DBA Data[Home] [Help]

APPS.BEN_ASG_INS dependencies on HR_UTILITY

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

80: l_last_updated_by per_all_assignments_f.last_updated_by%TYPE;
81: l_last_update_login per_all_assignments_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 360: hr_utility.set_location(' Leaving:'||l_proc, 15);

356: p_rec.applicant_rank
357: );
358: --
359: per_asg_shd.g_api_dml := false; -- Unset the api dml status
360: hr_utility.set_location(' Leaving:'||l_proc, 15);
361: --
362: Exception
363: When hr_api.check_integrity_violated Then
364: -- A check constraint has been violated

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

387: --
388: l_proc varchar2(72) := g_package||'insert_dml';
389: --
390: Begin
391: hr_utility.set_location('Entering:'||l_proc, 5);
392: --
393: dt_insert_dml(p_rec => p_rec,
394: p_effective_date => p_effective_date,
395: p_datetrack_mode => p_datetrack_mode,

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

395: p_datetrack_mode => p_datetrack_mode,
396: p_validation_start_date => p_validation_start_date,
397: p_validation_end_date => p_validation_end_date);
398: --
399: hr_utility.set_location(' Leaving:'||l_proc, 10);
400: End insert_dml;
401: --
402: -- ----------------------------------------------------------------------------
403: -- |------------------------------< pre_insert >------------------------------|

Line 454: hr_utility.set_location('Entering:'||l_proc, 1);

450: --
451: Cursor C_Sel1 is select per_assignments_s.nextval from sys.dual;
452: --
453: Begin
454: hr_utility.set_location('Entering:'||l_proc, 1);
455: --
456: -- Select the next sequence number
457: --
458: Open C_Sel1;

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

457: --
458: Open C_Sel1;
459: Fetch C_Sel1 Into p_rec.assignment_id;
460: Close C_Sel1;
461: hr_utility.set_location(l_proc, 10);
462: --
463: -- Insert the comment text if comments exist
464: --
465: If (p_rec.comment_text is not null) then

Line 470: hr_utility.set_location(l_proc, 20);

466: hr_comm_api.ins(p_comment_id => p_rec.comment_id,
467: p_source_table_name => 'PER_ALL_ASSIGNMENTS_F',
468: p_comment_text => p_rec.comment_text);
469: End If;
470: hr_utility.set_location(l_proc, 20);
471: --
472: -- Generate date probation end
473: --
474: -- Business Rule Mapping

Line 490: hr_utility.set_location(l_proc, 30);

486: ,p_object_version_number => p_rec.object_version_number
487: ,p_date_probation_end => p_rec.date_probation_end
488: );
489: --
490: hr_utility.set_location(l_proc, 30);
491: --
492: End pre_insert;
493: --
494: -- ----------------------------------------------------------------------------

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

532: --
533: l_proc varchar2(72) := g_package||'post_insert';
534: --
535: Begin
536: hr_utility.set_location('Entering:'||l_proc, 5);
537: --
538: g_trgr_loc_chg := FALSE; --Bug 2666342
539:
540: ben_dt_trgr_handle.assignment

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

724: );
725: end;
726: -- End of API User Hook for post_insert.
727: --
728: hr_utility.set_location(' Leaving:'||l_proc, 10);
729: End post_insert;
730: -- ----------------------------------------------------------------------------
731: -- |-------------------------------< ins_lck >--------------------------------|
732: -- ----------------------------------------------------------------------------

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

775: l_validation_start_date date;
776: l_validation_end_date date;
777: --
778: Begin
779: hr_utility.set_location('Entering:'||l_proc, 5);
780: --
781: -- Validate the datetrack mode getting the validation start
782: -- and end dates for the specified datetrack operation.
783: --

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

807: --
808: p_validation_start_date := l_validation_start_date;
809: p_validation_end_date := l_validation_end_date;
810: --
811: hr_utility.set_location(' Leaving:'||l_proc, 15);
812: --
813: End ins_lck;
814: --
815: -- ----------------------------------------------------------------------------

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

831: l_validation_end_date date;
832: l_inv_pos_grade_warning boolean;
833: --
834: Begin
835: hr_utility.set_location('Entering:'||l_proc, 5);
836: --
837: -- Determine if the business process is to be validated.
838: --
839: If p_validate then

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

943: If p_validate then
944: Raise HR_Api.Validate_Enabled;
945: End If;
946: --
947: hr_utility.set_location(' Leaving:'||l_proc, 10);
948: Exception
949: When HR_Api.Validate_Enabled Then
950: --
951: -- As the Validate_Enabled exception has been raised

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

1076: l_rec per_asg_shd.g_rec_type;
1077: l_proc varchar2(72) := g_package||'ins';
1078: --
1079: Begin
1080: hr_utility.set_location('Entering:'||l_proc, 5);
1081: --
1082: -- Call conversion function to turn arguments into the
1083: -- p_rec structure.
1084: --

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

1220: p_comment_id := l_rec.comment_id;
1221: p_assignment_number := l_rec.assignment_number;
1222: p_assignment_sequence := l_rec.assignment_sequence;
1223: --
1224: hr_utility.set_location(' Leaving:'||l_proc, 10);
1225: End ins;
1226: --
1227: end ben_asg_ins;