DBA Data[Home] [Help]

APPS.IGF_AW_MANAGE_AWD dependencies on IGF_AW_GEN

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

458: -- Change History:
459: -- Who When What
460: -- ridas 08-Feb-2006 Bug #5021084. Added new parameter 'lv_group_type' in
461: -- call to igf_ap_ss_pkg.get_pid
462: -- tsailaja 13/Jan/2006 Bug 4947880 Added invocation of igf_aw_gen.set_org_id(NULL);
463: -- veramach 31-May-2005 FA 140 Student SS Enhancements
464: -- Added logic to log parameters only if they are not null
465: --------------------------------------------------------------------------------
466:

Line 574: igf_aw_gen.set_org_id(NULL);

570: lv_err_msg fnd_new_messages.message_name%TYPE;
571:
572:
573: BEGIN
574: igf_aw_gen.set_org_id(NULL);
575: retcode := 0;
576: errbuf := NULL;
577: lv_ci_cal_type := LTRIM(RTRIM(SUBSTR(p_award_year,1,10)));
578: ln_ci_sequence_number := TO_NUMBER(SUBSTR(p_award_year,11));

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

591: END IF;
592:
593: fnd_file.new_line(fnd_file.log,1);
594:
595: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PARAMETER_PASS'));
596: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_YEAR'),40) ||': '|| igf_gr_gen.get_alt_code(lv_ci_cal_type,ln_ci_sequence_number));
597: IF p_award_period IS NOT NULL THEN
598: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_PERIOD'),40)||': '||p_award_period );
599: END IF;

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

592:
593: fnd_file.new_line(fnd_file.log,1);
594:
595: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PARAMETER_PASS'));
596: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_YEAR'),40) ||': '|| igf_gr_gen.get_alt_code(lv_ci_cal_type,ln_ci_sequence_number));
597: IF p_award_period IS NOT NULL THEN
598: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_PERIOD'),40)||': '||p_award_period );
599: END IF;
600:

Line 598: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_PERIOD'),40)||': '||p_award_period );

594:
595: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PARAMETER_PASS'));
596: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_YEAR'),40) ||': '|| igf_gr_gen.get_alt_code(lv_ci_cal_type,ln_ci_sequence_number));
597: IF p_award_period IS NOT NULL THEN
598: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_PERIOD'),40)||': '||p_award_period );
599: END IF;
600:
601: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','RUN_TYPE'),40)||': '||p_run_type );
602:

Line 601: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','RUN_TYPE'),40)||': '||p_run_type );

597: IF p_award_period IS NOT NULL THEN
598: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_PERIOD'),40)||': '||p_award_period );
599: END IF;
600:
601: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','RUN_TYPE'),40)||': '||p_run_type );
602:
603: IF p_pid_group IS NOT NULL THEN
604: OPEN c_group_code(p_pid_group);
605: FETCH c_group_code INTO l_grp_cd;

Line 608: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'),40) ||': '|| l_grp_cd.group_cd);

604: OPEN c_group_code(p_pid_group);
605: FETCH c_group_code INTO l_grp_cd;
606: CLOSE c_group_code;
607:
608: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'),40) ||': '|| l_grp_cd.group_cd);
609: END IF;
610: IF p_base_id IS NOT NULL THEN
611: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'),40) ||': '|| igf_gr_gen.get_per_num(p_base_id));
612: END If;

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

607:
608: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'),40) ||': '|| l_grp_cd.group_cd);
609: END IF;
610: IF p_base_id IS NOT NULL THEN
611: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'),40) ||': '|| igf_gr_gen.get_per_num(p_base_id));
612: END If;
613: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','RUN_MODE'),40) ||': '||igf_aw_gen.lookup_desc('IGF_AW_LOCK_MODE',p_run_mode));
614: IF p_awd_proc_status IS NOT NULL THEN
615: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_PROC_STATUS'),40) ||': '|| igf_aw_gen.lookup_desc('IGF_AW_AWD_PROC_STAT',p_awd_proc_status));

Line 613: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','RUN_MODE'),40) ||': '||igf_aw_gen.lookup_desc('IGF_AW_LOCK_MODE',p_run_mode));

609: END IF;
610: IF p_base_id IS NOT NULL THEN
611: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'),40) ||': '|| igf_gr_gen.get_per_num(p_base_id));
612: END If;
613: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','RUN_MODE'),40) ||': '||igf_aw_gen.lookup_desc('IGF_AW_LOCK_MODE',p_run_mode));
614: IF p_awd_proc_status IS NOT NULL THEN
615: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_PROC_STATUS'),40) ||': '|| igf_aw_gen.lookup_desc('IGF_AW_AWD_PROC_STAT',p_awd_proc_status));
616: END IF;
617:

Line 615: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_PROC_STATUS'),40) ||': '|| igf_aw_gen.lookup_desc('IGF_AW_AWD_PROC_STAT',p_awd_proc_status));

611: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'),40) ||': '|| igf_gr_gen.get_per_num(p_base_id));
612: END If;
613: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','RUN_MODE'),40) ||': '||igf_aw_gen.lookup_desc('IGF_AW_LOCK_MODE',p_run_mode));
614: IF p_awd_proc_status IS NOT NULL THEN
615: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_PROC_STATUS'),40) ||': '|| igf_aw_gen.lookup_desc('IGF_AW_AWD_PROC_STAT',p_awd_proc_status));
616: END IF;
617:
618: IF p_fund_id IS NOT NULL THEN
619: OPEN c_fund_code(p_fund_id);

Line 623: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','FUND_CODE'),40) ||': '|| l_fund_code.fund_code);

619: OPEN c_fund_code(p_fund_id);
620: FETCH c_fund_code INTO l_fund_code;
621: CLOSE c_fund_code;
622:
623: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','FUND_CODE'),40) ||': '|| l_fund_code.fund_code);
624: END IF;
625:
626:
627: IF (p_award_year IS NULL) OR (p_run_type IS NULL) OR (p_run_mode IS NULL) THEN