APPS.ASO_DEAL_PUB dependencies on FND_PROFILE

Line 191: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

187:
188: BEGIN
189:
190:
191: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
192: --pp_debug('In update deal'|| aso_debug_pub.g_debug_flag);
193: if aso_debug_pub.g_debug_flag='Y' then -- enabling trace
194: aso_debug_pub.SetDebugLevel(10);
195: aso_debug_pub.Initialize;

Line 315: l_db_link := FND_PROFILE.VALUE('QPR_PN_DBLINK') ;

311: where quote_header_id=p_quote_header_id;
312:
313:
314: ELSIF p_event = 'ACCEPTED' THEN
315: l_db_link := FND_PROFILE.VALUE('QPR_PN_DBLINK') ;
316:
317: IF l_db_link is NOT NULL THEN
318: l_db_link := '@' || l_db_link;
319: END IF;

Line 391: l_modifier_line_profile:=fnd_profile.value('QPR_DEAL_DIFF_MODIFIER');

387: IF aso_debug_pub.g_debug_flag='Y' THEN
388: aso_debug_pub.add( 'In call update quote from deal API Before Price Adjustment' , 1 ,'Y') ;
389: end if;
390: /*
391: l_modifier_line_profile:=fnd_profile.value('QPR_DEAL_DIFF_MODIFIER');
392: L_modifier_line_id:=to_number(l_modifier_line_profile);
393:
394: IF L_modifier_line_id is NULL THEN
395: FND_MESSAGE.SET_NAME('ASO','ASO_DEAL_PRC_PROFILE_NOT_SET');

Line 530: l_modifier_line_profile:=fnd_profile.value('QPR_DEAL_DIFF_MODIFIER');

526:
527: -- New Coding for already applied line level adjustments
528:
529: -- Getting the modifier profile value
530: l_modifier_line_profile:=fnd_profile.value('QPR_DEAL_DIFF_MODIFIER');
531: L_modifier_line_id:=to_number(l_modifier_line_profile);
532:
533:
534: for cur_auto_adj in cur_app_adj(p_quote_header_id,l_quote_line_id,l_modifier_line_id)

Line 595: /* l_modifier_line_profile:=fnd_profile.value('QPR_DEAL_DIFF_MODIFIER');

591:
592: if (l_updated_line_price is not null) and (l_line_quote_price<>l_updated_line_price) then -- checking if price has been modified or not
593:
594:
595: /* l_modifier_line_profile:=fnd_profile.value('QPR_DEAL_DIFF_MODIFIER');
596: L_modifier_line_id:=to_number(l_modifier_line_profile);
597: */
598: IF aso_debug_pub.g_debug_flag='Y' THEN
599: aso_debug_pub.add( 'Line Modifier Value'||L_modifier_line_id, 1 ) ;

Line 925: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

921: l_status_override VARCHAR2(1) := 'Y';
922:
923: BEGIN
924:
925: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
926:
927: -- API body
928: IF aso_debug_pub.g_debug_flag = 'Y' THEN
929: aso_debug_pub.add('ASO_DEAL_PUB: ****** Start of Get_Deal_Access API ******', 1, 'Y');

Line 966: l_status_override :=nvl(fnd_profile.value('ASO_STATUS_OVERRIDE'),'N');

962: INTO t_update_allowed_flag
963: FROM aso_quote_statuses_b
964: WHERE quote_status_id = l_quote_status_id;
965:
966: l_status_override :=nvl(fnd_profile.value('ASO_STATUS_OVERRIDE'),'N');
967:
968: If (t_update_allowed_flag='N' and l_status_override = 'N') then
969: l_access_level:='READ';
970: end if;

Line 1000: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

996: l_quote_number NUMBER;
997:
998: BEGIN
999:
1000: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
1001:
1002: -- API body
1003: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1004: aso_debug_pub.add('ASO_DEAL_PUB: ****** Start of Get_Deal_Enable_Buttons API ******', 1, 'Y');