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 163: hr_utility.set_message(8301,'GHR_37811_ALL_PROCEDURE_FAIL');

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

Line 164: hr_utility.raise_error;

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

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

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

Line 185: hr_utility.raise_error;

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

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

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

Line 207: hr_utility.raise_error;

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

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

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

Line 229: hr_utility.raise_error;

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

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

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

Line 254: hr_utility.raise_error;

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

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

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

Line 280: hr_utility.raise_error;

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

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

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

Line 299: hr_utility.raise_error;

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

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

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

Line 326: hr_utility.raise_error;

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

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

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

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

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

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

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

Line 355: hr_utility.raise_error;

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

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

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

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

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

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

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

Line 380: hr_utility.raise_error;

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

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

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

Line 409: hr_utility.raise_error;

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

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

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

Line 436: hr_utility.raise_error;

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

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

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

Line 463: hr_utility.raise_error;

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

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

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

Line 486: hr_utility.raise_error;

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

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

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

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

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

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

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

Line 524: hr_utility.raise_error;

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

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

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

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

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

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

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

Line 549: hr_utility.raise_error;

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

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

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

Line 577: hr_utility.raise_error;

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

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

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

Line 604: hr_utility.raise_error;

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

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

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

Line 628: hr_utility.raise_error;

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

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

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

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

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

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

653: ) then
654: GHR_GHRWS52L.CPDF_Parameter_Check;
655: hr_utility.set_message(8301,'GHR_37839_ALL_PROCEDURE_FAIL');
656: hr_utility.set_message_token('COND','exceed');
657: hr_utility.set_message_token('PRD_LIST','5,6 or M');
658: hr_utility.raise_error;
659: end if;
660: end if;
661: ELSE

Line 658: hr_utility.raise_error;

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

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

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

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

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

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

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

Line 679: hr_utility.raise_error;

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

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

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

Line 707: hr_utility.raise_error;

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

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

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

Line 743: hr_utility.raise_error;

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

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

764: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
765: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
766: then
767: GHR_GHRWS52L.CPDF_Parameter_Check;
768: hr_utility.set_message(8301,'GHR_37802_ALL_PROCEDURE_FAIL');
769: hr_utility.raise_error;
770: end if;
771: end if;
772:

Line 769: hr_utility.raise_error;

765: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
766: then
767: GHR_GHRWS52L.CPDF_Parameter_Check;
768: hr_utility.set_message(8301,'GHR_37802_ALL_PROCEDURE_FAIL');
769: hr_utility.raise_error;
770: end if;
771: end if;
772:
773: /*650.06.3 If pay plan is NX,

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

790: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
791: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
792: then
793: GHR_GHRWS52L.CPDF_Parameter_Check;
794: hr_utility.set_message(8301,'GHR_37803_ALL_PROCEDURE_FAIL');
795: hr_utility.raise_error;
796: end if;
797: end if;
798:

Line 795: hr_utility.raise_error;

791: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
792: then
793: GHR_GHRWS52L.CPDF_Parameter_Check;
794: hr_utility.set_message(8301,'GHR_37803_ALL_PROCEDURE_FAIL');
795: hr_utility.raise_error;
796: end if;
797: end if;
798:
799: /* Commenting the edit as per Sept.2000 patch -- refer to doc cpdf_edits_00_sep.doc

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

825: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
826: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
827: then
828: GHR_GHRWS52L.CPDF_Parameter_Check;
829: hr_utility.set_message(8301,'GHR_37863_ALL_PROCEDURE_FAIL');
830: hr_utility.raise_error;
831: end if;
832: end if;
833: */

Line 830: hr_utility.raise_error;

826: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
827: then
828: GHR_GHRWS52L.CPDF_Parameter_Check;
829: hr_utility.set_message(8301,'GHR_37863_ALL_PROCEDURE_FAIL');
830: hr_utility.raise_error;
831: end if;
832: end if;
833: */
834:

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

861: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
862: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
863: then
864: GHR_GHRWS52L.CPDF_Parameter_Check;
865: hr_utility.set_message(8301,'GHR_37864_ALL_PROCEDURE_FAIL');
866: hr_utility.raise_error;
867: end if;
868: end if;
869: */

Line 866: hr_utility.raise_error;

862: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
863: then
864: GHR_GHRWS52L.CPDF_Parameter_Check;
865: hr_utility.set_message(8301,'GHR_37864_ALL_PROCEDURE_FAIL');
866: hr_utility.raise_error;
867: end if;
868: end if;
869: */
870:

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

891: (not(to_number(p_to_basic_pay) >= min_basic_pay)
892: or (p_to_basic_pay is null and p_first_noac_lookup_code <> '817' ))
893: then
894: GHR_GHRWS52L.CPDF_Parameter_Check;
895: hr_utility.set_message(8301,'GHR_37805_ALL_PROCEDURE_FAIL');
896: hr_utility.raise_error;
897: end if;
898: end if;
899:

Line 896: hr_utility.raise_error;

892: or (p_to_basic_pay is null and p_first_noac_lookup_code <> '817' ))
893: then
894: GHR_GHRWS52L.CPDF_Parameter_Check;
895: hr_utility.set_message(8301,'GHR_37805_ALL_PROCEDURE_FAIL');
896: hr_utility.raise_error;
897: end if;
898: end if;
899:
900: /*650.16.1 If pay rate determinant is U or V,

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

918: (not(to_number(p_to_basic_pay) >= min_basic_pay)
919: or p_to_basic_pay is null)
920: then
921: GHR_GHRWS52L.CPDF_Parameter_Check;
922: hr_utility.set_message(8301,'GHR_37806_ALL_PROCEDURE_FAIL');
923: hr_utility.raise_error;
924: end if;
925: end if;
926: */

Line 923: hr_utility.raise_error;

919: or p_to_basic_pay is null)
920: then
921: GHR_GHRWS52L.CPDF_Parameter_Check;
922: hr_utility.set_message(8301,'GHR_37806_ALL_PROCEDURE_FAIL');
923: hr_utility.raise_error;
924: end if;
925: end if;
926: */
927:

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

947: and (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
948: or p_to_basic_pay is null)
949: then
950: GHR_GHRWS52L.CPDF_Parameter_Check;
951: hr_utility.set_message(8301,'GHR_37807_ALL_PROCEDURE_FAIL');
952: hr_utility.raise_error;
953: end if;
954: end if;
955: */

Line 952: hr_utility.raise_error;

948: or p_to_basic_pay is null)
949: then
950: GHR_GHRWS52L.CPDF_Parameter_Check;
951: hr_utility.set_message(8301,'GHR_37807_ALL_PROCEDURE_FAIL');
952: hr_utility.raise_error;
953: end if;
954: end if;
955: */
956:

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

975: and (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
976: or p_to_basic_pay is null)
977: then
978: GHR_GHRWS52L.CPDF_Parameter_Check;
979: hr_utility.set_message(8301,'GHR_37429_ALL_PROCEDURE_FAIL');
980: hr_utility.raise_error;
981: end if;
982: end if;
983: --Commented as per EOY 2003 cpdf changes by Ashley

Line 980: hr_utility.raise_error;

976: or p_to_basic_pay is null)
977: then
978: GHR_GHRWS52L.CPDF_Parameter_Check;
979: hr_utility.set_message(8301,'GHR_37429_ALL_PROCEDURE_FAIL');
980: hr_utility.raise_error;
981: end if;
982: end if;
983: --Commented as per EOY 2003 cpdf changes by Ashley
984: /*650.20.1 If pay plan is GM,

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

1001: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
1002: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
1003: then
1004: GHR_GHRWS52L.CPDF_Parameter_Check;
1005: hr_utility.set_message(8301,'GHR_37808_ALL_PROCEDURE_FAIL');
1006: hr_utility.raise_error;
1007: end if;
1008: end if;*/
1009:

Line 1006: hr_utility.raise_error;

1002: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
1003: then
1004: GHR_GHRWS52L.CPDF_Parameter_Check;
1005: hr_utility.set_message(8301,'GHR_37808_ALL_PROCEDURE_FAIL');
1006: hr_utility.raise_error;
1007: end if;
1008: end if;*/
1009:
1010: /* Commented as per December 2000 cpdf changes -- vravikan

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

1037: or p_to_basic_pay is null
1038: or to_number(p_to_basic_pay) = 0)
1039: then
1040: GHR_GHRWS52L.CPDF_Parameter_Check;
1041: hr_utility.set_message(8301,'GHR_37433_ALL_PROCEDURE_FAIL');
1042: hr_utility.raise_error;
1043: end if;
1044: end if;
1045: else

Line 1042: hr_utility.raise_error;

1038: or to_number(p_to_basic_pay) = 0)
1039: then
1040: GHR_GHRWS52L.CPDF_Parameter_Check;
1041: hr_utility.set_message(8301,'GHR_37433_ALL_PROCEDURE_FAIL');
1042: hr_utility.raise_error;
1043: end if;
1044: end if;
1045: else
1046: if p_to_pay_plan in ('GH','GM')

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

1062: or p_to_basic_pay is null
1063: or to_number(p_to_basic_pay) = 0)
1064: then
1065: GHR_GHRWS52L.CPDF_Parameter_Check;
1066: hr_utility.set_message(8301,'GHR_37809_ALL_PROCEDURE_FAIL');
1067: hr_utility.raise_error;
1068: end if;
1069: end if;
1070: end if;

Line 1067: hr_utility.raise_error;

1063: or to_number(p_to_basic_pay) = 0)
1064: then
1065: GHR_GHRWS52L.CPDF_Parameter_Check;
1066: hr_utility.set_message(8301,'GHR_37809_ALL_PROCEDURE_FAIL');
1067: hr_utility.raise_error;
1068: end if;
1069: end if;
1070: end if;
1071: */

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

1090: (not(to_number(p_to_basic_pay) >= min_basic_pay)
1091: or p_to_basic_pay is null)
1092: then
1093: GHR_GHRWS52L.CPDF_Parameter_Check;
1094: hr_utility.set_message(8301,'GHR_37810_ALL_PROCEDURE_FAIL');
1095: hr_utility.raise_error;
1096: end if;
1097: end if;
1098:

Line 1095: hr_utility.raise_error;

1091: or p_to_basic_pay is null)
1092: then
1093: GHR_GHRWS52L.CPDF_Parameter_Check;
1094: hr_utility.set_message(8301,'GHR_37810_ALL_PROCEDURE_FAIL');
1095: hr_utility.raise_error;
1096: end if;
1097: end if;
1098:
1099: /*650.27.3 If pay plan is FB, FJ, or FX,

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

1120: if (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
1121: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
1122: then
1123: GHR_GHRWS52L.CPDF_Parameter_Check;
1124: hr_utility.set_message(8301,'GHR_37812_ALL_PROCEDURE_FAIL');
1125: hr_utility.raise_error;
1126: end if;
1127: end if;
1128: end if;

Line 1125: hr_utility.raise_error;

1121: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
1122: then
1123: GHR_GHRWS52L.CPDF_Parameter_Check;
1124: hr_utility.set_message(8301,'GHR_37812_ALL_PROCEDURE_FAIL');
1125: hr_utility.raise_error;
1126: end if;
1127: end if;
1128: end if;
1129: END IF;

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

1147: if (not (to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
1148: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
1149: then
1150: GHR_GHRWS52L.CPDF_Parameter_Check;
1151: hr_utility.set_message(8301,'GHR_37813_ALL_PROCEDURE_FAIL');
1152: hr_utility.raise_error;
1153: end if;
1154: end if;
1155: end if;

Line 1152: hr_utility.raise_error;

1148: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
1149: then
1150: GHR_GHRWS52L.CPDF_Parameter_Check;
1151: hr_utility.set_message(8301,'GHR_37813_ALL_PROCEDURE_FAIL');
1152: hr_utility.raise_error;
1153: end if;
1154: end if;
1155: end if;
1156:

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

1179: if (not (to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
1180: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
1181: then
1182: GHR_GHRWS52L.CPDF_Parameter_Check;
1183: hr_utility.set_message(8301,'GHR_37814_ALL_PROCEDURE_FAIL');
1184: hr_utility.raise_error;
1185: end if;
1186: end if;
1187: end if; */

Line 1184: hr_utility.raise_error;

1180: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
1181: then
1182: GHR_GHRWS52L.CPDF_Parameter_Check;
1183: hr_utility.set_message(8301,'GHR_37814_ALL_PROCEDURE_FAIL');
1184: hr_utility.raise_error;
1185: end if;
1186: end if;
1187: end if; */
1188: -----------------------------------------------------------------------------------------------------------

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

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

Line 1214: hr_utility.raise_error;

1210: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
1211: then
1212: GHR_GHRWS52L.CPDF_Parameter_Check;
1213: hr_utility.set_message(8301,'GHR_37435_ALL_PROCEDURE_FAIL');
1214: hr_utility.raise_error;
1215: end if;
1216: end if;
1217: end if;
1218: else

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

1230: and (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
1231: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
1232: then
1233: GHR_GHRWS52L.CPDF_Parameter_Check;
1234: hr_utility.set_message(8301,'GHR_37815_ALL_PROCEDURE_FAIL');
1235: hr_utility.raise_error;
1236: end if;
1237: end if;
1238: end if;

Line 1235: hr_utility.raise_error;

1231: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
1232: then
1233: GHR_GHRWS52L.CPDF_Parameter_Check;
1234: hr_utility.set_message(8301,'GHR_37815_ALL_PROCEDURE_FAIL');
1235: hr_utility.raise_error;
1236: end if;
1237: end if;
1238: end if;
1239: end if;

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

1260: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
1261: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
1262: then
1263: GHR_GHRWS52L.CPDF_Parameter_Check;
1264: hr_utility.set_message(8301,'GHR_37854_ALL_PROCEDURE_FAIL');
1265: hr_utility.raise_error;
1266: end if;
1267: end if;
1268: */

Line 1265: hr_utility.raise_error;

1261: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
1262: then
1263: GHR_GHRWS52L.CPDF_Parameter_Check;
1264: hr_utility.set_message(8301,'GHR_37854_ALL_PROCEDURE_FAIL');
1265: hr_utility.raise_error;
1266: end if;
1267: end if;
1268: */
1269:

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

1290: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
1291: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
1292: then
1293: GHR_GHRWS52L.CPDF_Parameter_Check;
1294: hr_utility.set_message(8301,'GHR_37855_ALL_PROCEDURE_FAIL');
1295: hr_utility.raise_error;
1296: end if;
1297: end if;
1298: */

Line 1295: hr_utility.raise_error;

1291: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
1292: then
1293: GHR_GHRWS52L.CPDF_Parameter_Check;
1294: hr_utility.set_message(8301,'GHR_37855_ALL_PROCEDURE_FAIL');
1295: hr_utility.raise_error;
1296: end if;
1297: end if;
1298: */
1299:

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

1316: (not(to_number(p_to_basic_pay) < max_basic_pay)
1317: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
1318: then
1319: GHR_GHRWS52L.CPDF_Parameter_Check;
1320: hr_utility.set_message(8301,'GHR_37820_ALL_PROCEDURE_FAIL');
1321: hr_utility.raise_error;
1322: end if;
1323: end if;
1324: */

Line 1321: hr_utility.raise_error;

1317: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
1318: then
1319: GHR_GHRWS52L.CPDF_Parameter_Check;
1320: hr_utility.set_message(8301,'GHR_37820_ALL_PROCEDURE_FAIL');
1321: hr_utility.raise_error;
1322: end if;
1323: end if;
1324: */
1325: /*650.42.1 If pay plan is GG,

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

1341: and (not(to_number(p_to_basic_pay) >= min_basic_pay)
1342: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
1343: then
1344: GHR_GHRWS52L.CPDF_Parameter_Check;
1345: hr_utility.set_message(8301,'GHR_37821_ALL_PROCEDURE_FAIL');
1346: hr_utility.raise_error;
1347: end if;
1348: end if;
1349:

Line 1346: hr_utility.raise_error;

1342: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
1343: then
1344: GHR_GHRWS52L.CPDF_Parameter_Check;
1345: hr_utility.set_message(8301,'GHR_37821_ALL_PROCEDURE_FAIL');
1346: hr_utility.raise_error;
1347: end if;
1348: end if;
1349:
1350: -- 650.43.2 If pay plan is FA,

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

1368: and (to_number(p_to_basic_pay) <> max_basic_pay
1369: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
1370: then
1371: GHR_GHRWS52L.CPDF_Parameter_Check;
1372: hr_utility.set_message(8301,'GHR_37928_ALL_PROCEDURE_FAIL');
1373: hr_utility.raise_error;
1374: end if;
1375: end if;
1376: end if;

Line 1373: hr_utility.raise_error;

1369: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
1370: then
1371: GHR_GHRWS52L.CPDF_Parameter_Check;
1372: hr_utility.set_message(8301,'GHR_37928_ALL_PROCEDURE_FAIL');
1373: hr_utility.raise_error;
1374: end if;
1375: end if;
1376: end if;
1377:

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

1404: and (to_number(p_to_basic_pay) <> max_basic_pay
1405: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
1406: then
1407: GHR_GHRWS52L.CPDF_Parameter_Check;
1408: hr_utility.set_message(8301,'GHR_37822_ALL_PROCEDURE_FAIL');
1409: hr_utility.raise_error;
1410: end if;
1411: end if;
1412: end if;

Line 1409: hr_utility.raise_error;

1405: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
1406: then
1407: GHR_GHRWS52L.CPDF_Parameter_Check;
1408: hr_utility.set_message(8301,'GHR_37822_ALL_PROCEDURE_FAIL');
1409: hr_utility.raise_error;
1410: end if;
1411: end if;
1412: end if;
1413:

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

1432: or p_to_basic_pay is null
1433: or to_number(p_to_basic_pay) = 0)
1434: then
1435: GHR_GHRWS52L.CPDF_Parameter_Check;
1436: hr_utility.set_message(8301,'GHR_37823_ALL_PROCEDURE_FAIL');
1437: hr_utility.raise_error;
1438: end if;
1439: end if;
1440:

Line 1437: hr_utility.raise_error;

1433: or to_number(p_to_basic_pay) = 0)
1434: then
1435: GHR_GHRWS52L.CPDF_Parameter_Check;
1436: hr_utility.set_message(8301,'GHR_37823_ALL_PROCEDURE_FAIL');
1437: hr_utility.raise_error;
1438: end if;
1439: end if;
1440:
1441: --Commented as per EOY 2003 cpdf changes by Ashley

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

1461: and (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
1462: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
1463: then
1464: GHR_GHRWS52L.CPDF_Parameter_Check;
1465: hr_utility.set_message(8301,'GHR_37824_ALL_PROCEDURE_FAIL');
1466: hr_utility.raise_error;
1467: end if;
1468: end if;*/
1469:

Line 1466: hr_utility.raise_error;

1462: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
1463: then
1464: GHR_GHRWS52L.CPDF_Parameter_Check;
1465: hr_utility.set_message(8301,'GHR_37824_ALL_PROCEDURE_FAIL');
1466: hr_utility.raise_error;
1467: end if;
1468: end if;*/
1469:
1470: /*650.47.1 If pay plan is FC,

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

1491: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
1492: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
1493: then
1494: GHR_GHRWS52L.CPDF_Parameter_Check;
1495: hr_utility.set_message(8301,'GHR_37825_ALL_PROCEDURE_FAIL');
1496: hr_utility.raise_error;
1497: end if;
1498: end if;
1499:

Line 1496: hr_utility.raise_error;

1492: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
1493: then
1494: GHR_GHRWS52L.CPDF_Parameter_Check;
1495: hr_utility.set_message(8301,'GHR_37825_ALL_PROCEDURE_FAIL');
1496: hr_utility.raise_error;
1497: end if;
1498: end if;
1499:
1500: /*650.47.2 If pay plan is FC,

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

1522: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
1523: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
1524: then
1525: GHR_GHRWS52L.CPDF_Parameter_Check;
1526: hr_utility.set_message(8301,'GHR_37826_ALL_PROCEDURE_FAIL');
1527: hr_utility.raise_error;
1528: end if;
1529: end if;
1530:

Line 1527: hr_utility.raise_error;

1523: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
1524: then
1525: GHR_GHRWS52L.CPDF_Parameter_Check;
1526: hr_utility.set_message(8301,'GHR_37826_ALL_PROCEDURE_FAIL');
1527: hr_utility.raise_error;
1528: end if;
1529: end if;
1530:
1531: /*650.48.1 If pay plan is GG,

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

1550: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
1551: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
1552: then
1553: GHR_GHRWS52L.CPDF_Parameter_Check;
1554: hr_utility.set_message(8301,'GHR_37827_ALL_PROCEDURE_FAIL');
1555: hr_utility.raise_error;
1556: end if;
1557: end if;
1558:

Line 1555: hr_utility.raise_error;

1551: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
1552: then
1553: GHR_GHRWS52L.CPDF_Parameter_Check;
1554: hr_utility.set_message(8301,'GHR_37827_ALL_PROCEDURE_FAIL');
1555: hr_utility.raise_error;
1556: end if;
1557: end if;
1558:
1559: /* Commenting the edit as per Sept.2000 patch -- refer to doc cpdf_edits_00_sep.doc

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

1581: and not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
1582: or p_to_basic_pay is null
1583: then
1584: GHR_GHRWS52L.CPDF_Parameter_Check;
1585: hr_utility.set_message(8301,'GHR_37856_ALL_PROCEDURE_FAIL');
1586: hr_utility.raise_error;
1587: end if;
1588: end if;
1589: */

Line 1586: hr_utility.raise_error;

1582: or p_to_basic_pay is null
1583: then
1584: GHR_GHRWS52L.CPDF_Parameter_Check;
1585: hr_utility.set_message(8301,'GHR_37856_ALL_PROCEDURE_FAIL');
1586: hr_utility.raise_error;
1587: end if;
1588: end if;
1589: */
1590:

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

1613: and (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
1614: or p_to_basic_pay is null)
1615: then
1616: GHR_GHRWS52L.CPDF_Parameter_Check;
1617: hr_utility.set_message(8301,'GHR_37858_ALL_PROCEDURE_FAIL');
1618: hr_utility.raise_error;
1619: end if;
1620: end if;
1621: */

Line 1618: hr_utility.raise_error;

1614: or p_to_basic_pay is null)
1615: then
1616: GHR_GHRWS52L.CPDF_Parameter_Check;
1617: hr_utility.set_message(8301,'GHR_37858_ALL_PROCEDURE_FAIL');
1618: hr_utility.raise_error;
1619: end if;
1620: end if;
1621: */
1622:

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

1645: and (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
1646: or p_to_basic_pay is null)
1647: then
1648: GHR_GHRWS52L.CPDF_Parameter_Check;
1649: hr_utility.set_message(8301,'GHR_37860_ALL_PROCEDURE_FAIL');
1650: hr_utility.raise_error;
1651: end if;
1652: end if;
1653: */

Line 1650: hr_utility.raise_error;

1646: or p_to_basic_pay is null)
1647: then
1648: GHR_GHRWS52L.CPDF_Parameter_Check;
1649: hr_utility.set_message(8301,'GHR_37860_ALL_PROCEDURE_FAIL');
1650: hr_utility.raise_error;
1651: end if;
1652: end if;
1653: */
1654:

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

1673: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
1674: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
1675: then
1676: GHR_GHRWS52L.CPDF_Parameter_Check;
1677: hr_utility.set_message(8301,'GHR_37828_ALL_PROCEDURE_FAIL');
1678: hr_utility.raise_error;
1679: end if;
1680: end if;
1681:

Line 1678: hr_utility.raise_error;

1674: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
1675: then
1676: GHR_GHRWS52L.CPDF_Parameter_Check;
1677: hr_utility.set_message(8301,'GHR_37828_ALL_PROCEDURE_FAIL');
1678: hr_utility.raise_error;
1679: end if;
1680: end if;
1681:
1682: -- Dec 2001 Patch -- Renamed Edit 650.57.1 to 650.57.3

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

1725: (not(to_number(p_to_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))
1726: or p_to_basic_pay is null)
1727: then
1728: GHR_GHRWS52L.CPDF_Parameter_Check;
1729: hr_utility.set_message(8301,'GHR_37829_ALL_PROCEDURE_FAIL');
1730: hr_utility.raise_error;
1731: end if;
1732: end if; */
1733: -----------------------------------------------------------------------------------------------------------

Line 1730: hr_utility.raise_error;

1726: or p_to_basic_pay is null)
1727: then
1728: GHR_GHRWS52L.CPDF_Parameter_Check;
1729: hr_utility.set_message(8301,'GHR_37829_ALL_PROCEDURE_FAIL');
1730: hr_utility.raise_error;
1731: end if;
1732: end if; */
1733: -----------------------------------------------------------------------------------------------------------
1734:

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

1762: if (not(to_number(p_to_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))
1763: or p_to_basic_pay is null)
1764: then
1765: GHR_GHRWS52L.CPDF_Parameter_Check;
1766: hr_utility.set_message(8301,'GHR_37830_ALL_PROCEDURE_FAIL');
1767: hr_utility.raise_error;
1768: end if;
1769: end if;
1770: end if;

Line 1767: hr_utility.raise_error;

1763: or p_to_basic_pay is null)
1764: then
1765: GHR_GHRWS52L.CPDF_Parameter_Check;
1766: hr_utility.set_message(8301,'GHR_37830_ALL_PROCEDURE_FAIL');
1767: hr_utility.raise_error;
1768: end if;
1769: end if;
1770: end if;
1771: else -- greater than 01-mar-1998

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

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

Line 1800: hr_utility.raise_error;

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

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

1825: and (not(to_number(p_to_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))
1826: or p_to_basic_pay is null)
1827: then
1828: GHR_GHRWS52L.CPDF_Parameter_Check;
1829: hr_utility.set_message(8301,'GHR_37831_ALL_PROCEDURE_FAIL');
1830: hr_utility.raise_error;
1831: end if;
1832: end if;
1833: END IF;

Line 1830: hr_utility.raise_error;

1826: or p_to_basic_pay is null)
1827: then
1828: GHR_GHRWS52L.CPDF_Parameter_Check;
1829: hr_utility.set_message(8301,'GHR_37831_ALL_PROCEDURE_FAIL');
1830: hr_utility.raise_error;
1831: end if;
1832: end if;
1833: END IF;
1834:

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

1854: (not(to_number(p_to_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))
1855: or p_to_basic_pay is null)
1856: then
1857: GHR_GHRWS52L.CPDF_Parameter_Check;
1858: hr_utility.set_message(8301,'GHR_37832_ALL_PROCEDURE_FAIL');
1859: hr_utility.raise_error;
1860: end if;
1861: end if; */
1862:

