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

Line 127: AND NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) =

123: -- In other words, it will not check if the order is updated
124:
125: -- Adding 'AUTO HOLD' for bug# 4207478
126: IF p_calling_action IN ('SHIPPING', 'PACKING' , 'PICKING', 'AUTO HOLD')
127: AND NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) =
128: FND_API.G_FALSE
129: THEN
130:
131: BEGIN

Line 128: FND_API.G_FALSE

124:
125: -- Adding 'AUTO HOLD' for bug# 4207478
126: IF p_calling_action IN ('SHIPPING', 'PACKING' , 'PICKING', 'AUTO HOLD')
127: AND NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) =
128: FND_API.G_FALSE
129: THEN
130:
131: BEGIN
132: SELECT /* MOAC_SQL_CHANGE */ NVL(MAX(H.HOLD_RELEASE_ID),0)

Line 234: l_hold_result := FND_API.G_TRUE ;

230: END IF;
231:
232: IF g_hold_exist = 'Y'
233: THEN
234: l_hold_result := FND_API.G_TRUE ;
235: ELSIF g_hold_exist = 'N'
236: THEN
237: l_hold_result := 'F' ;
238: ELSE

Line 265: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

261: OE_DEBUG_PUB.ADD('OEXVCRHB: Out Check_Holds ');
262: OE_DEBUG_PUB.ADD('l_return_status = '|| l_return_status );
263: END IF;
264:
265: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
266: RAISE FND_API.G_EXC_ERROR;
267: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
268: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
269: END IF;

Line 266: RAISE FND_API.G_EXC_ERROR;

262: OE_DEBUG_PUB.ADD('l_return_status = '|| l_return_status );
263: END IF;
264:
265: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
266: RAISE FND_API.G_EXC_ERROR;
267: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
268: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
269: END IF;
270:

Line 267: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

263: END IF;
264:
265: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
266: RAISE FND_API.G_EXC_ERROR;
267: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
268: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
269: END IF;
270:
271: END IF; -- g_hold_exist

Line 268: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

264:
265: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
266: RAISE FND_API.G_EXC_ERROR;
267: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
268: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
269: END IF;
270:
271: END IF; -- g_hold_exist
272:

Line 279: IF l_hold_result = FND_API.G_TRUE THEN

275: OE_DEBUG_PUB.ADD('OEXVCRHB: about to Hold_Exists');
276: OE_DEBUG_PUB.ADD('l_hold_result => '|| l_hold_result );
277: END IF;
278:
279: IF l_hold_result = FND_API.G_TRUE THEN
280: return TRUE;
281: ELSE
282: return FALSE;
283: END IF;

Line 534: , p_validation_level => FND_API.G_VALID_LEVEL_NONE

530:
531:
532: OE_Holds_PUB.Apply_Holds
533: ( p_api_version => 1.0
534: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
535: , p_hold_source_rec => p_hold_source_rec
536: , x_msg_count => x_msg_count
537: , x_msg_data => x_msg_data
538: , x_return_status => x_return_status

Line 544: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

540:
541: OE_DEBUG_PUB.ADD(' Out OE_Holds_PUB.Apply_Holds ');
542: OE_DEBUG_PUB.ADD(' x_return_status => '|| x_return_status );
543:
544: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
545: RAISE FND_API.G_EXC_ERROR;
546: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
548: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 545: RAISE FND_API.G_EXC_ERROR;

541: OE_DEBUG_PUB.ADD(' Out OE_Holds_PUB.Apply_Holds ');
542: OE_DEBUG_PUB.ADD(' x_return_status => '|| x_return_status );
543:
544: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
545: RAISE FND_API.G_EXC_ERROR;
546: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
548: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
549:

Line 546: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

542: OE_DEBUG_PUB.ADD(' x_return_status => '|| x_return_status );
543:
544: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
545: RAISE FND_API.G_EXC_ERROR;
546: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
548: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
549:
550: OE_DEBUG_PUB.ADD(' Holds success ');

Line 547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

543:
544: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
545: RAISE FND_API.G_EXC_ERROR;
546: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
548: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
549:
550: OE_DEBUG_PUB.ADD(' Holds success ');
551: OE_DEBUG_PUB.ADD(' About to Issue COMMIT');

Line 548: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

544: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
545: RAISE FND_API.G_EXC_ERROR;
546: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
548: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
549:
550: OE_DEBUG_PUB.ADD(' Holds success ');
551: OE_DEBUG_PUB.ADD(' About to Issue COMMIT');
552:

Line 607: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

603: OE_DEBUG_PUB.ADD('OEXVCRHB: After OE_Holds_PUB.Update_Hold_Comments Status '
604: || x_return_status);
605: END IF;
606:
607: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
608: RAISE FND_API.G_EXC_ERROR;
609: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
611: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 608: RAISE FND_API.G_EXC_ERROR;

604: || x_return_status);
605: END IF;
606:
607: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
608: RAISE FND_API.G_EXC_ERROR;
609: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
611: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
612: IF G_debug_flag = 'Y'

Line 609: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

605: END IF;
606:
607: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
608: RAISE FND_API.G_EXC_ERROR;
609: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
611: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
612: IF G_debug_flag = 'Y'
613: THEN

Line 610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

606:
607: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
608: RAISE FND_API.G_EXC_ERROR;
609: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
611: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
612: IF G_debug_flag = 'Y'
613: THEN
614: OE_DEBUG_PUB.ADD('OEXVCRHB: Update Hold Comment Success, Issue COMMIT');

Line 611: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

607: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
608: RAISE FND_API.G_EXC_ERROR;
609: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
611: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
612: IF G_debug_flag = 'Y'
613: THEN
614: OE_DEBUG_PUB.ADD('OEXVCRHB: Update Hold Comment Success, Issue COMMIT');
615: END IF;

Line 769: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

765: OE_DEBUG_PUB.ADD('OEXVCRHB: Out OE_Holds_PUB.Update_Hold_Comments directly');
766: END IF;
767: END IF; -- Calling Action
768:
769: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
770: RAISE FND_API.G_EXC_ERROR;
771: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
773: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 770: RAISE FND_API.G_EXC_ERROR;

766: END IF;
767: END IF; -- Calling Action
768:
769: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
770: RAISE FND_API.G_EXC_ERROR;
771: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
773: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
774: IF G_debug_flag = 'Y'

Line 771: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

767: END IF; -- Calling Action
768:
769: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
770: RAISE FND_API.G_EXC_ERROR;
771: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
773: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
774: IF G_debug_flag = 'Y'
775: THEN

Line 772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

768:
769: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
770: RAISE FND_API.G_EXC_ERROR;
771: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
773: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
774: IF G_debug_flag = 'Y'
775: THEN
776: OE_DEBUG_PUB.ADD('OEXVCRHB: Updated Comments on Header ID:'

Line 773: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

769: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
770: RAISE FND_API.G_EXC_ERROR;
771: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
773: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
774: IF G_debug_flag = 'Y'
775: THEN
776: OE_DEBUG_PUB.ADD('OEXVCRHB: Updated Comments on Header ID:'
777: ||p_header_id, 1);

Line 838: , p_validation_level => FND_API.G_VALID_LEVEL_NONE

834:
835:
836: OE_Holds_PUB.Apply_Holds
837: ( p_api_version => 1.0
838: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
839: , p_hold_source_rec => l_hold_source_rec
840: , x_msg_count => l_msg_count
841: , x_msg_data => l_msg_data
842: , x_return_status => l_return_status

Line 851: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

847: END IF;
848: END IF; --check calling action
849:
850:
851: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
852: RAISE FND_API.G_EXC_ERROR;
853: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
854: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
855: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 852: RAISE FND_API.G_EXC_ERROR;

848: END IF; --check calling action
849:
850:
851: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
852: RAISE FND_API.G_EXC_ERROR;
853: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
854: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
855: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
856: IF G_debug_flag = 'Y' THEN

Line 853: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

849:
850:
851: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
852: RAISE FND_API.G_EXC_ERROR;
853: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
854: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
855: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
856: IF G_debug_flag = 'Y' THEN
857: OE_DEBUG_PUB.ADD('OEXVCRHB: Credit check hold applied header_ID: '

Line 854: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

850:
851: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
852: RAISE FND_API.G_EXC_ERROR;
853: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
854: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
855: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
856: IF G_debug_flag = 'Y' THEN
857: OE_DEBUG_PUB.ADD('OEXVCRHB: Credit check hold applied header_ID: '
858: ||p_header_id, 1);

Line 855: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

851: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
852: RAISE FND_API.G_EXC_ERROR;
853: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
854: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
855: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
856: IF G_debug_flag = 'Y' THEN
857: OE_DEBUG_PUB.ADD('OEXVCRHB: Credit check hold applied header_ID: '
858: ||p_header_id, 1);
859: END IF;

Line 920: l_return_status := FND_API.G_RET_STS_SUCCESS;

916: THEN
917: OE_DEBUG_PUB.Add('OEXVCRHB: In Release_Order_CC_Hold',1);
918: END IF;
919:
920: l_return_status := FND_API.G_RET_STS_SUCCESS;
921:
922: IF G_debug_flag = 'Y'
923: THEN
924: OE_DEBUG_PUB.Add('Check if Holds exist to release ');

Line 969: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

965: , x_msg_count => l_msg_count
966: , x_msg_data => l_msg_data
967: , x_return_status => l_return_status
968: );
969: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
970: RAISE FND_API.G_EXC_ERROR;
971: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
972: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
973: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN

Line 970: RAISE FND_API.G_EXC_ERROR;

966: , x_msg_data => l_msg_data
967: , x_return_status => l_return_status
968: );
969: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
970: RAISE FND_API.G_EXC_ERROR;
971: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
972: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
973: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
974: Write_Order_Release_Msg(

Line 971: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

967: , x_return_status => l_return_status
968: );
969: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
970: RAISE FND_API.G_EXC_ERROR;
971: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
972: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
973: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
974: Write_Order_Release_Msg(
975: p_calling_action => p_calling_action

Line 972: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

968: );
969: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
970: RAISE FND_API.G_EXC_ERROR;
971: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
972: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
973: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
974: Write_Order_Release_Msg(
975: p_calling_action => p_calling_action
976: , p_order_number => p_order_number

Line 973: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN

969: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
970: RAISE FND_API.G_EXC_ERROR;
971: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
972: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
973: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
974: Write_Order_Release_Msg(
975: p_calling_action => p_calling_action
976: , p_order_number => p_order_number
977: );

Line 1038: x_return_status := FND_API.G_RET_STS_SUCCESS;

1034: OE_DEBUG_PUB.ADD('Call Get_Past_Due_Invoice ');
1035: END IF;
1036:
1037: -- Initialize return status to success
1038: x_return_status := FND_API.G_RET_STS_SUCCESS;
1039: -- Default to pass
1040: x_cc_result_out := 'PASS';
1041:
1042:

Line 1066: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1062: OE_DEBUG_PUB.ADD(' x_return_status = '|| x_return_status);
1063: OE_DEBUG_PUB.ADD(' l_exist_flag = '|| l_exist_flag );
1064: END IF;
1065:
1066: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1067: RAISE FND_API.G_EXC_ERROR;
1068: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1069: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1070: END IF;

Line 1067: RAISE FND_API.G_EXC_ERROR;

1063: OE_DEBUG_PUB.ADD(' l_exist_flag = '|| l_exist_flag );
1064: END IF;
1065:
1066: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1067: RAISE FND_API.G_EXC_ERROR;
1068: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1069: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1070: END IF;
1071:

Line 1068: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1064: END IF;
1065:
1066: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1067: RAISE FND_API.G_EXC_ERROR;
1068: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1069: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1070: END IF;
1071:
1072:

Line 1069: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1065:
1066: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1067: RAISE FND_API.G_EXC_ERROR;
1068: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1069: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1070: END IF;
1071:
1072:
1073: IF l_exist_flag = 'Y'

Line 1085: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1081: OE_DEBUG_PUB.ADD('OEXVCRHB: Out Chk_Past_Due_Invoice');
1082: END IF;
1083: EXCEPTION
1084: WHEN OTHERS THEN
1085: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1086: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1087: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Chk_Past_Due_invoice');
1088: END IF;
1089: END Chk_Past_Due_Invoice;

Line 1125: x_return_status := FND_API.G_RET_STS_SUCCESS;

1121: OE_DEBUG_PUB.ADD('OEXVCRHB: In Check_Trx_Limit');
1122: END IF;
1123:
1124: -- Initialize return status to success
1125: x_return_status := FND_API.G_RET_STS_SUCCESS;
1126: -- Default to Pass
1127: x_cc_result_out := 'PASS';
1128:
1129: ----------------------------------------------

Line 1225: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1221: OE_DEBUG_PUB.ADD(' p_trx_credit_limit = '|| p_trx_credit_limit );
1222: END IF;
1223:
1224:
1225: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1226: RAISE FND_API.G_EXC_ERROR;
1227: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1229: END IF;

Line 1226: RAISE FND_API.G_EXC_ERROR;

1222: END IF;
1223:
1224:
1225: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1226: RAISE FND_API.G_EXC_ERROR;
1227: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1229: END IF;
1230: IF l_order_value > NVL(p_trx_credit_limit ,l_order_value )

Line 1227: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1223:
1224:
1225: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1226: RAISE FND_API.G_EXC_ERROR;
1227: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1229: END IF;
1230: IF l_order_value > NVL(p_trx_credit_limit ,l_order_value )
1231: THEN

Line 1228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1224:
1225: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1226: RAISE FND_API.G_EXC_ERROR;
1227: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1229: END IF;
1230: IF l_order_value > NVL(p_trx_credit_limit ,l_order_value )
1231: THEN
1232: x_cc_result_out := 'FAIL';

Line 1262: x_return_status := FND_API.G_RET_STS_ERROR;

1258: OE_MSG_PUB.ADD;
1259:
1260: G_result_out := 'FAIL' ;
1261: x_cc_result_out := 'FAIL';
1262: x_return_status := FND_API.G_RET_STS_ERROR;
1263:
1264: IF G_debug_flag = 'Y'
1265: THEN
1266: OE_DEBUG_PUB.ADD('Return status after assigned as Error = '

Line 1280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1276: END IF;
1277: EXCEPTION
1278: WHEN others THEN
1279: OE_DEBUG_PUB.Add('Check_Trx_Limit: Other exceptions');
1280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1281: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1282: OE_MSG_PUB.Add_Exc_Msg
1283: ( G_PKG_NAME
1284: , 'Check_Trx_Limit'

Line 1415: x_return_status := FND_API.G_RET_STS_SUCCESS;

1411: OE_DEBUG_PUB.ADD('p_site_use_id = ' || p_site_use_id );
1412: END IF;
1413:
1414: x_check_order_flag := 'Y';
1415: x_return_status := FND_API.G_RET_STS_SUCCESS;
1416: x_global_exposure_flag := 'N' ;
1417:
1418: -- If precalculated, no need to figure out the
1419: -- transaction curr first during ALL currency check

Line 1556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1552: END IF;
1553:
1554: EXCEPTION
1555: WHEN OTHERS THEN
1556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1557: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1558: OE_MSG_PUB.Add_Exc_Msg
1559: ( G_PKG_NAME
1560: , 'Validate_other_credit_check'

Line 1563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1559: ( G_PKG_NAME
1560: , 'Validate_other_credit_check'
1561: );
1562: END IF;
1563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1564: END Validate_other_credit_check;
1565:
1566: -----------------------------------------------------------
1567: -- PROCEDURE: Check_order_exposure PUBLIC

Line 1621: x_return_status := FND_API.G_RET_STS_SUCCESS;

1617: l_order_hold_amount NUMBER ;
1618: l_ar_amount NUMBER ;
1619:
1620: BEGIN
1621: x_return_status := FND_API.G_RET_STS_SUCCESS;
1622:
1623: IF G_debug_flag = 'Y'
1624: THEN
1625:

Line 1712: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1708: OE_DEBUG_PUB.ADD('err curr table count = '
1709: || l_conversion_status.COUNT );
1710: END IF;
1711:
1712: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1713: RAISE FND_API.G_EXC_ERROR;
1714: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1716: END IF;

Line 1713: RAISE FND_API.G_EXC_ERROR;

1709: || l_conversion_status.COUNT );
1710: END IF;
1711:
1712: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1713: RAISE FND_API.G_EXC_ERROR;
1714: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1716: END IF;
1717: END IF;

Line 1714: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1710: END IF;
1711:
1712: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1713: RAISE FND_API.G_EXC_ERROR;
1714: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1716: END IF;
1717: END IF;
1718:

Line 1715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1711:
1712: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1713: RAISE FND_API.G_EXC_ERROR;
1714: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1716: END IF;
1717: END IF;
1718:
1719: IF NVL(l_conversion_status.COUNT,0) > 0 THEN

Line 1762: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1758: OE_DEBUG_PUB.Add(' err cur tbl count = '||
1759: l_conversion_status.COUNT );
1760: END IF;
1761:
1762: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1763: RAISE FND_API.G_EXC_ERROR;
1764: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1766: END IF;

Line 1763: RAISE FND_API.G_EXC_ERROR;

1759: l_conversion_status.COUNT );
1760: END IF;
1761:
1762: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1763: RAISE FND_API.G_EXC_ERROR;
1764: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1766: END IF;
1767:

Line 1764: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1760: END IF;
1761:
1762: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1763: RAISE FND_API.G_EXC_ERROR;
1764: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1766: END IF;
1767:
1768: ELSE

Line 1765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1761:
1762: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1763: RAISE FND_API.G_EXC_ERROR;
1764: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1766: END IF;
1767:
1768: ELSE
1769:

Line 1828: NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) =

1824: l_current_order_value := 0 ;
1825: g_hold_exist := NULL;
1826:
1827: IF NVL(p_calling_action, 'BOOKING') = 'BOOKING' AND
1828: NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) =
1829: FND_API.G_FALSE
1830: THEN
1831: l_current_order_value :=
1832: NVL(OE_CREDIT_CHECK_UTIL.g_current_order_value,0) ;

Line 1829: FND_API.G_FALSE

1825: g_hold_exist := NULL;
1826:
1827: IF NVL(p_calling_action, 'BOOKING') = 'BOOKING' AND
1828: NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) =
1829: FND_API.G_FALSE
1830: THEN
1831: l_current_order_value :=
1832: NVL(OE_CREDIT_CHECK_UTIL.g_current_order_value,0) ;
1833: IF G_debug_flag = 'Y'

Line 1884: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1880: OE_DEBUG_PUB.Add('l_current_order_value = '|| l_current_order_value );
1881: OE_DEBUG_PUB.Add('x_total_exposure before add = '|| x_total_exposure );
1882: END IF;
1883:
1884: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1885: RAISE FND_API.G_EXC_ERROR;
1886: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1887: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1888: END IF;

Line 1885: RAISE FND_API.G_EXC_ERROR;

1881: OE_DEBUG_PUB.Add('x_total_exposure before add = '|| x_total_exposure );
1882: END IF;
1883:
1884: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1885: RAISE FND_API.G_EXC_ERROR;
1886: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1887: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1888: END IF;
1889: END IF; -- get exposure

Line 1886: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1882: END IF;
1883:
1884: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1885: RAISE FND_API.G_EXC_ERROR;
1886: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1887: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1888: END IF;
1889: END IF; -- get exposure
1890: -- Add up the exposure and the current transaction amount

Line 1887: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1883:
1884: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1885: RAISE FND_API.G_EXC_ERROR;
1886: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1887: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1888: END IF;
1889: END IF; -- get exposure
1890: -- Add up the exposure and the current transaction amount
1891: x_total_exposure := NVL(l_transaction_value,0) +

Line 1897: x_return_status := FND_API.G_RET_STS_SUCCESS;

1893: NVL(x_total_exposure,0);
1894: END IF;
1895: ELSE
1896: x_total_exposure := 0 ;
1897: x_return_status := FND_API.G_RET_STS_SUCCESS;
1898: IF G_debug_flag = 'Y' THEN
1899: OE_DEBUG_PUB.Add(' UNLIMITED overall credi '
1900: || p_overall_credit_limit );
1901: END IF;

Line 1912: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1908: || p_overall_credit_limit,1 );
1909: OE_DEBUG_PUB.Add(' curr conv err count ' || l_conversion_status.COUNT );
1910: END IF;
1911:
1912: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1913: RAISE FND_API.G_EXC_ERROR;
1914: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1915: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1916: END IF;

Line 1913: RAISE FND_API.G_EXC_ERROR;

1909: OE_DEBUG_PUB.Add(' curr conv err count ' || l_conversion_status.COUNT );
1910: END IF;
1911:
1912: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1913: RAISE FND_API.G_EXC_ERROR;
1914: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1915: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1916: END IF;
1917:

Line 1914: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1910: END IF;
1911:
1912: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1913: RAISE FND_API.G_EXC_ERROR;
1914: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1915: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1916: END IF;
1917:
1918: IF NVL(l_conversion_status.COUNT,0) > 0

Line 1915: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1911:
1912: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1913: RAISE FND_API.G_EXC_ERROR;
1914: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1915: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1916: END IF;
1917:
1918: IF NVL(l_conversion_status.COUNT,0) > 0
1919: THEN

Line 1944: x_return_status := FND_API.G_RET_STS_ERROR;

1940: OE_MSG_PUB.ADD;
1941:
1942: G_result_out := 'FAIL' ;
1943: x_cc_result_out := 'FAIL';
1944: x_return_status := FND_API.G_RET_STS_ERROR;
1945:
1946: IF G_debug_flag = 'Y'
1947: THEN
1948: OE_DEBUG_PUB.Add(' Exposure CC Failed due to currency failure');

Line 1971: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1967: END IF;
1968:
1969: EXCEPTION
1970: WHEN others THEN
1971: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1972: IF G_debug_flag = 'Y' THEN
1973: OE_DEBUG_PUB.Add('Check_order_exposure: Other exceptions');
1974: END IF;
1975: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 1981: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1977: ( G_PKG_NAME
1978: , 'Check_order_exposure'
1979: );
1980: END IF;
1981: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1982: IF G_debug_flag = 'Y' THEN
1983: OE_DEBUG_PUB.Add( SUBSTR(SQLERRM,1,300) ) ;
1984: END IF;
1985: END Check_order_Exposure ;

Line 2027: x_return_status := FND_API.G_RET_STS_SUCCESS;

2023: OE_DEBUG_PUB.Add('OEXVCRHB: In Check_Item_Limits');
2024: END IF;
2025: --
2026: -- Initialize return status to success
2027: x_return_status := FND_API.G_RET_STS_SUCCESS;
2028: -- Default to Pass
2029:
2030: l_cc_result_out := 'PASS';
2031:

Line 2181: x_return_status := FND_API.G_RET_STS_ERROR;

2177: OE_MSG_PUB.ADD ;
2178:
2179: G_result_out := 'FAIL' ;
2180: x_cc_result_out := 'FAIL';
2181: x_return_status := FND_API.G_RET_STS_ERROR;
2182:
2183: IF G_debug_flag = 'Y' THEN
2184: OE_DEBUG_PUB.Add(' Item CTG CC Failed due to currency failure');
2185: OE_DEBUG_PUB.ADD('Return status after assigned as Error = '

Line 2194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2190: WHEN others THEN
2191: IF G_debug_flag = 'Y' THEN
2192: OE_DEBUG_PUB.Add('Check_Item_Limit: Other exceptions');
2193: END IF;
2194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2195: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2196: OE_MSG_PUB.Add_Exc_Msg
2197: ( G_PKG_NAME
2198: , 'Check_Item_Limits'

Line 2284: x_return_status := FND_API.G_RET_STS_SUCCESS;

2280: --
2281: -- Set the default behavior to pass credit check
2282: --
2283: x_cc_result_out := 'PASS';
2284: x_return_status := FND_API.G_RET_STS_SUCCESS;
2285: x_global_exposure_flag := 'N' ;
2286:
2287: l_cc_result_out := 'PASS';
2288: l_cc_trx_result_out := 'PASS';

Line 2330: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

2326: , x_global_exposure_flag => x_global_exposure_flag
2327: , x_credit_limit_entity_id => l_credit_limit_entity_id
2328: );
2329:
2330: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2331: RAISE FND_API.G_EXC_ERROR;
2332: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2334: END IF;

Line 2331: RAISE FND_API.G_EXC_ERROR;

2327: , x_credit_limit_entity_id => l_credit_limit_entity_id
2328: );
2329:
2330: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2331: RAISE FND_API.G_EXC_ERROR;
2332: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2334: END IF;
2335: --

Line 2332: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2328: );
2329:
2330: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2331: RAISE FND_API.G_EXC_ERROR;
2332: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2334: END IF;
2335: --
2336:

Line 2333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2329:
2330: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2331: RAISE FND_API.G_EXC_ERROR;
2332: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2334: END IF;
2335: --
2336:
2337: -----------------------------------------------------------

Line 2387: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

2383: l_cc_result_out := l_cc_trx_result_out;
2384: l_cc_limit_used := 'TRX';
2385: END IF;
2386:
2387: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2388: RAISE FND_API.G_EXC_ERROR;
2389: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2391: END IF;

Line 2388: RAISE FND_API.G_EXC_ERROR;

2384: l_cc_limit_used := 'TRX';
2385: END IF;
2386:
2387: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2388: RAISE FND_API.G_EXC_ERROR;
2389: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2391: END IF;
2392: g_order := OE_CREDIT_CHECK_UTIL.g_current_order_value ;

Line 2389: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2385: END IF;
2386:
2387: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2388: RAISE FND_API.G_EXC_ERROR;
2389: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2391: END IF;
2392: g_order := OE_CREDIT_CHECK_UTIL.g_current_order_value ;
2393:

Line 2390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2386:
2387: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2388: RAISE FND_API.G_EXC_ERROR;
2389: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2391: END IF;
2392: g_order := OE_CREDIT_CHECK_UTIL.g_current_order_value ;
2393:
2394:

Line 2446: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

2442: l_cc_limit_used := 'DUEDATE';
2443: END IF;
2444: END IF;
2445:
2446: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2447: RAISE FND_API.G_EXC_ERROR;
2448: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2450: END IF;

Line 2447: RAISE FND_API.G_EXC_ERROR;

2443: END IF;
2444: END IF;
2445:
2446: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2447: RAISE FND_API.G_EXC_ERROR;
2448: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2450: END IF;
2451:

Line 2448: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2444: END IF;
2445:
2446: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2447: RAISE FND_API.G_EXC_ERROR;
2448: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2450: END IF;
2451:
2452: -- IF l_cc_result_out = 'PASS' THEN

Line 2449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2445:
2446: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2447: RAISE FND_API.G_EXC_ERROR;
2448: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2450: END IF;
2451:
2452: -- IF l_cc_result_out = 'PASS' THEN
2453: -- Changed IF condition to fix bug 4002813, need to do overall

Line 2544: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

2540: l_cc_limit_used := 'OVERALL';
2541: END IF;
2542: END IF;
2543:
2544: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2545: RAISE FND_API.G_EXC_ERROR;
2546: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2548: END IF;

Line 2545: RAISE FND_API.G_EXC_ERROR;

2541: END IF;
2542: END IF;
2543:
2544: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2545: RAISE FND_API.G_EXC_ERROR;
2546: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2548: END IF;
2549:

Line 2546: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2542: END IF;
2543:
2544: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2545: RAISE FND_API.G_EXC_ERROR;
2546: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2548: END IF;
2549:
2550: -- l_cc_limit_used := 'OVERALL';

Line 2547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2543:
2544: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2545: RAISE FND_API.G_EXC_ERROR;
2546: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2548: END IF;
2549:
2550: -- l_cc_limit_used := 'OVERALL';
2551:

Line 2715: , p_init_msg_list => FND_API.G_FALSE

2711: END IF;
2712: ----------------Submit Credit Review--------------------
2713: AR_CMGT_CREDIT_REQUEST_API.Create_credit_request
2714: ( p_api_version => 1.0
2715: , p_init_msg_list => FND_API.G_FALSE
2716: , p_commit => FND_API.G_FALSE
2717: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
2718: , x_return_status => x_return_status
2719: , x_msg_count => l_msg_count

Line 2716: , p_commit => FND_API.G_FALSE

2712: ----------------Submit Credit Review--------------------
2713: AR_CMGT_CREDIT_REQUEST_API.Create_credit_request
2714: ( p_api_version => 1.0
2715: , p_init_msg_list => FND_API.G_FALSE
2716: , p_commit => FND_API.G_FALSE
2717: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
2718: , x_return_status => x_return_status
2719: , x_msg_count => l_msg_count
2720: , x_msg_data => l_msg_data

Line 2717: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

2713: AR_CMGT_CREDIT_REQUEST_API.Create_credit_request
2714: ( p_api_version => 1.0
2715: , p_init_msg_list => FND_API.G_FALSE
2716: , p_commit => FND_API.G_FALSE
2717: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
2718: , x_return_status => x_return_status
2719: , x_msg_count => l_msg_count
2720: , x_msg_data => l_msg_data
2721: , p_application_number => NULL

Line 2817: WHEN FND_API.G_EXC_ERROR THEN

2813: OE_DEBUG_PUB.Add('OEXVCRHB: Out Check_Other_Credit Limits');
2814: END IF;
2815:
2816: EXCEPTION
2817: WHEN FND_API.G_EXC_ERROR THEN
2818: x_return_status := FND_API.G_RET_STS_ERROR;
2819: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2821: WHEN OTHERS THEN

Line 2818: x_return_status := FND_API.G_RET_STS_ERROR;

2814: END IF;
2815:
2816: EXCEPTION
2817: WHEN FND_API.G_EXC_ERROR THEN
2818: x_return_status := FND_API.G_RET_STS_ERROR;
2819: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2821: WHEN OTHERS THEN
2822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2819: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2815:
2816: EXCEPTION
2817: WHEN FND_API.G_EXC_ERROR THEN
2818: x_return_status := FND_API.G_RET_STS_ERROR;
2819: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2821: WHEN OTHERS THEN
2822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2823: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 2820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2816: EXCEPTION
2817: WHEN FND_API.G_EXC_ERROR THEN
2818: x_return_status := FND_API.G_RET_STS_ERROR;
2819: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2821: WHEN OTHERS THEN
2822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2823: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2824: OE_MSG_PUB.Add_Exc_Msg

Line 2822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2818: x_return_status := FND_API.G_RET_STS_ERROR;
2819: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2821: WHEN OTHERS THEN
2822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2823: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2824: OE_MSG_PUB.Add_Exc_Msg
2825: ( G_PKG_NAME, 'Check_Other_Credit_Limits');
2826: END IF;

Line 2876: x_return_status := FND_API.G_RET_STS_SUCCESS;

2872: --
2873: -- Set the default behavior to pass credit check
2874: --
2875: x_cc_result_out := 'NOCHECK';
2876: x_return_status := FND_API.G_RET_STS_SUCCESS;
2877: G_result_out := 'PASS' ;
2878: l_global_exposure_flag := 'N' ;
2879: g_hold_exist := NULL ;
2880: OE_Credit_Engine_GRP.G_currency_error_msg := NULL ;

Line 2984: x_return_status := FND_API.G_RET_STS_SUCCESS;

2980: || x_return_status );
2981: END IF;
2982: ELSE
2983: l_cc_result_out := 'PASS' ;
2984: x_return_status := FND_API.G_RET_STS_SUCCESS;
2985: IF G_debug_flag = 'Y' THEN
2986: OE_DEBUG_PUB.Add(' No Item category credit checking, flag OFF ');
2987: OE_DEBUG_PUB.Add('l_cc_result_out = '
2988: || l_cc_result_out );

Line 2994: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

2990: || x_return_status );
2991: END IF;
2992: END IF;
2993:
2994: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2995: RAISE FND_API.G_EXC_ERROR;
2996: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2998: END IF;

Line 2995: RAISE FND_API.G_EXC_ERROR;

2991: END IF;
2992: END IF;
2993:
2994: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2995: RAISE FND_API.G_EXC_ERROR;
2996: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2998: END IF;
2999: --

Line 2996: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2992: END IF;
2993:
2994: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2995: RAISE FND_API.G_EXC_ERROR;
2996: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2998: END IF;
2999: --
3000: -- Apply the database hold and Exit the bill-to site loop if

Line 2997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2993:
2994: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2995: RAISE FND_API.G_EXC_ERROR;
2996: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2998: END IF;
2999: --
3000: -- Apply the database hold and Exit the bill-to site loop if
3001: -- credit hold level is ORDER and the order failed credit check.

Line 3054: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

3050: OE_DEBUG_PUB.Add('Check_Other_Credit_Limits: Return Status = '
3051: || x_return_status );
3052: END IF;
3053:
3054: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3055: RAISE FND_API.G_EXC_ERROR;
3056: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3057: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3058: END IF;

Line 3055: RAISE FND_API.G_EXC_ERROR;

3051: || x_return_status );
3052: END IF;
3053:
3054: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3055: RAISE FND_API.G_EXC_ERROR;
3056: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3057: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3058: END IF;
3059:

Line 3056: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3052: END IF;
3053:
3054: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3055: RAISE FND_API.G_EXC_ERROR;
3056: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3057: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3058: END IF;
3059:
3060: -- Apply order level credit hold to the database if it necessary

Line 3057: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3053:
3054: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3055: RAISE FND_API.G_EXC_ERROR;
3056: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3057: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3058: END IF;
3059:
3060: -- Apply order level credit hold to the database if it necessary
3061:

Line 3147: WHEN FND_API.G_EXC_ERROR THEN

3143: OE_DEBUG_PUB.Add('OEXVCRHB: Out Check_order_credit API');
3144: END IF;
3145:
3146: EXCEPTION
3147: WHEN FND_API.G_EXC_ERROR THEN
3148: IF G_debug_flag = 'Y' THEN
3149: OE_DEBUG_PUB.Add('Check_order_credit: Error ');
3150: END IF;
3151: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3151: x_return_status := FND_API.G_RET_STS_ERROR;

3147: WHEN FND_API.G_EXC_ERROR THEN
3148: IF G_debug_flag = 'Y' THEN
3149: OE_DEBUG_PUB.Add('Check_order_credit: Error ');
3150: END IF;
3151: x_return_status := FND_API.G_RET_STS_ERROR;
3152: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3153: IF G_debug_flag = 'Y' THEN
3154: OE_DEBUG_PUB.Add('Check_order_credit: Unexpected Error ');
3155: END IF;

Line 3152: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3148: IF G_debug_flag = 'Y' THEN
3149: OE_DEBUG_PUB.Add('Check_order_credit: Error ');
3150: END IF;
3151: x_return_status := FND_API.G_RET_STS_ERROR;
3152: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3153: IF G_debug_flag = 'Y' THEN
3154: OE_DEBUG_PUB.Add('Check_order_credit: Unexpected Error ');
3155: END IF;
3156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3152: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3153: IF G_debug_flag = 'Y' THEN
3154: OE_DEBUG_PUB.Add('Check_order_credit: Unexpected Error ');
3155: END IF;
3156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3157: WHEN OTHERS THEN
3158: IF G_debug_flag = 'Y' THEN
3159: OE_DEBUG_PUB.Add('Check_order_credit: Other Unexpected Error ');
3160: END IF;

Line 3161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3157: WHEN OTHERS THEN
3158: IF G_debug_flag = 'Y' THEN
3159: OE_DEBUG_PUB.Add('Check_order_credit: Other Unexpected Error ');
3160: END IF;
3161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3162: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3163: OE_MSG_PUB.Add_Exc_Msg
3164: ( G_PKG_NAME
3165: , 'Check_order_credit'