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 163: OE_MSG_PUB.ADD;

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

Line 190: OE_MSG_PUB.Count_And_Get

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

Line 197: OE_MSG_PUB.Count_And_Get

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

Line 212: OE_MSG_PUB.Count_And_Get

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

Line 408: oe_msg_pub.add;

404: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
406: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
407: fnd_message.set_name('ONT', 'OE_CC_HOLD_REMOVED');
408: oe_msg_pub.add;
409: END IF;
410:
411: END IF; -- Do nothing if the hold has already been released.
412:

Line 419: OE_MSG_PUB.Count_And_Get

415: EXCEPTION
416:
417: WHEN FND_API.G_EXC_ERROR THEN
418: p_return_status := FND_API.G_RET_STS_ERROR;
419: OE_MSG_PUB.Count_And_Get
420: ( p_count => l_msg_count,
421: p_data => l_msg_data
422: );
423:

Line 426: OE_MSG_PUB.Count_And_Get

422: );
423:
424: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
425: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
426: OE_MSG_PUB.Count_And_Get
427: ( p_count => l_msg_count,
428: p_data => l_msg_data
429: );
430:

Line 441: OE_MSG_PUB.Count_And_Get

437: , 'Release_Credit_Check_Hold'
438: );
439: END IF;
440:
441: OE_MSG_PUB.Count_And_Get
442: ( p_count => l_msg_count,
443: p_data => l_msg_data
444: );
445:

Line 578: oe_msg_pub.add;

574: l_line_number := C1.line_number;
575: fnd_message.set_name('ONT','OE_HLD_APPLIED_LINE');
576: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
577: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);
578: oe_msg_pub.add;
579:
580: END IF;
581:
582: IF l_debug_level > 0 THEN

Line 592: OE_MSG_PUB.Count_And_Get

588: EXCEPTION
589:
590: WHEN FND_API.G_EXC_ERROR THEN
591: p_return_status := FND_API.G_RET_STS_ERROR;
592: OE_MSG_PUB.Count_And_Get
593: ( p_count => l_msg_count,
594: p_data => l_msg_data
595: );
596:

Line 599: OE_MSG_PUB.Count_And_Get

595: );
596:
597: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
598: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
599: OE_MSG_PUB.Count_And_Get
600: ( p_count => l_msg_count,
601: p_data => l_msg_data
602: );
603:

Line 614: OE_MSG_PUB.Count_And_Get

610: , 'Apply_Credit_Check_Hold'
611: );
612: END IF;
613:
614: OE_MSG_PUB.Count_And_Get
615: ( p_count => l_msg_count,
616: p_data => l_msg_data
617: );
618:

Line 763: OE_MSG_PUB.Count_And_Get

759: EXCEPTION
760:
761: WHEN FND_API.G_EXC_ERROR THEN
762: p_return_status := FND_API.G_RET_STS_ERROR;
763: OE_MSG_PUB.Count_And_Get
764: ( p_count => l_msg_count,
765: p_data => l_msg_data
766: );
767:

Line 770: OE_MSG_PUB.Count_And_Get

766: );
767:
768: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
769: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
770: OE_MSG_PUB.Count_And_Get
771: ( p_count => l_msg_count,
772: p_data => l_msg_data
773: );
774:

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

773: );
774:
775: WHEN OTHERS THEN
776: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
777: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
778: THEN
779: OE_MSG_PUB.Add_Exc_Msg
780: ( G_PKG_NAME
781: , 'Credit_Check_Line_Level'

Line 779: OE_MSG_PUB.Add_Exc_Msg

775: WHEN OTHERS THEN
776: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
777: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
778: THEN
779: OE_MSG_PUB.Add_Exc_Msg
780: ( G_PKG_NAME
781: , 'Credit_Check_Line_Level'
782: );
783: END IF;

Line 785: OE_MSG_PUB.Count_And_Get

781: , 'Credit_Check_Line_Level'
782: );
783: END IF;
784:
785: OE_MSG_PUB.Count_And_Get
786: ( p_count => l_msg_count,
787: p_data => l_msg_data
788: );
789:

Line 1110: OE_MSG_PUB.Count_And_Get( p_count => p_msg_count

1106: x_msg_data => l_msg_data,
1107: x_msg_count => l_msg_count,
1108: x_return_status => l_return_status);
1109:
1110: OE_MSG_PUB.Count_And_Get( p_count => p_msg_count
1111: ,p_data => p_msg_data
1112: );
1113:
1114: IF l_debug_level > 0 THEN

Line 1330: oe_msg_pub.add;

1326: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1328: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
1329: fnd_message.set_name('ONT', 'OE_CC_HOLD_APPLIED');
1330: oe_msg_pub.add;
1331: END IF;
1332: END IF; -- CHECK_MANUAL_RELEASED_HOLDS
1333:
1334: END IF; -- IF Result Out of Credit Checking

Line 1659: oe_msg_pub.add;

1655: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1656: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1657: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
1658: fnd_message.set_name('ONT', 'OE_CC_HOLD_APPLIED');
1659: oe_msg_pub.add;
1660: END IF;
1661: END IF; -- CHECK_MANUAL_RELEASED_HOLDS
1662:
1663: END IF; -- IF Result Out of Credit Checking

Line 1688: OE_MSG_PUB.Count_And_Get( p_count => p_msg_count

1684: END IF; -- IF Electronic Payment
1685:
1686: END IF; -- if multiple payments is enabled.
1687:
1688: OE_MSG_PUB.Count_And_Get( p_count => p_msg_count
1689: , p_data => p_msg_data
1690: );
1691:
1692: EXCEPTION

Line 1696: OE_MSG_PUB.Count_And_Get

1692: EXCEPTION
1693:
1694: WHEN FND_API.G_EXC_ERROR THEN
1695: p_return_status := FND_API.G_RET_STS_ERROR;
1696: OE_MSG_PUB.Count_And_Get
1697: ( p_count => l_msg_count,
1698: p_data => l_msg_data
1699: );
1700:

Line 1703: OE_MSG_PUB.Count_And_Get

1699: );
1700:
1701: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1702: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1703: OE_MSG_PUB.Count_And_Get
1704: ( p_count => l_msg_count,
1705: p_data => l_msg_data
1706: );
1707:

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

1706: );
1707:
1708: WHEN OTHERS THEN
1709: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1710: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1711: THEN
1712: OE_MSG_PUB.Add_Exc_Msg
1713: ( G_PKG_NAME
1714: , 'Verify_Payment'

Line 1712: OE_MSG_PUB.Add_Exc_Msg

1708: WHEN OTHERS THEN
1709: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1710: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1711: THEN
1712: OE_MSG_PUB.Add_Exc_Msg
1713: ( G_PKG_NAME
1714: , 'Verify_Payment'
1715: );
1716: END IF;

Line 1718: OE_MSG_PUB.Count_And_Get

1714: , 'Verify_Payment'
1715: );
1716: END IF;
1717:
1718: OE_MSG_PUB.Count_And_Get
1719: ( p_count => l_msg_count,
1720: p_data => l_msg_data
1721: );
1722:

Line 2114: OE_MSG_PUB.Count_And_Get

2110: , 'Hold_Exists'
2111: );
2112: END IF;
2113:
2114: OE_MSG_PUB.Count_And_Get
2115: ( p_count => l_msg_count,
2116: p_data => l_msg_data
2117: );
2118:

Line 2343: oe_msg_pub.add;

2339: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2341: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
2342: fnd_message.set_name('ONT', 'OE_CC_HOLD_REMOVED');
2343: oe_msg_pub.add;
2344: END IF;
2345:
2346: END IF; -- Do nothing if the hold has already been released.
2347:

Line 2354: OE_MSG_PUB.Count_And_Get

2350: EXCEPTION
2351:
2352: WHEN FND_API.G_EXC_ERROR THEN
2353: p_return_status := FND_API.G_RET_STS_ERROR;
2354: OE_MSG_PUB.Count_And_Get
2355: ( p_count => l_msg_count,
2356: p_data => l_msg_data
2357: );
2358:

Line 2361: OE_MSG_PUB.Count_And_Get

2357: );
2358:
2359: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2360: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2361: OE_MSG_PUB.Count_And_Get
2362: ( p_count => l_msg_count,
2363: p_data => l_msg_data
2364: );
2365:

Line 2376: OE_MSG_PUB.Count_And_Get

2372: , 'Release_Verify_Hold'
2373: );
2374: END IF;
2375:
2376: OE_MSG_PUB.Count_And_Get
2377: ( p_count => l_msg_count,
2378: p_data => l_msg_data
2379: );
2380:

Line 2463: OE_MSG_PUB.ADD;

2459: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2460: IF p_hold_id = 16 THEN
2461: FND_MESSAGE.SET_NAME('ONT','ONT_PENDING_AUTH_HOLD_APPLIED');
2462: FND_MESSAGE.SET_TOKEN('LEVEL','ORDER');
2463: OE_MSG_PUB.ADD;
2464: IF l_debug_level > 0 THEN
2465: oe_debug_pub.add( 'OEXVPPYB: Pending Payment Authorization hold has been applied on order.', 3);
2466: END IF;
2467: END IF;

Line 2482: OE_MSG_PUB.Count_And_Get

2478: EXCEPTION
2479:
2480: WHEN FND_API.G_EXC_ERROR THEN
2481: p_return_status := FND_API.G_RET_STS_ERROR;
2482: OE_MSG_PUB.Count_And_Get
2483: ( p_count => l_msg_count,
2484: p_data => l_msg_data
2485: );
2486:

Line 2489: OE_MSG_PUB.Count_And_Get

2485: );
2486:
2487: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2488: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2489: OE_MSG_PUB.Count_And_Get
2490: ( p_count => l_msg_count,
2491: p_data => l_msg_data
2492: );
2493:

Line 2504: OE_MSG_PUB.Count_And_Get

2500: , 'Apply_Verify_Hold'
2501: );
2502: END IF;
2503:
2504: OE_MSG_PUB.Count_And_Get
2505: ( p_count => l_msg_count,
2506: p_data => l_msg_data
2507: );
2508:

Line 2595: OE_MSG_PUB.ADD;

2591: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2592: IF p_hold_id = 16 THEN
2593: FND_MESSAGE.SET_NAME('ONT','ONT_PENDING_AUTH_HOLD_APPLIED');
2594: FND_MESSAGE.SET_TOKEN('LEVEL','ORDER');
2595: OE_MSG_PUB.ADD;
2596: IF l_debug_level > 0 THEN
2597: oe_debug_pub.add( 'OEXVPPYB: Pending Payment Authorization hold has been applied on order.', 3);
2598: END IF;
2599: END IF;

Line 2622: OE_MSG_PUB.Count_And_Get

2618: EXCEPTION
2619:
2620: WHEN FND_API.G_EXC_ERROR THEN
2621: p_return_status := FND_API.G_RET_STS_ERROR;
2622: OE_MSG_PUB.Count_And_Get
2623: ( p_count => l_msg_count,
2624: p_data => l_msg_data
2625: );
2626:

Line 2629: OE_MSG_PUB.Count_And_Get

2625: );
2626:
2627: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2628: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2629: OE_MSG_PUB.Count_And_Get
2630: ( p_count => l_msg_count,
2631: p_data => l_msg_data
2632: );
2633:

Line 2644: OE_MSG_PUB.Count_And_Get

2640: , 'Apply_Verify_Hold_and_Commit'
2641: );
2642: END IF;
2643:
2644: OE_MSG_PUB.Count_And_Get
2645: ( p_count => l_msg_count,
2646: p_data => l_msg_data
2647: );
2648:

Line 2840: OE_MSG_PUB.Count_And_Get

2836:
2837: WHEN FND_API.G_EXC_ERROR THEN
2838: p_result_out := 'FAIL';
2839: p_return_status := FND_API.G_RET_STS_ERROR;
2840: OE_MSG_PUB.Count_And_Get
2841: ( p_count => l_msg_count,
2842: p_data => l_msg_data
2843: );
2844:

Line 2848: OE_MSG_PUB.Count_And_Get

2844:
2845: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2846: p_result_out := 'FAIL';
2847: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2848: OE_MSG_PUB.Count_And_Get
2849: ( p_count => l_msg_count,
2850: p_data => l_msg_data
2851: );
2852:

Line 2864: OE_MSG_PUB.Count_And_Get

2860: , 'Payment_Request'
2861: );
2862: END IF;
2863:
2864: OE_MSG_PUB.Count_And_Get
2865: ( p_count => l_msg_count,
2866: p_data => l_msg_data
2867: );
2868:

