eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_HR_OTC_RETRIEVAL_INTERFACE dependencies on HR_UTILITY

Line 86: hr_utility.set_location ( ' l_lookup_meaning = '

82: INTO l_lookup_meaning;
83:
84: CLOSE csr_valid_lookup;
85:
86: hr_utility.set_location ( ' l_lookup_meaning = '
87: || l_lookup_meaning,
88: 10
89: );
90: RETURN l_lookup_meaning;

Line 105: hr_utility.set_location ( ' l_valueset_meaning = '

101: l_valueset_meaning :=
102: pay_input_values_pkg.decode_vset_value (p_value_set_id,
103: p_valueset_value
104: );
105: hr_utility.set_location ( ' l_valueset_meaning = '
106: || l_valueset_meaning,
107: 10
108: );
109: RETURN l_valueset_meaning;

Line 112: hr_utility.set_location ('Entering: ' || l_proc, 10);

108: );
109: RETURN l_valueset_meaning;
110: END valueset_meaning;
111: BEGIN
112: hr_utility.set_location ('Entering: ' || l_proc, 10);
113: l_display_value := p_internal_input_value;
114:
115: IF (p_internal_input_value IS NOT NULL)
116: THEN

Line 117: hr_utility.set_location

113: l_display_value := p_internal_input_value;
114:
115: IF (p_internal_input_value IS NOT NULL)
116: THEN
117: hr_utility.set_location
118: ( ' Converting p_internal_input_value = '
119: || p_internal_input_value,
120: 20
121: );

Line 122: hr_utility.set_location (' using: ', 30);

118: ( ' Converting p_internal_input_value = '
119: || p_internal_input_value,
120: 20
121: );
122: hr_utility.set_location (' using: ', 30);
123: hr_utility.set_location ( ' p_element_type_id = '
124: || p_element_type_id,
125: 40
126: );

Line 123: hr_utility.set_location ( ' p_element_type_id = '

119: || p_internal_input_value,
120: 20
121: );
122: hr_utility.set_location (' using: ', 30);
123: hr_utility.set_location ( ' p_element_type_id = '
124: || p_element_type_id,
125: 40
126: );
127: hr_utility.set_location (' p_iv_number = ' || p_iv_number,

Line 127: hr_utility.set_location (' p_iv_number = ' || p_iv_number,

123: hr_utility.set_location ( ' p_element_type_id = '
124: || p_element_type_id,
125: 40
126: );
127: hr_utility.set_location (' p_iv_number = ' || p_iv_number,
128: 50
129: );
130: hr_utility.set_location ( ' p_session_date = '
131: || p_session_date,

Line 130: hr_utility.set_location ( ' p_session_date = '

126: );
127: hr_utility.set_location (' p_iv_number = ' || p_iv_number,
128: 50
129: );
130: hr_utility.set_location ( ' p_session_date = '
131: || p_session_date,
132: 60
133: );
134: hr_utility.set_location (' p_bg_id = ' || p_bg_id,

Line 134: hr_utility.set_location (' p_bg_id = ' || p_bg_id,

130: hr_utility.set_location ( ' p_session_date = '
131: || p_session_date,
132: 60
133: );
134: hr_utility.set_location (' p_bg_id = ' || p_bg_id,
135: 70);
136:
137: OPEN csr_iv_info (p_element_type_id, p_iv_number, p_session_date);
138:

Line 167: hr_utility.set_location ( ' returning l_display_value = '

163: END IF;
164: END IF;
165: END IF;
166:
167: hr_utility.set_location ( ' returning l_display_value = '
168: || l_display_value,
169: 90
170: );
171: hr_utility.set_location ('Leaving: ' || l_proc, 100);

Line 171: hr_utility.set_location ('Leaving: ' || l_proc, 100);

167: hr_utility.set_location ( ' returning l_display_value = '
168: || l_display_value,
169: 90
170: );
171: hr_utility.set_location ('Leaving: ' || l_proc, 100);
172: RETURN l_display_value;
173: EXCEPTION
174: WHEN OTHERS
175: THEN

Line 176: hr_utility.set_message ('PAY', 'PAY_6306_INPUT_VALUE_FORMAT');

172: RETURN l_display_value;
173: EXCEPTION
174: WHEN OTHERS
175: THEN
176: hr_utility.set_message ('PAY', 'PAY_6306_INPUT_VALUE_FORMAT');
177: hr_utility.set_message_token
178: ('UNIT_OF_MEASURE',
179: hr_general.decode_lookup ('UNITS',
180: rec_iv_info.uom

Line 177: hr_utility.set_message_token

173: EXCEPTION
174: WHEN OTHERS
175: THEN
176: hr_utility.set_message ('PAY', 'PAY_6306_INPUT_VALUE_FORMAT');
177: hr_utility.set_message_token
178: ('UNIT_OF_MEASURE',
179: hr_general.decode_lookup ('UNITS',
180: rec_iv_info.uom
181: )

Line 183: hr_utility.raise_error;

179: hr_general.decode_lookup ('UNITS',
180: rec_iv_info.uom
181: )
182: );
183: hr_utility.raise_error;
184: END display_value;
185:
186: FUNCTION retro_batch_suffix
187: RETURN VARCHAR2

Line 191: hr_utility.set_location ('Entering:' || l_proc, 10);

187: RETURN VARCHAR2
188: IS
189: l_proc CONSTANT proc_name := g_package || 'retro_batch_suffix';
190: BEGIN
191: hr_utility.set_location ('Entering:' || l_proc, 10);
192: hr_utility.set_location ( ' returning g_retro_batch_suffix = '
193: || g_retro_batch_suffix,
194: 20
195: );

Line 192: hr_utility.set_location ( ' returning g_retro_batch_suffix = '

188: IS
189: l_proc CONSTANT proc_name := g_package || 'retro_batch_suffix';
190: BEGIN
191: hr_utility.set_location ('Entering:' || l_proc, 10);
192: hr_utility.set_location ( ' returning g_retro_batch_suffix = '
193: || g_retro_batch_suffix,
194: 20
195: );
196: hr_utility.set_location ('Leaving:' || l_proc, 100);

Line 196: hr_utility.set_location ('Leaving:' || l_proc, 100);

192: hr_utility.set_location ( ' returning g_retro_batch_suffix = '
193: || g_retro_batch_suffix,
194: 20
195: );
196: hr_utility.set_location ('Leaving:' || l_proc, 100);
197: RETURN g_retro_batch_suffix;
198: END retro_batch_suffix;
199:
200: PROCEDURE set_retro_batch_suffix (p_retro_batch_suffix IN VARCHAR2)

Line 204: hr_utility.set_location ('Entering:' || l_proc, 10);

200: PROCEDURE set_retro_batch_suffix (p_retro_batch_suffix IN VARCHAR2)
201: IS
202: l_proc CONSTANT proc_name := g_package || 'set_retro_batch_suffix';
203: BEGIN
204: hr_utility.set_location ('Entering:' || l_proc, 10);
205: hr_utility.set_location ( ' setting g_retro_batch_suffix to '
206: || p_retro_batch_suffix,
207: 20
208: );

Line 205: hr_utility.set_location ( ' setting g_retro_batch_suffix to '

201: IS
202: l_proc CONSTANT proc_name := g_package || 'set_retro_batch_suffix';
203: BEGIN
204: hr_utility.set_location ('Entering:' || l_proc, 10);
205: hr_utility.set_location ( ' setting g_retro_batch_suffix to '
206: || p_retro_batch_suffix,
207: 20
208: );
209: g_retro_batch_suffix := p_retro_batch_suffix;

Line 210: hr_utility.set_location ('Leaving:' || l_proc, 100);

206: || p_retro_batch_suffix,
207: 20
208: );
209: g_retro_batch_suffix := p_retro_batch_suffix;
210: hr_utility.set_location ('Leaving:' || l_proc, 100);
211: END set_retro_batch_suffix;
212:
213: PROCEDURE record_batch_info (p_batch_rec IN batches_type_rec)
214: IS

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

213: PROCEDURE record_batch_info (p_batch_rec IN batches_type_rec)
214: IS
215: l_proc CONSTANT proc_name := g_package || 'record_batch_info';
216: BEGIN
217: hr_utility.set_location ('Entering:' || l_proc, 10);
218: g_batches_created (NVL (g_batches_created.LAST, 0) + 1) := p_batch_rec;
219: hr_utility.set_location ('Leaving:' || l_proc, 100);
220: END record_batch_info;
221:

Line 219: hr_utility.set_location ('Leaving:' || l_proc, 100);

215: l_proc CONSTANT proc_name := g_package || 'record_batch_info';
216: BEGIN
217: hr_utility.set_location ('Entering:' || l_proc, 10);
218: g_batches_created (NVL (g_batches_created.LAST, 0) + 1) := p_batch_rec;
219: hr_utility.set_location ('Leaving:' || l_proc, 100);
220: END record_batch_info;
221:
222: PROCEDURE record_batch_info (
223: p_batch_id IN pay_batch_headers.batch_id%TYPE,

Line 233: hr_utility.set_location ('Entering:' || l_proc, 10);

229: l_proc CONSTANT proc_name
230: := g_package || 'record_batch_info (Overloaded)';
231: l_batch_created batches_type_rec;
232: BEGIN
233: hr_utility.set_location ('Entering:' || l_proc, 10);
234: l_batch_created.batch_id := p_batch_id;
235: l_batch_created.business_group_id := p_business_group_id;
236: l_batch_created.batch_reference := p_batch_reference;
237: l_batch_created.batch_name := p_batch_name;

Line 239: hr_utility.set_location ('Leaving:' || l_proc, 100);

235: l_batch_created.business_group_id := p_business_group_id;
236: l_batch_created.batch_reference := p_batch_reference;
237: l_batch_created.batch_name := p_batch_name;
238: record_batch_info (p_batch_rec => l_batch_created);
239: hr_utility.set_location ('Leaving:' || l_proc, 100);
240: END record_batch_info;
241:
242: FUNCTION batches_created
243: RETURN batches_type_table

Line 247: hr_utility.set_location ('Entering:' || l_proc, 10);

243: RETURN batches_type_table
244: IS
245: l_proc CONSTANT proc_name := g_package || 'batches_created';
246: BEGIN
247: hr_utility.set_location ('Entering:' || l_proc, 10);
248: hr_utility.set_location ( ' g_batches_created.count = '
249: || g_batches_created.COUNT,
250: 20
251: );

Line 248: hr_utility.set_location ( ' g_batches_created.count = '

244: IS
245: l_proc CONSTANT proc_name := g_package || 'batches_created';
246: BEGIN
247: hr_utility.set_location ('Entering:' || l_proc, 10);
248: hr_utility.set_location ( ' g_batches_created.count = '
249: || g_batches_created.COUNT,
250: 20
251: );
252: hr_utility.set_location ('Leaving:' || l_proc, 100);

Line 252: hr_utility.set_location ('Leaving:' || l_proc, 100);

248: hr_utility.set_location ( ' g_batches_created.count = '
249: || g_batches_created.COUNT,
250: 20
251: );
252: hr_utility.set_location ('Leaving:' || l_proc, 100);
253: RETURN g_batches_created;
254: END batches_created;
255:
256: PROCEDURE start_bee_process (

Line 265: hr_utility.set_location ('Entering:' || l_proc, 10);

261: l_proc CONSTANT proc_name := g_package || 'start_bee_process';
262: l_batches_idx PLS_INTEGER := p_batches.FIRST;
263: l_request_id fnd_concurrent_requests.request_id%TYPE;
264: BEGIN
265: hr_utility.set_location ('Entering:' || l_proc, 10);
266:
267: <>
268: LOOP
269: EXIT start_conc_prog_for_batches WHEN NOT p_batches.EXISTS

Line 280: hr_utility.set_location ('Leaving:' || l_proc, 100);

276: );
277: l_batches_idx := p_batches.NEXT (l_batches_idx);
278: END LOOP start_conc_prog_for_batches;
279:
280: hr_utility.set_location ('Leaving:' || l_proc, 100);
281: END start_bee_process;
282:
283: PROCEDURE validate_bee_batches (p_batches IN batches_type_table)
284: IS

Line 287: hr_utility.set_location ('Entering:' || l_proc, 10);

283: PROCEDURE validate_bee_batches (p_batches IN batches_type_table)
284: IS
285: l_proc CONSTANT proc_name := g_package || 'validate_bee_batches';
286: BEGIN
287: hr_utility.set_location ('Entering:' || l_proc, 10);
288: start_bee_process (p_mode => 'VALIDATE', p_batches => p_batches);
289: hr_utility.set_location ('Leaving:' || l_proc, 100);
290: END validate_bee_batches;
291:

Line 289: hr_utility.set_location ('Leaving:' || l_proc, 100);

285: l_proc CONSTANT proc_name := g_package || 'validate_bee_batches';
286: BEGIN
287: hr_utility.set_location ('Entering:' || l_proc, 10);
288: start_bee_process (p_mode => 'VALIDATE', p_batches => p_batches);
289: hr_utility.set_location ('Leaving:' || l_proc, 100);
290: END validate_bee_batches;
291:
292: PROCEDURE transfer_bee_batches (p_batches IN batches_type_table)
293: IS

Line 297: hr_utility.set_location ('Entering:' || l_proc, 10);

293: IS
294: l_proc CONSTANT proc_name := g_package || 'transfer_bee_batches';
295: l_batches_idx PLS_INTEGER := p_batches.FIRST;
296: BEGIN
297: hr_utility.set_location ('Entering:' || l_proc, 10);
298: start_bee_process (p_mode => 'TRANSFER', p_batches => p_batches);
299: hr_utility.set_location ('Leaving:' || l_proc, 100);
300: END transfer_bee_batches;
301:

Line 299: hr_utility.set_location ('Leaving:' || l_proc, 100);

295: l_batches_idx PLS_INTEGER := p_batches.FIRST;
296: BEGIN
297: hr_utility.set_location ('Entering:' || l_proc, 10);
298: start_bee_process (p_mode => 'TRANSFER', p_batches => p_batches);
299: hr_utility.set_location ('Leaving:' || l_proc, 100);
300: END transfer_bee_batches;
301:
302: PROCEDURE process_bee_batches (
303: p_batches IN batches_type_table DEFAULT batches_created,

Line 310: hr_utility.set_location ('Entering:' || l_proc, 10);

306: IS
307: l_proc CONSTANT proc_name := g_package || 'process_bee_batches';
308: l_batches_idx PLS_INTEGER := p_batches.FIRST;
309: BEGIN
310: hr_utility.set_location ('Entering:' || l_proc, 10);
311:
312: IF (p_status_in_bee = 'V')
313: THEN
314: validate_bee_batches (p_batches);

Line 320: hr_utility.set_location ('Leaving:' || l_proc, 100);

316: THEN
317: transfer_bee_batches (p_batches);
318: END IF;
319:
320: hr_utility.set_location ('Leaving:' || l_proc, 100);
321: END process_bee_batches;
322:
323: FUNCTION where_clause (
324: p_bg_id IN hr_all_organization_units.business_group_id%TYPE,

Line 356: hr_utility.set_location ('Entering ' || l_proc, 10);

352:
353: RETURN l_clause_part;
354: END clause_part;
355: BEGIN
356: hr_utility.set_location ('Entering ' || l_proc, 10);
357: l_location := clause_part (p_location_id, ' and paa.location_id = ');
358: l_payroll := clause_part (p_payroll_id, ' and paa.payroll_id = ');
359: l_org := clause_part (p_organization_id, ' and paa.organization_id = ');
360: l_person := clause_part (p_person_id, ' and paa.person_id = ');

Line 409: hr_utility.set_location ('Leaving ' || l_proc, 100);

405: || p_gre_id
406: || ''')}';
407: END IF;
408:
409: hr_utility.set_location ('Leaving ' || l_proc, 100);
410: RETURN l_where_clause;
411: END where_clause;
412:
413: PROCEDURE set_transaction_detail (

Line 421: hr_utility.set_location ('Entering ' || l_proc, 10);

417: )
418: IS
419: l_proc CONSTANT proc_name := g_package || 'set_transaction_detail';
420: BEGIN
421: hr_utility.set_location ('Entering ' || l_proc, 10);
422: hxc_generic_retrieval_pkg.t_tx_detail_status (p_tbb_idx) := p_status;
423: hxc_generic_retrieval_pkg.t_tx_detail_exception (p_tbb_idx) :=
424: SUBSTR (p_exception, 1, g_max_message_size);
425: hr_utility.set_location ('Leaving ' || l_proc, 100);

Line 425: hr_utility.set_location ('Leaving ' || l_proc, 100);

421: hr_utility.set_location ('Entering ' || l_proc, 10);
422: hxc_generic_retrieval_pkg.t_tx_detail_status (p_tbb_idx) := p_status;
423: hxc_generic_retrieval_pkg.t_tx_detail_exception (p_tbb_idx) :=
424: SUBSTR (p_exception, 1, g_max_message_size);
425: hr_utility.set_location ('Leaving ' || l_proc, 100);
426: END set_transaction_detail;
427:
428: PROCEDURE set_transaction (
429: p_process_name IN hxc_retrieval_processes.NAME%TYPE,

Line 436: hr_utility.set_location ('Entering ' || l_proc, 10);

432: )
433: IS
434: l_proc CONSTANT proc_name := g_package || 'set_transaction';
435: BEGIN
436: hr_utility.set_location ('Entering ' || l_proc, 10);
437: hxc_generic_retrieval_utils.set_parent_statuses;
438: hxc_generic_retrieval_pkg.update_transaction_status
439: (p_process => p_process_name,
440: p_status => p_status,

Line 448: hr_utility.set_location ('Leaving ' || l_proc, 100);

444: g_max_message_size
445: ),
446: p_rollback => FALSE
447: );
448: hr_utility.set_location ('Leaving ' || l_proc, 100);
449: END set_transaction;
450:
451: PROCEDURE set_successfull_trx_detail (p_tbb_idx IN PLS_INTEGER)
452: IS

Line 456: hr_utility.set_location ('Entering ' || l_proc, 10);

452: IS
453: l_proc CONSTANT proc_name
454: := g_package || 'set_successfull_trx_detail';
455: BEGIN
456: hr_utility.set_location ('Entering ' || l_proc, 10);
457: fnd_message.set_name (g_hxc_app_short_name, g_trx_detail_success_msg);
458: set_transaction_detail (p_tbb_idx => p_tbb_idx,
459: p_status => g_trx_success,
460: p_exception => fnd_message.get

Line 462: hr_utility.set_location ('Leaving ' || l_proc, 100);

458: set_transaction_detail (p_tbb_idx => p_tbb_idx,
459: p_status => g_trx_success,
460: p_exception => fnd_message.get
461: );
462: hr_utility.set_location ('Leaving ' || l_proc, 100);
463: END set_successfull_trx_detail;
464:
465: PROCEDURE set_successfull_trx (
466: p_process_name IN hxc_retrieval_processes.NAME%TYPE

Line 471: hr_utility.set_location ('Entering ' || l_proc, 10);

467: )
468: IS
469: l_proc CONSTANT proc_name := g_package || 'set_successfull_trx';
470: BEGIN
471: hr_utility.set_location ('Entering ' || l_proc, 10);
472: fnd_message.set_name (g_hxc_app_short_name, g_trx_success_msg);
473: set_transaction (p_process_name => p_process_name,
474: p_status => g_trx_success,
475: p_exception => fnd_message.get

Line 477: hr_utility.set_location ('Leaving ' || l_proc, 100);

473: set_transaction (p_process_name => p_process_name,
474: p_status => g_trx_success,
475: p_exception => fnd_message.get
476: );
477: hr_utility.set_location ('Leaving ' || l_proc, 100);
478: END set_successfull_trx;
479:
480: PROCEDURE set_sqlerror_trx_detail (p_tbb_idx IN PLS_INTEGER)
481: IS

Line 484: hr_utility.set_location ('Entering ' || l_proc, 10);

480: PROCEDURE set_sqlerror_trx_detail (p_tbb_idx IN PLS_INTEGER)
481: IS
482: l_proc CONSTANT proc_name := g_package || 'set_sqlerror_trx_detail';
483: BEGIN
484: hr_utility.set_location ('Entering ' || l_proc, 10);
485: hr_utility.set_location (' Error found = ' || SQLERRM, 20);
486: set_transaction_detail (p_tbb_idx => p_tbb_idx,
487: p_status => g_trx_error,
488: p_exception => 'The error is : '

Line 485: hr_utility.set_location (' Error found = ' || SQLERRM, 20);

481: IS
482: l_proc CONSTANT proc_name := g_package || 'set_sqlerror_trx_detail';
483: BEGIN
484: hr_utility.set_location ('Entering ' || l_proc, 10);
485: hr_utility.set_location (' Error found = ' || SQLERRM, 20);
486: set_transaction_detail (p_tbb_idx => p_tbb_idx,
487: p_status => g_trx_error,
488: p_exception => 'The error is : '
489: || TO_CHAR (SQLCODE)

Line 493: hr_utility.set_location ('Leaving ' || l_proc, 100);

489: || TO_CHAR (SQLCODE)
490: || ' '
491: || SQLERRM
492: );
493: hr_utility.set_location ('Leaving ' || l_proc, 100);
494: END set_sqlerror_trx_detail;
495:
496: PROCEDURE set_sqlerror_trx (
497: p_process_name IN hxc_retrieval_processes.NAME%TYPE

Line 502: hr_utility.set_location ('Entering ' || l_proc, 10);

498: )
499: IS
500: l_proc CONSTANT proc_name := g_package || 'set_sqlerror_trx';
501: BEGIN
502: hr_utility.set_location ('Entering ' || l_proc, 10);
503: set_transaction (p_process_name => p_process_name,
504: p_status => g_trx_error,
505: p_exception => 'The error is : '
506: || TO_CHAR (SQLCODE)

Line 510: hr_utility.set_location ('Leaving ' || l_proc, 100);

506: || TO_CHAR (SQLCODE)
507: || ' '
508: || SQLERRM
509: );
510: hr_utility.set_location ('Leaving ' || l_proc, 100);
511: END set_sqlerror_trx;
512:
513: PROCEDURE process_otlr_employees (
514: p_bg_id IN hr_all_organization_units.business_group_id%TYPE,

Line 536: hr_utility.set_location ('Entering ' || l_proc, 10);

532:
533: l_dup_count NUMBER; -- Bug 6121705
534:
535: BEGIN
536: hr_utility.set_location ('Entering ' || l_proc, 10);
537: -- transfer the employees with OTM Rules = Yes
538: hxt_otc_retrieval_interface.transfer_to_otm
539: (p_bg_id => p_bg_id,
540: p_incremental => p_incremental,

Line 586: hr_utility.set_location ('Leaving ' || l_proc, 100);

582: p_bg_id, -- bg_id to create batch
583: p_session_date); -- batch is created with this session date
584: END IF;
585:
586: hr_utility.set_location ('Leaving ' || l_proc, 100);
587: END process_otlr_employees;
588:
589: PROCEDURE extract_data_from_attr_tbl (
590: p_bg_id IN hr_all_organization_units.business_group_id%TYPE,

Line 605: hr_utility.set_location ('Entering ' || l_proc, 10);

601: := g_package || 'extract_data_from_attr_tbl';
602: e_no_element_type_id EXCEPTION;
603: l_start_attr_tbl_idx PLS_INTEGER;
604: BEGIN
605: hr_utility.set_location ('Entering ' || l_proc, 10);
606:
607: IF (hxt_interface_utilities.is_in_sync
608: (p_check_tbb_id => p_attr_tbl (NVL (p_attr_tbl_idx,
609: p_attr_tbl.FIRST

Line 650: hr_utility.set_location ('Leaving ' || l_proc, 100);

646: fnd_message.set_token ('STEP', 'tbb mismatch');
647: fnd_message.raise_error;
648: END IF;
649:
650: hr_utility.set_location ('Leaving ' || l_proc, 100);
651: EXCEPTION
652: WHEN e_no_element_type_id
653: THEN
654: fnd_message.set_name (g_hxc_app_short_name,

Line 671: hr_utility.set_location ('Entering ' || l_proc, 10);

667: )
668: AS
669: l_proc CONSTANT proc_name := g_package || 'parse_cost_flex';
670: BEGIN
671: hr_utility.set_location ('Entering ' || l_proc, 10);
672:
673: IF NOT (hxt_interface_utilities.cost_segments_all_null (p_bee_rec))
674: THEN
675: -- get the cost_allocation_flexfield_id (we can do this after the COST

Line 692: hr_utility.set_location ('Leaving ' || l_proc, 100);

688: p_bee_rec.pay_batch_line.cost_allocation_keyflex_id := NULL;
689: p_bee_rec.pay_batch_line.concatenated_segments := NULL;
690: END IF;
691:
692: hr_utility.set_location ('Leaving ' || l_proc, 100);
693: END parse_cost_flex;
694:
695: PROCEDURE bee_batch_line (
696: p_bg_id IN pay_batch_headers.business_group_id%TYPE,

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

709: l_geocode VARCHAR2 (21);
710: l_hours_iv_position PLS_INTEGER;
711: l_jurisdiction_iv_position PLS_INTEGER;
712: BEGIN
713: hr_utility.set_location ('Entering ' || l_proc, 10);
714: extract_data_from_attr_tbl (p_bg_id => p_bg_id,
715: p_attr_tbl => p_attr_tbl,
716: p_tbb_id => p_tbb_rec.bb_id,
717: p_det_tbb_idx => p_det_tbb_idx,

Line 779: hr_utility.set_location ('Leaving ' || l_proc, 100);

775: END IF;
776:
777: parse_cost_flex (p_business_group_id => p_bg_id,
778: p_bee_rec => p_bee_rec);
779: hr_utility.set_location ('Leaving ' || l_proc, 100);
780: EXCEPTION
781: WHEN e_no_assignment
782: THEN
783: fnd_message.set_name (g_hxc_app_short_name,

Line 803: hr_utility.set_location ('Entering:' || l_proc, 10);

799: l_proc CONSTANT proc_name := g_package || 'batch_name';
800: l_batch_suffix pay_batch_headers.batch_name%TYPE; -- NUMBER;
801: l_batch_name pay_batch_headers.batch_name%TYPE;
802: BEGIN
803: hr_utility.set_location ('Entering:' || l_proc, 10);
804: l_batch_suffix :=
805: TO_CHAR (hxt_interface_utilities.conc_request_id_suffix);
806: l_batch_suffix :=
807: l_batch_suffix

Line 817: hr_utility.set_location (' returning batch name: ' || l_batch_name,

813: l_batch_name :=
814: p_batch_reference
815: || hxt_interface_utilities.batchname_suffix_connector
816: || l_batch_suffix;
817: hr_utility.set_location (' returning batch name: ' || l_batch_name,
818: 20);
819: hr_utility.set_location ('Leaving:' || l_proc, 100);
820: RETURN l_batch_name;
821: END batch_name;

Line 819: hr_utility.set_location ('Leaving:' || l_proc, 100);

815: || hxt_interface_utilities.batchname_suffix_connector
816: || l_batch_suffix;
817: hr_utility.set_location (' returning batch name: ' || l_batch_name,
818: 20);
819: hr_utility.set_location ('Leaving:' || l_proc, 100);
820: RETURN l_batch_name;
821: END batch_name;
822:
823: FUNCTION create_batch_header (

Line 839: hr_utility.set_location ('Entering:' || l_proc, 10);

835: := g_package || 'create_batch_header';
836: l_object_version_number pay_batch_headers.object_version_number%TYPE;
837: l_new_batch pay_batch_headers.batch_id%TYPE;
838: BEGIN
839: hr_utility.set_location ('Entering:' || l_proc, 10);
840: pay_batch_element_entry_api.create_batch_header
841: (p_session_date => p_session_date,
842: p_batch_name => p_batch_name,
843: p_business_group_id => p_bg_id,

Line 855: hr_utility.set_location (' returning batch_id = :' || l_new_batch, 20);

851: p_business_group_id => p_bg_id,
852: p_batch_reference => p_batch_reference,
853: p_batch_name => p_batch_name
854: );
855: hr_utility.set_location (' returning batch_id = :' || l_new_batch, 20);
856: hr_utility.set_location ('Leaving:' || l_proc, 100);
857: RETURN l_new_batch;
858: EXCEPTION
859: WHEN OTHERS

Line 856: hr_utility.set_location ('Leaving:' || l_proc, 100);

852: p_batch_reference => p_batch_reference,
853: p_batch_name => p_batch_name
854: );
855: hr_utility.set_location (' returning batch_id = :' || l_new_batch, 20);
856: hr_utility.set_location ('Leaving:' || l_proc, 100);
857: RETURN l_new_batch;
858: EXCEPTION
859: WHEN OTHERS
860: THEN

Line 887: hr_utility.set_location ('Entering:' || l_proc, 10);

883: l_object_version_number pay_batch_headers.object_version_number%TYPE;
884: l_batch_name pay_batch_headers.batch_name%TYPE;
885: l_new_batch pay_batch_headers.batch_id%TYPE;
886: BEGIN
887: hr_utility.set_location ('Entering:' || l_proc, 10);
888: l_batch_name :=
889: batch_name (p_batch_reference => p_batch_reference,
890: p_bg_id => p_bg_id
891: );

Line 902: hr_utility.set_location (' returning batch_id = :' || l_new_batch, 20);

898: p_bg_id => p_bg_id,
899: p_session_date => p_session_date,
900: p_det_tbb_idx => p_det_tbb_idx
901: );
902: hr_utility.set_location (' returning batch_id = :' || l_new_batch, 20);
903: hr_utility.set_location ('Leaving:' || l_proc, 100);
904: RETURN l_new_batch;
905: END create_batch_header;
906:

Line 903: hr_utility.set_location ('Leaving:' || l_proc, 100);

899: p_session_date => p_session_date,
900: p_det_tbb_idx => p_det_tbb_idx
901: );
902: hr_utility.set_location (' returning batch_id = :' || l_new_batch, 20);
903: hr_utility.set_location ('Leaving:' || l_proc, 100);
904: RETURN l_new_batch;
905: END create_batch_header;
906:
907: PROCEDURE create_batch_line (

Line 922: hr_utility.set_location ('Entering:' || l_proc, 10);

918: l_total_lines NUMBER;
919: l_batch_line_id pay_batch_lines.batch_line_id%TYPE;
920: l_object_version_number pay_batch_lines.object_version_number%TYPE;
921: BEGIN
922: hr_utility.set_location ('Entering:' || l_proc, 10);
923: pay_batch_element_entry_api.create_batch_line
924: (p_session_date => p_session_date,
925: p_batch_id => p_batch_id,
926: p_assignment_id => p_bee_rec.pay_batch_line.assignment_id,

Line 1075: hr_utility.set_location ('Leaving:' || l_proc, 100);

1071: ),
1072: p_batch_line_id => l_batch_line_id,
1073: p_object_version_number => l_object_version_number
1074: );
1075: hr_utility.set_location ('Leaving:' || l_proc, 100);
1076: EXCEPTION
1077: WHEN OTHERS
1078: THEN
1079: fnd_message.set_name (g_hxc_app_short_name,

Line 1104: hr_utility.set_location ('Entering:' || l_proc, 10);

1100: AS
1101: l_proc CONSTANT proc_name := g_package || 'add_to_batch';
1102: l_max_lines_exceeded BOOLEAN;
1103: BEGIN
1104: hr_utility.set_location ('Entering:' || l_proc, 10);
1105:
1106: IF (p_batch_id IS NULL)
1107: THEN -- first call
1108: p_batch_id :=

Line 1153: hr_utility.set_location (' OUT p_batch_id = ' || p_batch_id, 20);

1149: );
1150: g_assignment_id := p_bee_rec.pay_batch_line.assignment_id;
1151: p_batch_lines := p_batch_lines + 1;
1152: p_batch_sequence := p_batch_sequence + 1;
1153: hr_utility.set_location (' OUT p_batch_id = ' || p_batch_id, 20);
1154: hr_utility.set_location (' OUT p_batch_sequence = '
1155: || p_batch_sequence,
1156: 30
1157: );

Line 1154: hr_utility.set_location (' OUT p_batch_sequence = '

1150: g_assignment_id := p_bee_rec.pay_batch_line.assignment_id;
1151: p_batch_lines := p_batch_lines + 1;
1152: p_batch_sequence := p_batch_sequence + 1;
1153: hr_utility.set_location (' OUT p_batch_id = ' || p_batch_id, 20);
1154: hr_utility.set_location (' OUT p_batch_sequence = '
1155: || p_batch_sequence,
1156: 30
1157: );
1158: hr_utility.set_location (' OUT p_batch_lines = ' || p_batch_lines, 40);

Line 1158: hr_utility.set_location (' OUT p_batch_lines = ' || p_batch_lines, 40);

1154: hr_utility.set_location (' OUT p_batch_sequence = '
1155: || p_batch_sequence,
1156: 30
1157: );
1158: hr_utility.set_location (' OUT p_batch_lines = ' || p_batch_lines, 40);
1159: hr_utility.set_location ('Leaving:' || l_proc, 100);
1160: END add_to_batch;
1161:
1162: PROCEDURE add_lines_to_bee_batch (

Line 1159: hr_utility.set_location ('Leaving:' || l_proc, 100);

1155: || p_batch_sequence,
1156: 30
1157: );
1158: hr_utility.set_location (' OUT p_batch_lines = ' || p_batch_lines, 40);
1159: hr_utility.set_location ('Leaving:' || l_proc, 100);
1160: END add_to_batch;
1161:
1162: PROCEDURE add_lines_to_bee_batch (
1163: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,

Line 1192: hr_utility.set_location ('Entering ' || l_proc, 10);

1188: l_retro_batch_sequence pay_batch_lines.batch_sequence%TYPE;
1189: l_batch_lines PLS_INTEGER;
1190: l_retro_batch_lines PLS_INTEGER;
1191: BEGIN
1192: hr_utility.set_location ('Entering ' || l_proc, 10);
1193: l_batch_id := p_batch_id;
1194: l_retro_batch_id := p_retro_batch_id;
1195: l_det_tbb_idx := p_tbb_tbl.FIRST;
1196:

Line 1393: hr_utility.set_location ('Leaving ' || l_proc, 100);

1389: set_successfull_trx (g_bee_retrieval_process);
1390: hxt_interface_utilities.perform_commit;
1391: p_batch_id := l_batch_id;
1392: p_retro_batch_id := l_retro_batch_id;
1393: hr_utility.set_location ('Leaving ' || l_proc, 100);
1394: END add_lines_to_bee_batch;
1395:
1396: PROCEDURE process_non_otlr_employees (
1397: p_bg_id IN hr_all_organization_units.business_group_id%TYPE,

Line 1424: hr_utility.set_location ('Entering ' || l_proc, 10);

1420:
1421: l_dup_count NUMBER; -- Bug 6121705
1422:
1423: BEGIN
1424: hr_utility.set_location ('Entering ' || l_proc, 10);
1425:
1426: <>
1427: LOOP
1428: -- call generic retrieval to get the non-OTM employees Timecards

Line 1500: hr_utility.set_location ('Leaving ' || l_proc, 100);

1496: hxt_interface_utilities.perform_commit;
1497: -- Transfer or Validate the batches that were created
1498: --(if requested by user)
1499: process_bee_batches (p_status_in_bee => p_status_in_bee);
1500: hr_utility.set_location ('Leaving ' || l_proc, 100);
1501: EXCEPTION
1502: WHEN OTHERS
1503: THEN
1504: set_sqlerror_trx (g_bee_retrieval_process);

Line 2012: hr_utility.trace('Sql error in make_adjustments :'||l_sqlmsg);

2008:
2009: EXCEPTION
2010: WHEN OTHERS THEN
2011: l_sqlmsg := SUBSTR(SQLERRM,1,1500)||SQLCODE;
2012: hr_utility.trace('Sql error in make_adjustments :'||l_sqlmsg);
2013: RAISE;
2014:
2015: END;
2016:

Line 2163: hr_utility.trace('Sql error in make_adjustments :'||l_sqlmsg);

2159: WHEN NO_DATA_FOUND THEN
2160: NULL;
2161: WHEN others THEN
2162: l_sqlmsg := SUBSTR(SQLERRM,1,1500)||SQLCODE;
2163: hr_utility.trace('Sql error in make_adjustments :'||l_sqlmsg);
2164: RAISE;
2165: END;
2166:
2167: