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_VERIFY_PAYMENT_PUB dependencies on OE_MSG_PUB

Line 164: OE_MSG_PUB.ADD;

160:
161:
162: FND_MESSAGE.SET_NAME('ONT','ONT_PENDING_AUTH_HOLD_APPLIED');
163: FND_MESSAGE.SET_TOKEN('LEVEL','LINE '||l_line_ind);
164: OE_MSG_PUB.ADD;
165: IF l_debug_level > 0 THEN
166: oe_debug_pub.add( 'OEXVPPYB: Pending Payment Authorization hold has been applied on order line.', 3);
167: END IF;
168: END IF;

Line 191: OE_MSG_PUB.Count_And_Get

187: EXCEPTION
188:
189: WHEN FND_API.G_EXC_ERROR THEN
190: p_return_status := FND_API.G_RET_STS_ERROR;
191: OE_MSG_PUB.Count_And_Get
192: ( p_count => l_msg_count,
193: p_data => l_msg_data
194: );
195:

Line 198: OE_MSG_PUB.Count_And_Get

194: );
195:
196: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
197: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
198: OE_MSG_PUB.Count_And_Get
199: ( p_count => l_msg_count,
200: p_data => l_msg_data
201: );
202:

Line 213: OE_MSG_PUB.Count_And_Get

209: , 'Apply_Verify_Line_Hold'
210: );
211: END IF;
212:
213: OE_MSG_PUB.Count_And_Get
214: ( p_count => l_msg_count,
215: p_data => l_msg_data
216: );
217:

Line 474: oe_msg_pub.add;

470: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
471: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
472: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
473: fnd_message.set_name('ONT', 'OE_CC_HOLD_REMOVED');
474: oe_msg_pub.add;
475: END IF;
476:
477: END IF; -- Do nothing if the hold has already been released.
478:

Line 485: OE_MSG_PUB.Count_And_Get

481: EXCEPTION
482:
483: WHEN FND_API.G_EXC_ERROR THEN
484: p_return_status := FND_API.G_RET_STS_ERROR;
485: OE_MSG_PUB.Count_And_Get
486: ( p_count => l_msg_count,
487: p_data => l_msg_data
488: );
489:

Line 492: OE_MSG_PUB.Count_And_Get

488: );
489:
490: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
491: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
492: OE_MSG_PUB.Count_And_Get
493: ( p_count => l_msg_count,
494: p_data => l_msg_data
495: );
496:

Line 507: OE_MSG_PUB.Count_And_Get

503: , 'Release_Credit_Check_Hold'
504: );
505: END IF;
506:
507: OE_MSG_PUB.Count_And_Get
508: ( p_count => l_msg_count,
509: p_data => l_msg_data
510: );
511:

Line 644: oe_msg_pub.add;

640: l_line_number := C1.line_number;
641: fnd_message.set_name('ONT','OE_HLD_APPLIED_LINE');
642: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
643: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);
644: oe_msg_pub.add;
645:
646: END IF;
647:
648: IF l_debug_level > 0 THEN

Line 658: OE_MSG_PUB.Count_And_Get

654: EXCEPTION
655:
656: WHEN FND_API.G_EXC_ERROR THEN
657: p_return_status := FND_API.G_RET_STS_ERROR;
658: OE_MSG_PUB.Count_And_Get
659: ( p_count => l_msg_count,
660: p_data => l_msg_data
661: );
662:

Line 665: OE_MSG_PUB.Count_And_Get

661: );
662:
663: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
664: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
665: OE_MSG_PUB.Count_And_Get
666: ( p_count => l_msg_count,
667: p_data => l_msg_data
668: );
669:

Line 680: OE_MSG_PUB.Count_And_Get

676: , 'Apply_Credit_Check_Hold'
677: );
678: END IF;
679:
680: OE_MSG_PUB.Count_And_Get
681: ( p_count => l_msg_count,
682: p_data => l_msg_data
683: );
684:

Line 829: OE_MSG_PUB.Count_And_Get

825: EXCEPTION
826:
827: WHEN FND_API.G_EXC_ERROR THEN
828: p_return_status := FND_API.G_RET_STS_ERROR;
829: OE_MSG_PUB.Count_And_Get
830: ( p_count => l_msg_count,
831: p_data => l_msg_data
832: );
833:

Line 836: OE_MSG_PUB.Count_And_Get

832: );
833:
834: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
835: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
836: OE_MSG_PUB.Count_And_Get
837: ( p_count => l_msg_count,
838: p_data => l_msg_data
839: );
840:

Line 843: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

839: );
840:
841: WHEN OTHERS THEN
842: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
843: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
844: THEN
845: OE_MSG_PUB.Add_Exc_Msg
846: ( G_PKG_NAME
847: , 'Credit_Check_Line_Level'

Line 845: OE_MSG_PUB.Add_Exc_Msg

841: WHEN OTHERS THEN
842: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
843: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
844: THEN
845: OE_MSG_PUB.Add_Exc_Msg
846: ( G_PKG_NAME
847: , 'Credit_Check_Line_Level'
848: );
849: END IF;

Line 851: OE_MSG_PUB.Count_And_Get

847: , 'Credit_Check_Line_Level'
848: );
849: END IF;
850:
851: OE_MSG_PUB.Count_And_Get
852: ( p_count => l_msg_count,
853: p_data => l_msg_data
854: );
855:

Line 1182: OE_MSG_PUB.Count_And_Get( p_count => p_msg_count

1178: x_msg_data => l_msg_data,
1179: x_msg_count => l_msg_count,
1180: x_return_status => l_return_status);
1181:
1182: OE_MSG_PUB.Count_And_Get( p_count => p_msg_count
1183: ,p_data => p_msg_data
1184: );
1185:
1186: IF l_debug_level > 0 THEN

Line 1402: oe_msg_pub.add;

1398: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1400: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
1401: fnd_message.set_name('ONT', 'OE_CC_HOLD_APPLIED');
1402: oe_msg_pub.add;
1403: END IF;
1404: END IF; -- CHECK_MANUAL_RELEASED_HOLDS
1405:
1406: END IF; -- IF Result Out of Credit Checking

Line 1731: oe_msg_pub.add;

1727: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1729: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
1730: fnd_message.set_name('ONT', 'OE_CC_HOLD_APPLIED');
1731: oe_msg_pub.add;
1732: END IF;
1733: END IF; -- CHECK_MANUAL_RELEASED_HOLDS
1734:
1735: END IF; -- IF Result Out of Credit Checking

Line 1760: OE_MSG_PUB.Count_And_Get( p_count => p_msg_count

1756: END IF; -- IF Electronic Payment
1757:
1758: END IF; -- if multiple payments is enabled.
1759:
1760: OE_MSG_PUB.Count_And_Get( p_count => p_msg_count
1761: , p_data => p_msg_data
1762: );
1763:
1764: EXCEPTION

Line 1768: OE_MSG_PUB.Count_And_Get

1764: EXCEPTION
1765:
1766: WHEN FND_API.G_EXC_ERROR THEN
1767: p_return_status := FND_API.G_RET_STS_ERROR;
1768: OE_MSG_PUB.Count_And_Get
1769: ( p_count => l_msg_count,
1770: p_data => l_msg_data
1771: );
1772:

Line 1775: OE_MSG_PUB.Count_And_Get

1771: );
1772:
1773: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1774: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1775: OE_MSG_PUB.Count_And_Get
1776: ( p_count => l_msg_count,
1777: p_data => l_msg_data
1778: );
1779:

Line 1782: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1778: );
1779:
1780: WHEN OTHERS THEN
1781: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1782: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1783: THEN
1784: OE_MSG_PUB.Add_Exc_Msg
1785: ( G_PKG_NAME
1786: , 'Verify_Payment'

Line 1784: OE_MSG_PUB.Add_Exc_Msg

1780: WHEN OTHERS THEN
1781: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1782: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1783: THEN
1784: OE_MSG_PUB.Add_Exc_Msg
1785: ( G_PKG_NAME
1786: , 'Verify_Payment'
1787: );
1788: END IF;

Line 1790: OE_MSG_PUB.Count_And_Get

1786: , 'Verify_Payment'
1787: );
1788: END IF;
1789:
1790: OE_MSG_PUB.Count_And_Get
1791: ( p_count => l_msg_count,
1792: p_data => l_msg_data
1793: );
1794:

Line 2187: OE_MSG_PUB.Count_And_Get

2183: , 'Hold_Exists'
2184: );
2185: END IF;
2186:
2187: OE_MSG_PUB.Count_And_Get
2188: ( p_count => l_msg_count,
2189: p_data => l_msg_data
2190: );
2191:

Line 2416: oe_msg_pub.add;

2412: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2414: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
2415: fnd_message.set_name('ONT', 'OE_CC_HOLD_REMOVED');
2416: oe_msg_pub.add;
2417: END IF;
2418:
2419: END IF; -- Do nothing if the hold has already been released.
2420:

Line 2427: OE_MSG_PUB.Count_And_Get

2423: EXCEPTION
2424:
2425: WHEN FND_API.G_EXC_ERROR THEN
2426: p_return_status := FND_API.G_RET_STS_ERROR;
2427: OE_MSG_PUB.Count_And_Get
2428: ( p_count => l_msg_count,
2429: p_data => l_msg_data
2430: );
2431:

Line 2434: OE_MSG_PUB.Count_And_Get

2430: );
2431:
2432: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2433: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2434: OE_MSG_PUB.Count_And_Get
2435: ( p_count => l_msg_count,
2436: p_data => l_msg_data
2437: );
2438:

Line 2449: OE_MSG_PUB.Count_And_Get

2445: , 'Release_Verify_Hold'
2446: );
2447: END IF;
2448:
2449: OE_MSG_PUB.Count_And_Get
2450: ( p_count => l_msg_count,
2451: p_data => l_msg_data
2452: );
2453:

Line 2536: OE_MSG_PUB.ADD;

2532: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2533: IF p_hold_id = 16 THEN
2534: FND_MESSAGE.SET_NAME('ONT','ONT_PENDING_AUTH_HOLD_APPLIED');
2535: FND_MESSAGE.SET_TOKEN('LEVEL','ORDER');
2536: OE_MSG_PUB.ADD;
2537: IF l_debug_level > 0 THEN
2538: oe_debug_pub.add( 'OEXVPPYB: Pending Payment Authorization hold has been applied on order.', 3);
2539: END IF;
2540: END IF;

Line 2555: OE_MSG_PUB.Count_And_Get

2551: EXCEPTION
2552:
2553: WHEN FND_API.G_EXC_ERROR THEN
2554: p_return_status := FND_API.G_RET_STS_ERROR;
2555: OE_MSG_PUB.Count_And_Get
2556: ( p_count => l_msg_count,
2557: p_data => l_msg_data
2558: );
2559:

Line 2562: OE_MSG_PUB.Count_And_Get

2558: );
2559:
2560: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2561: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2562: OE_MSG_PUB.Count_And_Get
2563: ( p_count => l_msg_count,
2564: p_data => l_msg_data
2565: );
2566:

Line 2577: OE_MSG_PUB.Count_And_Get

2573: , 'Apply_Verify_Hold'
2574: );
2575: END IF;
2576:
2577: OE_MSG_PUB.Count_And_Get
2578: ( p_count => l_msg_count,
2579: p_data => l_msg_data
2580: );
2581:

Line 2668: OE_MSG_PUB.ADD;

2664: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2665: IF p_hold_id = 16 THEN
2666: FND_MESSAGE.SET_NAME('ONT','ONT_PENDING_AUTH_HOLD_APPLIED');
2667: FND_MESSAGE.SET_TOKEN('LEVEL','ORDER');
2668: OE_MSG_PUB.ADD;
2669: IF l_debug_level > 0 THEN
2670: oe_debug_pub.add( 'OEXVPPYB: Pending Payment Authorization hold has been applied on order.', 3);
2671: END IF;
2672: END IF;

Line 2695: OE_MSG_PUB.Count_And_Get

2691: EXCEPTION
2692:
2693: WHEN FND_API.G_EXC_ERROR THEN
2694: p_return_status := FND_API.G_RET_STS_ERROR;
2695: OE_MSG_PUB.Count_And_Get
2696: ( p_count => l_msg_count,
2697: p_data => l_msg_data
2698: );
2699:

Line 2702: OE_MSG_PUB.Count_And_Get

2698: );
2699:
2700: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2701: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2702: OE_MSG_PUB.Count_And_Get
2703: ( p_count => l_msg_count,
2704: p_data => l_msg_data
2705: );
2706:

Line 2717: OE_MSG_PUB.Count_And_Get

2713: , 'Apply_Verify_Hold_and_Commit'
2714: );
2715: END IF;
2716:
2717: OE_MSG_PUB.Count_And_Get
2718: ( p_count => l_msg_count,
2719: p_data => l_msg_data
2720: );
2721:

Line 2913: OE_MSG_PUB.Count_And_Get

2909:
2910: WHEN FND_API.G_EXC_ERROR THEN
2911: p_result_out := 'FAIL';
2912: p_return_status := FND_API.G_RET_STS_ERROR;
2913: OE_MSG_PUB.Count_And_Get
2914: ( p_count => l_msg_count,
2915: p_data => l_msg_data
2916: );
2917:

Line 2921: OE_MSG_PUB.Count_And_Get

2917:
2918: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2919: p_result_out := 'FAIL';
2920: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2921: OE_MSG_PUB.Count_And_Get
2922: ( p_count => l_msg_count,
2923: p_data => l_msg_data
2924: );
2925:

Line 2937: OE_MSG_PUB.Count_And_Get

2933: , 'Payment_Request'
2934: );
2935: END IF;
2936:
2937: OE_MSG_PUB.Count_And_Get
2938: ( p_count => l_msg_count,
2939: p_data => l_msg_data
2940: );
2941:

Line 3373: OE_MSG_PUB.ADD;

3369: IF l_payee_id is NULL THEN
3370:
3371: -- Message "Unable to retrieve Payee/Merchant ID for Customer's Primary Payment Method"
3372: FND_MESSAGE.SET_NAME('ONT','OE_VPM_NO_PAYEE_ID');
3373: OE_MSG_PUB.ADD;
3374: p_result_out := 'FAIL' ;
3375: RETURN;
3376:
3377: END IF;

Line 3383: OE_MSG_PUB.ADD;

3379: ELSE -- Method ID is invalid
3380:
3381: -- Message "Unable to retrieve Primary Payment Method for the customer"
3382: FND_MESSAGE.SET_NAME('ONT','OE_VPM_NO_PAY_METHOD');
3383: OE_MSG_PUB.ADD;
3384: p_result_out := 'FAIL' ;
3385: RETURN;
3386:
3387: END IF;

Line 3473: OE_MSG_PUB.ADD;

3469: ) ;
3470: EXCEPTION
3471: WHEN OTHERS THEN
3472: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET');
3473: OE_MSG_PUB.ADD;
3474: IF l_debug_level > 0 THEN
3475: oe_debug_pub.add( 'OEXPVPMB: ERROR IN ARP_BANK_PKG.PROCESS_CUST_BANK_ACCOUNT' ) ;
3476: END IF;
3477: p_result_out := 'FAIL';

Line 3781: OE_MSG_PUB.ADD;

3777: FND_MESSAGE.SET_TOKEN('ERRMESSAGE',l_err_mesg);
3778: FND_MESSAGE.SET_TOKEN('ERRLOCATION',l_err_loc);
3779: FND_MESSAGE.SET_TOKEN('BEPERRCODE',l_bep_err_code);
3780: FND_MESSAGE.SET_TOKEN('BEPERRMESSAGE',l_bep_err_mesg);
3781: OE_MSG_PUB.ADD;
3782:
3783: IF l_debug_level > 0 THEN
3784: oe_debug_pub.add( 'OEXPVPMB: ERROR CODE : '||L_ERR_CODE ) ;
3785: END IF;

Line 3881: OE_MSG_PUB.Count_And_Get

3877: , 'Authorize_Payment'
3878: );
3879: END IF;
3880:
3881: OE_MSG_PUB.Count_And_Get
3882: ( p_count => l_msg_count,
3883: p_data => l_msg_data
3884: );
3885:

Line 4107: OE_MSG_PUB.ADD;

4103:
4104: -- Check For all Required Attributes
4105: IF p_header_rec.invoice_to_org_id is NULL THEN
4106: FND_MESSAGE.SET_NAME('ONT','OE_VPM_INV_TO_REQUIRED');
4107: OE_MSG_PUB.ADD;
4108: IF l_debug_level > 0 THEN
4109: oe_debug_pub.add( 'OEXPVPMB: INVOICE_TO_ORG_ID IS REQUIRED' ) ;
4110: END IF;
4111: l_result := FALSE;

Line 4115: OE_MSG_PUB.ADD;

4111: l_result := FALSE;
4112: ELSIF p_header_rec.credit_card_number is NULL THEN
4113: --R12 CC Encryption
4114: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_NUM_REQUIRED');
4115: OE_MSG_PUB.ADD;
4116: IF l_debug_level > 0 THEN
4117: oe_debug_pub.add( 'OEXPVPMB: CREDIT_CARD_NUMBER IS REQUIRED' ) ;
4118: END IF;
4119: l_result := FALSE;

Line 4122: OE_MSG_PUB.ADD;

4118: END IF;
4119: l_result := FALSE;
4120: ELSIF p_header_rec.credit_card_expiration_date is NULL THEN
4121: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_EXP_DT_REQUIRED');
4122: OE_MSG_PUB.ADD;
4123: IF l_debug_level > 0 THEN
4124: oe_debug_pub.add( 'OEXPVPMB: CREDIT_CARD_EXPIRATION_DATE IS REQUIRED' ) ;
4125: END IF;
4126: l_result := FALSE;

Line 4129: OE_MSG_PUB.ADD;

4125: END IF;
4126: l_result := FALSE;
4127: ELSIF p_header_rec.credit_card_holder_name is NULL THEN
4128: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_HOLDER_REQUIRED');
4129: OE_MSG_PUB.ADD;
4130: IF l_debug_level > 0 THEN
4131: oe_debug_pub.add( 'OEXPVPMB: CREDIT_CARD_HOLDER_NAME IS REQUIRED' ) ;
4132: END IF;
4133: l_result := FALSE;

Line 4454: OE_MSG_PUB.ADD;

4450: FND_MESSAGE.SET_TOKEN('ERRMESSAGE',l_err_mesg);
4451: FND_MESSAGE.SET_TOKEN('ERRLOCATION',l_err_loc);
4452: FND_MESSAGE.SET_TOKEN('BEPERRCODE',l_bep_err_code);
4453: FND_MESSAGE.SET_TOKEN('BEPERRMESSAGE',l_bep_err_mesg);
4454: OE_MSG_PUB.ADD;
4455:
4456: IF l_debug_level > 0 THEN
4457: oe_debug_pub.add( 'OEXPVPMB: ERROR CODE : '||L_ERR_CODE ) ;
4458: END IF;

Line 4483: OE_MSG_PUB.Count_And_Get

4479: EXCEPTION
4480:
4481: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4482: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4483: OE_MSG_PUB.Count_And_Get
4484: ( p_count => l_msg_count,
4485: p_data => l_msg_data
4486: );
4487:

Line 4498: OE_MSG_PUB.Count_And_Get

4494: , 'Void_Payment'
4495: );
4496: END IF;
4497:
4498: OE_MSG_PUB.Count_And_Get
4499: ( p_count => l_msg_count,
4500: p_data => l_msg_data
4501: );
4502:

Line 5099: OE_MSG_PUB.Count_And_Get

5095:
5096: WHEN FND_API.G_EXC_ERROR THEN
5097: ROLLBACK TO Update_Authorization_Info;
5098: p_return_status := FND_API.G_RET_STS_ERROR;
5099: OE_MSG_PUB.Count_And_Get
5100: ( p_count => l_msg_count,
5101: p_data => l_msg_data
5102: );
5103:

Line 5107: OE_MSG_PUB.Count_And_Get

5103:
5104: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5105: ROLLBACK TO Update_Authorization_Info;
5106: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5107: OE_MSG_PUB.Count_And_Get
5108: ( p_count => l_msg_count,
5109: p_data => l_msg_data
5110: );
5111:

Line 5124: OE_MSG_PUB.Count_And_Get

5120: , 'Update_Authorization_Info'
5121: );
5122: END IF;
5123:
5124: OE_MSG_PUB.Count_And_Get
5125: ( p_count => l_msg_count,
5126: p_data => l_msg_data
5127: );
5128:

Line 5890: OE_MSG_PUB.ADD;

5886: /* IF l_payee_id is NULL THEN
5887: -- Message "Unable to retrieve Payee/Merchant ID
5888: -- for Customer's Primary Payment Method"
5889: FND_MESSAGE.SET_NAME('ONT','OE_VPM_NO_PAYEE_ID');
5890: OE_MSG_PUB.ADD;
5891: l_result_status := 'FAIL' ;
5892: goto Update_Verify_Hold;
5893: -- RETURN;
5894: END IF; */

Line 5899: OE_MSG_PUB.ADD;

5895: ELSE -- Method ID is invalid
5896:
5897: -- Message "Unable to retrieve Primary Payment Method for the customer"
5898: FND_MESSAGE.SET_NAME('ONT','OE_VPM_NO_PAY_METHOD');
5899: OE_MSG_PUB.ADD;
5900: l_result_status := 'FAIL' ;
5901: goto Update_Verify_Hold;
5902: -- RETURN;
5903: END IF;

Line 5985: OE_MSG_PUB.ADD;

5981: END IF;
5982:
5983: IF l_invoice_to_org_id is NULL THEN
5984: FND_MESSAGE.SET_NAME('ONT','OE_VPM_INV_TO_REQUIRED');
5985: OE_MSG_PUB.ADD;
5986: IF l_debug_level > 0 THEN
5987: oe_debug_pub.add( 'OEXPVPMB: INVOICE_TO_ORG_ID IS REQUIRED' ) ;
5988: END IF;
5989: l_result_status := 'FAIL';

Line 5994: OE_MSG_PUB.ADD;

5990: goto Update_Verify_Hold;
5991: -- return;
5992: ELSIF l_payments_tbl(I).trxn_extension_id is NULL THEN --R12 CC Encryption
5993: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_NUM_REQUIRED');
5994: OE_MSG_PUB.ADD;
5995: IF l_debug_level > 0 THEN
5996: oe_debug_pub.add( 'OEXPVPMB: CREDIT_CARD_NUMBER IS REQUIRED' ) ;
5997: END IF;
5998: l_result_status := 'FAIL';

Line 6006: OE_MSG_PUB.ADD;

6002:
6003: /*
6004: ELSIF l_payments_tbl(I).credit_card_expiration_date is NULL THEN
6005: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_EXP_DT_REQUIRED');
6006: OE_MSG_PUB.ADD;
6007: IF l_debug_level > 0 THEN
6008: oe_debug_pub.add( 'OEXPVPMB: CREDIT_CARD_EXPIRATION_DATE IS REQUIRED' ) ;
6009: END IF;
6010: l_result_status := 'FAIL';

Line 6015: OE_MSG_PUB.ADD;

6011: goto Update_Verify_Hold;
6012: -- return;
6013: ELSIF l_payments_tbl(I).credit_card_holder_name is NULL THEN
6014: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_HOLDER_REQUIRED');
6015: OE_MSG_PUB.ADD;
6016: IF l_debug_level > 0 THEN
6017: oe_debug_pub.add( 'OEXPVPMB: CREDIT_CARD_HOLDER_NAME IS REQUIRED' ) ;
6018: END IF;
6019: l_result_status := 'FAIL';

Line 6293: OE_MSG_PUB.ADD;

6289: END IF;
6290: END IF; -- line id is not null
6291:
6292: FND_MESSAGE.SET_NAME('ONT','ONT_CC_RISK_HOLD_APPLIED');
6293: OE_MSG_PUB.ADD;
6294: RETURN;
6295:
6296: oe_debug_pub.add('after commented message');
6297: /*comm rej ELSE

Line 6303: OE_MSG_PUB.ADD;

6299: oe_debug_pub.add('Risk validation failed...!');
6300: END IF;
6301: -- the value is reject, then
6302: FND_MESSAGE.SET_NAME('ONT','ONT_RISK_VALIDATION_FAILED');
6303: OE_MSG_PUB.ADD;
6304: RAISE FND_API.G_EXC_ERROR;
6305: END IF; --Reject flag
6306: comm rej */
6307: END IF; -- risk score > threshold

Line 6317: OE_MSG_PUB.ADD;

6313: END IF;
6314: FND_MESSAGE.SET_NAME('ONT','ONT_PAYMENT_REV_REAUTH_SUCCESS');
6315: FND_MESSAGE.SET_TOKEN('OLD_AMOUNT',TO_CHAR(l_authorized_amt,l_format_mask));
6316: FND_MESSAGE.SET_TOKEN('NEW_AMOUNT',TO_CHAR(l_amount_to_authorize,l_format_mask));
6317: OE_MSG_PUB.ADD;
6318: ELSE
6319: --CC Reversal ER#16014135 End
6320: oe_debug_pub.add('before uncommented message');
6321: FND_MESSAGE.SET_NAME('ONT','ONT_PAYMENT_AUTH_SUCCESS');

Line 6323: OE_MSG_PUB.ADD;

6319: --CC Reversal ER#16014135 End
6320: oe_debug_pub.add('before uncommented message');
6321: FND_MESSAGE.SET_NAME('ONT','ONT_PAYMENT_AUTH_SUCCESS');
6322: FND_MESSAGE.SET_TOKEN('AMOUNT',TO_CHAR(l_amount_to_authorize,l_format_mask));
6323: OE_MSG_PUB.ADD;
6324: --CC Reversal ER#16014135 Start
6325: END IF;
6326: --CC Reversal ER#16014135 End
6327: oe_debug_pub.add('after uncommented message');

Line 6439: OE_MSG_PUB.ADD;

6435: END IF;
6436: END IF; -- line id is not null
6437:
6438: FND_MESSAGE.SET_NAME('ONT','ONT_CC_SECURITY_CODE_FAILED');
6439: OE_MSG_PUB.ADD;
6440: RETURN;
6441: --bug 4767915
6442: /* ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS AND
6443: l_response.result_code = 'RISK_THRESHOLD_EXCEEDED' THEN

Line 6498: OE_MSG_PUB.ADD;

6494: END IF;
6495: END IF; -- line id is not null
6496:
6497: FND_MESSAGE.SET_NAME('ONT','ONT_CC_RISK_HOLD_APPLIED');
6498: OE_MSG_PUB.ADD;
6499: RETURN;
6500: END IF;*/
6501: ELSE
6502: /*

Line 6530: --oe_msg_pub.add_text(p_message_text => l_response.result_message); --CC Reversal ER#16014135 Commented

6526: --CC Reversal ER#16014135 End
6527: l_result_status := 'FAIL';
6528:
6529: -- add messages to message stack.
6530: --oe_msg_pub.add_text(p_message_text => l_response.result_message); --CC Reversal ER#16014135 Commented
6531: --CC Reversal ER#16014135 Start
6532: IF l_reauthorize_flag = 'R' THEN
6533: IF l_debug_level > 0 THEN
6534: oe_msg_pub.add_text(p_message_text => l_response.result_message);

Line 6534: oe_msg_pub.add_text(p_message_text => l_response.result_message);

6530: --oe_msg_pub.add_text(p_message_text => l_response.result_message); --CC Reversal ER#16014135 Commented
6531: --CC Reversal ER#16014135 Start
6532: IF l_reauthorize_flag = 'R' THEN
6533: IF l_debug_level > 0 THEN
6534: oe_msg_pub.add_text(p_message_text => l_response.result_message);
6535: END IF;
6536: ELSE
6537: IF l_debug_level > 0 THEN
6538: oe_msg_pub.add_text(p_message_text => l_reauth_response.result_message);

Line 6538: oe_msg_pub.add_text(p_message_text => l_reauth_response.result_message);

6534: oe_msg_pub.add_text(p_message_text => l_response.result_message);
6535: END IF;
6536: ELSE
6537: IF l_debug_level > 0 THEN
6538: oe_msg_pub.add_text(p_message_text => l_reauth_response.result_message);
6539: END IF;
6540: END IF;
6541: --CC Reversal ER#16014135 End
6542: -- apply credit card authorization hold in case of auth failure.

Line 6590: OE_MSG_PUB.ADD;

6586: END IF;
6587:
6588: FND_MESSAGE.SET_NAME('ONT','ONT_CC_AUTH_HOLD_APPLIED');
6589: FND_MESSAGE.SET_TOKEN('AMOUNT',TO_CHAR(l_amount_to_authorize,l_format_mask));
6590: OE_MSG_PUB.ADD;
6591:
6592: /*comm rej ELSE
6593: -- the value is to reject on failure, then
6594: -- raise error so the transaction will fail

Line 6596: OE_MSG_PUB.ADD;

6592: /*comm rej ELSE
6593: -- the value is to reject on failure, then
6594: -- raise error so the transaction will fail
6595: FND_MESSAGE.SET_NAME('ONT',' ONT_CC_AUTH_FAILED'); FND_MESSAGE.SET_TOKEN('AMOUNT',TO_CHAR(l_amount_to_authorize,l_format_mask));
6596: OE_MSG_PUB.ADD;
6597: RAISE FND_API.G_EXC_ERROR;
6598: END IF;
6599: comm rej*/
6600: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 6621: OE_MSG_PUB.ADD;*/

