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

Line 575: hr_utility.set_location(l_package||l_function, 10);

571: v_defbal_id number;
572: l_function varchar2(16);
573: BEGIN
574: l_function :='get_defined_bal';
575: hr_utility.set_location(l_package||l_function, 10);
576:
577: SELECT defined_balance_id
578: INTO v_defbal_id
579: FROM pay_defined_balances

Line 585: hr_utility.set_location(l_package||l_function, 20);

581: AND balance_dimension_id = p_dim_id
582: AND nvl(business_group_id,p_business_group_id) = p_business_group_id
583: AND nvl(legislation_code,p_legislation_code) = p_legislation_code;
584:
585: hr_utility.set_location(l_package||l_function, 20);
586:
587: RETURN v_defbal_id;
588:
589: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 590: hr_utility.set_location(l_package||l_function, 30);

586:
587: RETURN v_defbal_id;
588:
589: EXCEPTION WHEN NO_DATA_FOUND THEN
590: hr_utility.set_location(l_package||l_function, 30);
591: RETURN -1;
592:
593: END;
594:

Line 615: hr_utility.set_location(l_package||l_function, 10);

611: l_function varchar2(9);
612:
613: BEGIN
614: l_function :='get_bal';
615: hr_utility.set_location(l_package||l_function, 10);
616: IF (p_assignment_action_id = -1 ) THEN
617: IF p_balance_level='PER' THEN
618: l_ytd_id := get_defined_bal(l_bal_type_id,p_per_ytd);
619: l_qtd_id := get_defined_bal(l_bal_type_id,p_per_qtd);

Line 621: hr_utility.set_location(l_package||l_function, 20);

617: IF p_balance_level='PER' THEN
618: l_ytd_id := get_defined_bal(l_bal_type_id,p_per_ytd);
619: l_qtd_id := get_defined_bal(l_bal_type_id,p_per_qtd);
620:
621: hr_utility.set_location(l_package||l_function, 20);
622:
623: BEGIN
624:
625: -- check to see if p_assignment_id exist as of l_date

Line 638: hr_utility.set_location(l_package||l_function, 30);

634: and hsk.segment1 = to_char(p_tax_unit_id);
635:
636: l_temp_assignment_id := to_number(p_assignment_id);
637:
638: hr_utility.set_location(l_package||l_function, 30);
639:
640: EXCEPTION
641: WHEN NO_DATA_FOUND THEN
642:

Line 646: hr_utility.set_location(l_package||l_function, 40);

642:
643: -- Attempt to find any assignment id for the person as of l_date
644:
645: BEGIN
646: hr_utility.set_location(l_package||l_function, 40);
647:
648: select paf2.assignment_id
649: into l_temp_assignment_id
650: from per_assignments_f paf1,

Line 661: hr_utility.set_location(l_package||l_function, 50);

657: and paf2.effective_end_date
658: and hsk.segment1 = to_char(p_tax_unit_id)
659: and rownum=1;
660:
661: hr_utility.set_location(l_package||l_function, 50);
662: EXCEPTION
663: WHEN NO_DATA_FOUND THEN
664:
665: BEGIN

Line 668: hr_utility.set_location(l_package||l_function, 60);

664:
665: BEGIN
666: -- Find an assignment id for the person with an end date < l_date
667: -- and greater than trunc(p_session_date,y).
668: hr_utility.set_location(l_package||l_function, 60);
669:
670: -- 4915420
671:
672: select paf2.assignment_id

Line 711: hr_utility.set_location(l_package||l_function, 70);

707: )
708: and rownum=1; */
709:
710:
711: hr_utility.set_location(l_package||l_function, 70);
712:
713: EXCEPTION
714: WHEN NO_DATA_FOUND THEN
715: hr_utility.set_location(l_package||l_function, 80);

Line 715: hr_utility.set_location(l_package||l_function, 80);

711: hr_utility.set_location(l_package||l_function, 70);
712:
713: EXCEPTION
714: WHEN NO_DATA_FOUND THEN
715: hr_utility.set_location(l_package||l_function, 80);
716: NULL;
717: END;
718: END;
719: END;

Line 722: hr_utility.set_location(l_package||l_function, 90);

718: END;
719: END;
720: ELSE -- Assignment level balances are required
721:
722: hr_utility.set_location(l_package||l_function, 90);
723:
724: l_temp_assignment_id := p_assignment_id;
725: l_ytd_id := get_defined_bal(l_bal_type_id,p_asg_ytd);
726: l_qtd_id := get_defined_bal(l_bal_type_id,p_asg_qtd);

Line 730: hr_utility.set_location(l_package||l_function, 100);

726: l_qtd_id := get_defined_bal(l_bal_type_id,p_asg_qtd);
727:
728: END IF; -- Person/asg level balances
729:
730: hr_utility.set_location(l_package||l_function, 100);
731:
732: l_date := payvwele.get_fpd_or_atd(p_assignment_id => l_temp_assignment_id,
733: p_session_date => p_session_date);
734: -- Bugfix 3300433 start

Line 764: hr_utility.set_location(l_package||l_function,110);

760: l_last_process_date:=p_session_date;
761: END IF;
762: END IF; -- Bugfix 3300433 end
763:
764: hr_utility.set_location(l_package||l_function,110);
765:
766: IF l_date IS NULL THEN
767: l_date := p_session_date; -- current emp
768: ELSIF l_date >= p_session_date THEN

Line 796: hr_utility.set_location(l_package||l_function,120);

792: -- terminated this year and this month
793: -- show all balances
794: l_date := p_session_date; -- Bugfix 3300433 and 3541052
795: END IF;
796: hr_utility.set_location(l_package||l_function,120);
797: -- set TAX_UNIT_ID context
798: pay_balance_pkg.set_context ('TAX_UNIT_ID', TO_CHAR(p_tax_unit_id));
799:
800: l_value := pay_balance_pkg.get_value_lock( p_defined_balance_id => l_defbal_id,

Line 804: hr_utility.set_location(l_package||l_function, 130);

800: l_value := pay_balance_pkg.get_value_lock( p_defined_balance_id => l_defbal_id,
801: p_assignment_id => l_temp_assignment_id,
802: p_virtual_date => l_date,
803: p_asg_lock => 'N' );
804: hr_utility.set_location(l_package||l_function, 130);
805:
806: END IF;-- End assignment action check
807:
808: hr_utility.set_location(l_package||l_function, 150);

Line 808: hr_utility.set_location(l_package||l_function, 150);

804: hr_utility.set_location(l_package||l_function, 130);
805:
806: END IF;-- End assignment action check
807:
808: hr_utility.set_location(l_package||l_function, 150);
809:
810: RETURN l_value;
811:
812: EXCEPTION

Line 814: hr_utility.set_location(l_package||l_function, 160);

810: RETURN l_value;
811:
812: EXCEPTION
813: WHEN NO_DATA_FOUND THEN
814: hr_utility.set_location(l_package||l_function, 160);
815: RETURN NULL;
816: END; --End of function get_bal
817:
818:

Line 832: hr_utility.set_location(l_package||l_procedure, 10);

828: i number;
829: l_procedure VARCHAR2(15);
830: BEGIN
831: l_procedure :='get_dedn_info';
832: hr_utility.set_location(l_package||l_procedure, 10);
833:
834: IF p_earn_data.COUNT>0 THEN
835: st_cnt:=p_earn_data.FIRST;
836: end_cnt:=p_earn_data.LAST;

Line 855: hr_utility.set_location(l_package||l_procedure, 20);

851: p_dedn_data(i).ytd :=p_earn_data(i).ytd;
852: END IF;
853: END LOOP;
854: END IF;
855: hr_utility.set_location(l_package||l_procedure, 20);
856: END;
857:
858:
859: /******************************************************************************

Line 871: hr_utility.set_location(l_package||l_procedure, 10);

867: BEGIN
868: l_ytd_date :=NULL;
869: l_qtd_date :=NULL;
870: l_procedure:='get_asg_date';
871: hr_utility.set_location(l_package||l_procedure, 10);
872:
873: IF (p_assignment_action_id = -1 ) THEN
874: IF p_balance_level='PER' THEN
875:

Line 876: hr_utility.set_location(l_package||l_procedure, 20);

872:
873: IF (p_assignment_action_id = -1 ) THEN
874: IF p_balance_level='PER' THEN
875:
876: hr_utility.set_location(l_package||l_procedure, 20);
877: BEGIN
878: -- check to see if p_assignment_id exist as of l_date
879: select paf.assignment_id
880: into l_temp_assignment_id

Line 891: hr_utility.set_location(l_package||l_procedure, 30);

887: and hsk.segment1 = to_char(p_tax_unit_id);
888:
889: l_temp_assignment_id := to_number(p_assignment_id);
890:
891: hr_utility.set_location(l_package||l_procedure, 30);
892:
893: EXCEPTION
894: WHEN NO_DATA_FOUND THEN
895: -- Attempt to find any assignment id for the person as of l_date

Line 897: hr_utility.set_location(l_package||l_procedure, 40);

893: EXCEPTION
894: WHEN NO_DATA_FOUND THEN
895: -- Attempt to find any assignment id for the person as of l_date
896: BEGIN
897: hr_utility.set_location(l_package||l_procedure, 40);
898:
899:
900: select paf2.assignment_id
901: into l_temp_assignment_id

Line 913: hr_utility.set_location(l_package||l_procedure, 50);

909: and paf2.effective_end_date
910: and hsk.segment1 = to_char(p_tax_unit_id)
911: and rownum=1;
912:
913: hr_utility.set_location(l_package||l_procedure, 50);
914: EXCEPTION
915: WHEN NO_DATA_FOUND THEN
916: BEGIN
917: -- Find an assignment id for the person with an end date < l_date

Line 919: hr_utility.set_location(l_package||l_procedure, 60);

915: WHEN NO_DATA_FOUND THEN
916: BEGIN
917: -- Find an assignment id for the person with an end date < l_date
918: -- and greater than trunc(p_session_date,y).
919: hr_utility.set_location(l_package||l_procedure, 60);
920:
921: -- 4915420
922:
923: select paf2.assignment_id

Line 961: hr_utility.set_location(l_package||l_procedure, 70);

957: and paf3.effective_end_date < p_session_date
958: )
959: and rownum=1; */
960:
961: hr_utility.set_location(l_package||l_procedure, 70);
962:
963: EXCEPTION
964: WHEN NO_DATA_FOUND THEN
965: hr_utility.set_location(l_package||l_procedure, 80);

Line 965: hr_utility.set_location(l_package||l_procedure, 80);

961: hr_utility.set_location(l_package||l_procedure, 70);
962:
963: EXCEPTION
964: WHEN NO_DATA_FOUND THEN
965: hr_utility.set_location(l_package||l_procedure, 80);
966: NULL;
967: END;
968: END;
969: END;

Line 972: hr_utility.set_location(l_package||l_procedure, 90);

968: END;
969: END;
970: ELSE -- Assignment level balances are required
971:
972: hr_utility.set_location(l_package||l_procedure, 90);
973: l_temp_assignment_id := p_assignment_id;
974: END IF; -- Person/asg level balances
975:
976: hr_utility.set_location(l_package||l_procedure, 100);

Line 976: hr_utility.set_location(l_package||l_procedure, 100);

972: hr_utility.set_location(l_package||l_procedure, 90);
973: l_temp_assignment_id := p_assignment_id;
974: END IF; -- Person/asg level balances
975:
976: hr_utility.set_location(l_package||l_procedure, 100);
977:
978: l_date := payvwele.get_fpd_or_atd(p_assignment_id => l_temp_assignment_id,
979: p_session_date => p_session_date);
980: -- Bugfix 3300433 start

Line 1009: hr_utility.set_location(l_package||l_procedure,110);

1005: l_last_process_date:=p_session_date;
1006: END IF;
1007: END IF; -- Bugfix 3300433 end
1008:
1009: hr_utility.set_location(l_package||l_procedure,110);
1010:
1011: IF l_date IS NULL THEN
1012: l_date := p_session_date; -- current emp
1013: ELSIF l_date >= p_session_date THEN

Line 1037: hr_utility.set_location(l_package||l_procedure,120);

1033: -- show all balances
1034: l_date := p_session_date; -- Bugfix 3300433 and 3541052
1035: END IF;
1036:
1037: hr_utility.set_location(l_package||l_procedure,120);
1038: hr_utility.set_location(l_package||l_procedure, 130);
1039:
1040: END IF;-- End assignment action check
1041:

Line 1038: hr_utility.set_location(l_package||l_procedure, 130);

1034: l_date := p_session_date; -- Bugfix 3300433 and 3541052
1035: END IF;
1036:
1037: hr_utility.set_location(l_package||l_procedure,120);
1038: hr_utility.set_location(l_package||l_procedure, 130);
1039:
1040: END IF;-- End assignment action check
1041:
1042: hr_utility.set_location(l_package||l_procedure, 150);

Line 1042: hr_utility.set_location(l_package||l_procedure, 150);

1038: hr_utility.set_location(l_package||l_procedure, 130);
1039:
1040: END IF;-- End assignment action check
1041:
1042: hr_utility.set_location(l_package||l_procedure, 150);
1043:
1044: END; --End of procedure get_asg_date
1045:
1046:

Line 1051: -- hr_utility.trace_on(null,'EMPB');

1047: BEGIN -- populate_element_info
1048:
1049: l_package := 'pay_us_employee_balances.';
1050: l_procedure :='populate_element_info';
1051: -- hr_utility.trace_on(null,'EMPB');
1052: hr_utility.set_location(l_package||l_procedure, 10);
1053: p_flag:='N';
1054:
1055: IF p_balance_level='ASG' THEN

Line 1052: hr_utility.set_location(l_package||l_procedure, 10);

1048:
1049: l_package := 'pay_us_employee_balances.';
1050: l_procedure :='populate_element_info';
1051: -- hr_utility.trace_on(null,'EMPB');
1052: hr_utility.set_location(l_package||l_procedure, 10);
1053: p_flag:='N';
1054:
1055: IF p_balance_level='ASG' THEN
1056: l_dim_month := 'ASG_GRE_MONTH';

Line 1093: hr_utility.set_location('Balances Valid ASG/PER level balances', 40);

1089: ELSIF UPPER(p_classification_name) = 'VOLUNTARY DEDUCTIONS' THEN
1090: l_attribute_name := 'PAY_US_VOLUNTARY_DEDUCTIONS';
1091: END IF;
1092:
1093: hr_utility.set_location('Balances Valid ASG/PER level balances', 40);
1094: -- Use the cursor csr_element_assact_info_dedn for Deductions
1095: -- as it checks for existence of Run balances for
1096: -- Arrears, Accrued, Towards Bond balance apart from
1097: -- the base balance

Line 1144: hr_utility.set_location(l_package||l_procedure, 20);

1140:
1141: end if; -- if (UPPER(p_classification_name) = 'PRE-TAX DEDUCTIONS'
1142: ELSE -- Balances are invalid
1143: i:=0;
1144: hr_utility.set_location(l_package||l_procedure, 20);
1145: hr_utility.set_location('Balances Invalid ASG/PER level balances', 60); -- delete
1146: OPEN csr_element_assact_runs;
1147: LOOP
1148: FETCH csr_element_assact_runs

Line 1145: hr_utility.set_location('Balances Invalid ASG/PER level balances', 60); -- delete

1141: end if; -- if (UPPER(p_classification_name) = 'PRE-TAX DEDUCTIONS'
1142: ELSE -- Balances are invalid
1143: i:=0;
1144: hr_utility.set_location(l_package||l_procedure, 20);
1145: hr_utility.set_location('Balances Invalid ASG/PER level balances', 60); -- delete
1146: OPEN csr_element_assact_runs;
1147: LOOP
1148: FETCH csr_element_assact_runs
1149: INTO p_earn_data(i).row_id

Line 1235: hr_utility.set_location(l_package||l_procedure, 60);

1231: IF p_element_type_id IS NOT NULL and p_earn_data.COUNT>0 THEN
1232: st_cnt := p_earn_data.first;
1233: end_cnt := p_earn_data.last;
1234:
1235: hr_utility.set_location(l_package||l_procedure, 60);
1236:
1237: FOR i IN st_cnt..end_cnt LOOP
1238: IF p_earn_data.exists(i) THEN
1239: IF p_element_type_id=p_earn_data(i).element_type_id THEN

Line 1248: hr_utility.set_location(l_package||l_procedure, 70);

1244: END IF;
1245: END IF;
1246: END LOOP;
1247:
1248: hr_utility.set_location(l_package||l_procedure, 70);
1249:
1250: END IF;
1251:
1252: -- Fetch the balance for the classification and populate the corresponding

Line 1260: hr_utility.set_location(l_package||l_procedure, 80);

1256: 'SUPPLEMENTAL EARNINGS',
1257: 'IMPUTED EARNINGS',
1258: 'EMPLOYER LIABILITIES',
1259: 'NON-PAYROLL PAYMENTS') THEN
1260: hr_utility.set_location(l_package||l_procedure, 80);
1261:
1262: IF p_flag='Y' THEN
1263: IF p_balance_level='ASG' THEN
1264: p_earn_data(j).ptd :=get_defined_bal(p_earn_data(j).element_information10,p_asg_ptd);

Line 1274: hr_utility.set_location(l_package||l_procedure, 90);

1270: p_earn_data(j).qtd :=get_defined_bal(p_earn_data(j).element_information10,p_per_qtd);
1271: p_earn_data(j).ytd :=get_defined_bal(p_earn_data(j).element_information10,p_per_ytd);
1272: END IF;
1273:
1274: hr_utility.set_location(l_package||l_procedure, 90);
1275:
1276: IF p_balance_level='ASG' THEN
1277: p_earn_data(j).ptd :=get_bal(p_earn_data(j).ptd,p_earn_data(j).element_information10);
1278: END IF;

Line 1283: hr_utility.set_location(l_package||l_procedure, 100);

1279: p_earn_data(j).month:=get_bal(p_earn_data(j).month,p_earn_data(j).element_information10);
1280: p_earn_data(j).qtd :=get_bal(p_earn_data(j).qtd,p_earn_data(j).element_information10);
1281: p_earn_data(j).ytd :=get_bal(p_earn_data(j).ytd,p_earn_data(j).element_information10);
1282:
1283: hr_utility.set_location(l_package||l_procedure, 100);
1284: END IF; -- End of p_flag
1285:
1286: IF p_element_type_id IS NULL THEN
1287: -- start of fetching balance values for earnings when

Line 1290: hr_utility.set_location(l_package||l_procedure, 110);

1286: IF p_element_type_id IS NULL THEN
1287: -- start of fetching balance values for earnings when
1288: -- element type id is not passed
1289: -- get DEFINED BALANCE IDS for asg/person for different time dimensions
1290: hr_utility.set_location(l_package||l_procedure, 110);
1291:
1292: IF p_earn_data.COUNT>0 THEN
1293:
1294: hr_utility.set_location(l_package||l_procedure, 120);

Line 1294: hr_utility.set_location(l_package||l_procedure, 120);

1290: hr_utility.set_location(l_package||l_procedure, 110);
1291:
1292: IF p_earn_data.COUNT>0 THEN
1293:
1294: hr_utility.set_location(l_package||l_procedure, 120);
1295:
1296: st_cnt := p_earn_data.first;
1297: end_cnt := p_earn_data.last;
1298:

Line 1313: hr_utility.set_location(l_package||l_procedure, 130);

1309: p_earn_data(i).ytd :=get_defined_bal(p_earn_data(i).element_information10,p_per_ytd);
1310: END IF;
1311: END IF;
1312: END LOOP;
1313: hr_utility.set_location(l_package||l_procedure, 130);
1314: END IF;
1315:
1316: -- end of fetching defined balance ids
1317:

Line 1318: hr_utility.set_location(l_package||l_procedure, 140);

1314: END IF;
1315:
1316: -- end of fetching defined balance ids
1317:
1318: hr_utility.set_location(l_package||l_procedure, 140);
1319:
1320: -- get BALANCE values stored for asg/person for different time dimensions
1321:
1322: IF p_earn_data.COUNT>0 THEN

Line 1326: hr_utility.set_location(l_package||l_procedure, 150);

1322: IF p_earn_data.COUNT>0 THEN
1323: st_cnt :=p_earn_data.first;
1324: end_cnt :=p_earn_data.last;
1325:
1326: hr_utility.set_location(l_package||l_procedure, 150);
1327:
1328: FOR i IN st_cnt..end_cnt LOOP
1329: IF p_earn_data.exists(i) THEN
1330: IF p_balance_level='ASG' THEN

Line 1339: hr_utility.set_location(l_package||l_procedure, 160);

1335: p_earn_data(i).ytd :=get_bal(p_earn_data(i).ytd,p_earn_data(i).element_information10);
1336: END IF;
1337: END LOOP;
1338:
1339: hr_utility.set_location(l_package||l_procedure, 160);
1340:
1341: END IF;
1342: -- End of fetching balance values for earnings.
1343: hr_utility.set_location(l_package||l_procedure, 170);

Line 1343: hr_utility.set_location(l_package||l_procedure, 170);

1339: hr_utility.set_location(l_package||l_procedure, 160);
1340:
1341: END IF;
1342: -- End of fetching balance values for earnings.
1343: hr_utility.set_location(l_package||l_procedure, 170);
1344: END IF;
1345: -- End of fetching all balance values for earnings
1346: -- when element_type_id is not passed
1347:

Line 1350: hr_utility.set_location(l_package||l_procedure, 180);

1346: -- when element_type_id is not passed
1347:
1348: ELSE -- get the values for deduction elements
1349:
1350: hr_utility.set_location(l_package||l_procedure, 180);
1351:
1352: -- copy element information in the earning table to the deductions table
1353: get_dedn_info(p_earn_data,p_dedn_data);
1354: p_earn_data.delete;

Line 1371: hr_utility.set_location(l_package||l_procedure, 190);

1367: p_dedn_data(j).accrued := get_defined_bal(p_dedn_data(j).element_information11,p_asg_itd);
1368: p_dedn_data(j).arrears := get_defined_bal(p_dedn_data(j).element_information12,p_asg_itd);
1369: p_dedn_data(j).tobond := get_defined_bal(p_dedn_data(j).element_information14,p_asg_itd);
1370:
1371: hr_utility.set_location(l_package||l_procedure, 190);
1372:
1373: IF p_balance_level='ASG' THEN
1374: p_dedn_data(j).ptd :=get_bal(p_dedn_data(j).ptd,p_dedn_data(j).element_information10);
1375: END IF;

Line 1383: hr_utility.set_location(l_package||l_procedure, 200);

1379: p_dedn_data(j).accrued :=get_bal(p_dedn_data(j).accrued,p_dedn_data(j).element_information11);
1380: p_dedn_data(j).arrears :=get_bal(p_dedn_data(j).arrears,p_dedn_data(j).element_information12);
1381: p_dedn_data(j).tobond :=get_bal(p_dedn_data(j).tobond,p_dedn_data(j).element_information14);
1382:
1383: hr_utility.set_location(l_package||l_procedure, 200);
1384: END IF;--End of fetching balance values when p_flag is 'Y'
1385:
1386: --start of code when element_type_id is not passed for deductions.
1387: --So all balance values are to be retrieved

Line 1394: hr_utility.set_location(l_package||l_procedure, 210);

1390: IF p_dedn_data.COUNT>0 THEN
1391: st_cnt :=p_dedn_data.first;
1392: end_cnt :=p_dedn_data.last;
1393:
1394: hr_utility.set_location(l_package||l_procedure, 210);
1395:
1396: FOR i IN st_cnt..end_cnt LOOP
1397: IF p_dedn_data.exists(i) THEN
1398: IF p_balance_level='ASG' THEN

Line 1413: hr_utility.set_location(l_package||l_procedure, 220);

1409: p_dedn_data(i).arrears := get_defined_bal(p_dedn_data(i).element_information12,p_asg_itd);
1410: p_dedn_data(i).tobond := get_defined_bal(p_dedn_data(i).element_information14,p_asg_itd);
1411: END IF;
1412: END LOOP;
1413: hr_utility.set_location(l_package||l_procedure, 220);
1414:
1415: END IF;
1416:
1417: hr_utility.set_location(l_package||l_procedure, 230);

Line 1417: hr_utility.set_location(l_package||l_procedure, 230);

1413: hr_utility.set_location(l_package||l_procedure, 220);
1414:
1415: END IF;
1416:
1417: hr_utility.set_location(l_package||l_procedure, 230);
1418:
1419: -- get the balance values.
1420: IF p_dedn_data.COUNT>0 THEN
1421: st_cnt :=p_dedn_data.first;

Line 1424: hr_utility.set_location(l_package||l_procedure, 240);

1420: IF p_dedn_data.COUNT>0 THEN
1421: st_cnt :=p_dedn_data.first;
1422: end_cnt :=p_dedn_data.last;
1423:
1424: hr_utility.set_location(l_package||l_procedure, 240);
1425:
1426: FOR i IN st_cnt..end_cnt LOOP
1427:
1428: IF p_dedn_data.exists(i) THEN

Line 1441: hr_utility.set_location(l_package||l_procedure, 250);

1437: p_dedn_data(i).tobond :=get_bal(p_dedn_data(i).tobond,p_dedn_data(i).element_information14);
1438: END IF;
1439:
1440: END LOOP;
1441: hr_utility.set_location(l_package||l_procedure, 250);
1442:
1443: END IF; -- End of fetching balance values
1444:
1445: hr_utility.set_location(l_package||l_procedure, 260);

Line 1445: hr_utility.set_location(l_package||l_procedure, 260);

1441: hr_utility.set_location(l_package||l_procedure, 250);
1442:
1443: END IF; -- End of fetching balance values
1444:
1445: hr_utility.set_location(l_package||l_procedure, 260);
1446:
1447: END IF; -- End of fetching balances when p_element_type_id is null;
1448: hr_utility.set_location(l_package||l_procedure, 270);
1449: END IF; --end earnings/deduction elements

Line 1448: hr_utility.set_location(l_package||l_procedure, 270);

1444:
1445: hr_utility.set_location(l_package||l_procedure, 260);
1446:
1447: END IF; -- End of fetching balances when p_element_type_id is null;
1448: hr_utility.set_location(l_package||l_procedure, 270);
1449: END IF; --end earnings/deduction elements
1450:
1451: END IF; --End Assignmentaction/assignment mode
1452:

Line 1453: hr_utility.set_location(l_package||l_procedure, 30);

1449: END IF; --end earnings/deduction elements
1450:
1451: END IF; --End Assignmentaction/assignment mode
1452:
1453: hr_utility.set_location(l_package||l_procedure, 30);
1454:
1455: ELSIF l_type='I' THEN
1456:
1457: hr_utility.set_location(l_package||l_procedure, 40);

Line 1457: hr_utility.set_location(l_package||l_procedure, 40);

1453: hr_utility.set_location(l_package||l_procedure, 30);
1454:
1455: ELSIF l_type='I' THEN
1456:
1457: hr_utility.set_location(l_package||l_procedure, 40);
1458:
1459: I:=0;
1460: get_asg_date; -- Get the correct assignment id and date
1461: hr_utility.set_location('Balance Initialization ASG/PER level balances', 300);

Line 1461: hr_utility.set_location('Balance Initialization ASG/PER level balances', 300);

1457: hr_utility.set_location(l_package||l_procedure, 40);
1458:
1459: I:=0;
1460: get_asg_date; -- Get the correct assignment id and date
1461: hr_utility.set_location('Balance Initialization ASG/PER level balances', 300);
1462: OPEN c_element_asg_balances;
1463: LOOP
1464: FETCH c_element_asg_balances INTO
1465: p_earn_data(i).row_id

Line 1525: hr_utility.set_location(l_package||l_procedure, 50);

1521: NULL) ;
1522: END LOOP;
1523: p_dedn_data_temp.delete();
1524: END IF;
1525: hr_utility.set_location(l_package||l_procedure, 50);
1526: END IF; -- l_type check
1527:
1528: IF p_element_type_id IS NOT NULL and p_assignment_action_id <> -1 THEN
1529: IF UPPER(p_classification_name) IN ('INVOLUNTARY DEDUCTIONS' ,

Line 1536: hr_utility.set_location(l_package||l_procedure, 60);

1532: IF p_dedn_data.count>0 THEN
1533: st_cnt := p_dedn_data.first;
1534: end_cnt := p_dedn_data.last;
1535:
1536: hr_utility.set_location(l_package||l_procedure, 60);
1537:
1538: FOR i IN st_cnt..end_cnt LOOP
1539: IF p_dedn_data.exists(i) THEN
1540: IF p_element_type_id=p_dedn_data(i).element_type_id THEN

Line 1554: hr_utility.set_location(l_package||l_procedure, 60);

1550: IF p_earn_data.count>0 THEN
1551: st_cnt := p_earn_data.first;
1552: end_cnt := p_earn_data.last;
1553:
1554: hr_utility.set_location(l_package||l_procedure, 60);
1555:
1556: FOR i IN st_cnt..end_cnt LOOP
1557: IF p_earn_data.exists(i) THEN
1558: IF p_element_type_id=p_earn_data(i).element_type_id THEN

Line 1567: hr_utility.set_location(l_package||l_procedure, 70);

1563: END IF;
1564: END IF;
1565: END LOOP;
1566: END IF;
1567: hr_utility.set_location(l_package||l_procedure, 70);
1568: END IF; --Earnings/Deduction
1569: END IF; -- ELEMENT_TYPE_ID is not null
1570: -- Fetch the balance for the classification and populate the corresponding
1571: -- PLSQL table to be used by form

Line 1575: hr_utility.set_location(l_package||l_procedure, 280);

1571: -- PLSQL table to be used by form
1572:
1573: EXCEPTION
1574: WHEN others THEN
1575: hr_utility.set_location(l_package||l_procedure, 280);
1576: raise_application_error(-20101, 'Error in '||l_package||l_procedure || ' - ' || sqlerrm);
1577: END;
1578: END pay_us_employee_balances;
1579: