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_GRD_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_grd_ins.g_grade_id_i := p_grade_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_grd_ins.g_grade_id_i := p_grade_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
29: End set_base_key_value;
30: --
31: --
32: -- ----------------------------------------------------------------------------

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

78: --
79: l_proc varchar2(72) := g_package||'insert_dml';
80: --
81: Begin
82: hr_utility.set_location('Entering:'||l_proc, 5);
83: hr_utility.trace(l_proc || ' : p_rec.grade_id => ' || p_rec.grade_id);
84: hr_utility.trace(l_proc || ' : p_rec.grade_definition_id => ' || p_rec.grade_definition_id);
85: hr_utility.trace('business_group_id => ' || p_rec.business_group_id);
86: hr_utility.trace('date_from => ' || p_rec.date_from);

Line 83: hr_utility.trace(l_proc || ' : p_rec.grade_id => ' || p_rec.grade_id);

79: l_proc varchar2(72) := g_package||'insert_dml';
80: --
81: Begin
82: hr_utility.set_location('Entering:'||l_proc, 5);
83: hr_utility.trace(l_proc || ' : p_rec.grade_id => ' || p_rec.grade_id);
84: hr_utility.trace(l_proc || ' : p_rec.grade_definition_id => ' || p_rec.grade_definition_id);
85: hr_utility.trace('business_group_id => ' || p_rec.business_group_id);
86: hr_utility.trace('date_from => ' || p_rec.date_from);
87: hr_utility.trace('sequence => ' || p_rec.sequence);

Line 84: hr_utility.trace(l_proc || ' : p_rec.grade_definition_id => ' || p_rec.grade_definition_id);

80: --
81: Begin
82: hr_utility.set_location('Entering:'||l_proc, 5);
83: hr_utility.trace(l_proc || ' : p_rec.grade_id => ' || p_rec.grade_id);
84: hr_utility.trace(l_proc || ' : p_rec.grade_definition_id => ' || p_rec.grade_definition_id);
85: hr_utility.trace('business_group_id => ' || p_rec.business_group_id);
86: hr_utility.trace('date_from => ' || p_rec.date_from);
87: hr_utility.trace('sequence => ' || p_rec.sequence);
88: hr_utility.trace('name => ' || p_rec.name);

Line 85: hr_utility.trace('business_group_id => ' || p_rec.business_group_id);

81: Begin
82: hr_utility.set_location('Entering:'||l_proc, 5);
83: hr_utility.trace(l_proc || ' : p_rec.grade_id => ' || p_rec.grade_id);
84: hr_utility.trace(l_proc || ' : p_rec.grade_definition_id => ' || p_rec.grade_definition_id);
85: hr_utility.trace('business_group_id => ' || p_rec.business_group_id);
86: hr_utility.trace('date_from => ' || p_rec.date_from);
87: hr_utility.trace('sequence => ' || p_rec.sequence);
88: hr_utility.trace('name => ' || p_rec.name);
89: hr_utility.trace('short_name => ' || p_rec.short_name);

Line 86: hr_utility.trace('date_from => ' || p_rec.date_from);

82: hr_utility.set_location('Entering:'||l_proc, 5);
83: hr_utility.trace(l_proc || ' : p_rec.grade_id => ' || p_rec.grade_id);
84: hr_utility.trace(l_proc || ' : p_rec.grade_definition_id => ' || p_rec.grade_definition_id);
85: hr_utility.trace('business_group_id => ' || p_rec.business_group_id);
86: hr_utility.trace('date_from => ' || p_rec.date_from);
87: hr_utility.trace('sequence => ' || p_rec.sequence);
88: hr_utility.trace('name => ' || p_rec.name);
89: hr_utility.trace('short_name => ' || p_rec.short_name);
90: p_rec.object_version_number := 1; -- Initialise the object version

Line 87: hr_utility.trace('sequence => ' || p_rec.sequence);

83: hr_utility.trace(l_proc || ' : p_rec.grade_id => ' || p_rec.grade_id);
84: hr_utility.trace(l_proc || ' : p_rec.grade_definition_id => ' || p_rec.grade_definition_id);
85: hr_utility.trace('business_group_id => ' || p_rec.business_group_id);
86: hr_utility.trace('date_from => ' || p_rec.date_from);
87: hr_utility.trace('sequence => ' || p_rec.sequence);
88: hr_utility.trace('name => ' || p_rec.name);
89: hr_utility.trace('short_name => ' || p_rec.short_name);
90: p_rec.object_version_number := 1; -- Initialise the object version
91: --

Line 88: hr_utility.trace('name => ' || p_rec.name);

84: hr_utility.trace(l_proc || ' : p_rec.grade_definition_id => ' || p_rec.grade_definition_id);
85: hr_utility.trace('business_group_id => ' || p_rec.business_group_id);
86: hr_utility.trace('date_from => ' || p_rec.date_from);
87: hr_utility.trace('sequence => ' || p_rec.sequence);
88: hr_utility.trace('name => ' || p_rec.name);
89: hr_utility.trace('short_name => ' || p_rec.short_name);
90: p_rec.object_version_number := 1; -- Initialise the object version
91: --
92: per_grd_shd.g_api_dml := true; -- Set the api dml status

Line 89: hr_utility.trace('short_name => ' || p_rec.short_name);

85: hr_utility.trace('business_group_id => ' || p_rec.business_group_id);
86: hr_utility.trace('date_from => ' || p_rec.date_from);
87: hr_utility.trace('sequence => ' || p_rec.sequence);
88: hr_utility.trace('name => ' || p_rec.name);
89: hr_utility.trace('short_name => ' || p_rec.short_name);
90: p_rec.object_version_number := 1; -- Initialise the object version
91: --
92: per_grd_shd.g_api_dml := true; -- Set the api dml status
93: --

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

209: );
210: --
211: per_grd_shd.g_api_dml := false; -- Unset the api dml status
212: --
213: hr_utility.set_location(' Leaving:'||l_proc, 10);
214: Exception
215: When hr_api.check_integrity_violated Then
216: hr_utility.set_location(' Leaving:'||l_proc, 20);
217: -- A check constraint has been violated

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

212: --
213: hr_utility.set_location(' Leaving:'||l_proc, 10);
214: Exception
215: When hr_api.check_integrity_violated Then
216: hr_utility.set_location(' Leaving:'||l_proc, 20);
217: -- A check constraint has been violated
218: per_grd_shd.g_api_dml := false; -- Unset the api dml status
219: per_grd_shd.constraint_error
220: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 222: hr_utility.set_location(' Leaving:'||l_proc, 30);

218: per_grd_shd.g_api_dml := false; -- Unset the api dml status
219: per_grd_shd.constraint_error
220: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
221: When hr_api.parent_integrity_violated Then
222: hr_utility.set_location(' Leaving:'||l_proc, 30);
223: -- Parent integrity has been violated
224: per_grd_shd.g_api_dml := false; -- Unset the api dml status
225: per_grd_shd.constraint_error
226: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 228: hr_utility.set_location(' Leaving:'||l_proc, 40);

224: per_grd_shd.g_api_dml := false; -- Unset the api dml status
225: per_grd_shd.constraint_error
226: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
227: When hr_api.unique_integrity_violated Then
228: hr_utility.set_location(' Leaving:'||l_proc, 40);
229: -- Unique integrity has been violated
230: per_grd_shd.g_api_dml := false; -- Unset the api dml status
231: per_grd_shd.constraint_error
232: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 234: hr_utility.set_location(' Leaving:'||l_proc, 50);

230: per_grd_shd.g_api_dml := false; -- Unset the api dml status
231: per_grd_shd.constraint_error
232: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
233: When Others Then
234: hr_utility.set_location(' Leaving:'||l_proc, 50);
235: per_grd_shd.g_api_dml := false; -- Unset the api dml status
236: Raise;
237: End insert_dml;
238: --

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

288: l_proc varchar2(72) := g_package||'pre_insert';
289: l_exists varchar2(1);
290: --
291: Begin
292: hr_utility.set_location('Entering:'||l_proc, 5);
293: --
294: If (per_grd_ins.g_grade_id_i is not null) Then
295: --
296: -- Verify registered primary key values not already in use

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

306: fnd_message.set_token('TABLE_NAME','per_grades');
307: fnd_message.raise_error;
308: End If;
309: Close C_Sel2;
310: hr_utility.set_location(l_proc, 10);
311: --
312: -- Use registered key values and clear globals
313: --
314: p_rec.grade_id :=

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

314: p_rec.grade_id :=
315: per_grd_ins.g_grade_id_i;
316: per_grd_ins.g_grade_id_i := null;
317: Else
318: hr_utility.set_location(l_proc, 20);
319: --
320: -- No registerd key values, so select the next sequence number
321: --
322: --

Line 330: hr_utility.set_location(' Leaving:'||l_proc, 100);

326: Fetch C_Sel1 Into p_rec.grade_id;
327: Close C_Sel1;
328: End If;
329: --
330: hr_utility.set_location(' Leaving:'||l_proc, 100);
331: End pre_insert;
332: --
333: -- ----------------------------------------------------------------------------
334: -- |-----------------------------< post_insert >------------------------------|

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

369: --
370: l_proc varchar2(72) := g_package||'post_insert';
371: --
372: Begin
373: hr_utility.set_location('Entering:'||l_proc, 5);
374: begin
375: --
376: per_grd_rki.after_insert
377: (p_effective_date => p_effective_date

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

496: ,p_hook_type => 'AI');
497: --
498: end;
499: --
500: hr_utility.set_location(' Leaving:'||l_proc, 10);
501: End post_insert;
502: --
503: -- ----------------------------------------------------------------------------
504: -- |---------------------------------< ins >----------------------------------|

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

510: --
511: l_proc varchar2(72) := g_package||'ins';
512: --
513: Begin
514: hr_utility.set_location('Entering:'||l_proc, 5);
515: --
516: -- Call the supporting insert validate operations
517: --
518: per_grd_bus.insert_validate

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

540: --
541: -- Call to raise any errors on multi-message list
542: hr_multi_message.end_validation_set;
543: --
544: hr_utility.set_location('Leaving:'||l_proc, 20);
545: end ins;
546: --
547: -- ----------------------------------------------------------------------------
548: -- |---------------------------------< ins >----------------------------------|

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

609: l_rec per_grd_shd.g_rec_type;
610: l_proc varchar2(72) := g_package||'ins';
611: --
612: Begin
613: hr_utility.set_location('Entering:'||l_proc, 5);
614: --
615: -- Call conversion function to turn arguments into the
616: -- p_rec structure.
617: --

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

687: --
688: p_grade_id := l_rec.grade_id;
689: p_object_version_number := l_rec.object_version_number;
690: --
691: hr_utility.set_location(' Leaving:'||l_proc, 10);
692: End ins;
693: --
694: end per_grd_ins;