DBA Data[Home] [Help]

APPS.IGF_GR_VERIFY_PROCESS dependencies on FND_MESSAGE

Line 160: fnd_message.set_name('IGF','IGF_AW_PROC_AWD');

156: IF l_c_ci_cal_type IS NULL OR l_n_ci_sequence_number IS NULL THEN
157: RAISE param_error;
158: END IF;
159:
160: fnd_message.set_name('IGF','IGF_AW_PROC_AWD');
161: fnd_message.set_token('AWD_YR',igf_gr_gen.get_alt_code(l_c_ci_cal_type,l_n_ci_sequence_number));
162: l_c_msg := fnd_message.get;
163: print_increment(l_c_msg);
164:

Line 161: fnd_message.set_token('AWD_YR',igf_gr_gen.get_alt_code(l_c_ci_cal_type,l_n_ci_sequence_number));

157: RAISE param_error;
158: END IF;
159:
160: fnd_message.set_name('IGF','IGF_AW_PROC_AWD');
161: fnd_message.set_token('AWD_YR',igf_gr_gen.get_alt_code(l_c_ci_cal_type,l_n_ci_sequence_number));
162: l_c_msg := fnd_message.get;
163: print_increment(l_c_msg);
164:
165: IF p_c_from <> p_c_to THEN

Line 162: l_c_msg := fnd_message.get;

158: END IF;
159:
160: fnd_message.set_name('IGF','IGF_AW_PROC_AWD');
161: fnd_message.set_token('AWD_YR',igf_gr_gen.get_alt_code(l_c_ci_cal_type,l_n_ci_sequence_number));
162: l_c_msg := fnd_message.get;
163: print_increment(l_c_msg);
164:
165: IF p_c_from <> p_c_to THEN
166: --Bug #5021084

Line 198: fnd_message.set_name('IGF','IGF_DB_NO_PER_GRP');

194:
195: FETCH cur_per_grp INTO per_grp_rec;
196:
197: IF cur_per_grp%NOTFOUND THEN
198: fnd_message.set_name('IGF','IGF_DB_NO_PER_GRP');
199: fnd_file.put_line(fnd_file.log,fnd_message.get);
200: ELSE
201: OPEN c_group_code(p_n_per_grp_id);
202: FETCH c_group_code INTO rec_grp_cd;

Line 199: fnd_file.put_line(fnd_file.log,fnd_message.get);

195: FETCH cur_per_grp INTO per_grp_rec;
196:
197: IF cur_per_grp%NOTFOUND THEN
198: fnd_message.set_name('IGF','IGF_DB_NO_PER_GRP');
199: fnd_file.put_line(fnd_file.log,fnd_message.get);
200: ELSE
201: OPEN c_group_code(p_n_per_grp_id);
202: FETCH c_group_code INTO rec_grp_cd;
203: fnd_message.set_name('IGF','IGF_AW_PERSON_ID_GROUP');

Line 203: fnd_message.set_name('IGF','IGF_AW_PERSON_ID_GROUP');

199: fnd_file.put_line(fnd_file.log,fnd_message.get);
200: ELSE
201: OPEN c_group_code(p_n_per_grp_id);
202: FETCH c_group_code INTO rec_grp_cd;
203: fnd_message.set_name('IGF','IGF_AW_PERSON_ID_GROUP');
204: fnd_message.set_token('P_PER_GRP',rec_grp_cd.group_cd);
205: l_c_msg := fnd_message.get;
206: print_increment(l_c_msg);
207: CLOSE c_group_code;

Line 204: fnd_message.set_token('P_PER_GRP',rec_grp_cd.group_cd);

200: ELSE
201: OPEN c_group_code(p_n_per_grp_id);
202: FETCH c_group_code INTO rec_grp_cd;
203: fnd_message.set_name('IGF','IGF_AW_PERSON_ID_GROUP');
204: fnd_message.set_token('P_PER_GRP',rec_grp_cd.group_cd);
205: l_c_msg := fnd_message.get;
206: print_increment(l_c_msg);
207: CLOSE c_group_code;
208: LOOP

Line 205: l_c_msg := fnd_message.get;

201: OPEN c_group_code(p_n_per_grp_id);
202: FETCH c_group_code INTO rec_grp_cd;
203: fnd_message.set_name('IGF','IGF_AW_PERSON_ID_GROUP');
204: fnd_message.set_token('P_PER_GRP',rec_grp_cd.group_cd);
205: l_c_msg := fnd_message.get;
206: print_increment(l_c_msg);
207: CLOSE c_group_code;
208: LOOP
209: fnd_message.set_name ('IGF', 'IGF_AW_PROC_STUD');

Line 209: fnd_message.set_name ('IGF', 'IGF_AW_PROC_STUD');

205: l_c_msg := fnd_message.get;
206: print_increment(l_c_msg);
207: CLOSE c_group_code;
208: LOOP
209: fnd_message.set_name ('IGF', 'IGF_AW_PROC_STUD');
210: fnd_message.set_token('STDNT',per_grp_rec.person_number);
211: l_c_msg := fnd_message.get;
212: fnd_file.new_line(fnd_file.log,1);
213: print_increment(l_c_msg);

Line 210: fnd_message.set_token('STDNT',per_grp_rec.person_number);

206: print_increment(l_c_msg);
207: CLOSE c_group_code;
208: LOOP
209: fnd_message.set_name ('IGF', 'IGF_AW_PROC_STUD');
210: fnd_message.set_token('STDNT',per_grp_rec.person_number);
211: l_c_msg := fnd_message.get;
212: fnd_file.new_line(fnd_file.log,1);
213: print_increment(l_c_msg);
214:

Line 211: l_c_msg := fnd_message.get;

207: CLOSE c_group_code;
208: LOOP
209: fnd_message.set_name ('IGF', 'IGF_AW_PROC_STUD');
210: fnd_message.set_token('STDNT',per_grp_rec.person_number);
211: l_c_msg := fnd_message.get;
212: fnd_file.new_line(fnd_file.log,1);
213: print_increment(l_c_msg);
214:
215: OPEN c_fa_base_dtls(l_c_ci_cal_type,l_n_ci_sequence_number, per_grp_rec.person_id);

Line 342: fnd_message.set_name('IGF','IGF_GR_VERI_COM_FROM_BLANK');

338:
339: -- If the vale of the FED_VERIF_STATUS is NULL in the FA BASE REC, log the message having no FROM token.
340:
341: IF (rec_fa_base_dtls.fed_verif_status IS NULL) THEN
342: fnd_message.set_name('IGF','IGF_GR_VERI_COM_FROM_BLANK');
343: fnd_message.set_token('PERSON_NUMBER',per_grp_rec.person_number);
344: fnd_message.set_token('P_TO',igf_aw_gen.LOOKUP_DESC('IGF_FED_VERIFY_STATUS',p_c_to));
345:
346: ELSIF (rec_fa_base_dtls.fed_verif_status = p_c_from) THEN

Line 343: fnd_message.set_token('PERSON_NUMBER',per_grp_rec.person_number);

339: -- If the vale of the FED_VERIF_STATUS is NULL in the FA BASE REC, log the message having no FROM token.
340:
341: IF (rec_fa_base_dtls.fed_verif_status IS NULL) THEN
342: fnd_message.set_name('IGF','IGF_GR_VERI_COM_FROM_BLANK');
343: fnd_message.set_token('PERSON_NUMBER',per_grp_rec.person_number);
344: fnd_message.set_token('P_TO',igf_aw_gen.LOOKUP_DESC('IGF_FED_VERIFY_STATUS',p_c_to));
345:
346: ELSIF (rec_fa_base_dtls.fed_verif_status = p_c_from) THEN
347: -- Log the message with the two tokens, as being done before.

Line 344: fnd_message.set_token('P_TO',igf_aw_gen.LOOKUP_DESC('IGF_FED_VERIFY_STATUS',p_c_to));

340:
341: IF (rec_fa_base_dtls.fed_verif_status IS NULL) THEN
342: fnd_message.set_name('IGF','IGF_GR_VERI_COM_FROM_BLANK');
343: fnd_message.set_token('PERSON_NUMBER',per_grp_rec.person_number);
344: fnd_message.set_token('P_TO',igf_aw_gen.LOOKUP_DESC('IGF_FED_VERIFY_STATUS',p_c_to));
345:
346: ELSIF (rec_fa_base_dtls.fed_verif_status = p_c_from) THEN
347: -- Log the message with the two tokens, as being done before.
348: fnd_message.set_name('IGF','IGF_GR_VERI_COMPLETE');

Line 348: fnd_message.set_name('IGF','IGF_GR_VERI_COMPLETE');

344: fnd_message.set_token('P_TO',igf_aw_gen.LOOKUP_DESC('IGF_FED_VERIFY_STATUS',p_c_to));
345:
346: ELSIF (rec_fa_base_dtls.fed_verif_status = p_c_from) THEN
347: -- Log the message with the two tokens, as being done before.
348: fnd_message.set_name('IGF','IGF_GR_VERI_COMPLETE');
349: fnd_message.set_token('PERSON_NUMBER',per_grp_rec.person_number);
350: fnd_message.set_token('P_FROM',igf_aw_gen.LOOKUP_DESC('IGF_FED_VERIFY_STATUS',p_c_from));
351: fnd_message.set_token('P_TO',igf_aw_gen.LOOKUP_DESC('IGF_FED_VERIFY_STATUS',p_c_to));
352: END IF;

Line 349: fnd_message.set_token('PERSON_NUMBER',per_grp_rec.person_number);

345:
346: ELSIF (rec_fa_base_dtls.fed_verif_status = p_c_from) THEN
347: -- Log the message with the two tokens, as being done before.
348: fnd_message.set_name('IGF','IGF_GR_VERI_COMPLETE');
349: fnd_message.set_token('PERSON_NUMBER',per_grp_rec.person_number);
350: fnd_message.set_token('P_FROM',igf_aw_gen.LOOKUP_DESC('IGF_FED_VERIFY_STATUS',p_c_from));
351: fnd_message.set_token('P_TO',igf_aw_gen.LOOKUP_DESC('IGF_FED_VERIFY_STATUS',p_c_to));
352: END IF;
353:

Line 350: fnd_message.set_token('P_FROM',igf_aw_gen.LOOKUP_DESC('IGF_FED_VERIFY_STATUS',p_c_from));

346: ELSIF (rec_fa_base_dtls.fed_verif_status = p_c_from) THEN
347: -- Log the message with the two tokens, as being done before.
348: fnd_message.set_name('IGF','IGF_GR_VERI_COMPLETE');
349: fnd_message.set_token('PERSON_NUMBER',per_grp_rec.person_number);
350: fnd_message.set_token('P_FROM',igf_aw_gen.LOOKUP_DESC('IGF_FED_VERIFY_STATUS',p_c_from));
351: fnd_message.set_token('P_TO',igf_aw_gen.LOOKUP_DESC('IGF_FED_VERIFY_STATUS',p_c_to));
352: END IF;
353:
354: l_c_msg := fnd_message.get;

Line 351: fnd_message.set_token('P_TO',igf_aw_gen.LOOKUP_DESC('IGF_FED_VERIFY_STATUS',p_c_to));

347: -- Log the message with the two tokens, as being done before.
348: fnd_message.set_name('IGF','IGF_GR_VERI_COMPLETE');
349: fnd_message.set_token('PERSON_NUMBER',per_grp_rec.person_number);
350: fnd_message.set_token('P_FROM',igf_aw_gen.LOOKUP_DESC('IGF_FED_VERIFY_STATUS',p_c_from));
351: fnd_message.set_token('P_TO',igf_aw_gen.LOOKUP_DESC('IGF_FED_VERIFY_STATUS',p_c_to));
352: END IF;
353:
354: l_c_msg := fnd_message.get;
355: print_increment(l_c_msg);

Line 354: l_c_msg := fnd_message.get;

350: fnd_message.set_token('P_FROM',igf_aw_gen.LOOKUP_DESC('IGF_FED_VERIFY_STATUS',p_c_from));
351: fnd_message.set_token('P_TO',igf_aw_gen.LOOKUP_DESC('IGF_FED_VERIFY_STATUS',p_c_to));
352: END IF;
353:
354: l_c_msg := fnd_message.get;
355: print_increment(l_c_msg);
356: ELSE
357: fnd_message.set_name('IGF','IGF_GR_VERI_NO_UPDT');
358: fnd_message.set_token('P_FROM',igf_aw_gen.LOOKUP_DESC('IGF_FED_VERIFY_STATUS',p_c_from));

Line 357: fnd_message.set_name('IGF','IGF_GR_VERI_NO_UPDT');

353:
354: l_c_msg := fnd_message.get;
355: print_increment(l_c_msg);
356: ELSE
357: fnd_message.set_name('IGF','IGF_GR_VERI_NO_UPDT');
358: fnd_message.set_token('P_FROM',igf_aw_gen.LOOKUP_DESC('IGF_FED_VERIFY_STATUS',p_c_from));
359: l_c_msg := fnd_message.get;
360: print_increment(l_c_msg);
361: END IF;

Line 358: fnd_message.set_token('P_FROM',igf_aw_gen.LOOKUP_DESC('IGF_FED_VERIFY_STATUS',p_c_from));

354: l_c_msg := fnd_message.get;
355: print_increment(l_c_msg);
356: ELSE
357: fnd_message.set_name('IGF','IGF_GR_VERI_NO_UPDT');
358: fnd_message.set_token('P_FROM',igf_aw_gen.LOOKUP_DESC('IGF_FED_VERIFY_STATUS',p_c_from));
359: l_c_msg := fnd_message.get;
360: print_increment(l_c_msg);
361: END IF;
362: ELSE

Line 359: l_c_msg := fnd_message.get;

355: print_increment(l_c_msg);
356: ELSE
357: fnd_message.set_name('IGF','IGF_GR_VERI_NO_UPDT');
358: fnd_message.set_token('P_FROM',igf_aw_gen.LOOKUP_DESC('IGF_FED_VERIFY_STATUS',p_c_from));
359: l_c_msg := fnd_message.get;
360: print_increment(l_c_msg);
361: END IF;
362: ELSE
363: fnd_message.set_name('IGF','IGF_DB_NO_FA_PER');

Line 363: fnd_message.set_name('IGF','IGF_DB_NO_FA_PER');

359: l_c_msg := fnd_message.get;
360: print_increment(l_c_msg);
361: END IF;
362: ELSE
363: fnd_message.set_name('IGF','IGF_DB_NO_FA_PER');
364: fnd_message.set_token('PER_NUM',per_grp_rec.person_number);
365: l_c_msg := fnd_message.get;
366: print_increment(l_c_msg);
367: END IF;

Line 364: fnd_message.set_token('PER_NUM',per_grp_rec.person_number);

360: print_increment(l_c_msg);
361: END IF;
362: ELSE
363: fnd_message.set_name('IGF','IGF_DB_NO_FA_PER');
364: fnd_message.set_token('PER_NUM',per_grp_rec.person_number);
365: l_c_msg := fnd_message.get;
366: print_increment(l_c_msg);
367: END IF;
368: CLOSE c_fa_base_dtls;

Line 365: l_c_msg := fnd_message.get;

361: END IF;
362: ELSE
363: fnd_message.set_name('IGF','IGF_DB_NO_FA_PER');
364: fnd_message.set_token('PER_NUM',per_grp_rec.person_number);
365: l_c_msg := fnd_message.get;
366: print_increment(l_c_msg);
367: END IF;
368: CLOSE c_fa_base_dtls;
369: FETCH cur_per_grp INTO per_grp_rec;

Line 386: errbuf := fnd_message.get_string('IGF','IGF_AW_PARAM_ERR');

382:
383: WHEN param_error THEN
384: ROLLBACK;
385: retcode := 2;
386: errbuf := fnd_message.get_string('IGF','IGF_AW_PARAM_ERR');
387: fnd_file.put_line(fnd_file.log,errbuf);
388:
389: WHEN others THEN
390: ROLLBACK;

Line 393: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION');

389: WHEN others THEN
390: ROLLBACK;
391: retcode := 2;
392: fnd_file.put_line(fnd_file.log,sqlerrm);
393: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION');
394: igs_ge_msg_stack.conc_exception_hndl;
395:
396: END main;
397: