DBA Data[Home] [Help]

APPS.PAY_DK_PR_ASG dependencies on HR_UTILITY

Line 4: g_debug boolean := hr_utility.debug_enabled;

1: PACKAGE BODY PAY_DK_PR_ASG AS
2: /* $Header: pydkprasg.pkb 120.12.12000000.2 2007/05/08 07:07:19 saurai noship $ */
3:
4: g_debug boolean := hr_utility.debug_enabled;
5: l_business_group_id NUMBER;
6: /* variables to store the input values*/
7: l_archive VARCHAR2(3);
8: l_from_date DATE;

Line 56: hr_utility.set_location(' Entering Function GET_PARAMETER',10);

52: l_delimiter VARCHAR2(1):=' ';
53:
54: BEGIN
55: IF g_debug THEN
56: hr_utility.set_location(' Entering Function GET_PARAMETER',10);
57: END IF;
58:
59: l_start_pos := instr(' '||p_parameter_string,l_delimiter||p_token||'=');
60:

Line 82: hr_utility.set_location(' Leaving Function GET_PARAMETER',20);

78: END IF;
79:
80: RETURN l_parameter;
81: IF g_debug THEN
82: hr_utility.set_location(' Leaving Function GET_PARAMETER',20);
83: END IF;
84:
85: END GET_PARAMETER;
86:

Line 119: hr_utility.set_location(' Leaving Procedure GET_ALL_PARAMETERS',30);

115: FETCH csr_parameter_info INTO p_payroll_id ,p_assignment_set_id,p_archive,
116: p_fromdate,p_todate,p_effective_date ,p_business_group_id;
117: CLOSE csr_parameter_info;
118: IF g_debug THEN
119: hr_utility.set_location(' Leaving Procedure GET_ALL_PARAMETERS',30);
120: END IF;
121:
122: END GET_ALL_PARAMETERS;
123:

Line 191: hr_utility.set_location(' Entering Procedure RANGE_CODE',40);

187: AND action_context_id = pactid;
188:
189: BEGIN
190: IF g_debug THEN
191: hr_utility.set_location(' Entering Procedure RANGE_CODE',40);
192: END IF;
193:
194:
195: -- the sql string to return

Line 285: hr_utility.set_location(' Leaving Procedure RANGE_CODE',50);

281:
282: END IF; -- l_archive = 'Y'
283:
284: IF g_debug THEN
285: hr_utility.set_location(' Leaving Procedure RANGE_CODE',50);
286: END IF;
287: END RANGE_CODE;
288:
289: -------------------------------------------------------------------------------------------------------------------------

Line 296: hr_utility.set_location(' Entering Procedure INITIALIZATION_CODE',80);

292: IS
293:
294: BEGIN
295: IF g_debug THEN
296: hr_utility.set_location(' Entering Procedure INITIALIZATION_CODE',80);
297: END IF;
298: NULL;
299: IF g_debug THEN
300: hr_utility.set_location(' Leaving Procedure INITIALIZATION_CODE',90);

Line 300: hr_utility.set_location(' Leaving Procedure INITIALIZATION_CODE',90);

296: hr_utility.set_location(' Entering Procedure INITIALIZATION_CODE',80);
297: END IF;
298: NULL;
299: IF g_debug THEN
300: hr_utility.set_location(' Leaving Procedure INITIALIZATION_CODE',90);
301: END IF;
302: exception when others then
303: g_err_num := SQLCODE;
304: IF g_debug THEN

Line 305: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In INITIALIZATION_CODE',180);

301: END IF;
302: exception when others then
303: g_err_num := SQLCODE;
304: IF g_debug THEN
305: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In INITIALIZATION_CODE',180);
306: END IF;
307:
308: END INITIALIZATION_CODE;
309:

Line 559: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',60);

555: ,l_from_date
556: ,l_to_date) ;
557:
558: IF g_debug THEN
559: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',60);
560: END IF;
561:
562: -- check if we have to archive again
563: IF (l_archive = 'Y') THEN

Line 680: hr_utility.set_location(' Leaving Procedure ASSIGNMENT_ACTION_CODE',70);

676: END IF;
677: END IF; -- l_archive = 'Y'
678:
679: IF g_debug THEN
680: hr_utility.set_location(' Leaving Procedure ASSIGNMENT_ACTION_CODE',70);
681: END IF;
682: END ASSIGNMENT_ACTION_CODE;
683:
684: ------------------------------------------------------------------------------------------------

Line 747: hr_utility.set_location(' Entering Procedure ARCHIVE_CODE',380);

743: rec_emp_details csr_emp_details%rowtype;
744:
745: BEGIN
746: IF g_debug THEN
747: hr_utility.set_location(' Entering Procedure ARCHIVE_CODE',380);
748: END IF;
749: BEGIN
750: SELECT payroll_action_id
751: INTO l_payroll_action_id

Line 788: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',390);

784:
785: END IF; -- l_archive = 'Y'
786:
787: IF g_debug THEN
788: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',390);
789: END IF;
790:
791: END ARCHIVE_CODE;
792: