19:
20:
21: BEGIN
22: l_proc := g_package||'create_asg_validate';
23: --hr_utility.trace_on(null,'Extra1');
24: hr_utility.set_location('Entering : '||l_proc,10);
25: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN
26: hr_utility.set_location('Leaving : '||l_proc,10);
27: return;
20:
21: BEGIN
22: l_proc := g_package||'create_asg_validate';
23: --hr_utility.trace_on(null,'Extra1');
24: hr_utility.set_location('Entering : '||l_proc,10);
25: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN
26: hr_utility.set_location('Leaving : '||l_proc,10);
27: return;
28: END IF;
21: BEGIN
22: l_proc := g_package||'create_asg_validate';
23: --hr_utility.trace_on(null,'Extra1');
24: hr_utility.set_location('Entering : '||l_proc,10);
25: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN
26: hr_utility.set_location('Leaving : '||l_proc,10);
27: return;
28: END IF;
29: --
22: l_proc := g_package||'create_asg_validate';
23: --hr_utility.trace_on(null,'Extra1');
24: hr_utility.set_location('Entering : '||l_proc,10);
25: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN
26: hr_utility.set_location('Leaving : '||l_proc,10);
27: return;
28: END IF;
29: --
30: hr_utility.set_location('Contract_id=> ' || P_contract_id, 40);
26: hr_utility.set_location('Leaving : '||l_proc,10);
27: return;
28: END IF;
29: --
30: hr_utility.set_location('Contract_id=> ' || P_contract_id, 40);
31: if p_contract_id is not null then
32: open csr_assignment_contract;
33: fetch csr_assignment_contract into l_exist;
34: if csr_assignment_contract%found then
31: if p_contract_id is not null then
32: open csr_assignment_contract;
33: fetch csr_assignment_contract into l_exist;
34: if csr_assignment_contract%found then
35: hr_utility.set_message('800','HR_520045_DUP_CONTRACT_ID');
36: hr_utility.raise_error;
37: end if;
38: close csr_assignment_contract;
39:
32: open csr_assignment_contract;
33: fetch csr_assignment_contract into l_exist;
34: if csr_assignment_contract%found then
35: hr_utility.set_message('800','HR_520045_DUP_CONTRACT_ID');
36: hr_utility.raise_error;
37: end if;
38: close csr_assignment_contract;
39:
40: end IF;
38: close csr_assignment_contract;
39:
40: end IF;
41:
42: hr_utility.set_location('Leaving : '||l_proc,20);
43: --hr_utility.trace_off;
44: END create_asg_validate;
45:
46: -------------------------------------------------------------------------------------------------------
39:
40: end IF;
41:
42: hr_utility.set_location('Leaving : '||l_proc,20);
43: --hr_utility.trace_off;
44: END create_asg_validate;
45:
46: -------------------------------------------------------------------------------------------------------
47:
66: l_contract_signed_date PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
67:
68: BEGIN
69: l_proc := g_package||'update_asg_validate';
70: --hr_utility.trace_on(null,'Extra');
71: hr_utility.set_location('Entering : '||l_proc,10);
72: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN
73: hr_utility.set_location('Leaving : '||l_proc,10);
74: return;
67:
68: BEGIN
69: l_proc := g_package||'update_asg_validate';
70: --hr_utility.trace_on(null,'Extra');
71: hr_utility.set_location('Entering : '||l_proc,10);
72: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN
73: hr_utility.set_location('Leaving : '||l_proc,10);
74: return;
75: END IF;
68: BEGIN
69: l_proc := g_package||'update_asg_validate';
70: --hr_utility.trace_on(null,'Extra');
71: hr_utility.set_location('Entering : '||l_proc,10);
72: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN
73: hr_utility.set_location('Leaving : '||l_proc,10);
74: return;
75: END IF;
76: hr_utility.set_location('Contract_id=> ' || P_contract_id, 40);
69: l_proc := g_package||'update_asg_validate';
70: --hr_utility.trace_on(null,'Extra');
71: hr_utility.set_location('Entering : '||l_proc,10);
72: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN
73: hr_utility.set_location('Leaving : '||l_proc,10);
74: return;
75: END IF;
76: hr_utility.set_location('Contract_id=> ' || P_contract_id, 40);
77: -- VALIDATE THE DUPLICATE CONTRACT id
72: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN
73: hr_utility.set_location('Leaving : '||l_proc,10);
74: return;
75: END IF;
76: hr_utility.set_location('Contract_id=> ' || P_contract_id, 40);
77: -- VALIDATE THE DUPLICATE CONTRACT id
78: if p_contract_id is not null then
79: open csr_assignment_contract;
80: fetch csr_assignment_contract into l_exist;
78: if p_contract_id is not null then
79: open csr_assignment_contract;
80: fetch csr_assignment_contract into l_exist;
81: if csr_assignment_contract%found then
82: hr_utility.set_message('800','HR_520045_DUP_CONTRACT_ID');
83: hr_utility.raise_error;
84: end if;
85: close csr_assignment_contract;
86:
79: open csr_assignment_contract;
80: fetch csr_assignment_contract into l_exist;
81: if csr_assignment_contract%found then
82: hr_utility.set_message('800','HR_520045_DUP_CONTRACT_ID');
83: hr_utility.raise_error;
84: end if;
85: close csr_assignment_contract;
86:
87:
86:
87:
88: end IF;
89:
90: hr_utility.set_location('Leaving : '||l_proc,20);
91: --hr_utility.trace_off;
92: END update_asg_validate;
93:
94: END PER_RO_ASSIGNMENT_VAL;
87:
88: end IF;
89:
90: hr_utility.set_location('Leaving : '||l_proc,20);
91: --hr_utility.trace_off;
92: END update_asg_validate;
93:
94: END PER_RO_ASSIGNMENT_VAL;