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 dependencies on EC_OUTBOUND

Line 1: PACKAGE BODY ec_outbound as

1: PACKAGE BODY ec_outbound as
2: -- $Header: ECOUBB.pls 120.3 2005/09/29 11:18:59 arsriniv ship $
3:
4: cursor seq_stage_id
5: is

Line 33: ec_debug.push('EC_OUTBOUND.PARSE_INSERT_STATEMENT');

29: dummy pls_integer;
30: error_position pls_integer;
31: begin
32: if ec_debug.G_debug_level >= 2 then
33: ec_debug.push('EC_OUTBOUND.PARSE_INSERT_STATEMENT');
34: ec_debug.pl(3,'i_level',i_level);
35: end if;
36:
37: --- Add Mandatory Columns for the Record

Line 84: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND.PARSE_INSERT_STATEMENT');

80: dbms_sql.parse(i_Insert_Cursor,cInsert_stmt,dbms_sql.native);
81: exception
82: when others then
83: error_position := dbms_sql.last_error_position;
84: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND.PARSE_INSERT_STATEMENT');
85: ece_error_handling_pvt.print_parse_error (error_position,cInsert_stmt);
86: ec_utils.i_ret_code :=2;
87: raise EC_UTILS.PROGRAM_EXIT;
88: end;

Line 90: ec_debug.pop('EC_OUTBOUND.PARSE_INSERT_STATEMENT');

86: ec_utils.i_ret_code :=2;
87: raise EC_UTILS.PROGRAM_EXIT;
88: end;
89: if ec_debug.G_debug_level >= 2 then
90: ec_debug.pop('EC_OUTBOUND.PARSE_INSERT_STATEMENT');
91: end if;
92:
93: EXCEPTION
94: WHEN EC_UTILS.PROGRAM_EXIT then

Line 97: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND.PARSE_INSERT_STATEMENT');

93: EXCEPTION
94: WHEN EC_UTILS.PROGRAM_EXIT then
95: raise;
96: WHEN OTHERS THEN
97: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND.PARSE_INSERT_STATEMENT');
98: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
99: ec_utils.i_ret_code :=2;
100: raise EC_UTILS.PROGRAM_EXIT;
101: END parse_insert_statement;

Line 124: EC_DEBUG.PUSH('EC_OUTBOUND.SELECT_CLAUSE');

120: iRow_count pls_integer := ec_utils.g_file_tbl.COUNT;
121:
122: BEGIN
123: if ec_debug.G_debug_level >= 2 then
124: EC_DEBUG.PUSH('EC_OUTBOUND.SELECT_CLAUSE');
125: EC_DEBUG.PL(3, 'i_level',i_level);
126: end if;
127:
128: For i in ec_utils.g_int_levels(i_level).file_start_pos..ec_utils.g_int_levels(i_level).file_end_pos

Line 161: EC_DEBUG.POP('EC_OUTBOUND.SELECT_CLAUSE');

157: i_Where_string := cSelect_stmt||' '||cFrom_stmt||' '||cWhere_Stmt;
158:
159: if ec_debug.G_debug_level >= 2 then
160: ec_debug.pl(3,'i_Where_String',i_Where_String);
161: EC_DEBUG.POP('EC_OUTBOUND.SELECT_CLAUSE');
162: end if;
163:
164: exception
165: when others then

