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 1045: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 1065: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 1074: APP_EXCEPTION.RAISE_EXCEPTION;

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;
1077:
1078:

Line 1144: APP_EXCEPTION.RAISE_EXCEPTION;

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;
1147:
1148: if sql%found then

Line 1203: APP_EXCEPTION.RAISE_EXCEPTION;

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;
1206:
1207: begin

Line 1257: APP_EXCEPTION.RAISE_EXCEPTION;

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