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.23.12010000.7 2008/08/25 06:54:05 bachakra ship $ */
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 10090: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

10086:
10087: EXCEPTION
10088: WHEN OTHERS THEN
10089: clear_cache;
10090: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
10091: debug_others(l_proc_name,l_proc_step);
10092: IF g_debug THEN
10093: debug('Leaving: '||l_proc_name,-999);
10094: END IF;

Line 10121: g_debug := hr_utility.debug_enabled;

10117: g_package_name||'get_absence_smp';
10118:
10119: BEGIN
10120:
10121: g_debug := hr_utility.debug_enabled;
10122:
10123: IF g_debug THEN
10124: debug_enter(l_proc_name);
10125: debug('p_absence_attendance_id:'||p_absence_attendance_id);

Line 10156: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

10152:
10153: EXCEPTION
10154: WHEN OTHERS THEN
10155: clear_cache;
10156: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
10157: debug_others(l_proc_name,l_proc_step);
10158: IF g_debug THEN
10159: debug('Leaving: '||l_proc_name,-999);
10160: END IF;

Line 10208: g_debug := hr_utility.debug_enabled;

10204: l_error_msg fnd_new_messages.message_text%TYPE;
10205:
10206: BEGIN
10207:
10208: g_debug := hr_utility.debug_enabled;
10209: IF g_debug THEN
10210: debug_enter(l_proc_name);
10211: END IF;
10212:

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

10275: p_error_msg := SQLERRM;
10276: p_error_code := SQLCODE;
10277: l_error_code := -1;
10278: clear_cache;
10279: --IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
10280: debug_others(l_proc_name,l_proc_step);
10281: IF g_debug THEN
10282: debug('Leaving: '||l_proc_name,-999);
10283: END IF;

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

10391: p_error_msg := SQLERRM;
10392: p_error_code := SQLCODE;
10393: l_error_code := -1;
10394: clear_cache;
10395: --IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
10396: debug_others(l_proc_name,l_proc_step);
10397: IF g_debug THEN
10398: debug('Leaving: '||l_proc_name,-999);
10399: END IF;

Line 10594: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

10590:
10591: EXCEPTION
10592: WHEN OTHERS THEN
10593: clear_cache;
10594: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
10595: debug_others(l_proc_name,l_proc_step);
10596: IF g_debug THEN
10597: debug('Leaving: '||l_proc_name,-999);
10598: END IF;

Line 10734: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

10730:
10731: EXCEPTION
10732: WHEN OTHERS THEN
10733: clear_cache;
10734: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
10735: debug_others(l_proc_name,l_proc_step);
10736: IF g_debug THEN
10737: debug('Leaving: '||l_proc_name,-999);
10738: END IF;

Line 10881: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

10877: debug_exit(l_proc_name);
10878:
10879: EXCEPTION
10880: WHEN OTHERS THEN
10881: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
10882: debug_others(l_proc_name,l_proc_step);
10883: IF g_debug THEN
10884: debug('Leaving: '||l_proc_name,-999);
10885: END IF;

Line 10963: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

10959: RETURN NVL(l_minpay_rate,0) ;
10960: EXCEPTION
10961: WHEN OTHERS THEN
10962: clear_cache;
10963: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
10964: debug_others(l_proc_name,l_proc_step);
10965: IF g_debug THEN
10966: debug('Leaving: '||l_proc_name,-999);
10967: END IF;

Line 11024: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

11020:
11021: EXCEPTION
11022: WHEN OTHERS THEN
11023: clear_cache;
11024: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
11025: debug_others(l_proc_name,l_proc_step);
11026: IF g_debug THEN
11027: debug('Leaving: '||l_proc_name,-999);
11028: END IF;

Line 11064: g_debug := hr_utility.debug_enabled;

11060: --3)Passes on the values to the out parameters.
11061: --4)Added for precaution...get the entitlement proration
11062: -- if it is Y and No rounding values is provided then
11063: -- by default round it to max precision..5 decimal places
11064: g_debug := hr_utility.debug_enabled;
11065: IF g_debug THEN
11066: debug_enter(l_proc_name);
11067: debug('p_pl_id:'||p_pl_id);
11068: END IF;

Line 11181: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

11177: END IF;
11178:
11179: EXCEPTION
11180: WHEN OTHERS THEN
11181: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
11182: pqp_utilities.debug_others
11183: (l_proc_name
11184: ,l_proc_step
11185: );

Line 11282: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

11278:
11279: EXCEPTION
11280: WHEN OTHERS THEN
11281: clear_cache;
11282: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
11283: debug_others(l_proc_name,l_proc_step);
11284: IF g_debug THEN
11285: debug('Leaving: '||l_proc_name,-999);
11286: END IF;

Line 11417: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

11413:
11414: EXCEPTION
11415: WHEN OTHERS THEN
11416: clear_cache;
11417: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
11418: debug_others(l_proc_name,l_proc_step);
11419: IF g_debug THEN
11420: debug('Leaving: '||l_proc_name,-999);
11421: END IF;

Line 11446: g_debug := hr_utility.debug_enabled;

11442: l_proc_step NUMBER;
11443:
11444: BEGIN
11445:
11446: g_debug := hr_utility.debug_enabled;
11447: l_proc_step := 10;
11448: IF g_debug THEN
11449: debug_enter(l_proc_name);
11450: debug(l_proc_name,l_proc_step);

Line 11512: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

11508:
11509: EXCEPTION
11510: WHEN OTHERS THEN
11511: clear_cache;
11512: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
11513: debug_others(l_proc_name,l_proc_step);
11514: IF g_debug THEN
11515: debug('Leaving: '||l_proc_name,-999);
11516: END IF;

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

11577:
11578:
11579: BEGIN
11580:
11581: --hr_utility.trace_on(null,'rvishwan');
11582: IF g_debug THEN
11583: debug_enter(l_proc_name);
11584: debug(l_proc_name,10);
11585: debug('p_business_group_id:'||p_business_group_id);

Line 11854: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

11850:
11851: EXCEPTION
11852: WHEN OTHERS THEN
11853: clear_cache;
11854: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
11855: debug_others(l_proc_name,l_proc_step);
11856: IF g_debug THEN
11857: debug('Leaving: '||l_proc_name,-999);
11858: END IF;

Line 11895: g_debug := hr_utility.debug_enabled;

11891:
11892: BEGIN
11893:
11894:
11895: g_debug := hr_utility.debug_enabled;
11896:
11897: IF g_debug THEN
11898: debug_enter(l_proc_name);
11899: debug(l_proc_name,10);

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

11962:
11963: IF (l_pension_end_dt IS NOT NULL OR l_pension_st_dt IS NOT NULL) AND
11964: (l_pension_end_dt IS NULL OR l_pension_st_dt IS NULL)
11965: THEN
11966: hr_utility.set_message(8303,'PQP_230462_ABS_PENSION_DATE');
11967: hr_utility.raise_error;
11968: END IF;
11969:
11970: IF g_debug THEN

Line 11967: hr_utility.raise_error;

11963: IF (l_pension_end_dt IS NOT NULL OR l_pension_st_dt IS NOT NULL) AND
11964: (l_pension_end_dt IS NULL OR l_pension_st_dt IS NULL)
11965: THEN
11966: hr_utility.set_message(8303,'PQP_230462_ABS_PENSION_DATE');
11967: hr_utility.raise_error;
11968: END IF;
11969:
11970: IF g_debug THEN
11971: debug(l_proc_name,45);

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

11979: END IF;
11980:
11981: IF (l_pension_end_dt NOT BETWEEN p_date_start AND l_date_end)
11982: THEN
11983: hr_utility.set_message(8303,'PQP_230462_ABS_PENSION_DATE');
11984: hr_utility.raise_error;
11985:
11986: IF g_debug THEN
11987: debug(l_proc_name,60);

Line 11984: hr_utility.raise_error;

11980:
11981: IF (l_pension_end_dt NOT BETWEEN p_date_start AND l_date_end)
11982: THEN
11983: hr_utility.set_message(8303,'PQP_230462_ABS_PENSION_DATE');
11984: hr_utility.raise_error;
11985:
11986: IF g_debug THEN
11987: debug(l_proc_name,60);
11988: debug('l_is_check_true'||l_is_check_true);

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

11997:
11998: IF l_pension_st_dt IS NOT NULL
11999: AND(l_pension_st_dt NOT BETWEEN p_date_start AND l_date_end)
12000: THEN
12001: hr_utility.set_message(8303,'PQP_230462_ABS_PENSION_DATE');
12002: hr_utility.raise_error;
12003: IF g_debug THEN
12004: debug(l_proc_name,70);
12005: debug('l_is_check_true'||l_is_check_true);

Line 12002: hr_utility.raise_error;

11998: IF l_pension_st_dt IS NOT NULL
11999: AND(l_pension_st_dt NOT BETWEEN p_date_start AND l_date_end)
12000: THEN
12001: hr_utility.set_message(8303,'PQP_230462_ABS_PENSION_DATE');
12002: hr_utility.raise_error;
12003: IF g_debug THEN
12004: debug(l_proc_name,70);
12005: debug('l_is_check_true'||l_is_check_true);
12006: END IF;

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

12011: END IF;
12012:
12013: IF l_pension_st_dt IS NOT NULL AND l_pension_end_dt IS NOT NULL THEN
12014: IF l_pension_st_dt > l_pension_end_dt THEN
12015: hr_utility.set_message(8303,'PQP_230463_ABS_PENSION_RATE');
12016: hr_utility.raise_error;
12017: END IF;
12018: END IF;
12019:

Line 12016: hr_utility.raise_error;

12012:
12013: IF l_pension_st_dt IS NOT NULL AND l_pension_end_dt IS NOT NULL THEN
12014: IF l_pension_st_dt > l_pension_end_dt THEN
12015: hr_utility.set_message(8303,'PQP_230463_ABS_PENSION_RATE');
12016: hr_utility.raise_error;
12017: END IF;
12018: END IF;
12019:
12020: IF g_debug THEN

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

12026: ( l_pension_rt IS NULL AND(( l_pension_st_dt IS NOT NULL OR l_pension_end_dt is NOT NULL ) ) )
12027: )
12028:
12029: THEN
12030: hr_utility.set_message(8303,'PQP_230463_ABS_PENSION_RATE');
12031: hr_utility.raise_error;
12032: END IF;
12033:
12034: IF g_debug THEN

Line 12031: hr_utility.raise_error;

12027: )
12028:
12029: THEN
12030: hr_utility.set_message(8303,'PQP_230463_ABS_PENSION_RATE');
12031: hr_utility.raise_error;
12032: END IF;
12033:
12034: IF g_debug THEN
12035: debug(l_proc_name,85);

Line 12046: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

12042:
12043: EXCEPTION
12044: WHEN OTHERS THEN
12045:
12046: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
12047: IF g_debug THEN
12048: debug('Leaving: '||l_proc_name,-999);
12049: END IF;
12050: hr_utility.raise_error;

Line 12050: hr_utility.raise_error;

12046: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
12047: IF g_debug THEN
12048: debug('Leaving: '||l_proc_name,-999);
12049: END IF;
12050: hr_utility.raise_error;
12051: ELSE
12052: RAISE;
12053: END IF;
12054:

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

12077: BEGIN
12078: --
12079: -- Added for GSI Bug 5472781
12080: --
12081: IF hr_utility.chk_product_install('Oracle Human Resources', 'GB') THEN
12082: --
12083: IF g_debug THEN
12084: debug_enter(l_proc_name);
12085: END IF;

Line 12093: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

12089: EXCEPTION
12090: WHEN OTHERS THEN
12091:
12092:
12093: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
12094: IF g_debug THEN
12095: debug('Leaving: '||l_proc_name,-999);
12096: END IF;
12097: hr_utility.raise_error;

Line 12097: hr_utility.raise_error;

12093: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
12094: IF g_debug THEN
12095: debug('Leaving: '||l_proc_name,-999);
12096: END IF;
12097: hr_utility.raise_error;
12098: ELSE
12099: RAISE;
12100: END IF;
12101:

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

12190: RETURN SSP_No_Paid_Days;
12191: EXCEPTION
12192: WHEN OTHERS THEN
12193: clear_cache;
12194: /* IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
12195: debug_others(l_proc_name,l_proc_step);*/
12196: IF g_debug THEN
12197: debug('Leaving: '||l_proc_name,-999);
12198: END IF;