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

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

647: IF g_debug THEN
648: hr_utility.set_location(' Entering Procedure INITIALIZATION_CODE',80);
649: END IF;
650:
651: /*fnd_file.put_line(fnd_file.log,'In INIT_CODE 0');*/
652:
653: GET_ALL_PARAMETERS(p_payroll_action_id
654: ,l_business_group_id
655: ,l_start_date

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

1011:
1012: IF g_debug THEN
1013: hr_utility.set_location(' Entering Procedure ARCHIVE_EMPLOYEE_DETAILS',160);
1014: END IF;
1015: /*fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS');*/
1016:
1017: /* PERSON AND ADDRESS DETAILS */
1018: OPEN csr_person_details(p_assignment_id);
1019: FETCH csr_person_details INTO rec_person_details;

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

1030: OPEN csr_organization_address(rec_person_details.org_id);
1031: FETCH csr_organization_address INTO rec_org_address;
1032: CLOSE csr_organization_address;
1033:
1034: /*fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 2');*/
1035:
1036: /* GRADE AND POSITION */
1037: IF(rec_person_details.pos_id IS NOT NULL) THEN
1038: OPEN csr_position(rec_person_details.pos_id);

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

1053: FETCH csr_job INTO l_job;
1054: CLOSE csr_job;
1055: END IF;
1056:
1057: /*fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 3');*/
1058: /* CURRENCY */
1059: OPEN csr_bus_grp_id(rec_person_details.org_id);
1060: FETCH csr_bus_grp_id INTO l_bg_id;
1061: CLOSE csr_bus_grp_id;

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

1068:
1069: /*NATIONALITY*/
1070: l_nationality := hr_general.decode_lookup('NATIONALITY',rec_person_details.nationality);
1071:
1072: /*fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 4');*/
1073:
1074: l_org_struct_ver_id := NULL;
1075: OPEN csr_org_structure(l_bg_id);
1076: FETCH csr_org_structure INTO l_org_struct_ver_id;

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

1105: WHERE organization_id = rec_employer_address.org_id;
1106: ELSE l_employer_name := NULL;
1107: END IF;
1108:
1109: /*fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 5');*/
1110:
1111: /* COUNTRY */
1112: l_country:=PAY_KW_ARCHIVE.get_country_name(rec_primary_address.country);
1113:

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

1152: ,p_action_information30 => l_pay_location
1153: ,p_assignment_id => p_assignment_id);
1154:
1155:
1156: /*fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 7');*/
1157: /* ADDITIONAL EMPLOYEE DETAILS */
1158: pay_action_information_api.create_action_information (
1159: p_action_information_id => l_action_info_id
1160: ,p_action_context_id => p_archive_assact_id

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

1176: ,p_action_information13 => l_formatted_value -- for payroll register
1177: ,p_action_information14 => l_employer_name
1178: ,p_assignment_id => p_assignment_id);
1179:
1180: /*fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 8');*/
1181:
1182: /* INSERT ADDRESS DETAILS */
1183: IF rec_primary_address.AL1 IS NOT NULL THEN /* CHECK IF EMPLOYEE HAS BEEN GIVEN A PRIMARY ADDRESS */
1184: pay_action_information_api.create_action_information (

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

1226: ,p_action_information14 => 'Employee Address'
1227: ,p_assignment_id => p_assignment_id);
1228: END IF;
1229:
1230: /*fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 9');*/
1231: /* INSERT EMPLOYER'S ADDRESS (ORGANIZATION ADDRESS)*/
1232:
1233:
1234: BEGIN

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

1270:
1271:
1272:
1273:
1274: /*fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 10');*/
1275: --
1276:
1277: IF g_debug THEN
1278: hr_utility.set_location(' Leaving Procedure ARCHIVE_EMPLOYEE_DETAILS',170);

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

1280: --
1281: EXCEPTION WHEN OTHERS THEN
1282: g_err_num := SQLCODE;
1283:
1284: /*fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In ARCHIVE_EMPLOYEE_DETAILS');*/
1285: IF g_debug THEN
1286: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In ARCHIVE_EMPLOYEE_DETAILS',180);
1287: END IF;
1288:

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

1440:
1441: EXCEPTION WHEN OTHERS THEN
1442: g_err_num := SQLCODE;
1443:
1444: /*fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In ARCHIVE_ELEMENT_INFO');*/
1445: IF g_debug THEN
1446: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'ARCHIVE_ELEMENT_INFO',230);
1447: END IF;
1448:

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

1583:
1584: IF g_debug THEN
1585: hr_utility.set_location(' Entering Procedure ARCHIVE_PAYMENT_INFO',260);
1586: END IF;
1587: fnd_file.put_line(fnd_file.log,'In ARCHIVE_PAYMENT_INFO 1');
1588:
1589:
1590: OPEN csr_chk(p_prepay_assact_id);
1591: LOOP

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

1608:
1609: l_pay_value := to_char (rec_pers_pay.value,g_format_mask);
1610:
1611: IF (l_ext_acct IS NOT NULL) THEN
1612: /*fnd_file.put_line(fnd_file.log,'In ARCHIVE_PAYMENT_INFO 2');*/
1613:
1614: l_bank_name := hr_general.decode_lookup('KW_BANKS',rec_pers_pay.name_id);
1615:
1616: pay_action_information_api.create_action_information (

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

1641: ,p_assignment_id => p_assignment_id);
1642:
1643: ELSE
1644:
1645: /*fnd_file.put_line(fnd_file.log,'In ARCHIVE_PAYMENT_INFO 3');*/
1646: pay_action_information_api.create_action_information (
1647: p_action_information_id => l_action_info_id
1648: ,p_action_context_id => p_archive_assact_id
1649: ,p_action_context_type => 'AAP'

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

1672:
1673: END IF;
1674:
1675: END LOOP;
1676: /*fnd_file.put_line(fnd_file.log,'In ARCHIVE_PAYMENT_INFO 4');*/
1677:
1678:
1679: END IF;
1680:

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

1679: END IF;
1680:
1681: IF (rec_chk.opm_id IS NOT NULL AND rec_chk.ppm_id IS NULL) THEN
1682:
1683: /*fnd_file.put_line(fnd_file.log,'In ARCHIVE_PAYMENT_INFO 5');*/
1684:
1685: FOR rec_org_pay IN csr_get_org_pay(p_prepay_assact_id,rec_chk.opm_id) LOOP
1686:
1687: l_pay_value := to_char (rec_org_pay.value,g_format_mask);

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

1724: END IF;
1725:
1726: EXCEPTION WHEN OTHERS THEN
1727: g_err_num := SQLCODE;
1728: /*fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In ARCHIVE_PAYMENT_INFO');*/
1729: IF g_debug THEN
1730: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In ARCHIVE_PAYMENT_INFO',280);
1731: END IF;
1732:

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

1880:
1881:
1882: EXCEPTION WHEN OTHERS THEN
1883: g_err_num := SQLCODE;
1884: /*fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In ARCHIVE_ADD_ELEMENT');*/
1885: IF g_debug THEN
1886: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In ARCHIVE_ADD_ELEMENT',330);
1887: END IF;
1888:

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

2033:
2034: EXCEPTION WHEN OTHERS THEN
2035: g_err_num := SQLCODE;
2036:
2037: /*fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In ARCHIVE_OTH_BALANCE'||SQLERRM);*/
2038: IF g_debug THEN
2039: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In ARCHIVE_OTH_BALANCE',360);
2040: END IF;
2041:

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

2139: OPEN csr_period_end_date(rec_archive_ids.prepay_assact_id,rec_archive_ids.prepay_payact_id);
2140: 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;
2141: CLOSE csr_period_end_date;
2142:
2143: /*fnd_file.put_line(fnd_file.log,'ARCHIVE_EMPLOYEE_DETAILS');*/
2144:
2145: -------------------------------------------------------------
2146: --Archive EMPLOYEE_DETAILS, PAYMENT_INFO and BALANCES
2147: --for every prepayment assignment action id

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

2158: ,p_pay_date_earned => l_date_earned
2159: ,p_effective_date => p_effective_date);
2160:
2161:
2162: /*fnd_file.put_line(fnd_file.log,'ARCHIVE_PAYMENT_INFO');*/
2163: ARCHIVE_PAYMENT_INFO(p_archive_assact_id => p_assignment_action_id,
2164: p_prepay_assact_id => rec_archive_ids.prepay_assact_id,
2165: p_assignment_id => rec_archive_ids.prepay_assgt_id,
2166: p_date_earned => l_date_earned, --l_pre_date_earned,

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

2165: p_assignment_id => rec_archive_ids.prepay_assgt_id,
2166: p_date_earned => l_date_earned, --l_pre_date_earned,
2167: p_effective_date => p_effective_date);
2168:
2169: /*fnd_file.put_line(fnd_file.log,'ARCHIVE_OTH_BALANCE');*/
2170: ARCHIVE_OTH_BALANCE(p_archive_assact_id => p_assignment_action_id,
2171: p_assignment_action_id => rec_archive_ids.run_assact_id,
2172: p_assignment_id => rec_archive_ids.run_assgt_id,
2173: p_payroll_action_id => l_archive_payact_id,

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

2180: l_prev_prepay := rec_archive_ids.prepay_assact_id;
2181:
2182: END IF;
2183:
2184: /*fnd_file.put_line(fnd_file.log,'ARCHIVE_ADD_ELEMENT');*/
2185: ARCHIVE_ADD_ELEMENT(p_archive_assact_id => p_assignment_action_id,
2186: p_assignment_action_id => rec_archive_ids.run_assact_id,
2187: p_assignment_id => rec_archive_ids.run_assgt_id,
2188: p_payroll_action_id => l_archive_payact_id,

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

2192: p_archive_flag => 'Y');
2193:
2194:
2195:
2196: /*fnd_file.put_line(fnd_file.log,'Assact id: '|| p_assignment_action_id);*/
2197:
2198: l_record_count := l_record_count + 1;
2199: END LOOP;
2200:

APPS.PAY_KW_ARCHIVE dependencies on FND_FILE

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

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

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

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

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

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

Line 1156: /*fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 7');*/

Line 1180: /*fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 8');*/

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

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

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

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

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

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

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

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

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

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

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

Line 2037: /*fnd_file.put_line(fnd_file.log,'ORA_ERR: ' || g_err_num || 'In ARCHIVE_OTH_BALANCE'||SQLERRM);*/

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

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

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

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

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