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.OE_CREDIT_CHECK_ORDER_PVT dependencies on FND_MESSAGE

Line 321: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_REMOVED');

317: ||' Line Number: '||TO_CHAR(p_line_number)
318: ||' released from credit check hold.');
319: END IF;
320:
321: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_REMOVED');
322: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
323: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
324: OE_MSG_PUB.Add;
325: ---OE_MSG_PUB.Save_Messages(1);

Line 322: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);

318: ||' released from credit check hold.');
319: END IF;
320:
321: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_REMOVED');
322: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
323: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
324: OE_MSG_PUB.Add;
325: ---OE_MSG_PUB.Save_Messages(1);
326:

Line 323: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);

319: END IF;
320:
321: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_REMOVED');
322: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
323: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
324: OE_MSG_PUB.Add;
325: ---OE_MSG_PUB.Save_Messages(1);
326:
327: IF G_debug_flag = 'Y'

Line 382: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_MSG');

378: THEN
379: -- bug 4002820
380: IF INSTR(p_cc_limit_used, ',') > 0 THEN
381: l_cc_profile_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_PROFILE', p_cc_profile_used); -- 6616741
382: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_MSG');
383: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
384: --6616741 FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used);
385: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used); --6616741
386: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);

Line 383: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);

379: -- bug 4002820
380: IF INSTR(p_cc_limit_used, ',') > 0 THEN
381: l_cc_profile_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_PROFILE', p_cc_profile_used); -- 6616741
382: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_MSG');
383: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
384: --6616741 FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used);
385: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used); --6616741
386: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
387: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_MSG');

Line 384: --6616741 FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used);

380: IF INSTR(p_cc_limit_used, ',') > 0 THEN
381: l_cc_profile_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_PROFILE', p_cc_profile_used); -- 6616741
382: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_MSG');
383: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
384: --6616741 FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used);
385: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used); --6616741
386: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
387: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_MSG');
388: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);

Line 385: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used); --6616741

381: l_cc_profile_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_PROFILE', p_cc_profile_used); -- 6616741
382: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_MSG');
383: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
384: --6616741 FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used);
385: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used); --6616741
386: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
387: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_MSG');
388: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
389: --6616741 FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used);

Line 386: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);

382: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_MSG');
383: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
384: --6616741 FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used);
385: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used); --6616741
386: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
387: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_MSG');
388: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
389: --6616741 FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used);
390: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used); --6616741

Line 387: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_MSG');

383: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
384: --6616741 FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used);
385: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used); --6616741
386: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
387: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_MSG');
388: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
389: --6616741 FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used);
390: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used); --6616741
391: OE_MSG_PUB.Add;

Line 388: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);

384: --6616741 FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used);
385: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used); --6616741
386: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
387: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_MSG');
388: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
389: --6616741 FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used);
390: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used); --6616741
391: OE_MSG_PUB.Add;
392: ELSE

Line 389: --6616741 FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used);

385: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used); --6616741
386: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
387: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_MSG');
388: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
389: --6616741 FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used);
390: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used); --6616741
391: OE_MSG_PUB.Add;
392: ELSE
393: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||

Line 390: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used); --6616741

386: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
387: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_MSG');
388: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
389: --6616741 FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used);
390: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used); --6616741
391: OE_MSG_PUB.Add;
392: ELSE
393: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||
394: p_cc_profile_used);

Line 393: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||

389: --6616741 FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used);
390: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used); --6616741
391: OE_MSG_PUB.Add;
392: ELSE
393: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||
394: p_cc_profile_used);
395: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
396: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||
397: p_cc_profile_used);

Line 395: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);

391: OE_MSG_PUB.Add;
392: ELSE
393: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||
394: p_cc_profile_used);
395: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
396: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||
397: p_cc_profile_used);
398: OE_MSG_PUB.Add;
399: END IF;

Line 396: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||

392: ELSE
393: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||
394: p_cc_profile_used);
395: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
396: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||
397: p_cc_profile_used);
398: OE_MSG_PUB.Add;
399: END IF;
400: ELSE

Line 403: FND_MESSAGE.Set_Name('ONT','OE_CC_EXT_MSG');

399: END IF;
400: ELSE
401: --bug4583872
402: IF INSTR(p_cc_limit_used, ',') > 0 THEN
403: FND_MESSAGE.Set_Name('ONT','OE_CC_EXT_MSG');
404: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
405: FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used);
406: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
407: FND_MESSAGE.Set_Name('ONT','OE_CC_EXT_MSG');

