16: --
17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: hr_utility.set_location('Entering:'||l_proc, 5);
21: --
22: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
23: hr_utility.set_message_token('PROCEDURE', l_proc);
24: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
18: --
19: Begin
20: hr_utility.set_location('Entering:'||l_proc, 5);
21: --
22: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
23: hr_utility.set_message_token('PROCEDURE', l_proc);
24: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
25: hr_utility.raise_error;
26: --
19: Begin
20: hr_utility.set_location('Entering:'||l_proc, 5);
21: --
22: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
23: hr_utility.set_message_token('PROCEDURE', l_proc);
24: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
25: hr_utility.raise_error;
26: --
27: hr_utility.set_location(' Leaving:'||l_proc, 10);
20: hr_utility.set_location('Entering:'||l_proc, 5);
21: --
22: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
23: hr_utility.set_message_token('PROCEDURE', l_proc);
24: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
25: hr_utility.raise_error;
26: --
27: hr_utility.set_location(' Leaving:'||l_proc, 10);
28: End constraint_error;
21: --
22: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
23: hr_utility.set_message_token('PROCEDURE', l_proc);
24: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
25: hr_utility.raise_error;
26: --
27: hr_utility.set_location(' Leaving:'||l_proc, 10);
28: End constraint_error;
29: --
23: hr_utility.set_message_token('PROCEDURE', l_proc);
24: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
25: hr_utility.raise_error;
26: --
27: hr_utility.set_location(' Leaving:'||l_proc, 10);
28: End constraint_error;
29: --
30: -- ----------------------------------------------------------------------------
31: -- |-----------------------------< api_updating >-----------------------------|
52: l_proc varchar2(72) := g_package||'api_updating';
53: l_fct_ret boolean;
54: --
55: Begin
56: hr_utility.set_location('Entering:'||l_proc, 5);
57: --
58: If (
59: p_template_id is null or
60: p_language is null
68: If (
69: p_template_id = g_old_rec.template_id and
70: p_language = g_old_rec.language
71: ) Then
72: hr_utility.set_location(l_proc, 10);
73: --
74: -- The g_old_rec is current therefore we must
75: -- set the returning function to true
76: --
85: Close C_Sel1;
86: --
87: -- The primary key is invalid therefore we must error
88: --
89: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
90: hr_utility.raise_error;
91: End If;
92: Close C_Sel1;
93: --
86: --
87: -- The primary key is invalid therefore we must error
88: --
89: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
90: hr_utility.raise_error;
91: End If;
92: Close C_Sel1;
93: --
94: hr_utility.set_location(l_proc, 15);
90: hr_utility.raise_error;
91: End If;
92: Close C_Sel1;
93: --
94: hr_utility.set_location(l_proc, 15);
95: l_fct_ret := true;
96: End If;
97: End If;
98: hr_utility.set_location(' Leaving:'||l_proc, 20);
94: hr_utility.set_location(l_proc, 15);
95: l_fct_ret := true;
96: End If;
97: End If;
98: hr_utility.set_location(' Leaving:'||l_proc, 20);
99: Return (l_fct_ret);
100: --
101: End api_updating;
102: --
123: --
124: l_proc varchar2(72) := g_package||'lck';
125: --
126: Begin
127: hr_utility.set_location('Entering:'||l_proc, 5);
128: --
129: -- Add any mandatory argument checking here:
130: -- Example:
131: -- hr_api.mandatory_arg_error
139: Close C_Sel1;
140: --
141: -- The primary key is invalid therefore we must error
142: --
143: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
144: hr_utility.raise_error;
145: End If;
146: Close C_Sel1;
147: --
140: --
141: -- The primary key is invalid therefore we must error
142: --
143: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
144: hr_utility.raise_error;
145: End If;
146: Close C_Sel1;
147: --
148: --
145: End If;
146: Close C_Sel1;
147: --
148: --
149: hr_utility.set_location(' Leaving:'||l_proc, 10);
150: --
151: -- We need to trap the ORA LOCK exception
152: --
153: Exception
155: --
156: -- The object is locked therefore we need to supply a meaningful
157: -- error message.
158: --
159: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
160: hr_utility.set_message_token('TABLE_NAME', 'pqh_templates_tl');
161: hr_utility.raise_error;
162: End lck;
163: --
156: -- The object is locked therefore we need to supply a meaningful
157: -- error message.
158: --
159: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
160: hr_utility.set_message_token('TABLE_NAME', 'pqh_templates_tl');
161: hr_utility.raise_error;
162: End lck;
163: --
164: --
157: -- error message.
158: --
159: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
160: hr_utility.set_message_token('TABLE_NAME', 'pqh_templates_tl');
161: hr_utility.raise_error;
162: End lck;
163: --
164: --
165: -- --------------------------------------ADD LANGUAGE ------------------------
240: l_proc varchar2(72) := g_package||'convert_args';
241: --
242: Begin
243: --
244: hr_utility.set_location('Entering:'||l_proc, 5);
245: --
246: -- Convert arguments into local l_rec structure.
247: --
248: l_rec.template_id := p_template_id;
251: l_rec.source_lang := p_source_lang;
252: --
253: -- Return the plsql record structure.
254: --
255: hr_utility.set_location(' Leaving:'||l_proc, 10);
256: Return(l_rec);
257: --
258: End convert_args;
259: --