[Home] [Help]
574: END IF;
575:
576: -- solin, use this profile to see whether we need calendar setup or not.
577: l_check_calendar :=
578: nvl(FND_PROFILE.Value('AS_SL_ASSIGN_CALENDAR_REQ'),'N');
579:
580: IF (AS_DEBUG_LOW_ON) THEN
581: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
582: 'Calling JTF_ASSIGN_PUB.Get_Assign_Lead_Resources');
1330: l_customer_id, l_address_id, l_assign_to_salesforce_id,
1331: l_assign_sales_group_id, l_referral_type, l_referred_by;
1332: CLOSE C_Get_Lead_Info;
1333:
1334: IF NVL(fnd_profile.value('AS_ENABLE_LEAD_ONLINE_TAP'), 'Y') = 'N' AND
1335: l_assign_to_salesforce_id IS NOT NULL
1336: THEN
1337: IF (AS_DEBUG_LOW_ON) THEN
1338: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2427:
2428: RETURN;
2429: ELSE
2430: */
2431: IF NVL(fnd_profile.value('AS_ENABLE_LEAD_ONLINE_TAP'), 'Y') = 'Y'
2432: THEN
2433: -- 1. If AS_ENABLE_LEAD_ONLINE_TAP is 'Y', delete record.
2434: -- 2. If AS_ENABLE_LEAD_ONLINE_TAP is 'N', still keep it in
2435: -- as_changed_accounts_all, so TAP New Mode will pick up this
3125: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3126: 'Trigger mode:' || P_Trigger_Mode);
3127: END IF;
3128:
3129: IF NVL(fnd_profile.value('AS_ENABLE_LEAD_ONLINE_TAP'),'Y') = 'Y'
3130: AND (P_Trigger_Mode = 'ON-DELETE')
3131: THEN
3132: -- IF (P_Trigger_Mode IN ('ON-INSERT', 'ON-DELETE'))
3133: -- IF (P_Trigger_Mode = 'ON-DELETE')
4386: SELECT user_id from jtf_rs_resource_extns
4387: WHERE resource_id= c_resource_id;
4388: BEGIN
4389: x_return_status := FND_API.G_RET_STS_SUCCESS;
4390: --l_resource_id := fnd_profile.value('AS_DEFAULT_RESOURCE_ID'); --code commented for bug12766399
4391:
4392: --code added for bug12766399
4393: OPEN C_get_user_id(p_resource_id);
4394: FETCH C_get_user_id INTO l_user_id;
4394: FETCH C_get_user_id INTO l_user_id;
4395: CLOSE C_get_user_id;
4396:
4397: IF l_user_id IS NOT NULL THEN
4398: l_resource_id := fnd_profile.VALUE_SPECIFIC(NAME => 'AS_DEFAULT_RESOURCE_ID', USER_ID => L_USER_ID);
4399: END IF;
4400:
4401: IF l_user_id IS NULL OR l_resource_id IS NULL THEN
4402: l_resource_id := fnd_profile.value('AS_DEFAULT_RESOURCE_ID');
4398: l_resource_id := fnd_profile.VALUE_SPECIFIC(NAME => 'AS_DEFAULT_RESOURCE_ID', USER_ID => L_USER_ID);
4399: END IF;
4400:
4401: IF l_user_id IS NULL OR l_resource_id IS NULL THEN
4402: l_resource_id := fnd_profile.value('AS_DEFAULT_RESOURCE_ID');
4403: END IF;
4404:
4405: IF l_resource_id IS NULL
4406: THEN
4475: l_reject_reason_code, l_lead_rank_id,
4476: l_qualified_flag, l_freeze_flag, l_status_code;
4477: CLOSE c_sales_lead;
4478:
4479: -- l_routing_status := fnd_profile.value('AS_LEAD_ROUTING_STATUS');
4480: -- IF (AS_DEBUG_LOW_ON) THEN AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4481: -- 'Lead Status on Routing:'|| l_routing_status); END IF;
4482:
4483: -- Call API to create log entry
4820: l_reject_reason_code, l_lead_rank_id,
4821: l_qualified_flag, l_freeze_flag, l_status_code;
4822: CLOSE c_sales_lead;
4823:
4824: -- l_routing_status := fnd_profile.value('AS_LEAD_ROUTING_STATUS');
4825:
4826: -- Call API to create log entry
4827: AS_SALES_LEADS_LOG_PKG.Insert_Row(
4828: px_log_id => l_sales_lead_log_id ,
5123: l_resource_id := g_i_resource_id(l_i);
5124: l_group_id := g_i_group_id(l_i);
5125: ELSE
5126: -- no owner found, get owner from profile
5127: l_resource_id := fnd_profile.value('AS_DEFAULT_CM_FOR_LEAD');
5128:
5129: IF (AS_DEBUG_LOW_ON) THEN
5130: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5131: 'AS_DEFAULT_CM=' || l_resource_id);
5157: l_reject_reason_code, l_lead_rank_id,
5158: l_qualified_flag, l_status_code;
5159: CLOSE c_sales_lead;
5160:
5161: -- l_routing_status := fnd_profile.value('AS_LEAD_ROUTING_STATUS');
5162:
5163: -- Call API to create log entry
5164: AS_SALES_LEADS_LOG_PKG.Insert_Row(
5165: px_log_id => l_sales_lead_log_id ,
5380: FROM jtf_rs_resource_extns res
5381: WHERE res.resource_id = c_resource_id;
5382:
5383: BEGIN
5384: l_rs_id := fnd_profile.value('AS_DEFAULT_RESOURCE_ID');
5385: IF l_rs_id IS NULL
5386: THEN
5387: IF (AS_DEBUG_LOW_ON) THEN
5388: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5548: l_resource_flag_tbl;
5549: CLOSE c_get_lead_resource;
5550:
5551: l_check_calendar :=
5552: NVL(FND_PROFILE.Value('AS_SL_ASSIGN_CALENDAR_REQ'),'N');
5553: IF (AS_DEBUG_LOW_ON) THEN
5554: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5555: 'l_resource_id_tbl.count=' || l_resource_id_tbl.count);
5556: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5955: l_reject_reason_code, l_lead_rank_id,
5956: l_qualified_flag, l_status_code;
5957: CLOSE c_sales_lead;
5958:
5959: -- l_routing_status := fnd_profile.value('AS_LEAD_ROUTING_STATUS');
5960:
5961: -- Call API to create log entry
5962: AS_SALES_LEADS_LOG_PKG.Insert_Row(
5963: px_log_id => l_sales_lead_log_id ,
6179: -- Referral type is not null, for CAPRI
6180: Get_Partner_Lead_Owner(p_sales_lead_id);
6181: ELSE
6182: l_assign_manual_flag :=
6183: nvl(FND_PROFILE.Value('AS_LEAD_ASSIGN_MANUAL'),'N');
6184: IF (AS_DEBUG_LOW_ON) THEN
6185: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
6186: 'manual assign profile=' || l_assign_manual_flag);
6187: END IF;
6187: END IF;
6188:
6189: IF l_assign_manual_flag = 'N'
6190: THEN
6191: IF fnd_profile.value('ASF_IS_ORACLE_INTERNAL') = 'Y'
6192: THEN
6193: -- Debug Message
6194: IF (AS_DEBUG_LOW_ON) THEN
6195: AS_UTILITY_PVT.Debug_Message(
6262: END IF; -- referral type IS NOT NULL
6263:
6264: -- If profile "OS: Enable Real Time Lead Assignment" is set to 'N',
6265: -- only owner will be left for this transaction.
6266: IF NVL(fnd_profile.value('AS_ENABLE_LEAD_ONLINE_TAP'), 'Y') = 'N'
6267: THEN
6268: IF (AS_DEBUG_LOW_ON) THEN
6269: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
6270: 'Lead Online TAP is disabled!');