DBA Data[Home] [Help]

APPS.HR_NL_EXTRA_ASG_RULES dependencies on FND_NUMBER

Line 584: (p_ind_working_hrs > fnd_number.canonical_to_number('24') OR

580: END IF;
581:
582:
583: IF (p_frequency = 'D' AND
584: (p_ind_working_hrs > fnd_number.canonical_to_number('24') OR
585: p_normal_hours > fnd_number.canonical_to_number('24'))) THEN
586: hr_utility.set_message(800, 'HR_NL_INCORRECT_FREQUENCY');
587: hr_utility.raise_error;
588: END IF;

Line 585: p_normal_hours > fnd_number.canonical_to_number('24'))) THEN

581:
582:
583: IF (p_frequency = 'D' AND
584: (p_ind_working_hrs > fnd_number.canonical_to_number('24') OR
585: p_normal_hours > fnd_number.canonical_to_number('24'))) THEN
586: hr_utility.set_message(800, 'HR_NL_INCORRECT_FREQUENCY');
587: hr_utility.raise_error;
588: END IF;
589:

Line 591: (p_ind_working_hrs > fnd_number.canonical_to_number('99.99') OR

587: hr_utility.raise_error;
588: END IF;
589:
590: IF (p_frequency = 'W' AND
591: (p_ind_working_hrs > fnd_number.canonical_to_number('99.99') OR
592: p_normal_hours > fnd_number.canonical_to_number('99.99'))) THEN
593: hr_utility.set_message(800, 'HR_NL_INCORRECT_FREQUENCY');
594: hr_utility.raise_error;
595: END IF;

Line 592: p_normal_hours > fnd_number.canonical_to_number('99.99'))) THEN

588: END IF;
589:
590: IF (p_frequency = 'W' AND
591: (p_ind_working_hrs > fnd_number.canonical_to_number('99.99') OR
592: p_normal_hours > fnd_number.canonical_to_number('99.99'))) THEN
593: hr_utility.set_message(800, 'HR_NL_INCORRECT_FREQUENCY');
594: hr_utility.raise_error;
595: END IF;
596:

Line 599: (p_ind_working_hrs > fnd_number.canonical_to_number('744') OR

595: END IF;
596:
597:
598: IF (p_frequency = 'M' AND
599: (p_ind_working_hrs > fnd_number.canonical_to_number('744') OR
600: p_normal_hours > fnd_number.canonical_to_number('744'))) THEN
601: hr_utility.set_message(800, 'HR_NL_INCORRECT_FREQUENCY');
602: hr_utility.raise_error;
603: END IF;

Line 600: p_normal_hours > fnd_number.canonical_to_number('744'))) THEN

596:
597:
598: IF (p_frequency = 'M' AND
599: (p_ind_working_hrs > fnd_number.canonical_to_number('744') OR
600: p_normal_hours > fnd_number.canonical_to_number('744'))) THEN
601: hr_utility.set_message(800, 'HR_NL_INCORRECT_FREQUENCY');
602: hr_utility.raise_error;
603: END IF;
604:

Line 607: (p_ind_working_hrs > fnd_number.canonical_to_number('8784') OR

603: END IF;
604:
605:
606: IF (p_frequency = 'Y' AND
607: (p_ind_working_hrs > fnd_number.canonical_to_number('8784') OR
608: p_normal_hours > fnd_number.canonical_to_number('8784'))) THEN
609: hr_utility.set_message(800, 'HR_NL_INCORRECT_FREQUENCY');
610: hr_utility.raise_error;
611: END IF;

Line 608: p_normal_hours > fnd_number.canonical_to_number('8784'))) THEN

604:
605:
606: IF (p_frequency = 'Y' AND
607: (p_ind_working_hrs > fnd_number.canonical_to_number('8784') OR
608: p_normal_hours > fnd_number.canonical_to_number('8784'))) THEN
609: hr_utility.set_message(800, 'HR_NL_INCORRECT_FREQUENCY');
610: hr_utility.raise_error;
611: END IF;
612:

Line 614: IF (p_ind_perc < fnd_number.canonical_to_number('0.00') OR

610: hr_utility.raise_error;
611: END IF;
612:
613: IF (p_ind_perc <> hr_api.g_number) THEN
614: IF (p_ind_perc < fnd_number.canonical_to_number('0.00') OR
615: p_ind_perc > fnd_number.canonical_to_number('100.00')) THEN
616: hr_utility.set_message(800, 'HR_NL_INVALID_PERCENT');
617: hr_utility.raise_error;
618: END IF;

Line 615: p_ind_perc > fnd_number.canonical_to_number('100.00')) THEN

611: END IF;
612:
613: IF (p_ind_perc <> hr_api.g_number) THEN
614: IF (p_ind_perc < fnd_number.canonical_to_number('0.00') OR
615: p_ind_perc > fnd_number.canonical_to_number('100.00')) THEN
616: hr_utility.set_message(800, 'HR_NL_INVALID_PERCENT');
617: hr_utility.raise_error;
618: END IF;
619: END IF;

Line 622: IF (p_percentage < fnd_number.canonical_to_number('0.00') OR

618: END IF;
619: END IF;
620:
621: IF (p_percentage <> hr_api.g_number) THEN
622: IF (p_percentage < fnd_number.canonical_to_number('0.00') OR
623: p_percentage > fnd_number.canonical_to_number('9999.9999')) THEN
624: hr_utility.set_message(800, 'HR_NL_REALNUMBER_INVALID');
625: hr_utility.set_message_token('MINIMUM', '0.00');
626: hr_utility.set_message_token('MAXIMUM', '9999.9999');

Line 623: p_percentage > fnd_number.canonical_to_number('9999.9999')) THEN

619: END IF;
620:
621: IF (p_percentage <> hr_api.g_number) THEN
622: IF (p_percentage < fnd_number.canonical_to_number('0.00') OR
623: p_percentage > fnd_number.canonical_to_number('9999.9999')) THEN
624: hr_utility.set_message(800, 'HR_NL_REALNUMBER_INVALID');
625: hr_utility.set_message_token('MINIMUM', '0.00');
626: hr_utility.set_message_token('MAXIMUM', '9999.9999');
627: hr_utility.set_message_token('PRECISION', '4');

Line 730: l_ind_working_hrs:=round(FND_NUMBER.CANONICAL_TO_NUMBER(p_scl_segment28),2);

726:
727: IF p_scl_segment28 IS NULL then
728: l_ind_working_hrs := NULL;
729: ELSIF p_scl_segment28 <> hr_api.g_varchar2 then
730: l_ind_working_hrs:=round(FND_NUMBER.CANONICAL_TO_NUMBER(p_scl_segment28),2);
731: ELSE
732: l_ind_working_hrs := hr_api.g_number;
733: END if;
734:

Line 764: l_percentage:=round(FND_NUMBER.CANONICAL_TO_NUMBER(p_scl_segment29),2);

760:
761: IF p_scl_segment29 IS NULL then
762: l_percentage := NULL;
763: ELSIF p_scl_segment29 <> hr_api.g_varchar2 then
764: l_percentage:=round(FND_NUMBER.CANONICAL_TO_NUMBER(p_scl_segment29),2);
765: ELSE
766: l_percentage := hr_api.g_number;
767: END if;
768:

Line 772: l_ind_perc := FND_NUMBER.CANONICAL_TO_NUMBER(p_scl_segment20);

768:
769: IF p_scl_segment20 IS NULL then
770: l_ind_perc := NULL;
771: ELSIF p_scl_segment20 <> hr_api.g_varchar2 then
772: l_ind_perc := FND_NUMBER.CANONICAL_TO_NUMBER(p_scl_segment20);
773: ELSE
774: l_ind_perc := hr_api.g_number;
775: END if;
776:

Line 951: l_ind_working_hrs:=round(FND_NUMBER.CANONICAL_TO_NUMBER(p_segment28),2);

947:
948: IF p_segment28 IS NULL THEN
949: l_ind_working_hrs := NULL;
950: ELSIF p_segment28 <> hr_api.g_varchar2 then
951: l_ind_working_hrs:=round(FND_NUMBER.CANONICAL_TO_NUMBER(p_segment28),2);
952: ELSE
953: l_ind_working_hrs := hr_api.g_number;
954: END if;
955:

Line 959: l_percentage := FND_NUMBER.CANONICAL_TO_NUMBER(p_segment29);

955:
956: IF p_segment29 IS NULL THEN
957: l_percentage := NULL;
958: ELSIF p_segment29 <> hr_api.g_varchar2 THEN
959: l_percentage := FND_NUMBER.CANONICAL_TO_NUMBER(p_segment29);
960: ELSE
961: l_percentage := hr_api.g_number;
962: END IF;
963:

Line 967: l_ind_perc := FND_NUMBER.CANONICAL_TO_NUMBER(p_segment20);

963:
964: IF p_segment20 IS NULL THEN
965: l_ind_perc := NULL;
966: ELSIF p_segment20 <> hr_api.g_varchar2 THEN
967: l_ind_perc := FND_NUMBER.CANONICAL_TO_NUMBER(p_segment20);
968: ELSE
969: l_ind_perc := hr_api.g_number;
970: END IF;
971: