DBA Data[Home] [Help]

APPS.HXC_TCC_INS dependencies on HR_UTILITY

Line 10: g_debug boolean := hr_utility.debug_enabled;

6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' hxc_tcc_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_tcc_shd.g_api_dml := true; -- Set the api dml status

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

108: --
109: hxc_tcc_shd.g_api_dml := false; -- Unset the api dml status
110: --
111: if g_debug then
112: hr_utility.set_location(' Leaving:'||l_proc, 10);
113: end if;
114: Exception
115: When hr_api.check_integrity_violated Then
116: -- A check constraint has been violated

Line 118: hr_utility.trace(SUBSTR(SQLERRM,1,60));

114: Exception
115: When hr_api.check_integrity_violated Then
116: -- A check constraint has been violated
117: if g_debug then
118: hr_utility.trace(SUBSTR(SQLERRM,1,60));
119: end if;
120: hxc_tcc_shd.g_api_dml := false; -- Unset the api dml status
121: hxc_tcc_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 126: hr_utility.trace(SUBSTR(SQLERRM,1,60));

122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.parent_integrity_violated Then
124: -- Parent integrity has been violated
125: if g_debug then
126: hr_utility.trace(SUBSTR(SQLERRM,1,60));
127: end if;
128: hxc_tcc_shd.g_api_dml := false; -- Unset the api dml status
129: hxc_tcc_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 134: hr_utility.trace(SUBSTR(SQLERRM,1,60));

130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.unique_integrity_violated Then
132: -- Unique integrity has been violated
133: if g_debug then
134: hr_utility.trace(SUBSTR(SQLERRM,1,60));
135: end if;
136: hxc_tcc_shd.g_api_dml := false; -- Unset the api dml status
137: hxc_tcc_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 141: hr_utility.trace(SUBSTR(SQLERRM,1,60));

137: hxc_tcc_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When Others Then
140: if g_debug then
141: hr_utility.trace(SUBSTR(SQLERRM,1,60));
142: hr_utility.trace(SUBSTR(SQLERRM,61,120));
143: end if;
144: hxc_tcc_shd.g_api_dml := false; -- Unset the api dml status
145: Raise;

Line 142: hr_utility.trace(SUBSTR(SQLERRM,61,120));

138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When Others Then
140: if g_debug then
141: hr_utility.trace(SUBSTR(SQLERRM,1,60));
142: hr_utility.trace(SUBSTR(SQLERRM,61,120));
143: end if;
144: hxc_tcc_shd.g_api_dml := false; -- Unset the api dml status
145: Raise;
146: End insert_dml;

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

194:
195:
196: if g_debug then
197: l_proc := g_package||'pre_insert';
198: hr_utility.set_location('Entering:'||l_proc, 5);
199: end if;
200: --
201: --
202: -- Select the next sequence number

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

205: Fetch C_Sel1 Into p_rec.time_category_comp_id;
206: Close C_Sel1;
207: --
208: if g_debug then
209: hr_utility.set_location(' Leaving:'||l_proc, 10);
210: end if;
211: End pre_insert;
212: --
213: -- ----------------------------------------------------------------------------

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

252:
253:
254: if g_debug then
255: l_proc := g_package||'post_insert';
256: hr_utility.set_location('Entering:'||l_proc, 5);
257: end if;
258: begin
259: --
260: hxc_tcc_rki.after_insert (

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

279:
280: end;
281:
282: if g_debug then
283: hr_utility.set_location(' Leaving:'||l_proc, 10);
284: end if;
285: End post_insert;
286: --
287: -- ----------------------------------------------------------------------------

Line 297: g_debug := hr_utility.debug_enabled;

293: --
294: l_proc varchar2(72);
295: --
296: Begin
297: g_debug := hr_utility.debug_enabled;
298:
299: if g_debug then
300: l_proc := g_package||'ins';
301: hr_utility.set_location('Entering:'||l_proc, 5);

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

297: g_debug := hr_utility.debug_enabled;
298:
299: if g_debug then
300: l_proc := g_package||'ins';
301: hr_utility.set_location('Entering:'||l_proc, 5);
302: end if;
303: --
304: -- Call the supporting insert validate operations
305: --

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

332: END IF;
333:
334: --
335: if g_debug then
336: hr_utility.set_location('Leaving:'||l_proc, 20);
337: end if;
338: end ins;
339: --
340: -- ----------------------------------------------------------------------------

Line 362: g_debug := hr_utility.debug_enabled;

358: l_proc varchar2(72);
359: --
360: Begin
361:
362: g_debug := hr_utility.debug_enabled;
363:
364: if g_debug then
365: l_proc := g_package||'ins';
366: hr_utility.set_location('Entering:'||l_proc, 5);

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

362: g_debug := hr_utility.debug_enabled;
363:
364: if g_debug then
365: l_proc := g_package||'ins';
366: hr_utility.set_location('Entering:'||l_proc, 5);
367: end if;
368: --
369: -- Call conversion function to turn arguments into the
370: -- p_rec structure.

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

395: p_time_category_comp_id := l_rec.time_category_comp_id;
396: p_object_version_number := l_rec.object_version_number;
397: --
398: if g_debug then
399: hr_utility.set_location(' Leaving:'||l_proc, 10);
400: end if;
401: End ins;
402: --
403: end hxc_tcc_ins;