DBA Data[Home] [Help]

APPS.FND_GRANTS_PKG dependencies on APP_EXCEPTION

Line 296: app_exception.raise_exception;

292: fetch c into recinfo;
293: if (c%notfound) then
294: close c;
295: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
296: app_exception.raise_exception;
297: end if;
298: close c;
299:
300: /* only allowed grantee_key is 'GLOBAL' for grantee_type 'GLOBAL'*/

Line 406: app_exception.raise_exception;

402: ) then
403: null;
404: else
405: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
406: app_exception.raise_exception;
407: end if;
408:
409: return;
410: end LOCK_ROW;

Line 515: app_exception.raise_exception;

511: fnd_message.set_name('FND','GENERIC-INTERNAL ERROR');
512: fnd_message.set_token('REASON',
513: 'UPDATE_ROW caller mixed NULL with *NOTPASSED* on grant guid:'
514: ||X_GRANT_GUID);
515: app_exception.raise_exception;
516: end if;
517:
518: /* First version of update does not include name, description */
519: update FND_GRANTS set

Line 747: app_exception.raise_exception;

743: FND_MESSAGE.SET_NAME('FND', 'SQL_NO_DATA_FOUND');
744: FND_MESSAGE.SET_TOKEN('VALUE', X_OBJ_NAME);
745: FND_MESSAGE.SET_TOKEN('COLUMN', 'OBJ_NAME');
746: FND_MESSAGE.SET_TOKEN('TABLE', 'FND_OBJECTS');
747: app_exception.raise_exception;
748: end if;
749: else
750: obj_id := NULL;
751: end if;

Line 768: app_exception.raise_exception;

764: FND_MESSAGE.SET_NAME('FND', 'SQL_NO_DATA_FOUND');
765: FND_MESSAGE.SET_TOKEN('VALUE', X_MENU_NAME);
766: FND_MESSAGE.SET_TOKEN('COLUMN', 'MENU_NAME');
767: FND_MESSAGE.SET_TOKEN('TABLE', 'FND_MENUS');
768: app_exception.raise_exception;
769: end if;
770: else
771: mnu_id := NULL;
772: end if;

Line 790: app_exception.raise_exception;

786: FND_MESSAGE.SET_NAME('FND', 'SQL_NO_DATA_FOUND');
787: FND_MESSAGE.SET_TOKEN('VALUE', X_INSTANCE_SET_NAME);
788: FND_MESSAGE.SET_TOKEN('COLUMN', 'INSTANCE_SET_NAME');
789: FND_MESSAGE.SET_TOKEN('TABLE', 'FND_OBJECT_INSTANCE_SETS');
790: app_exception.raise_exception;
791: end if;
792: else
793: ins_set_id := NULL;
794: end if;

Line 812: app_exception.raise_exception;

808: FND_MESSAGE.SET_NAME('FND', 'SQL_NO_DATA_FOUND');
809: FND_MESSAGE.SET_TOKEN('VALUE', X_CTX_SECURITY_GROUP_KEY);
810: FND_MESSAGE.SET_TOKEN('COLUMN', 'SECURITY_GROUP_KEY');
811: FND_MESSAGE.SET_TOKEN('TABLE', 'FND_SECURITY_GROUPS');
812: app_exception.raise_exception;
813: end if;
814: else
815: secgrp_id := -1;
816: end if;

Line 833: app_exception.raise_exception;

829: FND_MESSAGE.SET_NAME('FND', 'SQL_NO_DATA_FOUND');
830: FND_MESSAGE.SET_TOKEN('VALUE', X_CTX_RESP_APP_SHORT_NAME);
831: FND_MESSAGE.SET_TOKEN('COLUMN', 'APPLICATION_SHORT_NAME');
832: FND_MESSAGE.SET_TOKEN('TABLE', 'FND_APPLICATION');
833: app_exception.raise_exception;
834: end if;
835: else
836: resp_appl_id := -1;
837: end if;

Line 855: app_exception.raise_exception;

851: FND_MESSAGE.SET_NAME('FND', 'SQL_NO_DATA_FOUND');
852: FND_MESSAGE.SET_TOKEN('VALUE', X_CTX_RESP_KEY);
853: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESPONSIBILITY_KEY');
854: FND_MESSAGE.SET_TOKEN('TABLE', 'FND_RESPONSIBILITY');
855: app_exception.raise_exception;
856: end if;
857: else
858: resp_id := -1;
859: end if;

Line 1023: app_exception.raise_exception;

1019: -- Data corruption. Bad menu or bad instance set or bad object.
1020: fnd_message.set_name('FND','GENERIC-INTERNAL ERROR');
1021: fnd_message.set_token('REASON',
1022: 'Error- data corruption for GRANT:'||X_GRANT_GUID);
1023: app_exception.raise_exception;
1024:
1025: end if;
1026: end LOAD_ROW;
1027:

Line 1358: app_exception.raise_exception;

1354: fnd_message.set_name('FND','GENERIC-INTERNAL ERROR');
1355: fnd_message.set_token('REASON',
1356: 'UPDATE_GRANT caller mixed NULL with *NOTPASSED* on grant guid:'
1357: ||P_GRANT_GUID);
1358: app_exception.raise_exception;
1359: end if;
1360: /* Don't update name and description */
1361: UPDATE fnd_grants
1362: SET start_date=p_start_date,