APPS.PQH_GSP_STAGE_TO_BEN dependencies on FND_FILE

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

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

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

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

Line 3755: fnd_file.put_line

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

Line 3756: (which => fnd_file.LOG,

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

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

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

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

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

Line 3815: fnd_file.put_line

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

Line 3816: (which => fnd_file.LOG,

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

Line 3819: fnd_file.put_line

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

Line 3820: (which => fnd_file.LOG,

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

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

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