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 753: 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 );

749: END IF; --NVL(l_reg_dedup,'N') = 'Y'
750:
751: -- Bug 4594407 : Call DQM Sync Index
752: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Calling Parallel Sync Index concurrent program');
753: 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 );
754: l_index_conc_program_req_id := FND_REQUEST.SUBMIT_REQUEST('AR',
755: 'ARHDQMPP',
756: 'DQM Parallel Sync Index Parent Program',
757: NULL,

Line 759: fnd_global.conc_request_id

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

Line 779: to_char(fnd_global.conc_request_id),

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

Line 988: fnd_global.conc_request_id);

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

Line 1018: fnd_global.conc_request_id);

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

Line 1092: main_conc_req_id = fnd_global.conc_request_id,

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

Line 1331: fnd_global.conc_request_id,

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

Line 1332: fnd_global.prog_appl_id,

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

Line 1333: fnd_global.conc_program_id

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

Line 1368: fnd_global.conc_request_id,

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

Line 1369: fnd_global.prog_appl_id,

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

Line 1370: fnd_global.conc_program_id

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

Line 1442: p_request_id => fnd_global.conc_request_id,

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

Line 1480: 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 );

1476: END IF; --NVL(r_batch_info.registry_dedup_flag,'N') = 'Y'
1477:
1478: -- Bug 4594407 : Call DQM Sync Index
1479: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Calling Parallel Sync Index concurrent program');
1480: 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 );
1481: l_index_conc_program_req_id := FND_REQUEST.SUBMIT_REQUEST('AR',
1482: 'ARHDQMPP',
1483: 'DQM Parallel Sync Index Parent Program',
1484: NULL,

Line 1486: fnd_global.conc_request_id

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

Line 1507: to_char(fnd_global.conc_request_id),

1503: true,
1504: p_batch_id,
1505: r_batch_info.original_system,
1506: l_batch_mode_flag,
1507: to_char(fnd_global.conc_request_id),
1508: p_generate_fuzzy_key
1509: );
1510:
1511: IF l_pp_sub_request = 0 THEN

Line 1568: main_conc_req_id = fnd_global.conc_request_id

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

Line 1703: fnd_global.conc_request_id,

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

Line 1704: fnd_global.prog_appl_id,

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

Line 1705: fnd_global.conc_program_id

1701: nvl(r_batch_info.error_limit,FND_PROFILE.value('HZ_IMP_ERROR_LIMIT')),
1702: l_dataload_rerun,
1703: fnd_global.conc_request_id,
1704: fnd_global.prog_appl_id,
1705: fnd_global.conc_program_id
1706: );
1707:
1708: ELSE
1709:

Line 1738: fnd_global.conc_request_id,

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

Line 1739: fnd_global.prog_appl_id,

1735: l_num_of_workers,
1736: nvl(r_batch_info.error_limit,FND_PROFILE.value('HZ_IMP_ERROR_LIMIT')),
1737: l_dataload_rerun,
1738: fnd_global.conc_request_id,
1739: fnd_global.prog_appl_id,
1740: fnd_global.conc_program_id
1741: );
1742:
1743: END IF; -- IF r_batch_info.load_type = 'CSV'

Line 1740: fnd_global.conc_program_id

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

Line 1809: p_request_id => fnd_global.conc_request_id,

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

Line 1847: 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 );

1843: END IF; --NVL(r_batch_info.r_batch_info.registry_dedup_flag,'N') = 'Y'
1844:
1845: -- Bug 4594407 : Call DQM Sync Index
1846: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Calling Parallel Sync Index concurrent program');
1847: 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: l_index_conc_program_req_id := FND_REQUEST.SUBMIT_REQUEST('AR',
1849: 'ARHDQMPP',
1850: 'DQM Parallel Sync Index Parent Program',
1851: NULL,

Line 1853: fnd_global.conc_request_id

1849: 'ARHDQMPP',
1850: 'DQM Parallel Sync Index Parent Program',
1851: NULL,
1852: FALSE,
1853: fnd_global.conc_request_id
1854: );
1855: IF l_index_conc_program_req_id = 0 THEN
1856: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Error submitting DQM Sync Index Program.');
1857: ELSE

Line 1873: to_char(fnd_global.conc_request_id),

1869: true,
1870: p_batch_id,
1871: r_batch_info.original_system,
1872: l_batch_mode_flag,
1873: to_char(fnd_global.conc_request_id),
1874: p_generate_fuzzy_key
1875: );
1876:
1877: IF l_pp_sub_request = 0 THEN