DBA Data[Home] [Help]

APPS.PAY_GB_COURT_ORDER_UPGRADE dependencies on HR_UTILITY

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

26: l_context_id NUMBER;
27:
28: BEGIN
29:
30: hr_utility.set_location('Entering: ' || l_proc, 10);
31:
32: OPEN csr_context(p_context_name);
33: FETCH csr_context INTO l_context_id;
34: CLOSE csr_context;

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

32: OPEN csr_context(p_context_name);
33: FETCH csr_context INTO l_context_id;
34: CLOSE csr_context;
35:
36: hr_utility.set_location('Leaving: ' || l_proc, 20);
37:
38: RETURN l_context_id;
39:
40: END get_context_id;

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

91: l_context_value VARCHAR2(100) := '-1';
92: --
93: BEGIN
94: --
95: hr_utility.set_location('Entering: ' || l_proc, 10);
96:
97: -- Get ID for the context
98:
99: l_context_id := get_context_id('SOURCE_TEXT');

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

165: --
166: CLOSE csr_results;
167: COMMIT;
168: --
169: hr_utility.set_location('Leaving: ' || l_proc, 20);
170: --
171: END upgrade_action_contexts;
172: --
173: --

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

338: retcode := 0;
339: l_overpaid_flag := 'N';
340: l_no_data_found := 'Y';
341:
342: hr_utility.set_location('Entering: ' || l_proc, 10);
343:
344:
345: -- Correct the action contexts.
346: upgrade_action_contexts(p_bg_id);

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

353: OPEN csr_date;
354: FETCH csr_date into l_date;
355: CLOSE csr_date;
356:
357: hr_utility.set_location('Leaving: ' || l_proc, 20);
358: fnd_file.put_line(FND_FILE.OUTPUT,'------------------------------------------------------------------------------------------------------------------------------------');
359: fnd_file.put_line(FND_FILE.OUTPUT,' Court order details for employees in : '||rpad(l_business_group_name,30));
360: fnd_file.put_line(FND_FILE.OUTPUT,' report date : '|| l_date);
361: fnd_file.put_line(FND_FILE.OUTPUT,'------------------------------------------------------------------------------------------------------------------------------------');