[Home] [Help]
573: END IF;
574:
575: -- solin, use this profile to see whether we need calendar setup or not.
576: l_check_calendar :=
577: nvl(FND_PROFILE.Value('AS_SL_ASSIGN_CALENDAR_REQ'),'N');
578:
579: IF (AS_DEBUG_LOW_ON) THEN
580: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
581: 'Calling JTF_ASSIGN_PUB.Get_Assign_Lead_Resources');
1329: l_customer_id, l_address_id, l_assign_to_salesforce_id,
1330: l_assign_sales_group_id, l_referral_type, l_referred_by;
1331: CLOSE C_Get_Lead_Info;
1332:
1333: IF NVL(fnd_profile.value('AS_ENABLE_LEAD_ONLINE_TAP'), 'Y') = 'N' AND
1334: l_assign_to_salesforce_id IS NOT NULL
1335: THEN
1336: IF (AS_DEBUG_LOW_ON) THEN
1337: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2426:
2427: RETURN;
2428: ELSE
2429: */
2430: IF NVL(fnd_profile.value('AS_ENABLE_LEAD_ONLINE_TAP'), 'Y') = 'Y'
2431: THEN
2432: -- 1. If AS_ENABLE_LEAD_ONLINE_TAP is 'Y', delete record.
2433: -- 2. If AS_ENABLE_LEAD_ONLINE_TAP is 'N', still keep it in
2434: -- as_changed_accounts_all, so TAP New Mode will pick up this
3124: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3125: 'Trigger mode:' || P_Trigger_Mode);
3126: END IF;
3127:
3128: IF NVL(fnd_profile.value('AS_ENABLE_LEAD_ONLINE_TAP'),'Y') = 'Y'
3129: AND (P_Trigger_Mode = 'ON-DELETE')
3130: THEN
3131: -- IF (P_Trigger_Mode IN ('ON-INSERT', 'ON-DELETE'))
3132: -- IF (P_Trigger_Mode = 'ON-DELETE')
4378: AND sl.status_code = sta.status_code
4379: AND sl.lead_rank_id = rk.rank_id(+);
4380: BEGIN
4381: x_return_status := FND_API.G_RET_STS_SUCCESS;
4382: l_resource_id := fnd_profile.value('AS_DEFAULT_RESOURCE_ID');
4383: IF l_resource_id IS NULL
4384: THEN
4385: IF (AS_DEBUG_LOW_ON) THEN
4386: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4453: l_reject_reason_code, l_lead_rank_id,
4454: l_qualified_flag, l_freeze_flag, l_status_code;
4455: CLOSE c_sales_lead;
4456:
4457: -- l_routing_status := fnd_profile.value('AS_LEAD_ROUTING_STATUS');
4458: -- IF (AS_DEBUG_LOW_ON) THEN AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4459: -- 'Lead Status on Routing:'|| l_routing_status); END IF;
4460:
4461: -- Call API to create log entry
4796: l_reject_reason_code, l_lead_rank_id,
4797: l_qualified_flag, l_freeze_flag, l_status_code;
4798: CLOSE c_sales_lead;
4799:
4800: -- l_routing_status := fnd_profile.value('AS_LEAD_ROUTING_STATUS');
4801:
4802: -- Call API to create log entry
4803: AS_SALES_LEADS_LOG_PKG.Insert_Row(
4804: px_log_id => l_sales_lead_log_id ,
5099: l_resource_id := g_i_resource_id(l_i);
5100: l_group_id := g_i_group_id(l_i);
5101: ELSE
5102: -- no owner found, get owner from profile
5103: l_resource_id := fnd_profile.value('AS_DEFAULT_CM_FOR_LEAD');
5104:
5105: IF (AS_DEBUG_LOW_ON) THEN
5106: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5107: 'AS_DEFAULT_CM=' || l_resource_id);
5133: l_reject_reason_code, l_lead_rank_id,
5134: l_qualified_flag, l_status_code;
5135: CLOSE c_sales_lead;
5136:
5137: -- l_routing_status := fnd_profile.value('AS_LEAD_ROUTING_STATUS');
5138:
5139: -- Call API to create log entry
5140: AS_SALES_LEADS_LOG_PKG.Insert_Row(
5141: px_log_id => l_sales_lead_log_id ,
5356: FROM jtf_rs_resource_extns res
5357: WHERE res.resource_id = c_resource_id;
5358:
5359: BEGIN
5360: l_rs_id := fnd_profile.value('AS_DEFAULT_RESOURCE_ID');
5361: IF l_rs_id IS NULL
5362: THEN
5363: IF (AS_DEBUG_LOW_ON) THEN
5364: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5524: l_resource_flag_tbl;
5525: CLOSE c_get_lead_resource;
5526:
5527: l_check_calendar :=
5528: NVL(FND_PROFILE.Value('AS_SL_ASSIGN_CALENDAR_REQ'),'N');
5529: IF (AS_DEBUG_LOW_ON) THEN
5530: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5531: 'l_resource_id_tbl.count=' || l_resource_id_tbl.count);
5532: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5931: l_reject_reason_code, l_lead_rank_id,
5932: l_qualified_flag, l_status_code;
5933: CLOSE c_sales_lead;
5934:
5935: -- l_routing_status := fnd_profile.value('AS_LEAD_ROUTING_STATUS');
5936:
5937: -- Call API to create log entry
5938: AS_SALES_LEADS_LOG_PKG.Insert_Row(
5939: px_log_id => l_sales_lead_log_id ,
6154: -- Referral type is not null, for CAPRI
6155: Get_Partner_Lead_Owner(p_sales_lead_id);
6156: ELSE
6157: l_assign_manual_flag :=
6158: nvl(FND_PROFILE.Value('AS_LEAD_ASSIGN_MANUAL'),'N');
6159: IF (AS_DEBUG_LOW_ON) THEN
6160: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
6161: 'manual assign profile=' || l_assign_manual_flag);
6162: END IF;
6162: END IF;
6163:
6164: IF l_assign_manual_flag = 'N'
6165: THEN
6166: IF fnd_profile.value('ASF_IS_ORACLE_INTERNAL') = 'Y'
6167: THEN
6168: -- Debug Message
6169: IF (AS_DEBUG_LOW_ON) THEN
6170: AS_UTILITY_PVT.Debug_Message(
6235: END IF; -- referral type IS NOT NULL
6236:
6237: -- If profile "OS: Enable Real Time Lead Assignment" is set to 'N',
6238: -- only owner will be left for this transaction.
6239: IF NVL(fnd_profile.value('AS_ENABLE_LEAD_ONLINE_TAP'), 'Y') = 'N'
6240: THEN
6241: IF (AS_DEBUG_LOW_ON) THEN
6242: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
6243: 'Lead Online TAP is disabled!');