eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGC_CC_COMPLETE_COVER_PKG dependencies on IGC_CC_PROCESS_EXCEPTIONS

Line 37: l_msg_data igc_cc_process_exceptions.exception_reason%TYPE;

33: l_validation_error_code VARCHAR2(1);
34: l_return_status VARCHAR2(1);
35: l_bc_status VARCHAR2(1);
36: l_msg_count NUMBER;
37: l_msg_data igc_cc_process_exceptions.exception_reason%TYPE;
38: l_error_text VARCHAR2(12000);
39:
40: l_stage1_parent_req NUMBER;
41: l_stage1_wait_for_request BOOLEAN;

Line 181: -- for a CC in the igc_cc_process_exceptions table

177: End Update_releases;
178:
179:
180: -- Procedure Insert_exceptions insert validations or budgetary control errors
181: -- for a CC in the igc_cc_process_exceptions table
182:
183: Procedure Insert_exception (
184: x_request_id IN IGC_CC_PROCESS_EXCEPTIONS.REQUEST_ID%TYPE
185: , x_set_of_books_id IN IGC_CC_PROCESS_EXCEPTIONS.SET_OF_BOOKS_ID%TYPE

Line 184: x_request_id IN IGC_CC_PROCESS_EXCEPTIONS.REQUEST_ID%TYPE

180: -- Procedure Insert_exceptions insert validations or budgetary control errors
181: -- for a CC in the igc_cc_process_exceptions table
182:
183: Procedure Insert_exception (
184: x_request_id IN IGC_CC_PROCESS_EXCEPTIONS.REQUEST_ID%TYPE
185: , x_set_of_books_id IN IGC_CC_PROCESS_EXCEPTIONS.SET_OF_BOOKS_ID%TYPE
186: , x_org_id IN IGC_CC_PROCESS_EXCEPTIONS.ORG_ID%TYPE
187: , x_process_type IN IGC_CC_PROCESS_EXCEPTIONS.PROCESS_TYPE%TYPE
188: , x_process_phase IN IGC_CC_PROCESS_EXCEPTIONS.PROCESS_PHASE%TYPE

Line 185: , x_set_of_books_id IN IGC_CC_PROCESS_EXCEPTIONS.SET_OF_BOOKS_ID%TYPE

181: -- for a CC in the igc_cc_process_exceptions table
182:
183: Procedure Insert_exception (
184: x_request_id IN IGC_CC_PROCESS_EXCEPTIONS.REQUEST_ID%TYPE
185: , x_set_of_books_id IN IGC_CC_PROCESS_EXCEPTIONS.SET_OF_BOOKS_ID%TYPE
186: , x_org_id IN IGC_CC_PROCESS_EXCEPTIONS.ORG_ID%TYPE
187: , x_process_type IN IGC_CC_PROCESS_EXCEPTIONS.PROCESS_TYPE%TYPE
188: , x_process_phase IN IGC_CC_PROCESS_EXCEPTIONS.PROCESS_PHASE%TYPE
189: , x_cc_header_id IN IGC_CC_PROCESS_EXCEPTIONS.CC_HEADER_ID%TYPE

Line 186: , x_org_id IN IGC_CC_PROCESS_EXCEPTIONS.ORG_ID%TYPE

182:
183: Procedure Insert_exception (
184: x_request_id IN IGC_CC_PROCESS_EXCEPTIONS.REQUEST_ID%TYPE
185: , x_set_of_books_id IN IGC_CC_PROCESS_EXCEPTIONS.SET_OF_BOOKS_ID%TYPE
186: , x_org_id IN IGC_CC_PROCESS_EXCEPTIONS.ORG_ID%TYPE
187: , x_process_type IN IGC_CC_PROCESS_EXCEPTIONS.PROCESS_TYPE%TYPE
188: , x_process_phase IN IGC_CC_PROCESS_EXCEPTIONS.PROCESS_PHASE%TYPE
189: , x_cc_header_id IN IGC_CC_PROCESS_EXCEPTIONS.CC_HEADER_ID%TYPE
190: , x_reason IN IGC_CC_PROCESS_EXCEPTIONS.EXCEPTION_REASON%TYPE ) IS

Line 187: , x_process_type IN IGC_CC_PROCESS_EXCEPTIONS.PROCESS_TYPE%TYPE

183: Procedure Insert_exception (
184: x_request_id IN IGC_CC_PROCESS_EXCEPTIONS.REQUEST_ID%TYPE
185: , x_set_of_books_id IN IGC_CC_PROCESS_EXCEPTIONS.SET_OF_BOOKS_ID%TYPE
186: , x_org_id IN IGC_CC_PROCESS_EXCEPTIONS.ORG_ID%TYPE
187: , x_process_type IN IGC_CC_PROCESS_EXCEPTIONS.PROCESS_TYPE%TYPE
188: , x_process_phase IN IGC_CC_PROCESS_EXCEPTIONS.PROCESS_PHASE%TYPE
189: , x_cc_header_id IN IGC_CC_PROCESS_EXCEPTIONS.CC_HEADER_ID%TYPE
190: , x_reason IN IGC_CC_PROCESS_EXCEPTIONS.EXCEPTION_REASON%TYPE ) IS
191: Begin

Line 188: , x_process_phase IN IGC_CC_PROCESS_EXCEPTIONS.PROCESS_PHASE%TYPE

184: x_request_id IN IGC_CC_PROCESS_EXCEPTIONS.REQUEST_ID%TYPE
185: , x_set_of_books_id IN IGC_CC_PROCESS_EXCEPTIONS.SET_OF_BOOKS_ID%TYPE
186: , x_org_id IN IGC_CC_PROCESS_EXCEPTIONS.ORG_ID%TYPE
187: , x_process_type IN IGC_CC_PROCESS_EXCEPTIONS.PROCESS_TYPE%TYPE
188: , x_process_phase IN IGC_CC_PROCESS_EXCEPTIONS.PROCESS_PHASE%TYPE
189: , x_cc_header_id IN IGC_CC_PROCESS_EXCEPTIONS.CC_HEADER_ID%TYPE
190: , x_reason IN IGC_CC_PROCESS_EXCEPTIONS.EXCEPTION_REASON%TYPE ) IS
191: Begin
192: Insert into igc_cc_process_exceptions ( process_type

Line 189: , x_cc_header_id IN IGC_CC_PROCESS_EXCEPTIONS.CC_HEADER_ID%TYPE

185: , x_set_of_books_id IN IGC_CC_PROCESS_EXCEPTIONS.SET_OF_BOOKS_ID%TYPE
186: , x_org_id IN IGC_CC_PROCESS_EXCEPTIONS.ORG_ID%TYPE
187: , x_process_type IN IGC_CC_PROCESS_EXCEPTIONS.PROCESS_TYPE%TYPE
188: , x_process_phase IN IGC_CC_PROCESS_EXCEPTIONS.PROCESS_PHASE%TYPE
189: , x_cc_header_id IN IGC_CC_PROCESS_EXCEPTIONS.CC_HEADER_ID%TYPE
190: , x_reason IN IGC_CC_PROCESS_EXCEPTIONS.EXCEPTION_REASON%TYPE ) IS
191: Begin
192: Insert into igc_cc_process_exceptions ( process_type
193: , process_phase

Line 190: , x_reason IN IGC_CC_PROCESS_EXCEPTIONS.EXCEPTION_REASON%TYPE ) IS

186: , x_org_id IN IGC_CC_PROCESS_EXCEPTIONS.ORG_ID%TYPE
187: , x_process_type IN IGC_CC_PROCESS_EXCEPTIONS.PROCESS_TYPE%TYPE
188: , x_process_phase IN IGC_CC_PROCESS_EXCEPTIONS.PROCESS_PHASE%TYPE
189: , x_cc_header_id IN IGC_CC_PROCESS_EXCEPTIONS.CC_HEADER_ID%TYPE
190: , x_reason IN IGC_CC_PROCESS_EXCEPTIONS.EXCEPTION_REASON%TYPE ) IS
191: Begin
192: Insert into igc_cc_process_exceptions ( process_type
193: , process_phase
194: , cc_header_id

Line 192: Insert into igc_cc_process_exceptions ( process_type

188: , x_process_phase IN IGC_CC_PROCESS_EXCEPTIONS.PROCESS_PHASE%TYPE
189: , x_cc_header_id IN IGC_CC_PROCESS_EXCEPTIONS.CC_HEADER_ID%TYPE
190: , x_reason IN IGC_CC_PROCESS_EXCEPTIONS.EXCEPTION_REASON%TYPE ) IS
191: Begin
192: Insert into igc_cc_process_exceptions ( process_type
193: , process_phase
194: , cc_header_id
195: , exception_reason
196: , org_id

Line 407: Delete from igc_cc_process_exceptions

403: l_request_id := fnd_global.conc_request_id;
404: l_validation_error_code := 'N';
405: l_acct_date := SYSDATE;
406:
407: Delete from igc_cc_process_exceptions
408: where process_type = 'C'
409: and process_phase = 'F'
410: and cc_header_id = p_cc_header_id
411: and set_of_books_id = l_set_of_books_id