DBA Data[Home] [Help]

APPS.PAY_SE_HOLIDAY_PAY_DEBT dependencies on HR_UTILITY

Line 3: g_debug BOOLEAN := hr_utility.debug_enabled;

1: PACKAGE BODY pay_se_holiday_pay_debt AS
2: /* $Header: pysehpdr.pkb 120.0.12000000.1 2007/04/20 06:28:12 abhgangu noship $ */
3: g_debug BOOLEAN := hr_utility.debug_enabled;
4:
5: TYPE lock_rec IS RECORD (
6: archive_assact_id NUMBER
7: );

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

43:
44: BEGIN
45: --
46: IF g_debug THEN
47: hr_utility.set_location(' Entering Function GET_PARAMETER',10);
48: END IF;
49: l_start_pos := instr(' '||p_parameter_string,l_delimiter||p_token||'=');
50: --
51: IF l_start_pos = 0 THEN

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

69: END IF;
70: --
71: RETURN l_parameter;
72: IF g_debug THEN
73: hr_utility.set_location(' Leaving Function GET_PARAMETER',20);
74: END IF;
75: END;
76: */
77: /* GET PARAMETER */

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

89: BEGIN
90: --
91: IF g_debug
92: THEN
93: hr_utility.set_location (' Entering Function GET_PARAMETER', 10);
94: END IF;
95:
96: l_start_pos :=
97: INSTR (' ' || p_parameter_string, l_delimiter || p_token || '=');

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

132:
133: --
134: IF g_debug
135: THEN
136: hr_utility.set_location (' Leaving Function GET_PARAMETER', 20);
137: END IF;
138:
139: RETURN l_parameter;
140: END;

Line 257: hr_utility.set_location (' Leaving Procedure GET_ALL_PARAMETERS'

253: --fnd_file.put_line(fnd_file.log,'After p_local_unit_id in ' || p_local_unit_id );
254: --fnd_file.put_line(fnd_file.log,'After p_archive' || p_archive );
255: IF g_debug
256: THEN
257: hr_utility.set_location (' Leaving Procedure GET_ALL_PARAMETERS'
258: , 30);
259: END IF;
260: END get_all_parameters;
261:

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

343: fnd_file.put_line (fnd_file.LOG, 'In RANGE_CODE 0');
344:
345: IF g_debug
346: THEN
347: hr_utility.set_location (' Entering Procedure RANGE_CODE', 40);
348: END IF;
349:
350: p_sql :=
351: 'SELECT DISTINCT person_id

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

505:
506: --END IF; -- G_Archive End
507: IF g_debug
508: THEN
509: hr_utility.set_location (' Leaving Procedure RANGE_CODE', 50);
510: END IF;
511: EXCEPTION
512: WHEN OTHERS
513: THEN

Line 634: hr_utility.set_location

630: -- End of User pARAMETERS needed
631: BEGIN
632: IF g_debug
633: THEN
634: hr_utility.set_location
635: (' Entering Procedure ASSIGNMENT_ACTION_CODE'
636: , 60
637: );
638: END IF;

Line 716: hr_utility.set_location

712: );
713:
714: IF g_debug
715: THEN
716: hr_utility.set_location
717: (' Leaving Procedure ASSIGNMENT_ACTION_CODE'
718: , 70
719: );
720: END IF;

Line 726: hr_utility.set_location ('error raised assignment_action_code '

722: WHEN OTHERS
723: THEN
724: IF g_debug
725: THEN
726: hr_utility.set_location ('error raised assignment_action_code '
727: , 5
728: );
729: END IF;
730:

Line 752: hr_utility.set_location (' Entering Procedure INITIALIZATION_CODE'

748: l_prev_prepay NUMBER := 0;
749: BEGIN
750: IF g_debug
751: THEN
752: hr_utility.set_location (' Entering Procedure INITIALIZATION_CODE'
753: , 80
754: );
755: END IF;
756:

Line 777: hr_utility.set_location (' Leaving Procedure INITIALIZATION_CODE'

773: );
774:
775: IF g_debug
776: THEN
777: hr_utility.set_location (' Leaving Procedure INITIALIZATION_CODE'
778: , 90
779: );
780: END IF;
781: EXCEPTION

Line 788: hr_utility.set_location ( 'ORA_ERR: '

784: g_err_num := SQLCODE;
785:
786: IF g_debug
787: THEN
788: hr_utility.set_location ( 'ORA_ERR: '
789: || g_err_num
790: || 'In INITIALIZATION_CODE'
791: , 180
792: );

Line 815: hr_utility.set_location

811: l_defined_balance_id ff_user_entities.user_entity_id%TYPE;
812: BEGIN
813: IF g_debug
814: THEN
815: hr_utility.set_location
816: (' Entering Function GET_DEFINED_BALANCE_ID'
817: , 240
818: );
819: END IF;

Line 832: hr_utility.set_location (' Leaving Function GET_DEFINED_BALANCE_ID'

828: RETURN l_defined_balance_id;
829:
830: IF g_debug
831: THEN
832: hr_utility.set_location (' Leaving Function GET_DEFINED_BALANCE_ID'
833: , 250
834: );
835: END IF;
836: END get_defined_balance_id;

Line 863: hr_utility.set_location

859: l_return_balance_value NUMBER;
860: BEGIN
861: IF g_debug
862: THEN
863: hr_utility.set_location
864: (' Entering Function GET_DEFINED_BALANCE_VALUE'
865: , 240
866: );
867: END IF;

Line 892: hr_utility.set_location

888: RETURN l_return_balance_value;
889:
890: IF g_debug
891: THEN
892: hr_utility.set_location
893: (' Leaving Function GET_DEFINED_BALANCE_VALUE'
894: , 250
895: );
896: END IF;

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

1039: -- End of place for Cursor which fetches the values to be archived
1040: BEGIN
1041: IF g_debug
1042: THEN
1043: hr_utility.set_location (' Entering Procedure ARCHIVE_CODE', 380);
1044: END IF;
1045:
1046: fnd_file.put_line (fnd_file.LOG, 'Entering ARCHIVE_CODE ');
1047:

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

1395: fnd_file.put_line (fnd_file.LOG, 'Leaving Procedure ARCHIVE_CODE');
1396:
1397: IF g_debug
1398: THEN
1399: hr_utility.set_location (' Leaving Procedure ARCHIVE_CODE', 390);
1400: END IF;
1401: END archive_code;
1402:
1403: --- Report XML generating code

Line 1422: hr_utility.set_location ('Entering WritetoCLOB ', 70);

1418: current_index PLS_INTEGER;
1419: l_iana_charset VARCHAR2 (50);
1420: BEGIN
1421: l_iana_charset := hr_se_utility.get_iana_charset;
1422: hr_utility.set_location ('Entering WritetoCLOB ', 70);
1423: l_str1 :=
1424: ' 1425: || l_iana_charset
1426: || '"?> ';

Line 1527: hr_utility.set_location ('Leaving WritetoCLOB ', 40);

1523: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str7), l_str7);
1524: END IF;
1525:
1526: p_xfdf_clob := l_xfdf_string;
1527: hr_utility.set_location ('Leaving WritetoCLOB ', 40);
1528: EXCEPTION
1529: WHEN OTHERS
1530: THEN
1531: hr_utility.TRACE ('sqlerrm ' || SQLERRM);

Line 1531: hr_utility.TRACE ('sqlerrm ' || SQLERRM);

1527: hr_utility.set_location ('Leaving WritetoCLOB ', 40);
1528: EXCEPTION
1529: WHEN OTHERS
1530: THEN
1531: hr_utility.TRACE ('sqlerrm ' || SQLERRM);
1532: hr_utility.raise_error;
1533: END writetoclob;
1534:
1535: PROCEDURE get_xml_for_report (

Line 1532: hr_utility.raise_error;

1528: EXCEPTION
1529: WHEN OTHERS
1530: THEN
1531: hr_utility.TRACE ('sqlerrm ' || SQLERRM);
1532: hr_utility.raise_error;
1533: END writetoclob;
1534:
1535: PROCEDURE get_xml_for_report (
1536: p_business_group_id IN NUMBER