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 102: , p_validation_level => FND_API.G_VALID_LEVEL_NONE

98:
99:
100: OE_Holds_PUB.Apply_Holds
101: ( p_api_version => 1.0
102: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
103: , p_hold_source_rec => p_hold_source_rec
104: , x_msg_count => x_msg_count
105: , x_msg_data => x_msg_data
106: , x_return_status => x_return_status

Line 111: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

107: );
108:
109: OE_DEBUG_PUB.ADD(' Out OE_Holds_PUB.Apply_Holds ');
110: OE_DEBUG_PUB.ADD(' x_return_status => '|| x_return_status );
111: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
112: RAISE FND_API.G_EXC_ERROR;
113: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
115: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 112: RAISE FND_API.G_EXC_ERROR;

108:
109: OE_DEBUG_PUB.ADD(' Out OE_Holds_PUB.Apply_Holds ');
110: OE_DEBUG_PUB.ADD(' x_return_status => '|| x_return_status );
111: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
112: RAISE FND_API.G_EXC_ERROR;
113: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
115: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
116:

Line 113: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

109: OE_DEBUG_PUB.ADD(' Out OE_Holds_PUB.Apply_Holds ');
110: OE_DEBUG_PUB.ADD(' x_return_status => '|| x_return_status );
111: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
112: RAISE FND_API.G_EXC_ERROR;
113: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
115: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
116:
117: OE_DEBUG_PUB.ADD(' Holds success ');

Line 114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

110: OE_DEBUG_PUB.ADD(' x_return_status => '|| x_return_status );
111: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
112: RAISE FND_API.G_EXC_ERROR;
113: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
115: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
116:
117: OE_DEBUG_PUB.ADD(' Holds success ');
118: OE_DEBUG_PUB.ADD(' About to Issue COMMIT');

Line 115: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

111: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
112: RAISE FND_API.G_EXC_ERROR;
113: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
115: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
116:
117: OE_DEBUG_PUB.ADD(' Holds success ');
118: OE_DEBUG_PUB.ADD(' About to Issue COMMIT');
119:

Line 175: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

171: OE_DEBUG_PUB.ADD('OEXVCRLB: After OE_Holds_PUB.Update_Hold_Comments Status '
172: || x_return_status);
173: END IF;
174:
175: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
176: RAISE FND_API.G_EXC_ERROR;
177: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
179: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 176: RAISE FND_API.G_EXC_ERROR;

172: || x_return_status);
173: END IF;
174:
175: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
176: RAISE FND_API.G_EXC_ERROR;
177: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
179: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
180: IF G_debug_flag = 'Y'

Line 177: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

173: END IF;
174:
175: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
176: RAISE FND_API.G_EXC_ERROR;
177: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
179: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
180: IF G_debug_flag = 'Y'
181: THEN

Line 178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

174:
175: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
176: RAISE FND_API.G_EXC_ERROR;
177: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
179: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
180: IF G_debug_flag = 'Y'
181: THEN
182: OE_DEBUG_PUB.ADD('OEXVCRLB: Update Hold Comment Success, Issue COMMIT');

Line 179: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

175: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
176: RAISE FND_API.G_EXC_ERROR;
177: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
179: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
180: IF G_debug_flag = 'Y'
181: THEN
182: OE_DEBUG_PUB.ADD('OEXVCRLB: Update Hold Comment Success, Issue COMMIT');
183: END IF;

Line 486: x_return_status := FND_API.G_RET_STS_SUCCESS;

482: END IF;
483:
484:
485: -- Initialize return status to success
486: x_return_status := FND_API.G_RET_STS_SUCCESS;
487:
488: IF p_line_id IS NULL THEN
489: -- Update the whole table.
490: FOR i IN 1..p_holds_table.COUNT

Line 554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

550: END IF;
551:
552: EXCEPTION
553: WHEN OTHERS THEN
554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
555: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
556: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Update_Holds_Table');
557: END IF;
558: RAISE;

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

666: -- Will not check if the event is UPDATE
667:
668: -- Adding 'AUTO HOLD' for bug# 4207478
669: IF p_calling_action IN ( 'SHIPPING' , 'PACKING' , 'PICKING', 'AUTO HOLD')
670: AND NVL(OE_credit_engine_grp.G_delayed_request, FND_API.G_FALSE )
671: = FND_API.G_FALSE
672: THEN
673: BEGIN
674: IF p_credit_hold_level = 'ORDER'

Line 671: = FND_API.G_FALSE

667:
668: -- Adding 'AUTO HOLD' for bug# 4207478
669: IF p_calling_action IN ( 'SHIPPING' , 'PACKING' , 'PICKING', 'AUTO HOLD')
670: AND NVL(OE_credit_engine_grp.G_delayed_request, FND_API.G_FALSE )
671: = FND_API.G_FALSE
672: THEN
673: BEGIN
674: IF p_credit_hold_level = 'ORDER'
675: THEN

Line 792: x_return_status := FND_API.G_RET_STS_SUCCESS;

788: OE_DEBUG_PUB.ADD('OEXVCRLB: In Chk_Past_Due_Invoice');
789: END IF;
790:
791: -- Initialize return status to success
792: x_return_status := FND_API.G_RET_STS_SUCCESS;
793: -- Default to pass
794: x_cc_result_out := 'PASS';
795:
796:

Line 813: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 814: RAISE FND_API.G_EXC_ERROR;

810: );
811:
812:
813: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
814: RAISE FND_API.G_EXC_ERROR;
815: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
816: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
817: END IF;
818:

Line 815: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

811:
812:
813: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
814: RAISE FND_API.G_EXC_ERROR;
815: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
816: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
817: END IF;
818:
819: IF l_exist_flag = 'Y'

Line 816: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

812:
813: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
814: RAISE FND_API.G_EXC_ERROR;
815: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
816: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
817: END IF;
818:
819: IF l_exist_flag = 'Y'
820: THEN

Line 833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

829: END IF;
830:
831: EXCEPTION
832: WHEN OTHERS THEN
833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
834: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
835: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Chk_Past_Due_invoice');
836: END IF;
837: END Chk_Past_Due_Invoice;

Line 909: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

905: THEN
906: OE_DEBUG_PUB.ADD('OEXVCRLB: Out Check_Holds');
907: END IF;
908:
909: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
910: RAISE FND_API.G_EXC_ERROR;
911: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
912: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
913: END IF;

Line 910: RAISE FND_API.G_EXC_ERROR;

906: OE_DEBUG_PUB.ADD('OEXVCRLB: Out Check_Holds');
907: END IF;
908:
909: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
910: RAISE FND_API.G_EXC_ERROR;
911: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
912: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
913: END IF;
914:

Line 911: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

907: END IF;
908:
909: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
910: RAISE FND_API.G_EXC_ERROR;
911: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
912: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
913: END IF;
914:
915: IF l_hold_result = FND_API.G_TRUE THEN

Line 912: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

908:
909: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
910: RAISE FND_API.G_EXC_ERROR;
911: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
912: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
913: END IF;
914:
915: IF l_hold_result = FND_API.G_TRUE THEN
916: return TRUE;

Line 915: IF l_hold_result = FND_API.G_TRUE THEN

911: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
912: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
913: END IF;
914:
915: IF l_hold_result = FND_API.G_TRUE THEN
916: return TRUE;
917: ELSE
918: return FALSE;
919: END IF;

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

957:
958: -- Write to message stack anyway regardless of the calling action
959: -- added IF for bug 5467793
960: --bug 7207292, reverting fix 5467793 as multiple messages are now shown in processing messages window
961: --IF NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) =
962: -- FND_API.G_FALSE THEN
963: IF p_cc_limit_used <> 'ITEM' THEN
964: -- bug 4002820
965: IF INSTR(p_cc_limit_used, ',') > 0 THEN

Line 962: -- FND_API.G_FALSE THEN

958: -- Write to message stack anyway regardless of the calling action
959: -- added IF for bug 5467793
960: --bug 7207292, reverting fix 5467793 as multiple messages are now shown in processing messages window
961: --IF NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) =
962: -- FND_API.G_FALSE THEN
963: IF p_cc_limit_used <> 'ITEM' THEN
964: -- bug 4002820
965: IF INSTR(p_cc_limit_used, ',') > 0 THEN
966: l_cc_profile_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_PROFILE', p_cc_profile_used);

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

1432: IF G_debug_flag = 'Y'
1433: THEN
1434: OE_DEBUG_PUB.ADD('OEXVCRLB: Call Update_Comments_And_Commit');
1435: END IF;
1436: --IF NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) =
1437: --FND_API.G_FALSE THEN --bug6120327
1438:
1439: Update_Comments_And_Commit
1440: ( p_hold_source_rec => l_hold_source_rec

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

1433: THEN
1434: OE_DEBUG_PUB.ADD('OEXVCRLB: Call Update_Comments_And_Commit');
1435: END IF;
1436: --IF NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) =
1437: --FND_API.G_FALSE THEN --bug6120327
1438:
1439: Update_Comments_And_Commit
1440: ( p_hold_source_rec => l_hold_source_rec
1441: , x_msg_count => l_msg_count

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

1454: IF G_debug_flag = 'Y'
1455: THEN
1456: OE_DEBUG_PUB.ADD('OEXVCRLB: Call OE_Holds_PUB.Update_Hold_Comments directly');
1457: END IF;
1458: --IF NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) =
1459: --FND_API.G_FALSE THEN --bug6120327
1460:
1461: OE_Holds_PUB.Update_Hold_comments
1462: ( p_hold_source_rec => l_hold_source_rec

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

1455: THEN
1456: OE_DEBUG_PUB.ADD('OEXVCRLB: Call OE_Holds_PUB.Update_Hold_Comments directly');
1457: END IF;
1458: --IF NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) =
1459: --FND_API.G_FALSE THEN --bug6120327
1460:
1461: OE_Holds_PUB.Update_Hold_comments
1462: ( p_hold_source_rec => l_hold_source_rec
1463: , x_msg_count => l_msg_count

Line 1476: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1472: OE_DEBUG_PUB.ADD('OEXVCRLB: Out OE_Holds_PUB.Update_Hold_Comments directly');
1473: END IF;
1474: END IF;
1475:
1476: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1477: RAISE FND_API.G_EXC_ERROR;
1478: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1479: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1480: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 1477: RAISE FND_API.G_EXC_ERROR;

1473: END IF;
1474: END IF;
1475:
1476: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1477: RAISE FND_API.G_EXC_ERROR;
1478: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1479: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1480: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1481: IF G_debug_flag = 'Y' THEN

Line 1478: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1474: END IF;
1475:
1476: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1477: RAISE FND_API.G_EXC_ERROR;
1478: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1479: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1480: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1481: IF G_debug_flag = 'Y' THEN
1482: OE_DEBUG_PUB.ADD

Line 1479: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1475:
1476: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1477: RAISE FND_API.G_EXC_ERROR;
1478: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1479: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1480: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1481: IF G_debug_flag = 'Y' THEN
1482: OE_DEBUG_PUB.ADD
1483: ('OEXVCRLB: Updated Comments on Header/Line ID:' ||

Line 1480: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1476: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1477: RAISE FND_API.G_EXC_ERROR;
1478: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1479: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1480: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1481: IF G_debug_flag = 'Y' THEN
1482: OE_DEBUG_PUB.ADD
1483: ('OEXVCRLB: Updated Comments on Header/Line ID:' ||
1484: p_header_id || '/' ||

Line 1548: , p_validation_level => FND_API.G_VALID_LEVEL_NONE

1544: END IF;
1545:
1546: OE_Holds_PUB.Apply_Holds
1547: ( p_api_version => 1.0
1548: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
1549: , p_hold_source_rec => l_hold_source_rec
1550: , x_msg_count => l_msg_count
1551: , x_msg_data => l_msg_data
1552: , x_return_status => l_return_status

Line 1565: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1561: IF G_debug_flag = 'Y' THEN
1562: OE_DEBUG_PUB.ADD('OEXVCRLB: Apply Holds status '|| l_return_status );
1563: END IF;
1564:
1565: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1566: RAISE FND_API.G_EXC_ERROR;
1567: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1569: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 1566: RAISE FND_API.G_EXC_ERROR;

1562: OE_DEBUG_PUB.ADD('OEXVCRLB: Apply Holds status '|| l_return_status );
1563: END IF;
1564:
1565: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1566: RAISE FND_API.G_EXC_ERROR;
1567: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1569: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1570: IF G_debug_flag = 'Y' THEN

Line 1567: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1563: END IF;
1564:
1565: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1566: RAISE FND_API.G_EXC_ERROR;
1567: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1569: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1570: IF G_debug_flag = 'Y' THEN
1571: OE_DEBUG_PUB.ADD

Line 1568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1564:
1565: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1566: RAISE FND_API.G_EXC_ERROR;
1567: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1569: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1570: IF G_debug_flag = 'Y' THEN
1571: OE_DEBUG_PUB.ADD
1572: ('OEXVCRLB: Applied credit check hold on Header/Line ID:' ||

Line 1569: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1565: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1566: RAISE FND_API.G_EXC_ERROR;
1567: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1569: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1570: IF G_debug_flag = 'Y' THEN
1571: OE_DEBUG_PUB.ADD
1572: ('OEXVCRLB: Applied credit check hold on Header/Line ID:' ||
1573: p_header_id || '/' ||

Line 1714: , p_validation_level => FND_API.G_VALID_LEVEL_NONE

1710:
1711: IF NVL(p_calling_action, 'BOOKING') <> 'AUTO RELEASE' THEN
1712: OE_Holds_PUB.Apply_Holds
1713: ( p_api_version => 1.0
1714: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
1715: , p_hold_source_rec => l_hold_source_rec
1716: , x_msg_count => l_msg_count
1717: , x_msg_data => l_msg_data
1718: , x_return_status => l_return_status

Line 1721: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1717: , x_msg_data => l_msg_data
1718: , x_return_status => l_return_status
1719: );
1720:
1721: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1722: RAISE FND_API.G_EXC_ERROR;
1723: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1725: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 1722: RAISE FND_API.G_EXC_ERROR;

1718: , x_return_status => l_return_status
1719: );
1720:
1721: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1722: RAISE FND_API.G_EXC_ERROR;
1723: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1725: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1726: IF G_debug_flag = 'Y' THEN

Line 1723: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1719: );
1720:
1721: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1722: RAISE FND_API.G_EXC_ERROR;
1723: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1725: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1726: IF G_debug_flag = 'Y' THEN
1727: OE_DEBUG_PUB.ADD

Line 1724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1720:
1721: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1722: RAISE FND_API.G_EXC_ERROR;
1723: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1725: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1726: IF G_debug_flag = 'Y' THEN
1727: OE_DEBUG_PUB.ADD
1728: ('OEXVCRLB: Credit check hold applied on header_ID: '||p_header_id, 1);

Line 1725: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1721: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1722: RAISE FND_API.G_EXC_ERROR;
1723: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1725: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1726: IF G_debug_flag = 'Y' THEN
1727: OE_DEBUG_PUB.ADD
1728: ('OEXVCRLB: Credit check hold applied on header_ID: '||p_header_id, 1);
1729: END IF;

Line 1787: l_return_status := FND_API.G_RET_STS_SUCCESS;

1783: THEN
1784: OE_DEBUG_PUB.Add('OEXVCRLB: In Release_Order_CC_Hold');
1785: END IF;
1786:
1787: l_return_status := FND_API.G_RET_STS_SUCCESS;
1788: --
1789: -- Release credit hold if the calling action is not BOOKING and not
1790: -- UPDATE with background credit check set.
1791: --

Line 1831: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1827: , x_msg_count => l_msg_count
1828: , x_msg_data => l_msg_data
1829: , x_return_status => l_return_status
1830: );
1831: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1832: RAISE FND_API.G_EXC_ERROR;
1833: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1835: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN

Line 1832: RAISE FND_API.G_EXC_ERROR;

1828: , x_msg_data => l_msg_data
1829: , x_return_status => l_return_status
1830: );
1831: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1832: RAISE FND_API.G_EXC_ERROR;
1833: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1835: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
1836: Write_Order_Release_Msg(

Line 1833: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1829: , x_return_status => l_return_status
1830: );
1831: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1832: RAISE FND_API.G_EXC_ERROR;
1833: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1835: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
1836: Write_Order_Release_Msg(
1837: p_calling_action => p_calling_action

Line 1834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1830: );
1831: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1832: RAISE FND_API.G_EXC_ERROR;
1833: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1835: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
1836: Write_Order_Release_Msg(
1837: p_calling_action => p_calling_action
1838: , p_order_number => p_order_number

Line 1835: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN

1831: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1832: RAISE FND_API.G_EXC_ERROR;
1833: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1835: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
1836: Write_Order_Release_Msg(
1837: p_calling_action => p_calling_action
1838: , p_order_number => p_order_number
1839: );

Line 1887: l_return_status := FND_API.G_RET_STS_SUCCESS;

1883: THEN
1884: OE_DEBUG_PUB.Add('OEXVCRLB: In Apply_Item_Category_Holds');
1885: END IF;
1886:
1887: l_return_status := FND_API.G_RET_STS_SUCCESS;
1888: FOR i IN 1..p_lines.count LOOP
1889: IF p_item_category_id = p_lines(i).item_category_id THEN
1890: OE_DEBUG_PUB.Add('Line ID '||p_lines(i).line_id
1891: ||' fails ITEM limit ck',1);

Line 1901: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1897: , p_cc_profile_used => 'CATEGORY'
1898: , p_item_category_id => p_item_category_id
1899: , x_return_status => l_return_status
1900: );
1901: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1902: RAISE FND_API.G_EXC_ERROR;
1903: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1904: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1905: END IF;

Line 1902: RAISE FND_API.G_EXC_ERROR;

1898: , p_item_category_id => p_item_category_id
1899: , x_return_status => l_return_status
1900: );
1901: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1902: RAISE FND_API.G_EXC_ERROR;
1903: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1904: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1905: END IF;
1906: END IF;

Line 1903: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1899: , x_return_status => l_return_status
1900: );
1901: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1902: RAISE FND_API.G_EXC_ERROR;
1903: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1904: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1905: END IF;
1906: END IF;
1907: END LOOP;

Line 1904: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1900: );
1901: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1902: RAISE FND_API.G_EXC_ERROR;
1903: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1904: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1905: END IF;
1906: END IF;
1907: END LOOP;
1908:

Line 2007: l_return_status := FND_API.G_RET_STS_SUCCESS;

2003: OE_DEBUG_PUB.ADD('Processing line ID = '||
2004: p_line_id );
2005: END IF;
2006:
2007: l_return_status := FND_API.G_RET_STS_SUCCESS;
2008:
2009: -- Holds Issue 1979918
2010: --------------------------------------------------------------------
2011: -- During the credit checking is at Line level ( PASS scenario ),

Line 2057: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2053: , x_msg_data => l_msg_data
2054: , x_return_status => l_return_status
2055: );
2056:
2057: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2058: IF NVL(G_hdr_hold_released,'N') = 'N'
2059: THEN
2060: l_cc_result_out := 'HDR_HOLD' ;
2061: ELSE

Line 2062: RAISE FND_API.G_EXC_ERROR;

2058: IF NVL(G_hdr_hold_released,'N') = 'N'
2059: THEN
2060: l_cc_result_out := 'HDR_HOLD' ;
2061: ELSE
2062: RAISE FND_API.G_EXC_ERROR;
2063: END IF;
2064: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2065: IF NVL(G_hdr_hold_released,'N') = 'N'
2066: THEN

Line 2064: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2060: l_cc_result_out := 'HDR_HOLD' ;
2061: ELSE
2062: RAISE FND_API.G_EXC_ERROR;
2063: END IF;
2064: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2065: IF NVL(G_hdr_hold_released,'N') = 'N'
2066: THEN
2067: l_cc_result_out := 'HDR_HOLD' ;
2068: ELSE

Line 2069: RAISE FND_API.G_EXC_ERROR;

2065: IF NVL(G_hdr_hold_released,'N') = 'N'
2066: THEN
2067: l_cc_result_out := 'HDR_HOLD' ;
2068: ELSE
2069: RAISE FND_API.G_EXC_ERROR;
2070: END IF;
2071: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
2072: Write_Release_Message(
2073: p_calling_action => p_calling_action

Line 2071: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN

2067: l_cc_result_out := 'HDR_HOLD' ;
2068: ELSE
2069: RAISE FND_API.G_EXC_ERROR;
2070: END IF;
2071: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
2072: Write_Release_Message(
2073: p_calling_action => p_calling_action
2074: , p_order_number => p_order_number
2075: , p_line_number => p_line_number

Line 2146: x_return_status := FND_API.G_RET_STS_SUCCESS;

2142: OE_DEBUG_PUB.ADD(' p_trx_credit_limit = '|| p_trx_credit_limit,2);
2143: END IF;
2144:
2145: -- Initialize return status to success
2146: x_return_status := FND_API.G_RET_STS_SUCCESS;
2147: -- Default to Pass
2148: x_cc_result_out := 'PASS';
2149:
2150: ----------------------------------------------

Line 2198: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

2194: OE_DEBUG_PUB.ADD(' ERR curr tbl count = '
2195: || x_conversion_status.COUNT );
2196: END IF;
2197:
2198: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2199: RAISE FND_API.G_EXC_ERROR;
2200: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2202: END IF;

Line 2199: RAISE FND_API.G_EXC_ERROR;

2195: || x_conversion_status.COUNT );
2196: END IF;
2197:
2198: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2199: RAISE FND_API.G_EXC_ERROR;
2200: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2202: END IF;
2203:

Line 2200: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2196: END IF;
2197:
2198: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2199: RAISE FND_API.G_EXC_ERROR;
2200: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2202: END IF;
2203:
2204: IF G_debug_flag = 'Y'

Line 2201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2197:
2198: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2199: RAISE FND_API.G_EXC_ERROR;
2200: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2202: END IF;
2203:
2204: IF G_debug_flag = 'Y'
2205: THEN

Line 2238: x_return_status := FND_API.G_RET_STS_ERROR;

2234: FND_MESSAGE.Set_Token('CONV',
2235: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
2236:
2237: OE_MSG_PUB.ADD;
2238: x_return_status := FND_API.G_RET_STS_ERROR;
2239:
2240: END IF;
2241:
2242:

Line 2256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2252: END IF;
2253: EXCEPTION
2254: WHEN others THEN
2255: OE_DEBUG_PUB.Add('Check_Trx_Limit: Other exceptions');
2256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2257: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2258: OE_MSG_PUB.Add_Exc_Msg
2259: ( G_PKG_NAME
2260: , 'Check_Trx_Limit'

Line 2304: x_return_status := FND_API.G_RET_STS_SUCCESS;

2300:
2301: BEGIN
2302:
2303: x_check_order_flag := 'Y';
2304: x_return_status := FND_API.G_RET_STS_SUCCESS;
2305: x_global_exposure_flag := 'N' ;
2306:
2307: IF G_debug_flag = 'Y'
2308: THEN

Line 2421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2417: OE_DEBUG_PUB.Add('OEXVCRLB: Out Validate_other_credit_check');
2418: END IF;
2419: EXCEPTION
2420: WHEN OTHERS THEN
2421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2422: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2423: OE_MSG_PUB.Add_Exc_Msg
2424: ( G_PKG_NAME
2425: , 'Validate_other_credit_check'

Line 2428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2424: ( G_PKG_NAME
2425: , 'Validate_other_credit_check'
2426: );
2427: END IF;
2428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2429: OE_DEBUG_PUB.ADD( SUBSTR(SQLERRM,1,300) ,1 );
2430: END Validate_other_credit_check;
2431:
2432: -----------------------------------------------------------

Line 2534: x_return_status := FND_API.G_RET_STS_SUCCESS;

2530: -- Set the default behaviour to pass credit check |
2531: -- exposure |
2532: ----------------------------------------------------------
2533:
2534: x_return_status := FND_API.G_RET_STS_SUCCESS;
2535: x_total_exposure := 0 ;
2536: l_current_order_value := 0 ;
2537:
2538: OE_DEBUG_PUB.ADD( ' Call Get_Exposure ');

Line 2568: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

2564: OE_DEBUG_PUB.Add('x_total_exposure = '|| x_total_exposure );
2565: OE_DEBUG_PUB.Add('Error table count = '|| x_error_curr_tbl.COUNT );
2566: END IF;
2567:
2568: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2569: RAISE FND_API.G_EXC_ERROR;
2570: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2572: END IF;

Line 2569: RAISE FND_API.G_EXC_ERROR;

2565: OE_DEBUG_PUB.Add('Error table count = '|| x_error_curr_tbl.COUNT );
2566: END IF;
2567:
2568: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2569: RAISE FND_API.G_EXC_ERROR;
2570: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2572: END IF;
2573:

Line 2570: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2566: END IF;
2567:
2568: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2569: RAISE FND_API.G_EXC_ERROR;
2570: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2572: END IF;
2573:
2574:

Line 2571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2567:
2568: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2569: RAISE FND_API.G_EXC_ERROR;
2570: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2572: END IF;
2573:
2574:
2575: -- BUG Fix 2338145

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

2585:
2586: l_current_order_value := 0 ;
2587:
2588: IF NVL(p_calling_action, 'BOOKING') = 'BOOKING'
2589: and NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) =
2590: FND_API.G_FALSE
2591: THEN
2592: l_current_order_value :=
2593: NVL(OE_CREDIT_CHECK_UTIL.g_current_order_value,0) ;

Line 2590: FND_API.G_FALSE

2586: l_current_order_value := 0 ;
2587:
2588: IF NVL(p_calling_action, 'BOOKING') = 'BOOKING'
2589: and NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) =
2590: FND_API.G_FALSE
2591: THEN
2592: l_current_order_value :=
2593: NVL(OE_CREDIT_CHECK_UTIL.g_current_order_value,0) ;
2594: ELSE

Line 2659: x_return_status := FND_API.G_RET_STS_ERROR;

2655: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
2656:
2657:
2658: OE_MSG_PUB.ADD;
2659: x_return_status := FND_API.G_RET_STS_ERROR;
2660: OE_DEBUG_PUB.ADD('Return status after assigned as Error = '
2661: || x_return_status );
2662: END IF;
2663:

Line 2685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2681: OE_DEBUG_PUB.Add('OEXVCRLB: Out CHECK_ORDER_LINES_EXPOSURE');
2682: END IF;
2683: EXCEPTION
2684: WHEN others THEN
2685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2686: OE_DEBUG_PUB.Add('CHECK_ORDER_LINES_EXPOSURE: Other exceptions');
2687: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2688: OE_MSG_PUB.Add_Exc_Msg
2689: ( G_PKG_NAME

Line 2693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2689: ( G_PKG_NAME
2690: , 'CHECK_ORDER_LINES_EXPOSURE'
2691: );
2692: END IF;
2693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2694: OE_DEBUG_PUB.ADD( SUBSTR(SQLERRM,1,300) ,1 );
2695: END CHECK_ORDER_LINES_EXPOSURE;
2696:
2697: -----------------------------------------------------------

Line 2734: x_return_status := FND_API.G_RET_STS_SUCCESS;

2730: BEGIN
2731: OE_DEBUG_PUB.Add('OEXVCRLB: In Check_Item_Limits');
2732: --
2733: -- Initialize return status to success
2734: x_return_status := FND_API.G_RET_STS_SUCCESS;
2735: -- Default to Pass
2736: l_cc_result_out := 'PASS';
2737: l_credit_hold_level := p_credit_check_rule_rec.CREDIT_HOLD_LEVEL_CODE ;
2738: -- Need to use new get_item_limits api

Line 2901: x_return_status := FND_API.G_RET_STS_ERROR;

2897: FND_MESSAGE.Set_Token('CONV',
2898: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
2899:
2900: OE_MSG_PUB.ADD ;
2901: x_return_status := FND_API.G_RET_STS_ERROR;
2902: OE_DEBUG_PUB.ADD('Return status after assigned as Error = '
2903: || x_return_status );
2904: END IF;
2905:

Line 2911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2907: END;
2908:
2909: WHEN others THEN
2910: OE_DEBUG_PUB.Add('Check_Item_Limit: Other exceptions');
2911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2912: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2913: OE_MSG_PUB.Add_Exc_Msg
2914: ( G_PKG_NAME
2915: , 'Check_Item_Limits'

Line 2996: x_return_status := FND_API.G_RET_STS_SUCCESS;

2992: --
2993: -- Set the default behavior to pass credit check
2994: --
2995: x_cc_result_out := 'PASS';
2996: x_return_status := FND_API.G_RET_STS_SUCCESS;
2997: l_credit_hold_level := p_credit_check_rule_rec.CREDIT_HOLD_LEVEL_CODE ;
2998: x_global_exposure_flag := 'N' ;
2999:
3000: l_cc_result_out := 'PASS';

Line 3055: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 3056: RAISE FND_API.G_EXC_ERROR;

3052: OE_DEBUG_PUB.Add(' l_check_order = '|| l_check_order );
3053: END IF;
3054:
3055: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3056: RAISE FND_API.G_EXC_ERROR;
3057: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3058: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3059: END IF;
3060:

Line 3057: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3053: END IF;
3054:
3055: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3056: RAISE FND_API.G_EXC_ERROR;
3057: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3058: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3059: END IF;
3060:
3061:

Line 3058: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3054:
3055: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3056: RAISE FND_API.G_EXC_ERROR;
3057: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3058: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3059: END IF;
3060:
3061:
3062: --

Line 3120: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

3116: l_cc_limit_used := 'DUEDATE';
3117: END IF;
3118:
3119:
3120: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3121: RAISE FND_API.G_EXC_ERROR;
3122: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3124: END IF;

Line 3121: RAISE FND_API.G_EXC_ERROR;

3117: END IF;
3118:
3119:
3120: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3121: RAISE FND_API.G_EXC_ERROR;
3122: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3124: END IF;
3125:

Line 3122: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3118:
3119:
3120: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3121: RAISE FND_API.G_EXC_ERROR;
3122: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3124: END IF;
3125:
3126: -- IF l_cc_result_out = 'PASS' THEN

Line 3123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3119:
3120: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3121: RAISE FND_API.G_EXC_ERROR;
3122: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3124: END IF;
3125:
3126: -- IF l_cc_result_out = 'PASS' THEN
3127: -- Changed IF condition to fix bug 4002820, need to do overall

Line 3187: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

3183: l_cc_limit_used := 'TRX';
3184: END IF;
3185: END IF;
3186:
3187: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3188: RAISE FND_API.G_EXC_ERROR;
3189: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3191: END IF;

Line 3188: RAISE FND_API.G_EXC_ERROR;

3184: END IF;
3185: END IF;
3186:
3187: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3188: RAISE FND_API.G_EXC_ERROR;
3189: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3191: END IF;
3192:

Line 3189: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3185: END IF;
3186:
3187: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3188: RAISE FND_API.G_EXC_ERROR;
3189: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3191: END IF;
3192:
3193: -- IF l_cc_result_out = 'PASS' THEN

Line 3190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3186:
3187: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3188: RAISE FND_API.G_EXC_ERROR;
3189: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3191: END IF;
3192:
3193: -- IF l_cc_result_out = 'PASS' THEN
3194: -- Changed IF condition to fix bug 4002820, need to do overall

Line 3301: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

3297: -- customer exposure already checked, retrieve the result
3298: l_cc_result_out := l_customer_result_out;
3299: END IF;
3300:
3301: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3302: RAISE FND_API.G_EXC_ERROR;
3303: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3305: END IF;

Line 3302: RAISE FND_API.G_EXC_ERROR;

3298: l_cc_result_out := l_customer_result_out;
3299: END IF;
3300:
3301: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3302: RAISE FND_API.G_EXC_ERROR;
3303: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3305: END IF;
3306:

Line 3303: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3299: END IF;
3300:
3301: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3302: RAISE FND_API.G_EXC_ERROR;
3303: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3305: END IF;
3306:
3307: IF l_cc_overall_result_out = 'FAIL' THEN

Line 3304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3300:
3301: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3302: RAISE FND_API.G_EXC_ERROR;
3303: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3305: END IF;
3306:
3307: IF l_cc_overall_result_out = 'FAIL' THEN
3308: l_cc_result_out := l_cc_overall_result_out;

Line 3462: , p_init_msg_list => FND_API.G_FALSE

3458: END IF;
3459: ----------------Submit Credit Review--------------------
3460: AR_CMGT_CREDIT_REQUEST_API.Create_credit_request
3461: ( p_api_version => 1.0
3462: , p_init_msg_list => FND_API.G_FALSE
3463: , p_commit => FND_API.G_FALSE
3464: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
3465: , x_return_status => x_return_status
3466: , x_msg_count => l_msg_count

Line 3463: , p_commit => FND_API.G_FALSE

3459: ----------------Submit Credit Review--------------------
3460: AR_CMGT_CREDIT_REQUEST_API.Create_credit_request
3461: ( p_api_version => 1.0
3462: , p_init_msg_list => FND_API.G_FALSE
3463: , p_commit => FND_API.G_FALSE
3464: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
3465: , x_return_status => x_return_status
3466: , x_msg_count => l_msg_count
3467: , x_msg_data => l_msg_data

Line 3464: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

3460: AR_CMGT_CREDIT_REQUEST_API.Create_credit_request
3461: ( p_api_version => 1.0
3462: , p_init_msg_list => FND_API.G_FALSE
3463: , p_commit => FND_API.G_FALSE
3464: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
3465: , x_return_status => x_return_status
3466: , x_msg_count => l_msg_count
3467: , x_msg_data => l_msg_data
3468: , p_application_number => NULL

Line 3590: WHEN FND_API.G_EXC_ERROR THEN

3586: END IF;
3587:
3588:
3589: EXCEPTION
3590: WHEN FND_API.G_EXC_ERROR THEN
3591: x_return_status := FND_API.G_RET_STS_ERROR;
3592: RAISE FND_API.G_EXC_ERROR;
3593: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3591: x_return_status := FND_API.G_RET_STS_ERROR;

3587:
3588:
3589: EXCEPTION
3590: WHEN FND_API.G_EXC_ERROR THEN
3591: x_return_status := FND_API.G_RET_STS_ERROR;
3592: RAISE FND_API.G_EXC_ERROR;
3593: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3592: RAISE FND_API.G_EXC_ERROR;

3588:
3589: EXCEPTION
3590: WHEN FND_API.G_EXC_ERROR THEN
3591: x_return_status := FND_API.G_RET_STS_ERROR;
3592: RAISE FND_API.G_EXC_ERROR;
3593: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3596: WHEN OTHERS THEN

Line 3593: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3589: EXCEPTION
3590: WHEN FND_API.G_EXC_ERROR THEN
3591: x_return_status := FND_API.G_RET_STS_ERROR;
3592: RAISE FND_API.G_EXC_ERROR;
3593: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3596: WHEN OTHERS THEN
3597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3590: WHEN FND_API.G_EXC_ERROR THEN
3591: x_return_status := FND_API.G_RET_STS_ERROR;
3592: RAISE FND_API.G_EXC_ERROR;
3593: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3596: WHEN OTHERS THEN
3597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3598: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 3595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3591: x_return_status := FND_API.G_RET_STS_ERROR;
3592: RAISE FND_API.G_EXC_ERROR;
3593: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3596: WHEN OTHERS THEN
3597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3598: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3599: OE_MSG_PUB.Add_Exc_Msg

Line 3597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3593: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3596: WHEN OTHERS THEN
3597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3598: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3599: OE_MSG_PUB.Add_Exc_Msg
3600: ( G_PKG_NAME, 'Check_Other_Credit_Limits');
3601: END IF;

Line 3639: x_return_status := FND_API.G_RET_STS_SUCCESS;

3635: OE_DEBUG_PUB.Add('start Loop for holds table');
3636: OE_DEBUG_PUB.Add('p_check_exposure_mode => '|| p_check_exposure_mode );
3637: END IF;
3638:
3639: x_return_status := FND_API.G_RET_STS_SUCCESS;
3640: --
3641: -- Get the order number for notification
3642: --
3643:

Line 3767: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3763: OE_DEBUG_PUB.Add('OEXVCRLB: Out Apply_And_Release_Holds');
3764: END IF;
3765: EXCEPTION
3766: WHEN others THEN
3767: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3768: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3769: OE_MSG_PUB.Add_Exc_Msg
3770: ( G_PKG_NAME
3771: , 'Apply_And_Release_Holds'

Line 3878: x_return_status := FND_API.G_RET_STS_SUCCESS;

3874: --
3875: -- Set the default behavior to pass credit check
3876: --
3877: x_cc_result_out := 'NOCHECK';
3878: x_return_status := FND_API.G_RET_STS_SUCCESS;
3879: l_global_exposure_flag := 'N' ;
3880:
3881: G_result_out := 'PASS' ;
3882: G_release_status := 'NO' ;

Line 4051: x_return_status := FND_API.G_RET_STS_SUCCESS;

4047: );
4048:
4049: ELSE
4050: l_cc_result_out := 'PASS' ;
4051: x_return_status := FND_API.G_RET_STS_SUCCESS;
4052:
4053: IF G_debug_flag = 'Y'
4054: THEN
4055: OE_DEBUG_PUB.Add(' No check item categories, Flag OFF ');

Line 4061: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

4057:
4058: END IF;
4059:
4060:
4061: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4062: RAISE FND_API.G_EXC_ERROR;
4063: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4064: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4065: END IF;

Line 4062: RAISE FND_API.G_EXC_ERROR;

4058: END IF;
4059:
4060:
4061: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4062: RAISE FND_API.G_EXC_ERROR;
4063: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4064: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4065: END IF;
4066: --

Line 4063: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4059:
4060:
4061: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4062: RAISE FND_API.G_EXC_ERROR;
4063: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4064: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4065: END IF;
4066: --
4067: -- Apply the database hold and Exit the bill-to site loop if

Line 4064: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4060:
4061: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4062: RAISE FND_API.G_EXC_ERROR;
4063: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4064: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4065: END IF;
4066: --
4067: -- Apply the database hold and Exit the bill-to site loop if
4068: -- credit hold level is ORDER and the order failed credit check.

Line 4127: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

4123: || x_return_status );
4124: END IF;
4125:
4126:
4127: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4128: RAISE FND_API.G_EXC_ERROR;
4129: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4131: END IF;

Line 4128: RAISE FND_API.G_EXC_ERROR;

4124: END IF;
4125:
4126:
4127: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4128: RAISE FND_API.G_EXC_ERROR;
4129: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4131: END IF;
4132:

Line 4129: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4125:
4126:
4127: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4128: RAISE FND_API.G_EXC_ERROR;
4129: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4131: END IF;
4132:
4133: -- Apply order level credit hold to the database if it necessary

Line 4130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4126:
4127: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4128: RAISE FND_API.G_EXC_ERROR;
4129: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4131: END IF;
4132:
4133: -- Apply order level credit hold to the database if it necessary
4134:

Line 4173: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

4169: , x_return_status => x_return_status
4170: );
4171:
4172:
4173: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4174: RAISE FND_API.G_EXC_ERROR;
4175: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4177: END IF;

Line 4174: RAISE FND_API.G_EXC_ERROR;

4170: );
4171:
4172:
4173: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4174: RAISE FND_API.G_EXC_ERROR;
4175: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4177: END IF;
4178: END IF;

Line 4175: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4171:
4172:
4173: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4174: RAISE FND_API.G_EXC_ERROR;
4175: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4177: END IF;
4178: END IF;
4179:

Line 4176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4172:
4173: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4174: RAISE FND_API.G_EXC_ERROR;
4175: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4177: END IF;
4178: END IF;
4179:
4180: ------------------------- Credit review ------------

Line 4275: , p_init_msg_list => FND_API.G_FALSE

4271: END IF;
4272: ----------------Submit Credit Review--------------------
4273: AR_CMGT_CREDIT_REQUEST_API.Create_credit_request
4274: ( p_api_version => 1.0
4275: , p_init_msg_list => FND_API.G_FALSE
4276: , p_commit => FND_API.G_FALSE
4277: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
4278: , x_return_status => x_return_status
4279: , x_msg_count => l_msg_count

Line 4276: , p_commit => FND_API.G_FALSE

4272: ----------------Submit Credit Review--------------------
4273: AR_CMGT_CREDIT_REQUEST_API.Create_credit_request
4274: ( p_api_version => 1.0
4275: , p_init_msg_list => FND_API.G_FALSE
4276: , p_commit => FND_API.G_FALSE
4277: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
4278: , x_return_status => x_return_status
4279: , x_msg_count => l_msg_count
4280: , x_msg_data => l_msg_data

Line 4277: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

4273: AR_CMGT_CREDIT_REQUEST_API.Create_credit_request
4274: ( p_api_version => 1.0
4275: , p_init_msg_list => FND_API.G_FALSE
4276: , p_commit => FND_API.G_FALSE
4277: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
4278: , x_return_status => x_return_status
4279: , x_msg_count => l_msg_count
4280: , x_msg_data => l_msg_data
4281: , p_application_number => NULL

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

4438: -- OE_MSG_PUB.Delete_Msg(OE_MSG_PUB.G_msg_count);
4439:
4440: -- added OR condition for bug 5467793
4441: IF x_cc_result_out = 'FAIL'
4442: --OR( NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) =
4443: --FND_API.G_TRUE AND x_cc_result_out IN ('FAIL_HOLD', 'FAIL_NONE'))
4444: THEN
4445: -- Display the general message for the user on the screen
4446:

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

4439:
4440: -- added OR condition for bug 5467793
4441: IF x_cc_result_out = 'FAIL'
4442: --OR( NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) =
4443: --FND_API.G_TRUE AND x_cc_result_out IN ('FAIL_HOLD', 'FAIL_NONE'))
4444: THEN
4445: -- Display the general message for the user on the screen
4446:
4447: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_GENERAL_MSG');

Line 4468: WHEN FND_API.G_EXC_ERROR THEN

4464: OE_DEBUG_PUB.Add('OEXVCRLB: Out Check_order_lines_credit API',1);
4465: END IF;
4466:
4467: EXCEPTION
4468: WHEN FND_API.G_EXC_ERROR THEN
4469: x_return_status := FND_API.G_RET_STS_ERROR;
4470: OE_DEBUG_PUB.Add('Check_order_lines_credit: Error ',1);
4471:
4472: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4469: x_return_status := FND_API.G_RET_STS_ERROR;

4465: END IF;
4466:
4467: EXCEPTION
4468: WHEN FND_API.G_EXC_ERROR THEN
4469: x_return_status := FND_API.G_RET_STS_ERROR;
4470: OE_DEBUG_PUB.Add('Check_order_lines_credit: Error ',1);
4471:
4472: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4472: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4468: WHEN FND_API.G_EXC_ERROR THEN
4469: x_return_status := FND_API.G_RET_STS_ERROR;
4470: OE_DEBUG_PUB.Add('Check_order_lines_credit: Error ',1);
4471:
4472: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4474: OE_DEBUG_PUB.Add('Check_order_lines_credit: Unexpected Error ',1);
4475: WHEN OTHERS THEN
4476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4469: x_return_status := FND_API.G_RET_STS_ERROR;
4470: OE_DEBUG_PUB.Add('Check_order_lines_credit: Error ',1);
4471:
4472: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4474: OE_DEBUG_PUB.Add('Check_order_lines_credit: Unexpected Error ',1);
4475: WHEN OTHERS THEN
4476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4477: OE_DEBUG_PUB.Add('Check_order_lines_credit: Other Unexpected Error ',1);

Line 4476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4472: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4474: OE_DEBUG_PUB.Add('Check_order_lines_credit: Unexpected Error ',1);
4475: WHEN OTHERS THEN
4476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4477: OE_DEBUG_PUB.Add('Check_order_lines_credit: Other Unexpected Error ',1);
4478: OE_DEBUG_PUB.ADD( SUBSTR(SQLERRM,1,300),1 ) ;
4479: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4480: OE_MSG_PUB.Add_Exc_Msg