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

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

211:
212: /* End of Cursors */
213: BEGIN
214:
215: fnd_file.put_line(fnd_file.log,'Range Code 1');
216:
217: IF g_debug THEN
218: hr_utility.set_location(' Entering Procedure RANGE_CODE',40);
219: END IF;

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

224: WHERE ppa.payroll_action_id = :payroll_action_id
225: AND ppa.business_group_id = ppf.business_group_id
226: ORDER BY ppf.person_id';
227:
228: fnd_file.put_line(fnd_file.log,'Range Code 2');
229:
230: g_archive := NULL;
231: g_emp_type := NULL ;
232: g_legal_employer_id := NULL ;

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

237: g_lu_assignment_action_id := NULL ;
238: g_transact_type := NULL ;
239: g_deduction_ss := NULL ;
240:
241: fnd_file.put_line(fnd_file.log,'Range Code 3');
242:
243: PAY_FI_ARCHIVE_DPSA.GET_ALL_PARAMETERS(
244: p_payroll_action_id
245: ,l_business_group_id

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

250: ,g_deduction_ss
251: ,g_effective_date
252: ,g_archive ) ;
253:
254: fnd_file.put_line(fnd_file.log,'Range Code 4');
255:
256: IF g_archive = 'Y' THEN
257:
258: fnd_file.put_line(fnd_file.log,'Range Code 5');

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

254: fnd_file.put_line(fnd_file.log,'Range Code 4');
255:
256: IF g_archive = 'Y' THEN
257:
258: fnd_file.put_line(fnd_file.log,'Range Code 5');
259:
260: SELECT count(*)
261: INTO l_count
262: FROM pay_action_information

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

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

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

269: IF l_count < 1 then
270:
271: hr_utility.set_location('Entered Procedure GETDATA',10);
272:
273: fnd_file.put_line(fnd_file.log,'Range Code 7');
274:
275: OPEN csr_Legal_Emp_Details(g_legal_employer_id);
276: FETCH csr_Legal_Emp_Details INTO rg_Legal_Emp_Details;
277: CLOSE csr_Legal_Emp_Details;

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

279: l_le_name := rg_Legal_Emp_Details.name ;
280: l_y_number := rg_Legal_Emp_Details.ORG_INFORMATION1 ;
281: l_org_type := rg_Legal_Emp_Details.ORG_INFORMATION13 ;
282:
283: fnd_file.put_line(fnd_file.log,'Range Code 8');
284: IF g_local_unit_id IS NOT NULL THEN
285:
286: fnd_file.put_line(fnd_file.log,'Range Code 9');
287:

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

282:
283: fnd_file.put_line(fnd_file.log,'Range Code 8');
284: IF g_local_unit_id IS NOT NULL THEN
285:
286: fnd_file.put_line(fnd_file.log,'Range Code 9');
287:
288: g_emp_type:='LU' ;
289: l_emp_id:=g_local_unit_id;
290: hr_utility.set_location('Calculation for Local Unit',40);

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

313: l_contact_person := rg_Local_Unit_contact.contact_person ;
314: l_phone := rg_Local_Unit_contact.phone ;
315:
316: hr_utility.set_location('Pick up the contact details belonging to Local Unit',70);
317: fnd_file.put_line(fnd_file.log,'Range Code 10');
318: ELSE
319: fnd_file.put_line(fnd_file.log,'Range Code 11');
320: g_emp_type:='LE' ;
321: l_emp_id:=g_legal_employer_id ;

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

315:
316: hr_utility.set_location('Pick up the contact details belonging to Local Unit',70);
317: fnd_file.put_line(fnd_file.log,'Range Code 10');
318: ELSE
319: fnd_file.put_line(fnd_file.log,'Range Code 11');
320: g_emp_type:='LE' ;
321: l_emp_id:=g_legal_employer_id ;
322:
323: /* Pick up the details belonging to Legal Employer */

Line 341: fnd_file.put_line(fnd_file.log,'Range Code 12');

337:
338: l_contact_person := rg_Legal_Emp_Contact .contact_person ;
339: l_phone := rg_Legal_Emp_Contact .phone ;
340:
341: fnd_file.put_line(fnd_file.log,'Range Code 12');
342:
343: END IF ;
344:
345: fnd_file.put_line(fnd_file.log,'Range Code 13');

Line 345: fnd_file.put_line(fnd_file.log,'Range Code 13');

341: fnd_file.put_line(fnd_file.log,'Range Code 12');
342:
343: END IF ;
344:
345: fnd_file.put_line(fnd_file.log,'Range Code 13');
346:
347:
348: pay_action_information_api.create_action_information (
349: p_action_information_id => l_action_info_id

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

384: ,p_action_information28 => null
385: ,p_action_information29 => null
386: ,p_action_information30 => null );
387:
388: fnd_file.put_line(fnd_file.log,'Range Code 14');
389:
390: pay_action_information_api.create_action_information (
391: p_action_information_id => l_action_info_id
392: ,p_action_context_id => p_payroll_action_id

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

426: ,p_action_information28 => null
427: ,p_action_information29 => null
428: ,p_action_information30 => null );
429:
430: fnd_file.put_line(fnd_file.log,'Range Code 15');
431:
432: END IF;
433:
434: END IF;

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

581:
582:
583: BEGIN
584:
585: fnd_file.put_line(fnd_file.log,'ASSIGNMENT_ACTION_CODE 1');
586:
587: IF g_debug THEN
588: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',60);
589: END IF;

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

598: ,g_deduction_ss
599: ,g_effective_date
600: ,g_archive ) ;
601:
602: fnd_file.put_line(fnd_file.log,'ASSIGNMENT_ACTION_CODE 2');
603:
604: g_payroll_action_id :=p_payroll_action_id;
605: l_canonical_start_date := TO_DATE('01'||g_year,'MMYYYY');
606: l_canonical_end_date := LAST_DAY(TO_DATE('12'||g_year,'MMYYYY'));

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

607: l_prepay_action_id := 0;
608: l_prev_person_id := 0;
609:
610:
611: fnd_file.put_line(fnd_file.log,'ASSIGNMENT_ACTION_CODE 3');
612:
613: IF g_local_unit_id IS NOT NULL THEN
614:
615: g_emp_type := 'LU';

Line 617: fnd_file.put_line(fnd_file.log,'ASSIGNMENT_ACTION_CODE 4');

613: IF g_local_unit_id IS NOT NULL THEN
614:
615: g_emp_type := 'LU';
616:
617: fnd_file.put_line(fnd_file.log,'ASSIGNMENT_ACTION_CODE 4');
618:
619: FOR rec_prepaid_assignments IN csr_prepaid_assignments_lu(p_payroll_action_id
620: ,p_start_person
621: ,p_end_person

Line 641: fnd_file.put_line(fnd_file.log,'ASSIGNMENT_ACTION_CODE 5'||rec_prepaid_assignments.person_id);

637: ,rec_prepaid_assignments.assignment_id
638: ,p_payroll_action_id
639: ,p_chunk
640: ,NULL);
641: fnd_file.put_line(fnd_file.log,'ASSIGNMENT_ACTION_CODE 5'||rec_prepaid_assignments.person_id);
642:
643: END IF;
644: l_prepay_action_id := rec_prepaid_assignments.prepaid_action_id;
645: l_prev_person_id := rec_prepaid_assignments.person_id;

Line 651: fnd_file.put_line(fnd_file.log,'ASSIGNMENT_ACTION_CODE 6');

647:
648: ELSE
649: g_emp_type := 'LE';
650:
651: fnd_file.put_line(fnd_file.log,'ASSIGNMENT_ACTION_CODE 6');
652:
653: FOR rec_prepaid_assignments IN csr_prepaid_assignments_le(p_payroll_action_id
654: ,p_start_person
655: ,p_end_person

Line 673: fnd_file.put_line(fnd_file.log,'ASSIGNMENT_ACTION_CODE 7'||rec_prepaid_assignments.person_id);

669: ,rec_prepaid_assignments.assignment_id
670: ,p_payroll_action_id
671: ,p_chunk
672: ,NULL);
673: fnd_file.put_line(fnd_file.log,'ASSIGNMENT_ACTION_CODE 7'||rec_prepaid_assignments.person_id);
674:
675: END IF;
676: l_prepay_action_id := rec_prepaid_assignments.prepaid_action_id;
677: l_prev_person_id := rec_prepaid_assignments.person_id;

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

698: BEGIN
699: IF g_debug THEN
700: hr_utility.set_location(' Entering Procedure INITIALIZATION_CODE',80);
701: END IF;
702: fnd_file.put_line(fnd_file.log,'INITIALIZATION_CODE 1');
703: IF g_debug THEN
704: hr_utility.set_location(' Leaving Procedure INITIALIZATION_CODE',90);
705: END IF;
706:

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

1027: l_sm_ss NUMBER;
1028: l_month VARCHAR2(2);
1029:
1030: BEGIN
1031: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 1');
1032: /*Initializing all balance variables*/
1033:
1034: l_count :=0;
1035: l_wtax_base :=0;

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

1164: ,g_deduction_ss
1165: ,g_effective_date
1166: ,g_archive ) ;
1167:
1168: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 2');
1169:
1170: IF g_archive='Y' THEN
1171:
1172: l_start_date := TO_DATE('01'||g_year,'MMYYYY');

Line 1175: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 3');

1171:
1172: l_start_date := TO_DATE('01'||g_year,'MMYYYY');
1173: l_end_date := LAST_DAY(TO_DATE('12'||g_year,'MMYYYY'));
1174: l_effective_date := l_end_date ;
1175: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 3');
1176:
1177: /* Fetching Person Details */
1178: OPEN csr_asg_effective_date(p_assignment_action_id , l_start_date , l_end_date , g_business_group_id );
1179: FETCH csr_asg_effective_date INTO rg_csr_asg_effective_date;

Line 1197: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 4'||rg_csr_get_person_details.person_id);

1193: END IF;
1194:
1195: END;
1196:
1197: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 4'||rg_csr_get_person_details.person_id);
1198: l_assignment_action_id:=p_assignment_action_id;
1199:
1200: IF rg_csr_rpt_header.emp_type = 'LU' THEN
1201: l_dimension:='_PER_LU_EMPLTYPE_TC_YTD';

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

1206: l_dimension1:='_PER_LE_YTD';
1207: l_dimension2:='_PER_LE_MONTH';
1208: END IF ;
1209:
1210: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 5');
1211: OPEN csr_Get_Defined_Balance_Id( 'WITHHOLDING_TAX_BASE'||l_dimension1);
1212: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1213: CLOSE csr_Get_Defined_Balance_Id;
1214: l_wtax_base :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;

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

1222: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1223: CLOSE csr_Get_Defined_Balance_Id;
1224: l_notional_base :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;
1225:
1226: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 6');
1227:
1228:
1229: /*Determining Resident Type*/
1230: IF l_wtax_base > 0 THEN

Line 1244: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 7');

1240: l_person_type:= 'WO';
1241: l_record_id := 'VSPSERIE';
1242: END IF;
1243:
1244: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 7');
1245:
1246: OPEN csr_get_tax_card_type(rg_csr_get_person_details.assignment_id ,l_start_date, l_end_date );
1247: FETCH csr_get_tax_card_type INTO l_tax_card_type;
1248: CLOSE csr_get_tax_card_type;

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

1246: OPEN csr_get_tax_card_type(rg_csr_get_person_details.assignment_id ,l_start_date, l_end_date );
1247: FETCH csr_get_tax_card_type INTO l_tax_card_type;
1248: CLOSE csr_get_tax_card_type;
1249:
1250: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 8');
1251: IF l_tax_card_type IS NOT NULL AND l_person_type IS NOT NULL THEN
1252: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 9');
1253:
1254: OPEN csr_Get_Defined_Balance_Id( 'BENEFITS_IN_KIND'||l_dimension1);

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

1248: CLOSE csr_get_tax_card_type;
1249:
1250: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 8');
1251: IF l_tax_card_type IS NOT NULL AND l_person_type IS NOT NULL THEN
1252: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 9');
1253:
1254: OPEN csr_Get_Defined_Balance_Id( 'BENEFITS_IN_KIND'||l_dimension1);
1255: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1256: CLOSE csr_Get_Defined_Balance_Id;

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

1273: IF l_subsidy > 0 THEN
1274: l_subsidy_status:='Y' ;
1275: END IF;
1276:
1277: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 10');
1278:
1279: IF l_person_type= 'FI' THEN
1280:
1281: /*Determining Payment Type*/

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

1282: OPEN csr_Get_Defined_Balance_Id( 'WITHHOLDING_TAX_BASE'||l_dimension);
1283: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1284: CLOSE csr_Get_Defined_Balance_Id;
1285:
1286: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 11');
1287:
1288: IF l_tax_card_type in ('P', 'C' ) THEN
1289:
1290: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 12');

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

1286: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 11');
1287:
1288: IF l_tax_card_type in ('P', 'C' ) THEN
1289:
1290: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 12');
1291: l_ptp_1_wtax_base :=pay_balance_pkg.get_value
1292: (P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id
1293: ,P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id
1294: ,P_TAX_UNIT_ID =>g_legal_employer_id

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

1331: ,P_SOURCE_NUMBER2 =>NULL
1332: ,P_ORGANIZATION_ID =>NULL
1333: ) ;
1334:
1335: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 13');
1336: END IF;
1337:
1338: IF l_tax_card_type in ('EI', 'FT','S' ) AND (l_ptp_1_wtax_base + l_ptp_2_wtax_base) <=0 THEN
1339: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 14');

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

1335: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 13');
1336: END IF;
1337:
1338: IF l_tax_card_type in ('EI', 'FT','S' ) AND (l_ptp_1_wtax_base + l_ptp_2_wtax_base) <=0 THEN
1339: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 14');
1340: l_pt1_1_wtax_base :=pay_balance_pkg.get_value
1341: (P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id
1342: ,P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id
1343: ,P_TAX_UNIT_ID =>g_legal_employer_id

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

1379: ,P_LOCAL_UNIT_ID =>g_local_unit_id
1380: ,P_SOURCE_NUMBER2 =>NULL
1381: ,P_ORGANIZATION_ID =>NULL
1382: ) ;
1383: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 15');
1384: END IF;
1385:
1386: IF l_tax_card_type in ('C','FT','EI','P', 'S' )
1387: AND (l_ptp_1_wtax_base + l_ptp_2_wtax_base + l_pt1_1_wtax_base + l_pt1_2_wtax_base ) <=0 THEN

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

1384: END IF;
1385:
1386: IF l_tax_card_type in ('C','FT','EI','P', 'S' )
1387: AND (l_ptp_1_wtax_base + l_ptp_2_wtax_base + l_pt1_1_wtax_base + l_pt1_2_wtax_base ) <=0 THEN
1388: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 16');
1389: l_ptp2_1_wtax_base :=pay_balance_pkg.get_value
1390: (P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id
1391: ,P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id
1392: ,P_TAX_UNIT_ID =>g_legal_employer_id

Line 1432: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 17');

1428: ,P_LOCAL_UNIT_ID =>g_local_unit_id
1429: ,P_SOURCE_NUMBER2 =>NULL
1430: ,P_ORGANIZATION_ID =>NULL
1431: ) ;
1432: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 17');
1433:
1434: END IF;
1435:
1436:

Line 1439: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 18');

1435:
1436:
1437: IF l_tax_card_type in ('EI', 'FT','S' )
1438: AND (l_ptp_1_wtax_base + l_ptp_2_wtax_base + l_pt1_1_wtax_base + l_pt1_2_wtax_base + l_ptp2_2_wtax_base + l_ptp2_2_wtax_base) <=0 THEN
1439: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 18');
1440: l_pth_1_wtax_base :=pay_balance_pkg.get_value
1441: (P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id
1442: ,P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id
1443: ,P_TAX_UNIT_ID =>g_legal_employer_id

Line 1484: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 19');

1480: ,P_SOURCE_NUMBER2 =>NULL
1481: ,P_ORGANIZATION_ID =>NULL
1482: ) ;
1483:
1484: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 19');
1485: END IF;
1486:
1487: IF l_tax_card_type in ('EI', 'FT','S' )
1488: AND (l_ptp_1_wtax_base + l_ptp_2_wtax_base + l_pt1_1_wtax_base + l_pt1_2_wtax_base + l_ptp2_2_wtax_base

Line 1490: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 20');

1486:
1487: IF l_tax_card_type in ('EI', 'FT','S' )
1488: AND (l_ptp_1_wtax_base + l_ptp_2_wtax_base + l_pt1_1_wtax_base + l_pt1_2_wtax_base + l_ptp2_2_wtax_base
1489: + l_ptp2_2_wtax_base + l_pth_1_wtax_base + l_pth_2_wtax_base ) <=0 THEN
1490: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 20');
1491: l_pth2_1_wtax_base :=pay_balance_pkg.get_value
1492: (P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id
1493: ,P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id
1494: ,P_TAX_UNIT_ID =>g_legal_employer_id

Line 1534: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 21');

1530: ,P_LOCAL_UNIT_ID =>g_local_unit_id
1531: ,P_SOURCE_NUMBER2 =>NULL
1532: ,P_ORGANIZATION_ID =>NULL
1533: ) ;
1534: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 21');
1535: END IF;
1536: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 22');
1537: /*Determining Contexts*/
1538: IF l_tax_card_type IN ('P', 'C' ) AND ( l_ptp_1_wtax_base + l_ptp_2_wtax_base ) > 0 THEN

Line 1536: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 22');

1532: ,P_ORGANIZATION_ID =>NULL
1533: ) ;
1534: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 21');
1535: END IF;
1536: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 22');
1537: /*Determining Contexts*/
1538: IF l_tax_card_type IN ('P', 'C' ) AND ( l_ptp_1_wtax_base + l_ptp_2_wtax_base ) > 0 THEN
1539: l_payment_type:= 'P';
1540: IF l_ptp_1_wtax_base > 0 THEN

Line 1629: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 23');

1625: CLOSE csr_Get_Defined_Balance_Id;
1626:
1627: l_cum_mileage :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;
1628:
1629: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 23');
1630: BEGIN
1631: FOR balance_rec IN csr_balance('Mortgage Benefit' , rg_csr_get_person_details.business_group_id)
1632: LOOP
1633: OPEN csr_bg_Get_Defined_Balance_Id( balance_rec.balance_name||l_dimension1,rg_csr_get_person_details.business_group_id);

Line 2004: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 24');

2000: END;
2001:
2002: l_631:= l_tot_ss_ded + l_exem_ss;
2003:
2004: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 24');
2005:
2006:
2007:
2008: ELSIF l_person_type= 'FR' THEN

Line 2010: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 25');

2006:
2007:
2008: ELSIF l_person_type= 'FR' THEN
2009:
2010: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 25');
2011:
2012: /*Determining Payment Type*/
2013: OPEN csr_Get_Defined_Balance_Id( 'TAX_AT_SOURCE_BASE'||l_dimension);
2014: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;

Line 2162: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 26');

2158: ,P_SOURCE_NUMBER2 =>NULL
2159: ,P_ORGANIZATION_ID =>NULL
2160: ) ;
2161: END IF;
2162: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 26');
2163: l_org_type:=rg_csr_rpt_header.org_type;
2164:
2165: /*Determining Contexts*/
2166: IF l_tax_card_type IN ('TS' ) THEN

Line 2167: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 26'||l_tax_card_type);

2163: l_org_type:=rg_csr_rpt_header.org_type;
2164:
2165: /*Determining Contexts*/
2166: IF l_tax_card_type IN ('TS' ) THEN
2167: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 26'||l_tax_card_type);
2168:
2169: IF (l_pta1_1_tstax_base + l_pta1_2_tstax_base) > 0 AND l_org_type = 'PRIV' THEN
2170: l_payment_type:= 'A1';
2171: IF l_pta1_1_tstax_base > 0 THEN

Line 2214: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 27');

2210: l_source_text :='PEMP';
2211: l_source_text2 :='KP' ;
2212: l_tax_base:=l_pta7_1_tstax_base;
2213: END IF;
2214: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 27');
2215: /* Fetching Person Address Details */
2216: OPEN csr_per_address( rg_csr_get_person_details.person_id , rg_csr_get_person_details.business_group_id );
2217: FETCH csr_per_address INTO rg_csr_per_address;
2218: CLOSE csr_per_address;

Line 2256: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 28');

2252: l_place_residence:=null;
2253: END IF;
2254:
2255: END IF;
2256: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 28');
2257:
2258: ELSIF l_person_type= 'WO' THEN
2259:
2260: l_payment_type:= '5';

Line 2262: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 29');

2258: ELSIF l_person_type= 'WO' THEN
2259:
2260: l_payment_type:= '5';
2261: /*
2262: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 29');
2263: OPEN csr_Get_Defined_Balance_Id( 'NOTIONAL_SALARY'||l_dimension);
2264: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
2265: CLOSE csr_Get_Defined_Balance_Id;
2266:

Line 2334: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 31');

2330: END IF;
2331:
2332:
2333: IF l_person_type<> 'WO' THEN
2334: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 31');
2335:
2336: OPEN csr_Get_Defined_Balance_Id( 'OTHER_PAYMENTS_SUBJECT_TO_TAX'||l_dimension1);
2337: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
2338: CLOSE csr_Get_Defined_Balance_Id;

Line 2348: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 32');

2344: CLOSE csr_Get_Defined_Balance_Id;
2345:
2346: l_ptg_base :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;
2347:
2348: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 32');
2349:
2350: IF l_tax_card_type <>'TS' THEN
2351: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 33');
2352:

Line 2351: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 33');

2347:
2348: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 32');
2349:
2350: IF l_tax_card_type <>'TS' THEN
2351: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 33');
2352:
2353: OPEN csr_Get_Defined_Balance_Id( 'CAPITAL_INCOME_BASE'||l_dimension1);
2354: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
2355: CLOSE csr_Get_Defined_Balance_Id;

Line 2369: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 34');

2365:
2366: END IF;
2367:
2368: /*Proportion the Tax Base and Tax according to Payment Types*/
2369: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 34');
2370: IF l_tax_base > 0 THEN
2371: l_mtax_base := l_tax_base - (l_pth4_base + l_ptg_base) ;
2372: l_mtax := round((l_mtax_base/l_tax_base) * l_tax,2);
2373:

Line 2405: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 35');

2401: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
2402: CLOSE csr_Get_Defined_Balance_Id;
2403:
2404: l_external_expenses :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;
2405: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 35');
2406: END IF;
2407:
2408: IF l_payment_type IS NOT NULL THEN
2409: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 36');

Line 2409: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 36');

2405: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 35');
2406: END IF;
2407:
2408: IF l_payment_type IS NOT NULL THEN
2409: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 36');
2410: OPEN csr_arch_chk(l_record_id , l_payment_type , p_assignment_action_id);
2411: FETCH csr_arch_chk INTO l_count;
2412: CLOSE csr_arch_chk;
2413:

Line 2493: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 37');

2489: END LOOP;
2490:
2491: ELSE
2492:
2493: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 37');
2494: pay_action_information_api.create_action_information (
2495: p_action_information_id=> l_action_info_id,
2496: p_action_context_id=> p_assignment_action_id,
2497: p_action_context_type=> 'AAP',

Line 2662: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 38');

2658: p_action_information30 =>NULL
2659: );
2660: END IF;
2661:
2662: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 38');
2663: IF l_s3_tax_base > 0 THEN
2664: pay_action_information_api.create_action_information (
2665: p_action_information_id=> l_action_info_id,
2666: p_action_context_id=> p_assignment_action_id,

Line 2709: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 39');

2705:
2706: END IF;
2707:
2708: ELSIF l_count < 1 and l_record_id ='VSRAERIE' THEN
2709: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 39');
2710:
2711: pay_action_information_api.create_action_information (
2712: p_action_information_id=> l_action_info_id,
2713: p_action_context_id=> p_assignment_action_id,

Line 2837: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 40');

2833: p_action_information30=> NULL
2834: );
2835: END IF;
2836:
2837: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 40');
2838: END IF;
2839:
2840: IF l_subsidy_status ='Y' THEN
2841:

Line 3111: fnd_file.put_line(fnd_file.log,'DEINITIALIZATION_CODE 1');

3107:
3108:
3109:
3110: BEGIN
3111: fnd_file.put_line(fnd_file.log,'DEINITIALIZATION_CODE 1');
3112: /*Initializing the variables*/
3113:
3114: l_tot_count :=0;
3115: l_tot_bik :=0;

Line 3150: fnd_file.put_line(fnd_file.log,'DEINITIALIZATION_CODE 3');

3146: g_transact_type := 2;
3147: END IF;
3148:
3149: IF g_archive='Y' THEN
3150: fnd_file.put_line(fnd_file.log,'DEINITIALIZATION_CODE 3');
3151:
3152: FOR rg_csr_arch_fi IN csr_arch_fi(p_payroll_action_id)
3153: LOOP
3154: fnd_file.put_line(fnd_file.log,'DEINITIALIZATION_CODE 4');

Line 3154: fnd_file.put_line(fnd_file.log,'DEINITIALIZATION_CODE 4');

3150: fnd_file.put_line(fnd_file.log,'DEINITIALIZATION_CODE 3');
3151:
3152: FOR rg_csr_arch_fi IN csr_arch_fi(p_payroll_action_id)
3153: LOOP
3154: fnd_file.put_line(fnd_file.log,'DEINITIALIZATION_CODE 4');
3155:
3156:
3157: IF rg_csr_arch_fi.payment_type ='H' THEN
3158: OPEN csr_arch_fi_p2(p_payroll_action_id);

Line 3162: fnd_file.put_line(fnd_file.log,'DEINITIALIZATION_CODE 5');

3158: OPEN csr_arch_fi_p2(p_payroll_action_id);
3159: FETCH csr_arch_fi_p2 INTO rg_csr_arch_fi_p2;
3160: CLOSE csr_arch_fi_p2;
3161:
3162: fnd_file.put_line(fnd_file.log,'DEINITIALIZATION_CODE 5');
3163: pay_action_information_api.create_action_information (
3164: p_action_information_id=> l_action_info_id,
3165: p_action_context_id=> p_payroll_action_id,
3166: p_action_context_type=> 'PA',

Line 3211: fnd_file.put_line(fnd_file.log,'DEINITIALIZATION_CODE 6');

3207: l_tot_payment:= nvl(rg_csr_arch_fi.payment,0) + nvl(rg_csr_arch_fi_p2.payment,0) + l_tot_payment;
3208: l_tot_631:= nvl(rg_csr_arch_fi.code_631,0) + nvl(rg_csr_arch_fi_p2.code_631,0) + l_tot_631;
3209: l_tot_670:= nvl(rg_csr_arch_fi.code_670,0) + nvl(rg_csr_arch_fi_p2.code_670,0) + l_tot_670;
3210:
3211: fnd_file.put_line(fnd_file.log,'DEINITIALIZATION_CODE 6');
3212: ELSE
3213: pay_action_information_api.create_action_information (
3214: p_action_information_id=> l_action_info_id,
3215: p_action_context_id=> p_payroll_action_id,

Line 3261: fnd_file.put_line(fnd_file.log,'DEINITIALIZATION_CODE 6');

3257: l_tot_pen_unemp_ins:= nvl(rg_csr_arch_fi.pen_unemp_ins,0) + l_tot_pen_unemp_ins;
3258: l_tot_payment:= nvl(rg_csr_arch_fi.payment,0) + l_tot_payment;
3259: l_tot_631:= nvl(rg_csr_arch_fi.code_631,0) + l_tot_631;
3260: l_tot_670:= nvl(rg_csr_arch_fi.code_670,0) + l_tot_670;
3261: fnd_file.put_line(fnd_file.log,'DEINITIALIZATION_CODE 6');
3262:
3263: END IF;
3264: END LOOP;
3265: fnd_file.put_line(fnd_file.log,'DEINITIALIZATION_CODE 7');

Line 3265: fnd_file.put_line(fnd_file.log,'DEINITIALIZATION_CODE 7');

3261: fnd_file.put_line(fnd_file.log,'DEINITIALIZATION_CODE 6');
3262:
3263: END IF;
3264: END LOOP;
3265: fnd_file.put_line(fnd_file.log,'DEINITIALIZATION_CODE 7');
3266: FOR rg_csr_arch_fr_ss IN csr_arch_fr_ss(p_payroll_action_id)
3267: LOOP
3268: fnd_file.put_line(fnd_file.log,'DEINITIALIZATION_CODE 8');
3269: pay_action_information_api.create_action_information (

Line 3268: fnd_file.put_line(fnd_file.log,'DEINITIALIZATION_CODE 8');

3264: END LOOP;
3265: fnd_file.put_line(fnd_file.log,'DEINITIALIZATION_CODE 7');
3266: FOR rg_csr_arch_fr_ss IN csr_arch_fr_ss(p_payroll_action_id)
3267: LOOP
3268: fnd_file.put_line(fnd_file.log,'DEINITIALIZATION_CODE 8');
3269: pay_action_information_api.create_action_information (
3270: p_action_information_id=> l_action_info_id,
3271: p_action_context_id=> p_payroll_action_id,
3272: p_action_context_type=> 'PA',

Line 3314: fnd_file.put_line(fnd_file.log,'DEINITIALIZATION_CODE 9');

3310: l_tot_count := l_tot_count + 1;
3311: l_tot_bik := nvl(rg_csr_arch_fr_ss.bik,0) + l_tot_bik;
3312: l_tot_pretax_ded:= nvl(rg_csr_arch_fr_ss.pretax_ded,0) + l_tot_pretax_ded;
3313: l_tot_payment:= nvl(rg_csr_arch_fr_ss.payment,0) + l_tot_payment;
3314: fnd_file.put_line(fnd_file.log,'DEINITIALIZATION_CODE 9');
3315:
3316: END LOOP;
3317: fnd_file.put_line(fnd_file.log,'DEINITIALIZATION_CODE 10');
3318: FOR rg_csr_arch_fr_nss IN csr_arch_fr_nss(p_payroll_action_id)

Line 3317: fnd_file.put_line(fnd_file.log,'DEINITIALIZATION_CODE 10');

3313: l_tot_payment:= nvl(rg_csr_arch_fr_ss.payment,0) + l_tot_payment;
3314: fnd_file.put_line(fnd_file.log,'DEINITIALIZATION_CODE 9');
3315:
3316: END LOOP;
3317: fnd_file.put_line(fnd_file.log,'DEINITIALIZATION_CODE 10');
3318: FOR rg_csr_arch_fr_nss IN csr_arch_fr_nss(p_payroll_action_id)
3319: LOOP
3320: fnd_file.put_line(fnd_file.log,'DEINITIALIZATION_CODE 11');
3321: pay_action_information_api.create_action_information (

Line 3320: fnd_file.put_line(fnd_file.log,'DEINITIALIZATION_CODE 11');

3316: END LOOP;
3317: fnd_file.put_line(fnd_file.log,'DEINITIALIZATION_CODE 10');
3318: FOR rg_csr_arch_fr_nss IN csr_arch_fr_nss(p_payroll_action_id)
3319: LOOP
3320: fnd_file.put_line(fnd_file.log,'DEINITIALIZATION_CODE 11');
3321: pay_action_information_api.create_action_information (
3322: p_action_information_id=> l_action_info_id,
3323: p_action_context_id=> p_payroll_action_id,
3324: p_action_context_type=> 'PA',

Line 3366: fnd_file.put_line(fnd_file.log,'DEINITIALIZATION_CODE 11');

3362: l_tot_count := l_tot_count + 1;
3363: l_tot_bik := nvl(rg_csr_arch_fr_nss.bik,0) + l_tot_bik;
3364: l_tot_pretax_ded:= nvl(rg_csr_arch_fr_nss.pretax_ded,0) + l_tot_pretax_ded;
3365: l_tot_payment:= nvl(rg_csr_arch_fr_nss.payment ,0) + l_tot_payment;
3366: fnd_file.put_line(fnd_file.log,'DEINITIALIZATION_CODE 11');
3367: END LOOP;
3368:
3369: IF l_tot_payment = 0 THEN
3370: l_payment_status:=1;

Line 3386: fnd_file.put_line(fnd_file.log,'DEINITIALIZATION_CODE 12');

3382: IF g_deduction_ss IS NOT NULL THEN
3383: l_tot_631:= g_deduction_ss*100;
3384: END IF;
3385:
3386: fnd_file.put_line(fnd_file.log,'DEINITIALIZATION_CODE 12');
3387: pay_action_information_api.create_action_information (
3388: p_action_information_id=> l_action_info_id,
3389: p_action_context_id=> p_payroll_action_id,
3390: p_action_context_type=> 'PA',

Line 3428: fnd_file.put_line(fnd_file.log,'DEINITIALIZATION_CODE 14');

3424: p_action_information29=> NULL,
3425: p_action_information30=> NULL
3426: );
3427:
3428: fnd_file.put_line(fnd_file.log,'DEINITIALIZATION_CODE 14');
3429: END IF;
3430:
3431: l_end_code:=0 ;
3432: