eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_PREPAYMENT_PVT dependencies on FND_API

Line 155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

151: WHEN OTHERS THEN
152: IF l_debug_level > 0 THEN
153: oe_debug_pub.add( 'FROM Total_Invoiced_Amount OTHERS' ) ;
154: END IF;
155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
156:
157: END Total_Invoiced_Amount;
158:
159: /*--------------------------------------------------------------------------

Line 291: x_return_status := FND_API.G_RET_STS_SUCCESS;

287: IF l_debug_level > 0 THEN
288: oe_debug_pub.add( 'ENTERING OE_PREPAYMENT_PV.CREATE_RECEIPT.' , 1 ) ;
289: END IF;
290: x_result_out := 'PASS' ;
291: x_return_status := FND_API.G_RET_STS_SUCCESS;
292:
293: IF l_debug_level > 0 THEN
294: oe_debug_pub.add( 'OEXVPPYB: CALLING AR CREATE RECEIPT API ' , 3 ) ;
295: END IF;

Line 359: l_call_payment_processor := FND_API.G_TRUE;

355:
356: p_bank_account_id := null;
357:
358: IF p_trxn_extension_id IS NOT NULL THEN
359: l_call_payment_processor := FND_API.G_TRUE;
360: ELSE
361: l_call_payment_processor := FND_API.G_FALSE;
362: END IF;
363:

Line 361: l_call_payment_processor := FND_API.G_FALSE;

357:
358: IF p_trxn_extension_id IS NOT NULL THEN
359: l_call_payment_processor := FND_API.G_TRUE;
360: ELSE
361: l_call_payment_processor := FND_API.G_FALSE;
362: END IF;
363:
364: IF l_debug_level > 0 THEN
365: oe_debug_pub.add( 'OEXVPPYB: before calling AR Create_Prepayment: '||p_header_rec.header_id , 3 ) ;

Line 389: p_commit => FND_API.G_FALSE,

385: --changes for bug#8854662 end
386:
387: AR_PREPAYMENTS_PUB.create_prepayment(
388: p_api_version => 1.0,
389: p_commit => FND_API.G_FALSE,
390: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
391: x_return_status => x_return_status,
392: x_msg_count => x_msg_count,
393: x_msg_data => x_msg_data,

Line 390: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

386:
387: AR_PREPAYMENTS_PUB.create_prepayment(
388: p_api_version => 1.0,
389: p_commit => FND_API.G_FALSE,
390: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
391: x_return_status => x_return_status,
392: x_msg_count => x_msg_count,
393: x_msg_data => x_msg_data,
394: p_init_msg_list => FND_API.G_TRUE,

Line 394: p_init_msg_list => FND_API.G_TRUE,

390: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
391: x_return_status => x_return_status,
392: x_msg_count => x_msg_count,
393: x_msg_data => x_msg_data,
394: p_init_msg_list => FND_API.G_TRUE,
395: p_receipt_number => p_receipt_number, -- bug 4724845
396: p_amount => p_amount, -- pending_amount,
397: p_receipt_method_id => p_receipt_method_id,
398: --p_customer_id => p_header_rec.sold_to_org_id, --bug#8854662

Line 435: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

431: oe_debug_pub.add( 'OEXVPPYB: AFTER AR CREATE_PREPAYMENT x_msg_count IS: '||x_msg_count , 1 ) ;
432: oe_debug_pub.add( 'OEXVPPYB: AFTER AR CREATE_PREPAYMENT RETURN STATUS IS: '||X_RETURN_STATUS , 1 ) ;
433: END IF;
434:
435: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
436: IF x_msg_count = 1 THEN
437: IF l_debug_level > 0 THEN
438: oe_debug_pub.add('Error message after calling Create_Prepayment API: '||x_msg_data , 3 ) ;
439: END IF;

Line 450: -- l_msg_text := FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE);

446: oe_msg_pub.add_text(p_message_text => x_msg_data);
447: ELSIF ( FND_MSG_PUB.Count_Msg > 0 ) THEN
448: arp_util.enable_debug;
449: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
450: -- l_msg_text := FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE);
451: l_msg_text := FND_MSG_PUB.Get(i,'F');
452: IF l_debug_level > 0 THEN
453: oe_debug_pub.Add( 'Error message from AR API: '|| L_MSG_TEXT , 3 );
454: END IF;

Line 477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

473:
474: EXCEPTION
475: WHEN OTHERS THEN
476: x_result_out := 'FAIL';
477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
478: IF l_debug_level > 0 THEN
479: oe_debug_pub.add('Unexpected error in Create_Prepayment API: '||sqlerrm , 3 ) ;
480: END IF;
481:

Line 530: p_commit => FND_API.G_FALSE,

526: END IF;
527:
528: AR_PREPAYMENTS.refund_prepayments(
529: p_api_version => 1.0,
530: p_commit => FND_API.G_FALSE,
531: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
532: x_return_status => l_return_status,
533: x_msg_count => x_msg_count,
534: x_msg_data => x_msg_data,

Line 531: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

527:
528: AR_PREPAYMENTS.refund_prepayments(
529: p_api_version => 1.0,
530: p_commit => FND_API.G_FALSE,
531: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
532: x_return_status => l_return_status,
533: x_msg_count => x_msg_count,
534: x_msg_data => x_msg_data,
535: p_init_msg_list => FND_API.G_TRUE,

Line 535: p_init_msg_list => FND_API.G_TRUE,

531: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
532: x_return_status => l_return_status,
533: x_msg_count => x_msg_count,
534: x_msg_data => x_msg_data,
535: p_init_msg_list => FND_API.G_TRUE,
536: p_prepay_application_id => l_prepay_application_id, -- OUT NOCOPY /* file.sql.39 change */
537: p_number_of_refund_receipts => l_number_of_refund_receipts,
538: -- p_receipt_number => l_receipt_number,
539: p_receivables_trx_id => null,

Line 552: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

548: END IF;
549:
550: l_format_mask := get_format_mask(p_header_rec.transactional_curr_code);
551:
552: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
553: fnd_message.Set_Name('ONT', 'ONT_REFUND_PROCESS_SUCCESS');
554: FND_MESSAGE.SET_TOKEN('AMOUNT' , TO_CHAR(p_amount * -1, l_format_mask));
555: FND_MESSAGE.SET_TOKEN('NUMBER' , l_number_of_refund_receipts);
556: oe_msg_pub.add;

Line 575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

571: END IF;
572:
573: EXCEPTION WHEN OTHERS THEN
574: x_result_out := 'FAIL';
575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
576:
577: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
578: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , 'Refund_Request');
579: END IF;

Line 652: x_return_status := FND_API.G_RET_STS_SUCCESS;

648:
649: IF l_debug_level > 0 THEN
650: oe_debug_pub.add( 'OEXVPPYB: ENTERING PROCESS PREPAYMENT ORDER' , 1 ) ;
651: END IF;
652: x_return_status := FND_API.G_RET_STS_SUCCESS;
653:
654: -- calculate pending amount to be processed
655: l_pending_amount := OE_PrePayment_PVT.Calculate_Pending_Amount(l_header_rec);
656:

Line 668: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

664: , p_msg_data => l_msg_data
665: , p_return_status => l_return_status
666: );
667:
668: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
669: RAISE FND_API.G_EXC_ERROR;
670: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
671: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
672: END IF;

Line 669: RAISE FND_API.G_EXC_ERROR;

665: , p_return_status => l_return_status
666: );
667:
668: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
669: RAISE FND_API.G_EXC_ERROR;
670: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
671: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
672: END IF;
673: RETURN;

Line 670: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

666: );
667:
668: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
669: RAISE FND_API.G_EXC_ERROR;
670: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
671: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
672: END IF;
673: RETURN;
674: END IF;

Line 671: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

667:
668: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
669: RAISE FND_API.G_EXC_ERROR;
670: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
671: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
672: END IF;
673: RETURN;
674: END IF;
675:

Line 756: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

752: , p_msg_data => l_msg_data
753: , p_return_status => l_return_status
754: );
755:
756: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
757: RAISE FND_API.G_EXC_ERROR;
758: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
759: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
760: END IF;

Line 757: RAISE FND_API.G_EXC_ERROR;

753: , p_return_status => l_return_status
754: );
755:
756: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
757: RAISE FND_API.G_EXC_ERROR;
758: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
759: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
760: END IF;
761: END IF;

Line 758: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

754: );
755:
756: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
757: RAISE FND_API.G_EXC_ERROR;
758: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
759: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
760: END IF;
761: END IF;
762:

Line 759: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

755:
756: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
757: RAISE FND_API.G_EXC_ERROR;
758: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
759: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
760: END IF;
761: END IF;
762:
763: ELSE

Line 840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 872: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

868: , p_return_status => l_return_status
869: );
870: OE_GLOBALS.G_SYS_HOLD := FALSE; --8477694
871:
872: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
873:
874: IF l_debug_level > 0 THEN
875: oe_debug_pub.add( 'OEXVPPYB: ORDER IS PLACED ON PPP HOLD.' , 3 ) ;
876: END IF;

Line 877: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

873:
874: IF l_debug_level > 0 THEN
875: oe_debug_pub.add( 'OEXVPPYB: ORDER IS PLACED ON PPP HOLD.' , 3 ) ;
876: END IF;
877: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
878: RAISE FND_API.G_EXC_ERROR;
879: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
880: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
881: END IF;

Line 878: RAISE FND_API.G_EXC_ERROR;

874: IF l_debug_level > 0 THEN
875: oe_debug_pub.add( 'OEXVPPYB: ORDER IS PLACED ON PPP HOLD.' , 3 ) ;
876: END IF;
877: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
878: RAISE FND_API.G_EXC_ERROR;
879: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
880: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
881: END IF;
882:

Line 879: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

875: oe_debug_pub.add( 'OEXVPPYB: ORDER IS PLACED ON PPP HOLD.' , 3 ) ;
876: END IF;
877: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
878: RAISE FND_API.G_EXC_ERROR;
879: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
880: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
881: END IF;
882:
883: ELSIF l_epayment_failure_hold = 'Y' THEN

Line 880: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

876: END IF;
877: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
878: RAISE FND_API.G_EXC_ERROR;
879: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
880: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
881: END IF;
882:
883: ELSIF l_epayment_failure_hold = 'Y' THEN
884: OE_GLOBALS.G_SYS_HOLD := TRUE; --8477694

Line 892: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

888: , p_msg_data => l_msg_data
889: , p_return_status => l_return_status
890: );
891: OE_GLOBALS.G_SYS_HOLD := FALSE; --8477694
892: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
893: RAISE FND_API.G_EXC_ERROR;
894: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
895: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
896: END IF;

Line 893: RAISE FND_API.G_EXC_ERROR;

889: , p_return_status => l_return_status
890: );
891: OE_GLOBALS.G_SYS_HOLD := FALSE; --8477694
892: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
893: RAISE FND_API.G_EXC_ERROR;
894: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
895: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
896: END IF;
897: ELSE

Line 894: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

890: );
891: OE_GLOBALS.G_SYS_HOLD := FALSE; --8477694
892: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
893: RAISE FND_API.G_EXC_ERROR;
894: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
895: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
896: END IF;
897: ELSE
898: -- otherwise, call AR API to either create receipt or request refund.

Line 895: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

891: OE_GLOBALS.G_SYS_HOLD := FALSE; --8477694
892: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
893: RAISE FND_API.G_EXC_ERROR;
894: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
895: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
896: END IF;
897: ELSE
898: -- otherwise, call AR API to either create receipt or request refund.
899: -- check the installation status of IPayment

Line 955: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

951: oe_debug_pub.add( 'OEXVPPYB: RECEIPT NUMBER AFTER CREATE_RECEIPT: '||L_RECEIPT_NUMBER , 3 ) ; -- bug 4724845
952: oe_debug_pub.add( 'OEXVPPYB: RETURN_STATUS AFTER CALLING CREATE RECEIPT: '||L_RETURN_STATUS , 3 ) ;
953: END IF;
954:
955: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
956: -- If no error occurred in processing the payment, release any existing
957: -- prepayment holds.
958: l_format_mask := get_format_mask(p_header_rec.transactional_curr_code);
959:

Line 973: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

969: , p_msg_data => l_msg_data
970: , p_return_status => l_return_status
971: );
972:
973: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
974: RAISE FND_API.G_EXC_ERROR;
975: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
976: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
977: END IF;

Line 974: RAISE FND_API.G_EXC_ERROR;

970: , p_return_status => l_return_status
971: );
972:
973: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
974: RAISE FND_API.G_EXC_ERROR;
975: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
976: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
977: END IF;
978:

Line 975: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

971: );
972:
973: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
974: RAISE FND_API.G_EXC_ERROR;
975: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
976: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
977: END IF;
978:
979: -- to either insert or update the prepaid amount to oe_payments.

Line 976: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

972:
973: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
974: RAISE FND_API.G_EXC_ERROR;
975: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
976: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
977: END IF;
978:
979: -- to either insert or update the prepaid amount to oe_payments.
980: BEGIN

Line 1032: -- if l_return_status is not FND_API.G_RET_STS_SUCCESS

1028: END LOOP;
1029: CLOSE line_csr;
1030:
1031: ELSE
1032: -- if l_return_status is not FND_API.G_RET_STS_SUCCESS
1033: -- decode the error code return from AR, and apply the necessary holds.
1034: -- check for the existing holds, and apply the holds if non-existance.
1035: -- what is the seed id for ppp hold?
1036:

Line 1068: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1064: , p_msg_data => l_msg_data
1065: , p_return_status => l_return_status
1066: );
1067: OE_GLOBALS.G_SYS_HOLD := FALSE; --8477694
1068: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1069: RAISE FND_API.G_EXC_ERROR;
1070: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1071: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1072: END IF;

Line 1069: RAISE FND_API.G_EXC_ERROR;

1065: , p_return_status => l_return_status
1066: );
1067: OE_GLOBALS.G_SYS_HOLD := FALSE; --8477694
1068: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1069: RAISE FND_API.G_EXC_ERROR;
1070: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1071: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1072: END IF;
1073: ELSE

Line 1070: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1066: );
1067: OE_GLOBALS.G_SYS_HOLD := FALSE; --8477694
1068: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1069: RAISE FND_API.G_EXC_ERROR;
1070: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1071: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1072: END IF;
1073: ELSE
1074: -- for any other payment_response_error_code, need to apply epayment

Line 1071: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1067: OE_GLOBALS.G_SYS_HOLD := FALSE; --8477694
1068: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1069: RAISE FND_API.G_EXC_ERROR;
1070: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1071: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1072: END IF;
1073: ELSE
1074: -- for any other payment_response_error_code, need to apply epayment
1075: -- failure hold (seeded hold id is 14).

Line 1085: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1081: , p_return_status => l_return_status
1082: );
1083: OE_GLOBALS.G_SYS_HOLD := FALSE; --8477694
1084:
1085: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1086: RAISE FND_API.G_EXC_ERROR;
1087: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1089: END IF;

Line 1086: RAISE FND_API.G_EXC_ERROR;

1082: );
1083: OE_GLOBALS.G_SYS_HOLD := FALSE; --8477694
1084:
1085: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1086: RAISE FND_API.G_EXC_ERROR;
1087: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1089: END IF;
1090:

Line 1087: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1083: OE_GLOBALS.G_SYS_HOLD := FALSE; --8477694
1084:
1085: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1086: RAISE FND_API.G_EXC_ERROR;
1087: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1089: END IF;
1090:
1091:

Line 1088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1084:
1085: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1086: RAISE FND_API.G_EXC_ERROR;
1087: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1089: END IF;
1090:
1091:
1092: END IF; -- end of checking l_payment_response_error_code.

Line 1126: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1122: IF l_debug_level > 0 THEN
1123: oe_debug_pub.add( 'OEXVPPYB: RETURN STATUS AFTER CALLING REFUND IS: '||L_RETURN_STATUS , 1 ) ;
1124: END IF;
1125:
1126: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1127: IF l_debug_level > 0 THEN
1128: oe_debug_pub.add( 'OEXVPPYB: RELEASING PREPAYMENT HOLD AFTER REFUND PROCESS.' , 3 ) ;
1129: END IF;
1130: Release_Prepayment_Hold ( p_header_id => l_header_rec.header_id

Line 1136: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1132: , p_msg_data => l_msg_data
1133: , p_return_status => l_return_status
1134: );
1135:
1136: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1137: RAISE FND_API.G_EXC_ERROR;
1138: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1140: END IF;

Line 1137: RAISE FND_API.G_EXC_ERROR;

1133: , p_return_status => l_return_status
1134: );
1135:
1136: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1137: RAISE FND_API.G_EXC_ERROR;
1138: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1140: END IF;
1141:

Line 1138: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1134: );
1135:
1136: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1137: RAISE FND_API.G_EXC_ERROR;
1138: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1140: END IF;
1141:
1142: UPDATE oe_payments

Line 1139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1135:
1136: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1137: RAISE FND_API.G_EXC_ERROR;
1138: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1140: END IF;
1141:
1142: UPDATE oe_payments
1143: SET prepaid_amount = nvl(prepaid_amount,0) + l_pending_amount

Line 1160: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1156: EXIT WHEN line_csr%NOTFOUND;
1157: END LOOP;
1158: CLOSE line_csr;
1159:
1160: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1161: RAISE FND_API.G_EXC_ERROR;
1162: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1164: END IF;

Line 1161: RAISE FND_API.G_EXC_ERROR;

1157: END LOOP;
1158: CLOSE line_csr;
1159:
1160: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1161: RAISE FND_API.G_EXC_ERROR;
1162: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1164: END IF;
1165:

Line 1162: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1158: CLOSE line_csr;
1159:
1160: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1161: RAISE FND_API.G_EXC_ERROR;
1162: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1164: END IF;
1165:
1166: END IF;

Line 1163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1159:
1160: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1161: RAISE FND_API.G_EXC_ERROR;
1162: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1164: END IF;
1165:
1166: END IF;
1167: END IF;

Line 1177: WHEN FND_API.G_EXC_ERROR THEN

1173: END IF;
1174:
1175: EXCEPTION
1176:
1177: WHEN FND_API.G_EXC_ERROR THEN
1178: x_return_status := FND_API.G_RET_STS_ERROR;
1179: OE_MSG_PUB.Count_And_Get
1180: ( p_count => l_msg_count,
1181: p_data => l_msg_data

Line 1178: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1184: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1188: p_data => l_msg_data
1189: );
1190:
1191: WHEN OTHERS THEN
1192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1193: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1194: THEN
1195: OE_MSG_PUB.Add_Exc_Msg
1196: ( G_PKG_NAME

Line 1243: IF l_hold_result = FND_API.G_TRUE THEN

1239: , x_return_status => l_return_status
1240: );
1241:
1242: -- Check the Result
1243: IF l_hold_result = FND_API.G_TRUE THEN
1244: p_hold_exists := 'Y';
1245: IF l_debug_level > 0 THEN
1246: oe_debug_pub.add( 'OEXVPPYB: PREPAYMENT HOLD 13 EXISTS ON ORDER' , 3 ) ;
1247: END IF;

Line 1261: IF l_hold_result = FND_API.G_TRUE THEN

1257: , x_msg_count => l_msg_count
1258: , x_msg_data => l_msg_data
1259: , x_return_status => l_return_status
1260: );
1261: IF l_hold_result = FND_API.G_TRUE THEN
1262: p_hold_exists := 'Y';
1263: IF l_debug_level > 0 THEN
1264: oe_debug_pub.add( 'OEXVPPYB: PREPAYMENT HOLD 14 EXISTS ON ORDER' , 3 ) ;
1265: END IF;

Line 1279: IF l_hold_result = FND_API.G_TRUE THEN

1275: , x_msg_count => l_msg_count
1276: , x_msg_data => l_msg_data
1277: , x_return_status => l_return_status
1278: );
1279: IF l_hold_result = FND_API.G_TRUE THEN
1280: p_hold_exists := 'Y';
1281: IF l_debug_level > 0 THEN
1282: oe_debug_pub.add( 'OEXVPPYB: PREPAYMENT HOLD 15 EXISTS ON ORDER' , 3 ) ;
1283: END IF;

Line 1335: p_return_status := FND_API.G_RET_STS_SUCCESS;

1331: --
1332: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1333: --
1334: BEGIN
1335: p_return_status := FND_API.G_RET_STS_SUCCESS;
1336:
1337: IF l_debug_level > 0 THEN
1338: oe_debug_pub.add( 'OEXVPPYB: IN APPLY PREPAYMENT HOLDS' , 3 ) ;
1339: oe_debug_pub.add( 'OEXVPPYB: HEADER ID : '||P_HEADER_ID , 3 ) ;

Line 1375: , p_validation_level => FND_API.G_VALID_LEVEL_NONE

1371: END IF;
1372:
1373: OE_Holds_PUB.Apply_Holds
1374: ( p_api_version => 1.0
1375: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
1376: , p_hold_source_rec => l_hold_source_rec
1377: , x_msg_count => l_msg_count
1378: , x_msg_data => l_msg_data
1379: , x_return_status => l_return_status

Line 1382: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1378: , x_msg_data => l_msg_data
1379: , x_return_status => l_return_status
1380: );
1381:
1382: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1383: IF p_hold_id = 13 THEN
1384: FND_MESSAGE.SET_NAME('ONT','ONT_PPP_HOLD_APPLIED');
1385: OE_MSG_PUB.ADD;
1386: IF l_debug_level > 0 THEN

Line 1403: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1399: oe_debug_pub.add( 'OEXVPPYB: payment server failure hold has been applied on order.', 3 ) ;
1400: END IF;
1401: END IF;
1402:
1403: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1404: RAISE FND_API.G_EXC_ERROR;
1405: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1407: END IF;

Line 1404: RAISE FND_API.G_EXC_ERROR;

1400: END IF;
1401: END IF;
1402:
1403: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1404: RAISE FND_API.G_EXC_ERROR;
1405: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1407: END IF;
1408:

Line 1405: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1401: END IF;
1402:
1403: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1404: RAISE FND_API.G_EXC_ERROR;
1405: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1407: END IF;
1408:
1409: IF l_debug_level > 0 THEN

Line 1406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1402:
1403: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1404: RAISE FND_API.G_EXC_ERROR;
1405: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1407: END IF;
1408:
1409: IF l_debug_level > 0 THEN
1410: oe_debug_pub.add( 'OEXVPPYB: APPLIED PREPAYMENT HOLD ON HEADER ID:' || P_HEADER_ID , 3 ) ;

Line 1415: WHEN FND_API.G_EXC_ERROR THEN

1411: END IF;
1412:
1413: EXCEPTION
1414:
1415: WHEN FND_API.G_EXC_ERROR THEN
1416: p_return_status := FND_API.G_RET_STS_ERROR;
1417: OE_MSG_PUB.Count_And_Get
1418: ( p_count => l_msg_count,
1419: p_data => l_msg_data

Line 1416: p_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1422: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1423: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1430: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1426: p_data => l_msg_data
1427: );
1428:
1429: WHEN OTHERS THEN
1430: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1431: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1432: THEN
1433: FND_MSG_PUB.Add_Exc_Msg
1434: ( G_PKG_NAME

Line 1473: p_return_status := FND_API.G_RET_STS_SUCCESS;

1469: --
1470: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1471: --
1472: BEGIN
1473: p_return_status := FND_API.G_RET_STS_SUCCESS;
1474: OE_GLOBALS.G_SYS_HOLD := TRUE; --8477694
1475:
1476: IF l_debug_level > 0 THEN
1477: oe_debug_pub.add( 'OEXVPPYB: IN RELEASE PREPAYMENT HOLD' , 3 ) ;

Line 1518: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1514: , x_msg_data => l_msg_data
1515: , x_return_status => l_return_status
1516: );
1517:
1518: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1519: RAISE FND_API.G_EXC_ERROR;
1520: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1521: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1522: END IF;

Line 1519: RAISE FND_API.G_EXC_ERROR;

1515: , x_return_status => l_return_status
1516: );
1517:
1518: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1519: RAISE FND_API.G_EXC_ERROR;
1520: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1521: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1522: END IF;
1523: --bug3599715 start

Line 1520: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1516: );
1517:
1518: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1519: RAISE FND_API.G_EXC_ERROR;
1520: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1521: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1522: END IF;
1523: --bug3599715 start
1524: fnd_message.Set_Name('ONT', 'ONT_PPP_HOLD_RELEASED');

Line 1521: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1517:
1518: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1519: RAISE FND_API.G_EXC_ERROR;
1520: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1521: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1522: END IF;
1523: --bug3599715 start
1524: fnd_message.Set_Name('ONT', 'ONT_PPP_HOLD_RELEASED');
1525: oe_msg_pub.add;

Line 1562: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1558: , x_msg_data => l_msg_data
1559: , x_return_status => l_return_status
1560: );
1561:
1562: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1563: RAISE FND_API.G_EXC_ERROR;
1564: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1566: END IF;

Line 1563: RAISE FND_API.G_EXC_ERROR;

1559: , x_return_status => l_return_status
1560: );
1561:
1562: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1563: RAISE FND_API.G_EXC_ERROR;
1564: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1566: END IF;
1567: fnd_message.Set_Name('ONT', 'ONT_PMNT_FAIL_HOLD_RELEASED');

Line 1564: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1560: );
1561:
1562: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1563: RAISE FND_API.G_EXC_ERROR;
1564: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1566: END IF;
1567: fnd_message.Set_Name('ONT', 'ONT_PMNT_FAIL_HOLD_RELEASED');
1568: oe_msg_pub.add;

Line 1565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1561:
1562: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1563: RAISE FND_API.G_EXC_ERROR;
1564: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1566: END IF;
1567: fnd_message.Set_Name('ONT', 'ONT_PMNT_FAIL_HOLD_RELEASED');
1568: oe_msg_pub.add;
1569: END IF;

Line 1604: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1600: , x_msg_data => l_msg_data
1601: , x_return_status => l_return_status
1602: );
1603:
1604: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1605: RAISE FND_API.G_EXC_ERROR;
1606: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1608: END IF;

Line 1605: RAISE FND_API.G_EXC_ERROR;

1601: , x_return_status => l_return_status
1602: );
1603:
1604: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1605: RAISE FND_API.G_EXC_ERROR;
1606: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1608: END IF;
1609: fnd_message.Set_Name('ONT', 'ONT_PMNT_SERVER_HOLD_RELEASED');

Line 1606: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1602: );
1603:
1604: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1605: RAISE FND_API.G_EXC_ERROR;
1606: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1608: END IF;
1609: fnd_message.Set_Name('ONT', 'ONT_PMNT_SERVER_HOLD_RELEASED');
1610: oe_msg_pub.add;

Line 1607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1603:
1604: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1605: RAISE FND_API.G_EXC_ERROR;
1606: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1608: END IF;
1609: fnd_message.Set_Name('ONT', 'ONT_PMNT_SERVER_HOLD_RELEASED');
1610: oe_msg_pub.add;
1611: END IF;

Line 1615: WHEN FND_API.G_EXC_ERROR THEN

1611: END IF;
1612: OE_GLOBALS.G_SYS_HOLD := FALSE; --8477694
1613: EXCEPTION
1614:
1615: WHEN FND_API.G_EXC_ERROR THEN
1616: OE_GLOBALS.G_SYS_HOLD := FALSE; --8477694
1617: p_return_status := FND_API.G_RET_STS_ERROR;
1618: OE_MSG_PUB.Count_And_Get
1619: ( p_count => l_msg_count,

Line 1617: p_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1623: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1625: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1633: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1629: );
1630:
1631: WHEN OTHERS THEN
1632: OE_GLOBALS.G_SYS_HOLD := FALSE; --8477694
1633: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1634: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1635: THEN
1636: FND_MSG_PUB.Add_Exc_Msg
1637: ( G_PKG_NAME

Line 1677: p_return_status := FND_API.G_RET_STS_SUCCESS;

1673: --
1674: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1675: --
1676: BEGIN
1677: p_return_status := FND_API.G_RET_STS_SUCCESS;
1678:
1679: IF l_debug_level > 0 THEN
1680: oe_debug_pub.add( 'OEXVPPYB: IN RELEASE PAYMENT HOLD' , 3 ) ;
1681: END IF;

Line 1731: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1727: OE_GLOBALS.G_SYS_HOLD := FALSE;
1728: END IF;
1729: --8477694
1730:
1731: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1732: RAISE FND_API.G_EXC_ERROR;
1733: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1734: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1735: END IF;

Line 1732: RAISE FND_API.G_EXC_ERROR;

1728: END IF;
1729: --8477694
1730:
1731: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1732: RAISE FND_API.G_EXC_ERROR;
1733: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1734: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1735: END IF;
1736: END IF;

Line 1733: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1729: --8477694
1730:
1731: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1732: RAISE FND_API.G_EXC_ERROR;
1733: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1734: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1735: END IF;
1736: END IF;
1737:

Line 1734: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1730:
1731: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1732: RAISE FND_API.G_EXC_ERROR;
1733: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1734: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1735: END IF;
1736: END IF;
1737:
1738:

Line 1741: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1742: p_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1748: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1749: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1756: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1752: p_data => l_msg_data
1753: );
1754:
1755: WHEN OTHERS THEN
1756: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1757: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1758: THEN
1759: FND_MSG_PUB.Add_Exc_Msg
1760: ( G_PKG_NAME

Line 1906: x_return_status := FND_API.G_RET_STS_SUCCESS;

1902: oe_debug_pub.add( 'OEXVPPYB: Entering Process_Payments procedure.' , 1 ) ;
1903: oe_debug_pub.add( 'OEXVPPYB: l_calling_action is: '||l_calling_action , 1 ) ;
1904: oe_debug_pub.add( 'OEXVPPYB: p_delayed_request is: '||p_delayed_request , 1 ) ;
1905: END IF;
1906: x_return_status := FND_API.G_RET_STS_SUCCESS;
1907:
1908:
1909: oe_Header_util.query_row (p_header_id => p_Header_id
1910: ,x_header_rec=> l_header_rec );

Line 2049: OR (l_calling_action='UPDATE' AND p_delayed_request=FND_API.G_TRUE))

2045:
2046: IF ((nvl(c_payment_rec.defer_payment_processing_flag, 'N') = 'Y'
2047: AND l_calling_action = 'BOOKING')
2048: --bug3507871
2049: OR (l_calling_action='UPDATE' AND p_delayed_request=FND_API.G_TRUE))
2050: AND ( l_pending_amount <> 0 or c_payment_rec.payment_amount IS NULL ) THEN -- Modified for bug 8478559
2051: -- if calling action is null, this is invoked from action, we
2052: -- need to process payments regardless of the defer flag.
2053: -- Apply PPP prepayment hold (hold id 13) on the order;

Line 2069: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

2065: ,p_return_status => l_return_status
2066: );
2067: OE_GLOBALS.G_SYS_HOLD := FALSE; --8477694
2068:
2069: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2070: IF l_debug_level > 0 THEN
2071: oe_debug_pub.add( 'OEXVPPYB: ORDER IS PLACED ON PPP HOLD.' , 3 ) ;
2072: END IF;
2073: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 2073: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2069: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2070: IF l_debug_level > 0 THEN
2071: oe_debug_pub.add( 'OEXVPPYB: ORDER IS PLACED ON PPP HOLD.' , 3 ) ;
2072: END IF;
2073: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2074: RAISE FND_API.G_EXC_ERROR;
2075: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2077: END IF;

Line 2074: RAISE FND_API.G_EXC_ERROR;

2070: IF l_debug_level > 0 THEN
2071: oe_debug_pub.add( 'OEXVPPYB: ORDER IS PLACED ON PPP HOLD.' , 3 ) ;
2072: END IF;
2073: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2074: RAISE FND_API.G_EXC_ERROR;
2075: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2077: END IF;
2078: ELSE

Line 2075: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2071: oe_debug_pub.add( 'OEXVPPYB: ORDER IS PLACED ON PPP HOLD.' , 3 ) ;
2072: END IF;
2073: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2074: RAISE FND_API.G_EXC_ERROR;
2075: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2077: END IF;
2078: ELSE
2079: -- process the payments.

Line 2076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2072: END IF;
2073: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2074: RAISE FND_API.G_EXC_ERROR;
2075: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2077: END IF;
2078: ELSE
2079: -- process the payments.
2080:

Line 2131: RAISE FND_API.G_EXC_ERROR;

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

Line 2176: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

2172: IF l_debug_level > 0 THEN
2173: oe_debug_pub.add( 'OEXVPPYB: After calling Create_Receipt API, return status is: '||l_return_status, 3) ;
2174: END IF;
2175:
2176: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2177:
2178: IF l_debug_level > 0 THEN
2179: oe_debug_pub.add( 'OEXVPPYB: update oe_payments for payment_set_id: '||l_payment_set_id, 3) ;
2180: END IF;

Line 2211: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2207: , p_msg_data => l_msg_data
2208: , p_return_status => l_return_status
2209: );
2210:
2211: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2212: RAISE FND_API.G_EXC_ERROR;
2213: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2215: END IF;

Line 2212: RAISE FND_API.G_EXC_ERROR;

2208: , p_return_status => l_return_status
2209: );
2210:
2211: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2212: RAISE FND_API.G_EXC_ERROR;
2213: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2215: END IF;
2216: END IF;

Line 2213: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2209: );
2210:
2211: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2212: RAISE FND_API.G_EXC_ERROR;
2213: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2215: END IF;
2216: END IF;
2217:

Line 2214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2210:
2211: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2212: RAISE FND_API.G_EXC_ERROR;
2213: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2215: END IF;
2216: END IF;
2217:
2218: -- END IF; -- if l_insert = 'Y'

Line 2250: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2246: ,p_msg_data => l_msg_data
2247: ,p_return_status => l_return_status
2248: );
2249: OE_GLOBALS.G_SYS_HOLD := FALSE; --8477694
2250: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2251: RAISE FND_API.G_EXC_ERROR;
2252: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2253: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2254: END IF;

Line 2251: RAISE FND_API.G_EXC_ERROR;

2247: ,p_return_status => l_return_status
2248: );
2249: OE_GLOBALS.G_SYS_HOLD := FALSE; --8477694
2250: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2251: RAISE FND_API.G_EXC_ERROR;
2252: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2253: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2254: END IF;
2255:

Line 2252: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2248: );
2249: OE_GLOBALS.G_SYS_HOLD := FALSE; --8477694
2250: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2251: RAISE FND_API.G_EXC_ERROR;
2252: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2253: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2254: END IF;
2255:
2256: ELSE

Line 2253: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2249: OE_GLOBALS.G_SYS_HOLD := FALSE; --8477694
2250: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2251: RAISE FND_API.G_EXC_ERROR;
2252: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2253: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2254: END IF;
2255:
2256: ELSE
2257: -- Apply payment failure hold (seeded hold id is 14);

Line 2270: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2266: ,p_msg_data => l_msg_data
2267: ,p_return_status => l_return_status
2268: );
2269: OE_GLOBALS.G_SYS_HOLD := FALSE; --8477694
2270: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2271: RAISE FND_API.G_EXC_ERROR;
2272: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2273: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2274: END IF;

Line 2271: RAISE FND_API.G_EXC_ERROR;

2267: ,p_return_status => l_return_status
2268: );
2269: OE_GLOBALS.G_SYS_HOLD := FALSE; --8477694
2270: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2271: RAISE FND_API.G_EXC_ERROR;
2272: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2273: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2274: END IF;
2275:

Line 2272: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2268: );
2269: OE_GLOBALS.G_SYS_HOLD := FALSE; --8477694
2270: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2271: RAISE FND_API.G_EXC_ERROR;
2272: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2273: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2274: END IF;
2275:
2276: END IF; -- if l_payment_response_error_code...

Line 2273: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2269: OE_GLOBALS.G_SYS_HOLD := FALSE; --8477694
2270: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2271: RAISE FND_API.G_EXC_ERROR;
2272: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2273: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2274: END IF;
2275:
2276: END IF; -- if l_payment_response_error_code...
2277: END IF; -- if l_return status...

Line 2301: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

2297: IF l_debug_level > 0 THEN
2298: oe_debug_pub.add( 'OEXVPPYB Process_Payments: after calling create_refund, return status is: '||l_return_status, 3 ) ;
2299: END IF;
2300:
2301: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2302: UPDATE oe_payments
2303: SET prepaid_amount = nvl(prepaid_amount,0) + l_pending_amount
2304: WHERE header_id = p_header_id
2305: AND nvl(payment_number, -1) = nvl(c_payment_rec.payment_number, -1);

Line 2307: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2303: SET prepaid_amount = nvl(prepaid_amount,0) + l_pending_amount
2304: WHERE header_id = p_header_id
2305: AND nvl(payment_number, -1) = nvl(c_payment_rec.payment_number, -1);
2306:
2307: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2308: -- Apply payment failure hold (seeded hold id is 14);
2309: IF l_debug_level > 0 THEN
2310: oe_debug_pub.add( 'after create_refund, applying payment failure hold.', 3 ) ;
2311: END IF;

Line 2333: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2329: ,p_msg_data => l_msg_data
2330: ,p_return_status => l_return_status
2331: );
2332: OE_GLOBALS.G_SYS_HOLD := FALSE; --8477694
2333: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2334: RAISE FND_API.G_EXC_ERROR;
2335: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2337: END IF;

Line 2334: RAISE FND_API.G_EXC_ERROR;

2330: ,p_return_status => l_return_status
2331: );
2332: OE_GLOBALS.G_SYS_HOLD := FALSE; --8477694
2333: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2334: RAISE FND_API.G_EXC_ERROR;
2335: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2337: END IF;
2338:

Line 2335: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2331: );
2332: OE_GLOBALS.G_SYS_HOLD := FALSE; --8477694
2333: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2334: RAISE FND_API.G_EXC_ERROR;
2335: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2337: END IF;
2338:
2339: END IF;

Line 2336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2332: OE_GLOBALS.G_SYS_HOLD := FALSE; --8477694
2333: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2334: RAISE FND_API.G_EXC_ERROR;
2335: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2337: END IF;
2338:
2339: END IF;
2340: ELSIF l_pending_amount = 0 THEN

Line 2347: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2343: , p_msg_data => l_msg_data
2344: , p_return_status => l_return_status
2345: );
2346:
2347: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2348: RAISE FND_API.G_EXC_ERROR;
2349: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2351: END IF;

Line 2348: RAISE FND_API.G_EXC_ERROR;

2344: , p_return_status => l_return_status
2345: );
2346:
2347: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2348: RAISE FND_API.G_EXC_ERROR;
2349: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2351: END IF;
2352:

Line 2349: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2345: );
2346:
2347: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2348: RAISE FND_API.G_EXC_ERROR;
2349: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2351: END IF;
2352:
2353: END IF; -- if l_pending_amount > 0 ...

Line 2350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2346:
2347: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2348: RAISE FND_API.G_EXC_ERROR;
2349: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2351: END IF;
2352:
2353: END IF; -- if l_pending_amount > 0 ...
2354:

Line 2460: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2456: oe_debug_pub.add( 'OEXVPPYB: After calling OE_Verify_Payment_PUB.Authorize_MultiPayments, return status is: '||l_return_status, 3) ;
2457: END IF;
2458:
2459:
2460: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2461: RAISE FND_API.G_EXC_ERROR;
2462: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2464: END IF;

Line 2461: RAISE FND_API.G_EXC_ERROR;

2457: END IF;
2458:
2459:
2460: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2461: RAISE FND_API.G_EXC_ERROR;
2462: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2464: END IF;
2465:

Line 2462: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2458:
2459:
2460: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2461: RAISE FND_API.G_EXC_ERROR;
2462: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2464: END IF;
2465:
2466: END IF; -- end of CC authorization.

Line 2463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2459:
2460: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2461: RAISE FND_API.G_EXC_ERROR;
2462: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2464: END IF;
2465:
2466: END IF; -- end of CC authorization.
2467:

Line 2599: WHEN FND_API.G_EXC_ERROR THEN

2595: END IF;
2596:
2597: EXCEPTION
2598:
2599: WHEN FND_API.G_EXC_ERROR THEN
2600: x_return_status := FND_API.G_RET_STS_ERROR;
2601: OE_MSG_PUB.Count_And_Get
2602: ( p_count => l_msg_count,
2603: p_data => l_msg_data

Line 2600: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2606: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2602: ( p_count => l_msg_count,
2603: p_data => l_msg_data
2604: );
2605:
2606: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2608: IF l_debug_level > 0 THEN
2609: oe_debug_pub.add( 'Unexpected error in Process_Payments: ' || SQLERRM , 3 ) ;
2610: END IF;

Line 2607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2603: p_data => l_msg_data
2604: );
2605:
2606: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2608: IF l_debug_level > 0 THEN
2609: oe_debug_pub.add( 'Unexpected error in Process_Payments: ' || SQLERRM , 3 ) ;
2610: END IF;
2611: OE_MSG_PUB.Count_And_Get

Line 2617: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2613: p_data => l_msg_data
2614: );
2615:
2616: WHEN OTHERS THEN
2617: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2618: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2619: THEN
2620: FND_MSG_PUB.Add_Exc_Msg
2621: ( G_PKG_NAME

Line 2782: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE

2778: oe_debug_pub.add('OEXVPPYB: before OE_Order_PVT.Line_Payments',3);
2779: END IF;
2780:
2781: OE_Order_PVT.Line_Payments
2782: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
2783: , p_init_msg_list => FND_API.G_TRUE
2784: , p_control_rec => l_control_rec
2785: , p_x_Line_Payment_tbl => l_Line_Payment_tbl
2786: , p_x_old_Line_Payment_tbl => l_x_old_Line_Payment_tbl

Line 2783: , p_init_msg_list => FND_API.G_TRUE

2779: END IF;
2780:
2781: OE_Order_PVT.Line_Payments
2782: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
2783: , p_init_msg_list => FND_API.G_TRUE
2784: , p_control_rec => l_control_rec
2785: , p_x_Line_Payment_tbl => l_Line_Payment_tbl
2786: , p_x_old_Line_Payment_tbl => l_x_old_Line_Payment_tbl
2787: , x_return_Status => l_return_status

Line 2790: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2786: , p_x_old_Line_Payment_tbl => l_x_old_Line_Payment_tbl
2787: , x_return_Status => l_return_status
2788: );
2789:
2790: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2792: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2793: RAISE FND_API.G_EXC_ERROR;
2794: END IF;

Line 2791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2787: , x_return_Status => l_return_status
2788: );
2789:
2790: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2792: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2793: RAISE FND_API.G_EXC_ERROR;
2794: END IF;
2795:

Line 2792: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2788: );
2789:
2790: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2792: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2793: RAISE FND_API.G_EXC_ERROR;
2794: END IF;
2795:
2796: End If;

Line 2793: RAISE FND_API.G_EXC_ERROR;

2789:
2790: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2792: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2793: RAISE FND_API.G_EXC_ERROR;
2794: END IF;
2795:
2796: End If;
2797:

Line 2830: WHEN FND_API.G_EXC_ERROR THEN

2826: END IF;
2827:
2828: EXCEPTION
2829:
2830: WHEN FND_API.G_EXC_ERROR THEN
2831: x_return_status := FND_API.G_RET_STS_ERROR;
2832:
2833: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2831: x_return_status := FND_API.G_RET_STS_ERROR;

2827:
2828: EXCEPTION
2829:
2830: WHEN FND_API.G_EXC_ERROR THEN
2831: x_return_status := FND_API.G_RET_STS_ERROR;
2832:
2833: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2835: oe_debug_pub.add(G_PKG_NAME||':split_payment :'||SQLERRM);

Line 2833: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2829:
2830: WHEN FND_API.G_EXC_ERROR THEN
2831: x_return_status := FND_API.G_RET_STS_ERROR;
2832:
2833: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2835: oe_debug_pub.add(G_PKG_NAME||':split_payment :'||SQLERRM);
2836:
2837: WHEN OTHERS THEN

Line 2834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2830: WHEN FND_API.G_EXC_ERROR THEN
2831: x_return_status := FND_API.G_RET_STS_ERROR;
2832:
2833: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2835: oe_debug_pub.add(G_PKG_NAME||':split_payment :'||SQLERRM);
2836:
2837: WHEN OTHERS THEN
2838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2835: oe_debug_pub.add(G_PKG_NAME||':split_payment :'||SQLERRM);
2836:
2837: WHEN OTHERS THEN
2838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2839: If FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) Then
2840: OE_MSG_PUB.Add_Exc_Msg
2841: ( G_PKG_NAME
2842: , 'Split_Payment '

Line 2845: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2841: ( G_PKG_NAME
2842: , 'Split_Payment '
2843: );
2844: End If;
2845: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2846:
2847: END Split_Payment;
2848:
2849: PROCEDURE Process_Payment_Assurance

Line 2907: x_return_status := FND_API.G_RET_STS_SUCCESS;

2903: IF l_debug_level > 0 THEN
2904: oe_debug_pub.add('Entering OE_Prepayment_PVT.Process_Payment_Assurance for line: '||p_line_id, 1);
2905: END IF;
2906:
2907: x_return_status := FND_API.G_RET_STS_SUCCESS;
2908: x_result_out := 'COMPLETE:COMPLETE';
2909:
2910: --pnpl start
2911: IF nvl(p_exists_prepay,'N') = 'Y' THEN

Line 2939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2935: WHEN OTHERS THEN
2936: IF l_debug_level > 0 THEN
2937: oe_debug_pub.add('unable to get header_id.. raising unexpected error');
2938: END IF;
2939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2940: END;
2941:
2942: IF l_exists_prepay THEN
2943: IF l_debug_level > 0 THEN

Line 2975: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2971: ,x_msg_data => x_msg_data
2972: ,x_return_status => l_return_status
2973: );
2974:
2975: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2976: l_pay_now_total := 0;
2977: END IF;
2978:
2979: IF l_debug_level > 0 THEN

Line 3077: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3073:
3074: IF l_debug_level > 0 THEN
3075: oe_debug_pub.add('Return status 1 from update_flow_status_code for pay now instrument check: '||l_return_status , 3 ) ;
3076: END IF;
3077: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3078: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3079: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3080: RAISE FND_API.G_EXC_ERROR;
3081: END IF;

Line 3078: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3074: IF l_debug_level > 0 THEN
3075: oe_debug_pub.add('Return status 1 from update_flow_status_code for pay now instrument check: '||l_return_status , 3 ) ;
3076: END IF;
3077: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3078: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3079: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3080: RAISE FND_API.G_EXC_ERROR;
3081: END IF;
3082:

Line 3079: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3075: oe_debug_pub.add('Return status 1 from update_flow_status_code for pay now instrument check: '||l_return_status , 3 ) ;
3076: END IF;
3077: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3078: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3079: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3080: RAISE FND_API.G_EXC_ERROR;
3081: END IF;
3082:
3083: IF l_debug_level > 0 THEN

Line 3080: RAISE FND_API.G_EXC_ERROR;

3076: END IF;
3077: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3078: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3079: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3080: RAISE FND_API.G_EXC_ERROR;
3081: END IF;
3082:
3083: IF l_debug_level > 0 THEN
3084: oe_debug_pub.add('Returning from the procedure as there is no prepayment record for the order');

Line 3112: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3108:
3109: IF l_debug_level > 0 THEN
3110: oe_debug_pub.add('Return status 2 from update_flow_status_code for pay now instrument check: '||l_return_status , 3 ) ;
3111: END IF;
3112: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3114: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3115: RAISE FND_API.G_EXC_ERROR;
3116: END IF;

Line 3113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3109: IF l_debug_level > 0 THEN
3110: oe_debug_pub.add('Return status 2 from update_flow_status_code for pay now instrument check: '||l_return_status , 3 ) ;
3111: END IF;
3112: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3114: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3115: RAISE FND_API.G_EXC_ERROR;
3116: END IF;
3117:

Line 3114: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3110: oe_debug_pub.add('Return status 2 from update_flow_status_code for pay now instrument check: '||l_return_status , 3 ) ;
3111: END IF;
3112: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3114: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3115: RAISE FND_API.G_EXC_ERROR;
3116: END IF;
3117:
3118: x_return_status := l_return_status;

Line 3115: RAISE FND_API.G_EXC_ERROR;

3111: END IF;
3112: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3114: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3115: RAISE FND_API.G_EXC_ERROR;
3116: END IF;
3117:
3118: x_return_status := l_return_status;
3119: RETURN;

Line 3224: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3220:
3221: IF l_debug_level > 0 THEN
3222: oe_debug_pub.add('Return status 1 from update_flow_status_code: '||l_return_status , 3 ) ;
3223: END IF;
3224: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3225: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3226: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3227: RAISE FND_API.G_EXC_ERROR;
3228: END IF;

Line 3225: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3221: IF l_debug_level > 0 THEN
3222: oe_debug_pub.add('Return status 1 from update_flow_status_code: '||l_return_status , 3 ) ;
3223: END IF;
3224: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3225: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3226: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3227: RAISE FND_API.G_EXC_ERROR;
3228: END IF;
3229: ELSIF x_result_out = 'COMPLETE:INCOMPLETE' THEN

Line 3226: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3222: oe_debug_pub.add('Return status 1 from update_flow_status_code: '||l_return_status , 3 ) ;
3223: END IF;
3224: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3225: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3226: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3227: RAISE FND_API.G_EXC_ERROR;
3228: END IF;
3229: ELSIF x_result_out = 'COMPLETE:INCOMPLETE' THEN
3230: --bug4950878

Line 3227: RAISE FND_API.G_EXC_ERROR;

3223: END IF;
3224: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3225: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3226: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3227: RAISE FND_API.G_EXC_ERROR;
3228: END IF;
3229: ELSIF x_result_out = 'COMPLETE:INCOMPLETE' THEN
3230: --bug4950878
3231: fnd_message.Set_Name('ONT', 'ONT_PAYMENT_NOT_ASSURED');

Line 3242: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3238:
3239: IF l_debug_level > 0 THEN
3240: oe_debug_pub.add('Return status 2 from update_flow_status_code: '||l_return_status , 3 ) ;
3241: END IF;
3242: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3244: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3245: RAISE FND_API.G_EXC_ERROR;
3246: END IF;

Line 3243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3239: IF l_debug_level > 0 THEN
3240: oe_debug_pub.add('Return status 2 from update_flow_status_code: '||l_return_status , 3 ) ;
3241: END IF;
3242: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3244: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3245: RAISE FND_API.G_EXC_ERROR;
3246: END IF;
3247: END IF;

Line 3244: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3240: oe_debug_pub.add('Return status 2 from update_flow_status_code: '||l_return_status , 3 ) ;
3241: END IF;
3242: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3244: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3245: RAISE FND_API.G_EXC_ERROR;
3246: END IF;
3247: END IF;
3248:

Line 3245: RAISE FND_API.G_EXC_ERROR;

3241: END IF;
3242: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3244: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3245: RAISE FND_API.G_EXC_ERROR;
3246: END IF;
3247: END IF;
3248:
3249: x_return_status := l_return_status;

Line 3257: WHEN FND_API.G_EXC_ERROR THEN

3253: oe_debug_pub.add('Exiting OE_Prepayment_PVT.Process_Payment_Assurance for line: '||p_line_id, 1);
3254: END IF;
3255:
3256: EXCEPTION
3257: WHEN FND_API.G_EXC_ERROR THEN
3258: x_return_status := FND_API.G_RET_STS_ERROR;
3259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3261: WHEN OTHERS THEN

Line 3258: x_return_status := FND_API.G_RET_STS_ERROR;

3254: END IF;
3255:
3256: EXCEPTION
3257: WHEN FND_API.G_EXC_ERROR THEN
3258: x_return_status := FND_API.G_RET_STS_ERROR;
3259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3261: WHEN OTHERS THEN
3262: IF l_debug_level > 0 THEN

Line 3259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3255:
3256: EXCEPTION
3257: WHEN FND_API.G_EXC_ERROR THEN
3258: x_return_status := FND_API.G_RET_STS_ERROR;
3259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3261: WHEN OTHERS THEN
3262: IF l_debug_level > 0 THEN
3263: oe_debug_pub.add( 'ORACLE ERROR: ' || SQLERRM , 1 ) ;

Line 3260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3256: EXCEPTION
3257: WHEN FND_API.G_EXC_ERROR THEN
3258: x_return_status := FND_API.G_RET_STS_ERROR;
3259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3261: WHEN OTHERS THEN
3262: IF l_debug_level > 0 THEN
3263: oe_debug_pub.add( 'ORACLE ERROR: ' || SQLERRM , 1 ) ;
3264: END IF;

Line 3265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 3298: x_return_status := FND_API.G_RET_STS_SUCCESS;

3294: begin
3295: If l_debug_level > 0 Then
3296: oe_debug_pub.add('entering OE_PrePayment_PVT.print_payment_receipt');
3297: End If;
3298: x_return_status := FND_API.G_RET_STS_SUCCESS;
3299: x_result_out := 'COMPLETE:COMPLETE';
3300: select order_source_id, orig_sys_document_ref, change_sequence
3301: ,source_document_type_id, source_document_id
3302: into l_order_source_id, l_orig_sys_document_ref, l_change_sequence,

Line 3339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3335: OE_MSG_PUB.Add;
3336:
3337: IF (l_new_request_id = 0) THEN
3338: errbuf := FND_MESSAGE.GET;
3339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3340: END IF;
3341:
3342: EXCEPTION
3343:

Line 3344: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3340: END IF;
3341:
3342: EXCEPTION
3343:
3344: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3345: If l_debug_level > 0 Then
3346: oe_debug_pub.add( 'UNEXPECTED ERROR. EXITING FROM PAYMENT RECEIPT: '||SQLERRM , 1 ) ;
3347: End If;
3348: oe_msg_pub.Add_Text(errbuf);

Line 3349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 3363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3359: ( G_PKG_NAME
3360: , 'Print_Payment_Receipt'
3361: );
3362: END IF;
3363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3364:
3365: END Print_Payment_Receipt;
3366:
3367: --R12 CC Encryption

Line 3413: x_return_status := FND_API.G_RET_STS_SUCCESS;

3409: AND payment_type_code IN ('CREDIT_CARD','ACH','DIRECT_DEBIT');
3410:
3411: BEGIN
3412:
3413: x_return_status := FND_API.G_RET_STS_SUCCESS;
3414:
3415: IF l_debug_level > 0 THEN
3416: oe_debug_pub.add('Entering OEXVPPYB Delete_Payments');
3417: END IF;

Line 3443: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

3439: x_msg_count => x_msg_count,
3440: x_msg_data => x_msg_data);
3441:
3442:
3443: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3444: RAISE FND_API.G_EXC_ERROR;
3445: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3447: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 3444: RAISE FND_API.G_EXC_ERROR;

3440: x_msg_data => x_msg_data);
3441:
3442:
3443: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3444: RAISE FND_API.G_EXC_ERROR;
3445: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3447: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
3448: DELETE FROM OE_PAYMENTS

Line 3445: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3441:
3442:
3443: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3444: RAISE FND_API.G_EXC_ERROR;
3445: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3447: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
3448: DELETE FROM OE_PAYMENTS
3449: WHERE HEADER_ID = p_header_id

Line 3446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3442:
3443: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3444: RAISE FND_API.G_EXC_ERROR;
3445: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3447: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
3448: DELETE FROM OE_PAYMENTS
3449: WHERE HEADER_ID = p_header_id
3450: AND LINE_ID = p_line_id

Line 3447: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

3443: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3444: RAISE FND_API.G_EXC_ERROR;
3445: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3447: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
3448: DELETE FROM OE_PAYMENTS
3449: WHERE HEADER_ID = p_header_id
3450: AND LINE_ID = p_line_id
3451: AND payment_number = line_payments_rec.payment_number;

Line 3479: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

3475: x_return_status => l_return_status,
3476: x_msg_count => x_msg_count,
3477: x_msg_data => x_msg_data);
3478:
3479: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3480: RAISE FND_API.G_EXC_ERROR;
3481: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3483: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 3480: RAISE FND_API.G_EXC_ERROR;

3476: x_msg_count => x_msg_count,
3477: x_msg_data => x_msg_data);
3478:
3479: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3480: RAISE FND_API.G_EXC_ERROR;
3481: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3483: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
3484: DELETE FROM OE_PAYMENTS

Line 3481: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3477: x_msg_data => x_msg_data);
3478:
3479: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3480: RAISE FND_API.G_EXC_ERROR;
3481: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3483: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
3484: DELETE FROM OE_PAYMENTS
3485: WHERE HEADER_ID = p_header_id

Line 3482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3478:
3479: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3480: RAISE FND_API.G_EXC_ERROR;
3481: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3483: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
3484: DELETE FROM OE_PAYMENTS
3485: WHERE HEADER_ID = p_header_id
3486: AND payment_number = header_payments_rec.payment_number

Line 3483: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

3479: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3480: RAISE FND_API.G_EXC_ERROR;
3481: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3483: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
3484: DELETE FROM OE_PAYMENTS
3485: WHERE HEADER_ID = p_header_id
3486: AND payment_number = header_payments_rec.payment_number
3487: AND line_id is null;

Line 3497: x_return_status := FND_API.G_RET_STS_SUCCESS;

3493: header_id = p_header_id;
3494: IF l_debug_level > 0 THEN
3495: oe_debug_pub.add('Header id...after updating oe order headers all'||p_header_id);
3496: END IF;
3497: x_return_status := FND_API.G_RET_STS_SUCCESS;
3498: END IF;
3499: END IF;
3500: END LOOP;
3501: END IF;

Line 3505: WHEN FND_API.G_EXC_ERROR THEN

3501: END IF;
3502:
3503: EXCEPTION
3504:
3505: WHEN FND_API.G_EXC_ERROR THEN
3506: x_return_status := FND_API.G_RET_STS_ERROR;
3507: OE_MSG_PUB.Count_And_Get
3508: ( p_count => x_msg_count,
3509: p_data => x_msg_data

Line 3506: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 3512: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3508: ( p_count => x_msg_count,
3509: p_data => x_msg_data
3510: );
3511:
3512: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3514: IF l_debug_level > 0 THEN
3515: oe_debug_pub.add( 'Unexpected error in Delete_Payments: ' || SQLERRM , 3 ) ;
3516: END IF;

Line 3513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3509: p_data => x_msg_data
3510: );
3511:
3512: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3514: IF l_debug_level > 0 THEN
3515: oe_debug_pub.add( 'Unexpected error in Delete_Payments: ' || SQLERRM , 3 ) ;
3516: END IF;
3517: OE_MSG_PUB.Count_And_Get

Line 3523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3519: p_data => x_msg_data
3520: );
3521:
3522: WHEN OTHERS THEN
3523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3524: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3525: THEN
3526: FND_MSG_PUB.Add_Exc_Msg
3527: ( G_PKG_NAME

Line 3550: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;

3546: x_return_status out nocopy varchar2,
3547: x_msg_count out nocopy number,
3548: x_msg_data out nocopy varchar2) is
3549:
3550: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
3551: l_msg_count number := 0;
3552: l_msg_data varchar2(2000) := NULL;
3553: l_del_payment number := 0; -- 0 means do not delete, 1 means delete.
3554:

Line 3698: x_return_status := FND_API.G_RET_STS_ERROR;

3694: if p_action = 'UPDATE_LINE' then
3695:
3696: if p_line_id is null then
3697:
3698: x_return_status := FND_API.G_RET_STS_ERROR;
3699: oe_debug_pub.add('failed because line_id is null ');
3700: return;
3701:
3702: else

Line 3713: x_return_status := FND_API.G_RET_STS_ERROR;

3709: where line_id = p_line_id
3710: for update nowait;
3711:
3712: if l_lock_line_id is null then
3713: x_return_status := FND_API.G_RET_STS_ERROR;
3714: oe_debug_pub.add('failed to lock the line with line_id : ' || l_lock_line_id);
3715: return;
3716: end if;
3717:

Line 3751: x_return_status := FND_API.G_RET_STS_ERROR;

3747: where line_id = l_lock_line_id;
3748:
3749: exception
3750: when others then
3751: x_return_status := FND_API.G_RET_STS_ERROR;
3752: oe_debug_pub.add('failed to update line payment type: ' || substr(sqlerrm,1,300));
3753: rollback to savepoint update_line;
3754: return;
3755: End;

Line 3868: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

3864: (p_header_id => p_header_id
3865: ,p_x_header_rec => l_old_header_rec
3866: ,x_return_status => l_return_status
3867: );
3868: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3869: RAISE FND_API.G_EXC_ERROR;
3870: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3872: END IF;

Line 3869: RAISE FND_API.G_EXC_ERROR;

3865: ,p_x_header_rec => l_old_header_rec
3866: ,x_return_status => l_return_status
3867: );
3868: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3869: RAISE FND_API.G_EXC_ERROR;
3870: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3872: END IF;
3873:

Line 3870: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3866: ,x_return_status => l_return_status
3867: );
3868: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3869: RAISE FND_API.G_EXC_ERROR;
3870: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3872: END IF;
3873:
3874: l_header_rec := l_old_header_rec;

Line 3871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3867: );
3868: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3869: RAISE FND_API.G_EXC_ERROR;
3870: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3872: END IF;
3873:
3874: l_header_rec := l_old_header_rec;
3875: l_header_rec.payment_type_code := l_payment_type_code;

Line 3941: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

3937: l_header_rec.credit_card_approval_code;
3938: OE_ORDER_UTIL.g_header_rec.lock_control:=
3939: l_header_rec.lock_control;
3940:
3941: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3942: RAISE FND_API.G_EXC_ERROR;
3943: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3945: END IF;

Line 3942: RAISE FND_API.G_EXC_ERROR;

3938: OE_ORDER_UTIL.g_header_rec.lock_control:=
3939: l_header_rec.lock_control;
3940:
3941: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3942: RAISE FND_API.G_EXC_ERROR;
3943: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3945: END IF;
3946:

Line 3943: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3939: l_header_rec.lock_control;
3940:
3941: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3942: RAISE FND_API.G_EXC_ERROR;
3943: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3945: END IF;
3946:
3947: oe_debug_pub.add( 'OEXPVPMB: BEFORE CALLING PROCESS_REQUESTS_AND_NOTIFY' ) ;

Line 3944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3940:
3941: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3942: RAISE FND_API.G_EXC_ERROR;
3943: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3945: END IF;
3946:
3947: oe_debug_pub.add( 'OEXPVPMB: BEFORE CALLING PROCESS_REQUESTS_AND_NOTIFY' ) ;
3948:

Line 3957: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

3953: , p_old_header_rec => l_old_header_rec
3954: , x_return_status => l_return_status
3955: );
3956:
3957: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3958: RAISE FND_API.G_EXC_ERROR;
3959: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3961: END IF;

Line 3958: RAISE FND_API.G_EXC_ERROR;

3954: , x_return_status => l_return_status
3955: );
3956:
3957: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3958: RAISE FND_API.G_EXC_ERROR;
3959: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3961: END IF;
3962:

Line 3959: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3955: );
3956:
3957: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3958: RAISE FND_API.G_EXC_ERROR;
3959: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3961: END IF;
3962:
3963: END IF ; /* global entity index null check */

Line 3960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3956:
3957: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3958: RAISE FND_API.G_EXC_ERROR;
3959: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3961: END IF;
3962:
3963: END IF ; /* global entity index null check */
3964: END IF; --code_release_level check

Line 4170: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE

4166: oe_debug_pub.add('l_x_old_header_payment_tbl ' || l_x_old_header_payment_tbl.count);
4167:
4168: -- Call OE_Order_PVT.Header_Payments
4169: OE_Order_PVT.Header_Payments
4170: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
4171: , p_init_msg_list => FND_API.G_TRUE
4172: , p_control_rec => l_control_rec
4173: , p_x_Header_Payment_tbl => l_x_Header_Payment_tbl
4174: , p_x_old_Header_Payment_tbl => l_x_old_Header_Payment_tbl

Line 4171: , p_init_msg_list => FND_API.G_TRUE

4167:
4168: -- Call OE_Order_PVT.Header_Payments
4169: OE_Order_PVT.Header_Payments
4170: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
4171: , p_init_msg_list => FND_API.G_TRUE
4172: , p_control_rec => l_control_rec
4173: , p_x_Header_Payment_tbl => l_x_Header_Payment_tbl
4174: , p_x_old_Header_Payment_tbl => l_x_old_Header_Payment_tbl
4175: , x_return_Status => l_return_status

Line 4178: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4174: , p_x_old_Header_Payment_tbl => l_x_old_Header_Payment_tbl
4175: , x_return_Status => l_return_status
4176: );
4177:
4178: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4180: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4181: RAISE FND_API.G_EXC_ERROR;
4182: END IF;

Line 4179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4175: , x_return_Status => l_return_status
4176: );
4177:
4178: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4180: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4181: RAISE FND_API.G_EXC_ERROR;
4182: END IF;
4183:

Line 4180: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4176: );
4177:
4178: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4180: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4181: RAISE FND_API.G_EXC_ERROR;
4182: END IF;
4183:
4184:

Line 4181: RAISE FND_API.G_EXC_ERROR;

4177:
4178: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4180: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4181: RAISE FND_API.G_EXC_ERROR;
4182: END IF;
4183:
4184:
4185: else --if p_payment_type_code is null

Line 4210: x_return_status := FND_API.G_RET_STS_ERROR;

4206:
4207: EXCEPTION
4208:
4209: WHEN others then
4210: x_return_status := FND_API.G_RET_STS_ERROR;
4211: oe_debug_pub.add('when others error ');
4212: RAISE;
4213:
4214:

Line 4258: p_init_msg_list => FND_API.G_TRUE,

4254: END IF;
4255:
4256: AR_OM_PREPAY_REFUND_PVT.refund_prepayment_wrapper(
4257: p_api_version => 1.0,
4258: p_init_msg_list => FND_API.G_TRUE,
4259: p_commit => FND_API.G_FALSE,
4260: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4261: x_return_status => l_return_status,
4262: x_msg_count => l_msg_count,

Line 4259: p_commit => FND_API.G_FALSE,

4255:
4256: AR_OM_PREPAY_REFUND_PVT.refund_prepayment_wrapper(
4257: p_api_version => 1.0,
4258: p_init_msg_list => FND_API.G_TRUE,
4259: p_commit => FND_API.G_FALSE,
4260: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4261: x_return_status => l_return_status,
4262: x_msg_count => l_msg_count,
4263: x_msg_data => l_msg_data,

Line 4260: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

4256: AR_OM_PREPAY_REFUND_PVT.refund_prepayment_wrapper(
4257: p_api_version => 1.0,
4258: p_init_msg_list => FND_API.G_TRUE,
4259: p_commit => FND_API.G_FALSE,
4260: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4261: x_return_status => l_return_status,
4262: x_msg_count => l_msg_count,
4263: x_msg_data => l_msg_data,
4264: p_prepay_application_id => l_prepay_application_id,

Line 4293: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

4289: END IF;
4290:
4291: l_format_mask := get_format_mask(p_header_rec.transactional_curr_code);
4292:
4293: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
4294: fnd_message.Set_Name('ONT', 'ONT_REFUND_PROCESS_SUCCESS');
4295: FND_MESSAGE.SET_TOKEN('AMOUNT' , TO_CHAR(p_refund_amount, l_format_mask));
4296: FND_MESSAGE.SET_TOKEN('NUMBER' , l_number_of_refund_receipts);
4297: oe_msg_pub.add;

Line 4309: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

4305: , p_msg_data => l_msg_data
4306: , p_return_status => l_return_status
4307: );
4308:
4309: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4310: RAISE FND_API.G_EXC_ERROR;
4311: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4312: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4313: END IF;

Line 4310: RAISE FND_API.G_EXC_ERROR;

4306: , p_return_status => l_return_status
4307: );
4308:
4309: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4310: RAISE FND_API.G_EXC_ERROR;
4311: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4312: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4313: END IF;
4314: ELSE

Line 4311: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4307: );
4308:
4309: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4310: RAISE FND_API.G_EXC_ERROR;
4311: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4312: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4313: END IF;
4314: ELSE
4315: fnd_message.Set_Name('ONT', 'ONT_REFUND_PROCESS_FAILED');

Line 4312: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4308:
4309: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4310: RAISE FND_API.G_EXC_ERROR;
4311: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4312: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4313: END IF;
4314: ELSE
4315: fnd_message.Set_Name('ONT', 'ONT_REFUND_PROCESS_FAILED');
4316: FND_MESSAGE.SET_TOKEN('AMOUNT', TO_CHAR(p_refund_amount, l_format_mask));

Line 4330: -- l_msg_data := FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE);

4326: oe_msg_pub.add_text(p_message_text => l_msg_data);
4327: ELSIF ( FND_MSG_PUB.Count_Msg > 0 ) THEN
4328: arp_util.enable_debug;
4329: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
4330: -- l_msg_data := FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE);
4331: l_msg_data := FND_MSG_PUB.Get(i,'F');
4332: IF l_debug_level > 0 THEN
4333: oe_debug_pub.Add( 'Error message from AR API: '|| L_MSG_DATA , 3 );
4334: END IF;

Line 4338: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

4334: END IF;
4335: oe_msg_pub.add_text(p_message_text => l_msg_data);
4336: END LOOP;
4337: END IF;
4338: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4339: RAISE FND_API.G_EXC_ERROR;
4340: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4342: END IF;

Line 4339: RAISE FND_API.G_EXC_ERROR;

4335: oe_msg_pub.add_text(p_message_text => l_msg_data);
4336: END LOOP;
4337: END IF;
4338: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4339: RAISE FND_API.G_EXC_ERROR;
4340: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4342: END IF;
4343: END IF;

Line 4340: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4336: END LOOP;
4337: END IF;
4338: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4339: RAISE FND_API.G_EXC_ERROR;
4340: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4342: END IF;
4343: END IF;
4344:

Line 4341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4337: END IF;
4338: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4339: RAISE FND_API.G_EXC_ERROR;
4340: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4342: END IF;
4343: END IF;
4344:
4345: IF l_debug_level > 0 THEN

Line 4351: WHEN FND_API.G_EXC_ERROR THEN

4347: END IF;
4348:
4349: EXCEPTION
4350:
4351: WHEN FND_API.G_EXC_ERROR THEN
4352: x_return_status := FND_API.G_RET_STS_ERROR;
4353: OE_MSG_PUB.Count_And_Get
4354: ( p_count => l_msg_count,
4355: p_data => l_msg_data

Line 4352: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 4358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4354: ( p_count => l_msg_count,
4355: p_data => l_msg_data
4356: );
4357:
4358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4360: IF l_debug_level > 0 THEN
4361: oe_debug_pub.add( 'Unexpected error in Create_Refund: ' || SQLERRM , 3 ) ;
4362: END IF;

Line 4359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4355: p_data => l_msg_data
4356: );
4357:
4358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4360: IF l_debug_level > 0 THEN
4361: oe_debug_pub.add( 'Unexpected error in Create_Refund: ' || SQLERRM , 3 ) ;
4362: END IF;
4363: OE_MSG_PUB.Count_And_Get

Line 4369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4365: p_data => l_msg_data
4366: );
4367:
4368: WHEN OTHERS THEN
4369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4370: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4371: THEN
4372: OE_MSG_PUB.Add_Exc_Msg
4373: ( G_PKG_NAME

Line 4440: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

4436: oe_debug_pub.add( 'In Process_Payment_Refund, after calling create_refund return status is: '||l_return_status, 3 ) ;
4437: END IF;
4438:
4439:
4440: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
4441: UPDATE oe_payments
4442: SET payment_amount = 0, prepaid_amount = 0
4443: WHERE payment_collection_event = 'PREPAY'
4444: AND header_id = p_header_rec.header_id;

Line 4446: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4442: SET payment_amount = 0, prepaid_amount = 0
4443: WHERE payment_collection_event = 'PREPAY'
4444: AND header_id = p_header_rec.header_id;
4445:
4446: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4447: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4448: RAISE FND_API.G_EXC_ERROR;
4449: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4450: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4447: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

4443: WHERE payment_collection_event = 'PREPAY'
4444: AND header_id = p_header_rec.header_id;
4445:
4446: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4447: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4448: RAISE FND_API.G_EXC_ERROR;
4449: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4450: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4451: END IF;

Line 4448: RAISE FND_API.G_EXC_ERROR;

4444: AND header_id = p_header_rec.header_id;
4445:
4446: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4447: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4448: RAISE FND_API.G_EXC_ERROR;
4449: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4450: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4451: END IF;
4452: END IF;

Line 4449: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4445:
4446: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4447: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4448: RAISE FND_API.G_EXC_ERROR;
4449: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4450: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4451: END IF;
4452: END IF;
4453:

Line 4450: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4446: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4447: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4448: RAISE FND_API.G_EXC_ERROR;
4449: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4450: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4451: END IF;
4452: END IF;
4453:
4454: x_return_status := l_return_status;

Line 4462: WHEN FND_API.G_EXC_ERROR THEN

4458: END IF;
4459:
4460: EXCEPTION
4461:
4462: WHEN FND_API.G_EXC_ERROR THEN
4463: x_return_status := FND_API.G_RET_STS_ERROR;
4464: OE_MSG_PUB.Count_And_Get
4465: ( p_count => l_msg_count,
4466: p_data => l_msg_data

Line 4463: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 4469: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 4470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 4477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4473: p_data => l_msg_data
4474: );
4475:
4476: WHEN OTHERS THEN
4477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4478: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4479: THEN
4480: OE_MSG_PUB.Add_Exc_Msg
4481: ( G_PKG_NAME

Line 4548: IF l_hold_result = FND_API.G_TRUE THEN

4544: , x_msg_data => l_msg_data
4545: , x_return_status => l_return_status
4546: );
4547: -- Check the Result
4548: IF l_hold_result = FND_API.G_TRUE THEN
4549: p_hold_exists := 'Y';
4550: IF l_debug_level > 0 THEN
4551: oe_debug_pub.add( 'OEXVPPYB: Credit Card Authorization Failure hold EXISTS ON ORDER ' , 3 ) ;
4552: END IF;

Line 4567: IF l_hold_result = FND_API.G_TRUE THEN

4563: , x_msg_count => l_msg_count
4564: , x_msg_data => l_msg_data
4565: , x_return_status => l_return_status
4566: );
4567: IF l_hold_result = FND_API.G_TRUE THEN
4568: p_hold_exists := 'Y';
4569: IF l_debug_level > 0 THEN
4570: oe_debug_pub.add( 'OEXVPPYB: Credit Card Risk hold EXISTS ON ORDER' , 3 ) ;
4571: END IF;

Line 4587: IF l_hold_result = FND_API.G_TRUE THEN

4583: , x_msg_data => l_msg_data
4584: , x_return_status => l_return_status
4585: );
4586:
4587: IF l_hold_result = FND_API.G_TRUE THEN
4588: p_hold_exists := 'Y';
4589: IF l_debug_level > 0 THEN
4590: oe_debug_pub.add( 'OEXVPPYB: PAYMENT HOLD 16 EXISTS ON ORDER.' , 3 ) ;
4591: END IF;

Line 4604: IF ( l_return_status = FND_API.G_RET_STS_SUCCESS AND

4600: ,x_msg_count => l_msg_count
4601: ,x_msg_data => l_msg_data
4602: );
4603:
4604: IF ( l_return_status = FND_API.G_RET_STS_SUCCESS AND
4605: p_hold_rec.x_result_out = FND_API.G_TRUE )
4606: THEN
4607: p_hold_exists := 'Y';
4608: IF l_debug_level > 0 THEN

Line 4605: p_hold_rec.x_result_out = FND_API.G_TRUE )

4601: ,x_msg_data => l_msg_data
4602: );
4603:
4604: IF ( l_return_status = FND_API.G_RET_STS_SUCCESS AND
4605: p_hold_rec.x_result_out = FND_API.G_TRUE )
4606: THEN
4607: p_hold_exists := 'Y';
4608: IF l_debug_level > 0 THEN
4609: oe_debug_pub.add( 'OEXVPPYB: PAYMENT HOLD 16 EXISTS ON ORDER LINE.' , 3 ) ;

Line 4637: IF l_hold_result = FND_API.G_TRUE THEN

4633: , x_msg_data => l_msg_data
4634: , x_return_status => l_return_status
4635: );
4636: -- Check the Result
4637: IF l_hold_result = FND_API.G_TRUE THEN
4638: p_hold_exists := 'Y';
4639: IF l_debug_level > 0 THEN
4640: oe_debug_pub.add( 'OEXVPPYB: Credit Card Authorization Failure hold EXISTS ON ORDER LINE' , 3 ) ;
4641: END IF;

Line 4656: IF l_hold_result = FND_API.G_TRUE THEN

4652: , x_msg_count => l_msg_count
4653: , x_msg_data => l_msg_data
4654: , x_return_status => l_return_status
4655: );
4656: IF l_hold_result = FND_API.G_TRUE THEN
4657: p_hold_exists := 'Y';
4658: IF l_debug_level > 0 THEN
4659: oe_debug_pub.add( 'OEXVPPYB: Credit Card Risk hold EXISTS ON ORDER LINE' , 3 ) ;
4660: END IF;

Line 4675: IF l_hold_result = FND_API.G_TRUE THEN

4671: , x_msg_data => l_msg_data
4672: , x_return_status => l_return_status
4673: );
4674:
4675: IF l_hold_result = FND_API.G_TRUE THEN
4676: p_hold_exists := 'Y';
4677: IF l_debug_level > 0 THEN
4678: oe_debug_pub.add( 'OEXVPPYB: Pending Authorization hold EXISTS ON ORDER LINE' , 3 ) ;
4679: END IF;

Line 4735: x_return_status := FND_API.G_RET_STS_SUCCESS;

4731: l_payment_type varchar2(30) := null;
4732: l_payment_trx_id number := -1;
4733: Begin
4734:
4735: x_return_status := FND_API.G_RET_STS_SUCCESS;
4736: x_msg_count := 0;
4737: x_msg_data := null;
4738:
4739: if p_line_id is not null then

Line 4754: x_return_status := FND_API.G_RET_STS_SUCCESS;

4750: IF lock_lin_Payments%ISOPEN Then
4751: close lock_lin_Payments;
4752: END IF;
4753: oe_debug_pub.add('no line payments exist');
4754: x_return_status := FND_API.G_RET_STS_SUCCESS;
4755: return;
4756: when others then
4757: ROLLBACK TO LINE_PAYMENTS;
4758: IF lock_lin_Payments%ISOPEN Then

Line 4763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4759: close lock_lin_Payments;
4760: END IF;
4761: oe_debug_pub.add('locking the row failed');
4762: -- issue an error message saying that lock row failed.
4763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4764: RAISE;
4765: End;
4766: -- was able to lock the row. so, go ahead and update oe_payments.
4767: Begin

Line 4783: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 4788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4784: RAISE;
4785:
4786: when others then
4787: --oe_msg_pub.add(); --
4788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4789: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4790: End;
4791:
4792: elsif p_header_id is not null then

Line 4789: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4785:
4786: when others then
4787: --oe_msg_pub.add(); --
4788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4789: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4790: End;
4791:
4792: elsif p_header_id is not null then
4793:

Line 4810: x_return_status := FND_API.G_RET_STS_SUCCESS;

4806: IF lock_hdr_Payments%ISOPEN Then
4807: close lock_hdr_Payments;
4808: END IF;
4809: oe_debug_pub.add('no header payments exist');
4810: x_return_status := FND_API.G_RET_STS_SUCCESS;
4811: return;
4812: when others then
4813: ROLLBACK TO LOCK_HEADER_PAYMENTS;
4814: IF lock_hdr_Payments%ISOPEN Then

Line 4819: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4815: close lock_hdr_Payments;
4816: END IF;
4817: oe_debug_pub.add('locking the row failed');
4818: -- issue an error message saying that lock row failed.
4819: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4820: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4821: End;
4822: -- was able to lock the row. so, go ahead and update oe_payments.
4823: Begin

Line 4820: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4816: END IF;
4817: oe_debug_pub.add('locking the row failed');
4818: -- issue an error message saying that lock row failed.
4819: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4820: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4821: End;
4822: -- was able to lock the row. so, go ahead and update oe_payments.
4823: Begin
4824:

Line 4833: x_return_status := FND_API.G_RET_STS_ERROR;

4829:
4830: Exception
4831: when no_data_found then
4832: --oe_msg_pub.add( ); --
4833: x_return_status := FND_API.G_RET_STS_ERROR;
4834: RAISE;
4835: when others then
4836: --oe_msg_pub.add(); --
4837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 4838: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4834: RAISE;
4835: when others then
4836: --oe_msg_pub.add(); --
4837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4838: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4839: End;
4840:
4841: end if;
4842:

Line 4866: x_return_status := FND_API.G_RET_STS_SUCCESS;

4862: BEGIN
4863: IF l_debug_level > 0 THEN
4864: oe_debug_pub.add( 'OEXVPPYB: Entering OE_PREPAYMENT_PVT.Delete_Payment_Hold.' , 3 ) ;
4865: END IF;
4866: x_return_status := FND_API.G_RET_STS_SUCCESS;
4867:
4868: IF p_line_id IS NOT NULL THEN
4869: OE_Verify_Payment_PUB.Release_Verify_Line_Hold
4870: ( p_header_id => p_header_id

Line 4878: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

4874: , p_msg_data => l_msg_data
4875: , p_return_status => l_return_status
4876: );
4877:
4878: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4879: RAISE FND_API.G_EXC_ERROR;
4880: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4881: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4882: END IF;

Line 4879: RAISE FND_API.G_EXC_ERROR;

4875: , p_return_status => l_return_status
4876: );
4877:
4878: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4879: RAISE FND_API.G_EXC_ERROR;
4880: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4881: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4882: END IF;
4883:

Line 4880: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4876: );
4877:
4878: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4879: RAISE FND_API.G_EXC_ERROR;
4880: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4881: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4882: END IF;
4883:
4884: ELSE

Line 4881: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4877:
4878: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4879: RAISE FND_API.G_EXC_ERROR;
4880: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4881: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4882: END IF;
4883:
4884: ELSE
4885: IF p_hold_type = 'PREPAYMENT' THEN

Line 4893: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

4889: , p_msg_data => l_msg_data
4890: , p_return_status => l_return_status
4891: );
4892:
4893: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4894: RAISE FND_API.G_EXC_ERROR;
4895: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4896: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4897: END IF;

Line 4894: RAISE FND_API.G_EXC_ERROR;

4890: , p_return_status => l_return_status
4891: );
4892:
4893: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4894: RAISE FND_API.G_EXC_ERROR;
4895: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4896: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4897: END IF;
4898:

Line 4895: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4891: );
4892:
4893: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4894: RAISE FND_API.G_EXC_ERROR;
4895: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4896: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4897: END IF;
4898:
4899: ELSE

Line 4896: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4892:
4893: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4894: RAISE FND_API.G_EXC_ERROR;
4895: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4896: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4897: END IF;
4898:
4899: ELSE
4900: OE_Verify_Payment_PUB.Release_Verify_Hold

Line 4907: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

4903: , p_msg_count => l_msg_count
4904: , p_msg_data => l_msg_data
4905: , p_return_status => l_return_status
4906: );
4907: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4908: RAISE FND_API.G_EXC_ERROR;
4909: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4911: END IF;

Line 4908: RAISE FND_API.G_EXC_ERROR;

4904: , p_msg_data => l_msg_data
4905: , p_return_status => l_return_status
4906: );
4907: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4908: RAISE FND_API.G_EXC_ERROR;
4909: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4911: END IF;
4912: END IF;

Line 4909: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4905: , p_return_status => l_return_status
4906: );
4907: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4908: RAISE FND_API.G_EXC_ERROR;
4909: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4911: END IF;
4912: END IF;
4913: END IF;

Line 4910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4906: );
4907: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4908: RAISE FND_API.G_EXC_ERROR;
4909: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4911: END IF;
4912: END IF;
4913: END IF;
4914:

Line 4917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4913: END IF;
4914:
4915: EXCEPTION
4916: WHEN OTHERS THEN
4917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4918: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4919: THEN
4920: FND_MSG_PUB.Add_Exc_Msg
4921: ( G_PKG_NAME

Line 4974: x_return_status := FND_API.G_RET_STS_SUCCESS;

4970: IF l_debug_level > 0 THEN
4971: oe_debug_pub.add('ENTERING OE_PREPAYMENT_PVT.GET_FIRST_INSTALLMENT');
4972: END IF;
4973:
4974: x_return_status := FND_API.G_RET_STS_SUCCESS;
4975:
4976: l_pr_return_value := OE_ORDER_UTIL.Get_Precision(p_currency_code);
4977:
4978:

Line 5028: x_return_status := FND_API.G_RET_STS_ERROR;

5024: IF l_debug_level > 0 THEN
5025: oe_debug_pub.add('Error in OE_PREPAYMENT_PVT.Get_First_Installment');
5026: END IF;
5027:
5028: x_return_status := FND_API.G_RET_STS_ERROR;
5029:
5030: END Get_First_Installment;
5031:
5032:

Line 5080: x_return_status := FND_API.G_RET_STS_SUCCESS;

5076: BEGIN
5077: IF l_debug_level > 0 THEN
5078: oe_debug_pub.add('ENTERING OE_PREPAYMENT_PVT.GET_PAY_NOW_AMOUNTS');
5079: END IF;
5080: x_return_status := FND_API.G_RET_STS_SUCCESS;
5081:
5082: IF p_exc_inv_lines IS NULL THEN
5083: l_exc_inv_lines := 'N';
5084: ELSE

Line 5222: ,p_init_msg_list => FND_API.G_TRUE

5218: IF OE_Prepayment_Util.Get_Installment_Options = 'ENABLE_PAY_NOW' THEN
5219: -- calling AR API to get pay now total
5220: AR_VIEW_TERM_GRP.pay_now_amounts
5221: (p_api_version => 1.0
5222: ,p_init_msg_list => FND_API.G_TRUE
5223: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
5224: ,p_currency_code => OE_Order_Cache.g_header_rec.transactional_curr_code
5225: ,p_amounts_tbl => l_pay_now_total_detail_tbl
5226: ,x_pay_now_summary_rec => l_pay_now_total_summary_rec

Line 5223: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

5219: -- calling AR API to get pay now total
5220: AR_VIEW_TERM_GRP.pay_now_amounts
5221: (p_api_version => 1.0
5222: ,p_init_msg_list => FND_API.G_TRUE
5223: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
5224: ,p_currency_code => OE_Order_Cache.g_header_rec.transactional_curr_code
5225: ,p_amounts_tbl => l_pay_now_total_detail_tbl
5226: ,x_pay_now_summary_rec => l_pay_now_total_summary_rec
5227: ,x_return_status => x_return_status

Line 5304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5300:
5301:
5302: EXCEPTION
5303: WHEN OTHERS THEN
5304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5305: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5306: FND_MSG_PUB.Add_Exc_Msg
5307: (G_PKG_NAME, 'Get_Pay_Now_Amounts'
5308: );