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

Line 919: fnd_file.put_line(fnd_file.LOG,'g_business_group_id'||g_business_group_id);

915: , g_LE_request
916: , g_month
917: , g_report_year
918: );
919: fnd_file.put_line(fnd_file.LOG,'g_business_group_id'||g_business_group_id);
920: fnd_file.put_line(fnd_file.LOG,'g_effective_date'||g_effective_date);
921: fnd_file.put_line(fnd_file.LOG,'g_legal_employer_id'||g_legal_employer_id);
922: fnd_file.put_line(fnd_file.LOG,'g_LE_request'||g_LE_request);
923: fnd_file.put_line(fnd_file.LOG,'g_month'||g_month);

Line 920: fnd_file.put_line(fnd_file.LOG,'g_effective_date'||g_effective_date);

916: , g_month
917: , g_report_year
918: );
919: fnd_file.put_line(fnd_file.LOG,'g_business_group_id'||g_business_group_id);
920: fnd_file.put_line(fnd_file.LOG,'g_effective_date'||g_effective_date);
921: fnd_file.put_line(fnd_file.LOG,'g_legal_employer_id'||g_legal_employer_id);
922: fnd_file.put_line(fnd_file.LOG,'g_LE_request'||g_LE_request);
923: fnd_file.put_line(fnd_file.LOG,'g_month'||g_month);
924: fnd_file.put_line(fnd_file.LOG,'g_report_year'||g_report_year);

Line 921: fnd_file.put_line(fnd_file.LOG,'g_legal_employer_id'||g_legal_employer_id);

917: , g_report_year
918: );
919: fnd_file.put_line(fnd_file.LOG,'g_business_group_id'||g_business_group_id);
920: fnd_file.put_line(fnd_file.LOG,'g_effective_date'||g_effective_date);
921: fnd_file.put_line(fnd_file.LOG,'g_legal_employer_id'||g_legal_employer_id);
922: fnd_file.put_line(fnd_file.LOG,'g_LE_request'||g_LE_request);
923: fnd_file.put_line(fnd_file.LOG,'g_month'||g_month);
924: fnd_file.put_line(fnd_file.LOG,'g_report_year'||g_report_year);
925: -- g_start_date:=to_date('01-' || g_month || '-' || g_year, 'dd-mm-yyyy');

Line 922: fnd_file.put_line(fnd_file.LOG,'g_LE_request'||g_LE_request);

918: );
919: fnd_file.put_line(fnd_file.LOG,'g_business_group_id'||g_business_group_id);
920: fnd_file.put_line(fnd_file.LOG,'g_effective_date'||g_effective_date);
921: fnd_file.put_line(fnd_file.LOG,'g_legal_employer_id'||g_legal_employer_id);
922: fnd_file.put_line(fnd_file.LOG,'g_LE_request'||g_LE_request);
923: fnd_file.put_line(fnd_file.LOG,'g_month'||g_month);
924: fnd_file.put_line(fnd_file.LOG,'g_report_year'||g_report_year);
925: -- g_start_date:=to_date('01-' || g_month || '-' || g_year, 'dd-mm-yyyy');
926: --g_end_date:=to_date('31-'|| g_month || '-' || g_year, 'dd-mm-yyyy');

Line 923: fnd_file.put_line(fnd_file.LOG,'g_month'||g_month);

919: fnd_file.put_line(fnd_file.LOG,'g_business_group_id'||g_business_group_id);
920: fnd_file.put_line(fnd_file.LOG,'g_effective_date'||g_effective_date);
921: fnd_file.put_line(fnd_file.LOG,'g_legal_employer_id'||g_legal_employer_id);
922: fnd_file.put_line(fnd_file.LOG,'g_LE_request'||g_LE_request);
923: fnd_file.put_line(fnd_file.LOG,'g_month'||g_month);
924: fnd_file.put_line(fnd_file.LOG,'g_report_year'||g_report_year);
925: -- g_start_date:=to_date('01-' || g_month || '-' || g_year, 'dd-mm-yyyy');
926: --g_end_date:=to_date('31-'|| g_month || '-' || g_year, 'dd-mm-yyyy');
927: g_end_date:=last_day(to_date('01-09'|| '-' || g_report_year, 'dd-mm-yyyy'));

Line 924: fnd_file.put_line(fnd_file.LOG,'g_report_year'||g_report_year);

920: fnd_file.put_line(fnd_file.LOG,'g_effective_date'||g_effective_date);
921: fnd_file.put_line(fnd_file.LOG,'g_legal_employer_id'||g_legal_employer_id);
922: fnd_file.put_line(fnd_file.LOG,'g_LE_request'||g_LE_request);
923: fnd_file.put_line(fnd_file.LOG,'g_month'||g_month);
924: fnd_file.put_line(fnd_file.LOG,'g_report_year'||g_report_year);
925: -- g_start_date:=to_date('01-' || g_month || '-' || g_year, 'dd-mm-yyyy');
926: --g_end_date:=to_date('31-'|| g_month || '-' || g_year, 'dd-mm-yyyy');
927: g_end_date:=last_day(to_date('01-09'|| '-' || g_report_year, 'dd-mm-yyyy'));
928: fnd_file.put_line(fnd_file.LOG,'g_end_date'||g_end_date);

Line 928: fnd_file.put_line(fnd_file.LOG,'g_end_date'||g_end_date);

924: fnd_file.put_line(fnd_file.LOG,'g_report_year'||g_report_year);
925: -- g_start_date:=to_date('01-' || g_month || '-' || g_year, 'dd-mm-yyyy');
926: --g_end_date:=to_date('31-'|| g_month || '-' || g_year, 'dd-mm-yyyy');
927: g_end_date:=last_day(to_date('01-09'|| '-' || g_report_year, 'dd-mm-yyyy'));
928: fnd_file.put_line(fnd_file.LOG,'g_end_date'||g_end_date);
929:
930: IF g_LE_request ='LE_SELECTED' THEN
931: FOR csr_legal_employer IN csr_local_legal_employer(g_business_group_id,g_legal_employer_id) LOOP
932: l_local_unit_id:=csr_legal_employer.local_unit;

Line 964: fnd_file.put_line(fnd_file.LOG,'l_person_number'||l_person_number);

960: l_salary_type:=1;
961: ELSIF l_payroll_type='Week' THEN
962: l_salary_type:=2;
963: END IF;
964: fnd_file.put_line(fnd_file.LOG,'l_person_number'||l_person_number);
965: fnd_file.put_line(fnd_file.LOG,'l_assignment_id'||l_assignment_id);
966: fnd_file.put_line(fnd_file.LOG,'l_local_unit_id'||l_local_unit_id);
967: OPEN csr_extra_assignment(l_assignment_id);
968: FETCH csr_extra_assignment INTO l_work_type;

Line 965: fnd_file.put_line(fnd_file.LOG,'l_assignment_id'||l_assignment_id);

961: ELSIF l_payroll_type='Week' THEN
962: l_salary_type:=2;
963: END IF;
964: fnd_file.put_line(fnd_file.LOG,'l_person_number'||l_person_number);
965: fnd_file.put_line(fnd_file.LOG,'l_assignment_id'||l_assignment_id);
966: fnd_file.put_line(fnd_file.LOG,'l_local_unit_id'||l_local_unit_id);
967: OPEN csr_extra_assignment(l_assignment_id);
968: FETCH csr_extra_assignment INTO l_work_type;
969: CLOSE csr_extra_assignment;

Line 966: fnd_file.put_line(fnd_file.LOG,'l_local_unit_id'||l_local_unit_id);

962: l_salary_type:=2;
963: END IF;
964: fnd_file.put_line(fnd_file.LOG,'l_person_number'||l_person_number);
965: fnd_file.put_line(fnd_file.LOG,'l_assignment_id'||l_assignment_id);
966: fnd_file.put_line(fnd_file.LOG,'l_local_unit_id'||l_local_unit_id);
967: OPEN csr_extra_assignment(l_assignment_id);
968: FETCH csr_extra_assignment INTO l_work_type;
969: CLOSE csr_extra_assignment;
970: pay_balance_pkg.set_context('ASSIGNMENT_ID',l_assignment_id); --133942);

Line 974: fnd_file.put_line(fnd_file.LOG,'steering code 001');

970: pay_balance_pkg.set_context('ASSIGNMENT_ID',l_assignment_id); --133942);
971: pay_balance_pkg.set_context('LOCAL_UNIT_ID',l_local_unit_id); --3621);
972:
973: FOR csr_balance IN csr_balances(g_business_group_id,'001- Hours worked (September)') LOOP
974: fnd_file.put_line(fnd_file.LOG,'steering code 001');
975: l_balance_type_id:=csr_balance.balance_type_id;
976: fnd_file.put_line(fnd_file.LOG,'l_balance_type_id'||l_balance_type_id);
977: OPEN csr_defined_balances(l_balance_type_id);
978: FETCH csr_defined_balances INTO l_defined_balance_id;

Line 976: fnd_file.put_line(fnd_file.LOG,'l_balance_type_id'||l_balance_type_id);

972:
973: FOR csr_balance IN csr_balances(g_business_group_id,'001- Hours worked (September)') LOOP
974: fnd_file.put_line(fnd_file.LOG,'steering code 001');
975: l_balance_type_id:=csr_balance.balance_type_id;
976: fnd_file.put_line(fnd_file.LOG,'l_balance_type_id'||l_balance_type_id);
977: OPEN csr_defined_balances(l_balance_type_id);
978: FETCH csr_defined_balances INTO l_defined_balance_id;
979: CLOSE csr_defined_balances;
980: fnd_file.put_line(fnd_file.LOG,'l_defined_balance_id'||l_defined_balance_id);

Line 980: fnd_file.put_line(fnd_file.LOG,'l_defined_balance_id'||l_defined_balance_id);

976: fnd_file.put_line(fnd_file.LOG,'l_balance_type_id'||l_balance_type_id);
977: OPEN csr_defined_balances(l_balance_type_id);
978: FETCH csr_defined_balances INTO l_defined_balance_id;
979: CLOSE csr_defined_balances;
980: fnd_file.put_line(fnd_file.LOG,'l_defined_balance_id'||l_defined_balance_id);
981: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
982: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
983: P_VIRTUAL_DATE=>g_end_date),0);
984: fnd_file.put_line(fnd_file.LOG,'l_value'||l_value);

Line 984: fnd_file.put_line(fnd_file.LOG,'l_value'||l_value);

980: fnd_file.put_line(fnd_file.LOG,'l_defined_balance_id'||l_defined_balance_id);
981: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
982: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
983: P_VIRTUAL_DATE=>g_end_date),0);
984: fnd_file.put_line(fnd_file.LOG,'l_value'||l_value);
985: l_001_steering_code:=l_001_steering_code+l_value;
986: fnd_file.put_line(fnd_file.LOG,'l_001_steering_code'||l_001_steering_code);
987: END LOOP;
988: FOR csr_balance IN csr_balances(g_business_group_id,'002-Paid Overtime (September)') LOOP

Line 986: fnd_file.put_line(fnd_file.LOG,'l_001_steering_code'||l_001_steering_code);

982: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
983: P_VIRTUAL_DATE=>g_end_date),0);
984: fnd_file.put_line(fnd_file.LOG,'l_value'||l_value);
985: l_001_steering_code:=l_001_steering_code+l_value;
986: fnd_file.put_line(fnd_file.LOG,'l_001_steering_code'||l_001_steering_code);
987: END LOOP;
988: FOR csr_balance IN csr_balances(g_business_group_id,'002-Paid Overtime (September)') LOOP
989: fnd_file.put_line(fnd_file.LOG,'steering code 002');
990: l_balance_type_id:=csr_balance.balance_type_id;

Line 989: fnd_file.put_line(fnd_file.LOG,'steering code 002');

985: l_001_steering_code:=l_001_steering_code+l_value;
986: fnd_file.put_line(fnd_file.LOG,'l_001_steering_code'||l_001_steering_code);
987: END LOOP;
988: FOR csr_balance IN csr_balances(g_business_group_id,'002-Paid Overtime (September)') LOOP
989: fnd_file.put_line(fnd_file.LOG,'steering code 002');
990: l_balance_type_id:=csr_balance.balance_type_id;
991: OPEN csr_defined_balances(l_balance_type_id);
992: FETCH csr_defined_balances INTO l_defined_balance_id;
993: CLOSE csr_defined_balances;

Line 1000: fnd_file.put_line(fnd_file.LOG,'steering code 003');

996: P_VIRTUAL_DATE=>g_end_date),0);
997: l_002_steering_code:=l_002_steering_code+l_value;
998: END LOOP;
999: FOR csr_balance IN csr_balances(g_business_group_id,'003-Working Hours per week') LOOP
1000: fnd_file.put_line(fnd_file.LOG,'steering code 003');
1001: l_balance_type_id:=csr_balance.balance_type_id;
1002: OPEN csr_defined_balances(l_balance_type_id);
1003: FETCH csr_defined_balances INTO l_defined_balance_id;
1004: CLOSE csr_defined_balances;

Line 1011: fnd_file.put_line(fnd_file.LOG,'steering code 004');

1007: P_VIRTUAL_DATE=>g_end_date),0);
1008: l_003_steering_code:=l_003_steering_code+l_value;
1009: END LOOP;
1010: FOR csr_balance IN csr_balances(g_business_group_id,'004-Working Hours week-full') LOOP
1011: fnd_file.put_line(fnd_file.LOG,'steering code 004');
1012: l_balance_type_id:=csr_balance.balance_type_id;
1013: OPEN csr_defined_balances(l_balance_type_id);
1014: FETCH csr_defined_balances INTO l_defined_balance_id;
1015: CLOSE csr_defined_balances;

Line 1022: fnd_file.put_line(fnd_file.LOG,'steering code 051');

1018: P_VIRTUAL_DATE=>g_end_date),0);
1019: l_004_steering_code:=l_004_steering_code+l_value;
1020: END LOOP;
1021: FOR csr_balance IN csr_balances(g_business_group_id,'051-Monthly, weekly pay') LOOP
1022: fnd_file.put_line(fnd_file.LOG,'steering code 051');
1023: l_balance_type_id:=csr_balance.balance_type_id;
1024: OPEN csr_defined_balances(l_balance_type_id);
1025: FETCH csr_defined_balances INTO l_defined_balance_id;
1026: CLOSE csr_defined_balances;

Line 1033: fnd_file.put_line(fnd_file.LOG,'steering code 052');

1029: P_VIRTUAL_DATE=>g_end_date),0);
1030: l_051_steering_code:=l_051_steering_code+l_value;
1031: END LOOP;
1032: FOR csr_balance IN csr_balances(g_business_group_id,'052-Over-time allowance') LOOP
1033: fnd_file.put_line(fnd_file.LOG,'steering code 052');
1034: l_balance_type_id:=csr_balance.balance_type_id;
1035: OPEN csr_defined_balances(l_balance_type_id);
1036: FETCH csr_defined_balances INTO l_defined_balance_id;
1037: CLOSE csr_defined_balances;

Line 1044: fnd_file.put_line(fnd_file.LOG,'steering code 053');

1040: P_VIRTUAL_DATE=>g_end_date),0);
1041: l_052_steering_code:=l_052_steering_code+l_value;
1042: END LOOP;
1043: FOR csr_balance IN csr_balances(g_business_group_id,'053-Comp. for Over-time') LOOP
1044: fnd_file.put_line(fnd_file.LOG,'steering code 053');
1045: l_balance_type_id:=csr_balance.balance_type_id;
1046: OPEN csr_defined_balances(l_balance_type_id);
1047: FETCH csr_defined_balances INTO l_defined_balance_id;
1048: CLOSE csr_defined_balances;

Line 1055: fnd_file.put_line(fnd_file.LOG,'steering code 054');

1051: P_VIRTUAL_DATE=>g_end_date),0);
1052: l_053_steering_code:=l_053_steering_code+l_value;
1053: END LOOP;
1054: FOR csr_balance IN csr_balances(g_business_group_id,'054-Comp. for shift work') LOOP
1055: fnd_file.put_line(fnd_file.LOG,'steering code 054');
1056: l_balance_type_id:=csr_balance.balance_type_id;
1057: OPEN csr_defined_balances(l_balance_type_id);
1058: FETCH csr_defined_balances INTO l_defined_balance_id;
1059: CLOSE csr_defined_balances;

Line 1066: fnd_file.put_line(fnd_file.LOG,'steering code 055');

1062: P_VIRTUAL_DATE=>g_end_date),0);
1063: l_054_steering_code:=l_054_steering_code+l_value;
1064: END LOOP;
1065: FOR csr_balance IN csr_balances(g_business_group_id,'055-comp. duty, relief work') LOOP
1066: fnd_file.put_line(fnd_file.LOG,'steering code 055');
1067: l_balance_type_id:=csr_balance.balance_type_id;
1068: OPEN csr_defined_balances(l_balance_type_id);
1069: FETCH csr_defined_balances INTO l_defined_balance_id;
1070: CLOSE csr_defined_balances;

Line 1077: fnd_file.put_line(fnd_file.LOG,'steering code 056');

1073: P_VIRTUAL_DATE=>g_end_date),0);
1074: l_055_steering_code:=l_055_steering_code+l_value;
1075: END LOOP;
1076: FOR csr_balance IN csr_balances(g_business_group_id,'056-Comp. for danger,dirt') LOOP
1077: fnd_file.put_line(fnd_file.LOG,'steering code 056');
1078: l_balance_type_id:=csr_balance.balance_type_id;
1079: OPEN csr_defined_balances(l_balance_type_id);
1080: FETCH csr_defined_balances INTO l_defined_balance_id;
1081: CLOSE csr_defined_balances;

Line 1088: fnd_file.put_line(fnd_file.LOG,'steering code 058');

1084: P_VIRTUAL_DATE=>g_end_date),0);
1085: l_056_steering_code:=l_056_steering_code+l_value;
1086: END LOOP;
1087: FOR csr_balance IN csr_balances(g_business_group_id,'058-Incentive pay (bonus)') LOOP
1088: fnd_file.put_line(fnd_file.LOG,'steering code 058');
1089: l_balance_type_id:=csr_balance.balance_type_id;
1090: OPEN csr_defined_balances(l_balance_type_id);
1091: FETCH csr_defined_balances INTO l_defined_balance_id;
1092: CLOSE csr_defined_balances;

Line 1099: fnd_file.put_line(fnd_file.LOG,'steering code 600');

1095: P_VIRTUAL_DATE=>g_end_date),0);
1096: l_058_steering_code:=l_058_steering_code+l_value;
1097: END LOOP;
1098: FOR csr_balance IN csr_balances(g_business_group_id,'600-Holiday days Entitlement') LOOP
1099: fnd_file.put_line(fnd_file.LOG,'steering code 600');
1100: l_balance_type_id:=csr_balance.balance_type_id;
1101: OPEN csr_defined_balances(l_balance_type_id);
1102: FETCH csr_defined_balances INTO l_defined_balance_id;
1103: CLOSE csr_defined_balances;

Line 1110: fnd_file.put_line(fnd_file.LOG,'steering code 601');

1106: P_VIRTUAL_DATE=>g_end_date),0);
1107: l_600_steering_code:=l_600_steering_code+l_value;
1108: END LOOP;
1109: FOR csr_balance IN csr_balances(g_business_group_id,'601-Salary for hours worked') LOOP
1110: fnd_file.put_line(fnd_file.LOG,'steering code 601');
1111: l_balance_type_id:=csr_balance.balance_type_id;
1112: OPEN csr_defined_balances(l_balance_type_id);
1113: FETCH csr_defined_balances INTO l_defined_balance_id;
1114: CLOSE csr_defined_balances;

Line 1121: fnd_file.put_line(fnd_file.LOG,'steering code 810');

1117: P_VIRTUAL_DATE=>g_end_date),0);
1118: l_601_steering_code:=l_601_steering_code+l_value;
1119: END LOOP;
1120: FOR csr_balance IN csr_balances(g_business_group_id,'810-Job Status') LOOP
1121: fnd_file.put_line(fnd_file.LOG,'steering code 810');
1122: l_balance_type_id:=csr_balance.balance_type_id;
1123: OPEN csr_defined_balances(l_balance_type_id);
1124: FETCH csr_defined_balances INTO l_defined_balance_id;
1125: CLOSE csr_defined_balances;

Line 1132: fnd_file.put_line(fnd_file.LOG,'steering code 800');

1128: P_VIRTUAL_DATE=>g_end_date),0);
1129: l_810_steering_code:=l_810_steering_code+l_value;
1130: END LOOP;
1131: FOR csr_balance IN csr_balances(g_business_group_id,'800-Comp. type of shift') LOOP
1132: fnd_file.put_line(fnd_file.LOG,'steering code 800');
1133: l_balance_type_id:=csr_balance.balance_type_id;
1134: OPEN csr_defined_balances(l_balance_type_id);
1135: FETCH csr_defined_balances INTO l_defined_balance_id;
1136: CLOSE csr_defined_balances;

Line 1143: fnd_file.put_line(fnd_file.LOG,'steering code 801');

1139: P_VIRTUAL_DATE=>g_end_date),0);
1140: l_800_steering_code:=l_800_steering_code+l_value;
1141: END LOOP;
1142: FOR csr_balance IN csr_balances(g_business_group_id,'801-Comp. post and position') LOOP
1143: fnd_file.put_line(fnd_file.LOG,'steering code 801');
1144: l_balance_type_id:=csr_balance.balance_type_id;
1145: OPEN csr_defined_balances(l_balance_type_id);
1146: FETCH csr_defined_balances INTO l_defined_balance_id;
1147: CLOSE csr_defined_balances;

Line 1154: fnd_file.put_line(fnd_file.LOG,'steering code 802');

1150: P_VIRTUAL_DATE=>g_end_date),0);
1151: l_801_steering_code:=l_801_steering_code+l_value;
1152: END LOOP;
1153: FOR csr_balance IN csr_balances(g_business_group_id,'802-Comp. for calving') LOOP
1154: fnd_file.put_line(fnd_file.LOG,'steering code 802');
1155: l_balance_type_id:=csr_balance.balance_type_id;
1156: OPEN csr_defined_balances(l_balance_type_id);
1157: FETCH csr_defined_balances INTO l_defined_balance_id;
1158: CLOSE csr_defined_balances;

Line 1165: fnd_file.put_line(fnd_file.LOG,'steering code 803');

1161: P_VIRTUAL_DATE=>g_end_date),0);
1162: l_802_steering_code:=l_802_steering_code+l_value;
1163: END LOOP;
1164: FOR csr_balance IN csr_balances(g_business_group_id,'803-Comp. for delegation') LOOP
1165: fnd_file.put_line(fnd_file.LOG,'steering code 803');
1166: l_balance_type_id:=csr_balance.balance_type_id;
1167: OPEN csr_defined_balances(l_balance_type_id);
1168: FETCH csr_defined_balances INTO l_defined_balance_id;
1169: CLOSE csr_defined_balances;

Line 1176: fnd_file.put_line(fnd_file.LOG,'steering code 804');

1172: P_VIRTUAL_DATE=>g_end_date),0);
1173: l_803_steering_code:=l_803_steering_code+l_value;
1174: END LOOP;
1175: FOR csr_balance IN csr_balances(g_business_group_id,'804-Comp. County, Municipal') LOOP
1176: fnd_file.put_line(fnd_file.LOG,'steering code 804');
1177: l_balance_type_id:=csr_balance.balance_type_id;
1178: OPEN csr_defined_balances(l_balance_type_id);
1179: FETCH csr_defined_balances INTO l_defined_balance_id;
1180: CLOSE csr_defined_balances;

Line 1187: fnd_file.put_line(fnd_file.LOG,'steering code 805');

1183: P_VIRTUAL_DATE=>g_end_date),0);
1184: l_804_steering_code:=l_804_steering_code+l_value;
1185: END LOOP;
1186: FOR csr_balance IN csr_balances(g_business_group_id,'805-Comp. for Per Diem') LOOP
1187: fnd_file.put_line(fnd_file.LOG,'steering code 805');
1188: l_balance_type_id:=csr_balance.balance_type_id;
1189: OPEN csr_defined_balances(l_balance_type_id);
1190: FETCH csr_defined_balances INTO l_defined_balance_id;
1191: CLOSE csr_defined_balances;

Line 1198: fnd_file.put_line(fnd_file.LOG,'steering code 806');

1194: P_VIRTUAL_DATE=>g_end_date),0);
1195: l_805_steering_code:=l_805_steering_code+l_value;
1196: END LOOP;
1197: FOR csr_balance IN csr_balances(g_business_group_id,'806-Comp. for Travel Expenses') LOOP
1198: fnd_file.put_line(fnd_file.LOG,'steering code 806');
1199: l_balance_type_id:=csr_balance.balance_type_id;
1200: OPEN csr_defined_balances(l_balance_type_id);
1201: FETCH csr_defined_balances INTO l_defined_balance_id;
1202: CLOSE csr_defined_balances;

Line 1209: fnd_file.put_line(fnd_file.LOG,'steering code 808');

1205: P_VIRTUAL_DATE=>g_end_date),0);
1206: l_806_steering_code:=l_806_steering_code+l_value;
1207: END LOOP;
1208: FOR csr_balance IN csr_balances(g_business_group_id,'808-Comp. for Official Duty') LOOP
1209: fnd_file.put_line(fnd_file.LOG,'steering code 808');
1210: l_balance_type_id:=csr_balance.balance_type_id;
1211: OPEN csr_defined_balances(l_balance_type_id);
1212: FETCH csr_defined_balances INTO l_defined_balance_id;
1213: CLOSE csr_defined_balances;

Line 1219: fnd_file.put_line(fnd_file.LOG,'Before first insertion');

1215: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1216: P_VIRTUAL_DATE=>g_end_date),0);
1217: l_808_steering_code:=l_808_steering_code+l_value;
1218: END LOOP;
1219: fnd_file.put_line(fnd_file.LOG,'Before first insertion');
1220: pay_action_information_api.create_action_information
1221: (p_action_information_id => l_action_info_id
1222: , p_action_context_id => p_payroll_action_id
1223: , p_action_context_type => 'PA'

Line 1256: fnd_file.put_line(fnd_file.LOG,'Before second insertion');

1252: , p_action_information24 => l_600_steering_code
1253: , p_action_information25 => l_601_steering_code
1254: , p_action_information26 => l_810_steering_code
1255: );
1256: fnd_file.put_line(fnd_file.LOG,'Before second insertion');
1257: pay_action_information_api.create_action_information
1258: (p_action_information_id => l_action_info_id
1259: , p_action_context_id => p_payroll_action_id
1260: , p_action_context_type => 'PA'

Line 1342: fnd_file.put_line(fnd_file.LOG,'l_person_number'||l_person_number);

1338: l_salary_type:=1;
1339: ELSIF l_payroll_type='Week' THEN
1340: l_salary_type:=2;
1341: END IF;
1342: fnd_file.put_line(fnd_file.LOG,'l_person_number'||l_person_number);
1343: fnd_file.put_line(fnd_file.LOG,'l_assignment_id'||l_assignment_id);
1344: fnd_file.put_line(fnd_file.LOG,'l_local_unit_id'||l_local_unit_id);
1345: OPEN csr_extra_assignment(l_assignment_id);
1346: FETCH csr_extra_assignment INTO l_work_type;

Line 1343: fnd_file.put_line(fnd_file.LOG,'l_assignment_id'||l_assignment_id);

1339: ELSIF l_payroll_type='Week' THEN
1340: l_salary_type:=2;
1341: END IF;
1342: fnd_file.put_line(fnd_file.LOG,'l_person_number'||l_person_number);
1343: fnd_file.put_line(fnd_file.LOG,'l_assignment_id'||l_assignment_id);
1344: fnd_file.put_line(fnd_file.LOG,'l_local_unit_id'||l_local_unit_id);
1345: OPEN csr_extra_assignment(l_assignment_id);
1346: FETCH csr_extra_assignment INTO l_work_type;
1347: CLOSE csr_extra_assignment;

Line 1344: fnd_file.put_line(fnd_file.LOG,'l_local_unit_id'||l_local_unit_id);

1340: l_salary_type:=2;
1341: END IF;
1342: fnd_file.put_line(fnd_file.LOG,'l_person_number'||l_person_number);
1343: fnd_file.put_line(fnd_file.LOG,'l_assignment_id'||l_assignment_id);
1344: fnd_file.put_line(fnd_file.LOG,'l_local_unit_id'||l_local_unit_id);
1345: OPEN csr_extra_assignment(l_assignment_id);
1346: FETCH csr_extra_assignment INTO l_work_type;
1347: CLOSE csr_extra_assignment;
1348: pay_balance_pkg.set_context('ASSIGNMENT_ID',l_assignment_id); --133942);

Line 1352: fnd_file.put_line(fnd_file.LOG,'steering code 001');

1348: pay_balance_pkg.set_context('ASSIGNMENT_ID',l_assignment_id); --133942);
1349: pay_balance_pkg.set_context('LOCAL_UNIT_ID',l_local_unit_id); --3621);
1350:
1351: FOR csr_balance IN csr_balances(g_business_group_id,'001- Hours worked (September)') LOOP
1352: fnd_file.put_line(fnd_file.LOG,'steering code 001');
1353: l_balance_type_id:=csr_balance.balance_type_id;
1354: fnd_file.put_line(fnd_file.LOG,'l_balance_type_id'||l_balance_type_id);
1355: OPEN csr_defined_balances(l_balance_type_id);
1356: FETCH csr_defined_balances INTO l_defined_balance_id;

Line 1354: fnd_file.put_line(fnd_file.LOG,'l_balance_type_id'||l_balance_type_id);

1350:
1351: FOR csr_balance IN csr_balances(g_business_group_id,'001- Hours worked (September)') LOOP
1352: fnd_file.put_line(fnd_file.LOG,'steering code 001');
1353: l_balance_type_id:=csr_balance.balance_type_id;
1354: fnd_file.put_line(fnd_file.LOG,'l_balance_type_id'||l_balance_type_id);
1355: OPEN csr_defined_balances(l_balance_type_id);
1356: FETCH csr_defined_balances INTO l_defined_balance_id;
1357: CLOSE csr_defined_balances;
1358: fnd_file.put_line(fnd_file.LOG,'l_defined_balance_id'||l_defined_balance_id);

Line 1358: fnd_file.put_line(fnd_file.LOG,'l_defined_balance_id'||l_defined_balance_id);

1354: fnd_file.put_line(fnd_file.LOG,'l_balance_type_id'||l_balance_type_id);
1355: OPEN csr_defined_balances(l_balance_type_id);
1356: FETCH csr_defined_balances INTO l_defined_balance_id;
1357: CLOSE csr_defined_balances;
1358: fnd_file.put_line(fnd_file.LOG,'l_defined_balance_id'||l_defined_balance_id);
1359: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1360: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1361: P_VIRTUAL_DATE=>g_end_date),0);
1362: fnd_file.put_line(fnd_file.LOG,'l_value'||l_value);

Line 1362: fnd_file.put_line(fnd_file.LOG,'l_value'||l_value);

1358: fnd_file.put_line(fnd_file.LOG,'l_defined_balance_id'||l_defined_balance_id);
1359: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>l_defined_balance_id,
1360: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1361: P_VIRTUAL_DATE=>g_end_date),0);
1362: fnd_file.put_line(fnd_file.LOG,'l_value'||l_value);
1363: l_001_steering_code:=l_001_steering_code+l_value;
1364: fnd_file.put_line(fnd_file.LOG,'l_001_steering_code'||l_001_steering_code);
1365: END LOOP;
1366: FOR csr_balance IN csr_balances(g_business_group_id,'002-Paid Overtime (September)') LOOP

Line 1364: fnd_file.put_line(fnd_file.LOG,'l_001_steering_code'||l_001_steering_code);

1360: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1361: P_VIRTUAL_DATE=>g_end_date),0);
1362: fnd_file.put_line(fnd_file.LOG,'l_value'||l_value);
1363: l_001_steering_code:=l_001_steering_code+l_value;
1364: fnd_file.put_line(fnd_file.LOG,'l_001_steering_code'||l_001_steering_code);
1365: END LOOP;
1366: FOR csr_balance IN csr_balances(g_business_group_id,'002-Paid Overtime (September)') LOOP
1367: fnd_file.put_line(fnd_file.LOG,'steering code 002');
1368: l_balance_type_id:=csr_balance.balance_type_id;

Line 1367: fnd_file.put_line(fnd_file.LOG,'steering code 002');

1363: l_001_steering_code:=l_001_steering_code+l_value;
1364: fnd_file.put_line(fnd_file.LOG,'l_001_steering_code'||l_001_steering_code);
1365: END LOOP;
1366: FOR csr_balance IN csr_balances(g_business_group_id,'002-Paid Overtime (September)') LOOP
1367: fnd_file.put_line(fnd_file.LOG,'steering code 002');
1368: l_balance_type_id:=csr_balance.balance_type_id;
1369: OPEN csr_defined_balances(l_balance_type_id);
1370: FETCH csr_defined_balances INTO l_defined_balance_id;
1371: CLOSE csr_defined_balances;

Line 1378: fnd_file.put_line(fnd_file.LOG,'steering code 003');

1374: P_VIRTUAL_DATE=>g_end_date),0);
1375: l_002_steering_code:=l_002_steering_code+l_value;
1376: END LOOP;
1377: FOR csr_balance IN csr_balances(g_business_group_id,'003-Working Hours per week') LOOP
1378: fnd_file.put_line(fnd_file.LOG,'steering code 003');
1379: l_balance_type_id:=csr_balance.balance_type_id;
1380: OPEN csr_defined_balances(l_balance_type_id);
1381: FETCH csr_defined_balances INTO l_defined_balance_id;
1382: CLOSE csr_defined_balances;

Line 1389: fnd_file.put_line(fnd_file.LOG,'steering code 004');

1385: P_VIRTUAL_DATE=>g_end_date),0);
1386: l_003_steering_code:=l_003_steering_code+l_value;
1387: END LOOP;
1388: FOR csr_balance IN csr_balances(g_business_group_id,'004-Working Hours week-full') LOOP
1389: fnd_file.put_line(fnd_file.LOG,'steering code 004');
1390: l_balance_type_id:=csr_balance.balance_type_id;
1391: OPEN csr_defined_balances(l_balance_type_id);
1392: FETCH csr_defined_balances INTO l_defined_balance_id;
1393: CLOSE csr_defined_balances;

Line 1400: fnd_file.put_line(fnd_file.LOG,'steering code 051');

1396: P_VIRTUAL_DATE=>g_end_date),0);
1397: l_004_steering_code:=l_004_steering_code+l_value;
1398: END LOOP;
1399: FOR csr_balance IN csr_balances(g_business_group_id,'051-Monthly, weekly pay') LOOP
1400: fnd_file.put_line(fnd_file.LOG,'steering code 051');
1401: l_balance_type_id:=csr_balance.balance_type_id;
1402: OPEN csr_defined_balances(l_balance_type_id);
1403: FETCH csr_defined_balances INTO l_defined_balance_id;
1404: CLOSE csr_defined_balances;

Line 1411: fnd_file.put_line(fnd_file.LOG,'steering code 052');

1407: P_VIRTUAL_DATE=>g_end_date),0);
1408: l_051_steering_code:=l_051_steering_code+l_value;
1409: END LOOP;
1410: FOR csr_balance IN csr_balances(g_business_group_id,'052-Over-time allowance') LOOP
1411: fnd_file.put_line(fnd_file.LOG,'steering code 052');
1412: l_balance_type_id:=csr_balance.balance_type_id;
1413: OPEN csr_defined_balances(l_balance_type_id);
1414: FETCH csr_defined_balances INTO l_defined_balance_id;
1415: CLOSE csr_defined_balances;

Line 1422: fnd_file.put_line(fnd_file.LOG,'steering code 053');

1418: P_VIRTUAL_DATE=>g_end_date),0);
1419: l_052_steering_code:=l_052_steering_code+l_value;
1420: END LOOP;
1421: FOR csr_balance IN csr_balances(g_business_group_id,'053-Comp. for Over-time') LOOP
1422: fnd_file.put_line(fnd_file.LOG,'steering code 053');
1423: l_balance_type_id:=csr_balance.balance_type_id;
1424: OPEN csr_defined_balances(l_balance_type_id);
1425: FETCH csr_defined_balances INTO l_defined_balance_id;
1426: CLOSE csr_defined_balances;

Line 1433: fnd_file.put_line(fnd_file.LOG,'steering code 054');

1429: P_VIRTUAL_DATE=>g_end_date),0);
1430: l_053_steering_code:=l_053_steering_code+l_value;
1431: END LOOP;
1432: FOR csr_balance IN csr_balances(g_business_group_id,'054-Comp. for shift work') LOOP
1433: fnd_file.put_line(fnd_file.LOG,'steering code 054');
1434: l_balance_type_id:=csr_balance.balance_type_id;
1435: OPEN csr_defined_balances(l_balance_type_id);
1436: FETCH csr_defined_balances INTO l_defined_balance_id;
1437: CLOSE csr_defined_balances;

Line 1444: fnd_file.put_line(fnd_file.LOG,'steering code 055');

1440: P_VIRTUAL_DATE=>g_end_date),0);
1441: l_054_steering_code:=l_054_steering_code+l_value;
1442: END LOOP;
1443: FOR csr_balance IN csr_balances(g_business_group_id,'055-comp. duty, relief work') LOOP
1444: fnd_file.put_line(fnd_file.LOG,'steering code 055');
1445: l_balance_type_id:=csr_balance.balance_type_id;
1446: OPEN csr_defined_balances(l_balance_type_id);
1447: FETCH csr_defined_balances INTO l_defined_balance_id;
1448: CLOSE csr_defined_balances;

Line 1455: fnd_file.put_line(fnd_file.LOG,'steering code 056');

1451: P_VIRTUAL_DATE=>g_end_date),0);
1452: l_055_steering_code:=l_055_steering_code+l_value;
1453: END LOOP;
1454: FOR csr_balance IN csr_balances(g_business_group_id,'056-Comp. for danger,dirt') LOOP
1455: fnd_file.put_line(fnd_file.LOG,'steering code 056');
1456: l_balance_type_id:=csr_balance.balance_type_id;
1457: OPEN csr_defined_balances(l_balance_type_id);
1458: FETCH csr_defined_balances INTO l_defined_balance_id;
1459: CLOSE csr_defined_balances;

Line 1466: fnd_file.put_line(fnd_file.LOG,'steering code 058');

1462: P_VIRTUAL_DATE=>g_end_date),0);
1463: l_056_steering_code:=l_056_steering_code+l_value;
1464: END LOOP;
1465: FOR csr_balance IN csr_balances(g_business_group_id,'058-Incentive pay (bonus)') LOOP
1466: fnd_file.put_line(fnd_file.LOG,'steering code 058');
1467: l_balance_type_id:=csr_balance.balance_type_id;
1468: OPEN csr_defined_balances(l_balance_type_id);
1469: FETCH csr_defined_balances INTO l_defined_balance_id;
1470: CLOSE csr_defined_balances;

Line 1477: fnd_file.put_line(fnd_file.LOG,'steering code 600');

1473: P_VIRTUAL_DATE=>g_end_date),0);
1474: l_058_steering_code:=l_058_steering_code+l_value;
1475: END LOOP;
1476: FOR csr_balance IN csr_balances(g_business_group_id,'600-Holiday days Entitlement') LOOP
1477: fnd_file.put_line(fnd_file.LOG,'steering code 600');
1478: l_balance_type_id:=csr_balance.balance_type_id;
1479: OPEN csr_defined_balances(l_balance_type_id);
1480: FETCH csr_defined_balances INTO l_defined_balance_id;
1481: CLOSE csr_defined_balances;

Line 1488: fnd_file.put_line(fnd_file.LOG,'steering code 601');

1484: P_VIRTUAL_DATE=>g_end_date),0);
1485: l_600_steering_code:=l_600_steering_code+l_value;
1486: END LOOP;
1487: FOR csr_balance IN csr_balances(g_business_group_id,'601-Salary for hours worked') LOOP
1488: fnd_file.put_line(fnd_file.LOG,'steering code 601');
1489: l_balance_type_id:=csr_balance.balance_type_id;
1490: OPEN csr_defined_balances(l_balance_type_id);
1491: FETCH csr_defined_balances INTO l_defined_balance_id;
1492: CLOSE csr_defined_balances;

Line 1499: fnd_file.put_line(fnd_file.LOG,'steering code 810');

1495: P_VIRTUAL_DATE=>g_end_date),0);
1496: l_601_steering_code:=l_601_steering_code+l_value;
1497: END LOOP;
1498: FOR csr_balance IN csr_balances(g_business_group_id,'810-Job Status') LOOP
1499: fnd_file.put_line(fnd_file.LOG,'steering code 810');
1500: l_balance_type_id:=csr_balance.balance_type_id;
1501: OPEN csr_defined_balances(l_balance_type_id);
1502: FETCH csr_defined_balances INTO l_defined_balance_id;
1503: CLOSE csr_defined_balances;

Line 1510: fnd_file.put_line(fnd_file.LOG,'steering code 800');

1506: P_VIRTUAL_DATE=>g_end_date),0);
1507: l_810_steering_code:=l_810_steering_code+l_value;
1508: END LOOP;
1509: FOR csr_balance IN csr_balances(g_business_group_id,'800-Comp. type of shift') LOOP
1510: fnd_file.put_line(fnd_file.LOG,'steering code 800');
1511: l_balance_type_id:=csr_balance.balance_type_id;
1512: OPEN csr_defined_balances(l_balance_type_id);
1513: FETCH csr_defined_balances INTO l_defined_balance_id;
1514: CLOSE csr_defined_balances;

Line 1521: fnd_file.put_line(fnd_file.LOG,'steering code 801');

1517: P_VIRTUAL_DATE=>g_end_date),0);
1518: l_800_steering_code:=l_800_steering_code+l_value;
1519: END LOOP;
1520: FOR csr_balance IN csr_balances(g_business_group_id,'801-Comp. post and position') LOOP
1521: fnd_file.put_line(fnd_file.LOG,'steering code 801');
1522: l_balance_type_id:=csr_balance.balance_type_id;
1523: OPEN csr_defined_balances(l_balance_type_id);
1524: FETCH csr_defined_balances INTO l_defined_balance_id;
1525: CLOSE csr_defined_balances;

Line 1532: fnd_file.put_line(fnd_file.LOG,'steering code 802');

1528: P_VIRTUAL_DATE=>g_end_date),0);
1529: l_801_steering_code:=l_801_steering_code+l_value;
1530: END LOOP;
1531: FOR csr_balance IN csr_balances(g_business_group_id,'802-Comp. for calving') LOOP
1532: fnd_file.put_line(fnd_file.LOG,'steering code 802');
1533: l_balance_type_id:=csr_balance.balance_type_id;
1534: OPEN csr_defined_balances(l_balance_type_id);
1535: FETCH csr_defined_balances INTO l_defined_balance_id;
1536: CLOSE csr_defined_balances;

Line 1543: fnd_file.put_line(fnd_file.LOG,'steering code 803');

1539: P_VIRTUAL_DATE=>g_end_date),0);
1540: l_802_steering_code:=l_802_steering_code+l_value;
1541: END LOOP;
1542: FOR csr_balance IN csr_balances(g_business_group_id,'803-Comp. for delegation') LOOP
1543: fnd_file.put_line(fnd_file.LOG,'steering code 803');
1544: l_balance_type_id:=csr_balance.balance_type_id;
1545: OPEN csr_defined_balances(l_balance_type_id);
1546: FETCH csr_defined_balances INTO l_defined_balance_id;
1547: CLOSE csr_defined_balances;

Line 1554: fnd_file.put_line(fnd_file.LOG,'steering code 804');

1550: P_VIRTUAL_DATE=>g_end_date),0);
1551: l_803_steering_code:=l_803_steering_code+l_value;
1552: END LOOP;
1553: FOR csr_balance IN csr_balances(g_business_group_id,'804-Comp. County, Municipal') LOOP
1554: fnd_file.put_line(fnd_file.LOG,'steering code 804');
1555: l_balance_type_id:=csr_balance.balance_type_id;
1556: OPEN csr_defined_balances(l_balance_type_id);
1557: FETCH csr_defined_balances INTO l_defined_balance_id;
1558: CLOSE csr_defined_balances;

Line 1565: fnd_file.put_line(fnd_file.LOG,'steering code 805');

1561: P_VIRTUAL_DATE=>g_end_date),0);
1562: l_804_steering_code:=l_804_steering_code+l_value;
1563: END LOOP;
1564: FOR csr_balance IN csr_balances(g_business_group_id,'805-Comp. for Per Diem') LOOP
1565: fnd_file.put_line(fnd_file.LOG,'steering code 805');
1566: l_balance_type_id:=csr_balance.balance_type_id;
1567: OPEN csr_defined_balances(l_balance_type_id);
1568: FETCH csr_defined_balances INTO l_defined_balance_id;
1569: CLOSE csr_defined_balances;

Line 1576: fnd_file.put_line(fnd_file.LOG,'steering code 806');

1572: P_VIRTUAL_DATE=>g_end_date),0);
1573: l_805_steering_code:=l_805_steering_code+l_value;
1574: END LOOP;
1575: FOR csr_balance IN csr_balances(g_business_group_id,'806-Comp. for Travel Expenses') LOOP
1576: fnd_file.put_line(fnd_file.LOG,'steering code 806');
1577: l_balance_type_id:=csr_balance.balance_type_id;
1578: OPEN csr_defined_balances(l_balance_type_id);
1579: FETCH csr_defined_balances INTO l_defined_balance_id;
1580: CLOSE csr_defined_balances;

Line 1587: fnd_file.put_line(fnd_file.LOG,'steering code 808');

1583: P_VIRTUAL_DATE=>g_end_date),0);
1584: l_806_steering_code:=l_806_steering_code+l_value;
1585: END LOOP;
1586: FOR csr_balance IN csr_balances(g_business_group_id,'808-Comp. for Official Duty') LOOP
1587: fnd_file.put_line(fnd_file.LOG,'steering code 808');
1588: l_balance_type_id:=csr_balance.balance_type_id;
1589: OPEN csr_defined_balances(l_balance_type_id);
1590: FETCH csr_defined_balances INTO l_defined_balance_id;
1591: CLOSE csr_defined_balances;

Line 1597: fnd_file.put_line(fnd_file.LOG,'Before first insertion');

1593: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1594: P_VIRTUAL_DATE=>g_end_date),0);
1595: l_808_steering_code:=l_808_steering_code+l_value;
1596: END LOOP;
1597: fnd_file.put_line(fnd_file.LOG,'Before first insertion');
1598: pay_action_information_api.create_action_information
1599: (p_action_information_id => l_action_info_id
1600: , p_action_context_id => p_payroll_action_id
1601: , p_action_context_type => 'PA'

Line 1634: fnd_file.put_line(fnd_file.LOG,'Before second insertion');

1630: , p_action_information24 => l_600_steering_code
1631: , p_action_information25 => l_601_steering_code
1632: , p_action_information26 => l_810_steering_code
1633: );
1634: fnd_file.put_line(fnd_file.LOG,'Before second insertion');
1635: pay_action_information_api.create_action_information
1636: (p_action_information_id => l_action_info_id
1637: , p_action_context_id => p_payroll_action_id
1638: , p_action_context_type => 'PA'

Line 2956: -- fnd_file.put_line(fnd_file.LOG,'p_xml'||p_xml);

2952:
2953:
2954: WritetoCLOB (p_xml );
2955: --INSERT INTO raaj VALUES (p_xml);
2956: -- fnd_file.put_line(fnd_file.LOG,'p_xml'||p_xml);
2957:
2958:
2959: END POPULATE_DATA_DETAIL;
2960: