DBA Data[Home] [Help]

APPS.OTA_PMM_INS dependencies on HR_UTILITY

Line 58: hr_utility.set_location('Entering:'||l_proc, 5);

54: --
55: l_proc varchar2(72) := g_package||'insert_dml';
56: --
57: Begin
58: hr_utility.set_location('Entering:'||l_proc, 5);
59: p_rec.object_version_number := 1; -- Initialise the object version
60: --
61: ota_pmm_shd.g_api_dml := true; -- Set the api dml status
62: --

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

128: );
129: --
130: ota_pmm_shd.g_api_dml := false; -- Unset the api dml status
131: --
132: hr_utility.set_location(' Leaving:'||l_proc, 10);
133: Exception
134: When hr_api.check_integrity_violated Then
135: -- A check constraint has been violated
136: ota_pmm_shd.g_api_dml := false; -- Unset the api dml status

Line 198: hr_utility.set_location('Entering:'||l_proc, 5);

194: --
195: Cursor C_Sel1 is select ota_program_memberships_s.nextval from sys.dual;
196: --
197: Begin
198: hr_utility.set_location('Entering:'||l_proc, 5);
199: --
200: --
201: -- Select the next sequence number
202: --

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

203: Open C_Sel1;
204: Fetch C_Sel1 Into p_rec.program_membership_id;
205: Close C_Sel1;
206: --
207: hr_utility.set_location(' Leaving:'||l_proc, 10);
208: End pre_insert;
209: --
210: -- ----------------------------------------------------------------------------
211: -- |-----------------------------< post_insert >------------------------------|

Line 247: hr_utility.set_location('Entering:'||l_proc, 5);

243: --
244: l_proc varchar2(72) := g_package||'post_insert';
245: --
246: Begin
247: hr_utility.set_location('Entering:'||l_proc, 5);
248: --
249: hr_utility.set_location(' Leaving:'||l_proc, 10);
250: End post_insert;
251: --

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

245: --
246: Begin
247: hr_utility.set_location('Entering:'||l_proc, 5);
248: --
249: hr_utility.set_location(' Leaving:'||l_proc, 10);
250: End post_insert;
251: --
252: -- ----------------------------------------------------------------------------
253: -- |---------------------------------< ins >----------------------------------|

Line 264: hr_utility.set_location('Entering:'||l_proc, 5);

260: --
261: l_proc varchar2(72) := g_package||'ins';
262: --
263: Begin
264: hr_utility.set_location('Entering:'||l_proc, 5);
265: --
266: -- Determine if the business process is to be validated.
267: --
268: If p_validate then

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

293: If p_validate then
294: Raise HR_Api.Validate_Enabled;
295: End If;
296: --
297: hr_utility.set_location(' Leaving:'||l_proc, 10);
298: Exception
299: When HR_Api.Validate_Enabled Then
300: --
301: -- As the Validate_Enabled exception has been raised

Line 349: hr_utility.set_location('Entering:'||l_proc, 5);

345: l_rec ota_pmm_shd.g_rec_type;
346: l_proc varchar2(72) := g_package||'ins';
347: --
348: Begin
349: hr_utility.set_location('Entering:'||l_proc, 5);
350: --
351: -- Call conversion function to turn arguments into the
352: -- p_rec structure.
353: --

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

396: --
397: p_program_membership_id := l_rec.program_membership_id;
398: p_object_version_number := l_rec.object_version_number;
399: --
400: hr_utility.set_location(' Leaving:'||l_proc, 10);
401: End ins;
402: --
403: end ota_pmm_ins;