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.EC_OUTBOUND_STAGE dependencies on EC_OUTBOUND_STAGE

Line 1: PACKAGE BODY EC_OUTBOUND_STAGE AS

1: PACKAGE BODY EC_OUTBOUND_STAGE AS
2: -- $Header: ECOSTGB.pls 120.2.12000000.2 2007/03/09 14:41:15 cpeixoto ship $
3: --bug 3133379
4: TYPE STAGE_ID_TYPE is table of ece_stage.stage_id%TYPE index by binary_integer;
5: TYPE TRANSACTION_LEVEL_TYPE is table of ece_stage.transaction_level%TYPE index by binary_integer;

Line 88: ec_debug.push('EC_OUTBOUND_STAGE.GET_DATA');

84: i_empty_tbl ec_utils.mapping_tbl;
85:
86: BEGIN
87: if ec_debug.G_debug_level >= 2 then
88: ec_debug.push('EC_OUTBOUND_STAGE.GET_DATA');
89: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
90: ec_debug.pl(3,'i_file_name',i_file_name);
91: ec_debug.pl(3,'i_file_path',i_file_path);
92: ec_debug.pl(3,'i_map_id',i_map_id);

Line 241: ec_debug.pop('EC_OUTBOUND_STAGE.GET_DATA');

237: ec_debug.pl(0,'EC','ECE_NO_LINES_READ','NO_OF_LINES',counter);
238: <>
239: ec_debug.pl(0,'EC','ECE_DOCUMENTS_PROCESSED','NO_OF_DOCS',i_document_number);
240: if ec_debug.G_debug_level >= 2 then
241: ec_debug.pop('EC_OUTBOUND_STAGE.GET_DATA');
242: end if;
243: EXCEPTION
244: WHEN UTL_FILE.write_error THEN
245: ec_utils.i_ret_code :=2;

Line 247: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND_STAGE.GET_DATA');

243: EXCEPTION
244: WHEN UTL_FILE.write_error THEN
245: ec_utils.i_ret_code :=2;
246: ec_debug.pl(0,'EC','ECE_UTL_WRITE_ERROR',null);
247: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND_STAGE.GET_DATA');
248: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
249: utl_file.fclose(u_file_handle);
250: raise EC_UTILS.PROGRAM_EXIT;
251: WHEN UTL_FILE.read_error THEN

Line 254: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND_STAGE.GET_DATA');

250: raise EC_UTILS.PROGRAM_EXIT;
251: WHEN UTL_FILE.read_error THEN
252: ec_utils.i_ret_code :=2;
253: ec_debug.pl(0,'EC','ECE_UTL_READ_ERROR',null);
254: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND_STAGE.GET_DATA');
255: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
256: utl_file.fclose(u_file_handle);
257: raise EC_UTILS.PROGRAM_EXIT;
258: WHEN UTL_FILE.invalid_path THEN

Line 261: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND_STAGE.GET_DATA');

257: raise EC_UTILS.PROGRAM_EXIT;
258: WHEN UTL_FILE.invalid_path THEN
259: ec_utils.i_ret_code :=2;
260: ec_debug.pl(0,'EC','ECE_UTL_INVALID_PATH',null);
261: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND_STAGE.GET_DATA');
262: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
263: utl_file.fclose(u_file_handle);
264: raise EC_UTILS.PROGRAM_EXIT;
265: WHEN UTL_FILE.invalid_mode THEN

Line 268: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND_STAGE.GET_DATA');

264: raise EC_UTILS.PROGRAM_EXIT;
265: WHEN UTL_FILE.invalid_mode THEN
266: ec_utils.i_ret_code :=2;
267: ec_debug.pl(0,'EC','ECE_UTL_INVALID_MODE',null);
268: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND_STAGE.GET_DATA');
269: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
270: utl_file.fclose(u_file_handle);
271: raise EC_UTILS.PROGRAM_EXIT;
272: WHEN UTL_FILE.invalid_operation THEN

Line 275: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND_STAGE.GET_DATA');

271: raise EC_UTILS.PROGRAM_EXIT;
272: WHEN UTL_FILE.invalid_operation THEN
273: ec_utils.i_ret_code :=2;
274: ec_debug.pl(0,'EC','ECE_UTL_INVALID_OPERATION',null);
275: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND_STAGE.GET_DATA');
276: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
277: utl_file.fclose(u_file_handle);
278: raise EC_UTILS.PROGRAM_EXIT;
279: WHEN UTL_FILE.invalid_filehandle THEN

Line 282: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND_STAGE.GET_DATA');

278: raise EC_UTILS.PROGRAM_EXIT;
279: WHEN UTL_FILE.invalid_filehandle THEN
280: ec_utils.i_ret_code :=2;
281: ec_debug.pl(0,'EC','ECE_UTL_INVALID_FILEHANDLE',null);
282: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND_STAGE.GET_DATA');
283: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
284: utl_file.fclose(u_file_handle);
285: raise EC_UTILS.PROGRAM_EXIT;
286: WHEN UTL_FILE.internal_error THEN

Line 289: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND_STAGE.GET_DATA');

285: raise EC_UTILS.PROGRAM_EXIT;
286: WHEN UTL_FILE.internal_error THEN
287: ec_utils.i_ret_code :=2;
288: ec_debug.pl(0,'EC','ECE_UTL_INTERNAL_ERROR',null);
289: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND_STAGE.GET_DATA');
290: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
291: utl_file.fclose(u_file_handle);
292: raise EC_UTILS.PROGRAM_EXIT;
293: WHEN EC_UTILS.PROGRAM_EXIT THEN

Line 297: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND_STAGE.GET_DATA');

293: WHEN EC_UTILS.PROGRAM_EXIT THEN
294: raise;
295: WHEN OTHERS THEN
296: ec_utils.i_ret_code :=2;
297: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND_STAGE.GET_DATA');
298: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
299: utl_file.fclose(u_file_handle);
300: raise EC_UTILS.PROGRAM_EXIT;
301: END Get_Data;

Line 341: ec_debug.push('EC_OUTBOUND_STAGE.FETCH_STAGE_DATA');

337: v_transaction_level ece_stage.transaction_level%TYPE;
338: i_new_stage_cursor number := 0;
339: BEGIN
340: if ec_debug.G_debug_level >= 2 then
341: ec_debug.push('EC_OUTBOUND_STAGE.FETCH_STAGE_DATA');
342: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
343: ec_debug.pl(3,'i_run_id',i_run_id);
344: ec_debug.pl(3,'i_parent_stage_id',i_parent_stage_id);
345: ec_debug.pl(3,'i_stage_cursor',i_stage_cursor);

Line 392: -- ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND_STAGE.FETCH_STAGE_DATA');

388: -- dbms_sql.parse(i_stage_cursor,cSelect_stmt,dbms_sql.native);
389: -- EXCEPTION
390: -- WHEN OTHERS THEN
391: -- error_position := dbms_sql.last_error_position;
392: -- ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND_STAGE.FETCH_STAGE_DATA');
393: -- ece_error_handling_pvt.print_parse_error (error_position,cSelect_stmt);
394: -- EC_UTILS.i_ret_code :=2;
395: -- raise EC_UTILS.PROGRAM_EXIT;
396: -- END;

Line 425: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL', 'EC_OUTBOUND_STAGE.FETCH_STAGE_DATA');

421: end if;
422:
423: EXCEPTION
424: WHEN OTHERS THEN
425: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL', 'EC_OUTBOUND_STAGE.FETCH_STAGE_DATA');
426: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
427: ec_debug.pl(0,'EC','ECE_ERROR_SQL',null);
428: ec_debug.pl(0,cSelect_stmt);
429: EC_UTILS.i_ret_code :=2;

Line 466: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL', 'EC_OUTBOUND_STAGE.FETCH_STAGE_DATA');

462: i_common_key);
463: END LOOP;
464: EXCEPTION
465: WHEN OTHERS THEN
466: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL', 'EC_OUTBOUND_STAGE.FETCH_STAGE_DATA');
467: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
468: EC_UTILS.i_ret_code :=2;
469: raise EC_UTILS.PROGRAM_EXIT;
470: END;

Line 477: ec_debug.pop('EC_OUTBOUND_STAGE.FETCH_STAGE_DATA');

473: Close Cursor
474: **/
475: -- dbms_sql.close_cursor(i_stage_cursor);
476: if ec_debug.G_debug_level >= 2 then
477: ec_debug.pop('EC_OUTBOUND_STAGE.FETCH_STAGE_DATA');
478: end if;
479:
480: EXCEPTION
481: WHEN EC_UTILS.PROGRAM_EXIT THEN

Line 484: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND_STAGE.FETCH_STAGE_DATA');

480: EXCEPTION
481: WHEN EC_UTILS.PROGRAM_EXIT THEN
482: raise;
483: WHEN OTHERS THEN
484: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND_STAGE.FETCH_STAGE_DATA');
485: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
486: EC_UTILS.i_ret_code:=2;
487: raise EC_UTILS.PROGRAM_EXIT;
488: END Fetch_Stage_Data;

Line 538: ec_debug.push('EC_OUTBOUND_STAGE.POPULATE_FLATFILE_MAPPING');

534: m_counter number := i_counter;
535: b_tp_found BOOLEAN := FALSE;
536: BEGIN
537: if ec_debug.G_debug_level >= 2 then
538: ec_debug.push('EC_OUTBOUND_STAGE.POPULATE_FLATFILE_MAPPING');
539: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
540: ec_debug.pl(3,'i_Level',i_level);
541: ec_debug.pl(3,'EC','ECE_INTERFACE_MAPPING','TRANSACTION_TYPE',i_transaction_type,'LEVEL',i_level);
542: end if;

Line 622: ec_debug.pop('EC_OUTBOUND_STAGE.POPULATE_FLATFILE_MAPPING');

618: ec_utils.i_ret_code := 2;
619: raise EC_UTILS.PROGRAM_EXIT;
620: end if;
621: if ec_debug.G_debug_level >= 2 then
622: ec_debug.pop('EC_OUTBOUND_STAGE.POPULATE_FLATFILE_MAPPING');
623: end if;
624: EXCEPTION
625: WHEN EC_UTILS.PROGRAM_EXIT then
626: raise;

Line 628: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND_STAGE.POPULATE_FLATFILE_MAPPING');

624: EXCEPTION
625: WHEN EC_UTILS.PROGRAM_EXIT then
626: raise;
627: WHEN OTHERS then
628: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND_STAGE.POPULATE_FLATFILE_MAPPING');
629: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
630: ec_utils.i_ret_code:=2;
631: raise ec_utils.program_exit;
632: END populate_flatfile_mapping;

Line 655: ec_debug.push('EC_OUTBOUND_STAGE.GET_SELECT_STMT');

651: i_rec_ql ece_interface_columns.record_layout_qualifier%TYPE;
652: c_local_chr_39 VARCHAR2(1) := fnd_global.local_chr(39);
653: BEGIN
654: if ec_debug.G_debug_level >= 2 then
655: ec_debug.push('EC_OUTBOUND_STAGE.GET_SELECT_STMT');
656: ec_debug.pl(3,'i_current_level',i_current_level);
657: ec_debug.pl(3,'record_number',i_record_num);
658: ec_debug.pl(3,'i_file_pos',i_file_pos);
659: ec_debug.pl(3,'counter',i_total_rec_unit);

Line 716: ec_debug.pop('EC_OUTBOUND_STAGE.GET_SELECT_STMT');

712: if ec_debug.G_debug_level >= 2 then
713: ec_debug.pl(3,i_file_pos||'|'||
714: i_record_info(i_file_pos).record_number||'|'||
715: i_record_info(i_file_pos).select_stmt);
716: ec_debug.pop('EC_OUTBOUND_STAGE.GET_SELECT_STMT');
717: end if;
718: EXCEPTION
719: WHEN OTHERS then
720: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND_STAGE.GET_SELECT_STMT');

Line 720: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND_STAGE.GET_SELECT_STMT');

716: ec_debug.pop('EC_OUTBOUND_STAGE.GET_SELECT_STMT');
717: end if;
718: EXCEPTION
719: WHEN OTHERS then
720: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND_STAGE.GET_SELECT_STMT');
721: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
722: ec_utils.i_ret_code:=2;
723: raise EC_UTILS.PROGRAM_EXIT;
724: END get_select_stmt;

Line 759: ec_debug.push('EC_OUTBOUND_STAGE.SELECT_FROM_STAGE_TABLE');

755: error_position integer;
756:
757: BEGIN
758: if ec_debug.G_debug_level >= 2 then
759: ec_debug.push('EC_OUTBOUND_STAGE.SELECT_FROM_STAGE_TABLE');
760: ec_debug.pl(3,'i_level',i_level);
761: ec_debug.pl(3,'i_stage_id',i_stage_id);
762: ec_debug.pl(3,'i_select_cursor',i_select_cursor);
763: end if;

Line 811: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND_STAGE.SELECT_FROM_STAGE_TABLE');

807: i_level_info(i_level).total_records := i_select_count;
808: EXCEPTION
809: WHEN OTHERS THEN
810: error_position := dbms_sql.last_error_position;
811: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND_STAGE.SELECT_FROM_STAGE_TABLE');
812: ece_error_handling_pvt.print_parse_error (error_position,cSelect_stmt);
813: EC_UTILS.i_ret_code :=2;
814: raise EC_UTILS.PROGRAM_EXIT;
815: END;

Line 853: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL', 'EC_OUTBOUND_STAGE.SELECT_FROM_STAGE_TABLE');

849: ec_debug.pl(3,'i_select_cursor', i_select_cursor);
850: end if;
851: EXCEPTION
852: WHEN OTHERS THEN
853: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL', 'EC_OUTBOUND_STAGE.SELECT_FROM_STAGE_TABLE');
854: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
855: ec_debug.pl(0,'EC','ECE_ERROR_SQL',null);
856: ec_debug.pl(0,cSelect_stmt);
857: EC_UTILS.i_ret_code :=2;

Line 888: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL', 'EC_OUTBOUND_STAGE.SELECT_FROM_STAGE_TABLE');

884: END LOOP;
885: END LOOP;
886: EXCEPTION
887: WHEN OTHERS THEN
888: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL', 'EC_OUTBOUND_STAGE.SELECT_FROM_STAGE_TABLE');
889: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
890: EC_UTILS.i_ret_code :=2;
891: raise EC_UTILS.PROGRAM_EXIT;
892: END;

Line 898: ec_debug.pop('EC_OUTBOUND_STAGE.SELECT_FROM_STAGE_TABLE');

894: end if;
895: if ec_debug.G_debug_level >= 2 then
896: ec_debug.pl(3,'i_select_cursor',i_select_cursor);
897:
898: ec_debug.pop('EC_OUTBOUND_STAGE.SELECT_FROM_STAGE_TABLE');
899: end if;
900: EXCEPTION
901: WHEN EC_UTILS.PROGRAM_EXIT THEN
902: raise;

Line 908: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND_STAGE.SELECT_FROM_STAGE_TABLE');

904: IF dbms_sql.IS_OPEN(i_select_cursor)
905: then
906: dbms_sql.close_cursor(i_select_cursor);
907: end if;
908: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND_STAGE.SELECT_FROM_STAGE_TABLE');
909: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
910: EC_UTILS.i_ret_code:=2;
911: raise EC_UTILS.PROGRAM_EXIT;
912: END Select_From_Stage_Table;

Line 933: ec_debug.push('EC_OUTBOUND_STAGE.SELECT_COMMON_KEY');

929: is
930: i_common_key_ln INTEGER := 0;
931: BEGIN
932: if ec_debug.G_debug_level >= 2 then
933: ec_debug.push('EC_OUTBOUND_STAGE.SELECT_COMMON_KEY');
934: ec_debug.pl(3,'i_level',i_level);
935: ec_debug.pl(3,'i_tp_code',i_tp_code);
936: ec_debug.pl(3,'i_key_column',i_key_column);
937: ec_debug.pl(3,'i_common_key',i_common_key);

Line 958: ec_debug.pop('EC_OUTBOUND_STAGE.SELECT_COMMON_KEY');

954: i_common_key := i_common_key||RPAD(SUBSTRB(NVL(i_key_column,g_ref_ckey_fl),1,g_ref_ckey_ln),g_ref_ckey_ln,g_ref_ckey_fl);
955:
956: i_common_key := RPAD(SUBSTRB(NVL(i_common_key,g_rec_ckey_fl),1,g_rec_ckey_ln),g_rec_ckey_ln,g_rec_ckey_fl);
957: if ec_debug.G_debug_level >= 2 then
958: ec_debug.pop('EC_OUTBOUND_STAGE.SELECT_COMMON_KEY');
959: end if;
960: EXCEPTION
961: WHEN OTHERS then
962: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND_STAGE.SELECT_COMMON_KEY');

Line 962: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND_STAGE.SELECT_COMMON_KEY');

958: ec_debug.pop('EC_OUTBOUND_STAGE.SELECT_COMMON_KEY');
959: end if;
960: EXCEPTION
961: WHEN OTHERS then
962: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND_STAGE.SELECT_COMMON_KEY');
963: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
964: ec_utils.i_ret_code:=2;
965: raise EC_UTILS.PROGRAM_EXIT;
966: END Select_Common_Key;

Line 968: END EC_OUTBOUND_STAGE;

964: ec_utils.i_ret_code:=2;
965: raise EC_UTILS.PROGRAM_EXIT;
966: END Select_Common_Key;
967:
968: END EC_OUTBOUND_STAGE;