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

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

220:
221: /* End of Cursors */
222: BEGIN
223:
224: -- fnd_file.put_line(fnd_file.log,'Range Code 1');
225:
226: IF g_debug THEN
227: hr_utility.set_location(' Entering Procedure RANGE_CODE',40);
228: END IF;

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

228: END IF;
229:
230: p_sql := 'SELECT DISTINCT person_id FROM per_people_f ppf,pay_payroll_actions ppa WHERE ppa.payroll_action_id = :payroll_action_id AND ppa.business_group_id = ppf.business_group_id ORDER BY ppf.person_id';
231:
232: -- fnd_file.put_line(fnd_file.log,'Range Code 2');
233:
234: g_legal_employer_id := NULL ;
235: g_effective_date := NULL ;
236: g_payroll_action_id := p_payroll_action_id ;

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

239: g_payroll_period:=NULL;
240: g_test_submission:=NULL;
241: g_company_terminating:=NULL;
242:
243: -- fnd_file.put_line(fnd_file.log,'Range Code 3');
244:
245: PAY_DK_ARCHIVE_EIN.GET_ALL_PARAMETERS(
246: p_payroll_action_id
247: ,l_business_group_id

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

252: ,g_test_submission
253: ,g_company_terminating) ;
254:
255:
256: -- fnd_file.put_line(fnd_file.log,'Range Code 4');
257:
258: SELECT count(*)
259: INTO l_count
260: FROM pay_action_information

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

261: WHERE action_information_category = 'EMEA REPORT DETAILS'
262: AND action_information1 = 'PYDKEINA'
263: AND action_context_id = p_payroll_action_id;
264:
265: -- fnd_file.put_line(fnd_file.log,'Range Code 6');
266:
267: IF l_count < 1 then
268:
269: hr_utility.set_location('Entered Procedure GETDATA',10);

Line 272: -- fnd_file.put_line(fnd_file.log,'g_legal_employer_id : '||g_legal_employer_id);

268:
269: hr_utility.set_location('Entered Procedure GETDATA',10);
270:
271:
272: -- fnd_file.put_line(fnd_file.log,'g_legal_employer_id : '||g_legal_employer_id);
273: -- fnd_file.put_line(fnd_file.log,'l_business_group_id : '||l_business_group_id);
274: OPEN csr_Legal_Emp_Details(g_legal_employer_id);
275: FETCH csr_Legal_Emp_Details INTO rg_Legal_Emp_Details;
276:

Line 273: -- fnd_file.put_line(fnd_file.log,'l_business_group_id : '||l_business_group_id);

269: hr_utility.set_location('Entered Procedure GETDATA',10);
270:
271:
272: -- fnd_file.put_line(fnd_file.log,'g_legal_employer_id : '||g_legal_employer_id);
273: -- fnd_file.put_line(fnd_file.log,'l_business_group_id : '||l_business_group_id);
274: OPEN csr_Legal_Emp_Details(g_legal_employer_id);
275: FETCH csr_Legal_Emp_Details INTO rg_Legal_Emp_Details;
276:
277: /* if(csr_Legal_Emp_Details%notfound) then

Line 278: fnd_file.put_line(fnd_file.log,'No data found for the legal emp');

274: OPEN csr_Legal_Emp_Details(g_legal_employer_id);
275: FETCH csr_Legal_Emp_Details INTO rg_Legal_Emp_Details;
276:
277: /* if(csr_Legal_Emp_Details%notfound) then
278: fnd_file.put_line(fnd_file.log,'No data found for the legal emp');
279: end if;*/
280:
281: l_le_name := rg_Legal_Emp_Details.name ;
282: l_cvr_number := rg_Legal_Emp_Details.ORG_INFORMATION1 ;

Line 284: -- fnd_file.put_line(fnd_file.log,'l_cvr_number : '||l_cvr_number);

280:
281: l_le_name := rg_Legal_Emp_Details.name ;
282: l_cvr_number := rg_Legal_Emp_Details.ORG_INFORMATION1 ;
283:
284: -- fnd_file.put_line(fnd_file.log,'l_cvr_number : '||l_cvr_number);
285:
286: CLOSE csr_Legal_Emp_Details;
287:
288: /* Pick up the details belonging to Legal Employer

Line 363: fnd_file.put_line(fnd_file.log,HR_DK_UTILITY.GET_MESSAGE('PAY','HR_377103_DK_EINCOME_STATUS'));

359: l_sp_cvr_number := sp.org_information1;
360:
361: -- check the value of e-income data supplier
362: if(sp.org_information3<>'Y') then
363: fnd_file.put_line(fnd_file.log,HR_DK_UTILITY.GET_MESSAGE('PAY','HR_377103_DK_EINCOME_STATUS'));
364: g_flag:=1;
365: else
366: pay_action_information_api.create_action_information (
367: p_action_information_id => l_action_info_id

Line 504: -- fnd_file.put_line(fnd_file.log,'Range Code 14');

500: open csr_payroll_name(g_payroll_id);
501: fetch csr_payroll_name into rg_csr_payroll_name;
502: close csr_payroll_name;
503:
504: -- fnd_file.put_line(fnd_file.log,'Range Code 14');
505: --Report Level Information
506: pay_action_information_api.create_action_information (
507: p_action_information_id => l_action_info_id
508: ,p_action_context_id => p_payroll_action_id

Line 546: -- fnd_file.put_line(fnd_file.log,'Range Code 15');

542: ,p_action_information28 => null
543: ,p_action_information29 => null
544: ,p_action_information30 => null );
545:
546: -- fnd_file.put_line(fnd_file.log,'Range Code 15');
547: end if; -- end g_flag condition
548:
549: END IF;
550:

Line 639: -- fnd_file.put_line(fnd_file.log,'ASSIGNMENT_ACTION_CODE 1');

635: pp csr_pay_periods%rowtype;
636:
637: BEGIN
638: if(g_flag=0) then
639: -- fnd_file.put_line(fnd_file.log,'ASSIGNMENT_ACTION_CODE 1');
640:
641: IF g_debug THEN
642: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',60);
643: END IF;

Line 655: -- fnd_file.put_line(fnd_file.log,'ASSIGNMENT_ACTION_CODE 2');

651: ,g_payroll_period
652: ,g_test_submission
653: ,g_company_terminating) ;
654:
655: -- fnd_file.put_line(fnd_file.log,'ASSIGNMENT_ACTION_CODE 2');
656:
657: g_payroll_action_id :=p_payroll_action_id;
658:
659: open csr_pay_periods(g_payroll_id, g_payroll_period);

Line 667: -- fnd_file.put_line(fnd_file.log,'ASSIGNMENT_ACTION_CODE 3');

663:
664: l_prepay_action_id := 0;
665: l_prev_person_id := 0;
666:
667: -- fnd_file.put_line(fnd_file.log,'ASSIGNMENT_ACTION_CODE 3');
668:
669: FOR rec_prepaid_assignments IN csr_prepaid_assignments_le(p_payroll_action_id
670: ,p_start_person
671: ,p_end_person

Line 692: -- fnd_file.put_line(fnd_file.log,'ASSIGNMENT_ACTION_CODE 7');

688: ,p_payroll_action_id
689: ,p_chunk
690: ,NULL);
691:
692: -- fnd_file.put_line(fnd_file.log,'ASSIGNMENT_ACTION_CODE 7');
693:
694: END IF;
695: l_prepay_action_id := rec_prepaid_assignments.prepaid_action_id;
696: l_prev_person_id := rec_prepaid_assignments.person_id;

Line 721: -- fnd_file.put_line(fnd_file.log,'INITIALIZATION_CODE 1');

717: BEGIN
718: IF g_debug THEN
719: hr_utility.set_location(' Entering Procedure INITIALIZATION_CODE',80);
720: END IF;
721: -- fnd_file.put_line(fnd_file.log,'INITIALIZATION_CODE 1');
722: IF g_debug THEN
723: hr_utility.set_location(' Leaving Procedure INITIALIZATION_CODE',90);
724: END IF;
725:

Line 1049: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 1');

1045: ,p_action_information30 => null);
1046: END;
1047:
1048: BEGIN
1049: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 1');
1050: /*Initializing all balance variables*/
1051: l_sp_bonus :=0;
1052: l_free_phone :=0;
1053: l_mileage :=0;

Line 1100: -- fnd_file.put_line(fnd_file.log,'Fetched report parameters');

1096:
1097: if(g_flag=0) then
1098: if(g_company_terminating='N') then
1099:
1100: -- fnd_file.put_line(fnd_file.log,'Fetched report parameters');
1101:
1102: OPEN csr_get_person_details(p_assignment_action_id, p_effective_date);
1103: FETCH csr_get_person_details into rg_csr_get_person_details;
1104: CLOSE csr_get_person_details;

Line 1109: -- fnd_file.put_line(fnd_file.log,'Fetched person details');

1105: l_assignment_id:=rg_csr_get_person_details.assignment_id;
1106: l_bg_id:=rg_csr_get_person_details.business_group_id;
1107: l_org_id:=rg_csr_get_person_details.organization_id;
1108:
1109: -- fnd_file.put_line(fnd_file.log,'Fetched person details');
1110:
1111: OPEN csr_pay_periods(g_payroll_id,g_payroll_period);
1112: FETCH csr_pay_periods into rg_csr_pay_periods;
1113: l_bal_date:= rg_csr_pay_periods.end_date;

Line 1119: -- fnd_file.put_line(fnd_file.log,'Fetched payroll period details');

1115:
1116: l_start_date:=rg_csr_pay_periods.start_date;
1117: l_end_date:=rg_csr_pay_periods.end_date;
1118:
1119: -- fnd_file.put_line(fnd_file.log,'Fetched payroll period details');
1120:
1121: OPEN csr_get_atp_table_value(l_assignment_id, l_start_date, l_end_date);
1122: FETCH csr_get_atp_table_value into rg_csr_get_atp_table_value;
1123: CLOSE csr_get_atp_table_value;

Line 1125: -- fnd_file.put_line(fnd_file.log,'Fetched atp table value');

1121: OPEN csr_get_atp_table_value(l_assignment_id, l_start_date, l_end_date);
1122: FETCH csr_get_atp_table_value into rg_csr_get_atp_table_value;
1123: CLOSE csr_get_atp_table_value;
1124:
1125: -- fnd_file.put_line(fnd_file.log,'Fetched atp table value');
1126:
1127: -- fnd_file.put_line(fnd_file.log,'bg id:'||l_bg_id);
1128: -- fnd_file.put_line(fnd_file.log,'org id:'||l_org_id);
1129: OPEN csr_get_hr_org_info(l_bg_id,l_org_id);

Line 1127: -- fnd_file.put_line(fnd_file.log,'bg id:'||l_bg_id);

1123: CLOSE csr_get_atp_table_value;
1124:
1125: -- fnd_file.put_line(fnd_file.log,'Fetched atp table value');
1126:
1127: -- fnd_file.put_line(fnd_file.log,'bg id:'||l_bg_id);
1128: -- fnd_file.put_line(fnd_file.log,'org id:'||l_org_id);
1129: OPEN csr_get_hr_org_info(l_bg_id,l_org_id);
1130: FETCH csr_get_hr_org_info into rg_csr_get_hr_org_info;
1131: CLOSE csr_get_hr_org_info;

Line 1128: -- fnd_file.put_line(fnd_file.log,'org id:'||l_org_id);

1124:
1125: -- fnd_file.put_line(fnd_file.log,'Fetched atp table value');
1126:
1127: -- fnd_file.put_line(fnd_file.log,'bg id:'||l_bg_id);
1128: -- fnd_file.put_line(fnd_file.log,'org id:'||l_org_id);
1129: OPEN csr_get_hr_org_info(l_bg_id,l_org_id);
1130: FETCH csr_get_hr_org_info into rg_csr_get_hr_org_info;
1131: CLOSE csr_get_hr_org_info;
1132:

Line 1134: -- fnd_file.put_line(fnd_file.log,'Fetched hr org info');

1130: FETCH csr_get_hr_org_info into rg_csr_get_hr_org_info;
1131: CLOSE csr_get_hr_org_info;
1132:
1133:
1134: -- fnd_file.put_line(fnd_file.log,'Fetched hr org info');
1135:
1136: OPEN csr_Legal_Emp_Details(g_legal_employer_id);
1137: FETCH csr_Legal_Emp_Details INTO rg_Legal_Emp_Details;
1138: CLOSE csr_Legal_Emp_Details;

Line 1140: -- fnd_file.put_line(fnd_file.log,'Fetched legal emp details');

1136: OPEN csr_Legal_Emp_Details(g_legal_employer_id);
1137: FETCH csr_Legal_Emp_Details INTO rg_Legal_Emp_Details;
1138: CLOSE csr_Legal_Emp_Details;
1139:
1140: -- fnd_file.put_line(fnd_file.log,'Fetched legal emp details');
1141:
1142: OPEN csr_get_tax_card_details(l_assignment_id, l_start_date, l_end_date);
1143: FETCH csr_get_tax_card_details INTO rg_csr_get_tax_card_details;
1144: CLOSE csr_get_tax_card_details;

Line 1157: fnd_file.put_line(fnd_file.log,'hire date from per_people_v : '||l_hd);

1153: /* Code for getting the hire date from PER_PEOPLE_V*/
1154: /* begin
1155:
1156: select to_char(HIRE_DATE) into l_hd from PER_PEOPLE_V where NATIONAL_IDENTIFIER=rg_csr_get_person_details.cpr ;
1157: fnd_file.put_line(fnd_file.log,'hire date from per_people_v : '||l_hd);
1158:
1159: exception
1160: when others then
1161: null;

Line 1170: -- fnd_file.put_line(fnd_file.log,'Inserting starters');

1166: CLOSE csr_latest_hire_date;
1167:
1168: l_cpr_number:= rg_csr_get_person_details.cpr;
1169: if((rg_csr_latest_hire_date.lhd between l_start_date and l_end_date) and to_char(l_end_date,'mm')<'06' and to_char(l_end_date,'yyyy')<='2008') then
1170: -- fnd_file.put_line(fnd_file.log,'Inserting starters');
1171: --Record - 2101
1172: pay_action_information_api.create_action_information (
1173: p_action_information_id => l_action_info_id
1174: ,p_action_context_id => p_assignment_action_id

Line 1218: -- fnd_file.put_line(fnd_file.log,'Inserting terminators');

1214: OPEN csr_asg_terminator(p_assignment_action_id, l_start_date, l_end_date, g_business_group_id);
1215: FETCH csr_asg_terminator INTO rg_csr_asg_terminator;
1216:
1217: if(rg_csr_asg_terminator.effective_end_date <= l_end_date) then
1218: -- fnd_file.put_line(fnd_file.log,'Inserting terminators');
1219: --Record - 2101
1220: pay_action_information_api.create_action_information (
1221: p_action_information_id => l_action_info_id
1222: ,p_action_context_id => p_assignment_action_id

Line 1263: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 2');

1259: end if;
1260:
1261: CLOSE csr_asg_terminator;
1262:
1263: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 2');
1264:
1265: l_pu_code :=rg_csr_get_hr_org_info.ORG_INFORMATION6; -- HR-ORG Production Unit Code
1266: if(l_pu_code IS NULL) then
1267: l_pu_code:=rg_Legal_Emp_Details.ORG_INFORMATION6;

Line 1270: -- fnd_file.put_line(fnd_file.log,'PU code:'||l_pu_code);

1266: if(l_pu_code IS NULL) then
1267: l_pu_code:=rg_Legal_Emp_Details.ORG_INFORMATION6;
1268: end if;
1269:
1270: -- fnd_file.put_line(fnd_file.log,'PU code:'||l_pu_code);
1271:
1272: l_cvr_number:= rg_Legal_Emp_Details.ORG_INFORMATION1;
1273:
1274: -- fnd_file.put_line(fnd_file.log,'Person name : '||rg_csr_get_person_details.full_name);

Line 1274: -- fnd_file.put_line(fnd_file.log,'Person name : '||rg_csr_get_person_details.full_name);

1270: -- fnd_file.put_line(fnd_file.log,'PU code:'||l_pu_code);
1271:
1272: l_cvr_number:= rg_Legal_Emp_Details.ORG_INFORMATION1;
1273:
1274: -- fnd_file.put_line(fnd_file.log,'Person name : '||rg_csr_get_person_details.full_name);
1275:
1276: --Record - 6000
1277: pay_action_information_api.create_action_information (
1278: p_action_information_id => l_action_info_id

Line 1317: /* fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 4');

1313: ,p_action_information28 => null
1314: ,p_action_information29 => null
1315: ,p_action_information30 => null);
1316:
1317: /* fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 4');
1318:
1319: fnd_file.put_line(fnd_file.log,'p_assignment_action_id:'||p_assignment_action_id);
1320: fnd_file.put_line(fnd_file.log,'l_bal_date:'||l_bal_date); */
1321: -- Record 6001

Line 1319: fnd_file.put_line(fnd_file.log,'p_assignment_action_id:'||p_assignment_action_id);

1315: ,p_action_information30 => null);
1316:
1317: /* fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 4');
1318:
1319: fnd_file.put_line(fnd_file.log,'p_assignment_action_id:'||p_assignment_action_id);
1320: fnd_file.put_line(fnd_file.log,'l_bal_date:'||l_bal_date); */
1321: -- Record 6001
1322: l_amb_pay := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'AMBable Pay','_ASG_PTD' ,l_bal_date);
1323: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 4.5');

Line 1320: fnd_file.put_line(fnd_file.log,'l_bal_date:'||l_bal_date); */

1316:
1317: /* fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 4');
1318:
1319: fnd_file.put_line(fnd_file.log,'p_assignment_action_id:'||p_assignment_action_id);
1320: fnd_file.put_line(fnd_file.log,'l_bal_date:'||l_bal_date); */
1321: -- Record 6001
1322: l_amb_pay := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'AMBable Pay','_ASG_PTD' ,l_bal_date);
1323: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 4.5');
1324: l_emp_atp := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Employee ATP Deductions','_ASG_PTD' ,l_bal_date);

Line 1323: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 4.5');

1319: fnd_file.put_line(fnd_file.log,'p_assignment_action_id:'||p_assignment_action_id);
1320: fnd_file.put_line(fnd_file.log,'l_bal_date:'||l_bal_date); */
1321: -- Record 6001
1322: l_amb_pay := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'AMBable Pay','_ASG_PTD' ,l_bal_date);
1323: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 4.5');
1324: l_emp_atp := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Employee ATP Deductions','_ASG_PTD' ,l_bal_date);
1325: l_gross_income := l_amb_pay + l_emp_atp;
1326:
1327: if(l_gross_income<>0) then

Line 1331: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 5');

1327: if(l_gross_income<>0) then
1328: REC_6001(rg_csr_get_person_details.PERSON_ID, rg_csr_get_person_details.assignment_ID, '0200',abs(l_gross_income)*1000000,SIGN(l_gross_income));
1329: end if;
1330:
1331: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 5');
1332: l_hourly_holiday_pay := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Holiday Accrual Pay','_ASG_PTD' ,l_bal_date);
1333:
1334: l_monthly_holiday_pay := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Holiday Allowance Paid','_ASG_PTD' ,l_bal_date);
1335:

Line 1357: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 6');

1353: if(l_a_income<>0) then
1354: REC_6001(rg_csr_get_person_details.PERSON_ID, rg_csr_get_person_details.assignment_ID, '0013',abs(l_a_income)*1000000,SIGN(l_a_income));
1355: end if;
1356:
1357: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 6');
1358:
1359: OPEN csr_asg_action_id(rg_csr_get_person_details.assignment_id,g_payroll_id,g_payroll_period,g_legal_employer_id);
1360: FETCH csr_asg_action_id into rg_csr_asg_action_id;
1361: CLOSE csr_asg_action_id;

Line 1370: -- fnd_file.put_line(fnd_file.log,'Hourly Holiday Tax_Payments : '||l_holiday_tax_pay);

1366:
1367: l_emp_tax := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Employee Tax','_ASG_PTD' ,l_bal_date);
1368: -- l_holiday_tax := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Holiday Tax','_ASG_PTD' ,l_bal_date);
1369: l_holiday_tax_pay := pay_balance_pkg.get_value(lr_Get_Defined_Balance_Id.creator_id, rg_csr_asg_action_id.id);
1370: -- fnd_file.put_line(fnd_file.log,'Hourly Holiday Tax_Payments : '||l_holiday_tax_pay);
1371: l_tax := FLOOR(l_emp_tax)+FLOOR(l_holiday_tax_pay);
1372:
1373: if(l_tax<>0) then
1374: REC_6001(rg_csr_get_person_details.PERSON_ID, rg_csr_get_person_details.assignment_ID, '0015',abs(l_tax)*1000000,SIGN(l_tax));

Line 1384: -- fnd_file.put_line(fnd_file.log,'Holiday AMB Reporting (ASG RUN) : '||l_hol_amb_rep);

1380:
1381: l_emp_amb := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Employee AMB Deduction','_ASG_PTD' ,l_bal_date);
1382: -- l_hol_amb := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Holiday AMB','_ASG_PTD' ,l_bal_date);
1383: l_hol_amb_rep := pay_balance_pkg.get_value(lr_Get_Defined_Balance_Id.creator_id, rg_csr_asg_action_id.id);
1384: -- fnd_file.put_line(fnd_file.log,'Holiday AMB Reporting (ASG RUN) : '||l_hol_amb_rep);
1385: l_total_amb := FLOOR(l_emp_amb)+FLOOR(l_hol_amb_rep);
1386:
1387: if(l_total_amb<>0) then
1388: REC_6001(rg_csr_get_person_details.PERSON_ID, rg_csr_get_person_details.assignment_ID, '0016',abs(l_total_amb)*1000000,SIGN(l_total_amb));

Line 1396: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 8');

1392: if(l_car<>0) then
1393: REC_6001(rg_csr_get_person_details.PERSON_ID, rg_csr_get_person_details.assignment_ID,'0019',abs(l_car)*1000000,SIGN(l_car));
1394: end if;
1395:
1396: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 8');
1397: l_board_lodge := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Total Board and Lodge Amount','_ASG_PTD' ,l_bal_date);
1398: if(l_board_lodge<>0) then
1399: REC_6001(rg_csr_get_person_details.PERSON_ID, rg_csr_get_person_details.assignment_ID,'0021',abs(l_board_lodge)*1000000,SIGN(l_board_lodge));
1400: end if;

Line 1402: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 9');

1398: if(l_board_lodge<>0) then
1399: REC_6001(rg_csr_get_person_details.PERSON_ID, rg_csr_get_person_details.assignment_ID,'0021',abs(l_board_lodge)*1000000,SIGN(l_board_lodge));
1400: end if;
1401:
1402: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 9');
1403: l_employer_atp := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Employer ATP Deductions','_ASG_PTD' ,l_bal_date);
1404: l_total_atp := l_emp_atp+l_employer_atp;
1405: if(l_total_atp<>0) then
1406: REC_6001(rg_csr_get_person_details.PERSON_ID, rg_csr_get_person_details.assignment_ID,'0046',abs(l_total_atp)*1000000,SIGN(l_total_atp));

Line 1409: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 10');

1405: if(l_total_atp<>0) then
1406: REC_6001(rg_csr_get_person_details.PERSON_ID, rg_csr_get_person_details.assignment_ID,'0046',abs(l_total_atp)*1000000,SIGN(l_total_atp));
1407: end if;
1408:
1409: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 10');
1410: l_mileage := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Total Mileage Claimed Paid','_ASG_PTD' ,l_bal_date);
1411: if(l_mileage<>0) then
1412: REC_6001(rg_csr_get_person_details.PERSON_ID, rg_csr_get_person_details.assignment_ID,'0048',abs(l_mileage)*1000000,SIGN(l_mileage));
1413: end if;

Line 1415: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 11');

1411: if(l_mileage<>0) then
1412: REC_6001(rg_csr_get_person_details.PERSON_ID, rg_csr_get_person_details.assignment_ID,'0048',abs(l_mileage)*1000000,SIGN(l_mileage));
1413: end if;
1414:
1415: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 11');
1416: l_free_phone := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Total Taxable Phone Amount','_ASG_PTD' ,l_bal_date);
1417: if(l_free_phone<>0) then
1418: REC_6001(rg_csr_get_person_details.PERSON_ID, rg_csr_get_person_details.assignment_ID,'0054',abs(l_free_phone)*1000000,SIGN(l_free_phone));
1419: end if;

Line 1421: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 12');

1417: if(l_free_phone<>0) then
1418: REC_6001(rg_csr_get_person_details.PERSON_ID, rg_csr_get_person_details.assignment_ID,'0054',abs(l_free_phone)*1000000,SIGN(l_free_phone));
1419: end if;
1420:
1421: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 12');
1422: l_sp_bonus := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Special Pay','_ASG_PTD' ,l_bal_date);
1423: if(l_sp_bonus<>0) then
1424: REC_6001(rg_csr_get_person_details.PERSON_ID, rg_csr_get_person_details.assignment_ID,'0069',abs(l_sp_bonus)*1000000,SIGN(l_sp_bonus));
1425: end if;

Line 1427: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 13');

1423: if(l_sp_bonus<>0) then
1424: REC_6001(rg_csr_get_person_details.PERSON_ID, rg_csr_get_person_details.assignment_ID,'0069',abs(l_sp_bonus)*1000000,SIGN(l_sp_bonus));
1425: end if;
1426:
1427: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 13');
1428: --Record - 6002
1429: pay_action_information_api.create_action_information (
1430: p_action_information_id => l_action_info_id
1431: ,p_action_context_id => p_assignment_action_id

Line 1469: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 14');

1465: ,p_action_information28 => null
1466: ,p_action_information29 => null
1467: ,p_action_information30 => null);
1468:
1469: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 14');
1470: --Record - 6004
1471: pay_action_information_api.create_action_information (
1472: p_action_information_id => l_action_info_id
1473: ,p_action_context_id => p_assignment_action_id

Line 1514: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 15');

1510:
1511: l_total_atp_hours := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Total ATP Hours','_ASG_PTD' ,l_bal_date);
1512: l_total_atp_hours := ROUND(l_total_atp_hours,2); -- rounding to 2 decimals
1513:
1514: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 15');
1515: --Record - 6005
1516: pay_action_information_api.create_action_information (
1517: p_action_information_id => l_action_info_id
1518: ,p_action_context_id => p_assignment_action_id

Line 1559: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 16');

1555:
1556: end if; -- end company terminating check condition.
1557: end if; -- g_flag
1558:
1559: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 16');
1560: IF g_debug THEN
1561: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',390);
1562: END IF;
1563:

Line 1564: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE END');

1560: IF g_debug THEN
1561: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',390);
1562: END IF;
1563:
1564: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE END');
1565:
1566: EXCEPTION
1567: WHEN others THEN
1568: IF g_debug THEN

Line 1610: -- fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE 1');

1606:
1607: BEGIN
1608: l_end_code:=0 ;
1609: if(g_flag=0) then
1610: -- fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE 1');
1611:
1612: FOR rg_csr_all_rec IN csr_all_rec( p_payroll_action_id)
1613: LOOP
1614: l_end_code:=l_end_code + 1 ;

Line 1615: -- fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE 2');

1611:
1612: FOR rg_csr_all_rec IN csr_all_rec( p_payroll_action_id)
1613: LOOP
1614: l_end_code:=l_end_code + 1 ;
1615: -- fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE 2');
1616:
1617: UPDATE pay_action_information pai
1618: SET pai.action_information30 =LPAD(l_end_code,7,'0')
1619: WHERE CURRENT OF csr_all_rec;

Line 1621: /* fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE 3');

1617: UPDATE pay_action_information pai
1618: SET pai.action_information30 =LPAD(l_end_code,7,'0')
1619: WHERE CURRENT OF csr_all_rec;
1620:
1621: /* fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE 3');
1622: fnd_file.put_line(fnd_file.log,'payroll action id:'||p_payroll_action_id);
1623: fnd_file.put_line(fnd_file.log,'action info 4:'||rg_csr_all_rec.action_information4); */
1624:
1625: IF rg_csr_all_rec.action_information3='6000' THEN

Line 1622: fnd_file.put_line(fnd_file.log,'payroll action id:'||p_payroll_action_id);

1618: SET pai.action_information30 =LPAD(l_end_code,7,'0')
1619: WHERE CURRENT OF csr_all_rec;
1620:
1621: /* fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE 3');
1622: fnd_file.put_line(fnd_file.log,'payroll action id:'||p_payroll_action_id);
1623: fnd_file.put_line(fnd_file.log,'action info 4:'||rg_csr_all_rec.action_information4); */
1624:
1625: IF rg_csr_all_rec.action_information3='6000' THEN
1626: FOR rg_csr_asg_all_rec IN csr_asg_all_rec( p_payroll_action_id,to_number(rg_csr_all_rec.action_information4))

Line 1623: fnd_file.put_line(fnd_file.log,'action info 4:'||rg_csr_all_rec.action_information4); */

1619: WHERE CURRENT OF csr_all_rec;
1620:
1621: /* fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE 3');
1622: fnd_file.put_line(fnd_file.log,'payroll action id:'||p_payroll_action_id);
1623: fnd_file.put_line(fnd_file.log,'action info 4:'||rg_csr_all_rec.action_information4); */
1624:
1625: IF rg_csr_all_rec.action_information3='6000' THEN
1626: FOR rg_csr_asg_all_rec IN csr_asg_all_rec( p_payroll_action_id,to_number(rg_csr_all_rec.action_information4))
1627: LOOP

Line 1632: -- fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE 4');

1628: l_end_code:=l_end_code + 1 ;
1629: UPDATE pay_action_information pai
1630: SET pai.action_information30 =LPAD(l_end_code,7,'0')
1631: WHERE CURRENT OF csr_asg_all_rec;
1632: -- fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE 4');
1633: END LOOP;
1634: END IF;
1635: -- fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE 5');
1636: END LOOP;

Line 1635: -- fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE 5');

1631: WHERE CURRENT OF csr_asg_all_rec;
1632: -- fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE 4');
1633: END LOOP;
1634: END IF;
1635: -- fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE 5');
1636: END LOOP;
1637: l_end_code:=l_end_code + 1 ;
1638:
1639: -- fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE 6');

Line 1639: -- fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE 6');

1635: -- fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE 5');
1636: END LOOP;
1637: l_end_code:=l_end_code + 1 ;
1638:
1639: -- fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE 6');
1640:
1641: pay_action_information_api.create_action_information (
1642: p_action_information_id=> l_action_info_id,
1643: p_action_context_id=> p_payroll_action_id,

Line 1683: -- fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE 7');

1679: p_action_information30=> LPAD(l_end_code,7,'0')
1680: );
1681:
1682: end if; -- g_flag
1683: -- fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE 7');
1684: IF g_debug THEN
1685: hr_utility.set_location(' Leaving Procedure DEINITIALIZATION_CODE',390);
1686: END IF;
1687:

Line 1688: -- fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE 8');

1684: IF g_debug THEN
1685: hr_utility.set_location(' Leaving Procedure DEINITIALIZATION_CODE',390);
1686: END IF;
1687:
1688: -- fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE 8');
1689: EXCEPTION
1690: WHEN others THEN
1691: IF g_debug THEN
1692: hr_utility.set_location('error raised in DEINITIALIZATION_CODE ',5);