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.HXT_BATCH_PROCESS dependencies on HR_UTILITY

Line 3: g_debug boolean := hr_utility.debug_enabled;

1: PACKAGE BODY HXT_BATCH_PROCESS AS
2: /* $Header: hxtbat.pkb 120.25.12020000.10 2012/11/16 10:40:09 asrajago ship $ */
3: g_debug boolean := hr_utility.debug_enabled;
4: g_time_period_id NUMBER := NULL;
5: g_lookup_not_found EXCEPTION;
6: g_error_ins_batch_lines EXCEPTION; --SIR517 PWM 18FEB00
7: -- Bug 13388573

Line 233: hr_utility.trace(' IV sequence does not exist in cache ');

229: IF NOT g_list_iv_seq_table.EXISTS(TO_CHAR(p_element_type_id))
230: THEN
231: IF g_debug
232: THEN
233: hr_utility.trace(' IV sequence does not exist in cache ');
234: hr_utility.trace(' Checking from OTL and Pay setup ');
235: END IF;
236:
237: -- Bug 14827900

Line 234: hr_utility.trace(' Checking from OTL and Pay setup ');

230: THEN
231: IF g_debug
232: THEN
233: hr_utility.trace(' IV sequence does not exist in cache ');
234: hr_utility.trace(' Checking from OTL and Pay setup ');
235: END IF;
236:
237: -- Bug 14827900
238: -- Added this cursor.

Line 251: hr_utility.trace(' IV sequence does not exist in OTL setup ');

247: THEN
248:
249: IF g_debug
250: THEN
251: hr_utility.trace(' IV sequence does not exist in OTL setup ');
252: hr_utility.trace(' Checking only Pay setup ');
253: END IF;
254:
255: OPEN set_of_input_values_old;

Line 252: hr_utility.trace(' Checking only Pay setup ');

248:
249: IF g_debug
250: THEN
251: hr_utility.trace(' IV sequence does not exist in OTL setup ');
252: hr_utility.trace(' Checking only Pay setup ');
253: END IF;
254:
255: OPEN set_of_input_values_old;
256: FETCH set_of_input_values_old BULK COLLECT INTO l_seq_table;

Line 290: hr_utility.trace(' Sequence details ');

286: LOOP
287:
288: IF g_debug
289: THEN
290: hr_utility.trace(' Sequence details ');
291: hr_utility.trace('OTL Sequence : '||l_seq_table(i).otl_sequence);
292: hr_utility.trace('IV Id : '||l_seq_table(i).input_value_id);
293: hr_utility.trace('Name : '||l_seq_table(i).name);
294: hr_utility.trace('UOM : '||l_seq_table(i).UOM);

Line 291: hr_utility.trace('OTL Sequence : '||l_seq_table(i).otl_sequence);

287:
288: IF g_debug
289: THEN
290: hr_utility.trace(' Sequence details ');
291: hr_utility.trace('OTL Sequence : '||l_seq_table(i).otl_sequence);
292: hr_utility.trace('IV Id : '||l_seq_table(i).input_value_id);
293: hr_utility.trace('Name : '||l_seq_table(i).name);
294: hr_utility.trace('UOM : '||l_seq_table(i).UOM);
295: hr_utility.trace('Lookup type : '||l_seq_table(i).lookup_type);

Line 292: hr_utility.trace('IV Id : '||l_seq_table(i).input_value_id);

288: IF g_debug
289: THEN
290: hr_utility.trace(' Sequence details ');
291: hr_utility.trace('OTL Sequence : '||l_seq_table(i).otl_sequence);
292: hr_utility.trace('IV Id : '||l_seq_table(i).input_value_id);
293: hr_utility.trace('Name : '||l_seq_table(i).name);
294: hr_utility.trace('UOM : '||l_seq_table(i).UOM);
295: hr_utility.trace('Lookup type : '||l_seq_table(i).lookup_type);
296: END IF;

Line 293: hr_utility.trace('Name : '||l_seq_table(i).name);

289: THEN
290: hr_utility.trace(' Sequence details ');
291: hr_utility.trace('OTL Sequence : '||l_seq_table(i).otl_sequence);
292: hr_utility.trace('IV Id : '||l_seq_table(i).input_value_id);
293: hr_utility.trace('Name : '||l_seq_table(i).name);
294: hr_utility.trace('UOM : '||l_seq_table(i).UOM);
295: hr_utility.trace('Lookup type : '||l_seq_table(i).lookup_type);
296: END IF;
297: --

Line 294: hr_utility.trace('UOM : '||l_seq_table(i).UOM);

290: hr_utility.trace(' Sequence details ');
291: hr_utility.trace('OTL Sequence : '||l_seq_table(i).otl_sequence);
292: hr_utility.trace('IV Id : '||l_seq_table(i).input_value_id);
293: hr_utility.trace('Name : '||l_seq_table(i).name);
294: hr_utility.trace('UOM : '||l_seq_table(i).UOM);
295: hr_utility.trace('Lookup type : '||l_seq_table(i).lookup_type);
296: END IF;
297: --
298: fetched_input_value := l_seq_table(i);

Line 295: hr_utility.trace('Lookup type : '||l_seq_table(i).lookup_type);

291: hr_utility.trace('OTL Sequence : '||l_seq_table(i).otl_sequence);
292: hr_utility.trace('IV Id : '||l_seq_table(i).input_value_id);
293: hr_utility.trace('Name : '||l_seq_table(i).name);
294: hr_utility.trace('UOM : '||l_seq_table(i).UOM);
295: hr_utility.trace('Lookup type : '||l_seq_table(i).lookup_type);
296: END IF;
297: --
298: fetched_input_value := l_seq_table(i);
299: input_value_number := i;

Line 483: g_debug := hr_utility.debug_enabled;

479: TYPE NUMTAB IS TABLE OF NUMBER;
480: l_tc_tab NUMTAB;
481:
482: BEGIN
483: g_debug := hr_utility.debug_enabled;
484:
485: IF g_debug THEN
486: l_proc := 'hxt_batch_process.merge_batches';
487: hr_utility.set_location('Entering: '||l_proc, 10);

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

483: g_debug := hr_utility.debug_enabled;
484:
485: IF g_debug THEN
486: l_proc := 'hxt_batch_process.merge_batches';
487: hr_utility.set_location('Entering: '||l_proc, 10);
488: END IF;
489:
490: l_batch_name := p_merge_batch_name;
491:

Line 509: hr_utility.set_location('Inside merge_batches proc loop: '||p_merge_batches(l_loop_index1).batch_id, 20);

505:
506: EXIT WHEN NOT p_merge_batches.exists(l_loop_index1);
507:
508: IF g_debug THEN
509: hr_utility.set_location('Inside merge_batches proc loop: '||p_merge_batches(l_loop_index1).batch_id, 20);
510: END IF;
511:
512: l_temp_batch_upd_id := null;
513: l_batch_type := null;

Line 520: hr_utility.set_location('Before creating new valid batch header', 30);

516:
517: IF l_valid_batch_id is null THEN
518: l_valid_batch_name := l_batch_name;
519: IF g_debug THEN
520: hr_utility.set_location('Before creating new valid batch header', 30);
521: END IF;
522: pay_batch_element_entry_api.create_batch_header (p_session_date => sysdate,
523: p_batch_name => l_valid_batch_name,
524: p_business_group_id => p_bus_group_id,

Line 533: hr_utility.set_location('After creating new valid batch header: '||l_valid_batch_id, 40);

529: p_batch_id => l_valid_batch_id,
530: p_object_version_number => l_object_version_number
531: ); /* For creating new batch for valid Tcs. */
532: IF g_debug THEN
533: hr_utility.set_location('After creating new valid batch header: '||l_valid_batch_id, 40);
534: END IF;
535: l_valid_batch_name := l_valid_batch_name||l_string2||to_char(l_valid_batch_id);
536: pay_batch_element_entry_api.update_batch_header (p_session_date => sysdate,
537: p_batch_id => l_valid_batch_id,

Line 545: hr_utility.set_location('After updating valid batch name: '||l_valid_batch_name, 50);

541:
542: fnd_file.put_line (fnd_file.log, 'Successful Batch Name: '||l_valid_batch_name);
543:
544: IF g_debug THEN
545: hr_utility.set_location('After updating valid batch name: '||l_valid_batch_name, 50);
546: END IF;
547: BEGIN
548: UPDATE hxt_batch_states
549: SET status = 'VV'

Line 553: hr_utility.set_location('After updating valid batch status in hxt_batch_states', 60);

549: SET status = 'VV'
550: WHERE batch_id = l_valid_batch_id; /* For updating the status of the newly created batch */
551: END;
552: IF g_debug THEN
553: hr_utility.set_location('After updating valid batch status in hxt_batch_states', 60);
554: END IF;
555: END IF;
556:
557: l_temp_batch_upd_id := l_valid_batch_id;

Line 564: hr_utility.set_location('Before creating new warning batch header', 70);

560:
561: IF l_warning_batch_id is null THEN
562: l_warning_batch_name := l_batch_name||'_W';
563: IF g_debug THEN
564: hr_utility.set_location('Before creating new warning batch header', 70);
565: END IF;
566: pay_batch_element_entry_api.create_batch_header (p_session_date => sysdate,
567: p_batch_name => l_warning_batch_name,
568: p_business_group_id => p_bus_group_id,

Line 577: hr_utility.set_location('After creating new warning batch header: '||l_warning_batch_id, 80);

573: p_batch_id => l_warning_batch_id,
574: p_object_version_number => l_object_version_number
575: ); /* For creating new batch for warning Tcs. */
576: IF g_debug THEN
577: hr_utility.set_location('After creating new warning batch header: '||l_warning_batch_id, 80);
578: END IF;
579: l_warning_batch_name := l_warning_batch_name||l_string2||to_char(l_warning_batch_id);
580: pay_batch_element_entry_api.update_batch_header (p_session_date => sysdate,
581: p_batch_id => l_warning_batch_id,

Line 589: hr_utility.set_location('After updating warning batch name: '||l_warning_batch_name, 90);

585:
586: fnd_file.put_line (fnd_file.log, 'Warning Batch Name: '||l_warning_batch_name);
587:
588: IF g_debug THEN
589: hr_utility.set_location('After updating warning batch name: '||l_warning_batch_name, 90);
590: END IF;
591: BEGIN
592: UPDATE hxt_batch_states
593: SET status = 'VW'

Line 597: hr_utility.set_location('After updating warning batch status in hxt_batch_states', 100);

593: SET status = 'VW'
594: WHERE batch_id = l_warning_batch_id; /* For updating the status of the newly created batch */
595: END;
596: IF g_debug THEN
597: hr_utility.set_location('After updating warning batch status in hxt_batch_states', 100);
598: END IF;
599: END IF;
600:
601: l_temp_batch_upd_id := l_warning_batch_id;

Line 609: hr_utility.set_location('Before creating new error batch header', 110);

605:
606: IF l_error_batch_id is null THEN
607: l_error_batch_name := l_batch_name||'_E';
608: IF g_debug THEN
609: hr_utility.set_location('Before creating new error batch header', 110);
610: END IF;
611: pay_batch_element_entry_api.create_batch_header (p_session_date => sysdate,
612: p_batch_name => l_error_batch_name,
613: p_business_group_id => p_bus_group_id,

Line 622: hr_utility.set_location('after creating new error batch header: '||l_error_batch_id, 120);

618: p_batch_id => l_error_batch_id,
619: p_object_version_number => l_object_version_number
620: ); /* For creating new batch for erroded Tcs. */
621: IF g_debug THEN
622: hr_utility.set_location('after creating new error batch header: '||l_error_batch_id, 120);
623: END IF;
624: l_error_batch_name := l_error_batch_name||l_string2||to_char(l_error_batch_id);
625: pay_batch_element_entry_api.update_batch_header (p_session_date => sysdate,
626: p_batch_id => l_error_batch_id,

Line 634: hr_utility.set_location('After updating error batch name: '||l_error_batch_name, 130);

630:
631: fnd_file.put_line (fnd_file.log, 'Error Batch Name: '||l_error_batch_name);
632:
633: IF g_debug THEN
634: hr_utility.set_location('After updating error batch name: '||l_error_batch_name, 130);
635: END IF;
636: BEGIN
637: UPDATE hxt_batch_states
638: SET status = 'VE'

Line 642: hr_utility.set_location('After updating error batch status in hxt_batch_states', 140);

638: SET status = 'VE'
639: WHERE batch_id = l_error_batch_id; /* For updating the status of the newly created batch */
640: END;
641: IF g_debug THEN
642: hr_utility.set_location('After updating error batch status in hxt_batch_states', 140);
643: END IF;
644: END IF;
645:
646: l_temp_batch_upd_id := l_error_batch_id;

Line 652: hr_utility.set_location('Before updating TC reference: '||p_merge_batches(l_loop_index1).tc_id||

648:
649: END IF;
650:
651: IF g_debug THEN
652: hr_utility.set_location('Before updating TC reference: '||p_merge_batches(l_loop_index1).tc_id||
653: ' Mode: '||p_mode, 150);
654: END IF;
655:
656: IF p_mode = 'NR' THEN /* For updating the TC references of Non-Retro Batches to the newly created batch */

Line 695: hr_utility.trace('List of timecards updated in hxc_ret_pay_latest_details ');

691: BULK COLLECT INTO l_tc_tab;
692:
693: IF l_tc_tab.COUNT > 0
694: THEN
695: hr_utility.trace('List of timecards updated in hxc_ret_pay_latest_details ');
696: FOR i IN l_tc_tab.FIRST..l_tc_tab.LAST
697: LOOP
698: hr_utility.trace(' Timecard id '||l_tc_tab(i));
699: END LOOP;

Line 698: hr_utility.trace(' Timecard id '||l_tc_tab(i));

694: THEN
695: hr_utility.trace('List of timecards updated in hxc_ret_pay_latest_details ');
696: FOR i IN l_tc_tab.FIRST..l_tc_tab.LAST
697: LOOP
698: hr_utility.trace(' Timecard id '||l_tc_tab(i));
699: END LOOP;
700: END IF;
701:
702: l_tc_tab := NUMTAB();

Line 712: hr_utility.trace('List of timecards updated in hxc_ret_pay_details ');

708: BULK COLLECT INTO l_tc_tab;
709:
710: IF l_tc_tab.COUNT > 0
711: THEN
712: hr_utility.trace('List of timecards updated in hxc_ret_pay_details ');
713: FOR i IN l_tc_tab.FIRST..l_tc_tab.LAST
714: LOOP
715: hr_utility.trace(' Timecard id '||l_tc_tab(i));
716: END LOOP;

Line 715: hr_utility.trace(' Timecard id '||l_tc_tab(i));

711: THEN
712: hr_utility.trace('List of timecards updated in hxc_ret_pay_details ');
713: FOR i IN l_tc_tab.FIRST..l_tc_tab.LAST
714: LOOP
715: hr_utility.trace(' Timecard id '||l_tc_tab(i));
716: END LOOP;
717: END IF;
718:
719:

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

741: EXCEPTION
742: WHEN others THEN
743: null;
744: -- Bug 10143866
745: hr_utility.trace(dbms_utility.format_error_backtrace);
746:
747: END;
748:
749: fnd_file.put_line (fnd_file.log, 'Assignment# = '|| l_assignment_no||

Line 756: hr_utility.set_location('After updating TC reference', 160);

752:
753: END IF;
754:
755: IF g_debug THEN
756: hr_utility.set_location('After updating TC reference', 160);
757: END IF;
758:
759: l_loop_index1 := p_merge_batches.next(l_loop_index1);
760:

Line 769: hr_utility.set_location('Before deleting empty batches: '||p_del_empty_batches(l_loop_index2).batch_id||

765: LOOP /* To loop through empty batches left behind and delete them */
766:
767: EXIT WHEN NOT p_del_empty_batches.exists(l_loop_index2);
768: IF g_debug THEN
769: hr_utility.set_location('Before deleting empty batches: '||p_del_empty_batches(l_loop_index2).batch_id||
770: ' ovn: '||p_del_empty_batches(l_loop_index2).batch_ovn, 170);
771: END IF;
772:
773: pay_batch_element_entry_api.delete_batch_header (p_batch_id => p_del_empty_batches(l_loop_index2).batch_id,

Line 777: hr_utility.set_location('After deleting empty batches', 180);

773: pay_batch_element_entry_api.delete_batch_header (p_batch_id => p_del_empty_batches(l_loop_index2).batch_id,
774: p_object_version_number => p_del_empty_batches(l_loop_index2).batch_ovn
775: );
776: IF g_debug THEN
777: hr_utility.set_location('After deleting empty batches', 180);
778: END IF;
779:
780: BEGIN
781: DELETE FROM hxt_batch_states

Line 786: hr_utility.set_location('After deleting empty batches from hxt_batch_states', 190);

782: WHERE batch_id = p_del_empty_batches(l_loop_index2).batch_id;
783: END;
784:
785: IF g_debug THEN
786: hr_utility.set_location('After deleting empty batches from hxt_batch_states', 190);
787: END IF;
788:
789: l_loop_index2 := p_del_empty_batches.next(l_loop_index2);
790:

Line 794: hr_utility.set_location('Leaving: '||l_proc, 200);

790:
791: END LOOP;
792:
793: IF g_debug THEN
794: hr_utility.set_location('Leaving: '||l_proc, 200);
795: END IF;
796:
797: END merge_batches;
798:

Line 902: g_debug :=hr_utility.debug_enabled;

898:
899: /********Bug: 4620315 **********/
900:
901: BEGIN
902: g_debug :=hr_utility.debug_enabled;
903: if g_debug then
904: hr_utility.trace(p_bus_group_id);
905: hr_utility.trace(g_time_period_id);
906: hr_utility.trace(l_batch_requested);

Line 904: hr_utility.trace(p_bus_group_id);

900:
901: BEGIN
902: g_debug :=hr_utility.debug_enabled;
903: if g_debug then
904: hr_utility.trace(p_bus_group_id);
905: hr_utility.trace(g_time_period_id);
906: hr_utility.trace(l_batch_requested);
907: hr_utility.trace( p_ref_num);
908: end if;

Line 905: hr_utility.trace(g_time_period_id);

901: BEGIN
902: g_debug :=hr_utility.debug_enabled;
903: if g_debug then
904: hr_utility.trace(p_bus_group_id);
905: hr_utility.trace(g_time_period_id);
906: hr_utility.trace(l_batch_requested);
907: hr_utility.trace( p_ref_num);
908: end if;
909:

Line 906: hr_utility.trace(l_batch_requested);

902: g_debug :=hr_utility.debug_enabled;
903: if g_debug then
904: hr_utility.trace(p_bus_group_id);
905: hr_utility.trace(g_time_period_id);
906: hr_utility.trace(l_batch_requested);
907: hr_utility.trace( p_ref_num);
908: end if;
909:
910:

Line 907: hr_utility.trace( p_ref_num);

903: if g_debug then
904: hr_utility.trace(p_bus_group_id);
905: hr_utility.trace(g_time_period_id);
906: hr_utility.trace(l_batch_requested);
907: hr_utility.trace( p_ref_num);
908: end if;
909:
910:
911: l_date_earned := to_date(to_char(trunc(l_date_earned),'DD/MM/RRRR'),'DD/MM/RRRR');

Line 996: hr_utility.trace('Populating del_empty_batches record: '||'batchid: '||batch_rec.batch_id||

992: /*** To record the empty batch details ***/
993:
994: IF p_merge_flag = '1' THEN
995: IF g_debug THEN
996: hr_utility.trace('Populating del_empty_batches record: '||'batchid: '||batch_rec.batch_id||
997: ' ovn '||batch_rec.object_version_number);
998: END IF;
999: l_cnt := NVL(l_del_empty_batches.LAST,0) +1;
1000: l_del_empty_batches(l_cnt).batch_id := batch_rec.batch_id;

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

1175: b_we_have_batches := FALSE;
1176: END IF;
1177: -- Bug 10143866
1178: -- Added this logging in case of a NO_DATA_FOUND.
1179: hr_utility.trace(dbms_utility.format_error_backtrace);
1180: hr_utility.trace('Batch '||l_batch_id||' threw a NO_DATA_FOUND');
1181: hr_utility.trace('Backtrace this error to Batch validation log ');
1182: hr_utility.trace('Skipping to next batch ');
1183: WHEN g_lookup_not_found THEN --SIR517 PWM 18FEB00

Line 1180: hr_utility.trace('Batch '||l_batch_id||' threw a NO_DATA_FOUND');

1176: END IF;
1177: -- Bug 10143866
1178: -- Added this logging in case of a NO_DATA_FOUND.
1179: hr_utility.trace(dbms_utility.format_error_backtrace);
1180: hr_utility.trace('Batch '||l_batch_id||' threw a NO_DATA_FOUND');
1181: hr_utility.trace('Backtrace this error to Batch validation log ');
1182: hr_utility.trace('Skipping to next batch ');
1183: WHEN g_lookup_not_found THEN --SIR517 PWM 18FEB00
1184: raise g_lookup_not_found ; --propogate to the next level

Line 1181: hr_utility.trace('Backtrace this error to Batch validation log ');

1177: -- Bug 10143866
1178: -- Added this logging in case of a NO_DATA_FOUND.
1179: hr_utility.trace(dbms_utility.format_error_backtrace);
1180: hr_utility.trace('Batch '||l_batch_id||' threw a NO_DATA_FOUND');
1181: hr_utility.trace('Backtrace this error to Batch validation log ');
1182: hr_utility.trace('Skipping to next batch ');
1183: WHEN g_lookup_not_found THEN --SIR517 PWM 18FEB00
1184: raise g_lookup_not_found ; --propogate to the next level
1185: WHEN g_rollback_error THEN

Line 1182: hr_utility.trace('Skipping to next batch ');

1178: -- Added this logging in case of a NO_DATA_FOUND.
1179: hr_utility.trace(dbms_utility.format_error_backtrace);
1180: hr_utility.trace('Batch '||l_batch_id||' threw a NO_DATA_FOUND');
1181: hr_utility.trace('Backtrace this error to Batch validation log ');
1182: hr_utility.trace('Skipping to next batch ');
1183: WHEN g_lookup_not_found THEN --SIR517 PWM 18FEB00
1184: raise g_lookup_not_found ; --propogate to the next level
1185: WHEN g_rollback_error THEN
1186: -- Bug 10143866

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

1183: WHEN g_lookup_not_found THEN --SIR517 PWM 18FEB00
1184: raise g_lookup_not_found ; --propogate to the next level
1185: WHEN g_rollback_error THEN
1186: -- Bug 10143866
1187: hr_utility.trace(dbms_utility.format_error_backtrace);
1188: FND_FILE.put_line(fnd_file.log,'Rollback errored out ');
1189: -- Set_Batch_Status(l_date_earned, l_batch_id, 'VE');
1190: --commit;
1191: raise g_rollback_error;

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

1190: --commit;
1191: raise g_rollback_error;
1192: WHEN OTHERS THEN
1193: -- Bug 10143866
1194: hr_utility.trace(dbms_utility.format_error_backtrace);
1195: Set_Batch_Status(l_date_earned, l_batch_id, 'VE');
1196: Insert_Pay_Batch_Errors( l_batch_id,
1197: 'VE',
1198: sqlerrm,

Line 1266: hr_utility.trace('Before calling merge_batches proc');

1262: /*** To merge the batch TCs by calling 'merge_batches' procedure ***/
1263:
1264: IF p_merge_flag = '1' and p_process_mode = 'V' THEN
1265: IF g_debug THEN
1266: hr_utility.trace('Before calling merge_batches proc');
1267: END IF;
1268: merge_batches (p_merge_batch_name,
1269: l_merge_batches,
1270: l_del_empty_batches,

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

1301: FND_FILE.put_line(fnd_file.log,errbuf);
1302: raise;
1303: WHEN OTHERS THEN
1304: -- Bug 10143866
1305: hr_utility.trace(dbms_utility.format_error_backtrace);
1306: retcode := 2;
1307: FND_MESSAGE.SET_NAME('HXT','HXT_39363_SYSTEM_ERROR');
1308: l_errbuf := FND_MESSAGE.GET;
1309: FND_MESSAGE.CLEAR;

Line 1338: hr_utility.set_location('convert_lookup',10);

1334: AND nvl(fcl.end_date_active, p_date);
1335: BEGIN
1336:
1337: if g_debug then
1338: hr_utility.set_location('convert_lookup',10);
1339: end if;
1340: HXT_UTIL.DEBUG('convert_lookup - code = '||p_lookup_code||'
1341: type = '||p_lookup_type||' date = '||fnd_date.date_to_chardate(p_date_active));
1342:

Line 1351: hr_utility.set_location('convert_lookup',20);

1347: IF p_lookup_type IS NOT NULL AND p_lookup_code IS NOT NULL
1348: AND g_IV_format = 'N'
1349: THEN
1350: if g_debug then
1351: hr_utility.set_location('convert_lookup',20);
1352: end if;
1353: OPEN get_meaning_cur(p_lookup_code, p_lookup_type, p_date_active);
1354: FETCH get_meaning_cur into l_meaning;
1355: if g_debug then

Line 1356: hr_utility.trace('l_meaning :'||l_meaning);

1352: end if;
1353: OPEN get_meaning_cur(p_lookup_code, p_lookup_type, p_date_active);
1354: FETCH get_meaning_cur into l_meaning;
1355: if g_debug then
1356: hr_utility.trace('l_meaning :'||l_meaning);
1357: end if;
1358: IF get_meaning_cur%NOTFOUND then
1359: if g_debug then
1360: hr_utility.set_location('convert_lookup',30);

Line 1360: hr_utility.set_location('convert_lookup',30);

1356: hr_utility.trace('l_meaning :'||l_meaning);
1357: end if;
1358: IF get_meaning_cur%NOTFOUND then
1359: if g_debug then
1360: hr_utility.set_location('convert_lookup',30);
1361: end if;
1362: FND_MESSAGE.SET_NAME('HXT','HXT_39483_LOOKUP_NOT_FOUND');
1363: FND_MESSAGE.SET_TOKEN('CODE', p_lookup_code);
1364: FND_MESSAGE.SET_TOKEN('TYPE', p_lookup_type);

Line 1369: hr_utility.set_location('convert_lookup',40);

1365: RAISE g_lookup_not_found;
1366: END IF;
1367: ELSE
1368: if g_debug then
1369: hr_utility.set_location('convert_lookup',40);
1370: end if;
1371: l_meaning := p_lookup_code;
1372: if g_debug then
1373: hr_utility.trace('l_meaning :'||l_meaning);

Line 1373: hr_utility.trace('l_meaning :'||l_meaning);

1369: hr_utility.set_location('convert_lookup',40);
1370: end if;
1371: l_meaning := p_lookup_code;
1372: if g_debug then
1373: hr_utility.trace('l_meaning :'||l_meaning);
1374: end if;
1375: END IF;
1376: if g_debug then
1377: hr_utility.set_location('convert_lookup',50);

Line 1377: hr_utility.set_location('convert_lookup',50);

1373: hr_utility.trace('l_meaning :'||l_meaning);
1374: end if;
1375: END IF;
1376: if g_debug then
1377: hr_utility.set_location('convert_lookup',50);
1378: end if;
1379: RETURN l_meaning;
1380: END convert_lookup;
1381: --

Line 1398: g_debug :=hr_utility.debug_enabled;

1394: AND enabled_flag = 'Y'
1395: AND p_date_active BETWEEN nvl(start_date_active, p_date_active)
1396: AND nvl(end_date_active, p_date_active);
1397: BEGIN
1398: g_debug :=hr_utility.debug_enabled;
1399: if g_debug then
1400: hr_utility.set_location('get_lookup_code',10);
1401: end if;
1402: HXT_UTIL.DEBUG('get_lookup_ code for meaning = '||p_meaning||'

Line 1400: hr_utility.set_location('get_lookup_code',10);

1396: AND nvl(end_date_active, p_date_active);
1397: BEGIN
1398: g_debug :=hr_utility.debug_enabled;
1399: if g_debug then
1400: hr_utility.set_location('get_lookup_code',10);
1401: end if;
1402: HXT_UTIL.DEBUG('get_lookup_ code for meaning = '||p_meaning||'
1403: type = '||'NAME_TRANSLATIONS'||' date = '||fnd_date.date_to_chardate(p_date_active));
1404: if g_debug then

Line 1405: hr_utility.trace('p_meaning :'||p_meaning);

1401: end if;
1402: HXT_UTIL.DEBUG('get_lookup_ code for meaning = '||p_meaning||'
1403: type = '||'NAME_TRANSLATIONS'||' date = '||fnd_date.date_to_chardate(p_date_active));
1404: if g_debug then
1405: hr_utility.trace('p_meaning :'||p_meaning);
1406: end if;
1407: IF p_meaning IS NOT NULL THEN
1408: if g_debug then
1409: hr_utility.set_location('get_lookup_code',20);

Line 1409: hr_utility.set_location('get_lookup_code',20);

1405: hr_utility.trace('p_meaning :'||p_meaning);
1406: end if;
1407: IF p_meaning IS NOT NULL THEN
1408: if g_debug then
1409: hr_utility.set_location('get_lookup_code',20);
1410: end if;
1411: OPEN get_lookup_code_cur;
1412: FETCH get_lookup_code_cur into l_lookup_code;
1413: if g_debug then

Line 1414: hr_utility.trace('l_lookup_code :'||l_lookup_code);

1410: end if;
1411: OPEN get_lookup_code_cur;
1412: FETCH get_lookup_code_cur into l_lookup_code;
1413: if g_debug then
1414: hr_utility.trace('l_lookup_code :'||l_lookup_code);
1415: end if;
1416: IF get_lookup_code_cur%NOTFOUND then
1417: if g_debug then
1418: hr_utility.set_location('get_lookup_code',30);

Line 1418: hr_utility.set_location('get_lookup_code',30);

1414: hr_utility.trace('l_lookup_code :'||l_lookup_code);
1415: end if;
1416: IF get_lookup_code_cur%NOTFOUND then
1417: if g_debug then
1418: hr_utility.set_location('get_lookup_code',30);
1419: hr_utility.trace('get_lookup_code_cur NOT FOUND');
1420: end if;
1421: -- FND_MESSAGE.SET_NAME('HXT','HXT_39483_LOOKUP_NOT_FOUND');
1422: -- FND_MESSAGE.SET_TOKEN('CODE', p_meaning); --SIR517 PWM 18FEB00

Line 1419: hr_utility.trace('get_lookup_code_cur NOT FOUND');

1415: end if;
1416: IF get_lookup_code_cur%NOTFOUND then
1417: if g_debug then
1418: hr_utility.set_location('get_lookup_code',30);
1419: hr_utility.trace('get_lookup_code_cur NOT FOUND');
1420: end if;
1421: -- FND_MESSAGE.SET_NAME('HXT','HXT_39483_LOOKUP_NOT_FOUND');
1422: -- FND_MESSAGE.SET_TOKEN('CODE', p_meaning); --SIR517 PWM 18FEB00
1423: -- FND_MESSAGE.SET_TOKEN('TYPE', 'NAME_TRANSLATIONS'); --SIR517 PWM 18FEB00

Line 1429: hr_utility.set_location('get_lookup_code',40);

1425: null; -- This is done to fix bug 1761779 -- 17/May/2001
1426: END IF;
1427: ELSE
1428: if g_debug then
1429: hr_utility.set_location('get_lookup_code',40);
1430: end if;
1431: l_lookup_code := p_meaning;
1432: if g_debug then
1433: hr_utility.trace('p_meaning is null');

Line 1433: hr_utility.trace('p_meaning is null');

1429: hr_utility.set_location('get_lookup_code',40);
1430: end if;
1431: l_lookup_code := p_meaning;
1432: if g_debug then
1433: hr_utility.trace('p_meaning is null');
1434: hr_utility.trace('l_lookup_code:'||l_lookup_code);
1435: end if;
1436: END IF;
1437: if g_debug then

Line 1434: hr_utility.trace('l_lookup_code:'||l_lookup_code);

1430: end if;
1431: l_lookup_code := p_meaning;
1432: if g_debug then
1433: hr_utility.trace('p_meaning is null');
1434: hr_utility.trace('l_lookup_code:'||l_lookup_code);
1435: end if;
1436: END IF;
1437: if g_debug then
1438: hr_utility.trace('l_lookup_code :'||l_lookup_code);

Line 1438: hr_utility.trace('l_lookup_code :'||l_lookup_code);

1434: hr_utility.trace('l_lookup_code:'||l_lookup_code);
1435: end if;
1436: END IF;
1437: if g_debug then
1438: hr_utility.trace('l_lookup_code :'||l_lookup_code);
1439: hr_utility.set_location('get_lookup_code',50);
1440: end if;
1441: RETURN l_lookup_code;
1442: END get_lookup_code;

Line 1439: hr_utility.set_location('get_lookup_code',50);

1435: end if;
1436: END IF;
1437: if g_debug then
1438: hr_utility.trace('l_lookup_code :'||l_lookup_code);
1439: hr_utility.set_location('get_lookup_code',50);
1440: end if;
1441: RETURN l_lookup_code;
1442: END get_lookup_code;
1443: -- Place OTM data into BEE values per input values

Line 1702: hr_utility.set_location('dtl_to_BEE',10);

1698:
1699: BEGIN
1700:
1701: if g_debug then
1702: hr_utility.set_location('dtl_to_BEE',10);
1703: end if;
1704: -- Initialize table
1705: FOR i in 1..15 LOOP
1706: hxt_value(i).sequence := null;

Line 1797: hr_utility.set_location('dtl_to_BEE',20);

1793: hxt_value(14).otl_sequence,
1794: hxt_value(15).otl_sequence
1795: );
1796: if g_debug then
1797: hr_utility.set_location('dtl_to_BEE',20);
1798: end if;
1799: -- Place OTM data into BEE values per input values
1800: HXT_UTIL.DEBUG('Putting OTM data into BEE values per input values'); --HXT115
1801: --

Line 1827: hr_utility.set_location('dtl_to_BEE',30);

1823: -- processing the further logic on the screen value for the input values.
1824: --
1825: lv_pbl_flag := 'N';
1826: if g_debug then
1827: hr_utility.set_location('dtl_to_BEE',30);
1828: hr_utility.trace('hxt_value_name_'||to_char(i)||' :'|| hxt_value(i).name);
1829: hr_utility.trace('p_values_rec.date_worked:'||p_values_rec.date_worked);
1830: end if;
1831: l_value_meaning := get_lookup_code (hxt_value(i).name,

Line 1828: hr_utility.trace('hxt_value_name_'||to_char(i)||' :'|| hxt_value(i).name);

1824: --
1825: lv_pbl_flag := 'N';
1826: if g_debug then
1827: hr_utility.set_location('dtl_to_BEE',30);
1828: hr_utility.trace('hxt_value_name_'||to_char(i)||' :'|| hxt_value(i).name);
1829: hr_utility.trace('p_values_rec.date_worked:'||p_values_rec.date_worked);
1830: end if;
1831: l_value_meaning := get_lookup_code (hxt_value(i).name,
1832: p_values_rec.date_worked);

Line 1829: hr_utility.trace('p_values_rec.date_worked:'||p_values_rec.date_worked);

1825: lv_pbl_flag := 'N';
1826: if g_debug then
1827: hr_utility.set_location('dtl_to_BEE',30);
1828: hr_utility.trace('hxt_value_name_'||to_char(i)||' :'|| hxt_value(i).name);
1829: hr_utility.trace('p_values_rec.date_worked:'||p_values_rec.date_worked);
1830: end if;
1831: l_value_meaning := get_lookup_code (hxt_value(i).name,
1832: p_values_rec.date_worked);
1833: if g_debug then

Line 1834: hr_utility.trace('l_value_meaning :'|| l_value_meaning);

1830: end if;
1831: l_value_meaning := get_lookup_code (hxt_value(i).name,
1832: p_values_rec.date_worked);
1833: if g_debug then
1834: hr_utility.trace('l_value_meaning :'|| l_value_meaning);
1835: end if;
1836: if l_value_meaning = 'HOURS' then
1837: if g_debug then
1838: hr_utility.set_location('dtl_to_BEE',40);

Line 1838: hr_utility.set_location('dtl_to_BEE',40);

1834: hr_utility.trace('l_value_meaning :'|| l_value_meaning);
1835: end if;
1836: if l_value_meaning = 'HOURS' then
1837: if g_debug then
1838: hr_utility.set_location('dtl_to_BEE',40);
1839: end if;
1840:
1841: -- Bug 13777315
1842: -- If IV Upgrade is done, there is no need to convert anything.

Line 1859: hr_utility.trace('pbl_value_'||to_char(i)||' :'|| pbl_value(i));

1855:
1856: END IF;
1857:
1858: if g_debug then
1859: hr_utility.trace('pbl_value_'||to_char(i)||' :'|| pbl_value(i));
1860: end if;
1861: elsif l_value_meaning = 'AMOUNT' then
1862: if g_debug then
1863: hr_utility.set_location('dtl_to_BEE',50);

Line 1863: hr_utility.set_location('dtl_to_BEE',50);

1859: hr_utility.trace('pbl_value_'||to_char(i)||' :'|| pbl_value(i));
1860: end if;
1861: elsif l_value_meaning = 'AMOUNT' then
1862: if g_debug then
1863: hr_utility.set_location('dtl_to_BEE',50);
1864: end if;
1865:
1866: -- Bug 13777315
1867: IF g_iv_upgrade = 'N'

Line 1879: hr_utility.trace('pbl_value_'||to_char(i)||' :'|| pbl_value(i));

1875: pbl_value(i) := FND_NUMBER.number_to_canonical(p_values_rec.amount);
1876: END IF;
1877:
1878: if g_debug then
1879: hr_utility.trace('pbl_value_'||to_char(i)||' :'|| pbl_value(i));
1880: end if;
1881: elsif l_value_meaning = 'RATE_MULTIPLE' then
1882: if g_debug then
1883: hr_utility.set_location('dtl_to_BEE',60);

Line 1883: hr_utility.set_location('dtl_to_BEE',60);

1879: hr_utility.trace('pbl_value_'||to_char(i)||' :'|| pbl_value(i));
1880: end if;
1881: elsif l_value_meaning = 'RATE_MULTIPLE' then
1882: if g_debug then
1883: hr_utility.set_location('dtl_to_BEE',60);
1884: end if;
1885:
1886: -- Bug 13777315
1887: IF g_iv_upgrade = 'N'

Line 1899: hr_utility.trace('pbl_value_'||to_char(i)||' :'|| pbl_value(i));

1895: pbl_value(i) := FND_NUMBER.number_to_canonical(p_values_rec.rate_multiple);
1896: END IF;
1897:
1898: if g_debug then
1899: hr_utility.trace('pbl_value_'||to_char(i)||' :'|| pbl_value(i));
1900: end if;
1901: elsif l_value_meaning = 'HOURLY_RATE' then
1902: if g_debug then
1903: hr_utility.set_location('dtl_to_BEE',70);

Line 1903: hr_utility.set_location('dtl_to_BEE',70);

1899: hr_utility.trace('pbl_value_'||to_char(i)||' :'|| pbl_value(i));
1900: end if;
1901: elsif l_value_meaning = 'HOURLY_RATE' then
1902: if g_debug then
1903: hr_utility.set_location('dtl_to_BEE',70);
1904: end if;
1905:
1906: -- Bug 13777315
1907: IF g_iv_upgrade = 'N'

Line 1919: hr_utility.trace('pbl_value_'||to_char(i)||' :'|| pbl_value(i));

1915: pbl_value(i) := FND_NUMBER.number_to_canonical(p_values_rec.hourly_rate);
1916: END IF;
1917:
1918: if g_debug then
1919: hr_utility.trace('pbl_value_'||to_char(i)||' :'|| pbl_value(i));
1920: end if;
1921: elsif l_value_meaning = 'RATE' then
1922: if g_debug then
1923: hr_utility.set_location('dtl_to_BEE',80);

Line 1923: hr_utility.set_location('dtl_to_BEE',80);

1919: hr_utility.trace('pbl_value_'||to_char(i)||' :'|| pbl_value(i));
1920: end if;
1921: elsif l_value_meaning = 'RATE' then
1922: if g_debug then
1923: hr_utility.set_location('dtl_to_BEE',80);
1924: end if;
1925:
1926: -- Bug 13777315
1927: IF g_iv_upgrade = 'N'

Line 1939: hr_utility.trace('pbl_value_'||to_char(i)||' :'|| pbl_value(i));

1935: pbl_value(i) := FND_NUMBER.number_to_canonical(p_values_rec.hourly_rate);
1936: END IF;
1937:
1938: if g_debug then
1939: hr_utility.trace('pbl_value_'||to_char(i)||' :'|| pbl_value(i));
1940: end if;
1941: elsif l_value_meaning = 'RATE_CODE' then
1942: if g_debug then
1943: hr_utility.set_location('dtl_to_BEE',90);

Line 1943: hr_utility.set_location('dtl_to_BEE',90);

1939: hr_utility.trace('pbl_value_'||to_char(i)||' :'|| pbl_value(i));
1940: end if;
1941: elsif l_value_meaning = 'RATE_CODE' then
1942: if g_debug then
1943: hr_utility.set_location('dtl_to_BEE',90);
1944: end if;
1945: pbl_value(i) := convert_lookup(p_values_rec.rate_code,
1946: hxt_value(i).lookup,
1947: p_values_rec.date_worked);

Line 1949: hr_utility.trace('pbl_value_'||to_char(i)||' :'|| pbl_value(i));

1945: pbl_value(i) := convert_lookup(p_values_rec.rate_code,
1946: hxt_value(i).lookup,
1947: p_values_rec.date_worked);
1948: if g_debug then
1949: hr_utility.trace('pbl_value_'||to_char(i)||' :'|| pbl_value(i));
1950: end if;
1951: -- BEGIN US localization
1952: elsif hxt_value(i).name = 'Jurisdiction' then
1953: if g_debug then

Line 1954: hr_utility.set_location('dtl_to_BEE',100);

1950: end if;
1951: -- BEGIN US localization
1952: elsif hxt_value(i).name = 'Jurisdiction' then
1953: if g_debug then
1954: hr_utility.set_location('dtl_to_BEE',100);
1955: end if;
1956: if( p_values_rec.state_name is not null or
1957: p_values_rec.county_name is not null or
1958: p_values_rec.city_name is not null or

Line 1974: hr_utility.trace('pbl_value_'||to_char(i)||' :'|| pbl_value(i));

1970: end if;
1971:
1972: if g_debug
1973: then
1974: hr_utility.trace('pbl_value_'||to_char(i)||' :'|| pbl_value(i));
1975: end if;
1976: elsif hxt_value(i).name = 'Deduction Processing' then
1977: if g_debug then
1978: hr_utility.set_location('dtl_to_BEE',110);

Line 1978: hr_utility.set_location('dtl_to_BEE',110);

1974: hr_utility.trace('pbl_value_'||to_char(i)||' :'|| pbl_value(i));
1975: end if;
1976: elsif hxt_value(i).name = 'Deduction Processing' then
1977: if g_debug then
1978: hr_utility.set_location('dtl_to_BEE',110);
1979: end if;
1980: pbl_value(i) := convert_lookup(p_values_rec.fcl_tax_rule_code,
1981: hxt_value(i).lookup,
1982: p_values_rec.date_worked);

Line 1984: hr_utility.trace('pbl_value_'||to_char(i)||' :'|| pbl_value(i));

1980: pbl_value(i) := convert_lookup(p_values_rec.fcl_tax_rule_code,
1981: hxt_value(i).lookup,
1982: p_values_rec.date_worked);
1983: if g_debug then
1984: hr_utility.trace('pbl_value_'||to_char(i)||' :'|| pbl_value(i));
1985: end if;
1986: elsif hxt_value(i).name = 'Separate Check' then
1987: if g_debug then
1988: hr_utility.set_location('dtl_to_BEE',120);

Line 1988: hr_utility.set_location('dtl_to_BEE',120);

1984: hr_utility.trace('pbl_value_'||to_char(i)||' :'|| pbl_value(i));
1985: end if;
1986: elsif hxt_value(i).name = 'Separate Check' then
1987: if g_debug then
1988: hr_utility.set_location('dtl_to_BEE',120);
1989: end if;
1990: pbl_value(i) := convert_lookup(p_values_rec.separate_check_flag,
1991: hxt_value(i).lookup,
1992: p_values_rec.date_worked);

Line 1994: hr_utility.trace('pbl_value_'||to_char(i)||' :'|| pbl_value(i));

1990: pbl_value(i) := convert_lookup(p_values_rec.separate_check_flag,
1991: hxt_value(i).lookup,
1992: p_values_rec.date_worked);
1993: if g_debug then
1994: hr_utility.trace('pbl_value_'||to_char(i)||' :'|| pbl_value(i));
1995: end if;
1996: -- END US localization
1997: elsif hxt_value(i).name is not null THEN -- pbl_value(i) := NULL;
1998: if g_debug then

Line 1999: hr_utility.set_location('dtl_to_BEE',130);

1995: end if;
1996: -- END US localization
1997: elsif hxt_value(i).name is not null THEN -- pbl_value(i) := NULL;
1998: if g_debug then
1999: hr_utility.set_location('dtl_to_BEE',130);
2000: end if;
2001: OPEN c_date_input_value(p_values_rec.element_type_id
2002: ,p_values_rec.assignment_id
2003: ,p_values_rec.date_worked);

Line 2006: hr_utility.set_location('dtl_to_BEE',140);

2002: ,p_values_rec.assignment_id
2003: ,p_values_rec.date_worked);
2004: LOOP
2005: if g_debug then
2006: hr_utility.set_location('dtl_to_BEE',140);
2007: end if;
2008: FETCH c_date_input_value into l_piv_name;
2009: EXIT WHEN c_date_input_value%NOTFOUND;
2010: if g_debug then

Line 2011: hr_utility.trace('l_piv_name :'||l_piv_name);

2007: end if;
2008: FETCH c_date_input_value into l_piv_name;
2009: EXIT WHEN c_date_input_value%NOTFOUND;
2010: if g_debug then
2011: hr_utility.trace('l_piv_name :'||l_piv_name);
2012: hr_utility.trace('lv_pbl_flag :'||lv_pbl_flag);
2013: end if;
2014: IF l_piv_name = hxt_value(i).name THEN
2015: if g_debug then

Line 2012: hr_utility.trace('lv_pbl_flag :'||lv_pbl_flag);

2008: FETCH c_date_input_value into l_piv_name;
2009: EXIT WHEN c_date_input_value%NOTFOUND;
2010: if g_debug then
2011: hr_utility.trace('l_piv_name :'||l_piv_name);
2012: hr_utility.trace('lv_pbl_flag :'||lv_pbl_flag);
2013: end if;
2014: IF l_piv_name = hxt_value(i).name THEN
2015: if g_debug then
2016: hr_utility.set_location('dtl_to_BEE',150);

Line 2016: hr_utility.set_location('dtl_to_BEE',150);

2012: hr_utility.trace('lv_pbl_flag :'||lv_pbl_flag);
2013: end if;
2014: IF l_piv_name = hxt_value(i).name THEN
2015: if g_debug then
2016: hr_utility.set_location('dtl_to_BEE',150);
2017: end if;
2018: -- pbl_value(i) := to_char(p_values_rec.date_worked,'DD-MON-YYYY');
2019: pbl_value(i) := fnd_date.date_to_canonical(p_values_rec.date_worked);
2020: lv_pbl_flag := 'Y';

Line 2022: hr_utility.trace('pbl_value_'||to_char(i)||' :'||pbl_value(i));

2018: -- pbl_value(i) := to_char(p_values_rec.date_worked,'DD-MON-YYYY');
2019: pbl_value(i) := fnd_date.date_to_canonical(p_values_rec.date_worked);
2020: lv_pbl_flag := 'Y';
2021: if g_debug then
2022: hr_utility.trace('pbl_value_'||to_char(i)||' :'||pbl_value(i));
2023: end if;
2024: exit;
2025: END IF;
2026: END LOOP;

Line 2032: hr_utility.trace('Before : lv_pbl_flag :'||lv_pbl_flag);

2028:
2029: -- Bug 9650990
2030: -- Do this processing only if pbl_value(i) is still not set for input values with non NULL name.
2031: if g_debug then
2032: hr_utility.trace('Before : lv_pbl_flag :'||lv_pbl_flag);
2033: end if;
2034:
2035: IF lv_pbl_flag = 'N' --THEN
2036: -- Bug 13639441

Line 2041: hr_utility.trace('Coming into new code as if profile is turned OFF');

2037: -- Added code here
2038: AND NVL(FND_PROFILE.VALUE('HXT_ALLOW_SUM_CUSTOM_ATTRIBUTE'),'N') = 'N'
2039: THEN
2040:
2041: hr_utility.trace('Coming into new code as if profile is turned OFF');
2042:
2043: -- Bug 8888777
2044: -- Control is here means that no fixed input value is encountered, but
2045: -- still some IV with a Non NULL name. Convert this and copy it.

Line 2153: hr_utility.set_location('dtl_to_BEE',160);

2149:
2150:
2151: if lv_pbl_flag = 'N' then
2152: if g_debug then
2153: hr_utility.set_location('dtl_to_BEE',160);
2154: end if;
2155: pbl_value(i) := NULL;
2156: if g_debug then
2157: hr_utility.trace('pbl_value_'||to_char(i)||' :'||pbl_value(i));

Line 2157: hr_utility.trace('pbl_value_'||to_char(i)||' :'||pbl_value(i));

2153: hr_utility.set_location('dtl_to_BEE',160);
2154: end if;
2155: pbl_value(i) := NULL;
2156: if g_debug then
2157: hr_utility.trace('pbl_value_'||to_char(i)||' :'||pbl_value(i));
2158: end if;
2159: end if;
2160: if g_debug then
2161: hr_utility.trace('lv_pbl_flag :'||lv_pbl_flag);

Line 2161: hr_utility.trace('lv_pbl_flag :'||lv_pbl_flag);

2157: hr_utility.trace('pbl_value_'||to_char(i)||' :'||pbl_value(i));
2158: end if;
2159: end if;
2160: if g_debug then
2161: hr_utility.trace('lv_pbl_flag :'||lv_pbl_flag);
2162: end if;
2163: else
2164: if g_debug then
2165: hr_utility.set_location('dtl_to_BEE',180);

Line 2165: hr_utility.set_location('dtl_to_BEE',180);

2161: hr_utility.trace('lv_pbl_flag :'||lv_pbl_flag);
2162: end if;
2163: else
2164: if g_debug then
2165: hr_utility.set_location('dtl_to_BEE',180);
2166: end if;
2167: pbl_value(i) := NULL;
2168: if g_debug then
2169: hr_utility.trace('pbl_value_'||to_char(i)||' :'||pbl_value(i));

Line 2169: hr_utility.trace('pbl_value_'||to_char(i)||' :'||pbl_value(i));

2165: hr_utility.set_location('dtl_to_BEE',180);
2166: end if;
2167: pbl_value(i) := NULL;
2168: if g_debug then
2169: hr_utility.trace('pbl_value_'||to_char(i)||' :'||pbl_value(i));
2170: end if;
2171: end if;
2172: if g_debug then
2173: hr_utility.set_location('dtl_to_BEE',190);

Line 2173: hr_utility.set_location('dtl_to_BEE',190);

2169: hr_utility.trace('pbl_value_'||to_char(i)||' :'||pbl_value(i));
2170: end if;
2171: end if;
2172: if g_debug then
2173: hr_utility.set_location('dtl_to_BEE',190);
2174: end if;
2175: HXT_UTIL.DEBUG('value_'||to_char(i)||' = '||pbl_value(i)); --HXT115
2176: END LOOP;
2177: -- Get Batch Line ID

Line 2179: hr_utility.set_location('dtl_to_BEE',200);

2175: HXT_UTIL.DEBUG('value_'||to_char(i)||' = '||pbl_value(i)); --HXT115
2176: END LOOP;
2177: -- Get Batch Line ID
2178: if g_debug then
2179: hr_utility.set_location('dtl_to_BEE',200);
2180: end if;
2181: -- Get next sequence number
2182: -- l_batch_sequence := pay_paywsqee_pkg.next_batch_sequence(p_values_rec.batch_id);
2183: if g_debug then

Line 2184: hr_utility.set_location('dtl_to_BEE',210);

2180: end if;
2181: -- Get next sequence number
2182: -- l_batch_sequence := pay_paywsqee_pkg.next_batch_sequence(p_values_rec.batch_id);
2183: if g_debug then
2184: hr_utility.set_location('dtl_to_BEE',210);
2185: end if;
2186: HXT_UTIL.DEBUG('batch_sequence = '||to_char(p_batch_sequence)); --HXT115
2187: -- Insert data into BEE table
2188: PAY_BATCH_ELEMENT_ENTRY_API.create_batch_line

Line 2263: hr_utility.trace('Updated HXT_DET_HOURS_WORKED_F with line id '||l_batch_line_id);

2259: WHERE rowid = p_values_rec.hrw_rowid;
2260:
2261: IF g_debug
2262: THEN
2263: hr_utility.trace('Updated HXT_DET_HOURS_WORKED_F with line id '||l_batch_line_id);
2264: END IF;
2265:
2266: -- Bug 13777315
2267: ELSE

Line 2272: hr_utility.trace(p_values_rec.cost_allocation_keyflex_id );

2268:
2269: -- Print out all the inputs for the Batch line.
2270: IF g_debug
2271: THEN
2272: hr_utility.trace(p_values_rec.cost_allocation_keyflex_id );
2273: hr_utility.trace(p_values_rec.element_type_id );
2274: hr_utility.trace(p_values_rec.assignment_id);
2275: hr_utility.trace(p_values_rec.batch_id );
2276: hr_utility.trace(p_values_rec.assignment_number );

Line 2273: hr_utility.trace(p_values_rec.element_type_id );

2269: -- Print out all the inputs for the Batch line.
2270: IF g_debug
2271: THEN
2272: hr_utility.trace(p_values_rec.cost_allocation_keyflex_id );
2273: hr_utility.trace(p_values_rec.element_type_id );
2274: hr_utility.trace(p_values_rec.assignment_id);
2275: hr_utility.trace(p_values_rec.batch_id );
2276: hr_utility.trace(p_values_rec.assignment_number );
2277: hr_utility.trace(p_values_rec.concatenated_segments );

Line 2274: hr_utility.trace(p_values_rec.assignment_id);

2270: IF g_debug
2271: THEN
2272: hr_utility.trace(p_values_rec.cost_allocation_keyflex_id );
2273: hr_utility.trace(p_values_rec.element_type_id );
2274: hr_utility.trace(p_values_rec.assignment_id);
2275: hr_utility.trace(p_values_rec.batch_id );
2276: hr_utility.trace(p_values_rec.assignment_number );
2277: hr_utility.trace(p_values_rec.concatenated_segments );
2278: hr_utility.trace(p_values_rec.element_name );

Line 2275: hr_utility.trace(p_values_rec.batch_id );

2271: THEN
2272: hr_utility.trace(p_values_rec.cost_allocation_keyflex_id );
2273: hr_utility.trace(p_values_rec.element_type_id );
2274: hr_utility.trace(p_values_rec.assignment_id);
2275: hr_utility.trace(p_values_rec.batch_id );
2276: hr_utility.trace(p_values_rec.assignment_number );
2277: hr_utility.trace(p_values_rec.concatenated_segments );
2278: hr_utility.trace(p_values_rec.element_name );
2279: hr_utility.trace(p_values_rec.reason);

Line 2276: hr_utility.trace(p_values_rec.assignment_number );

2272: hr_utility.trace(p_values_rec.cost_allocation_keyflex_id );
2273: hr_utility.trace(p_values_rec.element_type_id );
2274: hr_utility.trace(p_values_rec.assignment_id);
2275: hr_utility.trace(p_values_rec.batch_id );
2276: hr_utility.trace(p_values_rec.assignment_number );
2277: hr_utility.trace(p_values_rec.concatenated_segments );
2278: hr_utility.trace(p_values_rec.element_name );
2279: hr_utility.trace(p_values_rec.reason);
2280: hr_utility.trace(p_values_rec.segment1 );

Line 2277: hr_utility.trace(p_values_rec.concatenated_segments );

2273: hr_utility.trace(p_values_rec.element_type_id );
2274: hr_utility.trace(p_values_rec.assignment_id);
2275: hr_utility.trace(p_values_rec.batch_id );
2276: hr_utility.trace(p_values_rec.assignment_number );
2277: hr_utility.trace(p_values_rec.concatenated_segments );
2278: hr_utility.trace(p_values_rec.element_name );
2279: hr_utility.trace(p_values_rec.reason);
2280: hr_utility.trace(p_values_rec.segment1 );
2281: hr_utility.trace(p_values_rec.segment2);

Line 2278: hr_utility.trace(p_values_rec.element_name );

2274: hr_utility.trace(p_values_rec.assignment_id);
2275: hr_utility.trace(p_values_rec.batch_id );
2276: hr_utility.trace(p_values_rec.assignment_number );
2277: hr_utility.trace(p_values_rec.concatenated_segments );
2278: hr_utility.trace(p_values_rec.element_name );
2279: hr_utility.trace(p_values_rec.reason);
2280: hr_utility.trace(p_values_rec.segment1 );
2281: hr_utility.trace(p_values_rec.segment2);
2282: hr_utility.trace(p_values_rec.segment3);

Line 2279: hr_utility.trace(p_values_rec.reason);

2275: hr_utility.trace(p_values_rec.batch_id );
2276: hr_utility.trace(p_values_rec.assignment_number );
2277: hr_utility.trace(p_values_rec.concatenated_segments );
2278: hr_utility.trace(p_values_rec.element_name );
2279: hr_utility.trace(p_values_rec.reason);
2280: hr_utility.trace(p_values_rec.segment1 );
2281: hr_utility.trace(p_values_rec.segment2);
2282: hr_utility.trace(p_values_rec.segment3);
2283: hr_utility.trace(p_values_rec.segment4);

Line 2280: hr_utility.trace(p_values_rec.segment1 );

2276: hr_utility.trace(p_values_rec.assignment_number );
2277: hr_utility.trace(p_values_rec.concatenated_segments );
2278: hr_utility.trace(p_values_rec.element_name );
2279: hr_utility.trace(p_values_rec.reason);
2280: hr_utility.trace(p_values_rec.segment1 );
2281: hr_utility.trace(p_values_rec.segment2);
2282: hr_utility.trace(p_values_rec.segment3);
2283: hr_utility.trace(p_values_rec.segment4);
2284: hr_utility.trace(p_values_rec.segment5);

Line 2281: hr_utility.trace(p_values_rec.segment2);

2277: hr_utility.trace(p_values_rec.concatenated_segments );
2278: hr_utility.trace(p_values_rec.element_name );
2279: hr_utility.trace(p_values_rec.reason);
2280: hr_utility.trace(p_values_rec.segment1 );
2281: hr_utility.trace(p_values_rec.segment2);
2282: hr_utility.trace(p_values_rec.segment3);
2283: hr_utility.trace(p_values_rec.segment4);
2284: hr_utility.trace(p_values_rec.segment5);
2285: hr_utility.trace(p_values_rec.segment6);

Line 2282: hr_utility.trace(p_values_rec.segment3);

2278: hr_utility.trace(p_values_rec.element_name );
2279: hr_utility.trace(p_values_rec.reason);
2280: hr_utility.trace(p_values_rec.segment1 );
2281: hr_utility.trace(p_values_rec.segment2);
2282: hr_utility.trace(p_values_rec.segment3);
2283: hr_utility.trace(p_values_rec.segment4);
2284: hr_utility.trace(p_values_rec.segment5);
2285: hr_utility.trace(p_values_rec.segment6);
2286: hr_utility.trace(p_values_rec.segment7);

Line 2283: hr_utility.trace(p_values_rec.segment4);

2279: hr_utility.trace(p_values_rec.reason);
2280: hr_utility.trace(p_values_rec.segment1 );
2281: hr_utility.trace(p_values_rec.segment2);
2282: hr_utility.trace(p_values_rec.segment3);
2283: hr_utility.trace(p_values_rec.segment4);
2284: hr_utility.trace(p_values_rec.segment5);
2285: hr_utility.trace(p_values_rec.segment6);
2286: hr_utility.trace(p_values_rec.segment7);
2287: hr_utility.trace(p_values_rec.segment8);

Line 2284: hr_utility.trace(p_values_rec.segment5);

2280: hr_utility.trace(p_values_rec.segment1 );
2281: hr_utility.trace(p_values_rec.segment2);
2282: hr_utility.trace(p_values_rec.segment3);
2283: hr_utility.trace(p_values_rec.segment4);
2284: hr_utility.trace(p_values_rec.segment5);
2285: hr_utility.trace(p_values_rec.segment6);
2286: hr_utility.trace(p_values_rec.segment7);
2287: hr_utility.trace(p_values_rec.segment8);
2288: hr_utility.trace(p_values_rec.segment9);

Line 2285: hr_utility.trace(p_values_rec.segment6);

2281: hr_utility.trace(p_values_rec.segment2);
2282: hr_utility.trace(p_values_rec.segment3);
2283: hr_utility.trace(p_values_rec.segment4);
2284: hr_utility.trace(p_values_rec.segment5);
2285: hr_utility.trace(p_values_rec.segment6);
2286: hr_utility.trace(p_values_rec.segment7);
2287: hr_utility.trace(p_values_rec.segment8);
2288: hr_utility.trace(p_values_rec.segment9);
2289: hr_utility.trace(p_values_rec.segment10);

Line 2286: hr_utility.trace(p_values_rec.segment7);

2282: hr_utility.trace(p_values_rec.segment3);
2283: hr_utility.trace(p_values_rec.segment4);
2284: hr_utility.trace(p_values_rec.segment5);
2285: hr_utility.trace(p_values_rec.segment6);
2286: hr_utility.trace(p_values_rec.segment7);
2287: hr_utility.trace(p_values_rec.segment8);
2288: hr_utility.trace(p_values_rec.segment9);
2289: hr_utility.trace(p_values_rec.segment10);
2290: hr_utility.trace(p_values_rec.segment11);

Line 2287: hr_utility.trace(p_values_rec.segment8);

2283: hr_utility.trace(p_values_rec.segment4);
2284: hr_utility.trace(p_values_rec.segment5);
2285: hr_utility.trace(p_values_rec.segment6);
2286: hr_utility.trace(p_values_rec.segment7);
2287: hr_utility.trace(p_values_rec.segment8);
2288: hr_utility.trace(p_values_rec.segment9);
2289: hr_utility.trace(p_values_rec.segment10);
2290: hr_utility.trace(p_values_rec.segment11);
2291: hr_utility.trace(p_values_rec.segment12);

Line 2288: hr_utility.trace(p_values_rec.segment9);

2284: hr_utility.trace(p_values_rec.segment5);
2285: hr_utility.trace(p_values_rec.segment6);
2286: hr_utility.trace(p_values_rec.segment7);
2287: hr_utility.trace(p_values_rec.segment8);
2288: hr_utility.trace(p_values_rec.segment9);
2289: hr_utility.trace(p_values_rec.segment10);
2290: hr_utility.trace(p_values_rec.segment11);
2291: hr_utility.trace(p_values_rec.segment12);
2292: hr_utility.trace(p_values_rec.segment13);

Line 2289: hr_utility.trace(p_values_rec.segment10);

2285: hr_utility.trace(p_values_rec.segment6);
2286: hr_utility.trace(p_values_rec.segment7);
2287: hr_utility.trace(p_values_rec.segment8);
2288: hr_utility.trace(p_values_rec.segment9);
2289: hr_utility.trace(p_values_rec.segment10);
2290: hr_utility.trace(p_values_rec.segment11);
2291: hr_utility.trace(p_values_rec.segment12);
2292: hr_utility.trace(p_values_rec.segment13);
2293: hr_utility.trace(p_values_rec.segment14);

Line 2290: hr_utility.trace(p_values_rec.segment11);

2286: hr_utility.trace(p_values_rec.segment7);
2287: hr_utility.trace(p_values_rec.segment8);
2288: hr_utility.trace(p_values_rec.segment9);
2289: hr_utility.trace(p_values_rec.segment10);
2290: hr_utility.trace(p_values_rec.segment11);
2291: hr_utility.trace(p_values_rec.segment12);
2292: hr_utility.trace(p_values_rec.segment13);
2293: hr_utility.trace(p_values_rec.segment14);
2294: hr_utility.trace(p_values_rec.segment15);

Line 2291: hr_utility.trace(p_values_rec.segment12);

2287: hr_utility.trace(p_values_rec.segment8);
2288: hr_utility.trace(p_values_rec.segment9);
2289: hr_utility.trace(p_values_rec.segment10);
2290: hr_utility.trace(p_values_rec.segment11);
2291: hr_utility.trace(p_values_rec.segment12);
2292: hr_utility.trace(p_values_rec.segment13);
2293: hr_utility.trace(p_values_rec.segment14);
2294: hr_utility.trace(p_values_rec.segment15);
2295: hr_utility.trace(p_values_rec.segment16);

Line 2292: hr_utility.trace(p_values_rec.segment13);

2288: hr_utility.trace(p_values_rec.segment9);
2289: hr_utility.trace(p_values_rec.segment10);
2290: hr_utility.trace(p_values_rec.segment11);
2291: hr_utility.trace(p_values_rec.segment12);
2292: hr_utility.trace(p_values_rec.segment13);
2293: hr_utility.trace(p_values_rec.segment14);
2294: hr_utility.trace(p_values_rec.segment15);
2295: hr_utility.trace(p_values_rec.segment16);
2296: hr_utility.trace(p_values_rec.segment17);

Line 2293: hr_utility.trace(p_values_rec.segment14);

2289: hr_utility.trace(p_values_rec.segment10);
2290: hr_utility.trace(p_values_rec.segment11);
2291: hr_utility.trace(p_values_rec.segment12);
2292: hr_utility.trace(p_values_rec.segment13);
2293: hr_utility.trace(p_values_rec.segment14);
2294: hr_utility.trace(p_values_rec.segment15);
2295: hr_utility.trace(p_values_rec.segment16);
2296: hr_utility.trace(p_values_rec.segment17);
2297: hr_utility.trace(p_values_rec.segment18);

Line 2294: hr_utility.trace(p_values_rec.segment15);

2290: hr_utility.trace(p_values_rec.segment11);
2291: hr_utility.trace(p_values_rec.segment12);
2292: hr_utility.trace(p_values_rec.segment13);
2293: hr_utility.trace(p_values_rec.segment14);
2294: hr_utility.trace(p_values_rec.segment15);
2295: hr_utility.trace(p_values_rec.segment16);
2296: hr_utility.trace(p_values_rec.segment17);
2297: hr_utility.trace(p_values_rec.segment18);
2298: hr_utility.trace(p_values_rec.segment19);

Line 2295: hr_utility.trace(p_values_rec.segment16);

2291: hr_utility.trace(p_values_rec.segment12);
2292: hr_utility.trace(p_values_rec.segment13);
2293: hr_utility.trace(p_values_rec.segment14);
2294: hr_utility.trace(p_values_rec.segment15);
2295: hr_utility.trace(p_values_rec.segment16);
2296: hr_utility.trace(p_values_rec.segment17);
2297: hr_utility.trace(p_values_rec.segment18);
2298: hr_utility.trace(p_values_rec.segment19);
2299: hr_utility.trace(p_values_rec.segment20);

Line 2296: hr_utility.trace(p_values_rec.segment17);

2292: hr_utility.trace(p_values_rec.segment13);
2293: hr_utility.trace(p_values_rec.segment14);
2294: hr_utility.trace(p_values_rec.segment15);
2295: hr_utility.trace(p_values_rec.segment16);
2296: hr_utility.trace(p_values_rec.segment17);
2297: hr_utility.trace(p_values_rec.segment18);
2298: hr_utility.trace(p_values_rec.segment19);
2299: hr_utility.trace(p_values_rec.segment20);
2300: hr_utility.trace(p_values_rec.segment21);

Line 2297: hr_utility.trace(p_values_rec.segment18);

2293: hr_utility.trace(p_values_rec.segment14);
2294: hr_utility.trace(p_values_rec.segment15);
2295: hr_utility.trace(p_values_rec.segment16);
2296: hr_utility.trace(p_values_rec.segment17);
2297: hr_utility.trace(p_values_rec.segment18);
2298: hr_utility.trace(p_values_rec.segment19);
2299: hr_utility.trace(p_values_rec.segment20);
2300: hr_utility.trace(p_values_rec.segment21);
2301: hr_utility.trace(p_values_rec.segment22);

Line 2298: hr_utility.trace(p_values_rec.segment19);

2294: hr_utility.trace(p_values_rec.segment15);
2295: hr_utility.trace(p_values_rec.segment16);
2296: hr_utility.trace(p_values_rec.segment17);
2297: hr_utility.trace(p_values_rec.segment18);
2298: hr_utility.trace(p_values_rec.segment19);
2299: hr_utility.trace(p_values_rec.segment20);
2300: hr_utility.trace(p_values_rec.segment21);
2301: hr_utility.trace(p_values_rec.segment22);
2302: hr_utility.trace(p_values_rec.segment23);

Line 2299: hr_utility.trace(p_values_rec.segment20);

2295: hr_utility.trace(p_values_rec.segment16);
2296: hr_utility.trace(p_values_rec.segment17);
2297: hr_utility.trace(p_values_rec.segment18);
2298: hr_utility.trace(p_values_rec.segment19);
2299: hr_utility.trace(p_values_rec.segment20);
2300: hr_utility.trace(p_values_rec.segment21);
2301: hr_utility.trace(p_values_rec.segment22);
2302: hr_utility.trace(p_values_rec.segment23);
2303: hr_utility.trace(p_values_rec.segment24);

Line 2300: hr_utility.trace(p_values_rec.segment21);

2296: hr_utility.trace(p_values_rec.segment17);
2297: hr_utility.trace(p_values_rec.segment18);
2298: hr_utility.trace(p_values_rec.segment19);
2299: hr_utility.trace(p_values_rec.segment20);
2300: hr_utility.trace(p_values_rec.segment21);
2301: hr_utility.trace(p_values_rec.segment22);
2302: hr_utility.trace(p_values_rec.segment23);
2303: hr_utility.trace(p_values_rec.segment24);
2304: hr_utility.trace(p_values_rec.segment25);

Line 2301: hr_utility.trace(p_values_rec.segment22);

2297: hr_utility.trace(p_values_rec.segment18);
2298: hr_utility.trace(p_values_rec.segment19);
2299: hr_utility.trace(p_values_rec.segment20);
2300: hr_utility.trace(p_values_rec.segment21);
2301: hr_utility.trace(p_values_rec.segment22);
2302: hr_utility.trace(p_values_rec.segment23);
2303: hr_utility.trace(p_values_rec.segment24);
2304: hr_utility.trace(p_values_rec.segment25);
2305: hr_utility.trace(p_values_rec.segment26);

Line 2302: hr_utility.trace(p_values_rec.segment23);

2298: hr_utility.trace(p_values_rec.segment19);
2299: hr_utility.trace(p_values_rec.segment20);
2300: hr_utility.trace(p_values_rec.segment21);
2301: hr_utility.trace(p_values_rec.segment22);
2302: hr_utility.trace(p_values_rec.segment23);
2303: hr_utility.trace(p_values_rec.segment24);
2304: hr_utility.trace(p_values_rec.segment25);
2305: hr_utility.trace(p_values_rec.segment26);
2306: hr_utility.trace(p_values_rec.segment27);

Line 2303: hr_utility.trace(p_values_rec.segment24);

2299: hr_utility.trace(p_values_rec.segment20);
2300: hr_utility.trace(p_values_rec.segment21);
2301: hr_utility.trace(p_values_rec.segment22);
2302: hr_utility.trace(p_values_rec.segment23);
2303: hr_utility.trace(p_values_rec.segment24);
2304: hr_utility.trace(p_values_rec.segment25);
2305: hr_utility.trace(p_values_rec.segment26);
2306: hr_utility.trace(p_values_rec.segment27);
2307: hr_utility.trace(p_values_rec.segment28);

Line 2304: hr_utility.trace(p_values_rec.segment25);

2300: hr_utility.trace(p_values_rec.segment21);
2301: hr_utility.trace(p_values_rec.segment22);
2302: hr_utility.trace(p_values_rec.segment23);
2303: hr_utility.trace(p_values_rec.segment24);
2304: hr_utility.trace(p_values_rec.segment25);
2305: hr_utility.trace(p_values_rec.segment26);
2306: hr_utility.trace(p_values_rec.segment27);
2307: hr_utility.trace(p_values_rec.segment28);
2308: hr_utility.trace(p_values_rec.segment29);

Line 2305: hr_utility.trace(p_values_rec.segment26);

2301: hr_utility.trace(p_values_rec.segment22);
2302: hr_utility.trace(p_values_rec.segment23);
2303: hr_utility.trace(p_values_rec.segment24);
2304: hr_utility.trace(p_values_rec.segment25);
2305: hr_utility.trace(p_values_rec.segment26);
2306: hr_utility.trace(p_values_rec.segment27);
2307: hr_utility.trace(p_values_rec.segment28);
2308: hr_utility.trace(p_values_rec.segment29);
2309: hr_utility.trace(p_values_rec.segment30);

Line 2306: hr_utility.trace(p_values_rec.segment27);

2302: hr_utility.trace(p_values_rec.segment23);
2303: hr_utility.trace(p_values_rec.segment24);
2304: hr_utility.trace(p_values_rec.segment25);
2305: hr_utility.trace(p_values_rec.segment26);
2306: hr_utility.trace(p_values_rec.segment27);
2307: hr_utility.trace(p_values_rec.segment28);
2308: hr_utility.trace(p_values_rec.segment29);
2309: hr_utility.trace(p_values_rec.segment30);
2310: hr_utility.trace(p_values_rec.amount );

Line 2307: hr_utility.trace(p_values_rec.segment28);

2303: hr_utility.trace(p_values_rec.segment24);
2304: hr_utility.trace(p_values_rec.segment25);
2305: hr_utility.trace(p_values_rec.segment26);
2306: hr_utility.trace(p_values_rec.segment27);
2307: hr_utility.trace(p_values_rec.segment28);
2308: hr_utility.trace(p_values_rec.segment29);
2309: hr_utility.trace(p_values_rec.segment30);
2310: hr_utility.trace(p_values_rec.amount );
2311: hr_utility.trace(p_values_rec.rate_multiple);

Line 2308: hr_utility.trace(p_values_rec.segment29);

2304: hr_utility.trace(p_values_rec.segment25);
2305: hr_utility.trace(p_values_rec.segment26);
2306: hr_utility.trace(p_values_rec.segment27);
2307: hr_utility.trace(p_values_rec.segment28);
2308: hr_utility.trace(p_values_rec.segment29);
2309: hr_utility.trace(p_values_rec.segment30);
2310: hr_utility.trace(p_values_rec.amount );
2311: hr_utility.trace(p_values_rec.rate_multiple);
2312: hr_utility.trace(p_values_rec.hourly_rate );

Line 2309: hr_utility.trace(p_values_rec.segment30);

2305: hr_utility.trace(p_values_rec.segment26);
2306: hr_utility.trace(p_values_rec.segment27);
2307: hr_utility.trace(p_values_rec.segment28);
2308: hr_utility.trace(p_values_rec.segment29);
2309: hr_utility.trace(p_values_rec.segment30);
2310: hr_utility.trace(p_values_rec.amount );
2311: hr_utility.trace(p_values_rec.rate_multiple);
2312: hr_utility.trace(p_values_rec.hourly_rate );
2313: hr_utility.trace(p_values_rec.rate_code);

Line 2310: hr_utility.trace(p_values_rec.amount );

2306: hr_utility.trace(p_values_rec.segment27);
2307: hr_utility.trace(p_values_rec.segment28);
2308: hr_utility.trace(p_values_rec.segment29);
2309: hr_utility.trace(p_values_rec.segment30);
2310: hr_utility.trace(p_values_rec.amount );
2311: hr_utility.trace(p_values_rec.rate_multiple);
2312: hr_utility.trace(p_values_rec.hourly_rate );
2313: hr_utility.trace(p_values_rec.rate_code);
2314: hr_utility.trace(p_values_rec.location_code);

Line 2311: hr_utility.trace(p_values_rec.rate_multiple);

2307: hr_utility.trace(p_values_rec.segment28);
2308: hr_utility.trace(p_values_rec.segment29);
2309: hr_utility.trace(p_values_rec.segment30);
2310: hr_utility.trace(p_values_rec.amount );
2311: hr_utility.trace(p_values_rec.rate_multiple);
2312: hr_utility.trace(p_values_rec.hourly_rate );
2313: hr_utility.trace(p_values_rec.rate_code);
2314: hr_utility.trace(p_values_rec.location_code);
2315: hr_utility.trace(p_values_rec.fcl_tax_rule_code );

Line 2312: hr_utility.trace(p_values_rec.hourly_rate );

2308: hr_utility.trace(p_values_rec.segment29);
2309: hr_utility.trace(p_values_rec.segment30);
2310: hr_utility.trace(p_values_rec.amount );
2311: hr_utility.trace(p_values_rec.rate_multiple);
2312: hr_utility.trace(p_values_rec.hourly_rate );
2313: hr_utility.trace(p_values_rec.rate_code);
2314: hr_utility.trace(p_values_rec.location_code);
2315: hr_utility.trace(p_values_rec.fcl_tax_rule_code );
2316: hr_utility.trace(p_values_rec.separate_check_flag);

Line 2313: hr_utility.trace(p_values_rec.rate_code);

2309: hr_utility.trace(p_values_rec.segment30);
2310: hr_utility.trace(p_values_rec.amount );
2311: hr_utility.trace(p_values_rec.rate_multiple);
2312: hr_utility.trace(p_values_rec.hourly_rate );
2313: hr_utility.trace(p_values_rec.rate_code);
2314: hr_utility.trace(p_values_rec.location_code);
2315: hr_utility.trace(p_values_rec.fcl_tax_rule_code );
2316: hr_utility.trace(p_values_rec.separate_check_flag);
2317: hr_utility.trace(p_values_rec.state_name);

Line 2314: hr_utility.trace(p_values_rec.location_code);

2310: hr_utility.trace(p_values_rec.amount );
2311: hr_utility.trace(p_values_rec.rate_multiple);
2312: hr_utility.trace(p_values_rec.hourly_rate );
2313: hr_utility.trace(p_values_rec.rate_code);
2314: hr_utility.trace(p_values_rec.location_code);
2315: hr_utility.trace(p_values_rec.fcl_tax_rule_code );
2316: hr_utility.trace(p_values_rec.separate_check_flag);
2317: hr_utility.trace(p_values_rec.state_name);
2318: hr_utility.trace(p_values_rec.county_name );

Line 2315: hr_utility.trace(p_values_rec.fcl_tax_rule_code );

2311: hr_utility.trace(p_values_rec.rate_multiple);
2312: hr_utility.trace(p_values_rec.hourly_rate );
2313: hr_utility.trace(p_values_rec.rate_code);
2314: hr_utility.trace(p_values_rec.location_code);
2315: hr_utility.trace(p_values_rec.fcl_tax_rule_code );
2316: hr_utility.trace(p_values_rec.separate_check_flag);
2317: hr_utility.trace(p_values_rec.state_name);
2318: hr_utility.trace(p_values_rec.county_name );
2319: hr_utility.trace(p_values_rec.city_name );

Line 2316: hr_utility.trace(p_values_rec.separate_check_flag);

2312: hr_utility.trace(p_values_rec.hourly_rate );
2313: hr_utility.trace(p_values_rec.rate_code);
2314: hr_utility.trace(p_values_rec.location_code);
2315: hr_utility.trace(p_values_rec.fcl_tax_rule_code );
2316: hr_utility.trace(p_values_rec.separate_check_flag);
2317: hr_utility.trace(p_values_rec.state_name);
2318: hr_utility.trace(p_values_rec.county_name );
2319: hr_utility.trace(p_values_rec.city_name );
2320: hr_utility.trace(p_values_rec.zip_code );

Line 2317: hr_utility.trace(p_values_rec.state_name);

2313: hr_utility.trace(p_values_rec.rate_code);
2314: hr_utility.trace(p_values_rec.location_code);
2315: hr_utility.trace(p_values_rec.fcl_tax_rule_code );
2316: hr_utility.trace(p_values_rec.separate_check_flag);
2317: hr_utility.trace(p_values_rec.state_name);
2318: hr_utility.trace(p_values_rec.county_name );
2319: hr_utility.trace(p_values_rec.city_name );
2320: hr_utility.trace(p_values_rec.zip_code );
2321:

Line 2318: hr_utility.trace(p_values_rec.county_name );

2314: hr_utility.trace(p_values_rec.location_code);
2315: hr_utility.trace(p_values_rec.fcl_tax_rule_code );
2316: hr_utility.trace(p_values_rec.separate_check_flag);
2317: hr_utility.trace(p_values_rec.state_name);
2318: hr_utility.trace(p_values_rec.county_name );
2319: hr_utility.trace(p_values_rec.city_name );
2320: hr_utility.trace(p_values_rec.zip_code );
2321:
2322: END IF;

Line 2319: hr_utility.trace(p_values_rec.city_name );

2315: hr_utility.trace(p_values_rec.fcl_tax_rule_code );
2316: hr_utility.trace(p_values_rec.separate_check_flag);
2317: hr_utility.trace(p_values_rec.state_name);
2318: hr_utility.trace(p_values_rec.county_name );
2319: hr_utility.trace(p_values_rec.city_name );
2320: hr_utility.trace(p_values_rec.zip_code );
2321:
2322: END IF;
2323:

Line 2320: hr_utility.trace(p_values_rec.zip_code );

2316: hr_utility.trace(p_values_rec.separate_check_flag);
2317: hr_utility.trace(p_values_rec.state_name);
2318: hr_utility.trace(p_values_rec.county_name );
2319: hr_utility.trace(p_values_rec.city_name );
2320: hr_utility.trace(p_values_rec.zip_code );
2321:
2322: END IF;
2323:
2324: -- Pass the input parameters to the original view

Line 2397: hr_utility.trace('Printing Rowids being updated with batch line '||l_batch_line_id);

2393: WHERE rowid = CHARTOROWID(l_rowtab(i));
2394:
2395: IF g_debug
2396: THEN
2397: hr_utility.trace('Printing Rowids being updated with batch line '||l_batch_line_id);
2398: FOR i IN l_rowtab.FIRST..l_rowtab.LAST
2399: LOOP
2400: hr_utility.trace('Row -'||l_rowtab(i));
2401: END LOOP;

Line 2400: hr_utility.trace('Row -'||l_rowtab(i));

2396: THEN
2397: hr_utility.trace('Printing Rowids being updated with batch line '||l_batch_line_id);
2398: FOR i IN l_rowtab.FIRST..l_rowtab.LAST
2399: LOOP
2400: hr_utility.trace('Row -'||l_rowtab(i));
2401: END LOOP;
2402: END IF;
2403: END IF;
2404:

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

2417: FND_MESSAGE.SET_TOKEN('SQLERR', sqlerrm);
2418: Insert_Pay_Batch_Errors( p_values_rec.batch_id, 'VE', '', l_return);
2419: p_sum_retcode := 3;
2420: -- Bug 10143866
2421: hr_utility.trace(dbms_utility.format_error_backtrace);
2422:
2423: RAISE g_error_ins_batch_lines; --SIR517 PWM 18FEB00 Re-raise the exception for the calling procedure
2424: END dtl_to_BEE;
2425:

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

2567: FND_MESSAGE.SET_TOKEN('SQLERR', sqlerrm);
2568: Insert_Pay_Batch_Errors( p_batch_id, 'VE', '', l_return);
2569: p_sum_retcode := 3;
2570: -- Bug 10143866
2571: hr_utility.trace(dbms_utility.format_error_backtrace);
2572:
2573: END sum_to_mix;
2574: --------------------------------------------------------------------------------
2575: PROCEDURE Transfer_To_Payroll( p_batch_id IN NUMBER

Line 2616: hr_utility.set_location('PAY_US_PDT_PROCESS.TRANSFER_TO_PAYROLL', 1);

2612: select 'PIPE' || userenv('sessionid')
2613: into g_pipe_session
2614: from dual;
2615: if g_debug then
2616: hr_utility.set_location('PAY_US_PDT_PROCESS.TRANSFER_TO_PAYROLL', 1);
2617: end if;
2618: --DEBUG ONLY END*/
2619: EXCEPTION
2620: WHEN OTHERS THEN

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

2627: '',
2628: l_return);
2629: p_pay_retcode := 3;
2630: -- Bug 10143866
2631: hr_utility.trace(dbms_utility.format_error_backtrace);
2632:
2633: END transfer_to_payroll;
2634: ---------------------------------------------
2635: FUNCTION Call_Gen_Error( p_batch_id IN NUMBER

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

2687: END IF;
2688: EXCEPTION
2689: WHEN OTHERS THEN
2690: -- Bug 10143866
2691: hr_utility.trace(dbms_utility.format_error_backtrace);
2692: RETURN(3);
2693:
2694:
2695: END Get_Transfer_Batch_Status;

Line 2777: hr_utility.trace('Time period is null ');

2773: --
2774:
2775: IF g_debug
2776: THEN
2777: hr_utility.trace('Time period is null ');
2778: hr_utility.trace('Getting Batch lines for batch id '||p_batch_id);
2779: END IF;
2780:
2781: FND_FILE.put_line(FND_FILE.log,'Processing Batch id '||p_batch_id);

Line 2778: hr_utility.trace('Getting Batch lines for batch id '||p_batch_id);

2774:
2775: IF g_debug
2776: THEN
2777: hr_utility.trace('Time period is null ');
2778: hr_utility.trace('Getting Batch lines for batch id '||p_batch_id);
2779: END IF;
2780:
2781: FND_FILE.put_line(FND_FILE.log,'Processing Batch id '||p_batch_id);
2782:

Line 2786: hr_utility.trace('=>Processing Batch Line id '||l_rec.batch_line_id);

2782:
2783: for l_rec in c_get_batch_lines(p_batch_id)
2784: loop
2785: FND_FILE.put_line(FND_FILE.log,'=> Processing Batch Line id '||l_rec.batch_line_id);
2786: hr_utility.trace('=>Processing Batch Line id '||l_rec.batch_line_id);
2787: PAY_BATCH_ELEMENT_ENTRY_API.delete_batch_line
2788: (p_batch_line_id => l_rec.batch_line_id
2789: ,p_object_version_number => l_rec.object_version_number
2790: );

Line 2802: hr_utility.trace( 'updated hxt_batch_states for this batch ');

2798: WHERE batch_id = p_batch_id;
2799:
2800: IF g_debug
2801: THEN
2802: hr_utility.trace( 'updated hxt_batch_states for this batch ');
2803: END IF;
2804: -- step 1 - delete retro_batch lines for any timecards in this (regular) batch.
2805: --Then we loop through the cursor and delete the batch lines and batches as follows.
2806: FND_FILE.put_line(FND_FILE.log,'=>Picking Retro batches for '||p_batch_id);

Line 2810: hr_utility.trace('=> Retro Batch Id: '||l_rec.retro_batch_id);

2806: FND_FILE.put_line(FND_FILE.log,'=>Picking Retro batches for '||p_batch_id);
2807: for l_rec in c_get_retro_batch_ids(p_batch_id) loop
2808:
2809: FND_FILE.put_line(FND_FILE.log,'=> Retro Batch Id: '||l_rec.retro_batch_id);
2810: hr_utility.trace('=> Retro Batch Id: '||l_rec.retro_batch_id);
2811:
2812: IF l_rec.batch_status IN ( 'T','V')
2813: THEN
2814: hr_utility.trace('Retro batch '||l_rec.retro_batch_id||' is in status T');

Line 2814: hr_utility.trace('Retro batch '||l_rec.retro_batch_id||' is in status T');

2810: hr_utility.trace('=> Retro Batch Id: '||l_rec.retro_batch_id);
2811:
2812: IF l_rec.batch_status IN ( 'T','V')
2813: THEN
2814: hr_utility.trace('Retro batch '||l_rec.retro_batch_id||' is in status T');
2815: FND_FILE.put_line(FND_file.log,'Retro batch '||l_rec.retro_batch_id||' is in status Transferred or Valid');
2816: FND_FILE.put_line(FND_file.log,'Retro batch '||l_rec.retro_batch_id||' should be Unprocessed to proceed further');
2817: RAISE g_rollback_error;
2818: END IF;

Line 2823: hr_utility.trace('=>------- Retro Line Id: '||l_line_rec.batch_line_id);

2819:
2820: -- delete the batch lines
2821: for l_line_rec in c_get_batch_lines(l_rec.retro_batch_id) loop
2822: FND_FILE.put_line(FND_FILE.log,'=>------- Retro Line Id: '||l_line_rec.batch_line_id);
2823: hr_utility.trace('=>------- Retro Line Id: '||l_line_rec.batch_line_id);
2824: PAY_BATCH_ELEMENT_ENTRY_API.delete_batch_line
2825: (p_batch_line_id => l_line_rec.batch_line_id
2826: ,p_object_version_number => l_line_rec.object_version_number
2827: );

Line 2878: hr_utility.trace('=>--Deleting header for Batch '||l_retro_tab(i).retro_batch_id);

2874:
2875: FOR i IN l_retro_tab.FIRST..l_retro_tab.LAST
2876: LOOP
2877: FND_FILE.put_line(FND_FILE.log,'=>--Deleting header for Batch '||l_retro_tab(i).retro_batch_id);
2878: hr_utility.trace('=>--Deleting header for Batch '||l_retro_tab(i).retro_batch_id);
2879:
2880: PAY_BATCH_ELEMENT_ENTRY_API.delete_batch_header
2881: (p_batch_id => l_retro_tab(i).retro_batch_id
2882: ,p_object_version_number => l_retro_tab(i).retro_ovn

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

2979: l_sql_error := sqlerrm;
2980: FND_FILE.put_line(fnd_file.log,'Error: '||sqlerrm);
2981: p_rollback_retcode := 3;
2982: -- Bug 10143866
2983: hr_utility.trace(dbms_utility.format_error_backtrace);
2984: RAISE g_rollback_error;
2985:
2986: END rollback_PayMIX;
2987: -------------------------------------------------------------------

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

3007: EXCEPTION
3008: WHEN OTHERS THEN
3009: p_return_code := 1;
3010: -- Bug 10143866
3011: hr_utility.trace(dbms_utility.format_error_backtrace);
3012:
3013: END Insert_Pay_Batch_Errors;
3014: ------------------------------------------------------------------
3015: -- end SPR C163, C166 by BC