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

Line 303: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

299: RETURN l_business_group_id;
300: EXCEPTION
301: WHEN OTHERS THEN
302: clear_cache;
303: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
304: debug_others(l_proc_name,l_proc_step);
305: IF g_debug THEN
306: debug('Leaving: '||l_proc_name,-999);
307: END IF;

Line 398: g_debug := hr_utility.debug_enabled;

394:
395:
396: BEGIN
397:
398: g_debug := hr_utility.debug_enabled;
399:
400: IF g_debug THEN
401: debug_enter(l_proc_name);
402: debug('p_element_type_extra_info_id:'||p_element_type_extra_info_id);

Line 469: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

465:
466: EXCEPTION
467: WHEN OTHERS THEN
468: clear_cache;
469: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
470: debug_others(l_proc_name,l_proc_step);
471: IF g_debug THEN
472: debug('Leaving: '||l_proc_name,-999);
473: END IF;

Line 607: g_debug := hr_utility.debug_enabled;

603: WHERE assignment_id = p_assignment_id
604: AND p_date BETWEEN effective_start_date AND effective_end_date;
605: BEGIN
606: --
607: g_debug := hr_utility.debug_enabled;
608: IF g_debug THEN
609: debug_enter(l_proc_name);
610: END IF;
611:

Line 625: hr_utility.set_message(8303, 'PQP_230113_AAT_MISSING_CONTRCT');

621: THEN
622: --
623: -- Added a new message for contract type not found
624: -- BUG 3454641
625: hr_utility.set_message(8303, 'PQP_230113_AAT_MISSING_CONTRCT');
626: -- ver 115.35 : anshghos : setting token value
627: fnd_message.set_token('EFFECTIVEDATE',fnd_date.date_to_canonical(p_date));
628: hr_utility.raise_error;
629: -- RETURN 0;

Line 628: hr_utility.raise_error;

624: -- BUG 3454641
625: hr_utility.set_message(8303, 'PQP_230113_AAT_MISSING_CONTRCT');
626: -- ver 115.35 : anshghos : setting token value
627: fnd_message.set_token('EFFECTIVEDATE',fnd_date.date_to_canonical(p_date));
628: hr_utility.raise_error;
629: -- RETURN 0;
630: --
631: END IF;
632:

Line 656: hr_utility.set_location('Leaving:' || l_proc_name, 20);

652: l_service_factor := 0;
653: --
654: END LOOP;
655:
656: hr_utility.set_location('Leaving:' || l_proc_name, 20);
657: RETURN l_service_factor;
658: EXCEPTION
659: WHEN OTHERS THEN
660: clear_cache;

Line 661: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

657: RETURN l_service_factor;
658: EXCEPTION
659: WHEN OTHERS THEN
660: clear_cache;
661: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
662: debug_others(l_proc_name,l_proc_step);
663: IF g_debug THEN
664: debug('Leaving: '||l_proc_name,-999);
665: END IF;

Line 728: g_debug := hr_utility.debug_enabled;

724: l_column_name pay_user_columns.user_column_name%TYPE;
725:
726: BEGIN
727:
728: g_debug := hr_utility.debug_enabled;
729: IF g_debug THEN
730: debug_enter(l_proc_name);
731: debug('p_assignment_id:'||p_assignment_id);
732: debug('p_effective_date:'||fnd_date.date_to_canonical(p_effective_date));

Line 854: hr_utility.set_message(8303, 'PQP_230513_INVALID_CNTRCT_TYPE');

850: IF g_debug THEN
851: debug(l_proc_name,l_proc_step);
852: END IF;
853:
854: hr_utility.set_message(8303, 'PQP_230513_INVALID_CNTRCT_TYPE');
855: hr_utility.raise_error;
856:
857: END IF;
858:

Line 855: hr_utility.raise_error;

851: debug(l_proc_name,l_proc_step);
852: END IF;
853:
854: hr_utility.set_message(8303, 'PQP_230513_INVALID_CNTRCT_TYPE');
855: hr_utility.raise_error;
856:
857: END IF;
858:
859: IF g_debug THEN

Line 869: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

865:
866: EXCEPTION
867: WHEN OTHERS THEN
868: clear_cache;
869: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
870: debug_others(l_proc_name,l_proc_step);
871: IF g_debug THEN
872: debug('Leaving: '||l_proc_name,-999);
873: END IF;

Line 930: g_debug := hr_utility.debug_enabled;

926: l_to_time_dimension fnd_lookup_values.lookup_code%TYPE;
927:
928: BEGIN
929:
930: g_debug := hr_utility.debug_enabled;
931: IF g_debug THEN
932: debug_enter(l_proc_name);
933: debug('p_assignment_id:'||p_assignment_id);
934: debug('p_date:'||fnd_date.date_to_canonical(p_date));

Line 1016: hr_utility.set_message(8303, 'PQP_230113_AAT_MISSING_CONTRCT');

1012: THEN
1013:
1014: IF l_contract_type IS NULL
1015: THEN
1016: hr_utility.set_message(8303, 'PQP_230113_AAT_MISSING_CONTRCT');
1017: -- ver 115.35 : anshghos : setting token value
1018: fnd_message.set_token('EFFECTIVEDATE',fnd_date.date_to_canonical(p_date));
1019: hr_utility.raise_error;
1020: END IF;

Line 1019: hr_utility.raise_error;

1015: THEN
1016: hr_utility.set_message(8303, 'PQP_230113_AAT_MISSING_CONTRCT');
1017: -- ver 115.35 : anshghos : setting token value
1018: fnd_message.set_token('EFFECTIVEDATE',fnd_date.date_to_canonical(p_date));
1019: hr_utility.raise_error;
1020: END IF;
1021:
1022: -- Modified code to improve performance
1023: -- BUG 3454641

Line 1241: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

1237:
1238: EXCEPTION
1239: WHEN OTHERS THEN
1240: clear_cache;
1241: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
1242: debug_others(l_proc_name,l_proc_step);
1243: IF g_debug THEN
1244: debug('Leaving: '||l_proc_name,-999);
1245: END IF;

Line 1281: g_debug := hr_utility.debug_enabled;

1277: l_modified_rate NUMBER;
1278:
1279: BEGIN
1280:
1281: g_debug := hr_utility.debug_enabled;
1282:
1283: IF g_debug THEN
1284: debug_enter(l_proc_name);
1285: debug('p_assignment_id:'||p_assignment_id);

Line 1397: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

1393:
1394: EXCEPTION
1395: WHEN OTHERS THEN
1396: clear_cache;
1397: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
1398: debug_others(l_proc_name,l_proc_step);
1399: IF g_debug THEN
1400: debug('Leaving: '||l_proc_name,-999);
1401: END IF;

Line 1512: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

1508:
1509: EXCEPTION
1510: WHEN OTHERS THEN
1511: clear_cache;
1512: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
1513: debug_others(l_proc_name,l_proc_step);
1514: IF g_debug THEN
1515: debug('Leaving: '||l_proc_name,-999);
1516: END IF;

Line 1588: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

1584:
1585: EXCEPTION
1586: WHEN OTHERS THEN
1587: clear_cache;
1588: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
1589: debug_others(l_proc_name,l_proc_step);
1590: IF g_debug THEN
1591: debug('Leaving: '||l_proc_name,-999);
1592: END IF;

Line 1777: g_debug := hr_utility.debug_enabled;

1773:
1774:
1775: BEGIN
1776:
1777: g_debug := hr_utility.debug_enabled;
1778: IF g_debug THEN
1779: debug_enter(l_proc_name);
1780: debug('p_assignment_id:'||p_assignment_id); --IN NUMBER
1781: debug('p_date:'||fnd_date.date_to_canonical(p_date)); --IN DATE

Line 1830: hr_utility.set_message(8303, 'PQP_230508_MULTIPLR_SCL_RATES');

1826: debug(l_proc_name,l_proc_step);
1827: END IF;
1828:
1829: CLOSE csr_spinal_pay_scale;
1830: hr_utility.set_message(8303, 'PQP_230508_MULTIPLR_SCL_RATES');
1831: hr_utility.raise_error;
1832: --
1833: END IF;
1834:

Line 1831: hr_utility.raise_error;

1827: END IF;
1828:
1829: CLOSE csr_spinal_pay_scale;
1830: hr_utility.set_message(8303, 'PQP_230508_MULTIPLR_SCL_RATES');
1831: hr_utility.raise_error;
1832: --
1833: END IF;
1834:
1835: IF csr_spinal_pay_scale%ROWCOUNT = 0

Line 1864: hr_utility.set_message(8303, 'PQP_230509_MULTIPLE_GRD_RATES');

1860: IF g_debug THEN
1861: debug(l_proc_name,l_proc_step);
1862: END IF;
1863: CLOSE csr_grade_rate;
1864: hr_utility.set_message(8303, 'PQP_230509_MULTIPLE_GRD_RATES');
1865: hr_utility.raise_error;
1866: --
1867: END IF;
1868:

Line 1865: hr_utility.raise_error;

1861: debug(l_proc_name,l_proc_step);
1862: END IF;
1863: CLOSE csr_grade_rate;
1864: hr_utility.set_message(8303, 'PQP_230509_MULTIPLE_GRD_RATES');
1865: hr_utility.raise_error;
1866: --
1867: END IF;
1868:
1869: IF csr_grade_rate%ROWCOUNT = 0

Line 2173: hr_utility.set_message(8303, 'PQP_230510_INVALID_PAY_SRC_VAL');

2169: l_proc_step := 195;
2170: IF g_debug THEN
2171: debug(l_proc_name,l_proc_step);
2172: END IF;
2173: hr_utility.set_message(8303, 'PQP_230510_INVALID_PAY_SRC_VAL');
2174: hr_utility.raise_error;
2175: --
2176: END IF;
2177:

Line 2174: hr_utility.raise_error;

2170: IF g_debug THEN
2171: debug(l_proc_name,l_proc_step);
2172: END IF;
2173: hr_utility.set_message(8303, 'PQP_230510_INVALID_PAY_SRC_VAL');
2174: hr_utility.raise_error;
2175: --
2176: END IF;
2177:
2178: l_proc_step := 200;

Line 2249: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

2245:
2246: EXCEPTION
2247: WHEN OTHERS THEN
2248: clear_cache;
2249: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
2250: debug_others(l_proc_name,l_proc_step);
2251: IF g_debug THEN
2252: debug('Leaving: '||l_proc_name,-999);
2253: END IF;

Line 2335: g_debug := hr_utility.debug_enabled;

2331: l_row_name_source_name pay_element_type_extra_info.eei_information19%TYPE;
2332:
2333: BEGIN
2334:
2335: g_debug := hr_utility.debug_enabled;
2336:
2337: IF g_debug THEN
2338: debug_enter(l_proc_name);
2339: debug('p_assignment_id:'||p_assignment_id);

Line 2683: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

2679:
2680: EXCEPTION
2681: WHEN OTHERS THEN
2682: clear_cache;
2683: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
2684: debug_others(l_proc_name,l_proc_step);
2685: IF g_debug THEN
2686: debug('Leaving: '||l_proc_name,-999);
2687: END IF;

Line 2735: g_debug := hr_utility.debug_enabled;

2731:
2732:
2733: BEGIN
2734:
2735: g_debug := hr_utility.debug_enabled;
2736: IF g_debug THEN
2737: debug('p_assignment_id:'||p_assignment_id);
2738: debug('p_rate_name:'||p_rate_name);
2739: debug('p_effective_date:'||fnd_date.date_to_canonical(p_effective_date));

Line 2792: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

2788:
2789: EXCEPTION
2790: WHEN OTHERS THEN
2791: clear_cache;
2792: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
2793: debug_others(l_proc_name,l_proc_step);
2794: IF g_debug THEN
2795: debug('Leaving: '||l_proc_name,-999);
2796: END IF;