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

Line 20: hr_utility.trace('Starting routine: '||l_routine_name);

16: l_date_mask VARCHAR2(5) := '';
17: l_routine_name VARCHAR2(64) := 'pay_ca_group_level_bal_pkg.get_date_mask';
18:
19: BEGIN
20: hr_utility.trace('Starting routine: '||l_routine_name);
21:
22: IF p_time_dimension = 'YTD' THEN
23: l_date_mask := 'Y';
24: hr_utility.trace(l_routine_name||': 20');

Line 24: hr_utility.trace(l_routine_name||': 20');

20: hr_utility.trace('Starting routine: '||l_routine_name);
21:
22: IF p_time_dimension = 'YTD' THEN
23: l_date_mask := 'Y';
24: hr_utility.trace(l_routine_name||': 20');
25: ELSIF p_time_dimension = 'QTD' THEN
26: l_date_mask := 'Q';
27: hr_utility.trace(l_routine_name||': 30');
28: ELSIF p_time_dimension = 'MONTH' THEN

Line 27: hr_utility.trace(l_routine_name||': 30');

23: l_date_mask := 'Y';
24: hr_utility.trace(l_routine_name||': 20');
25: ELSIF p_time_dimension = 'QTD' THEN
26: l_date_mask := 'Q';
27: hr_utility.trace(l_routine_name||': 30');
28: ELSIF p_time_dimension = 'MONTH' THEN
29: l_date_mask := 'MONTH';
30: hr_utility.trace(l_routine_name||': 40');
31: ELSE

Line 30: hr_utility.trace(l_routine_name||': 40');

26: l_date_mask := 'Q';
27: hr_utility.trace(l_routine_name||': 30');
28: ELSIF p_time_dimension = 'MONTH' THEN
29: l_date_mask := 'MONTH';
30: hr_utility.trace(l_routine_name||': 40');
31: ELSE
32: pay_us_balance_view_pkg.debug_err('Invalid time dimension');
33: END IF;
34:

Line 35: hr_utility.trace('Ending routine: '||l_routine_name);

31: ELSE
32: pay_us_balance_view_pkg.debug_err('Invalid time dimension');
33: END IF;
34:
35: hr_utility.trace('Ending routine: '||l_routine_name);
36: RETURN l_date_mask;
37:
38: END get_date_mask;
39:

Line 72: hr_utility.trace('Starting routine: '||l_routine_name);

68: l_asg_virtual_date DATE;
69: e_no_valid_date_exists EXCEPTION;
70:
71: BEGIN
72: hr_utility.trace('Starting routine: '||l_routine_name);
73:
74: OPEN csr_get_max_asg_end_date(p_assignment_id,
75: p_date_earned,
76: p_date_mask);

Line 79: hr_utility.trace(l_routine_name||': 20');

75: p_date_earned,
76: p_date_mask);
77: FETCH csr_get_max_asg_end_date INTO l_asg_virtual_date;
78: IF csr_get_max_asg_end_date%NOTFOUND THEN
79: hr_utility.trace(l_routine_name||': 20');
80: RAISE e_no_valid_date_exists;
81: END IF;
82:
83: hr_utility.trace

Line 83: hr_utility.trace

79: hr_utility.trace(l_routine_name||': 20');
80: RAISE e_no_valid_date_exists;
81: END IF;
82:
83: hr_utility.trace
84: ('Ending routine: '||l_routine_name);
85: RETURN l_asg_virtual_date;
86: EXCEPTION
87: WHEN e_no_valid_date_exists THEN

Line 88: hr_utility.trace(l_routine_name||': 40');

84: ('Ending routine: '||l_routine_name);
85: RETURN l_asg_virtual_date;
86: EXCEPTION
87: WHEN e_no_valid_date_exists THEN
88: hr_utility.trace(l_routine_name||': 40');
89: NULL;
90: END get_asg_virtual_date;
91:
92: -------------------------------------------------------------------------------

Line 141: hr_utility.trace('Starting routine: '||l_routine_name);

137: l_res_date DATE;
138: e_no_valid_date_exists EXCEPTION;
139:
140: BEGIN
141: hr_utility.trace('Starting routine: '||l_routine_name);
142:
143: OPEN csr_asg_in_payroll(p_assignment_id,
144: p_virtual_date);
145: FETCH csr_asg_in_payroll INTO l_asg_in_payroll;

Line 147: hr_utility.trace(l_routine_name||': 20');

143: OPEN csr_asg_in_payroll(p_assignment_id,
144: p_virtual_date);
145: FETCH csr_asg_in_payroll INTO l_asg_in_payroll;
146: IF csr_asg_in_payroll%NOTFOUND THEN
147: hr_utility.trace(l_routine_name||': 20');
148: l_virtual_date := get_asg_virtual_date (p_assignment_id,
149: p_virtual_date,
150: p_date_mask);
151: OPEN csr_get_virtual_date(p_assignment_id,

Line 156: hr_utility.trace(l_routine_name||': 30');

152: p_virtual_date,
153: p_date_mask);
154: FETCH csr_get_virtual_date INTO l_altered_date;
155: IF l_virtual_date IS NULL THEN
156: hr_utility.trace(l_routine_name||': 30');
157: IF l_altered_date IS NULL THEN
158: hr_utility.trace(l_routine_name||': 40');
159: RAISE e_no_valid_date_exists;
160: ELSE

Line 158: hr_utility.trace(l_routine_name||': 40');

154: FETCH csr_get_virtual_date INTO l_altered_date;
155: IF l_virtual_date IS NULL THEN
156: hr_utility.trace(l_routine_name||': 30');
157: IF l_altered_date IS NULL THEN
158: hr_utility.trace(l_routine_name||': 40');
159: RAISE e_no_valid_date_exists;
160: ELSE
161: hr_utility.trace(l_routine_name||': 50');
162: l_res_date := l_virtual_date;

Line 161: hr_utility.trace(l_routine_name||': 50');

157: IF l_altered_date IS NULL THEN
158: hr_utility.trace(l_routine_name||': 40');
159: RAISE e_no_valid_date_exists;
160: ELSE
161: hr_utility.trace(l_routine_name||': 50');
162: l_res_date := l_virtual_date;
163: END IF;
164: ELSE
165: IF l_altered_date IS NULL THEN

Line 166: hr_utility.trace(l_routine_name||': 60');

162: l_res_date := l_virtual_date;
163: END IF;
164: ELSE
165: IF l_altered_date IS NULL THEN
166: hr_utility.trace(l_routine_name||': 60');
167: l_res_date := l_virtual_date;
168: ELSE
169: hr_utility.trace(l_routine_name||': 70');
170: l_res_date := LEAST (l_virtual_date, l_altered_date);

Line 169: hr_utility.trace(l_routine_name||': 70');

165: IF l_altered_date IS NULL THEN
166: hr_utility.trace(l_routine_name||': 60');
167: l_res_date := l_virtual_date;
168: ELSE
169: hr_utility.trace(l_routine_name||': 70');
170: l_res_date := LEAST (l_virtual_date, l_altered_date);
171: END IF;
172: END IF;
173: ELSE

Line 174: hr_utility.trace(l_routine_name||': 80');

170: l_res_date := LEAST (l_virtual_date, l_altered_date);
171: END IF;
172: END IF;
173: ELSE
174: hr_utility.trace(l_routine_name||': 80');
175: l_res_date := p_virtual_date;
176: END IF;
177:
178: hr_utility.trace('Ending routine: '||l_routine_name);

Line 178: hr_utility.trace('Ending routine: '||l_routine_name);

174: hr_utility.trace(l_routine_name||': 80');
175: l_res_date := p_virtual_date;
176: END IF;
177:
178: hr_utility.trace('Ending routine: '||l_routine_name);
179: RETURN l_res_date;
180: EXCEPTION
181: WHEN e_no_valid_date_exists THEN
182: hr_utility.trace(l_routine_name||': 100');

Line 182: hr_utility.trace(l_routine_name||': 100');

178: hr_utility.trace('Ending routine: '||l_routine_name);
179: RETURN l_res_date;
180: EXCEPTION
181: WHEN e_no_valid_date_exists THEN
182: hr_utility.trace(l_routine_name||': 100');
183: END get_virtual_date;
184:
185: -------------------------------------------------------------------------------
186: -- Name: get_defined_balance

Line 227: hr_utility.trace('Starting routine: '||l_routine_name);

223: l_defined_balance_id NUMBER;
224: l_business_group_id NUMBER;
225:
226: BEGIN
227: hr_utility.trace('Starting routine: '||l_routine_name);
228:
229: hr_utility.trace('Balance type: '||p_balance_name);
230: hr_utility.trace('Balance Dimension: '||p_dimension);
231: OPEN csr_get_def_bal_id(p_balance_name,

Line 229: hr_utility.trace('Balance type: '||p_balance_name);

225:
226: BEGIN
227: hr_utility.trace('Starting routine: '||l_routine_name);
228:
229: hr_utility.trace('Balance type: '||p_balance_name);
230: hr_utility.trace('Balance Dimension: '||p_dimension);
231: OPEN csr_get_def_bal_id(p_balance_name,
232: p_dimension,
233: p_business_group_id);

Line 230: hr_utility.trace('Balance Dimension: '||p_dimension);

226: BEGIN
227: hr_utility.trace('Starting routine: '||l_routine_name);
228:
229: hr_utility.trace('Balance type: '||p_balance_name);
230: hr_utility.trace('Balance Dimension: '||p_dimension);
231: OPEN csr_get_def_bal_id(p_balance_name,
232: p_dimension,
233: p_business_group_id);
234: FETCH csr_get_def_bal_id INTO l_defined_balance_id;

Line 242: hr_utility.trace('Ending routine: '||l_routine_name);

238: l_defined_balance_id := NULL;
239: END IF;
240: CLOSE csr_get_def_bal_id;
241:
242: hr_utility.trace('Ending routine: '||l_routine_name);
243: RETURN l_defined_balance_id;
244:
245: END get_defined_balance;
246:

Line 460: hr_utility.trace('Starting routine: '||l_routine_name);

456: l_balance_value NUMBER(38,10) := 0;
457: l_run_dimension VARCHAR2(30);
458:
459: BEGIN
460: hr_utility.trace('Starting routine: '||l_routine_name);
461:
462: l_run_dimension := REPLACE(p_lb_dimension, 'PYDATE', 'RUN');
463:
464: l_lb_defined_balance_id := get_defined_balance(p_balance_name,

Line 476: hr_utility.trace(l_routine_name||': 30');

472: /*
473: * Loop through all the assignment actions for this Reporting Unit
474: * (Source Id) and sum the latest balance value for each one
475: */
476: hr_utility.trace(l_routine_name||': 30');
477: IF p_jurisdiction IS NULL THEN
478: FOR r_asg IN csr_get_asg_src_add(p_organization_id,
479: p_location_id,
480: p_payroll_id,

Line 485: hr_utility.trace(l_routine_name||': 60');

481: p_pay_basis_type,
482: p_source_id,
483: p_start_date,
484: p_effective_date) LOOP
485: hr_utility.trace(l_routine_name||': 60');
486: l_balance_value := l_balance_value +
487: pay_ca_balance_view_pkg.get_value
488: (p_assignment_action_id => r_asg.assignment_action_id,
489: p_defined_balance_id => l_lb_defined_balance_id,

Line 502: hr_utility.trace(l_routine_name||': 70');

498: p_source_id,
499: p_jurisdiction,
500: p_start_date,
501: p_effective_date) LOOP
502: hr_utility.trace(l_routine_name||': 70');
503: l_balance_value := l_balance_value +
504: pay_ca_balance_view_pkg.get_value
505: (p_assignment_action_id => r_asg.assignment_action_id,
506: p_defined_balance_id => l_lb_defined_balance_id,

Line 516: hr_utility.trace(l_routine_name||': 80');

512: /*
513: * Loop through all the assignments for this GRE and sum the latest
514: * balance value for each one
515: */
516: hr_utility.trace(l_routine_name||': 80');
517: IF p_jurisdiction IS NULL THEN
518: FOR r_asg IN csr_get_asg_gre_add(p_organization_id,
519: p_location_id,
520: p_payroll_id,

Line 525: hr_utility.trace(l_routine_name||': 110');

521: p_pay_basis_type,
522: p_gre_id,
523: p_start_date,
524: p_effective_date) LOOP
525: hr_utility.trace(l_routine_name||': 110');
526: l_balance_value := l_balance_value +
527: pay_ca_balance_view_pkg.get_value
528: (p_assignment_action_id => r_asg.assignment_action_id,
529: p_defined_balance_id => l_lb_defined_balance_id,

Line 542: hr_utility.trace(l_routine_name||': 120');

538: p_gre_id,
539: p_jurisdiction,
540: p_start_date,
541: p_effective_date) LOOP
542: hr_utility.trace(l_routine_name||': 120');
543: l_balance_value := l_balance_value +
544: pay_ca_balance_view_pkg.get_value
545: (p_assignment_action_id => r_asg.assignment_action_id,
546: p_defined_balance_id => l_lb_defined_balance_id,

Line 553: hr_utility.trace('Ending routine: '||l_routine_name);

549: END LOOP;
550: END IF;
551: END IF;
552:
553: hr_utility.trace('Ending routine: '||l_routine_name);
554: RETURN l_balance_value;
555: END get_grp_pydate_with_aa;
556:
557:

Line 776: hr_utility.trace('Starting routine: '||l_routine_name);

772: l_run_dimension VARCHAR2(30);
773: l_ge_def_bal_id NUMBER(20);
774:
775: BEGIN
776: hr_utility.trace('Starting routine: '||l_routine_name);
777:
778: l_run_dimension := REPLACE(p_lb_dimension, 'PYDATE', 'RUN');
779:
780: l_lb_defined_balance_id := get_defined_balance(p_balance_name,

Line 791: hr_utility.trace('Def_bal_id of '||p_balance_name||'_ASG_GRE_RUN : '||to_char(l_ge_def_bal_id));

787: If p_jurisdiction is NULL then
788: l_ge_def_bal_id := get_defined_balance(p_balance_name,
789: 'ASG_GRE_RUN',
790: p_business_group_id);
791: hr_utility.trace('Def_bal_id of '||p_balance_name||'_ASG_GRE_RUN : '||to_char(l_ge_def_bal_id));
792:
793: Else
794:
795: l_ge_def_bal_id := get_defined_balance(p_balance_name,

Line 798: hr_utility.trace('Def_bal_id of '||p_balance_name||'_ASG_JD_GRE_RUN : '||to_char(l_ge_def_bal_id));

794:
795: l_ge_def_bal_id := get_defined_balance(p_balance_name,
796: 'ASG_JD_GRE_RUN',
797: p_business_group_id);
798: hr_utility.trace('Def_bal_id of '||p_balance_name||'_ASG_JD_GRE_RUN : '||to_char(l_ge_def_bal_id));
799: End if;
800:
801: hr_utility.trace('Def_bal_id of GROSS_EARNINGS_ASG_JD_GRE_RUN : '||to_char(l_ge_def_bal_id));
802:

Line 801: hr_utility.trace('Def_bal_id of GROSS_EARNINGS_ASG_JD_GRE_RUN : '||to_char(l_ge_def_bal_id));

797: p_business_group_id);
798: hr_utility.trace('Def_bal_id of '||p_balance_name||'_ASG_JD_GRE_RUN : '||to_char(l_ge_def_bal_id));
799: End if;
800:
801: hr_utility.trace('Def_bal_id of GROSS_EARNINGS_ASG_JD_GRE_RUN : '||to_char(l_ge_def_bal_id));
802:
803: IF l_lb_defined_balance_id IS NULL THEN
804: RETURN NULL;
805: END IF;

Line 812: hr_utility.trace(l_routine_name||': 30');

808: /*
809: * Loop through all the assignment actions for this Reporting Unit
810: * (Source Id) and sum the latest balance value for each one
811: */
812: hr_utility.trace(l_routine_name||': 30');
813: IF p_jurisdiction IS NULL THEN
814:
815: FOR r_asg IN csr_get_asg_src_add_rb(p_organization_id,
816: p_location_id,

Line 823: hr_utility.trace(l_routine_name||': 60');

819: p_source_id,
820: p_start_date,
821: p_effective_date,
822: l_ge_def_bal_id) LOOP
823: hr_utility.trace(l_routine_name||': 60');
824: l_balance_value := l_balance_value +
825: pay_ca_balance_view_pkg.get_value
826: (p_assignment_action_id => r_asg.assignment_action_id,
827: p_defined_balance_id => l_lb_defined_balance_id,

Line 840: hr_utility.trace(l_routine_name||': 70');

836: p_source_id,
837: p_jurisdiction,
838: p_start_date,
839: p_effective_date) LOOP
840: hr_utility.trace(l_routine_name||': 70');
841: l_balance_value := l_balance_value +
842: pay_ca_balance_view_pkg.get_value
843: (p_assignment_action_id => r_asg.assignment_action_id,
844: p_defined_balance_id => l_lb_defined_balance_id,

Line 854: hr_utility.trace(l_routine_name||': 80');

850: /*
851: * Loop through all the assignments for this GRE and sum the latest
852: * balance value for each one
853: */
854: hr_utility.trace(l_routine_name||': 80');
855: IF p_jurisdiction IS NULL THEN
856: FOR r_asg IN csr_get_asg_gre_add_rb(p_organization_id,
857: p_location_id,
858: p_payroll_id,

Line 864: hr_utility.trace(l_routine_name||': 110');

860: p_gre_id,
861: p_start_date,
862: p_effective_date,
863: l_ge_def_bal_id) LOOP
864: hr_utility.trace(l_routine_name||': 110');
865: l_balance_value := l_balance_value +
866: pay_ca_balance_view_pkg.get_value
867: (p_assignment_action_id => r_asg.assignment_action_id,
868: p_defined_balance_id => l_lb_defined_balance_id,

Line 882: hr_utility.trace(l_routine_name||': 120');

878: p_jurisdiction,
879: p_start_date,
880: p_effective_date,
881: l_ge_def_bal_id) LOOP
882: hr_utility.trace(l_routine_name||': 120');
883: l_balance_value := l_balance_value +
884: pay_ca_balance_view_pkg.get_value
885: (p_assignment_action_id => r_asg.assignment_action_id,
886: p_defined_balance_id => l_lb_defined_balance_id,

Line 893: hr_utility.trace('Ending routine: '||l_routine_name);

889: END LOOP;
890: END IF;
891: END IF;
892:
893: hr_utility.trace('Ending routine: '||l_routine_name);
894: RETURN l_balance_value;
895: END get_grp_pydate_with_aa_rb;
896:
897:

Line 1223: hr_utility.trace('Starting routine: '||l_routine_name);

1219: l_date_mask VARCHAR2(5);
1220: l_additional_params VARCHAR2(1);
1221:
1222: BEGIN
1223: hr_utility.trace('Starting routine: '||l_routine_name);
1224:
1225: l_lb_defined_balance_id := get_defined_balance(p_balance_name,
1226: p_lb_dimension,
1227: p_business_group_id);

Line 1240: hr_utility.trace(l_routine_name||': 5');

1236: IF p_organization_id IS NULL AND
1237: p_location_id IS NULL AND
1238: p_payroll_id IS NULL AND
1239: p_pay_basis_type IS NULL THEN
1240: hr_utility.trace(l_routine_name||': 5');
1241: l_additional_params := 'N';
1242: ELSE
1243: hr_utility.trace(l_routine_name||': 10');
1244: l_additional_params := 'Y';

Line 1243: hr_utility.trace(l_routine_name||': 10');

1239: p_pay_basis_type IS NULL THEN
1240: hr_utility.trace(l_routine_name||': 5');
1241: l_additional_params := 'N';
1242: ELSE
1243: hr_utility.trace(l_routine_name||': 10');
1244: l_additional_params := 'Y';
1245: END IF;
1246:
1247: /*

Line 1258: hr_utility.trace(l_routine_name||': 20');

1254: p_effective_date);
1255: FETCH csr_latest_bal_exists INTO l_latest_bal_exists;
1256: IF csr_latest_bal_exists%NOTFOUND AND
1257: l_additional_params = 'N' THEN
1258: hr_utility.trace(l_routine_name||': 20');
1259: /*
1260: * No latest balances found so calculate the group level balance from
1261: * first principles
1262: */

Line 1273: hr_utility.trace(l_routine_name||': 30');

1269: /*
1270: * Loop through all the assignments for this Reporting Unit (Source Id)
1271: * and sum the latest balance value for each one
1272: */
1273: hr_utility.trace(l_routine_name||': 30');
1274: l_date_mask := get_date_mask(p_time_dimension);
1275: IF l_additional_params = 'N' THEN
1276: IF p_jurisdiction IS NULL THEN
1277: FOR r_asg IN csr_get_asg_src(p_source_id,

Line 1280: hr_utility.trace(l_routine_name||': 40');

1276: IF p_jurisdiction IS NULL THEN
1277: FOR r_asg IN csr_get_asg_src(p_source_id,
1278: p_start_date,
1279: p_effective_date) LOOP
1280: hr_utility.trace(l_routine_name||': 40');
1281:
1282: IF p_time_dimension <> 'PYDATE' THEN
1283: l_virtual_date := get_virtual_date (r_asg.assignment_id,
1284: p_effective_date,

Line 1298: hr_utility.trace(l_routine_name||': 50');

1294: FOR r_asg IN csr_get_asg_jd_src(p_source_id,
1295: p_jurisdiction,
1296: p_start_date,
1297: p_effective_date) LOOP
1298: hr_utility.trace(l_routine_name||': 50');
1299: l_virtual_date := get_virtual_date (r_asg.assignment_id,
1300: p_effective_date,
1301: l_date_mask);
1302: l_balance_value := l_balance_value +

Line 1318: hr_utility.trace(l_routine_name||': 60');

1314: p_pay_basis_type,
1315: p_source_id,
1316: p_start_date,
1317: p_effective_date) LOOP
1318: hr_utility.trace(l_routine_name||': 60');
1319: l_virtual_date := get_virtual_date (r_asg.assignment_id,
1320: p_effective_date,
1321: l_date_mask);
1322: l_balance_value := l_balance_value +

Line 1337: hr_utility.trace(l_routine_name||': 70');

1333: p_source_id,
1334: p_jurisdiction,
1335: p_start_date,
1336: p_effective_date) LOOP
1337: hr_utility.trace(l_routine_name||': 70');
1338: l_virtual_date := get_virtual_date (r_asg.assignment_id,
1339: p_effective_date,
1340: l_date_mask);
1341: l_balance_value := l_balance_value +

Line 1354: hr_utility.trace(l_routine_name||': 80');

1350: /*
1351: * Loop through all the assignments for this GRE and sum the latest
1352: * balance value for each one
1353: */
1354: hr_utility.trace(l_routine_name||': 80');
1355: IF p_time_dimension <> 'PYDATE' THEN
1356: l_date_mask := get_date_mask(p_time_dimension);
1357: END IF;
1358: IF l_additional_params = 'N' THEN

Line 1363: hr_utility.trace(l_routine_name||': 90');

1359: IF p_jurisdiction IS NULL THEN
1360: FOR r_asg IN csr_get_asg_gre(p_gre_id,
1361: p_start_date,
1362: p_effective_date) LOOP
1363: hr_utility.trace(l_routine_name||': 90');
1364: l_virtual_date := get_virtual_date (r_asg.assignment_id,
1365: p_effective_date,
1366: l_date_mask);
1367: l_balance_value := l_balance_value +

Line 1379: hr_utility.trace(l_routine_name||': 100');

1375: FOR r_asg IN csr_get_asg_jd_gre(p_gre_id,
1376: p_jurisdiction,
1377: p_start_date,
1378: p_effective_date) LOOP
1379: hr_utility.trace(l_routine_name||': 100');
1380: l_virtual_date := get_virtual_date (r_asg.assignment_id,
1381: p_effective_date,
1382: l_date_mask);
1383: l_balance_value := l_balance_value +

Line 1400: hr_utility.trace(l_routine_name||': 110');

1396: p_pay_basis_type,
1397: p_gre_id,
1398: p_start_date,
1399: p_effective_date) LOOP
1400: hr_utility.trace(l_routine_name||': 110');
1401: l_virtual_date := get_virtual_date (r_asg.assignment_id,
1402: p_effective_date,
1403: l_date_mask);
1404: l_balance_value := l_balance_value +

Line 1420: hr_utility.trace(l_routine_name||': 120');

1416: p_gre_id,
1417: p_jurisdiction,
1418: p_start_date,
1419: p_effective_date) LOOP
1420: hr_utility.trace(l_routine_name||': 120');
1421: l_virtual_date := get_virtual_date (r_asg.assignment_id,
1422: p_effective_date,
1423: l_date_mask);
1424: l_balance_value := l_balance_value +

Line 1435: hr_utility.trace('Ending routine: '||l_routine_name);

1431: END IF;
1432: END IF;
1433: END IF;
1434:
1435: hr_utility.trace('Ending routine: '||l_routine_name);
1436: RETURN l_balance_value;
1437: END get_grp_non_pydate_with_asg;
1438:
1439:

Line 1765: hr_utility.trace('Starting routine: '||l_routine_name);

1761: l_additional_params VARCHAR2(1);
1762: l_ge_def_bal_id NUMBER(20);
1763:
1764: BEGIN
1765: hr_utility.trace('Starting routine: '||l_routine_name);
1766:
1767:
1768: /* To check in run_balances table with def_val_id and get valid assignment
1769: or assignment_action for balance calls */

Line 1775: hr_utility.trace('Def_bal_id of '||p_balance_name||'_ASG_GRE_RUN : '||to_char(l_ge_def_bal_id));

1771: If p_jurisdiction is NULL then
1772: l_ge_def_bal_id := get_defined_balance(p_balance_name,
1773: 'ASG_GRE_RUN',
1774: p_business_group_id);
1775: hr_utility.trace('Def_bal_id of '||p_balance_name||'_ASG_GRE_RUN : '||to_char(l_ge_def_bal_id));
1776: else
1777: l_ge_def_bal_id := get_defined_balance(p_balance_name,
1778: 'ASG_JD_GRE_RUN',
1779: p_business_group_id);

Line 1780: hr_utility.trace('Def_bal_id of '||p_balance_name||'_ASG_JD_GRE_RUN : '||to_char(l_ge_def_bal_id));

1776: else
1777: l_ge_def_bal_id := get_defined_balance(p_balance_name,
1778: 'ASG_JD_GRE_RUN',
1779: p_business_group_id);
1780: hr_utility.trace('Def_bal_id of '||p_balance_name||'_ASG_JD_GRE_RUN : '||to_char(l_ge_def_bal_id));
1781: End if;
1782:
1783:
1784: hr_utility.trace('Def_bal_id of GROSS_EARNINGS_ASG_JD_GRE_RUN : '||to_char(l_ge_def_bal_id));

Line 1784: hr_utility.trace('Def_bal_id of GROSS_EARNINGS_ASG_JD_GRE_RUN : '||to_char(l_ge_def_bal_id));

1780: hr_utility.trace('Def_bal_id of '||p_balance_name||'_ASG_JD_GRE_RUN : '||to_char(l_ge_def_bal_id));
1781: End if;
1782:
1783:
1784: hr_utility.trace('Def_bal_id of GROSS_EARNINGS_ASG_JD_GRE_RUN : '||to_char(l_ge_def_bal_id));
1785:
1786: l_lb_defined_balance_id := get_defined_balance(p_balance_name,
1787: p_lb_dimension,
1788: p_business_group_id);

Line 1801: hr_utility.trace(l_routine_name||': 5');

1797: IF p_organization_id IS NULL AND
1798: p_location_id IS NULL AND
1799: p_payroll_id IS NULL AND
1800: p_pay_basis_type IS NULL THEN
1801: hr_utility.trace(l_routine_name||': 5');
1802: l_additional_params := 'N';
1803: ELSE
1804: hr_utility.trace(l_routine_name||': 10');
1805: l_additional_params := 'Y';

Line 1804: hr_utility.trace(l_routine_name||': 10');

1800: p_pay_basis_type IS NULL THEN
1801: hr_utility.trace(l_routine_name||': 5');
1802: l_additional_params := 'N';
1803: ELSE
1804: hr_utility.trace(l_routine_name||': 10');
1805: l_additional_params := 'Y';
1806: END IF;
1807:
1808: /*

Line 1819: hr_utility.trace(l_routine_name||': 20');

1815: p_effective_date);
1816: FETCH csr_latest_bal_exists INTO l_latest_bal_exists;
1817: IF csr_latest_bal_exists%NOTFOUND AND
1818: l_additional_params = 'N' THEN
1819: hr_utility.trace(l_routine_name||': 20');
1820: /*
1821: * No latest balances found so calculate the group level balance from
1822: * first principles
1823: */

Line 1834: hr_utility.trace(l_routine_name||': 30');

1830: /*
1831: * Loop through all the assignments for this Reporting Unit (Source Id)
1832: * and sum the latest balance value for each one
1833: */
1834: hr_utility.trace(l_routine_name||': 30');
1835: l_date_mask := get_date_mask(p_time_dimension);
1836: IF l_additional_params = 'N' THEN
1837: IF p_jurisdiction IS NULL THEN
1838: FOR r_asg IN csr_get_asg_src_rb(p_source_id,

Line 1841: hr_utility.trace(l_routine_name||': 40');

1837: IF p_jurisdiction IS NULL THEN
1838: FOR r_asg IN csr_get_asg_src_rb(p_source_id,
1839: p_start_date,
1840: p_effective_date) LOOP
1841: hr_utility.trace(l_routine_name||': 40');
1842:
1843: IF p_time_dimension <> 'PYDATE' THEN
1844: l_virtual_date := get_virtual_date (r_asg.assignment_id,
1845: p_effective_date,

Line 1859: hr_utility.trace(l_routine_name||': 50');

1855: FOR r_asg IN csr_get_asg_jd_src(p_source_id,
1856: p_jurisdiction,
1857: p_start_date,
1858: p_effective_date) LOOP
1859: hr_utility.trace(l_routine_name||': 50');
1860: l_virtual_date := get_virtual_date (r_asg.assignment_id,
1861: p_effective_date,
1862: l_date_mask);
1863: l_balance_value := l_balance_value +

Line 1881: hr_utility.trace(l_routine_name||': 60');

1877: p_start_date,
1878: p_effective_date,
1879: l_ge_def_bal_id)
1880: LOOP
1881: hr_utility.trace(l_routine_name||': 60');
1882: l_virtual_date := get_virtual_date (r_asg.assignment_id,
1883: p_effective_date,
1884: l_date_mask);
1885: l_balance_value := l_balance_value +

Line 1900: hr_utility.trace(l_routine_name||': 70');

1896: p_source_id,
1897: p_jurisdiction,
1898: p_start_date,
1899: p_effective_date) LOOP
1900: hr_utility.trace(l_routine_name||': 70');
1901: l_virtual_date := get_virtual_date (r_asg.assignment_id,
1902: p_effective_date,
1903: l_date_mask);
1904: l_balance_value := l_balance_value +

Line 1917: hr_utility.trace(l_routine_name||': 80');

1913: /*
1914: * Loop through all the assignments for this GRE and sum the latest
1915: * balance value for each one
1916: */
1917: hr_utility.trace(l_routine_name||': 80');
1918: IF p_time_dimension <> 'PYDATE' THEN
1919: l_date_mask := get_date_mask(p_time_dimension);
1920: END IF;
1921: IF l_additional_params = 'N' THEN

Line 1927: hr_utility.trace(l_routine_name||': 90');

1923: FOR r_asg IN csr_get_asg_gre_rb(p_gre_id,
1924: p_start_date,
1925: p_effective_date,
1926: l_ge_def_bal_id) LOOP
1927: hr_utility.trace(l_routine_name||': 90');
1928: l_virtual_date := get_virtual_date (r_asg.assignment_id,
1929: p_effective_date,
1930: l_date_mask);
1931: l_balance_value := l_balance_value +

Line 1944: hr_utility.trace(l_routine_name||': 100');

1940: p_jurisdiction,
1941: p_start_date,
1942: p_effective_date,
1943: l_ge_def_bal_id) LOOP
1944: hr_utility.trace(l_routine_name||': 100');
1945: l_virtual_date := get_virtual_date (r_asg.assignment_id,
1946: p_effective_date,
1947: l_date_mask);
1948: l_balance_value := l_balance_value +

Line 1966: hr_utility.trace(l_routine_name||': 110');

1962: p_gre_id,
1963: p_start_date,
1964: p_effective_date,
1965: l_ge_def_bal_id) LOOP
1966: hr_utility.trace(l_routine_name||': 110');
1967: l_virtual_date := get_virtual_date (r_asg.assignment_id,
1968: p_effective_date,
1969: l_date_mask);
1970: l_balance_value := l_balance_value +

Line 1987: hr_utility.trace(l_routine_name||': 120');

1983: p_jurisdiction,
1984: p_start_date,
1985: p_effective_date,
1986: l_ge_def_bal_id) LOOP
1987: hr_utility.trace(l_routine_name||': 120');
1988: l_virtual_date := get_virtual_date (r_asg.assignment_id,
1989: p_effective_date,
1990: l_date_mask);
1991: l_balance_value := l_balance_value +

Line 2002: hr_utility.trace('Ending routine: '||l_routine_name);

1998: END IF;
1999: END IF;
2000: END IF;
2001:
2002: hr_utility.trace('Ending routine: '||l_routine_name);
2003: RETURN l_balance_value;
2004: END get_grp_non_pydate_with_asg_rb;
2005:
2006:

Line 2221: /* hr_utility.trace_on(NULL,'ORASDR'); */

2217:
2218:
2219: BEGIN
2220:
2221: /* hr_utility.trace_on(NULL,'ORASDR'); */
2222: hr_utility.trace('Starting routine: '||l_routine_name);
2223: pay_ca_balance_view_pkg.set_context('DATE_EARNED',
2224: fnd_date.date_to_canonical(p_effective_date));
2225:

Line 2222: hr_utility.trace('Starting routine: '||l_routine_name);

2218:
2219: BEGIN
2220:
2221: /* hr_utility.trace_on(NULL,'ORASDR'); */
2222: hr_utility.trace('Starting routine: '||l_routine_name);
2223: pay_ca_balance_view_pkg.set_context('DATE_EARNED',
2224: fnd_date.date_to_canonical(p_effective_date));
2225:
2226: l_balance_name := p_balance_name;

Line 2238: hr_utility.trace(l_routine_name||': 10');

2234: END IF;
2235:
2236: IF p_time_dimension <> 'PYDATE' AND
2237: p_start_date IS NULL THEN
2238: hr_utility.trace(l_routine_name||': 10');
2239: IF p_time_dimension = 'MONTH' THEN
2240: l_start_date := TRUNC(p_effective_date,'MONTH');
2241: ELSIF p_time_dimension = 'YTD' THEN
2242: l_start_date := TRUNC(p_effective_date,'Y');

Line 2247: hr_utility.trace(l_routine_name||': 20');

2243: ELSIF p_time_dimension = 'QTD' THEN
2244: l_start_date := TRUNC(p_effective_date,'Q');
2245: END IF;
2246: ELSIF p_time_dimension = 'PYDATE' THEN
2247: hr_utility.trace(l_routine_name||': 20');
2248: IF p_start_date IS NULL THEN
2249: l_date_context := pay_ca_balance_view_pkg.get_context('BALANCE_DATE');
2250: IF l_date_context IS NOT NULL THEN
2251: l_start_date := fnd_date.canonical_to_date(l_date_context);

Line 2261: hr_utility.trace(l_routine_name||': 25');

2257: pay_ca_balance_view_pkg.set_context('BALANCE_DATE',
2258: fnd_date.date_to_canonical(p_start_date));
2259: END IF;
2260: ELSIF p_time_dimension = 'PTD' THEN
2261: hr_utility.trace(l_routine_name||': 25');
2262: l_start_date := NULL;
2263: ELSE
2264: RAISE e_invalid_dim_date_comb;
2265: END IF;

Line 2268: hr_utility.trace(l_routine_name||': 30');

2264: RAISE e_invalid_dim_date_comb;
2265: END IF;
2266:
2267: IF p_gre_id IS NOT NULL THEN
2268: hr_utility.trace(l_routine_name||': 30');
2269:
2270: pay_ca_balance_view_pkg.set_context('TAX_UNIT_ID',
2271: p_gre_id);
2272:

Line 2321: hr_utility.trace('ln_bg_id: '||to_char(ln_bg_id));

2317:
2318: open c_get_bg_id1(p_gre_id);
2319:
2320: fetch c_get_bg_id1 into ln_bg_id;
2321: hr_utility.trace('ln_bg_id: '||to_char(ln_bg_id));
2322: close c_get_bg_id1;
2323:
2324: ln_run_balance_status := pay_us_payroll_utils.check_balance_status
2325: (l_start_date,

Line 2337: hr_utility.trace('opening rb1 cursor');

2333: 'ASG_GRE_RUN',
2334: ln_bg_id);
2335:
2336:
2337: hr_utility.trace('opening rb1 cursor');
2338: OPEN csr_asg_for_gre_only_rb1(l_start_date,
2339: p_effective_date,
2340: p_gre_id,
2341: ln_defbal_id);

Line 2348: hr_utility.trace('opening gre_only cursor');

2344: l_business_group_id;
2345:
2346: CLOSE csr_asg_for_gre_only_rb1;
2347: else
2348: hr_utility.trace('opening gre_only cursor');
2349: OPEN csr_asg_exists_for_gre_only(l_start_date,
2350: p_effective_date,
2351: p_gre_id);
2352:

Line 2375: hr_utility.trace(l_routine_name||': 40');

2371:
2372: END IF;
2373:
2374: ELSIF p_source_id IS NOT NULL THEN
2375: hr_utility.trace(l_routine_name||': 40');
2376:
2377: pay_ca_balance_view_pkg.set_context('SOURCE_ID',
2378: p_source_id);
2379:

Line 2410: hr_utility.trace(l_routine_name||': 50');

2406: * e.g. with JD Group - _GRE_JD_MONTH
2407: * Assignment - _ASG_JD_GRE_MONTH
2408: */
2409: IF p_jurisdiction IS NULL THEN
2410: hr_utility.trace(l_routine_name||': 50');
2411: l_gl_dimension := l_dim_str1 || p_time_dimension;
2412: l_lb_dimension := 'ASG_' || l_gl_dimension;
2413: ELSE
2414: hr_utility.trace(l_routine_name||': 60');

Line 2414: hr_utility.trace(l_routine_name||': 60');

2410: hr_utility.trace(l_routine_name||': 50');
2411: l_gl_dimension := l_dim_str1 || p_time_dimension;
2412: l_lb_dimension := 'ASG_' || l_gl_dimension;
2413: ELSE
2414: hr_utility.trace(l_routine_name||': 60');
2415: pay_ca_balance_view_pkg.set_context('JURISDICTION_CODE',
2416: p_jurisdiction);
2417: l_gl_dimension := l_dim_str1 || 'JD_' || p_time_dimension;
2418: l_lb_dimension := 'ASG_JD_'|| l_dim_str1 || p_time_dimension;

Line 2420: hr_utility.trace('Group Level Dimension: '||l_gl_dimension);

2416: p_jurisdiction);
2417: l_gl_dimension := l_dim_str1 || 'JD_' || p_time_dimension;
2418: l_lb_dimension := 'ASG_JD_'|| l_dim_str1 || p_time_dimension;
2419: END IF;
2420: hr_utility.trace('Group Level Dimension: '||l_gl_dimension);
2421: hr_utility.trace('Latest Balance Dimension: '||l_lb_dimension);
2422:
2423: IF l_assignment_id IS NOT NULL THEN
2424: l_gl_defined_balance_id := get_defined_balance(l_balance_name,

Line 2421: hr_utility.trace('Latest Balance Dimension: '||l_lb_dimension);

2417: l_gl_dimension := l_dim_str1 || 'JD_' || p_time_dimension;
2418: l_lb_dimension := 'ASG_JD_'|| l_dim_str1 || p_time_dimension;
2419: END IF;
2420: hr_utility.trace('Group Level Dimension: '||l_gl_dimension);
2421: hr_utility.trace('Latest Balance Dimension: '||l_lb_dimension);
2422:
2423: IF l_assignment_id IS NOT NULL THEN
2424: l_gl_defined_balance_id := get_defined_balance(l_balance_name,
2425: l_gl_dimension,

Line 2431: hr_utility.trace(l_routine_name||': 70');

2427: IF l_gl_defined_balance_id IS NULL THEN
2428: RETURN NULL;
2429: END IF;
2430:
2431: hr_utility.trace(l_routine_name||': 70');
2432: IF p_time_dimension = 'PYDATE' OR
2433: p_time_dimension = 'PTD' THEN
2434: IF p_time_dimension = 'PTD' OR
2435: (p_organization_id IS NULL AND

Line 2440: hr_utility.trace(l_routine_name||': 80');

2436: p_location_id IS NULL AND
2437: p_payroll_id IS NULL AND
2438: p_pay_basis_type IS NULL) THEN
2439:
2440: hr_utility.trace(l_routine_name||': 80');
2441:
2442: /*
2443: * All of the balance parameters are contexts so we can just call PYDATE
2444: * This will not use latest balances.

Line 2462: hr_utility.trace(l_routine_name||': 85');

2458: * pre-payments
2459: * We can't use latest balances in this call because they won't exist
2460: * for any of the balances we are calling.
2461: */
2462: hr_utility.trace(l_routine_name||': 85');
2463:
2464: l_balance_value := get_grp_pydate_with_aa
2465: (l_lb_dimension,
2466: l_balance_name,

Line 2482: hr_utility.trace(l_routine_name||': 90');

2478: ELSE
2479: /*
2480: * For all non-PYDATE balances
2481: */
2482: hr_utility.trace(l_routine_name||': 90');
2483: l_balance_value := get_grp_non_pydate_with_asg
2484: (l_assignment_id,
2485: p_time_dimension,
2486: l_lb_dimension,

Line 2501: hr_utility.trace(l_routine_name||': 100');

2497: p_pay_basis_type,
2498: l_business_group_id);
2499: END IF;
2500: ELSE
2501: hr_utility.trace(l_routine_name||': 100');
2502: hr_utility.trace('No Assignments to process');
2503: l_balance_value := 0;
2504: -- RAISE e_no_assignments;
2505: END IF;

Line 2502: hr_utility.trace('No Assignments to process');

2498: l_business_group_id);
2499: END IF;
2500: ELSE
2501: hr_utility.trace(l_routine_name||': 100');
2502: hr_utility.trace('No Assignments to process');
2503: l_balance_value := 0;
2504: -- RAISE e_no_assignments;
2505: END IF;
2506:

Line 2507: hr_utility.trace('Ending routine: '||l_routine_name);

2503: l_balance_value := 0;
2504: -- RAISE e_no_assignments;
2505: END IF;
2506:
2507: hr_utility.trace('Ending routine: '||l_routine_name);
2508: RETURN l_balance_value;
2509:
2510: EXCEPTION
2511: WHEN e_invalid_time_dimension THEN

Line 2744: hr_utility.trace('Starting routine: '||l_routine_name);

2740:
2741:
2742: BEGIN
2743:
2744: hr_utility.trace('Starting routine: '||l_routine_name);
2745: hr_utility.trace('P_Flag for EBRA: '||p_flag);
2746: hr_utility.trace('p_time_dimension: '||p_time_dimension);
2747: hr_utility.trace('p_effective_date: '||to_char(p_effective_date));
2748: hr_utility.trace('p_balance_name: '||p_balance_name);

Line 2745: hr_utility.trace('P_Flag for EBRA: '||p_flag);

2741:
2742: BEGIN
2743:
2744: hr_utility.trace('Starting routine: '||l_routine_name);
2745: hr_utility.trace('P_Flag for EBRA: '||p_flag);
2746: hr_utility.trace('p_time_dimension: '||p_time_dimension);
2747: hr_utility.trace('p_effective_date: '||to_char(p_effective_date));
2748: hr_utility.trace('p_balance_name: '||p_balance_name);
2749: hr_utility.trace('p_jurisdiction: '||p_jurisdiction);

Line 2746: hr_utility.trace('p_time_dimension: '||p_time_dimension);

2742: BEGIN
2743:
2744: hr_utility.trace('Starting routine: '||l_routine_name);
2745: hr_utility.trace('P_Flag for EBRA: '||p_flag);
2746: hr_utility.trace('p_time_dimension: '||p_time_dimension);
2747: hr_utility.trace('p_effective_date: '||to_char(p_effective_date));
2748: hr_utility.trace('p_balance_name: '||p_balance_name);
2749: hr_utility.trace('p_jurisdiction: '||p_jurisdiction);
2750: hr_utility.trace('p_gre_id: '||to_char(p_gre_id));

Line 2747: hr_utility.trace('p_effective_date: '||to_char(p_effective_date));

2743:
2744: hr_utility.trace('Starting routine: '||l_routine_name);
2745: hr_utility.trace('P_Flag for EBRA: '||p_flag);
2746: hr_utility.trace('p_time_dimension: '||p_time_dimension);
2747: hr_utility.trace('p_effective_date: '||to_char(p_effective_date));
2748: hr_utility.trace('p_balance_name: '||p_balance_name);
2749: hr_utility.trace('p_jurisdiction: '||p_jurisdiction);
2750: hr_utility.trace('p_gre_id: '||to_char(p_gre_id));
2751: hr_utility.trace('Starting routine: '||l_routine_name);

Line 2748: hr_utility.trace('p_balance_name: '||p_balance_name);

2744: hr_utility.trace('Starting routine: '||l_routine_name);
2745: hr_utility.trace('P_Flag for EBRA: '||p_flag);
2746: hr_utility.trace('p_time_dimension: '||p_time_dimension);
2747: hr_utility.trace('p_effective_date: '||to_char(p_effective_date));
2748: hr_utility.trace('p_balance_name: '||p_balance_name);
2749: hr_utility.trace('p_jurisdiction: '||p_jurisdiction);
2750: hr_utility.trace('p_gre_id: '||to_char(p_gre_id));
2751: hr_utility.trace('Starting routine: '||l_routine_name);
2752: hr_utility.trace('P_Flag for EBRA: '||p_flag);

Line 2749: hr_utility.trace('p_jurisdiction: '||p_jurisdiction);

2745: hr_utility.trace('P_Flag for EBRA: '||p_flag);
2746: hr_utility.trace('p_time_dimension: '||p_time_dimension);
2747: hr_utility.trace('p_effective_date: '||to_char(p_effective_date));
2748: hr_utility.trace('p_balance_name: '||p_balance_name);
2749: hr_utility.trace('p_jurisdiction: '||p_jurisdiction);
2750: hr_utility.trace('p_gre_id: '||to_char(p_gre_id));
2751: hr_utility.trace('Starting routine: '||l_routine_name);
2752: hr_utility.trace('P_Flag for EBRA: '||p_flag);
2753:

Line 2750: hr_utility.trace('p_gre_id: '||to_char(p_gre_id));

2746: hr_utility.trace('p_time_dimension: '||p_time_dimension);
2747: hr_utility.trace('p_effective_date: '||to_char(p_effective_date));
2748: hr_utility.trace('p_balance_name: '||p_balance_name);
2749: hr_utility.trace('p_jurisdiction: '||p_jurisdiction);
2750: hr_utility.trace('p_gre_id: '||to_char(p_gre_id));
2751: hr_utility.trace('Starting routine: '||l_routine_name);
2752: hr_utility.trace('P_Flag for EBRA: '||p_flag);
2753:
2754: -- Checking the EBRA Flag to use Run Balances cursors or

Line 2751: hr_utility.trace('Starting routine: '||l_routine_name);

2747: hr_utility.trace('p_effective_date: '||to_char(p_effective_date));
2748: hr_utility.trace('p_balance_name: '||p_balance_name);
2749: hr_utility.trace('p_jurisdiction: '||p_jurisdiction);
2750: hr_utility.trace('p_gre_id: '||to_char(p_gre_id));
2751: hr_utility.trace('Starting routine: '||l_routine_name);
2752: hr_utility.trace('P_Flag for EBRA: '||p_flag);
2753:
2754: -- Checking the EBRA Flag to use Run Balances cursors or
2755: -- Pay_Assignment_Actions cursors

Line 2752: hr_utility.trace('P_Flag for EBRA: '||p_flag);

2748: hr_utility.trace('p_balance_name: '||p_balance_name);
2749: hr_utility.trace('p_jurisdiction: '||p_jurisdiction);
2750: hr_utility.trace('p_gre_id: '||to_char(p_gre_id));
2751: hr_utility.trace('Starting routine: '||l_routine_name);
2752: hr_utility.trace('P_Flag for EBRA: '||p_flag);
2753:
2754: -- Checking the EBRA Flag to use Run Balances cursors or
2755: -- Pay_Assignment_Actions cursors
2756: If p_flag = 'N' then

Line 2786: hr_utility.trace(l_routine_name||': 10');

2782: END IF;
2783:
2784: IF p_time_dimension <> 'PYDATE' AND
2785: p_start_date IS NULL THEN
2786: hr_utility.trace(l_routine_name||': 10');
2787: IF p_time_dimension = 'MONTH' THEN
2788: l_start_date := TRUNC(p_effective_date,'MONTH');
2789: ELSIF p_time_dimension = 'YTD' THEN
2790: l_start_date := TRUNC(p_effective_date,'Y');

Line 2795: hr_utility.trace(l_routine_name||': 20');

2791: ELSIF p_time_dimension = 'QTD' THEN
2792: l_start_date := TRUNC(p_effective_date,'Q');
2793: END IF;
2794: ELSIF p_time_dimension = 'PYDATE' THEN
2795: hr_utility.trace(l_routine_name||': 20');
2796: IF p_start_date IS NULL THEN
2797: l_date_context := pay_ca_balance_view_pkg.get_context('BALANCE_DATE');
2798: IF l_date_context IS NOT NULL THEN
2799: l_start_date := fnd_date.canonical_to_date(l_date_context);

Line 2809: hr_utility.trace(l_routine_name||': 25');

2805: pay_ca_balance_view_pkg.set_context('BALANCE_DATE',
2806: fnd_date.date_to_canonical(p_start_date));
2807: END IF;
2808: ELSIF p_time_dimension = 'PTD' THEN
2809: hr_utility.trace(l_routine_name||': 25');
2810: l_start_date := NULL;
2811: ELSE
2812: RAISE e_invalid_dim_date_comb;
2813: END IF;

Line 2816: hr_utility.trace(l_routine_name||': 30');

2812: RAISE e_invalid_dim_date_comb;
2813: END IF;
2814:
2815: IF p_gre_id IS NOT NULL THEN
2816: hr_utility.trace(l_routine_name||': 30');
2817:
2818: pay_ca_balance_view_pkg.set_context('TAX_UNIT_ID',
2819: p_gre_id);
2820:

Line 2839: hr_utility.trace('lv_gre_type: '||lv_gre_type);

2835: from hr_organization_information hoi
2836: where hoi.org_information_context = 'Canada Employer Identification'
2837: and hoi.organization_id = p_gre_id;
2838:
2839: hr_utility.trace('lv_gre_type: '||lv_gre_type);
2840: exception
2841: when others then
2842: null;
2843:

Line 2849: hr_utility.trace('ln_newbg_id: '||to_char(ln_newbg_id));

2845:
2846: /* added code to fix bug#3637426 */
2847: open c_get_bg_id(p_gre_id);
2848: fetch c_get_bg_id into ln_newbg_id;
2849: hr_utility.trace('ln_newbg_id: '||to_char(ln_newbg_id));
2850: close c_get_bg_id;
2851:
2852: IF l_balance_name is not null THEN
2853: ln_new_defbal_id := get_defined_balance(l_balance_name,

Line 2856: hr_utility.trace('ln_new_defbal_id: '||to_char(ln_new_defbal_id));

2852: IF l_balance_name is not null THEN
2853: ln_new_defbal_id := get_defined_balance(l_balance_name,
2854: 'ASG_GRE_RUN',
2855: ln_newbg_id);
2856: hr_utility.trace('ln_new_defbal_id: '||to_char(ln_new_defbal_id));
2857: End if;
2858:
2859: /* end of code for bug#3637426 */
2860:

Line 2881: hr_utility.trace('ran csr_asg_exists_for_gre_only_rb: ');

2877:
2878: FETCH csr_asg_exists_for_gre_only_rb INTO l_assignment_id,
2879: l_business_group_id;
2880:
2881: hr_utility.trace('ran csr_asg_exists_for_gre_only_rb: ');
2882: hr_utility.trace('l_assignment_id: '||to_char(l_assignment_id));
2883: CLOSE csr_asg_exists_for_gre_only_rb;
2884: end if;
2885:

Line 2882: hr_utility.trace('l_assignment_id: '||to_char(l_assignment_id));

2878: FETCH csr_asg_exists_for_gre_only_rb INTO l_assignment_id,
2879: l_business_group_id;
2880:
2881: hr_utility.trace('ran csr_asg_exists_for_gre_only_rb: ');
2882: hr_utility.trace('l_assignment_id: '||to_char(l_assignment_id));
2883: CLOSE csr_asg_exists_for_gre_only_rb;
2884: end if;
2885:
2886: ELSE

Line 2901: hr_utility.trace('ran csr_asg_exists_for_gre_rb: ');

2897: lv_gre_type,
2898: ln_new_defbal_id);
2899: FETCH csr_asg_exists_for_gre_rb INTO l_assignment_id,
2900: l_business_group_id;
2901: hr_utility.trace('ran csr_asg_exists_for_gre_rb: ');
2902: hr_utility.trace('l_assignment_id: '||to_char(l_assignment_id));
2903: CLOSE csr_asg_exists_for_gre_rb;
2904: end if;
2905:

Line 2902: hr_utility.trace('l_assignment_id: '||to_char(l_assignment_id));

2898: ln_new_defbal_id);
2899: FETCH csr_asg_exists_for_gre_rb INTO l_assignment_id,
2900: l_business_group_id;
2901: hr_utility.trace('ran csr_asg_exists_for_gre_rb: ');
2902: hr_utility.trace('l_assignment_id: '||to_char(l_assignment_id));
2903: CLOSE csr_asg_exists_for_gre_rb;
2904: end if;
2905:
2906:

Line 2910: hr_utility.trace(l_routine_name||': 40');

2906:
2907: END IF;
2908:
2909: ELSIF p_source_id IS NOT NULL THEN
2910: hr_utility.trace(l_routine_name||': 40');
2911:
2912: pay_ca_balance_view_pkg.set_context('SOURCE_ID',
2913: p_source_id);
2914:

Line 2925: hr_utility.trace('ln_new_defbal_id: '||to_char(ln_new_defbal_id));

2921: IF l_balance_name is not null THEN
2922: ln_new_defbal_id := get_defined_balance(l_balance_name,
2923: 'ASG_RPT_UNIT_RUN',
2924: ln_newbg_id);
2925: hr_utility.trace('ln_new_defbal_id: '||to_char(ln_new_defbal_id));
2926: End if;
2927: /* end of adding code for bug#3637426 */
2928:
2929: /*

Line 2945: hr_utility.trace('ran csr_asg_exists_for_src_rb: ');

2941: p_source_id,
2942: ln_new_defbal_id);
2943: FETCH csr_asg_exists_for_src_rb INTO l_assignment_id,
2944: l_business_group_id;
2945: hr_utility.trace('ran csr_asg_exists_for_src_rb: ');
2946: hr_utility.trace('l_assignment_id: '||to_char(l_assignment_id));
2947: CLOSE csr_asg_exists_for_src_rb;
2948: end if;
2949:

Line 2946: hr_utility.trace('l_assignment_id: '||to_char(l_assignment_id));

2942: ln_new_defbal_id);
2943: FETCH csr_asg_exists_for_src_rb INTO l_assignment_id,
2944: l_business_group_id;
2945: hr_utility.trace('ran csr_asg_exists_for_src_rb: ');
2946: hr_utility.trace('l_assignment_id: '||to_char(l_assignment_id));
2947: CLOSE csr_asg_exists_for_src_rb;
2948: end if;
2949:
2950: ELSE

Line 2964: hr_utility.trace(l_routine_name||': 50');

2960: * Assignment - _ASG_JD_GRE_MONTH
2961: */
2962:
2963: IF p_jurisdiction IS NULL THEN
2964: hr_utility.trace(l_routine_name||': 50');
2965: l_gl_dimension := l_dim_str1 || p_time_dimension;
2966: l_lb_dimension := 'ASG_' || l_gl_dimension;
2967: ELSE
2968: hr_utility.trace(l_routine_name||': 60');

Line 2968: hr_utility.trace(l_routine_name||': 60');

2964: hr_utility.trace(l_routine_name||': 50');
2965: l_gl_dimension := l_dim_str1 || p_time_dimension;
2966: l_lb_dimension := 'ASG_' || l_gl_dimension;
2967: ELSE
2968: hr_utility.trace(l_routine_name||': 60');
2969: pay_ca_balance_view_pkg.set_context('JURISDICTION_CODE',
2970: p_jurisdiction);
2971: l_gl_dimension := l_dim_str1 || 'JD_' || p_time_dimension;
2972: l_lb_dimension := 'ASG_JD_'|| l_dim_str1 || p_time_dimension;

Line 2974: hr_utility.trace('Group Level Dimension: '||l_gl_dimension);

2970: p_jurisdiction);
2971: l_gl_dimension := l_dim_str1 || 'JD_' || p_time_dimension;
2972: l_lb_dimension := 'ASG_JD_'|| l_dim_str1 || p_time_dimension;
2973: END IF;
2974: hr_utility.trace('Group Level Dimension: '||l_gl_dimension);
2975: hr_utility.trace('Latest Balance Dimension: '||l_lb_dimension);
2976:
2977:
2978: IF l_assignment_id IS NOT NULL THEN

Line 2975: hr_utility.trace('Latest Balance Dimension: '||l_lb_dimension);

2971: l_gl_dimension := l_dim_str1 || 'JD_' || p_time_dimension;
2972: l_lb_dimension := 'ASG_JD_'|| l_dim_str1 || p_time_dimension;
2973: END IF;
2974: hr_utility.trace('Group Level Dimension: '||l_gl_dimension);
2975: hr_utility.trace('Latest Balance Dimension: '||l_lb_dimension);
2976:
2977:
2978: IF l_assignment_id IS NOT NULL THEN
2979: l_gl_defined_balance_id := get_defined_balance(l_balance_name,

Line 2982: hr_utility.trace('l_gl_defined_balance_id: '||to_char(l_gl_defined_balance_id));

2978: IF l_assignment_id IS NOT NULL THEN
2979: l_gl_defined_balance_id := get_defined_balance(l_balance_name,
2980: l_gl_dimension,
2981: ln_newbg_id);
2982: hr_utility.trace('l_gl_defined_balance_id: '||to_char(l_gl_defined_balance_id));
2983:
2984: hr_utility.trace('l_assignment_id is not null satisfied ');
2985: IF l_gl_defined_balance_id IS NULL THEN
2986: RETURN NULL;

Line 2984: hr_utility.trace('l_assignment_id is not null satisfied ');

2980: l_gl_dimension,
2981: ln_newbg_id);
2982: hr_utility.trace('l_gl_defined_balance_id: '||to_char(l_gl_defined_balance_id));
2983:
2984: hr_utility.trace('l_assignment_id is not null satisfied ');
2985: IF l_gl_defined_balance_id IS NULL THEN
2986: RETURN NULL;
2987: END IF;
2988:

Line 2989: hr_utility.trace(l_routine_name||': 70');

2985: IF l_gl_defined_balance_id IS NULL THEN
2986: RETURN NULL;
2987: END IF;
2988:
2989: hr_utility.trace(l_routine_name||': 70');
2990:
2991: IF p_time_dimension = 'PYDATE' OR
2992: p_time_dimension = 'PTD' THEN
2993: IF p_time_dimension = 'PTD' OR

Line 2999: hr_utility.trace(l_routine_name||': 80');

2995: p_location_id IS NULL AND
2996: p_payroll_id IS NULL AND
2997: p_pay_basis_type IS NULL) THEN
2998:
2999: hr_utility.trace(l_routine_name||': 80');
3000:
3001: /*
3002: * All of the balance parameters are contexts so we can just call PYDATE
3003: * This will not use latest balances.

Line 3005: hr_utility.trace('Calling pay_ca_balance_view_pkg.get_value ');

3001: /*
3002: * All of the balance parameters are contexts so we can just call PYDATE
3003: * This will not use latest balances.
3004: */
3005: hr_utility.trace('Calling pay_ca_balance_view_pkg.get_value ');
3006:
3007: hr_utility.trace('l_assignment_id :'||to_char(l_assignment_id));
3008: l_balance_value :=
3009: pay_ca_balance_view_pkg.get_value (l_assignment_id,

Line 3007: hr_utility.trace('l_assignment_id :'||to_char(l_assignment_id));

3003: * This will not use latest balances.
3004: */
3005: hr_utility.trace('Calling pay_ca_balance_view_pkg.get_value ');
3006:
3007: hr_utility.trace('l_assignment_id :'||to_char(l_assignment_id));
3008: l_balance_value :=
3009: pay_ca_balance_view_pkg.get_value (l_assignment_id,
3010: l_gl_defined_balance_id,
3011: p_effective_date);

Line 3012: hr_utility.trace('l_balance_value :'||to_char(l_balance_value));

3008: l_balance_value :=
3009: pay_ca_balance_view_pkg.get_value (l_assignment_id,
3010: l_gl_defined_balance_id,
3011: p_effective_date);
3012: hr_utility.trace('l_balance_value :'||to_char(l_balance_value));
3013: ELSE
3014: /*
3015: * At least one of the balance parameters is not a context so we
3016: * must sum up all the relevant individual assignment action balance

Line 3025: hr_utility.trace(l_routine_name||': 85');

3021: * pre-payments
3022: * We can't use latest balances in this call because they won't exist
3023: * for any of the balances we are calling.
3024: */
3025: hr_utility.trace(l_routine_name||': 85');
3026: hr_utility.trace('Calling get_grp_pydate_with_aa_rb ');
3027:
3028: l_balance_value := get_grp_pydate_with_aa_rb
3029: (l_lb_dimension,

Line 3026: hr_utility.trace('Calling get_grp_pydate_with_aa_rb ');

3022: * We can't use latest balances in this call because they won't exist
3023: * for any of the balances we are calling.
3024: */
3025: hr_utility.trace(l_routine_name||': 85');
3026: hr_utility.trace('Calling get_grp_pydate_with_aa_rb ');
3027:
3028: l_balance_value := get_grp_pydate_with_aa_rb
3029: (l_lb_dimension,
3030: l_balance_name,

Line 3041: hr_utility.trace('l_balance_value :'||to_char(l_balance_value));

3037: p_location_id,
3038: p_payroll_id,
3039: p_pay_basis_type,
3040: l_business_group_id);
3041: hr_utility.trace('l_balance_value :'||to_char(l_balance_value));
3042: END IF;
3043: ELSE
3044: /*
3045: * For all non-PYDATE balances

Line 3047: hr_utility.trace(l_routine_name||': 90');

3043: ELSE
3044: /*
3045: * For all non-PYDATE balances
3046: */
3047: hr_utility.trace(l_routine_name||': 90');
3048: hr_utility.trace('Calling get_grp_non_pydate_with_asg_rb ');
3049: l_balance_value := get_grp_non_pydate_with_asg_rb
3050: (l_assignment_id,
3051: p_time_dimension,

Line 3048: hr_utility.trace('Calling get_grp_non_pydate_with_asg_rb ');

3044: /*
3045: * For all non-PYDATE balances
3046: */
3047: hr_utility.trace(l_routine_name||': 90');
3048: hr_utility.trace('Calling get_grp_non_pydate_with_asg_rb ');
3049: l_balance_value := get_grp_non_pydate_with_asg_rb
3050: (l_assignment_id,
3051: p_time_dimension,
3052: l_lb_dimension,

Line 3065: hr_utility.trace('l_balance_value :'||to_char(l_balance_value));

3061: p_location_id,
3062: p_payroll_id,
3063: p_pay_basis_type,
3064: l_business_group_id);
3065: hr_utility.trace('l_balance_value :'||to_char(l_balance_value));
3066: END IF;
3067: ELSE
3068: hr_utility.trace(l_routine_name||': 100');
3069: hr_utility.trace('No Assignments to process');

Line 3068: hr_utility.trace(l_routine_name||': 100');

3064: l_business_group_id);
3065: hr_utility.trace('l_balance_value :'||to_char(l_balance_value));
3066: END IF;
3067: ELSE
3068: hr_utility.trace(l_routine_name||': 100');
3069: hr_utility.trace('No Assignments to process');
3070: l_balance_value := 0;
3071: -- RAISE e_no_assignments;
3072: END IF;

Line 3069: hr_utility.trace('No Assignments to process');

3065: hr_utility.trace('l_balance_value :'||to_char(l_balance_value));
3066: END IF;
3067: ELSE
3068: hr_utility.trace(l_routine_name||': 100');
3069: hr_utility.trace('No Assignments to process');
3070: l_balance_value := 0;
3071: -- RAISE e_no_assignments;
3072: END IF;
3073:

Line 3076: hr_utility.trace('Ending routine: '||l_routine_name);

3072: END IF;
3073:
3074: End if; -- for EBRA p_flag check
3075:
3076: hr_utility.trace('Ending routine: '||l_routine_name);
3077:
3078: RETURN l_balance_value;
3079:
3080: EXCEPTION

Line 3082: hr_utility.trace('The time dimension is invalid');

3078: RETURN l_balance_value;
3079:
3080: EXCEPTION
3081: WHEN e_invalid_time_dimension THEN
3082: hr_utility.trace('The time dimension is invalid');
3083: WHEN e_no_assignments THEN
3084: hr_utility.trace('No Assignments to process');
3085: WHEN e_no_gre_or_source_id THEN
3086: hr_utility.trace('Either a GRE or a Reporting Unit '||

Line 3084: hr_utility.trace('No Assignments to process');

3080: EXCEPTION
3081: WHEN e_invalid_time_dimension THEN
3082: hr_utility.trace('The time dimension is invalid');
3083: WHEN e_no_assignments THEN
3084: hr_utility.trace('No Assignments to process');
3085: WHEN e_no_gre_or_source_id THEN
3086: hr_utility.trace('Either a GRE or a Reporting Unit '||
3087: '(Source Id) must be passed to this routine');
3088: WHEN e_no_gre_specified THEN

Line 3086: hr_utility.trace('Either a GRE or a Reporting Unit '||

3082: hr_utility.trace('The time dimension is invalid');
3083: WHEN e_no_assignments THEN
3084: hr_utility.trace('No Assignments to process');
3085: WHEN e_no_gre_or_source_id THEN
3086: hr_utility.trace('Either a GRE or a Reporting Unit '||
3087: '(Source Id) must be passed to this routine');
3088: WHEN e_no_gre_specified THEN
3089: hr_utility.trace('The GRE parameter must be specified');
3090: WHEN e_no_source_id_specified THEN

Line 3089: hr_utility.trace('The GRE parameter must be specified');

3085: WHEN e_no_gre_or_source_id THEN
3086: hr_utility.trace('Either a GRE or a Reporting Unit '||
3087: '(Source Id) must be passed to this routine');
3088: WHEN e_no_gre_specified THEN
3089: hr_utility.trace('The GRE parameter must be specified');
3090: WHEN e_no_source_id_specified THEN
3091: hr_utility.trace('The Source Id parameter must be specified');
3092: WHEN e_jurisdiction_must_be_null THEN
3093: hr_utility.trace('The Jurisdiction parameter can not be entered for Reporting Unit balances');

Line 3091: hr_utility.trace('The Source Id parameter must be specified');

3087: '(Source Id) must be passed to this routine');
3088: WHEN e_no_gre_specified THEN
3089: hr_utility.trace('The GRE parameter must be specified');
3090: WHEN e_no_source_id_specified THEN
3091: hr_utility.trace('The Source Id parameter must be specified');
3092: WHEN e_jurisdiction_must_be_null THEN
3093: hr_utility.trace('The Jurisdiction parameter can not be entered for Reporting Unit balances');
3094: WHEN e_invalid_dim_date_comb THEN
3095: hr_utility.trace('The Start Date parameter must be entered only when the dimension is PYDATE');

Line 3093: hr_utility.trace('The Jurisdiction parameter can not be entered for Reporting Unit balances');

3089: hr_utility.trace('The GRE parameter must be specified');
3090: WHEN e_no_source_id_specified THEN
3091: hr_utility.trace('The Source Id parameter must be specified');
3092: WHEN e_jurisdiction_must_be_null THEN
3093: hr_utility.trace('The Jurisdiction parameter can not be entered for Reporting Unit balances');
3094: WHEN e_invalid_dim_date_comb THEN
3095: hr_utility.trace('The Start Date parameter must be entered only when the dimension is PYDATE');
3096: WHEN e_no_rpt_unit_for_pydate THEN
3097: hr_utility.trace('The Reporting Unit dimension can not be used for pay date range calculations');

Line 3095: hr_utility.trace('The Start Date parameter must be entered only when the dimension is PYDATE');

3091: hr_utility.trace('The Source Id parameter must be specified');
3092: WHEN e_jurisdiction_must_be_null THEN
3093: hr_utility.trace('The Jurisdiction parameter can not be entered for Reporting Unit balances');
3094: WHEN e_invalid_dim_date_comb THEN
3095: hr_utility.trace('The Start Date parameter must be entered only when the dimension is PYDATE');
3096: WHEN e_no_rpt_unit_for_pydate THEN
3097: hr_utility.trace('The Reporting Unit dimension can not be used for pay date range calculations');
3098: WHEN e_no_start_date_for_pydate THEN
3099: hr_utility.trace('The Start Date parameter MUST be entered when the dimension is PYDATE');

Line 3097: hr_utility.trace('The Reporting Unit dimension can not be used for pay date range calculations');

3093: hr_utility.trace('The Jurisdiction parameter can not be entered for Reporting Unit balances');
3094: WHEN e_invalid_dim_date_comb THEN
3095: hr_utility.trace('The Start Date parameter must be entered only when the dimension is PYDATE');
3096: WHEN e_no_rpt_unit_for_pydate THEN
3097: hr_utility.trace('The Reporting Unit dimension can not be used for pay date range calculations');
3098: WHEN e_no_start_date_for_pydate THEN
3099: hr_utility.trace('The Start Date parameter MUST be entered when the dimension is PYDATE');
3100:
3101:

Line 3099: hr_utility.trace('The Start Date parameter MUST be entered when the dimension is PYDATE');

3095: hr_utility.trace('The Start Date parameter must be entered only when the dimension is PYDATE');
3096: WHEN e_no_rpt_unit_for_pydate THEN
3097: hr_utility.trace('The Reporting Unit dimension can not be used for pay date range calculations');
3098: WHEN e_no_start_date_for_pydate THEN
3099: hr_utility.trace('The Start Date parameter MUST be entered when the dimension is PYDATE');
3100:
3101:
3102: END ca_group_level_balance_rb;
3103: