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.

[Home] [Help]

APPS.PAY_HK_IR56_ARCHIVE dependencies on HR_UTILITY

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

752: When Others Then
753: If ir56_Employee_info%ISOPEN Then
754: CLOSE ir56_Employee_info;
755: End If;
756: hr_utility.set_location('Archive_employee_details ,Exception others',20);
757: RAISE;
758: End Archive_Employee_details;
759:
760: ---------------------------------

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

859:
860:
861: Exception
862: When e_employer_notfound then
863: hr_utility.set_location('No employee Details found for the assigment id ',20);
864: When Others Then
865: If ir56_Employer_info%ISOPEN Then
866: CLOSE ir56_Employer_info;
867: End If;

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

864: When Others Then
865: If ir56_Employer_info%ISOPEN Then
866: CLOSE ir56_Employer_info;
867: End If;
868: hr_utility.set_location('Error in archive_employee_details ',99);
869: RAISE;
870: End Archive_Employer_details;
871:
872: ---------------------------------

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

940: END LOOP;
941:
942: Exception
943: When Others Then
944: hr_utility.set_location('Error in archive_balance_details ',99);
945: RAISE;
946: End Archive_Balance_details;
947:
948: ---------------------------------

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

1168: When Others Then
1169: If quarters_info%ISOPEN Then
1170: CLOSE quarters_info;
1171: End If;
1172: hr_utility.set_location('Error in archive_quarter_details ',99);
1173: RAISE;
1174: End Archive_Quarter_details;
1175:
1176:

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

1230: When Others Then
1231: If os_info%ISOPEN Then
1232: CLOSE os_info;
1233: End If;
1234: hr_utility.set_location('Error in archive_quarter_details ',99);
1235: RAISE;
1236: End Archive_Overseas_Details;
1237:
1238: Procedure Archive_Excep_Error_dtls(

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

1351: CLOSE ir56_Employer_info;
1352:
1353: Exception
1354: When e_employer_notfound then
1355: hr_utility.set_location('From Archive_excp:No employer Details found ',20);
1356: When e_employee_notfound then
1357: hr_utility.set_location('From Archive_excp:No employee Details found ',20);
1358: When Others Then
1359: If ir56_Employer_info%ISOPEN Then

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

1353: Exception
1354: When e_employer_notfound then
1355: hr_utility.set_location('From Archive_excp:No employer Details found ',20);
1356: When e_employee_notfound then
1357: hr_utility.set_location('From Archive_excp:No employee Details found ',20);
1358: When Others Then
1359: If ir56_Employer_info%ISOPEN Then
1360: CLOSE ir56_Employer_info;
1361: End If;

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

1361: End If;
1362: If ir56_Employee_info%ISOPEN Then
1363: CLOSE ir56_Employee_info;
1364: End If;
1365: hr_utility.set_location('Error in archive_employee_details ',99);
1366: RAISE;
1367: End Archive_Excep_Error_dtls;
1368:
1369:

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

1510:
1511: e_No_Assignment_Found Exception;
1512:
1513: Begin
1514: hr_utility.set_location('pyhkirar: Start of archive_code',10);
1515:
1516: OPEN archive_parameters (p_assignment_action_id);
1517: FETCH archive_parameters INTO v_person_id,
1518: v_assignment_id,

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

1520: v_legal_entity_id,
1521: v_reporting_year,
1522: v_archive_date;
1523: If archive_parameters%FOUND Then
1524: hr_utility.set_location('pyhkirar: Person Id: ' || to_char(v_person_id) ,100);
1525:
1526: --* set the global value for assignment_id
1527: g_assignment_id := v_assignment_id;
1528:

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

1541: End If;
1542:
1543: CLOSE archive_parameters;
1544:
1545: hr_utility.set_location('pyhkirar: End of archive_code',20);
1546: Exception
1547: When e_No_Assignment_Found Then
1548: hr_utility.set_location('Exception: ARCHIVE_CODE,:No assignment id for assignment action id '||
1549: p_assignment_action_id,20);

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

1544:
1545: hr_utility.set_location('pyhkirar: End of archive_code',20);
1546: Exception
1547: When e_No_Assignment_Found Then
1548: hr_utility.set_location('Exception: ARCHIVE_CODE,:No assignment id for assignment action id '||
1549: p_assignment_action_id,20);
1550: When Others Then
1551: If archive_parameters%ISOPEN Then
1552: CLOSE archive_parameters;

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

1550: When Others Then
1551: If archive_parameters%ISOPEN Then
1552: CLOSE archive_parameters;
1553: End If;
1554: hr_utility.set_location('Error in archive_code ',99);
1555: RAISE;
1556: End archive_code;
1557:
1558:

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

1576: FROM ff_user_entities
1577: WHERE user_entity_name = c_user_entity_name;
1578:
1579: Begin
1580: hr_utility.set_location('Start of archive_item',10);
1581:
1582: OPEN user_entity_id (p_user_entity_name);
1583: FETCH user_entity_id into v_user_entity_id;
1584: If user_entity_id%FOUND Then

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

1595: ,p_context_name1 => 'ASSIGNMENT_ACTION_ID' -- varchar2 in default
1596: ,p_context1 => p_assignment_action_id -- varchar2 in default
1597: ,p_some_warning => v_some_warning); -- boolean out
1598:
1599: hr_utility.set_location('End of archive_item',20);
1600: Else
1601: hr_utility.set_location('User entity not found :'||p_user_entity_name,20);
1602: End If;
1603: CLOSE user_entity_id;

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

