89: --
90: -- The primary key is invalid therefore we must error
91: --
92: close csr_leg_code;
93: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
94: fnd_message.raise_error;
95: end if;
96: hr_utility.set_location(l_proc,30);
97: --
90: -- The primary key is invalid therefore we must error
91: --
92: close csr_leg_code;
93: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
94: fnd_message.raise_error;
95: end if;
96: hr_utility.set_location(l_proc,30);
97: --
98: -- Set the global variables so the values are
327: IF NOT hr_tmp_shd.api_updating
328: (p_form_template_id => p_rec.form_template_id
329: ,p_object_version_number => p_rec.object_version_number
330: ) THEN
331: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
332: fnd_message.set_token('PROCEDURE ', l_proc);
333: fnd_message.set_token('STEP ', '5');
334: fnd_message.raise_error;
335: END IF;
328: (p_form_template_id => p_rec.form_template_id
329: ,p_object_version_number => p_rec.object_version_number
330: ) THEN
331: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
332: fnd_message.set_token('PROCEDURE ', l_proc);
333: fnd_message.set_token('STEP ', '5');
334: fnd_message.raise_error;
335: END IF;
336: --
329: ,p_object_version_number => p_rec.object_version_number
330: ) THEN
331: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
332: fnd_message.set_token('PROCEDURE ', l_proc);
333: fnd_message.set_token('STEP ', '5');
334: fnd_message.raise_error;
335: END IF;
336: --
337: IF (nvl(p_rec.application_id,hr_api.g_number) <>
330: ) THEN
331: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
332: fnd_message.set_token('PROCEDURE ', l_proc);
333: fnd_message.set_token('STEP ', '5');
334: fnd_message.raise_error;
335: END IF;
336: --
337: IF (nvl(p_rec.application_id,hr_api.g_number) <>
338: nvl(hr_tmp_shd.g_old_rec.application_id,hr_api.g_number)
392: OPEN cur_chk_app_id;
393: FETCH cur_chk_app_id INTO l_check;
394: IF cur_chk_app_id%NOTFOUND THEN
395: CLOSE cur_chk_app_id;
396: fnd_message.set_name('PER', 'HR_NEW_MESSAGE');
397: fnd_message.set_token('PROCEDURE', l_proc);
398: fnd_message.set_token('STEP','10');
399: fnd_message.raise_error;
400: END IF;
393: FETCH cur_chk_app_id INTO l_check;
394: IF cur_chk_app_id%NOTFOUND THEN
395: CLOSE cur_chk_app_id;
396: fnd_message.set_name('PER', 'HR_NEW_MESSAGE');
397: fnd_message.set_token('PROCEDURE', l_proc);
398: fnd_message.set_token('STEP','10');
399: fnd_message.raise_error;
400: END IF;
401: CLOSE cur_chk_app_id;
394: IF cur_chk_app_id%NOTFOUND THEN
395: CLOSE cur_chk_app_id;
396: fnd_message.set_name('PER', 'HR_NEW_MESSAGE');
397: fnd_message.set_token('PROCEDURE', l_proc);
398: fnd_message.set_token('STEP','10');
399: fnd_message.raise_error;
400: END IF;
401: CLOSE cur_chk_app_id;
402:
395: CLOSE cur_chk_app_id;
396: fnd_message.set_name('PER', 'HR_NEW_MESSAGE');
397: fnd_message.set_token('PROCEDURE', l_proc);
398: fnd_message.set_token('STEP','10');
399: fnd_message.raise_error;
400: END IF;
401: CLOSE cur_chk_app_id;
402:
403: hr_utility.set_location('Leaving:'||l_proc, 100);
438: OPEN cur_chk_form_id;
439: FETCH cur_chk_form_id INTO l_check;
440: IF cur_chk_form_id%NOTFOUND THEN
441: CLOSE cur_chk_form_id;
442: fnd_message.set_name('PER', 'HR_NEW_MESSAGE');
443: fnd_message.set_token('PROCEDURE', l_proc);
444: fnd_message.set_token('STEP','10');
445: fnd_message.raise_error;
446: END IF;
439: FETCH cur_chk_form_id INTO l_check;
440: IF cur_chk_form_id%NOTFOUND THEN
441: CLOSE cur_chk_form_id;
442: fnd_message.set_name('PER', 'HR_NEW_MESSAGE');
443: fnd_message.set_token('PROCEDURE', l_proc);
444: fnd_message.set_token('STEP','10');
445: fnd_message.raise_error;
446: END IF;
447: CLOSE cur_chk_form_id;
440: IF cur_chk_form_id%NOTFOUND THEN
441: CLOSE cur_chk_form_id;
442: fnd_message.set_name('PER', 'HR_NEW_MESSAGE');
443: fnd_message.set_token('PROCEDURE', l_proc);
444: fnd_message.set_token('STEP','10');
445: fnd_message.raise_error;
446: END IF;
447: CLOSE cur_chk_form_id;
448: --
441: CLOSE cur_chk_form_id;
442: fnd_message.set_name('PER', 'HR_NEW_MESSAGE');
443: fnd_message.set_token('PROCEDURE', l_proc);
444: fnd_message.set_token('STEP','10');
445: fnd_message.raise_error;
446: END IF;
447: CLOSE cur_chk_form_id;
448: --
449: hr_utility.set_location('Leaving:'||l_proc, 100);
480: OPEN cur_chk_leg_code;
481: FETCH cur_chk_leg_code INTO l_check;
482: IF cur_chk_leg_code%NOTFOUND THEN
483: CLOSE cur_chk_leg_code;
484: fnd_message.set_name('PER', 'HR_NEW_MESSAGE');
485: fnd_message.set_token('PROCEDURE', l_proc);
486: fnd_message.set_token('STEP','10');
487: fnd_message.raise_error;
488: END IF;
481: FETCH cur_chk_leg_code INTO l_check;
482: IF cur_chk_leg_code%NOTFOUND THEN
483: CLOSE cur_chk_leg_code;
484: fnd_message.set_name('PER', 'HR_NEW_MESSAGE');
485: fnd_message.set_token('PROCEDURE', l_proc);
486: fnd_message.set_token('STEP','10');
487: fnd_message.raise_error;
488: END IF;
489: CLOSE cur_chk_leg_code ;
482: IF cur_chk_leg_code%NOTFOUND THEN
483: CLOSE cur_chk_leg_code;
484: fnd_message.set_name('PER', 'HR_NEW_MESSAGE');
485: fnd_message.set_token('PROCEDURE', l_proc);
486: fnd_message.set_token('STEP','10');
487: fnd_message.raise_error;
488: END IF;
489: CLOSE cur_chk_leg_code ;
490: --
483: CLOSE cur_chk_leg_code;
484: fnd_message.set_name('PER', 'HR_NEW_MESSAGE');
485: fnd_message.set_token('PROCEDURE', l_proc);
486: fnd_message.set_token('STEP','10');
487: fnd_message.raise_error;
488: END IF;
489: CLOSE cur_chk_leg_code ;
490: --
491: END IF;
519: --
520: -- Check value is in uppercase
521: --
522: if p_template_name <> upper(p_template_name) then
523: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
524: fnd_message.set_token('PROCEDURE', l_proc);
525: fnd_message.set_token('STEP','10');
526: fnd_message.raise_error;
527: end if;
520: -- Check value is in uppercase
521: --
522: if p_template_name <> upper(p_template_name) then
523: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
524: fnd_message.set_token('PROCEDURE', l_proc);
525: fnd_message.set_token('STEP','10');
526: fnd_message.raise_error;
527: end if;
528: --
521: --
522: if p_template_name <> upper(p_template_name) then
523: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
524: fnd_message.set_token('PROCEDURE', l_proc);
525: fnd_message.set_token('STEP','10');
526: fnd_message.raise_error;
527: end if;
528: --
529: hr_utility.set_location('Leaving:'||l_proc, 100);
522: if p_template_name <> upper(p_template_name) then
523: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
524: fnd_message.set_token('PROCEDURE', l_proc);
525: fnd_message.set_token('STEP','10');
526: fnd_message.raise_error;
527: end if;
528: --
529: hr_utility.set_location('Leaving:'||l_proc, 100);
530: End chk_template_name;
582: (p_effective_date => p_effective_date
583: ,p_lookup_type => 'YES_NO'
584: ,p_lookup_code => p_enabled_flag
585: ) then
586: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
587: fnd_message.set_token('PROCEDURE', l_proc);
588: fnd_message.set_token('STEP','10');
589: fnd_message.raise_error;
590: end if;
583: ,p_lookup_type => 'YES_NO'
584: ,p_lookup_code => p_enabled_flag
585: ) then
586: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
587: fnd_message.set_token('PROCEDURE', l_proc);
588: fnd_message.set_token('STEP','10');
589: fnd_message.raise_error;
590: end if;
591: --
584: ,p_lookup_code => p_enabled_flag
585: ) then
586: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
587: fnd_message.set_token('PROCEDURE', l_proc);
588: fnd_message.set_token('STEP','10');
589: fnd_message.raise_error;
590: end if;
591: --
592: end if;
585: ) then
586: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
587: fnd_message.set_token('PROCEDURE', l_proc);
588: fnd_message.set_token('STEP','10');
589: fnd_message.raise_error;
590: end if;
591: --
592: end if;
593: --