DBA Data[Home] [Help]

APPS.IGS_PE_EIT_PKG dependencies on IGS_GE_MSG_STACK

Line 53: igs_ge_msg_stack.add;

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

Line 106: igs_ge_msg_stack.add;

102: )
103: ) THEN
104: IF new_references.information_type = 'PE_STAT_RES_STATE' THEN
105: FND_MESSAGE.SET_NAME ('IGS','IGS_PE_STATE_DUP_EXISTS');
106: igs_ge_msg_stack.add;
107: app_exception.raise_exception;
108: ELSIF new_references.information_type = 'PE_STAT_RES_COUNTRY' THEN
109: FND_MESSAGE.SET_NAME ('IGS','IGS_PE_COUNTRY_DUP_EXISTS');
110: igs_ge_msg_stack.add;

Line 110: igs_ge_msg_stack.add;

106: igs_ge_msg_stack.add;
107: app_exception.raise_exception;
108: ELSIF new_references.information_type = 'PE_STAT_RES_COUNTRY' THEN
109: FND_MESSAGE.SET_NAME ('IGS','IGS_PE_COUNTRY_DUP_EXISTS');
110: igs_ge_msg_stack.add;
111: app_exception.raise_exception;
112: ELSE
113: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
114: igs_ge_msg_stack.add;

Line 114: igs_ge_msg_stack.add;

110: igs_ge_msg_stack.add;
111: app_exception.raise_exception;
112: ELSE
113: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
114: igs_ge_msg_stack.add;
115: app_exception.raise_exception;
116: END IF;
117: END IF;
118:

Line 141: igs_ge_msg_stack.add;

137: ELSIF NOT igs_pe_person_pkg.get_pk_for_validation (
138: new_references.person_id
139: ) THEN
140: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
141: igs_ge_msg_stack.add;
142: app_exception.raise_exception;
143: END IF;
144:
145: END check_parent_existance;

Line 248: igs_ge_msg_stack.add;

244: FETCH cur_rowid INTO lv_rowid;
245: IF (cur_rowid%FOUND) THEN
246: CLOSE cur_rowid;
247: fnd_message.set_name ('IGS', 'IGS_PE_PEIT_HZ_FK');
248: igs_ge_msg_stack.add;
249: app_exception.raise_exception;
250: RETURN;
251: END IF;
252: CLOSE cur_rowid;

Line 307: IGS_GE_MSG_STACK.ADD;

303: CLOSE validate_brth_dt;
304:
305: IF new_references.END_DATE IS NOT NULL AND new_references.END_DATE < new_references.START_DATE THEN
306: FND_MESSAGE.SET_NAME('IGS','IGS_FI_ST_DT_LE_END_DT');
307: IGS_GE_MSG_STACK.ADD;
308: APP_EXCEPTION.RAISE_EXCEPTION;
309:
310: ELSIF l_bth_dt IS NOT NULL AND l_bth_dt > new_references.START_DATE THEN
311: FND_MESSAGE.SET_NAME('IGS','IGS_PE_DREC_GT_BTDT');

Line 312: IGS_GE_MSG_STACK.ADD;

308: APP_EXCEPTION.RAISE_EXCEPTION;
309:
310: ELSIF l_bth_dt IS NOT NULL AND l_bth_dt > new_references.START_DATE THEN
311: FND_MESSAGE.SET_NAME('IGS','IGS_PE_DREC_GT_BTDT');
312: IGS_GE_MSG_STACK.ADD;
313: APP_EXCEPTION.RAISE_EXCEPTION;
314: END IF;
315:
316:

Line 342: IGS_GE_MSG_STACK.ADD;

338: ELSE
339: FND_MESSAGE.SET_NAME('IGS','IGS_PE_PRDS_OVERLAP');
340: END IF;
341:
342: IGS_GE_MSG_STACK.ADD;
343: APP_EXCEPTION.RAISE_EXCEPTION;
344: END IF;
345: CLOSE validate_dt_overlap;
346: END IF;

Line 409: igs_ge_msg_stack.add;

405: new_references.pe_eit_id
406: )
407: ) THEN
408: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
409: igs_ge_msg_stack.add;
410: app_exception.raise_exception;
411: END IF;
412: check_uniqueness;
413: check_parent_existance;

Line 426: igs_ge_msg_stack.add;

422: new_references.pe_eit_id
423: )
424: ) THEN
425: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
426: igs_ge_msg_stack.add;
427: app_exception.raise_exception;
428: END IF;
429: check_uniqueness;
430: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 486: igs_ge_msg_stack.add;

482: x_last_update_login := -1;
483: END IF;
484: ELSE
485: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
486: igs_ge_msg_stack.add;
487: app_exception.raise_exception;
488: END IF;
489:
490: SELECT igs_pe_eit_s.NEXTVAL

Line 569: igs_ge_msg_stack.add;

565: WHEN OTHERS THEN
566: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
567: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
568: fnd_message.set_token ('ERR_CD', SQLCODE);
569: igs_ge_msg_stack.add;
570: igs_sc_gen_001.unset_ctx('R');
571: app_exception.raise_exception;
572: ELSE
573: igs_sc_gen_001.unset_ctx('R');

Line 624: igs_ge_msg_stack.add;

620: OPEN c1;
621: FETCH c1 INTO tlinfo;
622: IF (c1%notfound) THEN
623: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
624: igs_ge_msg_stack.add;
625: CLOSE c1;
626: app_exception.raise_exception;
627: RETURN;
628: END IF;

Line 645: igs_ge_msg_stack.add;

641: ) THEN
642: NULL;
643: ELSE
644: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
645: igs_ge_msg_stack.add;
646: app_exception.raise_exception;
647: END IF;
648:
649: RETURN;

Line 698: igs_ge_msg_stack.add;

694: x_last_update_login := -1;
695: END IF;
696: ELSE
697: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
698: igs_ge_msg_stack.add;
699: app_exception.raise_exception;
700: END IF;
701:
702: before_dml(

Line 743: igs_ge_msg_stack.add;

739: WHERE rowid = x_rowid;
740:
741: IF (SQL%NOTFOUND) THEN
742: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
743: igs_ge_msg_stack.add;
744: igs_sc_gen_001.unset_ctx('R');
745: app_exception.raise_exception;
746: END IF;
747: IF (x_mode = 'S') THEN

Line 758: igs_ge_msg_stack.add;

754: WHEN OTHERS THEN
755: IF (SQLCODE = (-28115)) THEN
756: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
757: fnd_message.set_token ('ERR_CD', SQLCODE);
758: igs_ge_msg_stack.add;
759: igs_sc_gen_001.unset_ctx('R');
760: app_exception.raise_exception;
761: ELSE
762: igs_sc_gen_001.unset_ctx('R');

Line 867: igs_ge_msg_stack.add;

863: WHERE rowid = x_rowid;
864:
865: IF (SQL%NOTFOUND) THEN
866: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
867: igs_ge_msg_stack.add;
868: igs_sc_gen_001.unset_ctx('R');
869: app_exception.raise_exception;
870: END IF;
871: IF (x_mode = 'S') THEN