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

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

239: BEGIN
240: l_procedure :='populate_element_info';
241:
242: IF p_purge = 'Y' THEN
243: hr_utility.set_location(l_package||l_procedure, 10);
244:
245: DELETE PAY_US_RPT_TOTALS
246: WHERE GRE_NAME = 'IP_VIEW_BALANCE'
247: AND ORGANIZATION_NAME IN ('ASG','PER');

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

246: WHERE GRE_NAME = 'IP_VIEW_BALANCE'
247: AND ORGANIZATION_NAME IN ('ASG','PER');
248: COMMIT;
249:
250: hr_utility.set_location(l_package||l_procedure, 20);
251: END IF;
252: END;
253:
254:

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

262: l_valid_asg varchar2(1) := 'Y';
263: l_function varchar2(22);
264: BEGIN
265: l_function :='validate_assignment';
266: hr_utility.set_location(l_package||l_function, 10);
267:
268: SELECT 'Y'
269: INTO l_valid_asg
270: FROM per_assignments_f paf

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

274: AND rownum=1;
275:
276: RETURN l_valid_asg;
277:
278: hr_utility.set_location(l_package||l_function, 20);
279: EXCEPTION WHEN NO_DATA_FOUND THEN
280: hr_utility.set_location(l_package||l_function, 30);
281: RETURN 'N';
282: END;

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

276: RETURN l_valid_asg;
277:
278: hr_utility.set_location(l_package||l_function, 20);
279: EXCEPTION WHEN NO_DATA_FOUND THEN
280: hr_utility.set_location(l_package||l_function, 30);
281: RETURN 'N';
282: END;
283:
284: /******************************************************************************

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

755: l_function varchar2(16);
756: l_dim_id number;
757: BEGIN
758: l_function :='get_defined_bal';
759: hr_utility.set_location(l_package||l_function, 10);
760:
761: SELECT balance_dimension_id INTO l_dim_id
762: FROM pay_balance_dimensions
763: WHERE database_item_suffix = p_dimension

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

769: AND balance_dimension_id = l_dim_id
770: AND nvl(business_group_id,p_business_group_id) = p_business_group_id
771: AND nvl(legislation_code,l_legislation_code) = l_legislation_code;
772:
773: hr_utility.set_location(l_package||l_function, 20);
774:
775: RETURN l_defbal_id;
776:
777: EXCEPTION

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

775: RETURN l_defbal_id;
776:
777: EXCEPTION
778: WHEN NO_DATA_FOUND THEN
779: hr_utility.set_location(l_package||l_function, 30);
780: RETURN -1;
781: END;
782:
783:

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

801: l_value number := NULL;
802:
803: BEGIN
804: l_function :='get_bal';
805: hr_utility.set_location(l_package||l_function, 10);
806: IF (p_assignment_action_id = -1 ) THEN
807: IF p_balance_level='PER' THEN
808: l_ytd_id := get_defined_bal(p_bal_type_id,l_dim_ytd);
809: l_qtd_id := get_defined_bal(p_bal_type_id,l_dim_qtd);

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

808: l_ytd_id := get_defined_bal(p_bal_type_id,l_dim_ytd);
809: l_qtd_id := get_defined_bal(p_bal_type_id,l_dim_qtd);
810: l_mtd_id := get_defined_bal(p_bal_type_id,l_dim_mtd);
811:
812: hr_utility.set_location(l_package||l_function, 20);
813:
814: BEGIN
815: IF p_tax_unit_id <> -1 THEN
816: /*To check whether p_assignment_id exists as of p_session_date

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

839: AND paf.effective_end_date;
840: END IF;
841: l_temp_assignment_id := to_number(p_assignment_id);
842:
843: hr_utility.set_location(l_package||l_function, 30);
844:
845: EXCEPTION
846: WHEN NO_DATA_FOUND THEN
847: BEGIN

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

848: IF p_tax_unit_id <> -1 THEN
849: /*Attempt to find any assignment id for the person as of p_session_date
850: when the localization is based on the Tax Unit Id architecture.
851: */
852: hr_utility.set_location(l_package||l_function, 40);
853:
854: SELECT paf2.assignment_id
855: INTO l_temp_assignment_id
856: FROM per_assignments_f paf1,

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

877: AND p_session_date BETWEEN paf2.effective_start_date
878: AND paf2.effective_end_date
879: AND rownum=1;
880: END IF;
881: hr_utility.set_location(l_package||l_function, 50);
882: EXCEPTION
883: WHEN NO_DATA_FOUND THEN
884: BEGIN
885: IF p_tax_unit_id <> -1 THEN

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

886: /* Attempt to find an assignment id for the person with end date < p_session_date
887: and greater than pay_ip_route_support.tax_year(p_business_group_id,p_session_date)
888: when the localization is based on Tax Unit Id architecture.
889: */
890: hr_utility.set_location(l_package||l_function, 60);
891: SELECT paf2.assignment_id
892: INTO l_temp_assignment_id
893: FROM per_assignments_f paf1,
894: per_assignments_f paf2,

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

928: )
929: AND rownum=1;
930:
931: END IF;
932: hr_utility.set_location(l_package||l_function, 70);
933: EXCEPTION
934: WHEN NO_DATA_FOUND THEN
935: hr_utility.set_location(l_package||l_function, 80);
936: NULL;

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

931: END IF;
932: hr_utility.set_location(l_package||l_function, 70);
933: EXCEPTION
934: WHEN NO_DATA_FOUND THEN
935: hr_utility.set_location(l_package||l_function, 80);
936: NULL;
937: END;
938: END;
939: END;

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

937: END;
938: END;
939: END;
940: ELSE -- ELSE clause for p_balance_level='PER'
941: hr_utility.set_location(l_package||l_function, 90);
942:
943: l_temp_assignment_id := p_assignment_id;
944: l_ytd_id := get_defined_bal(p_bal_type_id,l_dim_ytd);
945: l_qtd_id := get_defined_bal(p_bal_type_id,l_dim_qtd);

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

943: l_temp_assignment_id := p_assignment_id;
944: l_ytd_id := get_defined_bal(p_bal_type_id,l_dim_ytd);
945: l_qtd_id := get_defined_bal(p_bal_type_id,l_dim_qtd);
946: END IF; -- END IF clause for p_balance_level='PER'
947: hr_utility.set_location(l_package||l_function, 100);
948:
949: /* find the actual termination of final process date for the assignment*/
950: l_date := payvwele.get_fpd_or_atd(p_assignment_id => l_temp_assignment_id,
951: p_session_date => p_session_date);

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

956: l_last_process_date := l_date;
957: END IF;
958: END IF;
959:
960: hr_utility.set_location(l_package||l_function,110);
961:
962: IF l_date IS NULL THEN
963: l_date := p_session_date; -- Current Employee
964: ELSIF l_date >= p_session_date THEN

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

995: ELSE
996: -- Assignment terminated this year and this month show all balances
997: l_date := p_session_date;
998: END IF;
999: hr_utility.set_location(l_package||l_function,120);
1000:
1001: -- set TAX_UNIT_ID context
1002: IF p_tax_unit_id <> -1 THEN
1003: pay_balance_pkg.set_context ('TAX_UNIT_ID', TO_CHAR(p_tax_unit_id));

Line 1006: hr_utility.trace('p_defbal_id: '||to_char(p_defbal_id));

1002: IF p_tax_unit_id <> -1 THEN
1003: pay_balance_pkg.set_context ('TAX_UNIT_ID', TO_CHAR(p_tax_unit_id));
1004: END IF;
1005:
1006: hr_utility.trace('p_defbal_id: '||to_char(p_defbal_id));
1007: hr_utility.trace('l_temp_assignment_id: '||to_char(l_temp_assignment_id));
1008: hr_utility.trace('l_date: '||to_char(l_date));
1009:
1010: IF l_date <> to_date('31-12-4712','DD-MM-YYYY') THEN

Line 1007: hr_utility.trace('l_temp_assignment_id: '||to_char(l_temp_assignment_id));

1003: pay_balance_pkg.set_context ('TAX_UNIT_ID', TO_CHAR(p_tax_unit_id));
1004: END IF;
1005:
1006: hr_utility.trace('p_defbal_id: '||to_char(p_defbal_id));
1007: hr_utility.trace('l_temp_assignment_id: '||to_char(l_temp_assignment_id));
1008: hr_utility.trace('l_date: '||to_char(l_date));
1009:
1010: IF l_date <> to_date('31-12-4712','DD-MM-YYYY') THEN
1011: hr_utility.set_location(l_package||l_function, 130);

Line 1008: hr_utility.trace('l_date: '||to_char(l_date));

1004: END IF;
1005:
1006: hr_utility.trace('p_defbal_id: '||to_char(p_defbal_id));
1007: hr_utility.trace('l_temp_assignment_id: '||to_char(l_temp_assignment_id));
1008: hr_utility.trace('l_date: '||to_char(l_date));
1009:
1010: IF l_date <> to_date('31-12-4712','DD-MM-YYYY') THEN
1011: hr_utility.set_location(l_package||l_function, 130);
1012:

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

1007: hr_utility.trace('l_temp_assignment_id: '||to_char(l_temp_assignment_id));
1008: hr_utility.trace('l_date: '||to_char(l_date));
1009:
1010: IF l_date <> to_date('31-12-4712','DD-MM-YYYY') THEN
1011: hr_utility.set_location(l_package||l_function, 130);
1012:
1013: l_value := pay_balance_pkg.get_value_lock( p_defined_balance_id => p_defbal_id,
1014: p_assignment_id => l_temp_assignment_id,
1015: p_virtual_date => l_date,

Line 1019: hr_utility.set_location(l_package||l_function, 140);

1015: p_virtual_date => l_date,
1016: p_asg_lock => 'N' );
1017:
1018: END IF;
1019: hr_utility.set_location(l_package||l_function, 140);
1020:
1021: END IF;-- END IF clause for p_assignment_action_id = -1
1022:
1023: hr_utility.set_location(l_package||l_function, 150);

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

1019: hr_utility.set_location(l_package||l_function, 140);
1020:
1021: END IF;-- END IF clause for p_assignment_action_id = -1
1022:
1023: hr_utility.set_location(l_package||l_function, 150);
1024:
1025: RETURN l_value;
1026:
1027: EXCEPTION

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

1025: RETURN l_value;
1026:
1027: EXCEPTION
1028: WHEN NO_DATA_FOUND THEN
1029: hr_utility.set_location(l_package||l_function, 160);
1030: RETURN NULL;
1031: END; --End of function get_bal
1032:
1033:

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

1041: RETURN NUMBER IS
1042: l_function VARCHAR2(30);
1043: BEGIN
1044: l_function :='fetch_and_store_balances';
1045: hr_utility.set_location(l_package||l_function, 10);
1046: IF UPPER(p_classification_name) IN ('INVOLUNTARY DEDUCTIONS' ,
1047: 'VOLUNTARY DEDUCTIONS',
1048: 'PRE-TAX DEDUCTIONS',
1049: 'TAX DEDUCTIONS') THEN

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

1047: 'VOLUNTARY DEDUCTIONS',
1048: 'PRE-TAX DEDUCTIONS',
1049: 'TAX DEDUCTIONS') THEN
1050:
1051: hr_utility.set_location(l_package||l_function, 20);
1052:
1053: t_defbal_details_tab.delete; -- purging the pl/sql table to clear any old data.
1054: FOR i IN 0 .. t_deduction_tab.count-1
1055: LOOP

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

1069: t_defbal_details_tab(k.defined_balance_id).bal_type_id := k.balance_type_id;
1070: t_defbal_details_tab(k.defined_balance_id).bal_dim_id := k.balance_dimension_id;
1071: t_defbal_details_tab(k.defined_balance_id).defbal_type := k.database_item_suffix;
1072: END LOOP;
1073: hr_utility.set_location(l_package||l_function, 30);
1074:
1075: --Fetch the Arrears Balance Details
1076: k:=0;
1077: FOR k IN c_get_asg_arr_defbal (t_deduction_tab(i).element_information11)

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

1083: t_defbal_details_tab(k.defined_balance_id).bal_type_id := k.balance_type_id;
1084: t_defbal_details_tab(k.defined_balance_id).bal_dim_id := k.balance_dimension_id;
1085: t_defbal_details_tab(k.defined_balance_id).defbal_type := 'ASG_ARR_ITD';
1086: END LOOP;
1087: hr_utility.set_location(l_package||l_function, 40);
1088:
1089: --Fetch the Accruals Balance Details
1090: k:=0;
1091: FOR k IN c_get_asg_acc_defbal (t_deduction_tab(i).element_information13)

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

1098: t_defbal_details_tab(k.defined_balance_id).bal_dim_id := k.balance_dimension_id;
1099: t_defbal_details_tab(k.defined_balance_id).defbal_type := 'ASG_ACC_ITD';
1100: END LOOP;
1101:
1102: hr_utility.set_location(l_package||l_function, 50);
1103:
1104: ELSIF p_balance_level = 'PER' THEN
1105: /*The following code is written to fetch the element details and Person
1106: level defined balance details for Deductions Type elements and are stored

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

1115: t_defbal_details_tab(k.defined_balance_id).bal_type_id := k.balance_type_id;
1116: t_defbal_details_tab(k.defined_balance_id).bal_dim_id := k.balance_dimension_id;
1117: t_defbal_details_tab(k.defined_balance_id).defbal_type := k.database_item_suffix;
1118: END LOOP;
1119: hr_utility.set_location(l_package||l_function, 60);
1120: END IF; -- END IF clause for p_balance_level
1121: END IF; -- END IF clause for t_deduction_tab.exists(i)
1122: END LOOP;
1123:

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

1120: END IF; -- END IF clause for p_balance_level
1121: END IF; -- END IF clause for t_deduction_tab.exists(i)
1122: END LOOP;
1123:
1124: hr_utility.set_location(l_package||l_function, 70);
1125:
1126: ELSE -- ELSE clause for UPPER(classification_name)
1127: hr_utility.set_location(l_package||l_function, 80);
1128:

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

1123:
1124: hr_utility.set_location(l_package||l_function, 70);
1125:
1126: ELSE -- ELSE clause for UPPER(classification_name)
1127: hr_utility.set_location(l_package||l_function, 80);
1128:
1129: -- Purge the pl/sql table to clear any old data.
1130: t_defbal_details_tab.delete;
1131: FOR i IN 0 .. t_earnings_tab.count-1

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

1146: t_defbal_details_tab(k.defined_balance_id).bal_type_id := k.balance_type_id;
1147: t_defbal_details_tab(k.defined_balance_id).bal_dim_id := k.balance_dimension_id;
1148: t_defbal_details_tab(k.defined_balance_id).defbal_type := k.database_item_suffix;
1149: END LOOP;
1150: hr_utility.set_location(l_package||l_function, 90);
1151:
1152: ELSIF p_balance_level = 'PER' THEN
1153: /*The following code is written to fetch the element details and Person
1154: level defined balance details for Earnings Type elements and are stored

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

1166: t_defbal_details_tab(k.defined_balance_id).bal_type_id := k.balance_type_id;
1167: t_defbal_details_tab(k.defined_balance_id).bal_dim_id := k.balance_dimension_id;
1168: t_defbal_details_tab(k.defined_balance_id).defbal_type := k.database_item_suffix;
1169: END LOOP;
1170: hr_utility.set_location(l_package||l_function, 100);
1171: END IF; -- END IF clause for p_balance_level
1172: END IF; -- END IF clause for t_earnings_tab.exists(i)
1173: END LOOP;
1174:

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

1171: END IF; -- END IF clause for p_balance_level
1172: END IF; -- END IF clause for t_earnings_tab.exists(i)
1173: END LOOP;
1174:
1175: hr_utility.set_location(l_package||l_function, 110);
1176:
1177: END IF; -- END IF clause for UPPER(classification_name)
1178: hr_utility.set_location(l_package||l_function, 120);
1179:

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

1174:
1175: hr_utility.set_location(l_package||l_function, 110);
1176:
1177: END IF; -- END IF clause for UPPER(classification_name)
1178: hr_utility.set_location(l_package||l_function, 120);
1179:
1180: -- purging the pl/sql table to clear any old data.
1181: t_ele_bal_horizontal_tab.delete;
1182:

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

1207: t_ele_bal_horizontal_tab(t_defbal_details_tab(i).bal_type_id).bal_type_id := t_defbal_details_tab(i).bal_type_id;
1208: END IF;
1209: END IF;
1210: END LOOP;
1211: hr_utility.set_location(l_package||l_function, 130);
1212:
1213: -- The page is called in assignment action mode
1214: IF p_assignment_action_id <> -1 THEN
1215: IF p_tax_unit_id <> -1 THEN

Line 1220: hr_utility.set_location(l_package||l_function, 140);

1216: t_eb_bal_context_tab(1).tax_unit_id:= p_tax_unit_id;
1217: ELSE
1218: t_eb_bal_context_tab(1).tax_unit_id:= NULL;
1219: END IF;
1220: hr_utility.set_location(l_package||l_function, 140);
1221:
1222: -- purging the pl/sql table to clear any old data.
1223: t_eb_balance_value_tab.delete;
1224:

Line 1237: hr_utility.trace('Defined Balance Type is: '||t_defbal_details_tab(i).defbal_type);

1233: j:=1;
1234: FOR i IN t_defbal_details_tab.first..t_defbal_details_tab.last
1235: LOOP
1236: IF t_defbal_details_tab.exists(i) THEN
1237: hr_utility.trace('Defined Balance Type is: '||t_defbal_details_tab(i).defbal_type);
1238: IF (t_defbal_details_tab(i).defbal_type IN ('_ASG_PTD','_ASG_TU_PTD') AND p_asg_ptd = 1) OR
1239: (t_defbal_details_tab(i).defbal_type IN ('_ASG_MONTH','_ASG_TU_MONTH') AND p_asg_month = 1) OR
1240: (t_defbal_details_tab(i).defbal_type IN ('_ASG_TQTD','_ASG_TU_TQTD') AND p_asg_qtd = 1) OR
1241: (t_defbal_details_tab(i).defbal_type IN ('_ASG_TYTD','_ASG_TU_TYTD') AND p_asg_ytd = 1) OR

Line 1249: hr_utility.trace('Defined Balance id to be sent to pay_balance_pkg is '||to_char(t_eb_balance_value_tab(j).defined_balance_id));

1245: (t_defbal_details_tab(i).defbal_type IN ('_PER_TQTD','_PER_TU_TQTD') AND p_per_qtd = 1) OR
1246: (t_defbal_details_tab(i).defbal_type IN ('_PER_TYTD','_PER_TU_TYTD') AND p_per_ytd = 1)
1247: THEN
1248: t_eb_balance_value_tab(j).defined_balance_id:=t_defbal_details_tab(i).def_bal_id;
1249: hr_utility.trace('Defined Balance id to be sent to pay_balance_pkg is '||to_char(t_eb_balance_value_tab(j).defined_balance_id));
1250: j:=j+1;
1251: END IF;
1252: END IF;
1253: END LOOP;

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

1258: t_eb_bal_context_tab pl/sql table with the balance context values,
1259: t_eb_bal_result_tab emplty pl/sql table that will hold the balance values
1260: along with the defined balance ids as parameters to the pay_balance_pkg call.
1261: */
1262: hr_utility.set_location(l_package||l_function, 150);
1263: pay_balance_pkg.get_value
1264: (p_assignment_action_id => p_assignment_action_id
1265: ,p_defined_balance_lst => t_eb_balance_value_tab
1266: ,p_context_lst => t_eb_bal_context_tab

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

1266: ,p_context_lst => t_eb_bal_context_tab
1267: ,p_output_table => t_eb_bal_result_tab
1268: );
1269:
1270: hr_utility.set_location(l_package||l_function, 160);
1271:
1272: FOR i IN t_eb_bal_result_tab.first..t_eb_bal_result_tab.last
1273: LOOP
1274: IF t_eb_bal_result_tab.exists(i) THEN

Line 1292: hr_utility.set_location(l_package||l_function, 170);

1288: the balance value for the current defined balance id. These balance values are stored in the
1289: pl/sql table t_defbal_details_tab.
1290: */
1291:
1292: hr_utility.set_location(l_package||l_function, 170);
1293:
1294: FOR i IN t_defbal_details_tab.first..t_defbal_details_tab.last
1295: LOOP
1296: IF t_defbal_details_tab.exists(i) THEN

Line 1308: hr_utility.trace('Defined Balance id for which the balance value needs to be fetched is '||to_char(t_defbal_details_tab(i).def_bal_id));

1304: (t_defbal_details_tab(i).defbal_type IN ('_PER_TQTD','_PER_TU_TQTD') AND p_per_qtd = 1) OR
1305: (t_defbal_details_tab(i).defbal_type IN ('_PER_TYTD','_PER_TU_TYTD') AND p_per_ytd = 1)
1306: THEN
1307: t_defbal_details_tab(i).bal_value := get_bal(t_defbal_details_tab(i).def_bal_id,t_defbal_details_tab(i).bal_type_id);
1308: hr_utility.trace('Defined Balance id for which the balance value needs to be fetched is '||to_char(t_defbal_details_tab(i).def_bal_id));
1309: END IF;
1310: END IF;
1311: END LOOP;
1312: hr_utility.set_location(l_package||l_function, 180);

Line 1312: hr_utility.set_location(l_package||l_function, 180);

1308: hr_utility.trace('Defined Balance id for which the balance value needs to be fetched is '||to_char(t_defbal_details_tab(i).def_bal_id));
1309: END IF;
1310: END IF;
1311: END LOOP;
1312: hr_utility.set_location(l_package||l_function, 180);
1313: END IF; -- END IF clause for p_assignment_action_id <> -1
1314:
1315: hr_utility.set_location(l_package||l_function, 190);
1316: FOR i IN t_defbal_details_tab.first..t_defbal_details_tab.last

Line 1315: hr_utility.set_location(l_package||l_function, 190);

1311: END LOOP;
1312: hr_utility.set_location(l_package||l_function, 180);
1313: END IF; -- END IF clause for p_assignment_action_id <> -1
1314:
1315: hr_utility.set_location(l_package||l_function, 190);
1316: FOR i IN t_defbal_details_tab.first..t_defbal_details_tab.last
1317: LOOP
1318: IF t_defbal_details_tab.exists(i) THEN
1319: IF t_defbal_details_tab(i).defbal_type IN ('_ASG_PTD','_ASG_TU_PTD') THEN

Line 1349: hr_utility.set_location(l_package||l_function, 200);

1345: t_ele_bal_horizontal_tab(t_defbal_details_tab(i).bal_type_id).ytd_bal_value := t_defbal_details_tab(i).bal_value;
1346: END IF;
1347: END IF;
1348: END LOOP;
1349: hr_utility.set_location(l_package||l_function, 200);
1350:
1351: RETURN 1;
1352:
1353: EXCEPTION

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

1367: l_function VARCHAR2(30);
1368: l_id_value number;
1369: BEGIN
1370: l_function :='populate_tab_rpt_totals';
1371: hr_utility.set_location(l_package||l_function, 10);
1372:
1373: IF p_insert_flag = 'Y' THEN
1374: hr_utility.set_location(l_package||l_function, 20);
1375: FOR i IN t_ele_bal_horizontal_tab.first..t_ele_bal_horizontal_tab.last

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

1370: l_function :='populate_tab_rpt_totals';
1371: hr_utility.set_location(l_package||l_function, 10);
1372:
1373: IF p_insert_flag = 'Y' THEN
1374: hr_utility.set_location(l_package||l_function, 20);
1375: FOR i IN t_ele_bal_horizontal_tab.first..t_ele_bal_horizontal_tab.last
1376: LOOP
1377: IF t_ele_bal_horizontal_tab.exists(i) THEN
1378: IF t_ele_bal_horizontal_tab(i).arr_bal_dim_id IS NOT NULL THEN

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

1424: t_ele_bal_horizontal_tab(i).acc_bal_dim_id,
1425: t_ele_bal_horizontal_tab(i).acc_bal_value);
1426: END IF; -- END IF clause for t_ele_bal_horizontal_tab.exists(i)
1427: END LOOP;
1428: hr_utility.set_location(l_package||l_function, 30);
1429: RETURN 1;
1430: END IF; -- END IF clause for p_insert_flag
1431:
1432: EXCEPTION

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

1439: BEGIN -- populate_element_info
1440:
1441: l_procedure :='populate_element_info';
1442:
1443: hr_utility.set_location(l_package||l_procedure, 10);
1444: hr_utility.trace('p_assignment_id: '||to_char(p_assignment_id));
1445: hr_utility.trace('p_assignment_action_id: '||to_char(p_assignment_action_id));
1446: hr_utility.trace('p_classification_name: '||to_char(p_classification_name));
1447: hr_utility.trace('p_session_date: '||to_char(p_session_date));

Line 1444: hr_utility.trace('p_assignment_id: '||to_char(p_assignment_id));

1440:
1441: l_procedure :='populate_element_info';
1442:
1443: hr_utility.set_location(l_package||l_procedure, 10);
1444: hr_utility.trace('p_assignment_id: '||to_char(p_assignment_id));
1445: hr_utility.trace('p_assignment_action_id: '||to_char(p_assignment_action_id));
1446: hr_utility.trace('p_classification_name: '||to_char(p_classification_name));
1447: hr_utility.trace('p_session_date: '||to_char(p_session_date));
1448: hr_utility.trace('p_tax_unit_id: '||to_char(p_tax_unit_id));

Line 1445: hr_utility.trace('p_assignment_action_id: '||to_char(p_assignment_action_id));

1441: l_procedure :='populate_element_info';
1442:
1443: hr_utility.set_location(l_package||l_procedure, 10);
1444: hr_utility.trace('p_assignment_id: '||to_char(p_assignment_id));
1445: hr_utility.trace('p_assignment_action_id: '||to_char(p_assignment_action_id));
1446: hr_utility.trace('p_classification_name: '||to_char(p_classification_name));
1447: hr_utility.trace('p_session_date: '||to_char(p_session_date));
1448: hr_utility.trace('p_tax_unit_id: '||to_char(p_tax_unit_id));
1449: hr_utility.trace('p_per_month: '||to_char(p_per_month));

Line 1446: hr_utility.trace('p_classification_name: '||to_char(p_classification_name));

1442:
1443: hr_utility.set_location(l_package||l_procedure, 10);
1444: hr_utility.trace('p_assignment_id: '||to_char(p_assignment_id));
1445: hr_utility.trace('p_assignment_action_id: '||to_char(p_assignment_action_id));
1446: hr_utility.trace('p_classification_name: '||to_char(p_classification_name));
1447: hr_utility.trace('p_session_date: '||to_char(p_session_date));
1448: hr_utility.trace('p_tax_unit_id: '||to_char(p_tax_unit_id));
1449: hr_utility.trace('p_per_month: '||to_char(p_per_month));
1450: hr_utility.trace('p_per_qtd: '||to_char(p_per_qtd));

Line 1447: hr_utility.trace('p_session_date: '||to_char(p_session_date));

1443: hr_utility.set_location(l_package||l_procedure, 10);
1444: hr_utility.trace('p_assignment_id: '||to_char(p_assignment_id));
1445: hr_utility.trace('p_assignment_action_id: '||to_char(p_assignment_action_id));
1446: hr_utility.trace('p_classification_name: '||to_char(p_classification_name));
1447: hr_utility.trace('p_session_date: '||to_char(p_session_date));
1448: hr_utility.trace('p_tax_unit_id: '||to_char(p_tax_unit_id));
1449: hr_utility.trace('p_per_month: '||to_char(p_per_month));
1450: hr_utility.trace('p_per_qtd: '||to_char(p_per_qtd));
1451: hr_utility.trace('p_per_ytd: '||to_char(p_per_ytd));

Line 1448: hr_utility.trace('p_tax_unit_id: '||to_char(p_tax_unit_id));

1444: hr_utility.trace('p_assignment_id: '||to_char(p_assignment_id));
1445: hr_utility.trace('p_assignment_action_id: '||to_char(p_assignment_action_id));
1446: hr_utility.trace('p_classification_name: '||to_char(p_classification_name));
1447: hr_utility.trace('p_session_date: '||to_char(p_session_date));
1448: hr_utility.trace('p_tax_unit_id: '||to_char(p_tax_unit_id));
1449: hr_utility.trace('p_per_month: '||to_char(p_per_month));
1450: hr_utility.trace('p_per_qtd: '||to_char(p_per_qtd));
1451: hr_utility.trace('p_per_ytd: '||to_char(p_per_ytd));
1452: hr_utility.trace('p_asg_ptd: '||to_char(p_asg_ptd));

Line 1449: hr_utility.trace('p_per_month: '||to_char(p_per_month));

1445: hr_utility.trace('p_assignment_action_id: '||to_char(p_assignment_action_id));
1446: hr_utility.trace('p_classification_name: '||to_char(p_classification_name));
1447: hr_utility.trace('p_session_date: '||to_char(p_session_date));
1448: hr_utility.trace('p_tax_unit_id: '||to_char(p_tax_unit_id));
1449: hr_utility.trace('p_per_month: '||to_char(p_per_month));
1450: hr_utility.trace('p_per_qtd: '||to_char(p_per_qtd));
1451: hr_utility.trace('p_per_ytd: '||to_char(p_per_ytd));
1452: hr_utility.trace('p_asg_ptd: '||to_char(p_asg_ptd));
1453: hr_utility.trace('p_asg_month: '||to_char(p_asg_month));

Line 1450: hr_utility.trace('p_per_qtd: '||to_char(p_per_qtd));

1446: hr_utility.trace('p_classification_name: '||to_char(p_classification_name));
1447: hr_utility.trace('p_session_date: '||to_char(p_session_date));
1448: hr_utility.trace('p_tax_unit_id: '||to_char(p_tax_unit_id));
1449: hr_utility.trace('p_per_month: '||to_char(p_per_month));
1450: hr_utility.trace('p_per_qtd: '||to_char(p_per_qtd));
1451: hr_utility.trace('p_per_ytd: '||to_char(p_per_ytd));
1452: hr_utility.trace('p_asg_ptd: '||to_char(p_asg_ptd));
1453: hr_utility.trace('p_asg_month: '||to_char(p_asg_month));
1454: hr_utility.trace('p_asg_qtd: '||to_char(p_asg_qtd));

Line 1451: hr_utility.trace('p_per_ytd: '||to_char(p_per_ytd));

1447: hr_utility.trace('p_session_date: '||to_char(p_session_date));
1448: hr_utility.trace('p_tax_unit_id: '||to_char(p_tax_unit_id));
1449: hr_utility.trace('p_per_month: '||to_char(p_per_month));
1450: hr_utility.trace('p_per_qtd: '||to_char(p_per_qtd));
1451: hr_utility.trace('p_per_ytd: '||to_char(p_per_ytd));
1452: hr_utility.trace('p_asg_ptd: '||to_char(p_asg_ptd));
1453: hr_utility.trace('p_asg_month: '||to_char(p_asg_month));
1454: hr_utility.trace('p_asg_qtd: '||to_char(p_asg_qtd));
1455: hr_utility.trace('p_asg_ytd: '||to_char(p_asg_ytd));

Line 1452: hr_utility.trace('p_asg_ptd: '||to_char(p_asg_ptd));

1448: hr_utility.trace('p_tax_unit_id: '||to_char(p_tax_unit_id));
1449: hr_utility.trace('p_per_month: '||to_char(p_per_month));
1450: hr_utility.trace('p_per_qtd: '||to_char(p_per_qtd));
1451: hr_utility.trace('p_per_ytd: '||to_char(p_per_ytd));
1452: hr_utility.trace('p_asg_ptd: '||to_char(p_asg_ptd));
1453: hr_utility.trace('p_asg_month: '||to_char(p_asg_month));
1454: hr_utility.trace('p_asg_qtd: '||to_char(p_asg_qtd));
1455: hr_utility.trace('p_asg_ytd: '||to_char(p_asg_ytd));
1456: hr_utility.trace('p_asg_arr_itd: '||to_char(p_asg_arr_itd));

Line 1453: hr_utility.trace('p_asg_month: '||to_char(p_asg_month));

1449: hr_utility.trace('p_per_month: '||to_char(p_per_month));
1450: hr_utility.trace('p_per_qtd: '||to_char(p_per_qtd));
1451: hr_utility.trace('p_per_ytd: '||to_char(p_per_ytd));
1452: hr_utility.trace('p_asg_ptd: '||to_char(p_asg_ptd));
1453: hr_utility.trace('p_asg_month: '||to_char(p_asg_month));
1454: hr_utility.trace('p_asg_qtd: '||to_char(p_asg_qtd));
1455: hr_utility.trace('p_asg_ytd: '||to_char(p_asg_ytd));
1456: hr_utility.trace('p_asg_arr_itd: '||to_char(p_asg_arr_itd));
1457: hr_utility.trace('p_asg_acc_itd: '||to_char(p_asg_acc_itd));

Line 1454: hr_utility.trace('p_asg_qtd: '||to_char(p_asg_qtd));

1450: hr_utility.trace('p_per_qtd: '||to_char(p_per_qtd));
1451: hr_utility.trace('p_per_ytd: '||to_char(p_per_ytd));
1452: hr_utility.trace('p_asg_ptd: '||to_char(p_asg_ptd));
1453: hr_utility.trace('p_asg_month: '||to_char(p_asg_month));
1454: hr_utility.trace('p_asg_qtd: '||to_char(p_asg_qtd));
1455: hr_utility.trace('p_asg_ytd: '||to_char(p_asg_ytd));
1456: hr_utility.trace('p_asg_arr_itd: '||to_char(p_asg_arr_itd));
1457: hr_utility.trace('p_asg_acc_itd: '||to_char(p_asg_acc_itd));
1458: hr_utility.trace('p_business_group_id: '||to_char(p_business_group_id));

Line 1455: hr_utility.trace('p_asg_ytd: '||to_char(p_asg_ytd));

1451: hr_utility.trace('p_per_ytd: '||to_char(p_per_ytd));
1452: hr_utility.trace('p_asg_ptd: '||to_char(p_asg_ptd));
1453: hr_utility.trace('p_asg_month: '||to_char(p_asg_month));
1454: hr_utility.trace('p_asg_qtd: '||to_char(p_asg_qtd));
1455: hr_utility.trace('p_asg_ytd: '||to_char(p_asg_ytd));
1456: hr_utility.trace('p_asg_arr_itd: '||to_char(p_asg_arr_itd));
1457: hr_utility.trace('p_asg_acc_itd: '||to_char(p_asg_acc_itd));
1458: hr_utility.trace('p_business_group_id: '||to_char(p_business_group_id));
1459: hr_utility.trace('p_balance_level: '||to_char(p_balance_level));

Line 1456: hr_utility.trace('p_asg_arr_itd: '||to_char(p_asg_arr_itd));

1452: hr_utility.trace('p_asg_ptd: '||to_char(p_asg_ptd));
1453: hr_utility.trace('p_asg_month: '||to_char(p_asg_month));
1454: hr_utility.trace('p_asg_qtd: '||to_char(p_asg_qtd));
1455: hr_utility.trace('p_asg_ytd: '||to_char(p_asg_ytd));
1456: hr_utility.trace('p_asg_arr_itd: '||to_char(p_asg_arr_itd));
1457: hr_utility.trace('p_asg_acc_itd: '||to_char(p_asg_acc_itd));
1458: hr_utility.trace('p_business_group_id: '||to_char(p_business_group_id));
1459: hr_utility.trace('p_balance_level: '||to_char(p_balance_level));
1460:

Line 1457: hr_utility.trace('p_asg_acc_itd: '||to_char(p_asg_acc_itd));

1453: hr_utility.trace('p_asg_month: '||to_char(p_asg_month));
1454: hr_utility.trace('p_asg_qtd: '||to_char(p_asg_qtd));
1455: hr_utility.trace('p_asg_ytd: '||to_char(p_asg_ytd));
1456: hr_utility.trace('p_asg_arr_itd: '||to_char(p_asg_arr_itd));
1457: hr_utility.trace('p_asg_acc_itd: '||to_char(p_asg_acc_itd));
1458: hr_utility.trace('p_business_group_id: '||to_char(p_business_group_id));
1459: hr_utility.trace('p_balance_level: '||to_char(p_balance_level));
1460:
1461: l_action_date := payvwele.get_action_date(p_assignment_action_id);

Line 1458: hr_utility.trace('p_business_group_id: '||to_char(p_business_group_id));

1454: hr_utility.trace('p_asg_qtd: '||to_char(p_asg_qtd));
1455: hr_utility.trace('p_asg_ytd: '||to_char(p_asg_ytd));
1456: hr_utility.trace('p_asg_arr_itd: '||to_char(p_asg_arr_itd));
1457: hr_utility.trace('p_asg_acc_itd: '||to_char(p_asg_acc_itd));
1458: hr_utility.trace('p_business_group_id: '||to_char(p_business_group_id));
1459: hr_utility.trace('p_balance_level: '||to_char(p_balance_level));
1460:
1461: l_action_date := payvwele.get_action_date(p_assignment_action_id);
1462:

Line 1459: hr_utility.trace('p_balance_level: '||to_char(p_balance_level));

1455: hr_utility.trace('p_asg_ytd: '||to_char(p_asg_ytd));
1456: hr_utility.trace('p_asg_arr_itd: '||to_char(p_asg_arr_itd));
1457: hr_utility.trace('p_asg_acc_itd: '||to_char(p_asg_acc_itd));
1458: hr_utility.trace('p_business_group_id: '||to_char(p_business_group_id));
1459: hr_utility.trace('p_balance_level: '||to_char(p_balance_level));
1460:
1461: l_action_date := payvwele.get_action_date(p_assignment_action_id);
1462:
1463: SELECT MIN(ptp.start_date) first_period_start_date

Line 1471: hr_utility.trace('l_action_date: '||to_char(l_action_date));

1467: WHERE paf.assignment_id = p_assignment_id
1468: AND ptp.payroll_id = paf.payroll_id
1469: AND ptp.regular_payment_date >= pay_ip_route_support.tax_year(p_business_group_id,nvl(l_action_date, p_session_date));
1470:
1471: hr_utility.trace('l_action_date: '||to_char(l_action_date));
1472: hr_utility.trace('l_pay_start_date: '||to_char(l_pay_start_date));
1473:
1474: /*The following code sets the balance dimension name based on
1475: the balance level and a valid tax unit id value.

Line 1472: hr_utility.trace('l_pay_start_date: '||to_char(l_pay_start_date));

1468: AND ptp.payroll_id = paf.payroll_id
1469: AND ptp.regular_payment_date >= pay_ip_route_support.tax_year(p_business_group_id,nvl(l_action_date, p_session_date));
1470:
1471: hr_utility.trace('l_action_date: '||to_char(l_action_date));
1472: hr_utility.trace('l_pay_start_date: '||to_char(l_pay_start_date));
1473:
1474: /*The following code sets the balance dimension name based on
1475: the balance level and a valid tax unit id value.
1476: */

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

1474: /*The following code sets the balance dimension name based on
1475: the balance level and a valid tax unit id value.
1476: */
1477: IF p_balance_level='ASG' THEN
1478: hr_utility.set_location(l_package||l_procedure, 20);
1479: IF p_asg_month = 0 THEN
1480: l_dim_mtd := NULL;
1481: ELSIF p_asg_month = 1 AND p_tax_unit_id <> -1 THEN
1482: l_dim_mtd := '_ASG_TU_MONTH';

Line 1503: hr_utility.trace('l_dim_mtd: '||to_char(l_dim_mtd));

1499: ELSE
1500: l_dim_ytd := '_ASG_TYTD';
1501: END IF;
1502:
1503: hr_utility.trace('l_dim_mtd: '||to_char(l_dim_mtd));
1504: hr_utility.trace('l_dim_qtd: '||to_char(l_dim_qtd));
1505: hr_utility.trace('l_dim_ytd: '||to_char(l_dim_ytd));
1506:
1507: -- balance level is PER

Line 1504: hr_utility.trace('l_dim_qtd: '||to_char(l_dim_qtd));

1500: l_dim_ytd := '_ASG_TYTD';
1501: END IF;
1502:
1503: hr_utility.trace('l_dim_mtd: '||to_char(l_dim_mtd));
1504: hr_utility.trace('l_dim_qtd: '||to_char(l_dim_qtd));
1505: hr_utility.trace('l_dim_ytd: '||to_char(l_dim_ytd));
1506:
1507: -- balance level is PER
1508: ELSE --ELSE clause of p_balance_level

Line 1505: hr_utility.trace('l_dim_ytd: '||to_char(l_dim_ytd));

1501: END IF;
1502:
1503: hr_utility.trace('l_dim_mtd: '||to_char(l_dim_mtd));
1504: hr_utility.trace('l_dim_qtd: '||to_char(l_dim_qtd));
1505: hr_utility.trace('l_dim_ytd: '||to_char(l_dim_ytd));
1506:
1507: -- balance level is PER
1508: ELSE --ELSE clause of p_balance_level
1509:

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

1506:
1507: -- balance level is PER
1508: ELSE --ELSE clause of p_balance_level
1509:
1510: hr_utility.set_location(l_package||l_procedure, 30);
1511: IF p_per_month = 0 THEN
1512: l_dim_mtd := NULL;
1513: ELSIF p_per_qtd = 1 AND p_tax_unit_id <> -1 THEN
1514: l_dim_mtd := '_PER_TU_MONTH';

Line 1535: hr_utility.trace('l_dim_mtd: '||to_char(l_dim_mtd));

1531: ELSE
1532: l_dim_ytd := '_PER_TYTD';
1533: END IF;
1534:
1535: hr_utility.trace('l_dim_mtd: '||to_char(l_dim_mtd));
1536: hr_utility.trace('l_dim_qtd: '||to_char(l_dim_qtd));
1537: hr_utility.trace('l_dim_ytd: '||to_char(l_dim_ytd));
1538:
1539: END IF; -- END IF clause of p_balance_level

Line 1536: hr_utility.trace('l_dim_qtd: '||to_char(l_dim_qtd));

1532: l_dim_ytd := '_PER_TYTD';
1533: END IF;
1534:
1535: hr_utility.trace('l_dim_mtd: '||to_char(l_dim_mtd));
1536: hr_utility.trace('l_dim_qtd: '||to_char(l_dim_qtd));
1537: hr_utility.trace('l_dim_ytd: '||to_char(l_dim_ytd));
1538:
1539: END IF; -- END IF clause of p_balance_level
1540:

Line 1537: hr_utility.trace('l_dim_ytd: '||to_char(l_dim_ytd));

1533: END IF;
1534:
1535: hr_utility.trace('l_dim_mtd: '||to_char(l_dim_mtd));
1536: hr_utility.trace('l_dim_qtd: '||to_char(l_dim_qtd));
1537: hr_utility.trace('l_dim_ytd: '||to_char(l_dim_ytd));
1538:
1539: END IF; -- END IF clause of p_balance_level
1540:
1541: hr_utility.set_location(l_package||l_procedure, 40);

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

1537: hr_utility.trace('l_dim_ytd: '||to_char(l_dim_ytd));
1538:
1539: END IF; -- END IF clause of p_balance_level
1540:
1541: hr_utility.set_location(l_package||l_procedure, 40);
1542:
1543: OPEN c_leg_code;
1544: FETCH c_leg_code INTO l_legislation_code;
1545: CLOSE c_leg_code;

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

1561: FETCH c_action_type_bg INTO l_type;
1562: CLOSE c_action_type_bg;
1563: END IF;
1564:
1565: hr_utility.set_location(l_package||l_procedure, 50);
1566: hr_utility.trace('l_legislation_code: '||to_char(l_legislation_code));
1567: hr_utility.trace('l_classification_id: '||to_char(l_classification_id));
1568: hr_utility.trace('l_type: '||to_char(l_type));
1569:

Line 1566: hr_utility.trace('l_legislation_code: '||to_char(l_legislation_code));

1562: CLOSE c_action_type_bg;
1563: END IF;
1564:
1565: hr_utility.set_location(l_package||l_procedure, 50);
1566: hr_utility.trace('l_legislation_code: '||to_char(l_legislation_code));
1567: hr_utility.trace('l_classification_id: '||to_char(l_classification_id));
1568: hr_utility.trace('l_type: '||to_char(l_type));
1569:
1570: -- If none of the check boxes are checked,nothing to fetch

Line 1567: hr_utility.trace('l_classification_id: '||to_char(l_classification_id));

1563: END IF;
1564:
1565: hr_utility.set_location(l_package||l_procedure, 50);
1566: hr_utility.trace('l_legislation_code: '||to_char(l_legislation_code));
1567: hr_utility.trace('l_classification_id: '||to_char(l_classification_id));
1568: hr_utility.trace('l_type: '||to_char(l_type));
1569:
1570: -- If none of the check boxes are checked,nothing to fetch
1571: IF ((p_per_month = 0) AND (p_per_qtd = 0) AND (p_per_ytd = 0) AND (p_asg_ptd = 0) AND (p_asg_month = 0)

Line 1568: hr_utility.trace('l_type: '||to_char(l_type));

1564:
1565: hr_utility.set_location(l_package||l_procedure, 50);
1566: hr_utility.trace('l_legislation_code: '||to_char(l_legislation_code));
1567: hr_utility.trace('l_classification_id: '||to_char(l_classification_id));
1568: hr_utility.trace('l_type: '||to_char(l_type));
1569:
1570: -- If none of the check boxes are checked,nothing to fetch
1571: IF ((p_per_month = 0) AND (p_per_qtd = 0) AND (p_per_ytd = 0) AND (p_asg_ptd = 0) AND (p_asg_month = 0)
1572: AND (p_asg_qtd = 0) AND (p_asg_ytd = 0) AND (p_asg_arr_itd = 0) AND (p_asg_acc_itd = 0)) THEN

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

1570: -- If none of the check boxes are checked,nothing to fetch
1571: IF ((p_per_month = 0) AND (p_per_qtd = 0) AND (p_per_ytd = 0) AND (p_asg_ptd = 0) AND (p_asg_month = 0)
1572: AND (p_asg_qtd = 0) AND (p_asg_ytd = 0) AND (p_asg_arr_itd = 0) AND (p_asg_acc_itd = 0)) THEN
1573:
1574: hr_utility.set_location(l_package||l_procedure, 60);
1575: hr_utility.trace('No Elements will be displayed as no options have been chosen');
1576: ELSE -- Atleast one of the options has been selected at the page level.
1577: hr_utility.set_location(l_package||l_procedure, 70);
1578: IF l_type ='Q' or l_type = 'R' THEN

Line 1575: hr_utility.trace('No Elements will be displayed as no options have been chosen');

1571: IF ((p_per_month = 0) AND (p_per_qtd = 0) AND (p_per_ytd = 0) AND (p_asg_ptd = 0) AND (p_asg_month = 0)
1572: AND (p_asg_qtd = 0) AND (p_asg_ytd = 0) AND (p_asg_arr_itd = 0) AND (p_asg_acc_itd = 0)) THEN
1573:
1574: hr_utility.set_location(l_package||l_procedure, 60);
1575: hr_utility.trace('No Elements will be displayed as no options have been chosen');
1576: ELSE -- Atleast one of the options has been selected at the page level.
1577: hr_utility.set_location(l_package||l_procedure, 70);
1578: IF l_type ='Q' or l_type = 'R' THEN
1579: IF p_assignment_action_id <> -1 THEN

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

1573:
1574: hr_utility.set_location(l_package||l_procedure, 60);
1575: hr_utility.trace('No Elements will be displayed as no options have been chosen');
1576: ELSE -- Atleast one of the options has been selected at the page level.
1577: hr_utility.set_location(l_package||l_procedure, 70);
1578: IF l_type ='Q' or l_type = 'R' THEN
1579: IF p_assignment_action_id <> -1 THEN
1580: i:=0;
1581: l_flag := 'N';

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

1578: IF l_type ='Q' or l_type = 'R' THEN
1579: IF p_assignment_action_id <> -1 THEN
1580: i:=0;
1581: l_flag := 'N';
1582: hr_utility.set_location(l_package||l_procedure, 80);
1583: IF UPPER(p_classification_name) IN ('PRE-TAX DEDUCTIONS',
1584: 'INVOLUNTARY DEDUCTIONS',
1585: 'VOLUNTARY DEDUCTIONS',
1586: 'TAX DEDUCTIONS') THEN

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

1583: IF UPPER(p_classification_name) IN ('PRE-TAX DEDUCTIONS',
1584: 'INVOLUNTARY DEDUCTIONS',
1585: 'VOLUNTARY DEDUCTIONS',
1586: 'TAX DEDUCTIONS') THEN
1587: hr_utility.set_location(l_package||l_procedure, 90);
1588: t_deduction_tab.delete;
1589: OPEN c_element_info_asact_dedn;
1590: LOOP
1591: FETCH c_element_info_asact_dedn INTO

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

1600: END IF;
1601: EXIT WHEN c_element_info_asact_dedn%NOTFOUND;
1602: i:=i+1;
1603: END LOOP;
1604: hr_utility.set_location(l_package||l_procedure, 100);
1605: CLOSE c_element_info_asact_dedn;
1606:
1607: -- The element classification is of the EARNIGNS type.
1608: ELSE -- ELSE clause of UPPER(p_classification_name) IN ('PRE-TAX DEDUCTIONS'

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

1605: CLOSE c_element_info_asact_dedn;
1606:
1607: -- The element classification is of the EARNIGNS type.
1608: ELSE -- ELSE clause of UPPER(p_classification_name) IN ('PRE-TAX DEDUCTIONS'
1609: hr_utility.set_location(l_package||l_procedure, 110);
1610: t_earnings_tab.delete;
1611: OPEN c_element_info_asact_earn ;
1612: LOOP
1613: FETCH c_element_info_asact_earn INTO

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

1620: END IF;
1621: EXIT WHEN c_element_info_asact_earn%NOTFOUND;
1622: i:=i+1;
1623: END LOOP;
1624: hr_utility.set_location(l_package||l_procedure, 120);
1625: CLOSE c_element_info_asact_earn;
1626: END IF; -- END IF clause of UPPER(p_classification_name) IN ('PRE-TAX DEDUCTIONS'
1627:
1628: hr_utility.set_location(l_package||l_procedure, 130);

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

1624: hr_utility.set_location(l_package||l_procedure, 120);
1625: CLOSE c_element_info_asact_earn;
1626: END IF; -- END IF clause of UPPER(p_classification_name) IN ('PRE-TAX DEDUCTIONS'
1627:
1628: hr_utility.set_location(l_package||l_procedure, 130);
1629:
1630: IF l_flag = 'Y' THEN -- Only if the element details were found proceed further to fetch and insert the balance values.
1631: hr_utility.set_location(l_package||l_procedure, 140);
1632:

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

1627:
1628: hr_utility.set_location(l_package||l_procedure, 130);
1629:
1630: IF l_flag = 'Y' THEN -- Only if the element details were found proceed further to fetch and insert the balance values.
1631: hr_utility.set_location(l_package||l_procedure, 140);
1632:
1633: -- call the function to fetch defined balances,balance values and populate the pl/sql tables
1634: l_return_value := FETCH_AND_STORE_BALANCES();
1635:

Line 1636: hr_utility.trace('l_return_value in Quick Pay/Payroll Run and Assignment Action Mode is: '||to_char(l_return_value));

1632:
1633: -- call the function to fetch defined balances,balance values and populate the pl/sql tables
1634: l_return_value := FETCH_AND_STORE_BALANCES();
1635:
1636: hr_utility.trace('l_return_value in Quick Pay/Payroll Run and Assignment Action Mode is: '||to_char(l_return_value));
1637:
1638: IF l_return_value = 1 THEN
1639: l_insert_flag := 'Y';
1640: hr_utility.trace('Insert Flag value in Quick Pay/Payroll Run and Assignment Action Mode is: '||to_char(l_insert_flag));

Line 1640: hr_utility.trace('Insert Flag value in Quick Pay/Payroll Run and Assignment Action Mode is: '||to_char(l_insert_flag));

1636: hr_utility.trace('l_return_value in Quick Pay/Payroll Run and Assignment Action Mode is: '||to_char(l_return_value));
1637:
1638: IF l_return_value = 1 THEN
1639: l_insert_flag := 'Y';
1640: hr_utility.trace('Insert Flag value in Quick Pay/Payroll Run and Assignment Action Mode is: '||to_char(l_insert_flag));
1641: ELSE
1642: l_insert_flag := 'N';
1643: hr_utility.trace('Insert Flag value in Quick Pay/Payroll Run and Assignment Action Mode is: '||to_char(l_insert_flag));
1644: END IF;

Line 1643: hr_utility.trace('Insert Flag value in Quick Pay/Payroll Run and Assignment Action Mode is: '||to_char(l_insert_flag));

1639: l_insert_flag := 'Y';
1640: hr_utility.trace('Insert Flag value in Quick Pay/Payroll Run and Assignment Action Mode is: '||to_char(l_insert_flag));
1641: ELSE
1642: l_insert_flag := 'N';
1643: hr_utility.trace('Insert Flag value in Quick Pay/Payroll Run and Assignment Action Mode is: '||to_char(l_insert_flag));
1644: END IF;
1645:
1646: -- call the function to populate the table pay_us_rpt_totals
1647: l_return_insert := POPULATE_TAB_RPT_TOTALS(l_insert_flag);

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

1646: -- call the function to populate the table pay_us_rpt_totals
1647: l_return_insert := POPULATE_TAB_RPT_TOTALS(l_insert_flag);
1648:
1649: ELSIF l_flag = 'N' THEN -- no elements are fetched
1650: hr_utility.set_location(l_package||l_procedure, 150);
1651: hr_utility.trace('No Elements were fetched for the given Classification Name - Quick Pay/Payroll Run and Assignment Action Mode');
1652: END IF; -- END IF clause for l_flag
1653:
1654: -- The page is opened in Date mode

Line 1651: hr_utility.trace('No Elements were fetched for the given Classification Name - Quick Pay/Payroll Run and Assignment Action Mode');

1647: l_return_insert := POPULATE_TAB_RPT_TOTALS(l_insert_flag);
1648:
1649: ELSIF l_flag = 'N' THEN -- no elements are fetched
1650: hr_utility.set_location(l_package||l_procedure, 150);
1651: hr_utility.trace('No Elements were fetched for the given Classification Name - Quick Pay/Payroll Run and Assignment Action Mode');
1652: END IF; -- END IF clause for l_flag
1653:
1654: -- The page is opened in Date mode
1655: ELSE -- ELSE clause for p_assignment_action_id <> -1

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

1652: END IF; -- END IF clause for l_flag
1653:
1654: -- The page is opened in Date mode
1655: ELSE -- ELSE clause for p_assignment_action_id <> -1
1656: hr_utility.set_location(l_package||l_procedure, 160);
1657: IF UPPER(p_classification_name) IN ('EARNINGS',
1658: 'SUPPLEMENTAL EARNINGS',
1659: 'DIRECT PAYMENT',
1660: 'TAXABLE BENEFITS',

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

1658: 'SUPPLEMENTAL EARNINGS',
1659: 'DIRECT PAYMENT',
1660: 'TAXABLE BENEFITS',
1661: 'EMPLOYER CHARGES') THEN
1662: hr_utility.set_location(l_package||l_procedure, 170);
1663: t_earnings_tab.delete;
1664: i:=0;
1665: l_flag := 'N';
1666: OPEN c_element_info_date_earn;

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

1675: END IF;
1676: EXIT WHEN c_element_info_date_earn %NOTFOUND;
1677: i:=i+1;
1678: END LOOP;
1679: hr_utility.set_location(l_package||l_procedure, 180);
1680: CLOSE c_element_info_date_earn;
1681:
1682: -- The element classification is the DEDUCTIONS type.
1683: ELSE -- ELSE Clause for UPPER(p_classification_name) IN ('EARNINGS'

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

1680: CLOSE c_element_info_date_earn;
1681:
1682: -- The element classification is the DEDUCTIONS type.
1683: ELSE -- ELSE Clause for UPPER(p_classification_name) IN ('EARNINGS'
1684: hr_utility.set_location(l_package||l_procedure, 190);
1685: t_deduction_tab.delete;
1686: i:=0;
1687: l_flag := 'N';
1688: OPEN c_element_info_date_dedn ;

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

1699: END IF;
1700: EXIT WHEN c_element_info_date_dedn %NOTFOUND;
1701: i:=i+1;
1702: END LOOP;
1703: hr_utility.set_location(l_package||l_procedure, 200);
1704: CLOSE c_element_info_date_dedn;
1705: END IF; -- END IF clause for UPPER(p_classification_name) IN ('EARNINGS'
1706: hr_utility.set_location(l_package||l_procedure, 210);
1707: IF l_flag = 'Y' THEN -- Only if the element details were found proceed further to fetch and insert the balance values.

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

1702: END LOOP;
1703: hr_utility.set_location(l_package||l_procedure, 200);
1704: CLOSE c_element_info_date_dedn;
1705: END IF; -- END IF clause for UPPER(p_classification_name) IN ('EARNINGS'
1706: hr_utility.set_location(l_package||l_procedure, 210);
1707: IF l_flag = 'Y' THEN -- Only if the element details were found proceed further to fetch and insert the balance values.
1708: hr_utility.set_location(l_package||l_procedure, 220);
1709:
1710: -- call the function to fetch defined balances,balance values and populate the pl/sql tables

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

1704: CLOSE c_element_info_date_dedn;
1705: END IF; -- END IF clause for UPPER(p_classification_name) IN ('EARNINGS'
1706: hr_utility.set_location(l_package||l_procedure, 210);
1707: IF l_flag = 'Y' THEN -- Only if the element details were found proceed further to fetch and insert the balance values.
1708: hr_utility.set_location(l_package||l_procedure, 220);
1709:
1710: -- call the function to fetch defined balances,balance values and populate the pl/sql tables
1711: l_return_value := FETCH_AND_STORE_BALANCES();
1712:

Line 1713: hr_utility.trace('l_return_value in Quick Pay/Payroll Run and Date Mode is: '||to_char(l_return_value));

1709:
1710: -- call the function to fetch defined balances,balance values and populate the pl/sql tables
1711: l_return_value := FETCH_AND_STORE_BALANCES();
1712:
1713: hr_utility.trace('l_return_value in Quick Pay/Payroll Run and Date Mode is: '||to_char(l_return_value));
1714:
1715: IF l_return_value = 1 THEN
1716: l_insert_flag := 'Y';
1717: hr_utility.trace('Insert Flag value in Quick Pay/Payroll Run and Date Mode is: '||to_char(l_insert_flag));

Line 1717: hr_utility.trace('Insert Flag value in Quick Pay/Payroll Run and Date Mode is: '||to_char(l_insert_flag));

1713: hr_utility.trace('l_return_value in Quick Pay/Payroll Run and Date Mode is: '||to_char(l_return_value));
1714:
1715: IF l_return_value = 1 THEN
1716: l_insert_flag := 'Y';
1717: hr_utility.trace('Insert Flag value in Quick Pay/Payroll Run and Date Mode is: '||to_char(l_insert_flag));
1718: ELSE
1719: l_insert_flag := 'N';
1720: hr_utility.trace('Insert Flag value in Quick Pay/Payroll Run and Date Mode is: '||to_char(l_insert_flag));
1721: END IF;

Line 1720: hr_utility.trace('Insert Flag value in Quick Pay/Payroll Run and Date Mode is: '||to_char(l_insert_flag));

1716: l_insert_flag := 'Y';
1717: hr_utility.trace('Insert Flag value in Quick Pay/Payroll Run and Date Mode is: '||to_char(l_insert_flag));
1718: ELSE
1719: l_insert_flag := 'N';
1720: hr_utility.trace('Insert Flag value in Quick Pay/Payroll Run and Date Mode is: '||to_char(l_insert_flag));
1721: END IF;
1722:
1723: -- call the function to populate the table pay_us_rpt_totals
1724: l_return_insert := POPULATE_TAB_RPT_TOTALS(l_insert_flag);

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

1723: -- call the function to populate the table pay_us_rpt_totals
1724: l_return_insert := POPULATE_TAB_RPT_TOTALS(l_insert_flag);
1725:
1726: ELSIF l_flag = 'N' THEN -- no elements are fetched
1727: hr_utility.set_location(l_package||l_procedure, 230);
1728: hr_utility.trace('No Elements were fetched for the given Classification Name - Quick Pay/Payroll Run and Date Mode');
1729: END IF; -- END IF clause for l_flag
1730: END IF; -- END IF clause for p_assignment_action_id <> -1
1731: ELSIF l_type='I' THEN -- Balance Initialization case

Line 1728: hr_utility.trace('No Elements were fetched for the given Classification Name - Quick Pay/Payroll Run and Date Mode');

1724: l_return_insert := POPULATE_TAB_RPT_TOTALS(l_insert_flag);
1725:
1726: ELSIF l_flag = 'N' THEN -- no elements are fetched
1727: hr_utility.set_location(l_package||l_procedure, 230);
1728: hr_utility.trace('No Elements were fetched for the given Classification Name - Quick Pay/Payroll Run and Date Mode');
1729: END IF; -- END IF clause for l_flag
1730: END IF; -- END IF clause for p_assignment_action_id <> -1
1731: ELSIF l_type='I' THEN -- Balance Initialization case
1732: hr_utility.set_location(l_package||l_procedure, 240);

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

1728: hr_utility.trace('No Elements were fetched for the given Classification Name - Quick Pay/Payroll Run and Date Mode');
1729: END IF; -- END IF clause for l_flag
1730: END IF; -- END IF clause for p_assignment_action_id <> -1
1731: ELSIF l_type='I' THEN -- Balance Initialization case
1732: hr_utility.set_location(l_package||l_procedure, 240);
1733:
1734: i:=0;
1735: l_flag := 'N';
1736: IF UPPER(p_classification_name) IN ('PRE-TAX DEDUCTIONS',

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

1736: IF UPPER(p_classification_name) IN ('PRE-TAX DEDUCTIONS',
1737: 'INVOLUNTARY DEDUCTIONS',
1738: 'VOLUNTARY DEDUCTIONS',
1739: 'TAX DEDUCTIONS') THEN
1740: hr_utility.set_location(l_package||l_procedure, 250);
1741: t_deduction_tab.delete;
1742: OPEN c_element_info_bi_dedn;
1743: LOOP
1744: FETCH c_element_info_bi_dedn INTO

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

1753: END IF;
1754: EXIT WHEN c_element_info_bi_dedn%NOTFOUND;
1755: i:=i+1;
1756: END LOOP;
1757: hr_utility.set_location(l_package||l_procedure, 260);
1758: CLOSE c_element_info_bi_dedn;
1759:
1760: -- The element classifications is of the EARNINGS type.
1761: ELSE -- ELSE clause for UPPER(p_classification_name) IN ('PRE-TAX DEDUCTIONS'

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

1758: CLOSE c_element_info_bi_dedn;
1759:
1760: -- The element classifications is of the EARNINGS type.
1761: ELSE -- ELSE clause for UPPER(p_classification_name) IN ('PRE-TAX DEDUCTIONS'
1762: hr_utility.set_location(l_package||l_procedure, 270);
1763: t_earnings_tab.delete;
1764: OPEN c_element_info_bi_earn ;
1765: LOOP
1766: FETCH c_element_info_bi_earn INTO

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

1773: END IF;
1774: EXIT WHEN c_element_info_bi_earn%NOTFOUND;
1775: i:=i+1;
1776: END LOOP;
1777: hr_utility.set_location(l_package||l_procedure, 280);
1778: CLOSE c_element_info_bi_earn;
1779: END IF; -- END IF clause for UPPER(p_classification_name) IN ('PRE-TAX DEDUCTIONS'
1780: hr_utility.set_location(l_package||l_procedure, 290);
1781:

Line 1780: hr_utility.set_location(l_package||l_procedure, 290);

1776: END LOOP;
1777: hr_utility.set_location(l_package||l_procedure, 280);
1778: CLOSE c_element_info_bi_earn;
1779: END IF; -- END IF clause for UPPER(p_classification_name) IN ('PRE-TAX DEDUCTIONS'
1780: hr_utility.set_location(l_package||l_procedure, 290);
1781:
1782: IF l_flag = 'Y' THEN -- Only if the element details were found proceed further to fetch and insert the balance values.
1783: hr_utility.set_location(l_package||l_procedure, 300);
1784:

Line 1783: hr_utility.set_location(l_package||l_procedure, 300);

1779: END IF; -- END IF clause for UPPER(p_classification_name) IN ('PRE-TAX DEDUCTIONS'
1780: hr_utility.set_location(l_package||l_procedure, 290);
1781:
1782: IF l_flag = 'Y' THEN -- Only if the element details were found proceed further to fetch and insert the balance values.
1783: hr_utility.set_location(l_package||l_procedure, 300);
1784:
1785: -- call the function to fetch defined balances,balance values and populate the pl/sql tables
1786: l_return_value := FETCH_AND_STORE_BALANCES();
1787:

Line 1788: hr_utility.trace('l_return_value in Balance Initialization and Date Mode is: '||to_char(l_return_value));

1784:
1785: -- call the function to fetch defined balances,balance values and populate the pl/sql tables
1786: l_return_value := FETCH_AND_STORE_BALANCES();
1787:
1788: hr_utility.trace('l_return_value in Balance Initialization and Date Mode is: '||to_char(l_return_value));
1789:
1790: IF l_return_value = 1 THEN
1791: l_insert_flag := 'Y';
1792: hr_utility.trace('Insert Flag value in Balance Initialization and Date Mode is: '||to_char(l_insert_flag));

Line 1792: hr_utility.trace('Insert Flag value in Balance Initialization and Date Mode is: '||to_char(l_insert_flag));

1788: hr_utility.trace('l_return_value in Balance Initialization and Date Mode is: '||to_char(l_return_value));
1789:
1790: IF l_return_value = 1 THEN
1791: l_insert_flag := 'Y';
1792: hr_utility.trace('Insert Flag value in Balance Initialization and Date Mode is: '||to_char(l_insert_flag));
1793: ELSE
1794: l_insert_flag := 'N';
1795: hr_utility.trace('Insert Flag value in Balance Initialization and Date Mode is: '||to_char(l_insert_flag));
1796: END IF;

Line 1795: hr_utility.trace('Insert Flag value in Balance Initialization and Date Mode is: '||to_char(l_insert_flag));

1791: l_insert_flag := 'Y';
1792: hr_utility.trace('Insert Flag value in Balance Initialization and Date Mode is: '||to_char(l_insert_flag));
1793: ELSE
1794: l_insert_flag := 'N';
1795: hr_utility.trace('Insert Flag value in Balance Initialization and Date Mode is: '||to_char(l_insert_flag));
1796: END IF;
1797:
1798: -- call the function to populate the table pay_us_rpt_totals
1799: l_return_insert := POPULATE_TAB_RPT_TOTALS(l_insert_flag);

Line 1802: hr_utility.set_location(l_package||l_procedure, 310);

1798: -- call the function to populate the table pay_us_rpt_totals
1799: l_return_insert := POPULATE_TAB_RPT_TOTALS(l_insert_flag);
1800:
1801: ELSIF l_flag = 'N' THEN -- no elements are fetched
1802: hr_utility.set_location(l_package||l_procedure, 310);
1803: hr_utility.trace('No Elements were fetched for the given Classification Name - Balance Initialization and Date Mode');
1804: END IF; -- END IF clause for l_flag
1805: END IF; -- END IF clause for l_type
1806: END IF; -- END IF clause for the IF statement that checks whether any of the dimension options on the SS Page were selcted or not.

Line 1803: hr_utility.trace('No Elements were fetched for the given Classification Name - Balance Initialization and Date Mode');

1799: l_return_insert := POPULATE_TAB_RPT_TOTALS(l_insert_flag);
1800:
1801: ELSIF l_flag = 'N' THEN -- no elements are fetched
1802: hr_utility.set_location(l_package||l_procedure, 310);
1803: hr_utility.trace('No Elements were fetched for the given Classification Name - Balance Initialization and Date Mode');
1804: END IF; -- END IF clause for l_flag
1805: END IF; -- END IF clause for l_type
1806: END IF; -- END IF clause for the IF statement that checks whether any of the dimension options on the SS Page were selcted or not.
1807:

Line 1813: hr_utility.set_location(l_package||l_procedure, 320);

1809:
1810: EXCEPTION
1811: WHEN others THEN
1812: ROLLBACK;
1813: hr_utility.set_location(l_package||l_procedure, 320);
1814: raise_application_error(-20101, 'Error in '||l_package||l_procedure || ' - ' || sqlerrm);
1815: END;
1816:
1817: END pay_ip_employee_balances;