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_FUNCTION dependencies on FND_LOG

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

88: apps_maintenance_mode varchar2(255);
89: retval boolean;
90: l_api_name CONSTANT VARCHAR2(30) := 'AVAILABILITY';
91: begin
92: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
93: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
94: c_log_head || l_api_name || '.begin',
95: c_pkg_name || '.' ||l_api_name|| '(' ||
96: 'MAINTENANCE_MODE_SUPPORT =>'|| MAINTENANCE_MODE_SUPPORT

Line 93: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

89: retval boolean;
90: l_api_name CONSTANT VARCHAR2(30) := 'AVAILABILITY';
91: begin
92: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
93: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
94: c_log_head || l_api_name || '.begin',
95: c_pkg_name || '.' ||l_api_name|| '(' ||
96: 'MAINTENANCE_MODE_SUPPORT =>'|| MAINTENANCE_MODE_SUPPORT
97: ||');');

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

98: end if;
99:
100: apps_maintenance_mode := FND_PROFILE.VALUE('APPS_MAINTENANCE_MODE');
101:
102: if(fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
103: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
104: c_log_head || l_api_name || '.got_mode',
105: 'profile APPS_MAINTENANCE_MODE is set to value:'
106: || apps_maintenance_mode);

Line 103: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

99:
100: apps_maintenance_mode := FND_PROFILE.VALUE('APPS_MAINTENANCE_MODE');
101:
102: if(fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
103: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
104: c_log_head || l_api_name || '.got_mode',
105: 'profile APPS_MAINTENANCE_MODE is set to value:'
106: || apps_maintenance_mode);
107: end if;

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

144: end if;
145: else
146: /* Unrecognized value for APPS_MAINTENANCE_MODE profile... */
147: /* assume the best and allow access. */
148: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
149: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
150: c_log_head || l_api_name || '.unrecognized_mode',
151: 'Unrecognized value for profile APPS_MAINTENANCE_MODE:'
152: || apps_maintenance_mode);

Line 149: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

145: else
146: /* Unrecognized value for APPS_MAINTENANCE_MODE profile... */
147: /* assume the best and allow access. */
148: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
149: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
150: c_log_head || l_api_name || '.unrecognized_mode',
151: 'Unrecognized value for profile APPS_MAINTENANCE_MODE:'
152: || apps_maintenance_mode);
153: end if;

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

155: end if;
156: end if; /* If statement for supporting OFFLINE */
157:
158: if (retval) then
159: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
160: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
161: c_log_head || l_api_name || '.end_true',
162: 'returning Y');
163: end if;

Line 160: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

156: end if; /* If statement for supporting OFFLINE */
157:
158: if (retval) then
159: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
160: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
161: c_log_head || l_api_name || '.end_true',
162: 'returning Y');
163: end if;
164: return 'Y';

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

162: 'returning Y');
163: end if;
164: return 'Y';
165: else
166: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
167: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
168: c_log_head || l_api_name || '.end_false',
169: 'returning N');
170: end if;

Line 167: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

163: end if;
164: return 'Y';
165: else
166: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
167: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
168: c_log_head || l_api_name || '.end_false',
169: 'returning N');
170: end if;
171: return 'N';

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

296: -- }
297: -- Move to next element on menulist
298: -- }
299: -- }
300: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
301: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
302: c_log_head || l_api_name || '.begin',
303: c_pkg_name || '.' ||l_api_name|| '(' ||
304: 'p_menu_id =>'|| to_char(p_menu_id) ||

Line 301: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

297: -- Move to next element on menulist
298: -- }
299: -- }
300: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
301: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
302: c_log_head || l_api_name || '.begin',
303: c_pkg_name || '.' ||l_api_name|| '(' ||
304: 'p_menu_id =>'|| to_char(p_menu_id) ||
305: 'p_function_id =>'|| to_char(p_function_id) ||

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

321: menulist(0) := p_menu_id;
322:
323: -- Continue processing until reach the end of list
324: while (menulist_cur < menulist_size) loop
325: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
326: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
327: c_log_head || l_api_name || '.proc_menulist',
328: 'menulist_cur: ' || to_char(menulist_cur));
329: end if;

Line 326: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

322:
323: -- Continue processing until reach the end of list
324: while (menulist_cur < menulist_size) loop
325: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
326: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
327: c_log_head || l_api_name || '.proc_menulist',
328: 'menulist_cur: ' || to_char(menulist_cur));
329: end if;
330:

Line 335: if (fnd_log.LEVEL_ERROR >= fnd_log.g_current_runtime_level) then

331: -- Check if recursion limit exceeded
332: if (menulist_cur > C_MAX_MENU_ENTRIES) then
333: fnd_message.set_name('FND', 'MENU-MENU LOOP');
334: fnd_message.set_token('MENU_ID', p_menu_id);
335: if (fnd_log.LEVEL_ERROR >= fnd_log.g_current_runtime_level) then
336: fnd_log.message(FND_LOG.LEVEL_ERROR,
337: c_log_head || l_api_name || '.recursion');
338: end if;
339:

Line 336: fnd_log.message(FND_LOG.LEVEL_ERROR,

332: if (menulist_cur > C_MAX_MENU_ENTRIES) then
333: fnd_message.set_name('FND', 'MENU-MENU LOOP');
334: fnd_message.set_token('MENU_ID', p_menu_id);
335: if (fnd_log.LEVEL_ERROR >= fnd_log.g_current_runtime_level) then
336: fnd_log.message(FND_LOG.LEVEL_ERROR,
337: c_log_head || l_api_name || '.recursion');
338: end if;
339:
340: /* If the function were accessible from this menu, then we should */

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

339:
340: /* If the function were accessible from this menu, then we should */
341: /* have found it before getting to this point, so we are confident */
342: /* that the function is not on this menu. */
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 || '.end_found_recur',
346: 'returning FALSE');
347: end if;

Line 344: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

340: /* If the function were accessible from this menu, then we should */
341: /* have found it before getting to this point, so we are confident */
342: /* that the function is not on this menu. */
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 || '.end_found_recur',
346: 'returning FALSE');
347: end if;
348:

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

355: entry_excluded := FALSE;
356: begin
357: if( (l_sub_menu_id is not NULL)
358: and (exclusions(l_sub_menu_id) = 'M')) then
359: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
360: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
361: c_log_head || l_api_name || '.menu_excl',
362: 'l_sub_menu_id:' || l_sub_menu_id );
363: end if;

Line 360: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

356: begin
357: if( (l_sub_menu_id is not NULL)
358: and (exclusions(l_sub_menu_id) = 'M')) then
359: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
360: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
361: c_log_head || l_api_name || '.menu_excl',
362: 'l_sub_menu_id:' || l_sub_menu_id );
363: end if;
364: entry_excluded := TRUE;

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

372: last_index := 0; /* Indicate that no rows were returned */
373: else
374: /* This menu isn't excluded, so find out whats entries are on it. */
375:
376: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
377: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
378: c_log_head || l_api_name || '.not_excl',
379: ' Following was not excluded: l_sub_menu_id: ' ||
380: to_char(l_sub_menu_id));

Line 377: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

373: else
374: /* This menu isn't excluded, so find out whats entries are on it. */
375:
376: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
377: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
378: c_log_head || l_api_name || '.not_excl',
379: ' Following was not excluded: l_sub_menu_id: ' ||
380: to_char(l_sub_menu_id));
381: end if;

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

417: end if; /* entry_excluded */
418:
419: -- Process each of the child entries fetched
420: for i in 1 .. last_index loop
421: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
422: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
423: c_log_head || l_api_name || '.proc_child',
424: 'Processing child of current menu. tbl_func_id(i):' ||
425: tbl_func_id(i) || ' tbl_submenu_id(i):'||

Line 422: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

418:
419: -- Process each of the child entries fetched
420: for i in 1 .. last_index loop
421: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
422: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
423: c_log_head || l_api_name || '.proc_child',
424: 'Processing child of current menu. tbl_func_id(i):' ||
425: tbl_func_id(i) || ' tbl_submenu_id(i):'||
426: tbl_submnu_id(i));

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

430: entry_excluded := FALSE;
431: begin
432: if( (tbl_func_id(i) is not NULL)
433: and (exclusions(tbl_func_id(i)) = 'F')) then
434: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
435: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
436: c_log_head || l_api_name || '.func_excl',
437: 'tbl_func_id(i):' || tbl_func_id(i) );
438: end if;

Line 435: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

431: begin
432: if( (tbl_func_id(i) is not NULL)
433: and (exclusions(tbl_func_id(i)) = 'F')) then
434: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
435: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
436: c_log_head || l_api_name || '.func_excl',
437: 'tbl_func_id(i):' || tbl_func_id(i) );
438: end if;
439: entry_excluded := TRUE;

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

444: end;
445:
446: -- Skip this entry if it's excluded
447: if (not entry_excluded) then
448: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
449: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
450: c_log_head || l_api_name || '.not_excl',
451: 'Entry not excluded. Checking function:'
452: ||to_char(tbl_func_id(i))|| ' against p_function_id:'

Line 449: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

445:
446: -- Skip this entry if it's excluded
447: if (not entry_excluded) then
448: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
449: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
450: c_log_head || l_api_name || '.not_excl',
451: 'Entry not excluded. Checking function:'
452: ||to_char(tbl_func_id(i))|| ' against p_function_id:'
453: ||to_char(p_function_id)||' where grant_flag='||tbl_gnt_flg(i));

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

455: -- Check if this is a matching function. If so, return success.
456: if( (tbl_func_id(i) = p_function_id)
457: and (tbl_gnt_flg(i) = 'Y'))
458: then
459: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
460: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
461: c_log_head || l_api_name || '.end_found',
462: 'returning TRUE');
463: end if;

Line 460: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

456: if( (tbl_func_id(i) = p_function_id)
457: and (tbl_gnt_flg(i) = 'Y'))
458: then
459: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
460: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
461: c_log_head || l_api_name || '.end_found',
462: 'returning TRUE');
463: end if;
464: return TRUE;

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

477: menulist_cur := menulist_cur + 1;
478: end loop;
479:
480: -- We couldn't find the function anywhere, so it's not available
481: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
482: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
483: c_log_head || l_api_name || '.end_not_found',
484: 'returning FALSE');
485: end if;

Line 482: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

478: end loop;
479:
480: -- We couldn't find the function anywhere, so it's not available
481: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
482: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
483: c_log_head || l_api_name || '.end_not_found',
484: 'returning FALSE');
485: end if;
486: return FALSE;

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

505: ) return boolean is
506: l_menu_id NUMBER;
507: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_MENU_TREE_DOWN';
508: begin
509: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
510: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
511: c_log_head || l_api_name || '.begin',
512: c_pkg_name || '.' ||l_api_name|| '(' ||
513: 'p_appl_id=>'|| to_char(p_appl_id) ||

Line 510: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

506: l_menu_id NUMBER;
507: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_MENU_TREE_DOWN';
508: begin
509: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
510: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
511: c_log_head || l_api_name || '.begin',
512: c_pkg_name || '.' ||l_api_name|| '(' ||
513: 'p_appl_id=>'|| to_char(p_appl_id) ||
514: ', p_resp_id=>'|| p_resp_id ||

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

535: exception
536: when no_data_found then
537: /* No menu for this resp, so there can't be any functions */
538:
539: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
540: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
541: c_log_head || l_api_name || '.end_no_menu_resp',
542: 'returning FALSE');
543: end if;

Line 540: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

536: when no_data_found then
537: /* No menu for this resp, so there can't be any functions */
538:
539: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
540: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
541: c_log_head || l_api_name || '.end_no_menu_resp',
542: 'returning FALSE');
543: end if;
544: return FALSE;

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

543: end if;
544: return FALSE;
545: end;
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',
550: 'return call to PROCESS_MENU_TREE_DOWN_FOR_MN '||
551: ' l_menu_id = '||l_menu_id);

Line 548: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

544: return FALSE;
545: end;
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',
550: 'return call to PROCESS_MENU_TREE_DOWN_FOR_MN '||
551: ' l_menu_id = '||l_menu_id);
552: end if;

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

634: last_index pls_integer;
635:
636:
637: begin
638: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
639: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
640: c_log_head || l_api_name || '.begin',
641: c_pkg_name || '.' ||l_api_name || '(' ||
642: 'p_menu_id=>'|| p_menu_id||');');

Line 639: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

635:
636:
637: begin
638: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
639: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
640: c_log_head || l_api_name || '.begin',
641: c_pkg_name || '.' ||l_api_name || '(' ||
642: 'p_menu_id=>'|| p_menu_id||');');
643: end if;

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

673: m := 0;
674:
675: /* Loop through all the menu entries on the current list */
676: while (i < CUR_MNES_SIZE) loop /* For each entry at the level */
677: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
678: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
679: c_log_head || l_api_name || '.proc_ent',
680: 'Processing entry. i:' || to_char(i)||
681: ' CUR_MNES(i).MENU_ID:'|| to_char(CUR_MNES(i).MENU_ID) ||

Line 678: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

674:
675: /* Loop through all the menu entries on the current list */
676: while (i < CUR_MNES_SIZE) loop /* For each entry at the level */
677: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
678: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
679: c_log_head || l_api_name || '.proc_ent',
680: 'Processing entry. i:' || to_char(i)||
681: ' CUR_MNES(i).MENU_ID:'|| to_char(CUR_MNES(i).MENU_ID) ||
682: ' CUR_MNES(i).ENTRY_SEQ:'|| to_char(CUR_MNES(i).ENTRY_SEQ) ||

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

689: (menu_id, function_id, grant_flag)
690: values
691: (CUR_MNES(i).MENU_ID, C_INVALID_MENU_VAL, C_INVALID_GRANT_VAL);
692: commit;
693: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
694: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
695: c_log_head || l_api_name || '.marked',
696: 'Mark inserted.');
697: end if;

Line 694: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

690: values
691: (CUR_MNES(i).MENU_ID, C_INVALID_MENU_VAL, C_INVALID_GRANT_VAL);
692: commit;
693: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
694: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
695: c_log_head || l_api_name || '.marked',
696: 'Mark inserted.');
697: end if;
698: mark_existed := FALSE;

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

697: end if;
698: mark_existed := FALSE;
699: exception
700: when dup_val_on_index then
701: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
702: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
703: c_log_head || l_api_name || '.marked_existed',
704: 'Mark was already there. ');
705: end if;

Line 702: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

698: mark_existed := FALSE;
699: exception
700: when dup_val_on_index then
701: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
702: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
703: c_log_head || l_api_name || '.marked_existed',
704: 'Mark was already there. ');
705: end if;
706: mark_existed := TRUE;

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

722: /* Process the list of parent menuids */
723: p := 0;
724: while (p < m) loop
725: /* Get the list of menu entries above a particular submenu */
726: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
727: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
728: c_log_head || l_api_name || '.handle_menulist',
729: 'Handling Menulist. p:' || to_char(p)||
730: ' MENULIST(p):'|| to_char(MENULIST(p)));

Line 727: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

723: p := 0;
724: while (p < m) loop
725: /* Get the list of menu entries above a particular submenu */
726: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
727: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
728: c_log_head || l_api_name || '.handle_menulist',
729: 'Handling Menulist. p:' || to_char(p)||
730: ' MENULIST(p):'|| to_char(MENULIST(p)));
731: end if;

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

778: end loop; /* while (j < EXCLUSIONS_SIZE) loop */
779:
780: end loop; /* while (i < CUR_MNES_SIZE) loop */
781:
782: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
783: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
784: c_log_head || l_api_name || '.end',
785: 'end');
786: end if;

Line 783: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

779:
780: end loop; /* while (i < CUR_MNES_SIZE) loop */
781:
782: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
783: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
784: c_log_head || l_api_name || '.end',
785: 'end');
786: end if;
787: end MARK_MENU_I;

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

794: is
795: l_api_name CONSTANT VARCHAR2(30) := 'ADD_QUEUED_MARKS';
796: RSTATUS number;
797: begin
798: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
799: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
800: c_log_head || l_api_name || '.begin',
801: c_pkg_name || '.' ||l_api_name);
802: end if;

Line 799: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

795: l_api_name CONSTANT VARCHAR2(30) := 'ADD_QUEUED_MARKS';
796: RSTATUS number;
797: begin
798: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
799: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
800: c_log_head || l_api_name || '.begin',
801: c_pkg_name || '.' ||l_api_name);
802: end if;
803: if (DBMS_LOCK.REQUEST(C_MENU_LOCK_ID, DBMS_LOCK.S_MODE) = 0) then

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

811: null;
812: end;
813: RSTATUS := DBMS_LOCK.RELEASE(C_MENU_LOCK_ID);
814: end if;
815: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
816: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
817: c_log_head || l_api_name || '.end',
818: 'return');
819: end if;

Line 816: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

812: end;
813: RSTATUS := DBMS_LOCK.RELEASE(C_MENU_LOCK_ID);
814: end if;
815: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
816: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
817: c_log_head || l_api_name || '.end',
818: 'return');
819: end if;
820: end;

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

830: procedure QUEUE_MARK(
831: p_menu_id in number) is
832: l_api_name CONSTANT VARCHAR2(30) := 'QUEUE_MARK';
833: begin
834: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
835: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
836: c_log_head || l_api_name || '.begin',
837: c_pkg_name || '.' ||l_api_name ||'(' ||
838: 'p_menu_id=>'|| p_menu_id||');');

Line 835: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

831: p_menu_id in number) is
832: l_api_name CONSTANT VARCHAR2(30) := 'QUEUE_MARK';
833: begin
834: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
835: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
836: c_log_head || l_api_name || '.begin',
837: c_pkg_name || '.' ||l_api_name ||'(' ||
838: 'p_menu_id=>'|| p_menu_id||');');
839: end if;

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

838: 'p_menu_id=>'|| p_menu_id||');');
839: end if;
840: if (TBL_QUEUED_MENU_ID_MAX <> 0)
841: AND (TBL_QUEUED_MENU_ID(TBL_QUEUED_MENU_ID_MAX) = p_menu_id) then
842: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
843: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
844: c_log_head || l_api_name || '.end_dupfound',
845: 'return');
846: end if;

Line 843: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

839: end if;
840: if (TBL_QUEUED_MENU_ID_MAX <> 0)
841: AND (TBL_QUEUED_MENU_ID(TBL_QUEUED_MENU_ID_MAX) = p_menu_id) then
842: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
843: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
844: c_log_head || l_api_name || '.end_dupfound',
845: 'return');
846: end if;
847: return; /* Dont make duplicate marks */

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

850: /* Store the mark away. */
851: TBL_QUEUED_MENU_ID_MAX := TBL_QUEUED_MENU_ID_MAX + 1;
852: TBL_QUEUED_MENU_ID(TBL_QUEUED_MENU_ID_MAX) := p_menu_id;
853:
854: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
855: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
856: c_log_head || l_api_name || '.end',
857: 'mark stored as TBL_QUEUED_MENU_ID_MAX: '||TBL_QUEUED_MENU_ID_MAX);
858: end if;

Line 855: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

851: TBL_QUEUED_MENU_ID_MAX := TBL_QUEUED_MENU_ID_MAX + 1;
852: TBL_QUEUED_MENU_ID(TBL_QUEUED_MENU_ID_MAX) := p_menu_id;
853:
854: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
855: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
856: c_log_head || l_api_name || '.end',
857: 'mark stored as TBL_QUEUED_MENU_ID_MAX: '||TBL_QUEUED_MENU_ID_MAX);
858: end if;
859: end;

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

914: l_resp_appl_id number;
915: result boolean;
916: L_TEST_MAINT_AVAILABILITY boolean;
917: begin
918: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
919: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
920: c_log_head || l_api_name || '.begin',
921: c_pkg_name || '.' ||l_api_name|| '(' ||
922: 'function_id =>'|| function_id ||

Line 919: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

915: result boolean;
916: L_TEST_MAINT_AVAILABILITY boolean;
917: begin
918: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
919: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
920: c_log_head || l_api_name || '.begin',
921: c_pkg_name || '.' ||l_api_name|| '(' ||
922: 'function_id =>'|| function_id ||
923: 'MAINTENANCE_MODE_SUPPORT =>'|| MAINTENANCE_MODE_SUPPORT ||

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

946: and application_id = l_resp_appl_id
947: and rownum = 1;
948:
949: /* If we got here then there are exclusions, so don't use compiled */
950: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
951: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
952: c_log_head || l_api_name || '.end_excl',
953: 'Because of exclusions, falling back, calling process_menu_tree_down.');
954: end if;

Line 951: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

947: and rownum = 1;
948:
949: /* If we got here then there are exclusions, so don't use compiled */
950: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
951: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
952: c_log_head || l_api_name || '.end_excl',
953: 'Because of exclusions, falling back, calling process_menu_tree_down.');
954: end if;
955:

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

972:
973: exception
974: when no_data_found then
975: /* If we got here, there are no exclusions. */
976: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
977: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
978: c_log_head || l_api_name || '.not_excl',
979: 'No exclusions, so finding menu');
980: end if;

Line 977: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

973: exception
974: when no_data_found then
975: /* If we got here, there are no exclusions. */
976: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
977: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
978: c_log_head || l_api_name || '.not_excl',
979: 'No exclusions, so finding menu');
980: end if;
981: if ( (P_LAST_RESP_ID = l_resp_id)

Line 1000: if (fnd_log.LEVEL_PROCEDURE >=

996: P_LAST_MENU_ID := l_menu_id;
997: exception
998: when no_data_found then
999: /* No menu for this resp, so there can't be any functions */
1000: if (fnd_log.LEVEL_PROCEDURE >=
1001: fnd_log.g_current_runtime_level) then
1002: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1003: c_log_head || l_api_name || '.end_no_menu',
1004: 'Couldnt find root menu for resp. returning FALSE ');

Line 1001: fnd_log.g_current_runtime_level) then

997: exception
998: when no_data_found then
999: /* No menu for this resp, so there can't be any functions */
1000: if (fnd_log.LEVEL_PROCEDURE >=
1001: fnd_log.g_current_runtime_level) then
1002: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1003: c_log_head || l_api_name || '.end_no_menu',
1004: 'Couldnt find root menu for resp. returning FALSE ');
1005: end if;

Line 1002: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

998: when no_data_found then
999: /* No menu for this resp, so there can't be any functions */
1000: if (fnd_log.LEVEL_PROCEDURE >=
1001: fnd_log.g_current_runtime_level) then
1002: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1003: c_log_head || l_api_name || '.end_no_menu',
1004: 'Couldnt find root menu for resp. returning FALSE ');
1005: end if;
1006: return FALSE;

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

1007: end;
1008: end if;
1009: end;
1010:
1011: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1012: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1013: c_log_head || l_api_name || '.end',
1014: 'Returning with call to is_function_on_menu; ');
1015: end if;

Line 1012: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1008: end if;
1009: end;
1010:
1011: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1012: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1013: c_log_head || l_api_name || '.end',
1014: 'Returning with call to is_function_on_menu; ');
1015: end if;
1016:

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

1041: is
1042: l_api_name CONSTANT VARCHAR2(30) := 'TEST_ID';
1043: l_function_id number;
1044: begin
1045: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1046: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1047: c_log_head || l_api_name || '.begin',
1048: 'function_id: '||function_id);
1049: end if;

Line 1046: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1042: l_api_name CONSTANT VARCHAR2(30) := 'TEST_ID';
1043: l_function_id number;
1044: begin
1045: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1046: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1047: c_log_head || l_api_name || '.begin',
1048: 'function_id: '||function_id);
1049: end if;
1050:

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

1049: end if;
1050:
1051: l_function_id := function_id;
1052:
1053: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1054: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1055: c_log_head || l_api_name || '.end',
1056: 'Returning with call to process_menu_tree_down; ');
1057: end if;

Line 1054: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1050:
1051: l_function_id := function_id;
1052:
1053: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1054: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1055: c_log_head || l_api_name || '.end',
1056: 'Returning with call to process_menu_tree_down; ');
1057: end if;
1058: return process_menu_tree_down(Fnd_Global.Resp_Appl_Id,

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

1077: else
1078: p_chk_gnt_as_vc := 'N';
1079: end if;
1080:
1081: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1082: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1083: c_log_head || l_api_name || '.begin',
1084: c_pkg_name || '.' ||l_api_name|| '(' ||
1085: 'p_menu_id =>'|| to_char(p_menu_id) ||

Line 1082: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1078: p_chk_gnt_as_vc := 'N';
1079: end if;
1080:
1081: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1082: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1083: c_log_head || l_api_name || '.begin',
1084: c_pkg_name || '.' ||l_api_name|| '(' ||
1085: 'p_menu_id =>'|| to_char(p_menu_id) ||
1086: 'p_check_grant_flag (as vc) =>'|| p_chk_gnt_as_vc || ');');

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

1100: and rownum = 1;
1101: /* If we got here, there are compiled rows */
1102: some_compiled_menus := TRUE;
1103:
1104: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1105: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1106: c_log_head || l_api_name || '.compiled_rows',
1107: 'There are compiled rows.');
1108: end if;

Line 1105: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1101: /* If we got here, there are compiled rows */
1102: some_compiled_menus := TRUE;
1103:
1104: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1105: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1106: c_log_head || l_api_name || '.compiled_rows',
1107: 'There are compiled rows.');
1108: end if;
1109: exception

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

1122: and grant_flag = C_INVALID_GRANT_VAL
1123: and rownum = 1;
1124: /* If we got here we know this is marked as not compiled. */
1125: marked_as_not_compiled := TRUE;
1126: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1127: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1128: c_log_head || l_api_name || '.marked_as_not_comp',
1129: 'Menu Marked as not compiled.');
1130: end if;

Line 1127: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1123: and rownum = 1;
1124: /* If we got here we know this is marked as not compiled. */
1125: marked_as_not_compiled := TRUE;
1126: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1127: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1128: c_log_head || l_api_name || '.marked_as_not_comp',
1129: 'Menu Marked as not compiled.');
1130: end if;
1131: exception

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

1138: -- assume the menu must be compiled.
1139: if (some_compiled_menus and (not marked_as_not_compiled)) then
1140: begin
1141: if (p_check_grant_flag) then
1142: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1143: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1144: c_log_head || l_api_name || '.check_w_gflg',
1145: 'Checking with grantflag for p_menu_id: '|| to_char(p_menu_id)
1146: ||' and p_function_id:'||to_char(p_function_id));

Line 1143: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1139: if (some_compiled_menus and (not marked_as_not_compiled)) then
1140: begin
1141: if (p_check_grant_flag) then
1142: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1143: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1144: c_log_head || l_api_name || '.check_w_gflg',
1145: 'Checking with grantflag for p_menu_id: '|| to_char(p_menu_id)
1146: ||' and p_function_id:'||to_char(p_function_id));
1147: end if;

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

1152: where menu_id = p_menu_id
1153: and function_id = p_function_id
1154: and grant_flag = 'Y' ;
1155: else
1156: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1157: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1158: c_log_head || l_api_name || '.check_wo_gflg',
1159: 'Checking without grantflag for p_menu_id: '|| to_char(p_menu_id)
1160: ||' and p_function_id:'||to_char(p_function_id));

Line 1157: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1153: and function_id = p_function_id
1154: and grant_flag = 'Y' ;
1155: else
1156: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1157: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1158: c_log_head || l_api_name || '.check_wo_gflg',
1159: 'Checking without grantflag for p_menu_id: '|| to_char(p_menu_id)
1160: ||' and p_function_id:'||to_char(p_function_id));
1161: end if;

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

1167: and function_id = p_function_id;
1168: end if;
1169:
1170: /* If we got here that means we found the compiled row */
1171: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1172: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1173: c_log_head || l_api_name || '.end_comp_found',
1174: 'found compiled row. returning TRUE');
1175: end if;

Line 1172: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1168: end if;
1169:
1170: /* If we got here that means we found the compiled row */
1171: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1172: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1173: c_log_head || l_api_name || '.end_comp_found',
1174: 'found compiled row. returning TRUE');
1175: end if;
1176: return TRUE;

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

1176: return TRUE;
1177: exception
1178: when no_data_found then
1179: /* Not in compilation, so this function is not in the menu */
1180: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1181: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1182: c_log_head || l_api_name || '.end_comp_nfound',
1183: 'found no compiled row. returning FALSE');
1184: end if;

Line 1181: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1177: exception
1178: when no_data_found then
1179: /* Not in compilation, so this function is not in the menu */
1180: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1181: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1182: c_log_head || l_api_name || '.end_comp_nfound',
1183: 'found no compiled row. returning FALSE');
1184: end if;
1185: return FALSE;

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

1189: begin
1190: FND_JOBS_PKG.SUBMIT_MENU_COMPILE;
1191: exception
1192: when others then /* Don't error out if we can't submit the request.*/
1193: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
1194: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1195: c_log_head || l_api_name || '.req_submit_fail',
1196: 'Could not submit concurrent request FNDSCMPI to recompile menus');
1197: end if;

Line 1194: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

1190: FND_JOBS_PKG.SUBMIT_MENU_COMPILE;
1191: exception
1192: when others then /* Don't error out if we can't submit the request.*/
1193: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
1194: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1195: c_log_head || l_api_name || '.req_submit_fail',
1196: 'Could not submit concurrent request FNDSCMPI to recompile menus');
1197: end if;
1198: end;

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

1197: end if;
1198: end;
1199:
1200: /* The menu is uncompiled so fall back to the full tree search */
1201: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1202: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1203: c_log_head || l_api_name || '.end',
1204: 'uncompiled, fall back. return process_menu_tree_down_for_mn()');
1205: end if;

Line 1202: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1198: end;
1199:
1200: /* The menu is uncompiled so fall back to the full tree search */
1201: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1202: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1203: c_log_head || l_api_name || '.end',
1204: 'uncompiled, fall back. return process_menu_tree_down_for_mn()');
1205: end if;
1206: return process_menu_tree_down_for_mn(p_menu_id, p_function_id,

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

1228: L_CONTEXT_DEPENDENCE varchar2(8) := NULL;
1229: -- modified for bug#5395351
1230: l_function_name fnd_form_functions.function_name%type := NULL;
1231: begin
1232: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1233: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1234: c_log_head || l_api_name || '.begin',
1235: c_pkg_name || '.' ||l_api_name || '(' ||
1236: 'function_id=>'|| function_id||

Line 1233: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1229: -- modified for bug#5395351
1230: l_function_name fnd_form_functions.function_name%type := NULL;
1231: begin
1232: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1233: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1234: c_log_head || l_api_name || '.begin',
1235: c_pkg_name || '.' ||l_api_name || '(' ||
1236: 'function_id=>'|| function_id||
1237: ', object_name=>'|| object_name||

Line 1276: if (fnd_log.LEVEL_EXCEPTION >=

1272: 'a bug against the product that owns the call to this '||
1273: 'routine, which is likely the owner of the object that '||
1274: 'was passed to this routine: '||
1275: object_name);
1276: if (fnd_log.LEVEL_EXCEPTION >=
1277: fnd_log.g_current_runtime_level) then
1278: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
1279: c_log_head || l_api_name || '.end_depr_param',
1280: FALSE);

Line 1277: fnd_log.g_current_runtime_level) then

1273: 'routine, which is likely the owner of the object that '||
1274: 'was passed to this routine: '||
1275: object_name);
1276: if (fnd_log.LEVEL_EXCEPTION >=
1277: fnd_log.g_current_runtime_level) then
1278: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
1279: c_log_head || l_api_name || '.end_depr_param',
1280: FALSE);
1281: end if;

Line 1278: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

1274: 'was passed to this routine: '||
1275: object_name);
1276: if (fnd_log.LEVEL_EXCEPTION >=
1277: fnd_log.g_current_runtime_level) then
1278: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
1279: c_log_head || l_api_name || '.end_depr_param',
1280: FALSE);
1281: end if;
1282: fnd_message.raise_error;

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

1291: where F.FUNCTION_ID = test_instance_id_maintmode.function_id;
1292: exception
1293: when no_data_found then
1294: -- Invalid function name
1295: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1296: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1297: c_log_head || l_api_name || '.end_notfound',
1298: 'returning FALSE');
1299: end if;

Line 1296: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1292: exception
1293: when no_data_found then
1294: -- Invalid function name
1295: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1296: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1297: c_log_head || l_api_name || '.end_notfound',
1298: 'returning FALSE');
1299: end if;
1300: return(FALSE);

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

1354:
1355: <>
1356:
1357: if (ret_bool) then
1358: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1359: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1360: c_log_head || l_api_name || '.end_available',
1361: 'returning TRUE;');
1362: end if;

Line 1359: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1355: <>
1356:
1357: if (ret_bool) then
1358: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1359: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1360: c_log_head || l_api_name || '.end_available',
1361: 'returning TRUE;');
1362: end if;
1363: return TRUE;

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

1361: 'returning TRUE;');
1362: end if;
1363: return TRUE;
1364: else
1365: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1366: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1367: c_log_head || l_api_name || '.end_false',
1368: 'returning FALSE;');
1369: end if;

Line 1366: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1362: end if;
1363: return TRUE;
1364: else
1365: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1366: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1367: c_log_head || l_api_name || '.end_false',
1368: 'returning FALSE;');
1369: end if;
1370: return FALSE;

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

1386: ret_val boolean := FALSE;
1387: L_MAINTENANCE_MODE_SUPPORT varchar2(8) := NULL;
1388: L_CONTEXT_DEPENDENCE varchar2(8) := NULL;
1389: begin
1390: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1391: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1392: c_log_head || l_api_name || '.begin',
1393: c_pkg_name || '.' ||l_api_name|| '(' ||
1394: 'function_id =>'|| function_id ||

Line 1391: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1387: L_MAINTENANCE_MODE_SUPPORT varchar2(8) := NULL;
1388: L_CONTEXT_DEPENDENCE varchar2(8) := NULL;
1389: begin
1390: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1391: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1392: c_log_head || l_api_name || '.begin',
1393: c_pkg_name || '.' ||l_api_name|| '(' ||
1394: 'function_id =>'|| function_id ||
1395: ');');

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

1405: where F.function_id = test_instance_id.function_id;
1406: exception
1407: when no_data_found then
1408: -- Invalid function name
1409: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1410: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1411: c_log_head || l_api_name || '.end_notfound',
1412: 'returning FALSE');
1413: end if;

Line 1410: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1406: exception
1407: when no_data_found then
1408: -- Invalid function name
1409: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1410: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1411: c_log_head || l_api_name || '.end_notfound',
1412: 'returning FALSE');
1413: end if;
1414: return(FALSE);

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

1427: L_CONTEXT_DEPENDENCE,
1428: 'Y');
1429:
1430: if (ret_val) then
1431: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1432: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1433: c_log_head || l_api_name || '.end_available',
1434: 'returning TRUE;');
1435: end if;

Line 1432: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1428: 'Y');
1429:
1430: if (ret_val) then
1431: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1432: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1433: c_log_head || l_api_name || '.end_available',
1434: 'returning TRUE;');
1435: end if;
1436: return TRUE;

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

1434: 'returning TRUE;');
1435: end if;
1436: return TRUE;
1437: else
1438: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1439: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1440: c_log_head || l_api_name || '.end_false',
1441: 'returning FALSE;');
1442: end if;

Line 1439: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1435: end if;
1436: return TRUE;
1437: else
1438: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1439: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1440: c_log_head || l_api_name || '.end_false',
1441: 'returning FALSE;');
1442: end if;
1443: return FALSE;

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

1490: function_id number;
1491: L_MAINTENANCE_MODE_SUPPORT varchar2(8);
1492: L_CONTEXT_DEPENDENCE varchar2(8);
1493: begin
1494: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1495: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1496: c_log_head || l_api_name || '.begin',
1497: c_pkg_name || '.' ||l_api_name|| '(' ||
1498: 'function_name =>'|| function_name ||

Line 1495: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1491: L_MAINTENANCE_MODE_SUPPORT varchar2(8);
1492: L_CONTEXT_DEPENDENCE varchar2(8);
1493: begin
1494: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1495: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1496: c_log_head || l_api_name || '.begin',
1497: c_pkg_name || '.' ||l_api_name|| '(' ||
1498: 'function_name =>'|| function_name ||
1499: 'object_name =>'|| object_name ||

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

1515: where F.FUNCTION_NAME = test_instance.function_name;
1516: exception
1517: when no_data_found then
1518: -- Invalid function name
1519: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1520: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1521: c_log_head || l_api_name || '.end_notfound',
1522: 'returning FALSE');
1523: end if;

Line 1520: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1516: exception
1517: when no_data_found then
1518: -- Invalid function name
1519: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1520: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1521: c_log_head || l_api_name || '.end_notfound',
1522: 'returning FALSE');
1523: end if;
1524: return(FALSE);

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

1537: L_CONTEXT_DEPENDENCE,
1538: 'Y');
1539:
1540: if (ret_val) then
1541: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1542: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1543: c_log_head || l_api_name || '.end_available',
1544: 'returning TRUE;');
1545: end if;

Line 1542: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1538: 'Y');
1539:
1540: if (ret_val) then
1541: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1542: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1543: c_log_head || l_api_name || '.end_available',
1544: 'returning TRUE;');
1545: end if;
1546: return TRUE;

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

1544: 'returning TRUE;');
1545: end if;
1546: return TRUE;
1547: else
1548: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1549: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1550: c_log_head || l_api_name || '.end_false',
1551: 'returning FALSE;');
1552: end if;

Line 1549: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1545: end if;
1546: return TRUE;
1547: else
1548: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1549: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1550: c_log_head || l_api_name || '.end_false',
1551: 'returning FALSE;');
1552: end if;
1553: return FALSE;

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

1577: is
1578: l_api_name CONSTANT VARCHAR2(30) := 'TEST_ID(4_ARGS)';
1579: result boolean;
1580: begin
1581: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1582: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1583: c_log_head || l_api_name || '.begin',
1584: c_pkg_name || '.' ||l_api_name|| '(' ||
1585: 'function_id =>'|| function_id ||

Line 1582: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1578: l_api_name CONSTANT VARCHAR2(30) := 'TEST_ID(4_ARGS)';
1579: result boolean;
1580: begin
1581: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1582: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1583: c_log_head || l_api_name || '.begin',
1584: c_pkg_name || '.' ||l_api_name|| '(' ||
1585: 'function_id =>'|| function_id ||
1586: 'MAINTENANCE_MODE_SUPPORT =>'|| MAINTENANCE_MODE_SUPPORT ||

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

1602: CONTEXT_DEPENDENCE => CONTEXT_DEPENDENCE,
1603: TEST_MAINT_AVAILABILITY => TEST_MAINT_AVAILABILITY);
1604:
1605: if (result) then
1606: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1607: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1608: c_log_head || l_api_name || '.end_available',
1609: 'returning TRUE;');
1610: end if;

Line 1607: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1603: TEST_MAINT_AVAILABILITY => TEST_MAINT_AVAILABILITY);
1604:
1605: if (result) then
1606: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1607: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1608: c_log_head || l_api_name || '.end_available',
1609: 'returning TRUE;');
1610: end if;
1611: return TRUE;

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

1609: 'returning TRUE;');
1610: end if;
1611: return TRUE;
1612: else
1613: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1614: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1615: c_log_head || l_api_name || '.end_false',
1616: 'returning FALSE;');
1617: end if;

Line 1614: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1610: end if;
1611: return TRUE;
1612: else
1613: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1614: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1615: c_log_head || l_api_name || '.end_false',
1616: 'returning FALSE;');
1617: end if;
1618: return FALSE;

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

1637: L_CONTEXT_DEPENDENCE varchar2(8);
1638: l_function_id number;
1639: l_api_name CONSTANT VARCHAR2(30) := 'TEST_ID(1_ARG)';
1640: begin
1641: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1642: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1643: c_log_head || l_api_name || '.begin',
1644: c_pkg_name || '.' ||l_api_name|| '(' ||
1645: 'function_id =>'|| function_id || ');');

Line 1642: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1638: l_function_id number;
1639: l_api_name CONSTANT VARCHAR2(30) := 'TEST_ID(1_ARG)';
1640: begin
1641: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1642: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1643: c_log_head || l_api_name || '.begin',
1644: c_pkg_name || '.' ||l_api_name|| '(' ||
1645: 'function_id =>'|| function_id || ');');
1646: end if;

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

1656: where function_id = l_function_id;
1657:
1658: exception
1659: when no_data_found then
1660: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1661: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1662: c_log_head || l_api_name || '.end_bad_fnid',
1663: 'function_id passed to test_id cant be found in fnd_form_functions.');
1664: end if;

Line 1661: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1657:
1658: exception
1659: when no_data_found then
1660: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1661: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1662: c_log_head || l_api_name || '.end_bad_fnid',
1663: 'function_id passed to test_id cant be found in fnd_form_functions.');
1664: end if;
1665: return FALSE; /* Bad function id passed */

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

1664: end if;
1665: return FALSE; /* Bad function id passed */
1666: end;
1667:
1668: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1669: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1670: c_log_head || l_api_name || '.end_call_3_arg',
1671: 'Passing MAINTENANCE_MODE_SUPPORT and CONTEXT_DEPENDENCE to test_id().');
1672: end if;

Line 1669: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1665: return FALSE; /* Bad function id passed */
1666: end;
1667:
1668: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1669: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1670: c_log_head || l_api_name || '.end_call_3_arg',
1671: 'Passing MAINTENANCE_MODE_SUPPORT and CONTEXT_DEPENDENCE to test_id().');
1672: end if;
1673:

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

1696: function_id number;
1697: L_MAINTENANCE_MODE_SUPPORT varchar2(8);
1698: L_CONTEXT_DEPENDENCE varchar2(8);
1699: begin
1700: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1701: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1702: c_log_head || l_api_name || '.begin',
1703: c_pkg_name || '.' ||l_api_name|| '(' ||
1704: 'function_name =>'|| function_name || ');');

Line 1701: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1697: L_MAINTENANCE_MODE_SUPPORT varchar2(8);
1698: L_CONTEXT_DEPENDENCE varchar2(8);
1699: begin
1700: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1701: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1702: c_log_head || l_api_name || '.begin',
1703: c_pkg_name || '.' ||l_api_name|| '(' ||
1704: 'function_name =>'|| function_name || ');');
1705: end if;

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

1712: where F.FUNCTION_NAME = test.function_name;
1713: exception
1714: when no_data_found then
1715: -- Invalid function name
1716: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1717: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1718: c_log_head || l_api_name || '.end_notfound',
1719: 'returning FALSE');
1720: end if;

Line 1717: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1713: exception
1714: when no_data_found then
1715: -- Invalid function name
1716: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1717: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1718: c_log_head || l_api_name || '.end_notfound',
1719: 'returning FALSE');
1720: end if;
1721: return(FALSE);

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

1721: return(FALSE);
1722: end;
1723:
1724: -- Call test_id to complete
1725: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1726: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1727: c_log_head || l_api_name || '.end',
1728: 'returning call to test_id of function_id:'||function_id
1729: ||' L_MAINTENANCE_MODE_SUPPORT:'||L_MAINTENANCE_MODE_SUPPORT

Line 1726: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1722: end;
1723:
1724: -- Call test_id to complete
1725: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1726: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1727: c_log_head || l_api_name || '.end',
1728: 'returning call to test_id of function_id:'||function_id
1729: ||' L_MAINTENANCE_MODE_SUPPORT:'||L_MAINTENANCE_MODE_SUPPORT
1730: ||' L_CONTEXT_DEPENDENCE:'||L_CONTEXT_DEPENDENCE);

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

1759: l_api_name CONSTANT VARCHAR2(30) := 'COMPILE';
1760: numrows NUMBER;
1761: msgbuf varchar2(2000);
1762: begin
1763: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1764: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1765: c_log_head || l_api_name || '.begin',
1766: c_pkg_name || '.' ||l_api_name ||'(' ||
1767: 'everything=>'|| everything||');');

Line 1764: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1760: numrows NUMBER;
1761: msgbuf varchar2(2000);
1762: begin
1763: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1764: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1765: c_log_head || l_api_name || '.begin',
1766: c_pkg_name || '.' ||l_api_name ||'(' ||
1767: 'everything=>'|| everything||');');
1768: end if;

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

1783: fnd_message.set_token('ROWS', numrows);
1784: msgbuf := fnd_message.get;
1785: FND_FILE.put_line(FND_FILE.log, msgbuf);
1786:
1787: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1788: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1789: c_log_head || l_api_name || '.end',
1790: 'returning from compile. numrows='||numrows);
1791: end if;

Line 1788: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1784: msgbuf := fnd_message.get;
1785: FND_FILE.put_line(FND_FILE.log, msgbuf);
1786:
1787: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1788: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1789: c_log_head || l_api_name || '.end',
1790: 'returning from compile. numrows='||numrows);
1791: end if;
1792: exception

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

1793: when others then
1794: errbuf := sqlerrm;
1795: retcode := '2';
1796: FND_FILE.put_line(FND_FILE.log,errbuf);
1797: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1798: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1799: c_log_head || l_api_name || '.end_exception',
1800: 'returning from compile with exception. numrows='||numrows);
1801: end if;

Line 1798: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1794: errbuf := sqlerrm;
1795: retcode := '2';
1796: FND_FILE.put_line(FND_FILE.log,errbuf);
1797: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1798: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1799: c_log_head || l_api_name || '.end_exception',
1800: 'returning from compile with exception. numrows='||numrows);
1801: end if;
1802: raise;

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

1828: RSTATUS number;
1829: begin
1830: FND_JOBS_PKG.APPS_INITIALIZE_SYSADMIN;
1831:
1832: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1833: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1834: c_log_head || l_api_name || '.begin',
1835: c_pkg_name || '.' ||l_api_name ||';');
1836: end if;

Line 1833: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1829: begin
1830: FND_JOBS_PKG.APPS_INITIALIZE_SYSADMIN;
1831:
1832: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1833: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1834: c_log_head || l_api_name || '.begin',
1835: c_pkg_name || '.' ||l_api_name ||';');
1836: end if;
1837:

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

1843: end;
1844: RSTATUS := DBMS_LOCK.RELEASE(C_MENU_LOCK_ID);
1845: end if;
1846:
1847: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1848: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1849: c_log_head || l_api_name || '.end',
1850: 'returning from compile. numrows='||numrows);
1851: end if;

Line 1848: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1844: RSTATUS := DBMS_LOCK.RELEASE(C_MENU_LOCK_ID);
1845: end if;
1846:
1847: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1848: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1849: c_log_head || l_api_name || '.end',
1850: 'returning from compile. numrows='||numrows);
1851: end if;
1852:

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

1851: end if;
1852:
1853: exception
1854: when others then
1855: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1856: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1857: c_log_head || l_api_name || '.end_exception',
1858: 'returning from compile with exception. numrows='||numrows);
1859: end if;

Line 1856: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1852:
1853: exception
1854: when others then
1855: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1856: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1857: c_log_head || l_api_name || '.end_exception',
1858: 'returning from compile with exception. numrows='||numrows);
1859: end if;
1860: -- ### Should log return code = 2 and sqlerrm buffer

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

1866: -- Recompiles everything from scratch.
1867: function COMPILE_ALL_FROM_SCRATCH_I return NUMBER is
1868: l_api_name CONSTANT VARCHAR2(30) := 'COMPILE_ALL_FROM_SCRATCH';
1869: begin
1870: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1871: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1872: c_log_head || l_api_name || '.begin',
1873: c_pkg_name || '.' ||l_api_name );
1874: end if;

Line 1871: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1867: function COMPILE_ALL_FROM_SCRATCH_I return NUMBER is
1868: l_api_name CONSTANT VARCHAR2(30) := 'COMPILE_ALL_FROM_SCRATCH';
1869: begin
1870: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1871: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1872: c_log_head || l_api_name || '.begin',
1873: c_pkg_name || '.' ||l_api_name );
1874: end if;
1875: MARK_ALL_I;

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

1872: c_log_head || l_api_name || '.begin',
1873: c_pkg_name || '.' ||l_api_name );
1874: end if;
1875: MARK_ALL_I;
1876: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1877: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1878: c_log_head || l_api_name || '.end',
1879: 'returning COMPILE_ALL_MARKED');
1880: end if;

Line 1877: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1873: c_pkg_name || '.' ||l_api_name );
1874: end if;
1875: MARK_ALL_I;
1876: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1877: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1878: c_log_head || l_api_name || '.end',
1879: 'returning COMPILE_ALL_MARKED');
1880: end if;
1881: return COMPILE_ALL_MARKED_I('Y');

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

1924: from fnd_compiled_menu_functions cmf
1925: where menus.menu_id = cmf.menu_id);
1926: z number;
1927: begin
1928: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1929: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1930: c_log_head || l_api_name || '.begin',
1931: c_pkg_name || '.' ||l_api_name );
1932: end if;

Line 1929: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1925: where menus.menu_id = cmf.menu_id);
1926: z number;
1927: begin
1928: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1929: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1930: c_log_head || l_api_name || '.begin',
1931: c_pkg_name || '.' ||l_api_name );
1932: end if;
1933:

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

1962: end loop;
1963: last_index := z;
1964: end if;
1965:
1966: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1967: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1968: c_log_head || l_api_name || '.got_list',
1969: 'Got list of menus. Number of elements- last_index:' ||
1970: last_index);

Line 1967: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1963: last_index := z;
1964: end if;
1965:
1966: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1967: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1968: c_log_head || l_api_name || '.got_list',
1969: 'Got list of menus. Number of elements- last_index:' ||
1970: last_index);
1971: end if;

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

1981: -- from getting too big as we compile lots of menus.
1982: commit;
1983: exception
1984: when dup_val_on_index then
1985: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
1986: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1987: c_log_head || l_api_name || '.exception',
1988: 'Duplicate Value on index. Should never happen.');
1989: end if;

Line 1986: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

1982: commit;
1983: exception
1984: when dup_val_on_index then
1985: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
1986: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1987: c_log_head || l_api_name || '.exception',
1988: 'Duplicate Value on index. Should never happen.');
1989: end if;
1990: null; /* Should never happen but better safe than sorry */

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

1989: end if;
1990: null; /* Should never happen but better safe than sorry */
1991: end;
1992: end loop;
1993: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1994: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1995: c_log_head || l_api_name || '.end',
1996: 'end');
1997: end if;

Line 1994: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1990: null; /* Should never happen but better safe than sorry */
1991: end;
1992: end loop;
1993: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1994: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1995: c_log_head || l_api_name || '.end',
1996: 'end');
1997: end if;
1998: end MARK_MISSING;

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

2016: TYPE NUMBER_TABLE_TYPE is table of NUMBER INDEX BY BINARY_INTEGER;
2017: TBL_MENU_ID NUMBER_TABLE_TYPE;
2018:
2019: begin
2020: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
2021: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2022: c_log_head || l_api_name || '.begin',
2023: c_pkg_name || '.' ||l_api_name ||'(' ||
2024: 'compile_missing=>'|| compile_missing||');');

Line 2021: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

2017: TBL_MENU_ID NUMBER_TABLE_TYPE;
2018:
2019: begin
2020: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
2021: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2022: c_log_head || l_api_name || '.begin',
2023: c_pkg_name || '.' ||l_api_name ||'(' ||
2024: 'compile_missing=>'|| compile_missing||');');
2025: end if;

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

2043: and rownum = 1;
2044: exception
2045: when no_data_found then
2046: /* We've gotten to all the marked rows, so we are done */
2047: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
2048: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2049: c_log_head || l_api_name || '.end_none_marked',
2050: 'returning l_rows_processed:' || l_rows_processed );
2051: end if;

Line 2048: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

2044: exception
2045: when no_data_found then
2046: /* We've gotten to all the marked rows, so we are done */
2047: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
2048: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2049: c_log_head || l_api_name || '.end_none_marked',
2050: 'returning l_rows_processed:' || l_rows_processed );
2051: end if;
2052:

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

2064:
2065: end loop;
2066:
2067: fnd_function.g_already_fast_compiled := 'T';
2068: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
2069: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2070: c_log_head || l_api_name || '.end',
2071: 'returning l_rows_processed:' || l_rows_processed );
2072: end if;

Line 2069: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

2065: end loop;
2066:
2067: fnd_function.g_already_fast_compiled := 'T';
2068: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
2069: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2070: c_log_head || l_api_name || '.end',
2071: 'returning l_rows_processed:' || l_rows_processed );
2072: end if;
2073: return l_rows_processed;

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

2212: comp_fail exception;
2213: i number;
2214: j number;
2215: begin
2216: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
2217: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2218: c_log_head || l_api_name || '.begin',
2219: c_pkg_name || '.' ||l_api_name|| '(' ||
2220: 'p_menu_id =>'|| p_menu_id ||

Line 2217: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

2213: i number;
2214: j number;
2215: begin
2216: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
2217: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2218: c_log_head || l_api_name || '.begin',
2219: c_pkg_name || '.' ||l_api_name|| '(' ||
2220: 'p_menu_id =>'|| p_menu_id ||
2221: 'p_force =>'|| p_force || ');');

Line 2245: if (fnd_log.LEVEL_ERROR >= fnd_log.g_current_runtime_level) then

2241: /* Check the recursion stack to make sure this menu isn't also a */
2242: /* parent of this menu. */
2243: for i in 1..TBL_RECURS_DETEC_MENU_ID_MAX loop
2244: if ( TBL_RECURS_DETEC_MENU_ID(i) = p_menu_id ) then
2245: if (fnd_log.LEVEL_ERROR >= fnd_log.g_current_runtime_level) then
2246: fnd_log.string(FND_LOG.LEVEL_ERROR,
2247: c_log_head || l_api_name || '.recursion',
2248: 'A looping menu has been detected in menu_id:'||to_char(p_menu_id));
2249: end if;

Line 2246: fnd_log.string(FND_LOG.LEVEL_ERROR,

2242: /* parent of this menu. */
2243: for i in 1..TBL_RECURS_DETEC_MENU_ID_MAX loop
2244: if ( TBL_RECURS_DETEC_MENU_ID(i) = p_menu_id ) then
2245: if (fnd_log.LEVEL_ERROR >= fnd_log.g_current_runtime_level) then
2246: fnd_log.string(FND_LOG.LEVEL_ERROR,
2247: c_log_head || l_api_name || '.recursion',
2248: 'A looping menu has been detected in menu_id:'||to_char(p_menu_id));
2249: end if;
2250:

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

2303: end if;
2304:
2305:
2306:
2307: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2308: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2309: c_log_head || l_api_name || '.got_mnulist',
2310: 'Got list of mnes below p_menu_id '||
2311: to_char(p_menu_id)||'. Number of elements- last_index:'

Line 2308: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

2304:
2305:
2306:
2307: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2308: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2309: c_log_head || l_api_name || '.got_mnulist',
2310: 'Got list of mnes below p_menu_id '||
2311: to_char(p_menu_id)||'. Number of elements- last_index:'
2312: ||to_char(last_index));

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

2316: for q in 1..last_index loop
2317: /* If this is a function, Put this function into the cache */
2318: if (tbl_func_id(q) is not NULL) then
2319: begin
2320: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2321: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2322: c_log_head || l_api_name || '.insert1',
2323: 'Inserting into compiled table menu_id: '|| to_char(p_menu_id)
2324: ||' func_id:'||to_char(tbl_func_id(q) )

Line 2321: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

2317: /* If this is a function, Put this function into the cache */
2318: if (tbl_func_id(q) is not NULL) then
2319: begin
2320: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2321: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2322: c_log_head || l_api_name || '.insert1',
2323: 'Inserting into compiled table menu_id: '|| to_char(p_menu_id)
2324: ||' func_id:'||to_char(tbl_func_id(q) )
2325: ||' gnt_flag:'||tbl_gnt_flg(q) );

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

2330: values
2331: (p_menu_id, tbl_func_id(q), tbl_gnt_flg(q));
2332: exception
2333: when dup_val_on_index then
2334: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2335: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2336: c_log_head || l_api_name || '.dup_val_index',
2337: 'Insert failed with dup val on index. No Problem.');
2338: end if;

Line 2335: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

2331: (p_menu_id, tbl_func_id(q), tbl_gnt_flg(q));
2332: exception
2333: when dup_val_on_index then
2334: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2335: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2336: c_log_head || l_api_name || '.dup_val_index',
2337: 'Insert failed with dup val on index. No Problem.');
2338: end if;
2339: if (tbl_gnt_flg(q) <> 'N') then /* don't overwrite 'Y' with 'N'*/

Line 2340: if (fnd_log.LEVEL_STATEMENT >=

2336: c_log_head || l_api_name || '.dup_val_index',
2337: 'Insert failed with dup val on index. No Problem.');
2338: end if;
2339: if (tbl_gnt_flg(q) <> 'N') then /* don't overwrite 'Y' with 'N'*/
2340: if (fnd_log.LEVEL_STATEMENT >=
2341: fnd_log.g_current_runtime_level) then
2342: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2343: c_log_head || l_api_name || '.upd_gnt_flag',
2344: 'About to update grant_flag.');

Line 2341: fnd_log.g_current_runtime_level) then

2337: 'Insert failed with dup val on index. No Problem.');
2338: end if;
2339: if (tbl_gnt_flg(q) <> 'N') then /* don't overwrite 'Y' with 'N'*/
2340: if (fnd_log.LEVEL_STATEMENT >=
2341: fnd_log.g_current_runtime_level) then
2342: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2343: c_log_head || l_api_name || '.upd_gnt_flag',
2344: 'About to update grant_flag.');
2345: end if;

Line 2342: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

2338: end if;
2339: if (tbl_gnt_flg(q) <> 'N') then /* don't overwrite 'Y' with 'N'*/
2340: if (fnd_log.LEVEL_STATEMENT >=
2341: fnd_log.g_current_runtime_level) then
2342: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2343: c_log_head || l_api_name || '.upd_gnt_flag',
2344: 'About to update grant_flag.');
2345: end if;
2346: /* If the grant flag isn't right, update it. */

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

2355:
2356: /* Compile the sub menu, recursively, and then copy the compiled */
2357: /* rows from the submenu into this menu. */
2358: if (tbl_submnu_id(q) is not NULL) then
2359: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2360: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2361: c_log_head || l_api_name || '.call_recursive',
2362: 'Calling recursively for tbl_submnu_id(q): '||
2363: tbl_submnu_id(q));

Line 2360: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

2356: /* Compile the sub menu, recursively, and then copy the compiled */
2357: /* rows from the submenu into this menu. */
2358: if (tbl_submnu_id(q) is not NULL) then
2359: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2360: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2361: c_log_head || l_api_name || '.call_recursive',
2362: 'Calling recursively for tbl_submnu_id(q): '||
2363: tbl_submnu_id(q));
2364: end if;

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

2408: /* put those entries into the compilation for the menu worked on. */
2409: for z in 1..last_index loop
2410: begin
2411:
2412: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2413: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2414: c_log_head || l_api_name || '.insert2',
2415: 'Inserting into compiled table p_menu_id: '|| to_char(p_menu_id)
2416: ||' tbl_copy_func_id(z):'||tbl_copy_func_id(z)

Line 2413: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

2409: for z in 1..last_index loop
2410: begin
2411:
2412: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2413: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2414: c_log_head || l_api_name || '.insert2',
2415: 'Inserting into compiled table p_menu_id: '|| to_char(p_menu_id)
2416: ||' tbl_copy_func_id(z):'||tbl_copy_func_id(z)
2417: ||' tbl_copy_gnt_flg(ze):'||tbl_copy_gnt_flg(z) );

Line 2428: if (fnd_log.LEVEL_STATEMENT >=

2424: when dup_val_on_index then
2425: if (l_rows_processed > 1) then
2426: l_rows_processed := l_rows_processed - 1;
2427: end if;
2428: if (fnd_log.LEVEL_STATEMENT >=
2429: fnd_log.g_current_runtime_level) then
2430: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2431: c_log_head || l_api_name || '.dup_val_index2',
2432: 'Insert failed with dup val on index. No Problem.');

Line 2429: fnd_log.g_current_runtime_level) then

2425: if (l_rows_processed > 1) then
2426: l_rows_processed := l_rows_processed - 1;
2427: end if;
2428: if (fnd_log.LEVEL_STATEMENT >=
2429: fnd_log.g_current_runtime_level) then
2430: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2431: c_log_head || l_api_name || '.dup_val_index2',
2432: 'Insert failed with dup val on index. No Problem.');
2433: end if;

Line 2430: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

2426: l_rows_processed := l_rows_processed - 1;
2427: end if;
2428: if (fnd_log.LEVEL_STATEMENT >=
2429: fnd_log.g_current_runtime_level) then
2430: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2431: c_log_head || l_api_name || '.dup_val_index2',
2432: 'Insert failed with dup val on index. No Problem.');
2433: end if;
2434: if (tbl_copy_gnt_flg(z) <> 'N') then/*don't overwrite 'Y' w/ 'N'*/

Line 2435: if (fnd_log.LEVEL_STATEMENT >=

2431: c_log_head || l_api_name || '.dup_val_index2',
2432: 'Insert failed with dup val on index. No Problem.');
2433: end if;
2434: if (tbl_copy_gnt_flg(z) <> 'N') then/*don't overwrite 'Y' w/ 'N'*/
2435: if (fnd_log.LEVEL_STATEMENT >=
2436: fnd_log.g_current_runtime_level) then
2437: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2438: c_log_head || l_api_name || '.upd_gnt_flag2',
2439: 'About to update grant_flag.');

Line 2436: fnd_log.g_current_runtime_level) then

2432: 'Insert failed with dup val on index. No Problem.');
2433: end if;
2434: if (tbl_copy_gnt_flg(z) <> 'N') then/*don't overwrite 'Y' w/ 'N'*/
2435: if (fnd_log.LEVEL_STATEMENT >=
2436: fnd_log.g_current_runtime_level) then
2437: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2438: c_log_head || l_api_name || '.upd_gnt_flag2',
2439: 'About to update grant_flag.');
2440: end if;

Line 2437: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

2433: end if;
2434: if (tbl_copy_gnt_flg(z) <> 'N') then/*don't overwrite 'Y' w/ 'N'*/
2435: if (fnd_log.LEVEL_STATEMENT >=
2436: fnd_log.g_current_runtime_level) then
2437: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2438: c_log_head || l_api_name || '.upd_gnt_flag2',
2439: 'About to update grant_flag.');
2440: end if;
2441: /* If the grant flag isn't right, update it. */

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

2453: /* If there were no functions in this menu, then insert a "blank" mark */
2454: /* to indicate that we've compiled this menu but there are no fns. */
2455: if (l_rows_processed = 0) then
2456: begin
2457: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2458: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2459: c_log_head || l_api_name || '.insert_blank',
2460: 'Inserting blank row into compiled table p_menu_id: '||
2461: to_char(p_menu_id) );

Line 2458: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

2454: /* to indicate that we've compiled this menu but there are no fns. */
2455: if (l_rows_processed = 0) then
2456: begin
2457: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2458: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2459: c_log_head || l_api_name || '.insert_blank',
2460: 'Inserting blank row into compiled table p_menu_id: '||
2461: to_char(p_menu_id) );
2462: end if;

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

2465: values
2466: (p_menu_id, C_BLANK_MENU_VAL, C_BLANK_GRANT_VAL);
2467: exception
2468: when dup_val_on_index then
2469: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2470: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2471: c_log_head || l_api_name || '.dup_val_index3',
2472: 'Insert failed with dup val on index. No Problem.');
2473: end if;

Line 2470: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

2466: (p_menu_id, C_BLANK_MENU_VAL, C_BLANK_GRANT_VAL);
2467: exception
2468: when dup_val_on_index then
2469: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2470: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2471: c_log_head || l_api_name || '.dup_val_index3',
2472: 'Insert failed with dup val on index. No Problem.');
2473: end if;
2474: null; /* Only put one copy of this row */

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

2475: end;
2476: end if;
2477:
2478: /* now that this menu has been compiled, remove the "uncompiled mark" */
2479: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2480: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2481: c_log_head || l_api_name || '.del_mark',
2482: 'Removing uncompiled mark from p_menu_id:'||p_menu_id);
2483: end if;

Line 2480: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

2476: end if;
2477:
2478: /* now that this menu has been compiled, remove the "uncompiled mark" */
2479: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2480: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2481: c_log_head || l_api_name || '.del_mark',
2482: 'Removing uncompiled mark from p_menu_id:'||p_menu_id);
2483: end if;
2484: begin

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

2499: else
2500: TBL_RECURS_DETEC_MENU_ID_MAX := TBL_RECURS_DETEC_MENU_ID_MAX - 1;
2501: end if;
2502:
2503: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
2504: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2505: c_log_head || l_api_name || '.end',
2506: 'returning l_rows_processed:' || l_rows_processed );
2507: end if;

Line 2504: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

2500: TBL_RECURS_DETEC_MENU_ID_MAX := TBL_RECURS_DETEC_MENU_ID_MAX - 1;
2501: end if;
2502:
2503: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
2504: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2505: c_log_head || l_api_name || '.end',
2506: 'returning l_rows_processed:' || l_rows_processed );
2507: end if;
2508: return l_rows_processed;

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

2565: more_to_delete boolean;
2566:
2567: z number;
2568: begin
2569: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
2570: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2571: c_log_head || l_api_name || '.begin',
2572: c_pkg_name || '.' ||l_api_name );
2573: end if;

Line 2570: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

2566:
2567: z number;
2568: begin
2569: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
2570: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2571: c_log_head || l_api_name || '.begin',
2572: c_pkg_name || '.' ||l_api_name );
2573: end if;
2574:

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

2624: end loop;
2625: last_index := z;
2626: end if;
2627:
2628: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2629: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2630: c_log_head || l_api_name || '.got_mnulist',
2631: 'Got list of menus. Number of elements- last_index:'||
2632: last_index);

Line 2629: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

2625: last_index := z;
2626: end if;
2627:
2628: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2629: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2630: c_log_head || l_api_name || '.got_mnulist',
2631: 'Got list of menus. Number of elements- last_index:'||
2632: last_index);
2633: end if;

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

2643: -- from getting too big as we compile lots of menus.
2644: commit;
2645: exception
2646: when dup_val_on_index then
2647: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2648: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2649: c_log_head || l_api_name || '.dup_val_index',
2650: 'Mark failed because of dup val on index. Shouldnt happen.');
2651: end if;

Line 2648: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

2644: commit;
2645: exception
2646: when dup_val_on_index then
2647: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2648: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2649: c_log_head || l_api_name || '.dup_val_index',
2650: 'Mark failed because of dup val on index. Shouldnt happen.');
2651: end if;
2652: null; /* Should never happen but better safe than sorry */

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

2652: null; /* Should never happen but better safe than sorry */
2653: end;
2654: end loop;
2655:
2656: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
2657: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2658: c_log_head || l_api_name || '.end',
2659: 'end');
2660: end if;

Line 2657: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

2653: end;
2654: end loop;
2655:
2656: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
2657: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2658: c_log_head || l_api_name || '.end',
2659: 'end');
2660: end if;
2661: end mark_all_I;

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

2688: ) return number is
2689: v_function_id number;
2690: l_api_name CONSTANT VARCHAR2(30) := 'GET_FUNCTION_ID';
2691: Begin
2692: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
2693: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2694: c_log_head || l_api_name || '.begin',
2695: c_pkg_name || '.' ||l_api_name|| '(' ||
2696: 'p_function_name =>'|| p_function_name ||');');

Line 2693: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

2689: v_function_id number;
2690: l_api_name CONSTANT VARCHAR2(30) := 'GET_FUNCTION_ID';
2691: Begin
2692: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
2693: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2694: c_log_head || l_api_name || '.begin',
2695: c_pkg_name || '.' ||l_api_name|| '(' ||
2696: 'p_function_name =>'|| p_function_name ||');');
2697: end if;

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

2709: g_func_name_cache := p_function_name;
2710: end if;
2711:
2712:
2713: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
2714: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2715: c_log_head || l_api_name || '.end',
2716: 'returning v_function_id:' || v_function_id);
2717: end if;

Line 2714: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

2710: end if;
2711:
2712:
2713: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
2714: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2715: c_log_head || l_api_name || '.end',
2716: 'returning v_function_id:' || v_function_id);
2717: end if;
2718: return v_function_id;

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

2717: end if;
2718: return v_function_id;
2719: exception
2720: when no_data_found then
2721: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
2722: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2723: c_log_head || l_api_name || '.end_null',
2724: 'returning null');
2725: end if;

Line 2722: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

2718: return v_function_id;
2719: exception
2720: when no_data_found then
2721: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
2722: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2723: c_log_head || l_api_name || '.end_null',
2724: 'returning null');
2725: end if;
2726: return null;