DBA Data[Home] [Help]

APPS.PER_AST_INS dependencies on HR_UTILITY

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

22: --
23: l_proc varchar2(72) := g_package||'set_base_key_value';
24: --
25: Begin
26: hr_utility.set_location('Entering:'||l_proc, 10);
27: --
28: per_ast_ins.g_assessment_type_id_i := p_assessment_type_id;
29: --
30: hr_utility.set_location(' Leaving:'||l_proc, 20);

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

26: hr_utility.set_location('Entering:'||l_proc, 10);
27: --
28: per_ast_ins.g_assessment_type_id_i := p_assessment_type_id;
29: --
30: hr_utility.set_location(' Leaving:'||l_proc, 20);
31: End set_base_key_value;
32: --
33: --
34: -- ----------------------------------------------------------------------------

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

72: --
73: l_proc varchar2(72) := g_package||'insert_dml';
74: --
75: Begin
76: hr_utility.set_location('Entering:'||l_proc, 5);
77: p_rec.object_version_number := 1; -- Initialise the object version
78: --
79: --
80: -- Insert the row into: per_assessment_types

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

170: p_rec.available_flag
171: );
172: --
173: --
174: hr_utility.set_location(' Leaving:'||l_proc, 10);
175: Exception
176: When hr_api.check_integrity_violated Then
177: -- A check constraint has been violated
178: -- Bug#885806

Line 180: hr_utility.trace('A check constraint has been violated insert-dml');

176: When hr_api.check_integrity_violated Then
177: -- A check constraint has been violated
178: -- Bug#885806
179: -- dbms_output.put_line('A check constraint has been violated insert-dml');
180: hr_utility.trace('A check constraint has been violated insert-dml');
181: -- dbms_output.put_line('p_rec.rating_scale_id is :'|| p_rec.rating_scale_id);
182: hr_utility.trace('p_rec.rating_scale_id is :'|| p_rec.rating_scale_id);
183: per_ast_shd.constraint_error
184: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 182: hr_utility.trace('p_rec.rating_scale_id is :'|| p_rec.rating_scale_id);

178: -- Bug#885806
179: -- dbms_output.put_line('A check constraint has been violated insert-dml');
180: hr_utility.trace('A check constraint has been violated insert-dml');
181: -- dbms_output.put_line('p_rec.rating_scale_id is :'|| p_rec.rating_scale_id);
182: hr_utility.trace('p_rec.rating_scale_id is :'|| p_rec.rating_scale_id);
183: per_ast_shd.constraint_error
184: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
185: When hr_api.parent_integrity_violated Then
186: -- Bug#885806

Line 188: hr_utility.trace('Parent integrity has been violated insert-dml');

184: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
185: When hr_api.parent_integrity_violated Then
186: -- Bug#885806
187: -- dbms_output.put_line('Parent integrity has been violated insert-dml');
188: hr_utility.trace('Parent integrity has been violated insert-dml');
189: -- Parent integrity has been violated
190: per_ast_shd.constraint_error
191: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
192: When hr_api.unique_integrity_violated Then

Line 195: hr_utility.trace('Unique integrity has been violated insert-dml');

191: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
192: When hr_api.unique_integrity_violated Then
193: -- Bug#885806
194: -- dbms_output.put_line('Unique integrity has been violated insert-dml');
195: hr_utility.trace('Unique integrity has been violated insert-dml');
196: -- Unique integrity has been violated
197: per_ast_shd.constraint_error
198: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
199: When Others Then

Line 202: hr_utility.trace('Something else has been violated insert-dml');

198: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
199: When Others Then
200: -- Bug#885806
201: -- dbms_output.put_line('Something else has been violated insert-dml');
202: hr_utility.trace('Something else has been violated insert-dml');
203: Raise;
204: End insert_dml;
205: --
206: -- ----------------------------------------------------------------------------

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

252:
253: --
254: --
255: Begin
256: hr_utility.set_location('Entering:'||l_proc, 5);
257: --
258: -- Select the next sequence number
259: --
260: if ( per_ast_ins.g_assessment_type_id_i is not null ) then

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

283: Close C_Sel1;
284: end if;
285: --
286: --
287: hr_utility.set_location(' Leaving:'||l_proc, 10);
288: --
289: End pre_insert;
290: --
291: --

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

325: --
326: l_proc varchar2(72) := g_package||'post_insert';
327: --
328: Begin
329: hr_utility.set_location('Entering:'||l_proc, 5);
330: --
331: -- This is a hook point and the user hook for post_insert is called here.
332: --
333: begin

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

384: );
385: end;
386: -- End of API User Hook for post_insert.
387: --
388: hr_utility.set_location(' Leaving:'||l_proc, 10);
389: End post_insert;
390: --
391: -- ----------------------------------------------------------------------------
392: -- |---------------------------------< ins >----------------------------------|

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

399: --
400: l_proc varchar2(72) := g_package||'ins';
401: --
402: Begin
403: hr_utility.set_location('Entering:'||l_proc, 5);
404: --
405: -- Determine if the business process is to be validated.
406: --
407: If p_validate then

Line 416: hr_utility.set_location(' insert_validate called :'||l_proc, 11);

412: End If;
413: --
414: -- Call the supporting insert validate operations
415: --
416: hr_utility.set_location(' insert_validate called :'||l_proc, 11);
417: per_ast_bus.insert_validate(p_rec
418: ,p_effective_date);
419: --
420: hr_utility.set_location(' insert_validate finished :'||l_proc, 11);

Line 420: hr_utility.set_location(' insert_validate finished :'||l_proc, 11);

416: hr_utility.set_location(' insert_validate called :'||l_proc, 11);
417: per_ast_bus.insert_validate(p_rec
418: ,p_effective_date);
419: --
420: hr_utility.set_location(' insert_validate finished :'||l_proc, 11);
421: --
422: -- Call the supporting pre-insert operation
423: --
424: -- Bug#885806

Line 426: hr_utility.trace('about to do pre_insert');

422: -- Call the supporting pre-insert operation
423: --
424: -- Bug#885806
425: -- dbms_output.put_line('about to do pre_insert');
426: hr_utility.trace('about to do pre_insert');
427: pre_insert(p_rec);
428: --
429: -- Insert the row
430: --

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

439: If p_validate then
440: Raise HR_Api.Validate_Enabled;
441: End If;
442: --
443: hr_utility.set_location(' Leaving:'||l_proc, 10);
444: Exception
445: When HR_Api.Validate_Enabled Then
446: --
447: -- As the Validate_Enabled exception has been raised

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

505: l_rec per_ast_shd.g_rec_type;
506: l_proc varchar2(72) := g_package||'ins';
507: --
508: Begin
509: hr_utility.set_location('Entering:'||l_proc, 5);
510: --
511: -- Call conversion function to turn arguments into the
512: -- p_rec structure.
513: --

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

571: --
572: p_assessment_type_id := l_rec.assessment_type_id;
573: p_object_version_number := l_rec.object_version_number;
574: --
575: hr_utility.set_location(' Leaving:'||l_proc, 10);
576: End ins;
577: --
578: end per_ast_ins;