DBA Data[Home] [Help]

APPS.OTA_PLE_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_ple_shd.g_api_dml := true; -- Set the api dml status
62: --

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

134: );
135: --
136: ota_ple_shd.g_api_dml := false; -- Unset the api dml status
137: --
138: hr_utility.set_location(' Leaving:'||l_proc, 10);
139: Exception
140: When hr_api.check_integrity_violated Then
141: -- A check constraint has been violated
142: ota_ple_shd.g_api_dml := false; -- Unset the api dml status

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

200: --
201: Cursor C_Sel1 is select ota_price_list_entries_s.nextval from sys.dual;
202: --
203: Begin
204: hr_utility.set_location('Entering:'||l_proc, 5);
205: --
206: --
207: -- Select the next sequence number
208: --

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

209: Open C_Sel1;
210: Fetch C_Sel1 Into p_rec.price_list_entry_id;
211: Close C_Sel1;
212: --
213: hr_utility.set_location(' Leaving:'||l_proc, 10);
214: End pre_insert;
215: --
216: -- ----------------------------------------------------------------------------
217: -- |-----------------------------< post_insert >------------------------------|

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

249: --
250: l_proc varchar2(72) := g_package||'post_insert';
251: --
252: Begin
253: hr_utility.set_location('Entering:'||l_proc, 5);
254: --
255: hr_utility.set_location(' Leaving:'||l_proc, 10);
256: End post_insert;
257: --

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

251: --
252: Begin
253: hr_utility.set_location('Entering:'||l_proc, 5);
254: --
255: hr_utility.set_location(' Leaving:'||l_proc, 10);
256: End post_insert;
257: --
258: -- ----------------------------------------------------------------------------
259: -- |---------------------------------< ins >----------------------------------|

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

266: --
267: l_proc varchar2(72) := g_package||'ins';
268: --
269: Begin
270: hr_utility.set_location('Entering:'||l_proc, 5);
271: --
272: -- Determine if the business process is to be validated.
273: --
274: If p_validate then

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

299: If p_validate then
300: Raise HR_Api.Validate_Enabled;
301: End If;
302: --
303: hr_utility.set_location(' Leaving:'||l_proc, 10);
304: Exception
305: When HR_Api.Validate_Enabled Then
306: --
307: -- As the Validate_Enabled exception has been raised

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

354: l_rec ota_ple_shd.g_rec_type;
355: l_proc varchar2(72) := g_package||'ins';
356: --
357: Begin
358: hr_utility.set_location('Entering:'||l_proc, 5);
359: --
360: -- Call conversion function to turn arguments into the
361: -- p_rec structure.
362: --

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

408: --
409: p_price_list_entry_id := l_rec.price_list_entry_id;
410: p_object_version_number := l_rec.object_version_number;
411: --
412: hr_utility.set_location(' Leaving:'||l_proc, 10);
413: End ins;
414: --
415: end ota_ple_ins;