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 878: 'raise_application_error(-20160, FND_MESSAGE.GET);' ||

874: TBLNM || ''',rowidtochar(:new.rowid)' ||
875: ',''' || event_mode || ''',mailid,ORGID);' ||
876:
877: 'if REQID=0 then ' ||
878: 'raise_application_error(-20160, FND_MESSAGE.GET);' ||
879: 'end if;' ||
880:
881: 'end if;' ||
882:

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

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

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

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

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

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

Line 1040: FND_MESSAGE.SET_TOKEN('ORACLE_USERNAME',

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

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

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

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

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

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

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

Line 1050: FND_MESSAGE.SET_TOKEN(

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

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

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

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

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

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

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

Line 1069: FND_MESSAGE.SET_TOKEN(

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

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

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

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

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

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

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

Line 1139: FND_MESSAGE.SET_TOKEN(

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

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

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

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

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

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

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

Line 1198: FND_MESSAGE.SET_TOKEN(

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

Line 1252: FND_MESSAGE.CLEAR;

1248: end if;
1249:
1250: if IS_NONEXISTENT_TABLE then
1251: if NEW_TABLE_NAME = OLD_TBLNM then
1252: FND_MESSAGE.CLEAR;
1253: else
1254: APP_EXCEPTION.RAISE_EXCEPTION;
1255: end if;
1256: end if;