DBA Data[Home] [Help]

APPS.IGS_AD_APLINS_ADMREQ_PKG dependencies on FND_MESSAGE

Line 48: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');

44: OPEN cur_old_ref_values;
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;

Line 98: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');

94: new_references.sequence_number,
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:

Line 133: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');

129: new_references.admission_appl_number, -- locking issues -- rghosh )
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:

Line 144: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');

140: NULL;
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:

Line 264: fnd_message.set_name ('IGS', 'IGS_AD_APLINS_ACAI_FK');

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

Line 299: fnd_message.set_name ('IGS', 'IGS_FOREIGN_KEY_REFERENCE');

295: OPEN cur_rowid;
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;

Line 361: Fnd_Message.Set_name('IGS','IGS_AD_NOT_INST_UPD_REQ_DOC');

357: FETCH c_get_adm_doc_status INTO l_get_adm_doc_status;
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;

Line 464: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

460: IF ( get_pk_for_validation(
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;

Line 492: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

488: IF ( get_pk_for_validation (
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;

Line 577: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');

573: ELSE
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:

Line 659: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');

655: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.
656: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
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

Line 660: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);

656: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
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;

Line 705: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

701:
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;

Line 722: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

718: AND (tlinfo.tracking_id = x_tracking_id)
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:

Line 776: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');

772: IF (x_last_update_login IS NULL) THEN
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:

Line 831: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

827: program_update_date = x_program_update_date
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;

Line 854: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_UPD_POLICY_EXCP');

850: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.
851: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
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

Line 855: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);

851: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
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;

Line 951: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

947: DELETE FROM igs_ad_aplins_admreq
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;

Line 974: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');

970: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.
971: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
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

Line 975: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);

971: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
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;