eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_ASG_INS dependencies on HR_UTILITY

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

20: --
21: l_proc varchar2(72) := g_package||'set_base_key_value';
22: --
23: Begin
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: per_asg_ins.g_assignment_id_i := p_assignment_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);

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

24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: per_asg_ins.g_assignment_id_i := p_assignment_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
29: End set_base_key_value;
30: --
31: -- ----------------------------------------------------------------------------
32: -- |----------------------------< dt_insert_dml >-----------------------------|

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

101: l_last_updated_by per_all_assignments_f.last_updated_by%TYPE;
102: l_last_update_login per_all_assignments_f.last_update_login%TYPE;
103: --
104: Begin
105: hr_utility.set_location('Entering:'||l_proc, 5);
106: --
107: -- Get the object version number for the insert
108: --
109: p_rec.object_version_number :=

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

121: -- If the datetrack_mode is not INSERT then we must populate the WHO
122: -- columns with the 'old' creation values and 'new' updated values.
123: --
124: If (p_datetrack_mode <> 'INSERT') then
125: hr_utility.set_location(l_proc, 10);
126: --
127: -- Select the 'old' created values
128: --
129: Open C_Sel1;

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

133: -- The previous 'old' created row has not been found. We need
134: -- to error as an internal datetrack problem exists.
135: --
136: Close C_Sel1;
137: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
138: hr_utility.set_message_token('PROCEDURE', l_proc);
139: hr_utility.set_message_token('STEP','10');
140: hr_utility.raise_error;
141: End If;

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

134: -- to error as an internal datetrack problem exists.
135: --
136: Close C_Sel1;
137: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
138: hr_utility.set_message_token('PROCEDURE', l_proc);
139: hr_utility.set_message_token('STEP','10');
140: hr_utility.raise_error;
141: End If;
142: Close C_Sel1;

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

135: --
136: Close C_Sel1;
137: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
138: hr_utility.set_message_token('PROCEDURE', l_proc);
139: hr_utility.set_message_token('STEP','10');
140: hr_utility.raise_error;
141: End If;
142: Close C_Sel1;
143: --

Line 140: hr_utility.raise_error;

136: Close C_Sel1;
137: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
138: hr_utility.set_message_token('PROCEDURE', l_proc);
139: hr_utility.set_message_token('STEP','10');
140: hr_utility.raise_error;
141: End If;
142: Close C_Sel1;
143: --
144: -- Set the AOL updated WHO values

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

389: p_rec.projected_assignment_end
390: );
391: --
392: per_asg_shd.g_api_dml := false; -- Unset the api dml status
393: hr_utility.set_location(' Leaving:'||l_proc, 15);
394: --
395: Exception
396: When hr_api.check_integrity_violated Then
397: -- A check constraint has been violated

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

420: --
421: l_proc varchar2(72) := g_package||'insert_dml';
422: --
423: Begin
424: hr_utility.set_location('Entering:'||l_proc, 5);
425: --
426: dt_insert_dml(p_rec => p_rec,
427: p_effective_date => p_effective_date,
428: p_datetrack_mode => p_datetrack_mode,

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

428: p_datetrack_mode => p_datetrack_mode,
429: p_validation_start_date => p_validation_start_date,
430: p_validation_end_date => p_validation_end_date);
431: --
432: hr_utility.set_location(' Leaving:'||l_proc, 10);
433: End insert_dml;
434: --
435: -- ----------------------------------------------------------------------------
436: -- |------------------------------< pre_insert >------------------------------|

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

490: where assignment_id =
491: per_asg_ins.g_assignment_id_i;
492: --
493: Begin
494: hr_utility.set_location('Entering:'||l_proc, 1);
495: --
496: If (per_asg_ins.g_assignment_id_i is not null) Then
497: --
498: -- Verify registered primary key values not already in use

Line 508: -- Changed the calls to hr_utility package.

504: --
505: -- The primary key values are already in use.
506: --
507: -- Bug 2661569
508: -- Changed the calls to hr_utility package.
509: hr_utility.set_message(800, 'PER_289391_KEY_ALREADY_USED');
510: hr_utility.set_message_token('TABLE_NAME', 'per_all_assignments_f');
511: hr_utility.raise_error;
512: End If;

Line 509: hr_utility.set_message(800, 'PER_289391_KEY_ALREADY_USED');

505: -- The primary key values are already in use.
506: --
507: -- Bug 2661569
508: -- Changed the calls to hr_utility package.
509: hr_utility.set_message(800, 'PER_289391_KEY_ALREADY_USED');
510: hr_utility.set_message_token('TABLE_NAME', 'per_all_assignments_f');
511: hr_utility.raise_error;
512: End If;
513: Close C_Sel2;

Line 510: hr_utility.set_message_token('TABLE_NAME', 'per_all_assignments_f');

506: --
507: -- Bug 2661569
508: -- Changed the calls to hr_utility package.
509: hr_utility.set_message(800, 'PER_289391_KEY_ALREADY_USED');
510: hr_utility.set_message_token('TABLE_NAME', 'per_all_assignments_f');
511: hr_utility.raise_error;
512: End If;
513: Close C_Sel2;
514: --

Line 511: hr_utility.raise_error;

507: -- Bug 2661569
508: -- Changed the calls to hr_utility package.
509: hr_utility.set_message(800, 'PER_289391_KEY_ALREADY_USED');
510: hr_utility.set_message_token('TABLE_NAME', 'per_all_assignments_f');
511: hr_utility.raise_error;
512: End If;
513: Close C_Sel2;
514: --
515: -- Use registered key values and clear globals

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

526: --
527: Open C_Sel1;
528: Fetch C_Sel1 Into p_rec.assignment_id;
529: Close C_Sel1;
530: hr_utility.set_location(l_proc, 10);
531: --
532: -- Insert the comment text if comments exist
533: --
534: If (p_rec.comment_text is not null) then

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

535: hr_comm_api.ins(p_comment_id => p_rec.comment_id,
536: p_source_table_name => 'PER_ALL_ASSIGNMENTS_F',
537: p_comment_text => p_rec.comment_text);
538: End If;
539: hr_utility.set_location(l_proc, 20);
540: End If;
541: --
542: -- Generate date probation end
543: --

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

561: );
562: end if;
563: -- Bug 4041992 Ends Here
564: --
565: hr_utility.set_location(l_proc, 30);
566: --
567: End pre_insert;
568: --
569: -- ----------------------------------------------------------------------------

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

738: --
739: l_proc varchar2(72) := g_package||'post_insert';
740: --
741: Begin
742: hr_utility.set_location('Entering:'||l_proc, 5);
743:
744: -- Start changes for bug 13855370
745: open c_asg_rec;
746: fetch c_asg_rec into l_old_rec;

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

1086: p_datetrack_mode);
1087:
1088: -- End of call to Workflow Sync Procedure For Assignments
1089: --
1090: hr_utility.set_location(' Leaving:'||l_proc, 10);
1091: End post_insert;
1092: -- ----------------------------------------------------------------------------
1093: -- |-------------------------------< ins_lck >--------------------------------|
1094: -- ----------------------------------------------------------------------------

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

1137: l_validation_start_date date;
1138: l_validation_end_date date;
1139: --
1140: Begin
1141: hr_utility.set_location('Entering:'||l_proc, 5);
1142: --
1143: -- Validate the datetrack mode getting the validation start
1144: -- and end dates for the specified datetrack operation.
1145: --

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

1174: --
1175: p_validation_start_date := l_validation_start_date;
1176: p_validation_end_date := l_validation_end_date;
1177: --
1178: hr_utility.set_location(' Leaving:'||l_proc, 15);
1179: --
1180: End ins_lck;
1181: --
1182: -- ----------------------------------------------------------------------------

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

1198: l_validation_end_date date;
1199: l_inv_pos_grade_warning boolean;
1200: --
1201: Begin
1202: hr_utility.set_location('Entering:'||l_proc, 5);
1203: --
1204: -- Determine if the business process is to be validated.
1205: --
1206: If p_validate then

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

1281: If p_validate then
1282: Raise HR_Api.Validate_Enabled;
1283: End If;
1284: --
1285: hr_utility.set_location(' Leaving:'||l_proc, 10);
1286: Exception
1287: When HR_Api.Validate_Enabled Then
1288: --
1289: -- As the Validate_Enabled exception has been raised

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

1420: l_rec per_asg_shd.g_rec_type;
1421: l_proc varchar2(72) := g_package||'ins';
1422: --
1423: Begin
1424: hr_utility.set_location('Entering:'||l_proc, 5);
1425: --
1426: -- Call conversion function to turn arguments into the
1427: -- p_rec structure.
1428: --

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

1564: p_comment_id := l_rec.comment_id;
1565: p_assignment_number := l_rec.assignment_number;
1566: p_assignment_sequence := l_rec.assignment_sequence;
1567: --
1568: hr_utility.set_location(' Leaving:'||l_proc, 10);
1569: End ins;
1570: --
1571: end per_asg_ins;