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.GHR_CPDF_CHECK8 dependencies on HR_UTILITY

Line 86: hr_utility.set_message(8301,'GHR_37801_ALL_PROCEDURE_FAIL');

82: if not (l_table_pay = to_number(p_to_basic_pay) or
83: p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
84: then
85: GHR_GHRWS52L.CPDF_Parameter_Check;
86: hr_utility.set_message(8301,'GHR_37801_ALL_PROCEDURE_FAIL');
87: hr_utility.raise_error;
88: end if;
89: end if;
90:

Line 87: hr_utility.raise_error;

83: p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
84: then
85: GHR_GHRWS52L.CPDF_Parameter_Check;
86: hr_utility.set_message(8301,'GHR_37801_ALL_PROCEDURE_FAIL');
87: hr_utility.raise_error;
88: end if;
89: end if;
90:
91: -- 650.07.1

Line 113: hr_utility.set_message(8301,'GHR_37804_ALL_PROCEDURE_FAIL');

109: if (l_table_pay <> to_number(p_to_basic_pay) and
110: p_to_basic_pay is not null and
111: to_number(p_to_basic_pay) <> 0) then
112: GHR_GHRWS52L.CPDF_Parameter_Check;
113: hr_utility.set_message(8301,'GHR_37804_ALL_PROCEDURE_FAIL');
114: hr_utility.raise_error;
115: end if;
116: end if;
117:

Line 114: hr_utility.raise_error;

110: p_to_basic_pay is not null and
111: to_number(p_to_basic_pay) <> 0) then
112: GHR_GHRWS52L.CPDF_Parameter_Check;
113: hr_utility.set_message(8301,'GHR_37804_ALL_PROCEDURE_FAIL');
114: hr_utility.raise_error;
115: end if;
116: end if;
117:
118: --650.11.1

Line 134: hr_utility.set_message(8301,'GHR_37057_ALL_PROCEDURE_FAIL');

130: p_to_pay_plan,'Maximum Basic Pay',p_effective_date);
131: if not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
132: then
133: GHR_GHRWS52L.CPDF_Parameter_Check;
134: hr_utility.set_message(8301,'GHR_37057_ALL_PROCEDURE_FAIL');
135: hr_utility.raise_error;
136: end if;
137: end if;
138: end if;

Line 135: hr_utility.raise_error;

131: if not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
132: then
133: GHR_GHRWS52L.CPDF_Parameter_Check;
134: hr_utility.set_message(8301,'GHR_37057_ALL_PROCEDURE_FAIL');
135: hr_utility.raise_error;
136: end if;
137: end if;
138: end if;
139: -- 650.26.3

Line 164: hr_utility.set_message(8301,'GHR_37811_ALL_PROCEDURE_FAIL');

160: ) ;
161: if not (nvl(l_table_pay,0) = to_number(p_to_basic_pay) or
162: (p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)) then
163: GHR_GHRWS52L.CPDF_Parameter_Check;
164: hr_utility.set_message(8301,'GHR_37811_ALL_PROCEDURE_FAIL');
165: hr_utility.raise_error;
166: end if;
167: end if;
168: end if;

Line 165: hr_utility.raise_error;

161: if not (nvl(l_table_pay,0) = to_number(p_to_basic_pay) or
162: (p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)) then
163: GHR_GHRWS52L.CPDF_Parameter_Check;
164: hr_utility.set_message(8301,'GHR_37811_ALL_PROCEDURE_FAIL');
165: hr_utility.raise_error;
166: end if;
167: end if;
168: end if;
169: /* previous code was incorrect

Line 185: hr_utility.set_message(8301,'GHR_37811_ALL_PROCEDURE_FAIL');

181: ) ;
182: if not (l_table_pay = to_number(p_to_basic_pay) or
183: (p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)) then
184: GHR_GHRWS52L.CPDF_Parameter_Check;
185: hr_utility.set_message(8301,'GHR_37811_ALL_PROCEDURE_FAIL');
186: hr_utility.raise_error;
187: end if;
188: end if;
189: */

Line 186: hr_utility.raise_error;

182: if not (l_table_pay = to_number(p_to_basic_pay) or
183: (p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)) then
184: GHR_GHRWS52L.CPDF_Parameter_Check;
185: hr_utility.set_message(8301,'GHR_37811_ALL_PROCEDURE_FAIL');
186: hr_utility.raise_error;
187: end if;
188: end if;
189: */
190:

Line 207: hr_utility.set_message(8301,'GHR_37816_ALL_PROCEDURE_FAIL');

203: 'Maximum Basic Pay',
204: p_effective_date);
205: IF NVL(to_number(p_to_basic_pay), 0) <> max_basic_pay THEN
206: GHR_GHRWS52L.CPDF_Parameter_Check;
207: hr_utility.set_message(8301,'GHR_37816_ALL_PROCEDURE_FAIL');
208: hr_utility.raise_error;
209: END IF;
210: END IF;
211:

Line 208: hr_utility.raise_error;

204: p_effective_date);
205: IF NVL(to_number(p_to_basic_pay), 0) <> max_basic_pay THEN
206: GHR_GHRWS52L.CPDF_Parameter_Check;
207: hr_utility.set_message(8301,'GHR_37816_ALL_PROCEDURE_FAIL');
208: hr_utility.raise_error;
209: END IF;
210: END IF;
211:
212: --650.32.3

Line 229: hr_utility.set_message(8301,'GHR_37425_ALL_PROCEDURE_FAIL');

225: p_to_grade_or_level,'Maximum Basic Pay',p_effective_date);
226: if not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
227: then
228: GHR_GHRWS52L.CPDF_Parameter_Check;
229: hr_utility.set_message(8301,'GHR_37425_ALL_PROCEDURE_FAIL');
230: hr_utility.raise_error;
231: end if;
232: end if;
233: end if;

Line 230: hr_utility.raise_error;

226: if not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
227: then
228: GHR_GHRWS52L.CPDF_Parameter_Check;
229: hr_utility.set_message(8301,'GHR_37425_ALL_PROCEDURE_FAIL');
230: hr_utility.raise_error;
231: end if;
232: end if;
233: end if;
234: -- commented by Raju as it is duplicate

Line 254: hr_utility.set_message(8301,'GHR_37425_ALL_PROCEDURE_FAIL');

250: p_effective_date);
251: if not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
252: then
253: GHR_GHRWS52L.CPDF_Parameter_Check;
254: hr_utility.set_message(8301,'GHR_37425_ALL_PROCEDURE_FAIL');
255: hr_utility.raise_error;
256: end if;
257: end if;
258: end if;

Line 255: hr_utility.raise_error;

251: if not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
252: then
253: GHR_GHRWS52L.CPDF_Parameter_Check;
254: hr_utility.set_message(8301,'GHR_37425_ALL_PROCEDURE_FAIL');
255: hr_utility.raise_error;
256: end if;
257: end if;
258: end if;
259: */

Line 280: hr_utility.set_message(8301,'GHR_37817_ALL_PROCEDURE_FAIL');

276: , p_step_or_rate => p_to_step_or_rate
277: ) ;
278: IF nvl(to_number(p_to_basic_pay), 0) <> l_table_pay THEN
279: GHR_GHRWS52L.CPDF_Parameter_Check;
280: hr_utility.set_message(8301,'GHR_37817_ALL_PROCEDURE_FAIL');
281: hr_utility.raise_error;
282: end if;
283: ELSIF ( p_effective_date >= to_date('2004/01/11', 'yyyy/mm/dd') and
284: p_to_pay_plan IN ('ES', 'FE') and p_rate_determinant_code = '0' )

Line 281: hr_utility.raise_error;

277: ) ;
278: IF nvl(to_number(p_to_basic_pay), 0) <> l_table_pay THEN
279: GHR_GHRWS52L.CPDF_Parameter_Check;
280: hr_utility.set_message(8301,'GHR_37817_ALL_PROCEDURE_FAIL');
281: hr_utility.raise_error;
282: end if;
283: ELSIF ( p_effective_date >= to_date('2004/01/11', 'yyyy/mm/dd') and
284: p_to_pay_plan IN ('ES', 'FE') and p_rate_determinant_code = '0' )
285: THEN

Line 298: hr_utility.set_message(8301,'GHR_38884_ALL_PROCEDURE_FAIL');

294: p_effective_date);
295: if not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
296: then
297: GHR_GHRWS52L.CPDF_Parameter_Check;
298: hr_utility.set_message(8301,'GHR_38884_ALL_PROCEDURE_FAIL');
299: -- NEED TO ADD A NEW MESSAGE HERE
300: hr_utility.raise_error;
301: end if;
302: END IF;

Line 300: hr_utility.raise_error;

296: then
297: GHR_GHRWS52L.CPDF_Parameter_Check;
298: hr_utility.set_message(8301,'GHR_38884_ALL_PROCEDURE_FAIL');
299: -- NEED TO ADD A NEW MESSAGE HERE
300: hr_utility.raise_error;
301: end if;
302: END IF;
303:
304:

Line 326: hr_utility.set_message(8301,'GHR_37818_ALL_PROCEDURE_FAIL');

322: ) ;
323: if not (to_number(p_to_basic_pay) = l_table_pay or
324: (p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)) then
325: GHR_GHRWS52L.CPDF_Parameter_Check;
326: hr_utility.set_message(8301,'GHR_37818_ALL_PROCEDURE_FAIL');
327: hr_utility.raise_error;
328: end if;
329: end if;
330: */

Line 327: hr_utility.raise_error;

323: if not (to_number(p_to_basic_pay) = l_table_pay or
324: (p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)) then
325: GHR_GHRWS52L.CPDF_Parameter_Check;
326: hr_utility.set_message(8301,'GHR_37818_ALL_PROCEDURE_FAIL');
327: hr_utility.raise_error;
328: end if;
329: end if;
330: */
331: -- 650.39.1

Line 353: hr_utility.set_message(8301,'GHR_37819_ALL_PROCEDURE_FAIL');

349: ) ;
350: if not (to_number(p_to_basic_pay) > l_table_pay or
351: (p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)) then
352: GHR_GHRWS52L.CPDF_Parameter_Check;
353: hr_utility.set_message(8301,'GHR_37819_ALL_PROCEDURE_FAIL');
354: hr_utility.set_message_token('COND','exceed');
355: hr_utility.set_message_token('PRD_LIST','5,6 or M');
356: hr_utility.raise_error;
357: end if;

Line 354: hr_utility.set_message_token('COND','exceed');

350: if not (to_number(p_to_basic_pay) > l_table_pay or
351: (p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)) then
352: GHR_GHRWS52L.CPDF_Parameter_Check;
353: hr_utility.set_message(8301,'GHR_37819_ALL_PROCEDURE_FAIL');
354: hr_utility.set_message_token('COND','exceed');
355: hr_utility.set_message_token('PRD_LIST','5,6 or M');
356: hr_utility.raise_error;
357: end if;
358: end if;

Line 355: hr_utility.set_message_token('PRD_LIST','5,6 or M');

351: (p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)) then
352: GHR_GHRWS52L.CPDF_Parameter_Check;
353: hr_utility.set_message(8301,'GHR_37819_ALL_PROCEDURE_FAIL');
354: hr_utility.set_message_token('COND','exceed');
355: hr_utility.set_message_token('PRD_LIST','5,6 or M');
356: hr_utility.raise_error;
357: end if;
358: end if;
359: -- FWFA Changes Bug#4444609

Line 356: hr_utility.raise_error;

352: GHR_GHRWS52L.CPDF_Parameter_Check;
353: hr_utility.set_message(8301,'GHR_37819_ALL_PROCEDURE_FAIL');
354: hr_utility.set_message_token('COND','exceed');
355: hr_utility.set_message_token('PRD_LIST','5,6 or M');
356: hr_utility.raise_error;
357: end if;
358: end if;
359: -- FWFA Changes Bug#4444609
360: ELSIF p_effective_date >= to_date('2005/05/01','YYYY/MM/DD') THEN

Line 378: hr_utility.set_message(8301,'GHR_37819_ALL_PROCEDURE_FAIL');

374: ) ;
375: if not (to_number(p_to_basic_pay) >= l_table_pay or
376: (p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)) then
377: GHR_GHRWS52L.CPDF_Parameter_Check;
378: hr_utility.set_message(8301,'GHR_37819_ALL_PROCEDURE_FAIL');
379: hr_utility.set_message_token('COND','equal or exceed');
380: hr_utility.set_message_token('PRD_LIST','5 or 6');
381: hr_utility.raise_error;
382: end if;

Line 379: hr_utility.set_message_token('COND','equal or exceed');

375: if not (to_number(p_to_basic_pay) >= l_table_pay or
376: (p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)) then
377: GHR_GHRWS52L.CPDF_Parameter_Check;
378: hr_utility.set_message(8301,'GHR_37819_ALL_PROCEDURE_FAIL');
379: hr_utility.set_message_token('COND','equal or exceed');
380: hr_utility.set_message_token('PRD_LIST','5 or 6');
381: hr_utility.raise_error;
382: end if;
383: end if;

Line 380: hr_utility.set_message_token('PRD_LIST','5 or 6');

376: (p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)) then
377: GHR_GHRWS52L.CPDF_Parameter_Check;
378: hr_utility.set_message(8301,'GHR_37819_ALL_PROCEDURE_FAIL');
379: hr_utility.set_message_token('COND','equal or exceed');
380: hr_utility.set_message_token('PRD_LIST','5 or 6');
381: hr_utility.raise_error;
382: end if;
383: end if;
384: END IF;

Line 381: hr_utility.raise_error;

377: GHR_GHRWS52L.CPDF_Parameter_Check;
378: hr_utility.set_message(8301,'GHR_37819_ALL_PROCEDURE_FAIL');
379: hr_utility.set_message_token('COND','equal or exceed');
380: hr_utility.set_message_token('PRD_LIST','5 or 6');
381: hr_utility.raise_error;
382: end if;
383: end if;
384: END IF;
385: -- FWFA Changes Bug#4444609

Line 409: hr_utility.set_message(8301,'GHR_38983_ALL_PROCEDURE_FAIL');

405: (l_table_pay > to_number(p_to_basic_pay)) and
406: (p_to_basic_pay is not null or to_number(p_to_basic_pay) <> '0')
407: ) then
408: GHR_GHRWS52L.CPDF_Parameter_Check;
409: hr_utility.set_message(8301,'GHR_38983_ALL_PROCEDURE_FAIL');
410: hr_utility.raise_error;
411: end if;
412: end if;
413: END IF;

Line 410: hr_utility.raise_error;

406: (p_to_basic_pay is not null or to_number(p_to_basic_pay) <> '0')
407: ) then
408: GHR_GHRWS52L.CPDF_Parameter_Check;
409: hr_utility.set_message(8301,'GHR_38983_ALL_PROCEDURE_FAIL');
410: hr_utility.raise_error;
411: end if;
412: end if;
413: END IF;
414:

Line 436: hr_utility.set_message(8301,'GHR_37427_ALL_PROCEDURE_FAIL');

432: p_effective_date);
433: if not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
434: then
435: GHR_GHRWS52L.CPDF_Parameter_Check;
436: hr_utility.set_message(8301,'GHR_37427_ALL_PROCEDURE_FAIL');
437: hr_utility.raise_error;
438: end if;
439: end if;
440: end if;

Line 437: hr_utility.raise_error;

433: if not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
434: then
435: GHR_GHRWS52L.CPDF_Parameter_Check;
436: hr_utility.set_message(8301,'GHR_37427_ALL_PROCEDURE_FAIL');
437: hr_utility.raise_error;
438: end if;
439: end if;
440: end if;
441:

Line 465: hr_utility.set_message(8301,'GHR_37428_ALL_PROCEDURE_FAIL');

461: p_effective_date);
462: if not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
463: then
464: GHR_GHRWS52L.CPDF_Parameter_Check;
465: hr_utility.set_message(8301,'GHR_37428_ALL_PROCEDURE_FAIL');
466: hr_utility.raise_error;
467: end if;
468: end if;
469: end if;

Line 466: hr_utility.raise_error;

462: if not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
463: then
464: GHR_GHRWS52L.CPDF_Parameter_Check;
465: hr_utility.set_message(8301,'GHR_37428_ALL_PROCEDURE_FAIL');
466: hr_utility.raise_error;
467: end if;
468: end if;
469: end if;
470: end if;

Line 489: hr_utility.set_message(8301,'GHR_37852_ALL_PROCEDURE_FAIL');

485: , p_grade_or_level => '11'
486: , p_step_or_rate => '10') ;
487: if l_table_pay < to_number(p_to_basic_pay) then
488: GHR_GHRWS52L.CPDF_Parameter_Check;
489: hr_utility.set_message(8301,'GHR_37852_ALL_PROCEDURE_FAIL');
490: hr_utility.raise_error;
491: end if;
492: end if;
493: end if;

Line 490: hr_utility.raise_error;

486: , p_step_or_rate => '10') ;
487: if l_table_pay < to_number(p_to_basic_pay) then
488: GHR_GHRWS52L.CPDF_Parameter_Check;
489: hr_utility.set_message(8301,'GHR_37852_ALL_PROCEDURE_FAIL');
490: hr_utility.raise_error;
491: end if;
492: end if;
493: end if;
494: -- 650.89.1

Line 525: hr_utility.set_message(8301,'GHR_37844_ALL_PROCEDURE_FAIL');

521: (nvl(l_table_pay,0) < to_number(p_to_basic_pay)) or
522: (p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
523: ) then
524: GHR_GHRWS52L.CPDF_Parameter_Check;
525: hr_utility.set_message(8301,'GHR_37844_ALL_PROCEDURE_FAIL');
526: hr_utility.set_message_token('COND','exceed');
527: hr_utility.set_message_token('PRD_LIST','E, F or M');
528: hr_utility.raise_error;
529: end if;

Line 526: hr_utility.set_message_token('COND','exceed');

522: (p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
523: ) then
524: GHR_GHRWS52L.CPDF_Parameter_Check;
525: hr_utility.set_message(8301,'GHR_37844_ALL_PROCEDURE_FAIL');
526: hr_utility.set_message_token('COND','exceed');
527: hr_utility.set_message_token('PRD_LIST','E, F or M');
528: hr_utility.raise_error;
529: end if;
530: end if;

Line 527: hr_utility.set_message_token('PRD_LIST','E, F or M');

523: ) then
524: GHR_GHRWS52L.CPDF_Parameter_Check;
525: hr_utility.set_message(8301,'GHR_37844_ALL_PROCEDURE_FAIL');
526: hr_utility.set_message_token('COND','exceed');
527: hr_utility.set_message_token('PRD_LIST','E, F or M');
528: hr_utility.raise_error;
529: end if;
530: end if;
531: -- FWFA Changes

Line 528: hr_utility.raise_error;

524: GHR_GHRWS52L.CPDF_Parameter_Check;
525: hr_utility.set_message(8301,'GHR_37844_ALL_PROCEDURE_FAIL');
526: hr_utility.set_message_token('COND','exceed');
527: hr_utility.set_message_token('PRD_LIST','E, F or M');
528: hr_utility.raise_error;
529: end if;
530: end if;
531: -- FWFA Changes
532: ELSIF p_effective_date >= to_date('2005/05/01','YYYY/MM/DD') THEN

Line 550: hr_utility.set_message(8301,'GHR_37844_ALL_PROCEDURE_FAIL');

546: (nvl(l_table_pay,0) <= to_number(p_to_basic_pay)) or
547: (p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
548: ) then
549: GHR_GHRWS52L.CPDF_Parameter_Check;
550: hr_utility.set_message(8301,'GHR_37844_ALL_PROCEDURE_FAIL');
551: hr_utility.set_message_token('COND','equal or exceed');
552: hr_utility.set_message_token('PRD_LIST','E or F');
553: hr_utility.raise_error;
554: end if;

Line 551: hr_utility.set_message_token('COND','equal or exceed');

547: (p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
548: ) then
549: GHR_GHRWS52L.CPDF_Parameter_Check;
550: hr_utility.set_message(8301,'GHR_37844_ALL_PROCEDURE_FAIL');
551: hr_utility.set_message_token('COND','equal or exceed');
552: hr_utility.set_message_token('PRD_LIST','E or F');
553: hr_utility.raise_error;
554: end if;
555: end if;

Line 552: hr_utility.set_message_token('PRD_LIST','E or F');

548: ) then
549: GHR_GHRWS52L.CPDF_Parameter_Check;
550: hr_utility.set_message(8301,'GHR_37844_ALL_PROCEDURE_FAIL');
551: hr_utility.set_message_token('COND','equal or exceed');
552: hr_utility.set_message_token('PRD_LIST','E or F');
553: hr_utility.raise_error;
554: end if;
555: end if;
556: END IF;

Line 553: hr_utility.raise_error;

549: GHR_GHRWS52L.CPDF_Parameter_Check;
550: hr_utility.set_message(8301,'GHR_37844_ALL_PROCEDURE_FAIL');
551: hr_utility.set_message_token('COND','equal or exceed');
552: hr_utility.set_message_token('PRD_LIST','E or F');
553: hr_utility.raise_error;
554: end if;
555: end if;
556: END IF;
557: -- FWFA Changes

Line 580: hr_utility.set_message(8301,'GHR_37837_ALL_PROCEDURE_FAIL');

576: if not (
577: (l_table_pay = to_number(p_to_basic_pay)) or (p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
578: ) then
579: GHR_GHRWS52L.CPDF_Parameter_Check;
580: hr_utility.set_message(8301,'GHR_37837_ALL_PROCEDURE_FAIL');
581: hr_utility.raise_error;
582: end if;
583: end if;
584: */

Line 581: hr_utility.raise_error;

577: (l_table_pay = to_number(p_to_basic_pay)) or (p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
578: ) then
579: GHR_GHRWS52L.CPDF_Parameter_Check;
580: hr_utility.set_message(8301,'GHR_37837_ALL_PROCEDURE_FAIL');
581: hr_utility.raise_error;
582: end if;
583: end if;
584: */
585:

Line 607: hr_utility.set_message(8301,'GHR_37838_ALL_PROCEDURE_FAIL');

603: (nvl(l_table_pay,0) < to_number(p_to_basic_pay)) or
604: (p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
605: ) then
606: GHR_GHRWS52L.CPDF_Parameter_Check;
607: hr_utility.set_message(8301,'GHR_37838_ALL_PROCEDURE_FAIL');
608: hr_utility.raise_error;
609: end if;
610: end if;
611: */

Line 608: hr_utility.raise_error;

604: (p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
605: ) then
606: GHR_GHRWS52L.CPDF_Parameter_Check;
607: hr_utility.set_message(8301,'GHR_37838_ALL_PROCEDURE_FAIL');
608: hr_utility.raise_error;
609: end if;
610: end if;
611: */
612: -- Added on 10-Oct-05 by Utokachi for Validate actions after 01-MAY-2005

Line 631: hr_utility.set_message(8301,'GHR_37838_ALL_PROCEDURE_FAIL');

627: (nvl(l_table_pay,0) <= to_number(p_to_basic_pay)) or
628: (p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
629: ) then
630: GHR_GHRWS52L.CPDF_Parameter_Check;
631: hr_utility.set_message(8301,'GHR_37838_ALL_PROCEDURE_FAIL');
632: hr_utility.raise_error;
633: end if;
634: end if;
635: END IF;

Line 632: hr_utility.raise_error;

628: (p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
629: ) then
630: GHR_GHRWS52L.CPDF_Parameter_Check;
631: hr_utility.set_message(8301,'GHR_37838_ALL_PROCEDURE_FAIL');
632: hr_utility.raise_error;
633: end if;
634: end if;
635: END IF;
636: --FWFA Changes

Line 659: hr_utility.set_message(8301,'GHR_37839_ALL_PROCEDURE_FAIL');

655: (l_table_pay < to_number(p_to_basic_pay)) or
656: (p_to_basic_pay is null or to_number(p_to_basic_pay) = '0')
657: ) then
658: GHR_GHRWS52L.CPDF_Parameter_Check;
659: hr_utility.set_message(8301,'GHR_37839_ALL_PROCEDURE_FAIL');
660: hr_utility.set_message_token('COND','exceed');
661: hr_utility.set_message_token('PRD_LIST','5,6 or M');
662: hr_utility.raise_error;
663: end if;

Line 660: hr_utility.set_message_token('COND','exceed');

656: (p_to_basic_pay is null or to_number(p_to_basic_pay) = '0')
657: ) then
658: GHR_GHRWS52L.CPDF_Parameter_Check;
659: hr_utility.set_message(8301,'GHR_37839_ALL_PROCEDURE_FAIL');
660: hr_utility.set_message_token('COND','exceed');
661: hr_utility.set_message_token('PRD_LIST','5,6 or M');
662: hr_utility.raise_error;
663: end if;
664: end if;

Line 661: hr_utility.set_message_token('PRD_LIST','5,6 or M');

657: ) then
658: GHR_GHRWS52L.CPDF_Parameter_Check;
659: hr_utility.set_message(8301,'GHR_37839_ALL_PROCEDURE_FAIL');
660: hr_utility.set_message_token('COND','exceed');
661: hr_utility.set_message_token('PRD_LIST','5,6 or M');
662: hr_utility.raise_error;
663: end if;
664: end if;
665: ELSE

Line 662: hr_utility.raise_error;

658: GHR_GHRWS52L.CPDF_Parameter_Check;
659: hr_utility.set_message(8301,'GHR_37839_ALL_PROCEDURE_FAIL');
660: hr_utility.set_message_token('COND','exceed');
661: hr_utility.set_message_token('PRD_LIST','5,6 or M');
662: hr_utility.raise_error;
663: end if;
664: end if;
665: ELSE
666: if p_to_step_or_rate between '01' and '10' and

Line 680: hr_utility.set_message(8301,'GHR_37839_ALL_PROCEDURE_FAIL');

676: (l_table_pay <= to_number(p_to_basic_pay)) or
677: (p_to_basic_pay is null or to_number(p_to_basic_pay) = '0')
678: ) then
679: GHR_GHRWS52L.CPDF_Parameter_Check;
680: hr_utility.set_message(8301,'GHR_37839_ALL_PROCEDURE_FAIL');
681: hr_utility.set_message_token('COND','equal or exceed');
682: hr_utility.set_message_token('PRD_LIST','5 or 6');
683: hr_utility.raise_error;
684: end if;

Line 681: hr_utility.set_message_token('COND','equal or exceed');

677: (p_to_basic_pay is null or to_number(p_to_basic_pay) = '0')
678: ) then
679: GHR_GHRWS52L.CPDF_Parameter_Check;
680: hr_utility.set_message(8301,'GHR_37839_ALL_PROCEDURE_FAIL');
681: hr_utility.set_message_token('COND','equal or exceed');
682: hr_utility.set_message_token('PRD_LIST','5 or 6');
683: hr_utility.raise_error;
684: end if;
685: end if;

Line 682: hr_utility.set_message_token('PRD_LIST','5 or 6');

678: ) then
679: GHR_GHRWS52L.CPDF_Parameter_Check;
680: hr_utility.set_message(8301,'GHR_37839_ALL_PROCEDURE_FAIL');
681: hr_utility.set_message_token('COND','equal or exceed');
682: hr_utility.set_message_token('PRD_LIST','5 or 6');
683: hr_utility.raise_error;
684: end if;
685: end if;
686: END IF;

Line 683: hr_utility.raise_error;

679: GHR_GHRWS52L.CPDF_Parameter_Check;
680: hr_utility.set_message(8301,'GHR_37839_ALL_PROCEDURE_FAIL');
681: hr_utility.set_message_token('COND','equal or exceed');
682: hr_utility.set_message_token('PRD_LIST','5 or 6');
683: hr_utility.raise_error;
684: end if;
685: end if;
686: END IF;
687: -- FWFA Changes

Line 710: hr_utility.set_message(8301,'GHR_38984_ALL_PROCEDURE_FAIL');

706: (l_table_pay > to_number(p_to_basic_pay)) or
707: (p_to_basic_pay is not null or to_number(p_to_basic_pay) <> '0')
708: ) then
709: GHR_GHRWS52L.CPDF_Parameter_Check;
710: hr_utility.set_message(8301,'GHR_38984_ALL_PROCEDURE_FAIL');
711: hr_utility.raise_error;
712: end if;
713: end if;
714: END If;

Line 711: hr_utility.raise_error;

707: (p_to_basic_pay is not null or to_number(p_to_basic_pay) <> '0')
708: ) then
709: GHR_GHRWS52L.CPDF_Parameter_Check;
710: hr_utility.set_message(8301,'GHR_38984_ALL_PROCEDURE_FAIL');
711: hr_utility.raise_error;
712: end if;
713: end if;
714: END If;
715:

Line 746: hr_utility.set_message(8301,'GHR_37886_ALL_PROCEDURE_FAIL');

742: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
743: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
744: then
745: GHR_GHRWS52L.CPDF_Parameter_Check;
746: hr_utility.set_message(8301,'GHR_37886_ALL_PROCEDURE_FAIL');
747: hr_utility.raise_error;
748: end if;
749: end if;
750: */

Line 747: hr_utility.raise_error;

743: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
744: then
745: GHR_GHRWS52L.CPDF_Parameter_Check;
746: hr_utility.set_message(8301,'GHR_37886_ALL_PROCEDURE_FAIL');
747: hr_utility.raise_error;
748: end if;
749: end if;
750: */
751:

Line 774: hr_utility.set_message(8301,'GHR_37802_ALL_PROCEDURE_FAIL');

770: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
771: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
772: then
773: GHR_GHRWS52L.CPDF_Parameter_Check;
774: hr_utility.set_message(8301,'GHR_37802_ALL_PROCEDURE_FAIL');
775: hr_utility.raise_error;
776: end if;
777: end if;
778: end if;

Line 775: hr_utility.raise_error;

771: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
772: then
773: GHR_GHRWS52L.CPDF_Parameter_Check;
774: hr_utility.set_message(8301,'GHR_37802_ALL_PROCEDURE_FAIL');
775: hr_utility.raise_error;
776: end if;
777: end if;
778: end if;
779:

Line 802: hr_utility.set_message(8301,'GHR_37803_ALL_PROCEDURE_FAIL');

798: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
799: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
800: then
801: GHR_GHRWS52L.CPDF_Parameter_Check;
802: hr_utility.set_message(8301,'GHR_37803_ALL_PROCEDURE_FAIL');
803: hr_utility.raise_error;
804: end if;
805: end if;
806: end if;

Line 803: hr_utility.raise_error;

799: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
800: then
801: GHR_GHRWS52L.CPDF_Parameter_Check;
802: hr_utility.set_message(8301,'GHR_37803_ALL_PROCEDURE_FAIL');
803: hr_utility.raise_error;
804: end if;
805: end if;
806: end if;
807:

Line 838: hr_utility.set_message(8301,'GHR_37863_ALL_PROCEDURE_FAIL');

834: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
835: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
836: then
837: GHR_GHRWS52L.CPDF_Parameter_Check;
838: hr_utility.set_message(8301,'GHR_37863_ALL_PROCEDURE_FAIL');
839: hr_utility.raise_error;
840: end if;
841: end if;
842: */

Line 839: hr_utility.raise_error;

835: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
836: then
837: GHR_GHRWS52L.CPDF_Parameter_Check;
838: hr_utility.set_message(8301,'GHR_37863_ALL_PROCEDURE_FAIL');
839: hr_utility.raise_error;
840: end if;
841: end if;
842: */
843:

Line 874: hr_utility.set_message(8301,'GHR_37864_ALL_PROCEDURE_FAIL');

870: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
871: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
872: then
873: GHR_GHRWS52L.CPDF_Parameter_Check;
874: hr_utility.set_message(8301,'GHR_37864_ALL_PROCEDURE_FAIL');
875: hr_utility.raise_error;
876: end if;
877: end if;
878: */

Line 875: hr_utility.raise_error;

871: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
872: then
873: GHR_GHRWS52L.CPDF_Parameter_Check;
874: hr_utility.set_message(8301,'GHR_37864_ALL_PROCEDURE_FAIL');
875: hr_utility.raise_error;
876: end if;
877: end if;
878: */
879:

Line 905: hr_utility.set_message(8301,'GHR_37805_ALL_PROCEDURE_FAIL');

901: (not(to_number(p_to_basic_pay) >= min_basic_pay)
902: or (p_to_basic_pay is null and p_first_noac_lookup_code <> '817' ))
903: then
904: GHR_GHRWS52L.CPDF_Parameter_Check;
905: hr_utility.set_message(8301,'GHR_37805_ALL_PROCEDURE_FAIL');
906: hr_utility.raise_error;
907: end if;
908: end if;
909:

Line 906: hr_utility.raise_error;

902: or (p_to_basic_pay is null and p_first_noac_lookup_code <> '817' ))
903: then
904: GHR_GHRWS52L.CPDF_Parameter_Check;
905: hr_utility.set_message(8301,'GHR_37805_ALL_PROCEDURE_FAIL');
906: hr_utility.raise_error;
907: end if;
908: end if;
909:
910: /*650.16.1 If pay rate determinant is U or V,

Line 932: hr_utility.set_message(8301,'GHR_37806_ALL_PROCEDURE_FAIL');

928: (not(to_number(p_to_basic_pay) >= min_basic_pay)
929: or p_to_basic_pay is null)
930: then
931: GHR_GHRWS52L.CPDF_Parameter_Check;
932: hr_utility.set_message(8301,'GHR_37806_ALL_PROCEDURE_FAIL');
933: hr_utility.raise_error;
934: end if;
935: end if;
936: */

Line 933: hr_utility.raise_error;

929: or p_to_basic_pay is null)
930: then
931: GHR_GHRWS52L.CPDF_Parameter_Check;
932: hr_utility.set_message(8301,'GHR_37806_ALL_PROCEDURE_FAIL');
933: hr_utility.raise_error;
934: end if;
935: end if;
936: */
937:

Line 961: hr_utility.set_message(8301,'GHR_37807_ALL_PROCEDURE_FAIL');

957: and (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
958: or p_to_basic_pay is null)
959: then
960: GHR_GHRWS52L.CPDF_Parameter_Check;
961: hr_utility.set_message(8301,'GHR_37807_ALL_PROCEDURE_FAIL');
962: hr_utility.raise_error;
963: end if;
964: end if;
965: */

Line 962: hr_utility.raise_error;

958: or p_to_basic_pay is null)
959: then
960: GHR_GHRWS52L.CPDF_Parameter_Check;
961: hr_utility.set_message(8301,'GHR_37807_ALL_PROCEDURE_FAIL');
962: hr_utility.raise_error;
963: end if;
964: end if;
965: */
966:

Line 989: hr_utility.set_message(8301,'GHR_37429_ALL_PROCEDURE_FAIL');

985: and (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
986: or p_to_basic_pay is null)
987: then
988: GHR_GHRWS52L.CPDF_Parameter_Check;
989: hr_utility.set_message(8301,'GHR_37429_ALL_PROCEDURE_FAIL');
990: hr_utility.raise_error;
991: end if;
992: end if;
993: --Commented as per EOY 2003 cpdf changes by Ashley

Line 990: hr_utility.raise_error;

986: or p_to_basic_pay is null)
987: then
988: GHR_GHRWS52L.CPDF_Parameter_Check;
989: hr_utility.set_message(8301,'GHR_37429_ALL_PROCEDURE_FAIL');
990: hr_utility.raise_error;
991: end if;
992: end if;
993: --Commented as per EOY 2003 cpdf changes by Ashley
994: /*650.20.1 If pay plan is GM,

Line 1015: hr_utility.set_message(8301,'GHR_37808_ALL_PROCEDURE_FAIL');

1011: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
1012: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
1013: then
1014: GHR_GHRWS52L.CPDF_Parameter_Check;
1015: hr_utility.set_message(8301,'GHR_37808_ALL_PROCEDURE_FAIL');
1016: hr_utility.raise_error;
1017: end if;
1018: end if;*/
1019:

Line 1016: hr_utility.raise_error;

1012: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
1013: then
1014: GHR_GHRWS52L.CPDF_Parameter_Check;
1015: hr_utility.set_message(8301,'GHR_37808_ALL_PROCEDURE_FAIL');
1016: hr_utility.raise_error;
1017: end if;
1018: end if;*/
1019:
1020: /*

Line 1041: hr_utility.set_message(8301,'GHR_37751_ALL_PROCEDURE_FAIL');

1037:
1038: if not (nvl(l_table_pay,0) = to_number(p_to_basic_pay) or
1039: (p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)) THEN
1040: GHR_GHRWS52L.CPDF_Parameter_Check;
1041: hr_utility.set_message(8301,'GHR_37751_ALL_PROCEDURE_FAIL');
1042: hr_utility.raise_error;
1043: end if;
1044: end if;
1045:

Line 1042: hr_utility.raise_error;

1038: if not (nvl(l_table_pay,0) = to_number(p_to_basic_pay) or
1039: (p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)) THEN
1040: GHR_GHRWS52L.CPDF_Parameter_Check;
1041: hr_utility.set_message(8301,'GHR_37751_ALL_PROCEDURE_FAIL');
1042: hr_utility.raise_error;
1043: end if;
1044: end if;
1045:
1046: END IF;

Line 1079: hr_utility.set_message(8301,'GHR_37433_ALL_PROCEDURE_FAIL');

1075: or p_to_basic_pay is null
1076: or to_number(p_to_basic_pay) = 0)
1077: then
1078: GHR_GHRWS52L.CPDF_Parameter_Check;
1079: hr_utility.set_message(8301,'GHR_37433_ALL_PROCEDURE_FAIL');
1080: hr_utility.raise_error;
1081: end if;
1082: end if;
1083: else

Line 1080: hr_utility.raise_error;

1076: or to_number(p_to_basic_pay) = 0)
1077: then
1078: GHR_GHRWS52L.CPDF_Parameter_Check;
1079: hr_utility.set_message(8301,'GHR_37433_ALL_PROCEDURE_FAIL');
1080: hr_utility.raise_error;
1081: end if;
1082: end if;
1083: else
1084: if p_to_pay_plan in ('GH','GM')

Line 1104: hr_utility.set_message(8301,'GHR_37809_ALL_PROCEDURE_FAIL');

1100: or p_to_basic_pay is null
1101: or to_number(p_to_basic_pay) = 0)
1102: then
1103: GHR_GHRWS52L.CPDF_Parameter_Check;
1104: hr_utility.set_message(8301,'GHR_37809_ALL_PROCEDURE_FAIL');
1105: hr_utility.raise_error;
1106: end if;
1107: end if;
1108: end if;

Line 1105: hr_utility.raise_error;

1101: or to_number(p_to_basic_pay) = 0)
1102: then
1103: GHR_GHRWS52L.CPDF_Parameter_Check;
1104: hr_utility.set_message(8301,'GHR_37809_ALL_PROCEDURE_FAIL');
1105: hr_utility.raise_error;
1106: end if;
1107: end if;
1108: end if;
1109: */

Line 1133: hr_utility.set_message(8301,'GHR_37810_ALL_PROCEDURE_FAIL');

1129: (not(to_number(p_to_basic_pay) >= min_basic_pay)
1130: or p_to_basic_pay is null)
1131: then
1132: GHR_GHRWS52L.CPDF_Parameter_Check;
1133: hr_utility.set_message(8301,'GHR_37810_ALL_PROCEDURE_FAIL');
1134: hr_utility.raise_error;
1135: end if;
1136: end if;
1137:

Line 1134: hr_utility.raise_error;

1130: or p_to_basic_pay is null)
1131: then
1132: GHR_GHRWS52L.CPDF_Parameter_Check;
1133: hr_utility.set_message(8301,'GHR_37810_ALL_PROCEDURE_FAIL');
1134: hr_utility.raise_error;
1135: end if;
1136: end if;
1137:
1138: --Begin Bug# 9255822

Line 1157: hr_utility.set_message(8301,'GHR_38381_ALL_PROCEDURE_FAIL');

1153: (not(to_number(p_to_basic_pay) >= min_basic_pay)
1154: or p_to_basic_pay is null)
1155: then
1156: GHR_GHRWS52L.CPDF_Parameter_Check;
1157: hr_utility.set_message(8301,'GHR_38381_ALL_PROCEDURE_FAIL');
1158: hr_utility.raise_error;
1159: end if;
1160: end if;
1161: -- End Bug# 9255822

Line 1158: hr_utility.raise_error;

1154: or p_to_basic_pay is null)
1155: then
1156: GHR_GHRWS52L.CPDF_Parameter_Check;
1157: hr_utility.set_message(8301,'GHR_38381_ALL_PROCEDURE_FAIL');
1158: hr_utility.raise_error;
1159: end if;
1160: end if;
1161: -- End Bug# 9255822
1162:

Line 1188: hr_utility.set_message(8301,'GHR_37812_ALL_PROCEDURE_FAIL');

1184: if (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
1185: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
1186: then
1187: GHR_GHRWS52L.CPDF_Parameter_Check;
1188: hr_utility.set_message(8301,'GHR_37812_ALL_PROCEDURE_FAIL');
1189: hr_utility.raise_error;
1190: end if;
1191: end if;
1192: end if;

Line 1189: hr_utility.raise_error;

1185: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
1186: then
1187: GHR_GHRWS52L.CPDF_Parameter_Check;
1188: hr_utility.set_message(8301,'GHR_37812_ALL_PROCEDURE_FAIL');
1189: hr_utility.raise_error;
1190: end if;
1191: end if;
1192: end if;
1193: END IF;

Line 1216: hr_utility.set_message(8301,'GHR_37813_ALL_PROCEDURE_FAIL');

1212: if (not (to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
1213: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
1214: then
1215: GHR_GHRWS52L.CPDF_Parameter_Check;
1216: hr_utility.set_message(8301,'GHR_37813_ALL_PROCEDURE_FAIL');
1217: hr_utility.raise_error;
1218: end if;
1219: end if;
1220: end if;

Line 1217: hr_utility.raise_error;

1213: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
1214: then
1215: GHR_GHRWS52L.CPDF_Parameter_Check;
1216: hr_utility.set_message(8301,'GHR_37813_ALL_PROCEDURE_FAIL');
1217: hr_utility.raise_error;
1218: end if;
1219: end if;
1220: end if;
1221: end if;

Line 1248: hr_utility.set_message(8301,'GHR_37814_ALL_PROCEDURE_FAIL');

1244: if (not (to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
1245: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
1246: then
1247: GHR_GHRWS52L.CPDF_Parameter_Check;
1248: hr_utility.set_message(8301,'GHR_37814_ALL_PROCEDURE_FAIL');
1249: hr_utility.raise_error;
1250: end if;
1251: end if;
1252: end if; */

Line 1249: hr_utility.raise_error;

1245: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
1246: then
1247: GHR_GHRWS52L.CPDF_Parameter_Check;
1248: hr_utility.set_message(8301,'GHR_37814_ALL_PROCEDURE_FAIL');
1249: hr_utility.raise_error;
1250: end if;
1251: end if;
1252: end if; */
1253: -----------------------------------------------------------------------------------------------------------

Line 1280: hr_utility.set_message(8301,'GHR_37435_ALL_PROCEDURE_FAIL');

1276: and (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
1277: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
1278: then
1279: GHR_GHRWS52L.CPDF_Parameter_Check;
1280: hr_utility.set_message(8301,'GHR_37435_ALL_PROCEDURE_FAIL');
1281: hr_utility.raise_error;
1282: end if;
1283: end if;
1284: end if;

Line 1281: hr_utility.raise_error;

1277: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
1278: then
1279: GHR_GHRWS52L.CPDF_Parameter_Check;
1280: hr_utility.set_message(8301,'GHR_37435_ALL_PROCEDURE_FAIL');
1281: hr_utility.raise_error;
1282: end if;
1283: end if;
1284: end if;
1285: else

Line 1301: hr_utility.set_message(8301,'GHR_37815_ALL_PROCEDURE_FAIL');

1297: and (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
1298: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
1299: then
1300: GHR_GHRWS52L.CPDF_Parameter_Check;
1301: hr_utility.set_message(8301,'GHR_37815_ALL_PROCEDURE_FAIL');
1302: hr_utility.raise_error;
1303: end if;
1304: end if;
1305: end if;

Line 1302: hr_utility.raise_error;

1298: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
1299: then
1300: GHR_GHRWS52L.CPDF_Parameter_Check;
1301: hr_utility.set_message(8301,'GHR_37815_ALL_PROCEDURE_FAIL');
1302: hr_utility.raise_error;
1303: end if;
1304: end if;
1305: end if;
1306: end if;

Line 1332: hr_utility.set_message(8301,'GHR_37854_ALL_PROCEDURE_FAIL');

1328: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
1329: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
1330: then
1331: GHR_GHRWS52L.CPDF_Parameter_Check;
1332: hr_utility.set_message(8301,'GHR_37854_ALL_PROCEDURE_FAIL');
1333: hr_utility.raise_error;
1334: end if;
1335: end if;
1336: */

Line 1333: hr_utility.raise_error;

1329: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
1330: then
1331: GHR_GHRWS52L.CPDF_Parameter_Check;
1332: hr_utility.set_message(8301,'GHR_37854_ALL_PROCEDURE_FAIL');
1333: hr_utility.raise_error;
1334: end if;
1335: end if;
1336: */
1337:

Line 1362: hr_utility.set_message(8301,'GHR_37855_ALL_PROCEDURE_FAIL');

1358: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
1359: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
1360: then
1361: GHR_GHRWS52L.CPDF_Parameter_Check;
1362: hr_utility.set_message(8301,'GHR_37855_ALL_PROCEDURE_FAIL');
1363: hr_utility.raise_error;
1364: end if;
1365: end if;
1366: */

Line 1363: hr_utility.raise_error;

1359: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
1360: then
1361: GHR_GHRWS52L.CPDF_Parameter_Check;
1362: hr_utility.set_message(8301,'GHR_37855_ALL_PROCEDURE_FAIL');
1363: hr_utility.raise_error;
1364: end if;
1365: end if;
1366: */
1367:

Line 1388: hr_utility.set_message(8301,'GHR_37820_ALL_PROCEDURE_FAIL');

1384: (not(to_number(p_to_basic_pay) < max_basic_pay)
1385: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
1386: then
1387: GHR_GHRWS52L.CPDF_Parameter_Check;
1388: hr_utility.set_message(8301,'GHR_37820_ALL_PROCEDURE_FAIL');
1389: hr_utility.raise_error;
1390: end if;
1391: end if;
1392: */

Line 1389: hr_utility.raise_error;

1385: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
1386: then
1387: GHR_GHRWS52L.CPDF_Parameter_Check;
1388: hr_utility.set_message(8301,'GHR_37820_ALL_PROCEDURE_FAIL');
1389: hr_utility.raise_error;
1390: end if;
1391: end if;
1392: */
1393: /*650.42.1 If pay plan is GG,

Line 1414: hr_utility.set_message(8301,'GHR_37821_ALL_PROCEDURE_FAIL');

1410: and (not(to_number(p_to_basic_pay) >= min_basic_pay)
1411: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
1412: then
1413: GHR_GHRWS52L.CPDF_Parameter_Check;
1414: hr_utility.set_message(8301,'GHR_37821_ALL_PROCEDURE_FAIL');
1415: hr_utility.raise_error;
1416: end if;
1417: end if;
1418:

Line 1415: hr_utility.raise_error;

1411: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
1412: then
1413: GHR_GHRWS52L.CPDF_Parameter_Check;
1414: hr_utility.set_message(8301,'GHR_37821_ALL_PROCEDURE_FAIL');
1415: hr_utility.raise_error;
1416: end if;
1417: end if;
1418:
1419: -- 650.43.2 If pay plan is FA,

Line 1441: hr_utility.set_message(8301,'GHR_37928_ALL_PROCEDURE_FAIL');

1437: and (to_number(p_to_basic_pay) <> max_basic_pay
1438: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
1439: then
1440: GHR_GHRWS52L.CPDF_Parameter_Check;
1441: hr_utility.set_message(8301,'GHR_37928_ALL_PROCEDURE_FAIL');
1442: hr_utility.raise_error;
1443: end if;
1444: end if;
1445: end if;

Line 1442: hr_utility.raise_error;

1438: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
1439: then
1440: GHR_GHRWS52L.CPDF_Parameter_Check;
1441: hr_utility.set_message(8301,'GHR_37928_ALL_PROCEDURE_FAIL');
1442: hr_utility.raise_error;
1443: end if;
1444: end if;
1445: end if;
1446:

Line 1477: hr_utility.set_message(8301,'GHR_37822_ALL_PROCEDURE_FAIL');

1473: and (to_number(p_to_basic_pay) <> max_basic_pay
1474: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
1475: then
1476: GHR_GHRWS52L.CPDF_Parameter_Check;
1477: hr_utility.set_message(8301,'GHR_37822_ALL_PROCEDURE_FAIL');
1478: hr_utility.raise_error;
1479: end if;
1480: end if;
1481: end if;

Line 1478: hr_utility.raise_error;

1474: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
1475: then
1476: GHR_GHRWS52L.CPDF_Parameter_Check;
1477: hr_utility.set_message(8301,'GHR_37822_ALL_PROCEDURE_FAIL');
1478: hr_utility.raise_error;
1479: end if;
1480: end if;
1481: end if;
1482:

Line 1505: hr_utility.set_message(8301,'GHR_37823_ALL_PROCEDURE_FAIL');

1501: or p_to_basic_pay is null
1502: or to_number(p_to_basic_pay) = 0)
1503: then
1504: GHR_GHRWS52L.CPDF_Parameter_Check;
1505: hr_utility.set_message(8301,'GHR_37823_ALL_PROCEDURE_FAIL');
1506: hr_utility.raise_error;
1507: end if;
1508: end if;
1509:

Line 1506: hr_utility.raise_error;

1502: or to_number(p_to_basic_pay) = 0)
1503: then
1504: GHR_GHRWS52L.CPDF_Parameter_Check;
1505: hr_utility.set_message(8301,'GHR_37823_ALL_PROCEDURE_FAIL');
1506: hr_utility.raise_error;
1507: end if;
1508: end if;
1509:
1510: --Commented as per EOY 2003 cpdf changes by Ashley

Line 1534: hr_utility.set_message(8301,'GHR_37824_ALL_PROCEDURE_FAIL');

1530: and (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
1531: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
1532: then
1533: GHR_GHRWS52L.CPDF_Parameter_Check;
1534: hr_utility.set_message(8301,'GHR_37824_ALL_PROCEDURE_FAIL');
1535: hr_utility.raise_error;
1536: end if;
1537: end if;*/
1538:

Line 1535: hr_utility.raise_error;

1531: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
1532: then
1533: GHR_GHRWS52L.CPDF_Parameter_Check;
1534: hr_utility.set_message(8301,'GHR_37824_ALL_PROCEDURE_FAIL');
1535: hr_utility.raise_error;
1536: end if;
1537: end if;*/
1538:
1539: /*650.47.1 If pay plan is FC,

Line 1564: hr_utility.set_message(8301,'GHR_37825_ALL_PROCEDURE_FAIL');

1560: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
1561: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
1562: then
1563: GHR_GHRWS52L.CPDF_Parameter_Check;
1564: hr_utility.set_message(8301,'GHR_37825_ALL_PROCEDURE_FAIL');
1565: hr_utility.raise_error;
1566: end if;
1567: end if;
1568:

Line 1565: hr_utility.raise_error;

1561: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
1562: then
1563: GHR_GHRWS52L.CPDF_Parameter_Check;
1564: hr_utility.set_message(8301,'GHR_37825_ALL_PROCEDURE_FAIL');
1565: hr_utility.raise_error;
1566: end if;
1567: end if;
1568:
1569: /*650.47.2 If pay plan is FC,

Line 1596: hr_utility.set_message(8301,'GHR_37826_ALL_PROCEDURE_FAIL');

1592: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
1593: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
1594: then
1595: GHR_GHRWS52L.CPDF_Parameter_Check;
1596: hr_utility.set_message(8301,'GHR_37826_ALL_PROCEDURE_FAIL');
1597: hr_utility.raise_error;
1598: end if;
1599: end if;
1600: end if;

Line 1597: hr_utility.raise_error;

1593: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
1594: then
1595: GHR_GHRWS52L.CPDF_Parameter_Check;
1596: hr_utility.set_message(8301,'GHR_37826_ALL_PROCEDURE_FAIL');
1597: hr_utility.raise_error;
1598: end if;
1599: end if;
1600: end if;
1601:

Line 1625: hr_utility.set_message(8301,'GHR_37827_ALL_PROCEDURE_FAIL');

1621: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
1622: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
1623: then
1624: GHR_GHRWS52L.CPDF_Parameter_Check;
1625: hr_utility.set_message(8301,'GHR_37827_ALL_PROCEDURE_FAIL');
1626: hr_utility.raise_error;
1627: end if;
1628: end if;
1629:

Line 1626: hr_utility.raise_error;

1622: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
1623: then
1624: GHR_GHRWS52L.CPDF_Parameter_Check;
1625: hr_utility.set_message(8301,'GHR_37827_ALL_PROCEDURE_FAIL');
1626: hr_utility.raise_error;
1627: end if;
1628: end if;
1629:
1630: /* Commenting the edit as per Sept.2000 patch -- refer to doc cpdf_edits_00_sep.doc

Line 1656: hr_utility.set_message(8301,'GHR_37856_ALL_PROCEDURE_FAIL');

1652: and not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
1653: or p_to_basic_pay is null
1654: then
1655: GHR_GHRWS52L.CPDF_Parameter_Check;
1656: hr_utility.set_message(8301,'GHR_37856_ALL_PROCEDURE_FAIL');
1657: hr_utility.raise_error;
1658: end if;
1659: end if;
1660: */

Line 1657: hr_utility.raise_error;

1653: or p_to_basic_pay is null
1654: then
1655: GHR_GHRWS52L.CPDF_Parameter_Check;
1656: hr_utility.set_message(8301,'GHR_37856_ALL_PROCEDURE_FAIL');
1657: hr_utility.raise_error;
1658: end if;
1659: end if;
1660: */
1661:

Line 1688: hr_utility.set_message(8301,'GHR_37858_ALL_PROCEDURE_FAIL');

1684: and (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
1685: or p_to_basic_pay is null)
1686: then
1687: GHR_GHRWS52L.CPDF_Parameter_Check;
1688: hr_utility.set_message(8301,'GHR_37858_ALL_PROCEDURE_FAIL');
1689: hr_utility.raise_error;
1690: end if;
1691: end if;
1692: */

Line 1689: hr_utility.raise_error;

1685: or p_to_basic_pay is null)
1686: then
1687: GHR_GHRWS52L.CPDF_Parameter_Check;
1688: hr_utility.set_message(8301,'GHR_37858_ALL_PROCEDURE_FAIL');
1689: hr_utility.raise_error;
1690: end if;
1691: end if;
1692: */
1693:

Line 1720: hr_utility.set_message(8301,'GHR_37860_ALL_PROCEDURE_FAIL');

1716: and (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
1717: or p_to_basic_pay is null)
1718: then
1719: GHR_GHRWS52L.CPDF_Parameter_Check;
1720: hr_utility.set_message(8301,'GHR_37860_ALL_PROCEDURE_FAIL');
1721: hr_utility.raise_error;
1722: end if;
1723: end if;
1724: */

Line 1721: hr_utility.raise_error;

1717: or p_to_basic_pay is null)
1718: then
1719: GHR_GHRWS52L.CPDF_Parameter_Check;
1720: hr_utility.set_message(8301,'GHR_37860_ALL_PROCEDURE_FAIL');
1721: hr_utility.raise_error;
1722: end if;
1723: end if;
1724: */
1725:

Line 1748: hr_utility.set_message(8301,'GHR_37828_ALL_PROCEDURE_FAIL');

1744: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
1745: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
1746: then
1747: GHR_GHRWS52L.CPDF_Parameter_Check;
1748: hr_utility.set_message(8301,'GHR_37828_ALL_PROCEDURE_FAIL');
1749: hr_utility.raise_error;
1750: end if;
1751: end if;
1752:

Line 1749: hr_utility.raise_error;

1745: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
1746: then
1747: GHR_GHRWS52L.CPDF_Parameter_Check;
1748: hr_utility.set_message(8301,'GHR_37828_ALL_PROCEDURE_FAIL');
1749: hr_utility.raise_error;
1750: end if;
1751: end if;
1752:
1753: -- Dec 2001 Patch -- Renamed Edit 650.57.1 to 650.57.3

Line 1800: hr_utility.set_message(8301,'GHR_37829_ALL_PROCEDURE_FAIL');

1796: (not(to_number(p_to_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))
1797: or p_to_basic_pay is null)
1798: then
1799: GHR_GHRWS52L.CPDF_Parameter_Check;
1800: hr_utility.set_message(8301,'GHR_37829_ALL_PROCEDURE_FAIL');
1801: hr_utility.raise_error;
1802: end if;
1803: end if; */
1804: -----------------------------------------------------------------------------------------------------------

Line 1801: hr_utility.raise_error;

1797: or p_to_basic_pay is null)
1798: then
1799: GHR_GHRWS52L.CPDF_Parameter_Check;
1800: hr_utility.set_message(8301,'GHR_37829_ALL_PROCEDURE_FAIL');
1801: hr_utility.raise_error;
1802: end if;
1803: end if; */
1804: -----------------------------------------------------------------------------------------------------------
1805:

Line 1837: hr_utility.set_message(8301,'GHR_37830_ALL_PROCEDURE_FAIL');

1833: if (not(to_number(p_to_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))
1834: or p_to_basic_pay is null)
1835: then
1836: GHR_GHRWS52L.CPDF_Parameter_Check;
1837: hr_utility.set_message(8301,'GHR_37830_ALL_PROCEDURE_FAIL');
1838: hr_utility.raise_error;
1839: end if;
1840: end if;
1841: end if;

Line 1838: hr_utility.raise_error;

1834: or p_to_basic_pay is null)
1835: then
1836: GHR_GHRWS52L.CPDF_Parameter_Check;
1837: hr_utility.set_message(8301,'GHR_37830_ALL_PROCEDURE_FAIL');
1838: hr_utility.raise_error;
1839: end if;
1840: end if;
1841: end if;
1842: else -- greater than 01-mar-1998

Line 1870: hr_utility.set_message(8301,'GHR_37861_ALL_PROCEDURE_FAIL');

1866: if (not(to_number(p_to_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))
1867: or p_to_basic_pay is null)
1868: then
1869: GHR_GHRWS52L.CPDF_Parameter_Check;
1870: hr_utility.set_message(8301,'GHR_37861_ALL_PROCEDURE_FAIL');
1871: hr_utility.raise_error;
1872: end if;
1873: end if;
1874: end if;

Line 1871: hr_utility.raise_error;

1867: or p_to_basic_pay is null)
1868: then
1869: GHR_GHRWS52L.CPDF_Parameter_Check;
1870: hr_utility.set_message(8301,'GHR_37861_ALL_PROCEDURE_FAIL');
1871: hr_utility.raise_error;
1872: end if;
1873: end if;
1874: end if;
1875: end if;

Line 1900: hr_utility.set_message(8301,'GHR_37831_ALL_PROCEDURE_FAIL');

1896: and (not(to_number(p_to_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))
1897: or p_to_basic_pay is null)
1898: then
1899: GHR_GHRWS52L.CPDF_Parameter_Check;
1900: hr_utility.set_message(8301,'GHR_37831_ALL_PROCEDURE_FAIL');
1901: hr_utility.raise_error;
1902: end if;
1903: end if;
1904: END IF;

Line 1901: hr_utility.raise_error;

1897: or p_to_basic_pay is null)
1898: then
1899: GHR_GHRWS52L.CPDF_Parameter_Check;
1900: hr_utility.set_message(8301,'GHR_37831_ALL_PROCEDURE_FAIL');
1901: hr_utility.raise_error;
1902: end if;
1903: end if;
1904: END IF;
1905:

Line 1929: hr_utility.set_message(8301,'GHR_37832_ALL_PROCEDURE_FAIL');

1925: (not(to_number(p_to_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))
1926: or p_to_basic_pay is null)
1927: then
1928: GHR_GHRWS52L.CPDF_Parameter_Check;
1929: hr_utility.set_message(8301,'GHR_37832_ALL_PROCEDURE_FAIL');
1930: hr_utility.raise_error;
1931: end if;
1932: end if; */
1933:

Line 1930: hr_utility.raise_error;

1926: or p_to_basic_pay is null)
1927: then
1928: GHR_GHRWS52L.CPDF_Parameter_Check;
1929: hr_utility.set_message(8301,'GHR_37832_ALL_PROCEDURE_FAIL');
1930: hr_utility.raise_error;
1931: end if;
1932: end if; */
1933:
1934: /* Commenting the edit as per Sept.2000 patch -- refer to doc cpdf_edits_00_sep.doc

Line 1954: hr_utility.set_message(8301,'GHR_37833_ALL_PROCEDURE_FAIL');

1950: and (not(to_number(p_to_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))
1951: or p_to_basic_pay is null)
1952: then
1953: GHR_GHRWS52L.CPDF_Parameter_Check;
1954: hr_utility.set_message(8301,'GHR_37833_ALL_PROCEDURE_FAIL');
1955: hr_utility.raise_error;
1956: end if;
1957: end if;
1958: */

Line 1955: hr_utility.raise_error;

1951: or p_to_basic_pay is null)
1952: then
1953: GHR_GHRWS52L.CPDF_Parameter_Check;
1954: hr_utility.set_message(8301,'GHR_37833_ALL_PROCEDURE_FAIL');
1955: hr_utility.raise_error;
1956: end if;
1957: end if;
1958: */
1959:

Line 1987: hr_utility.set_message(8301,'GHR_37834_ALL_PROCEDURE_FAIL');

1983: and (not(to_number(p_to_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))
1984: or p_to_basic_pay is null)
1985: then
1986: GHR_GHRWS52L.CPDF_Parameter_Check;
1987: hr_utility.set_message(8301,'GHR_37834_ALL_PROCEDURE_FAIL');
1988: hr_utility.raise_error;
1989: end if;
1990: end if;
1991: end if;

Line 1988: hr_utility.raise_error;

1984: or p_to_basic_pay is null)
1985: then
1986: GHR_GHRWS52L.CPDF_Parameter_Check;
1987: hr_utility.set_message(8301,'GHR_37834_ALL_PROCEDURE_FAIL');
1988: hr_utility.raise_error;
1989: end if;
1990: end if;
1991: end if;
1992: /* Commenting the edit as per Sept.2000 patch -- refer to doc cpdf_edits_00_sep.doc

Line 2022: hr_utility.set_message(8301,'GHR_37081_ALL_PROCEDURE_FAIL');

2018: and (not(to_number(p_to_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))
2019: or p_to_basic_pay is null)
2020: then
2021: GHR_GHRWS52L.CPDF_Parameter_Check;
2022: hr_utility.set_message(8301,'GHR_37081_ALL_PROCEDURE_FAIL');
2023: hr_utility.raise_error;
2024: end if;
2025: end if;
2026: end if;

Line 2023: hr_utility.raise_error;

2019: or p_to_basic_pay is null)
2020: then
2021: GHR_GHRWS52L.CPDF_Parameter_Check;
2022: hr_utility.set_message(8301,'GHR_37081_ALL_PROCEDURE_FAIL');
2023: hr_utility.raise_error;
2024: end if;
2025: end if;
2026: end if;
2027: */

Line 2058: hr_utility.set_message(8301,'GHR_37078_ALL_PROCEDURE_FAIL');

2054: and (not(to_number(p_to_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))
2055: or p_to_basic_pay is null)
2056: then
2057: GHR_GHRWS52L.CPDF_Parameter_Check;
2058: hr_utility.set_message(8301,'GHR_37078_ALL_PROCEDURE_FAIL');
2059: hr_utility.raise_error;
2060: end if;
2061: end if;
2062: end if;

Line 2059: hr_utility.raise_error;

2055: or p_to_basic_pay is null)
2056: then
2057: GHR_GHRWS52L.CPDF_Parameter_Check;
2058: hr_utility.set_message(8301,'GHR_37078_ALL_PROCEDURE_FAIL');
2059: hr_utility.raise_error;
2060: end if;
2061: end if;
2062: end if;
2063: */

Line 2095: hr_utility.set_message(8301,'GHR_37079_ALL_PROCEDURE_FAIL');

2091: and (not(to_number(p_to_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))
2092: or p_to_basic_pay is null)
2093: then
2094: GHR_GHRWS52L.CPDF_Parameter_Check;
2095: hr_utility.set_message(8301,'GHR_37079_ALL_PROCEDURE_FAIL');
2096: hr_utility.raise_error;
2097: end if;
2098: end if;
2099: end if;

Line 2096: hr_utility.raise_error;

2092: or p_to_basic_pay is null)
2093: then
2094: GHR_GHRWS52L.CPDF_Parameter_Check;
2095: hr_utility.set_message(8301,'GHR_37079_ALL_PROCEDURE_FAIL');
2096: hr_utility.raise_error;
2097: end if;
2098: end if;
2099: end if;
2100: */

Line 2131: hr_utility.set_message(8301,'GHR_37080_ALL_PROCEDURE_FAIL');

2127: and (not(to_number(p_to_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))
2128: or p_to_basic_pay is null)
2129: then
2130: GHR_GHRWS52L.CPDF_Parameter_Check;
2131: hr_utility.set_message(8301,'GHR_37080_ALL_PROCEDURE_FAIL');
2132: hr_utility.raise_error;
2133: end if;
2134: end if;
2135: end if;

Line 2132: hr_utility.raise_error;

2128: or p_to_basic_pay is null)
2129: then
2130: GHR_GHRWS52L.CPDF_Parameter_Check;
2131: hr_utility.set_message(8301,'GHR_37080_ALL_PROCEDURE_FAIL');
2132: hr_utility.raise_error;
2133: end if;
2134: end if;
2135: end if;
2136: */

Line 2162: hr_utility.set_message(8301,'GHR_37835_ALL_PROCEDURE_FAIL');

2158: if (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
2159: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
2160: then
2161: GHR_GHRWS52L.CPDF_Parameter_Check;
2162: hr_utility.set_message(8301,'GHR_37835_ALL_PROCEDURE_FAIL');
2163: hr_utility.raise_error;
2164: end if;
2165: end if;
2166: end if;

Line 2163: hr_utility.raise_error;

2159: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
2160: then
2161: GHR_GHRWS52L.CPDF_Parameter_Check;
2162: hr_utility.set_message(8301,'GHR_37835_ALL_PROCEDURE_FAIL');
2163: hr_utility.raise_error;
2164: end if;
2165: end if;
2166: end if;
2167: END IF;

Line 2198: hr_utility.set_message(8301,'GHR_37836_ALL_PROCEDURE_FAIL');

2194: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
2195: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2196: then
2197: GHR_GHRWS52L.CPDF_Parameter_Check;
2198: hr_utility.set_message(8301,'GHR_37836_ALL_PROCEDURE_FAIL');
2199: hr_utility.set_message_token('TABLE_NUMBER','24');
2200: hr_utility.raise_error;
2201: end if;
2202: end if;

Line 2199: hr_utility.set_message_token('TABLE_NUMBER','24');

2195: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2196: then
2197: GHR_GHRWS52L.CPDF_Parameter_Check;
2198: hr_utility.set_message(8301,'GHR_37836_ALL_PROCEDURE_FAIL');
2199: hr_utility.set_message_token('TABLE_NUMBER','24');
2200: hr_utility.raise_error;
2201: end if;
2202: end if;
2203: elsif p_effective_date >= to_date('2002/09/01','yyyy/mm/dd') then

Line 2200: hr_utility.raise_error;

2196: then
2197: GHR_GHRWS52L.CPDF_Parameter_Check;
2198: hr_utility.set_message(8301,'GHR_37836_ALL_PROCEDURE_FAIL');
2199: hr_utility.set_message_token('TABLE_NUMBER','24');
2200: hr_utility.raise_error;
2201: end if;
2202: end if;
2203: elsif p_effective_date >= to_date('2002/09/01','yyyy/mm/dd') then
2204: if p_agency_subelement = 'DD16' and

Line 2221: hr_utility.set_message(8301,'GHR_37836_ALL_PROCEDURE_FAIL');

2217: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
2218: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2219: then
2220: GHR_GHRWS52L.CPDF_Parameter_Check;
2221: hr_utility.set_message(8301,'GHR_37836_ALL_PROCEDURE_FAIL');
2222: hr_utility.set_message_token('TABLE_NUMBER','54');
2223: hr_utility.raise_error;
2224: end if;
2225: end if;

Line 2222: hr_utility.set_message_token('TABLE_NUMBER','54');

2218: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2219: then
2220: GHR_GHRWS52L.CPDF_Parameter_Check;
2221: hr_utility.set_message(8301,'GHR_37836_ALL_PROCEDURE_FAIL');
2222: hr_utility.set_message_token('TABLE_NUMBER','54');
2223: hr_utility.raise_error;
2224: end if;
2225: end if;
2226: end if;

Line 2223: hr_utility.raise_error;

2219: then
2220: GHR_GHRWS52L.CPDF_Parameter_Check;
2221: hr_utility.set_message(8301,'GHR_37836_ALL_PROCEDURE_FAIL');
2222: hr_utility.set_message_token('TABLE_NUMBER','54');
2223: hr_utility.raise_error;
2224: end if;
2225: end if;
2226: end if;
2227: */

Line 2255: hr_utility.set_message(8301,'GHR_37840_ALL_PROCEDURE_FAIL');

2251: (not(to_number(p_to_basic_pay) < max_basic_pay)
2252: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2253: then
2254: GHR_GHRWS52L.CPDF_Parameter_Check;
2255: hr_utility.set_message(8301,'GHR_37840_ALL_PROCEDURE_FAIL');
2256: hr_utility.raise_error;
2257: end if;
2258: end if;
2259: */

Line 2256: hr_utility.raise_error;

2252: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2253: then
2254: GHR_GHRWS52L.CPDF_Parameter_Check;
2255: hr_utility.set_message(8301,'GHR_37840_ALL_PROCEDURE_FAIL');
2256: hr_utility.raise_error;
2257: end if;
2258: end if;
2259: */
2260:

Line 2290: hr_utility.set_message(8301,'GHR_37841_ALL_PROCEDURE_FAIL');

2286: or p_to_basic_pay is null
2287: or to_number(p_to_basic_pay) = 0)
2288: then
2289: GHR_GHRWS52L.CPDF_Parameter_Check;
2290: hr_utility.set_message(8301,'GHR_37841_ALL_PROCEDURE_FAIL');
2291: hr_utility.raise_error;
2292: end if;
2293: end if;
2294: */

Line 2291: hr_utility.raise_error;

2287: or to_number(p_to_basic_pay) = 0)
2288: then
2289: GHR_GHRWS52L.CPDF_Parameter_Check;
2290: hr_utility.set_message(8301,'GHR_37841_ALL_PROCEDURE_FAIL');
2291: hr_utility.raise_error;
2292: end if;
2293: end if;
2294: */
2295:

Line 2319: hr_utility.set_message(8301,'GHR_37842_ALL_PROCEDURE_FAIL');

2315: and (not(to_number(p_to_basic_pay) <= max_basic_pay)
2316: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2317: then
2318: GHR_GHRWS52L.CPDF_Parameter_Check;
2319: hr_utility.set_message(8301,'GHR_37842_ALL_PROCEDURE_FAIL');
2320: hr_utility.raise_error;
2321: end if;
2322: end if;
2323: */

Line 2320: hr_utility.raise_error;

2316: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2317: then
2318: GHR_GHRWS52L.CPDF_Parameter_Check;
2319: hr_utility.set_message(8301,'GHR_37842_ALL_PROCEDURE_FAIL');
2320: hr_utility.raise_error;
2321: end if;
2322: end if;
2323: */
2324: /*650.87.1 If pay plan is other than GH or GM,

Line 2352: hr_utility.set_message(8301,'GHR_37843_ALL_PROCEDURE_FAIL');

2348: and (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
2349: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2350: then
2351: GHR_GHRWS52L.CPDF_Parameter_Check;
2352: hr_utility.set_message(8301,'GHR_37843_ALL_PROCEDURE_FAIL');
2353: hr_utility.raise_error;
2354: end if;
2355: end if;
2356: */

Line 2353: hr_utility.raise_error;

2349: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2350: then
2351: GHR_GHRWS52L.CPDF_Parameter_Check;
2352: hr_utility.set_message(8301,'GHR_37843_ALL_PROCEDURE_FAIL');
2353: hr_utility.raise_error;
2354: end if;
2355: end if;
2356: */
2357:

Line 2384: hr_utility.set_message(8301,'GHR_37845_ALL_PROCEDURE_FAIL');

2380: and (not(to_number(p_to_basic_pay) < max_basic_pay)
2381: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2382: then
2383: GHR_GHRWS52L.CPDF_Parameter_Check;
2384: hr_utility.set_message(8301,'GHR_37845_ALL_PROCEDURE_FAIL');
2385: hr_utility.raise_error;
2386: end if;
2387: end if;
2388: */

Line 2385: hr_utility.raise_error;

2381: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2382: then
2383: GHR_GHRWS52L.CPDF_Parameter_Check;
2384: hr_utility.set_message(8301,'GHR_37845_ALL_PROCEDURE_FAIL');
2385: hr_utility.raise_error;
2386: end if;
2387: end if;
2388: */
2389: /* Commented as per December 2000 cpdf changes -- vravikan

Line 2416: hr_utility.set_message(8301,'GHR_37846_ALL_PROCEDURE_FAIL');

2412: and (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
2413: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2414: then
2415: GHR_GHRWS52L.CPDF_Parameter_Check;
2416: hr_utility.set_message(8301,'GHR_37846_ALL_PROCEDURE_FAIL');
2417: hr_utility.raise_error;
2418: end if;
2419: end if;
2420: */

Line 2417: hr_utility.raise_error;

2413: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2414: then
2415: GHR_GHRWS52L.CPDF_Parameter_Check;
2416: hr_utility.set_message(8301,'GHR_37846_ALL_PROCEDURE_FAIL');
2417: hr_utility.raise_error;
2418: end if;
2419: end if;
2420: */
2421:

Line 2449: hr_utility.set_message(8301,'GHR_37847_ALL_PROCEDURE_FAIL');

2445: and (to_number(p_to_basic_pay) <> max_basic_pay
2446: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2447: then
2448: GHR_GHRWS52L.CPDF_Parameter_Check;
2449: hr_utility.set_message(8301,'GHR_37847_ALL_PROCEDURE_FAIL');
2450: hr_utility.raise_error;
2451: end if;
2452: end if;
2453:

Line 2450: hr_utility.raise_error;

2446: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2447: then
2448: GHR_GHRWS52L.CPDF_Parameter_Check;
2449: hr_utility.set_message(8301,'GHR_37847_ALL_PROCEDURE_FAIL');
2450: hr_utility.raise_error;
2451: end if;
2452: end if;
2453:
2454: /*650.97.1 If pay plan is CA,

Line 2474: hr_utility.set_message(8301,'GHR_37848_ALL_PROCEDURE_FAIL');

2470: and (to_number(p_to_basic_pay) <> max_basic_pay
2471: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2472: then
2473: GHR_GHRWS52L.CPDF_Parameter_Check;
2474: hr_utility.set_message(8301,'GHR_37848_ALL_PROCEDURE_FAIL');
2475: hr_utility.raise_error;
2476: end if;
2477: end if;
2478:

Line 2475: hr_utility.raise_error;

2471: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2472: then
2473: GHR_GHRWS52L.CPDF_Parameter_Check;
2474: hr_utility.set_message(8301,'GHR_37848_ALL_PROCEDURE_FAIL');
2475: hr_utility.raise_error;
2476: end if;
2477: end if;
2478:
2479: /*650.98.1 If pay plan is ST or SL,

Line 2506: hr_utility.set_message(8301,'GHR_37849_ALL_PROCEDURE_FAIL');

2502: and (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
2503: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2504: then
2505: GHR_GHRWS52L.CPDF_Parameter_Check;
2506: hr_utility.set_message(8301,'GHR_37849_ALL_PROCEDURE_FAIL');
2507: hr_utility.set_message_token('PRD','not C');
2508: hr_utility.raise_error;
2509: end if;
2510: end if;

Line 2507: hr_utility.set_message_token('PRD','not C');

2503: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2504: then
2505: GHR_GHRWS52L.CPDF_Parameter_Check;
2506: hr_utility.set_message(8301,'GHR_37849_ALL_PROCEDURE_FAIL');
2507: hr_utility.set_message_token('PRD','not C');
2508: hr_utility.raise_error;
2509: end if;
2510: end if;
2511: else

Line 2508: hr_utility.raise_error;

2504: then
2505: GHR_GHRWS52L.CPDF_Parameter_Check;
2506: hr_utility.set_message(8301,'GHR_37849_ALL_PROCEDURE_FAIL');
2507: hr_utility.set_message_token('PRD','not C');
2508: hr_utility.raise_error;
2509: end if;
2510: end if;
2511: else
2512: if p_to_pay_plan in ('ST', 'SL')

Line 2528: hr_utility.set_message(8301,'GHR_37849_ALL_PROCEDURE_FAIL');

2524: and (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
2525: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2526: then
2527: GHR_GHRWS52L.CPDF_Parameter_Check;
2528: hr_utility.set_message(8301,'GHR_37849_ALL_PROCEDURE_FAIL');
2529: hr_utility.set_message_token('PRD','not C or D');
2530: hr_utility.raise_error;
2531: end if;
2532: end if;

Line 2529: hr_utility.set_message_token('PRD','not C or D');

2525: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2526: then
2527: GHR_GHRWS52L.CPDF_Parameter_Check;
2528: hr_utility.set_message(8301,'GHR_37849_ALL_PROCEDURE_FAIL');
2529: hr_utility.set_message_token('PRD','not C or D');
2530: hr_utility.raise_error;
2531: end if;
2532: end if;
2533: end if;

Line 2530: hr_utility.raise_error;

2526: then
2527: GHR_GHRWS52L.CPDF_Parameter_Check;
2528: hr_utility.set_message(8301,'GHR_37849_ALL_PROCEDURE_FAIL');
2529: hr_utility.set_message_token('PRD','not C or D');
2530: hr_utility.raise_error;
2531: end if;
2532: end if;
2533: end if;
2534:

Line 2556: hr_utility.set_message(8301,'GHR_38551_ALL_PROCEDURE_FAIL');

2552: (not(to_number(p_to_basic_pay) <> max_basic_pay)
2553: or p_to_basic_pay is null)
2554: then
2555: GHR_GHRWS52L.CPDF_Parameter_Check;
2556: hr_utility.set_message(8301,'GHR_38551_ALL_PROCEDURE_FAIL');
2557: hr_utility.raise_error;
2558: end if;
2559: end if;
2560: end if;

Line 2557: hr_utility.raise_error;

2553: or p_to_basic_pay is null)
2554: then
2555: GHR_GHRWS52L.CPDF_Parameter_Check;
2556: hr_utility.set_message(8301,'GHR_38551_ALL_PROCEDURE_FAIL');
2557: hr_utility.raise_error;
2558: end if;
2559: end if;
2560: end if;
2561: /*650.53.2 If pay plan is AF, FO, or FP,

Line 2585: hr_utility.set_message(8301,'GHR_37850_ALL_PROCEDURE_FAIL');

2581: and (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
2582: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2583: then
2584: GHR_GHRWS52L.CPDF_Parameter_Check;
2585: hr_utility.set_message(8301,'GHR_37850_ALL_PROCEDURE_FAIL');
2586: hr_utility.raise_error;
2587: end if;
2588: end if;
2589: end if;

Line 2586: hr_utility.raise_error;

2582: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2583: then
2584: GHR_GHRWS52L.CPDF_Parameter_Check;
2585: hr_utility.set_message(8301,'GHR_37850_ALL_PROCEDURE_FAIL');
2586: hr_utility.raise_error;
2587: end if;
2588: end if;
2589: end if;
2590:

Line 2632: hr_utility.set_message(8301,'GHR_37851_ALL_PROCEDURE_FAIL');

2628: if (not(to_number(p_to_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))
2629: or p_to_basic_pay is null)
2630: then
2631: GHR_GHRWS52L.CPDF_Parameter_Check;
2632: hr_utility.set_message(8301,'GHR_37851_ALL_PROCEDURE_FAIL');
2633: hr_utility.raise_error;
2634: end if;
2635: end if;
2636: end if;

Line 2633: hr_utility.raise_error;

2629: or p_to_basic_pay is null)
2630: then
2631: GHR_GHRWS52L.CPDF_Parameter_Check;
2632: hr_utility.set_message(8301,'GHR_37851_ALL_PROCEDURE_FAIL');
2633: hr_utility.raise_error;
2634: end if;
2635: end if;
2636: end if;
2637: */

Line 2664: hr_utility.set_message(8301,'GHR_37853_ALL_PROCEDURE_FAIL');

2660: and (not(to_number(p_to_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))
2661: or p_to_basic_pay is null)
2662: then
2663: GHR_GHRWS52L.CPDF_Parameter_Check;
2664: hr_utility.set_message(8301,'GHR_37853_ALL_PROCEDURE_FAIL');
2665: hr_utility.raise_error;
2666: end if;
2667: end if;
2668: end if;

Line 2665: hr_utility.raise_error;

2661: or p_to_basic_pay is null)
2662: then
2663: GHR_GHRWS52L.CPDF_Parameter_Check;
2664: hr_utility.set_message(8301,'GHR_37853_ALL_PROCEDURE_FAIL');
2665: hr_utility.raise_error;
2666: end if;
2667: end if;
2668: end if;
2669: hr_utility.set_location('Leaving CPDF 8 ',1);

Line 2669: hr_utility.set_location('Leaving CPDF 8 ',1);

2665: hr_utility.raise_error;
2666: end if;
2667: end if;
2668: end if;
2669: hr_utility.set_location('Leaving CPDF 8 ',1);
2670: end basic_pay;
2671: end ghr_cpdf_check8;