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

Line 295: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

291:
292: EXCEPTION
293: WHEN OTHERS THEN
294: clear_cache;
295: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
296: debug_others(l_proc_name,l_proc_step);
297: IF g_debug THEN
298: debug('Leaving: '||l_proc_name,-999);
299: END IF;

Line 345: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

341:
342: EXCEPTION
343: WHEN OTHERS THEN
344: clear_cache;
345: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
346: debug_others(l_proc_name,l_proc_step);
347: IF g_debug THEN
348: debug('Leaving: '||l_proc_name,-999);
349: END IF;

Line 427: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

423:
424: EXCEPTION
425: WHEN OTHERS THEN
426: clear_cache;
427: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
428: debug_others(l_proc_name,l_proc_step);
429: IF g_debug THEN
430: debug('Leaving: '||l_proc_name,-999);
431: END IF;

Line 561: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

557:
558: EXCEPTION
559: WHEN OTHERS THEN
560: clear_cache;
561: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
562: debug_others(l_proc_name,l_proc_step);
563: IF g_debug THEN
564: debug('Leaving: '||l_proc_name,-999);
565: END IF;

Line 670: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

666:
667: EXCEPTION
668: WHEN OTHERS THEN
669: clear_cache;
670: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
671: debug_others(l_proc_name,l_proc_step);
672: IF g_debug THEN
673: debug('Leaving: '||l_proc_name,-999);
674: END IF;

Line 767: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

763:
764: EXCEPTION
765: WHEN OTHERS THEN
766: clear_cache;
767: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
768: debug_others(l_proc_name,l_proc_step);
769: IF g_debug THEN
770: debug('Leaving: '||l_proc_name,-999);
771: END IF;

Line 833: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

829:
830: EXCEPTION
831: WHEN OTHERS THEN
832: clear_cache;
833: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
834: debug_others(l_proc_name,l_proc_step);
835: IF g_debug THEN
836: debug('Leaving: '||l_proc_name,-999);
837: END IF;

Line 1192: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

1188:
1189: EXCEPTION
1190: WHEN OTHERS THEN
1191: clear_cache;
1192: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
1193: debug_others(l_proc_name,l_proc_step);
1194: IF g_debug THEN
1195: debug('Leaving: '||l_proc_name,-999);
1196: END IF;

Line 1223: g_debug := hr_utility.debug_enabled;

1219:
1220: BEGIN -- get_fte_value
1221:
1222: IF NOT g_is_concurrent_program_run THEN
1223: g_debug := hr_utility.debug_enabled;
1224: END IF;
1225:
1226: IF g_debug THEN
1227: debug_enter(l_proc_name);

Line 1246: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

1242:
1243: EXCEPTION
1244: WHEN OTHERS THEN
1245: clear_cache;
1246: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
1247: debug_others(l_proc_name,l_proc_step);
1248: IF g_debug THEN
1249: debug('Leaving: '||l_proc_name,-999);
1250: END IF;

Line 1328: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

1324: EXCEPTION
1325: WHEN OTHERS THEN
1326: p_assignment_details := l_assignment_details; -- nocopy
1327: clear_cache;
1328: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
1329: debug_others(l_proc_name,l_proc_step);
1330: IF g_debug THEN
1331: debug('Leaving: '||l_proc_name,-999);
1332: END IF;

Line 1501: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

1497: EXCEPTION
1498: WHEN OTHERS THEN
1499: p_contract_details := l_contract_details; -- empty for nocopy
1500: clear_cache;
1501: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
1502: debug_others(l_proc_name,l_proc_step);
1503: IF g_debug THEN
1504: debug('Leaving: '||l_proc_name,-999);
1505: END IF;

Line 1612: hr_utility.trace(

1608: ,p_FTE_value => l_FTE_value
1609: );
1610:
1611: IF g_debug THEN
1612: hr_utility.trace(
1613: 'Updated, '||p_assignment_id||', '||
1614: fnd_date.date_to_displaydate(p_effective_date)||', '||
1615: l_FTE_value||', '||
1616: l_assignment_details.normal_hours||', '||

Line 1639: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

1635:
1636: EXCEPTION
1637: WHEN OTHERS THEN
1638: clear_cache;
1639: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
1640: debug_others(l_proc_name,l_proc_step);
1641: IF g_debug THEN
1642: debug('Leaving: '||l_proc_name,-999);
1643: END IF;

Line 1755: g_debug := hr_utility.debug_enabled;

1751: BEGIN -- update_fte_for_assignment
1752:
1753:
1754: IF NOT g_is_concurrent_program_run THEN
1755: g_debug := hr_utility.debug_enabled;
1756: END IF;
1757:
1758: IF g_debug THEN
1759: debug_enter(l_proc_name);

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

1917: );
1918: ELSE
1919: BEGIN -- For bug 5531482
1920: IF g_debug THEN
1921: hr_utility.set_location('In the Debug -4 This_change.effective_start_date:-'||this_change.effective_start_date,70);
1922: hr_utility.set_location('In the Debug -5 l_last_change_date:-'||l_last_change_date,80);
1923: END IF;
1924: g_output_file_records(g_output_file_records.LAST) :=
1925: g_output_file_records(g_output_file_records.LAST-1);

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

1918: ELSE
1919: BEGIN -- For bug 5531482
1920: IF g_debug THEN
1921: hr_utility.set_location('In the Debug -4 This_change.effective_start_date:-'||this_change.effective_start_date,70);
1922: hr_utility.set_location('In the Debug -5 l_last_change_date:-'||l_last_change_date,80);
1923: END IF;
1924: g_output_file_records(g_output_file_records.LAST) :=
1925: g_output_file_records(g_output_file_records.LAST-1);
1926: g_output_file_records(g_output_file_records.LAST).change_in :=

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

1930: g_output_file_records(g_output_file_records.LAST).message :=
1931: 'Processing was skipped as this change effective the same date as the previous record.';
1932: EXCEPTION
1933: when VALUE_ERROR then
1934: hr_utility.set_location('In the Debug -6 VALUE_ERROR',90);
1935: null;
1936: when others then
1937: hr_utility.set_location('In the Debug -7 OTHERS',100);
1938: hr_utility.set_location('In the Debug -8:'||sqlerrm,110);

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

1933: when VALUE_ERROR then
1934: hr_utility.set_location('In the Debug -6 VALUE_ERROR',90);
1935: null;
1936: when others then
1937: hr_utility.set_location('In the Debug -7 OTHERS',100);
1938: hr_utility.set_location('In the Debug -8:'||sqlerrm,110);
1939: Raise;
1940: END; -- End For bug 5531482
1941: END IF;

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

1934: hr_utility.set_location('In the Debug -6 VALUE_ERROR',90);
1935: null;
1936: when others then
1937: hr_utility.set_location('In the Debug -7 OTHERS',100);
1938: hr_utility.set_location('In the Debug -8:'||sqlerrm,110);
1939: Raise;
1940: END; -- End For bug 5531482
1941: END IF;
1942: END LOOP; --FOR this_change IN csr_get_relevant_change_dates

Line 1956: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

1952:
1953: EXCEPTION
1954: WHEN OTHERS THEN
1955: clear_cache;
1956: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
1957: debug_others(l_proc_name,l_proc_step);
1958: IF g_debug THEN
1959: debug('Leaving: '||l_proc_name,-999);
1960: END IF;

Line 2072: g_debug := hr_utility.debug_enabled;

2068: BEGIN -- update_fte_for_assignment_set
2069:
2070: g_is_concurrent_program_run := TRUE;
2071:
2072: g_debug := hr_utility.debug_enabled;
2073:
2074: IF p_trace = 'Y' THEN
2075: g_debug := TRUE;
2076: END IF;

Line 2404: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

2400: WHEN OTHERS THEN
2401:
2402: clear_cache;
2403:
2404: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
2405: debug_others(l_proc_name,l_proc_step);
2406: IF g_debug THEN
2407: debug('Leaving: '||l_proc_name,-999);
2408: END IF;

Line 2482: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

2478:
2479: EXCEPTION
2480: WHEN OTHERS THEN
2481: clear_cache;
2482: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
2483: debug_others(l_proc_name,l_proc_step);
2484: IF g_debug THEN
2485: debug('Leaving: '||l_proc_name,-999);
2486: END IF;