eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_DATA_SECURITY dependencies on FND_LOG

Line 198: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then

194: x_user_id number;
195: x_is_per_person number;
196: begin
197:
198: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
199: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
200: c_log_head || l_api_name || '.begin',
201: c_pkg_name || '.' ||l_api_name|| '(' ||
202: 'p_user_name =>'|| p_user_name ||');');

Line 199: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

195: x_is_per_person number;
196: begin
197:
198: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
199: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
200: c_log_head || l_api_name || '.begin',
201: c_pkg_name || '.' ||l_api_name|| '(' ||
202: 'p_user_name =>'|| p_user_name ||');');
203: end if;

Line 207: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then

203: end if;
204:
205: if ((p_user_name is NULL) or (p_user_name = 'GLOBAL')) then
206: x_user_name_bind := ''''|| replace(p_user_name, '''','''''')||'''';
207: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
208: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
209: c_log_head || l_api_name || '.end_quick',
210: 'returning NULLs for user_name bind.');
211: end if;

Line 208: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

204:
205: if ((p_user_name is NULL) or (p_user_name = 'GLOBAL')) then
206: x_user_name_bind := ''''|| replace(p_user_name, '''','''''')||'''';
207: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
208: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
209: c_log_head || l_api_name || '.end_quick',
210: 'returning NULLs for user_name bind.');
211: end if;
212: return;

Line 217: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then

213: end if;
214:
215: if (p_user_name = SYS_CONTEXT('FND','USER_NAME')) then
216: x_user_name_bind := 'SYS_CONTEXT(''FND'',''USER_NAME'')';
217: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
218: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
219: c_log_head || l_api_name || '.end_global_user_name',
220: 'returning x_user_name_bind:' || x_user_name_bind);
221: end if;

Line 218: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

214:
215: if (p_user_name = SYS_CONTEXT('FND','USER_NAME')) then
216: x_user_name_bind := 'SYS_CONTEXT(''FND'',''USER_NAME'')';
217: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
218: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
219: c_log_head || l_api_name || '.end_global_user_name',
220: 'returning x_user_name_bind:' || x_user_name_bind);
221: end if;
222: return;

Line 225: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then

221: end if;
222: return;
223: else
224: x_user_name_bind := ''''||replace(p_user_name, '''', '''''')||'''';
225: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
226: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
227: c_log_head || l_api_name || '.end_literal',
228: 'returning x_user_name_bind:' || x_user_name_bind);
229: end if;

Line 226: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

222: return;
223: else
224: x_user_name_bind := ''''||replace(p_user_name, '''', '''''')||'''';
225: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
226: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
227: c_log_head || l_api_name || '.end_literal',
228: 'returning x_user_name_bind:' || x_user_name_bind);
229: end if;
230: return;

Line 234: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then

230: return;
231: end if;
232:
233: /* This line should never be reached. */
234: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
235: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
236: c_log_head || l_api_name || '.end_interr',
237: 'Internal Error. This line should not be executed.');
238: end if;

Line 235: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

231: end if;
232:
233: /* This line should never be reached. */
234: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
235: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
236: c_log_head || l_api_name || '.end_interr',
237: 'Internal Error. This line should not be executed.');
238: end if;
239: x_user_name_bind := 'ERROR_IN_GET_NAME_BIND';

Line 262: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then

258: is
259: l_api_name CONSTANT VARCHAR2(30) := 'GET_ORIG_KEY';
260: colon pls_integer;
261: begin
262: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
263: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
264: c_log_head || l_api_name || '.begin',
265: c_pkg_name || '.' ||l_api_name|| '(' ||
266: 'p_user_name =>'|| p_user_name ||');');

Line 263: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

259: l_api_name CONSTANT VARCHAR2(30) := 'GET_ORIG_KEY';
260: colon pls_integer;
261: begin
262: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
263: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
264: c_log_head || l_api_name || '.begin',
265: c_pkg_name || '.' ||l_api_name|| '(' ||
266: 'p_user_name =>'|| p_user_name ||');');
267: end if;

Line 293: if (fnd_log.LEVEL_EXCEPTION >=

289: 'Application%20Object%20Library/DeprecatedApiRDD.doc '||
290: 'Oracle employees who encounter this error should log '||
291: 'a bug against the product that owns the call to this '||
292: 'routine');
293: if (fnd_log.LEVEL_EXCEPTION >=
294: fnd_log.g_current_runtime_level) then
295: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
296: c_log_head || l_api_name || '.end_unsupported',
297: FALSE);

Line 294: fnd_log.g_current_runtime_level) then

290: 'Oracle employees who encounter this error should log '||
291: 'a bug against the product that owns the call to this '||
292: 'routine');
293: if (fnd_log.LEVEL_EXCEPTION >=
294: fnd_log.g_current_runtime_level) then
295: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
296: c_log_head || l_api_name || '.end_unsupported',
297: FALSE);
298: end if;

Line 295: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

291: 'a bug against the product that owns the call to this '||
292: 'routine');
293: if (fnd_log.LEVEL_EXCEPTION >=
294: fnd_log.g_current_runtime_level) then
295: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
296: c_log_head || l_api_name || '.end_unsupported',
297: FALSE);
298: end if;
299: fnd_message.raise_error;

Line 309: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then

305: /* Note that this logic is written to accomodate VGEORGE's case where*/
306: /* the grantee_type is 'GLOBAL' but the grantee_key is something */
307: /* parsable. */
308: if ((p_user_name is NULL) or (p_user_name = 'GLOBAL')) then
309: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
310: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
311: c_log_head || l_api_name || '.end_quick',
312: 'returning NULLs for x_orig_system and x_orig_system_id');
313: end if;

Line 310: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

306: /* the grantee_type is 'GLOBAL' but the grantee_key is something */
307: /* parsable. */
308: if ((p_user_name is NULL) or (p_user_name = 'GLOBAL')) then
309: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
310: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
311: c_log_head || l_api_name || '.end_quick',
312: 'returning NULLs for x_orig_system and x_orig_system_id');
313: end if;
314: return;

Line 326: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then

322: Role => p_user_name,
323: Orig_System => x_orig_system,
324: Orig_System_Id => x_orig_system_id);
325:
326: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
327: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
328: c_log_head || l_api_name || '.end',
329: 'returning x_orig_system:' || x_orig_system ||
330: 'x_orig_system_id:'||to_char(x_orig_system_id));

Line 327: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

323: Orig_System => x_orig_system,
324: Orig_System_Id => x_orig_system_id);
325:
326: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
327: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
328: c_log_head || l_api_name || '.end',
329: 'returning x_orig_system:' || x_orig_system ||
330: 'x_orig_system_id:'||to_char(x_orig_system_id));
331: end if;

Line 344: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then

340: ) return number is
341: v_object_id number;
342: l_api_name CONSTANT VARCHAR2(30) := 'GET_OBJECT_ID';
343: Begin
344: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
345: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
346: c_log_head || l_api_name || '.begin',
347: c_pkg_name || '.' ||l_api_name|| '(' ||
348: 'p_object_name =>'|| p_object_name ||');');

Line 345: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

341: v_object_id number;
342: l_api_name CONSTANT VARCHAR2(30) := 'GET_OBJECT_ID';
343: Begin
344: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
345: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
346: c_log_head || l_api_name || '.begin',
347: c_pkg_name || '.' ||l_api_name|| '(' ||
348: 'p_object_name =>'|| p_object_name ||');');
349: end if;

Line 363: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then

359: g_obj_id_cache := v_object_id;
360: g_obj_name_cache := p_object_name;
361: end if;
362:
363: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
364: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
365: c_log_head || l_api_name || '.end',
366: 'returning v_object_id:' || v_object_id);
367: end if;

Line 364: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

360: g_obj_name_cache := p_object_name;
361: end if;
362:
363: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
364: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
365: c_log_head || l_api_name || '.end',
366: 'returning v_object_id:' || v_object_id);
367: end if;
368: return v_object_id;

Line 371: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then

367: end if;
368: return v_object_id;
369: exception
370: when no_data_found then
371: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
372: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
373: c_log_head || l_api_name || '.end_null',
374: 'returning null');
375: end if;

Line 372: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

368: return v_object_id;
369: exception
370: when no_data_found then
371: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
372: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
373: c_log_head || l_api_name || '.end_null',
374: 'returning null');
375: end if;
376: return null;

Line 387: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then

383: ) return number is
384: v_function_id number;
385: l_api_name CONSTANT VARCHAR2(30) := 'GET_FUNCTION_ID';
386: Begin
387: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
388: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
389: c_log_head || l_api_name || '.begin',
390: c_pkg_name || '.' ||l_api_name|| '(' ||
391: 'p_function_name =>'|| p_function_name ||');');

Line 388: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

384: v_function_id number;
385: l_api_name CONSTANT VARCHAR2(30) := 'GET_FUNCTION_ID';
386: Begin
387: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
388: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
389: c_log_head || l_api_name || '.begin',
390: c_pkg_name || '.' ||l_api_name|| '(' ||
391: 'p_function_name =>'|| p_function_name ||');');
392: end if;

Line 408: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then

404: g_func_name_cache := p_function_name;
405: end if;
406:
407:
408: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
409: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
410: c_log_head || l_api_name || '.end',
411: 'returning v_function_id:' || v_function_id);
412: end if;

Line 409: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

405: end if;
406:
407:
408: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
409: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
410: c_log_head || l_api_name || '.end',
411: 'returning v_function_id:' || v_function_id);
412: end if;
413: return v_function_id;

Line 416: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then

412: end if;
413: return v_function_id;
414: exception
415: when no_data_found then
416: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
417: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
418: c_log_head || l_api_name || '.end_null',
419: 'returning null');
420: end if;

Line 417: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

413: return v_function_id;
414: exception
415: when no_data_found then
416: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
417: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
418: c_log_head || l_api_name || '.end_null',
419: 'returning null');
420: end if;
421: return null;

Line 500: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then

496: , database_object_name
497: FROM fnd_objects
498: WHERE obj_name=p_object_name ;
499: begin
500: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
501: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
502: c_log_head || l_api_name || '.begin',
503: c_pkg_name || '.' ||l_api_name|| '(' ||
504: 'p_object_name=>'|| p_object_name ||

Line 501: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

497: FROM fnd_objects
498: WHERE obj_name=p_object_name ;
499: begin
500: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
501: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
502: c_log_head || l_api_name || '.begin',
503: c_pkg_name || '.' ||l_api_name|| '(' ||
504: 'p_object_name=>'|| p_object_name ||
505: 'x_table_alias=>'|| x_table_alias ||

Line 543: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then

539: c_pkg_name || '.'|| l_api_name);
540: fnd_message.set_token('REASON',
541: 'FND_OBJECTS does not have column obj_name with value:'||
542: p_object_name);
543: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
544: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
545: c_log_head || l_api_name || '.bad_objname',
546: FALSE);
547: end if;

Line 544: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

540: fnd_message.set_token('REASON',
541: 'FND_OBJECTS does not have column obj_name with value:'||
542: p_object_name);
543: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
544: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
545: c_log_head || l_api_name || '.bad_objname',
546: FALSE);
547: end if;
548: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then

Line 548: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then

544: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
545: c_log_head || l_api_name || '.bad_objname',
546: FALSE);
547: end if;
548: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
549: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
550: c_log_head || l_api_name || '.end_bad_objname',
551: 'returning: ' ||'U');
552: end if;

Line 549: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

545: c_log_head || l_api_name || '.bad_objname',
546: FALSE);
547: end if;
548: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
549: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
550: c_log_head || l_api_name || '.end_bad_objname',
551: 'returning: ' ||'U');
552: end if;
553: return 'U';

Line 558: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then

554: end if;
555:
556: CLOSE c_pk;
557:
558: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
559: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
560: c_log_head || l_api_name || '.after_fetch',
561: ' x_pk1_column_name: '|| x_pk1_column_name||
562: ' x_pk2_column_name: '|| x_pk2_column_name||

Line 559: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

555:
556: CLOSE c_pk;
557:
558: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
559: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
560: c_log_head || l_api_name || '.after_fetch',
561: ' x_pk1_column_name: '|| x_pk1_column_name||
562: ' x_pk2_column_name: '|| x_pk2_column_name||
563: ' x_pk3_column_name: '|| x_pk3_column_name||

Line 675: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then

671:
672: x_ik_clause := x_ik_clause||' )';
673: x_exact_clause := x_exact_clause||' )';
674:
675: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
676: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
677: c_log_head || l_api_name || '.end',
678: 'returning: ' ||
679: ' p_object_name=>'|| p_object_name ||','||

Line 676: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

672: x_ik_clause := x_ik_clause||' )';
673: x_exact_clause := x_exact_clause||' )';
674:
675: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
676: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
677: c_log_head || l_api_name || '.end',
678: 'returning: ' ||
679: ' p_object_name=>'|| p_object_name ||','||
680: ' x_pk1_column_name=>'|| x_pk1_column_name ||','||

Line 879: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then

875: AND (g.object_id = cp_object_id))
876: ;
877:
878: BEGIN
879: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
880: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
881: c_log_head || l_api_name || '.begin',
882: c_pkg_name || '.' ||l_api_name|| '(' ||
883: ' p_api_version=>'|| to_char(p_api_version) ||','||

Line 880: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

876: ;
877:
878: BEGIN
879: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
880: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
881: c_log_head || l_api_name || '.begin',
882: c_pkg_name || '.' ||l_api_name|| '(' ||
883: ' p_api_version=>'|| to_char(p_api_version) ||','||
884: ' p_function=>'|| p_function ||','||

Line 897: if (fnd_log.LEVEL_EXCEPTION >=

893: fnd_message.set_token('REASON',
894: 'Unsupported version '|| to_char(p_api_version)||
895: ' passed to API; expecting version '||
896: to_char(l_api_version));
897: if (fnd_log.LEVEL_EXCEPTION >=
898: fnd_log.g_current_runtime_level) then
899: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
900: c_log_head || l_api_name || '.end_bad_api_ver',
901: FALSE);

Line 898: fnd_log.g_current_runtime_level) then

894: 'Unsupported version '|| to_char(p_api_version)||
895: ' passed to API; expecting version '||
896: to_char(l_api_version));
897: if (fnd_log.LEVEL_EXCEPTION >=
898: fnd_log.g_current_runtime_level) then
899: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
900: c_log_head || l_api_name || '.end_bad_api_ver',
901: FALSE);
902: end if;

Line 899: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

895: ' passed to API; expecting version '||
896: to_char(l_api_version));
897: if (fnd_log.LEVEL_EXCEPTION >=
898: fnd_log.g_current_runtime_level) then
899: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
900: c_log_head || l_api_name || '.end_bad_api_ver',
901: FALSE);
902: end if;
903: return 'U';

Line 914: if (fnd_log.LEVEL_EXCEPTION >=

910: c_pkg_name || '.'|| l_api_name);
911: fnd_message.set_token('REASON',
912: 'NULL value passed for p_function:'||p_function);
913:
914: if (fnd_log.LEVEL_EXCEPTION >=
915: fnd_log.g_current_runtime_level) then
916: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
917: c_log_head || l_api_name || '.end_bad_param',
918: FALSE);

Line 915: fnd_log.g_current_runtime_level) then

911: fnd_message.set_token('REASON',
912: 'NULL value passed for p_function:'||p_function);
913:
914: if (fnd_log.LEVEL_EXCEPTION >=
915: fnd_log.g_current_runtime_level) then
916: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
917: c_log_head || l_api_name || '.end_bad_param',
918: FALSE);
919: end if;

Line 916: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

912: 'NULL value passed for p_function:'||p_function);
913:
914: if (fnd_log.LEVEL_EXCEPTION >=
915: fnd_log.g_current_runtime_level) then
916: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
917: c_log_head || l_api_name || '.end_bad_param',
918: FALSE);
919: end if;
920: return 'U';

Line 940: if (fnd_log.LEVEL_EXCEPTION >=

936: c_pkg_name || '.'|| l_api_name);
937: fnd_message.set_token('REASON',
938: 'The parameter value p_object_name is not a valid object.'||
939: ' p_object_name:'||p_object_name);
940: if (fnd_log.LEVEL_EXCEPTION >=
941: fnd_log.g_current_runtime_level) then
942: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
943: c_log_head || l_api_name || '.end_bad_obj',
944: FALSE);

Line 941: fnd_log.g_current_runtime_level) then

937: fnd_message.set_token('REASON',
938: 'The parameter value p_object_name is not a valid object.'||
939: ' p_object_name:'||p_object_name);
940: if (fnd_log.LEVEL_EXCEPTION >=
941: fnd_log.g_current_runtime_level) then
942: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
943: c_log_head || l_api_name || '.end_bad_obj',
944: FALSE);
945: end if;

Line 942: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

938: 'The parameter value p_object_name is not a valid object.'||
939: ' p_object_name:'||p_object_name);
940: if (fnd_log.LEVEL_EXCEPTION >=
941: fnd_log.g_current_runtime_level) then
942: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
943: c_log_head || l_api_name || '.end_bad_obj',
944: FALSE);
945: end if;
946: return 'U';

Line 984: if (fnd_log.LEVEL_EXCEPTION >=

980: 'a bug against the product that owns the call to this '||
981: 'routine, which is likely the owner of the object that '||
982: 'was passed to this routine: '||
983: p_object_name);
984: if (fnd_log.LEVEL_EXCEPTION >=
985: fnd_log.g_current_runtime_level) then
986: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
987: c_log_head || l_api_name || '.end_depr_param',
988: FALSE);

Line 985: fnd_log.g_current_runtime_level) then

981: 'routine, which is likely the owner of the object that '||
982: 'was passed to this routine: '||
983: p_object_name);
984: if (fnd_log.LEVEL_EXCEPTION >=
985: fnd_log.g_current_runtime_level) then
986: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
987: c_log_head || l_api_name || '.end_depr_param',
988: FALSE);
989: end if;

Line 986: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

982: 'was passed to this routine: '||
983: p_object_name);
984: if (fnd_log.LEVEL_EXCEPTION >=
985: fnd_log.g_current_runtime_level) then
986: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
987: c_log_head || l_api_name || '.end_depr_param',
988: FALSE);
989: end if;
990: fnd_message.raise_error;

Line 1004: if (fnd_log.LEVEL_EXCEPTION >=

1000: c_pkg_name || '.'|| l_api_name);
1001: fnd_message.set_token('REASON',
1002: 'The parameter value p_function is not a valid function name.'||
1003: ' p_function:'||p_function);
1004: if (fnd_log.LEVEL_EXCEPTION >=
1005: fnd_log.g_current_runtime_level) then
1006: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
1007: c_log_head || l_api_name || '.end_bad_func',
1008: FALSE);

Line 1005: fnd_log.g_current_runtime_level) then

1001: fnd_message.set_token('REASON',
1002: 'The parameter value p_function is not a valid function name.'||
1003: ' p_function:'||p_function);
1004: if (fnd_log.LEVEL_EXCEPTION >=
1005: fnd_log.g_current_runtime_level) then
1006: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
1007: c_log_head || l_api_name || '.end_bad_func',
1008: FALSE);
1009: end if;

Line 1006: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

1002: 'The parameter value p_function is not a valid function name.'||
1003: ' p_function:'||p_function);
1004: if (fnd_log.LEVEL_EXCEPTION >=
1005: fnd_log.g_current_runtime_level) then
1006: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
1007: c_log_head || l_api_name || '.end_bad_func',
1008: FALSE);
1009: end if;
1010: return 'U';

Line 1023: if (fnd_log.LEVEL_STATEMENT >=

1019: cp_function_id => l_function_id,
1020: cp_sysdate => l_sysdate,
1021: cp_object_id => l_object_id);
1022:
1023: if (fnd_log.LEVEL_STATEMENT >=
1024: fnd_log.g_current_runtime_level) then
1025: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1026: c_log_head||l_api_name||
1027: '.open_grants_bkwd_cursor',

Line 1024: fnd_log.g_current_runtime_level) then

1020: cp_sysdate => l_sysdate,
1021: cp_object_id => l_object_id);
1022:
1023: if (fnd_log.LEVEL_STATEMENT >=
1024: fnd_log.g_current_runtime_level) then
1025: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1026: c_log_head||l_api_name||
1027: '.open_grants_bkwd_cursor',
1028: ' cp_user_name: '|| l_user_name||

Line 1025: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1021: cp_object_id => l_object_id);
1022:
1023: if (fnd_log.LEVEL_STATEMENT >=
1024: fnd_log.g_current_runtime_level) then
1025: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1026: c_log_head||l_api_name||
1027: '.open_grants_bkwd_cursor',
1028: ' cp_user_name: '|| l_user_name||
1029: ' cp_function_id: '|| l_function_id||

Line 1041: if (fnd_log.LEVEL_STATEMENT >=

1037: OPEN global_grants_c (cp_user_name => l_user_name,
1038: cp_function_id => l_function_id,
1039: cp_sysdate => l_sysdate,
1040: cp_object_id => l_object_id);
1041: if (fnd_log.LEVEL_STATEMENT >=
1042: fnd_log.g_current_runtime_level) then
1043: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1044: c_log_head || l_api_name || '.open_grants_cursor',
1045: ' cp_user_name: '|| l_user_name||

Line 1042: fnd_log.g_current_runtime_level) then

1038: cp_function_id => l_function_id,
1039: cp_sysdate => l_sysdate,
1040: cp_object_id => l_object_id);
1041: if (fnd_log.LEVEL_STATEMENT >=
1042: fnd_log.g_current_runtime_level) then
1043: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1044: c_log_head || l_api_name || '.open_grants_cursor',
1045: ' cp_user_name: '|| l_user_name||
1046: ' cp_function_id: '|| l_function_id||

Line 1043: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1039: cp_sysdate => l_sysdate,
1040: cp_object_id => l_object_id);
1041: if (fnd_log.LEVEL_STATEMENT >=
1042: fnd_log.g_current_runtime_level) then
1043: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1044: c_log_head || l_api_name || '.open_grants_cursor',
1045: ' cp_user_name: '|| l_user_name||
1046: ' cp_function_id: '|| l_function_id||
1047: ' l_sysdate: '|| to_char(l_sysdate)||

Line 1059: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

1055: OPEN global_grants_guest_c (cp_user_name => l_user_name,
1056: cp_function_id => l_function_id,
1057: cp_sysdate => l_sysdate,
1058: cp_object_id => l_object_id);
1059: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1060: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1061: c_log_head || l_api_name || '.open_grants_guest_cursor',
1062: ' cp_user_name: '|| l_user_name||
1063: ' cp_function_id: '|| l_function_id||

Line 1060: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1056: cp_function_id => l_function_id,
1057: cp_sysdate => l_sysdate,
1058: cp_object_id => l_object_id);
1059: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1060: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1061: c_log_head || l_api_name || '.open_grants_guest_cursor',
1062: ' cp_user_name: '|| l_user_name||
1063: ' cp_function_id: '|| l_function_id||
1064: ' l_sysdate: '|| to_char(l_sysdate)||

Line 1073: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

1069: CLOSE global_grants_guest_c;
1070:
1071: END IF;
1072:
1073: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1074: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1075: c_log_head || l_api_name || '.fetch_instance_grants',
1076: ' l_result:'||l_result);
1077: end if;

Line 1074: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1070:
1071: END IF;
1072:
1073: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1074: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1075: c_log_head || l_api_name || '.fetch_instance_grants',
1076: ' l_result:'||l_result);
1077: end if;
1078: IF (l_result = 'X') THEN

Line 1079: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then

1075: c_log_head || l_api_name || '.fetch_instance_grants',
1076: ' l_result:'||l_result);
1077: end if;
1078: IF (l_result = 'X') THEN
1079: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1080: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1081: c_log_head || l_api_name || '.end_inst_grant',
1082: 'T');
1083: end if;

Line 1080: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1076: ' l_result:'||l_result);
1077: end if;
1078: IF (l_result = 'X') THEN
1079: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1080: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1081: c_log_head || l_api_name || '.end_inst_grant',
1082: 'T');
1083: end if;
1084: RETURN 'T';

Line 1087: if (fnd_log.LEVEL_PROCEDURE >=

1083: end if;
1084: RETURN 'T';
1085: ELSE
1086:
1087: if (fnd_log.LEVEL_PROCEDURE >=
1088: fnd_log.g_current_runtime_level) then
1089: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1090: c_log_head || l_api_name || '.end_no_inst','F');
1091: end if;

Line 1088: fnd_log.g_current_runtime_level) then

1084: RETURN 'T';
1085: ELSE
1086:
1087: if (fnd_log.LEVEL_PROCEDURE >=
1088: fnd_log.g_current_runtime_level) then
1089: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1090: c_log_head || l_api_name || '.end_no_inst','F');
1091: end if;
1092: RETURN 'F';

Line 1089: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1085: ELSE
1086:
1087: if (fnd_log.LEVEL_PROCEDURE >=
1088: fnd_log.g_current_runtime_level) then
1089: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1090: c_log_head || l_api_name || '.end_no_inst','F');
1091: end if;
1092: RETURN 'F';
1093: END IF;

Line 1111: if (fnd_log.LEVEL_EXCEPTION >=

1107: c_pkg_name||','||l_api_name);
1108: fnd_message.set_token('ERRNO', SQLCODE);
1109: fnd_message.set_token('REASON', SQLERRM);
1110:
1111: if (fnd_log.LEVEL_EXCEPTION >=
1112: fnd_log.g_current_runtime_level) then
1113: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
1114: c_log_head || l_api_name || '.other_err',
1115: FALSE);

Line 1112: fnd_log.g_current_runtime_level) then

1108: fnd_message.set_token('ERRNO', SQLCODE);
1109: fnd_message.set_token('REASON', SQLERRM);
1110:
1111: if (fnd_log.LEVEL_EXCEPTION >=
1112: fnd_log.g_current_runtime_level) then
1113: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
1114: c_log_head || l_api_name || '.other_err',
1115: FALSE);
1116: end if;

Line 1113: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

1109: fnd_message.set_token('REASON', SQLERRM);
1110:
1111: if (fnd_log.LEVEL_EXCEPTION >=
1112: fnd_log.g_current_runtime_level) then
1113: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
1114: c_log_head || l_api_name || '.other_err',
1115: FALSE);
1116: end if;
1117: if (fnd_log.LEVEL_PROCEDURE >=

Line 1117: if (fnd_log.LEVEL_PROCEDURE >=

1113: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
1114: c_log_head || l_api_name || '.other_err',
1115: FALSE);
1116: end if;
1117: if (fnd_log.LEVEL_PROCEDURE >=
1118: fnd_log.g_current_runtime_level) then
1119: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1120: c_log_head || l_api_name || '.end_after_other',
1121: 'U' );

Line 1118: fnd_log.g_current_runtime_level) then

1114: c_log_head || l_api_name || '.other_err',
1115: FALSE);
1116: end if;
1117: if (fnd_log.LEVEL_PROCEDURE >=
1118: fnd_log.g_current_runtime_level) then
1119: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1120: c_log_head || l_api_name || '.end_after_other',
1121: 'U' );
1122: end if;

Line 1119: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1115: FALSE);
1116: end if;
1117: if (fnd_log.LEVEL_PROCEDURE >=
1118: fnd_log.g_current_runtime_level) then
1119: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1120: c_log_head || l_api_name || '.end_after_other',
1121: 'U' );
1122: end if;
1123: RETURN 'U';

Line 1143: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then

1139: l_api_name CONSTANT VARCHAR2(30) :=
1140: 'CHECK_GLOBAL_OBJECT_TYPE_GRANT';
1141: l_result varchar2(30);
1142: BEGIN
1143: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1144: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1145: c_log_head || l_api_name || '.begin',
1146: c_pkg_name || '.' ||l_api_name|| '(' ||
1147: ' p_api_version=>'|| to_char(p_api_version) ||','||

Line 1144: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1140: 'CHECK_GLOBAL_OBJECT_TYPE_GRANT';
1141: l_result varchar2(30);
1142: BEGIN
1143: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1144: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1145: c_log_head || l_api_name || '.begin',
1146: c_pkg_name || '.' ||l_api_name|| '(' ||
1147: ' p_api_version=>'|| to_char(p_api_version) ||','||
1148: ' p_function=>'|| p_function ||','||

Line 1161: if (fnd_log.LEVEL_EXCEPTION >=

1157: fnd_message.set_token('REASON',
1158: 'Unsupported version '|| to_char(p_api_version)||
1159: ' passed to API; expecting version '||
1160: to_char(l_api_version));
1161: if (fnd_log.LEVEL_EXCEPTION >=
1162: fnd_log.g_current_runtime_level) then
1163: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
1164: c_log_head || l_api_name || '.end_bad_api_ver',
1165: FALSE);

Line 1162: fnd_log.g_current_runtime_level) then

1158: 'Unsupported version '|| to_char(p_api_version)||
1159: ' passed to API; expecting version '||
1160: to_char(l_api_version));
1161: if (fnd_log.LEVEL_EXCEPTION >=
1162: fnd_log.g_current_runtime_level) then
1163: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
1164: c_log_head || l_api_name || '.end_bad_api_ver',
1165: FALSE);
1166: end if;

Line 1163: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

1159: ' passed to API; expecting version '||
1160: to_char(l_api_version));
1161: if (fnd_log.LEVEL_EXCEPTION >=
1162: fnd_log.g_current_runtime_level) then
1163: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
1164: c_log_head || l_api_name || '.end_bad_api_ver',
1165: FALSE);
1166: end if;
1167: return 'U';

Line 1176: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then

1172: p_function,
1173: p_user_name,
1174: 'GLOBAL');
1175:
1176: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1177: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1178: c_log_head || l_api_name || '.end',
1179: l_result);
1180: end if;

Line 1177: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1173: p_user_name,
1174: 'GLOBAL');
1175:
1176: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1177: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1178: c_log_head || l_api_name || '.end',
1179: l_result);
1180: end if;
1181:

Line 1241: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then

1237: i number;
1238: l_bind_order varchar2(256);
1239: BEGIN
1240:
1241: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1242: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1243: c_log_head || l_api_name || '.begin',
1244: c_pkg_name || '.' ||l_api_name|| '(' ||
1245: ' p_api_version=>'|| to_char(p_api_version) ||','||

Line 1242: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1238: l_bind_order varchar2(256);
1239: BEGIN
1240:
1241: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1242: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1243: c_log_head || l_api_name || '.begin',
1244: c_pkg_name || '.' ||l_api_name|| '(' ||
1245: ' p_api_version=>'|| to_char(p_api_version) ||','||
1246: ' p_function=>'|| p_function ||','||

Line 1266: if (fnd_log.LEVEL_EXCEPTION >=

1262: 'Unsupported version '|| to_char(p_api_version)||
1263: ' passed to API; expecting version '||
1264: to_char(l_api_version));
1265:
1266: if (fnd_log.LEVEL_EXCEPTION >=
1267: fnd_log.g_current_runtime_level) then
1268: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
1269: c_log_head || l_api_name || '.end_bad_api_ver',
1270: FALSE);

Line 1267: fnd_log.g_current_runtime_level) then

1263: ' passed to API; expecting version '||
1264: to_char(l_api_version));
1265:
1266: if (fnd_log.LEVEL_EXCEPTION >=
1267: fnd_log.g_current_runtime_level) then
1268: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
1269: c_log_head || l_api_name || '.end_bad_api_ver',
1270: FALSE);
1271: end if;

Line 1268: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

1264: to_char(l_api_version));
1265:
1266: if (fnd_log.LEVEL_EXCEPTION >=
1267: fnd_log.g_current_runtime_level) then
1268: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
1269: c_log_head || l_api_name || '.end_bad_api_ver',
1270: FALSE);
1271: end if;
1272: return 'U';

Line 1283: if (fnd_log.LEVEL_EXCEPTION >=

1279: c_pkg_name || '.'|| l_api_name);
1280: fnd_message.set_token('REASON',
1281: 'NULL value passed for p_function:'||p_function||
1282: ' or for p_object_name:'||p_object_name);
1283: if (fnd_log.LEVEL_EXCEPTION >=
1284: fnd_log.g_current_runtime_level) then
1285: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
1286: c_log_head || l_api_name || '.end_bad_param',
1287: FALSE);

Line 1284: fnd_log.g_current_runtime_level) then

1280: fnd_message.set_token('REASON',
1281: 'NULL value passed for p_function:'||p_function||
1282: ' or for p_object_name:'||p_object_name);
1283: if (fnd_log.LEVEL_EXCEPTION >=
1284: fnd_log.g_current_runtime_level) then
1285: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
1286: c_log_head || l_api_name || '.end_bad_param',
1287: FALSE);
1288: end if;

Line 1285: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

1281: 'NULL value passed for p_function:'||p_function||
1282: ' or for p_object_name:'||p_object_name);
1283: if (fnd_log.LEVEL_EXCEPTION >=
1284: fnd_log.g_current_runtime_level) then
1285: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
1286: c_log_head || l_api_name || '.end_bad_param',
1287: FALSE);
1288: end if;
1289: return 'U';

Line 1327: if (fnd_log.LEVEL_EXCEPTION >=

1323: 'a bug against the product that owns the call to this '||
1324: 'routine, which is likely the owner of the object that '||
1325: 'was passed to this routine: '||
1326: p_object_name);
1327: if (fnd_log.LEVEL_EXCEPTION >=
1328: fnd_log.g_current_runtime_level) then
1329: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
1330: c_log_head || l_api_name || '.end_depr_param',
1331: FALSE);

Line 1328: fnd_log.g_current_runtime_level) then

1324: 'routine, which is likely the owner of the object that '||
1325: 'was passed to this routine: '||
1326: p_object_name);
1327: if (fnd_log.LEVEL_EXCEPTION >=
1328: fnd_log.g_current_runtime_level) then
1329: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
1330: c_log_head || l_api_name || '.end_depr_param',
1331: FALSE);
1332: end if;

Line 1329: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

1325: 'was passed to this routine: '||
1326: p_object_name);
1327: if (fnd_log.LEVEL_EXCEPTION >=
1328: fnd_log.g_current_runtime_level) then
1329: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
1330: c_log_head || l_api_name || '.end_depr_param',
1331: FALSE);
1332: end if;
1333: fnd_message.raise_error;

Line 1380: if (fnd_log.LEVEL_PROCEDURE >=

1376: p_object_name);
1377:
1378: /* If we found a global object grant, we're done. */
1379: if (l_result = 'T') then
1380: if (fnd_log.LEVEL_PROCEDURE >=
1381: fnd_log.g_current_runtime_level) then
1382: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1383: c_log_head || l_api_name || '.end_shortckt',
1384: 'T');

Line 1381: fnd_log.g_current_runtime_level) then

1377:
1378: /* If we found a global object grant, we're done. */
1379: if (l_result = 'T') then
1380: if (fnd_log.LEVEL_PROCEDURE >=
1381: fnd_log.g_current_runtime_level) then
1382: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1383: c_log_head || l_api_name || '.end_shortckt',
1384: 'T');
1385: end if;

Line 1382: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1378: /* If we found a global object grant, we're done. */
1379: if (l_result = 'T') then
1380: if (fnd_log.LEVEL_PROCEDURE >=
1381: fnd_log.g_current_runtime_level) then
1382: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1383: c_log_head || l_api_name || '.end_shortckt',
1384: 'T');
1385: end if;
1386: return 'T';

Line 1388: if (fnd_log.LEVEL_PROCEDURE >=

1384: 'T');
1385: end if;
1386: return 'T';
1387: elsif (l_result <> 'F') then
1388: if (fnd_log.LEVEL_PROCEDURE >=
1389: fnd_log.g_current_runtime_level) then
1390: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1391: c_log_head || l_api_name || '.end_sckterr',
1392: l_result);

Line 1389: fnd_log.g_current_runtime_level) then

1385: end if;
1386: return 'T';
1387: elsif (l_result <> 'F') then
1388: if (fnd_log.LEVEL_PROCEDURE >=
1389: fnd_log.g_current_runtime_level) then
1390: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1391: c_log_head || l_api_name || '.end_sckterr',
1392: l_result);
1393: end if;

Line 1390: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1386: return 'T';
1387: elsif (l_result <> 'F') then
1388: if (fnd_log.LEVEL_PROCEDURE >=
1389: fnd_log.g_current_runtime_level) then
1390: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1391: c_log_head || l_api_name || '.end_sckterr',
1392: l_result);
1393: end if;
1394: return l_result;

Line 1414: if (fnd_log.LEVEL_PROCEDURE >=

1410: l_pk_orig_column_names,
1411: l_db_object_name,
1412: 'OBJTAB', 'GNT' );
1413: if (result <> 'T') then
1414: if (fnd_log.LEVEL_PROCEDURE >=
1415: fnd_log.g_current_runtime_level) then
1416: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1417: c_log_head || l_api_name || '.end_pk_info_err',
1418: 'returning status: '|| result);

Line 1415: fnd_log.g_current_runtime_level) then

1411: l_db_object_name,
1412: 'OBJTAB', 'GNT' );
1413: if (result <> 'T') then
1414: if (fnd_log.LEVEL_PROCEDURE >=
1415: fnd_log.g_current_runtime_level) then
1416: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1417: c_log_head || l_api_name || '.end_pk_info_err',
1418: 'returning status: '|| result);
1419: end if;

Line 1416: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1412: 'OBJTAB', 'GNT' );
1413: if (result <> 'T') then
1414: if (fnd_log.LEVEL_PROCEDURE >=
1415: fnd_log.g_current_runtime_level) then
1416: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1417: c_log_head || l_api_name || '.end_pk_info_err',
1418: 'returning status: '|| result);
1419: end if;
1420: /* There will be a message on the msg dict stack. */

Line 1437: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

1433: x_function_id=>l_function_id,
1434: x_bind_order=>l_bind_order
1435: );
1436:
1437: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1438: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1439: c_log_head || l_api_name || '.after_gsp',
1440: 'l_predicate:'||l_predicate||
1441: 'l_return_status:'||l_return_status||

Line 1438: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1434: x_bind_order=>l_bind_order
1435: );
1436:
1437: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1438: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1439: c_log_head || l_api_name || '.after_gsp',
1440: 'l_predicate:'||l_predicate||
1441: 'l_return_status:'||l_return_status||
1442: 'l_object_id:'||l_object_id||

Line 1448: if (fnd_log.LEVEL_EXCEPTION >=

1444: end if;
1445:
1446: IF( l_return_status <> 'T' AND l_return_status <> 'F') then
1447: /* There will be a message on the stack from gsp */
1448: if (fnd_log.LEVEL_EXCEPTION >=
1449: fnd_log.g_current_runtime_level) then
1450: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
1451: c_log_head || l_api_name || '.end_gsp_fail',
1452: FALSE);

Line 1449: fnd_log.g_current_runtime_level) then

1445:
1446: IF( l_return_status <> 'T' AND l_return_status <> 'F') then
1447: /* There will be a message on the stack from gsp */
1448: if (fnd_log.LEVEL_EXCEPTION >=
1449: fnd_log.g_current_runtime_level) then
1450: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
1451: c_log_head || l_api_name || '.end_gsp_fail',
1452: FALSE);
1453: end if;

Line 1450: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

1446: IF( l_return_status <> 'T' AND l_return_status <> 'F') then
1447: /* There will be a message on the stack from gsp */
1448: if (fnd_log.LEVEL_EXCEPTION >=
1449: fnd_log.g_current_runtime_level) then
1450: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
1451: c_log_head || l_api_name || '.end_gsp_fail',
1452: FALSE);
1453: end if;
1454: if (l_return_status = 'L') then

Line 1464: if (fnd_log.LEVEL_PROCEDURE >=

1460: end if;
1461:
1462: IF( l_return_status = 'F') then /* If there weren't enough grants */
1463: /* to make a predicate, we are done. */
1464: if (fnd_log.LEVEL_PROCEDURE >=
1465: fnd_log.g_current_runtime_level) then
1466: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1467: c_log_head || l_api_name || '.end_gsp_nopred',
1468: 'F');

Line 1465: fnd_log.g_current_runtime_level) then

1461:
1462: IF( l_return_status = 'F') then /* If there weren't enough grants */
1463: /* to make a predicate, we are done. */
1464: if (fnd_log.LEVEL_PROCEDURE >=
1465: fnd_log.g_current_runtime_level) then
1466: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1467: c_log_head || l_api_name || '.end_gsp_nopred',
1468: 'F');
1469: end if;

Line 1466: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1462: IF( l_return_status = 'F') then /* If there weren't enough grants */
1463: /* to make a predicate, we are done. */
1464: if (fnd_log.LEVEL_PROCEDURE >=
1465: fnd_log.g_current_runtime_level) then
1466: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1467: c_log_head || l_api_name || '.end_gsp_nopred',
1468: 'F');
1469: end if;
1470: return 'F';

Line 1536: if (fnd_log.LEVEL_STATEMENT >=

1532: end if;
1533: dynamic_sql := dynamic_sql ||
1534: ' AND ('||l_predicate||') ';
1535:
1536: if (fnd_log.LEVEL_STATEMENT >=
1537: fnd_log.g_current_runtime_level) then
1538: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1539: c_log_head || l_api_name || '.create_dy_sql',
1540: 'dynamic_sql:'||dynamic_sql);

Line 1537: fnd_log.g_current_runtime_level) then

1533: dynamic_sql := dynamic_sql ||
1534: ' AND ('||l_predicate||') ';
1535:
1536: if (fnd_log.LEVEL_STATEMENT >=
1537: fnd_log.g_current_runtime_level) then
1538: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1539: c_log_head || l_api_name || '.create_dy_sql',
1540: 'dynamic_sql:'||dynamic_sql);
1541: end if;

Line 1538: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1534: ' AND ('||l_predicate||') ';
1535:
1536: if (fnd_log.LEVEL_STATEMENT >=
1537: fnd_log.g_current_runtime_level) then
1538: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1539: c_log_head || l_api_name || '.create_dy_sql',
1540: 'dynamic_sql:'||dynamic_sql);
1541: end if;
1542:

Line 1549: if (fnd_log.LEVEL_STATEMENT >=

1545:
1546: if l_bind_pk1 then
1547: dbms_sql.bind_variable(
1548: l_cursor, 'pk1_val', l_instance_pk1_value);
1549: if (fnd_log.LEVEL_STATEMENT >=
1550: fnd_log.g_current_runtime_level) then
1551: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1552: c_log_head || l_api_name || '.open1bind',
1553: ' l_instance_pk1_value:'||l_instance_pk1_value);

Line 1550: fnd_log.g_current_runtime_level) then

1546: if l_bind_pk1 then
1547: dbms_sql.bind_variable(
1548: l_cursor, 'pk1_val', l_instance_pk1_value);
1549: if (fnd_log.LEVEL_STATEMENT >=
1550: fnd_log.g_current_runtime_level) then
1551: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1552: c_log_head || l_api_name || '.open1bind',
1553: ' l_instance_pk1_value:'||l_instance_pk1_value);
1554: end if;

Line 1551: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1547: dbms_sql.bind_variable(
1548: l_cursor, 'pk1_val', l_instance_pk1_value);
1549: if (fnd_log.LEVEL_STATEMENT >=
1550: fnd_log.g_current_runtime_level) then
1551: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1552: c_log_head || l_api_name || '.open1bind',
1553: ' l_instance_pk1_value:'||l_instance_pk1_value);
1554: end if;
1555: end if;

Line 1560: if (fnd_log.LEVEL_STATEMENT >=

1556:
1557: if l_bind_pk2 then
1558: dbms_sql.bind_variable(
1559: l_cursor, 'pk2_val', l_instance_pk2_value);
1560: if (fnd_log.LEVEL_STATEMENT >=
1561: fnd_log.g_current_runtime_level) then
1562: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1563: c_log_head || l_api_name || '.open2bind',
1564: ' l_instance_pk2_value:'||l_instance_pk2_value);

Line 1561: fnd_log.g_current_runtime_level) then

1557: if l_bind_pk2 then
1558: dbms_sql.bind_variable(
1559: l_cursor, 'pk2_val', l_instance_pk2_value);
1560: if (fnd_log.LEVEL_STATEMENT >=
1561: fnd_log.g_current_runtime_level) then
1562: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1563: c_log_head || l_api_name || '.open2bind',
1564: ' l_instance_pk2_value:'||l_instance_pk2_value);
1565: end if;

Line 1562: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1558: dbms_sql.bind_variable(
1559: l_cursor, 'pk2_val', l_instance_pk2_value);
1560: if (fnd_log.LEVEL_STATEMENT >=
1561: fnd_log.g_current_runtime_level) then
1562: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1563: c_log_head || l_api_name || '.open2bind',
1564: ' l_instance_pk2_value:'||l_instance_pk2_value);
1565: end if;
1566: end if;

Line 1571: if (fnd_log.LEVEL_STATEMENT >=

1567:
1568: if l_bind_pk3 then
1569: dbms_sql.bind_variable(
1570: l_cursor, 'pk3_val', l_instance_pk3_value);
1571: if (fnd_log.LEVEL_STATEMENT >=
1572: fnd_log.g_current_runtime_level) then
1573: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1574: c_log_head || l_api_name || '.open3bind',
1575: ' l_instance_pk3_value:'||l_instance_pk3_value);

Line 1572: fnd_log.g_current_runtime_level) then

1568: if l_bind_pk3 then
1569: dbms_sql.bind_variable(
1570: l_cursor, 'pk3_val', l_instance_pk3_value);
1571: if (fnd_log.LEVEL_STATEMENT >=
1572: fnd_log.g_current_runtime_level) then
1573: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1574: c_log_head || l_api_name || '.open3bind',
1575: ' l_instance_pk3_value:'||l_instance_pk3_value);
1576: end if;

Line 1573: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1569: dbms_sql.bind_variable(
1570: l_cursor, 'pk3_val', l_instance_pk3_value);
1571: if (fnd_log.LEVEL_STATEMENT >=
1572: fnd_log.g_current_runtime_level) then
1573: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1574: c_log_head || l_api_name || '.open3bind',
1575: ' l_instance_pk3_value:'||l_instance_pk3_value);
1576: end if;
1577: end if;

Line 1582: if (fnd_log.LEVEL_STATEMENT >=

1578:
1579: if l_bind_pk4 then
1580: dbms_sql.bind_variable(
1581: l_cursor, 'pk4_val', l_instance_pk4_value);
1582: if (fnd_log.LEVEL_STATEMENT >=
1583: fnd_log.g_current_runtime_level) then
1584: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1585: c_log_head || l_api_name || '.open4bind',
1586: ' l_instance_pk4_value:'||l_instance_pk4_value);

Line 1583: fnd_log.g_current_runtime_level) then

1579: if l_bind_pk4 then
1580: dbms_sql.bind_variable(
1581: l_cursor, 'pk4_val', l_instance_pk4_value);
1582: if (fnd_log.LEVEL_STATEMENT >=
1583: fnd_log.g_current_runtime_level) then
1584: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1585: c_log_head || l_api_name || '.open4bind',
1586: ' l_instance_pk4_value:'||l_instance_pk4_value);
1587: end if;

Line 1584: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1580: dbms_sql.bind_variable(
1581: l_cursor, 'pk4_val', l_instance_pk4_value);
1582: if (fnd_log.LEVEL_STATEMENT >=
1583: fnd_log.g_current_runtime_level) then
1584: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1585: c_log_head || l_api_name || '.open4bind',
1586: ' l_instance_pk4_value:'||l_instance_pk4_value);
1587: end if;
1588: end if;

Line 1593: if (fnd_log.LEVEL_STATEMENT >=

1589:
1590: if l_bind_pk5 then
1591: dbms_sql.bind_variable(
1592: l_cursor, 'pk5_val', l_instance_pk5_value);
1593: if (fnd_log.LEVEL_STATEMENT >=
1594: fnd_log.g_current_runtime_level) then
1595: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1596: c_log_head || l_api_name || '.open5bind',
1597: ' l_instance_pk5_value:'||l_instance_pk5_value);

Line 1594: fnd_log.g_current_runtime_level) then

1590: if l_bind_pk5 then
1591: dbms_sql.bind_variable(
1592: l_cursor, 'pk5_val', l_instance_pk5_value);
1593: if (fnd_log.LEVEL_STATEMENT >=
1594: fnd_log.g_current_runtime_level) then
1595: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1596: c_log_head || l_api_name || '.open5bind',
1597: ' l_instance_pk5_value:'||l_instance_pk5_value);
1598: end if;

Line 1595: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1591: dbms_sql.bind_variable(
1592: l_cursor, 'pk5_val', l_instance_pk5_value);
1593: if (fnd_log.LEVEL_STATEMENT >=
1594: fnd_log.g_current_runtime_level) then
1595: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1596: c_log_head || l_api_name || '.open5bind',
1597: ' l_instance_pk5_value:'||l_instance_pk5_value);
1598: end if;
1599: end if;

Line 1603: if (fnd_log.LEVEL_STATEMENT >=

1599: end if;
1600:
1601:
1602: if(l_function_id is not NULL) then
1603: if (fnd_log.LEVEL_STATEMENT >=
1604: fnd_log.g_current_runtime_level) then
1605: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1606: c_log_head || l_api_name || '.fnidbind',
1607: ' l_function_id:'||l_function_id);

Line 1604: fnd_log.g_current_runtime_level) then

1600:
1601:
1602: if(l_function_id is not NULL) then
1603: if (fnd_log.LEVEL_STATEMENT >=
1604: fnd_log.g_current_runtime_level) then
1605: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1606: c_log_head || l_api_name || '.fnidbind',
1607: ' l_function_id:'||l_function_id);
1608: end if;

Line 1605: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1601:
1602: if(l_function_id is not NULL) then
1603: if (fnd_log.LEVEL_STATEMENT >=
1604: fnd_log.g_current_runtime_level) then
1605: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1606: c_log_head || l_api_name || '.fnidbind',
1607: ' l_function_id:'||l_function_id);
1608: end if;
1609: dbms_sql.bind_variable(

Line 1614: if (fnd_log.LEVEL_STATEMENT >=

1610: l_cursor, 'FUNCTION_ID_BIND',l_function_id);
1611: end if;
1612:
1613: if(l_object_id is not NULL) then
1614: if (fnd_log.LEVEL_STATEMENT >=
1615: fnd_log.g_current_runtime_level) then
1616: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1617: c_log_head || l_api_name || '.objidbind',
1618: ' l_object_id:'||l_object_id);

Line 1615: fnd_log.g_current_runtime_level) then

1611: end if;
1612:
1613: if(l_object_id is not NULL) then
1614: if (fnd_log.LEVEL_STATEMENT >=
1615: fnd_log.g_current_runtime_level) then
1616: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1617: c_log_head || l_api_name || '.objidbind',
1618: ' l_object_id:'||l_object_id);
1619: end if;

Line 1616: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1612:
1613: if(l_object_id is not NULL) then
1614: if (fnd_log.LEVEL_STATEMENT >=
1615: fnd_log.g_current_runtime_level) then
1616: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1617: c_log_head || l_api_name || '.objidbind',
1618: ' l_object_id:'||l_object_id);
1619: end if;
1620: dbms_sql.bind_variable(

Line 1629: if (fnd_log.LEVEL_PROCEDURE >=

1625: l_rows_processed := dbms_sql.execute(l_cursor);
1626:
1627: IF( dbms_sql.fetch_rows(l_cursor) > 0 ) THEN
1628: dbms_sql.close_cursor(l_cursor); -- close cursor
1629: if (fnd_log.LEVEL_PROCEDURE >=
1630: fnd_log.g_current_runtime_level) then
1631: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1632: c_log_head || l_api_name || '.end_found',
1633: 'T');

Line 1630: fnd_log.g_current_runtime_level) then

1626:
1627: IF( dbms_sql.fetch_rows(l_cursor) > 0 ) THEN
1628: dbms_sql.close_cursor(l_cursor); -- close cursor
1629: if (fnd_log.LEVEL_PROCEDURE >=
1630: fnd_log.g_current_runtime_level) then
1631: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1632: c_log_head || l_api_name || '.end_found',
1633: 'T');
1634: end if;

Line 1631: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1627: IF( dbms_sql.fetch_rows(l_cursor) > 0 ) THEN
1628: dbms_sql.close_cursor(l_cursor); -- close cursor
1629: if (fnd_log.LEVEL_PROCEDURE >=
1630: fnd_log.g_current_runtime_level) then
1631: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1632: c_log_head || l_api_name || '.end_found',
1633: 'T');
1634: end if;
1635: RETURN 'T';

Line 1638: if (fnd_log.LEVEL_PROCEDURE >=

1634: end if;
1635: RETURN 'T';
1636: ELSE
1637: dbms_sql.close_cursor(l_cursor); -- close cursor
1638: if (fnd_log.LEVEL_PROCEDURE >=
1639: fnd_log.g_current_runtime_level) then
1640: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1641: c_log_head || l_api_name || '.end_notfnd',
1642: 'F');

Line 1639: fnd_log.g_current_runtime_level) then

1635: RETURN 'T';
1636: ELSE
1637: dbms_sql.close_cursor(l_cursor); -- close cursor
1638: if (fnd_log.LEVEL_PROCEDURE >=
1639: fnd_log.g_current_runtime_level) then
1640: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1641: c_log_head || l_api_name || '.end_notfnd',
1642: 'F');
1643: end if;

Line 1640: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1636: ELSE
1637: dbms_sql.close_cursor(l_cursor); -- close cursor
1638: if (fnd_log.LEVEL_PROCEDURE >=
1639: fnd_log.g_current_runtime_level) then
1640: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1641: c_log_head || l_api_name || '.end_notfnd',
1642: 'F');
1643: end if;
1644: RETURN 'F';

Line 1649: if (fnd_log.LEVEL_PROCEDURE >=

1645: END IF;
1646:
1647: ELSE
1648: -- No predicate
1649: if (fnd_log.LEVEL_PROCEDURE >=
1650: fnd_log.g_current_runtime_level) then
1651: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1652: c_log_head || l_api_name || '.end_nopred',
1653: 'F');

Line 1650: fnd_log.g_current_runtime_level) then

1646:
1647: ELSE
1648: -- No predicate
1649: if (fnd_log.LEVEL_PROCEDURE >=
1650: fnd_log.g_current_runtime_level) then
1651: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1652: c_log_head || l_api_name || '.end_nopred',
1653: 'F');
1654: end if;

Line 1651: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1647: ELSE
1648: -- No predicate
1649: if (fnd_log.LEVEL_PROCEDURE >=
1650: fnd_log.g_current_runtime_level) then
1651: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1652: c_log_head || l_api_name || '.end_nopred',
1653: 'F');
1654: end if;
1655: RETURN 'F';

Line 1676: if (fnd_log.LEVEL_EXCEPTION >=

1672: c_pkg_name||','||l_api_name);
1673: fnd_message.set_token('ERRNO', SQLCODE);
1674: fnd_message.set_token('REASON', SQLERRM);
1675:
1676: if (fnd_log.LEVEL_EXCEPTION >=
1677: fnd_log.g_current_runtime_level) then
1678: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
1679: c_log_head || l_api_name || '.other_err',
1680: FALSE);

Line 1677: fnd_log.g_current_runtime_level) then

1673: fnd_message.set_token('ERRNO', SQLCODE);
1674: fnd_message.set_token('REASON', SQLERRM);
1675:
1676: if (fnd_log.LEVEL_EXCEPTION >=
1677: fnd_log.g_current_runtime_level) then
1678: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
1679: c_log_head || l_api_name || '.other_err',
1680: FALSE);
1681: end if;

Line 1678: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

1674: fnd_message.set_token('REASON', SQLERRM);
1675:
1676: if (fnd_log.LEVEL_EXCEPTION >=
1677: fnd_log.g_current_runtime_level) then
1678: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
1679: c_log_head || l_api_name || '.other_err',
1680: FALSE);
1681: end if;
1682: if (fnd_log.LEVEL_PROCEDURE >=

Line 1682: if (fnd_log.LEVEL_PROCEDURE >=

1678: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
1679: c_log_head || l_api_name || '.other_err',
1680: FALSE);
1681: end if;
1682: if (fnd_log.LEVEL_PROCEDURE >=
1683: fnd_log.g_current_runtime_level) then
1684: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1685: c_log_head || l_api_name || '.end_after_other',
1686: 'U' );

Line 1683: fnd_log.g_current_runtime_level) then

1679: c_log_head || l_api_name || '.other_err',
1680: FALSE);
1681: end if;
1682: if (fnd_log.LEVEL_PROCEDURE >=
1683: fnd_log.g_current_runtime_level) then
1684: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1685: c_log_head || l_api_name || '.end_after_other',
1686: 'U' );
1687: end if;

Line 1684: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1680: FALSE);
1681: end if;
1682: if (fnd_log.LEVEL_PROCEDURE >=
1683: fnd_log.g_current_runtime_level) then
1684: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1685: c_log_head || l_api_name || '.end_after_other',
1686: 'U' );
1687: end if;
1688: RETURN 'U';

Line 1732: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then

1728:
1729: l_object_id number;
1730: l_user_name varchar2(80);
1731: BEGIN
1732: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1733: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1734: c_log_head || l_api_name || '.begin',
1735: c_pkg_name || '.' ||l_api_name|| '(' ||
1736: ' p_api_version=>'|| to_char(p_api_version) ||','||

Line 1733: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1729: l_object_id number;
1730: l_user_name varchar2(80);
1731: BEGIN
1732: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1733: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1734: c_log_head || l_api_name || '.begin',
1735: c_pkg_name || '.' ||l_api_name|| '(' ||
1736: ' p_api_version=>'|| to_char(p_api_version) ||','||
1737: ' p_object_name=>'|| p_object_name ||','||

Line 1757: if (fnd_log.LEVEL_EXCEPTION >=

1753: 'Unsupported version '|| to_char(p_api_version)||
1754: ' passed to API; expecting version '||
1755: to_char(l_api_version));
1756:
1757: if (fnd_log.LEVEL_EXCEPTION >=
1758: fnd_log.g_current_runtime_level) then
1759: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
1760: c_log_head || l_api_name || '.end_bad_api_ver',
1761: FALSE);

Line 1758: fnd_log.g_current_runtime_level) then

1754: ' passed to API; expecting version '||
1755: to_char(l_api_version));
1756:
1757: if (fnd_log.LEVEL_EXCEPTION >=
1758: fnd_log.g_current_runtime_level) then
1759: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
1760: c_log_head || l_api_name || '.end_bad_api_ver',
1761: FALSE);
1762: end if;

Line 1759: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

1755: to_char(l_api_version));
1756:
1757: if (fnd_log.LEVEL_EXCEPTION >=
1758: fnd_log.g_current_runtime_level) then
1759: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
1760: c_log_head || l_api_name || '.end_bad_api_ver',
1761: FALSE);
1762: end if;
1763: x_return_status := 'U';

Line 1775: if (fnd_log.LEVEL_EXCEPTION >=

1771: c_pkg_name || '.'|| l_api_name);
1772: fnd_message.set_token('REASON',
1773: 'NULL value passed for p_object_name:'|| p_object_name);
1774:
1775: if (fnd_log.LEVEL_EXCEPTION >=
1776: fnd_log.g_current_runtime_level) then
1777: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
1778: c_log_head || l_api_name || '.end_bad_param',
1779: FALSE);

Line 1776: fnd_log.g_current_runtime_level) then

1772: fnd_message.set_token('REASON',
1773: 'NULL value passed for p_object_name:'|| p_object_name);
1774:
1775: if (fnd_log.LEVEL_EXCEPTION >=
1776: fnd_log.g_current_runtime_level) then
1777: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
1778: c_log_head || l_api_name || '.end_bad_param',
1779: FALSE);
1780: end if;

Line 1777: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

1773: 'NULL value passed for p_object_name:'|| p_object_name);
1774:
1775: if (fnd_log.LEVEL_EXCEPTION >=
1776: fnd_log.g_current_runtime_level) then
1777: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
1778: c_log_head || l_api_name || '.end_bad_param',
1779: FALSE);
1780: end if;
1781: x_return_status := 'U';

Line 1824: if (fnd_log.LEVEL_EXCEPTION >=

1820: 'a bug against the product that owns the call to this '||
1821: 'routine, which is likely the owner of the object that '||
1822: 'was passed to this routine: '||
1823: p_object_name);
1824: if (fnd_log.LEVEL_EXCEPTION >=
1825: fnd_log.g_current_runtime_level) then
1826: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
1827: c_log_head || l_api_name || '.end_depr_param',
1828: FALSE);

Line 1825: fnd_log.g_current_runtime_level) then

1821: 'routine, which is likely the owner of the object that '||
1822: 'was passed to this routine: '||
1823: p_object_name);
1824: if (fnd_log.LEVEL_EXCEPTION >=
1825: fnd_log.g_current_runtime_level) then
1826: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
1827: c_log_head || l_api_name || '.end_depr_param',
1828: FALSE);
1829: end if;

Line 1826: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

1822: 'was passed to this routine: '||
1823: p_object_name);
1824: if (fnd_log.LEVEL_EXCEPTION >=
1825: fnd_log.g_current_runtime_level) then
1826: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
1827: c_log_head || l_api_name || '.end_depr_param',
1828: FALSE);
1829: end if;
1830: fnd_message.raise_error;

Line 1849: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

1845: p_user_name =>l_user_name,
1846: x_predicate=>l_predicate,
1847: x_return_status=>l_return_status
1848: );
1849: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1850: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1851: c_log_head || l_api_name || '.after_gsp',
1852: 'l_predicate:'||l_predicate);
1853: end if;

Line 1850: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1846: x_predicate=>l_predicate,
1847: x_return_status=>l_return_status
1848: );
1849: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1850: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1851: c_log_head || l_api_name || '.after_gsp',
1852: 'l_predicate:'||l_predicate);
1853: end if;
1854:

Line 1857: if (fnd_log.LEVEL_EXCEPTION >=

1853: end if;
1854:
1855: IF( l_return_status <> 'T' AND l_return_status <> 'F') then
1856: /* There will be a message on the stack from gsp */
1857: if (fnd_log.LEVEL_EXCEPTION >=
1858: fnd_log.g_current_runtime_level) then
1859: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
1860: c_log_head || l_api_name || '.end_gsp_fail',
1861: FALSE);

Line 1858: fnd_log.g_current_runtime_level) then

1854:
1855: IF( l_return_status <> 'T' AND l_return_status <> 'F') then
1856: /* There will be a message on the stack from gsp */
1857: if (fnd_log.LEVEL_EXCEPTION >=
1858: fnd_log.g_current_runtime_level) then
1859: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
1860: c_log_head || l_api_name || '.end_gsp_fail',
1861: FALSE);
1862: end if;

Line 1859: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

1855: IF( l_return_status <> 'T' AND l_return_status <> 'F') then
1856: /* There will be a message on the stack from gsp */
1857: if (fnd_log.LEVEL_EXCEPTION >=
1858: fnd_log.g_current_runtime_level) then
1859: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
1860: c_log_head || l_api_name || '.end_gsp_fail',
1861: FALSE);
1862: end if;
1863: if (l_return_status = 'L') then

Line 1874: if (fnd_log.LEVEL_PROCEDURE >=

1870: end if;
1871:
1872: IF( l_return_status = 'F') then /* If there weren't enough grants */
1873: /* to make a predicate, we are done. */
1874: if (fnd_log.LEVEL_PROCEDURE >=
1875: fnd_log.g_current_runtime_level) then
1876: fnd_log.message(FND_LOG.LEVEL_PROCEDURE,
1877: c_log_head || l_api_name || '.end_gsp_nopred',
1878: FALSE);

Line 1875: fnd_log.g_current_runtime_level) then

1871:
1872: IF( l_return_status = 'F') then /* If there weren't enough grants */
1873: /* to make a predicate, we are done. */
1874: if (fnd_log.LEVEL_PROCEDURE >=
1875: fnd_log.g_current_runtime_level) then
1876: fnd_log.message(FND_LOG.LEVEL_PROCEDURE,
1877: c_log_head || l_api_name || '.end_gsp_nopred',
1878: FALSE);
1879: end if;

Line 1876: fnd_log.message(FND_LOG.LEVEL_PROCEDURE,

1872: IF( l_return_status = 'F') then /* If there weren't enough grants */
1873: /* to make a predicate, we are done. */
1874: if (fnd_log.LEVEL_PROCEDURE >=
1875: fnd_log.g_current_runtime_level) then
1876: fnd_log.message(FND_LOG.LEVEL_PROCEDURE,
1877: c_log_head || l_api_name || '.end_gsp_nopred',
1878: FALSE);
1879: end if;
1880: x_return_status := 'F';

Line 1887: if (fnd_log.LEVEL_STATEMENT >=

1883:
1884: IF( length(l_predicate ) >1) THEN
1885: dynamic_sql := l_predicate;
1886:
1887: if (fnd_log.LEVEL_STATEMENT >=
1888: fnd_log.g_current_runtime_level) then
1889: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1890: c_log_head || l_api_name || '.create_dy_sql',
1891: 'dynamic_sql:'||dynamic_sql);

Line 1888: fnd_log.g_current_runtime_level) then

1884: IF( length(l_predicate ) >1) THEN
1885: dynamic_sql := l_predicate;
1886:
1887: if (fnd_log.LEVEL_STATEMENT >=
1888: fnd_log.g_current_runtime_level) then
1889: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1890: c_log_head || l_api_name || '.create_dy_sql',
1891: 'dynamic_sql:'||dynamic_sql);
1892: end if;

Line 1889: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1885: dynamic_sql := l_predicate;
1886:
1887: if (fnd_log.LEVEL_STATEMENT >=
1888: fnd_log.g_current_runtime_level) then
1889: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1890: c_log_head || l_api_name || '.create_dy_sql',
1891: 'dynamic_sql:'||dynamic_sql);
1892: end if;
1893:

Line 1925: if (fnd_log.LEVEL_STATEMENT >=

1921: end if;
1922: l_index := 0;
1923: LOOP
1924: FETCH instance_sets_cur INTO function_name ;
1925: if (fnd_log.LEVEL_STATEMENT >=
1926: fnd_log.g_current_runtime_level) then
1927: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1928: c_log_head || l_api_name || '.got_priv',
1929: 'function_name:' || function_name);

Line 1926: fnd_log.g_current_runtime_level) then

1922: l_index := 0;
1923: LOOP
1924: FETCH instance_sets_cur INTO function_name ;
1925: if (fnd_log.LEVEL_STATEMENT >=
1926: fnd_log.g_current_runtime_level) then
1927: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1928: c_log_head || l_api_name || '.got_priv',
1929: 'function_name:' || function_name);
1930: end if;

Line 1927: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1923: LOOP
1924: FETCH instance_sets_cur INTO function_name ;
1925: if (fnd_log.LEVEL_STATEMENT >=
1926: fnd_log.g_current_runtime_level) then
1927: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1928: c_log_head || l_api_name || '.got_priv',
1929: 'function_name:' || function_name);
1930: end if;
1931: EXIT WHEN instance_sets_cur%NOTFOUND;

Line 1941: if (fnd_log.LEVEL_PROCEDURE >=

1937: x_return_status := 'T'; /* Success */
1938: else
1939: x_return_status := 'F'; /* No functions */
1940: end if;
1941: if (fnd_log.LEVEL_PROCEDURE >=
1942: fnd_log.g_current_runtime_level) then
1943: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1944: c_log_head || l_api_name || '.end',
1945: 'returning '|| x_return_status );

Line 1942: fnd_log.g_current_runtime_level) then

1938: else
1939: x_return_status := 'F'; /* No functions */
1940: end if;
1941: if (fnd_log.LEVEL_PROCEDURE >=
1942: fnd_log.g_current_runtime_level) then
1943: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1944: c_log_head || l_api_name || '.end',
1945: 'returning '|| x_return_status );
1946: end if;

Line 1943: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1939: x_return_status := 'F'; /* No functions */
1940: end if;
1941: if (fnd_log.LEVEL_PROCEDURE >=
1942: fnd_log.g_current_runtime_level) then
1943: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1944: c_log_head || l_api_name || '.end',
1945: 'returning '|| x_return_status );
1946: end if;
1947: ELSE

Line 1949: if (fnd_log.LEVEL_PROCEDURE >=

1945: 'returning '|| x_return_status );
1946: end if;
1947: ELSE
1948: -- No predicate
1949: if (fnd_log.LEVEL_PROCEDURE >=
1950: fnd_log.g_current_runtime_level) then
1951: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1952: c_log_head || l_api_name || '.end_nopred',
1953: 'F');

Line 1950: fnd_log.g_current_runtime_level) then

1946: end if;
1947: ELSE
1948: -- No predicate
1949: if (fnd_log.LEVEL_PROCEDURE >=
1950: fnd_log.g_current_runtime_level) then
1951: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1952: c_log_head || l_api_name || '.end_nopred',
1953: 'F');
1954: end if;

Line 1951: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1947: ELSE
1948: -- No predicate
1949: if (fnd_log.LEVEL_PROCEDURE >=
1950: fnd_log.g_current_runtime_level) then
1951: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1952: c_log_head || l_api_name || '.end_nopred',
1953: 'F');
1954: end if;
1955: x_return_status := 'F';

Line 1978: if (fnd_log.LEVEL_EXCEPTION >=

1974: c_pkg_name || '.'|| l_api_name);
1975: fnd_message.set_token('ERRNO', SQLCODE);
1976: fnd_message.set_token('REASON', SQLERRM);
1977:
1978: if (fnd_log.LEVEL_EXCEPTION >=
1979: fnd_log.g_current_runtime_level) then
1980: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
1981: c_log_head || l_api_name || '.other_err',
1982: FALSE);

Line 1979: fnd_log.g_current_runtime_level) then

1975: fnd_message.set_token('ERRNO', SQLCODE);
1976: fnd_message.set_token('REASON', SQLERRM);
1977:
1978: if (fnd_log.LEVEL_EXCEPTION >=
1979: fnd_log.g_current_runtime_level) then
1980: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
1981: c_log_head || l_api_name || '.other_err',
1982: FALSE);
1983: end if;

Line 1980: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

1976: fnd_message.set_token('REASON', SQLERRM);
1977:
1978: if (fnd_log.LEVEL_EXCEPTION >=
1979: fnd_log.g_current_runtime_level) then
1980: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
1981: c_log_head || l_api_name || '.other_err',
1982: FALSE);
1983: end if;
1984: if (fnd_log.LEVEL_PROCEDURE >=

Line 1984: if (fnd_log.LEVEL_PROCEDURE >=

1980: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
1981: c_log_head || l_api_name || '.other_err',
1982: FALSE);
1983: end if;
1984: if (fnd_log.LEVEL_PROCEDURE >=
1985: fnd_log.g_current_runtime_level) then
1986: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1987: c_log_head || l_api_name || '.end_after_other',
1988: 'returning '|| 'U' );

Line 1985: fnd_log.g_current_runtime_level) then

1981: c_log_head || l_api_name || '.other_err',
1982: FALSE);
1983: end if;
1984: if (fnd_log.LEVEL_PROCEDURE >=
1985: fnd_log.g_current_runtime_level) then
1986: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1987: c_log_head || l_api_name || '.end_after_other',
1988: 'returning '|| 'U' );
1989: end if;

Line 1986: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1982: FALSE);
1983: end if;
1984: if (fnd_log.LEVEL_PROCEDURE >=
1985: fnd_log.g_current_runtime_level) then
1986: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1987: c_log_head || l_api_name || '.end_after_other',
1988: 'returning '|| 'U' );
1989: end if;
1990: x_return_status := 'U';

Line 2023: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then

2019: l_menu_id NUMBER;
2020: l_out_menu_tbl FND_TABLE_OF_NUMBER;
2021: l_user_id_str VARCHAR2(255);
2022: begin
2023: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
2024: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2025: c_log_head || l_api_name || '.begin',
2026: c_pkg_name || '.' ||l_api_name|| '(' ||
2027: ' p_api_version=>'|| to_char(p_api_version) ||','||

Line 2024: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

2020: l_out_menu_tbl FND_TABLE_OF_NUMBER;
2021: l_user_id_str VARCHAR2(255);
2022: begin
2023: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
2024: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2025: c_log_head || l_api_name || '.begin',
2026: c_pkg_name || '.' ||l_api_name|| '(' ||
2027: ' p_api_version=>'|| to_char(p_api_version) ||','||
2028: ' p_object_name=>'|| p_object_name ||','||

Line 2046: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then

2042: fnd_message.set_token('REASON',
2043: 'Unsupported version '|| to_char(p_api_version)||
2044: ' passed to API; expecting version '||
2045: to_char(l_api_version));
2046: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
2047: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2048: c_log_head || l_api_name || '.end_bad_api_ver',
2049: FALSE);
2050: end if;

Line 2047: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

2043: 'Unsupported version '|| to_char(p_api_version)||
2044: ' passed to API; expecting version '||
2045: to_char(l_api_version));
2046: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
2047: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2048: c_log_head || l_api_name || '.end_bad_api_ver',
2049: FALSE);
2050: end if;
2051: x_return_status := 'U';

Line 2079: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

2075: l_out_menu_tbl := FND_TABLE_OF_NUMBER();
2076:
2077: LOOP
2078: begin
2079: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2080: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2081: c_log_head || l_api_name || '.got_menu',
2082: 'menu_id:' || l_menu_tbl(l_index));
2083: end if;

Line 2080: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

2076:
2077: LOOP
2078: begin
2079: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2080: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2081: c_log_head || l_api_name || '.got_menu',
2082: 'menu_id:' || l_menu_tbl(l_index));
2083: end if;
2084: l_menu_id := to_number(l_menu_tbl(l_index));

Line 2101: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then

2097: x_menu_tbl := NULL;
2098: x_return_status := 'F';
2099: end if;
2100:
2101: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
2102: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2103: c_log_head || l_api_name || '.end',
2104: 'returning status'|| x_return_status );
2105: end if;

Line 2102: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

2098: x_return_status := 'F';
2099: end if;
2100:
2101: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
2102: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2103: c_log_head || l_api_name || '.end',
2104: 'returning status'|| x_return_status );
2105: end if;
2106:

Line 2307: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then

2303: l_object_id number;
2304: l_function_id number;
2305: BEGIN
2306:
2307: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
2308: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2309: c_log_head || l_api_name || '.begin',
2310: c_pkg_name || '.' ||l_api_name|| '(' ||
2311: ', p_function=>'|| p_function ||

Line 2308: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

2304: l_function_id number;
2305: BEGIN
2306:
2307: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
2308: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2309: c_log_head || l_api_name || '.begin',
2310: c_pkg_name || '.' ||l_api_name|| '(' ||
2311: ', p_function=>'|| p_function ||
2312: ', p_object_name=>'|| p_object_name ||

Line 2362: if (fnd_log.LEVEL_EXCEPTION >=

2358: 'a bug against the product that owns the call to this '||
2359: 'routine, which is likely the owner of the object that '||
2360: 'was passed to this routine: '||
2361: p_object_name);
2362: if (fnd_log.LEVEL_EXCEPTION >=
2363: fnd_log.g_current_runtime_level) then
2364: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2365: c_log_head || l_api_name || '.end_depr_param',
2366: FALSE);

Line 2363: fnd_log.g_current_runtime_level) then

2359: 'routine, which is likely the owner of the object that '||
2360: 'was passed to this routine: '||
2361: p_object_name);
2362: if (fnd_log.LEVEL_EXCEPTION >=
2363: fnd_log.g_current_runtime_level) then
2364: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2365: c_log_head || l_api_name || '.end_depr_param',
2366: FALSE);
2367: end if;

Line 2364: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

2360: 'was passed to this routine: '||
2361: p_object_name);
2362: if (fnd_log.LEVEL_EXCEPTION >=
2363: fnd_log.g_current_runtime_level) then
2364: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2365: c_log_head || l_api_name || '.end_depr_param',
2366: FALSE);
2367: end if;
2368: fnd_message.raise_error;

Line 2375: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

2371: LENGTH('GET_MNUIDS_NBVCXDS:')+1);
2372: else
2373: l_user_name := SYS_CONTEXT('FND','USER_NAME');
2374: end if;
2375: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2376: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2377: c_log_head || l_api_name || '.get_mnuid',
2378: 'l_user_name= '||l_user_name);
2379: end if;

Line 2376: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

2372: else
2373: l_user_name := SYS_CONTEXT('FND','USER_NAME');
2374: end if;
2375: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2376: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2377: c_log_head || l_api_name || '.get_mnuid',
2378: 'l_user_name= '||l_user_name);
2379: end if;
2380: elsif (p_user_name is NULL) then

Line 2382: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

2378: 'l_user_name= '||l_user_name);
2379: end if;
2380: elsif (p_user_name is NULL) then
2381: l_user_name := SYS_CONTEXT('FND','USER_NAME');
2382: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2383: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2384: c_log_head || l_api_name || '.null_username',
2385: 'l_user_name= '||l_user_name);
2386: end if;

Line 2383: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

2379: end if;
2380: elsif (p_user_name is NULL) then
2381: l_user_name := SYS_CONTEXT('FND','USER_NAME');
2382: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2383: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2384: c_log_head || l_api_name || '.null_username',
2385: 'l_user_name= '||l_user_name);
2386: end if;
2387: else

Line 2418: if (fnd_log.LEVEL_EXCEPTION >=

2414: 'a bug against the product that owns the call to this '||
2415: 'routine, which is likely the owner of the object that '||
2416: 'was passed to this routine: '||
2417: p_object_name);
2418: if (fnd_log.LEVEL_EXCEPTION >=
2419: fnd_log.g_current_runtime_level) then
2420: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2421: c_log_head || l_api_name || '.end_depr_param',
2422: FALSE);

Line 2419: fnd_log.g_current_runtime_level) then

2415: 'routine, which is likely the owner of the object that '||
2416: 'was passed to this routine: '||
2417: p_object_name);
2418: if (fnd_log.LEVEL_EXCEPTION >=
2419: fnd_log.g_current_runtime_level) then
2420: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2421: c_log_head || l_api_name || '.end_depr_param',
2422: FALSE);
2423: end if;

Line 2420: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

2416: 'was passed to this routine: '||
2417: p_object_name);
2418: if (fnd_log.LEVEL_EXCEPTION >=
2419: fnd_log.g_current_runtime_level) then
2420: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2421: c_log_head || l_api_name || '.end_depr_param',
2422: FALSE);
2423: end if;
2424: fnd_message.raise_error;

Line 2427: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

2423: end if;
2424: fnd_message.raise_error;
2425: end if;
2426: l_user_name := p_user_name;
2427: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2428: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2429: c_log_head || l_api_name || '.passed_uname',
2430: 'l_user_name= '||l_user_name);
2431: end if;

Line 2428: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

2424: fnd_message.raise_error;
2425: end if;
2426: l_user_name := p_user_name;
2427: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2428: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2429: c_log_head || l_api_name || '.passed_uname',
2430: 'l_user_name= '||l_user_name);
2431: end if;
2432: end if;

Line 2448: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then

2444: 'The user_name passed or defaulted is not a valid user_name '||
2445: 'in wf_user_roles. '||
2446: 'Invalid user_name: '||l_user_name ||
2447: ' Passed p_user_name: '||p_user_name);
2448: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
2449: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2450: c_log_head || l_api_name || '.end_no_wf_user_role',
2451: FALSE);
2452: end if;

Line 2449: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

2445: 'in wf_user_roles. '||
2446: 'Invalid user_name: '||l_user_name ||
2447: ' Passed p_user_name: '||p_user_name);
2448: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
2449: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2450: c_log_head || l_api_name || '.end_no_wf_user_role',
2451: FALSE);
2452: end if;
2453: l_aggregate_predicate := '1=2';

Line 2461: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

2457:
2458:
2459: -- Step 1.
2460:
2461: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2462: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2463: c_log_head || l_api_name || '.step1start',
2464: 'p_grant_instance_type:'||p_grant_instance_type);
2465: end if;

Line 2462: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

2458:
2459: -- Step 1.
2460:
2461: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2462: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2463: c_log_head || l_api_name || '.step1start',
2464: 'p_grant_instance_type:'||p_grant_instance_type);
2465: end if;
2466: IF (p_grant_instance_type = C_TYPE_INSTANCE) THEN

Line 2467: if (fnd_log.LEVEL_STATEMENT >=

2463: c_log_head || l_api_name || '.step1start',
2464: 'p_grant_instance_type:'||p_grant_instance_type);
2465: end if;
2466: IF (p_grant_instance_type = C_TYPE_INSTANCE) THEN
2467: if (fnd_log.LEVEL_STATEMENT >=
2468: fnd_log.g_current_runtime_level) then
2469: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2470: c_log_head || l_api_name || '.chk_instance',
2471: ' l_instance_set_flag := FALSE ');

Line 2468: fnd_log.g_current_runtime_level) then

2464: 'p_grant_instance_type:'||p_grant_instance_type);
2465: end if;
2466: IF (p_grant_instance_type = C_TYPE_INSTANCE) THEN
2467: if (fnd_log.LEVEL_STATEMENT >=
2468: fnd_log.g_current_runtime_level) then
2469: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2470: c_log_head || l_api_name || '.chk_instance',
2471: ' l_instance_set_flag := FALSE ');
2472: end if;

Line 2469: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

2465: end if;
2466: IF (p_grant_instance_type = C_TYPE_INSTANCE) THEN
2467: if (fnd_log.LEVEL_STATEMENT >=
2468: fnd_log.g_current_runtime_level) then
2469: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2470: c_log_head || l_api_name || '.chk_instance',
2471: ' l_instance_set_flag := FALSE ');
2472: end if;
2473: l_instance_set_flag:= FALSE;

Line 2475: if (fnd_log.LEVEL_STATEMENT >=

2471: ' l_instance_set_flag := FALSE ');
2472: end if;
2473: l_instance_set_flag:= FALSE;
2474: ELSIF (p_grant_instance_type = C_TYPE_SET) THEN
2475: if (fnd_log.LEVEL_STATEMENT >=
2476: fnd_log.g_current_runtime_level) then
2477: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2478: c_log_head || l_api_name || '.chk_set',
2479: ' l_instance_flag := FALSE ');

Line 2476: fnd_log.g_current_runtime_level) then

2472: end if;
2473: l_instance_set_flag:= FALSE;
2474: ELSIF (p_grant_instance_type = C_TYPE_SET) THEN
2475: if (fnd_log.LEVEL_STATEMENT >=
2476: fnd_log.g_current_runtime_level) then
2477: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2478: c_log_head || l_api_name || '.chk_set',
2479: ' l_instance_flag := FALSE ');
2480: end if;

Line 2477: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

2473: l_instance_set_flag:= FALSE;
2474: ELSIF (p_grant_instance_type = C_TYPE_SET) THEN
2475: if (fnd_log.LEVEL_STATEMENT >=
2476: fnd_log.g_current_runtime_level) then
2477: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2478: c_log_head || l_api_name || '.chk_set',
2479: ' l_instance_flag := FALSE ');
2480: end if;
2481: l_instance_flag:= FALSE;

Line 2483: if (fnd_log.LEVEL_STATEMENT >=

2479: ' l_instance_flag := FALSE ');
2480: end if;
2481: l_instance_flag:= FALSE;
2482: ELSIF (p_grant_instance_type = 'FUNCLIST') THEN
2483: if (fnd_log.LEVEL_STATEMENT >=
2484: fnd_log.g_current_runtime_level) then
2485: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2486: c_log_head || l_api_name || '.chk_funclist',
2487: ' l_funclist_flag := TRUE ');

Line 2484: fnd_log.g_current_runtime_level) then

2480: end if;
2481: l_instance_flag:= FALSE;
2482: ELSIF (p_grant_instance_type = 'FUNCLIST') THEN
2483: if (fnd_log.LEVEL_STATEMENT >=
2484: fnd_log.g_current_runtime_level) then
2485: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2486: c_log_head || l_api_name || '.chk_funclist',
2487: ' l_funclist_flag := TRUE ');
2488: end if;

Line 2485: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

2481: l_instance_flag:= FALSE;
2482: ELSIF (p_grant_instance_type = 'FUNCLIST') THEN
2483: if (fnd_log.LEVEL_STATEMENT >=
2484: fnd_log.g_current_runtime_level) then
2485: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2486: c_log_head || l_api_name || '.chk_funclist',
2487: ' l_funclist_flag := TRUE ');
2488: end if;
2489: l_funclist_flag:= TRUE;

Line 2491: if (fnd_log.LEVEL_STATEMENT >=

2487: ' l_funclist_flag := TRUE ');
2488: end if;
2489: l_funclist_flag:= TRUE;
2490: ELSIF (p_grant_instance_type = 'FUNCLIST_NOINST') THEN
2491: if (fnd_log.LEVEL_STATEMENT >=
2492: fnd_log.g_current_runtime_level) then
2493: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2494: c_log_head || l_api_name || '.chk_funclist_noinst',
2495: ' l_funclist_flag := TRUE ');

Line 2492: fnd_log.g_current_runtime_level) then

2488: end if;
2489: l_funclist_flag:= TRUE;
2490: ELSIF (p_grant_instance_type = 'FUNCLIST_NOINST') THEN
2491: if (fnd_log.LEVEL_STATEMENT >=
2492: fnd_log.g_current_runtime_level) then
2493: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2494: c_log_head || l_api_name || '.chk_funclist_noinst',
2495: ' l_funclist_flag := TRUE ');
2496: end if;

Line 2493: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

2489: l_funclist_flag:= TRUE;
2490: ELSIF (p_grant_instance_type = 'FUNCLIST_NOINST') THEN
2491: if (fnd_log.LEVEL_STATEMENT >=
2492: fnd_log.g_current_runtime_level) then
2493: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2494: c_log_head || l_api_name || '.chk_funclist_noinst',
2495: ' l_funclist_flag := TRUE ');
2496: end if;
2497: l_funclist_flag:= TRUE;

Line 2501: if (fnd_log.LEVEL_STATEMENT >=

2497: l_funclist_flag:= TRUE;
2498: l_instance_flag:= FALSE;
2499: l_instance_set_flag:= FALSE;
2500: ELSIF (p_grant_instance_type = 'GRANTS_ONLY') THEN
2501: if (fnd_log.LEVEL_STATEMENT >=
2502: fnd_log.g_current_runtime_level) then
2503: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2504: c_log_head || l_api_name || '.chk_grants_only',
2505: ' l_funclist_flag := FALSE ');

Line 2502: fnd_log.g_current_runtime_level) then

2498: l_instance_flag:= FALSE;
2499: l_instance_set_flag:= FALSE;
2500: ELSIF (p_grant_instance_type = 'GRANTS_ONLY') THEN
2501: if (fnd_log.LEVEL_STATEMENT >=
2502: fnd_log.g_current_runtime_level) then
2503: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2504: c_log_head || l_api_name || '.chk_grants_only',
2505: ' l_funclist_flag := FALSE ');
2506: end if;

Line 2503: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

2499: l_instance_set_flag:= FALSE;
2500: ELSIF (p_grant_instance_type = 'GRANTS_ONLY') THEN
2501: if (fnd_log.LEVEL_STATEMENT >=
2502: fnd_log.g_current_runtime_level) then
2503: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2504: c_log_head || l_api_name || '.chk_grants_only',
2505: ' l_funclist_flag := FALSE ');
2506: end if;
2507: l_grants_only_flag:= TRUE;

Line 2512: if (fnd_log.LEVEL_STATEMENT >=

2508: l_funclist_flag:= FALSE;
2509: l_instance_flag:= FALSE;
2510: l_instance_set_flag:= FALSE;
2511: ELSIF (p_grant_instance_type = 'UNIVERSAL') THEN
2512: if (fnd_log.LEVEL_STATEMENT >=
2513: fnd_log.g_current_runtime_level) then
2514: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2515: c_log_head || l_api_name || '.chk_universal',
2516: ' ');

Line 2513: fnd_log.g_current_runtime_level) then

2509: l_instance_flag:= FALSE;
2510: l_instance_set_flag:= FALSE;
2511: ELSIF (p_grant_instance_type = 'UNIVERSAL') THEN
2512: if (fnd_log.LEVEL_STATEMENT >=
2513: fnd_log.g_current_runtime_level) then
2514: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2515: c_log_head || l_api_name || '.chk_universal',
2516: ' ');
2517: end if;

Line 2514: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

2510: l_instance_set_flag:= FALSE;
2511: ELSIF (p_grant_instance_type = 'UNIVERSAL') THEN
2512: if (fnd_log.LEVEL_STATEMENT >=
2513: fnd_log.g_current_runtime_level) then
2514: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2515: c_log_head || l_api_name || '.chk_universal',
2516: ' ');
2517: end if;
2518: END IF;

Line 2526: if (fnd_log.LEVEL_EXCEPTION >=

2522: fnd_message.set_token('ROUTINE',
2523: c_pkg_name || '.'|| l_api_name);
2524: fnd_message.set_token('REASON',
2525: 'The parameter p_object_name can not be NULL.');
2526: if (fnd_log.LEVEL_EXCEPTION >=
2527: fnd_log.g_current_runtime_level) then
2528: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2529: c_log_head || l_api_name || '.end_null_obj',
2530: FALSE);

Line 2527: fnd_log.g_current_runtime_level) then

2523: c_pkg_name || '.'|| l_api_name);
2524: fnd_message.set_token('REASON',
2525: 'The parameter p_object_name can not be NULL.');
2526: if (fnd_log.LEVEL_EXCEPTION >=
2527: fnd_log.g_current_runtime_level) then
2528: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2529: c_log_head || l_api_name || '.end_null_obj',
2530: FALSE);
2531: end if;

Line 2528: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

2524: fnd_message.set_token('REASON',
2525: 'The parameter p_object_name can not be NULL.');
2526: if (fnd_log.LEVEL_EXCEPTION >=
2527: fnd_log.g_current_runtime_level) then
2528: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2529: c_log_head || l_api_name || '.end_null_obj',
2530: FALSE);
2531: end if;
2532: x_return_status := 'U';

Line 2559: if (fnd_log.LEVEL_EXCEPTION >=

2555: fnd_message.set_token('ROUTINE',
2556: c_pkg_name || '.'|| l_api_name);
2557: fnd_message.set_token('REASON',
2558: 'The parameter p_object_name can not be ''GLOBAL''. ');
2559: if (fnd_log.LEVEL_EXCEPTION >=
2560: fnd_log.g_current_runtime_level) then
2561: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2562: c_log_head || l_api_name || '.end_glob_obj',
2563: FALSE);

Line 2560: fnd_log.g_current_runtime_level) then

2556: c_pkg_name || '.'|| l_api_name);
2557: fnd_message.set_token('REASON',
2558: 'The parameter p_object_name can not be ''GLOBAL''. ');
2559: if (fnd_log.LEVEL_EXCEPTION >=
2560: fnd_log.g_current_runtime_level) then
2561: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2562: c_log_head || l_api_name || '.end_glob_obj',
2563: FALSE);
2564: end if;

Line 2561: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

2557: fnd_message.set_token('REASON',
2558: 'The parameter p_object_name can not be ''GLOBAL''. ');
2559: if (fnd_log.LEVEL_EXCEPTION >=
2560: fnd_log.g_current_runtime_level) then
2561: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2562: c_log_head || l_api_name || '.end_glob_obj',
2563: FALSE);
2564: end if;
2565: x_return_status := 'U';

Line 2576: if (fnd_log.LEVEL_EXCEPTION >=

2572: fnd_message.set_token('ROUTINE',
2573: c_pkg_name || '.'|| l_api_name);
2574: fnd_message.set_token('REASON',
2575: 'The parameter p_object_name can not be ''GLOBAL''. ');
2576: if (fnd_log.LEVEL_EXCEPTION >=
2577: fnd_log.g_current_runtime_level) then
2578: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2579: c_log_head || l_api_name || '.end_glob_obj',
2580: FALSE);

Line 2577: fnd_log.g_current_runtime_level) then

2573: c_pkg_name || '.'|| l_api_name);
2574: fnd_message.set_token('REASON',
2575: 'The parameter p_object_name can not be ''GLOBAL''. ');
2576: if (fnd_log.LEVEL_EXCEPTION >=
2577: fnd_log.g_current_runtime_level) then
2578: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2579: c_log_head || l_api_name || '.end_glob_obj',
2580: FALSE);
2581: end if;

Line 2578: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

2574: fnd_message.set_token('REASON',
2575: 'The parameter p_object_name can not be ''GLOBAL''. ');
2576: if (fnd_log.LEVEL_EXCEPTION >=
2577: fnd_log.g_current_runtime_level) then
2578: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2579: c_log_head || l_api_name || '.end_glob_obj',
2580: FALSE);
2581: end if;
2582: x_return_status := 'U';

Line 2599: if (fnd_log.LEVEL_PROCEDURE >=

2595: l_pk_orig_column_names,
2596: l_db_object_name,
2597: 'OBJTAB', 'GNT');
2598: if (x_return_status <> 'T') then
2599: if (fnd_log.LEVEL_PROCEDURE >=
2600: fnd_log.g_current_runtime_level) then
2601: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2602: c_log_head || l_api_name || '.end_pk_info_err',
2603: 'returning status: '|| x_return_status);

Line 2600: fnd_log.g_current_runtime_level) then

2596: l_db_object_name,
2597: 'OBJTAB', 'GNT');
2598: if (x_return_status <> 'T') then
2599: if (fnd_log.LEVEL_PROCEDURE >=
2600: fnd_log.g_current_runtime_level) then
2601: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2602: c_log_head || l_api_name || '.end_pk_info_err',
2603: 'returning status: '|| x_return_status);
2604: end if;

Line 2601: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

2597: 'OBJTAB', 'GNT');
2598: if (x_return_status <> 'T') then
2599: if (fnd_log.LEVEL_PROCEDURE >=
2600: fnd_log.g_current_runtime_level) then
2601: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2602: c_log_head || l_api_name || '.end_pk_info_err',
2603: 'returning status: '|| x_return_status);
2604: end if;
2605: /* There will be a message on the msg dict stack. */

Line 2617: if (fnd_log.LEVEL_EXCEPTION >=

2613: c_pkg_name || '.'|| l_api_name);
2614: fnd_message.set_token('REASON',
2615: 'The parameter value p_object_name is not a valid object.'||
2616: ' p_object_name:'||p_object_name);
2617: if (fnd_log.LEVEL_EXCEPTION >=
2618: fnd_log.g_current_runtime_level) then
2619: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2620: c_log_head || l_api_name || '.end_bad_obj',
2621: FALSE);

Line 2618: fnd_log.g_current_runtime_level) then

2614: fnd_message.set_token('REASON',
2615: 'The parameter value p_object_name is not a valid object.'||
2616: ' p_object_name:'||p_object_name);
2617: if (fnd_log.LEVEL_EXCEPTION >=
2618: fnd_log.g_current_runtime_level) then
2619: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2620: c_log_head || l_api_name || '.end_bad_obj',
2621: FALSE);
2622: end if;

Line 2619: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

2615: 'The parameter value p_object_name is not a valid object.'||
2616: ' p_object_name:'||p_object_name);
2617: if (fnd_log.LEVEL_EXCEPTION >=
2618: fnd_log.g_current_runtime_level) then
2619: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2620: c_log_head || l_api_name || '.end_bad_obj',
2621: FALSE);
2622: end if;
2623: x_return_status := 'U';

Line 2639: if (fnd_log.LEVEL_EXCEPTION >=

2635: c_pkg_name || '.'|| l_api_name);
2636: fnd_message.set_token('REASON',
2637: 'The parameter value p_function is not a valid function name.'||
2638: ' p_function:'||p_function);
2639: if (fnd_log.LEVEL_EXCEPTION >=
2640: fnd_log.g_current_runtime_level) then
2641: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2642: c_log_head || l_api_name || '.end_bad_func',
2643: FALSE);

Line 2640: fnd_log.g_current_runtime_level) then

2636: fnd_message.set_token('REASON',
2637: 'The parameter value p_function is not a valid function name.'||
2638: ' p_function:'||p_function);
2639: if (fnd_log.LEVEL_EXCEPTION >=
2640: fnd_log.g_current_runtime_level) then
2641: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2642: c_log_head || l_api_name || '.end_bad_func',
2643: FALSE);
2644: end if;

Line 2641: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

2637: 'The parameter value p_function is not a valid function name.'||
2638: ' p_function:'||p_function);
2639: if (fnd_log.LEVEL_EXCEPTION >=
2640: fnd_log.g_current_runtime_level) then
2641: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2642: c_log_head || l_api_name || '.end_bad_func',
2643: FALSE);
2644: end if;
2645: x_return_status := 'U';

Line 2790: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

2786: IF ((l_instance_flag = TRUE) OR (l_instance_set_flag = TRUE)) then
2787: l_aggregate_predicate := l_aggregate_predicate ||
2788: ' AND '||l_exact_clause;
2789: END IF;
2790: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2791: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2792: c_log_head || l_api_name || '.step2astart','step2astart');
2793: end if;
2794: END IF;

Line 2791: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

2787: l_aggregate_predicate := l_aggregate_predicate ||
2788: ' AND '||l_exact_clause;
2789: END IF;
2790: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2791: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2792: c_log_head || l_api_name || '.step2astart','step2astart');
2793: end if;
2794: END IF;
2795: if(l_grants_only_flag = FALSE) then

Line 2802: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

2798: end if;
2799: IF(l_instance_flag = TRUE) THEN
2800: /* Add on the clause for INSTANCE_TYPE = 'INSTANCE' */
2801: l_aggregate_predicate := l_aggregate_predicate || l_ik_clause;
2802: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2803: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2804: c_log_head || l_api_name || '.step2start','step2start');
2805: end if;
2806: END IF;

Line 2803: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

2799: IF(l_instance_flag = TRUE) THEN
2800: /* Add on the clause for INSTANCE_TYPE = 'INSTANCE' */
2801: l_aggregate_predicate := l_aggregate_predicate || l_ik_clause;
2802: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2803: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2804: c_log_head || l_api_name || '.step2start','step2start');
2805: end if;
2806: END IF;
2807: IF(l_instance_set_flag = TRUE) THEN

Line 2809: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

2805: end if;
2806: END IF;
2807: IF(l_instance_set_flag = TRUE) THEN
2808: /* Add on the clause for INSTANCE_TYPE = 'SET' */
2809: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2810: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2811: c_log_head || l_api_name || '.step3start',
2812: ' user_name: '|| l_user_name ||
2813: ' function: '|| p_function ||

Line 2810: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

2806: END IF;
2807: IF(l_instance_set_flag = TRUE) THEN
2808: /* Add on the clause for INSTANCE_TYPE = 'SET' */
2809: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2810: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2811: c_log_head || l_api_name || '.step3start',
2812: ' user_name: '|| l_user_name ||
2813: ' function: '|| p_function ||
2814: ' l_object_id: '|| l_object_id);

Line 2833: if (fnd_log.LEVEL_STATEMENT >=

2829: /* Upgrade and substitute predicate */
2830: l_pred := upgrade_predicate(
2831: instance_set_grants_bkwd_rec.predicate);
2832:
2833: if (fnd_log.LEVEL_STATEMENT >=
2834: fnd_log.g_current_runtime_level) then
2835: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2836: c_log_head || l_api_name || '.upgd_pred',
2837: 'l_pred:'||l_pred);

Line 2834: fnd_log.g_current_runtime_level) then

2830: l_pred := upgrade_predicate(
2831: instance_set_grants_bkwd_rec.predicate);
2832:
2833: if (fnd_log.LEVEL_STATEMENT >=
2834: fnd_log.g_current_runtime_level) then
2835: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2836: c_log_head || l_api_name || '.upgd_pred',
2837: 'l_pred:'||l_pred);
2838: end if;

Line 2835: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

2831: instance_set_grants_bkwd_rec.predicate);
2832:
2833: if (fnd_log.LEVEL_STATEMENT >=
2834: fnd_log.g_current_runtime_level) then
2835: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2836: c_log_head || l_api_name || '.upgd_pred',
2837: 'l_pred:'||l_pred);
2838: end if;
2839:

Line 2850: if (fnd_log.LEVEL_STATEMENT >=

2846: l_pred := substitute_predicate(
2847: l_pred,
2848: p_table_alias);
2849: end if;
2850: if (fnd_log.LEVEL_STATEMENT >=
2851: fnd_log.g_current_runtime_level) then
2852: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2853: c_log_head || l_api_name || '.subbed_pred',
2854: 'l_pred:'||l_pred);

Line 2851: fnd_log.g_current_runtime_level) then

2847: l_pred,
2848: p_table_alias);
2849: end if;
2850: if (fnd_log.LEVEL_STATEMENT >=
2851: fnd_log.g_current_runtime_level) then
2852: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2853: c_log_head || l_api_name || '.subbed_pred',
2854: 'l_pred:'||l_pred);
2855: end if;

Line 2852: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

2848: p_table_alias);
2849: end if;
2850: if (fnd_log.LEVEL_STATEMENT >=
2851: fnd_log.g_current_runtime_level) then
2852: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2853: c_log_head || l_api_name || '.subbed_pred',
2854: 'l_pred:'||l_pred);
2855: end if;
2856:

Line 2863: if (fnd_log.LEVEL_STATEMENT >=

2859: instance_set_grants_bkwd_rec.instance_set_id ||
2860: ' ) AND ('||
2861: l_pred ||
2862: ' )) OR ', 1, c_pred_buf_size);
2863: if (fnd_log.LEVEL_STATEMENT >=
2864: fnd_log.g_current_runtime_level) then
2865: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2866: c_log_head || l_api_name || '.step3loop',
2867: ' l_set_predicates: ' || l_set_predicates);

Line 2864: fnd_log.g_current_runtime_level) then

2860: ' ) AND ('||
2861: l_pred ||
2862: ' )) OR ', 1, c_pred_buf_size);
2863: if (fnd_log.LEVEL_STATEMENT >=
2864: fnd_log.g_current_runtime_level) then
2865: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2866: c_log_head || l_api_name || '.step3loop',
2867: ' l_set_predicates: ' || l_set_predicates);
2868: end if;

Line 2865: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

2861: l_pred ||
2862: ' )) OR ', 1, c_pred_buf_size);
2863: if (fnd_log.LEVEL_STATEMENT >=
2864: fnd_log.g_current_runtime_level) then
2865: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2866: c_log_head || l_api_name || '.step3loop',
2867: ' l_set_predicates: ' || l_set_predicates);
2868: end if;
2869: END LOOP;

Line 2880: if (fnd_log.LEVEL_STATEMENT >=

2876: /* Upgrade and substitute predicate */
2877: l_pred := upgrade_predicate(
2878: instance_set_grants_rec.predicate);
2879:
2880: if (fnd_log.LEVEL_STATEMENT >=
2881: fnd_log.g_current_runtime_level) then
2882: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2883: c_log_head || l_api_name || '.upgd_pred',
2884: 'l_pred:'||l_pred);

Line 2881: fnd_log.g_current_runtime_level) then

2877: l_pred := upgrade_predicate(
2878: instance_set_grants_rec.predicate);
2879:
2880: if (fnd_log.LEVEL_STATEMENT >=
2881: fnd_log.g_current_runtime_level) then
2882: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2883: c_log_head || l_api_name || '.upgd_pred',
2884: 'l_pred:'||l_pred);
2885: end if;

Line 2882: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

2878: instance_set_grants_rec.predicate);
2879:
2880: if (fnd_log.LEVEL_STATEMENT >=
2881: fnd_log.g_current_runtime_level) then
2882: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2883: c_log_head || l_api_name || '.upgd_pred',
2884: 'l_pred:'||l_pred);
2885: end if;
2886:

Line 2897: if (fnd_log.LEVEL_STATEMENT >=

2893: l_pred := substitute_predicate(
2894: l_pred,
2895: p_table_alias);
2896: end if;
2897: if (fnd_log.LEVEL_STATEMENT >=
2898: fnd_log.g_current_runtime_level) then
2899: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2900: c_log_head || l_api_name || '.subbed_pred',
2901: 'l_pred:'||l_pred);

Line 2898: fnd_log.g_current_runtime_level) then

2894: l_pred,
2895: p_table_alias);
2896: end if;
2897: if (fnd_log.LEVEL_STATEMENT >=
2898: fnd_log.g_current_runtime_level) then
2899: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2900: c_log_head || l_api_name || '.subbed_pred',
2901: 'l_pred:'||l_pred);
2902: end if;

Line 2899: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

2895: p_table_alias);
2896: end if;
2897: if (fnd_log.LEVEL_STATEMENT >=
2898: fnd_log.g_current_runtime_level) then
2899: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2900: c_log_head || l_api_name || '.subbed_pred',
2901: 'l_pred:'||l_pred);
2902: end if;
2903:

Line 2910: if (fnd_log.LEVEL_STATEMENT >=

2906: instance_set_grants_rec.instance_set_id ||
2907: ' ) AND ('||
2908: l_pred ||
2909: ' )) OR ', 1, c_pred_buf_size);
2910: if (fnd_log.LEVEL_STATEMENT >=
2911: fnd_log.g_current_runtime_level) then
2912: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2913: c_log_head || l_api_name || '.step3loop',
2914: ' l_set_predicates: ' || l_set_predicates);

Line 2911: fnd_log.g_current_runtime_level) then

2907: ' ) AND ('||
2908: l_pred ||
2909: ' )) OR ', 1, c_pred_buf_size);
2910: if (fnd_log.LEVEL_STATEMENT >=
2911: fnd_log.g_current_runtime_level) then
2912: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2913: c_log_head || l_api_name || '.step3loop',
2914: ' l_set_predicates: ' || l_set_predicates);
2915: end if;

Line 2912: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

2908: l_pred ||
2909: ' )) OR ', 1, c_pred_buf_size);
2910: if (fnd_log.LEVEL_STATEMENT >=
2911: fnd_log.g_current_runtime_level) then
2912: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2913: c_log_head || l_api_name || '.step3loop',
2914: ' l_set_predicates: ' || l_set_predicates);
2915: end if;
2916: END LOOP;

Line 2930: if (fnd_log.LEVEL_STATEMENT >=

2926: /* Upgrade and substitute predicate */
2927: l_pred := upgrade_predicate(
2928: instance_set_grants_guest_rec.predicate);
2929:
2930: if (fnd_log.LEVEL_STATEMENT >=
2931: fnd_log.g_current_runtime_level) then
2932: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2933: c_log_head || l_api_name || '.upgd_pred',
2934: 'l_pred:'||l_pred);

Line 2931: fnd_log.g_current_runtime_level) then

2927: l_pred := upgrade_predicate(
2928: instance_set_grants_guest_rec.predicate);
2929:
2930: if (fnd_log.LEVEL_STATEMENT >=
2931: fnd_log.g_current_runtime_level) then
2932: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2933: c_log_head || l_api_name || '.upgd_pred',
2934: 'l_pred:'||l_pred);
2935: end if;

Line 2932: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

2928: instance_set_grants_guest_rec.predicate);
2929:
2930: if (fnd_log.LEVEL_STATEMENT >=
2931: fnd_log.g_current_runtime_level) then
2932: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2933: c_log_head || l_api_name || '.upgd_pred',
2934: 'l_pred:'||l_pred);
2935: end if;
2936:

Line 2947: if (fnd_log.LEVEL_STATEMENT >=

2943: l_pred := substitute_predicate(
2944: l_pred,
2945: p_table_alias);
2946: end if;
2947: if (fnd_log.LEVEL_STATEMENT >=
2948: fnd_log.g_current_runtime_level) then
2949: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2950: c_log_head || l_api_name || '.subbed_pred',
2951: 'l_pred:'||l_pred);

Line 2948: fnd_log.g_current_runtime_level) then

2944: l_pred,
2945: p_table_alias);
2946: end if;
2947: if (fnd_log.LEVEL_STATEMENT >=
2948: fnd_log.g_current_runtime_level) then
2949: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2950: c_log_head || l_api_name || '.subbed_pred',
2951: 'l_pred:'||l_pred);
2952: end if;

Line 2949: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

2945: p_table_alias);
2946: end if;
2947: if (fnd_log.LEVEL_STATEMENT >=
2948: fnd_log.g_current_runtime_level) then
2949: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2950: c_log_head || l_api_name || '.subbed_pred',
2951: 'l_pred:'||l_pred);
2952: end if;
2953:

Line 2960: if (fnd_log.LEVEL_STATEMENT >=

2956: instance_set_grants_guest_rec.instance_set_id ||
2957: ' ) AND ('||
2958: l_pred ||
2959: ' )) OR ', 1, c_pred_buf_size);
2960: if (fnd_log.LEVEL_STATEMENT >=
2961: fnd_log.g_current_runtime_level) then
2962: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2963: c_log_head || l_api_name || '.step3loop',
2964: ' l_set_predicates: ' || l_set_predicates);

Line 2961: fnd_log.g_current_runtime_level) then

2957: ' ) AND ('||
2958: l_pred ||
2959: ' )) OR ', 1, c_pred_buf_size);
2960: if (fnd_log.LEVEL_STATEMENT >=
2961: fnd_log.g_current_runtime_level) then
2962: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2963: c_log_head || l_api_name || '.step3loop',
2964: ' l_set_predicates: ' || l_set_predicates);
2965: end if;

Line 2962: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

2958: l_pred ||
2959: ' )) OR ', 1, c_pred_buf_size);
2960: if (fnd_log.LEVEL_STATEMENT >=
2961: fnd_log.g_current_runtime_level) then
2962: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2963: c_log_head || l_api_name || '.step3loop',
2964: ' l_set_predicates: ' || l_set_predicates);
2965: end if;
2966: END LOOP;

Line 2984: if (fnd_log.LEVEL_STATEMENT >=

2980: l_aggregate_predicate ||
2981: ' ( (gnt.instance_type = ''SET'') AND ( ' ||
2982: l_set_predicates ||'))',
2983: 1, c_pred_buf_size);
2984: if (fnd_log.LEVEL_STATEMENT >=
2985: fnd_log.g_current_runtime_level) then
2986: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2987: c_log_head || l_api_name || '.setpreds',
2988: ' l_aggregate_predicate: ' || l_aggregate_predicate);

Line 2985: fnd_log.g_current_runtime_level) then

2981: ' ( (gnt.instance_type = ''SET'') AND ( ' ||
2982: l_set_predicates ||'))',
2983: 1, c_pred_buf_size);
2984: if (fnd_log.LEVEL_STATEMENT >=
2985: fnd_log.g_current_runtime_level) then
2986: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2987: c_log_head || l_api_name || '.setpreds',
2988: ' l_aggregate_predicate: ' || l_aggregate_predicate);
2989: end if;

Line 2986: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

2982: l_set_predicates ||'))',
2983: 1, c_pred_buf_size);
2984: if (fnd_log.LEVEL_STATEMENT >=
2985: fnd_log.g_current_runtime_level) then
2986: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2987: c_log_head || l_api_name || '.setpreds',
2988: ' l_aggregate_predicate: ' || l_aggregate_predicate);
2989: end if;
2990: ELSE

Line 2995: if (fnd_log.LEVEL_PROCEDURE >=

2991: /* If there weren't any instance sets and not instance mode,
2992: /* predicate will not return any rows, so just return '1=2' */
2993: if (l_instance_flag = FALSE) then
2994: x_predicate := '(1=2)';
2995: if (fnd_log.LEVEL_PROCEDURE >=
2996: fnd_log.g_current_runtime_level) then
2997: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2998: c_log_head || l_api_name || '.end_no_row_pred',
2999: 'x_predicate: '|| x_predicate ||

Line 2996: fnd_log.g_current_runtime_level) then

2992: /* predicate will not return any rows, so just return '1=2' */
2993: if (l_instance_flag = FALSE) then
2994: x_predicate := '(1=2)';
2995: if (fnd_log.LEVEL_PROCEDURE >=
2996: fnd_log.g_current_runtime_level) then
2997: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2998: c_log_head || l_api_name || '.end_no_row_pred',
2999: 'x_predicate: '|| x_predicate ||
3000: ', x_return_status:'||x_return_status);

Line 2997: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

2993: if (l_instance_flag = FALSE) then
2994: x_predicate := '(1=2)';
2995: if (fnd_log.LEVEL_PROCEDURE >=
2996: fnd_log.g_current_runtime_level) then
2997: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2998: c_log_head || l_api_name || '.end_no_row_pred',
2999: 'x_predicate: '|| x_predicate ||
3000: ', x_return_status:'||x_return_status);
3001: end if;

Line 3065: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then

3061: FND_MESSAGE.SET_TOKEN('REASON',
3062: 'The predicate was longer than the database VPD limit of '||
3063: to_char(g_vpd_buf_limit)||' bytes for the predicate. ');
3064:
3065: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
3066: fnd_log.message(FND_LOG.LEVEL_PROCEDURE,
3067: c_log_head || l_api_name || '.end',
3068: FALSE);
3069: end if;

Line 3066: fnd_log.message(FND_LOG.LEVEL_PROCEDURE,

3062: 'The predicate was longer than the database VPD limit of '||
3063: to_char(g_vpd_buf_limit)||' bytes for the predicate. ');
3064:
3065: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
3066: fnd_log.message(FND_LOG.LEVEL_PROCEDURE,
3067: c_log_head || l_api_name || '.end',
3068: FALSE);
3069: end if;
3070: x_return_status := 'L'; /* Indicate Error */

Line 3091: if (fnd_log.LEVEL_EXCEPTION >=

3087: c_pkg_name || '.'|| l_api_name);
3088: fnd_message.set_token('ERRNO', SQLCODE);
3089: fnd_message.set_token('REASON', SQLERRM);
3090:
3091: if (fnd_log.LEVEL_EXCEPTION >=
3092: fnd_log.g_current_runtime_level) then
3093: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3094: c_log_head || l_api_name || '.other_err',
3095: FALSE);

Line 3092: fnd_log.g_current_runtime_level) then

3088: fnd_message.set_token('ERRNO', SQLCODE);
3089: fnd_message.set_token('REASON', SQLERRM);
3090:
3091: if (fnd_log.LEVEL_EXCEPTION >=
3092: fnd_log.g_current_runtime_level) then
3093: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3094: c_log_head || l_api_name || '.other_err',
3095: FALSE);
3096: end if;

Line 3093: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

3089: fnd_message.set_token('REASON', SQLERRM);
3090:
3091: if (fnd_log.LEVEL_EXCEPTION >=
3092: fnd_log.g_current_runtime_level) then
3093: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3094: c_log_head || l_api_name || '.other_err',
3095: FALSE);
3096: end if;
3097: x_return_status := 'U';

Line 3098: if (fnd_log.LEVEL_PROCEDURE >=

3094: c_log_head || l_api_name || '.other_err',
3095: FALSE);
3096: end if;
3097: x_return_status := 'U';
3098: if (fnd_log.LEVEL_PROCEDURE >=
3099: fnd_log.g_current_runtime_level) then
3100: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
3101: c_log_head || l_api_name || '.end_after_other',
3102: 'x_predicate: '|| x_predicate ||

Line 3099: fnd_log.g_current_runtime_level) then

3095: FALSE);
3096: end if;
3097: x_return_status := 'U';
3098: if (fnd_log.LEVEL_PROCEDURE >=
3099: fnd_log.g_current_runtime_level) then
3100: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
3101: c_log_head || l_api_name || '.end_after_other',
3102: 'x_predicate: '|| x_predicate ||
3103: ', x_return_status:'||x_return_status);

Line 3100: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

3096: end if;
3097: x_return_status := 'U';
3098: if (fnd_log.LEVEL_PROCEDURE >=
3099: fnd_log.g_current_runtime_level) then
3100: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
3101: c_log_head || l_api_name || '.end_after_other',
3102: 'x_predicate: '|| x_predicate ||
3103: ', x_return_status:'||x_return_status);
3104: end if;

Line 3726: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then

3722: l_function_id number := -2;
3723:
3724: BEGIN
3725:
3726: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
3727: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
3728: c_log_head || l_api_name || '.begin',
3729: c_pkg_name || '.' ||l_api_name|| '(' ||
3730: 'p_api_version=>'|| to_char(p_api_version) ||

Line 3727: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

3723:
3724: BEGIN
3725:
3726: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
3727: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
3728: c_log_head || l_api_name || '.begin',
3729: c_pkg_name || '.' ||l_api_name|| '(' ||
3730: 'p_api_version=>'|| to_char(p_api_version) ||
3731: ', p_function=>'|| p_function ||

Line 3755: if (fnd_log.LEVEL_EXCEPTION >=

3751: fnd_message.set_token('REASON',
3752: 'Unsupported version '|| to_char(p_api_version)||
3753: ' passed to API; expecting version '||
3754: to_char(l_api_version));
3755: if (fnd_log.LEVEL_EXCEPTION >=
3756: fnd_log.g_current_runtime_level) then
3757: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3758: c_log_head || l_api_name || '.end_bad_api_ver',
3759: FALSE);

Line 3756: fnd_log.g_current_runtime_level) then

3752: 'Unsupported version '|| to_char(p_api_version)||
3753: ' passed to API; expecting version '||
3754: to_char(l_api_version));
3755: if (fnd_log.LEVEL_EXCEPTION >=
3756: fnd_log.g_current_runtime_level) then
3757: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3758: c_log_head || l_api_name || '.end_bad_api_ver',
3759: FALSE);
3760: end if;

Line 3757: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

3753: ' passed to API; expecting version '||
3754: to_char(l_api_version));
3755: if (fnd_log.LEVEL_EXCEPTION >=
3756: fnd_log.g_current_runtime_level) then
3757: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3758: c_log_head || l_api_name || '.end_bad_api_ver',
3759: FALSE);
3760: end if;
3761: x_return_status := 'U'; /* Unexpected Error */

Line 3768: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

3764:
3765: /* default the username if necessary. */
3766: if (p_user_name is NULL) then
3767: l_user_name := SYS_CONTEXT('FND','USER_NAME');
3768: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
3769: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
3770: c_log_head || l_api_name || '.null_username',
3771: 'l_user_name= '||l_user_name);
3772: end if;

Line 3769: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

3765: /* default the username if necessary. */
3766: if (p_user_name is NULL) then
3767: l_user_name := SYS_CONTEXT('FND','USER_NAME');
3768: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
3769: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
3770: c_log_head || l_api_name || '.null_username',
3771: 'l_user_name= '||l_user_name);
3772: end if;
3773: else

Line 3774: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

3770: c_log_head || l_api_name || '.null_username',
3771: 'l_user_name= '||l_user_name);
3772: end if;
3773: else
3774: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
3775: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
3776: c_log_head || l_api_name || '.passed_uname',
3777: 'l_user_name= '||l_user_name);
3778: end if;

Line 3775: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

3771: 'l_user_name= '||l_user_name);
3772: end if;
3773: else
3774: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
3775: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
3776: c_log_head || l_api_name || '.passed_uname',
3777: 'l_user_name= '||l_user_name);
3778: end if;
3779:

Line 3810: if (fnd_log.LEVEL_EXCEPTION >=

3806: 'a bug against the product that owns the call to this '||
3807: 'routine, which is likely the owner of the object that '||
3808: 'was passed to this routine: '||
3809: p_object_name);
3810: if (fnd_log.LEVEL_EXCEPTION >=
3811: fnd_log.g_current_runtime_level) then
3812: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3813: c_log_head || l_api_name || '.end_depr_param',
3814: FALSE);

Line 3811: fnd_log.g_current_runtime_level) then

3807: 'routine, which is likely the owner of the object that '||
3808: 'was passed to this routine: '||
3809: p_object_name);
3810: if (fnd_log.LEVEL_EXCEPTION >=
3811: fnd_log.g_current_runtime_level) then
3812: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3813: c_log_head || l_api_name || '.end_depr_param',
3814: FALSE);
3815: end if;

Line 3812: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

3808: 'was passed to this routine: '||
3809: p_object_name);
3810: if (fnd_log.LEVEL_EXCEPTION >=
3811: fnd_log.g_current_runtime_level) then
3812: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3813: c_log_head || l_api_name || '.end_depr_param',
3814: FALSE);
3815: end if;
3816: fnd_message.raise_error;

Line 3822: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

3818: l_user_name := p_user_name;
3819: end if;
3820:
3821:
3822: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
3823: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
3824: c_log_head || l_api_name || '.b4cachechk',
3825: ' g_gsp_function: '|| g_gsp_function ||
3826: ' p_function: '|| p_function ||

Line 3823: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

3819: end if;
3820:
3821:
3822: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
3823: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
3824: c_log_head || l_api_name || '.b4cachechk',
3825: ' g_gsp_function: '|| g_gsp_function ||
3826: ' p_function: '|| p_function ||
3827: ' g_gsp_object_name: '|| g_gsp_object_name ||

Line 3877: if (fnd_log.LEVEL_EXCEPTION >=

3873: fnd_message.set_token('ROUTINE',
3874: c_pkg_name || '.'|| l_api_name);
3875: fnd_message.set_token('REASON',
3876: 'The parameter p_object_name can not be NULL.');
3877: if (fnd_log.LEVEL_EXCEPTION >=
3878: fnd_log.g_current_runtime_level) then
3879: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3880: c_log_head || l_api_name || '.end_null_obj',
3881: FALSE);

Line 3878: fnd_log.g_current_runtime_level) then

3874: c_pkg_name || '.'|| l_api_name);
3875: fnd_message.set_token('REASON',
3876: 'The parameter p_object_name can not be NULL.');
3877: if (fnd_log.LEVEL_EXCEPTION >=
3878: fnd_log.g_current_runtime_level) then
3879: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3880: c_log_head || l_api_name || '.end_null_obj',
3881: FALSE);
3882: end if;

Line 3879: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

3875: fnd_message.set_token('REASON',
3876: 'The parameter p_object_name can not be NULL.');
3877: if (fnd_log.LEVEL_EXCEPTION >=
3878: fnd_log.g_current_runtime_level) then
3879: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3880: c_log_head || l_api_name || '.end_null_obj',
3881: FALSE);
3882: end if;
3883: x_return_status := 'U';

Line 3895: if (fnd_log.LEVEL_EXCEPTION >=

3891: c_pkg_name || '.'|| l_api_name);
3892: fnd_message.set_token('REASON',
3893: 'The parameter value p_object_name is not a valid object.'||
3894: ' p_object_name:'||p_object_name);
3895: if (fnd_log.LEVEL_EXCEPTION >=
3896: fnd_log.g_current_runtime_level) then
3897: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3898: c_log_head || l_api_name || '.end_bad_obj',
3899: FALSE);

Line 3896: fnd_log.g_current_runtime_level) then

3892: fnd_message.set_token('REASON',
3893: 'The parameter value p_object_name is not a valid object.'||
3894: ' p_object_name:'||p_object_name);
3895: if (fnd_log.LEVEL_EXCEPTION >=
3896: fnd_log.g_current_runtime_level) then
3897: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3898: c_log_head || l_api_name || '.end_bad_obj',
3899: FALSE);
3900: end if;

Line 3897: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

3893: 'The parameter value p_object_name is not a valid object.'||
3894: ' p_object_name:'||p_object_name);
3895: if (fnd_log.LEVEL_EXCEPTION >=
3896: fnd_log.g_current_runtime_level) then
3897: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3898: c_log_head || l_api_name || '.end_bad_obj',
3899: FALSE);
3900: end if;
3901: x_return_status := 'U';

Line 3916: if (fnd_log.LEVEL_EXCEPTION >=

3912: c_pkg_name || '.'|| l_api_name);
3913: fnd_message.set_token('REASON',
3914: 'The parameter value p_function is not a valid function name.'||
3915: ' p_function:'||p_function);
3916: if (fnd_log.LEVEL_EXCEPTION >=
3917: fnd_log.g_current_runtime_level) then
3918: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3919: c_log_head || l_api_name || '.end_bad_func',
3920: FALSE);

Line 3917: fnd_log.g_current_runtime_level) then

3913: fnd_message.set_token('REASON',
3914: 'The parameter value p_function is not a valid function name.'||
3915: ' p_function:'||p_function);
3916: if (fnd_log.LEVEL_EXCEPTION >=
3917: fnd_log.g_current_runtime_level) then
3918: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3919: c_log_head || l_api_name || '.end_bad_func',
3920: FALSE);
3921: end if;

Line 3918: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

3914: 'The parameter value p_function is not a valid function name.'||
3915: ' p_function:'||p_function);
3916: if (fnd_log.LEVEL_EXCEPTION >=
3917: fnd_log.g_current_runtime_level) then
3918: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3919: c_log_head || l_api_name || '.end_bad_func',
3920: FALSE);
3921: end if;
3922: x_return_status := 'U';

Line 3980: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then

3976: x_return_status := g_gsp_return_status;
3977: x_object_id := g_gsp_object_id;
3978: x_function_id := g_gsp_function_id;
3979: x_bind_order := g_gsp_bind_order;
3980: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
3981: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
3982: c_log_head || l_api_name || '.end_cachehit',
3983: 'x_predicate: '|| x_predicate ||
3984: ', x_return_status:'||x_return_status||

Line 3981: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

3977: x_object_id := g_gsp_object_id;
3978: x_function_id := g_gsp_function_id;
3979: x_bind_order := g_gsp_bind_order;
3980: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
3981: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
3982: c_log_head || l_api_name || '.end_cachehit',
3983: 'x_predicate: '|| x_predicate ||
3984: ', x_return_status:'||x_return_status||
3985: ', x_object_id:'||x_object_id||

Line 4003: if (fnd_log.LEVEL_EXCEPTION >=

3999: fnd_message.set_token('ROUTINE',
4000: c_pkg_name || '.'|| l_api_name);
4001: fnd_message.set_token('REASON',
4002: 'Unsupported p_statement_type: '|| p_statement_type);
4003: if (fnd_log.LEVEL_EXCEPTION >=
4004: fnd_log.g_current_runtime_level) then
4005: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
4006: c_log_head || l_api_name || '.end_bad_stm_typ',
4007: FALSE);

Line 4004: fnd_log.g_current_runtime_level) then

4000: c_pkg_name || '.'|| l_api_name);
4001: fnd_message.set_token('REASON',
4002: 'Unsupported p_statement_type: '|| p_statement_type);
4003: if (fnd_log.LEVEL_EXCEPTION >=
4004: fnd_log.g_current_runtime_level) then
4005: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
4006: c_log_head || l_api_name || '.end_bad_stm_typ',
4007: FALSE);
4008: end if;

Line 4005: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

4001: fnd_message.set_token('REASON',
4002: 'Unsupported p_statement_type: '|| p_statement_type);
4003: if (fnd_log.LEVEL_EXCEPTION >=
4004: fnd_log.g_current_runtime_level) then
4005: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
4006: c_log_head || l_api_name || '.end_bad_stm_typ',
4007: FALSE);
4008: end if;
4009: x_return_status := 'U'; /* Unexpected Error */

Line 4019: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

4015: if (FND_FUNCTION.G_ALREADY_FAST_COMPILED <> 'T') then
4016: FND_FUNCTION.FAST_COMPILE;
4017: end if;
4018:
4019: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
4020: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4021: c_log_head || l_api_name || '.step1start',
4022: 'p_grant_instance_type:'||p_grant_instance_type);
4023: end if;

Line 4020: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4016: FND_FUNCTION.FAST_COMPILE;
4017: end if;
4018:
4019: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
4020: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4021: c_log_head || l_api_name || '.step1start',
4022: 'p_grant_instance_type:'||p_grant_instance_type);
4023: end if;
4024:

Line 4056: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then

4052: 'The user_name passed or defaulted is not a valid user_name '||
4053: 'in wf_user_roles. '||
4054: 'Invalid user_name: '||l_user_name ||
4055: ' Passed p_user_name: '||p_user_name);
4056: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
4057: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
4058: c_log_head || l_api_name || '.end_no_wf_user_role',
4059: FALSE);
4060: end if;

Line 4057: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

4053: 'in wf_user_roles. '||
4054: 'Invalid user_name: '||l_user_name ||
4055: ' Passed p_user_name: '||p_user_name);
4056: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
4057: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
4058: c_log_head || l_api_name || '.end_no_wf_user_role',
4059: FALSE);
4060: end if;
4061:

Line 4069: if (fnd_log.LEVEL_STATEMENT >=

4065: end if;
4066:
4067: /* Set up flags depending on which mode we are running in. */
4068: IF (p_grant_instance_type = C_TYPE_INSTANCE) THEN
4069: if (fnd_log.LEVEL_STATEMENT >=
4070: fnd_log.g_current_runtime_level) then
4071: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4072: c_log_head || l_api_name || '.chk_instance',
4073: ' l_instance_set_flag := FALSE ');

Line 4070: fnd_log.g_current_runtime_level) then

4066:
4067: /* Set up flags depending on which mode we are running in. */
4068: IF (p_grant_instance_type = C_TYPE_INSTANCE) THEN
4069: if (fnd_log.LEVEL_STATEMENT >=
4070: fnd_log.g_current_runtime_level) then
4071: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4072: c_log_head || l_api_name || '.chk_instance',
4073: ' l_instance_set_flag := FALSE ');
4074: end if;

Line 4071: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4067: /* Set up flags depending on which mode we are running in. */
4068: IF (p_grant_instance_type = C_TYPE_INSTANCE) THEN
4069: if (fnd_log.LEVEL_STATEMENT >=
4070: fnd_log.g_current_runtime_level) then
4071: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4072: c_log_head || l_api_name || '.chk_instance',
4073: ' l_instance_set_flag := FALSE ');
4074: end if;
4075: l_instance_set_flag:= FALSE;

Line 4077: if (fnd_log.LEVEL_STATEMENT >=

4073: ' l_instance_set_flag := FALSE ');
4074: end if;
4075: l_instance_set_flag:= FALSE;
4076: ELSIF (p_grant_instance_type = C_TYPE_SET) THEN
4077: if (fnd_log.LEVEL_STATEMENT >=
4078: fnd_log.g_current_runtime_level) then
4079: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4080: c_log_head || l_api_name || '.chk_set',
4081: ' l_instance_flag := FALSE ');

Line 4078: fnd_log.g_current_runtime_level) then

4074: end if;
4075: l_instance_set_flag:= FALSE;
4076: ELSIF (p_grant_instance_type = C_TYPE_SET) THEN
4077: if (fnd_log.LEVEL_STATEMENT >=
4078: fnd_log.g_current_runtime_level) then
4079: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4080: c_log_head || l_api_name || '.chk_set',
4081: ' l_instance_flag := FALSE ');
4082: end if;

Line 4079: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4075: l_instance_set_flag:= FALSE;
4076: ELSIF (p_grant_instance_type = C_TYPE_SET) THEN
4077: if (fnd_log.LEVEL_STATEMENT >=
4078: fnd_log.g_current_runtime_level) then
4079: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4080: c_log_head || l_api_name || '.chk_set',
4081: ' l_instance_flag := FALSE ');
4082: end if;
4083: l_instance_flag:= FALSE;

Line 4085: if (fnd_log.LEVEL_STATEMENT >=

4081: ' l_instance_flag := FALSE ');
4082: end if;
4083: l_instance_flag:= FALSE;
4084: ELSIF (p_grant_instance_type = 'UNIVERSAL') THEN
4085: if (fnd_log.LEVEL_STATEMENT >=
4086: fnd_log.g_current_runtime_level) then
4087: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4088: c_log_head || l_api_name || '.chk_universal',
4089: ' ');

Line 4086: fnd_log.g_current_runtime_level) then

4082: end if;
4083: l_instance_flag:= FALSE;
4084: ELSIF (p_grant_instance_type = 'UNIVERSAL') THEN
4085: if (fnd_log.LEVEL_STATEMENT >=
4086: fnd_log.g_current_runtime_level) then
4087: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4088: c_log_head || l_api_name || '.chk_universal',
4089: ' ');
4090: end if;

Line 4087: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4083: l_instance_flag:= FALSE;
4084: ELSIF (p_grant_instance_type = 'UNIVERSAL') THEN
4085: if (fnd_log.LEVEL_STATEMENT >=
4086: fnd_log.g_current_runtime_level) then
4087: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4088: c_log_head || l_api_name || '.chk_universal',
4089: ' ');
4090: end if;
4091: END IF;

Line 4108: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then

4104: fnd_message.set_token('ROUTINE',
4105: c_pkg_name || '.'|| l_api_name);
4106: fnd_message.set_token('REASON',
4107: 'The parameter p_object_name can not be ''GLOBAL''. ');
4108: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
4109: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
4110: c_log_head || l_api_name || '.end_glob_obj',
4111: FALSE);
4112: end if;

Line 4109: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

4105: c_pkg_name || '.'|| l_api_name);
4106: fnd_message.set_token('REASON',
4107: 'The parameter p_object_name can not be ''GLOBAL''. ');
4108: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
4109: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
4110: c_log_head || l_api_name || '.end_glob_obj',
4111: FALSE);
4112: end if;
4113: x_return_status := 'U';

Line 4131: if (fnd_log.LEVEL_PROCEDURE >=

4127: l_db_object_name,
4128: p_table_alias,
4129: 'GNT');
4130: if (x_return_status <> 'T') then
4131: if (fnd_log.LEVEL_PROCEDURE >=
4132: fnd_log.g_current_runtime_level) then
4133: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
4134: c_log_head || l_api_name || '.end_pk_info_err',
4135: 'returning status: '|| x_return_status);

Line 4132: fnd_log.g_current_runtime_level) then

4128: p_table_alias,
4129: 'GNT');
4130: if (x_return_status <> 'T') then
4131: if (fnd_log.LEVEL_PROCEDURE >=
4132: fnd_log.g_current_runtime_level) then
4133: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
4134: c_log_head || l_api_name || '.end_pk_info_err',
4135: 'returning status: '|| x_return_status);
4136: end if;

Line 4133: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

4129: 'GNT');
4130: if (x_return_status <> 'T') then
4131: if (fnd_log.LEVEL_PROCEDURE >=
4132: fnd_log.g_current_runtime_level) then
4133: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
4134: c_log_head || l_api_name || '.end_pk_info_err',
4135: 'returning status: '|| x_return_status);
4136: end if;
4137: /* There will be a message on the msg dict stack. */

Line 4420: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

4416: /* in scope, so just return 1=1 */
4417: if(l_global_instance_type = TRUE) then
4418: l_aggregate_predicate := '1=1';
4419: x_return_status := 'T';
4420: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
4421: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4422: c_log_head || l_api_name || '.11global_inst',
4423: 'l_aggregate_predicate: '|| l_aggregate_predicate ||
4424: ', x_return_status:'||x_return_status);

Line 4421: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4417: if(l_global_instance_type = TRUE) then
4418: l_aggregate_predicate := '1=1';
4419: x_return_status := 'T';
4420: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
4421: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4422: c_log_head || l_api_name || '.11global_inst',
4423: 'l_aggregate_predicate: '|| l_aggregate_predicate ||
4424: ', x_return_status:'||x_return_status);
4425: end if;

Line 4437: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

4433: l_inst_instance_type = FALSE and
4434: l_set_instance_type = FALSE) then
4435: l_aggregate_predicate := '1=2';
4436: x_return_status := 'T';
4437: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
4438: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4439: c_log_head || l_api_name || '.12no_inst',
4440: 'l_aggregate_predicate: '|| l_aggregate_predicate ||
4441: ', x_return_status:'||x_return_status);

Line 4438: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4434: l_set_instance_type = FALSE) then
4435: l_aggregate_predicate := '1=2';
4436: x_return_status := 'T';
4437: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
4438: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4439: c_log_head || l_api_name || '.12no_inst',
4440: 'l_aggregate_predicate: '|| l_aggregate_predicate ||
4441: ', x_return_status:'||x_return_status);
4442: end if;

Line 4452: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then

4448: if(l_inst_instance_type = TRUE and
4449: l_inst_group_grantee_type = FALSE and
4450: l_inst_global_grantee_type = FALSE) then
4451: l_set_instance_type := TRUE;
4452: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
4453: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
4454: c_log_head || l_api_name || '.err_inst_no_gnt_typ',
4455: 'x_predicate: '|| x_predicate);
4456: end if;

Line 4453: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

4449: l_inst_group_grantee_type = FALSE and
4450: l_inst_global_grantee_type = FALSE) then
4451: l_set_instance_type := TRUE;
4452: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
4453: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
4454: c_log_head || l_api_name || '.err_inst_no_gnt_typ',
4455: 'x_predicate: '|| x_predicate);
4456: end if;
4457: end if;

Line 4462: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

4458:
4459: /* Build up the instance set part of the predicate */
4460: l_last_pred := '*NO_PRED*';
4461: if(l_set_instance_type = TRUE) then
4462: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
4463: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4464: c_log_head || l_api_name || '.in_set_instyp',
4465: '.');
4466: end if;

Line 4463: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4459: /* Build up the instance set part of the predicate */
4460: l_last_pred := '*NO_PRED*';
4461: if(l_set_instance_type = TRUE) then
4462: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
4463: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4464: c_log_head || l_api_name || '.in_set_instyp',
4465: '.');
4466: end if;
4467:

Line 4487: if (fnd_log.LEVEL_STATEMENT >=

4483: OPEN isg_grp_glob_fn_c ( l_user_name,
4484: l_function_id,
4485: l_object_id);
4486: l_grp_glob_fn := TRUE;
4487: if (fnd_log.LEVEL_STATEMENT >=
4488: fnd_log.g_current_runtime_level) then
4489: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4490: c_log_head || l_api_name || '.open_grp_glob_fn_cursor',
4491: ' open');

Line 4488: fnd_log.g_current_runtime_level) then

4484: l_function_id,
4485: l_object_id);
4486: l_grp_glob_fn := TRUE;
4487: if (fnd_log.LEVEL_STATEMENT >=
4488: fnd_log.g_current_runtime_level) then
4489: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4490: c_log_head || l_api_name || '.open_grp_glob_fn_cursor',
4491: ' open');
4492: end if;

Line 4489: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4485: l_object_id);
4486: l_grp_glob_fn := TRUE;
4487: if (fnd_log.LEVEL_STATEMENT >=
4488: fnd_log.g_current_runtime_level) then
4489: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4490: c_log_head || l_api_name || '.open_grp_glob_fn_cursor',
4491: ' open');
4492: end if;
4493: elsif( l_set_group_grantee_type

Line 4501: if (fnd_log.LEVEL_STATEMENT >=

4497: --- Fix Non Backward change made for universal person support
4498: /*OPEN isg_grp_glob_nofn_c ( l_user_name,
4499: l_object_id);
4500: l_grp_glob_nofn := TRUE;
4501: if (fnd_log.LEVEL_STATEMENT >=
4502: fnd_log.g_current_runtime_level) then
4503: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4504: c_log_head || l_api_name || '.open_grp_glob_nofn_cursor',
4505: ' open');

Line 4502: fnd_log.g_current_runtime_level) then

4498: /*OPEN isg_grp_glob_nofn_c ( l_user_name,
4499: l_object_id);
4500: l_grp_glob_nofn := TRUE;
4501: if (fnd_log.LEVEL_STATEMENT >=
4502: fnd_log.g_current_runtime_level) then
4503: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4504: c_log_head || l_api_name || '.open_grp_glob_nofn_cursor',
4505: ' open');
4506: end if;*/

Line 4503: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4499: l_object_id);
4500: l_grp_glob_nofn := TRUE;
4501: if (fnd_log.LEVEL_STATEMENT >=
4502: fnd_log.g_current_runtime_level) then
4503: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4504: c_log_head || l_api_name || '.open_grp_glob_nofn_cursor',
4505: ' open');
4506: end if;*/
4507: if (colon <> 0) then

Line 4511: if (fnd_log.LEVEL_STATEMENT >=

4507: if (colon <> 0) then
4508: OPEN isg_grp_glob_nofn_bkwd_c ( l_user_name,
4509: l_object_id);
4510: l_grp_glob_nofn := TRUE;
4511: if (fnd_log.LEVEL_STATEMENT >=
4512: fnd_log.g_current_runtime_level) then
4513: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4514: c_log_head || l_api_name ||
4515: '.open_grp_glob_nofn_bkwd_cursor',

Line 4512: fnd_log.g_current_runtime_level) then

4508: OPEN isg_grp_glob_nofn_bkwd_c ( l_user_name,
4509: l_object_id);
4510: l_grp_glob_nofn := TRUE;
4511: if (fnd_log.LEVEL_STATEMENT >=
4512: fnd_log.g_current_runtime_level) then
4513: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4514: c_log_head || l_api_name ||
4515: '.open_grp_glob_nofn_bkwd_cursor',
4516: ' open');

Line 4513: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4509: l_object_id);
4510: l_grp_glob_nofn := TRUE;
4511: if (fnd_log.LEVEL_STATEMENT >=
4512: fnd_log.g_current_runtime_level) then
4513: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4514: c_log_head || l_api_name ||
4515: '.open_grp_glob_nofn_bkwd_cursor',
4516: ' open');
4517: end if;

Line 4522: if (fnd_log.LEVEL_STATEMENT >=

4518: else
4519: OPEN isg_grp_glob_nofn_c ( l_user_name,
4520: l_object_id);
4521: l_grp_glob_nofn := TRUE;
4522: if (fnd_log.LEVEL_STATEMENT >=
4523: fnd_log.g_current_runtime_level) then
4524: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4525: c_log_head || l_api_name || '.open_grp_glob_nofn_cursor',
4526: ' open');

Line 4523: fnd_log.g_current_runtime_level) then

4519: OPEN isg_grp_glob_nofn_c ( l_user_name,
4520: l_object_id);
4521: l_grp_glob_nofn := TRUE;
4522: if (fnd_log.LEVEL_STATEMENT >=
4523: fnd_log.g_current_runtime_level) then
4524: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4525: c_log_head || l_api_name || '.open_grp_glob_nofn_cursor',
4526: ' open');
4527: end if;

Line 4524: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4520: l_object_id);
4521: l_grp_glob_nofn := TRUE;
4522: if (fnd_log.LEVEL_STATEMENT >=
4523: fnd_log.g_current_runtime_level) then
4524: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4525: c_log_head || l_api_name || '.open_grp_glob_nofn_cursor',
4526: ' open');
4527: end if;
4528: end if;

Line 4536: if (fnd_log.LEVEL_STATEMENT >=

4532: /*OPEN isg_grp_fn_c ( l_user_name,
4533: l_function_id,
4534: l_object_id);
4535: l_grp_fn := TRUE;
4536: if (fnd_log.LEVEL_STATEMENT >=
4537: fnd_log.g_current_runtime_level) then
4538: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4539: c_log_head || l_api_name || '.open_grp_fn_cursor',
4540: ' open');

Line 4537: fnd_log.g_current_runtime_level) then

4533: l_function_id,
4534: l_object_id);
4535: l_grp_fn := TRUE;
4536: if (fnd_log.LEVEL_STATEMENT >=
4537: fnd_log.g_current_runtime_level) then
4538: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4539: c_log_head || l_api_name || '.open_grp_fn_cursor',
4540: ' open');
4541: end if;*/

Line 4538: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4534: l_object_id);
4535: l_grp_fn := TRUE;
4536: if (fnd_log.LEVEL_STATEMENT >=
4537: fnd_log.g_current_runtime_level) then
4538: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4539: c_log_head || l_api_name || '.open_grp_fn_cursor',
4540: ' open');
4541: end if;*/
4542:

Line 4548: if (fnd_log.LEVEL_STATEMENT >=

4544: OPEN isg_grp_fn_bkwd_c (l_user_name,
4545: l_function_id,
4546: l_object_id);
4547: l_grp_fn := TRUE;
4548: if (fnd_log.LEVEL_STATEMENT >=
4549: fnd_log.g_current_runtime_level) then
4550: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4551: c_log_head || l_api_name || '.open_grp_fn_bkwd_cursor',
4552: ' open');

Line 4549: fnd_log.g_current_runtime_level) then

4545: l_function_id,
4546: l_object_id);
4547: l_grp_fn := TRUE;
4548: if (fnd_log.LEVEL_STATEMENT >=
4549: fnd_log.g_current_runtime_level) then
4550: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4551: c_log_head || l_api_name || '.open_grp_fn_bkwd_cursor',
4552: ' open');
4553: end if;

Line 4550: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4546: l_object_id);
4547: l_grp_fn := TRUE;
4548: if (fnd_log.LEVEL_STATEMENT >=
4549: fnd_log.g_current_runtime_level) then
4550: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4551: c_log_head || l_api_name || '.open_grp_fn_bkwd_cursor',
4552: ' open');
4553: end if;
4554: else

Line 4559: if (fnd_log.LEVEL_STATEMENT >=

4555: OPEN isg_grp_fn_c (l_user_name,
4556: l_function_id,
4557: l_object_id);
4558: l_grp_fn := TRUE;
4559: if (fnd_log.LEVEL_STATEMENT >=
4560: fnd_log.g_current_runtime_level) then
4561: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4562: c_log_head || l_api_name || '.open_grp_fn_cursor',
4563: ' open');

Line 4560: fnd_log.g_current_runtime_level) then

4556: l_function_id,
4557: l_object_id);
4558: l_grp_fn := TRUE;
4559: if (fnd_log.LEVEL_STATEMENT >=
4560: fnd_log.g_current_runtime_level) then
4561: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4562: c_log_head || l_api_name || '.open_grp_fn_cursor',
4563: ' open');
4564: end if;

Line 4561: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4557: l_object_id);
4558: l_grp_fn := TRUE;
4559: if (fnd_log.LEVEL_STATEMENT >=
4560: fnd_log.g_current_runtime_level) then
4561: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4562: c_log_head || l_api_name || '.open_grp_fn_cursor',
4563: ' open');
4564: end if;
4565: end if;

Line 4574: if (fnd_log.LEVEL_STATEMENT >=

4570: -- Fix Non Backward change made for universal person support
4571: /*OPEN isg_grp_nofn_c ( l_user_name,
4572: l_object_id);
4573: l_grp_nofn := TRUE;
4574: if (fnd_log.LEVEL_STATEMENT >=
4575: fnd_log.g_current_runtime_level) then
4576: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4577: c_log_head || l_api_name || '.open_grp_nofn_cursor',
4578: ' open');

Line 4575: fnd_log.g_current_runtime_level) then

4571: /*OPEN isg_grp_nofn_c ( l_user_name,
4572: l_object_id);
4573: l_grp_nofn := TRUE;
4574: if (fnd_log.LEVEL_STATEMENT >=
4575: fnd_log.g_current_runtime_level) then
4576: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4577: c_log_head || l_api_name || '.open_grp_nofn_cursor',
4578: ' open');
4579: end if;*/

Line 4576: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4572: l_object_id);
4573: l_grp_nofn := TRUE;
4574: if (fnd_log.LEVEL_STATEMENT >=
4575: fnd_log.g_current_runtime_level) then
4576: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4577: c_log_head || l_api_name || '.open_grp_nofn_cursor',
4578: ' open');
4579: end if;*/
4580: if (colon <> 0) then

Line 4584: if (fnd_log.LEVEL_STATEMENT >=

4580: if (colon <> 0) then
4581: OPEN isg_grp_nofn_bkwd_c (l_user_name,
4582: l_object_id);
4583: l_grp_nofn := TRUE;
4584: if (fnd_log.LEVEL_STATEMENT >=
4585: fnd_log.g_current_runtime_level) then
4586: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4587: c_log_head || l_api_name || '.open_grp_nofn_bkwd_cursor',
4588: ' open');

Line 4585: fnd_log.g_current_runtime_level) then

4581: OPEN isg_grp_nofn_bkwd_c (l_user_name,
4582: l_object_id);
4583: l_grp_nofn := TRUE;
4584: if (fnd_log.LEVEL_STATEMENT >=
4585: fnd_log.g_current_runtime_level) then
4586: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4587: c_log_head || l_api_name || '.open_grp_nofn_bkwd_cursor',
4588: ' open');
4589: end if;

Line 4586: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4582: l_object_id);
4583: l_grp_nofn := TRUE;
4584: if (fnd_log.LEVEL_STATEMENT >=
4585: fnd_log.g_current_runtime_level) then
4586: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4587: c_log_head || l_api_name || '.open_grp_nofn_bkwd_cursor',
4588: ' open');
4589: end if;
4590: else

Line 4594: if (fnd_log.LEVEL_STATEMENT >=

4590: else
4591: OPEN isg_grp_nofn_c (l_user_name,
4592: l_object_id);
4593: l_grp_nofn := TRUE;
4594: if (fnd_log.LEVEL_STATEMENT >=
4595: fnd_log.g_current_runtime_level) then
4596: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4597: c_log_head || l_api_name || '.open_grp_nofn_cursor',
4598: ' open');

Line 4595: fnd_log.g_current_runtime_level) then

4591: OPEN isg_grp_nofn_c (l_user_name,
4592: l_object_id);
4593: l_grp_nofn := TRUE;
4594: if (fnd_log.LEVEL_STATEMENT >=
4595: fnd_log.g_current_runtime_level) then
4596: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4597: c_log_head || l_api_name || '.open_grp_nofn_cursor',
4598: ' open');
4599: end if;

Line 4596: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4592: l_object_id);
4593: l_grp_nofn := TRUE;
4594: if (fnd_log.LEVEL_STATEMENT >=
4595: fnd_log.g_current_runtime_level) then
4596: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4597: c_log_head || l_api_name || '.open_grp_nofn_cursor',
4598: ' open');
4599: end if;
4600: end if;

Line 4608: if (fnd_log.LEVEL_STATEMENT >=

4604: OPEN isg_glob_fn_c (l_user_name,
4605: l_function_id,
4606: l_object_id);
4607: l_glob_fn := TRUE;
4608: if (fnd_log.LEVEL_STATEMENT >=
4609: fnd_log.g_current_runtime_level) then
4610: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4611: c_log_head || l_api_name || '.open_glob_fn_cursor',
4612: ' open');

Line 4609: fnd_log.g_current_runtime_level) then

4605: l_function_id,
4606: l_object_id);
4607: l_glob_fn := TRUE;
4608: if (fnd_log.LEVEL_STATEMENT >=
4609: fnd_log.g_current_runtime_level) then
4610: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4611: c_log_head || l_api_name || '.open_glob_fn_cursor',
4612: ' open');
4613: end if;

Line 4610: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4606: l_object_id);
4607: l_glob_fn := TRUE;
4608: if (fnd_log.LEVEL_STATEMENT >=
4609: fnd_log.g_current_runtime_level) then
4610: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4611: c_log_head || l_api_name || '.open_glob_fn_cursor',
4612: ' open');
4613: end if;
4614: elsif(NOT l_set_group_grantee_type

Line 4620: if (fnd_log.LEVEL_STATEMENT >=

4616: AND l_function_id = -1) then
4617: OPEN isg_glob_nofn_c (l_user_name,
4618: l_object_id);
4619: l_glob_nofn := TRUE;
4620: if (fnd_log.LEVEL_STATEMENT >=
4621: fnd_log.g_current_runtime_level) then
4622: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4623: c_log_head || l_api_name || '.open_glob_nofn_cursor',
4624: ' open');

Line 4621: fnd_log.g_current_runtime_level) then

4617: OPEN isg_glob_nofn_c (l_user_name,
4618: l_object_id);
4619: l_glob_nofn := TRUE;
4620: if (fnd_log.LEVEL_STATEMENT >=
4621: fnd_log.g_current_runtime_level) then
4622: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4623: c_log_head || l_api_name || '.open_glob_nofn_cursor',
4624: ' open');
4625: end if;

Line 4622: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4618: l_object_id);
4619: l_glob_nofn := TRUE;
4620: if (fnd_log.LEVEL_STATEMENT >=
4621: fnd_log.g_current_runtime_level) then
4622: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4623: c_log_head || l_api_name || '.open_glob_nofn_cursor',
4624: ' open');
4625: end if;
4626: else

Line 4632: if (fnd_log.LEVEL_EXCEPTION >=

4628: fnd_message.set_token('ROUTINE',
4629: c_pkg_name || '.'|| l_api_name);
4630: fnd_message.set_token('REASON',
4631: ' Fell through where we shouldnt have (1)');
4632: if (fnd_log.LEVEL_EXCEPTION >=
4633: fnd_log.g_current_runtime_level) then
4634: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
4635: c_log_head || l_api_name || '.end_fallthru1',
4636: FALSE);

Line 4633: fnd_log.g_current_runtime_level) then

4629: c_pkg_name || '.'|| l_api_name);
4630: fnd_message.set_token('REASON',
4631: ' Fell through where we shouldnt have (1)');
4632: if (fnd_log.LEVEL_EXCEPTION >=
4633: fnd_log.g_current_runtime_level) then
4634: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
4635: c_log_head || l_api_name || '.end_fallthru1',
4636: FALSE);
4637: end if;

Line 4634: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

4630: fnd_message.set_token('REASON',
4631: ' Fell through where we shouldnt have (1)');
4632: if (fnd_log.LEVEL_EXCEPTION >=
4633: fnd_log.g_current_runtime_level) then
4634: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
4635: c_log_head || l_api_name || '.end_fallthru1',
4636: FALSE);
4637: end if;
4638: x_return_status := 'U';

Line 4645: if (fnd_log.LEVEL_STATEMENT >=

4641:
4642: l_cursor_is_open := TRUE;
4643: LOOP
4644: if (l_grp_glob_fn) then
4645: if (fnd_log.LEVEL_STATEMENT >=
4646: fnd_log.g_current_runtime_level) then
4647: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4648: c_log_head || l_api_name || '.fetch_grp_glob_fn_cursor',
4649: ' fetch');

Line 4646: fnd_log.g_current_runtime_level) then

4642: l_cursor_is_open := TRUE;
4643: LOOP
4644: if (l_grp_glob_fn) then
4645: if (fnd_log.LEVEL_STATEMENT >=
4646: fnd_log.g_current_runtime_level) then
4647: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4648: c_log_head || l_api_name || '.fetch_grp_glob_fn_cursor',
4649: ' fetch');
4650: end if;

Line 4647: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4643: LOOP
4644: if (l_grp_glob_fn) then
4645: if (fnd_log.LEVEL_STATEMENT >=
4646: fnd_log.g_current_runtime_level) then
4647: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4648: c_log_head || l_api_name || '.fetch_grp_glob_fn_cursor',
4649: ' fetch');
4650: end if;
4651: FETCH isg_grp_glob_fn_c INTO d_predicate, d_instance_set_id,

Line 4661: /*if (fnd_log.LEVEL_STATEMENT >=

4657: end if;
4658: elsif (l_grp_glob_nofn) then
4659: --Changes for Bug#3867925
4660: -- Fix Non Backward change made for universal person support
4661: /*if (fnd_log.LEVEL_STATEMENT >=
4662: fnd_log.g_current_runtime_level) then
4663: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4664: c_log_head || l_api_name || '.fetch_grp_glob_nofn_cursor',
4665: ' fetch');

Line 4662: fnd_log.g_current_runtime_level) then

4658: elsif (l_grp_glob_nofn) then
4659: --Changes for Bug#3867925
4660: -- Fix Non Backward change made for universal person support
4661: /*if (fnd_log.LEVEL_STATEMENT >=
4662: fnd_log.g_current_runtime_level) then
4663: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4664: c_log_head || l_api_name || '.fetch_grp_glob_nofn_cursor',
4665: ' fetch');
4666: end if;

Line 4663: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4659: --Changes for Bug#3867925
4660: -- Fix Non Backward change made for universal person support
4661: /*if (fnd_log.LEVEL_STATEMENT >=
4662: fnd_log.g_current_runtime_level) then
4663: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4664: c_log_head || l_api_name || '.fetch_grp_glob_nofn_cursor',
4665: ' fetch');
4666: end if;
4667: FETCH isg_grp_glob_nofn_c INTO d_predicate, d_instance_set_id,

Line 4676: if (fnd_log.LEVEL_STATEMENT >=

4672: exit; -- exit loop
4673: end if;*/
4674:
4675: if (colon <> 0) then
4676: if (fnd_log.LEVEL_STATEMENT >=
4677: fnd_log.g_current_runtime_level) then
4678: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4679: c_log_head || l_api_name ||
4680: '.fetch_grp_glob_nofn_bkwd_cursor',

Line 4677: fnd_log.g_current_runtime_level) then

4673: end if;*/
4674:
4675: if (colon <> 0) then
4676: if (fnd_log.LEVEL_STATEMENT >=
4677: fnd_log.g_current_runtime_level) then
4678: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4679: c_log_head || l_api_name ||
4680: '.fetch_grp_glob_nofn_bkwd_cursor',
4681: ' fetch');

Line 4678: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4674:
4675: if (colon <> 0) then
4676: if (fnd_log.LEVEL_STATEMENT >=
4677: fnd_log.g_current_runtime_level) then
4678: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4679: c_log_head || l_api_name ||
4680: '.fetch_grp_glob_nofn_bkwd_cursor',
4681: ' fetch');
4682: end if;

Line 4691: if (fnd_log.LEVEL_STATEMENT >=

4687: l_cursor_is_open := FALSE;
4688: exit; -- exit loop
4689: end if;
4690: else
4691: if (fnd_log.LEVEL_STATEMENT >=
4692: fnd_log.g_current_runtime_level) then
4693: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4694: c_log_head || l_api_name||'.fetch_grp_glob_nofn_cursor',
4695: ' fetch');

Line 4692: fnd_log.g_current_runtime_level) then

4688: exit; -- exit loop
4689: end if;
4690: else
4691: if (fnd_log.LEVEL_STATEMENT >=
4692: fnd_log.g_current_runtime_level) then
4693: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4694: c_log_head || l_api_name||'.fetch_grp_glob_nofn_cursor',
4695: ' fetch');
4696: end if;

Line 4693: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4689: end if;
4690: else
4691: if (fnd_log.LEVEL_STATEMENT >=
4692: fnd_log.g_current_runtime_level) then
4693: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4694: c_log_head || l_api_name||'.fetch_grp_glob_nofn_cursor',
4695: ' fetch');
4696: end if;
4697: FETCH isg_grp_glob_nofn_c

Line 4709: /*if (fnd_log.LEVEL_STATEMENT >=

4705: end if;
4706: elsif (l_grp_fn) then
4707: --Changes for Bug#3867925
4708: -- Fix Non Backward change made for universal person support
4709: /*if (fnd_log.LEVEL_STATEMENT >=
4710: fnd_log.g_current_runtime_level) then
4711: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4712: c_log_head || l_api_name || '.fetch_grp_fn_cursor',
4713: ' fetch');

Line 4710: fnd_log.g_current_runtime_level) then

4706: elsif (l_grp_fn) then
4707: --Changes for Bug#3867925
4708: -- Fix Non Backward change made for universal person support
4709: /*if (fnd_log.LEVEL_STATEMENT >=
4710: fnd_log.g_current_runtime_level) then
4711: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4712: c_log_head || l_api_name || '.fetch_grp_fn_cursor',
4713: ' fetch');
4714: end if;

Line 4711: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4707: --Changes for Bug#3867925
4708: -- Fix Non Backward change made for universal person support
4709: /*if (fnd_log.LEVEL_STATEMENT >=
4710: fnd_log.g_current_runtime_level) then
4711: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4712: c_log_head || l_api_name || '.fetch_grp_fn_cursor',
4713: ' fetch');
4714: end if;
4715: FETCH isg_grp_fn_c INTO d_predicate, d_instance_set_id,

Line 4724: if (fnd_log.LEVEL_STATEMENT >=

4720: exit; -- exit loop
4721: end if;*/
4722:
4723: if (colon <> 0) then
4724: if (fnd_log.LEVEL_STATEMENT >=
4725: fnd_log.g_current_runtime_level) then
4726: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4727: c_log_head || l_api_name||'.fetch_grp_fn_bkwd_cursor',
4728: ' fetch');

Line 4725: fnd_log.g_current_runtime_level) then

4721: end if;*/
4722:
4723: if (colon <> 0) then
4724: if (fnd_log.LEVEL_STATEMENT >=
4725: fnd_log.g_current_runtime_level) then
4726: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4727: c_log_head || l_api_name||'.fetch_grp_fn_bkwd_cursor',
4728: ' fetch');
4729: end if;

Line 4726: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4722:
4723: if (colon <> 0) then
4724: if (fnd_log.LEVEL_STATEMENT >=
4725: fnd_log.g_current_runtime_level) then
4726: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4727: c_log_head || l_api_name||'.fetch_grp_fn_bkwd_cursor',
4728: ' fetch');
4729: end if;
4730: FETCH isg_grp_fn_bkwd_c INTO

Line 4739: if (fnd_log.LEVEL_STATEMENT >=

4735: l_cursor_is_open := FALSE;
4736: exit; -- exit loop
4737: end if;
4738: else
4739: if (fnd_log.LEVEL_STATEMENT >=
4740: fnd_log.g_current_runtime_level) then
4741: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4742: c_log_head || l_api_name || '.fetch_grp_fn_cursor',
4743: ' fetch');

Line 4740: fnd_log.g_current_runtime_level) then

4736: exit; -- exit loop
4737: end if;
4738: else
4739: if (fnd_log.LEVEL_STATEMENT >=
4740: fnd_log.g_current_runtime_level) then
4741: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4742: c_log_head || l_api_name || '.fetch_grp_fn_cursor',
4743: ' fetch');
4744: end if;

Line 4741: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4737: end if;
4738: else
4739: if (fnd_log.LEVEL_STATEMENT >=
4740: fnd_log.g_current_runtime_level) then
4741: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4742: c_log_head || l_api_name || '.fetch_grp_fn_cursor',
4743: ' fetch');
4744: end if;
4745: FETCH isg_grp_fn_c INTO d_predicate, d_instance_set_id,

Line 4756: /*if (fnd_log.LEVEL_STATEMENT >=

4752: end if;
4753: elsif (l_grp_nofn) then
4754: --Changes for Bug#3867925
4755: -- Fix Non Backward change made for universal person support
4756: /*if (fnd_log.LEVEL_STATEMENT >=
4757: fnd_log.g_current_runtime_level) then
4758: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4759: c_log_head || l_api_name || '.fetch_grp_nofn_cursor',
4760: ' fetch');

Line 4757: fnd_log.g_current_runtime_level) then

4753: elsif (l_grp_nofn) then
4754: --Changes for Bug#3867925
4755: -- Fix Non Backward change made for universal person support
4756: /*if (fnd_log.LEVEL_STATEMENT >=
4757: fnd_log.g_current_runtime_level) then
4758: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4759: c_log_head || l_api_name || '.fetch_grp_nofn_cursor',
4760: ' fetch');
4761: end if;

Line 4758: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4754: --Changes for Bug#3867925
4755: -- Fix Non Backward change made for universal person support
4756: /*if (fnd_log.LEVEL_STATEMENT >=
4757: fnd_log.g_current_runtime_level) then
4758: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4759: c_log_head || l_api_name || '.fetch_grp_nofn_cursor',
4760: ' fetch');
4761: end if;
4762: FETCH isg_grp_nofn_c INTO d_predicate, d_instance_set_id,

Line 4771: if (fnd_log.LEVEL_STATEMENT >=

4767: exit; -- exit loop
4768: end if; */
4769:
4770: if (colon <> 0) then
4771: if (fnd_log.LEVEL_STATEMENT >=
4772: fnd_log.g_current_runtime_level) then
4773: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4774: c_log_head || l_api_name ||'.fetch_grp_nofn_bkwd_cursor',
4775: ' fetch');

Line 4772: fnd_log.g_current_runtime_level) then

4768: end if; */
4769:
4770: if (colon <> 0) then
4771: if (fnd_log.LEVEL_STATEMENT >=
4772: fnd_log.g_current_runtime_level) then
4773: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4774: c_log_head || l_api_name ||'.fetch_grp_nofn_bkwd_cursor',
4775: ' fetch');
4776: end if;

Line 4773: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4769:
4770: if (colon <> 0) then
4771: if (fnd_log.LEVEL_STATEMENT >=
4772: fnd_log.g_current_runtime_level) then
4773: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4774: c_log_head || l_api_name ||'.fetch_grp_nofn_bkwd_cursor',
4775: ' fetch');
4776: end if;
4777: FETCH isg_grp_nofn_bkwd_c

Line 4786: if (fnd_log.LEVEL_STATEMENT >=

4782: l_cursor_is_open := FALSE;
4783: exit; -- exit loop
4784: end if;
4785: else
4786: if (fnd_log.LEVEL_STATEMENT >=
4787: fnd_log.g_current_runtime_level) then
4788: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4789: c_log_head || l_api_name || '.fetch_grp_nofn_cursor',
4790: ' fetch');

Line 4787: fnd_log.g_current_runtime_level) then

4783: exit; -- exit loop
4784: end if;
4785: else
4786: if (fnd_log.LEVEL_STATEMENT >=
4787: fnd_log.g_current_runtime_level) then
4788: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4789: c_log_head || l_api_name || '.fetch_grp_nofn_cursor',
4790: ' fetch');
4791: end if;

Line 4788: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4784: end if;
4785: else
4786: if (fnd_log.LEVEL_STATEMENT >=
4787: fnd_log.g_current_runtime_level) then
4788: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4789: c_log_head || l_api_name || '.fetch_grp_nofn_cursor',
4790: ' fetch');
4791: end if;
4792: FETCH isg_grp_nofn_c INTO d_predicate, d_instance_set_id,

Line 4801: if (fnd_log.LEVEL_STATEMENT >=

4797: exit; -- exit loop
4798: end if;
4799: end if;
4800: elsif (l_glob_fn) then
4801: if (fnd_log.LEVEL_STATEMENT >=
4802: fnd_log.g_current_runtime_level) then
4803: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4804: c_log_head || l_api_name || '.fetch_glob_fn_cursor',
4805: ' fetch');

Line 4802: fnd_log.g_current_runtime_level) then

4798: end if;
4799: end if;
4800: elsif (l_glob_fn) then
4801: if (fnd_log.LEVEL_STATEMENT >=
4802: fnd_log.g_current_runtime_level) then
4803: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4804: c_log_head || l_api_name || '.fetch_glob_fn_cursor',
4805: ' fetch');
4806: end if;

Line 4803: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4799: end if;
4800: elsif (l_glob_fn) then
4801: if (fnd_log.LEVEL_STATEMENT >=
4802: fnd_log.g_current_runtime_level) then
4803: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4804: c_log_head || l_api_name || '.fetch_glob_fn_cursor',
4805: ' fetch');
4806: end if;
4807: FETCH isg_glob_fn_c INTO d_predicate, d_instance_set_id,

Line 4815: if (fnd_log.LEVEL_STATEMENT >=

4811: l_cursor_is_open := FALSE;
4812: exit; -- exit loop
4813: end if;
4814: elsif (l_glob_nofn) then
4815: if (fnd_log.LEVEL_STATEMENT >=
4816: fnd_log.g_current_runtime_level) then
4817: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4818: c_log_head || l_api_name || '.fetch_glob_nofn_cursor',
4819: ' fetch');

Line 4816: fnd_log.g_current_runtime_level) then

4812: exit; -- exit loop
4813: end if;
4814: elsif (l_glob_nofn) then
4815: if (fnd_log.LEVEL_STATEMENT >=
4816: fnd_log.g_current_runtime_level) then
4817: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4818: c_log_head || l_api_name || '.fetch_glob_nofn_cursor',
4819: ' fetch');
4820: end if;

Line 4817: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4813: end if;
4814: elsif (l_glob_nofn) then
4815: if (fnd_log.LEVEL_STATEMENT >=
4816: fnd_log.g_current_runtime_level) then
4817: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4818: c_log_head || l_api_name || '.fetch_glob_nofn_cursor',
4819: ' fetch');
4820: end if;
4821: FETCH isg_glob_nofn_c INTO d_predicate, d_instance_set_id,

Line 4834: if (fnd_log.LEVEL_EXCEPTION >=

4830: fnd_message.set_token('ROUTINE',
4831: c_pkg_name || '.'|| l_api_name);
4832: fnd_message.set_token('REASON',
4833: ' Fell through where we shouldnt have (2)');
4834: if (fnd_log.LEVEL_EXCEPTION >=
4835: fnd_log.g_current_runtime_level) then
4836: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
4837: c_log_head || l_api_name || '.end_fallthru2',
4838: FALSE);

Line 4835: fnd_log.g_current_runtime_level) then

4831: c_pkg_name || '.'|| l_api_name);
4832: fnd_message.set_token('REASON',
4833: ' Fell through where we shouldnt have (2)');
4834: if (fnd_log.LEVEL_EXCEPTION >=
4835: fnd_log.g_current_runtime_level) then
4836: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
4837: c_log_head || l_api_name || '.end_fallthru2',
4838: FALSE);
4839: end if;

Line 4836: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

4832: fnd_message.set_token('REASON',
4833: ' Fell through where we shouldnt have (2)');
4834: if (fnd_log.LEVEL_EXCEPTION >=
4835: fnd_log.g_current_runtime_level) then
4836: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
4837: c_log_head || l_api_name || '.end_fallthru2',
4838: FALSE);
4839: end if;
4840: x_return_status := 'U';

Line 4844: if (fnd_log.LEVEL_STATEMENT >=

4840: x_return_status := 'U';
4841: return;
4842: end if;
4843:
4844: if (fnd_log.LEVEL_STATEMENT >=
4845: fnd_log.g_current_runtime_level) then
4846: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4847: c_log_head || l_api_name || '.loop_isg',
4848: ' d_instance_set_id: '||

Line 4845: fnd_log.g_current_runtime_level) then

4841: return;
4842: end if;
4843:
4844: if (fnd_log.LEVEL_STATEMENT >=
4845: fnd_log.g_current_runtime_level) then
4846: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4847: c_log_head || l_api_name || '.loop_isg',
4848: ' d_instance_set_id: '||
4849: d_instance_set_id ||

Line 4846: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4842: end if;
4843:
4844: if (fnd_log.LEVEL_STATEMENT >=
4845: fnd_log.g_current_runtime_level) then
4846: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4847: c_log_head || l_api_name || '.loop_isg',
4848: ' d_instance_set_id: '||
4849: d_instance_set_id ||
4850: ' d_predicate: '||

Line 4864: if (fnd_log.LEVEL_STATEMENT >=

4860: l_aggregate_predicate := substrb( l_aggregate_predicate ||
4861: ') AND '|| l_pred ||')', 1, c_pred_buf_size);
4862: l_need_to_close_pred := FALSE;
4863: l_last_was_hextoraw := FALSE;
4864: if (fnd_log.LEVEL_STATEMENT >=
4865: fnd_log.g_current_runtime_level) then
4866: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4867: c_log_head || l_api_name || '.close_pred',
4868: 'l_pred:'||l_pred);

Line 4865: fnd_log.g_current_runtime_level) then

4861: ') AND '|| l_pred ||')', 1, c_pred_buf_size);
4862: l_need_to_close_pred := FALSE;
4863: l_last_was_hextoraw := FALSE;
4864: if (fnd_log.LEVEL_STATEMENT >=
4865: fnd_log.g_current_runtime_level) then
4866: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4867: c_log_head || l_api_name || '.close_pred',
4868: 'l_pred:'||l_pred);
4869: end if;

Line 4866: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4862: l_need_to_close_pred := FALSE;
4863: l_last_was_hextoraw := FALSE;
4864: if (fnd_log.LEVEL_STATEMENT >=
4865: fnd_log.g_current_runtime_level) then
4866: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4867: c_log_head || l_api_name || '.close_pred',
4868: 'l_pred:'||l_pred);
4869: end if;
4870: end if;

Line 4882: if (fnd_log.LEVEL_STATEMENT >=

4878: /* Upgrade and substitute predicate */
4879: l_pred := upgrade_predicate(
4880: d_predicate);
4881:
4882: if (fnd_log.LEVEL_STATEMENT >=
4883: fnd_log.g_current_runtime_level) then
4884: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4885: c_log_head || l_api_name || '.upgd_pred',
4886: 'l_pred:'||l_pred);

Line 4883: fnd_log.g_current_runtime_level) then

4879: l_pred := upgrade_predicate(
4880: d_predicate);
4881:
4882: if (fnd_log.LEVEL_STATEMENT >=
4883: fnd_log.g_current_runtime_level) then
4884: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4885: c_log_head || l_api_name || '.upgd_pred',
4886: 'l_pred:'||l_pred);
4887: end if;

Line 4884: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4880: d_predicate);
4881:
4882: if (fnd_log.LEVEL_STATEMENT >=
4883: fnd_log.g_current_runtime_level) then
4884: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4885: c_log_head || l_api_name || '.upgd_pred',
4886: 'l_pred:'||l_pred);
4887: end if;
4888:

Line 4901: if (fnd_log.LEVEL_STATEMENT >=

4897: l_pred := substitute_predicate(
4898: l_pred,
4899: p_table_alias);
4900:
4901: if (fnd_log.LEVEL_STATEMENT >=
4902: fnd_log.g_current_runtime_level) then
4903: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4904: c_log_head || l_api_name || '.subbed_pred',
4905: 'l_pred:'||l_pred);

Line 4902: fnd_log.g_current_runtime_level) then

4898: l_pred,
4899: p_table_alias);
4900:
4901: if (fnd_log.LEVEL_STATEMENT >=
4902: fnd_log.g_current_runtime_level) then
4903: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4904: c_log_head || l_api_name || '.subbed_pred',
4905: 'l_pred:'||l_pred);
4906: end if;

Line 4903: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4899: p_table_alias);
4900:
4901: if (fnd_log.LEVEL_STATEMENT >=
4902: fnd_log.g_current_runtime_level) then
4903: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4904: c_log_head || l_api_name || '.subbed_pred',
4905: 'l_pred:'||l_pred);
4906: end if;
4907:

Line 4916: if (fnd_log.LEVEL_STATEMENT >=

4912: substrb( l_aggregate_predicate ||
4913: '('|| l_pred ||')', 1, c_pred_buf_size);
4914: l_need_to_close_pred := FALSE;
4915: l_refers_to_grants := FALSE;
4916: if (fnd_log.LEVEL_STATEMENT >=
4917: fnd_log.g_current_runtime_level) then
4918: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4919: c_log_head || l_api_name || '.simple_pred',
4920: 'l_pred:'||l_pred);

Line 4917: fnd_log.g_current_runtime_level) then

4913: '('|| l_pred ||')', 1, c_pred_buf_size);
4914: l_need_to_close_pred := FALSE;
4915: l_refers_to_grants := FALSE;
4916: if (fnd_log.LEVEL_STATEMENT >=
4917: fnd_log.g_current_runtime_level) then
4918: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4919: c_log_head || l_api_name || '.simple_pred',
4920: 'l_pred:'||l_pred);
4921: end if;

Line 4918: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4914: l_need_to_close_pred := FALSE;
4915: l_refers_to_grants := FALSE;
4916: if (fnd_log.LEVEL_STATEMENT >=
4917: fnd_log.g_current_runtime_level) then
4918: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4919: c_log_head || l_api_name || '.simple_pred',
4920: 'l_pred:'||l_pred);
4921: end if;
4922: else /* Has references to grant table so we subselect */

Line 4932: if (fnd_log.LEVEL_STATEMENT >=

4928: ' where gnt.grant_guid in (',
4929: 1, c_pred_buf_size);
4930: l_need_to_close_pred := TRUE;
4931: l_refers_to_grants := TRUE;
4932: if (fnd_log.LEVEL_STATEMENT >=
4933: fnd_log.g_current_runtime_level) then
4934: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4935: c_log_head || l_api_name || '.compl_pred',
4936: 'l_pred:'||l_pred);

Line 4933: fnd_log.g_current_runtime_level) then

4929: 1, c_pred_buf_size);
4930: l_need_to_close_pred := TRUE;
4931: l_refers_to_grants := TRUE;
4932: if (fnd_log.LEVEL_STATEMENT >=
4933: fnd_log.g_current_runtime_level) then
4934: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4935: c_log_head || l_api_name || '.compl_pred',
4936: 'l_pred:'||l_pred);
4937: end if;

Line 4934: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4930: l_need_to_close_pred := TRUE;
4931: l_refers_to_grants := TRUE;
4932: if (fnd_log.LEVEL_STATEMENT >=
4933: fnd_log.g_current_runtime_level) then
4934: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4935: c_log_head || l_api_name || '.compl_pred',
4936: 'l_pred:'||l_pred);
4937: end if;
4938: end if;

Line 4959: if (fnd_log.LEVEL_STATEMENT >=

4955: l_last_was_hextoraw := TRUE;
4956: else
4957: l_last_was_hextoraw := FALSE;
4958: end if;
4959: if (fnd_log.LEVEL_STATEMENT >=
4960: fnd_log.g_current_runtime_level) then
4961: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4962: c_log_head || l_api_name || '.instsetloop',
4963: ' l_aggregate_predicate: ' || l_aggregate_predicate);

Line 4960: fnd_log.g_current_runtime_level) then

4956: else
4957: l_last_was_hextoraw := FALSE;
4958: end if;
4959: if (fnd_log.LEVEL_STATEMENT >=
4960: fnd_log.g_current_runtime_level) then
4961: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4962: c_log_head || l_api_name || '.instsetloop',
4963: ' l_aggregate_predicate: ' || l_aggregate_predicate);
4964: end if;

Line 4961: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4957: l_last_was_hextoraw := FALSE;
4958: end if;
4959: if (fnd_log.LEVEL_STATEMENT >=
4960: fnd_log.g_current_runtime_level) then
4961: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4962: c_log_head || l_api_name || '.instsetloop',
4963: ' l_aggregate_predicate: ' || l_aggregate_predicate);
4964: end if;
4965: END LOOP;

Line 4989: if (fnd_log.LEVEL_EXCEPTION >=

4985: fnd_message.set_token('ROUTINE',
4986: c_pkg_name || '.'|| l_api_name);
4987: fnd_message.set_token('REASON',
4988: ' Fell through where we shouldnt have (3)');
4989: if (fnd_log.LEVEL_EXCEPTION >=
4990: fnd_log.g_current_runtime_level) then
4991: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
4992: c_log_head || l_api_name || '.end_fallthru3',
4993: FALSE);

Line 4990: fnd_log.g_current_runtime_level) then

4986: c_pkg_name || '.'|| l_api_name);
4987: fnd_message.set_token('REASON',
4988: ' Fell through where we shouldnt have (3)');
4989: if (fnd_log.LEVEL_EXCEPTION >=
4990: fnd_log.g_current_runtime_level) then
4991: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
4992: c_log_head || l_api_name || '.end_fallthru3',
4993: FALSE);
4994: end if;

Line 4991: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

4987: fnd_message.set_token('REASON',
4988: ' Fell through where we shouldnt have (3)');
4989: if (fnd_log.LEVEL_EXCEPTION >=
4990: fnd_log.g_current_runtime_level) then
4991: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
4992: c_log_head || l_api_name || '.end_fallthru3',
4993: FALSE);
4994: end if;
4995: x_return_status := 'U';

Line 5014: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

5010: if (l_last_pred = '*NO_PRED*') then
5011: l_set_instance_type := FALSE;
5012: end if;
5013:
5014: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
5015: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
5016: c_log_head || l_api_name || '.afterinstset',
5017: ' l_aggregate_predicate: ' || l_aggregate_predicate);
5018: end if;

Line 5015: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

5011: l_set_instance_type := FALSE;
5012: end if;
5013:
5014: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
5015: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
5016: c_log_head || l_api_name || '.afterinstset',
5017: ' l_aggregate_predicate: ' || l_aggregate_predicate);
5018: end if;
5019:

Line 5156: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

5152:
5153: /* Add on the clause for INSTANCE_TYPE = 'INSTANCE' */
5154: l_instance_predicate := l_instance_predicate ||
5155: ' AND'|| l_ik_clause||'))';
5156: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
5157: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
5158: c_log_head || l_api_name || '.instpred','instpred');
5159: end if;
5160: end if;

Line 5157: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

5153: /* Add on the clause for INSTANCE_TYPE = 'INSTANCE' */
5154: l_instance_predicate := l_instance_predicate ||
5155: ' AND'|| l_ik_clause||'))';
5156: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
5157: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
5158: c_log_head || l_api_name || '.instpred','instpred');
5159: end if;
5160: end if;
5161:

Line 5210: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then

5206: FND_MESSAGE.SET_TOKEN('REASON',
5207: 'The predicate was longer than the database VPD limit of '||
5208: to_char(g_vpd_buf_limit)||' bytes for the predicate. ');
5209:
5210: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
5211: fnd_log.message(FND_LOG.LEVEL_PROCEDURE,
5212: c_log_head || l_api_name || '.end',
5213: FALSE);
5214: end if;

Line 5211: fnd_log.message(FND_LOG.LEVEL_PROCEDURE,

5207: 'The predicate was longer than the database VPD limit of '||
5208: to_char(g_vpd_buf_limit)||' bytes for the predicate. ');
5209:
5210: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
5211: fnd_log.message(FND_LOG.LEVEL_PROCEDURE,
5212: c_log_head || l_api_name || '.end',
5213: FALSE);
5214: end if;
5215: x_return_status := 'L'; /* Indicate Error */

Line 5228: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then

5224: or (p_statement_type = 'VPD'))) then
5225: x_predicate := NULL;
5226: end if;
5227:
5228: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
5229: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
5230: c_log_head || l_api_name || '.end',
5231: 'x_predicate: '|| x_predicate ||
5232: ', x_return_status:'||x_return_status);

Line 5229: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

5225: x_predicate := NULL;
5226: end if;
5227:
5228: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
5229: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
5230: c_log_head || l_api_name || '.end',
5231: 'x_predicate: '|| x_predicate ||
5232: ', x_return_status:'||x_return_status);
5233: end if;

Line 5272: if (fnd_log.LEVEL_EXCEPTION >=

5268: c_pkg_name || '.'|| l_api_name);
5269: fnd_message.set_token('ERRNO', SQLCODE);
5270: fnd_message.set_token('REASON', SQLERRM);
5271:
5272: if (fnd_log.LEVEL_EXCEPTION >=
5273: fnd_log.g_current_runtime_level) then
5274: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
5275: c_log_head || l_api_name || '.other_err',
5276: FALSE);

Line 5273: fnd_log.g_current_runtime_level) then

5269: fnd_message.set_token('ERRNO', SQLCODE);
5270: fnd_message.set_token('REASON', SQLERRM);
5271:
5272: if (fnd_log.LEVEL_EXCEPTION >=
5273: fnd_log.g_current_runtime_level) then
5274: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
5275: c_log_head || l_api_name || '.other_err',
5276: FALSE);
5277: end if;

Line 5274: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

5270: fnd_message.set_token('REASON', SQLERRM);
5271:
5272: if (fnd_log.LEVEL_EXCEPTION >=
5273: fnd_log.g_current_runtime_level) then
5274: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
5275: c_log_head || l_api_name || '.other_err',
5276: FALSE);
5277: end if;
5278: x_return_status := 'U';

Line 5279: if (fnd_log.LEVEL_PROCEDURE >=

5275: c_log_head || l_api_name || '.other_err',
5276: FALSE);
5277: end if;
5278: x_return_status := 'U';
5279: if (fnd_log.LEVEL_PROCEDURE >=
5280: fnd_log.g_current_runtime_level) then
5281: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
5282: c_log_head || l_api_name || '.end_after_other',
5283: 'x_predicate: '|| x_predicate ||

Line 5280: fnd_log.g_current_runtime_level) then

5276: FALSE);
5277: end if;
5278: x_return_status := 'U';
5279: if (fnd_log.LEVEL_PROCEDURE >=
5280: fnd_log.g_current_runtime_level) then
5281: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
5282: c_log_head || l_api_name || '.end_after_other',
5283: 'x_predicate: '|| x_predicate ||
5284: ', x_return_status:'||x_return_status);

Line 5281: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

5277: end if;
5278: x_return_status := 'U';
5279: if (fnd_log.LEVEL_PROCEDURE >=
5280: fnd_log.g_current_runtime_level) then
5281: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
5282: c_log_head || l_api_name || '.end_after_other',
5283: 'x_predicate: '|| x_predicate ||
5284: ', x_return_status:'||x_return_status);
5285: end if;

Line 5311: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then

5307: l_api_name CONSTANT VARCHAR2(30) := 'GET_SECURITY_PREDICATE_W_BINDS';
5308: l_api_version CONSTANT NUMBER := 1.0;
5309: BEGIN
5310:
5311: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
5312: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
5313: c_log_head || l_api_name || '.begin',
5314: c_pkg_name || '.' ||l_api_name|| '(' ||
5315: 'p_api_version=>'|| to_char(p_api_version) ||

Line 5312: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

5308: l_api_version CONSTANT NUMBER := 1.0;
5309: BEGIN
5310:
5311: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
5312: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
5313: c_log_head || l_api_name || '.begin',
5314: c_pkg_name || '.' ||l_api_name|| '(' ||
5315: 'p_api_version=>'|| to_char(p_api_version) ||
5316: ', p_function=>'|| p_function ||

Line 5334: if (fnd_log.LEVEL_EXCEPTION >=

5330: fnd_message.set_token('REASON',
5331: 'Unsupported version '|| to_char(p_api_version)||
5332: ' passed to API; expecting version '||
5333: to_char(l_api_version));
5334: if (fnd_log.LEVEL_EXCEPTION >=
5335: fnd_log.g_current_runtime_level) then
5336: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
5337: c_log_head || l_api_name || '.end_bad_api_ver',
5338: FALSE);

Line 5335: fnd_log.g_current_runtime_level) then

5331: 'Unsupported version '|| to_char(p_api_version)||
5332: ' passed to API; expecting version '||
5333: to_char(l_api_version));
5334: if (fnd_log.LEVEL_EXCEPTION >=
5335: fnd_log.g_current_runtime_level) then
5336: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
5337: c_log_head || l_api_name || '.end_bad_api_ver',
5338: FALSE);
5339: end if;

Line 5336: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

5332: ' passed to API; expecting version '||
5333: to_char(l_api_version));
5334: if (fnd_log.LEVEL_EXCEPTION >=
5335: fnd_log.g_current_runtime_level) then
5336: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
5337: c_log_head || l_api_name || '.end_bad_api_ver',
5338: FALSE);
5339: end if;
5340: x_return_status := 'U'; /* Unexpected Error */

Line 5350: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then

5346: p_user_name, p_statement_type, p_table_alias,'Y',
5347: x_predicate, x_return_status,
5348: x_function_id, x_object_id, x_bind_order);
5349:
5350: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
5351: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
5352: c_log_head || l_api_name || '.end',
5353: ' x_predicate: '|| x_predicate ||
5354: ' x_return_status:'||x_return_status||

Line 5351: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

5347: x_predicate, x_return_status,
5348: x_function_id, x_object_id, x_bind_order);
5349:
5350: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
5351: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
5352: c_log_head || l_api_name || '.end',
5353: ' x_predicate: '|| x_predicate ||
5354: ' x_return_status:'||x_return_status||
5355: ' x_function_id: '|| x_function_id ||

Line 5389: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then

5385: x_object_id NUMBER;
5386: x_bind_order varchar2(256);
5387: BEGIN
5388:
5389: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
5390: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
5391: c_log_head || l_api_name || '.begin',
5392: c_pkg_name || '.' ||l_api_name|| '(' ||
5393: 'p_api_version=>'|| to_char(p_api_version) ||

Line 5390: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

5386: x_bind_order varchar2(256);
5387: BEGIN
5388:
5389: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
5390: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
5391: c_log_head || l_api_name || '.begin',
5392: c_pkg_name || '.' ||l_api_name|| '(' ||
5393: 'p_api_version=>'|| to_char(p_api_version) ||
5394: ', p_function=>'|| p_function ||

Line 5411: if (fnd_log.LEVEL_EXCEPTION >=

5407: fnd_message.set_token('REASON',
5408: 'Unsupported version '|| to_char(p_api_version)||
5409: ' passed to API; expecting version '||
5410: to_char(l_api_version));
5411: if (fnd_log.LEVEL_EXCEPTION >=
5412: fnd_log.g_current_runtime_level) then
5413: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
5414: c_log_head || l_api_name || '.end_bad_api_ver',
5415: FALSE);

Line 5412: fnd_log.g_current_runtime_level) then

5408: 'Unsupported version '|| to_char(p_api_version)||
5409: ' passed to API; expecting version '||
5410: to_char(l_api_version));
5411: if (fnd_log.LEVEL_EXCEPTION >=
5412: fnd_log.g_current_runtime_level) then
5413: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
5414: c_log_head || l_api_name || '.end_bad_api_ver',
5415: FALSE);
5416: end if;

Line 5413: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

5409: ' passed to API; expecting version '||
5410: to_char(l_api_version));
5411: if (fnd_log.LEVEL_EXCEPTION >=
5412: fnd_log.g_current_runtime_level) then
5413: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
5414: c_log_head || l_api_name || '.end_bad_api_ver',
5415: FALSE);
5416: end if;
5417: x_return_status := 'U'; /* Unexpected Error */

Line 5427: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then

5423: p_user_name, p_statement_type, p_table_alias, 'N',
5424: x_predicate, x_return_status,
5425: x_function_id, x_object_id, x_bind_order);
5426:
5427: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
5428: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
5429: c_log_head || l_api_name || '.end',
5430: ' x_predicate: '|| x_predicate ||
5431: ' x_return_status:'||x_return_status||

Line 5428: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

5424: x_predicate, x_return_status,
5425: x_function_id, x_object_id, x_bind_order);
5426:
5427: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
5428: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
5429: c_log_head || l_api_name || '.end',
5430: ' x_predicate: '|| x_predicate ||
5431: ' x_return_status:'||x_return_status||
5432: ' x_function_id: '|| x_function_id ||

Line 5487: if (fnd_log.LEVEL_EXCEPTION >=

5483: fnd_message.set_token('REASON',
5484: 'Unsupported mode arguments: '||
5485: 'p_statement_type = BASE|VPD,'||
5486: ' or p_pkX_alias values passed.');
5487: if (fnd_log.LEVEL_EXCEPTION >=
5488: fnd_log.g_current_runtime_level) then
5489: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
5490: c_log_head || l_api_name || '.end_bad_mode',
5491: FALSE);

Line 5488: fnd_log.g_current_runtime_level) then

5484: 'Unsupported mode arguments: '||
5485: 'p_statement_type = BASE|VPD,'||
5486: ' or p_pkX_alias values passed.');
5487: if (fnd_log.LEVEL_EXCEPTION >=
5488: fnd_log.g_current_runtime_level) then
5489: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
5490: c_log_head || l_api_name || '.end_bad_mode',
5491: FALSE);
5492: end if;

Line 5489: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

5485: 'p_statement_type = BASE|VPD,'||
5486: ' or p_pkX_alias values passed.');
5487: if (fnd_log.LEVEL_EXCEPTION >=
5488: fnd_log.g_current_runtime_level) then
5489: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
5490: c_log_head || l_api_name || '.end_bad_mode',
5491: FALSE);
5492: end if;
5493: x_return_status := 'U'; /* Unexpected Error */

Line 5520: if (fnd_log.LEVEL_EXCEPTION >=

5516: 'a bug against the product that owns the call to this '||
5517: 'routine, which is likely the owner of the object that '||
5518: 'was passed to this routine: '||
5519: p_object_name);
5520: if (fnd_log.LEVEL_EXCEPTION >=
5521: fnd_log.g_current_runtime_level) then
5522: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
5523: c_log_head || l_api_name || '.end_unsupported',
5524: FALSE);

Line 5521: fnd_log.g_current_runtime_level) then

5517: 'routine, which is likely the owner of the object that '||
5518: 'was passed to this routine: '||
5519: p_object_name);
5520: if (fnd_log.LEVEL_EXCEPTION >=
5521: fnd_log.g_current_runtime_level) then
5522: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
5523: c_log_head || l_api_name || '.end_unsupported',
5524: FALSE);
5525: end if;

Line 5522: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

5518: 'was passed to this routine: '||
5519: p_object_name);
5520: if (fnd_log.LEVEL_EXCEPTION >=
5521: fnd_log.g_current_runtime_level) then
5522: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
5523: c_log_head || l_api_name || '.end_unsupported',
5524: FALSE);
5525: end if;
5526: fnd_message.raise_error;

Line 5568: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then

5564:
5565: TYPE DYNAMIC_CUR IS REF CURSOR;
5566: instances_cur DYNAMIC_CUR;
5567: begin
5568: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
5569: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
5570: c_log_head || l_api_name || '.begin',
5571: c_pkg_name || '.' ||l_api_name|| '(' ||
5572: 'p_api_version=>'|| to_char(p_api_version) ||

Line 5569: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

5565: TYPE DYNAMIC_CUR IS REF CURSOR;
5566: instances_cur DYNAMIC_CUR;
5567: begin
5568: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
5569: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
5570: c_log_head || l_api_name || '.begin',
5571: c_pkg_name || '.' ||l_api_name|| '(' ||
5572: 'p_api_version=>'|| to_char(p_api_version) ||
5573: ', p_function=>'|| p_function ||

Line 5605: if (fnd_log.LEVEL_EXCEPTION >=

5601: 'a bug against the product that owns the call to this '||
5602: 'routine, which is likely the owner of the object that '||
5603: 'was passed to this routine: '||
5604: p_object_name);
5605: if (fnd_log.LEVEL_EXCEPTION >=
5606: fnd_log.g_current_runtime_level) then
5607: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
5608: c_log_head || l_api_name || '.end_unsupported',
5609: FALSE);

Line 5606: fnd_log.g_current_runtime_level) then

5602: 'routine, which is likely the owner of the object that '||
5603: 'was passed to this routine: '||
5604: p_object_name);
5605: if (fnd_log.LEVEL_EXCEPTION >=
5606: fnd_log.g_current_runtime_level) then
5607: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
5608: c_log_head || l_api_name || '.end_unsupported',
5609: FALSE);
5610: end if;

Line 5607: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

5603: 'was passed to this routine: '||
5604: p_object_name);
5605: if (fnd_log.LEVEL_EXCEPTION >=
5606: fnd_log.g_current_runtime_level) then
5607: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
5608: c_log_head || l_api_name || '.end_unsupported',
5609: FALSE);
5610: end if;
5611: fnd_message.raise_error;

Line 5622: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then

5618: p_user_name =>p_user_name,
5619: x_predicate=>l_predicate,
5620: x_return_status=>x_return_status);
5621: if((x_return_status <> 'T') AND (x_return_status <> 'F'))then
5622: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
5623: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
5624: c_log_head || l_api_name || '.end_gsp_err',
5625: 'returning status: '|| x_return_status);
5626: end if;

Line 5623: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

5619: x_predicate=>l_predicate,
5620: x_return_status=>x_return_status);
5621: if((x_return_status <> 'T') AND (x_return_status <> 'F'))then
5622: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
5623: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
5624: c_log_head || l_api_name || '.end_gsp_err',
5625: 'returning status: '|| x_return_status);
5626: end if;
5627: /* There will be a message on the msg dict stack. */

Line 5645: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then

5641: l_pk_orig_column_names,
5642: l_db_object_name,
5643: 'OBJTAB', 'GNT');
5644: if (x_return_status <> 'T') then
5645: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
5646: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
5647: c_log_head || l_api_name || '.end_pk_info_err',
5648: 'returning status: '|| x_return_status);
5649: end if;

Line 5646: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

5642: l_db_object_name,
5643: 'OBJTAB', 'GNT');
5644: if (x_return_status <> 'T') then
5645: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
5646: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
5647: c_log_head || l_api_name || '.end_pk_info_err',
5648: 'returning status: '|| x_return_status);
5649: end if;
5650: /* There will be a message on the msg dict stack. */

Line 5662: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then

5658: ' FROM '|| l_db_object_name ||
5659: ' WHERE '||l_predicate||' ';
5660: else
5661: x_return_status := 'F';
5662: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
5663: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
5664: c_log_head || l_api_name || '.end_nopred',
5665: 'returning '|| x_return_status );
5666: end if;

Line 5663: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

5659: ' WHERE '||l_predicate||' ';
5660: else
5661: x_return_status := 'F';
5662: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
5663: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
5664: c_log_head || l_api_name || '.end_nopred',
5665: 'returning '|| x_return_status );
5666: end if;
5667: return;

Line 5670: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

5666: end if;
5667: return;
5668: end if;
5669:
5670: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
5671: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
5672: c_log_head || l_api_name || '.create_dy_sql',
5673: 'dynamic_sql:'||l_dynamic_sql);
5674: end if;

Line 5671: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

5667: return;
5668: end if;
5669:
5670: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
5671: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
5672: c_log_head || l_api_name || '.create_dy_sql',
5673: 'dynamic_sql:'||l_dynamic_sql);
5674: end if;
5675:

Line 5680: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

5676: l_index:=0;
5677:
5678: -- Run the statement,
5679: OPEN instances_cur FOR l_dynamic_sql;
5680: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
5681: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
5682: c_log_head || l_api_name || '.startloop',
5683: ' startloop');
5684: end if;

Line 5681: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

5677:
5678: -- Run the statement,
5679: OPEN instances_cur FOR l_dynamic_sql;
5680: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
5681: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
5682: c_log_head || l_api_name || '.startloop',
5683: ' startloop');
5684: end if;
5685: LOOP

Line 5717: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

5713: return; /* This will never happen since pk1 is reqd*/
5714: end if;
5715:
5716:
5717: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
5718: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
5719: c_log_head || l_api_name || '.did_fetch',
5720: ' l_pk1_val: ' || l_pk1_val ||
5721: ' l_pk2_val: ' || l_pk2_val ||

Line 5718: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

5714: end if;
5715:
5716:
5717: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
5718: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
5719: c_log_head || l_api_name || '.did_fetch',
5720: ' l_pk1_val: ' || l_pk1_val ||
5721: ' l_pk2_val: ' || l_pk2_val ||
5722: ' l_pk3_val: ' || l_pk3_val ||

Line 5741: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then

5737: else
5738: x_return_status := 'F'; /* No instances */
5739: end if;
5740:
5741: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
5742: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
5743: c_log_head || l_api_name || '.end',
5744: 'returning '|| x_return_status );
5745: end if;

Line 5742: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

5738: x_return_status := 'F'; /* No instances */
5739: end if;
5740:
5741: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
5742: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
5743: c_log_head || l_api_name || '.end',
5744: 'returning '|| x_return_status );
5745: end if;
5746: return;

Line 5764: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then

5760: c_pkg_name || '.'|| l_api_name);
5761: fnd_message.set_token('ERRNO', SQLCODE);
5762: fnd_message.set_token('REASON', SQLERRM);
5763:
5764: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
5765: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
5766: c_log_head || l_api_name || '.other_err',
5767: FALSE);
5768: end if;

Line 5765: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

5761: fnd_message.set_token('ERRNO', SQLCODE);
5762: fnd_message.set_token('REASON', SQLERRM);
5763:
5764: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
5765: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
5766: c_log_head || l_api_name || '.other_err',
5767: FALSE);
5768: end if;
5769: x_return_status := 'U';

Line 5770: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then

5766: c_log_head || l_api_name || '.other_err',
5767: FALSE);
5768: end if;
5769: x_return_status := 'U';
5770: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
5771: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
5772: c_log_head || l_api_name || '.end_after_other',
5773: ', x_return_status:'||x_return_status);
5774: end if;

Line 5771: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

5767: FALSE);
5768: end if;
5769: x_return_status := 'U';
5770: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
5771: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
5772: c_log_head || l_api_name || '.end_after_other',
5773: ', x_return_status:'||x_return_status);
5774: end if;
5775: RETURN ;

Line 5795: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then

5791: ) return VARCHAR2 is
5792: l_api_name CONSTANT VARCHAR2(30) := 'CHECK_INSTANCE_IN_SET';
5793:
5794: begin
5795: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
5796: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
5797: c_log_head || l_api_name || '.begin',
5798: c_pkg_name || '.' ||l_api_name|| '(' ||
5799: 'p_api_version=>'|| to_char(p_api_version) ||

Line 5796: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

5792: l_api_name CONSTANT VARCHAR2(30) := 'CHECK_INSTANCE_IN_SET';
5793:
5794: begin
5795: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
5796: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
5797: c_log_head || l_api_name || '.begin',
5798: c_pkg_name || '.' ||l_api_name|| '(' ||
5799: 'p_api_version=>'|| to_char(p_api_version) ||
5800: ', p_instance_set_name=>'|| p_instance_set_name ||

Line 5815: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then

5811: 'Desupported API called. This routine is no longer '||
5812: 'supported because it is incompatible with '||
5813: 'parameterized instance sets which were introduced '||
5814: 'in 4/2002. ');
5815: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
5816: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
5817: c_log_head || l_api_name || '.end_desupported',
5818: FALSE);
5819: end if;

Line 5816: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

5812: 'supported because it is incompatible with '||
5813: 'parameterized instance sets which were introduced '||
5814: 'in 4/2002. ');
5815: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
5816: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
5817: c_log_head || l_api_name || '.end_desupported',
5818: FALSE);
5819: end if;
5820:

Line 6125: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then

6121: L_API_NAME VARCHAR2(100) := 'GET_FUNCTIONS_BY_PROMPT';
6122: L_USER_NAME Varchar2(100):= SYS_CONTEXT('FND','USER_NAME');
6123:
6124: BEGIN
6125: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
6126: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
6127: C_LOG_HEAD || L_API_NAME || '.begin',
6128: 'P_FUNCTION_PROMPT -->'||P_FUNCTION_PROMPT||' L_USER_NAME --> '||L_USER_NAME);
6129: end if;

Line 6126: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

6122: L_USER_NAME Varchar2(100):= SYS_CONTEXT('FND','USER_NAME');
6123:
6124: BEGIN
6125: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
6126: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
6127: C_LOG_HEAD || L_API_NAME || '.begin',
6128: 'P_FUNCTION_PROMPT -->'||P_FUNCTION_PROMPT||' L_USER_NAME --> '||L_USER_NAME);
6129: end if;
6130:

Line 6262: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

6258: where function_id IS NOT NULL and responsibility_id IS NOT NULL)
6259: ) U;
6260:
6261: ELSE
6262: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
6263: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
6264: C_LOG_HEAD || L_API_NAME,
6265: 'Null has been passed either for Prompt OR User name has not been set in
6266: session '||'P_FUNCTION_PROMPT -->'||P_FUNCTION_PROMPT||' L_USER_NAME -->

Line 6263: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

6259: ) U;
6260:
6261: ELSE
6262: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
6263: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
6264: C_LOG_HEAD || L_API_NAME,
6265: 'Null has been passed either for Prompt OR User name has not been set in
6266: session '||'P_FUNCTION_PROMPT -->'||P_FUNCTION_PROMPT||' L_USER_NAME -->
6267: '||L_USER_NAME);

Line 6271: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then

6267: '||L_USER_NAME);
6268: end if;
6269: RETURN FALSE;
6270: END IF;
6271: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
6272: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
6273: C_LOG_HEAD || L_API_NAME || '.end',
6274: 'P_FUNCTION_PROMPT -->'||P_FUNCTION_PROMPT||' L_USER_NAME -->
6275: '||L_USER_NAME);

Line 6272: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

6268: end if;
6269: RETURN FALSE;
6270: END IF;
6271: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
6272: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
6273: C_LOG_HEAD || L_API_NAME || '.end',
6274: 'P_FUNCTION_PROMPT -->'||P_FUNCTION_PROMPT||' L_USER_NAME -->
6275: '||L_USER_NAME);
6276: end if;