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 421: oe_msg_pub.add_text(p_message_text => x_msg_data);

417: IF x_msg_count = 1 THEN
418: IF l_debug_level > 0 THEN
419: oe_debug_pub.add('Error message after calling Create_Prepayment API: '||x_msg_data , 3 ) ;
420: END IF;
421: oe_msg_pub.add_text(p_message_text => x_msg_data);
422: ELSIF ( FND_MSG_PUB.Count_Msg > 0 ) THEN
423: arp_util.enable_debug;
424: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
425: -- l_msg_text := FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE);

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

426: l_msg_text := FND_MSG_PUB.Get(i,'F');
427: IF l_debug_level > 0 THEN
428: oe_debug_pub.Add( 'Error message from AR API: '|| L_MSG_TEXT , 3 );
429: END IF;
430: oe_msg_pub.add_text(p_message_text => l_msg_text);
431: END LOOP;
432: END IF;
433:
434: x_result_out := 'FAIL';

Line 455: OE_MSG_PUB.Count_And_Get

451: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
452: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , 'Create_Receipt');
453: END IF;
454:
455: OE_MSG_PUB.Count_And_Get
456: ( p_count => l_msg_count,
457: p_data => l_msg_data
458: );
459:

Line 525: oe_msg_pub.add;

521: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
522: fnd_message.Set_Name('ONT', 'ONT_REFUND_PROCESS_SUCCESS');
523: FND_MESSAGE.SET_TOKEN('AMOUNT' , TO_CHAR(p_amount * -1, l_format_mask));
524: FND_MESSAGE.SET_TOKEN('NUMBER' , l_number_of_refund_receipts);
525: oe_msg_pub.add;
526: IF l_debug_level > 0 THEN
527: oe_debug_pub.add( 'OEXVPPYB: REFUND REQUEST OF ' ||P_AMOUNT||' HAS BEEN PROCESSED SUCCESSFULLY.' , 3 ) ;
528: END IF;
529: ELSE

Line 532: oe_msg_pub.add;

528: END IF;
529: ELSE
530: fnd_message.Set_Name('ONT', 'ONT_REFUND_PROCESS_FAILED');
531: FND_MESSAGE.SET_TOKEN('AMOUNT', TO_CHAR(p_amount, l_format_mask));
532: oe_msg_pub.add;
533: IF l_debug_level > 0 THEN
534: oe_debug_pub.add( 'OEXVPPYB: REFUND PROCESSING FOR ' ||P_AMOUNT||' FAILED.' , 3 ) ;
535: END IF;
536: END IF;

Line 550: OE_MSG_PUB.Count_And_Get

546: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
547: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , 'Refund_Request');
548: END IF;
549:
550: OE_MSG_PUB.Count_And_Get
551: ( p_count => l_msg_count,
552: p_data => l_msg_data
553: );
554:

Line 781: OE_MSG_PUB.ADD;

777: --R12 CC Encryption
778:
779: EXCEPTION WHEN OTHERS THEN
780: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET');
781: OE_MSG_PUB.ADD;
782: IF l_debug_level > 0 THEN
783: oe_debug_pub.add( 'OEXVPPYB: ERROR IN ARP_BANK_PKG.PROCESS_CUST_BANK_ACCOUNT' , 3 ) ;
784: END IF;
785: -- apply epayment failure hold due to incorrect credit card information.

Line 808: OE_MSG_PUB.ADD;

804: IF l_debug_level > 0 THEN
805: oe_debug_pub.add( 'OEXVPPYB: THE PAYMENT METHOD ID IS INVALID: '||L_PAY_METHOD_ID , 3 ) ;
806: END IF;
807: FND_MESSAGE.SET_NAME('ONT','OE_VPM_NO_PAY_METHOD');
808: OE_MSG_PUB.ADD;
809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
810: RETURN;
811: END IF;
812:

Line 927: OE_MSG_PUB.ADD;

923: l_format_mask := get_format_mask(p_header_rec.transactional_curr_code);
924:
925: FND_MESSAGE.SET_NAME('ONT','ONT_PAYMENT_PROCESS_SUCESS');
926: FND_MESSAGE.SET_TOKEN('AMOUNT' , TO_CHAR(l_pending_amount, l_format_mask));
927: OE_MSG_PUB.ADD;
928:
929: IF l_debug_level > 0 THEN
930: oe_debug_pub.add( 'OEXVPPYB: RELEASING PREPAYMENT HOLD' , 3 ) ;
931: END IF;

Line 1004: l_msg_count:=OE_MSG_PUB.COUNT_MSG;

1000: -- what is the seed id for ppp hold?
1001:
1002: -- get the message count here, as we do not want to append
1003: -- the message ONT_PAYMENT_PROCESS_FAILED to the hold comments.
1004: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
1005:
1006: l_format_mask := get_format_mask(p_header_rec.transactional_curr_code);
1007:
1008: FND_MESSAGE.SET_NAME('ONT','ONT_PAYMENT_PROCESS_FAILED');

Line 1010: OE_MSG_PUB.ADD;

1006: l_format_mask := get_format_mask(p_header_rec.transactional_curr_code);
1007:
1008: FND_MESSAGE.SET_NAME('ONT','ONT_PAYMENT_PROCESS_FAILED');
1009: FND_MESSAGE.SET_TOKEN('AMOUNT' , TO_CHAR(l_pending_amount, l_format_mask));
1010: OE_MSG_PUB.ADD;
1011:
1012: -- fix for bug 4201632, get the messages and populate them
1013: -- as the hold comments.
1014: l_msg_data := null;

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

1012: -- fix for bug 4201632, get the messages and populate them
1013: -- as the hold comments.
1014: l_msg_data := null;
1015: FOR I IN 1..l_msg_count LOOP
1016: l_msg_data := l_msg_data||' '|| OE_MSG_PUB.Get(I,'F');
1017: IF l_debug_level > 0 THEN
1018: oe_debug_pub.add( L_MSG_DATA , 1 ) ;
1019: END IF;
1020: END LOOP;

Line 1141: OE_MSG_PUB.Count_And_Get

1137: EXCEPTION
1138:
1139: WHEN FND_API.G_EXC_ERROR THEN
1140: x_return_status := FND_API.G_RET_STS_ERROR;
1141: OE_MSG_PUB.Count_And_Get
1142: ( p_count => l_msg_count,
1143: p_data => l_msg_data
1144: );
1145:

Line 1148: OE_MSG_PUB.Count_And_Get

1144: );
1145:
1146: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1148: OE_MSG_PUB.Count_And_Get
1149: ( p_count => l_msg_count,
1150: p_data => l_msg_data
1151: );
1152:

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

1151: );
1152:
1153: WHEN OTHERS THEN
1154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1155: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1156: THEN
1157: OE_MSG_PUB.Add_Exc_Msg
1158: ( G_PKG_NAME
1159: , 'Process_PrePayment_Order'

Line 1157: OE_MSG_PUB.Add_Exc_Msg

1153: WHEN OTHERS THEN
1154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1155: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1156: THEN
1157: OE_MSG_PUB.Add_Exc_Msg
1158: ( G_PKG_NAME
1159: , 'Process_PrePayment_Order'
1160: );
1161: END IF;

Line 1163: OE_MSG_PUB.Count_And_Get

1159: , 'Process_PrePayment_Order'
1160: );
1161: END IF;
1162:
1163: OE_MSG_PUB.Count_And_Get
1164: ( p_count => l_msg_count,
1165: p_data => l_msg_data
1166: );
1167:

Line 1266: OE_MSG_PUB.Count_And_Get

1262: , 'Any_Prepayment_Hold_Exists'
1263: );
1264: END IF;
1265:
1266: OE_MSG_PUB.Count_And_Get
1267: ( p_count => l_msg_count,
1268: p_data => l_msg_data
1269: );
1270:

Line 1347: OE_MSG_PUB.ADD;

1343:
1344: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1345: IF p_hold_id = 13 THEN
1346: FND_MESSAGE.SET_NAME('ONT','ONT_PPP_HOLD_APPLIED');
1347: OE_MSG_PUB.ADD;
1348: IF l_debug_level > 0 THEN
1349: oe_debug_pub.add( 'OEXVPPYB: PPP Hold has been applied on order.', 3 ) ;
1350: END IF;
1351: ELSIF p_hold_id = 14 THEN

Line 1353: OE_MSG_PUB.ADD;

1349: oe_debug_pub.add( 'OEXVPPYB: PPP Hold has been applied on order.', 3 ) ;
1350: END IF;
1351: ELSIF p_hold_id = 14 THEN
1352: FND_MESSAGE.SET_NAME('ONT','ONT_PAYMENT_FAILURE_HOLD');
1353: OE_MSG_PUB.ADD;
1354: IF l_debug_level > 0 THEN
1355: oe_debug_pub.add( 'OEXVPPYB: payment failure hold has been applied on order.', 3 ) ;
1356: END IF;
1357: ELSIF p_hold_id = 15 THEN

Line 1359: OE_MSG_PUB.ADD;

1355: oe_debug_pub.add( 'OEXVPPYB: payment failure hold has been applied on order.', 3 ) ;
1356: END IF;
1357: ELSIF p_hold_id = 15 THEN
1358: FND_MESSAGE.SET_NAME('ONT','ONT_PAYMENT_SERVER_FAIL_HOLD');
1359: OE_MSG_PUB.ADD;
1360: IF l_debug_level > 0 THEN
1361: oe_debug_pub.add( 'OEXVPPYB: payment server failure hold has been applied on order.', 3 ) ;
1362: END IF;
1363: END IF;

Line 1379: OE_MSG_PUB.Count_And_Get

1375: EXCEPTION
1376:
1377: WHEN FND_API.G_EXC_ERROR THEN
1378: p_return_status := FND_API.G_RET_STS_ERROR;
1379: OE_MSG_PUB.Count_And_Get
1380: ( p_count => l_msg_count,
1381: p_data => l_msg_data
1382: );
1383:

Line 1386: OE_MSG_PUB.Count_And_Get

1382: );
1383:
1384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1385: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1386: OE_MSG_PUB.Count_And_Get
1387: ( p_count => l_msg_count,
1388: p_data => l_msg_data
1389: );
1390:

Line 1401: OE_MSG_PUB.Count_And_Get

1397: , 'Apply_Prepayment_Hold'
1398: );
1399: END IF;
1400:
1401: OE_MSG_PUB.Count_And_Get
1402: ( p_count => l_msg_count,
1403: p_data => l_msg_data
1404: );
1405:

Line 1486: oe_msg_pub.add;

1482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1483: END IF;
1484: --bug3599715 start
1485: fnd_message.Set_Name('ONT', 'ONT_PPP_HOLD_RELEASED');
1486: oe_msg_pub.add;
1487: --bug3599715 end
1488: END IF;
1489:
1490: -- check for epayment failure hold.

Line 1529: oe_msg_pub.add;

1525: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1527: END IF;
1528: fnd_message.Set_Name('ONT', 'ONT_PMNT_FAIL_HOLD_RELEASED');
1529: oe_msg_pub.add;
1530: END IF;
1531:
1532: -- check for epayment server failure hold.
1533: l_hold_id := 15 ;

Line 1571: oe_msg_pub.add;

1567: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1569: END IF;
1570: fnd_message.Set_Name('ONT', 'ONT_PMNT_SERVER_HOLD_RELEASED');
1571: oe_msg_pub.add;
1572: END IF;
1573:
1574: EXCEPTION
1575:

Line 1578: OE_MSG_PUB.Count_And_Get

1574: EXCEPTION
1575:
1576: WHEN FND_API.G_EXC_ERROR THEN
1577: p_return_status := FND_API.G_RET_STS_ERROR;
1578: OE_MSG_PUB.Count_And_Get
1579: ( p_count => l_msg_count,
1580: p_data => l_msg_data
1581: );
1582:

Line 1585: OE_MSG_PUB.Count_And_Get

1581: );
1582:
1583: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1584: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1585: OE_MSG_PUB.Count_And_Get
1586: ( p_count => l_msg_count,
1587: p_data => l_msg_data
1588: );
1589:

Line 1600: OE_MSG_PUB.Count_And_Get

1596: , 'Release_Prepayment_Hold'
1597: );
1598: END IF;
1599:
1600: OE_MSG_PUB.Count_And_Get
1601: ( p_count => l_msg_count,
1602: p_data => l_msg_data
1603: );
1604:

Line 1694: OE_MSG_PUB.Count_And_Get

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

Line 1701: OE_MSG_PUB.Count_And_Get

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

Line 1716: OE_MSG_PUB.Count_And_Get

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

Line 2047: oe_msg_pub.Add;

2043: IF l_receipt_method_id =0 THEN
2044: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
2045: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Receipt Method');
2046: oe_debug_pub.add('OEXVPPYB: receipt method is null.',3);
2047: oe_msg_pub.Add;
2048: RAISE FND_API.G_EXC_ERROR;
2049:
2050: ELSE
2051: -- receipt method is not null

Line 2146: l_msg_count:=OE_MSG_PUB.COUNT_MSG;

2142: END IF;
2143:
2144: -- get the message count here, as we do not want to append
2145: -- the message ONT_PAYMENT_PROCESS_FAILED to the hold comments.
2146: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
2147:
2148: -- fix for bug 4201632, get the messages and populate them
2149: -- as the hold comments.
2150: l_msg_data := null;

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

2148: -- fix for bug 4201632, get the messages and populate them
2149: -- as the hold comments.
2150: l_msg_data := null;
2151: FOR I IN 1..l_msg_count LOOP
2152: l_msg_data := l_msg_data||' '|| OE_MSG_PUB.Get(I,'F');
2153: IF l_debug_level > 0 THEN
2154: oe_debug_pub.add( L_MSG_DATA , 1 ) ;
2155: END IF;
2156: END LOOP;

Line 2226: l_msg_count:=OE_MSG_PUB.COUNT_MSG;

2222: IF l_debug_level > 0 THEN
2223: oe_debug_pub.add( 'after create_refund, applying payment failure hold.', 3 ) ;
2224: END IF;
2225:
2226: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
2227:
2228: -- fix for bug 4201632, get the messages and populate them
2229: -- as the hold comments.
2230: l_msg_data := null;

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

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

Line 2321: x_msg_count := OE_MSG_PUB.Count_Msg;

2317: IF l_debug_level > 0 THEN
2318: oe_debug_pub.add( 'OEXVPPYB: No rule defined for authorization. ' ) ;
2319: END IF;
2320: --bug3511992
2321: x_msg_count := OE_MSG_PUB.Count_Msg;
2322:
2323: oe_debug_pub.add('pviprana: x_msg_count in OEXVPPYB.pls = ' || x_msg_count);
2324: RETURN;
2325: END IF;

Line 2379: x_msg_count := OE_MSG_PUB.Count_Msg;

2375: END IF;
2376:
2377: IF l_rule_defined = 'N' THEN
2378: --bug3511992
2379: x_msg_count := OE_MSG_PUB.Count_Msg;
2380:
2381: oe_debug_pub.add('pviprana: x_msg_count in OEXVPPYB.pls = ' || x_msg_count);
2382:
2383: return;

Line 2455: x_msg_count := OE_MSG_PUB.Count_Msg;

2451: g_process_pmt_req_logged := 'N';
2452: END IF;
2453:
2454: --bug3511992
2455: x_msg_count := OE_MSG_PUB.Count_Msg;
2456:
2457: oe_debug_pub.add('pviprana: x_msg_count in OEXVPPYB.pls = ' || x_msg_count);
2458:
2459: x_return_status := l_return_status;

Line 2469: OE_MSG_PUB.Count_And_Get

2465: EXCEPTION
2466:
2467: WHEN FND_API.G_EXC_ERROR THEN
2468: x_return_status := FND_API.G_RET_STS_ERROR;
2469: OE_MSG_PUB.Count_And_Get
2470: ( p_count => l_msg_count,
2471: p_data => l_msg_data
2472: );
2473:

Line 2479: OE_MSG_PUB.Count_And_Get

2475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2476: IF l_debug_level > 0 THEN
2477: oe_debug_pub.add( 'Unexpected error in Process_Payments: ' || SQLERRM , 3 ) ;
2478: END IF;
2479: OE_MSG_PUB.Count_And_Get
2480: ( p_count => l_msg_count,
2481: p_data => l_msg_data
2482: );
2483:

Line 2498: OE_MSG_PUB.Count_And_Get

2494: IF l_debug_level > 0 THEN
2495: oe_debug_pub.add( 'Oracle error in others in process_payments: '||SQLERRM , 3 ) ;
2496: END IF;
2497:
2498: OE_MSG_PUB.Count_And_Get
2499: ( p_count => l_msg_count,
2500: p_data => l_msg_data
2501: );
2502:

Line 2670: OE_Msg_Pub.Add;

2666: -- bug 5204275
2667: IF Oe_Payment_Trxn_Util.Get_CC_Security_Code_Use = 'REQUIRED'
2668: AND l_is_credit_card = 'Y' THEN
2669: FND_MESSAGE.SET_NAME('ONT','OE_CC_CVV2_REQD_FOR_SPLIT');
2670: OE_Msg_Pub.Add;
2671: END IF;
2672:
2673: I := l_line_payment_tbl.FIRST;
2674: WHILE I IS NOT NULL LOOP

Line 2708: OE_MSG_PUB.Add_Exc_Msg

2704:
2705: WHEN OTHERS THEN
2706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2707: If FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) Then
2708: OE_MSG_PUB.Add_Exc_Msg
2709: ( G_PKG_NAME
2710: , 'Split_Payment '
2711: );
2712: End If;

Line 2969: oe_msg_pub.add;

2965: oe_debug_pub.add('No Pay now payment instrument. setting x_result_out to INCOMPLETE and returning from the procedure');
2966: END IF;
2967: --bug4950878
2968: fnd_message.Set_Name('ONT', 'ONT_PAYNOW_PMT_NOT_ASSURED');
2969: oe_msg_pub.add;
2970:
2971: x_result_out := 'COMPLETE:INCOMPLETE';
2972: OE_Order_WF_Util.Update_Flow_Status_Code
2973: (p_line_id => p_line_id

Line 3098: oe_msg_pub.add;

3094: END IF;
3095: ELSIF x_result_out = 'COMPLETE:INCOMPLETE' THEN
3096: --bug4950878
3097: fnd_message.Set_Name('ONT', 'ONT_PAYMENT_NOT_ASSURED');
3098: oe_msg_pub.add;
3099:
3100: OE_Order_WF_Util.Update_Flow_Status_Code
3101: (p_line_id => p_line_id,
3102: p_flow_status_code => 'PAYMENT_ASSURANCE_NOT_ASSURED',

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

3128: IF l_debug_level > 0 THEN
3129: oe_debug_pub.add( 'ORACLE ERROR: ' || SQLERRM , 1 ) ;
3130: END IF;
3131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3132: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3133: THEN
3134: OE_MSG_PUB.Add_Exc_Msg
3135: ( G_PKG_NAME
3136: , 'Payment Assurance'

Line 3134: OE_MSG_PUB.Add_Exc_Msg

3130: END IF;
3131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3132: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3133: THEN
3134: OE_MSG_PUB.Add_Exc_Msg
3135: ( G_PKG_NAME
3136: , 'Payment Assurance'
3137: );
3138: END IF;

Line 3172: OE_MSG_PUB.set_msg_context(

3168: into l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
3169: l_source_document_type_id, l_source_document_id
3170: from oe_order_headers where header_id = p_header_id;
3171: -- Set message context
3172: OE_MSG_PUB.set_msg_context(
3173: p_entity_code => 'HEADER'
3174: ,p_entity_id => p_header_id
3175: ,p_header_id => p_header_id
3176: ,p_order_source_id => l_order_source_id

Line 3201: OE_MSG_PUB.Add;

3197: oe_debug_pub.add('l_new_request_id = '||l_new_request_id);
3198: End If;
3199: FND_MESSAGE.SET_NAME('ONT','ONT_CONCURRENT_REQUEST_ID');
3200: fnd_message.set_token('REQUEST_ID',l_new_request_id);
3201: OE_MSG_PUB.Add;
3202:
3203: IF (l_new_request_id = 0) THEN
3204: errbuf := FND_MESSAGE.GET;
3205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3214: oe_msg_pub.Add_Text(errbuf);

3210: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3211: If l_debug_level > 0 Then
3212: oe_debug_pub.add( 'UNEXPECTED ERROR. EXITING FROM PAYMENT RECEIPT: '||SQLERRM , 1 ) ;
3213: End If;
3214: oe_msg_pub.Add_Text(errbuf);
3215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3216:
3217: WHEN OTHERS THEN
3218: If l_debug_level > 0 Then

Line 3224: OE_MSG_PUB.Add_Exc_Msg

3220: End If;
3221: IF FND_MSG_PUB.Check_Msg_Level
3222: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3223: THEN
3224: OE_MSG_PUB.Add_Exc_Msg
3225: ( G_PKG_NAME
3226: , 'Print_Payment_Receipt'
3227: );
3228: END IF;

Line 3373: OE_MSG_PUB.Count_And_Get

3369: EXCEPTION
3370:
3371: WHEN FND_API.G_EXC_ERROR THEN
3372: x_return_status := FND_API.G_RET_STS_ERROR;
3373: OE_MSG_PUB.Count_And_Get
3374: ( p_count => x_msg_count,
3375: p_data => x_msg_data
3376: );
3377:

Line 3383: OE_MSG_PUB.Count_And_Get

3379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3380: IF l_debug_level > 0 THEN
3381: oe_debug_pub.add( 'Unexpected error in Delete_Payments: ' || SQLERRM , 3 ) ;
3382: END IF;
3383: OE_MSG_PUB.Count_And_Get
3384: ( p_count => x_msg_count,
3385: p_data => x_msg_data
3386: );
3387:

Line 3402: OE_MSG_PUB.Count_And_Get

3398: IF l_debug_level > 0 THEN
3399: oe_debug_pub.add( 'Oracle error in others in delete_payments: '||SQLERRM , 3 ) ;
3400: END IF;
3401:
3402: OE_MSG_PUB.Count_And_Get
3403: ( p_count => x_msg_count,
3404: p_data => x_msg_data
3405: );
3406: END Delete_Payments;

Line 4163: oe_msg_pub.add;

4159: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
4160: fnd_message.Set_Name('ONT', 'ONT_REFUND_PROCESS_SUCCESS');
4161: FND_MESSAGE.SET_TOKEN('AMOUNT' , TO_CHAR(p_refund_amount, l_format_mask));
4162: FND_MESSAGE.SET_TOKEN('NUMBER' , l_number_of_refund_receipts);
4163: oe_msg_pub.add;
4164: IF l_debug_level > 0 THEN
4165: oe_debug_pub.add( 'OEXVPPYB: REFUND REQUEST OF ' ||P_REFUND_AMOUNT||' HAS BEEN PROCESSED SUCCESSFULLY.' , 3 ) ;
4166: oe_debug_pub.add('pviprana: Releasing Prepayment Hold');
4167: END IF;

Line 4183: oe_msg_pub.add;

4179: END IF;
4180: ELSE
4181: fnd_message.Set_Name('ONT', 'ONT_REFUND_PROCESS_FAILED');
4182: FND_MESSAGE.SET_TOKEN('AMOUNT', TO_CHAR(p_refund_amount, l_format_mask));
4183: oe_msg_pub.add;
4184: IF l_debug_level > 0 THEN
4185: oe_debug_pub.add( 'OEXVPPYB: REFUND PROCESSING FOR ' ||P_REFUND_AMOUNT||' FAILED.' , 3 ) ;
4186: END IF;
4187:

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

4188: IF l_msg_count = 1 THEN
4189: IF l_debug_level > 0 THEN
4190: oe_debug_pub.add('Error message after calling refund_prepayment_wrapper API: '||l_msg_data , 3 ) ;
4191: END IF;
4192: oe_msg_pub.add_text(p_message_text => l_msg_data);
4193: ELSIF ( FND_MSG_PUB.Count_Msg > 0 ) THEN
4194: arp_util.enable_debug;
4195: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
4196: -- l_msg_data := FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE);

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

4197: l_msg_data := FND_MSG_PUB.Get(i,'F');
4198: IF l_debug_level > 0 THEN
4199: oe_debug_pub.Add( 'Error message from AR API: '|| L_MSG_DATA , 3 );
4200: END IF;
4201: oe_msg_pub.add_text(p_message_text => l_msg_data);
4202: END LOOP;
4203: END IF;
4204: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4205: RAISE FND_API.G_EXC_ERROR;

Line 4219: OE_MSG_PUB.Count_And_Get

4215: EXCEPTION
4216:
4217: WHEN FND_API.G_EXC_ERROR THEN
4218: x_return_status := FND_API.G_RET_STS_ERROR;
4219: OE_MSG_PUB.Count_And_Get
4220: ( p_count => l_msg_count,
4221: p_data => l_msg_data
4222: );
4223:

Line 4229: OE_MSG_PUB.Count_And_Get

4225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4226: IF l_debug_level > 0 THEN
4227: oe_debug_pub.add( 'Unexpected error in Create_Refund: ' || SQLERRM , 3 ) ;
4228: END IF;
4229: OE_MSG_PUB.Count_And_Get
4230: ( p_count => l_msg_count,
4231: p_data => l_msg_data
4232: );
4233:

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

4232: );
4233:
4234: WHEN OTHERS THEN
4235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4236: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4237: THEN
4238: OE_MSG_PUB.Add_Exc_Msg
4239: ( G_PKG_NAME
4240: , 'Create_Refund'

Line 4238: OE_MSG_PUB.Add_Exc_Msg

4234: WHEN OTHERS THEN
4235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4236: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4237: THEN
4238: OE_MSG_PUB.Add_Exc_Msg
4239: ( G_PKG_NAME
4240: , 'Create_Refund'
4241: );
4242: END IF;

Line 4247: OE_MSG_PUB.Count_And_Get

4243: IF l_debug_level > 0 THEN
4244: oe_debug_pub.add( 'Other oracle error in Create_Refund: ' || SQLERRM , 3 ) ;
4245: END IF;
4246:
4247: OE_MSG_PUB.Count_And_Get
4248: ( p_count => l_msg_count,
4249: p_data => l_msg_data
4250: );
4251:

Line 4330: OE_MSG_PUB.Count_And_Get

4326: EXCEPTION
4327:
4328: WHEN FND_API.G_EXC_ERROR THEN
4329: x_return_status := FND_API.G_RET_STS_ERROR;
4330: OE_MSG_PUB.Count_And_Get
4331: ( p_count => l_msg_count,
4332: p_data => l_msg_data
4333: );
4334:

Line 4337: OE_MSG_PUB.Count_And_Get

4333: );
4334:
4335: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4337: OE_MSG_PUB.Count_And_Get
4338: ( p_count => l_msg_count,
4339: p_data => l_msg_data
4340: );
4341:

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

4340: );
4341:
4342: WHEN OTHERS THEN
4343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4344: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4345: THEN
4346: OE_MSG_PUB.Add_Exc_Msg
4347: ( G_PKG_NAME
4348: , 'Process_Payment_Refund'

Line 4346: OE_MSG_PUB.Add_Exc_Msg

4342: WHEN OTHERS THEN
4343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4344: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4345: THEN
4346: OE_MSG_PUB.Add_Exc_Msg
4347: ( G_PKG_NAME
4348: , 'Process_Payment_Refund'
4349: );
4350: END IF;

Line 4352: OE_MSG_PUB.Count_And_Get

4348: , 'Process_Payment_Refund'
4349: );
4350: END IF;
4351:
4352: OE_MSG_PUB.Count_And_Get
4353: ( p_count => l_msg_count,
4354: p_data => l_msg_data
4355: );
4356:

Line 4568: OE_MSG_PUB.Count_And_Get

4564: , 'Any_Payment_Hold_Exists'
4565: );
4566: END IF;
4567:
4568: OE_MSG_PUB.Count_And_Get
4569: ( p_count => l_msg_count,
4570: p_data => l_msg_data
4571: );
4572:

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

4644: end if;
4645:
4646: Exception
4647: when no_data_found then
4648: --oe_msg_pub.add( ); --
4649: x_return_status := FND_API.G_RET_STS_ERROR;
4650: RAISE;
4651:
4652: when others then

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

4649: x_return_status := FND_API.G_RET_STS_ERROR;
4650: RAISE;
4651:
4652: when others then
4653: --oe_msg_pub.add(); --
4654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4656: End;
4657:

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

4694: and payment_number is null;
4695:
4696: Exception
4697: when no_data_found then
4698: --oe_msg_pub.add( ); --
4699: x_return_status := FND_API.G_RET_STS_ERROR;
4700: RAISE;
4701: when others then
4702: --oe_msg_pub.add(); --

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

4698: --oe_msg_pub.add( ); --
4699: x_return_status := FND_API.G_RET_STS_ERROR;
4700: RAISE;
4701: when others then
4702: --oe_msg_pub.add(); --
4703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4705: End;
4706:

Line 4792: OE_MSG_PUB.Count_And_Get

4788: , 'Delete_Prepayment_Hold'
4789: );
4790: END IF;
4791:
4792: OE_MSG_PUB.Count_And_Get
4793: ( p_count => l_msg_count,
4794: p_data => l_msg_data
4795: );
4796: