DBA Data[Home] [Help]

APPS.PER_RO_ASSIGNMENT_VAL dependencies on HR_UTILITY

Line 23: --hr_utility.trace_on(null,'Extra1');

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;

Line 24: hr_utility.set_location('Entering : '||l_proc,10);

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;

Line 25: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN

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: --

Line 26: hr_utility.set_location('Leaving : '||l_proc,10);

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);

Line 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

Line 35: hr_utility.set_message('800','HR_520045_DUP_CONTRACT_ID');

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:

Line 36: hr_utility.raise_error;

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;

Line 42: hr_utility.set_location('Leaving : '||l_proc,20);

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: -------------------------------------------------------------------------------------------------------

Line 43: --hr_utility.trace_off;

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:

Line 70: --hr_utility.trace_on(null,'Extra');

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;

Line 71: hr_utility.set_location('Entering : '||l_proc,10);

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;

Line 72: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN

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);

Line 73: hr_utility.set_location('Leaving : '||l_proc,10);

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

Line 76: hr_utility.set_location('Contract_id=> ' || P_contract_id, 40);

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;

Line 82: hr_utility.set_message('800','HR_520045_DUP_CONTRACT_ID');

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:

Line 83: hr_utility.raise_error;

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:

Line 90: hr_utility.set_location('Leaving : '||l_proc,20);

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;

Line 91: --hr_utility.trace_off;

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;