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

Line 166: hr_utility.trace_on(NULL, 'REQID'); -- Pipe name REQIDnnnnn

162: BEGIN
163: --
164: IF g_debug THEN
165: IF pqp_utilities.g_nested_level = 0 THEN
166: hr_utility.trace_on(NULL, 'REQID'); -- Pipe name REQIDnnnnn
167: END IF;
168: pqp_utilities.debug_enter (
169: p_proc_name => p_proc_name
170: ,p_trace_on => p_trace_on

Line 195: hr_utility.trace_off;

191: ,p_trace_off => p_trace_off
192: );
193:
194: IF pqp_utilities.g_nested_level = 0 THEN
195: hr_utility.trace_off;
196: END IF;
197: END IF;
198: --
199: END debug_exit;

Line 314: IF SQLCODE <> hr_utility.hr_error_number

310: return false;
311: END IF;
312: EXCEPTION
313: WHEN others THEN
314: IF SQLCODE <> hr_utility.hr_error_number
315: THEN
316: debug_others (l_proc_name, 10);
317: IF g_debug
318: THEN

Line 359: IF SQLCODE <> hr_utility.hr_error_number

355: return false;
356: END IF;
357: EXCEPTION
358: WHEN others THEN
359: IF SQLCODE <> hr_utility.hr_error_number
360: THEN
361: debug_others (l_proc_name, 10);
362: IF g_debug
363: THEN

Line 403: IF SQLCODE <> hr_utility.hr_error_number

399: return false;
400: END IF;
401: EXCEPTION
402: WHEN others THEN
403: IF SQLCODE <> hr_utility.hr_error_number
404: THEN
405: debug_others (l_proc_name, 10);
406: IF g_debug
407: THEN

Line 455: hr_utility.set_message(805, 'BEN_94453_INV_PAYPOINT');

451: or
452: NOT PQP_GB_PSI_FUNCTIONS.is_alphanumeric(p_string=> l_pay_point)
453: THEN
454: -- Raise error as Paypoint is unknown(E)
455: hr_utility.set_message(805, 'BEN_94453_INV_PAYPOINT');
456: fnd_file.put_line(fnd_file.LOG
457: , RPAD('Error', 30) || ': ' || hr_utility.get_message);
458: fnd_file.put_line(fnd_file.LOG, ' ');
459: END IF;

Line 457: , RPAD('Error', 30) || ': ' || hr_utility.get_message);

453: THEN
454: -- Raise error as Paypoint is unknown(E)
455: hr_utility.set_message(805, 'BEN_94453_INV_PAYPOINT');
456: fnd_file.put_line(fnd_file.LOG
457: , RPAD('Error', 30) || ': ' || hr_utility.get_message);
458: fnd_file.put_line(fnd_file.LOG, ' ');
459: END IF;
460:
461:

Line 493: hr_utility.set_message(805, 'BEN_94458_PEN_SPCL_CHAR_CHK');

489: RPAD(nvl(l_bonus_rec.pre_75_reckonable,' '),1,' ') ||
490: RPAD(l_filler2,86,' '));
491: --
492: -- Raise error as Special characters are not permitted in the allowance code(E)
493: hr_utility.set_message(805, 'BEN_94458_PEN_SPCL_CHAR_CHK');
494: fnd_file.put_line(fnd_file.LOG
495: , RPAD('Error', 30) || ': ' || hr_utility.get_message);
496:
497: fnd_file.put_line(fnd_file.log, 'INTERFACE : Bonus');

Line 495: , RPAD('Error', 30) || ': ' || hr_utility.get_message);

491: --
492: -- Raise error as Special characters are not permitted in the allowance code(E)
493: hr_utility.set_message(805, 'BEN_94458_PEN_SPCL_CHAR_CHK');
494: fnd_file.put_line(fnd_file.LOG
495: , RPAD('Error', 30) || ': ' || hr_utility.get_message);
496:
497: fnd_file.put_line(fnd_file.log, 'INTERFACE : Bonus');
498:
499: fnd_file.put_line(fnd_file.log, 'ELEMENT : '|| l_bonus_rec.element_name);

Line 587: hr_utility.set_message(805, 'BEN_94453_INV_PAYPOINT');

583: or
584: NOT PQP_GB_PSI_FUNCTIONS.is_alphanumeric(p_string=> l_pay_point)
585: THEN
586: -- Raise error as Paypoint is unknown(E)
587: hr_utility.set_message(805, 'BEN_94453_INV_PAYPOINT');
588: fnd_file.put_line(fnd_file.LOG
589: , RPAD('Error', 30) || ': ' || hr_utility.get_message);
590: fnd_file.put_line(fnd_file.LOG, ' ');
591: END IF;

Line 589: , RPAD('Error', 30) || ': ' || hr_utility.get_message);

585: THEN
586: -- Raise error as Paypoint is unknown(E)
587: hr_utility.set_message(805, 'BEN_94453_INV_PAYPOINT');
588: fnd_file.put_line(fnd_file.LOG
589: , RPAD('Error', 30) || ': ' || hr_utility.get_message);
590: fnd_file.put_line(fnd_file.LOG, ' ');
591: END IF;
592: --Pass context as PQP_GB_PENSERV_ALLOWANCE_INFO to get the allowance codes information
593: FOR l_allowance_rec IN csr_get_extra_allow_info

Line 624: hr_utility.set_message(805, 'BEN_94458_PEN_SPCL_CHAR_CHK');

620: RPAD(nvl(l_allowance_rec.pre_75_reckonable,' '),1,' ') ||
621: RPAD(l_filler2,79,' '));
622: --
623: -- Raise error as Special characters are not permitted in the allowance code(E)
624: hr_utility.set_message(805, 'BEN_94458_PEN_SPCL_CHAR_CHK');
625: fnd_file.put_line(fnd_file.LOG
626: , RPAD('Error', 30) || ': ' || hr_utility.get_message);
627:
628: fnd_file.put_line(fnd_file.log, 'INTERFACE : Allowance');

Line 626: , RPAD('Error', 30) || ': ' || hr_utility.get_message);

622: --
623: -- Raise error as Special characters are not permitted in the allowance code(E)
624: hr_utility.set_message(805, 'BEN_94458_PEN_SPCL_CHAR_CHK');
625: fnd_file.put_line(fnd_file.LOG
626: , RPAD('Error', 30) || ': ' || hr_utility.get_message);
627:
628: fnd_file.put_line(fnd_file.log, 'INTERFACE : Allowance');
629:
630: fnd_file.put_line(fnd_file.log, 'ELEMENT : '|| l_allowance_rec.element_name);

Line 1799: hr_utility.set_location('p_ext_ehi_rslt_id: ' || p_ext_ehi_rslt_id, 10);

1795:
1796: BEGIN
1797:
1798:
1799: hr_utility.set_location('p_ext_ehi_rslt_id: ' || p_ext_ehi_rslt_id, 10);
1800: -- check for enabling trace
1801: g_debug := pqp_gb_psi_functions.check_debug(p_business_group_id);
1802:
1803: l_ext_bdi_rslt_id := p_ext_bdi_rslt_id;

Line 1829: hr_utility.set_message(805, 'BEN_94453_INV_PAYPOINT');

1825: or
1826: NOT PQP_GB_PSI_FUNCTIONS.is_alphanumeric(p_string=> l_pay_point)
1827: THEN
1828: -- Raise error as Paypoint is unknown(E)
1829: hr_utility.set_message(805, 'BEN_94453_INV_PAYPOINT');
1830: fnd_file.put_line(fnd_file.LOG
1831: , RPAD('Error', 30) || ': ' || hr_utility.get_message);
1832: fnd_file.put_line(fnd_file.LOG, ' ');
1833: END IF;

Line 1831: , RPAD('Error', 30) || ': ' || hr_utility.get_message);

1827: THEN
1828: -- Raise error as Paypoint is unknown(E)
1829: hr_utility.set_message(805, 'BEN_94453_INV_PAYPOINT');
1830: fnd_file.put_line(fnd_file.LOG
1831: , RPAD('Error', 30) || ': ' || hr_utility.get_message);
1832: fnd_file.put_line(fnd_file.LOG, ' ');
1833: END IF;
1834:
1835:

Line 1846: hr_utility.set_location('l_per_end_date: ' || l_per_end_date, 10);

1842: FETCH csr_get_rsltid INTO l_get_rsltid;
1843: EXIT WHEN csr_get_rsltid%NOTFOUND;
1844: l_ext_date := l_get_rsltid.req_date;
1845: l_per_end_date := fnd_date.canonical_to_date(l_get_rsltid.Extract_eff_date); -- For Nuvos change
1846: hr_utility.set_location('l_per_end_date: ' || l_per_end_date, 10);
1847: IF l_get_rsltid.Interface_File = g_periodic_ext_names(1).extract_code THEN
1848: l_ext_bdi_rslt_id := l_get_rsltid.rslt_id; -- dbms_output.put_line(l_ext_bdi_rslt_id);
1849: debug('l_get_rsltid.rslt_id '|| l_get_rsltid.rslt_id, 20);
1850: ELSIF l_get_rsltid.Interface_File = g_periodic_ext_names(2).extract_code THEN

Line 1889: hr_utility.set_location('l_ext_ehi_rslt_id: ' || l_ext_ehi_rslt_id, 30);

1885:
1886: debug('l_get_rsltid.rslt_id '|| l_get_rsltid.rslt_id, 125);
1887: END IF;
1888:
1889: hr_utility.set_location('l_ext_ehi_rslt_id: ' || l_ext_ehi_rslt_id, 30);
1890: --Basic Data interface Count
1891: IF l_ext_bdi_rslt_id IS NOT NULL THEN
1892: OPEN csr_get_ttl_rslt(c_ext_rslt_id => l_ext_bdi_rslt_id);
1893: FETCH csr_get_ttl_rslt INTO l_get_ttl_rslt;

Line 2066: hr_utility.set_location('l_per_end_date: '||l_per_end_date,64);

2062: ELSE
2063: l_per_end_date := fnd_date.canonical_to_date(l_eff_date_arg8);
2064: END IF;
2065: CLOSE csr_get_eff_date;
2066: hr_utility.set_location('l_per_end_date: '||l_per_end_date,64);
2067: ELSE
2068: l_Earning_Hist_Cnt := RPAD(' ',10,' ');
2069: l_Earning_Tot_Cnt := RPAD(' ',16,' ');
2070: END IF;

Line 2129: hr_utility.set_location('l_eff_date_arg8'|| l_eff_date_arg8,31);

2125: IF csr_get_eff_date%NOTFOUND
2126: THEN
2127: l_per_end_date := sysdate;
2128: ELSE
2129: hr_utility.set_location('l_eff_date_arg8'|| l_eff_date_arg8,31);
2130: l_per_end_date := fnd_date.canonical_to_date(l_eff_date_arg8);
2131: END IF;
2132: CLOSE csr_get_eff_date;
2133: hr_utility.set_location('l_per_end_date: '||l_per_end_date,64);

Line 2133: hr_utility.set_location('l_per_end_date: '||l_per_end_date,64);

2129: hr_utility.set_location('l_eff_date_arg8'|| l_eff_date_arg8,31);
2130: l_per_end_date := fnd_date.canonical_to_date(l_eff_date_arg8);
2131: END IF;
2132: CLOSE csr_get_eff_date;
2133: hr_utility.set_location('l_per_end_date: '||l_per_end_date,64);
2134: ELSE
2135: l_Pay_Hist_Cnt := RPAD(' ',10,' ');
2136: l_Pay_Tot_EARN_Cnt := RPAD(' ',16,' ');
2137: l_Pay_Tot_DEDS_Cnt := RPAD(' ',16,' ');

Line 2464: hr_utility.set_location('l_year_close1: ' || l_year_close , 11);

2460: END IF;
2461: END IF;
2462:
2463: ------------
2464: hr_utility.set_location('l_year_close1: ' || l_year_close , 11);
2465: hr_utility.set_location('p_year_end_close: ' || p_year_end_close , 11);
2466:
2467: /* For Nuvps */
2468: IF p_year_end_close = 'Yes'

Line 2465: hr_utility.set_location('p_year_end_close: ' || p_year_end_close , 11);

2461: END IF;
2462:
2463: ------------
2464: hr_utility.set_location('l_year_close1: ' || l_year_close , 11);
2465: hr_utility.set_location('p_year_end_close: ' || p_year_end_close , 11);
2466:
2467: /* For Nuvps */
2468: IF p_year_end_close = 'Yes'
2469: THEN

Line 2486: hr_utility.set_location('l_per_end_date: ' || l_per_end_date, 20);

2482:
2483: END IF;
2484:
2485: l_per_end_date := last_day(l_per_end_date);
2486: hr_utility.set_location('l_per_end_date: ' || l_per_end_date, 20);
2487: hr_utility.set_location('l_year_close6: ' || l_year_close , 11);
2488:
2489: l_Earning_Hist_Cnt := RPAD(' ',10,' ');
2490: l_Earning_Tot_Cnt := RPAD(' ',16,' ');

Line 2487: hr_utility.set_location('l_year_close6: ' || l_year_close , 11);

2483: END IF;
2484:
2485: l_per_end_date := last_day(l_per_end_date);
2486: hr_utility.set_location('l_per_end_date: ' || l_per_end_date, 20);
2487: hr_utility.set_location('l_year_close6: ' || l_year_close , 11);
2488:
2489: l_Earning_Hist_Cnt := RPAD(' ',10,' ');
2490: l_Earning_Tot_Cnt := RPAD(' ',16,' ');
2491:

Line 2799: IF SQLCODE <> hr_utility.hr_error_number

2795: RETURN l_employer_code;
2796:
2797: EXCEPTION
2798: WHEN others THEN
2799: IF SQLCODE <> hr_utility.hr_error_number
2800: THEN
2801: debug_others (l_proc_name, 10);
2802: IF g_debug
2803: THEN

Line 2869: IF SQLCODE <> hr_utility.hr_error_number

2865: RETURN l_return;
2866:
2867: EXCEPTION
2868: WHEN others THEN
2869: IF SQLCODE <> hr_utility.hr_error_number
2870: THEN
2871: debug_others (l_proc_name, 10);
2872: IF g_debug
2873: THEN

Line 2935: IF SQLCODE <> hr_utility.hr_error_number

2931: RETURN g_paypoint;
2932:
2933: EXCEPTION
2934: WHEN others THEN
2935: IF SQLCODE <> hr_utility.hr_error_number
2936: THEN
2937: debug_others (l_proc_name, 10);
2938: IF g_debug
2939: THEN

Line 3031: IF SQLCODE <> hr_utility.hr_error_number

3027: debug_exit(l_proc_name);
3028:
3029: EXCEPTION
3030: WHEN others THEN
3031: IF SQLCODE <> hr_utility.hr_error_number
3032: THEN
3033: debug_others (l_proc_name, 10);
3034: IF g_debug
3035: THEN

Line 3177: IF SQLCODE <> hr_utility.hr_error_number

3173: debug_exit(l_proc_name);
3174:
3175: EXCEPTION
3176: WHEN others THEN
3177: IF SQLCODE <> hr_utility.hr_error_number
3178: THEN
3179: debug_others (l_proc_name, 10);
3180: IF g_debug
3181: THEN

Line 3297: IF SQLCODE <> hr_utility.hr_error_number

3293: fnd_file.put_line(fnd_file.log, 'Done : ' || l_proc_name || ' : ' || get_time);
3294:
3295: EXCEPTION
3296: WHEN others THEN
3297: IF SQLCODE <> hr_utility.hr_error_number
3298: THEN
3299: debug_others (l_proc_name, 10);
3300: IF g_debug
3301: THEN

Line 3465: IF SQLCODE <> hr_utility.hr_error_number

3461: --
3462: RETURN l_return_value;
3463: EXCEPTION
3464: WHEN others THEN
3465: IF SQLCODE <> hr_utility.hr_error_number
3466: THEN
3467: debug_others (l_proc_name, 10);
3468: IF g_debug
3469: THEN

Line 3613: IF SQLCODE <> hr_utility.hr_error_number

3609:
3610: RETURN l_return_value;
3611: EXCEPTION
3612: WHEN others THEN
3613: IF SQLCODE <> hr_utility.hr_error_number
3614: THEN
3615: debug_others (l_proc_name, 10);
3616: IF g_debug
3617: THEN

Line 3749: IF SQLCODE <> hr_utility.hr_error_number

3745: debug_exit(l_proc_name);
3746:
3747: EXCEPTION
3748: WHEN others THEN
3749: IF SQLCODE <> hr_utility.hr_error_number
3750: THEN
3751: debug_others (l_proc_name, 10);
3752: IF g_debug
3753: THEN

Line 3958: IF SQLCODE <> hr_utility.hr_error_number

3954: debug_exit(l_proc_name);
3955:
3956: EXCEPTION
3957: WHEN others THEN
3958: IF SQLCODE <> hr_utility.hr_error_number
3959: THEN
3960: debug_others (l_proc_name, 10);
3961: IF g_debug
3962: THEN

Line 4087: IF SQLCODE <> hr_utility.hr_error_number

4083: debug_exit(l_proc_name);
4084:
4085: EXCEPTION
4086: WHEN others THEN
4087: IF SQLCODE <> hr_utility.hr_error_number
4088: THEN
4089: debug_others (l_proc_name, 10);
4090: IF g_debug
4091: THEN

Line 4200: IF SQLCODE <> hr_utility.hr_error_number

4196: return l_return;
4197:
4198: EXCEPTION
4199: WHEN others THEN
4200: IF SQLCODE <> hr_utility.hr_error_number
4201: THEN
4202: debug_others (l_proc_name, 10);
4203: IF g_debug
4204: THEN

Line 4333: IF SQLCODE <> hr_utility.hr_error_number

4329: return l_return;
4330:
4331: EXCEPTION
4332: WHEN others THEN
4333: IF SQLCODE <> hr_utility.hr_error_number
4334: THEN
4335: debug_others (l_proc_name, 10);
4336: IF g_debug
4337: THEN

Line 4693: IF SQLCODE <> hr_utility.hr_error_number

4689: return l_inclusion_flag;
4690:
4691: EXCEPTION
4692: WHEN others THEN
4693: IF SQLCODE <> hr_utility.hr_error_number
4694: THEN
4695: debug_others (l_proc_name, 10);
4696: IF g_debug
4697: THEN

Line 4907: IF SQLCODE <> hr_utility.hr_error_number

4903:
4904: RETURN l_run_date;
4905: EXCEPTION
4906: WHEN others THEN
4907: IF SQLCODE <> hr_utility.hr_error_number
4908: THEN
4909: debug_others (l_proc_name, l_proc_step);
4910: IF g_debug
4911: THEN

Line 5136: IF SQLCODE <> hr_utility.hr_error_number

5132:
5133: RETURN l_return;
5134: EXCEPTION
5135: WHEN others THEN
5136: IF SQLCODE <> hr_utility.hr_error_number
5137: THEN
5138: debug_others (l_proc_name, l_proc_step);
5139: IF g_debug
5140: THEN

Line 5233: IF SQLCODE <> hr_utility.hr_error_number

5229: END IF;
5230: EXCEPTION
5231: WHEN OTHERS
5232: THEN
5233: IF SQLCODE <> hr_utility.hr_error_number
5234: THEN
5235: debug_others(l_proc_name, l_proc_step);
5236:
5237: IF g_debug

Line 5390: IF SQLCODE <> hr_utility.hr_error_number

5386: debug_exit(l_proc);
5387: return l_leaver;
5388: EXCEPTION
5389: WHEN others THEN
5390: IF SQLCODE <> hr_utility.hr_error_number
5391: THEN
5392: debug_others (l_proc, 10);
5393: IF g_debug
5394: THEN

Line 5550: IF SQLCODE <> hr_utility.hr_error_number

5546: debug_exit(l_proc);
5547: RETURN l_return;
5548: EXCEPTION
5549: WHEN others THEN
5550: IF SQLCODE <> hr_utility.hr_error_number
5551: THEN
5552: debug_others (l_proc, 10);
5553: IF g_debug
5554: THEN

Line 5648: IF SQLCODE <> hr_utility.hr_error_number

5644: debug_exit(l_proc_name);
5645:
5646: EXCEPTION
5647: WHEN others THEN
5648: IF SQLCODE <> hr_utility.hr_error_number
5649: THEN
5650: debug_others (l_proc_name, 10);
5651: IF g_debug
5652: THEN

Line 5775: IF SQLCODE <> hr_utility.hr_error_number

5771:
5772: debug_exit(l_proc_name);
5773: EXCEPTION
5774: WHEN others THEN
5775: IF SQLCODE <> hr_utility.hr_error_number
5776: THEN
5777: debug_others (l_proc_name, 10);
5778: IF g_debug
5779: THEN

Line 5959: IF SQLCODE <> hr_utility.hr_error_number

5955: return l_run_result_value;
5956:
5957: EXCEPTION
5958: WHEN others THEN
5959: IF SQLCODE <> hr_utility.hr_error_number
5960: THEN
5961: debug_others (l_proc_name, 10);
5962: IF g_debug
5963: THEN

Line 6029: IF SQLCODE <> hr_utility.hr_error_number

6025: return l_payment;
6026:
6027: EXCEPTION
6028: WHEN others THEN
6029: IF SQLCODE <> hr_utility.hr_error_number
6030: THEN
6031: debug_others (l_proc_name, 10);
6032: IF g_debug
6033: THEN

Line 6118: IF SQLCODE <> hr_utility.hr_error_number

6114: return l_balance_value;
6115:
6116: EXCEPTION
6117: WHEN others THEN
6118: IF SQLCODE <> hr_utility.hr_error_number
6119: THEN
6120: debug_others (l_proc_name, 10);
6121: IF g_debug
6122: THEN

Line 6296: IF SQLCODE <> hr_utility.hr_error_number

6292: return l_balance_ele_value;
6293:
6294: EXCEPTION
6295: WHEN others THEN
6296: IF SQLCODE <> hr_utility.hr_error_number
6297: THEN
6298: debug_others (l_proc_name, 10);
6299: IF g_debug
6300: THEN

Line 6369: IF SQLCODE <> hr_utility.hr_error_number

6365: return l_payment;
6366:
6367: EXCEPTION
6368: WHEN others THEN
6369: IF SQLCODE <> hr_utility.hr_error_number
6370: THEN
6371: debug_others (l_proc_name, 10);
6372: IF g_debug
6373: THEN

Line 6454: IF SQLCODE <> hr_utility.hr_error_number

6450: RETURN p_output;
6451:
6452: EXCEPTION
6453: WHEN others THEN
6454: IF SQLCODE <> hr_utility.hr_error_number
6455: THEN
6456: debug_others (l_proc_name, 10);
6457: IF g_debug
6458: THEN

Line 6772: IF SQLCODE <> hr_utility.hr_error_number

6768: RETURN p_output;
6769:
6770: EXCEPTION
6771: WHEN others THEN
6772: IF SQLCODE <> hr_utility.hr_error_number
6773: THEN
6774: debug_others (l_proc_name, 10);
6775: IF g_debug
6776: THEN

Line 7882: IF SQLCODE <> hr_utility.hr_error_number

7878:
7879: p_rate := NVL(l_user_rate,0);
7880: EXCEPTION
7881: WHEN others THEN
7882: IF SQLCODE <> hr_utility.hr_error_number
7883: THEN
7884: debug_others (l_proc, 10);
7885: IF g_debug
7886: THEN