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.12 2006/12/18 09:40:38 susaha 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 660: i_method_name varchar2(2000) := 'ecx_outbound.fetch_data_from_view';

656: (
657: i_level IN pls_integer
658: )
659: is
660: i_method_name varchar2(2000) := 'ecx_outbound.fetch_data_from_view';
661: i_column_counter pls_integer :=0;
662: i_rows_processed pls_integer ;
663: i_start_element varchar2(2000);
664: j pls_integer;

Line 835: 'PROGRESS_LEVEL','ECX_OUTBOUND.FETCH_DATA_FROM_VIEW');

831: EXCEPTION
832: WHEN invalid_number then
833: if(l_unexpectedEnabled) then
834: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,
835: 'PROGRESS_LEVEL','ECX_OUTBOUND.FETCH_DATA_FROM_VIEW');
836: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,
837: 'ERROR_MESSAGE',SQLERRM);
838: end if;
839: ecx_debug.setErrorInfo(2,30,'ECX_INVALID_NUMBER - ECX_OUTBOUND.FETCH_DATA_FROM_VIEW' );

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

835: 'PROGRESS_LEVEL','ECX_OUTBOUND.FETCH_DATA_FROM_VIEW');
836: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,
837: 'ERROR_MESSAGE',SQLERRM);
838: end if;
839: ecx_debug.setErrorInfo(2,30,'ECX_INVALID_NUMBER - ECX_OUTBOUND.FETCH_DATA_FROM_VIEW' );
840: if (l_procedureEnabled) then
841: ecx_debug.pop(i_method_name);
842: end if;
843: raise ecx_utils.program_exit;

Line 849: 'ECX_OUTBOUND.FETCH_DATA_FROM_VIEW');

845: raise;
846: WHEN OTHERS THEN
847: if(l_unexpectedEnabled) then
848: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
849: 'ECX_OUTBOUND.FETCH_DATA_FROM_VIEW');
850: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
851: end if;
852: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.FETCH_DATA_FROM_VIEW');
853: if(l_unexpectedEnabled) then

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

848: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
849: 'ECX_OUTBOUND.FETCH_DATA_FROM_VIEW');
850: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
851: end if;
852: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.FETCH_DATA_FROM_VIEW');
853: if(l_unexpectedEnabled) then
854: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_OUTBOUND.FETCH_DATA_FROM_VIEW',
855: i_method_name);
856: end if;

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

850: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
851: end if;
852: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.FETCH_DATA_FROM_VIEW');
853: if(l_unexpectedEnabled) then
854: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_OUTBOUND.FETCH_DATA_FROM_VIEW',
855: i_method_name);
856: end if;
857: if (l_procedureEnabled) then
858: ecx_debug.pop(i_method_name );

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

863: procedure log_summary(level pls_integer)
864: is
865: i_method_name varchar2(2000);
866: begin
867: i_method_name:='ecx_outbound.log_summary';
868: if (l_procedureEnabled) then
869: ecx_debug.push(i_method_name);
870: end if;
871:

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

883: ecx_debug.pop(i_method_name);
884: end if;
885: exception
886: when others then
887: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.LOG_SUMMARY');
888: if(l_unexpectedEnabled) then
889: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_OUTBOUND.LOG_SUMMARY',i_method_name);
890: end if;
891: if (l_procedureEnabled) then

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

885: exception
886: when others then
887: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.LOG_SUMMARY');
888: if(l_unexpectedEnabled) then
889: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_OUTBOUND.LOG_SUMMARY',i_method_name);
890: end if;
891: if (l_procedureEnabled) then
892: ecx_debug.pop(i_method_name);
893: end if;

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

912: i_message_type IN varchar2
913: )
914: is
915:
916: i_method_name varchar2(2000) := 'ecx_outbound.process_outbound_documents';
917:
918: i_msgid raw(16);
919: i_dtd_id pls_integer;
920: i_run_id pls_integer;

Line 1299: ecx_outbound.log_summary(l_statement);

1295: end if;
1296: end if;
1297:
1298: if(l_statementEnabled) then
1299: ecx_outbound.log_summary(l_statement);
1300:
1301: ecx_debug.log(l_statement,'ECX','ECX_DOCUMENTS_PROCESSED',i_method_name,'NO_OF_DOCS',
1302: ecx_utils.g_source_levels(0).rows_processed);
1303: ecx_debug.log(l_statement,'ECX','ECX_FINISH_OUTBOUND',i_method_name,'MAP_ID',i_map_id);

Line 1324: ecx_outbound.log_summary(l_unexpected);

1320: WHEN ecx_utils.PROGRAM_EXIT then
1321: if(l_unexpectedEnabled) then
1322: ecx_debug.log(l_unexpected, 'Clean-up i_stack, l_node_stack, i_tmpxml and last_printed',
1323: i_method_name);
1324: ecx_outbound.log_summary(l_unexpected);
1325: end if;
1326: i_stack.DELETE;
1327: ecx_print_local.i_tmpxml.DELETE;
1328: ecx_print_local.l_node_stack.DELETE;

Line 1337: 'ECX_OUTBOUND.PROCESS_OUTBOUND_DOCUMENTS');

1333: raise ecx_utils.program_exit;
1334: WHEN OTHERS THEN
1335: if(l_unexpectedEnabled) then
1336: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
1337: 'ECX_OUTBOUND.PROCESS_OUTBOUND_DOCUMENTS');
1338: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
1339: ecx_outbound.log_summary(l_unexpected);
1340: end if;
1341: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.PROCESS_OUTBOUND_DOCUMENTS');

Line 1339: ecx_outbound.log_summary(l_unexpected);

1335: if(l_unexpectedEnabled) then
1336: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
1337: 'ECX_OUTBOUND.PROCESS_OUTBOUND_DOCUMENTS');
1338: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
1339: ecx_outbound.log_summary(l_unexpected);
1340: end if;
1341: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.PROCESS_OUTBOUND_DOCUMENTS');
1342: if(l_unexpectedEnabled) then
1343: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_OUTBOUND.PROCESS_OUTBOUND_DOCUMENTS',i_method_name);

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

1337: 'ECX_OUTBOUND.PROCESS_OUTBOUND_DOCUMENTS');
1338: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
1339: ecx_outbound.log_summary(l_unexpected);
1340: end if;
1341: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.PROCESS_OUTBOUND_DOCUMENTS');
1342: if(l_unexpectedEnabled) then
1343: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_OUTBOUND.PROCESS_OUTBOUND_DOCUMENTS',i_method_name);
1344: ecx_debug.log(l_unexpected, 'Clean-up i_stack, l_node_stack, i_tmpxml and last_printed',i_method_name);
1345: end if;

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

1339: ecx_outbound.log_summary(l_unexpected);
1340: end if;
1341: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.PROCESS_OUTBOUND_DOCUMENTS');
1342: if(l_unexpectedEnabled) then
1343: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_OUTBOUND.PROCESS_OUTBOUND_DOCUMENTS',i_method_name);
1344: ecx_debug.log(l_unexpected, 'Clean-up i_stack, l_node_stack, i_tmpxml and last_printed',i_method_name);
1345: end if;
1346: i_stack.DELETE;
1347: ecx_print_local.i_tmpxml.DELETE;

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

1381: i_trigger_id IN number,
1382: i_msgid OUT NOCOPY raw
1383: )
1384: is
1385: i_method_name varchar2(2000) := 'ecx_outbound.putmsg';
1386: i_xmldoc CLOB;
1387: ecx_logging_enabled boolean := false;
1388: e_qtimeout exception;
1389: pragma exception_init(e_qtimeout,-25228);

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

1558: else
1559: i_from_agt.setname(i_destination_address);
1560: end if;
1561: else
1562: i_from_agt.setname('ECX_OUTBOUND');
1563: end if;
1564:
1565: end if;
1566: i_from_agt.setsystem(i_system);

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

1713: i_msgid OUT NOCOPY raw
1714: ) as
1715:
1716:
1717: i_method_name varchar2(2000) := 'ecx_outbound.putmsg';
1718:
1719: -- logging enabled
1720: ecx_logging_enabled boolean := false;
1721: logging_enabled varchar2(20);

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

1780: i_trigger_id ,
1781: i_msgid );
1782: Exception
1783: WHEN OTHERS THEN
1784: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.putmsg ');
1785: if(l_unexpectedEnabled) then
1786: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_OUTBOUND.putmsg ',
1787: i_method_name);
1788: end if;

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

1782: Exception
1783: WHEN OTHERS THEN
1784: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.putmsg ');
1785: if(l_unexpectedEnabled) then
1786: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_OUTBOUND.putmsg ',
1787: i_method_name);
1788: end if;
1789: raise ecx_utils.PROGRAM_EXIT;
1790: end putmsg;

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

1806: i_log_file OUT NOCOPY varchar2,
1807: i_message_type IN VARCHAR2 default 'XML'
1808: )
1809: is
1810: i_method_name varchar2(2000) := 'ecx_outbound.getxml';
1811: /* Start changes for Bug 2120165 */
1812: i_paramCount number;
1813: /* End of changes for bug 2120165 */
1814: cursor get_run_s

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

1983: ecx_debug.print_log;
1984: ecx_debug.disable_debug;
1985: END IF;
1986: WHEN OTHERS THEN
1987: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.PUTMSG');
1988: if(l_unexpectedEnabled) then
1989: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_OUTBOUND.PUTMSG',i_method_name);
1990: end if;
1991: i_ret_code := ecx_utils.i_ret_code;

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

1985: END IF;
1986: WHEN OTHERS THEN
1987: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_OUTBOUND.PUTMSG');
1988: if(l_unexpectedEnabled) then
1989: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_OUTBOUND.PUTMSG',i_method_name);
1990: end if;
1991: i_ret_code := ecx_utils.i_ret_code;
1992: i_errbuf := ecx_utils.i_errbuf;
1993: if(l_procedureEnabled) then

Line 2007: end ecx_outbound;

2003: ecx_debug.disable_debug;
2004: END IF;
2005: end GETXML;
2006:
2007: end ecx_outbound;