DBA Data[Home] [Help]

APPS.PER_CTC_INS dependencies on HR_UTILITY

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

80: l_last_updated_by per_contracts_f.last_updated_by%TYPE;
81: l_last_update_login per_contracts_f.last_update_login%TYPE;
82: --
83: Begin
84: hr_utility.set_location('Entering:'||l_proc, 5);
85: --
86: -- Get the object version number for the insert
87: --
88: p_rec.object_version_number :=

Line 104: hr_utility.set_location(l_proc, 10);

100: -- If the datetrack_mode is not INSERT then we must populate the WHO
101: -- columns with the 'old' creation values and 'new' updated values.
102: --
103: If (p_datetrack_mode <> 'INSERT') then
104: hr_utility.set_location(l_proc, 10);
105: --
106: -- Select the 'old' created values
107: --
108: Open C_Sel1;

Line 116: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

112: -- The previous 'old' created row has not been found. We need
113: -- to error as an internal datetrack problem exists.
114: --
115: Close C_Sel1;
116: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
117: hr_utility.set_message_token('PROCEDURE', l_proc);
118: hr_utility.set_message_token('STEP','10');
119: hr_utility.raise_error;
120: End If;

Line 117: hr_utility.set_message_token('PROCEDURE', l_proc);

113: -- to error as an internal datetrack problem exists.
114: --
115: Close C_Sel1;
116: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
117: hr_utility.set_message_token('PROCEDURE', l_proc);
118: hr_utility.set_message_token('STEP','10');
119: hr_utility.raise_error;
120: End If;
121: Close C_Sel1;

Line 118: hr_utility.set_message_token('STEP','10');

114: --
115: Close C_Sel1;
116: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
117: hr_utility.set_message_token('PROCEDURE', l_proc);
118: hr_utility.set_message_token('STEP','10');
119: hr_utility.raise_error;
120: End If;
121: Close C_Sel1;
122: --

Line 119: hr_utility.raise_error;

115: Close C_Sel1;
116: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
117: hr_utility.set_message_token('PROCEDURE', l_proc);
118: hr_utility.set_message_token('STEP','10');
119: hr_utility.raise_error;
120: End If;
121: Close C_Sel1;
122: --
123: -- Set the AOL updated WHO values

Line 278: hr_utility.set_location(' Leaving:'||l_proc, 15);

274: l_last_updated_by,
275: l_last_update_login
276: );
277: --
278: hr_utility.set_location(' Leaving:'||l_proc, 15);
279: --
280: Exception
281: When hr_api.check_integrity_violated Then
282: -- A check constraint has been violated

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

303:
304: l_proc varchar2(72) := g_package||'insert_dml';
305: --
306: Begin
307: hr_utility.set_location('Entering:'||l_proc, 5);
308: --
309: dt_insert_dml(p_rec => p_rec,
310: p_effective_date => p_effective_date,
311: p_datetrack_mode => p_datetrack_mode,

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

311: p_datetrack_mode => p_datetrack_mode,
312: p_validation_start_date => p_validation_start_date,
313: p_validation_end_date => p_validation_end_date);
314: --
315: hr_utility.set_location(' Leaving:'||l_proc, 10);
316: End insert_dml;
317: --
318: -- ----------------------------------------------------------------------------
319: -- |------------------------------< pre_insert >------------------------------|

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

365: --
366: Cursor C_Sel1 is select per_contracts_s.nextval from sys.dual;
367: --
368: Begin
369: hr_utility.set_location('Entering:'||l_proc, 5);
370: --
371: --
372: -- Select the next sequence number
373: --

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

375: Fetch C_Sel1 Into p_rec.contract_id;
376: Close C_Sel1;
377: --
378: --
379: hr_utility.set_location(' Leaving:'||l_proc, 10);
380: End pre_insert;
381: --
382: -- ----------------------------------------------------------------------------
383: -- |-----------------------------< post_insert >------------------------------|

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

420: --
421: l_proc varchar2(72) := g_package||'post_insert';
422: --
423: Begin
424: hr_utility.set_location('Entering:'||l_proc, 5);
425: --
426: -- Start of API User Hook for post_insert.
427: --
428: begin

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

510: end;
511: --
512: -- End of API User Hook for post_insert.
513: --
514: hr_utility.set_location(' Leaving:'||l_proc, 10);
515: End post_insert;
516: --
517: -- ----------------------------------------------------------------------------
518: -- |-------------------------------< ins_lck >--------------------------------|

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

562: l_validation_start_date date;
563: l_validation_end_date date;
564: --
565: Begin
566: hr_utility.set_location('Entering:'||l_proc, 5);
567: --
568: -- Validate the datetrack mode mode getting the validation start
569: -- and end dates for the specified datetrack operation.
570: --

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

585: --
586: p_validation_start_date := l_validation_start_date;
587: p_validation_end_date := l_validation_end_date;
588: --
589: hr_utility.set_location(' Leaving:'||l_proc, 10);
590:
591: --
592: End ins_lck;
593: --

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

605: l_validation_start_date date;
606: l_validation_end_date date;
607: --
608: Begin
609: hr_utility.set_location('Entering:'||l_proc, 5);
610: --
611: -- Call the lock operation
612: --
613: ins_lck

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

730: l_rec per_ctc_shd.g_rec_type;
731: l_proc varchar2(72) := g_package||'ins';
732: --
733: Begin
734: hr_utility.set_location('Entering:'||l_proc, 5);
735: --
736: -- Call conversion function to turn arguments into the
737: -- p_rec structure.
738: --

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

819: p_effective_end_date := l_rec.effective_end_date;
820: p_object_version_number := l_rec.object_version_number;
821: --
822: --
823: hr_utility.set_location(' Leaving:'||l_proc, 10);
824: End ins;
825: --
826: end per_ctc_ins;