Line 404: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);

400: ELSE
401: --bug4583872
402: IF INSTR(p_cc_limit_used, ',') > 0 THEN
403: FND_MESSAGE.Set_Name('ONT','OE_CC_EXT_MSG');
404: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
405: FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used);
406: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
407: FND_MESSAGE.Set_Name('ONT','OE_CC_EXT_MSG');
408: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);

Line 405: FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used);

401: --bug4583872
402: IF INSTR(p_cc_limit_used, ',') > 0 THEN
403: FND_MESSAGE.Set_Name('ONT','OE_CC_EXT_MSG');
404: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
405: FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used);
406: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
407: FND_MESSAGE.Set_Name('ONT','OE_CC_EXT_MSG');
408: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
409: FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used);

Line 406: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);

402: IF INSTR(p_cc_limit_used, ',') > 0 THEN
403: FND_MESSAGE.Set_Name('ONT','OE_CC_EXT_MSG');
404: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
405: FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used);
406: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
407: FND_MESSAGE.Set_Name('ONT','OE_CC_EXT_MSG');
408: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
409: FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used);
410: OE_MSG_PUB.Add;

Line 407: FND_MESSAGE.Set_Name('ONT','OE_CC_EXT_MSG');

403: FND_MESSAGE.Set_Name('ONT','OE_CC_EXT_MSG');
404: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
405: FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used);
406: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
407: FND_MESSAGE.Set_Name('ONT','OE_CC_EXT_MSG');
408: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
409: FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used);
410: OE_MSG_PUB.Add;
411: ELSE

Line 408: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);

404: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
405: FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used);
406: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
407: FND_MESSAGE.Set_Name('ONT','OE_CC_EXT_MSG');
408: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
409: FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used);
410: OE_MSG_PUB.Add;
411: ELSE
412: FND_MESSAGE.Set_Name('ONT','OE_CC_EXT_'||p_cc_limit_used||'_'||

Line 409: FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used);

405: FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used);
406: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
407: FND_MESSAGE.Set_Name('ONT','OE_CC_EXT_MSG');
408: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
409: FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used);
410: OE_MSG_PUB.Add;
411: ELSE
412: FND_MESSAGE.Set_Name('ONT','OE_CC_EXT_'||p_cc_limit_used||'_'||
413: p_cc_profile_used);

Line 412: FND_MESSAGE.Set_Name('ONT','OE_CC_EXT_'||p_cc_limit_used||'_'||

408: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
409: FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used);
410: OE_MSG_PUB.Add;
411: ELSE
412: FND_MESSAGE.Set_Name('ONT','OE_CC_EXT_'||p_cc_limit_used||'_'||
413: p_cc_profile_used);
414: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
415: FND_MESSAGE.Set_Name('ONT','OE_CC_EXT_'||p_cc_limit_used||'_'||
416: p_cc_profile_used);

Line 414: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);

410: OE_MSG_PUB.Add;
411: ELSE
412: FND_MESSAGE.Set_Name('ONT','OE_CC_EXT_'||p_cc_limit_used||'_'||
413: p_cc_profile_used);
414: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
415: FND_MESSAGE.Set_Name('ONT','OE_CC_EXT_'||p_cc_limit_used||'_'||
416: p_cc_profile_used);
417: OE_MSG_PUB.Add;
418: END IF;

Line 415: FND_MESSAGE.Set_Name('ONT','OE_CC_EXT_'||p_cc_limit_used||'_'||

411: ELSE
412: FND_MESSAGE.Set_Name('ONT','OE_CC_EXT_'||p_cc_limit_used||'_'||
413: p_cc_profile_used);
414: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
415: FND_MESSAGE.Set_Name('ONT','OE_CC_EXT_'||p_cc_limit_used||'_'||
416: p_cc_profile_used);
417: OE_MSG_PUB.Add;
418: END IF;
419: END IF;

Line 421: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_CATEGORY');

417: OE_MSG_PUB.Add;
418: END IF;
419: END IF;
420: ELSE
421: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_CATEGORY');
422: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);
423: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
424: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||
425: 'CATEGORY');

Line 422: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);

418: END IF;
419: END IF;
420: ELSE
421: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_CATEGORY');
422: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);
423: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
424: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||
425: 'CATEGORY');
426: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);

Line 423: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);

419: END IF;
420: ELSE
421: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_CATEGORY');
422: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);
423: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
424: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||
425: 'CATEGORY');
426: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);
427: OE_MSG_PUB.Add;

Line 424: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||

420: ELSE
421: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_CATEGORY');
422: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);
423: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
424: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||
425: 'CATEGORY');
426: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);
427: OE_MSG_PUB.Add;
428: END IF;

Line 426: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);

422: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);
423: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
424: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||
425: 'CATEGORY');
426: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);
427: OE_MSG_PUB.Add;
428: END IF;
429: --
430: -- Write to logfile if original call was from a concurrent program

Line 445: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_ACT_COM');

441: ELSE
442: l_calling_activity := InitCap(OE_Verify_Payment_PUB.G_init_calling_action);
443: END IF;
444:
445: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_ACT_COM');
446: FND_MESSAGE.Set_Token('CALLING_ACTIVITY',l_calling_activity);
447: FND_MESSAGE.Set_Token('CREDIT_CHECK_RULE',OE_Verify_Payment_PUB.G_credit_check_rule);
448:
449: l_comment := l_comment||SUBSTR(FND_MESSAGE.GET,1,2000);

Line 446: FND_MESSAGE.Set_Token('CALLING_ACTIVITY',l_calling_activity);

442: l_calling_activity := InitCap(OE_Verify_Payment_PUB.G_init_calling_action);
443: END IF;
444:
445: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_ACT_COM');
446: FND_MESSAGE.Set_Token('CALLING_ACTIVITY',l_calling_activity);
447: FND_MESSAGE.Set_Token('CREDIT_CHECK_RULE',OE_Verify_Payment_PUB.G_credit_check_rule);
448:
449: l_comment := l_comment||SUBSTR(FND_MESSAGE.GET,1,2000);
450:

Line 447: FND_MESSAGE.Set_Token('CREDIT_CHECK_RULE',OE_Verify_Payment_PUB.G_credit_check_rule);

443: END IF;
444:
445: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_ACT_COM');
446: FND_MESSAGE.Set_Token('CALLING_ACTIVITY',l_calling_activity);
447: FND_MESSAGE.Set_Token('CREDIT_CHECK_RULE',OE_Verify_Payment_PUB.G_credit_check_rule);
448:
449: l_comment := l_comment||SUBSTR(FND_MESSAGE.GET,1,2000);
450:
451: --ER#7479609 end

Line 449: l_comment := l_comment||SUBSTR(FND_MESSAGE.GET,1,2000);

445: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_ACT_COM');
446: FND_MESSAGE.Set_Token('CALLING_ACTIVITY',l_calling_activity);
447: FND_MESSAGE.Set_Token('CREDIT_CHECK_RULE',OE_Verify_Payment_PUB.G_credit_check_rule);
448:
449: l_comment := l_comment||SUBSTR(FND_MESSAGE.GET,1,2000);
450:
451: --ER#7479609 end
452:
453: x_comment := l_comment;

Line 492: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_REMOVED');

488: IF p_calling_action = 'AUTO RELEASE' THEN
489: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Order '||TO_CHAR(p_order_number)
490: ||': Credit check hold released.');
491: ELSE
492: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_REMOVED');
493: OE_MSG_PUB.Add;
494: END IF;
495: --
496: IF G_debug_flag = 'Y'

Line 946: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_ACT_COM');

942: ELSE
943: l_calling_activity := InitCap(OE_Verify_Payment_PUB.G_init_calling_action);
944: END IF;
945:
946: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_ACT_COM');
947: FND_MESSAGE.Set_Token('CALLING_ACTIVITY',l_calling_activity);
948: FND_MESSAGE.Set_Token('CREDIT_CHECK_RULE',OE_Verify_Payment_PUB.G_credit_check_rule);
949:
950: l_hold_release_rec.release_comment := l_hold_release_rec.release_comment||SUBSTR(FND_MESSAGE.GET,1,2000);

Line 947: FND_MESSAGE.Set_Token('CALLING_ACTIVITY',l_calling_activity);

943: l_calling_activity := InitCap(OE_Verify_Payment_PUB.G_init_calling_action);
944: END IF;
945:
946: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_ACT_COM');
947: FND_MESSAGE.Set_Token('CALLING_ACTIVITY',l_calling_activity);
948: FND_MESSAGE.Set_Token('CREDIT_CHECK_RULE',OE_Verify_Payment_PUB.G_credit_check_rule);
949:
950: l_hold_release_rec.release_comment := l_hold_release_rec.release_comment||SUBSTR(FND_MESSAGE.GET,1,2000);
951:

Line 948: FND_MESSAGE.Set_Token('CREDIT_CHECK_RULE',OE_Verify_Payment_PUB.G_credit_check_rule);

944: END IF;
945:
946: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_ACT_COM');
947: FND_MESSAGE.Set_Token('CALLING_ACTIVITY',l_calling_activity);
948: FND_MESSAGE.Set_Token('CREDIT_CHECK_RULE',OE_Verify_Payment_PUB.G_credit_check_rule);
949:
950: l_hold_release_rec.release_comment := l_hold_release_rec.release_comment||SUBSTR(FND_MESSAGE.GET,1,2000);
951:
952: --ER#7479609 end

Line 950: l_hold_release_rec.release_comment := l_hold_release_rec.release_comment||SUBSTR(FND_MESSAGE.GET,1,2000);

946: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_ACT_COM');
947: FND_MESSAGE.Set_Token('CALLING_ACTIVITY',l_calling_activity);
948: FND_MESSAGE.Set_Token('CREDIT_CHECK_RULE',OE_Verify_Payment_PUB.G_credit_check_rule);
949:
950: l_hold_release_rec.release_comment := l_hold_release_rec.release_comment||SUBSTR(FND_MESSAGE.GET,1,2000);
951:
952: --ER#7479609 end
953:
954:

Line 1245: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');

1241: END IF;
1242:
1243: x_cc_result_out := 'FAIL';
1244:
1245: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
1246: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);
1247: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
1248: FND_MESSAGE.Set_Token('CONV',
1249: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));

Line 1246: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);

1242:
1243: x_cc_result_out := 'FAIL';
1244:
1245: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
1246: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);
1247: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
1248: FND_MESSAGE.Set_Token('CONV',
1249: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
1250: OE_Credit_Engine_GRP.G_currency_error_msg :=

Line 1247: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );

1243: x_cc_result_out := 'FAIL';
1244:
1245: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
1246: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);
1247: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
1248: FND_MESSAGE.Set_Token('CONV',
1249: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
1250: OE_Credit_Engine_GRP.G_currency_error_msg :=
1251: SUBSTR(FND_MESSAGE.GET,1,1000) ;

Line 1248: FND_MESSAGE.Set_Token('CONV',

1244:
1245: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
1246: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);
1247: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
1248: FND_MESSAGE.Set_Token('CONV',
1249: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
1250: OE_Credit_Engine_GRP.G_currency_error_msg :=
1251: SUBSTR(FND_MESSAGE.GET,1,1000) ;
1252:

Line 1251: SUBSTR(FND_MESSAGE.GET,1,1000) ;

1247: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
1248: FND_MESSAGE.Set_Token('CONV',
1249: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
1250: OE_Credit_Engine_GRP.G_currency_error_msg :=
1251: SUBSTR(FND_MESSAGE.GET,1,1000) ;
1252:
1253: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
1254: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);
1255: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );

Line 1253: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');

1249: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
1250: OE_Credit_Engine_GRP.G_currency_error_msg :=
1251: SUBSTR(FND_MESSAGE.GET,1,1000) ;
1252:
1253: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
1254: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);
1255: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
1256: FND_MESSAGE.Set_Token('CONV',
1257: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));

Line 1254: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);

1250: OE_Credit_Engine_GRP.G_currency_error_msg :=
1251: SUBSTR(FND_MESSAGE.GET,1,1000) ;
1252:
1253: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
1254: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);
1255: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
1256: FND_MESSAGE.Set_Token('CONV',
1257: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
1258: OE_MSG_PUB.ADD;

Line 1255: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );

1251: SUBSTR(FND_MESSAGE.GET,1,1000) ;
1252:
1253: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
1254: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);
1255: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
1256: FND_MESSAGE.Set_Token('CONV',
1257: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
1258: OE_MSG_PUB.ADD;
1259:

Line 1256: FND_MESSAGE.Set_Token('CONV',

1252:
1253: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
1254: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);
1255: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
1256: FND_MESSAGE.Set_Token('CONV',
1257: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
1258: OE_MSG_PUB.ADD;
1259:
1260: G_result_out := 'FAIL' ;

Line 1926: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');

1922: END IF;
1923: x_cc_result_out := 'FAIL';
1924:
1925:
1926: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
1927: FND_MESSAGE.Set_Token('FROM',l_conversion_status(1).usage_curr_code );
1928: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
1929: FND_MESSAGE.Set_Token('CONV',
1930: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate')) ;

Line 1927: FND_MESSAGE.Set_Token('FROM',l_conversion_status(1).usage_curr_code );

1923: x_cc_result_out := 'FAIL';
1924:
1925:
1926: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
1927: FND_MESSAGE.Set_Token('FROM',l_conversion_status(1).usage_curr_code );
1928: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
1929: FND_MESSAGE.Set_Token('CONV',
1930: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate')) ;
1931: OE_Credit_Engine_GRP.G_currency_error_msg :=

Line 1928: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );

1924:
1925:
1926: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
1927: FND_MESSAGE.Set_Token('FROM',l_conversion_status(1).usage_curr_code );
1928: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
1929: FND_MESSAGE.Set_Token('CONV',
1930: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate')) ;
1931: OE_Credit_Engine_GRP.G_currency_error_msg :=
1932: SUBSTR(FND_MESSAGE.GET,1,1000) ;

Line 1929: FND_MESSAGE.Set_Token('CONV',

1925:
1926: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
1927: FND_MESSAGE.Set_Token('FROM',l_conversion_status(1).usage_curr_code );
1928: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
1929: FND_MESSAGE.Set_Token('CONV',
1930: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate')) ;
1931: OE_Credit_Engine_GRP.G_currency_error_msg :=
1932: SUBSTR(FND_MESSAGE.GET,1,1000) ;
1933:

Line 1932: SUBSTR(FND_MESSAGE.GET,1,1000) ;

1928: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
1929: FND_MESSAGE.Set_Token('CONV',
1930: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate')) ;
1931: OE_Credit_Engine_GRP.G_currency_error_msg :=
1932: SUBSTR(FND_MESSAGE.GET,1,1000) ;
1933:
1934: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
1935: FND_MESSAGE.Set_Token('FROM',l_conversion_status(1).usage_curr_code );
1936: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );

Line 1934: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');

1930: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate')) ;
1931: OE_Credit_Engine_GRP.G_currency_error_msg :=
1932: SUBSTR(FND_MESSAGE.GET,1,1000) ;
1933:
1934: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
1935: FND_MESSAGE.Set_Token('FROM',l_conversion_status(1).usage_curr_code );
1936: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
1937: FND_MESSAGE.Set_Token('CONV',
1938: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate')) ;

Line 1935: FND_MESSAGE.Set_Token('FROM',l_conversion_status(1).usage_curr_code );

1931: OE_Credit_Engine_GRP.G_currency_error_msg :=
1932: SUBSTR(FND_MESSAGE.GET,1,1000) ;
1933:
1934: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
1935: FND_MESSAGE.Set_Token('FROM',l_conversion_status(1).usage_curr_code );
1936: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
1937: FND_MESSAGE.Set_Token('CONV',
1938: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate')) ;
1939:

Line 1936: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );

1932: SUBSTR(FND_MESSAGE.GET,1,1000) ;
1933:
1934: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
1935: FND_MESSAGE.Set_Token('FROM',l_conversion_status(1).usage_curr_code );
1936: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
1937: FND_MESSAGE.Set_Token('CONV',
1938: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate')) ;
1939:
1940: OE_MSG_PUB.ADD;

Line 1937: FND_MESSAGE.Set_Token('CONV',

1933:
1934: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
1935: FND_MESSAGE.Set_Token('FROM',l_conversion_status(1).usage_curr_code );
1936: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
1937: FND_MESSAGE.Set_Token('CONV',
1938: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate')) ;
1939:
1940: OE_MSG_PUB.ADD;
1941:

Line 2163: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');

2159: OE_DEBUG_PUB.Add('currency = '|| p_header_rec.transactional_curr_code );
2160: OE_DEBUG_PUB.Add('checking category = '|| l_check_category_id );
2161: END IF;
2162:
2163: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2164: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);
2165: FND_MESSAGE.Set_Token('TO',l_limit_curr );
2166: FND_MESSAGE.Set_Token('CONV',
2167: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate')) ;

Line 2164: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);

2160: OE_DEBUG_PUB.Add('checking category = '|| l_check_category_id );
2161: END IF;
2162:
2163: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2164: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);
2165: FND_MESSAGE.Set_Token('TO',l_limit_curr );
2166: FND_MESSAGE.Set_Token('CONV',
2167: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate')) ;
2168: OE_Credit_Engine_GRP.G_currency_error_msg :=

Line 2165: FND_MESSAGE.Set_Token('TO',l_limit_curr );

2161: END IF;
2162:
2163: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2164: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);
2165: FND_MESSAGE.Set_Token('TO',l_limit_curr );
2166: FND_MESSAGE.Set_Token('CONV',
2167: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate')) ;
2168: OE_Credit_Engine_GRP.G_currency_error_msg :=
2169: SUBSTR(FND_MESSAGE.GET,1,1000) ;

Line 2166: FND_MESSAGE.Set_Token('CONV',

2162:
2163: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2164: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);
2165: FND_MESSAGE.Set_Token('TO',l_limit_curr );
2166: FND_MESSAGE.Set_Token('CONV',
2167: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate')) ;
2168: OE_Credit_Engine_GRP.G_currency_error_msg :=
2169: SUBSTR(FND_MESSAGE.GET,1,1000) ;
2170:

Line 2169: SUBSTR(FND_MESSAGE.GET,1,1000) ;

2165: FND_MESSAGE.Set_Token('TO',l_limit_curr );
2166: FND_MESSAGE.Set_Token('CONV',
2167: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate')) ;
2168: OE_Credit_Engine_GRP.G_currency_error_msg :=
2169: SUBSTR(FND_MESSAGE.GET,1,1000) ;
2170:
2171: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2172: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);
2173: FND_MESSAGE.Set_Token('TO',l_limit_curr );

Line 2171: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');

2167: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate')) ;
2168: OE_Credit_Engine_GRP.G_currency_error_msg :=
2169: SUBSTR(FND_MESSAGE.GET,1,1000) ;
2170:
2171: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2172: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);
2173: FND_MESSAGE.Set_Token('TO',l_limit_curr );
2174: FND_MESSAGE.Set_Token('CONV',
2175: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate')) ;

Line 2172: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);

2168: OE_Credit_Engine_GRP.G_currency_error_msg :=
2169: SUBSTR(FND_MESSAGE.GET,1,1000) ;
2170:
2171: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2172: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);
2173: FND_MESSAGE.Set_Token('TO',l_limit_curr );
2174: FND_MESSAGE.Set_Token('CONV',
2175: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate')) ;
2176:

Line 2173: FND_MESSAGE.Set_Token('TO',l_limit_curr );

2169: SUBSTR(FND_MESSAGE.GET,1,1000) ;
2170:
2171: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2172: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);
2173: FND_MESSAGE.Set_Token('TO',l_limit_curr );
2174: FND_MESSAGE.Set_Token('CONV',
2175: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate')) ;
2176:
2177: OE_MSG_PUB.ADD ;

Line 2174: FND_MESSAGE.Set_Token('CONV',

2170:
2171: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2172: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);
2173: FND_MESSAGE.Set_Token('TO',l_limit_curr );
2174: FND_MESSAGE.Set_Token('CONV',
2175: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate')) ;
2176:
2177: OE_MSG_PUB.ADD ;
2178:

Line 2757: FND_MESSAGE.Set_Name('ONT','OE_CC_CMGT_REVIEW');

2753:
2754: IF x_return_status='S'
2755: THEN
2756:
2757: FND_MESSAGE.Set_Name('ONT','OE_CC_CMGT_REVIEW');
2758: FND_MESSAGE.Set_Token('REQUEST_ID',l_request_id);
2759: OE_MSG_PUB.Add;
2760:
2761: END IF;

Line 2758: FND_MESSAGE.Set_Token('REQUEST_ID',l_request_id);

2754: IF x_return_status='S'
2755: THEN
2756:
2757: FND_MESSAGE.Set_Name('ONT','OE_CC_CMGT_REVIEW');
2758: FND_MESSAGE.Set_Token('REQUEST_ID',l_request_id);
2759: OE_MSG_PUB.Add;
2760:
2761: END IF;
2762: