DBA Data[Home] [Help]

APPS.OTA_TCC_INS dependencies on HR_UTILITY

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

56: --
57: l_proc varchar2(72) := g_package||'insert_dml';
58: --
59: Begin
60: hr_utility.set_location('Entering:'||l_proc, 5);
61: p_rec.object_version_number := 1; -- Initialise the object version
62: --
63: --
64: --

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

86: );
87: --
88: --
89: --
90: hr_utility.set_location(' Leaving:'||l_proc, 10);
91: Exception
92: When hr_api.check_integrity_violated Then
93: -- A check constraint has been violated
94: --

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

154: --
155: Cursor C_Sel1 is select ota_cross_charges_s.nextval from sys.dual;
156: --
157: Begin
158: hr_utility.set_location('Entering:'||l_proc, 5);
159: --
160: --
161: -- Select the next sequence number
162: --

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

163: Open C_Sel1;
164: Fetch C_Sel1 Into p_rec.cross_charge_id;
165: Close C_Sel1;
166: --
167: hr_utility.set_location(' Leaving:'||l_proc, 10);
168: End pre_insert;
169: --
170: -- ----------------------------------------------------------------------------
171: -- |-----------------------------< post_insert >------------------------------|

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

206: --
207: l_proc varchar2(72) := g_package||'post_insert';
208: --
209: Begin
210: hr_utility.set_location('Entering:'||l_proc, 5);
211: begin
212: --
213: ota_tcc_rki.after_insert
214: (p_effective_date => p_effective_date

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

239: ,p_hook_type => 'AI');
240: --
241: end;
242: --
243: hr_utility.set_location(' Leaving:'||l_proc, 10);
244: End post_insert;
245: --
246: -- ----------------------------------------------------------------------------
247: -- |---------------------------------< ins >----------------------------------|

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

254: --
255: l_proc varchar2(72) := g_package||'ins';
256: --
257: Begin
258: hr_utility.set_location('Entering:'||l_proc, 5);
259: --
260: -- Call the supporting insert validate operations
261: --
262: If p_validate then

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

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

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

321: l_rec ota_tcc_shd.g_rec_type;
322: l_proc varchar2(72) := g_package||'ins';
323: --
324: Begin
325: hr_utility.set_location('Entering:'||l_proc, 5);
326: --
327: -- Call conversion function to turn arguments into the
328: -- p_rec structure.
329: --

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

353: --
354: p_cross_charge_id := l_rec.cross_charge_id;
355: p_object_version_number := l_rec.object_version_number;
356: --
357: hr_utility.set_location(' Leaving:'||l_proc, 10);
358: End ins;
359: --
360: end ota_tcc_ins;