eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_CREDIT_CHECK_ORDER_PVT dependencies on OE_CREDIT_ENGINE_GRP

Line 138: OE_credit_engine_GRP.G_delayed_request );

134: OE_DEBUG_PUB.Add('OEXVCRHB: In Check_Manual_Released_Holds');
135: OE_DEBUG_PUB.Add('Check Header ID/Line ID: '||p_header_id||'/'||p_line_id);
136: OE_DEBUG_PUB.Add('p_calling action = '|| p_calling_action );
137: OE_DEBUG_PUB.Add('G_delayed_request = '||
138: OE_credit_engine_GRP.G_delayed_request );
139: END IF;
140:
141: -- Will check only if delayed_request is FALSE
142: -- In other words, it will not check if the order is updated

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

142: -- In other words, it will not check if the order is updated
143:
144: -- Adding 'AUTO HOLD' for bug# 4207478
145: IF p_calling_action IN ('SHIPPING', 'PACKING' , 'PICKING', 'AUTO HOLD')
146: AND NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) =
147: FND_API.G_FALSE
148: --ER 12363706 start
149: OR (NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) = FND_API.G_TRUE)
150: --ER 12363706 end

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

145: IF p_calling_action IN ('SHIPPING', 'PACKING' , 'PICKING', 'AUTO HOLD')
146: AND NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) =
147: FND_API.G_FALSE
148: --ER 12363706 start
149: OR (NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) = FND_API.G_TRUE)
150: --ER 12363706 end
151: THEN
152:
153: BEGIN

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

200: AND RELEASE_REASON_CODE <> 'PASS_CREDIT'
201: AND CREATED_BY <> 1;
202:
203: -----check if days_honor_manual_release expired
204: IF NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) = FND_API.G_FALSE THEN --ER 12363706
205: IF p_credit_check_rule_rec.days_honor_manual_release IS NOT NULL
206: THEN
207: IF (l_release_date +
208: p_credit_check_rule_rec.days_honor_manual_release

Line 289: OE_Credit_Engine_GRP.G_cc_hold_item_type

285: ( p_api_version => 1.0
286: , p_header_id => p_header_id
287: , p_hold_id => 1
288: , p_wf_item =>
289: OE_Credit_Engine_GRP.G_cc_hold_item_type
290: , p_wf_activity =>
291: OE_Credit_Engine_GRP.G_cc_hold_activity_name
292: , p_entity_code => 'O'
293: , p_entity_id => p_header_id

Line 291: OE_Credit_Engine_GRP.G_cc_hold_activity_name

287: , p_hold_id => 1
288: , p_wf_item =>
289: OE_Credit_Engine_GRP.G_cc_hold_item_type
290: , p_wf_activity =>
291: OE_Credit_Engine_GRP.G_cc_hold_activity_name
292: , p_entity_code => 'O'
293: , p_entity_id => p_header_id
294: , x_result_out => l_hold_result
295: , x_msg_count => l_msg_count

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

800: THEN
801: OE_DEBUG_PUB.ADD('OEXVCRHB: Call Update_Comments_And_Commit');
802: END IF;
803:
804: OE_Credit_Engine_GRP.G_Credit_Profile_Level := p_cc_profile_used; --ER 12363706
805: l_cc_result_out := 'FAIL_HOLD';--kadiraju added for Bug$ 13768161
806: Update_Comments_And_Commit
807: ( p_hold_source_rec => l_hold_source_rec
808: , x_msg_count => l_msg_count

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

809: , x_msg_data => l_msg_data
810: , x_return_status => l_return_status
811: );
812:
813: OE_Credit_Engine_GRP.G_Credit_Profile_Level := NULL; --ER 12363706
814:
815: IF G_debug_flag = 'Y'
816: THEN
817: OE_DEBUG_PUB.ADD('OEXVCRHB: Out Update_Comments_And_Commit');

Line 845: OE_Credit_Engine_GRP.G_Credit_Profile_Level := p_cc_profile_used;

841: THEN
842: OE_DEBUG_PUB.ADD('OEXVCRHB: Call OE_CREDIT_CHECK_UTIL.Update_Credit_Profile_Level');
843: END IF;
844:
845: OE_Credit_Engine_GRP.G_Credit_Profile_Level := p_cc_profile_used;
846:
847: IF l_hold_source_rec.hold_entity_code = 'O' AND l_hold_source_rec.hold_id = 1 THEN
848: OE_DEBUG_PUB.ADD('OEXVCRHB: calling Update_Credit_Profile_Level');
849: OE_CREDIT_CHECK_UTIL.Update_Credit_Profile_Level(l_hold_source_rec);

Line 852: OE_Credit_Engine_GRP.G_Credit_Profile_Level := NULL;

848: OE_DEBUG_PUB.ADD('OEXVCRHB: calling Update_Credit_Profile_Level');
849: OE_CREDIT_CHECK_UTIL.Update_Credit_Profile_Level(l_hold_source_rec);
850: END IF;
851:
852: OE_Credit_Engine_GRP.G_Credit_Profile_Level := NULL;
853:
854: IF G_debug_flag = 'Y'
855: THEN
856: OE_DEBUG_PUB.ADD('OEXVCRHB: Out OE_CREDIT_CHECK_UTIL.Update_Credit_Profile_Level');

Line 882: 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)

878: ,p_line_id => NULL
879: ,p_credit_check_rule_rec=>p_credit_check_rule_rec
880: ) = 'N'
881: --ER 12363706 start
882: 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)
883: --ER 12363706 end
884: THEN
885: IF G_debug_flag = 'Y'
886: THEN

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

897: , x_comment => l_hold_comment
898: );
899: l_hold_source_rec.hold_comment := l_hold_comment;
900:
901: OE_Credit_Engine_GRP.G_Credit_Profile_Level := p_cc_profile_used; --ER 12363706
902:
903: ------------------------------------------------------------
904: -- Call for all actions except for the
905: -- concurrent program credit check processor

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

947: END IF;
948:
949: END IF; --check calling action
950:
951: OE_Credit_Engine_GRP.G_Credit_Profile_Level := NULL; --ER 12363706
952:
953: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
954: RAISE FND_API.G_EXC_ERROR;
955: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1352: OE_Credit_Engine_GRP.G_currency_error_msg :=

1348: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);
1349: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
1350: FND_MESSAGE.Set_Token('CONV',
1351: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
1352: OE_Credit_Engine_GRP.G_currency_error_msg :=
1353: SUBSTR(FND_MESSAGE.GET,1,1000) ;
1354:
1355: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
1356: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);

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

1926: l_current_order_value := 0 ;
1927: g_hold_exist := NULL;
1928:
1929: IF NVL(p_calling_action, 'BOOKING') = 'BOOKING' AND
1930: NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) =
1931: FND_API.G_FALSE
1932: THEN
1933: l_current_order_value :=
1934: NVL(OE_CREDIT_CHECK_UTIL.g_current_order_value,0) ;

Line 2033: OE_Credit_Engine_GRP.G_currency_error_msg :=

2029: FND_MESSAGE.Set_Token('FROM',l_conversion_status(1).usage_curr_code );
2030: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
2031: FND_MESSAGE.Set_Token('CONV',
2032: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate')) ;
2033: OE_Credit_Engine_GRP.G_currency_error_msg :=
2034: SUBSTR(FND_MESSAGE.GET,1,1000) ;
2035:
2036: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2037: FND_MESSAGE.Set_Token('FROM',l_conversion_status(1).usage_curr_code );

Line 2193: OE_Credit_Engine_GRP.GL_currency );

2189: IF G_debug_flag = 'Y'
2190: THEN
2191: OE_DEBUG_PUB.Add(' l_category_sum = ' || l_category_sum );
2192: OE_DEBUG_PUB.Add(' GL_CURRENCY = '||
2193: OE_Credit_Engine_GRP.GL_currency );
2194:
2195: OE_DEBUG_PUB.Add(' ------------------------------------ ');
2196: OE_DEBUG_PUB.Add(' ');
2197: END IF;

Line 2206: , p_functional_currency => OE_Credit_Engine_GRP.GL_currency

2202: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
2203: ( p_amount => l_category_sum
2204: , p_transactional_currency => p_header_rec.transactional_curr_code
2205: , p_limit_currency => l_item_limits(i).limit_curr_code
2206: , p_functional_currency => OE_Credit_Engine_GRP.GL_currency
2207: , p_conversion_date => SYSDATE
2208: , p_conversion_type => p_credit_check_rule_rec.conversion_type
2209: ) ;
2210:

Line 2270: OE_Credit_Engine_GRP.G_currency_error_msg :=

2266: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);
2267: FND_MESSAGE.Set_Token('TO',l_limit_curr );
2268: FND_MESSAGE.Set_Token('CONV',
2269: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate')) ;
2270: OE_Credit_Engine_GRP.G_currency_error_msg :=
2271: SUBSTR(FND_MESSAGE.GET,1,1000) ;
2272:
2273: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2274: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);

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

2526: p_header_id => p_header_rec.header_id ,
2527: p_line_id => NULL ,
2528: p_credit_check_rule_rec=>p_credit_check_rule_rec) = 'Y' THEN
2529: oe_debug_pub.ADD('slagiset: l_tolerance_check ' || l_tolerance_check);
2530: IF OE_CREDIT_ENGINE_GRP.CREDIT_TOLERANCE_CHECK( p_header_id => p_header_rec.header_id) THEN
2531: RETURN;
2532: END IF;
2533: ELSE
2534: oe_debug_pub.ADD('slagiset: No tolerance check is required. Since, there is no released hold for this order.');

Line 3127: OE_Credit_Engine_GRP.G_currency_error_msg := NULL ;

3123: x_return_status := FND_API.G_RET_STS_SUCCESS;
3124: G_result_out := 'PASS' ;
3125: l_global_exposure_flag := 'N' ;
3126: g_hold_exist := NULL ;
3127: OE_Credit_Engine_GRP.G_currency_error_msg := NULL ;
3128: IF G_debug_flag = 'Y' THEN
3129: OE_DEBUG_PUB.Add( 'Initial start G_result_out = '|| G_result_out );
3130: OE_DEBUG_PUB.Add( 'Initial start G_currency_error_msg = '||
3131: substr(OE_Credit_Engine_GRP.G_currency_error_msg,1,10)) ;

Line 3131: substr(OE_Credit_Engine_GRP.G_currency_error_msg,1,10)) ;

3127: OE_Credit_Engine_GRP.G_currency_error_msg := NULL ;
3128: IF G_debug_flag = 'Y' THEN
3129: OE_DEBUG_PUB.Add( 'Initial start G_result_out = '|| G_result_out );
3130: OE_DEBUG_PUB.Add( 'Initial start G_currency_error_msg = '||
3131: substr(OE_Credit_Engine_GRP.G_currency_error_msg,1,10)) ;
3132: OE_DEBUG_PUB.Add(' ');
3133: OE_DEBUG_PUB.Add(' -------------------------------------------- ');
3134: OE_DEBUG_PUB.Add(' Calling action = '|| p_calling_action);
3135: OE_DEBUG_PUB.Add(' Transaction Amount = '|| p_transaction_amount);

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

3208: -- check 5: overall limit |
3209: ----------------------------------------------------+
3210:
3211: --ER 12363706 start
3212: IF NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) = FND_API.G_TRUE
3213: THEN
3214: IF OE_CREDIT_ENGINE_GRP.TOLERANCE_CHECK_REQUIRED
3215: THEN
3216: oe_debug_pub.ADD('OEXVCRLB: Tolerance Check is required');

Line 3214: IF OE_CREDIT_ENGINE_GRP.TOLERANCE_CHECK_REQUIRED

3210:
3211: --ER 12363706 start
3212: IF NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) = FND_API.G_TRUE
3213: THEN
3214: IF OE_CREDIT_ENGINE_GRP.TOLERANCE_CHECK_REQUIRED
3215: THEN
3216: oe_debug_pub.ADD('OEXVCRLB: Tolerance Check is required');
3217: IF NOT OE_HOLDS_PUB.Hold_exists( p_hold_entity_code => 'O'
3218: , p_hold_entity_id => p_header_rec.header_id

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

3227: p_line_id => NULL ,
3228: p_credit_check_rule_rec=>p_credit_check_rule_rec) = 'Y'
3229: THEN
3230: oe_debug_pub.ADD('OEXVCRLB: Manual released hold exists.');
3231: IF OE_CREDIT_ENGINE_GRP.CREDIT_TOLERANCE_CHECK( p_header_id => p_header_rec.header_id)
3232: THEN
3233: OE_CREDIT_ENGINE_GRP.TOLERANCE_CHECK_REQUIRED := TRUE; -- slagiset: Resetting the value to NULL
3234: RETURN;
3235: END IF;

Line 3233: OE_CREDIT_ENGINE_GRP.TOLERANCE_CHECK_REQUIRED := TRUE; -- slagiset: Resetting the value to NULL

3229: THEN
3230: oe_debug_pub.ADD('OEXVCRLB: Manual released hold exists.');
3231: IF OE_CREDIT_ENGINE_GRP.CREDIT_TOLERANCE_CHECK( p_header_id => p_header_rec.header_id)
3232: THEN
3233: OE_CREDIT_ENGINE_GRP.TOLERANCE_CHECK_REQUIRED := TRUE; -- slagiset: Resetting the value to NULL
3234: RETURN;
3235: END IF;
3236: END IF;
3237: END IF;

Line 3241: OE_CREDIT_ENGINE_GRP.TOLERANCE_CHECK_REQUIRED := TRUE;

3237: END IF;
3238: END IF;
3239: END IF;
3240:
3241: OE_CREDIT_ENGINE_GRP.TOLERANCE_CHECK_REQUIRED := TRUE;
3242: --ER 12363706 end
3243:
3244: IF p_credit_check_rule_rec.CHECK_ITEM_CATEGORIES_FLAG = 'Y'
3245: THEN

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

3425: END IF;
3426:
3427: EXCEPTION
3428: WHEN FND_API.G_EXC_ERROR THEN
3429: OE_CREDIT_ENGINE_GRP.TOLERANCE_CHECK_REQUIRED := TRUE; -- ER 12363706
3430: IF G_debug_flag = 'Y' THEN
3431: OE_DEBUG_PUB.Add('Check_order_credit: Error ');
3432: END IF;
3433: x_return_status := FND_API.G_RET_STS_ERROR;

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

3431: OE_DEBUG_PUB.Add('Check_order_credit: Error ');
3432: END IF;
3433: x_return_status := FND_API.G_RET_STS_ERROR;
3434: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3435: OE_CREDIT_ENGINE_GRP.TOLERANCE_CHECK_REQUIRED := TRUE; -- ER 12363706
3436: IF G_debug_flag = 'Y' THEN
3437: OE_DEBUG_PUB.Add('Check_order_credit: Unexpected Error ');
3438: END IF;
3439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

3437: OE_DEBUG_PUB.Add('Check_order_credit: Unexpected Error ');
3438: END IF;
3439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3440: WHEN OTHERS THEN
3441: OE_CREDIT_ENGINE_GRP.TOLERANCE_CHECK_REQUIRED := TRUE; -- ER 12363706
3442: IF G_debug_flag = 'Y' THEN
3443: OE_DEBUG_PUB.Add('Check_order_credit: Other Unexpected Error ');
3444: END IF;
3445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;