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

Line 69: -- fnd_file.put_line(fnd_file.log,'Entering Function GET_PARAMETER');

65: l_delimiter VARCHAR2(1):=' ';
66: l_proc VARCHAR2(40):= g_package||' get parameter ';
67:
68: BEGIN
69: -- fnd_file.put_line(fnd_file.log,'Entering Function GET_PARAMETER');
70: --
71: IF g_debug THEN
72: hr_utility.set_location(' Entering Function GET_PARAMETER',10);
73: END IF;

Line 100: -- fnd_file.put_line(fnd_file.log,'Leaving Function GET_PARAMETER');

96:
97: IF g_debug THEN
98: hr_utility.set_location(' Leaving Function GET_PARAMETER',20);
99: END IF;
100: -- fnd_file.put_line(fnd_file.log,'Leaving Function GET_PARAMETER');
101: END;
102:
103: --------------------------------- PROCEDURE GET_ALL_PARAMETERS -----------------------------------------------------------------
104:

Line 129: -- fnd_file.put_line(fnd_file.log,'Entering Procedure GET_ALL_PARAMETERS');

125: l_proc VARCHAR2(240):= g_package||' GET_ALL_PARAMETERS ';
126: --
127:
128: BEGIN
129: -- fnd_file.put_line(fnd_file.log,'Entering Procedure GET_ALL_PARAMETERS');
130:
131: OPEN csr_parameter_info (p_payroll_action_id);
132: FETCH csr_parameter_info INTO p_payroll_id
133: ,p_consolidation_set

Line 143: -- fnd_file.put_line(fnd_file.log,'Leaving Procedure GET_ALL_PARAMETERS');

139: --
140: IF g_debug THEN
141: hr_utility.set_location(' Leaving Procedure GET_ALL_PARAMETERS',30);
142: END IF;
143: -- fnd_file.put_line(fnd_file.log,'Leaving Procedure GET_ALL_PARAMETERS');
144:
145: END GET_ALL_PARAMETERS;
146:
147: ----------------------------------- PROCEDURE RANGE_CODE ---------------------------------------------------------------

Line 265: -- fnd_file.put_line(fnd_file.log,'Entering Procedure RANGE_CODE');

261:
262: ----------------
263:
264: BEGIN
265: -- fnd_file.put_line(fnd_file.log,'Entering Procedure RANGE_CODE');
266: IF g_debug THEN
267: hr_utility.set_location(' Entering Procedure RANGE_CODE',40);
268: END IF;
269:

Line 427: -- fnd_file.put_line(fnd_file.log,'Leaving Procedure RANGE_CODE');

423: IF g_debug THEN
424: hr_utility.set_location(' Leaving Procedure RANGE_CODE',50);
425: END IF;
426:
427: -- fnd_file.put_line(fnd_file.log,'Leaving Procedure RANGE_CODE');
428:
429: EXCEPTION
430: WHEN OTHERS THEN
431: -- Return cursor that selects no rows

Line 533: -- fnd_file.put_line(fnd_file.log,'Entering Procedure ASSIGNMENT_ACTION_CODE');

529: ----------------
530:
531: BEGIN
532:
533: -- fnd_file.put_line(fnd_file.log,'Entering Procedure ASSIGNMENT_ACTION_CODE');
534: IF g_debug THEN
535: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',60);
536: END IF;
537:

Line 587: -- fnd_file.put_line(fnd_file.log,'Leaving Procedure ASSIGNMENT_ACTION_CODE');

583:
584: IF g_debug THEN
585: hr_utility.set_location(' Leaving Procedure ASSIGNMENT_ACTION_CODE',70);
586: END IF;
587: -- fnd_file.put_line(fnd_file.log,'Leaving Procedure ASSIGNMENT_ACTION_CODE');
588:
589: END ASSIGNMENT_ACTION_CODE;
590:
591: ------------------------------------- PROCEDURE INITIALIZATION_CODE -------------------------------------------------------------

Line 665: -- fnd_file.put_line(fnd_file.log,'Entering Procedure INITIALIZATION_CODE');

661: ---------------
662:
663: BEGIN
664:
665: -- fnd_file.put_line(fnd_file.log,'Entering Procedure INITIALIZATION_CODE');
666:
667: IF g_debug THEN
668: hr_utility.set_location(' Entering Procedure INITIALIZATION_CODE',80);
669: END IF;

Line 671: /fnd_file.put_line(fnd_file.log,'In INIT_CODE 0');/

667: IF g_debug THEN
668: hr_utility.set_location(' Entering Procedure INITIALIZATION_CODE',80);
669: END IF;
670:
671: /*fnd_file.put_line(fnd_file.log,'In INIT_CODE 0');*/
672:
673:
674:
675: GET_ALL_PARAMETERS(p_payroll_action_id

Line 726: -- fnd_file.put_line(fnd_file.log,'Leaving Procedure INITIALIZATION_CODE');

722:
723: IF g_debug THEN
724: hr_utility.set_location(' Leaving Procedure INITIALIZATION_CODE',90);
725: END IF;
726: -- fnd_file.put_line(fnd_file.log,'Leaving Procedure INITIALIZATION_CODE');
727:
728:
729: EXCEPTION WHEN OTHERS THEN
730: g_err_num := SQLCODE;

Line 731: -- fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In INITIALIZATION_CODE');

727:
728:
729: EXCEPTION WHEN OTHERS THEN
730: g_err_num := SQLCODE;
731: -- fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In INITIALIZATION_CODE');
732:
733: IF g_debug THEN
734: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In INITIALIZATION_CODE',180);
735: END IF;

Line 737: -- fnd_file.put_line(fnd_file.log,'Leaving Procedure INITIALIZATION_CODE');

733: IF g_debug THEN
734: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In INITIALIZATION_CODE',180);
735: END IF;
736:
737: -- fnd_file.put_line(fnd_file.log,'Leaving Procedure INITIALIZATION_CODE');
738:
739: END INITIALIZATION_CODE;
740:
741: ------------------------------------- PROCEDURE SETUP_ELEMENT_DEFINITIONS -------------------------------------------------------------

Line 792: --fnd_file.put_line(fnd_file.log,'SETUP_BALANCE_DEFINITIONS ' ||p_balance_name);

788: g_user_balance_table(g_index_bal).balance_name := p_balance_name;
789: g_user_balance_table(g_index_bal).defined_balance_id := p_defined_balance_id;
790: g_user_balance_table(g_index_bal).balance_type_id := p_balance_type_id;
791:
792: --fnd_file.put_line(fnd_file.log,'SETUP_BALANCE_DEFINITIONS ' ||p_balance_name);
793:
794: IF g_debug THEN
795: hr_utility.set_location(' Leaving Procedure SETUP_BALANCE_DEFINITIONS',130);
796: END IF;

Line 1093: /fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS');/

1089: IF g_debug THEN
1090: hr_utility.set_location(' Entering Procedure ARCHIVE_EMPLOYEE_DETAILS',160);
1091: END IF;
1092:
1093: /*fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS');*/
1094:
1095:
1096: /* PERSON AND ADDRESS DETAILS */
1097: OPEN csr_person_details(p_assignment_id);

Line 1111: /fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 2');/

1107: OPEN csr_organization_address(rec_person_details.org_id);
1108: FETCH csr_organization_address INTO rec_org_address;
1109: CLOSE csr_organization_address;
1110:
1111: /*fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 2');*/
1112:
1113: /* GRADE AND POSITION */
1114:
1115: /* Changed IF condition construct to fix Bug 3583862 */

Line 1128: /fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 3');/

1124: FETCH csr_grade INTO l_grade;
1125: CLOSE csr_grade;
1126: END IF;
1127:
1128: /*fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 3');*/
1129:
1130: /* CURRENCY */
1131:
1132:

Line 1158: /fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 4');/

1154:
1155: /*NATIONALITY*/
1156: l_nationality := hr_general.decode_lookup('NATIONALITY',rec_person_details.nationality);
1157:
1158: /*fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 4');*/
1159:
1160: /*Local Unit*/
1161: /*
1162: OPEN csr_scl_details(p_assignment_id);

Line 1227: /fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 5');/

1223: FETCH csr_org_name INTO l_employer_name ;
1224: CLOSE csr_org_name ;
1225:
1226:
1227: /*fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 5');*/
1228:
1229: IF rec_primary_address.style = 'DK' THEN
1230: l_postal_code := hr_general.decode_lookup('DK_POSTCODE_TOWN',rec_primary_address.postal_code);
1231: ELSIF rec_primary_address.style = 'DK_GLB' and rec_primary_address.city is not null THEN /* 10327065 start */

Line 1274: /fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS gosi reference');/

1270: FETCH csr_le_cvr INTO l_cvr_num ;
1271: CLOSE csr_le_cvr ;
1272:
1273:
1274: /*fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS gosi reference');*/
1275:
1276: /* INSERT PERSON DETAILS */
1277:
1278: pay_action_information_api.create_action_information (

Line 1348: /fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 9');/

1344: ,p_action_information14 => 'Employee Address'
1345: ,p_assignment_id => p_assignment_id);
1346: END IF;
1347:
1348: /*fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 9');*/
1349:
1350: /* INSERT EMPLOYER'S ADDRESS (ORGANIZATION ADDRESS)*/
1351:
1352: BEGIN

Line 1388: /fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 10');/

1384: WHEN OTHERS THEN
1385: NULL;
1386: END;
1387:
1388: /*fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 10');*/
1389:
1390:
1391: --
1392: IF g_debug THEN

Line 1399: /fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In ARCHIVE_EMPLOYEE_DETAILS');/

1395: --
1396:
1397: EXCEPTION WHEN OTHERS THEN
1398: g_err_num := SQLCODE;
1399: /*fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In ARCHIVE_EMPLOYEE_DETAILS');*/
1400:
1401: IF g_debug THEN
1402: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In ARCHIVE_EMPLOYEE_DETAILS',180);
1403: END IF;

Line 1579: /fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In ARCHIVE_ELEMENT_INFO');/

1575: END IF;
1576:
1577: EXCEPTION WHEN OTHERS THEN
1578: g_err_num := SQLCODE;
1579: /*fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In ARCHIVE_ELEMENT_INFO');*/
1580:
1581: IF g_debug THEN
1582: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'ARCHIVE_ELEMENT_INFO',230);
1583: END IF;

Line 1718: /fnd_file.put_line(fnd_file.log,'In ARCHIVE_PAYMENT_INFO 1');/

1714: IF g_debug THEN
1715: hr_utility.set_location(' Entering Procedure ARCHIVE_PAYMENT_INFO',260);
1716: END IF;
1717:
1718: /*fnd_file.put_line(fnd_file.log,'In ARCHIVE_PAYMENT_INFO 1');*/
1719:
1720: OPEN csr_chk(p_prepay_assact_id);
1721: LOOP
1722: FETCH csr_chk INTO rec_chk;

Line 1736: /fnd_file.put_line(fnd_file.log,'In ARCHIVE_PAYMENT_INFO 2');/

1732: l_pay_value := to_char (rec_pers_pay.value,g_format_mask);
1733:
1734: IF (l_ext_acct IS NOT NULL) THEN
1735:
1736: /*fnd_file.put_line(fnd_file.log,'In ARCHIVE_PAYMENT_INFO 2');*/
1737:
1738: --l_bank_reg_num := rec_pers_pay.bank_reg_num;
1739: l_bank_reg_num := rec_pers_pay.bank_reg_num || ' ' ||
1740: hr_general.decode_lookup('HR_DK_BANK_REGISTRATION',rec_pers_pay.bank_reg_num);

Line 1770: /fnd_file.put_line(fnd_file.log,'In ARCHIVE_PAYMENT_INFO 3');/

1766: ,p_action_information18 => rec_pers_pay.opm_name -- rec_pers_pay.pay_type
1767: ,p_assignment_id => p_assignment_id);
1768: ELSE
1769:
1770: /*fnd_file.put_line(fnd_file.log,'In ARCHIVE_PAYMENT_INFO 3');*/
1771:
1772: pay_action_information_api.create_action_information (
1773: p_action_information_id => l_action_info_id
1774: ,p_action_context_id => p_archive_assact_id

Line 1800: /fnd_file.put_line(fnd_file.log,'In ARCHIVE_PAYMENT_INFO 4');/

1796: ,p_action_information18 => rec_pers_pay.opm_name -- rec_pers_pay.pay_type
1797: ,p_assignment_id => p_assignment_id);
1798: END IF;
1799: END LOOP;
1800: /*fnd_file.put_line(fnd_file.log,'In ARCHIVE_PAYMENT_INFO 4');*/
1801:
1802: END IF;
1803:
1804: IF (rec_chk.opm_id IS NOT NULL AND rec_chk.ppm_id IS NULL) THEN

Line 1806: /fnd_file.put_line(fnd_file.log,'In ARCHIVE_PAYMENT_INFO 5');/

1802: END IF;
1803:
1804: IF (rec_chk.opm_id IS NOT NULL AND rec_chk.ppm_id IS NULL) THEN
1805:
1806: /*fnd_file.put_line(fnd_file.log,'In ARCHIVE_PAYMENT_INFO 5');*/
1807:
1808: FOR rec_org_pay IN csr_get_org_pay(p_prepay_assact_id,rec_chk.opm_id) LOOP
1809:
1810: l_pay_value := to_char (rec_org_pay.value,g_format_mask);

Line 1852: /fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In ARCHIVE_PAYMENT_INFO');/

1848:
1849: EXCEPTION WHEN OTHERS THEN
1850: g_err_num := SQLCODE;
1851:
1852: /*fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In ARCHIVE_PAYMENT_INFO');*/
1853:
1854: IF g_debug THEN
1855: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In ARCHIVE_PAYMENT_INFO',280);
1856: END IF;

Line 2000: --fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In ARCHIVE_ACCRUAL_PLAN');

1996: --
1997: END IF;
1998: --
1999: g_err_num := SQLCODE;
2000: --fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In ARCHIVE_ACCRUAL_PLAN');
2001: IF g_debug THEN
2002: hr_utility.set_location('ORA_ERR: ' || g_err_num || ' In ARCHIVE_ACCRUAL_PLAN',310);
2003: END IF;
2004: RAISE;

Line 2291: /fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In ARCHIVE_ADD_ELEMENT');/

2287: -- End Fix to handle Multiple Element Entries
2288:
2289: EXCEPTION WHEN OTHERS THEN
2290: g_err_num := SQLCODE;
2291: /*fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In ARCHIVE_ADD_ELEMENT');*/
2292:
2293: /* IF g_debug THEN
2294: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In ARCHIVE_ADD_ELEMENT',330);
2295: END IF;

Line 2551: /fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In ARCHIVE_ADD_ELEMENT');/

2547: END IF;
2548:
2549: EXCEPTION WHEN OTHERS THEN
2550: g_err_num := SQLCODE;
2551: /*fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In ARCHIVE_ADD_ELEMENT');*/
2552: IF g_debug THEN
2553: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In ARCHIVE_ADD_ELEMENT',330);
2554: END IF;
2555: END;

Line 2622: -- fnd_file.put_line(fnd_file.log,'In ARCHIVE_OTH_BALANCE 0');

2618: IF g_debug THEN
2619: hr_utility.set_location(' Entering Procedure ARCHIVE_OTH_BALANCE',350);
2620: END IF;
2621:
2622: -- fnd_file.put_line(fnd_file.log,'In ARCHIVE_OTH_BALANCE 0');
2623: /*fnd_file.put_line(fnd_file.log,'Entering In ARCHIVE_OTH_BALANCE global');*/
2624:
2625: IF p_archive_flag = 'N' THEN
2626: ---------------------------------------------------

Line 2623: /fnd_file.put_line(fnd_file.log,'Entering In ARCHIVE_OTH_BALANCE global');/

2619: hr_utility.set_location(' Entering Procedure ARCHIVE_OTH_BALANCE',350);
2620: END IF;
2621:
2622: -- fnd_file.put_line(fnd_file.log,'In ARCHIVE_OTH_BALANCE 0');
2623: /*fnd_file.put_line(fnd_file.log,'Entering In ARCHIVE_OTH_BALANCE global');*/
2624:
2625: IF p_archive_flag = 'N' THEN
2626: ---------------------------------------------------
2627: --Check if global table has already been populated

Line 2782: -- fnd_file.put_line(fnd_file.log,'In ARCHIVE_OTH_BALANCE 1');

2778: PAY_BALANCE_PKG.SET_CONTEXT('TAX_UNIT_ID',l_tu_id);
2779: PAY_BALANCE_PKG.SET_CONTEXT('DATE_EARNED',fnd_date.date_to_canonical(p_date_earned));
2780:
2781: IF g_user_balance_table.count > 0 THEN
2782: -- fnd_file.put_line(fnd_file.log,'In ARCHIVE_OTH_BALANCE 1');
2783:
2784: FOR l_index IN g_user_balance_table.first.. g_user_balance_table.last LOOP
2785:
2786: l_balance_value := pay_balance_pkg.get_value(g_user_balance_table(l_index).defined_balance_id,p_assignment_action_id);

Line 2789: -- fnd_file.put_line(fnd_file.log,'In ARCHIVE_OTH_BALANCE 2 :' || l_balance_value);

2785:
2786: l_balance_value := pay_balance_pkg.get_value(g_user_balance_table(l_index).defined_balance_id,p_assignment_action_id);
2787:
2788: IF l_balance_value > 0 THEN
2789: -- fnd_file.put_line(fnd_file.log,'In ARCHIVE_OTH_BALANCE 2 :' || l_balance_value);
2790: pay_action_information_api.create_action_information (
2791: p_action_information_id => l_action_info_id
2792: ,p_action_context_id => p_archive_assact_id
2793: ,p_action_context_type => 'AAP'

Line 2812: -- fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In ARCHIVE_OTH_BALANCE'||SQLERRM);

2808: END IF;
2809:
2810: EXCEPTION WHEN OTHERS THEN
2811: g_err_num := SQLCODE;
2812: -- fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In ARCHIVE_OTH_BALANCE'||SQLERRM);
2813:
2814: IF g_debug THEN
2815: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In ARCHIVE_OTH_BALANCE',360);
2816: END IF;

Line 2903: -- fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_CODE');

2899: ------------------
2900:
2901: BEGIN
2902:
2903: -- fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_CODE');
2904:
2905: IF g_debug THEN
2906: hr_utility.set_location(' Entering Procedure ARCHIVE_CODE',380);
2907: END IF;

Line 2913: -- fnd_file.put_line(fnd_file.log,'closed csr_archive_payact');

2909: OPEN csr_archive_payact(p_assignment_action_id);
2910: FETCH csr_archive_payact INTO l_archive_payact_id;
2911: CLOSE csr_archive_payact;
2912:
2913: -- fnd_file.put_line(fnd_file.log,'closed csr_archive_payact');
2914:
2915: l_record_count := 0;
2916:
2917: FOR rec_archive_ids IN csr_archive_ids(p_assignment_action_id) LOOP

Line 2923: -- fnd_file.put_line(fnd_file.log,'closed csr_period_end_date');

2919: OPEN csr_period_end_date(rec_archive_ids.run_assact_id,rec_archive_ids.run_payact_id);
2920: FETCH csr_period_end_date INTO l_end_date,l_reg_payment_date,l_time_period_id,l_date_earned,l_effective_date,l_start_date;
2921: CLOSE csr_period_end_date;
2922:
2923: -- fnd_file.put_line(fnd_file.log,'closed csr_period_end_date');
2924:
2925: OPEN csr_period_end_date(rec_archive_ids.prepay_assact_id,rec_archive_ids.prepay_payact_id);
2926: FETCH csr_period_end_date INTO l_pre_end_date,l_pre_reg_payment_date,l_pre_time_period_id,l_pre_date_earned,l_pre_effective_date,l_pre_start_date;
2927: CLOSE csr_period_end_date;

Line 2929: -- fnd_file.put_line(fnd_file.log,'closed csr_period_end_date');

2925: OPEN csr_period_end_date(rec_archive_ids.prepay_assact_id,rec_archive_ids.prepay_payact_id);
2926: FETCH csr_period_end_date INTO l_pre_end_date,l_pre_reg_payment_date,l_pre_time_period_id,l_pre_date_earned,l_pre_effective_date,l_pre_start_date;
2927: CLOSE csr_period_end_date;
2928:
2929: -- fnd_file.put_line(fnd_file.log,'closed csr_period_end_date');
2930:
2931: /*fnd_file.put_line(fnd_file.log,'ARCHIVE_EMPLOYEE_DETAILS');*/
2932:
2933: -------------------------------------------------------------

Line 2931: /fnd_file.put_line(fnd_file.log,'ARCHIVE_EMPLOYEE_DETAILS');/

2927: CLOSE csr_period_end_date;
2928:
2929: -- fnd_file.put_line(fnd_file.log,'closed csr_period_end_date');
2930:
2931: /*fnd_file.put_line(fnd_file.log,'ARCHIVE_EMPLOYEE_DETAILS');*/
2932:
2933: -------------------------------------------------------------
2934: --Archive EMPLOYEE_DETAILS, PAYMENT_INFO and BALANCES
2935: --for every prepayment assignment action id

Line 2940: -- fnd_file.put_line(fnd_file.log,'in ARCHIVE_EMPLOYEE_DETAILS');

2936: -------------------------------------------------------------
2937:
2938: IF (rec_archive_ids.prepay_assact_id <> l_prev_prepay) THEN
2939:
2940: -- fnd_file.put_line(fnd_file.log,'in ARCHIVE_EMPLOYEE_DETAILS');
2941:
2942: /*
2943: ARCHIVE_EMPLOYEE_DETAILS(p_archive_assact_id => p_assignment_action_id
2944: ,p_assignment_id => rec_archive_ids.run_assgt_id

Line 2965: -- fnd_file.put_line(fnd_file.log,'out ARCHIVE_EMPLOYEE_DETAILS');

2961: ,p_date_earned => l_date_earned
2962: ,p_pay_date_earned => l_date_earned
2963: ,p_effective_date => p_effective_date);
2964:
2965: -- fnd_file.put_line(fnd_file.log,'out ARCHIVE_EMPLOYEE_DETAILS');
2966: -- fnd_file.put_line(fnd_file.log,'in ARCHIVE_ADDL_EMP_DETAILS');
2967:
2968: ARCHIVE_ADDL_EMP_DETAILS(p_archive_assact_id => p_assignment_action_id
2969: ,p_assignment_id => rec_archive_ids.run_assgt_id

Line 2966: -- fnd_file.put_line(fnd_file.log,'in ARCHIVE_ADDL_EMP_DETAILS');

2962: ,p_pay_date_earned => l_date_earned
2963: ,p_effective_date => p_effective_date);
2964:
2965: -- fnd_file.put_line(fnd_file.log,'out ARCHIVE_EMPLOYEE_DETAILS');
2966: -- fnd_file.put_line(fnd_file.log,'in ARCHIVE_ADDL_EMP_DETAILS');
2967:
2968: ARCHIVE_ADDL_EMP_DETAILS(p_archive_assact_id => p_assignment_action_id
2969: ,p_assignment_id => rec_archive_ids.run_assgt_id
2970: ,p_assignment_action_id => rec_archive_ids.run_assact_id

Line 2976: -- fnd_file.put_line(fnd_file.log,'out ARCHIVE_ADDL_EMP_DETAILS');

2972: ,p_date_earned => l_date_earned
2973: ,p_payroll_action_id => l_archive_payact_id );
2974:
2975:
2976: -- fnd_file.put_line(fnd_file.log,'out ARCHIVE_ADDL_EMP_DETAILS');
2977: -- fnd_file.put_line(fnd_file.log,'in ARCHIVE_PAYMENT_INFO');
2978:
2979: /*fnd_file.put_line(fnd_file.log,'ARCHIVE_PAYMENT_INFO');*/
2980:

Line 2977: -- fnd_file.put_line(fnd_file.log,'in ARCHIVE_PAYMENT_INFO');

2973: ,p_payroll_action_id => l_archive_payact_id );
2974:
2975:
2976: -- fnd_file.put_line(fnd_file.log,'out ARCHIVE_ADDL_EMP_DETAILS');
2977: -- fnd_file.put_line(fnd_file.log,'in ARCHIVE_PAYMENT_INFO');
2978:
2979: /*fnd_file.put_line(fnd_file.log,'ARCHIVE_PAYMENT_INFO');*/
2980:
2981: /*

Line 2979: /fnd_file.put_line(fnd_file.log,'ARCHIVE_PAYMENT_INFO');/

2975:
2976: -- fnd_file.put_line(fnd_file.log,'out ARCHIVE_ADDL_EMP_DETAILS');
2977: -- fnd_file.put_line(fnd_file.log,'in ARCHIVE_PAYMENT_INFO');
2978:
2979: /*fnd_file.put_line(fnd_file.log,'ARCHIVE_PAYMENT_INFO');*/
2980:
2981: /*
2982: ARCHIVE_PAYMENT_INFO(p_archive_assact_id => p_assignment_action_id,
2983: p_prepay_assact_id => rec_archive_ids.prepay_assact_id,

Line 2998: -- fnd_file.put_line(fnd_file.log,'out ARCHIVE_PAYMENT_INFO');

2994: p_assignment_id => rec_archive_ids.prepay_assgt_id,
2995: p_date_earned => l_date_earned,
2996: p_effective_date => p_effective_date);
2997:
2998: -- fnd_file.put_line(fnd_file.log,'out ARCHIVE_PAYMENT_INFO');
2999: -- fnd_file.put_line(fnd_file.log,'in ARCHIVE_OTH_BALANCE');
3000:
3001: /*fnd_file.put_line(fnd_file.log,'ARCHIVE_OTH_BALANCE');*/
3002:

Line 2999: -- fnd_file.put_line(fnd_file.log,'in ARCHIVE_OTH_BALANCE');

2995: p_date_earned => l_date_earned,
2996: p_effective_date => p_effective_date);
2997:
2998: -- fnd_file.put_line(fnd_file.log,'out ARCHIVE_PAYMENT_INFO');
2999: -- fnd_file.put_line(fnd_file.log,'in ARCHIVE_OTH_BALANCE');
3000:
3001: /*fnd_file.put_line(fnd_file.log,'ARCHIVE_OTH_BALANCE');*/
3002:
3003: ARCHIVE_OTH_BALANCE(p_archive_assact_id => p_assignment_action_id,

Line 3001: /fnd_file.put_line(fnd_file.log,'ARCHIVE_OTH_BALANCE');/

2997:
2998: -- fnd_file.put_line(fnd_file.log,'out ARCHIVE_PAYMENT_INFO');
2999: -- fnd_file.put_line(fnd_file.log,'in ARCHIVE_OTH_BALANCE');
3000:
3001: /*fnd_file.put_line(fnd_file.log,'ARCHIVE_OTH_BALANCE');*/
3002:
3003: ARCHIVE_OTH_BALANCE(p_archive_assact_id => p_assignment_action_id,
3004: p_assignment_action_id => rec_archive_ids.run_assact_id,
3005: p_assignment_id => rec_archive_ids.run_assgt_id,

Line 3013: -- fnd_file.put_line(fnd_file.log,'out ARCHIVE_OTH_BALANCE');

3009: p_effective_date => p_effective_date,
3010: p_date_earned => l_date_earned,
3011: p_archive_flag => 'Y');
3012:
3013: -- fnd_file.put_line(fnd_file.log,'out ARCHIVE_OTH_BALANCE');
3014: -- fnd_file.put_line(fnd_file.log,'before end if');
3015:
3016:
3017:

Line 3014: -- fnd_file.put_line(fnd_file.log,'before end if');

3010: p_date_earned => l_date_earned,
3011: p_archive_flag => 'Y');
3012:
3013: -- fnd_file.put_line(fnd_file.log,'out ARCHIVE_OTH_BALANCE');
3014: -- fnd_file.put_line(fnd_file.log,'before end if');
3015:
3016:
3017:
3018: l_prev_prepay := rec_archive_ids.prepay_assact_id;

Line 3022: /fnd_file.put_line(fnd_file.log,'ARCHIVE_ACCRUAL_PLAN');/

3018: l_prev_prepay := rec_archive_ids.prepay_assact_id;
3019:
3020: END IF;
3021:
3022: /*fnd_file.put_line(fnd_file.log,'ARCHIVE_ACCRUAL_PLAN');*/
3023:
3024: /* ARCHIVE_ACCRUAL_PLAN (p_assignment_id => rec_archive_ids.run_assgt_id,
3025: p_date_earned => l_date_earned,
3026: p_effective_date => p_effective_date,

Line 3032: /fnd_file.put_line(fnd_file.log,'ARCHIVE_ADD_ELEMENT');/

3028: p_run_assignment_action_id => rec_archive_ids.run_assact_id,
3029: p_period_end_date => l_end_date,
3030: p_period_start_date => l_start_date);*/
3031:
3032: /*fnd_file.put_line(fnd_file.log,'ARCHIVE_ADD_ELEMENT');*/
3033:
3034: -- fnd_file.put_line(fnd_file.log,'in ARCHIVE_ADD_ELEMENT');
3035:
3036:

Line 3034: -- fnd_file.put_line(fnd_file.log,'in ARCHIVE_ADD_ELEMENT');

3030: p_period_start_date => l_start_date);*/
3031:
3032: /*fnd_file.put_line(fnd_file.log,'ARCHIVE_ADD_ELEMENT');*/
3033:
3034: -- fnd_file.put_line(fnd_file.log,'in ARCHIVE_ADD_ELEMENT');
3035:
3036:
3037: ARCHIVE_ADD_ELEMENT(p_archive_assact_id => p_assignment_action_id,
3038: p_assignment_action_id => rec_archive_ids.run_assact_id,

Line 3046: -- fnd_file.put_line(fnd_file.log,'out ARCHIVE_ADD_ELEMENT');

3042: p_effective_date => p_effective_date,
3043: p_pre_payact_id => rec_archive_ids.prepay_payact_id,
3044: p_archive_flag => 'Y');
3045:
3046: -- fnd_file.put_line(fnd_file.log,'out ARCHIVE_ADD_ELEMENT');
3047: -- fnd_file.put_line(fnd_file.log,'in ARCHIVE_MAIN_ELEMENTS');
3048:
3049: /*fnd_file.put_line(fnd_file.log,'Assact id: '|| p_assignment_action_id);*/
3050:

Line 3047: -- fnd_file.put_line(fnd_file.log,'in ARCHIVE_MAIN_ELEMENTS');

3043: p_pre_payact_id => rec_archive_ids.prepay_payact_id,
3044: p_archive_flag => 'Y');
3045:
3046: -- fnd_file.put_line(fnd_file.log,'out ARCHIVE_ADD_ELEMENT');
3047: -- fnd_file.put_line(fnd_file.log,'in ARCHIVE_MAIN_ELEMENTS');
3048:
3049: /*fnd_file.put_line(fnd_file.log,'Assact id: '|| p_assignment_action_id);*/
3050:
3051: ARCHIVE_MAIN_ELEMENTS (p_archive_assact_id => p_assignment_action_id,

Line 3049: /fnd_file.put_line(fnd_file.log,'Assact id: '|| p_assignment_action_id);/

3045:
3046: -- fnd_file.put_line(fnd_file.log,'out ARCHIVE_ADD_ELEMENT');
3047: -- fnd_file.put_line(fnd_file.log,'in ARCHIVE_MAIN_ELEMENTS');
3048:
3049: /*fnd_file.put_line(fnd_file.log,'Assact id: '|| p_assignment_action_id);*/
3050:
3051: ARCHIVE_MAIN_ELEMENTS (p_archive_assact_id => p_assignment_action_id,
3052: p_assignment_action_id => rec_archive_ids.run_assact_id,
3053: p_assignment_id => rec_archive_ids.run_assgt_id,

Line 3057: -- fnd_file.put_line(fnd_file.log,'out ARCHIVE_MAIN_ELEMENTS');

3053: p_assignment_id => rec_archive_ids.run_assgt_id,
3054: p_date_earned => l_date_earned,
3055: p_effective_date => p_effective_date ) ;
3056:
3057: -- fnd_file.put_line(fnd_file.log,'out ARCHIVE_MAIN_ELEMENTS');
3058:
3059:
3060:
3061: l_record_count := l_record_count + 1;

Line 3069: -- fnd_file.put_line(fnd_file.log,'Leaving Procedure ARCHIVE_CODE');

3065: IF g_debug THEN
3066: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',390);
3067: END IF;
3068:
3069: -- fnd_file.put_line(fnd_file.log,'Leaving Procedure ARCHIVE_CODE');
3070:
3071: END ARCHIVE_CODE;
3072:
3073:

Line 3253: -- fnd_file.put_line(fnd_file.log,'inside ARCHIVE_ADDL_EMP_DETAILS');

3249: -------------
3250:
3251: BEGIN
3252:
3253: -- fnd_file.put_line(fnd_file.log,'inside ARCHIVE_ADDL_EMP_DETAILS');
3254:
3255: OPEN CSR_ACTUAL_TERM_DATE (p_assignment_id);
3256: FETCH CSR_ACTUAL_TERM_DATE INTO l_actual_termination_date;
3257: CLOSE CSR_ACTUAL_TERM_DATE;

Line 3259: -- fnd_file.put_line(fnd_file.log,'closed CSR_ACTUAL_TERM_DATE');

3255: OPEN CSR_ACTUAL_TERM_DATE (p_assignment_id);
3256: FETCH CSR_ACTUAL_TERM_DATE INTO l_actual_termination_date;
3257: CLOSE CSR_ACTUAL_TERM_DATE;
3258:
3259: -- fnd_file.put_line(fnd_file.log,'closed CSR_ACTUAL_TERM_DATE');
3260:
3261: -- fnd_file.put_line(fnd_file.log,'before FOR g_tax_card_tab');
3262:
3263: FOR l_index IN g_tax_card_tab.first.. g_tax_card_tab.last LOOP

Line 3261: -- fnd_file.put_line(fnd_file.log,'before FOR g_tax_card_tab');

3257: CLOSE CSR_ACTUAL_TERM_DATE;
3258:
3259: -- fnd_file.put_line(fnd_file.log,'closed CSR_ACTUAL_TERM_DATE');
3260:
3261: -- fnd_file.put_line(fnd_file.log,'before FOR g_tax_card_tab');
3262:
3263: FOR l_index IN g_tax_card_tab.first.. g_tax_card_tab.last LOOP
3264:
3265: OPEN get_details( p_assignment_id ,g_tax_card_tab(l_index).inp_val_name );

Line 3273: -- fnd_file.put_line(fnd_file.log,'end loop FOR g_tax_card_tab');

3269: g_tax_card_tab(l_index).screen_entry_val := l_rec.screen_entry_value ;
3270:
3271: END LOOP;
3272:
3273: -- fnd_file.put_line(fnd_file.log,'end loop FOR g_tax_card_tab');
3274:
3275: l_tax_card_effective_date := l_rec.effective_start_date;
3276:
3277:

Line 3283: -- fnd_file.put_line(fnd_file.log,' l_tax_card_type = '||l_tax_card_type );

3279:
3280: -- get the tax card type
3281: l_tax_card_type := g_tax_card_tab(2).screen_entry_val ;
3282:
3283: -- fnd_file.put_line(fnd_file.log,' l_tax_card_type = '||l_tax_card_type );
3284:
3285: -- get the global value for tax percentage
3286:
3287: OPEN csr_global_value ('DK_NO_TAX_CARD_RATE') ;

Line 3291: -- fnd_file.put_line(fnd_file.log,'l_global_tax_percent = '||l_global_tax_percent );

3287: OPEN csr_global_value ('DK_NO_TAX_CARD_RATE') ;
3288: FETCH csr_global_value INTO l_global_tax_percent ;
3289: CLOSE csr_global_value ;
3290:
3291: -- fnd_file.put_line(fnd_file.log,'l_global_tax_percent = '||l_global_tax_percent );
3292:
3293: -- get the 'Use Tax Card' input vale from Tax element
3294:
3295: OPEN csr_tax_details (p_assignment_id, 'Use Tax Card') ;

Line 3301: -- fnd_file.put_line(fnd_file.log,'l_use_tax_card = '||l_use_tax_card );

3297: CLOSE csr_tax_details ;
3298:
3299: l_use_tax_card := l_tax_rec.screen_entry_value ;
3300:
3301: -- fnd_file.put_line(fnd_file.log,'l_use_tax_card = '||l_use_tax_card );
3302:
3303: -- For an employee with Tax Card type as 'No Tax Card'
3304: -- or
3305: -- For an employee with "Use tax card" as 'No' in the tax element

Line 3312: -- fnd_file.put_line(fnd_file.log,' Overriding l_tax_percent ');

3308: -- Hence even in the payslip the tax percentage should be displayed as DK_NO_TAX_CARD_RATE
3309:
3310: IF ( (l_tax_card_type = 'NTC') OR (l_use_tax_card = 'N') ) THEN
3311: l_tax_percent := l_global_tax_percent ;
3312: -- fnd_file.put_line(fnd_file.log,' Overriding l_tax_percent ');
3313: ELSE
3314: l_tax_percent := g_tax_card_tab(3).screen_entry_val ;
3315: -- fnd_file.put_line(fnd_file.log,' Tax Card l_tax_percent ');
3316: END IF;

Line 3315: -- fnd_file.put_line(fnd_file.log,' Tax Card l_tax_percent ');

3311: l_tax_percent := l_global_tax_percent ;
3312: -- fnd_file.put_line(fnd_file.log,' Overriding l_tax_percent ');
3313: ELSE
3314: l_tax_percent := g_tax_card_tab(3).screen_entry_val ;
3315: -- fnd_file.put_line(fnd_file.log,' Tax Card l_tax_percent ');
3316: END IF;
3317:
3318: -- fnd_file.put_line(fnd_file.log,' l_tax_percent = '|| l_tax_percent);
3319:

Line 3318: -- fnd_file.put_line(fnd_file.log,' l_tax_percent = '|| l_tax_percent);

3314: l_tax_percent := g_tax_card_tab(3).screen_entry_val ;
3315: -- fnd_file.put_line(fnd_file.log,' Tax Card l_tax_percent ');
3316: END IF;
3317:
3318: -- fnd_file.put_line(fnd_file.log,' l_tax_percent = '|| l_tax_percent);
3319:
3320: -- Bug Fix 5081696 : End
3321:
3322: ---------------------

Line 3324: -- fnd_file.put_line(fnd_file.log,'getting DK_TAX_CARD_TYPE');

3320: -- Bug Fix 5081696 : End
3321:
3322: ---------------------
3323:
3324: -- fnd_file.put_line(fnd_file.log,'getting DK_TAX_CARD_TYPE');
3325:
3326: -- Getting the display value for Tax Card type
3327: g_tax_card_tab(2).screen_entry_val := hr_general.decode_lookup('DK_TAX_CARD_TYPE',g_tax_card_tab(2).screen_entry_val);
3328:

Line 3329: -- fnd_file.put_line(fnd_file.log,'archiving ADDL EMPLOYEE DETAILS');

3325:
3326: -- Getting the display value for Tax Card type
3327: g_tax_card_tab(2).screen_entry_val := hr_general.decode_lookup('DK_TAX_CARD_TYPE',g_tax_card_tab(2).screen_entry_val);
3328:
3329: -- fnd_file.put_line(fnd_file.log,'archiving ADDL EMPLOYEE DETAILS');
3330:
3331: pay_action_information_api.create_action_information (
3332: p_action_information_id => l_action_info_id
3333: ,p_action_context_id => p_archive_assact_id

Line 3355: -- fnd_file.put_line(fnd_file.log,'finished archiving ADDL EMPLOYEE DETAILS');

3351: ,p_action_information13 => fnd_date.date_to_displaydate(fnd_date.canonical_to_date(g_tax_card_tab(10).screen_entry_val)) -- Date Returned
3352: --,p_action_information13 => g_tax_card_tab(10).screen_entry_val -- Date Returned
3353: ,p_assignment_id => p_assignment_id );
3354:
3355: -- fnd_file.put_line(fnd_file.log,'finished archiving ADDL EMPLOYEE DETAILS');
3356:
3357: -------------------------------------------------------------------------------
3358:
3359: -- fnd_file.put_line(fnd_file.log,'begin FOR g_bal_val');

Line 3359: -- fnd_file.put_line(fnd_file.log,'begin FOR g_bal_val');

3355: -- fnd_file.put_line(fnd_file.log,'finished archiving ADDL EMPLOYEE DETAILS');
3356:
3357: -------------------------------------------------------------------------------
3358:
3359: -- fnd_file.put_line(fnd_file.log,'begin FOR g_bal_val');
3360:
3361: -- fnd_file.put_line(fnd_file.log,'g_bal_val.first = '||to_char(g_bal_val.first));
3362: -- fnd_file.put_line(fnd_file.log,'g_bal_val.last = '||to_char(g_bal_val.last));
3363:

Line 3361: -- fnd_file.put_line(fnd_file.log,'g_bal_val.first = '||to_char(g_bal_val.first));

3357: -------------------------------------------------------------------------------
3358:
3359: -- fnd_file.put_line(fnd_file.log,'begin FOR g_bal_val');
3360:
3361: -- fnd_file.put_line(fnd_file.log,'g_bal_val.first = '||to_char(g_bal_val.first));
3362: -- fnd_file.put_line(fnd_file.log,'g_bal_val.last = '||to_char(g_bal_val.last));
3363:
3364:
3365: FOR l_index IN g_bal_val.first.. g_bal_val.last LOOP

Line 3362: -- fnd_file.put_line(fnd_file.log,'g_bal_val.last = '||to_char(g_bal_val.last));

3358:
3359: -- fnd_file.put_line(fnd_file.log,'begin FOR g_bal_val');
3360:
3361: -- fnd_file.put_line(fnd_file.log,'g_bal_val.first = '||to_char(g_bal_val.first));
3362: -- fnd_file.put_line(fnd_file.log,'g_bal_val.last = '||to_char(g_bal_val.last));
3363:
3364:
3365: FOR l_index IN g_bal_val.first.. g_bal_val.last LOOP
3366:

Line 3367: -- fnd_file.put_line(fnd_file.log,'l_index = '||to_char(l_index));

3363:
3364:
3365: FOR l_index IN g_bal_val.first.. g_bal_val.last LOOP
3366:
3367: -- fnd_file.put_line(fnd_file.log,'l_index = '||to_char(l_index));
3368:
3369: l_defined_balance_id := GET_DEFINED_BALANCE_ID( g_bal_val(l_index).bal_name );
3370:
3371: -- fnd_file.put_line(fnd_file.log,'l_defined_balance_id = '||to_char(l_defined_balance_id));

Line 3371: -- fnd_file.put_line(fnd_file.log,'l_defined_balance_id = '||to_char(l_defined_balance_id));

3367: -- fnd_file.put_line(fnd_file.log,'l_index = '||to_char(l_index));
3368:
3369: l_defined_balance_id := GET_DEFINED_BALANCE_ID( g_bal_val(l_index).bal_name );
3370:
3371: -- fnd_file.put_line(fnd_file.log,'l_defined_balance_id = '||to_char(l_defined_balance_id));
3372: -- fnd_file.put_line(fnd_file.log,'p_assignment_action_id = '||to_char(p_assignment_action_id));
3373:
3374: g_bal_val(l_index).bal_val := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
3375:

Line 3372: -- fnd_file.put_line(fnd_file.log,'p_assignment_action_id = '||to_char(p_assignment_action_id));

3368:
3369: l_defined_balance_id := GET_DEFINED_BALANCE_ID( g_bal_val(l_index).bal_name );
3370:
3371: -- fnd_file.put_line(fnd_file.log,'l_defined_balance_id = '||to_char(l_defined_balance_id));
3372: -- fnd_file.put_line(fnd_file.log,'p_assignment_action_id = '||to_char(p_assignment_action_id));
3373:
3374: g_bal_val(l_index).bal_val := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
3375:
3376: -- fnd_file.put_line(fnd_file.log,'g_bal_val(l_index).bal_val = '||to_char(g_bal_val(l_index).bal_val));

Line 3376: -- fnd_file.put_line(fnd_file.log,'g_bal_val(l_index).bal_val = '||to_char(g_bal_val(l_index).bal_val));

3372: -- fnd_file.put_line(fnd_file.log,'p_assignment_action_id = '||to_char(p_assignment_action_id));
3373:
3374: g_bal_val(l_index).bal_val := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
3375:
3376: -- fnd_file.put_line(fnd_file.log,'g_bal_val(l_index).bal_val = '||to_char(g_bal_val(l_index).bal_val));
3377:
3378: END LOOP;
3379:
3380: -- fnd_file.put_line(fnd_file.log,'end loop FOR g_bal_val');

Line 3380: -- fnd_file.put_line(fnd_file.log,'end loop FOR g_bal_val');

3376: -- fnd_file.put_line(fnd_file.log,'g_bal_val(l_index).bal_val = '||to_char(g_bal_val(l_index).bal_val));
3377:
3378: END LOOP;
3379:
3380: -- fnd_file.put_line(fnd_file.log,'end loop FOR g_bal_val');
3381: -- fnd_file.put_line(fnd_file.log,'start asigning balance values');
3382:
3383: /* For reference : DBIs used for various balances and reporting values
3384:

Line 3381: -- fnd_file.put_line(fnd_file.log,'start asigning balance values');

3377:
3378: END LOOP;
3379:
3380: -- fnd_file.put_line(fnd_file.log,'end loop FOR g_bal_val');
3381: -- fnd_file.put_line(fnd_file.log,'start asigning balance values');
3382:
3383: /* For reference : DBIs used for various balances and reporting values
3384:
3385: g_bal_val(1).bal_name := 'AMBABLE_PAY_ASG_YTD'; -- AMB able income ytd

Line 3539: -- fnd_file.put_line(fnd_file.log,' DK EMPLOYEE DETAILS : l_tax_percent = '|| l_tax_percent);

3535: /* 10006902 end */
3536:
3537: -- Tax percentage value already fetched above
3538: -- l_tax_percent := g_tax_card_tab(3).screen_entry_val ; -- from tax card
3539: -- fnd_file.put_line(fnd_file.log,' DK EMPLOYEE DETAILS : l_tax_percent = '|| l_tax_percent);
3540:
3541:
3542: -- fnd_file.put_line(fnd_file.log,'finish asigning balance values');
3543:

Line 3542: -- fnd_file.put_line(fnd_file.log,'finish asigning balance values');

3538: -- l_tax_percent := g_tax_card_tab(3).screen_entry_val ; -- from tax card
3539: -- fnd_file.put_line(fnd_file.log,' DK EMPLOYEE DETAILS : l_tax_percent = '|| l_tax_percent);
3540:
3541:
3542: -- fnd_file.put_line(fnd_file.log,'finish asigning balance values');
3543:
3544: OPEN csr_payroll (p_payroll_action_id) ;
3545: FETCH csr_payroll INTO l_payroll_id;
3546: CLOSE csr_payroll ;

Line 3548: -- fnd_file.put_line(fnd_file.log,'closed csr_payroll');

3544: OPEN csr_payroll (p_payroll_action_id) ;
3545: FETCH csr_payroll INTO l_payroll_id;
3546: CLOSE csr_payroll ;
3547:
3548: -- fnd_file.put_line(fnd_file.log,'closed csr_payroll');
3549:
3550: OPEN csr_payroll_details (l_payroll_id);
3551: FETCH csr_payroll_details INTO l_payroll_name , l_period_type ;
3552: CLOSE csr_payroll_details ;

Line 3554: -- fnd_file.put_line(fnd_file.log,'closed csr_payroll_details');

3550: OPEN csr_payroll_details (l_payroll_id);
3551: FETCH csr_payroll_details INTO l_payroll_name , l_period_type ;
3552: CLOSE csr_payroll_details ;
3553:
3554: -- fnd_file.put_line(fnd_file.log,'closed csr_payroll_details');
3555:
3556: SELECT decode (l_period_type
3557: ,'Calendar Month',g_tax_card_tab(5).screen_entry_val
3558: ,'Bi-Week',g_tax_card_tab(6).screen_entry_val

Line 3593: -- fnd_file.put_line(fnd_file.log,'after the select decode');

3589: INTO l_calc_holiday_pay_asg_ytd
3590: FROM dual ;
3591: */
3592:
3593: -- fnd_file.put_line(fnd_file.log,'after the select decode');
3594:
3595: -- fnd_file.put_line(fnd_file.log,'starting archiving DK EMPLOYEE DETAILS');
3596:
3597: pay_action_information_api.create_action_information (

Line 3595: -- fnd_file.put_line(fnd_file.log,'starting archiving DK EMPLOYEE DETAILS');

3591: */
3592:
3593: -- fnd_file.put_line(fnd_file.log,'after the select decode');
3594:
3595: -- fnd_file.put_line(fnd_file.log,'starting archiving DK EMPLOYEE DETAILS');
3596:
3597: pay_action_information_api.create_action_information (
3598: p_action_information_id => l_action_info_id
3599: ,p_action_context_id => p_archive_assact_id

Line 3632: -- fnd_file.put_line(fnd_file.log,'finished archiving DK EMPLOYEE DETAILS');

3628: ,p_action_information19 => l_tax_percent -- Tax Percent
3629: --,p_action_information21 => l_net_pay -- Net Pay
3630: ,p_assignment_id => p_assignment_id);
3631:
3632: -- fnd_file.put_line(fnd_file.log,'finished archiving DK EMPLOYEE DETAILS');
3633: -- fnd_file.put_line(fnd_file.log,'leaving ARCHIVE_ADDL_EMP_DETAILS');
3634:
3635:
3636: END ARCHIVE_ADDL_EMP_DETAILS;

Line 3633: -- fnd_file.put_line(fnd_file.log,'leaving ARCHIVE_ADDL_EMP_DETAILS');

3629: --,p_action_information21 => l_net_pay -- Net Pay
3630: ,p_assignment_id => p_assignment_id);
3631:
3632: -- fnd_file.put_line(fnd_file.log,'finished archiving DK EMPLOYEE DETAILS');
3633: -- fnd_file.put_line(fnd_file.log,'leaving ARCHIVE_ADDL_EMP_DETAILS');
3634:
3635:
3636: END ARCHIVE_ADDL_EMP_DETAILS;
3637:

Line 3997: /*fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In ARCHIVE_MAIN_ELEMENTS');

3993: -- End Fix to handle Multiple Element Entries
3994:
3995: EXCEPTION WHEN OTHERS THEN
3996: g_err_num := SQLCODE;
3997: /*fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In ARCHIVE_MAIN_ELEMENTS');
3998:
3999: IF g_debug THEN
4000: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In ARCHIVE_MAIN_ELEMENTS',330);
4001: END IF;

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

4122: -- segment 6 = > Y or N
4123: -- segment 7 = > Input ID UNIT
4124: -- segment 8 = > Input ID UNIT PRICE
4125: -- segment 9 = > Input ID Amount
4126: fnd_file.put_line(fnd_file.log,'p_assignment_action_id'||p_assignment_action_id);
4127: fnd_file.put_line(fnd_file.log,'csr_rec.rep_name'|| csr_rec.rep_name);
4128: fnd_file.put_line(fnd_file.log,'rec_group_by.ORG_INFORMATION3'|| rec_group_by.ORG_INFORMATION3);
4129: fnd_file.put_line(fnd_file.log,'rec_group_by.ORG_INFORMATION6'|| rec_group_by.ORG_INFORMATION6);
4130: fnd_file.put_line(fnd_file.log,'rec_group_by.ORG_INFORMATION7'|| rec_group_by.ORG_INFORMATION7);

Line 4127: fnd_file.put_line(fnd_file.log,'csr_rec.rep_name'|| csr_rec.rep_name);

4123: -- segment 7 = > Input ID UNIT
4124: -- segment 8 = > Input ID UNIT PRICE
4125: -- segment 9 = > Input ID Amount
4126: fnd_file.put_line(fnd_file.log,'p_assignment_action_id'||p_assignment_action_id);
4127: fnd_file.put_line(fnd_file.log,'csr_rec.rep_name'|| csr_rec.rep_name);
4128: fnd_file.put_line(fnd_file.log,'rec_group_by.ORG_INFORMATION3'|| rec_group_by.ORG_INFORMATION3);
4129: fnd_file.put_line(fnd_file.log,'rec_group_by.ORG_INFORMATION6'|| rec_group_by.ORG_INFORMATION6);
4130: fnd_file.put_line(fnd_file.log,'rec_group_by.ORG_INFORMATION7'|| rec_group_by.ORG_INFORMATION7);
4131: fnd_file.put_line(fnd_file.log,'rec_group_by.ORG_INFORMATION8'|| rec_group_by.ORG_INFORMATION8);

Line 4128: fnd_file.put_line(fnd_file.log,'rec_group_by.ORG_INFORMATION3'|| rec_group_by.ORG_INFORMATION3);

4124: -- segment 8 = > Input ID UNIT PRICE
4125: -- segment 9 = > Input ID Amount
4126: fnd_file.put_line(fnd_file.log,'p_assignment_action_id'||p_assignment_action_id);
4127: fnd_file.put_line(fnd_file.log,'csr_rec.rep_name'|| csr_rec.rep_name);
4128: fnd_file.put_line(fnd_file.log,'rec_group_by.ORG_INFORMATION3'|| rec_group_by.ORG_INFORMATION3);
4129: fnd_file.put_line(fnd_file.log,'rec_group_by.ORG_INFORMATION6'|| rec_group_by.ORG_INFORMATION6);
4130: fnd_file.put_line(fnd_file.log,'rec_group_by.ORG_INFORMATION7'|| rec_group_by.ORG_INFORMATION7);
4131: fnd_file.put_line(fnd_file.log,'rec_group_by.ORG_INFORMATION8'|| rec_group_by.ORG_INFORMATION8);
4132: fnd_file.put_line(fnd_file.log,'rec_group_by.ORG_INFORMATION9'|| rec_group_by.ORG_INFORMATION9);

Line 4129: fnd_file.put_line(fnd_file.log,'rec_group_by.ORG_INFORMATION6'|| rec_group_by.ORG_INFORMATION6);

4125: -- segment 9 = > Input ID Amount
4126: fnd_file.put_line(fnd_file.log,'p_assignment_action_id'||p_assignment_action_id);
4127: fnd_file.put_line(fnd_file.log,'csr_rec.rep_name'|| csr_rec.rep_name);
4128: fnd_file.put_line(fnd_file.log,'rec_group_by.ORG_INFORMATION3'|| rec_group_by.ORG_INFORMATION3);
4129: fnd_file.put_line(fnd_file.log,'rec_group_by.ORG_INFORMATION6'|| rec_group_by.ORG_INFORMATION6);
4130: fnd_file.put_line(fnd_file.log,'rec_group_by.ORG_INFORMATION7'|| rec_group_by.ORG_INFORMATION7);
4131: fnd_file.put_line(fnd_file.log,'rec_group_by.ORG_INFORMATION8'|| rec_group_by.ORG_INFORMATION8);
4132: fnd_file.put_line(fnd_file.log,'rec_group_by.ORG_INFORMATION9'|| rec_group_by.ORG_INFORMATION9);
4133:

Line 4130: fnd_file.put_line(fnd_file.log,'rec_group_by.ORG_INFORMATION7'|| rec_group_by.ORG_INFORMATION7);

4126: fnd_file.put_line(fnd_file.log,'p_assignment_action_id'||p_assignment_action_id);
4127: fnd_file.put_line(fnd_file.log,'csr_rec.rep_name'|| csr_rec.rep_name);
4128: fnd_file.put_line(fnd_file.log,'rec_group_by.ORG_INFORMATION3'|| rec_group_by.ORG_INFORMATION3);
4129: fnd_file.put_line(fnd_file.log,'rec_group_by.ORG_INFORMATION6'|| rec_group_by.ORG_INFORMATION6);
4130: fnd_file.put_line(fnd_file.log,'rec_group_by.ORG_INFORMATION7'|| rec_group_by.ORG_INFORMATION7);
4131: fnd_file.put_line(fnd_file.log,'rec_group_by.ORG_INFORMATION8'|| rec_group_by.ORG_INFORMATION8);
4132: fnd_file.put_line(fnd_file.log,'rec_group_by.ORG_INFORMATION9'|| rec_group_by.ORG_INFORMATION9);
4133:
4134: IF ( (rec_group_by.ORG_INFORMATION3 = 'O') or (rec_group_by.ORG_INFORMATION3 IS NULL) )

Line 4131: fnd_file.put_line(fnd_file.log,'rec_group_by.ORG_INFORMATION8'|| rec_group_by.ORG_INFORMATION8);

4127: fnd_file.put_line(fnd_file.log,'csr_rec.rep_name'|| csr_rec.rep_name);
4128: fnd_file.put_line(fnd_file.log,'rec_group_by.ORG_INFORMATION3'|| rec_group_by.ORG_INFORMATION3);
4129: fnd_file.put_line(fnd_file.log,'rec_group_by.ORG_INFORMATION6'|| rec_group_by.ORG_INFORMATION6);
4130: fnd_file.put_line(fnd_file.log,'rec_group_by.ORG_INFORMATION7'|| rec_group_by.ORG_INFORMATION7);
4131: fnd_file.put_line(fnd_file.log,'rec_group_by.ORG_INFORMATION8'|| rec_group_by.ORG_INFORMATION8);
4132: fnd_file.put_line(fnd_file.log,'rec_group_by.ORG_INFORMATION9'|| rec_group_by.ORG_INFORMATION9);
4133:
4134: IF ( (rec_group_by.ORG_INFORMATION3 = 'O') or (rec_group_by.ORG_INFORMATION3 IS NULL) )
4135: THEN

Line 4132: fnd_file.put_line(fnd_file.log,'rec_group_by.ORG_INFORMATION9'|| rec_group_by.ORG_INFORMATION9);

4128: fnd_file.put_line(fnd_file.log,'rec_group_by.ORG_INFORMATION3'|| rec_group_by.ORG_INFORMATION3);
4129: fnd_file.put_line(fnd_file.log,'rec_group_by.ORG_INFORMATION6'|| rec_group_by.ORG_INFORMATION6);
4130: fnd_file.put_line(fnd_file.log,'rec_group_by.ORG_INFORMATION7'|| rec_group_by.ORG_INFORMATION7);
4131: fnd_file.put_line(fnd_file.log,'rec_group_by.ORG_INFORMATION8'|| rec_group_by.ORG_INFORMATION8);
4132: fnd_file.put_line(fnd_file.log,'rec_group_by.ORG_INFORMATION9'|| rec_group_by.ORG_INFORMATION9);
4133:
4134: IF ( (rec_group_by.ORG_INFORMATION3 = 'O') or (rec_group_by.ORG_INFORMATION3 IS NULL) )
4135: THEN
4136: -- Case for Group by or NOT

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

4140: IF ( rec_group_by.ORG_INFORMATION6 = 'N' or (rec_group_by.ORG_INFORMATION3 IS NULL) )
4141: THEN
4142: -- This case is for individual representation of each element.
4143: -- unit and unit price should be absent.
4144: -- fnd_file.put_line(fnd_file.log,'p_assignment_action_id'||p_assignment_action_id);
4145:
4146: FOR csr_result_rec IN csr_result_value(csr_rec.input_value_id ,csr_rec.element_type_id ,p_assignment_action_id)
4147: LOOP
4148:

Line 4151: fnd_file.put_line(fnd_file.log,' 1 csr_result_rec.result_value '||csr_result_rec.result_value);

4147: LOOP
4148:
4149:
4150: IF csr_result_rec.result_value is not null THEN
4151: fnd_file.put_line(fnd_file.log,' 1 csr_result_rec.result_value '||csr_result_rec.result_value);
4152: pay_action_information_api.create_action_information (
4153: p_action_information_id => l_action_info_id
4154: ,p_action_context_id => p_archive_assact_id
4155: ,p_action_context_type => 'AAP'

Line 4169: fnd_file.put_line(fnd_file.log,' 1 csr_result_rec.result_value '||csr_result_rec.result_value);

4165: ,p_action_information8 => ''
4166: ,p_action_information9 => 'Earning Element:'
4167: ,p_action_information10 => csr_rec.processing_priority /* 9358829 */
4168: ,p_assignment_id => p_assignment_id);
4169: fnd_file.put_line(fnd_file.log,' 1 csr_result_rec.result_value '||csr_result_rec.result_value);
4170:
4171: END IF;
4172: END LOOP;
4173:

Line 4189: fnd_file.put_line(fnd_file.log,' 2 csr_result_rec.result_value '||csr_result_rec.result_value);

4185:
4186:
4187:
4188: IF csr_result_rec.result_value is not null THEN
4189: fnd_file.put_line(fnd_file.log,' 2 csr_result_rec.result_value '||csr_result_rec.result_value);
4190: pay_action_information_api.create_action_information (
4191: p_action_information_id => l_action_info_id
4192: ,p_action_context_id => p_archive_assact_id
4193: ,p_action_context_type => 'AAP'

Line 4207: fnd_file.put_line(fnd_file.log,' 2 csr_result_rec.result_value '||csr_result_rec.result_value);

4203: ,p_action_information8 => csr_result_rec.record_count
4204: ,p_action_information9 => 'Earning Element unit per price:'||csr_result_rec.UNIT_PRICE
4205: ,p_action_information10 => csr_rec.processing_priority /* 9358829 */
4206: ,p_assignment_id => p_assignment_id);
4207: fnd_file.put_line(fnd_file.log,' 2 csr_result_rec.result_value '||csr_result_rec.result_value);
4208:
4209: END IF;
4210: END LOOP;
4211: END IF;

Line 4234: fnd_file.put_line(fnd_file.log,' 3 csr_result_rec.AMOUNT '||csr_result_rec.AMOUNT);

4230: FOR csr_result_rec IN csr_all_sum_result_values(rec_group_by.ORG_INFORMATION7,rec_group_by.ORG_INFORMATION9,rec_group_by.ORG_INFORMATION8,csr_rec.element_type_id,p_assignment_action_id)
4231: LOOP
4232:
4233: IF csr_result_rec.AMOUNT is not null THEN
4234: fnd_file.put_line(fnd_file.log,' 3 csr_result_rec.AMOUNT '||csr_result_rec.AMOUNT);
4235: pay_action_information_api.create_action_information (
4236: p_action_information_id => l_action_info_id
4237: ,p_action_context_id => p_archive_assact_id
4238: ,p_action_context_type => 'AAP'

Line 4252: fnd_file.put_line(fnd_file.log,' 3 csr_result_rec.AMOUNT '||csr_result_rec.AMOUNT);

4248: ,p_action_information8 => fnd_number.number_to_canonical(csr_result_rec.UNIT) /* l_formatted_value 9316928 not removing canonical because select query does a canonical to number */
4249: ,p_action_information9 => 'Earning Element unit per price:'||csr_result_rec.UNIT_PRICE
4250: ,p_action_information10 => csr_rec.processing_priority /* 9358829 */
4251: ,p_assignment_id => p_assignment_id);
4252: fnd_file.put_line(fnd_file.log,' 3 csr_result_rec.AMOUNT '||csr_result_rec.AMOUNT);
4253:
4254: END IF;
4255: END LOOP;
4256: ELSE

Line 4261: fnd_file.put_line(fnd_file.log,' 4 csr_result_rec.AMOUNT '||csr_result_rec.AMOUNT);

4257: FOR csr_result_rec IN csr_all_result_values(rec_group_by.ORG_INFORMATION7,rec_group_by.ORG_INFORMATION9,rec_group_by.ORG_INFORMATION8,csr_rec.element_type_id,p_assignment_action_id )
4258: LOOP
4259:
4260: IF csr_result_rec.AMOUNT is not null THEN
4261: fnd_file.put_line(fnd_file.log,' 4 csr_result_rec.AMOUNT '||csr_result_rec.AMOUNT);
4262: pay_action_information_api.create_action_information (
4263: p_action_information_id => l_action_info_id
4264: ,p_action_context_id => p_archive_assact_id
4265: ,p_action_context_type => 'AAP'

Line 4279: fnd_file.put_line(fnd_file.log,' 4 csr_result_rec.AMOUNT '||csr_result_rec.AMOUNT);

4275: ,p_action_information8 => csr_result_rec.UNIT
4276: ,p_action_information9 => 'Earning Element unit per price:'||csr_result_rec.UNIT_PRICE
4277: ,p_action_information10 => csr_rec.processing_priority /* 9358829 */
4278: ,p_assignment_id => p_assignment_id);
4279: fnd_file.put_line(fnd_file.log,' 4 csr_result_rec.AMOUNT '||csr_result_rec.AMOUNT);
4280:
4281: END IF; -- end of csr_result_rec.AMOUNT is not null
4282: END LOOP;
4283:

Line 4331: fnd_file.put_line(fnd_file.log,' 5 l_amount '||l_amount);

4327:
4328: -- Resume again
4329:
4330: IF csr_result_rec.result_value is not null THEN
4331: fnd_file.put_line(fnd_file.log,' 5 l_amount '||l_amount);
4332: pay_action_information_api.create_action_information (
4333: p_action_information_id => l_action_info_id
4334: ,p_action_context_id => p_archive_assact_id
4335: ,p_action_context_type => 'AAP'

Line 4349: fnd_file.put_line(fnd_file.log,' 5 l_amount '||l_amount);

4345: ,p_action_information8 => l_unit
4346: ,p_action_information9 => 'Earning Element unit per price:'||l_unit_price
4347: ,p_action_information10 => csr_rec.processing_priority /* 9358829 */
4348: ,p_assignment_id => p_assignment_id);
4349: fnd_file.put_line(fnd_file.log,' 5 l_amount '||l_amount);
4350:
4351: END IF; -- end of csr_result_rec.result_value is not null
4352: END LOOP;
4353: END IF; -- end of rec_group_by.ORG_INFORMATION9 IS NOT NULL

Line 4361: fnd_file.put_line(fnd_file.log,'ORA_ERR: Earnings' || g_err_num || 'In ARCHIVE_MAIN_ELEMENTS');

4357: END IF; -- End of rec_group_by.ORG_INFORMATION3 = 'I'
4358:
4359: EXCEPTION WHEN OTHERS THEN
4360: g_err_num := SQLCODE;
4361: fnd_file.put_line(fnd_file.log,'ORA_ERR: Earnings' || g_err_num || 'In ARCHIVE_MAIN_ELEMENTS');
4362: IF g_debug THEN
4363: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In ARCHIVE_MAIN_ELEMENTS',330);
4364: END IF;
4365:

Line 4376: -- fnd_file.put_line(fnd_file.log,'Deduction Elements REP_NAME:'||csr_rec.rep_name);

4372: -- Archiving Deduction Elements
4373:
4374: FOR csr_rec IN csr_ded_element_info LOOP
4375:
4376: -- fnd_file.put_line(fnd_file.log,'Deduction Elements REP_NAME:'||csr_rec.rep_name);
4377:
4378: l_result_value := null;
4379: rec_group_by := NULL;
4380:

Line 4397: --fnd_file.put_line(fnd_file.log,'Vetri1 : ' || 'In ARCHIVE_MAIN_ELEMENTS'||rec_group_by.ORG_INFORMATION3);

4393: -- segment 6 = > Y or N
4394: -- segment 7 = > Input ID UNIT
4395: -- segment 8 = > Input ID UNIT PRICE
4396: -- segment 9 = > Input ID Amount
4397: --fnd_file.put_line(fnd_file.log,'Vetri1 : ' || 'In ARCHIVE_MAIN_ELEMENTS'||rec_group_by.ORG_INFORMATION3);
4398:
4399:
4400:
4401: IF ( (rec_group_by.ORG_INFORMATION3 = 'O') or (rec_group_by.ORG_INFORMATION3 IS NULL) )

Line 4420: -- fnd_file.put_line(fnd_file.log,'Deduction Elements P1:'||csr_rec.rep_name);

4416: /* Added for Pension changes -start */
4417:
4418: IF( csr_rec.rep_name IN ('Pension','Employer Pension','Retro Pension','Retro Employer Pension')) THEN
4419:
4420: -- fnd_file.put_line(fnd_file.log,'Deduction Elements P1:'||csr_rec.rep_name);
4421:
4422: -- rec_result_val := NULL;
4423: --OPEN csr_result_value(csr_rec.input_value_id ,csr_rec.element_type_id ,p_assignment_action_id);
4424: --FETCH csr_result_value INTO rec_result_val;

Line 4440: -- fnd_file.put_line(fnd_file.log,'rec_get_pp_name.name :'||rec_get_pp_name.name );

4436: OPEN csr_get_pp_name(p_effective_date , l_rr_id_pen);
4437: FETCH csr_get_pp_name INTO rec_get_pp_name;
4438: CLOSE csr_get_pp_name;
4439:
4440: -- fnd_file.put_line(fnd_file.log,'rec_get_pp_name.name :'||rec_get_pp_name.name );
4441:
4442:
4443: OPEN csr_get_ded_pen_dtl(p_effective_date ,csr_rec.element_type_id ,csr_rec.input_value_id);
4444: FETCH csr_get_ded_pen_dtl INTO l_action_info_id_pen;

Line 4456: -- fnd_file.put_line(fnd_file.log,'Deduction Elements :'||rec_get_pp_name.name);

4452: p_action_information_id => l_action_info_id_pen
4453: ,p_object_version_number => l_ovn_pen
4454: ,p_action_information4 => l_new_rep_name); */
4455:
4456: -- fnd_file.put_line(fnd_file.log,'Deduction Elements :'||rec_get_pp_name.name);
4457:
4458: l_ele_pen_context:='PP';
4459: l_ele_pen_context_desc:= rec_get_pp_name.name||':';
4460:

Line 4472: -- fnd_file.put_line(fnd_file.log,'D 1 : l_result_value '|| l_result_value );

4468: /* Added for Pension changes -end */
4469:
4470:
4471: IF l_result_value is not null THEN
4472: -- fnd_file.put_line(fnd_file.log,'D 1 : l_result_value '|| l_result_value );
4473:
4474: pay_action_information_api.create_action_information (
4475: p_action_information_id => l_action_info_id
4476: ,p_action_context_id => p_archive_assact_id

Line 4492: -- fnd_file.put_line(fnd_file.log,'D 1 : l_result_value '|| l_result_value );

4488: ,p_assignment_id => p_assignment_id
4489: ,p_action_information8 => ''
4490: ,p_action_information10 => csr_rec.processing_priority /* 9358829 */
4491: );
4492: -- fnd_file.put_line(fnd_file.log,'D 1 : l_result_value '|| l_result_value );
4493: END IF;
4494: END LOOP;
4495: ----------------------------------------------------------------------------------------------------------------------------------------------
4496: ELSIF rec_group_by.ORG_INFORMATION6 = 'Y'

Line 4543: -- fnd_file.put_line(fnd_file.log,'D 2 : l_result_value '|| l_result_value );

4539:
4540:
4541:
4542: IF l_result_value is not null THEN
4543: -- fnd_file.put_line(fnd_file.log,'D 2 : l_result_value '|| l_result_value );
4544: pay_action_information_api.create_action_information (
4545: p_action_information_id => l_action_info_id
4546: ,p_action_context_id => p_archive_assact_id
4547: ,p_action_context_type => 'AAP'

Line 4562: -- fnd_file.put_line(fnd_file.log,'D 2 : l_result_value '|| l_result_value );

4558: ,p_assignment_id => p_assignment_id
4559: ,p_action_information8 => csr_result_rec.record_count
4560: ,p_action_information10 => csr_rec.processing_priority /* 9358829 */
4561: );
4562: -- fnd_file.put_line(fnd_file.log,'D 2 : l_result_value '|| l_result_value );
4563: END IF;
4564: END LOOP;
4565: END IF;
4566: ELSIF rec_group_by.ORG_INFORMATION3 = 'I'

Line 4621: -- fnd_file.put_line(fnd_file.log,'D 3 : csr_result_rec.AMOUNT '|| csr_result_rec.AMOUNT );

4617:
4618:
4619:
4620: IF csr_result_rec.AMOUNT is not null THEN
4621: -- fnd_file.put_line(fnd_file.log,'D 3 : csr_result_rec.AMOUNT '|| csr_result_rec.AMOUNT );
4622: pay_action_information_api.create_action_information (
4623: p_action_information_id => l_action_info_id
4624: ,p_action_context_id => p_archive_assact_id
4625: ,p_action_context_type => 'AAP'

Line 4639: -- fnd_file.put_line(fnd_file.log,'D 3 : csr_result_rec.AMOUNT '|| csr_result_rec.AMOUNT );

4635: ,p_action_information8 => csr_result_rec.UNIT
4636: ,p_action_information9 => l_ele_pen_context_desc||':'||csr_result_rec.UNIT_PRICE
4637: ,p_action_information10 => csr_rec.processing_priority /* 9358829 */
4638: ,p_assignment_id => p_assignment_id);
4639: -- fnd_file.put_line(fnd_file.log,'D 3 : csr_result_rec.AMOUNT '|| csr_result_rec.AMOUNT );
4640:
4641:
4642: END IF;
4643: END LOOP;

Line 4682: -- fnd_file.put_line(fnd_file.log,'D 4 : csr_result_rec.AMOUNT '|| csr_result_rec.AMOUNT );

4678:
4679: /* End */
4680:
4681: IF csr_result_rec.AMOUNT is not null THEN
4682: -- fnd_file.put_line(fnd_file.log,'D 4 : csr_result_rec.AMOUNT '|| csr_result_rec.AMOUNT );
4683: pay_action_information_api.create_action_information (
4684: p_action_information_id => l_action_info_id
4685: ,p_action_context_id => p_archive_assact_id
4686: ,p_action_context_type => 'AAP'

Line 4700: -- fnd_file.put_line(fnd_file.log,'D 4 : csr_result_rec.AMOUNT '|| csr_result_rec.AMOUNT );

4696: ,p_action_information8 => csr_result_rec.UNIT
4697: ,p_action_information9 => l_ele_pen_context_desc||':'||csr_result_rec.UNIT_PRICE
4698: ,p_action_information10 => csr_rec.processing_priority /* 9358829 */
4699: ,p_assignment_id => p_assignment_id);
4700: -- fnd_file.put_line(fnd_file.log,'D 4 : csr_result_rec.AMOUNT '|| csr_result_rec.AMOUNT );
4701:
4702: END IF;
4703:
4704:

Line 4787: -- fnd_file.put_line(fnd_file.log,'D 5 : csr_result_rec.result_value '|| csr_result_rec.result_value );

4783: /* End */
4784:
4785:
4786: IF csr_result_rec.result_value is not null THEN
4787: -- fnd_file.put_line(fnd_file.log,'D 5 : csr_result_rec.result_value '|| csr_result_rec.result_value );
4788: pay_action_information_api.create_action_information (
4789: p_action_information_id => l_action_info_id
4790: ,p_action_context_id => p_archive_assact_id
4791: ,p_action_context_type => 'AAP'

Line 4805: -- fnd_file.put_line(fnd_file.log,'D 5 : csr_result_rec.result_value '|| csr_result_rec.result_value );

4801: ,p_action_information8 => l_unit
4802: ,p_action_information9 => l_ele_pen_context_desc||':'||l_unit_price
4803: ,p_action_information10 => csr_rec.processing_priority /* 9358829 */
4804: ,p_assignment_id => p_assignment_id);
4805: -- fnd_file.put_line(fnd_file.log,'D 5 : csr_result_rec.result_value '|| csr_result_rec.result_value );
4806:
4807: END IF; -- end of csr_result_rec.result_value is not null
4808: END LOOP;
4809: END IF; -- end of rec_group_by.ORG_INFORMATION9 IS NOT NULL

Line 4817: fnd_file.put_line(fnd_file.log,'ORA_ERR: Deductions' || g_err_num || 'In ARCHIVE_MAIN_ELEMENTS');

4813: /*******************************************End Changes*********************************************************************************/
4814:
4815: EXCEPTION WHEN OTHERS THEN
4816: g_err_num := SQLCODE;
4817: fnd_file.put_line(fnd_file.log,'ORA_ERR: Deductions' || g_err_num || 'In ARCHIVE_MAIN_ELEMENTS');
4818:
4819: IF g_debug THEN
4820: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In ARCHIVE_MAIN_ELEMENTS',330);
4821: END IF;