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 378: IF SQLCODE <> hr_utility.hr_error_number

374: return false;
375: END IF;
376: EXCEPTION
377: WHEN others THEN
378: IF SQLCODE <> hr_utility.hr_error_number
379: THEN
380: debug_others (l_proc_name, 10);
381: IF g_debug
382: THEN

Line 423: IF SQLCODE <> hr_utility.hr_error_number

419: return false;
420: END IF;
421: EXCEPTION
422: WHEN others THEN
423: IF SQLCODE <> hr_utility.hr_error_number
424: THEN
425: debug_others (l_proc_name, 10);
426: IF g_debug
427: THEN

Line 467: IF SQLCODE <> hr_utility.hr_error_number

463: return false;
464: END IF;
465: EXCEPTION
466: WHEN others THEN
467: IF SQLCODE <> hr_utility.hr_error_number
468: THEN
469: debug_others (l_proc_name, 10);
470: IF g_debug
471: THEN

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

515: or
516: NOT PQP_GB_PSI_FUNCTIONS.is_alphanumeric(p_string=> l_pay_point)
517: THEN
518: -- Raise error as Paypoint is unknown(E)
519: hr_utility.set_message(805, 'BEN_94453_INV_PAYPOINT');
520: fnd_file.put_line(fnd_file.LOG
521: , RPAD('Error', 30) || ': ' || hr_utility.get_message);
522: fnd_file.put_line(fnd_file.LOG, ' ');
523: END IF;

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

517: THEN
518: -- Raise error as Paypoint is unknown(E)
519: hr_utility.set_message(805, 'BEN_94453_INV_PAYPOINT');
520: fnd_file.put_line(fnd_file.LOG
521: , RPAD('Error', 30) || ': ' || hr_utility.get_message);
522: fnd_file.put_line(fnd_file.LOG, ' ');
523: END IF;
524:
525:

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

553: RPAD(nvl(l_bonus_rec.pre_75_reckonable,' '),1,' ') ||
554: RPAD(l_filler2,86,' '));
555: --
556: -- Raise error as Special characters are not permitted in the allowance code(E)
557: hr_utility.set_message(805, 'BEN_94458_PEN_SPCL_CHAR_CHK');
558: fnd_file.put_line(fnd_file.LOG
559: , RPAD('Error', 30) || ': ' || hr_utility.get_message);
560:
561: fnd_file.put_line(fnd_file.log, 'INTERFACE : Bonus');

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

555: --
556: -- Raise error as Special characters are not permitted in the allowance code(E)
557: hr_utility.set_message(805, 'BEN_94458_PEN_SPCL_CHAR_CHK');
558: fnd_file.put_line(fnd_file.LOG
559: , RPAD('Error', 30) || ': ' || hr_utility.get_message);
560:
561: fnd_file.put_line(fnd_file.log, 'INTERFACE : Bonus');
562:
563: fnd_file.put_line(fnd_file.log, 'ELEMENT : '|| l_bonus_rec.element_name);

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

647: or
648: NOT PQP_GB_PSI_FUNCTIONS.is_alphanumeric(p_string=> l_pay_point)
649: THEN
650: -- Raise error as Paypoint is unknown(E)
651: hr_utility.set_message(805, 'BEN_94453_INV_PAYPOINT');
652: fnd_file.put_line(fnd_file.LOG
653: , RPAD('Error', 30) || ': ' || hr_utility.get_message);
654: fnd_file.put_line(fnd_file.LOG, ' ');
655: END IF;

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

649: THEN
650: -- Raise error as Paypoint is unknown(E)
651: hr_utility.set_message(805, 'BEN_94453_INV_PAYPOINT');
652: fnd_file.put_line(fnd_file.LOG
653: , RPAD('Error', 30) || ': ' || hr_utility.get_message);
654: fnd_file.put_line(fnd_file.LOG, ' ');
655: END IF;
656: --Pass context as PQP_GB_PENSERV_ALLOWANCE_INFO to get the allowance codes information
657: FOR l_allowance_rec IN csr_get_extra_allow_info

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

684: RPAD(nvl(l_allowance_rec.pre_75_reckonable,' '),1,' ') ||
685: RPAD(l_filler2,79,' '));
686: --
687: -- Raise error as Special characters are not permitted in the allowance code(E)
688: hr_utility.set_message(805, 'BEN_94458_PEN_SPCL_CHAR_CHK');
689: fnd_file.put_line(fnd_file.LOG
690: , RPAD('Error', 30) || ': ' || hr_utility.get_message);
691:
692: fnd_file.put_line(fnd_file.log, 'INTERFACE : Allowance');

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

686: --
687: -- Raise error as Special characters are not permitted in the allowance code(E)
688: hr_utility.set_message(805, 'BEN_94458_PEN_SPCL_CHAR_CHK');
689: fnd_file.put_line(fnd_file.LOG
690: , RPAD('Error', 30) || ': ' || hr_utility.get_message);
691:
692: fnd_file.put_line(fnd_file.log, 'INTERFACE : Allowance');
693:
694: fnd_file.put_line(fnd_file.log, 'ELEMENT : '|| l_allowance_rec.element_name);

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

1859:
1860: BEGIN
1861:
1862:
1863: hr_utility.set_location('p_ext_ehi_rslt_id: ' || p_ext_ehi_rslt_id, 10);
1864: -- check for enabling trace
1865: g_debug := pqp_gb_psi_functions.check_debug(p_business_group_id);
1866:
1867: l_ext_bdi_rslt_id := p_ext_bdi_rslt_id;

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

1889: or
1890: NOT PQP_GB_PSI_FUNCTIONS.is_alphanumeric(p_string=> l_pay_point)
1891: THEN
1892: -- Raise error as Paypoint is unknown(E)
1893: hr_utility.set_message(805, 'BEN_94453_INV_PAYPOINT');
1894: fnd_file.put_line(fnd_file.LOG
1895: , RPAD('Error', 30) || ': ' || hr_utility.get_message);
1896: fnd_file.put_line(fnd_file.LOG, ' ');
1897: END IF;

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

1891: THEN
1892: -- Raise error as Paypoint is unknown(E)
1893: hr_utility.set_message(805, 'BEN_94453_INV_PAYPOINT');
1894: fnd_file.put_line(fnd_file.LOG
1895: , RPAD('Error', 30) || ': ' || hr_utility.get_message);
1896: fnd_file.put_line(fnd_file.LOG, ' ');
1897: END IF;
1898:
1899:

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

1906: FETCH csr_get_rsltid INTO l_get_rsltid;
1907: EXIT WHEN csr_get_rsltid%NOTFOUND;
1908: l_ext_date := l_get_rsltid.req_date;
1909: l_per_end_date := fnd_date.canonical_to_date(l_get_rsltid.Extract_eff_date); -- For Nuvos change
1910: hr_utility.set_location('l_per_end_date: ' || l_per_end_date, 10);
1911: IF l_get_rsltid.Interface_File = g_periodic_ext_names(1).extract_code THEN
1912: l_ext_bdi_rslt_id := l_get_rsltid.rslt_id; -- dbms_output.put_line(l_ext_bdi_rslt_id);
1913: debug('l_get_rsltid.rslt_id '|| l_get_rsltid.rslt_id, 20);
1914: ELSIF l_get_rsltid.Interface_File = g_periodic_ext_names(2).extract_code THEN

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

1949:
1950: debug('l_get_rsltid.rslt_id '|| l_get_rsltid.rslt_id, 125);
1951: END IF;
1952:
1953: hr_utility.set_location('l_ext_ehi_rslt_id: ' || l_ext_ehi_rslt_id, 30);
1954: --Basic Data interface Count
1955: IF l_ext_bdi_rslt_id IS NOT NULL THEN
1956: OPEN csr_get_ttl_rslt(c_ext_rslt_id => l_ext_bdi_rslt_id);
1957: FETCH csr_get_ttl_rslt INTO l_get_ttl_rslt;

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

2126: ELSE
2127: l_per_end_date := fnd_date.canonical_to_date(l_eff_date_arg8);
2128: END IF;
2129: CLOSE csr_get_eff_date;
2130: hr_utility.set_location('l_per_end_date: '||l_per_end_date,64);
2131: ELSE
2132: l_Earning_Hist_Cnt := RPAD(' ',10,' ');
2133: l_Earning_Tot_Cnt := RPAD(' ',16,' ');
2134: END IF;

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

2189: IF csr_get_eff_date%NOTFOUND
2190: THEN
2191: l_per_end_date := sysdate;
2192: ELSE
2193: hr_utility.set_location('l_eff_date_arg8'|| l_eff_date_arg8,31);
2194: l_per_end_date := fnd_date.canonical_to_date(l_eff_date_arg8);
2195: END IF;
2196: CLOSE csr_get_eff_date;
2197: hr_utility.set_location('l_per_end_date: '||l_per_end_date,64);

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

2193: hr_utility.set_location('l_eff_date_arg8'|| l_eff_date_arg8,31);
2194: l_per_end_date := fnd_date.canonical_to_date(l_eff_date_arg8);
2195: END IF;
2196: CLOSE csr_get_eff_date;
2197: hr_utility.set_location('l_per_end_date: '||l_per_end_date,64);
2198: ELSE
2199: l_Pay_Hist_Cnt := RPAD(' ',10,' ');
2200: l_Pay_Tot_EARN_Cnt := RPAD(' ',16,' ');
2201: l_Pay_Tot_DEDS_Cnt := RPAD(' ',16,' ');

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

2524: END IF;
2525: END IF;
2526:
2527: ------------
2528: hr_utility.set_location('l_year_close1: ' || l_year_close , 11);
2529: hr_utility.set_location('p_year_end_close: ' || p_year_end_close , 11);
2530:
2531: /* For Nuvps */
2532: IF p_year_end_close = 'Yes'

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

2525: END IF;
2526:
2527: ------------
2528: hr_utility.set_location('l_year_close1: ' || l_year_close , 11);
2529: hr_utility.set_location('p_year_end_close: ' || p_year_end_close , 11);
2530:
2531: /* For Nuvps */
2532: IF p_year_end_close = 'Yes'
2533: THEN

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

2546:
2547: END IF;
2548:
2549: l_per_end_date := last_day(l_per_end_date);
2550: hr_utility.set_location('l_per_end_date: ' || l_per_end_date, 20);
2551: hr_utility.set_location('l_year_close6: ' || l_year_close , 11);
2552:
2553: l_Earning_Hist_Cnt := RPAD(' ',10,' ');
2554: l_Earning_Tot_Cnt := RPAD(' ',16,' ');

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

2547: END IF;
2548:
2549: l_per_end_date := last_day(l_per_end_date);
2550: hr_utility.set_location('l_per_end_date: ' || l_per_end_date, 20);
2551: hr_utility.set_location('l_year_close6: ' || l_year_close , 11);
2552:
2553: l_Earning_Hist_Cnt := RPAD(' ',10,' ');
2554: l_Earning_Tot_Cnt := RPAD(' ',16,' ');
2555:

Line 2863: IF SQLCODE <> hr_utility.hr_error_number

2859: RETURN l_employer_code;
2860:
2861: EXCEPTION
2862: WHEN others THEN
2863: IF SQLCODE <> hr_utility.hr_error_number
2864: THEN
2865: debug_others (l_proc_name, 10);
2866: IF g_debug
2867: THEN

Line 2933: IF SQLCODE <> hr_utility.hr_error_number

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

Line 2999: IF SQLCODE <> hr_utility.hr_error_number

2995: RETURN g_paypoint;
2996:
2997: EXCEPTION
2998: WHEN others THEN
2999: IF SQLCODE <> hr_utility.hr_error_number
3000: THEN
3001: debug_others (l_proc_name, 10);
3002: IF g_debug
3003: THEN

Line 3095: IF SQLCODE <> hr_utility.hr_error_number

3091: debug_exit(l_proc_name);
3092:
3093: EXCEPTION
3094: WHEN others THEN
3095: IF SQLCODE <> hr_utility.hr_error_number
3096: THEN
3097: debug_others (l_proc_name, 10);
3098: IF g_debug
3099: THEN

Line 3241: IF SQLCODE <> hr_utility.hr_error_number

3237: debug_exit(l_proc_name);
3238:
3239: EXCEPTION
3240: WHEN others THEN
3241: IF SQLCODE <> hr_utility.hr_error_number
3242: THEN
3243: debug_others (l_proc_name, 10);
3244: IF g_debug
3245: THEN

Line 3361: IF SQLCODE <> hr_utility.hr_error_number

3357: fnd_file.put_line(fnd_file.log, 'Done : ' || l_proc_name || ' : ' || get_time);
3358:
3359: EXCEPTION
3360: WHEN others THEN
3361: IF SQLCODE <> hr_utility.hr_error_number
3362: THEN
3363: debug_others (l_proc_name, 10);
3364: IF g_debug
3365: THEN

Line 3529: IF SQLCODE <> hr_utility.hr_error_number

3525: --
3526: RETURN l_return_value;
3527: EXCEPTION
3528: WHEN others THEN
3529: IF SQLCODE <> hr_utility.hr_error_number
3530: THEN
3531: debug_others (l_proc_name, 10);
3532: IF g_debug
3533: THEN

Line 3677: IF SQLCODE <> hr_utility.hr_error_number

3673:
3674: RETURN l_return_value;
3675: EXCEPTION
3676: WHEN others THEN
3677: IF SQLCODE <> hr_utility.hr_error_number
3678: THEN
3679: debug_others (l_proc_name, 10);
3680: IF g_debug
3681: THEN

Line 3813: IF SQLCODE <> hr_utility.hr_error_number

3809: debug_exit(l_proc_name);
3810:
3811: EXCEPTION
3812: WHEN others THEN
3813: IF SQLCODE <> hr_utility.hr_error_number
3814: THEN
3815: debug_others (l_proc_name, 10);
3816: IF g_debug
3817: THEN

Line 4022: IF SQLCODE <> hr_utility.hr_error_number

4018: debug_exit(l_proc_name);
4019:
4020: EXCEPTION
4021: WHEN others THEN
4022: IF SQLCODE <> hr_utility.hr_error_number
4023: THEN
4024: debug_others (l_proc_name, 10);
4025: IF g_debug
4026: THEN

Line 4159: IF SQLCODE <> hr_utility.hr_error_number

4155: debug_exit(l_proc_name);
4156:
4157: EXCEPTION
4158: WHEN others THEN
4159: IF SQLCODE <> hr_utility.hr_error_number
4160: THEN
4161: debug_others (l_proc_name, 10);
4162: IF g_debug
4163: THEN

Line 4272: IF SQLCODE <> hr_utility.hr_error_number

4268: return l_return;
4269:
4270: EXCEPTION
4271: WHEN others THEN
4272: IF SQLCODE <> hr_utility.hr_error_number
4273: THEN
4274: debug_others (l_proc_name, 10);
4275: IF g_debug
4276: THEN

Line 4405: IF SQLCODE <> hr_utility.hr_error_number

4401: return l_return;
4402:
4403: EXCEPTION
4404: WHEN others THEN
4405: IF SQLCODE <> hr_utility.hr_error_number
4406: THEN
4407: debug_others (l_proc_name, 10);
4408: IF g_debug
4409: THEN

Line 4765: IF SQLCODE <> hr_utility.hr_error_number

4761: return l_inclusion_flag;
4762:
4763: EXCEPTION
4764: WHEN others THEN
4765: IF SQLCODE <> hr_utility.hr_error_number
4766: THEN
4767: debug_others (l_proc_name, 10);
4768: IF g_debug
4769: THEN

Line 4985: IF SQLCODE <> hr_utility.hr_error_number

4981:
4982: RETURN l_run_date;
4983: EXCEPTION
4984: WHEN others THEN
4985: IF SQLCODE <> hr_utility.hr_error_number
4986: THEN
4987: debug_others (l_proc_name, l_proc_step);
4988: IF g_debug
4989: THEN

Line 5246: IF SQLCODE <> hr_utility.hr_error_number

5242:
5243: RETURN l_return;
5244: EXCEPTION
5245: WHEN others THEN
5246: IF SQLCODE <> hr_utility.hr_error_number
5247: THEN
5248: debug_others (l_proc_name, l_proc_step);
5249: IF g_debug
5250: THEN

Line 5343: IF SQLCODE <> hr_utility.hr_error_number

5339: END IF;
5340: EXCEPTION
5341: WHEN OTHERS
5342: THEN
5343: IF SQLCODE <> hr_utility.hr_error_number
5344: THEN
5345: debug_others(l_proc_name, l_proc_step);
5346:
5347: IF g_debug

Line 5500: IF SQLCODE <> hr_utility.hr_error_number

5496: debug_exit(l_proc);
5497: return l_leaver;
5498: EXCEPTION
5499: WHEN others THEN
5500: IF SQLCODE <> hr_utility.hr_error_number
5501: THEN
5502: debug_others (l_proc, 10);
5503: IF g_debug
5504: THEN

Line 5660: IF SQLCODE <> hr_utility.hr_error_number

5656: debug_exit(l_proc);
5657: RETURN l_return;
5658: EXCEPTION
5659: WHEN others THEN
5660: IF SQLCODE <> hr_utility.hr_error_number
5661: THEN
5662: debug_others (l_proc, 10);
5663: IF g_debug
5664: THEN

Line 5758: IF SQLCODE <> hr_utility.hr_error_number

5754: debug_exit(l_proc_name);
5755:
5756: EXCEPTION
5757: WHEN others THEN
5758: IF SQLCODE <> hr_utility.hr_error_number
5759: THEN
5760: debug_others (l_proc_name, 10);
5761: IF g_debug
5762: THEN

Line 5885: IF SQLCODE <> hr_utility.hr_error_number

5881:
5882: debug_exit(l_proc_name);
5883: EXCEPTION
5884: WHEN others THEN
5885: IF SQLCODE <> hr_utility.hr_error_number
5886: THEN
5887: debug_others (l_proc_name, 10);
5888: IF g_debug
5889: THEN

Line 6069: IF SQLCODE <> hr_utility.hr_error_number

6065: return l_run_result_value;
6066:
6067: EXCEPTION
6068: WHEN others THEN
6069: IF SQLCODE <> hr_utility.hr_error_number
6070: THEN
6071: debug_others (l_proc_name, 10);
6072: IF g_debug
6073: THEN

Line 6139: IF SQLCODE <> hr_utility.hr_error_number

6135: return l_payment;
6136:
6137: EXCEPTION
6138: WHEN others THEN
6139: IF SQLCODE <> hr_utility.hr_error_number
6140: THEN
6141: debug_others (l_proc_name, 10);
6142: IF g_debug
6143: THEN

Line 6228: IF SQLCODE <> hr_utility.hr_error_number

6224: return l_balance_value;
6225:
6226: EXCEPTION
6227: WHEN others THEN
6228: IF SQLCODE <> hr_utility.hr_error_number
6229: THEN
6230: debug_others (l_proc_name, 10);
6231: IF g_debug
6232: THEN

Line 6456: IF SQLCODE <> hr_utility.hr_error_number

6452: return l_balance_ele_value;
6453:
6454: EXCEPTION
6455: WHEN others THEN
6456: IF SQLCODE <> hr_utility.hr_error_number
6457: THEN
6458: debug_others (l_proc_name, 10);
6459: IF g_debug
6460: THEN

Line 6529: IF SQLCODE <> hr_utility.hr_error_number

6525: return l_payment;
6526:
6527: EXCEPTION
6528: WHEN others THEN
6529: IF SQLCODE <> hr_utility.hr_error_number
6530: THEN
6531: debug_others (l_proc_name, 10);
6532: IF g_debug
6533: THEN

Line 6614: IF SQLCODE <> hr_utility.hr_error_number

6610: RETURN p_output;
6611:
6612: EXCEPTION
6613: WHEN others THEN
6614: IF SQLCODE <> hr_utility.hr_error_number
6615: THEN
6616: debug_others (l_proc_name, 10);
6617: IF g_debug
6618: THEN

Line 6932: IF SQLCODE <> hr_utility.hr_error_number

6928: RETURN p_output;
6929:
6930: EXCEPTION
6931: WHEN others THEN
6932: IF SQLCODE <> hr_utility.hr_error_number
6933: THEN
6934: debug_others (l_proc_name, 10);
6935: IF g_debug
6936: THEN

Line 8347: IF SQLCODE <> hr_utility.hr_error_number

8343:
8344: p_rate := NVL(l_user_rate,0);
8345: EXCEPTION
8346: WHEN others THEN
8347: IF SQLCODE <> hr_utility.hr_error_number
8348: THEN
8349: debug_others (l_proc, 10);
8350: IF g_debug
8351: THEN