DBA Data[Home] [Help]

APPS.PER_PGN_INS dependencies on HR_UTILITY

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

57: l_proc varchar2(72) := g_package||'insert_dml';
58: l_identifier_key per_gen_hierarchy_nodes.identifier_key%TYPE := null;
59: --
60: Begin
61: hr_utility.set_location('Entering:'||l_proc, 5);
62: p_rec.object_version_number := 1; -- Initialise the object version
63:
64: -- Set the identifier key value if we are SEED, ORACLE user
65: IF fnd_global.user_id in (0,1,2) THEN

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

226: );
227: --
228: --
229: --
230: hr_utility.set_location(' Leaving:'||l_proc, 10);
231: Exception
232: When hr_api.check_integrity_violated Then
233: -- A check constraint has been violated
234: --

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

294: --
295: Cursor C_Sel1 is select per_gen_hierarchy_nodes_s.nextval from sys.dual;
296: --
297: Begin
298: hr_utility.set_location('Entering:'||l_proc, 5);
299: --
300: --
301: -- Select the next sequence number
302: --

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

303: Open C_Sel1;
304: Fetch C_Sel1 Into p_rec.hierarchy_node_id;
305: Close C_Sel1;
306: --
307: hr_utility.set_location(' Leaving:'||l_proc, 10);
308: End pre_insert;
309: --
310: -- ----------------------------------------------------------------------------
311: -- |-----------------------------< post_insert >------------------------------|

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

346: --
347: l_proc varchar2(72) := g_package||'post_insert';
348: --
349: Begin
350: hr_utility.set_location('Entering:'||l_proc, 5);
351: begin
352: --
353: per_pgn_rki.after_insert
354: (p_effective_date => p_effective_date

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

511: ,p_hook_type => 'AI');
512: --
513: end;
514: --
515: hr_utility.set_location(' Leaving:'||l_proc, 10);
516: End post_insert;
517: --
518: -- ----------------------------------------------------------------------------
519: -- |---------------------------------< ins >----------------------------------|

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

525: --
526: l_proc varchar2(72) := g_package||'ins';
527: --
528: Begin
529: hr_utility.set_location('Entering:'||l_proc, 5);
530: --
531: -- Call the supporting insert validate operations
532: --
533: per_pgn_bus.insert_validate

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

549: (p_effective_date
550: ,p_rec
551: );
552: --
553: hr_utility.set_location('Leaving:'||l_proc, 20);
554: end ins;
555: --
556: -- ----------------------------------------------------------------------------
557: -- |---------------------------------< ins >----------------------------------|

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

638: l_proc varchar2(72) := g_package||'ins';
639: --
640: Begin
641: -- hr_utilily.trace(null,'madmax');
642: hr_utility.set_location('Entering:'||l_proc, 5);
643: hr_utility.set_location(p_effective_date||l_proc, 5);
644: --
645: -- Call conversion function to turn arguments into the
646: -- p_rec structure.

Line 643: hr_utility.set_location(p_effective_date||l_proc, 5);

639: --
640: Begin
641: -- hr_utilily.trace(null,'madmax');
642: hr_utility.set_location('Entering:'||l_proc, 5);
643: hr_utility.set_location(p_effective_date||l_proc, 5);
644: --
645: -- Call conversion function to turn arguments into the
646: -- p_rec structure.
647: --

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

736: --
737: p_hierarchy_node_id := l_rec.hierarchy_node_id;
738: p_object_version_number := l_rec.object_version_number;
739: --
740: hr_utility.set_location(' Leaving:'||l_proc, 10);
741: End ins;
742: --
743: end per_pgn_ins;