DBA Data[Home] [Help]

APPS.IGS_AD_APLINS_ADMREQ_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 99: igs_ge_msg_stack.add;

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

Line 134: igs_ge_msg_stack.add;

130: new_references.course_cd,
131: new_references.sequence_number
132: ) THEN
133: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
134: igs_ge_msg_stack.add;
135: app_exception.raise_exception;
136: END IF;
137:
138: IF (((old_references.tracking_id = new_references.tracking_id)) OR

Line 145: igs_ge_msg_stack.add;

141: ELSIF NOT igs_tr_item_pkg.get_pk_for_validation (
142: new_references.tracking_id
143: ) THEN
144: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
145: igs_ge_msg_stack.add;
146: app_exception.raise_exception;
147: END IF;
148:
149: END check_parent_existance;

Line 265: igs_ge_msg_stack.add;

261: IF (cur_rowid%FOUND) THEN
262: CLOSE cur_rowid;
263: --changed the message name -rghosh (bug #2619603)
264: fnd_message.set_name ('IGS', 'IGS_AD_APLINS_ACAI_FK');
265: igs_ge_msg_stack.add;
266: app_exception.raise_exception;
267: RETURN;
268: END IF;
269: CLOSE cur_rowid;

Line 300: igs_ge_msg_stack.add;

296: FETCH cur_rowid INTO lv_rowid;
297: IF (cur_rowid%FOUND) THEN
298: CLOSE cur_rowid;
299: fnd_message.set_name ('IGS', 'IGS_FOREIGN_KEY_REFERENCE');
300: igs_ge_msg_stack.add;
301: app_exception.raise_exception;
302: RETURN;
303: END IF;
304: CLOSE cur_rowid;

Line 362: IGS_GE_MSG_STACK.ADD;

358: OPEN c_not_post_adm (x_tracking_id) ;
359: FETCH c_not_post_adm INTO l_not_post_adm ;
360: IF c_get_adm_doc_status % FOUND AND c_not_post_adm%FOUND THEN
361: Fnd_Message.Set_name('IGS','IGS_AD_NOT_INST_UPD_REQ_DOC');
362: IGS_GE_MSG_STACK.ADD;
363: CLOSE c_get_adm_doc_status;
364: CLOSE c_not_post_adm;
365: App_Exception.Raise_Exception;
366: END IF;

Line 465: igs_ge_msg_stack.add;

461: new_references.aplins_admreq_id
462: )
463: ) THEN
464: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
465: igs_ge_msg_stack.add;
466: app_exception.raise_exception;
467: END IF;
468: check_uniqueness;
469: check_parent_existance;

Line 493: igs_ge_msg_stack.add;

489: new_references.aplins_admreq_id
490: )
491: ) THEN
492: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
493: igs_ge_msg_stack.add;
494: app_exception.raise_exception;
495: END IF;
496: check_uniqueness;
497: check_appl_compl_stat (

Line 578: igs_ge_msg_stack.add;

574: x_program_update_date := SYSDATE;
575: END IF;
576: ELSE
577: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
578: igs_ge_msg_stack.add;
579: app_exception.raise_exception;
580: END IF;
581:
582: x_aplins_admreq_id := -1;

Line 661: IGS_GE_MSG_STACK.ADD;

657: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
658: -- that the ownerof policy function does not have privilege to access.
659: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
660: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
661: IGS_GE_MSG_STACK.ADD;
662: app_exception.raise_exception;
663: ELSE
664: RAISE;
665: END IF;

Line 706: igs_ge_msg_stack.add;

702: OPEN c1;
703: FETCH c1 INTO tlinfo;
704: IF (c1%notfound) THEN
705: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
706: igs_ge_msg_stack.add;
707: CLOSE c1;
708: app_exception.raise_exception;
709: RETURN;
710: END IF;

Line 723: igs_ge_msg_stack.add;

719: ) THEN
720: NULL;
721: ELSE
722: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
723: igs_ge_msg_stack.add;
724: app_exception.raise_exception;
725: END IF;
726:
727: RETURN;

Line 777: igs_ge_msg_stack.add;

773: x_last_update_login := -1;
774: END IF;
775: ELSE
776: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
777: igs_ge_msg_stack.add;
778: app_exception.raise_exception;
779: END IF;
780:
781: before_dml(

Line 832: igs_ge_msg_stack.add;

828: WHERE rowid = x_rowid;
829:
830: IF (SQL%NOTFOUND) THEN
831: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
832: igs_ge_msg_stack.add;
833: IF (x_mode = 'S') THEN
834: igs_sc_gen_001.set_ctx('R');
835: END IF;
836: app_exception.raise_exception;

Line 856: IGS_GE_MSG_STACK.ADD;

852: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
853: -- that the ownerof policy function does not have privilege to access.
854: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
855: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
856: IGS_GE_MSG_STACK.ADD;
857: app_exception.raise_exception;
858: ELSE
859: RAISE;
860: END IF;

Line 952: igs_ge_msg_stack.add;

948: WHERE rowid = x_rowid;
949:
950: IF (SQL%NOTFOUND) THEN
951: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
952: igs_ge_msg_stack.add;
953: IF (x_mode = 'S') THEN
954: igs_sc_gen_001.set_ctx('R');
955: END IF;
956: app_exception.raise_exception;

Line 976: IGS_GE_MSG_STACK.ADD;

972: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
973: -- that the ownerof policy function does not have privilege to access.
974: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
975: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
976: IGS_GE_MSG_STACK.ADD;
977: app_exception.raise_exception;
978: ELSE
979: RAISE;
980: END IF;