APPS.PQH_GSP_STAGE_TO_BEN dependencies on FND_FILE

Line 3743: fnd_file.put_line (which => fnd_file.LOG,

3739: p_enrt_perd_strt_dt_cd => 'AED',
3740: p_rt_end_dt_cd => 'ODBED',
3741: p_rt_strt_dt_cd => 'AED'
3742: );
3743: fnd_file.put_line (which => fnd_file.LOG,
3744: buff => 'Program Name : '
3745: || get_pgm_name (p_pgm_id,
3746: p_effective_date
3747: )

Line 3749: fnd_file.put_line (which => fnd_file.LOG,

3745: || get_pgm_name (p_pgm_id,
3746: p_effective_date
3747: )
3748: );
3749: fnd_file.put_line (which => fnd_file.LOG,
3750: buff => 'Program Id : ' || p_pgm_id
3751: );
3752: END IF;
3753: EXCEPTION

Line 3756: fnd_file.put_line

3752: END IF;
3753: EXCEPTION
3754: WHEN OTHERS
3755: THEN
3756: fnd_file.put_line
3757: (which => fnd_file.LOG,
3758: buff => 'Error while creating Program Enrollement Reasons..exiting'
3759: );
3760: ROLLBACK;

Line 3757: (which => fnd_file.LOG,

3753: EXCEPTION
3754: WHEN OTHERS
3755: THEN
3756: fnd_file.put_line
3757: (which => fnd_file.LOG,
3758: buff => 'Error while creating Program Enrollement Reasons..exiting'
3759: );
3760: ROLLBACK;
3761: END create_le_for_pgm;

Line 3798: fnd_file.put_line (which => fnd_file.LOG,buff => 'Entering create_pgm_le');

3794: l_ler_id NUMBER;
3795: l_effective_date DATE;
3796: l_pgm_effective_start_date DATE;
3797: BEGIN
3798: fnd_file.put_line (which => fnd_file.LOG,buff => 'Entering create_pgm_le');
3799: l_effective_date := TO_DATE (p_effective_date, 'YYYY/MM/DD HH24:MI:SS');
3800: l_effective_date :=TO_DATE (TO_CHAR (TRUNC (l_effective_date), 'DD/MM/RRRR'),'DD/MM/RRRR');
3801:
3802: OPEN csr_ler_id;

Line 3812: fnd_file.put_line (which => fnd_file.LOG,buff => 'Life Event Exists');

3808: errbuf :='No Life Event of Type Grade/Step Progression with Operator Code Synchronization found. Exiting';
3809: retcode := -20;
3810: RETURN;
3811: ELSE
3812: fnd_file.put_line (which => fnd_file.LOG,buff => 'Life Event Exists');
3813: END IF;
3814:
3815: CLOSE csr_ler_id;
3816: fnd_file.put_line

Line 3816: fnd_file.put_line

3812: fnd_file.put_line (which => fnd_file.LOG,buff => 'Life Event Exists');
3813: END IF;
3814:
3815: CLOSE csr_ler_id;
3816: fnd_file.put_line
3817: (which => fnd_file.LOG,
3818: buff => 'Created Program Enrolment Reason for the following Programs '
3819: );
3820: fnd_file.put_line

Line 3817: (which => fnd_file.LOG,

3813: END IF;
3814:
3815: CLOSE csr_ler_id;
3816: fnd_file.put_line
3817: (which => fnd_file.LOG,
3818: buff => 'Created Program Enrolment Reason for the following Programs '
3819: );
3820: fnd_file.put_line
3821: (which => fnd_file.LOG,

Line 3820: fnd_file.put_line

3816: fnd_file.put_line
3817: (which => fnd_file.LOG,
3818: buff => 'Created Program Enrolment Reason for the following Programs '
3819: );
3820: fnd_file.put_line
3821: (which => fnd_file.LOG,
3822: buff => '==========================================================='
3823: );
3824: IF p_pgm_id IS NULL

Line 3821: (which => fnd_file.LOG,

3817: (which => fnd_file.LOG,
3818: buff => 'Created Program Enrolment Reason for the following Programs '
3819: );
3820: fnd_file.put_line
3821: (which => fnd_file.LOG,
3822: buff => '==========================================================='
3823: );
3824: IF p_pgm_id IS NULL
3825: THEN

Line 3848: fnd_file.put_line (which => fnd_file.LOG,

3844: p_effective_date => l_pgm_effective_start_date
3845: );
3846: END IF;
3847: COMMIT;
3848: fnd_file.put_line (which => fnd_file.LOG,
3849: buff => 'Leaving create_pgm_le'
3850: );
3851: END create_pgm_le;
3852: