index

Package BANINST1.fb_vendor_strings

This package contains the error messages for vendor API (FB_VENDOR_STRINGS)


Constants
MISSING_PIDM  
MISSING_EFF_DATE  
MISSING_USER_ID  
MISSING_COLLECT_TAX  
MISSING_EPROC_IND  
INVALID_PIDM  
INVALID_EFF_DATE  
INVALID_TERM_DATE  
INVALID_USER_ID  
INVALID_ITYP_CODE  
INVALID_ITYP_CODE2  
INVALID_DISC_CODE  
INVALID_1099_RPT_ID  
INVALID_IN_ST_IND  
INVALID_GROUPING_IND  
INVALID_CARRIER_IND  
INVALID_CONTACT  
INVALID_PHONE_AREA  
INVALID_PHONE_NUMBER  
INVALID_PHONE_EXT  
INVALID_ATYP_CODE  
INVALID_ADDR_SEQNO  
INVALID_FED_WHOLD_PCT  
INVALID_ST_WHOLD_PCT  
INVALID_COMBINED_FED_ST_FILER  
INVALID_COLLECT_TAX  
INVALID_COLLECT_TAX_CODE2  
INVALID_VEND_CHECK_PIDM  
INVALID_VEND_CHECK_ATYP_CODE  
INVALID_VEND_CHECK_ADDR_SEQNO  
INVALID_VEND_CHECK_ADDRESS  
INVALID_CURR_CODE  
INVALID_ENTITY_IND  
INVALID_PIDM_OWNER  
INVALID_PIDM_OWNER2  
INVALID_EPROC_IND  
INVALID_ADDRESS  
MISSING_PARENT  
P_DELETE_FAILED  
PK_NOT_FOUND  
RECORD_EXISTS  
P_DELETE_DISABLED  
INVALID_PO_RSN_CODE  
INVALID_PMT_RSN_CODE  
INVALID_1099_ATYP_CODE  
INVALID_1099_ADDR_SEQNO  
INVALID_TAX_FORM_STATUS  
INVALID_TAX_FORM_DATE  


MISSING_PIDM

MISSING_PIDM CONSTANT VARCHAR2 (80)
   := g$_nls.get ('FOKB_VENDOR_S0-0000', 'SQL',
                     'Missing mandatory value for %01%','FTVVEND_PIDM');

MISSING_EFF_DATE

MISSING_EFF_DATE CONSTANT VARCHAR2 (80)
   := g$_nls.get ('FOKB_VENDOR_S0-0001', 'SQL',
                        'Missing mandatory value for %01%','FTVVEND_EFF_DATE');

MISSING_USER_ID

MISSING_USER_ID CONSTANT VARCHAR2 (80)
   := g$_nls.get ('FOKB_VENDOR_S0-0002', 'SQL',
                        'Missing mandatory value for %01%','FTVVEND_USER_ID');

MISSING_COLLECT_TAX

MISSING_COLLECT_TAX CONSTANT VARCHAR2 (80)
   := g$_nls.get ('FOKB_VENDOR_S0-0003', 'SQL',
                        'Missing mandatory value for %01%','FTVVEND_COLLECT_TAX');

MISSING_EPROC_IND

MISSING_EPROC_IND CONSTANT VARCHAR2 (80)
   := g$_nls.get ('FOKB_VENDOR_S0-0004', 'SQL',
                        'Missing mandatory value for %01%','FTVVEND_EPROC_IND');

INVALID_PIDM

INVALID_PIDM CONSTANT VARCHAR2 (80)
   := g$_nls.get ('FOKB_VENDOR_S0-0005', 'SQL',
                     'Invalid value for %01%','FTVVEND_PIDM');

INVALID_EFF_DATE

INVALID_EFF_DATE CONSTANT VARCHAR2 (80)
   := g$_nls.get ('FOKB_VENDOR_S0-0006', 'SQL',
                     'Invalid value for %01%','FTVVEND_EFF_DATE');

