DBA Data[Home] [Help]

APPS.PER_SSM_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: p_rec.object_version_number := 1; -- Initialise the object version
60: --
61: per_ssm_shd.g_api_dml := true; -- Set the api dml status
62: --

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

130: );
131: --
132: per_ssm_shd.g_api_dml := false; -- Unset the api dml status
133: --
134: hr_utility.set_location(' Leaving:'||l_proc, 10);
135: Exception
136: When hr_api.check_integrity_violated Then
137: -- A check constraint has been violated
138: hr_utility.set_location(l_proc, 6);

Line 138: hr_utility.set_location(l_proc, 6);

134: hr_utility.set_location(' Leaving:'||l_proc, 10);
135: Exception
136: When hr_api.check_integrity_violated Then
137: -- A check constraint has been violated
138: hr_utility.set_location(l_proc, 6);
139: per_ssm_shd.g_api_dml := false; -- Unset the api dml status
140: per_ssm_shd.constraint_error
141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
142: When hr_api.parent_integrity_violated Then

Line 143: hr_utility.set_location(l_proc, 7);

139: per_ssm_shd.g_api_dml := false; -- Unset the api dml status
140: per_ssm_shd.constraint_error
141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
142: When hr_api.parent_integrity_violated Then
143: hr_utility.set_location(l_proc, 7);
144: -- Parent integrity has been violated
145: per_ssm_shd.g_api_dml := false; -- Unset the api dml status
146: per_ssm_shd.constraint_error
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 149: hr_utility.set_location(l_proc, 8);

145: per_ssm_shd.g_api_dml := false; -- Unset the api dml status
146: per_ssm_shd.constraint_error
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
148: When hr_api.unique_integrity_violated Then
149: hr_utility.set_location(l_proc, 8);
150: -- Unique integrity has been violated
151: per_ssm_shd.g_api_dml := false; -- Unset the api dml status
152: per_ssm_shd.constraint_error
153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 155: hr_utility.set_location(l_proc, 9);

151: per_ssm_shd.g_api_dml := false; -- Unset the api dml status
152: per_ssm_shd.constraint_error
153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
154: When Others Then
155: hr_utility.set_location(l_proc, 9);
156: per_ssm_shd.g_api_dml := false; -- Unset the api dml status
157: Raise;
158: End insert_dml;
159: --

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

200: --
201: Cursor C_Sel1 is select per_salary_survey_mappings_s.nextval from sys.dual;
202: --
203: Begin
204: hr_utility.set_location('Entering:'||l_proc, 5);
205: --
206: --
207: -- Select the next sequence number
208: --

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

209: Open C_Sel1;
210: Fetch C_Sel1 Into p_rec.salary_survey_mapping_id;
211: Close C_Sel1;
212: --
213: hr_utility.set_location(' Leaving:'||l_proc, 10);
214: End pre_insert;
215: --
216: -- ----------------------------------------------------------------------------
217: -- |-----------------------------< post_insert >------------------------------|

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

250: --
251: l_proc varchar2(72) := g_package||'post_insert';
252: --
253: Begin
254: hr_utility.set_location('Entering:'||l_proc, 5);
255: --
256: begin
257: per_ssm_rki.after_insert
258: (

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

298: ,p_hook_type => 'AI'
299: );
300: end;
301: --
302: hr_utility.set_location(' Leaving:'||l_proc, 10);
303: End post_insert;
304: --
305: -- ----------------------------------------------------------------------------
306: -- |---------------------------------< ins >----------------------------------|

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

313: --
314: l_proc varchar2(72) := g_package||'ins';
315: --
316: Begin
317: hr_utility.set_location('Entering:'||l_proc, 5);
318: --
319: -- Call the supporting insert validate operations
320: --
321: per_ssm_bus.insert_validate(p_rec, p_effective_date);

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

375: l_rec per_ssm_shd.g_rec_type;
376: l_proc varchar2(72) := g_package||'ins';
377: --
378: Begin
379: hr_utility.set_location('Entering:'||l_proc, 5);
380: --
381: -- Call conversion function to turn arguments into the
382: -- p_rec structure.
383: --

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

427: --
428: p_salary_survey_mapping_id := l_rec.salary_survey_mapping_id;
429: p_object_version_number := l_rec.object_version_number;
430: --
431: hr_utility.set_location(' Leaving:'||l_proc, 10);
432: End ins;
433: --
434: end per_ssm_ins;