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

Line 1115: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

1111: from fnd_application
1112: where application_short_name = upper(x_application_short_name);
1113: exception
1114: when no_data_found then
1115: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1116: fnd_message.set_token('TABLE', 'FND_APPLICATION');
1117: fnd_message.set_token('COLUMN', 'APPLICATION_SHORT_NAME');
1118: fnd_message.set_token('VALUE', x_application_short_name);
1119: app_exception.raise_exception;

Line 1116: fnd_message.set_token('TABLE', 'FND_APPLICATION');

1112: where application_short_name = upper(x_application_short_name);
1113: exception
1114: when no_data_found then
1115: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1116: fnd_message.set_token('TABLE', 'FND_APPLICATION');
1117: fnd_message.set_token('COLUMN', 'APPLICATION_SHORT_NAME');
1118: fnd_message.set_token('VALUE', x_application_short_name);
1119: app_exception.raise_exception;
1120: return;

Line 1117: fnd_message.set_token('COLUMN', 'APPLICATION_SHORT_NAME');

1113: exception
1114: when no_data_found then
1115: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1116: fnd_message.set_token('TABLE', 'FND_APPLICATION');
1117: fnd_message.set_token('COLUMN', 'APPLICATION_SHORT_NAME');
1118: fnd_message.set_token('VALUE', x_application_short_name);
1119: app_exception.raise_exception;
1120: return;
1121: end;

Line 1118: fnd_message.set_token('VALUE', x_application_short_name);

1114: when no_data_found then
1115: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1116: fnd_message.set_token('TABLE', 'FND_APPLICATION');
1117: fnd_message.set_token('COLUMN', 'APPLICATION_SHORT_NAME');
1118: fnd_message.set_token('VALUE', x_application_short_name);
1119: app_exception.raise_exception;
1120: return;
1121: end;
1122:

Line 1131: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

1127: where application_id = appl_id
1128: and table_name = upper(x_table_name);
1129: exception
1130: when no_data_found then
1131: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1132: fnd_message.set_token('TABLE', 'FND_TABLES');
1133: fnd_message.set_token('COLUMN', 'TABLE_NAME');
1134: fnd_message.set_token('VALUE', x_table_name);
1135: app_exception.raise_exception;

Line 1132: fnd_message.set_token('TABLE', 'FND_TABLES');

1128: and table_name = upper(x_table_name);
1129: exception
1130: when no_data_found then
1131: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1132: fnd_message.set_token('TABLE', 'FND_TABLES');
1133: fnd_message.set_token('COLUMN', 'TABLE_NAME');
1134: fnd_message.set_token('VALUE', x_table_name);
1135: app_exception.raise_exception;
1136: return;

Line 1133: fnd_message.set_token('COLUMN', 'TABLE_NAME');

1129: exception
1130: when no_data_found then
1131: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1132: fnd_message.set_token('TABLE', 'FND_TABLES');
1133: fnd_message.set_token('COLUMN', 'TABLE_NAME');
1134: fnd_message.set_token('VALUE', x_table_name);
1135: app_exception.raise_exception;
1136: return;
1137: end;

Line 1134: fnd_message.set_token('VALUE', x_table_name);

1130: when no_data_found then
1131: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1132: fnd_message.set_token('TABLE', 'FND_TABLES');
1133: fnd_message.set_token('COLUMN', 'TABLE_NAME');
1134: fnd_message.set_token('VALUE', x_table_name);
1135: app_exception.raise_exception;
1136: return;
1137: end;
1138:

Line 1148: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

1144: and table_id = tab_id
1145: and column_name = upper(x_column_name);
1146: exception
1147: when no_data_found then
1148: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1149: fnd_message.set_token('TABLE', 'FND_COLUMNS');
1150: fnd_message.set_token('COLUMN', 'COLUMN_NAME');
1151: fnd_message.set_token('VALUE', x_column_name);
1152: app_exception.raise_exception;

Line 1149: fnd_message.set_token('TABLE', 'FND_COLUMNS');

1145: and column_name = upper(x_column_name);
1146: exception
1147: when no_data_found then
1148: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1149: fnd_message.set_token('TABLE', 'FND_COLUMNS');
1150: fnd_message.set_token('COLUMN', 'COLUMN_NAME');
1151: fnd_message.set_token('VALUE', x_column_name);
1152: app_exception.raise_exception;
1153: return;

Line 1150: fnd_message.set_token('COLUMN', 'COLUMN_NAME');

1146: exception
1147: when no_data_found then
1148: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1149: fnd_message.set_token('TABLE', 'FND_COLUMNS');
1150: fnd_message.set_token('COLUMN', 'COLUMN_NAME');
1151: fnd_message.set_token('VALUE', x_column_name);
1152: app_exception.raise_exception;
1153: return;
1154: end;

Line 1151: fnd_message.set_token('VALUE', x_column_name);

1147: when no_data_found then
1148: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1149: fnd_message.set_token('TABLE', 'FND_COLUMNS');
1150: fnd_message.set_token('COLUMN', 'COLUMN_NAME');
1151: fnd_message.set_token('VALUE', x_column_name);
1152: app_exception.raise_exception;
1153: return;
1154: end;
1155:

Line 1167: fnd_message.set_name('FND', 'FND-CHILD EXISTS');

1163: where application_id = appl_id
1164: and table_id = tab_id
1165: and column_id = col_id;
1166: if (cnt > 0) then
1167: fnd_message.set_name('FND', 'FND-CHILD EXISTS');
1168: fnd_message.set_token('APPLICATION', x_application_short_name);
1169: fnd_message.set_token('TABLE', x_table_name);
1170: fnd_message.set_token('COLUMN', x_column_name);
1171: fnd_message.set_token('CHILD', 'INDEX COLUMN');

Line 1168: fnd_message.set_token('APPLICATION', x_application_short_name);

1164: and table_id = tab_id
1165: and column_id = col_id;
1166: if (cnt > 0) then
1167: fnd_message.set_name('FND', 'FND-CHILD EXISTS');
1168: fnd_message.set_token('APPLICATION', x_application_short_name);
1169: fnd_message.set_token('TABLE', x_table_name);
1170: fnd_message.set_token('COLUMN', x_column_name);
1171: fnd_message.set_token('CHILD', 'INDEX COLUMN');
1172: app_exception.raise_exception;

Line 1169: fnd_message.set_token('TABLE', x_table_name);

1165: and column_id = col_id;
1166: if (cnt > 0) then
1167: fnd_message.set_name('FND', 'FND-CHILD EXISTS');
1168: fnd_message.set_token('APPLICATION', x_application_short_name);
1169: fnd_message.set_token('TABLE', x_table_name);
1170: fnd_message.set_token('COLUMN', x_column_name);
1171: fnd_message.set_token('CHILD', 'INDEX COLUMN');
1172: app_exception.raise_exception;
1173: return;

Line 1170: fnd_message.set_token('COLUMN', x_column_name);

1166: if (cnt > 0) then
1167: fnd_message.set_name('FND', 'FND-CHILD EXISTS');
1168: fnd_message.set_token('APPLICATION', x_application_short_name);
1169: fnd_message.set_token('TABLE', x_table_name);
1170: fnd_message.set_token('COLUMN', x_column_name);
1171: fnd_message.set_token('CHILD', 'INDEX COLUMN');
1172: app_exception.raise_exception;
1173: return;
1174: end if;

Line 1171: fnd_message.set_token('CHILD', 'INDEX COLUMN');

1167: fnd_message.set_name('FND', 'FND-CHILD EXISTS');
1168: fnd_message.set_token('APPLICATION', x_application_short_name);
1169: fnd_message.set_token('TABLE', x_table_name);
1170: fnd_message.set_token('COLUMN', x_column_name);
1171: fnd_message.set_token('CHILD', 'INDEX COLUMN');
1172: app_exception.raise_exception;
1173: return;
1174: end if;
1175:

Line 1184: fnd_message.set_name('FND', 'FND-CHILD EXISTS');

1180: where application_id = appl_id
1181: and table_id = tab_id
1182: and column_id = col_id;
1183: if (cnt > 0) then
1184: fnd_message.set_name('FND', 'FND-CHILD EXISTS');
1185: fnd_message.set_token('APPLICATION', x_application_short_name);
1186: fnd_message.set_token('TABLE', x_table_name);
1187: fnd_message.set_token('COLUMN', x_column_name);
1188: fnd_message.set_token('CHILD', 'PRIMARY KEY COLUMN');

Line 1185: fnd_message.set_token('APPLICATION', x_application_short_name);

1181: and table_id = tab_id
1182: and column_id = col_id;
1183: if (cnt > 0) then
1184: fnd_message.set_name('FND', 'FND-CHILD EXISTS');
1185: fnd_message.set_token('APPLICATION', x_application_short_name);
1186: fnd_message.set_token('TABLE', x_table_name);
1187: fnd_message.set_token('COLUMN', x_column_name);
1188: fnd_message.set_token('CHILD', 'PRIMARY KEY COLUMN');
1189: app_exception.raise_exception;

Line 1186: fnd_message.set_token('TABLE', x_table_name);

1182: and column_id = col_id;
1183: if (cnt > 0) then
1184: fnd_message.set_name('FND', 'FND-CHILD EXISTS');
1185: fnd_message.set_token('APPLICATION', x_application_short_name);
1186: fnd_message.set_token('TABLE', x_table_name);
1187: fnd_message.set_token('COLUMN', x_column_name);
1188: fnd_message.set_token('CHILD', 'PRIMARY KEY COLUMN');
1189: app_exception.raise_exception;
1190: return;

Line 1187: fnd_message.set_token('COLUMN', x_column_name);

1183: if (cnt > 0) then
1184: fnd_message.set_name('FND', 'FND-CHILD EXISTS');
1185: fnd_message.set_token('APPLICATION', x_application_short_name);
1186: fnd_message.set_token('TABLE', x_table_name);
1187: fnd_message.set_token('COLUMN', x_column_name);
1188: fnd_message.set_token('CHILD', 'PRIMARY KEY COLUMN');
1189: app_exception.raise_exception;
1190: return;
1191: end if;

Line 1188: fnd_message.set_token('CHILD', 'PRIMARY KEY COLUMN');

1184: fnd_message.set_name('FND', 'FND-CHILD EXISTS');
1185: fnd_message.set_token('APPLICATION', x_application_short_name);
1186: fnd_message.set_token('TABLE', x_table_name);
1187: fnd_message.set_token('COLUMN', x_column_name);
1188: fnd_message.set_token('CHILD', 'PRIMARY KEY COLUMN');
1189: app_exception.raise_exception;
1190: return;
1191: end if;
1192:

Line 1201: fnd_message.set_name('FND', 'FND-CHILD EXISTS');

1197: where application_id = appl_id
1198: and table_id = tab_id
1199: and column_id = col_id;
1200: if (cnt > 0) then
1201: fnd_message.set_name('FND', 'FND-CHILD EXISTS');
1202: fnd_message.set_token('APPLICATION', x_application_short_name);
1203: fnd_message.set_token('TABLE', x_table_name);
1204: fnd_message.set_token('COLUMN', x_column_name);
1205: fnd_message.set_token('CHILD', 'FOREIGN KEY COLUMN');

Line 1202: fnd_message.set_token('APPLICATION', x_application_short_name);

1198: and table_id = tab_id
1199: and column_id = col_id;
1200: if (cnt > 0) then
1201: fnd_message.set_name('FND', 'FND-CHILD EXISTS');
1202: fnd_message.set_token('APPLICATION', x_application_short_name);
1203: fnd_message.set_token('TABLE', x_table_name);
1204: fnd_message.set_token('COLUMN', x_column_name);
1205: fnd_message.set_token('CHILD', 'FOREIGN KEY COLUMN');
1206: app_exception.raise_exception;

Line 1203: fnd_message.set_token('TABLE', x_table_name);

1199: and column_id = col_id;
1200: if (cnt > 0) then
1201: fnd_message.set_name('FND', 'FND-CHILD EXISTS');
1202: fnd_message.set_token('APPLICATION', x_application_short_name);
1203: fnd_message.set_token('TABLE', x_table_name);
1204: fnd_message.set_token('COLUMN', x_column_name);
1205: fnd_message.set_token('CHILD', 'FOREIGN KEY COLUMN');
1206: app_exception.raise_exception;
1207: return;

Line 1204: fnd_message.set_token('COLUMN', x_column_name);

1200: if (cnt > 0) then
1201: fnd_message.set_name('FND', 'FND-CHILD EXISTS');
1202: fnd_message.set_token('APPLICATION', x_application_short_name);
1203: fnd_message.set_token('TABLE', x_table_name);
1204: fnd_message.set_token('COLUMN', x_column_name);
1205: fnd_message.set_token('CHILD', 'FOREIGN KEY COLUMN');
1206: app_exception.raise_exception;
1207: return;
1208: end if;

Line 1205: fnd_message.set_token('CHILD', 'FOREIGN KEY COLUMN');

1201: fnd_message.set_name('FND', 'FND-CHILD EXISTS');
1202: fnd_message.set_token('APPLICATION', x_application_short_name);
1203: fnd_message.set_token('TABLE', x_table_name);
1204: fnd_message.set_token('COLUMN', x_column_name);
1205: fnd_message.set_token('CHILD', 'FOREIGN KEY COLUMN');
1206: app_exception.raise_exception;
1207: return;
1208: end if;
1209:

Line 1236: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

1232: from fnd_application
1233: where application_short_name = upper(x_application_short_name);
1234: exception
1235: when no_data_found then
1236: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1237: fnd_message.set_token('TABLE', 'FND_APPLICATION');
1238: fnd_message.set_token('COLUMN', 'APPLICATION_SHORT_NAME');
1239: fnd_message.set_token('VALUE', x_application_short_name);
1240: app_exception.raise_exception;

Line 1237: fnd_message.set_token('TABLE', 'FND_APPLICATION');

1233: where application_short_name = upper(x_application_short_name);
1234: exception
1235: when no_data_found then
1236: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1237: fnd_message.set_token('TABLE', 'FND_APPLICATION');
1238: fnd_message.set_token('COLUMN', 'APPLICATION_SHORT_NAME');
1239: fnd_message.set_token('VALUE', x_application_short_name);
1240: app_exception.raise_exception;
1241: return;

Line 1238: fnd_message.set_token('COLUMN', 'APPLICATION_SHORT_NAME');

1234: exception
1235: when no_data_found then
1236: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1237: fnd_message.set_token('TABLE', 'FND_APPLICATION');
1238: fnd_message.set_token('COLUMN', 'APPLICATION_SHORT_NAME');
1239: fnd_message.set_token('VALUE', x_application_short_name);
1240: app_exception.raise_exception;
1241: return;
1242: end;

Line 1239: fnd_message.set_token('VALUE', x_application_short_name);

1235: when no_data_found then
1236: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1237: fnd_message.set_token('TABLE', 'FND_APPLICATION');
1238: fnd_message.set_token('COLUMN', 'APPLICATION_SHORT_NAME');
1239: fnd_message.set_token('VALUE', x_application_short_name);
1240: app_exception.raise_exception;
1241: return;
1242: end;
1243:

Line 1252: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

1248: where application_id = appl_id
1249: and table_name = upper(x_table_name);
1250: exception
1251: when no_data_found then
1252: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1253: fnd_message.set_token('TABLE', 'FND_TABLES');
1254: fnd_message.set_token('COLUMN', 'TABLE_NAME');
1255: fnd_message.set_token('VALUE', x_table_name);
1256: app_exception.raise_exception;

Line 1253: fnd_message.set_token('TABLE', 'FND_TABLES');

1249: and table_name = upper(x_table_name);
1250: exception
1251: when no_data_found then
1252: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1253: fnd_message.set_token('TABLE', 'FND_TABLES');
1254: fnd_message.set_token('COLUMN', 'TABLE_NAME');
1255: fnd_message.set_token('VALUE', x_table_name);
1256: app_exception.raise_exception;
1257: return;

Line 1254: fnd_message.set_token('COLUMN', 'TABLE_NAME');

1250: exception
1251: when no_data_found then
1252: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1253: fnd_message.set_token('TABLE', 'FND_TABLES');
1254: fnd_message.set_token('COLUMN', 'TABLE_NAME');
1255: fnd_message.set_token('VALUE', x_table_name);
1256: app_exception.raise_exception;
1257: return;
1258: end;

Line 1255: fnd_message.set_token('VALUE', x_table_name);

1251: when no_data_found then
1252: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1253: fnd_message.set_token('TABLE', 'FND_TABLES');
1254: fnd_message.set_token('COLUMN', 'TABLE_NAME');
1255: fnd_message.set_token('VALUE', x_table_name);
1256: app_exception.raise_exception;
1257: return;
1258: end;
1259:

Line 1269: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

1265: and table_id = tab_id
1266: and index_name = upper(x_index_name);
1267: exception
1268: when no_data_found then
1269: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1270: fnd_message.set_token('TABLE', 'FND_INDEXES');
1271: fnd_message.set_token('COLUMN', 'INDEX_NAME');
1272: fnd_message.set_token('VALUE', x_index_name);
1273: app_exception.raise_exception;

Line 1270: fnd_message.set_token('TABLE', 'FND_INDEXES');

1266: and index_name = upper(x_index_name);
1267: exception
1268: when no_data_found then
1269: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1270: fnd_message.set_token('TABLE', 'FND_INDEXES');
1271: fnd_message.set_token('COLUMN', 'INDEX_NAME');
1272: fnd_message.set_token('VALUE', x_index_name);
1273: app_exception.raise_exception;
1274: return;

Line 1271: fnd_message.set_token('COLUMN', 'INDEX_NAME');

1267: exception
1268: when no_data_found then
1269: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1270: fnd_message.set_token('TABLE', 'FND_INDEXES');
1271: fnd_message.set_token('COLUMN', 'INDEX_NAME');
1272: fnd_message.set_token('VALUE', x_index_name);
1273: app_exception.raise_exception;
1274: return;
1275: end;

Line 1272: fnd_message.set_token('VALUE', x_index_name);

1268: when no_data_found then
1269: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1270: fnd_message.set_token('TABLE', 'FND_INDEXES');
1271: fnd_message.set_token('COLUMN', 'INDEX_NAME');
1272: fnd_message.set_token('VALUE', x_index_name);
1273: app_exception.raise_exception;
1274: return;
1275: end;
1276:

Line 1312: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

1308: from fnd_application
1309: where application_short_name = upper(x_application_short_name);
1310: exception
1311: when no_data_found then
1312: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1313: fnd_message.set_token('TABLE', 'FND_APPLICATION');
1314: fnd_message.set_token('COLUMN', 'APPLICATION_SHORT_NAME');
1315: fnd_message.set_token('VALUE', x_application_short_name);
1316: app_exception.raise_exception;

Line 1313: fnd_message.set_token('TABLE', 'FND_APPLICATION');

1309: where application_short_name = upper(x_application_short_name);
1310: exception
1311: when no_data_found then
1312: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1313: fnd_message.set_token('TABLE', 'FND_APPLICATION');
1314: fnd_message.set_token('COLUMN', 'APPLICATION_SHORT_NAME');
1315: fnd_message.set_token('VALUE', x_application_short_name);
1316: app_exception.raise_exception;
1317: return;

Line 1314: fnd_message.set_token('COLUMN', 'APPLICATION_SHORT_NAME');

1310: exception
1311: when no_data_found then
1312: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1313: fnd_message.set_token('TABLE', 'FND_APPLICATION');
1314: fnd_message.set_token('COLUMN', 'APPLICATION_SHORT_NAME');
1315: fnd_message.set_token('VALUE', x_application_short_name);
1316: app_exception.raise_exception;
1317: return;
1318: end;

Line 1315: fnd_message.set_token('VALUE', x_application_short_name);

1311: when no_data_found then
1312: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1313: fnd_message.set_token('TABLE', 'FND_APPLICATION');
1314: fnd_message.set_token('COLUMN', 'APPLICATION_SHORT_NAME');
1315: fnd_message.set_token('VALUE', x_application_short_name);
1316: app_exception.raise_exception;
1317: return;
1318: end;
1319:

Line 1328: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

1324: where application_id = appl_id
1325: and table_name = upper(x_table_name);
1326: exception
1327: when no_data_found then
1328: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1329: fnd_message.set_token('TABLE', 'FND_TABLES');
1330: fnd_message.set_token('COLUMN', 'TABLE_NAME');
1331: fnd_message.set_token('VALUE', x_table_name);
1332: app_exception.raise_exception;

Line 1329: fnd_message.set_token('TABLE', 'FND_TABLES');

1325: and table_name = upper(x_table_name);
1326: exception
1327: when no_data_found then
1328: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1329: fnd_message.set_token('TABLE', 'FND_TABLES');
1330: fnd_message.set_token('COLUMN', 'TABLE_NAME');
1331: fnd_message.set_token('VALUE', x_table_name);
1332: app_exception.raise_exception;
1333: return;

Line 1330: fnd_message.set_token('COLUMN', 'TABLE_NAME');

1326: exception
1327: when no_data_found then
1328: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1329: fnd_message.set_token('TABLE', 'FND_TABLES');
1330: fnd_message.set_token('COLUMN', 'TABLE_NAME');
1331: fnd_message.set_token('VALUE', x_table_name);
1332: app_exception.raise_exception;
1333: return;
1334: end;

Line 1331: fnd_message.set_token('VALUE', x_table_name);

1327: when no_data_found then
1328: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1329: fnd_message.set_token('TABLE', 'FND_TABLES');
1330: fnd_message.set_token('COLUMN', 'TABLE_NAME');
1331: fnd_message.set_token('VALUE', x_table_name);
1332: app_exception.raise_exception;
1333: return;
1334: end;
1335:

Line 1345: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

1341: and table_id = tab_id
1342: and primary_key_name = upper(x_primary_key_name);
1343: exception
1344: when no_data_found then
1345: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1346: fnd_message.set_token('TABLE', 'FND_PRIMARY_KEYS');
1347: fnd_message.set_token('COLUMN', 'PRIMARY_KEY_NAME');
1348: fnd_message.set_token('VALUE', x_primary_key_name);
1349: app_exception.raise_exception;

Line 1346: fnd_message.set_token('TABLE', 'FND_PRIMARY_KEYS');

1342: and primary_key_name = upper(x_primary_key_name);
1343: exception
1344: when no_data_found then
1345: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1346: fnd_message.set_token('TABLE', 'FND_PRIMARY_KEYS');
1347: fnd_message.set_token('COLUMN', 'PRIMARY_KEY_NAME');
1348: fnd_message.set_token('VALUE', x_primary_key_name);
1349: app_exception.raise_exception;
1350: return;

Line 1347: fnd_message.set_token('COLUMN', 'PRIMARY_KEY_NAME');

1343: exception
1344: when no_data_found then
1345: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1346: fnd_message.set_token('TABLE', 'FND_PRIMARY_KEYS');
1347: fnd_message.set_token('COLUMN', 'PRIMARY_KEY_NAME');
1348: fnd_message.set_token('VALUE', x_primary_key_name);
1349: app_exception.raise_exception;
1350: return;
1351: end;

Line 1348: fnd_message.set_token('VALUE', x_primary_key_name);

1344: when no_data_found then
1345: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1346: fnd_message.set_token('TABLE', 'FND_PRIMARY_KEYS');
1347: fnd_message.set_token('COLUMN', 'PRIMARY_KEY_NAME');
1348: fnd_message.set_token('VALUE', x_primary_key_name);
1349: app_exception.raise_exception;
1350: return;
1351: end;
1352:

Line 1377: fnd_message.set_name('FND', 'FND-FOREIGN KEY EXISTS');

1373:
1374: else
1375: -- There are foreign keys pointing to this primary key.
1376: -- Removing the foreign key before removing this primary key
1377: fnd_message.set_name('FND', 'FND-FOREIGN KEY EXISTS');
1378: fnd_message.set_token('PRIMARY_KEY', x_primary_key_name);
1379: app_exception.raise_exception;
1380: return;
1381: end if;

Line 1378: fnd_message.set_token('PRIMARY_KEY', x_primary_key_name);

1374: else
1375: -- There are foreign keys pointing to this primary key.
1376: -- Removing the foreign key before removing this primary key
1377: fnd_message.set_name('FND', 'FND-FOREIGN KEY EXISTS');
1378: fnd_message.set_token('PRIMARY_KEY', x_primary_key_name);
1379: app_exception.raise_exception;
1380: return;
1381: end if;
1382:

Line 1404: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

1400: from fnd_application
1401: where application_short_name = upper(x_application_short_name);
1402: exception
1403: when no_data_found then
1404: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1405: fnd_message.set_token('TABLE', 'FND_APPLICATION');
1406: fnd_message.set_token('COLUMN', 'APPLICATION_SHORT_NAME');
1407: fnd_message.set_token('VALUE', x_application_short_name);
1408: app_exception.raise_exception;

Line 1405: fnd_message.set_token('TABLE', 'FND_APPLICATION');

1401: where application_short_name = upper(x_application_short_name);
1402: exception
1403: when no_data_found then
1404: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1405: fnd_message.set_token('TABLE', 'FND_APPLICATION');
1406: fnd_message.set_token('COLUMN', 'APPLICATION_SHORT_NAME');
1407: fnd_message.set_token('VALUE', x_application_short_name);
1408: app_exception.raise_exception;
1409: return;

Line 1406: fnd_message.set_token('COLUMN', 'APPLICATION_SHORT_NAME');

1402: exception
1403: when no_data_found then
1404: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1405: fnd_message.set_token('TABLE', 'FND_APPLICATION');
1406: fnd_message.set_token('COLUMN', 'APPLICATION_SHORT_NAME');
1407: fnd_message.set_token('VALUE', x_application_short_name);
1408: app_exception.raise_exception;
1409: return;
1410: end;

Line 1407: fnd_message.set_token('VALUE', x_application_short_name);

1403: when no_data_found then
1404: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1405: fnd_message.set_token('TABLE', 'FND_APPLICATION');
1406: fnd_message.set_token('COLUMN', 'APPLICATION_SHORT_NAME');
1407: fnd_message.set_token('VALUE', x_application_short_name);
1408: app_exception.raise_exception;
1409: return;
1410: end;
1411:

Line 1420: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

1416: where application_id = appl_id
1417: and table_name = upper(x_table_name);
1418: exception
1419: when no_data_found then
1420: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1421: fnd_message.set_token('TABLE', 'FND_TABLES');
1422: fnd_message.set_token('COLUMN', 'TABLE_NAME');
1423: fnd_message.set_token('VALUE', x_table_name);
1424: app_exception.raise_exception;

Line 1421: fnd_message.set_token('TABLE', 'FND_TABLES');

1417: and table_name = upper(x_table_name);
1418: exception
1419: when no_data_found then
1420: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1421: fnd_message.set_token('TABLE', 'FND_TABLES');
1422: fnd_message.set_token('COLUMN', 'TABLE_NAME');
1423: fnd_message.set_token('VALUE', x_table_name);
1424: app_exception.raise_exception;
1425: return;

Line 1422: fnd_message.set_token('COLUMN', 'TABLE_NAME');

1418: exception
1419: when no_data_found then
1420: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1421: fnd_message.set_token('TABLE', 'FND_TABLES');
1422: fnd_message.set_token('COLUMN', 'TABLE_NAME');
1423: fnd_message.set_token('VALUE', x_table_name);
1424: app_exception.raise_exception;
1425: return;
1426: end;

Line 1423: fnd_message.set_token('VALUE', x_table_name);

1419: when no_data_found then
1420: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1421: fnd_message.set_token('TABLE', 'FND_TABLES');
1422: fnd_message.set_token('COLUMN', 'TABLE_NAME');
1423: fnd_message.set_token('VALUE', x_table_name);
1424: app_exception.raise_exception;
1425: return;
1426: end;
1427:

Line 1437: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

1433: and table_id = tab_id
1434: and foreign_key_name = upper(x_foreign_key_name);
1435: exception
1436: when no_data_found then
1437: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1438: fnd_message.set_token('TABLE', 'FND_FOREIGN_KEYS');
1439: fnd_message.set_token('COLUMN', 'FOREIGN_KEY_NAME');
1440: fnd_message.set_token('VALUE', x_foreign_key_name);
1441: app_exception.raise_exception;

Line 1438: fnd_message.set_token('TABLE', 'FND_FOREIGN_KEYS');

1434: and foreign_key_name = upper(x_foreign_key_name);
1435: exception
1436: when no_data_found then
1437: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1438: fnd_message.set_token('TABLE', 'FND_FOREIGN_KEYS');
1439: fnd_message.set_token('COLUMN', 'FOREIGN_KEY_NAME');
1440: fnd_message.set_token('VALUE', x_foreign_key_name);
1441: app_exception.raise_exception;
1442: return;

Line 1439: fnd_message.set_token('COLUMN', 'FOREIGN_KEY_NAME');

1435: exception
1436: when no_data_found then
1437: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1438: fnd_message.set_token('TABLE', 'FND_FOREIGN_KEYS');
1439: fnd_message.set_token('COLUMN', 'FOREIGN_KEY_NAME');
1440: fnd_message.set_token('VALUE', x_foreign_key_name);
1441: app_exception.raise_exception;
1442: return;
1443: end;

Line 1440: fnd_message.set_token('VALUE', x_foreign_key_name);

1436: when no_data_found then
1437: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1438: fnd_message.set_token('TABLE', 'FND_FOREIGN_KEYS');
1439: fnd_message.set_token('COLUMN', 'FOREIGN_KEY_NAME');
1440: fnd_message.set_token('VALUE', x_foreign_key_name);
1441: app_exception.raise_exception;
1442: return;
1443: end;
1444:

Line 1474: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

1470: from fnd_application
1471: where application_short_name = upper(x_application_short_name);
1472: exception
1473: when no_data_found then
1474: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1475: fnd_message.set_token('TABLE', 'FND_APPLICATION');
1476: fnd_message.set_token('COLUMN', 'APPLICATION_SHORT_NAME');
1477: fnd_message.set_token('VALUE', x_application_short_name);
1478: app_exception.raise_exception;

Line 1475: fnd_message.set_token('TABLE', 'FND_APPLICATION');

1471: where application_short_name = upper(x_application_short_name);
1472: exception
1473: when no_data_found then
1474: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1475: fnd_message.set_token('TABLE', 'FND_APPLICATION');
1476: fnd_message.set_token('COLUMN', 'APPLICATION_SHORT_NAME');
1477: fnd_message.set_token('VALUE', x_application_short_name);
1478: app_exception.raise_exception;
1479: return;

Line 1476: fnd_message.set_token('COLUMN', 'APPLICATION_SHORT_NAME');

1472: exception
1473: when no_data_found then
1474: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1475: fnd_message.set_token('TABLE', 'FND_APPLICATION');
1476: fnd_message.set_token('COLUMN', 'APPLICATION_SHORT_NAME');
1477: fnd_message.set_token('VALUE', x_application_short_name);
1478: app_exception.raise_exception;
1479: return;
1480: end;

Line 1477: fnd_message.set_token('VALUE', x_application_short_name);

1473: when no_data_found then
1474: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1475: fnd_message.set_token('TABLE', 'FND_APPLICATION');
1476: fnd_message.set_token('COLUMN', 'APPLICATION_SHORT_NAME');
1477: fnd_message.set_token('VALUE', x_application_short_name);
1478: app_exception.raise_exception;
1479: return;
1480: end;
1481:

Line 1486: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

1482: delete from fnd_sequences
1483: where application_id = appl_id
1484: and sequence_name = upper(x_sequence_name);
1485: if (SQL%ROWCOUNT = 0) then
1486: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1487: fnd_message.set_token('TABLE', 'FND_SEQUENCES');
1488: fnd_message.set_token('COLUMN', 'SEQUENCE_NAME');
1489: fnd_message.set_token('VALUE', x_sequence_name);
1490: app_exception.raise_exception;

Line 1487: fnd_message.set_token('TABLE', 'FND_SEQUENCES');

1483: where application_id = appl_id
1484: and sequence_name = upper(x_sequence_name);
1485: if (SQL%ROWCOUNT = 0) then
1486: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1487: fnd_message.set_token('TABLE', 'FND_SEQUENCES');
1488: fnd_message.set_token('COLUMN', 'SEQUENCE_NAME');
1489: fnd_message.set_token('VALUE', x_sequence_name);
1490: app_exception.raise_exception;
1491: return;

Line 1488: fnd_message.set_token('COLUMN', 'SEQUENCE_NAME');

1484: and sequence_name = upper(x_sequence_name);
1485: if (SQL%ROWCOUNT = 0) then
1486: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1487: fnd_message.set_token('TABLE', 'FND_SEQUENCES');
1488: fnd_message.set_token('COLUMN', 'SEQUENCE_NAME');
1489: fnd_message.set_token('VALUE', x_sequence_name);
1490: app_exception.raise_exception;
1491: return;
1492: end if;

Line 1489: fnd_message.set_token('VALUE', x_sequence_name);

1485: if (SQL%ROWCOUNT = 0) then
1486: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1487: fnd_message.set_token('TABLE', 'FND_SEQUENCES');
1488: fnd_message.set_token('COLUMN', 'SEQUENCE_NAME');
1489: fnd_message.set_token('VALUE', x_sequence_name);
1490: app_exception.raise_exception;
1491: return;
1492: end if;
1493:

Line 1513: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

1509: from fnd_application
1510: where application_short_name = upper(x_application_short_name);
1511: exception
1512: when no_data_found then
1513: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1514: fnd_message.set_token('TABLE', 'FND_APPLICATION');
1515: fnd_message.set_token('COLUMN', 'APPLICATION_SHORT_NAME');
1516: fnd_message.set_token('VALUE', x_application_short_name);
1517: app_exception.raise_exception;

Line 1514: fnd_message.set_token('TABLE', 'FND_APPLICATION');

1510: where application_short_name = upper(x_application_short_name);
1511: exception
1512: when no_data_found then
1513: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1514: fnd_message.set_token('TABLE', 'FND_APPLICATION');
1515: fnd_message.set_token('COLUMN', 'APPLICATION_SHORT_NAME');
1516: fnd_message.set_token('VALUE', x_application_short_name);
1517: app_exception.raise_exception;
1518: return;

Line 1515: fnd_message.set_token('COLUMN', 'APPLICATION_SHORT_NAME');

1511: exception
1512: when no_data_found then
1513: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1514: fnd_message.set_token('TABLE', 'FND_APPLICATION');
1515: fnd_message.set_token('COLUMN', 'APPLICATION_SHORT_NAME');
1516: fnd_message.set_token('VALUE', x_application_short_name);
1517: app_exception.raise_exception;
1518: return;
1519: end;

Line 1516: fnd_message.set_token('VALUE', x_application_short_name);

1512: when no_data_found then
1513: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1514: fnd_message.set_token('TABLE', 'FND_APPLICATION');
1515: fnd_message.set_token('COLUMN', 'APPLICATION_SHORT_NAME');
1516: fnd_message.set_token('VALUE', x_application_short_name);
1517: app_exception.raise_exception;
1518: return;
1519: end;
1520:

Line 1528: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

1524: where application_id = appl_id
1525: and view_name = upper(x_view_name);
1526: exception
1527: when no_data_found then
1528: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1529: fnd_message.set_token('TABLE', 'FND_VIEWS');
1530: fnd_message.set_token('COLUMN', 'VIEW_NAME');
1531: fnd_message.set_token('VALUE', x_view_name);
1532: app_exception.raise_exception;

Line 1529: fnd_message.set_token('TABLE', 'FND_VIEWS');

1525: and view_name = upper(x_view_name);
1526: exception
1527: when no_data_found then
1528: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1529: fnd_message.set_token('TABLE', 'FND_VIEWS');
1530: fnd_message.set_token('COLUMN', 'VIEW_NAME');
1531: fnd_message.set_token('VALUE', x_view_name);
1532: app_exception.raise_exception;
1533: return;

Line 1530: fnd_message.set_token('COLUMN', 'VIEW_NAME');

1526: exception
1527: when no_data_found then
1528: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1529: fnd_message.set_token('TABLE', 'FND_VIEWS');
1530: fnd_message.set_token('COLUMN', 'VIEW_NAME');
1531: fnd_message.set_token('VALUE', x_view_name);
1532: app_exception.raise_exception;
1533: return;
1534: end;

Line 1531: fnd_message.set_token('VALUE', x_view_name);

1527: when no_data_found then
1528: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1529: fnd_message.set_token('TABLE', 'FND_VIEWS');
1530: fnd_message.set_token('COLUMN', 'VIEW_NAME');
1531: fnd_message.set_token('VALUE', x_view_name);
1532: app_exception.raise_exception;
1533: return;
1534: end;
1535:

Line 1585: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

1581: from fnd_application
1582: where application_short_name = upper(x_application_short_name);
1583: exception
1584: when no_data_found then
1585: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1586: fnd_message.set_token('TABLE', 'FND_APPLICATION');
1587: fnd_message.set_token('COLUMN', 'APPLICATION_SHORT_NAME');
1588: fnd_message.set_token('VALUE', x_application_short_name);
1589: app_exception.raise_exception;

Line 1586: fnd_message.set_token('TABLE', 'FND_APPLICATION');

1582: where application_short_name = upper(x_application_short_name);
1583: exception
1584: when no_data_found then
1585: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1586: fnd_message.set_token('TABLE', 'FND_APPLICATION');
1587: fnd_message.set_token('COLUMN', 'APPLICATION_SHORT_NAME');
1588: fnd_message.set_token('VALUE', x_application_short_name);
1589: app_exception.raise_exception;
1590: return;

Line 1587: fnd_message.set_token('COLUMN', 'APPLICATION_SHORT_NAME');

1583: exception
1584: when no_data_found then
1585: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1586: fnd_message.set_token('TABLE', 'FND_APPLICATION');
1587: fnd_message.set_token('COLUMN', 'APPLICATION_SHORT_NAME');
1588: fnd_message.set_token('VALUE', x_application_short_name);
1589: app_exception.raise_exception;
1590: return;
1591: end;

Line 1588: fnd_message.set_token('VALUE', x_application_short_name);

1584: when no_data_found then
1585: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1586: fnd_message.set_token('TABLE', 'FND_APPLICATION');
1587: fnd_message.set_token('COLUMN', 'APPLICATION_SHORT_NAME');
1588: fnd_message.set_token('VALUE', x_application_short_name);
1589: app_exception.raise_exception;
1590: return;
1591: end;
1592:

Line 1601: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

1597: where application_id = appl_id
1598: and table_name = upper(x_table_name);
1599: exception
1600: when no_data_found then
1601: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1602: fnd_message.set_token('TABLE', 'FND_TABLES');
1603: fnd_message.set_token('COLUMN', 'TABLE_NAME');
1604: fnd_message.set_token('VALUE', x_table_name);
1605: app_exception.raise_exception;

Line 1602: fnd_message.set_token('TABLE', 'FND_TABLES');

1598: and table_name = upper(x_table_name);
1599: exception
1600: when no_data_found then
1601: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1602: fnd_message.set_token('TABLE', 'FND_TABLES');
1603: fnd_message.set_token('COLUMN', 'TABLE_NAME');
1604: fnd_message.set_token('VALUE', x_table_name);
1605: app_exception.raise_exception;
1606: return;

Line 1603: fnd_message.set_token('COLUMN', 'TABLE_NAME');

1599: exception
1600: when no_data_found then
1601: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1602: fnd_message.set_token('TABLE', 'FND_TABLES');
1603: fnd_message.set_token('COLUMN', 'TABLE_NAME');
1604: fnd_message.set_token('VALUE', x_table_name);
1605: app_exception.raise_exception;
1606: return;
1607: end;

Line 1604: fnd_message.set_token('VALUE', x_table_name);

1600: when no_data_found then
1601: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1602: fnd_message.set_token('TABLE', 'FND_TABLES');
1603: fnd_message.set_token('COLUMN', 'TABLE_NAME');
1604: fnd_message.set_token('VALUE', x_table_name);
1605: app_exception.raise_exception;
1606: return;
1607: end;
1608:

Line 1682: fnd_message.set_name('FND', 'FND-APPLICATION NAME');

1678: from FND_APPLICATION A
1679: where A.APPLICATION_SHORT_NAME = x_application_short_name;
1680: exception
1681: when no_data_found then
1682: fnd_message.set_name('FND', 'FND-APPLICATION NAME');
1683: fnd_message.set_token('APPLICATION_NAME', x_application_short_name);
1684: app_exception.raise_exception;
1685: end;
1686:

Line 1683: fnd_message.set_token('APPLICATION_NAME', x_application_short_name);

1679: where A.APPLICATION_SHORT_NAME = x_application_short_name;
1680: exception
1681: when no_data_found then
1682: fnd_message.set_name('FND', 'FND-APPLICATION NAME');
1683: fnd_message.set_token('APPLICATION_NAME', x_application_short_name);
1684: app_exception.raise_exception;
1685: end;
1686:
1687: -- Validate hosted support style

Line 1697: fnd_message.set_name('FND', 'FND-HOSTED SUPPORT STYLE');

1693: and lookup_code = x_hosted_support_style;
1694: end if;
1695: exception
1696: when no_data_found then
1697: fnd_message.set_name('FND', 'FND-HOSTED SUPPORT STYLE');
1698: fnd_message.set_token('HOSTED_SUPPORT_STYLE', x_hosted_support_style);
1699: app_exception.raise_exception;
1700: end;
1701:

Line 1698: fnd_message.set_token('HOSTED_SUPPORT_STYLE', x_hosted_support_style);

1694: end if;
1695: exception
1696: when no_data_found then
1697: fnd_message.set_name('FND', 'FND-HOSTED SUPPORT STYLE');
1698: fnd_message.set_token('HOSTED_SUPPORT_STYLE', x_hosted_support_style);
1699: app_exception.raise_exception;
1700: end;
1701:
1702: -- Translate owner to file_last_updated_by

Line 2336: fnd_message.set_name('FND', 'FND-COLUMN NAME');

2332: and C.TABLE_ID = tab_id
2333: and C.COLUMN_NAME = x_index_column_name;
2334: exception
2335: when no_data_found then
2336: fnd_message.set_name('FND', 'FND-COLUMN NAME');
2337: fnd_message.set_token('COLUMN_NAME', x_index_column_name);
2338: fnd_message.set_token('OBJECT_TYPE', 'Index');
2339: fnd_message.set_token('OBJECT_NAME', x_index_name);
2340: app_exception.raise_exception;

Line 2337: fnd_message.set_token('COLUMN_NAME', x_index_column_name);

2333: and C.COLUMN_NAME = x_index_column_name;
2334: exception
2335: when no_data_found then
2336: fnd_message.set_name('FND', 'FND-COLUMN NAME');
2337: fnd_message.set_token('COLUMN_NAME', x_index_column_name);
2338: fnd_message.set_token('OBJECT_TYPE', 'Index');
2339: fnd_message.set_token('OBJECT_NAME', x_index_name);
2340: app_exception.raise_exception;
2341: end;

Line 2338: fnd_message.set_token('OBJECT_TYPE', 'Index');

2334: exception
2335: when no_data_found then
2336: fnd_message.set_name('FND', 'FND-COLUMN NAME');
2337: fnd_message.set_token('COLUMN_NAME', x_index_column_name);
2338: fnd_message.set_token('OBJECT_TYPE', 'Index');
2339: fnd_message.set_token('OBJECT_NAME', x_index_name);
2340: app_exception.raise_exception;
2341: end;
2342:

Line 2339: fnd_message.set_token('OBJECT_NAME', x_index_name);

2335: when no_data_found then
2336: fnd_message.set_name('FND', 'FND-COLUMN NAME');
2337: fnd_message.set_token('COLUMN_NAME', x_index_column_name);
2338: fnd_message.set_token('OBJECT_TYPE', 'Index');
2339: fnd_message.set_token('OBJECT_NAME', x_index_name);
2340: app_exception.raise_exception;
2341: end;
2342:
2343: -- Translate owner to file_last_updated_by

Line 2380: fnd_message.set_name('FND', 'FND-DUPLICATE COLUMN SEQUENCE');

2376: f_luby);
2377:
2378: exception
2379: when dup_val_on_index then
2380: fnd_message.set_name('FND', 'FND-DUPLICATE COLUMN SEQUENCE');
2381: fnd_message.set_token('COLUMN_SEQUENCE', x_index_column_sequence);
2382: fnd_message.set_token('OBJECT_NAME', x_index_name);
2383: app_exception.raise_exception;
2384: end;

Line 2381: fnd_message.set_token('COLUMN_SEQUENCE', x_index_column_sequence);

2377:
2378: exception
2379: when dup_val_on_index then
2380: fnd_message.set_name('FND', 'FND-DUPLICATE COLUMN SEQUENCE');
2381: fnd_message.set_token('COLUMN_SEQUENCE', x_index_column_sequence);
2382: fnd_message.set_token('OBJECT_NAME', x_index_name);
2383: app_exception.raise_exception;
2384: end;
2385:

Line 2382: fnd_message.set_token('OBJECT_NAME', x_index_name);

2378: exception
2379: when dup_val_on_index then
2380: fnd_message.set_name('FND', 'FND-DUPLICATE COLUMN SEQUENCE');
2381: fnd_message.set_token('COLUMN_SEQUENCE', x_index_column_sequence);
2382: fnd_message.set_token('OBJECT_NAME', x_index_name);
2383: app_exception.raise_exception;
2384: end;
2385:
2386: end UploadIndexColumn;

Line 2448: fnd_message.set_name('FND', 'FND-INVALID PRIMARY KEY ATTR');

2444: end if;
2445:
2446: if ((pkmode = 'INSERT' and x_primary_key_type not in ('S', 'D')) or
2447: (pkmode = 'UPDATE' and nvl(x_primary_key_type, 'S') not in ('S', 'D'))) then
2448: fnd_message.set_name('FND', 'FND-INVALID PRIMARY KEY ATTR');
2449: fnd_message.set_token('ATTRIBUTE_NAME', 'Type');
2450: fnd_message.set_token('ATTRIBUTE_VALUE', x_primary_key_type);
2451: fnd_message.set_token('PRIMARY_KEY', x_primary_key_name);
2452: app_exception.raise_exception;

Line 2449: fnd_message.set_token('ATTRIBUTE_NAME', 'Type');

2445:
2446: if ((pkmode = 'INSERT' and x_primary_key_type not in ('S', 'D')) or
2447: (pkmode = 'UPDATE' and nvl(x_primary_key_type, 'S') not in ('S', 'D'))) then
2448: fnd_message.set_name('FND', 'FND-INVALID PRIMARY KEY ATTR');
2449: fnd_message.set_token('ATTRIBUTE_NAME', 'Type');
2450: fnd_message.set_token('ATTRIBUTE_VALUE', x_primary_key_type);
2451: fnd_message.set_token('PRIMARY_KEY', x_primary_key_name);
2452: app_exception.raise_exception;
2453: end if;

Line 2450: fnd_message.set_token('ATTRIBUTE_VALUE', x_primary_key_type);

2446: if ((pkmode = 'INSERT' and x_primary_key_type not in ('S', 'D')) or
2447: (pkmode = 'UPDATE' and nvl(x_primary_key_type, 'S') not in ('S', 'D'))) then
2448: fnd_message.set_name('FND', 'FND-INVALID PRIMARY KEY ATTR');
2449: fnd_message.set_token('ATTRIBUTE_NAME', 'Type');
2450: fnd_message.set_token('ATTRIBUTE_VALUE', x_primary_key_type);
2451: fnd_message.set_token('PRIMARY_KEY', x_primary_key_name);
2452: app_exception.raise_exception;
2453: end if;
2454:

Line 2451: fnd_message.set_token('PRIMARY_KEY', x_primary_key_name);

2447: (pkmode = 'UPDATE' and nvl(x_primary_key_type, 'S') not in ('S', 'D'))) then
2448: fnd_message.set_name('FND', 'FND-INVALID PRIMARY KEY ATTR');
2449: fnd_message.set_token('ATTRIBUTE_NAME', 'Type');
2450: fnd_message.set_token('ATTRIBUTE_VALUE', x_primary_key_type);
2451: fnd_message.set_token('PRIMARY_KEY', x_primary_key_name);
2452: app_exception.raise_exception;
2453: end if;
2454:
2455: if ((pkmode = 'INSERT' and x_audit_key_flag not in ('Y', 'N')) or

Line 2457: fnd_message.set_name('FND', 'FND-INVALID PRIMARY KEY ATTR');

2453: end if;
2454:
2455: if ((pkmode = 'INSERT' and x_audit_key_flag not in ('Y', 'N')) or
2456: (pkmode = 'UPDATE' and nvl(x_audit_key_flag, 'Y') not in ('Y', 'N'))) then
2457: fnd_message.set_name('FND', 'FND-INVALID PRIMARY KEY ATTR');
2458: fnd_message.set_token('ATTRIBUTE_NAME', 'Audit Key');
2459: fnd_message.set_token('ATTRIBUTE_VALUE', x_audit_key_flag);
2460: fnd_message.set_token('PRIMARY_KEY', x_primary_key_name);
2461: app_exception.raise_exception;

Line 2458: fnd_message.set_token('ATTRIBUTE_NAME', 'Audit Key');

2454:
2455: if ((pkmode = 'INSERT' and x_audit_key_flag not in ('Y', 'N')) or
2456: (pkmode = 'UPDATE' and nvl(x_audit_key_flag, 'Y') not in ('Y', 'N'))) then
2457: fnd_message.set_name('FND', 'FND-INVALID PRIMARY KEY ATTR');
2458: fnd_message.set_token('ATTRIBUTE_NAME', 'Audit Key');
2459: fnd_message.set_token('ATTRIBUTE_VALUE', x_audit_key_flag);
2460: fnd_message.set_token('PRIMARY_KEY', x_primary_key_name);
2461: app_exception.raise_exception;
2462: end if;

Line 2459: fnd_message.set_token('ATTRIBUTE_VALUE', x_audit_key_flag);

2455: if ((pkmode = 'INSERT' and x_audit_key_flag not in ('Y', 'N')) or
2456: (pkmode = 'UPDATE' and nvl(x_audit_key_flag, 'Y') not in ('Y', 'N'))) then
2457: fnd_message.set_name('FND', 'FND-INVALID PRIMARY KEY ATTR');
2458: fnd_message.set_token('ATTRIBUTE_NAME', 'Audit Key');
2459: fnd_message.set_token('ATTRIBUTE_VALUE', x_audit_key_flag);
2460: fnd_message.set_token('PRIMARY_KEY', x_primary_key_name);
2461: app_exception.raise_exception;
2462: end if;
2463:

Line 2460: fnd_message.set_token('PRIMARY_KEY', x_primary_key_name);

2456: (pkmode = 'UPDATE' and nvl(x_audit_key_flag, 'Y') not in ('Y', 'N'))) then
2457: fnd_message.set_name('FND', 'FND-INVALID PRIMARY KEY ATTR');
2458: fnd_message.set_token('ATTRIBUTE_NAME', 'Audit Key');
2459: fnd_message.set_token('ATTRIBUTE_VALUE', x_audit_key_flag);
2460: fnd_message.set_token('PRIMARY_KEY', x_primary_key_name);
2461: app_exception.raise_exception;
2462: end if;
2463:
2464: if ((pkmode = 'INSERT' and x_enabled_flag not in ('Y', 'N')) or

Line 2466: fnd_message.set_name('FND', 'FND-INVALID PRIMARY KEY ATTR');

2462: end if;
2463:
2464: if ((pkmode = 'INSERT' and x_enabled_flag not in ('Y', 'N')) or
2465: (pkmode = 'UPDATE' and nvl(x_enabled_flag, 'Y') not in ('Y', 'N'))) then
2466: fnd_message.set_name('FND', 'FND-INVALID PRIMARY KEY ATTR');
2467: fnd_message.set_token('ATTRIBUTE_NAME', 'Enabled Flag');
2468: fnd_message.set_token('ATTRIBUTE_VALUE', x_enabled_flag);
2469: fnd_message.set_token('PRIMARY_KEY', x_primary_key_name);
2470: app_exception.raise_exception;

Line 2467: fnd_message.set_token('ATTRIBUTE_NAME', 'Enabled Flag');

2463:
2464: if ((pkmode = 'INSERT' and x_enabled_flag not in ('Y', 'N')) or
2465: (pkmode = 'UPDATE' and nvl(x_enabled_flag, 'Y') not in ('Y', 'N'))) then
2466: fnd_message.set_name('FND', 'FND-INVALID PRIMARY KEY ATTR');
2467: fnd_message.set_token('ATTRIBUTE_NAME', 'Enabled Flag');
2468: fnd_message.set_token('ATTRIBUTE_VALUE', x_enabled_flag);
2469: fnd_message.set_token('PRIMARY_KEY', x_primary_key_name);
2470: app_exception.raise_exception;
2471: end if;

Line 2468: fnd_message.set_token('ATTRIBUTE_VALUE', x_enabled_flag);

2464: if ((pkmode = 'INSERT' and x_enabled_flag not in ('Y', 'N')) or
2465: (pkmode = 'UPDATE' and nvl(x_enabled_flag, 'Y') not in ('Y', 'N'))) then
2466: fnd_message.set_name('FND', 'FND-INVALID PRIMARY KEY ATTR');
2467: fnd_message.set_token('ATTRIBUTE_NAME', 'Enabled Flag');
2468: fnd_message.set_token('ATTRIBUTE_VALUE', x_enabled_flag);
2469: fnd_message.set_token('PRIMARY_KEY', x_primary_key_name);
2470: app_exception.raise_exception;
2471: end if;
2472:

Line 2469: fnd_message.set_token('PRIMARY_KEY', x_primary_key_name);

2465: (pkmode = 'UPDATE' and nvl(x_enabled_flag, 'Y') not in ('Y', 'N'))) then
2466: fnd_message.set_name('FND', 'FND-INVALID PRIMARY KEY ATTR');
2467: fnd_message.set_token('ATTRIBUTE_NAME', 'Enabled Flag');
2468: fnd_message.set_token('ATTRIBUTE_VALUE', x_enabled_flag);
2469: fnd_message.set_token('PRIMARY_KEY', x_primary_key_name);
2470: app_exception.raise_exception;
2471: end if;
2472:
2473: if (x_primary_key_type = 'D' and

Line 2475: fnd_message.set_name('FND', 'FND-MULTIPLE DEVELOPER PK');

2471: end if;
2472:
2473: if (x_primary_key_type = 'D' and
2474: MultipleDeveloperKeys(appl_id, tab_id, x_primary_key_name)) then
2475: fnd_message.set_name('FND', 'FND-MULTIPLE DEVELOPER PK');
2476: fnd_message.set_token('TABLE_NAME', x_table_name);
2477: app_exception.raise_exception;
2478: end if;
2479:

Line 2476: fnd_message.set_token('TABLE_NAME', x_table_name);

2472:
2473: if (x_primary_key_type = 'D' and
2474: MultipleDeveloperKeys(appl_id, tab_id, x_primary_key_name)) then
2475: fnd_message.set_name('FND', 'FND-MULTIPLE DEVELOPER PK');
2476: fnd_message.set_token('TABLE_NAME', x_table_name);
2477: app_exception.raise_exception;
2478: end if;
2479:
2480: -- Bug2631776 In this section handle the parent entity

Line 2779: fnd_message.set_name('FND', 'FND-COLUMN NAME');

2775: and C.TABLE_ID = tab_id
2776: and C.COLUMN_NAME = x_primary_key_column_name;
2777: exception
2778: when no_data_found then
2779: fnd_message.set_name('FND', 'FND-COLUMN NAME');
2780: fnd_message.set_token('COLUMN_NAME', x_primary_key_column_name);
2781: fnd_message.set_token('OBJECT_TYPE', 'Primary Key');
2782: fnd_message.set_token('OBJECT_NAME', x_primary_key_name);
2783: app_exception.raise_exception;

Line 2780: fnd_message.set_token('COLUMN_NAME', x_primary_key_column_name);

2776: and C.COLUMN_NAME = x_primary_key_column_name;
2777: exception
2778: when no_data_found then
2779: fnd_message.set_name('FND', 'FND-COLUMN NAME');
2780: fnd_message.set_token('COLUMN_NAME', x_primary_key_column_name);
2781: fnd_message.set_token('OBJECT_TYPE', 'Primary Key');
2782: fnd_message.set_token('OBJECT_NAME', x_primary_key_name);
2783: app_exception.raise_exception;
2784: end;

Line 2781: fnd_message.set_token('OBJECT_TYPE', 'Primary Key');

2777: exception
2778: when no_data_found then
2779: fnd_message.set_name('FND', 'FND-COLUMN NAME');
2780: fnd_message.set_token('COLUMN_NAME', x_primary_key_column_name);
2781: fnd_message.set_token('OBJECT_TYPE', 'Primary Key');
2782: fnd_message.set_token('OBJECT_NAME', x_primary_key_name);
2783: app_exception.raise_exception;
2784: end;
2785:

Line 2782: fnd_message.set_token('OBJECT_NAME', x_primary_key_name);

2778: when no_data_found then
2779: fnd_message.set_name('FND', 'FND-COLUMN NAME');
2780: fnd_message.set_token('COLUMN_NAME', x_primary_key_column_name);
2781: fnd_message.set_token('OBJECT_TYPE', 'Primary Key');
2782: fnd_message.set_token('OBJECT_NAME', x_primary_key_name);
2783: app_exception.raise_exception;
2784: end;
2785:
2786: -- Translate owner to file_last_updated_by

Line 2822: fnd_message.set_name('FND', 'FND-DUPLICATE COLUMN SEQUENCE');

2818: f_ludate,
2819: f_luby);
2820: exception
2821: when dup_val_on_index then
2822: fnd_message.set_name('FND', 'FND-DUPLICATE COLUMN SEQUENCE');
2823: fnd_message.set_token('COLUMN_SEQUENCE', x_primary_key_column_sequence);
2824: fnd_message.set_token('OBJECT_NAME', x_primary_key_name);
2825: app_exception.raise_exception;
2826: end;

Line 2823: fnd_message.set_token('COLUMN_SEQUENCE', x_primary_key_column_sequence);

2819: f_luby);
2820: exception
2821: when dup_val_on_index then
2822: fnd_message.set_name('FND', 'FND-DUPLICATE COLUMN SEQUENCE');
2823: fnd_message.set_token('COLUMN_SEQUENCE', x_primary_key_column_sequence);
2824: fnd_message.set_token('OBJECT_NAME', x_primary_key_name);
2825: app_exception.raise_exception;
2826: end;
2827:

Line 2824: fnd_message.set_token('OBJECT_NAME', x_primary_key_name);

2820: exception
2821: when dup_val_on_index then
2822: fnd_message.set_name('FND', 'FND-DUPLICATE COLUMN SEQUENCE');
2823: fnd_message.set_token('COLUMN_SEQUENCE', x_primary_key_column_sequence);
2824: fnd_message.set_token('OBJECT_NAME', x_primary_key_name);
2825: app_exception.raise_exception;
2826: end;
2827:
2828: end UploadPrimaryKeyColumn;

Line 2890: fnd_message.set_name('FND', 'INVALID_PRIMARY_KEY');

2886: x_primary_key_name, pk_appl_id, pk_tab_id, pk_id);
2887:
2888: if (pk_id = -1) then
2889: /*
2890: fnd_message.set_name('FND', 'INVALID_PRIMARY_KEY');
2891: fnd_message.set_token('PRIMARY_KEY', x_primary_key_name);
2892: fnd_message.set_token('TABLE_NAME', x_primary_key_table_name);
2893: fnd_message.set_token('APPLICATION_NAME', x_primary_key_application_name);
2894: fnd_message.set_token('FOREIGN_KEY', x_foreign_key_name);

Line 2891: fnd_message.set_token('PRIMARY_KEY', x_primary_key_name);

2887:
2888: if (pk_id = -1) then
2889: /*
2890: fnd_message.set_name('FND', 'INVALID_PRIMARY_KEY');
2891: fnd_message.set_token('PRIMARY_KEY', x_primary_key_name);
2892: fnd_message.set_token('TABLE_NAME', x_primary_key_table_name);
2893: fnd_message.set_token('APPLICATION_NAME', x_primary_key_application_name);
2894: fnd_message.set_token('FOREIGN_KEY', x_foreign_key_name);
2895: app_exception.raise_exception;

Line 2892: fnd_message.set_token('TABLE_NAME', x_primary_key_table_name);

2888: if (pk_id = -1) then
2889: /*
2890: fnd_message.set_name('FND', 'INVALID_PRIMARY_KEY');
2891: fnd_message.set_token('PRIMARY_KEY', x_primary_key_name);
2892: fnd_message.set_token('TABLE_NAME', x_primary_key_table_name);
2893: fnd_message.set_token('APPLICATION_NAME', x_primary_key_application_name);
2894: fnd_message.set_token('FOREIGN_KEY', x_foreign_key_name);
2895: app_exception.raise_exception;
2896: */

Line 2893: fnd_message.set_token('APPLICATION_NAME', x_primary_key_application_name);

2889: /*
2890: fnd_message.set_name('FND', 'INVALID_PRIMARY_KEY');
2891: fnd_message.set_token('PRIMARY_KEY', x_primary_key_name);
2892: fnd_message.set_token('TABLE_NAME', x_primary_key_table_name);
2893: fnd_message.set_token('APPLICATION_NAME', x_primary_key_application_name);
2894: fnd_message.set_token('FOREIGN_KEY', x_foreign_key_name);
2895: app_exception.raise_exception;
2896: */
2897: pk_appl_id := -1;

Line 2894: fnd_message.set_token('FOREIGN_KEY', x_foreign_key_name);

2890: fnd_message.set_name('FND', 'INVALID_PRIMARY_KEY');
2891: fnd_message.set_token('PRIMARY_KEY', x_primary_key_name);
2892: fnd_message.set_token('TABLE_NAME', x_primary_key_table_name);
2893: fnd_message.set_token('APPLICATION_NAME', x_primary_key_application_name);
2894: fnd_message.set_token('FOREIGN_KEY', x_foreign_key_name);
2895: app_exception.raise_exception;
2896: */
2897: pk_appl_id := -1;
2898: pk_tab_id := -1;

Line 3205: fnd_message.set_name('FND', 'FND-COLUMN NAME');

3201: and C.TABLE_ID = tab_id
3202: and C.COLUMN_NAME = x_foreign_key_column_name;
3203: exception
3204: when no_data_found then
3205: fnd_message.set_name('FND', 'FND-COLUMN NAME');
3206: fnd_message.set_token('COLUMN_NAME', x_foreign_key_column_name);
3207: fnd_message.set_token('OBJECT_TYPE', 'Foreign Key');
3208: fnd_message.set_token('OBJECT_NAME', x_foreign_key_name);
3209: app_exception.raise_exception;

Line 3206: fnd_message.set_token('COLUMN_NAME', x_foreign_key_column_name);

3202: and C.COLUMN_NAME = x_foreign_key_column_name;
3203: exception
3204: when no_data_found then
3205: fnd_message.set_name('FND', 'FND-COLUMN NAME');
3206: fnd_message.set_token('COLUMN_NAME', x_foreign_key_column_name);
3207: fnd_message.set_token('OBJECT_TYPE', 'Foreign Key');
3208: fnd_message.set_token('OBJECT_NAME', x_foreign_key_name);
3209: app_exception.raise_exception;
3210: end;

Line 3207: fnd_message.set_token('OBJECT_TYPE', 'Foreign Key');

3203: exception
3204: when no_data_found then
3205: fnd_message.set_name('FND', 'FND-COLUMN NAME');
3206: fnd_message.set_token('COLUMN_NAME', x_foreign_key_column_name);
3207: fnd_message.set_token('OBJECT_TYPE', 'Foreign Key');
3208: fnd_message.set_token('OBJECT_NAME', x_foreign_key_name);
3209: app_exception.raise_exception;
3210: end;
3211:

Line 3208: fnd_message.set_token('OBJECT_NAME', x_foreign_key_name);

3204: when no_data_found then
3205: fnd_message.set_name('FND', 'FND-COLUMN NAME');
3206: fnd_message.set_token('COLUMN_NAME', x_foreign_key_column_name);
3207: fnd_message.set_token('OBJECT_TYPE', 'Foreign Key');
3208: fnd_message.set_token('OBJECT_NAME', x_foreign_key_name);
3209: app_exception.raise_exception;
3210: end;
3211:
3212: -- Translate owner to file_last_updated_by

Line 3251: fnd_message.set_name('FND', 'FND-DUPLICATE COLUMN SEQUENCE');

3247: f_ludate,
3248: f_luby);
3249: exception
3250: when dup_val_on_index then
3251: fnd_message.set_name('FND', 'FND-DUPLICATE COLUMN SEQUENCE');
3252: fnd_message.set_token('COLUMN_SEQUENCE', x_foreign_key_column_sequence);
3253: fnd_message.set_token('OBJECT_NAME', x_foreign_key_name);
3254: app_exception.raise_exception;
3255: end;

Line 3252: fnd_message.set_token('COLUMN_SEQUENCE', x_foreign_key_column_sequence);

3248: f_luby);
3249: exception
3250: when dup_val_on_index then
3251: fnd_message.set_name('FND', 'FND-DUPLICATE COLUMN SEQUENCE');
3252: fnd_message.set_token('COLUMN_SEQUENCE', x_foreign_key_column_sequence);
3253: fnd_message.set_token('OBJECT_NAME', x_foreign_key_name);
3254: app_exception.raise_exception;
3255: end;
3256: end UploadForeignKeyColumn;

Line 3253: fnd_message.set_token('OBJECT_NAME', x_foreign_key_name);

3249: exception
3250: when dup_val_on_index then
3251: fnd_message.set_name('FND', 'FND-DUPLICATE COLUMN SEQUENCE');
3252: fnd_message.set_token('COLUMN_SEQUENCE', x_foreign_key_column_sequence);
3253: fnd_message.set_token('OBJECT_NAME', x_foreign_key_name);
3254: app_exception.raise_exception;
3255: end;
3256: end UploadForeignKeyColumn;
3257:

Line 3294: fnd_message.set_name('FND', 'FND-APPLICATION NAME');

3290: where A.APPLICATION_SHORT_NAME = x_application_short_name;
3291:
3292: exception
3293: when no_data_found then
3294: fnd_message.set_name('FND', 'FND-APPLICATION NAME');
3295: fnd_message.set_token('APPLICATION_NAME', x_application_short_name);
3296: app_exception.raise_exception;
3297: end;
3298:

Line 3295: fnd_message.set_token('APPLICATION_NAME', x_application_short_name);

3291:
3292: exception
3293: when no_data_found then
3294: fnd_message.set_name('FND', 'FND-APPLICATION NAME');
3295: fnd_message.set_token('APPLICATION_NAME', x_application_short_name);
3296: app_exception.raise_exception;
3297: end;
3298:
3299: -- Translate owner to file_last_updated_by

Line 3390: fnd_message.set_name('FND', 'FND-APPLICATION NAME');

3386: from FND_APPLICATION A
3387: where A.APPLICATION_SHORT_NAME = x_application_short_name;
3388: exception
3389: when no_data_found then
3390: fnd_message.set_name('FND', 'FND-APPLICATION NAME');
3391: fnd_message.set_token('APPLICATION_NAME', x_application_short_name);
3392: app_exception.raise_exception;
3393: end;
3394:

Line 3391: fnd_message.set_token('APPLICATION_NAME', x_application_short_name);

3387: where A.APPLICATION_SHORT_NAME = x_application_short_name;
3388: exception
3389: when no_data_found then
3390: fnd_message.set_name('FND', 'FND-APPLICATION NAME');
3391: fnd_message.set_token('APPLICATION_NAME', x_application_short_name);
3392: app_exception.raise_exception;
3393: end;
3394:
3395: if (x_phase_mode = 'BEGIN') then

Line 3641: fnd_message.set_name('FND', 'FND-DUPLICATE COLUMN SEQUENCE');

3637: f_ludate,
3638: f_luby);
3639: exception
3640: when dup_val_on_index then
3641: fnd_message.set_name('FND', 'FND-DUPLICATE COLUMN SEQUENCE');
3642: fnd_message.set_token('COLUMN_SEQUENCE', x_view_column_sequence);
3643: fnd_message.set_token('OBJECT_NAME', x_view_name);
3644: app_exception.raise_exception;
3645: end;

Line 3642: fnd_message.set_token('COLUMN_SEQUENCE', x_view_column_sequence);

3638: f_luby);
3639: exception
3640: when dup_val_on_index then
3641: fnd_message.set_name('FND', 'FND-DUPLICATE COLUMN SEQUENCE');
3642: fnd_message.set_token('COLUMN_SEQUENCE', x_view_column_sequence);
3643: fnd_message.set_token('OBJECT_NAME', x_view_name);
3644: app_exception.raise_exception;
3645: end;
3646: end UploadViewColumn;

Line 3643: fnd_message.set_token('OBJECT_NAME', x_view_name);

3639: exception
3640: when dup_val_on_index then
3641: fnd_message.set_name('FND', 'FND-DUPLICATE COLUMN SEQUENCE');
3642: fnd_message.set_token('COLUMN_SEQUENCE', x_view_column_sequence);
3643: fnd_message.set_token('OBJECT_NAME', x_view_name);
3644: app_exception.raise_exception;
3645: end;
3646: end UploadViewColumn;
3647:

Line 3888: fnd_message.set_name('FND', 'FK_COLUMN_VALUE_DUPLICATE');

3884: visited_table_count := visited_table_count + 1;
3885:
3886: exception
3887: when unique_constraint then
3888: fnd_message.set_name('FND', 'FK_COLUMN_VALUE_DUPLICATE');
3889: fnd_message.set_token('FK_TABLE', fk.table_name);
3890: fnd_message.set_token('UPDATE_STATEMENT', updbuf);
3891: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3892: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

Line 3889: fnd_message.set_token('FK_TABLE', fk.table_name);

3885:
3886: exception
3887: when unique_constraint then
3888: fnd_message.set_name('FND', 'FK_COLUMN_VALUE_DUPLICATE');
3889: fnd_message.set_token('FK_TABLE', fk.table_name);
3890: fnd_message.set_token('UPDATE_STATEMENT', updbuf);
3891: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3892: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3893: c_log_head || l_api_name || '.update_failed', FALSE);

Line 3890: fnd_message.set_token('UPDATE_STATEMENT', updbuf);

3886: exception
3887: when unique_constraint then
3888: fnd_message.set_name('FND', 'FK_COLUMN_VALUE_DUPLICATE');
3889: fnd_message.set_token('FK_TABLE', fk.table_name);
3890: fnd_message.set_token('UPDATE_STATEMENT', updbuf);
3891: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3892: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3893: c_log_head || l_api_name || '.update_failed', FALSE);
3894: end if;

Line 3902: fnd_message.set_name('FND', 'FK_TABLE_NOT_FOUND');

3898: -- continue;
3899:
3900: when table_doesnot_exist then
3901: -- ORA 942
3902: fnd_message.set_name('FND', 'FK_TABLE_NOT_FOUND');
3903: fnd_message.set_token('FK_TABLE', fk.table_name);
3904: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3905: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3906: c_log_head || l_api_name || '.update_failed', FALSE);

Line 3903: fnd_message.set_token('FK_TABLE', fk.table_name);

3899:
3900: when table_doesnot_exist then
3901: -- ORA 942
3902: fnd_message.set_name('FND', 'FK_TABLE_NOT_FOUND');
3903: fnd_message.set_token('FK_TABLE', fk.table_name);
3904: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3905: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3906: c_log_head || l_api_name || '.update_failed', FALSE);
3907: end if;

Line 3915: fnd_message.set_name('FND', 'FK_COLUMN_NOT_FOUND');

3911: -- continue;
3912:
3913: when column_doesnot_exist then
3914: -- ORA 904
3915: fnd_message.set_name('FND', 'FK_COLUMN_NOT_FOUND');
3916: j := 0;
3917: tmpbuf := '';
3918: while (j < i or j = i) loop
3919: tmpbuf := tmpbuf || colnames(j)||',';

Line 3922: fnd_message.set_token('FK_COLUMN',

3918: while (j < i or j = i) loop
3919: tmpbuf := tmpbuf || colnames(j)||',';
3920: j := j + 1;
3921: end loop;
3922: fnd_message.set_token('FK_COLUMN',
3923: tmpbuf||' or LAST_UPDATED_BY or LAST_UPDATE_DATE' );
3924: fnd_message.set_token('FK_TABLE', fk.table_name);
3925: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3926: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

Line 3924: fnd_message.set_token('FK_TABLE', fk.table_name);

3920: j := j + 1;
3921: end loop;
3922: fnd_message.set_token('FK_COLUMN',
3923: tmpbuf||' or LAST_UPDATED_BY or LAST_UPDATE_DATE' );
3924: fnd_message.set_token('FK_TABLE', fk.table_name);
3925: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3926: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3927: c_log_head || l_api_name || '.update_failed', FALSE);
3928: end if;

Line 3935: fnd_message.set_name('FND', 'FK_DUPLICATE_COLUMN_UPDATE');

3931: -- Try again. Update it WITHOUT the who column
3932:
3933: when duplicate_column_name then
3934: -- ORA 957
3935: fnd_message.set_name('FND', 'FK_DUPLICATE_COLUMN_UPDATE');
3936: fnd_message.set_token('SQL_STATEMENT', updbuf);
3937: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3938: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3939: c_log_head || l_api_name || '.update_failed', FALSE);

Line 3936: fnd_message.set_token('SQL_STATEMENT', updbuf);

3932:
3933: when duplicate_column_name then
3934: -- ORA 957
3935: fnd_message.set_name('FND', 'FK_DUPLICATE_COLUMN_UPDATE');
3936: fnd_message.set_token('SQL_STATEMENT', updbuf);
3937: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3938: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3939: c_log_head || l_api_name || '.update_failed', FALSE);
3940: end if;

Line 3944: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

3940: end if;
3941: checking_log := TRUE;
3942: -- Probably no need to raise error
3943: when others then
3944: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
3945: fnd_message.set_token('ROUTINE', 'UpdateChildren');
3946: fnd_message.set_token('ERRNO', to_char(sqlcode));
3947: fnd_message.set_token('REASON', sqlerrm);
3948: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then

Line 3945: fnd_message.set_token('ROUTINE', 'UpdateChildren');

3941: checking_log := TRUE;
3942: -- Probably no need to raise error
3943: when others then
3944: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
3945: fnd_message.set_token('ROUTINE', 'UpdateChildren');
3946: fnd_message.set_token('ERRNO', to_char(sqlcode));
3947: fnd_message.set_token('REASON', sqlerrm);
3948: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3949: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

Line 3946: fnd_message.set_token('ERRNO', to_char(sqlcode));

3942: -- Probably no need to raise error
3943: when others then
3944: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
3945: fnd_message.set_token('ROUTINE', 'UpdateChildren');
3946: fnd_message.set_token('ERRNO', to_char(sqlcode));
3947: fnd_message.set_token('REASON', sqlerrm);
3948: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3949: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3950: c_log_head || l_api_name || '.update_failed', FALSE);

Line 3947: fnd_message.set_token('REASON', sqlerrm);

3943: when others then
3944: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
3945: fnd_message.set_token('ROUTINE', 'UpdateChildren');
3946: fnd_message.set_token('ERRNO', to_char(sqlcode));
3947: fnd_message.set_token('REASON', sqlerrm);
3948: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3949: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3950: c_log_head || l_api_name || '.update_failed', FALSE);
3951: end if;

Line 3963: fnd_message.set_name('FND', 'FK_FOUND_NO_DELETE_PK');

3959: -- and forget about the rest of the loop.
3960: if (x_primary_key_col_value_new(0) is null) then
3961: if (l_exists_flag = 'Y') then
3962: -- put a message on the stack regarding which foreign key child
3963: fnd_message.set_name('FND', 'FK_FOUND_NO_DELETE_PK');
3964: fnd_message.set_token('FK_TABLE', fk.table_name);
3965: fnd_message.set_token('FK_KEY', fk.foreign_key_name);
3966: return(TRUE);
3967: end if;

Line 3964: fnd_message.set_token('FK_TABLE', fk.table_name);

3960: if (x_primary_key_col_value_new(0) is null) then
3961: if (l_exists_flag = 'Y') then
3962: -- put a message on the stack regarding which foreign key child
3963: fnd_message.set_name('FND', 'FK_FOUND_NO_DELETE_PK');
3964: fnd_message.set_token('FK_TABLE', fk.table_name);
3965: fnd_message.set_token('FK_KEY', fk.foreign_key_name);
3966: return(TRUE);
3967: end if;
3968: -- End 1496010

Line 3965: fnd_message.set_token('FK_KEY', fk.foreign_key_name);

3961: if (l_exists_flag = 'Y') then
3962: -- put a message on the stack regarding which foreign key child
3963: fnd_message.set_name('FND', 'FK_FOUND_NO_DELETE_PK');
3964: fnd_message.set_token('FK_TABLE', fk.table_name);
3965: fnd_message.set_token('FK_KEY', fk.foreign_key_name);
3966: return(TRUE);
3967: end if;
3968: -- End 1496010
3969: else

Line 4073: fnd_message.set_name('FND', 'FK_INVALID_TABLE');

4069: and a.application_id = t.application_id
4070: and t.table_name = x_primary_table_name;
4071: exception
4072: when no_data_found then
4073: fnd_message.set_name('FND', 'FK_INVALID_TABLE');
4074: fnd_message.set_token('APPS', x_application_short_name);
4075: fnd_message.set_token('TABLE', x_primary_table_name);
4076: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
4077: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

Line 4074: fnd_message.set_token('APPS', x_application_short_name);

4070: and t.table_name = x_primary_table_name;
4071: exception
4072: when no_data_found then
4073: fnd_message.set_name('FND', 'FK_INVALID_TABLE');
4074: fnd_message.set_token('APPS', x_application_short_name);
4075: fnd_message.set_token('TABLE', x_primary_table_name);
4076: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
4077: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
4078: c_log_head || l_api_name || '.fetch_info', FALSE);

Line 4075: fnd_message.set_token('TABLE', x_primary_table_name);

4071: exception
4072: when no_data_found then
4073: fnd_message.set_name('FND', 'FK_INVALID_TABLE');
4074: fnd_message.set_token('APPS', x_application_short_name);
4075: fnd_message.set_token('TABLE', x_primary_table_name);
4076: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
4077: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
4078: c_log_head || l_api_name || '.fetch_info', FALSE);
4079: end if;

Line 4082: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

4078: c_log_head || l_api_name || '.fetch_info', FALSE);
4079: end if;
4080: return(FALSE);
4081: when others then
4082: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
4083: fnd_message.set_token('ROUTINE', 'UpdatePKColumns');
4084: fnd_message.set_token('ERRNO', to_char(sqlcode));
4085: fnd_message.set_token('REASON', sqlerrm);
4086: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then

Line 4083: fnd_message.set_token('ROUTINE', 'UpdatePKColumns');

4079: end if;
4080: return(FALSE);
4081: when others then
4082: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
4083: fnd_message.set_token('ROUTINE', 'UpdatePKColumns');
4084: fnd_message.set_token('ERRNO', to_char(sqlcode));
4085: fnd_message.set_token('REASON', sqlerrm);
4086: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
4087: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

Line 4084: fnd_message.set_token('ERRNO', to_char(sqlcode));

4080: return(FALSE);
4081: when others then
4082: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
4083: fnd_message.set_token('ROUTINE', 'UpdatePKColumns');
4084: fnd_message.set_token('ERRNO', to_char(sqlcode));
4085: fnd_message.set_token('REASON', sqlerrm);
4086: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
4087: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
4088: c_log_head || l_api_name || '.fetch_info', FALSE);

Line 4085: fnd_message.set_token('REASON', sqlerrm);

4081: when others then
4082: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
4083: fnd_message.set_token('ROUTINE', 'UpdatePKColumns');
4084: fnd_message.set_token('ERRNO', to_char(sqlcode));
4085: fnd_message.set_token('REASON', sqlerrm);
4086: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
4087: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
4088: c_log_head || l_api_name || '.fetch_info', FALSE);
4089: end if;