DBA Data[Home] [Help]

APPS.JTF_AUTH_BULKLOAD_PKG dependencies on APP_EXCEPTION

Line 28: app_exception.raise_exception;

24: where user_name=U_USER_NAME;
25:
26: if cnt=0 then
27: fnd_message.set_name('JTF', 'JTF-1055');
28: app_exception.raise_exception;
29: end if;
30:
31: select count(*) into cnt
32: from jtf_auth_principals_b

Line 37: app_exception.raise_exception;

33: where principal_name=U_ROLE_NAME and is_user_flag=0;
34:
35: if cnt=0 then
36: fnd_message.set_name('JTF', 'JTF-1056');
37: app_exception.raise_exception;
38: end if;
39:
40: select count(*) into cnt
41: from jtf_auth_principals_b

Line 156: app_exception.raise_exception;

152: where user_name=U_USER_NAME;
153:
154: if cnt=0 then
155: fnd_message.set_name('JTF', 'JTF-1055');
156: app_exception.raise_exception;
157: end if;
158:
159: select count(*) into cnt
160: from jtf_auth_principals_b

Line 165: app_exception.raise_exception;

161: where principal_name=U_ROLE_NAME and is_user_flag=0;
162:
163: if cnt=0 then
164: fnd_message.set_name('JTF', 'JTF-1056');
165: app_exception.raise_exception;
166: end if;
167:
168:
169: select count(*) into cnt

Line 241: app_exception.raise_exception;

237:
238: exception
239: when table_error then
240: fnd_message.set_name('JTF', 'JTF-1049');
241: app_exception.raise_exception;
242:
243:
244:
245: end ASSIGN_ROLE;

Line 273: app_exception.raise_exception;

269: where user_name=U_USER_NAME;
270:
271: if cnt=0 then
272: fnd_message.set_name('JTF', 'JTF-1055');
273: app_exception.raise_exception;
274: end if;
275:
276: select count(*) into cnt
277: from jtf_auth_principals_b

Line 282: app_exception.raise_exception;

278: where principal_name=U_ROLE_NAME and is_user_flag=0;
279:
280: if cnt=0 then
281: fnd_message.set_name('JTF', 'JTF-1056');
282: app_exception.raise_exception;
283: end if;
284:
285:
286: select count(*) into cnt

Line 403: app_exception.raise_exception;

399: where user_name=U_USER_NAME;
400:
401: if cnt=0 then
402: fnd_message.set_name('JTF', 'JTF-1055');
403: app_exception.raise_exception;
404: end if;
405:
406: select count(*) into cnt
407: from jtf_auth_principals_b

Line 412: app_exception.raise_exception;

408: where principal_name=U_ROLE_NAME and is_user_flag=0;
409:
410: if cnt=0 then
411: fnd_message.set_name('JTF', 'JTF-1056');
412: app_exception.raise_exception;
413: end if;
414:
415:
416: select count(*) into cnt

Line 488: app_exception.raise_exception;

484:
485: exception
486: when table_error then
487: fnd_message.set_name('JTF', 'JTF-1049');
488: app_exception.raise_exception;
489:
490:
491:
492: end ASSIGN_ROLE;