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 APP_EXCEPTION

Line 1119: app_exception.raise_exception;

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:
1123: begin

Line 1135: app_exception.raise_exception;

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:
1139: begin

Line 1152: app_exception.raise_exception;

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:
1156: -- Before removing this column, make sure that there is no index,

Line 1172: app_exception.raise_exception;

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:
1176: -- Check primary key column

Line 1189: app_exception.raise_exception;

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:
1193: -- Check foreign key column

Line 1206: app_exception.raise_exception;

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:
1210: delete from fnd_columns

Line 1240: app_exception.raise_exception;

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:
1244: begin

Line 1256: app_exception.raise_exception;

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:
1260: begin

Line 1273: app_exception.raise_exception;

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:
1277: -- Delete index columns

Line 1316: app_exception.raise_exception;

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:
1320: begin

Line 1332: app_exception.raise_exception;

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:
1336: begin

Line 1349: app_exception.raise_exception;

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:
1353: -- Before deleting primary key, make sure that there is no foreign key

Line 1379: app_exception.raise_exception;

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:
1383: end RemovePrimaryKey;

Line 1408: app_exception.raise_exception;

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:
1412: begin

Line 1424: app_exception.raise_exception;

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:
1428: begin

Line 1441: app_exception.raise_exception;

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:
1445: -- Nothing pointing to foreign key so is safe to delete

Line 1478: app_exception.raise_exception;

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:
1482: delete from fnd_sequences

Line 1490: app_exception.raise_exception;

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:
1494: end RemoveSequence;

Line 1517: app_exception.raise_exception;

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:
1521: begin

Line 1532: app_exception.raise_exception;

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:
1536: -- Nothing pointing to view, so is safe to delete

Line 1589: app_exception.raise_exception;

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:
1593: begin

Line 1605: app_exception.raise_exception;

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:
1609: -- Before removing this table, remove all the children.

Line 1684: app_exception.raise_exception;

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
1688: begin

Line 1699: app_exception.raise_exception;

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
1703: f_luby := fnd_load_util.owner_id(x_user_id);

Line 2340: app_exception.raise_exception;

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
2344: f_luby := fnd_load_util.owner_id(x_user_id);

Line 2383: app_exception.raise_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;
2387:

Line 2452: app_exception.raise_exception;

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
2456: (pkmode = 'UPDATE' and nvl(x_audit_key_flag, 'Y') not in ('Y', 'N'))) then

Line 2461: app_exception.raise_exception;

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
2465: (pkmode = 'UPDATE' and nvl(x_enabled_flag, 'Y') not in ('Y', 'N'))) then

Line 2470: app_exception.raise_exception;

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
2474: MultipleDeveloperKeys(appl_id, tab_id, x_primary_key_name)) then

Line 2477: app_exception.raise_exception;

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
2481: -- and update the child entity so that constraints do not occur.

Line 2783: app_exception.raise_exception;

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
2787: f_luby := fnd_load_util.owner_id(x_user_id);

Line 2825: app_exception.raise_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;
2829:

Line 2895: app_exception.raise_exception;

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;
2899:

Line 3209: app_exception.raise_exception;

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
3213: f_luby := fnd_load_util.owner_id(x_user_id);

Line 3254: app_exception.raise_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:
3258:

Line 3296: app_exception.raise_exception;

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
3300: f_luby := fnd_load_util.owner_id(x_user_id);

Line 3392: app_exception.raise_exception;

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
3396:

Line 3644: app_exception.raise_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:
3648: