14: --
15: l_proc varchar2(72) := g_package||'return_api_dml_status';
16: --
17: Begin
18: hr_utility.set_location('Entering:'||l_proc, 5);
19: --
20: Return (nvl(g_api_dml, false));
21: --
22: hr_utility.set_location(' Leaving:'||l_proc, 10);
18: hr_utility.set_location('Entering:'||l_proc, 5);
19: --
20: Return (nvl(g_api_dml, false));
21: --
22: hr_utility.set_location(' Leaving:'||l_proc, 10);
23: End return_api_dml_status;
24: --
25: -- ----------------------------------------------------------------------------
26: -- |---------------------------< constraint_error >---------------------------|
30: --
31: l_proc varchar2(72) := g_package||'constraint_error';
32: --
33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'PER_DEPLOYMENT_FACTORS_FK1') Then
37: hr_utility.set_message(801,'HR_52026_DPF_CHK_JOB_ID');
38: hr_utility.raise_error;
33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'PER_DEPLOYMENT_FACTORS_FK1') Then
37: hr_utility.set_message(801,'HR_52026_DPF_CHK_JOB_ID');
38: hr_utility.raise_error;
39: ElsIf (p_constraint_name = 'PER_DEPLOYMENT_FACTORS_FK2') Then
40: hr_utility.set_message(801,'HR_52024_DPF_CHK_POSITION_ID');
41: hr_utility.raise_error;
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'PER_DEPLOYMENT_FACTORS_FK1') Then
37: hr_utility.set_message(801,'HR_52026_DPF_CHK_JOB_ID');
38: hr_utility.raise_error;
39: ElsIf (p_constraint_name = 'PER_DEPLOYMENT_FACTORS_FK2') Then
40: hr_utility.set_message(801,'HR_52024_DPF_CHK_POSITION_ID');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'PER_DEPLOYMENT_FACTORS_FK3') Then
36: If (p_constraint_name = 'PER_DEPLOYMENT_FACTORS_FK1') Then
37: hr_utility.set_message(801,'HR_52026_DPF_CHK_JOB_ID');
38: hr_utility.raise_error;
39: ElsIf (p_constraint_name = 'PER_DEPLOYMENT_FACTORS_FK2') Then
40: hr_utility.set_message(801,'HR_52024_DPF_CHK_POSITION_ID');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'PER_DEPLOYMENT_FACTORS_FK3') Then
43: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
44: hr_utility.set_message_token('PROCEDURE', l_proc);
37: hr_utility.set_message(801,'HR_52026_DPF_CHK_JOB_ID');
38: hr_utility.raise_error;
39: ElsIf (p_constraint_name = 'PER_DEPLOYMENT_FACTORS_FK2') Then
40: hr_utility.set_message(801,'HR_52024_DPF_CHK_POSITION_ID');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'PER_DEPLOYMENT_FACTORS_FK3') Then
43: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
44: hr_utility.set_message_token('PROCEDURE', l_proc);
45: hr_utility.set_message_token('STEP','15');
39: ElsIf (p_constraint_name = 'PER_DEPLOYMENT_FACTORS_FK2') Then
40: hr_utility.set_message(801,'HR_52024_DPF_CHK_POSITION_ID');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'PER_DEPLOYMENT_FACTORS_FK3') Then
43: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
44: hr_utility.set_message_token('PROCEDURE', l_proc);
45: hr_utility.set_message_token('STEP','15');
46: hr_utility.raise_error;
47: ElsIf (p_constraint_name = 'PER_DEPLOYMENT_FACTORS_PK') Then
40: hr_utility.set_message(801,'HR_52024_DPF_CHK_POSITION_ID');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'PER_DEPLOYMENT_FACTORS_FK3') Then
43: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
44: hr_utility.set_message_token('PROCEDURE', l_proc);
45: hr_utility.set_message_token('STEP','15');
46: hr_utility.raise_error;
47: ElsIf (p_constraint_name = 'PER_DEPLOYMENT_FACTORS_PK') Then
48: hr_utility.set_message(801, 'HR_52041_DPF_DEP_FACTOR_PK');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'PER_DEPLOYMENT_FACTORS_FK3') Then
43: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
44: hr_utility.set_message_token('PROCEDURE', l_proc);
45: hr_utility.set_message_token('STEP','15');
46: hr_utility.raise_error;
47: ElsIf (p_constraint_name = 'PER_DEPLOYMENT_FACTORS_PK') Then
48: hr_utility.set_message(801, 'HR_52041_DPF_DEP_FACTOR_PK');
49: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'PER_DEPLOYMENT_FACTORS_FK3') Then
43: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
44: hr_utility.set_message_token('PROCEDURE', l_proc);
45: hr_utility.set_message_token('STEP','15');
46: hr_utility.raise_error;
47: ElsIf (p_constraint_name = 'PER_DEPLOYMENT_FACTORS_PK') Then
48: hr_utility.set_message(801, 'HR_52041_DPF_DEP_FACTOR_PK');
49: hr_utility.raise_error;
50: ElsIf (p_constraint_name = 'PER_DEPLOYMENT_FACTORS_UK') Then
44: hr_utility.set_message_token('PROCEDURE', l_proc);
45: hr_utility.set_message_token('STEP','15');
46: hr_utility.raise_error;
47: ElsIf (p_constraint_name = 'PER_DEPLOYMENT_FACTORS_PK') Then
48: hr_utility.set_message(801, 'HR_52041_DPF_DEP_FACTOR_PK');
49: hr_utility.raise_error;
50: ElsIf (p_constraint_name = 'PER_DEPLOYMENT_FACTORS_UK') Then
51: hr_utility.set_message(801, 'HR_52043_DPF_DEP_FACTOR_UK');
52: hr_utility.raise_error;
45: hr_utility.set_message_token('STEP','15');
46: hr_utility.raise_error;
47: ElsIf (p_constraint_name = 'PER_DEPLOYMENT_FACTORS_PK') Then
48: hr_utility.set_message(801, 'HR_52041_DPF_DEP_FACTOR_PK');
49: hr_utility.raise_error;
50: ElsIf (p_constraint_name = 'PER_DEPLOYMENT_FACTORS_UK') Then
51: hr_utility.set_message(801, 'HR_52043_DPF_DEP_FACTOR_UK');
52: hr_utility.raise_error;
53: ElsIf (p_constraint_name = 'PER_DPF_AVAILABLE_FOR_TRANSFER') Then
47: ElsIf (p_constraint_name = 'PER_DEPLOYMENT_FACTORS_PK') Then
48: hr_utility.set_message(801, 'HR_52041_DPF_DEP_FACTOR_PK');
49: hr_utility.raise_error;
50: ElsIf (p_constraint_name = 'PER_DEPLOYMENT_FACTORS_UK') Then
51: hr_utility.set_message(801, 'HR_52043_DPF_DEP_FACTOR_UK');
52: hr_utility.raise_error;
53: ElsIf (p_constraint_name = 'PER_DPF_AVAILABLE_FOR_TRANSFER') Then
54: hr_utility.set_message(801, 'HR_52044_DPF_DEP_AVAIL_TRANS');
55: hr_utility.raise_error;
48: hr_utility.set_message(801, 'HR_52041_DPF_DEP_FACTOR_PK');
49: hr_utility.raise_error;
50: ElsIf (p_constraint_name = 'PER_DEPLOYMENT_FACTORS_UK') Then
51: hr_utility.set_message(801, 'HR_52043_DPF_DEP_FACTOR_UK');
52: hr_utility.raise_error;
53: ElsIf (p_constraint_name = 'PER_DPF_AVAILABLE_FOR_TRANSFER') Then
54: hr_utility.set_message(801, 'HR_52044_DPF_DEP_AVAIL_TRANS');
55: hr_utility.raise_error;
56: ElsIf (p_constraint_name = 'PER_DPF_ONLY_CURRENT_LOCATION') Then
50: ElsIf (p_constraint_name = 'PER_DEPLOYMENT_FACTORS_UK') Then
51: hr_utility.set_message(801, 'HR_52043_DPF_DEP_FACTOR_UK');
52: hr_utility.raise_error;
53: ElsIf (p_constraint_name = 'PER_DPF_AVAILABLE_FOR_TRANSFER') Then
54: hr_utility.set_message(801, 'HR_52044_DPF_DEP_AVAIL_TRANS');
55: hr_utility.raise_error;
56: ElsIf (p_constraint_name = 'PER_DPF_ONLY_CURRENT_LOCATION') Then
57: hr_utility.set_message(801, 'HR_52045_DPF_ONLY_CUR_LOCATION');
58: hr_utility.raise_error;
51: hr_utility.set_message(801, 'HR_52043_DPF_DEP_FACTOR_UK');
52: hr_utility.raise_error;
53: ElsIf (p_constraint_name = 'PER_DPF_AVAILABLE_FOR_TRANSFER') Then
54: hr_utility.set_message(801, 'HR_52044_DPF_DEP_AVAIL_TRANS');
55: hr_utility.raise_error;
56: ElsIf (p_constraint_name = 'PER_DPF_ONLY_CURRENT_LOCATION') Then
57: hr_utility.set_message(801, 'HR_52045_DPF_ONLY_CUR_LOCATION');
58: hr_utility.raise_error;
59: ElsIf (p_constraint_name = 'PER_DPF_PASSPORT_REQUIRED') Then
53: ElsIf (p_constraint_name = 'PER_DPF_AVAILABLE_FOR_TRANSFER') Then
54: hr_utility.set_message(801, 'HR_52044_DPF_DEP_AVAIL_TRANS');
55: hr_utility.raise_error;
56: ElsIf (p_constraint_name = 'PER_DPF_ONLY_CURRENT_LOCATION') Then
57: hr_utility.set_message(801, 'HR_52045_DPF_ONLY_CUR_LOCATION');
58: hr_utility.raise_error;
59: ElsIf (p_constraint_name = 'PER_DPF_PASSPORT_REQUIRED') Then
60: hr_utility.set_message(801, 'HR_52046_DPF_PASSPORT_REQUIRED');
61: hr_utility.raise_error;
54: hr_utility.set_message(801, 'HR_52044_DPF_DEP_AVAIL_TRANS');
55: hr_utility.raise_error;
56: ElsIf (p_constraint_name = 'PER_DPF_ONLY_CURRENT_LOCATION') Then
57: hr_utility.set_message(801, 'HR_52045_DPF_ONLY_CUR_LOCATION');
58: hr_utility.raise_error;
59: ElsIf (p_constraint_name = 'PER_DPF_PASSPORT_REQUIRED') Then
60: hr_utility.set_message(801, 'HR_52046_DPF_PASSPORT_REQUIRED');
61: hr_utility.raise_error;
62: ElsIf (p_constraint_name = 'PER_DPF_RELOCATE_DOMESTICALLY') Then
56: ElsIf (p_constraint_name = 'PER_DPF_ONLY_CURRENT_LOCATION') Then
57: hr_utility.set_message(801, 'HR_52045_DPF_ONLY_CUR_LOCATION');
58: hr_utility.raise_error;
59: ElsIf (p_constraint_name = 'PER_DPF_PASSPORT_REQUIRED') Then
60: hr_utility.set_message(801, 'HR_52046_DPF_PASSPORT_REQUIRED');
61: hr_utility.raise_error;
62: ElsIf (p_constraint_name = 'PER_DPF_RELOCATE_DOMESTICALLY') Then
63: hr_utility.set_message(801, 'HR_52047_DPF_RELOCATE_DOMESTIC');
64: hr_utility.raise_error;
57: hr_utility.set_message(801, 'HR_52045_DPF_ONLY_CUR_LOCATION');
58: hr_utility.raise_error;
59: ElsIf (p_constraint_name = 'PER_DPF_PASSPORT_REQUIRED') Then
60: hr_utility.set_message(801, 'HR_52046_DPF_PASSPORT_REQUIRED');
61: hr_utility.raise_error;
62: ElsIf (p_constraint_name = 'PER_DPF_RELOCATE_DOMESTICALLY') Then
63: hr_utility.set_message(801, 'HR_52047_DPF_RELOCATE_DOMESTIC');
64: hr_utility.raise_error;
65: ElsIf (p_constraint_name = 'PER_DPF_RELOCATE_INTERNATIONAL') Then
59: ElsIf (p_constraint_name = 'PER_DPF_PASSPORT_REQUIRED') Then
60: hr_utility.set_message(801, 'HR_52046_DPF_PASSPORT_REQUIRED');
61: hr_utility.raise_error;
62: ElsIf (p_constraint_name = 'PER_DPF_RELOCATE_DOMESTICALLY') Then
63: hr_utility.set_message(801, 'HR_52047_DPF_RELOCATE_DOMESTIC');
64: hr_utility.raise_error;
65: ElsIf (p_constraint_name = 'PER_DPF_RELOCATE_INTERNATIONAL') Then
66: hr_utility.set_message(801, 'HR_52048_DPF_RELOCATE_INTERNAT');
67: hr_utility.raise_error;
60: hr_utility.set_message(801, 'HR_52046_DPF_PASSPORT_REQUIRED');
61: hr_utility.raise_error;
62: ElsIf (p_constraint_name = 'PER_DPF_RELOCATE_DOMESTICALLY') Then
63: hr_utility.set_message(801, 'HR_52047_DPF_RELOCATE_DOMESTIC');
64: hr_utility.raise_error;
65: ElsIf (p_constraint_name = 'PER_DPF_RELOCATE_INTERNATIONAL') Then
66: hr_utility.set_message(801, 'HR_52048_DPF_RELOCATE_INTERNAT');
67: hr_utility.raise_error;
68: ElsIf (p_constraint_name = 'PER_DPF_RELOCATION_REQUIRED') Then
62: ElsIf (p_constraint_name = 'PER_DPF_RELOCATE_DOMESTICALLY') Then
63: hr_utility.set_message(801, 'HR_52047_DPF_RELOCATE_DOMESTIC');
64: hr_utility.raise_error;
65: ElsIf (p_constraint_name = 'PER_DPF_RELOCATE_INTERNATIONAL') Then
66: hr_utility.set_message(801, 'HR_52048_DPF_RELOCATE_INTERNAT');
67: hr_utility.raise_error;
68: ElsIf (p_constraint_name = 'PER_DPF_RELOCATION_REQUIRED') Then
69: hr_utility.set_message(801, 'HR_52049_DPF_RELOCATION_REQUIR');
70: hr_utility.raise_error;
63: hr_utility.set_message(801, 'HR_52047_DPF_RELOCATE_DOMESTIC');
64: hr_utility.raise_error;
65: ElsIf (p_constraint_name = 'PER_DPF_RELOCATE_INTERNATIONAL') Then
66: hr_utility.set_message(801, 'HR_52048_DPF_RELOCATE_INTERNAT');
67: hr_utility.raise_error;
68: ElsIf (p_constraint_name = 'PER_DPF_RELOCATION_REQUIRED') Then
69: hr_utility.set_message(801, 'HR_52049_DPF_RELOCATION_REQUIR');
70: hr_utility.raise_error;
71: ElsIf (p_constraint_name = 'PER_DPF_TRAVEL_REQUIRED') Then
65: ElsIf (p_constraint_name = 'PER_DPF_RELOCATE_INTERNATIONAL') Then
66: hr_utility.set_message(801, 'HR_52048_DPF_RELOCATE_INTERNAT');
67: hr_utility.raise_error;
68: ElsIf (p_constraint_name = 'PER_DPF_RELOCATION_REQUIRED') Then
69: hr_utility.set_message(801, 'HR_52049_DPF_RELOCATION_REQUIR');
70: hr_utility.raise_error;
71: ElsIf (p_constraint_name = 'PER_DPF_TRAVEL_REQUIRED') Then
72: hr_utility.set_message(801, 'HR_52050_DPF_TRAVEL_REQUIRED');
73: hr_utility.raise_error;
66: hr_utility.set_message(801, 'HR_52048_DPF_RELOCATE_INTERNAT');
67: hr_utility.raise_error;
68: ElsIf (p_constraint_name = 'PER_DPF_RELOCATION_REQUIRED') Then
69: hr_utility.set_message(801, 'HR_52049_DPF_RELOCATION_REQUIR');
70: hr_utility.raise_error;
71: ElsIf (p_constraint_name = 'PER_DPF_TRAVEL_REQUIRED') Then
72: hr_utility.set_message(801, 'HR_52050_DPF_TRAVEL_REQUIRED');
73: hr_utility.raise_error;
74: ElsIf (p_constraint_name = 'PER_DPF_VISIT_INTERNATIONALLY') Then
68: ElsIf (p_constraint_name = 'PER_DPF_RELOCATION_REQUIRED') Then
69: hr_utility.set_message(801, 'HR_52049_DPF_RELOCATION_REQUIR');
70: hr_utility.raise_error;
71: ElsIf (p_constraint_name = 'PER_DPF_TRAVEL_REQUIRED') Then
72: hr_utility.set_message(801, 'HR_52050_DPF_TRAVEL_REQUIRED');
73: hr_utility.raise_error;
74: ElsIf (p_constraint_name = 'PER_DPF_VISIT_INTERNATIONALLY') Then
75: hr_utility.set_message(801, 'HR_52051_DPF_VISIT_INTER');
76: hr_utility.raise_error;
69: hr_utility.set_message(801, 'HR_52049_DPF_RELOCATION_REQUIR');
70: hr_utility.raise_error;
71: ElsIf (p_constraint_name = 'PER_DPF_TRAVEL_REQUIRED') Then
72: hr_utility.set_message(801, 'HR_52050_DPF_TRAVEL_REQUIRED');
73: hr_utility.raise_error;
74: ElsIf (p_constraint_name = 'PER_DPF_VISIT_INTERNATIONALLY') Then
75: hr_utility.set_message(801, 'HR_52051_DPF_VISIT_INTER');
76: hr_utility.raise_error;
77: ElsIf (p_constraint_name = 'PER_DPF_WORK_ANY_COUNTRY') Then
71: ElsIf (p_constraint_name = 'PER_DPF_TRAVEL_REQUIRED') Then
72: hr_utility.set_message(801, 'HR_52050_DPF_TRAVEL_REQUIRED');
73: hr_utility.raise_error;
74: ElsIf (p_constraint_name = 'PER_DPF_VISIT_INTERNATIONALLY') Then
75: hr_utility.set_message(801, 'HR_52051_DPF_VISIT_INTER');
76: hr_utility.raise_error;
77: ElsIf (p_constraint_name = 'PER_DPF_WORK_ANY_COUNTRY') Then
78: hr_utility.set_message(801, 'HR_52052_WORK_ANY_COUNTRY');
79: hr_utility.raise_error;
72: hr_utility.set_message(801, 'HR_52050_DPF_TRAVEL_REQUIRED');
73: hr_utility.raise_error;
74: ElsIf (p_constraint_name = 'PER_DPF_VISIT_INTERNATIONALLY') Then
75: hr_utility.set_message(801, 'HR_52051_DPF_VISIT_INTER');
76: hr_utility.raise_error;
77: ElsIf (p_constraint_name = 'PER_DPF_WORK_ANY_COUNTRY') Then
78: hr_utility.set_message(801, 'HR_52052_WORK_ANY_COUNTRY');
79: hr_utility.raise_error;
80: ElsIf (p_constraint_name = 'PER_DPF_WORK_ANY_LOCATION') Then
74: ElsIf (p_constraint_name = 'PER_DPF_VISIT_INTERNATIONALLY') Then
75: hr_utility.set_message(801, 'HR_52051_DPF_VISIT_INTER');
76: hr_utility.raise_error;
77: ElsIf (p_constraint_name = 'PER_DPF_WORK_ANY_COUNTRY') Then
78: hr_utility.set_message(801, 'HR_52052_WORK_ANY_COUNTRY');
79: hr_utility.raise_error;
80: ElsIf (p_constraint_name = 'PER_DPF_WORK_ANY_LOCATION') Then
81: hr_utility.set_message(801, 'HR_52053_DPF_WORK_ANY_LOCATION');
82: hr_utility.raise_error;
75: hr_utility.set_message(801, 'HR_52051_DPF_VISIT_INTER');
76: hr_utility.raise_error;
77: ElsIf (p_constraint_name = 'PER_DPF_WORK_ANY_COUNTRY') Then
78: hr_utility.set_message(801, 'HR_52052_WORK_ANY_COUNTRY');
79: hr_utility.raise_error;
80: ElsIf (p_constraint_name = 'PER_DPF_WORK_ANY_LOCATION') Then
81: hr_utility.set_message(801, 'HR_52053_DPF_WORK_ANY_LOCATION');
82: hr_utility.raise_error;
83: Else
77: ElsIf (p_constraint_name = 'PER_DPF_WORK_ANY_COUNTRY') Then
78: hr_utility.set_message(801, 'HR_52052_WORK_ANY_COUNTRY');
79: hr_utility.raise_error;
80: ElsIf (p_constraint_name = 'PER_DPF_WORK_ANY_LOCATION') Then
81: hr_utility.set_message(801, 'HR_52053_DPF_WORK_ANY_LOCATION');
82: hr_utility.raise_error;
83: Else
84: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
85: hr_utility.set_message_token('PROCEDURE', l_proc);
78: hr_utility.set_message(801, 'HR_52052_WORK_ANY_COUNTRY');
79: hr_utility.raise_error;
80: ElsIf (p_constraint_name = 'PER_DPF_WORK_ANY_LOCATION') Then
81: hr_utility.set_message(801, 'HR_52053_DPF_WORK_ANY_LOCATION');
82: hr_utility.raise_error;
83: Else
84: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
85: hr_utility.set_message_token('PROCEDURE', l_proc);
86: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
80: ElsIf (p_constraint_name = 'PER_DPF_WORK_ANY_LOCATION') Then
81: hr_utility.set_message(801, 'HR_52053_DPF_WORK_ANY_LOCATION');
82: hr_utility.raise_error;
83: Else
84: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
85: hr_utility.set_message_token('PROCEDURE', l_proc);
86: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
87: hr_utility.raise_error;
88: End If;
81: hr_utility.set_message(801, 'HR_52053_DPF_WORK_ANY_LOCATION');
82: hr_utility.raise_error;
83: Else
84: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
85: hr_utility.set_message_token('PROCEDURE', l_proc);
86: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
87: hr_utility.raise_error;
88: End If;
89: --
82: hr_utility.raise_error;
83: Else
84: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
85: hr_utility.set_message_token('PROCEDURE', l_proc);
86: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
87: hr_utility.raise_error;
88: End If;
89: --
90: hr_utility.set_location(' Leaving:'||l_proc, 10);
83: Else
84: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
85: hr_utility.set_message_token('PROCEDURE', l_proc);
86: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
87: hr_utility.raise_error;
88: End If;
89: --
90: hr_utility.set_location(' Leaving:'||l_proc, 10);
91: End constraint_error;
86: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
87: hr_utility.raise_error;
88: End If;
89: --
90: hr_utility.set_location(' Leaving:'||l_proc, 10);
91: End constraint_error;
92: --
93: -- ----------------------------------------------------------------------------
94: -- |-----------------------------< api_updating >-----------------------------|
165: l_proc varchar2(72) := g_package||'api_updating';
166: l_fct_ret boolean;
167: --
168: Begin
169: hr_utility.set_location('Entering:'||l_proc, 5);
170: --
171: If (
172: p_deployment_factor_id is null and
173: p_object_version_number is null
181: If (
182: p_deployment_factor_id = g_old_rec.deployment_factor_id and
183: p_object_version_number = g_old_rec.object_version_number
184: ) Then
185: hr_utility.set_location(l_proc, 10);
186: --
187: -- The g_old_rec is current therefore we must
188: -- set the returning function to true
189: --
198: Close C_Sel1;
199: --
200: -- The primary key is invalid therefore we must error
201: --
202: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
203: hr_utility.raise_error;
204: End If;
205: Close C_Sel1;
206: If (p_object_version_number <> g_old_rec.object_version_number) Then
199: --
200: -- The primary key is invalid therefore we must error
201: --
202: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
203: hr_utility.raise_error;
204: End If;
205: Close C_Sel1;
206: If (p_object_version_number <> g_old_rec.object_version_number) Then
207: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
203: hr_utility.raise_error;
204: End If;
205: Close C_Sel1;
206: If (p_object_version_number <> g_old_rec.object_version_number) Then
207: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
208: hr_utility.raise_error;
209: End If;
210: hr_utility.set_location(l_proc, 15);
211: l_fct_ret := true;
204: End If;
205: Close C_Sel1;
206: If (p_object_version_number <> g_old_rec.object_version_number) Then
207: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
208: hr_utility.raise_error;
209: End If;
210: hr_utility.set_location(l_proc, 15);
211: l_fct_ret := true;
212: End If;
206: If (p_object_version_number <> g_old_rec.object_version_number) Then
207: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
208: hr_utility.raise_error;
209: End If;
210: hr_utility.set_location(l_proc, 15);
211: l_fct_ret := true;
212: End If;
213: End If;
214: hr_utility.set_location(' Leaving:'||l_proc, 20);
210: hr_utility.set_location(l_proc, 15);
211: l_fct_ret := true;
212: End If;
213: End If;
214: hr_utility.set_location(' Leaving:'||l_proc, 20);
215: Return (l_fct_ret);
216: --
217: End api_updating;
218: --
289: --
290: l_proc varchar2(72) := g_package||'lck';
291: --
292: Begin
293: hr_utility.set_location('Entering:'||l_proc, 5);
294: --
295: -- Add any mandatory argument checking here:
296: -- Example:
297: -- hr_api.mandatory_arg_error
305: Close C_Sel1;
306: --
307: -- The primary key is invalid therefore we must error
308: --
309: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
310: hr_utility.raise_error;
311: End If;
312: Close C_Sel1;
313: If (p_object_version_number <> g_old_rec.object_version_number) Then
306: --
307: -- The primary key is invalid therefore we must error
308: --
309: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
310: hr_utility.raise_error;
311: End If;
312: Close C_Sel1;
313: If (p_object_version_number <> g_old_rec.object_version_number) Then
314: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
310: hr_utility.raise_error;
311: End If;
312: Close C_Sel1;
313: If (p_object_version_number <> g_old_rec.object_version_number) Then
314: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
315: hr_utility.raise_error;
316: End If;
317: --
318: hr_utility.set_location(' Leaving:'||l_proc, 10);
311: End If;
312: Close C_Sel1;
313: If (p_object_version_number <> g_old_rec.object_version_number) Then
314: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
315: hr_utility.raise_error;
316: End If;
317: --
318: hr_utility.set_location(' Leaving:'||l_proc, 10);
319: --
314: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
315: hr_utility.raise_error;
316: End If;
317: --
318: hr_utility.set_location(' Leaving:'||l_proc, 10);
319: --
320: -- We need to trap the ORA LOCK exception
321: --
322: Exception
324: --
325: -- The object is locked therefore we need to supply a meaningful
326: -- error message.
327: --
328: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
329: hr_utility.set_message_token('TABLE_NAME', 'per_deployment_factors');
330: hr_utility.raise_error;
331: End lck;
332: --
325: -- The object is locked therefore we need to supply a meaningful
326: -- error message.
327: --
328: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
329: hr_utility.set_message_token('TABLE_NAME', 'per_deployment_factors');
330: hr_utility.raise_error;
331: End lck;
332: --
333: -- ----------------------------------------------------------------------------
326: -- error message.
327: --
328: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
329: hr_utility.set_message_token('TABLE_NAME', 'per_deployment_factors');
330: hr_utility.raise_error;
331: End lck;
332: --
333: -- ----------------------------------------------------------------------------
334: -- |-----------------------------< convert_args >-----------------------------|
397: l_proc varchar2(72) := g_package||'convert_args';
398: --
399: Begin
400: --
401: hr_utility.set_location('Entering:'||l_proc, 5);
402: --
403: -- Convert arguments into local l_rec structure.
404: --
405: l_rec.deployment_factor_id := p_deployment_factor_id;
459: l_rec.attribute20 := p_attribute20;
460: --
461: -- Return the plsql record structure.
462: --
463: hr_utility.set_location(' Leaving:'||l_proc, 10);
464: Return(l_rec);
465: --
466: End convert_args;
467: --