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.IGS_PE_GEN_001 dependencies on FND_LOG

Line 480: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

476:
477: BEGIN
478: l_prog_label := 'igs.plsql.igs_pe_gen_001.get_res_status';
479:
480: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
481: l_label := 'igs.plsql.igs_pe_gen_001.get_res_status.begin';
482: l_debug_str := 'start of proc get_res_status. Parameters p_person_id/p_residency_class/p_cal_type/p_sequence_number: '||
483: p_person_id||'/'||p_residency_class||'/'||p_cal_type||'/'||p_sequence_number;
484: fnd_log.string_with_context(fnd_log.level_procedure, l_label,l_debug_str,NULL,NULL,NULL,NULL,NULL,NULL);

Line 484: fnd_log.string_with_context(fnd_log.level_procedure, l_label,l_debug_str,NULL,NULL,NULL,NULL,NULL,NULL);

480: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
481: l_label := 'igs.plsql.igs_pe_gen_001.get_res_status.begin';
482: l_debug_str := 'start of proc get_res_status. Parameters p_person_id/p_residency_class/p_cal_type/p_sequence_number: '||
483: p_person_id||'/'||p_residency_class||'/'||p_cal_type||'/'||p_sequence_number;
484: fnd_log.string_with_context(fnd_log.level_procedure, l_label,l_debug_str,NULL,NULL,NULL,NULL,NULL,NULL);
485: END IF;
486:
487: --check all parameters passed.
488: IF ( p_person_id IS NULL OR p_residency_class IS NULL OR p_cal_type IS NULL OR p_sequence_number IS NULL ) THEN

Line 506: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

502: OPEN c_ca(p_cal_type , p_sequence_number);
503: FETCH c_ca INTO ca_rec;
504: IF c_ca%FOUND THEN
505:
506: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
507: l_label := 'igs.plsql.igs_pe_gen_001.get_res_status.Nearest Term1';
508: l_debug_str := 'No Residency Status defined for the Term passed. Returning the Status defined for the Nearest Term.';
509: fnd_log.string_with_context(fnd_log.level_procedure, l_label,l_debug_str,NULL,NULL,NULL,NULL,NULL,NULL);
510: END IF;

Line 509: fnd_log.string_with_context(fnd_log.level_procedure, l_label,l_debug_str,NULL,NULL,NULL,NULL,NULL,NULL);

505:
506: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
507: l_label := 'igs.plsql.igs_pe_gen_001.get_res_status.Nearest Term1';
508: l_debug_str := 'No Residency Status defined for the Term passed. Returning the Status defined for the Nearest Term.';
509: fnd_log.string_with_context(fnd_log.level_procedure, l_label,l_debug_str,NULL,NULL,NULL,NULL,NULL,NULL);
510: END IF;
511:
512: CLOSE c_ca;
513: OPEN c_gap_res(p_person_id, p_residency_class, ca_rec.start_dt);

Line 517: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

513: OPEN c_gap_res(p_person_id, p_residency_class, ca_rec.start_dt);
514: FETCH c_gap_res INTO gap_rec;
515: IF c_gap_res%FOUND THEN
516:
517: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
518: l_label := 'igs.plsql.igs_pe_gen_001.get_res_status.Nearest Term2';
519: l_debug_str := 'Residency Status: '||gap_rec.residency_status_cd;
520: fnd_log.string_with_context(fnd_log.level_procedure, l_label,l_debug_str,NULL,NULL,NULL,NULL,NULL,NULL);
521: END IF;

Line 520: fnd_log.string_with_context(fnd_log.level_procedure, l_label,l_debug_str,NULL,NULL,NULL,NULL,NULL,NULL);

516:
517: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
518: l_label := 'igs.plsql.igs_pe_gen_001.get_res_status.Nearest Term2';
519: l_debug_str := 'Residency Status: '||gap_rec.residency_status_cd;
520: fnd_log.string_with_context(fnd_log.level_procedure, l_label,l_debug_str,NULL,NULL,NULL,NULL,NULL,NULL);
521: END IF;
522:
523: CLOSE c_gap_res;
524: RETURN gap_rec.residency_status_cd;