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

Line 272: --oe_msg_pub.add_text(p_message_text => l_response_code.result_message);

268: X_msg_data => l_msg_data,
269: p_card_instrument => l_credit_card_rec,
270: x_response => l_response_code
271: );
272: --oe_msg_pub.add_text(p_message_text => l_response_code.result_message);
273: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
274: IF l_debug_level > 0 THEN
275: oe_debug_pub.add('Result error code in Update_Card exp'||l_response_code.result_code);
276: END IF;

Line 364: --oe_msg_pub.add_text(p_message_text => l_response_code.result_message);

360: P_assignment_attribs => l_assignment_attribs,
361: X_assign_id => l_assign_id,
362: X_response => l_response_code
363: );
364: --oe_msg_pub.add_text(p_message_text => l_response_code.result_message);
365:
366: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
367: IF l_debug_level > 0 THEN
368: oe_debug_pub.add('Result error code in Process_Credit_Card -->'||l_response_code.result_code);

Line 372: OE_MSG_PUB.ADD;

368: oe_debug_pub.add('Result error code in Process_Credit_Card -->'||l_response_code.result_code);
369: END IF;
370: IF l_response_code.result_code = 'INVALID_CARD_NUMBER' THEN
371: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET');
372: OE_MSG_PUB.ADD;
373: IF l_debug_level > 0 THEN
374: oe_debug_pub.add( 'OEXUPTXB: Invalid card number or expiration date' ) ;
375: END IF;
376: ELSIF l_response_code.result_code = 'INVALID_ADDRESS' THEN

Line 378: OE_MSG_PUB.ADD;

374: oe_debug_pub.add( 'OEXUPTXB: Invalid card number or expiration date' ) ;
375: END IF;
376: ELSIF l_response_code.result_code = 'INVALID_ADDRESS' THEN
377: FND_MESSAGE.SET_NAME('ONT','OE_CC_BILL_TO_ADDRESS_INVALID');
378: OE_MSG_PUB.ADD;
379: IF l_debug_level > 0 THEN
380: oe_debug_pub.add( 'OEXUPTXB: Invalid billing address' ) ;
381: END IF;
382: ELSIF l_response_code.result_code = 'INVALID_CARD_ISSUER' THEN

Line 384: OE_MSG_PUB.ADD;

380: oe_debug_pub.add( 'OEXUPTXB: Invalid billing address' ) ;
381: END IF;
382: ELSIF l_response_code.result_code = 'INVALID_CARD_ISSUER' THEN
383: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET'); --bug 5012613
384: OE_MSG_PUB.ADD;
385: IF l_debug_level > 0 THEN
386: oe_debug_pub.add( 'OEXUPTXB: Invalid billing address' ) ;
387: END IF;
388: ELSE --Setting a generic message bug 5244099

Line 390: OE_MSG_PUB.ADD;

386: oe_debug_pub.add( 'OEXUPTXB: Invalid billing address' ) ;
387: END IF;
388: ELSE --Setting a generic message bug 5244099
389: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET');
390: OE_MSG_PUB.ADD;
391: IF l_debug_level > 0 THEN
392: oe_debug_pub.add( 'OEXUPTXB: Setting the generic message' ) ;
393: END IF;
394: END IF;

Line 398: OE_MSG_PUB.ADD;

394: END IF;
395: RAISE FND_API.G_EXC_ERROR;
396: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
397: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET'); --bug 5244099
398: OE_MSG_PUB.ADD;
399: IF l_debug_level > 0 THEN
400: oe_debug_pub.add('Unexpected result error code in Process_Credit_Card-->'||l_response_code.result_code);
401: END IF;
402: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 539: --oe_msg_pub.add_text(p_message_text => l_response_code.result_message);

535: P_trxn_attribs => l_trxn_attribs,
536: x_entity_id => l_trxn_extension_id,
537: X_response => l_response_code);
538:
539: --oe_msg_pub.add_text(p_message_text => l_response_code.result_message);
540:
541: IF l_debug_level > 0 THEN
542: oe_debug_pub.add('After calling Create_Transaction_Extension'||l_trxn_extension_id);
543: oe_debug_pub.add('Result code'||l_Response_code.result_code);

Line 597: OE_MSG_PUB.Count_And_Get

593: oe_debug_pub.add('Error'||l_err_message);
594: END IF;
595:
596: X_return_status := FND_API.G_RET_STS_ERROR;
597: OE_MSG_PUB.Count_And_Get
598: ( p_count => l_msg_count,
599: p_data => l_msg_data
600: );
601: RAISE FND_API.G_EXC_ERROR;

Line 613: OE_MSG_PUB.Count_And_Get

609: oe_debug_pub.add('f Error'||l_err_message);
610: END IF;
611:
612: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
613: OE_MSG_PUB.Count_And_Get
614: ( p_count => l_msg_count,
615: p_data => l_msg_data
616: );
617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 637: OE_MSG_PUB.Count_And_Get

633: , 'OE_PAYMENT_TRXN_UTIL'
634: );
635: END IF;
636:
637: OE_MSG_PUB.Count_And_Get
638: ( p_count => l_msg_count,
639: p_data => l_msg_data
640: );
641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 852: --oe_msg_pub.add_text(p_message_text => l_response_code.result_message);

848: P_assignment_attribs => l_assignment_attribs,
849: X_assign_id => l_assign_id,
850: X_response => l_response_code);
851:
852: --oe_msg_pub.add_text(p_message_text => l_response_code.result_message);
853:
854: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
855: IF l_debug_level > 0 THEN
856: oe_debug_pub.add('Result error code in Set_Payer_Instr_Assignment'||l_response_code.result_code);

Line 860: OE_MSG_PUB.ADD;

856: oe_debug_pub.add('Result error code in Set_Payer_Instr_Assignment'||l_response_code.result_code);
857: END IF;
858: IF l_response_code.result_code = 'INVALID_CARD_NUMBER' THEN
859: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET');
860: OE_MSG_PUB.ADD;
861: IF l_debug_level > 0 THEN
862: oe_debug_pub.add( 'OEXUPTXB: Invalid card number or expiration date' ) ;
863: END IF;
864: ELSIF l_response_code.result_code = 'INVALID_ADDRESS' THEN

Line 866: OE_MSG_PUB.ADD;

862: oe_debug_pub.add( 'OEXUPTXB: Invalid card number or expiration date' ) ;
863: END IF;
864: ELSIF l_response_code.result_code = 'INVALID_ADDRESS' THEN
865: FND_MESSAGE.SET_NAME('ONT','OE_CC_BILL_TO_ADDRESS_INVALID');
866: OE_MSG_PUB.ADD;
867: IF l_debug_level > 0 THEN
868: oe_debug_pub.add( 'OEXUPTXB: Invalid billing address' ) ;
869: END IF;
870: ELSIF l_response_code.result_code = 'INVALID_CARD_ISSUER' THEN

Line 872: OE_MSG_PUB.ADD;

868: oe_debug_pub.add( 'OEXUPTXB: Invalid billing address' ) ;
869: END IF;
870: ELSIF l_response_code.result_code = 'INVALID_CARD_ISSUER' THEN
871: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET'); --bug 5012613
872: OE_MSG_PUB.ADD;
873: IF l_debug_level > 0 THEN
874: oe_debug_pub.add( 'OEXUPTXB: Invalid billing address' ) ;
875: END IF;
876: END IF;

Line 921: --oe_msg_pub.add_text(p_message_text => l_response_code.result_message);

917: X_msg_data => l_msg_data,
918: p_card_instrument => l_credit_card_rec,
919: x_response => l_response_code
920: );
921: --oe_msg_pub.add_text(p_message_text => l_response_code.result_message);
922:
923: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
924: IF l_debug_level > 0 THEN
925: oe_debug_pub.add('Result error code in Update_Card exp'||l_response_code.result_code);

Line 1014: --oe_msg_pub.add_text(p_message_text => l_response_code.result_message);

1010: P_assignment_attribs => l_assignment_attribs,
1011: X_assign_id => l_assign_id,
1012: X_response => l_response_code);
1013:
1014: --oe_msg_pub.add_text(p_message_text => l_response_code.result_message);
1015:
1016: IF l_debug_level > 0 THEN
1017: oe_debug_pub.add('After call to process credit card....');
1018: END IF;

Line 1027: OE_MSG_PUB.ADD;

1023: oe_debug_pub.add('Result error code in Process_Credit_Card -->'||l_response_code.result_code);
1024: END IF;
1025: IF l_response_code.result_code = 'INVALID_CARD_NUMBER' THEN
1026: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET');
1027: OE_MSG_PUB.ADD;
1028: IF l_debug_level > 0 THEN
1029: oe_debug_pub.add( 'OEXUPTXB: Invalid card number or expiration date' ) ;
1030: END IF;
1031: ELSIF l_response_code.result_code = 'INVALID_ADDRESS' THEN

Line 1033: OE_MSG_PUB.ADD;

1029: oe_debug_pub.add( 'OEXUPTXB: Invalid card number or expiration date' ) ;
1030: END IF;
1031: ELSIF l_response_code.result_code = 'INVALID_ADDRESS' THEN
1032: FND_MESSAGE.SET_NAME('ONT','OE_CC_BILL_TO_ADDRESS_INVALID');
1033: OE_MSG_PUB.ADD;
1034: IF l_debug_level > 0 THEN
1035: oe_debug_pub.add( 'OEXUPTXB: Invalid billing address' ) ;
1036: END IF;
1037: ELSIF l_response_code.result_code = 'INVALID_CARD_ISSUER' THEN

Line 1039: OE_MSG_PUB.ADD;

1035: oe_debug_pub.add( 'OEXUPTXB: Invalid billing address' ) ;
1036: END IF;
1037: ELSIF l_response_code.result_code = 'INVALID_CARD_ISSUER' THEN
1038: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET'); --bug 5012613
1039: OE_MSG_PUB.ADD;
1040: IF l_debug_level > 0 THEN
1041: oe_debug_pub.add( 'OEXUPTXB: Invalid billing address' ) ;
1042: END IF;
1043: ELSE --Setting a generic message bug 5244099

Line 1045: OE_MSG_PUB.ADD;

1041: oe_debug_pub.add( 'OEXUPTXB: Invalid billing address' ) ;
1042: END IF;
1043: ELSE --Setting a generic message bug 5244099
1044: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET');
1045: OE_MSG_PUB.ADD;
1046: IF l_debug_level > 0 THEN
1047: oe_debug_pub.add( 'OEXUPTXB: Setting the generic message' ) ;
1048: END IF;
1049: END IF;

Line 1053: OE_MSG_PUB.ADD;

1049: END IF;
1050: RAISE FND_API.G_EXC_ERROR;
1051: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1052: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET'); --bug 5244099
1053: OE_MSG_PUB.ADD;
1054: IF l_debug_level > 0 THEN
1055: oe_debug_pub.add('Unexpected result error code in Process_Credit_Card-->'||l_response_code.result_code);
1056: END IF;
1057: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1200: OE_Msg_Pub.Add;

1196: OE_GLOBALS.Equal(l_trxn_attribs.Instrument_Security_Code,FND_API.G_MISS_CHAR))
1197: THEN
1198:
1199: FND_MESSAGE.SET_NAME('ONT','OE_CC_SECURITY_CODE_REQD');
1200: OE_Msg_Pub.Add;
1201: RAISE FND_API.G_EXC_ERROR;
1202:
1203: ELSIF Oe_Payment_Trxn_Util.Get_CC_Security_Code_Use = 'REQUIRED'
1204: AND l_trxn_attribs.Instrument_Security_Code IS NOT NULL

Line 1315: --oe_msg_pub.add_text(p_message_text => l_response_code.result_message);

1311: P_trxn_attribs => l_trxn_attribs,
1312: x_entity_id => l_trxn_extension_id,
1313: X_response => l_response_code);
1314:
1315: --oe_msg_pub.add_text(p_message_text => l_response_code.result_message);
1316:
1317: IF l_debug_level > 0 THEN
1318: oe_debug_pub.add('After calling Create_Transaction_Extension'||l_trxn_extension_id);
1319: oe_debug_pub.add('Result code'||l_Response_code.result_code);

Line 1382: --oe_msg_pub.add_text(p_message_text => l_response_code.result_message);

1378: x_response => l_response_code,
1379: p_pmt_channel => L_pmt_channel_code,
1380: p_instr_assignment => l_assign_id);
1381:
1382: --oe_msg_pub.add_text(p_message_text => l_response_code.result_message);
1383:
1384: IF l_debug_level > 0 THEN
1385: oe_debug_pub.add('After calling update transaction extension...');
1386: END IF;

Line 1470: OE_Msg_Pub.Add;

1466: --has been brought in. Since the CVV2 value used here
1467: --would be of the previous cards', displaying this message
1468: --to the user.
1469: FND_MESSAGE.SET_NAME('ONT','OE_CC_SECURITY_CODE_REQD');
1470: OE_Msg_Pub.Add;
1471: END IF;*/
1472: END IF;
1473: --Now setting the account site id as the new bill to site
1474: --for creating this trxn extension id

Line 1503: --oe_msg_pub.add_text(p_message_text => l_response_code.result_message);

1499: P_trxn_attribs => l_trxn_attribs,
1500: x_entity_id => l_trxn_extension_id,
1501: X_response => l_response_code);
1502:
1503: --oe_msg_pub.add_text(p_message_text => l_response_code.result_message);
1504:
1505: IF l_debug_level > 0 THEN
1506: oe_debug_pub.add('After calling Create_Transaction_Extension'||l_trxn_extension_id);
1507: oe_debug_pub.add('Result code'||l_Response_code.result_code);

Line 1546: OE_MSG_PUB.Count_And_Get

1542: EXCEPTION
1543:
1544: WHEN FND_API.G_EXC_ERROR THEN
1545: X_return_status := FND_API.G_RET_STS_ERROR;
1546: OE_MSG_PUB.Count_And_Get
1547: ( p_count => l_msg_count,
1548: p_data => l_msg_data
1549: );
1550: RAISE FND_API.G_EXC_ERROR;

Line 1554: OE_MSG_PUB.Count_And_Get

1550: RAISE FND_API.G_EXC_ERROR;
1551:
1552: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1553: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1554: OE_MSG_PUB.Count_And_Get
1555: ( p_count => l_msg_count,
1556: p_data => l_msg_data
1557: );
1558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1570: OE_MSG_PUB.Count_And_Get

1566: , 'OE_PAYMENT_TRXN_UTIL'
1567: );
1568: END IF;
1569:
1570: OE_MSG_PUB.Count_And_Get
1571: ( p_count => l_msg_count,
1572: p_data => l_msg_data
1573: );
1574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1818: OE_MSG_PUB.Count_And_Get

1814: oe_debug_pub.add('Error'||l_err_message);
1815: END IF;
1816:
1817: X_return_status := FND_API.G_RET_STS_ERROR;
1818: OE_MSG_PUB.Count_And_Get
1819: ( p_count => l_msg_count,
1820: p_data => l_msg_data
1821: );
1822: RAISE FND_API.G_EXC_ERROR;

Line 1833: OE_MSG_PUB.Count_And_Get

1829: oe_debug_pub.add('f Error'||l_err_message);
1830: END IF;
1831:
1832: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1833: OE_MSG_PUB.Count_And_Get
1834: ( p_count => l_msg_count,
1835: p_data => l_msg_data
1836: );
1837: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1857: OE_MSG_PUB.Count_And_Get

1853: , 'OE_PAYMENT_TRXN_UTIL'
1854: );
1855: END IF;
1856:
1857: OE_MSG_PUB.Count_And_Get
1858: ( p_count => l_msg_count,
1859: p_data => l_msg_data
1860: );
1861: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2023: OE_MSG_PUB.Count_And_Get

2019: oe_debug_pub.add('Error'||l_err_message);
2020: END IF;
2021:
2022:
2023: OE_MSG_PUB.Count_And_Get
2024: ( p_count => l_msg_count,
2025: p_data => l_msg_data
2026: );
2027:

Line 2038: OE_MSG_PUB.Count_And_Get

2034: oe_debug_pub.add('f Error'||l_err_message);
2035: END IF;
2036:
2037:
2038: OE_MSG_PUB.Count_And_Get
2039: ( p_count => l_msg_count,
2040: p_data => l_msg_data
2041: );
2042:

Line 2062: -- OE_MSG_PUB.Add;

2058: );
2059: END IF;
2060:
2061: -- FND_MESSAGE.SET_NAME('ONT','Exception in Get_Payment_Trxn_Info');
2062: -- OE_MSG_PUB.Add;
2063:
2064: OE_MSG_PUB.Count_And_Get
2065: ( p_count => l_msg_count,
2066: p_data => l_msg_data

Line 2064: OE_MSG_PUB.Count_And_Get

2060:
2061: -- FND_MESSAGE.SET_NAME('ONT','Exception in Get_Payment_Trxn_Info');
2062: -- OE_MSG_PUB.Add;
2063:
2064: OE_MSG_PUB.Count_And_Get
2065: ( p_count => l_msg_count,
2066: p_data => l_msg_data
2067: );
2068:

Line 2251: OE_MSG_PUB.Count_And_Get

2247: oe_debug_pub.add('Error'||l_err_message);
2248: END IF;
2249:
2250: X_return_status := FND_API.G_RET_STS_ERROR;
2251: OE_MSG_PUB.Count_And_Get
2252: ( p_count => l_msg_count,
2253: p_data => l_msg_data
2254: );
2255: RAISE FND_API.G_EXC_ERROR;

Line 2267: OE_MSG_PUB.Count_And_Get

2263: oe_debug_pub.add('f Error'||l_err_message);
2264: END IF;
2265:
2266: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2267: OE_MSG_PUB.Count_And_Get
2268: ( p_count => l_msg_count,
2269: p_data => l_msg_data
2270: );
2271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2292: -- OE_MSG_PUB.Add;

2288: );
2289: END IF;
2290:
2291: -- FND_MESSAGE.SET_NAME('ONT','Exception in Delete_Payment_Trxn'||sqlerrm);
2292: -- OE_MSG_PUB.Add;
2293:
2294: OE_MSG_PUB.Count_And_Get
2295: ( p_count => l_msg_count,
2296: p_data => l_msg_data

Line 2294: OE_MSG_PUB.Count_And_Get

2290:
2291: -- FND_MESSAGE.SET_NAME('ONT','Exception in Delete_Payment_Trxn'||sqlerrm);
2292: -- OE_MSG_PUB.Add;
2293:
2294: OE_MSG_PUB.Count_And_Get
2295: ( p_count => l_msg_count,
2296: p_data => l_msg_data
2297: );
2298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

2333:
2334: RETURN l_settled_flag;
2335: EXCEPTION
2336: WHEN OTHERS THEN
2337: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2338: THEN
2339: OE_MSG_PUB.Add_Exc_Msg
2340: ( G_PKG_NAME ,
2341: 'Get_CC_Security_Code_Use'

Line 2339: OE_MSG_PUB.Add_Exc_Msg

2335: EXCEPTION
2336: WHEN OTHERS THEN
2337: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2338: THEN
2339: OE_MSG_PUB.Add_Exc_Msg
2340: ( G_PKG_NAME ,
2341: 'Get_CC_Security_Code_Use'
2342: );
2343: END IF;

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

2386: EXCEPTION
2387:
2388: WHEN OTHERS THEN
2389:
2390: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2391: THEN
2392: OE_MSG_PUB.Add_Exc_Msg
2393: ( G_PKG_NAME ,
2394: 'Get_CC_Security_Code_Use'

Line 2392: OE_MSG_PUB.Add_Exc_Msg

2388: WHEN OTHERS THEN
2389:
2390: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2391: THEN
2392: OE_MSG_PUB.Add_Exc_Msg
2393: ( G_PKG_NAME ,
2394: 'Get_CC_Security_Code_Use'
2395: );
2396: END IF;