DBA Data[Home] [Help]

APPS.PAY_RECORDED_REQUESTS_PKG dependencies on HR_UTILITY

Line 57: --hr_utility.set_location('Entering:'||l_proc, 10);

53: as
54: l_proc varchar2(72) := g_package||'insert_recorded_request';
55: --
56: BEGIN
57: --hr_utility.set_location('Entering:'||l_proc, 10);
58: --
59: -- Validate against hr_lookups,
60: -- to check request/process has been set up to use mechanism.
61: --

Line 68: hr_utility.set_location(' Leaving:'||l_proc, 20);

64: ,p_lookup_type => 'PAY_RECORDED_REQUESTS'
65: ,p_lookup_code => p_process
66: )
67: then
68: hr_utility.set_location(' Leaving:'||l_proc, 20);
69: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
70: fnd_message.set_token('LOOKUP_TYPE', 'PAY_RECORDED_REQUESTS');
71: fnd_message.set_token('VALUE', p_process);
72: fnd_message.raise_error;

Line 121: --hr_utility.set_location(' Leaving:'||l_proc, 900);

117: p_attribute17,
118: p_attribute18,
119: p_attribute19,
120: p_attribute20 );
121: --hr_utility.set_location(' Leaving:'||l_proc, 900);
122:
123: END insert_recorded_request;
124:
125: -- ----------------------------------------------------------------------------

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

200: l_recorded_date DATE;
201: l_proc varchar2(72) := g_package||'get_recorded_date';
202: --
203: BEGIN
204: --hr_utility.set_location('Entering:'||l_proc, 10);
205:
206: --See if we've already got an appropriate row
207: open csr_process_run;
208: fetch csr_process_run into l_recorded_date;

Line 240: --hr_utility.set_location('Leaving:'||l_proc, 900);

236:
237: close csr_process_run;
238:
239: p_recorded_date := l_recorded_date;
240: --hr_utility.set_location('Leaving:'||l_proc, 900);
241:
242: END get_recorded_date;
243:
244: -- Variation of above procedure

Line 305: --hr_utility.set_location('Entering:'||l_proc, 10);

301: l_recorded_date DATE;
302: l_proc varchar2(72) := g_package||'get_recorded_date_no_ins';
303: --
304: BEGIN
305: --hr_utility.set_location('Entering:'||l_proc, 10);
306:
307: --See if we've already got an appropriate row
308: open csr_process_run;
309: fetch csr_process_run into l_recorded_date;

Line 319: --hr_utility.set_location('Leaving:'||l_proc, 900);

315:
316: close csr_process_run;
317:
318: p_recorded_date := l_recorded_date;
319: --hr_utility.set_location('Leaving:'||l_proc, 900);
320:
321: END get_recorded_date_no_ins;
322:
323: -- ----------------------------------------------------------------------------

Line 403: --hr_utility.set_location('Entering:'||l_proc, 10);

399: l_recorded_date DATE;
400: l_proc varchar2(72) := g_package||'set_recorded_date';
401: --
402: BEGIN
403: --hr_utility.set_location('Entering:'||l_proc, 10);
404:
405: --Get existing row
406: open csr_process_run;
407: fetch csr_process_run into l_recorded_date;

Line 467: --hr_utility.set_location('Leaving:'||l_proc, 900);

463:
464: END IF;
465:
466: close csr_process_run;
467: --hr_utility.set_location('Leaving:'||l_proc, 900);
468:
469: END set_recorded_date;
470:
471: