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.

APPS.HZ_STAGE_MAP_TRANSFORM dependencies on HZ_DQM_SYNC_INTERFACE

Line 402: INSERT INTO hz_dqm_sync_interface (

398: p_realtime_sync_flag IN VARCHAR2 DEFAULT 'Y',
399: p_error_data IN VARCHAR2
400: ) IS
401: BEGIN
402: INSERT INTO hz_dqm_sync_interface (
403: PARTY_ID,
404: RECORD_ID,
405: PARTY_SITE_ID,
406: ORG_CONTACT_ID,

Line 433: HZ_DQM_SYNC_INTERFACE_S.nextval

429: hz_utility_pub.creation_date,
430: hz_utility_pub.last_update_login,
431: hz_utility_pub.last_update_date,
432: hz_utility_pub.user_id,
433: HZ_DQM_SYNC_INTERFACE_S.nextval
434: );
435: END insert_dqm_sync_error_rec;
436:
437:

Line 1091: -- FAILOVER : REPORT RECORD TO HZ_DQM_SYNC_INTERFACE

1087: EXIT WHEN c_contact%NOTFOUND;
1088: BEGIN
1089: sync_single_contact_online(l_org_contact_id, p_operation);
1090: EXCEPTION WHEN OTHERS THEN
1091: -- FAILOVER : REPORT RECORD TO HZ_DQM_SYNC_INTERFACE
1092: -- FOR ONLINE FLOWS
1093: l_sql_err_message := SQLERRM;
1094: insert_dqm_sync_error_rec(p_party_id,l_org_contact_id,null,null,'CONTACTS','U','E','Y', l_sql_err_message);
1095: END ;

Line 1376: -- FAILOVER : REPORT RECORD TO HZ_DQM_SYNC_INTERFACE

1372: END;
1373: END IF;
1374:
1375: EXCEPTION WHEN OTHERS THEN
1376: -- FAILOVER : REPORT RECORD TO HZ_DQM_SYNC_INTERFACE
1377: -- FOR ONLINE FLOWS
1378: l_sql_err_message := SQLERRM;
1379: insert_dqm_sync_error_rec(p_party_id, NULL, NULL, NULL, 'PARTY', p_operation, 'E', 'Y', l_sql_err_message);
1380: END;

Line 1520: FROM HZ_ORG_CONTACTS oc, HZ_DQM_SYNC_INTERFACE d,

1516: INTO H_ORG_CONTACT_ID(1), H_PARTY_ID(1), H_STATUS(1)
1517: , H_TX2(1)
1518: , H_TX11(1)
1519: , H_TX22(1)
1520: FROM HZ_ORG_CONTACTS oc, HZ_DQM_SYNC_INTERFACE d,
1521: HZ_RELATIONSHIPS r, HZ_PERSON_PROFILES pp
1522: WHERE d.ENTITY = 'CONTACTS'
1523: AND oc.org_contact_id = p_org_contact_id
1524: AND oc.org_contact_id = d.RECORD_ID

Line 1773: -- FAILOVER : REPORT RECORD TO HZ_DQM_SYNC_INTERFACE

1769: END;
1770: END IF;
1771:
1772: EXCEPTION WHEN OTHERS THEN
1773: -- FAILOVER : REPORT RECORD TO HZ_DQM_SYNC_INTERFACE
1774: -- FOR ONLINE FLOWS
1775: l_sql_err_message := SQLERRM;
1776: insert_dqm_sync_error_rec(l_party_id, p_org_contact_id, NULL, NULL, 'CONTACTS', p_operation, 'E', 'Y', l_sql_err_message);
1777: END;

Line 1964: FROM HZ_CONTACT_POINTS cp, HZ_DQM_SYNC_INTERFACE d

1960: , H_TX10(1)
1961: , H_TX11(1)
1962: , H_TX12(1)
1963: , H_TX13(1)
1964: FROM HZ_CONTACT_POINTS cp, HZ_DQM_SYNC_INTERFACE d
1965: WHERE d.ENTITY = 'CONTACT_POINTS'
1966: AND cp.contact_point_id = p_contact_point_id
1967: AND cp.contact_point_id = d.RECORD_ID
1968: AND (cp.status is null OR cp.status = 'A' or cp.status = 'I') and rownum = 1 ;

Line 2327: -- FAILOVER : REPORT RECORD TO HZ_DQM_SYNC_INTERFACE

2323: END;
2324: END IF;
2325:
2326: EXCEPTION WHEN OTHERS THEN
2327: -- FAILOVER : REPORT RECORD TO HZ_DQM_SYNC_INTERFACE
2328: -- FOR ONLINE FLOWS
2329: l_sql_err_message := SQLERRM;
2330: insert_dqm_sync_error_rec(l_party_id, p_contact_point_id, l_party_site_id, l_org_contact_id, 'CONTACT_POINTS', p_operation, 'E', 'Y', l_sql_err_message);
2331: END;

Line 2551: FROM HZ_PARTY_SITES ps, HZ_DQM_SYNC_INTERFACE d, HZ_LOCATIONS l

2547: , H_TX22(1)
2548: , H_TX24(1)
2549: , H_TX25(1)
2550: , H_TX28(1)
2551: FROM HZ_PARTY_SITES ps, HZ_DQM_SYNC_INTERFACE d, HZ_LOCATIONS l
2552: WHERE d.ENTITY='PARTY_SITES'
2553: AND ps.party_site_id = p_party_site_id
2554: AND d.record_id = ps.party_site_id
2555: AND ps.location_id = l.location_id

Line 2945: -- FAILOVER : REPORT RECORD TO HZ_DQM_SYNC_INTERFACE

2941: END;
2942: END IF;
2943:
2944: EXCEPTION WHEN OTHERS THEN
2945: -- FAILOVER : REPORT RECORD TO HZ_DQM_SYNC_INTERFACE
2946: -- FOR ONLINE FLOWS
2947: l_sql_err_message := SQLERRM;
2948: insert_dqm_sync_error_rec(l_party_id, p_party_site_id, NULL, l_org_contact_id, 'PARTY_SITES', p_operation, 'E', 'Y', l_sql_err_message);
2949: END;

Line 2976: FROM HZ_PARTIES p, HZ_ORGANIZATION_PROFILES op, HZ_DQM_SYNC_INTERFACE dsi

2972: ,op.SIC_CODE_TYPE
2973: ,p.CATEGORY_CODE
2974: ,p.REFERENCE_USE_FLAG
2975: ,op.CORPORATION_CLASS
2976: FROM HZ_PARTIES p, HZ_ORGANIZATION_PROFILES op, HZ_DQM_SYNC_INTERFACE dsi
2977: WHERE p.party_id = op.party_id
2978: AND p.party_id = dsi.party_id
2979: AND p.PARTY_TYPE = 'ORGANIZATION'
2980: AND dsi.entity = 'PARTY'

Line 3002: FROM HZ_PARTIES p, HZ_PERSON_PROFILES pe, HZ_DQM_SYNC_INTERFACE dsi

2998: ,NULL
2999: ,p.CATEGORY_CODE
3000: ,p.REFERENCE_USE_FLAG
3001: ,NULL
3002: FROM HZ_PARTIES p, HZ_PERSON_PROFILES pe, HZ_DQM_SYNC_INTERFACE dsi
3003: WHERE p.party_id = pe.party_id
3004: AND p.party_id = dsi.party_id
3005: AND p.PARTY_TYPE = 'PERSON'
3006: AND dsi.entity = 'PARTY'

Line 3028: FROM HZ_PARTIES p, HZ_DQM_SYNC_INTERFACE dsi

3024: ,NULL
3025: ,p.CATEGORY_CODE
3026: ,p.REFERENCE_USE_FLAG
3027: ,NULL
3028: FROM HZ_PARTIES p, HZ_DQM_SYNC_INTERFACE dsi
3029: WHERE p.party_id = dsi.party_id
3030: AND dsi.entity = 'PARTY'
3031: AND dsi.staged_flag = 'N'
3032: AND dsi.operation = p_operation

Line 3210: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE ENTITY='PARTY' AND OPERATION='C' AND PARTY_ID=H_P_PARTY_ID(l_err_index);

3206: l_err_index := SQL%BULK_EXCEPTIONS(indx).ERROR_INDEX;
3207: l_sql_errm := sqlerrm(-SQL%BULK_EXCEPTIONS(indx).ERROR_CODE);
3208: IF (instr(l_sql_errm,'ORA-00001')>0) THEN
3209: log ('Exception DUP_VAL_ON_INDEX occured while inserting Party with PARTY_ID - '||H_P_PARTY_ID(l_err_index));
3210: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE ENTITY='PARTY' AND OPERATION='C' AND PARTY_ID=H_P_PARTY_ID(l_err_index);
3211: ELSE
3212: IF p_bulk_sync_type = 'DQM_SYNC' THEN
3213: UPDATE hz_dqm_sync_interface
3214: SET error_data = l_sql_errm

Line 3213: UPDATE hz_dqm_sync_interface

3209: log ('Exception DUP_VAL_ON_INDEX occured while inserting Party with PARTY_ID - '||H_P_PARTY_ID(l_err_index));
3210: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE ENTITY='PARTY' AND OPERATION='C' AND PARTY_ID=H_P_PARTY_ID(l_err_index);
3211: ELSE
3212: IF p_bulk_sync_type = 'DQM_SYNC' THEN
3213: UPDATE hz_dqm_sync_interface
3214: SET error_data = l_sql_errm
3215: ,staged_flag = decode (error_data, NULL, 'N', 'E')
3216: WHERE rowid = H_ROWID(l_err_index);
3217: ELSIF p_bulk_sync_type = 'IMPORT_SYNC' THEN

Line 3218: -- Insert the Error Record into HZ_DQM_SYNC_INTERFACE table

3214: SET error_data = l_sql_errm
3215: ,staged_flag = decode (error_data, NULL, 'N', 'E')
3216: WHERE rowid = H_ROWID(l_err_index);
3217: ELSIF p_bulk_sync_type = 'IMPORT_SYNC' THEN
3218: -- Insert the Error Record into HZ_DQM_SYNC_INTERFACE table
3219: insert_dqm_sync_error_rec(H_P_PARTY_ID(l_err_index), NULL, NULL, NULL, 'PARTY', p_operation, 'E', 'N', l_sql_errm);
3220: END IF;
3221: END IF;
3222: END LOOP;

Line 3267: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE ENTITY='PARTY' AND OPERATION='U' AND PARTY_ID=H_P_PARTY_ID(l_err_index);

3263: l_err_index := SQL%BULK_EXCEPTIONS(indx).ERROR_INDEX;
3264: l_sql_errm := sqlerrm(-SQL%BULK_EXCEPTIONS(indx).ERROR_CODE);
3265: IF (instr(l_sql_errm,'ORA-00001')>0) THEN
3266: log ('Exception DUP_VAL_ON_INDEX occured while inserting Party with PARTY_ID - '||H_P_PARTY_ID(l_err_index));
3267: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE ENTITY='PARTY' AND OPERATION='U' AND PARTY_ID=H_P_PARTY_ID(l_err_index);
3268: ELSE
3269: IF p_bulk_sync_type = 'DQM_SYNC' THEN
3270: UPDATE hz_dqm_sync_interface
3271: SET error_data = l_sql_errm

Line 3270: UPDATE hz_dqm_sync_interface

3266: log ('Exception DUP_VAL_ON_INDEX occured while inserting Party with PARTY_ID - '||H_P_PARTY_ID(l_err_index));
3267: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE ENTITY='PARTY' AND OPERATION='U' AND PARTY_ID=H_P_PARTY_ID(l_err_index);
3268: ELSE
3269: IF p_bulk_sync_type = 'DQM_SYNC' THEN
3270: UPDATE hz_dqm_sync_interface
3271: SET error_data = l_sql_errm
3272: ,staged_flag = decode (error_data, NULL, 'N', 'E')
3273: WHERE rowid = H_ROWID(l_err_index);
3274: ELSIF p_bulk_sync_type = 'IMPORT_SYNC' THEN

Line 3275: -- Insert the Error Record into HZ_DQM_SYNC_INTERFACE table

3271: SET error_data = l_sql_errm
3272: ,staged_flag = decode (error_data, NULL, 'N', 'E')
3273: WHERE rowid = H_ROWID(l_err_index);
3274: ELSIF p_bulk_sync_type = 'IMPORT_SYNC' THEN
3275: -- Insert the Error Record into HZ_DQM_SYNC_INTERFACE table
3276: insert_dqm_sync_error_rec(H_P_PARTY_ID(l_err_index), NULL, NULL, NULL, 'PARTY', p_operation, 'E', 'N', l_sql_errm);
3277: END IF;
3278: END IF;
3279: END LOOP;

Line 3377: FROM HZ_DQM_SYNC_INTERFACE dsi, HZ_PARTY_SITES ps, HZ_LOCATIONS l

3373: ,l.COUNTRY
3374: ,ps.IDENTIFYING_ADDRESS_FLAG
3375: ,ps.STATUS
3376: ,l.ADDRESS1
3377: FROM HZ_DQM_SYNC_INTERFACE dsi, HZ_PARTY_SITES ps, HZ_LOCATIONS l
3378: WHERE dsi.record_id = ps.party_site_id
3379: AND dsi.entity = 'PARTY_SITES'
3380: AND dsi.operation = p_operation
3381: AND dsi.staged_flag = 'N'

Line 3540: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE ENTITY='PARTY_SITES' AND OPERATION='C' AND RECORD_ID=H_PARTY_SITE_ID(l_err_index);

3536: l_err_index := SQL%BULK_EXCEPTIONS(indx).ERROR_INDEX;
3537: l_sql_errm := sqlerrm(-SQL%BULK_EXCEPTIONS(indx).ERROR_CODE);
3538: IF (instr(l_sql_errm,'ORA-00001')>0) THEN
3539: log ('Exception DUP_VAL_ON_INDEX occured while inserting Party Site with PARTY_SITE_ID - '||H_PARTY_SITE_ID(l_err_index));
3540: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE ENTITY='PARTY_SITES' AND OPERATION='C' AND RECORD_ID=H_PARTY_SITE_ID(l_err_index);
3541: ELSE
3542: IF p_bulk_sync_type = 'DQM_SYNC' THEN
3543: UPDATE hz_dqm_sync_interface
3544: SET error_data = l_sql_errm

Line 3543: UPDATE hz_dqm_sync_interface

3539: log ('Exception DUP_VAL_ON_INDEX occured while inserting Party Site with PARTY_SITE_ID - '||H_PARTY_SITE_ID(l_err_index));
3540: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE ENTITY='PARTY_SITES' AND OPERATION='C' AND RECORD_ID=H_PARTY_SITE_ID(l_err_index);
3541: ELSE
3542: IF p_bulk_sync_type = 'DQM_SYNC' THEN
3543: UPDATE hz_dqm_sync_interface
3544: SET error_data = l_sql_errm
3545: ,staged_flag = decode (error_data, NULL, 'N', 'E')
3546: WHERE rowid = H_ROWID(l_err_index);
3547: ELSIF p_bulk_sync_type = 'IMPORT_SYNC' THEN

Line 3548: -- Insert the Error Record into HZ_DQM_SYNC_INTERFACE table

3544: SET error_data = l_sql_errm
3545: ,staged_flag = decode (error_data, NULL, 'N', 'E')
3546: WHERE rowid = H_ROWID(l_err_index);
3547: ELSIF p_bulk_sync_type = 'IMPORT_SYNC' THEN
3548: -- Insert the Error Record into HZ_DQM_SYNC_INTERFACE table
3549: insert_dqm_sync_error_rec(H_PS_PARTY_ID(l_err_index), H_PARTY_SITE_ID(l_err_index), NULL, H_PS_ORG_CONTACT_ID(l_err_index), 'PARTY_SITES', p_operation, 'E', 'N', l_sql_errm);
3550: END IF;
3551: END IF;
3552: END LOOP;

Line 3592: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE ENTITY='PARTY_SITES' AND OPERATION='U' AND RECORD_ID=H_PARTY_SITE_ID(l_err_index);

3588: l_err_index := SQL%BULK_EXCEPTIONS(indx).ERROR_INDEX;
3589: l_sql_errm := sqlerrm(-SQL%BULK_EXCEPTIONS(indx).ERROR_CODE);
3590: IF (instr(l_sql_errm,'ORA-00001')>0) THEN
3591: log ('Exception DUP_VAL_ON_INDEX occured while inserting Party Site with PARTY_SITE_ID - '||H_PARTY_SITE_ID(l_err_index));
3592: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE ENTITY='PARTY_SITES' AND OPERATION='U' AND RECORD_ID=H_PARTY_SITE_ID(l_err_index);
3593: ELSE
3594: IF p_bulk_sync_type = 'DQM_SYNC' THEN
3595: UPDATE hz_dqm_sync_interface
3596: SET error_data = l_sql_errm

Line 3595: UPDATE hz_dqm_sync_interface

3591: log ('Exception DUP_VAL_ON_INDEX occured while inserting Party Site with PARTY_SITE_ID - '||H_PARTY_SITE_ID(l_err_index));
3592: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE ENTITY='PARTY_SITES' AND OPERATION='U' AND RECORD_ID=H_PARTY_SITE_ID(l_err_index);
3593: ELSE
3594: IF p_bulk_sync_type = 'DQM_SYNC' THEN
3595: UPDATE hz_dqm_sync_interface
3596: SET error_data = l_sql_errm
3597: ,staged_flag = decode (error_data, NULL, 'N', 'E')
3598: WHERE rowid = H_ROWID(l_err_index);
3599: ELSIF p_bulk_sync_type = 'IMPORT_SYNC' THEN

Line 3600: -- Insert the Error Record into HZ_DQM_SYNC_INTERFACE table

3596: SET error_data = l_sql_errm
3597: ,staged_flag = decode (error_data, NULL, 'N', 'E')
3598: WHERE rowid = H_ROWID(l_err_index);
3599: ELSIF p_bulk_sync_type = 'IMPORT_SYNC' THEN
3600: -- Insert the Error Record into HZ_DQM_SYNC_INTERFACE table
3601: insert_dqm_sync_error_rec(H_PS_PARTY_ID(l_err_index), H_PARTY_SITE_ID(l_err_index), NULL, H_PS_ORG_CONTACT_ID(l_err_index), 'PARTY_SITES', p_operation, 'E', 'N', l_sql_errm);
3602: END IF;
3603: END IF;
3604: END LOOP;

Line 3710: FROM HZ_DQM_SYNC_INTERFACE dsi, HZ_RELATIONSHIPS r,

3706: ,dsi.ROWID
3707: ,rtrim(pp.person_first_name || ' ' || pp.person_last_name)
3708: ,oc.CONTACT_NUMBER
3709: ,oc.JOB_TITLE
3710: FROM HZ_DQM_SYNC_INTERFACE dsi, HZ_RELATIONSHIPS r,
3711: HZ_ORG_CONTACTS oc, HZ_PERSON_PROFILES pp
3712: WHERE oc.party_relationship_id = r.relationship_id
3713: AND dsi.record_id = oc.org_contact_id
3714: AND r.subject_id = pp.party_id

Line 3829: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE ENTITY='CONTACTS' AND OPERATION='C' AND RECORD_ID=H_ORG_CONTACT_ID(l_err_index);

3825: l_err_index := SQL%BULK_EXCEPTIONS(indx).ERROR_INDEX;
3826: l_sql_errm := sqlerrm(-SQL%BULK_EXCEPTIONS(indx).ERROR_CODE);
3827: IF (instr(l_sql_errm,'ORA-00001')>0) THEN
3828: log ('Exception DUP_VAL_ON_INDEX occured while inserting a Contact with ORG_CONTACT_ID - '||H_ORG_CONTACT_ID(l_err_index));
3829: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE ENTITY='CONTACTS' AND OPERATION='C' AND RECORD_ID=H_ORG_CONTACT_ID(l_err_index);
3830: ELSE
3831: IF p_bulk_sync_type = 'DQM_SYNC' THEN
3832: UPDATE hz_dqm_sync_interface
3833: SET error_data = l_sql_errm

Line 3832: UPDATE hz_dqm_sync_interface

3828: log ('Exception DUP_VAL_ON_INDEX occured while inserting a Contact with ORG_CONTACT_ID - '||H_ORG_CONTACT_ID(l_err_index));
3829: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE ENTITY='CONTACTS' AND OPERATION='C' AND RECORD_ID=H_ORG_CONTACT_ID(l_err_index);
3830: ELSE
3831: IF p_bulk_sync_type = 'DQM_SYNC' THEN
3832: UPDATE hz_dqm_sync_interface
3833: SET error_data = l_sql_errm
3834: ,staged_flag = decode (error_data, NULL, 'N', 'E')
3835: WHERE rowid = H_ROWID(l_err_index);
3836: ELSIF p_bulk_sync_type = 'IMPORT_SYNC' THEN

Line 3837: -- Insert the Error Record into HZ_DQM_SYNC_INTERFACE table

3833: SET error_data = l_sql_errm
3834: ,staged_flag = decode (error_data, NULL, 'N', 'E')
3835: WHERE rowid = H_ROWID(l_err_index);
3836: ELSIF p_bulk_sync_type = 'IMPORT_SYNC' THEN
3837: -- Insert the Error Record into HZ_DQM_SYNC_INTERFACE table
3838: insert_dqm_sync_error_rec(H_C_PARTY_ID(l_err_index), H_ORG_CONTACT_ID(l_err_index), NULL, NULL, 'CONTACTS', p_operation, 'E', 'N', l_sql_errm);
3839: END IF;
3840: END IF;
3841: END LOOP;

Line 3868: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE ENTITY='CONTACTS' AND OPERATION='U' AND RECORD_ID=H_ORG_CONTACT_ID(l_err_index);

3864: l_err_index := SQL%BULK_EXCEPTIONS(indx).ERROR_INDEX;
3865: l_sql_errm := sqlerrm(-SQL%BULK_EXCEPTIONS(indx).ERROR_CODE);
3866: IF (instr(l_sql_errm,'ORA-00001')>0) THEN
3867: log ('Exception DUP_VAL_ON_INDEX occured while inserting a Contact with ORG_CONTACT_ID - '||H_ORG_CONTACT_ID(l_err_index));
3868: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE ENTITY='CONTACTS' AND OPERATION='U' AND RECORD_ID=H_ORG_CONTACT_ID(l_err_index);
3869: ELSE
3870: IF p_bulk_sync_type = 'DQM_SYNC' THEN
3871: UPDATE hz_dqm_sync_interface
3872: SET error_data = l_sql_errm

Line 3871: UPDATE hz_dqm_sync_interface

3867: log ('Exception DUP_VAL_ON_INDEX occured while inserting a Contact with ORG_CONTACT_ID - '||H_ORG_CONTACT_ID(l_err_index));
3868: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE ENTITY='CONTACTS' AND OPERATION='U' AND RECORD_ID=H_ORG_CONTACT_ID(l_err_index);
3869: ELSE
3870: IF p_bulk_sync_type = 'DQM_SYNC' THEN
3871: UPDATE hz_dqm_sync_interface
3872: SET error_data = l_sql_errm
3873: ,staged_flag = decode (error_data, NULL, 'N', 'E')
3874: WHERE rowid = H_ROWID(l_err_index);
3875: ELSIF p_bulk_sync_type = 'IMPORT_SYNC' THEN

Line 3876: -- Insert the Error Record into HZ_DQM_SYNC_INTERFACE table

3872: SET error_data = l_sql_errm
3873: ,staged_flag = decode (error_data, NULL, 'N', 'E')
3874: WHERE rowid = H_ROWID(l_err_index);
3875: ELSIF p_bulk_sync_type = 'IMPORT_SYNC' THEN
3876: -- Insert the Error Record into HZ_DQM_SYNC_INTERFACE table
3877: insert_dqm_sync_error_rec(H_C_PARTY_ID(l_err_index), H_ORG_CONTACT_ID(l_err_index), NULL, NULL, 'CONTACTS', p_operation, 'E', 'N', l_sql_errm);
3878: END IF;
3879: END IF;
3880: END LOOP;

Line 3994: FROM HZ_DQM_SYNC_INTERFACE dsi,HZ_CONTACT_POINTS cp

3990: ,translate(phone_country_code|| ' ' || phone_area_code||' ' || phone_number,'0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz!"#$%&()''*+,-./:;<=>?@[\]^_`{|}~ ','0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZ')
3991: ,cp.PHONE_LINE_TYPE
3992: ,cp.STATUS
3993: ,cp.CONTACT_POINT_PURPOSE
3994: FROM HZ_DQM_SYNC_INTERFACE dsi,HZ_CONTACT_POINTS cp
3995: WHERE dsi.record_id = cp.contact_point_id
3996: AND dsi.entity = 'CONTACT_POINTS'
3997: AND dsi.operation = p_operation
3998: AND dsi.staged_flag = 'N'

Line 4138: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE ENTITY='CONTACT_POINTS' AND OPERATION='C' AND RECORD_ID=H_CONTACT_POINT_ID(l_err_index);

4134: l_err_index := SQL%BULK_EXCEPTIONS(indx).ERROR_INDEX;
4135: l_sql_errm := sqlerrm(-SQL%BULK_EXCEPTIONS(indx).ERROR_CODE);
4136: IF (instr(l_sql_errm,'ORA-00001')>0) THEN
4137: log ('Exception DUP_VAL_ON_INDEX occured while inserting a Contact Point with CONTACT_POINT_ID - '||H_CONTACT_POINT_ID(l_err_index));
4138: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE ENTITY='CONTACT_POINTS' AND OPERATION='C' AND RECORD_ID=H_CONTACT_POINT_ID(l_err_index);
4139: ELSE
4140: IF p_bulk_sync_type = 'DQM_SYNC' THEN
4141: UPDATE hz_dqm_sync_interface
4142: SET error_data = l_sql_errm

Line 4141: UPDATE hz_dqm_sync_interface

4137: log ('Exception DUP_VAL_ON_INDEX occured while inserting a Contact Point with CONTACT_POINT_ID - '||H_CONTACT_POINT_ID(l_err_index));
4138: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE ENTITY='CONTACT_POINTS' AND OPERATION='C' AND RECORD_ID=H_CONTACT_POINT_ID(l_err_index);
4139: ELSE
4140: IF p_bulk_sync_type = 'DQM_SYNC' THEN
4141: UPDATE hz_dqm_sync_interface
4142: SET error_data = l_sql_errm
4143: ,staged_flag = decode (error_data, NULL, 'N', 'E')
4144: WHERE rowid = H_ROWID(l_err_index);
4145: ELSIF p_bulk_sync_type = 'IMPORT_SYNC' THEN

Line 4146: -- Insert the Error Record into HZ_DQM_SYNC_INTERFACE table

4142: SET error_data = l_sql_errm
4143: ,staged_flag = decode (error_data, NULL, 'N', 'E')
4144: WHERE rowid = H_ROWID(l_err_index);
4145: ELSIF p_bulk_sync_type = 'IMPORT_SYNC' THEN
4146: -- Insert the Error Record into HZ_DQM_SYNC_INTERFACE table
4147: insert_dqm_sync_error_rec(H_CPT_PARTY_ID(l_err_index), H_CONTACT_POINT_ID(l_err_index), H_CPT_PARTY_SITE_ID(l_err_index), H_CPT_ORG_CONTACT_ID(l_err_index), 'CONTACT_POINTS', p_operation, 'E', 'N', l_sql_errm);
4148: END IF;
4149: END IF;
4150: END LOOP;

Line 4183: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE ENTITY='CONTACT_POINTS' AND OPERATION='U' AND RECORD_ID=H_CONTACT_POINT_ID(l_err_index);

4179: l_err_index := SQL%BULK_EXCEPTIONS(indx).ERROR_INDEX;
4180: l_sql_errm := sqlerrm(-SQL%BULK_EXCEPTIONS(indx).ERROR_CODE);
4181: IF (instr(l_sql_errm,'ORA-00001')>0) THEN
4182: log ('Exception DUP_VAL_ON_INDEX occured while inserting a Contact Point with CONTACT_POINT_ID - '||H_CONTACT_POINT_ID(l_err_index));
4183: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE ENTITY='CONTACT_POINTS' AND OPERATION='U' AND RECORD_ID=H_CONTACT_POINT_ID(l_err_index);
4184: ELSE
4185: IF p_bulk_sync_type = 'DQM_SYNC' THEN
4186: UPDATE hz_dqm_sync_interface
4187: SET error_data = l_sql_errm

Line 4186: UPDATE hz_dqm_sync_interface

4182: log ('Exception DUP_VAL_ON_INDEX occured while inserting a Contact Point with CONTACT_POINT_ID - '||H_CONTACT_POINT_ID(l_err_index));
4183: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE ENTITY='CONTACT_POINTS' AND OPERATION='U' AND RECORD_ID=H_CONTACT_POINT_ID(l_err_index);
4184: ELSE
4185: IF p_bulk_sync_type = 'DQM_SYNC' THEN
4186: UPDATE hz_dqm_sync_interface
4187: SET error_data = l_sql_errm
4188: ,staged_flag = decode (error_data, NULL, 'N', 'E')
4189: WHERE rowid = H_ROWID(l_err_index);
4190: ELSIF p_bulk_sync_type = 'IMPORT_SYNC' THEN

Line 4191: -- Insert the Error Record into HZ_DQM_SYNC_INTERFACE table

4187: SET error_data = l_sql_errm
4188: ,staged_flag = decode (error_data, NULL, 'N', 'E')
4189: WHERE rowid = H_ROWID(l_err_index);
4190: ELSIF p_bulk_sync_type = 'IMPORT_SYNC' THEN
4191: -- Insert the Error Record into HZ_DQM_SYNC_INTERFACE table
4192: insert_dqm_sync_error_rec(H_CPT_PARTY_ID(l_err_index), H_CONTACT_POINT_ID(l_err_index), H_CPT_PARTY_SITE_ID(l_err_index), H_CPT_ORG_CONTACT_ID(l_err_index), 'CONTACT_POINTS', p_operation, 'E', 'N', l_sql_errm);
4193: END IF;
4194: END IF;
4195: END LOOP;