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

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

54: --
55: l_proc varchar2(72) := g_package||'insert_dml';
56: --
57: Begin
58: hr_utility.set_location('Entering:'||l_proc, 5);
59: hr_utility.set_location('SS id '||to_char(p_rec.salary_survey_id), 5);
60: p_rec.object_version_number := 1; -- Initialise the object version
61: --
62: --

Line 59: hr_utility.set_location('SS id '||to_char(p_rec.salary_survey_id), 5);

55: l_proc varchar2(72) := g_package||'insert_dml';
56: --
57: Begin
58: hr_utility.set_location('Entering:'||l_proc, 5);
59: hr_utility.set_location('SS id '||to_char(p_rec.salary_survey_id), 5);
60: p_rec.object_version_number := 1; -- Initialise the object version
61: --
62: --
63: -- Insert the row into: per_salary_survey_lines

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

233: /*End Enhancement 4021737 */
234: );
235: --
236: --
237: hr_utility.set_location(' Leaving:'||l_proc, 10);
238: Exception
239: When hr_api.check_integrity_violated Then
240: -- A check constraint has been violated
241: hr_utility.set_location('check integrity constraint',11);

Line 241: hr_utility.set_location('check integrity constraint',11);

237: hr_utility.set_location(' Leaving:'||l_proc, 10);
238: Exception
239: When hr_api.check_integrity_violated Then
240: -- A check constraint has been violated
241: hr_utility.set_location('check integrity constraint',11);
242: per_ssl_shd.constraint_error
243: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
244: When hr_api.parent_integrity_violated Then
245: -- Parent integrity has been violated

Line 246: hr_utility.set_location('parent integrity constraint',11);

242: per_ssl_shd.constraint_error
243: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
244: When hr_api.parent_integrity_violated Then
245: -- Parent integrity has been violated
246: hr_utility.set_location('parent integrity constraint',11);
247: per_ssl_shd.constraint_error
248: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
249: When hr_api.unique_integrity_violated Then
250: -- Unique integrity has been violated

Line 251: hr_utility.set_location('unique integrity constraint ',11);

247: per_ssl_shd.constraint_error
248: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
249: When hr_api.unique_integrity_violated Then
250: -- Unique integrity has been violated
251: hr_utility.set_location('unique integrity constraint ',11);
252: hr_utility.set_location(SQLERRM,12);
253: per_ssl_shd.constraint_error
254: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
255: When Others Then

Line 252: hr_utility.set_location(SQLERRM,12);

248: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
249: When hr_api.unique_integrity_violated Then
250: -- Unique integrity has been violated
251: hr_utility.set_location('unique integrity constraint ',11);
252: hr_utility.set_location(SQLERRM,12);
253: per_ssl_shd.constraint_error
254: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
255: When Others Then
256: Raise;

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

299: --
300: Cursor C_Sel1 is select per_salary_survey_lines_s.nextval from sys.dual;
301: --
302: Begin
303: hr_utility.set_location('Entering:'||l_proc, 5);
304: --
305: --
306: -- Select the next sequence number
307: --

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

308: Open C_Sel1;
309: Fetch C_Sel1 Into p_rec.salary_survey_line_id;
310: Close C_Sel1;
311: --
312: hr_utility.set_location(' Leaving:'||l_proc, 10);
313: End pre_insert;
314: --
315: -- ----------------------------------------------------------------------------
316: -- |-----------------------------< post_insert >------------------------------|

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

349: --
350: l_proc varchar2(72) := g_package||'post_insert';
351: --
352: Begin
353: hr_utility.set_location('Entering:'||l_proc, 5);
354: --
355: begin
356: per_ssl_rki.after_insert
357: (p_salary_survey_line_id

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

529: );
530: end;
531:
532: --
533: hr_utility.set_location(' Leaving:'||l_proc, 10);
534: End post_insert;
535: --
536: -- ----------------------------------------------------------------------------
537: -- |---------------------------------< ins >----------------------------------|

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

544: --
545: l_proc varchar2(72) := g_package||'ins';
546: --
547: Begin
548: hr_utility.set_location('Entering:'||l_proc, 5);
549: --
550: -- Call the supporting insert validate operations
551: --
552: per_ssl_bus.insert_validate(p_rec, p_effective_date);

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

658: l_rec per_ssl_shd.g_rec_type;
659: l_proc varchar2(72) := g_package||'ins';
660: --
661: Begin
662: hr_utility.set_location('Entering:'||l_proc, 5);
663: --
664: -- Call conversion function to turn arguments into the
665: -- p_rec structure.
666: --

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

762: --
763: p_salary_survey_line_id := l_rec.salary_survey_line_id;
764: p_object_version_number := l_rec.object_version_number;
765: --
766: hr_utility.set_location(' Leaving:'||l_proc, 10);
767: End ins;
768: --
769: End per_ssl_ins;