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 56: OE_MSG_PUB.Count_And_Get

52: , 'Process_Credit_Card'
53: );
54: END IF;
55:
56: OE_MSG_PUB.Count_And_Get
57: ( p_count => p_msg_count,
58: p_data => p_msg_data
59: );
60: END Process_Credit_Card;

Line 295: OE_MSG_PUB.ADD;

291: -- 16604394
292: -- Capturing the return status from IBY API and displaying the appropriate error message on the UI
293: IF l_response_code.result_code = 'INVALID_CARD_NUMBER' THEN
294: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET');
295: OE_MSG_PUB.ADD;
296: IF l_debug_level > 0 THEN
297: oe_debug_pub.add( 'OEXUPTXB: Invalid card number or expiration date in set payer instr assignment' || l_response_code.result_code ) ;
298: END IF;
299: ELSIF l_response_code.result_code = 'INVALID_ADDRESS' THEN

Line 301: OE_MSG_PUB.ADD;

297: oe_debug_pub.add( 'OEXUPTXB: Invalid card number or expiration date in set payer instr assignment' || l_response_code.result_code ) ;
298: END IF;
299: ELSIF l_response_code.result_code = 'INVALID_ADDRESS' THEN
300: FND_MESSAGE.SET_NAME('ONT','OE_CC_BILL_TO_ADDRESS_INVALID');
301: OE_MSG_PUB.ADD;
302: IF l_debug_level > 0 THEN
303: oe_debug_pub.add( 'OEXUPTXB: Invalid billing address in set payer instr assignment' || l_response_code.result_code) ;
304: END IF;
305: ELSIF l_response_code.result_code = 'INVALID_CARD_ISSUER' THEN

Line 307: OE_MSG_PUB.ADD;

303: oe_debug_pub.add( 'OEXUPTXB: Invalid billing address in set payer instr assignment' || l_response_code.result_code) ;
304: END IF;
305: ELSIF l_response_code.result_code = 'INVALID_CARD_ISSUER' THEN
306: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET'); --bug 5012613
307: OE_MSG_PUB.ADD;
308: IF l_debug_level > 0 THEN
309: oe_debug_pub.add( 'OEXUPTXB: Invalid billing address in set payer instr assignment' || l_response_code.result_code) ;
310: END IF;
311: ELSE --Setting a generic message bug 5244099

Line 313: OE_MSG_PUB.ADD;

309: oe_debug_pub.add( 'OEXUPTXB: Invalid billing address in set payer instr assignment' || l_response_code.result_code) ;
310: END IF;
311: ELSE --Setting a generic message bug 5244099
312: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET');
313: OE_MSG_PUB.ADD;
314: IF l_debug_level > 0 THEN
315: oe_debug_pub.add( 'OEXUPTXB: Setting the generic message in set payer instr assignment' || l_response_code.result_code) ;
316: END IF;
317: -- 16604394

Line 323: OE_MSG_PUB.ADD;

319: RAISE FND_API.G_EXC_ERROR;
320: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
321: -- 16604394
322: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET'); --bug 5244099
323: OE_MSG_PUB.ADD;
324: -- 16604394
325: IF l_debug_level > 0 THEN
326: oe_debug_pub.add('Unexpected result error code in Set_Payer_Instr_Assignment-->'||l_response_code.result_code);
327: END IF;

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

357: X_msg_data => l_msg_data,
358: p_card_instrument => l_credit_card_rec,
359: x_response => l_response_code
360: );
361: --oe_msg_pub.add_text(p_message_text => l_response_code.result_message);
362: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
363: IF l_debug_level > 0 THEN
364: oe_debug_pub.add('Result error code in Update_Card exp'||l_response_code.result_code);
365: END IF;

Line 404: OE_MSG_PUB.ADD;

400: -- 16604394
401: -- Capturing the return status from IBY API and displaying the appropriate error message on the UI
402: IF l_response_code.result_code = 'INVALID_CARD_NUMBER' THEN
403: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET');
404: OE_MSG_PUB.ADD;
405: IF l_debug_level > 0 THEN
406: oe_debug_pub.add( 'OEXUPTXB: Invalid card number or expiration date in set payer instr assignment ' || l_response_code.result_code ) ;
407: END IF;
408: ELSIF l_response_code.result_code = 'INVALID_ADDRESS' THEN

Line 410: OE_MSG_PUB.ADD;

406: oe_debug_pub.add( 'OEXUPTXB: Invalid card number or expiration date in set payer instr assignment ' || l_response_code.result_code ) ;
407: END IF;
408: ELSIF l_response_code.result_code = 'INVALID_ADDRESS' THEN
409: FND_MESSAGE.SET_NAME('ONT','OE_CC_BILL_TO_ADDRESS_INVALID');
410: OE_MSG_PUB.ADD;
411: IF l_debug_level > 0 THEN
412: oe_debug_pub.add( 'OEXUPTXB: Invalid billing address in set payer instr assignment ' || l_response_code.result_code) ;
413: END IF;
414: ELSIF l_response_code.result_code = 'INVALID_CARD_ISSUER' THEN

Line 416: OE_MSG_PUB.ADD;

412: oe_debug_pub.add( 'OEXUPTXB: Invalid billing address in set payer instr assignment ' || l_response_code.result_code) ;
413: END IF;
414: ELSIF l_response_code.result_code = 'INVALID_CARD_ISSUER' THEN
415: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET'); --bug 5012613
416: OE_MSG_PUB.ADD;
417: IF l_debug_level > 0 THEN
418: oe_debug_pub.add( 'OEXUPTXB: Invalid billing address in set payer instr assignment ' || l_response_code.result_code) ;
419: END IF;
420: ELSE --Setting a generic message bug 5244099

Line 422: OE_MSG_PUB.ADD;

418: oe_debug_pub.add( 'OEXUPTXB: Invalid billing address in set payer instr assignment ' || l_response_code.result_code) ;
419: END IF;
420: ELSE --Setting a generic message bug 5244099
421: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET');
422: OE_MSG_PUB.ADD;
423: IF l_debug_level > 0 THEN
424: oe_debug_pub.add( 'OEXUPTXB: Setting the generic message in set payer instr assignment ' || l_response_code.result_code) ;
425: END IF;
426: -- 16604394

Line 432: OE_MSG_PUB.ADD;

428: RAISE FND_API.G_EXC_ERROR;
429: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
430: -- 16604394
431: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET'); --bug 5244099
432: OE_MSG_PUB.ADD;
433: -- 16604394
434: IF l_debug_level > 0 THEN
435: oe_debug_pub.add('Unexpected result error code in Set_Payer_Instr_Assignment-->'||l_response_code.result_code);
436: END IF;

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

496: );
497: 13488830*/
498: --9092936 end
499:
500: --oe_msg_pub.add_text(p_message_text => l_response_code.result_message);
501:
502: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
503: IF l_debug_level > 0 THEN
504: oe_debug_pub.add('Result error code in Process_Credit_Card -->'||l_response_code.result_code);

Line 508: OE_MSG_PUB.ADD;

504: oe_debug_pub.add('Result error code in Process_Credit_Card -->'||l_response_code.result_code);
505: END IF;
506: IF l_response_code.result_code = 'INVALID_CARD_NUMBER' THEN
507: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET');
508: OE_MSG_PUB.ADD;
509: IF l_debug_level > 0 THEN
510: oe_debug_pub.add( 'OEXUPTXB: Invalid card number or expiration date' ) ;
511: END IF;
512: ELSIF l_response_code.result_code = 'INVALID_ADDRESS' THEN

Line 514: OE_MSG_PUB.ADD;

510: oe_debug_pub.add( 'OEXUPTXB: Invalid card number or expiration date' ) ;
511: END IF;
512: ELSIF l_response_code.result_code = 'INVALID_ADDRESS' THEN
513: FND_MESSAGE.SET_NAME('ONT','OE_CC_BILL_TO_ADDRESS_INVALID');
514: OE_MSG_PUB.ADD;
515: IF l_debug_level > 0 THEN
516: oe_debug_pub.add( 'OEXUPTXB: Invalid billing address' ) ;
517: END IF;
518: ELSIF l_response_code.result_code = 'INVALID_CARD_ISSUER' THEN

Line 520: OE_MSG_PUB.ADD;

516: oe_debug_pub.add( 'OEXUPTXB: Invalid billing address' ) ;
517: END IF;
518: ELSIF l_response_code.result_code = 'INVALID_CARD_ISSUER' THEN
519: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET'); --bug 5012613
520: OE_MSG_PUB.ADD;
521: IF l_debug_level > 0 THEN
522: oe_debug_pub.add( 'OEXUPTXB: Invalid billing address' ) ;
523: END IF;
524: ELSE --Setting a generic message bug 5244099

Line 526: OE_MSG_PUB.ADD;

