DBA Data[Home] [Help]

APPS.IGS_HE_POOUS_ALL_PKG dependencies on IGS_GE_MSG_STACK

Line 87: igs_ge_msg_stack.add;

83: FETCH cur_old_ref_values INTO old_references;
84: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
85: CLOSE cur_old_ref_values;
86: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
87: igs_ge_msg_stack.add;
88: app_exception.raise_exception;
89: RETURN;
90: END IF;
91: CLOSE cur_old_ref_values;

Line 171: igs_ge_msg_stack.add;

167: new_references.us_version_number
168: )
169: ) THEN
170: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
171: igs_ge_msg_stack.add;
172: app_exception.raise_exception;
173: END IF;
174:
175: END check_uniqueness;

Line 238: igs_ge_msg_stack.add;

234: new_references.attendance_mode,
235: new_references.attendance_type
236: ) THEN
237: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
238: igs_ge_msg_stack.add;
239: app_exception.raise_exception;
240: END IF;
241:
242: IF (((old_references.unit_set_cd = new_references.unit_set_cd) AND

Line 252: igs_ge_msg_stack.add;

248: new_references.unit_set_cd,
249: new_references.us_version_number
250: ) THEN
251: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
252: igs_ge_msg_stack.add;
253: app_exception.raise_exception;
254: END IF;
255:
256: -- smaddali added parent check for funding_source field

Line 264: igs_ge_msg_stack.add;

260: ELSIF NOT igs_fi_fund_src_pkg.get_pk_for_validation (
261: new_references.funding_source
262: ) THEN
263: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
264: igs_ge_msg_stack.add;
265: app_exception.raise_exception;
266: END IF;
267:
268: --Added this check for unit sets in IGS_PS_OFR_OPT_UNIT_SET_V view

Line 281: IGS_GE_MSG_STACK.ADD;

277: FETCH cur_unitset_check INTO l_c_var;
278: IF cur_unitset_check%NOTFOUND THEN
279: CLOSE cur_unitset_check;
280: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
281: IGS_GE_MSG_STACK.ADD;
282: App_Exception.Raise_Exception;
283: END IF;
284: CLOSE cur_unitset_check;
285:

Line 409: igs_ge_msg_stack.add;

405: FETCH cur_rowid INTO lv_rowid;
406: IF (cur_rowid%FOUND) THEN
407: CLOSE cur_rowid;
408: fnd_message.set_name ('IGS', 'IGS_HE_HPUD_UOO_FK');
409: igs_ge_msg_stack.add;
410: app_exception.raise_exception;
411: RETURN;
412: END IF;
413: CLOSE cur_rowid;

Line 446: igs_ge_msg_stack.add;

442: FETCH cur_rowid INTO lv_rowid;
443: IF (cur_rowid%FOUND) THEN
444: CLOSE cur_rowid;
445: fnd_message.set_name ('IGS', 'IGS_HE_HPUD_US_FK');
446: igs_ge_msg_stack.add;
447: app_exception.raise_exception;
448: RETURN;
449: END IF;
450: CLOSE cur_rowid;

Line 489: IGS_GE_MSG_STACK.ADD;

485: Fetch cur_rowid INTO lv_rowid;
486: IF (cur_rowid%FOUND) THEN
487: Close cur_rowid;
488: Fnd_Message.Set_Name ('IGS', 'IGS_HE_HPUD_US_FK');
489: IGS_GE_MSG_STACK.ADD;
490: App_Exception.Raise_Exception;
491: Return;
492: END IF;
493: Close cur_rowid;

Line 526: igs_ge_msg_stack.add;

522: FETCH cur_stdnt INTO l_stdnt;
523: IF cur_stdnt%FOUND THEN
524: CLOSE cur_stdnt;
525: fnd_message.set_name ('IGS', 'IGS_HE_CANT_DEL_POP_EXIST');
526: igs_ge_msg_stack.add;
527: app_exception.raise_exception;
528: RETURN;
529: END IF;
530: CLOSE cur_stdnt;

Line 655: igs_ge_msg_stack.add;

651: new_references.hesa_poous_id
652: )
653: ) THEN
654: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
655: igs_ge_msg_stack.add;
656: app_exception.raise_exception;
657: END IF;
658: check_uniqueness;
659: check_parent_existance;

Line 674: igs_ge_msg_stack.add;

670: new_references.hesa_poous_id
671: )
672: ) THEN
673: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
674: igs_ge_msg_stack.add;
675: app_exception.raise_exception;
676: END IF;
677: check_uniqueness;
678: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 772: igs_ge_msg_stack.add;

768: x_last_update_login := -1;
769: END IF;
770: ELSE
771: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
772: igs_ge_msg_stack.add;
773: app_exception.raise_exception;
774: END IF;
775:
776: SELECT igs_he_poous_all_s.NEXTVAL

Line 1034: igs_ge_msg_stack.add;

1030: OPEN c1;
1031: FETCH c1 INTO tlinfo;
1032: IF (c1%notfound) THEN
1033: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1034: igs_ge_msg_stack.add;
1035: CLOSE c1;
1036: app_exception.raise_exception;
1037: RETURN;
1038: END IF;

Line 1081: igs_ge_msg_stack.add;

1077: ) THEN
1078: NULL;
1079: ELSE
1080: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1081: igs_ge_msg_stack.add;
1082: app_exception.raise_exception;
1083: END IF;
1084:
1085: RETURN;

Line 1168: igs_ge_msg_stack.add;

1164: x_last_update_login := -1;
1165: END IF;
1166: ELSE
1167: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
1168: igs_ge_msg_stack.add;
1169: app_exception.raise_exception;
1170: END IF;
1171:
1172: before_dml(