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_AW_GEN

Line 335: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','ORG_UNIT_CD'));

331: ELSE
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;

Line 344: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','PROGRAM_TYPE'));

340: END IF;
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;

Line 353: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','PROGRAM_LOCATION_CD'));

349: END IF;
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;

Line 362: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','PROGRAM_CD'));

358: END IF;
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;

Line 371: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','CLASS_STANDING'));

367: END IF;
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;

Line 380: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','RESIDENCY_STATUS_CODE'));

376: END IF;
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;

Line 389: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','HOUSING_STATUS_CODE'));

385: END IF;
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;

Line 398: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','ATTENDANCE_TYPE'));

394: END IF;
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;

Line 407: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','ATTENDANCE_MODE'));

403: END IF;
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;

Line 729: -- tsailaja 13/Jan/2006 Bug 4947880 Added invocation of igf_aw_gen.set_org_id(NULL);

725: -- Change History:
726: -- Who When What
727: -- ridas 08-Feb-2006 Bug #5021084. Added new parameter 'lv_group_type' in
728: -- call to igf_ap_ss_pkg.get_pid
729: -- tsailaja 13/Jan/2006 Bug 4947880 Added invocation of igf_aw_gen.set_org_id(NULL);
730: --------------------------------------------------------------------------------
731:
732: param_exception EXCEPTION;
733:

Line 861: igf_aw_gen.set_org_id(NULL);

857: lv_return_flag VARCHAR2(1);
858:
859:
860: BEGIN
861: igf_aw_gen.set_org_id(NULL);
862: retcode := 0;
863: errbuf := NULL;
864: lv_ci_cal_type := LTRIM(RTRIM(SUBSTR(p_award_year,1,10)));
865: ln_ci_sequence_number := TO_NUMBER(SUBSTR(p_award_year,11));

Line 878: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PARAMETER_PASS'));

874: END IF;
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:

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 881: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','RUN_TYPE'),60) ||p_run_type );

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);
884: FETCH c_group_code INTO l_grp_cd;
885: CLOSE c_group_code;

Line 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);

883: OPEN c_group_code(p_pid_group);
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:

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