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_FI_ARCHIVE_LTFA dependencies on FND_FILE

Line 40: fnd_file.put_line(fnd_file.log,'Range Code 23'||p_token);

36: l_delimiter VARCHAR2(1):=' ';
37: l_proc VARCHAR2(240):= g_package||' get parameter ';
38: BEGIN
39: --
40: fnd_file.put_line(fnd_file.log,'Range Code 23'||p_token);
41: IF g_debug THEN
42: hr_utility.set_location(' Entering Function GET_PARAMETER',10);
43: END IF;
44: l_start_pos := instr(' '||p_parameter_string,l_delimiter||p_token||'=');

Line 71: --fnd_file.put_line(fnd_file.log,'Range Code 24');

67: IF g_debug THEN
68: hr_utility.set_location(' Leaving Function GET_PARAMETER',20);
69: END IF;
70:
71: --fnd_file.put_line(fnd_file.log,'Range Code 24');
72: RETURN l_parameter;
73:
74: END;
75:

Line 104: --fnd_file.put_line(fnd_file.log,'Range Code 21'||TO_CHAR(p_payroll_action_id));

100: l_proc VARCHAR2(240):= g_package||' GET_ALL_PARAMETERS ';
101: --
102: BEGIN
103:
104: --fnd_file.put_line(fnd_file.log,'Range Code 21'||TO_CHAR(p_payroll_action_id));
105:
106: OPEN csr_parameter_info (p_payroll_action_id);
107:
108: FETCH csr_parameter_info

Line 119: --fnd_file.put_line(fnd_file.log,'Range Code 22');

115: ,p_effective_date
116: ,p_business_group_id;
117: CLOSE csr_parameter_info;
118:
119: --fnd_file.put_line(fnd_file.log,'Range Code 22');
120: --
121: IF g_debug THEN
122: hr_utility.set_location(' Leaving Procedure GET_ALL_PARAMETERS',30);
123: END IF;

Line 124: --fnd_file.put_line(fnd_file.log,'Range Code 22222');

120: --
121: IF g_debug THEN
122: hr_utility.set_location(' Leaving Procedure GET_ALL_PARAMETERS',30);
123: END IF;
124: --fnd_file.put_line(fnd_file.log,'Range Code 22222');
125: END GET_ALL_PARAMETERS;
126:
127: /* RANGE CODE */
128: PROCEDURE RANGE_CODE (p_payroll_action_id IN NUMBER

Line 303: --fnd_file.put_line(fnd_file.log,'Range Code 1');

299: /* End of Cursors */
300:
301: BEGIN
302:
303: --fnd_file.put_line(fnd_file.log,'Range Code 1');
304:
305: IF g_debug THEN
306: hr_utility.set_location(' Entering Procedure RANGE_CODE',40);
307: END IF;

Line 327: --fnd_file.put_line(fnd_file.log,'Range Code 2');

323: g_le_assignment_action_id := NULL ;
324: g_lu_assignment_action_id := NULL ;
325:
326:
327: --fnd_file.put_line(fnd_file.log,'Range Code 2');
328: PAY_FI_ARCHIVE_LTFA.GET_ALL_PARAMETERS(
329: p_payroll_action_id
330: ,l_business_group_id
331: ,g_pension_ins_num

Line 340: --fnd_file.put_line(fnd_file.log,'Range Code 3');

336: ,g_effective_date
337: ,g_archive ) ;
338:
339:
340: --fnd_file.put_line(fnd_file.log,'Range Code 3');
341:
342: IF g_archive = 'Y' THEN
343:
344: SELECT count(*)

Line 355: --fnd_file.put_line(fnd_file.log,'Range Code 5');

351: IF l_count < 1 then
352:
353: l_dept_code:='';
354:
355: --fnd_file.put_line(fnd_file.log,'Range Code 5');
356: hr_utility.set_location('Entered Procedure GETDATA',10);
357:
358: OPEN csr_Legal_Emp_Details(g_legal_employer_id, g_pension_ins_num, g_effective_date);
359: FETCH csr_Legal_Emp_Details INTO rg_Legal_Emp_Details;

Line 366: --fnd_file.put_line(fnd_file.log,'Range Code 4');

362: l_le_name := rg_Legal_Emp_Details.name ;
363: --l_y_number := rg_Legal_Emp_Details.ORG_INFORMATION1 ;
364: g_pension_provider := rg_Legal_Emp_Details.ORG_INFORMATION4 ;
365:
366: --fnd_file.put_line(fnd_file.log,'Range Code 4');
367: BEGIN
368: pay_balance_pkg.set_context('TAX_UNIT_ID',g_legal_employer_id);
369: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_local_unit_id);
370: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_effective_date));

Line 397: --fnd_file.put_line(fnd_file.log,'Range Code 6');

393: */
394:
395: IF g_local_unit_id IS NOT NULL THEN
396:
397: --fnd_file.put_line(fnd_file.log,'Range Code 6');
398: BEGIN
399:
400: SELECT MAX(ASSIGNMENT_ACTION_ID)
401: INTO g_lu_assignment_action_id

Line 445: --fnd_file.put_line(fnd_file.log,'Range Code 7');

441:
442: l_customer_num :=rg_lu_pp_dtls.ORG_INFORMATION2 ;
443: */
444: hr_utility.set_location('Pick up the details belonging to Local Unit',60);
445: --fnd_file.put_line(fnd_file.log,'Range Code 7');
446:
447: ELSE
448: --fnd_file.put_line(fnd_file.log,'Range Code 8');
449: l_emp_type:='LE' ;

Line 448: --fnd_file.put_line(fnd_file.log,'Range Code 8');

444: hr_utility.set_location('Pick up the details belonging to Local Unit',60);
445: --fnd_file.put_line(fnd_file.log,'Range Code 7');
446:
447: ELSE
448: --fnd_file.put_line(fnd_file.log,'Range Code 8');
449: l_emp_type:='LE' ;
450: l_emp_id:=g_legal_employer_id ;
451:
452: BEGIN

Line 478: --fnd_file.put_line(fnd_file.log,'Range Code 9');

474: l_le_name := rg_Legal_Emp_Details.name ;
475: --l_emp_name := rg_Legal_Emp_Details.name ;
476: --l_business_id := rg_Legal_Emp_Details.ORG_INFORMATION1 ;
477:
478: --fnd_file.put_line(fnd_file.log,'Range Code 9');
479: END IF ;
480:
481: /*
482: --fnd_file.put_line(fnd_file.log,'Range Code 10');

Line 482: --fnd_file.put_line(fnd_file.log,'Range Code 10');

478: --fnd_file.put_line(fnd_file.log,'Range Code 9');
479: END IF ;
480:
481: /*
482: --fnd_file.put_line(fnd_file.log,'Range Code 10');
483: pay_action_information_api.create_action_information (
484: p_action_information_id => l_action_info_id
485: ,p_action_context_id => p_payroll_action_id
486: ,p_action_context_type => 'PA'

Line 564: --fnd_file.put_line(fnd_file.log,'Range Code 11');

560: ,p_action_information28 => null
561: ,p_action_information29 => null
562: ,p_action_information30 => null );
563:
564: --fnd_file.put_line(fnd_file.log,'Range Code 11');
565: END IF;
566:
567: END IF;
568:

Line 727: --fnd_file.put_line(fnd_file.log,'Assignment Action Code 1');

723: IF g_debug THEN
724: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',60);
725: END IF;
726:
727: --fnd_file.put_line(fnd_file.log,'Assignment Action Code 1');
728: PAY_FI_ARCHIVE_LTFA.GET_ALL_PARAMETERS(
729: p_payroll_action_id
730: ,l_business_group_id
731: ,g_pension_ins_num

Line 740: --fnd_file.put_line(fnd_file.log,'Assignment Action Code 2');

736: ,g_effective_date
737: ,g_archive ) ;
738:
739: g_payroll_action_id :=p_payroll_action_id;
740: --fnd_file.put_line(fnd_file.log,'Assignment Action Code 2');
741:
742:
743: BEGIN
744: pay_balance_pkg.set_context('TAX_UNIT_ID',g_legal_employer_id);

Line 759: --fnd_file.put_line(fnd_file.log,'Assignment Action Code 3');

755: l_prepay_action_id := 0;
756:
757: IF g_local_unit_id IS NOT NULL THEN
758: g_emp_type := 'LU';
759: --fnd_file.put_line(fnd_file.log,'Assignment Action Code 3');
760:
761: FOR rec_prepaid_assignments IN csr_prepaid_assignments_lu(p_payroll_action_id
762: ,p_start_person
763: ,p_end_person

Line 770: --fnd_file.put_line(fnd_file.log,'Assignment Action Code 4');

766: ,g_pension_ins_num
767: ,l_canonical_start_date
768: ,l_canonical_end_date)
769: LOOP
770: --fnd_file.put_line(fnd_file.log,'Assignment Action Code 4');
771: IF l_prepay_action_id <> rec_prepaid_assignments.prepaid_action_id THEN
772: SELECT pay_assignment_actions_s.NEXTVAL
773: INTO l_actid
774: FROM dual;

Line 794: --fnd_file.put_line(fnd_file.log,'Assignment Action Code 5');

790: l_prepay_action_id := rec_prepaid_assignments.prepaid_action_id;
791: END LOOP;
792:
793: ELSE
794: --fnd_file.put_line(fnd_file.log,'Assignment Action Code 5');
795: g_emp_type := 'LE';
796:
797: FOR rec_prepaid_assignments IN csr_prepaid_assignments_le(p_payroll_action_id
798: ,p_start_person

Line 805: --fnd_file.put_line(fnd_file.log,'Assignment Action Code 6');

801: ,g_pension_ins_num
802: ,l_canonical_start_date
803: ,l_canonical_end_date)
804: LOOP
805: --fnd_file.put_line(fnd_file.log,'Assignment Action Code 6');
806: IF l_prepay_action_id <> rec_prepaid_assignments.prepaid_action_id THEN
807: SELECT pay_assignment_actions_s.NEXTVAL
808: INTO l_actid
809: FROM dual;

Line 828: --fnd_file.put_line(fnd_file.log,'Assignment Action Code 7');

824: --hr_nonrun_asact.insint(l_actid,rec_prepaid_assignments.run_action_id);
825: l_prepay_action_id := rec_prepaid_assignments.prepaid_action_id;
826: END LOOP;
827: END IF;
828: --fnd_file.put_line(fnd_file.log,'Assignment Action Code 7');
829: IF g_debug THEN
830: hr_utility.set_location(' Leaving Procedure ASSIGNMENT_ACTION_CODE',70);
831: END IF;
832: EXCEPTION

Line 910: --fnd_file.put_line(fnd_file.log,'Archive Code 1');

906: BEGIN
907: IF g_debug THEN
908: hr_utility.set_location(' Entering Procedure ARCHIVE_CODE',380);
909: END IF;
910: --fnd_file.put_line(fnd_file.log,'Archive Code 1');
911:
912:
913: IF g_archive='Y' THEN
914:

Line 937: --fnd_file.put_line(fnd_file.log,'Archive Code 2');

933: pay_balance_pkg.set_context('ASSIGNMENT_ID',rg_get_person_details.assignment_id);
934: END;
935:
936: l_assignment_id:=rg_get_person_details.assignment_id;
937: --fnd_file.put_line(fnd_file.log,'Archive Code 2');
938:
939: IF g_emp_type = 'LU' THEN
940:
941: --fnd_file.put_line(fnd_file.log,'Archive Code 3');

Line 941: --fnd_file.put_line(fnd_file.log,'Archive Code 3');

937: --fnd_file.put_line(fnd_file.log,'Archive Code 2');
938:
939: IF g_emp_type = 'LU' THEN
940:
941: --fnd_file.put_line(fnd_file.log,'Archive Code 3');
942: OPEN csr_Get_Defined_Balance_Id( 'SALARY_SUBJECT_TO_PENSION_PER_PENSION_LU_MONTH');
943: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
944: CLOSE csr_Get_Defined_Balance_Id;
945:

Line 974: --fnd_file.put_line(fnd_file.log,'Archive Code 4');

970:
971: l_emp_pension :=TO_CHAR(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id, P_ASSIGNMENT_ACTION_ID =>g_lu_assignment_action_id ),'999999999D99') *100;
972: */
973:
974: --fnd_file.put_line(fnd_file.log,'Archive Code 4');
975:
976: ELSIF g_emp_type = 'LE' THEN
977:
978: --fnd_file.put_line(fnd_file.log,'Archive Code 5');

Line 978: --fnd_file.put_line(fnd_file.log,'Archive Code 5');

974: --fnd_file.put_line(fnd_file.log,'Archive Code 4');
975:
976: ELSIF g_emp_type = 'LE' THEN
977:
978: --fnd_file.put_line(fnd_file.log,'Archive Code 5');
979: OPEN csr_Get_Defined_Balance_Id( 'SALARY_SUBJECT_TO_PENSION_PER_PENSION_LE_MONTH');
980: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
981: CLOSE csr_Get_Defined_Balance_Id;
982: l_Sal_subject_pension :=to_char(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id, P_ASSIGNMENT_ID =>l_assignment_id , P_VIRTUAL_DATE => g_effective_date ),'999999999D99') *100;

Line 1005: --fnd_file.put_line(fnd_file.log,'Archive Code 6');

1001: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1002: CLOSE csr_Get_Defined_Balance_Id;
1003: l_emp_pension := TO_CHAR(pay_balance_pkg.get_value(lr_Get_Defined_Balance_Id.creator_id,NULL, g_legal_employer_id, NULL, NULL, NULL, g_effective_date ),'999999999D99') *100;
1004: */
1005: --fnd_file.put_line(fnd_file.log,'Archive Code 6');
1006: END IF;
1007:
1008: BEGIN
1009: SELECT 1

Line 1020: --fnd_file.put_line(fnd_file.log,'Archive Code 7');

1016: EXCEPTION
1017: WHEN NO_DATA_FOUND
1018: THEN
1019:
1020: --fnd_file.put_line(fnd_file.log,'Archive Code 7');
1021: pay_action_information_api.create_action_information (
1022: p_action_information_id=> l_action_info_id,
1023: p_action_context_id=> p_assignment_action_id,
1024: p_action_context_type=> 'AAP',

Line 1061: --fnd_file.put_line(fnd_file.log,'Archive Code 8');

1057: p_action_information28=> NULL,
1058: p_action_information29=> NULL,
1059: p_action_information30=> NULL
1060: );
1061: --fnd_file.put_line(fnd_file.log,'Archive Code 8');
1062: WHEN OTHERS
1063: THEN
1064: NULL;
1065: END;

Line 1067: --fnd_file.put_line(fnd_file.log,'Archive Code 9');

1063: THEN
1064: NULL;
1065: END;
1066:
1067: --fnd_file.put_line(fnd_file.log,'Archive Code 9');
1068: END IF;---ARCHIVE=YES
1069: IF g_debug THEN
1070: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',390);
1071: END IF;

Line 1130: --fnd_file.put_line(fnd_file.log,'Deinitialization Code 1');

1126: IF g_debug THEN
1127: hr_utility.set_location(' Entering Procedure DEINITIALIZATION_CODE',380);
1128: END IF;
1129: /*
1130: --fnd_file.put_line(fnd_file.log,'Deinitialization Code 1');
1131: PAY_FI_ARCHIVE_LTFA.GET_ALL_PARAMETERS(
1132: p_payroll_action_id
1133: ,l_business_group_id
1134: ,l_pension_type

Line 1156: --fnd_file.put_line(fnd_file.log,'Deinitialization Code 2');

1152: g_emp_type:= 'LU';
1153: END IF;
1154:
1155: IF g_archive='Y' THEN
1156: --fnd_file.put_line(fnd_file.log,'Deinitialization Code 2');
1157: l_total_ins_fee := l_pension + l_emp_pension;
1158:
1159: l_total := l_total_ins_fee + (nvl(g_penalty_amt,0)*100) ;
1160:

Line 1202: --fnd_file.put_line(fnd_file.log,'Deinitialization Code 3');

1198: p_action_information29=> NULL,
1199: p_action_information30=> NULL
1200: );
1201:
1202: --fnd_file.put_line(fnd_file.log,'Deinitialization Code 3');
1203:
1204: END IF;---ARCHIVE=YES
1205:
1206: */