DBA Data[Home] [Help]

APPS.HZ_BATCH_IMPORT_PKG dependencies on FND_GLOBAL

Line 709: p_request_id => fnd_global.conc_request_id,

705: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Calling DQM interface tca sanitize report');
706: HZ_DQM_DUP_ID_PKG.interface_tca_sanitize_report
707: (p_batch_id => p_batch_id,
708: p_match_rule_id => p_registry_dedup_rule_id,
709: p_request_id => fnd_global.conc_request_id,
710: x_dup_batch_id => l_dup_batch_id,
711: x_return_status => l_return_status,
712: x_msg_count => l_msg_count,
713: x_msg_data => l_msg_data);

Line 754: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Request Id of the program to be waited on, that is being passed to this : ' || fnd_global.conc_request_id );

750:
751: IF (Nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'),'Y') <> 'DISABLE') THEN --Bug 10435345
752: -- Bug 4594407 : Call DQM Sync Index
753: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Calling Parallel Sync Index concurrent program');
754: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Request Id of the program to be waited on, that is being passed to this : ' || fnd_global.conc_request_id );
755: l_index_conc_program_req_id := FND_REQUEST.SUBMIT_REQUEST('AR',
756: 'ARHDQMPP',
757: 'DQM Parallel Sync Index Parent Program',
758: NULL,

Line 760: fnd_global.conc_request_id

756: 'ARHDQMPP',
757: 'DQM Parallel Sync Index Parent Program',
758: NULL,
759: FALSE,
760: fnd_global.conc_request_id
761: );
762: IF l_index_conc_program_req_id = 0 THEN
763: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Error submitting DQM Sync Index Program.');
764: ELSE

Line 781: to_char(fnd_global.conc_request_id),

777: true,
778: p_batch_id,
779: r_batch_info.original_system,
780: l_batch_mode_flag,
781: to_char(fnd_global.conc_request_id),
782: p_generate_fuzzy_key
783: );
784:
785: IF l_pp_sub_request = 0 THEN

Line 990: fnd_global.conc_request_id);

986: HZ_UTILITY_V2PUB.creation_date,
987: HZ_UTILITY_V2PUB.last_updated_by,
988: HZ_UTILITY_V2PUB.last_update_date,
989: HZ_UTILITY_V2PUB.last_update_login,
990: fnd_global.conc_request_id);
991:
992: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Created entry in batch details table');
993:
994: END IF; -- l_last_run_imp_status <> 'PENDING'

Line 1020: fnd_global.conc_request_id);

1016: HZ_UTILITY_V2PUB.creation_date,
1017: HZ_UTILITY_V2PUB.last_updated_by,
1018: HZ_UTILITY_V2PUB.last_update_date,
1019: HZ_UTILITY_V2PUB.last_update_login,
1020: fnd_global.conc_request_id);
1021:
1022: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Created entry in batch details table');
1023:
1024: END IF;

Line 1094: main_conc_req_id = fnd_global.conc_request_id,

1090: import_status = 'PENDING',
1091: what_if_flag = decode(p_import_run_option, 'WHAT_IF', 'Y', 'N'),
1092: main_conc_status = 'PROCESSING',
1093: batch_status = 'PROCESSING',
1094: main_conc_req_id = fnd_global.conc_request_id,
1095: bd_action_on_parties = NVL(p_batch_dedup_action,bd_action_on_parties),
1096: bd_action_on_addresses = NVL(p_batch_dedup_action,bd_action_on_addresses),
1097: bd_action_on_contacts = NVL(p_batch_dedup_action,bd_action_on_contacts),
1098: bd_action_on_contact_points = NVL(p_batch_dedup_action,bd_action_on_contact_points)

Line 1333: fnd_global.conc_request_id,

1329: nvl(p_registry_dedup_rule_id, r_batch_info.registry_dedup_match_rule_id),
1330: to_char(sysdate,'DD-MM-YY HH24:MI:SS'),
1331: nvl(r_batch_info.error_limit,FND_PROFILE.value('HZ_IMP_ERROR_LIMIT')),
1332: l_dataload_rerun,
1333: fnd_global.conc_request_id,
1334: fnd_global.prog_appl_id,
1335: fnd_global.conc_program_id
1336: );
1337:

Line 1334: fnd_global.prog_appl_id,

1330: to_char(sysdate,'DD-MM-YY HH24:MI:SS'),
1331: nvl(r_batch_info.error_limit,FND_PROFILE.value('HZ_IMP_ERROR_LIMIT')),
1332: l_dataload_rerun,
1333: fnd_global.conc_request_id,
1334: fnd_global.prog_appl_id,
1335: fnd_global.conc_program_id
1336: );
1337:
1338: ELSE

Line 1335: fnd_global.conc_program_id

1331: nvl(r_batch_info.error_limit,FND_PROFILE.value('HZ_IMP_ERROR_LIMIT')),
1332: l_dataload_rerun,
1333: fnd_global.conc_request_id,
1334: fnd_global.prog_appl_id,
1335: fnd_global.conc_program_id
1336: );
1337:
1338: ELSE
1339: -- generate number of workers

Line 1370: fnd_global.conc_request_id,

1366: to_char(sysdate,'DD-MM-YY HH24:MI:SS'),
1367: l_num_of_workers,
1368: nvl(r_batch_info.error_limit,FND_PROFILE.value('HZ_IMP_ERROR_LIMIT')),
1369: l_dataload_rerun,
1370: fnd_global.conc_request_id,
1371: fnd_global.prog_appl_id,
1372: fnd_global.conc_program_id
1373: );
1374:

Line 1371: fnd_global.prog_appl_id,

1367: l_num_of_workers,
1368: nvl(r_batch_info.error_limit,FND_PROFILE.value('HZ_IMP_ERROR_LIMIT')),
1369: l_dataload_rerun,
1370: fnd_global.conc_request_id,
1371: fnd_global.prog_appl_id,
1372: fnd_global.conc_program_id
1373: );
1374:
1375: END IF;

Line 1372: fnd_global.conc_program_id

1368: nvl(r_batch_info.error_limit,FND_PROFILE.value('HZ_IMP_ERROR_LIMIT')),
1369: l_dataload_rerun,
1370: fnd_global.conc_request_id,
1371: fnd_global.prog_appl_id,
1372: fnd_global.conc_program_id
1373: );
1374:
1375: END IF;
1376:

Line 1444: p_request_id => fnd_global.conc_request_id,

1440: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Calling DQM interface tca sanitize report');
1441: HZ_DQM_DUP_ID_PKG.interface_tca_sanitize_report
1442: (p_batch_id => p_batch_id,
1443: p_match_rule_id => p_registry_dedup_rule_id,
1444: p_request_id => fnd_global.conc_request_id,
1445: x_dup_batch_id => l_dup_batch_id,
1446: x_return_status => l_return_status,
1447: x_msg_count => l_msg_count,
1448: x_msg_data => l_msg_data);

Line 1483: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Request Id of the program to be waited on, that is being passed to this : ' || fnd_global.conc_request_id );

1479:
1480: IF (Nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'),'Y') <> 'DISABLE') THEN --Bug 10435345
1481: -- Bug 4594407 : Call DQM Sync Index
1482: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Calling Parallel Sync Index concurrent program');
1483: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Request Id of the program to be waited on, that is being passed to this : ' || fnd_global.conc_request_id );
1484: l_index_conc_program_req_id := FND_REQUEST.SUBMIT_REQUEST('AR',
1485: 'ARHDQMPP',
1486: 'DQM Parallel Sync Index Parent Program',
1487: NULL,

Line 1489: fnd_global.conc_request_id

1485: 'ARHDQMPP',
1486: 'DQM Parallel Sync Index Parent Program',
1487: NULL,
1488: FALSE,
1489: fnd_global.conc_request_id
1490: );
1491: IF l_index_conc_program_req_id = 0 THEN
1492: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Error submitting DQM Sync Index Program.');
1493: ELSE

Line 1511: to_char(fnd_global.conc_request_id),

1507: true,
1508: p_batch_id,
1509: r_batch_info.original_system,
1510: l_batch_mode_flag,
1511: to_char(fnd_global.conc_request_id),
1512: p_generate_fuzzy_key
1513: );
1514:
1515: IF l_pp_sub_request = 0 THEN

Line 1572: main_conc_req_id = fnd_global.conc_request_id

1568: -- set the data load status to pending
1569: UPDATE hz_imp_batch_summary
1570: SET import_status = 'PENDING',
1571: main_conc_status = 'PROCESSING',
1572: main_conc_req_id = fnd_global.conc_request_id
1573: WHERE batch_id = p_batch_id;
1574:
1575: -- apply the batch de-duplication actions if needed.
1576: -- this is done becuase during what-if run, batch deduplication actions

Line 1707: fnd_global.conc_request_id,

1703: r_batch_info.registry_dedup_match_rule_id,
1704: to_char(sysdate,'DD-MM-YY HH24:MI:SS'),
1705: nvl(r_batch_info.error_limit,FND_PROFILE.value('HZ_IMP_ERROR_LIMIT')),
1706: l_dataload_rerun,
1707: fnd_global.conc_request_id,
1708: fnd_global.prog_appl_id,
1709: fnd_global.conc_program_id
1710: );
1711:

Line 1708: fnd_global.prog_appl_id,

1704: to_char(sysdate,'DD-MM-YY HH24:MI:SS'),
1705: nvl(r_batch_info.error_limit,FND_PROFILE.value('HZ_IMP_ERROR_LIMIT')),
1706: l_dataload_rerun,
1707: fnd_global.conc_request_id,
1708: fnd_global.prog_appl_id,
1709: fnd_global.conc_program_id
1710: );
1711:
1712: ELSE

Line 1709: fnd_global.conc_program_id

1705: nvl(r_batch_info.error_limit,FND_PROFILE.value('HZ_IMP_ERROR_LIMIT')),
1706: l_dataload_rerun,
1707: fnd_global.conc_request_id,
1708: fnd_global.prog_appl_id,
1709: fnd_global.conc_program_id
1710: );
1711:
1712: ELSE
1713:

Line 1742: fnd_global.conc_request_id,

1738: to_char(sysdate,'DD-MM-YY HH24:MI:SS'),
1739: l_num_of_workers,
1740: nvl(r_batch_info.error_limit,FND_PROFILE.value('HZ_IMP_ERROR_LIMIT')),
1741: l_dataload_rerun,
1742: fnd_global.conc_request_id,
1743: fnd_global.prog_appl_id,
1744: fnd_global.conc_program_id
1745: );
1746:

Line 1743: fnd_global.prog_appl_id,

1739: l_num_of_workers,
1740: nvl(r_batch_info.error_limit,FND_PROFILE.value('HZ_IMP_ERROR_LIMIT')),
1741: l_dataload_rerun,
1742: fnd_global.conc_request_id,
1743: fnd_global.prog_appl_id,
1744: fnd_global.conc_program_id
1745: );
1746:
1747: END IF; -- IF r_batch_info.load_type = 'CSV'

Line 1744: fnd_global.conc_program_id

1740: nvl(r_batch_info.error_limit,FND_PROFILE.value('HZ_IMP_ERROR_LIMIT')),
1741: l_dataload_rerun,
1742: fnd_global.conc_request_id,
1743: fnd_global.prog_appl_id,
1744: fnd_global.conc_program_id
1745: );
1746:
1747: END IF; -- IF r_batch_info.load_type = 'CSV'
1748:

Line 1813: p_request_id => fnd_global.conc_request_id,

1809: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Calling DQM interface tca sanitize report');
1810: HZ_DQM_DUP_ID_PKG.interface_tca_sanitize_report
1811: (p_batch_id => p_batch_id,
1812: p_match_rule_id => r_batch_info.registry_dedup_match_rule_id,
1813: p_request_id => fnd_global.conc_request_id,
1814: x_dup_batch_id => l_dup_batch_id,
1815: x_return_status => l_return_status,
1816: x_msg_count => l_msg_count,
1817: x_msg_data => l_msg_data);

Line 1852: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Request Id of the program to be waited on, that is being passed to this : ' || fnd_global.conc_request_id );

1848:
1849: IF (Nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'),'Y') <> 'DISABLE') THEN --Bug 10435345
1850: -- Bug 4594407 : Call DQM Sync Index
1851: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Calling Parallel Sync Index concurrent program');
1852: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Request Id of the program to be waited on, that is being passed to this : ' || fnd_global.conc_request_id );
1853: l_index_conc_program_req_id := FND_REQUEST.SUBMIT_REQUEST('AR',
1854: 'ARHDQMPP',
1855: 'DQM Parallel Sync Index Parent Program',
1856: NULL,

Line 1858: fnd_global.conc_request_id

1854: 'ARHDQMPP',
1855: 'DQM Parallel Sync Index Parent Program',
1856: NULL,
1857: FALSE,
1858: fnd_global.conc_request_id
1859: );
1860: IF l_index_conc_program_req_id = 0 THEN
1861: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Error submitting DQM Sync Index Program.');
1862: ELSE

Line 1879: to_char(fnd_global.conc_request_id),

1875: true,
1876: p_batch_id,
1877: r_batch_info.original_system,
1878: l_batch_mode_flag,
1879: to_char(fnd_global.conc_request_id),
1880: p_generate_fuzzy_key
1881: );
1882:
1883: IF l_pp_sub_request = 0 THEN