DBA Data[Home] [Help]

APPS.PAY_FI_ARCHIVE_TEL dependencies on HR_UTILITY

Line 4: g_debug boolean := hr_utility.debug_enabled;

1: PACKAGE BODY PAY_FI_ARCHIVE_TEL AS
2: /* $Header: pyfitela.pkb 120.16.12000000.3 2007/03/20 06:54:37 dbehera noship $ */
3:
4: g_debug boolean := hr_utility.debug_enabled;
5:
6: TYPE lock_rec IS RECORD (
7: archive_assact_id NUMBER);
8:

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

61:
62: BEGIN
63: --
64: IF g_debug THEN
65: hr_utility.set_location(' Entering Function GET_PARAMETER',10);
66: END IF;
67: l_start_pos := instr(' '||p_parameter_string,l_delimiter||p_token||'=');
68: --
69: IF l_start_pos = 0 THEN

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

87: END IF;
88: --
89: RETURN l_parameter;
90: IF g_debug THEN
91: hr_utility.set_location(' Leaving Function GET_PARAMETER',20);
92: END IF;
93: END;
94: /* GET ALL PARAMETERS */
95: PROCEDURE GET_ALL_PARAMETERS(

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

143: fnd_file.put_line(fnd_file.log,'After p_local_unit_id in ' || p_local_unit_id );
144: fnd_file.put_line(fnd_file.log,'After p_archive' || p_archive );
145:
146: IF g_debug THEN
147: hr_utility.set_location(' Leaving Procedure GET_ALL_PARAMETERS',30);
148: END IF;
149: END GET_ALL_PARAMETERS;
150:
151:

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

321:
322: fnd_file.put_line(fnd_file.log,'In RANGE_CODE 0');
323:
324: IF g_debug THEN
325: hr_utility.set_location(' Entering Procedure RANGE_CODE',40);
326: END IF;
327:
328: p_sql := 'SELECT DISTINCT person_id
329: FROM per_people_f ppf

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

613:
614: END IF; -- G_Archive End
615:
616: IF g_debug THEN
617: hr_utility.set_location(' Leaving Procedure RANGE_CODE',50);
618: END IF;
619: EXCEPTION
620: WHEN OTHERS
621: THEN

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

773: -- End of User pARAMETERS needed
774:
775: BEGIN
776: IF g_debug THEN
777: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',60);
778: END IF;
779: fnd_file.put_line(fnd_file.log,' ASSIGNMENT_ACTION_CODE ');
780:
781: PAY_FI_ARCHIVE_TEL.GET_ALL_PARAMETERS

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

887: END IF;
888: fnd_file.put_line(fnd_file.log,' After Ending Assignment Act Code the Locking Cursor ');
889:
890: IF g_debug THEN
891: hr_utility.set_location(' Leaving Procedure ASSIGNMENT_ACTION_CODE',70);
892: END IF;
893: EXCEPTION
894: WHEN others THEN
895: IF g_debug THEN

Line 896: hr_utility.set_location('error raised assignment_action_code ',5);

892: END IF;
893: EXCEPTION
894: WHEN others THEN
895: IF g_debug THEN
896: hr_utility.set_location('error raised assignment_action_code ',5);
897: END if;
898: RAISE;
899:
900: END ASSIGNMENT_ACTION_CODE;

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

915: l_prev_prepay NUMBER := 0;
916:
917: BEGIN
918: IF g_debug THEN
919: hr_utility.set_location(' Entering Procedure INITIALIZATION_CODE',80);
920: END IF;
921: fnd_file.put_line(fnd_file.log,'In INIT_CODE 0');
922:
923: g_payroll_action_id :=p_payroll_action_id;

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

944:
945: fnd_file.put_line(fnd_file.log,'In the INITIALIZATION_CODE After Initiliazing the global parameter ' );
946:
947: IF g_debug THEN
948: hr_utility.set_location(' Leaving Procedure INITIALIZATION_CODE',90);
949: END IF;
950: EXCEPTION
951: WHEN OTHERS
952: THEN

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

951: WHEN OTHERS
952: THEN
953: g_err_num := SQLCODE;
954: IF g_debug THEN
955: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In INITIALIZATION_CODE',180);
956: END IF;
957: END INITIALIZATION_CODE;
958:
959:

Line 978: hr_utility.set_location(' Entering Function GET_DEFINED_BALANCE_ID',240);

974:
975: l_defined_balance_id ff_user_entities.user_entity_id%TYPE;
976: BEGIN
977: IF g_debug THEN
978: hr_utility.set_location(' Entering Function GET_DEFINED_BALANCE_ID',240);
979: END IF;
980: OPEN csr_def_bal_id(p_user_name);
981: FETCH csr_def_bal_id
982: INTO l_defined_balance_id;

Line 986: hr_utility.set_location(' Leaving Function GET_DEFINED_BALANCE_ID',250);

982: INTO l_defined_balance_id;
983: CLOSE csr_def_bal_id;
984: RETURN l_defined_balance_id;
985: IF g_debug THEN
986: hr_utility.set_location(' Leaving Function GET_DEFINED_BALANCE_ID',250);
987: END IF;
988: END GET_DEFINED_BALANCE_ID;
989:
990:

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

1290: -- End of place for Cursor which fetches the values to be archived
1291:
1292: BEGIN
1293: IF g_debug THEN
1294: hr_utility.set_location(' Entering Procedure ARCHIVE_CODE',380);
1295: END IF;
1296:
1297: fnd_file.put_line(fnd_file.log,'Entering ARCHIVE_CODE ' );
1298: IF g_archive ='Y'

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

2133: END;
2134: END IF;
2135: fnd_file.put_line(fnd_file.log,'Leaving Procedure ARCHIVE_CODE');
2136: IF g_debug THEN
2137: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',390);
2138: END IF;
2139:
2140: END ARCHIVE_CODE;
2141: END PAY_FI_ARCHIVE_TEL;