APPS.AS_SALES_METH_WF dependencies on JTF_RS_RESOURCE_EXTNS

Line 100: FROM jtf_rs_resource_extns

96: AND a.profile_option_name = 'AS_SM_CREATE_TASKS'
97: AND b.application_id =279;
98: CURSOR c_resource IS
99: SELECT decode(category,'EMPLOYEE','RS_EMPLOYEE','PARTNER','RS_PARTNER','PARTY','RS_PARTY')
100: FROM jtf_rs_resource_extns
101: WHERE resource_id = p_owner_id ;
102: CURSOR c_meth IS
103: SELECT b.autocreatetask_flag,b.sales_methodology_id
104: FROM as_leads_all a,as_sales_methodology_b b

Line 203: l_error_msg := 'Category for resource not found in jtf_rs_resource_extns table';

199: FETCH c_resource INTO l_category;
200: PRINT_MESSAGE('category:'||l_category);
201: IF (c_resource%NOTFOUND ) THEN
202: CLOSE c_resource;
203: l_error_msg := 'Category for resource not found in jtf_rs_resource_extns table';
204: PRINT_MESSAGE('p_error_msg = ' || l_error_msg);
205: fnd_message.set_name('AS','AS_INVALID_RESOURCE');
206: fnd_msg_pub.add;
207: RAISE fnd_api.g_exc_unexpected_error;