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 FND_MESSAGE

Line 301: fnd_message.raise_error;

297: debug_others(l_proc_name,l_proc_step);
298: IF g_debug THEN
299: debug('Leaving: '||l_proc_name,-999);
300: END IF;
301: fnd_message.raise_error;
302: ELSE
303: RAISE;
304: END IF;
305: END pqp_get_absence_attendances;

Line 405: fnd_message.raise_error;

401: debug_others(l_proc_name,l_proc_step);
402: IF g_debug THEN
403: debug('Leaving: '||l_proc_name,-999);
404: END IF;
405: fnd_message.raise_error;
406: ELSE
407: RAISE;
408: END IF;
409: END pqp_get_absence_further_info;

Line 500: fnd_message.raise_error;

496: debug_others(l_proc_name,l_proc_step);
497: IF g_debug THEN
498: debug('Leaving: '||l_proc_name,-999);
499: END IF;
500: fnd_message.raise_error;
501: ELSE
502: RAISE;
503: END IF;
504: END pqp_get_absence_addnl_attr;

Line 573: fnd_message.raise_error;

569: debug_others(l_proc_name,l_proc_step);
570: IF g_debug THEN
571: debug('Leaving: '||l_proc_name,-999);
572: END IF;
573: fnd_message.raise_error;
574: ELSE
575: RAISE;
576: END IF;
577: END pqp_get_ssp_medicals_details;

Line 682: fnd_message.raise_error;

678: debug_others(l_proc_name,l_proc_step);
679: IF g_debug THEN
680: debug('Leaving: '||l_proc_name,-999);
681: END IF;
682: fnd_message.raise_error;
683: ELSE
684: RAISE;
685: END IF;
686: --

Line 756: fnd_message.raise_error;

752: debug_others(l_proc_name,l_proc_step);
753: IF g_debug THEN
754: debug('Leaving: '||l_proc_name,-999);
755: END IF;
756: fnd_message.raise_error;
757: ELSE
758: RAISE;
759: END IF;
760: END pqp_get_ssp_matrnty_details;

Line 865: fnd_message.raise_error;

861: debug_others(l_proc_name,l_proc_step);
862: IF g_debug THEN
863: debug('Leaving: '||l_proc_name,-999);
864: END IF;
865: fnd_message.raise_error;
866: ELSE
867: RAISE;
868: END IF;
869: END pqp_get_ssp_matrnty_addnl_attr;

Line 914: fnd_message.get_string('PQP', 'PQP_230602_INV_INFO_TYPE');

910: IF l_element_type_id IS NULL
911: THEN
912: debug(l_proc_name, 20);
913: p_error_msg :=
914: fnd_message.get_string('PQP', 'PQP_230602_INV_INFO_TYPE');
915: debug_exit(l_proc_name || ' ' || p_error_msg);
916: RETURN -1;
917: ELSE
918: debug(l_proc_name, 30);

Line 951: fnd_message.raise_error;

947: debug_others(l_proc_name,l_proc_step);
948: IF g_debug THEN
949: debug('Leaving: '||l_proc_name,-999);
950: END IF;
951: fnd_message.raise_error;
952: ELSE
953: RAISE;
954: END IF;
955: --

Line 1002: fnd_message.get_string('PQP', 'PQP_230606_INV_PLAN_NAME');

998:
999: IF l_pl_id IS NULL
1000: THEN
1001: p_error_msg :=
1002: fnd_message.get_string('PQP', 'PQP_230606_INV_PLAN_NAME');
1003: debug_exit(l_proc_name || ' ' || p_error_msg);
1004: RETURN -1;
1005: END IF;
1006:

Line 1032: fnd_message.raise_error;

1028: debug_others(l_proc_name,l_proc_step);
1029: IF g_debug THEN
1030: debug('Leaving: '||l_proc_name,-999);
1031: END IF;
1032: fnd_message.raise_error;
1033: ELSE
1034: RAISE;
1035: END IF;
1036: END pqp_get_other_plan_extra_info;

Line 1085: fnd_message.raise_error;

1081: debug_others(l_proc_name,l_proc_step);
1082: IF g_debug THEN
1083: debug('Leaving: '||l_proc_name,-999);
1084: END IF;
1085: fnd_message.raise_error;
1086: ELSE
1087: RAISE;
1088: END IF;
1089: --

Line 1147: fnd_message.raise_error;

1143: debug_others(l_proc_name,l_proc_step);
1144: IF g_debug THEN
1145: debug('Leaving: '||l_proc_name,-999);
1146: END IF;
1147: fnd_message.raise_error;
1148: ELSE
1149: RAISE;
1150: END IF;
1151: --

Line 1195: fnd_message.raise_error;

1191: debug_others(l_proc_name,l_proc_step);
1192: IF g_debug THEN
1193: debug('Leaving: '||l_proc_name,-999);
1194: END IF;
1195: fnd_message.raise_error;
1196: ELSE
1197: RAISE;
1198: END IF;
1199: END ben_get_absence_id;

Line 1255: fnd_message.raise_error;

1251: debug_others(l_proc_name,l_proc_step);
1252: IF g_debug THEN
1253: debug('Leaving: '||l_proc_name,-999);
1254: END IF;
1255: fnd_message.raise_error;
1256: ELSE
1257: RAISE;
1258: END IF;
1259: END ben_get_per_abs_attendances;

Line 1322: fnd_message.raise_error;

1318: debug_others(l_proc_name,l_proc_step);
1319: IF g_debug THEN
1320: debug('Leaving: '||l_proc_name,-999);
1321: END IF;
1322: fnd_message.raise_error;
1323: ELSE
1324: RAISE;
1325: END IF;
1326:

Line 1389: fnd_message.raise_error;

1385: debug_others(l_proc_name,l_proc_step);
1386: IF g_debug THEN
1387: debug('Leaving: '||l_proc_name,-999);
1388: END IF;
1389: fnd_message.raise_error;
1390: ELSE
1391: RAISE;
1392: END IF;
1393:

Line 1448: fnd_message.raise_error;

1444: debug_others(l_proc_name,l_proc_step);
1445: IF g_debug THEN
1446: debug('Leaving: '||l_proc_name,-999);
1447: END IF;
1448: fnd_message.raise_error;
1449: ELSE
1450: RAISE;
1451: END IF;
1452:

Line 1513: fnd_message.raise_error;

1509: debug_others(l_proc_name,l_proc_step);
1510: IF g_debug THEN
1511: debug('Leaving: '||l_proc_name,-999);
1512: END IF;
1513: fnd_message.raise_error;
1514: ELSE
1515: RAISE;
1516: END IF;
1517:

Line 1571: fnd_message.raise_error;

1567: debug_others(l_proc_name,l_proc_step);
1568: IF g_debug THEN
1569: debug('Leaving: '||l_proc_name,-999);
1570: END IF;
1571: fnd_message.raise_error;
1572: ELSE
1573: RAISE;
1574: END IF;
1575: END ben_get_ssp_matrnty_details;

Line 1634: fnd_message.raise_error;

1630: debug_others(l_proc_name,l_proc_step);
1631: IF g_debug THEN
1632: debug('Leaving: '||l_proc_name,-999);
1633: END IF;
1634: fnd_message.raise_error;
1635: ELSE
1636: RAISE;
1637: END IF;
1638:

Line 1670: fnd_message.set_name('PQP', 'PQP_230598_INV_TITLE');

1666:
1667: --
1668: IF csr_lookup_code%NOTFOUND
1669: THEN
1670: fnd_message.set_name('PQP', 'PQP_230598_INV_TITLE');
1671: fnd_message.set_token('LKUP_MEANING', p_lookup_meaning);
1672: p_message := fnd_message.get();
1673: -- CLOSE csr_lookup_code ;
1674: -- RETURN NULL ;

Line 1671: fnd_message.set_token('LKUP_MEANING', p_lookup_meaning);

1667: --
1668: IF csr_lookup_code%NOTFOUND
1669: THEN
1670: fnd_message.set_name('PQP', 'PQP_230598_INV_TITLE');
1671: fnd_message.set_token('LKUP_MEANING', p_lookup_meaning);
1672: p_message := fnd_message.get();
1673: -- CLOSE csr_lookup_code ;
1674: -- RETURN NULL ;
1675: END IF;

Line 1672: p_message := fnd_message.get();

1668: IF csr_lookup_code%NOTFOUND
1669: THEN
1670: fnd_message.set_name('PQP', 'PQP_230598_INV_TITLE');
1671: fnd_message.set_token('LKUP_MEANING', p_lookup_meaning);
1672: p_message := fnd_message.get();
1673: -- CLOSE csr_lookup_code ;
1674: -- RETURN NULL ;
1675: END IF;
1676:

Line 1693: fnd_message.raise_error;

1689: debug_others(l_proc_name,l_proc_step);
1690: IF g_debug THEN
1691: debug('Leaving: '||l_proc_name,-999);
1692: END IF;
1693: fnd_message.raise_error;
1694: ELSE
1695: RAISE;
1696: END IF;
1697: END get_lookup_code;

Line 1857: fnd_message.raise_error;

1853: debug_others(l_proc_name,l_proc_step);
1854: IF g_debug THEN
1855: debug('Leaving: '||l_proc_name,-999);
1856: END IF;
1857: fnd_message.raise_error;
1858: ELSE
1859: RAISE;
1860: END IF;
1861: END get_absence_details;

Line 1922: fnd_message.raise_error;

1918: debug_others(l_proc_name,l_proc_step);
1919: IF g_debug THEN
1920: debug('Leaving: '||l_proc_name,-999);
1921: END IF;
1922: fnd_message.raise_error;
1923: ELSE
1924: RAISE;
1925: END IF;
1926: END ben_get_absence_details;

Line 1995: fnd_message.raise_error;

1991: debug_others(l_proc_name,l_proc_step);
1992: IF g_debug THEN
1993: debug('Leaving: '||l_proc_name,-999);
1994: END IF;
1995: fnd_message.raise_error;
1996: ELSE
1997: RAISE;
1998: END IF;
1999: END get_medical_details;

Line 2129: fnd_message.raise_error;

2125: debug_others(l_proc_name,l_proc_step);
2126: IF g_debug THEN
2127: debug('Leaving: '||l_proc_name,-999);
2128: END IF;
2129: fnd_message.raise_error;
2130: ELSE
2131: RAISE;
2132: END IF;
2133: END get_matrnty_details;

Line 2327: fnd_message.raise_error;

2323: debug_others(l_proc_name,l_proc_step);
2324: IF g_debug THEN
2325: debug('Leaving: '||l_proc_name,-999);
2326: END IF;
2327: fnd_message.raise_error;
2328: ELSE
2329: RAISE;
2330: END IF;
2331: END get_override_entitlements;

Line 2579: -- p_error_msg := fnd_message.get_string('PQP', 'PQP_230603_DEF_BAND1');

2575: -- --
2576: -- -- If there is no value defined
2577: -- --
2578: -- CLOSE csr_get_lookup_info;
2579: -- p_error_msg := fnd_message.get_string('PQP', 'PQP_230603_DEF_BAND1');
2580: -- debug(p_error_msg);
2581: -- debug_exit(l_proc_name);
2582: -- RETURN -1;
2583: --

Line 2707: fnd_message.raise_error;

2703: debug_others(l_proc_name,l_proc_step);
2704: IF g_debug THEN
2705: debug('Leaving: '||l_proc_name,-999);
2706: END IF;
2707: fnd_message.raise_error;
2708: ELSE
2709: RAISE;
2710: END IF;
2711: END get_los_based_entitlements;

Line 2777: fnd_message.set_name('PQP', 'PQP_230604_DEF_BND_PER');

2773: END IF;
2774:
2775: IF l_band_percentage IS NULL
2776: THEN
2777: fnd_message.set_name('PQP', 'PQP_230604_DEF_BND_PER');
2778: fnd_message.set_token('BAND', p_level_of_entitlement);
2779: p_error_msg := fnd_message.get();
2780: debug_exit(l_proc_name);
2781: RETURN -1;

Line 2778: fnd_message.set_token('BAND', p_level_of_entitlement);

2774:
2775: IF l_band_percentage IS NULL
2776: THEN
2777: fnd_message.set_name('PQP', 'PQP_230604_DEF_BND_PER');
2778: fnd_message.set_token('BAND', p_level_of_entitlement);
2779: p_error_msg := fnd_message.get();
2780: debug_exit(l_proc_name);
2781: RETURN -1;
2782: ELSE

Line 2779: p_error_msg := fnd_message.get();

2775: IF l_band_percentage IS NULL
2776: THEN
2777: fnd_message.set_name('PQP', 'PQP_230604_DEF_BND_PER');
2778: fnd_message.set_token('BAND', p_level_of_entitlement);
2779: p_error_msg := fnd_message.get();
2780: debug_exit(l_proc_name);
2781: RETURN -1;
2782: ELSE
2783: l_band_ent_rows.meaning := p_level_of_entitlement;

Line 2817: fnd_message.set_name('PQP', 'PQP_230605_DEF_AVG_REC');

2813: END IF;
2814:
2815: IF l_band_avg_rec_ind IS NULL
2816: THEN
2817: fnd_message.set_name('PQP', 'PQP_230605_DEF_AVG_REC');
2818: fnd_message.set_token('BAND', p_level_of_entitlement);
2819: p_error_msg := fnd_message.get();
2820: debug(p_error_msg);
2821: debug_exit(l_proc_name);

Line 2818: fnd_message.set_token('BAND', p_level_of_entitlement);

2814:
2815: IF l_band_avg_rec_ind IS NULL
2816: THEN
2817: fnd_message.set_name('PQP', 'PQP_230605_DEF_AVG_REC');
2818: fnd_message.set_token('BAND', p_level_of_entitlement);
2819: p_error_msg := fnd_message.get();
2820: debug(p_error_msg);
2821: debug_exit(l_proc_name);
2822: RETURN -1;

Line 2819: p_error_msg := fnd_message.get();

2815: IF l_band_avg_rec_ind IS NULL
2816: THEN
2817: fnd_message.set_name('PQP', 'PQP_230605_DEF_AVG_REC');
2818: fnd_message.set_token('BAND', p_level_of_entitlement);
2819: p_error_msg := fnd_message.get();
2820: debug(p_error_msg);
2821: debug_exit(l_proc_name);
2822: RETURN -1;
2823: ELSE

Line 2848: fnd_message.raise_error;

2844: debug_others(l_proc_name,l_proc_step);
2845: IF g_debug THEN
2846: debug('Leaving: '||l_proc_name,-999);
2847: END IF;
2848: fnd_message.raise_error;
2849: ELSE
2850: RAISE;
2851: END IF;
2852: END pqp_get_band_ent_parameters;

Line 3003: fnd_message.raise_error;

2999: debug_others(l_proc_name,l_proc_step);
3000: IF g_debug THEN
3001: debug('Leaving: '||l_proc_name,-999);
3002: END IF;
3003: fnd_message.raise_error;
3004: ELSE
3005: RAISE;
3006: END IF;
3007: END get_entitlement_parameters;

Line 3441: fnd_message.raise_error;

3437: debug_others(l_proc_name,l_proc_step);
3438: IF g_debug THEN
3439: debug('Leaving: '||l_proc_name,-999);
3440: END IF;
3441: fnd_message.raise_error;
3442: ELSE
3443: RAISE;
3444: END IF;
3445: END pqp_get_band_ent_value;

Line 3473: fnd_message.get_string('PQP', 'PQP_230599_INV_MATERNITY_ID');

3469: IF csr_maternity_id%NOTFOUND
3470: OR l_maternity_id IS NULL
3471: THEN
3472: p_message :=
3473: fnd_message.get_string('PQP', 'PQP_230599_INV_MATERNITY_ID');
3474: END IF;
3475:
3476: --
3477: CLOSE csr_maternity_id;

Line 3492: fnd_message.raise_error;

3488: debug_others(l_proc_name,l_proc_step);
3489: IF g_debug THEN
3490: debug('Leaving: '||l_proc_name,-999);
3491: END IF;
3492: fnd_message.raise_error;
3493: ELSE
3494: RAISE;
3495: END IF;
3496: END pqp_get_maternity_id;

Line 3520: p_message := fnd_message.get_string('PQP', 'PQP_230600_INV_MEDICAL_ID');

3516:
3517: --
3518: IF csr_medical_id%NOTFOUND
3519: THEN
3520: p_message := fnd_message.get_string('PQP', 'PQP_230600_INV_MEDICAL_ID');
3521: END IF;
3522:
3523: CLOSE csr_medical_id;
3524: IF g_debug THEN

Line 3538: fnd_message.raise_error;

3534: debug_others(l_proc_name,l_proc_step);
3535: IF g_debug THEN
3536: debug('Leaving: '||l_proc_name,-999);
3537: END IF;
3538: fnd_message.raise_error;
3539: ELSE
3540: RAISE;
3541: END IF;
3542: END pqp_get_medical_id;

Line 3618: fnd_message.raise_error;

3614: debug_others(l_proc_name,l_proc_step);
3615: IF g_debug THEN
3616: debug('Leaving: '||l_proc_name,-999);
3617: END IF;
3618: fnd_message.raise_error;
3619: ELSE
3620: RAISE;
3621: END IF;
3622: END pqp_gb_get_no_of_holidays;

Line 3661: fnd_message.raise_error;

3657: debug_others(l_proc_name,l_proc_step);
3658: IF g_debug THEN
3659: debug('Leaving: '||l_proc_name,-999);
3660: END IF;
3661: fnd_message.raise_error;
3662: ELSE
3663: RAISE;
3664: END IF;
3665: END pqp_gb_get_calendar_days;

Line 3731: fnd_message.raise_error;

3727: debug_others(l_proc_name,l_proc_step);
3728: IF g_debug THEN
3729: debug('Leaving: '||l_proc_name,-999);
3730: END IF;
3731: fnd_message.raise_error;
3732: ELSE
3733: RAISE;
3734: END IF;
3735: END pqp_gb_get_cal_abs_hol_days;

Line 3805: fnd_message.raise_error;

3801: debug_others(l_proc_name,l_proc_step);
3802: IF g_debug THEN
3803: debug('Leaving: '||l_proc_name,-999);
3804: END IF;
3805: fnd_message.raise_error;
3806: ELSE
3807: RAISE;
3808: END IF;
3809: END pqp_gb_get_cal_abs_days;

Line 3882: fnd_message.raise_error;

3878: debug_others(l_proc_name,l_proc_step);
3879: IF g_debug THEN
3880: debug('Leaving: '||l_proc_name,-999);
3881: END IF;
3882: fnd_message.raise_error;
3883: ELSE
3884: RAISE;
3885: END IF;
3886: END pqp_gb_get_no_of_work_holidays;

Line 3969: fnd_message.raise_error;

3965: debug_others(l_proc_name,l_proc_step);
3966: IF g_debug THEN
3967: debug('Leaving: '||l_proc_name,-999);
3968: END IF;
3969: fnd_message.raise_error;
3970: ELSE
3971: RAISE;
3972: END IF;
3973: END pqp_gb_get_work_abs_days_udt;

Line 4054: fnd_message.raise_error;

4050: debug_others(l_proc_name,l_proc_step);
4051: IF g_debug THEN
4052: debug('Leaving: '||l_proc_name,-999);
4053: END IF;
4054: fnd_message.raise_error;
4055: ELSE
4056: RAISE;
4057: END IF;
4058: END pqp_gb_get_work_abs_days;

Line 4217: fnd_message.raise_error;

4213: debug_others(l_proc_name,l_proc_step);
4214: IF g_debug THEN
4215: debug('Leaving: '||l_proc_name,-999);
4216: END IF;
4217: fnd_message.raise_error;
4218: ELSE
4219: RAISE;
4220: END IF;
4221: END pqp_get_omp_band_ent_value;

Line 4354: -- fnd_message.raise_error;

4350: -- debug_others(l_proc_name,l_proc_step);
4351: -- IF g_debug THEN
4352: -- debug('Leaving: '||l_proc_name,-999);
4353: -- END IF;
4354: -- fnd_message.raise_error;
4355: -- ELSE
4356: -- RAISE;
4357: -- END IF;
4358: -- END get_day_dets;

Line 4528: fnd_message.raise_error;

4524: debug_others(l_proc_name,l_proc_step);
4525: IF g_debug THEN
4526: debug('Leaving: '||l_proc_name,-999);
4527: END IF;
4528: fnd_message.raise_error;
4529: ELSE
4530: RAISE;
4531: END IF;
4532: END get_next_working_date_wp;

Line 4734: p_error_message := fnd_message.get_string('PQP', l_err_msg_name);

4730:
4731: --
4732: IF l_err_msg_name IS NOT NULL
4733: THEN
4734: p_error_message := fnd_message.get_string('PQP', l_err_msg_name);
4735: END IF;
4736: IF g_debug THEN
4737: debug('l_curr_date'|| to_char(l_curr_date));
4738: debug_exit(l_proc_name);

Line 4750: fnd_message.raise_error;

4746: debug_others(l_proc_name,l_proc_step);
4747: IF g_debug THEN
4748: debug('Leaving: '||l_proc_name,-999);
4749: END IF;
4750: fnd_message.raise_error;
4751: ELSE
4752: RAISE;
4753: END IF;
4754: END get_next_working_date;

Line 4801: fnd_message.raise_error;

4797: debug_others(l_proc_name,l_proc_step);
4798: IF g_debug THEN
4799: debug('Leaving: '||l_proc_name,-999);
4800: END IF;
4801: fnd_message.raise_error;
4802: ELSE
4803: RAISE;
4804: END IF;
4805:

Line 4859: fnd_message.raise_error;

4855: debug_others(l_proc_name,l_proc_step);
4856: IF g_debug THEN
4857: debug('Leaving: '||l_proc_name,-999);
4858: END IF;
4859: fnd_message.raise_error;
4860: ELSE
4861: RAISE;
4862: END IF;
4863: END pqp_get_omp_oth_pl_extra_info;

Line 4934: fnd_message.raise_error;

4930: debug_others(l_proc_name,l_proc_step);
4931: IF g_debug THEN
4932: debug('Leaving: '||l_proc_name,-999);
4933: END IF;
4934: fnd_message.raise_error;
4935: ELSE
4936: RAISE;
4937: END IF;
4938: END ben_matrnty_details;

Line 5004: fnd_message.raise_error;

5000: debug_others(l_proc_name,l_proc_step);
5001: IF g_debug THEN
5002: debug('Leaving: '||l_proc_name,-999);
5003: END IF;
5004: fnd_message.raise_error;
5005: ELSE
5006: RAISE;
5007: END IF;
5008: END ben_medical_details;

Line 5050: fnd_message.set_name('PQP', 'PQP_230617_END_GE_START');

5046: IF NVL(p_search_start_date, SYSDATE) >
5047: NVL(p_search_end_date, hr_api.g_eot)
5048: THEN
5049: p_error_code := -1;
5050: fnd_message.set_name('PQP', 'PQP_230617_END_GE_START');
5051: --fnd_message.set_token('START'
5052: -- ,fnd_date.date_to_canonical(p_search_start_date));
5053: --fnd_message.set_token('END'
5054: -- ,fnd_date.date_to_canonical(p_search_end_date));

Line 5051: --fnd_message.set_token('START'

5047: NVL(p_search_end_date, hr_api.g_eot)
5048: THEN
5049: p_error_code := -1;
5050: fnd_message.set_name('PQP', 'PQP_230617_END_GE_START');
5051: --fnd_message.set_token('START'
5052: -- ,fnd_date.date_to_canonical(p_search_start_date));
5053: --fnd_message.set_token('END'
5054: -- ,fnd_date.date_to_canonical(p_search_end_date));
5055: p_error_message := fnd_message.get();

Line 5053: --fnd_message.set_token('END'

5049: p_error_code := -1;
5050: fnd_message.set_name('PQP', 'PQP_230617_END_GE_START');
5051: --fnd_message.set_token('START'
5052: -- ,fnd_date.date_to_canonical(p_search_start_date));
5053: --fnd_message.set_token('END'
5054: -- ,fnd_date.date_to_canonical(p_search_end_date));
5055: p_error_message := fnd_message.get();
5056: RETURN NULL;
5057: END IF;

Line 5055: p_error_message := fnd_message.get();

5051: --fnd_message.set_token('START'
5052: -- ,fnd_date.date_to_canonical(p_search_start_date));
5053: --fnd_message.set_token('END'
5054: -- ,fnd_date.date_to_canonical(p_search_end_date));
5055: p_error_message := fnd_message.get();
5056: RETURN NULL;
5057: END IF;
5058:
5059: -- Open the Cursor to get total number of Entitled days for the qualifier.

Line 5090: fnd_message.raise_error;

5086: debug_others(l_proc_name,l_proc_step);
5087: IF g_debug THEN
5088: debug('Leaving: '||l_proc_name,-999);
5089: END IF;
5090: fnd_message.raise_error;
5091: ELSE
5092: RAISE;
5093: END IF;
5094: END get_abs_plan_ent_days_info;

Line 5132: fnd_message.set_name('PQP', 'PQP_230617_END_GE_START');

5128: IF NVL(p_search_start_date, SYSDATE) >
5129: NVL(p_search_end_date, hr_api.g_eot)
5130: THEN
5131: p_error_code := -1;
5132: fnd_message.set_name('PQP', 'PQP_230617_END_GE_START');
5133: --fnd_message.set_token('START'
5134: -- ,fnd_date.date_to_canonical(p_search_start_date));
5135: --fnd_message.set_token('END'
5136: -- ,fnd_date.date_to_canonical(p_search_end_date));

Line 5133: --fnd_message.set_token('START'

5129: NVL(p_search_end_date, hr_api.g_eot)
5130: THEN
5131: p_error_code := -1;
5132: fnd_message.set_name('PQP', 'PQP_230617_END_GE_START');
5133: --fnd_message.set_token('START'
5134: -- ,fnd_date.date_to_canonical(p_search_start_date));
5135: --fnd_message.set_token('END'
5136: -- ,fnd_date.date_to_canonical(p_search_end_date));
5137: p_error_message := fnd_message.get();

Line 5135: --fnd_message.set_token('END'

5131: p_error_code := -1;
5132: fnd_message.set_name('PQP', 'PQP_230617_END_GE_START');
5133: --fnd_message.set_token('START'
5134: -- ,fnd_date.date_to_canonical(p_search_start_date));
5135: --fnd_message.set_token('END'
5136: -- ,fnd_date.date_to_canonical(p_search_end_date));
5137: p_error_message := fnd_message.get();
5138: RETURN NULL;
5139: END IF;

Line 5137: p_error_message := fnd_message.get();

5133: --fnd_message.set_token('START'
5134: -- ,fnd_date.date_to_canonical(p_search_start_date));
5135: --fnd_message.set_token('END'
5136: -- ,fnd_date.date_to_canonical(p_search_end_date));
5137: p_error_message := fnd_message.get();
5138: RETURN NULL;
5139: END IF;
5140:
5141: -- Open the Cursor to get total number of Paid days for the qualifier type.

Line 5168: fnd_message.raise_error;

5164: debug_others(l_proc_name,l_proc_step);
5165: IF g_debug THEN
5166: debug('Leaving: '||l_proc_name,-999);
5167: END IF;
5168: fnd_message.raise_error;
5169: ELSE
5170: RAISE;
5171: END IF;
5172: END get_abs_plan_paid_days_info;

Line 5209: fnd_message.set_name('PQP', 'PQP_230617_END_GE_START');

5205: IF NVL(p_search_start_date, SYSDATE) >
5206: NVL(p_search_end_date, hr_api.g_eot)
5207: THEN
5208: p_error_code := -1;
5209: fnd_message.set_name('PQP', 'PQP_230617_END_GE_START');
5210: --fnd_message.set_token('START'
5211: -- ,fnd_date.date_to_canonical(p_search_start_date));
5212: --fnd_message.set_token('END'
5213: -- ,fnd_date.date_to_canonical(p_search_end_date));

Line 5210: --fnd_message.set_token('START'

5206: NVL(p_search_end_date, hr_api.g_eot)
5207: THEN
5208: p_error_code := -1;
5209: fnd_message.set_name('PQP', 'PQP_230617_END_GE_START');
5210: --fnd_message.set_token('START'
5211: -- ,fnd_date.date_to_canonical(p_search_start_date));
5212: --fnd_message.set_token('END'
5213: -- ,fnd_date.date_to_canonical(p_search_end_date));
5214: p_error_message := fnd_message.get();

Line 5212: --fnd_message.set_token('END'

5208: p_error_code := -1;
5209: fnd_message.set_name('PQP', 'PQP_230617_END_GE_START');
5210: --fnd_message.set_token('START'
5211: -- ,fnd_date.date_to_canonical(p_search_start_date));
5212: --fnd_message.set_token('END'
5213: -- ,fnd_date.date_to_canonical(p_search_end_date));
5214: p_error_message := fnd_message.get();
5215: RETURN NULL;
5216: END IF;

Line 5214: p_error_message := fnd_message.get();

5210: --fnd_message.set_token('START'
5211: -- ,fnd_date.date_to_canonical(p_search_start_date));
5212: --fnd_message.set_token('END'
5213: -- ,fnd_date.date_to_canonical(p_search_end_date));
5214: p_error_message := fnd_message.get();
5215: RETURN NULL;
5216: END IF;
5217:
5218: -- Open the Cursor to get total number of Paid days for the qualifier type.

Line 5242: fnd_message.raise_error;

5238: debug_others(l_proc_name,l_proc_step);
5239: IF g_debug THEN
5240: debug('Leaving: '||l_proc_name,-999);
5241: END IF;
5242: fnd_message.raise_error;
5243: ELSE
5244: RAISE;
5245: END IF;
5246: END get_abs_plan_wp_info;

Line 5429: fnd_message.raise_error;

5425: debug_others(l_proc_name,l_proc_step);
5426: IF g_debug THEN
5427: debug('Leaving: '||l_proc_name,-999);
5428: END IF;
5429: fnd_message.raise_error;
5430: ELSE
5431: RAISE;
5432: END IF;
5433: END get_osp_band_paid_entitlements;

Line 5501: fnd_message.raise_error;

5497: debug_others(l_proc_name,l_proc_step);
5498: IF g_debug THEN
5499: debug('Leaving: '||l_proc_name,-999);
5500: END IF;
5501: fnd_message.raise_error;
5502: ELSE
5503: RAISE;
5504: END IF;
5505: END chk_calendar_occurance;

Line 5915: fnd_message.raise_error;

5911: debug_others(l_proc_name,l_proc_step);
5912: IF g_debug THEN
5913: debug('Leaving: '||l_proc_name,-999);
5914: END IF;
5915: fnd_message.raise_error;
5916: ELSE
5917: RAISE;
5918: END IF;
5919: END get_band_entitlement_balance;

Line 6065: fnd_message.raise_error;

6061: debug_others(l_proc_name,l_proc_step);
6062: IF g_debug THEN
6063: debug('Leaving: '||l_proc_name,-999);
6064: END IF;
6065: fnd_message.raise_error;
6066: ELSE
6067: RAISE;
6068: END IF;
6069: END get_band_ent_bal_by_ele_typ_id;

Line 6208: fnd_message.raise_error;

6204: debug_others(l_proc_name,l_proc_step);
6205: IF g_debug THEN
6206: debug('Leaving: '||l_proc_name,-999);
6207: END IF;
6208: fnd_message.raise_error;
6209: ELSE
6210: RAISE;
6211: END IF;
6212: END get_all_band_ent_balance;

Line 6278: fnd_message.raise_error;

6274: debug_others(l_proc_name,l_proc_step);
6275: IF g_debug THEN
6276: debug('Leaving: '||l_proc_name,-999);
6277: END IF;
6278: fnd_message.raise_error;
6279: ELSE
6280: RAISE;
6281: END IF;
6282: END get_band_ent_bal_by_pl_id;

Line 6339: fnd_message.raise_error;

6335: debug_others(l_proc_name,l_proc_step);
6336: IF g_debug THEN
6337: debug('Leaving: '||l_proc_name,-999);
6338: END IF;
6339: fnd_message.raise_error;
6340: ELSE
6341: RAISE;
6342: END IF;
6343: END get_paid_days_duration;

Line 6400: fnd_message.raise_error;

6396: debug_others(l_proc_name,l_proc_step);
6397: IF g_debug THEN
6398: debug('Leaving: '||l_proc_name,-999);
6399: END IF;
6400: fnd_message.raise_error;
6401: ELSE
6402: RAISE;
6403: END IF;
6404: END get_entitled_days_duration;

Line 6449: fnd_message.raise_error;

6445: debug_others(l_proc_name,l_proc_step);
6446: IF g_debug THEN
6447: debug('Leaving: '||l_proc_name,-999);
6448: END IF;
6449: fnd_message.raise_error;
6450: ELSE
6451: RAISE;
6452: END IF;
6453: END get_wp_days_duration;

Line 6518: fnd_message.raise_error;

6514: debug_others(l_proc_name,l_proc_step);
6515: IF g_debug THEN
6516: debug('Leaving: '||l_proc_name,-999);
6517: END IF;
6518: fnd_message.raise_error;
6519: ELSE
6520: RAISE;
6521: END IF;
6522: END get_subpriority;

Line 6600: fnd_message.raise_error;

6596: debug_others(l_proc_name,l_proc_step);
6597: IF g_debug THEN
6598: debug('Leaving: '||l_proc_name,-999);
6599: END IF;
6600: fnd_message.raise_error;
6601: ELSE
6602: RAISE;
6603: END IF;
6604: END get_next_cal_date;

Line 6710: fnd_message.raise_error;

6706: debug_others(l_proc_name,l_proc_step);
6707: IF g_debug THEN
6708: debug('Leaving: '||l_proc_name,-999);
6709: END IF;
6710: fnd_message.raise_error;
6711: ELSE
6712: RAISE;
6713: END IF;
6714: END exists_in_gap_lookup;

Line 6842: fnd_message.raise_error;

6838: debug_others(l_proc_name,l_proc_step);
6839: IF g_debug THEN
6840: debug('Leaving: '||l_proc_name,-999);
6841: END IF;
6842: fnd_message.raise_error;
6843: ELSE
6844: RAISE;
6845: END IF;
6846: END get_omp_all_band_ent_balance;

Line 6917: fnd_message.raise_error;

6913: debug_others(l_proc_name,l_proc_step);
6914: IF g_debug THEN
6915: debug('Leaving: '||l_proc_name,-999);
6916: END IF;
6917: fnd_message.raise_error;
6918: ELSE
6919: RAISE;
6920: END IF;
6921: END get_omp_band_ent_bal_ele_typ;

Line 7008: fnd_message.raise_error;

7004: debug_others(l_proc_name,l_proc_step);
7005: IF g_debug THEN
7006: debug('Leaving: '||l_proc_name,-999);
7007: END IF;
7008: fnd_message.raise_error;
7009: ELSE
7010: RAISE;
7011: END IF;
7012: END get_omp_band_ent_bal_pl_typ;

Line 7048: fnd_message.set_name('PQP','PQP_230617_END_GE_START');

7044: p_error_code := 0 ;
7045: -- Check the Start Date is earlier than or equal to End Date.
7046: IF NVL(p_search_start_date,SYSDATE) > NVL(p_search_end_date,hr_api.g_eot) THEN
7047: p_error_code := -1 ;
7048: fnd_message.set_name('PQP','PQP_230617_END_GE_START');
7049: --fnd_message.set_token('START',fnd_date.date_to_canonical(p_search_start_date));
7050: --fnd_message.set_token('END',fnd_date.date_to_canonical(p_search_end_date));
7051: p_error_message := fnd_message.get();
7052: RETURN NULL;

Line 7049: --fnd_message.set_token('START',fnd_date.date_to_canonical(p_search_start_date));

7045: -- Check the Start Date is earlier than or equal to End Date.
7046: IF NVL(p_search_start_date,SYSDATE) > NVL(p_search_end_date,hr_api.g_eot) THEN
7047: p_error_code := -1 ;
7048: fnd_message.set_name('PQP','PQP_230617_END_GE_START');
7049: --fnd_message.set_token('START',fnd_date.date_to_canonical(p_search_start_date));
7050: --fnd_message.set_token('END',fnd_date.date_to_canonical(p_search_end_date));
7051: p_error_message := fnd_message.get();
7052: RETURN NULL;
7053: END IF;

Line 7050: --fnd_message.set_token('END',fnd_date.date_to_canonical(p_search_end_date));

7046: IF NVL(p_search_start_date,SYSDATE) > NVL(p_search_end_date,hr_api.g_eot) THEN
7047: p_error_code := -1 ;
7048: fnd_message.set_name('PQP','PQP_230617_END_GE_START');
7049: --fnd_message.set_token('START',fnd_date.date_to_canonical(p_search_start_date));
7050: --fnd_message.set_token('END',fnd_date.date_to_canonical(p_search_end_date));
7051: p_error_message := fnd_message.get();
7052: RETURN NULL;
7053: END IF;
7054:

Line 7051: p_error_message := fnd_message.get();

7047: p_error_code := -1 ;
7048: fnd_message.set_name('PQP','PQP_230617_END_GE_START');
7049: --fnd_message.set_token('START',fnd_date.date_to_canonical(p_search_start_date));
7050: --fnd_message.set_token('END',fnd_date.date_to_canonical(p_search_end_date));
7051: p_error_message := fnd_message.get();
7052: RETURN NULL;
7053: END IF;
7054:
7055: -- Open the Cursor to get total number of Entitled days for the qualifier.

Line 7080: fnd_message.raise_error;

7076: debug_others(l_proc_name,l_proc_step);
7077: IF g_debug THEN
7078: debug('Leaving: '||l_proc_name,-999);
7079: END IF;
7080: fnd_message.raise_error;
7081: ELSE
7082: RAISE;
7083: END IF;
7084:

Line 7114: fnd_message.set_name('PQP','PQP_230617_END_GE_START');

7110: p_error_code := 0 ;
7111: -- Check the Start Date is earlier than or equal to End Date.
7112: IF NVL(p_search_start_date,SYSDATE) > NVL(p_search_end_date,hr_api.g_eot) THEN
7113: p_error_code := -1 ;
7114: fnd_message.set_name('PQP','PQP_230617_END_GE_START');
7115: --fnd_message.set_token('START',fnd_date.date_to_canonical(p_search_start_date));
7116: --fnd_message.set_token('END',fnd_date.date_to_canonical(p_search_end_date));
7117: p_error_message := fnd_message.get();
7118: RETURN NULL;

Line 7115: --fnd_message.set_token('START',fnd_date.date_to_canonical(p_search_start_date));

7111: -- Check the Start Date is earlier than or equal to End Date.
7112: IF NVL(p_search_start_date,SYSDATE) > NVL(p_search_end_date,hr_api.g_eot) THEN
7113: p_error_code := -1 ;
7114: fnd_message.set_name('PQP','PQP_230617_END_GE_START');
7115: --fnd_message.set_token('START',fnd_date.date_to_canonical(p_search_start_date));
7116: --fnd_message.set_token('END',fnd_date.date_to_canonical(p_search_end_date));
7117: p_error_message := fnd_message.get();
7118: RETURN NULL;
7119: END IF;

Line 7116: --fnd_message.set_token('END',fnd_date.date_to_canonical(p_search_end_date));

7112: IF NVL(p_search_start_date,SYSDATE) > NVL(p_search_end_date,hr_api.g_eot) THEN
7113: p_error_code := -1 ;
7114: fnd_message.set_name('PQP','PQP_230617_END_GE_START');
7115: --fnd_message.set_token('START',fnd_date.date_to_canonical(p_search_start_date));
7116: --fnd_message.set_token('END',fnd_date.date_to_canonical(p_search_end_date));
7117: p_error_message := fnd_message.get();
7118: RETURN NULL;
7119: END IF;
7120:

Line 7117: p_error_message := fnd_message.get();

7113: p_error_code := -1 ;
7114: fnd_message.set_name('PQP','PQP_230617_END_GE_START');
7115: --fnd_message.set_token('START',fnd_date.date_to_canonical(p_search_start_date));
7116: --fnd_message.set_token('END',fnd_date.date_to_canonical(p_search_end_date));
7117: p_error_message := fnd_message.get();
7118: RETURN NULL;
7119: END IF;
7120:
7121: -- Open the Cursor to get total number of Paid days for the qualifier type.

Line 7147: fnd_message.raise_error;

7143: debug_others(l_proc_name,l_proc_step);
7144: IF g_debug THEN
7145: debug('Leaving: '||l_proc_name,-999);
7146: END IF;
7147: fnd_message.raise_error;
7148: ELSE
7149: RAISE;
7150: END IF;
7151:

Line 7269: fnd_message.raise_error;

7265: debug_others(l_proc_name,l_proc_step);
7266: IF g_debug THEN
7267: debug('Leaving: '||l_proc_name,-999);
7268: END IF;
7269: fnd_message.raise_error;
7270: ELSE
7271: RAISE;
7272: END IF;
7273: END get_osp_hours_band_paid_ent ;

Line 7395: fnd_message.raise_error;

7391: debug_others(l_proc_name,l_proc_step);
7392: IF g_debug THEN
7393: debug('Leaving: '||l_proc_name,-999);
7394: END IF;
7395: fnd_message.raise_error;
7396: ELSE
7397: RAISE;
7398: END IF;
7399:

Line 7515: fnd_message.raise_error;

7511: debug_others(l_proc_name,l_proc_step);
7512: IF g_debug THEN
7513: debug('Leaving: '||l_proc_name,-999);
7514: END IF;
7515: fnd_message.raise_error;
7516: ELSE
7517: RAISE;
7518: END IF;
7519: END get_omp_all_band_hours_ent_bal ;

Line 7701: fnd_message.raise_error;

7697: debug_others(l_proc_name,l_proc_step);
7698: IF g_debug THEN
7699: debug('Leaving: '||l_proc_name,-999);
7700: END IF;
7701: fnd_message.raise_error;
7702: ELSE
7703: RAISE;
7704: END IF;
7705: END get_boundary_dates;

Line 7757: fnd_message.raise_error;

7753: debug_others(l_proc_name,l_proc_step);
7754: IF g_debug THEN
7755: debug('Leaving: '||l_proc_name,-999);
7756: END IF;
7757: fnd_message.raise_error;
7758: ELSE
7759: RAISE;
7760: END IF;
7761: END get_first_paid_day;

Line 7815: fnd_message.raise_error;

7811: debug_others(l_proc_name,l_proc_step);
7812: IF g_debug THEN
7813: debug('Leaving: '||l_proc_name,-999);
7814: END IF;
7815: fnd_message.raise_error;
7816: ELSE
7817: RAISE;
7818: END IF;
7819: END get_last_paid_day;

Line 7874: fnd_message.raise_error;

7870: debug_others(l_proc_name,l_proc_step);
7871: IF g_debug THEN
7872: debug('Leaving: '||l_proc_name,-999);
7873: END IF;
7874: fnd_message.raise_error;
7875: ELSE
7876: RAISE;
7877: END IF;
7878: END get_first_entitled_day;

Line 7933: fnd_message.raise_error;

7929: debug_others(l_proc_name,l_proc_step);
7930: IF g_debug THEN
7931: debug('Leaving: '||l_proc_name,-999);
7932: END IF;
7933: fnd_message.raise_error;
7934: ELSE
7935: RAISE;
7936: END IF;
7937: END get_last_entitled_day;

Line 8048: fnd_message.set_name('PQP','PQP_230617_END_GE_START');

8044: l_proc_step := 15;
8045: IF g_debug THEN
8046: debug(l_proc_name, l_proc_step);
8047: END IF;
8048: fnd_message.set_name('PQP','PQP_230617_END_GE_START');
8049: --fnd_message.set_token('START',p_pei_information1);
8050: --fnd_message.set_token('END',p_pei_information2);
8051: fnd_message.raise_error;
8052: END IF;

Line 8049: --fnd_message.set_token('START',p_pei_information1);

8045: IF g_debug THEN
8046: debug(l_proc_name, l_proc_step);
8047: END IF;
8048: fnd_message.set_name('PQP','PQP_230617_END_GE_START');
8049: --fnd_message.set_token('START',p_pei_information1);
8050: --fnd_message.set_token('END',p_pei_information2);
8051: fnd_message.raise_error;
8052: END IF;
8053:

Line 8050: --fnd_message.set_token('END',p_pei_information2);

8046: debug(l_proc_name, l_proc_step);
8047: END IF;
8048: fnd_message.set_name('PQP','PQP_230617_END_GE_START');
8049: --fnd_message.set_token('START',p_pei_information1);
8050: --fnd_message.set_token('END',p_pei_information2);
8051: fnd_message.raise_error;
8052: END IF;
8053:
8054: l_proc_step := 20;

Line 8051: fnd_message.raise_error;

8047: END IF;
8048: fnd_message.set_name('PQP','PQP_230617_END_GE_START');
8049: --fnd_message.set_token('START',p_pei_information1);
8050: --fnd_message.set_token('END',p_pei_information2);
8051: fnd_message.raise_error;
8052: END IF;
8053:
8054: l_proc_step := 20;
8055: IF g_debug THEN

Line 8127: fnd_message.set_name('PQP','PQP_230010_PLAN_OVRRIDE_OVRLAP');

8123: --CLOSE csr_plan_type;
8124:
8125: --IF l_other_override_pl_id = l_override_pl_id
8126: --THEN
8127: fnd_message.set_name('PQP','PQP_230010_PLAN_OVRRIDE_OVRLAP');
8128:
8129: --fnd_message.set_token('CURRSTART',p_pei_information1);
8130: --fnd_message.set_token('CURREND',p_pei_information2);
8131: --fnd_message.set_token('OTHERSTART',r_other_override_row.override_start_date_txt);

Line 8129: --fnd_message.set_token('CURRSTART',p_pei_information1);

8125: --IF l_other_override_pl_id = l_override_pl_id
8126: --THEN
8127: fnd_message.set_name('PQP','PQP_230010_PLAN_OVRRIDE_OVRLAP');
8128:
8129: --fnd_message.set_token('CURRSTART',p_pei_information1);
8130: --fnd_message.set_token('CURREND',p_pei_information2);
8131: --fnd_message.set_token('OTHERSTART',r_other_override_row.override_start_date_txt);
8132: --fnd_message.set_token('OTHEREND',r_other_override_row.override_end_date_txt);
8133:

Line 8130: --fnd_message.set_token('CURREND',p_pei_information2);

8126: --THEN
8127: fnd_message.set_name('PQP','PQP_230010_PLAN_OVRRIDE_OVRLAP');
8128:
8129: --fnd_message.set_token('CURRSTART',p_pei_information1);
8130: --fnd_message.set_token('CURREND',p_pei_information2);
8131: --fnd_message.set_token('OTHERSTART',r_other_override_row.override_start_date_txt);
8132: --fnd_message.set_token('OTHEREND',r_other_override_row.override_end_date_txt);
8133:
8134: -- Changed Tokens to refer to Date in Date Format rather

Line 8131: --fnd_message.set_token('OTHERSTART',r_other_override_row.override_start_date_txt);

8127: fnd_message.set_name('PQP','PQP_230010_PLAN_OVRRIDE_OVRLAP');
8128:
8129: --fnd_message.set_token('CURRSTART',p_pei_information1);
8130: --fnd_message.set_token('CURREND',p_pei_information2);
8131: --fnd_message.set_token('OTHERSTART',r_other_override_row.override_start_date_txt);
8132: --fnd_message.set_token('OTHEREND',r_other_override_row.override_end_date_txt);
8133:
8134: -- Changed Tokens to refer to Date in Date Format rather
8135: -- Canonical Format for Bug : 3110889

Line 8132: --fnd_message.set_token('OTHEREND',r_other_override_row.override_end_date_txt);

8128:
8129: --fnd_message.set_token('CURRSTART',p_pei_information1);
8130: --fnd_message.set_token('CURREND',p_pei_information2);
8131: --fnd_message.set_token('OTHERSTART',r_other_override_row.override_start_date_txt);
8132: --fnd_message.set_token('OTHEREND',r_other_override_row.override_end_date_txt);
8133:
8134: -- Changed Tokens to refer to Date in Date Format rather
8135: -- Canonical Format for Bug : 3110889
8136: fnd_message.set_token('CURRSTART',l_override_start_date);

Line 8136: fnd_message.set_token('CURRSTART',l_override_start_date);

8132: --fnd_message.set_token('OTHEREND',r_other_override_row.override_end_date_txt);
8133:
8134: -- Changed Tokens to refer to Date in Date Format rather
8135: -- Canonical Format for Bug : 3110889
8136: fnd_message.set_token('CURRSTART',l_override_start_date);
8137: fnd_message.set_token('CURREND',l_override_end_date);
8138: fnd_message.set_token('OTHERSTART',l_other_override_start_date);
8139: fnd_message.set_token('OTHEREND',l_other_override_end_date);
8140: fnd_message.raise_error;

Line 8137: fnd_message.set_token('CURREND',l_override_end_date);

8133:
8134: -- Changed Tokens to refer to Date in Date Format rather
8135: -- Canonical Format for Bug : 3110889
8136: fnd_message.set_token('CURRSTART',l_override_start_date);
8137: fnd_message.set_token('CURREND',l_override_end_date);
8138: fnd_message.set_token('OTHERSTART',l_other_override_start_date);
8139: fnd_message.set_token('OTHEREND',l_other_override_end_date);
8140: fnd_message.raise_error;
8141: --END IF;

Line 8138: fnd_message.set_token('OTHERSTART',l_other_override_start_date);

8134: -- Changed Tokens to refer to Date in Date Format rather
8135: -- Canonical Format for Bug : 3110889
8136: fnd_message.set_token('CURRSTART',l_override_start_date);
8137: fnd_message.set_token('CURREND',l_override_end_date);
8138: fnd_message.set_token('OTHERSTART',l_other_override_start_date);
8139: fnd_message.set_token('OTHEREND',l_other_override_end_date);
8140: fnd_message.raise_error;
8141: --END IF;
8142:

Line 8139: fnd_message.set_token('OTHEREND',l_other_override_end_date);

8135: -- Canonical Format for Bug : 3110889
8136: fnd_message.set_token('CURRSTART',l_override_start_date);
8137: fnd_message.set_token('CURREND',l_override_end_date);
8138: fnd_message.set_token('OTHERSTART',l_other_override_start_date);
8139: fnd_message.set_token('OTHEREND',l_other_override_end_date);
8140: fnd_message.raise_error;
8141: --END IF;
8142:
8143: END IF;

Line 8140: fnd_message.raise_error;

8136: fnd_message.set_token('CURRSTART',l_override_start_date);
8137: fnd_message.set_token('CURREND',l_override_end_date);
8138: fnd_message.set_token('OTHERSTART',l_other_override_start_date);
8139: fnd_message.set_token('OTHEREND',l_other_override_end_date);
8140: fnd_message.raise_error;
8141: --END IF;
8142:
8143: END IF;
8144:

Line 8286: fnd_message.raise_error;

8282: debug_others(l_proc_name,l_proc_step);
8283: IF g_debug THEN
8284: debug('Leaving: '||l_proc_name,-999);
8285: END IF;
8286: fnd_message.raise_error;
8287: ELSE
8288: RAISE;
8289: END IF;
8290: END get_num_of_ssp_qualifying_days;

Line 8566: fnd_message.raise_error;

8562: debug_others(l_proc_name,l_proc_step);
8563: IF g_debug THEN
8564: debug('Leaving: '||l_proc_name,-999);
8565: END IF;
8566: fnd_message.raise_error;
8567: ELSE
8568: RAISE;
8569: END IF;
8570: END get_number_of_overlap_ssp_days;

Line 8714: fnd_message.raise_error;

8710: debug_others(l_proc_name,l_proc_step);
8711: IF g_debug THEN
8712: debug('Leaving: '||l_proc_name,-999);
8713: END IF;
8714: fnd_message.raise_error;
8715: ELSE
8716: RAISE;
8717: END IF;
8718: END get_ssp_entry_overlap_amount;

Line 9329: fnd_message.raise_error;

9325: debug_others(l_proc_name,l_proc_step);
9326: IF g_debug THEN
9327: debug('Leaving: '||l_proc_name,-999);
9328: END IF;
9329: fnd_message.raise_error;
9330: ELSE
9331: RAISE;
9332: END IF;
9333: END get_range_and_absence_ssp;

Line 9394: fnd_message.raise_error;

9390: debug_others(l_proc_name,l_proc_step);
9391: IF g_debug THEN
9392: debug('Leaving: '||l_proc_name,-999);
9393: END IF;
9394: fnd_message.raise_error;
9395: ELSE
9396: RAISE;
9397: END IF;
9398: END get_absence_ssp;

Line 9516: fnd_message.raise_error;

9512: debug_others(l_proc_name,l_proc_step);
9513: IF g_debug THEN
9514: debug('Leaving: '||l_proc_name,-999);
9515: END IF;
9516: fnd_message.raise_error;
9517: ELSE
9518: RAISE;
9519: END IF;
9520: END get_smp_entry_overlap_amount;

Line 10095: fnd_message.raise_error;

10091: debug_others(l_proc_name,l_proc_step);
10092: IF g_debug THEN
10093: debug('Leaving: '||l_proc_name,-999);
10094: END IF;
10095: fnd_message.raise_error;
10096: ELSE
10097: RAISE;
10098: END IF;
10099: END get_range_and_absence_smp;

Line 10161: fnd_message.raise_error;

10157: debug_others(l_proc_name,l_proc_step);
10158: IF g_debug THEN
10159: debug('Leaving: '||l_proc_name,-999);
10160: END IF;
10161: fnd_message.raise_error;
10162: ELSE
10163: RAISE;
10164: END IF;
10165: END get_absence_smp;

Line 10284: --fnd_message.raise_error;

10280: debug_others(l_proc_name,l_proc_step);
10281: IF g_debug THEN
10282: debug('Leaving: '||l_proc_name,-999);
10283: END IF;
10284: --fnd_message.raise_error;
10285:
10286: RETURN l_error_code;
10287: --ELSE
10288: -- RAISE;

Line 10400: --fnd_message.raise_error;

10396: debug_others(l_proc_name,l_proc_step);
10397: IF g_debug THEN
10398: debug('Leaving: '||l_proc_name,-999);
10399: END IF;
10400: --fnd_message.raise_error;
10401:
10402: RETURN l_error_code;
10403: --ELSE
10404: -- RAISE;

Line 10599: fnd_message.raise_error;

10595: debug_others(l_proc_name,l_proc_step);
10596: IF g_debug THEN
10597: debug('Leaving: '||l_proc_name,-999);
10598: END IF;
10599: fnd_message.raise_error;
10600: ELSE
10601: RAISE;
10602: END IF;
10603: END get_absence_paid_days_tp ;

Line 10739: fnd_message.raise_error;

10735: debug_others(l_proc_name,l_proc_step);
10736: IF g_debug THEN
10737: debug('Leaving: '||l_proc_name,-999);
10738: END IF;
10739: fnd_message.raise_error;
10740: ELSE
10741: RAISE;
10742: END IF;
10743:

Line 10886: fnd_message.raise_error;

10882: debug_others(l_proc_name,l_proc_step);
10883: IF g_debug THEN
10884: debug('Leaving: '||l_proc_name,-999);
10885: END IF;
10886: fnd_message.raise_error;
10887: ELSE
10888: RAISE;
10889: END IF;
10890: END get_entitlements;

Line 10968: fnd_message.raise_error;

10964: debug_others(l_proc_name,l_proc_step);
10965: IF g_debug THEN
10966: debug('Leaving: '||l_proc_name,-999);
10967: END IF;
10968: fnd_message.raise_error;
10969: ELSE
10970: RAISE;
10971: END IF;
10972: END get_minimum_pay_info ;

Line 11029: fnd_message.raise_error;

11025: debug_others(l_proc_name,l_proc_step);
11026: IF g_debug THEN
11027: debug('Leaving: '||l_proc_name,-999);
11028: END IF;
11029: fnd_message.raise_error;
11030: ELSE
11031: RAISE;
11032: END IF;
11033: END get_osp_minimum_pay_rate ;

Line 11189: fnd_message.raise_error;

11185: );
11186: IF g_debug THEN
11187: debug('Leaving: '||l_proc_name,-999);
11188: END IF;
11189: fnd_message.raise_error;
11190: ELSE
11191: RAISE;
11192: END IF;
11193: END set_osp_omp_rounding_factors;

Line 11287: fnd_message.raise_error;

11283: debug_others(l_proc_name,l_proc_step);
11284: IF g_debug THEN
11285: debug('Leaving: '||l_proc_name,-999);
11286: END IF;
11287: fnd_message.raise_error;
11288: ELSE
11289: RAISE;
11290: END IF;
11291: END chk_absence_belongs_to_person ;

Line 11422: fnd_message.raise_error;

11418: debug_others(l_proc_name,l_proc_step);
11419: IF g_debug THEN
11420: debug('Leaving: '||l_proc_name,-999);
11421: END IF;
11422: fnd_message.raise_error;
11423: ELSE
11424: RAISE;
11425: END IF;
11426: END get_absence_statutory_pay ;

Line 11517: fnd_message.raise_error;

11513: debug_others(l_proc_name,l_proc_step);
11514: IF g_debug THEN
11515: debug('Leaving: '||l_proc_name,-999);
11516: END IF;
11517: fnd_message.raise_error;
11518: ELSE
11519: RAISE;
11520: END IF;
11521:

Line 11859: fnd_message.raise_error;

11855: debug_others(l_proc_name,l_proc_step);
11856: IF g_debug THEN
11857: debug('Leaving: '||l_proc_name,-999);
11858: END IF;
11859: fnd_message.raise_error;
11860: ELSE
11861: RAISE;
11862: END IF;
11863: END get_all_band_ent_used_and_rem;

Line 12199: /* fnd_message.raise_error;

12195: debug_others(l_proc_name,l_proc_step);*/
12196: IF g_debug THEN
12197: debug('Leaving: '||l_proc_name,-999);
12198: END IF;
12199: /* fnd_message.raise_error;
12200: ELSE*/
12201: RAISE;
12202: -- END IF;
12203: END get_ssp_smp_paid_days;