DBA Data[Home] [Help]

APPS.PAY_NO_ARCHIVE_RSEA dependencies on HR_UTILITY

Line 4: g_debug boolean := hr_utility.debug_enabled;

1: PACKAGE BODY PAY_NO_ARCHIVE_RSEA AS
2: /* $Header: pynorsea.pkb 120.1 2010/10/27 07:23:34 vijranga ship $ */
3:
4: g_debug boolean := hr_utility.debug_enabled;
5: g_package VARCHAR2(33) := ' PAY_NO_ARCHIVE_RSEA.';
6: g_err_num NUMBER;
7: g_errm VARCHAR2(150);
8:

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

48: l_proc VARCHAR2(40):= g_package||' get parameter ';
49: BEGIN
50: --
51: IF g_debug THEN
52: hr_utility.set_location(' Entering Function GET_PARAMETER',10);
53: END IF;
54: l_start_pos := instr(' '||p_parameter_string,l_delimiter||p_token||'=');
55: --
56: IF l_start_pos = 0 THEN

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

74: END IF;
75: END IF;
76: --
77: IF g_debug THEN
78: hr_utility.set_location(' Leaving Function GET_PARAMETER',20);
79: END IF;
80:
81: RETURN l_parameter;
82:

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

120: ,p_business_group_id;
121: CLOSE csr_parameter_info;
122: --
123: IF g_debug THEN
124: hr_utility.set_location(' Leaving Procedure GET_ALL_PARAMETERS',30);
125: END IF;
126: END GET_ALL_PARAMETERS;
127:
128: /* RANGE CODE */

Line 555: hr_utility.set_location(' Entering Procedure RANGE_CODE',10);

551:
552: g_debug:=true;
553:
554: IF g_debug THEN
555: hr_utility.set_location(' Entering Procedure RANGE_CODE',10);
556: END IF;
557:
558: p_sql := 'SELECT DISTINCT person_id
559: FROM per_people_f ppf

Line 720: hr_utility.set_location(' Inside Procedure RANGE_CODE',20);

716: ,p_action_information29 => null
717: ,p_action_information30 => null );
718:
719: IF g_debug THEN
720: hr_utility.set_location(' Inside Procedure RANGE_CODE',20);
721: END IF;
722:
723:
724:

Line 768: hr_utility.set_location(' Inside Procedure RANGE_CODE',30);

764: ,p_action_information29 => null
765: ,p_action_information30 => null );
766:
767: IF g_debug THEN
768: hr_utility.set_location(' Inside Procedure RANGE_CODE',30);
769: END IF;
770:
771:
772: /* Inserting municipal codes for the Legal Employer in a PL/SQL table */

Line 893: hr_utility.set_location(' Inside Procedure RANGE_CODE',40);

889:
890: END IF ;
891:
892: IF g_debug THEN
893: hr_utility.set_location(' Inside Procedure RANGE_CODE',40);
894: END IF;
895:
896:
897:

Line 904: hr_utility.set_location(' Inside Procedure RANGE_CODE',50);

900: pay_balance_pkg.set_context('JURISDICTION_CODE',l_municipal_no);
901: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(l_reporting_end_date));
902:
903: IF g_debug THEN
904: hr_utility.set_location(' Inside Procedure RANGE_CODE',50);
905: END IF;
906:
907:
908: FOR i IN 1 .. l_counter LOOP

Line 1107: hr_utility.set_location(' Inside Procedure RANGE_CODE',60);

1103: ,p_action_information29 => null
1104: ,p_action_information30 => null );
1105:
1106: IF g_debug THEN
1107: hr_utility.set_location(' Inside Procedure RANGE_CODE',60);
1108: END IF;
1109:
1110:
1111: l_municipal_no:=NULL;

Line 1125: hr_utility.set_location(' Leaving Procedure RANGE_CODE',70);

1121:
1122: END IF;
1123:
1124: IF g_debug THEN
1125: hr_utility.set_location(' Leaving Procedure RANGE_CODE',70);
1126: END IF;
1127:
1128: EXCEPTION
1129: WHEN OTHERS THEN

Line 1145: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',80);

1141: ,p_chunk IN NUMBER)
1142: IS
1143: BEGIN
1144: IF g_debug THEN
1145: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',80);
1146: END IF;
1147:
1148: IF g_debug THEN
1149: hr_utility.set_location(' Leaving Procedure ASSIGNMENT_ACTION_CODE',90);

Line 1149: hr_utility.set_location(' Leaving Procedure ASSIGNMENT_ACTION_CODE',90);

1145: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',80);
1146: END IF;
1147:
1148: IF g_debug THEN
1149: hr_utility.set_location(' Leaving Procedure ASSIGNMENT_ACTION_CODE',90);
1150: END IF;
1151:
1152:
1153: END ASSIGNMENT_ACTION_CODE;

Line 1162: hr_utility.set_location(' Entering Procedure INITIALIZATION_CODE',100);

1158: IS
1159:
1160: BEGIN
1161: IF g_debug THEN
1162: hr_utility.set_location(' Entering Procedure INITIALIZATION_CODE',100);
1163: END IF;
1164:
1165:
1166: IF g_debug THEN

Line 1167: hr_utility.set_location(' Leaving Procedure INITIALIZATION_CODE',110);

1163: END IF;
1164:
1165:
1166: IF g_debug THEN
1167: hr_utility.set_location(' Leaving Procedure INITIALIZATION_CODE',110);
1168: END IF;
1169:
1170: EXCEPTION WHEN OTHERS THEN
1171: g_err_num := SQLCODE;

Line 1173: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In INITIALIZATION_CODE',120);

1169:
1170: EXCEPTION WHEN OTHERS THEN
1171: g_err_num := SQLCODE;
1172: IF g_debug THEN
1173: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In INITIALIZATION_CODE',120);
1174: END IF;
1175: END INITIALIZATION_CODE;
1176:
1177: /* ARCHIVE CODE */

Line 1184: hr_utility.set_location(' Entering Procedure ARCHIVE_CODE',130);

1180: IS
1181:
1182: BEGIN
1183: IF g_debug THEN
1184: hr_utility.set_location(' Entering Procedure ARCHIVE_CODE',130);
1185: END IF;
1186:
1187: IF g_debug THEN
1188: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',140);

Line 1188: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',140);

1184: hr_utility.set_location(' Entering Procedure ARCHIVE_CODE',130);
1185: END IF;
1186:
1187: IF g_debug THEN
1188: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',140);
1189: END IF;
1190:
1191: END ARCHIVE_CODE;
1192: END PAY_NO_ARCHIVE_RSEA;