522: oe_debug_pub.add( 'OEXUPTXB: Invalid billing address' ) ;
523: END IF;
524: ELSE --Setting a generic message bug 5244099
525: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET');
526: OE_MSG_PUB.ADD;
527: IF l_debug_level > 0 THEN
528: oe_debug_pub.add( 'OEXUPTXB: Setting the generic message' ) ;
529: END IF;
530: END IF;

Line 534: OE_MSG_PUB.ADD;

530: END IF;
531: RAISE FND_API.G_EXC_ERROR;
532: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
533: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET'); --bug 5244099
534: OE_MSG_PUB.ADD;
535: IF l_debug_level > 0 THEN
536: oe_debug_pub.add('Unexpected result error code in Process_Credit_Card-->'||l_response_code.result_code);
537: END IF;
538: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

672: P_trxn_attribs => l_trxn_attribs,
673: x_entity_id => l_trxn_extension_id,
674: X_response => l_response_code);
675:
676: --oe_msg_pub.add_text(p_message_text => l_response_code.result_message);
677:
678: IF l_debug_level > 0 THEN
679: oe_debug_pub.add('After calling Create_Transaction_Extension'||l_trxn_extension_id);
680: oe_debug_pub.add('Result code'||l_Response_code.result_code);

Line 734: OE_MSG_PUB.Count_And_Get

730: oe_debug_pub.add('Error'||l_err_message);
731: END IF;
732:
733: X_return_status := FND_API.G_RET_STS_ERROR;
734: OE_MSG_PUB.Count_And_Get
735: ( p_count => l_msg_count,
736: p_data => l_msg_data
737: );
738: RAISE FND_API.G_EXC_ERROR;

Line 750: OE_MSG_PUB.Count_And_Get

746: oe_debug_pub.add('f Error'||l_err_message);
747: END IF;
748:
749: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
750: OE_MSG_PUB.Count_And_Get
751: ( p_count => l_msg_count,
752: p_data => l_msg_data
753: );
754: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 774: OE_MSG_PUB.Count_And_Get

770: , 'OE_PAYMENT_TRXN_UTIL'
771: );
772: END IF;
773:
774: OE_MSG_PUB.Count_And_Get
775: ( p_count => l_msg_count,
776: p_data => l_msg_data
777: );
778: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

990: P_assignment_attribs => l_assignment_attribs,
991: X_assign_id => l_assign_id,
992: X_response => l_response_code);
993:
994: --oe_msg_pub.add_text(p_message_text => l_response_code.result_message);
995:
996: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
997: IF l_debug_level > 0 THEN
998: oe_debug_pub.add('Result error code in Set_Payer_Instr_Assignment in set payer instr assignment '||l_response_code.result_code);

Line 1002: OE_MSG_PUB.ADD;

998: oe_debug_pub.add('Result error code in Set_Payer_Instr_Assignment in set payer instr assignment '||l_response_code.result_code);
999: END IF;
1000: IF l_response_code.result_code = 'INVALID_CARD_NUMBER' THEN
1001: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET');
1002: OE_MSG_PUB.ADD;
1003: IF l_debug_level > 0 THEN
1004: oe_debug_pub.add( 'OEXUPTXB: Invalid card number or expiration date in set payer instr assignment ' ||l_response_code.result_code) ;
1005: END IF;
1006: ELSIF l_response_code.result_code = 'INVALID_ADDRESS' THEN

Line 1008: OE_MSG_PUB.ADD;

1004: oe_debug_pub.add( 'OEXUPTXB: Invalid card number or expiration date in set payer instr assignment ' ||l_response_code.result_code) ;
1005: END IF;
1006: ELSIF l_response_code.result_code = 'INVALID_ADDRESS' THEN
1007: FND_MESSAGE.SET_NAME('ONT','OE_CC_BILL_TO_ADDRESS_INVALID');
1008: OE_MSG_PUB.ADD;
1009: IF l_debug_level > 0 THEN
1010: oe_debug_pub.add( 'OEXUPTXB: Invalid billing address in set payer instr assignment '||l_response_code.result_code ) ;
1011: END IF;
1012: ELSIF l_response_code.result_code = 'INVALID_CARD_ISSUER' THEN

Line 1014: OE_MSG_PUB.ADD;

1010: oe_debug_pub.add( 'OEXUPTXB: Invalid billing address in set payer instr assignment '||l_response_code.result_code ) ;
1011: END IF;
1012: ELSIF l_response_code.result_code = 'INVALID_CARD_ISSUER' THEN
1013: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET'); --bug 5012613
1014: OE_MSG_PUB.ADD;
1015: IF l_debug_level > 0 THEN
1016: oe_debug_pub.add( 'OEXUPTXB: Invalid billing address in set payer instr assignment ' ||l_response_code.result_code) ;
1017: END IF;
1018: END IF;

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

1060: X_msg_data => l_msg_data,
1061: p_card_instrument => l_credit_card_rec,
1062: x_response => l_response_code
1063: );
1064: --oe_msg_pub.add_text(p_message_text => l_response_code.result_message);
1065:
1066: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1067: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET'); --12691100
1068: OE_MSG_PUB.ADD; --12691100

Line 1068: OE_MSG_PUB.ADD; --12691100

1064: --oe_msg_pub.add_text(p_message_text => l_response_code.result_message);
1065:
1066: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1067: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET'); --12691100
1068: OE_MSG_PUB.ADD; --12691100
1069: IF l_debug_level > 0 THEN
1070: oe_debug_pub.add('Result error code in Update_Card exp'||l_response_code.result_code);
1071: END IF;
1072: RAISE FND_API.G_EXC_ERROR;

Line 1113: OE_MSG_PUB.ADD;

1109: -- 16604394
1110: -- Capturing the return status from IBY API and displaying the appropriate error message on the UI
1111: IF l_response_code.result_code = 'INVALID_CARD_NUMBER' THEN
1112: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET');
1113: OE_MSG_PUB.ADD;
1114: IF l_debug_level > 0 THEN
1115: oe_debug_pub.add( 'OEXUPTXB: Invalid card number or expiration date in set payer instr assignment ' || l_response_code.result_code ) ;
1116: END IF;
1117: ELSIF l_response_code.result_code = 'INVALID_ADDRESS' THEN

Line 1119: OE_MSG_PUB.ADD;

1115: oe_debug_pub.add( 'OEXUPTXB: Invalid card number or expiration date in set payer instr assignment ' || l_response_code.result_code ) ;
1116: END IF;
1117: ELSIF l_response_code.result_code = 'INVALID_ADDRESS' THEN
1118: FND_MESSAGE.SET_NAME('ONT','OE_CC_BILL_TO_ADDRESS_INVALID');
1119: OE_MSG_PUB.ADD;
1120: IF l_debug_level > 0 THEN
1121: oe_debug_pub.add( 'OEXUPTXB: Invalid billing address in set payer instr assignment ' || l_response_code.result_code) ;
1122: END IF;
1123: ELSIF l_response_code.result_code = 'INVALID_CARD_ISSUER' THEN

Line 1125: OE_MSG_PUB.ADD;

1121: oe_debug_pub.add( 'OEXUPTXB: Invalid billing address in set payer instr assignment ' || l_response_code.result_code) ;
1122: END IF;
1123: ELSIF l_response_code.result_code = 'INVALID_CARD_ISSUER' THEN
1124: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET'); --bug 5012613
1125: OE_MSG_PUB.ADD;
1126: IF l_debug_level > 0 THEN
1127: oe_debug_pub.add( 'OEXUPTXB: Invalid billing address in set payer instr assignment ' || l_response_code.result_code) ;
1128: END IF;
1129: ELSE --Setting a generic message bug 5244099

Line 1131: OE_MSG_PUB.ADD;

1127: oe_debug_pub.add( 'OEXUPTXB: Invalid billing address in set payer instr assignment ' || l_response_code.result_code) ;
1128: END IF;
1129: ELSE --Setting a generic message bug 5244099
1130: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET');
1131: OE_MSG_PUB.ADD;
1132: IF l_debug_level > 0 THEN
1133: oe_debug_pub.add( 'OEXUPTXB: Setting the generic message in set payer instr assignment ' || l_response_code.result_code) ;
1134: END IF;
1135: -- 16604394

Line 1141: OE_MSG_PUB.ADD;

1137: RAISE FND_API.G_EXC_ERROR;
1138: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1139: -- 16604394
1140: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET'); --bug 5244099
1141: OE_MSG_PUB.ADD;
1142: IF l_debug_level > 0 THEN
1143: oe_debug_pub.add('Unexpected result error code in Set_Payer_Instr_Assignment-->'||l_response_code.result_code);
1144: END IF;
1145: -- 16604394

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

1201: );
1202: 13488830*/
1203: --9092936 end
1204:
1205: --oe_msg_pub.add_text(p_message_text => l_response_code.result_message);
1206:
1207: IF l_debug_level > 0 THEN
1208: oe_debug_pub.add('After call to process credit card....');
1209: END IF;

Line 1218: OE_MSG_PUB.ADD;

1214: oe_debug_pub.add('Result error code in Process_Credit_Card -->'||l_response_code.result_code);
1215: END IF;
1216: IF l_response_code.result_code = 'INVALID_CARD_NUMBER' THEN
1217: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET');
1218: OE_MSG_PUB.ADD;
1219: IF l_debug_level > 0 THEN
1220: oe_debug_pub.add( 'OEXUPTXB: Invalid card number or expiration date' ) ;
1221: END IF;
1222: ELSIF l_response_code.result_code = 'INVALID_ADDRESS' THEN

Line 1224: OE_MSG_PUB.ADD;

1220: oe_debug_pub.add( 'OEXUPTXB: Invalid card number or expiration date' ) ;
1221: END IF;
1222: ELSIF l_response_code.result_code = 'INVALID_ADDRESS' THEN
1223: FND_MESSAGE.SET_NAME('ONT','OE_CC_BILL_TO_ADDRESS_INVALID');
1224: OE_MSG_PUB.ADD;
1225: IF l_debug_level > 0 THEN
1226: oe_debug_pub.add( 'OEXUPTXB: Invalid billing address' ) ;
1227: END IF;
1228: ELSIF l_response_code.result_code = 'INVALID_CARD_ISSUER' THEN

Line 1230: OE_MSG_PUB.ADD;

1226: oe_debug_pub.add( 'OEXUPTXB: Invalid billing address' ) ;
1227: END IF;
1228: ELSIF l_response_code.result_code = 'INVALID_CARD_ISSUER' THEN
1229: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET'); --bug 5012613
1230: OE_MSG_PUB.ADD;
1231: IF l_debug_level > 0 THEN
1232: oe_debug_pub.add( 'OEXUPTXB: Invalid billing address' ) ;
1233: END IF;
1234: ELSE --Setting a generic message bug 5244099

Line 1236: OE_MSG_PUB.ADD;

1232: oe_debug_pub.add( 'OEXUPTXB: Invalid billing address' ) ;
1233: END IF;
1234: ELSE --Setting a generic message bug 5244099
1235: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET');
1236: OE_MSG_PUB.ADD;
1237: IF l_debug_level > 0 THEN
1238: oe_debug_pub.add( 'OEXUPTXB: Setting the generic message' ) ;
1239: END IF;
1240: END IF;

Line 1244: OE_MSG_PUB.ADD;

1240: END IF;
1241: RAISE FND_API.G_EXC_ERROR;
1242: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1243: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET'); --bug 5244099
1244: OE_MSG_PUB.ADD;
1245: IF l_debug_level > 0 THEN
1246: oe_debug_pub.add('Unexpected result error code in Process_Credit_Card-->'||l_response_code.result_code);
1247: END IF;
1248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1406: OE_Msg_Pub.Add;

1402: OE_GLOBALS.Equal(l_trxn_attribs.Instrument_Security_Code,FND_API.G_MISS_CHAR))
1403: THEN
1404:
1405: FND_MESSAGE.SET_NAME('ONT','OE_CC_SECURITY_CODE_REQD');
1406: OE_Msg_Pub.Add;
1407: RAISE FND_API.G_EXC_ERROR;
1408:
1409: ELSIF Oe_Payment_Trxn_Util.Get_CC_Security_Code_Use = 'REQUIRED'
1410: AND l_trxn_attribs.Instrument_Security_Code IS NOT NULL

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

1548: P_trxn_attribs => l_trxn_attribs,
1549: x_entity_id => l_trxn_extension_id,
1550: X_response => l_response_code);
1551:
1552: --oe_msg_pub.add_text(p_message_text => l_response_code.result_message);
1553:
1554: IF l_debug_level > 0 THEN
1555: oe_debug_pub.add('After calling Create_Transaction_Extension'||l_trxn_extension_id);
1556: oe_debug_pub.add('Result code'||l_Response_code.result_code);

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

1651: x_response => l_response_code,
1652: p_pmt_channel => L_pmt_channel_code,
1653: p_instr_assignment => l_assign_id);
1654:
1655: --oe_msg_pub.add_text(p_message_text => l_response_code.result_message);
1656:
1657: IF l_debug_level > 0 THEN
1658: oe_debug_pub.add('After calling update transaction extension...');
1659: END IF;

Line 1743: OE_Msg_Pub.Add;

1739: --has been brought in. Since the CVV2 value used here
1740: --would be of the previous cards', displaying this message
1741: --to the user.
1742: FND_MESSAGE.SET_NAME('ONT','OE_CC_SECURITY_CODE_REQD');
1743: OE_Msg_Pub.Add;
1744: END IF;*/
1745: END IF;
1746: --Now setting the account site id as the new bill to site
1747: --for creating this trxn extension id

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

1772: P_trxn_attribs => l_trxn_attribs,
1773: x_entity_id => l_trxn_extension_id,
1774: X_response => l_response_code);
1775:
1776: --oe_msg_pub.add_text(p_message_text => l_response_code.result_message);
1777:
1778: IF l_debug_level > 0 THEN
1779: oe_debug_pub.add('After calling Create_Transaction_Extension'||l_trxn_extension_id);
1780: oe_debug_pub.add('Result code'||l_Response_code.result_code);

Line 1849: OE_MSG_PUB.Count_And_Get

1845: EXCEPTION
1846:
1847: WHEN FND_API.G_EXC_ERROR THEN
1848: X_return_status := FND_API.G_RET_STS_ERROR;
1849: OE_MSG_PUB.Count_And_Get
1850: ( p_count => l_msg_count,
1851: p_data => l_msg_data
1852: );
1853: RAISE FND_API.G_EXC_ERROR;

Line 1857: OE_MSG_PUB.Count_And_Get

1853: RAISE FND_API.G_EXC_ERROR;
1854:
1855: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1856: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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 1873: OE_MSG_PUB.Count_And_Get

1869: , 'OE_PAYMENT_TRXN_UTIL'
1870: );
1871: END IF;
1872:
1873: OE_MSG_PUB.Count_And_Get
1874: ( p_count => l_msg_count,
1875: p_data => l_msg_data
1876: );
1877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2026: OE_MSG_PUB.ADD;

2022: -- 16604394
2023: -- Capturing the return status from IBY API and displaying the appropriate error message on the UI
2024: IF l_response_code.result_code = 'INVALID_CARD_NUMBER' THEN
2025: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET');
2026: OE_MSG_PUB.ADD;
2027: IF l_debug_level > 0 THEN
2028: oe_debug_pub.add( 'OEXUPTXB: Invalid card number or expiration date in set payer instr assignment ' || l_response_code.result_code ) ;
2029: END IF;
2030: ELSIF l_response_code.result_code = 'INVALID_ADDRESS' THEN

Line 2032: OE_MSG_PUB.ADD;

2028: oe_debug_pub.add( 'OEXUPTXB: Invalid card number or expiration date in set payer instr assignment ' || l_response_code.result_code ) ;
2029: END IF;
2030: ELSIF l_response_code.result_code = 'INVALID_ADDRESS' THEN
2031: FND_MESSAGE.SET_NAME('ONT','OE_CC_BILL_TO_ADDRESS_INVALID');
2032: OE_MSG_PUB.ADD;
2033: IF l_debug_level > 0 THEN
2034: oe_debug_pub.add( 'OEXUPTXB: Invalid billing address in set payer instr assignment ' || l_response_code.result_code) ;
2035: END IF;
2036: ELSIF l_response_code.result_code = 'INVALID_CARD_ISSUER' THEN

Line 2038: OE_MSG_PUB.ADD;

2034: oe_debug_pub.add( 'OEXUPTXB: Invalid billing address in set payer instr assignment ' || l_response_code.result_code) ;
2035: END IF;
2036: ELSIF l_response_code.result_code = 'INVALID_CARD_ISSUER' THEN
2037: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET'); --bug 5012613
2038: OE_MSG_PUB.ADD;
2039: IF l_debug_level > 0 THEN
2040: oe_debug_pub.add( 'OEXUPTXB: Invalid billing address in set payer instr assignment ' || l_response_code.result_code) ;
2041: END IF;
2042: ELSE --Setting a generic message bug 5244099

Line 2044: OE_MSG_PUB.ADD;

2040: oe_debug_pub.add( 'OEXUPTXB: Invalid billing address in set payer instr assignment ' || l_response_code.result_code) ;
2041: END IF;
2042: ELSE --Setting a generic message bug 5244099
2043: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET');
2044: OE_MSG_PUB.ADD;
2045: IF l_debug_level > 0 THEN
2046: oe_debug_pub.add( 'OEXUPTXB: Setting the generic message in set payer instr assignment ' || l_response_code.result_code) ;
2047: END IF;
2048: END IF;

Line 2054: OE_MSG_PUB.ADD;

2050: RAISE FND_API.G_EXC_ERROR;
2051: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2052: -- 16604394
2053: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET'); --bug 5244099
2054: OE_MSG_PUB.ADD;
2055: -- 16604394
2056: IF l_debug_level > 0 THEN
2057: oe_debug_pub.add('Unexpected result error code in Set_Payer_Instr_Assignment-->'||l_response_code.result_code);
2058: END IF;

Line 2150: OE_MSG_PUB.Count_And_Get

2146: oe_debug_pub.add('Error'||l_err_message);
2147: END IF;
2148:
2149: X_return_status := FND_API.G_RET_STS_ERROR;
2150: OE_MSG_PUB.Count_And_Get
2151: ( p_count => l_msg_count,
2152: p_data => l_msg_data
2153: );
2154: RAISE FND_API.G_EXC_ERROR;

Line 2165: OE_MSG_PUB.Count_And_Get

2161: oe_debug_pub.add('f Error'||l_err_message);
2162: END IF;
2163:
2164: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2165: OE_MSG_PUB.Count_And_Get
2166: ( p_count => l_msg_count,
2167: p_data => l_msg_data
2168: );
2169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2189: OE_MSG_PUB.Count_And_Get

2185: , 'OE_PAYMENT_TRXN_UTIL'
2186: );
2187: END IF;
2188:
2189: OE_MSG_PUB.Count_And_Get
2190: ( p_count => l_msg_count,
2191: p_data => l_msg_data
2192: );
2193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2402: OE_MSG_PUB.Count_And_Get

2398: oe_debug_pub.add('Error'||l_err_message);
2399: END IF;
2400:
2401:
2402: OE_MSG_PUB.Count_And_Get
2403: ( p_count => l_msg_count,
2404: p_data => l_msg_data
2405: );
2406:

Line 2417: OE_MSG_PUB.Count_And_Get

2413: oe_debug_pub.add('f Error'||l_err_message);
2414: END IF;
2415:
2416:
2417: OE_MSG_PUB.Count_And_Get
2418: ( p_count => l_msg_count,
2419: p_data => l_msg_data
2420: );
2421:

Line 2441: -- OE_MSG_PUB.Add;

2437: );
2438: END IF;
2439:
2440: -- FND_MESSAGE.SET_NAME('ONT','Exception in Get_Payment_Trxn_Info');
2441: -- OE_MSG_PUB.Add;
2442:
2443: OE_MSG_PUB.Count_And_Get
2444: ( p_count => l_msg_count,
2445: p_data => l_msg_data

Line 2443: OE_MSG_PUB.Count_And_Get

2439:
2440: -- FND_MESSAGE.SET_NAME('ONT','Exception in Get_Payment_Trxn_Info');
2441: -- OE_MSG_PUB.Add;
2442:
2443: OE_MSG_PUB.Count_And_Get
2444: ( p_count => l_msg_count,
2445: p_data => l_msg_data
2446: );
2447:

Line 2731: OE_MSG_PUB.Count_And_Get

2727: oe_debug_pub.add('Error'||l_err_message);
2728: END IF;
2729:
2730: X_return_status := FND_API.G_RET_STS_ERROR;
2731: OE_MSG_PUB.Count_And_Get
2732: ( p_count => l_msg_count,
2733: p_data => l_msg_data
2734: );
2735: RAISE FND_API.G_EXC_ERROR;

Line 2747: OE_MSG_PUB.Count_And_Get

2743: oe_debug_pub.add('f Error'||l_err_message);
2744: END IF;
2745:
2746: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2747: OE_MSG_PUB.Count_And_Get
2748: ( p_count => l_msg_count,
2749: p_data => l_msg_data
2750: );
2751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2772: -- OE_MSG_PUB.Add;

2768: );
2769: END IF;
2770:
2771: -- FND_MESSAGE.SET_NAME('ONT','Exception in Delete_Payment_Trxn'||sqlerrm);
2772: -- OE_MSG_PUB.Add;
2773:
2774: OE_MSG_PUB.Count_And_Get
2775: ( p_count => l_msg_count,
2776: p_data => l_msg_data

Line 2774: OE_MSG_PUB.Count_And_Get

2770:
2771: -- FND_MESSAGE.SET_NAME('ONT','Exception in Delete_Payment_Trxn'||sqlerrm);
2772: -- OE_MSG_PUB.Add;
2773:
2774: OE_MSG_PUB.Count_And_Get
2775: ( p_count => l_msg_count,
2776: p_data => l_msg_data
2777: );
2778: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

2814:
2815: RETURN l_settled_flag;
2816: EXCEPTION
2817: WHEN OTHERS THEN
2818: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2819: THEN
2820: OE_MSG_PUB.Add_Exc_Msg
2821: ( G_PKG_NAME ,
2822: 'Get_CC_Security_Code_Use'

Line 2820: OE_MSG_PUB.Add_Exc_Msg

2816: EXCEPTION
2817: WHEN OTHERS THEN
2818: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2819: THEN
2820: OE_MSG_PUB.Add_Exc_Msg
2821: ( G_PKG_NAME ,
2822: 'Get_CC_Security_Code_Use'
2823: );
2824: END IF;

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

2867: EXCEPTION
2868:
2869: WHEN OTHERS THEN
2870:
2871: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2872: THEN
2873: OE_MSG_PUB.Add_Exc_Msg
2874: ( G_PKG_NAME ,
2875: 'Get_CC_Security_Code_Use'

Line 2873: OE_MSG_PUB.Add_Exc_Msg

2869: WHEN OTHERS THEN
2870:
2871: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2872: THEN
2873: OE_MSG_PUB.Add_Exc_Msg
2874: ( G_PKG_NAME ,
2875: 'Get_CC_Security_Code_Use'
2876: );
2877: END IF;

Line 3151: OE_MSG_PUB.ADD;

3147: oe_debug_pub.add('Reversal successful....',5);
3148: END IF; --16594955 setting message token outside of l_debug_level condition
3149: FND_MESSAGE.SET_NAME('ONT','ONT_PAYMENT_REV_SUCCESS');
3150: FND_MESSAGE.SET_TOKEN('AMOUNT',TO_CHAR(l_authorized_amt,l_format_mask));
3151: OE_MSG_PUB.ADD;
3152: --END IF; 16594955
3153: -- update the payment amount field on order header, this is for backward compatibility
3154: -- we used to show the authorized amount on order header. We have to update header
3155: -- table directly here as we did in 11i code, as the payment amount field is also

Line 3228: OE_MSG_PUB.ADD;

3224: );
3225: END IF;
3226: FND_MESSAGE.SET_NAME('ONT','ONT_CC_AUTH_HOLD_APPLIED');
3227: FND_MESSAGE.SET_TOKEN('AMOUNT',TO_CHAR(l_authorized_amt,l_format_mask));
3228: OE_MSG_PUB.ADD;
3229: p_return_status := l_return_status;
3230: oe_msg_pub.add_text(p_message_text => l_reversal_response.result_message);
3231: END IF;--end if of l_return_status
3232: END IF;-- reversal, settlement flag if condition

Line 3230: oe_msg_pub.add_text(p_message_text => l_reversal_response.result_message);

3226: FND_MESSAGE.SET_NAME('ONT','ONT_CC_AUTH_HOLD_APPLIED');
3227: FND_MESSAGE.SET_TOKEN('AMOUNT',TO_CHAR(l_authorized_amt,l_format_mask));
3228: OE_MSG_PUB.ADD;
3229: p_return_status := l_return_status;
3230: oe_msg_pub.add_text(p_message_text => l_reversal_response.result_message);
3231: END IF;--end if of l_return_status
3232: END IF;-- reversal, settlement flag if condition
3233: ELSE
3234: IF l_debug_level > 0 THEN

Line 3253: OE_MSG_PUB.Count_And_Get

3249: oe_debug_pub.add('Error'||l_err_message,5);
3250: END IF;
3251:
3252: p_return_status := FND_API.G_RET_STS_ERROR;
3253: OE_MSG_PUB.Count_And_Get
3254: ( p_count => l_msg_count,
3255: p_data => l_msg_data
3256: );
3257:

Line 3269: OE_MSG_PUB.Count_And_Get

3265: oe_debug_pub.add('f Error'||l_err_message,5);
3266: END IF;
3267:
3268: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3269: OE_MSG_PUB.Count_And_Get
3270: ( p_count => l_msg_count,
3271: p_data => l_msg_data
3272: );
3273:

Line 3289: OE_MSG_PUB.Count_And_Get

3285: , 'Reverse_CreditCard_Auth'
3286: );
3287: END IF;
3288:
3289: OE_MSG_PUB.Count_And_Get
3290: ( p_count => l_msg_count,
3291: p_data => l_msg_data
3292: );
3293: END Reverse_CreditCard_Auth;