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_GRANTS_PKG dependencies on FND_MESSAGE

Line 295: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

291: open c;
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:

Line 405: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

401: OR ((recinfo.DESCRIPTION is null) AND (X_DESCRIPTION is null)))
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;

Line 511: fnd_message.set_name('FND','GENERIC-INTERNAL ERROR');

507: if((x_name = '*NOTPASSED*') or (x_description = '*NOTPASSED*')) then
508:
509: if ((x_name is NULL) or (x_description is NULL)) then
510: /* Mixing NULL with *NOTPASSED* not allowed. */
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;

Line 512: fnd_message.set_token('REASON',

508:
509: if ((x_name is NULL) or (x_description is NULL)) then
510: /* Mixing NULL with *NOTPASSED* not allowed. */
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;

Line 743: FND_MESSAGE.SET_NAME('FND', 'SQL_NO_DATA_FOUND');

739: obj_id := NULL;
740: end;
741: end if;
742: if (obj_id is NULL) then
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;

Line 744: FND_MESSAGE.SET_TOKEN('VALUE', X_OBJ_NAME);

740: end;
741: end if;
742: if (obj_id is NULL) then
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;

Line 745: FND_MESSAGE.SET_TOKEN('COLUMN', 'OBJ_NAME');

741: end if;
742: if (obj_id is NULL) then
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

Line 746: FND_MESSAGE.SET_TOKEN('TABLE', 'FND_OBJECTS');

742: if (obj_id is NULL) then
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;

Line 764: FND_MESSAGE.SET_NAME('FND', 'SQL_NO_DATA_FOUND');

760: when no_data_found then
761: mnu_id := NULL;
762: end;
763: if (mnu_id is NULL) then
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;

Line 765: FND_MESSAGE.SET_TOKEN('VALUE', X_MENU_NAME);

761: mnu_id := NULL;
762: end;
763: if (mnu_id is NULL) then
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;

Line 766: FND_MESSAGE.SET_TOKEN('COLUMN', 'MENU_NAME');

762: end;
763: if (mnu_id is NULL) then
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

Line 767: FND_MESSAGE.SET_TOKEN('TABLE', 'FND_MENUS');

763: if (mnu_id is NULL) then
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;

Line 786: FND_MESSAGE.SET_NAME('FND', 'SQL_NO_DATA_FOUND');

782: when no_data_found then
783: ins_set_id := NULL;
784: end;
785: if (ins_set_id is NULL) then
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;

Line 787: FND_MESSAGE.SET_TOKEN('VALUE', X_INSTANCE_SET_NAME);

783: ins_set_id := NULL;
784: end;
785: if (ins_set_id is NULL) then
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;

Line 788: FND_MESSAGE.SET_TOKEN('COLUMN', 'INSTANCE_SET_NAME');

784: end;
785: if (ins_set_id is NULL) then
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

Line 789: FND_MESSAGE.SET_TOKEN('TABLE', 'FND_OBJECT_INSTANCE_SETS');

785: if (ins_set_id is NULL) then
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;

Line 808: FND_MESSAGE.SET_NAME('FND', 'SQL_NO_DATA_FOUND');

804: when no_data_found then
805: secgrp_id := -1;
806: end;
807: if (secgrp_id = -1) then
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;

Line 809: FND_MESSAGE.SET_TOKEN('VALUE', X_CTX_SECURITY_GROUP_KEY);

805: secgrp_id := -1;
806: end;
807: if (secgrp_id = -1) then
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;

Line 810: FND_MESSAGE.SET_TOKEN('COLUMN', 'SECURITY_GROUP_KEY');

806: end;
807: if (secgrp_id = -1) then
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

Line 811: FND_MESSAGE.SET_TOKEN('TABLE', 'FND_SECURITY_GROUPS');

807: if (secgrp_id = -1) then
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;

Line 829: FND_MESSAGE.SET_NAME('FND', 'SQL_NO_DATA_FOUND');

825: when no_data_found then
826: resp_appl_id := -1;
827: end;
828: if (resp_appl_id = -1) then
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;

Line 830: FND_MESSAGE.SET_TOKEN('VALUE', X_CTX_RESP_APP_SHORT_NAME);

826: resp_appl_id := -1;
827: end;
828: if (resp_appl_id = -1) then
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;

Line 831: FND_MESSAGE.SET_TOKEN('COLUMN', 'APPLICATION_SHORT_NAME');

827: end;
828: if (resp_appl_id = -1) then
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

Line 832: FND_MESSAGE.SET_TOKEN('TABLE', 'FND_APPLICATION');

828: if (resp_appl_id = -1) then
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;

Line 851: FND_MESSAGE.SET_NAME('FND', 'SQL_NO_DATA_FOUND');

847: when no_data_found then
848: resp_id := -1;
849: end;
850: if (resp_id = -1) then
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;

Line 852: FND_MESSAGE.SET_TOKEN('VALUE', X_CTX_RESP_KEY);

848: resp_id := -1;
849: end;
850: if (resp_id = -1) then
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;

Line 853: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESPONSIBILITY_KEY');

849: end;
850: if (resp_id = -1) then
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

Line 854: FND_MESSAGE.SET_TOKEN('TABLE', 'FND_RESPONSIBILITY');

850: if (resp_id = -1) then
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;

Line 1020: fnd_message.set_name('FND','GENERIC-INTERNAL ERROR');

1016: X_DESCRIPTION =>l_description
1017: );
1018: else
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:

Line 1021: fnd_message.set_token('REASON',

1017: );
1018: else
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;

Line 1107: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');

1103: THEN
1104: if (fnd_log.LEVEL_EXCEPTION >=
1105: fnd_log.g_current_runtime_level) then
1106:
1107: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
1108: fnd_message.set_token('ROUTINE',
1109: G_PKG_NAME||'.'||l_api_name);
1110: fnd_message.set_token('REASON',
1111: 'Unsupported version '|| to_char(p_api_version)||

Line 1108: fnd_message.set_token('ROUTINE',

1104: if (fnd_log.LEVEL_EXCEPTION >=
1105: fnd_log.g_current_runtime_level) then
1106:
1107: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
1108: fnd_message.set_token('ROUTINE',
1109: G_PKG_NAME||'.'||l_api_name);
1110: fnd_message.set_token('REASON',
1111: 'Unsupported version '|| to_char(p_api_version)||
1112: ' passed to API; expecting version '||

Line 1110: fnd_message.set_token('REASON',

1106:
1107: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
1108: fnd_message.set_token('ROUTINE',
1109: G_PKG_NAME||'.'||l_api_name);
1110: fnd_message.set_token('REASON',
1111: 'Unsupported version '|| to_char(p_api_version)||
1112: ' passed to API; expecting version '||
1113: to_char(l_api_version));
1114: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

Line 1134: fnd_message.set_name('FND','FND_INVALID_MENU_NAME');

1130: OPEN get_menu_id(p_menu_name);
1131: FETCH get_menu_id INTO l_menu_id;
1132: IF (get_menu_id%NOTFOUND) THEN
1133: CLOSE get_menu_id;
1134: fnd_message.set_name('FND','FND_INVALID_MENU_NAME');
1135: fnd_msg_pub.ADD; /* Add for backward compatibility because in */
1136: /* the past this API put messages on fnd_msg_pub */
1137: /* stack. That's obsolete. FND_MESSAGE is now */
1138: /* used. */

Line 1137: /* stack. That's obsolete. FND_MESSAGE is now */

1133: CLOSE get_menu_id;
1134: fnd_message.set_name('FND','FND_INVALID_MENU_NAME');
1135: fnd_msg_pub.ADD; /* Add for backward compatibility because in */
1136: /* the past this API put messages on fnd_msg_pub */
1137: /* stack. That's obsolete. FND_MESSAGE is now */
1138: /* used. */
1139: fnd_message.set_name('FND','FND_INVALID_MENU_NAME');
1140: x_success := FND_API.G_FALSE ;
1141: x_errorcode:=1;

Line 1139: fnd_message.set_name('FND','FND_INVALID_MENU_NAME');

1135: fnd_msg_pub.ADD; /* Add for backward compatibility because in */
1136: /* the past this API put messages on fnd_msg_pub */
1137: /* stack. That's obsolete. FND_MESSAGE is now */
1138: /* used. */
1139: fnd_message.set_name('FND','FND_INVALID_MENU_NAME');
1140: x_success := FND_API.G_FALSE ;
1141: x_errorcode:=1;
1142: return;
1143: END IF;

Line 1155: fnd_message.set_name('FND','FND_INVALID_OBJECT_NAME');

1151: open get_object_id(p_object_name);
1152: fetch get_object_id into l_object_id;
1153: if (get_object_id%NOTFOUND) then
1154: close get_object_id;
1155: fnd_message.set_name('FND','FND_INVALID_OBJECT_NAME');
1156: fnd_msg_pub.ADD; /* Add for backward compatibility because in */
1157: /* the past this API put messages on fnd_msg_pub */
1158: /* stack. That's obsolete. FND_MESSAGE is now */
1159: /* used. */

Line 1158: /* stack. That's obsolete. FND_MESSAGE is now */

1154: close get_object_id;
1155: fnd_message.set_name('FND','FND_INVALID_OBJECT_NAME');
1156: fnd_msg_pub.ADD; /* Add for backward compatibility because in */
1157: /* the past this API put messages on fnd_msg_pub */
1158: /* stack. That's obsolete. FND_MESSAGE is now */
1159: /* used. */
1160: fnd_message.set_name('FND','FND_INVALID_OBJECT_NAME');
1161: x_success := FND_API.G_FALSE ;
1162: x_errorcode:=1;

Line 1160: fnd_message.set_name('FND','FND_INVALID_OBJECT_NAME');

1156: fnd_msg_pub.ADD; /* Add for backward compatibility because in */
1157: /* the past this API put messages on fnd_msg_pub */
1158: /* stack. That's obsolete. FND_MESSAGE is now */
1159: /* used. */
1160: fnd_message.set_name('FND','FND_INVALID_OBJECT_NAME');
1161: x_success := FND_API.G_FALSE ;
1162: x_errorcode:=1;
1163: return;
1164: end if ;

Line 1255: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');

1251: G_PKG_NAME)
1252: THEN
1253: if (fnd_log.LEVEL_EXCEPTION >=
1254: fnd_log.g_current_runtime_level) then
1255: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
1256: fnd_message.set_token('ROUTINE',
1257: G_PKG_NAME||'.'||l_api_name);
1258: fnd_message.set_token('REASON',
1259: 'Unsupported version '|| to_char(p_api_version)||

Line 1256: fnd_message.set_token('ROUTINE',

1252: THEN
1253: if (fnd_log.LEVEL_EXCEPTION >=
1254: fnd_log.g_current_runtime_level) then
1255: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
1256: fnd_message.set_token('ROUTINE',
1257: G_PKG_NAME||'.'||l_api_name);
1258: fnd_message.set_token('REASON',
1259: 'Unsupported version '|| to_char(p_api_version)||
1260: ' passed to API; expecting version '||

Line 1258: fnd_message.set_token('REASON',

1254: fnd_log.g_current_runtime_level) then
1255: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
1256: fnd_message.set_token('ROUTINE',
1257: G_PKG_NAME||'.'||l_api_name);
1258: fnd_message.set_token('REASON',
1259: 'Unsupported version '|| to_char(p_api_version)||
1260: ' passed to API; expecting version '||
1261: to_char(l_api_version));
1262: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

Line 1335: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');

1331: G_PKG_NAME)
1332: THEN
1333: if (fnd_log.LEVEL_EXCEPTION >=
1334: fnd_log.g_current_runtime_level) then
1335: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
1336: fnd_message.set_token('ROUTINE',
1337: G_PKG_NAME||'.'||l_api_name);
1338: fnd_message.set_token('REASON',
1339: 'Unsupported version '|| to_char(p_api_version)||

Line 1336: fnd_message.set_token('ROUTINE',

1332: THEN
1333: if (fnd_log.LEVEL_EXCEPTION >=
1334: fnd_log.g_current_runtime_level) then
1335: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
1336: fnd_message.set_token('ROUTINE',
1337: G_PKG_NAME||'.'||l_api_name);
1338: fnd_message.set_token('REASON',
1339: 'Unsupported version '|| to_char(p_api_version)||
1340: ' passed to API; expecting version '||

Line 1338: fnd_message.set_token('REASON',

1334: fnd_log.g_current_runtime_level) then
1335: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
1336: fnd_message.set_token('ROUTINE',
1337: G_PKG_NAME||'.'||l_api_name);
1338: fnd_message.set_token('REASON',
1339: 'Unsupported version '|| to_char(p_api_version)||
1340: ' passed to API; expecting version '||
1341: to_char(l_api_version));
1342: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

Line 1354: fnd_message.set_name('FND','GENERIC-INTERNAL ERROR');

1350: if((p_name = '*NOTPASSED*') or (p_description = '*NOTPASSED*')) then
1351:
1352: if ((p_name is NULL) or (p_description is NULL)) then
1353: /* Mixing NULL with *NOTPASSED* not allowed. */
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;

Line 1355: fnd_message.set_token('REASON',

1351:
1352: if ((p_name is NULL) or (p_description is NULL)) then
1353: /* Mixing NULL with *NOTPASSED* not allowed. */
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;

Line 1546: fnd_message.set_name('FND','FND_ROUTINE_INVALID_ARGS');

1542: BEGIN
1543:
1544: IF(p_grantee_type is NULL AND p_object_name is NULL AND p_menu_name IS NULL
1545: AND p_program_name is NULL) THEN
1546: fnd_message.set_name('FND','FND_ROUTINE_INVALID_ARGS');
1547: fnd_message.set_token('ROUTINE',
1548: 'FND_GRANTS_DELETE_PKG.delete_grant()');
1549: fnd_msg_pub.ADD; /* Add for backward compatibility because in */
1550: /* the past this API put messages on fnd_msg_pub */

Line 1547: fnd_message.set_token('ROUTINE',

1543:
1544: IF(p_grantee_type is NULL AND p_object_name is NULL AND p_menu_name IS NULL
1545: AND p_program_name is NULL) THEN
1546: fnd_message.set_name('FND','FND_ROUTINE_INVALID_ARGS');
1547: fnd_message.set_token('ROUTINE',
1548: 'FND_GRANTS_DELETE_PKG.delete_grant()');
1549: fnd_msg_pub.ADD; /* Add for backward compatibility because in */
1550: /* the past this API put messages on fnd_msg_pub */
1551: /* stack. That's obsolete. FND_MESSAGE is now */

Line 1551: /* stack. That's obsolete. FND_MESSAGE is now */

1547: fnd_message.set_token('ROUTINE',
1548: 'FND_GRANTS_DELETE_PKG.delete_grant()');
1549: fnd_msg_pub.ADD; /* Add for backward compatibility because in */
1550: /* the past this API put messages on fnd_msg_pub */
1551: /* stack. That's obsolete. FND_MESSAGE is now */
1552: /* used. */
1553: fnd_message.set_name('FND','FND_ROUTINE_INVALID_ARGS');
1554: fnd_message.set_token('ROUTINE',
1555: 'FND_GRANTS_DELETE_PKG.delete_grant()');

Line 1553: fnd_message.set_name('FND','FND_ROUTINE_INVALID_ARGS');

1549: fnd_msg_pub.ADD; /* Add for backward compatibility because in */
1550: /* the past this API put messages on fnd_msg_pub */
1551: /* stack. That's obsolete. FND_MESSAGE is now */
1552: /* used. */
1553: fnd_message.set_name('FND','FND_ROUTINE_INVALID_ARGS');
1554: fnd_message.set_token('ROUTINE',
1555: 'FND_GRANTS_DELETE_PKG.delete_grant()');
1556: x_success := 'F';
1557: x_errcode := -1;

Line 1554: fnd_message.set_token('ROUTINE',

1550: /* the past this API put messages on fnd_msg_pub */
1551: /* stack. That's obsolete. FND_MESSAGE is now */
1552: /* used. */
1553: fnd_message.set_name('FND','FND_ROUTINE_INVALID_ARGS');
1554: fnd_message.set_token('ROUTINE',
1555: 'FND_GRANTS_DELETE_PKG.delete_grant()');
1556: x_success := 'F';
1557: x_errcode := -1;
1558: return;

Line 1579: fnd_message.set_name('FND','FND_INVALID_OBJECT_NAME');

1575: OPEN get_object_id(p_object_name);
1576: FETCH get_object_id INTO l_object_id;
1577: IF(get_object_id%NOTFOUND) THEN
1578: CLOSE get_object_id;
1579: fnd_message.set_name('FND','FND_INVALID_OBJECT_NAME');
1580: fnd_msg_pub.ADD; /* Add for backward compatibility because in */
1581: /* the past this API put messages on fnd_msg_pub */
1582: /* stack. That's obsolete. FND_MESSAGE is now */
1583: /* used. */

Line 1582: /* stack. That's obsolete. FND_MESSAGE is now */

1578: CLOSE get_object_id;
1579: fnd_message.set_name('FND','FND_INVALID_OBJECT_NAME');
1580: fnd_msg_pub.ADD; /* Add for backward compatibility because in */
1581: /* the past this API put messages on fnd_msg_pub */
1582: /* stack. That's obsolete. FND_MESSAGE is now */
1583: /* used. */
1584: fnd_message.set_name('FND','FND_INVALID_OBJECT_NAME');
1585: x_success := 'F';
1586: x_errcode := 1;

Line 1584: fnd_message.set_name('FND','FND_INVALID_OBJECT_NAME');

1580: fnd_msg_pub.ADD; /* Add for backward compatibility because in */
1581: /* the past this API put messages on fnd_msg_pub */
1582: /* stack. That's obsolete. FND_MESSAGE is now */
1583: /* used. */
1584: fnd_message.set_name('FND','FND_INVALID_OBJECT_NAME');
1585: x_success := 'F';
1586: x_errcode := 1;
1587: return;
1588: END IF;

Line 1630: fnd_message.set_name('FND','FND_INVALID_MENU_NAME');

1626: OPEN get_menu_id(p_menu_name);
1627: FETCH get_menu_id INTO l_menu_id;
1628: IF(get_menu_id%NOTFOUND) THEN
1629: CLOSE get_menu_id;
1630: fnd_message.set_name('FND','FND_INVALID_MENU_NAME');
1631: fnd_msg_pub.ADD; /* Add for backward compatibility because in */
1632: /* the past this API put messages on fnd_msg_pub */
1633: /* stack. That's obsolete. FND_MESSAGE is now */
1634: /* used. */

Line 1633: /* stack. That's obsolete. FND_MESSAGE is now */

1629: CLOSE get_menu_id;
1630: fnd_message.set_name('FND','FND_INVALID_MENU_NAME');
1631: fnd_msg_pub.ADD; /* Add for backward compatibility because in */
1632: /* the past this API put messages on fnd_msg_pub */
1633: /* stack. That's obsolete. FND_MESSAGE is now */
1634: /* used. */
1635: fnd_message.set_name('FND','FND_INVALID_MENU_NAME');
1636: x_success := 'F';
1637: x_errcode := 1;

Line 1635: fnd_message.set_name('FND','FND_INVALID_MENU_NAME');

1631: fnd_msg_pub.ADD; /* Add for backward compatibility because in */
1632: /* the past this API put messages on fnd_msg_pub */
1633: /* stack. That's obsolete. FND_MESSAGE is now */
1634: /* used. */
1635: fnd_message.set_name('FND','FND_INVALID_MENU_NAME');
1636: x_success := 'F';
1637: x_errcode := 1;
1638: return;
1639: END IF;