APPS.FND_MENU_ENTRIES_PKG dependencies on FND_MENUS

Line 450: from fnd_menus

446:
447: if (l_sub_menu_name is not null) then
448: begin
449: select menu_id into sub_mnu_id
450: from fnd_menus
451: where menu_name = X_SUB_MENU_NAME;
452: exception
453: when no_data_found then
454: /* The sub menu doesn't yet exist so create a dummy menu*/

Line 460: fnd_menus_pkg.LOAD_ROW(

456: /* 2225482 about uploading menus whose children hadn't */
457: /* yet been uploaded. This dummy menu will end up getting */
458: /* updated with the real menu information later on during */
459: /* the load when the real menu data gets uploaded. */
460: fnd_menus_pkg.LOAD_ROW(
461: x_menu_name => X_SUB_MENU_NAME,
462: x_menu_type => NULL,
463: x_user_menu_name => X_SUB_MENU_NAME,
464: x_description => NULL,

Line 470: from fnd_menus

466: x_custom_mode => X_CUSTOM_MODE,
467: x_last_update_date => X_LAST_UPDATE_DATE);
468: begin
469: select menu_id into sub_mnu_id
470: from fnd_menus
471: where menu_name = X_SUB_MENU_NAME;
472: exception /* This should never happen since we have already loaded*/
473: when no_data_found then
474: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

Line 475: fnd_message.set_token('TABLE', 'FND_MENUS');

471: where menu_name = X_SUB_MENU_NAME;
472: exception /* This should never happen since we have already loaded*/
473: when no_data_found then
474: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
475: fnd_message.set_token('TABLE', 'FND_MENUS');
476: fnd_message.set_token('COLUMN', 'MENU_NAME');
477: fnd_message.set_token('VALUE', x_sub_menu_name);
478: app_exception.raise_exception;
479: return;

Line 514: from fnd_menus

510: begin
511: -- FOR UPDATE is added, to make the upload of entries for the same menu
512: -- from diff ldt files sequential. This is for bug 3657426.
513: select menu_id into mnu_id
514: from fnd_menus
515: where menu_name = X_MENU_NAME
516: for update;
517: exception
518: when no_data_found then

Line 520: fnd_message.set_token('TABLE', 'FND_MENUS');

516: for update;
517: exception
518: when no_data_found then
519: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
520: fnd_message.set_token('TABLE', 'FND_MENUS');
521: fnd_message.set_token('COLUMN', 'MENU_NAME');
522: fnd_message.set_token('VALUE', x_menu_name);
523: app_exception.raise_exception;
524: return;