APPS.RCV_ROI_PREPROCESSOR dependencies on RCV_DCP_PVT

Line 278: /* Moved this cursor as well as its for loop to the rcv_dcp_pvt package */

274: AND COUNT(osa_flag) > 0;
275:
276: /*Added for the RCV DCP. This cursors is used to loop through the
277: * * records in RHI*/
278: /* Moved this cursor as well as its for loop to the rcv_dcp_pvt package */
279: /* CURSOR headers_cur_dcp(x_request_id NUMBER, x_group_id NUMBER) IS
280: SELECT *
281: FROM rcv_headers_interface
282: WHERE NVL(asn_type, 'STD') IN('ASN', 'ASBN', 'STD', 'WC')

Line 321: l_check_dcp := rcv_dcp_pvt.g_check_dcp;

317: asn_debug.put_line('Entering preprocessor. Request_id = ' || p_request_id || ',Group_id=' || p_group_id);
318: END IF;
319:
320: SAVEPOINT dcp_preprocessor_start;
321: l_check_dcp := rcv_dcp_pvt.g_check_dcp;
322:
323: IF l_check_dcp IS NULL THEN
324: l_check_dcp := rcv_dcp_pvt.is_dcp_enabled;
325: END IF;

Line 324: l_check_dcp := rcv_dcp_pvt.is_dcp_enabled;

320: SAVEPOINT dcp_preprocessor_start;
321: l_check_dcp := rcv_dcp_pvt.g_check_dcp;
322:
323: IF l_check_dcp IS NULL THEN
324: l_check_dcp := rcv_dcp_pvt.is_dcp_enabled;
325: END IF;
326:
327: -- Cache basic configuration options
328: IF (g_is_edi_installed IS NULL) THEN

Line 1229: asn_debug.put_line('g_check_dcp ' || rcv_dcp_pvt.g_check_dcp);

1225: --DCP call
1226: BEGIN
1227: IF (g_asn_debug = 'Y') THEN
1228: asn_debug.put_line('l_check_dcp ' || l_check_dcp);
1229: asn_debug.put_line('g_check_dcp ' || rcv_dcp_pvt.g_check_dcp);
1230: END IF;
1231:
1232: IF l_check_dcp > 0 THEN
1233: -- Moved the driving cursor to the DCP package itself

Line 1235: rcv_dcp_pvt.validate_data(p_dcp_event => 'PREPROCESSOR', p_request_id => x_request_id, p_group_id => x_group_id, p_raise_exception => 'Y', x_return_status => l_return_status);

1231:
1232: IF l_check_dcp > 0 THEN
1233: -- Moved the driving cursor to the DCP package itself
1234: -- FOR header_cur_rec IN headers_cur_dcp(x_request_id, x_group_id) LOOP
1235: rcv_dcp_pvt.validate_data(p_dcp_event => 'PREPROCESSOR', p_request_id => x_request_id, p_group_id => x_group_id, p_raise_exception => 'Y', x_return_status => l_return_status);
1236: --END LOOP;
1237: END IF;
1238: EXCEPTION
1239: WHEN rcv_dcp_pvt.data_inconsistency_exception THEN

Line 1239: WHEN rcv_dcp_pvt.data_inconsistency_exception THEN

1235: rcv_dcp_pvt.validate_data(p_dcp_event => 'PREPROCESSOR', p_request_id => x_request_id, p_group_id => x_group_id, p_raise_exception => 'Y', x_return_status => l_return_status);
1236: --END LOOP;
1237: END IF;
1238: EXCEPTION
1239: WHEN rcv_dcp_pvt.data_inconsistency_exception THEN
1240: IF (g_asn_debug = 'Y') THEN
1241: asn_debug.put_line('Data Inconsistency Exception');
1242: END IF;
1243: IF distinct_org_id%ISOPEN THEN