DBA Data[Home] [Help]

APPS.ECX_OUTBOUND dependencies on ECX_OUTBOUND

Line 1: PACKAGE BODY ecx_outbound as

1: PACKAGE BODY ecx_outbound as
2: -- $Header: ECXOUBXB.pls 120.14 2011/03/14 09:38:30 jmaddila ship $
3:
4: l_procedure PLS_INTEGER := ecx_debug.g_procedure;
5: l_statement PLS_INTEGER := ecx_debug.g_statement;

Line 26: i_method_name varchar2(2000) := 'ecx_outbound.move_from_source_to_target';

22: i_target_level IN pls_integer
23: )
24: is
25:
26: i_method_name varchar2(2000) := 'ecx_outbound.move_from_source_to_target';
27: i pls_integer;
28: begin
29: if (l_procedureEnabled) then
30: ecx_debug.push(i_method_name);

Line 111: 'ECX_OUTBOUND.MOVE_FROM_SOURCE_TO_TARGET');

107: exception
108: when others then
109: if(l_unexpectedEnabled) then
110: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
111: 'ECX_OUTBOUND.MOVE_FROM_SOURCE_TO_TARGET');
112: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
113: end if;
114: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.MOVE_FROM_SOURCE_TO_TARGET');
115: if(l_unexpectedEnabled) then

Line 114: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.MOVE_FROM_SOURCE_TO_TARGET');

110: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
111: 'ECX_OUTBOUND.MOVE_FROM_SOURCE_TO_TARGET');
112: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
113: end if;
114: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.MOVE_FROM_SOURCE_TO_TARGET');
115: if(l_unexpectedEnabled) then
116: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_OUTBOUND.MOVE_FROM_SOURCE_TO_TARGET',
117: i_method_name);
118: end if;

Line 116: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_OUTBOUND.MOVE_FROM_SOURCE_TO_TARGET',

112: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
113: end if;
114: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.MOVE_FROM_SOURCE_TO_TARGET');
115: if(l_unexpectedEnabled) then
116: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_OUTBOUND.MOVE_FROM_SOURCE_TO_TARGET',
117: i_method_name);
118: end if;
119: if (l_procedureEnabled) then
120: ecx_debug.pop(i_method_name);

Line 130: i_method_name varchar2(2000) := 'ecx_outbound.processtarget';

126: (
127: i_target in pls_integer
128: )
129: is
130: i_method_name varchar2(2000) := 'ecx_outbound.processtarget';
131: i_init_msg_list varchar2(20);
132: i_simulate varchar2(20);
133: i_validation_level varchar2(20);
134: i_commit varchar2(20);

Line 179: ecx_debug.pop('ECX_OUTBOUND.processTarget');

175: end if;
176:
177: exception
178: when ecx_utils.program_exit then
179: ecx_debug.pop('ECX_OUTBOUND.processTarget');
180: raise ecx_utils.program_exit;
181: when others then
182: if(l_unexpectedEnabled) then
183: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',

Line 184: 'ECX_OUTBOUND.PROCESSTARGET');

180: raise ecx_utils.program_exit;
181: when others then
182: if(l_unexpectedEnabled) then
183: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
184: 'ECX_OUTBOUND.PROCESSTARGET');
185: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
186: end if;
187: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.PROCESSTARGET');
188: if(l_unexpectedEnabled) then

Line 187: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.PROCESSTARGET');

183: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
184: 'ECX_OUTBOUND.PROCESSTARGET');
185: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
186: end if;
187: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.PROCESSTARGET');
188: if(l_unexpectedEnabled) then
189: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_OUTBOUND.PROCESSTARGET',
190: i_method_name);
191: end if;

Line 189: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_OUTBOUND.PROCESSTARGET',

185: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
186: end if;
187: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.PROCESSTARGET');
188: if(l_unexpectedEnabled) then
189: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_OUTBOUND.PROCESSTARGET',
190: i_method_name);
191: end if;
192: if (l_procedureEnabled) then
193: ecx_debug.pop(i_method_name);

Line 206: i_method_name varchar2(2000) := 'ecx_outbound.process_data';

202: i_next IN pls_integer
203: )
204: is
205:
206: i_method_name varchar2(2000) := 'ecx_outbound.process_data';
207: i_init_msg_list varchar2(20);
208: i_simulate varchar2(20);
209: i_validation_level varchar2(20);
210: i_commit varchar2(20);

Line 293: 'ECX_OUTBOUND.PROCESS_DATA');

289: )
290: THEN
291: if(l_statementEnabled) then
292: ecx_debug.log(l_statement,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
293: 'ECX_OUTBOUND.PROCESS_DATA');
294: ecx_debug.log(l_statement,'ECX','EC_CODE_CONVERSION_FAILED',i_method_name,'LEVEL',i);
295: end if;
296: ecx_utils.i_ret_code := 2;
297: RAISE ecx_utils.PROGRAM_EXIT;

Line 403: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.PROCESS_DATA');

399: ecx_debug.pop(i_method_name);
400: end if;
401: raise ecx_utils.program_exit;
402: when others then
403: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.PROCESS_DATA');
404: if(l_unexpectedEnabled) then
405: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_OUTBOUND.PROCESS_DATA',i_method_name);
406: end if;
407: if (l_procedureEnabled) then

Line 405: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_OUTBOUND.PROCESS_DATA',i_method_name);

401: raise ecx_utils.program_exit;
402: when others then
403: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.PROCESS_DATA');
404: if(l_unexpectedEnabled) then
405: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_OUTBOUND.PROCESS_DATA',i_method_name);
406: end if;
407: if (l_procedureEnabled) then
408: ecx_debug.pop(i_method_name);
409: end if;

Line 416: i_method_name varchar2(2000) := 'ecx_outbound.print_stack';

412:
413:
414: procedure print_stack
415: is
416: i_method_name varchar2(2000) := 'ecx_outbound.print_stack';
417: begin
418:
419: if(l_statementEnabled) then
420: ecx_debug.log(l_statement,'Stack Status','====',i_method_name);

Line 430: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.PRINT_STACK');

426: end if;
427: end loop;
428: exception
429: when others then
430: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.PRINT_STACK');
431: if(l_unexpectedEnabled) then
432: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_OUTBOUND.PRINT_STACK',i_method_name);
433: end if;
434: raise ecx_utils.program_exit;

Line 432: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_OUTBOUND.PRINT_STACK',i_method_name);

428: exception
429: when others then
430: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.PRINT_STACK');
431: if(l_unexpectedEnabled) then
432: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_OUTBOUND.PRINT_STACK',i_method_name);
433: end if;
434: raise ecx_utils.program_exit;
435: end print_stack;
436:

Line 442: i_method_name varchar2(2000) := 'ecx_outbound.pop';

438: (
439: i_next in pls_integer
440: )
441: is
442: i_method_name varchar2(2000) := 'ecx_outbound.pop';
443:
444: begin
445: if (l_procedureEnabled) then
446: ecx_debug.push(i_method_name );

Line 482: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.POP');

478: ecx_debug.pop(i_method_name);
479: end if;
480: raise ecx_utils.program_exit;
481: when others then
482: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.POP');
483: if(l_unexpectedEnabled) then
484: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_OUTBOUND.POP',i_method_name);
485: end if;
486: if (l_procedureEnabled) then

Line 484: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_OUTBOUND.POP',i_method_name);

480: raise ecx_utils.program_exit;
481: when others then
482: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.POP');
483: if(l_unexpectedEnabled) then
484: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_OUTBOUND.POP',i_method_name);
485: end if;
486: if (l_procedureEnabled) then
487: ecx_debug.pop(i_method_name);
488: end if;

Line 498: i_method_name varchar2(2000) := 'ecx_outbound.push';

494: i in pls_integer
495: )
496: is
497:
498: i_method_name varchar2(2000) := 'ecx_outbound.push';
499: begin
500: if (l_procedureEnabled) then
501: ecx_debug.push(i_method_name);
502: end if;

Line 594: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.PUSH');

590: ecx_debug.pop(i_method_name);
591: end if;
592: raise ecx_utils.program_exit;
593: when others then
594: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.PUSH');
595: if(l_unexpectedEnabled) then
596: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_OUTBOUND.PUSH',i_method_name);
597: end if;
598: if (l_procedureEnabled) then

Line 596: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_OUTBOUND.PUSH',i_method_name);

592: raise ecx_utils.program_exit;
593: when others then
594: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.PUSH');
595: if(l_unexpectedEnabled) then
596: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_OUTBOUND.PUSH',i_method_name);
597: end if;
598: if (l_procedureEnabled) then
599: ecx_debug.pop(i_method_name);
600: end if;

Line 607: i_method_name varchar2(2000) := 'ecx_outbound.popall';

603:
604:
605: procedure popall
606: is
607: i_method_name varchar2(2000) := 'ecx_outbound.popall';
608: begin
609: if (l_procedureEnabled) then
610: ecx_debug.push(i_method_name );
611: end if;

Line 642: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.POPALL');

638: ecx_debug.pop(i_method_name );
639: end if;
640: raise ecx_utils.program_exit;
641: when others then
642: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.POPALL');
643: if(l_unexpectedEnabled) then
644: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_OUTBOUND.POPALL',i_method_name);
645: end if;
646: if (l_procedureEnabled) then

Line 644: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_OUTBOUND.POPALL',i_method_name);

640: raise ecx_utils.program_exit;
641: when others then
642: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.POPALL');
643: if(l_unexpectedEnabled) then
644: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_OUTBOUND.POPALL',i_method_name);
645: end if;
646: if (l_procedureEnabled) then
647: ecx_debug.pop(i_method_name );
648: end if;

Line 658: i_method_name VARCHAR2(2000) := 'ecx_outbound.fetch_data_from_view';

654: **/
655: PROCEDURE fetch_data_from_view(
656: i_level IN pls_integer )
657: IS
658: i_method_name VARCHAR2(2000) := 'ecx_outbound.fetch_data_from_view';
659: i_column_counter pls_integer :=0;
660: i_rows_processed pls_integer ;
661: i_start_element VARCHAR2(2000);
662: j pls_integer;

Line 789: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name, 'PROGRESS_LEVEL','ECX_OUTBOUND.FETCH_DATA_FROM_VIEW');

785: END IF;
786: EXCEPTION
787: WHEN invalid_number THEN
788: IF(l_unexpectedEnabled) THEN
789: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name, 'PROGRESS_LEVEL','ECX_OUTBOUND.FETCH_DATA_FROM_VIEW');
790: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,
791: 'ERROR_MESSAGE',SQLERRM);
792: end if;
793: ecx_debug.setErrorInfo(2,30,'ECX_INVALID_NUMBER - ECX_OUTBOUND.FETCH_DATA_FROM_VIEW' );

Line 793: ecx_debug.setErrorInfo(2,30,'ECX_INVALID_NUMBER - ECX_OUTBOUND.FETCH_DATA_FROM_VIEW' );

789: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name, 'PROGRESS_LEVEL','ECX_OUTBOUND.FETCH_DATA_FROM_VIEW');
790: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,
791: 'ERROR_MESSAGE',SQLERRM);
792: end if;
793: ecx_debug.setErrorInfo(2,30,'ECX_INVALID_NUMBER - ECX_OUTBOUND.FETCH_DATA_FROM_VIEW' );
794: if (l_procedureEnabled) then
795: ecx_debug.pop(i_method_name);
796: end if;
797: raise ecx_utils.program_exit;

Line 803: 'ECX_OUTBOUND.FETCH_DATA_FROM_VIEW');

799: raise;
800: WHEN OTHERS THEN
801: if(l_unexpectedEnabled) then
802: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
803: 'ECX_OUTBOUND.FETCH_DATA_FROM_VIEW');
804: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
805: end if;
806: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.FETCH_DATA_FROM_VIEW');
807: if(l_unexpectedEnabled) then

Line 806: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.FETCH_DATA_FROM_VIEW');

802: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
803: 'ECX_OUTBOUND.FETCH_DATA_FROM_VIEW');
804: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
805: end if;
806: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.FETCH_DATA_FROM_VIEW');
807: if(l_unexpectedEnabled) then
808: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_OUTBOUND.FETCH_DATA_FROM_VIEW',
809: i_method_name);
810: end if;

Line 808: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_OUTBOUND.FETCH_DATA_FROM_VIEW',

804: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
805: end if;
806: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.FETCH_DATA_FROM_VIEW');
807: if(l_unexpectedEnabled) then
808: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_OUTBOUND.FETCH_DATA_FROM_VIEW',
809: i_method_name);
810: end if;
811: if (l_procedureEnabled) then
812: ecx_debug.pop(i_method_name );

Line 821: i_method_name:='ecx_outbound.log_summary';

817: procedure log_summary(level pls_integer)
818: is
819: i_method_name varchar2(2000);
820: begin
821: i_method_name:='ecx_outbound.log_summary';
822: if (l_procedureEnabled) then
823: ecx_debug.push(i_method_name);
824: end if;
825:

Line 841: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.LOG_SUMMARY');

837: ecx_debug.pop(i_method_name);
838: end if;
839: exception
840: when others then
841: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.LOG_SUMMARY');
842: if(l_unexpectedEnabled) then
843: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_OUTBOUND.LOG_SUMMARY',i_method_name);
844: end if;
845: if (l_procedureEnabled) then

Line 843: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_OUTBOUND.LOG_SUMMARY',i_method_name);

839: exception
840: when others then
841: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.LOG_SUMMARY');
842: if(l_unexpectedEnabled) then
843: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_OUTBOUND.LOG_SUMMARY',i_method_name);
844: end if;
845: if (l_procedureEnabled) then
846: ecx_debug.pop(i_method_name);
847: end if;

Line 870: i_method_name varchar2(2000) := 'ecx_outbound.process_outbound_documents';

866: i_message_type IN varchar2
867: )
868: is
869:
870: i_method_name varchar2(2000) := 'ecx_outbound.process_outbound_documents';
871:
872: i_msgid raw(16);
873: i_dtd_id pls_integer;
874: i_run_id pls_integer;

Line 1264: ecx_outbound.log_summary(l_statement);

1260: end if;
1261: end if;
1262:
1263: if(l_statementEnabled) then
1264: ecx_outbound.log_summary(l_statement);
1265:
1266: ecx_debug.log(l_statement,'ECX','ECX_DOCUMENTS_PROCESSED',i_method_name,'NO_OF_DOCS',
1267: ecx_utils.g_source_levels(0).rows_processed);
1268: ecx_debug.log(l_statement,'ECX','ECX_FINISH_OUTBOUND',i_method_name,'MAP_ID',i_map_id);

Line 1289: ecx_outbound.log_summary(l_unexpected);

1285: WHEN ecx_utils.PROGRAM_EXIT then
1286: if(l_unexpectedEnabled) then
1287: ecx_debug.log(l_unexpected, 'Clean-up i_stack, l_node_stack, i_tmpxml and last_printed',
1288: i_method_name);
1289: ecx_outbound.log_summary(l_unexpected);
1290: end if;
1291: i_stack.DELETE;
1292: ecx_print_local.i_tmpxml.DELETE;
1293: ecx_print_local.l_node_stack.DELETE;

Line 1302: 'ECX_OUTBOUND.PROCESS_OUTBOUND_DOCUMENTS');

1298: raise ecx_utils.program_exit;
1299: WHEN OTHERS THEN
1300: if(l_unexpectedEnabled) then
1301: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
1302: 'ECX_OUTBOUND.PROCESS_OUTBOUND_DOCUMENTS');
1303: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
1304: ecx_outbound.log_summary(l_unexpected);
1305: end if;
1306: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.PROCESS_OUTBOUND_DOCUMENTS');

Line 1304: ecx_outbound.log_summary(l_unexpected);

1300: if(l_unexpectedEnabled) then
1301: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
1302: 'ECX_OUTBOUND.PROCESS_OUTBOUND_DOCUMENTS');
1303: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
1304: ecx_outbound.log_summary(l_unexpected);
1305: end if;
1306: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.PROCESS_OUTBOUND_DOCUMENTS');
1307: if(l_unexpectedEnabled) then
1308: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_OUTBOUND.PROCESS_OUTBOUND_DOCUMENTS',i_method_name);

Line 1306: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.PROCESS_OUTBOUND_DOCUMENTS');

1302: 'ECX_OUTBOUND.PROCESS_OUTBOUND_DOCUMENTS');
1303: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
1304: ecx_outbound.log_summary(l_unexpected);
1305: end if;
1306: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.PROCESS_OUTBOUND_DOCUMENTS');
1307: if(l_unexpectedEnabled) then
1308: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_OUTBOUND.PROCESS_OUTBOUND_DOCUMENTS',i_method_name);
1309: ecx_debug.log(l_unexpected, 'Clean-up i_stack, l_node_stack, i_tmpxml and last_printed',i_method_name);
1310: end if;

Line 1308: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_OUTBOUND.PROCESS_OUTBOUND_DOCUMENTS',i_method_name);

1304: ecx_outbound.log_summary(l_unexpected);
1305: end if;
1306: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.PROCESS_OUTBOUND_DOCUMENTS');
1307: if(l_unexpectedEnabled) then
1308: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_OUTBOUND.PROCESS_OUTBOUND_DOCUMENTS',i_method_name);
1309: ecx_debug.log(l_unexpected, 'Clean-up i_stack, l_node_stack, i_tmpxml and last_printed',i_method_name);
1310: end if;
1311: i_stack.DELETE;
1312: ecx_print_local.i_tmpxml.DELETE;

Line 1350: i_method_name varchar2(2000) := 'ecx_outbound.putmsg';

1346: i_trigger_id IN number,
1347: i_msgid OUT NOCOPY raw
1348: )
1349: is
1350: i_method_name varchar2(2000) := 'ecx_outbound.putmsg';
1351: i_xmldoc CLOB;
1352: ecx_logging_enabled boolean := false;
1353: e_qtimeout exception;
1354: pragma exception_init(e_qtimeout,-25228);

Line 1527: i_from_agt.setname('ECX_OUTBOUND');

1523: else
1524: i_from_agt.setname(i_destination_address);
1525: end if;
1526: else
1527: i_from_agt.setname('ECX_OUTBOUND');
1528: end if;
1529:
1530: end if;
1531: i_from_agt.setsystem(i_system);

Line 1682: i_method_name varchar2(2000) := 'ecx_outbound.putmsg';

1678: i_msgid OUT NOCOPY raw
1679: ) as
1680:
1681:
1682: i_method_name varchar2(2000) := 'ecx_outbound.putmsg';
1683:
1684: -- logging enabled
1685: ecx_logging_enabled boolean := false;
1686: logging_enabled varchar2(20);

Line 1749: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.putmsg ');

1745: i_trigger_id ,
1746: i_msgid );
1747: Exception
1748: WHEN OTHERS THEN
1749: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.putmsg ');
1750: if(l_unexpectedEnabled) then
1751: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_OUTBOUND.putmsg ',
1752: i_method_name);
1753: end if;

Line 1751: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_OUTBOUND.putmsg ',

1747: Exception
1748: WHEN OTHERS THEN
1749: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.putmsg ');
1750: if(l_unexpectedEnabled) then
1751: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_OUTBOUND.putmsg ',
1752: i_method_name);
1753: end if;
1754: raise ecx_utils.PROGRAM_EXIT;
1755: end putmsg;

Line 1775: i_method_name varchar2(2000) := 'ecx_outbound.getxml';

1771: i_log_file OUT NOCOPY varchar2,
1772: i_message_type IN VARCHAR2 default 'XML'
1773: )
1774: is
1775: i_method_name varchar2(2000) := 'ecx_outbound.getxml';
1776: /* Start changes for Bug 2120165 */
1777: i_paramCount number;
1778: /* End of changes for bug 2120165 */
1779: cursor get_run_s

Line 1952: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.PUTMSG');

1948: ecx_debug.print_log;
1949: ecx_debug.disable_debug;
1950: END IF;
1951: WHEN OTHERS THEN
1952: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.PUTMSG');
1953: if(l_unexpectedEnabled) then
1954: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_OUTBOUND.PUTMSG',i_method_name);
1955: end if;
1956: i_ret_code := ecx_utils.i_ret_code;

Line 1954: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_OUTBOUND.PUTMSG',i_method_name);

1950: END IF;
1951: WHEN OTHERS THEN
1952: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.PUTMSG');
1953: if(l_unexpectedEnabled) then
1954: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_OUTBOUND.PUTMSG',i_method_name);
1955: end if;
1956: i_ret_code := ecx_utils.i_ret_code;
1957: i_errbuf := ecx_utils.i_errbuf;
1958: if(l_procedureEnabled) then

Line 1972: end ecx_outbound;

1968: ecx_debug.disable_debug;
1969: END IF;
1970: end GETXML;
1971:
1972: end ecx_outbound;