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 830: l_ind_working_hrs:=round(FND_NUMBER.CANONICAL_TO_NUMBER(p_scl_segment28),2);

826:
827: IF p_scl_segment28 IS NULL then
828: l_ind_working_hrs := NULL;
829: ELSIF p_scl_segment28 <> hr_api.g_varchar2 then
830: l_ind_working_hrs:=round(FND_NUMBER.CANONICAL_TO_NUMBER(p_scl_segment28),2);
831: ELSE
832: l_ind_working_hrs := hr_api.g_number;
833: END if;
834:

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

860:
861: IF p_scl_segment29 IS NULL then
862: l_percentage := NULL;
863: ELSIF p_scl_segment29 <> hr_api.g_varchar2 then
864: l_percentage:=round(FND_NUMBER.CANONICAL_TO_NUMBER(p_scl_segment29),2);
865: ELSE
866: l_percentage := hr_api.g_number;
867: END if;
868:

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

868:
869: IF p_scl_segment20 IS NULL then
870: l_ind_perc := NULL;
871: ELSIF p_scl_segment20 <> hr_api.g_varchar2 then
872: l_ind_perc := FND_NUMBER.CANONICAL_TO_NUMBER(p_scl_segment20);
873: ELSE
874: l_ind_perc := hr_api.g_number;
875: END if;
876:

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

1048:
1049: IF p_segment28 IS NULL THEN
1050: l_ind_working_hrs := NULL;
1051: ELSIF p_segment28 <> hr_api.g_varchar2 then
1052: l_ind_working_hrs:=round(FND_NUMBER.CANONICAL_TO_NUMBER(p_segment28),2);
1053: ELSE
1054: l_ind_working_hrs := hr_api.g_number;
1055: END if;
1056:

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

1056:
1057: IF p_segment29 IS NULL THEN
1058: l_percentage := NULL;
1059: ELSIF p_segment29 <> hr_api.g_varchar2 THEN
1060: l_percentage := FND_NUMBER.CANONICAL_TO_NUMBER(p_segment29);
1061: ELSE
1062: l_percentage := hr_api.g_number;
1063: END IF;
1064:

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

1064:
1065: IF p_segment20 IS NULL THEN
1066: l_ind_perc := NULL;
1067: ELSIF p_segment20 <> hr_api.g_varchar2 THEN
1068: l_ind_perc := FND_NUMBER.CANONICAL_TO_NUMBER(p_segment20);
1069: ELSE
1070: l_ind_perc := hr_api.g_number;
1071: END IF;
1072: