APPS.ALR_DBTRIGGER dependencies on APP_EXCEPTION

Line 156: APP_EXCEPTION.RAISE_EXCEPTION;

152:
153: exception
154: when others then
155: -- Need to provide an error message here.
156: APP_EXCEPTION.RAISE_EXCEPTION;
157:
158: end;
159: end if; -- APPLSYS_SCHEMA
160:

Line 178: APP_EXCEPTION.RAISE_EXCEPTION;

174:
175: exception
176: when others then
177: -- Need to provide an error message here.
178: APP_EXCEPTION.RAISE_EXCEPTION;
179:
180: end;
181: end if; -- TARGET_APPL_ID
182:

Line 201: APP_EXCEPTION.RAISE_EXCEPTION;

197:
198: exception
199: when others then
200: -- Need to provide an error message here.
201: APP_EXCEPTION.RAISE_EXCEPTION;
202:
203: end;
204: end if;
205:

Line 366: APP_EXCEPTION.RAISE_EXCEPTION;

362: elsif ROOT_STMT = 'drop' then
363: STMT_TYPE := ad_ddl.drop_trigger;
364: else
365: -- Need to provide an error message here.
366: APP_EXCEPTION.RAISE_EXCEPTION;
367: end if;
368:
369:
370: /* ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Line 622: APP_EXCEPTION.RAISE_EXCEPTION;

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;
625:
626:

Line 1042: APP_EXCEPTION.RAISE_EXCEPTION;

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
1045:
1046: -- Save the error code/msg first

Line 1062: APP_EXCEPTION.RAISE_EXCEPTION;

1058: -- Note that table appl is the same even when
1059: -- dropping trigger off different accounts.
1060: end loop;
1061:
1062: APP_EXCEPTION.RAISE_EXCEPTION;
1063:
1064: when others then
1065:
1066: FND_MESSAGE.SET_NAME('FND', 'SQL-Generic error');

Line 1071: APP_EXCEPTION.RAISE_EXCEPTION;

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;
1074:
1075:

Line 1141: APP_EXCEPTION.RAISE_EXCEPTION;

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;
1144:
1145: if sql%found then

Line 1200: APP_EXCEPTION.RAISE_EXCEPTION;

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;
1203:
1204: begin

Line 1254: APP_EXCEPTION.RAISE_EXCEPTION;

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;
1257:
1258: ALR_DEBUG('<<--- Leaving PRE_UPDATE_EVENT_ALERT');