1597: ,p_some_warning => v_some_warning); -- boolean out
1598:
1599: hr_utility.set_location('End of archive_item',20);
1600: Else
1601: hr_utility.set_location('User entity not found :'||p_user_entity_name,20);
1602: End If;
1603: CLOSE user_entity_id;
1604:
1605: Exception

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

1606: When Others Then
1607: If user_entity_id%ISOPEN Then
1608: CLOSE user_entity_id;
1609: End If;
1610: hr_utility.set_location('Error in archive_item ',99);
1611: RAISE;
1612: End archive_item;
1613:
1614: ------------------------------

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

1665: -- process. End the loop by the exception clause because we don't know
1666: -- what order the parameters will be in.
1667:
1668: -- Default the parameters in case they are not found.
1669: hr_utility.set_location('Submit report called',1);
1670:
1671: l_archive_action_id := 0;
1672:
1673: Begin

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

1683: end if;
1684: END LOOP;
1685: Exception
1686: When no_data_found then
1687: hr_utility.set_location('No data found',1);
1688: NULL;
1689: When value_error then
1690: hr_utility.set_location('Value error',1);
1691: NULL;

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

1686: When no_data_found then
1687: hr_utility.set_location('No data found',1);
1688: NULL;
1689: When value_error then
1690: hr_utility.set_location('Value error',1);
1691: NULL;
1692: End;
1693: -- Default the number of report copies to 0.
1694: l_number_of_copies := 0;/*Reverted fix for 2810178 */

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

1697: OPEN csr_get_print_options(l_archive_action_id);
1698: FETCH csr_get_print_options INTO rec_print_options;
1699: CLOSE csr_get_print_options;
1700:
1701: hr_utility.set_location('fnd_request.set_print_options',1);
1702:
1703: /*Reverted fix for 2810178 */
1704: l_print_return := fnd_request.set_print_options
1705: (printer => rec_print_options.printer,

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

1716:
1717: -- Need to supply the parameters with keywords because it's a postscript report
1718: -- and the option version=2.0b set in the SRS definition uses a keyword, hence
1719:
1720: hr_utility.set_location('fnd_request.submit_request',1);
1721:
1722: l_request_id := fnd_request.submit_request
1723: (application => 'PAY',
1724: program => l_report_short_name,

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

1727: argument3 => 'P_BUSINESS_GROUP_ID='||g_business_group_id);
1728:
1729: -- If an error submitting report then get message and put to log.
1730:
1731: hr_utility.set_location('l_request_id : '||l_request_id,1);
1732:
1733: If l_request_id = 0 Then
1734: RAISE e_submit_error;
1735: End If;