[Home] [Help]
21: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
22: --
23: BEGIN
24:
25: p_return_status := FND_API.G_RET_STS_SUCCESS;
26:
27: IBY_FNDCPT_SETUP_PUB.Process_Credit_Card
28: (
29: p_api_version => 1.0,
26:
27: IBY_FNDCPT_SETUP_PUB.Process_Credit_Card
28: (
29: p_api_version => 1.0,
30: p_commit => FND_API.G_FALSE,
31: X_return_status => p_return_status,
32: X_msg_count => p_msg_count,
33: X_msg_data => p_msg_data,
34: P_payer => p_payer,
37: X_assign_id => p_assign_id,
38: X_response => p_response
39: );
40:
41: IF p_return_status =FND_API.G_RET_STS_SUCCESS THEN
42: COMMIT;
43: END IF;
44:
45: EXCEPTION
43: END IF;
44:
45: EXCEPTION
46: WHEN OTHERS THEN
47: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
48: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
49: THEN
50: FND_MSG_PUB.Add_Exc_Msg
51: ( G_PKG_NAME
221: oe_debug_pub.add('Invoice to org id'||l_invoice_to_org_id);
222: oe_debug_pub.add('Org id'||l_org_id);
223: oe_debug_pub.add('payment_number'||p_payment_number);
224: oe_debug_pub.add('Return status'||l_return_status||l_msg_data);
225: RAISE FND_API.G_EXC_ERROR;
226: END IF;
227: END;
228:
229: --Getting the instrument type based on
277: END IF;
278:
279: IBY_FNDCPT_SETUP_PUB.Set_Payer_Instr_Assignment
280: (p_api_version => 1.0,
281: p_commit => FND_API.G_FALSE,
282: X_return_status => l_return_status,
283: X_msg_count => l_msg_count,
284: X_msg_data => l_msg_data,
285: P_payer => l_payer,
286: P_assignment_attribs => l_assignment_attribs,
287: X_assign_id => l_assign_id,
288: X_response => l_response_code);
289:
290: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
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');
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
318: END IF;
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;
316: END IF;
317: -- 16604394
318: END IF;
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
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;
328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
329: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
330: IF l_debug_level > 0 THEN
331: oe_debug_pub.add('Set Payer instr assignment Successful....');
332: oe_debug_pub.add('After calling Set_Payer_Instr_Assignment');
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;
328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
329: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
330: IF l_debug_level > 0 THEN
331: oe_debug_pub.add('Set Payer instr assignment Successful....');
332: oe_debug_pub.add('After calling Set_Payer_Instr_Assignment');
333: oe_debug_pub.add('Instr assignment id'||l_assign_id);
349: END IF;
350: IBY_FNDCPT_SETUP_PUB.Update_Card
351: (
352: p_api_version => 1.0,
353: p_init_msg_list => FND_API.G_TRUE,
354: p_commit => FND_API.G_FALSE,
355: x_return_status => l_return_status,
356: X_msg_count => l_msg_count,
357: X_msg_data => l_msg_data,
350: IBY_FNDCPT_SETUP_PUB.Update_Card
351: (
352: p_api_version => 1.0,
353: p_init_msg_list => FND_API.G_TRUE,
354: p_commit => FND_API.G_FALSE,
355: x_return_status => l_return_status,
356: X_msg_count => l_msg_count,
357: X_msg_data => l_msg_data,
358: p_card_instrument => l_credit_card_rec,
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;
366: RAISE FND_API.G_EXC_ERROR;
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;
366: RAISE FND_API.G_EXC_ERROR;
367: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
368: IF l_debug_level > 0 THEN
369: oe_debug_pub.add('Result error code in Update_Card unxc'||l_response_code.result_code);
370: END IF;
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;
366: RAISE FND_API.G_EXC_ERROR;
367: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
368: IF l_debug_level > 0 THEN
369: oe_debug_pub.add('Result error code in Update_Card unxc'||l_response_code.result_code);
370: END IF;
371: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
367: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
368: IF l_debug_level > 0 THEN
369: oe_debug_pub.add('Result error code in Update_Card unxc'||l_response_code.result_code);
370: END IF;
371: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
372: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
373: IF l_debug_level > 0 THEN
374: oe_debug_pub.add('Update_Card Successful....');
375: oe_debug_pub.add('Return status '||l_return_status);
368: IF l_debug_level > 0 THEN
369: oe_debug_pub.add('Result error code in Update_Card unxc'||l_response_code.result_code);
370: END IF;
371: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
372: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
373: IF l_debug_level > 0 THEN
374: oe_debug_pub.add('Update_Card Successful....');
375: oe_debug_pub.add('Return status '||l_return_status);
376: END IF;
386: END IF;
387:
388: IBY_FNDCPT_SETUP_PUB.Set_Payer_Instr_Assignment
389: (p_api_version => 1.0,
390: p_commit => FND_API.G_FALSE,
391: X_return_status => l_return_status,
392: X_msg_count => l_msg_count,
393: X_msg_data => l_msg_data,
394: P_payer => l_payer,
395: P_assignment_attribs => l_assignment_attribs,
396: X_assign_id => l_assign_id,
397: X_response => l_response_code);
398:
399: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
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');
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
427: END IF;
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;
425: END IF;
426: -- 16604394
427: END IF;
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
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;
437: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
438: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
439: IF l_debug_level > 0 THEN
440: oe_debug_pub.add('Set Payer instr assignment Successful....');
441: oe_debug_pub.add('After calling Set_Payer_Instr_Assignment');
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;
437: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
438: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
439: IF l_debug_level > 0 THEN
440: oe_debug_pub.add('Set Payer instr assignment Successful....');
441: oe_debug_pub.add('After calling Set_Payer_Instr_Assignment');
442: oe_debug_pub.add('Instr assignment id'||l_assign_id);
469: --13488830 /*9092936 start
470: IBY_FNDCPT_SETUP_PUB.Process_Credit_Card
471: (
472: p_api_version => 1.0,
473: p_commit => FND_API.G_FALSE,
474: X_return_status => l_return_status,
475: X_msg_count => l_msg_count,
476: X_msg_data => l_msg_data,
477: P_payer => l_payer,
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);
505: END IF;
506: IF l_response_code.result_code = 'INVALID_CARD_NUMBER' THEN
527: IF l_debug_level > 0 THEN
528: oe_debug_pub.add( 'OEXUPTXB: Setting the generic message' ) ;
529: END IF;
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
528: oe_debug_pub.add( 'OEXUPTXB: Setting the generic message' ) ;
529: END IF;
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);
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;
539: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
540: IF l_debug_level > 0 THEN
541: oe_debug_pub.add('Process_Credit_Card assignment Successful....');
542: oe_debug_pub.add('After calling Process_Credit_Card');
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;
539: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
540: IF l_debug_level > 0 THEN
541: oe_debug_pub.add('Process_Credit_Card assignment Successful....');
542: oe_debug_pub.add('After calling Process_Credit_Card');
543: oe_debug_pub.add('Instr assignment id'||l_assign_id);
584: X_trxn_attribs => l_trxn_attribs,
585: --x_authorized => l_authorized,
586: --x_settled => l_settled,
587: X_response => l_response_code);
588: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
589: IF l_debug_level > 0 THEN
590: oe_debug_pub.add('Result error code in Get_Transaction_Extension'||l_response_code.result_code);
591: END IF;
592: RAISE FND_API.G_EXC_ERROR;
588: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
589: IF l_debug_level > 0 THEN
590: oe_debug_pub.add('Result error code in Get_Transaction_Extension'||l_response_code.result_code);
591: END IF;
592: RAISE FND_API.G_EXC_ERROR;
593: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
594: IF l_debug_level > 0 THEN
595: oe_debug_pub.add('Result error code in Get_Transaction_Extension'||l_response_code.result_code);
596: END IF;
589: IF l_debug_level > 0 THEN
590: oe_debug_pub.add('Result error code in Get_Transaction_Extension'||l_response_code.result_code);
591: END IF;
592: RAISE FND_API.G_EXC_ERROR;
593: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
594: IF l_debug_level > 0 THEN
595: oe_debug_pub.add('Result error code in Get_Transaction_Extension'||l_response_code.result_code);
596: END IF;
597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
593: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
594: IF l_debug_level > 0 THEN
595: oe_debug_pub.add('Result error code in Get_Transaction_Extension'||l_response_code.result_code);
596: END IF;
597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
598: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
599: IF l_debug_level > 0 THEN
600: oe_debug_pub.add('Get_Transaction_Extension assignment Successful....');
601: oe_debug_pub.add('After call to Get Transaction Extension'||l_return_status);
594: IF l_debug_level > 0 THEN
595: oe_debug_pub.add('Result error code in Get_Transaction_Extension'||l_response_code.result_code);
596: END IF;
597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
598: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
599: IF l_debug_level > 0 THEN
600: oe_debug_pub.add('Get_Transaction_Extension assignment Successful....');
601: oe_debug_pub.add('After call to Get Transaction Extension'||l_return_status);
602: oe_debug_pub.add('After call to get trxn...instr sec code'||l_trxn_attribs.instrument_security_code);
659: END IF;
660:
661: IBY_Fndcpt_Trxn_Pub.Create_Transaction_Extension
662: (p_api_version => 1.0,
663: p_init_msg_list => FND_API.G_TRUE,
664: p_commit => FND_API.G_FALSE,
665: X_return_status => l_return_status,
666: X_msg_count => l_msg_count,
667: X_msg_data => l_msg_data,
660:
661: IBY_Fndcpt_Trxn_Pub.Create_Transaction_Extension
662: (p_api_version => 1.0,
663: p_init_msg_list => FND_API.G_TRUE,
664: p_commit => FND_API.G_FALSE,
665: X_return_status => l_return_status,
666: X_msg_count => l_msg_count,
667: X_msg_data => l_msg_data,
668: P_payer => l_payer,
680: oe_debug_pub.add('Result code'||l_Response_code.result_code);
681: oe_debug_pub.add('Return status'||l_Return_Status);
682: END IF;
683:
684: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
685: IF l_debug_level > 0 THEN
686: oe_debug_pub.add('Result error code in Create_Transaction_Extension'||l_response_code.result_code);
687: END IF;
688: RAISE FND_API.G_EXC_ERROR;
684: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
685: IF l_debug_level > 0 THEN
686: oe_debug_pub.add('Result error code in Create_Transaction_Extension'||l_response_code.result_code);
687: END IF;
688: RAISE FND_API.G_EXC_ERROR;
689: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
690: IF l_debug_level > 0 THEN
691: oe_debug_pub.add('Result error code in Create_Transaction_Extension'||l_response_code.result_code);
692: END IF;
685: IF l_debug_level > 0 THEN
686: oe_debug_pub.add('Result error code in Create_Transaction_Extension'||l_response_code.result_code);
687: END IF;
688: RAISE FND_API.G_EXC_ERROR;
689: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
690: IF l_debug_level > 0 THEN
691: oe_debug_pub.add('Result error code in Create_Transaction_Extension'||l_response_code.result_code);
692: END IF;
693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
689: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
690: IF l_debug_level > 0 THEN
691: oe_debug_pub.add('Result error code in Create_Transaction_Extension'||l_response_code.result_code);
692: END IF;
693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
694: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
695: IF l_debug_level > 0 THEN
696: oe_debug_pub.add('Create_Transaction_Extension assignment Successful....');
697: oe_debug_pub.add('After call to Create_Transaction_Extension'||l_return_status);
690: IF l_debug_level > 0 THEN
691: oe_debug_pub.add('Result error code in Create_Transaction_Extension'||l_response_code.result_code);
692: END IF;
693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
694: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
695: IF l_debug_level > 0 THEN
696: oe_debug_pub.add('Create_Transaction_Extension assignment Successful....');
697: oe_debug_pub.add('After call to Create_Transaction_Extension'||l_return_status);
698: oe_debug_pub.add('After call to create Transaction Extension');
714: END IF;
715: END IF;
716: --bug 5176015
717: P_x_trxn_extension_id := l_trxn_extension_id;
718: X_return_status := FND_API.G_RET_STS_SUCCESS;
719: IF l_debug_level > 0 THEN
720: oe_debug_pub.add('Exiting Create_Payment_Trxn.....');
721: END IF;
722: EXCEPTION
720: oe_debug_pub.add('Exiting Create_Payment_Trxn.....');
721: END IF;
722: EXCEPTION
723:
724: WHEN FND_API.G_EXC_ERROR THEN
725: l_err_message := SQLERRM;
726: IF l_debug_level > 0 THEN
727: oe_debug_pub.add('Create_Transaction_Extension assignment error....exc');
728: oe_debug_pub.add('After call to Create_Transaction_Extension'||l_return_status);
729: oe_debug_pub.add('Result code'||l_response_code.result_code);
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: );
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;
739:
740: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
741: l_err_message := SQLERRM;
742: IF l_debug_level > 0 THEN
736: p_data => l_msg_data
737: );
738: RAISE FND_API.G_EXC_ERROR;
739:
740: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
741: l_err_message := SQLERRM;
742: IF l_debug_level > 0 THEN
743: oe_debug_pub.add('Create_Transaction_Extension assignment error....unxc');
744: oe_debug_pub.add('After call to Create_Transaction_Extension'||l_return_status);
745: oe_debug_pub.add('Result code'||l_response_code.result_code);
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: );
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;
755:
756: WHEN OTHERS THEN
757: l_err_message := SQLERRM;
758: IF l_debug_level > 0 THEN
761: oe_debug_pub.add('Result code'||l_response_code.result_code);
762: oe_debug_pub.add('trx Error'||l_err_message);
763: END IF;
764:
765: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
766: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
767: THEN
768: FND_MSG_PUB.Add_Exc_Msg
769: ( G_PKG_NAME
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;
779: END Create_Payment_Trxn;
780:
781: Procedure Update_Payment_Trxn
782: (p_header_id IN NUMBER,
981:
982: --
983: IBY_FNDCPT_SETUP_PUB.Set_Payer_Instr_Assignment
984: (p_api_version => 1.0,
985: p_commit => FND_API.G_FALSE,
986: X_return_status => l_return_status,
987: X_msg_count => l_msg_count,
988: X_msg_data => l_msg_data,
989: P_payer => l_payer,
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);
999: END IF;
1000: IF l_response_code.result_code = 'INVALID_CARD_NUMBER' THEN
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;
1019: RAISE FND_API.G_EXC_ERROR;
1020: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1021: IF l_debug_level > 0 THEN
1022: oe_debug_pub.add('Result error code in Set_Payer_Instr_Assignment'||l_response_code.result_code);
1023: END IF;
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;
1019: RAISE FND_API.G_EXC_ERROR;
1020: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1021: IF l_debug_level > 0 THEN
1022: oe_debug_pub.add('Result error code in Set_Payer_Instr_Assignment'||l_response_code.result_code);
1023: END IF;
1024: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1020: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1021: IF l_debug_level > 0 THEN
1022: oe_debug_pub.add('Result error code in Set_Payer_Instr_Assignment'||l_response_code.result_code);
1023: END IF;
1024: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1025: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
1026: IF l_debug_level > 0 THEN
1027: oe_debug_pub.add('Set_Payer_Instr_Assignment assignment Successful....');
1028: oe_debug_pub.add('After calling Set_Payer_Instr_Assignment');
1021: IF l_debug_level > 0 THEN
1022: oe_debug_pub.add('Result error code in Set_Payer_Instr_Assignment'||l_response_code.result_code);
1023: END IF;
1024: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1025: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
1026: IF l_debug_level > 0 THEN
1027: oe_debug_pub.add('Set_Payer_Instr_Assignment assignment Successful....');
1028: oe_debug_pub.add('After calling Set_Payer_Instr_Assignment');
1029: oe_debug_pub.add('Instr assignment id'||l_assign_id);
1052: l_credit_Card_rec.card_id := l_instrument_id;
1053: IBY_FNDCPT_SETUP_PUB.Update_Card
1054: (
1055: p_api_version => 1.0,
1056: p_init_msg_list => FND_API.G_TRUE,
1057: p_commit => FND_API.G_FALSE,
1058: x_return_status => l_return_status,
1059: X_msg_count => l_msg_count,
1060: X_msg_data => l_msg_data,
1053: IBY_FNDCPT_SETUP_PUB.Update_Card
1054: (
1055: p_api_version => 1.0,
1056: p_init_msg_list => FND_API.G_TRUE,
1057: p_commit => FND_API.G_FALSE,
1058: x_return_status => l_return_status,
1059: X_msg_count => l_msg_count,
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
1069: IF l_debug_level > 0 THEN
1070: oe_debug_pub.add('Result error code in Update_Card exp'||l_response_code.result_code);
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;
1073: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1074: IF l_debug_level > 0 THEN
1075: oe_debug_pub.add('Result error code in Update_Card unxc'||l_response_code.result_code);
1076: END IF;
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;
1073: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1074: IF l_debug_level > 0 THEN
1075: oe_debug_pub.add('Result error code in Update_Card unxc'||l_response_code.result_code);
1076: END IF;
1077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1073: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1074: IF l_debug_level > 0 THEN
1075: oe_debug_pub.add('Result error code in Update_Card unxc'||l_response_code.result_code);
1076: END IF;
1077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1078: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
1079: IF l_debug_level > 0 THEN
1080: oe_debug_pub.add('Update_Card Successful....');
1081: oe_debug_pub.add('Return status '||l_return_status);
1074: IF l_debug_level > 0 THEN
1075: oe_debug_pub.add('Result error code in Update_Card unxc'||l_response_code.result_code);
1076: END IF;
1077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1078: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
1079: IF l_debug_level > 0 THEN
1080: oe_debug_pub.add('Update_Card Successful....');
1081: oe_debug_pub.add('Return status '||l_return_status);
1082: END IF;
1095: l_assignment_attribs.instrument := l_instrument;
1096:
1097: IBY_FNDCPT_SETUP_PUB.Set_Payer_Instr_Assignment
1098: (p_api_version => 1.0,
1099: p_commit => FND_API.G_FALSE,
1100: X_return_status => l_return_status,
1101: X_msg_count => l_msg_count,
1102: X_msg_data => l_msg_data,
1103: P_payer => l_payer,
1104: P_assignment_attribs => l_assignment_attribs,
1105: X_assign_id => l_assign_id,
1106: X_response => l_response_code);
1107:
1108: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
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');
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
1136: END IF;
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;
1134: END IF;
1135: -- 16604394
1136: END IF;
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
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
1146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1147: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
1148: IF l_debug_level > 0 THEN
1149: oe_debug_pub.add('Set Payer instr assignment Successful....');
1150: oe_debug_pub.add('After calling Set_Payer_Instr_Assignment');
1143: oe_debug_pub.add('Unexpected result error code in Set_Payer_Instr_Assignment-->'||l_response_code.result_code);
1144: END IF;
1145: -- 16604394
1146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1147: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
1148: IF l_debug_level > 0 THEN
1149: oe_debug_pub.add('Set Payer instr assignment Successful....');
1150: oe_debug_pub.add('After calling Set_Payer_Instr_Assignment');
1151: oe_debug_pub.add('Instr assignment id'||l_assign_id);
1175:
1176: --13488830 /*9092936 start
1177: IBY_FNDCPT_SETUP_PUB.Process_Credit_Card
1178: (p_api_version => 1.0,
1179: p_commit => FND_API.G_FALSE,
1180: X_return_status => l_return_status,
1181: X_msg_count => l_msg_count,
1182: X_msg_data => l_msg_data,
1183: P_payer => l_payer,
1208: oe_debug_pub.add('After call to process credit card....');
1209: END IF;
1210:
1211:
1212: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1213: IF l_debug_level > 0 THEN
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
1237: IF l_debug_level > 0 THEN
1238: oe_debug_pub.add( 'OEXUPTXB: Setting the generic message' ) ;
1239: END IF;
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
1238: oe_debug_pub.add( 'OEXUPTXB: Setting the generic message' ) ;
1239: END IF;
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);
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;
1249: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
1250: IF l_debug_level > 0 THEN
1251: oe_debug_pub.add('Process_Credit_Card assignment Successful....');
1252: oe_debug_pub.add('After calling Process_Credit_Card');
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;
1249: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
1250: IF l_debug_level > 0 THEN
1251: oe_debug_pub.add('Process_Credit_Card assignment Successful....');
1252: oe_debug_pub.add('After calling Process_Credit_Card');
1253: oe_debug_pub.add('Instr assignment id'||l_assign_id);
1282: --the value appropriately.
1283: IF p_instrument_security_code is not null then
1284: l_trxn_attribs.Instrument_Security_Code := p_instrument_security_code;
1285: ELSE
1286: l_trxn_attribs.Instrument_Security_Code := FND_API.G_MISS_CHAR;
1287: END IF;
1288: END IF;
1289:
1290: IF l_debug_level > 0 THEN
1348: --If approval code is not null then the transaction
1349: --extension has already been authorized once. So cannot
1350: --call update_transaction API for this trxn_extension_id
1351: IF (l_approval_code IS NOT NULL AND
1352: NOT OE_GLOBALS.Equal(l_approval_code,FND_API.G_MISS_CHAR))
1353: OR l_settled_flag = 'Y' THEN
1354:
1355: IF l_settled_flag = 'N' THEN
1356: -- need to re-authorize if the authorization has expired.
1398: END IF;
1399:
1400: IF Oe_Payment_Trxn_Util.Get_CC_Security_Code_Use = 'REQUIRED'
1401: AND (l_trxn_attribs.Instrument_Security_Code IS NULL OR
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;
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
1411: AND NOT OE_GLOBALS.Equal(l_trxn_attribs.Instrument_Security_Code,FND_API.G_MISS_CHAR)
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
1411: AND NOT OE_GLOBALS.Equal(l_trxn_attribs.Instrument_Security_Code,FND_API.G_MISS_CHAR)
1412: THEN
1413:
1414: -- need to create a new payment transaction extension as the old one has been settled.
1415: IF l_debug_level > 0 THEN
1428: x_msg_count => x_msg_count,
1429: x_msg_data => x_msg_data,
1430: x_return_status => x_return_status);
1431:
1432: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1433: IF l_debug_level > 0 THEN
1434: oe_debug_pub.add( 'OEXUPTXB.pls: Exp. error in call to Create_New_Payment_Trxn');
1435: oe_debug_pub.add( 'SQL ERRM ----> '||sqlerrm);
1436: END IF;
1433: IF l_debug_level > 0 THEN
1434: oe_debug_pub.add( 'OEXUPTXB.pls: Exp. error in call to Create_New_Payment_Trxn');
1435: oe_debug_pub.add( 'SQL ERRM ----> '||sqlerrm);
1436: END IF;
1437: RAISE FND_API.G_EXC_ERROR;
1438: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1439: IF l_debug_level > 0 THEN
1440: oe_debug_pub.add( 'OEXUPTXB.pls: Unexp. error in call to Create_New_Payment_Trxn');
1441: oe_debug_pub.add( 'SQL ERRM ----> '||sqlerrm);
1434: oe_debug_pub.add( 'OEXUPTXB.pls: Exp. error in call to Create_New_Payment_Trxn');
1435: oe_debug_pub.add( 'SQL ERRM ----> '||sqlerrm);
1436: END IF;
1437: RAISE FND_API.G_EXC_ERROR;
1438: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1439: IF l_debug_level > 0 THEN
1440: oe_debug_pub.add( 'OEXUPTXB.pls: Unexp. error in call to Create_New_Payment_Trxn');
1441: oe_debug_pub.add( 'SQL ERRM ----> '||sqlerrm);
1442: END IF;
1439: IF l_debug_level > 0 THEN
1440: oe_debug_pub.add( 'OEXUPTXB.pls: Unexp. error in call to Create_New_Payment_Trxn');
1441: oe_debug_pub.add( 'SQL ERRM ----> '||sqlerrm);
1442: END IF;
1443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1444: END IF;
1445:
1446: IF l_debug_level > 0 THEN
1447: oe_debug_pub.add( 'OEXUPTXB.pls: After successful call to Create_New_Payment_Trxn');
1456: p_msg_data => l_msg_data,
1457: p_return_status => l_return_status,
1458: p_new_trxn_extension_id =>l_trxn_extension_id
1459: );
1460: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1461: IF l_debug_level > 0 THEN
1462: oe_debug_pub.add('Reverse_CreditCard_Auth error....exc',5);
1463: oe_debug_pub.add('After call to Reverse_CreditCard_Auth'||l_return_status,5);
1464: oe_debug_pub.add('Error'||sqlerrm,5);
1462: oe_debug_pub.add('Reverse_CreditCard_Auth error....exc',5);
1463: oe_debug_pub.add('After call to Reverse_CreditCard_Auth'||l_return_status,5);
1464: oe_debug_pub.add('Error'||sqlerrm,5);
1465: END IF;
1466: RAISE FND_API.G_EXC_ERROR;
1467:
1468: ELSIF l_return_status= FND_API.G_RET_STS_UNEXP_ERROR THEN
1469: IF l_debug_level > 0 THEN
1470: oe_debug_pub.add('After call to Reverse_CreditCard_Auth --> Unexpected error',5);
1464: oe_debug_pub.add('Error'||sqlerrm,5);
1465: END IF;
1466: RAISE FND_API.G_EXC_ERROR;
1467:
1468: ELSIF l_return_status= FND_API.G_RET_STS_UNEXP_ERROR THEN
1469: IF l_debug_level > 0 THEN
1470: oe_debug_pub.add('After call to Reverse_CreditCard_Auth --> Unexpected error',5);
1471: oe_debug_pub.add('Error message '||sqlerrm,5);
1472: END IF;
1469: IF l_debug_level > 0 THEN
1470: oe_debug_pub.add('After call to Reverse_CreditCard_Auth --> Unexpected error',5);
1471: oe_debug_pub.add('Error message '||sqlerrm,5);
1472: END IF;
1473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1474: ELSIF l_return_status=FND_API.G_RET_STS_SUCCESS Then
1475: IF l_debug_level > 0 THEN
1476: oe_debug_pub.add('Call to Reverse_CreditCard_Auth --> Success',5);
1477: end if;
1470: oe_debug_pub.add('After call to Reverse_CreditCard_Auth --> Unexpected error',5);
1471: oe_debug_pub.add('Error message '||sqlerrm,5);
1472: END IF;
1473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1474: ELSIF l_return_status=FND_API.G_RET_STS_SUCCESS Then
1475: IF l_debug_level > 0 THEN
1476: oe_debug_pub.add('Call to Reverse_CreditCard_Auth --> Success',5);
1477: end if;
1478: END IF;
1535: END IF;
1536:
1537: IBY_Fndcpt_Trxn_Pub.Create_Transaction_Extension
1538: (p_api_version => 1.0,
1539: p_init_msg_list => FND_API.G_TRUE,
1540: p_commit => FND_API.G_FALSE,
1541: X_return_status => l_return_status,
1542: X_msg_count => l_msg_count,
1543: X_msg_data => l_msg_data,
1536:
1537: IBY_Fndcpt_Trxn_Pub.Create_Transaction_Extension
1538: (p_api_version => 1.0,
1539: p_init_msg_list => FND_API.G_TRUE,
1540: p_commit => FND_API.G_FALSE,
1541: X_return_status => l_return_status,
1542: X_msg_count => l_msg_count,
1543: X_msg_data => l_msg_data,
1544: P_payer => l_payer,
1556: oe_debug_pub.add('Result code'||l_Response_code.result_code);
1557: oe_debug_pub.add('Return status'||l_Return_Status);
1558: END IF;
1559:
1560: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1561: IF l_debug_level > 0 THEN
1562: oe_debug_pub.add('Result error code in Create_Transaction_Extension'||l_response_code.result_code);
1563: END IF;
1564: RAISE FND_API.G_EXC_ERROR;
1560: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1561: IF l_debug_level > 0 THEN
1562: oe_debug_pub.add('Result error code in Create_Transaction_Extension'||l_response_code.result_code);
1563: END IF;
1564: RAISE FND_API.G_EXC_ERROR;
1565: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1566: IF l_debug_level > 0 THEN
1567: oe_debug_pub.add('Result error code in Create_Transaction_Extension'||l_response_code.result_code);
1568: END IF;
1561: IF l_debug_level > 0 THEN
1562: oe_debug_pub.add('Result error code in Create_Transaction_Extension'||l_response_code.result_code);
1563: END IF;
1564: RAISE FND_API.G_EXC_ERROR;
1565: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1566: IF l_debug_level > 0 THEN
1567: oe_debug_pub.add('Result error code in Create_Transaction_Extension'||l_response_code.result_code);
1568: END IF;
1569: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1565: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1566: IF l_debug_level > 0 THEN
1567: oe_debug_pub.add('Result error code in Create_Transaction_Extension'||l_response_code.result_code);
1568: END IF;
1569: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1570: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
1571: --CC Reversal ER#16014135 Start
1572: Begin
1573: oe_payment_trxn_util.Reverse_CreditCard_Auth
1566: IF l_debug_level > 0 THEN
1567: oe_debug_pub.add('Result error code in Create_Transaction_Extension'||l_response_code.result_code);
1568: END IF;
1569: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1570: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
1571: --CC Reversal ER#16014135 Start
1572: Begin
1573: oe_payment_trxn_util.Reverse_CreditCard_Auth
1574: (p_header_id => p_header_id,
1577: p_msg_data => l_msg_data,
1578: p_return_status => l_return_status,
1579: p_new_trxn_extension_id => l_trxn_extension_id
1580: );
1581: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1582: IF l_debug_level > 0 THEN
1583: oe_debug_pub.add('Reverse_CreditCard_Auth error....exc',5);
1584: oe_debug_pub.add('After call to Reverse_CreditCard_Auth'||l_return_status,5);
1585: oe_debug_pub.add('Error'||sqlerrm,5);
1583: oe_debug_pub.add('Reverse_CreditCard_Auth error....exc',5);
1584: oe_debug_pub.add('After call to Reverse_CreditCard_Auth'||l_return_status,5);
1585: oe_debug_pub.add('Error'||sqlerrm,5);
1586: END IF;
1587: RAISE FND_API.G_EXC_ERROR;
1588: ELSIF l_return_status= FND_API.G_RET_STS_UNEXP_ERROR Then
1589: IF l_debug_level > 0 THEN
1590: oe_debug_pub.add('After call to Reverse_CreditCard_Auth --> Unexpected error',5);
1591: oe_debug_pub.add('Error message '||sqlerrm,5);
1584: oe_debug_pub.add('After call to Reverse_CreditCard_Auth'||l_return_status,5);
1585: oe_debug_pub.add('Error'||sqlerrm,5);
1586: END IF;
1587: RAISE FND_API.G_EXC_ERROR;
1588: ELSIF l_return_status= FND_API.G_RET_STS_UNEXP_ERROR Then
1589: IF l_debug_level > 0 THEN
1590: oe_debug_pub.add('After call to Reverse_CreditCard_Auth --> Unexpected error',5);
1591: oe_debug_pub.add('Error message '||sqlerrm,5);
1592: END IF;
1589: IF l_debug_level > 0 THEN
1590: oe_debug_pub.add('After call to Reverse_CreditCard_Auth --> Unexpected error',5);
1591: oe_debug_pub.add('Error message '||sqlerrm,5);
1592: END IF;
1593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1594: ELSIF l_return_status=FND_API.G_RET_STS_SUCCESS Then
1595: IF l_debug_level > 0 THEN
1596: oe_debug_pub.add('Call to Reverse_CreditCard_Auth --> Success',5);
1597: end if;
1590: oe_debug_pub.add('After call to Reverse_CreditCard_Auth --> Unexpected error',5);
1591: oe_debug_pub.add('Error message '||sqlerrm,5);
1592: END IF;
1593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1594: ELSIF l_return_status=FND_API.G_RET_STS_SUCCESS Then
1595: IF l_debug_level > 0 THEN
1596: oe_debug_pub.add('Call to Reverse_CreditCard_Auth --> Success',5);
1597: end if;
1598: END IF;
1639: --Bug 7460481 ends
1640:
1641: IBY_Fndcpt_Trxn_Pub.Update_Transaction_Extension
1642: (p_api_version => 1.0,
1643: p_init_msg_list => FND_API.G_TRUE,
1644: p_commit => FND_API.G_FALSE,
1645: X_return_status => l_return_status,
1646: X_msg_count => l_msg_count,
1647: X_msg_data => l_msg_data,
1640:
1641: IBY_Fndcpt_Trxn_Pub.Update_Transaction_Extension
1642: (p_api_version => 1.0,
1643: p_init_msg_list => FND_API.G_TRUE,
1644: p_commit => FND_API.G_FALSE,
1645: X_return_status => l_return_status,
1646: X_msg_count => l_msg_count,
1647: X_msg_data => l_msg_data,
1648: P_payer => l_payer,
1657: IF l_debug_level > 0 THEN
1658: oe_debug_pub.add('After calling update transaction extension...');
1659: END IF;
1660:
1661: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1662: IF l_debug_level > 0 THEN
1663: oe_debug_pub.add('Result error code in Update_Transaction_Extension'||l_response_code.result_code);
1664: END IF;
1665: RAISE FND_API.G_EXC_ERROR;
1661: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1662: IF l_debug_level > 0 THEN
1663: oe_debug_pub.add('Result error code in Update_Transaction_Extension'||l_response_code.result_code);
1664: END IF;
1665: RAISE FND_API.G_EXC_ERROR;
1666: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1667: IF l_debug_level > 0 THEN
1668: oe_debug_pub.add('Result error code in Update_Transaction_Extension'||l_response_code.result_code);
1669: END IF;
1662: IF l_debug_level > 0 THEN
1663: oe_debug_pub.add('Result error code in Update_Transaction_Extension'||l_response_code.result_code);
1664: END IF;
1665: RAISE FND_API.G_EXC_ERROR;
1666: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1667: IF l_debug_level > 0 THEN
1668: oe_debug_pub.add('Result error code in Update_Transaction_Extension'||l_response_code.result_code);
1669: END IF;
1670: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1666: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1667: IF l_debug_level > 0 THEN
1668: oe_debug_pub.add('Result error code in Update_Transaction_Extension'||l_response_code.result_code);
1669: END IF;
1670: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1671: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
1672: IF l_debug_level > 0 THEN
1673: oe_debug_pub.add('Update_Transaction_Extension assignment Successful....');
1674: oe_debug_pub.add('After calling Update_Transaction_Extension');
1667: IF l_debug_level > 0 THEN
1668: oe_debug_pub.add('Result error code in Update_Transaction_Extension'||l_response_code.result_code);
1669: END IF;
1670: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1671: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
1672: IF l_debug_level > 0 THEN
1673: oe_debug_pub.add('Update_Transaction_Extension assignment Successful....');
1674: oe_debug_pub.add('After calling Update_Transaction_Extension');
1675: END IF;
1698: p_api_version => 1.0,
1699: X_return_status => l_return_status,
1700: X_msg_count => l_msg_count,
1701: X_msg_data => l_msg_data,
1702: p_commit => FND_API.G_FALSE,
1703: P_payer => l_payer,
1704: p_payer_equivalency => IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_IMMEDIATE,
1705: X_response => l_response_code,
1706: p_entity_id => p_trxn_extension_id);
1704: p_payer_equivalency => IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_IMMEDIATE,
1705: X_response => l_response_code,
1706: p_entity_id => p_trxn_extension_id);
1707:
1708: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1709: IF l_debug_level > 0 THEN
1710: oe_debug_pub.add('Result error code in Delete_Transaction_Extension'||l_response_code.result_code);
1711: oe_debug_pub.add('sql error'||sqlerrm);
1712: oe_debug_pub.add('msg data'||l_msg_data);
1710: oe_debug_pub.add('Result error code in Delete_Transaction_Extension'||l_response_code.result_code);
1711: oe_debug_pub.add('sql error'||sqlerrm);
1712: oe_debug_pub.add('msg data'||l_msg_data);
1713: END IF;
1714: RAISE FND_API.G_EXC_ERROR;
1715: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1716: IF l_debug_level > 0 THEN
1717: oe_debug_pub.add('Result error code in Delete_Transaction_Extension'||l_response_code.result_code);
1718: oe_debug_pub.add('sql error'||sqlerrm);
1711: oe_debug_pub.add('sql error'||sqlerrm);
1712: oe_debug_pub.add('msg data'||l_msg_data);
1713: END IF;
1714: RAISE FND_API.G_EXC_ERROR;
1715: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1716: IF l_debug_level > 0 THEN
1717: oe_debug_pub.add('Result error code in Delete_Transaction_Extension'||l_response_code.result_code);
1718: oe_debug_pub.add('sql error'||sqlerrm);
1719: oe_debug_pub.add('msg data'||l_msg_data);
1717: oe_debug_pub.add('Result error code in Delete_Transaction_Extension'||l_response_code.result_code);
1718: oe_debug_pub.add('sql error'||sqlerrm);
1719: oe_debug_pub.add('msg data'||l_msg_data);
1720: END IF;
1721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1722: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
1723: IF l_debug_level > 0 THEN
1724: oe_debug_pub.add('Delete_Transaction_Extension Successful....');
1725: oe_debug_pub.add('After calling Delete_Transaction_Extension');
1718: oe_debug_pub.add('sql error'||sqlerrm);
1719: oe_debug_pub.add('msg data'||l_msg_data);
1720: END IF;
1721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1722: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
1723: IF l_debug_level > 0 THEN
1724: oe_debug_pub.add('Delete_Transaction_Extension Successful....');
1725: oe_debug_pub.add('After calling Delete_Transaction_Extension');
1726: oe_debug_pub.add('sql error'||sqlerrm);
1733: ELSIF p_payment_type_code = 'CREDIT_CARD' THEN
1734: l_trxn_attribs.Originating_Application_Id := 660;
1735: l_trxn_attribs.Instrument_Security_Code := p_instrument_security_code;
1736: /*IF p_instrument_security_code IS NOT NULL AND
1737: NOT OE_GLOBALS.Equal(p_instrument_security_code,FND_API.G_MISS_CHAR) THEN
1738: --The bill to site has changed and a new credit card
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.
1759: END IF;
1760:
1761: IBY_Fndcpt_Trxn_Pub.Create_Transaction_Extension
1762: (p_api_version => 1.0,
1763: p_init_msg_list => FND_API.G_TRUE,
1764: p_commit => FND_API.G_FALSE,
1765: X_return_status => l_return_status,
1766: X_msg_count => l_msg_count,
1767: X_msg_data => l_msg_data,
1760:
1761: IBY_Fndcpt_Trxn_Pub.Create_Transaction_Extension
1762: (p_api_version => 1.0,
1763: p_init_msg_list => FND_API.G_TRUE,
1764: p_commit => FND_API.G_FALSE,
1765: X_return_status => l_return_status,
1766: X_msg_count => l_msg_count,
1767: X_msg_data => l_msg_data,
1768: P_payer => l_payer,
1780: oe_debug_pub.add('Result code'||l_Response_code.result_code);
1781: oe_debug_pub.add('Return status'||l_Return_Status);
1782: END IF;
1783:
1784: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1785: IF l_debug_level > 0 THEN
1786: oe_debug_pub.add('Result error code in Create_Transaction_Extension'||l_response_code.result_code);
1787: END IF;
1788: RAISE FND_API.G_EXC_ERROR;
1784: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1785: IF l_debug_level > 0 THEN
1786: oe_debug_pub.add('Result error code in Create_Transaction_Extension'||l_response_code.result_code);
1787: END IF;
1788: RAISE FND_API.G_EXC_ERROR;
1789: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1790: IF l_debug_level > 0 THEN
1791: oe_debug_pub.add('Result error code in Create_Transaction_Extension'||l_response_code.result_code);
1792: END IF;
1785: IF l_debug_level > 0 THEN
1786: oe_debug_pub.add('Result error code in Create_Transaction_Extension'||l_response_code.result_code);
1787: END IF;
1788: RAISE FND_API.G_EXC_ERROR;
1789: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1790: IF l_debug_level > 0 THEN
1791: oe_debug_pub.add('Result error code in Create_Transaction_Extension'||l_response_code.result_code);
1792: END IF;
1793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1789: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1790: IF l_debug_level > 0 THEN
1791: oe_debug_pub.add('Result error code in Create_Transaction_Extension'||l_response_code.result_code);
1792: END IF;
1793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1794: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
1795: --CC Reversal ER#16014135 Start
1796: Begin
1797: oe_payment_trxn_util.Reverse_CreditCard_Auth
1790: IF l_debug_level > 0 THEN
1791: oe_debug_pub.add('Result error code in Create_Transaction_Extension'||l_response_code.result_code);
1792: END IF;
1793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1794: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
1795: --CC Reversal ER#16014135 Start
1796: Begin
1797: oe_payment_trxn_util.Reverse_CreditCard_Auth
1798: (p_header_id => p_header_id,
1801: p_msg_data => l_msg_data,
1802: p_return_status => l_return_status,
1803: p_new_trxn_extension_id => l_trxn_extension_id
1804: );
1805: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1806: IF l_debug_level > 0 THEN
1807: oe_debug_pub.add('Reverse_CreditCard_Auth error....exc',5);
1808: oe_debug_pub.add('After call to Reverse_CreditCard_Auth'||l_return_status,5);
1809: oe_debug_pub.add('Error'||sqlerrm,5);
1807: oe_debug_pub.add('Reverse_CreditCard_Auth error....exc',5);
1808: oe_debug_pub.add('After call to Reverse_CreditCard_Auth'||l_return_status,5);
1809: oe_debug_pub.add('Error'||sqlerrm,5);
1810: END IF;
1811: RAISE FND_API.G_EXC_ERROR;
1812: ELSIF l_return_status= FND_API.G_RET_STS_UNEXP_ERROR Then
1813: IF l_debug_level > 0 THEN
1814: oe_debug_pub.add('After call to Reverse_CreditCard_Auth --> Unexpected error',5);
1815: oe_debug_pub.add('Error message '||sqlerrm,5);
1808: oe_debug_pub.add('After call to Reverse_CreditCard_Auth'||l_return_status,5);
1809: oe_debug_pub.add('Error'||sqlerrm,5);
1810: END IF;
1811: RAISE FND_API.G_EXC_ERROR;
1812: ELSIF l_return_status= FND_API.G_RET_STS_UNEXP_ERROR Then
1813: IF l_debug_level > 0 THEN
1814: oe_debug_pub.add('After call to Reverse_CreditCard_Auth --> Unexpected error',5);
1815: oe_debug_pub.add('Error message '||sqlerrm,5);
1816: END IF;
1813: IF l_debug_level > 0 THEN
1814: oe_debug_pub.add('After call to Reverse_CreditCard_Auth --> Unexpected error',5);
1815: oe_debug_pub.add('Error message '||sqlerrm,5);
1816: END IF;
1817: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1818: ELSIF l_return_status=FND_API.G_RET_STS_SUCCESS Then
1819: IF l_debug_level > 0 THEN
1820: oe_debug_pub.add('Call to Reverse_CreditCard_Auth --> Success',5);
1821: end if;
1814: oe_debug_pub.add('After call to Reverse_CreditCard_Auth --> Unexpected error',5);
1815: oe_debug_pub.add('Error message '||sqlerrm,5);
1816: END IF;
1817: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1818: ELSIF l_return_status=FND_API.G_RET_STS_SUCCESS Then
1819: IF l_debug_level > 0 THEN
1820: oe_debug_pub.add('Call to Reverse_CreditCard_Auth --> Success',5);
1821: end if;
1822: END IF;
1839: IF l_debug_level > 0 THEN
1840: oe_debug_pub.add('Exiting Update_Payment_Trxn.....');
1841: END IF;
1842:
1843: X_return_status := FND_API.G_RET_STS_SUCCESS;
1844:
1845: EXCEPTION
1846:
1847: WHEN FND_API.G_EXC_ERROR THEN
1843: X_return_status := FND_API.G_RET_STS_SUCCESS;
1844:
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
1844:
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: );
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;
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
1851: p_data => l_msg_data
1852: );
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
1852: );
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: );
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;
1862:
1863: WHEN OTHERS THEN
1864: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1865: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1860: );
1861: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1862:
1863: WHEN OTHERS THEN
1864: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1865: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1866: THEN
1867: FND_MSG_PUB.Add_Exc_Msg
1868: ( G_PKG_NAME
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;
1878:
1879: END Update_Payment_Trxn;
1880:
1881: Procedure Copy_Payment_Trxn( p_header_id IN NUMBER,
2007: END IF;
2008:
2009: IBY_FNDCPT_SETUP_PUB.Set_Payer_Instr_Assignment
2010: (p_api_version => 1.0,
2011: p_init_msg_list => FND_API.G_TRUE,
2012: p_commit => FND_API.G_FALSE,
2013: X_return_status => l_return_status,
2014: X_msg_count => l_msg_count,
2015: X_msg_data => l_msg_data,
2008:
2009: IBY_FNDCPT_SETUP_PUB.Set_Payer_Instr_Assignment
2010: (p_api_version => 1.0,
2011: p_init_msg_list => FND_API.G_TRUE,
2012: p_commit => FND_API.G_FALSE,
2013: X_return_status => l_return_status,
2014: X_msg_count => l_msg_count,
2015: X_msg_data => l_msg_data,
2016: P_payer => l_payer,
2017: P_assignment_attribs => l_assignment_attribs,
2018: X_assign_id => l_assign_id,
2019: X_response => l_response_code);
2020:
2021: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
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');
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;
2049: -- 16604394
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;
2047: END IF;
2048: END IF;
2049: -- 16604394
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
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;
2059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2060: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2061: IF l_debug_level > 0 THEN
2062: oe_debug_pub.add('Result code in Set_Payer_Instr_Assignment'||l_response_code.result_code);
2063: oe_debug_pub.add('new assignment id is: '||l_assign_id,1);
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;
2059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2060: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2061: IF l_debug_level > 0 THEN
2062: oe_debug_pub.add('Result code in Set_Payer_Instr_Assignment'||l_response_code.result_code);
2063: oe_debug_pub.add('new assignment id is: '||l_assign_id,1);
2064: END IF;
2095: oe_debug_pub.add('l_trxn_attribs.copy_instr_assign_id ---->'||l_assign_id);
2096: END IF;
2097: IBY_Fndcpt_Trxn_Pub.Copy_Transaction_Extension
2098: (p_api_version => 1.0,
2099: p_init_msg_list => FND_API.G_TRUE,
2100: p_commit => FND_API.G_FALSE,
2101: X_return_status => l_return_status,
2102: X_msg_count => l_msg_count,
2103: X_msg_data => l_msg_data,
2096: END IF;
2097: IBY_Fndcpt_Trxn_Pub.Copy_Transaction_Extension
2098: (p_api_version => 1.0,
2099: p_init_msg_list => FND_API.G_TRUE,
2100: p_commit => FND_API.G_FALSE,
2101: X_return_status => l_return_status,
2102: X_msg_count => l_msg_count,
2103: X_msg_data => l_msg_data,
2104: P_payer => l_payer,
2111: IF l_debug_level > 0 THEN
2112: oe_debug_pub.add('Return status from Copy_Transaction_Extension'||l_return_status);
2113: END IF;
2114:
2115: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2116: IF l_debug_level > 0 THEN
2117: oe_debug_pub.add('Result error code in Copy_Transaction_Extension'||l_response_code.result_code);
2118: END IF;
2119: --IF l_response_code.result_code = '
2116: IF l_debug_level > 0 THEN
2117: oe_debug_pub.add('Result error code in Copy_Transaction_Extension'||l_response_code.result_code);
2118: END IF;
2119: --IF l_response_code.result_code = '
2120: RAISE FND_API.G_EXC_ERROR;
2121: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2122: IF l_debug_level > 0 THEN
2123: oe_debug_pub.add('Result error code in Copy_Transaction_Extension'||l_response_code.result_code);
2124: END IF;
2117: oe_debug_pub.add('Result error code in Copy_Transaction_Extension'||l_response_code.result_code);
2118: END IF;
2119: --IF l_response_code.result_code = '
2120: RAISE FND_API.G_EXC_ERROR;
2121: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2122: IF l_debug_level > 0 THEN
2123: oe_debug_pub.add('Result error code in Copy_Transaction_Extension'||l_response_code.result_code);
2124: END IF;
2125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2121: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2122: IF l_debug_level > 0 THEN
2123: oe_debug_pub.add('Result error code in Copy_Transaction_Extension'||l_response_code.result_code);
2124: END IF;
2125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2126: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2127: IF l_debug_level > 0 THEN
2128: oe_debug_pub.add('Result code in Copy_Transaction_Extension'||l_response_code.result_code);
2129: END IF;
2122: IF l_debug_level > 0 THEN
2123: oe_debug_pub.add('Result error code in Copy_Transaction_Extension'||l_response_code.result_code);
2124: END IF;
2125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2126: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2127: IF l_debug_level > 0 THEN
2128: oe_debug_pub.add('Result code in Copy_Transaction_Extension'||l_response_code.result_code);
2129: END IF;
2130: END IF;
2132: IF l_debug_level > 0 THEN
2133: oe_debug_pub.add('Exiting OE_PAYMENT_TRXN_UTIL.Copy_Payment_Trxn.', 1);
2134: END IF;
2135:
2136: X_return_status := FND_API.G_RET_STS_SUCCESS;
2137:
2138: EXCEPTION
2139:
2140: WHEN FND_API.G_EXC_ERROR THEN
2136: X_return_status := FND_API.G_RET_STS_SUCCESS;
2137:
2138: EXCEPTION
2139:
2140: WHEN FND_API.G_EXC_ERROR THEN
2141: l_err_message := SQLERRM;
2142: IF l_debug_level > 0 THEN
2143: oe_debug_pub.add('Copy_Transaction_Extension error....exc');
2144: oe_debug_pub.add('After call to Copy_Transaction_Extension'||l_return_status);
2145: oe_debug_pub.add('Result code'||l_response_code.result_code);
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: );
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;
2155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2156: l_err_message := SQLERRM;
2157: IF l_debug_level > 0 THEN
2158: oe_debug_pub.add('Copy_Transaction_Extension error....unxc');
2151: ( p_count => l_msg_count,
2152: p_data => l_msg_data
2153: );
2154: RAISE FND_API.G_EXC_ERROR;
2155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2156: l_err_message := SQLERRM;
2157: IF l_debug_level > 0 THEN
2158: oe_debug_pub.add('Copy_Transaction_Extension error....unxc');
2159: oe_debug_pub.add('After call to Copy_Transaction_Extension'||l_return_status);
2160: oe_debug_pub.add('Result code'||l_response_code.result_code);
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: );
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;
2170:
2171: WHEN OTHERS THEN
2172: l_err_message := SQLERRM;
2173: IF l_debug_level > 0 THEN
2176: oe_debug_pub.add('Result code'||l_response_code.result_code);
2177: oe_debug_pub.add('trx Error'||l_err_message);
2178: END IF;
2179:
2180: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2181: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2182: THEN
2183: FND_MSG_PUB.Add_Exc_Msg
2184: ( G_PKG_NAME
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;
2194: --R12 CC Encryption
2195: END Copy_Payment_Trxn;
2196:
2197: Procedure Get_Payment_Trxn_Info(p_header_id IN NUMBER,
2235: BEGIN
2236:
2237: IF l_debug_level > 0 THEN
2238: oe_debug_pub.add('Entering Get_Payment_Trxn_Info...');
2239: x_return_status := FND_API.G_RET_STS_SUCCESS;
2240: END IF;
2241:
2242: --< if l_trxn_extension_id is null, this might be called from sales order header>
2243: IF l_trxn_extension_id IS NULL THEN
2356: IF l_debug_level > 0 THEN
2357: oe_debug_pub.add('Return status from Get_Authorization'||l_return_status);
2358: END IF;
2359:
2360: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2361: IF l_debug_level > 0 THEN
2362: oe_debug_pub.add('Result error code in Get_Authorization'||l_response.result_code);
2363: END IF;
2364: --IF l_response_code.result_code = '
2361: IF l_debug_level > 0 THEN
2362: oe_debug_pub.add('Result error code in Get_Authorization'||l_response.result_code);
2363: END IF;
2364: --IF l_response_code.result_code = '
2365: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2366: IF l_debug_level > 0 THEN
2367: oe_debug_pub.add('Result error code in Get_Authorization'||l_response.result_code);
2368: END IF;
2369: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2365: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2366: IF l_debug_level > 0 THEN
2367: oe_debug_pub.add('Result error code in Get_Authorization'||l_response.result_code);
2368: END IF;
2369: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2370: IF l_debug_level > 0 THEN
2371: oe_debug_pub.add('Success in Get_Authorization'||l_response.result_code);
2372: --oe_debug_pub.add('approval code ----> '||l_auth_result.auth_code);
2373: --oe_debug_pub.add('x_credit_card_approval_date ---> '||l_auth_result.auth_date);
2380: END IF; --Payment type code = 'Credit_card'
2381:
2382: END IF; --trxn extension id not null
2383:
2384: X_return_status := FND_API.G_RET_STS_SUCCESS;
2385:
2386: IF l_debug_level > 0 THEN
2387: oe_debug_pub.add('Exiting Get_Payment_Trxn_Info....');
2388: END IF;
2388: END IF;
2389:
2390: EXCEPTION
2391:
2392: WHEN FND_API.G_EXC_ERROR THEN
2393: l_err_message := SQLERRM;
2394: IF l_debug_level > 0 THEN
2395: oe_debug_pub.add('Get_Payment_Trxn_Info error....exc');
2396: oe_debug_pub.add('After call to Get_Payment_Trxn_Info'||l_return_status);
2403: ( p_count => l_msg_count,
2404: p_data => l_msg_data
2405: );
2406:
2407: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2408: l_err_message := SQLERRM;
2409: IF l_debug_level > 0 THEN
2410: oe_debug_pub.add('Get_Payment_Trxn_Info error....unxc');
2411: oe_debug_pub.add('After call to Get_Payment_Trxn_Info'||l_return_status);
2599: p_api_version => 1.0,
2600: X_return_status => l_return_status,
2601: X_msg_count => l_msg_count,
2602: X_msg_data => l_msg_data,
2603: p_commit => FND_API.G_FALSE,
2604: P_payer => l_payer,
2605: p_payer_equivalency => IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_IMMEDIATE,
2606: X_response => l_response_code,
2607: p_entity_id => p_trxn_extension_id);
2605: p_payer_equivalency => IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_IMMEDIATE,
2606: X_response => l_response_code,
2607: p_entity_id => p_trxn_extension_id);
2608:
2609: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2610: IF l_debug_level > 0 THEN
2611: oe_debug_pub.add('Result error code in Delete_Transaction_Extension'||l_response_code.result_code);
2612: oe_debug_pub.add('sql error'||sqlerrm);
2613: oe_debug_pub.add('msg data'||l_msg_data);
2611: oe_debug_pub.add('Result error code in Delete_Transaction_Extension'||l_response_code.result_code);
2612: oe_debug_pub.add('sql error'||sqlerrm);
2613: oe_debug_pub.add('msg data'||l_msg_data);
2614: END IF;
2615: RAISE FND_API.G_EXC_ERROR;
2616: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2617: IF l_debug_level > 0 THEN
2618: oe_debug_pub.add('Result error code in Delete_Transaction_Extension'||l_response_code.result_code);
2619: oe_debug_pub.add('sql error'||sqlerrm);
2612: oe_debug_pub.add('sql error'||sqlerrm);
2613: oe_debug_pub.add('msg data'||l_msg_data);
2614: END IF;
2615: RAISE FND_API.G_EXC_ERROR;
2616: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2617: IF l_debug_level > 0 THEN
2618: oe_debug_pub.add('Result error code in Delete_Transaction_Extension'||l_response_code.result_code);
2619: oe_debug_pub.add('sql error'||sqlerrm);
2620: oe_debug_pub.add('msg data'||l_msg_data);
2618: oe_debug_pub.add('Result error code in Delete_Transaction_Extension'||l_response_code.result_code);
2619: oe_debug_pub.add('sql error'||sqlerrm);
2620: oe_debug_pub.add('msg data'||l_msg_data);
2621: END IF;
2622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2623: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
2624: IF l_debug_level > 0 THEN
2625: oe_debug_pub.add('Delete_Transaction_Extension Successful....');
2626: oe_debug_pub.add('After calling Delete_Transaction_Extension');
2619: oe_debug_pub.add('sql error'||sqlerrm);
2620: oe_debug_pub.add('msg data'||l_msg_data);
2621: END IF;
2622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2623: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
2624: IF l_debug_level > 0 THEN
2625: oe_debug_pub.add('Delete_Transaction_Extension Successful....');
2626: oe_debug_pub.add('After calling Delete_Transaction_Extension');
2627: oe_debug_pub.add('sql error'||sqlerrm);
2626: oe_debug_pub.add('After calling Delete_Transaction_Extension');
2627: oe_debug_pub.add('sql error'||sqlerrm);
2628: oe_debug_pub.add('msg data'||l_msg_data);
2629: END IF;
2630: x_return_status := FND_API.G_RET_STS_SUCCESS;
2631: END IF;
2632: END IF;
2633: -- bug 5194228
2634: --CC Reversal ER#16014135 Start
2640: p_msg_count => l_msg_count,
2641: p_msg_data => l_msg_data,
2642: p_return_status => l_return_status
2643: );
2644: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2645: IF l_debug_level > 0 THEN
2646: oe_debug_pub.add('Reverse_CreditCard_Auth error....exc',5);
2647: oe_debug_pub.add('After call to Reverse_CreditCard_Auth'||l_return_status,5);
2648: oe_debug_pub.add('Error'||sqlerrm,5);
2646: oe_debug_pub.add('Reverse_CreditCard_Auth error....exc',5);
2647: oe_debug_pub.add('After call to Reverse_CreditCard_Auth'||l_return_status,5);
2648: oe_debug_pub.add('Error'||sqlerrm,5);
2649: END IF;
2650: RAISE FND_API.G_EXC_ERROR;
2651: ELSIF l_return_status= FND_API.G_RET_STS_UNEXP_ERROR Then
2652: IF l_debug_level > 0 THEN
2653: oe_debug_pub.add('After call to Reverse_CreditCard_Auth --> Unexpected error',5);
2654: oe_debug_pub.add('Error message '||sqlerrm,5);
2647: oe_debug_pub.add('After call to Reverse_CreditCard_Auth'||l_return_status,5);
2648: oe_debug_pub.add('Error'||sqlerrm,5);
2649: END IF;
2650: RAISE FND_API.G_EXC_ERROR;
2651: ELSIF l_return_status= FND_API.G_RET_STS_UNEXP_ERROR Then
2652: IF l_debug_level > 0 THEN
2653: oe_debug_pub.add('After call to Reverse_CreditCard_Auth --> Unexpected error',5);
2654: oe_debug_pub.add('Error message '||sqlerrm,5);
2655: END IF;
2652: IF l_debug_level > 0 THEN
2653: oe_debug_pub.add('After call to Reverse_CreditCard_Auth --> Unexpected error',5);
2654: oe_debug_pub.add('Error message '||sqlerrm,5);
2655: END IF;
2656: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2657: ELSIF l_return_status=FND_API.G_RET_STS_SUCCESS Then
2658: IF l_debug_level > 0 THEN
2659: oe_debug_pub.add('Call to Reverse_CreditCard_Auth --> Success',5);
2660: end if;
2653: oe_debug_pub.add('After call to Reverse_CreditCard_Auth --> Unexpected error',5);
2654: oe_debug_pub.add('Error message '||sqlerrm,5);
2655: END IF;
2656: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2657: ELSIF l_return_status=FND_API.G_RET_STS_SUCCESS Then
2658: IF l_debug_level > 0 THEN
2659: oe_debug_pub.add('Call to Reverse_CreditCard_Auth --> Success',5);
2660: end if;
2661: --need to evaluate again
2700: , p_msg_data => l_msg_data
2701: , p_result_out => l_result_out
2702: , p_return_status => l_return_status
2703: );
2704: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2705: RAISE FND_API.G_EXC_ERROR;
2706: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2708: END IF;
2701: , p_result_out => l_result_out
2702: , p_return_status => l_return_status
2703: );
2704: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2705: RAISE FND_API.G_EXC_ERROR;
2706: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2708: END IF;
2709:
2702: , p_return_status => l_return_status
2703: );
2704: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2705: RAISE FND_API.G_EXC_ERROR;
2706: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2708: END IF;
2709:
2710: END IF;
2703: );
2704: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2705: RAISE FND_API.G_EXC_ERROR;
2706: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2708: END IF;
2709:
2710: END IF;
2711:
2714: END;
2715: end if;
2716: --CC Reversal ER#16014135 End
2717: END;
2718: x_return_status := nvl(l_return_status,FND_API.G_RET_STS_SUCCESS); --Added for CC Reversal ER bug# 16595030
2719: EXCEPTION
2720:
2721: WHEN FND_API.G_EXC_ERROR THEN
2722: l_err_message := SQLERRM;
2717: END;
2718: x_return_status := nvl(l_return_status,FND_API.G_RET_STS_SUCCESS); --Added for CC Reversal ER bug# 16595030
2719: EXCEPTION
2720:
2721: WHEN FND_API.G_EXC_ERROR THEN
2722: l_err_message := SQLERRM;
2723: IF l_debug_level > 0 THEN
2724: oe_debug_pub.add('Delete_Payment_Trxn error....exc');
2725: oe_debug_pub.add('After call to Delete_Payment_Trxn'||l_return_status);
2726: oe_debug_pub.add('Result code'||l_response_code.result_code);
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: );
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;
2736:
2737: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2738: l_err_message := SQLERRM;
2739: IF l_debug_level > 0 THEN
2733: p_data => l_msg_data
2734: );
2735: RAISE FND_API.G_EXC_ERROR;
2736:
2737: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2738: l_err_message := SQLERRM;
2739: IF l_debug_level > 0 THEN
2740: oe_debug_pub.add('Delete_Payment_Trxn error....unxc');
2741: oe_debug_pub.add('After call to Delete_Payment_Trxn'||l_return_status);
2742: oe_debug_pub.add('Result code'||l_response_code.result_code);
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: );
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;
2752:
2753: WHEN OTHERS THEN
2754: l_err_message := SQLERRM;
2755: IF l_debug_level > 0 THEN
2758: oe_debug_pub.add('Result code'||l_response_code.result_code);
2759: oe_debug_pub.add('trx Error'||l_err_message);
2760: END IF;
2761:
2762: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2763: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2764: THEN
2765: FND_MSG_PUB.Add_Exc_Msg
2766: ( G_PKG_NAME
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;
2779: END Delete_Payment_Trxn;
2780:
2781: FUNCTION Get_Settled_Flag(p_Trxn_Extension_Id Number)
2782: RETURN VARCHAR2
2790: END IF;
2791:
2792: BEGIN
2793: IF p_trxn_extension_id IS NOT NULL AND
2794: NOT OE_GLOBALS.Equal(p_trxn_Extension_id, FND_API.G_MISS_NUM) THEN
2795: -- bug 8586227
2796: select settled_flag
2797: into l_Settled_flag
2798: from IBY_EXTN_SETTLEMENTS_V
2875: 'Get_CC_Security_Code_Use'
2876: );
2877: END IF;
2878:
2879: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2880:
2881: END Get_CC_Security_Code_Use;
2882:
2883: --CC Reversal ER#16014135 start
2923: l_result_out VARCHAR2(30);
2924:
2925: BEGIN
2926: --p_result_out := 'PASS' ;
2927: p_return_status := FND_API.G_RET_STS_SUCCESS;
2928:
2929: IF l_debug_level > 0 THEN
2930: oe_debug_pub.add( 'OEXPVPMB: Entering CREDIT CARD AUTHORIZATION REVERSAL',5 ) ;
2931: oe_debug_pub.add('p_header_id :'||p_header_id);
3123: oe_debug_pub.add('Calling IBY Create Reversal',5);
3124: END IF;
3125: IBY_Fndcpt_Trxn_Pub.Create_Reversal
3126: (p_api_version => 1.0,
3127: p_init_msg_list => FND_API.G_FALSE,
3128: p_payer => l_payer,
3129: p_payer_equivalency => IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_UPWARD,
3130: p_trxn_entity_id => l_trxn_extension_id,
3131: p_rev_attribs => l_rev_attribs,
3140: oe_debug_pub.add('Return Status after call to Create_Reversal'||l_return_status,5);
3141: OE_DEBUG_PUB.ADD('l_reversal_response.Result_Code: '||l_reversal_response.result_code,5);
3142: OE_DEBUG_PUB.ADD('l_reauth_response.result_code: '||l_reauth_response.result_code,5 );
3143: END IF;
3144: IF (l_return_status = FND_API.G_RET_STS_SUCCESS AND
3145: l_reversal_response.result_code = IBY_FNDCPT_TRXN_PUB.G_RC_REVERSAL_SUCCESS ) THEN
3146: IF l_debug_level > 0 THEN
3147: oe_debug_pub.add('Reversal successful....',5);
3148: END IF; --16594955 setting message token outside of l_debug_level condition
3189: , p_msg_data => l_msg_data
3190: , p_result_out => l_result_out
3191: , p_return_status => l_return_status
3192: );
3193: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3194: RAISE FND_API.G_EXC_ERROR;
3195: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3197: END IF;
3190: , p_result_out => l_result_out
3191: , p_return_status => l_return_status
3192: );
3193: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3194: RAISE FND_API.G_EXC_ERROR;
3195: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3197: END IF;
3198: */
3191: , p_return_status => l_return_status
3192: );
3193: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3194: RAISE FND_API.G_EXC_ERROR;
3195: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3197: END IF;
3198: */
3199:
3192: );
3193: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3194: RAISE FND_API.G_EXC_ERROR;
3195: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3197: END IF;
3198: */
3199:
3200: END IF;
3238: IF l_debug_level > 0 THEN
3239: oe_debug_pub.add( 'OEXPVPMB: Exiting CREDIT CARD AUTHORIZATION REVERSAL',1 ) ;
3240: END IF;
3241: EXCEPTION
3242: WHEN FND_API.G_EXC_ERROR THEN
3243: l_err_message := SQLERRM;
3244:
3245: IF l_debug_level > 0 THEN
3246: oe_debug_pub.add('Create_Reversal error....exc',5);
3248: oe_debug_pub.add('Result code'||l_reversal_response.result_code,5);
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: );
3254: ( p_count => l_msg_count,
3255: p_data => l_msg_data
3256: );
3257:
3258: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3259: l_err_message := SQLERRM;
3260:
3261: IF l_debug_level > 0 THEN
3262: oe_debug_pub.add('Create_Reversal error....unxc',5);
3264: oe_debug_pub.add('Result code'||l_reversal_response.result_code,5);
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: );
3275: l_err_message := SQLERRM;
3276: IF l_debug_level > 0 THEN
3277: oe_debug_pub.add('Returned error others part in Reverse_CreditCard_Auth...'||l_err_message,5);
3278: END IF;
3279: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3280:
3281: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3282: THEN
3283: FND_MSG_PUB.Add_Exc_Msg