358: ||' Line Number: '||TO_CHAR(p_line_number)
359: ||' released from credit check hold.');
360: END IF;
361:
362: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_REMOVED');
363: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
364: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
365: OE_MSG_PUB.Add;
366: ---OE_MSG_PUB.Save_Messages(1);
359: ||' released from credit check hold.');
360: END IF;
361:
362: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_REMOVED');
363: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
364: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
365: OE_MSG_PUB.Add;
366: ---OE_MSG_PUB.Save_Messages(1);
367:
360: END IF;
361:
362: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_REMOVED');
363: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
364: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
365: OE_MSG_PUB.Add;
366: ---OE_MSG_PUB.Save_Messages(1);
367:
368: IF G_debug_flag = 'Y'
420: THEN
421: -- bug 4002820
422: IF INSTR(p_cc_limit_used, ',') > 0 THEN
423: l_cc_profile_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_PROFILE', p_cc_profile_used); -- 6616741
424: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_MSG');
425: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
426: --6616741 FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used);
427: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used); --6616741
428: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
421: -- bug 4002820
422: IF INSTR(p_cc_limit_used, ',') > 0 THEN
423: l_cc_profile_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_PROFILE', p_cc_profile_used); -- 6616741
424: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_MSG');
425: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
426: --6616741 FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used);
427: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used); --6616741
428: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
429: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_MSG');
422: IF INSTR(p_cc_limit_used, ',') > 0 THEN
423: l_cc_profile_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_PROFILE', p_cc_profile_used); -- 6616741
424: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_MSG');
425: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
426: --6616741 FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used);
427: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used); --6616741
428: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
429: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_MSG');
430: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
423: l_cc_profile_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_PROFILE', p_cc_profile_used); -- 6616741
424: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_MSG');
425: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
426: --6616741 FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used);
427: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used); --6616741
428: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
429: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_MSG');
430: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
431: --6616741 FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used);
424: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_MSG');
425: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
426: --6616741 FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used);
427: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used); --6616741
428: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
429: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_MSG');
430: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
431: --6616741 FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used);
432: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used); --6616741
425: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
426: --6616741 FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used);
427: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used); --6616741
428: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
429: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_MSG');
430: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
431: --6616741 FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used);
432: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used); --6616741
433: OE_MSG_PUB.Add;
426: --6616741 FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used);
427: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used); --6616741
428: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
429: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_MSG');
430: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
431: --6616741 FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used);
432: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used); --6616741
433: OE_MSG_PUB.Add;
434: ELSE
427: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used); --6616741
428: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
429: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_MSG');
430: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
431: --6616741 FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used);
432: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used); --6616741
433: OE_MSG_PUB.Add;
434: ELSE
435: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||
428: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
429: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_MSG');
430: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
431: --6616741 FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used);
432: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used); --6616741
433: OE_MSG_PUB.Add;
434: ELSE
435: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||
436: p_cc_profile_used); --commented ER8880886, uncommented for bug 10305908
431: --6616741 FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used);
432: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used); --6616741
433: OE_MSG_PUB.Add;
434: ELSE
435: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||
436: p_cc_profile_used); --commented ER8880886, uncommented for bug 10305908
437: -- l_cc_profile_used); --ER8880886, commented for bug 10305908
438: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
439: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||
434: ELSE
435: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||
436: p_cc_profile_used); --commented ER8880886, uncommented for bug 10305908
437: -- l_cc_profile_used); --ER8880886, commented for bug 10305908
438: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
439: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||
440: p_cc_profile_used); --commented ER8880886, uncommented for bug 10305908
441: --l_cc_profile_used); --ER8880886, commented for bug 10305908
442: OE_MSG_PUB.Add;
435: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||
436: p_cc_profile_used); --commented ER8880886, uncommented for bug 10305908
437: -- l_cc_profile_used); --ER8880886, commented for bug 10305908
438: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
439: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||
440: p_cc_profile_used); --commented ER8880886, uncommented for bug 10305908
441: --l_cc_profile_used); --ER8880886, commented for bug 10305908
442: OE_MSG_PUB.Add;
443: END IF;
443: END IF;
444: ELSE
445: --bug4583872
446: IF INSTR(p_cc_limit_used, ',') > 0 THEN
447: FND_MESSAGE.Set_Name('ONT','OE_CC_EXT_MSG');
448: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
449: --FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used); -- commented for bug 10305908
450: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used); -- added for bug 10305908
451: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
444: ELSE
445: --bug4583872
446: IF INSTR(p_cc_limit_used, ',') > 0 THEN
447: FND_MESSAGE.Set_Name('ONT','OE_CC_EXT_MSG');
448: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
449: --FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used); -- commented for bug 10305908
450: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used); -- added for bug 10305908
451: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
452: FND_MESSAGE.Set_Name('ONT','OE_CC_EXT_MSG');
445: --bug4583872
446: IF INSTR(p_cc_limit_used, ',') > 0 THEN
447: FND_MESSAGE.Set_Name('ONT','OE_CC_EXT_MSG');
448: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
449: --FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used); -- commented for bug 10305908
450: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used); -- added for bug 10305908
451: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
452: FND_MESSAGE.Set_Name('ONT','OE_CC_EXT_MSG');
453: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
446: IF INSTR(p_cc_limit_used, ',') > 0 THEN
447: FND_MESSAGE.Set_Name('ONT','OE_CC_EXT_MSG');
448: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
449: --FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used); -- commented for bug 10305908
450: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used); -- added for bug 10305908
451: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
452: FND_MESSAGE.Set_Name('ONT','OE_CC_EXT_MSG');
453: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
454: --FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used); -- commented for bug 10305908
447: FND_MESSAGE.Set_Name('ONT','OE_CC_EXT_MSG');
448: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
449: --FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used); -- commented for bug 10305908
450: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used); -- added for bug 10305908
451: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
452: FND_MESSAGE.Set_Name('ONT','OE_CC_EXT_MSG');
453: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
454: --FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used); -- commented for bug 10305908
455: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used); -- added for bug 10305908
448: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
449: --FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used); -- commented for bug 10305908
450: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used); -- added for bug 10305908
451: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
452: FND_MESSAGE.Set_Name('ONT','OE_CC_EXT_MSG');
453: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
454: --FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used); -- commented for bug 10305908
455: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used); -- added for bug 10305908
456: OE_MSG_PUB.Add;
449: --FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used); -- commented for bug 10305908
450: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used); -- added for bug 10305908
451: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
452: FND_MESSAGE.Set_Name('ONT','OE_CC_EXT_MSG');
453: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
454: --FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used); -- commented for bug 10305908
455: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used); -- added for bug 10305908
456: OE_MSG_PUB.Add;
457: ELSE
450: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used); -- added for bug 10305908
451: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
452: FND_MESSAGE.Set_Name('ONT','OE_CC_EXT_MSG');
453: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
454: --FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used); -- commented for bug 10305908
455: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used); -- added for bug 10305908
456: OE_MSG_PUB.Add;
457: ELSE
458: FND_MESSAGE.Set_Name('ONT','OE_CC_EXT_'||p_cc_limit_used||'_'||
451: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
452: FND_MESSAGE.Set_Name('ONT','OE_CC_EXT_MSG');
453: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
454: --FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used); -- commented for bug 10305908
455: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used); -- added for bug 10305908
456: OE_MSG_PUB.Add;
457: ELSE
458: FND_MESSAGE.Set_Name('ONT','OE_CC_EXT_'||p_cc_limit_used||'_'||
459: p_cc_profile_used);
454: --FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used); -- commented for bug 10305908
455: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used); -- added for bug 10305908
456: OE_MSG_PUB.Add;
457: ELSE
458: FND_MESSAGE.Set_Name('ONT','OE_CC_EXT_'||p_cc_limit_used||'_'||
459: p_cc_profile_used);
460: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
461: FND_MESSAGE.Set_Name('ONT','OE_CC_EXT_'||p_cc_limit_used||'_'||
462: p_cc_profile_used);
456: OE_MSG_PUB.Add;
457: ELSE
458: FND_MESSAGE.Set_Name('ONT','OE_CC_EXT_'||p_cc_limit_used||'_'||
459: p_cc_profile_used);
460: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
461: FND_MESSAGE.Set_Name('ONT','OE_CC_EXT_'||p_cc_limit_used||'_'||
462: p_cc_profile_used);
463: OE_MSG_PUB.Add;
464: END IF;
457: ELSE
458: FND_MESSAGE.Set_Name('ONT','OE_CC_EXT_'||p_cc_limit_used||'_'||
459: p_cc_profile_used);
460: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
461: FND_MESSAGE.Set_Name('ONT','OE_CC_EXT_'||p_cc_limit_used||'_'||
462: p_cc_profile_used);
463: OE_MSG_PUB.Add;
464: END IF;
465: END IF;
463: OE_MSG_PUB.Add;
464: END IF;
465: END IF;
466: ELSE
467: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_CATEGORY');
468: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);
469: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
470: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||
471: 'CATEGORY');
464: END IF;
465: END IF;
466: ELSE
467: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_CATEGORY');
468: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);
469: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
470: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||
471: 'CATEGORY');
472: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);
465: END IF;
466: ELSE
467: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_CATEGORY');
468: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);
469: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
470: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||
471: 'CATEGORY');
472: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);
473: OE_MSG_PUB.Add;
466: ELSE
467: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_CATEGORY');
468: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);
469: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
470: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||
471: 'CATEGORY');
472: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);
473: OE_MSG_PUB.Add;
474: END IF;
468: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);
469: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
470: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||
471: 'CATEGORY');
472: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);
473: OE_MSG_PUB.Add;
474: END IF;
475: --
476: -- Write to logfile if original call was from a concurrent program
487: ELSE
488: l_calling_activity := InitCap(OE_Verify_Payment_PUB.G_init_calling_action);
489: END IF;
490:
491: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_ACT_COM');
492: FND_MESSAGE.Set_Token('CALLING_ACTIVITY',l_calling_activity);
493: FND_MESSAGE.Set_Token('CREDIT_CHECK_RULE',OE_Verify_Payment_PUB.G_credit_check_rule);
494:
495: l_comment := l_comment||SUBSTR(FND_MESSAGE.GET,1,2000);
488: l_calling_activity := InitCap(OE_Verify_Payment_PUB.G_init_calling_action);
489: END IF;
490:
491: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_ACT_COM');
492: FND_MESSAGE.Set_Token('CALLING_ACTIVITY',l_calling_activity);
493: FND_MESSAGE.Set_Token('CREDIT_CHECK_RULE',OE_Verify_Payment_PUB.G_credit_check_rule);
494:
495: l_comment := l_comment||SUBSTR(FND_MESSAGE.GET,1,2000);
496:
489: END IF;
490:
491: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_ACT_COM');
492: FND_MESSAGE.Set_Token('CALLING_ACTIVITY',l_calling_activity);
493: FND_MESSAGE.Set_Token('CREDIT_CHECK_RULE',OE_Verify_Payment_PUB.G_credit_check_rule);
494:
495: l_comment := l_comment||SUBSTR(FND_MESSAGE.GET,1,2000);
496:
497: --ER#7479609 end
491: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_ACT_COM');
492: FND_MESSAGE.Set_Token('CALLING_ACTIVITY',l_calling_activity);
493: FND_MESSAGE.Set_Token('CREDIT_CHECK_RULE',OE_Verify_Payment_PUB.G_credit_check_rule);
494:
495: l_comment := l_comment||SUBSTR(FND_MESSAGE.GET,1,2000);
496:
497: --ER#7479609 end
498:
499: x_comment := l_comment;
534: IF p_calling_action = 'AUTO RELEASE' THEN
535: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Order '||TO_CHAR(p_order_number)
536: ||': Credit check hold released.');
537: ELSE
538: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_REMOVED');
539: OE_MSG_PUB.Add;
540: END IF;
541: --
542: IF G_debug_flag = 'Y'
1044: ELSE
1045: l_calling_activity := InitCap(OE_Verify_Payment_PUB.G_init_calling_action);
1046: END IF;
1047:
1048: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_ACT_COM');
1049: FND_MESSAGE.Set_Token('CALLING_ACTIVITY',l_calling_activity);
1050: FND_MESSAGE.Set_Token('CREDIT_CHECK_RULE',OE_Verify_Payment_PUB.G_credit_check_rule);
1051:
1052: l_hold_release_rec.release_comment := l_hold_release_rec.release_comment||SUBSTR(FND_MESSAGE.GET,1,2000);
1045: l_calling_activity := InitCap(OE_Verify_Payment_PUB.G_init_calling_action);
1046: END IF;
1047:
1048: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_ACT_COM');
1049: FND_MESSAGE.Set_Token('CALLING_ACTIVITY',l_calling_activity);
1050: FND_MESSAGE.Set_Token('CREDIT_CHECK_RULE',OE_Verify_Payment_PUB.G_credit_check_rule);
1051:
1052: l_hold_release_rec.release_comment := l_hold_release_rec.release_comment||SUBSTR(FND_MESSAGE.GET,1,2000);
1053:
1046: END IF;
1047:
1048: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_ACT_COM');
1049: FND_MESSAGE.Set_Token('CALLING_ACTIVITY',l_calling_activity);
1050: FND_MESSAGE.Set_Token('CREDIT_CHECK_RULE',OE_Verify_Payment_PUB.G_credit_check_rule);
1051:
1052: l_hold_release_rec.release_comment := l_hold_release_rec.release_comment||SUBSTR(FND_MESSAGE.GET,1,2000);
1053:
1054: --ER#7479609 end
1048: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_ACT_COM');
1049: FND_MESSAGE.Set_Token('CALLING_ACTIVITY',l_calling_activity);
1050: FND_MESSAGE.Set_Token('CREDIT_CHECK_RULE',OE_Verify_Payment_PUB.G_credit_check_rule);
1051:
1052: l_hold_release_rec.release_comment := l_hold_release_rec.release_comment||SUBSTR(FND_MESSAGE.GET,1,2000);
1053:
1054: --ER#7479609 end
1055:
1056:
1343: END IF;
1344:
1345: x_cc_result_out := 'FAIL';
1346:
1347: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
1348: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);
1349: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
1350: FND_MESSAGE.Set_Token('CONV',
1351: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
1344:
1345: x_cc_result_out := 'FAIL';
1346:
1347: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
1348: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);
1349: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
1350: FND_MESSAGE.Set_Token('CONV',
1351: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
1352: OE_Credit_Engine_GRP.G_currency_error_msg :=
1345: x_cc_result_out := 'FAIL';
1346:
1347: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
1348: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);
1349: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
1350: FND_MESSAGE.Set_Token('CONV',
1351: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
1352: OE_Credit_Engine_GRP.G_currency_error_msg :=
1353: SUBSTR(FND_MESSAGE.GET,1,1000) ;
1346:
1347: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
1348: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);
1349: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
1350: FND_MESSAGE.Set_Token('CONV',
1351: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
1352: OE_Credit_Engine_GRP.G_currency_error_msg :=
1353: SUBSTR(FND_MESSAGE.GET,1,1000) ;
1354:
1349: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
1350: FND_MESSAGE.Set_Token('CONV',
1351: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
1352: OE_Credit_Engine_GRP.G_currency_error_msg :=
1353: SUBSTR(FND_MESSAGE.GET,1,1000) ;
1354:
1355: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
1356: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);
1357: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
1351: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
1352: OE_Credit_Engine_GRP.G_currency_error_msg :=
1353: SUBSTR(FND_MESSAGE.GET,1,1000) ;
1354:
1355: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
1356: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);
1357: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
1358: FND_MESSAGE.Set_Token('CONV',
1359: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
1352: OE_Credit_Engine_GRP.G_currency_error_msg :=
1353: SUBSTR(FND_MESSAGE.GET,1,1000) ;
1354:
1355: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
1356: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);
1357: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
1358: FND_MESSAGE.Set_Token('CONV',
1359: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
1360: OE_MSG_PUB.ADD;
1353: SUBSTR(FND_MESSAGE.GET,1,1000) ;
1354:
1355: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
1356: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);
1357: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
1358: FND_MESSAGE.Set_Token('CONV',
1359: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
1360: OE_MSG_PUB.ADD;
1361:
1354:
1355: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
1356: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);
1357: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
1358: FND_MESSAGE.Set_Token('CONV',
1359: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
1360: OE_MSG_PUB.ADD;
1361:
1362: G_result_out := 'FAIL' ;
2024: END IF;
2025: x_cc_result_out := 'FAIL';
2026:
2027:
2028: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2029: FND_MESSAGE.Set_Token('FROM',l_conversion_status(1).usage_curr_code );
2030: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
2031: FND_MESSAGE.Set_Token('CONV',
2032: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate')) ;
2025: x_cc_result_out := 'FAIL';
2026:
2027:
2028: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2029: FND_MESSAGE.Set_Token('FROM',l_conversion_status(1).usage_curr_code );
2030: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
2031: FND_MESSAGE.Set_Token('CONV',
2032: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate')) ;
2033: OE_Credit_Engine_GRP.G_currency_error_msg :=
2026:
2027:
2028: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2029: FND_MESSAGE.Set_Token('FROM',l_conversion_status(1).usage_curr_code );
2030: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
2031: FND_MESSAGE.Set_Token('CONV',
2032: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate')) ;
2033: OE_Credit_Engine_GRP.G_currency_error_msg :=
2034: SUBSTR(FND_MESSAGE.GET,1,1000) ;
2027:
2028: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2029: FND_MESSAGE.Set_Token('FROM',l_conversion_status(1).usage_curr_code );
2030: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
2031: FND_MESSAGE.Set_Token('CONV',
2032: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate')) ;
2033: OE_Credit_Engine_GRP.G_currency_error_msg :=
2034: SUBSTR(FND_MESSAGE.GET,1,1000) ;
2035:
2030: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
2031: FND_MESSAGE.Set_Token('CONV',
2032: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate')) ;
2033: OE_Credit_Engine_GRP.G_currency_error_msg :=
2034: SUBSTR(FND_MESSAGE.GET,1,1000) ;
2035:
2036: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2037: FND_MESSAGE.Set_Token('FROM',l_conversion_status(1).usage_curr_code );
2038: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
2032: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate')) ;
2033: OE_Credit_Engine_GRP.G_currency_error_msg :=
2034: SUBSTR(FND_MESSAGE.GET,1,1000) ;
2035:
2036: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2037: FND_MESSAGE.Set_Token('FROM',l_conversion_status(1).usage_curr_code );
2038: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
2039: FND_MESSAGE.Set_Token('CONV',
2040: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate')) ;
2033: OE_Credit_Engine_GRP.G_currency_error_msg :=
2034: SUBSTR(FND_MESSAGE.GET,1,1000) ;
2035:
2036: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2037: FND_MESSAGE.Set_Token('FROM',l_conversion_status(1).usage_curr_code );
2038: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
2039: FND_MESSAGE.Set_Token('CONV',
2040: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate')) ;
2041:
2034: SUBSTR(FND_MESSAGE.GET,1,1000) ;
2035:
2036: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2037: FND_MESSAGE.Set_Token('FROM',l_conversion_status(1).usage_curr_code );
2038: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
2039: FND_MESSAGE.Set_Token('CONV',
2040: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate')) ;
2041:
2042: OE_MSG_PUB.ADD;
2035:
2036: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2037: FND_MESSAGE.Set_Token('FROM',l_conversion_status(1).usage_curr_code );
2038: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
2039: FND_MESSAGE.Set_Token('CONV',
2040: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate')) ;
2041:
2042: OE_MSG_PUB.ADD;
2043:
2261: OE_DEBUG_PUB.Add('currency = '|| p_header_rec.transactional_curr_code );
2262: OE_DEBUG_PUB.Add('checking category = '|| l_check_category_id );
2263: END IF;
2264:
2265: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2266: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);
2267: FND_MESSAGE.Set_Token('TO',l_limit_curr );
2268: FND_MESSAGE.Set_Token('CONV',
2269: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate')) ;
2262: OE_DEBUG_PUB.Add('checking category = '|| l_check_category_id );
2263: END IF;
2264:
2265: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2266: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);
2267: FND_MESSAGE.Set_Token('TO',l_limit_curr );
2268: FND_MESSAGE.Set_Token('CONV',
2269: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate')) ;
2270: OE_Credit_Engine_GRP.G_currency_error_msg :=
2263: END IF;
2264:
2265: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2266: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);
2267: FND_MESSAGE.Set_Token('TO',l_limit_curr );
2268: FND_MESSAGE.Set_Token('CONV',
2269: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate')) ;
2270: OE_Credit_Engine_GRP.G_currency_error_msg :=
2271: SUBSTR(FND_MESSAGE.GET,1,1000) ;
2264:
2265: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2266: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);
2267: FND_MESSAGE.Set_Token('TO',l_limit_curr );
2268: FND_MESSAGE.Set_Token('CONV',
2269: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate')) ;
2270: OE_Credit_Engine_GRP.G_currency_error_msg :=
2271: SUBSTR(FND_MESSAGE.GET,1,1000) ;
2272:
2267: FND_MESSAGE.Set_Token('TO',l_limit_curr );
2268: FND_MESSAGE.Set_Token('CONV',
2269: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate')) ;
2270: OE_Credit_Engine_GRP.G_currency_error_msg :=
2271: SUBSTR(FND_MESSAGE.GET,1,1000) ;
2272:
2273: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2274: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);
2275: FND_MESSAGE.Set_Token('TO',l_limit_curr );
2269: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate')) ;
2270: OE_Credit_Engine_GRP.G_currency_error_msg :=
2271: SUBSTR(FND_MESSAGE.GET,1,1000) ;
2272:
2273: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2274: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);
2275: FND_MESSAGE.Set_Token('TO',l_limit_curr );
2276: FND_MESSAGE.Set_Token('CONV',
2277: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate')) ;
2270: OE_Credit_Engine_GRP.G_currency_error_msg :=
2271: SUBSTR(FND_MESSAGE.GET,1,1000) ;
2272:
2273: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2274: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);
2275: FND_MESSAGE.Set_Token('TO',l_limit_curr );
2276: FND_MESSAGE.Set_Token('CONV',
2277: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate')) ;
2278:
2271: SUBSTR(FND_MESSAGE.GET,1,1000) ;
2272:
2273: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2274: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);
2275: FND_MESSAGE.Set_Token('TO',l_limit_curr );
2276: FND_MESSAGE.Set_Token('CONV',
2277: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate')) ;
2278:
2279: OE_MSG_PUB.ADD ;
2272:
2273: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2274: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);
2275: FND_MESSAGE.Set_Token('TO',l_limit_curr );
2276: FND_MESSAGE.Set_Token('CONV',
2277: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate')) ;
2278:
2279: OE_MSG_PUB.ADD ;
2280:
3000:
3001: IF x_return_status='S'
3002: THEN
3003:
3004: FND_MESSAGE.Set_Name('ONT','OE_CC_CMGT_REVIEW');
3005: FND_MESSAGE.Set_Token('REQUEST_ID',l_request_id);
3006: OE_MSG_PUB.Add;
3007:
3008: END IF;
3001: IF x_return_status='S'
3002: THEN
3003:
3004: FND_MESSAGE.Set_Name('ONT','OE_CC_CMGT_REVIEW');
3005: FND_MESSAGE.Set_Token('REQUEST_ID',l_request_id);
3006: OE_MSG_PUB.Add;
3007:
3008: END IF;
3009: