DBA Data[Home] [Help]

APPS.AS_SALES_LEAD_ENGINE_PVT dependencies on FND_PROFILE

Line 342: FND_PROFILE.Value('AS_LEAD_INCUBATION_CHANNEL')

338:
339: IF l_sales_lead_rec.qualified_flag = 'N'
340: THEN
341: IF l_sales_lead_rec.channel_code =
342: FND_PROFILE.Value('AS_LEAD_INCUBATION_CHANNEL')
343: THEN
344: x_lead_engines_out_rec.sales_team_flag := 'N';
345: ELSE
346: x_lead_engines_out_rec.sales_team_flag := 'Y';

Line 381: 'Chinar giving default' || FND_PROFILE.Value('AS_DEF_RATING_UNQUAL_LEADS'));

377: l_sales_lead_rec.lead_rank_id = FND_API.G_MISS_NUM
378: THEN
379: IF (AS_DEBUG_LOW_ON) THEN
380: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
381: 'Chinar giving default' || FND_PROFILE.Value('AS_DEF_RATING_UNQUAL_LEADS'));
382: END IF;
383: l_sales_lead_rec.lead_rank_id := FND_PROFILE.Value('AS_DEF_RATING_UNQUAL_LEADS');
384: x_lead_engines_out_rec.lead_rank_id :=
385: l_sales_lead_rec.lead_rank_id;

Line 383: l_sales_lead_rec.lead_rank_id := FND_PROFILE.Value('AS_DEF_RATING_UNQUAL_LEADS');

379: IF (AS_DEBUG_LOW_ON) THEN
380: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
381: 'Chinar giving default' || FND_PROFILE.Value('AS_DEF_RATING_UNQUAL_LEADS'));
382: END IF;
383: l_sales_lead_rec.lead_rank_id := FND_PROFILE.Value('AS_DEF_RATING_UNQUAL_LEADS');
384: x_lead_engines_out_rec.lead_rank_id :=
385: l_sales_lead_rec.lead_rank_id;
386: -- ckapoor Disqualification project call sales lead table handler to save this value of lead_rank_id
387:

Line 528: FND_PROFILE.Value('AS_LEAD_INCUBATION_CHANNEL')

524: x_lead_engines_out_rec.indirect_channel_flag := 'N';
525: END IF;
526:
527: IF l_sales_lead_rec.channel_code =
528: FND_PROFILE.Value('AS_LEAD_INCUBATION_CHANNEL')
529: THEN
530: x_lead_engines_out_rec.sales_team_flag := 'N';
531: ELSE
532: x_lead_engines_out_rec.sales_team_flag := 'Y';

Line 1892: -- l_filter_unqual_leads := FND_PROFILE.value('AS_FILTER_UNQUALIFIED_LEADS');

1888:
1889:
1890: -- if (p_process_type = 'LEAD_QUALIFICATION') then
1891:
1892: -- l_filter_unqual_leads := FND_PROFILE.value('AS_FILTER_UNQUALIFIED_LEADS');
1893:
1894: -- AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1895: -- 'filterprofile'||l_filter_unqual_leads);
1896:

Line 2193: TO_NUMBER(FND_PROFILE.Value('AS_DEFAULT_LEAD_ENGINE_RANK'));

2189: -- no rules matched
2190: IF p_process_type = G_LEAD_RATING
2191: THEN
2192: l_default_lead_rank_id :=
2193: TO_NUMBER(FND_PROFILE.Value('AS_DEFAULT_LEAD_ENGINE_RANK'));
2194: l_lead_rank_id := l_default_lead_rank_id;
2195: IF (AS_DEBUG_LOW_ON) THEN
2196: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2197: 'Default rank:' || l_default_lead_rank_id);

Line 2241: FND_PROFILE.Value('AS_DEFAULT_LEAD_ENGINE_CHANNEL');

2237: -- ckapoor changed.
2238: ELSIF p_process_type = G_CHANNEL_SELECTION
2239: THEN
2240: l_default_channel_code :=
2241: FND_PROFILE.Value('AS_DEFAULT_LEAD_ENGINE_CHANNEL');
2242: IF (AS_DEBUG_LOW_ON) THEN
2243: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2244: 'Default channel:' || l_default_channel_code);
2245: END IF;

Line 2263: l_default_qualified_flag := FND_PROFILE.Value('AS_DEFAULT_LEAD_ENGINE_QUALIFIED_FLAG');

2259:
2260: -- ckapoor changed
2261: ELSIF p_process_type = G_LEAD_QUALIFICATION -- qualification case
2262: THEN
2263: l_default_qualified_flag := FND_PROFILE.Value('AS_DEFAULT_LEAD_ENGINE_QUALIFIED_FLAG');
2264: IF (AS_DEBUG_LOW_ON) THEN
2265: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2266: 'Default qualified flag:' || l_default_qualified_flag);
2267: END IF;

Line 2334: -- l_filter_unqual_leads := FND_PROFILE.value('AS_FILTER_UNQUALIFIED_LEADS');

2330: -- if no rules match, then check for default qual flag
2331:
2332: -- if (p_process_type = 'LEAD_QUALIFICATION') then
2333:
2334: -- l_filter_unqual_leads := FND_PROFILE.value('AS_FILTER_UNQUALIFIED_LEADS');
2335:
2336: -- if ((l_filter_unqual_leads = 'Y') and (l_is_create_import_mode_val='Y') and
2337: -- (l_default_qualified_flag = 'N')) then
2338: -- AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 2738: IF NVL(fnd_profile.value('AS_ENABLE_LEAD_ONLINE_TAP'), 'N') = 'Y' AND

2734:
2735: -- Condition modified for bug 7654339
2736: -- Creator to be deleted from Sales Team in Real Time TAP when there are winning resources from TAP
2737: --Code modified for bug12766399
2738: IF NVL(fnd_profile.value('AS_ENABLE_LEAD_ONLINE_TAP'), 'N') = 'Y' AND
2739: l_created_by_tap_flag = 'Y' THEN
2740:
2741: DELETE from as_accesses_all acc
2742: WHERE acc.sales_lead_id = p_sales_lead_id

Line 2750: NVL(fnd_profile.value('AS_ENABLE_LEAD_ONLINE_TAP'), 'N') = 'Y' --Code modified for bug12766399

2746:
2747: -- condition modified for bug 7654339
2748: IF NVL(l_freeze_flag,'N') = 'N' AND
2749: l_created_by_tap_flag = 'Y' AND
2750: NVL(fnd_profile.value('AS_ENABLE_LEAD_ONLINE_TAP'), 'N') = 'Y' --Code modified for bug12766399
2751: THEN
2752: As_Sales_Lead_Assign_PVT.Find_Lead_Owner(
2753: p_sales_lead_id, p_salesgroup_id, l_request_id,P_identity_salesforce_id, --code added for bug12766399
2754: l_return_status, x_msg_count, x_msg_data);

Line 2848: FND_PROFILE.Value('AS_AUTO_CONVERT_LEAD_OPP') = 'Y'

2844: 'indirect?' || L_Lead_Engines_Out_Rec.indirect_channel_flag);
2845: END IF;
2846: IF L_Lead_Engines_Out_Rec.indirect_channel_flag = 'Y' AND
2847: L_Lead_Engines_Out_Rec.qualified_flag = 'Y' AND
2848: FND_PROFILE.Value('AS_AUTO_CONVERT_LEAD_OPP') = 'Y'
2849: THEN
2850: As_Sales_Lead_Opp_PVT.Create_Opportunity_For_Lead(
2851: P_Api_Version_Number => 2.0,
2852: P_Init_Msg_List => FND_API.G_FALSE,

Line 2969: -- IF NVL(fnd_profile.value('AS_ENABLE_LEAD_ONLINE_TAP'), 'Y') = 'Y'

2965: UPDATE AS_CHANGED_ACCOUNTS_ALL
2966: SET processed_flag = 'Y'
2967: WHERE sales_lead_id = p_sales_lead_id;
2968: END;
2969: -- IF NVL(fnd_profile.value('AS_ENABLE_LEAD_ONLINE_TAP'), 'Y') = 'Y'
2970: -- THEN
2971: -- 1. If AS_ENABLE_LEAD_ONLINE_TAP is 'Y', update record.
2972: -- 2. If AS_ENABLE_LEAD_ONLINE_TAP is 'N', still keep it in
2973: -- as_changed_accounts_all, so TAP New Mode will pick up this

Line 3230: l_auto_run_lead_engines := FND_PROFILE.Value('AS_AUTO_RUN_LEAD_ENGINES');

3226: l_status_code, l_reject_reason_code;
3227: CLOSE C_Get_Lead_Info;
3228:
3229: -- Profile OS: Auto Run Lead Engines While Update
3230: l_auto_run_lead_engines := FND_PROFILE.Value('AS_AUTO_RUN_LEAD_ENGINES');
3231: IF (AS_DEBUG_LOW_ON) THEN
3232: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3233: 'auto run engine=' || l_auto_run_lead_engines);
3234: END IF;

Line 3265: FND_PROFILE.Value('AS_LEAD_INCUBATION_CHANNEL')

3261: l_lead_engines_out_rec.indirect_channel_flag;
3262: CLOSE c_get_indirect_channel_flag;
3263:
3264: IF l_lead_engines_out_rec.channel_code =
3265: FND_PROFILE.Value('AS_LEAD_INCUBATION_CHANNEL')
3266: THEN
3267: l_lead_engines_out_rec.sales_team_flag := 'N';
3268: ELSE
3269: l_lead_engines_out_rec.sales_team_flag := 'Y';

Line 3351: FND_PROFILE.Value('AS_AUTO_CONVERT_LEAD_OPP') = 'Y' AND

3347: END IF;
3348: END IF;
3349:
3350: IF L_Lead_Engines_Out_Rec.indirect_channel_flag = 'Y' AND
3351: FND_PROFILE.Value('AS_AUTO_CONVERT_LEAD_OPP') = 'Y' AND
3352: l_status_code <> 'CONVERTED_TO_OPPORTUNITY'
3353: THEN
3354: As_Sales_Lead_Opp_PVT.Create_Opportunity_For_Lead(
3355: P_Api_Version_Number => 2.0,

Line 3609: -- IF NVL(fnd_profile.value('AS_ENABLE_LEAD_ONLINE_TAP'), 'Y') = 'Y'

3605: UPDATE AS_CHANGED_ACCOUNTS_ALL
3606: SET processed_flag = 'Y'
3607: WHERE sales_lead_id = p_sales_lead_id;
3608: END;
3609: -- IF NVL(fnd_profile.value('AS_ENABLE_LEAD_ONLINE_TAP'), 'Y') = 'Y'
3610: -- THEN
3611: -- 1. If AS_ENABLE_LEAD_ONLINE_TAP is 'Y', delete record.
3612: -- 2. If AS_ENABLE_LEAD_ONLINE_TAP is 'N', still keep it in
3613: -- as_changed_accounts_all, so TAP New Mode will pick up this