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.ECX_DOCUMENT dependencies on ECX_UTILS

Line 58: raise ecx_utils.program_exit;

54: where internal_control_number = p_document_id;
55: exception
56: when no_data_found then
57: ecx_debug.setErrorInfo(2,30,'ECX_CONFIRM_DOC_NOT_FOUND');
58: raise ecx_utils.program_exit;
59: end;
60:
61: if i_transaction_type = 'BOD'
62: then

Line 64: raise ecx_utils.program_exit;

60:
61: if i_transaction_type = 'BOD'
62: then
63: ecx_debug.setErrorInfo(2,30,'ECX_CONFIRM_GENERATE_FAILED');
64: raise ecx_utils.program_exit;
65: end if;
66:
67: if(l_statementEnabled) then
68: ecx_debug.log(l_statement, 'Document Confirmation',i_confirmation,i_method_name);

Line 121: raise ecx_utils.program_exit;

117: 'p_transaction_subtype',
118: p_transaction_subtype,
119: 'p_location_code',
120: i_location_code);
121: raise ecx_utils.program_exit;
122:
123: /* Start of bug #2183619*/
124: when too_many_rows then
125: ecx_debug.setErrorInfo(2,30,'ECX_PARTY_TYPE_NOT_SET ');

Line 126: raise ecx_utils.program_exit;

122:
123: /* Start of bug #2183619*/
124: when too_many_rows then
125: ecx_debug.setErrorInfo(2,30,'ECX_PARTY_TYPE_NOT_SET ');
126: raise ecx_utils.program_exit;
127: /* End of bug #2183619 */
128:
129: end;
130: if(l_statementEnabled) then

Line 143: when ecx_utils.program_exit then

139: if (l_procedureEnabled) then
140: ecx_debug.pop(i_method_name);
141: end if;
142: raise;
143: when ecx_utils.program_exit then
144: if (l_procedureEnabled) then
145: ecx_debug.pop(i_method_name);
146: end if;
147: raise ecx_utils.program_exit;

Line 147: raise ecx_utils.program_exit;

143: when ecx_utils.program_exit then
144: if (l_procedureEnabled) then
145: ecx_debug.pop(i_method_name);
146: end if;
147: raise ecx_utils.program_exit;
148: when others then
149: ecx_debug.setErrorInfo(2,30,SQLERRM ||'- ECX_DOCUMENT.getConfirmation');
150: if (l_procedureEnabled) then
151: ecx_debug.pop(i_method_name);

Line 153: raise ecx_utils.program_exit;

149: ecx_debug.setErrorInfo(2,30,SQLERRM ||'- ECX_DOCUMENT.getConfirmation');
150: if (l_procedureEnabled) then
151: ecx_debug.pop(i_method_name);
152: end if;
153: raise ecx_utils.program_exit;
154: end getConfirmation;
155:
156: /**
157: Format and Queue the Outbound Engine Object for delivery

Line 283: raise ecx_utils.program_exit;

279: ecx_debug.setErrorInfo(2,30,SQLERRM ||'- ECX_DOCUMENT.PUT_ON_ENGQUEUE');
280: if (l_procedureEnabled) then
281: ecx_debug.pop(i_method_name);
282: end if;
283: raise ecx_utils.program_exit;
284: end put_on_engqueue;
285:
286: /* Get Delivery Attributes */
287: PROCEDURE get_delivery_attribs

Line 342: raise ecx_utils.program_exit;

338: Exception
339: /* Start of bug #2183619*/
340: when too_many_rows then
341: ecx_debug.setErrorInfo(2,30,'ECX_PARTY_TYPE_NOT_SET');
342: raise ecx_utils.program_exit;
343: /* End of bug #2183619 */
344: When Others then
345: /** Email goes to Sys Admin***/
346: ecx_debug.setErrorInfo(1,30,'ECX_TRANSACTION_NOT_FOUND',

Line 392: ecx_utils.g_tp_dtl_id

388: i_ext_type,
389: i_ext_subtype,
390: i_party_type,
391: i_tp_header_id,
392: ecx_utils.g_tp_dtl_id
393: from ecx_tp_details etd,
394: ecx_tp_headers eth,
395: ecx_ext_processes eep,
396: ecx_transactions et,

Line 415: raise ecx_utils.program_exit;

411: exception
412: /* Start of bug #2183619*/
413: when too_many_rows then
414: ecx_debug.setErrorInfo(2,30,'ECX_PARTY_TYPE_NOT_SET');
415: raise ecx_utils.program_exit;
416: /* End of bug #2183619 */
417: when others then
418: /** Email goes to Sys Admin***/
419: ecx_debug.setErrorInfo(1,30,'ECX_DELIVERY_TP_NOT_SETUP',

Line 508: WHEN ECX_UTILS.PROGRAM_EXIT THEN

504: if (l_procedureEnabled) then
505: ecx_debug.pop(i_method_name);
506: end if;
507: raise;
508: WHEN ECX_UTILS.PROGRAM_EXIT THEN
509: if (l_procedureEnabled) then
510: ecx_debug.pop(i_method_name);
511: end if;
512: raise ecx_utils.program_exit;

Line 512: raise ecx_utils.program_exit;

508: WHEN ECX_UTILS.PROGRAM_EXIT THEN
509: if (l_procedureEnabled) then
510: ecx_debug.pop(i_method_name);
511: end if;
512: raise ecx_utils.program_exit;
513: WHEN OTHERS THEN
514: ecx_debug.setErrorInfo(2,30,SQLERRM ||'- ECX_DOCUMENT.GET_DELIVERY_ATTRIBS');
515: if (l_procedureEnabled) then
516: ecx_debug.pop(i_method_name);

Line 518: raise ecx_utils.program_exit;

514: ecx_debug.setErrorInfo(2,30,SQLERRM ||'- ECX_DOCUMENT.GET_DELIVERY_ATTRIBS');
515: if (l_procedureEnabled) then
516: ecx_debug.pop(i_method_name);
517: end if;
518: raise ecx_utils.program_exit;
519: END get_delivery_attribs;
520:
521: /* This SEND is used by the CM */
522: /*PROCEDURE send_cm(

Line 693: when ecx_utils.program_exit then

689: if (l_procedureEnabled) then
690: ecx_debug.pop(i_method_name);
691: end if;
692: raise;
693: when ecx_utils.program_exit then
694: if (l_procedureEnabled) then
695: ecx_debug.pop(i_method_name);
696: end if;
697: raise ecx_utils.program_exit;

Line 697: raise ecx_utils.program_exit;

693: when ecx_utils.program_exit then
694: if (l_procedureEnabled) then
695: ecx_debug.pop(i_method_name);
696: end if;
697: raise ecx_utils.program_exit;
698: when others then
699: ecx_debug.setErrorInfo(2,30,SQLERRM ||'- ECX_DOCUMENT.TRIGGER_OUTBOUND');
700: if (l_procedureEnabled) then
701: ecx_debug.pop(i_method_name);

Line 703: raise ecx_utils.program_exit;

699: ecx_debug.setErrorInfo(2,30,SQLERRM ||'- ECX_DOCUMENT.TRIGGER_OUTBOUND');
700: if (l_procedureEnabled) then
701: ecx_debug.pop(i_method_name);
702: end if;
703: raise ecx_utils.program_exit;
704: end trigger_outbound;
705:
706:
707: /* The SEND routine A-Synchronous Call */

Line 802: ecx_utils.getLogDirectory;

798:
799: IF (ecx_logging_enabled ) THEN
800:
801: --- Sets the Log Directory in both Standalone and the Embedded mode
802: ecx_utils.getLogDirectory;
803: p_aflog_module_name := 'trig.';
804: IF (transaction_type is not null) THEN
805: p_aflog_module_name := p_aflog_module_name||transaction_type||'.';
806: END IF;

Line 818: ecx_debug.enable_debug_new(debug_mode, ecx_utils.g_logdir, 'TRIG'||transaction_type||transaction_subtype||

814: p_aflog_module_name := p_aflog_module_name||trigger_id;
815: END IF;
816: p_aflog_module_name := p_aflog_module_name||'.log';
817:
818: ecx_debug.enable_debug_new(debug_mode, ecx_utils.g_logdir, 'TRIG'||transaction_type||transaction_subtype||
819: document_id||trigger_id||'.log', p_aflog_module_name);
820: END IF;
821:
822: /* Assign local variables with the ecx_debug global variables*/

Line 849: Initialize the ecx_utils.i_ret_code and i_errbuf variables;

845: ecx_debug.log(l_statement,'debug_mode',debug_mode,i_method_name);
846: end if;
847:
848: /**
849: Initialize the ecx_utils.i_ret_code and i_errbuf variables;
850: **/
851: ecx_utils.i_ret_code :=0;
852: ecx_utils.i_errbuf := null;
853: --MLS

Line 851: ecx_utils.i_ret_code :=0;

847:
848: /**
849: Initialize the ecx_utils.i_ret_code and i_errbuf variables;
850: **/
851: ecx_utils.i_ret_code :=0;
852: ecx_utils.i_errbuf := null;
853: --MLS
854: ecx_utils.i_errparams := null;
855: i_count :=0;

Line 852: ecx_utils.i_errbuf := null;

848: /**
849: Initialize the ecx_utils.i_ret_code and i_errbuf variables;
850: **/
851: ecx_utils.i_ret_code :=0;
852: ecx_utils.i_errbuf := null;
853: --MLS
854: ecx_utils.i_errparams := null;
855: i_count :=0;
856:

Line 854: ecx_utils.i_errparams := null;

850: **/
851: ecx_utils.i_ret_code :=0;
852: ecx_utils.i_errbuf := null;
853: --MLS
854: ecx_utils.i_errparams := null;
855: i_count :=0;
856:
857: -- invoke trigger_outbound which will invoke outbound_trigger, getConfirmation and
858: -- get_delivery_attribs

Line 862: document_id, ecx_utils.i_ret_code,

858: -- get_delivery_attribs
859: ecx_debug.setErrorInfo(10,10,'ECX_TRIGGER_OUTBOUND');
860: trigger_outbound (transaction_type, transaction_subtype,
861: party_id, party_site_id,
862: document_id, ecx_utils.i_ret_code,
863: ecx_utils.i_errbuf, trigger_id,
864: p_party_type, p_party_id, p_party_site_id, p_message_type,
865: p_message_standard, p_ext_type, p_ext_subtype, p_source_code,
866: p_destination_code, p_destination_type, p_destination_address,

Line 863: ecx_utils.i_errbuf, trigger_id,

859: ecx_debug.setErrorInfo(10,10,'ECX_TRIGGER_OUTBOUND');
860: trigger_outbound (transaction_type, transaction_subtype,
861: party_id, party_site_id,
862: document_id, ecx_utils.i_ret_code,
863: ecx_utils.i_errbuf, trigger_id,
864: p_party_type, p_party_id, p_party_site_id, p_message_type,
865: p_message_standard, p_ext_type, p_ext_subtype, p_source_code,
866: p_destination_code, p_destination_type, p_destination_address,
867: p_username, p_password, p_map_code,

Line 868: p_queue_name, ecx_utils.g_rec_tp_id);

864: p_party_type, p_party_id, p_party_site_id, p_message_type,
865: p_message_standard, p_ext_type, p_ext_subtype, p_source_code,
866: p_destination_code, p_destination_type, p_destination_address,
867: p_username, p_password, p_map_code,
868: p_queue_name, ecx_utils.g_rec_tp_id);
869:
870: -- take appropriate action for destination_type
871: If p_destination_type = 'NONE' Then
872: /** No email Action required **/

Line 920: retcode := ecx_utils.i_ret_code;

916: i_msgid
917: );
918:
919: --- Assign the values back to the program OUT variables.
920: retcode := ecx_utils.i_ret_code;
921: errmsg := ecx_utils.i_errbuf;
922:
923: if(l_statementEnabled) then
924: ecx_debug.log(l_statement,'trigger_id',trigger_id,i_method_name);

Line 921: errmsg := ecx_utils.i_errbuf;

917: );
918:
919: --- Assign the values back to the program OUT variables.
920: retcode := ecx_utils.i_ret_code;
921: errmsg := ecx_utils.i_errbuf;
922:
923: if(l_statementEnabled) then
924: ecx_debug.log(l_statement,'trigger_id',trigger_id,i_method_name);
925: end if;

Line 929: ecx_utils.i_errparams),i_method_name); --MLS

925: end if;
926: if(l_unexpectedEnabled) then
927: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
928: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
929: ecx_utils.i_errparams),i_method_name); --MLS
930: end if;
931:
932: if (l_procedureEnabled) then
933: ecx_debug.pop(i_method_name);

Line 944: retcode := ecx_utils.i_ret_code;

940:
941: EXCEPTION
942: /* raised only by getConfirmation at this point */
943: WHEN ECX_NO_DELIVERY_REQUIRED THEN
944: retcode := ecx_utils.i_ret_code;
945: errmsg := ecx_utils.i_errbuf;
946: if(l_unexpectedEnabled) then
947: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
948: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SEND',

Line 945: errmsg := ecx_utils.i_errbuf;

941: EXCEPTION
942: /* raised only by getConfirmation at this point */
943: WHEN ECX_NO_DELIVERY_REQUIRED THEN
944: retcode := ecx_utils.i_ret_code;
945: errmsg := ecx_utils.i_errbuf;
946: if(l_unexpectedEnabled) then
947: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
948: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SEND',
949: i_method_name);

Line 947: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);

943: WHEN ECX_NO_DELIVERY_REQUIRED THEN
944: retcode := ecx_utils.i_ret_code;
945: errmsg := ecx_utils.i_errbuf;
946: if(l_unexpectedEnabled) then
947: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
948: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SEND',
949: i_method_name);
950: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
951: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,

Line 948: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SEND',

944: retcode := ecx_utils.i_ret_code;
945: errmsg := ecx_utils.i_errbuf;
946: if(l_unexpectedEnabled) then
947: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
948: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SEND',
949: i_method_name);
950: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
951: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
952: ecx_utils.i_errparams),i_method_name); --MLS

Line 952: ecx_utils.i_errparams),i_method_name); --MLS

948: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SEND',
949: i_method_name);
950: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
951: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
952: ecx_utils.i_errparams),i_method_name); --MLS
953: ecx_debug.log(l_unexpected,'errtype',ecx_utils.error_type,i_method_name);
954: end if;
955: if (l_procedureEnabled) then
956: ecx_debug.pop(i_method_name);

Line 953: ecx_debug.log(l_unexpected,'errtype',ecx_utils.error_type,i_method_name);

949: i_method_name);
950: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
951: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
952: ecx_utils.i_errparams),i_method_name); --MLS
953: ecx_debug.log(l_unexpected,'errtype',ecx_utils.error_type,i_method_name);
954: end if;
955: if (l_procedureEnabled) then
956: ecx_debug.pop(i_method_name);
957: end if;

Line 973: ecx_utils.i_ret_code,

969: party_id,
970: party_site_id,
971: p_party_type, --bug #2183619
972: document_id,
973: ecx_utils.i_ret_code,
974: ecx_utils.i_errbuf,
975: ecx_utils.i_errparams --MLS
976: );
977: WHEN ECX_UTILS.PROGRAM_EXIT THEN

Line 974: ecx_utils.i_errbuf,

970: party_site_id,
971: p_party_type, --bug #2183619
972: document_id,
973: ecx_utils.i_ret_code,
974: ecx_utils.i_errbuf,
975: ecx_utils.i_errparams --MLS
976: );
977: WHEN ECX_UTILS.PROGRAM_EXIT THEN
978: retcode := ecx_utils.i_ret_code;

Line 975: ecx_utils.i_errparams --MLS

971: p_party_type, --bug #2183619
972: document_id,
973: ecx_utils.i_ret_code,
974: ecx_utils.i_errbuf,
975: ecx_utils.i_errparams --MLS
976: );
977: WHEN ECX_UTILS.PROGRAM_EXIT THEN
978: retcode := ecx_utils.i_ret_code;
979: errmsg := ecx_utils.i_errbuf;

Line 977: WHEN ECX_UTILS.PROGRAM_EXIT THEN

973: ecx_utils.i_ret_code,
974: ecx_utils.i_errbuf,
975: ecx_utils.i_errparams --MLS
976: );
977: WHEN ECX_UTILS.PROGRAM_EXIT THEN
978: retcode := ecx_utils.i_ret_code;
979: errmsg := ecx_utils.i_errbuf;
980: if(l_unexpectedEnabled) then
981: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);

Line 978: retcode := ecx_utils.i_ret_code;

974: ecx_utils.i_errbuf,
975: ecx_utils.i_errparams --MLS
976: );
977: WHEN ECX_UTILS.PROGRAM_EXIT THEN
978: retcode := ecx_utils.i_ret_code;
979: errmsg := ecx_utils.i_errbuf;
980: if(l_unexpectedEnabled) then
981: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
982: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf ||SQLERRM||' at ECX_DOCUMENT.SEND',

Line 979: errmsg := ecx_utils.i_errbuf;

975: ecx_utils.i_errparams --MLS
976: );
977: WHEN ECX_UTILS.PROGRAM_EXIT THEN
978: retcode := ecx_utils.i_ret_code;
979: errmsg := ecx_utils.i_errbuf;
980: if(l_unexpectedEnabled) then
981: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
982: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf ||SQLERRM||' at ECX_DOCUMENT.SEND',
983: i_method_name);

Line 981: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);

977: WHEN ECX_UTILS.PROGRAM_EXIT THEN
978: retcode := ecx_utils.i_ret_code;
979: errmsg := ecx_utils.i_errbuf;
980: if(l_unexpectedEnabled) then
981: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
982: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf ||SQLERRM||' at ECX_DOCUMENT.SEND',
983: i_method_name);
984: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
985: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,

Line 982: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf ||SQLERRM||' at ECX_DOCUMENT.SEND',

978: retcode := ecx_utils.i_ret_code;
979: errmsg := ecx_utils.i_errbuf;
980: if(l_unexpectedEnabled) then
981: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
982: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf ||SQLERRM||' at ECX_DOCUMENT.SEND',
983: i_method_name);
984: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
985: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
986: ecx_utils.i_errparams),i_method_name); --MLS

Line 986: ecx_utils.i_errparams),i_method_name); --MLS

982: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf ||SQLERRM||' at ECX_DOCUMENT.SEND',
983: i_method_name);
984: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
985: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
986: ecx_utils.i_errparams),i_method_name); --MLS
987: end if;
988: if (l_procedureEnabled) then
989: ecx_debug.pop(i_method_name);
990: end if;

Line 1007: ecx_utils.i_ret_code,

1003: party_id,
1004: party_site_id,
1005: p_party_type, --bug #2183619
1006: document_id,
1007: ecx_utils.i_ret_code,
1008: ecx_utils.i_errbuf,
1009: ecx_utils.i_errparams --MLS
1010: );
1011:

Line 1008: ecx_utils.i_errbuf,

1004: party_site_id,
1005: p_party_type, --bug #2183619
1006: document_id,
1007: ecx_utils.i_ret_code,
1008: ecx_utils.i_errbuf,
1009: ecx_utils.i_errparams --MLS
1010: );
1011:
1012: WHEN OTHERS THEN

Line 1009: ecx_utils.i_errparams --MLS

1005: p_party_type, --bug #2183619
1006: document_id,
1007: ecx_utils.i_ret_code,
1008: ecx_utils.i_errbuf,
1009: ecx_utils.i_errparams --MLS
1010: );
1011:
1012: WHEN OTHERS THEN
1013: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_DOCUMENT.SEND');

Line 1014: retcode := ecx_utils.i_ret_code;

1010: );
1011:
1012: WHEN OTHERS THEN
1013: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_DOCUMENT.SEND');
1014: retcode := ecx_utils.i_ret_code;
1015: errmsg := ecx_utils.i_errbuf;
1016: if(l_unexpectedEnabled) then
1017: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1018: ecx_debug.log(l_unexpected,'i_errmsg',SQLERRM||' at ECX_DOCUMENT.SEND',i_method_name);

Line 1015: errmsg := ecx_utils.i_errbuf;

1011:
1012: WHEN OTHERS THEN
1013: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_DOCUMENT.SEND');
1014: retcode := ecx_utils.i_ret_code;
1015: errmsg := ecx_utils.i_errbuf;
1016: if(l_unexpectedEnabled) then
1017: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1018: ecx_debug.log(l_unexpected,'i_errmsg',SQLERRM||' at ECX_DOCUMENT.SEND',i_method_name);
1019: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name,i_method_name);

Line 1017: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);

1013: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_DOCUMENT.SEND');
1014: retcode := ecx_utils.i_ret_code;
1015: errmsg := ecx_utils.i_errbuf;
1016: if(l_unexpectedEnabled) then
1017: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1018: ecx_debug.log(l_unexpected,'i_errmsg',SQLERRM||' at ECX_DOCUMENT.SEND',i_method_name);
1019: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name,i_method_name);
1020: ecx_debug.log(l_unexpected,'errmsg',errmsg,i_method_name,i_method_name);
1021: end if;

Line 1040: ecx_utils.i_ret_code,

1036: party_id,
1037: party_site_id,
1038: p_party_type, --bug #2183619
1039: document_id,
1040: ecx_utils.i_ret_code,
1041: ecx_utils.i_errbuf,
1042: ecx_utils.i_errparams
1043: );
1044: end send;

Line 1041: ecx_utils.i_errbuf,

1037: party_site_id,
1038: p_party_type, --bug #2183619
1039: document_id,
1040: ecx_utils.i_ret_code,
1041: ecx_utils.i_errbuf,
1042: ecx_utils.i_errparams
1043: );
1044: end send;
1045:

Line 1042: ecx_utils.i_errparams

1038: p_party_type, --bug #2183619
1039: document_id,
1040: ecx_utils.i_ret_code,
1041: ecx_utils.i_errbuf,
1042: ecx_utils.i_errparams
1043: );
1044: end send;
1045:
1046:

Line 1141: ecx_utils.getLogDirectory;

1137:
1138: IF (ecx_logging_enabled ) THEN
1139:
1140: --- Sets the Log Directory in both Standalone and the Embedded mode
1141: ecx_utils.getLogDirectory;
1142: ecx_utils.g_logfile := 'TRIG'||transaction_type||transaction_subtype||document_id||trigger_id||'.log';
1143:
1144: p_aflog_module_name := 'trig.';
1145: IF (transaction_type is not null) THEN

Line 1142: ecx_utils.g_logfile := 'TRIG'||transaction_type||transaction_subtype||document_id||trigger_id||'.log';

1138: IF (ecx_logging_enabled ) THEN
1139:
1140: --- Sets the Log Directory in both Standalone and the Embedded mode
1141: ecx_utils.getLogDirectory;
1142: ecx_utils.g_logfile := 'TRIG'||transaction_type||transaction_subtype||document_id||trigger_id||'.log';
1143:
1144: p_aflog_module_name := 'trig.';
1145: IF (transaction_type is not null) THEN
1146: p_aflog_module_name := p_aflog_module_name||transaction_type||'.';

Line 1160: ecx_debug.enable_debug_new(debug_mode, ecx_utils.g_logdir,ecx_utils.g_logfile, p_aflog_module_name);

1156: END IF;
1157:
1158: p_aflog_module_name := p_aflog_module_name||'.log';
1159:
1160: ecx_debug.enable_debug_new(debug_mode, ecx_utils.g_logdir,ecx_utils.g_logfile, p_aflog_module_name);
1161: END IF;
1162:
1163: /* Assign local variables with the ecx_debug global variables*/
1164: l_procedure := ecx_debug.g_procedure;

Line 1186: if ecx_utils.g_event is null

1182: ecx_debug.log(l_statement,'debug_mode',debug_mode,i_method_name);
1183: end if;
1184:
1185: /** check for the Event Object. If null , initialize it **/
1186: if ecx_utils.g_event is null
1187: then
1188: wf_event_t.initialize(ecx_utils.g_event);
1189: end if;
1190: i_parameterlist := wf_event_t.getParameterList(ecx_utils.g_event);

Line 1188: wf_event_t.initialize(ecx_utils.g_event);

1184:
1185: /** check for the Event Object. If null , initialize it **/
1186: if ecx_utils.g_event is null
1187: then
1188: wf_event_t.initialize(ecx_utils.g_event);
1189: end if;
1190: i_parameterlist := wf_event_t.getParameterList(ecx_utils.g_event);
1191: if(l_statementEnabled) then
1192: if i_parameterList is not null

Line 1190: i_parameterlist := wf_event_t.getParameterList(ecx_utils.g_event);

1186: if ecx_utils.g_event is null
1187: then
1188: wf_event_t.initialize(ecx_utils.g_event);
1189: end if;
1190: i_parameterlist := wf_event_t.getParameterList(ecx_utils.g_event);
1191: if(l_statementEnabled) then
1192: if i_parameterList is not null
1193: then
1194: for i in i_parameterList.FIRST..i_parameterList.LAST

Line 1203: Initialize the ecx_utils.i_ret_code and i_errbuf variables;

1199: end if;
1200: end if;
1201:
1202: /**
1203: Initialize the ecx_utils.i_ret_code and i_errbuf variables;
1204: **/
1205: ecx_utils.i_ret_code :=0;
1206: ecx_utils.i_errbuf := null;
1207: --MLS

Line 1205: ecx_utils.i_ret_code :=0;

1201:
1202: /**
1203: Initialize the ecx_utils.i_ret_code and i_errbuf variables;
1204: **/
1205: ecx_utils.i_ret_code :=0;
1206: ecx_utils.i_errbuf := null;
1207: --MLS
1208: ecx_utils.i_errparams := null;
1209:

Line 1206: ecx_utils.i_errbuf := null;

1202: /**
1203: Initialize the ecx_utils.i_ret_code and i_errbuf variables;
1204: **/
1205: ecx_utils.i_ret_code :=0;
1206: ecx_utils.i_errbuf := null;
1207: --MLS
1208: ecx_utils.i_errparams := null;
1209:
1210: -- make a new procedure which will invoke outbound_trigger, getConfirmation and

Line 1208: ecx_utils.i_errparams := null;

1204: **/
1205: ecx_utils.i_ret_code :=0;
1206: ecx_utils.i_errbuf := null;
1207: --MLS
1208: ecx_utils.i_errparams := null;
1209:
1210: -- make a new procedure which will invoke outbound_trigger, getConfirmation and
1211: -- get_delivery_attribs
1212: ecx_debug.setErrorInfo(10,10,'ECX_TRIGGER_OUTBOUND');

Line 1215: document_id, ecx_utils.i_ret_code,

1211: -- get_delivery_attribs
1212: ecx_debug.setErrorInfo(10,10,'ECX_TRIGGER_OUTBOUND');
1213: trigger_outbound (transaction_type, transaction_subtype,
1214: party_id, party_site_id,
1215: document_id, ecx_utils.i_ret_code,
1216: ecx_utils.i_errbuf, trigger_id,
1217: p_party_type, p_party_id, p_party_site_id, p_message_type,
1218: p_message_standard, p_ext_type, p_ext_subtype, p_source_code,
1219: p_destination_code, p_destination_type, p_destination_address,

Line 1216: ecx_utils.i_errbuf, trigger_id,

1212: ecx_debug.setErrorInfo(10,10,'ECX_TRIGGER_OUTBOUND');
1213: trigger_outbound (transaction_type, transaction_subtype,
1214: party_id, party_site_id,
1215: document_id, ecx_utils.i_ret_code,
1216: ecx_utils.i_errbuf, trigger_id,
1217: p_party_type, p_party_id, p_party_site_id, p_message_type,
1218: p_message_standard, p_ext_type, p_ext_subtype, p_source_code,
1219: p_destination_code, p_destination_type, p_destination_address,
1220: p_username, p_password, p_map_code,

Line 1221: p_queue_name, ecx_utils.g_rec_tp_id);

1217: p_party_type, p_party_id, p_party_site_id, p_message_type,
1218: p_message_standard, p_ext_type, p_ext_subtype, p_source_code,
1219: p_destination_code, p_destination_type, p_destination_address,
1220: p_username, p_password, p_map_code,
1221: p_queue_name, ecx_utils.g_rec_tp_id);
1222:
1223: -- take appropriate action for destination_type
1224: If p_destination_type = 'NONE' Then
1225: /** No email Action required **/

Line 1256: ecx_utils.g_company_name,

1252: p_destination_type,
1253: p_destination_address,
1254: p_username,
1255: p_password,
1256: ecx_utils.g_company_name,
1257: null,
1258: p_destination_code,
1259: null,
1260: null,

Line 1267: retcode := ecx_utils.i_ret_code;

1263: i_msgid
1264: );
1265:
1266: --- Assign the values back to the program OUT variables.
1267: retcode := ecx_utils.i_ret_code;
1268: errmsg := ecx_utils.i_errbuf;
1269:
1270: if(l_unexpectedEnabled) then
1271: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);

Line 1268: errmsg := ecx_utils.i_errbuf;

1264: );
1265:
1266: --- Assign the values back to the program OUT variables.
1267: retcode := ecx_utils.i_ret_code;
1268: errmsg := ecx_utils.i_errbuf;
1269:
1270: if(l_unexpectedEnabled) then
1271: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1272: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,

Line 1273: ecx_utils.i_errparams),i_method_name); --MLS

1269:
1270: if(l_unexpectedEnabled) then
1271: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1272: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
1273: ecx_utils.i_errparams),i_method_name); --MLS
1274: end if;
1275: if(l_statementEnabled) then
1276: ecx_debug.log(l_statement,'i_msgid',i_msgid,i_method_name);
1277: end if;

Line 1292: retcode := ecx_utils.i_ret_code;

1288:
1289: EXCEPTION
1290: /* raised only by getConfirmation at this point */
1291: WHEN ECX_NO_DELIVERY_REQUIRED THEN
1292: retcode := ecx_utils.i_ret_code;
1293: errmsg := ecx_utils.i_errbuf;
1294: if(l_unexpectedEnabled) then
1295: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1296: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',

Line 1293: errmsg := ecx_utils.i_errbuf;

1289: EXCEPTION
1290: /* raised only by getConfirmation at this point */
1291: WHEN ECX_NO_DELIVERY_REQUIRED THEN
1292: retcode := ecx_utils.i_ret_code;
1293: errmsg := ecx_utils.i_errbuf;
1294: if(l_unexpectedEnabled) then
1295: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1296: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',
1297: i_method_name);

Line 1295: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);

1291: WHEN ECX_NO_DELIVERY_REQUIRED THEN
1292: retcode := ecx_utils.i_ret_code;
1293: errmsg := ecx_utils.i_errbuf;
1294: if(l_unexpectedEnabled) then
1295: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1296: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',
1297: i_method_name);
1298: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1299: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,

Line 1296: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',

1292: retcode := ecx_utils.i_ret_code;
1293: errmsg := ecx_utils.i_errbuf;
1294: if(l_unexpectedEnabled) then
1295: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1296: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',
1297: i_method_name);
1298: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1299: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
1300: ecx_utils.i_errparams),i_method_name); --MLS

Line 1300: ecx_utils.i_errparams),i_method_name); --MLS

1296: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',
1297: i_method_name);
1298: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1299: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
1300: ecx_utils.i_errparams),i_method_name); --MLS
1301: ecx_debug.log(l_unexpected,'errtype',ecx_utils.error_type,i_method_name);
1302: end if;
1303: if (l_procedureEnabled) then
1304: ecx_debug.pop(i_method_name);

Line 1301: ecx_debug.log(l_unexpected,'errtype',ecx_utils.error_type,i_method_name);

1297: i_method_name);
1298: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1299: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
1300: ecx_utils.i_errparams),i_method_name); --MLS
1301: ecx_debug.log(l_unexpected,'errtype',ecx_utils.error_type,i_method_name);
1302: end if;
1303: if (l_procedureEnabled) then
1304: ecx_debug.pop(i_method_name);
1305: end if;

Line 1321: ecx_utils.i_ret_code,

1317: party_id,
1318: party_site_id,
1319: p_party_type, --bug #2183619
1320: document_id,
1321: ecx_utils.i_ret_code,
1322: ecx_utils.i_errbuf,
1323: ecx_utils.i_errparams --MLS
1324: );
1325: WHEN ECX_TRANSACTION_NOT_DEFINED THEN

Line 1322: ecx_utils.i_errbuf,

1318: party_site_id,
1319: p_party_type, --bug #2183619
1320: document_id,
1321: ecx_utils.i_ret_code,
1322: ecx_utils.i_errbuf,
1323: ecx_utils.i_errparams --MLS
1324: );
1325: WHEN ECX_TRANSACTION_NOT_DEFINED THEN
1326: retcode := ecx_utils.i_ret_code;

Line 1323: ecx_utils.i_errparams --MLS

1319: p_party_type, --bug #2183619
1320: document_id,
1321: ecx_utils.i_ret_code,
1322: ecx_utils.i_errbuf,
1323: ecx_utils.i_errparams --MLS
1324: );
1325: WHEN ECX_TRANSACTION_NOT_DEFINED THEN
1326: retcode := ecx_utils.i_ret_code;
1327: errmsg := ecx_utils.i_errbuf;

Line 1326: retcode := ecx_utils.i_ret_code;

1322: ecx_utils.i_errbuf,
1323: ecx_utils.i_errparams --MLS
1324: );
1325: WHEN ECX_TRANSACTION_NOT_DEFINED THEN
1326: retcode := ecx_utils.i_ret_code;
1327: errmsg := ecx_utils.i_errbuf;
1328: if(l_unexpectedEnabled) then
1329: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1330: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',

Line 1327: errmsg := ecx_utils.i_errbuf;

1323: ecx_utils.i_errparams --MLS
1324: );
1325: WHEN ECX_TRANSACTION_NOT_DEFINED THEN
1326: retcode := ecx_utils.i_ret_code;
1327: errmsg := ecx_utils.i_errbuf;
1328: if(l_unexpectedEnabled) then
1329: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1330: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',
1331: i_method_name);

Line 1329: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);

1325: WHEN ECX_TRANSACTION_NOT_DEFINED THEN
1326: retcode := ecx_utils.i_ret_code;
1327: errmsg := ecx_utils.i_errbuf;
1328: if(l_unexpectedEnabled) then
1329: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1330: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',
1331: i_method_name);
1332: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1333: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,

Line 1330: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',

1326: retcode := ecx_utils.i_ret_code;
1327: errmsg := ecx_utils.i_errbuf;
1328: if(l_unexpectedEnabled) then
1329: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1330: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',
1331: i_method_name);
1332: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1333: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
1334: ecx_utils.i_errparams),i_method_name); --MLS

Line 1334: ecx_utils.i_errparams),i_method_name); --MLS

1330: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',
1331: i_method_name);
1332: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1333: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
1334: ecx_utils.i_errparams),i_method_name); --MLS
1335: ecx_debug.log(l_unexpected,'errtype',ecx_utils.error_type,i_method_name);
1336: end if;
1337: if (l_procedureEnabled) then
1338: ecx_debug.pop(i_method_name);

Line 1335: ecx_debug.log(l_unexpected,'errtype',ecx_utils.error_type,i_method_name);

1331: i_method_name);
1332: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1333: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
1334: ecx_utils.i_errparams),i_method_name); --MLS
1335: ecx_debug.log(l_unexpected,'errtype',ecx_utils.error_type,i_method_name);
1336: end if;
1337: if (l_procedureEnabled) then
1338: ecx_debug.pop(i_method_name);
1339: end if;

Line 1355: ecx_utils.i_ret_code,

1351: party_id,
1352: party_site_id,
1353: p_party_type, --bug #2183619
1354: document_id,
1355: ecx_utils.i_ret_code,
1356: ecx_utils.i_errbuf,
1357: ecx_utils.i_errparams --MLS
1358: );
1359:

Line 1356: ecx_utils.i_errbuf,

1352: party_site_id,
1353: p_party_type, --bug #2183619
1354: document_id,
1355: ecx_utils.i_ret_code,
1356: ecx_utils.i_errbuf,
1357: ecx_utils.i_errparams --MLS
1358: );
1359:
1360: WHEN ECX_NO_PARTY_SETUP THEN

Line 1357: ecx_utils.i_errparams --MLS

1353: p_party_type, --bug #2183619
1354: document_id,
1355: ecx_utils.i_ret_code,
1356: ecx_utils.i_errbuf,
1357: ecx_utils.i_errparams --MLS
1358: );
1359:
1360: WHEN ECX_NO_PARTY_SETUP THEN
1361: retcode := ecx_utils.i_ret_code;

Line 1361: retcode := ecx_utils.i_ret_code;

1357: ecx_utils.i_errparams --MLS
1358: );
1359:
1360: WHEN ECX_NO_PARTY_SETUP THEN
1361: retcode := ecx_utils.i_ret_code;
1362: errmsg := ecx_utils.i_errbuf;
1363:
1364: if(l_unexpectedEnabled) then
1365: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);

Line 1362: errmsg := ecx_utils.i_errbuf;

1358: );
1359:
1360: WHEN ECX_NO_PARTY_SETUP THEN
1361: retcode := ecx_utils.i_ret_code;
1362: errmsg := ecx_utils.i_errbuf;
1363:
1364: if(l_unexpectedEnabled) then
1365: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1366: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',

Line 1365: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);

1361: retcode := ecx_utils.i_ret_code;
1362: errmsg := ecx_utils.i_errbuf;
1363:
1364: if(l_unexpectedEnabled) then
1365: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1366: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',
1367: i_method_name);
1368: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1369: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,

Line 1366: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',

1362: errmsg := ecx_utils.i_errbuf;
1363:
1364: if(l_unexpectedEnabled) then
1365: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1366: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',
1367: i_method_name);
1368: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1369: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
1370: ecx_utils.i_errparams),i_method_name); --MLS

Line 1370: ecx_utils.i_errparams),i_method_name); --MLS

1366: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',
1367: i_method_name);
1368: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1369: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
1370: ecx_utils.i_errparams),i_method_name); --MLS
1371: ecx_debug.log(l_unexpected,'errtype',ecx_utils.error_type,i_method_name);
1372: end if;
1373: if (l_procedureEnabled) then
1374: ecx_debug.pop(i_method_name);

Line 1371: ecx_debug.log(l_unexpected,'errtype',ecx_utils.error_type,i_method_name);

1367: i_method_name);
1368: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1369: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
1370: ecx_utils.i_errparams),i_method_name); --MLS
1371: ecx_debug.log(l_unexpected,'errtype',ecx_utils.error_type,i_method_name);
1372: end if;
1373: if (l_procedureEnabled) then
1374: ecx_debug.pop(i_method_name);
1375: end if;

Line 1392: ecx_utils.i_ret_code,

1388: party_id,
1389: party_site_id,
1390: p_party_type, --bug #2183619
1391: document_id,
1392: ecx_utils.i_ret_code,
1393: ecx_utils.i_errbuf,
1394: ecx_utils.i_errparams --MLS
1395: );
1396:

Line 1393: ecx_utils.i_errbuf,

1389: party_site_id,
1390: p_party_type, --bug #2183619
1391: document_id,
1392: ecx_utils.i_ret_code,
1393: ecx_utils.i_errbuf,
1394: ecx_utils.i_errparams --MLS
1395: );
1396:
1397: WHEN ECX_DELIVERY_SETUP_ERROR THEN

Line 1394: ecx_utils.i_errparams --MLS

1390: p_party_type, --bug #2183619
1391: document_id,
1392: ecx_utils.i_ret_code,
1393: ecx_utils.i_errbuf,
1394: ecx_utils.i_errparams --MLS
1395: );
1396:
1397: WHEN ECX_DELIVERY_SETUP_ERROR THEN
1398: retcode := ecx_utils.i_ret_code;

Line 1398: retcode := ecx_utils.i_ret_code;

1394: ecx_utils.i_errparams --MLS
1395: );
1396:
1397: WHEN ECX_DELIVERY_SETUP_ERROR THEN
1398: retcode := ecx_utils.i_ret_code;
1399: errmsg := ecx_utils.i_errbuf;
1400:
1401: if(l_unexpectedEnabled) then
1402: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);

Line 1399: errmsg := ecx_utils.i_errbuf;

1395: );
1396:
1397: WHEN ECX_DELIVERY_SETUP_ERROR THEN
1398: retcode := ecx_utils.i_ret_code;
1399: errmsg := ecx_utils.i_errbuf;
1400:
1401: if(l_unexpectedEnabled) then
1402: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1403: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',

Line 1402: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);

1398: retcode := ecx_utils.i_ret_code;
1399: errmsg := ecx_utils.i_errbuf;
1400:
1401: if(l_unexpectedEnabled) then
1402: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1403: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',
1404: i_method_name);
1405: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1406: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,

Line 1403: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',

1399: errmsg := ecx_utils.i_errbuf;
1400:
1401: if(l_unexpectedEnabled) then
1402: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1403: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',
1404: i_method_name);
1405: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1406: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
1407: ecx_utils.i_errparams),i_method_name); --MLS

Line 1407: ecx_utils.i_errparams),i_method_name); --MLS

1403: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',
1404: i_method_name);
1405: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1406: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
1407: ecx_utils.i_errparams),i_method_name); --MLS
1408: ecx_debug.log(l_unexpected,'errtype',ecx_utils.error_type,i_method_name);
1409: end if;
1410: if (l_procedureEnabled) then
1411: ecx_debug.pop(i_method_name);

Line 1408: ecx_debug.log(l_unexpected,'errtype',ecx_utils.error_type,i_method_name);

1404: i_method_name);
1405: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1406: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
1407: ecx_utils.i_errparams),i_method_name); --MLS
1408: ecx_debug.log(l_unexpected,'errtype',ecx_utils.error_type,i_method_name);
1409: end if;
1410: if (l_procedureEnabled) then
1411: ecx_debug.pop(i_method_name);
1412: end if;

Line 1428: ecx_utils.i_ret_code,

1424: party_id,
1425: party_site_id,
1426: p_party_type, --bug #2183619
1427: document_id,
1428: ecx_utils.i_ret_code,
1429: ecx_utils.i_errbuf,
1430: ecx_utils.i_errparams --MLS
1431: );
1432: WHEN ECX_UTILS.PROGRAM_EXIT THEN

Line 1429: ecx_utils.i_errbuf,

1425: party_site_id,
1426: p_party_type, --bug #2183619
1427: document_id,
1428: ecx_utils.i_ret_code,
1429: ecx_utils.i_errbuf,
1430: ecx_utils.i_errparams --MLS
1431: );
1432: WHEN ECX_UTILS.PROGRAM_EXIT THEN
1433: retcode := ecx_utils.i_ret_code;

Line 1430: ecx_utils.i_errparams --MLS

1426: p_party_type, --bug #2183619
1427: document_id,
1428: ecx_utils.i_ret_code,
1429: ecx_utils.i_errbuf,
1430: ecx_utils.i_errparams --MLS
1431: );
1432: WHEN ECX_UTILS.PROGRAM_EXIT THEN
1433: retcode := ecx_utils.i_ret_code;
1434: errmsg := ecx_utils.i_errbuf;

Line 1432: WHEN ECX_UTILS.PROGRAM_EXIT THEN

1428: ecx_utils.i_ret_code,
1429: ecx_utils.i_errbuf,
1430: ecx_utils.i_errparams --MLS
1431: );
1432: WHEN ECX_UTILS.PROGRAM_EXIT THEN
1433: retcode := ecx_utils.i_ret_code;
1434: errmsg := ecx_utils.i_errbuf;
1435:
1436: if(l_unexpectedEnabled) then

Line 1433: retcode := ecx_utils.i_ret_code;

1429: ecx_utils.i_errbuf,
1430: ecx_utils.i_errparams --MLS
1431: );
1432: WHEN ECX_UTILS.PROGRAM_EXIT THEN
1433: retcode := ecx_utils.i_ret_code;
1434: errmsg := ecx_utils.i_errbuf;
1435:
1436: if(l_unexpectedEnabled) then
1437: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);

Line 1434: errmsg := ecx_utils.i_errbuf;

1430: ecx_utils.i_errparams --MLS
1431: );
1432: WHEN ECX_UTILS.PROGRAM_EXIT THEN
1433: retcode := ecx_utils.i_ret_code;
1434: errmsg := ecx_utils.i_errbuf;
1435:
1436: if(l_unexpectedEnabled) then
1437: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1438: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',

Line 1437: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);

1433: retcode := ecx_utils.i_ret_code;
1434: errmsg := ecx_utils.i_errbuf;
1435:
1436: if(l_unexpectedEnabled) then
1437: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1438: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',
1439: i_method_name);
1440: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1441: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,

Line 1438: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',

1434: errmsg := ecx_utils.i_errbuf;
1435:
1436: if(l_unexpectedEnabled) then
1437: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1438: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',
1439: i_method_name);
1440: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1441: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
1442: ecx_utils.i_errparams),i_method_name); --MLS

Line 1442: ecx_utils.i_errparams),i_method_name); --MLS

1438: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',
1439: i_method_name);
1440: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1441: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
1442: ecx_utils.i_errparams),i_method_name); --MLS
1443: ecx_debug.log(l_unexpected,'errtype',ecx_utils.error_type,i_method_name);
1444: end if;
1445: if (l_procedureEnabled) then
1446: ecx_debug.pop(i_method_name);

Line 1443: ecx_debug.log(l_unexpected,'errtype',ecx_utils.error_type,i_method_name);

1439: i_method_name);
1440: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1441: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
1442: ecx_utils.i_errparams),i_method_name); --MLS
1443: ecx_debug.log(l_unexpected,'errtype',ecx_utils.error_type,i_method_name);
1444: end if;
1445: if (l_procedureEnabled) then
1446: ecx_debug.pop(i_method_name);
1447: end if;

Line 1463: ecx_utils.i_ret_code,

1459: party_id,
1460: party_site_id,
1461: p_party_type, --bug #2183619
1462: document_id,
1463: ecx_utils.i_ret_code,
1464: ecx_utils.i_errbuf,
1465: ecx_utils.i_errparams --MLS
1466: );
1467: WHEN OTHERS THEN

Line 1464: ecx_utils.i_errbuf,

1460: party_site_id,
1461: p_party_type, --bug #2183619
1462: document_id,
1463: ecx_utils.i_ret_code,
1464: ecx_utils.i_errbuf,
1465: ecx_utils.i_errparams --MLS
1466: );
1467: WHEN OTHERS THEN
1468: ecx_debug.setErrorInfo(2,30, SQLERRM||' - ECX_DOCUMENT.SENDDIRECT');

Line 1465: ecx_utils.i_errparams --MLS

1461: p_party_type, --bug #2183619
1462: document_id,
1463: ecx_utils.i_ret_code,
1464: ecx_utils.i_errbuf,
1465: ecx_utils.i_errparams --MLS
1466: );
1467: WHEN OTHERS THEN
1468: ecx_debug.setErrorInfo(2,30, SQLERRM||' - ECX_DOCUMENT.SENDDIRECT');
1469: retcode := ecx_utils.i_ret_code;

Line 1469: retcode := ecx_utils.i_ret_code;

1465: ecx_utils.i_errparams --MLS
1466: );
1467: WHEN OTHERS THEN
1468: ecx_debug.setErrorInfo(2,30, SQLERRM||' - ECX_DOCUMENT.SENDDIRECT');
1469: retcode := ecx_utils.i_ret_code;
1470: errmsg := ecx_utils.i_errbuf;
1471: if(l_unexpectedEnabled) then
1472: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1473: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',

Line 1470: errmsg := ecx_utils.i_errbuf;

1466: );
1467: WHEN OTHERS THEN
1468: ecx_debug.setErrorInfo(2,30, SQLERRM||' - ECX_DOCUMENT.SENDDIRECT');
1469: retcode := ecx_utils.i_ret_code;
1470: errmsg := ecx_utils.i_errbuf;
1471: if(l_unexpectedEnabled) then
1472: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1473: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',
1474: i_method_name);

Line 1472: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);

1468: ecx_debug.setErrorInfo(2,30, SQLERRM||' - ECX_DOCUMENT.SENDDIRECT');
1469: retcode := ecx_utils.i_ret_code;
1470: errmsg := ecx_utils.i_errbuf;
1471: if(l_unexpectedEnabled) then
1472: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1473: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',
1474: i_method_name);
1475: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1476: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,

Line 1473: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',

1469: retcode := ecx_utils.i_ret_code;
1470: errmsg := ecx_utils.i_errbuf;
1471: if(l_unexpectedEnabled) then
1472: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1473: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',
1474: i_method_name);
1475: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1476: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
1477: ecx_utils.i_errparams),i_method_name); --MLS

Line 1477: ecx_utils.i_errparams),i_method_name); --MLS

1473: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',
1474: i_method_name);
1475: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1476: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
1477: ecx_utils.i_errparams),i_method_name); --MLS
1478: ecx_debug.log(l_unexpected,'errtype',ecx_utils.error_type,i_method_name);
1479: end if;
1480: if (l_procedureEnabled) then
1481: ecx_debug.pop(i_method_name);

Line 1478: ecx_debug.log(l_unexpected,'errtype',ecx_utils.error_type,i_method_name);

1474: i_method_name);
1475: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1476: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
1477: ecx_utils.i_errparams),i_method_name); --MLS
1478: ecx_debug.log(l_unexpected,'errtype',ecx_utils.error_type,i_method_name);
1479: end if;
1480: if (l_procedureEnabled) then
1481: ecx_debug.pop(i_method_name);
1482: end if;

Line 1498: ecx_utils.i_ret_code,

1494: party_id,
1495: party_site_id,
1496: p_party_type, --bug #2183619
1497: document_id,
1498: ecx_utils.i_ret_code,
1499: ecx_utils.i_errbuf,
1500: ecx_utils.i_errparams --MLS
1501: );
1502: end senddirect;

Line 1499: ecx_utils.i_errbuf,

1495: party_site_id,
1496: p_party_type, --bug #2183619
1497: document_id,
1498: ecx_utils.i_ret_code,
1499: ecx_utils.i_errbuf,
1500: ecx_utils.i_errparams --MLS
1501: );
1502: end senddirect;
1503:

Line 1500: ecx_utils.i_errparams --MLS

1496: p_party_type, --bug #2183619
1497: document_id,
1498: ecx_utils.i_ret_code,
1499: ecx_utils.i_errbuf,
1500: ecx_utils.i_errparams --MLS
1501: );
1502: end senddirect;
1503:
1504: procedure isDeliveryRequired

Line 1552: ecx_utils.g_rec_tp_id

1548: p_username,
1549: p_password,
1550: p_map_code,
1551: p_queue_name,
1552: ecx_utils.g_rec_tp_id
1553: );
1554: -- take appropriate action for destination_type
1555: If p_destination_type = 'NONE' Then
1556: /** No email Action required **/

Line 1583: when ecx_utils.program_exit then

1579: resultout := FALSE;
1580: when ecx_delivery_setup_error then
1581: resultout := FALSE;
1582: raise;
1583: when ecx_utils.program_exit then
1584: resultout := FALSE;
1585: raise;
1586: when others then
1587: resultout := FALSE;

Line 1588: raise ecx_utils.program_exit;

1584: resultout := FALSE;
1585: raise;
1586: when others then
1587: resultout := FALSE;
1588: raise ecx_utils.program_exit;
1589: end;
1590: -- Changed for MLS
1591: ecx_debug.setErrorInfo(0,10,'ECX_SUCCESSFUL_TP_LKP');
1592: errmsg:=ecx_utils.i_errbuf;

Line 1592: errmsg:=ecx_utils.i_errbuf;

1588: raise ecx_utils.program_exit;
1589: end;
1590: -- Changed for MLS
1591: ecx_debug.setErrorInfo(0,10,'ECX_SUCCESSFUL_TP_LKP');
1592: errmsg:=ecx_utils.i_errbuf;
1593: retcode :=ecx_utils.i_ret_code;
1594:
1595: exception
1596: when ecx_transaction_not_defined then

Line 1593: retcode :=ecx_utils.i_ret_code;

1589: end;
1590: -- Changed for MLS
1591: ecx_debug.setErrorInfo(0,10,'ECX_SUCCESSFUL_TP_LKP');
1592: errmsg:=ecx_utils.i_errbuf;
1593: retcode :=ecx_utils.i_ret_code;
1594:
1595: exception
1596: when ecx_transaction_not_defined then
1597: retcode := ecx_utils.i_ret_code;

Line 1597: retcode := ecx_utils.i_ret_code;

1593: retcode :=ecx_utils.i_ret_code;
1594:
1595: exception
1596: when ecx_transaction_not_defined then
1597: retcode := ecx_utils.i_ret_code;
1598: errmsg := ecx_utils.i_errbuf;
1599: raise;
1600: when ecx_delivery_setup_error then
1601: retcode := ecx_utils.i_ret_code;

Line 1598: errmsg := ecx_utils.i_errbuf;

1594:
1595: exception
1596: when ecx_transaction_not_defined then
1597: retcode := ecx_utils.i_ret_code;
1598: errmsg := ecx_utils.i_errbuf;
1599: raise;
1600: when ecx_delivery_setup_error then
1601: retcode := ecx_utils.i_ret_code;
1602: errmsg := ecx_utils.i_errbuf;

Line 1601: retcode := ecx_utils.i_ret_code;

1597: retcode := ecx_utils.i_ret_code;
1598: errmsg := ecx_utils.i_errbuf;
1599: raise;
1600: when ecx_delivery_setup_error then
1601: retcode := ecx_utils.i_ret_code;
1602: errmsg := ecx_utils.i_errbuf;
1603: raise;
1604: when ecx_utils.program_exit then
1605: retcode := ecx_utils.i_ret_code;

Line 1602: errmsg := ecx_utils.i_errbuf;

1598: errmsg := ecx_utils.i_errbuf;
1599: raise;
1600: when ecx_delivery_setup_error then
1601: retcode := ecx_utils.i_ret_code;
1602: errmsg := ecx_utils.i_errbuf;
1603: raise;
1604: when ecx_utils.program_exit then
1605: retcode := ecx_utils.i_ret_code;
1606: errmsg := ecx_utils.i_errbuf;

Line 1604: when ecx_utils.program_exit then

1600: when ecx_delivery_setup_error then
1601: retcode := ecx_utils.i_ret_code;
1602: errmsg := ecx_utils.i_errbuf;
1603: raise;
1604: when ecx_utils.program_exit then
1605: retcode := ecx_utils.i_ret_code;
1606: errmsg := ecx_utils.i_errbuf;
1607: raise ecx_utils.program_exit;
1608: when others then

Line 1605: retcode := ecx_utils.i_ret_code;

1601: retcode := ecx_utils.i_ret_code;
1602: errmsg := ecx_utils.i_errbuf;
1603: raise;
1604: when ecx_utils.program_exit then
1605: retcode := ecx_utils.i_ret_code;
1606: errmsg := ecx_utils.i_errbuf;
1607: raise ecx_utils.program_exit;
1608: when others then
1609: retcode := 2;

Line 1606: errmsg := ecx_utils.i_errbuf;

1602: errmsg := ecx_utils.i_errbuf;
1603: raise;
1604: when ecx_utils.program_exit then
1605: retcode := ecx_utils.i_ret_code;
1606: errmsg := ecx_utils.i_errbuf;
1607: raise ecx_utils.program_exit;
1608: when others then
1609: retcode := 2;
1610: errmsg := SQLERRM;

Line 1607: raise ecx_utils.program_exit;

1603: raise;
1604: when ecx_utils.program_exit then
1605: retcode := ecx_utils.i_ret_code;
1606: errmsg := ecx_utils.i_errbuf;
1607: raise ecx_utils.program_exit;
1608: when others then
1609: retcode := 2;
1610: errmsg := SQLERRM;
1611: raise;

Line 1660: ecx_utils.g_rec_tp_id

1656: p_username,
1657: p_password,
1658: p_map_code,
1659: p_queue_name,
1660: ecx_utils.g_rec_tp_id
1661: );
1662:
1663: -- take appropriate action for destination_type
1664: If p_destination_type = 'NONE' Then

Line 1680: retcode:=ecx_utils.i_ret_code;

1676: end if;
1677:
1678: --Changed for MLS
1679: ecx_debug.setErrorInfo(0,10,'ECX_SUCCESSFUL_TP_LKP');
1680: retcode:=ecx_utils.i_ret_code;
1681: errmsg:=ecx_utils.i_errbuf;
1682: exception
1683: when ecx_no_party_setup then
1684: retcode := ecx_utils.i_ret_code;

Line 1681: errmsg:=ecx_utils.i_errbuf;

1677:
1678: --Changed for MLS
1679: ecx_debug.setErrorInfo(0,10,'ECX_SUCCESSFUL_TP_LKP');
1680: retcode:=ecx_utils.i_ret_code;
1681: errmsg:=ecx_utils.i_errbuf;
1682: exception
1683: when ecx_no_party_setup then
1684: retcode := ecx_utils.i_ret_code;
1685: errmsg := ecx_utils.i_errbuf;

Line 1684: retcode := ecx_utils.i_ret_code;

1680: retcode:=ecx_utils.i_ret_code;
1681: errmsg:=ecx_utils.i_errbuf;
1682: exception
1683: when ecx_no_party_setup then
1684: retcode := ecx_utils.i_ret_code;
1685: errmsg := ecx_utils.i_errbuf;
1686: when ecx_no_delivery_required then
1687: retcode := ecx_utils.i_ret_code;
1688: errmsg := ecx_utils.i_errbuf;

Line 1685: errmsg := ecx_utils.i_errbuf;

1681: errmsg:=ecx_utils.i_errbuf;
1682: exception
1683: when ecx_no_party_setup then
1684: retcode := ecx_utils.i_ret_code;
1685: errmsg := ecx_utils.i_errbuf;
1686: when ecx_no_delivery_required then
1687: retcode := ecx_utils.i_ret_code;
1688: errmsg := ecx_utils.i_errbuf;
1689: when ecx_delivery_setup_error then

Line 1687: retcode := ecx_utils.i_ret_code;

1683: when ecx_no_party_setup then
1684: retcode := ecx_utils.i_ret_code;
1685: errmsg := ecx_utils.i_errbuf;
1686: when ecx_no_delivery_required then
1687: retcode := ecx_utils.i_ret_code;
1688: errmsg := ecx_utils.i_errbuf;
1689: when ecx_delivery_setup_error then
1690: retcode := ecx_utils.i_ret_code;
1691: errmsg := ecx_utils.i_errbuf;

Line 1688: errmsg := ecx_utils.i_errbuf;

1684: retcode := ecx_utils.i_ret_code;
1685: errmsg := ecx_utils.i_errbuf;
1686: when ecx_no_delivery_required then
1687: retcode := ecx_utils.i_ret_code;
1688: errmsg := ecx_utils.i_errbuf;
1689: when ecx_delivery_setup_error then
1690: retcode := ecx_utils.i_ret_code;
1691: errmsg := ecx_utils.i_errbuf;
1692: when ecx_utils.program_exit then

Line 1690: retcode := ecx_utils.i_ret_code;

1686: when ecx_no_delivery_required then
1687: retcode := ecx_utils.i_ret_code;
1688: errmsg := ecx_utils.i_errbuf;
1689: when ecx_delivery_setup_error then
1690: retcode := ecx_utils.i_ret_code;
1691: errmsg := ecx_utils.i_errbuf;
1692: when ecx_utils.program_exit then
1693: retcode := ecx_utils.i_ret_code;
1694: errmsg := ecx_utils.i_errbuf;

Line 1691: errmsg := ecx_utils.i_errbuf;

1687: retcode := ecx_utils.i_ret_code;
1688: errmsg := ecx_utils.i_errbuf;
1689: when ecx_delivery_setup_error then
1690: retcode := ecx_utils.i_ret_code;
1691: errmsg := ecx_utils.i_errbuf;
1692: when ecx_utils.program_exit then
1693: retcode := ecx_utils.i_ret_code;
1694: errmsg := ecx_utils.i_errbuf;
1695: when others then

Line 1692: when ecx_utils.program_exit then

1688: errmsg := ecx_utils.i_errbuf;
1689: when ecx_delivery_setup_error then
1690: retcode := ecx_utils.i_ret_code;
1691: errmsg := ecx_utils.i_errbuf;
1692: when ecx_utils.program_exit then
1693: retcode := ecx_utils.i_ret_code;
1694: errmsg := ecx_utils.i_errbuf;
1695: when others then
1696: retcode := 2;

Line 1693: retcode := ecx_utils.i_ret_code;

1689: when ecx_delivery_setup_error then
1690: retcode := ecx_utils.i_ret_code;
1691: errmsg := ecx_utils.i_errbuf;
1692: when ecx_utils.program_exit then
1693: retcode := ecx_utils.i_ret_code;
1694: errmsg := ecx_utils.i_errbuf;
1695: when others then
1696: retcode := 2;
1697: errmsg := SQLERRM;

Line 1694: errmsg := ecx_utils.i_errbuf;

1690: retcode := ecx_utils.i_ret_code;
1691: errmsg := ecx_utils.i_errbuf;
1692: when ecx_utils.program_exit then
1693: retcode := ecx_utils.i_ret_code;
1694: errmsg := ecx_utils.i_errbuf;
1695: when others then
1696: retcode := 2;
1697: errmsg := SQLERRM;
1698: end getExtPartyInfo;

Line 1748: retcode:=ecx_utils.i_ret_code;

1744: tp_header_id
1745: );
1746: --Changed for MLS
1747: ecx_debug.setErrorInfo(0,10,'ECX_SUCCESSFUL_TP_LKP');
1748: retcode:=ecx_utils.i_ret_code;
1749: retmsg:=ecx_utils.i_errbuf;
1750: exception
1751: when ecx_no_party_setup then
1752: retcode := ecx_utils.i_ret_code;

Line 1749: retmsg:=ecx_utils.i_errbuf;

1745: );
1746: --Changed for MLS
1747: ecx_debug.setErrorInfo(0,10,'ECX_SUCCESSFUL_TP_LKP');
1748: retcode:=ecx_utils.i_ret_code;
1749: retmsg:=ecx_utils.i_errbuf;
1750: exception
1751: when ecx_no_party_setup then
1752: retcode := ecx_utils.i_ret_code;
1753: retmsg := ecx_utils.i_errbuf;

Line 1752: retcode := ecx_utils.i_ret_code;

1748: retcode:=ecx_utils.i_ret_code;
1749: retmsg:=ecx_utils.i_errbuf;
1750: exception
1751: when ecx_no_party_setup then
1752: retcode := ecx_utils.i_ret_code;
1753: retmsg := ecx_utils.i_errbuf;
1754: when ecx_no_delivery_required then
1755: retcode := ecx_utils.i_ret_code;
1756: retmsg := ecx_utils.i_errbuf;

Line 1753: retmsg := ecx_utils.i_errbuf;

1749: retmsg:=ecx_utils.i_errbuf;
1750: exception
1751: when ecx_no_party_setup then
1752: retcode := ecx_utils.i_ret_code;
1753: retmsg := ecx_utils.i_errbuf;
1754: when ecx_no_delivery_required then
1755: retcode := ecx_utils.i_ret_code;
1756: retmsg := ecx_utils.i_errbuf;
1757: when ecx_delivery_setup_error then

Line 1755: retcode := ecx_utils.i_ret_code;

1751: when ecx_no_party_setup then
1752: retcode := ecx_utils.i_ret_code;
1753: retmsg := ecx_utils.i_errbuf;
1754: when ecx_no_delivery_required then
1755: retcode := ecx_utils.i_ret_code;
1756: retmsg := ecx_utils.i_errbuf;
1757: when ecx_delivery_setup_error then
1758: retcode := ecx_utils.i_ret_code;
1759: retmsg := ecx_utils.i_errbuf;

Line 1756: retmsg := ecx_utils.i_errbuf;

1752: retcode := ecx_utils.i_ret_code;
1753: retmsg := ecx_utils.i_errbuf;
1754: when ecx_no_delivery_required then
1755: retcode := ecx_utils.i_ret_code;
1756: retmsg := ecx_utils.i_errbuf;
1757: when ecx_delivery_setup_error then
1758: retcode := ecx_utils.i_ret_code;
1759: retmsg := ecx_utils.i_errbuf;
1760: when ecx_utils.program_exit then

Line 1758: retcode := ecx_utils.i_ret_code;

1754: when ecx_no_delivery_required then
1755: retcode := ecx_utils.i_ret_code;
1756: retmsg := ecx_utils.i_errbuf;
1757: when ecx_delivery_setup_error then
1758: retcode := ecx_utils.i_ret_code;
1759: retmsg := ecx_utils.i_errbuf;
1760: when ecx_utils.program_exit then
1761: retcode := ecx_utils.i_ret_code;
1762: retmsg := ecx_utils.i_errbuf;

Line 1759: retmsg := ecx_utils.i_errbuf;

1755: retcode := ecx_utils.i_ret_code;
1756: retmsg := ecx_utils.i_errbuf;
1757: when ecx_delivery_setup_error then
1758: retcode := ecx_utils.i_ret_code;
1759: retmsg := ecx_utils.i_errbuf;
1760: when ecx_utils.program_exit then
1761: retcode := ecx_utils.i_ret_code;
1762: retmsg := ecx_utils.i_errbuf;
1763: when others then

Line 1760: when ecx_utils.program_exit then

1756: retmsg := ecx_utils.i_errbuf;
1757: when ecx_delivery_setup_error then
1758: retcode := ecx_utils.i_ret_code;
1759: retmsg := ecx_utils.i_errbuf;
1760: when ecx_utils.program_exit then
1761: retcode := ecx_utils.i_ret_code;
1762: retmsg := ecx_utils.i_errbuf;
1763: when others then
1764: retcode := 2;

Line 1761: retcode := ecx_utils.i_ret_code;

1757: when ecx_delivery_setup_error then
1758: retcode := ecx_utils.i_ret_code;
1759: retmsg := ecx_utils.i_errbuf;
1760: when ecx_utils.program_exit then
1761: retcode := ecx_utils.i_ret_code;
1762: retmsg := ecx_utils.i_errbuf;
1763: when others then
1764: retcode := 2;
1765: retmsg := SQLERRM;

Line 1762: retmsg := ecx_utils.i_errbuf;

1758: retcode := ecx_utils.i_ret_code;
1759: retmsg := ecx_utils.i_errbuf;
1760: when ecx_utils.program_exit then
1761: retcode := ecx_utils.i_ret_code;
1762: retmsg := ecx_utils.i_errbuf;
1763: when others then
1764: retcode := 2;
1765: retmsg := SQLERRM;
1766: end get_delivery_attribs;

Line 1856: retcode := ecx_utils.i_ret_code;

1852:
1853: If ( i_msgid is NULL ) Then
1854: -- MLS
1855: ecx_debug.setErrorInfo(1,30,'ECX_MSGID_NOT_NULL');
1856: retcode := ecx_utils.i_ret_code;
1857: errmsg := ecx_utils.i_errbuf;
1858: return;
1859: End If;
1860:

Line 1857: errmsg := ecx_utils.i_errbuf;

1853: If ( i_msgid is NULL ) Then
1854: -- MLS
1855: ecx_debug.setErrorInfo(1,30,'ECX_MSGID_NOT_NULL');
1856: retcode := ecx_utils.i_ret_code;
1857: errmsg := ecx_utils.i_errbuf;
1858: return;
1859: End If;
1860:
1861: Open c1(i_msgid);

Line 1867: retcode := ecx_utils.i_ret_code;

1863:
1864: If c1%NOTFOUND Then
1865: -- MLS
1866: ecx_debug.setErrorInfo(1,30,'ECX_MSGID_NOT_FOUND','p_msgid',i_msgid);
1867: retcode := ecx_utils.i_ret_code;
1868: errmsg := ecx_utils.i_errbuf;
1869: Close c1;
1870: return;
1871: End If;

Line 1868: errmsg := ecx_utils.i_errbuf;

1864: If c1%NOTFOUND Then
1865: -- MLS
1866: ecx_debug.setErrorInfo(1,30,'ECX_MSGID_NOT_FOUND','p_msgid',i_msgid);
1867: retcode := ecx_utils.i_ret_code;
1868: errmsg := ecx_utils.i_errbuf;
1869: Close c1;
1870: return;
1871: End If;
1872:

Line 1881: retcode := ecx_utils.i_ret_code;

1877: c1_rec.transaction_subtype is NULL )
1878: Then
1879: -- MLS
1880: ecx_debug.setErrorInfo(1,30,'ECX_INVALID_TXN_PARAMS');
1881: retcode := ecx_utils.i_ret_code;
1882: errmsg := ecx_utils.i_errbuf;
1883: return;
1884: End IF;
1885:

Line 1882: errmsg := ecx_utils.i_errbuf;

1878: Then
1879: -- MLS
1880: ecx_debug.setErrorInfo(1,30,'ECX_INVALID_TXN_PARAMS');
1881: retcode := ecx_utils.i_ret_code;
1882: errmsg := ecx_utils.i_errbuf;
1883: return;
1884: End IF;
1885:
1886: open c_tp_details

Line 1974: ecx_utils.g_event.addParameterToList('WS_SERVICE_NAMESPACE',

1970: if (upper(l_protocol_type) = 'SOAP') then
1971: i_from_agt.setname('WF_WS_JMS_OUT');
1972:
1973: -- set default Web Services related attributes^M
1974: ecx_utils.g_event.addParameterToList('WS_SERVICE_NAMESPACE',
1975: 'http://xmlns.oracle.com/apps/fnd/XMLGateway');
1976: ecx_utils.g_event.addParameterToList('WS_PORT_OPERATION',
1977: 'ReceiveDocument');
1978: ecx_utils.g_event.addParameterToList('WS_HEADER_IMPL_CLASS',

Line 1976: ecx_utils.g_event.addParameterToList('WS_PORT_OPERATION',

1972:
1973: -- set default Web Services related attributes^M
1974: ecx_utils.g_event.addParameterToList('WS_SERVICE_NAMESPACE',
1975: 'http://xmlns.oracle.com/apps/fnd/XMLGateway');
1976: ecx_utils.g_event.addParameterToList('WS_PORT_OPERATION',
1977: 'ReceiveDocument');
1978: ecx_utils.g_event.addParameterToList('WS_HEADER_IMPL_CLASS',
1979: 'oracle.apps.fnd.wf.ws.client.DefaultHeaderGenerator');
1980: ecx_utils.g_event.addParameterToList('WS_RESPONSE_IMPL_CLASS',

Line 1978: ecx_utils.g_event.addParameterToList('WS_HEADER_IMPL_CLASS',

1974: ecx_utils.g_event.addParameterToList('WS_SERVICE_NAMESPACE',
1975: 'http://xmlns.oracle.com/apps/fnd/XMLGateway');
1976: ecx_utils.g_event.addParameterToList('WS_PORT_OPERATION',
1977: 'ReceiveDocument');
1978: ecx_utils.g_event.addParameterToList('WS_HEADER_IMPL_CLASS',
1979: 'oracle.apps.fnd.wf.ws.client.DefaultHeaderGenerator');
1980: ecx_utils.g_event.addParameterToList('WS_RESPONSE_IMPL_CLASS',
1981: 'oracle.apps.fnd.wf.ws.client.WfWsResponse');
1982:

Line 1980: ecx_utils.g_event.addParameterToList('WS_RESPONSE_IMPL_CLASS',

1976: ecx_utils.g_event.addParameterToList('WS_PORT_OPERATION',
1977: 'ReceiveDocument');
1978: ecx_utils.g_event.addParameterToList('WS_HEADER_IMPL_CLASS',
1979: 'oracle.apps.fnd.wf.ws.client.DefaultHeaderGenerator');
1980: ecx_utils.g_event.addParameterToList('WS_RESPONSE_IMPL_CLASS',
1981: 'oracle.apps.fnd.wf.ws.client.WfWsResponse');
1982:
1983: else
1984:

Line 2006: retcode := ecx_utils.i_ret_code;

2002: i_event.setFromAgent(i_from_agt);
2003: wf_event.send(i_event);
2004: -- MLS
2005: ecx_debug.setErrorInfo(0,10,'ECX_RESEND_TRIGGERED');
2006: retcode := ecx_utils.i_ret_code;
2007: errmsg := ecx_utils.i_errbuf;
2008:
2009: ecx_errorlog.outbound_log(i_event);
2010:

Line 2007: errmsg := ecx_utils.i_errbuf;

2003: wf_event.send(i_event);
2004: -- MLS
2005: ecx_debug.setErrorInfo(0,10,'ECX_RESEND_TRIGGERED');
2006: retcode := ecx_utils.i_ret_code;
2007: errmsg := ecx_utils.i_errbuf;
2008:
2009: ecx_errorlog.outbound_log(i_event);
2010:
2011: if (i_flag <> 'Y') then

Line 2025: retcode := ecx_utils.i_ret_code;

2021: if (ecx_out_wf_qh.retmsg is null AND ecx_out_wf_qh.retcode = 0)
2022: then
2023: -- MLS
2024: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_DOCUMENT.RESEND');
2025: retcode := ecx_utils.i_ret_code;
2026: errmsg := ecx_utils.i_errbuf;
2027: else
2028: -- MLS
2029: ecx_debug.setErrorInfo(ecx_out_wf_qh.retcode,30,

Line 2026: errmsg := ecx_utils.i_errbuf;

2022: then
2023: -- MLS
2024: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_DOCUMENT.RESEND');
2025: retcode := ecx_utils.i_ret_code;
2026: errmsg := ecx_utils.i_errbuf;
2027: else
2028: -- MLS
2029: ecx_debug.setErrorInfo(ecx_out_wf_qh.retcode,30,
2030: ecx_out_wf_qh.retmsg);

Line 2031: retcode := ecx_utils.i_ret_code;

2027: else
2028: -- MLS
2029: ecx_debug.setErrorInfo(ecx_out_wf_qh.retcode,30,
2030: ecx_out_wf_qh.retmsg);
2031: retcode := ecx_utils.i_ret_code;
2032: errmsg := ecx_utils.i_errbuf;
2033: end if;
2034:
2035: if (i_flag <> 'Y') then

Line 2032: errmsg := ecx_utils.i_errbuf;

2028: -- MLS
2029: ecx_debug.setErrorInfo(ecx_out_wf_qh.retcode,30,
2030: ecx_out_wf_qh.retmsg);
2031: retcode := ecx_utils.i_ret_code;
2032: errmsg := ecx_utils.i_errbuf;
2033: end if;
2034:
2035: if (i_flag <> 'Y') then
2036: rollback;

Line 2080: raise ecx_utils.program_exit;

2076:
2077: exception
2078: when no_data_found then
2079: ecx_debug.setErrorInfo(2,30,'ECX_CONFIRM_STATUS_NOT_FOUND');
2080: raise ecx_utils.program_exit;
2081:
2082:
2083: when too_many_rows then
2084: ecx_debug.setErrorInfo(2,30,'ECX_PARTY_TYPE_NOT_SET ');

Line 2085: raise ecx_utils.program_exit;

2081:
2082:
2083: when too_many_rows then
2084: ecx_debug.setErrorInfo(2,30,'ECX_PARTY_TYPE_NOT_SET ');
2085: raise ecx_utils.program_exit;
2086:
2087:
2088: when others then
2089: ecx_debug.setErrorInfo(2,30, SQLERRM ||'- ECX_DOCUMENT.getConfirmationstatus');

Line 2090: raise ecx_utils.program_exit;

2086:
2087:
2088: when others then
2089: ecx_debug.setErrorInfo(2,30, SQLERRM ||'- ECX_DOCUMENT.getConfirmationstatus');
2090: raise ecx_utils.program_exit;
2091: end getConfirmationstatus;
2092:
2093: end ecx_document;