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.HR_NL_EXTRA_ASG_RULES dependencies on HR_API

Line 122: IF p_tax_code= hr_api.g_varchar2 THEN

118: hr_utility.trace('tax_details_rec.tax_red '||tax_details_rec.tax_red );
119: hr_utility.trace('tax_details_rec.labour_tax '||tax_details_rec.labour_tax );
120: hr_utility.trace('tax_details_rec.add_sr_tax '||tax_details_rec.add_sr_tax );
121: */
122: IF p_tax_code= hr_api.g_varchar2 THEN
123: l_tax_code := NVL(tax_details_rec.tax_code,'940') ;
124: END IF;
125: IF p_tax_red_apply= hr_api.g_varchar2 THEN
126: l_tax_red_apply := NVL(tax_details_rec.tax_red,'N') ;

Line 125: IF p_tax_red_apply= hr_api.g_varchar2 THEN

121: */
122: IF p_tax_code= hr_api.g_varchar2 THEN
123: l_tax_code := NVL(tax_details_rec.tax_code,'940') ;
124: END IF;
125: IF p_tax_red_apply= hr_api.g_varchar2 THEN
126: l_tax_red_apply := NVL(tax_details_rec.tax_red,'N') ;
127: END IF;
128: IF p_labour_tax_apply= hr_api.g_varchar2 THEN
129: l_labour_tax_apply := NVL(tax_details_rec.labour_tax,'N') ;

Line 128: IF p_labour_tax_apply= hr_api.g_varchar2 THEN

124: END IF;
125: IF p_tax_red_apply= hr_api.g_varchar2 THEN
126: l_tax_red_apply := NVL(tax_details_rec.tax_red,'N') ;
127: END IF;
128: IF p_labour_tax_apply= hr_api.g_varchar2 THEN
129: l_labour_tax_apply := NVL(tax_details_rec.labour_tax,'N') ;
130: END IF;
131: IF p_add_sr_tax_apply= hr_api.g_varchar2 THEN
132: l_add_sr_tax_apply := NVL(tax_details_rec.add_sr_tax,'N') ;

Line 131: IF p_add_sr_tax_apply= hr_api.g_varchar2 THEN

127: END IF;
128: IF p_labour_tax_apply= hr_api.g_varchar2 THEN
129: l_labour_tax_apply := NVL(tax_details_rec.labour_tax,'N') ;
130: END IF;
131: IF p_add_sr_tax_apply= hr_api.g_varchar2 THEN
132: l_add_sr_tax_apply := NVL(tax_details_rec.add_sr_tax,'N') ;
133: END IF;
134: END IF;
135: /*

Line 331: IF p_special_indicators = hr_api.g_varchar2 THEN

327:
328: BEGIN
329: hr_utility.trace('Entering validate_spl_indicators');
330: --
331: IF p_special_indicators = hr_api.g_varchar2 THEN
332: open csr_get_spl_indicator_details(p_assignment_id,p_effective_date);
333: fetch csr_get_spl_indicator_details into l_special_indicators2;
334: l_special_indicators := l_special_indicators2.special_indicator;
335: close csr_get_spl_indicator_details;

Line 498: IF p_employment_type= hr_api.g_varchar2 THEN

494:
495: OPEN csr_get_asg_oth_details(p_assignment_id,p_effective_date);
496: FETCH csr_get_asg_oth_details INTO oth_details_rec;
497: IF csr_get_asg_oth_details%FOUND THEN
498: IF p_employment_type= hr_api.g_varchar2 THEN
499: l_emp_type := oth_details_rec.emp_type ;
500: END IF;
501: IF p_employment_subtype= hr_api.g_varchar2 THEN
502: l_emp_sub_type := oth_details_rec.emp_sub_type ;

Line 501: IF p_employment_subtype= hr_api.g_varchar2 THEN

497: IF csr_get_asg_oth_details%FOUND THEN
498: IF p_employment_type= hr_api.g_varchar2 THEN
499: l_emp_type := oth_details_rec.emp_type ;
500: END IF;
501: IF p_employment_subtype= hr_api.g_varchar2 THEN
502: l_emp_sub_type := oth_details_rec.emp_sub_type ;
503: END IF;
504: IF p_commencing_from= hr_api.g_date THEN
505: l_commencing_from := oth_details_rec.commencing_from ;

Line 504: IF p_commencing_from= hr_api.g_date THEN

500: END IF;
501: IF p_employment_subtype= hr_api.g_varchar2 THEN
502: l_emp_sub_type := oth_details_rec.emp_sub_type ;
503: END IF;
504: IF p_commencing_from= hr_api.g_date THEN
505: l_commencing_from := oth_details_rec.commencing_from ;
506: END IF;
507: IF p_date_ending= hr_api.g_date THEN
508: l_date_ending := oth_details_rec.date_ending ;

Line 507: IF p_date_ending= hr_api.g_date THEN

503: END IF;
504: IF p_commencing_from= hr_api.g_date THEN
505: l_commencing_from := oth_details_rec.commencing_from ;
506: END IF;
507: IF p_date_ending= hr_api.g_date THEN
508: l_date_ending := oth_details_rec.date_ending ;
509: END IF;
510:
511:

Line 575: IF ((p_ind_working_hrs <> hr_api.g_number OR p_normal_hours <> hr_api.g_number)

571: -- Message Text -
572: -- "You are attempting to save this record without submitting all of the
573: -- mandatory information. Please enter a value in Frequency."
574:
575: IF ((p_ind_working_hrs <> hr_api.g_number OR p_normal_hours <> hr_api.g_number)
576: AND p_frequency IS null) THEN
577: hr_utility.set_message(800, 'HR_NL_REQUIRED_FIELD');
578: hr_utility.set_message_token('FIELD', 'Frequency');
579: hr_utility.raise_error;

Line 613: IF (p_ind_perc <> hr_api.g_number) THEN

609: hr_utility.set_message(800, 'HR_NL_INCORRECT_FREQUENCY');
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;

Line 621: IF (p_percentage <> hr_api.g_number) THEN

617: hr_utility.raise_error;
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');

Line 829: ELSIF p_scl_segment28 <> hr_api.g_varchar2 then

825: l_frequency:=p_frequency;
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;

Line 832: l_ind_working_hrs := hr_api.g_number;

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:
835: validate_tax_code_combinations(p_person_id
836: ,null ,p_payroll_id ,p_effective_date

Line 847: ELSIF p_scl_segment21 <> hr_api.g_varchar2 then

843:
844:
845: IF p_scl_segment21 IS NULL then
846: l_commencing_date := NULL;
847: ELSIF p_scl_segment21 <> hr_api.g_varchar2 then
848: l_commencing_date:=FND_DATE.CANONICAL_TO_DATE(p_scl_segment21);
849: ELSE
850: l_commencing_date := hr_api.g_date;
851: END if;

Line 850: l_commencing_date := hr_api.g_date;

846: l_commencing_date := NULL;
847: ELSIF p_scl_segment21 <> hr_api.g_varchar2 then
848: l_commencing_date:=FND_DATE.CANONICAL_TO_DATE(p_scl_segment21);
849: ELSE
850: l_commencing_date := hr_api.g_date;
851: END if;
852:
853: IF p_scl_segment23 IS NULL then
854: l_date_ending := NULL;

Line 855: ELSIF p_scl_segment23 <> hr_api.g_varchar2 then

851: END if;
852:
853: IF p_scl_segment23 IS NULL then
854: l_date_ending := NULL;
855: ELSIF p_scl_segment23 <> hr_api.g_varchar2 then
856: l_date_ending:=FND_DATE.CANONICAL_TO_DATE(p_scl_segment23);
857: ELSE
858: l_date_ending := hr_api.g_date;
859: END if;

Line 858: l_date_ending := hr_api.g_date;

854: l_date_ending := NULL;
855: ELSIF p_scl_segment23 <> hr_api.g_varchar2 then
856: l_date_ending:=FND_DATE.CANONICAL_TO_DATE(p_scl_segment23);
857: ELSE
858: l_date_ending := hr_api.g_date;
859: END if;
860:
861: IF p_scl_segment29 IS NULL then
862: l_percentage := NULL;

Line 863: ELSIF p_scl_segment29 <> hr_api.g_varchar2 then

859: END if;
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;

Line 866: l_percentage := hr_api.g_number;

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:
869: IF p_scl_segment20 IS NULL then
870: l_ind_perc := NULL;

Line 871: ELSIF p_scl_segment20 <> hr_api.g_varchar2 then

867: END if;
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;

Line 874: l_ind_perc := hr_api.g_number;

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:
877:
878: other_validations(null ,p_effective_date

Line 1018: ELSIF p_frequency =hr_api.g_varchar2 then

1014: END IF;
1015: l_frequency:=p_frequency;
1016: IF p_frequency IS NULL then
1017: l_frequency := NULL;
1018: ELSIF p_frequency =hr_api.g_varchar2 then
1019: open csr_freq;
1020: fetch csr_freq into l_frequency ;
1021: close csr_freq;
1022: END if;

Line 1030: IF p_segment21 = hr_api.g_varchar2 THEN

1026: ,p_segment11 ,p_segment4 ,p_segment7 ,p_segment9);
1027:
1028: validate_spl_indicators(p_segment10,p_assignment_id,p_effective_date);
1029:
1030: IF p_segment21 = hr_api.g_varchar2 THEN
1031: open csr_get_date_details(p_assignment_id,p_effective_date);
1032: hr_utility.trace('DATE1');
1033: fetch csr_get_date_details into date_details_rec;
1034: l_commencing_date := fnd_date.canonical_to_date(date_details_rec.commencing_date);

Line 1040: IF p_segment23 = hr_api.g_varchar2 THEN

1036: ELSE
1037: l_commencing_date := fnd_date.canonical_to_date(p_segment21);
1038: END IF;
1039:
1040: IF p_segment23 = hr_api.g_varchar2 THEN
1041: open csr_get_date_details(p_assignment_id,p_effective_date);
1042: fetch csr_get_date_details into date_details_rec;
1043: l_date_ending := fnd_date.canonical_to_date(date_details_rec.date_ending);
1044: close csr_get_date_details;

Line 1051: ELSIF p_segment28 <> hr_api.g_varchar2 then

1047: END IF;
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;

Line 1054: l_ind_working_hrs := hr_api.g_number;

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:
1057: IF p_segment29 IS NULL THEN
1058: l_percentage := NULL;

Line 1059: ELSIF p_segment29 <> hr_api.g_varchar2 THEN

1055: END if;
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;

Line 1062: l_percentage := hr_api.g_number;

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:
1065: IF p_segment20 IS NULL THEN
1066: l_ind_perc := NULL;

Line 1067: ELSIF p_segment20 <> hr_api.g_varchar2 THEN

1063: END IF;
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;

Line 1070: l_ind_perc := hr_api.g_number;

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:
1073:
1074: other_validations(p_assignment_id

Line 1081: IF p_establishment_id <> hr_api.g_number THEN

1077: ,l_ind_working_hrs ,l_ind_perc
1078: ,l_percentage ,l_frequency,p_normal_hours);
1079:
1080: --14084074
1081: IF p_establishment_id <> hr_api.g_number THEN
1082: IF NOT validate_employer_change(p_assignment_id,p_establishment_id,v_csr_asg.business_group_id,p_effective_date) THEN
1083: hr_utility.set_message(800, 'HR_373479_NL_EMPLOYER_CHG');
1084: hr_utility.raise_error;
1085: END IF;