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 426: INSERT INTO hz_dqm_sync_interface (

422: p_realtime_sync_flag IN VARCHAR2 DEFAULT 'Y',
423: p_error_data IN VARCHAR2
424: ) IS
425: BEGIN
426: INSERT INTO hz_dqm_sync_interface (
427: PARTY_ID,
428: RECORD_ID,
429: PARTY_SITE_ID,
430: ORG_CONTACT_ID,

Line 457: HZ_DQM_SYNC_INTERFACE_S.nextval

453: hz_utility_pub.creation_date,
454: hz_utility_pub.last_update_login,
455: hz_utility_pub.last_update_date,
456: hz_utility_pub.user_id,
457: HZ_DQM_SYNC_INTERFACE_S.nextval
458: );
459: END insert_dqm_sync_error_rec;
460:
461:

Line 1117: -- FAILOVER : REPORT RECORD TO HZ_DQM_SYNC_INTERFACE

1113: EXIT WHEN c_contact%NOTFOUND;
1114: BEGIN
1115: sync_single_contact_online(l_org_contact_id, p_operation);
1116: EXCEPTION WHEN OTHERS THEN
1117: -- FAILOVER : REPORT RECORD TO HZ_DQM_SYNC_INTERFACE
1118: -- FOR ONLINE FLOWS
1119: l_sql_err_message := SQLERRM;
1120: insert_dqm_sync_error_rec(p_party_id,l_org_contact_id,null,null,'CONTACTS','U','E','Y', l_sql_err_message);
1121: END ;

Line 1402: -- FAILOVER : REPORT RECORD TO HZ_DQM_SYNC_INTERFACE

1398: END;
1399: END IF;
1400:
1401: EXCEPTION WHEN OTHERS THEN
1402: -- FAILOVER : REPORT RECORD TO HZ_DQM_SYNC_INTERFACE
1403: -- FOR ONLINE FLOWS
1404: l_sql_err_message := SQLERRM;
1405: insert_dqm_sync_error_rec(p_party_id, NULL, NULL, NULL, 'PARTY', p_operation, 'E', 'Y', l_sql_err_message);
1406: END;

Line 1546: FROM HZ_ORG_CONTACTS oc, HZ_DQM_SYNC_INTERFACE d,

1542: INTO H_ORG_CONTACT_ID(1), H_PARTY_ID(1), H_STATUS(1)
1543: , H_TX2(1)
1544: , H_TX11(1)
1545: , H_TX22(1)
1546: FROM HZ_ORG_CONTACTS oc, HZ_DQM_SYNC_INTERFACE d,
1547: HZ_RELATIONSHIPS r, HZ_PERSON_PROFILES pp
1548: WHERE d.ENTITY = 'CONTACTS'
1549: AND oc.org_contact_id = p_org_contact_id
1550: AND oc.org_contact_id = d.RECORD_ID

Line 1799: -- FAILOVER : REPORT RECORD TO HZ_DQM_SYNC_INTERFACE

1795: END;
1796: END IF;
1797:
1798: EXCEPTION WHEN OTHERS THEN
1799: -- FAILOVER : REPORT RECORD TO HZ_DQM_SYNC_INTERFACE
1800: -- FOR ONLINE FLOWS
1801: l_sql_err_message := SQLERRM;
1802: insert_dqm_sync_error_rec(l_party_id, p_org_contact_id, NULL, NULL, 'CONTACTS', p_operation, 'E', 'Y', l_sql_err_message);
1803: END;

Line 1990: FROM HZ_CONTACT_POINTS cp, HZ_DQM_SYNC_INTERFACE d

1986: , H_TX10(1)
1987: , H_TX11(1)
1988: , H_TX12(1)
1989: , H_TX13(1)
1990: FROM HZ_CONTACT_POINTS cp, HZ_DQM_SYNC_INTERFACE d
1991: WHERE d.ENTITY = 'CONTACT_POINTS'
1992: AND cp.contact_point_id = p_contact_point_id
1993: AND cp.contact_point_id = d.RECORD_ID
1994: AND (cp.status is null OR cp.status = 'A' or cp.status = 'I') and rownum = 1 ;

Line 2353: -- FAILOVER : REPORT RECORD TO HZ_DQM_SYNC_INTERFACE

2349: END;
2350: END IF;
2351:
2352: EXCEPTION WHEN OTHERS THEN
2353: -- FAILOVER : REPORT RECORD TO HZ_DQM_SYNC_INTERFACE
2354: -- FOR ONLINE FLOWS
2355: l_sql_err_message := SQLERRM;
2356: 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);
2357: END;

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

2573: , H_TX22(1)
2574: , H_TX24(1)
2575: , H_TX25(1)
2576: , H_TX28(1)
2577: FROM HZ_PARTY_SITES ps, HZ_DQM_SYNC_INTERFACE d, HZ_LOCATIONS l
2578: WHERE d.ENTITY='PARTY_SITES'
2579: AND ps.party_site_id = p_party_site_id
2580: AND d.record_id = ps.party_site_id
2581: AND ps.location_id = l.location_id

Line 2971: -- FAILOVER : REPORT RECORD TO HZ_DQM_SYNC_INTERFACE

2967: END;
2968: END IF;
2969:
2970: EXCEPTION WHEN OTHERS THEN
2971: -- FAILOVER : REPORT RECORD TO HZ_DQM_SYNC_INTERFACE
2972: -- FOR ONLINE FLOWS
2973: l_sql_err_message := SQLERRM;
2974: 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);
2975: END;

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

2998: ,op.SIC_CODE_TYPE
2999: ,p.CATEGORY_CODE
3000: ,p.REFERENCE_USE_FLAG
3001: ,op.CORPORATION_CLASS
3002: FROM HZ_PARTIES p, HZ_ORGANIZATION_PROFILES op, HZ_DQM_SYNC_INTERFACE dsi
3003: WHERE p.party_id = op.party_id
3004: AND p.party_id = dsi.party_id
3005: AND p.PARTY_TYPE = 'ORGANIZATION'
3006: AND dsi.entity = 'PARTY'

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

3024: ,NULL
3025: ,p.CATEGORY_CODE
3026: ,p.REFERENCE_USE_FLAG
3027: ,NULL
3028: FROM HZ_PARTIES p, HZ_PERSON_PROFILES pe, HZ_DQM_SYNC_INTERFACE dsi
3029: WHERE p.party_id = pe.party_id
3030: AND p.party_id = dsi.party_id
3031: AND p.PARTY_TYPE = 'PERSON'
3032: AND dsi.entity = 'PARTY'

Line 3054: FROM HZ_PARTIES p, HZ_DQM_SYNC_INTERFACE dsi

3050: ,NULL
3051: ,p.CATEGORY_CODE
3052: ,p.REFERENCE_USE_FLAG
3053: ,NULL
3054: FROM HZ_PARTIES p, HZ_DQM_SYNC_INTERFACE dsi
3055: WHERE p.party_id = dsi.party_id
3056: AND dsi.entity = 'PARTY'
3057: AND dsi.staged_flag = 'N'
3058: AND dsi.operation = p_operation

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

3232: l_err_index := SQL%BULK_EXCEPTIONS(indx).ERROR_INDEX;
3233: l_sql_errm := sqlerrm(-SQL%BULK_EXCEPTIONS(indx).ERROR_CODE);
3234: IF (instr(l_sql_errm,'ORA-00001')>0) THEN
3235: log ('Exception DUP_VAL_ON_INDEX occured while inserting Party with PARTY_ID - '||H_P_PARTY_ID(l_err_index));
3236: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE ENTITY='PARTY' AND OPERATION='C' AND PARTY_ID=H_P_PARTY_ID(l_err_index);
3237: ELSE
3238: IF p_bulk_sync_type = 'DQM_SYNC' THEN
3239: UPDATE hz_dqm_sync_interface
3240: SET error_data = l_sql_errm

Line 3239: UPDATE hz_dqm_sync_interface

3235: log ('Exception DUP_VAL_ON_INDEX occured while inserting Party with PARTY_ID - '||H_P_PARTY_ID(l_err_index));
3236: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE ENTITY='PARTY' AND OPERATION='C' AND PARTY_ID=H_P_PARTY_ID(l_err_index);
3237: ELSE
3238: IF p_bulk_sync_type = 'DQM_SYNC' THEN
3239: UPDATE hz_dqm_sync_interface
3240: SET error_data = l_sql_errm
3241: ,staged_flag = decode (error_data, NULL, 'N', 'E')
3242: WHERE rowid = H_ROWID(l_err_index);
3243: ELSIF p_bulk_sync_type = 'IMPORT_SYNC' THEN

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

3240: SET error_data = l_sql_errm
3241: ,staged_flag = decode (error_data, NULL, 'N', 'E')
3242: WHERE rowid = H_ROWID(l_err_index);
3243: ELSIF p_bulk_sync_type = 'IMPORT_SYNC' THEN
3244: -- Insert the Error Record into HZ_DQM_SYNC_INTERFACE table
3245: insert_dqm_sync_error_rec(H_P_PARTY_ID(l_err_index), NULL, NULL, NULL, 'PARTY', p_operation, 'E', 'N', l_sql_errm);
3246: END IF;
3247: END IF;
3248: END LOOP;

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

3289: l_err_index := SQL%BULK_EXCEPTIONS(indx).ERROR_INDEX;
3290: l_sql_errm := sqlerrm(-SQL%BULK_EXCEPTIONS(indx).ERROR_CODE);
3291: IF (instr(l_sql_errm,'ORA-00001')>0) THEN
3292: log ('Exception DUP_VAL_ON_INDEX occured while inserting Party with PARTY_ID - '||H_P_PARTY_ID(l_err_index));
3293: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE ENTITY='PARTY' AND OPERATION='U' AND PARTY_ID=H_P_PARTY_ID(l_err_index);
3294: ELSE
3295: IF p_bulk_sync_type = 'DQM_SYNC' THEN
3296: UPDATE hz_dqm_sync_interface
3297: SET error_data = l_sql_errm

Line 3296: UPDATE hz_dqm_sync_interface

3292: log ('Exception DUP_VAL_ON_INDEX occured while inserting Party with PARTY_ID - '||H_P_PARTY_ID(l_err_index));
3293: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE ENTITY='PARTY' AND OPERATION='U' AND PARTY_ID=H_P_PARTY_ID(l_err_index);
3294: ELSE
3295: IF p_bulk_sync_type = 'DQM_SYNC' THEN
3296: UPDATE hz_dqm_sync_interface
3297: SET error_data = l_sql_errm
3298: ,staged_flag = decode (error_data, NULL, 'N', 'E')
3299: WHERE rowid = H_ROWID(l_err_index);
3300: ELSIF p_bulk_sync_type = 'IMPORT_SYNC' THEN

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

3297: SET error_data = l_sql_errm
3298: ,staged_flag = decode (error_data, NULL, 'N', 'E')
3299: WHERE rowid = H_ROWID(l_err_index);
3300: ELSIF p_bulk_sync_type = 'IMPORT_SYNC' THEN
3301: -- Insert the Error Record into HZ_DQM_SYNC_INTERFACE table
3302: insert_dqm_sync_error_rec(H_P_PARTY_ID(l_err_index), NULL, NULL, NULL, 'PARTY', p_operation, 'E', 'N', l_sql_errm);
3303: END IF;
3304: END IF;
3305: END LOOP;

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

3399: ,l.COUNTRY
3400: ,ps.IDENTIFYING_ADDRESS_FLAG
3401: ,ps.STATUS
3402: ,l.ADDRESS1
3403: FROM HZ_DQM_SYNC_INTERFACE dsi, HZ_PARTY_SITES ps, HZ_LOCATIONS l
3404: WHERE dsi.record_id = ps.party_site_id
3405: AND dsi.entity = 'PARTY_SITES'
3406: AND dsi.operation = p_operation
3407: AND dsi.staged_flag = 'N'

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

3562: l_err_index := SQL%BULK_EXCEPTIONS(indx).ERROR_INDEX;
3563: l_sql_errm := sqlerrm(-SQL%BULK_EXCEPTIONS(indx).ERROR_CODE);
3564: IF (instr(l_sql_errm,'ORA-00001')>0) THEN
3565: log ('Exception DUP_VAL_ON_INDEX occured while inserting Party Site with PARTY_SITE_ID - '||H_PARTY_SITE_ID(l_err_index));
3566: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE ENTITY='PARTY_SITES' AND OPERATION='C' AND RECORD_ID=H_PARTY_SITE_ID(l_err_index);
3567: ELSE
3568: IF p_bulk_sync_type = 'DQM_SYNC' THEN
3569: UPDATE hz_dqm_sync_interface
3570: SET error_data = l_sql_errm

Line 3569: UPDATE hz_dqm_sync_interface

3565: log ('Exception DUP_VAL_ON_INDEX occured while inserting Party Site with PARTY_SITE_ID - '||H_PARTY_SITE_ID(l_err_index));
3566: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE ENTITY='PARTY_SITES' AND OPERATION='C' AND RECORD_ID=H_PARTY_SITE_ID(l_err_index);
3567: ELSE
3568: IF p_bulk_sync_type = 'DQM_SYNC' THEN
3569: UPDATE hz_dqm_sync_interface
3570: SET error_data = l_sql_errm
3571: ,staged_flag = decode (error_data, NULL, 'N', 'E')
3572: WHERE rowid = H_ROWID(l_err_index);
3573: ELSIF p_bulk_sync_type = 'IMPORT_SYNC' THEN

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

3570: SET error_data = l_sql_errm
3571: ,staged_flag = decode (error_data, NULL, 'N', 'E')
3572: WHERE rowid = H_ROWID(l_err_index);
3573: ELSIF p_bulk_sync_type = 'IMPORT_SYNC' THEN
3574: -- Insert the Error Record into HZ_DQM_SYNC_INTERFACE table
3575: 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);
3576: END IF;
3577: END IF;
3578: END LOOP;

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

3614: l_err_index := SQL%BULK_EXCEPTIONS(indx).ERROR_INDEX;
3615: l_sql_errm := sqlerrm(-SQL%BULK_EXCEPTIONS(indx).ERROR_CODE);
3616: IF (instr(l_sql_errm,'ORA-00001')>0) THEN
3617: log ('Exception DUP_VAL_ON_INDEX occured while inserting Party Site with PARTY_SITE_ID - '||H_PARTY_SITE_ID(l_err_index));
3618: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE ENTITY='PARTY_SITES' AND OPERATION='U' AND RECORD_ID=H_PARTY_SITE_ID(l_err_index);
3619: ELSE
3620: IF p_bulk_sync_type = 'DQM_SYNC' THEN
3621: UPDATE hz_dqm_sync_interface
3622: SET error_data = l_sql_errm

Line 3621: UPDATE hz_dqm_sync_interface

3617: log ('Exception DUP_VAL_ON_INDEX occured while inserting Party Site with PARTY_SITE_ID - '||H_PARTY_SITE_ID(l_err_index));
3618: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE ENTITY='PARTY_SITES' AND OPERATION='U' AND RECORD_ID=H_PARTY_SITE_ID(l_err_index);
3619: ELSE
3620: IF p_bulk_sync_type = 'DQM_SYNC' THEN
3621: UPDATE hz_dqm_sync_interface
3622: SET error_data = l_sql_errm
3623: ,staged_flag = decode (error_data, NULL, 'N', 'E')
3624: WHERE rowid = H_ROWID(l_err_index);
3625: ELSIF p_bulk_sync_type = 'IMPORT_SYNC' THEN

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

3622: SET error_data = l_sql_errm
3623: ,staged_flag = decode (error_data, NULL, 'N', 'E')
3624: WHERE rowid = H_ROWID(l_err_index);
3625: ELSIF p_bulk_sync_type = 'IMPORT_SYNC' THEN
3626: -- Insert the Error Record into HZ_DQM_SYNC_INTERFACE table
3627: 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);
3628: END IF;
3629: END IF;
3630: END LOOP;

Line 3736: FROM HZ_DQM_SYNC_INTERFACE dsi, HZ_RELATIONSHIPS r,

3732: ,dsi.ROWID
3733: ,rtrim(pp.person_first_name || ' ' || pp.person_last_name)
3734: ,oc.CONTACT_NUMBER
3735: ,oc.JOB_TITLE
3736: FROM HZ_DQM_SYNC_INTERFACE dsi, HZ_RELATIONSHIPS r,
3737: HZ_ORG_CONTACTS oc, HZ_PERSON_PROFILES pp
3738: WHERE oc.party_relationship_id = r.relationship_id
3739: AND dsi.record_id = oc.org_contact_id
3740: AND r.subject_id = pp.party_id

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

3851: l_err_index := SQL%BULK_EXCEPTIONS(indx).ERROR_INDEX;
3852: l_sql_errm := sqlerrm(-SQL%BULK_EXCEPTIONS(indx).ERROR_CODE);
3853: IF (instr(l_sql_errm,'ORA-00001')>0) THEN
3854: log ('Exception DUP_VAL_ON_INDEX occured while inserting a Contact with ORG_CONTACT_ID - '||H_ORG_CONTACT_ID(l_err_index));
3855: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE ENTITY='CONTACTS' AND OPERATION='C' AND RECORD_ID=H_ORG_CONTACT_ID(l_err_index);
3856: ELSE
3857: IF p_bulk_sync_type = 'DQM_SYNC' THEN
3858: UPDATE hz_dqm_sync_interface
3859: SET error_data = l_sql_errm

Line 3858: UPDATE hz_dqm_sync_interface

3854: log ('Exception DUP_VAL_ON_INDEX occured while inserting a Contact with ORG_CONTACT_ID - '||H_ORG_CONTACT_ID(l_err_index));
3855: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE ENTITY='CONTACTS' AND OPERATION='C' AND RECORD_ID=H_ORG_CONTACT_ID(l_err_index);
3856: ELSE
3857: IF p_bulk_sync_type = 'DQM_SYNC' THEN
3858: UPDATE hz_dqm_sync_interface
3859: SET error_data = l_sql_errm
3860: ,staged_flag = decode (error_data, NULL, 'N', 'E')
3861: WHERE rowid = H_ROWID(l_err_index);
3862: ELSIF p_bulk_sync_type = 'IMPORT_SYNC' THEN

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

3859: SET error_data = l_sql_errm
3860: ,staged_flag = decode (error_data, NULL, 'N', 'E')
3861: WHERE rowid = H_ROWID(l_err_index);
3862: ELSIF p_bulk_sync_type = 'IMPORT_SYNC' THEN
3863: -- Insert the Error Record into HZ_DQM_SYNC_INTERFACE table
3864: 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);
3865: END IF;
3866: END IF;
3867: END LOOP;

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

3890: l_err_index := SQL%BULK_EXCEPTIONS(indx).ERROR_INDEX;
3891: l_sql_errm := sqlerrm(-SQL%BULK_EXCEPTIONS(indx).ERROR_CODE);
3892: IF (instr(l_sql_errm,'ORA-00001')>0) THEN
3893: log ('Exception DUP_VAL_ON_INDEX occured while inserting a Contact with ORG_CONTACT_ID - '||H_ORG_CONTACT_ID(l_err_index));
3894: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE ENTITY='CONTACTS' AND OPERATION='U' AND RECORD_ID=H_ORG_CONTACT_ID(l_err_index);
3895: ELSE
3896: IF p_bulk_sync_type = 'DQM_SYNC' THEN
3897: UPDATE hz_dqm_sync_interface
3898: SET error_data = l_sql_errm

Line 3897: UPDATE hz_dqm_sync_interface

3893: log ('Exception DUP_VAL_ON_INDEX occured while inserting a Contact with ORG_CONTACT_ID - '||H_ORG_CONTACT_ID(l_err_index));
3894: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE ENTITY='CONTACTS' AND OPERATION='U' AND RECORD_ID=H_ORG_CONTACT_ID(l_err_index);
3895: ELSE
3896: IF p_bulk_sync_type = 'DQM_SYNC' THEN
3897: UPDATE hz_dqm_sync_interface
3898: SET error_data = l_sql_errm
3899: ,staged_flag = decode (error_data, NULL, 'N', 'E')
3900: WHERE rowid = H_ROWID(l_err_index);
3901: ELSIF p_bulk_sync_type = 'IMPORT_SYNC' THEN

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

3898: SET error_data = l_sql_errm
3899: ,staged_flag = decode (error_data, NULL, 'N', 'E')
3900: WHERE rowid = H_ROWID(l_err_index);
3901: ELSIF p_bulk_sync_type = 'IMPORT_SYNC' THEN
3902: -- Insert the Error Record into HZ_DQM_SYNC_INTERFACE table
3903: 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);
3904: END IF;
3905: END IF;
3906: END LOOP;

Line 4020: FROM HZ_DQM_SYNC_INTERFACE dsi,HZ_CONTACT_POINTS cp

4016: ,translate(phone_country_code|| ' ' || phone_area_code||' ' || phone_number,'0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz!"#$%&()''*+,-./:;<=>?@[\]^_`{|}~ ','0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZ')
4017: ,cp.PHONE_LINE_TYPE
4018: ,cp.STATUS
4019: ,cp.CONTACT_POINT_PURPOSE
4020: FROM HZ_DQM_SYNC_INTERFACE dsi,HZ_CONTACT_POINTS cp
4021: WHERE dsi.record_id = cp.contact_point_id
4022: AND dsi.entity = 'CONTACT_POINTS'
4023: AND dsi.operation = p_operation
4024: AND dsi.staged_flag = 'N'

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

4160: l_err_index := SQL%BULK_EXCEPTIONS(indx).ERROR_INDEX;
4161: l_sql_errm := sqlerrm(-SQL%BULK_EXCEPTIONS(indx).ERROR_CODE);
4162: IF (instr(l_sql_errm,'ORA-00001')>0) THEN
4163: log ('Exception DUP_VAL_ON_INDEX occured while inserting a Contact Point with CONTACT_POINT_ID - '||H_CONTACT_POINT_ID(l_err_index));
4164: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE ENTITY='CONTACT_POINTS' AND OPERATION='C' AND RECORD_ID=H_CONTACT_POINT_ID(l_err_index);
4165: ELSE
4166: IF p_bulk_sync_type = 'DQM_SYNC' THEN
4167: UPDATE hz_dqm_sync_interface
4168: SET error_data = l_sql_errm

Line 4167: UPDATE hz_dqm_sync_interface

4163: log ('Exception DUP_VAL_ON_INDEX occured while inserting a Contact Point with CONTACT_POINT_ID - '||H_CONTACT_POINT_ID(l_err_index));
4164: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE ENTITY='CONTACT_POINTS' AND OPERATION='C' AND RECORD_ID=H_CONTACT_POINT_ID(l_err_index);
4165: ELSE
4166: IF p_bulk_sync_type = 'DQM_SYNC' THEN
4167: UPDATE hz_dqm_sync_interface
4168: SET error_data = l_sql_errm
4169: ,staged_flag = decode (error_data, NULL, 'N', 'E')
4170: WHERE rowid = H_ROWID(l_err_index);
4171: ELSIF p_bulk_sync_type = 'IMPORT_SYNC' THEN

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

4168: SET error_data = l_sql_errm
4169: ,staged_flag = decode (error_data, NULL, 'N', 'E')
4170: WHERE rowid = H_ROWID(l_err_index);
4171: ELSIF p_bulk_sync_type = 'IMPORT_SYNC' THEN
4172: -- Insert the Error Record into HZ_DQM_SYNC_INTERFACE table
4173: 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);
4174: END IF;
4175: END IF;
4176: END LOOP;

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

4205: l_err_index := SQL%BULK_EXCEPTIONS(indx).ERROR_INDEX;
4206: l_sql_errm := sqlerrm(-SQL%BULK_EXCEPTIONS(indx).ERROR_CODE);
4207: IF (instr(l_sql_errm,'ORA-00001')>0) THEN
4208: log ('Exception DUP_VAL_ON_INDEX occured while inserting a Contact Point with CONTACT_POINT_ID - '||H_CONTACT_POINT_ID(l_err_index));
4209: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE ENTITY='CONTACT_POINTS' AND OPERATION='U' AND RECORD_ID=H_CONTACT_POINT_ID(l_err_index);
4210: ELSE
4211: IF p_bulk_sync_type = 'DQM_SYNC' THEN
4212: UPDATE hz_dqm_sync_interface
4213: SET error_data = l_sql_errm

Line 4212: UPDATE hz_dqm_sync_interface

4208: log ('Exception DUP_VAL_ON_INDEX occured while inserting a Contact Point with CONTACT_POINT_ID - '||H_CONTACT_POINT_ID(l_err_index));
4209: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE ENTITY='CONTACT_POINTS' AND OPERATION='U' AND RECORD_ID=H_CONTACT_POINT_ID(l_err_index);
4210: ELSE
4211: IF p_bulk_sync_type = 'DQM_SYNC' THEN
4212: UPDATE hz_dqm_sync_interface
4213: SET error_data = l_sql_errm
4214: ,staged_flag = decode (error_data, NULL, 'N', 'E')
4215: WHERE rowid = H_ROWID(l_err_index);
4216: ELSIF p_bulk_sync_type = 'IMPORT_SYNC' THEN

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

4213: SET error_data = l_sql_errm
4214: ,staged_flag = decode (error_data, NULL, 'N', 'E')
4215: WHERE rowid = H_ROWID(l_err_index);
4216: ELSIF p_bulk_sync_type = 'IMPORT_SYNC' THEN
4217: -- Insert the Error Record into HZ_DQM_SYNC_INTERFACE table
4218: 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);
4219: END IF;
4220: END IF;
4221: END LOOP;