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_VERIFY_PAYMENT_PUB dependencies on FND_API

Line 78: p_return_status := FND_API.G_RET_STS_SUCCESS;

74: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
75:
76: BEGIN
77:
78: p_return_status := FND_API.G_RET_STS_SUCCESS;
79:
80: IF l_debug_level > 0 THEN
81: oe_debug_pub.add( 'OEXPVPMB: IN APPLY VERIFY LINE HOLDS' ) ;
82: END IF;

Line 110: IF l_hold_result = FND_API.G_TRUE THEN

106: , x_return_status => l_return_status
107: );
108:
109: -- Return with Success if this Hold Already exists on the order
110: IF l_hold_result = FND_API.G_TRUE THEN
111: IF l_debug_level > 0 THEN
112: oe_debug_pub.add( 'OEXPVPMB: HOLD ALREADY APPLIED ON LINE ID : ' || P_LINE_ID ) ;
113: END IF;
114: RETURN ;

Line 129: , p_validation_level => FND_API.G_VALID_LEVEL_NONE

125: l_hold_source_rec.line_id := p_line_id;
126:
127: OE_Holds_PUB.Apply_Holds
128: ( p_api_version => 1.0
129: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
130: , p_hold_source_rec => l_hold_source_rec
131: , x_msg_count => l_msg_count
132: , x_msg_data => l_msg_data
133: , x_return_status => l_return_status

Line 136: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

132: , x_msg_data => l_msg_data
133: , x_return_status => l_return_status
134: );
135:
136: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
137: IF p_hold_id = 16 THEN
138:
139: BEGIN
140: SELECT line_number,

Line 169: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

165: IF l_debug_level > 0 THEN
166: oe_debug_pub.add( 'OEXVPPYB: Pending Payment Authorization hold has been applied on order line.', 3);
167: END IF;
168: END IF;
169: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
170: RAISE FND_API.G_EXC_ERROR;
171: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
173: END IF;

Line 170: RAISE FND_API.G_EXC_ERROR;

166: oe_debug_pub.add( 'OEXVPPYB: Pending Payment Authorization hold has been applied on order line.', 3);
167: END IF;
168: END IF;
169: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
170: RAISE FND_API.G_EXC_ERROR;
171: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
173: END IF;
174:

Line 171: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

167: END IF;
168: END IF;
169: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
170: RAISE FND_API.G_EXC_ERROR;
171: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
173: END IF;
174:
175: -- bug 4339864

Line 172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

168: END IF;
169: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
170: RAISE FND_API.G_EXC_ERROR;
171: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
173: END IF;
174:
175: -- bug 4339864
176: IF l_debug_level > 0 THEN

Line 189: WHEN FND_API.G_EXC_ERROR THEN

185: END IF;
186:
187: EXCEPTION
188:
189: WHEN FND_API.G_EXC_ERROR THEN
190: p_return_status := FND_API.G_RET_STS_ERROR;
191: OE_MSG_PUB.Count_And_Get
192: ( p_count => l_msg_count,
193: p_data => l_msg_data

Line 190: p_return_status := FND_API.G_RET_STS_ERROR;

186:
187: EXCEPTION
188:
189: WHEN FND_API.G_EXC_ERROR THEN
190: p_return_status := FND_API.G_RET_STS_ERROR;
191: OE_MSG_PUB.Count_And_Get
192: ( p_count => l_msg_count,
193: p_data => l_msg_data
194: );

Line 196: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

192: ( p_count => l_msg_count,
193: p_data => l_msg_data
194: );
195:
196: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
197: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
198: OE_MSG_PUB.Count_And_Get
199: ( p_count => l_msg_count,
200: p_data => l_msg_data

Line 197: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

193: p_data => l_msg_data
194: );
195:
196: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
197: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
198: OE_MSG_PUB.Count_And_Get
199: ( p_count => l_msg_count,
200: p_data => l_msg_data
201: );

Line 204: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

200: p_data => l_msg_data
201: );
202:
203: WHEN OTHERS THEN
204: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
205: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
206: THEN
207: FND_MSG_PUB.Add_Exc_Msg
208: ( G_PKG_NAME

Line 413: p_return_status := FND_API.G_RET_STS_SUCCESS;

409: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
410: --
411: BEGIN
412:
413: p_return_status := FND_API.G_RET_STS_SUCCESS;
414:
415: IF l_debug_level > 0 THEN
416: oe_debug_pub.add( 'OEXPVPMB: IN RELEASE CREDIT CHECK HOLD' ) ;
417: END IF;

Line 445: IF l_hold_result = FND_API.G_TRUE THEN

441: , x_msg_data => l_msg_data
442: , x_return_status => l_return_status
443: );
444:
445: IF l_hold_result = FND_API.G_TRUE THEN
446:
447: IF l_debug_level > 0 THEN
448: oe_debug_pub.add( 'OEXPVPMB: RELEASING CREDIT CHECK HOLD ON HEADER ID:' || TO_CHAR ( P_HEADER_ID ) || '/' || TO_CHAR ( C1.LINE_ID ) , 1 ) ;
449: END IF;

Line 468: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

464: , x_msg_data => l_msg_data
465: , x_return_status => l_return_status
466: );
467:
468: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
469: RAISE FND_API.G_EXC_ERROR;
470: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
471: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
472: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN

Line 469: RAISE FND_API.G_EXC_ERROR;

465: , x_return_status => l_return_status
466: );
467:
468: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
469: RAISE FND_API.G_EXC_ERROR;
470: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
471: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
472: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
473: fnd_message.set_name('ONT', 'OE_CC_HOLD_REMOVED');

Line 470: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

466: );
467:
468: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
469: RAISE FND_API.G_EXC_ERROR;
470: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
471: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
472: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
473: fnd_message.set_name('ONT', 'OE_CC_HOLD_REMOVED');
474: oe_msg_pub.add;

Line 471: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

467:
468: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
469: RAISE FND_API.G_EXC_ERROR;
470: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
471: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
472: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
473: fnd_message.set_name('ONT', 'OE_CC_HOLD_REMOVED');
474: oe_msg_pub.add;
475: END IF;

Line 472: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN

468: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
469: RAISE FND_API.G_EXC_ERROR;
470: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
471: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
472: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
473: fnd_message.set_name('ONT', 'OE_CC_HOLD_REMOVED');
474: oe_msg_pub.add;
475: END IF;
476:

Line 483: WHEN FND_API.G_EXC_ERROR THEN

479: END LOOP;
480:
481: EXCEPTION
482:
483: WHEN FND_API.G_EXC_ERROR THEN
484: p_return_status := FND_API.G_RET_STS_ERROR;
485: OE_MSG_PUB.Count_And_Get
486: ( p_count => l_msg_count,
487: p_data => l_msg_data

Line 484: p_return_status := FND_API.G_RET_STS_ERROR;

480:
481: EXCEPTION
482:
483: WHEN FND_API.G_EXC_ERROR THEN
484: p_return_status := FND_API.G_RET_STS_ERROR;
485: OE_MSG_PUB.Count_And_Get
486: ( p_count => l_msg_count,
487: p_data => l_msg_data
488: );

Line 490: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

486: ( p_count => l_msg_count,
487: p_data => l_msg_data
488: );
489:
490: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
491: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
492: OE_MSG_PUB.Count_And_Get
493: ( p_count => l_msg_count,
494: p_data => l_msg_data

Line 491: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

487: p_data => l_msg_data
488: );
489:
490: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
491: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
492: OE_MSG_PUB.Count_And_Get
493: ( p_count => l_msg_count,
494: p_data => l_msg_data
495: );

Line 498: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

494: p_data => l_msg_data
495: );
496:
497: WHEN OTHERS THEN
498: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
499: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
500: THEN
501: FND_MSG_PUB.Add_Exc_Msg
502: ( G_PKG_NAME

Line 552: p_return_status := FND_API.G_RET_STS_SUCCESS;

548: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
549: --
550: BEGIN
551:
552: p_return_status := FND_API.G_RET_STS_SUCCESS;
553:
554: IF l_debug_level > 0 THEN
555: oe_debug_pub.add( 'OEXPVPMB: IN APPLY CREDIT CHECK HOLDS' ) ;
556: END IF;

Line 569: IF NVL(p_delayed_request, FND_API.G_FALSE) = FND_API.G_TRUE THEN

565: oe_debug_pub.add( 'OEXPVPMB: HOLD ID : '||P_HOLD_ID ) ;
566: END IF;
567:
568: -- If the call was made from a delayed request, always apply hold.
569: IF NVL(p_delayed_request, FND_API.G_FALSE) = FND_API.G_TRUE THEN
570: l_apply_hold := 'Y';
571: ELSE
572: IF CHECK_MANUAL_RELEASED_HOLDS (
573: p_calling_action => p_calling_action,

Line 601: IF l_hold_result = FND_API.G_TRUE THEN

597: , x_return_status => l_return_status
598: );
599:
600: -- Return with Success if this Hold Already exists on the order
601: IF l_hold_result = FND_API.G_TRUE THEN
602: IF l_debug_level > 0 THEN
603: oe_debug_pub.add( 'OEXPVPMB: HOLD ALREADY APPLIED ON HEADER/LINE ID:' || P_HEADER_ID || '/' || C1.LINE_ID ) ;
604: END IF;
605: -- IF One line is on Hold, other lines will NOT go on hold

Line 626: , p_validation_level => FND_API.G_VALID_LEVEL_NONE

622: l_hold_source_rec.line_id := C1.line_id;
623:
624: OE_Holds_PUB.Apply_Holds
625: ( p_api_version => 1.0
626: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
627: , p_hold_source_rec => l_hold_source_rec
628: , x_msg_count => l_msg_count
629: , x_msg_data => l_msg_data
630: , x_return_status => l_return_status

Line 633: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

629: , x_msg_data => l_msg_data
630: , x_return_status => l_return_status
631: );
632:
633: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
634: RAISE FND_API.G_EXC_ERROR;
635: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
636: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
637: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN

Line 634: RAISE FND_API.G_EXC_ERROR;

630: , x_return_status => l_return_status
631: );
632:
633: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
634: RAISE FND_API.G_EXC_ERROR;
635: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
636: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
637: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
638: --fnd_message.set_name('ONT', 'OE_CC_HOLD_APPLIED');

Line 635: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

631: );
632:
633: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
634: RAISE FND_API.G_EXC_ERROR;
635: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
636: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
637: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
638: --fnd_message.set_name('ONT', 'OE_CC_HOLD_APPLIED');
639: l_attribute := 'Credit Check';

Line 636: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

632:
633: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
634: RAISE FND_API.G_EXC_ERROR;
635: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
636: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
637: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
638: --fnd_message.set_name('ONT', 'OE_CC_HOLD_APPLIED');
639: l_attribute := 'Credit Check';
640: l_line_number := C1.line_number;

Line 637: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN

633: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
634: RAISE FND_API.G_EXC_ERROR;
635: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
636: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
637: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
638: --fnd_message.set_name('ONT', 'OE_CC_HOLD_APPLIED');
639: l_attribute := 'Credit Check';
640: l_line_number := C1.line_number;
641: fnd_message.set_name('ONT','OE_HLD_APPLIED_LINE');

Line 656: WHEN FND_API.G_EXC_ERROR THEN

652: END LOOP;
653:
654: EXCEPTION
655:
656: WHEN FND_API.G_EXC_ERROR THEN
657: p_return_status := FND_API.G_RET_STS_ERROR;
658: OE_MSG_PUB.Count_And_Get
659: ( p_count => l_msg_count,
660: p_data => l_msg_data

Line 657: p_return_status := FND_API.G_RET_STS_ERROR;

653:
654: EXCEPTION
655:
656: WHEN FND_API.G_EXC_ERROR THEN
657: p_return_status := FND_API.G_RET_STS_ERROR;
658: OE_MSG_PUB.Count_And_Get
659: ( p_count => l_msg_count,
660: p_data => l_msg_data
661: );

Line 663: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

659: ( p_count => l_msg_count,
660: p_data => l_msg_data
661: );
662:
663: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
664: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
665: OE_MSG_PUB.Count_And_Get
666: ( p_count => l_msg_count,
667: p_data => l_msg_data

Line 664: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

660: p_data => l_msg_data
661: );
662:
663: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
664: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
665: OE_MSG_PUB.Count_And_Get
666: ( p_count => l_msg_count,
667: p_data => l_msg_data
668: );

Line 671: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

667: p_data => l_msg_data
668: );
669:
670: WHEN OTHERS THEN
671: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
672: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
673: THEN
674: FND_MSG_PUB.Add_Exc_Msg
675: ( G_PKG_NAME

Line 750: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

746: IF l_debug_level > 0 THEN
747: oe_debug_pub.add( 'OEXPVPMB: AFTER CALLING CREDIT REQUEST API:' || L_RESULT_OUT ) ;
748: END IF;
749:
750: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
751: RAISE FND_API.G_EXC_ERROR;
752: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
753: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
754: END IF;

Line 751: RAISE FND_API.G_EXC_ERROR;

747: oe_debug_pub.add( 'OEXPVPMB: AFTER CALLING CREDIT REQUEST API:' || L_RESULT_OUT ) ;
748: END IF;
749:
750: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
751: RAISE FND_API.G_EXC_ERROR;
752: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
753: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
754: END IF;
755:

Line 752: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

748: END IF;
749:
750: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
751: RAISE FND_API.G_EXC_ERROR;
752: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
753: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
754: END IF;
755:
756: -- Release Any existing CC Holds

Line 753: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

749:
750: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
751: RAISE FND_API.G_EXC_ERROR;
752: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
753: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
754: END IF;
755:
756: -- Release Any existing CC Holds
757: IF l_debug_level > 0 THEN

Line 768: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

764: , p_msg_count => l_msg_count
765: , p_msg_data => l_msg_data
766: , p_return_status => l_return_status
767: );
768: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
769: RAISE FND_API.G_EXC_ERROR;
770: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
772: END IF;

Line 769: RAISE FND_API.G_EXC_ERROR;

765: , p_msg_data => l_msg_data
766: , p_return_status => l_return_status
767: );
768: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
769: RAISE FND_API.G_EXC_ERROR;
770: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
772: END IF;
773:

Line 770: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

766: , p_return_status => l_return_status
767: );
768: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
769: RAISE FND_API.G_EXC_ERROR;
770: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
772: END IF;
773:
774: -- Check the Out Result of Credit Checking

Line 771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

767: );
768: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
769: RAISE FND_API.G_EXC_ERROR;
770: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
772: END IF;
773:
774: -- Check the Out Result of Credit Checking
775: IF l_result_out = 'PASS' THEN

Line 789: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

785: , p_msg_count => l_msg_count
786: , p_msg_data => l_msg_data
787: , p_return_status => l_return_status
788: );
789: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
790: RAISE FND_API.G_EXC_ERROR;
791: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
793: END IF;

Line 790: RAISE FND_API.G_EXC_ERROR;

786: , p_msg_data => l_msg_data
787: , p_return_status => l_return_status
788: );
789: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
790: RAISE FND_API.G_EXC_ERROR;
791: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
793: END IF;
794:

Line 791: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

787: , p_return_status => l_return_status
788: );
789: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
790: RAISE FND_API.G_EXC_ERROR;
791: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
793: END IF;
794:
795: ELSE -- Failed

Line 792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

788: );
789: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
790: RAISE FND_API.G_EXC_ERROR;
791: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
793: END IF;
794:
795: ELSE -- Failed
796:

Line 812: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

808: , p_msg_count => l_msg_count
809: , p_msg_data => l_msg_data
810: , p_return_status => l_return_status
811: );
812: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
813: RAISE FND_API.G_EXC_ERROR;
814: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
816: END IF;

Line 813: RAISE FND_API.G_EXC_ERROR;

809: , p_msg_data => l_msg_data
810: , p_return_status => l_return_status
811: );
812: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
813: RAISE FND_API.G_EXC_ERROR;
814: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
816: END IF;
817:

Line 814: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

810: , p_return_status => l_return_status
811: );
812: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
813: RAISE FND_API.G_EXC_ERROR;
814: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
816: END IF;
817:
818: END IF; -- IF Result Out of Credit Checking

Line 815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

811: );
812: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
813: RAISE FND_API.G_EXC_ERROR;
814: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
816: END IF;
817:
818: END IF; -- IF Result Out of Credit Checking
819: END LOOP;

Line 827: WHEN FND_API.G_EXC_ERROR THEN

823: END IF;
824:
825: EXCEPTION
826:
827: WHEN FND_API.G_EXC_ERROR THEN
828: p_return_status := FND_API.G_RET_STS_ERROR;
829: OE_MSG_PUB.Count_And_Get
830: ( p_count => l_msg_count,
831: p_data => l_msg_data

Line 828: p_return_status := FND_API.G_RET_STS_ERROR;

824:
825: EXCEPTION
826:
827: WHEN FND_API.G_EXC_ERROR THEN
828: p_return_status := FND_API.G_RET_STS_ERROR;
829: OE_MSG_PUB.Count_And_Get
830: ( p_count => l_msg_count,
831: p_data => l_msg_data
832: );

Line 834: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

830: ( p_count => l_msg_count,
831: p_data => l_msg_data
832: );
833:
834: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
835: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
836: OE_MSG_PUB.Count_And_Get
837: ( p_count => l_msg_count,
838: p_data => l_msg_data

Line 835: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

831: p_data => l_msg_data
832: );
833:
834: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
835: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
836: OE_MSG_PUB.Count_And_Get
837: ( p_count => l_msg_count,
838: p_data => l_msg_data
839: );

Line 842: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

838: p_data => l_msg_data
839: );
840:
841: WHEN OTHERS THEN
842: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
843: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
844: THEN
845: OE_MSG_PUB.Add_Exc_Msg
846: ( G_PKG_NAME

Line 909: p_return_status := FND_API.G_RET_STS_SUCCESS;

905: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
906: --
907: BEGIN
908:
909: p_return_status := FND_API.G_RET_STS_SUCCESS;
910:
911: IF l_debug_level > 0 THEN
912: oe_debug_pub.add( 'OEXPVPMB: IN VERIFY PAYMENT MAIN' , 1 ) ;
913: END IF;

Line 957: IF NVL(p_delayed_request, FND_API.G_FALSE) = FND_API.G_TRUE THEN

953: IF l_debug_level > 0 THEN
954: oe_debug_pub.add( 'OEXPVPMB: BEFORE CHECKING CALL FROM DELAYED REQUEST OR NOT' ) ;
955: END IF;
956: --
957: IF NVL(p_delayed_request, FND_API.G_FALSE) = FND_API.G_TRUE THEN
958:
959: /*
960: ** Fix for 1967295:
961: ** As VOID has been de-supported by iPayment, commenting

Line 992: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

988: , p_msg_data => l_msg_data
989: , p_result_out => l_result_out
990: , p_return_status => l_return_status
991: );
992: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
993: RAISE FND_API.G_EXC_ERROR;
994: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
995: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
996: END IF;

Line 993: RAISE FND_API.G_EXC_ERROR;

989: , p_result_out => l_result_out
990: , p_return_status => l_return_status
991: );
992: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
993: RAISE FND_API.G_EXC_ERROR;
994: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
995: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
996: END IF;
997:

Line 994: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

990: , p_return_status => l_return_status
991: );
992: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
993: RAISE FND_API.G_EXC_ERROR;
994: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
995: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
996: END IF;
997:
998: -- Requery Order Header just in case it was updated during VOID.

Line 995: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

991: );
992: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
993: RAISE FND_API.G_EXC_ERROR;
994: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
995: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
996: END IF;
997:
998: -- Requery Order Header just in case it was updated during VOID.
999: OE_DEBUG_PUB.ADD('OEXPVPMB: Requerying Order Header After Void : ');

Line 1190: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1186: IF l_debug_level > 0 THEN
1187: oe_debug_pub.add( 'OEXPVPMB: after calling Process_Payments, returns tatus is: '||l_return_status, 3 ) ;
1188: END IF;
1189:
1190: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1191: RAISE FND_API.G_EXC_ERROR;
1192: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1194: END IF;

Line 1191: RAISE FND_API.G_EXC_ERROR;

1187: oe_debug_pub.add( 'OEXPVPMB: after calling Process_Payments, returns tatus is: '||l_return_status, 3 ) ;
1188: END IF;
1189:
1190: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1191: RAISE FND_API.G_EXC_ERROR;
1192: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1194: END IF;
1195:

Line 1192: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1188: END IF;
1189:
1190: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1191: RAISE FND_API.G_EXC_ERROR;
1192: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1194: END IF;
1195:
1196: RETURN;

Line 1193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1189:
1190: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1191: RAISE FND_API.G_EXC_ERROR;
1192: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1194: END IF;
1195:
1196: RETURN;
1197: -- end of multiple payments processing.

Line 1352: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1348: IF l_debug_level > 0 THEN
1349: oe_debug_pub.add( 'OEXPVPMB: AFTER CALLING CREDIT REQUEST API' ) ;
1350: END IF;
1351:
1352: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1353: RAISE FND_API.G_EXC_ERROR;
1354: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1356: END IF;

Line 1353: RAISE FND_API.G_EXC_ERROR;

1349: oe_debug_pub.add( 'OEXPVPMB: AFTER CALLING CREDIT REQUEST API' ) ;
1350: END IF;
1351:
1352: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1353: RAISE FND_API.G_EXC_ERROR;
1354: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1356: END IF;
1357: -- Check the Out Result of Credit Checking

Line 1354: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1350: END IF;
1351:
1352: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1353: RAISE FND_API.G_EXC_ERROR;
1354: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1356: END IF;
1357: -- Check the Out Result of Credit Checking
1358: IF l_result_out = 'PASS' THEN

Line 1355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1351:
1352: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1353: RAISE FND_API.G_EXC_ERROR;
1354: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1356: END IF;
1357: -- Check the Out Result of Credit Checking
1358: IF l_result_out = 'PASS' THEN
1359:

Line 1372: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1368: , p_msg_count => l_msg_count
1369: , p_msg_data => l_msg_data
1370: , p_return_status => l_return_status
1371: );
1372: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1373: RAISE FND_API.G_EXC_ERROR;
1374: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1376: END IF;

Line 1373: RAISE FND_API.G_EXC_ERROR;

1369: , p_msg_data => l_msg_data
1370: , p_return_status => l_return_status
1371: );
1372: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1373: RAISE FND_API.G_EXC_ERROR;
1374: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1376: END IF;
1377:

Line 1374: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1370: , p_return_status => l_return_status
1371: );
1372: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1373: RAISE FND_API.G_EXC_ERROR;
1374: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1376: END IF;
1377:
1378: ELSE -- Failed

Line 1375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1371: );
1372: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1373: RAISE FND_API.G_EXC_ERROR;
1374: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1376: END IF;
1377:
1378: ELSE -- Failed
1379: IF CHECK_MANUAL_RELEASED_HOLDS (

Line 1396: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1392: , p_msg_count => l_msg_count
1393: , p_msg_data => l_msg_data
1394: , p_return_status => l_return_status
1395: );
1396: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1397: RAISE FND_API.G_EXC_ERROR;
1398: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1400: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN

Line 1397: RAISE FND_API.G_EXC_ERROR;

1393: , p_msg_data => l_msg_data
1394: , p_return_status => l_return_status
1395: );
1396: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1397: RAISE FND_API.G_EXC_ERROR;
1398: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1400: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
1401: fnd_message.set_name('ONT', 'OE_CC_HOLD_APPLIED');

Line 1398: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1394: , p_return_status => l_return_status
1395: );
1396: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1397: RAISE FND_API.G_EXC_ERROR;
1398: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1400: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
1401: fnd_message.set_name('ONT', 'OE_CC_HOLD_APPLIED');
1402: oe_msg_pub.add;

Line 1399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1395: );
1396: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1397: RAISE FND_API.G_EXC_ERROR;
1398: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1400: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
1401: fnd_message.set_name('ONT', 'OE_CC_HOLD_APPLIED');
1402: oe_msg_pub.add;
1403: END IF;

Line 1400: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN

1396: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1397: RAISE FND_API.G_EXC_ERROR;
1398: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1400: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
1401: fnd_message.set_name('ONT', 'OE_CC_HOLD_APPLIED');
1402: oe_msg_pub.add;
1403: END IF;
1404: END IF; -- CHECK_MANUAL_RELEASED_HOLDS

Line 1457: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1453: IF l_debug_level > 0 THEN
1454: oe_debug_pub.add( 'OEXPVPMB: AFTER CALLING PAYMENT REQUEST API' ) ;
1455: END IF;
1456:
1457: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1458: RAISE FND_API.G_EXC_ERROR;
1459: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1461: END IF;

Line 1458: RAISE FND_API.G_EXC_ERROR;

1454: oe_debug_pub.add( 'OEXPVPMB: AFTER CALLING PAYMENT REQUEST API' ) ;
1455: END IF;
1456:
1457: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1458: RAISE FND_API.G_EXC_ERROR;
1459: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1461: END IF;
1462:

Line 1459: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1455: END IF;
1456:
1457: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1458: RAISE FND_API.G_EXC_ERROR;
1459: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1461: END IF;
1462:
1463: -- If No Error Occurred in Payment Request, Release any existing

Line 1460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1456:
1457: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1458: RAISE FND_API.G_EXC_ERROR;
1459: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1461: END IF;
1462:
1463: -- If No Error Occurred in Payment Request, Release any existing
1464: -- Credit Checking Holds This will ensure that for Elctronic Payment

Line 1477: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1473: , p_msg_count => l_msg_count
1474: , p_msg_data => l_msg_data
1475: , p_return_status => l_return_status
1476: );
1477: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1478: RAISE FND_API.G_EXC_ERROR;
1479: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1481: END IF;

Line 1478: RAISE FND_API.G_EXC_ERROR;

1474: , p_msg_data => l_msg_data
1475: , p_return_status => l_return_status
1476: );
1477: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1478: RAISE FND_API.G_EXC_ERROR;
1479: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1481: END IF;
1482:

Line 1479: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1475: , p_return_status => l_return_status
1476: );
1477: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1478: RAISE FND_API.G_EXC_ERROR;
1479: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1481: END IF;
1482:
1483: -- Check the Out Result of Payment Request

Line 1480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1476: );
1477: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1478: RAISE FND_API.G_EXC_ERROR;
1479: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1481: END IF;
1482:
1483: -- Check the Out Result of Payment Request
1484: IF l_result_out = 'PASS' THEN

Line 1498: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1494: , p_msg_count => l_msg_count
1495: , p_msg_data => l_msg_data
1496: , p_return_status => l_return_status
1497: );
1498: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1499: RAISE FND_API.G_EXC_ERROR;
1500: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1502: END IF;

Line 1499: RAISE FND_API.G_EXC_ERROR;

1495: , p_msg_data => l_msg_data
1496: , p_return_status => l_return_status
1497: );
1498: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1499: RAISE FND_API.G_EXC_ERROR;
1500: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1502: END IF;
1503:

Line 1500: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1496: , p_return_status => l_return_status
1497: );
1498: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1499: RAISE FND_API.G_EXC_ERROR;
1500: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1502: END IF;
1503:
1504: ELSIF l_result_out = 'RISK' THEN

Line 1501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1497: );
1498: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1499: RAISE FND_API.G_EXC_ERROR;
1500: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1502: END IF;
1503:
1504: ELSIF l_result_out = 'RISK' THEN
1505:

Line 1518: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1514: , p_msg_count => l_msg_count
1515: , p_msg_data => l_msg_data
1516: , p_return_status => l_return_status
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: , p_msg_data => l_msg_data
1516: , p_return_status => l_return_status
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:

Line 1520: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1516: , p_return_status => l_return_status
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:
1524: ELSE -- Failed

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:
1524: ELSE -- Failed
1525:

Line 1538: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1534: , p_msg_count => l_msg_count
1535: , p_msg_data => l_msg_data
1536: , p_return_status => l_return_status
1537: );
1538: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1539: RAISE FND_API.G_EXC_ERROR;
1540: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1542: END IF;

Line 1539: RAISE FND_API.G_EXC_ERROR;

1535: , p_msg_data => l_msg_data
1536: , p_return_status => l_return_status
1537: );
1538: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1539: RAISE FND_API.G_EXC_ERROR;
1540: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1542: END IF;
1543:

Line 1540: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1536: , p_return_status => l_return_status
1537: );
1538: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1539: RAISE FND_API.G_EXC_ERROR;
1540: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1542: END IF;
1543:
1544: END IF; -- IF Result Out of Payment Request

Line 1541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1537: );
1538: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1539: RAISE FND_API.G_EXC_ERROR;
1540: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1542: END IF;
1543:
1544: END IF; -- IF Result Out of Payment Request
1545:

Line 1681: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1677: IF l_debug_level > 0 THEN
1678: oe_debug_pub.add( 'OEXPVPMB: AFTER CALLING CREDIT REQUEST API' ) ;
1679: END IF;
1680:
1681: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1682: RAISE FND_API.G_EXC_ERROR;
1683: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1685: END IF;

Line 1682: RAISE FND_API.G_EXC_ERROR;

1678: oe_debug_pub.add( 'OEXPVPMB: AFTER CALLING CREDIT REQUEST API' ) ;
1679: END IF;
1680:
1681: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1682: RAISE FND_API.G_EXC_ERROR;
1683: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1685: END IF;
1686: -- Check the Out Result of Credit Checking

Line 1683: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1679: END IF;
1680:
1681: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1682: RAISE FND_API.G_EXC_ERROR;
1683: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1685: END IF;
1686: -- Check the Out Result of Credit Checking
1687: IF l_result_out = 'PASS' THEN

Line 1684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1680:
1681: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1682: RAISE FND_API.G_EXC_ERROR;
1683: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1685: END IF;
1686: -- Check the Out Result of Credit Checking
1687: IF l_result_out = 'PASS' THEN
1688:

Line 1701: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1697: , p_msg_count => l_msg_count
1698: , p_msg_data => l_msg_data
1699: , p_return_status => l_return_status
1700: );
1701: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1702: RAISE FND_API.G_EXC_ERROR;
1703: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1705: END IF;

Line 1702: RAISE FND_API.G_EXC_ERROR;

1698: , p_msg_data => l_msg_data
1699: , p_return_status => l_return_status
1700: );
1701: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1702: RAISE FND_API.G_EXC_ERROR;
1703: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1705: END IF;
1706:

Line 1703: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1699: , p_return_status => l_return_status
1700: );
1701: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1702: RAISE FND_API.G_EXC_ERROR;
1703: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1705: END IF;
1706:
1707: ELSE -- Failed

Line 1704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1700: );
1701: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1702: RAISE FND_API.G_EXC_ERROR;
1703: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1705: END IF;
1706:
1707: ELSE -- Failed
1708: IF CHECK_MANUAL_RELEASED_HOLDS (

Line 1725: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1721: , p_msg_count => l_msg_count
1722: , p_msg_data => l_msg_data
1723: , p_return_status => l_return_status
1724: );
1725: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1726: RAISE FND_API.G_EXC_ERROR;
1727: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1729: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN

Line 1726: RAISE FND_API.G_EXC_ERROR;

1722: , p_msg_data => l_msg_data
1723: , p_return_status => l_return_status
1724: );
1725: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1726: RAISE FND_API.G_EXC_ERROR;
1727: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1729: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
1730: fnd_message.set_name('ONT', 'OE_CC_HOLD_APPLIED');

Line 1727: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1723: , p_return_status => l_return_status
1724: );
1725: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1726: RAISE FND_API.G_EXC_ERROR;
1727: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1729: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
1730: fnd_message.set_name('ONT', 'OE_CC_HOLD_APPLIED');
1731: oe_msg_pub.add;

Line 1728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1724: );
1725: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1726: RAISE FND_API.G_EXC_ERROR;
1727: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1729: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
1730: fnd_message.set_name('ONT', 'OE_CC_HOLD_APPLIED');
1731: oe_msg_pub.add;
1732: END IF;

Line 1729: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN

1725: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1726: RAISE FND_API.G_EXC_ERROR;
1727: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1729: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
1730: fnd_message.set_name('ONT', 'OE_CC_HOLD_APPLIED');
1731: oe_msg_pub.add;
1732: END IF;
1733: END IF; -- CHECK_MANUAL_RELEASED_HOLDS

Line 1766: WHEN FND_API.G_EXC_ERROR THEN

1762: );
1763:
1764: EXCEPTION
1765:
1766: WHEN FND_API.G_EXC_ERROR THEN
1767: p_return_status := FND_API.G_RET_STS_ERROR;
1768: OE_MSG_PUB.Count_And_Get
1769: ( p_count => l_msg_count,
1770: p_data => l_msg_data

Line 1767: p_return_status := FND_API.G_RET_STS_ERROR;

1763:
1764: EXCEPTION
1765:
1766: WHEN FND_API.G_EXC_ERROR THEN
1767: p_return_status := FND_API.G_RET_STS_ERROR;
1768: OE_MSG_PUB.Count_And_Get
1769: ( p_count => l_msg_count,
1770: p_data => l_msg_data
1771: );

Line 1773: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1769: ( p_count => l_msg_count,
1770: p_data => l_msg_data
1771: );
1772:
1773: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1774: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1775: OE_MSG_PUB.Count_And_Get
1776: ( p_count => l_msg_count,
1777: p_data => l_msg_data

Line 1774: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1770: p_data => l_msg_data
1771: );
1772:
1773: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1774: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1775: OE_MSG_PUB.Count_And_Get
1776: ( p_count => l_msg_count,
1777: p_data => l_msg_data
1778: );

Line 1781: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1777: p_data => l_msg_data
1778: );
1779:
1780: WHEN OTHERS THEN
1781: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1782: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1783: THEN
1784: OE_MSG_PUB.Add_Exc_Msg
1785: ( G_PKG_NAME

Line 1913: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1909: RETURN (l_calling_action);
1910:
1911: EXCEPTION
1912: WHEN OTHERS THEN
1913: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1914:
1915: END Which_Rule;
1916:
1917: /*-------------------------------------------------------------------

Line 2164: IF l_hold_result = FND_API.G_TRUE THEN

2160: , x_return_status => l_return_status
2161: );
2162:
2163: -- Check the Result
2164: IF l_hold_result = FND_API.G_TRUE THEN
2165: p_hold_exists := 'Y';
2166: IF l_debug_level > 0 THEN
2167: oe_debug_pub.add( 'OEXPVPMB: HOLD EXISTS ON ORDER' ) ;
2168: END IF;

Line 2220: p_return_status := FND_API.G_RET_STS_SUCCESS;

2216: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2217: --
2218: BEGIN
2219:
2220: p_return_status := FND_API.G_RET_STS_SUCCESS;
2221:
2222: IF l_debug_level > 0 THEN
2223: oe_debug_pub.add( 'OEXPVPMB: IN RELEASE VERIFY HOLD' ) ;
2224: END IF;

Line 2268: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2264: , x_msg_data => l_msg_data
2265: , x_return_status => l_return_status
2266: );
2267:
2268: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2269: RAISE FND_API.G_EXC_ERROR;
2270: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2272: END IF;

Line 2269: RAISE FND_API.G_EXC_ERROR;

2265: , x_return_status => l_return_status
2266: );
2267:
2268: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2269: RAISE FND_API.G_EXC_ERROR;
2270: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2272: END IF;
2273:

Line 2270: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2266: );
2267:
2268: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2269: RAISE FND_API.G_EXC_ERROR;
2270: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2272: END IF;
2273:
2274: END IF; -- Do nothing if the hold has already been released.

Line 2271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2267:
2268: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2269: RAISE FND_API.G_EXC_ERROR;
2270: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2272: END IF;
2273:
2274: END IF; -- Do nothing if the hold has already been released.
2275:

Line 2314: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2310: , x_msg_data => l_msg_data
2311: , x_return_status => l_return_status
2312: );
2313:
2314: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2315: RAISE FND_API.G_EXC_ERROR;
2316: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2318: END IF;

Line 2315: RAISE FND_API.G_EXC_ERROR;

2311: , x_return_status => l_return_status
2312: );
2313:
2314: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2315: RAISE FND_API.G_EXC_ERROR;
2316: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2318: END IF;
2319:

Line 2316: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2312: );
2313:
2314: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2315: RAISE FND_API.G_EXC_ERROR;
2316: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2318: END IF;
2319:
2320: END IF; -- Do nothing if the hold has already been released.

Line 2317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2313:
2314: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2315: RAISE FND_API.G_EXC_ERROR;
2316: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2318: END IF;
2319:
2320: END IF; -- Do nothing if the hold has already been released.
2321:

Line 2361: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2357: , x_msg_data => l_msg_data
2358: , x_return_status => l_return_status
2359: );
2360:
2361: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2362: RAISE FND_API.G_EXC_ERROR;
2363: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2365: END IF;

Line 2362: RAISE FND_API.G_EXC_ERROR;

2358: , x_return_status => l_return_status
2359: );
2360:
2361: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2362: RAISE FND_API.G_EXC_ERROR;
2363: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2365: END IF;
2366: END IF; -- Do nothing if the hold has already been released.

Line 2363: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2359: );
2360:
2361: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2362: RAISE FND_API.G_EXC_ERROR;
2363: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2365: END IF;
2366: END IF; -- Do nothing if the hold has already been released.
2367: END IF;

Line 2364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2360:
2361: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2362: RAISE FND_API.G_EXC_ERROR;
2363: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2365: END IF;
2366: END IF; -- Do nothing if the hold has already been released.
2367: END IF;
2368:

Line 2410: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2406: , x_msg_data => l_msg_data
2407: , x_return_status => l_return_status
2408: );
2409:
2410: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2411: RAISE FND_API.G_EXC_ERROR;
2412: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2414: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN

Line 2411: RAISE FND_API.G_EXC_ERROR;

2407: , x_return_status => l_return_status
2408: );
2409:
2410: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2411: RAISE FND_API.G_EXC_ERROR;
2412: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2414: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
2415: fnd_message.set_name('ONT', 'OE_CC_HOLD_REMOVED');

Line 2412: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2408: );
2409:
2410: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2411: RAISE FND_API.G_EXC_ERROR;
2412: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2414: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
2415: fnd_message.set_name('ONT', 'OE_CC_HOLD_REMOVED');
2416: oe_msg_pub.add;

Line 2413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2409:
2410: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2411: RAISE FND_API.G_EXC_ERROR;
2412: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2414: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
2415: fnd_message.set_name('ONT', 'OE_CC_HOLD_REMOVED');
2416: oe_msg_pub.add;
2417: END IF;

Line 2414: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN

2410: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2411: RAISE FND_API.G_EXC_ERROR;
2412: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2414: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
2415: fnd_message.set_name('ONT', 'OE_CC_HOLD_REMOVED');
2416: oe_msg_pub.add;
2417: END IF;
2418:

Line 2425: WHEN FND_API.G_EXC_ERROR THEN

2421: END IF; -- Electronic Payment
2422:
2423: EXCEPTION
2424:
2425: WHEN FND_API.G_EXC_ERROR THEN
2426: p_return_status := FND_API.G_RET_STS_ERROR;
2427: OE_MSG_PUB.Count_And_Get
2428: ( p_count => l_msg_count,
2429: p_data => l_msg_data

Line 2426: p_return_status := FND_API.G_RET_STS_ERROR;

2422:
2423: EXCEPTION
2424:
2425: WHEN FND_API.G_EXC_ERROR THEN
2426: p_return_status := FND_API.G_RET_STS_ERROR;
2427: OE_MSG_PUB.Count_And_Get
2428: ( p_count => l_msg_count,
2429: p_data => l_msg_data
2430: );

Line 2432: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2428: ( p_count => l_msg_count,
2429: p_data => l_msg_data
2430: );
2431:
2432: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2433: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2434: OE_MSG_PUB.Count_And_Get
2435: ( p_count => l_msg_count,
2436: p_data => l_msg_data

Line 2433: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2429: p_data => l_msg_data
2430: );
2431:
2432: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2433: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2434: OE_MSG_PUB.Count_And_Get
2435: ( p_count => l_msg_count,
2436: p_data => l_msg_data
2437: );

Line 2440: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2436: p_data => l_msg_data
2437: );
2438:
2439: WHEN OTHERS THEN
2440: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2441: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2442: THEN
2443: FND_MSG_PUB.Add_Exc_Msg
2444: ( G_PKG_NAME

Line 2482: p_return_status := FND_API.G_RET_STS_SUCCESS;

2478: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2479: --
2480: BEGIN
2481:
2482: p_return_status := FND_API.G_RET_STS_SUCCESS;
2483:
2484: IF l_debug_level > 0 THEN
2485: oe_debug_pub.add( 'OEXPVPMB: IN APPLY VERIFY HOLDS' ) ;
2486: END IF;

Line 2525: , p_validation_level => FND_API.G_VALID_LEVEL_NONE

2521: l_hold_source_rec.hold_entity_id := p_header_id; -- Order Header
2522:
2523: OE_Holds_PUB.Apply_Holds
2524: ( p_api_version => 1.0
2525: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
2526: , p_hold_source_rec => l_hold_source_rec
2527: , x_msg_count => l_msg_count
2528: , x_msg_data => l_msg_data
2529: , x_return_status => l_return_status

Line 2532: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

2528: , x_msg_data => l_msg_data
2529: , x_return_status => l_return_status
2530: );
2531:
2532: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2533: IF p_hold_id = 16 THEN
2534: FND_MESSAGE.SET_NAME('ONT','ONT_PENDING_AUTH_HOLD_APPLIED');
2535: FND_MESSAGE.SET_TOKEN('LEVEL','ORDER');
2536: OE_MSG_PUB.ADD;

Line 2541: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2537: IF l_debug_level > 0 THEN
2538: oe_debug_pub.add( 'OEXVPPYB: Pending Payment Authorization hold has been applied on order.', 3);
2539: END IF;
2540: END IF;
2541: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2542: RAISE FND_API.G_EXC_ERROR;
2543: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2545: END IF;

Line 2542: RAISE FND_API.G_EXC_ERROR;

2538: oe_debug_pub.add( 'OEXVPPYB: Pending Payment Authorization hold has been applied on order.', 3);
2539: END IF;
2540: END IF;
2541: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2542: RAISE FND_API.G_EXC_ERROR;
2543: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2545: END IF;
2546:

Line 2543: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2539: END IF;
2540: END IF;
2541: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2542: RAISE FND_API.G_EXC_ERROR;
2543: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2545: END IF;
2546:
2547: IF l_debug_level > 0 THEN

Line 2544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2540: END IF;
2541: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2542: RAISE FND_API.G_EXC_ERROR;
2543: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2545: END IF;
2546:
2547: IF l_debug_level > 0 THEN
2548: oe_debug_pub.add( 'OEXPVPMB: APPLIED VERIFY HOLD ON HEADER ID:' || P_HEADER_ID ) ;

Line 2553: WHEN FND_API.G_EXC_ERROR THEN

2549: END IF;
2550:
2551: EXCEPTION
2552:
2553: WHEN FND_API.G_EXC_ERROR THEN
2554: p_return_status := FND_API.G_RET_STS_ERROR;
2555: OE_MSG_PUB.Count_And_Get
2556: ( p_count => l_msg_count,
2557: p_data => l_msg_data

Line 2554: p_return_status := FND_API.G_RET_STS_ERROR;

2550:
2551: EXCEPTION
2552:
2553: WHEN FND_API.G_EXC_ERROR THEN
2554: p_return_status := FND_API.G_RET_STS_ERROR;
2555: OE_MSG_PUB.Count_And_Get
2556: ( p_count => l_msg_count,
2557: p_data => l_msg_data
2558: );

Line 2560: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2556: ( p_count => l_msg_count,
2557: p_data => l_msg_data
2558: );
2559:
2560: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2561: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2562: OE_MSG_PUB.Count_And_Get
2563: ( p_count => l_msg_count,
2564: p_data => l_msg_data

Line 2561: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2557: p_data => l_msg_data
2558: );
2559:
2560: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2561: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2562: OE_MSG_PUB.Count_And_Get
2563: ( p_count => l_msg_count,
2564: p_data => l_msg_data
2565: );

Line 2568: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2564: p_data => l_msg_data
2565: );
2566:
2567: WHEN OTHERS THEN
2568: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2569: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2570: THEN
2571: FND_MSG_PUB.Add_Exc_Msg
2572: ( G_PKG_NAME

Line 2614: p_return_status := FND_API.G_RET_STS_SUCCESS;

2610: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2611: --
2612: BEGIN
2613:
2614: p_return_status := FND_API.G_RET_STS_SUCCESS;
2615:
2616: IF l_debug_level > 0 THEN
2617: oe_debug_pub.add( 'OEXPVPMB: IN APPLY VERIFY HOLDS' ) ;
2618: END IF;

Line 2657: , p_validation_level => FND_API.G_VALID_LEVEL_NONE

2653: l_hold_source_rec.hold_entity_id := p_header_id; -- Order Header
2654:
2655: OE_Holds_PUB.Apply_Holds
2656: ( p_api_version => 1.0
2657: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
2658: , p_hold_source_rec => l_hold_source_rec
2659: , x_msg_count => l_msg_count
2660: , x_msg_data => l_msg_data
2661: , x_return_status => l_return_status

Line 2664: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

2660: , x_msg_data => l_msg_data
2661: , x_return_status => l_return_status
2662: );
2663:
2664: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2665: IF p_hold_id = 16 THEN
2666: FND_MESSAGE.SET_NAME('ONT','ONT_PENDING_AUTH_HOLD_APPLIED');
2667: FND_MESSAGE.SET_TOKEN('LEVEL','ORDER');
2668: OE_MSG_PUB.ADD;

Line 2673: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2669: IF l_debug_level > 0 THEN
2670: oe_debug_pub.add( 'OEXVPPYB: Pending Payment Authorization hold has been applied on order.', 3);
2671: END IF;
2672: END IF;
2673: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2674: RAISE FND_API.G_EXC_ERROR;
2675: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2676: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2677: END IF;

Line 2674: RAISE FND_API.G_EXC_ERROR;

2670: oe_debug_pub.add( 'OEXVPPYB: Pending Payment Authorization hold has been applied on order.', 3);
2671: END IF;
2672: END IF;
2673: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2674: RAISE FND_API.G_EXC_ERROR;
2675: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2676: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2677: END IF;
2678:

Line 2675: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2671: END IF;
2672: END IF;
2673: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2674: RAISE FND_API.G_EXC_ERROR;
2675: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2676: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2677: END IF;
2678:
2679: -- bug 4339864

Line 2676: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2672: END IF;
2673: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2674: RAISE FND_API.G_EXC_ERROR;
2675: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2676: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2677: END IF;
2678:
2679: -- bug 4339864
2680: IF l_debug_level > 0 THEN

Line 2693: WHEN FND_API.G_EXC_ERROR THEN

2689: END IF;
2690:
2691: EXCEPTION
2692:
2693: WHEN FND_API.G_EXC_ERROR THEN
2694: p_return_status := FND_API.G_RET_STS_ERROR;
2695: OE_MSG_PUB.Count_And_Get
2696: ( p_count => l_msg_count,
2697: p_data => l_msg_data

Line 2694: p_return_status := FND_API.G_RET_STS_ERROR;

2690:
2691: EXCEPTION
2692:
2693: WHEN FND_API.G_EXC_ERROR THEN
2694: p_return_status := FND_API.G_RET_STS_ERROR;
2695: OE_MSG_PUB.Count_And_Get
2696: ( p_count => l_msg_count,
2697: p_data => l_msg_data
2698: );

Line 2700: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2696: ( p_count => l_msg_count,
2697: p_data => l_msg_data
2698: );
2699:
2700: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2701: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2702: OE_MSG_PUB.Count_And_Get
2703: ( p_count => l_msg_count,
2704: p_data => l_msg_data

Line 2701: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2697: p_data => l_msg_data
2698: );
2699:
2700: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2701: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2702: OE_MSG_PUB.Count_And_Get
2703: ( p_count => l_msg_count,
2704: p_data => l_msg_data
2705: );

Line 2708: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2704: p_data => l_msg_data
2705: );
2706:
2707: WHEN OTHERS THEN
2708: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2709: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2710: THEN
2711: FND_MSG_PUB.Add_Exc_Msg
2712: ( G_PKG_NAME

Line 2750: p_return_status := FND_API.G_RET_STS_SUCCESS;

2746: --
2747: BEGIN
2748:
2749: p_result_out := 'PASS';
2750: p_return_status := FND_API.G_RET_STS_SUCCESS;
2751:
2752: IF l_debug_level > 0 THEN
2753: oe_debug_pub.add( 'OEXPVPMB: IN PAYMENT REQUEST MAIN' ) ;
2754: END IF;

Line 2804: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2800: , p_msg_data => l_msg_data
2801: , p_result_out => p_result_out
2802: , p_return_status=> l_return_status
2803: );
2804: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2805: RAISE FND_API.G_EXC_ERROR;
2806: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2807: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2808: END IF;

Line 2805: RAISE FND_API.G_EXC_ERROR;

2801: , p_result_out => p_result_out
2802: , p_return_status=> l_return_status
2803: );
2804: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2805: RAISE FND_API.G_EXC_ERROR;
2806: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2807: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2808: END IF;
2809:

Line 2806: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2802: , p_return_status=> l_return_status
2803: );
2804: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2805: RAISE FND_API.G_EXC_ERROR;
2806: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2807: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2808: END IF;
2809:
2810: ELSIF p_trxn_type = 'VOIDAUTHONLY' THEN

Line 2807: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2803: );
2804: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2805: RAISE FND_API.G_EXC_ERROR;
2806: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2807: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2808: END IF;
2809:
2810: ELSIF p_trxn_type = 'VOIDAUTHONLY' THEN
2811:

Line 2842: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2838: , p_msg_data => l_msg_data
2839: , p_return_status=> l_return_status
2840: , p_void_supported => l_void_supported
2841: ) ;
2842: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2843: RAISE FND_API.G_EXC_ERROR;
2844: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2845: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2846: END IF;

Line 2843: RAISE FND_API.G_EXC_ERROR;

2839: , p_return_status=> l_return_status
2840: , p_void_supported => l_void_supported
2841: ) ;
2842: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2843: RAISE FND_API.G_EXC_ERROR;
2844: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2845: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2846: END IF;
2847: END IF;

Line 2844: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2840: , p_void_supported => l_void_supported
2841: ) ;
2842: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2843: RAISE FND_API.G_EXC_ERROR;
2844: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2845: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2846: END IF;
2847: END IF;
2848:

Line 2845: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2841: ) ;
2842: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2843: RAISE FND_API.G_EXC_ERROR;
2844: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2845: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2846: END IF;
2847: END IF;
2848:
2849: -- Return if VOID is not even supported.

Line 2882: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2878: , l_msg_count
2879: , l_msg_data
2880: , l_return_status
2881: );
2882: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2883: RAISE FND_API.G_EXC_ERROR;
2884: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2886: END IF;

Line 2883: RAISE FND_API.G_EXC_ERROR;

2879: , l_msg_data
2880: , l_return_status
2881: );
2882: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2883: RAISE FND_API.G_EXC_ERROR;
2884: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2886: END IF;
2887:

Line 2884: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2880: , l_return_status
2881: );
2882: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2883: RAISE FND_API.G_EXC_ERROR;
2884: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2886: END IF;
2887:
2888: -- Release any existing Credit Card Holds on the Order

Line 2885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2881: );
2882: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2883: RAISE FND_API.G_EXC_ERROR;
2884: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2886: END IF;
2887:
2888: -- Release any existing Credit Card Holds on the Order
2889: IF l_debug_level > 0 THEN

Line 2900: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2896: , p_msg_count => l_msg_count
2897: , p_msg_data => l_msg_data
2898: , p_return_status => l_return_status
2899: );
2900: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2901: RAISE FND_API.G_EXC_ERROR;
2902: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2903: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2904: END IF;

Line 2901: RAISE FND_API.G_EXC_ERROR;

2897: , p_msg_data => l_msg_data
2898: , p_return_status => l_return_status
2899: );
2900: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2901: RAISE FND_API.G_EXC_ERROR;
2902: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2903: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2904: END IF;
2905:

Line 2902: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2898: , p_return_status => l_return_status
2899: );
2900: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2901: RAISE FND_API.G_EXC_ERROR;
2902: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2903: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2904: END IF;
2905:
2906: END IF;

Line 2903: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2899: );
2900: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2901: RAISE FND_API.G_EXC_ERROR;
2902: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2903: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2904: END IF;
2905:
2906: END IF;
2907:

Line 2910: WHEN FND_API.G_EXC_ERROR THEN

2906: END IF;
2907:
2908: EXCEPTION
2909:
2910: WHEN FND_API.G_EXC_ERROR THEN
2911: p_result_out := 'FAIL';
2912: p_return_status := FND_API.G_RET_STS_ERROR;
2913: OE_MSG_PUB.Count_And_Get
2914: ( p_count => l_msg_count,

Line 2912: p_return_status := FND_API.G_RET_STS_ERROR;

2908: EXCEPTION
2909:
2910: WHEN FND_API.G_EXC_ERROR THEN
2911: p_result_out := 'FAIL';
2912: p_return_status := FND_API.G_RET_STS_ERROR;
2913: OE_MSG_PUB.Count_And_Get
2914: ( p_count => l_msg_count,
2915: p_data => l_msg_data
2916: );

Line 2918: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2914: ( p_count => l_msg_count,
2915: p_data => l_msg_data
2916: );
2917:
2918: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2919: p_result_out := 'FAIL';
2920: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2921: OE_MSG_PUB.Count_And_Get
2922: ( p_count => l_msg_count,

Line 2920: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2916: );
2917:
2918: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2919: p_result_out := 'FAIL';
2920: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2921: OE_MSG_PUB.Count_And_Get
2922: ( p_count => l_msg_count,
2923: p_data => l_msg_data
2924: );

Line 2928: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2924: );
2925:
2926: WHEN OTHERS THEN
2927: p_result_out := 'FAIL';
2928: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2929: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2930: THEN
2931: FND_MSG_PUB.Add_Exc_Msg
2932: ( G_PKG_NAME

Line 3174: p_return_status := FND_API.G_RET_STS_SUCCESS;

3170: --
3171: BEGIN
3172:
3173: p_result_out := 'PASS' ;
3174: p_return_status := FND_API.G_RET_STS_SUCCESS;
3175:
3176: IF l_debug_level > 0 THEN
3177: oe_debug_pub.add( 'OEXPVPMB: IN AUTHORIZE PAYMENT' ) ;
3178: END IF;

Line 3216: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3212: , p_msg_data => l_msg_data
3213: , p_return_status=> l_return_status
3214: , p_void_supported => l_void_supported
3215: ) ;
3216: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3217: p_result_out := 'FAIL';
3218: RETURN;
3219: END IF;
3220:

Line 3762: IF l_return_status <> FND_API.G_RET_STS_SUCCESS OR l_status > 0 THEN

3758: oe_debug_pub.add( 'OEXPVPMB: AFTER EXECUTING THE PL/SQL BLOCK' ) ;
3759: END IF;
3760: --
3761:
3762: IF l_return_status <> FND_API.G_RET_STS_SUCCESS OR l_status > 0 THEN
3763: --bug 4065891 commenting out the following code which checks for err_code = 'IBY_0008'
3764: -- Check if the Operation was Supported or not
3765: /* IF NVL(l_err_code, 'XXX') = 'IBY_0008' THEN
3766: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3766: l_return_status := FND_API.G_RET_STS_SUCCESS;

3762: IF l_return_status <> FND_API.G_RET_STS_SUCCESS OR l_status > 0 THEN
3763: --bug 4065891 commenting out the following code which checks for err_code = 'IBY_0008'
3764: -- Check if the Operation was Supported or not
3765: /* IF NVL(l_err_code, 'XXX') = 'IBY_0008' THEN
3766: l_return_status := FND_API.G_RET_STS_SUCCESS;
3767: IF l_debug_level > 0 THEN
3768: oe_debug_pub.add( 'OEXPVPMB: OPERATION NOT SUPPORTED.' ) ;
3769: END IF;
3770: RETURN;

Line 3833: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3829: , l_msg_data
3830: , l_return_status
3831: );
3832:
3833: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3834: p_result_out := 'FAIL';
3835: RETURN;
3836: END IF;
3837:

Line 3871: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3867: EXCEPTION
3868:
3869: WHEN OTHERS THEN
3870: p_result_out := 'FAIL';
3871: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3872:
3873: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3874: THEN
3875: FND_MSG_PUB.Add_Exc_Msg

Line 4342: p_return_status := FND_API.G_RET_STS_SUCCESS;

4338: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4339: --
4340: BEGIN
4341:
4342: p_return_status := FND_API.G_RET_STS_SUCCESS;
4343: p_void_supported:= 'Y';
4344:
4345: IF l_debug_level > 0 THEN
4346: oe_debug_pub.add( 'OEXPVPMB: IN VOID PAYMENT' ) ;

Line 4434: l_return_status := FND_API.G_RET_STS_SUCCESS;

4430: IF l_status > 0 THEN
4431:
4432: -- Check if the Operation was Supported or not
4433: IF NVL(l_err_code, 'XXX') = 'IBY_0008' THEN
4434: l_return_status := FND_API.G_RET_STS_SUCCESS;
4435: p_void_supported:= 'N';
4436: IF l_debug_level > 0 THEN
4437: oe_debug_pub.add( 'OEXPVPMB: VOID TRANSACTION NOT SUPPORTED.' ) ;
4438: END IF;

Line 4441: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4437: oe_debug_pub.add( 'OEXPVPMB: VOID TRANSACTION NOT SUPPORTED.' ) ;
4438: END IF;
4439: RETURN;
4440: ELSE
4441: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4442: END IF;
4443: END IF;
4444:
4445: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 4445: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4441: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4442: END IF;
4443: END IF;
4444:
4445: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4446:
4447: -- Message "The following error(s) occurred when calling iPayment for Credit Card Transaction :"
4448: FND_MESSAGE.SET_NAME('ONT','OE_VPM_IPAYMENT_ERROR');
4449: FND_MESSAGE.SET_TOKEN('ERRCODE',l_err_code);

Line 4475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4471: IF l_debug_level > 0 THEN
4472: oe_debug_pub.add( 'OEXPVPMB: BEP ERR MESG : '||L_BEP_ERR_MESG ) ;
4473: END IF;
4474:
4475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4476:
4477: END IF;
4478:
4479: EXCEPTION

Line 4481: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4477: END IF;
4478:
4479: EXCEPTION
4480:
4481: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4482: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4483: OE_MSG_PUB.Count_And_Get
4484: ( p_count => l_msg_count,
4485: p_data => l_msg_data

Line 4482: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4478:
4479: EXCEPTION
4480:
4481: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4482: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4483: OE_MSG_PUB.Count_And_Get
4484: ( p_count => l_msg_count,
4485: p_data => l_msg_data
4486: );

Line 4489: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4485: p_data => l_msg_data
4486: );
4487:
4488: WHEN OTHERS THEN
4489: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4490: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4491: THEN
4492: FND_MSG_PUB.Add_Exc_Msg
4493: ( G_PKG_NAME

Line 4746: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4742: END IF;
4743: IF l_debug_level > 0 THEN
4744: oe_debug_pub.add( 'OEXPVPMB: ERROR: '||SQLERRM ) ;
4745: END IF;
4746: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4747: end;
4748:
4749: END IF;
4750:

Line 4791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4787: END IF;
4788: IF l_debug_level > 0 THEN
4789: oe_debug_pub.add( 'OEXPVPMB: ERROR: '||SQLERRM ) ;
4790: END IF;
4791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4792: end;
4793:
4794: END IF;
4795:

Line 4947: p_return_status := FND_API.G_RET_STS_SUCCESS;

4943: BEGIN
4944:
4945: SAVEPOINT Update_Authorization_Info;
4946:
4947: p_return_status := FND_API.G_RET_STS_SUCCESS;
4948:
4949: IF l_debug_level > 0 THEN
4950: oe_debug_pub.add( 'OEXPVPMB: IN UPDATE AUTHORIZATION INFORMATION' ) ;
4951: END IF;

Line 4959: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

4955: (p_header_id => p_header_id
4956: ,p_x_header_rec => l_old_header_rec
4957: ,x_return_status => l_return_status
4958: );
4959: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4960: RAISE FND_API.G_EXC_ERROR;
4961: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4962: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4963: END IF;

Line 4960: RAISE FND_API.G_EXC_ERROR;

4956: ,p_x_header_rec => l_old_header_rec
4957: ,x_return_status => l_return_status
4958: );
4959: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4960: RAISE FND_API.G_EXC_ERROR;
4961: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4962: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4963: END IF;
4964:

Line 4961: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4957: ,x_return_status => l_return_status
4958: );
4959: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4960: RAISE FND_API.G_EXC_ERROR;
4961: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4962: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4963: END IF;
4964:
4965: l_header_rec := l_old_header_rec;

Line 4962: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4958: );
4959: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4960: RAISE FND_API.G_EXC_ERROR;
4961: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4962: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4963: END IF;
4964:
4965: l_header_rec := l_old_header_rec;
4966:

Line 5045: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

5041: --IF l_debug_level > 0 THEN
5042: --oe_debug_pub.add( 'GLOBAL HDR CC APPROVAL_DATE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.CREDIT_CARD_APPROVAL_DATE , 1 ) ;
5043: --END IF;
5044:
5045: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5046: RAISE FND_API.G_EXC_ERROR;
5047: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5049: END IF;

Line 5046: RAISE FND_API.G_EXC_ERROR;

5042: --oe_debug_pub.add( 'GLOBAL HDR CC APPROVAL_DATE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.CREDIT_CARD_APPROVAL_DATE , 1 ) ;
5043: --END IF;
5044:
5045: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5046: RAISE FND_API.G_EXC_ERROR;
5047: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5049: END IF;
5050:

Line 5047: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5043: --END IF;
5044:
5045: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5046: RAISE FND_API.G_EXC_ERROR;
5047: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5049: END IF;
5050:
5051: -- Process requests is TRUE so still need to call it, but don't need to notify

Line 5048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5044:
5045: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5046: RAISE FND_API.G_EXC_ERROR;
5047: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5049: END IF;
5050:
5051: -- Process requests is TRUE so still need to call it, but don't need to notify
5052: IF l_debug_level > 0 THEN

Line 5063: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

5059: , p_old_header_rec => l_old_header_rec
5060: , x_return_status => l_return_status
5061: );
5062:
5063: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5064: RAISE FND_API.G_EXC_ERROR;
5065: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5067: END IF;

Line 5064: RAISE FND_API.G_EXC_ERROR;

5060: , x_return_status => l_return_status
5061: );
5062:
5063: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5064: RAISE FND_API.G_EXC_ERROR;
5065: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5067: END IF;
5068:

Line 5065: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5061: );
5062:
5063: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5064: RAISE FND_API.G_EXC_ERROR;
5065: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5067: END IF;
5068:
5069: END IF ; /* global entity index null check */

Line 5066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5062:
5063: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5064: RAISE FND_API.G_EXC_ERROR;
5065: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5067: END IF;
5068:
5069: END IF ; /* global entity index null check */
5070:

Line 5084: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

5080: , p_old_header_rec => l_old_header_rec
5081: , x_return_status => l_return_status
5082: );
5083:
5084: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5085: RAISE FND_API.G_EXC_ERROR;
5086: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5088: END IF;

Line 5085: RAISE FND_API.G_EXC_ERROR;

5081: , x_return_status => l_return_status
5082: );
5083:
5084: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5085: RAISE FND_API.G_EXC_ERROR;
5086: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5088: END IF;
5089:

Line 5086: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5082: );
5083:
5084: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5085: RAISE FND_API.G_EXC_ERROR;
5086: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5088: END IF;
5089:
5090: -- notification framework end

Line 5087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5083:
5084: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5085: RAISE FND_API.G_EXC_ERROR;
5086: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5088: END IF;
5089:
5090: -- notification framework end
5091: END IF; /* code set is pack H or higher */

Line 5096: WHEN FND_API.G_EXC_ERROR THEN

5092: /* jolin end*/
5093:
5094: EXCEPTION
5095:
5096: WHEN FND_API.G_EXC_ERROR THEN
5097: ROLLBACK TO Update_Authorization_Info;
5098: p_return_status := FND_API.G_RET_STS_ERROR;
5099: OE_MSG_PUB.Count_And_Get
5100: ( p_count => l_msg_count,

Line 5098: p_return_status := FND_API.G_RET_STS_ERROR;

5094: EXCEPTION
5095:
5096: WHEN FND_API.G_EXC_ERROR THEN
5097: ROLLBACK TO Update_Authorization_Info;
5098: p_return_status := FND_API.G_RET_STS_ERROR;
5099: OE_MSG_PUB.Count_And_Get
5100: ( p_count => l_msg_count,
5101: p_data => l_msg_data
5102: );

Line 5104: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5100: ( p_count => l_msg_count,
5101: p_data => l_msg_data
5102: );
5103:
5104: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5105: ROLLBACK TO Update_Authorization_Info;
5106: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5107: OE_MSG_PUB.Count_And_Get
5108: ( p_count => l_msg_count,

Line 5106: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5102: );
5103:
5104: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5105: ROLLBACK TO Update_Authorization_Info;
5106: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5107: OE_MSG_PUB.Count_And_Get
5108: ( p_count => l_msg_count,
5109: p_data => l_msg_data
5110: );

Line 5114: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5110: );
5111:
5112: WHEN OTHERS THEN
5113: ROLLBACK TO Update_Authorization_Info;
5114: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5115:
5116: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5117: THEN
5118: FND_MSG_PUB.Add_Exc_Msg

Line 5348: p_return_status := FND_API.G_RET_STS_SUCCESS;

5344:
5345: BEGIN
5346:
5347: p_result_out := 'PASS' ;
5348: p_return_status := FND_API.G_RET_STS_SUCCESS;
5349:
5350: IF l_debug_level > 0 THEN
5351: oe_debug_pub.add( 'OEXPVPMB: IN AUTHORIZE MULTIPLE PAYMENTS' ) ;
5352: END IF;

Line 5519: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

5515: , p_return_status => l_return_status
5516: );
5517:
5518: END IF;
5519: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5520: RAISE FND_API.G_EXC_ERROR;
5521: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5523: END IF;

Line 5520: RAISE FND_API.G_EXC_ERROR;

5516: );
5517:
5518: END IF;
5519: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5520: RAISE FND_API.G_EXC_ERROR;
5521: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5523: END IF;
5524: goto Next_In_Loop;

Line 5521: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5517:
5518: END IF;
5519: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5520: RAISE FND_API.G_EXC_ERROR;
5521: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5523: END IF;
5524: goto Next_In_Loop;
5525: END IF;

Line 5522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5518: END IF;
5519: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5520: RAISE FND_API.G_EXC_ERROR;
5521: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5523: END IF;
5524: goto Next_In_Loop;
5525: END IF;
5526:

Line 5550: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

5546: , p_msg_count => l_msg_count
5547: , p_msg_data => l_msg_data
5548: , p_return_status => l_return_status
5549: );
5550: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5551: RAISE FND_API.G_EXC_ERROR;
5552: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5554: END IF;

Line 5551: RAISE FND_API.G_EXC_ERROR;

5547: , p_msg_data => l_msg_data
5548: , p_return_status => l_return_status
5549: );
5550: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5551: RAISE FND_API.G_EXC_ERROR;
5552: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5554: END IF;
5555: goto Next_In_Loop;

Line 5552: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5548: , p_return_status => l_return_status
5549: );
5550: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5551: RAISE FND_API.G_EXC_ERROR;
5552: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5554: END IF;
5555: goto Next_In_Loop;
5556: END IF;

Line 5553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5549: );
5550: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5551: RAISE FND_API.G_EXC_ERROR;
5552: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5554: END IF;
5555: goto Next_In_Loop;
5556: END IF;
5557:

Line 5608: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

5604: , p_msg_count => l_msg_count
5605: , p_msg_data => l_msg_data
5606: , p_return_status => l_return_status
5607: );
5608: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5609: RAISE FND_API.G_EXC_ERROR;
5610: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5612: END IF;

Line 5609: RAISE FND_API.G_EXC_ERROR;

5605: , p_msg_data => l_msg_data
5606: , p_return_status => l_return_status
5607: );
5608: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5609: RAISE FND_API.G_EXC_ERROR;
5610: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5612: END IF;
5613: goto Next_In_Loop;

Line 5610: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5606: , p_return_status => l_return_status
5607: );
5608: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5609: RAISE FND_API.G_EXC_ERROR;
5610: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5612: END IF;
5613: goto Next_In_Loop;
5614: END IF;

Line 5611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5607: );
5608: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5609: RAISE FND_API.G_EXC_ERROR;
5610: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5612: END IF;
5613: goto Next_In_Loop;
5614: END IF;
5615:

Line 5822: IF l_hold_result = FND_API.G_TRUE THEN

5818: , x_return_status => l_return_status
5819: );
5820: END IF;
5821:
5822: IF l_hold_result = FND_API.G_TRUE THEN
5823: IF l_debug_level > 0 THEN
5824: oe_debug_pub.add( 'OEXPVPMB: ORDER IS ON RISK HOLD' ) ;
5825: END IF;
5826: l_result_status := 'RISK';

Line 6121: p_init_msg_list => FND_API.G_FALSE,

6117: oe_debug_pub.add('Calling Create Reversal',0.5);
6118: END IF;
6119: IBY_Fndcpt_Trxn_Pub.Create_Reversal
6120: (p_api_version => 1.0,
6121: p_init_msg_list => FND_API.G_FALSE,
6122: p_payer => l_payer,
6123: p_payer_equivalency => IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_UPWARD,
6124: p_trxn_entity_id => l_trxn_extension_id,
6125: p_rev_attribs => l_rev_attribs,

Line 6177: /* IF l_return_status = FND_API.G_RET_STS_SUCCESS AND

6173: --For bug 3571485
6174: l_format_mask := get_format_mask(p_header_rec.transactional_curr_code);
6175: END IF; --CC Reversal ER#16014135
6176:
6177: /* IF l_return_status = FND_API.G_RET_STS_SUCCESS AND
6178: l_response.result_code = 'AUTH_SUCCESS' THEN */ --CC Reversal ER#16014135 Commented
6179: --CC Reversal ER#16014135 Start
6180: IF (l_return_status = FND_API.G_RET_STS_SUCCESS AND
6181: l_response.result_code = 'AUTH_SUCCESS') OR

Line 6180: IF (l_return_status = FND_API.G_RET_STS_SUCCESS AND

6176:
6177: /* IF l_return_status = FND_API.G_RET_STS_SUCCESS AND
6178: l_response.result_code = 'AUTH_SUCCESS' THEN */ --CC Reversal ER#16014135 Commented
6179: --CC Reversal ER#16014135 Start
6180: IF (l_return_status = FND_API.G_RET_STS_SUCCESS AND
6181: l_response.result_code = 'AUTH_SUCCESS') OR
6182: (l_return_status = FND_API.G_RET_STS_SUCCESS AND
6183: l_reversal_response.result_code = IBY_FNDCPT_TRXN_PUB.G_RC_REVERSAL_SUCCESS AND
6184: l_reauth_response.result_code = IBY_FNDCPT_TRXN_PUB.G_RC_AUTH_SUCCESS) THEN

Line 6182: (l_return_status = FND_API.G_RET_STS_SUCCESS AND

6178: l_response.result_code = 'AUTH_SUCCESS' THEN */ --CC Reversal ER#16014135 Commented
6179: --CC Reversal ER#16014135 Start
6180: IF (l_return_status = FND_API.G_RET_STS_SUCCESS AND
6181: l_response.result_code = 'AUTH_SUCCESS') OR
6182: (l_return_status = FND_API.G_RET_STS_SUCCESS AND
6183: l_reversal_response.result_code = IBY_FNDCPT_TRXN_PUB.G_RC_REVERSAL_SUCCESS AND
6184: l_reauth_response.result_code = IBY_FNDCPT_TRXN_PUB.G_RC_AUTH_SUCCESS) THEN
6185: --CC Reversal ER#16014135 End
6186: /*

Line 6227: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

6223: , p_return_status => l_return_status
6224: );
6225: END IF;
6226:
6227: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
6228: RAISE FND_API.G_EXC_ERROR;
6229: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6231: END IF;

Line 6228: RAISE FND_API.G_EXC_ERROR;

6224: );
6225: END IF;
6226:
6227: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
6228: RAISE FND_API.G_EXC_ERROR;
6229: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6231: END IF;
6232:

Line 6229: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

6225: END IF;
6226:
6227: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
6228: RAISE FND_API.G_EXC_ERROR;
6229: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6231: END IF;
6232:
6233: --Risk Score evaluation -- Bug 6805953

Line 6230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6226:
6227: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
6228: RAISE FND_API.G_EXC_ERROR;
6229: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6231: END IF;
6232:
6233: --Risk Score evaluation -- Bug 6805953
6234: IF nvl(p_risk_eval_flag, 'Y') = 'Y' THEN --change flag to p_risk_eval_flag l_RiskEval_Enable_Flag verify

Line 6304: RAISE FND_API.G_EXC_ERROR;

6300: END IF;
6301: -- the value is reject, then
6302: FND_MESSAGE.SET_NAME('ONT','ONT_RISK_VALIDATION_FAILED');
6303: OE_MSG_PUB.ADD;
6304: RAISE FND_API.G_EXC_ERROR;
6305: END IF; --Reject flag
6306: comm rej */
6307: END IF; -- risk score > threshold
6308: END IF; --risk eval flag = y

Line 6352: /* ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS AND

6348:
6349: --bug 4767915
6350: --A new message has been added for the scenario when the
6351: --authorization is successful but security code validation has failed
6352: /* ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS AND
6353: l_response.result_code = 'SECURITY_CODE_WARNING' THEN */ --CC Reversal ER#16014135 Commented
6354: --CC Reversal ER#16014135 Start
6355: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS AND
6356: (l_response.result_code = 'SECURITY_CODE_WARNING'

Line 6355: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS AND

6351: --authorization is successful but security code validation has failed
6352: /* ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS AND
6353: l_response.result_code = 'SECURITY_CODE_WARNING' THEN */ --CC Reversal ER#16014135 Commented
6354: --CC Reversal ER#16014135 Start
6355: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS AND
6356: (l_response.result_code = 'SECURITY_CODE_WARNING'
6357: OR l_reauth_response.result_code = 'SECURITY_CODE_WARNING') THEN
6358: --CC Reversal ER#16014135 End
6359: /*

Line 6442: /* ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS AND

6438: FND_MESSAGE.SET_NAME('ONT','ONT_CC_SECURITY_CODE_FAILED');
6439: OE_MSG_PUB.ADD;
6440: RETURN;
6441: --bug 4767915
6442: /* ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS AND
6443: l_response.result_code = 'RISK_THRESHOLD_EXCEEDED' THEN
6444:
6445: IF l_debug_level > 0 THEN
6446: oe_debug_pub.add('Risk threshold exceeded...');

Line 6597: RAISE FND_API.G_EXC_ERROR;

6593: -- the value is to reject on failure, then
6594: -- raise error so the transaction will fail
6595: FND_MESSAGE.SET_NAME('ONT',' ONT_CC_AUTH_FAILED'); FND_MESSAGE.SET_TOKEN('AMOUNT',TO_CHAR(l_amount_to_authorize,l_format_mask));
6596: OE_MSG_PUB.ADD;
6597: RAISE FND_API.G_EXC_ERROR;
6598: END IF;
6599: comm rej*/
6600: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
6601: RAISE FND_API.G_EXC_ERROR;

Line 6600: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

6596: OE_MSG_PUB.ADD;
6597: RAISE FND_API.G_EXC_ERROR;
6598: END IF;
6599: comm rej*/
6600: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
6601: RAISE FND_API.G_EXC_ERROR;
6602: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6604: END IF;

Line 6601: RAISE FND_API.G_EXC_ERROR;

6597: RAISE FND_API.G_EXC_ERROR;
6598: END IF;
6599: comm rej*/
6600: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
6601: RAISE FND_API.G_EXC_ERROR;
6602: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6604: END IF;
6605:

Line 6602: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

6598: END IF;
6599: comm rej*/
6600: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
6601: RAISE FND_API.G_EXC_ERROR;
6602: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6604: END IF;
6605:
6606: END IF; --Return status of create_auth

Line 6603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6599: comm rej*/
6600: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
6601: RAISE FND_API.G_EXC_ERROR;
6602: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6604: END IF;
6605:
6606: END IF; --Return status of create_auth
6607:

Line 6651: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6647: );
6648: END IF;
6649:
6650:
6651: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6652: p_result_out := 'FAIL';
6653:
6654:
6655:

Line 6695: AND l_return_status = FND_API.G_RET_STS_SUCCESS THEN

6691: NULL;
6692: --CC Reversal ER#16014135 End
6693: --IF l_result_status = 'PASS' --CC Reversal ER#16014135 Commented
6694: ELSIF l_result_status = 'PASS' --CC Reversal ER#16014135
6695: AND l_return_status = FND_API.G_RET_STS_SUCCESS THEN
6696:
6697: -- Release Any existing CC Holds
6698: IF l_debug_level > 0 THEN
6699: oe_debug_pub.add( 'OEXPVPMB: RELEASING LINE LEVEL CREDIT CARD HOLDS' ) ;

Line 6723: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

6719: , p_return_status => l_return_status
6720: );
6721: END IF;
6722:
6723: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
6724: RAISE FND_API.G_EXC_ERROR;
6725: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6726: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6727: END IF;

Line 6724: RAISE FND_API.G_EXC_ERROR;

6720: );
6721: END IF;
6722:
6723: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
6724: RAISE FND_API.G_EXC_ERROR;
6725: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6726: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6727: END IF;
6728:

Line 6725: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

6721: END IF;
6722:
6723: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
6724: RAISE FND_API.G_EXC_ERROR;
6725: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6726: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6727: END IF;
6728:
6729: ELSIF l_result_status = 'RISK' THEN

Line 6726: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6722:
6723: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
6724: RAISE FND_API.G_EXC_ERROR;
6725: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6726: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6727: END IF;
6728:
6729: ELSIF l_result_status = 'RISK' THEN
6730:

Line 6755: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

6751: , p_return_status => l_return_status
6752: );
6753: END IF;
6754:
6755: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
6756: RAISE FND_API.G_EXC_ERROR;
6757: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6759: END IF;

Line 6756: RAISE FND_API.G_EXC_ERROR;

6752: );
6753: END IF;
6754:
6755: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
6756: RAISE FND_API.G_EXC_ERROR;
6757: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6759: END IF;
6760: ELSE -- Failed

Line 6757: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

6753: END IF;
6754:
6755: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
6756: RAISE FND_API.G_EXC_ERROR;
6757: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6759: END IF;
6760: ELSE -- Failed
6761:

Line 6758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6754:
6755: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
6756: RAISE FND_API.G_EXC_ERROR;
6757: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6759: END IF;
6760: ELSE -- Failed
6761:
6762: -- Apply CC Auth Failure Hold on the Order

Line 6787: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

6783: , p_return_status => l_return_status
6784: );
6785: END IF;
6786:
6787: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
6788: RAISE FND_API.G_EXC_ERROR;
6789: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6790: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6791: END IF;

Line 6788: RAISE FND_API.G_EXC_ERROR;

6784: );
6785: END IF;
6786:
6787: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
6788: RAISE FND_API.G_EXC_ERROR;
6789: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6790: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6791: END IF;
6792:

Line 6789: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

6785: END IF;
6786:
6787: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
6788: RAISE FND_API.G_EXC_ERROR;
6789: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6790: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6791: END IF;
6792:
6793: END IF; -- IF Result Status.

Line 6790: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6786:
6787: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
6788: RAISE FND_API.G_EXC_ERROR;
6789: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6790: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6791: END IF;
6792:
6793: END IF; -- IF Result Status.
6794:

Line 6806: WHEN FND_API.G_EXC_ERROR THEN

6802: --CC Reversal ER#16014135 End
6803: p_return_status := l_return_status;
6804:
6805: EXCEPTION
6806: WHEN FND_API.G_EXC_ERROR THEN
6807: l_err_message := SQLERRM;
6808: /*
6809: IF l_debug_level > 0 THEN
6810: oe_debug_pub.add('Create_Authorization error....exc');

Line 6833: p_return_status := FND_API.G_RET_STS_ERROR;

6829: oe_debug_pub.add('Error'||l_err_message,5);
6830: END IF;
6831: END IF;
6832: --CC Reversal ER#16014135 End
6833: p_return_status := FND_API.G_RET_STS_ERROR;
6834: OE_MSG_PUB.Count_And_Get
6835: ( p_count => l_msg_count,
6836: p_data => l_msg_data
6837: );

Line 6839: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6835: ( p_count => l_msg_count,
6836: p_data => l_msg_data
6837: );
6838:
6839: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6840: l_err_message := SQLERRM;
6841: /*
6842: IF l_debug_level > 0 THEN
6843: oe_debug_pub.add('Create_Authorization error....unxc');

Line 6866: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6862: oe_debug_pub.add('f Error'||l_err_message,5);
6863: END IF;
6864: END IF;
6865: --CC Reversal ER#16014135 End
6866: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6867: OE_MSG_PUB.Count_And_Get
6868: ( p_count => l_msg_count,
6869: p_data => l_msg_data
6870: );

Line 6877: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6873: l_err_message := SQLERRM;
6874: oe_debug_pub.add('Returned error others part in Auth multi payments...'||l_err_message);
6875:
6876: p_result_out := 'FAIL';
6877: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6878:
6879: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6880: THEN
6881: FND_MSG_PUB.Add_Exc_Msg

Line 6937: x_return_status := FND_API.G_RET_STS_SUCCESS;

6933: --
6934:
6935: BEGIN
6936:
6937: x_return_status := FND_API.G_RET_STS_SUCCESS;
6938: IF l_debug_level > 0 THEN
6939: oe_debug_pub.add( 'OEXPVPMB: IN CHECK REAUTHORIZE ORDER' ) ;
6940: END IF;
6941:

Line 6974: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

6970: x_msg_count => x_msg_count,
6971: x_msg_data => x_msg_data,
6972: x_return_status => x_return_status);
6973:
6974: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
6975: RAISE FND_API.G_EXC_ERROR;
6976: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6977: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6978: END IF;

Line 6975: RAISE FND_API.G_EXC_ERROR;

6971: x_msg_data => x_msg_data,
6972: x_return_status => x_return_status);
6973:
6974: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
6975: RAISE FND_API.G_EXC_ERROR;
6976: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6977: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6978: END IF;
6979:

Line 6976: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

6972: x_return_status => x_return_status);
6973:
6974: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
6975: RAISE FND_API.G_EXC_ERROR;
6976: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6977: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6978: END IF;
6979:
6980: -- update oe_payments table

Line 6977: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6973:
6974: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
6975: RAISE FND_API.G_EXC_ERROR;
6976: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6977: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6978: END IF;
6979:
6980: -- update oe_payments table
6981: UPDATE oe_payments

Line 7032: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

7028: x_msg_count => x_msg_count,
7029: x_msg_data => x_msg_data,
7030: x_return_status => x_return_status);
7031:
7032: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
7033: RAISE FND_API.G_EXC_ERROR;
7034: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7036: END IF;

Line 7033: RAISE FND_API.G_EXC_ERROR;

7029: x_msg_data => x_msg_data,
7030: x_return_status => x_return_status);
7031:
7032: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
7033: RAISE FND_API.G_EXC_ERROR;
7034: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7036: END IF;
7037:

Line 7034: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

7030: x_return_status => x_return_status);
7031:
7032: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
7033: RAISE FND_API.G_EXC_ERROR;
7034: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7036: END IF;
7037:
7038: -- update oe_payments table

Line 7035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7031:
7032: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
7033: RAISE FND_API.G_EXC_ERROR;
7034: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7036: END IF;
7037:
7038: -- update oe_payments table
7039: UPDATE oe_payments

Line 7081: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

7077: x_msg_count => x_msg_count,
7078: x_msg_data => x_msg_data,
7079: x_return_status => x_return_status);
7080:
7081: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
7082: RAISE FND_API.G_EXC_ERROR;
7083: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7085: END IF;

Line 7082: RAISE FND_API.G_EXC_ERROR;

7078: x_msg_data => x_msg_data,
7079: x_return_status => x_return_status);
7080:
7081: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
7082: RAISE FND_API.G_EXC_ERROR;
7083: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7085: END IF;
7086: IF l_debug_level > 0 THEN

Line 7083: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

7079: x_return_status => x_return_status);
7080:
7081: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
7082: RAISE FND_API.G_EXC_ERROR;
7083: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7085: END IF;
7086: IF l_debug_level > 0 THEN
7087: oe_debug_pub.add( 'OEXPVPMB: updating new trxn_extension_id ');

Line 7084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7080:
7081: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
7082: RAISE FND_API.G_EXC_ERROR;
7083: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7085: END IF;
7086: IF l_debug_level > 0 THEN
7087: oe_debug_pub.add( 'OEXPVPMB: updating new trxn_extension_id ');
7088: END IF;

Line 7206: ELSIF(p_calling_action is null OR nvl(l_cc_rev_reauth_code,FND_API.G_MISS_CHAR) = 'REV_REAUTH')

7202: , p_return_status => l_return_status
7203: );
7204: END IF;
7205: END IF;
7206: ELSIF(p_calling_action is null OR nvl(l_cc_rev_reauth_code,FND_API.G_MISS_CHAR) = 'REV_REAUTH')
7207: OR (G_init_calling_action ='PICKING' AND l_cc_rev_reauth_code='REV_REAUTH_AT_PICK')
7208: OR p_calling_action ='REVERSAL_REAUTH'
7209: THEN
7210: IF l_debug_level > 0 THEN

Line 7280: WHEN FND_API.G_EXC_ERROR THEN

7276: p_msg_data => l_msg_data,
7277: p_return_status => l_return_status
7278: );
7279: EXCEPTION
7280: WHEN FND_API.G_EXC_ERROR THEN
7281: IF l_debug_level > 0 THEN
7282: oe_debug_pub.add('Reverse_CreditCard_Auth error....exc',5);
7283: oe_debug_pub.add('After call to Reverse_CreditCard_Auth'||l_return_status,5);
7284: oe_debug_pub.add('Error'||sqlerrm,5);

Line 7286: l_return_status := FND_API.G_RET_STS_ERROR;

7282: oe_debug_pub.add('Reverse_CreditCard_Auth error....exc',5);
7283: oe_debug_pub.add('After call to Reverse_CreditCard_Auth'||l_return_status,5);
7284: oe_debug_pub.add('Error'||sqlerrm,5);
7285: END IF;
7286: l_return_status := FND_API.G_RET_STS_ERROR;
7287: OE_MSG_PUB.Count_And_Get
7288: ( p_count => l_msg_count,
7289: p_data => l_msg_data
7290: );

Line 7291: RAISE FND_API.G_EXC_ERROR;

7287: OE_MSG_PUB.Count_And_Get
7288: ( p_count => l_msg_count,
7289: p_data => l_msg_data
7290: );
7291: RAISE FND_API.G_EXC_ERROR;
7292: WHEN OTHERS THEN
7293: OE_MSG_PUB.Count_And_Get
7294: ( p_count => l_msg_count,
7295: p_data => l_msg_data

Line 7301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7297: IF l_debug_level > 0 THEN
7298: oe_debug_pub.add('After call to Reverse_CreditCard_Auth --> Unexpected error',5);
7299: oe_debug_pub.add('Error message '||sqlerrm,5);
7300: END IF;
7301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7302: END;
7303: END IF;
7304: --CC Reversal ER#16014135 End
7305: ELSE

Line 7319: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7315:
7316: p_reauthorize_out := l_reauthorize_flag ;
7317:
7318: EXCEPTION WHEN OTHERS THEN
7319: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7320: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7321: THEN
7322: FND_MSG_PUB.Add_Exc_Msg
7323: ( G_PKG_NAME

Line 7363: l_return_status VARCHAR2(30) := FND_API.G_RET_STS_SUCCESS;

7359:
7360: --pnpl start
7361: l_pay_now_total_detail_tbl AR_VIEW_TERM_GRP.amounts_table;
7362: l_pay_now_total_summary_rec AR_VIEW_TERM_GRP.summary_amounts_rec;
7363: l_return_status VARCHAR2(30) := FND_API.G_RET_STS_SUCCESS;
7364: l_return_value NUMBER;
7365: --pnpl end
7366: Is_fmt BOOLEAN; --8241416
7367:

Line 7567: ,p_init_msg_list => FND_API.G_TRUE

7563:
7564: -- calling AR API to get pay now total
7565: AR_VIEW_TERM_GRP.pay_now_amounts
7566: (p_api_version => 1.0
7567: ,p_init_msg_list => FND_API.G_TRUE
7568: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
7569: ,p_currency_code => OE_Order_Cache.g_header_rec.transactional_curr_code
7570: ,p_amounts_tbl => l_pay_now_total_detail_tbl
7571: ,x_pay_now_summary_rec => l_pay_now_total_summary_rec

Line 7568: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

7564: -- calling AR API to get pay now total
7565: AR_VIEW_TERM_GRP.pay_now_amounts
7566: (p_api_version => 1.0
7567: ,p_init_msg_list => FND_API.G_TRUE
7568: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
7569: ,p_currency_code => OE_Order_Cache.g_header_rec.transactional_curr_code
7570: ,p_amounts_tbl => l_pay_now_total_detail_tbl
7571: ,x_pay_now_summary_rec => l_pay_now_total_summary_rec
7572: ,x_return_status => l_return_status

Line 7621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7617: WHEN OTHERS THEN
7618: IF l_debug_level > 0 THEN
7619: oe_debug_pub.add( 'Unexpected Error from OE_Verify_Payment_PUB.Get_Line_Total ' || SQLERRM ) ;
7620: END IF;
7621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7622: END Get_Line_Total;
7623:
7624: --bug3225795 start
7625: --This function is currently similar to Get_Line_Total. Needs to be changed later to consider partial invoicing.

Line 7652: l_return_status VARCHAR2(30) := FND_API.G_RET_STS_SUCCESS;

7648:
7649: --pnpl start
7650: l_pay_now_total_detail_tbl AR_VIEW_TERM_GRP.amounts_table;
7651: l_pay_now_total_summary_rec AR_VIEW_TERM_GRP.summary_amounts_rec;
7652: l_return_status VARCHAR2(30) := FND_API.G_RET_STS_SUCCESS;
7653: l_return_value NUMBER;
7654: --pnpl end
7655:
7656:

Line 7820: ,p_init_msg_list => FND_API.G_TRUE

7816:
7817: -- calling AR API to get pay now total
7818: AR_VIEW_TERM_GRP.pay_now_amounts
7819: (p_api_version => 1.0
7820: ,p_init_msg_list => FND_API.G_TRUE
7821: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
7822: ,p_currency_code => OE_Order_Cache.g_header_rec.transactional_curr_code
7823: ,p_amounts_tbl => l_pay_now_total_detail_tbl
7824: ,x_pay_now_summary_rec => l_pay_now_total_summary_rec

Line 7821: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

7817: -- calling AR API to get pay now total
7818: AR_VIEW_TERM_GRP.pay_now_amounts
7819: (p_api_version => 1.0
7820: ,p_init_msg_list => FND_API.G_TRUE
7821: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
7822: ,p_currency_code => OE_Order_Cache.g_header_rec.transactional_curr_code
7823: ,p_amounts_tbl => l_pay_now_total_detail_tbl
7824: ,x_pay_now_summary_rec => l_pay_now_total_summary_rec
7825: ,x_return_status => l_return_status

Line 7860: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7856: WHEN OTHERS THEN
7857: IF l_debug_level > 0 THEN
7858: oe_debug_pub.add( 'FROM OE_Verify_Payment_PUB.Get_Inv_Line_Total' ) ;
7859: END IF;
7860: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7861: END Get_Inv_Line_Total;
7862:
7863: --This function also needs to be modified later to consider partial invoicing
7864: FUNCTION Outbound_Order_Total

Line 8035: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

8031: ,x_msg_count => l_msg_count
8032: ,x_msg_data => l_msg_data
8033: ,x_return_status => l_return_status
8034: );
8035: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8036: IF l_debug_level > 0 THEN
8037: oe_debug_pub.add('Error in OE_Prepayment_PVT.Get_Pay_Now_Amounts... returning zero');
8038: END IF;
8039: RETURN 0;

Line 8081: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8077: WHEN OTHERS THEN
8078: IF l_debug_level > 0 THEN
8079: oe_debug_pub.add( 'FROM OUTBOUND TOTAL OTHERS: ' || SQLERRM ) ;
8080: END IF;
8081: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8082:
8083: END Outbound_Order_Total;
8084:
8085: --bug3225795 end

Line 8123: p_return_status := FND_API.G_RET_STS_SUCCESS;

8119:
8120:
8121: SAVEPOINT Update_AuthInfo_for_MultiPmnts;
8122:
8123: p_return_status := FND_API.G_RET_STS_SUCCESS;
8124:
8125: IF l_debug_level > 0 THEN
8126: oe_debug_pub.add( 'OEXPVPMB: IN UPDATE AUTHORIZATION INFORMATION' ) ;
8127: END IF;

Line 8137: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

8133: ,p_payment_number => null
8134: ,p_x_Header_Payment_rec => l_old_Header_Payment_rec
8135: ,x_return_status => l_return_status
8136: );
8137: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
8138: RAISE FND_API.G_EXC_ERROR;
8139: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8141: END IF;

Line 8138: RAISE FND_API.G_EXC_ERROR;

8134: ,p_x_Header_Payment_rec => l_old_Header_Payment_rec
8135: ,x_return_status => l_return_status
8136: );
8137: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
8138: RAISE FND_API.G_EXC_ERROR;
8139: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8141: END IF;
8142:

Line 8139: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

8135: ,x_return_status => l_return_status
8136: );
8137: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
8138: RAISE FND_API.G_EXC_ERROR;
8139: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8141: END IF;
8142:
8143: l_Line_Payment_rec := l_old_Line_Payment_rec;

Line 8140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8136: );
8137: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
8138: RAISE FND_API.G_EXC_ERROR;
8139: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8141: END IF;
8142:
8143: l_Line_Payment_rec := l_old_Line_Payment_rec;
8144:

Line 8254: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

8250: IF l_debug_level > 0 THEN
8251: oe_debug_pub.add( 'GLOBAL HDR CC APPROVAL_DATE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.CREDIT_CARD_APPROVAL_DATE , 1 ) ;
8252: END IF;
8253:
8254: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
8255: RAISE FND_API.G_EXC_ERROR;
8256: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8258: END IF;

Line 8255: RAISE FND_API.G_EXC_ERROR;

8251: oe_debug_pub.add( 'GLOBAL HDR CC APPROVAL_DATE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.CREDIT_CARD_APPROVAL_DATE , 1 ) ;
8252: END IF;
8253:
8254: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
8255: RAISE FND_API.G_EXC_ERROR;
8256: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8258: END IF;
8259:

Line 8256: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

8252: END IF;
8253:
8254: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
8255: RAISE FND_API.G_EXC_ERROR;
8256: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8258: END IF;
8259:
8260: -- Process requests is TRUE so still need to call it, but don't need to notify

Line 8257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8253:
8254: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
8255: RAISE FND_API.G_EXC_ERROR;
8256: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8258: END IF;
8259:
8260: -- Process requests is TRUE so still need to call it, but don't need to notify
8261: IF l_debug_level > 0 THEN

Line 8272: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

8268: , p_old_header_rec => l_old_header_rec
8269: , x_return_status => l_return_status
8270: );
8271:
8272: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
8273: RAISE FND_API.G_EXC_ERROR;
8274: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8276: END IF;

Line 8273: RAISE FND_API.G_EXC_ERROR;

8269: , x_return_status => l_return_status
8270: );
8271:
8272: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
8273: RAISE FND_API.G_EXC_ERROR;
8274: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8276: END IF;
8277:

Line 8274: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

8270: );
8271:
8272: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
8273: RAISE FND_API.G_EXC_ERROR;
8274: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8276: END IF;
8277:
8278: END IF ; -- global entity index null check

Line 8275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8271:
8272: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
8273: RAISE FND_API.G_EXC_ERROR;
8274: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8276: END IF;
8277:
8278: END IF ; -- global entity index null check
8279:

Line 8293: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

8289: , p_old_header_rec => l_old_header_rec
8290: , x_return_status => l_return_status
8291: );
8292:
8293: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
8294: RAISE FND_API.G_EXC_ERROR;
8295: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8296: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8297: END IF;

Line 8294: RAISE FND_API.G_EXC_ERROR;

8290: , x_return_status => l_return_status
8291: );
8292:
8293: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
8294: RAISE FND_API.G_EXC_ERROR;
8295: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8296: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8297: END IF;
8298:

Line 8295: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

8291: );
8292:
8293: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
8294: RAISE FND_API.G_EXC_ERROR;
8295: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8296: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8297: END IF;
8298:
8299: -- notification framework end

Line 8296: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8292:
8293: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
8294: RAISE FND_API.G_EXC_ERROR;
8295: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8296: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8297: END IF;
8298:
8299: -- notification framework end
8300: END IF; -- code set is pack H or higher

Line 8305: WHEN FND_API.G_EXC_ERROR THEN

8301: -- end of code commented out for Multiple Payments Project */
8302:
8303: EXCEPTION
8304:
8305: WHEN FND_API.G_EXC_ERROR THEN
8306: ROLLBACK TO Update_AuthInfo_for_MultiPmnts;
8307: p_return_status := FND_API.G_RET_STS_ERROR;
8308: OE_MSG_PUB.Count_And_Get
8309: ( p_count => l_msg_count,

Line 8307: p_return_status := FND_API.G_RET_STS_ERROR;

8303: EXCEPTION
8304:
8305: WHEN FND_API.G_EXC_ERROR THEN
8306: ROLLBACK TO Update_AuthInfo_for_MultiPmnts;
8307: p_return_status := FND_API.G_RET_STS_ERROR;
8308: OE_MSG_PUB.Count_And_Get
8309: ( p_count => l_msg_count,
8310: p_data => l_msg_data
8311: );

Line 8313: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

8309: ( p_count => l_msg_count,
8310: p_data => l_msg_data
8311: );
8312:
8313: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8314: ROLLBACK TO Update_AuthInfo_for_MultiPmnts;
8315: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8316: OE_MSG_PUB.Count_And_Get
8317: ( p_count => l_msg_count,

Line 8315: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8311: );
8312:
8313: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8314: ROLLBACK TO Update_AuthInfo_for_MultiPmnts;
8315: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8316: OE_MSG_PUB.Count_And_Get
8317: ( p_count => l_msg_count,
8318: p_data => l_msg_data
8319: );

Line 8323: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8319: );
8320:
8321: WHEN OTHERS THEN
8322: ROLLBACK TO Update_AuthInfo_for_MultiPmnts;
8323: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8324:
8325: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8326: THEN
8327: FND_MSG_PUB.Add_Exc_Msg

Line 8361: p_return_status := FND_API.G_RET_STS_SUCCESS;

8357: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
8358:
8359: BEGIN
8360:
8361: p_return_status := FND_API.G_RET_STS_SUCCESS;
8362: IF l_debug_level > 0 THEN
8363: oe_debug_pub.add( 'OEXPVPMB: IN RELEASE VERIFY LINE HOLD' ) ;
8364: END IF;
8365:

Line 8396: IF l_hold_result = FND_API.G_TRUE THEN

8392: , x_return_status => l_return_status
8393: );
8394:
8395: -- Check the Result
8396: IF l_hold_result = FND_API.G_TRUE THEN
8397:
8398: IF l_debug_level > 0 THEN
8399: oe_debug_pub.add( 'OEXPVPMB: RELEASING CC FAILURE HOLD ON ORDER HEADER ID:' || p_header_id ) ;
8400: END IF;

Line 8418: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

8414: , x_msg_data => l_msg_data
8415: , x_return_status => l_return_status
8416: );
8417:
8418: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
8419: RAISE FND_API.G_EXC_ERROR;
8420: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8422: END IF;

Line 8419: RAISE FND_API.G_EXC_ERROR;

8415: , x_return_status => l_return_status
8416: );
8417:
8418: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
8419: RAISE FND_API.G_EXC_ERROR;
8420: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8422: END IF;
8423:

Line 8420: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

8416: );
8417:
8418: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
8419: RAISE FND_API.G_EXC_ERROR;
8420: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8422: END IF;
8423:
8424: END IF; -- Do nothing if the hold has already been released.

Line 8421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8417:
8418: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
8419: RAISE FND_API.G_EXC_ERROR;
8420: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8422: END IF;
8423:
8424: END IF; -- Do nothing if the hold has already been released.
8425:

Line 8452: IF l_hold_result = FND_API.G_TRUE THEN

8448: , x_return_status => l_return_status
8449: );
8450:
8451: -- Check the Result
8452: IF l_hold_result = FND_API.G_TRUE THEN
8453:
8454: IF l_debug_level > 0 THEN
8455: oe_debug_pub.add( 'OEXPVPMB: RELEASING CC RISK HOLD ON ORDER LINE ID:' || p_line_id ) ;
8456: END IF;

Line 8473: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

8469: , x_msg_data => l_msg_data
8470: , x_return_status => l_return_status
8471: );
8472:
8473: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
8474: RAISE FND_API.G_EXC_ERROR;
8475: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8477: END IF;

Line 8474: RAISE FND_API.G_EXC_ERROR;

8470: , x_return_status => l_return_status
8471: );
8472:
8473: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
8474: RAISE FND_API.G_EXC_ERROR;
8475: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8477: END IF;
8478:

Line 8475: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

8471: );
8472:
8473: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
8474: RAISE FND_API.G_EXC_ERROR;
8475: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8477: END IF;
8478:
8479: END IF; -- Do nothing if the hold has already been released.

Line 8476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8472:
8473: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
8474: RAISE FND_API.G_EXC_ERROR;
8475: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8477: END IF;
8478:
8479: END IF; -- Do nothing if the hold has already been released.
8480:

Line 8507: IF l_hold_result = FND_API.G_TRUE THEN

8503: , x_return_status => l_return_status
8504: );
8505:
8506: -- Check the Result
8507: IF l_hold_result = FND_API.G_TRUE THEN
8508:
8509: IF l_debug_level > 0 THEN
8510: oe_debug_pub.add( 'OEXPVPMB: RELEASING CC RISK HOLD ON ORDER LINE ID:' || p_line_id ) ;
8511: END IF;

Line 8528: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

8524: , x_msg_data => l_msg_data
8525: , x_return_status => l_return_status
8526: );
8527:
8528: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
8529: RAISE FND_API.G_EXC_ERROR;
8530: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8532: END IF;

Line 8529: RAISE FND_API.G_EXC_ERROR;

8525: , x_return_status => l_return_status
8526: );
8527:
8528: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
8529: RAISE FND_API.G_EXC_ERROR;
8530: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8532: END IF;
8533:

Line 8530: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

8526: );
8527:
8528: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
8529: RAISE FND_API.G_EXC_ERROR;
8530: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8532: END IF;
8533:
8534: END IF; -- Do nothing if the hold has already been released.

Line 8531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8527:
8528: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
8529: RAISE FND_API.G_EXC_ERROR;
8530: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8532: END IF;
8533:
8534: END IF; -- Do nothing if the hold has already been released.
8535: END IF;

Line 8541: WHEN FND_API.G_EXC_ERROR THEN

8537: END IF; -- Electronic Payment
8538:
8539: EXCEPTION
8540:
8541: WHEN FND_API.G_EXC_ERROR THEN
8542: p_return_status := FND_API.G_RET_STS_ERROR;
8543: OE_MSG_PUB.Count_And_Get
8544: ( p_count => l_msg_count,
8545: p_data => l_msg_data

Line 8542: p_return_status := FND_API.G_RET_STS_ERROR;

8538:
8539: EXCEPTION
8540:
8541: WHEN FND_API.G_EXC_ERROR THEN
8542: p_return_status := FND_API.G_RET_STS_ERROR;
8543: OE_MSG_PUB.Count_And_Get
8544: ( p_count => l_msg_count,
8545: p_data => l_msg_data
8546: );

Line 8548: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

8544: ( p_count => l_msg_count,
8545: p_data => l_msg_data
8546: );
8547:
8548: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8549: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8550: OE_MSG_PUB.Count_And_Get
8551: ( p_count => l_msg_count,
8552: p_data => l_msg_data

Line 8549: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8545: p_data => l_msg_data
8546: );
8547:
8548: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8549: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8550: OE_MSG_PUB.Count_And_Get
8551: ( p_count => l_msg_count,
8552: p_data => l_msg_data
8553: );

Line 8556: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8552: p_data => l_msg_data
8553: );
8554:
8555: WHEN OTHERS THEN
8556: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8557: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8558: THEN
8559: FND_MSG_PUB.Add_Exc_Msg
8560: ( G_PKG_NAME

Line 8602: p_return_status := FND_API.G_RET_STS_SUCCESS;

8598: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
8599:
8600: BEGIN
8601:
8602: p_return_status := FND_API.G_RET_STS_SUCCESS;
8603:
8604: IF l_debug_level > 0 THEN
8605: oe_debug_pub.add( 'OEXPVPMB: IN APPLY VERIFY LINE HOLDS' ) ;
8606: END IF;

Line 8634: IF l_hold_result = FND_API.G_TRUE THEN

8630: , x_return_status => l_return_status
8631: );
8632:
8633: -- Return with Success if this Hold Already exists on the order
8634: IF l_hold_result = FND_API.G_TRUE THEN
8635: IF l_debug_level > 0 THEN
8636: oe_debug_pub.add( 'OEXPVPMB: HOLD ALREADY APPLIED ON LINE ID : ' || P_LINE_ID ) ;
8637: END IF;
8638: RETURN ;

Line 8653: , p_validation_level => FND_API.G_VALID_LEVEL_NONE

8649: l_hold_source_rec.line_id := p_line_id;
8650:
8651: OE_Holds_PUB.Apply_Holds
8652: ( p_api_version => 1.0
8653: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
8654: , p_hold_source_rec => l_hold_source_rec
8655: , x_msg_count => l_msg_count
8656: , x_msg_data => l_msg_data
8657: , x_return_status => l_return_status

Line 8660: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

8656: , x_msg_data => l_msg_data
8657: , x_return_status => l_return_status
8658: );
8659:
8660: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
8661: IF p_hold_id = 16 THEN
8662:
8663: BEGIN
8664: SELECT line_number,

Line 8693: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

8689: IF l_debug_level > 0 THEN
8690: oe_debug_pub.add( 'OEXVPPYB: Pending Payment Authorization hold has been applied on order line.', 3);
8691: END IF;
8692: END IF;
8693: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
8694: RAISE FND_API.G_EXC_ERROR;
8695: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8697: END IF;

Line 8694: RAISE FND_API.G_EXC_ERROR;

8690: oe_debug_pub.add( 'OEXVPPYB: Pending Payment Authorization hold has been applied on order line.', 3);
8691: END IF;
8692: END IF;
8693: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
8694: RAISE FND_API.G_EXC_ERROR;
8695: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8697: END IF;
8698:

Line 8695: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

8691: END IF;
8692: END IF;
8693: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
8694: RAISE FND_API.G_EXC_ERROR;
8695: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8697: END IF;
8698:
8699: IF l_debug_level > 0 THEN

Line 8696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8692: END IF;
8693: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
8694: RAISE FND_API.G_EXC_ERROR;
8695: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8697: END IF;
8698:
8699: IF l_debug_level > 0 THEN
8700: oe_debug_pub.add( 'OEXPVPMB: APPLIED VERIFY HOLD ON LINE ID:' || P_LINE_ID ) ;

Line 8705: WHEN FND_API.G_EXC_ERROR THEN

8701: END IF;
8702:
8703: EXCEPTION
8704:
8705: WHEN FND_API.G_EXC_ERROR THEN
8706: p_return_status := FND_API.G_RET_STS_ERROR;
8707: OE_MSG_PUB.Count_And_Get
8708: ( p_count => l_msg_count,
8709: p_data => l_msg_data

Line 8706: p_return_status := FND_API.G_RET_STS_ERROR;

8702:
8703: EXCEPTION
8704:
8705: WHEN FND_API.G_EXC_ERROR THEN
8706: p_return_status := FND_API.G_RET_STS_ERROR;
8707: OE_MSG_PUB.Count_And_Get
8708: ( p_count => l_msg_count,
8709: p_data => l_msg_data
8710: );

Line 8712: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

8708: ( p_count => l_msg_count,
8709: p_data => l_msg_data
8710: );
8711:
8712: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8713: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8714: OE_MSG_PUB.Count_And_Get
8715: ( p_count => l_msg_count,
8716: p_data => l_msg_data

Line 8713: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8709: p_data => l_msg_data
8710: );
8711:
8712: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8713: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8714: OE_MSG_PUB.Count_And_Get
8715: ( p_count => l_msg_count,
8716: p_data => l_msg_data
8717: );

Line 8720: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8716: p_data => l_msg_data
8717: );
8718:
8719: WHEN OTHERS THEN
8720: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8721: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8722: THEN
8723: FND_MSG_PUB.Add_Exc_Msg
8724: ( G_PKG_NAME

Line 8796: l_return_status := FND_API.G_RET_STS_SUCCESS;

8792: --
8793:
8794: BEGIN
8795:
8796: l_return_status := FND_API.G_RET_STS_SUCCESS;
8797:
8798: IF l_debug_level > 0 THEN
8799: oe_debug_pub.add( 'Entering Create_New_Payment_Trxn.', 1 ) ;
8800: END IF;

Line 8835: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

8831: P_payer => l_payer,
8832: X_trxn_attribs => l_trxn_attribs,
8833: X_response => l_response_code);
8834:
8835: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
8836: IF l_debug_level > 0 THEN
8837: oe_debug_pub.add('Result error code in Get_Transaction_Extension'||l_response_code.result_code);
8838: END IF;
8839: RAISE FND_API.G_EXC_ERROR;

Line 8839: RAISE FND_API.G_EXC_ERROR;

8835: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
8836: IF l_debug_level > 0 THEN
8837: oe_debug_pub.add('Result error code in Get_Transaction_Extension'||l_response_code.result_code);
8838: END IF;
8839: RAISE FND_API.G_EXC_ERROR;
8840: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8841: IF l_debug_level > 0 THEN
8842: oe_debug_pub.add('Result error code in Get_Transaction_Extension'||l_response_code.result_code);
8843: END IF;

Line 8840: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

8836: IF l_debug_level > 0 THEN
8837: oe_debug_pub.add('Result error code in Get_Transaction_Extension'||l_response_code.result_code);
8838: END IF;
8839: RAISE FND_API.G_EXC_ERROR;
8840: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8841: IF l_debug_level > 0 THEN
8842: oe_debug_pub.add('Result error code in Get_Transaction_Extension'||l_response_code.result_code);
8843: END IF;
8844: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8844: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8840: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8841: IF l_debug_level > 0 THEN
8842: oe_debug_pub.add('Result error code in Get_Transaction_Extension'||l_response_code.result_code);
8843: END IF;
8844: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8845: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
8846: IF l_debug_level > 0 THEN
8847: oe_debug_pub.add('Get_Transaction_Extension assignment Successful....');
8848: oe_debug_pub.add('After call to Get Transaction Extension'||l_return_status);

Line 8845: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN

8841: IF l_debug_level > 0 THEN
8842: oe_debug_pub.add('Result error code in Get_Transaction_Extension'||l_response_code.result_code);
8843: END IF;
8844: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8845: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
8846: IF l_debug_level > 0 THEN
8847: oe_debug_pub.add('Get_Transaction_Extension assignment Successful....');
8848: oe_debug_pub.add('After call to Get Transaction Extension'||l_return_status);
8849: oe_debug_pub.add('After call to get trxn...instr sec code'||l_trxn_attribs.instrument_security_code);

Line 8905: OE_GLOBALS.Equal(l_trxn_attribs.Instrument_Security_Code,FND_API.G_MISS_CHAR))

8901:
8902: --bug 5028932
8903: IF Oe_Payment_Trxn_Util.Get_CC_Security_Code_Use = 'REQUIRED'
8904: AND (l_trxn_attribs.Instrument_Security_Code IS NULL OR
8905: OE_GLOBALS.Equal(l_trxn_attribs.Instrument_Security_Code,FND_API.G_MISS_CHAR))
8906: THEN
8907: IF p_instrument_security_code IS NOT NULL AND
8908: NOT OE_GLOBALS.Equal(p_instrument_security_code,FND_API.G_MISS_CHAR) THEN
8909: l_trxn_attribs.Instrument_Security_Code := p_instrument_security_code;

Line 8908: NOT OE_GLOBALS.Equal(p_instrument_security_code,FND_API.G_MISS_CHAR) THEN

8904: AND (l_trxn_attribs.Instrument_Security_Code IS NULL OR
8905: OE_GLOBALS.Equal(l_trxn_attribs.Instrument_Security_Code,FND_API.G_MISS_CHAR))
8906: THEN
8907: IF p_instrument_security_code IS NOT NULL AND
8908: NOT OE_GLOBALS.Equal(p_instrument_security_code,FND_API.G_MISS_CHAR) THEN
8909: l_trxn_attribs.Instrument_Security_Code := p_instrument_security_code;
8910: ELSE
8911: FND_MESSAGE.SET_NAME('ONT','OE_CC_SECURITY_CODE_REQD');
8912: OE_Msg_Pub.Add;

Line 8913: RAISE FND_API.G_EXC_ERROR;

8909: l_trxn_attribs.Instrument_Security_Code := p_instrument_security_code;
8910: ELSE
8911: FND_MESSAGE.SET_NAME('ONT','OE_CC_SECURITY_CODE_REQD');
8912: OE_Msg_Pub.Add;
8913: RAISE FND_API.G_EXC_ERROR;
8914: END IF;
8915: END IF;
8916: --bug 5028932
8917:

Line 8921: p_init_msg_list => FND_API.G_TRUE,

8917:
8918: -- create new payment transaction extension id
8919: IBY_Fndcpt_Trxn_Pub.Create_Transaction_Extension
8920: (p_api_version => 1.0,
8921: p_init_msg_list => FND_API.G_TRUE,
8922: p_commit => FND_API.G_FALSE,
8923: X_return_status => l_return_status,
8924: X_msg_count => l_msg_count,
8925: X_msg_data => l_msg_data,

Line 8922: p_commit => FND_API.G_FALSE,

8918: -- create new payment transaction extension id
8919: IBY_Fndcpt_Trxn_Pub.Create_Transaction_Extension
8920: (p_api_version => 1.0,
8921: p_init_msg_list => FND_API.G_TRUE,
8922: p_commit => FND_API.G_FALSE,
8923: X_return_status => l_return_status,
8924: X_msg_count => l_msg_count,
8925: X_msg_data => l_msg_data,
8926: P_payer => l_payer,

Line 8940: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

8936: oe_debug_pub.add('Result code'||l_Response_code.result_code);
8937: oe_debug_pub.add('Return status'||l_Return_Status);
8938: END IF;
8939:
8940: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
8941: IF l_debug_level > 0 THEN
8942: oe_debug_pub.add('Result error code in Create_Transaction_Extension'||l_response_code.result_code);
8943: END IF;
8944: RAISE FND_API.G_EXC_ERROR;

Line 8944: RAISE FND_API.G_EXC_ERROR;

8940: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
8941: IF l_debug_level > 0 THEN
8942: oe_debug_pub.add('Result error code in Create_Transaction_Extension'||l_response_code.result_code);
8943: END IF;
8944: RAISE FND_API.G_EXC_ERROR;
8945: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8946: IF l_debug_level > 0 THEN
8947: oe_debug_pub.add('Result error code in Create_Transaction_Extension'||l_response_code.result_code);
8948: END IF;

Line 8945: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

8941: IF l_debug_level > 0 THEN
8942: oe_debug_pub.add('Result error code in Create_Transaction_Extension'||l_response_code.result_code);
8943: END IF;
8944: RAISE FND_API.G_EXC_ERROR;
8945: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8946: IF l_debug_level > 0 THEN
8947: oe_debug_pub.add('Result error code in Create_Transaction_Extension'||l_response_code.result_code);
8948: END IF;
8949: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8949: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8945: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8946: IF l_debug_level > 0 THEN
8947: oe_debug_pub.add('Result error code in Create_Transaction_Extension'||l_response_code.result_code);
8948: END IF;
8949: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8950: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
8951: IF l_debug_level > 0 THEN
8952: oe_debug_pub.add('Create_Transaction_Extension assignment Successful....');
8953: oe_debug_pub.add('After call to Create_Transaction_Extension'||l_return_status);

Line 8950: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN

8946: IF l_debug_level > 0 THEN
8947: oe_debug_pub.add('Result error code in Create_Transaction_Extension'||l_response_code.result_code);
8948: END IF;
8949: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8950: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
8951: IF l_debug_level > 0 THEN
8952: oe_debug_pub.add('Create_Transaction_Extension assignment Successful....');
8953: oe_debug_pub.add('After call to Create_Transaction_Extension'||l_return_status);
8954: oe_debug_pub.add('New trxn extension id'||x_trxn_extension_id);

Line 8966: WHEN FND_API.G_EXC_ERROR THEN

8962: END IF;
8963:
8964: EXCEPTION
8965:
8966: WHEN FND_API.G_EXC_ERROR THEN
8967:
8968: X_return_status := FND_API.G_RET_STS_ERROR;
8969: OE_MSG_PUB.Count_And_Get
8970: ( p_count => l_msg_count,

Line 8968: X_return_status := FND_API.G_RET_STS_ERROR;

8964: EXCEPTION
8965:
8966: WHEN FND_API.G_EXC_ERROR THEN
8967:
8968: X_return_status := FND_API.G_RET_STS_ERROR;
8969: OE_MSG_PUB.Count_And_Get
8970: ( p_count => l_msg_count,
8971: p_data => l_msg_data
8972: );

Line 8973: RAISE FND_API.G_EXC_ERROR;

8969: OE_MSG_PUB.Count_And_Get
8970: ( p_count => l_msg_count,
8971: p_data => l_msg_data
8972: );
8973: RAISE FND_API.G_EXC_ERROR;
8974:
8975: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8976:
8977: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 8975: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

8971: p_data => l_msg_data
8972: );
8973: RAISE FND_API.G_EXC_ERROR;
8974:
8975: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8976:
8977: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8978: OE_MSG_PUB.Count_And_Get
8979: ( p_count => l_msg_count,

Line 8977: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8973: RAISE FND_API.G_EXC_ERROR;
8974:
8975: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8976:
8977: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8978: OE_MSG_PUB.Count_And_Get
8979: ( p_count => l_msg_count,
8980: p_data => l_msg_data
8981: );

Line 8982: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8978: OE_MSG_PUB.Count_And_Get
8979: ( p_count => l_msg_count,
8980: p_data => l_msg_data
8981: );
8982: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8983:
8984: WHEN OTHERS THEN
8985:
8986: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 8986: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8982: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8983:
8984: WHEN OTHERS THEN
8985:
8986: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8987: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8988: THEN
8989: FND_MSG_PUB.Add_Exc_Msg
8990: ( G_PKG_NAME

Line 8999: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8995: OE_MSG_PUB.Count_And_Get
8996: ( p_count => l_msg_count,
8997: p_data => l_msg_data
8998: );
8999: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9000:
9001:
9002: END Create_New_Payment_Trxn;
9003: