DBA Data[Home] [Help]

APPS.IGS_UC_DEFAULTS_PKG dependencies on APP_EXCEPTION

Line 66: app_exception.raise_exception;

62: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
63: CLOSE cur_old_ref_values;
64: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
65: igs_ge_msg_stack.add;
66: app_exception.raise_exception;
67: RETURN;
68: END IF;
69: CLOSE cur_old_ref_values;
70:

Line 129: App_Exception.Raise_Exception;

125: ELSE
126: IF NOT IGS_AD_OU_STAT_PKG.Get_PK_For_Validation ( new_references.obsolete_outcome_status , 'N' ) THEN
127: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
128: IGS_GE_MSG_STACK.ADD;
129: App_Exception.Raise_Exception;
130: END IF;
131: END IF;
132:
133:

Line 141: App_Exception.Raise_Exception;

137: ELSE
138: IF NOT IGS_AD_OU_STAT_PKG.Get_PK_For_Validation (new_references.pending_outcome_status , 'N' ) THEN
139: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
140: IGS_GE_MSG_STACK.ADD;
141: App_Exception.Raise_Exception;
142: END IF;
143: END IF;
144:
145:

Line 153: App_Exception.Raise_Exception;

149: ELSE
150: IF NOT IGS_AD_OU_STAT_PKG.Get_PK_For_Validation (new_references.rejected_outcome_status , 'N') THEN
151: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
152: IGS_GE_MSG_STACK.ADD;
153: App_Exception.Raise_Exception;
154: END IF;
155:
156: END IF;
157:

Line 167: App_Exception.Raise_Exception;

163: ELSE
164: IF NOT IGS_AD_CODE_CLASSES_PKG.Get_PK_For_Validation (new_references.decision_reason_id, 'N' ) THEN
165: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
166: IGS_GE_MSG_STACK.ADD;
167: App_Exception.Raise_Exception;
168: END IF;
169:
170: END IF;
171:

Line 181: App_Exception.Raise_Exception;

177: ELSE
178: IF NOT IGS_AD_SS_APPL_TYP_PKG.get_pk_for_validation ( new_references.application_type, 'N') THEN
179: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
180: IGS_GE_MSG_STACK.ADD;
181: App_Exception.Raise_Exception;
182: END IF;
183:
184: END IF;
185:

Line 193: App_Exception.Raise_Exception;

189: ELSE
190: IF NOT IGS_PE_PERSON_ID_TYP_PKG.Get_PK_For_Validation (new_references.ni_number_alt_pers_type ) THEN
191: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
192: IGS_GE_MSG_STACK.ADD;
193: App_Exception.Raise_Exception;
194: END IF;
195:
196: END IF;
197:

Line 234: App_Exception.Raise_Exception;

230: IF (cur_rowid1%FOUND) THEN
231: Close cur_rowid1;
232: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AOS_UCDF_FK1');
233: IGS_GE_MSG_STACK.ADD;
234: App_Exception.Raise_Exception;
235: Return;
236: END IF;
237: Close cur_rowid1;
238:

Line 245: App_Exception.Raise_Exception;

241: IF (cur_rowid2%FOUND) THEN
242: Close cur_rowid2;
243: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AOS_UCDF_FK2');
244: IGS_GE_MSG_STACK.ADD;
245: App_Exception.Raise_Exception;
246: Return;
247: END IF;
248: Close cur_rowid2;
249:

Line 257: App_Exception.Raise_Exception;

253: IF (cur_rowid3%FOUND) THEN
254: Close cur_rowid3;
255: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AOS_UCDF_FK3');
256: IGS_GE_MSG_STACK.ADD;
257: App_Exception.Raise_Exception;
258: Return;
259: END IF;
260: Close cur_rowid3;
261:

Line 285: App_Exception.Raise_Exception;

281: IF (cur_rowid%FOUND) THEN
282: Close cur_rowid;
283: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ADCC_UCDF_FK');
284: IGS_GE_MSG_STACK.ADD;
285: App_Exception.Raise_Exception;
286: Return;
287: END IF;
288: Close cur_rowid;
289:

Line 312: App_Exception.Raise_Exception;

308: IF (cur_rowid%FOUND) THEN
309: Close cur_rowid;
310: Fnd_Message.Set_Name ('IGS', 'IGS_UC_UCDF_SSAT_FK');
311: IGS_GE_MSG_STACK.ADD;
312: App_Exception.Raise_Exception;
313: Return;
314: END IF;
315: Close cur_rowid;
316:

Line 435: app_exception.raise_exception;

431: )
432: ) THEN
433: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
434: igs_ge_msg_stack.add;
435: app_exception.raise_exception;
436: END IF;
437: Check_Parent_Existance;
438:
439: ELSIF (p_action = 'VALIDATE_INSERT') THEN

Line 446: app_exception.raise_exception;

442: )
443: ) THEN
444: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
445: igs_ge_msg_stack.add;
446: app_exception.raise_exception;
447: END IF;
448:
449: END IF;
450:

Line 516: app_exception.raise_exception;

512: END IF;
513: ELSE
514: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
515: igs_ge_msg_stack.add;
516: app_exception.raise_exception;
517: END IF;
518:
519: before_dml(
520: p_action => 'INSERT',

Line 687: app_exception.raise_exception;

683: IF (c1%notfound) THEN
684: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
685: igs_ge_msg_stack.add;
686: CLOSE c1;
687: app_exception.raise_exception;
688: RETURN;
689: END IF;
690: CLOSE c1;
691:

Line 720: app_exception.raise_exception;

716: NULL;
717: ELSE
718: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
719: igs_ge_msg_stack.add;
720: app_exception.raise_exception;
721: END IF;
722:
723: RETURN;
724:

Line 786: app_exception.raise_exception;

782: END IF;
783: ELSE
784: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
785: igs_ge_msg_stack.add;
786: app_exception.raise_exception;
787: END IF;
788:
789: before_dml(
790: p_action => 'UPDATE',