151: if nvl(g_business_group_id,-1) <> p_business_group_id then
152: hr_utility.set_location('pay_jp_custom_pkg.set_globals',20);
153:
154: -- Name Translation
155: g_name_tl.salary := fnd_message.get_string('PAY','PAY_JP_SALARY');
156: g_name_tl.bonus := fnd_message.get_string('PAY','PAY_JP_BONUS');
157: g_name_tl.sp_bonus := fnd_message.get_string('PAY','PAY_JP_SP_BONUS');
158: g_name_tl.sp_bonus2 := fnd_message.get_string('PAY','PAY_JP_SP_BON');
159: g_name_tl.yea := fnd_message.get_string('PAY','PAY_JP_YEAR_END_ADJ');
152: hr_utility.set_location('pay_jp_custom_pkg.set_globals',20);
153:
154: -- Name Translation
155: g_name_tl.salary := fnd_message.get_string('PAY','PAY_JP_SALARY');
156: g_name_tl.bonus := fnd_message.get_string('PAY','PAY_JP_BONUS');
157: g_name_tl.sp_bonus := fnd_message.get_string('PAY','PAY_JP_SP_BONUS');
158: g_name_tl.sp_bonus2 := fnd_message.get_string('PAY','PAY_JP_SP_BON');
159: g_name_tl.yea := fnd_message.get_string('PAY','PAY_JP_YEAR_END_ADJ');
160: g_name_tl.yea2 := fnd_message.get_string('PAY','PAY_JP_YEA');
153:
154: -- Name Translation
155: g_name_tl.salary := fnd_message.get_string('PAY','PAY_JP_SALARY');
156: g_name_tl.bonus := fnd_message.get_string('PAY','PAY_JP_BONUS');
157: g_name_tl.sp_bonus := fnd_message.get_string('PAY','PAY_JP_SP_BONUS');
158: g_name_tl.sp_bonus2 := fnd_message.get_string('PAY','PAY_JP_SP_BON');
159: g_name_tl.yea := fnd_message.get_string('PAY','PAY_JP_YEAR_END_ADJ');
160: g_name_tl.yea2 := fnd_message.get_string('PAY','PAY_JP_YEA');
161: g_name_tl.re_yea := fnd_message.get_string('PAY','PAY_JP_RE_YEAR_END_ADJ');
154: -- Name Translation
155: g_name_tl.salary := fnd_message.get_string('PAY','PAY_JP_SALARY');
156: g_name_tl.bonus := fnd_message.get_string('PAY','PAY_JP_BONUS');
157: g_name_tl.sp_bonus := fnd_message.get_string('PAY','PAY_JP_SP_BONUS');
158: g_name_tl.sp_bonus2 := fnd_message.get_string('PAY','PAY_JP_SP_BON');
159: g_name_tl.yea := fnd_message.get_string('PAY','PAY_JP_YEAR_END_ADJ');
160: g_name_tl.yea2 := fnd_message.get_string('PAY','PAY_JP_YEA');
161: g_name_tl.re_yea := fnd_message.get_string('PAY','PAY_JP_RE_YEAR_END_ADJ');
162: g_name_tl.term := fnd_message.get_string('PAY','PAY_JP_TERM_PAY');
155: g_name_tl.salary := fnd_message.get_string('PAY','PAY_JP_SALARY');
156: g_name_tl.bonus := fnd_message.get_string('PAY','PAY_JP_BONUS');
157: g_name_tl.sp_bonus := fnd_message.get_string('PAY','PAY_JP_SP_BONUS');
158: g_name_tl.sp_bonus2 := fnd_message.get_string('PAY','PAY_JP_SP_BON');
159: g_name_tl.yea := fnd_message.get_string('PAY','PAY_JP_YEAR_END_ADJ');
160: g_name_tl.yea2 := fnd_message.get_string('PAY','PAY_JP_YEA');
161: g_name_tl.re_yea := fnd_message.get_string('PAY','PAY_JP_RE_YEAR_END_ADJ');
162: g_name_tl.term := fnd_message.get_string('PAY','PAY_JP_TERM_PAY');
163: g_name_tl.term2 := fnd_message.get_string('PAY','PAY_JP_TERM');
156: g_name_tl.bonus := fnd_message.get_string('PAY','PAY_JP_BONUS');
157: g_name_tl.sp_bonus := fnd_message.get_string('PAY','PAY_JP_SP_BONUS');
158: g_name_tl.sp_bonus2 := fnd_message.get_string('PAY','PAY_JP_SP_BON');
159: g_name_tl.yea := fnd_message.get_string('PAY','PAY_JP_YEAR_END_ADJ');
160: g_name_tl.yea2 := fnd_message.get_string('PAY','PAY_JP_YEA');
161: g_name_tl.re_yea := fnd_message.get_string('PAY','PAY_JP_RE_YEAR_END_ADJ');
162: g_name_tl.term := fnd_message.get_string('PAY','PAY_JP_TERM_PAY');
163: g_name_tl.term2 := fnd_message.get_string('PAY','PAY_JP_TERM');
164: g_name_tl.santei := fnd_message.get_string('PAY','PAY_JP_SANTEI');
157: g_name_tl.sp_bonus := fnd_message.get_string('PAY','PAY_JP_SP_BONUS');
158: g_name_tl.sp_bonus2 := fnd_message.get_string('PAY','PAY_JP_SP_BON');
159: g_name_tl.yea := fnd_message.get_string('PAY','PAY_JP_YEAR_END_ADJ');
160: g_name_tl.yea2 := fnd_message.get_string('PAY','PAY_JP_YEA');
161: g_name_tl.re_yea := fnd_message.get_string('PAY','PAY_JP_RE_YEAR_END_ADJ');
162: g_name_tl.term := fnd_message.get_string('PAY','PAY_JP_TERM_PAY');
163: g_name_tl.term2 := fnd_message.get_string('PAY','PAY_JP_TERM');
164: g_name_tl.santei := fnd_message.get_string('PAY','PAY_JP_SANTEI');
165: g_name_tl.geppen := fnd_message.get_string('PAY','PAY_JP_GEPPEN');
158: g_name_tl.sp_bonus2 := fnd_message.get_string('PAY','PAY_JP_SP_BON');
159: g_name_tl.yea := fnd_message.get_string('PAY','PAY_JP_YEAR_END_ADJ');
160: g_name_tl.yea2 := fnd_message.get_string('PAY','PAY_JP_YEA');
161: g_name_tl.re_yea := fnd_message.get_string('PAY','PAY_JP_RE_YEAR_END_ADJ');
162: g_name_tl.term := fnd_message.get_string('PAY','PAY_JP_TERM_PAY');
163: g_name_tl.term2 := fnd_message.get_string('PAY','PAY_JP_TERM');
164: g_name_tl.santei := fnd_message.get_string('PAY','PAY_JP_SANTEI');
165: g_name_tl.geppen := fnd_message.get_string('PAY','PAY_JP_GEPPEN');
166: g_name_tl.na := fnd_message.get_string('PAY','PAY_JP_AMBIGUOUS');
159: g_name_tl.yea := fnd_message.get_string('PAY','PAY_JP_YEAR_END_ADJ');
160: g_name_tl.yea2 := fnd_message.get_string('PAY','PAY_JP_YEA');
161: g_name_tl.re_yea := fnd_message.get_string('PAY','PAY_JP_RE_YEAR_END_ADJ');
162: g_name_tl.term := fnd_message.get_string('PAY','PAY_JP_TERM_PAY');
163: g_name_tl.term2 := fnd_message.get_string('PAY','PAY_JP_TERM');
164: g_name_tl.santei := fnd_message.get_string('PAY','PAY_JP_SANTEI');
165: g_name_tl.geppen := fnd_message.get_string('PAY','PAY_JP_GEPPEN');
166: g_name_tl.na := fnd_message.get_string('PAY','PAY_JP_AMBIGUOUS');
167: g_name_tl.bal_init_prefix := fnd_message.get_string('PAY','PAY_JP_INIT_PREFIX');
160: g_name_tl.yea2 := fnd_message.get_string('PAY','PAY_JP_YEA');
161: g_name_tl.re_yea := fnd_message.get_string('PAY','PAY_JP_RE_YEAR_END_ADJ');
162: g_name_tl.term := fnd_message.get_string('PAY','PAY_JP_TERM_PAY');
163: g_name_tl.term2 := fnd_message.get_string('PAY','PAY_JP_TERM');
164: g_name_tl.santei := fnd_message.get_string('PAY','PAY_JP_SANTEI');
165: g_name_tl.geppen := fnd_message.get_string('PAY','PAY_JP_GEPPEN');
166: g_name_tl.na := fnd_message.get_string('PAY','PAY_JP_AMBIGUOUS');
167: g_name_tl.bal_init_prefix := fnd_message.get_string('PAY','PAY_JP_INIT_PREFIX');
168: g_name_tl.itax_category := 'ITX_TYPE';
161: g_name_tl.re_yea := fnd_message.get_string('PAY','PAY_JP_RE_YEAR_END_ADJ');
162: g_name_tl.term := fnd_message.get_string('PAY','PAY_JP_TERM_PAY');
163: g_name_tl.term2 := fnd_message.get_string('PAY','PAY_JP_TERM');
164: g_name_tl.santei := fnd_message.get_string('PAY','PAY_JP_SANTEI');
165: g_name_tl.geppen := fnd_message.get_string('PAY','PAY_JP_GEPPEN');
166: g_name_tl.na := fnd_message.get_string('PAY','PAY_JP_AMBIGUOUS');
167: g_name_tl.bal_init_prefix := fnd_message.get_string('PAY','PAY_JP_INIT_PREFIX');
168: g_name_tl.itax_category := 'ITX_TYPE';
169: g_name_tl.yea_category := 'INCLUDE_FLAG';
162: g_name_tl.term := fnd_message.get_string('PAY','PAY_JP_TERM_PAY');
163: g_name_tl.term2 := fnd_message.get_string('PAY','PAY_JP_TERM');
164: g_name_tl.santei := fnd_message.get_string('PAY','PAY_JP_SANTEI');
165: g_name_tl.geppen := fnd_message.get_string('PAY','PAY_JP_GEPPEN');
166: g_name_tl.na := fnd_message.get_string('PAY','PAY_JP_AMBIGUOUS');
167: g_name_tl.bal_init_prefix := fnd_message.get_string('PAY','PAY_JP_INIT_PREFIX');
168: g_name_tl.itax_category := 'ITX_TYPE';
169: g_name_tl.yea_category := 'INCLUDE_FLAG';
170: g_name_tl.yea_category2 := 'INCLUDE_FLAG';
163: g_name_tl.term2 := fnd_message.get_string('PAY','PAY_JP_TERM');
164: g_name_tl.santei := fnd_message.get_string('PAY','PAY_JP_SANTEI');
165: g_name_tl.geppen := fnd_message.get_string('PAY','PAY_JP_GEPPEN');
166: g_name_tl.na := fnd_message.get_string('PAY','PAY_JP_AMBIGUOUS');
167: g_name_tl.bal_init_prefix := fnd_message.get_string('PAY','PAY_JP_INIT_PREFIX');
168: g_name_tl.itax_category := 'ITX_TYPE';
169: g_name_tl.yea_category := 'INCLUDE_FLAG';
170: g_name_tl.yea_category2 := 'INCLUDE_FLAG';
171: g_name_tl.non_res := 'NRES_FLAG';
173: g_name_tl.reyea_element := 'REY_ITX';
174:
175: l_legislation_code := hr_jp_id_pkg.legislation_code(p_business_group_id);
176: if l_legislation_code is NULL then
177: fnd_message.set_name(800,'HR_51255_PYP_INVALID_BUS_GROUP');
178: fnd_message.raise_error;
179: end if;
180:
181: g_business_group_id := p_business_group_id;
174:
175: l_legislation_code := hr_jp_id_pkg.legislation_code(p_business_group_id);
176: if l_legislation_code is NULL then
177: fnd_message.set_name(800,'HR_51255_PYP_INVALID_BUS_GROUP');
178: fnd_message.raise_error;
179: end if;
180:
181: g_business_group_id := p_business_group_id;
182: g_legislation_code := l_legislation_code;
319: -- Write your own validation here.
320: -- 1) Health Insurance Premium Validation
321: if not(p_value.hi_prem_ee = 0 or p_value.hi_prem_er = 0 or p_value.ci_prem_ee = 0 or p_value.ci_prem_er = 0) and (p_value.hi_org_id is NULL) then
322: p_action_status := 'I';
323: fnd_message.set_name('PAY','PAY_JP_INVALID_HI_UNION');
324: fnd_message.set_token('ASG_NUM',l_asg_num);
325: fnd_message.set_token('ASG_ID',p_assignment_id);
326: fnd_message.set_token('ARCH_ASG_ID',p_locking_assignment_action_id);
327: fnd_message.set_token('RUN_ASG_ID',p_locked_assignment_action_id);
320: -- 1) Health Insurance Premium Validation
321: if not(p_value.hi_prem_ee = 0 or p_value.hi_prem_er = 0 or p_value.ci_prem_ee = 0 or p_value.ci_prem_er = 0) and (p_value.hi_org_id is NULL) then
322: p_action_status := 'I';
323: fnd_message.set_name('PAY','PAY_JP_INVALID_HI_UNION');
324: fnd_message.set_token('ASG_NUM',l_asg_num);
325: fnd_message.set_token('ASG_ID',p_assignment_id);
326: fnd_message.set_token('ARCH_ASG_ID',p_locking_assignment_action_id);
327: fnd_message.set_token('RUN_ASG_ID',p_locked_assignment_action_id);
328: p_message := fnd_message.get;
321: if not(p_value.hi_prem_ee = 0 or p_value.hi_prem_er = 0 or p_value.ci_prem_ee = 0 or p_value.ci_prem_er = 0) and (p_value.hi_org_id is NULL) then
322: p_action_status := 'I';
323: fnd_message.set_name('PAY','PAY_JP_INVALID_HI_UNION');
324: fnd_message.set_token('ASG_NUM',l_asg_num);
325: fnd_message.set_token('ASG_ID',p_assignment_id);
326: fnd_message.set_token('ARCH_ASG_ID',p_locking_assignment_action_id);
327: fnd_message.set_token('RUN_ASG_ID',p_locked_assignment_action_id);
328: p_message := fnd_message.get;
329: return;
322: p_action_status := 'I';
323: fnd_message.set_name('PAY','PAY_JP_INVALID_HI_UNION');
324: fnd_message.set_token('ASG_NUM',l_asg_num);
325: fnd_message.set_token('ASG_ID',p_assignment_id);
326: fnd_message.set_token('ARCH_ASG_ID',p_locking_assignment_action_id);
327: fnd_message.set_token('RUN_ASG_ID',p_locked_assignment_action_id);
328: p_message := fnd_message.get;
329: return;
330: end if;
323: fnd_message.set_name('PAY','PAY_JP_INVALID_HI_UNION');
324: fnd_message.set_token('ASG_NUM',l_asg_num);
325: fnd_message.set_token('ASG_ID',p_assignment_id);
326: fnd_message.set_token('ARCH_ASG_ID',p_locking_assignment_action_id);
327: fnd_message.set_token('RUN_ASG_ID',p_locked_assignment_action_id);
328: p_message := fnd_message.get;
329: return;
330: end if;
331:
324: fnd_message.set_token('ASG_NUM',l_asg_num);
325: fnd_message.set_token('ASG_ID',p_assignment_id);
326: fnd_message.set_token('ARCH_ASG_ID',p_locking_assignment_action_id);
327: fnd_message.set_token('RUN_ASG_ID',p_locked_assignment_action_id);
328: p_message := fnd_message.get;
329: return;
330: end if;
331:
332: -- 2) Welfare Pension Insurance Premium Validation
331:
332: -- 2) Welfare Pension Insurance Premium Validation
333: if not(p_value.wp_prem_ee = 0 or p_value.wp_prem_er = 0) and (p_value.wp_org_id is NULL) then
334: p_action_status := 'I';
335: fnd_message.set_name('PAY','PAY_JP_INVALID_WP_UNION');
336: fnd_message.set_token('ASG_NUM',l_asg_num);
337: fnd_message.set_token('ASG_ID',p_assignment_id);
338: fnd_message.set_token('ARCH_ASG_ID',p_locking_assignment_action_id);
339: fnd_message.set_token('RUN_ASG_ID',p_locked_assignment_action_id);
332: -- 2) Welfare Pension Insurance Premium Validation
333: if not(p_value.wp_prem_ee = 0 or p_value.wp_prem_er = 0) and (p_value.wp_org_id is NULL) then
334: p_action_status := 'I';
335: fnd_message.set_name('PAY','PAY_JP_INVALID_WP_UNION');
336: fnd_message.set_token('ASG_NUM',l_asg_num);
337: fnd_message.set_token('ASG_ID',p_assignment_id);
338: fnd_message.set_token('ARCH_ASG_ID',p_locking_assignment_action_id);
339: fnd_message.set_token('RUN_ASG_ID',p_locked_assignment_action_id);
340: p_message := fnd_message.get;
333: if not(p_value.wp_prem_ee = 0 or p_value.wp_prem_er = 0) and (p_value.wp_org_id is NULL) then
334: p_action_status := 'I';
335: fnd_message.set_name('PAY','PAY_JP_INVALID_WP_UNION');
336: fnd_message.set_token('ASG_NUM',l_asg_num);
337: fnd_message.set_token('ASG_ID',p_assignment_id);
338: fnd_message.set_token('ARCH_ASG_ID',p_locking_assignment_action_id);
339: fnd_message.set_token('RUN_ASG_ID',p_locked_assignment_action_id);
340: p_message := fnd_message.get;
341: return;
334: p_action_status := 'I';
335: fnd_message.set_name('PAY','PAY_JP_INVALID_WP_UNION');
336: fnd_message.set_token('ASG_NUM',l_asg_num);
337: fnd_message.set_token('ASG_ID',p_assignment_id);
338: fnd_message.set_token('ARCH_ASG_ID',p_locking_assignment_action_id);
339: fnd_message.set_token('RUN_ASG_ID',p_locked_assignment_action_id);
340: p_message := fnd_message.get;
341: return;
342: end if;
335: fnd_message.set_name('PAY','PAY_JP_INVALID_WP_UNION');
336: fnd_message.set_token('ASG_NUM',l_asg_num);
337: fnd_message.set_token('ASG_ID',p_assignment_id);
338: fnd_message.set_token('ARCH_ASG_ID',p_locking_assignment_action_id);
339: fnd_message.set_token('RUN_ASG_ID',p_locked_assignment_action_id);
340: p_message := fnd_message.get;
341: return;
342: end if;
343:
336: fnd_message.set_token('ASG_NUM',l_asg_num);
337: fnd_message.set_token('ASG_ID',p_assignment_id);
338: fnd_message.set_token('ARCH_ASG_ID',p_locking_assignment_action_id);
339: fnd_message.set_token('RUN_ASG_ID',p_locked_assignment_action_id);
340: p_message := fnd_message.get;
341: return;
342: end if;
343:
344: -- 3) Welfare Pension Fund Premium Validation
343:
344: -- 3) Welfare Pension Fund Premium Validation
345: if not(p_value.wpf_prem_ee = 0 or p_value.wpf_prem_er = 0) and (p_value.wpf_org_id is NULL) then
346: p_action_status := 'I';
347: fnd_message.set_name('PAY','PAY_JP_INVALID_WP_FUND');
348: fnd_message.set_token('ASG_NUM',l_asg_num);
349: fnd_message.set_token('ASG_ID',p_assignment_id);
350: fnd_message.set_token('ARCH_ASG_ID',p_locking_assignment_action_id);
351: fnd_message.set_token('RUN_ASG_ID',p_locked_assignment_action_id);
344: -- 3) Welfare Pension Fund Premium Validation
345: if not(p_value.wpf_prem_ee = 0 or p_value.wpf_prem_er = 0) and (p_value.wpf_org_id is NULL) then
346: p_action_status := 'I';
347: fnd_message.set_name('PAY','PAY_JP_INVALID_WP_FUND');
348: fnd_message.set_token('ASG_NUM',l_asg_num);
349: fnd_message.set_token('ASG_ID',p_assignment_id);
350: fnd_message.set_token('ARCH_ASG_ID',p_locking_assignment_action_id);
351: fnd_message.set_token('RUN_ASG_ID',p_locked_assignment_action_id);
352: p_message := fnd_message.get;
345: if not(p_value.wpf_prem_ee = 0 or p_value.wpf_prem_er = 0) and (p_value.wpf_org_id is NULL) then
346: p_action_status := 'I';
347: fnd_message.set_name('PAY','PAY_JP_INVALID_WP_FUND');
348: fnd_message.set_token('ASG_NUM',l_asg_num);
349: fnd_message.set_token('ASG_ID',p_assignment_id);
350: fnd_message.set_token('ARCH_ASG_ID',p_locking_assignment_action_id);
351: fnd_message.set_token('RUN_ASG_ID',p_locked_assignment_action_id);
352: p_message := fnd_message.get;
353: return;
346: p_action_status := 'I';
347: fnd_message.set_name('PAY','PAY_JP_INVALID_WP_FUND');
348: fnd_message.set_token('ASG_NUM',l_asg_num);
349: fnd_message.set_token('ASG_ID',p_assignment_id);
350: fnd_message.set_token('ARCH_ASG_ID',p_locking_assignment_action_id);
351: fnd_message.set_token('RUN_ASG_ID',p_locked_assignment_action_id);
352: p_message := fnd_message.get;
353: return;
354: end if;
347: fnd_message.set_name('PAY','PAY_JP_INVALID_WP_FUND');
348: fnd_message.set_token('ASG_NUM',l_asg_num);
349: fnd_message.set_token('ASG_ID',p_assignment_id);
350: fnd_message.set_token('ARCH_ASG_ID',p_locking_assignment_action_id);
351: fnd_message.set_token('RUN_ASG_ID',p_locked_assignment_action_id);
352: p_message := fnd_message.get;
353: return;
354: end if;
355:
348: fnd_message.set_token('ASG_NUM',l_asg_num);
349: fnd_message.set_token('ASG_ID',p_assignment_id);
350: fnd_message.set_token('ARCH_ASG_ID',p_locking_assignment_action_id);
351: fnd_message.set_token('RUN_ASG_ID',p_locked_assignment_action_id);
352: p_message := fnd_message.get;
353: return;
354: end if;
355:
356: -- 4) Unemployment Insurance Premium Validation
355:
356: -- 4) Unemployment Insurance Premium Validation
357: if not(p_value.ui_prem_ee = 0) and (nvl(p_value.ui_category,'E') = 'E' or p_value.ui_org_id is NULL) then
358: p_action_status := 'I';
359: fnd_message.set_name('PAY','PAY_JP_INVALID_UI_UNION');
360: fnd_message.set_token('ASG_NUM',l_asg_num);
361: fnd_message.set_token('ASG_ID',p_assignment_id);
362: fnd_message.set_token('ARCH_ASG_ID',p_locking_assignment_action_id);
363: fnd_message.set_token('RUN_ASG_ID',p_locked_assignment_action_id);
356: -- 4) Unemployment Insurance Premium Validation
357: if not(p_value.ui_prem_ee = 0) and (nvl(p_value.ui_category,'E') = 'E' or p_value.ui_org_id is NULL) then
358: p_action_status := 'I';
359: fnd_message.set_name('PAY','PAY_JP_INVALID_UI_UNION');
360: fnd_message.set_token('ASG_NUM',l_asg_num);
361: fnd_message.set_token('ASG_ID',p_assignment_id);
362: fnd_message.set_token('ARCH_ASG_ID',p_locking_assignment_action_id);
363: fnd_message.set_token('RUN_ASG_ID',p_locked_assignment_action_id);
364: p_message := fnd_message.get;
357: if not(p_value.ui_prem_ee = 0) and (nvl(p_value.ui_category,'E') = 'E' or p_value.ui_org_id is NULL) then
358: p_action_status := 'I';
359: fnd_message.set_name('PAY','PAY_JP_INVALID_UI_UNION');
360: fnd_message.set_token('ASG_NUM',l_asg_num);
361: fnd_message.set_token('ASG_ID',p_assignment_id);
362: fnd_message.set_token('ARCH_ASG_ID',p_locking_assignment_action_id);
363: fnd_message.set_token('RUN_ASG_ID',p_locked_assignment_action_id);
364: p_message := fnd_message.get;
365: return;
358: p_action_status := 'I';
359: fnd_message.set_name('PAY','PAY_JP_INVALID_UI_UNION');
360: fnd_message.set_token('ASG_NUM',l_asg_num);
361: fnd_message.set_token('ASG_ID',p_assignment_id);
362: fnd_message.set_token('ARCH_ASG_ID',p_locking_assignment_action_id);
363: fnd_message.set_token('RUN_ASG_ID',p_locked_assignment_action_id);
364: p_message := fnd_message.get;
365: return;
366: end if;
359: fnd_message.set_name('PAY','PAY_JP_INVALID_UI_UNION');
360: fnd_message.set_token('ASG_NUM',l_asg_num);
361: fnd_message.set_token('ASG_ID',p_assignment_id);
362: fnd_message.set_token('ARCH_ASG_ID',p_locking_assignment_action_id);
363: fnd_message.set_token('RUN_ASG_ID',p_locked_assignment_action_id);
364: p_message := fnd_message.get;
365: return;
366: end if;
367:
360: fnd_message.set_token('ASG_NUM',l_asg_num);
361: fnd_message.set_token('ASG_ID',p_assignment_id);
362: fnd_message.set_token('ARCH_ASG_ID',p_locking_assignment_action_id);
363: fnd_message.set_token('RUN_ASG_ID',p_locked_assignment_action_id);
364: p_message := fnd_message.get;
365: return;
366: end if;
367:
368: -- 5) Income Tax Validation
368: -- 5) Income Tax Validation
369: if not(p_value.taxable_sal_amt = 0 and p_value.taxable_mat_amt = 0 and p_value.itax = 0 and p_value.itax_adjustment = 0)
370: and (p_value.itax_org_id is NULL or nvl(p_value.itax_category,'E') = 'E') then
371: p_action_status := 'I';
372: fnd_message.set_name('PAY','PAY_JP_INVALID_ITAX_SWOT');
373: fnd_message.set_token('ASG_NUM',l_asg_num);
374: fnd_message.set_token('ASG_ID',p_assignment_id);
375: fnd_message.set_token('ARCH_ASG_ID',p_locking_assignment_action_id);
376: fnd_message.set_token('RUN_ASG_ID',p_locked_assignment_action_id);
369: if not(p_value.taxable_sal_amt = 0 and p_value.taxable_mat_amt = 0 and p_value.itax = 0 and p_value.itax_adjustment = 0)
370: and (p_value.itax_org_id is NULL or nvl(p_value.itax_category,'E') = 'E') then
371: p_action_status := 'I';
372: fnd_message.set_name('PAY','PAY_JP_INVALID_ITAX_SWOT');
373: fnd_message.set_token('ASG_NUM',l_asg_num);
374: fnd_message.set_token('ASG_ID',p_assignment_id);
375: fnd_message.set_token('ARCH_ASG_ID',p_locking_assignment_action_id);
376: fnd_message.set_token('RUN_ASG_ID',p_locked_assignment_action_id);
377: p_message := fnd_message.get;
370: and (p_value.itax_org_id is NULL or nvl(p_value.itax_category,'E') = 'E') then
371: p_action_status := 'I';
372: fnd_message.set_name('PAY','PAY_JP_INVALID_ITAX_SWOT');
373: fnd_message.set_token('ASG_NUM',l_asg_num);
374: fnd_message.set_token('ASG_ID',p_assignment_id);
375: fnd_message.set_token('ARCH_ASG_ID',p_locking_assignment_action_id);
376: fnd_message.set_token('RUN_ASG_ID',p_locked_assignment_action_id);
377: p_message := fnd_message.get;
378: return;
371: p_action_status := 'I';
372: fnd_message.set_name('PAY','PAY_JP_INVALID_ITAX_SWOT');
373: fnd_message.set_token('ASG_NUM',l_asg_num);
374: fnd_message.set_token('ASG_ID',p_assignment_id);
375: fnd_message.set_token('ARCH_ASG_ID',p_locking_assignment_action_id);
376: fnd_message.set_token('RUN_ASG_ID',p_locked_assignment_action_id);
377: p_message := fnd_message.get;
378: return;
379: end if;
372: fnd_message.set_name('PAY','PAY_JP_INVALID_ITAX_SWOT');
373: fnd_message.set_token('ASG_NUM',l_asg_num);
374: fnd_message.set_token('ASG_ID',p_assignment_id);
375: fnd_message.set_token('ARCH_ASG_ID',p_locking_assignment_action_id);
376: fnd_message.set_token('RUN_ASG_ID',p_locked_assignment_action_id);
377: p_message := fnd_message.get;
378: return;
379: end if;
380:
373: fnd_message.set_token('ASG_NUM',l_asg_num);
374: fnd_message.set_token('ASG_ID',p_assignment_id);
375: fnd_message.set_token('ARCH_ASG_ID',p_locking_assignment_action_id);
376: fnd_message.set_token('RUN_ASG_ID',p_locked_assignment_action_id);
377: p_message := fnd_message.get;
378: return;
379: end if;
380:
381: -- 6) Local Tax Validation
389: or (p_value.ltax_lumpsum <> 0 and p_value.ltax_district_code is NULL))) then
390: --if not(p_value.ltax = 0 and p_value.ltax_lumpsum = 0 and p_value.sp_ltax = 0)
391: --and (p_value.itax_org_id is NULL or p_value.ltax_district_code is NULL) then
392: p_action_status := 'I';
393: fnd_message.set_name('PAY','PAY_JP_INVALID_LTAX_SWOT');
394: fnd_message.set_token('ASG_NUM',l_asg_num);
395: fnd_message.set_token('ASG_ID',p_assignment_id);
396: fnd_message.set_token('ARCH_ASG_ID',p_locking_assignment_action_id);
397: fnd_message.set_token('RUN_ASG_ID',p_locked_assignment_action_id);
390: --if not(p_value.ltax = 0 and p_value.ltax_lumpsum = 0 and p_value.sp_ltax = 0)
391: --and (p_value.itax_org_id is NULL or p_value.ltax_district_code is NULL) then
392: p_action_status := 'I';
393: fnd_message.set_name('PAY','PAY_JP_INVALID_LTAX_SWOT');
394: fnd_message.set_token('ASG_NUM',l_asg_num);
395: fnd_message.set_token('ASG_ID',p_assignment_id);
396: fnd_message.set_token('ARCH_ASG_ID',p_locking_assignment_action_id);
397: fnd_message.set_token('RUN_ASG_ID',p_locked_assignment_action_id);
398: p_message := fnd_message.get;
391: --and (p_value.itax_org_id is NULL or p_value.ltax_district_code is NULL) then
392: p_action_status := 'I';
393: fnd_message.set_name('PAY','PAY_JP_INVALID_LTAX_SWOT');
394: fnd_message.set_token('ASG_NUM',l_asg_num);
395: fnd_message.set_token('ASG_ID',p_assignment_id);
396: fnd_message.set_token('ARCH_ASG_ID',p_locking_assignment_action_id);
397: fnd_message.set_token('RUN_ASG_ID',p_locked_assignment_action_id);
398: p_message := fnd_message.get;
399: return;
392: p_action_status := 'I';
393: fnd_message.set_name('PAY','PAY_JP_INVALID_LTAX_SWOT');
394: fnd_message.set_token('ASG_NUM',l_asg_num);
395: fnd_message.set_token('ASG_ID',p_assignment_id);
396: fnd_message.set_token('ARCH_ASG_ID',p_locking_assignment_action_id);
397: fnd_message.set_token('RUN_ASG_ID',p_locked_assignment_action_id);
398: p_message := fnd_message.get;
399: return;
400: end if;
393: fnd_message.set_name('PAY','PAY_JP_INVALID_LTAX_SWOT');
394: fnd_message.set_token('ASG_NUM',l_asg_num);
395: fnd_message.set_token('ASG_ID',p_assignment_id);
396: fnd_message.set_token('ARCH_ASG_ID',p_locking_assignment_action_id);
397: fnd_message.set_token('RUN_ASG_ID',p_locked_assignment_action_id);
398: p_message := fnd_message.get;
399: return;
400: end if;
401:
394: fnd_message.set_token('ASG_NUM',l_asg_num);
395: fnd_message.set_token('ASG_ID',p_assignment_id);
396: fnd_message.set_token('ARCH_ASG_ID',p_locking_assignment_action_id);
397: fnd_message.set_token('RUN_ASG_ID',p_locked_assignment_action_id);
398: p_message := fnd_message.get;
399: return;
400: end if;
401:
402: hr_utility.set_location('pay_jp_custom_pkg.validate_record',20);