6617:
6618: --bug3511992 start
6619: FND_MESSAGE.SET_NAME('ONT','ONT_PAYMENT_AUTH_SUCCESS');
6620: FND_MESSAGE.SET_TOKEN('AMOUNT',TO_CHAR(l_amount_to_authorize,l_format_mask)); --Format mask for bug 3571485
6621: OE_MSG_PUB.ADD;*/
6622: --bug3511992 end
6623:
6624: <>
6625: -- Update Payment Amount and Authorization Code and DATE

Line 6834: OE_MSG_PUB.Count_And_Get

6830: END IF;
6831: END IF;
6832: --CC Reversal ER#16014135 End
6833: p_return_status := FND_API.G_RET_STS_ERROR;
6834: OE_MSG_PUB.Count_And_Get
6835: ( p_count => l_msg_count,
6836: p_data => l_msg_data
6837: );
6838:

Line 6867: OE_MSG_PUB.Count_And_Get

6863: END IF;
6864: END IF;
6865: --CC Reversal ER#16014135 End
6866: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6867: OE_MSG_PUB.Count_And_Get
6868: ( p_count => l_msg_count,
6869: p_data => l_msg_data
6870: );
6871:

Line 6887: OE_MSG_PUB.Count_And_Get

6883: , 'Authorize_Payment'
6884: );
6885: END IF;
6886:
6887: OE_MSG_PUB.Count_And_Get
6888: ( p_count => l_msg_count,
6889: p_data => l_msg_data
6890: );
6891:

Line 7287: OE_MSG_PUB.Count_And_Get

7283: oe_debug_pub.add('After call to Reverse_CreditCard_Auth'||l_return_status,5);
7284: oe_debug_pub.add('Error'||sqlerrm,5);
7285: END IF;
7286: l_return_status := FND_API.G_RET_STS_ERROR;
7287: OE_MSG_PUB.Count_And_Get
7288: ( p_count => l_msg_count,
7289: p_data => l_msg_data
7290: );
7291: RAISE FND_API.G_EXC_ERROR;

Line 7293: OE_MSG_PUB.Count_And_Get

7289: p_data => l_msg_data
7290: );
7291: RAISE FND_API.G_EXC_ERROR;
7292: WHEN OTHERS THEN
7293: OE_MSG_PUB.Count_And_Get
7294: ( p_count => l_msg_count,
7295: p_data => l_msg_data
7296: );
7297: IF l_debug_level > 0 THEN

Line 7328: OE_MSG_PUB.Count_And_Get

7324: , 'Check_ReAuth_for_MultiPmnts'
7325: );
7326: END IF;
7327:
7328: OE_MSG_PUB.Count_And_Get
7329: ( p_count => x_msg_count,
7330: p_data => x_msg_data
7331: );
7332:

Line 8308: OE_MSG_PUB.Count_And_Get

8304:
8305: WHEN FND_API.G_EXC_ERROR THEN
8306: ROLLBACK TO Update_AuthInfo_for_MultiPmnts;
8307: p_return_status := FND_API.G_RET_STS_ERROR;
8308: OE_MSG_PUB.Count_And_Get
8309: ( p_count => l_msg_count,
8310: p_data => l_msg_data
8311: );
8312:

Line 8316: OE_MSG_PUB.Count_And_Get

8312:
8313: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8314: ROLLBACK TO Update_AuthInfo_for_MultiPmnts;
8315: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8316: OE_MSG_PUB.Count_And_Get
8317: ( p_count => l_msg_count,
8318: p_data => l_msg_data
8319: );
8320:

Line 8333: OE_MSG_PUB.Count_And_Get

8329: , 'Update_AuthInfo_for_MultiPmnts'
8330: );
8331: END IF;
8332:
8333: OE_MSG_PUB.Count_And_Get
8334: ( p_count => l_msg_count,
8335: p_data => l_msg_data
8336: );
8337:

Line 8543: OE_MSG_PUB.Count_And_Get

8539: EXCEPTION
8540:
8541: WHEN FND_API.G_EXC_ERROR THEN
8542: p_return_status := FND_API.G_RET_STS_ERROR;
8543: OE_MSG_PUB.Count_And_Get
8544: ( p_count => l_msg_count,
8545: p_data => l_msg_data
8546: );
8547:

Line 8550: OE_MSG_PUB.Count_And_Get

8546: );
8547:
8548: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8549: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8550: OE_MSG_PUB.Count_And_Get
8551: ( p_count => l_msg_count,
8552: p_data => l_msg_data
8553: );
8554:

Line 8565: OE_MSG_PUB.Count_And_Get

8561: , 'Release_Verify_Line_Hold'
8562: );
8563: END IF;
8564:
8565: OE_MSG_PUB.Count_And_Get
8566: ( p_count => l_msg_count,
8567: p_data => l_msg_data
8568: );
8569:

Line 8688: OE_MSG_PUB.ADD;

8684:
8685:
8686: FND_MESSAGE.SET_NAME('ONT','ONT_PENDING_AUTH_HOLD_APPLIED');
8687: FND_MESSAGE.SET_TOKEN('LEVEL','LINE '||l_line_ind);
8688: OE_MSG_PUB.ADD;
8689: IF l_debug_level > 0 THEN
8690: oe_debug_pub.add( 'OEXVPPYB: Pending Payment Authorization hold has been applied on order line.', 3);
8691: END IF;
8692: END IF;

Line 8707: OE_MSG_PUB.Count_And_Get

8703: EXCEPTION
8704:
8705: WHEN FND_API.G_EXC_ERROR THEN
8706: p_return_status := FND_API.G_RET_STS_ERROR;
8707: OE_MSG_PUB.Count_And_Get
8708: ( p_count => l_msg_count,
8709: p_data => l_msg_data
8710: );
8711:

Line 8714: OE_MSG_PUB.Count_And_Get

8710: );
8711:
8712: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8713: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8714: OE_MSG_PUB.Count_And_Get
8715: ( p_count => l_msg_count,
8716: p_data => l_msg_data
8717: );
8718:

Line 8729: OE_MSG_PUB.Count_And_Get

8725: , 'Apply_Verify_Line_Hold'
8726: );
8727: END IF;
8728:
8729: OE_MSG_PUB.Count_And_Get
8730: ( p_count => l_msg_count,
8731: p_data => l_msg_data
8732: );
8733:

Line 8912: OE_Msg_Pub.Add;

8908: NOT OE_GLOBALS.Equal(p_instrument_security_code,FND_API.G_MISS_CHAR) THEN
8909: l_trxn_attribs.Instrument_Security_Code := p_instrument_security_code;
8910: ELSE
8911: FND_MESSAGE.SET_NAME('ONT','OE_CC_SECURITY_CODE_REQD');
8912: OE_Msg_Pub.Add;
8913: RAISE FND_API.G_EXC_ERROR;
8914: END IF;
8915: END IF;
8916: --bug 5028932

Line 8969: OE_MSG_PUB.Count_And_Get

8965:
8966: WHEN FND_API.G_EXC_ERROR THEN
8967:
8968: X_return_status := FND_API.G_RET_STS_ERROR;
8969: OE_MSG_PUB.Count_And_Get
8970: ( p_count => l_msg_count,
8971: p_data => l_msg_data
8972: );
8973: RAISE FND_API.G_EXC_ERROR;

Line 8978: OE_MSG_PUB.Count_And_Get

8974:
8975: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8976:
8977: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8978: OE_MSG_PUB.Count_And_Get
8979: ( p_count => l_msg_count,
8980: p_data => l_msg_data
8981: );
8982: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8995: OE_MSG_PUB.Count_And_Get

8991: , 'OE_Verify_Payment_PUB'
8992: );
8993: END IF;
8994:
8995: OE_MSG_PUB.Count_And_Get
8996: ( p_count => l_msg_count,
8997: p_data => l_msg_data
8998: );
8999: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;