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

Line 446: oe_msg_pub.add_text(p_message_text => x_msg_data);

442: FND_MESSAGE.Set_Token('PAYMENT_NUMBER',p_payment_number);
443: FND_MESSAGE.Set_Token('ERROR',x_msg_data);
444: x_msg_data := SUBSTR(FND_MESSAGE.GET,1,2000);
445: --7559372 end
446: oe_msg_pub.add_text(p_message_text => x_msg_data);
447: ELSIF ( FND_MSG_PUB.Count_Msg > 0 ) THEN
448: arp_util.enable_debug;
449: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
450: -- l_msg_text := FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE);

Line 461: oe_msg_pub.add_text(p_message_text => l_msg_text);

457: FND_MESSAGE.Set_Token('PAYMENT_NUMBER',p_payment_number);
458: FND_MESSAGE.Set_Token('ERROR',l_msg_text);
459: l_msg_text := SUBSTR(FND_MESSAGE.GET,1,2000);
460: --7559372 end
461: oe_msg_pub.add_text(p_message_text => l_msg_text);
462: END LOOP;
463: END IF;
464:
465: x_result_out := 'FAIL';

Line 486: OE_MSG_PUB.Count_And_Get

482: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
483: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , 'Create_Receipt');
484: END IF;
485:
486: OE_MSG_PUB.Count_And_Get
487: ( p_count => l_msg_count,
488: p_data => l_msg_data
489: );
490:

Line 556: oe_msg_pub.add;

552: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
553: fnd_message.Set_Name('ONT', 'ONT_REFUND_PROCESS_SUCCESS');
554: FND_MESSAGE.SET_TOKEN('AMOUNT' , TO_CHAR(p_amount * -1, l_format_mask));
555: FND_MESSAGE.SET_TOKEN('NUMBER' , l_number_of_refund_receipts);
556: oe_msg_pub.add;
557: IF l_debug_level > 0 THEN
558: oe_debug_pub.add( 'OEXVPPYB: REFUND REQUEST OF ' ||P_AMOUNT||' HAS BEEN PROCESSED SUCCESSFULLY.' , 3 ) ;
559: END IF;
560: ELSE

Line 563: oe_msg_pub.add;

559: END IF;
560: ELSE
561: fnd_message.Set_Name('ONT', 'ONT_REFUND_PROCESS_FAILED');
562: FND_MESSAGE.SET_TOKEN('AMOUNT', TO_CHAR(p_amount, l_format_mask));
563: oe_msg_pub.add;
564: IF l_debug_level > 0 THEN
565: oe_debug_pub.add( 'OEXVPPYB: REFUND PROCESSING FOR ' ||P_AMOUNT||' FAILED.' , 3 ) ;
566: END IF;
567: END IF;

Line 581: OE_MSG_PUB.Count_And_Get

577: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
578: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , 'Refund_Request');
579: END IF;
580:
581: OE_MSG_PUB.Count_And_Get
582: ( p_count => l_msg_count,
583: p_data => l_msg_data
584: );
585:

Line 812: OE_MSG_PUB.ADD;

808: --R12 CC Encryption
809:
810: EXCEPTION WHEN OTHERS THEN
811: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET');
812: OE_MSG_PUB.ADD;
813: IF l_debug_level > 0 THEN
814: oe_debug_pub.add( 'OEXVPPYB: ERROR IN ARP_BANK_PKG.PROCESS_CUST_BANK_ACCOUNT' , 3 ) ;
815: END IF;
816: -- apply epayment failure hold due to incorrect credit card information.

Line 839: OE_MSG_PUB.ADD;

835: IF l_debug_level > 0 THEN
836: oe_debug_pub.add( 'OEXVPPYB: THE PAYMENT METHOD ID IS INVALID: '||L_PAY_METHOD_ID , 3 ) ;
837: END IF;
838: FND_MESSAGE.SET_NAME('ONT','OE_VPM_NO_PAY_METHOD');
839: OE_MSG_PUB.ADD;
840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
841: RETURN;
842: END IF;
843:

Line 962: OE_MSG_PUB.ADD;

958: l_format_mask := get_format_mask(p_header_rec.transactional_curr_code);
959:
960: FND_MESSAGE.SET_NAME('ONT','ONT_PAYMENT_PROCESS_SUCESS');
961: FND_MESSAGE.SET_TOKEN('AMOUNT' , TO_CHAR(l_pending_amount, l_format_mask));
962: OE_MSG_PUB.ADD;
963:
964: IF l_debug_level > 0 THEN
965: oe_debug_pub.add( 'OEXVPPYB: RELEASING PREPAYMENT HOLD' , 3 ) ;
966: END IF;

Line 1039: l_msg_count:=OE_MSG_PUB.COUNT_MSG;

1035: -- what is the seed id for ppp hold?
1036:
1037: -- get the message count here, as we do not want to append
1038: -- the message ONT_PAYMENT_PROCESS_FAILED to the hold comments.
1039: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
1040:
1041: l_format_mask := get_format_mask(p_header_rec.transactional_curr_code);
1042:
1043: FND_MESSAGE.SET_NAME('ONT','ONT_PAYMENT_PROCESS_FAILED');

Line 1045: OE_MSG_PUB.ADD;

1041: l_format_mask := get_format_mask(p_header_rec.transactional_curr_code);
1042:
1043: FND_MESSAGE.SET_NAME('ONT','ONT_PAYMENT_PROCESS_FAILED');
1044: FND_MESSAGE.SET_TOKEN('AMOUNT' , TO_CHAR(l_pending_amount, l_format_mask));
1045: OE_MSG_PUB.ADD;
1046:
1047: -- fix for bug 4201632, get the messages and populate them
1048: -- as the hold comments.
1049: l_msg_data := null;

Line 1051: l_msg_data := l_msg_data||' '|| OE_MSG_PUB.Get(I,'F');

1047: -- fix for bug 4201632, get the messages and populate them
1048: -- as the hold comments.
1049: l_msg_data := null;
1050: FOR I IN 1..l_msg_count LOOP
1051: l_msg_data := l_msg_data||' '|| OE_MSG_PUB.Get(I,'F');
1052: IF l_debug_level > 0 THEN
1053: oe_debug_pub.add( L_MSG_DATA , 1 ) ;
1054: END IF;
1055: END LOOP;

Line 1179: OE_MSG_PUB.Count_And_Get

1175: EXCEPTION
1176:
1177: WHEN FND_API.G_EXC_ERROR THEN
1178: x_return_status := FND_API.G_RET_STS_ERROR;
1179: OE_MSG_PUB.Count_And_Get
1180: ( p_count => l_msg_count,
1181: p_data => l_msg_data
1182: );
1183:

Line 1186: OE_MSG_PUB.Count_And_Get

1182: );
1183:
1184: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1186: OE_MSG_PUB.Count_And_Get
1187: ( p_count => l_msg_count,
1188: p_data => l_msg_data
1189: );
1190:

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

1189: );
1190:
1191: WHEN OTHERS THEN
1192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1193: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1194: THEN
1195: OE_MSG_PUB.Add_Exc_Msg
1196: ( G_PKG_NAME
1197: , 'Process_PrePayment_Order'

Line 1195: OE_MSG_PUB.Add_Exc_Msg

1191: WHEN OTHERS THEN
1192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1193: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1194: THEN
1195: OE_MSG_PUB.Add_Exc_Msg
1196: ( G_PKG_NAME
1197: , 'Process_PrePayment_Order'
1198: );
1199: END IF;

Line 1201: OE_MSG_PUB.Count_And_Get

1197: , 'Process_PrePayment_Order'
1198: );
1199: END IF;
1200:
1201: OE_MSG_PUB.Count_And_Get
1202: ( p_count => l_msg_count,
1203: p_data => l_msg_data
1204: );
1205:

Line 1304: OE_MSG_PUB.Count_And_Get

1300: , 'Any_Prepayment_Hold_Exists'
1301: );
1302: END IF;
1303:
1304: OE_MSG_PUB.Count_And_Get
1305: ( p_count => l_msg_count,
1306: p_data => l_msg_data
1307: );
1308:

Line 1385: OE_MSG_PUB.ADD;

1381:
1382: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1383: IF p_hold_id = 13 THEN
1384: FND_MESSAGE.SET_NAME('ONT','ONT_PPP_HOLD_APPLIED');
1385: OE_MSG_PUB.ADD;
1386: IF l_debug_level > 0 THEN
1387: oe_debug_pub.add( 'OEXVPPYB: PPP Hold has been applied on order.', 3 ) ;
1388: END IF;
1389: ELSIF p_hold_id = 14 THEN

Line 1391: OE_MSG_PUB.ADD;

1387: oe_debug_pub.add( 'OEXVPPYB: PPP Hold has been applied on order.', 3 ) ;
1388: END IF;
1389: ELSIF p_hold_id = 14 THEN
1390: FND_MESSAGE.SET_NAME('ONT','ONT_PAYMENT_FAILURE_HOLD');
1391: OE_MSG_PUB.ADD;
1392: IF l_debug_level > 0 THEN
1393: oe_debug_pub.add( 'OEXVPPYB: payment failure hold has been applied on order.', 3 ) ;
1394: END IF;
1395: ELSIF p_hold_id = 15 THEN

Line 1397: OE_MSG_PUB.ADD;

1393: oe_debug_pub.add( 'OEXVPPYB: payment failure hold has been applied on order.', 3 ) ;
1394: END IF;
1395: ELSIF p_hold_id = 15 THEN
1396: FND_MESSAGE.SET_NAME('ONT','ONT_PAYMENT_SERVER_FAIL_HOLD');
1397: OE_MSG_PUB.ADD;
1398: IF l_debug_level > 0 THEN
1399: oe_debug_pub.add( 'OEXVPPYB: payment server failure hold has been applied on order.', 3 ) ;
1400: END IF;
1401: END IF;

Line 1417: OE_MSG_PUB.Count_And_Get

1413: EXCEPTION
1414:
1415: WHEN FND_API.G_EXC_ERROR THEN
1416: p_return_status := FND_API.G_RET_STS_ERROR;
1417: OE_MSG_PUB.Count_And_Get
1418: ( p_count => l_msg_count,
1419: p_data => l_msg_data
1420: );
1421:

Line 1424: OE_MSG_PUB.Count_And_Get

1420: );
1421:
1422: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1423: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1424: OE_MSG_PUB.Count_And_Get
1425: ( p_count => l_msg_count,
1426: p_data => l_msg_data
1427: );
1428:

Line 1439: OE_MSG_PUB.Count_And_Get

1435: , 'Apply_Prepayment_Hold'
1436: );
1437: END IF;
1438:
1439: OE_MSG_PUB.Count_And_Get
1440: ( p_count => l_msg_count,
1441: p_data => l_msg_data
1442: );
1443:

Line 1525: oe_msg_pub.add;

1521: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1522: END IF;
1523: --bug3599715 start
1524: fnd_message.Set_Name('ONT', 'ONT_PPP_HOLD_RELEASED');
1525: oe_msg_pub.add;
1526: --bug3599715 end
1527: END IF;
1528:
1529: -- check for epayment failure hold.

Line 1568: oe_msg_pub.add;

1564: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1566: END IF;
1567: fnd_message.Set_Name('ONT', 'ONT_PMNT_FAIL_HOLD_RELEASED');
1568: oe_msg_pub.add;
1569: END IF;
1570:
1571: -- check for epayment server failure hold.
1572: l_hold_id := 15 ;

Line 1610: oe_msg_pub.add;

1606: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1608: END IF;
1609: fnd_message.Set_Name('ONT', 'ONT_PMNT_SERVER_HOLD_RELEASED');
1610: oe_msg_pub.add;
1611: END IF;
1612: OE_GLOBALS.G_SYS_HOLD := FALSE; --8477694
1613: EXCEPTION
1614:

Line 1618: OE_MSG_PUB.Count_And_Get

1614:
1615: WHEN FND_API.G_EXC_ERROR THEN
1616: OE_GLOBALS.G_SYS_HOLD := FALSE; --8477694
1617: p_return_status := FND_API.G_RET_STS_ERROR;
1618: OE_MSG_PUB.Count_And_Get
1619: ( p_count => l_msg_count,
1620: p_data => l_msg_data
1621: );
1622:

Line 1626: OE_MSG_PUB.Count_And_Get

1622:
1623: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1624: OE_GLOBALS.G_SYS_HOLD := FALSE; --8477694
1625: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1626: OE_MSG_PUB.Count_And_Get
1627: ( p_count => l_msg_count,
1628: p_data => l_msg_data
1629: );
1630:

Line 1642: OE_MSG_PUB.Count_And_Get

1638: , 'Release_Prepayment_Hold'
1639: );
1640: END IF;
1641:
1642: OE_MSG_PUB.Count_And_Get
1643: ( p_count => l_msg_count,
1644: p_data => l_msg_data
1645: );
1646:

Line 1743: OE_MSG_PUB.Count_And_Get

1739: EXCEPTION
1740:
1741: WHEN FND_API.G_EXC_ERROR THEN
1742: p_return_status := FND_API.G_RET_STS_ERROR;
1743: OE_MSG_PUB.Count_And_Get
1744: ( p_count => l_msg_count,
1745: p_data => l_msg_data
1746: );
1747:

Line 1750: OE_MSG_PUB.Count_And_Get

1746: );
1747:
1748: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1749: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1750: OE_MSG_PUB.Count_And_Get
1751: ( p_count => l_msg_count,
1752: p_data => l_msg_data
1753: );
1754:

Line 1765: OE_MSG_PUB.Count_And_Get

1761: , 'Release_Payment_Hold'
1762: );
1763: END IF;
1764:
1765: OE_MSG_PUB.Count_And_Get
1766: ( p_count => l_msg_count,
1767: p_data => l_msg_data
1768: );
1769:

Line 2130: oe_msg_pub.Add;

2126: IF l_receipt_method_id =0 THEN
2127: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
2128: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Receipt Method');
2129: oe_debug_pub.add('OEXVPPYB: receipt method is null.',3);
2130: oe_msg_pub.Add;
2131: RAISE FND_API.G_EXC_ERROR;
2132:
2133: ELSE
2134: -- receipt method is not null

Line 2230: l_msg_count:=OE_MSG_PUB.COUNT_MSG;

2226: END IF;
2227:
2228: -- get the message count here, as we do not want to append
2229: -- the message ONT_PAYMENT_PROCESS_FAILED to the hold comments.
2230: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
2231:
2232: -- fix for bug 4201632, get the messages and populate them
2233: -- as the hold comments.
2234: l_msg_data := null;

Line 2236: l_msg_data := l_msg_data||' '|| OE_MSG_PUB.Get(I,'F');

2232: -- fix for bug 4201632, get the messages and populate them
2233: -- as the hold comments.
2234: l_msg_data := null;
2235: FOR I IN 1..l_msg_count LOOP
2236: l_msg_data := l_msg_data||' '|| OE_MSG_PUB.Get(I,'F');
2237: IF l_debug_level > 0 THEN
2238: oe_debug_pub.add( L_MSG_DATA , 1 ) ;
2239: END IF;
2240: END LOOP;

Line 2313: l_msg_count:=OE_MSG_PUB.COUNT_MSG;

2309: IF l_debug_level > 0 THEN
2310: oe_debug_pub.add( 'after create_refund, applying payment failure hold.', 3 ) ;
2311: END IF;
2312:
2313: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
2314:
2315: -- fix for bug 4201632, get the messages and populate them
2316: -- as the hold comments.
2317: l_msg_data := null;

Line 2319: l_msg_data := l_msg_data||' '|| OE_MSG_PUB.Get(I,'F');

2315: -- fix for bug 4201632, get the messages and populate them
2316: -- as the hold comments.
2317: l_msg_data := null;
2318: FOR I IN 1..l_msg_count LOOP
2319: l_msg_data := l_msg_data||' '|| OE_MSG_PUB.Get(I,'F');
2320: IF l_debug_level > 0 THEN
2321: oe_debug_pub.add( L_MSG_DATA , 1 ) ;
2322: END IF;
2323: END LOOP;

Line 2428: x_msg_count := OE_MSG_PUB.Count_Msg;

2424: IF l_debug_level > 0 THEN
2425: oe_debug_pub.add( 'OEXVPPYB: No rule defined for authorization. ' ) ;
2426: END IF;
2427: --bug3511992
2428: x_msg_count := OE_MSG_PUB.Count_Msg;
2429:
2430: oe_debug_pub.add('pviprana: x_msg_count in OEXVPPYB.pls = ' || x_msg_count);
2431: RETURN;
2432: END IF; --CC Reversal ER#16014135

Line 2504: x_msg_count := OE_MSG_PUB.Count_Msg;

2500: END IF;
2501:
2502: IF l_rule_defined = 'N' THEN
2503: --bug3511992
2504: x_msg_count := OE_MSG_PUB.Count_Msg;
2505:
2506: oe_debug_pub.add('pviprana: x_msg_count in OEXVPPYB.pls = ' || x_msg_count);
2507:
2508: return;

Line 2587: x_msg_count := OE_MSG_PUB.Count_Msg;

2583: g_process_pmt_req_logged := 'N';
2584: END IF;
2585:
2586: --bug3511992
2587: x_msg_count := OE_MSG_PUB.Count_Msg;
2588:
2589: oe_debug_pub.add('pviprana: x_msg_count in OEXVPPYB.pls = ' || x_msg_count);
2590:
2591: x_return_status := l_return_status;

Line 2601: OE_MSG_PUB.Count_And_Get

2597: EXCEPTION
2598:
2599: WHEN FND_API.G_EXC_ERROR THEN
2600: x_return_status := FND_API.G_RET_STS_ERROR;
2601: OE_MSG_PUB.Count_And_Get
2602: ( p_count => l_msg_count,
2603: p_data => l_msg_data
2604: );
2605:

Line 2611: OE_MSG_PUB.Count_And_Get

2607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2608: IF l_debug_level > 0 THEN
2609: oe_debug_pub.add( 'Unexpected error in Process_Payments: ' || SQLERRM , 3 ) ;
2610: END IF;
2611: OE_MSG_PUB.Count_And_Get
2612: ( p_count => l_msg_count,
2613: p_data => l_msg_data
2614: );
2615:

Line 2630: OE_MSG_PUB.Count_And_Get

2626: IF l_debug_level > 0 THEN
2627: oe_debug_pub.add( 'Oracle error in others in process_payments: '||SQLERRM , 3 ) ;
2628: END IF;
2629:
2630: OE_MSG_PUB.Count_And_Get
2631: ( p_count => l_msg_count,
2632: p_data => l_msg_data
2633: );
2634:

Line 2802: OE_Msg_Pub.Add;

2798: -- bug 5204275
2799: IF Oe_Payment_Trxn_Util.Get_CC_Security_Code_Use = 'REQUIRED'
2800: AND l_is_credit_card = 'Y' THEN
2801: FND_MESSAGE.SET_NAME('ONT','OE_CC_CVV2_REQD_FOR_SPLIT');
2802: OE_Msg_Pub.Add;
2803: END IF;
2804:
2805: I := l_line_payment_tbl.FIRST;
2806: WHILE I IS NOT NULL LOOP

Line 2840: OE_MSG_PUB.Add_Exc_Msg

2836:
2837: WHEN OTHERS THEN
2838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2839: If FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) Then
2840: OE_MSG_PUB.Add_Exc_Msg
2841: ( G_PKG_NAME
2842: , 'Split_Payment '
2843: );
2844: End If;

Line 3101: oe_msg_pub.add;

3097: oe_debug_pub.add('No Pay now payment instrument. setting x_result_out to INCOMPLETE and returning from the procedure');
3098: END IF;
3099: --bug4950878
3100: fnd_message.Set_Name('ONT', 'ONT_PAYNOW_PMT_NOT_ASSURED');
3101: oe_msg_pub.add;
3102:
3103: x_result_out := 'COMPLETE:INCOMPLETE';
3104: OE_Order_WF_Util.Update_Flow_Status_Code
3105: (p_line_id => p_line_id

Line 3232: oe_msg_pub.add;

3228: END IF;
3229: ELSIF x_result_out = 'COMPLETE:INCOMPLETE' THEN
3230: --bug4950878
3231: fnd_message.Set_Name('ONT', 'ONT_PAYMENT_NOT_ASSURED');
3232: oe_msg_pub.add;
3233:
3234: OE_Order_WF_Util.Update_Flow_Status_Code
3235: (p_line_id => p_line_id,
3236: p_flow_status_code => 'PAYMENT_ASSURANCE_NOT_ASSURED',

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

3262: IF l_debug_level > 0 THEN
3263: oe_debug_pub.add( 'ORACLE ERROR: ' || SQLERRM , 1 ) ;
3264: END IF;
3265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3266: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3267: THEN
3268: OE_MSG_PUB.Add_Exc_Msg
3269: ( G_PKG_NAME
3270: , 'Payment Assurance'

Line 3268: OE_MSG_PUB.Add_Exc_Msg

3264: END IF;
3265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3266: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3267: THEN
3268: OE_MSG_PUB.Add_Exc_Msg
3269: ( G_PKG_NAME
3270: , 'Payment Assurance'
3271: );
3272: END IF;

Line 3306: OE_MSG_PUB.set_msg_context(

3302: into l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
3303: l_source_document_type_id, l_source_document_id
3304: from oe_order_headers where header_id = p_header_id;
3305: -- Set message context
3306: OE_MSG_PUB.set_msg_context(
3307: p_entity_code => 'HEADER'
3308: ,p_entity_id => p_header_id
3309: ,p_header_id => p_header_id
3310: ,p_order_source_id => l_order_source_id

Line 3335: OE_MSG_PUB.Add;

3331: oe_debug_pub.add('l_new_request_id = '||l_new_request_id);
3332: End If;
3333: FND_MESSAGE.SET_NAME('ONT','ONT_CONCURRENT_REQUEST_ID');
3334: fnd_message.set_token('REQUEST_ID',l_new_request_id);
3335: OE_MSG_PUB.Add;
3336:
3337: IF (l_new_request_id = 0) THEN
3338: errbuf := FND_MESSAGE.GET;
3339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3348: oe_msg_pub.Add_Text(errbuf);

3344: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3345: If l_debug_level > 0 Then
3346: oe_debug_pub.add( 'UNEXPECTED ERROR. EXITING FROM PAYMENT RECEIPT: '||SQLERRM , 1 ) ;
3347: End If;
3348: oe_msg_pub.Add_Text(errbuf);
3349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3350:
3351: WHEN OTHERS THEN
3352: If l_debug_level > 0 Then

Line 3358: OE_MSG_PUB.Add_Exc_Msg

3354: End If;
3355: IF FND_MSG_PUB.Check_Msg_Level
3356: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3357: THEN
3358: OE_MSG_PUB.Add_Exc_Msg
3359: ( G_PKG_NAME
3360: , 'Print_Payment_Receipt'
3361: );
3362: END IF;

Line 3507: OE_MSG_PUB.Count_And_Get

3503: EXCEPTION
3504:
3505: WHEN FND_API.G_EXC_ERROR THEN
3506: x_return_status := FND_API.G_RET_STS_ERROR;
3507: OE_MSG_PUB.Count_And_Get
3508: ( p_count => x_msg_count,
3509: p_data => x_msg_data
3510: );
3511:

Line 3517: OE_MSG_PUB.Count_And_Get

3513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3514: IF l_debug_level > 0 THEN
3515: oe_debug_pub.add( 'Unexpected error in Delete_Payments: ' || SQLERRM , 3 ) ;
3516: END IF;
3517: OE_MSG_PUB.Count_And_Get
3518: ( p_count => x_msg_count,
3519: p_data => x_msg_data
3520: );
3521:

Line 3536: OE_MSG_PUB.Count_And_Get

3532: IF l_debug_level > 0 THEN
3533: oe_debug_pub.add( 'Oracle error in others in delete_payments: '||SQLERRM , 3 ) ;
3534: END IF;
3535:
3536: OE_MSG_PUB.Count_And_Get
3537: ( p_count => x_msg_count,
3538: p_data => x_msg_data
3539: );
3540: END Delete_Payments;

Line 4297: oe_msg_pub.add;

4293: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
4294: fnd_message.Set_Name('ONT', 'ONT_REFUND_PROCESS_SUCCESS');
4295: FND_MESSAGE.SET_TOKEN('AMOUNT' , TO_CHAR(p_refund_amount, l_format_mask));
4296: FND_MESSAGE.SET_TOKEN('NUMBER' , l_number_of_refund_receipts);
4297: oe_msg_pub.add;
4298: IF l_debug_level > 0 THEN
4299: oe_debug_pub.add( 'OEXVPPYB: REFUND REQUEST OF ' ||P_REFUND_AMOUNT||' HAS BEEN PROCESSED SUCCESSFULLY.' , 3 ) ;
4300: oe_debug_pub.add('pviprana: Releasing Prepayment Hold');
4301: END IF;

Line 4317: oe_msg_pub.add;

4313: END IF;
4314: ELSE
4315: fnd_message.Set_Name('ONT', 'ONT_REFUND_PROCESS_FAILED');
4316: FND_MESSAGE.SET_TOKEN('AMOUNT', TO_CHAR(p_refund_amount, l_format_mask));
4317: oe_msg_pub.add;
4318: IF l_debug_level > 0 THEN
4319: oe_debug_pub.add( 'OEXVPPYB: REFUND PROCESSING FOR ' ||P_REFUND_AMOUNT||' FAILED.' , 3 ) ;
4320: END IF;
4321:

Line 4326: oe_msg_pub.add_text(p_message_text => l_msg_data);

4322: IF l_msg_count = 1 THEN
4323: IF l_debug_level > 0 THEN
4324: oe_debug_pub.add('Error message after calling refund_prepayment_wrapper API: '||l_msg_data , 3 ) ;
4325: END IF;
4326: oe_msg_pub.add_text(p_message_text => l_msg_data);
4327: ELSIF ( FND_MSG_PUB.Count_Msg > 0 ) THEN
4328: arp_util.enable_debug;
4329: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
4330: -- l_msg_data := FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE);

Line 4335: oe_msg_pub.add_text(p_message_text => l_msg_data);

4331: l_msg_data := FND_MSG_PUB.Get(i,'F');
4332: IF l_debug_level > 0 THEN
4333: oe_debug_pub.Add( 'Error message from AR API: '|| L_MSG_DATA , 3 );
4334: END IF;
4335: oe_msg_pub.add_text(p_message_text => l_msg_data);
4336: END LOOP;
4337: END IF;
4338: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4339: RAISE FND_API.G_EXC_ERROR;

Line 4353: OE_MSG_PUB.Count_And_Get

4349: EXCEPTION
4350:
4351: WHEN FND_API.G_EXC_ERROR THEN
4352: x_return_status := FND_API.G_RET_STS_ERROR;
4353: OE_MSG_PUB.Count_And_Get
4354: ( p_count => l_msg_count,
4355: p_data => l_msg_data
4356: );
4357:

Line 4363: OE_MSG_PUB.Count_And_Get

4359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4360: IF l_debug_level > 0 THEN
4361: oe_debug_pub.add( 'Unexpected error in Create_Refund: ' || SQLERRM , 3 ) ;
4362: END IF;
4363: OE_MSG_PUB.Count_And_Get
4364: ( p_count => l_msg_count,
4365: p_data => l_msg_data
4366: );
4367:

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

4366: );
4367:
4368: WHEN OTHERS THEN
4369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4370: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4371: THEN
4372: OE_MSG_PUB.Add_Exc_Msg
4373: ( G_PKG_NAME
4374: , 'Create_Refund'

Line 4372: OE_MSG_PUB.Add_Exc_Msg

4368: WHEN OTHERS THEN
4369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4370: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4371: THEN
4372: OE_MSG_PUB.Add_Exc_Msg
4373: ( G_PKG_NAME
4374: , 'Create_Refund'
4375: );
4376: END IF;

Line 4381: OE_MSG_PUB.Count_And_Get

4377: IF l_debug_level > 0 THEN
4378: oe_debug_pub.add( 'Other oracle error in Create_Refund: ' || SQLERRM , 3 ) ;
4379: END IF;
4380:
4381: OE_MSG_PUB.Count_And_Get
4382: ( p_count => l_msg_count,
4383: p_data => l_msg_data
4384: );
4385:

Line 4464: OE_MSG_PUB.Count_And_Get

4460: EXCEPTION
4461:
4462: WHEN FND_API.G_EXC_ERROR THEN
4463: x_return_status := FND_API.G_RET_STS_ERROR;
4464: OE_MSG_PUB.Count_And_Get
4465: ( p_count => l_msg_count,
4466: p_data => l_msg_data
4467: );
4468:

Line 4471: OE_MSG_PUB.Count_And_Get

4467: );
4468:
4469: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4471: OE_MSG_PUB.Count_And_Get
4472: ( p_count => l_msg_count,
4473: p_data => l_msg_data
4474: );
4475:

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

4474: );
4475:
4476: WHEN OTHERS THEN
4477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4478: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4479: THEN
4480: OE_MSG_PUB.Add_Exc_Msg
4481: ( G_PKG_NAME
4482: , 'Process_Payment_Refund'

Line 4480: OE_MSG_PUB.Add_Exc_Msg

4476: WHEN OTHERS THEN
4477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4478: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4479: THEN
4480: OE_MSG_PUB.Add_Exc_Msg
4481: ( G_PKG_NAME
4482: , 'Process_Payment_Refund'
4483: );
4484: END IF;

Line 4486: OE_MSG_PUB.Count_And_Get

4482: , 'Process_Payment_Refund'
4483: );
4484: END IF;
4485:
4486: OE_MSG_PUB.Count_And_Get
4487: ( p_count => l_msg_count,
4488: p_data => l_msg_data
4489: );
4490:

Line 4702: OE_MSG_PUB.Count_And_Get

4698: , 'Any_Payment_Hold_Exists'
4699: );
4700: END IF;
4701:
4702: OE_MSG_PUB.Count_And_Get
4703: ( p_count => l_msg_count,
4704: p_data => l_msg_data
4705: );
4706:

Line 4782: --oe_msg_pub.add( ); --

4778: end if;
4779:
4780: Exception
4781: when no_data_found then
4782: --oe_msg_pub.add( ); --
4783: x_return_status := FND_API.G_RET_STS_ERROR;
4784: RAISE;
4785:
4786: when others then

Line 4787: --oe_msg_pub.add(); --

4783: x_return_status := FND_API.G_RET_STS_ERROR;
4784: RAISE;
4785:
4786: when others then
4787: --oe_msg_pub.add(); --
4788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4789: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4790: End;
4791:

Line 4832: --oe_msg_pub.add( ); --

4828: and payment_number is null;
4829:
4830: Exception
4831: when no_data_found then
4832: --oe_msg_pub.add( ); --
4833: x_return_status := FND_API.G_RET_STS_ERROR;
4834: RAISE;
4835: when others then
4836: --oe_msg_pub.add(); --

Line 4836: --oe_msg_pub.add(); --

4832: --oe_msg_pub.add( ); --
4833: x_return_status := FND_API.G_RET_STS_ERROR;
4834: RAISE;
4835: when others then
4836: --oe_msg_pub.add(); --
4837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4838: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4839: End;
4840:

Line 4926: OE_MSG_PUB.Count_And_Get

4922: , 'Delete_Prepayment_Hold'
4923: );
4924: END IF;
4925:
4926: OE_MSG_PUB.Count_And_Get
4927: ( p_count => l_msg_count,
4928: p_data => l_msg_data
4929: );
4930: