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 = 'SSP_MAT_NOTE_OF_BIRTH_TOO_SOON') Then
37: fnd_message.set_name ('SSP', 'SSP_35012_EARLY_BIRTH_NOTIFIC');
38: --
73: End If;
74: --
75: fnd_message.raise_error;
76: --
77: hr_utility.set_location(' Leaving:'||l_proc, 10);
78: End constraint_error;
79: --
80: -- ----------------------------------------------------------------------------
81: -- |-----------------------------< api_updating >-----------------------------|
168: l_proc varchar2(72) := g_package||'api_updating';
169: l_fct_ret boolean;
170: --
171: Begin
172: hr_utility.set_location('Entering:'||l_proc, 5);
173: --
174: If (
175: p_maternity_id is null and
176: p_object_version_number is null
184: If (
185: p_maternity_id = g_old_rec.maternity_id and
186: p_object_version_number = g_old_rec.object_version_number
187: ) Then
188: hr_utility.set_location(l_proc, 10);
189: --
190: -- The g_old_rec is current therefore we must
191: -- set the returning function to true
192: --
209: If (p_object_version_number <> g_old_rec.object_version_number) Then
210: fnd_message.set_name ('PAY', 'HR_7155_OBJECT_INVALID');
211: fnd_message.raise_error;
212: End If;
213: hr_utility.set_location(l_proc, 15);
214: l_fct_ret := true;
215: End If;
216: End If;
217: hr_utility.set_location(' Leaving:'||l_proc, 20);
213: hr_utility.set_location(l_proc, 15);
214: l_fct_ret := true;
215: End If;
216: End If;
217: hr_utility.set_location(' Leaving:'||l_proc, 20);
218: Return (l_fct_ret);
219: --
220: End api_updating;
221: --
308: --
309: l_proc varchar2(72) := g_package||'lck';
310: --
311: Begin
312: hr_utility.set_location('Entering:'||l_proc, 5);
313: --
314: -- Add any mandatory argument checking here:
315: -- Example:
316: -- hr_api.mandatory_arg_error
333: fnd_message.set_name ('PAY', 'HR_7155_OBJECT_INVALID');
334: fnd_message.raise_error;
335: End If;
336: --
337: hr_utility.set_location(' Leaving:'||l_proc, 10);
338: --
339: -- We need to trap the ORA LOCK exception
340: --
341: Exception
432: l_proc varchar2(72) := g_package||'convert_args';
433: --
434: Begin
435: --
436: hr_utility.set_location('Entering:'||l_proc, 5);
437: --
438: -- Convert arguments into local l_rec structure.
439: --
440: l_rec.maternity_id := p_maternity_id;
510: l_rec.mat_information30 := p_mat_information30;
511: --
512: -- Return the plsql record structure.
513: --
514: hr_utility.set_location(' Leaving:'||l_proc, 10);
515: Return(l_rec);
516: --
517: End convert_args;
518: --