eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_AW_COA_UPDATE dependencies on IGF_GR_GEN

Line 336: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));

332:
333: IF l_rate_order.org_unit_cd IS NOT NULL AND p_base_details.org_unit_cd IS NULL THEN
334: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
335: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','ORG_UNIT_CD'));
336: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
337: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
338:
339: l_counter := 2;
340: END IF;

Line 345: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));

341:
342: IF l_rate_order.program_type IS NOT NULL AND p_base_details.program_type IS NULL THEN
343: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
344: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','PROGRAM_TYPE'));
345: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
346: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
347:
348: l_counter := 2;
349: END IF;

Line 354: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));

350:
351: IF l_rate_order.program_location_cd IS NOT NULL AND p_base_details.program_location_cd IS NULL THEN
352: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
353: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','PROGRAM_LOCATION_CD'));
354: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
355: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
356:
357: l_counter := 2;
358: END IF;

Line 363: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));

359:
360: IF l_rate_order.program_cd IS NOT NULL AND p_base_details.program_cd IS NULL THEN
361: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
362: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','PROGRAM_CD'));
363: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
364: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
365:
366: l_counter := 2;
367: END IF;

Line 372: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));

368:
369: IF l_rate_order.class_standing IS NOT NULL AND p_base_details.class_standing IS NULL THEN
370: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
371: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','CLASS_STANDING'));
372: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
373: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
374:
375: l_counter := 2;
376: END IF;

Line 381: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));

377:
378: IF l_rate_order.residency_status_code IS NOT NULL AND p_base_details.residency_status_code IS NULL THEN
379: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
380: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','RESIDENCY_STATUS_CODE'));
381: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
382: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
383:
384: l_counter := 2;
385: END IF;

Line 390: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));

386:
387: IF l_rate_order.housing_status_code IS NOT NULL AND p_base_details.housing_status_code IS NULL THEN
388: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
389: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','HOUSING_STATUS_CODE'));
390: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
391: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
392:
393: l_counter := 2;
394: END IF;

Line 399: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));

395:
396: IF l_rate_order.attendance_type IS NOT NULL AND p_base_details.attendance_type IS NULL THEN
397: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
398: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','ATTENDANCE_TYPE'));
399: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
400: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
401:
402: l_counter := 2;
403: END IF;

Line 408: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));

404:
405: IF l_rate_order.attendance_mode IS NOT NULL AND p_base_details.attendance_mode IS NULL THEN
406: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
407: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','ATTENDANCE_MODE'));
408: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
409: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
410:
411: l_counter := 2;
412: END IF;

Line 589: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.evaluate.debug','term:'||igf_gr_gen.get_alt_code(l_terms.ld_cal_type,l_terms.ld_sequence_number)||' is locked');

585: LOOP
586: IF l_terms.lock_flag = 'Y' THEN
587:
588: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
589: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.evaluate.debug','term:'||igf_gr_gen.get_alt_code(l_terms.ld_cal_type,l_terms.ld_sequence_number)||' is locked');
590: END IF;
591:
592: fnd_message.set_name('IGF','IGF_AW_SKP_LK_TRM');
593: fnd_message.set_token('TERM_CODE',igf_gr_gen.get_alt_code(l_terms.ld_cal_type,l_terms.ld_sequence_number));

Line 593: fnd_message.set_token('TERM_CODE',igf_gr_gen.get_alt_code(l_terms.ld_cal_type,l_terms.ld_sequence_number));

589: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.evaluate.debug','term:'||igf_gr_gen.get_alt_code(l_terms.ld_cal_type,l_terms.ld_sequence_number)||' is locked');
590: END IF;
591:
592: fnd_message.set_name('IGF','IGF_AW_SKP_LK_TRM');
593: fnd_message.set_token('TERM_CODE',igf_gr_gen.get_alt_code(l_terms.ld_cal_type,l_terms.ld_sequence_number));
594: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
595: ELSE
596: --Execute the COA re-calculation logic
597: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 618: fnd_message.set_token('TERM_CODE',igf_gr_gen.get_alt_code(l_terms.ld_cal_type,l_terms.ld_sequence_number));

614:
615: IF ln_amount <> l_terms.amount THEN
616: fnd_message.set_name('IGF','IGF_AW_UPD_ITM');
617: fnd_message.set_token('ITEM_CODE',l_items.item_code);
618: fnd_message.set_token('TERM_CODE',igf_gr_gen.get_alt_code(l_terms.ld_cal_type,l_terms.ld_sequence_number));
619: fnd_message.set_token('RATE_ORDER',ln_rate_order);
620: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
621:
622: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 642: fnd_message.set_token('TERM_CODE',igf_gr_gen.get_alt_code(l_terms.ld_cal_type,l_terms.ld_sequence_number));

638: ELSE
639: IF NVL(ln_rate_order,0) <> -1 THEN
640: fnd_message.set_name('IGF','IGF_AW_ITEM_SKIP');
641: fnd_message.set_token('ITEM_CODE',l_items.item_code);
642: fnd_message.set_token('TERM_CODE',igf_gr_gen.get_alt_code(l_terms.ld_cal_type,l_terms.ld_sequence_number));
643: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
644: END IF;
645:
646: RAISE E_SKIP_STUDENT;

Line 879: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_YEAR'),60) || igf_gr_gen.get_alt_code(lv_ci_cal_type,ln_ci_sequence_number));

875:
876: fnd_file.new_line(fnd_file.log,1);
877:
878: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PARAMETER_PASS'));
879: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_YEAR'),60) || igf_gr_gen.get_alt_code(lv_ci_cal_type,ln_ci_sequence_number));
880:
881: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','RUN_TYPE'),60) ||p_run_type );
882:
883: OPEN c_group_code(p_pid_group);

Line 888: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'),60) || igf_gr_gen.get_per_num(p_base_id));

884: FETCH c_group_code INTO l_grp_cd;
885: CLOSE c_group_code;
886:
887: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'),60) || l_grp_cd.group_cd);
888: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'),60) || igf_gr_gen.get_per_num(p_base_id));
889:
890: fnd_file.new_line(fnd_file.log,2);
891:
892: IF (p_award_year IS NULL) OR (p_run_type IS NULL) THEN

Line 925: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(p_base_id));

921: IF p_run_type = 'S' AND (p_pid_group IS NULL) AND (p_base_id IS NOT NULL) THEN
922:
923: fnd_file.new_line(fnd_file.log,1);
924: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
925: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(p_base_id));
926: fnd_file.put_line(fnd_file.log,fnd_message.get);
927:
928: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
929: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','Starting Run_Type=S with base_id:'||p_base_id);

Line 948: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(l_per_awd_rec.base_id));

944: FOR l_per_awd_rec IN c_per_awd_yr(lv_ci_cal_type,ln_ci_sequence_number)
945: LOOP
946: fnd_file.new_line(fnd_file.log,1);
947: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
948: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(l_per_awd_rec.base_id));
949: fnd_file.put_line(fnd_file.log,fnd_message.get);
950:
951: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
952: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','Starting Run_Type=Y with base_id:'||l_per_awd_rec.base_id);

Line 998: igf_gr_gen.get_base_id(

994: -- check if person has a fa base record
995: ln_base_id := NULL;
996: lv_err_msg := NULL;
997:
998: igf_gr_gen.get_base_id(
999: lv_ci_cal_type,
1000: ln_ci_sequence_number,
1001: per_grp_rec.person_id,
1002: ln_base_id,

Line 1009: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(ln_base_id));

1005:
1006: IF lv_err_msg = 'NULL' THEN
1007: fnd_file.new_line(fnd_file.log,1);
1008: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
1009: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(ln_base_id));
1010: fnd_file.put_line(fnd_file.log,fnd_message.get);
1011:
1012: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1013: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','Starting Run_Type=P with base_id:'||ln_base_id);

Line 1054: igf_gr_gen.get_base_id(

1050: -- check if person has a fa base record
1051: ln_base_id := NULL;
1052: lv_err_msg := NULL;
1053:
1054: igf_gr_gen.get_base_id(
1055: lv_ci_cal_type,
1056: ln_ci_sequence_number,
1057: l_person_id.person_id,
1058: ln_base_id,

Line 1065: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(ln_base_id));

1061:
1062: IF lv_err_msg = 'NULL' THEN
1063: fnd_file.new_line(fnd_file.log,1);
1064: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
1065: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(ln_base_id));
1066: fnd_file.put_line(fnd_file.log,fnd_message.get);
1067:
1068: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1069: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','Starting Run_Type=A with base_id:'||ln_base_id);