DBA Data[Home] [Help]

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

296: --
297: p_pattern_id := l_rec.pattern_id;
298: p_object_version_number := l_rec.object_version_number;
299: --
300: hr_utility.set_location(' Leaving:'||l_proc, 10);
301: End ins;
302: --
303: end hr_pat_ins;