APPS.IGC_CC_OPEN_INTERFACE_PKG dependencies on IGC_CC_INTERFACE_ERRORS

Line 165: INSERT INTO IGC_CC_INTERFACE_ERRORS

161: IF P_X_Error_Status = 'N' THEN
162: ROLLBACK;
163: P_X_Error_Status := 'E';
164: END IF;
165: INSERT INTO IGC_CC_INTERFACE_ERRORS
166: ( batch_id,
167: interface_header_id,
168: interface_acct_line_id,
169: interface_det_pf_line_id,

Line 183: -- Insert the Acct Line and Det Pf records into igc_cc_interface_errors

179: P_Error_Message);
180: END;
181:
182: /***************************************************************************/
183: -- Insert the Acct Line and Det Pf records into igc_cc_interface_errors
184: -- for which the header or acct line record does not exists in the batch.
185: /***************************************************************************/
186: PROCEDURE INSERT_ORPHAN_RECORDS
187: ( P_X_Error_Status IN OUT NOCOPY VARCHAR2 )

Line 192: l_error_message igc_cc_interface_errors.error_message%TYPE;

188: IS
189: l_interface_header_id NUMBER;
190: l_interface_acct_line_id NUMBER;
191: l_interface_det_pf_id NUMBER;
192: l_error_message igc_cc_interface_errors.error_message%TYPE;
193:
194: CURSOR c_interface_orphan_acct_lines IS
195: SELECT ICALI.interface_header_id,
196: ICALI.interface_acct_line_id

Line 1384: l_error_message igc_cc_interface_errors.error_message%TYPE;

1380: l_interface_header_record igc_cc_headers_interface%ROWTYPE;
1381: l_start_date gl_periods.start_date%TYPE;
1382: l_end_date gl_periods.end_date%TYPE;
1383: l_curr_year_pf_lines NUMBER;
1384: l_error_message igc_cc_interface_errors.error_message%TYPE;
1385: l_history_message VARCHAR2(240);
1386: l_wait_for_request BOOLEAN;
1387: l_phase VARCHAR2(240);
1388: l_status VARCHAR2(240);

Line 1468: -- Delete all the old records from IGC_CC_INTERFACE_ERRORS

1464: RETCODE := '0';
1465: g_process_phase := P_Process_Phase;
1466: g_batch_id := P_Batch_Id;
1467:
1468: -- Delete all the old records from IGC_CC_INTERFACE_ERRORS
1469: DELETE IGC_CC_INTERFACE_ERRORS;
1470:
1471: COMMIT;
1472:

Line 1469: DELETE IGC_CC_INTERFACE_ERRORS;

1465: g_process_phase := P_Process_Phase;
1466: g_batch_id := P_Batch_Id;
1467:
1468: -- Delete all the old records from IGC_CC_INTERFACE_ERRORS
1469: DELETE IGC_CC_INTERFACE_ERRORS;
1470:
1471: COMMIT;
1472:
1473: -- Bug 2871052

Line 1901: -- igc_cc_interface_errors, if any.

1897: END LOOP;
1898: CLOSE c_interface_header_records;
1899:
1900: -- Insert the orphan interface acct lines and det pf lines into
1901: -- igc_cc_interface_errors, if any.
1902: INSERT_ORPHAN_RECORDS
1903: ( l_error_status );
1904:
1905: -- If process phase is final and no errors encountered

Line 2560: l_error_message igc_cc_interface_errors.error_message%TYPE;

2556: P_Current_Set_of_Books_Id IN NUMBER,
2557: P_Func_Currency_Code IN VARCHAR2,
2558: P_Cbc_Enable_Flag IN VARCHAR2)
2559: IS
2560: l_error_message igc_cc_interface_errors.error_message%TYPE;
2561: l_count NUMBER;
2562: l_interface_parent_header_id NUMBER;
2563: l_vendor_id NUMBER;
2564: l_vendor_site_id NUMBER;

Line 3682: l_error_message igc_cc_interface_errors.error_message%TYPE;

3678: P_X_Error_Status IN OUT NOCOPY VARCHAR2)
3679: IS
3680: l_interface_parent_header_id NUMBER;
3681: l_interface_parent_acctline_id NUMBER;
3682: l_error_message igc_cc_interface_errors.error_message%TYPE;
3683: l_code_combination_id NUMBER;
3684: l_entered_amt NUMBER;
3685: l_func_amt NUMBER;
3686: l_project_id NUMBER;

Line 4701: l_error_message igc_cc_interface_errors.error_message%TYPE;

4697: P_Created_By IN NUMBER,
4698: P_X_Error_Status IN OUT NOCOPY VARCHAR2)
4699: IS
4700: l_interface_parent_det_pf_id NUMBER;
4701: l_error_message igc_cc_interface_errors.error_message%TYPE;
4702: l_count NUMBER;
4703: l_func_amt NUMBER;
4704: l_det_pf_date DATE;
4705: l_user_id NUMBER;