DBA Data[Home] [Help]

APPS.IGS_AD_ASSIGN_EVAL_AI_PKG dependencies on FND_FILE

Line 152: FND_FILE.PUT_LINE(FND_FILE.LOG,'Review Profile Name :' || l_review_profile_name);

148: IF p_unassigned_appl = '1' THEN l_unassigned_appl := 'YES';
149: ELSIF p_unassigned_appl = '2' THEN l_unassigned_appl := 'NO';
150: END IF;
151:
152: FND_FILE.PUT_LINE(FND_FILE.LOG,'Review Profile Name :' || l_review_profile_name);
153: FND_FILE.PUT_LINE(FND_FILE.LOG,'Review Group Code :' || l_review_group_code);
154: FND_FILE.PUT_LINE(FND_FILE.LOG,'All Unassigned Applications :' || l_unassigned_appl);
155:
156: IF p_review_profile_id IS NULL AND

Line 153: FND_FILE.PUT_LINE(FND_FILE.LOG,'Review Group Code :' || l_review_group_code);

149: ELSIF p_unassigned_appl = '2' THEN l_unassigned_appl := 'NO';
150: END IF;
151:
152: FND_FILE.PUT_LINE(FND_FILE.LOG,'Review Profile Name :' || l_review_profile_name);
153: FND_FILE.PUT_LINE(FND_FILE.LOG,'Review Group Code :' || l_review_group_code);
154: FND_FILE.PUT_LINE(FND_FILE.LOG,'All Unassigned Applications :' || l_unassigned_appl);
155:
156: IF p_review_profile_id IS NULL AND
157: p_review_group_code IS NULL AND

Line 154: FND_FILE.PUT_LINE(FND_FILE.LOG,'All Unassigned Applications :' || l_unassigned_appl);

150: END IF;
151:
152: FND_FILE.PUT_LINE(FND_FILE.LOG,'Review Profile Name :' || l_review_profile_name);
153: FND_FILE.PUT_LINE(FND_FILE.LOG,'Review Group Code :' || l_review_group_code);
154: FND_FILE.PUT_LINE(FND_FILE.LOG,'All Unassigned Applications :' || l_unassigned_appl);
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

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 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 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 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 268: FND_FILE.PUT_LINE(FND_FILE.LOG,sqlerrm(sqlcode));

264: END IF;
265: IF c_common_no_eval_grp%ISOPEN THEN
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);

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 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 504: -- fnd_file.put_line(fnd_file.log,'Value of seq ind is '|| l_seq_conc_ind);

500: );
501:
502: /*********** New Feature ****** For Sending notification to Evaluators: bug 2864696 *************/
503:
504: -- fnd_file.put_line(fnd_file.log,'Value of seq ind is '|| l_seq_conc_ind);
505:
506: IF l_seq_conc_ind = 'S' and l_sequence_number = 1 THEN
507:
508: IF my_revgrp_list.count = 0 THEN

Line 519: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Record already present in table');

515:
516: FOR j IN 0..(my_revgrp_list.COUNT-1)
517: LOOP
518: IF my_revgrp_list(j) = l_appl_rev_prof_evaluator_rec.person_id THEN
519: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Record already present in table');
520: l_exists := 'Y';
521: EXIT;
522: END IF;
523: END LOOP;

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 554: -- FND_FILE.PUT_LINE (FND_FILE.LOG, 'eval is '|| l_person_id );

550:
551: LOOP
552: l_person_id := NVL(my_revgrp_list(k),0);
553:
554: -- FND_FILE.PUT_LINE (FND_FILE.LOG, 'eval is '|| l_person_id );
555:
556: Wf_Directory.GetRoleName('HZ_PARTY', l_person_id, l_person_name, l_full_name);
557:
558: IF l_person_name IS NOT NULL THEN

Line 563: FND_FILE.PUT_LINE (FND_FILE.LOG, '');

559:
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:

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 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 585: fnd_file.put_line(fnd_file.log,sqlerrm(sqlcode));

581: EXCEPTION
582: WHEN INVALID_PARAMETER THEN
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);

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: