DBA Data[Home] [Help]

APPS.IGS_FI_PERSON_HOLDS_PKG dependencies on IGS_GE_MSG_STACK

Line 57: igs_ge_msg_stack.add;

53: FETCH cur_old_ref_values INTO old_references;
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;

Line 116: igs_ge_msg_stack.add;

112: ELSIF NOT igs_pe_person_pkg.get_pk_for_validation (
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

Line 127: igs_ge_msg_stack.add;

123: ELSIF NOT igs_fi_hold_plan_pkg.get_pk_for_validation (
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

Line 138: igs_ge_msg_stack.add;

134: ELSIF NOT igs_fi_encmb_type_pkg.get_pk_for_validation (
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

Line 152: igs_ge_msg_stack.add;

148: new_references.fee_cal_type,
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

Line 163: igs_ge_msg_stack.add;

159: ELSIF NOT igs_fi_credits_pkg.get_pk_for_validation (
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;

Line 234: igs_ge_msg_stack.add;

230: FETCH cur_rowid INTO lv_rowid;
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;

Line 269: igs_ge_msg_stack.add;

265: FETCH cur_rowid INTO lv_rowid;
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;

Line 304: igs_ge_msg_stack.add;

300: FETCH cur_rowid INTO lv_rowid;
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;

Line 341: igs_ge_msg_stack.add;

337: FETCH cur_rowid INTO lv_rowid;
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;

Line 355: IGS_GE_MSG_STACK.ADD;

351: BEGIN
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;

Line 433: igs_ge_msg_stack.add;

429: new_references.hold_start_dt
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

Line 450: igs_ge_msg_stack.add;

446: new_references.hold_start_dt
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:

Line 529: igs_ge_msg_stack.add;

525: x_program_update_date := SYSDATE;
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(

Line 669: igs_ge_msg_stack.add;

665: OPEN c1;
666: FETCH c1 INTO tlinfo;
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;

Line 692: igs_ge_msg_stack.add;

688: ) THEN
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;

Line 753: igs_ge_msg_stack.add;

749: x_last_update_login := -1;
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(