DBA Data[Home] [Help]

APPS.IGS_AD_ASSIGN_EVAL_AI_PKG dependencies on FND_MESSAGE

Line 159: FND_MESSAGE.SET_NAME('IGS','IGS_FI_SELECT_COMBN_NORECORDS');

155:
156: IF p_review_profile_id IS NULL AND
157: p_review_group_code IS NULL AND
158: p_unassigned_appl IS NULL THEN
159: FND_MESSAGE.SET_NAME('IGS','IGS_FI_SELECT_COMBN_NORECORDS');
160: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
161: RAISE INVALID_PARAMETER;
162: END IF;
163:

Line 160: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);

156: IF p_review_profile_id IS NULL AND
157: p_review_group_code IS NULL AND
158: p_unassigned_appl IS NULL THEN
159: FND_MESSAGE.SET_NAME('IGS','IGS_FI_SELECT_COMBN_NORECORDS');
160: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
161: RAISE INVALID_PARAMETER;
162: END IF;
163:
164: IF p_review_profile_id IS NOT NULL AND

Line 167: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PROCESS_PARAM');

163:
164: IF p_review_profile_id IS NOT NULL AND
165: p_review_group_code IS NOT NULL AND
166: p_unassigned_appl = '1' THEN -- p_unassigned_appl is passed as 'Y' interpreted as '1'
167: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PROCESS_PARAM');
168: FND_MESSAGE.SET_TOKEN('PARAM_NAME',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ALL_UNASGN_APL'));
169: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
170:
171: ELSIF p_review_profile_id IS NOT NULL AND

Line 168: FND_MESSAGE.SET_TOKEN('PARAM_NAME',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ALL_UNASGN_APL'));

164: IF p_review_profile_id IS NOT NULL AND
165: p_review_group_code IS NOT NULL AND
166: p_unassigned_appl = '1' THEN -- p_unassigned_appl is passed as 'Y' interpreted as '1'
167: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PROCESS_PARAM');
168: FND_MESSAGE.SET_TOKEN('PARAM_NAME',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ALL_UNASGN_APL'));
169: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
170:
171: ELSIF p_review_profile_id IS NOT NULL AND
172: p_review_group_code IS NOT NULL AND

Line 169: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);

165: p_review_group_code IS NOT NULL AND
166: p_unassigned_appl = '1' THEN -- p_unassigned_appl is passed as 'Y' interpreted as '1'
167: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PROCESS_PARAM');
168: FND_MESSAGE.SET_TOKEN('PARAM_NAME',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ALL_UNASGN_APL'));
169: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
170:
171: ELSIF p_review_profile_id IS NOT NULL AND
172: p_review_group_code IS NOT NULL AND
173: NVL(p_unassigned_appl,'0') <> '1' THEN -- p_unassigned_appl is passed as 'Y' interpreted as '1'

Line 174: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PROCESS_PARAM');

170:
171: ELSIF p_review_profile_id IS NOT NULL AND
172: p_review_group_code IS NOT NULL AND
173: NVL(p_unassigned_appl,'0') <> '1' THEN -- p_unassigned_appl is passed as 'Y' interpreted as '1'
174: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PROCESS_PARAM');
175: FND_MESSAGE.SET_TOKEN('PARAM_NAME',FND_MESSAGE.GET_STRING('IGS','IGS_AD_REV_PROF_NAME'));
176: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
177:
178: ELSIF p_review_profile_id IS NULL AND

Line 175: FND_MESSAGE.SET_TOKEN('PARAM_NAME',FND_MESSAGE.GET_STRING('IGS','IGS_AD_REV_PROF_NAME'));

171: ELSIF p_review_profile_id IS NOT NULL AND
172: p_review_group_code IS NOT NULL AND
173: NVL(p_unassigned_appl,'0') <> '1' THEN -- p_unassigned_appl is passed as 'Y' interpreted as '1'
174: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PROCESS_PARAM');
175: FND_MESSAGE.SET_TOKEN('PARAM_NAME',FND_MESSAGE.GET_STRING('IGS','IGS_AD_REV_PROF_NAME'));
176: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
177:
178: ELSIF p_review_profile_id IS NULL AND
179: p_review_group_code IS NOT NULL AND

Line 176: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);

172: p_review_group_code IS NOT NULL AND
173: NVL(p_unassigned_appl,'0') <> '1' THEN -- p_unassigned_appl is passed as 'Y' interpreted as '1'
174: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PROCESS_PARAM');
175: FND_MESSAGE.SET_TOKEN('PARAM_NAME',FND_MESSAGE.GET_STRING('IGS','IGS_AD_REV_PROF_NAME'));
176: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
177:
178: ELSIF p_review_profile_id IS NULL AND
179: p_review_group_code IS NOT NULL AND
180: NVL(p_unassigned_appl,'0') <> '1' THEN -- p_unassigned_appl is passed as 'Y' interpreted as '1'

Line 181: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PROCESS_PARAM');

177:
178: ELSIF p_review_profile_id IS NULL AND
179: p_review_group_code IS NOT NULL AND
180: NVL(p_unassigned_appl,'0') <> '1' THEN -- p_unassigned_appl is passed as 'Y' interpreted as '1'
181: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PROCESS_PARAM');
182: FND_MESSAGE.SET_TOKEN('PARAM_NAME',FND_MESSAGE.GET_STRING('IGS','IGS_AD_REV_GR_CD'));
183: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
184: END IF;
185:

Line 182: FND_MESSAGE.SET_TOKEN('PARAM_NAME',FND_MESSAGE.GET_STRING('IGS','IGS_AD_REV_GR_CD'));

178: ELSIF p_review_profile_id IS NULL AND
179: p_review_group_code IS NOT NULL AND
180: NVL(p_unassigned_appl,'0') <> '1' THEN -- p_unassigned_appl is passed as 'Y' interpreted as '1'
181: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PROCESS_PARAM');
182: FND_MESSAGE.SET_TOKEN('PARAM_NAME',FND_MESSAGE.GET_STRING('IGS','IGS_AD_REV_GR_CD'));
183: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
184: END IF;
185:
186:

Line 183: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);

179: p_review_group_code IS NOT NULL AND
180: NVL(p_unassigned_appl,'0') <> '1' THEN -- p_unassigned_appl is passed as 'Y' interpreted as '1'
181: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PROCESS_PARAM');
182: FND_MESSAGE.SET_TOKEN('PARAM_NAME',FND_MESSAGE.GET_STRING('IGS','IGS_AD_REV_GR_CD'));
183: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
184: END IF;
185:
186:
187: -- Initialize l_appl_revprof_revgr_id based on wether user has provided the

Line 270: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

266: CLOSE c_common_no_eval_grp;
267: END IF;
268: FND_FILE.PUT_LINE(FND_FILE.LOG,sqlerrm(sqlcode));
269: Retcode := 2;
270: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
271: FND_MESSAGE.SET_TOKEN('NAME','Assign_Eval_To_Appl_Inst');
272: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
273: Igs_Ge_Msg_Stack.conc_exception_hndl;
274:

Line 271: FND_MESSAGE.SET_TOKEN('NAME','Assign_Eval_To_Appl_Inst');

267: END IF;
268: FND_FILE.PUT_LINE(FND_FILE.LOG,sqlerrm(sqlcode));
269: Retcode := 2;
270: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
271: FND_MESSAGE.SET_TOKEN('NAME','Assign_Eval_To_Appl_Inst');
272: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
273: Igs_Ge_Msg_Stack.conc_exception_hndl;
274:
275: END Assign_Eval_To_Appl_Inst;

Line 272: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

268: FND_FILE.PUT_LINE(FND_FILE.LOG,sqlerrm(sqlcode));
269: Retcode := 2;
270: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
271: FND_MESSAGE.SET_TOKEN('NAME','Assign_Eval_To_Appl_Inst');
272: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
273: Igs_Ge_Msg_Stack.conc_exception_hndl;
274:
275: END Assign_Eval_To_Appl_Inst;
276:

Line 416: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_COMBI_OF_PARAMS');

412: p_admission_appl_number IS NULL OR
413: p_nominated_course_cd IS NULL OR
414: p_sequence_number IS NULL
415: THEN
416: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_COMBI_OF_PARAMS');
417: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
418: RAISE INVALID_PARAMETER;
419: END IF;
420:

Line 417: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);

413: p_nominated_course_cd IS NULL OR
414: p_sequence_number IS NULL
415: THEN
416: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_COMBI_OF_PARAMS');
417: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
418: RAISE INVALID_PARAMETER;
419: END IF;
420:
421: Retcode := 0;

Line 540: FND_MESSAGE.SET_NAME('IGS','IGS_AD_MISS_RS_SETUP');

536: FETCH c_appl_rev_profile INTO l_review_profile_name;
537: CLOSE c_appl_rev_profile;
538:
539: IF l_rating_exists = 'N' THEN
540: FND_MESSAGE.SET_NAME('IGS','IGS_AD_MISS_RS_SETUP');
541: FND_MESSAGE.SET_TOKEN ('REVIEW_PROFILE', l_review_profile_name);
542: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
543: EXIT;
544: END IF;

Line 541: FND_MESSAGE.SET_TOKEN ('REVIEW_PROFILE', l_review_profile_name);

537: CLOSE c_appl_rev_profile;
538:
539: IF l_rating_exists = 'N' THEN
540: FND_MESSAGE.SET_NAME('IGS','IGS_AD_MISS_RS_SETUP');
541: FND_MESSAGE.SET_TOKEN ('REVIEW_PROFILE', l_review_profile_name);
542: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
543: EXIT;
544: END IF;
545:

Line 542: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

538:
539: IF l_rating_exists = 'N' THEN
540: FND_MESSAGE.SET_NAME('IGS','IGS_AD_MISS_RS_SETUP');
541: FND_MESSAGE.SET_TOKEN ('REVIEW_PROFILE', l_review_profile_name);
542: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
543: EXIT;
544: END IF;
545:
546: END LOOP; -- End of looping through all the evaluators of that Review Profile Group.

Line 564: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF6');

560: /* Evaluators are being printed without any application context information.
561: Hence commenting out the following as part of fix for bug# 3224891
562:
563: FND_FILE.PUT_LINE (FND_FILE.LOG, '');
564: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF6');
565: FND_MESSAGE.SET_TOKEN ('PNAME', l_full_name);
566: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET()); */
567:
568: Wf_Inform_Evaluator_Appl (l_person_id, l_person_name, l_full_name);

Line 565: FND_MESSAGE.SET_TOKEN ('PNAME', l_full_name);

561: Hence commenting out the following as part of fix for bug# 3224891
562:
563: FND_FILE.PUT_LINE (FND_FILE.LOG, '');
564: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF6');
565: FND_MESSAGE.SET_TOKEN ('PNAME', l_full_name);
566: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET()); */
567:
568: Wf_Inform_Evaluator_Appl (l_person_id, l_person_name, l_full_name);
569:

Line 566: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET()); */

562:
563: FND_FILE.PUT_LINE (FND_FILE.LOG, '');
564: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF6');
565: FND_MESSAGE.SET_TOKEN ('PNAME', l_full_name);
566: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET()); */
567:
568: Wf_Inform_Evaluator_Appl (l_person_id, l_person_name, l_full_name);
569:
570: /* Evaluators are being printed without any application context information.

Line 574: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF4');

570: /* Evaluators are being printed without any application context information.
571: Hence commenting out the following as part of fix for bug# 3224891
572:
573: ELSE
574: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF4');
575: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET()); */
576:
577: END IF ; -- l_person_name
578: END LOOP;

Line 575: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET()); */

571: Hence commenting out the following as part of fix for bug# 3224891
572:
573: ELSE
574: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF4');
575: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET()); */
576:
577: END IF ; -- l_person_name
578: END LOOP;
579: /**************************************/

Line 587: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

583: Retcode := 2;
584: WHEN OTHERS THEN
585: fnd_file.put_line(fnd_file.log,sqlerrm(sqlcode));
586: Retcode := 2;
587: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
588: FND_MESSAGE.SET_TOKEN('NAME','Assign_Eval_To_Ai');
589: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
590: Igs_Ge_Msg_Stack.add;
591:

Line 588: FND_MESSAGE.SET_TOKEN('NAME','Assign_Eval_To_Ai');

584: WHEN OTHERS THEN
585: fnd_file.put_line(fnd_file.log,sqlerrm(sqlcode));
586: Retcode := 2;
587: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
588: FND_MESSAGE.SET_TOKEN('NAME','Assign_Eval_To_Ai');
589: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
590: Igs_Ge_Msg_Stack.add;
591:
592: END Assign_Eval_To_Ai;

Line 589: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

585: fnd_file.put_line(fnd_file.log,sqlerrm(sqlcode));
586: Retcode := 2;
587: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
588: FND_MESSAGE.SET_TOKEN('NAME','Assign_Eval_To_Ai');
589: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
590: Igs_Ge_Msg_Stack.add;
591:
592: END Assign_Eval_To_Ai;
593:

Line 910: FND_MESSAGE.SET_NAME('IGS','IGS_AD_MAND_RATING');

906: FOR l_next_seq IN c_next_seq(p_person_id,p_admission_appl_number,p_nominated_course_cd,p_sequence_number,
907: p_evaluator_id) LOOP
908: IF l_next_seq.rating_values_id IS NULL AND NVL(l_next_seq.closed_ind,'N') = 'N' THEN
909: IF (p_rating_type_id = l_next_seq.rating_type_id AND p_rating_scale_id = l_next_seq.rating_scale_id ) THEN
910: FND_MESSAGE.SET_NAME('IGS','IGS_AD_MAND_RATING');
911: IGS_GE_MSG_STACK.ADD;
912: APP_EXCEPTION.RAISE_EXCEPTION;
913: END IF;
914: l_chk_rating_val_null := 'Y' ;

Line 920: FND_MESSAGE.SET_NAME('IGS','IGS_AD_ACT_EVL_RT_RS');

916: EXIT;
917: END IF;
918: IF l_next_seq.rating_values_id IS NOT NULL AND NVL(l_next_seq.closed_ind,'N') = 'N' THEN
919: IF (p_rating_type_id = l_next_seq.rating_type_id AND p_rating_scale_id = l_next_seq.rating_scale_id ) THEN
920: FND_MESSAGE.SET_NAME('IGS','IGS_AD_ACT_EVL_RT_RS');
921: IGS_GE_MSG_STACK.ADD;
922: APP_EXCEPTION.RAISE_EXCEPTION;
923: END IF;
924: END IF;

Line 937: fnd_message.set_name('IGS','IGS_AD_NO_WF_NOTIF');

933:
934: ELSIF l_exist_eval_type = 'C' THEN
935: l_count:=1;
936:
937: fnd_message.set_name('IGS','IGS_AD_NO_WF_NOTIF');
938: IGS_GE_MSG_STACK.ADD;
939:
940: ELSE
941: l_count:=1;