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 13: g_debug BOOLEAN := hr_utility.debug_enabled;

9: e_continue EXCEPTION;
10: e_halt EXCEPTION;
11: g_assignment_id pay_batch_lines.assignment_id%TYPE;
12: l_since_date VARCHAR2 (20);
13: g_debug BOOLEAN := hr_utility.debug_enabled;
14:
15: -- Bug 13705204
16: -- Defined the datatype and added a global variable here.
17: CURSOR csr_iv_info_m (

Line 140: hr_utility.set_location ( ' l_lookup_meaning = '

136: INTO l_lookup_meaning;
137:
138: CLOSE csr_valid_lookup;
139:
140: hr_utility.set_location ( ' l_lookup_meaning = '
141: || l_lookup_meaning,
142: 10
143: );
144: RETURN l_lookup_meaning;

Line 159: hr_utility.set_location ( ' l_valueset_meaning = '

155: l_valueset_meaning :=
156: pay_input_values_pkg.decode_vset_value (p_value_set_id,
157: p_valueset_value
158: );
159: hr_utility.set_location ( ' l_valueset_meaning = '
160: || l_valueset_meaning,
161: 10
162: );
163: RETURN l_valueset_meaning;

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

162: );
163: RETURN l_valueset_meaning;
164: END valueset_meaning;
165: BEGIN
166: hr_utility.set_location ('Entering: ' || l_proc, 10);
167: l_display_value := p_internal_input_value;
168:
169: -- Bug 13777315
170: IF g_iv_upgrade = 'Y'

Line 172: hr_utility.trace('IV In = '||p_internal_input_value);

168:
169: -- Bug 13777315
170: IF g_iv_upgrade = 'Y'
171: THEN
172: hr_utility.trace('IV In = '||p_internal_input_value);
173: hr_utility.trace('IV upgrade done, not converting any IVs ');
174: RETURN p_internal_input_value;
175: END IF;
176:

Line 173: hr_utility.trace('IV upgrade done, not converting any IVs ');

169: -- Bug 13777315
170: IF g_iv_upgrade = 'Y'
171: THEN
172: hr_utility.trace('IV In = '||p_internal_input_value);
173: hr_utility.trace('IV upgrade done, not converting any IVs ');
174: RETURN p_internal_input_value;
175: END IF;
176:
177: IF (p_internal_input_value IS NOT NULL)

Line 179: hr_utility.set_location

175: END IF;
176:
177: IF (p_internal_input_value IS NOT NULL)
178: THEN
179: hr_utility.set_location
180: ( ' Converting p_internal_input_value = '
181: || p_internal_input_value,
182: 20
183: );

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

180: ( ' Converting p_internal_input_value = '
181: || p_internal_input_value,
182: 20
183: );
184: hr_utility.set_location (' using: ', 30);
185: hr_utility.set_location ( ' p_element_type_id = '
186: || p_element_type_id,
187: 40
188: );

Line 185: hr_utility.set_location ( ' p_element_type_id = '

181: || p_internal_input_value,
182: 20
183: );
184: hr_utility.set_location (' using: ', 30);
185: hr_utility.set_location ( ' p_element_type_id = '
186: || p_element_type_id,
187: 40
188: );
189: hr_utility.set_location (' p_iv_number = ' || p_iv_number,

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

185: hr_utility.set_location ( ' p_element_type_id = '
186: || p_element_type_id,
187: 40
188: );
189: hr_utility.set_location (' p_iv_number = ' || p_iv_number,
190: 50
191: );
192: hr_utility.set_location ( ' p_session_date = '
193: || p_session_date,

Line 192: hr_utility.set_location ( ' p_session_date = '

188: );
189: hr_utility.set_location (' p_iv_number = ' || p_iv_number,
190: 50
191: );
192: hr_utility.set_location ( ' p_session_date = '
193: || p_session_date,
194: 60
195: );
196: hr_utility.set_location (' p_bg_id = ' || p_bg_id,

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

192: hr_utility.set_location ( ' p_session_date = '
193: || p_session_date,
194: 60
195: );
196: hr_utility.set_location (' p_bg_id = ' || p_bg_id,
197: 70);
198:
199: -- Bug 13705204
200: -- Added this caching logic here.

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

257: END IF;
258: END IF;
259: END IF;
260:
261: hr_utility.set_location ( ' returning l_display_value = '
262: || l_display_value,
263: 90
264: );
265: hr_utility.set_location ('Leaving: ' || l_proc, 100);

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

261: hr_utility.set_location ( ' returning l_display_value = '
262: || l_display_value,
263: 90
264: );
265: hr_utility.set_location ('Leaving: ' || l_proc, 100);
266: RETURN l_display_value;
267: EXCEPTION
268: WHEN OTHERS
269: THEN

Line 270: hr_utility.trace(dbms_utility.format_error_backtrace);

266: RETURN l_display_value;
267: EXCEPTION
268: WHEN OTHERS
269: THEN
270: hr_utility.trace(dbms_utility.format_error_backtrace);
271: hr_utility.set_message ('PAY', 'PAY_6306_INPUT_VALUE_FORMAT');
272: hr_utility.set_message_token
273: ('UNIT_OF_MEASURE',
274: hr_general.decode_lookup ('UNITS',

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

267: EXCEPTION
268: WHEN OTHERS
269: THEN
270: hr_utility.trace(dbms_utility.format_error_backtrace);
271: hr_utility.set_message ('PAY', 'PAY_6306_INPUT_VALUE_FORMAT');
272: hr_utility.set_message_token
273: ('UNIT_OF_MEASURE',
274: hr_general.decode_lookup ('UNITS',
275: rec_iv_info.uom

Line 272: hr_utility.set_message_token

268: WHEN OTHERS
269: THEN
270: hr_utility.trace(dbms_utility.format_error_backtrace);
271: hr_utility.set_message ('PAY', 'PAY_6306_INPUT_VALUE_FORMAT');
272: hr_utility.set_message_token
273: ('UNIT_OF_MEASURE',
274: hr_general.decode_lookup ('UNITS',
275: rec_iv_info.uom
276: )

Line 278: hr_utility.raise_error;

274: hr_general.decode_lookup ('UNITS',
275: rec_iv_info.uom
276: )
277: );
278: hr_utility.raise_error;
279:
280: END display_value;
281:
282: FUNCTION retro_batch_suffix

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

283: RETURN VARCHAR2
284: IS
285: l_proc CONSTANT proc_name := g_package || 'retro_batch_suffix';
286: BEGIN
287: hr_utility.set_location ('Entering:' || l_proc, 10);
288: hr_utility.set_location ( ' returning g_retro_batch_suffix = '
289: || g_retro_batch_suffix,
290: 20
291: );

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

284: IS
285: l_proc CONSTANT proc_name := g_package || 'retro_batch_suffix';
286: BEGIN
287: hr_utility.set_location ('Entering:' || l_proc, 10);
288: hr_utility.set_location ( ' returning g_retro_batch_suffix = '
289: || g_retro_batch_suffix,
290: 20
291: );
292: hr_utility.set_location ('Leaving:' || l_proc, 100);

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

288: hr_utility.set_location ( ' returning g_retro_batch_suffix = '
289: || g_retro_batch_suffix,
290: 20
291: );
292: hr_utility.set_location ('Leaving:' || l_proc, 100);
293: RETURN g_retro_batch_suffix;
294: END retro_batch_suffix;
295:
296: PROCEDURE set_retro_batch_suffix (p_retro_batch_suffix IN VARCHAR2)

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

296: PROCEDURE set_retro_batch_suffix (p_retro_batch_suffix IN VARCHAR2)
297: IS
298: l_proc CONSTANT proc_name := g_package || 'set_retro_batch_suffix';
299: BEGIN
300: hr_utility.set_location ('Entering:' || l_proc, 10);
301: hr_utility.set_location ( ' setting g_retro_batch_suffix to '
302: || p_retro_batch_suffix,
303: 20
304: );

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

297: IS
298: l_proc CONSTANT proc_name := g_package || 'set_retro_batch_suffix';
299: BEGIN
300: hr_utility.set_location ('Entering:' || l_proc, 10);
301: hr_utility.set_location ( ' setting g_retro_batch_suffix to '
302: || p_retro_batch_suffix,
303: 20
304: );
305: g_retro_batch_suffix := p_retro_batch_suffix;

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

302: || p_retro_batch_suffix,
303: 20
304: );
305: g_retro_batch_suffix := p_retro_batch_suffix;
306: hr_utility.set_location ('Leaving:' || l_proc, 100);
307: END set_retro_batch_suffix;
308:
309: PROCEDURE record_batch_info (p_batch_rec IN batches_type_rec)
310: IS

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

309: PROCEDURE record_batch_info (p_batch_rec IN batches_type_rec)
310: IS
311: l_proc CONSTANT proc_name := g_package || 'record_batch_info';
312: BEGIN
313: hr_utility.set_location ('Entering:' || l_proc, 10);
314: g_batches_created (NVL (g_batches_created.LAST, 0) + 1) := p_batch_rec;
315: hr_utility.set_location ('Leaving:' || l_proc, 100);
316: END record_batch_info;
317:

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

311: l_proc CONSTANT proc_name := g_package || 'record_batch_info';
312: BEGIN
313: hr_utility.set_location ('Entering:' || l_proc, 10);
314: g_batches_created (NVL (g_batches_created.LAST, 0) + 1) := p_batch_rec;
315: hr_utility.set_location ('Leaving:' || l_proc, 100);
316: END record_batch_info;
317:
318: PROCEDURE record_batch_info (
319: p_batch_id IN pay_batch_headers.batch_id%TYPE,

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

325: l_proc CONSTANT proc_name
326: := g_package || 'record_batch_info (Overloaded)';
327: l_batch_created batches_type_rec;
328: BEGIN
329: hr_utility.set_location ('Entering:' || l_proc, 10);
330: l_batch_created.batch_id := p_batch_id;
331: l_batch_created.business_group_id := p_business_group_id;
332: l_batch_created.batch_reference := p_batch_reference;
333: l_batch_created.batch_name := p_batch_name;

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

331: l_batch_created.business_group_id := p_business_group_id;
332: l_batch_created.batch_reference := p_batch_reference;
333: l_batch_created.batch_name := p_batch_name;
334: record_batch_info (p_batch_rec => l_batch_created);
335: hr_utility.set_location ('Leaving:' || l_proc, 100);
336: END record_batch_info;
337:
338: FUNCTION batches_created
339: RETURN batches_type_table

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

339: RETURN batches_type_table
340: IS
341: l_proc CONSTANT proc_name := g_package || 'batches_created';
342: BEGIN
343: hr_utility.set_location ('Entering:' || l_proc, 10);
344: hr_utility.set_location ( ' g_batches_created.count = '
345: || g_batches_created.COUNT,
346: 20
347: );

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

340: IS
341: l_proc CONSTANT proc_name := g_package || 'batches_created';
342: BEGIN
343: hr_utility.set_location ('Entering:' || l_proc, 10);
344: hr_utility.set_location ( ' g_batches_created.count = '
345: || g_batches_created.COUNT,
346: 20
347: );
348: hr_utility.set_location ('Leaving:' || l_proc, 100);

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

344: hr_utility.set_location ( ' g_batches_created.count = '
345: || g_batches_created.COUNT,
346: 20
347: );
348: hr_utility.set_location ('Leaving:' || l_proc, 100);
349: RETURN g_batches_created;
350: END batches_created;
351:
352: PROCEDURE start_bee_process (

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

357: l_proc CONSTANT proc_name := g_package || 'start_bee_process';
358: l_batches_idx PLS_INTEGER := p_batches.FIRST;
359: l_request_id fnd_concurrent_requests.request_id%TYPE;
360: BEGIN
361: hr_utility.set_location ('Entering:' || l_proc, 10);
362:
363: <>
364: LOOP
365: EXIT start_conc_prog_for_batches WHEN NOT p_batches.EXISTS

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

372: );
373: l_batches_idx := p_batches.NEXT (l_batches_idx);
374: END LOOP start_conc_prog_for_batches;
375:
376: hr_utility.set_location ('Leaving:' || l_proc, 100);
377: END start_bee_process;
378:
379: PROCEDURE validate_bee_batches (p_batches IN batches_type_table)
380: IS

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

379: PROCEDURE validate_bee_batches (p_batches IN batches_type_table)
380: IS
381: l_proc CONSTANT proc_name := g_package || 'validate_bee_batches';
382: BEGIN
383: hr_utility.set_location ('Entering:' || l_proc, 10);
384: start_bee_process (p_mode => 'VALIDATE', p_batches => p_batches);
385: hr_utility.set_location ('Leaving:' || l_proc, 100);
386: END validate_bee_batches;
387:

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

381: l_proc CONSTANT proc_name := g_package || 'validate_bee_batches';
382: BEGIN
383: hr_utility.set_location ('Entering:' || l_proc, 10);
384: start_bee_process (p_mode => 'VALIDATE', p_batches => p_batches);
385: hr_utility.set_location ('Leaving:' || l_proc, 100);
386: END validate_bee_batches;
387:
388: PROCEDURE transfer_bee_batches (p_batches IN batches_type_table)
389: IS

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

389: IS
390: l_proc CONSTANT proc_name := g_package || 'transfer_bee_batches';
391: l_batches_idx PLS_INTEGER := p_batches.FIRST;
392: BEGIN
393: hr_utility.set_location ('Entering:' || l_proc, 10);
394: start_bee_process (p_mode => 'TRANSFER', p_batches => p_batches);
395: hr_utility.set_location ('Leaving:' || l_proc, 100);
396: END transfer_bee_batches;
397:

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

391: l_batches_idx PLS_INTEGER := p_batches.FIRST;
392: BEGIN
393: hr_utility.set_location ('Entering:' || l_proc, 10);
394: start_bee_process (p_mode => 'TRANSFER', p_batches => p_batches);
395: hr_utility.set_location ('Leaving:' || l_proc, 100);
396: END transfer_bee_batches;
397:
398: PROCEDURE process_bee_batches (
399: p_batches IN batches_type_table DEFAULT batches_created,

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

402: IS
403: l_proc CONSTANT proc_name := g_package || 'process_bee_batches';
404: l_batches_idx PLS_INTEGER := p_batches.FIRST;
405: BEGIN
406: hr_utility.set_location ('Entering:' || l_proc, 10);
407:
408: IF (p_status_in_bee = 'V')
409: THEN
410: validate_bee_batches (p_batches);

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

412: THEN
413: transfer_bee_batches (p_batches);
414: END IF;
415:
416: hr_utility.set_location ('Leaving:' || l_proc, 100);
417: END process_bee_batches;
418:
419: FUNCTION where_clause (
420: p_bg_id IN hr_all_organization_units.business_group_id%TYPE,

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

448:
449: RETURN l_clause_part;
450: END clause_part;
451: BEGIN
452: hr_utility.set_location ('Entering ' || l_proc, 10);
453: l_location := clause_part (p_location_id, ' and paa.location_id = ');
454: l_payroll := clause_part (p_payroll_id, ' and paa.payroll_id = ');
455: l_org := clause_part (p_organization_id, ' and paa.organization_id = ');
456: l_person := clause_part (p_person_id, ' and paa.person_id = ');

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

501: || p_gre_id
502: || ''')}';
503: END IF;
504:
505: hr_utility.set_location ('Leaving ' || l_proc, 100);
506: RETURN l_where_clause;
507: END where_clause;
508:
509: PROCEDURE set_transaction_detail (

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

513: )
514: IS
515: l_proc CONSTANT proc_name := g_package || 'set_transaction_detail';
516: BEGIN
517: hr_utility.set_location ('Entering ' || l_proc, 10);
518: hxc_generic_retrieval_pkg.t_tx_detail_status (p_tbb_idx) := p_status;
519: hxc_generic_retrieval_pkg.t_tx_detail_exception (p_tbb_idx) :=
520: SUBSTR (p_exception, 1, g_max_message_size);
521: hr_utility.set_location ('Leaving ' || l_proc, 100);

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

517: hr_utility.set_location ('Entering ' || l_proc, 10);
518: hxc_generic_retrieval_pkg.t_tx_detail_status (p_tbb_idx) := p_status;
519: hxc_generic_retrieval_pkg.t_tx_detail_exception (p_tbb_idx) :=
520: SUBSTR (p_exception, 1, g_max_message_size);
521: hr_utility.set_location ('Leaving ' || l_proc, 100);
522: END set_transaction_detail;
523:
524: PROCEDURE set_transaction (
525: p_process_name IN hxc_retrieval_processes.NAME%TYPE,

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

528: )
529: IS
530: l_proc CONSTANT proc_name := g_package || 'set_transaction';
531: BEGIN
532: hr_utility.set_location ('Entering ' || l_proc, 10);
533: hxc_generic_retrieval_utils.set_parent_statuses;
534: hxc_generic_retrieval_pkg.update_transaction_status
535: (p_process => p_process_name,
536: p_status => p_status,

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

540: g_max_message_size
541: ),
542: p_rollback => FALSE
543: );
544: hr_utility.set_location ('Leaving ' || l_proc, 100);
545: END set_transaction;
546:
547: PROCEDURE set_successfull_trx_detail (p_tbb_idx IN PLS_INTEGER)
548: IS

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

548: IS
549: l_proc CONSTANT proc_name
550: := g_package || 'set_successfull_trx_detail';
551: BEGIN
552: hr_utility.set_location ('Entering ' || l_proc, 10);
553: fnd_message.set_name (g_hxc_app_short_name, g_trx_detail_success_msg);
554: set_transaction_detail (p_tbb_idx => p_tbb_idx,
555: p_status => g_trx_success,
556: p_exception => fnd_message.get

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

554: set_transaction_detail (p_tbb_idx => p_tbb_idx,
555: p_status => g_trx_success,
556: p_exception => fnd_message.get
557: );
558: hr_utility.set_location ('Leaving ' || l_proc, 100);
559: END set_successfull_trx_detail;
560:
561: PROCEDURE set_successfull_trx (
562: p_process_name IN hxc_retrieval_processes.NAME%TYPE

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

563: )
564: IS
565: l_proc CONSTANT proc_name := g_package || 'set_successfull_trx';
566: BEGIN
567: hr_utility.set_location ('Entering ' || l_proc, 10);
568: fnd_message.set_name (g_hxc_app_short_name, g_trx_success_msg);
569: set_transaction (p_process_name => p_process_name,
570: p_status => g_trx_success,
571: p_exception => fnd_message.get

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

569: set_transaction (p_process_name => p_process_name,
570: p_status => g_trx_success,
571: p_exception => fnd_message.get
572: );
573: hr_utility.set_location ('Leaving ' || l_proc, 100);
574: END set_successfull_trx;
575:
576: PROCEDURE set_sqlerror_trx_detail (p_tbb_idx IN PLS_INTEGER)
577: IS

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

576: PROCEDURE set_sqlerror_trx_detail (p_tbb_idx IN PLS_INTEGER)
577: IS
578: l_proc CONSTANT proc_name := g_package || 'set_sqlerror_trx_detail';
579: BEGIN
580: hr_utility.set_location ('Entering ' || l_proc, 10);
581: hr_utility.set_location (' Error found = ' || SQLERRM, 20);
582: set_transaction_detail (p_tbb_idx => p_tbb_idx,
583: p_status => g_trx_error,
584: p_exception => 'The error is : '

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

577: IS
578: l_proc CONSTANT proc_name := g_package || 'set_sqlerror_trx_detail';
579: BEGIN
580: hr_utility.set_location ('Entering ' || l_proc, 10);
581: hr_utility.set_location (' Error found = ' || SQLERRM, 20);
582: set_transaction_detail (p_tbb_idx => p_tbb_idx,
583: p_status => g_trx_error,
584: p_exception => 'The error is : '
585: || TO_CHAR (SQLCODE)

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

585: || TO_CHAR (SQLCODE)
586: || ' '
587: || SQLERRM
588: );
589: hr_utility.set_location ('Leaving ' || l_proc, 100);
590: END set_sqlerror_trx_detail;
591:
592: PROCEDURE set_sqlerror_trx (
593: p_process_name IN hxc_retrieval_processes.NAME%TYPE

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

594: )
595: IS
596: l_proc CONSTANT proc_name := g_package || 'set_sqlerror_trx';
597: BEGIN
598: hr_utility.set_location ('Entering ' || l_proc, 10);
599: set_transaction (p_process_name => p_process_name,
600: p_status => g_trx_error,
601: p_exception => 'The error is : '
602: || TO_CHAR (SQLCODE)

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

602: || TO_CHAR (SQLCODE)
603: || ' '
604: || SQLERRM
605: );
606: hr_utility.set_location ('Leaving ' || l_proc, 100);
607: END set_sqlerror_trx;
608:
609: -- Bug 10323310
610: -- New function for R12.2 Proj Pay Integration.

Line 626: hr_utility.trace('p_resource_id = '||p_resource_id);

622: BEGIN
623:
624: IF g_debug
625: THEN
626: hr_utility.trace('p_resource_id = '||p_resource_id);
627: END IF;
628:
629: IF NOT hxc_generic_retrieval_utils.g_resources.EXISTS(p_resource_id)
630: THEN

Line 633: hr_utility.trace(' Resource does not exists; returning here ');

629: IF NOT hxc_generic_retrieval_utils.g_resources.EXISTS(p_resource_id)
630: THEN
631: IF g_debug
632: THEN
633: hr_utility.trace(' Resource does not exists; returning here ');
634: END IF;
635: RETURN;
636: END IF;
637:

Line 642: hr_utility.trace('Preference already cached, returning');

638: IF g_emp_pref_tab.EXISTS(p_resource_id)
639: THEN
640: IF g_debug
641: THEN
642: hr_utility.trace('Preference already cached, returning');
643: END IF;
644: RETURN;
645: END IF;
646:

Line 659: hr_utility.trace('Gathered preferences for '||p_resource_id);

655: IF l_pref_tab.COUNT > 0
656: THEN
657: IF g_debug
658: THEN
659: hr_utility.trace('Gathered preferences for '||p_resource_id);
660: END IF;
661: g_emp_pref_tab(p_resource_id) := pref_tab();
662: FOR i IN l_pref_tab.FIRST..l_pref_tab.LAST
663: LOOP

Line 669: hr_utility.trace('Integration is enabled for this person ');

665: AND l_pref_tab(i).attribute1 = 'Y'
666: THEN
667: IF g_debug
668: THEN
669: hr_utility.trace('Integration is enabled for this person ');
670: END IF;
671:
672: g_emp_pref_tab(p_resource_id).EXTEND;
673: l_index := l_index+1;

Line 698: hr_utility.trace('No preferences gathered; returning ');

694: IF NOT g_emp_pref_tab.EXISTS(p_resource_id)
695: THEN
696: IF g_debug
697: THEN
698: hr_utility.trace('No preferences gathered; returning ');
699: END IF;
700: RETURN FALSE;
701: END IF;
702:

Line 714: hr_utility.trace('Integration enabled, returning TRUE ');

710: IF g_emp_pref_tab(p_resource_id)(i).intg_enabled = 'Y'
711: THEN
712: IF g_debug
713: THEN
714: hr_utility.trace('Integration enabled, returning TRUE ');
715: END IF;
716: RETURN TRUE;
717: ELSE
718: RETURN FALSE;

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

748:
749: l_dup_count NUMBER; -- Bug 6121705
750:
751: BEGIN
752: hr_utility.set_location ('Entering ' || l_proc, 10);
753: -- transfer the employees with OTM Rules = Yes
754: hxt_otc_retrieval_interface.transfer_to_otm
755: (p_bg_id => p_bg_id,
756: p_incremental => p_incremental,

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

798: p_bg_id, -- bg_id to create batch
799: p_session_date); -- batch is created with this session date
800: END IF;
801:
802: hr_utility.set_location ('Leaving ' || l_proc, 100);
803: END process_otlr_employees;
804:
805:
806: -- Bug 10323310

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

907: := g_package || 'extract_data_from_attr_tbl';
908: e_no_element_type_id EXCEPTION;
909: l_start_attr_tbl_idx PLS_INTEGER;
910: BEGIN
911: hr_utility.set_location ('Entering ' || l_proc, 10);
912:
913: IF (hxt_interface_utilities.is_in_sync
914: (p_check_tbb_id => p_attr_tbl (NVL (p_attr_tbl_idx,
915: p_attr_tbl.FIRST

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

957: fnd_message.set_token ('STEP', 'tbb mismatch');
958: fnd_message.raise_error;
959: END IF;
960:
961: hr_utility.set_location ('Leaving ' || l_proc, 100);
962: EXCEPTION
963: WHEN e_no_element_type_id
964: THEN
965: fnd_message.set_name (g_hxc_app_short_name,

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

978: )
979: AS
980: l_proc CONSTANT proc_name := g_package || 'parse_cost_flex';
981: BEGIN
982: hr_utility.set_location ('Entering ' || l_proc, 10);
983:
984: IF NOT (hxt_interface_utilities.cost_segments_all_null (p_bee_rec))
985: THEN
986: -- get the cost_allocation_flexfield_id (we can do this after the COST

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

999: p_bee_rec.pay_batch_line.cost_allocation_keyflex_id := NULL;
1000: p_bee_rec.pay_batch_line.concatenated_segments := NULL;
1001: END IF;
1002:
1003: hr_utility.set_location ('Leaving ' || l_proc, 100);
1004: END parse_cost_flex;
1005:
1006: PROCEDURE bee_batch_line (
1007: p_bg_id IN pay_batch_headers.business_group_id%TYPE,

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

1020: l_geocode VARCHAR2 (21);
1021: l_hours_iv_position PLS_INTEGER;
1022: l_jurisdiction_iv_position PLS_INTEGER;
1023: BEGIN
1024: hr_utility.set_location ('Entering ' || l_proc, 10);
1025: extract_data_from_attr_tbl (p_bg_id => p_bg_id,
1026: p_attr_tbl => p_attr_tbl,
1027: p_tbb_id => p_tbb_rec.bb_id,
1028: p_det_tbb_idx => p_det_tbb_idx,

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

1105: END IF;
1106:
1107: parse_cost_flex (p_business_group_id => p_bg_id,
1108: p_bee_rec => p_bee_rec);
1109: hr_utility.set_location ('Leaving ' || l_proc, 100);
1110: EXCEPTION
1111: WHEN e_no_assignment
1112: THEN
1113: fnd_message.set_name (g_hxc_app_short_name,

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

1129: l_proc CONSTANT proc_name := g_package || 'batch_name';
1130: l_batch_suffix pay_batch_headers.batch_name%TYPE; -- NUMBER;
1131: l_batch_name pay_batch_headers.batch_name%TYPE;
1132: BEGIN
1133: hr_utility.set_location ('Entering:' || l_proc, 10);
1134: l_batch_suffix :=
1135: TO_CHAR (hxt_interface_utilities.conc_request_id_suffix);
1136: l_batch_suffix :=
1137: l_batch_suffix

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

1143: l_batch_name :=
1144: p_batch_reference
1145: || hxt_interface_utilities.batchname_suffix_connector
1146: || l_batch_suffix;
1147: hr_utility.set_location (' returning batch name: ' || l_batch_name,
1148: 20);
1149: hr_utility.set_location ('Leaving:' || l_proc, 100);
1150: RETURN l_batch_name;
1151: END batch_name;

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

1145: || hxt_interface_utilities.batchname_suffix_connector
1146: || l_batch_suffix;
1147: hr_utility.set_location (' returning batch name: ' || l_batch_name,
1148: 20);
1149: hr_utility.set_location ('Leaving:' || l_proc, 100);
1150: RETURN l_batch_name;
1151: END batch_name;
1152:
1153: FUNCTION create_batch_header (

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

1165: := g_package || 'create_batch_header';
1166: l_object_version_number pay_batch_headers.object_version_number%TYPE;
1167: l_new_batch pay_batch_headers.batch_id%TYPE;
1168: BEGIN
1169: hr_utility.set_location ('Entering:' || l_proc, 10);
1170: pay_batch_element_entry_api.create_batch_header
1171: (p_session_date => p_session_date,
1172: p_batch_name => p_batch_name,
1173: p_business_group_id => p_bg_id,

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

1181: p_business_group_id => p_bg_id,
1182: p_batch_reference => p_batch_reference,
1183: p_batch_name => p_batch_name
1184: );
1185: hr_utility.set_location (' returning batch_id = :' || l_new_batch, 20);
1186: hr_utility.set_location ('Leaving:' || l_proc, 100);
1187: RETURN l_new_batch;
1188: EXCEPTION
1189: WHEN OTHERS

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

1182: p_batch_reference => p_batch_reference,
1183: p_batch_name => p_batch_name
1184: );
1185: hr_utility.set_location (' returning batch_id = :' || l_new_batch, 20);
1186: hr_utility.set_location ('Leaving:' || l_proc, 100);
1187: RETURN l_new_batch;
1188: EXCEPTION
1189: WHEN OTHERS
1190: THEN

Line 1191: hr_utility.trace(dbms_utility.format_error_backtrace);

1187: RETURN l_new_batch;
1188: EXCEPTION
1189: WHEN OTHERS
1190: THEN
1191: hr_utility.trace(dbms_utility.format_error_backtrace);
1192: fnd_message.set_name (g_hxc_app_short_name,
1193: 'HXC_HRPAY_RET_BATCH_HDR_API'
1194: );
1195: set_transaction_detail (p_tbb_idx => p_det_tbb_idx,

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

1214: l_object_version_number pay_batch_headers.object_version_number%TYPE;
1215: l_batch_name pay_batch_headers.batch_name%TYPE;
1216: l_new_batch pay_batch_headers.batch_id%TYPE;
1217: BEGIN
1218: hr_utility.set_location ('Entering:' || l_proc, 10);
1219: l_batch_name :=
1220: batch_name (p_batch_reference => p_batch_reference,
1221: p_bg_id => p_bg_id
1222: );

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

1229: p_bg_id => p_bg_id,
1230: p_session_date => p_session_date,
1231: p_det_tbb_idx => p_det_tbb_idx
1232: );
1233: hr_utility.set_location (' returning batch_id = :' || l_new_batch, 20);
1234: hr_utility.set_location ('Leaving:' || l_proc, 100);
1235: RETURN l_new_batch;
1236: END create_batch_header;
1237:

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

1230: p_session_date => p_session_date,
1231: p_det_tbb_idx => p_det_tbb_idx
1232: );
1233: hr_utility.set_location (' returning batch_id = :' || l_new_batch, 20);
1234: hr_utility.set_location ('Leaving:' || l_proc, 100);
1235: RETURN l_new_batch;
1236: END create_batch_header;
1237:
1238: -- Bug 9494444

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

1253: l_total_lines NUMBER;
1254: l_batch_line_id pay_batch_lines.batch_line_id%TYPE;
1255: l_object_version_number pay_batch_lines.object_version_number%TYPE;
1256: BEGIN
1257: hr_utility.set_location ('Entering:' || l_proc, 10);
1258:
1259: -- Bug 13777315
1260: -- IF IV Upgrade is done, there is no need to call any function to convert any
1261: -- values; IVs will all go in Internal format, as is.

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

1527: END IF;
1528:
1529:
1530:
1531: hr_utility.set_location ('Leaving:' || l_proc, 100);
1532: EXCEPTION
1533: WHEN OTHERS
1534: THEN
1535: hr_utility.trace(dbms_utility.format_error_backtrace);

Line 1535: hr_utility.trace(dbms_utility.format_error_backtrace);

1531: hr_utility.set_location ('Leaving:' || l_proc, 100);
1532: EXCEPTION
1533: WHEN OTHERS
1534: THEN
1535: hr_utility.trace(dbms_utility.format_error_backtrace);
1536: fnd_message.set_name (g_hxc_app_short_name,
1537: 'HXC_HRPAY_RET_BATCH_LINE_API'
1538: );
1539: set_transaction_detail (p_tbb_idx => p_det_tbb_idx,

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

1560: AS
1561: l_proc CONSTANT proc_name := g_package || 'add_to_batch';
1562: l_max_lines_exceeded BOOLEAN;
1563: BEGIN
1564: hr_utility.set_location ('Entering:' || l_proc, 10);
1565:
1566: IF (p_batch_id IS NULL)
1567: THEN -- first call
1568: p_batch_id :=

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

1610: );
1611: g_assignment_id := p_bee_rec.pay_batch_line.assignment_id;
1612: p_batch_lines := p_batch_lines + 1;
1613: p_batch_sequence := p_batch_sequence + 1;
1614: hr_utility.set_location (' OUT p_batch_id = ' || p_batch_id, 20);
1615: hr_utility.set_location (' OUT p_batch_sequence = '
1616: || p_batch_sequence,
1617: 30
1618: );

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

1611: g_assignment_id := p_bee_rec.pay_batch_line.assignment_id;
1612: p_batch_lines := p_batch_lines + 1;
1613: p_batch_sequence := p_batch_sequence + 1;
1614: hr_utility.set_location (' OUT p_batch_id = ' || p_batch_id, 20);
1615: hr_utility.set_location (' OUT p_batch_sequence = '
1616: || p_batch_sequence,
1617: 30
1618: );
1619: hr_utility.set_location (' OUT p_batch_lines = ' || p_batch_lines, 40);

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

1615: hr_utility.set_location (' OUT p_batch_sequence = '
1616: || p_batch_sequence,
1617: 30
1618: );
1619: hr_utility.set_location (' OUT p_batch_lines = ' || p_batch_lines, 40);
1620: hr_utility.set_location ('Leaving:' || l_proc, 100);
1621: END add_to_batch;
1622:
1623: PROCEDURE add_lines_to_bee_batch (

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

1616: || p_batch_sequence,
1617: 30
1618: );
1619: hr_utility.set_location (' OUT p_batch_lines = ' || p_batch_lines, 40);
1620: hr_utility.set_location ('Leaving:' || l_proc, 100);
1621: END add_to_batch;
1622:
1623: PROCEDURE add_lines_to_bee_batch (
1624: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,

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

1652: i BINARY_INTEGER;
1653: l_space VARCHAR2(15) := ' |';
1654: l_line VARCHAR2(15) := '=====|';
1655: BEGIN
1656: hr_utility.set_location ('Entering ' || l_proc, 10);
1657: l_batch_id := p_batch_id;
1658: l_retro_batch_id := p_retro_batch_id;
1659: l_det_tbb_idx := p_tbb_tbl.FIRST;
1660:

Line 1894: hr_utility.trace(dbms_utility.format_error_backtrace);

1890: WHEN OTHERS
1891: THEN
1892: set_sqlerror_trx_detail (p_tbb_idx => l_det_tbb_idx);
1893: l_det_tbb_idx := p_tbb_tbl.NEXT (l_det_tbb_idx);
1894: hr_utility.trace(dbms_utility.format_error_backtrace);
1895: END processing_tbb;
1896: END LOOP process_all_detail_tbb;
1897:
1898: set_successfull_trx (g_bee_retrieval_process);

Line 1899: hr_utility.trace('Yeah it came here ');

1895: END processing_tbb;
1896: END LOOP process_all_detail_tbb;
1897:
1898: set_successfull_trx (g_bee_retrieval_process);
1899: hr_utility.trace('Yeah it came here ');
1900: IF g_pay_pa_link_tab.COUNT > 0
1901: THEN
1902:
1903: FND_file.new_line(fnd_file.log);

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

2106:
2107: hxt_interface_utilities.perform_commit;
2108: p_batch_id := l_batch_id;
2109: p_retro_batch_id := l_retro_batch_id;
2110: hr_utility.set_location ('Leaving ' || l_proc, 100);
2111: END add_lines_to_bee_batch;
2112:
2113: PROCEDURE process_non_otlr_employees (
2114: p_bg_id IN hr_all_organization_units.business_group_id%TYPE,

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

2137:
2138: l_dup_count NUMBER; -- Bug 6121705
2139:
2140: BEGIN
2141: hr_utility.set_location ('Entering ' || l_proc, 10);
2142:
2143: -- Bug 10323310
2144: g_start_date := TRUNC(p_start_date);
2145: g_end_date := TRUNC(p_end_date);

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

2225: hxt_interface_utilities.perform_commit;
2226: -- Transfer or Validate the batches that were created
2227: --(if requested by user)
2228: process_bee_batches (p_status_in_bee => p_status_in_bee);
2229: hr_utility.set_location ('Leaving ' || l_proc, 100);
2230: EXCEPTION
2231: WHEN OTHERS
2232: THEN
2233:

Line 2234: hr_utility.trace(dbms_utility.format_error_backtrace);

2230: EXCEPTION
2231: WHEN OTHERS
2232: THEN
2233:
2234: hr_utility.trace(dbms_utility.format_error_backtrace);
2235: set_sqlerror_trx (g_bee_retrieval_process);
2236: hxc_generic_retrieval_utils.set_parent_statuses;
2237: hxc_generic_retrieval_pkg.update_transaction_status
2238: (p_process => g_bee_retrieval_process,

Line 2257: hr_utility.trace(dbms_utility.format_error_backtrace);

2253: THEN
2254: fnd_message.raise_error;
2255: END IF;
2256: END IF;
2257: hr_utility.trace(dbms_utility.format_error_backtrace);
2258:
2259: RETURN;
2260: END process_non_otlr_employees;
2261:

Line 2322: hr_utility.trace('BEE IV Upgrade '||g_iv_upgrade);

2318: -- Bug 13777315
2319: -- Find out BEE IV Upgrade status
2320: g_IV_upgrade := get_upgrade_status(p_bg_id);
2321:
2322: hr_utility.trace('BEE IV Upgrade '||g_iv_upgrade);
2323:
2324:
2325: IF ((l_retrieval_options <> 'BEE') OR (l_retrieval_options IS NULL))
2326: THEN

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

2747:
2748: EXCEPTION
2749: WHEN OTHERS THEN
2750: l_sqlmsg := SUBSTR(SQLERRM,1,1500)||SQLCODE;
2751: hr_utility.trace('Sql error in make_adjustments :'||l_sqlmsg);
2752: hr_utility.trace(dbms_utility.format_error_backtrace);
2753: RAISE;
2754:
2755: END;

Line 2752: hr_utility.trace(dbms_utility.format_error_backtrace);

2748: EXCEPTION
2749: WHEN OTHERS THEN
2750: l_sqlmsg := SUBSTR(SQLERRM,1,1500)||SQLCODE;
2751: hr_utility.trace('Sql error in make_adjustments :'||l_sqlmsg);
2752: hr_utility.trace(dbms_utility.format_error_backtrace);
2753: RAISE;
2754:
2755: END;
2756:

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

2900: WHEN NO_DATA_FOUND THEN
2901: NULL;
2902: WHEN others THEN
2903: l_sqlmsg := SUBSTR(SQLERRM,1,1500)||SQLCODE;
2904: hr_utility.trace('Sql error in make_adjustments :'||l_sqlmsg);
2905: hr_utility.trace(dbms_utility.format_error_backtrace);
2906: RAISE;
2907: END;
2908:

Line 2905: hr_utility.trace(dbms_utility.format_error_backtrace);

2901: NULL;
2902: WHEN others THEN
2903: l_sqlmsg := SUBSTR(SQLERRM,1,1500)||SQLCODE;
2904: hr_utility.trace('Sql error in make_adjustments :'||l_sqlmsg);
2905: hr_utility.trace(dbms_utility.format_error_backtrace);
2906: RAISE;
2907: END;
2908:
2909: