APPS.IGS_PE_SN_SERVICE_PKG dependencies on IGS_GE_MSG_STACK

Line 49: igs_ge_msg_stack.add;

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

Line 100: igs_ge_msg_stack.add;

96: new_references.start_dt
97: )
98: ) THEN
99: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
100: igs_ge_msg_stack.add;
101: app_exception.raise_exception;
102: END IF;
103:
104: END check_uniqueness;

Line 126: igs_ge_msg_stack.add;

122: ELSIF NOT igs_lookups_view_pkg.get_pk_for_validation (
123: 'PE_SN_SERVICE',new_references.special_service_cd
124: ) THEN
125: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
126: igs_ge_msg_stack.add;
127: app_exception.raise_exception;
128: END IF;
129:
130: IF (((old_references.disability_id = new_references.disability_id)) OR

Line 137: igs_ge_msg_stack.add;

133: ELSIF NOT igs_pe_pers_disablty_pkg.get_pk_for_validation (
134: new_references.disability_id
135: ) THEN
136: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
137: igs_ge_msg_stack.add;
138: app_exception.raise_exception;
139: END IF;
140:
141: END check_parent_existance;

Line 245: igs_ge_msg_stack.add;

241: FETCH cur_rowid INTO lv_rowid;
242: IF (cur_rowid%FOUND) THEN
243: CLOSE cur_rowid;
244: fnd_message.set_name ('IGS', 'IGS_PE_SNSV_PD_FK');
245: igs_ge_msg_stack.add;
246: app_exception.raise_exception;
247: RETURN;
248: END IF;
249: CLOSE cur_rowid;

Line 306: igs_ge_msg_stack.add;

302: new_references.sn_service_id
303: )
304: ) THEN
305: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
306: igs_ge_msg_stack.add;
307: app_exception.raise_exception;
308: END IF;
309:
310: check_uniqueness;

Line 324: igs_ge_msg_stack.add;

320: new_references.sn_service_id
321: )
322: ) THEN
323: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
324: igs_ge_msg_stack.add;
325: app_exception.raise_exception;
326: END IF;
327: check_uniqueness;
328:

Line 381: igs_ge_msg_stack.add;

377: x_last_update_login := -1;
378: END IF;
379: ELSE
380: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
381: igs_ge_msg_stack.add;
382: app_exception.raise_exception;
383: END IF;
384:
385: SELECT igs_pe_sn_service_s.NEXTVAL

Line 452: igs_ge_msg_stack.add;

448: WHEN OTHERS THEN
449: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
450: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
451: fnd_message.set_token ('ERR_CD', SQLCODE);
452: igs_ge_msg_stack.add;
453: igs_sc_gen_001.unset_ctx('R');
454: app_exception.raise_exception;
455: ELSE
456: igs_sc_gen_001.unset_ctx('R');

Line 500: igs_ge_msg_stack.add;

496: OPEN c1;
497: FETCH c1 INTO tlinfo;
498: IF (c1%notfound) THEN
499: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
500: igs_ge_msg_stack.add;
501: CLOSE c1;
502: app_exception.raise_exception;
503: RETURN;
504: END IF;

Line 526: igs_ge_msg_stack.add;

522: ) THEN
523: NULL;
524: ELSE
525: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
526: igs_ge_msg_stack.add;
527: app_exception.raise_exception;
528: END IF;
529:
530: RETURN;

Line 575: igs_ge_msg_stack.add;

571: x_last_update_login := -1;
572: END IF;
573: ELSE
574: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
575: igs_ge_msg_stack.add;
576: app_exception.raise_exception;
577: END IF;
578:
579: before_dml(

Line 612: igs_ge_msg_stack.add;

608: WHERE rowid = x_rowid;
609:
610: IF (SQL%NOTFOUND) THEN
611: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
612: igs_ge_msg_stack.add;
613: igs_sc_gen_001.unset_ctx('R');
614: app_exception.raise_exception;
615: END IF;
616: IF (x_mode = 'S') THEN

Line 627: igs_ge_msg_stack.add;

623: WHEN OTHERS THEN
624: IF (SQLCODE = (-28115)) THEN
625: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
626: fnd_message.set_token ('ERR_CD', SQLCODE);
627: igs_ge_msg_stack.add;
628: igs_sc_gen_001.unset_ctx('R');
629: app_exception.raise_exception;
630: ELSE
631: igs_sc_gen_001.unset_ctx('R');

Line 724: igs_ge_msg_stack.add;

720: WHERE rowid = x_rowid;
721:
722: IF (SQL%NOTFOUND) THEN
723: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
724: igs_ge_msg_stack.add;
725: igs_sc_gen_001.unset_ctx('R');
726: app_exception.raise_exception;
727: END IF;
728: IF (x_mode = 'S') THEN