DBA Data[Home] [Help]

APPS.PAY_LOADER_UTILS_PKG dependencies on HR_UTILITY

Line 34: hr_utility.set_location('Entering:'||l_proc, 5);

30: l_mode varchar2(10);
31: --
32: BEGIN
33: --
34: hr_utility.set_location('Entering:'||l_proc, 5);
35:
36: if p_business_group_id is not null and p_legislation_code is null then
37: l_mode := 'USER';
38: elsif p_business_group_id is null and p_legislation_code is not null then

Line 51: hr_utility.set_location(' Leaving:'||l_proc, 30);

47: hr_startup_data_api_support.delete_owner_definitions;
48: hr_startup_data_api_support.create_owner_definition('PAY');
49: end if;
50:
51: hr_utility.set_location(' Leaving:'||l_proc, 30);
52: --
53: END enable_startup_mode;
54: --
55: --

Line 74: hr_utility.set_location('Entering:'||l_proc, 5);

70: l_proc varchar2(72) := g_package||'init_fndload';
71: --
72: BEGIN
73: --
74: hr_utility.set_location('Entering:'||l_proc, 5);
75:
76: if p_owner = 'SEED' then
77: hr_general2.init_fndload
78: (p_resp_appl_id => 801

Line 88: hr_utility.set_location(' Leaving:'||l_proc, 30);

84: ,p_user_id => -1
85: );
86: end if;
87:
88: hr_utility.set_location(' Leaving:'||l_proc, 30);
89: --
90: END init_fndload;
91: --
92: --

Line 117: hr_utility.set_location('Entering:'||l_proc, 5);

113: --
114: BEGIN
115: --
116:
117: hr_utility.set_location('Entering:'||l_proc, 5);
118:
119: if p_business_group_name is not null then
120:
121: open csr_bg_id;

Line 127: hr_utility.set_location('Entering:'||l_proc, 5);

123: close csr_bg_id;
124:
125: end if;
126:
127: hr_utility.set_location('Entering:'||l_proc, 5);
128:
129: return l_business_group_id;
130: --
131: END get_business_group_id;

Line 162: hr_utility.set_location('Entering:'||l_proc, 5);

158: --
159: BEGIN
160: --
161:
162: hr_utility.set_location('Entering:'||l_proc, 5);
163:
164: if p_event_group_name is not null then
165:
166: open csr_evg_grp_id;

Line 172: hr_utility.set_location('Entering:'||l_proc, 5);

168: close csr_evg_grp_id;
169:
170: end if;
171:
172: hr_utility.set_location('Entering:'||l_proc, 5);
173:
174: return l_event_group_id;
175: --
176: END get_event_group_id;

Line 207: hr_utility.set_location('Entering:'||l_proc, 5);

203: --
204: BEGIN
205: --
206:
207: hr_utility.set_location('Entering:'||l_proc, 5);
208:
209: if p_element_set_name is not null then
210:
211: open csr_eset_id;

Line 217: hr_utility.set_location('Entering:'||l_proc, 5);

213: close csr_eset_id;
214:
215: end if;
216:
217: hr_utility.set_location('Entering:'||l_proc, 5);
218:
219: return l_element_set_id;
220: --
221: END get_element_set_id;

Line 253: hr_utility.set_location('Entering:'||l_proc, 5);

249: l_user_entity_id FF_USER_ENTITIES.USER_ENTITY_ID%TYPE;
250: --
251: BEGIN
252: --
253: hr_utility.set_location('Entering:'||l_proc, 5);
254:
255: if p_user_entity_name is not null then
256: open csr_user_entity_id;
257: fetch csr_user_entity_id into l_user_entity_id;

Line 261: hr_utility.set_location(' Leaving:'||l_proc, 30);

257: fetch csr_user_entity_id into l_user_entity_id;
258: close csr_user_entity_id;
259: end if;
260:
261: hr_utility.set_location(' Leaving:'||l_proc, 30);
262:
263: return l_user_entity_id;
264: --
265: END get_user_entity_id;

Line 301: hr_utility.set_location('Entering:'||l_proc, 5);

297: l_proc varchar2(72) := g_package||'get_formula_id';
298: --
299: BEGIN
300: --
301: hr_utility.set_location('Entering:'||l_proc, 5);
302:
303: if p_formula_type_name is not null and p_formula_name is not null then
304:
305: open csr_formula_id;

Line 324: hr_utility.set_location(' Leaving:'||l_proc, 30);

320: l_formula_id := -9999;
321:
322: end if;
323:
324: hr_utility.set_location(' Leaving:'||l_proc, 30);
325:
326: return l_formula_id;
327: --
328: END get_formula_id;

Line 406: hr_utility.set_location('Entering:'||l_proc, 5);

402: l_rfi_eed date;
403: --
404: BEGIN
405: --
406: hr_utility.set_location('Entering:'||l_proc, 5);
407:
408: open csr_rfi_exists ;
409: fetch csr_rfi_exists into l_rfi_esd, l_rfi_eed;
410:

Line 446: hr_utility.set_location(' Leaving:'||l_proc, 10);

442: ,p_effective_start_date => l_effective_start_date
443: ,p_effective_end_date => l_effective_end_date
444: );
445:
446: hr_utility.set_location(' Leaving:'||l_proc, 10);
447: --
448: END set_end_date;
449: --
450: BEGIN

Line 452: hr_utility.set_location('Entering:'||l_proc, 5);

448: END set_end_date;
449: --
450: BEGIN
451: --
452: hr_utility.set_location('Entering:'||l_proc, 5);
453:
454: -- Derive the Business Group Id from Name.
455:
456: l_business_group_id := get_business_group_id

Line 599: hr_utility.set_location(' Leaving:'||l_proc, 10);

595: end if;
596:
597: end if;
598:
599: hr_utility.set_location(' Leaving:'||l_proc, 10);
600: --
601: END load_rfm_row;
602: --
603: --

Line 628: hr_utility.set_location('Entering:'||l_proc, 5);

624: l_report_format_mapping_id PAY_REPORT_FORMAT_MAPPINGS_F.REPORT_FORMAT_MAPPING_ID%TYPE;
625: --
626: BEGIN
627: --
628: hr_utility.set_location('Entering:'||l_proc, 5);
629:
630: l_report_format_mapping_id :=
631: pay_rfm_shd.get_report_format_mapping_id
632: ( p_report_type => p_report_type

Line 641: hr_utility.set_location(' Leaving:'||l_proc, 30);

637: ( p_language_code => userenv('LANG')
638: ,p_report_format_mapping_id => l_report_format_mapping_id
639: ,p_display_name => p_display_name );
640:
641: hr_utility.set_location(' Leaving:'||l_proc, 30);
642: --
643: END translate_rfm_row;
644: --
645: --

Line 696: hr_utility.set_location('Entering:'||l_proc, 5);

692: l_effective_end_date date;
693: --
694: BEGIN
695: --
696: hr_utility.set_location('Entering:'||l_proc, 5);
697:
698: pay_rfi_del.del
699: ( p_effective_date => g_rfi_effective_end_date
700: ,p_datetrack_mode => 'DELETE'

Line 707: hr_utility.set_location(' Leaving:'||l_proc, 30);

703: ,p_effective_start_date => l_effective_start_date
704: ,p_effective_end_date => l_effective_end_date
705: );
706:
707: hr_utility.set_location(' Leaving:'||l_proc, 30);
708: --
709: END set_end_date;
710: --
711: BEGIN

Line 713: hr_utility.set_location('Entering:'||l_proc, 5);

709: END set_end_date;
710: --
711: BEGIN
712: --
713: hr_utility.set_location('Entering:'||l_proc, 5);
714:
715: l_user_entity_id := get_user_entity_id
716: ( p_user_entity_name => p_user_entity_name
717: ,p_legislation_code => p_legislation_code );

Line 825: hr_utility.set_location(' Leaving:'||l_proc, 30);

821: end if;
822:
823: end if;
824:
825: hr_utility.set_location(' Leaving:'||l_proc, 30);
826: --
827: END load_rfi_row;
828: --
829: --

Line 862: hr_utility.set_location('Entering:'||l_proc, 5);

858: --
859: BEGIN
860: --
861:
862: hr_utility.set_location('Entering:'||l_proc, 5);
863:
864: l_report_format_mapping_id :=
865: pay_rfm_shd.get_report_format_mapping_id
866: ( p_report_type => p_report_type

Line 900: hr_utility.set_location(' Leaving:'||l_proc, 30);

896: end if;
897:
898: close csr_exists;
899:
900: hr_utility.set_location(' Leaving:'||l_proc, 30);
901:
902: --
903: END load_rfp_row;
904: --

Line 936: hr_utility.set_location('Entering:'||l_proc, 5);

932:
933: --
934: BEGIN
935: --
936: hr_utility.set_location('Entering:'||l_proc, 5);
937:
938: l_magnetic_block_id :=
939: pay_mgb_shd.get_magnetic_block_id
940: ( p_block_name => p_block_name

Line 972: hr_utility.set_location(' Leaving:'||l_proc, 30);

968: end if;
969:
970: close csr_exists;
971:
972: hr_utility.set_location(' Leaving:'||l_proc, 30);
973:
974: --
975: END load_mgb_row;
976: --

Line 1022: hr_utility.set_location('Entering:'||l_proc, 5);

1018: --
1019: BEGIN
1020: --
1021:
1022: hr_utility.set_location('Entering:'||l_proc, 5);
1023:
1024: l_magnetic_block_id :=
1025: pay_mgb_shd.get_magnetic_block_id
1026: ( p_block_name => p_block_name

Line 1074: hr_utility.set_location(' Leaving:'||l_proc, 30);

1070: end if;
1071:
1072: close csr_exists;
1073:
1074: hr_utility.set_location(' Leaving:'||l_proc, 30);
1075:
1076: --
1077: END load_mgr_row;
1078: --

Line 1131: hr_utility.set_location('Entering:'||l_proc, 5);

1127: --
1128: BEGIN
1129: --
1130:
1131: hr_utility.set_location('Entering:'||l_proc, 5);
1132:
1133: l_business_group_id := get_business_group_id
1134: (p_business_group_name => p_egu_bus_grp_name);
1135:

Line 1182: hr_utility.set_location(' Leaving:'||l_proc, 30);

1178: end if;
1179:
1180: close csr_exists;
1181:
1182: hr_utility.set_location(' Leaving:'||l_proc, 30);
1183:
1184: --
1185: END load_egu_row;
1186: --

Line 1271: hr_utility.set_location('Entering:'||l_proc, 5);

1267: l_effective_end_date date;
1268: --
1269: BEGIN
1270: --
1271: hr_utility.set_location('Entering:'||l_proc, 5);
1272:
1273: enable_startup_mode
1274: ( p_business_group_id => g_ecu_old_rec.business_group_id
1275: ,p_legislation_code => g_ecu_old_rec.legislation_code );

Line 1284: hr_utility.set_location(' Leaving:'||l_proc, 10);

1280: ,p_element_class_usage_id => g_ecu_old_rec.element_class_usage_id
1281: ,p_object_version_number => g_ecu_old_rec.object_version_number
1282: ,p_effective_start_date => l_effective_start_date
1283: ,p_effective_end_date => l_effective_end_date);
1284: hr_utility.set_location(' Leaving:'||l_proc, 10);
1285: --
1286: END set_end_date;
1287: --
1288: BEGIN

Line 1290: hr_utility.set_location('Entering:'||l_proc, 5);

1286: END set_end_date;
1287: --
1288: BEGIN
1289: --
1290: hr_utility.set_location('Entering:'||l_proc, 5);
1291:
1292: -- Derive the Business Group Id from Name.
1293:
1294: l_business_group_id := NULL;

Line 1403: hr_utility.set_location(' Leaving:'||l_proc, 10);

1399: end if;
1400: g_usage_id := -1;
1401: end if;
1402:
1403: hr_utility.set_location(' Leaving:'||l_proc, 10);
1404: --
1405: END load_ecu_row;
1406: --
1407: END PAY_LOADER_UTILS_PKG;