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 197: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then

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

Line 198: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 207: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 217: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 225: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 234: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

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

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

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

Line 262: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

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

Line 292: if (fnd_log.LEVEL_EXCEPTION >=

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

Line 293: fnd_log.g_current_runtime_level) then

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

Line 294: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

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

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

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

Line 309: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 326: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 344: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 363: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 371: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 387: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 408: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 416: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 500: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 543: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

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

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

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

Line 548: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 558: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 675: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 879: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

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

Line 896: if (fnd_log.LEVEL_EXCEPTION >=

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

Line 897: fnd_log.g_current_runtime_level) then

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

Line 898: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

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

Line 913: if (fnd_log.LEVEL_EXCEPTION >=

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

Line 914: fnd_log.g_current_runtime_level) then

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

Line 915: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

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

Line 939: if (fnd_log.LEVEL_EXCEPTION >=

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

Line 940: fnd_log.g_current_runtime_level) then

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

Line 941: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

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

Line 983: if (fnd_log.LEVEL_EXCEPTION >=

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

Line 984: fnd_log.g_current_runtime_level) then

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

Line 985: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

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

Line 1003: if (fnd_log.LEVEL_EXCEPTION >=

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

Line 1004: fnd_log.g_current_runtime_level) then

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

Line 1005: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

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

Line 1022: if (fnd_log.LEVEL_STATEMENT >=

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

Line 1023: fnd_log.g_current_runtime_level) then

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

Line 1024: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

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

Line 1040: if (fnd_log.LEVEL_STATEMENT >=

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

Line 1041: fnd_log.g_current_runtime_level) then

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

Line 1042: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

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

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

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

Line 1059: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

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

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

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

Line 1073: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

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

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

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

Line 1079: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

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

Line 1086: if (fnd_log.LEVEL_PROCEDURE >=

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

Line 1087: fnd_log.g_current_runtime_level) then

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

Line 1088: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

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

Line 1110: if (fnd_log.LEVEL_EXCEPTION >=

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

Line 1111: fnd_log.g_current_runtime_level) then

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

Line 1112: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

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

Line 1116: if (fnd_log.LEVEL_PROCEDURE >=

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

Line 1117: fnd_log.g_current_runtime_level) then

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

Line 1118: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 1143: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

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

Line 1160: if (fnd_log.LEVEL_EXCEPTION >=

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

Line 1161: fnd_log.g_current_runtime_level) then

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

Line 1162: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

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

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

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

Line 1176: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 1241: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

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

Line 1265: if (fnd_log.LEVEL_EXCEPTION >=

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

Line 1266: fnd_log.g_current_runtime_level) then

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

Line 1267: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

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

Line 1282: if (fnd_log.LEVEL_EXCEPTION >=

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

Line 1283: fnd_log.g_current_runtime_level) then

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

Line 1284: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

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

Line 1326: if (fnd_log.LEVEL_EXCEPTION >=

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

Line 1327: fnd_log.g_current_runtime_level) then

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

Line 1328: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

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

Line 1379: if (fnd_log.LEVEL_PROCEDURE >=

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

Line 1380: fnd_log.g_current_runtime_level) then

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

Line 1381: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

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

Line 1387: if (fnd_log.LEVEL_PROCEDURE >=

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

Line 1388: fnd_log.g_current_runtime_level) then

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

Line 1389: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

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

Line 1413: if (fnd_log.LEVEL_PROCEDURE >=

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

Line 1414: fnd_log.g_current_runtime_level) then

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

Line 1415: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 1437: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

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

Line 1447: if (fnd_log.LEVEL_EXCEPTION >=

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

Line 1448: fnd_log.g_current_runtime_level) then

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

Line 1449: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

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

Line 1463: if (fnd_log.LEVEL_PROCEDURE >=

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

Line 1464: fnd_log.g_current_runtime_level) then

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

Line 1465: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

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

Line 1535: if (fnd_log.LEVEL_STATEMENT >=

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

Line 1536: fnd_log.g_current_runtime_level) then

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

Line 1537: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

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

Line 1548: if (fnd_log.LEVEL_STATEMENT >=

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

Line 1549: fnd_log.g_current_runtime_level) then

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

Line 1550: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

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

Line 1559: if (fnd_log.LEVEL_STATEMENT >=

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

Line 1560: fnd_log.g_current_runtime_level) then

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

Line 1561: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

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

Line 1570: if (fnd_log.LEVEL_STATEMENT >=

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

Line 1571: fnd_log.g_current_runtime_level) then

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

Line 1572: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

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

Line 1581: if (fnd_log.LEVEL_STATEMENT >=

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

Line 1582: fnd_log.g_current_runtime_level) then

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

Line 1583: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

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

Line 1592: if (fnd_log.LEVEL_STATEMENT >=

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

Line 1593: fnd_log.g_current_runtime_level) then

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

Line 1594: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

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

Line 1602: if (fnd_log.LEVEL_STATEMENT >=

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

Line 1603: fnd_log.g_current_runtime_level) then

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

Line 1604: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

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

Line 1613: if (fnd_log.LEVEL_STATEMENT >=

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

Line 1614: fnd_log.g_current_runtime_level) then

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

Line 1615: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

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

Line 1628: if (fnd_log.LEVEL_PROCEDURE >=

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

Line 1629: fnd_log.g_current_runtime_level) then

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

Line 1630: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

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

Line 1637: if (fnd_log.LEVEL_PROCEDURE >=

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

Line 1638: fnd_log.g_current_runtime_level) then

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

Line 1639: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

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

Line 1648: if (fnd_log.LEVEL_PROCEDURE >=

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

Line 1649: fnd_log.g_current_runtime_level) then

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

Line 1650: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

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

Line 1675: if (fnd_log.LEVEL_EXCEPTION >=

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

Line 1676: fnd_log.g_current_runtime_level) then

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

Line 1677: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

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

Line 1681: if (fnd_log.LEVEL_PROCEDURE >=

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

Line 1682: fnd_log.g_current_runtime_level) then

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

Line 1683: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 1732: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

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

Line 1756: if (fnd_log.LEVEL_EXCEPTION >=

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

Line 1757: fnd_log.g_current_runtime_level) then

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

Line 1758: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

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

Line 1774: if (fnd_log.LEVEL_EXCEPTION >=

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

Line 1775: fnd_log.g_current_runtime_level) then

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

Line 1776: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

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

Line 1823: if (fnd_log.LEVEL_EXCEPTION >=

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

Line 1824: fnd_log.g_current_runtime_level) then

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

Line 1825: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

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

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

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

Line 1849: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

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

Line 1856: if (fnd_log.LEVEL_EXCEPTION >=

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

Line 1857: fnd_log.g_current_runtime_level) then

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

Line 1858: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

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

Line 1873: if (fnd_log.LEVEL_PROCEDURE >=

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

Line 1874: fnd_log.g_current_runtime_level) then

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

Line 1875: fnd_log.message(FND_LOG.LEVEL_PROCEDURE,

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

Line 1886: if (fnd_log.LEVEL_STATEMENT >=

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

Line 1887: fnd_log.g_current_runtime_level) then

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

Line 1888: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

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

Line 1924: if (fnd_log.LEVEL_STATEMENT >=

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

Line 1925: fnd_log.g_current_runtime_level) then

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

Line 1926: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

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

Line 1940: if (fnd_log.LEVEL_PROCEDURE >=

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

Line 1941: fnd_log.g_current_runtime_level) then

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

Line 1942: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

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

Line 1948: if (fnd_log.LEVEL_PROCEDURE >=

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

Line 1949: fnd_log.g_current_runtime_level) then

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

Line 1950: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

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

Line 1977: if (fnd_log.LEVEL_EXCEPTION >=

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

Line 1978: fnd_log.g_current_runtime_level) then

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

Line 1979: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

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

Line 1983: if (fnd_log.LEVEL_PROCEDURE >=

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

Line 1984: fnd_log.g_current_runtime_level) then

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

Line 1985: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 2023: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 2046: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

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

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

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

Line 2079: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

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

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

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

Line 2101: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 2307: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

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

Line 2361: if (fnd_log.LEVEL_EXCEPTION >=

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

Line 2362: fnd_log.g_current_runtime_level) then

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

Line 2363: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

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

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

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

Line 2375: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

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

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

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

Line 2382: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

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

Line 2417: if (fnd_log.LEVEL_EXCEPTION >=

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

Line 2418: fnd_log.g_current_runtime_level) then

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

Line 2419: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

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

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

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

Line 2427: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

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

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

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

Line 2448: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

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

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

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

Line 2461: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

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

Line 2466: if (fnd_log.LEVEL_STATEMENT >=

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

Line 2467: fnd_log.g_current_runtime_level) then

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

Line 2468: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

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

Line 2474: if (fnd_log.LEVEL_STATEMENT >=

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

Line 2475: fnd_log.g_current_runtime_level) then

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

Line 2476: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

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

Line 2482: if (fnd_log.LEVEL_STATEMENT >=

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

Line 2483: fnd_log.g_current_runtime_level) then

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

Line 2484: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

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

Line 2490: if (fnd_log.LEVEL_STATEMENT >=

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

Line 2491: fnd_log.g_current_runtime_level) then

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

Line 2492: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

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

Line 2500: if (fnd_log.LEVEL_STATEMENT >=

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

Line 2501: fnd_log.g_current_runtime_level) then

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

Line 2502: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

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

Line 2511: if (fnd_log.LEVEL_STATEMENT >=

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

Line 2512: fnd_log.g_current_runtime_level) then

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

Line 2513: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

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

Line 2525: if (fnd_log.LEVEL_EXCEPTION >=

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

Line 2526: fnd_log.g_current_runtime_level) then

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

Line 2527: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

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

Line 2558: if (fnd_log.LEVEL_EXCEPTION >=

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

Line 2559: fnd_log.g_current_runtime_level) then

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

Line 2560: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

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

Line 2575: if (fnd_log.LEVEL_EXCEPTION >=

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

Line 2576: fnd_log.g_current_runtime_level) then

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

Line 2577: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

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

Line 2598: if (fnd_log.LEVEL_PROCEDURE >=

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

Line 2599: fnd_log.g_current_runtime_level) then

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

Line 2600: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

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

Line 2616: if (fnd_log.LEVEL_EXCEPTION >=

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

Line 2617: fnd_log.g_current_runtime_level) then

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

Line 2618: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

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

Line 2638: if (fnd_log.LEVEL_EXCEPTION >=

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

Line 2639: fnd_log.g_current_runtime_level) then

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

Line 2640: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

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

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

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

Line 2790: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

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

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

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

Line 2802: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

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

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

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

Line 2809: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

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

Line 2832: if (fnd_log.LEVEL_STATEMENT >=

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

Line 2833: fnd_log.g_current_runtime_level) then

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

Line 2834: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

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

Line 2849: if (fnd_log.LEVEL_STATEMENT >=

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

Line 2850: fnd_log.g_current_runtime_level) then

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

Line 2851: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

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

Line 2862: if (fnd_log.LEVEL_STATEMENT >=

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

Line 2863: fnd_log.g_current_runtime_level) then

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

Line 2864: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

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

Line 2879: if (fnd_log.LEVEL_STATEMENT >=

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

Line 2880: fnd_log.g_current_runtime_level) then

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

Line 2881: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

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

Line 2896: if (fnd_log.LEVEL_STATEMENT >=

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

Line 2897: fnd_log.g_current_runtime_level) then

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

Line 2898: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

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

Line 2909: if (fnd_log.LEVEL_STATEMENT >=

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

Line 2910: fnd_log.g_current_runtime_level) then

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

Line 2911: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

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

Line 2929: if (fnd_log.LEVEL_STATEMENT >=

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

Line 2930: fnd_log.g_current_runtime_level) then

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

Line 2931: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

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

Line 2946: if (fnd_log.LEVEL_STATEMENT >=

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

Line 2947: fnd_log.g_current_runtime_level) then

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

Line 2948: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

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

Line 2959: if (fnd_log.LEVEL_STATEMENT >=

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

Line 2960: fnd_log.g_current_runtime_level) then

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

Line 2961: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

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

Line 2983: if (fnd_log.LEVEL_STATEMENT >=

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

Line 2984: fnd_log.g_current_runtime_level) then

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

Line 2985: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

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

Line 2994: if (fnd_log.LEVEL_PROCEDURE >=

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

Line 2995: fnd_log.g_current_runtime_level) then

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

Line 2996: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 3065: fnd_log.message(FND_LOG.LEVEL_PROCEDURE,

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

Line 3090: if (fnd_log.LEVEL_EXCEPTION >=

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

Line 3091: fnd_log.g_current_runtime_level) then

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

Line 3092: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

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

Line 3097: if (fnd_log.LEVEL_PROCEDURE >=

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

Line 3098: fnd_log.g_current_runtime_level) then

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

Line 3099: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 3725: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

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

Line 3753: if (fnd_log.LEVEL_EXCEPTION >=

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

Line 3754: fnd_log.g_current_runtime_level) then

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

Line 3755: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

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

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

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

Line 3767: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

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

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

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

Line 3773: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

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

Line 3808: if (fnd_log.LEVEL_EXCEPTION >=

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

Line 3809: fnd_log.g_current_runtime_level) then

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

Line 3810: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

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

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

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

Line 3821: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

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

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

3881: x_return_status := g_gsp_return_status;
3882: x_object_id := g_gsp_object_id;
3883: x_function_id := g_gsp_function_id;
3884: x_bind_order := g_gsp_bind_order;
3885: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
3886: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
3887: c_log_head || l_api_name || '.end_cachehit',
3888: 'x_predicate: '|| x_predicate ||
3889: ', x_return_status:'||x_return_status||

Line 3886: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

3882: x_object_id := g_gsp_object_id;
3883: x_function_id := g_gsp_function_id;
3884: x_bind_order := g_gsp_bind_order;
3885: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
3886: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
3887: c_log_head || l_api_name || '.end_cachehit',
3888: 'x_predicate: '|| x_predicate ||
3889: ', x_return_status:'||x_return_status||
3890: ', x_object_id:'||x_object_id||

Line 3908: if (fnd_log.LEVEL_EXCEPTION >=

3904: fnd_message.set_token('ROUTINE',
3905: c_pkg_name || '.'|| l_api_name);
3906: fnd_message.set_token('REASON',
3907: 'Unsupported p_statement_type: '|| p_statement_type);
3908: if (fnd_log.LEVEL_EXCEPTION >=
3909: fnd_log.g_current_runtime_level) then
3910: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3911: c_log_head || l_api_name || '.end_bad_stm_typ',
3912: FALSE);

Line 3909: fnd_log.g_current_runtime_level) then

3905: c_pkg_name || '.'|| l_api_name);
3906: fnd_message.set_token('REASON',
3907: 'Unsupported p_statement_type: '|| p_statement_type);
3908: if (fnd_log.LEVEL_EXCEPTION >=
3909: fnd_log.g_current_runtime_level) then
3910: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3911: c_log_head || l_api_name || '.end_bad_stm_typ',
3912: FALSE);
3913: end if;

Line 3910: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

3906: fnd_message.set_token('REASON',
3907: 'Unsupported p_statement_type: '|| p_statement_type);
3908: if (fnd_log.LEVEL_EXCEPTION >=
3909: fnd_log.g_current_runtime_level) then
3910: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3911: c_log_head || l_api_name || '.end_bad_stm_typ',
3912: FALSE);
3913: end if;
3914: x_return_status := 'U'; /* Unexpected Error */

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

3920: if (FND_FUNCTION.G_ALREADY_FAST_COMPILED <> 'T') then
3921: FND_FUNCTION.FAST_COMPILE;
3922: end if;
3923:
3924: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
3925: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
3926: c_log_head || l_api_name || '.step1start',
3927: 'p_grant_instance_type:'||p_grant_instance_type);
3928: end if;

Line 3925: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

3921: FND_FUNCTION.FAST_COMPILE;
3922: end if;
3923:
3924: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
3925: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
3926: c_log_head || l_api_name || '.step1start',
3927: 'p_grant_instance_type:'||p_grant_instance_type);
3928: end if;
3929:

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

3957: 'The user_name passed or defaulted is not a valid user_name '||
3958: 'in wf_user_roles. '||
3959: 'Invalid user_name: '||l_user_name ||
3960: ' Passed p_user_name: '||p_user_name);
3961: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3962: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3963: c_log_head || l_api_name || '.end_no_wf_user_role',
3964: FALSE);
3965: end if;

Line 3962: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

3958: 'in wf_user_roles. '||
3959: 'Invalid user_name: '||l_user_name ||
3960: ' Passed p_user_name: '||p_user_name);
3961: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3962: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3963: c_log_head || l_api_name || '.end_no_wf_user_role',
3964: FALSE);
3965: end if;
3966:

Line 3974: if (fnd_log.LEVEL_STATEMENT >=

3970: end if;
3971:
3972: /* Set up flags depending on which mode we are running in. */
3973: IF (p_grant_instance_type = C_TYPE_INSTANCE) THEN
3974: if (fnd_log.LEVEL_STATEMENT >=
3975: fnd_log.g_current_runtime_level) then
3976: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
3977: c_log_head || l_api_name || '.chk_instance',
3978: ' l_instance_set_flag := FALSE ');

Line 3975: fnd_log.g_current_runtime_level) then

3971:
3972: /* Set up flags depending on which mode we are running in. */
3973: IF (p_grant_instance_type = C_TYPE_INSTANCE) THEN
3974: if (fnd_log.LEVEL_STATEMENT >=
3975: fnd_log.g_current_runtime_level) then
3976: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
3977: c_log_head || l_api_name || '.chk_instance',
3978: ' l_instance_set_flag := FALSE ');
3979: end if;

Line 3976: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

3972: /* Set up flags depending on which mode we are running in. */
3973: IF (p_grant_instance_type = C_TYPE_INSTANCE) THEN
3974: if (fnd_log.LEVEL_STATEMENT >=
3975: fnd_log.g_current_runtime_level) then
3976: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
3977: c_log_head || l_api_name || '.chk_instance',
3978: ' l_instance_set_flag := FALSE ');
3979: end if;
3980: l_instance_set_flag:= FALSE;

Line 3982: if (fnd_log.LEVEL_STATEMENT >=

3978: ' l_instance_set_flag := FALSE ');
3979: end if;
3980: l_instance_set_flag:= FALSE;
3981: ELSIF (p_grant_instance_type = C_TYPE_SET) THEN
3982: if (fnd_log.LEVEL_STATEMENT >=
3983: fnd_log.g_current_runtime_level) then
3984: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
3985: c_log_head || l_api_name || '.chk_set',
3986: ' l_instance_flag := FALSE ');

Line 3983: fnd_log.g_current_runtime_level) then

3979: end if;
3980: l_instance_set_flag:= FALSE;
3981: ELSIF (p_grant_instance_type = C_TYPE_SET) THEN
3982: if (fnd_log.LEVEL_STATEMENT >=
3983: fnd_log.g_current_runtime_level) then
3984: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
3985: c_log_head || l_api_name || '.chk_set',
3986: ' l_instance_flag := FALSE ');
3987: end if;

Line 3984: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

3980: l_instance_set_flag:= FALSE;
3981: ELSIF (p_grant_instance_type = C_TYPE_SET) THEN
3982: if (fnd_log.LEVEL_STATEMENT >=
3983: fnd_log.g_current_runtime_level) then
3984: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
3985: c_log_head || l_api_name || '.chk_set',
3986: ' l_instance_flag := FALSE ');
3987: end if;
3988: l_instance_flag:= FALSE;

Line 3990: if (fnd_log.LEVEL_STATEMENT >=

3986: ' l_instance_flag := FALSE ');
3987: end if;
3988: l_instance_flag:= FALSE;
3989: ELSIF (p_grant_instance_type = 'UNIVERSAL') THEN
3990: if (fnd_log.LEVEL_STATEMENT >=
3991: fnd_log.g_current_runtime_level) then
3992: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
3993: c_log_head || l_api_name || '.chk_universal',
3994: ' ');

Line 3991: fnd_log.g_current_runtime_level) then

3987: end if;
3988: l_instance_flag:= FALSE;
3989: ELSIF (p_grant_instance_type = 'UNIVERSAL') THEN
3990: if (fnd_log.LEVEL_STATEMENT >=
3991: fnd_log.g_current_runtime_level) then
3992: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
3993: c_log_head || l_api_name || '.chk_universal',
3994: ' ');
3995: end if;

Line 3992: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

3988: l_instance_flag:= FALSE;
3989: ELSIF (p_grant_instance_type = 'UNIVERSAL') THEN
3990: if (fnd_log.LEVEL_STATEMENT >=
3991: fnd_log.g_current_runtime_level) then
3992: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
3993: c_log_head || l_api_name || '.chk_universal',
3994: ' ');
3995: end if;
3996: END IF;

Line 4013: if (fnd_log.LEVEL_EXCEPTION >=

4009: fnd_message.set_token('ROUTINE',
4010: c_pkg_name || '.'|| l_api_name);
4011: fnd_message.set_token('REASON',
4012: 'The parameter p_object_name can not be NULL.');
4013: if (fnd_log.LEVEL_EXCEPTION >=
4014: fnd_log.g_current_runtime_level) then
4015: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
4016: c_log_head || l_api_name || '.end_null_obj',
4017: FALSE);

Line 4014: fnd_log.g_current_runtime_level) then

4010: c_pkg_name || '.'|| l_api_name);
4011: fnd_message.set_token('REASON',
4012: 'The parameter p_object_name can not be NULL.');
4013: if (fnd_log.LEVEL_EXCEPTION >=
4014: fnd_log.g_current_runtime_level) then
4015: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
4016: c_log_head || l_api_name || '.end_null_obj',
4017: FALSE);
4018: end if;

Line 4015: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

4011: fnd_message.set_token('REASON',
4012: 'The parameter p_object_name can not be NULL.');
4013: if (fnd_log.LEVEL_EXCEPTION >=
4014: fnd_log.g_current_runtime_level) then
4015: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
4016: c_log_head || l_api_name || '.end_null_obj',
4017: FALSE);
4018: end if;
4019: x_return_status := 'U';

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

4025: fnd_message.set_token('ROUTINE',
4026: c_pkg_name || '.'|| l_api_name);
4027: fnd_message.set_token('REASON',
4028: 'The parameter p_object_name can not be ''GLOBAL''. ');
4029: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
4030: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
4031: c_log_head || l_api_name || '.end_glob_obj',
4032: FALSE);
4033: end if;

Line 4030: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

4026: c_pkg_name || '.'|| l_api_name);
4027: fnd_message.set_token('REASON',
4028: 'The parameter p_object_name can not be ''GLOBAL''. ');
4029: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
4030: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
4031: c_log_head || l_api_name || '.end_glob_obj',
4032: FALSE);
4033: end if;
4034: x_return_status := 'U';

Line 4052: if (fnd_log.LEVEL_PROCEDURE >=

4048: l_db_object_name,
4049: p_table_alias,
4050: 'GNT');
4051: if (x_return_status <> 'T') then
4052: if (fnd_log.LEVEL_PROCEDURE >=
4053: fnd_log.g_current_runtime_level) then
4054: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
4055: c_log_head || l_api_name || '.end_pk_info_err',
4056: 'returning status: '|| x_return_status);

Line 4053: fnd_log.g_current_runtime_level) then

4049: p_table_alias,
4050: 'GNT');
4051: if (x_return_status <> 'T') then
4052: if (fnd_log.LEVEL_PROCEDURE >=
4053: fnd_log.g_current_runtime_level) then
4054: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
4055: c_log_head || l_api_name || '.end_pk_info_err',
4056: 'returning status: '|| x_return_status);
4057: end if;

Line 4054: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

4050: 'GNT');
4051: if (x_return_status <> 'T') then
4052: if (fnd_log.LEVEL_PROCEDURE >=
4053: fnd_log.g_current_runtime_level) then
4054: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
4055: c_log_head || l_api_name || '.end_pk_info_err',
4056: 'returning status: '|| x_return_status);
4057: end if;
4058: /* There will be a message on the msg dict stack. */

Line 4079: if (fnd_log.LEVEL_EXCEPTION >=

4075: c_pkg_name || '.'|| l_api_name);
4076: fnd_message.set_token('REASON',
4077: 'The parameter value p_object_name is not a valid object.'||
4078: ' p_object_name:'||p_object_name);
4079: if (fnd_log.LEVEL_EXCEPTION >=
4080: fnd_log.g_current_runtime_level) then
4081: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
4082: c_log_head || l_api_name || '.end_bad_obj',
4083: FALSE);

Line 4080: fnd_log.g_current_runtime_level) then

4076: fnd_message.set_token('REASON',
4077: 'The parameter value p_object_name is not a valid object.'||
4078: ' p_object_name:'||p_object_name);
4079: if (fnd_log.LEVEL_EXCEPTION >=
4080: fnd_log.g_current_runtime_level) then
4081: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
4082: c_log_head || l_api_name || '.end_bad_obj',
4083: FALSE);
4084: end if;

Line 4081: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

4077: 'The parameter value p_object_name is not a valid object.'||
4078: ' p_object_name:'||p_object_name);
4079: if (fnd_log.LEVEL_EXCEPTION >=
4080: fnd_log.g_current_runtime_level) then
4081: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
4082: c_log_head || l_api_name || '.end_bad_obj',
4083: FALSE);
4084: end if;
4085: x_return_status := 'U';

Line 4101: if (fnd_log.LEVEL_EXCEPTION >=

4097: c_pkg_name || '.'|| l_api_name);
4098: fnd_message.set_token('REASON',
4099: 'The parameter value p_function is not a valid function name.'||
4100: ' p_function:'||p_function);
4101: if (fnd_log.LEVEL_EXCEPTION >=
4102: fnd_log.g_current_runtime_level) then
4103: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
4104: c_log_head || l_api_name || '.end_bad_func',
4105: FALSE);

Line 4102: fnd_log.g_current_runtime_level) then

4098: fnd_message.set_token('REASON',
4099: 'The parameter value p_function is not a valid function name.'||
4100: ' p_function:'||p_function);
4101: if (fnd_log.LEVEL_EXCEPTION >=
4102: fnd_log.g_current_runtime_level) then
4103: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
4104: c_log_head || l_api_name || '.end_bad_func',
4105: FALSE);
4106: end if;

Line 4103: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

4099: 'The parameter value p_function is not a valid function name.'||
4100: ' p_function:'||p_function);
4101: if (fnd_log.LEVEL_EXCEPTION >=
4102: fnd_log.g_current_runtime_level) then
4103: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
4104: c_log_head || l_api_name || '.end_bad_func',
4105: FALSE);
4106: end if;
4107: x_return_status := 'U';

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

4376: /* in scope, so just return 1=1 */
4377: if(l_global_instance_type = TRUE) then
4378: l_aggregate_predicate := '1=1';
4379: x_return_status := 'T';
4380: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
4381: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4382: c_log_head || l_api_name || '.11global_inst',
4383: 'l_aggregate_predicate: '|| l_aggregate_predicate ||
4384: ', x_return_status:'||x_return_status);

Line 4381: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4377: if(l_global_instance_type = TRUE) then
4378: l_aggregate_predicate := '1=1';
4379: x_return_status := 'T';
4380: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
4381: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4382: c_log_head || l_api_name || '.11global_inst',
4383: 'l_aggregate_predicate: '|| l_aggregate_predicate ||
4384: ', x_return_status:'||x_return_status);
4385: end if;

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

4393: l_inst_instance_type = FALSE and
4394: l_set_instance_type = FALSE) then
4395: l_aggregate_predicate := '1=2';
4396: x_return_status := 'T';
4397: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
4398: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4399: c_log_head || l_api_name || '.12no_inst',
4400: 'l_aggregate_predicate: '|| l_aggregate_predicate ||
4401: ', x_return_status:'||x_return_status);

Line 4398: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4394: l_set_instance_type = FALSE) then
4395: l_aggregate_predicate := '1=2';
4396: x_return_status := 'T';
4397: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
4398: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4399: c_log_head || l_api_name || '.12no_inst',
4400: 'l_aggregate_predicate: '|| l_aggregate_predicate ||
4401: ', x_return_status:'||x_return_status);
4402: end if;

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

4408: if(l_inst_instance_type = TRUE and
4409: l_inst_group_grantee_type = FALSE and
4410: l_inst_global_grantee_type = FALSE) then
4411: l_set_instance_type := TRUE;
4412: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
4413: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
4414: c_log_head || l_api_name || '.err_inst_no_gnt_typ',
4415: 'x_predicate: '|| x_predicate);
4416: end if;

Line 4413: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

4409: l_inst_group_grantee_type = FALSE and
4410: l_inst_global_grantee_type = FALSE) then
4411: l_set_instance_type := TRUE;
4412: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
4413: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
4414: c_log_head || l_api_name || '.err_inst_no_gnt_typ',
4415: 'x_predicate: '|| x_predicate);
4416: end if;
4417: end if;

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

4418:
4419: /* Build up the instance set part of the predicate */
4420: l_last_pred := '*NO_PRED*';
4421: if(l_set_instance_type = TRUE) then
4422: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
4423: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4424: c_log_head || l_api_name || '.in_set_instyp',
4425: '.');
4426: end if;

Line 4423: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4419: /* Build up the instance set part of the predicate */
4420: l_last_pred := '*NO_PRED*';
4421: if(l_set_instance_type = TRUE) then
4422: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
4423: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4424: c_log_head || l_api_name || '.in_set_instyp',
4425: '.');
4426: end if;
4427:

Line 4447: if (fnd_log.LEVEL_STATEMENT >=

4443: OPEN isg_grp_glob_fn_c ( l_user_name,
4444: l_function_id,
4445: l_object_id);
4446: l_grp_glob_fn := TRUE;
4447: if (fnd_log.LEVEL_STATEMENT >=
4448: fnd_log.g_current_runtime_level) then
4449: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4450: c_log_head || l_api_name || '.open_grp_glob_fn_cursor',
4451: ' open');

Line 4448: fnd_log.g_current_runtime_level) then

4444: l_function_id,
4445: l_object_id);
4446: l_grp_glob_fn := TRUE;
4447: if (fnd_log.LEVEL_STATEMENT >=
4448: fnd_log.g_current_runtime_level) then
4449: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4450: c_log_head || l_api_name || '.open_grp_glob_fn_cursor',
4451: ' open');
4452: end if;

Line 4449: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4445: l_object_id);
4446: l_grp_glob_fn := TRUE;
4447: if (fnd_log.LEVEL_STATEMENT >=
4448: fnd_log.g_current_runtime_level) then
4449: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4450: c_log_head || l_api_name || '.open_grp_glob_fn_cursor',
4451: ' open');
4452: end if;
4453: elsif( l_set_group_grantee_type

Line 4461: if (fnd_log.LEVEL_STATEMENT >=

4457: --- Fix Non Backward change made for universal person support
4458: /*OPEN isg_grp_glob_nofn_c ( l_user_name,
4459: l_object_id);
4460: l_grp_glob_nofn := TRUE;
4461: if (fnd_log.LEVEL_STATEMENT >=
4462: fnd_log.g_current_runtime_level) then
4463: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4464: c_log_head || l_api_name || '.open_grp_glob_nofn_cursor',
4465: ' open');

Line 4462: fnd_log.g_current_runtime_level) then

4458: /*OPEN isg_grp_glob_nofn_c ( l_user_name,
4459: l_object_id);
4460: l_grp_glob_nofn := TRUE;
4461: if (fnd_log.LEVEL_STATEMENT >=
4462: fnd_log.g_current_runtime_level) then
4463: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4464: c_log_head || l_api_name || '.open_grp_glob_nofn_cursor',
4465: ' open');
4466: end if;*/

Line 4463: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4459: l_object_id);
4460: l_grp_glob_nofn := TRUE;
4461: if (fnd_log.LEVEL_STATEMENT >=
4462: fnd_log.g_current_runtime_level) then
4463: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4464: c_log_head || l_api_name || '.open_grp_glob_nofn_cursor',
4465: ' open');
4466: end if;*/
4467: if (colon <> 0) then

Line 4471: if (fnd_log.LEVEL_STATEMENT >=

4467: if (colon <> 0) then
4468: OPEN isg_grp_glob_nofn_bkwd_c ( l_user_name,
4469: l_object_id);
4470: l_grp_glob_nofn := TRUE;
4471: if (fnd_log.LEVEL_STATEMENT >=
4472: fnd_log.g_current_runtime_level) then
4473: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4474: c_log_head || l_api_name ||
4475: '.open_grp_glob_nofn_bkwd_cursor',

Line 4472: fnd_log.g_current_runtime_level) then

4468: OPEN isg_grp_glob_nofn_bkwd_c ( l_user_name,
4469: l_object_id);
4470: l_grp_glob_nofn := TRUE;
4471: if (fnd_log.LEVEL_STATEMENT >=
4472: fnd_log.g_current_runtime_level) then
4473: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4474: c_log_head || l_api_name ||
4475: '.open_grp_glob_nofn_bkwd_cursor',
4476: ' open');

Line 4473: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4469: l_object_id);
4470: l_grp_glob_nofn := TRUE;
4471: if (fnd_log.LEVEL_STATEMENT >=
4472: fnd_log.g_current_runtime_level) then
4473: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4474: c_log_head || l_api_name ||
4475: '.open_grp_glob_nofn_bkwd_cursor',
4476: ' open');
4477: end if;

Line 4482: if (fnd_log.LEVEL_STATEMENT >=

4478: else
4479: OPEN isg_grp_glob_nofn_c ( l_user_name,
4480: l_object_id);
4481: l_grp_glob_nofn := TRUE;
4482: if (fnd_log.LEVEL_STATEMENT >=
4483: fnd_log.g_current_runtime_level) then
4484: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4485: c_log_head || l_api_name || '.open_grp_glob_nofn_cursor',
4486: ' open');

Line 4483: fnd_log.g_current_runtime_level) then

4479: OPEN isg_grp_glob_nofn_c ( l_user_name,
4480: l_object_id);
4481: l_grp_glob_nofn := TRUE;
4482: if (fnd_log.LEVEL_STATEMENT >=
4483: fnd_log.g_current_runtime_level) then
4484: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4485: c_log_head || l_api_name || '.open_grp_glob_nofn_cursor',
4486: ' open');
4487: end if;

Line 4484: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4480: l_object_id);
4481: l_grp_glob_nofn := TRUE;
4482: if (fnd_log.LEVEL_STATEMENT >=
4483: fnd_log.g_current_runtime_level) then
4484: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4485: c_log_head || l_api_name || '.open_grp_glob_nofn_cursor',
4486: ' open');
4487: end if;
4488: end if;

Line 4496: if (fnd_log.LEVEL_STATEMENT >=

4492: /*OPEN isg_grp_fn_c ( l_user_name,
4493: l_function_id,
4494: l_object_id);
4495: l_grp_fn := TRUE;
4496: if (fnd_log.LEVEL_STATEMENT >=
4497: fnd_log.g_current_runtime_level) then
4498: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4499: c_log_head || l_api_name || '.open_grp_fn_cursor',
4500: ' open');

Line 4497: fnd_log.g_current_runtime_level) then

4493: l_function_id,
4494: l_object_id);
4495: l_grp_fn := TRUE;
4496: if (fnd_log.LEVEL_STATEMENT >=
4497: fnd_log.g_current_runtime_level) then
4498: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4499: c_log_head || l_api_name || '.open_grp_fn_cursor',
4500: ' open');
4501: end if;*/

Line 4498: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4494: l_object_id);
4495: l_grp_fn := TRUE;
4496: if (fnd_log.LEVEL_STATEMENT >=
4497: fnd_log.g_current_runtime_level) then
4498: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4499: c_log_head || l_api_name || '.open_grp_fn_cursor',
4500: ' open');
4501: end if;*/
4502:

Line 4508: if (fnd_log.LEVEL_STATEMENT >=

4504: OPEN isg_grp_fn_bkwd_c (l_user_name,
4505: l_function_id,
4506: l_object_id);
4507: l_grp_fn := TRUE;
4508: if (fnd_log.LEVEL_STATEMENT >=
4509: fnd_log.g_current_runtime_level) then
4510: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4511: c_log_head || l_api_name || '.open_grp_fn_bkwd_cursor',
4512: ' open');

Line 4509: fnd_log.g_current_runtime_level) then

4505: l_function_id,
4506: l_object_id);
4507: l_grp_fn := TRUE;
4508: if (fnd_log.LEVEL_STATEMENT >=
4509: fnd_log.g_current_runtime_level) then
4510: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4511: c_log_head || l_api_name || '.open_grp_fn_bkwd_cursor',
4512: ' open');
4513: end if;

Line 4510: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4506: l_object_id);
4507: l_grp_fn := TRUE;
4508: if (fnd_log.LEVEL_STATEMENT >=
4509: fnd_log.g_current_runtime_level) then
4510: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4511: c_log_head || l_api_name || '.open_grp_fn_bkwd_cursor',
4512: ' open');
4513: end if;
4514: else

Line 4519: if (fnd_log.LEVEL_STATEMENT >=

4515: OPEN isg_grp_fn_c (l_user_name,
4516: l_function_id,
4517: l_object_id);
4518: l_grp_fn := TRUE;
4519: if (fnd_log.LEVEL_STATEMENT >=
4520: fnd_log.g_current_runtime_level) then
4521: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4522: c_log_head || l_api_name || '.open_grp_fn_cursor',
4523: ' open');

Line 4520: fnd_log.g_current_runtime_level) then

4516: l_function_id,
4517: l_object_id);
4518: l_grp_fn := TRUE;
4519: if (fnd_log.LEVEL_STATEMENT >=
4520: fnd_log.g_current_runtime_level) then
4521: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4522: c_log_head || l_api_name || '.open_grp_fn_cursor',
4523: ' open');
4524: end if;

Line 4521: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4517: l_object_id);
4518: l_grp_fn := TRUE;
4519: if (fnd_log.LEVEL_STATEMENT >=
4520: fnd_log.g_current_runtime_level) then
4521: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4522: c_log_head || l_api_name || '.open_grp_fn_cursor',
4523: ' open');
4524: end if;
4525: end if;

Line 4534: if (fnd_log.LEVEL_STATEMENT >=

4530: -- Fix Non Backward change made for universal person support
4531: /*OPEN isg_grp_nofn_c ( l_user_name,
4532: l_object_id);
4533: l_grp_nofn := TRUE;
4534: if (fnd_log.LEVEL_STATEMENT >=
4535: fnd_log.g_current_runtime_level) then
4536: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4537: c_log_head || l_api_name || '.open_grp_nofn_cursor',
4538: ' open');

Line 4535: fnd_log.g_current_runtime_level) then

4531: /*OPEN isg_grp_nofn_c ( l_user_name,
4532: l_object_id);
4533: l_grp_nofn := TRUE;
4534: if (fnd_log.LEVEL_STATEMENT >=
4535: fnd_log.g_current_runtime_level) then
4536: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4537: c_log_head || l_api_name || '.open_grp_nofn_cursor',
4538: ' open');
4539: end if;*/

Line 4536: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4532: l_object_id);
4533: l_grp_nofn := TRUE;
4534: if (fnd_log.LEVEL_STATEMENT >=
4535: fnd_log.g_current_runtime_level) then
4536: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4537: c_log_head || l_api_name || '.open_grp_nofn_cursor',
4538: ' open');
4539: end if;*/
4540: if (colon <> 0) then

Line 4544: if (fnd_log.LEVEL_STATEMENT >=

4540: if (colon <> 0) then
4541: OPEN isg_grp_nofn_bkwd_c (l_user_name,
4542: l_object_id);
4543: l_grp_nofn := TRUE;
4544: if (fnd_log.LEVEL_STATEMENT >=
4545: fnd_log.g_current_runtime_level) then
4546: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4547: c_log_head || l_api_name || '.open_grp_nofn_bkwd_cursor',
4548: ' open');

Line 4545: fnd_log.g_current_runtime_level) then

4541: OPEN isg_grp_nofn_bkwd_c (l_user_name,
4542: l_object_id);
4543: l_grp_nofn := TRUE;
4544: if (fnd_log.LEVEL_STATEMENT >=
4545: fnd_log.g_current_runtime_level) then
4546: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4547: c_log_head || l_api_name || '.open_grp_nofn_bkwd_cursor',
4548: ' open');
4549: end if;

Line 4546: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4542: l_object_id);
4543: l_grp_nofn := TRUE;
4544: if (fnd_log.LEVEL_STATEMENT >=
4545: fnd_log.g_current_runtime_level) then
4546: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4547: c_log_head || l_api_name || '.open_grp_nofn_bkwd_cursor',
4548: ' open');
4549: end if;
4550: else

Line 4554: if (fnd_log.LEVEL_STATEMENT >=

4550: else
4551: OPEN isg_grp_nofn_c (l_user_name,
4552: l_object_id);
4553: l_grp_nofn := TRUE;
4554: if (fnd_log.LEVEL_STATEMENT >=
4555: fnd_log.g_current_runtime_level) then
4556: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4557: c_log_head || l_api_name || '.open_grp_nofn_cursor',
4558: ' open');

Line 4555: fnd_log.g_current_runtime_level) then

4551: OPEN isg_grp_nofn_c (l_user_name,
4552: l_object_id);
4553: l_grp_nofn := TRUE;
4554: if (fnd_log.LEVEL_STATEMENT >=
4555: fnd_log.g_current_runtime_level) then
4556: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4557: c_log_head || l_api_name || '.open_grp_nofn_cursor',
4558: ' open');
4559: end if;

Line 4556: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4552: l_object_id);
4553: l_grp_nofn := TRUE;
4554: if (fnd_log.LEVEL_STATEMENT >=
4555: fnd_log.g_current_runtime_level) then
4556: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4557: c_log_head || l_api_name || '.open_grp_nofn_cursor',
4558: ' open');
4559: end if;
4560: end if;

Line 4568: if (fnd_log.LEVEL_STATEMENT >=

4564: OPEN isg_glob_fn_c (l_user_name,
4565: l_function_id,
4566: l_object_id);
4567: l_glob_fn := TRUE;
4568: if (fnd_log.LEVEL_STATEMENT >=
4569: fnd_log.g_current_runtime_level) then
4570: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4571: c_log_head || l_api_name || '.open_glob_fn_cursor',
4572: ' open');

Line 4569: fnd_log.g_current_runtime_level) then

4565: l_function_id,
4566: l_object_id);
4567: l_glob_fn := TRUE;
4568: if (fnd_log.LEVEL_STATEMENT >=
4569: fnd_log.g_current_runtime_level) then
4570: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4571: c_log_head || l_api_name || '.open_glob_fn_cursor',
4572: ' open');
4573: end if;

Line 4570: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4566: l_object_id);
4567: l_glob_fn := TRUE;
4568: if (fnd_log.LEVEL_STATEMENT >=
4569: fnd_log.g_current_runtime_level) then
4570: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4571: c_log_head || l_api_name || '.open_glob_fn_cursor',
4572: ' open');
4573: end if;
4574: elsif(NOT l_set_group_grantee_type

Line 4580: if (fnd_log.LEVEL_STATEMENT >=

4576: AND l_function_id = -1) then
4577: OPEN isg_glob_nofn_c (l_user_name,
4578: l_object_id);
4579: l_glob_nofn := TRUE;
4580: if (fnd_log.LEVEL_STATEMENT >=
4581: fnd_log.g_current_runtime_level) then
4582: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4583: c_log_head || l_api_name || '.open_glob_nofn_cursor',
4584: ' open');

Line 4581: fnd_log.g_current_runtime_level) then

4577: OPEN isg_glob_nofn_c (l_user_name,
4578: l_object_id);
4579: l_glob_nofn := TRUE;
4580: if (fnd_log.LEVEL_STATEMENT >=
4581: fnd_log.g_current_runtime_level) then
4582: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4583: c_log_head || l_api_name || '.open_glob_nofn_cursor',
4584: ' open');
4585: end if;

Line 4582: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4578: l_object_id);
4579: l_glob_nofn := TRUE;
4580: if (fnd_log.LEVEL_STATEMENT >=
4581: fnd_log.g_current_runtime_level) then
4582: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4583: c_log_head || l_api_name || '.open_glob_nofn_cursor',
4584: ' open');
4585: end if;
4586: else

Line 4592: if (fnd_log.LEVEL_EXCEPTION >=

4588: fnd_message.set_token('ROUTINE',
4589: c_pkg_name || '.'|| l_api_name);
4590: fnd_message.set_token('REASON',
4591: ' Fell through where we shouldnt have (1)');
4592: if (fnd_log.LEVEL_EXCEPTION >=
4593: fnd_log.g_current_runtime_level) then
4594: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
4595: c_log_head || l_api_name || '.end_fallthru1',
4596: FALSE);

Line 4593: fnd_log.g_current_runtime_level) then

4589: c_pkg_name || '.'|| l_api_name);
4590: fnd_message.set_token('REASON',
4591: ' Fell through where we shouldnt have (1)');
4592: if (fnd_log.LEVEL_EXCEPTION >=
4593: fnd_log.g_current_runtime_level) then
4594: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
4595: c_log_head || l_api_name || '.end_fallthru1',
4596: FALSE);
4597: end if;

Line 4594: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

4590: fnd_message.set_token('REASON',
4591: ' Fell through where we shouldnt have (1)');
4592: if (fnd_log.LEVEL_EXCEPTION >=
4593: fnd_log.g_current_runtime_level) then
4594: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
4595: c_log_head || l_api_name || '.end_fallthru1',
4596: FALSE);
4597: end if;
4598: x_return_status := 'U';

Line 4605: if (fnd_log.LEVEL_STATEMENT >=

4601:
4602: l_cursor_is_open := TRUE;
4603: LOOP
4604: if (l_grp_glob_fn) then
4605: if (fnd_log.LEVEL_STATEMENT >=
4606: fnd_log.g_current_runtime_level) then
4607: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4608: c_log_head || l_api_name || '.fetch_grp_glob_fn_cursor',
4609: ' fetch');

Line 4606: fnd_log.g_current_runtime_level) then

4602: l_cursor_is_open := TRUE;
4603: LOOP
4604: if (l_grp_glob_fn) then
4605: if (fnd_log.LEVEL_STATEMENT >=
4606: fnd_log.g_current_runtime_level) then
4607: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4608: c_log_head || l_api_name || '.fetch_grp_glob_fn_cursor',
4609: ' fetch');
4610: end if;

Line 4607: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4603: LOOP
4604: if (l_grp_glob_fn) then
4605: if (fnd_log.LEVEL_STATEMENT >=
4606: fnd_log.g_current_runtime_level) then
4607: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4608: c_log_head || l_api_name || '.fetch_grp_glob_fn_cursor',
4609: ' fetch');
4610: end if;
4611: FETCH isg_grp_glob_fn_c INTO d_predicate, d_instance_set_id,

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

4617: end if;
4618: elsif (l_grp_glob_nofn) then
4619: --Changes for Bug#3867925
4620: -- Fix Non Backward change made for universal person support
4621: /*if (fnd_log.LEVEL_STATEMENT >=
4622: fnd_log.g_current_runtime_level) then
4623: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4624: c_log_head || l_api_name || '.fetch_grp_glob_nofn_cursor',
4625: ' fetch');

Line 4622: fnd_log.g_current_runtime_level) then

4618: elsif (l_grp_glob_nofn) then
4619: --Changes for Bug#3867925
4620: -- Fix Non Backward change made for universal person support
4621: /*if (fnd_log.LEVEL_STATEMENT >=
4622: fnd_log.g_current_runtime_level) then
4623: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4624: c_log_head || l_api_name || '.fetch_grp_glob_nofn_cursor',
4625: ' fetch');
4626: end if;

Line 4623: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4619: --Changes for Bug#3867925
4620: -- Fix Non Backward change made for universal person support
4621: /*if (fnd_log.LEVEL_STATEMENT >=
4622: fnd_log.g_current_runtime_level) then
4623: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4624: c_log_head || l_api_name || '.fetch_grp_glob_nofn_cursor',
4625: ' fetch');
4626: end if;
4627: FETCH isg_grp_glob_nofn_c INTO d_predicate, d_instance_set_id,

Line 4636: if (fnd_log.LEVEL_STATEMENT >=

4632: exit; -- exit loop
4633: end if;*/
4634:
4635: if (colon <> 0) then
4636: if (fnd_log.LEVEL_STATEMENT >=
4637: fnd_log.g_current_runtime_level) then
4638: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4639: c_log_head || l_api_name ||
4640: '.fetch_grp_glob_nofn_bkwd_cursor',

Line 4637: fnd_log.g_current_runtime_level) then

4633: end if;*/
4634:
4635: if (colon <> 0) then
4636: if (fnd_log.LEVEL_STATEMENT >=
4637: fnd_log.g_current_runtime_level) then
4638: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4639: c_log_head || l_api_name ||
4640: '.fetch_grp_glob_nofn_bkwd_cursor',
4641: ' fetch');

Line 4638: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4634:
4635: if (colon <> 0) then
4636: if (fnd_log.LEVEL_STATEMENT >=
4637: fnd_log.g_current_runtime_level) then
4638: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4639: c_log_head || l_api_name ||
4640: '.fetch_grp_glob_nofn_bkwd_cursor',
4641: ' fetch');
4642: end if;

Line 4651: if (fnd_log.LEVEL_STATEMENT >=

4647: l_cursor_is_open := FALSE;
4648: exit; -- exit loop
4649: end if;
4650: else
4651: if (fnd_log.LEVEL_STATEMENT >=
4652: fnd_log.g_current_runtime_level) then
4653: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4654: c_log_head || l_api_name||'.fetch_grp_glob_nofn_cursor',
4655: ' fetch');

Line 4652: fnd_log.g_current_runtime_level) then

4648: exit; -- exit loop
4649: end if;
4650: else
4651: if (fnd_log.LEVEL_STATEMENT >=
4652: fnd_log.g_current_runtime_level) then
4653: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4654: c_log_head || l_api_name||'.fetch_grp_glob_nofn_cursor',
4655: ' fetch');
4656: end if;

Line 4653: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4649: end if;
4650: else
4651: if (fnd_log.LEVEL_STATEMENT >=
4652: fnd_log.g_current_runtime_level) then
4653: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4654: c_log_head || l_api_name||'.fetch_grp_glob_nofn_cursor',
4655: ' fetch');
4656: end if;
4657: FETCH isg_grp_glob_nofn_c

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

4665: end if;
4666: elsif (l_grp_fn) then
4667: --Changes for Bug#3867925
4668: -- Fix Non Backward change made for universal person support
4669: /*if (fnd_log.LEVEL_STATEMENT >=
4670: fnd_log.g_current_runtime_level) then
4671: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4672: c_log_head || l_api_name || '.fetch_grp_fn_cursor',
4673: ' fetch');

Line 4670: fnd_log.g_current_runtime_level) then

4666: elsif (l_grp_fn) then
4667: --Changes for Bug#3867925
4668: -- Fix Non Backward change made for universal person support
4669: /*if (fnd_log.LEVEL_STATEMENT >=
4670: fnd_log.g_current_runtime_level) then
4671: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4672: c_log_head || l_api_name || '.fetch_grp_fn_cursor',
4673: ' fetch');
4674: end if;

Line 4671: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4667: --Changes for Bug#3867925
4668: -- Fix Non Backward change made for universal person support
4669: /*if (fnd_log.LEVEL_STATEMENT >=
4670: fnd_log.g_current_runtime_level) then
4671: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4672: c_log_head || l_api_name || '.fetch_grp_fn_cursor',
4673: ' fetch');
4674: end if;
4675: FETCH isg_grp_fn_c INTO d_predicate, d_instance_set_id,

Line 4684: if (fnd_log.LEVEL_STATEMENT >=

4680: exit; -- exit loop
4681: end if;*/
4682:
4683: if (colon <> 0) then
4684: if (fnd_log.LEVEL_STATEMENT >=
4685: fnd_log.g_current_runtime_level) then
4686: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4687: c_log_head || l_api_name||'.fetch_grp_fn_bkwd_cursor',
4688: ' fetch');

Line 4685: fnd_log.g_current_runtime_level) then

4681: end if;*/
4682:
4683: if (colon <> 0) then
4684: if (fnd_log.LEVEL_STATEMENT >=
4685: fnd_log.g_current_runtime_level) then
4686: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4687: c_log_head || l_api_name||'.fetch_grp_fn_bkwd_cursor',
4688: ' fetch');
4689: end if;

Line 4686: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4682:
4683: if (colon <> 0) then
4684: if (fnd_log.LEVEL_STATEMENT >=
4685: fnd_log.g_current_runtime_level) then
4686: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4687: c_log_head || l_api_name||'.fetch_grp_fn_bkwd_cursor',
4688: ' fetch');
4689: end if;
4690: FETCH isg_grp_fn_bkwd_c INTO

Line 4699: if (fnd_log.LEVEL_STATEMENT >=

4695: l_cursor_is_open := FALSE;
4696: exit; -- exit loop
4697: end if;
4698: else
4699: if (fnd_log.LEVEL_STATEMENT >=
4700: fnd_log.g_current_runtime_level) then
4701: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4702: c_log_head || l_api_name || '.fetch_grp_fn_cursor',
4703: ' fetch');

Line 4700: fnd_log.g_current_runtime_level) then

4696: exit; -- exit loop
4697: end if;
4698: else
4699: if (fnd_log.LEVEL_STATEMENT >=
4700: fnd_log.g_current_runtime_level) then
4701: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4702: c_log_head || l_api_name || '.fetch_grp_fn_cursor',
4703: ' fetch');
4704: end if;

Line 4701: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4697: end if;
4698: else
4699: if (fnd_log.LEVEL_STATEMENT >=
4700: fnd_log.g_current_runtime_level) then
4701: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4702: c_log_head || l_api_name || '.fetch_grp_fn_cursor',
4703: ' fetch');
4704: end if;
4705: FETCH isg_grp_fn_c INTO d_predicate, d_instance_set_id,

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

4712: end if;
4713: elsif (l_grp_nofn) then
4714: --Changes for Bug#3867925
4715: -- Fix Non Backward change made for universal person support
4716: /*if (fnd_log.LEVEL_STATEMENT >=
4717: fnd_log.g_current_runtime_level) then
4718: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4719: c_log_head || l_api_name || '.fetch_grp_nofn_cursor',
4720: ' fetch');

Line 4717: fnd_log.g_current_runtime_level) then

4713: elsif (l_grp_nofn) then
4714: --Changes for Bug#3867925
4715: -- Fix Non Backward change made for universal person support
4716: /*if (fnd_log.LEVEL_STATEMENT >=
4717: fnd_log.g_current_runtime_level) then
4718: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4719: c_log_head || l_api_name || '.fetch_grp_nofn_cursor',
4720: ' fetch');
4721: end if;

Line 4718: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4714: --Changes for Bug#3867925
4715: -- Fix Non Backward change made for universal person support
4716: /*if (fnd_log.LEVEL_STATEMENT >=
4717: fnd_log.g_current_runtime_level) then
4718: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4719: c_log_head || l_api_name || '.fetch_grp_nofn_cursor',
4720: ' fetch');
4721: end if;
4722: FETCH isg_grp_nofn_c INTO d_predicate, d_instance_set_id,

Line 4731: if (fnd_log.LEVEL_STATEMENT >=

4727: exit; -- exit loop
4728: end if; */
4729:
4730: if (colon <> 0) then
4731: if (fnd_log.LEVEL_STATEMENT >=
4732: fnd_log.g_current_runtime_level) then
4733: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4734: c_log_head || l_api_name ||'.fetch_grp_nofn_bkwd_cursor',
4735: ' fetch');

Line 4732: fnd_log.g_current_runtime_level) then

4728: end if; */
4729:
4730: if (colon <> 0) then
4731: if (fnd_log.LEVEL_STATEMENT >=
4732: fnd_log.g_current_runtime_level) then
4733: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4734: c_log_head || l_api_name ||'.fetch_grp_nofn_bkwd_cursor',
4735: ' fetch');
4736: end if;

Line 4733: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4729:
4730: if (colon <> 0) then
4731: if (fnd_log.LEVEL_STATEMENT >=
4732: fnd_log.g_current_runtime_level) then
4733: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4734: c_log_head || l_api_name ||'.fetch_grp_nofn_bkwd_cursor',
4735: ' fetch');
4736: end if;
4737: FETCH isg_grp_nofn_bkwd_c

Line 4746: if (fnd_log.LEVEL_STATEMENT >=

4742: l_cursor_is_open := FALSE;
4743: exit; -- exit loop
4744: end if;
4745: else
4746: if (fnd_log.LEVEL_STATEMENT >=
4747: fnd_log.g_current_runtime_level) then
4748: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4749: c_log_head || l_api_name || '.fetch_grp_nofn_cursor',
4750: ' fetch');

Line 4747: fnd_log.g_current_runtime_level) then

4743: exit; -- exit loop
4744: end if;
4745: else
4746: if (fnd_log.LEVEL_STATEMENT >=
4747: fnd_log.g_current_runtime_level) then
4748: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4749: c_log_head || l_api_name || '.fetch_grp_nofn_cursor',
4750: ' fetch');
4751: end if;

Line 4748: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4744: end if;
4745: else
4746: if (fnd_log.LEVEL_STATEMENT >=
4747: fnd_log.g_current_runtime_level) then
4748: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4749: c_log_head || l_api_name || '.fetch_grp_nofn_cursor',
4750: ' fetch');
4751: end if;
4752: FETCH isg_grp_nofn_c INTO d_predicate, d_instance_set_id,

Line 4761: if (fnd_log.LEVEL_STATEMENT >=

4757: exit; -- exit loop
4758: end if;
4759: end if;
4760: elsif (l_glob_fn) then
4761: if (fnd_log.LEVEL_STATEMENT >=
4762: fnd_log.g_current_runtime_level) then
4763: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4764: c_log_head || l_api_name || '.fetch_glob_fn_cursor',
4765: ' fetch');

Line 4762: fnd_log.g_current_runtime_level) then

4758: end if;
4759: end if;
4760: elsif (l_glob_fn) then
4761: if (fnd_log.LEVEL_STATEMENT >=
4762: fnd_log.g_current_runtime_level) then
4763: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4764: c_log_head || l_api_name || '.fetch_glob_fn_cursor',
4765: ' fetch');
4766: end if;

Line 4763: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4759: end if;
4760: elsif (l_glob_fn) then
4761: if (fnd_log.LEVEL_STATEMENT >=
4762: fnd_log.g_current_runtime_level) then
4763: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4764: c_log_head || l_api_name || '.fetch_glob_fn_cursor',
4765: ' fetch');
4766: end if;
4767: FETCH isg_glob_fn_c INTO d_predicate, d_instance_set_id,

Line 4775: if (fnd_log.LEVEL_STATEMENT >=

4771: l_cursor_is_open := FALSE;
4772: exit; -- exit loop
4773: end if;
4774: elsif (l_glob_nofn) then
4775: if (fnd_log.LEVEL_STATEMENT >=
4776: fnd_log.g_current_runtime_level) then
4777: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4778: c_log_head || l_api_name || '.fetch_glob_nofn_cursor',
4779: ' fetch');

Line 4776: fnd_log.g_current_runtime_level) then

4772: exit; -- exit loop
4773: end if;
4774: elsif (l_glob_nofn) then
4775: if (fnd_log.LEVEL_STATEMENT >=
4776: fnd_log.g_current_runtime_level) then
4777: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4778: c_log_head || l_api_name || '.fetch_glob_nofn_cursor',
4779: ' fetch');
4780: end if;

Line 4777: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4773: end if;
4774: elsif (l_glob_nofn) then
4775: if (fnd_log.LEVEL_STATEMENT >=
4776: fnd_log.g_current_runtime_level) then
4777: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4778: c_log_head || l_api_name || '.fetch_glob_nofn_cursor',
4779: ' fetch');
4780: end if;
4781: FETCH isg_glob_nofn_c INTO d_predicate, d_instance_set_id,

Line 4794: if (fnd_log.LEVEL_EXCEPTION >=

4790: fnd_message.set_token('ROUTINE',
4791: c_pkg_name || '.'|| l_api_name);
4792: fnd_message.set_token('REASON',
4793: ' Fell through where we shouldnt have (2)');
4794: if (fnd_log.LEVEL_EXCEPTION >=
4795: fnd_log.g_current_runtime_level) then
4796: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
4797: c_log_head || l_api_name || '.end_fallthru2',
4798: FALSE);

Line 4795: fnd_log.g_current_runtime_level) then

4791: c_pkg_name || '.'|| l_api_name);
4792: fnd_message.set_token('REASON',
4793: ' Fell through where we shouldnt have (2)');
4794: if (fnd_log.LEVEL_EXCEPTION >=
4795: fnd_log.g_current_runtime_level) then
4796: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
4797: c_log_head || l_api_name || '.end_fallthru2',
4798: FALSE);
4799: end if;

Line 4796: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

4792: fnd_message.set_token('REASON',
4793: ' Fell through where we shouldnt have (2)');
4794: if (fnd_log.LEVEL_EXCEPTION >=
4795: fnd_log.g_current_runtime_level) then
4796: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
4797: c_log_head || l_api_name || '.end_fallthru2',
4798: FALSE);
4799: end if;
4800: x_return_status := 'U';

Line 4804: if (fnd_log.LEVEL_STATEMENT >=

4800: x_return_status := 'U';
4801: return;
4802: end if;
4803:
4804: if (fnd_log.LEVEL_STATEMENT >=
4805: fnd_log.g_current_runtime_level) then
4806: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4807: c_log_head || l_api_name || '.loop_isg',
4808: ' d_instance_set_id: '||

Line 4805: fnd_log.g_current_runtime_level) then

4801: return;
4802: end if;
4803:
4804: if (fnd_log.LEVEL_STATEMENT >=
4805: fnd_log.g_current_runtime_level) then
4806: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4807: c_log_head || l_api_name || '.loop_isg',
4808: ' d_instance_set_id: '||
4809: d_instance_set_id ||

Line 4806: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4802: end if;
4803:
4804: if (fnd_log.LEVEL_STATEMENT >=
4805: fnd_log.g_current_runtime_level) then
4806: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4807: c_log_head || l_api_name || '.loop_isg',
4808: ' d_instance_set_id: '||
4809: d_instance_set_id ||
4810: ' d_predicate: '||

Line 4824: if (fnd_log.LEVEL_STATEMENT >=

4820: l_aggregate_predicate := substrb( l_aggregate_predicate ||
4821: ') AND '|| l_pred ||')', 1, c_pred_buf_size);
4822: l_need_to_close_pred := FALSE;
4823: l_last_was_hextoraw := FALSE;
4824: if (fnd_log.LEVEL_STATEMENT >=
4825: fnd_log.g_current_runtime_level) then
4826: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4827: c_log_head || l_api_name || '.close_pred',
4828: 'l_pred:'||l_pred);

Line 4825: fnd_log.g_current_runtime_level) then

4821: ') AND '|| l_pred ||')', 1, c_pred_buf_size);
4822: l_need_to_close_pred := FALSE;
4823: l_last_was_hextoraw := FALSE;
4824: if (fnd_log.LEVEL_STATEMENT >=
4825: fnd_log.g_current_runtime_level) then
4826: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4827: c_log_head || l_api_name || '.close_pred',
4828: 'l_pred:'||l_pred);
4829: end if;

Line 4826: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4822: l_need_to_close_pred := FALSE;
4823: l_last_was_hextoraw := FALSE;
4824: if (fnd_log.LEVEL_STATEMENT >=
4825: fnd_log.g_current_runtime_level) then
4826: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4827: c_log_head || l_api_name || '.close_pred',
4828: 'l_pred:'||l_pred);
4829: end if;
4830: end if;

Line 4842: if (fnd_log.LEVEL_STATEMENT >=

4838: /* Upgrade and substitute predicate */
4839: l_pred := upgrade_predicate(
4840: d_predicate);
4841:
4842: if (fnd_log.LEVEL_STATEMENT >=
4843: fnd_log.g_current_runtime_level) then
4844: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4845: c_log_head || l_api_name || '.upgd_pred',
4846: 'l_pred:'||l_pred);

Line 4843: fnd_log.g_current_runtime_level) then

4839: l_pred := upgrade_predicate(
4840: d_predicate);
4841:
4842: if (fnd_log.LEVEL_STATEMENT >=
4843: fnd_log.g_current_runtime_level) then
4844: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4845: c_log_head || l_api_name || '.upgd_pred',
4846: 'l_pred:'||l_pred);
4847: end if;

Line 4844: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4840: d_predicate);
4841:
4842: if (fnd_log.LEVEL_STATEMENT >=
4843: fnd_log.g_current_runtime_level) then
4844: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4845: c_log_head || l_api_name || '.upgd_pred',
4846: 'l_pred:'||l_pred);
4847: end if;
4848:

Line 4861: if (fnd_log.LEVEL_STATEMENT >=

4857: l_pred := substitute_predicate(
4858: l_pred,
4859: p_table_alias);
4860:
4861: if (fnd_log.LEVEL_STATEMENT >=
4862: fnd_log.g_current_runtime_level) then
4863: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4864: c_log_head || l_api_name || '.subbed_pred',
4865: 'l_pred:'||l_pred);

Line 4862: fnd_log.g_current_runtime_level) then

4858: l_pred,
4859: p_table_alias);
4860:
4861: if (fnd_log.LEVEL_STATEMENT >=
4862: fnd_log.g_current_runtime_level) then
4863: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4864: c_log_head || l_api_name || '.subbed_pred',
4865: 'l_pred:'||l_pred);
4866: end if;

Line 4863: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4859: p_table_alias);
4860:
4861: if (fnd_log.LEVEL_STATEMENT >=
4862: fnd_log.g_current_runtime_level) then
4863: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4864: c_log_head || l_api_name || '.subbed_pred',
4865: 'l_pred:'||l_pred);
4866: end if;
4867:

Line 4876: if (fnd_log.LEVEL_STATEMENT >=

4872: substrb( l_aggregate_predicate ||
4873: '('|| l_pred ||')', 1, c_pred_buf_size);
4874: l_need_to_close_pred := FALSE;
4875: l_refers_to_grants := FALSE;
4876: if (fnd_log.LEVEL_STATEMENT >=
4877: fnd_log.g_current_runtime_level) then
4878: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4879: c_log_head || l_api_name || '.simple_pred',
4880: 'l_pred:'||l_pred);

Line 4877: fnd_log.g_current_runtime_level) then

4873: '('|| l_pred ||')', 1, c_pred_buf_size);
4874: l_need_to_close_pred := FALSE;
4875: l_refers_to_grants := FALSE;
4876: if (fnd_log.LEVEL_STATEMENT >=
4877: fnd_log.g_current_runtime_level) then
4878: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4879: c_log_head || l_api_name || '.simple_pred',
4880: 'l_pred:'||l_pred);
4881: end if;

Line 4878: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4874: l_need_to_close_pred := FALSE;
4875: l_refers_to_grants := FALSE;
4876: if (fnd_log.LEVEL_STATEMENT >=
4877: fnd_log.g_current_runtime_level) then
4878: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4879: c_log_head || l_api_name || '.simple_pred',
4880: 'l_pred:'||l_pred);
4881: end if;
4882: else /* Has references to grant table so we subselect */

Line 4892: if (fnd_log.LEVEL_STATEMENT >=

4888: ' where gnt.grant_guid in (',
4889: 1, c_pred_buf_size);
4890: l_need_to_close_pred := TRUE;
4891: l_refers_to_grants := TRUE;
4892: if (fnd_log.LEVEL_STATEMENT >=
4893: fnd_log.g_current_runtime_level) then
4894: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4895: c_log_head || l_api_name || '.compl_pred',
4896: 'l_pred:'||l_pred);

Line 4893: fnd_log.g_current_runtime_level) then

4889: 1, c_pred_buf_size);
4890: l_need_to_close_pred := TRUE;
4891: l_refers_to_grants := TRUE;
4892: if (fnd_log.LEVEL_STATEMENT >=
4893: fnd_log.g_current_runtime_level) then
4894: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4895: c_log_head || l_api_name || '.compl_pred',
4896: 'l_pred:'||l_pred);
4897: end if;

Line 4894: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4890: l_need_to_close_pred := TRUE;
4891: l_refers_to_grants := TRUE;
4892: if (fnd_log.LEVEL_STATEMENT >=
4893: fnd_log.g_current_runtime_level) then
4894: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4895: c_log_head || l_api_name || '.compl_pred',
4896: 'l_pred:'||l_pred);
4897: end if;
4898: end if;

Line 4919: if (fnd_log.LEVEL_STATEMENT >=

4915: l_last_was_hextoraw := TRUE;
4916: else
4917: l_last_was_hextoraw := FALSE;
4918: end if;
4919: if (fnd_log.LEVEL_STATEMENT >=
4920: fnd_log.g_current_runtime_level) then
4921: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4922: c_log_head || l_api_name || '.instsetloop',
4923: ' l_aggregate_predicate: ' || l_aggregate_predicate);

Line 4920: fnd_log.g_current_runtime_level) then

4916: else
4917: l_last_was_hextoraw := FALSE;
4918: end if;
4919: if (fnd_log.LEVEL_STATEMENT >=
4920: fnd_log.g_current_runtime_level) then
4921: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4922: c_log_head || l_api_name || '.instsetloop',
4923: ' l_aggregate_predicate: ' || l_aggregate_predicate);
4924: end if;

Line 4921: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4917: l_last_was_hextoraw := FALSE;
4918: end if;
4919: if (fnd_log.LEVEL_STATEMENT >=
4920: fnd_log.g_current_runtime_level) then
4921: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4922: c_log_head || l_api_name || '.instsetloop',
4923: ' l_aggregate_predicate: ' || l_aggregate_predicate);
4924: end if;
4925: END LOOP;

Line 4949: if (fnd_log.LEVEL_EXCEPTION >=

4945: fnd_message.set_token('ROUTINE',
4946: c_pkg_name || '.'|| l_api_name);
4947: fnd_message.set_token('REASON',
4948: ' Fell through where we shouldnt have (3)');
4949: if (fnd_log.LEVEL_EXCEPTION >=
4950: fnd_log.g_current_runtime_level) then
4951: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
4952: c_log_head || l_api_name || '.end_fallthru3',
4953: FALSE);

Line 4950: fnd_log.g_current_runtime_level) then

4946: c_pkg_name || '.'|| l_api_name);
4947: fnd_message.set_token('REASON',
4948: ' Fell through where we shouldnt have (3)');
4949: if (fnd_log.LEVEL_EXCEPTION >=
4950: fnd_log.g_current_runtime_level) then
4951: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
4952: c_log_head || l_api_name || '.end_fallthru3',
4953: FALSE);
4954: end if;

Line 4951: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

4947: fnd_message.set_token('REASON',
4948: ' Fell through where we shouldnt have (3)');
4949: if (fnd_log.LEVEL_EXCEPTION >=
4950: fnd_log.g_current_runtime_level) then
4951: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
4952: c_log_head || l_api_name || '.end_fallthru3',
4953: FALSE);
4954: end if;
4955: x_return_status := 'U';

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

4970: if (l_last_pred = '*NO_PRED*') then
4971: l_set_instance_type := FALSE;
4972: end if;
4973:
4974: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
4975: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4976: c_log_head || l_api_name || '.afterinstset',
4977: ' l_aggregate_predicate: ' || l_aggregate_predicate);
4978: end if;

Line 4975: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4971: l_set_instance_type := FALSE;
4972: end if;
4973:
4974: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
4975: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4976: c_log_head || l_api_name || '.afterinstset',
4977: ' l_aggregate_predicate: ' || l_aggregate_predicate);
4978: end if;
4979:

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

5112:
5113: /* Add on the clause for INSTANCE_TYPE = 'INSTANCE' */
5114: l_instance_predicate := l_instance_predicate ||
5115: ' AND'|| l_ik_clause||'))';
5116: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
5117: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
5118: c_log_head || l_api_name || '.instpred','instpred');
5119: end if;
5120: end if;

Line 5117: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

5113: /* Add on the clause for INSTANCE_TYPE = 'INSTANCE' */
5114: l_instance_predicate := l_instance_predicate ||
5115: ' AND'|| l_ik_clause||'))';
5116: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
5117: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
5118: c_log_head || l_api_name || '.instpred','instpred');
5119: end if;
5120: end if;
5121:

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

5166: FND_MESSAGE.SET_TOKEN('REASON',
5167: 'The predicate was longer than the database VPD limit of '||
5168: to_char(g_vpd_buf_limit)||' bytes for the predicate. ');
5169:
5170: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
5171: fnd_log.message(FND_LOG.LEVEL_PROCEDURE,
5172: c_log_head || l_api_name || '.end',
5173: FALSE);
5174: end if;

Line 5171: fnd_log.message(FND_LOG.LEVEL_PROCEDURE,

5167: 'The predicate was longer than the database VPD limit of '||
5168: to_char(g_vpd_buf_limit)||' bytes for the predicate. ');
5169:
5170: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
5171: fnd_log.message(FND_LOG.LEVEL_PROCEDURE,
5172: c_log_head || l_api_name || '.end',
5173: FALSE);
5174: end if;
5175: x_return_status := 'L'; /* Indicate Error */

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

5184: or (p_statement_type = 'VPD'))) then
5185: x_predicate := NULL;
5186: end if;
5187:
5188: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
5189: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
5190: c_log_head || l_api_name || '.end',
5191: 'x_predicate: '|| x_predicate ||
5192: ', x_return_status:'||x_return_status);

Line 5189: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

5185: x_predicate := NULL;
5186: end if;
5187:
5188: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
5189: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
5190: c_log_head || l_api_name || '.end',
5191: 'x_predicate: '|| x_predicate ||
5192: ', x_return_status:'||x_return_status);
5193: end if;

Line 5231: if (fnd_log.LEVEL_EXCEPTION >=

5227: c_pkg_name || '.'|| l_api_name);
5228: fnd_message.set_token('ERRNO', SQLCODE);
5229: fnd_message.set_token('REASON', SQLERRM);
5230:
5231: if (fnd_log.LEVEL_EXCEPTION >=
5232: fnd_log.g_current_runtime_level) then
5233: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
5234: c_log_head || l_api_name || '.other_err',
5235: FALSE);

Line 5232: fnd_log.g_current_runtime_level) then

5228: fnd_message.set_token('ERRNO', SQLCODE);
5229: fnd_message.set_token('REASON', SQLERRM);
5230:
5231: if (fnd_log.LEVEL_EXCEPTION >=
5232: fnd_log.g_current_runtime_level) then
5233: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
5234: c_log_head || l_api_name || '.other_err',
5235: FALSE);
5236: end if;

Line 5233: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

5229: fnd_message.set_token('REASON', SQLERRM);
5230:
5231: if (fnd_log.LEVEL_EXCEPTION >=
5232: fnd_log.g_current_runtime_level) then
5233: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
5234: c_log_head || l_api_name || '.other_err',
5235: FALSE);
5236: end if;
5237: x_return_status := 'U';

Line 5238: if (fnd_log.LEVEL_PROCEDURE >=

5234: c_log_head || l_api_name || '.other_err',
5235: FALSE);
5236: end if;
5237: x_return_status := 'U';
5238: if (fnd_log.LEVEL_PROCEDURE >=
5239: fnd_log.g_current_runtime_level) then
5240: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
5241: c_log_head || l_api_name || '.end_after_other',
5242: 'x_predicate: '|| x_predicate ||

Line 5239: fnd_log.g_current_runtime_level) then

5235: FALSE);
5236: end if;
5237: x_return_status := 'U';
5238: if (fnd_log.LEVEL_PROCEDURE >=
5239: fnd_log.g_current_runtime_level) then
5240: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
5241: c_log_head || l_api_name || '.end_after_other',
5242: 'x_predicate: '|| x_predicate ||
5243: ', x_return_status:'||x_return_status);

Line 5240: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

5236: end if;
5237: x_return_status := 'U';
5238: if (fnd_log.LEVEL_PROCEDURE >=
5239: fnd_log.g_current_runtime_level) then
5240: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
5241: c_log_head || l_api_name || '.end_after_other',
5242: 'x_predicate: '|| x_predicate ||
5243: ', x_return_status:'||x_return_status);
5244: end if;

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

5266: l_api_name CONSTANT VARCHAR2(30) := 'GET_SECURITY_PREDICATE_W_BINDS';
5267: l_api_version CONSTANT NUMBER := 1.0;
5268: BEGIN
5269:
5270: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
5271: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
5272: c_log_head || l_api_name || '.begin',
5273: c_pkg_name || '.' ||l_api_name|| '(' ||
5274: 'p_api_version=>'|| to_char(p_api_version) ||

Line 5271: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

5267: l_api_version CONSTANT NUMBER := 1.0;
5268: BEGIN
5269:
5270: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
5271: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
5272: c_log_head || l_api_name || '.begin',
5273: c_pkg_name || '.' ||l_api_name|| '(' ||
5274: 'p_api_version=>'|| to_char(p_api_version) ||
5275: ', p_function=>'|| p_function ||

Line 5293: if (fnd_log.LEVEL_EXCEPTION >=

5289: fnd_message.set_token('REASON',
5290: 'Unsupported version '|| to_char(p_api_version)||
5291: ' passed to API; expecting version '||
5292: to_char(l_api_version));
5293: if (fnd_log.LEVEL_EXCEPTION >=
5294: fnd_log.g_current_runtime_level) then
5295: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
5296: c_log_head || l_api_name || '.end_bad_api_ver',
5297: FALSE);

Line 5294: fnd_log.g_current_runtime_level) then

5290: 'Unsupported version '|| to_char(p_api_version)||
5291: ' passed to API; expecting version '||
5292: to_char(l_api_version));
5293: if (fnd_log.LEVEL_EXCEPTION >=
5294: fnd_log.g_current_runtime_level) then
5295: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
5296: c_log_head || l_api_name || '.end_bad_api_ver',
5297: FALSE);
5298: end if;

Line 5295: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

5291: ' passed to API; expecting version '||
5292: to_char(l_api_version));
5293: if (fnd_log.LEVEL_EXCEPTION >=
5294: fnd_log.g_current_runtime_level) then
5295: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
5296: c_log_head || l_api_name || '.end_bad_api_ver',
5297: FALSE);
5298: end if;
5299: x_return_status := 'U'; /* Unexpected Error */

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

5305: p_user_name, p_statement_type, p_table_alias,'Y',
5306: x_predicate, x_return_status,
5307: x_function_id, x_object_id, x_bind_order);
5308:
5309: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
5310: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
5311: c_log_head || l_api_name || '.end',
5312: ' x_predicate: '|| x_predicate ||
5313: ' x_return_status:'||x_return_status||

Line 5310: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

5306: x_predicate, x_return_status,
5307: x_function_id, x_object_id, x_bind_order);
5308:
5309: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
5310: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
5311: c_log_head || l_api_name || '.end',
5312: ' x_predicate: '|| x_predicate ||
5313: ' x_return_status:'||x_return_status||
5314: ' x_function_id: '|| x_function_id ||

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

5344: x_object_id NUMBER;
5345: x_bind_order varchar2(256);
5346: BEGIN
5347:
5348: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
5349: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
5350: c_log_head || l_api_name || '.begin',
5351: c_pkg_name || '.' ||l_api_name|| '(' ||
5352: 'p_api_version=>'|| to_char(p_api_version) ||

Line 5349: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

5345: x_bind_order varchar2(256);
5346: BEGIN
5347:
5348: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
5349: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
5350: c_log_head || l_api_name || '.begin',
5351: c_pkg_name || '.' ||l_api_name|| '(' ||
5352: 'p_api_version=>'|| to_char(p_api_version) ||
5353: ', p_function=>'|| p_function ||

Line 5370: if (fnd_log.LEVEL_EXCEPTION >=

5366: fnd_message.set_token('REASON',
5367: 'Unsupported version '|| to_char(p_api_version)||
5368: ' passed to API; expecting version '||
5369: to_char(l_api_version));
5370: if (fnd_log.LEVEL_EXCEPTION >=
5371: fnd_log.g_current_runtime_level) then
5372: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
5373: c_log_head || l_api_name || '.end_bad_api_ver',
5374: FALSE);

Line 5371: fnd_log.g_current_runtime_level) then

5367: 'Unsupported version '|| to_char(p_api_version)||
5368: ' passed to API; expecting version '||
5369: to_char(l_api_version));
5370: if (fnd_log.LEVEL_EXCEPTION >=
5371: fnd_log.g_current_runtime_level) then
5372: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
5373: c_log_head || l_api_name || '.end_bad_api_ver',
5374: FALSE);
5375: end if;

Line 5372: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

5368: ' passed to API; expecting version '||
5369: to_char(l_api_version));
5370: if (fnd_log.LEVEL_EXCEPTION >=
5371: fnd_log.g_current_runtime_level) then
5372: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
5373: c_log_head || l_api_name || '.end_bad_api_ver',
5374: FALSE);
5375: end if;
5376: x_return_status := 'U'; /* Unexpected Error */

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

5382: p_user_name, p_statement_type, p_table_alias, 'N',
5383: x_predicate, x_return_status,
5384: x_function_id, x_object_id, x_bind_order);
5385:
5386: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
5387: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
5388: c_log_head || l_api_name || '.end',
5389: ' x_predicate: '|| x_predicate ||
5390: ' x_return_status:'||x_return_status||

Line 5387: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

5383: x_predicate, x_return_status,
5384: x_function_id, x_object_id, x_bind_order);
5385:
5386: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
5387: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
5388: c_log_head || l_api_name || '.end',
5389: ' x_predicate: '|| x_predicate ||
5390: ' x_return_status:'||x_return_status||
5391: ' x_function_id: '|| x_function_id ||

Line 5446: if (fnd_log.LEVEL_EXCEPTION >=

5442: fnd_message.set_token('REASON',
5443: 'Unsupported mode arguments: '||
5444: 'p_statement_type = BASE|VPD,'||
5445: ' or p_pkX_alias values passed.');
5446: if (fnd_log.LEVEL_EXCEPTION >=
5447: fnd_log.g_current_runtime_level) then
5448: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
5449: c_log_head || l_api_name || '.end_bad_mode',
5450: FALSE);

Line 5447: fnd_log.g_current_runtime_level) then

5443: 'Unsupported mode arguments: '||
5444: 'p_statement_type = BASE|VPD,'||
5445: ' or p_pkX_alias values passed.');
5446: if (fnd_log.LEVEL_EXCEPTION >=
5447: fnd_log.g_current_runtime_level) then
5448: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
5449: c_log_head || l_api_name || '.end_bad_mode',
5450: FALSE);
5451: end if;

Line 5448: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

5444: 'p_statement_type = BASE|VPD,'||
5445: ' or p_pkX_alias values passed.');
5446: if (fnd_log.LEVEL_EXCEPTION >=
5447: fnd_log.g_current_runtime_level) then
5448: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
5449: c_log_head || l_api_name || '.end_bad_mode',
5450: FALSE);
5451: end if;
5452: x_return_status := 'U'; /* Unexpected Error */

Line 5479: if (fnd_log.LEVEL_EXCEPTION >=

5475: 'a bug against the product that owns the call to this '||
5476: 'routine, which is likely the owner of the object that '||
5477: 'was passed to this routine: '||
5478: p_object_name);
5479: if (fnd_log.LEVEL_EXCEPTION >=
5480: fnd_log.g_current_runtime_level) then
5481: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
5482: c_log_head || l_api_name || '.end_unsupported',
5483: FALSE);

Line 5480: fnd_log.g_current_runtime_level) then

5476: 'routine, which is likely the owner of the object that '||
5477: 'was passed to this routine: '||
5478: p_object_name);
5479: if (fnd_log.LEVEL_EXCEPTION >=
5480: fnd_log.g_current_runtime_level) then
5481: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
5482: c_log_head || l_api_name || '.end_unsupported',
5483: FALSE);
5484: end if;

Line 5481: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

5477: 'was passed to this routine: '||
5478: p_object_name);
5479: if (fnd_log.LEVEL_EXCEPTION >=
5480: fnd_log.g_current_runtime_level) then
5481: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
5482: c_log_head || l_api_name || '.end_unsupported',
5483: FALSE);
5484: end if;
5485: fnd_message.raise_error;

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

5523:
5524: TYPE DYNAMIC_CUR IS REF CURSOR;
5525: instances_cur DYNAMIC_CUR;
5526: begin
5527: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
5528: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
5529: c_log_head || l_api_name || '.begin',
5530: c_pkg_name || '.' ||l_api_name|| '(' ||
5531: 'p_api_version=>'|| to_char(p_api_version) ||

Line 5528: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

5524: TYPE DYNAMIC_CUR IS REF CURSOR;
5525: instances_cur DYNAMIC_CUR;
5526: begin
5527: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
5528: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
5529: c_log_head || l_api_name || '.begin',
5530: c_pkg_name || '.' ||l_api_name|| '(' ||
5531: 'p_api_version=>'|| to_char(p_api_version) ||
5532: ', p_function=>'|| p_function ||

Line 5564: if (fnd_log.LEVEL_EXCEPTION >=

5560: 'a bug against the product that owns the call to this '||
5561: 'routine, which is likely the owner of the object that '||
5562: 'was passed to this routine: '||
5563: p_object_name);
5564: if (fnd_log.LEVEL_EXCEPTION >=
5565: fnd_log.g_current_runtime_level) then
5566: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
5567: c_log_head || l_api_name || '.end_unsupported',
5568: FALSE);

Line 5565: fnd_log.g_current_runtime_level) then

5561: 'routine, which is likely the owner of the object that '||
5562: 'was passed to this routine: '||
5563: p_object_name);
5564: if (fnd_log.LEVEL_EXCEPTION >=
5565: fnd_log.g_current_runtime_level) then
5566: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
5567: c_log_head || l_api_name || '.end_unsupported',
5568: FALSE);
5569: end if;

Line 5566: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

5562: 'was passed to this routine: '||
5563: p_object_name);
5564: if (fnd_log.LEVEL_EXCEPTION >=
5565: fnd_log.g_current_runtime_level) then
5566: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
5567: c_log_head || l_api_name || '.end_unsupported',
5568: FALSE);
5569: end if;
5570: fnd_message.raise_error;

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

5577: p_user_name =>p_user_name,
5578: x_predicate=>l_predicate,
5579: x_return_status=>x_return_status);
5580: if((x_return_status <> 'T') AND (x_return_status <> 'F'))then
5581: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
5582: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
5583: c_log_head || l_api_name || '.end_gsp_err',
5584: 'returning status: '|| x_return_status);
5585: end if;

Line 5582: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

5578: x_predicate=>l_predicate,
5579: x_return_status=>x_return_status);
5580: if((x_return_status <> 'T') AND (x_return_status <> 'F'))then
5581: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
5582: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
5583: c_log_head || l_api_name || '.end_gsp_err',
5584: 'returning status: '|| x_return_status);
5585: end if;
5586: /* There will be a message on the msg dict stack. */

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

5600: l_pk_orig_column_names,
5601: l_db_object_name,
5602: 'OBJTAB', 'GNT');
5603: if (x_return_status <> 'T') then
5604: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
5605: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
5606: c_log_head || l_api_name || '.end_pk_info_err',
5607: 'returning status: '|| x_return_status);
5608: end if;

Line 5605: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

5601: l_db_object_name,
5602: 'OBJTAB', 'GNT');
5603: if (x_return_status <> 'T') then
5604: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
5605: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
5606: c_log_head || l_api_name || '.end_pk_info_err',
5607: 'returning status: '|| x_return_status);
5608: end if;
5609: /* There will be a message on the msg dict stack. */

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

5617: ' FROM '|| l_db_object_name ||
5618: ' WHERE '||l_predicate||' ';
5619: else
5620: x_return_status := 'F';
5621: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
5622: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
5623: c_log_head || l_api_name || '.end_nopred',
5624: 'returning '|| x_return_status );
5625: end if;

Line 5622: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

5618: ' WHERE '||l_predicate||' ';
5619: else
5620: x_return_status := 'F';
5621: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
5622: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
5623: c_log_head || l_api_name || '.end_nopred',
5624: 'returning '|| x_return_status );
5625: end if;
5626: return;

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

5625: end if;
5626: return;
5627: end if;
5628:
5629: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
5630: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
5631: c_log_head || l_api_name || '.create_dy_sql',
5632: 'dynamic_sql:'||l_dynamic_sql);
5633: end if;

Line 5630: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

5626: return;
5627: end if;
5628:
5629: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
5630: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
5631: c_log_head || l_api_name || '.create_dy_sql',
5632: 'dynamic_sql:'||l_dynamic_sql);
5633: end if;
5634:

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

5635: l_index:=0;
5636:
5637: -- Run the statement,
5638: OPEN instances_cur FOR l_dynamic_sql;
5639: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
5640: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
5641: c_log_head || l_api_name || '.startloop',
5642: ' startloop');
5643: end if;

Line 5640: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

5636:
5637: -- Run the statement,
5638: OPEN instances_cur FOR l_dynamic_sql;
5639: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
5640: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
5641: c_log_head || l_api_name || '.startloop',
5642: ' startloop');
5643: end if;
5644: LOOP

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

5672: return; /* This will never happen since pk1 is reqd*/
5673: end if;
5674:
5675:
5676: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
5677: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
5678: c_log_head || l_api_name || '.did_fetch',
5679: ' l_pk1_val: ' || l_pk1_val ||
5680: ' l_pk2_val: ' || l_pk2_val ||

Line 5677: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

5673: end if;
5674:
5675:
5676: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
5677: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
5678: c_log_head || l_api_name || '.did_fetch',
5679: ' l_pk1_val: ' || l_pk1_val ||
5680: ' l_pk2_val: ' || l_pk2_val ||
5681: ' l_pk3_val: ' || l_pk3_val ||

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

5696: else
5697: x_return_status := 'F'; /* No instances */
5698: end if;
5699:
5700: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
5701: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
5702: c_log_head || l_api_name || '.end',
5703: 'returning '|| x_return_status );
5704: end if;

Line 5701: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

5697: x_return_status := 'F'; /* No instances */
5698: end if;
5699:
5700: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
5701: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
5702: c_log_head || l_api_name || '.end',
5703: 'returning '|| x_return_status );
5704: end if;
5705: return;

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

5719: c_pkg_name || '.'|| l_api_name);
5720: fnd_message.set_token('ERRNO', SQLCODE);
5721: fnd_message.set_token('REASON', SQLERRM);
5722:
5723: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
5724: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
5725: c_log_head || l_api_name || '.other_err',
5726: FALSE);
5727: end if;

Line 5724: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

5720: fnd_message.set_token('ERRNO', SQLCODE);
5721: fnd_message.set_token('REASON', SQLERRM);
5722:
5723: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
5724: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
5725: c_log_head || l_api_name || '.other_err',
5726: FALSE);
5727: end if;
5728: x_return_status := 'U';

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

5725: c_log_head || l_api_name || '.other_err',
5726: FALSE);
5727: end if;
5728: x_return_status := 'U';
5729: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
5730: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
5731: c_log_head || l_api_name || '.end_after_other',
5732: ', x_return_status:'||x_return_status);
5733: end if;

Line 5730: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

5726: FALSE);
5727: end if;
5728: x_return_status := 'U';
5729: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
5730: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
5731: c_log_head || l_api_name || '.end_after_other',
5732: ', x_return_status:'||x_return_status);
5733: end if;
5734: RETURN ;

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

5750: ) return VARCHAR2 is
5751: l_api_name CONSTANT VARCHAR2(30) := 'CHECK_INSTANCE_IN_SET';
5752:
5753: begin
5754: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
5755: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
5756: c_log_head || l_api_name || '.begin',
5757: c_pkg_name || '.' ||l_api_name|| '(' ||
5758: 'p_api_version=>'|| to_char(p_api_version) ||

Line 5755: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

5751: l_api_name CONSTANT VARCHAR2(30) := 'CHECK_INSTANCE_IN_SET';
5752:
5753: begin
5754: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
5755: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
5756: c_log_head || l_api_name || '.begin',
5757: c_pkg_name || '.' ||l_api_name|| '(' ||
5758: 'p_api_version=>'|| to_char(p_api_version) ||
5759: ', p_instance_set_name=>'|| p_instance_set_name ||

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

5770: 'Desupported API called. This routine is no longer '||
5771: 'supported because it is incompatible with '||
5772: 'parameterized instance sets which were introduced '||
5773: 'in 4/2002. ');
5774: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
5775: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
5776: c_log_head || l_api_name || '.end_desupported',
5777: FALSE);
5778: end if;

Line 5775: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

5771: 'supported because it is incompatible with '||
5772: 'parameterized instance sets which were introduced '||
5773: 'in 4/2002. ');
5774: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
5775: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
5776: c_log_head || l_api_name || '.end_desupported',
5777: FALSE);
5778: end if;
5779: