370: IF l_party_id.COUNT = 0 THEN
371: RETURN;
372: END IF;
373:
374: -- Bug 4925023 : call HZ_DQM_SYNC once with new spec
375: /*
376: IF (p_enable_dqm_sync <> 'DISABLE') THEN
377: fnd_file.put_line(fnd_file.log, ' sync PARTY');
378: HZ_DQM_SYNC.sync_work_unit_imp(l_party_id, l_record_id, l_entity, l_operation, l_party_type,
374: -- Bug 4925023 : call HZ_DQM_SYNC once with new spec
375: /*
376: IF (p_enable_dqm_sync <> 'DISABLE') THEN
377: fnd_file.put_line(fnd_file.log, ' sync PARTY');
378: HZ_DQM_SYNC.sync_work_unit_imp(l_party_id, l_record_id, l_entity, l_operation, l_party_type,
379: l_return_status, l_msg_count, l_msg_data);
380: END IF;
381: */
382:
505: IF l_location_id.COUNT = 0 THEN
506: RETURN;
507: END IF;
508:
509: -- Bug 4925023 : call HZ_DQM_SYNC once with new spec
510: /*
511: IF (p_enable_dqm_sync <> 'DISABLE') THEN
512: fnd_file.put_line(fnd_file.log, ' sync PARTY_SITES');
513: HZ_DQM_SYNC.sync_work_unit_imp(l_party_id, l_record_id, l_entity, l_operation, l_party_type,
509: -- Bug 4925023 : call HZ_DQM_SYNC once with new spec
510: /*
511: IF (p_enable_dqm_sync <> 'DISABLE') THEN
512: fnd_file.put_line(fnd_file.log, ' sync PARTY_SITES');
513: HZ_DQM_SYNC.sync_work_unit_imp(l_party_id, l_record_id, l_entity, l_operation, l_party_type,
514: l_return_status, l_msg_count, l_msg_data);
515: END IF;
516: */
517:
1045: IF l_contact_point_id.COUNT = 0 THEN
1046: RETURN;
1047: END IF;
1048:
1049: -- Bug 4925023 : call HZ_DQM_SYNC once with new spec
1050: /*
1051: IF (p_enable_dqm_sync <> 'DISABLE') THEN
1052: fnd_file.put_line(fnd_file.log, ' sync CONTACT_POINTS');
1053: HZ_DQM_SYNC.sync_work_unit_imp(l_party_id, l_record_id, l_entity, l_operation, l_party_type,
1049: -- Bug 4925023 : call HZ_DQM_SYNC once with new spec
1050: /*
1051: IF (p_enable_dqm_sync <> 'DISABLE') THEN
1052: fnd_file.put_line(fnd_file.log, ' sync CONTACT_POINTS');
1053: HZ_DQM_SYNC.sync_work_unit_imp(l_party_id, l_record_id, l_entity, l_operation, l_party_type,
1054: l_return_status, l_msg_count, l_msg_data);
1055: END IF;
1056: */
1057:
1142: fnd_file.put_line(fnd_file.log, ' pp_phone_format-');
1143:
1144: END pp_phone_format;
1145:
1146: -- Bug 4925023 : call HZ_DQM_SYNC once with new spec
1147: -- PROCEDURE pp_dqm_sync obsoleted
1148: /*
1149: PROCEDURE pp_dqm_sync (
1150: p_batch_mode_flag IN VARCHAR2,
1216: END IF;
1217:
1218: fnd_file.put_line(fnd_file.log, ' sync CONTACTS');
1219:
1220: HZ_DQM_SYNC.sync_work_unit_imp(l_party_id, l_record_id, l_entity, l_operation, l_party_type,
1221: l_return_status, l_msg_count, l_msg_data);
1222:
1223: fnd_file.put_line(fnd_file.log, ' pp_dqm_sync-');
1224:
1334: fnd_file.put_line(fnd_file.log,' Generate Loctaion Timezone (-) ');
1335:
1336: fnd_file.put_line(fnd_file.log,' DQM Sync (+) ');
1337: IF (l_enable_dqm_sync_flag <> 'DISABLE') THEN
1338: fnd_file.put_line(fnd_file.log,' Calling HZ_DQM_SYNC.sync_work_unit_imp.');
1339: -- Bug 4925023 : call HZ_DQM_SYNC once with new spec
1340: -- pp_dqm_sync(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID, NULL);
1341: HZ_DQM_SYNC.sync_work_unit_imp(
1342: p_batch_id => P_BATCH_ID,
1335:
1336: fnd_file.put_line(fnd_file.log,' DQM Sync (+) ');
1337: IF (l_enable_dqm_sync_flag <> 'DISABLE') THEN
1338: fnd_file.put_line(fnd_file.log,' Calling HZ_DQM_SYNC.sync_work_unit_imp.');
1339: -- Bug 4925023 : call HZ_DQM_SYNC once with new spec
1340: -- pp_dqm_sync(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID, NULL);
1341: HZ_DQM_SYNC.sync_work_unit_imp(
1342: p_batch_id => P_BATCH_ID,
1343: p_batch_mode_flag => P_BATCH_MODE_FLAG,
1337: IF (l_enable_dqm_sync_flag <> 'DISABLE') THEN
1338: fnd_file.put_line(fnd_file.log,' Calling HZ_DQM_SYNC.sync_work_unit_imp.');
1339: -- Bug 4925023 : call HZ_DQM_SYNC once with new spec
1340: -- pp_dqm_sync(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID, NULL);
1341: HZ_DQM_SYNC.sync_work_unit_imp(
1342: p_batch_id => P_BATCH_ID,
1343: p_batch_mode_flag => P_BATCH_MODE_FLAG,
1344: p_from_osr => P_FROM_OSR,
1345: p_to_osr => P_TO_OSR,
1442:
1443: fnd_file.put_line(fnd_file.log,' DQM Sync (+) ');
1444: IF (l_enable_dqm_sync_flag <> 'DISABLE') THEN
1445: fnd_file.put_line(fnd_file.log,' Calling pp_dqm_sync.');
1446: -- Bug 4925023 : call HZ_DQM_SYNC once with new spec
1447: -- pp_dqm_sync(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID, 'U');
1448: HZ_DQM_SYNC.sync_work_unit_imp(
1449: p_batch_id => P_BATCH_ID,
1450: p_batch_mode_flag => P_BATCH_MODE_FLAG,
1444: IF (l_enable_dqm_sync_flag <> 'DISABLE') THEN
1445: fnd_file.put_line(fnd_file.log,' Calling pp_dqm_sync.');
1446: -- Bug 4925023 : call HZ_DQM_SYNC once with new spec
1447: -- pp_dqm_sync(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID, 'U');
1448: HZ_DQM_SYNC.sync_work_unit_imp(
1449: p_batch_id => P_BATCH_ID,
1450: p_batch_mode_flag => P_BATCH_MODE_FLAG,
1451: p_from_osr => P_FROM_OSR,
1452: p_to_osr => P_TO_OSR,