DBA Data[Home] [Help]

APPS.IGS_FI_PERSON_HOLDS_PKG dependencies on APP_EXCEPTION

Line 58: app_exception.raise_exception;

54: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
55: CLOSE cur_old_ref_values;
56: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
57: igs_ge_msg_stack.add;
58: app_exception.raise_exception;
59: RETURN;
60: END IF;
61: CLOSE cur_old_ref_values;
62:

Line 117: app_exception.raise_exception;

113: new_references.person_id
114: ) THEN
115: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
116: igs_ge_msg_stack.add;
117: app_exception.raise_exception;
118: END IF;
119:
120: IF (((old_references.hold_plan_name = new_references.hold_plan_name)) OR
121: ((new_references.hold_plan_name IS NULL))) THEN

Line 128: app_exception.raise_exception;

124: new_references.hold_plan_name
125: ) THEN
126: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
127: igs_ge_msg_stack.add;
128: app_exception.raise_exception;
129: END IF;
130:
131: IF (((old_references.hold_type = new_references.hold_type)) OR
132: ((new_references.hold_type IS NULL))) THEN

Line 139: app_exception.raise_exception;

135: new_references.hold_type
136: ) THEN
137: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
138: igs_ge_msg_stack.add;
139: app_exception.raise_exception;
140: END IF;
141:
142: IF (((old_references.fee_cal_type = new_references.fee_cal_type) AND
143: (old_references.fee_ci_sequence_number = new_references.fee_ci_sequence_number)) OR

Line 153: app_exception.raise_exception;

149: new_references.fee_ci_sequence_number
150: ) 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: IF (((old_references.release_credit_id = new_references.release_credit_id)) OR
157: ((new_references.release_credit_id IS NULL))) THEN

Line 164: app_exception.raise_exception;

160: new_references.release_credit_id
161: ) THEN
162: fnd_message.set_name ('FND','FORM_RECORD_DELETED');
163: igs_ge_msg_stack.add;
164: app_exception.raise_exception;
165: END IF;
166:
167: END check_parent_existance;
168:

Line 235: app_exception.raise_exception;

231: IF (cur_rowid%FOUND) THEN
232: CLOSE cur_rowid;
233: fnd_message.set_name ('IGS', 'IGS_FI_FPHL_FIHP_FK');
234: igs_ge_msg_stack.add;
235: app_exception.raise_exception;
236: RETURN;
237: END IF;
238: CLOSE cur_rowid;
239:

Line 270: app_exception.raise_exception;

266: IF (cur_rowid%FOUND) THEN
267: CLOSE cur_rowid;
268: fnd_message.set_name ('IGS', 'IGS_FI_FPHL_ET_FK');
269: igs_ge_msg_stack.add;
270: app_exception.raise_exception;
271: RETURN;
272: END IF;
273: CLOSE cur_rowid;
274:

Line 305: app_exception.raise_exception;

301: IF (cur_rowid%FOUND) THEN
302: CLOSE cur_rowid;
303: fnd_message.set_name ('IGS', 'IGS_FI_FPHL_CRDT_FK');
304: igs_ge_msg_stack.add;
305: app_exception.raise_exception;
306: RETURN;
307: END IF;
308: CLOSE cur_rowid;
309:

Line 342: app_exception.raise_exception;

338: IF (cur_rowid%FOUND) THEN
339: CLOSE cur_rowid;
340: fnd_message.set_name ('IGS', 'IGS_FI_FPHL_CI_FK');
341: igs_ge_msg_stack.add;
342: app_exception.raise_exception;
343: RETURN;
344: END IF;
345: CLOSE cur_rowid;
346:

Line 356: App_Exception.Raise_Exception;

352: IF ( p_inserting = TRUE OR (p_updating = TRUE AND new_references.hold_type <> old_references.hold_type) ) THEN
353: IF NOT igs_en_val_etde.enrp_val_et_closed(new_references.hold_type,p_message_name) THEN
354: Fnd_Message.Set_Name('IGS', p_message_name);
355: IGS_GE_MSG_STACK.ADD;
356: App_Exception.Raise_Exception;
357: END IF;
358: END IF;
359: END BeforeInsertUpdate;
360:

Line 434: app_exception.raise_exception;

430: )
431: ) THEN
432: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
433: igs_ge_msg_stack.add;
434: app_exception.raise_exception;
435: END IF;
436: check_parent_existance;
437: ELSIF (p_action = 'UPDATE') THEN
438: BeforeInsertUpdate(FALSE,TRUE);

Line 451: app_exception.raise_exception;

447: )
448: ) THEN
449: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
450: igs_ge_msg_stack.add;
451: app_exception.raise_exception;
452: END IF;
453: END IF;
454:
455: END before_dml;

Line 530: app_exception.raise_exception;

526: END IF;
527: ELSE
528: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
529: igs_ge_msg_stack.add;
530: app_exception.raise_exception;
531: END IF;
532:
533: before_dml(
534: p_action => 'INSERT',

Line 671: app_exception.raise_exception;

667: IF (c1%notfound) THEN
668: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
669: igs_ge_msg_stack.add;
670: CLOSE c1;
671: app_exception.raise_exception;
672: RETURN;
673: END IF;
674: CLOSE c1;
675:

Line 693: app_exception.raise_exception;

689: NULL;
690: ELSE
691: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
692: igs_ge_msg_stack.add;
693: app_exception.raise_exception;
694: END IF;
695:
696: RETURN;
697:

Line 754: app_exception.raise_exception;

750: END IF;
751: ELSE
752: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
753: igs_ge_msg_stack.add;
754: app_exception.raise_exception;
755: END IF;
756:
757: before_dml(
758: p_action => 'UPDATE',