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.ALR_DBTRIGGER dependencies on FND_MESSAGE

Line 617: FND_MESSAGE.SET_NAME('FND', 'SQL-Generic error');

613: -- Ignore...
614: NULL;
615:
616: when others then
617: FND_MESSAGE.SET_NAME('FND', 'SQL-Generic error');
618: FND_MESSAGE.SET_TOKEN('ERRNO', SQLCODE, FALSE);
619: FND_MESSAGE.SET_TOKEN('REASON', SQLERRM, FALSE);
620: FND_MESSAGE.SET_TOKEN(
621: 'ROUTINE', 'DROP_EVENT_DB_TRIGGER', FALSE);

Line 618: FND_MESSAGE.SET_TOKEN('ERRNO', SQLCODE, FALSE);

614: NULL;
615:
616: when others then
617: FND_MESSAGE.SET_NAME('FND', 'SQL-Generic error');
618: FND_MESSAGE.SET_TOKEN('ERRNO', SQLCODE, FALSE);
619: FND_MESSAGE.SET_TOKEN('REASON', SQLERRM, FALSE);
620: FND_MESSAGE.SET_TOKEN(
621: 'ROUTINE', 'DROP_EVENT_DB_TRIGGER', FALSE);
622: APP_EXCEPTION.RAISE_EXCEPTION;

Line 619: FND_MESSAGE.SET_TOKEN('REASON', SQLERRM, FALSE);

615:
616: when others then
617: FND_MESSAGE.SET_NAME('FND', 'SQL-Generic error');
618: FND_MESSAGE.SET_TOKEN('ERRNO', SQLCODE, FALSE);
619: FND_MESSAGE.SET_TOKEN('REASON', SQLERRM, FALSE);
620: FND_MESSAGE.SET_TOKEN(
621: 'ROUTINE', 'DROP_EVENT_DB_TRIGGER', FALSE);
622: APP_EXCEPTION.RAISE_EXCEPTION;
623:

Line 620: FND_MESSAGE.SET_TOKEN(

616: when others then
617: FND_MESSAGE.SET_NAME('FND', 'SQL-Generic error');
618: FND_MESSAGE.SET_TOKEN('ERRNO', SQLCODE, FALSE);
619: FND_MESSAGE.SET_TOKEN('REASON', SQLERRM, FALSE);
620: FND_MESSAGE.SET_TOKEN(
621: 'ROUTINE', 'DROP_EVENT_DB_TRIGGER', FALSE);
622: APP_EXCEPTION.RAISE_EXCEPTION;
623:
624: end DELETE_EVENT_DB_TRIGGER$1;

Line 882: 'raise_application_error(-20160, FND_MESSAGE.GET);' ||

878: TBLNM || ''',rowidtochar(:new.rowid)' ||
879: ',''' || event_mode || ''',mailid,ORGID);' ||
880:
881: 'if REQID=0 then ' ||
882: 'raise_application_error(-20160, FND_MESSAGE.GET);' ||
883: 'end if;' ||
884:
885: 'end;';
886:

Line 1040: FND_MESSAGE.SET_NAME('ALR', 'TRIGGER-NO TABLE IN ACCOUNT');

1036: exception
1037:
1038: when NONEXISTENT_TABLE then
1039:
1040: FND_MESSAGE.SET_NAME('ALR', 'TRIGGER-NO TABLE IN ACCOUNT');
1041: -- this message is uppercased in fnd_new_messages and fnd_messages
1042: FND_MESSAGE.SET_TOKEN('TABLE_NAME', TBL_NAME);
1043: FND_MESSAGE.SET_TOKEN('ORACLE_USERNAME',
1044: alr_dbtrigger.BAD_ORACLE_USERNAMES, FALSE);

Line 1041: -- this message is uppercased in fnd_new_messages and fnd_messages

1037:
1038: when NONEXISTENT_TABLE then
1039:
1040: FND_MESSAGE.SET_NAME('ALR', 'TRIGGER-NO TABLE IN ACCOUNT');
1041: -- this message is uppercased in fnd_new_messages and fnd_messages
1042: FND_MESSAGE.SET_TOKEN('TABLE_NAME', TBL_NAME);
1043: FND_MESSAGE.SET_TOKEN('ORACLE_USERNAME',
1044: alr_dbtrigger.BAD_ORACLE_USERNAMES, FALSE);
1045: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1042: FND_MESSAGE.SET_TOKEN('TABLE_NAME', TBL_NAME);

1038: when NONEXISTENT_TABLE then
1039:
1040: FND_MESSAGE.SET_NAME('ALR', 'TRIGGER-NO TABLE IN ACCOUNT');
1041: -- this message is uppercased in fnd_new_messages and fnd_messages
1042: FND_MESSAGE.SET_TOKEN('TABLE_NAME', TBL_NAME);
1043: FND_MESSAGE.SET_TOKEN('ORACLE_USERNAME',
1044: alr_dbtrigger.BAD_ORACLE_USERNAMES, FALSE);
1045: APP_EXCEPTION.RAISE_EXCEPTION;
1046:

Line 1043: FND_MESSAGE.SET_TOKEN('ORACLE_USERNAME',

1039:
1040: FND_MESSAGE.SET_NAME('ALR', 'TRIGGER-NO TABLE IN ACCOUNT');
1041: -- this message is uppercased in fnd_new_messages and fnd_messages
1042: FND_MESSAGE.SET_TOKEN('TABLE_NAME', TBL_NAME);
1043: FND_MESSAGE.SET_TOKEN('ORACLE_USERNAME',
1044: alr_dbtrigger.BAD_ORACLE_USERNAMES, FALSE);
1045: APP_EXCEPTION.RAISE_EXCEPTION;
1046:
1047: when ERROR_ROLLBACK then

Line 1050: FND_MESSAGE.SET_NAME('FND', 'SQL-Generic error');

1046:
1047: when ERROR_ROLLBACK then
1048:
1049: -- Save the error code/msg first
1050: FND_MESSAGE.SET_NAME('FND', 'SQL-Generic error');
1051: FND_MESSAGE.SET_TOKEN('ERRNO', SQLCODE, FALSE);
1052: FND_MESSAGE.SET_TOKEN('REASON', SQLERRM, FALSE);
1053: FND_MESSAGE.SET_TOKEN(
1054: 'ROUTINE', 'CREATE_EVENT_DB_TRIGGER', FALSE);

Line 1051: FND_MESSAGE.SET_TOKEN('ERRNO', SQLCODE, FALSE);

1047: when ERROR_ROLLBACK then
1048:
1049: -- Save the error code/msg first
1050: FND_MESSAGE.SET_NAME('FND', 'SQL-Generic error');
1051: FND_MESSAGE.SET_TOKEN('ERRNO', SQLCODE, FALSE);
1052: FND_MESSAGE.SET_TOKEN('REASON', SQLERRM, FALSE);
1053: FND_MESSAGE.SET_TOKEN(
1054: 'ROUTINE', 'CREATE_EVENT_DB_TRIGGER', FALSE);
1055:

Line 1052: FND_MESSAGE.SET_TOKEN('REASON', SQLERRM, FALSE);

1048:
1049: -- Save the error code/msg first
1050: FND_MESSAGE.SET_NAME('FND', 'SQL-Generic error');
1051: FND_MESSAGE.SET_TOKEN('ERRNO', SQLCODE, FALSE);
1052: FND_MESSAGE.SET_TOKEN('REASON', SQLERRM, FALSE);
1053: FND_MESSAGE.SET_TOKEN(
1054: 'ROUTINE', 'CREATE_EVENT_DB_TRIGGER', FALSE);
1055:
1056: -- "Rollback"

Line 1053: FND_MESSAGE.SET_TOKEN(

1049: -- Save the error code/msg first
1050: FND_MESSAGE.SET_NAME('FND', 'SQL-Generic error');
1051: FND_MESSAGE.SET_TOKEN('ERRNO', SQLCODE, FALSE);
1052: FND_MESSAGE.SET_TOKEN('REASON', SQLERRM, FALSE);
1053: FND_MESSAGE.SET_TOKEN(
1054: 'ROUTINE', 'CREATE_EVENT_DB_TRIGGER', FALSE);
1055:
1056: -- "Rollback"
1057: for I in 1 .. alr_dbtrigger.NUMBER_OF_TRIGGERS loop

Line 1069: FND_MESSAGE.SET_NAME('FND', 'SQL-Generic error');

1065: APP_EXCEPTION.RAISE_EXCEPTION;
1066:
1067: when others then
1068:
1069: FND_MESSAGE.SET_NAME('FND', 'SQL-Generic error');
1070: FND_MESSAGE.SET_TOKEN('ERRNO', SQLCODE, FALSE);
1071: FND_MESSAGE.SET_TOKEN('REASON', SQLERRM, FALSE);
1072: FND_MESSAGE.SET_TOKEN(
1073: 'ROUTINE', 'CREATE_EVENT_DB_TRIGGER', FALSE);

Line 1070: FND_MESSAGE.SET_TOKEN('ERRNO', SQLCODE, FALSE);

1066:
1067: when others then
1068:
1069: FND_MESSAGE.SET_NAME('FND', 'SQL-Generic error');
1070: FND_MESSAGE.SET_TOKEN('ERRNO', SQLCODE, FALSE);
1071: FND_MESSAGE.SET_TOKEN('REASON', SQLERRM, FALSE);
1072: FND_MESSAGE.SET_TOKEN(
1073: 'ROUTINE', 'CREATE_EVENT_DB_TRIGGER', FALSE);
1074: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1071: FND_MESSAGE.SET_TOKEN('REASON', SQLERRM, FALSE);

1067: when others then
1068:
1069: FND_MESSAGE.SET_NAME('FND', 'SQL-Generic error');
1070: FND_MESSAGE.SET_TOKEN('ERRNO', SQLCODE, FALSE);
1071: FND_MESSAGE.SET_TOKEN('REASON', SQLERRM, FALSE);
1072: FND_MESSAGE.SET_TOKEN(
1073: 'ROUTINE', 'CREATE_EVENT_DB_TRIGGER', FALSE);
1074: APP_EXCEPTION.RAISE_EXCEPTION;
1075:

Line 1072: FND_MESSAGE.SET_TOKEN(

1068:
1069: FND_MESSAGE.SET_NAME('FND', 'SQL-Generic error');
1070: FND_MESSAGE.SET_TOKEN('ERRNO', SQLCODE, FALSE);
1071: FND_MESSAGE.SET_TOKEN('REASON', SQLERRM, FALSE);
1072: FND_MESSAGE.SET_TOKEN(
1073: 'ROUTINE', 'CREATE_EVENT_DB_TRIGGER', FALSE);
1074: APP_EXCEPTION.RAISE_EXCEPTION;
1075:
1076: end CREATE_EVENT_DB_TRIGGER;

Line 1139: FND_MESSAGE.SET_NAME('FND', 'SQL-Generic error');

1135:
1136: exception
1137: when others then
1138: if sql%found then
1139: FND_MESSAGE.SET_NAME('FND', 'SQL-Generic error');
1140: FND_MESSAGE.SET_TOKEN('ERRNO', SQLCODE, FALSE);
1141: FND_MESSAGE.SET_TOKEN('REASON', SQLERRM, FALSE);
1142: FND_MESSAGE.SET_TOKEN(
1143: 'ROUTINE', 'DELETE_EVENT_DB_TRIGGER', FALSE);

Line 1140: FND_MESSAGE.SET_TOKEN('ERRNO', SQLCODE, FALSE);

1136: exception
1137: when others then
1138: if sql%found then
1139: FND_MESSAGE.SET_NAME('FND', 'SQL-Generic error');
1140: FND_MESSAGE.SET_TOKEN('ERRNO', SQLCODE, FALSE);
1141: FND_MESSAGE.SET_TOKEN('REASON', SQLERRM, FALSE);
1142: FND_MESSAGE.SET_TOKEN(
1143: 'ROUTINE', 'DELETE_EVENT_DB_TRIGGER', FALSE);
1144: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1141: FND_MESSAGE.SET_TOKEN('REASON', SQLERRM, FALSE);

1137: when others then
1138: if sql%found then
1139: FND_MESSAGE.SET_NAME('FND', 'SQL-Generic error');
1140: FND_MESSAGE.SET_TOKEN('ERRNO', SQLCODE, FALSE);
1141: FND_MESSAGE.SET_TOKEN('REASON', SQLERRM, FALSE);
1142: FND_MESSAGE.SET_TOKEN(
1143: 'ROUTINE', 'DELETE_EVENT_DB_TRIGGER', FALSE);
1144: APP_EXCEPTION.RAISE_EXCEPTION;
1145: end if;

Line 1142: FND_MESSAGE.SET_TOKEN(

1138: if sql%found then
1139: FND_MESSAGE.SET_NAME('FND', 'SQL-Generic error');
1140: FND_MESSAGE.SET_TOKEN('ERRNO', SQLCODE, FALSE);
1141: FND_MESSAGE.SET_TOKEN('REASON', SQLERRM, FALSE);
1142: FND_MESSAGE.SET_TOKEN(
1143: 'ROUTINE', 'DELETE_EVENT_DB_TRIGGER', FALSE);
1144: APP_EXCEPTION.RAISE_EXCEPTION;
1145: end if;
1146: end;

Line 1198: FND_MESSAGE.SET_NAME('FND', 'SQL-Generic error');

1194:
1195: exception
1196: when others then
1197: if sql%found then
1198: FND_MESSAGE.SET_NAME('FND', 'SQL-Generic error');
1199: FND_MESSAGE.SET_TOKEN('ERRNO', SQLCODE, FALSE);
1200: FND_MESSAGE.SET_TOKEN('REASON', SQLERRM, FALSE);
1201: FND_MESSAGE.SET_TOKEN(
1202: 'ROUTINE', 'PRE_UPDATE_EVENT_ALERT', FALSE);

Line 1199: FND_MESSAGE.SET_TOKEN('ERRNO', SQLCODE, FALSE);

1195: exception
1196: when others then
1197: if sql%found then
1198: FND_MESSAGE.SET_NAME('FND', 'SQL-Generic error');
1199: FND_MESSAGE.SET_TOKEN('ERRNO', SQLCODE, FALSE);
1200: FND_MESSAGE.SET_TOKEN('REASON', SQLERRM, FALSE);
1201: FND_MESSAGE.SET_TOKEN(
1202: 'ROUTINE', 'PRE_UPDATE_EVENT_ALERT', FALSE);
1203: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1200: FND_MESSAGE.SET_TOKEN('REASON', SQLERRM, FALSE);

1196: when others then
1197: if sql%found then
1198: FND_MESSAGE.SET_NAME('FND', 'SQL-Generic error');
1199: FND_MESSAGE.SET_TOKEN('ERRNO', SQLCODE, FALSE);
1200: FND_MESSAGE.SET_TOKEN('REASON', SQLERRM, FALSE);
1201: FND_MESSAGE.SET_TOKEN(
1202: 'ROUTINE', 'PRE_UPDATE_EVENT_ALERT', FALSE);
1203: APP_EXCEPTION.RAISE_EXCEPTION;
1204: end if;

Line 1201: FND_MESSAGE.SET_TOKEN(

1197: if sql%found then
1198: FND_MESSAGE.SET_NAME('FND', 'SQL-Generic error');
1199: FND_MESSAGE.SET_TOKEN('ERRNO', SQLCODE, FALSE);
1200: FND_MESSAGE.SET_TOKEN('REASON', SQLERRM, FALSE);
1201: FND_MESSAGE.SET_TOKEN(
1202: 'ROUTINE', 'PRE_UPDATE_EVENT_ALERT', FALSE);
1203: APP_EXCEPTION.RAISE_EXCEPTION;
1204: end if;
1205: end;

Line 1255: FND_MESSAGE.CLEAR;

1251: end if;
1252:
1253: if IS_NONEXISTENT_TABLE then
1254: if NEW_TABLE_NAME = OLD_TBLNM then
1255: FND_MESSAGE.CLEAR;
1256: else
1257: APP_EXCEPTION.RAISE_EXCEPTION;
1258: end if;
1259: end if;