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.PAY_SE_HOLIDAY_PAY_DEBT dependencies on FND_FILE

Line 203: fnd_file.put_line (fnd_file.LOG

199: lr_parameter_info csr_parameter_info%ROWTYPE;
200: l_proc VARCHAR2 (240)
201: := g_package || ' GET_ALL_PARAMETERS ';
202: BEGIN
203: fnd_file.put_line (fnd_file.LOG
204: , 'Entering Procedure GET_ALL_PARAMETER '
205: );
206: fnd_file.put_line (fnd_file.LOG
207: , 'Payroill Action iD ' || p_payroll_action_id

Line 206: fnd_file.put_line (fnd_file.LOG

202: BEGIN
203: fnd_file.put_line (fnd_file.LOG
204: , 'Entering Procedure GET_ALL_PARAMETER '
205: );
206: fnd_file.put_line (fnd_file.LOG
207: , 'Payroill Action iD ' || p_payroll_action_id
208: );
209:
210: OPEN csr_parameter_info (p_payroll_action_id);

Line 219: fnd_file.put_line (fnd_file.LOG

215:
216: CLOSE csr_parameter_info;
217:
218: p_legal_employer_id := lr_parameter_info.legal;
219: fnd_file.put_line (fnd_file.LOG
220: , 'lr_parameter_info.Legal '
221: || lr_parameter_info.legal
222: );
223: p_request_for_all_or_not := lr_parameter_info.request_for;

Line 224: fnd_file.put_line (fnd_file.LOG

220: , 'lr_parameter_info.Legal '
221: || lr_parameter_info.legal
222: );
223: p_request_for_all_or_not := lr_parameter_info.request_for;
224: fnd_file.put_line (fnd_file.LOG
225: , 'lr_parameter_info.REQUEST_FOR '
226: || lr_parameter_info.request_for
227: );
228: fnd_file.put_line (fnd_file.LOG

Line 228: fnd_file.put_line (fnd_file.LOG

224: fnd_file.put_line (fnd_file.LOG
225: , 'lr_parameter_info.REQUEST_FOR '
226: || lr_parameter_info.request_for
227: );
228: fnd_file.put_line (fnd_file.LOG
229: , 'lr_parameter_info.EFF_START_DATE '
230: || lr_parameter_info.eff_start_date
231: );
232: p_start_date :=

Line 234: fnd_file.put_line (fnd_file.LOG

230: || lr_parameter_info.eff_start_date
231: );
232: p_start_date :=
233: fnd_date.canonical_to_date (lr_parameter_info.eff_start_date);
234: fnd_file.put_line (fnd_file.LOG
235: , 'lr_parameter_info.EFF_END_DATE '
236: || lr_parameter_info.eff_end_date
237: );
238: p_end_date :=

Line 240: fnd_file.put_line (fnd_file.LOG

236: || lr_parameter_info.eff_end_date
237: );
238: p_end_date :=
239: fnd_date.canonical_to_date (lr_parameter_info.eff_end_date);
240: fnd_file.put_line (fnd_file.LOG
241: , 'lr_parameter_info.Effective_date '
242: || lr_parameter_info.effective_date
243: );
244: p_effective_date := lr_parameter_info.effective_date;

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

242: || lr_parameter_info.effective_date
243: );
244: p_effective_date := lr_parameter_info.effective_date;
245: p_business_group_id := lr_parameter_info.bg_id;
246: fnd_file.put_line (fnd_file.LOG, 'After csr_parameter_info in ');
247: --fnd_file.put_line(fnd_file.log,'After p_pension_provider_id ' || p_pension_provider_id);
248: fnd_file.put_line (fnd_file.LOG
249: , 'After p_legal_employer_id in '
250: || p_legal_employer_id

Line 247: --fnd_file.put_line(fnd_file.log,'After p_pension_provider_id ' || p_pension_provider_id);

243: );
244: p_effective_date := lr_parameter_info.effective_date;
245: p_business_group_id := lr_parameter_info.bg_id;
246: fnd_file.put_line (fnd_file.LOG, 'After csr_parameter_info in ');
247: --fnd_file.put_line(fnd_file.log,'After p_pension_provider_id ' || p_pension_provider_id);
248: fnd_file.put_line (fnd_file.LOG
249: , 'After p_legal_employer_id in '
250: || p_legal_employer_id
251: );

Line 248: fnd_file.put_line (fnd_file.LOG

244: p_effective_date := lr_parameter_info.effective_date;
245: p_business_group_id := lr_parameter_info.bg_id;
246: fnd_file.put_line (fnd_file.LOG, 'After csr_parameter_info in ');
247: --fnd_file.put_line(fnd_file.log,'After p_pension_provider_id ' || p_pension_provider_id);
248: fnd_file.put_line (fnd_file.LOG
249: , 'After p_legal_employer_id in '
250: || p_legal_employer_id
251: );
252:

Line 253: --fnd_file.put_line(fnd_file.log,'After p_local_unit_id in ' || p_local_unit_id );

249: , 'After p_legal_employer_id in '
250: || p_legal_employer_id
251: );
252:
253: --fnd_file.put_line(fnd_file.log,'After p_local_unit_id in ' || p_local_unit_id );
254: --fnd_file.put_line(fnd_file.log,'After p_archive' || p_archive );
255: IF g_debug
256: THEN
257: hr_utility.set_location (' Leaving Procedure GET_ALL_PARAMETERS'

Line 254: --fnd_file.put_line(fnd_file.log,'After p_archive' || p_archive );

250: || p_legal_employer_id
251: );
252:
253: --fnd_file.put_line(fnd_file.log,'After p_local_unit_id in ' || p_local_unit_id );
254: --fnd_file.put_line(fnd_file.log,'After p_archive' || p_archive );
255: IF g_debug
256: THEN
257: hr_utility.set_location (' Leaving Procedure GET_ALL_PARAMETERS'
258: , 30);

Line 343: fnd_file.put_line (fnd_file.LOG, 'In RANGE_CODE 0');

339:
340: l_le_has_employee VARCHAR2 (2);
341: -- Archiving the data , as this will fire once
342: BEGIN
343: fnd_file.put_line (fnd_file.LOG, 'In RANGE_CODE 0');
344:
345: IF g_debug
346: THEN
347: hr_utility.set_location (' Entering Procedure RANGE_CODE', 40);

Line 371: fnd_file.put_line (fnd_file.LOG

367: , g_request_for
368: , g_start_date
369: , g_end_date
370: );
371: fnd_file.put_line (fnd_file.LOG
372: , 'Range Legal Emp ID ==> '
373: || g_legal_employer_id
374: );
375:

Line 386: fnd_file.put_line (fnd_file.LOG

382:
383: CLOSE csr_legal_employer_details;
384:
385: -- *****************************************************************************
386: fnd_file.put_line (fnd_file.LOG
387: , 'After CURSOR Legal Emp DETAILS ==> '
388: || g_legal_employer_id
389: );
390: -- *****************************************************************************

Line 415: fnd_file.put_line (fnd_file.LOG

411: , p_action_information9 => NULL
412: , p_action_information10 => NULL
413: );
414: -- *****************************************************************************
415: fnd_file.put_line (fnd_file.LOG
416: , ' ================ ALL ================ '
417: );
418: --fnd_file.put_line(fnd_file.log,'PENSION provider name ==> '||lr_pension_provider_details.NAME );
419: --fnd_file.put_line(fnd_file.log,'PENSION provider ID ==> '||g_pension_provider_id);

Line 418: --fnd_file.put_line(fnd_file.log,'PENSION provider name ==> '||lr_pension_provider_details.NAME );

414: -- *****************************************************************************
415: fnd_file.put_line (fnd_file.LOG
416: , ' ================ ALL ================ '
417: );
418: --fnd_file.put_line(fnd_file.log,'PENSION provider name ==> '||lr_pension_provider_details.NAME );
419: --fnd_file.put_line(fnd_file.log,'PENSION provider ID ==> '||g_pension_provider_id);
420: fnd_file.put_line (fnd_file.LOG
421: , 'Legal Emp Name ==> '
422: || l_legal_employer_details.legal_employer_name

Line 419: --fnd_file.put_line(fnd_file.log,'PENSION provider ID ==> '||g_pension_provider_id);

415: fnd_file.put_line (fnd_file.LOG
416: , ' ================ ALL ================ '
417: );
418: --fnd_file.put_line(fnd_file.log,'PENSION provider name ==> '||lr_pension_provider_details.NAME );
419: --fnd_file.put_line(fnd_file.log,'PENSION provider ID ==> '||g_pension_provider_id);
420: fnd_file.put_line (fnd_file.LOG
421: , 'Legal Emp Name ==> '
422: || l_legal_employer_details.legal_employer_name
423: );

Line 420: fnd_file.put_line (fnd_file.LOG

416: , ' ================ ALL ================ '
417: );
418: --fnd_file.put_line(fnd_file.log,'PENSION provider name ==> '||lr_pension_provider_details.NAME );
419: --fnd_file.put_line(fnd_file.log,'PENSION provider ID ==> '||g_pension_provider_id);
420: fnd_file.put_line (fnd_file.LOG
421: , 'Legal Emp Name ==> '
422: || l_legal_employer_details.legal_employer_name
423: );
424: fnd_file.put_line (fnd_file.LOG

Line 424: fnd_file.put_line (fnd_file.LOG

420: fnd_file.put_line (fnd_file.LOG
421: , 'Legal Emp Name ==> '
422: || l_legal_employer_details.legal_employer_name
423: );
424: fnd_file.put_line (fnd_file.LOG
425: , 'Legal Emp ID ==> ' || g_legal_employer_id
426: );
427: fnd_file.put_line (fnd_file.LOG
428: , 'g_request_for ==> ' || g_request_for

Line 427: fnd_file.put_line (fnd_file.LOG

423: );
424: fnd_file.put_line (fnd_file.LOG
425: , 'Legal Emp ID ==> ' || g_legal_employer_id
426: );
427: fnd_file.put_line (fnd_file.LOG
428: , 'g_request_for ==> ' || g_request_for
429: );
430: --fnd_file.put_line(fnd_file.log,'Local Unit ID ==> '||g_local_unit_id);
431: --fnd_file.put_line(fnd_file.log,'acti_info_id ==> '||l_action_info_id );

Line 430: --fnd_file.put_line(fnd_file.log,'Local Unit ID ==> '||g_local_unit_id);

426: );
427: fnd_file.put_line (fnd_file.LOG
428: , 'g_request_for ==> ' || g_request_for
429: );
430: --fnd_file.put_line(fnd_file.log,'Local Unit ID ==> '||g_local_unit_id);
431: --fnd_file.put_line(fnd_file.log,'acti_info_id ==> '||l_action_info_id );
432: fnd_file.put_line (fnd_file.LOG, ' ================================ ');
433:
434: -- *****************************************************************************

Line 431: --fnd_file.put_line(fnd_file.log,'acti_info_id ==> '||l_action_info_id );

427: fnd_file.put_line (fnd_file.LOG
428: , 'g_request_for ==> ' || g_request_for
429: );
430: --fnd_file.put_line(fnd_file.log,'Local Unit ID ==> '||g_local_unit_id);
431: --fnd_file.put_line(fnd_file.log,'acti_info_id ==> '||l_action_info_id );
432: fnd_file.put_line (fnd_file.LOG, ' ================================ ');
433:
434: -- *****************************************************************************
435: IF g_request_for = 'REQUESTING_ORG'

Line 432: fnd_file.put_line (fnd_file.LOG, ' ================================ ');

428: , 'g_request_for ==> ' || g_request_for
429: );
430: --fnd_file.put_line(fnd_file.log,'Local Unit ID ==> '||g_local_unit_id);
431: --fnd_file.put_line(fnd_file.log,'acti_info_id ==> '||l_action_info_id );
432: fnd_file.put_line (fnd_file.LOG, ' ================================ ');
433:
434: -- *****************************************************************************
435: IF g_request_for = 'REQUESTING_ORG'
436: THEN

Line 640: fnd_file.put_line (fnd_file.LOG, ' ASSIGNMENT_ACTION_CODE ');

636: , 60
637: );
638: END IF;
639:
640: fnd_file.put_line (fnd_file.LOG, ' ASSIGNMENT_ACTION_CODE ');
641: pay_se_holiday_pay_debt.get_all_parameters (p_payroll_action_id
642: , g_business_group_id
643: , g_effective_date
644: , g_legal_employer_id

Line 652: --fnd_file.put_line(fnd_file.log,' g_local_unit_id '|| g_local_unit_id);

648: );
649: l_canonical_start_date := g_start_date;
650: l_canonical_end_date := g_end_date;
651: l_prepay_action_id := 0;
652: --fnd_file.put_line(fnd_file.log,' g_local_unit_id '|| g_local_unit_id);
653:
654: --fnd_file.put_line(fnd_file.log,' INSIDE IF LOCAL UNIT NOT NULL ');
655: fnd_file.put_line (fnd_file.LOG
656: , ' p_payroll_action_id ==> ' || p_payroll_action_id

Line 654: --fnd_file.put_line(fnd_file.log,' INSIDE IF LOCAL UNIT NOT NULL ');

650: l_canonical_end_date := g_end_date;
651: l_prepay_action_id := 0;
652: --fnd_file.put_line(fnd_file.log,' g_local_unit_id '|| g_local_unit_id);
653:
654: --fnd_file.put_line(fnd_file.log,' INSIDE IF LOCAL UNIT NOT NULL ');
655: fnd_file.put_line (fnd_file.LOG
656: , ' p_payroll_action_id ==> ' || p_payroll_action_id
657: );
658: fnd_file.put_line (fnd_file.LOG

Line 655: fnd_file.put_line (fnd_file.LOG

651: l_prepay_action_id := 0;
652: --fnd_file.put_line(fnd_file.log,' g_local_unit_id '|| g_local_unit_id);
653:
654: --fnd_file.put_line(fnd_file.log,' INSIDE IF LOCAL UNIT NOT NULL ');
655: fnd_file.put_line (fnd_file.LOG
656: , ' p_payroll_action_id ==> ' || p_payroll_action_id
657: );
658: fnd_file.put_line (fnd_file.LOG
659: , ' g_legal_employer_id ==> ' || g_legal_employer_id

Line 658: fnd_file.put_line (fnd_file.LOG

654: --fnd_file.put_line(fnd_file.log,' INSIDE IF LOCAL UNIT NOT NULL ');
655: fnd_file.put_line (fnd_file.LOG
656: , ' p_payroll_action_id ==> ' || p_payroll_action_id
657: );
658: fnd_file.put_line (fnd_file.LOG
659: , ' g_legal_employer_id ==> ' || g_legal_employer_id
660: );
661: --fnd_file.put_line(fnd_file.log,' g_local_unit_id ==> ' || g_local_unit_id);
662: --fnd_file.put_line(fnd_file.log,' g_pension_provider_id ==> ' || g_pension_provider_id);

Line 661: --fnd_file.put_line(fnd_file.log,' g_local_unit_id ==> ' || g_local_unit_id);

657: );
658: fnd_file.put_line (fnd_file.LOG
659: , ' g_legal_employer_id ==> ' || g_legal_employer_id
660: );
661: --fnd_file.put_line(fnd_file.log,' g_local_unit_id ==> ' || g_local_unit_id);
662: --fnd_file.put_line(fnd_file.log,' g_pension_provider_id ==> ' || g_pension_provider_id);
663: fnd_file.put_line (fnd_file.LOG
664: , ' g_effective_date ==> ' || g_effective_date
665: );

Line 662: --fnd_file.put_line(fnd_file.log,' g_pension_provider_id ==> ' || g_pension_provider_id);

658: fnd_file.put_line (fnd_file.LOG
659: , ' g_legal_employer_id ==> ' || g_legal_employer_id
660: );
661: --fnd_file.put_line(fnd_file.log,' g_local_unit_id ==> ' || g_local_unit_id);
662: --fnd_file.put_line(fnd_file.log,' g_pension_provider_id ==> ' || g_pension_provider_id);
663: fnd_file.put_line (fnd_file.LOG
664: , ' g_effective_date ==> ' || g_effective_date
665: );
666: fnd_file.put_line (fnd_file.LOG

Line 663: fnd_file.put_line (fnd_file.LOG

659: , ' g_legal_employer_id ==> ' || g_legal_employer_id
660: );
661: --fnd_file.put_line(fnd_file.log,' g_local_unit_id ==> ' || g_local_unit_id);
662: --fnd_file.put_line(fnd_file.log,' g_pension_provider_id ==> ' || g_pension_provider_id);
663: fnd_file.put_line (fnd_file.LOG
664: , ' g_effective_date ==> ' || g_effective_date
665: );
666: fnd_file.put_line (fnd_file.LOG
667: , ' l_canonical_start_date ==> '

Line 666: fnd_file.put_line (fnd_file.LOG

662: --fnd_file.put_line(fnd_file.log,' g_pension_provider_id ==> ' || g_pension_provider_id);
663: fnd_file.put_line (fnd_file.LOG
664: , ' g_effective_date ==> ' || g_effective_date
665: );
666: fnd_file.put_line (fnd_file.LOG
667: , ' l_canonical_start_date ==> '
668: || l_canonical_start_date
669: );
670: fnd_file.put_line (fnd_file.LOG

Line 670: fnd_file.put_line (fnd_file.LOG

666: fnd_file.put_line (fnd_file.LOG
667: , ' l_canonical_start_date ==> '
668: || l_canonical_start_date
669: );
670: fnd_file.put_line (fnd_file.LOG
671: , ' l_canonical_end_date ==> ' || l_canonical_end_date
672: );
673:
674: --fnd_file.put_line(fnd_file.log,' INSIDE ELS LOCAL UNIT NULL ');

Line 674: --fnd_file.put_line(fnd_file.log,' INSIDE ELS LOCAL UNIT NULL ');

670: fnd_file.put_line (fnd_file.LOG
671: , ' l_canonical_end_date ==> ' || l_canonical_end_date
672: );
673:
674: --fnd_file.put_line(fnd_file.log,' INSIDE ELS LOCAL UNIT NULL ');
675: l_assignment_id := 0;
676: FOR rec_prepaid_assignments IN
677: csr_prepaid_assignments_le (p_payroll_action_id
678: , p_start_person

Line 685: --fnd_file.put_line(fnd_file.log,' LE Inside the Csr Prepaid Cursor ');

681: , l_canonical_start_date
682: , l_canonical_end_date
683: )
684: LOOP
685: --fnd_file.put_line(fnd_file.log,' LE Inside the Csr Prepaid Cursor ');
686: IF l_assignment_id <> rec_prepaid_assignments.assignment_id
687: THEN
688: SELECT pay_assignment_actions_s.NEXTVAL
689: INTO l_actid

Line 709: fnd_file.put_line

705: --hr_nonrun_asact.insint(l_actid,rec_prepaid_assignments.run_action_id);
706: l_assignment_id := rec_prepaid_assignments.assignment_id;
707: END LOOP;
708:
709: fnd_file.put_line
710: (fnd_file.LOG
711: , ' After Ending Assignment Act Code the Locking Cursor '
712: );
713:

Line 710: (fnd_file.LOG

706: l_assignment_id := rec_prepaid_assignments.assignment_id;
707: END LOOP;
708:
709: fnd_file.put_line
710: (fnd_file.LOG
711: , ' After Ending Assignment Act Code the Locking Cursor '
712: );
713:
714: IF g_debug

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

753: , 80
754: );
755: END IF;
756:
757: fnd_file.put_line (fnd_file.LOG, 'In INIT_CODE 0');
758: g_payroll_action_id := p_payroll_action_id;
759: g_business_group_id := NULL;
760: g_effective_date := NULL;
761: g_legal_employer_id := NULL;

Line 770: fnd_file.put_line

766: , g_request_for
767: , g_start_date
768: , g_end_date
769: );
770: fnd_file.put_line
771: (fnd_file.LOG
772: , 'In the INITIALIZATION_CODE After Initiliazing the global parameter '
773: );
774:

Line 771: (fnd_file.LOG

767: , g_start_date
768: , g_end_date
769: );
770: fnd_file.put_line
771: (fnd_file.LOG
772: , 'In the INITIALIZATION_CODE After Initiliazing the global parameter '
773: );
774:
775: IF g_debug

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

1042: THEN
1043: hr_utility.set_location (' Entering Procedure ARCHIVE_CODE', 380);
1044: END IF;
1045:
1046: fnd_file.put_line (fnd_file.LOG, 'Entering ARCHIVE_CODE ');
1047:
1048: -- *****************************************************************************
1049: -- TO pick up the PIN
1050: OPEN csr_get_person_details (p_assignment_action_id);

Line 1076: fnd_file.put_line (fnd_file.LOG

1072: END IF;
1073:
1074: l_employee_number := lr_get_person_details.assignment_number;
1075: l_employee_code := lr_get_person_details.employee_category;
1076: fnd_file.put_line (fnd_file.LOG
1077: , ' ==============PERSON================== '
1078: );
1079: fnd_file.put_line (fnd_file.LOG
1080: , 'l_Employee_Pin ==> ' || l_employee_pin

Line 1079: fnd_file.put_line (fnd_file.LOG

1075: l_employee_code := lr_get_person_details.employee_category;
1076: fnd_file.put_line (fnd_file.LOG
1077: , ' ==============PERSON================== '
1078: );
1079: fnd_file.put_line (fnd_file.LOG
1080: , 'l_Employee_Pin ==> ' || l_employee_pin
1081: );
1082: fnd_file.put_line (fnd_file.LOG
1083: , 'l_Employee_name ==> ' || l_employee_name

Line 1082: fnd_file.put_line (fnd_file.LOG

1078: );
1079: fnd_file.put_line (fnd_file.LOG
1080: , 'l_Employee_Pin ==> ' || l_employee_pin
1081: );
1082: fnd_file.put_line (fnd_file.LOG
1083: , 'l_Employee_name ==> ' || l_employee_name
1084: );
1085: fnd_file.put_line (fnd_file.LOG, ' ================================ ');
1086:

Line 1085: fnd_file.put_line (fnd_file.LOG, ' ================================ ');

1081: );
1082: fnd_file.put_line (fnd_file.LOG
1083: , 'l_Employee_name ==> ' || l_employee_name
1084: );
1085: fnd_file.put_line (fnd_file.LOG, ' ================================ ');
1086:
1087: -- *****************************************************************************
1088: -- TO pick up the Local Unit Sub-disbursement Number
1089: OPEN csr_get_segment2 ();

Line 1109: fnd_file.put_line (fnd_file.LOG

1105: l_legal_employer_id_fetched := lr_find_legal_employer.legal_id;
1106: -- *****************************************************************************
1107: -- Pick up Person ID
1108: l_person_id := lr_get_person_details.person_id;
1109: fnd_file.put_line (fnd_file.LOG
1110: , 'l_person_id ==> ' || l_person_id
1111: );
1112: -- *****************************************************************************
1113:

Line 1117: fnd_file.put_line (fnd_file.LOG

1113:
1114: -- *****************************************************************************
1115: -- Pick up the Balance value
1116: l_assignment_id := lr_get_person_details.assignment_id;
1117: fnd_file.put_line (fnd_file.LOG
1118: , 'l_assignment_id ==> ' || l_assignment_id
1119: );
1120:
1121: -- *****************************************************************************

Line 1124: fnd_file.put_line (fnd_file.LOG

1120:
1121: -- *****************************************************************************
1122: -- Setting the context
1123: BEGIN
1124: fnd_file.put_line (fnd_file.LOG
1125: , 'l_assignment_id ==> ' || l_assignment_id
1126: );
1127: pay_balance_pkg.set_context ('ASSIGNMENT_ID', l_assignment_id);
1128: fnd_file.put_line (fnd_file.LOG

Line 1128: fnd_file.put_line (fnd_file.LOG

1124: fnd_file.put_line (fnd_file.LOG
1125: , 'l_assignment_id ==> ' || l_assignment_id
1126: );
1127: pay_balance_pkg.set_context ('ASSIGNMENT_ID', l_assignment_id);
1128: fnd_file.put_line (fnd_file.LOG
1129: , 'L_LEGAL_EMPLOYER_ID_FETCHED ==> '
1130: || l_legal_employer_id_fetched
1131: );
1132: pay_balance_pkg.set_context ('TAX_UNIT_ID'

Line 1135: fnd_file.put_line (fnd_file.LOG

1131: );
1132: pay_balance_pkg.set_context ('TAX_UNIT_ID'
1133: , l_legal_employer_id_fetched
1134: );
1135: fnd_file.put_line (fnd_file.LOG
1136: , 'l_local_unit_id_fetched ==> '
1137: || l_local_unit_id_fetched
1138: );
1139: pay_balance_pkg.set_context ('LOCAL_UNIT_ID'

Line 1141: fnd_file.put_line (fnd_file.LOG, 'G_END_DATE ==> ' || g_end_date);

1137: || l_local_unit_id_fetched
1138: );
1139: pay_balance_pkg.set_context ('LOCAL_UNIT_ID'
1140: , l_local_unit_id_fetched);
1141: fnd_file.put_line (fnd_file.LOG, 'G_END_DATE ==> ' || g_end_date);
1142: pay_balance_pkg.set_context ('DATE_EARNED', g_end_date);
1143: fnd_file.put_line (fnd_file.LOG
1144: , 'l_assignment_id ==> ' || l_assignment_id
1145: );

Line 1143: fnd_file.put_line (fnd_file.LOG

1139: pay_balance_pkg.set_context ('LOCAL_UNIT_ID'
1140: , l_local_unit_id_fetched);
1141: fnd_file.put_line (fnd_file.LOG, 'G_END_DATE ==> ' || g_end_date);
1142: pay_balance_pkg.set_context ('DATE_EARNED', g_end_date);
1143: fnd_file.put_line (fnd_file.LOG
1144: , 'l_assignment_id ==> ' || l_assignment_id
1145: );
1146: pay_balance_pkg.set_context ('JURISDICTION_CODE', NULL);
1147: pay_balance_pkg.set_context ('SOURCE_ID', NULL);

Line 1167: fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> ' ||lr_Get_Defined_Balance_Id.creator_id );

1163: /* OPEN csr_Get_Defined_Balance_Id( 'HOLIDAY_PAY_PER_DAY_ASG_LE_HY_YEAR');
1164: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1165: CLOSE csr_Get_Defined_Balance_Id;
1166:
1167: fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> ' ||lr_Get_Defined_Balance_Id.creator_id );
1168: --fnd_file.put_line(fnd_file.log,'g_effective_date ==> ' ||g_effective_date );
1169:
1170: L_HOLIDAY_PAY_PER_DAY :=to_char(pay_balance_pkg.get_value
1171: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,

Line 1168: --fnd_file.put_line(fnd_file.log,'g_effective_date ==> ' ||g_effective_date );

1164: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1165: CLOSE csr_Get_Defined_Balance_Id;
1166:
1167: fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> ' ||lr_Get_Defined_Balance_Id.creator_id );
1168: --fnd_file.put_line(fnd_file.log,'g_effective_date ==> ' ||g_effective_date );
1169:
1170: L_HOLIDAY_PAY_PER_DAY :=to_char(pay_balance_pkg.get_value
1171: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1172: P_ASSIGNMENT_ID =>l_assignment_id ,

Line 1179: fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> ' ||lr_Get_Defined_Balance_Id.creator_id );

1175: /* OPEN csr_Get_Defined_Balance_Id( 'TOTAL_PAID_HOLIDAY_DAYS_TAKEN_ASG_LE_HY_YEAR');
1176: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1177: CLOSE csr_Get_Defined_Balance_Id;
1178:
1179: fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> ' ||lr_Get_Defined_Balance_Id.creator_id );
1180: --fnd_file.put_line(fnd_file.log,'g_effective_date ==> ' ||g_effective_date );
1181:
1182: L_TOTAL_PAID_DAYS :=to_char(pay_balance_pkg.get_value
1183: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,

Line 1180: --fnd_file.put_line(fnd_file.log,'g_effective_date ==> ' ||g_effective_date );

1176: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1177: CLOSE csr_Get_Defined_Balance_Id;
1178:
1179: fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> ' ||lr_Get_Defined_Balance_Id.creator_id );
1180: --fnd_file.put_line(fnd_file.log,'g_effective_date ==> ' ||g_effective_date );
1181:
1182: L_TOTAL_PAID_DAYS :=to_char(pay_balance_pkg.get_value
1183: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1184: P_ASSIGNMENT_ID =>l_assignment_id ,

Line 1203: --fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> ' ||lr_Get_Defined_Balance_Id.creator_id );

1199: OPEN csr_Get_Defined_Balance_Id( 'TOTAL_HOLIDAY_PAY_ASG_LE_HY_YEAR');
1200: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1201: CLOSE csr_Get_Defined_Balance_Id;
1202:
1203: --fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> ' ||lr_Get_Defined_Balance_Id.creator_id );
1204: --fnd_file.put_line(fnd_file.log,'g_effective_date ==> ' ||g_effective_date );
1205:
1206: L_TOTAL_PAID_DAYS_AMOUNT :=to_char(pay_balance_pkg.get_value
1207: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,

Line 1204: --fnd_file.put_line(fnd_file.log,'g_effective_date ==> ' ||g_effective_date );

1200: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1201: CLOSE csr_Get_Defined_Balance_Id;
1202:
1203: --fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> ' ||lr_Get_Defined_Balance_Id.creator_id );
1204: --fnd_file.put_line(fnd_file.log,'g_effective_date ==> ' ||g_effective_date );
1205:
1206: L_TOTAL_PAID_DAYS_AMOUNT :=to_char(pay_balance_pkg.get_value
1207: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1208: P_ASSIGNMENT_ID =>l_assignment_id ,

Line 1226: --fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> ' ||lr_Get_Defined_Balance_Id.creator_id );

1222: OPEN csr_Get_Defined_Balance_Id( 'TOTAL_SAVED_HOLIDAY_DAYS_TAKEN_ASG_LE_HY_YEAR');
1223: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1224: CLOSE csr_Get_Defined_Balance_Id;
1225:
1226: --fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> ' ||lr_Get_Defined_Balance_Id.creator_id );
1227: --fnd_file.put_line(fnd_file.log,'g_effective_date ==> ' ||g_effective_date );
1228:
1229: L_TOTAL_SAVED_DAYS :=to_char(pay_balance_pkg.get_value
1230: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,

Line 1227: --fnd_file.put_line(fnd_file.log,'g_effective_date ==> ' ||g_effective_date );

1223: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1224: CLOSE csr_Get_Defined_Balance_Id;
1225:
1226: --fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> ' ||lr_Get_Defined_Balance_Id.creator_id );
1227: --fnd_file.put_line(fnd_file.log,'g_effective_date ==> ' ||g_effective_date );
1228:
1229: L_TOTAL_SAVED_DAYS :=to_char(pay_balance_pkg.get_value
1230: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1231: P_ASSIGNMENT_ID =>l_assignment_id ,

Line 1250: --fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> ' ||lr_Get_Defined_Balance_Id.creator_id );

1246: OPEN csr_Get_Defined_Balance_Id( 'TOTAL_SAVED_HOLIDAY_PAY_ASG_LE_HY_YEAR');
1247: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1248: CLOSE csr_Get_Defined_Balance_Id;
1249:
1250: --fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> ' ||lr_Get_Defined_Balance_Id.creator_id );
1251: --fnd_file.put_line(fnd_file.log,'g_effective_date ==> ' ||g_effective_date );
1252:
1253: L_TOTAL_SAVED_DAYS_AMOUNT :=to_char(pay_balance_pkg.get_value
1254: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,

Line 1251: --fnd_file.put_line(fnd_file.log,'g_effective_date ==> ' ||g_effective_date );

1247: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1248: CLOSE csr_Get_Defined_Balance_Id;
1249:
1250: --fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> ' ||lr_Get_Defined_Balance_Id.creator_id );
1251: --fnd_file.put_line(fnd_file.log,'g_effective_date ==> ' ||g_effective_date );
1252:
1253: L_TOTAL_SAVED_DAYS_AMOUNT :=to_char(pay_balance_pkg.get_value
1254: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1255: P_ASSIGNMENT_ID =>l_assignment_id ,

Line 1295: --fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> ' ||lr_Get_Defined_Balance_Id.creator_id );

1291: OPEN csr_Get_Defined_Balance_Id( 'TOTAL_PAID_HOLIDAY_DAYS_TAKEN_ASG_LE_HY_YEAR');
1292: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1293: CLOSE csr_Get_Defined_Balance_Id;
1294:
1295: --fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> ' ||lr_Get_Defined_Balance_Id.creator_id );
1296: --fnd_file.put_line(fnd_file.log,'g_effective_date ==> ' ||g_effective_date );
1297:
1298: L_TOTAL_EARNED_DAYS :=to_char(pay_balance_pkg.get_value
1299: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,

Line 1296: --fnd_file.put_line(fnd_file.log,'g_effective_date ==> ' ||g_effective_date );

1292: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1293: CLOSE csr_Get_Defined_Balance_Id;
1294:
1295: --fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> ' ||lr_Get_Defined_Balance_Id.creator_id );
1296: --fnd_file.put_line(fnd_file.log,'g_effective_date ==> ' ||g_effective_date );
1297:
1298: L_TOTAL_EARNED_DAYS :=to_char(pay_balance_pkg.get_value
1299: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1300: P_ASSIGNMENT_ID =>l_assignment_id ,

Line 1307: --fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> ' ||lr_Get_Defined_Balance_Id.creator_id );

1303: /* OPEN csr_Get_Defined_Balance_Id( 'TOTAL_PAID_HOLIDAY_DAYS_ASG_LE_HY_YEAR');
1304: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1305: CLOSE csr_Get_Defined_Balance_Id;
1306:
1307: --fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> ' ||lr_Get_Defined_Balance_Id.creator_id );
1308: --fnd_file.put_line(fnd_file.log,'g_effective_date ==> ' ||g_effective_date );
1309:
1310: L_TOTAL_EARNED_DAYS_AMOUNT :=to_char(pay_balance_pkg.get_value
1311: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,

Line 1308: --fnd_file.put_line(fnd_file.log,'g_effective_date ==> ' ||g_effective_date );

1304: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1305: CLOSE csr_Get_Defined_Balance_Id;
1306:
1307: --fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> ' ||lr_Get_Defined_Balance_Id.creator_id );
1308: --fnd_file.put_line(fnd_file.log,'g_effective_date ==> ' ||g_effective_date );
1309:
1310: L_TOTAL_EARNED_DAYS_AMOUNT :=to_char(pay_balance_pkg.get_value
1311: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1312: P_ASSIGNMENT_ID =>l_assignment_id ,

Line 1327: --fnd_file.put_line(fnd_file.log,'Not found In Archive record ' );

1323: AND action_context_id = p_assignment_action_id;
1324: EXCEPTION
1325: WHEN NO_DATA_FOUND
1326: THEN
1327: --fnd_file.put_line(fnd_file.log,'Not found In Archive record ' );
1328: fnd_file.put_line (fnd_file.LOG
1329: , 'g_payroll_action_id ' || g_payroll_action_id
1330: );
1331: pay_action_information_api.create_action_information

Line 1328: fnd_file.put_line (fnd_file.LOG

1324: EXCEPTION
1325: WHEN NO_DATA_FOUND
1326: THEN
1327: --fnd_file.put_line(fnd_file.log,'Not found In Archive record ' );
1328: fnd_file.put_line (fnd_file.LOG
1329: , 'g_payroll_action_id ' || g_payroll_action_id
1330: );
1331: pay_action_information_api.create_action_information
1332: (p_action_information_id => l_action_info_id

Line 1383: fnd_file.put_line (fnd_file.LOG

1379: , p_action_information29 => NULL
1380: , p_action_information30 => l_person_id
1381: , p_assignment_id => l_assignment_id
1382: );
1383: fnd_file.put_line (fnd_file.LOG
1384: , 'l_action_info_id ==> ' || l_action_info_id
1385: );
1386: fnd_file.put_line (fnd_file.LOG
1387: , 'l_action_info_id ==> ' || l_person_id

Line 1386: fnd_file.put_line (fnd_file.LOG

1382: );
1383: fnd_file.put_line (fnd_file.LOG
1384: , 'l_action_info_id ==> ' || l_action_info_id
1385: );
1386: fnd_file.put_line (fnd_file.LOG
1387: , 'l_action_info_id ==> ' || l_person_id
1388: );
1389: WHEN OTHERS
1390: THEN

Line 1395: fnd_file.put_line (fnd_file.LOG, 'Leaving Procedure ARCHIVE_CODE');

1391: NULL;
1392: END;
1393:
1394: --END IF;
1395: fnd_file.put_line (fnd_file.LOG, 'Leaving Procedure ARCHIVE_CODE');
1396:
1397: IF g_debug
1398: THEN
1399: hr_utility.set_location (' Leaving Procedure ARCHIVE_CODE', 390);

Line 1626: fnd_file.put_line (fnd_file.LOG, 'Entered Reporting');

1622: NULL;
1623: END;
1624: ELSE
1625: l_payroll_action_id := p_payroll_action_id;
1626: fnd_file.put_line (fnd_file.LOG, 'Entered Reporting');
1627: fnd_file.put_line (fnd_file.LOG
1628: , 'p_payroll_action_id ' || p_payroll_action_id
1629: );
1630:

Line 1627: fnd_file.put_line (fnd_file.LOG

1623: END;
1624: ELSE
1625: l_payroll_action_id := p_payroll_action_id;
1626: fnd_file.put_line (fnd_file.LOG, 'Entered Reporting');
1627: fnd_file.put_line (fnd_file.LOG
1628: , 'p_payroll_action_id ' || p_payroll_action_id
1629: );
1630:
1631: /* Structure of Xml should look like this

Line 1650: fnd_file.put_line (fnd_file.LOG, 'After csr_REPORT_DETAILS ');

1646: CLOSE csr_report_details;
1647:
1648: add_tag_value ('PERIOD_FROM', lr_report_details.period_from);
1649: add_tag_value ('PERIOD_TO', lr_report_details.period_to);
1650: fnd_file.put_line (fnd_file.LOG, 'After csr_REPORT_DETAILS ');
1651: fnd_file.put_line (fnd_file.LOG
1652: , 'PERIOD_FROM ' || lr_report_details.period_from
1653: );
1654: fnd_file.put_line (fnd_file.LOG

Line 1651: fnd_file.put_line (fnd_file.LOG

1647:
1648: add_tag_value ('PERIOD_FROM', lr_report_details.period_from);
1649: add_tag_value ('PERIOD_TO', lr_report_details.period_to);
1650: fnd_file.put_line (fnd_file.LOG, 'After csr_REPORT_DETAILS ');
1651: fnd_file.put_line (fnd_file.LOG
1652: , 'PERIOD_FROM ' || lr_report_details.period_from
1653: );
1654: fnd_file.put_line (fnd_file.LOG
1655: , 'PERIOD_TO ' || lr_report_details.period_to

Line 1654: fnd_file.put_line (fnd_file.LOG

1650: fnd_file.put_line (fnd_file.LOG, 'After csr_REPORT_DETAILS ');
1651: fnd_file.put_line (fnd_file.LOG
1652: , 'PERIOD_FROM ' || lr_report_details.period_from
1653: );
1654: fnd_file.put_line (fnd_file.LOG
1655: , 'PERIOD_TO ' || lr_report_details.period_to
1656: );
1657: fnd_file.put_line (fnd_file.LOG, 'Before Csr for Legal');
1658:

Line 1657: fnd_file.put_line (fnd_file.LOG, 'Before Csr for Legal');

1653: );
1654: fnd_file.put_line (fnd_file.LOG
1655: , 'PERIOD_TO ' || lr_report_details.period_to
1656: );
1657: fnd_file.put_line (fnd_file.LOG, 'Before Csr for Legal');
1658:
1659: FOR rec_all_le IN csr_all_legal_employer (l_payroll_action_id)
1660: LOOP
1661: add_tag_value ('LEGAL_EMPLOYER', 'LEGAL_EMPLOYER');

Line 1667: fnd_file.put_line (fnd_file.LOG, '^^^^^^^^^^^^^^^^^^^^^');

1663: add_tag_value ('LE_NAME', rec_all_le.action_information4);
1664: add_tag_value ('LE_ORG_NUM', rec_all_le.action_information5);
1665: add_tag_value ('LE_DETAILS', 'LE_DETAILS_END');
1666: add_tag_value ('EMPLOYEES', 'EMPLOYEES');
1667: fnd_file.put_line (fnd_file.LOG, '^^^^^^^^^^^^^^^^^^^^^');
1668: fnd_file.put_line (fnd_file.LOG, 'Legal Employer');
1669: fnd_file.put_line (fnd_file.LOG
1670: , 'LE ID ' || rec_all_le.action_information3
1671: );

Line 1668: fnd_file.put_line (fnd_file.LOG, 'Legal Employer');

1664: add_tag_value ('LE_ORG_NUM', rec_all_le.action_information5);
1665: add_tag_value ('LE_DETAILS', 'LE_DETAILS_END');
1666: add_tag_value ('EMPLOYEES', 'EMPLOYEES');
1667: fnd_file.put_line (fnd_file.LOG, '^^^^^^^^^^^^^^^^^^^^^');
1668: fnd_file.put_line (fnd_file.LOG, 'Legal Employer');
1669: fnd_file.put_line (fnd_file.LOG
1670: , 'LE ID ' || rec_all_le.action_information3
1671: );
1672: fnd_file.put_line (fnd_file.LOG

Line 1669: fnd_file.put_line (fnd_file.LOG

1665: add_tag_value ('LE_DETAILS', 'LE_DETAILS_END');
1666: add_tag_value ('EMPLOYEES', 'EMPLOYEES');
1667: fnd_file.put_line (fnd_file.LOG, '^^^^^^^^^^^^^^^^^^^^^');
1668: fnd_file.put_line (fnd_file.LOG, 'Legal Employer');
1669: fnd_file.put_line (fnd_file.LOG
1670: , 'LE ID ' || rec_all_le.action_information3
1671: );
1672: fnd_file.put_line (fnd_file.LOG
1673: , 'LE_NAME ' || rec_all_le.action_information4

Line 1672: fnd_file.put_line (fnd_file.LOG

1668: fnd_file.put_line (fnd_file.LOG, 'Legal Employer');
1669: fnd_file.put_line (fnd_file.LOG
1670: , 'LE ID ' || rec_all_le.action_information3
1671: );
1672: fnd_file.put_line (fnd_file.LOG
1673: , 'LE_NAME ' || rec_all_le.action_information4
1674: );
1675: fnd_file.put_line (fnd_file.LOG, '^^^^^^^^^^^^^^^^^^^^^');
1676: fnd_file.put_line (fnd_file.LOG, '^^^^^^^^^^^^^^^^^^^^^');

Line 1675: fnd_file.put_line (fnd_file.LOG, '^^^^^^^^^^^^^^^^^^^^^');

1671: );
1672: fnd_file.put_line (fnd_file.LOG
1673: , 'LE_NAME ' || rec_all_le.action_information4
1674: );
1675: fnd_file.put_line (fnd_file.LOG, '^^^^^^^^^^^^^^^^^^^^^');
1676: fnd_file.put_line (fnd_file.LOG, '^^^^^^^^^^^^^^^^^^^^^');
1677: fnd_file.put_line (fnd_file.LOG, ' Inside Person Query');
1678:
1679: FOR rec_all_emp_under_le IN

Line 1676: fnd_file.put_line (fnd_file.LOG, '^^^^^^^^^^^^^^^^^^^^^');

1672: fnd_file.put_line (fnd_file.LOG
1673: , 'LE_NAME ' || rec_all_le.action_information4
1674: );
1675: fnd_file.put_line (fnd_file.LOG, '^^^^^^^^^^^^^^^^^^^^^');
1676: fnd_file.put_line (fnd_file.LOG, '^^^^^^^^^^^^^^^^^^^^^');
1677: fnd_file.put_line (fnd_file.LOG, ' Inside Person Query');
1678:
1679: FOR rec_all_emp_under_le IN
1680: csr_all_employees_under_le (l_payroll_action_id

Line 1677: fnd_file.put_line (fnd_file.LOG, ' Inside Person Query');

1673: , 'LE_NAME ' || rec_all_le.action_information4
1674: );
1675: fnd_file.put_line (fnd_file.LOG, '^^^^^^^^^^^^^^^^^^^^^');
1676: fnd_file.put_line (fnd_file.LOG, '^^^^^^^^^^^^^^^^^^^^^');
1677: fnd_file.put_line (fnd_file.LOG, ' Inside Person Query');
1678:
1679: FOR rec_all_emp_under_le IN
1680: csr_all_employees_under_le (l_payroll_action_id
1681: , rec_all_le.action_information3

Line 1684: fnd_file.put_line (fnd_file.LOG

1680: csr_all_employees_under_le (l_payroll_action_id
1681: , rec_all_le.action_information3
1682: )
1683: LOOP
1684: fnd_file.put_line (fnd_file.LOG
1685: , 'PERSON ID ==> '
1686: || rec_all_emp_under_le.action_information30
1687: );
1688: add_tag_value ('PERSON', 'PERSON');

Line 1742: fnd_file.put_line (fnd_file.LOG, '^^^^^^^^^^^^^^^^^^^^^');

1738: );
1739: add_tag_value ('PERSON', 'PERSON_END');
1740: END LOOP; /* For all EMPLOYEES */
1741:
1742: fnd_file.put_line (fnd_file.LOG, '^^^^^^^^^^^^^^^^^^^^^');
1743: add_tag_value ('EMPLOYEES', 'EMPLOYEES_END');
1744: add_tag_value ('LEGAL_EMPLOYER', 'LEGAL_EMPLOYER_END');
1745: END LOOP; /* For all LEGAL_EMPLYER */
1746: END IF; /* for p_payroll_action_id IS NULL */