APPS.IGS_PE_CRS_GRP_EXCL_PKG dependencies on APP_EXCEPTION

Line 46: App_Exception.Raise_Exception;

42: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
43: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
44: IGS_GE_MSG_STACK.ADD;
45: Close cur_old_ref_values;
46: App_Exception.Raise_Exception;
47: Return;
48: END IF;
49: Close cur_old_ref_values;
50:

Line 92: App_Exception.Raise_Exception;

88: new_references.pcge_start_dt,
89: v_message_name) = FALSE THEN
90: Fnd_Message.Set_Name('IGS', v_message_name);
91: IGS_GE_MSG_STACK.ADD;
92: App_Exception.Raise_Exception;
93: END IF;
94: END IF;
95: END IF;
96: -- Validate that start date is not less than the parent IGS_PE_PERSON

Line 105: App_Exception.Raise_Exception;

101: new_references.pcge_start_dt,
102: v_message_name) = FALSE THEN
103: Fnd_Message.Set_Name('IGS', v_message_name);
104: IGS_GE_MSG_STACK.ADD;
105: App_Exception.Raise_Exception;
106: END IF;
107: END IF;
108: -- Validate that if expiry date is specified, then expiry date is not
109: -- less than the start date.

Line 121: App_Exception.Raise_Exception;

117: new_references.expiry_dt,
118: v_message_name) = FALSE THEN
119: Fnd_Message.Set_Name('IGS', v_message_name);
120: IGS_GE_MSG_STACK.ADD;
121: App_Exception.Raise_Exception;
122: END IF;
123: IF IGS_EN_VAL_PCE.enrp_val_encmb_dt (
124: new_references.expiry_dt,
125: v_message_name) = FALSE THEN

Line 128: App_Exception.Raise_Exception;

124: new_references.expiry_dt,
125: v_message_name) = FALSE THEN
126: Fnd_Message.Set_Name('IGS', v_message_name);
127: IGS_GE_MSG_STACK.ADD;
128: App_Exception.Raise_Exception;
129: END IF;
130: END IF;
131: END IF;
132: -- Validate that records for this table can be created for the encumbrance

Line 141: App_Exception.Raise_Exception;

137: 'IGS_PE_CRS_GRP_EXCL',
138: v_message_name) = FALSE THEN
139: Fnd_Message.Set_Name('IGS', v_message_name);
140: IGS_GE_MSG_STACK.ADD;
141: App_Exception.Raise_Exception;
142: END IF;
143: END IF;
144:
145:

Line 176: App_Exception.Raise_Exception;

172: new_references.pcge_start_dt,
173: v_message_name) = FALSE THEN
174: Fnd_Message.Set_Name('IGS', v_message_name);
175: IGS_GE_MSG_STACK.ADD;
176: App_Exception.Raise_Exception;
177: END IF;
178:
179:
180: v_rowid_saved := TRUE;

Line 214: App_Exception.Raise_Exception;

210: column_name is null Then
211: IF new_references.course_group_cd <> UPPER(new_references.course_group_cd) Then
212: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
213: IGS_GE_MSG_STACK.ADD;
214: App_Exception.Raise_Exception;
215: END IF;
216: END IF;
217:
218: IF upper(column_name) = 'ENCUMBRANCE_TYPE' OR

Line 224: App_Exception.Raise_Exception;

220: IF new_references.encumbrance_type <>
221: UPPER(new_references.encumbrance_type) Then
222: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
223: IGS_GE_MSG_STACK.ADD;
224: App_Exception.Raise_Exception;
225: END IF;
226: END IF;
227: IF upper(column_name) = 'S_ENCMB_EFFECT_TYPE' OR
228: column_name is null Then

Line 233: App_Exception.Raise_Exception;

229: IF new_references.s_encmb_effect_type<>
230: UPPER(new_references.s_encmb_effect_type) Then
231: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
232: IGS_GE_MSG_STACK.ADD;
233: App_Exception.Raise_Exception;
234: END IF;
235: END IF;
236:
237:

Line 255: App_Exception.Raise_Exception;

251: new_references.course_group_cd
252: ) THEN
253: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
254: IGS_GE_MSG_STACK.ADD;
255: App_Exception.Raise_Exception;
256: END IF;
257: END IF;
258:
259: IF (((old_references.person_id = new_references.person_id) AND

Line 282: App_Exception.Raise_Exception;

278: new_references.pee_start_dt,
279: new_references.pee_sequence_number ) THEN
280: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
281: IGS_GE_MSG_STACK.ADD;
282: App_Exception.Raise_Exception;
283: END IF;
284: END IF;
285:
286: END Check_Parent_Existance;

Line 356: App_Exception.Raise_Exception;

352: IF (cur_rowid%FOUND) THEN
353: Fnd_Message.Set_Name ('IGS', 'IGS_PE_PCGE_PEE_FK');
354: IGS_GE_MSG_STACK.ADD;
355: Close cur_rowid;
356: App_Exception.Raise_Exception;
357: Return;
358: END IF;
359: Close cur_rowid;
360:

Line 416: App_Exception.Raise_Exception;

412: new_references.course_group_cd,
413: new_references.pcge_start_dt) THEN
414: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
415: IGS_GE_MSG_STACK.ADD;
416: App_Exception.Raise_Exception;
417: END IF;
418:
419: Check_Constraints; -- if procedure present
420: Check_Parent_Existance; -- if procedure present

Line 444: App_Exception.Raise_Exception;

440: new_references.course_group_cd,
441: new_references.pcge_start_dt) THEN
442: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
443: IGS_GE_MSG_STACK.ADD;
444: App_Exception.Raise_Exception;
445: END IF;
446: Check_Constraints; -- if procedure present
447:
448:

Line 522: app_exception.raise_exception;

518: end if;
519: else
520: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
521: IGS_GE_MSG_STACK.ADD;
522: app_exception.raise_exception;
523: end if;
524:
525: Before_DML(
526: p_action=>'INSERT',

Line 615: App_Exception.Raise_Exception;

611: if (c1%notfound) then
612: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
613:
614: close c1;
615: App_Exception.Raise_Exception;
616: return;
617: end if;
618: close c1;
619:

Line 627: app_exception.raise_exception;

623: ) then
624: null;
625: else
626: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
627: app_exception.raise_exception;
628: end if;
629: return;
630: end LOCK_ROW;
631:

Line 665: app_exception.raise_exception;

661: end if;
662: else
663: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
664: IGS_GE_MSG_STACK.ADD;
665: app_exception.raise_exception;
666: end if;
667: Before_DML(
668: p_action=>'UPDATE',
669: x_rowid=>X_ROWID,