Line 3300: OE_MSG_PUB.ADD;

3296: IF l_payee_id is NULL THEN
3297:
3298: -- Message "Unable to retrieve Payee/Merchant ID for Customer's Primary Payment Method"
3299: FND_MESSAGE.SET_NAME('ONT','OE_VPM_NO_PAYEE_ID');
3300: OE_MSG_PUB.ADD;
3301: p_result_out := 'FAIL' ;
3302: RETURN;
3303:
3304: END IF;

Line 3310: OE_MSG_PUB.ADD;

3306: ELSE -- Method ID is invalid
3307:
3308: -- Message "Unable to retrieve Primary Payment Method for the customer"
3309: FND_MESSAGE.SET_NAME('ONT','OE_VPM_NO_PAY_METHOD');
3310: OE_MSG_PUB.ADD;
3311: p_result_out := 'FAIL' ;
3312: RETURN;
3313:
3314: END IF;

Line 3400: OE_MSG_PUB.ADD;

3396: ) ;
3397: EXCEPTION
3398: WHEN OTHERS THEN
3399: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET');
3400: OE_MSG_PUB.ADD;
3401: IF l_debug_level > 0 THEN
3402: oe_debug_pub.add( 'OEXPVPMB: ERROR IN ARP_BANK_PKG.PROCESS_CUST_BANK_ACCOUNT' ) ;
3403: END IF;
3404: p_result_out := 'FAIL';

Line 3708: OE_MSG_PUB.ADD;

3704: FND_MESSAGE.SET_TOKEN('ERRMESSAGE',l_err_mesg);
3705: FND_MESSAGE.SET_TOKEN('ERRLOCATION',l_err_loc);
3706: FND_MESSAGE.SET_TOKEN('BEPERRCODE',l_bep_err_code);
3707: FND_MESSAGE.SET_TOKEN('BEPERRMESSAGE',l_bep_err_mesg);
3708: OE_MSG_PUB.ADD;
3709:
3710: IF l_debug_level > 0 THEN
3711: oe_debug_pub.add( 'OEXPVPMB: ERROR CODE : '||L_ERR_CODE ) ;
3712: END IF;

Line 3808: OE_MSG_PUB.Count_And_Get

3804: , 'Authorize_Payment'
3805: );
3806: END IF;
3807:
3808: OE_MSG_PUB.Count_And_Get
3809: ( p_count => l_msg_count,
3810: p_data => l_msg_data
3811: );
3812:

Line 4034: OE_MSG_PUB.ADD;

4030:
4031: -- Check For all Required Attributes
4032: IF p_header_rec.invoice_to_org_id is NULL THEN
4033: FND_MESSAGE.SET_NAME('ONT','OE_VPM_INV_TO_REQUIRED');
4034: OE_MSG_PUB.ADD;
4035: IF l_debug_level > 0 THEN
4036: oe_debug_pub.add( 'OEXPVPMB: INVOICE_TO_ORG_ID IS REQUIRED' ) ;
4037: END IF;
4038: l_result := FALSE;

Line 4042: OE_MSG_PUB.ADD;

4038: l_result := FALSE;
4039: ELSIF p_header_rec.credit_card_number is NULL THEN
4040: --R12 CC Encryption
4041: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_NUM_REQUIRED');
4042: OE_MSG_PUB.ADD;
4043: IF l_debug_level > 0 THEN
4044: oe_debug_pub.add( 'OEXPVPMB: CREDIT_CARD_NUMBER IS REQUIRED' ) ;
4045: END IF;
4046: l_result := FALSE;

Line 4049: OE_MSG_PUB.ADD;

4045: END IF;
4046: l_result := FALSE;
4047: ELSIF p_header_rec.credit_card_expiration_date is NULL THEN
4048: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_EXP_DT_REQUIRED');
4049: OE_MSG_PUB.ADD;
4050: IF l_debug_level > 0 THEN
4051: oe_debug_pub.add( 'OEXPVPMB: CREDIT_CARD_EXPIRATION_DATE IS REQUIRED' ) ;
4052: END IF;
4053: l_result := FALSE;

Line 4056: OE_MSG_PUB.ADD;

4052: END IF;
4053: l_result := FALSE;
4054: ELSIF p_header_rec.credit_card_holder_name is NULL THEN
4055: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_HOLDER_REQUIRED');
4056: OE_MSG_PUB.ADD;
4057: IF l_debug_level > 0 THEN
4058: oe_debug_pub.add( 'OEXPVPMB: CREDIT_CARD_HOLDER_NAME IS REQUIRED' ) ;
4059: END IF;
4060: l_result := FALSE;

Line 4381: OE_MSG_PUB.ADD;

4377: FND_MESSAGE.SET_TOKEN('ERRMESSAGE',l_err_mesg);
4378: FND_MESSAGE.SET_TOKEN('ERRLOCATION',l_err_loc);
4379: FND_MESSAGE.SET_TOKEN('BEPERRCODE',l_bep_err_code);
4380: FND_MESSAGE.SET_TOKEN('BEPERRMESSAGE',l_bep_err_mesg);
4381: OE_MSG_PUB.ADD;
4382:
4383: IF l_debug_level > 0 THEN
4384: oe_debug_pub.add( 'OEXPVPMB: ERROR CODE : '||L_ERR_CODE ) ;
4385: END IF;

Line 4410: OE_MSG_PUB.Count_And_Get

4406: EXCEPTION
4407:
4408: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4409: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4410: OE_MSG_PUB.Count_And_Get
4411: ( p_count => l_msg_count,
4412: p_data => l_msg_data
4413: );
4414:

Line 4425: OE_MSG_PUB.Count_And_Get

4421: , 'Void_Payment'
4422: );
4423: END IF;
4424:
4425: OE_MSG_PUB.Count_And_Get
4426: ( p_count => l_msg_count,
4427: p_data => l_msg_data
4428: );
4429:

Line 5026: OE_MSG_PUB.Count_And_Get

5022:
5023: WHEN FND_API.G_EXC_ERROR THEN
5024: ROLLBACK TO Update_Authorization_Info;
5025: p_return_status := FND_API.G_RET_STS_ERROR;
5026: OE_MSG_PUB.Count_And_Get
5027: ( p_count => l_msg_count,
5028: p_data => l_msg_data
5029: );
5030:

Line 5034: OE_MSG_PUB.Count_And_Get

5030:
5031: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5032: ROLLBACK TO Update_Authorization_Info;
5033: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5034: OE_MSG_PUB.Count_And_Get
5035: ( p_count => l_msg_count,
5036: p_data => l_msg_data
5037: );
5038:

Line 5051: OE_MSG_PUB.Count_And_Get

5047: , 'Update_Authorization_Info'
5048: );
5049: END IF;
5050:
5051: OE_MSG_PUB.Count_And_Get
5052: ( p_count => l_msg_count,
5053: p_data => l_msg_data
5054: );
5055:

Line 5726: OE_MSG_PUB.ADD;

5722: /* IF l_payee_id is NULL THEN
5723: -- Message "Unable to retrieve Payee/Merchant ID
5724: -- for Customer's Primary Payment Method"
5725: FND_MESSAGE.SET_NAME('ONT','OE_VPM_NO_PAYEE_ID');
5726: OE_MSG_PUB.ADD;
5727: l_result_status := 'FAIL' ;
5728: goto Update_Verify_Hold;
5729: -- RETURN;
5730: END IF; */

Line 5735: OE_MSG_PUB.ADD;

5731: ELSE -- Method ID is invalid
5732:
5733: -- Message "Unable to retrieve Primary Payment Method for the customer"
5734: FND_MESSAGE.SET_NAME('ONT','OE_VPM_NO_PAY_METHOD');
5735: OE_MSG_PUB.ADD;
5736: l_result_status := 'FAIL' ;
5737: goto Update_Verify_Hold;
5738: -- RETURN;
5739: END IF;

Line 5821: OE_MSG_PUB.ADD;

5817: END IF;
5818:
5819: IF l_invoice_to_org_id is NULL THEN
5820: FND_MESSAGE.SET_NAME('ONT','OE_VPM_INV_TO_REQUIRED');
5821: OE_MSG_PUB.ADD;
5822: IF l_debug_level > 0 THEN
5823: oe_debug_pub.add( 'OEXPVPMB: INVOICE_TO_ORG_ID IS REQUIRED' ) ;
5824: END IF;
5825: l_result_status := 'FAIL';

Line 5830: OE_MSG_PUB.ADD;

5826: goto Update_Verify_Hold;
5827: -- return;
5828: ELSIF l_payments_tbl(I).trxn_extension_id is NULL THEN --R12 CC Encryption
5829: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_NUM_REQUIRED');
5830: OE_MSG_PUB.ADD;
5831: IF l_debug_level > 0 THEN
5832: oe_debug_pub.add( 'OEXPVPMB: CREDIT_CARD_NUMBER IS REQUIRED' ) ;
5833: END IF;
5834: l_result_status := 'FAIL';

Line 5842: OE_MSG_PUB.ADD;

5838:
5839: /*
5840: ELSIF l_payments_tbl(I).credit_card_expiration_date is NULL THEN
5841: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_EXP_DT_REQUIRED');
5842: OE_MSG_PUB.ADD;
5843: IF l_debug_level > 0 THEN
5844: oe_debug_pub.add( 'OEXPVPMB: CREDIT_CARD_EXPIRATION_DATE IS REQUIRED' ) ;
5845: END IF;
5846: l_result_status := 'FAIL';

Line 5851: OE_MSG_PUB.ADD;

5847: goto Update_Verify_Hold;
5848: -- return;
5849: ELSIF l_payments_tbl(I).credit_card_holder_name is NULL THEN
5850: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_HOLDER_REQUIRED');
5851: OE_MSG_PUB.ADD;
5852: IF l_debug_level > 0 THEN
5853: oe_debug_pub.add( 'OEXPVPMB: CREDIT_CARD_HOLDER_NAME IS REQUIRED' ) ;
5854: END IF;
5855: l_result_status := 'FAIL';

Line 6055: OE_MSG_PUB.ADD;

6051: END IF;
6052: END IF; -- line id is not null
6053:
6054: FND_MESSAGE.SET_NAME('ONT','ONT_CC_RISK_HOLD_APPLIED');
6055: OE_MSG_PUB.ADD;
6056: RETURN;
6057:
6058: oe_debug_pub.add('after commented message');
6059: /*comm rej ELSE

Line 6065: OE_MSG_PUB.ADD;

6061: oe_debug_pub.add('Risk validation failed...!');
6062: END IF;
6063: -- the value is reject, then
6064: FND_MESSAGE.SET_NAME('ONT','ONT_RISK_VALIDATION_FAILED');
6065: OE_MSG_PUB.ADD;
6066: RAISE FND_API.G_EXC_ERROR;
6067: END IF; --Reject flag
6068: comm rej */
6069: END IF; -- risk score > threshold

Line 6074: OE_MSG_PUB.ADD;

6070: END IF; --risk eval flag = y
6071: oe_debug_pub.add('before uncommented message');
6072: FND_MESSAGE.SET_NAME('ONT','ONT_PAYMENT_AUTH_SUCCESS');
6073: FND_MESSAGE.SET_TOKEN('AMOUNT',TO_CHAR(l_amount_to_authorize,l_format_mask));
6074: OE_MSG_PUB.ADD;
6075: oe_debug_pub.add('after uncommented message');
6076: IF l_debug_level >0 THEN
6077: oe_debug_pub.add('After risk evaluation...!');
6078: END IF;

Line 6166: OE_MSG_PUB.ADD;

6162: END IF;
6163: END IF; -- line id is not null
6164:
6165: FND_MESSAGE.SET_NAME('ONT','ONT_CC_SECURITY_CODE_FAILED');
6166: OE_MSG_PUB.ADD;
6167: RETURN;
6168: --bug 4767915
6169: /* ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS AND
6170: l_response.result_code = 'RISK_THRESHOLD_EXCEEDED' THEN

Line 6225: OE_MSG_PUB.ADD;

6221: END IF;
6222: END IF; -- line id is not null
6223:
6224: FND_MESSAGE.SET_NAME('ONT','ONT_CC_RISK_HOLD_APPLIED');
6225: OE_MSG_PUB.ADD;
6226: RETURN;
6227: END IF;*/
6228: ELSE
6229: IF l_debug_level >0 THEN

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

6235:
6236: l_result_status := 'FAIL';
6237:
6238: -- add messages to message stack.
6239: oe_msg_pub.add_text(p_message_text => l_response.result_message);
6240:
6241: -- apply credit card authorization hold in case of auth failure.
6242: --comm rej IF nvl(p_reject_on_auth_failure, 'N') = 'N' THEN
6243: IF l_payments_tbl(I).line_id IS NULL THEN

Line 6289: OE_MSG_PUB.ADD;

6285: END IF;
6286:
6287: FND_MESSAGE.SET_NAME('ONT','ONT_CC_AUTH_HOLD_APPLIED');
6288: FND_MESSAGE.SET_TOKEN('AMOUNT',TO_CHAR(l_amount_to_authorize,l_format_mask));
6289: OE_MSG_PUB.ADD;
6290:
6291: /*comm rej ELSE
6292: -- the value is to reject on failure, then
6293: -- raise error so the transaction will fail

Line 6295: OE_MSG_PUB.ADD;

6291: /*comm rej ELSE
6292: -- the value is to reject on failure, then
6293: -- raise error so the transaction will fail
6294: FND_MESSAGE.SET_NAME('ONT',' ONT_CC_AUTH_FAILED'); FND_MESSAGE.SET_TOKEN('AMOUNT',TO_CHAR(l_amount_to_authorize,l_format_mask));
6295: OE_MSG_PUB.ADD;
6296: RAISE FND_API.G_EXC_ERROR;
6297: END IF;
6298: comm rej*/
6299: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 6320: OE_MSG_PUB.ADD;*/

6316:
6317: --bug3511992 start
6318: FND_MESSAGE.SET_NAME('ONT','ONT_PAYMENT_AUTH_SUCCESS');
6319: FND_MESSAGE.SET_TOKEN('AMOUNT',TO_CHAR(l_amount_to_authorize,l_format_mask)); --Format mask for bug 3571485
6320: OE_MSG_PUB.ADD;*/
6321: --bug3511992 end
6322:
6323: <>
6324: -- Update Payment Amount and Authorization Code and DATE

Line 6508: OE_MSG_PUB.Count_And_Get

6504: oe_debug_pub.add('Error'||l_err_message);
6505: END IF;
6506:
6507: p_return_status := FND_API.G_RET_STS_ERROR;
6508: OE_MSG_PUB.Count_And_Get
6509: ( p_count => l_msg_count,
6510: p_data => l_msg_data
6511: );
6512:

Line 6523: OE_MSG_PUB.Count_And_Get

6519: oe_debug_pub.add('f Error'||l_err_message);
6520: END IF;
6521:
6522: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6523: OE_MSG_PUB.Count_And_Get
6524: ( p_count => l_msg_count,
6525: p_data => l_msg_data
6526: );
6527:

Line 6543: OE_MSG_PUB.Count_And_Get

6539: , 'Authorize_Payment'
6540: );
6541: END IF;
6542:
6543: OE_MSG_PUB.Count_And_Get
6544: ( p_count => l_msg_count,
6545: p_data => l_msg_data
6546: );
6547:

Line 6719: OE_MSG_PUB.Count_And_Get

6715: , 'Check_ReAuth_for_MultiPmnts'
6716: );
6717: END IF;
6718:
6719: OE_MSG_PUB.Count_And_Get
6720: ( p_count => x_msg_count,
6721: p_data => x_msg_data
6722: );
6723:

Line 7664: OE_MSG_PUB.Count_And_Get

7660:
7661: WHEN FND_API.G_EXC_ERROR THEN
7662: ROLLBACK TO Update_AuthInfo_for_MultiPmnts;
7663: p_return_status := FND_API.G_RET_STS_ERROR;
7664: OE_MSG_PUB.Count_And_Get
7665: ( p_count => l_msg_count,
7666: p_data => l_msg_data
7667: );
7668:

Line 7672: OE_MSG_PUB.Count_And_Get

7668:
7669: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7670: ROLLBACK TO Update_AuthInfo_for_MultiPmnts;
7671: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7672: OE_MSG_PUB.Count_And_Get
7673: ( p_count => l_msg_count,
7674: p_data => l_msg_data
7675: );
7676:

Line 7689: OE_MSG_PUB.Count_And_Get

7685: , 'Update_AuthInfo_for_MultiPmnts'
7686: );
7687: END IF;
7688:
7689: OE_MSG_PUB.Count_And_Get
7690: ( p_count => l_msg_count,
7691: p_data => l_msg_data
7692: );
7693:

Line 7899: OE_MSG_PUB.Count_And_Get

7895: EXCEPTION
7896:
7897: WHEN FND_API.G_EXC_ERROR THEN
7898: p_return_status := FND_API.G_RET_STS_ERROR;
7899: OE_MSG_PUB.Count_And_Get
7900: ( p_count => l_msg_count,
7901: p_data => l_msg_data
7902: );
7903:

Line 7906: OE_MSG_PUB.Count_And_Get

7902: );
7903:
7904: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7905: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7906: OE_MSG_PUB.Count_And_Get
7907: ( p_count => l_msg_count,
7908: p_data => l_msg_data
7909: );
7910:

Line 7921: OE_MSG_PUB.Count_And_Get

7917: , 'Release_Verify_Line_Hold'
7918: );
7919: END IF;
7920:
7921: OE_MSG_PUB.Count_And_Get
7922: ( p_count => l_msg_count,
7923: p_data => l_msg_data
7924: );
7925:

Line 8044: OE_MSG_PUB.ADD;

8040:
8041:
8042: FND_MESSAGE.SET_NAME('ONT','ONT_PENDING_AUTH_HOLD_APPLIED');
8043: FND_MESSAGE.SET_TOKEN('LEVEL','LINE '||l_line_ind);
8044: OE_MSG_PUB.ADD;
8045: IF l_debug_level > 0 THEN
8046: oe_debug_pub.add( 'OEXVPPYB: Pending Payment Authorization hold has been applied on order line.', 3);
8047: END IF;
8048: END IF;

Line 8063: OE_MSG_PUB.Count_And_Get

8059: EXCEPTION
8060:
8061: WHEN FND_API.G_EXC_ERROR THEN
8062: p_return_status := FND_API.G_RET_STS_ERROR;
8063: OE_MSG_PUB.Count_And_Get
8064: ( p_count => l_msg_count,
8065: p_data => l_msg_data
8066: );
8067:

Line 8070: OE_MSG_PUB.Count_And_Get

8066: );
8067:
8068: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8069: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8070: OE_MSG_PUB.Count_And_Get
8071: ( p_count => l_msg_count,
8072: p_data => l_msg_data
8073: );
8074:

Line 8085: OE_MSG_PUB.Count_And_Get

8081: , 'Apply_Verify_Line_Hold'
8082: );
8083: END IF;
8084:
8085: OE_MSG_PUB.Count_And_Get
8086: ( p_count => l_msg_count,
8087: p_data => l_msg_data
8088: );
8089:

Line 8267: OE_Msg_Pub.Add;

8263: NOT OE_GLOBALS.Equal(p_instrument_security_code,FND_API.G_MISS_CHAR) THEN
8264: l_trxn_attribs.Instrument_Security_Code := p_instrument_security_code;
8265: ELSE
8266: FND_MESSAGE.SET_NAME('ONT','OE_CC_SECURITY_CODE_REQD');
8267: OE_Msg_Pub.Add;
8268: RAISE FND_API.G_EXC_ERROR;
8269: END IF;
8270: END IF;
8271: --bug 5028932

Line 8324: OE_MSG_PUB.Count_And_Get

8320:
8321: WHEN FND_API.G_EXC_ERROR THEN
8322:
8323: X_return_status := FND_API.G_RET_STS_ERROR;
8324: OE_MSG_PUB.Count_And_Get
8325: ( p_count => l_msg_count,
8326: p_data => l_msg_data
8327: );
8328: RAISE FND_API.G_EXC_ERROR;

Line 8333: OE_MSG_PUB.Count_And_Get

8329:
8330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8331:
8332: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8333: OE_MSG_PUB.Count_And_Get
8334: ( p_count => l_msg_count,
8335: p_data => l_msg_data
8336: );
8337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8350: OE_MSG_PUB.Count_And_Get

8346: , 'OE_Verify_Payment_PUB'
8347: );
8348: END IF;
8349:
8350: OE_MSG_PUB.Count_And_Get
8351: ( p_count => l_msg_count,
8352: p_data => l_msg_data
8353: );
8354: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;