eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.HZ_IMP_LOAD_WRAPPER dependencies on HZ_IMP_ERRORS

Line 151: select int_row_id, table_name, hz_imp_errors_s.nextval

147: l_table_name T_TABLE_NAME;
148: --l_debug_prefix VARCHAR2(30):= '';
149:
150: CURSOR dup_rel (p_batch_id NUMBER, p_batch_mode_flag VARCHAR2) IS
151: select int_row_id, table_name, hz_imp_errors_s.nextval
152: from (
153: select /*+ ordered parallel(r) use_hash(r) */
154: table_name, int_row_id, lead(sd,1) over (partition by
155: decode(t.direction_code, 'C', obj_id, sub_id),

Line 201: select int_row_id, hz_imp_errors_s.NextVal from (

197: /* Combination of party_site_id and site_use_type is unique.
198: Order by 's.primary_flag desc' such that primary address uses will not
199: be marked as duplicate and leave a non-primary one there */
200: CURSOR dup_addr_uses (p_batch_id NUMBER, p_batch_mode_flag VARCHAR2) IS
201: select int_row_id, hz_imp_errors_s.NextVal from (
202: select /*+ parallel(s) */ party_site_use_id suid, party_site_id sid,
203: site_use_type sut, int_row_id, lead(party_site_id, 1) over(
204: partition by site_use_type order by primary_flag desc) n_sid
205: from hz_imp_addressuses_sg s

Line 217: select int_row_id, decode(allow_multi_assign_flag, 'N', 'M', 'E'), hz_imp_errors_s.NextVal from (

213: /* There should not be overlapping assignment for the same
214: party and same classification (class category / class code)
215: within the same content source type */
216: CURSOR dup_code_assignments (p_batch_id NUMBER, p_batch_mode_flag VARCHAR2) IS
217: select int_row_id, decode(allow_multi_assign_flag, 'N', 'M', 'E'), hz_imp_errors_s.NextVal from (
218: select /*+ parallel(s) */
219: s.int_row_id, s.party_id, s.party_orig_system_reference,
220: s.primary_flag, s.start_date_active, s.end_date_active,
221: lead(s.start_date_active, 1) over(partition by s.party_id,

Line 460: insert into hz_imp_errors (

456:
457: /* Records in hz_tmp_errors for global validations will be ignored when
458: copy from tmp error to permanent error table. Insert into tmp errors table
459: for keeping error count. */
460: insert into hz_imp_errors (
461: error_id, batch_id, request_id, interface_table_name, message_name
462: )
463: select error_id, batch_id, request_id, interface_table_name,
464: decode(interface_table_name, 'HZ_IMP_RELSHIPS_INT', 'HZ_IMP_DUP_REL_IN_INT_ERROR',

Line 565: execute immediate 'alter sequence ' || l_schema || '.hz_imp_errors_s cache 20000';

561: execute immediate 'alter sequence ' || l_schema || '.hz_contact_points_s cache 20000';
562: execute immediate 'alter sequence ' || l_schema || '.hz_credit_ratings_s cache 20000';
563: execute immediate 'alter sequence ' || l_schema || '.hz_financial_numbers_s cache 20000';
564: execute immediate 'alter sequence ' || l_schema || '.hz_financial_reports_s cache 20000';
565: execute immediate 'alter sequence ' || l_schema || '.hz_imp_errors_s cache 20000';
566: execute immediate 'alter sequence hr.hr_locations_s cache 20000';
567: execute immediate 'alter sequence ' || l_schema || '.hz_location_profiles_s cache 20000';
568: execute immediate 'alter sequence ' || l_schema || '.hz_organization_profiles_s cache 20000';
569: execute immediate 'alter sequence ' || l_schema || '.hz_org_contacts_s cache 20000';

Line 602: execute immediate 'alter sequence ' || l_schema || '.hz_imp_errors_s cache 20';

598: execute immediate 'alter sequence ' || l_schema || '.hz_contact_points_s cache 20';
599: execute immediate 'alter sequence ' || l_schema || '.hz_credit_ratings_s cache 20';
600: execute immediate 'alter sequence ' || l_schema || '.hz_financial_numbers_s cache 20';
601: execute immediate 'alter sequence ' || l_schema || '.hz_financial_reports_s cache 20';
602: execute immediate 'alter sequence ' || l_schema || '.hz_imp_errors_s cache 20';
603: execute immediate 'alter sequence hr.hr_locations_s cache 20';
604: execute immediate 'alter sequence ' || l_schema || '.hz_location_profiles_s cache 20';
605: execute immediate 'alter sequence ' || l_schema || '.hz_organization_profiles_s cache 20';
606: execute immediate 'alter sequence ' || l_schema || '.hz_org_contacts_s cache 20';

Line 1543: into hz_imp_errors (

1539:
1540: /* Populate permanent errors tables from tmp errors table */
1541: insert all
1542: when (E1_FLAG is null) then
1543: into hz_imp_errors (
1544: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
1545: values (
1546: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',
1547: 'HZ_IMP_INVALD_ADDR_ASSIGN')

Line 1549: into hz_imp_errors (

1545: values (
1546: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',
1547: 'HZ_IMP_INVALD_ADDR_ASSIGN')
1548: when (E2_FLAG is null) then
1549: into hz_imp_errors (
1550: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1551: token1_name, token1_value)
1552: values (
1553: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',

Line 1556: into hz_imp_errors (

1552: values (
1553: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',
1554: 'HZ_API_MISSING_COLUMN', 'COLUMN', 'ADDRESS1')
1555: when (E3_FLAG is null) then
1556: into hz_imp_errors (
1557: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1558: token1_name, token1_value)
1559: values (
1560: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',

Line 1563: into hz_imp_errors (

1559: values (
1560: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',
1561: 'HZ_API_MISSING_COLUMN', 'COLUMN', 'COUNTRY')
1562: when (E4_FLAG is null) then
1563: into hz_imp_errors (
1564: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1565: token1_name, token1_value, token2_name, token2_value, token3_name,
1566: token3_value)
1567: values (

Line 1572: into hz_imp_errors (

1568: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',
1569: 'HZ_API_INVALID_FK', 'FK', 'LANGUAGE', 'COLUMN', 'LANGUAGE_CODE',
1570: 'TABLE', 'FND_LANGUAGES')
1571: when (E5_FLAG is null) then
1572: into hz_imp_errors (
1573: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1574: token1_name, token1_value, token2_name, token2_value, token3_name,
1575: token3_value)
1576: values (

Line 1581: into hz_imp_errors (

1577: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',
1578: 'HZ_API_INVALID_FK', 'FK', 'TIMEZONE_CODE', 'COLUMN',
1579: 'TIMEZONE_CODE', 'TABLE', 'FND_TIMEZONES_B')
1580: when (E6_FLAG is null) then
1581: into hz_imp_errors (
1582: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1583: token1_name, token1_value)
1584: values (
1585: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',

Line 1588: into hz_imp_errors (

1584: values (
1585: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',
1586: 'AR_RAPI_DESC_FLEX_INVALID', 'DEF_NAME', 'HZ_PARTY_SITES')
1587: when (E7_FLAG is null) then
1588: into hz_imp_errors (
1589: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
1590: values (
1591: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',
1592: 'HZ_IMP_ADDR_NO_CORRECTION')

Line 1594: into hz_imp_errors (

1590: values (
1591: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',
1592: 'HZ_IMP_ADDR_NO_CORRECTION')
1593: when (E8_FLAG is null) then
1594: into hz_imp_errors (
1595: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1596: token1_name, token1_value, token2_name, token2_value, token3_name,
1597: token3_value)
1598: values (

Line 1603: into hz_imp_errors (

1599: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',
1600: 'HZ_DSS_SECURITY_FAIL', 'USER_NAME', USER_NAME,
1601: 'OPER_NAME', 'UPDATE', 'OBJECT_NAME', 'HZ_PARTY_SITES')
1602: when (DUP_VAL_IDX_EXCEP_FLAG = 'A') then
1603: into hz_imp_errors (
1604: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1605: token1_name, token1_value, token2_name,
1606: token2_value)
1607: values (

Line 1612: into hz_imp_errors (

1608: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',
1609: 'HZ_IMP_DUP_VAL', 'INDEX', 'HZ_PARTY_SITES_U1', 'ENTITY',
1610: 'HZ_PARTY_SITES')
1611: when (DUP_VAL_IDX_EXCEP_FLAG = 'B') then
1612: into hz_imp_errors (
1613: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1614: token1_name, token1_value, token2_name, token2_value)
1615: values (
1616: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',

Line 1620: into hz_imp_errors (

1616: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',
1617: 'HZ_IMP_DUP_VAL', 'INDEX', 'HZ_PARTY_SITES_U2', 'ENTITY',
1618: 'HZ_PARTY_SITES')
1619: when (DUP_VAL_IDX_EXCEP_FLAG = 'C') then
1620: into hz_imp_errors (
1621: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1622: token1_name, token1_value, token2_name, token2_value)
1623: values (
1624: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',

Line 1627: into hz_imp_errors (

1623: values (
1624: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',
1625: 'HZ_IMP_DUP_VAL', 'INDEX', 'HZ_LOCATIONS_U1', 'ENTITY', 'HZ_LOCATIONS')
1626: when (ACTION_MISMATCH_FLAG is null) then
1627: into hz_imp_errors (
1628: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
1629: values (
1630: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',
1631: 'HZ_IMP_ACTION_MISMATCH')

Line 1633: into hz_imp_errors (

1629: values (
1630: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',
1631: 'HZ_IMP_ACTION_MISMATCH')
1632: when (MISSING_PARENT_FLAG is null) then
1633: into hz_imp_errors (
1634: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
1635: values (
1636: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',
1637: 'HZ_IMP_PARENT_PARTY_NOT_FOUND')

Line 1639: into hz_imp_errors (

1635: values (
1636: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',
1637: 'HZ_IMP_PARENT_PARTY_NOT_FOUND')
1638: when (E9_FLAG is null) then
1639: into hz_imp_errors (
1640: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
1641: values (
1642: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',
1643: 'HZ_NOTALLOW_UPDATE_THIRD_PARTY')

Line 1645: into hz_imp_errors (

1641: values (
1642: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',
1643: 'HZ_NOTALLOW_UPDATE_THIRD_PARTY')
1644: when (E10_FLAG is null) then
1645: into hz_imp_errors (
1646: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
1647: values (
1648: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',
1649: 'HZ_IMP_PARENT_PARTY_NOT_FOUND')

Line 1651: into hz_imp_errors (

1647: values (
1648: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',
1649: 'HZ_IMP_PARENT_PARTY_NOT_FOUND')
1650: when (E11_FLAG is null) then
1651: into hz_imp_errors (
1652: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1653: token1_name, token1_value, token2_name, token2_value)
1654: values (
1655: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',

Line 1669: into hz_imp_errors (

1665: and e.interface_table_name = 'HZ_IMP_ADDRESSES_INT';
1666:
1667: insert all
1668: when (E1_FLAG is null) then
1669: into hz_imp_errors (
1670: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1671: token1_name, token1_value, token2_name, token2_value)
1672: values (
1673: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',

Line 1677: into hz_imp_errors (

1673: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',
1674: 'HZ_API_DATE_GREATER', 'DATE2', 'REPORT_END_DATE', 'DATE1',
1675: 'REPORT_START_DATE')
1676: when (E2_FLAG is null) then
1677: into hz_imp_errors (
1678: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1679: token1_name, token1_value, token2_name, token2_value)
1680: values (
1681: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',

Line 1684: into hz_imp_errors (

1680: values (
1681: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',
1682: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'AUDIT_IND', 'LOOKUP_TYPE', 'YES/NO')
1683: when (E3_FLAG is null) then
1684: into hz_imp_errors (
1685: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1686: token1_name, token1_value, token2_name, token2_value)
1687: values (
1688: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',

Line 1692: into hz_imp_errors (

1688: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',
1689: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'CONSOLIDATED_IND',
1690: 'LOOKUP_TYPE', 'YES/NO')
1691: when (E4_FLAG is null) then
1692: into hz_imp_errors (
1693: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1694: token1_name, token1_value, token2_name, token2_value)
1695: values (
1696: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',

Line 1700: into hz_imp_errors (

1696: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',
1697: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'ESTIMATED_IND', 'LOOKUP_TYPE',
1698: 'YES/NO')
1699: when (E5_FLAG is null) then
1700: into hz_imp_errors (
1701: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1702: token1_name, token1_value, token2_name, token2_value)
1703: values (
1704: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',

Line 1707: into hz_imp_errors (

1703: values (
1704: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',
1705: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'FINAL_IND', 'LOOKUP_TYPE', 'YES/NO')
1706: when (E6_FLAG is null) then
1707: into hz_imp_errors (
1708: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1709: token1_name, token1_value, token2_name, token2_value)
1710: values (
1711: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',

Line 1714: into hz_imp_errors (

1710: values (
1711: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',
1712: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'FISCAL_IND', 'LOOKUP_TYPE', 'YES/NO')
1713: when (E7_FLAG is null) then
1714: into hz_imp_errors (
1715: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1716: token1_name, token1_value, token2_name, token2_value)
1717: values (
1718: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',

Line 1722: into hz_imp_errors (

1718: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',
1719: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'FORECAST_IND', 'LOOKUP_TYPE',
1720: 'YES/NO')
1721: when (E8_FLAG is null) then
1722: into hz_imp_errors (
1723: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1724: token1_name, token1_value, token2_name, token2_value)
1725: values (
1726: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',

Line 1730: into hz_imp_errors (

1726: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',
1727: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'OPENING_IND', 'LOOKUP_TYPE',
1728: 'YES/NO')
1729: when (E9_FLAG is null) then
1730: into hz_imp_errors (
1731: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1732: token1_name, token1_value, token2_name, token2_value)
1733: values (
1734: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',

Line 1738: into hz_imp_errors (

1734: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',
1735: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'PROFORMA_IND', 'LOOKUP_TYPE',
1736: 'YES/NO')
1737: when (E10_FLAG is null) then
1738: into hz_imp_errors (
1739: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1740: token1_name, token1_value, token2_name, token2_value)
1741: values (
1742: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',

Line 1746: into hz_imp_errors (

1742: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',
1743: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'QUALIFIED_IND', 'LOOKUP_TYPE',
1744: 'YES/NO')
1745: when (E11_FLAG is null) then
1746: into hz_imp_errors (
1747: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1748: token1_name, token1_value, token2_name, token2_value)
1749: values (
1750: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',

Line 1754: into hz_imp_errors (

1750: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',
1751: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'RESTATED_IND', 'LOOKUP_TYPE',
1752: 'YES/NO')
1753: when (E12_FLAG is null) then
1754: into hz_imp_errors (
1755: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1756: token1_name, token1_value, token2_name, token2_value)
1757: values (
1758: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',

Line 1762: into hz_imp_errors (

1758: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',
1759: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'SIGNED_BY_PRINCIPALS_IND',
1760: 'LOOKUP_TYPE', 'YES/NO')
1761: when (E13_FLAG is null) then
1762: into hz_imp_errors (
1763: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1764: token1_name, token1_value, token2_name, token2_value)
1765: values (
1766: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',

Line 1771: into hz_imp_errors (

1767: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'TRIAL_BALANCE_IND',
1768: 'LOOKUP_TYPE', 'YES/NO')
1769:
1770: when (E14_FLAG is null) then
1771: into hz_imp_errors (
1772: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1773: token1_name, token1_value, token2_name, token2_value)
1774: values (
1775: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',

Line 1779: into hz_imp_errors (

1775: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',
1776: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'UNBALANCED_IND', 'LOOKUP_TYPE',
1777: 'YES/NO')
1778: when (E15_FLAG is null) then
1779: into hz_imp_errors (
1780: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1781: token1_name, token1_value, token2_name, token2_value)
1782: values (
1783: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',

Line 1787: into hz_imp_errors (

1783: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',
1784: 'HZ_API_INVALID_COMBINATION2', 'COLUMN1', 'issued_period', 'COLUMN2',
1785: 'report_start_date')
1786: when (E16_FLAG is null) then
1787: into hz_imp_errors (
1788: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1789: token1_name, token1_value, token2_name, token2_value)
1790: values (
1791: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',

Line 1795: into hz_imp_errors (

1791: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',
1792: 'HZ_API_INVALID_COMBINATION3', 'COLUMN1', 'report_start_date', 'COLUMN2',
1793: 'report_end_date')
1794: when (E17_FLAG is null) then
1795: into hz_imp_errors (
1796: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1797: token1_name, token1_value, token2_name, token2_value)
1798: values (
1799: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',

Line 1803: into hz_imp_errors (

1799: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',
1800: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'CREATED_BY_MODULE', 'LOOKUP_TYPE',
1801: 'HZ_CREATED_BY_MODULES')
1802: when (DUP_VAL_IDX_EXCEP_FLAG = 'A') then
1803: into hz_imp_errors (
1804: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1805: token1_name, token1_value, token2_name, token2_value)
1806: values (
1807: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',

Line 1811: into hz_imp_errors (

1807: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',
1808: 'HZ_IMP_DUP_VAL', 'INDEX', 'HZ_FINANCIAL_REPORTS_U1', 'ENTITY',
1809: 'HZ_FINANCIAL_REPORTS')
1810: when (DUP_VAL_IDX_EXCEP_FLAG = 'B') then
1811: into hz_imp_errors (
1812: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1813: token1_name, token1_value, token2_name, token2_value)
1814: values (
1815: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',

Line 1819: into hz_imp_errors (

1815: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',
1816: 'HZ_IMP_DUP_VAL', 'INDEX', 'HZ_FINANCIAL_REPORTS_U2', 'ENTITY',
1817: 'HZ_FINANCIAL_REPORTS')
1818: when (ACTION_MISMATCH_FLAG is null) then
1819: into hz_imp_errors (
1820: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
1821: values (
1822: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',
1823: 'HZ_IMP_ACTION_MISMATCH')

Line 1825: into hz_imp_errors (

1821: values (
1822: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',
1823: 'HZ_IMP_ACTION_MISMATCH')
1824: when (MISSING_PARENT_FLAG is null) then
1825: into hz_imp_errors (
1826: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
1827: values (
1828: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINREPORTS_INT',
1829: 'HZ_IMP_PARENT_PARTY_NOT_FOUND')

Line 1846: into hz_imp_errors (

1842: and e.interface_table_name = 'HZ_IMP_FINREPORTS_INT';
1843:
1844: insert all
1845: when (E1_FLAG is null) then
1846: into hz_imp_errors (
1847: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1848: token1_name, token1_value, token2_name, token2_value)
1849: values (
1850: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINNUMBERS_INT',

Line 1854: into hz_imp_errors (

1850: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINNUMBERS_INT',
1851: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'FINANCIAL_NUMBER_NAME',
1852: 'LOOKUP_TYPE', 'FIN_NUM_NAME')
1853: when (E2_FLAG is null) then
1854: into hz_imp_errors (
1855: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1856: token1_name, token1_value, token2_name, token2_value)
1857: values (
1858: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINNUMBERS_INT',

Line 1862: into hz_imp_errors (

1858: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINNUMBERS_INT',
1859: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'CREATED_BY_MODULE', 'LOOKUP_TYPE',
1860: 'HZ_CREATED_BY_MODULES')
1861: when (DUP_VAL_IDX_EXCEP_FLAG = 'A') then
1862: into hz_imp_errors (
1863: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1864: token1_name, token1_value, token2_name, token2_value)
1865: values (
1866: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINNUMBERS_INT',

Line 1870: into hz_imp_errors (

1866: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINNUMBERS_INT',
1867: 'HZ_IMP_DUP_VAL', 'INDEX', 'HZ_FINANCIAL_NUMBERS_U1', 'ENTITY',
1868: 'HZ_FINANCIAL_NUMBERS')
1869: when (DUP_VAL_IDX_EXCEP_FLAG = 'B') then
1870: into hz_imp_errors (
1871: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1872: token1_name, token1_value, token2_name, token2_value)
1873: values (
1874: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINNUMBERS_INT',

Line 1878: into hz_imp_errors (

1874: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINNUMBERS_INT',
1875: 'HZ_IMP_DUP_VAL', 'INDEX', 'HZ_FINANCIAL_NUMBERS_U2', 'ENTITY',
1876: 'HZ_FINANCIAL_NUMBERS')
1877: when (ACTION_MISMATCH_FLAG is null) then
1878: into hz_imp_errors (
1879: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
1880: values (
1881: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINNUMBERS_INT',
1882: 'HZ_IMP_ACTION_MISMATCH')

Line 1884: into hz_imp_errors (

1880: values (
1881: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINNUMBERS_INT',
1882: 'HZ_IMP_ACTION_MISMATCH')
1883: when (MISSING_PARENT_FLAG is null) then
1884: into hz_imp_errors (
1885: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
1886: values (
1887: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINNUMBERS_INT',
1888: 'HZ_IMP_FINREPORT_NOT_FOUND')

Line 1898: into hz_imp_errors (

1894: and e.interface_table_name = 'HZ_IMP_FINNUMBERS_INT';
1895:
1896: insert all
1897: when (E1_FLAG is null) then
1898: into hz_imp_errors (
1899: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1900: token1_name, token1_value, token2_name, token2_value)
1901: values (
1902: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',

Line 1906: into hz_imp_errors (

1902: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',
1903: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'FISCAL_YEAREND_MONTH',
1904: 'LOOKUP_TYPE', 'MONTH')
1905: when (E2_FLAG is null) then
1906: into hz_imp_errors (
1907: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1908: token1_name, token1_value, token2_name, token2_value)
1909: values (
1910: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',

Line 1914: into hz_imp_errors (

1910: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',
1911: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'LEGAL_STATUS', 'LOOKUP_TYPE',
1912: 'LEGAL_STATUS')
1913: when (E3_FLAG is null) then
1914: into hz_imp_errors (
1915: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1916: token1_name, token1_value, token2_name, token2_value)
1917: values (
1918: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',

Line 1922: into hz_imp_errors (

1918: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',
1919: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'LOCAL_BUS_IDEN_TYPE',
1920: 'LOOKUP_TYPE', 'LOCAL_BUS_IDEN_TYPE')
1921: when (E4_FLAG is null) then
1922: into hz_imp_errors (
1923: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1924: token1_name, token1_value, token2_name, token2_value)
1925: values (
1926: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',

Line 1930: into hz_imp_errors (

1926: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',
1927: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'REGISTRATION_TYPE',
1928: 'LOOKUP_TYPE', 'REGISTRATION_TYPE')
1929: when (E5_FLAG is null) then
1930: into hz_imp_errors (
1931: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1932: token1_name, token1_value, token2_name, token2_value)
1933: values (
1934: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',

Line 1938: into hz_imp_errors (

1934: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',
1935: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'HQ_BRANCH_IND', 'LOOKUP_TYPE',
1936: 'HQ_BRANCH_IND')
1937: when (E6_FLAG is null) then
1938: into hz_imp_errors (
1939: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1940: token1_name, token1_value, token2_name, token2_value)
1941: values (
1942: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',

Line 1946: into hz_imp_errors (

1942: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',
1943: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'MINORITY_OWNED_IND',
1944: 'LOOKUP_TYPE', 'YES/NO')
1945: when (E7_FLAG is null) then
1946: into hz_imp_errors (
1947: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1948: token1_name, token1_value, token2_name, token2_value)
1949: values (
1950: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',

Line 1954: into hz_imp_errors (

1950: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',
1951: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'GSA_INDICATOR_FLAG', 'LOOKUP_TYPE',
1952: 'YES/NO')
1953: when (E8_FLAG is null) then
1954: into hz_imp_errors (
1955: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1956: token1_name, token1_value, token2_name, token2_value)
1957: values (
1958: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',

Line 1961: into hz_imp_errors (

1957: values (
1958: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',
1959: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'IMPORT_IND', 'LOOKUP_TYPE', 'YES/NO')
1960: when (E9_FLAG is null) then
1961: into hz_imp_errors (
1962: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1963: token1_name, token1_value, token2_name, token2_value)
1964: values (
1965: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',

Line 1968: into hz_imp_errors (

1964: values (
1965: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',
1966: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'EXPORT_IND', 'LOOKUP_TYPE', 'YES/NO')
1967: when (E10_FLAG is null) then
1968: into hz_imp_errors (
1969: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1970: token1_name, token1_value, token2_name, token2_value)
1971: values (
1972: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',

Line 1976: into hz_imp_errors (

1972: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',
1973: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'BRANCH_FLAG', 'LOOKUP_TYPE',
1974: 'YES/NO')
1975: when (E11_FLAG is null) then
1976: into hz_imp_errors (
1977: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1978: token1_name, token1_value, token2_name, token2_value)
1979: values (
1980: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',

Line 1984: into hz_imp_errors (

1980: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',
1981: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'DISADV_8A_IND', 'LOOKUP_TYPE',
1982: 'YES/NO')
1983: when (E12_FLAG is null) then
1984: into hz_imp_errors (
1985: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1986: token1_name, token1_value, token2_name, token2_value)
1987: values (
1988: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',

Line 1992: into hz_imp_errors (

1988: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',
1989: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'LABOR_SURPLUS_IND',
1990: 'LOOKUP_TYPE', 'YES/NO')
1991: when (E13_FLAG is null) then
1992: into hz_imp_errors (
1993: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1994: token1_name, token1_value, token2_name, token2_value)
1995: values (
1996: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',

Line 1999: into hz_imp_errors (

1995: values (
1996: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',
1997: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'OOB_IND', 'LOOKUP_TYPE', 'YES/NO')
1998: when (E14_FLAG is null) then
1999: into hz_imp_errors (
2000: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2001: token1_name, token1_value, token2_name, token2_value)
2002: values (
2003: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',

Line 2007: into hz_imp_errors (

2003: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',
2004: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'PARENT_SUB_IND', 'LOOKUP_TYPE',
2005: 'YES/NO')
2006: when (E15_FLAG is null) then
2007: into hz_imp_errors (
2008: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2009: token1_name, token1_value, token2_name, token2_value)
2010: values (
2011: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',

Line 2015: into hz_imp_errors (

2011: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',
2012: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'PUBLIC_PRIVATE_OWNERSHIP_FLAG',
2013: 'LOOKUP_TYPE', 'YES/NO')
2014: when (E16_FLAG is null) then
2015: into hz_imp_errors (
2016: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2017: token1_name, token1_value, token2_name, token2_value)
2018: values (
2019: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',

Line 2023: into hz_imp_errors (

2019: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',
2020: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'SMALL_BUS_IND', 'LOOKUP_TYPE',
2021: 'YES/NO')
2022: when (E17_FLAG is null) then
2023: into hz_imp_errors (
2024: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2025: token1_name, token1_value, token2_name, token2_value)
2026: values (
2027: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',

Line 2031: into hz_imp_errors (

2027: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',
2028: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'TOTAL_EMP_EST_IND',
2029: 'LOOKUP_TYPE', 'TOTAL_EMP_EST_IND')
2030: when (E18_FLAG is null) then
2031: into hz_imp_errors (
2032: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2033: token1_name, token1_value, token2_name, token2_value)
2034: values (
2035: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',

Line 2039: into hz_imp_errors (

2035: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',
2036: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'TOTAL_EMP_MIN_IND',
2037: 'LOOKUP_TYPE', 'TOTAL_EMP_MIN_IND')
2038: when (E19_FLAG is null) then
2039: into hz_imp_errors (
2040: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2041: token1_name, token1_value, token2_name, token2_value)
2042: values (
2043: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',

Line 2047: into hz_imp_errors (

2043: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',
2044: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'TOTAL_EMPLOYEES_IND', 'LOOKUP_TYPE',
2045: 'TOTAL_EMPLOYEES_INDICATOR')
2046: when (E20_FLAG is null) then
2047: into hz_imp_errors (
2048: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2049: token1_name, token1_value, token2_name, token2_value)
2050: values (
2051: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',

Line 2055: into hz_imp_errors (

2051: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',
2052: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'WOMAN_OWNED_IND', 'LOOKUP_TYPE',
2053: 'YES/NO')
2054: when (E21_FLAG is null) then
2055: into hz_imp_errors (
2056: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2057: token1_name, token1_value, token2_name, token2_value)
2058: values (
2059: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',

Line 2063: into hz_imp_errors (

2059: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',
2060: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'EMP_AT_PRIMARY_ADR_EST_IND',
2061: 'LOOKUP_TYPE', 'EMP_AT_PRIMARY_ADR_EST_IND')
2062: when (E22_FLAG is null) then
2063: into hz_imp_errors (
2064: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2065: token1_name, token1_value, token2_name, token2_value)
2066: values (
2067: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',

Line 2071: into hz_imp_errors (

2067: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',
2068: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'EMP_AT_PRIMARY_ADR_MIN_IND',
2069: 'LOOKUP_TYPE', 'EMP_AT_PRIMARY_ADR_MIN_IND')
2070: when (E23_FLAG is null) then
2071: into hz_imp_errors (
2072: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2073: token1_name, token1_value, token2_name, token2_value)
2074: values (
2075: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',

Line 2079: into hz_imp_errors (

2075: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',
2076: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'MARITAL_STATUS', 'LOOKUP_TYPE',
2077: 'MARITAL_STATUS')
2078: when (E24_FLAG is null) then
2079: into hz_imp_errors (
2080: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2081: token1_name, token1_value, token2_name, token2_value)
2082: values (
2083: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',

Line 2087: into hz_imp_errors (

2083: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',
2084: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'PERSON_PRE_NAME_ADJUNCT',
2085: 'LOOKUP_TYPE', 'CONTACT_TITLE')
2086: when (E25_FLAG is null) then
2087: into hz_imp_errors (
2088: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
2089: values (
2090: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',
2091: 'HZ_IMP_DECEASED_FLAG_ERROR')

Line 2093: into hz_imp_errors (

2089: values (
2090: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',
2091: 'HZ_IMP_DECEASED_FLAG_ERROR')
2092: when (E26_FLAG is null) then
2093: into hz_imp_errors (
2094: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2095: token1_name, token1_value, token2_name, token2_value)
2096: values (
2097: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',

Line 2101: into hz_imp_errors (

2097: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',
2098: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'HEAD_OF_HOUSEHOLD_FLAG',
2099: 'LOOKUP_TYPE', 'YES/NO')
2100: when (E27_FLAG is null) then
2101: into hz_imp_errors (
2102: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2103: token1_name, token1_value, token2_name, token2_value)
2104: values (
2105: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',

Line 2108: into hz_imp_errors (

2104: values (
2105: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',
2106: 'HZ_API_DATE_GREATER', 'DATE2', 'SYSDATE', 'DATE1', 'DATE_OF_BIRTH')
2107: when (E28_FLAG is null) then
2108: into hz_imp_errors (
2109: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2110: token1_name, token1_value, token2_name, token2_value)
2111: values (
2112: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',

Line 2115: into hz_imp_errors (

2111: values (
2112: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',
2113: 'HZ_API_DATE_GREATER', 'DATE2', 'SYSDATE', 'DATE1', 'DATE_OF_DEATH')
2114: when (E29_FLAG is null) then
2115: into hz_imp_errors (
2116: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2117: token1_name, token1_value, token2_name, token2_value)
2118: values (
2119: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',

Line 2122: into hz_imp_errors (

2118: values (
2119: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',
2120: 'HZ_API_DATE_GREATER', 'DATE2', 'DATE_OF_DEATH', 'DATE1', 'DATE_OF_BIRTH')
2121: when (E30_FLAG is null) then
2122: into hz_imp_errors (
2123: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
2124: values (
2125: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',
2126: 'HZ_IMP_PARTY_TYPE_ERROR')

Line 2128: into hz_imp_errors (

2124: values (
2125: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',
2126: 'HZ_IMP_PARTY_TYPE_ERROR')
2127: when (E31_FLAG is null) then
2128: into hz_imp_errors (
2129: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2130: token1_name, token1_value, token2_name, token2_value)
2131: values (
2132: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',

Line 2136: into hz_imp_errors (

2132: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',
2133: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'RENT_OWN_IND', 'LOOKUP_TYPE',
2134: 'OWN_RENT_IND')
2135: when (E32_FLAG is null) then
2136: into hz_imp_errors (
2137: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2138: token1_name, token1_value)
2139: values (
2140: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',

Line 2143: into hz_imp_errors (

2139: values (
2140: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',
2141: 'AR_RAPI_DESC_FLEX_INVALID', 'DFF_NAME', 'HZ_PARTIES')
2142: when (E33_FLAG is null) then
2143: into hz_imp_errors (
2144: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
2145: values (
2146: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',
2147: 'HZ_IMP_PARTY_NAME_ERROR')

Line 2149: into hz_imp_errors (

2145: values (
2146: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',
2147: 'HZ_IMP_PARTY_NAME_ERROR')
2148: when (E34_FLAG='P') then
2149: into hz_imp_errors (
2150: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2151: token1_name, token1_value)
2152: values (
2153: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',

Line 2156: into hz_imp_errors (

2152: values (
2153: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',
2154: 'HZ_DSS_NO_UPDATE_PRIVILEGE', 'ENTITY_NAME', l_dss_person_err)
2155: when (E34_FLAG='O') then
2156: into hz_imp_errors (
2157: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2158: token1_name, token1_value)
2159: values (
2160: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',

Line 2163: into hz_imp_errors (

2159: values (
2160: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',
2161: 'HZ_DSS_NO_UPDATE_PRIVILEGE', 'ENTITY_NAME', l_dss_org_err)
2162: when (E34_FLAG is null) then
2163: into hz_imp_errors (
2164: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2165: token1_name, token1_value)
2166: values (
2167: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',

Line 2170: into hz_imp_errors (

2166: values (
2167: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',
2168: 'HZ_DSS_NO_UPDATE_PRIVILEGE', 'ENTITY_NAME', l_dss_others_err)
2169: when (E35_FLAG is null) then
2170: into hz_imp_errors (
2171: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2172: token1_name, token1_value, token2_name, token2_value)
2173: values (
2174: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',

Line 2178: into hz_imp_errors (

2174: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',
2175: 'HZ_API_NO_RECORD', 'RECORD', 'PARTY', 'VALUE', ' ')
2176: -- Bug 4310257
2177: when (E36_FLAG is null) then
2178: into hz_imp_errors (
2179: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2180: token1_name, token1_value, token2_name, token2_value)
2181: values (
2182: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',

Line 2186: into hz_imp_errors (

2182: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',
2183: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'GENDER', 'LOOKUP_TYPE',
2184: 'HZ_GENDER')
2185: when (E37_FLAG is null) then
2186: into hz_imp_errors (
2187: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2188: token1_name, token1_value, token2_name, token2_value)
2189: values (
2190: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',

Line 2194: into hz_imp_errors (

2190: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',
2191: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'PERSON_IDEN_TYPE', 'LOOKUP_TYPE',
2192: 'HZ_PERSON_IDEN_TYPE')
2193: when (E38_FLAG is null) then
2194: into hz_imp_errors (
2195: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2196: token1_name, token1_value, token2_name, token2_value)
2197: values (
2198: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',

Line 2202: into hz_imp_errors (

2198: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',
2199: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'CREATED_BY_MODULE', 'LOOKUP_TYPE',
2200: 'HZ_CREATED_BY_MODULES')
2201: when (E39_FLAG is null) then
2202: into hz_imp_errors (
2203: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
2204: values (
2205: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',
2206: 'HZ_NO_CHANGE_PARTY_NAME')

Line 2208: into hz_imp_errors (

2204: values (
2205: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',
2206: 'HZ_NO_CHANGE_PARTY_NAME')
2207: when (DUP_VAL_IDX_EXCEP_FLAG = 'A') then
2208: into hz_imp_errors (
2209: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2210: token1_name, token1_value, token2_name, token2_value)
2211: values (
2212: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',

Line 2215: into hz_imp_errors (

2211: values (
2212: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',
2213: 'HZ_IMP_DUP_VAL', 'INDEX', 'HZ_PARTIES_U1', 'ENTITY', 'HZ_PARTIES')
2214: when (DUP_VAL_IDX_EXCEP_FLAG = 'B') then
2215: into hz_imp_errors (
2216: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2217: token1_name, token1_value, token2_name, token2_value)
2218: values (
2219: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',

Line 2222: into hz_imp_errors (

2218: values (
2219: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',
2220: 'HZ_IMP_DUP_VAL', 'INDEX', 'HZ_PARTIES_U2', 'ENTITY', 'HZ_PARTIES')
2221: when (ACTION_MISMATCH_FLAG is null) then
2222: into hz_imp_errors (
2223: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
2224: values (
2225: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_PARTIES_INT',
2226: 'HZ_IMP_ACTION_MISMATCH')

Line 2246: into hz_imp_errors (

2242: and e.interface_table_name = 'HZ_IMP_PARTIES_INT';
2243:
2244: insert all
2245: when (E1_FLAG is null) then
2246: into hz_imp_errors (
2247: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2248: token1_name, token1_value)
2249: values (
2250: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_RELSHIPS_INT',

Line 2253: into hz_imp_errors (

2249: values (
2250: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_RELSHIPS_INT',
2251: 'HZ_IMP_REL_SUBJ_OBJ_ERROR', 'SUB_OR_OBJ', 'SUBJECT')
2252: when (E2_FLAG is null) then
2253: into hz_imp_errors (
2254: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2255: token1_name, token1_value)
2256: values (
2257: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_RELSHIPS_INT',

Line 2260: into hz_imp_errors (

2256: values (
2257: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_RELSHIPS_INT',
2258: 'HZ_IMP_REL_SUBJ_OBJ_ERROR', 'SUB_OR_OBJ', 'OBJECT')
2259: when (E3_FLAG is null) then
2260: into hz_imp_errors (
2261: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
2262: values (
2263: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_RELSHIPS_INT',
2264: 'HZ_IMP_REL_TYPE_ERROR')

Line 2266: into hz_imp_errors (

2262: values (
2263: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_RELSHIPS_INT',
2264: 'HZ_IMP_REL_TYPE_ERROR')
2265: when (E4_FLAG is null) then
2266: into hz_imp_errors (
2267: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2268: token1_name, token1_value, token2_name, token2_value)
2269: values (
2270: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_RELSHIPS_INT',

Line 2274: into hz_imp_errors (

2270: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_RELSHIPS_INT',
2271: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'RELATIONSHIP_CODE',
2272: 'LOOKUP_TYPE', 'PARTY_RELATIONS_TYPE')
2273: when (E5_FLAG is null) then
2274: into hz_imp_errors (
2275: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2276: token1_name, token1_value, token2_name, token2_value)
2277: values (
2278: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_RELSHIPS_INT',

Line 2281: into hz_imp_errors (

2277: values (
2278: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_RELSHIPS_INT',
2279: 'HZ_API_DATE_GREATER', 'DATE2', 'END_DATE', 'DATE1', 'START_DATE')
2280: when (E6_FLAG is null) then
2281: into hz_imp_errors (
2282: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
2283: values (
2284: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_RELSHIPS_INT',
2285: 'HZ_IMP_HIERARCHICAL_FLAG_ERROR')

Line 2287: into hz_imp_errors (

2283: values (
2284: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_RELSHIPS_INT',
2285: 'HZ_IMP_HIERARCHICAL_FLAG_ERROR')
2286: when (E7_FLAG is null) then
2287: into hz_imp_errors (
2288: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
2289: values (
2290: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_RELSHIPS_INT',
2291: 'HZ_API_SUBJECT_OBJECT_IDS')

Line 2293: into hz_imp_errors (

2289: values (
2290: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_RELSHIPS_INT',
2291: 'HZ_API_SUBJECT_OBJECT_IDS')
2292: when (E8_FLAG is null) then
2293: into hz_imp_errors (
2294: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
2295: values (
2296: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_RELSHIPS_INT',
2297: 'HZ_RELATIONSHIP_DATE_OVERLAP')

Line 2299: into hz_imp_errors (

2295: values (
2296: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_RELSHIPS_INT',
2297: 'HZ_RELATIONSHIP_DATE_OVERLAP')
2298: when (E9_FLAG is null) then
2299: into hz_imp_errors (
2300: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2301: token1_name, token1_value)
2302: values (
2303: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_RELSHIPS_INT',

Line 2306: into hz_imp_errors (

2302: values (
2303: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_RELSHIPS_INT',
2304: 'AR_RAPI_DESC_FLEX_INVALID', 'DFF_NAME', 'HZ_RELATIONSHIPS')
2305: when (E10_FLAG is null) then
2306: into hz_imp_errors (
2307: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2308: token1_name, token1_value)
2309: values (
2310: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_RELSHIPS_INT',

Line 2313: into hz_imp_errors (

2309: values (
2310: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_RELSHIPS_INT',
2311: 'HZ_DSS_NO_UPDATE_PRIVILEGE', 'ENTITY_NAME', l_dss_rel_err)
2312: when (E11_FLAG is null) then
2313: into hz_imp_errors (
2314: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2315: token1_name, token1_value, token2_name, token2_value)
2316: values (
2317: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_RELSHIPS_INT',

Line 2321: into hz_imp_errors (

2317: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_RELSHIPS_INT',
2318: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'CREATED_BY_MODULE', 'LOOKUP_TYPE',
2319: 'HZ_CREATED_BY_MODULES')
2320: when (DUP_VAL_IDX_EXCEP_FLAG = 'A') then
2321: into hz_imp_errors (
2322: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2323: token1_name, token1_value, token2_name, token2_value)
2324: values (
2325: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_RELSHIPS_INT',

Line 2329: into hz_imp_errors (

2325: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_RELSHIPS_INT',
2326: 'HZ_IMP_DUP_VAL', 'INDEX', 'HZ_RELATIONSHIPS_U1', 'ENTITY',
2327: 'HZ_RELATIONSHIPS')
2328: when (ACTION_MISMATCH_FLAG is null) then
2329: into hz_imp_errors (
2330: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
2331: values (
2332: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_RELSHIPS_INT',
2333: 'HZ_IMP_ACTION_MISMATCH')

Line 2348: into hz_imp_errors (

2344: and e.interface_table_name = 'HZ_IMP_RELSHIPS_INT';
2345:
2346: insert all
2347: when (E1_FLAG is null) then
2348: into hz_imp_errors (
2349: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2350: token1_name, token1_value)
2351: values (
2352: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTS_INT',

Line 2355: into hz_imp_errors (

2351: values (
2352: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTS_INT',
2353: 'HZ_IMP_REL_SUBJ_OBJ_ERROR', 'SUB_OR_OBJ', 'SUBJECT')
2354: when (E2_FLAG is null) then
2355: into hz_imp_errors (
2356: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2357: token1_name, token1_value)
2358: values (
2359: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTS_INT',

Line 2362: into hz_imp_errors (

2358: values (
2359: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTS_INT',
2360: 'HZ_IMP_REL_SUBJ_OBJ_ERROR', 'SUB_OR_OBJ', 'OBJECT')
2361: when (E3_FLAG is null) then
2362: into hz_imp_errors (
2363: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2364: token1_name, token1_value, token2_name, token2_value)
2365: values (
2366: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTS_INT',

Line 2370: into hz_imp_errors (

2366: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTS_INT',
2367: 'HZ_API_PARTY_NOT_PERSON', 'TABLE_NAME', 'HZ_IMP_CONTACTS_INT',
2368: 'PARTY_ID_COL', SUB_ORIG_SYSTEM_REFERENCE)
2369: when (E4_FLAG is null) then
2370: into hz_imp_errors (
2371: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2372: token1_name, token1_value, token2_name, token2_value)
2373: values (
2374: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTS_INT',

Line 2378: into hz_imp_errors (

2374: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTS_INT',
2375: 'HZ_API_PARTY_NOT_ORG', 'TABLE_NAME', 'HZ_IMP_CONTACTS_INT',
2376: 'PARTY_ID_COL', OBJ_ORIG_SYSTEM_REFERENCE)
2377: when (E5_FLAG is null) then
2378: into hz_imp_errors (
2379: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2380: token1_name, token1_value, token2_name, token2_value)
2381: values (
2382: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTS_INT',

Line 2386: into hz_imp_errors (

2382: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTS_INT',
2383: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'RELATIONSHIP_CODE',
2384: 'LOOKUP_TYPE', 'PARTY_RELATIONS_TYPE')
2385: when (E6_FLAG is null) then
2386: into hz_imp_errors (
2387: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2388: token1_name, token1_value, token2_name, token2_value)
2389: values (
2390: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTS_INT',

Line 2394: into hz_imp_errors (

2390: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTS_INT',
2391: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'DEPARTMENT_CODE', 'LOOKUP_TYPE',
2392: 'DEPARTMENT_CODE')
2393: when (E7_FLAG is null) then
2394: into hz_imp_errors (
2395: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2396: token1_name, token1_value, token2_name, token2_value)
2397: values (
2398: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTS_INT',

Line 2402: into hz_imp_errors (

2398: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTS_INT',
2399: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'TITLE', 'LOOKUP_TYPE',
2400: 'CONTACT_TITLE')
2401: when (E8_FLAG is null) then
2402: into hz_imp_errors (
2403: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2404: token1_name, token1_value, token2_name, token2_value)
2405: values (
2406: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTS_INT',

Line 2410: into hz_imp_errors (

2406: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTS_INT',
2407: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'JOB_TITLE_CODE', 'LOOKUP_TYPE',
2408: 'RESPONSIBILITY')
2409: when (E9_FLAG is null) then
2410: into hz_imp_errors (
2411: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2412: token1_name, token1_value, token2_name, token2_value)
2413: values (
2414: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTS_INT',

Line 2418: into hz_imp_errors (

2414: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTS_INT',
2415: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'DECISION_MAKER_FLAG',
2416: 'LOOKUP_TYPE', 'YES/NO')
2417: when (E10_FLAG is null) then
2418: into hz_imp_errors (
2419: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2420: token1_name, token1_value, token2_name, token2_value)
2421: values (
2422: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTS_INT',

Line 2426: into hz_imp_errors (

2422: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTS_INT',
2423: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'REFERENCE_USE_FLAG',
2424: 'LOOKUP_TYPE', 'YES/NO')
2425: when (E11_FLAG is null) then
2426: into hz_imp_errors (
2427: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2428: token1_name, token1_value, token2_name, token2_value)
2429: values (
2430: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTS_INT',

Line 2433: into hz_imp_errors (

2429: values (
2430: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTS_INT',
2431: 'HZ_API_DATE_GREATER', 'DATE2', 'END_DATE', 'DATE1', 'START_DATE')
2432: when (E12_FLAG is null) then
2433: into hz_imp_errors (
2434: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2435: token1_name, token1_value)
2436: values (
2437: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTS_INT',

Line 2440: into hz_imp_errors (

2436: values (
2437: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTS_INT',
2438: 'AR_RAPI_DESC_FLEX_INVALID', 'DFF_NAME', 'HZ_ORG_CONTACTS')
2439: when (E13_FLAG is null) then
2440: into hz_imp_errors (
2441: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
2442: values (
2443: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTS_INT',
2444: 'HZ_IMP_HIERARCHICAL_FLAG_ERROR')

Line 2446: into hz_imp_errors (

2442: values (
2443: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTS_INT',
2444: 'HZ_IMP_HIERARCHICAL_FLAG_ERROR')
2445: when (E14_FLAG is null) then
2446: into hz_imp_errors (
2447: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
2448: values (
2449: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTS_INT', 'HZ_IMP_DUP_REL_IN_INT_ERROR')
2450: when (E15_FLAG is null) then

Line 2451: into hz_imp_errors (

2447: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
2448: values (
2449: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTS_INT', 'HZ_IMP_DUP_REL_IN_INT_ERROR')
2450: when (E15_FLAG is null) then
2451: into hz_imp_errors (
2452: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2453: token1_name, token1_value)
2454: values (
2455: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTS_INT',

Line 2458: into hz_imp_errors (

2454: values (
2455: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTS_INT',
2456: 'HZ_DSS_NO_UPDATE_PRIVILEGE', 'ENTITY_NAME', l_dss_rel_err)
2457: when (E16_FLAG is null) then
2458: into hz_imp_errors (
2459: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2460: token1_name, token1_value)
2461: values (
2462: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTS_INT',

Line 2466: into hz_imp_errors (

2462: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTS_INT',
2463: 'HZ_API_NONUPDATEABLE_TO_NULL', 'COLUMN', 'START_DATE')
2464: -- Bug 4156586
2465: when (E17_FLAG is null) then
2466: into hz_imp_errors (
2467: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
2468: values (
2469: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTS_INT', 'HZ_API_SUBJECT_OBJECT_IDS')
2470: when (E18_FLAG is null) then

Line 2471: into hz_imp_errors (

2467: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
2468: values (
2469: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTS_INT', 'HZ_API_SUBJECT_OBJECT_IDS')
2470: when (E18_FLAG is null) then
2471: into hz_imp_errors (
2472: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2473: token1_name, token1_value, token2_name, token2_value)
2474: values (
2475: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTS_INT',

Line 2479: into hz_imp_errors (

2475: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTS_INT',
2476: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'CREATED_BY_MODULE', 'LOOKUP_TYPE',
2477: 'HZ_CREATED_BY_MODULES')
2478: when (DUP_VAL_IDX_EXCEP_FLAG = 'A') then
2479: into hz_imp_errors (
2480: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2481: token1_name, token1_value, token2_name, token2_value)
2482: values (
2483: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTS_INT',

Line 2487: into hz_imp_errors (

2483: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTS_INT',
2484: 'HZ_IMP_DUP_VAL', 'INDEX', 'HZ_ORG_CONTACTS_U1', 'ENTITY',
2485: 'HZ_ORG_CONTACTS')
2486: when (ACTION_MISMATCH_FLAG is null) then
2487: into hz_imp_errors (
2488: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
2489: values (
2490: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTS_INT',
2491: 'HZ_IMP_ACTION_MISMATCH')

Line 2509: into hz_imp_errors (

2505: and e.interface_table_name = 'HZ_IMP_CONTACTS_INT';
2506:
2507: insert all
2508: when (E2_FLAG is null) then
2509: into hz_imp_errors (
2510: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2511: token1_name, token1_value, token2_name, token2_value, token3_name,
2512: token3_value)
2513: values (

Line 2518: into hz_imp_errors (

2514: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CLASSIFICS_INT',
2515: 'HZ_API_INVALID_FK', 'FK', 'CLASS_CATEGORY', 'COLUMN',
2516: 'CLASS_CATEGORY', 'TABLE', 'HZ_CLASS_CATEGORIES')
2517: when (E3_FLAG is null) then
2518: into hz_imp_errors (
2519: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2520: token1_name, token1_value, token2_name, token2_value)
2521: values (
2522: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CLASSIFICS_INT',

Line 2526: into hz_imp_errors (

2522: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CLASSIFICS_INT',
2523: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'CLASS_CODE', 'LOOKUP_TYPE',
2524: 'HZ_IMP_CLASSIFICS_INT.CLASS_CATEGORY')
2525: when (E4_FLAG is null) then
2526: into hz_imp_errors (
2527: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2528: token1_name, token1_value, token2_name, token2_value)
2529: values (
2530: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CLASSIFICS_INT',

Line 2534: into hz_imp_errors (

2530: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CLASSIFICS_INT',
2531: 'HZ_API_DATE_GREATER', 'DATE2', 'END_DATE_ACTIVE', 'DATE1',
2532: 'START_DATE_ACTIVE')
2533: when (E5_FLAG is null) then
2534: into hz_imp_errors (
2535: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
2536: values (
2537: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CLASSIFICS_INT',
2538: 'HZ_IMP_CODE_ASSG_DATE_OVERLAP')

Line 2540: into hz_imp_errors (

2536: values (
2537: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CLASSIFICS_INT',
2538: 'HZ_IMP_CODE_ASSG_DATE_OVERLAP')
2539: when (E6_FLAG is null) then
2540: into hz_imp_errors (
2541: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
2542: values (
2543: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CLASSIFICS_INT',
2544: 'HZ_API_ALLOW_MUL_ASSIGN_FG')

Line 2546: into hz_imp_errors (

2542: values (
2543: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CLASSIFICS_INT',
2544: 'HZ_API_ALLOW_MUL_ASSIGN_FG')
2545: when (E7_FLAG is null) then
2546: into hz_imp_errors (
2547: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
2548: values (
2549: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CLASSIFICS_INT',
2550: 'HZ_API_LEAFNODE_FLAG')

Line 2552: into hz_imp_errors (

2548: values (
2549: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CLASSIFICS_INT',
2550: 'HZ_API_LEAFNODE_FLAG')
2551: when (E8_FLAG is null) then
2552: into hz_imp_errors (
2553: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2554: token1_name, token1_value)
2555: values (
2556: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CLASSIFICS_INT',

Line 2559: into hz_imp_errors (

2555: values (
2556: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CLASSIFICS_INT',
2557: 'HZ_API_NONUPDATEABLE_TO_NULL', 'COLUMN', 'START_DATE')
2558: when (E9_FLAG is null) then
2559: into hz_imp_errors (
2560: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2561: token1_name, token1_value)
2562: values (
2563: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CLASSIFICS_INT',

Line 2566: into hz_imp_errors (

2562: values (
2563: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CLASSIFICS_INT',
2564: 'HZ_DSS_NO_UPDATE_PRIVILEGE', 'ENTITY_NAME', l_dss_ca_err)
2565: when (E10_FLAG is null) then
2566: into hz_imp_errors (
2567: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2568: token1_name, token1_value, token2_name, token2_value)
2569: values (
2570: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CLASSIFICS_INT',

Line 2574: into hz_imp_errors (

2570: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CLASSIFICS_INT',
2571: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'CREATED_BY_MODULE', 'LOOKUP_TYPE',
2572: 'HZ_CREATED_BY_MODULES')
2573: when (DUP_VAL_IDX_EXCEP_FLAG = 'A') then
2574: into hz_imp_errors (
2575: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2576: token1_name, token1_value, token2_name, token2_value)
2577: values (
2578: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CLASSIFICS_INT',

Line 2582: into hz_imp_errors (

2578: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CLASSIFICS_INT',
2579: 'HZ_IMP_DUP_VAL', 'INDEX', 'HZ_CODE_ASSIGNMENTS_U1', 'ENTITY',
2580: 'HZ_CODE_ASSIGNMENTS')
2581: when (DUP_VAL_IDX_EXCEP_FLAG = 'B') then
2582: into hz_imp_errors (
2583: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2584: token1_name, token1_value, token2_name, token2_value)
2585: values (
2586: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CLASSIFICS_INT',

Line 2590: into hz_imp_errors (

2586: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CLASSIFICS_INT',
2587: 'HZ_IMP_DUP_VAL', 'INDEX', 'HZ_CODE_ASSIGNMENTS_U2', 'ENTITY',
2588: 'HZ_CODE_ASSIGNMENTS')
2589: when (ACTION_MISMATCH_FLAG is null) then
2590: into hz_imp_errors (
2591: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
2592: values (
2593: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CLASSIFICS_INT',
2594: 'HZ_IMP_ACTION_MISMATCH')

Line 2596: into hz_imp_errors (

2592: values (
2593: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CLASSIFICS_INT',
2594: 'HZ_IMP_ACTION_MISMATCH')
2595: when (MISSING_PARENT_FLAG is null) then -- Bug 4403736
2596: into hz_imp_errors (
2597: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
2598: values (
2599: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CLASSIFICS_INT',
2600: 'HZ_IMP_PARENT_PARTY_NOT_FOUND')

Line 2615: into hz_imp_errors (

2611: and e.interface_table_name = 'HZ_IMP_CLASSIFICS_INT';
2612:
2613: insert all
2614: when (E1_FLAG is null) then
2615: into hz_imp_errors (
2616: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2617: token1_name, token1_value, token2_name, token2_value)
2618: values (
2619: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

Line 2623: into hz_imp_errors (

2619: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2620: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'BANKRUPTCY_IND', 'LOOKUP_TYPE',
2621: 'YES/NO')
2622: when (E2_FLAG is null) then
2623: into hz_imp_errors (
2624: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2625: token1_name, token1_value, token2_name, token2_value)
2626: values (
2627: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

Line 2630: into hz_imp_errors (

2626: values (
2627: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2628: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'SUIT_IND', 'LOOKUP_TYPE', 'YES/NO')
2629: when (E4_FLAG is null) then
2630: into hz_imp_errors (
2631: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2632: token1_name, token1_value, token2_name, token2_value)
2633: values (
2634: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

Line 2638: into hz_imp_errors (

2634: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2635: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'DEBARMENT_IND', 'LOOKUP_TYPE',
2636: 'YES/NO')
2637: when (E5_FLAG is null) then
2638: into hz_imp_errors (
2639: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2640: token1_name, token1_value, token2_name,
2641: token2_value)
2642: values (

Line 2647: into hz_imp_errors (

2643: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2644: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'FINCL_EMBT_IND', 'LOOKUP_TYPE',
2645: 'YES/NO')
2646: when (E6_FLAG is null) then
2647: into hz_imp_errors (
2648: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2649: token1_name, token1_value, token2_name, token2_value)
2650: values (
2651: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

Line 2655: into hz_imp_errors (

2651: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2652: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'NO_TRADE_IND', 'LOOKUP_TYPE',
2653: 'YES/NO')
2654: when (E7_FLAG is null) then
2655: into hz_imp_errors (
2656: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2657: token1_name, token1_value, token2_name, token2_value)
2658: values (
2659: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

Line 2663: into hz_imp_errors (

2659: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2660: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'JUDGEMENT_IND', 'LOOKUP_TYPE',
2661: 'YES/NO')
2662: when (E8_FLAG is null) then
2663: into hz_imp_errors (
2664: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2665: token1_name, token1_value, token2_name, token2_value)
2666: values (
2667: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

Line 2670: into hz_imp_errors (

2666: values (
2667: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2668: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'LIEN_IND', 'LOOKUP_TYPE', 'YES/NO')
2669: when (E9_FLAG is null) then
2670: into hz_imp_errors (
2671: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2672: token1_name, token1_value, token2_name, token2_value)
2673: values (
2674: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

Line 2678: into hz_imp_errors (

2674: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2675: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'CREDIT_SCORE_OVERRIDE_CODE',
2676: 'LOOKUP_TYPE', 'FAILURE_SCORE_OVERRIDE_CODE')
2677: when (E10_FLAG is null) then
2678: into hz_imp_errors (
2679: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2680: token1_name, token1_value, token2_name, token2_value)
2681: values (
2682: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

Line 2686: into hz_imp_errors (

2682: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2683: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'FAILURE_SCORE_COMMENTARY',
2684: 'LOOKUP_TYPE', 'FAILURE_SCORE_COMMENTARY')
2685: when (E11_FLAG is null) then
2686: into hz_imp_errors (
2687: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2688: token1_name, token1_value, token2_name, token2_value)
2689: values (
2690: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

Line 2694: into hz_imp_errors (

2690: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2691: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'FAILURE_SCORE_COMMENTARY2',
2692: 'LOOKUP_TYPE', 'FAILURE_SCORE_COMMENTARY')
2693: when (E12_FLAG is null) then
2694: into hz_imp_errors (
2695: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2696: token1_name, token1_value, token2_name, token2_value)
2697: values (
2698: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

Line 2702: into hz_imp_errors (

2698: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2699: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'FAILURE_SCORE_COMMENTARY3',
2700: 'LOOKUP_TYPE', 'FAILURE_SCORE_COMMENTARY')
2701: when (E13_FLAG is null) then
2702: into hz_imp_errors (
2703: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2704: token1_name, token1_value, token2_name, token2_value)
2705: values (
2706: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

Line 2710: into hz_imp_errors (

2706: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2707: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'FAILURE_SCORE_COMMENTARY4',
2708: 'LOOKUP_TYPE', 'FAILURE_SCORE_COMMENTARY')
2709: when (E14_FLAG is null) then
2710: into hz_imp_errors (
2711: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2712: token1_name, token1_value, token2_name, token2_value)
2713: values (
2714: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

Line 2718: into hz_imp_errors (

2714: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2715: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'FAILURE_SCORE_COMMENTARY5',
2716: 'LOOKUP_TYPE', 'FAILURE_SCORE_COMMENTARY')
2717: when (E15_FLAG is null) then
2718: into hz_imp_errors (
2719: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2720: token1_name, token1_value, token2_name, token2_value)
2721: values (
2722: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

Line 2726: into hz_imp_errors (

2722: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2723: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'FAILURE_SCORE_COMMENTARY6',
2724: 'LOOKUP_TYPE', 'FAILURE_SCORE_COMMENTARY')
2725: when (E16_FLAG is null) then
2726: into hz_imp_errors (
2727: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2728: token1_name, token1_value, token2_name, token2_value)
2729: values (
2730: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

Line 2734: into hz_imp_errors (

2730: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2731: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'FAILURE_SCORE_COMMENTARY7',
2732: 'LOOKUP_TYPE', 'FAILURE_SCORE_COMMENTARY')
2733: when (E17_FLAG is null) then
2734: into hz_imp_errors (
2735: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2736: token1_name, token1_value, token2_name, token2_value)
2737: values (
2738: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

Line 2742: into hz_imp_errors (

2738: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2739: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'FAILURE_SCORE_COMMENTARY8',
2740: 'LOOKUP_TYPE', 'FAILURE_SCORE_COMMENTARY')
2741: when (E18_FLAG is null) then
2742: into hz_imp_errors (
2743: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2744: token1_name, token1_value, token2_name, token2_value)
2745: values (
2746: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

Line 2750: into hz_imp_errors (

2746: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2747: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'FAILURE_SCORE_COMMENTARY9',
2748: 'LOOKUP_TYPE', 'FAILURE_SCORE_COMMENTARY')
2749: when (E19_FLAG is null) then
2750: into hz_imp_errors (
2751: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2752: token1_name, token1_value, token2_name, token2_value)
2753: values (
2754: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

Line 2758: into hz_imp_errors (

2754: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2755: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'FAILURE_SCORE_COMMENTARY10',
2756: 'LOOKUP_TYPE', 'FAILURE_SCORE_COMMENTARY')
2757: when (E20_FLAG is null) then
2758: into hz_imp_errors (
2759: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2760: token1_name, token1_value, token2_name, token2_value)
2761: values (
2762: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

Line 2766: into hz_imp_errors (

2762: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2763: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'FAILURE_SCORE_OVERRIDE_CODE',
2764: 'LOOKUP_TYPE', 'FAILURE_SCORE_OVERRIDE_CODE')
2765: when (E21_FLAG is null) then
2766: into hz_imp_errors (
2767: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2768: token1_name, token1_value, token2_name, token2_value)
2769: values (
2770: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

Line 2774: into hz_imp_errors (

2770: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2771: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'CREDIT_SCORE_COMMENTARY',
2772: 'LOOKUP_TYPE', 'CREDIT_SCORE_COMMENTARY')
2773: when (E22_FLAG is null) then
2774: into hz_imp_errors (
2775: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2776: token1_name, token1_value, token2_name, token2_value)
2777: values (
2778: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

Line 2782: into hz_imp_errors (

2778: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2779: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'CREDIT_SCORE_COMMENTARY2',
2780: 'LOOKUP_TYPE', 'CREDIT_SCORE_COMMENTARY')
2781: when (E23_FLAG is null) then
2782: into hz_imp_errors (
2783: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2784: token1_name, token1_value, token2_name, token2_value)
2785: values (
2786: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

Line 2790: into hz_imp_errors (

2786: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2787: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'CREDIT_SCORE_COMMENTARY3',
2788: 'LOOKUP_TYPE', 'CREDIT_SCORE_COMMENTARY')
2789: when (E24_FLAG is null) then
2790: into hz_imp_errors (
2791: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2792: token1_name, token1_value, token2_name, token2_value)
2793: values (
2794: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

Line 2798: into hz_imp_errors (

2794: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2795: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'CREDIT_SCORE_COMMENTARY4',
2796: 'LOOKUP_TYPE', 'CREDIT_SCORE_COMMENTARY')
2797: when (E25_FLAG is null) then
2798: into hz_imp_errors (
2799: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2800: token1_name, token1_value, token2_name, token2_value)
2801: values (
2802: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

Line 2806: into hz_imp_errors (

2802: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2803: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'CREDIT_SCORE_COMMENTARY5',
2804: 'LOOKUP_TYPE', 'CREDIT_SCORE_COMMENTARY')
2805: when (E26_FLAG is null) then
2806: into hz_imp_errors (
2807: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2808: token1_name, token1_value, token2_name, token2_value)
2809: values (
2810: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

Line 2814: into hz_imp_errors (

2810: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2811: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'CREDIT_SCORE_COMMENTARY6',
2812: 'LOOKUP_TYPE', 'CREDIT_SCORE_COMMENTARY')
2813: when (E27_FLAG is null) then
2814: into hz_imp_errors (
2815: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2816: token1_name, token1_value, token2_name, token2_value)
2817: values (
2818: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

Line 2822: into hz_imp_errors (

2818: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2819: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'CREDIT_SCORE_COMMENTARY7',
2820: 'LOOKUP_TYPE', 'CREDIT_SCORE_COMMENTARY')
2821: when (E28_FLAG is null) then
2822: into hz_imp_errors (
2823: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2824: token1_name, token1_value, token2_name, token2_value)
2825: values (
2826: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

Line 2830: into hz_imp_errors (

2826: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2827: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'CREDIT_SCORE_COMMENTARY8',
2828: 'LOOKUP_TYPE', 'CREDIT_SCORE_COMMENTARY')
2829: when (E29_FLAG is null) then
2830: into hz_imp_errors (
2831: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2832: token1_name, token1_value, token2_name, token2_value)
2833: values (
2834: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

Line 2838: into hz_imp_errors (

2834: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2835: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'CREDIT_SCORE_COMMENTARY9',
2836: 'LOOKUP_TYPE', 'CREDIT_SCORE_COMMENTARY')
2837: when (E30_FLAG is null) then
2838: into hz_imp_errors (
2839: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2840: token1_name, token1_value, token2_name, token2_value)
2841: values (
2842: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

Line 2846: into hz_imp_errors (

2842: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2843: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'CREDIT_SCORE_COMMENTARY10',
2844: 'LOOKUP_TYPE', 'CREDIT_SCORE_COMMENTARY')
2845: when (E31_FLAG is null) then
2846: into hz_imp_errors (
2847: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2848: token1_name, token1_value, token2_name, token2_value)
2849: values (
2850: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

Line 2854: into hz_imp_errors (

2850: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2851: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'PRNT_HQ_BKCY_IND',
2852: 'LOOKUP_TYPE', 'PRNT_HQ_IND')
2853: when (E32_FLAG is null) then
2854: into hz_imp_errors (
2855: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2856: token1_name, token1_value, token2_name, token2_value, token3_name,
2857: token3_value)
2858: values (

Line 2863: into hz_imp_errors (

2859: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2860: 'HZ_API_INVALID_FK', 'FK', 'CURRENCY_CODE', 'COLUMN',
2861: 'MAXIMUM_CREDIT_CURRENCY_CODE', 'TABLE', 'FND_CURRENCIES')
2862: when (E33_FLAG is null) then
2863: into hz_imp_errors (
2864: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2865: token1_name, token1_value, token2_name, token2_value)
2866: values (
2867: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

Line 2871: into hz_imp_errors (

2867: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2868: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'CREATED_BY_MODULE', 'LOOKUP_TYPE',
2869: 'HZ_CREATED_BY_MODULES')
2870: when (DUP_VAL_IDX_EXCEP_FLAG = 'A') then
2871: into hz_imp_errors (
2872: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2873: token1_name, token1_value, token2_name, token2_value)
2874: values (
2875: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

Line 2879: into hz_imp_errors (

2875: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2876: 'HZ_IMP_DUP_VAL', 'INDEX', 'HZ_CREDIT_RATINGS_U1', 'ENTITY',
2877: 'HZ_CREDIT_RATINGS')
2878: when (DUP_VAL_IDX_EXCEP_FLAG = 'B') then
2879: into hz_imp_errors (
2880: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2881: token1_name, token1_value, token2_name, token2_value)
2882: values (
2883: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

Line 2887: into hz_imp_errors (

2883: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2884: 'HZ_IMP_DUP_VAL', 'INDEX', 'HZ_CREDIT_RATINGS_U2', 'ENTITY',
2885: 'HZ_CREDIT_RATINGS')
2886: when (ACTION_MISMATCH_FLAG is null) then
2887: into hz_imp_errors (
2888: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
2889: values (
2890: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2891: 'HZ_IMP_ACTION_MISMATCH')

Line 2893: into hz_imp_errors (

2889: values (
2890: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2891: 'HZ_IMP_ACTION_MISMATCH')
2892: when (MISSING_PARENT_FLAG is null) then
2893: into hz_imp_errors (
2894: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
2895: values (
2896: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2897: 'HZ_IMP_PARENT_PARTY_NOT_FOUND')

Line 2915: into hz_imp_errors (

2911:
2912:
2913: insert all
2914: when (E1_FLAG is null) then
2915: into hz_imp_errors (
2916: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2917: token1_name, token1_value, token2_name, token2_value)
2918: values (
2919: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSUSES_INT',

Line 2923: into hz_imp_errors (

2919: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSUSES_INT',
2920: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'SITE_USE_TYPE', 'LOOKUP_TYPE',
2921: 'PARTY_SITE_USE_CODE')
2922: when (E2_FLAG is null) then
2923: into hz_imp_errors (
2924: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
2925: values (
2926: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSUSES_INT',
2927: 'HZ_API_UNIQUE_SITE_USE_TYPE')

Line 2929: into hz_imp_errors (

2925: values (
2926: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSUSES_INT',
2927: 'HZ_API_UNIQUE_SITE_USE_TYPE')
2928: when (E3_FLAG is null) then
2929: into hz_imp_errors (
2930: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
2931: values (
2932: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSUSES_INT',
2933: 'HZ_IMP_ADDRUSE_OSR_MISMATCH')

Line 2935: into hz_imp_errors (

2931: values (
2932: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSUSES_INT',
2933: 'HZ_IMP_ADDRUSE_OSR_MISMATCH')
2934: when (E4_FLAG is null) then
2935: into hz_imp_errors (
2936: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2937: token1_name, token1_value, token2_name, token2_value)
2938: values (
2939: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSUSES_INT',

Line 2943: into hz_imp_errors (

2939: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSUSES_INT',
2940: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'CREATED_BY_MODULE', 'LOOKUP_TYPE',
2941: 'HZ_CREATED_BY_MODULES')
2942: when (DUP_VAL_IDX_EXCEP_FLAG = 'A') then
2943: into hz_imp_errors (
2944: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2945: token1_name, token1_value, token2_name, token2_value)
2946: values (
2947: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSUSES_INT',

Line 2951: into hz_imp_errors (

2947: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSUSES_INT',
2948: 'HZ_IMP_DUP_VAL', 'INDEX', 'HZ_PARTY_SITE_USES_U1', 'ENTITY',
2949: 'HZ_PARTY_SITE_USES')
2950: when (ACTION_MISMATCH_FLAG is null) then
2951: into hz_imp_errors (
2952: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
2953: values (
2954: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSUSES_INT',
2955: 'HZ_IMP_ACTION_MISMATCH')

Line 2957: into hz_imp_errors (

2953: values (
2954: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSUSES_INT',
2955: 'HZ_IMP_ACTION_MISMATCH')
2956: when (MISSING_PARENT_FLAG is null) then
2957: into hz_imp_errors (
2958: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
2959: values (
2960: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSUSES_INT',
2961: 'HZ_IMP_ADDR_NOT_FOUND')

Line 2972: into hz_imp_errors (

2968:
2969:
2970: insert all
2971: when (E1_FLAG is null) then
2972: into hz_imp_errors (
2973: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2974: token1_name, token1_value, token2_name, token2_value)
2975: values (
2976: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTROLES_INT',

Line 2980: into hz_imp_errors (

2976: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTROLES_INT',
2977: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'ROLE_TYPE', 'LOOKUP_TYPE',
2978: 'CONTACT_ROLE_TYPE')
2979: when (E2_FLAG is null) then
2980: into hz_imp_errors (
2981: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
2982: values (
2983: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTROLES_INT',
2984: 'HZ_IMP_CONTROLE_OSR_MISMATCH')

Line 2986: into hz_imp_errors (

2982: values (
2983: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTROLES_INT',
2984: 'HZ_IMP_CONTROLE_OSR_MISMATCH')
2985: when (E3_FLAG is null) then
2986: into hz_imp_errors (
2987: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2988: token1_name, token1_value, token2_name, token2_value)
2989: values (
2990: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTROLES_INT',

Line 2994: into hz_imp_errors (

2990: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTROLES_INT',
2991: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'CREATED_BY_MODULE', 'LOOKUP_TYPE',
2992: 'HZ_CREATED_BY_MODULES')
2993: when (DUP_VAL_IDX_EXCEP_FLAG = 'A') then
2994: into hz_imp_errors (
2995: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2996: token1_name, token1_value, token2_name, token2_value)
2997: values (
2998: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTROLES_INT',

Line 3002: into hz_imp_errors (

2998: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTROLES_INT',
2999: 'HZ_IMP_DUP_VAL', 'INDEX', 'HZ_ORG_CONTACT_ROLES_U1', 'ENTITY',
3000: 'HZ_ORG_CONTACT_ROLES')
3001: when (DUP_VAL_IDX_EXCEP_FLAG = 'B') then
3002: into hz_imp_errors (
3003: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
3004: token1_name, token1_value, token2_name, token2_value)
3005: values (
3006: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTROLES_INT',

Line 3010: into hz_imp_errors (

3006: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTROLES_INT',
3007: 'HZ_IMP_DUP_VAL', 'INDEX', 'HZ_ORG_CONTACT_ROLES_U2', 'ENTITY',
3008: 'HZ_ORG_CONTACT_ROLES')
3009: when (ACTION_MISMATCH_FLAG is null) then
3010: into hz_imp_errors (
3011: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
3012: values (
3013: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTROLES_INT',
3014: 'HZ_IMP_ACTION_MISMATCH')

Line 3016: into hz_imp_errors (

3012: values (
3013: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTROLES_INT',
3014: 'HZ_IMP_ACTION_MISMATCH')
3015: when (MISSING_PARENT_FLAG is null) then
3016: into hz_imp_errors (
3017: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
3018: values (
3019: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTROLES_INT',
3020: 'HZ_IMP_CONTACT_NOT_FOUND')

Line 3032: into hz_imp_errors (

3028:
3029:
3030: insert all
3031: when (E1_FLAG is null) then
3032: into hz_imp_errors (
3033: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
3034: token1_name, token1_value, token2_name, token2_value)
3035: values (
3036: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',

Line 3040: into hz_imp_errors (

3036: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',
3037: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'CONTACT_POINT_TYPE',
3038: 'LOOKUP_TYPE', 'CONTACT_POINT_TYPE')
3039: when (E2_FLAG is null) then
3040: into hz_imp_errors (
3041: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
3042: token1_name, token1_value, token2_name, token2_value)
3043: values (
3044: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',

Line 3048: into hz_imp_errors (

3044: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',
3045: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'CONTACT_POINT_PURPOSE',
3046: 'LOOKUP_TYPE', 'CONTACT_POINT_PURPOSE')
3047: when (E3_FLAG is null) then
3048: into hz_imp_errors (
3049: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
3050: token1_name, token1_value)
3051: values (
3052: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',

Line 3055: into hz_imp_errors (

3051: values (
3052: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',
3053: 'HZ_API_MISSING_COLUMN', 'COLUMN', 'EDI_ID_NUMBER')
3054: when (E4_FLAG is null) then
3055: into hz_imp_errors (
3056: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
3057: token1_name, token1_value)
3058: values (
3059: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',

Line 3062: into hz_imp_errors (

3058: values (
3059: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',
3060: 'HZ_API_MISSING_COLUMN', 'COLUMN', 'EMAIL_ADDRESS')
3061: when (E5_FLAG is null) then
3062: into hz_imp_errors (
3063: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
3064: token1_name, token1_value, token2_name, token2_value)
3065: values (
3066: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',

Line 3070: into hz_imp_errors (

3066: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',
3067: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'EMAIL_FORMAT', 'LOOKUP_TYPE',
3068: 'EMAIL_FORMAT')
3069: when (E6_FLAG is null) then
3070: into hz_imp_errors (
3071: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
3072: token1_name, token1_value, token2_name, token2_value, token3_name,
3073: token3_value)
3074: values (

Line 3079: into hz_imp_errors (

3075: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',
3076: 'HZ_API_INVALID_FK', 'FK', 'PHONE_COUNTRY_CODE', 'COLUMN',
3077: 'PHONE_COUNTRY_CODE', 'TABLE', 'HZ_PHONE_COUNTRY_CODES')
3078: when (E7_FLAG is null) then
3079: into hz_imp_errors (
3080: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
3081: token1_value, token2_name, token2_value)
3082: values (
3083: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',

Line 3087: into hz_imp_errors (

3083: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',
3084: 'HZ_API_INVALID_LOOKUP', 'PHONE_LINE_TYPE', 'LOOKUP_TYPE',
3085: 'PHONE_LINE_TYPE')
3086: when (E8_FLAG is null) then
3087: into hz_imp_errors (
3088: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
3089: values (
3090: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',
3091: 'HZ_INVALID_PHONE_PARAMETER')

Line 3093: into hz_imp_errors (

3089: values (
3090: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',
3091: 'HZ_INVALID_PHONE_PARAMETER')
3092: when (E9_FLAG is null) then
3093: into hz_imp_errors (
3094: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
3095: token1_name, token1_value)
3096: values (
3097: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',

Line 3100: into hz_imp_errors (

3096: values (
3097: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',
3098: 'HZ_API_MISSING_COLUMN', 'COLUMN', 'TELEX_NUMBER')
3099: when (E10_FLAG is null) then
3100: into hz_imp_errors (
3101: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
3102: token1_name, token1_value, token2_name, token2_value, token3_name,
3103: token3_value)
3104: values (

Line 3109: into hz_imp_errors (

3105: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',
3106: 'HZ_API_INVALID_FK', 'FK', 'TIMEZONE_CODE', 'COLUMN',
3107: 'TIMEZONE_CODE', 'TABLE', 'FND_TIMEZONES_B')
3108: when (E11_FLAG is null) then
3109: into hz_imp_errors (
3110: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
3111: token1_name, token1_value)
3112: values (
3113: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',

Line 3116: into hz_imp_errors (

3112: values (
3113: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',
3114: 'HZ_API_MISSING_COLUMN', 'COLUMN', 'URL')
3115: when (E12_FLAG is null) then
3116: into hz_imp_errors (
3117: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
3118: token1_name, token1_value)
3119: values (
3120: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',

Line 3123: into hz_imp_errors (

3119: values (
3120: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',
3121: 'HZ_API_MISSING_COLUMN', 'COLUMN', 'WEB_TYPE')
3122: when (E13_FLAG is null) then
3123: into hz_imp_errors (
3124: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
3125: token1_name, token1_value)
3126: values (
3127: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',

Line 3130: into hz_imp_errors (

3126: values (
3127: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',
3128: 'AR_RAPI_DESC_FLEX_INVALID', 'DFF_NAME', 'HZ_CONTACT_POINTS')
3129: when (E15_FLAG is null) then
3130: into hz_imp_errors (
3131: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
3132: token1_name, token1_value)
3133: values (
3134: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',

Line 3137: into hz_imp_errors (

3133: values (
3134: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',
3135: 'HZ_API_MISSING_COLUMN', 'COLUMN', 'CONTACT_POINT_TYPE')
3136: when (E16_FLAG is null) then
3137: into hz_imp_errors (
3138: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
3139: values (
3140: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',
3141: 'HZ_IMP_CPT_ADDR_OSR_MISMATCH')

Line 3143: into hz_imp_errors (

3139: values (
3140: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',
3141: 'HZ_IMP_CPT_ADDR_OSR_MISMATCH')
3142: when (E17_FLAG is null) then
3143: into hz_imp_errors (
3144: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
3145: token1_name, token1_value)
3146: values (
3147: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',

Line 3150: into hz_imp_errors (

3146: values (
3147: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',
3148: 'HZ_API_NONUPDATEABLE_COLUMN', 'COLUMN', 'CONTACT_POINT_TYPE')
3149: when (E18_FLAG='P') then
3150: into hz_imp_errors (
3151: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
3152: token1_name, token1_value)
3153: values (
3154: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',

Line 3157: into hz_imp_errors (

3153: values (
3154: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',
3155: 'HZ_DSS_NO_UPDATE_PRIVILEGE', 'ENTITY_NAME', l_dss_cp_err)
3156: when (E18_FLAG='S') then
3157: into hz_imp_errors (
3158: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
3159: token1_name, token1_value)
3160: values (
3161: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',

Line 3164: into hz_imp_errors (

3160: values (
3161: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',
3162: 'HZ_DSS_NO_UPDATE_PRIVILEGE', 'ENTITY_NAME', l_dss_ps_err)
3163: when (E19_FLAG is null) then
3164: into hz_imp_errors (
3165: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
3166: token1_name, token1_value, token2_name, token2_value)
3167: values (
3168: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',

Line 3172: into hz_imp_errors (

3168: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',
3169: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'CONTACT_POINT_PURPOSE',
3170: 'LOOKUP_TYPE', 'CONTACT_POINT_PURPOSE_WEB')
3171: when (DUP_VAL_IDX_EXCEP_FLAG = 'A') then
3172: into hz_imp_errors (
3173: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
3174: token1_name, token1_value, token2_name, token2_value)
3175: values (
3176: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',

Line 3180: into hz_imp_errors (

3176: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',
3177: 'HZ_IMP_DUP_VAL', 'INDEX', 'HZ_CONTACT_POINTS_U1', 'ENTITY',
3178: 'HZ_CONTACT_POINTS')
3179: when (ACTION_MISMATCH_FLAG is null) then
3180: into hz_imp_errors (
3181: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
3182: values (
3183: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',
3184: 'HZ_IMP_ACTION_MISMATCH')

Line 3186: into hz_imp_errors (

3182: values (
3183: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',
3184: 'HZ_IMP_ACTION_MISMATCH')
3185: when (MISSING_PARENT_FLAG = 'P') then
3186: into hz_imp_errors (
3187: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
3188: values (
3189: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',
3190: 'HZ_IMP_PARENT_PARTY_NOT_FOUND')

Line 3192: into hz_imp_errors (

3188: values (
3189: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',
3190: 'HZ_IMP_PARENT_PARTY_NOT_FOUND')
3191: when (MISSING_PARENT_FLAG = 'A') then
3192: into hz_imp_errors (
3193: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
3194: values (
3195: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',
3196: 'HZ_IMP_PARENT_ADDR_NOT_FOUND')

Line 3198: into hz_imp_errors (

3194: values (
3195: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',
3196: 'HZ_IMP_PARENT_ADDR_NOT_FOUND')
3197: when (E20_FLAG IS NULL) then /* Bug 4079902 */
3198: into hz_imp_errors (
3199: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
3200: values (
3201: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',
3202: 'HZ_NOTALLOW_UPDATE_THIRD_PARTY')

Line 3204: into hz_imp_errors (

3200: values (
3201: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',
3202: 'HZ_NOTALLOW_UPDATE_THIRD_PARTY')
3203: when (E21_FLAG is null) then
3204: into hz_imp_errors (
3205: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
3206: token1_name, token1_value, token2_name, token2_value)
3207: values (
3208: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',

Line 4064: SELECT hz_imp_errors_s.NEXTVAL INTO l_start_error_id FROM dual;

4060: fnd_stats.gather_table_stats('AR', 'HZ_ORIG_SYS_REFERENCES', percent=>5, degree=>4);
4061: END IF;
4062:
4063: -- get the start error_id sequence number
4064: SELECT hz_imp_errors_s.NEXTVAL INTO l_start_error_id FROM dual;
4065:
4066: /* Dup check of relationships and address uses within interface,
4067: V+DML of other entities, PP-Wait */
4068: ident_dup_within_int(P_BATCH_ID, P_ORIG_SYSTEM, P_BATCH_MODE_FLAG, P_REQUEST_ID,

Line 4072: SELECT hz_imp_errors_s.CURRVAL INTO l_current_error_id FROM dual;

4068: ident_dup_within_int(P_BATCH_ID, P_ORIG_SYSTEM, P_BATCH_MODE_FLAG, P_REQUEST_ID,
4069: D_SYSDATE, l_user_id, l_last_update_login,
4070: P_PROGRAM_APPLICATION_ID, P_PROGRAM_ID);
4071:
4072: SELECT hz_imp_errors_s.CURRVAL INTO l_current_error_id FROM dual;
4073:
4074: -- if error is greater than error limit
4075: IF l_current_error_id - l_start_error_id >=
4076: NVL(P_ERROR_LIMIT, NVL(FND_PROFILE.value('HZ_IMP_ERROR_LIMIT'), 10000)) THEN

Line 4857: INSERT into hz_imp_errors (

4853: ELSE
4854: x_return_status := 'E';
4855:
4856: FORALL i in l_party_id.first..l_party_id.last
4857: INSERT into hz_imp_errors (
4858: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id,
4859: program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
4860: token1_name, token1_value)
4861: values (

Line 4863: P_PROGRAM_ID, l_sysdate, HZ_IMP_ERRORS_S.NextVal, P_BATCH_ID, P_REQUEST_ID, 'HZ_IMP_PARTIES_INT',

4859: program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
4860: token1_name, token1_value)
4861: values (
4862: l_sysdate, P_USER_ID, l_sysdate, P_USER_ID, P_LAST_UPDATE_LOGIN, P_PROGRAM_APPLICATION_ID,
4863: P_PROGRAM_ID, l_sysdate, HZ_IMP_ERRORS_S.NextVal, P_BATCH_ID, P_REQUEST_ID, 'HZ_IMP_PARTIES_INT',
4864: 'HZ_IMP_INVALID_PARTY_ID','PARTY_ID',l_party_id(i))
4865: RETURNING error_id BULK COLLECT INTO l_error_id;
4866:
4867: