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_ECO_INS dependencies on HR_UTILITY

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

61: l_last_updated_by per_election_constituencys.last_updated_by%TYPE;
62: l_last_update_login per_election_constituencys.last_update_login%TYPE;
63: --
64: Begin
65: hr_utility.set_location('Entering:'||l_proc, 5);
66: p_rec.object_version_number := 1; -- Initialise the object version
67: --
68: per_eco_shd.g_api_dml := true; -- Set the api dml status
69: --

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

76: l_last_update_login := fnd_global.login_id;
77: --
78: -- Insert the row into: per_election_constituencys
79: --
80: hr_utility.set_location('Entering:'||l_proc, 10);
81: insert into per_election_constituencys
82: (election_constituency_id
83: ,election_id
84: ,business_group_id

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

166: );
167: --
168: per_eco_shd.g_api_dml := false; -- Unset the api dml status
169: --
170: hr_utility.set_location(' Leaving:'||l_proc, 10);
171: Exception
172: When hr_api.check_integrity_violated Then
173: hr_utility.set_location(' Leaving:'||l_proc, 11);
174: -- A check constraint has been violated

Line 173: hr_utility.set_location(' Leaving:'||l_proc, 11);

169: --
170: hr_utility.set_location(' Leaving:'||l_proc, 10);
171: Exception
172: When hr_api.check_integrity_violated Then
173: hr_utility.set_location(' Leaving:'||l_proc, 11);
174: -- A check constraint has been violated
175: per_eco_shd.g_api_dml := false; -- Unset the api dml status
176: per_eco_shd.constraint_error
177: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 179: hr_utility.set_location(' Leaving:'||l_proc, 12);

175: per_eco_shd.g_api_dml := false; -- Unset the api dml status
176: per_eco_shd.constraint_error
177: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
178: When hr_api.parent_integrity_violated Then
179: hr_utility.set_location(' Leaving:'||l_proc, 12);
180: -- Parent integrity has been violated
181: per_eco_shd.g_api_dml := false; -- Unset the api dml status
182: per_eco_shd.constraint_error
183: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 185: hr_utility.set_location(' Leaving:'||l_proc, 13);

181: per_eco_shd.g_api_dml := false; -- Unset the api dml status
182: per_eco_shd.constraint_error
183: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
184: When hr_api.unique_integrity_violated Then
185: hr_utility.set_location(' Leaving:'||l_proc, 13);
186: -- Unique integrity has been violated
187: per_eco_shd.g_api_dml := false; -- Unset the api dml status
188: per_eco_shd.constraint_error
189: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 191: hr_utility.set_location(' Leaving:'||l_proc, 14);

187: per_eco_shd.g_api_dml := false; -- Unset the api dml status
188: per_eco_shd.constraint_error
189: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
190: When Others Then
191: hr_utility.set_location(' Leaving:'||l_proc, 14);
192: per_eco_shd.g_api_dml := false; -- Unset the api dml status
193: Raise;
194: End insert_dml;
195: --

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

238: --
239: Cursor C_Sel1 is select per_election_constituencys_s.nextval from sys.dual;
240: --
241: Begin
242: hr_utility.set_location('Entering:'||l_proc, 5);
243: --
244: --
245: -- Select the next sequence number
246: --

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

247: Open C_Sel1;
248: Fetch C_Sel1 Into p_rec.election_constituency_id;
249: Close C_Sel1;
250: --
251: hr_utility.set_location(' Leaving:'||l_proc, 10);
252: End pre_insert;
253: --
254: -- ----------------------------------------------------------------------------
255: -- |-----------------------------< post_insert >------------------------------|

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

290: --
291: l_proc varchar2(72) := g_package||'post_insert';
292: --
293: Begin
294: hr_utility.set_location('Entering:'||l_proc, 5);
295: begin
296: --
297: per_eco_rki.after_insert
298: (p_effective_date => p_effective_date

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

379: ,p_hook_type => 'AI');
380: --
381: end;
382: --
383: hr_utility.set_location(' Leaving:'||l_proc, 10);
384: End post_insert;
385: --
386: -- ----------------------------------------------------------------------------
387: -- |---------------------------------< ins >----------------------------------|

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

394: --
395: l_proc varchar2(72) := g_package||'ins';
396: --
397: Begin
398: hr_utility.set_location('Entering:'||l_proc, 5);
399: --
400: -- Determine if the business process is to be validated.
401: --
402: If p_validate then

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

434: If p_validate then
435: Raise HR_Api.Validate_Enabled;
436: End If;
437: --
438: hr_utility.set_location(' Leaving:'||l_proc, 10);
439: Exception
440: When HR_Api.Validate_Enabled Then
441: --
442: -- As the Validate_Enabled exception has been raised

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

443: -- we must rollback to the savepoint
444: --
445: ROLLBACK TO ins_per_elc;
446: --
447: hr_utility.set_location('Leaving:'||l_proc, 20);
448: end ins;
449: --
450: -- ----------------------------------------------------------------------------
451: -- |---------------------------------< ins >----------------------------------|

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

494: l_rec per_eco_shd.g_rec_type;
495: l_proc varchar2(72) := g_package||'ins';
496: --
497: Begin
498: hr_utility.set_location('Entering:'||l_proc, 5);
499: --
500: -- Call conversion function to turn arguments into the
501: -- p_rec structure.
502: --

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

554: --
555: p_election_constituency_id := l_rec.election_constituency_id;
556: p_object_version_number := l_rec.object_version_number;
557: --
558: hr_utility.set_location(' Leaving:'||l_proc, 10);
559: End ins;
560: --
561: end per_eco_ins;