Line 1859: hr_utility.raise_error;

1855: or p_to_basic_pay is null)
1856: then
1857: GHR_GHRWS52L.CPDF_Parameter_Check;
1858: hr_utility.set_message(8301,'GHR_37832_ALL_PROCEDURE_FAIL');
1859: hr_utility.raise_error;
1860: end if;
1861: end if; */
1862:
1863: /* Commenting the edit as per Sept.2000 patch -- refer to doc cpdf_edits_00_sep.doc

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

1879: and (not(to_number(p_to_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))
1880: or p_to_basic_pay is null)
1881: then
1882: GHR_GHRWS52L.CPDF_Parameter_Check;
1883: hr_utility.set_message(8301,'GHR_37833_ALL_PROCEDURE_FAIL');
1884: hr_utility.raise_error;
1885: end if;
1886: end if;
1887: */

Line 1884: hr_utility.raise_error;

1880: or p_to_basic_pay is null)
1881: then
1882: GHR_GHRWS52L.CPDF_Parameter_Check;
1883: hr_utility.set_message(8301,'GHR_37833_ALL_PROCEDURE_FAIL');
1884: hr_utility.raise_error;
1885: end if;
1886: end if;
1887: */
1888:

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

1910: and (not(to_number(p_to_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))
1911: or p_to_basic_pay is null)
1912: then
1913: GHR_GHRWS52L.CPDF_Parameter_Check;
1914: hr_utility.set_message(8301,'GHR_37834_ALL_PROCEDURE_FAIL');
1915: hr_utility.raise_error;
1916: end if;
1917: end if;
1918:

Line 1915: hr_utility.raise_error;

1911: or p_to_basic_pay is null)
1912: then
1913: GHR_GHRWS52L.CPDF_Parameter_Check;
1914: hr_utility.set_message(8301,'GHR_37834_ALL_PROCEDURE_FAIL');
1915: hr_utility.raise_error;
1916: end if;
1917: end if;
1918:
1919: /* Commenting the edit as per Sept.2000 patch -- refer to doc cpdf_edits_00_sep.doc

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

1945: and (not(to_number(p_to_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))
1946: or p_to_basic_pay is null)
1947: then
1948: GHR_GHRWS52L.CPDF_Parameter_Check;
1949: hr_utility.set_message(8301,'GHR_37081_ALL_PROCEDURE_FAIL');
1950: hr_utility.raise_error;
1951: end if;
1952: end if;
1953: end if;

Line 1950: hr_utility.raise_error;

1946: or p_to_basic_pay is null)
1947: then
1948: GHR_GHRWS52L.CPDF_Parameter_Check;
1949: hr_utility.set_message(8301,'GHR_37081_ALL_PROCEDURE_FAIL');
1950: hr_utility.raise_error;
1951: end if;
1952: end if;
1953: end if;
1954: */

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

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

Line 1986: hr_utility.raise_error;

1982: or p_to_basic_pay is null)
1983: then
1984: GHR_GHRWS52L.CPDF_Parameter_Check;
1985: hr_utility.set_message(8301,'GHR_37078_ALL_PROCEDURE_FAIL');
1986: hr_utility.raise_error;
1987: end if;
1988: end if;
1989: end if;
1990: */

Line 2022: hr_utility.set_message(8301,'GHR_37079_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_37079_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_37079_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_37080_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_37080_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_37080_ALL_PROCEDURE_FAIL');
2059: hr_utility.raise_error;
2060: end if;
2061: end if;
2062: end if;
2063: */

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

2085: if (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
2086: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
2087: then
2088: GHR_GHRWS52L.CPDF_Parameter_Check;
2089: hr_utility.set_message(8301,'GHR_37835_ALL_PROCEDURE_FAIL');
2090: hr_utility.raise_error;
2091: end if;
2092: end if;
2093: end if;

Line 2090: hr_utility.raise_error;

2086: or p_to_basic_pay is null or to_number(p_to_basic_pay) = 0)
2087: then
2088: GHR_GHRWS52L.CPDF_Parameter_Check;
2089: hr_utility.set_message(8301,'GHR_37835_ALL_PROCEDURE_FAIL');
2090: hr_utility.raise_error;
2091: end if;
2092: end if;
2093: end if;
2094: END IF;

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

2121: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
2122: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2123: then
2124: GHR_GHRWS52L.CPDF_Parameter_Check;
2125: hr_utility.set_message(8301,'GHR_37836_ALL_PROCEDURE_FAIL');
2126: hr_utility.set_message_token('TABLE_NUMBER','24');
2127: hr_utility.raise_error;
2128: end if;
2129: end if;

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

2122: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2123: then
2124: GHR_GHRWS52L.CPDF_Parameter_Check;
2125: hr_utility.set_message(8301,'GHR_37836_ALL_PROCEDURE_FAIL');
2126: hr_utility.set_message_token('TABLE_NUMBER','24');
2127: hr_utility.raise_error;
2128: end if;
2129: end if;
2130: elsif p_effective_date >= to_date('2002/09/01','yyyy/mm/dd') then

Line 2127: hr_utility.raise_error;

2123: then
2124: GHR_GHRWS52L.CPDF_Parameter_Check;
2125: hr_utility.set_message(8301,'GHR_37836_ALL_PROCEDURE_FAIL');
2126: hr_utility.set_message_token('TABLE_NUMBER','24');
2127: hr_utility.raise_error;
2128: end if;
2129: end if;
2130: elsif p_effective_date >= to_date('2002/09/01','yyyy/mm/dd') then
2131: if p_agency_subelement = 'DD16' and

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

2144: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
2145: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2146: then
2147: GHR_GHRWS52L.CPDF_Parameter_Check;
2148: hr_utility.set_message(8301,'GHR_37836_ALL_PROCEDURE_FAIL');
2149: hr_utility.set_message_token('TABLE_NUMBER','54');
2150: hr_utility.raise_error;
2151: end if;
2152: end if;

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

2145: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2146: then
2147: GHR_GHRWS52L.CPDF_Parameter_Check;
2148: hr_utility.set_message(8301,'GHR_37836_ALL_PROCEDURE_FAIL');
2149: hr_utility.set_message_token('TABLE_NUMBER','54');
2150: hr_utility.raise_error;
2151: end if;
2152: end if;
2153: end if;

Line 2150: hr_utility.raise_error;

2146: then
2147: GHR_GHRWS52L.CPDF_Parameter_Check;
2148: hr_utility.set_message(8301,'GHR_37836_ALL_PROCEDURE_FAIL');
2149: hr_utility.set_message_token('TABLE_NUMBER','54');
2150: hr_utility.raise_error;
2151: end if;
2152: end if;
2153: end if;
2154: */

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

2178: (not(to_number(p_to_basic_pay) < max_basic_pay)
2179: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2180: then
2181: GHR_GHRWS52L.CPDF_Parameter_Check;
2182: hr_utility.set_message(8301,'GHR_37840_ALL_PROCEDURE_FAIL');
2183: hr_utility.raise_error;
2184: end if;
2185: end if;
2186: */

Line 2183: hr_utility.raise_error;

2179: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2180: then
2181: GHR_GHRWS52L.CPDF_Parameter_Check;
2182: hr_utility.set_message(8301,'GHR_37840_ALL_PROCEDURE_FAIL');
2183: hr_utility.raise_error;
2184: end if;
2185: end if;
2186: */
2187:

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

2213: or p_to_basic_pay is null
2214: or to_number(p_to_basic_pay) = 0)
2215: then
2216: GHR_GHRWS52L.CPDF_Parameter_Check;
2217: hr_utility.set_message(8301,'GHR_37841_ALL_PROCEDURE_FAIL');
2218: hr_utility.raise_error;
2219: end if;
2220: end if;
2221: */

Line 2218: hr_utility.raise_error;

2214: or to_number(p_to_basic_pay) = 0)
2215: then
2216: GHR_GHRWS52L.CPDF_Parameter_Check;
2217: hr_utility.set_message(8301,'GHR_37841_ALL_PROCEDURE_FAIL');
2218: hr_utility.raise_error;
2219: end if;
2220: end if;
2221: */
2222:

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

2242: and (not(to_number(p_to_basic_pay) <= max_basic_pay)
2243: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2244: then
2245: GHR_GHRWS52L.CPDF_Parameter_Check;
2246: hr_utility.set_message(8301,'GHR_37842_ALL_PROCEDURE_FAIL');
2247: hr_utility.raise_error;
2248: end if;
2249: end if;
2250: */

Line 2247: hr_utility.raise_error;

2243: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2244: then
2245: GHR_GHRWS52L.CPDF_Parameter_Check;
2246: hr_utility.set_message(8301,'GHR_37842_ALL_PROCEDURE_FAIL');
2247: hr_utility.raise_error;
2248: end if;
2249: end if;
2250: */
2251: /*650.87.1 If pay plan is other than GH or GM,

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

2275: and (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
2276: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2277: then
2278: GHR_GHRWS52L.CPDF_Parameter_Check;
2279: hr_utility.set_message(8301,'GHR_37843_ALL_PROCEDURE_FAIL');
2280: hr_utility.raise_error;
2281: end if;
2282: end if;
2283: */

Line 2280: hr_utility.raise_error;

2276: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2277: then
2278: GHR_GHRWS52L.CPDF_Parameter_Check;
2279: hr_utility.set_message(8301,'GHR_37843_ALL_PROCEDURE_FAIL');
2280: hr_utility.raise_error;
2281: end if;
2282: end if;
2283: */
2284:

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

2307: and (not(to_number(p_to_basic_pay) < max_basic_pay)
2308: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2309: then
2310: GHR_GHRWS52L.CPDF_Parameter_Check;
2311: hr_utility.set_message(8301,'GHR_37845_ALL_PROCEDURE_FAIL');
2312: hr_utility.raise_error;
2313: end if;
2314: end if;
2315: */

Line 2312: hr_utility.raise_error;

2308: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2309: then
2310: GHR_GHRWS52L.CPDF_Parameter_Check;
2311: hr_utility.set_message(8301,'GHR_37845_ALL_PROCEDURE_FAIL');
2312: hr_utility.raise_error;
2313: end if;
2314: end if;
2315: */
2316: /* Commented as per December 2000 cpdf changes -- vravikan

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

2339: and (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
2340: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2341: then
2342: GHR_GHRWS52L.CPDF_Parameter_Check;
2343: hr_utility.set_message(8301,'GHR_37846_ALL_PROCEDURE_FAIL');
2344: hr_utility.raise_error;
2345: end if;
2346: end if;
2347: */

Line 2344: hr_utility.raise_error;

2340: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2341: then
2342: GHR_GHRWS52L.CPDF_Parameter_Check;
2343: hr_utility.set_message(8301,'GHR_37846_ALL_PROCEDURE_FAIL');
2344: hr_utility.raise_error;
2345: end if;
2346: end if;
2347: */
2348:

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

2372: and (to_number(p_to_basic_pay) <> max_basic_pay
2373: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2374: then
2375: GHR_GHRWS52L.CPDF_Parameter_Check;
2376: hr_utility.set_message(8301,'GHR_37847_ALL_PROCEDURE_FAIL');
2377: hr_utility.raise_error;
2378: end if;
2379: end if;
2380:

Line 2377: hr_utility.raise_error;

2373: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2374: then
2375: GHR_GHRWS52L.CPDF_Parameter_Check;
2376: hr_utility.set_message(8301,'GHR_37847_ALL_PROCEDURE_FAIL');
2377: hr_utility.raise_error;
2378: end if;
2379: end if;
2380:
2381: /*650.97.1 If pay plan is CA,

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

2397: and (to_number(p_to_basic_pay) <> max_basic_pay
2398: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2399: then
2400: GHR_GHRWS52L.CPDF_Parameter_Check;
2401: hr_utility.set_message(8301,'GHR_37848_ALL_PROCEDURE_FAIL');
2402: hr_utility.raise_error;
2403: end if;
2404: end if;
2405:

Line 2402: hr_utility.raise_error;

2398: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2399: then
2400: GHR_GHRWS52L.CPDF_Parameter_Check;
2401: hr_utility.set_message(8301,'GHR_37848_ALL_PROCEDURE_FAIL');
2402: hr_utility.raise_error;
2403: end if;
2404: end if;
2405:
2406: /*650.98.1 If pay plan is ST or SL,

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

2427: and (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)
2428: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2429: then
2430: GHR_GHRWS52L.CPDF_Parameter_Check;
2431: hr_utility.set_message(8301,'GHR_37849_ALL_PROCEDURE_FAIL');
2432: hr_utility.raise_error;
2433: end if;
2434: end if;
2435:

Line 2432: hr_utility.raise_error;

2428: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2429: then
2430: GHR_GHRWS52L.CPDF_Parameter_Check;
2431: hr_utility.set_message(8301,'GHR_37849_ALL_PROCEDURE_FAIL');
2432: hr_utility.raise_error;
2433: end if;
2434: end if;
2435:
2436: /* 650.99.3 If pay plan is IJ,

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

2451: (not(to_number(p_to_basic_pay) <> max_basic_pay)
2452: or p_to_basic_pay is null)
2453: then
2454: GHR_GHRWS52L.CPDF_Parameter_Check;
2455: hr_utility.set_message(8301,'GHR_38551_ALL_PROCEDURE_FAIL');
2456: hr_utility.raise_error;
2457: end if;
2458: end if;
2459:

Line 2456: hr_utility.raise_error;

2452: or p_to_basic_pay is null)
2453: then
2454: GHR_GHRWS52L.CPDF_Parameter_Check;
2455: hr_utility.set_message(8301,'GHR_38551_ALL_PROCEDURE_FAIL');
2456: hr_utility.raise_error;
2457: end if;
2458: end if;
2459:
2460: /*650.53.2 If pay plan is AF, FO, or FP,

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

2478: and (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
2479: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2480: then
2481: GHR_GHRWS52L.CPDF_Parameter_Check;
2482: hr_utility.set_message(8301,'GHR_37850_ALL_PROCEDURE_FAIL');
2483: hr_utility.raise_error;
2484: end if;
2485: end if;
2486:

Line 2483: hr_utility.raise_error;

2479: or p_to_basic_pay is null and to_number(p_to_basic_pay) = 0)
2480: then
2481: GHR_GHRWS52L.CPDF_Parameter_Check;
2482: hr_utility.set_message(8301,'GHR_37850_ALL_PROCEDURE_FAIL');
2483: hr_utility.raise_error;
2484: end if;
2485: end if;
2486:
2487: -- Dec 2001 Patch -- Rename Edit 650.57.2 to 650.57.3

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

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

Line 2529: hr_utility.raise_error;

2525: or p_to_basic_pay is null)
2526: then
2527: GHR_GHRWS52L.CPDF_Parameter_Check;
2528: hr_utility.set_message(8301,'GHR_37851_ALL_PROCEDURE_FAIL');
2529: hr_utility.raise_error;
2530: end if;
2531: end if;
2532: end if;
2533: */

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

2555: and (not(to_number(p_to_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))
2556: or p_to_basic_pay is null)
2557: then
2558: GHR_GHRWS52L.CPDF_Parameter_Check;
2559: hr_utility.set_message(8301,'GHR_37853_ALL_PROCEDURE_FAIL');
2560: hr_utility.raise_error;
2561: end if;
2562: end if;
2563: hr_utility.set_location('Leaving CPDF 8 ',1);

Line 2560: hr_utility.raise_error;

2556: or p_to_basic_pay is null)
2557: then
2558: GHR_GHRWS52L.CPDF_Parameter_Check;
2559: hr_utility.set_message(8301,'GHR_37853_ALL_PROCEDURE_FAIL');
2560: hr_utility.raise_error;
2561: end if;
2562: end if;
2563: hr_utility.set_location('Leaving CPDF 8 ',1);
2564: end basic_pay;

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

2559: hr_utility.set_message(8301,'GHR_37853_ALL_PROCEDURE_FAIL');
2560: hr_utility.raise_error;
2561: end if;
2562: end if;
2563: hr_utility.set_location('Leaving CPDF 8 ',1);
2564: end basic_pay;
2565: end ghr_cpdf_check8;