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.PQP_FTE_UTILITIES dependencies on HR_UTILITY

Line 312: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

308:
309: EXCEPTION
310: WHEN OTHERS THEN
311: clear_cache;
312: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
313: debug_others(l_proc_name,l_proc_step);
314: IF g_debug THEN
315: debug('Leaving: '||l_proc_name,-999);
316: END IF;

Line 362: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

358:
359: EXCEPTION
360: WHEN OTHERS THEN
361: clear_cache;
362: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
363: debug_others(l_proc_name,l_proc_step);
364: IF g_debug THEN
365: debug('Leaving: '||l_proc_name,-999);
366: END IF;

Line 444: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

440:
441: EXCEPTION
442: WHEN OTHERS THEN
443: clear_cache;
444: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
445: debug_others(l_proc_name,l_proc_step);
446: IF g_debug THEN
447: debug('Leaving: '||l_proc_name,-999);
448: END IF;

Line 578: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

574:
575: EXCEPTION
576: WHEN OTHERS THEN
577: clear_cache;
578: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
579: debug_others(l_proc_name,l_proc_step);
580: IF g_debug THEN
581: debug('Leaving: '||l_proc_name,-999);
582: END IF;

Line 687: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

683:
684: EXCEPTION
685: WHEN OTHERS THEN
686: clear_cache;
687: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
688: debug_others(l_proc_name,l_proc_step);
689: IF g_debug THEN
690: debug('Leaving: '||l_proc_name,-999);
691: END IF;

Line 784: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

780:
781: EXCEPTION
782: WHEN OTHERS THEN
783: clear_cache;
784: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
785: debug_others(l_proc_name,l_proc_step);
786: IF g_debug THEN
787: debug('Leaving: '||l_proc_name,-999);
788: END IF;

Line 850: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

846:
847: EXCEPTION
848: WHEN OTHERS THEN
849: clear_cache;
850: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
851: debug_others(l_proc_name,l_proc_step);
852: IF g_debug THEN
853: debug('Leaving: '||l_proc_name,-999);
854: END IF;

Line 1209: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

1205:
1206: EXCEPTION
1207: WHEN OTHERS THEN
1208: clear_cache;
1209: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
1210: debug_others(l_proc_name,l_proc_step);
1211: IF g_debug THEN
1212: debug('Leaving: '||l_proc_name,-999);
1213: END IF;

Line 1240: g_debug := hr_utility.debug_enabled;

1236:
1237: BEGIN -- get_fte_value
1238:
1239: IF NOT g_is_concurrent_program_run THEN
1240: g_debug := hr_utility.debug_enabled;
1241: END IF;
1242:
1243: IF g_debug THEN
1244: debug_enter(l_proc_name);

Line 1263: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

1259:
1260: EXCEPTION
1261: WHEN OTHERS THEN
1262: clear_cache;
1263: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
1264: debug_others(l_proc_name,l_proc_step);
1265: IF g_debug THEN
1266: debug('Leaving: '||l_proc_name,-999);
1267: END IF;

Line 1351: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

1347: EXCEPTION
1348: WHEN OTHERS THEN
1349: p_assignment_details := l_assignment_details; -- nocopy
1350: clear_cache;
1351: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
1352: debug_others(l_proc_name,l_proc_step);
1353: IF g_debug THEN
1354: debug('Leaving: '||l_proc_name,-999);
1355: END IF;

Line 1535: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

1531: EXCEPTION
1532: WHEN OTHERS THEN
1533: p_contract_details := l_contract_details; -- empty for nocopy
1534: clear_cache;
1535: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
1536: debug_others(l_proc_name,l_proc_step);
1537: IF g_debug THEN
1538: debug('Leaving: '||l_proc_name,-999);
1539: END IF;

Line 1647: hr_utility.trace(

1643: );
1644:
1645: IF g_debug THEN
1646: /* Corrected and added as a part of Bug#10239082 Starts
1647: hr_utility.trace(
1648: 'Updated, '||p_assignment_id||', '||
1649: fnd_date.date_to_displaydate(p_effective_date)||', '||
1650: l_FTE_value||', '||
1651: l_assignment_details.normal_hours||', '||

Line 1656: hr_utility.trace(

1652: -- l_assignment_details.contract_type||', '||
1653: l_contract_details.annual_hours||', '||
1654: l_contract_details.period_divisor
1655: ); */
1656: hr_utility.trace(
1657: 'Updated, '||p_assignment_id||', '||
1658: fnd_date.date_to_displaydate(p_effective_date, calendar_aware => FND_DATE.calendar_aware_alt)||', '||
1659: l_FTE_value||', '||
1660: l_assignment_details.normal_hours||', '||

Line 1685: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

1681:
1682: EXCEPTION
1683: WHEN OTHERS THEN
1684: clear_cache;
1685: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
1686: debug_others(l_proc_name,l_proc_step);
1687: IF g_debug THEN
1688: debug('Leaving: '||l_proc_name,-999);
1689: END IF;

Line 1801: g_debug := hr_utility.debug_enabled;

1797: BEGIN -- update_fte_for_assignment
1798:
1799:
1800: IF NOT g_is_concurrent_program_run THEN
1801: g_debug := hr_utility.debug_enabled;
1802: END IF;
1803:
1804: IF g_debug THEN
1805: debug_enter(l_proc_name);

Line 1970: hr_utility.set_location('In the Debug -4 This_change.effective_start_date:-'||this_change.effective_start_date,70);

1966: );
1967: ELSE
1968: BEGIN -- For bug 5531482
1969: IF g_debug THEN
1970: hr_utility.set_location('In the Debug -4 This_change.effective_start_date:-'||this_change.effective_start_date,70);
1971: hr_utility.set_location('In the Debug -5 l_last_change_date:-'||l_last_change_date,80);
1972: END IF;
1973: g_output_file_records(g_output_file_records.LAST) :=
1974: g_output_file_records(g_output_file_records.LAST-1);

Line 1971: hr_utility.set_location('In the Debug -5 l_last_change_date:-'||l_last_change_date,80);

1967: ELSE
1968: BEGIN -- For bug 5531482
1969: IF g_debug THEN
1970: hr_utility.set_location('In the Debug -4 This_change.effective_start_date:-'||this_change.effective_start_date,70);
1971: hr_utility.set_location('In the Debug -5 l_last_change_date:-'||l_last_change_date,80);
1972: END IF;
1973: g_output_file_records(g_output_file_records.LAST) :=
1974: g_output_file_records(g_output_file_records.LAST-1);
1975: g_output_file_records(g_output_file_records.LAST).change_in :=

Line 1983: hr_utility.set_location('In the Debug -6 VALUE_ERROR',90);

1979: g_output_file_records(g_output_file_records.LAST).message :=
1980: 'Processing was skipped as this change effective the same date as the previous record.';
1981: EXCEPTION
1982: when VALUE_ERROR then
1983: hr_utility.set_location('In the Debug -6 VALUE_ERROR',90);
1984: null;
1985: when others then
1986: hr_utility.set_location('In the Debug -7 OTHERS',100);
1987: hr_utility.set_location('In the Debug -8:'||sqlerrm,110);

Line 1986: hr_utility.set_location('In the Debug -7 OTHERS',100);

1982: when VALUE_ERROR then
1983: hr_utility.set_location('In the Debug -6 VALUE_ERROR',90);
1984: null;
1985: when others then
1986: hr_utility.set_location('In the Debug -7 OTHERS',100);
1987: hr_utility.set_location('In the Debug -8:'||sqlerrm,110);
1988: Raise;
1989: END; -- End For bug 5531482
1990: END IF;

Line 1987: hr_utility.set_location('In the Debug -8:'||sqlerrm,110);

1983: hr_utility.set_location('In the Debug -6 VALUE_ERROR',90);
1984: null;
1985: when others then
1986: hr_utility.set_location('In the Debug -7 OTHERS',100);
1987: hr_utility.set_location('In the Debug -8:'||sqlerrm,110);
1988: Raise;
1989: END; -- End For bug 5531482
1990: END IF;
1991: END LOOP; --FOR this_change IN csr_get_relevant_change_dates

Line 2005: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

2001:
2002: EXCEPTION
2003: WHEN OTHERS THEN
2004: clear_cache;
2005: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
2006: debug_others(l_proc_name,l_proc_step);
2007: IF g_debug THEN
2008: debug('Leaving: '||l_proc_name,-999);
2009: END IF;

Line 2121: g_debug := hr_utility.debug_enabled;

2117: BEGIN -- update_fte_for_assignment_set
2118:
2119: g_is_concurrent_program_run := TRUE;
2120:
2121: g_debug := hr_utility.debug_enabled;
2122:
2123: IF p_trace = 'Y' THEN
2124: g_debug := TRUE;
2125: END IF;

Line 2463: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

2459: WHEN OTHERS THEN
2460:
2461: clear_cache;
2462:
2463: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
2464: debug_others(l_proc_name,l_proc_step);
2465: IF g_debug THEN
2466: debug('Leaving: '||l_proc_name,-999);
2467: END IF;

Line 2541: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

2537:
2538: EXCEPTION
2539: WHEN OTHERS THEN
2540: clear_cache;
2541: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
2542: debug_others(l_proc_name,l_proc_step);
2543: IF g_debug THEN
2544: debug('Leaving: '||l_proc_name,-999);
2545: END IF;