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_HK_IR56_ARCHIVE dependencies on HR_UTILITY

Line 159: hr_utility.set_location('Start of range_code',1);

155: PROCEDURE range_code
156: (p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE,
157: p_sql OUT nocopy Varchar2) is
158: Begin
159: hr_utility.set_location('Start of range_code',1);
160: p_sql := 'SELECT distinct person_id ' ||
161: 'FROM per_people_f ppf, ' ||
162: 'pay_payroll_actions ppa ' ||
163: 'WHERE ppa.payroll_action_id = :payroll_action_id ' ||

Line 166: hr_utility.set_location('End of range_code',2);

162: 'pay_payroll_actions ppa ' ||
163: 'WHERE ppa.payroll_action_id = :payroll_action_id ' ||
164: 'AND ppa.business_group_id = ppf.business_group_id ' ||
165: 'ORDER BY ppf.person_id';
166: hr_utility.set_location('End of range_code',2);
167: End range_code;
168:
169: ------------------------------------------------------------------------
170: -- This is used by legislation groups to set global contexts that are

Line 179: hr_utility.set_location('pyhkirar: Start of initialization_code',6);

175: ------------------------------------------------------------------------
176: PROCEDURE initialization_code
177: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE) is
178: Begin
179: hr_utility.set_location('pyhkirar: Start of initialization_code',6);
180: g_payroll_action_id := p_payroll_action_id;
181: hr_utility.set_location('pyhkirar: End of initialization_code',7);
182:
183: End initialization_code;

Line 181: hr_utility.set_location('pyhkirar: End of initialization_code',7);

177: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE) is
178: Begin
179: hr_utility.set_location('pyhkirar: Start of initialization_code',6);
180: g_payroll_action_id := p_payroll_action_id;
181: hr_utility.set_location('pyhkirar: End of initialization_code',7);
182:
183: End initialization_code;
184:
185: ------------------------------------------------------------------------

Line 321: hr_utility.set_location('Start of assignment_action_code '||

317: )
318: ;
319:
320: Begin
321: hr_utility.set_location('Start of assignment_action_code '||
322: p_payroll_action_id || ':' || p_start_person_id || ':' || p_end_person_id,3);
323:
324: /* Bug No : 2740270 - Fetching values from the cursor get_params */
325: OPEN get_params(p_payroll_action_id);

Line 365: hr_utility.set_location('Before calling hr_nonrun_asact.insact',4);

361: OPEN next_action_id;
362: FETCH next_action_id INTO v_next_action_id;
363: CLOSE next_action_id;
364:
365: hr_utility.set_location('Before calling hr_nonrun_asact.insact',4);
366: hr_nonrun_asact.insact(v_next_action_id,
367: asglist(i),
368: p_payroll_action_id,
369: p_chunk,

Line 371: hr_utility.set_location('After calling hr_nonrun_asact.insact',4);

367: asglist(i),
368: p_payroll_action_id,
369: p_chunk,
370: null);
371: hr_utility.set_location('After calling hr_nonrun_asact.insact',4);
372: END IF;
373: END IF;
374: END LOOP;
375:

Line 381: hr_utility.set_location('Exception in assignment_action_code ',20);

377: WHEN OTHERS THEN
378: IF next_action_id%ISOPEN THEN
379: CLOSE next_action_id;
380: END IF;
381: hr_utility.set_location('Exception in assignment_action_code ',20);
382: RAISE;
383: End assignment_action_code;
384:
385:

Line 824: hr_utility.set_location('Archive_employee_details ,Exception others',20);

820: When Others Then
821: If ir56_Employee_info%ISOPEN Then
822: CLOSE ir56_Employee_info;
823: End If;
824: hr_utility.set_location('Archive_employee_details ,Exception others',20);
825: RAISE;
826: End Archive_Employee_details;
827:
828: ---------------------------------

Line 932: hr_utility.set_location('No employee Details found for the assigment id ',20);

928:
929:
930: Exception
931: When e_employer_notfound then
932: hr_utility.set_location('No employee Details found for the assigment id ',20);
933: When Others Then
934: If ir56_Employer_info%ISOPEN Then
935: CLOSE ir56_Employer_info;
936: End If;

Line 937: hr_utility.set_location('Error in archive_employee_details ',99);

933: When Others Then
934: If ir56_Employer_info%ISOPEN Then
935: CLOSE ir56_Employer_info;
936: End If;
937: hr_utility.set_location('Error in archive_employee_details ',99);
938: RAISE;
939: End Archive_Employer_details;
940:
941: ---------------------------------

Line 1013: hr_utility.set_location('Error in archive_balance_details ',99);

1009: END LOOP;
1010:
1011: Exception
1012: When Others Then
1013: hr_utility.set_location('Error in archive_balance_details ',99);
1014: RAISE;
1015: End Archive_Balance_details;
1016:
1017: ---------------------------------

Line 1241: hr_utility.set_location('Error in archive_quarter_details ',99);

1237: When Others Then
1238: If quarters_info%ISOPEN Then
1239: CLOSE quarters_info;
1240: End If;
1241: hr_utility.set_location('Error in archive_quarter_details ',99);
1242: RAISE;
1243: End Archive_Quarter_details;
1244:
1245:

Line 1303: hr_utility.set_location('Error in archive_quarter_details ',99);

1299: When Others Then
1300: If os_info%ISOPEN Then
1301: CLOSE os_info;
1302: End If;
1303: hr_utility.set_location('Error in archive_quarter_details ',99);
1304: RAISE;
1305: End Archive_Overseas_Details;
1306:
1307: Procedure Archive_Excep_Error_dtls(

Line 1424: hr_utility.set_location('From Archive_excp:No employer Details found ',20);

1420: CLOSE ir56_Employer_info;
1421:
1422: Exception
1423: When e_employer_notfound then
1424: hr_utility.set_location('From Archive_excp:No employer Details found ',20);
1425: When e_employee_notfound then
1426: hr_utility.set_location('From Archive_excp:No employee Details found ',20);
1427: When Others Then
1428: If ir56_Employer_info%ISOPEN Then

Line 1426: hr_utility.set_location('From Archive_excp:No employee Details found ',20);

1422: Exception
1423: When e_employer_notfound then
1424: hr_utility.set_location('From Archive_excp:No employer Details found ',20);
1425: When e_employee_notfound then
1426: hr_utility.set_location('From Archive_excp:No employee Details found ',20);
1427: When Others Then
1428: If ir56_Employer_info%ISOPEN Then
1429: CLOSE ir56_Employer_info;
1430: End If;

Line 1434: hr_utility.set_location('Error in archive_employee_details ',99);

1430: End If;
1431: If ir56_Employee_info%ISOPEN Then
1432: CLOSE ir56_Employee_info;
1433: End If;
1434: hr_utility.set_location('Error in archive_employee_details ',99);
1435: RAISE;
1436: End Archive_Excep_Error_dtls;
1437:
1438:

Line 1583: hr_utility.set_location('pyhkirar: Start of archive_code',10);

1579:
1580: e_No_Assignment_Found Exception;
1581:
1582: Begin
1583: hr_utility.set_location('pyhkirar: Start of archive_code',10);
1584:
1585: OPEN archive_parameters (p_assignment_action_id);
1586: FETCH archive_parameters INTO v_person_id,
1587: v_assignment_id,

Line 1593: hr_utility.set_location('pyhkirar: Person Id: ' || to_char(v_person_id) ,100);

1589: v_legal_entity_id,
1590: v_reporting_year,
1591: v_archive_date;
1592: If archive_parameters%FOUND Then
1593: hr_utility.set_location('pyhkirar: Person Id: ' || to_char(v_person_id) ,100);
1594:
1595: --* set the global value for assignment_id
1596: g_assignment_id := v_assignment_id;
1597:

Line 1614: hr_utility.set_location('pyhkirar: End of archive_code',20);

1610: End If;
1611:
1612: CLOSE archive_parameters;
1613:
1614: hr_utility.set_location('pyhkirar: End of archive_code',20);
1615: Exception
1616: When e_No_Assignment_Found Then
1617: hr_utility.set_location('Exception: ARCHIVE_CODE,:No assignment id for assignment action id '||
1618: p_assignment_action_id,20);

Line 1617: hr_utility.set_location('Exception: ARCHIVE_CODE,:No assignment id for assignment action id '||

1613:
1614: hr_utility.set_location('pyhkirar: End of archive_code',20);
1615: Exception
1616: When e_No_Assignment_Found Then
1617: hr_utility.set_location('Exception: ARCHIVE_CODE,:No assignment id for assignment action id '||
1618: p_assignment_action_id,20);
1619: When Others Then
1620: If archive_parameters%ISOPEN Then
1621: CLOSE archive_parameters;

Line 1623: hr_utility.set_location('Error in archive_code ',99);

1619: When Others Then
1620: If archive_parameters%ISOPEN Then
1621: CLOSE archive_parameters;
1622: End If;
1623: hr_utility.set_location('Error in archive_code ',99);
1624: RAISE;
1625: End archive_code;
1626:
1627:

Line 1649: hr_utility.set_location('Start of archive_item',10);

1645: FROM ff_user_entities
1646: WHERE user_entity_name = c_user_entity_name;
1647:
1648: Begin
1649: hr_utility.set_location('Start of archive_item',10);
1650:
1651: OPEN user_entity_id (p_user_entity_name);
1652: FETCH user_entity_id into v_user_entity_id;
1653: If user_entity_id%FOUND Then

Line 1668: hr_utility.set_location('End of archive_item',20);

1664: ,p_context_name1 => 'ASSIGNMENT_ACTION_ID' -- varchar2 in default
1665: ,p_context1 => p_assignment_action_id -- varchar2 in default
1666: ,p_some_warning => v_some_warning); -- boolean out
1667:
1668: hr_utility.set_location('End of archive_item',20);
1669: Else
1670: hr_utility.set_location('User entity not found :'||p_user_entity_name,20);
1671: End If;
1672: CLOSE user_entity_id;

Line 1670: hr_utility.set_location('User entity not found :'||p_user_entity_name,20);

1666: ,p_some_warning => v_some_warning); -- boolean out
1667:
1668: hr_utility.set_location('End of archive_item',20);
1669: Else
1670: hr_utility.set_location('User entity not found :'||p_user_entity_name,20);
1671: End If;
1672: CLOSE user_entity_id;
1673:
1674: Exception

Line 1679: hr_utility.set_location('Error in archive_item ',99);

1675: When Others Then
1676: If user_entity_id%ISOPEN Then
1677: CLOSE user_entity_id;
1678: End If;
1679: hr_utility.set_location('Error in archive_item ',99);
1680: RAISE;
1681: End archive_item;
1682:
1683: ------------------------------

Line 1738: hr_utility.set_location('Submit report called',1);

1734: -- process. End the loop by the exception clause because we don't know
1735: -- what order the parameters will be in.
1736:
1737: -- Default the parameters in case they are not found.
1738: hr_utility.set_location('Submit report called',1);
1739:
1740: l_archive_action_id := 0;
1741:
1742: Begin

Line 1756: hr_utility.set_location('No data found',1);

1752: end if;
1753: END LOOP;
1754: Exception
1755: When no_data_found then
1756: hr_utility.set_location('No data found',1);
1757: NULL;
1758: When value_error then
1759: hr_utility.set_location('Value error',1);
1760: NULL;

Line 1759: hr_utility.set_location('Value error',1);

1755: When no_data_found then
1756: hr_utility.set_location('No data found',1);
1757: NULL;
1758: When value_error then
1759: hr_utility.set_location('Value error',1);
1760: NULL;
1761: End;
1762: -- Default the number of report copies to 0.
1763: l_number_of_copies := 0;/*Reverted fix for 2810178 */

Line 1770: hr_utility.set_location('fnd_request.set_print_options',1);

1766: OPEN csr_get_print_options(l_archive_action_id);
1767: FETCH csr_get_print_options INTO rec_print_options;
1768: CLOSE csr_get_print_options;
1769:
1770: hr_utility.set_location('fnd_request.set_print_options',1);
1771:
1772: /*Reverted fix for 2810178 */
1773: l_print_return := fnd_request.set_print_options
1774: (printer => rec_print_options.printer,

Line 1789: hr_utility.set_location('fnd_request.submit_request',1);

1785:
1786: -- Need to supply the parameters with keywords because it's a postscript report
1787: -- and the option version=2.0b set in the SRS definition uses a keyword, hence
1788:
1789: hr_utility.set_location('fnd_request.submit_request',1);
1790:
1791: l_request_id := fnd_request.submit_request
1792: (application => 'PAY',
1793: program => l_report_short_name,

Line 1800: hr_utility.set_location('l_request_id : '||l_request_id,1);

1796: argument3 => 'P_BUSINESS_GROUP_ID='||g_business_group_id);
1797:
1798: -- If an error submitting report then get message and put to log.
1799:
1800: hr_utility.set_location('l_request_id : '||l_request_id,1);
1801:
1802: If l_request_id = 0 Then
1803: RAISE e_submit_error;
1804: End If;