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

Line 136: , p_validation_level => FND_API.G_VALID_LEVEL_NONE

132:
133:
134: OE_Holds_PUB.Apply_Holds
135: ( p_api_version => 1.0
136: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
137: , p_hold_source_rec => p_hold_source_rec
138: , x_msg_count => x_msg_count
139: , x_msg_data => x_msg_data
140: , x_return_status => x_return_status

Line 145: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

141: );
142:
143: OE_DEBUG_PUB.ADD(' Out OE_Holds_PUB.Apply_Holds ');
144: OE_DEBUG_PUB.ADD(' x_return_status => '|| x_return_status );
145: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
146: RAISE FND_API.G_EXC_ERROR;
147: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
149: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 146: RAISE FND_API.G_EXC_ERROR;

142:
143: OE_DEBUG_PUB.ADD(' Out OE_Holds_PUB.Apply_Holds ');
144: OE_DEBUG_PUB.ADD(' x_return_status => '|| x_return_status );
145: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
146: RAISE FND_API.G_EXC_ERROR;
147: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
149: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
150:

Line 147: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

143: OE_DEBUG_PUB.ADD(' Out OE_Holds_PUB.Apply_Holds ');
144: OE_DEBUG_PUB.ADD(' x_return_status => '|| x_return_status );
145: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
146: RAISE FND_API.G_EXC_ERROR;
147: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
149: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
150:
151: OE_DEBUG_PUB.ADD(' Holds success ');

Line 148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

144: OE_DEBUG_PUB.ADD(' x_return_status => '|| x_return_status );
145: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
146: RAISE FND_API.G_EXC_ERROR;
147: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
149: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
150:
151: OE_DEBUG_PUB.ADD(' Holds success ');
152: OE_DEBUG_PUB.ADD(' About to Issue COMMIT');

Line 149: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

145: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
146: RAISE FND_API.G_EXC_ERROR;
147: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
149: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
150:
151: OE_DEBUG_PUB.ADD(' Holds success ');
152: OE_DEBUG_PUB.ADD(' About to Issue COMMIT');
153:

Line 209: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

205: OE_DEBUG_PUB.ADD('OEXVCRLB: After OE_Holds_PUB.Update_Hold_Comments Status '
206: || x_return_status);
207: END IF;
208:
209: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
210: RAISE FND_API.G_EXC_ERROR;
211: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
213: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 210: RAISE FND_API.G_EXC_ERROR;

206: || x_return_status);
207: END IF;
208:
209: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
210: RAISE FND_API.G_EXC_ERROR;
211: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
213: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
214: IF G_debug_flag = 'Y'

Line 211: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

207: END IF;
208:
209: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
210: RAISE FND_API.G_EXC_ERROR;
211: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
213: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
214: IF G_debug_flag = 'Y'
215: THEN

Line 212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

208:
209: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
210: RAISE FND_API.G_EXC_ERROR;
211: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
213: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
214: IF G_debug_flag = 'Y'
215: THEN
216: OE_DEBUG_PUB.ADD('OEXVCRLB: Update Hold Comment Success, Issue COMMIT');

Line 213: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

209: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
210: RAISE FND_API.G_EXC_ERROR;
211: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
213: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
214: IF G_debug_flag = 'Y'
215: THEN
216: OE_DEBUG_PUB.ADD('OEXVCRLB: Update Hold Comment Success, Issue COMMIT');
217: END IF;

Line 520: x_return_status := FND_API.G_RET_STS_SUCCESS;

516: END IF;
517:
518:
519: -- Initialize return status to success
520: x_return_status := FND_API.G_RET_STS_SUCCESS;
521:
522: IF p_line_id IS NULL THEN
523: -- Update the whole table.
524: FOR i IN 1..p_holds_table.COUNT

Line 588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

584: END IF;
585:
586: EXCEPTION
587: WHEN OTHERS THEN
588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
589: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
590: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Update_Holds_Table');
591: END IF;
592: RAISE;

Line 765: AND NVL(OE_credit_engine_grp.G_delayed_request, FND_API.G_FALSE )

761: -- Will not check if the event is UPDATE
762:
763: -- Adding 'AUTO HOLD' for bug# 4207478
764: IF p_calling_action IN ( 'SHIPPING' , 'PACKING' , 'PICKING', 'AUTO HOLD')
765: AND NVL(OE_credit_engine_grp.G_delayed_request, FND_API.G_FALSE )
766: = FND_API.G_FALSE
767: --ER 12363706 start
768: OR (NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) = FND_API.G_TRUE)
769: --ER 12363706 end

Line 766: = FND_API.G_FALSE

762:
763: -- Adding 'AUTO HOLD' for bug# 4207478
764: IF p_calling_action IN ( 'SHIPPING' , 'PACKING' , 'PICKING', 'AUTO HOLD')
765: AND NVL(OE_credit_engine_grp.G_delayed_request, FND_API.G_FALSE )
766: = FND_API.G_FALSE
767: --ER 12363706 start
768: OR (NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) = FND_API.G_TRUE)
769: --ER 12363706 end
770: THEN

Line 768: OR (NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) = FND_API.G_TRUE)

764: IF p_calling_action IN ( 'SHIPPING' , 'PACKING' , 'PICKING', 'AUTO HOLD')
765: AND NVL(OE_credit_engine_grp.G_delayed_request, FND_API.G_FALSE )
766: = FND_API.G_FALSE
767: --ER 12363706 start
768: OR (NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) = FND_API.G_TRUE)
769: --ER 12363706 end
770: THEN
771: BEGIN
772: IF p_credit_hold_level = 'ORDER'

Line 851: IF NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) = FND_API.G_FALSE THEN --ER 12363706

847: FROM OE_HOLD_RELEASES
848: WHERE HOLD_RELEASE_ID = l_hold_release_id
849: AND RELEASE_REASON_CODE <> 'PASS_CREDIT'
850: AND CREATED_BY <> 1;
851: IF NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) = FND_API.G_FALSE THEN --ER 12363706
852: -----check if days_honor_manual_release expired
853: IF p_credit_check_rule_rec.days_honor_manual_release IS NOT NULL
854: THEN
855: IF (l_release_date + p_credit_check_rule_rec.days_honor_manual_release >= SYSDATE )

Line 919: x_return_status := FND_API.G_RET_STS_SUCCESS;

915: OE_DEBUG_PUB.ADD('OEXVCRLB: In Chk_Past_Due_Invoice');
916: END IF;
917:
918: -- Initialize return status to success
919: x_return_status := FND_API.G_RET_STS_SUCCESS;
920: -- Default to pass
921: x_cc_result_out := 'PASS';
922:
923:

Line 940: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

936: , x_return_status => x_return_status
937: );
938:
939:
940: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
941: RAISE FND_API.G_EXC_ERROR;
942: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
944: END IF;

Line 941: RAISE FND_API.G_EXC_ERROR;

937: );
938:
939:
940: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
941: RAISE FND_API.G_EXC_ERROR;
942: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
944: END IF;
945:

Line 942: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

938:
939:
940: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
941: RAISE FND_API.G_EXC_ERROR;
942: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
944: END IF;
945:
946: IF l_exist_flag = 'Y'

Line 943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

939:
940: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
941: RAISE FND_API.G_EXC_ERROR;
942: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
944: END IF;
945:
946: IF l_exist_flag = 'Y'
947: THEN

Line 960: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

956: END IF;
957:
958: EXCEPTION
959: WHEN OTHERS THEN
960: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
961: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
962: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Chk_Past_Due_invoice');
963: END IF;
964: END Chk_Past_Due_Invoice;

Line 1036: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1032: THEN
1033: OE_DEBUG_PUB.ADD('OEXVCRLB: Out Check_Holds');
1034: END IF;
1035:
1036: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1037: RAISE FND_API.G_EXC_ERROR;
1038: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1039: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1040: END IF;

Line 1037: RAISE FND_API.G_EXC_ERROR;

1033: OE_DEBUG_PUB.ADD('OEXVCRLB: Out Check_Holds');
1034: END IF;
1035:
1036: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1037: RAISE FND_API.G_EXC_ERROR;
1038: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1039: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1040: END IF;
1041:

Line 1038: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1034: END IF;
1035:
1036: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1037: RAISE FND_API.G_EXC_ERROR;
1038: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1039: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1040: END IF;
1041:
1042: IF l_hold_result = FND_API.G_TRUE THEN

Line 1039: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1035:
1036: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1037: RAISE FND_API.G_EXC_ERROR;
1038: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1039: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1040: END IF;
1041:
1042: IF l_hold_result = FND_API.G_TRUE THEN
1043: return TRUE;

Line 1042: IF l_hold_result = FND_API.G_TRUE THEN

1038: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1039: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1040: END IF;
1041:
1042: IF l_hold_result = FND_API.G_TRUE THEN
1043: return TRUE;
1044: ELSE
1045: return FALSE;
1046: END IF;

Line 1088: --IF NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) =

1084:
1085: -- Write to message stack anyway regardless of the calling action
1086: -- added IF for bug 5467793
1087: --bug 7207292, reverting fix 5467793 as multiple messages are now shown in processing messages window
1088: --IF NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) =
1089: -- FND_API.G_FALSE THEN
1090: IF p_cc_limit_used <> 'ITEM' THEN
1091: -- bug 4002820
1092: IF INSTR(p_cc_limit_used, ',') > 0 THEN

Line 1089: -- FND_API.G_FALSE THEN

1085: -- Write to message stack anyway regardless of the calling action
1086: -- added IF for bug 5467793
1087: --bug 7207292, reverting fix 5467793 as multiple messages are now shown in processing messages window
1088: --IF NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) =
1089: -- FND_API.G_FALSE THEN
1090: IF p_cc_limit_used <> 'ITEM' THEN
1091: -- bug 4002820
1092: IF INSTR(p_cc_limit_used, ',') > 0 THEN
1093: l_cc_profile_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_PROFILE', p_cc_profile_used);

Line 1563: --IF NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) =

1559: IF G_debug_flag = 'Y'
1560: THEN
1561: OE_DEBUG_PUB.ADD('OEXVCRLB: Call Update_Comments_And_Commit');
1562: END IF;
1563: --IF NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) =
1564: --FND_API.G_FALSE THEN --bug6120327
1565: l_cc_result_out := 'FAIL_HOLD';--kadiraju added for Bug# 13768161
1566: Update_Comments_And_Commit
1567: ( p_hold_source_rec => l_hold_source_rec

Line 1564: --FND_API.G_FALSE THEN --bug6120327

1560: THEN
1561: OE_DEBUG_PUB.ADD('OEXVCRLB: Call Update_Comments_And_Commit');
1562: END IF;
1563: --IF NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) =
1564: --FND_API.G_FALSE THEN --bug6120327
1565: l_cc_result_out := 'FAIL_HOLD';--kadiraju added for Bug# 13768161
1566: Update_Comments_And_Commit
1567: ( p_hold_source_rec => l_hold_source_rec
1568: , x_msg_count => l_msg_count

Line 1585: --IF NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) =

1581: IF G_debug_flag = 'Y'
1582: THEN
1583: OE_DEBUG_PUB.ADD('OEXVCRLB: Call OE_Holds_PUB.Update_Hold_Comments directly');
1584: END IF;
1585: --IF NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) =
1586: --FND_API.G_FALSE THEN --bug6120327
1587: l_cc_result_out := 'FAIL_HOLD';--kadiraju added for Bug# 13768161
1588: OE_Holds_PUB.Update_Hold_comments
1589: ( p_hold_source_rec => l_hold_source_rec

Line 1586: --FND_API.G_FALSE THEN --bug6120327

1582: THEN
1583: OE_DEBUG_PUB.ADD('OEXVCRLB: Call OE_Holds_PUB.Update_Hold_Comments directly');
1584: END IF;
1585: --IF NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) =
1586: --FND_API.G_FALSE THEN --bug6120327
1587: l_cc_result_out := 'FAIL_HOLD';--kadiraju added for Bug# 13768161
1588: OE_Holds_PUB.Update_Hold_comments
1589: ( p_hold_source_rec => l_hold_source_rec
1590: , x_msg_count => l_msg_count

Line 1603: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1599: OE_DEBUG_PUB.ADD('OEXVCRLB: Out OE_Holds_PUB.Update_Hold_Comments directly');
1600: END IF;
1601: END IF;
1602:
1603: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1604: RAISE FND_API.G_EXC_ERROR;
1605: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1607: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 1604: RAISE FND_API.G_EXC_ERROR;

1600: END IF;
1601: END IF;
1602:
1603: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1604: RAISE FND_API.G_EXC_ERROR;
1605: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1607: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1608: IF G_debug_flag = 'Y' THEN

Line 1605: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1601: END IF;
1602:
1603: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1604: RAISE FND_API.G_EXC_ERROR;
1605: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1607: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1608: IF G_debug_flag = 'Y' THEN
1609: OE_DEBUG_PUB.ADD

Line 1606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1602:
1603: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1604: RAISE FND_API.G_EXC_ERROR;
1605: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1607: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1608: IF G_debug_flag = 'Y' THEN
1609: OE_DEBUG_PUB.ADD
1610: ('OEXVCRLB: Updated Comments on Header/Line ID:' ||

Line 1607: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1603: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1604: RAISE FND_API.G_EXC_ERROR;
1605: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1607: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1608: IF G_debug_flag = 'Y' THEN
1609: OE_DEBUG_PUB.ADD
1610: ('OEXVCRLB: Updated Comments on Header/Line ID:' ||
1611: p_header_id || '/' ||

Line 1626: AND NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) = FND_API.G_FALSE) OR (NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) = FND_API.G_TRUE)

1622: ,p_line_id => top_model_line_id_smc(p_line_id) -- Bug 7673312
1623: ,p_credit_check_rule_rec=>p_credit_check_rule_rec
1624: ) = 'N'
1625: --ER 12363706 start
1626: AND NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) = FND_API.G_FALSE) OR (NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) = FND_API.G_TRUE)
1627: --ER 12363706 end
1628: THEN
1629: G_result_out := 'FAIL' ;
1630:

Line 1664: , p_validation_level => FND_API.G_VALID_LEVEL_NONE

1660: OE_Credit_Engine_GRP.G_Credit_Profile_Level := p_cc_profile_used; --ER 12363706
1661:
1662: OE_Holds_PUB.Apply_Holds
1663: ( p_api_version => 1.0
1664: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
1665: , p_hold_source_rec => l_hold_source_rec
1666: , x_msg_count => l_msg_count
1667: , x_msg_data => l_msg_data
1668: , x_return_status => l_return_status

Line 1701: , p_validation_level => FND_API.G_VALID_LEVEL_NONE

1697: END IF;
1698: OE_Credit_Engine_GRP.G_Credit_Profile_Level := p_cc_profile_used; --ER 12363706
1699: OE_Holds_PUB.Apply_Holds
1700: ( p_api_version => 1.0
1701: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
1702: , p_hold_source_rec => l_hold_source_rec
1703: , x_msg_count => l_msg_count
1704: , x_msg_data => l_msg_data
1705: , x_return_status => l_return_status

Line 1718: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1714: IF G_debug_flag = 'Y' THEN
1715: OE_DEBUG_PUB.ADD('OEXVCRLB: Apply Holds status '|| l_return_status );
1716: END IF;
1717:
1718: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1719: RAISE FND_API.G_EXC_ERROR;
1720: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1722: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 1719: RAISE FND_API.G_EXC_ERROR;

1715: OE_DEBUG_PUB.ADD('OEXVCRLB: Apply Holds status '|| l_return_status );
1716: END IF;
1717:
1718: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1719: RAISE FND_API.G_EXC_ERROR;
1720: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1722: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1723: IF G_debug_flag = 'Y' THEN

Line 1720: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1716: END IF;
1717:
1718: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1719: RAISE FND_API.G_EXC_ERROR;
1720: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1722: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1723: IF G_debug_flag = 'Y' THEN
1724: OE_DEBUG_PUB.ADD

Line 1721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1717:
1718: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1719: RAISE FND_API.G_EXC_ERROR;
1720: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1722: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1723: IF G_debug_flag = 'Y' THEN
1724: OE_DEBUG_PUB.ADD
1725: ('OEXVCRLB: Applied credit check hold on Header/Line ID:' ||

Line 1722: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1718: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1719: RAISE FND_API.G_EXC_ERROR;
1720: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1722: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1723: IF G_debug_flag = 'Y' THEN
1724: OE_DEBUG_PUB.ADD
1725: ('OEXVCRLB: Applied credit check hold on Header/Line ID:' ||
1726: p_header_id || '/' ||

Line 1845: AND NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) = FND_API.G_FALSE) OR (NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) = FND_API.G_TRUE)

1841: ,p_line_id => NULL
1842: ,p_credit_check_rule_rec=>p_credit_check_rule_rec
1843: ) = 'N'
1844: --ER 12363706 start
1845: AND NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) = FND_API.G_FALSE) OR (NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) = FND_API.G_TRUE)
1846: --ER 12363706 end
1847: THEN
1848: G_result_out := 'FAIL' ;
1849:

Line 1872: , p_validation_level => FND_API.G_VALID_LEVEL_NONE

1868: IF NVL(p_calling_action, 'BOOKING') <> 'AUTO RELEASE' THEN
1869: OE_Credit_Engine_GRP.G_Credit_Profile_Level := p_cc_profile_used; --ER 12363706
1870: OE_Holds_PUB.Apply_Holds
1871: ( p_api_version => 1.0
1872: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
1873: , p_hold_source_rec => l_hold_source_rec
1874: , x_msg_count => l_msg_count
1875: , x_msg_data => l_msg_data
1876: , x_return_status => l_return_status

Line 1879: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1875: , x_msg_data => l_msg_data
1876: , x_return_status => l_return_status
1877: );
1878: OE_Credit_Engine_GRP.G_Credit_Profile_Level := NULL; --ER 12363706
1879: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1880: RAISE FND_API.G_EXC_ERROR;
1881: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1882: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1883: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 1880: RAISE FND_API.G_EXC_ERROR;

1876: , x_return_status => l_return_status
1877: );
1878: OE_Credit_Engine_GRP.G_Credit_Profile_Level := NULL; --ER 12363706
1879: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1880: RAISE FND_API.G_EXC_ERROR;
1881: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1882: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1883: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1884: IF G_debug_flag = 'Y' THEN

Line 1881: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1877: );
1878: OE_Credit_Engine_GRP.G_Credit_Profile_Level := NULL; --ER 12363706
1879: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1880: RAISE FND_API.G_EXC_ERROR;
1881: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1882: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1883: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1884: IF G_debug_flag = 'Y' THEN
1885: OE_DEBUG_PUB.ADD

Line 1882: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1878: OE_Credit_Engine_GRP.G_Credit_Profile_Level := NULL; --ER 12363706
1879: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1880: RAISE FND_API.G_EXC_ERROR;
1881: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1882: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1883: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1884: IF G_debug_flag = 'Y' THEN
1885: OE_DEBUG_PUB.ADD
1886: ('OEXVCRLB: Credit check hold applied on header_ID: '||p_header_id, 1);

Line 1883: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1879: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1880: RAISE FND_API.G_EXC_ERROR;
1881: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1882: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1883: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1884: IF G_debug_flag = 'Y' THEN
1885: OE_DEBUG_PUB.ADD
1886: ('OEXVCRLB: Credit check hold applied on header_ID: '||p_header_id, 1);
1887: END IF;

Line 1945: l_return_status := FND_API.G_RET_STS_SUCCESS;

1941: THEN
1942: OE_DEBUG_PUB.Add('OEXVCRLB: In Release_Order_CC_Hold');
1943: END IF;
1944:
1945: l_return_status := FND_API.G_RET_STS_SUCCESS;
1946: --
1947: -- Release credit hold if the calling action is not BOOKING and not
1948: -- UPDATE with background credit check set.
1949: --

Line 1989: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1985: , x_msg_count => l_msg_count
1986: , x_msg_data => l_msg_data
1987: , x_return_status => l_return_status
1988: );
1989: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1990: RAISE FND_API.G_EXC_ERROR;
1991: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1993: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN

Line 1990: RAISE FND_API.G_EXC_ERROR;

1986: , x_msg_data => l_msg_data
1987: , x_return_status => l_return_status
1988: );
1989: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1990: RAISE FND_API.G_EXC_ERROR;
1991: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1993: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
1994: Write_Order_Release_Msg(

Line 1991: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1987: , x_return_status => l_return_status
1988: );
1989: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1990: RAISE FND_API.G_EXC_ERROR;
1991: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1993: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
1994: Write_Order_Release_Msg(
1995: p_calling_action => p_calling_action

Line 1992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1988: );
1989: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1990: RAISE FND_API.G_EXC_ERROR;
1991: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1993: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
1994: Write_Order_Release_Msg(
1995: p_calling_action => p_calling_action
1996: , p_order_number => p_order_number

Line 1993: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN

1989: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1990: RAISE FND_API.G_EXC_ERROR;
1991: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1993: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
1994: Write_Order_Release_Msg(
1995: p_calling_action => p_calling_action
1996: , p_order_number => p_order_number
1997: );

Line 2045: l_return_status := FND_API.G_RET_STS_SUCCESS;

2041: THEN
2042: OE_DEBUG_PUB.Add('OEXVCRLB: In Apply_Item_Category_Holds');
2043: END IF;
2044:
2045: l_return_status := FND_API.G_RET_STS_SUCCESS;
2046: FOR i IN 1..p_lines.count LOOP
2047: IF p_item_category_id = p_lines(i).item_category_id THEN
2048: OE_DEBUG_PUB.Add('Line ID '||p_lines(i).line_id
2049: ||' fails ITEM limit ck',1);

Line 2059: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2055: , p_cc_profile_used => 'CATEGORY'
2056: , p_item_category_id => p_item_category_id
2057: , x_return_status => l_return_status
2058: );
2059: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2060: RAISE FND_API.G_EXC_ERROR;
2061: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2063: END IF;

Line 2060: RAISE FND_API.G_EXC_ERROR;

2056: , p_item_category_id => p_item_category_id
2057: , x_return_status => l_return_status
2058: );
2059: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2060: RAISE FND_API.G_EXC_ERROR;
2061: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2063: END IF;
2064: END IF;

Line 2061: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2057: , x_return_status => l_return_status
2058: );
2059: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2060: RAISE FND_API.G_EXC_ERROR;
2061: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2063: END IF;
2064: END IF;
2065: END LOOP;

Line 2062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2058: );
2059: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2060: RAISE FND_API.G_EXC_ERROR;
2061: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2063: END IF;
2064: END IF;
2065: END LOOP;
2066:

Line 2165: l_return_status := FND_API.G_RET_STS_SUCCESS;

2161: OE_DEBUG_PUB.ADD('Processing line ID = '||
2162: p_line_id );
2163: END IF;
2164:
2165: l_return_status := FND_API.G_RET_STS_SUCCESS;
2166:
2167: -- Holds Issue 1979918
2168: --------------------------------------------------------------------
2169: -- During the credit checking is at Line level ( PASS scenario ),

Line 2215: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2211: , x_msg_data => l_msg_data
2212: , x_return_status => l_return_status
2213: );
2214:
2215: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2216: IF NVL(G_hdr_hold_released,'N') = 'N'
2217: THEN
2218: l_cc_result_out := 'HDR_HOLD' ;
2219: ELSE

Line 2220: RAISE FND_API.G_EXC_ERROR;

2216: IF NVL(G_hdr_hold_released,'N') = 'N'
2217: THEN
2218: l_cc_result_out := 'HDR_HOLD' ;
2219: ELSE
2220: RAISE FND_API.G_EXC_ERROR;
2221: END IF;
2222: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2223: IF NVL(G_hdr_hold_released,'N') = 'N'
2224: THEN

Line 2222: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2218: l_cc_result_out := 'HDR_HOLD' ;
2219: ELSE
2220: RAISE FND_API.G_EXC_ERROR;
2221: END IF;
2222: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2223: IF NVL(G_hdr_hold_released,'N') = 'N'
2224: THEN
2225: l_cc_result_out := 'HDR_HOLD' ;
2226: ELSE

Line 2227: RAISE FND_API.G_EXC_ERROR;

2223: IF NVL(G_hdr_hold_released,'N') = 'N'
2224: THEN
2225: l_cc_result_out := 'HDR_HOLD' ;
2226: ELSE
2227: RAISE FND_API.G_EXC_ERROR;
2228: END IF;
2229: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
2230: Write_Release_Message(
2231: p_calling_action => p_calling_action

Line 2229: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN

2225: l_cc_result_out := 'HDR_HOLD' ;
2226: ELSE
2227: RAISE FND_API.G_EXC_ERROR;
2228: END IF;
2229: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
2230: Write_Release_Message(
2231: p_calling_action => p_calling_action
2232: , p_order_number => p_order_number
2233: , p_line_number => p_line_number

Line 2306: x_return_status := FND_API.G_RET_STS_SUCCESS;

2302: OE_DEBUG_PUB.ADD(' p_trx_credit_limit = '|| p_trx_credit_limit,2);
2303: END IF;
2304:
2305: -- Initialize return status to success
2306: x_return_status := FND_API.G_RET_STS_SUCCESS;
2307: -- Default to Pass
2308: x_cc_result_out := 'PASS';
2309:
2310: -- Start 13987649

Line 2369: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

2365: OE_DEBUG_PUB.ADD(' ERR curr tbl count = '
2366: || x_conversion_status.COUNT );
2367: END IF;
2368:
2369: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2370: RAISE FND_API.G_EXC_ERROR;
2371: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2373: END IF;

Line 2370: RAISE FND_API.G_EXC_ERROR;

2366: || x_conversion_status.COUNT );
2367: END IF;
2368:
2369: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2370: RAISE FND_API.G_EXC_ERROR;
2371: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2373: END IF;
2374:

Line 2371: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2367: END IF;
2368:
2369: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2370: RAISE FND_API.G_EXC_ERROR;
2371: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2373: END IF;
2374:
2375: IF G_debug_flag = 'Y'

Line 2372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2368:
2369: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2370: RAISE FND_API.G_EXC_ERROR;
2371: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2373: END IF;
2374:
2375: IF G_debug_flag = 'Y'
2376: THEN

Line 2409: x_return_status := FND_API.G_RET_STS_ERROR;

2405: FND_MESSAGE.Set_Token('CONV',
2406: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
2407:
2408: OE_MSG_PUB.ADD;
2409: x_return_status := FND_API.G_RET_STS_ERROR;
2410:
2411: END IF;
2412:
2413:

Line 2427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2423: END IF;
2424: EXCEPTION
2425: WHEN others THEN
2426: OE_DEBUG_PUB.Add('Check_Trx_Limit: Other exceptions');
2427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2428: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2429: OE_MSG_PUB.Add_Exc_Msg
2430: ( G_PKG_NAME
2431: , 'Check_Trx_Limit'

Line 2475: x_return_status := FND_API.G_RET_STS_SUCCESS;

2471:
2472: BEGIN
2473:
2474: x_check_order_flag := 'Y';
2475: x_return_status := FND_API.G_RET_STS_SUCCESS;
2476: x_global_exposure_flag := 'N' ;
2477:
2478: IF G_debug_flag = 'Y'
2479: THEN

Line 2592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2588: OE_DEBUG_PUB.Add('OEXVCRLB: Out Validate_other_credit_check');
2589: END IF;
2590: EXCEPTION
2591: WHEN OTHERS THEN
2592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2593: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2594: OE_MSG_PUB.Add_Exc_Msg
2595: ( G_PKG_NAME
2596: , 'Validate_other_credit_check'

Line 2599: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2595: ( G_PKG_NAME
2596: , 'Validate_other_credit_check'
2597: );
2598: END IF;
2599: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2600: OE_DEBUG_PUB.ADD( SUBSTR(SQLERRM,1,300) ,1 );
2601: END Validate_other_credit_check;
2602:
2603: -----------------------------------------------------------

Line 2705: x_return_status := FND_API.G_RET_STS_SUCCESS;

2701: -- Set the default behaviour to pass credit check |
2702: -- exposure |
2703: ----------------------------------------------------------
2704:
2705: x_return_status := FND_API.G_RET_STS_SUCCESS;
2706: x_total_exposure := 0 ;
2707: l_current_order_value := 0 ;
2708:
2709: OE_DEBUG_PUB.ADD( ' Call Get_Exposure ');

Line 2739: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

2735: OE_DEBUG_PUB.Add('x_total_exposure = '|| x_total_exposure );
2736: OE_DEBUG_PUB.Add('Error table count = '|| x_error_curr_tbl.COUNT );
2737: END IF;
2738:
2739: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2740: RAISE FND_API.G_EXC_ERROR;
2741: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2742: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2743: END IF;

Line 2740: RAISE FND_API.G_EXC_ERROR;

2736: OE_DEBUG_PUB.Add('Error table count = '|| x_error_curr_tbl.COUNT );
2737: END IF;
2738:
2739: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2740: RAISE FND_API.G_EXC_ERROR;
2741: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2742: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2743: END IF;
2744:

Line 2741: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2737: END IF;
2738:
2739: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2740: RAISE FND_API.G_EXC_ERROR;
2741: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2742: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2743: END IF;
2744:
2745:

Line 2742: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2738:
2739: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2740: RAISE FND_API.G_EXC_ERROR;
2741: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2742: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2743: END IF;
2744:
2745:
2746: -- BUG Fix 2338145

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

2756:
2757: l_current_order_value := 0 ;
2758:
2759: IF NVL(p_calling_action, 'BOOKING') = 'BOOKING'
2760: and NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) =
2761: FND_API.G_FALSE
2762: THEN
2763: l_current_order_value :=
2764: NVL(OE_CREDIT_CHECK_UTIL.g_current_order_value,0) ;

Line 2761: FND_API.G_FALSE

2757: l_current_order_value := 0 ;
2758:
2759: IF NVL(p_calling_action, 'BOOKING') = 'BOOKING'
2760: and NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) =
2761: FND_API.G_FALSE
2762: THEN
2763: l_current_order_value :=
2764: NVL(OE_CREDIT_CHECK_UTIL.g_current_order_value,0) ;
2765: ELSE

Line 2830: x_return_status := FND_API.G_RET_STS_ERROR;

2826: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
2827:
2828:
2829: OE_MSG_PUB.ADD;
2830: x_return_status := FND_API.G_RET_STS_ERROR;
2831: OE_DEBUG_PUB.ADD('Return status after assigned as Error = '
2832: || x_return_status );
2833: END IF;
2834:

Line 2856: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2852: OE_DEBUG_PUB.Add('OEXVCRLB: Out CHECK_ORDER_LINES_EXPOSURE');
2853: END IF;
2854: EXCEPTION
2855: WHEN others THEN
2856: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2857: OE_DEBUG_PUB.Add('CHECK_ORDER_LINES_EXPOSURE: Other exceptions');
2858: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2859: OE_MSG_PUB.Add_Exc_Msg
2860: ( G_PKG_NAME

Line 2864: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2860: ( G_PKG_NAME
2861: , 'CHECK_ORDER_LINES_EXPOSURE'
2862: );
2863: END IF;
2864: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2865: OE_DEBUG_PUB.ADD( SUBSTR(SQLERRM,1,300) ,1 );
2866: END CHECK_ORDER_LINES_EXPOSURE;
2867:
2868: -----------------------------------------------------------

Line 2905: x_return_status := FND_API.G_RET_STS_SUCCESS;

2901: BEGIN
2902: OE_DEBUG_PUB.Add('OEXVCRLB: In Check_Item_Limits');
2903: --
2904: -- Initialize return status to success
2905: x_return_status := FND_API.G_RET_STS_SUCCESS;
2906: -- Default to Pass
2907: l_cc_result_out := 'PASS';
2908: l_credit_hold_level := p_credit_check_rule_rec.CREDIT_HOLD_LEVEL_CODE ;
2909: -- Need to use new get_item_limits api

Line 3072: x_return_status := FND_API.G_RET_STS_ERROR;

3068: FND_MESSAGE.Set_Token('CONV',
3069: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
3070:
3071: OE_MSG_PUB.ADD ;
3072: x_return_status := FND_API.G_RET_STS_ERROR;
3073: OE_DEBUG_PUB.ADD('Return status after assigned as Error = '
3074: || x_return_status );
3075: END IF;
3076:

Line 3082: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3078: END;
3079:
3080: WHEN others THEN
3081: OE_DEBUG_PUB.Add('Check_Item_Limit: Other exceptions');
3082: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3083: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3084: OE_MSG_PUB.Add_Exc_Msg
3085: ( G_PKG_NAME
3086: , 'Check_Item_Limits'

Line 3213: x_return_status := FND_API.G_RET_STS_SUCCESS;

3209: --
3210: -- Set the default behavior to pass credit check
3211: --
3212: x_cc_result_out := 'PASS';
3213: x_return_status := FND_API.G_RET_STS_SUCCESS;
3214: l_credit_hold_level := p_credit_check_rule_rec.CREDIT_HOLD_LEVEL_CODE ;
3215: x_global_exposure_flag := 'N' ;
3216:
3217: l_cc_result_out := 'PASS';

Line 3404: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

3400: l_credit_limit_entity_id );
3401: OE_DEBUG_PUB.Add(' l_check_order = '|| l_check_order );
3402: END IF;
3403:
3404: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3405: RAISE FND_API.G_EXC_ERROR;
3406: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3408: END IF;

Line 3405: RAISE FND_API.G_EXC_ERROR;

3401: OE_DEBUG_PUB.Add(' l_check_order = '|| l_check_order );
3402: END IF;
3403:
3404: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3405: RAISE FND_API.G_EXC_ERROR;
3406: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3408: END IF;
3409:

Line 3406: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3402: END IF;
3403:
3404: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3405: RAISE FND_API.G_EXC_ERROR;
3406: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3408: END IF;
3409:
3410:

Line 3407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3403:
3404: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3405: RAISE FND_API.G_EXC_ERROR;
3406: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3408: END IF;
3409:
3410:
3411: --

Line 3475: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

3471: --ER8880886
3472: END IF;
3473:
3474:
3475: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3476: RAISE FND_API.G_EXC_ERROR;
3477: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3478: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3479: END IF;

Line 3476: RAISE FND_API.G_EXC_ERROR;

3472: END IF;
3473:
3474:
3475: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3476: RAISE FND_API.G_EXC_ERROR;
3477: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3478: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3479: END IF;
3480:

Line 3477: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3473:
3474:
3475: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3476: RAISE FND_API.G_EXC_ERROR;
3477: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3478: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3479: END IF;
3480:
3481: -- IF l_cc_result_out = 'PASS' THEN

Line 3478: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3474:
3475: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3476: RAISE FND_API.G_EXC_ERROR;
3477: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3478: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3479: END IF;
3480:
3481: -- IF l_cc_result_out = 'PASS' THEN
3482: -- Changed IF condition to fix bug 4002820, need to do overall

Line 3558: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

3554:
3555: END IF;
3556: END IF;
3557:
3558: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3559: RAISE FND_API.G_EXC_ERROR;
3560: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3561: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3562: END IF;

Line 3559: RAISE FND_API.G_EXC_ERROR;

3555: END IF;
3556: END IF;
3557:
3558: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3559: RAISE FND_API.G_EXC_ERROR;
3560: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3561: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3562: END IF;
3563:

Line 3560: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3556: END IF;
3557:
3558: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3559: RAISE FND_API.G_EXC_ERROR;
3560: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3561: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3562: END IF;
3563:
3564: -- IF l_cc_result_out = 'PASS' THEN

Line 3561: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3557:
3558: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3559: RAISE FND_API.G_EXC_ERROR;
3560: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3561: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3562: END IF;
3563:
3564: -- IF l_cc_result_out = 'PASS' THEN
3565: -- Changed IF condition to fix bug 4002820, need to do overall

Line 3672: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

3668: -- customer exposure already checked, retrieve the result
3669: l_cc_result_out := l_customer_result_out;
3670: END IF;
3671:
3672: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3673: RAISE FND_API.G_EXC_ERROR;
3674: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3676: END IF;

Line 3673: RAISE FND_API.G_EXC_ERROR;

3669: l_cc_result_out := l_customer_result_out;
3670: END IF;
3671:
3672: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3673: RAISE FND_API.G_EXC_ERROR;
3674: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3676: END IF;
3677:

Line 3674: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3670: END IF;
3671:
3672: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3673: RAISE FND_API.G_EXC_ERROR;
3674: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3676: END IF;
3677:
3678: IF l_cc_overall_result_out = 'FAIL' THEN

Line 3675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3671:
3672: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3673: RAISE FND_API.G_EXC_ERROR;
3674: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3676: END IF;
3677:
3678: IF l_cc_overall_result_out = 'FAIL' THEN
3679: l_cc_result_out := l_cc_overall_result_out;

Line 3866: , p_init_msg_list => FND_API.G_FALSE

3862: END IF;
3863: ----------------Submit Credit Review--------------------
3864: AR_CMGT_CREDIT_REQUEST_API.Create_credit_request
3865: ( p_api_version => 1.0
3866: , p_init_msg_list => FND_API.G_FALSE
3867: , p_commit => FND_API.G_FALSE
3868: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
3869: , x_return_status => x_return_status
3870: , x_msg_count => l_msg_count

Line 3867: , p_commit => FND_API.G_FALSE

3863: ----------------Submit Credit Review--------------------
3864: AR_CMGT_CREDIT_REQUEST_API.Create_credit_request
3865: ( p_api_version => 1.0
3866: , p_init_msg_list => FND_API.G_FALSE
3867: , p_commit => FND_API.G_FALSE
3868: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
3869: , x_return_status => x_return_status
3870: , x_msg_count => l_msg_count
3871: , x_msg_data => l_msg_data

Line 3868: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

3864: AR_CMGT_CREDIT_REQUEST_API.Create_credit_request
3865: ( p_api_version => 1.0
3866: , p_init_msg_list => FND_API.G_FALSE
3867: , p_commit => FND_API.G_FALSE
3868: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
3869: , x_return_status => x_return_status
3870: , x_msg_count => l_msg_count
3871: , x_msg_data => l_msg_data
3872: , p_application_number => NULL

Line 4006: WHEN FND_API.G_EXC_ERROR THEN

4002: END IF;
4003:
4004:
4005: EXCEPTION
4006: WHEN FND_API.G_EXC_ERROR THEN
4007: x_return_status := FND_API.G_RET_STS_ERROR;
4008: RAISE FND_API.G_EXC_ERROR;
4009: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4010: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4007: x_return_status := FND_API.G_RET_STS_ERROR;

4003:
4004:
4005: EXCEPTION
4006: WHEN FND_API.G_EXC_ERROR THEN
4007: x_return_status := FND_API.G_RET_STS_ERROR;
4008: RAISE FND_API.G_EXC_ERROR;
4009: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4010: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4011: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4008: RAISE FND_API.G_EXC_ERROR;

4004:
4005: EXCEPTION
4006: WHEN FND_API.G_EXC_ERROR THEN
4007: x_return_status := FND_API.G_RET_STS_ERROR;
4008: RAISE FND_API.G_EXC_ERROR;
4009: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4010: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4011: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4012: WHEN OTHERS THEN

Line 4009: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4005: EXCEPTION
4006: WHEN FND_API.G_EXC_ERROR THEN
4007: x_return_status := FND_API.G_RET_STS_ERROR;
4008: RAISE FND_API.G_EXC_ERROR;
4009: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4010: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4011: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4012: WHEN OTHERS THEN
4013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4010: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4006: WHEN FND_API.G_EXC_ERROR THEN
4007: x_return_status := FND_API.G_RET_STS_ERROR;
4008: RAISE FND_API.G_EXC_ERROR;
4009: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4010: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4011: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4012: WHEN OTHERS THEN
4013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4014: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 4011: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4007: x_return_status := FND_API.G_RET_STS_ERROR;
4008: RAISE FND_API.G_EXC_ERROR;
4009: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4010: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4011: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4012: WHEN OTHERS THEN
4013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4014: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4015: OE_MSG_PUB.Add_Exc_Msg

Line 4013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4009: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4010: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4011: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4012: WHEN OTHERS THEN
4013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4014: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4015: OE_MSG_PUB.Add_Exc_Msg
4016: ( G_PKG_NAME, 'Check_Other_Credit_Limits');
4017: END IF;

Line 4055: x_return_status := FND_API.G_RET_STS_SUCCESS;

4051: OE_DEBUG_PUB.Add('start Loop for holds table');
4052: OE_DEBUG_PUB.Add('p_check_exposure_mode => '|| p_check_exposure_mode );
4053: END IF;
4054:
4055: x_return_status := FND_API.G_RET_STS_SUCCESS;
4056: --
4057: -- Get the order number for notification
4058: --
4059:

Line 4183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4179: OE_DEBUG_PUB.Add('OEXVCRLB: Out Apply_And_Release_Holds');
4180: END IF;
4181: EXCEPTION
4182: WHEN others THEN
4183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4184: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4185: OE_MSG_PUB.Add_Exc_Msg
4186: ( G_PKG_NAME
4187: , 'Apply_And_Release_Holds'

Line 4313: x_return_status := FND_API.G_RET_STS_SUCCESS;

4309: --
4310: -- Set the default behavior to pass credit check
4311: --
4312: x_cc_result_out := 'NOCHECK';
4313: x_return_status := FND_API.G_RET_STS_SUCCESS;
4314: l_global_exposure_flag := 'N' ;
4315:
4316: G_result_out := 'PASS' ;
4317: G_release_status := 'NO' ;

Line 4385: IF NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) = FND_API.G_TRUE

4381:
4382: --ER 12363706 start
4383:
4384: -- Call Tolerance check for LINE level credit checking and ORDER level hold
4385: IF NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) = FND_API.G_TRUE
4386: THEN
4387: IF l_credit_hold_level = 'ORDER'
4388: THEN
4389: oe_debug_pub.ADD('OEXVCRLB: Credit check at Order Level');

Line 4425: IF NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) = FND_API.G_TRUE

4421: END IF;
4422: END IF;
4423:
4424: -- Call Tolerance check if LINE level credit checking and LINE level hold
4425: IF NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) = FND_API.G_TRUE
4426: THEN
4427: IF l_credit_hold_level = 'LINE'
4428: THEN
4429: oe_debug_pub.ADD('OEXVCRLB: Credit check at Line Level');

Line 4593: x_return_status := FND_API.G_RET_STS_SUCCESS;

4589: );
4590:
4591: ELSE
4592: l_cc_result_out := 'PASS' ;
4593: x_return_status := FND_API.G_RET_STS_SUCCESS;
4594:
4595: IF G_debug_flag = 'Y'
4596: THEN
4597: OE_DEBUG_PUB.Add(' No check item categories, Flag OFF ');

Line 4603: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

4599:
4600: END IF;
4601:
4602:
4603: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4604: RAISE FND_API.G_EXC_ERROR;
4605: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4607: END IF;

Line 4604: RAISE FND_API.G_EXC_ERROR;

4600: END IF;
4601:
4602:
4603: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4604: RAISE FND_API.G_EXC_ERROR;
4605: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4607: END IF;
4608: --

Line 4605: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4601:
4602:
4603: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4604: RAISE FND_API.G_EXC_ERROR;
4605: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4607: END IF;
4608: --
4609: -- Apply the database hold and Exit the bill-to site loop if

Line 4606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4602:
4603: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4604: RAISE FND_API.G_EXC_ERROR;
4605: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4607: END IF;
4608: --
4609: -- Apply the database hold and Exit the bill-to site loop if
4610: -- credit hold level is ORDER and the order failed credit check.

Line 4669: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

4665: || x_return_status );
4666: END IF;
4667:
4668:
4669: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4670: RAISE FND_API.G_EXC_ERROR;
4671: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4672: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4673: END IF;

Line 4670: RAISE FND_API.G_EXC_ERROR;

4666: END IF;
4667:
4668:
4669: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4670: RAISE FND_API.G_EXC_ERROR;
4671: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4672: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4673: END IF;
4674:

Line 4671: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4667:
4668:
4669: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4670: RAISE FND_API.G_EXC_ERROR;
4671: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4672: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4673: END IF;
4674:
4675: -- Apply order level credit hold to the database if it necessary

Line 4672: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4668:
4669: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4670: RAISE FND_API.G_EXC_ERROR;
4671: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4672: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4673: END IF;
4674:
4675: -- Apply order level credit hold to the database if it necessary
4676:

Line 4715: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

4711: , x_return_status => x_return_status
4712: );
4713:
4714:
4715: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4716: RAISE FND_API.G_EXC_ERROR;
4717: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4719: END IF;

Line 4716: RAISE FND_API.G_EXC_ERROR;

4712: );
4713:
4714:
4715: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4716: RAISE FND_API.G_EXC_ERROR;
4717: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4719: END IF;
4720: END IF;

Line 4717: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4713:
4714:
4715: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4716: RAISE FND_API.G_EXC_ERROR;
4717: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4719: END IF;
4720: END IF;
4721:

Line 4718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4714:
4715: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4716: RAISE FND_API.G_EXC_ERROR;
4717: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4719: END IF;
4720: END IF;
4721:
4722: ------------------------- Credit review ------------

Line 4820: , p_init_msg_list => FND_API.G_FALSE

4816: END IF;
4817: ----------------Submit Credit Review--------------------
4818: AR_CMGT_CREDIT_REQUEST_API.Create_credit_request
4819: ( p_api_version => 1.0
4820: , p_init_msg_list => FND_API.G_FALSE
4821: , p_commit => FND_API.G_FALSE
4822: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
4823: , x_return_status => x_return_status
4824: , x_msg_count => l_msg_count

Line 4821: , p_commit => FND_API.G_FALSE

4817: ----------------Submit Credit Review--------------------
4818: AR_CMGT_CREDIT_REQUEST_API.Create_credit_request
4819: ( p_api_version => 1.0
4820: , p_init_msg_list => FND_API.G_FALSE
4821: , p_commit => FND_API.G_FALSE
4822: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
4823: , x_return_status => x_return_status
4824: , x_msg_count => l_msg_count
4825: , x_msg_data => l_msg_data

Line 4822: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

4818: AR_CMGT_CREDIT_REQUEST_API.Create_credit_request
4819: ( p_api_version => 1.0
4820: , p_init_msg_list => FND_API.G_FALSE
4821: , p_commit => FND_API.G_FALSE
4822: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
4823: , x_return_status => x_return_status
4824: , x_msg_count => l_msg_count
4825: , x_msg_data => l_msg_data
4826: , p_application_number => NULL

Line 4988: --OR( NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) =

4984: -- OE_MSG_PUB.Delete_Msg(OE_MSG_PUB.G_msg_count);
4985:
4986: -- added OR condition for bug 5467793
4987: IF x_cc_result_out = 'FAIL'
4988: --OR( NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) =
4989: --FND_API.G_TRUE AND x_cc_result_out IN ('FAIL_HOLD', 'FAIL_NONE'))
4990: THEN
4991: -- Display the general message for the user on the screen
4992:

Line 4989: --FND_API.G_TRUE AND x_cc_result_out IN ('FAIL_HOLD', 'FAIL_NONE'))

4985:
4986: -- added OR condition for bug 5467793
4987: IF x_cc_result_out = 'FAIL'
4988: --OR( NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) =
4989: --FND_API.G_TRUE AND x_cc_result_out IN ('FAIL_HOLD', 'FAIL_NONE'))
4990: THEN
4991: -- Display the general message for the user on the screen
4992:
4993: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_GENERAL_MSG');

Line 5015: WHEN FND_API.G_EXC_ERROR THEN

5011: OE_DEBUG_PUB.Add('OEXVCRLB: Out Check_order_lines_credit API',1);
5012: END IF;
5013:
5014: EXCEPTION
5015: WHEN FND_API.G_EXC_ERROR THEN
5016: x_return_status := FND_API.G_RET_STS_ERROR;
5017: OE_CREDIT_ENGINE_GRP.TOLERANCE_CHECK_REQUIRED := TRUE; --ER 12363706
5018: OE_CREDIT_CHECK_UTIL.G_CC_Invoice_tab.delete; --13706069
5019: OE_DEBUG_PUB.Add('Check_order_lines_credit: Error ',1);

Line 5016: x_return_status := FND_API.G_RET_STS_ERROR;

5012: END IF;
5013:
5014: EXCEPTION
5015: WHEN FND_API.G_EXC_ERROR THEN
5016: x_return_status := FND_API.G_RET_STS_ERROR;
5017: OE_CREDIT_ENGINE_GRP.TOLERANCE_CHECK_REQUIRED := TRUE; --ER 12363706
5018: OE_CREDIT_CHECK_UTIL.G_CC_Invoice_tab.delete; --13706069
5019: OE_DEBUG_PUB.Add('Check_order_lines_credit: Error ',1);
5020:

Line 5021: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5017: OE_CREDIT_ENGINE_GRP.TOLERANCE_CHECK_REQUIRED := TRUE; --ER 12363706
5018: OE_CREDIT_CHECK_UTIL.G_CC_Invoice_tab.delete; --13706069
5019: OE_DEBUG_PUB.Add('Check_order_lines_credit: Error ',1);
5020:
5021: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5023: OE_CREDIT_ENGINE_GRP.TOLERANCE_CHECK_REQUIRED := TRUE; --ER 12363706
5024: OE_CREDIT_CHECK_UTIL.G_CC_Invoice_tab.delete; --13706069
5025: OE_DEBUG_PUB.Add('Check_order_lines_credit: Unexpected Error ',1);

Line 5022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5018: OE_CREDIT_CHECK_UTIL.G_CC_Invoice_tab.delete; --13706069
5019: OE_DEBUG_PUB.Add('Check_order_lines_credit: Error ',1);
5020:
5021: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5023: OE_CREDIT_ENGINE_GRP.TOLERANCE_CHECK_REQUIRED := TRUE; --ER 12363706
5024: OE_CREDIT_CHECK_UTIL.G_CC_Invoice_tab.delete; --13706069
5025: OE_DEBUG_PUB.Add('Check_order_lines_credit: Unexpected Error ',1);
5026: WHEN OTHERS THEN

Line 5027: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5023: OE_CREDIT_ENGINE_GRP.TOLERANCE_CHECK_REQUIRED := TRUE; --ER 12363706
5024: OE_CREDIT_CHECK_UTIL.G_CC_Invoice_tab.delete; --13706069
5025: OE_DEBUG_PUB.Add('Check_order_lines_credit: Unexpected Error ',1);
5026: WHEN OTHERS THEN
5027: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5028: OE_CREDIT_ENGINE_GRP.TOLERANCE_CHECK_REQUIRED := TRUE; --ER 12363706
5029: OE_CREDIT_CHECK_UTIL.G_CC_Invoice_tab.delete; --13706069
5030: OE_DEBUG_PUB.Add('Check_order_lines_credit: Other Unexpected Error ',1);
5031: OE_DEBUG_PUB.ADD( SUBSTR(SQLERRM,1,300),1 ) ;