15: --
16: l_proc varchar2(72) := g_package||'constraint_error';
17: --
18: Begin
19: hr_utility.set_location('Entering:'||l_proc, 5);
20: --
21: If (p_constraint_name = 'PQH_TEMPLATES_FK') Then
22: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
23: hr_utility.set_message_token('PROCEDURE', l_proc);
18: Begin
19: hr_utility.set_location('Entering:'||l_proc, 5);
20: --
21: If (p_constraint_name = 'PQH_TEMPLATES_FK') Then
22: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
23: hr_utility.set_message_token('PROCEDURE', l_proc);
24: hr_utility.set_message_token('STEP','5');
25: hr_utility.raise_error;
26: ElsIf (p_constraint_name = 'PQH_TEMPLATES_PK') Then
19: hr_utility.set_location('Entering:'||l_proc, 5);
20: --
21: If (p_constraint_name = 'PQH_TEMPLATES_FK') Then
22: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
23: hr_utility.set_message_token('PROCEDURE', l_proc);
24: hr_utility.set_message_token('STEP','5');
25: hr_utility.raise_error;
26: ElsIf (p_constraint_name = 'PQH_TEMPLATES_PK') Then
27: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
20: --
21: If (p_constraint_name = 'PQH_TEMPLATES_FK') Then
22: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
23: hr_utility.set_message_token('PROCEDURE', l_proc);
24: hr_utility.set_message_token('STEP','5');
25: hr_utility.raise_error;
26: ElsIf (p_constraint_name = 'PQH_TEMPLATES_PK') Then
27: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
28: hr_utility.set_message_token('PROCEDURE', l_proc);
21: If (p_constraint_name = 'PQH_TEMPLATES_FK') Then
22: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
23: hr_utility.set_message_token('PROCEDURE', l_proc);
24: hr_utility.set_message_token('STEP','5');
25: hr_utility.raise_error;
26: ElsIf (p_constraint_name = 'PQH_TEMPLATES_PK') Then
27: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
28: hr_utility.set_message_token('PROCEDURE', l_proc);
29: hr_utility.set_message_token('STEP','10');
23: hr_utility.set_message_token('PROCEDURE', l_proc);
24: hr_utility.set_message_token('STEP','5');
25: hr_utility.raise_error;
26: ElsIf (p_constraint_name = 'PQH_TEMPLATES_PK') Then
27: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
28: hr_utility.set_message_token('PROCEDURE', l_proc);
29: hr_utility.set_message_token('STEP','10');
30: hr_utility.raise_error;
31: ElsIf (p_constraint_name = 'PQH_TEMPLATES_FK2') Then
24: hr_utility.set_message_token('STEP','5');
25: hr_utility.raise_error;
26: ElsIf (p_constraint_name = 'PQH_TEMPLATES_PK') Then
27: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
28: hr_utility.set_message_token('PROCEDURE', l_proc);
29: hr_utility.set_message_token('STEP','10');
30: hr_utility.raise_error;
31: ElsIf (p_constraint_name = 'PQH_TEMPLATES_FK2') Then
32: hr_utility.set_message(8302, 'PQH_TEM_LEG_CODE_NOT_EXIST');
25: hr_utility.raise_error;
26: ElsIf (p_constraint_name = 'PQH_TEMPLATES_PK') Then
27: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
28: hr_utility.set_message_token('PROCEDURE', l_proc);
29: hr_utility.set_message_token('STEP','10');
30: hr_utility.raise_error;
31: ElsIf (p_constraint_name = 'PQH_TEMPLATES_FK2') Then
32: hr_utility.set_message(8302, 'PQH_TEM_LEG_CODE_NOT_EXIST');
33: hr_utility.raise_error;
26: ElsIf (p_constraint_name = 'PQH_TEMPLATES_PK') Then
27: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
28: hr_utility.set_message_token('PROCEDURE', l_proc);
29: hr_utility.set_message_token('STEP','10');
30: hr_utility.raise_error;
31: ElsIf (p_constraint_name = 'PQH_TEMPLATES_FK2') Then
32: hr_utility.set_message(8302, 'PQH_TEM_LEG_CODE_NOT_EXIST');
33: hr_utility.raise_error;
34: ElsIf (p_constraint_name = 'PQH_TEMPLATES_UK') Then
28: hr_utility.set_message_token('PROCEDURE', l_proc);
29: hr_utility.set_message_token('STEP','10');
30: hr_utility.raise_error;
31: ElsIf (p_constraint_name = 'PQH_TEMPLATES_FK2') Then
32: hr_utility.set_message(8302, 'PQH_TEM_LEG_CODE_NOT_EXIST');
33: hr_utility.raise_error;
34: ElsIf (p_constraint_name = 'PQH_TEMPLATES_UK') Then
35: hr_utility.set_message(8302, 'PQH_DUPLICATE_TEM_SHORT_NAME');
36: hr_utility.raise_error;
29: hr_utility.set_message_token('STEP','10');
30: hr_utility.raise_error;
31: ElsIf (p_constraint_name = 'PQH_TEMPLATES_FK2') Then
32: hr_utility.set_message(8302, 'PQH_TEM_LEG_CODE_NOT_EXIST');
33: hr_utility.raise_error;
34: ElsIf (p_constraint_name = 'PQH_TEMPLATES_UK') Then
35: hr_utility.set_message(8302, 'PQH_DUPLICATE_TEM_SHORT_NAME');
36: hr_utility.raise_error;
37: ElsIf (p_constraint_name = 'PQH_TRANSACTION_TEMPLATE_FK2') Then
31: ElsIf (p_constraint_name = 'PQH_TEMPLATES_FK2') Then
32: hr_utility.set_message(8302, 'PQH_TEM_LEG_CODE_NOT_EXIST');
33: hr_utility.raise_error;
34: ElsIf (p_constraint_name = 'PQH_TEMPLATES_UK') Then
35: hr_utility.set_message(8302, 'PQH_DUPLICATE_TEM_SHORT_NAME');
36: hr_utility.raise_error;
37: ElsIf (p_constraint_name = 'PQH_TRANSACTION_TEMPLATE_FK2') Then
38: hr_utility.set_message(8302, 'PQH_TRANS_TEMPLATE_FK_EXIST');
39: hr_utility.raise_error;
32: hr_utility.set_message(8302, 'PQH_TEM_LEG_CODE_NOT_EXIST');
33: hr_utility.raise_error;
34: ElsIf (p_constraint_name = 'PQH_TEMPLATES_UK') Then
35: hr_utility.set_message(8302, 'PQH_DUPLICATE_TEM_SHORT_NAME');
36: hr_utility.raise_error;
37: ElsIf (p_constraint_name = 'PQH_TRANSACTION_TEMPLATE_FK2') Then
38: hr_utility.set_message(8302, 'PQH_TRANS_TEMPLATE_FK_EXIST');
39: hr_utility.raise_error;
40: ElsIf (p_constraint_name = 'PQH_ROLE_TEMPLATES_FK3') Then
34: ElsIf (p_constraint_name = 'PQH_TEMPLATES_UK') Then
35: hr_utility.set_message(8302, 'PQH_DUPLICATE_TEM_SHORT_NAME');
36: hr_utility.raise_error;
37: ElsIf (p_constraint_name = 'PQH_TRANSACTION_TEMPLATE_FK2') Then
38: hr_utility.set_message(8302, 'PQH_TRANS_TEMPLATE_FK_EXIST');
39: hr_utility.raise_error;
40: ElsIf (p_constraint_name = 'PQH_ROLE_TEMPLATES_FK3') Then
41: hr_utility.set_message(8302, 'PQH_ROLE_TEMPLATE_FK_EXIST');
42: hr_utility.raise_error;
35: hr_utility.set_message(8302, 'PQH_DUPLICATE_TEM_SHORT_NAME');
36: hr_utility.raise_error;
37: ElsIf (p_constraint_name = 'PQH_TRANSACTION_TEMPLATE_FK2') Then
38: hr_utility.set_message(8302, 'PQH_TRANS_TEMPLATE_FK_EXIST');
39: hr_utility.raise_error;
40: ElsIf (p_constraint_name = 'PQH_ROLE_TEMPLATES_FK3') Then
41: hr_utility.set_message(8302, 'PQH_ROLE_TEMPLATE_FK_EXIST');
42: hr_utility.raise_error;
43: Else
37: ElsIf (p_constraint_name = 'PQH_TRANSACTION_TEMPLATE_FK2') Then
38: hr_utility.set_message(8302, 'PQH_TRANS_TEMPLATE_FK_EXIST');
39: hr_utility.raise_error;
40: ElsIf (p_constraint_name = 'PQH_ROLE_TEMPLATES_FK3') Then
41: hr_utility.set_message(8302, 'PQH_ROLE_TEMPLATE_FK_EXIST');
42: hr_utility.raise_error;
43: Else
44: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
45: hr_utility.set_message_token('PROCEDURE', l_proc);
38: hr_utility.set_message(8302, 'PQH_TRANS_TEMPLATE_FK_EXIST');
39: hr_utility.raise_error;
40: ElsIf (p_constraint_name = 'PQH_ROLE_TEMPLATES_FK3') Then
41: hr_utility.set_message(8302, 'PQH_ROLE_TEMPLATE_FK_EXIST');
42: hr_utility.raise_error;
43: Else
44: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
45: hr_utility.set_message_token('PROCEDURE', l_proc);
46: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
40: ElsIf (p_constraint_name = 'PQH_ROLE_TEMPLATES_FK3') Then
41: hr_utility.set_message(8302, 'PQH_ROLE_TEMPLATE_FK_EXIST');
42: hr_utility.raise_error;
43: Else
44: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
45: hr_utility.set_message_token('PROCEDURE', l_proc);
46: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
47: hr_utility.raise_error;
48: End If;
41: hr_utility.set_message(8302, 'PQH_ROLE_TEMPLATE_FK_EXIST');
42: hr_utility.raise_error;
43: Else
44: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
45: hr_utility.set_message_token('PROCEDURE', l_proc);
46: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
47: hr_utility.raise_error;
48: End If;
49: --
42: hr_utility.raise_error;
43: Else
44: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
45: hr_utility.set_message_token('PROCEDURE', l_proc);
46: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
47: hr_utility.raise_error;
48: End If;
49: --
50: hr_utility.set_location(' Leaving:'||l_proc, 10);
43: Else
44: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
45: hr_utility.set_message_token('PROCEDURE', l_proc);
46: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
47: hr_utility.raise_error;
48: End If;
49: --
50: hr_utility.set_location(' Leaving:'||l_proc, 10);
51: End constraint_error;
46: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
47: hr_utility.raise_error;
48: End If;
49: --
50: hr_utility.set_location(' Leaving:'||l_proc, 10);
51: End constraint_error;
52: --
53: -- ----------------------------------------------------------------------------
54: -- |-----------------------------< api_updating >-----------------------------|
82: l_proc varchar2(72) := g_package||'api_updating';
83: l_fct_ret boolean;
84: --
85: Begin
86: hr_utility.set_location('Entering:'||l_proc, 5);
87: --
88: If (
89: p_template_id is null and
90: p_object_version_number is null
98: If (
99: p_template_id = g_old_rec.template_id and
100: p_object_version_number = g_old_rec.object_version_number
101: ) Then
102: hr_utility.set_location(l_proc, 10);
103: --
104: -- The g_old_rec is current therefore we must
105: -- set the returning function to true
106: --
115: Close C_Sel1;
116: --
117: -- The primary key is invalid therefore we must error
118: --
119: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
120: hr_utility.raise_error;
121: End If;
122: Close C_Sel1;
123: If (p_object_version_number <> g_old_rec.object_version_number) Then
116: --
117: -- The primary key is invalid therefore we must error
118: --
119: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
120: hr_utility.raise_error;
121: End If;
122: Close C_Sel1;
123: If (p_object_version_number <> g_old_rec.object_version_number) Then
124: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
120: hr_utility.raise_error;
121: End If;
122: Close C_Sel1;
123: If (p_object_version_number <> g_old_rec.object_version_number) Then
124: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
125: hr_utility.raise_error;
126: End If;
127: hr_utility.set_location(l_proc, 15);
128: l_fct_ret := true;
121: End If;
122: Close C_Sel1;
123: If (p_object_version_number <> g_old_rec.object_version_number) Then
124: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
125: hr_utility.raise_error;
126: End If;
127: hr_utility.set_location(l_proc, 15);
128: l_fct_ret := true;
129: End If;
123: If (p_object_version_number <> g_old_rec.object_version_number) Then
124: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
125: hr_utility.raise_error;
126: End If;
127: hr_utility.set_location(l_proc, 15);
128: l_fct_ret := true;
129: End If;
130: End If;
131: hr_utility.set_location(' Leaving:'||l_proc, 20);
127: hr_utility.set_location(l_proc, 15);
128: l_fct_ret := true;
129: End If;
130: End If;
131: hr_utility.set_location(' Leaving:'||l_proc, 20);
132: Return (l_fct_ret);
133: --
134: End api_updating;
135: --
163: --
164: l_proc varchar2(72) := g_package||'lck';
165: --
166: Begin
167: hr_utility.set_location('Entering:'||l_proc, 5);
168: --
169: -- Add any mandatory argument checking here:
170: -- Example:
171: -- hr_api.mandatory_arg_error
179: Close C_Sel1;
180: --
181: -- The primary key is invalid therefore we must error
182: --
183: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
184: hr_utility.raise_error;
185: End If;
186: Close C_Sel1;
187: If (p_object_version_number <> g_old_rec.object_version_number) Then
180: --
181: -- The primary key is invalid therefore we must error
182: --
183: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
184: hr_utility.raise_error;
185: End If;
186: Close C_Sel1;
187: If (p_object_version_number <> g_old_rec.object_version_number) Then
188: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
184: hr_utility.raise_error;
185: End If;
186: Close C_Sel1;
187: If (p_object_version_number <> g_old_rec.object_version_number) Then
188: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
189: hr_utility.raise_error;
190: End If;
191: --
192: hr_utility.set_location(' Leaving:'||l_proc, 10);
185: End If;
186: Close C_Sel1;
187: If (p_object_version_number <> g_old_rec.object_version_number) Then
188: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
189: hr_utility.raise_error;
190: End If;
191: --
192: hr_utility.set_location(' Leaving:'||l_proc, 10);
193: --
188: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
189: hr_utility.raise_error;
190: End If;
191: --
192: hr_utility.set_location(' Leaving:'||l_proc, 10);
193: --
194: -- We need to trap the ORA LOCK exception
195: --
196: Exception
198: --
199: -- The object is locked therefore we need to supply a meaningful
200: -- error message.
201: --
202: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
203: hr_utility.set_message_token('TABLE_NAME', 'pqh_templates');
204: hr_utility.raise_error;
205: End lck;
206: --
199: -- The object is locked therefore we need to supply a meaningful
200: -- error message.
201: --
202: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
203: hr_utility.set_message_token('TABLE_NAME', 'pqh_templates');
204: hr_utility.raise_error;
205: End lck;
206: --
207: -- ----------------------------------------------------------------------------
200: -- error message.
201: --
202: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
203: hr_utility.set_message_token('TABLE_NAME', 'pqh_templates');
204: hr_utility.raise_error;
205: End lck;
206: --
207: -- ----------------------------------------------------------------------------
208: -- |-----------------------------< convert_args >-----------------------------|
228: l_proc varchar2(72) := g_package||'convert_args';
229: --
230: Begin
231: --
232: hr_utility.set_location('Entering:'||l_proc, 5);
233: --
234: -- Convert arguments into local l_rec structure.
235: --
236: l_rec.template_name := p_template_name;
247: l_rec.legislation_code := p_legislation_code;
248: --
249: -- Return the plsql record structure.
250: --
251: hr_utility.set_location(' Leaving:'||l_proc, 10);
252: Return(l_rec);
253: --
254: End convert_args;
255: --