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

Line 9: g_debug boolean := hr_utility.debug_enabled;

5: archive_assact_id NUMBER);
6:
7: TYPE lock_table IS TABLE OF lock_rec INDEX BY BINARY_INTEGER;
8:
9: g_debug boolean := hr_utility.debug_enabled;
10: g_lock_table lock_table;
11: g_index NUMBER := -1;
12: g_index_assact NUMBER := -1;
13: g_index_bal NUMBER := -1;

Line 34: hr_utility.set_location(' Entering Function GET_PARAMETER',10);

30: l_proc VARCHAR2(40):= g_package||' get parameter ';
31: BEGIN
32: --
33: IF g_debug THEN
34: hr_utility.set_location(' Entering Function GET_PARAMETER',10);
35: END IF;
36: l_start_pos := instr(' '||p_parameter_string,l_delimiter||p_token||'=');
37: --
38: IF l_start_pos = 0 THEN

Line 60: hr_utility.set_location(' Leaving Function GET_PARAMETER',20);

56: END IF;
57: END IF;
58: --
59: IF g_debug THEN
60: hr_utility.set_location(' Leaving Function GET_PARAMETER',20);
61: END IF;
62:
63: RETURN l_parameter;
64:

Line 125: hr_utility.set_location(' Leaving Procedure GET_ALL_PARAMETERS',30);

121:
122: CLOSE csr_parameter_info;
123: --
124: IF g_debug THEN
125: hr_utility.set_location(' Leaving Procedure GET_ALL_PARAMETERS',30);
126: END IF;
127: END GET_ALL_PARAMETERS;
128:
129: /* RANGE CODE */

Line 489: hr_utility.set_location(' Entering Procedure RANGE_CODE',10);

485:
486: BEGIN
487: -- g_debug:=true;
488: IF g_debug THEN
489: hr_utility.set_location(' Entering Procedure RANGE_CODE',10);
490: END IF;
491:
492: p_sql := 'SELECT DISTINCT person_id
493: FROM per_people_f ppf

Line 541: hr_utility.set_location('Entered Procedure GETDATA',10);

537:
538: IF l_count < 1 then
539:
540:
541: hr_utility.set_location('Entered Procedure GETDATA',10);
542:
543: BEGIN
544: pay_balance_pkg.set_context('TAX_UNIT_ID',l_legal_employer_id);
545: pay_balance_pkg.set_context('LOCAL_UNIT_ID',l_local_unit_id);

Line 551: hr_utility.set_location('Set the contexts',20);

547: pay_balance_pkg.set_context('JURISDICTION_CODE',NULL);
548: pay_balance_pkg.set_context('SOURCE_ID',NULL);
549: pay_balance_pkg.set_context('TAX_GROUP',NULL);
550: END;
551: hr_utility.set_location('Set the contexts',20);
552:
553:
554: hr_utility.set_location('Calculated the Wage Payment Month and Due Date',30);
555:

Line 554: hr_utility.set_location('Calculated the Wage Payment Month and Due Date',30);

550: END;
551: hr_utility.set_location('Set the contexts',20);
552:
553:
554: hr_utility.set_location('Calculated the Wage Payment Month and Due Date',30);
555:
556:
557: OPEN csr_Legal_Emp_Details(l_legal_employer_id);
558: FETCH csr_Legal_Emp_Details INTO rg_Legal_Emp_Details;

Line 569: hr_utility.set_location('Calculation for Local Unit',40);

565: IF l_local_unit_id IS NOT NULL THEN
566:
567: l_emp_type:='LU' ;
568: l_emp_id:=l_local_unit_id;
569: hr_utility.set_location('Calculation for Local Unit',40);
570:
571: BEGIN
572:
573: SELECT MAX(ASSIGNMENT_ACTION_ID)

Line 584: hr_utility.set_location('Fetched the Assignment action id',50);

580: WHEN others THEN
581: NULL;
582: END;
583:
584: hr_utility.set_location('Fetched the Assignment action id',50);
585:
586:
587: /* Pick up the details belonging to Local Unit */
588:

Line 599: hr_utility.set_location('Pick up the details belonging to Local Unit',60);

595: l_business_id := l_y_number||'-'||rg_Local_Unit_Details.ORG_INFORMATION1 ;
596: l_tax_office_id := rg_Local_Unit_Details.ORG_INFORMATION7 ;
597:
598:
599: hr_utility.set_location('Pick up the details belonging to Local Unit',60);
600:
601: /* Pick up the contact details belonging to Local Unit*/
602:
603: OPEN csr_Local_Unit_contact( l_local_unit_id);

Line 611: hr_utility.set_location('Pick up the contact details belonging to Local Unit',70);

607: l_contact_person := rg_Local_Unit_contact.contact_person ;
608: l_phone := rg_Local_Unit_contact.phone ;
609: l_fax := rg_Local_Unit_contact.fax ;
610:
611: hr_utility.set_location('Pick up the contact details belonging to Local Unit',70);
612:
613: /* Pick up the Address details belonging to Local Unit*/
614:
615: OPEN csr_Local_Unit_addr( l_local_unit_id);

Line 833: hr_utility.set_location('Pick up the tax office details belonging to Employer',70);

829: l_tax_office_name := rg_Tax_Office_Details.name ;
830: l_tax_office_pay_meth_id := rg_Tax_Office_Details.ORG_INFORMATION2 ;
831: l_employer_pay_meth_id := rg_Tax_Office_Details.ORG_INFORMATION1 ;
832:
833: hr_utility.set_location('Pick up the tax office details belonging to Employer',70);
834:
835: OPEN csr_account_number( l_tax_office_pay_meth_id );
836: FETCH csr_account_number INTO rg_account_number;
837: CLOSE csr_account_number;

Line 846: hr_utility.set_location('Before populating pl/sql table',70);

842: FETCH csr_account_number INTO rg_account_number;
843: CLOSE csr_account_number;
844:
845: l_employer_ba := rg_account_number.segment3 ;
846: hr_utility.set_location('Before populating pl/sql table',70);
847: IF l_vat IS NULL THEN
848: l_vat:=l_vat_bal;
849: END IF;
850:

Line 988: hr_utility.set_location(' Leaving Procedure RANGE_CODE',50);

984:
985: END IF;
986:
987: IF g_debug THEN
988: hr_utility.set_location(' Leaving Procedure RANGE_CODE',50);
989: END IF;
990:
991: EXCEPTION
992: WHEN OTHERS THEN

Line 1007: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',60);

1003: ,p_chunk IN NUMBER)
1004: IS
1005: BEGIN
1006: IF g_debug THEN
1007: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',60);
1008: END IF;
1009:
1010: IF g_debug THEN
1011: hr_utility.set_location(' Leaving Procedure ASSIGNMENT_ACTION_CODE',70);

Line 1011: hr_utility.set_location(' Leaving Procedure ASSIGNMENT_ACTION_CODE',70);

1007: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',60);
1008: END IF;
1009:
1010: IF g_debug THEN
1011: hr_utility.set_location(' Leaving Procedure ASSIGNMENT_ACTION_CODE',70);
1012: END IF;
1013:
1014:
1015: END ASSIGNMENT_ACTION_CODE;

Line 1024: hr_utility.set_location(' Entering Procedure INITIALIZATION_CODE',80);

1020: IS
1021:
1022: BEGIN
1023: IF g_debug THEN
1024: hr_utility.set_location(' Entering Procedure INITIALIZATION_CODE',80);
1025: END IF;
1026:
1027:
1028: IF g_debug THEN

Line 1029: hr_utility.set_location(' Leaving Procedure INITIALIZATION_CODE',90);

1025: END IF;
1026:
1027:
1028: IF g_debug THEN
1029: hr_utility.set_location(' Leaving Procedure INITIALIZATION_CODE',90);
1030: END IF;
1031:
1032: EXCEPTION WHEN OTHERS THEN
1033: g_err_num := SQLCODE;

Line 1035: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In INITIALIZATION_CODE',180);

1031:
1032: EXCEPTION WHEN OTHERS THEN
1033: g_err_num := SQLCODE;
1034: IF g_debug THEN
1035: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In INITIALIZATION_CODE',180);
1036: END IF;
1037: END INITIALIZATION_CODE;
1038:
1039: /* ARCHIVE CODE */

Line 1046: hr_utility.set_location(' Entering Procedure ARCHIVE_CODE',80);

1042: IS
1043:
1044: BEGIN
1045: IF g_debug THEN
1046: hr_utility.set_location(' Entering Procedure ARCHIVE_CODE',80);
1047: END IF;
1048:
1049: IF g_debug THEN
1050: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',90);

Line 1050: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',90);

1046: hr_utility.set_location(' Entering Procedure ARCHIVE_CODE',80);
1047: END IF;
1048:
1049: IF g_debug THEN
1050: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',90);
1051: END IF;
1052:
1053: END ARCHIVE_CODE;
1054: END PAY_FI_ARCHIVE_MTRA;