DBA Data[Home] [Help]

APPS.IGS_AD_APPL_ARP_PKG dependencies on FND_MESSAGE

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

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

Line 99: fnd_message.set_name ('IGS', 'IGS_GE_PK_UK_NOT_FOUND_CLOSED');

95: NULL;
96: ELSIF NOT igs_pe_person_pkg.get_pk_for_validation (
97: new_references.person_id
98: ) THEN
99: fnd_message.set_name ('IGS', 'IGS_GE_PK_UK_NOT_FOUND_CLOSED');
100: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PERSON'));
101: igs_ge_msg_stack.add;
102: app_exception.raise_exception;
103: END IF;

Line 100: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PERSON'));

96: ELSIF NOT igs_pe_person_pkg.get_pk_for_validation (
97: new_references.person_id
98: ) THEN
99: fnd_message.set_name ('IGS', 'IGS_GE_PK_UK_NOT_FOUND_CLOSED');
100: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PERSON'));
101: igs_ge_msg_stack.add;
102: app_exception.raise_exception;
103: END IF;
104:

Line 111: fnd_message.set_name ('IGS', 'IGS_GE_PK_UK_NOT_FOUND_CLOSED');

107: NULL;
108: ELSIF NOT igs_ad_apl_rprf_rgr_pkg.get_pk_for_validation (
109: new_references.appl_revprof_revgr_id
110: ) THEN
111: fnd_message.set_name ('IGS', 'IGS_GE_PK_UK_NOT_FOUND_CLOSED');
112: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_REV_PRF_GRP'));
113: igs_ge_msg_stack.add;
114: app_exception.raise_exception;
115: END IF;

Line 112: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_REV_PRF_GRP'));

108: ELSIF NOT igs_ad_apl_rprf_rgr_pkg.get_pk_for_validation (
109: new_references.appl_revprof_revgr_id
110: ) THEN
111: fnd_message.set_name ('IGS', 'IGS_GE_PK_UK_NOT_FOUND_CLOSED');
112: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_REV_PRF_GRP'));
113: igs_ge_msg_stack.add;
114: app_exception.raise_exception;
115: END IF;
116:

Line 124: fnd_message.set_name ('IGS', 'IGS_GE_PK_UK_NOT_FOUND_CLOSED');

120: ELSIF NOT igs_ad_apl_rev_prf_pkg.get_pk_for_validation (
121: new_references.appl_rev_profile_id ,
122: 'N'
123: ) THEN
124: fnd_message.set_name ('IGS', 'IGS_GE_PK_UK_NOT_FOUND_CLOSED');
125: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_REV_PROFILE'));
126: igs_ge_msg_stack.add;
127: app_exception.raise_exception;
128: END IF;

Line 125: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_REV_PROFILE'));

121: new_references.appl_rev_profile_id ,
122: 'N'
123: ) THEN
124: fnd_message.set_name ('IGS', 'IGS_GE_PK_UK_NOT_FOUND_CLOSED');
125: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_REV_PROFILE'));
126: igs_ge_msg_stack.add;
127: app_exception.raise_exception;
128: END IF;
129:

Line 145: fnd_message.set_name ('IGS', 'IGS_GE_PK_UK_NOT_FOUND_CLOSED');

141: new_references.admission_appl_number, -- locking issues -- rghosh )
142: new_references.nominated_course_cd,
143: new_references.sequence_number
144: ) THEN
145: fnd_message.set_name ('IGS', 'IGS_GE_PK_UK_NOT_FOUND_CLOSED');
146: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PROGRAM_APPL'));
147: igs_ge_msg_stack.add;
148: app_exception.raise_exception;
149: END IF;

Line 146: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PROGRAM_APPL'));

142: new_references.nominated_course_cd,
143: new_references.sequence_number
144: ) THEN
145: fnd_message.set_name ('IGS', 'IGS_GE_PK_UK_NOT_FOUND_CLOSED');
146: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PROGRAM_APPL'));
147: igs_ge_msg_stack.add;
148: app_exception.raise_exception;
149: END IF;
150:

Line 215: fnd_message.set_name ('IGS', 'IGS_AD_APLARP_APRRGR_FK');

211: OPEN cur_rowid;
212: FETCH cur_rowid INTO lv_rowid;
213: IF (cur_rowid%FOUND) THEN
214: CLOSE cur_rowid;
215: fnd_message.set_name ('IGS', 'IGS_AD_APLARP_APRRGR_FK');
216: igs_ge_msg_stack.add;
217: app_exception.raise_exception;
218: RETURN;
219: END IF;

Line 250: fnd_message.set_name ('IGS', 'IGS_AD_APLARP_ADAPR_FK');

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

Line 293: fnd_message.set_name ('IGS', 'IGS_AD_APLARP_ACAI_FK');

289: OPEN cur_rowid;
290: FETCH cur_rowid INTO lv_rowid;
291: IF (cur_rowid%FOUND) THEN
292: CLOSE cur_rowid;
293: fnd_message.set_name ('IGS', 'IGS_AD_APLARP_ACAI_FK');
294: igs_ge_msg_stack.add;
295: app_exception.raise_exception;
296: RETURN;
297: END IF;

Line 346: Fnd_Message.Set_name('IGS','IGS_AD_NOT_INST_UPD_RVP_OUT');

342: x_sequence_number );
343:
344: FETCH c_get_system_status INTO l_get_system_status;
345: IF c_get_system_status % NOTFOUND THEN
346: Fnd_Message.Set_name('IGS','IGS_AD_NOT_INST_UPD_RVP_OUT');
347: IGS_GE_MSG_STACK.ADD;
348: CLOSE c_get_system_status;
349: App_Exception.Raise_Exception;
350: END IF;

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

410: IF ( get_pk_for_validation(
411: new_references.appl_arp_id
412: )
413: ) THEN
414: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
415: igs_ge_msg_stack.add;
416: app_exception.raise_exception;
417: END IF;
418: check_parent_existance;

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

434: IF ( get_pk_for_validation (
435: new_references.appl_arp_id
436: )
437: ) THEN
438: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
439: igs_ge_msg_stack.add;
440: app_exception.raise_exception;
441: END IF;
442: check_system_status (

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

516: ELSE
517: x_program_update_date := SYSDATE;
518: END IF;
519: ELSE
520: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
521: igs_ge_msg_stack.add;
522: app_exception.raise_exception;
523: END IF;
524:

Line 601: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');

597: IF (x_mode = 'S') THEN
598: igs_sc_gen_001.unset_ctx('R');
599: END IF;
600: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
601: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
602: fnd_message.set_token ('ERR_CD', SQLCODE);
603: igs_ge_msg_stack.add;
604: app_exception.raise_exception;
605: ELSE

Line 602: fnd_message.set_token ('ERR_CD', SQLCODE);

598: igs_sc_gen_001.unset_ctx('R');
599: END IF;
600: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
601: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
602: fnd_message.set_token ('ERR_CD', SQLCODE);
603: igs_ge_msg_stack.add;
604: app_exception.raise_exception;
605: ELSE
606: igs_sc_gen_001.unset_ctx('R');

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

646:
647: OPEN c1;
648: FETCH c1 INTO tlinfo;
649: IF (c1%notfound) THEN
650: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
651: igs_ge_msg_stack.add;
652: CLOSE c1;
653: app_exception.raise_exception;
654: RETURN;

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

664: AND ((tlinfo.appl_revprof_revgr_id = x_appl_revprof_revgr_id) OR ((tlinfo.appl_revprof_revgr_id IS NULL) AND (X_appl_revprof_revgr_id IS NULL)))
665: ) THEN
666: NULL;
667: ELSE
668: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
669: igs_ge_msg_stack.add;
670: app_exception.raise_exception;
671: END IF;
672:

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

719: IF (x_last_update_login IS NULL) THEN
720: x_last_update_login := -1;
721: END IF;
722: ELSE
723: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
724: igs_ge_msg_stack.add;
725: app_exception.raise_exception;
726: END IF;
727:

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

776: program_update_date = x_program_update_date
777: WHERE rowid = x_rowid;
778:
779: IF (SQL%NOTFOUND) THEN
780: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
781: igs_ge_msg_stack.add;
782: IF (x_mode = 'S') THEN
783: igs_sc_gen_001.unset_ctx('R');
784: END IF;

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

798: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.
799: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
800: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
801: -- that the ownerof policy function does not have privilege to access.
802: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
803: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
804: IGS_GE_MSG_STACK.ADD;
805: app_exception.raise_exception;
806: ELSE

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

799: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
800: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
801: -- that the ownerof policy function does not have privilege to access.
802: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
803: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
804: IGS_GE_MSG_STACK.ADD;
805: app_exception.raise_exception;
806: ELSE
807: RAISE;

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

898: DELETE FROM igs_ad_appl_arp
899: WHERE rowid = x_rowid;
900:
901: IF (SQL%NOTFOUND) THEN
902: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
903: igs_ge_msg_stack.add;
904: IF (x_mode = 'S') THEN
905: igs_sc_gen_001.unset_ctx('R');
906: END IF;