DBA Data[Home] [Help]

APPS.PAY_FI_PAYLIST_ARCHIVE dependencies on FND_FILE

Line 172: fnd_file.put_line (

168: := g_package
169: || ' GET_ALL_PARAMETERS ';
170: --
171: BEGIN
172: fnd_file.put_line (
173: fnd_file.LOG,
174: 'Entering Procedure GET_ALL_PARAMETER '
175: );
176: fnd_file.put_line (

Line 173: fnd_file.LOG,

169: || ' GET_ALL_PARAMETERS ';
170: --
171: BEGIN
172: fnd_file.put_line (
173: fnd_file.LOG,
174: 'Entering Procedure GET_ALL_PARAMETER '
175: );
176: fnd_file.put_line (
177: fnd_file.LOG,

Line 176: fnd_file.put_line (

172: fnd_file.put_line (
173: fnd_file.LOG,
174: 'Entering Procedure GET_ALL_PARAMETER '
175: );
176: fnd_file.put_line (
177: fnd_file.LOG,
178: 'Payroill Action iD '
179: || p_RUN_payroll_action_id
180: );

Line 177: fnd_file.LOG,

173: fnd_file.LOG,
174: 'Entering Procedure GET_ALL_PARAMETER '
175: );
176: fnd_file.put_line (
177: fnd_file.LOG,
178: 'Payroill Action iD '
179: || p_RUN_payroll_action_id
180: );
181: OPEN csr_parameter_info (p_payroll_action_id);

Line 190: fnd_file.put_line (fnd_file.LOG, 'After csr_parameter_info in ');

186: p_start_date,
187: p_effective_date,
188: p_business_group_id;
189: CLOSE csr_parameter_info;
190: fnd_file.put_line (fnd_file.LOG, 'After csr_parameter_info in ');
191: fnd_file.put_line (fnd_file.LOG, 'archive='
192: || p_archive);
193:
194: IF g_debug

Line 191: fnd_file.put_line (fnd_file.LOG, 'archive='

187: p_effective_date,
188: p_business_group_id;
189: CLOSE csr_parameter_info;
190: fnd_file.put_line (fnd_file.LOG, 'After csr_parameter_info in ');
191: fnd_file.put_line (fnd_file.LOG, 'archive='
192: || p_archive);
193:
194: IF g_debug
195: THEN

Line 266: fnd_file.put_line (fnd_file.LOG, 'Entering Procedure RANGE_CODE 7');

262: THEN
263: hr_utility.set_location (' Entering Procedure RANGE_CODE', 40);
264: END IF;
265:
266: fnd_file.put_line (fnd_file.LOG, 'Entering Procedure RANGE_CODE 7');
267: p_sql :=
268: 'SELECT DISTINCT person_id
269: FROM per_people_f ppf
270: ,pay_payroll_actions ppa

Line 443: fnd_file.put_line (fnd_file.LOG, ' ');

439: g_run_payroll_action_id,
440: g_archive
441: );
442:
443: fnd_file.put_line (fnd_file.LOG, ' ');
444: fnd_file.put_line (
445: fnd_file.LOG,
446: 'Parameter P_Start_person '
447: || p_start_person

Line 444: fnd_file.put_line (

440: g_archive
441: );
442:
443: fnd_file.put_line (fnd_file.LOG, ' ');
444: fnd_file.put_line (
445: fnd_file.LOG,
446: 'Parameter P_Start_person '
447: || p_start_person
448: );

Line 445: fnd_file.LOG,

441: );
442:
443: fnd_file.put_line (fnd_file.LOG, ' ');
444: fnd_file.put_line (
445: fnd_file.LOG,
446: 'Parameter P_Start_person '
447: || p_start_person
448: );
449: fnd_file.put_line (

Line 449: fnd_file.put_line (

445: fnd_file.LOG,
446: 'Parameter P_Start_person '
447: || p_start_person
448: );
449: fnd_file.put_line (
450: fnd_file.LOG,
451: 'Paramter P_end_personn '
452: || p_end_person
453: );

Line 450: fnd_file.LOG,

446: 'Parameter P_Start_person '
447: || p_start_person
448: );
449: fnd_file.put_line (
450: fnd_file.LOG,
451: 'Paramter P_end_personn '
452: || p_end_person
453: );
454: fnd_file.put_line (

Line 454: fnd_file.put_line (

450: fnd_file.LOG,
451: 'Paramter P_end_personn '
452: || p_end_person
453: );
454: fnd_file.put_line (
455: fnd_file.LOG,
456: 'Paramter P_end_personn '
457: || p_end_person
458: );

Line 455: fnd_file.LOG,

451: 'Paramter P_end_personn '
452: || p_end_person
453: );
454: fnd_file.put_line (
455: fnd_file.LOG,
456: 'Paramter P_end_personn '
457: || p_end_person
458: );
459: fnd_file.put_line (

Line 459: fnd_file.put_line (

455: fnd_file.LOG,
456: 'Paramter P_end_personn '
457: || p_end_person
458: );
459: fnd_file.put_line (
460: fnd_file.LOG,
461: 'Paramter P_end_personn '
462: || p_end_person
463: );

Line 460: fnd_file.LOG,

456: 'Paramter P_end_personn '
457: || p_end_person
458: );
459: fnd_file.put_line (
460: fnd_file.LOG,
461: 'Paramter P_end_personn '
462: || p_end_person
463: );
464: fnd_file.put_line (

Line 464: fnd_file.put_line (

460: fnd_file.LOG,
461: 'Paramter P_end_personn '
462: || p_end_person
463: );
464: fnd_file.put_line (
465: fnd_file.LOG,
466: 'g_run_payroll_action_id'
467: || g_run_payroll_action_id
468: );

Line 465: fnd_file.LOG,

461: 'Paramter P_end_personn '
462: || p_end_person
463: );
464: fnd_file.put_line (
465: fnd_file.LOG,
466: 'g_run_payroll_action_id'
467: || g_run_payroll_action_id
468: );
469:

Line 475: fnd_file.put_line (fnd_file.LOG, ' Before the Locking Cursor ');

471: THEN
472: l_prepay_action_id := 0;
473:
474: l_assignment := 0;
475: fnd_file.put_line (fnd_file.LOG, ' Before the Locking Cursor ');
476:
477: -- this is for all the person's assignment actionid under the selected legal employer
478: FOR rec_prepaid_assignments IN
479: csr_prepaid_assignments (

Line 487: fnd_file.put_line (

483: g_run_payroll_action_id,
484: g_business_group_id
485: )
486: LOOP
487: fnd_file.put_line (
488: fnd_file.LOG,
489: ' Inside the Csr Prepaid Cursor '
490: );
491:

Line 488: fnd_file.LOG,

484: g_business_group_id
485: )
486: LOOP
487: fnd_file.put_line (
488: fnd_file.LOG,
489: ' Inside the Csr Prepaid Cursor '
490: );
491:
492:

Line 508: fnd_file.put_line (

504: + 1;
505: g_lock_table (g_index_assact).archive_assact_id := l_actid;
506: /* For Element archival */
507: -- Create the archive assignment action
508: fnd_file.put_line (
509: fnd_file.LOG,
510: 'l_actid'
511: || l_actid
512: || ' rec_prepaid_assignments.assignment_id'

Line 509: fnd_file.LOG,

505: g_lock_table (g_index_assact).archive_assact_id := l_actid;
506: /* For Element archival */
507: -- Create the archive assignment action
508: fnd_file.put_line (
509: fnd_file.LOG,
510: 'l_actid'
511: || l_actid
512: || ' rec_prepaid_assignments.assignment_id'
513: || rec_prepaid_assignments.assignment_id

Line 537: fnd_file.put_line (

533: l_assignment := rec_prepaid_assignments.assignment_id;
534: END LOOP;
535: END IF; --ARCHIVE
536:
537: fnd_file.put_line (
538: fnd_file.LOG,
539: ' After Ending Assignment Act Code the Locking Cursor '
540: );
541:

Line 538: fnd_file.LOG,

534: END LOOP;
535: END IF; --ARCHIVE
536:
537: fnd_file.put_line (
538: fnd_file.LOG,
539: ' After Ending Assignment Act Code the Locking Cursor '
540: );
541:
542: IF g_debug

Line 563: fnd_file.put_line (fnd_file.LOG, 'In INIT_CODE 0');

559: 80
560: );
561: END IF;
562:
563: fnd_file.put_line (fnd_file.LOG, 'In INIT_CODE 0');
564:
565: IF g_debug
566: THEN
567: hr_utility.set_location (

Line 688: fnd_file.put_line (fnd_file.LOG, 'Entering ARCHIVE_CODE ');

684:
685: --
686: --
687: --
688: fnd_file.put_line (fnd_file.LOG, 'Entering ARCHIVE_CODE ');
689: OPEN csr_person_details (g_business_group_id);
690: FETCH csr_person_details INTO lr_person_details;
691: CLOSE csr_person_details;
692: -- l_employee_pin := lr_person_details.national_identifier;

Line 710: fnd_file.put_line (

706: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
707: CLOSE csr_Get_Defined_Balance_Id;
708:
709: l_benefits :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id, P_ASSIGNMENT_ID =>lr_person_details.assignment_id , P_VIRTUAL_DATE => g_pay_period_end_date );
710: fnd_file.put_line (
711: fnd_file.LOG,
712: ' l_benefits'||l_benefits
713:
714: );

Line 711: fnd_file.LOG,

707: CLOSE csr_Get_Defined_Balance_Id;
708:
709: l_benefits :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id, P_ASSIGNMENT_ID =>lr_person_details.assignment_id , P_VIRTUAL_DATE => g_pay_period_end_date );
710: fnd_file.put_line (
711: fnd_file.LOG,
712: ' l_benefits'||l_benefits
713:
714: );
715:

Line 876: fnd_file.put_line ( fnd_file.LOG,

872: OPEN csr_get_run_ass_action_id (p_assignment_action_id);
873: FETCH csr_get_run_ass_action_id INTO lr_get_run_ass_action_id ;
874: CLOSE csr_get_run_ass_action_id ;
875:
876: fnd_file.put_line ( fnd_file.LOG,
877: 'p_balance_name'
878: || p_balance_name
879: );
880: fnd_file.put_line ( fnd_file.LOG,

Line 880: fnd_file.put_line ( fnd_file.LOG,

876: fnd_file.put_line ( fnd_file.LOG,
877: 'p_balance_name'
878: || p_balance_name
879: );
880: fnd_file.put_line ( fnd_file.LOG,
881: 'lr_get_defined_balance_id '
882: || lr_get_defined_balance_id
883: );
884: fnd_file.put_line ( fnd_file.LOG,

Line 884: fnd_file.put_line ( fnd_file.LOG,

880: fnd_file.put_line ( fnd_file.LOG,
881: 'lr_get_defined_balance_id '
882: || lr_get_defined_balance_id
883: );
884: fnd_file.put_line ( fnd_file.LOG,
885: 'p_assignment_action_id '
886: || p_assignment_action_id
887: );
888: fnd_file.put_line ( fnd_file.LOG,

Line 888: fnd_file.put_line ( fnd_file.LOG,

884: fnd_file.put_line ( fnd_file.LOG,
885: 'p_assignment_action_id '
886: || p_assignment_action_id
887: );
888: fnd_file.put_line ( fnd_file.LOG,
889: 'lr_get_run_ass_action_id'
890: || lr_get_run_ass_action_id
891: );
892: