DBA Data[Home] [Help]

APPS.PER_PTU_INS dependencies on HR_UTILITY

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

73: l_last_updated_by per_person_type_usages_f.last_updated_by%TYPE;
74: l_last_update_login per_person_type_usages_f.last_update_login%TYPE;
75: --
76: Begin
77: hr_utility.set_location('Entering:'||l_proc, 5);
78: --
79: -- Get the object version number for the insert
80: --
81: p_rec.object_version_number :=

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

93: -- If the datetrack_mode is not INSERT then we must populate the WHO
94: -- columns with the 'old' creation values and 'new' updated values.
95: --
96: If (p_datetrack_mode <> 'INSERT') then
97: hr_utility.set_location(l_proc, 10);
98: --
99: -- Select the 'old' created values
100: --
101: Open C_Sel1;

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

105: -- The previous 'old' created row has not been found. We need
106: -- to error as an internal datetrack problem exists.
107: --
108: Close C_Sel1;
109: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
110: hr_utility.set_message_token('PROCEDURE', l_proc);
111: hr_utility.set_message_token('STEP','10');
112: hr_utility.raise_error;
113: End If;

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

106: -- to error as an internal datetrack problem exists.
107: --
108: Close C_Sel1;
109: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
110: hr_utility.set_message_token('PROCEDURE', l_proc);
111: hr_utility.set_message_token('STEP','10');
112: hr_utility.raise_error;
113: End If;
114: Close C_Sel1;

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

107: --
108: Close C_Sel1;
109: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
110: hr_utility.set_message_token('PROCEDURE', l_proc);
111: hr_utility.set_message_token('STEP','10');
112: hr_utility.raise_error;
113: End If;
114: Close C_Sel1;
115: --

Line 112: hr_utility.raise_error;

108: Close C_Sel1;
109: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
110: hr_utility.set_message_token('PROCEDURE', l_proc);
111: hr_utility.set_message_token('STEP','10');
112: hr_utility.raise_error;
113: End If;
114: Close C_Sel1;
115: --
116: -- Set the AOL updated WHO values

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

219: l_last_updated_by,
220: l_last_update_login
221: );
222: --
223: hr_utility.set_location(' Leaving:'||l_proc, 15);
224: --
225: Exception
226: When hr_api.check_integrity_violated Then
227: -- A check constraint has been violated

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

247: --
248: l_proc varchar2(72) := g_package||'insert_dml';
249: --
250: Begin
251: hr_utility.set_location('Entering:'||l_proc, 5);
252: --
253: dt_insert_dml(p_rec => p_rec,
254: p_effective_date => p_effective_date,
255: p_datetrack_mode => p_datetrack_mode,

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

255: p_datetrack_mode => p_datetrack_mode,
256: p_validation_start_date => p_validation_start_date,
257: p_validation_end_date => p_validation_end_date);
258: --
259: hr_utility.set_location(' Leaving:'||l_proc, 10);
260: End insert_dml;
261: --
262: -- ----------------------------------------------------------------------------
263: -- |------------------------------< pre_insert >------------------------------|

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

309: --
310: Cursor C_Sel1 is select per_person_type_usages_s.nextval from sys.dual;
311: --
312: Begin
313: hr_utility.set_location('Entering:'||l_proc, 5);
314: --
315: --
316: -- Select the next sequence number
317: --

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

319: Fetch C_Sel1 Into p_rec.person_type_usage_id;
320: Close C_Sel1;
321: --
322: --
323: hr_utility.set_location(' Leaving:'||l_proc, 10);
324: End pre_insert;
325: --
326: -- ----------------------------------------------------------------------------
327: -- |-----------------------------< post_insert >------------------------------|

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

372: -- End of Fix for WWBUG 1408379
373: --
374: --
375: Begin
376: hr_utility.set_location('Entering:'||l_proc, 5);
377: --
378: --
379: -- Start of API User Hook for post_insert.
380: begin

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

453: --
454: --
455: -- End of API User Hook for post_insert.
456: --
457: hr_utility.set_location(' Leaving:'||l_proc, 10);
458: End post_insert;
459: --
460: -- ----------------------------------------------------------------------------
461: -- |-------------------------------< ins_lck >--------------------------------|

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

505: l_validation_start_date date;
506: l_validation_end_date date;
507: --
508: Begin
509: hr_utility.set_location('Entering:'||l_proc, 5);
510: --
511: -- Validate the datetrack mode mode getting the validation start
512: -- and end dates for the specified datetrack operation.
513: --

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

528: --
529: p_validation_start_date := l_validation_start_date;
530: p_validation_end_date := l_validation_end_date;
531: --
532: hr_utility.set_location(' Leaving:'||l_proc, 10);
533: --
534: End ins_lck;
535: --
536: -- ----------------------------------------------------------------------------

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

547: l_validation_start_date date;
548: l_validation_end_date date;
549: --
550: Begin
551: hr_utility.set_location('Entering:'||l_proc, 5);
552: --
553: -- Call the lock operation
554: --
555: ins_lck

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

648: l_rec per_ptu_shd.g_rec_type;
649: l_proc varchar2(72) := g_package||'ins';
650: --
651: Begin
652: hr_utility.set_location('Entering:'||l_proc, 5);
653: --
654: -- Call conversion function to turn arguments into the
655: -- p_rec structure.
656: --

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

713: p_effective_end_date := l_rec.effective_end_date;
714: p_object_version_number := l_rec.object_version_number;
715: --
716: --
717: hr_utility.set_location(' Leaving:'||l_proc, 10);
718: End ins;
719: --
720: end per_ptu_ins;