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_TRADING_PARTNER_PVT dependencies on ECX_DEBUG

Line 42: retmsg := ecx_debug.getTranslatedMessage('ECX_INVALID_TP_HDR_ID',

38:
39: if p_party_site_id is null
40: then
41: retcode :=0;
42: retmsg := ecx_debug.getTranslatedMessage('ECX_INVALID_TP_HDR_ID',
43: 'p_tp_header_id', p_tp_header_id);
44: ecx_debug.setErrorInfo(1,30,
45: 'ECX_INVALID_TP_HDR_ID', 'p_tp_header_id', p_tp_header_id);
46: return;

Line 44: ecx_debug.setErrorInfo(1,30,

40: then
41: retcode :=0;
42: retmsg := ecx_debug.getTranslatedMessage('ECX_INVALID_TP_HDR_ID',
43: 'p_tp_header_id', p_tp_header_id);
44: ecx_debug.setErrorInfo(1,30,
45: 'ECX_INVALID_TP_HDR_ID', 'p_tp_header_id', p_tp_header_id);
46: return;
47: end if;
48:

Line 71: ecx_debug.setErrorInfo(1,30, 'ECX_INVALID_PARTY_TYPE', 'p_party_type',p_party_type);

67: ' where vendor_id = :party_id' ||
68: ' and vendor_site_id = :party_site_id ';
69:
70: else
71: ecx_debug.setErrorInfo(1,30, 'ECX_INVALID_PARTY_TYPE', 'p_party_type',p_party_type);
72: retcode := 1;
73: retmsg := ecx_debug.getTranslatedMessage('ECX_INVALID_PARTY_TYPE',
74: 'p_party_type',p_party_type);
75: return;

Line 73: retmsg := ecx_debug.getTranslatedMessage('ECX_INVALID_PARTY_TYPE',

69:
70: else
71: ecx_debug.setErrorInfo(1,30, 'ECX_INVALID_PARTY_TYPE', 'p_party_type',p_party_type);
72: retcode := 1;
73: retmsg := ecx_debug.getTranslatedMessage('ECX_INVALID_PARTY_TYPE',
74: 'p_party_type',p_party_type);
75: return;
76: end if;
77:

Line 93: ecx_debug.setErrorInfo(2,30, SQLERRM || '- ECX_TRADING_PARTNER_PVT.GET_TP_INFO');

89: end if;
90:
91: exception
92: when others then
93: ecx_debug.setErrorInfo(2,30, SQLERRM || '- ECX_TRADING_PARTNER_PVT.GET_TP_INFO');
94: retcode := 2;
95: retmsg := SQLERRM;
96: end get_tp_info;
97:

Line 144: ecx_debug.setErrorInfo(1,30, 'ECX_INVALID_ADDRESS_TYPE', 'p_address_type',p_info_type);

140: ' from hr_locations_all' ||
141: ' where ece_tp_location_code = :location_code_ext ';
142:
143: else
144: ecx_debug.setErrorInfo(1,30, 'ECX_INVALID_ADDRESS_TYPE', 'p_address_type',p_info_type);
145: retcode := 1;
146: retmsg := ecx_debug.getTranslatedMessage( 'ECX_INVALID_ADDRESS_TYPE',
147: 'p_address_type',p_info_type);
148: return;

Line 146: retmsg := ecx_debug.getTranslatedMessage( 'ECX_INVALID_ADDRESS_TYPE',

142:
143: else
144: ecx_debug.setErrorInfo(1,30, 'ECX_INVALID_ADDRESS_TYPE', 'p_address_type',p_info_type);
145: retcode := 1;
146: retmsg := ecx_debug.getTranslatedMessage( 'ECX_INVALID_ADDRESS_TYPE',
147: 'p_address_type',p_info_type);
148: return;
149: end if;
150:

Line 167: ecx_debug.setErrorInfo(1,30,'ECX_ADDR_DERIVATION_ERR', 'p_address_type',p_info_type,

163:
164:
165: if p_entity_address_id is NULL
166: then
167: ecx_debug.setErrorInfo(1,30,'ECX_ADDR_DERIVATION_ERR', 'p_address_type',p_info_type,
168: 'p_location_code', p_location_code_ext);
169: retcode := 1;
170: retmsg := ecx_debug.getTranslatedMessage('ECX_ADDR_DERIVATION_ERR',
171: 'p_address_type',p_info_type,

Line 170: retmsg := ecx_debug.getTranslatedMessage('ECX_ADDR_DERIVATION_ERR',

166: then
167: ecx_debug.setErrorInfo(1,30,'ECX_ADDR_DERIVATION_ERR', 'p_address_type',p_info_type,
168: 'p_location_code', p_location_code_ext);
169: retcode := 1;
170: retmsg := ecx_debug.getTranslatedMessage('ECX_ADDR_DERIVATION_ERR',
171: 'p_address_type',p_info_type,
172: 'p_location_code', p_location_code_ext);
173: end if;
174:

Line 178: ecx_debug.setErrorInfo(2,30,

174:
175:
176: EXCEPTION
177: WHEN OTHERS THEN
178: ecx_debug.setErrorInfo(2,30,
179: SQLERRM ||' - ECX_TRADING_PARTNER_PVT.Get_TP_Address');
180: retcode := 2;
181: retmsg := SQLERRM;
182: end Get_Address_id;

Line 209: ecx_debug.setErrorInfo(1,30,'ECX_RCVR_NOT_SETUP', 'p_tp_header_id', ECX_UTILS.G_rec_tp_id);

205: retcode => retcode,
206: retmsg => retmsg
207: );
208: else
209: ecx_debug.setErrorInfo(1,30,'ECX_RCVR_NOT_SETUP', 'p_tp_header_id', ECX_UTILS.G_rec_tp_id);
210: retcode := 1;
211: retmsg := ecx_debug.getTranslatedMessage('ECX_RCVR_NOT_SETUP');
212: end if;
213: EXCEPTION

Line 211: retmsg := ecx_debug.getTranslatedMessage('ECX_RCVR_NOT_SETUP');

207: );
208: else
209: ecx_debug.setErrorInfo(1,30,'ECX_RCVR_NOT_SETUP', 'p_tp_header_id', ECX_UTILS.G_rec_tp_id);
210: retcode := 1;
211: retmsg := ecx_debug.getTranslatedMessage('ECX_RCVR_NOT_SETUP');
212: end if;
213: EXCEPTION
214: WHEN OTHERS THEN
215: ecx_debug.setErrorInfo(2,30,

Line 215: ecx_debug.setErrorInfo(2,30,

211: retmsg := ecx_debug.getTranslatedMessage('ECX_RCVR_NOT_SETUP');
212: end if;
213: EXCEPTION
214: WHEN OTHERS THEN
215: ecx_debug.setErrorInfo(2,30,
216: SQLERRM ||' - ECX_TRADING_PARTNER_PVT. GET_RECEIVERS_TP_INFO');
217: retcode := 2;
218: retmsg := SQLERRM ||' - ECX_TRADING_PARTNER_PVT. GET_RECEIVERS_TP_INFO';
219: end get_receivers_tp_info;

Line 246: ecx_debug.setErrorInfo(1,30, 'ECX_SNDR_NOT_ENABLED','p_tp_header_id',ECX_UTILS.G_snd_tp_id);

242: retcode => retcode,
243: retmsg => retmsg
244: );
245: else
246: ecx_debug.setErrorInfo(1,30, 'ECX_SNDR_NOT_ENABLED','p_tp_header_id',ECX_UTILS.G_snd_tp_id);
247: retcode := 1;
248: retmsg := ecx_debug.getTranslatedMessage('ECX_SNDR_NOT_SETUP');
249: end if;
250:

Line 248: retmsg := ecx_debug.getTranslatedMessage('ECX_SNDR_NOT_SETUP');

244: );
245: else
246: ecx_debug.setErrorInfo(1,30, 'ECX_SNDR_NOT_ENABLED','p_tp_header_id',ECX_UTILS.G_snd_tp_id);
247: retcode := 1;
248: retmsg := ecx_debug.getTranslatedMessage('ECX_SNDR_NOT_SETUP');
249: end if;
250:
251: EXCEPTION
252: WHEN OTHERS THEN

Line 253: ecx_debug.setErrorInfo(2,30,

249: end if;
250:
251: EXCEPTION
252: WHEN OTHERS THEN
253: ecx_debug.setErrorInfo(2,30,
254: SQLERRM ||' - ECX_TRADING_PARTNER_PVT.GET_SENDERS_TP_INFO');
255: retcode := 2;
256: retmsg := SQLERRM;
257: end get_senders_tp_info;

Line 285: ecx_debug.setErrorInfo(1,30,'ECX_NO_EMAIL_ADDR',

281: retcode := 0;
282:
283: Exception
284: When no_data_found Then
285: ecx_debug.setErrorInfo(1,30,'ECX_NO_EMAIL_ADDR',
286: 'p_transaction_type', l_transaction_type,
287: 'p_transaction_subtype', l_transaction_subtype,
288: 'p_party_type', l_party_type,
289: 'p_party_site_id', l_party_site_id);

Line 293: ecx_debug.setErrorInfo(2,30,'ECX_PARTY_TYPE_NOT_SET');

289: 'p_party_site_id', l_party_site_id);
290:
291: /* Start of bug #2183619*/
292: when too_many_rows then
293: ecx_debug.setErrorInfo(2,30,'ECX_PARTY_TYPE_NOT_SET');
294: raise ecx_utils.program_exit;
295: /* End of bug #2183619 */
296:
297: When Others Then

Line 300: ecx_debug.setErrorInfo(2,30,SQLERRM);

296:
297: When Others Then
298: retcode := 2;
299: errmsg := SQLERRM || ' At ECX_TRADING_PARTNER_PVT.GET_TP_COMPANY_EMAIL';
300: ecx_debug.setErrorInfo(2,30,SQLERRM);
301: End Get_TP_Company_Email;
302:
303: /** Get System Adminstrator Email ***/
304: Procedure get_sysadmin_email(email_address OUT NOCOPY varchar2,

Line 346: ecx_debug.setErrorInfo(2,30,

342: ecx_utils.error_type := 10;
343: retcode := 0;
344: Exception
345: When Others Then
346: ecx_debug.setErrorInfo(2,30,
347: SQLERRM || ' - ECX_TRADING_PARTNER_PVT.get_sysadmin_email');
348: retcode := 2;
349: errmsg := SQLERRM;
350: End;

Line 386: ecx_debug.setErrorInfo(1,30, 'ECX_PARTY_SITE_ID_NOT_NULL');

382:
383: ecx_utils.error_type := 10;
384: p_retcode := 0;
385: Else
386: ecx_debug.setErrorInfo(1,30, 'ECX_PARTY_SITE_ID_NOT_NULL');
387: End If;
388: Else
389: ecx_debug.setErrorInfo(1,30, 'ECX_PARTY_ID_NOT_NULL');
390: End If;

Line 389: ecx_debug.setErrorInfo(1,30, 'ECX_PARTY_ID_NOT_NULL');

385: Else
386: ecx_debug.setErrorInfo(1,30, 'ECX_PARTY_SITE_ID_NOT_NULL');
387: End If;
388: Else
389: ecx_debug.setErrorInfo(1,30, 'ECX_PARTY_ID_NOT_NULL');
390: End If;
391: Else
392: ecx_debug.setErrorInfo(1,30, 'ECX_PARTY_TYPE_NOT_NULL');
393: End IF;

Line 392: ecx_debug.setErrorInfo(1,30, 'ECX_PARTY_TYPE_NOT_NULL');

388: Else
389: ecx_debug.setErrorInfo(1,30, 'ECX_PARTY_ID_NOT_NULL');
390: End If;
391: Else
392: ecx_debug.setErrorInfo(1,30, 'ECX_PARTY_TYPE_NOT_NULL');
393: End IF;
394: p_retcode := ecx_utils.i_ret_code;
395: p_errmsg := ecx_utils.i_errbuf;
396: EXCEPTION

Line 399: p_errmsg := ecx_debug.getTranslatedMessage('ECX_NO_UNIQUE_TP_SETUP');

395: p_errmsg := ecx_utils.i_errbuf;
396: EXCEPTION
397: When no_data_found Then
398: p_retcode := 1;
399: p_errmsg := ecx_debug.getTranslatedMessage('ECX_NO_UNIQUE_TP_SETUP');
400: ecx_debug.setErrorInfo(1,30,
401: 'ECX_NO_UNIQUE_TP_SETUP');
402: When Others Then
403: ecx_debug.setErrorInfo(2,30,

Line 400: ecx_debug.setErrorInfo(1,30,

396: EXCEPTION
397: When no_data_found Then
398: p_retcode := 1;
399: p_errmsg := ecx_debug.getTranslatedMessage('ECX_NO_UNIQUE_TP_SETUP');
400: ecx_debug.setErrorInfo(1,30,
401: 'ECX_NO_UNIQUE_TP_SETUP');
402: When Others Then
403: ecx_debug.setErrorInfo(2,30,
404: SQLERRM || ' At ECX_TRADING_PARTNER_PVT.GET_TP_DETAILS');

Line 403: ecx_debug.setErrorInfo(2,30,

399: p_errmsg := ecx_debug.getTranslatedMessage('ECX_NO_UNIQUE_TP_SETUP');
400: ecx_debug.setErrorInfo(1,30,
401: 'ECX_NO_UNIQUE_TP_SETUP');
402: When Others Then
403: ecx_debug.setErrorInfo(2,30,
404: SQLERRM || ' At ECX_TRADING_PARTNER_PVT.GET_TP_DETAILS');
405: p_retcode := 2;
406: p_errmsg := SQLERRM || ' At ECX_TRADING_PARTNER_PVT.GET_TP_DETAILS';
407: END get_tp_details;

Line 418: ecx_debug.setErrorInfo(2,30, SQLERRM);

414: i_error_type := ecx_utils.error_type;
415: retcode := 0;
416: Exception
417: When Others Then
418: ecx_debug.setErrorInfo(2,30, SQLERRM);
419: retcode := 0;
420: errmsg := SQLERRM;
421: End get_error_type;
422:

Line 492: ecx_debug.setErrorInfo(1,30, 'ECX_NO_ENVELOPE',

488: i_attribute5 := i_get_msg_attributes.attribute5;
489:
490: if get_msg_attributes%NOTFOUND
491: then
492: ecx_debug.setErrorInfo(1,30, 'ECX_NO_ENVELOPE',
493: 'p_icn', i_internal_control_number);
494: retcode := 1;
495: retmsg := ecx_debug.getTranslatedMessage('ECX_NO_ENVELOPE',
496: 'p_icn', i_internal_control_number);

Line 495: retmsg := ecx_debug.getTranslatedMessage('ECX_NO_ENVELOPE',

491: then
492: ecx_debug.setErrorInfo(1,30, 'ECX_NO_ENVELOPE',
493: 'p_icn', i_internal_control_number);
494: retcode := 1;
495: retmsg := ecx_debug.getTranslatedMessage('ECX_NO_ENVELOPE',
496: 'p_icn', i_internal_control_number);
497: if get_msg_attributes%ISOPEN
498: then
499: close get_msg_attributes;

Line 518: ecx_debug.setErrorInfo(2,30, SQLERRM || ' -ECX_TRADING_PARTNER_PVT.getEnvelopeInformation');

514: then
515: close get_msg_attributes;
516: end if;
517:
518: ecx_debug.setErrorInfo(2,30, SQLERRM || ' -ECX_TRADING_PARTNER_PVT.getEnvelopeInformation');
519: retcode :=2;
520: retmsg := SQLERRM || ' -ECX_TRADING_PARTNER_PVT.getEnvelopeInformation';
521: end getEnvelopeInformation;
522:

Line 543: ecx_debug.setErrorInfo(2,30,

539: exception
540: when others then
541: retcode := 2;
542: retmsg := substr(SQLERRM,1,200);
543: ecx_debug.setErrorInfo(2,30,
544: substr(SQLERRM,1,200) || ' -ECX_TRADING_PARTNER_PVT.setOriginalReferenceId');
545: end setOriginalReferenceId;
546:
547:

Line 631: errmsg := ecx_debug.getTranslatedMessage('ECX_RULE_INVALID_TP_SETUP',

627: if (p_tp_flag) then
628: retcode := 0;
629: else
630: retcode := 1;
631: errmsg := ecx_debug.getTranslatedMessage('ECX_RULE_INVALID_TP_SETUP',
632: 'p_standard_code', p_standard_code,'p_transaction_type',p_transaction_type,
633: 'p_transaction_subtype',p_transaction_subtype,'p_party_site_id',p_party_site_id);
634:
635: ecx_debug.setErrorInfo(2,30,

Line 635: ecx_debug.setErrorInfo(2,30,

631: errmsg := ecx_debug.getTranslatedMessage('ECX_RULE_INVALID_TP_SETUP',
632: 'p_standard_code', p_standard_code,'p_transaction_type',p_transaction_type,
633: 'p_transaction_subtype',p_transaction_subtype,'p_party_site_id',p_party_site_id);
634:
635: ecx_debug.setErrorInfo(2,30,
636: 'ECX_RULE_INVALID_TP_SETUP', 'p_standard_code', p_standard_code,'p_transaction_type',p_transaction_type,
637: 'p_transaction_subtype',p_transaction_subtype,'p_party_site_id',p_party_site_id);
638:
639: return 'N';

Line 653: errmsg := ecx_debug.getTranslatedMessage('ECX_USER_TP_NOT_VALID',

649: retcode := 0;
650: return 'Y';
651: else
652: retcode := 2;
653: errmsg := ecx_debug.getTranslatedMessage('ECX_USER_TP_NOT_VALID',
654: 'p_user_name',p_user_name);
655: ecx_debug.setErrorInfo(2,30,
656: 'ECX_USER_TP_NOT_VALID','p_user_name',p_user_name);
657: return 'N';

Line 655: ecx_debug.setErrorInfo(2,30,

651: else
652: retcode := 2;
653: errmsg := ecx_debug.getTranslatedMessage('ECX_USER_TP_NOT_VALID',
654: 'p_user_name',p_user_name);
655: ecx_debug.setErrorInfo(2,30,
656: 'ECX_USER_TP_NOT_VALID','p_user_name',p_user_name);
657: return 'N';
658: end if;
659: Exception