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

Line 5: g_debug BOOLEAN:= hr_utility.debug_enabled;

1: PACKAGE BODY pqp_gb_osp_functions AS
2: /* $Header: pqpospfn.pkb 120.30 2011/05/03 07:29:16 pprvenka noship $ */
3: --
4: g_package_name VARCHAR2(31) := 'pqp_gb_osp_functions.';
5: g_debug BOOLEAN:= hr_utility.debug_enabled;
6:
7:
8: g_udt_name VARCHAR2(80):=
9: pqp_schedule_calculation_pkg.g_udt_name;

Line 296: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

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

Line 400: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

396:
397: EXCEPTION
398: WHEN OTHERS THEN
399: clear_cache;
400: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
401: debug_others(l_proc_name,l_proc_step);
402: IF g_debug THEN
403: debug('Leaving: '||l_proc_name,-999);
404: END IF;

Line 495: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

491:
492: EXCEPTION
493: WHEN OTHERS THEN
494: clear_cache;
495: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
496: debug_others(l_proc_name,l_proc_step);
497: IF g_debug THEN
498: debug('Leaving: '||l_proc_name,-999);
499: END IF;

Line 568: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

564:
565: EXCEPTION
566: WHEN OTHERS THEN
567: clear_cache;
568: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
569: debug_others(l_proc_name,l_proc_step);
570: IF g_debug THEN
571: debug('Leaving: '||l_proc_name,-999);
572: END IF;

Line 677: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

673:
674: EXCEPTION
675: WHEN OTHERS THEN
676: clear_cache;
677: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
678: debug_others(l_proc_name,l_proc_step);
679: IF g_debug THEN
680: debug('Leaving: '||l_proc_name,-999);
681: END IF;

Line 751: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

747:
748: EXCEPTION
749: WHEN OTHERS THEN
750: clear_cache;
751: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
752: debug_others(l_proc_name,l_proc_step);
753: IF g_debug THEN
754: debug('Leaving: '||l_proc_name,-999);
755: END IF;

Line 860: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

856:
857: EXCEPTION
858: WHEN OTHERS THEN
859: clear_cache;
860: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
861: debug_others(l_proc_name,l_proc_step);
862: IF g_debug THEN
863: debug('Leaving: '||l_proc_name,-999);
864: END IF;

Line 946: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

942:
943: EXCEPTION
944: WHEN OTHERS THEN
945: clear_cache;
946: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
947: debug_others(l_proc_name,l_proc_step);
948: IF g_debug THEN
949: debug('Leaving: '||l_proc_name,-999);
950: END IF;

Line 1027: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

1023:
1024: EXCEPTION
1025: WHEN OTHERS THEN
1026: clear_cache;
1027: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
1028: debug_others(l_proc_name,l_proc_step);
1029: IF g_debug THEN
1030: debug('Leaving: '||l_proc_name,-999);
1031: END IF;

Line 1080: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

1076:
1077: EXCEPTION
1078: WHEN OTHERS THEN
1079: clear_cache;
1080: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
1081: debug_others(l_proc_name,l_proc_step);
1082: IF g_debug THEN
1083: debug('Leaving: '||l_proc_name,-999);
1084: END IF;

Line 1142: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

1138:
1139: EXCEPTION
1140: WHEN OTHERS THEN
1141: clear_cache;
1142: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
1143: debug_others(l_proc_name,l_proc_step);
1144: IF g_debug THEN
1145: debug('Leaving: '||l_proc_name,-999);
1146: END IF;

Line 1190: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

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

Line 1250: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

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

Line 1317: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

1313:
1314: EXCEPTION
1315: WHEN OTHERS THEN
1316: clear_cache;
1317: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
1318: debug_others(l_proc_name,l_proc_step);
1319: IF g_debug THEN
1320: debug('Leaving: '||l_proc_name,-999);
1321: END IF;

Line 1384: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

1380:
1381: EXCEPTION
1382: WHEN OTHERS THEN
1383: clear_cache;
1384: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
1385: debug_others(l_proc_name,l_proc_step);
1386: IF g_debug THEN
1387: debug('Leaving: '||l_proc_name,-999);
1388: END IF;

Line 1443: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

1439:
1440: EXCEPTION
1441: WHEN OTHERS THEN
1442: clear_cache;
1443: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
1444: debug_others(l_proc_name,l_proc_step);
1445: IF g_debug THEN
1446: debug('Leaving: '||l_proc_name,-999);
1447: END IF;

Line 1508: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

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

Line 1566: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

1562:
1563: EXCEPTION
1564: WHEN OTHERS THEN
1565: clear_cache;
1566: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
1567: debug_others(l_proc_name,l_proc_step);
1568: IF g_debug THEN
1569: debug('Leaving: '||l_proc_name,-999);
1570: END IF;

Line 1629: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

1625:
1626: EXCEPTION
1627: WHEN OTHERS THEN
1628: clear_cache;
1629: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
1630: debug_others(l_proc_name,l_proc_step);
1631: IF g_debug THEN
1632: debug('Leaving: '||l_proc_name,-999);
1633: END IF;

Line 1688: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

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

Line 1852: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

1848:
1849: EXCEPTION
1850: WHEN OTHERS THEN
1851: clear_cache;
1852: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
1853: debug_others(l_proc_name,l_proc_step);
1854: IF g_debug THEN
1855: debug('Leaving: '||l_proc_name,-999);
1856: END IF;

Line 1917: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

1913:
1914: EXCEPTION
1915: WHEN OTHERS THEN
1916: clear_cache;
1917: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
1918: debug_others(l_proc_name,l_proc_step);
1919: IF g_debug THEN
1920: debug('Leaving: '||l_proc_name,-999);
1921: END IF;

Line 1990: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

1986:
1987: EXCEPTION
1988: WHEN OTHERS THEN
1989: clear_cache;
1990: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
1991: debug_others(l_proc_name,l_proc_step);
1992: IF g_debug THEN
1993: debug('Leaving: '||l_proc_name,-999);
1994: END IF;

Line 2124: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

2120:
2121: EXCEPTION
2122: WHEN OTHERS THEN
2123: clear_cache;
2124: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
2125: debug_others(l_proc_name,l_proc_step);
2126: IF g_debug THEN
2127: debug('Leaving: '||l_proc_name,-999);
2128: END IF;

Line 2322: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

2318:
2319: EXCEPTION
2320: WHEN OTHERS THEN
2321: clear_cache;
2322: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
2323: debug_others(l_proc_name,l_proc_step);
2324: IF g_debug THEN
2325: debug('Leaving: '||l_proc_name,-999);
2326: END IF;

Line 2702: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

2698:
2699: EXCEPTION
2700: WHEN OTHERS THEN
2701: clear_cache;
2702: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
2703: debug_others(l_proc_name,l_proc_step);
2704: IF g_debug THEN
2705: debug('Leaving: '||l_proc_name,-999);
2706: END IF;

Line 2843: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

2839:
2840: EXCEPTION
2841: WHEN OTHERS THEN
2842: clear_cache;
2843: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
2844: debug_others(l_proc_name,l_proc_step);
2845: IF g_debug THEN
2846: debug('Leaving: '||l_proc_name,-999);
2847: END IF;

Line 2998: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

2994:
2995: EXCEPTION
2996: WHEN OTHERS THEN
2997: clear_cache;
2998: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
2999: debug_others(l_proc_name,l_proc_step);
3000: IF g_debug THEN
3001: debug('Leaving: '||l_proc_name,-999);
3002: END IF;

Line 3436: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

3432:
3433: EXCEPTION
3434: WHEN OTHERS THEN
3435: clear_cache;
3436: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
3437: debug_others(l_proc_name,l_proc_step);
3438: IF g_debug THEN
3439: debug('Leaving: '||l_proc_name,-999);
3440: END IF;

Line 3487: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

3483:
3484: EXCEPTION
3485: WHEN OTHERS THEN
3486: clear_cache;
3487: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
3488: debug_others(l_proc_name,l_proc_step);
3489: IF g_debug THEN
3490: debug('Leaving: '||l_proc_name,-999);
3491: END IF;

Line 3533: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

3529:
3530: EXCEPTION
3531: WHEN OTHERS THEN
3532: clear_cache;
3533: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
3534: debug_others(l_proc_name,l_proc_step);
3535: IF g_debug THEN
3536: debug('Leaving: '||l_proc_name,-999);
3537: END IF;

Line 3613: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

3609: RETURN NVL(l_count, 0);
3610: EXCEPTION
3611: WHEN OTHERS THEN
3612: clear_cache;
3613: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
3614: debug_others(l_proc_name,l_proc_step);
3615: IF g_debug THEN
3616: debug('Leaving: '||l_proc_name,-999);
3617: END IF;

Line 3656: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

3652: RETURN l_count;
3653: EXCEPTION
3654: WHEN OTHERS THEN
3655: clear_cache;
3656: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
3657: debug_others(l_proc_name,l_proc_step);
3658: IF g_debug THEN
3659: debug('Leaving: '||l_proc_name,-999);
3660: END IF;

Line 3726: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

3722:
3723: EXCEPTION
3724: WHEN OTHERS THEN
3725: clear_cache;
3726: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
3727: debug_others(l_proc_name,l_proc_step);
3728: IF g_debug THEN
3729: debug('Leaving: '||l_proc_name,-999);
3730: END IF;

Line 3800: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

3796:
3797: EXCEPTION
3798: WHEN OTHERS THEN
3799: clear_cache;
3800: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
3801: debug_others(l_proc_name,l_proc_step);
3802: IF g_debug THEN
3803: debug('Leaving: '||l_proc_name,-999);
3804: END IF;

Line 3877: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

3873: RETURN l_count;
3874: EXCEPTION
3875: WHEN OTHERS THEN
3876: clear_cache;
3877: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
3878: debug_others(l_proc_name,l_proc_step);
3879: IF g_debug THEN
3880: debug('Leaving: '||l_proc_name,-999);
3881: END IF;

Line 3964: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

3960:
3961: EXCEPTION
3962: WHEN OTHERS THEN
3963: clear_cache;
3964: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
3965: debug_others(l_proc_name,l_proc_step);
3966: IF g_debug THEN
3967: debug('Leaving: '||l_proc_name,-999);
3968: END IF;

Line 4049: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

4045:
4046: EXCEPTION
4047: WHEN OTHERS THEN
4048: clear_cache;
4049: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
4050: debug_others(l_proc_name,l_proc_step);
4051: IF g_debug THEN
4052: debug('Leaving: '||l_proc_name,-999);
4053: END IF;

Line 4212: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

4208:
4209: EXCEPTION
4210: WHEN OTHERS THEN
4211: clear_cache;
4212: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
4213: debug_others(l_proc_name,l_proc_step);
4214: IF g_debug THEN
4215: debug('Leaving: '||l_proc_name,-999);
4216: END IF;

Line 4349: -- IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

4345: --
4346: -- EXCEPTION
4347: -- WHEN OTHERS THEN
4348: -- clear_cache;
4349: -- IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
4350: -- debug_others(l_proc_name,l_proc_step);
4351: -- IF g_debug THEN
4352: -- debug('Leaving: '||l_proc_name,-999);
4353: -- END IF;

Line 4523: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

4519:
4520: EXCEPTION
4521: WHEN OTHERS THEN
4522: clear_cache;
4523: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
4524: debug_others(l_proc_name,l_proc_step);
4525: IF g_debug THEN
4526: debug('Leaving: '||l_proc_name,-999);
4527: END IF;

Line 4745: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

4741:
4742: EXCEPTION
4743: WHEN OTHERS THEN
4744: clear_cache;
4745: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
4746: debug_others(l_proc_name,l_proc_step);
4747: IF g_debug THEN
4748: debug('Leaving: '||l_proc_name,-999);
4749: END IF;

Line 4796: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

4792:
4793: EXCEPTION
4794: WHEN OTHERS THEN
4795: clear_cache;
4796: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
4797: debug_others(l_proc_name,l_proc_step);
4798: IF g_debug THEN
4799: debug('Leaving: '||l_proc_name,-999);
4800: END IF;

Line 4854: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

4850:
4851: EXCEPTION
4852: WHEN OTHERS THEN
4853: clear_cache;
4854: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
4855: debug_others(l_proc_name,l_proc_step);
4856: IF g_debug THEN
4857: debug('Leaving: '||l_proc_name,-999);
4858: END IF;

Line 4929: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

4925:
4926: EXCEPTION
4927: WHEN OTHERS THEN
4928: clear_cache;
4929: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
4930: debug_others(l_proc_name,l_proc_step);
4931: IF g_debug THEN
4932: debug('Leaving: '||l_proc_name,-999);
4933: END IF;

Line 4999: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

4995:
4996: EXCEPTION
4997: WHEN OTHERS THEN
4998: clear_cache;
4999: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
5000: debug_others(l_proc_name,l_proc_step);
5001: IF g_debug THEN
5002: debug('Leaving: '||l_proc_name,-999);
5003: END IF;

Line 5085: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

5081:
5082: EXCEPTION
5083: WHEN OTHERS THEN
5084: clear_cache;
5085: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
5086: debug_others(l_proc_name,l_proc_step);
5087: IF g_debug THEN
5088: debug('Leaving: '||l_proc_name,-999);
5089: END IF;

Line 5163: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

5159:
5160: EXCEPTION
5161: WHEN OTHERS THEN
5162: clear_cache;
5163: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
5164: debug_others(l_proc_name,l_proc_step);
5165: IF g_debug THEN
5166: debug('Leaving: '||l_proc_name,-999);
5167: END IF;

Line 5237: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

5233:
5234: EXCEPTION
5235: WHEN OTHERS THEN
5236: clear_cache;
5237: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
5238: debug_others(l_proc_name,l_proc_step);
5239: IF g_debug THEN
5240: debug('Leaving: '||l_proc_name,-999);
5241: END IF;

Line 5424: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

5420:
5421: EXCEPTION
5422: WHEN OTHERS THEN
5423: clear_cache;
5424: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
5425: debug_others(l_proc_name,l_proc_step);
5426: IF g_debug THEN
5427: debug('Leaving: '||l_proc_name,-999);
5428: END IF;

Line 5496: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

5492:
5493: EXCEPTION
5494: WHEN OTHERS THEN
5495: clear_cache;
5496: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
5497: debug_others(l_proc_name,l_proc_step);
5498: IF g_debug THEN
5499: debug('Leaving: '||l_proc_name,-999);
5500: END IF;

Line 5573: g_debug := hr_utility.debug_enabled;

5569:
5570: BEGIN
5571:
5572:
5573: g_debug := hr_utility.debug_enabled;
5574:
5575: IF p_absence_start_date IS NULL
5576: THEN
5577: l_absence_start_date := p_effective_date;

Line 5910: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

5906:
5907: EXCEPTION
5908: WHEN OTHERS THEN
5909: clear_cache;
5910: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
5911: debug_others(l_proc_name,l_proc_step);
5912: IF g_debug THEN
5913: debug('Leaving: '||l_proc_name,-999);
5914: END IF;

Line 6060: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

6056:
6057: EXCEPTION
6058: WHEN OTHERS THEN
6059: clear_cache;
6060: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
6061: debug_others(l_proc_name,l_proc_step);
6062: IF g_debug THEN
6063: debug('Leaving: '||l_proc_name,-999);
6064: END IF;

Line 6203: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

6199:
6200: EXCEPTION
6201: WHEN OTHERS THEN
6202: clear_cache;
6203: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
6204: debug_others(l_proc_name,l_proc_step);
6205: IF g_debug THEN
6206: debug('Leaving: '||l_proc_name,-999);
6207: END IF;

Line 6273: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

6269:
6270: EXCEPTION
6271: WHEN OTHERS THEN
6272: clear_cache;
6273: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
6274: debug_others(l_proc_name,l_proc_step);
6275: IF g_debug THEN
6276: debug('Leaving: '||l_proc_name,-999);
6277: END IF;

Line 6334: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

6330:
6331: EXCEPTION
6332: WHEN OTHERS THEN
6333: clear_cache;
6334: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
6335: debug_others(l_proc_name,l_proc_step);
6336: IF g_debug THEN
6337: debug('Leaving: '||l_proc_name,-999);
6338: END IF;

Line 6395: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

6391:
6392: EXCEPTION
6393: WHEN OTHERS THEN
6394: clear_cache;
6395: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
6396: debug_others(l_proc_name,l_proc_step);
6397: IF g_debug THEN
6398: debug('Leaving: '||l_proc_name,-999);
6399: END IF;

Line 6444: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

6440: RETURN(l_balance);
6441: EXCEPTION
6442: WHEN OTHERS THEN
6443: clear_cache;
6444: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
6445: debug_others(l_proc_name,l_proc_step);
6446: IF g_debug THEN
6447: debug('Leaving: '||l_proc_name,-999);
6448: END IF;

Line 6475: hr_utility.set_location(l_proc_name,44333);

6471: l_subpriority NUMBER;
6472: BEGIN
6473: /*
6474: l_proc_step := 1;
6475: hr_utility.set_location(l_proc_name,44333);
6476: l_proc_step := 2;
6477: hr_utility.set_location(' Absence Start Date: ' || to_char(p_absence_start_date),44333);
6478: l_proc_step := 3;
6479: hr_utility.set_location('p_business_group_id:'||p_business_group_id,44333);

Line 6477: hr_utility.set_location(' Absence Start Date: ' || to_char(p_absence_start_date),44333);

6473: /*
6474: l_proc_step := 1;
6475: hr_utility.set_location(l_proc_name,44333);
6476: l_proc_step := 2;
6477: hr_utility.set_location(' Absence Start Date: ' || to_char(p_absence_start_date),44333);
6478: l_proc_step := 3;
6479: hr_utility.set_location('p_business_group_id:'||p_business_group_id,44333);
6480: l_proc_step := 4;
6481: hr_utility.set_location('p_assignment_id:'||p_assignment_id,44333);

Line 6479: hr_utility.set_location('p_business_group_id:'||p_business_group_id,44333);

6475: hr_utility.set_location(l_proc_name,44333);
6476: l_proc_step := 2;
6477: hr_utility.set_location(' Absence Start Date: ' || to_char(p_absence_start_date),44333);
6478: l_proc_step := 3;
6479: hr_utility.set_location('p_business_group_id:'||p_business_group_id,44333);
6480: l_proc_step := 4;
6481: hr_utility.set_location('p_assignment_id:'||p_assignment_id,44333);
6482: l_proc_step := 5;
6483: hr_utility.set_location('p_payroll_action_id:'||p_payroll_action_id,44333);

Line 6481: hr_utility.set_location('p_assignment_id:'||p_assignment_id,44333);

6477: hr_utility.set_location(' Absence Start Date: ' || to_char(p_absence_start_date),44333);
6478: l_proc_step := 3;
6479: hr_utility.set_location('p_business_group_id:'||p_business_group_id,44333);
6480: l_proc_step := 4;
6481: hr_utility.set_location('p_assignment_id:'||p_assignment_id,44333);
6482: l_proc_step := 5;
6483: hr_utility.set_location('p_payroll_action_id:'||p_payroll_action_id,44333);
6484: l_proc_step := 6;
6485: hr_utility.set_location('p_pl_id:'||p_pl_id,44333);

Line 6483: hr_utility.set_location('p_payroll_action_id:'||p_payroll_action_id,44333);

6479: hr_utility.set_location('p_business_group_id:'||p_business_group_id,44333);
6480: l_proc_step := 4;
6481: hr_utility.set_location('p_assignment_id:'||p_assignment_id,44333);
6482: l_proc_step := 5;
6483: hr_utility.set_location('p_payroll_action_id:'||p_payroll_action_id,44333);
6484: l_proc_step := 6;
6485: hr_utility.set_location('p_pl_id:'||p_pl_id,44333);
6486: l_proc_step := 7;
6487: hr_utility.set_location('p_ler_id:'||p_ler_id,44333);

Line 6485: hr_utility.set_location('p_pl_id:'||p_pl_id,44333);

6481: hr_utility.set_location('p_assignment_id:'||p_assignment_id,44333);
6482: l_proc_step := 5;
6483: hr_utility.set_location('p_payroll_action_id:'||p_payroll_action_id,44333);
6484: l_proc_step := 6;
6485: hr_utility.set_location('p_pl_id:'||p_pl_id,44333);
6486: l_proc_step := 7;
6487: hr_utility.set_location('p_ler_id:'||p_ler_id,44333);
6488: l_proc_step := 8;
6489:

Line 6487: hr_utility.set_location('p_ler_id:'||p_ler_id,44333);

6483: hr_utility.set_location('p_payroll_action_id:'||p_payroll_action_id,44333);
6484: l_proc_step := 6;
6485: hr_utility.set_location('p_pl_id:'||p_pl_id,44333);
6486: l_proc_step := 7;
6487: hr_utility.set_location('p_ler_id:'||p_ler_id,44333);
6488: l_proc_step := 8;
6489:
6490: -- In future the sub priority Calculation may be changed to consider element priorities
6491: -- like Primary element or Secondary element. For this element Type Id can be derived from

Line 6513: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

6509:
6510: EXCEPTION
6511: WHEN OTHERS THEN
6512: clear_cache;
6513: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
6514: debug_others(l_proc_name,l_proc_step);
6515: IF g_debug THEN
6516: debug('Leaving: '||l_proc_name,-999);
6517: END IF;

Line 6595: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

6591: RETURN(l_curr_date);
6592: EXCEPTION
6593: WHEN OTHERS THEN
6594: clear_cache;
6595: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
6596: debug_others(l_proc_name,l_proc_step);
6597: IF g_debug THEN
6598: debug('Leaving: '||l_proc_name,-999);
6599: END IF;

Line 6670: hr_utility.set_message(800, 'HR_289296_SEC_PROF_SETUP_ERR');

6666: CLOSE csr_get_security_group;
6667:
6668: IF l_security_group_id IS NULL
6669: THEN
6670: hr_utility.set_message(800, 'HR_289296_SEC_PROF_SETUP_ERR');
6671: hr_utility.raise_error;
6672: END IF;
6673:
6674: -- Check whether the lookup code exists

Line 6671: hr_utility.raise_error;

6667:
6668: IF l_security_group_id IS NULL
6669: THEN
6670: hr_utility.set_message(800, 'HR_289296_SEC_PROF_SETUP_ERR');
6671: hr_utility.raise_error;
6672: END IF;
6673:
6674: -- Check whether the lookup code exists
6675: -- for the user security group id

Line 6705: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

6701: --
6702: EXCEPTION
6703: WHEN OTHERS THEN
6704: clear_cache;
6705: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
6706: debug_others(l_proc_name,l_proc_step);
6707: IF g_debug THEN
6708: debug('Leaving: '||l_proc_name,-999);
6709: END IF;

Line 6837: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

6833:
6834: EXCEPTION
6835: WHEN OTHERS THEN
6836: clear_cache;
6837: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
6838: debug_others(l_proc_name,l_proc_step);
6839: IF g_debug THEN
6840: debug('Leaving: '||l_proc_name,-999);
6841: END IF;

Line 6912: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

6908: RETURN l_retval;
6909: EXCEPTION
6910: WHEN OTHERS THEN
6911: clear_cache;
6912: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
6913: debug_others(l_proc_name,l_proc_step);
6914: IF g_debug THEN
6915: debug('Leaving: '||l_proc_name,-999);
6916: END IF;

Line 7003: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

6999:
7000: EXCEPTION
7001: WHEN OTHERS THEN
7002: clear_cache;
7003: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
7004: debug_others(l_proc_name,l_proc_step);
7005: IF g_debug THEN
7006: debug('Leaving: '||l_proc_name,-999);
7007: END IF;

Line 7075: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

7071:
7072: EXCEPTION
7073: WHEN OTHERS THEN
7074: clear_cache;
7075: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
7076: debug_others(l_proc_name,l_proc_step);
7077: IF g_debug THEN
7078: debug('Leaving: '||l_proc_name,-999);
7079: END IF;

Line 7142: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

7138:
7139: EXCEPTION
7140: WHEN OTHERS THEN
7141: clear_cache;
7142: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
7143: debug_others(l_proc_name,l_proc_step);
7144: IF g_debug THEN
7145: debug('Leaving: '||l_proc_name,-999);
7146: END IF;

Line 7264: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

7260:
7261: EXCEPTION
7262: WHEN OTHERS THEN
7263: clear_cache;
7264: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
7265: debug_others(l_proc_name,l_proc_step);
7266: IF g_debug THEN
7267: debug('Leaving: '||l_proc_name,-999);
7268: END IF;

Line 7390: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

7386:
7387: EXCEPTION
7388: WHEN OTHERS THEN
7389: clear_cache;
7390: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
7391: debug_others(l_proc_name,l_proc_step);
7392: IF g_debug THEN
7393: debug('Leaving: '||l_proc_name,-999);
7394: END IF;

Line 7510: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

7506:
7507: EXCEPTION
7508: WHEN OTHERS THEN
7509: clear_cache;
7510: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
7511: debug_others(l_proc_name,l_proc_step);
7512: IF g_debug THEN
7513: debug('Leaving: '||l_proc_name,-999);
7514: END IF;

Line 7598: g_debug := hr_utility.debug_enabled;

7594:
7595: l_boundary_date DATE;
7596:
7597: BEGIN
7598: g_debug := hr_utility.debug_enabled;
7599:
7600: IF g_debug then
7601: debug('p_absence_attendance_id:'||p_absence_attendance_id);
7602: debug('p_pl_id:'||p_pl_id);

Line 7696: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

7692:
7693: EXCEPTION
7694: WHEN OTHERS THEN
7695: clear_cache;
7696: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
7697: debug_others(l_proc_name,l_proc_step);
7698: IF g_debug THEN
7699: debug('Leaving: '||l_proc_name,-999);
7700: END IF;

Line 7725: g_debug := hr_utility.debug_enabled;

7721:
7722: l_boundary_date DATE;
7723:
7724: BEGIN
7725: g_debug := hr_utility.debug_enabled;
7726:
7727: IF g_debug THEN
7728: debug_enter(l_proc_name);
7729: debug('p_absence_attendance_id:'||p_absence_attendance_id);

Line 7752: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

7748:
7749: EXCEPTION
7750: WHEN OTHERS THEN
7751: clear_cache;
7752: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
7753: debug_others(l_proc_name,l_proc_step);
7754: IF g_debug THEN
7755: debug('Leaving: '||l_proc_name,-999);
7756: END IF;

Line 7781: g_debug := hr_utility.debug_enabled;

7777:
7778: l_boundary_date DATE;
7779:
7780: BEGIN
7781: g_debug := hr_utility.debug_enabled;
7782: IF g_debug THEN
7783: debug_enter(l_proc_name);
7784: debug('p_absence_attendance_id:'||p_absence_attendance_id);
7785: debug('p_pl_id:'||p_pl_id);

Line 7810: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

7806:
7807: EXCEPTION
7808: WHEN OTHERS THEN
7809: clear_cache;
7810: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
7811: debug_others(l_proc_name,l_proc_step);
7812: IF g_debug THEN
7813: debug('Leaving: '||l_proc_name,-999);
7814: END IF;

Line 7839: g_debug := hr_utility.debug_enabled;

7835:
7836: l_boundary_date DATE;
7837:
7838: BEGIN
7839: g_debug := hr_utility.debug_enabled;
7840: IF g_debug THEN
7841: debug_enter(l_proc_name);
7842: debug('p_absence_attendance_id:'||p_absence_attendance_id);
7843: debug('p_pl_id:'||p_pl_id);

Line 7869: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

7865:
7866: EXCEPTION
7867: WHEN OTHERS THEN
7868: clear_cache;
7869: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
7870: debug_others(l_proc_name,l_proc_step);
7871: IF g_debug THEN
7872: debug('Leaving: '||l_proc_name,-999);
7873: END IF;

Line 7898: g_debug := hr_utility.debug_enabled;

7894:
7895: l_boundary_date DATE;
7896:
7897: BEGIN
7898: g_debug := hr_utility.debug_enabled;
7899: IF g_debug THEN
7900: debug_enter(l_proc_name);
7901: debug('p_absence_attendance_id:'||p_absence_attendance_id);
7902: debug('p_pl_id:'||p_pl_id);

Line 7928: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

7924:
7925: EXCEPTION
7926: WHEN OTHERS THEN
7927: clear_cache;
7928: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
7929: debug_others(l_proc_name,l_proc_step);
7930: IF g_debug THEN
7931: debug('Leaving: '||l_proc_name,-999);
7932: END IF;

Line 8001: IF hr_utility.chk_product_install('Oracle Human Resources', 'GB') THEN

7997: BEGIN
7998: --
7999: -- Added for GSI Bug 5472781
8000: --
8001: IF hr_utility.chk_product_install('Oracle Human Resources', 'GB') THEN
8002: --
8003: g_debug := hr_utility.debug_enabled;
8004:
8005: IF g_debug THEN

Line 8003: g_debug := hr_utility.debug_enabled;

7999: -- Added for GSI Bug 5472781
8000: --
8001: IF hr_utility.chk_product_install('Oracle Human Resources', 'GB') THEN
8002: --
8003: g_debug := hr_utility.debug_enabled;
8004:
8005: IF g_debug THEN
8006: debug_enter(l_proc_name);
8007: debug('p_person_extra_info_id:'||p_person_extra_info_id);

Line 8281: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

8277:
8278: EXCEPTION
8279: WHEN OTHERS THEN
8280: clear_cache;
8281: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
8282: debug_others(l_proc_name,l_proc_step);
8283: IF g_debug THEN
8284: debug('Leaving: '||l_proc_name,-999);
8285: END IF;

Line 8561: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

8557:
8558: EXCEPTION
8559: WHEN OTHERS THEN
8560: clear_cache;
8561: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
8562: debug_others(l_proc_name,l_proc_step);
8563: IF g_debug THEN
8564: debug('Leaving: '||l_proc_name,-999);
8565: END IF;

Line 8709: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

8705:
8706: EXCEPTION
8707: WHEN OTHERS THEN
8708: clear_cache;
8709: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
8710: debug_others(l_proc_name,l_proc_step);
8711: IF g_debug THEN
8712: debug('Leaving: '||l_proc_name,-999);
8713: END IF;

Line 9324: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

9320:
9321: EXCEPTION
9322: WHEN OTHERS THEN
9323: clear_cache;
9324: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
9325: debug_others(l_proc_name,l_proc_step);
9326: IF g_debug THEN
9327: debug('Leaving: '||l_proc_name,-999);
9328: END IF;

Line 9355: g_debug := hr_utility.debug_enabled;

9351: g_package_name||'get_absence_ssp';
9352:
9353: BEGIN
9354:
9355: g_debug := hr_utility.debug_enabled;
9356:
9357: IF g_debug THEN
9358: debug_enter(l_proc_name);
9359: debug('p_absence_attendance_id:'||p_absence_attendance_id);

Line 9389: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

9385:
9386: EXCEPTION
9387: WHEN OTHERS THEN
9388: clear_cache;
9389: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
9390: debug_others(l_proc_name,l_proc_step);
9391: IF g_debug THEN
9392: debug('Leaving: '||l_proc_name,-999);
9393: END IF;

Line 9511: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

9507:
9508: EXCEPTION
9509: WHEN OTHERS THEN
9510: clear_cache;
9511: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
9512: debug_others(l_proc_name,l_proc_step);
9513: IF g_debug THEN
9514: debug('Leaving: '||l_proc_name,-999);
9515: END IF;

Line 10118: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

10114:
10115: EXCEPTION
10116: WHEN OTHERS THEN
10117: clear_cache;
10118: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
10119: debug_others(l_proc_name,l_proc_step);
10120: IF g_debug THEN
10121: debug('Leaving: '||l_proc_name,-999);
10122: END IF;

Line 10149: g_debug := hr_utility.debug_enabled;

10145: g_package_name||'get_absence_smp';
10146:
10147: BEGIN
10148:
10149: g_debug := hr_utility.debug_enabled;
10150:
10151: IF g_debug THEN
10152: debug_enter(l_proc_name);
10153: debug('p_absence_attendance_id:'||p_absence_attendance_id);

Line 10184: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

10180:
10181: EXCEPTION
10182: WHEN OTHERS THEN
10183: clear_cache;
10184: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
10185: debug_others(l_proc_name,l_proc_step);
10186: IF g_debug THEN
10187: debug('Leaving: '||l_proc_name,-999);
10188: END IF;

Line 10236: g_debug := hr_utility.debug_enabled;

10232: l_error_msg fnd_new_messages.message_text%TYPE;
10233:
10234: BEGIN
10235:
10236: g_debug := hr_utility.debug_enabled;
10237: IF g_debug THEN
10238: debug_enter(l_proc_name);
10239: END IF;
10240:

Line 10307: --IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

10303: p_error_msg := SQLERRM;
10304: p_error_code := SQLCODE;
10305: l_error_code := -1;
10306: clear_cache;
10307: --IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
10308: debug_others(l_proc_name,l_proc_step);
10309: IF g_debug THEN
10310: debug('Leaving: '||l_proc_name,-999);
10311: END IF;

Line 10423: --IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

10419: p_error_msg := SQLERRM;
10420: p_error_code := SQLCODE;
10421: l_error_code := -1;
10422: clear_cache;
10423: --IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
10424: debug_others(l_proc_name,l_proc_step);
10425: IF g_debug THEN
10426: debug('Leaving: '||l_proc_name,-999);
10427: END IF;

Line 10622: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

10618:
10619: EXCEPTION
10620: WHEN OTHERS THEN
10621: clear_cache;
10622: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
10623: debug_others(l_proc_name,l_proc_step);
10624: IF g_debug THEN
10625: debug('Leaving: '||l_proc_name,-999);
10626: END IF;

Line 10762: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

10758:
10759: EXCEPTION
10760: WHEN OTHERS THEN
10761: clear_cache;
10762: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
10763: debug_others(l_proc_name,l_proc_step);
10764: IF g_debug THEN
10765: debug('Leaving: '||l_proc_name,-999);
10766: END IF;

Line 10909: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

10905: debug_exit(l_proc_name);
10906:
10907: EXCEPTION
10908: WHEN OTHERS THEN
10909: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
10910: debug_others(l_proc_name,l_proc_step);
10911: IF g_debug THEN
10912: debug('Leaving: '||l_proc_name,-999);
10913: END IF;

Line 10991: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

10987: RETURN NVL(l_minpay_rate,0) ;
10988: EXCEPTION
10989: WHEN OTHERS THEN
10990: clear_cache;
10991: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
10992: debug_others(l_proc_name,l_proc_step);
10993: IF g_debug THEN
10994: debug('Leaving: '||l_proc_name,-999);
10995: END IF;

Line 11052: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

11048:
11049: EXCEPTION
11050: WHEN OTHERS THEN
11051: clear_cache;
11052: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
11053: debug_others(l_proc_name,l_proc_step);
11054: IF g_debug THEN
11055: debug('Leaving: '||l_proc_name,-999);
11056: END IF;

Line 11092: g_debug := hr_utility.debug_enabled;

11088: --3)Passes on the values to the out parameters.
11089: --4)Added for precaution...get the entitlement proration
11090: -- if it is Y and No rounding values is provided then
11091: -- by default round it to max precision..5 decimal places
11092: g_debug := hr_utility.debug_enabled;
11093: IF g_debug THEN
11094: debug_enter(l_proc_name);
11095: debug('p_pl_id:'||p_pl_id);
11096: END IF;

Line 11209: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

11205: END IF;
11206:
11207: EXCEPTION
11208: WHEN OTHERS THEN
11209: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
11210: pqp_utilities.debug_others
11211: (l_proc_name
11212: ,l_proc_step
11213: );

Line 11310: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

11306:
11307: EXCEPTION
11308: WHEN OTHERS THEN
11309: clear_cache;
11310: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
11311: debug_others(l_proc_name,l_proc_step);
11312: IF g_debug THEN
11313: debug('Leaving: '||l_proc_name,-999);
11314: END IF;

Line 11446: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

11442:
11443: EXCEPTION
11444: WHEN OTHERS THEN
11445: clear_cache;
11446: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
11447: debug_others(l_proc_name,l_proc_step);
11448: IF g_debug THEN
11449: debug('Leaving: '||l_proc_name,-999);
11450: END IF;

Line 11475: g_debug := hr_utility.debug_enabled;

11471: l_proc_step NUMBER;
11472:
11473: BEGIN
11474:
11475: g_debug := hr_utility.debug_enabled;
11476: l_proc_step := 10;
11477: IF g_debug THEN
11478: debug_enter(l_proc_name);
11479: debug(l_proc_name,l_proc_step);

Line 11541: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

11537:
11538: EXCEPTION
11539: WHEN OTHERS THEN
11540: clear_cache;
11541: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
11542: debug_others(l_proc_name,l_proc_step);
11543: IF g_debug THEN
11544: debug('Leaving: '||l_proc_name,-999);
11545: END IF;

Line 11610: --hr_utility.trace_on(null,'rvishwan');

11606:
11607:
11608: BEGIN
11609:
11610: --hr_utility.trace_on(null,'rvishwan');
11611: IF g_debug THEN
11612: debug_enter(l_proc_name);
11613: debug(l_proc_name,10);
11614: debug('p_business_group_id:'||p_business_group_id);

Line 11883: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

11879:
11880: EXCEPTION
11881: WHEN OTHERS THEN
11882: clear_cache;
11883: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
11884: debug_others(l_proc_name,l_proc_step);
11885: IF g_debug THEN
11886: debug('Leaving: '||l_proc_name,-999);
11887: END IF;

Line 11924: g_debug := hr_utility.debug_enabled;

11920:
11921: BEGIN
11922:
11923:
11924: g_debug := hr_utility.debug_enabled;
11925:
11926: IF g_debug THEN
11927: debug_enter(l_proc_name);
11928: debug(l_proc_name,10);

Line 11995: hr_utility.set_message(8303,'PQP_230462_ABS_PENSION_DATE');

11991:
11992: IF (l_pension_end_dt IS NOT NULL OR l_pension_st_dt IS NOT NULL) AND
11993: (l_pension_end_dt IS NULL OR l_pension_st_dt IS NULL)
11994: THEN
11995: hr_utility.set_message(8303,'PQP_230462_ABS_PENSION_DATE');
11996: hr_utility.raise_error;
11997: END IF;
11998:
11999: IF g_debug THEN

Line 11996: hr_utility.raise_error;

11992: IF (l_pension_end_dt IS NOT NULL OR l_pension_st_dt IS NOT NULL) AND
11993: (l_pension_end_dt IS NULL OR l_pension_st_dt IS NULL)
11994: THEN
11995: hr_utility.set_message(8303,'PQP_230462_ABS_PENSION_DATE');
11996: hr_utility.raise_error;
11997: END IF;
11998:
11999: IF g_debug THEN
12000: debug(l_proc_name,45);

Line 12012: hr_utility.set_message(8303,'PQP_230462_ABS_PENSION_DATE');

12008: END IF;
12009:
12010: IF (l_pension_end_dt NOT BETWEEN p_date_start AND l_date_end)
12011: THEN
12012: hr_utility.set_message(8303,'PQP_230462_ABS_PENSION_DATE');
12013: hr_utility.raise_error;
12014:
12015: IF g_debug THEN
12016: debug(l_proc_name,60);

Line 12013: hr_utility.raise_error;

12009:
12010: IF (l_pension_end_dt NOT BETWEEN p_date_start AND l_date_end)
12011: THEN
12012: hr_utility.set_message(8303,'PQP_230462_ABS_PENSION_DATE');
12013: hr_utility.raise_error;
12014:
12015: IF g_debug THEN
12016: debug(l_proc_name,60);
12017: debug('l_is_check_true'||l_is_check_true);

Line 12030: hr_utility.set_message(8303,'PQP_230462_ABS_PENSION_DATE');

12026:
12027: IF l_pension_st_dt IS NOT NULL
12028: AND(l_pension_st_dt NOT BETWEEN p_date_start AND l_date_end)
12029: THEN
12030: hr_utility.set_message(8303,'PQP_230462_ABS_PENSION_DATE');
12031: hr_utility.raise_error;
12032: IF g_debug THEN
12033: debug(l_proc_name,70);
12034: debug('l_is_check_true'||l_is_check_true);

Line 12031: hr_utility.raise_error;

12027: IF l_pension_st_dt IS NOT NULL
12028: AND(l_pension_st_dt NOT BETWEEN p_date_start AND l_date_end)
12029: THEN
12030: hr_utility.set_message(8303,'PQP_230462_ABS_PENSION_DATE');
12031: hr_utility.raise_error;
12032: IF g_debug THEN
12033: debug(l_proc_name,70);
12034: debug('l_is_check_true'||l_is_check_true);
12035: END IF;

Line 12044: hr_utility.set_message(8303,'PQP_230463_ABS_PENSION_RATE');

12040: END IF;
12041:
12042: IF l_pension_st_dt IS NOT NULL AND l_pension_end_dt IS NOT NULL THEN
12043: IF l_pension_st_dt > l_pension_end_dt THEN
12044: hr_utility.set_message(8303,'PQP_230463_ABS_PENSION_RATE');
12045: hr_utility.raise_error;
12046: END IF;
12047: END IF;
12048:

Line 12045: hr_utility.raise_error;

12041:
12042: IF l_pension_st_dt IS NOT NULL AND l_pension_end_dt IS NOT NULL THEN
12043: IF l_pension_st_dt > l_pension_end_dt THEN
12044: hr_utility.set_message(8303,'PQP_230463_ABS_PENSION_RATE');
12045: hr_utility.raise_error;
12046: END IF;
12047: END IF;
12048:
12049: IF g_debug THEN

Line 12059: hr_utility.set_message(8303,'PQP_230463_ABS_PENSION_RATE');

12055: ( l_pension_rt IS NULL AND(( l_pension_st_dt IS NOT NULL OR l_pension_end_dt is NOT NULL ) ) )
12056: )
12057:
12058: THEN
12059: hr_utility.set_message(8303,'PQP_230463_ABS_PENSION_RATE');
12060: hr_utility.raise_error;
12061: END IF;
12062:
12063: IF g_debug THEN

Line 12060: hr_utility.raise_error;

12056: )
12057:
12058: THEN
12059: hr_utility.set_message(8303,'PQP_230463_ABS_PENSION_RATE');
12060: hr_utility.raise_error;
12061: END IF;
12062:
12063: IF g_debug THEN
12064: debug(l_proc_name,85);

Line 12075: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

12071:
12072: EXCEPTION
12073: WHEN OTHERS THEN
12074:
12075: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
12076: IF g_debug THEN
12077: debug('Leaving: '||l_proc_name,-999);
12078: END IF;
12079: hr_utility.raise_error;

Line 12079: hr_utility.raise_error;

12075: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
12076: IF g_debug THEN
12077: debug('Leaving: '||l_proc_name,-999);
12078: END IF;
12079: hr_utility.raise_error;
12080: ELSE
12081: RAISE;
12082: END IF;
12083:

Line 12110: IF hr_utility.chk_product_install('Oracle Human Resources', 'GB') THEN

12106: BEGIN
12107: --
12108: -- Added for GSI Bug 5472781
12109: --
12110: IF hr_utility.chk_product_install('Oracle Human Resources', 'GB') THEN
12111: --
12112: IF g_debug THEN
12113: debug_enter(l_proc_name);
12114: END IF;

Line 12122: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

12118: EXCEPTION
12119: WHEN OTHERS THEN
12120:
12121:
12122: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
12123: IF g_debug THEN
12124: debug('Leaving: '||l_proc_name,-999);
12125: END IF;
12126: hr_utility.raise_error;

Line 12126: hr_utility.raise_error;

12122: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
12123: IF g_debug THEN
12124: debug('Leaving: '||l_proc_name,-999);
12125: END IF;
12126: hr_utility.raise_error;
12127: ELSE
12128: RAISE;
12129: END IF;
12130:

Line 12223: /* IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

12219: RETURN SSP_No_Paid_Days;
12220: EXCEPTION
12221: WHEN OTHERS THEN
12222: clear_cache;
12223: /* IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
12224: debug_others(l_proc_name,l_proc_step);*/
12225: IF g_debug THEN
12226: debug('Leaving: '||l_proc_name,-999);
12227: END IF;