DBA Data[Home] [Help]

APPS.OTA_TSR_INS dependencies on HR_UTILITY

Line 24: hr_utility.set_location('Entering:'||l_proc, 10);

20: --
21: l_proc varchar2(72) := g_package||'set_base_key_value';
22: --
23: Begin
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: ota_tsr_ins.g_supplied_resource_id_i := p_supplied_resource_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 28: hr_utility.set_location(' Leaving:'||l_proc, 20);

24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: ota_tsr_ins.g_supplied_resource_id_i := p_supplied_resource_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
29: End set_base_key_value;
30: --
31: -- ----------------------------------------------------------------------------
32: -- |------------------------------< insert_dml >------------------------------|

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

75: --
76: l_proc varchar2(72) := g_package||'insert_dml';
77: --
78: Begin
79: hr_utility.set_location('Entering:'||l_proc, 5);
80: p_rec.object_version_number := 1; -- Initialise the object version
81: --
82: ota_tsr_shd.g_api_dml := true; -- Set the api dml status
83: --

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

173: );
174: --
175: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
176: --
177: hr_utility.set_location(' Leaving:'||l_proc, 10);
178: Exception
179: When hr_api.check_integrity_violated Then
180: -- A check constraint has been violated
181: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status

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

248:
249: l_exists varchar2(1);
250: --
251: Begin
252: hr_utility.set_location('Entering:'||l_proc, 5);
253: If (ota_tsr_ins.g_supplied_resource_id_i is not null) Then
254: --
255: -- Verify registered primary key values not already in use
256: --

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

281: Fetch C_Sel1 Into p_rec.supplied_resource_id;
282: Close C_Sel1;
283: End If;
284: --
285: hr_utility.set_location(' Leaving:'||l_proc, 10);
286: End pre_insert;
287: --
288: -- ----------------------------------------------------------------------------
289: -- |-----------------------------< post_insert >------------------------------|

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

321: --
322: l_proc varchar2(72) := g_package||'post_insert';
323: --
324: Begin
325: hr_utility.set_location('Entering:'||l_proc, 5);
326: --
327: hr_utility.set_location(' Leaving:'||l_proc, 10);
328: End post_insert;
329: --

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

323: --
324: Begin
325: hr_utility.set_location('Entering:'||l_proc, 5);
326: --
327: hr_utility.set_location(' Leaving:'||l_proc, 10);
328: End post_insert;
329: --
330: -- ----------------------------------------------------------------------------
331: -- |---------------------------------< ins >----------------------------------|

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

338: --
339: l_proc varchar2(72) := g_package||'ins';
340: --
341: Begin
342: hr_utility.set_location('Entering:'||l_proc, 5);
343: --
344: -- Determine if the business process is to be validated.
345: --
346: If p_validate then

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

371: If p_validate then
372: Raise HR_Api.Validate_Enabled;
373: End If;
374: --
375: hr_utility.set_location(' Leaving:'||l_proc, 10);
376: Exception
377: When HR_Api.Validate_Enabled Then
378: --
379: -- As the Validate_Enabled exception has been raised

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

435: l_rec ota_tsr_shd.g_rec_type;
436: l_proc varchar2(72) := g_package||'ins';
437: --
438: Begin
439: hr_utility.set_location('Entering:'||l_proc, 5);
440: --
441: -- Call conversion function to turn arguments into the
442: -- p_rec structure.
443: --

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

498: --
499: p_supplied_resource_id := l_rec.supplied_resource_id;
500: p_object_version_number := l_rec.object_version_number;
501: --
502: hr_utility.set_location(' Leaving:'||l_proc, 10);
503: End ins;
504: --
505: end ota_tsr_ins;