APPS.PAY_NO_SUPPORT_ORDER dependencies on HR_UTILITY

Line 3: g_debug boolean := hr_utility.debug_enabled;

1: PACKAGE BODY PAY_NO_SUPPORT_ORDER AS
2: /* $Header: pynosupord.pkb 120.5 2010/10/27 07:22:00 vijranga ship $ */
3: g_debug boolean := hr_utility.debug_enabled;
4:
5: ------------------------------------------------------------------------------------------------------
6: /* GET PARAMETER */
7: FUNCTION GET_PARAMETER(

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

14: l_delimiter VARCHAR2(1):=' ';
15:
16: BEGIN
17: IF g_debug THEN
18: hr_utility.set_location(' Entering Function GET_PARAMETER',10);
19: END IF;
20: l_start_pos := instr(' '||p_parameter_string,l_delimiter||p_token||'=');
21:
22: IF l_start_pos = 0 THEN

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

39: END IF;
40:
41: RETURN l_parameter;
42: IF g_debug THEN
43: hr_utility.set_location(' Leaving Function GET_PARAMETER',20);
44: END IF;
45:
46: END GET_PARAMETER;
47:

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

88: ,p_business_group_id;
89: CLOSE csr_parameter_info;
90:
91: IF g_debug THEN
92: hr_utility.set_location(' Leaving Procedure GET_ALL_PARAMETERS',30);
93: END IF;
94:
95: END GET_ALL_PARAMETERS;
96:

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

276:
277:
278: BEGIN
279: IF g_debug THEN
280: hr_utility.set_location(' Entering Procedure RANGE_CODE',40);
281: END IF;
282:
283: -- the sql string to return
284: sqlstr := 'SELECT DISTINCT person_id

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

452: END IF; -- l_archive = 'Y'
453:
454:
455: IF g_debug THEN
456: hr_utility.set_location(' Leaving Procedure RANGE_CODE',50);
457: END IF;
458:
459: END RANGE_CODE;
460:

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

464: IS
465:
466: BEGIN
467: IF g_debug THEN
468: hr_utility.set_location(' Entering Procedure INITIALIZATION_CODE',80);
469: END IF;
470:
471: NULL;
472:

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

470:
471: NULL;
472:
473: IF g_debug THEN
474: hr_utility.set_location(' Leaving Procedure INITIALIZATION_CODE',90);
475: END IF;
476: END INITIALIZATION_CODE;
477:
478: -------------------------------------------------------------------------------------------------------------------------

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

606: l_ele_type_id NUMBER;
607:
608: BEGIN
609: IF g_debug THEN
610: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',60);
611: END IF;
612:
613: -- fetch the data
614: PAY_NO_SUPPORT_ORDER.GET_ALL_PARAMETERS(

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

672:
673: END IF; -- l_archive = 'Y'
674:
675: IF g_debug THEN
676: hr_utility.set_location(' Leaving Procedure ASSIGNMENT_ACTION_CODE',70);
677: END IF;
678: END ASSIGNMENT_ACTION_CODE;
679:
680:

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

860:
861:
862: BEGIN
863: IF g_debug THEN
864: hr_utility.set_location(' Entering Procedure ARCHIVE_CODE',380);
865: END IF;
866:
867: SELECT payroll_action_id
868: INTO l_payroll_action_id

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

1013: END IF; -- l_archive = 'Y'
1014:
1015: --fnd_file.put_line(fnd_file.log,'SUGARG: leaving ARCHIVE_CODE');
1016: IF g_debug THEN
1017: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',390);
1018: END IF;
1019: END ARCHIVE_CODE;
1020:
1021: -------------------------------------------------------------------------------------------------------------------------

Line 1213: --hr_utility.trace('SUP_ORD: after FOR loop ');

1209: END IF ;
1210:
1211: END LOOP;
1212:
1213: --hr_utility.trace('SUP_ORD: after FOR loop ');
1214:
1215: IF (xml_tab(xml_ctr).xmlstring is null)
1216: THEN raise no_data_found;
1217: ELSE

Line 1294: hr_utility.trace('sqleerm ' || sqlerrm);

1290: --clob_to_blob(l_xfdf_string,p_xml);
1291:
1292: exception
1293: when others then
1294: hr_utility.trace('sqleerm ' || sqlerrm);
1295: hr_utility.raise_error;
1296:
1297: END write_to_clob;
1298:

Line 1295: hr_utility.raise_error;

1291:
1292: exception
1293: when others then
1294: hr_utility.trace('sqleerm ' || sqlerrm);
1295: hr_utility.raise_error;
1296:
1297: END write_to_clob;
1298:
1299: