DBA Data[Home] [Help]

APPS.OE_CREDIT_CHECK_LINES_PVT dependencies on OE_CREDIT_ENGINE_GRP

Line 652: , p_functional_currency => OE_Credit_Engine_GRP.GL_currency

648: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
649: ( p_amount => p_holds_table(i).line_total
650: , p_transactional_currency => p_transactional_currency
651: , p_limit_currency => p_limit_currency
652: , p_functional_currency => OE_Credit_Engine_GRP.GL_currency
653: , p_conversion_date => SYSDATE
654: , p_conversion_type => p_conversion_type
655: ) ;
656: p_holds_table(i).line_total :=l_converted_amt;

Line 758: OE_credit_engine_grp.G_delayed_request );

754: OE_DEBUG_PUB.Add('p_calling_action = '|| p_calling_action );
755: OE_DEBUG_PUB.Add('Check for Header ID/Line ID: '||p_header_id||'/'
756: ||p_line_id,1);
757: OE_DEBUG_PUB.Add('G_delayed_request = '||
758: OE_credit_engine_grp.G_delayed_request );
759: END IF;
760:
761: -- Will not check if the event is UPDATE
762:

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 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 999: , p_wf_item => OE_Credit_Engine_GRP.G_cc_hold_item_type

995: OE_HOLDS_PUB.Check_Holds
996: ( p_api_version => 1.0
997: , p_header_id => p_header_id
998: , p_hold_id => 1
999: , p_wf_item => OE_Credit_Engine_GRP.G_cc_hold_item_type
1000: , p_wf_activity => OE_Credit_Engine_GRP.G_cc_hold_activity_name
1001: , p_entity_code => 'O'
1002: , p_entity_id => p_header_id
1003: , x_result_out => l_hold_result

Line 1000: , p_wf_activity => OE_Credit_Engine_GRP.G_cc_hold_activity_name

996: ( p_api_version => 1.0
997: , p_header_id => p_header_id
998: , p_hold_id => 1
999: , p_wf_item => OE_Credit_Engine_GRP.G_cc_hold_item_type
1000: , p_wf_activity => OE_Credit_Engine_GRP.G_cc_hold_activity_name
1001: , p_entity_code => 'O'
1002: , p_entity_id => p_header_id
1003: , x_result_out => l_hold_result
1004: , x_msg_count => l_msg_count

Line 1020: , p_wf_item => OE_Credit_Engine_GRP.G_cc_hold_item_type

1016: ( p_api_version => 1.0
1017: , p_header_id => p_header_id
1018: , p_line_id => p_line_id
1019: , p_hold_id => 1
1020: , p_wf_item => OE_Credit_Engine_GRP.G_cc_hold_item_type
1021: , p_wf_activity => OE_Credit_Engine_GRP.G_cc_hold_activity_name
1022: , p_entity_code => 'O'
1023: , p_entity_id => p_header_id
1024: , x_result_out => l_hold_result

Line 1021: , p_wf_activity => OE_Credit_Engine_GRP.G_cc_hold_activity_name

1017: , p_header_id => p_header_id
1018: , p_line_id => p_line_id
1019: , p_hold_id => 1
1020: , p_wf_item => OE_Credit_Engine_GRP.G_cc_hold_item_type
1021: , p_wf_activity => OE_Credit_Engine_GRP.G_cc_hold_activity_name
1022: , p_entity_code => 'O'
1023: , p_entity_id => p_header_id
1024: , x_result_out => l_hold_result
1025: , x_msg_count => l_msg_count

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 1216: x_comment := NVL(OE_Credit_Engine_GRP.G_currency_error_msg,l_comment);

1212:
1213: l_comment := l_comment||SUBSTR(FND_MESSAGE.GET,1,2000);
1214: --ER#7479609 end
1215:
1216: x_comment := NVL(OE_Credit_Engine_GRP.G_currency_error_msg,l_comment);
1217:
1218: IF G_debug_flag = 'Y'
1219: THEN
1220: OE_DEBUG_PUB.ADD(' x_comment '|| x_comment );

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 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 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 1660: OE_Credit_Engine_GRP.G_Credit_Profile_Level := p_cc_profile_used; --ER 12363706

1656:
1657: --8478151
1658: IF Oe_Globals.G_calling_source = 'ONT' and p_calling_action = 'SHIPPING'
1659: THEN
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

Line 1671: OE_Credit_Engine_GRP.G_Credit_Profile_Level := NULL; --ER 12363706

1667: , x_msg_data => l_msg_data
1668: , x_return_status => l_return_status
1669: );
1670:
1671: OE_Credit_Engine_GRP.G_Credit_Profile_Level := NULL; --ER 12363706
1672: ELSE --8478151
1673: OE_Credit_Engine_GRP.G_Credit_Profile_Level := p_cc_profile_used; --ER 12363706
1674:
1675: Apply_hold_and_commit

Line 1673: OE_Credit_Engine_GRP.G_Credit_Profile_Level := p_cc_profile_used; --ER 12363706

1669: );
1670:
1671: OE_Credit_Engine_GRP.G_Credit_Profile_Level := NULL; --ER 12363706
1672: ELSE --8478151
1673: OE_Credit_Engine_GRP.G_Credit_Profile_Level := p_cc_profile_used; --ER 12363706
1674:
1675: Apply_hold_and_commit
1676: ( p_hold_source_rec => l_hold_source_rec
1677: , x_msg_count => l_msg_count

Line 1682: OE_Credit_Engine_GRP.G_Credit_Profile_Level := NULL; --ER 12363706

1678: , x_msg_data => l_msg_data
1679: , x_return_status => l_return_status
1680: );
1681:
1682: OE_Credit_Engine_GRP.G_Credit_Profile_Level := NULL; --ER 12363706
1683: END IF; --8478151
1684:
1685:
1686: IF G_debug_flag = 'Y'

Line 1698: OE_Credit_Engine_GRP.G_Credit_Profile_Level := p_cc_profile_used; --ER 12363706

1694: IF G_debug_flag = 'Y'
1695: THEN
1696: OE_DEBUG_PUB.ADD('OEXVCRLB: Call OE_Holds_PUB.Apply_Holds directly');
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

Line 1707: OE_Credit_Engine_GRP.G_Credit_Profile_Level := NULL; --ER 12363706

1703: , x_msg_count => l_msg_count
1704: , x_msg_data => l_msg_data
1705: , x_return_status => l_return_status
1706: );
1707: OE_Credit_Engine_GRP.G_Credit_Profile_Level := NULL; --ER 12363706
1708: IF G_debug_flag = 'Y'
1709: THEN
1710: OE_DEBUG_PUB.ADD('OEXVCRLB: Out OE_Holds_PUB.Apply_Holds directly');
1711: END IF;

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 1869: OE_Credit_Engine_GRP.G_Credit_Profile_Level := p_cc_profile_used; --ER 12363706

1865: );
1866: l_hold_source_rec.hold_comment := l_hold_comment;
1867:
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

Line 1878: OE_Credit_Engine_GRP.G_Credit_Profile_Level := NULL; --ER 12363706

1874: , x_msg_count => l_msg_count
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;

Line 2394: OE_Credit_Engine_GRP.G_currency_error_msg :=

2390: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);
2391: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
2392: FND_MESSAGE.Set_Token('CONV',
2393: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
2394: OE_Credit_Engine_GRP.G_currency_error_msg :=
2395: SUBSTR(FND_MESSAGE.GET,1,1000) ;
2396:
2397: G_result_out := 'FAIL' ;
2398: x_cc_result_out := 'FAIL' ;

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 2813: OE_Credit_Engine_GRP.G_currency_error_msg :=

2809: FND_MESSAGE.Set_Token('FROM',x_error_curr_tbl(1).usage_curr_code);
2810: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
2811: FND_MESSAGE.Set_Token('CONV',
2812: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
2813: OE_Credit_Engine_GRP.G_currency_error_msg :=
2814: SUBSTR(FND_MESSAGE.GET,1,1000) ;
2815:
2816: G_result_out := 'FAIL' ;
2817: x_cc_result_out := 'FAIL' ;

Line 2961: OE_Credit_Engine_GRP.GL_currency );

2957: l_category_sum := l_item_limits(i).ctg_line_amount ;
2958:
2959: OE_DEBUG_PUB.Add(' l_category_sum = ' || l_category_sum );
2960: OE_DEBUG_PUB.Add(' GL_CURRENCY = '||
2961: OE_Credit_Engine_GRP.GL_currency );
2962:
2963:
2964: OE_DEBUG_PUB.ADD(' ');
2965: OE_DEBUG_PUB.Add(' ------------------------------------ ');

Line 2976: , p_functional_currency => OE_Credit_Engine_GRP.GL_currency

2972: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
2973: ( p_amount => l_category_sum
2974: , p_transactional_currency => p_header_rec.transactional_curr_code
2975: , p_limit_currency => l_item_limits(i).limit_curr_code
2976: , p_functional_currency => OE_Credit_Engine_GRP.GL_currency
2977: , p_conversion_date => SYSDATE
2978: , p_conversion_type => p_credit_check_rule_rec.conversion_type
2979: ) ;
2980:

Line 3057: OE_Credit_Engine_GRP.G_currency_error_msg :=

3053: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code );
3054: FND_MESSAGE.Set_Token('TO',l_limit_currency );
3055: FND_MESSAGE.Set_Token('CONV',
3056: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
3057: OE_Credit_Engine_GRP.G_currency_error_msg :=
3058: SUBSTR(FND_MESSAGE.GET,1,1000) ;
3059: G_result_out := 'FAIL' ;
3060: x_cc_result_out := 'FAIL' ;
3061:

Line 3386: IF OE_CREDIT_ENGINE_GRP.CREDIT_TOLERANCE_CHECK( p_header_id => p_header_rec.header_id) THEN

3382: END IF;
3383: END LOOP;
3384:
3385: IF l_tolerance_check = 'Y' THEN
3386: IF OE_CREDIT_ENGINE_GRP.CREDIT_TOLERANCE_CHECK( p_header_id => p_header_rec.header_id) THEN
3387: RETURN;
3388: END IF;
3389: END IF;
3390:

Line 4321: OE_Credit_Engine_GRP.G_currency_error_msg := NULL;

4317: G_release_status := 'NO' ;
4318: G_hdr_hold_released := 'N' ;
4319:
4320:
4321: OE_Credit_Engine_GRP.G_currency_error_msg := NULL;
4322:
4323: l_credit_hold_level := p_credit_check_rule_rec.CREDIT_HOLD_LEVEL_CODE ;
4324:
4325: IF G_debug_flag = 'Y'

Line 4335: OE_Credit_Engine_GRP.G_currency_error_msg );

4331: G_hdr_hold_released);
4332: OE_DEBUG_PUB.Add('Inital G_release_status = '||
4333: G_release_status );
4334: OE_DEBUG_PUB.Add('G_currency_error_msg = '||
4335: OE_Credit_Engine_GRP.G_currency_error_msg );
4336: OE_DEBUG_PUB.Add(' ');
4337: OE_DEBUG_PUB.Add(' ---------------------------------------');
4338: OE_DEBUG_PUB.Add(' ');
4339: OE_DEBUG_PUB.Add(' p_calling_action = ' || p_calling_action );

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 4390: IF OE_CREDIT_ENGINE_GRP.TOLERANCE_CHECK_REQUIRED

4386: THEN
4387: IF l_credit_hold_level = 'ORDER'
4388: THEN
4389: oe_debug_pub.ADD('OEXVCRLB: Credit check at Order Level');
4390: IF OE_CREDIT_ENGINE_GRP.TOLERANCE_CHECK_REQUIRED
4391: THEN
4392: oe_debug_pub.ADD('OEXVCRLB: Tolerance Check is required');
4393: IF NOT OE_HOLDS_PUB.Hold_exists( p_hold_entity_code => 'O'
4394: , p_hold_entity_id => p_header_rec.header_id

Line 4408: IF OE_CREDIT_ENGINE_GRP.CREDIT_TOLERANCE_CHECK( p_header_id => p_header_rec.header_id) THEN

4404: p_line_id => NULL ,
4405: p_credit_check_rule_rec=>p_credit_check_rule_rec) = 'Y'
4406: THEN
4407: oe_debug_pub.ADD('OEXVCRLB: Manually released hold exists.');
4408: IF OE_CREDIT_ENGINE_GRP.CREDIT_TOLERANCE_CHECK( p_header_id => p_header_rec.header_id) THEN
4409: OE_CREDIT_ENGINE_GRP.TOLERANCE_CHECK_REQUIRED := TRUE;
4410:
4411: IF G_debug_flag = 'Y'
4412: THEN

Line 4409: OE_CREDIT_ENGINE_GRP.TOLERANCE_CHECK_REQUIRED := TRUE;

4405: p_credit_check_rule_rec=>p_credit_check_rule_rec) = 'Y'
4406: THEN
4407: oe_debug_pub.ADD('OEXVCRLB: Manually released hold exists.');
4408: IF OE_CREDIT_ENGINE_GRP.CREDIT_TOLERANCE_CHECK( p_header_id => p_header_rec.header_id) THEN
4409: OE_CREDIT_ENGINE_GRP.TOLERANCE_CHECK_REQUIRED := TRUE;
4410:
4411: IF G_debug_flag = 'Y'
4412: THEN
4413: oe_debug_pub.ADD('OEXVCRLB: Tolerance Check Passed');

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 4430: IF OE_CREDIT_ENGINE_GRP.TOLERANCE_CHECK_REQUIRED

4426: THEN
4427: IF l_credit_hold_level = 'LINE'
4428: THEN
4429: oe_debug_pub.ADD('OEXVCRLB: Credit check at Line Level');
4430: IF OE_CREDIT_ENGINE_GRP.TOLERANCE_CHECK_REQUIRED
4431: THEN
4432: oe_debug_pub.ADD('OEXVCRLB: Tolerance Check is required');
4433: OPEN latest_hold_rec(p_header_rec.header_id);
4434:

Line 4473: IF OE_CREDIT_ENGINE_GRP.CREDIT_TOLERANCE_CHECK( p_header_id => p_header_rec.header_id) THEN

4469: END IF;
4470:
4471: IF l_manual_hold_exists = 'Y'
4472: THEN
4473: IF OE_CREDIT_ENGINE_GRP.CREDIT_TOLERANCE_CHECK( p_header_id => p_header_rec.header_id) THEN
4474: OE_CREDIT_ENGINE_GRP.TOLERANCE_CHECK_REQUIRED := TRUE;
4475: IF G_debug_flag = 'Y'
4476: THEN
4477: oe_debug_pub.ADD('OEXVCRLB: Tolerance Check Passed');

Line 4474: OE_CREDIT_ENGINE_GRP.TOLERANCE_CHECK_REQUIRED := TRUE;

4470:
4471: IF l_manual_hold_exists = 'Y'
4472: THEN
4473: IF OE_CREDIT_ENGINE_GRP.CREDIT_TOLERANCE_CHECK( p_header_id => p_header_rec.header_id) THEN
4474: OE_CREDIT_ENGINE_GRP.TOLERANCE_CHECK_REQUIRED := TRUE;
4475: IF G_debug_flag = 'Y'
4476: THEN
4477: oe_debug_pub.ADD('OEXVCRLB: Tolerance Check Passed');
4478: END IF;

Line 4486: OE_CREDIT_ENGINE_GRP.TOLERANCE_CHECK_REQUIRED := TRUE;

4482: END IF;
4483: END IF;
4484: END IF;
4485:
4486: OE_CREDIT_ENGINE_GRP.TOLERANCE_CHECK_REQUIRED := TRUE;
4487: --ER 12363706 end
4488:
4489:
4490:

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 5017: OE_CREDIT_ENGINE_GRP.TOLERANCE_CHECK_REQUIRED := TRUE; --ER 12363706

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:
5021: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 5023: OE_CREDIT_ENGINE_GRP.TOLERANCE_CHECK_REQUIRED := TRUE; --ER 12363706

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
5027: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5028: 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 ) ;
5032: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN