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_APAC_PAYSLIP_ARCHIVE dependencies on HR_UTILITY

Line 48: >Changed hr_utility.trace to execute conditionally.

44: p_pre_payroll_action_id and p_pre_effective_date changed).
45: 03-Nov-2002 Ragovind 115.9 2689226 Added NOCOPY for function get_legislative_parameters.
46: 04-Nov-2003 Puchil 115.10 3228928 Added a new cursor csr_element_num_val to sum all the element values for
47: numeric values and archive individual values for other types of input.
48: >Changed hr_utility.trace to execute conditionally.
49: 19-Apr-2004 bramajey 115.5 3578040 Renamed procedure range_code to
50: archive_payroll_level_data
51: 04-May-2004 bramajey 115.6 3604206 Added code to convert numeric data to
52: canonical using fnd_number.number_to_canonical while archiving.

Line 60: 15-Oct-2007 jalin 115.13 6486660 Changed calling function pay_in_utils to hr_utility

56: 02-Jul-2004 punmehta 115.9 3731940 Modified for GSCC warnings
57: 12-Dec-2006 aaagarwa 115.10 5048802 Added deinitialization_code
58: 05-Oct-2007 jalin 115.11 6471802 Reset l_element_archived to N in the loop in archive_user_elements procedure
59: 11-Oct-2007 jalin 115.12 6486660 Added NOT null check for l_sum_value in archive_user_elements
60: 15-Oct-2007 jalin 115.13 6486660 Changed calling function pay_in_utils to hr_utility
61: 11-Mar-2009 mdubasi 115.21 8277653 Changed the cursor 'csr_payroll_msg'
62: 13-Mar-2009 mdubasi 115.21 8277653 Changed the cursor 'csr_payroll_msg'
63:
64: *******************************************************************/

Line 168: g_debug := hr_utility.debug_enabled;

164: l_input_value_name pay_input_values_f.name%TYPE;
165:
166:
167: BEGIN
168: g_debug := hr_utility.debug_enabled;
169: IF g_debug THEN
170: hr_utility.trace('Entering procedure get_eit_definitions');
171: END IF;
172:

Line 170: hr_utility.trace('Entering procedure get_eit_definitions');

166:
167: BEGIN
168: g_debug := hr_utility.debug_enabled;
169: IF g_debug THEN
170: hr_utility.trace('Entering procedure get_eit_definitions');
171: END IF;
172:
173: FOR csr_eit_rec IN csr_eit_values(p_business_group_id)
174:

Line 180: hr_utility.trace(' For context : l_context ........:'||l_context);

176:
177: l_context := csr_eit_rec.org_information1;
178:
179: IF g_debug THEN
180: hr_utility.trace(' For context : l_context ........:'||l_context);
181: END IF;
182:
183: IF (l_context = pay_apac_payslip_archive.g_balance_context) THEN
184:

Line 210: hr_utility.trace('Archiving the user configured balances.......');

206: g_user_balance_table(l_balance_index).balance_narrative:= g_user_balance_table(l_balance_index).balance_name ||' '|| g_user_balance_table(l_balance_index).database_item_suffix;
207: END IF;
208:
209: IF g_debug THEN
210: hr_utility.trace('Archiving the user configured balances.......');
211: END IF;
212:
213: IF p_archive = 'Y' THEN
214:

Line 250: hr_utility.trace(' ......ELEMENT :'||l_element_index);

246:
247: l_element_index := l_element_index + 1;
248:
249: IF g_debug THEN
250: hr_utility.trace(' ......ELEMENT :'||l_element_index);
251: END IF;
252: g_element_table(l_element_index).element_type_id := l_element_type_id;
253: g_element_table(l_element_index).input_value_id := l_input_value_id;
254: g_element_table(l_element_index).element_narrative := l_element_narrative;

Line 291: hr_utility.trace('Leaving procedure get_eit_definition ');

287: g_max_user_balance_index := l_balance_index;
288: g_max_user_element_index := l_element_index;
289:
290: IF g_debug THEN
291: hr_utility.trace('Leaving procedure get_eit_definition ');
292: END IF;
293:
294: EXCEPTION
295: WHEN OTHERS THEN

Line 297: hr_utility.trace('Error occured in get_eit_definitions');

293:
294: EXCEPTION
295: WHEN OTHERS THEN
296: IF g_debug THEN
297: hr_utility.trace('Error occured in get_eit_definitions');
298: END IF;
299: RAISE;
300:
301: END get_eit_definitions;

Line 352: g_debug := hr_utility.debug_enabled;

348: and PACT.effective_date between PIVF.effective_start_date and PIVF.effective_end_date;
349:
350:
351: BEGIN
352: g_debug := hr_utility.debug_enabled;
353: IF g_debug THEN
354: hr_utility.trace('Start of archive user balances');
355: END IF;
356:

Line 354: hr_utility.trace('Start of archive user balances');

350:
351: BEGIN
352: g_debug := hr_utility.debug_enabled;
353: IF g_debug THEN
354: hr_utility.trace('Start of archive user balances');
355: END IF;
356:
357: FOR l_index IN 1 .. pay_apac_payslip_archive.g_max_user_balance_index LOOP
358:

Line 406: hr_utility.trace(' End of archive user balances');

402: END IF;
403:
404: END LOOP;
405: IF g_debug THEN
406: hr_utility.trace(' End of archive user balances');
407: END IF;
408:
409: EXCEPTION
410: WHEN OTHERS THEN

Line 412: hr_utility.trace('Error occured in archive user balances');

408:
409: EXCEPTION
410: WHEN OTHERS THEN
411: IF g_debug THEN
412: hr_utility.trace('Error occured in archive user balances');
413: END IF;
414: RAISE;
415: END archive_user_balances;
416:

Line 534: g_debug := hr_utility.debug_enabled;

530: l_input_name pay_input_values_f.name%TYPE;
531: l_element_archived VARCHAR2(1);
532:
533: BEGIN
534: g_debug := hr_utility.debug_enabled;
535: l_element_archived := 'N';
536: IF g_debug THEN
537: hr_utility.trace(' Start of archive user elements');
538: END IF;

Line 537: hr_utility.trace(' Start of archive user elements');

533: BEGIN
534: g_debug := hr_utility.debug_enabled;
535: l_element_archived := 'N';
536: IF g_debug THEN
537: hr_utility.trace(' Start of archive user elements');
538: END IF;
539:
540: FOR l_index IN 1 .. g_max_user_element_index LOOP
541:

Line 570: hr_utility.trace(' ...Unit Of Measure is ...:'||l_uom);

566:
567: IF l_element_archived = 'N' THEN
568:
569: IF g_debug THEN
570: hr_utility.trace(' ...Unit Of Measure is ...:'||l_uom);
571: END IF;
572:
573: IF (l_uom ='M' OR l_uom='H' OR l_uom='I') THEN
574:

Line 649: hr_utility.trace(' End of archive user elements');

645:
646: END LOOP; -- End of 1.. max_user_elements Loop
647:
648: IF g_debug THEN
649: hr_utility.trace(' End of archive user elements');
650: END IF;
651:
652: EXCEPTION
653: WHEN OTHERS THEN

Line 655: hr_utility.trace('Error occured in archive user elements');

651:
652: EXCEPTION
653: WHEN OTHERS THEN
654: IF g_debug THEN
655: hr_utility.trace('Error occured in archive user elements');
656: END IF;
657: RAISE;
658:
659: END archive_user_elements;

Line 693: hr_utility.trace('Start of process_eit');

689:
690: BEGIN
691:
692: IF g_debug THEN
693: hr_utility.trace('Start of process_eit');
694: END IF;
695:
696: -- Get the legislative parameters of the archive request.
697:

Line 721: hr_utility.trace('End of process_eit');

717: , p_archive => p_archive
718: );
719:
720: IF g_debug THEN
721: hr_utility.trace('End of process_eit');
722: END IF;
723:
724: EXCEPTION
725: WHEN OTHERS THEN

Line 727: hr_utility.trace('Error occured in process_eit');

723:
724: EXCEPTION
725: WHEN OTHERS THEN
726: IF g_debug THEN
727: hr_utility.trace('Error occured in process_eit');
728: END IF;
729: RAISE;
730: END process_eit;
731:

Line 804: g_debug := hr_utility.debug_enabled;

800: l_archive VARCHAR2(1) ;
801:
802:
803: BEGIN
804: g_debug := hr_utility.debug_enabled;
805: l_archive := 'Y';
806: IF g_debug THEN
807: hr_utility.trace(' Start of APAC archive Range Code');
808: END IF;

Line 807: hr_utility.trace(' Start of APAC archive Range Code');

803: BEGIN
804: g_debug := hr_utility.debug_enabled;
805: l_archive := 'Y';
806: IF g_debug THEN
807: hr_utility.trace(' Start of APAC archive Range Code');
808: END IF;
809:
810: -----------------------------------------------------------------------+
811: -- Call to process_eit with p_archive parameter as 'Y' as this will

Line 844: hr_utility.trace('Archiving the Payroll Messages.');

840: l_payroll_id,
841: l_canonical_end_date);
842:
843: IF g_debug THEN
844: hr_utility.trace('Archiving the Payroll Messages.');
845: END IF;
846:
847: FOR csr_msg_rec IN csr_payroll_msg(l_payroll_id
848: ,l_canonical_start_date

Line 873: hr_utility.trace('End of APAC archive Range Code');

869: END LOOP;
870:
871:
872: IF g_debug THEN
873: hr_utility.trace('End of APAC archive Range Code');
874: END IF;
875:
876: EXCEPTION
877: WHEN OTHERS THEN

Line 879: hr_utility.trace('Error occured in APAC archive Range Code');

875:
876: EXCEPTION
877: WHEN OTHERS THEN
878: IF g_debug THEN
879: hr_utility.trace('Error occured in APAC archive Range Code');
880: END IF;
881: RAISE;
882:
883: END range_code;

Line 901: g_debug := hr_utility.debug_enabled;

897:
898: l_archive VARCHAR2(1);
899:
900: BEGIN
901: g_debug := hr_utility.debug_enabled;
902: l_archive := 'N';
903: IF g_debug THEN
904: hr_utility.trace(' Start of APAC archive Initialization Code');
905: END IF;

Line 904: hr_utility.trace(' Start of APAC archive Initialization Code');

900: BEGIN
901: g_debug := hr_utility.debug_enabled;
902: l_archive := 'N';
903: IF g_debug THEN
904: hr_utility.trace(' Start of APAC archive Initialization Code');
905: END IF;
906:
907: -----------------------------------------------------------------------+
908: -- Call to process_eit with p_archive parameter as 'N' as this will

Line 916: hr_utility.trace('End of APAC Initliazation Code');

912:
913: process_eit(p_payroll_action_id,l_archive);
914:
915: IF g_debug THEN
916: hr_utility.trace('End of APAC Initliazation Code');
917: END IF;
918:
919: EXCEPTION
920: WHEN OTHERS THEN

Line 922: hr_utility.trace('Error occured in APAC archive Initialization Code');

918:
919: EXCEPTION
920: WHEN OTHERS THEN
921: IF g_debug THEN
922: hr_utility.trace('Error occured in APAC archive Initialization Code');
923: END IF;
924: RAISE;
925:
926: END initialization_code;

Line 966: g_debug := hr_utility.debug_enabled;

962: FROM pay_payroll_actions ppa
963: WHERE ppa.payroll_action_id = p_payroll_action_id;
964:
965: BEGIN
966: g_debug := hr_utility.debug_enabled;
967: IF g_debug THEN
968: hr_utility.trace('Start of get_legislative_parameters Procedure');
969: END IF;
970:

Line 968: hr_utility.trace('Start of get_legislative_parameters Procedure');

964:
965: BEGIN
966: g_debug := hr_utility.debug_enabled;
967: IF g_debug THEN
968: hr_utility.trace('Start of get_legislative_parameters Procedure');
969: END IF;
970:
971: OPEN csr_params(p_payroll_action_id);
972: FETCH csr_params INTO p_payroll_id

Line 980: hr_utility.trace('End of get_legislative_parameters Procedure');

976: ,p_end_date;
977: CLOSE csr_params;
978:
979: IF g_debug THEN
980: hr_utility.trace('End of get_legislative_parameters Procedure');
981: END IF;
982:
983: EXCEPTION
984: WHEN OTHERS THEN

Line 986: hr_utility.trace('Error occured in get_legislative_parameters');

982:
983: EXCEPTION
984: WHEN OTHERS THEN
985: IF g_debug THEN
986: hr_utility.trace('Error occured in get_legislative_parameters');
987: END IF;
988: RAISE;
989:
990: END get_legislative_parameters; /* End of get_legislative_parameters */

Line 1030: hr_utility.set_location(l_procedure, 10);

1026: BEGIN
1027: l_procedure := 'pay_apac_payslip_archive.deinitialization_code';
1028:
1029: IF g_debug THEN
1030: hr_utility.set_location(l_procedure, 10);
1031: END IF;
1032: l_count := -1;
1033:
1034: OPEN check_pa_data_existence;

Line 1040: hr_utility.trace('p_payroll_action_id:'||p_payroll_action_id);

1036: CLOSE check_pa_data_existence;
1037:
1038: IF (g_debug)
1039: THEN
1040: hr_utility.trace('p_payroll_action_id:'||p_payroll_action_id);
1041: hr_utility.trace('l_count:'||l_count);
1042: END IF;
1043:
1044: IF (l_count = -1)

Line 1041: hr_utility.trace('l_count:'||l_count);

1037:
1038: IF (g_debug)
1039: THEN
1040: hr_utility.trace('p_payroll_action_id:'||p_payroll_action_id);
1041: hr_utility.trace('l_count:'||l_count);
1042: END IF;
1043:
1044: IF (l_count = -1)
1045: THEN

Line 1048: hr_utility.set_location(l_procedure, 20);

1044: IF (l_count = -1)
1045: THEN
1046: pay_apac_payslip_archive.range_code(p_payroll_action_id => p_payroll_action_id);
1047: IF g_debug THEN
1048: hr_utility.set_location(l_procedure, 20);
1049: END IF;
1050: END IF;
1051:
1052: IF g_debug THEN

Line 1053: hr_utility.set_location(l_procedure, 30);

1049: END IF;
1050: END IF;
1051:
1052: IF g_debug THEN
1053: hr_utility.set_location(l_procedure, 30);
1054: END IF;
1055:
1056: END deinitialization_code;
1057: