DBA Data[Home] [Help]

APPS.HXC_TER_INS dependencies on HR_UTILITY

Line 10: g_debug boolean := hr_utility.debug_enabled;

6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' hxc_ter_ins.'; -- Global package name
9:
10: g_debug boolean := hr_utility.debug_enabled;
11: --
12: -- ----------------------------------------------------------------------------
13: -- |------------------------------< insert_dml >------------------------------|
14: -- ----------------------------------------------------------------------------

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

62:
63:
64: if g_debug then
65: l_proc := g_package||'insert_dml';
66: hr_utility.set_location('Entering:'||l_proc, 5);
67: end if;
68: p_rec.object_version_number := 1; -- Initialise the object version
69: --
70: hxc_ter_shd.g_api_dml := true; -- Set the api dml status

Line 174: hr_utility.trace('error is '||SUBSTR(SQLERRM,1,60));

170: ,fnd_global.login_id
171: );
172: --
173: if g_debug then
174: hr_utility.trace('error is '||SUBSTR(SQLERRM,1,60));
175: end if;
176: hxc_ter_shd.g_api_dml := false; -- Unset the api dml status
177: --
178: if g_debug then

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

175: end if;
176: hxc_ter_shd.g_api_dml := false; -- Unset the api dml status
177: --
178: if g_debug then
179: hr_utility.set_location(' Leaving:'||l_proc, 10);
180: end if;
181: Exception
182: When hr_api.check_integrity_violated Then
183: if g_debug then

Line 184: hr_utility.trace('error is '||SUBSTR(SQLERRM,1,60));

180: end if;
181: Exception
182: When hr_api.check_integrity_violated Then
183: if g_debug then
184: hr_utility.trace('error is '||SUBSTR(SQLERRM,1,60));
185: end if;
186: -- A check constraint has been violated
187: hxc_ter_shd.g_api_dml := false; -- Unset the api dml status
188: hxc_ter_shd.constraint_error

Line 193: hr_utility.trace('error is '||SUBSTR(SQLERRM,1,60));

189: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
190: When hr_api.parent_integrity_violated Then
191: -- Parent integrity has been violated
192: if g_debug then
193: hr_utility.trace('error is '||SUBSTR(SQLERRM,1,60));
194: end if;
195: hxc_ter_shd.g_api_dml := false; -- Unset the api dml status
196: hxc_ter_shd.constraint_error
197: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 201: hr_utility.trace('error is '||SUBSTR(SQLERRM,1,60));

197: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
198: When hr_api.unique_integrity_violated Then
199: -- Unique integrity has been violated
200: if g_debug then
201: hr_utility.trace('error is '||SUBSTR(SQLERRM,1,60));
202: end if;
203: hxc_ter_shd.g_api_dml := false; -- Unset the api dml status
204: hxc_ter_shd.constraint_error
205: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 208: hr_utility.trace('error is '||SUBSTR(SQLERRM,1,60));

204: hxc_ter_shd.constraint_error
205: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
206: When Others Then
207: if g_debug then
208: hr_utility.trace('error is '||SUBSTR(SQLERRM,1,60));
209: end if;
210: hxc_ter_shd.g_api_dml := false; -- Unset the api dml status
211: Raise;
212: End insert_dml;

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

260:
261:
262: if g_debug then
263: l_proc := g_package||'pre_insert';
264: hr_utility.set_location('Entering:'||l_proc, 5);
265: end if;
266: --
267: --
268: -- Select the next sequence number

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

271: Fetch C_Sel1 Into p_rec.time_entry_rule_id;
272: Close C_Sel1;
273: --
274: if g_debug then
275: hr_utility.set_location(' Leaving:'||l_proc, 10);
276: end if;
277: End pre_insert;
278: --
279: -- ----------------------------------------------------------------------------

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

319:
320:
321: if g_debug then
322: l_proc := g_package||'post_insert';
323: hr_utility.set_location('Entering:'||l_proc, 5);
324: end if;
325: begin
326: --
327: hxc_ter_rki.after_insert

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

411: --
412: end;
413: --
414: if g_debug then
415: hr_utility.set_location(' Leaving:'||l_proc, 10);
416: end if;
417: End post_insert;
418: --
419: -- ----------------------------------------------------------------------------

Line 430: g_debug := hr_utility.debug_enabled;

426: --
427: l_proc varchar2(72);
428: --
429: Begin
430: g_debug := hr_utility.debug_enabled;
431:
432: if g_debug then
433: l_proc := g_package||'ins';
434: hr_utility.set_location('Entering:'||l_proc, 5);

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

430: g_debug := hr_utility.debug_enabled;
431:
432: if g_debug then
433: l_proc := g_package||'ins';
434: hr_utility.set_location('Entering:'||l_proc, 5);
435: end if;
436: --
437: -- Call the supporting insert validate operations
438: --

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

456: ,p_rec
457: );
458: --
459: if g_debug then
460: hr_utility.set_location('Leaving:'||l_proc, 20);
461: end if;
462: end ins;
463: --
464: -- ----------------------------------------------------------------------------

Line 517: g_debug := hr_utility.debug_enabled;

513: l_rec hxc_ter_shd.g_rec_type;
514: l_proc varchar2(72);
515: --
516: Begin
517: g_debug := hr_utility.debug_enabled;
518:
519: if g_debug then
520: l_proc := g_package||'ins';
521: hr_utility.set_location('Entering:'||l_proc, 5);

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

517: g_debug := hr_utility.debug_enabled;
518:
519: if g_debug then
520: l_proc := g_package||'ins';
521: hr_utility.set_location('Entering:'||l_proc, 5);
522: end if;
523: --
524: -- Call conversion function to turn arguments into the
525: -- p_rec structure.

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

584: p_time_entry_rule_id := l_rec.time_entry_rule_id;
585: p_object_version_number := l_rec.object_version_number;
586: --
587: if g_debug then
588: hr_utility.set_location(' Leaving:'||l_proc, 10);
589: end if;
590: End ins;
591: --
592: end hxc_ter_ins;