APPS.RCV_ROI_PREPROCESSOR dependencies on RCV_DCP_PVT

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

170: AND COUNT(osa_flag) > 0;
171:
172: /*Added for the RCV DCP. This cursors is used to loop through the
173: * * records in RHI*/
174: /* Moved this cursor as well as its for loop to the rcv_dcp_pvt package */
175: /* CURSOR headers_cur_dcp(x_request_id NUMBER, x_group_id NUMBER) IS
176: SELECT *
177: FROM rcv_headers_interface
178: WHERE NVL(asn_type, 'STD') IN('ASN', 'ASBN', 'STD', 'WC')

Line 202: l_check_dcp := rcv_dcp_pvt.g_check_dcp;

198: asn_debug.put_line('Entering preprocessor. Request_id = ' || p_request_id || ',Group_id=' || p_group_id);
199: END IF;
200:
201: SAVEPOINT dcp_preprocessor_start;
202: l_check_dcp := rcv_dcp_pvt.g_check_dcp;
203:
204: IF l_check_dcp IS NULL THEN
205: l_check_dcp := rcv_dcp_pvt.is_dcp_enabled;
206: END IF;

Line 205: l_check_dcp := rcv_dcp_pvt.is_dcp_enabled;

201: SAVEPOINT dcp_preprocessor_start;
202: l_check_dcp := rcv_dcp_pvt.g_check_dcp;
203:
204: IF l_check_dcp IS NULL THEN
205: l_check_dcp := rcv_dcp_pvt.is_dcp_enabled;
206: END IF;
207:
208: -- Cache basic configuration options
209: IF (g_is_edi_installed IS NULL) THEN

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

1060: --DCP call
1061: BEGIN
1062: IF (g_asn_debug = 'Y') THEN
1063: asn_debug.put_line('l_check_dcp ' || l_check_dcp);
1064: asn_debug.put_line('g_check_dcp ' || rcv_dcp_pvt.g_check_dcp);
1065: END IF;
1066:
1067: IF l_check_dcp > 0 THEN
1068: -- Moved the driving cursor to the DCP package itself

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

1066:
1067: IF l_check_dcp > 0 THEN
1068: -- Moved the driving cursor to the DCP package itself
1069: -- FOR header_cur_rec IN headers_cur_dcp(x_request_id, x_group_id) LOOP
1070: 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);
1071: --END LOOP;
1072: END IF;
1073: EXCEPTION
1074: WHEN rcv_dcp_pvt.data_inconsistency_exception THEN

Line 1074: WHEN rcv_dcp_pvt.data_inconsistency_exception THEN

1070: 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);
1071: --END LOOP;
1072: END IF;
1073: EXCEPTION
1074: WHEN rcv_dcp_pvt.data_inconsistency_exception THEN
1075: IF (g_asn_debug = 'Y') THEN
1076: asn_debug.put_line('Data Inconsistency Exception');
1077: END IF;
1078: IF distinct_org_id%ISOPEN THEN