[Home] [Help]
228: END IF;
229: RAISE FND_API.G_EXC_ERROR;
230: END IF;
231:
232: if fnd_profile.value('AS_RUN_LEAD_MONITOR_ENGINE') = 'Y' then
233: -- ******************************************************************
234: -- Get Lead Country and Rank
235: -- ******************************************************************
236: open c_get_lead_info (P_Sales_Lead_Id);
2161: itemtype => itemtype,
2162: itemkey => itemkey,
2163: aname => 'TIMEOUT_CURR_REROUTES');
2164:
2165: l_max_reroutes := fnd_profile.value('AS_MAX_WF_LEAD_REROUTES');
2166:
2167: -- swkhanna Jun18,03
2168: -- Get escalation Manager profile value
2169: l_esc_mgr_resource_id := fnd_profile.value('AS_LEAD_ESC_MGR_RESOURCE_ID');
2165: l_max_reroutes := fnd_profile.value('AS_MAX_WF_LEAD_REROUTES');
2166:
2167: -- swkhanna Jun18,03
2168: -- Get escalation Manager profile value
2169: l_esc_mgr_resource_id := fnd_profile.value('AS_LEAD_ESC_MGR_RESOURCE_ID');
2170:
2171:
2172: OPEN c_esc_username (l_esc_mgr_resource_id);
2173: FETCH c_esc_username INTO l_source_id, l_source_name, l_source_email, l_esc_username;
2602:
2603: IF funcmode = 'RUN'
2604: THEN
2605:
2606: l_rs_id := fnd_profile.value('AS_DEFAULT_RESOURCE_ID');
2607: IF l_rs_id IS NULL
2608: THEN
2609:
2610: -- Profile is not set. hence going against the logged in user
3026: l_timeout := p_timeout;
3027: l_total_timeout := p_timeout;
3028:
3029: /* 3/20/03 swkhanna - commented out following to fix bug 2832001
3030: l_server_timezone_id := fnd_profile.value('AMS_SYSTEM_TIMEZONE_ID');
3031:
3032: select timezone_id
3033: into l_GMT_timezone_id
3034: from hz_timezones_vl
3201: l_mgr_source_name VARCHAR2(360);
3202: l_mgr_source_email VARCHAR2(2000);
3203: l_mgr_name VARCHAR2(320);
3204: l_mgr_display_name VARCHAR2(360);
3205: l_default_resource_id NUMBER := fnd_profile.value('AS_DEFAULT_RESOURCE_ID');
3206: l_source_username VARCHAR2(60);
3207:
3208:
3209: -- Get lead info