DBA Data[Home] [Help]

APPS.PQH_WPR_INS dependencies on HR_UTILITY

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

48: --
49: l_proc varchar2(72) := g_package||'insert_dml';
50: --
51: Begin
52: hr_utility.set_location('Entering:'||l_proc, 5);
53: p_rec.object_version_number := 1; -- Initialise the object version
54: --
55: --
56: -- Insert the row into: pqh_worksheet_periods

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

94: p_rec.budget_unit1_available
95: );
96: --
97: --
98: hr_utility.set_location(' Leaving:'||l_proc, 10);
99: Exception
100: When hr_api.check_integrity_violated Then
101: -- A check constraint has been violated
102: pqh_wpr_shd.constraint_error

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

156: --
157: Cursor C_Sel1 is select pqh_worksheet_periods_s.nextval from sys.dual;
158: --
159: Begin
160: hr_utility.set_location('Entering:'||l_proc, 5);
161: --
162: --
163: -- Select the next sequence number
164: --

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

165: Open C_Sel1;
166: Fetch C_Sel1 Into p_rec.worksheet_period_id;
167: Close C_Sel1;
168: --
169: hr_utility.set_location(' Leaving:'||l_proc, 10);
170: End pre_insert;
171: --
172: -- ----------------------------------------------------------------------------
173: -- |-----------------------------< post_insert >------------------------------|

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

206: --
207: l_proc varchar2(72) := g_package||'post_insert';
208: --
209: Begin
210: hr_utility.set_location('Entering:'||l_proc, 5);
211: --
212: --
213: -- Start of API User Hook for post_insert.
214: --

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

248: --
249: -- End of API User Hook for post_insert.
250: --
251: --
252: hr_utility.set_location(' Leaving:'||l_proc, 10);
253: End post_insert;
254: --
255: -- ----------------------------------------------------------------------------
256: -- |---------------------------------< ins >----------------------------------|

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

263: --
264: l_proc varchar2(72) := g_package||'ins';
265: --
266: Begin
267: hr_utility.set_location('Entering:'||l_proc, 5);
268: --
269: -- Call the supporting insert validate operations
270: --
271: pqh_wpr_bus.insert_validate(p_rec

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

313: l_rec pqh_wpr_shd.g_rec_type;
314: l_proc varchar2(72) := g_package||'ins';
315: --
316: Begin
317: hr_utility.set_location('Entering:'||l_proc, 5);
318: --
319: -- Call conversion function to turn arguments into the
320: -- p_rec structure.
321: --

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

352: --
353: p_worksheet_period_id := l_rec.worksheet_period_id;
354: p_object_version_number := l_rec.object_version_number;
355: --
356: hr_utility.set_location(' Leaving:'||l_proc, 10);
357: End ins;
358: --
359: end pqh_wpr_ins;