149: open c;
150: fetch c into recinfo;
151: if (c%notfound) then
152: close c;
153: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
154: app_exception.raise_exception;
155: end if;
156: close c;
157: if ( ((recinfo.SUB_MENU_ID = X_SUB_MENU_ID)
162: OR ((recinfo.GRANT_FLAG is null) AND (L_GRANT_FLAG is null)))
163: ) then
164: null;
165: else
166: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
167: app_exception.raise_exception;
168: end if;
169:
170: open c1;
181: OR ((tlinfo.DESCRIPTION is null) AND (X_DESCRIPTION is null)))
182: ) then
183: null;
184: else
185: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
186: app_exception.raise_exception;
187: end if;
188: return;
189: end LOCK_ROW;
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');
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;
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;
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;
480: end;
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;
480: end;
481: end;
495: from fnd_form_functions
496: where function_name = X_FUNCTION_NAME;
497: exception
498: when no_data_found then
499: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
500: fnd_message.set_token('TABLE', 'FND_FORM_FUNCTIONS');
501: fnd_message.set_token('COLUMN', 'FUNCTION_NAME');
502: fnd_message.set_token('VALUE', x_function_name);
503: app_exception.raise_exception;
496: where function_name = X_FUNCTION_NAME;
497: exception
498: when no_data_found then
499: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
500: fnd_message.set_token('TABLE', 'FND_FORM_FUNCTIONS');
501: fnd_message.set_token('COLUMN', 'FUNCTION_NAME');
502: fnd_message.set_token('VALUE', x_function_name);
503: app_exception.raise_exception;
504: return;
497: exception
498: when no_data_found then
499: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
500: fnd_message.set_token('TABLE', 'FND_FORM_FUNCTIONS');
501: fnd_message.set_token('COLUMN', 'FUNCTION_NAME');
502: fnd_message.set_token('VALUE', x_function_name);
503: app_exception.raise_exception;
504: return;
505: end;
498: when no_data_found then
499: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
500: fnd_message.set_token('TABLE', 'FND_FORM_FUNCTIONS');
501: fnd_message.set_token('COLUMN', 'FUNCTION_NAME');
502: fnd_message.set_token('VALUE', x_function_name);
503: app_exception.raise_exception;
504: return;
505: end;
506: else fun_id := null;
515: where menu_name = X_MENU_NAME
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;
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;
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;
525: end;
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;
525: end;
526: