DBA Data[Home] [Help]

APPS.IGS_AD_APCTR_RU_PKG dependencies on APP_EXCEPTION

Line 49: app_exception.raise_exception;

45: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
46: CLOSE cur_old_ref_values;
47: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
48: igs_ge_msg_stack.add;
49: app_exception.raise_exception;
50: RETURN;
51: END IF;
52: CLOSE cur_old_ref_values;
53:

Line 88: App_Exception.Raise_Exception;

84: new_references.s_admission_process_type
85: ) THEN
86: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
87: IGS_GE_MSG_STACK.ADD;
88: App_Exception.Raise_Exception;
89: END IF;
90: END IF;
91:
92: IF (((old_references.s_rule_call_cd = new_references.s_rule_call_cd)) OR

Line 102: App_Exception.Raise_Exception;

98: new_references.s_rule_call_cd
99: ) THEN
100: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
101: IGS_GE_MSG_STACK.ADD;
102: App_Exception.Raise_Exception;
103: END IF;
104: END IF;
105:
106: IF (((old_references.admission_cat = new_references.admission_cat)) OR

Line 116: App_Exception.Raise_Exception;

112: 'N'
113: ) THEN
114: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
115: IGS_GE_MSG_STACK.ADD;
116: App_Exception.Raise_Exception;
117: END IF;
118: END IF;
119:
120: IF (((old_references.rul_sequence_number = new_references.rul_sequence_number)) OR

Line 129: App_Exception.Raise_Exception;

125: new_references.rul_sequence_number
126: ) 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: END Check_Parent_Existance;

Line 154: App_Exception.Raise_Exception;

150: IF (cur_rowid%FOUND) THEN
151: Close cur_rowid;
152: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ATR_AC_FK');
153: IGS_GE_MSG_STACK.ADD;
154: App_Exception.Raise_Exception;
155: Return;
156: END IF;
157: Close cur_rowid;
158:

Line 180: App_Exception.Raise_Exception;

176: IF (cur_rowid%FOUND) THEN
177: Close cur_rowid;
178: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ATR_RU_FK');
179: IGS_GE_MSG_STACK.ADD;
180: App_Exception.Raise_Exception;
181: Return;
182: END IF;
183: Close cur_rowid;
184:

Line 271: app_exception.raise_exception;

267: )
268: ) THEN
269: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
270: igs_ge_msg_stack.add;
271: app_exception.raise_exception;
272: END IF;
273: Check_Parent_Existance;
274: ELSIF (p_action = 'UPDATE') THEN
275: Check_Parent_Existance;

Line 284: app_exception.raise_exception;

280: )
281: ) THEN
282: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
283: igs_ge_msg_stack.add;
284: app_exception.raise_exception;
285: END IF;
286: END IF;
287: END before_dml;
288:

Line 335: app_exception.raise_exception;

331: END IF;
332: ELSE
333: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
334: igs_ge_msg_stack.add;
335: app_exception.raise_exception;
336: END IF;
337:
338: new_references.org_id := igs_ge_gen_003.get_org_id;
339:

Line 430: app_exception.raise_exception;

426: IF (c1%notfound) THEN
427: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
428: igs_ge_msg_stack.add;
429: CLOSE c1;
430: app_exception.raise_exception;
431: RETURN;
432: END IF;
433: CLOSE c1;
434:

Line 445: app_exception.raise_exception;

441: NULL;
442: ELSE
443: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
444: igs_ge_msg_stack.add;
445: app_exception.raise_exception;
446: END IF;
447:
448: RETURN;
449:

Line 493: app_exception.raise_exception;

489: END IF;
490: ELSE
491: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
492: igs_ge_msg_stack.add;
493: app_exception.raise_exception;
494: END IF;
495:
496: before_dml(
497: p_action => 'UPDATE',