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_ERRORLOG dependencies on ECX_UTILS

Line 43: logfile = ecx_utils.g_logfile,

39: update ecx_outbound_logs
40: set status=i_status,
41: out_msgid = i_outmsgid,
42: error_id = i_error_no,
43: logfile = ecx_utils.g_logfile,
44: time_stamp = sysdate,
45: party_type = decode(i_party_type,null,party_type,i_party_type)
46: where trigger_id=i_trigger_id;
47:

Line 72: nvl(i_errparams, ecx_utils.i_errparams)

68: )
69: values (
70: i_error_no,
71: i_errmsg,
72: nvl(i_errparams, ecx_utils.i_errparams)
73: );
74: ecx_utils.i_curr_errid := i_error_no;
75:
76: end if;

Line 74: ecx_utils.i_curr_errid := i_error_no;

70: i_error_no,
71: i_errmsg,
72: nvl(i_errparams, ecx_utils.i_errparams)
73: );
74: ecx_utils.i_curr_errid := i_error_no;
75:
76: end if;
77:
78: /**

Line 122: logfile = ecx_utils.g_logfile,

118:
119: update ecx_inbound_logs
120: set status = i_status,
121: error_id = i_error_no,
122: logfile = ecx_utils.g_logfile,
123: time_stamp = sysdate
124: where process_id = i_process_id;
125:
126: for c_curr_trigger_id in get_curr_trigger_id(i_process_id)

Line 155: nvl(i_errparams, ecx_utils.i_errparams)

151: )
152: values (
153: i_error_no,
154: i_errmsg,
155: nvl(i_errparams, ecx_utils.i_errparams)
156: );
157: ecx_utils.i_curr_errid := i_error_no;
158: end if;
159: /**

Line 157: ecx_utils.i_curr_errid := i_error_no;

153: i_error_no,
154: i_errmsg,
155: nvl(i_errparams, ecx_utils.i_errparams)
156: );
157: ecx_utils.i_curr_errid := i_error_no;
158: end if;
159: /**
160: Commit for the Autonomous transaction.
161: **/

Line 232: ecx_utils.getLogDirectory;

228:
229: begin
230:
231: --- Sets the Log Directory in both Standalone and the Embedded mode
232: ecx_utils.getLogDirectory;
233: ecx_debug.enable_debug_new(debug_mode, ecx_utils.g_logdir, 'otacb_'||i_outmsgid||'.log', 'otacb_'||i_outmsgid||'.log');
234:
235: /* Assign local variables with the ecx_debug global variables*/
236: l_procedure := ecx_debug.g_procedure;

Line 233: ecx_debug.enable_debug_new(debug_mode, ecx_utils.g_logdir, 'otacb_'||i_outmsgid||'.log', 'otacb_'||i_outmsgid||'.log');

229: begin
230:
231: --- Sets the Log Directory in both Standalone and the Embedded mode
232: ecx_utils.getLogDirectory;
233: ecx_debug.enable_debug_new(debug_mode, ecx_utils.g_logdir, 'otacb_'||i_outmsgid||'.log', 'otacb_'||i_outmsgid||'.log');
234:
235: /* Assign local variables with the ecx_debug global variables*/
236: l_procedure := ecx_debug.g_procedure;
237: l_statement := ecx_debug.g_statement;

Line 305: nvl(i_errparams, ecx_utils.i_errparams)

301: )
302: values (
303: i_error_no,
304: i_errmsg,
305: nvl(i_errparams, ecx_utils.i_errparams)
306: );
307: ecx_utils.i_curr_errid := i_error_no;
308: end if;
309: /* Start of Bug #2167164 */

Line 307: ecx_utils.i_curr_errid := i_error_no;

303: i_error_no,
304: i_errmsg,
305: nvl(i_errparams, ecx_utils.i_errparams)
306: );
307: ecx_utils.i_curr_errid := i_error_no;
308: end if;
309: /* Start of Bug #2167164 */
310: BEGIN
311: update ecx_external_retry set status= i_status,time_stamp = i_timestamp,error_id=i_error_no where retry_msgid=i_outmsgid;

Line 697: ecx_utils.error_type := 20;

693: then
694: return;
695: elsif (i_ret_code = 1)
696: then
697: ecx_utils.error_type := 20;
698: elsif (i_ret_code = 2)
699: then
700: ecx_utils.error_type := 30;
701: end if;

Line 700: ecx_utils.error_type := 30;

696: then
697: ecx_utils.error_type := 20;
698: elsif (i_ret_code = 2)
699: then
700: ecx_utils.error_type := 30;
701: end if;
702:
703: open c1;
704: fetch c1 into i_sysdate;

Line 707: if ( ecx_utils.g_direction = 'IN' ) and (ecx_utils.error_type = 20)

703: open c1;
704: fetch c1 into i_sysdate;
705: close c1;
706:
707: if ( ecx_utils.g_direction = 'IN' ) and (ecx_utils.error_type = 20)
708: then
709: ecx_trading_partner_pvt.get_senders_tp_info
710: (
711: p_party_id => m_party_id,

Line 718: elsif ( ecx_utils.g_direction = 'OUT' ) and (ecx_utils.error_type = 20)

714: p_admin_email => m_admin_email,
715: retcode => retcode,
716: retmsg => retmsg
717: );
718: elsif ( ecx_utils.g_direction = 'OUT' ) and (ecx_utils.error_type = 20)
719: then
720: ecx_trading_partner_pvt.get_receivers_tp_info
721: (
722: p_party_id => m_party_id,

Line 745: p_event.addParameterToList('ECX_ERROR_TYPE',ecx_utils.error_type);

741: p_event.setSendDate(i_sysdate);
742:
743: p_event.addParameterToList('ECX_RETURN_CODE', i_ret_code);
744: p_event.addParameterToList('ECX_ERROR_MSG',i_errbuf);
745: p_event.addParameterToList('ECX_ERROR_TYPE',ecx_utils.error_type);
746: p_event.addParameterToList('ECX_PARTY_ID', m_party_id);
747: p_event.addParameterToList('ECX_PARTY_SITE_ID', m_party_site_id);
748: p_event.addParameterToList('ECX_TRANSACTION_TYPE', ecx_utils.g_transaction_type);
749: p_event.addParameterToList('ECX_TRANSACTION_SUBTYPE',ecx_utils.g_transaction_subtype);

Line 748: p_event.addParameterToList('ECX_TRANSACTION_TYPE', ecx_utils.g_transaction_type);

744: p_event.addParameterToList('ECX_ERROR_MSG',i_errbuf);
745: p_event.addParameterToList('ECX_ERROR_TYPE',ecx_utils.error_type);
746: p_event.addParameterToList('ECX_PARTY_ID', m_party_id);
747: p_event.addParameterToList('ECX_PARTY_SITE_ID', m_party_site_id);
748: p_event.addParameterToList('ECX_TRANSACTION_TYPE', ecx_utils.g_transaction_type);
749: p_event.addParameterToList('ECX_TRANSACTION_SUBTYPE',ecx_utils.g_transaction_subtype);
750: p_event.addParameterToList('ECX_PARTY_ADMIN_EMAIL',m_admin_email);
751:
752: wf_event.raise(p_event.getEventName(),

Line 749: p_event.addParameterToList('ECX_TRANSACTION_SUBTYPE',ecx_utils.g_transaction_subtype);

745: p_event.addParameterToList('ECX_ERROR_TYPE',ecx_utils.error_type);
746: p_event.addParameterToList('ECX_PARTY_ID', m_party_id);
747: p_event.addParameterToList('ECX_PARTY_SITE_ID', m_party_site_id);
748: p_event.addParameterToList('ECX_TRANSACTION_TYPE', ecx_utils.g_transaction_type);
749: p_event.addParameterToList('ECX_TRANSACTION_SUBTYPE',ecx_utils.g_transaction_subtype);
750: p_event.addParameterToList('ECX_PARTY_ADMIN_EMAIL',m_admin_email);
751:
752: wf_event.raise(p_event.getEventName(),
753: p_event.getEventKey(),

Line 807: ecx_utils.error_type := p_error_type;

803: i_tp_hdr_id number;
804:
805: begin
806:
807: ecx_utils.error_type := p_error_type;
808: ecx_utils.g_transaction_type := p_transaction_type;
809: ecx_utils.g_transaction_subtype := p_transaction_subtype;
810:
811: open c1;

Line 808: ecx_utils.g_transaction_type := p_transaction_type;

804:
805: begin
806:
807: ecx_utils.error_type := p_error_type;
808: ecx_utils.g_transaction_type := p_transaction_type;
809: ecx_utils.g_transaction_subtype := p_transaction_subtype;
810:
811: open c1;
812: fetch c1 into i_sysdate;

Line 809: ecx_utils.g_transaction_subtype := p_transaction_subtype;

805: begin
806:
807: ecx_utils.error_type := p_error_type;
808: ecx_utils.g_transaction_type := p_transaction_type;
809: ecx_utils.g_transaction_subtype := p_transaction_subtype;
810:
811: open c1;
812: fetch c1 into i_sysdate;
813: close c1;

Line 826: if ecx_utils.error_type = 20

822: 'p_party_type',p_party_type);
823: x_retcode := 2;
824: end if;
825:
826: if ecx_utils.error_type = 20
827: then
828: ecx_tp_api.retrieve_trading_partner(
829: x_return_status => x_retcode,
830: x_msg => x_retmsg,

Line 856: p_event.addParameterToList('ECX_ERROR_TYPE',ecx_utils.error_type);

852: p_event.setSendDate(i_sysdate);
853:
854: p_event.addParameterToList('ECX_RETURN_CODE', p_retcode);
855: p_event.addParameterToList('ECX_ERROR_MSG',p_errbuf);
856: p_event.addParameterToList('ECX_ERROR_TYPE',ecx_utils.error_type);
857: p_event.addParameterToList('ECX_PARTY_ID', p_party_id);
858: p_event.addParameterToList('ECX_PARTY_SITE_ID', p_party_site_id);
859: p_event.addParameterToList('ECX_TRANSACTION_TYPE', p_transaction_type);
860: p_event.addParameterToList('ECX_TRANSACTION_SUBTYPE',p_transaction_subtype);

Line 958: nvl(i_errparams, ecx_utils.i_errparams)

954: )
955: values (
956: i_error_no,
957: i_errmsg,
958: nvl(i_errparams, ecx_utils.i_errparams)
959: );
960: ecx_utils.i_curr_errid := i_error_no;
961: end if;
962:

Line 960: ecx_utils.i_curr_errid := i_error_no;

956: i_error_no,
957: i_errmsg,
958: nvl(i_errparams, ecx_utils.i_errparams)
959: );
960: ecx_utils.i_curr_errid := i_error_no;
961: end if;
962:
963: /**
964: Commit for the Autonomous transaction.

Line 1070: nvl(i_errparams, ecx_utils.i_errparams)

1066: )
1067: values (
1068: i_error_no,
1069: i_errmsg,
1070: nvl(i_errparams, ecx_utils.i_errparams)
1071: );
1072: ecx_utils.i_curr_errid := i_error_no;
1073: end if;
1074:

Line 1072: ecx_utils.i_curr_errid := i_error_no;

1068: i_error_no,
1069: i_errmsg,
1070: nvl(i_errparams, ecx_utils.i_errparams)
1071: );
1072: ecx_utils.i_curr_errid := i_error_no;
1073: end if;
1074:
1075: /**
1076: Commit for the Autonomous transaction.

Line 1140: ecx_utils.convertPartyTypeToCode(i_party_type, l_party_type);

1136: o_retcode := ecx_util_api.G_INVALID_PARAM;
1137: o_retmsg := 'ECX_INVALID_DIRECTION';
1138: end if;
1139:
1140: ecx_utils.convertPartyTypeToCode(i_party_type, l_party_type);
1141:
1142: insert into ecx_doclogs
1143: (
1144: msgid,

Line 1362: ecx_utils.i_ret_code := o_retcode;

1358: exception
1359: when no_data_found then
1360: o_retcode := 2;
1361: o_retmsg := ecx_debug.getTranslatedMessage('ECX_DOCLOGS_NOT_EXISTS', 'p_msgid', i_msgid);
1362: ecx_utils.i_ret_code := o_retcode;
1363: ecx_utils.i_errbuf := o_retmsg;
1364: when others then
1365: o_retcode := 2;
1366: o_retmsg := SQLERRM;

Line 1363: ecx_utils.i_errbuf := o_retmsg;

1359: when no_data_found then
1360: o_retcode := 2;
1361: o_retmsg := ecx_debug.getTranslatedMessage('ECX_DOCLOGS_NOT_EXISTS', 'p_msgid', i_msgid);
1362: ecx_utils.i_ret_code := o_retcode;
1363: ecx_utils.i_errbuf := o_retmsg;
1364: when others then
1365: o_retcode := 2;
1366: o_retmsg := SQLERRM;
1367: ecx_utils.i_ret_code := o_retcode;

Line 1367: ecx_utils.i_ret_code := o_retcode;

1363: ecx_utils.i_errbuf := o_retmsg;
1364: when others then
1365: o_retcode := 2;
1366: o_retmsg := SQLERRM;
1367: ecx_utils.i_ret_code := o_retcode;
1368: ecx_utils.i_errbuf := o_retmsg;
1369:
1370: end getDoclogDetails;
1371:

Line 1368: ecx_utils.i_errbuf := o_retmsg;

1364: when others then
1365: o_retcode := 2;
1366: o_retmsg := SQLERRM;
1367: ecx_utils.i_ret_code := o_retcode;
1368: ecx_utils.i_errbuf := o_retmsg;
1369:
1370: end getDoclogDetails;
1371:
1372: procedure log_resend(

Line 1809: l_direction := ecx_utils.g_direction;

1805:
1806: -- This code was originally in the queue handler and this is moved to here for
1807: -- backward compatible purpose. Not sure who is using this.
1808: if (l_direction is null) then
1809: l_direction := ecx_utils.g_direction;
1810: end if;
1811:
1812: if (UPPER(l_direction) = 'OUT') then
1813: if (l_activity_id is not null) then