Line 166: EC_DEBUG.PL(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND.SELECT_CLAUSE');

162: end if;
163:
164: exception
165: when others then
166: EC_DEBUG.PL(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND.SELECT_CLAUSE');
167: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
168: ec_utils.i_ret_code :=2;
169: raise EC_UTILS.PROGRAM_EXIT;
170: END select_clause;

Line 184: ec_debug.push('EC_OUTBOUND.LOAD_OBJECTS');

180: is
181: i_counter pls_integer :=0;
182: begin
183: if ec_debug.G_debug_level >= 2 then
184: ec_debug.push('EC_OUTBOUND.LOAD_OBJECTS');
185: end if;
186:
187: for i in 1..ec_utils.g_int_levels.COUNT
188: LOOP

Line 222: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND.LOAD_OBJECTS');

218: (
219: dbms_sql.last_error_position,
220: ec_utils.g_int_levels(i).sql_stmt
221: );
222: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND.LOAD_OBJECTS');
223: ec_debug.pl(0,'EC','ECE_PARSE_VIEW_ERROR','LEVEL',i);
224: raise EC_UTILS.PROGRAM_EXIT;
225: END;
226:

Line 254: ec_debug.pop('EC_OUTBOUND.LOAD_OBJECTS');

250: i
251: );
252: end loop;
253: if ec_debug.G_debug_level >= 2 then
254: ec_debug.pop('EC_OUTBOUND.LOAD_OBJECTS');
255: end if;
256:
257: EXCEPTION
258: WHEN EC_UTILS.PROGRAM_EXIT then

Line 261: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND.LOAD_OBJECTS');

257: EXCEPTION
258: WHEN EC_UTILS.PROGRAM_EXIT then
259: raise;
260: WHEN OTHERS THEN
261: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND.LOAD_OBJECTS');
262: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
263: ec_utils.i_ret_code :=2;
264: raise EC_UTILS.PROGRAM_EXIT;
265: end load_objects;

Line 283: ec_debug.push('EC_OUTBOUND.BIND_INSERT_STATEMENT');

279: i_status ece_stage.status%TYPE := 'NEW';
280: ins_value varchar2(32000);
281: begin
282: if ec_debug.G_debug_level >= 2 then
283: ec_debug.push('EC_OUTBOUND.BIND_INSERT_STATEMENT');
284: ec_debug.pl(3,'i_level',i_level);
285: end if;
286:
287: begin

Line 346: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND.BIND_INSERT_STATEMENT');

342: ec_debug.pl(3,'EC','ECE_STAGE_INSERTED',null);
343: end if;
344: else
345: ec_debug.pl(0,'EC','ECE_STAGE_INSERT_FAILED','LEVEL',i_level);
346: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND.BIND_INSERT_STATEMENT');
347: ec_utils.i_ret_code :=2;
348: raise EC_UTILS.PROGRAM_EXIT;
349: end if;
350:

Line 353: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND.BIND_INSERT_STATEMENT');

349: end if;
350:
351: exception
352: when others then
353: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND.BIND_INSERT_STATEMENT');
354: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
355: ec_debug.pl(0,'EC','ECE_ERROR_SQL',null);
356:
357: ec_utils.i_ret_code :=2;

Line 361: ec_debug.pop('EC_OUTBOUND.BIND_INSERT_STATEMENT');

357: ec_utils.i_ret_code :=2;
358: raise EC_UTILS.PROGRAM_EXIT;
359: end;
360: if ec_debug.G_debug_level >= 2 then
361: ec_debug.pop('EC_OUTBOUND.BIND_INSERT_STATEMENT');
362: end if;
363: EXCEPTION
364: WHEN EC_UTILS.PROGRAM_EXIT then
365: raise;

Line 367: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND.BIND_INSERT_STATEMENT');

363: EXCEPTION
364: WHEN EC_UTILS.PROGRAM_EXIT then
365: raise;
366: WHEN OTHERS THEN
367: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND.BIND_INSERT_STATEMENT');
368: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
369: ec_utils.i_ret_code :=2;
370: raise EC_UTILS.PROGRAM_EXIT;
371: END bind_insert_statement;

Line 388: ec_debug.push('EC_OUTBOUND.INSERT_INTO_STAGE');

384: i_document_id pls_integer;
385: i_line_number pls_integer :=0;
386: begin
387: if ec_debug.G_debug_level >= 2 then
388: ec_debug.push('EC_OUTBOUND.INSERT_INTO_STAGE');
389: ec_debug.pl(3,'i_level',i_level);
390: end if;
391:
392: -- Generate Stage Id anyways

Line 478: ec_debug.pop('EC_OUTBOUND.INSERT_INTO_STAGE');

474: (
475: i_level
476: );
477: if ec_debug.G_debug_level >= 2 then
478: ec_debug.pop('EC_OUTBOUND.INSERT_INTO_STAGE');
479: end if;
480:
481: EXCEPTION
482: WHEN EC_UTILS.PROGRAM_EXIT then

Line 485: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND.INSERT_INTO_STAGE');

481: EXCEPTION
482: WHEN EC_UTILS.PROGRAM_EXIT then
483: raise;
484: WHEN OTHERS THEN
485: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND.INSERT_INTO_STAGE');
486: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
487: ec_utils.i_ret_code :=2;
488: raise EC_UTILS.PROGRAM_EXIT;
489: END insert_into_stage;

Line 514: ec_debug.push('EC_OUTBOUND.FETCH_DATA_FROM_VIEW');

510:
511:
512: BEGIN
513: if ec_debug.G_debug_level >= 2 then
514: ec_debug.push('EC_OUTBOUND.FETCH_DATA_FROM_VIEW');
515: ec_debug.pl(3,'i_level',i_level);
516: end if;
517:
518: for i in 1..ec_utils.g_int_levels.COUNT

Line 611: 'EC_OUTBOUND.FETCH_DATA_FROM_VIEW');

607: i_return_status = FND_API.G_RET_STS_UNEXP_ERROR
608: )
609: THEN
610: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',
611: 'EC_OUTBOUND.FETCH_DATA_FROM_VIEW');
612: ec_debug.pl(0,'EC','EC_CODE_CONVERSION_FAILED','LEVEL',i);
613: ec_utils.i_ret_code := 2;
614: RAISE EC_UTILS.PROGRAM_EXIT;
615: END IF;

Line 663: 'EC_OUTBOUND.FETCH_DATA_FROM_VIEW');

659: i_return_status = FND_API.G_RET_STS_UNEXP_ERROR
660: )
661: THEN
662: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',
663: 'EC_OUTBOUND.FETCH_DATA_FROM_VIEW');
664: ec_debug.pl(0,'EC','EC_CODE_CONVERSION_FAILED','LEVEL',i);
665: ec_utils.i_ret_code := 2;
666: RAISE EC_UTILS.PROGRAM_EXIT;
667: END IF;

Line 710: ec_debug.pop('EC_OUTBOUND.FETCH_DATA_FROM_VIEW');

706:
707: END IF;
708: end loop;
709: if ec_debug.G_debug_level >= 2 then
710: ec_debug.pop('EC_OUTBOUND.FETCH_DATA_FROM_VIEW');
711: end if;
712:
713: EXCEPTION
714: WHEN EC_UTILS.PROGRAM_EXIT then

Line 717: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND.FETCH_DATA_FROM_VIEW');

713: EXCEPTION
714: WHEN EC_UTILS.PROGRAM_EXIT then
715: raise;
716: WHEN OTHERS THEN
717: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND.FETCH_DATA_FROM_VIEW');
718: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
719: ec_utils.i_ret_code :=2;
720: raise EC_UTILS.PROGRAM_EXIT;
721: END fetch_data_from_view;

Line 730: ec_debug.push('EC_OUTBOUND.CLOSE_OUTBOUND');

726: procedure close_outbound
727: is
728: begin
729: if ec_debug.G_debug_level >= 2 then
730: ec_debug.push('EC_OUTBOUND.CLOSE_OUTBOUND');
731: end if;
732: /**
733: Successful execution of the transaction. Close the Cursor handles,
734: Disbale the Debug.

Line 762: ec_debug.pop('EC_OUTBOUND.CLOSE_OUTBOUND');

758: dbms_sql.close_cursor(ec_utils.g_ext_levels(i).cursor_handle);
759: end if;
760: end loop;
761: if ec_debug.G_debug_level >= 2 then
762: ec_debug.pop('EC_OUTBOUND.CLOSE_OUTBOUND');
763: end if;
764:
765: exception
766: WHEN OTHERS THEN

Line 767: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND.CLOSE_OUTBOUND');

763: end if;
764:
765: exception
766: WHEN OTHERS THEN
767: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND.CLOSE_OUTBOUND');
768: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
769: ec_utils.i_ret_code :=2;
770: raise EC_UTILS.PROGRAM_EXIT;
771: end close_outbound;

Line 789: ec_debug.push('EC_OUTBOUND.PROCESS_OUTBOUND_DOCUMENTS');

785: ec_debug.pl(0,'EC','ECE_START_OUTBOUND','TRANSACTION_TYPE',i_transaction_type,'MAP_ID',i_map_id);
786: if ec_debug.G_debug_level >= 2 then
787: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
788: ec_debug.pl(3,'i_map_id',i_map_id);
789: ec_debug.push('EC_OUTBOUND.PROCESS_OUTBOUND_DOCUMENTS');
790: end if;
791:
792: /** Initialize Memory Structures**/
793: ec_utils.g_file_tbl.DELETE;

Line 870: ec_debug.pop('EC_OUTBOUND.PROCESS_OUTBOUND_DOCUMENTS');

866: ec_debug.pl(0,'EC','ECE_DOCUMENTS_PROCESSED','NO_OF_DOCS',ec_utils.g_int_levels(1).rows_processed);
867:
868: close_outbound;
869: if ec_debug.G_debug_level >= 2 then
870: ec_debug.pop('EC_OUTBOUND.PROCESS_OUTBOUND_DOCUMENTS');
871: end if;
872: ec_debug.pl(0,'EC','ECE_FINISH_OUTBOUND','TRANSACTION_TYPE',i_transaction_type,'MAP_ID',i_map_id);
873: EXCEPTION
874: WHEN EC_UTILS.PROGRAM_EXIT then

Line 877: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND.PROCESS_OUTBOUND_DOCUMENTS');

873: EXCEPTION
874: WHEN EC_UTILS.PROGRAM_EXIT then
875: raise;
876: WHEN OTHERS THEN
877: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND.PROCESS_OUTBOUND_DOCUMENTS');
878: ec_debug.pl(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
879: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
880: close_outbound;
881: ec_debug.pop('EC_OUTBOUND.PROCESS_OUTBOUND_DOCUMENTS');

Line 881: ec_debug.pop('EC_OUTBOUND.PROCESS_OUTBOUND_DOCUMENTS');

877: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND.PROCESS_OUTBOUND_DOCUMENTS');
878: ec_debug.pl(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
879: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
880: close_outbound;
881: ec_debug.pop('EC_OUTBOUND.PROCESS_OUTBOUND_DOCUMENTS');
882: raise EC_UTILS.PROGRAM_EXIT;
883: end process_outbound_documents;
884:
885: /**

Line 898: ec_debug.push('EC_OUTBOUND.DELETE_STAGE_DATA');

894: i_document_id IN number DEFAULT NULL
895: ) IS
896: BEGIN
897: if ec_debug.G_debug_level >= 2 then
898: ec_debug.push('EC_OUTBOUND.DELETE_STAGE_DATA');
899: ec_debug.pl(3,'i_run_id',i_run_id);
900: ec_debug.pl(3,'i_document_id',i_document_id);
901: end if;
902: IF i_run_id IS NULL THEN

Line 903: ec_debug.pl(0,'EC','ECE_PARAM_MISSING','PARAMETER','I_RUN_ID', 'PROCEDURE','EC_OUTBOUND.DELETE_STAGE_DATA');

899: ec_debug.pl(3,'i_run_id',i_run_id);
900: ec_debug.pl(3,'i_document_id',i_document_id);
901: end if;
902: IF i_run_id IS NULL THEN
903: ec_debug.pl(0,'EC','ECE_PARAM_MISSING','PARAMETER','I_RUN_ID', 'PROCEDURE','EC_OUTBOUND.DELETE_STAGE_DATA');
904: /**
905: Set the FAILURE Retcode for the Concurrent Manager
906: **/
907: EC_UTILS.i_ret_code := 2;

Line 929: ec_debug.pop('EC_OUTBOUND.DELETE_STAGE_DATA');

925: END IF;
926: if ec_debug.G_debug_level >= 2 then
927: ec_debug.pl(3,'Number of rows deleted from ECE_STAGE',SQL%ROWCOUNT);
928:
929: ec_debug.pop('EC_OUTBOUND.DELETE_STAGE_DATA');
930: end if;
931: EXCEPTION
932: WHEN EC_UTILS.PROGRAM_EXIT then
933: raise;

Line 935: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND.DELETE_STAGE_DATA');

931: EXCEPTION
932: WHEN EC_UTILS.PROGRAM_EXIT then
933: raise;
934: WHEN OTHERS THEN
935: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND.DELETE_STAGE_DATA');
936: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
937: ec_utils.i_ret_code:=2;
938: raise EC_UTILS.PROGRAM_EXIT;
939: END delete_stage_data;

Line 941: end ec_outbound;

937: ec_utils.i_ret_code:=2;
938: raise EC_UTILS.PROGRAM_EXIT;
939: END delete_stage_data;
940:
941: end ec_outbound;