DBA Data[Home] [Help]

APPS.HR_PAP_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: hr_pap_shd.g_api_dml := true; -- Set the api dml status
62: --

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

76: );
77: --
78: hr_pap_shd.g_api_dml := false; -- Unset the api dml status
79: --
80: hr_utility.set_location(' Leaving:'||l_proc, 10);
81: Exception
82: When hr_api.check_integrity_violated Then
83: -- A check constraint has been violated
84: hr_pap_shd.g_api_dml := false; -- Unset the api dml status

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

142: --
143: Cursor C_Sel1 is select hr_pattern_purposes_s.nextval from sys.dual;
144: --
145: Begin
146: hr_utility.set_location('Entering:'||l_proc, 5);
147: --
148: --
149: -- Select the next sequence number
150: --

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

151: Open C_Sel1;
152: Fetch C_Sel1 Into p_rec.pattern_purpose_id;
153: Close C_Sel1;
154: --
155: hr_utility.set_location(' Leaving:'||l_proc, 10);
156: End pre_insert;
157: --
158: -- ----------------------------------------------------------------------------
159: -- |-----------------------------< post_insert >------------------------------|

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

191: --
192: l_proc varchar2(72) := g_package||'post_insert';
193: --
194: Begin
195: hr_utility.set_location('Entering:'||l_proc, 5);
196: --
197: hr_utility.set_location(' Leaving:'||l_proc, 10);
198: End post_insert;
199: --

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

193: --
194: Begin
195: hr_utility.set_location('Entering:'||l_proc, 5);
196: --
197: hr_utility.set_location(' Leaving:'||l_proc, 10);
198: End post_insert;
199: --
200: -- ----------------------------------------------------------------------------
201: -- |---------------------------------< ins >----------------------------------|

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

208: --
209: l_proc varchar2(72) := g_package||'ins';
210: --
211: Begin
212: hr_utility.set_location('Entering:'||l_proc, 5);
213: --
214: -- Determine if the business process is to be validated.
215: --
216: If p_validate then

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

241: If p_validate then
242: Raise HR_Api.Validate_Enabled;
243: End If;
244: --
245: hr_utility.set_location(' Leaving:'||l_proc, 10);
246: Exception
247: When HR_Api.Validate_Enabled Then
248: --
249: -- As the Validate_Enabled exception has been raised

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

267: l_rec hr_pap_shd.g_rec_type;
268: l_proc varchar2(72) := g_package||'ins';
269: --
270: Begin
271: hr_utility.set_location('Entering:'||l_proc, 5);
272: --
273: -- Call conversion function to turn arguments into the
274: -- p_rec structure.
275: --

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

292: --
293: p_pattern_purpose_id := l_rec.pattern_purpose_id;
294: p_object_version_number := l_rec.object_version_number;
295: --
296: hr_utility.set_location(' Leaving:'||l_proc, 10);
297: End ins;
298: --
299: end hr_pap_ins;