INVALID_TERM_DATE

INVALID_TERM_DATE CONSTANT VARCHAR2 (80)
   := g$_nls.get ('FOKB_VENDOR_S0-0007', 'SQL',
                     'Invalid value for %01%','FTVVEND_TERM_DATE');

INVALID_USER_ID

INVALID_USER_ID CONSTANT VARCHAR2 (80)
   := g$_nls.get ('FOKB_VENDOR_S0-0008', 'SQL',
                     'Invalid value for %01%','FTVVEND_USER_ID');

INVALID_ITYP_CODE

INVALID_ITYP_CODE CONSTANT VARCHAR2 (80)
   := g$_nls.get ('FOKB_VENDOR_S0-0009', 'SQL',
                     'Invalid value for %01%','FTVVEND_ITYP_SEQ_CODE');

INVALID_ITYP_CODE2

INVALID_ITYP_CODE2 CONSTANT VARCHAR2 (80)
   := g$_nls.get ('FOKB_VENDOR_S0-0010', 'SQL',
                     'Missing %01% for %02%','FTVVEND_ITYP_SEQ_CODE','FTVVEND_1099_RPT_ID');

INVALID_DISC_CODE

INVALID_DISC_CODE CONSTANT VARCHAR2 (80)
   := g$_nls.get ('FOKB_VENDOR_S0-0011', 'SQL',
                     'Invalid value FOR %01%','FTVVEND_DISC_CODE');

INVALID_1099_RPT_ID

INVALID_1099_RPT_ID CONSTANT VARCHAR2 (80)
   := g$_nls.get ('FOKB_VENDOR_S0-0012', 'SQL',
                     'Invalid value FOR %01%','FTVVEND_1099_RPT_ID');

INVALID_IN_ST_IND

INVALID_IN_ST_IND CONSTANT VARCHAR2 (80)
   := g$_nls.get ('FOKB_VENDOR_S0-0013', 'SQL',
                     'Invalid value FOR %01%','FTVVEND_IN_ST_IND');

INVALID_GROUPING_IND

INVALID_GROUPING_IND CONSTANT VARCHAR2 (80)
   := g$_nls.get ('FOKB_VENDOR_S0-0014', 'SQL',
                     'Invalid value FOR %01%','FTVVEND_GROUPING_IND');

INVALID_CARRIER_IND

INVALID_CARRIER_IND CONSTANT VARCHAR2 (80)
   := g$_nls.get ('FOKB_VENDOR_S0-0015', 'SQL',
                     'Invalid value FOR %01%','FTVVEND_CARRIER_IND');

INVALID_CONTACT

INVALID_CONTACT CONSTANT VARCHAR2 (80)
   := g$_nls.get ('FOKB_VENDOR_S0-0016', 'SQL',
                     'Invalid value FOR %01%','FTVVEND_CONTACT');

INVALID_PHONE_AREA

INVALID_PHONE_AREA CONSTANT VARCHAR2 (80)
   := g$_nls.get ('FOKB_VENDOR_S0-0017', 'SQL',
                     'Invalid value FOR %01%','FTVVEND_PHONE_AREA');

INVALID_PHONE_NUMBER

INVALID_PHONE_NUMBER CONSTANT VARCHAR2 (80)
   := g$_nls.get ('FOKB_VENDOR_S0-0018', 'SQL',
                     'Invalid value FOR %01%','FTVVEND_PHONE_NUMBER');

INVALID_PHONE_EXT

INVALID_PHONE_EXT CONSTANT VARCHAR2 (80)
   := g$_nls.get ('FOKB_VENDOR_S0-0019', 'SQL',
                     'Invalid value FOR %01%','FTVVEND_PHONE_EXT');

INVALID_ATYP_CODE

INVALID_ATYP_CODE CONSTANT VARCHAR2 (80)
   := g$_nls.get ('FOKB_VENDOR_S0-0020', 'SQL',
                     'Invalid value FOR %01%','FTVVEND_ATYP_CODE');

INVALID_ADDR_SEQNO

INVALID_ADDR_SEQNO CONSTANT VARCHAR2 (80)
   := g$_nls.get ('FOKB_VENDOR_S0-0021', 'SQL',
                     'Invalid value FOR %01%','FTVVEND_ADDR_SEQNO');

INVALID_FED_WHOLD_PCT

INVALID_FED_WHOLD_PCT CONSTANT VARCHAR2 (80)
   := g$_nls.get ('FOKB_VENDOR_S0-0022', 'SQL',
                     'Invalid value FOR %01%','FTVVEND_FED_WHOLD_PCT');

INVALID_ST_WHOLD_PCT

INVALID_ST_WHOLD_PCT CONSTANT VARCHAR2 (80)
   := g$_nls.get ('FOKB_VENDOR_S0-0023', 'SQL',
                     'Invalid value FOR %01%','FTVVEND_ST_WHOLD_PCT');

INVALID_COMBINED_FED_ST_FILER

INVALID_COMBINED_FED_ST_FILER CONSTANT VARCHAR2 (80)
   := g$_nls.get ('FOKB_VENDOR_S0-0024', 'SQL',
                     'Invalid value FOR %01%','FTVVEND_COMBINED_FED_ST_FILER');

INVALID_COLLECT_TAX

INVALID_COLLECT_TAX CONSTANT VARCHAR2 (80)
   := g$_nls.get ('FOKB_VENDOR_S0-0025', 'SQL',
                     'Invalid value FOR %01%','FTVVEND_COLLECT_TAX');

INVALID_COLLECT_TAX_CODE2

INVALID_COLLECT_TAX_CODE2 CONSTANT VARCHAR2 (80)
   := g$_nls.get ('FOKB_VENDOR_S0-0026','SQL',
                   'Cannot withhold state for in state vendors');

INVALID_VEND_CHECK_PIDM

INVALID_VEND_CHECK_PIDM CONSTANT VARCHAR2 (80)
   := g$_nls.get ('FOKB_VENDOR_S0-0027', 'SQL',
                     'Invalid value for %01%','FTVVEND_VEND_CHECK_PIDM');

INVALID_VEND_CHECK_ATYP_CODE

INVALID_VEND_CHECK_ATYP_CODE CONSTANT VARCHAR2 (80)
   := g$_nls.get ('FOKB_VENDOR_S0-0028', 'SQL',
                     'Invalid value for %01%','FTVVEND_VEND_CHECK_ATYP_CODE');

INVALID_VEND_CHECK_ADDR_SEQNO

INVALID_VEND_CHECK_ADDR_SEQNO CONSTANT VARCHAR2 (80)
   := g$_nls.get ('FOKB_VENDOR_S0-0029', 'SQL',
                     'Invalid value for %01%','FTVVEND_VEND_CHECK_ADDR_SEQNO');

INVALID_VEND_CHECK_ADDRESS

INVALID_VEND_CHECK_ADDRESS CONSTANT VARCHAR2 (80)
   := g$_nls.get ('FOKB_VENDOR_S0-0030','SQL',
                   'Invalid address for %01%','FTVVEND_VEND_CHECK_PIDM');

INVALID_CURR_CODE

INVALID_CURR_CODE CONSTANT VARCHAR2 (80)
   := g$_nls.get ('FOKB_VENDOR_S0-0031', 'SQL',
                     'Invalid value for %01%','FTVVEND_CURR_CODE');

INVALID_ENTITY_IND

INVALID_ENTITY_IND CONSTANT VARCHAR2 (80)
   := g$_nls.get ('FOKB_VENDOR_S0-0032', 'SQL',
                     'Invalid value for %01%','FTVVEND_ENTITY_IND');

INVALID_PIDM_OWNER

INVALID_PIDM_OWNER CONSTANT VARCHAR2 (80)
   := g$_nls.get ('FOKB_VENDOR_S0-0033', 'SQL',
                     'Invalid value for %01%','FTVVEND_PIDM_OWNER');

INVALID_PIDM_OWNER2

INVALID_PIDM_OWNER2 CONSTANT VARCHAR2 (80)
   := g$_nls.get ('FOKB_VENDOR_S0-0034','SQL',
                   'Missing %01% for %02%','FTVVEND_1099_RPT_ID','FTVVEND_PIDM_OWNER');

INVALID_EPROC_IND

INVALID_EPROC_IND CONSTANT VARCHAR2 (80)
   := g$_nls.get ('FOKB_VENDOR_S0-0035', 'SQL',
                     'Invalid value for %01%','FTVVEND_EPROC_IND');

INVALID_ADDRESS

INVALID_ADDRESS CONSTANT VARCHAR2 (80)
   := g$_nls.get ('FOKB_VENDOR_S0-0036','SQL',
                   'Invalid value for %01%', 'FTVVEND_ADDRESS');

MISSING_PARENT

MISSING_PARENT   CONSTANT VARCHAR2 (80)
   := g$_nls.get ('FOKB_VENDOR_S0-0037', 'SQL', 'Required parent record not found  ');

P_DELETE_FAILED

P_DELETE_FAILED CONSTANT VARCHAR2 (80)
   := g$_nls.get ('FOKB_VENDOR_S0-0038', 'SQL', 'Cannot DELETE, RECORD does NOT exist ');

PK_NOT_FOUND

PK_NOT_FOUND CONSTANT VARCHAR2 (80)
   := g$_nls.get ('FOKB_VENDOR_S0-0039', 'SQL', 'Cannot find RECORD USING UNIQUE OR PRIMARY KEY ');

RECORD_EXISTS

RECORD_EXISTS CONSTANT VARCHAR2(80)
   := g$_nls.get ('FOKB_VENDOR_S0-0040','SQL','Cannot CREATE, RECORD already EXISTS');

P_DELETE_DISABLED

P_DELETE_DISABLED CONSTANT VARCHAR2 (80)
   := g$_nls.get ('FOKB_VENDOR_S0-0041','SQL','Vendor once created cannot be deleted ');

INVALID_PO_RSN_CODE

INVALID_PO_RSN_CODE CONSTANT VARCHAR2(80)
   := g$_nls.get('FOKB_VENDOR_S0-0042','SQL','Invalid value for %01%', 'FTVVEND_PO_HOLD_RSN_CODE');

INVALID_PMT_RSN_CODE

INVALID_PMT_RSN_CODE CONSTANT VARCHAR2(80)
   := g$_nls.get('FOKB_VENDOR_S0-0043','SQL','Invalid value for %01%', 'FTVVEND_PMT_HOLD_RSN_CODE');

INVALID_1099_ATYP_CODE

INVALID_1099_ATYP_CODE CONSTANT VARCHAR2 (80)
   := g$_nls.get ('FOKB_VENDOR_S0-0044', 'SQL',
                     'Invalid value FOR %01%','FTVVEND_1099_ATYP_CODE');

INVALID_1099_ADDR_SEQNO

INVALID_1099_ADDR_SEQNO CONSTANT VARCHAR2 (80)
   := g$_nls.get ('FOKB_VENDOR_S0-0045', 'SQL',
                     'Invalid value FOR %01%','FTVVEND_1099_ADDR_SEQNO');

INVALID_TAX_FORM_STATUS

INVALID_TAX_FORM_STATUS CONSTANT VARCHAR2 (80)
   := g$_nls.get ('FOKB_VENDOR_S0-0046', 'SQL',
                     'Invalid value FOR %01%','FTVVEND_TAX_FORM_STATUS');

INVALID_TAX_FORM_DATE

INVALID_TAX_FORM_DATE CONSTANT VARCHAR2 (80)
   := g$_nls.get ('FOKB_VENDOR_S0-0047', 'SQL',
                     'Missing %01% for %02%','FTVVEND_TAX_FORM_DATE','FTVVEND_TAX_FORM_STATUS');