APPS.FII_SETUP_VAL_C dependencies on FII_CC_MGR_SUP_V

Line 231: -- Make sure that the username pass in exists in fii_cc_mgr_sup_v

227: BEGIN
228: ----------------------------------------------------------------------
229: -- User Setup Validations
230: ----------------------------------------------------------------------
231: -- Make sure that the username pass in exists in fii_cc_mgr_sup_v
232: ----------------------------------------------------------------------
233: fii_util.put_line(' ');
234: fii_util.put_line(
235: '+---------------------------------------------------------------------+');

Line 244: fii_util.put_line('Performing Check for: User exists in fii_cc_mgr_sup_v');

240: '********************** User Setup Validations ************************');
241: fii_util.put_line(
242: '***********************************************************************');
243: fii_util.put_line(' ');
244: fii_util.put_line('Performing Check for: User exists in fii_cc_mgr_sup_v');
245: fii_util.put_line(
246: '+---------------------------------------------------------------------+');
247: -- Check if user exists in manager view
248: fii_util.put_line('START CHECK: User exists in fii_cc_mgr_sup_v');

Line 248: fii_util.put_line('START CHECK: User exists in fii_cc_mgr_sup_v');

244: fii_util.put_line('Performing Check for: User exists in fii_cc_mgr_sup_v');
245: fii_util.put_line(
246: '+---------------------------------------------------------------------+');
247: -- Check if user exists in manager view
248: fii_util.put_line('START CHECK: User exists in fii_cc_mgr_sup_v');
249: fii_util.put_line(' ');
250:
251: -- Set a default value for l_user_id
252: l_user_id := -1;

Line 254: -- Retrieve fnd user ID from the username if it exists in fii_cc_mgr_sup_v

250:
251: -- Set a default value for l_user_id
252: l_user_id := -1;
253:
254: -- Retrieve fnd user ID from the username if it exists in fii_cc_mgr_sup_v
255: BEGIN
256: SELECT DISTINCT employee_id
257: INTO l_user_id
258: FROM fnd_user a,

Line 259: fii_cc_mgr_sup_v b

255: BEGIN
256: SELECT DISTINCT employee_id
257: INTO l_user_id
258: FROM fnd_user a,
259: fii_cc_mgr_sup_v b
260: WHERE a.user_name = UPPER(p_user_name)
261: AND a.employee_id = b.id;
262: EXCEPTION
263: WHEN no_data_found THEN

Line 265: 'is not found in fii_cc_mgr_sup_v');

261: AND a.employee_id = b.id;
262: EXCEPTION
263: WHEN no_data_found THEN
264: fii_util.put_line('The username '|| p_user_name ||
265: 'is not found in fii_cc_mgr_sup_v');
266:
267: END;
268:
269: fii_util.put_line('Username parameter = ' || p_user_name ||

Line 275: ' does not have a person attached to it or the person does not exist in fii_cc_mgr_sup_v');

271:
272: fii_util.put_line(' ');
273: IF (l_user_id = -1) THEN
274: fii_util.put_line('DIAGNOSIS: The user ' || p_user_name ||
275: ' does not have a person attached to it or the person does not exist in fii_cc_mgr_sup_v');
276:
277: ELSE
278: fii_util.put_line('DIAGNOSIS: A person is attached to the user ' || p_user_name ||
279: ' and this person exists in fii_cc_mgr_sup_v');

Line 279: ' and this person exists in fii_cc_mgr_sup_v');

275: ' does not have a person attached to it or the person does not exist in fii_cc_mgr_sup_v');
276:
277: ELSE
278: fii_util.put_line('DIAGNOSIS: A person is attached to the user ' || p_user_name ||
279: ' and this person exists in fii_cc_mgr_sup_v');
280: fii_util.put_line('DIAGNOSIS: NO ACTION is needed.');
281: END IF;
282:
283: fii_util.put_line(' ');

Line 284: fii_util.put_line('END CHECK: User exists in fii_cc_mgr_sup_v');

280: fii_util.put_line('DIAGNOSIS: NO ACTION is needed.');
281: END IF;
282:
283: fii_util.put_line(' ');
284: fii_util.put_line('END CHECK: User exists in fii_cc_mgr_sup_v');
285: fii_util.put_line(
286: '+---------------------------------------------------------------------+');
287:
288: ----------------------------------------------------------------------