eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_US_PAYSLIP_SIMULATION_MAIN dependencies on HR_UTILITY

Line 105: hr_utility.trace('Entering '||gv_package||lv_procedure_name);

101: lv_reporting_level hr_organization_information.org_information1%TYPE;
102:
103: BEGIN
104:
105: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
106:
107: pay_us_payslip_simulation_main.lrr_act_tab.delete;
108: pay_us_payslip_simulation_main.emp_elements_tab.delete;
109:

Line 110: hr_utility.set_location(gv_package || lv_procedure_name, 10);

106:
107: pay_us_payslip_simulation_main.lrr_act_tab.delete;
108: pay_us_payslip_simulation_main.emp_elements_tab.delete;
109:
110: hr_utility.set_location(gv_package || lv_procedure_name, 10);
111:
112: IF p_legislation_code = 'CA' THEN
113:
114: hr_utility.set_location(gv_package || lv_procedure_name, 20);

Line 114: hr_utility.set_location(gv_package || lv_procedure_name, 20);

110: hr_utility.set_location(gv_package || lv_procedure_name, 10);
111:
112: IF p_legislation_code = 'CA' THEN
113:
114: hr_utility.set_location(gv_package || lv_procedure_name, 20);
115:
116: OPEN cur_reporting_level(p_payroll_action_id);
117: FETCH cur_reporting_level INTO lv_reporting_level;
118:

Line 135: hr_utility.set_location(gv_package || lv_procedure_name, 30);

131: END IF;
132:
133: IF pay_us_payslip_simulation_main.ltr_summary_labels.count = 0 THEN
134:
135: hr_utility.set_location(gv_package || lv_procedure_name, 30);
136:
137: i := 0;
138:
139: FOR lbl in c_arch_labels LOOP

Line 153: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);

149: END IF;
150:
151: END IF; /*p_legislation_code = 'CA' IF*/
152:
153: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);
154:
155: END initialization_process;
156:
157: /* Procedure : update_asg_data

Line 390: hr_utility.trace('Entering '||gv_package||lv_procedure_name);

386: lb_return BOOLEAN := FALSE;
387:
388: BEGIN
389:
390: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
391:
392: IF (p_value IS NULL AND p_default_value IS NOT NULL)
393: OR
394: (p_value IS NOT NULL AND p_default_value IS NULL)

Line 406: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);

402: END IF;
403:
404: RETURN lb_return;
405:
406: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);
407:
408: END value_changed;
409:
410: BEGIN

Line 412: hr_utility.trace('Entering '||gv_package||lv_procedure_name);

408: END value_changed;
409:
410: BEGIN
411:
412: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
413:
414: OPEN get_details(p_source_action_id);
415: FETCH get_details INTO ln_assignment_id,
416: ln_business_group_id,

Line 425: hr_utility.set_location(gv_package || lv_procedure_name, 10);

421: OPEN get_person_details(ln_assignment_id,ld_effective_date);
422: FETCH get_person_details INTO ln_person_id,ln_asg_object_version_number;
423: CLOSE get_person_details;
424:
425: hr_utility.set_location(gv_package || lv_procedure_name, 10);
426:
427: IF p_effective_date IS NOT NULL THEN
428:
429: hr_utility.set_location(gv_package || lv_procedure_name, 20);

Line 429: hr_utility.set_location(gv_package || lv_procedure_name, 20);

425: hr_utility.set_location(gv_package || lv_procedure_name, 10);
426:
427: IF p_effective_date IS NOT NULL THEN
428:
429: hr_utility.set_location(gv_package || lv_procedure_name, 20);
430:
431: ld_effective_date := p_effective_date;
432:
433: END IF;

Line 439: hr_utility.set_location(gv_package || lv_procedure_name, 30);

435: OPEN get_legislation_code(ln_business_group_id,ld_effective_date);
436: FETCH get_legislation_code INTO lv_legislation_code;
437: CLOSE get_legislation_code;
438:
439: hr_utility.set_location(gv_package || lv_procedure_name, 30);
440:
441: OPEN get_assignment_information(ln_assignment_id,
442: lv_legislation_code);
443:

Line 476: hr_utility.set_location(gv_package || lv_procedure_name, 40);

472: lct_default_region2 := lct_asg_information;
473:
474: END IF;
475:
476: hr_utility.set_location(gv_package || lv_procedure_name, 40);
477:
478: END LOOP;
479:
480: CLOSE get_assignment_information;

Line 482: hr_utility.set_location(gv_package || lv_procedure_name, 50);

478: END LOOP;
479:
480: CLOSE get_assignment_information;
481:
482: hr_utility.set_location(gv_package || lv_procedure_name, 50);
483:
484: IF lv_legislation_code = 'US' THEN
485:
486: IF lct_region1.aei_information_category = 'US_SIMULATION_REGION1' AND

Line 952: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);

948: NULL;
949:
950: END IF; /* lv_legislation_code IF */
951:
952: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);
953:
954: END;
955:
956: /* Procedure : get_defined_balance_id

Line 1009: hr_utility.trace('Entering '||gv_package||lv_procedure_name);

1005: ln_defined_balance_id NUMBER := NULL;
1006:
1007: BEGIN
1008:
1009: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
1010:
1011: OPEN c_get_defined_balance_id(p_legislation_code,
1012: p_business_group_id,
1013: p_balance_name,

Line 1021: hr_utility.trace('Defined balance Id not found');

1017: FETCH c_get_defined_balance_id INTO ln_defined_balance_id;
1018:
1019: IF c_get_defined_balance_id%NOTFOUND THEN
1020:
1021: hr_utility.trace('Defined balance Id not found');
1022:
1023: END IF;
1024:
1025: CLOSE c_get_defined_balance_id;

Line 1027: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);

1023: END IF;
1024:
1025: CLOSE c_get_defined_balance_id;
1026:
1027: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);
1028: hr_utility.trace('Return Value : '||ln_defined_balance_id);
1029:
1030: RETURN (ln_defined_balance_id);
1031:

Line 1028: hr_utility.trace('Return Value : '||ln_defined_balance_id);

1024:
1025: CLOSE c_get_defined_balance_id;
1026:
1027: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);
1028: hr_utility.trace('Return Value : '||ln_defined_balance_id);
1029:
1030: RETURN (ln_defined_balance_id);
1031:
1032: END get_defined_balance_id;

Line 1114: hr_utility.trace('Entering '||gv_package||lv_procedure_name);

1110: lv_dim_dbi_suffix pay_balance_dimensions.database_item_suffix%TYPE;
1111:
1112: BEGIN
1113:
1114: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
1115:
1116: /*For US,MX and CA Localizations we have the "Gross Earnings" Balance
1117: and "_ASG_RUN" Dimension*/
1118:

Line 1122: hr_utility.set_location(gv_package || lv_procedure_name, 10);

1118:
1119: lv_balance_name := p_gross_balance;
1120: lv_dim_dbi_suffix := p_run_dimension_suffix;
1121:
1122: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1123:
1124: ln_defined_balance_id :=
1125: get_defined_balance_id(p_legislation_code,
1126: NULL,

Line 1130: hr_utility.set_location(gv_package || lv_procedure_name, 20);

1126: NULL,
1127: lv_balance_name,
1128: lv_dim_dbi_suffix);
1129:
1130: hr_utility.set_location(gv_package || lv_procedure_name, 20);
1131:
1132: IF ln_defined_balance_id IS NOT NULL THEN
1133:
1134: hr_utility.set_location(gv_package || lv_procedure_name, 30);

Line 1134: hr_utility.set_location(gv_package || lv_procedure_name, 30);

1130: hr_utility.set_location(gv_package || lv_procedure_name, 20);
1131:
1132: IF ln_defined_balance_id IS NOT NULL THEN
1133:
1134: hr_utility.set_location(gv_package || lv_procedure_name, 30);
1135:
1136: ln_gross_earnings := pay_balance_pkg.get_value(ln_defined_balance_id,
1137: p_assignment_action_id);
1138:

Line 1141: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);

1137: p_assignment_action_id);
1138:
1139: END IF;
1140:
1141: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);
1142: hr_utility.trace('Return Value : '||ln_gross_earnings);
1143:
1144: RETURN ln_gross_earnings;
1145:

Line 1142: hr_utility.trace('Return Value : '||ln_gross_earnings);

1138:
1139: END IF;
1140:
1141: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);
1142: hr_utility.trace('Return Value : '||ln_gross_earnings);
1143:
1144: RETURN ln_gross_earnings;
1145:
1146: END gross_earnings;

Line 1204: hr_utility.trace('Entering '||gv_package||lv_procedure_name);

1200: l_emp_res_dtls_rec c_get_emp_res_dtls%ROWTYPE;
1201:
1202: BEGIN
1203:
1204: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
1205:
1206: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1207:
1208: OPEN c_get_emp_res_dtls(p_assignment_id,p_effective_date);

Line 1206: hr_utility.set_location(gv_package || lv_procedure_name, 10);

1202: BEGIN
1203:
1204: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
1205:
1206: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1207:
1208: OPEN c_get_emp_res_dtls(p_assignment_id,p_effective_date);
1209: FETCH c_get_emp_res_dtls INTO l_emp_res_dtls_rec;
1210: CLOSE c_get_emp_res_dtls;

Line 1212: hr_utility.set_location(gv_package || lv_procedure_name, 20);

1208: OPEN c_get_emp_res_dtls(p_assignment_id,p_effective_date);
1209: FETCH c_get_emp_res_dtls INTO l_emp_res_dtls_rec;
1210: CLOSE c_get_emp_res_dtls;
1211:
1212: hr_utility.set_location(gv_package || lv_procedure_name, 20);
1213:
1214: OPEN c_get_emp_res_jd(l_emp_res_dtls_rec.state_abbrev,
1215: l_emp_res_dtls_rec.county_name,
1216: l_emp_res_dtls_rec.city_name);

Line 1220: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);

1216: l_emp_res_dtls_rec.city_name);
1217: FETCH c_get_emp_res_jd INTO p_jurisdiction_code;
1218: CLOSE c_get_emp_res_jd;
1219:
1220: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);
1221: hr_utility.trace('Return Value : '||p_jurisdiction_code);
1222:
1223: END get_emp_resident_jd;
1224:

Line 1221: hr_utility.trace('Return Value : '||p_jurisdiction_code);

1217: FETCH c_get_emp_res_jd INTO p_jurisdiction_code;
1218: CLOSE c_get_emp_res_jd;
1219:
1220: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);
1221: hr_utility.trace('Return Value : '||p_jurisdiction_code);
1222:
1223: END get_emp_resident_jd;
1224:
1225: /* Procedure : get_personal_information

Line 1426: hr_utility.trace('Entering '||gv_package||lv_procedure_name);

1422:
1423:
1424: BEGIN
1425:
1426: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
1427:
1428: lv_exists := 'N';
1429:
1430: hr_utility.set_location(gv_package || lv_procedure_name, 10);

Line 1430: hr_utility.set_location(gv_package || lv_procedure_name, 10);

1426: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
1427:
1428: lv_exists := 'N';
1429:
1430: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1431:
1432: pay_emp_action_arch.initialization_process;
1433:
1434: hr_utility.set_location(gv_package || lv_procedure_name, 20);

Line 1434: hr_utility.set_location(gv_package || lv_procedure_name, 20);

1430: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1431:
1432: pay_emp_action_arch.initialization_process;
1433:
1434: hr_utility.set_location(gv_package || lv_procedure_name, 20);
1435:
1436: OPEN c_employee_details(p_assignment_id,p_effective_date,p_date_earned);
1437:
1438: FETCH c_employee_details INTO lv_full_name,

Line 1474: hr_utility.set_location(gv_package || lv_procedure_name, 30);

1470: ld_period_start_date,
1471: ld_period_end_date;
1472: CLOSE c_period_details;
1473:
1474: hr_utility.set_location(gv_package || lv_procedure_name, 30);
1475:
1476: lv_gre_name := pay_emp_action_arch.get_organization_name(p_tax_unit_id);
1477: lv_organization_name := pay_emp_action_arch.get_organization_name(ln_organization_id);
1478:

Line 1479: hr_utility.set_location(gv_package || lv_procedure_name, 40);

1475:
1476: lv_gre_name := pay_emp_action_arch.get_organization_name(p_tax_unit_id);
1477: lv_organization_name := pay_emp_action_arch.get_organization_name(ln_organization_id);
1478:
1479: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1480:
1481: IF ln_job_id IS NOT NULL THEN
1482: lv_job_name := pay_emp_action_arch.get_job_name(ln_job_id
1483: ,p_effective_date);

Line 1486: hr_utility.set_location(gv_package || lv_procedure_name, 50);

1482: lv_job_name := pay_emp_action_arch.get_job_name(ln_job_id
1483: ,p_effective_date);
1484: END IF ;
1485:
1486: hr_utility.set_location(gv_package || lv_procedure_name, 50);
1487:
1488: IF ln_position_id IS NOT NULL THEN
1489: lv_position_name := pay_emp_action_arch.get_position(ln_position_id
1490: ,p_effective_date);

Line 1493: hr_utility.set_location(gv_package || lv_procedure_name, 60);

1489: lv_position_name := pay_emp_action_arch.get_position(ln_position_id
1490: ,p_effective_date);
1491: END IF;
1492:
1493: hr_utility.set_location(gv_package || lv_procedure_name, 60);
1494:
1495: IF ln_pay_basis_id IS NOT NULL THEN
1496: lv_pay_basis := pay_emp_action_arch.get_pay_basis(ln_pay_basis_id
1497: ,p_effective_date);

Line 1500: hr_utility.set_location(gv_package || lv_procedure_name, 70);

1496: lv_pay_basis := pay_emp_action_arch.get_pay_basis(ln_pay_basis_id
1497: ,p_effective_date);
1498: END IF;
1499:
1500: hr_utility.set_location(gv_package || lv_procedure_name, 70);
1501:
1502: IF ln_location_id IS NOT NULL THEN
1503: lv_location_code := pay_emp_action_arch.get_location(ln_location_id);
1504: END IF;

Line 1506: hr_utility.set_location(gv_package || lv_procedure_name, 80);

1502: IF ln_location_id IS NOT NULL THEN
1503: lv_location_code := pay_emp_action_arch.get_location(ln_location_id);
1504: END IF;
1505:
1506: hr_utility.set_location(gv_package || lv_procedure_name, 80);
1507:
1508: ln_proposed_salary := pay_emp_action_arch.get_proposed_emp_salary(p_assignment_id
1509: ,ln_pay_basis_id
1510: ,lv_pay_basis

Line 1513: hr_utility.set_location(gv_package || lv_procedure_name, 90);

1509: ,ln_pay_basis_id
1510: ,lv_pay_basis
1511: ,p_date_earned);
1512:
1513: hr_utility.set_location(gv_package || lv_procedure_name, 90);
1514:
1515: ln_pay_annualization_factor := pay_emp_action_arch.get_emp_annualization_factor(
1516: ln_pay_basis_id
1517: ,lv_period_type

Line 1522: hr_utility.set_location(gv_package || lv_procedure_name, 100);

1518: ,lv_pay_basis
1519: ,p_assignment_id
1520: ,p_date_earned);
1521:
1522: hr_utility.set_location(gv_package || lv_procedure_name, 100);
1523:
1524: IF lv_frequency IS NOT NULL THEN
1525: lv_frequency_desc := pay_emp_action_arch.get_frequency(lv_frequency
1526: ,p_effective_date);

Line 1529: hr_utility.set_location(gv_package || lv_procedure_name, 110);

1525: lv_frequency_desc := pay_emp_action_arch.get_frequency(lv_frequency
1526: ,p_effective_date);
1527: END IF;
1528:
1529: hr_utility.set_location(gv_package || lv_procedure_name, 110);
1530:
1531: IF ln_grade_id IS NOT NULL THEN
1532: lv_grade := pay_emp_action_arch.get_grade(ln_grade_id
1533: ,p_effective_date);

Line 1536: hr_utility.set_location(gv_package || lv_procedure_name, 120);

1532: lv_grade := pay_emp_action_arch.get_grade(ln_grade_id
1533: ,p_effective_date);
1534: END IF;
1535:
1536: hr_utility.set_location(gv_package || lv_procedure_name, 120);
1537:
1538: IF lv_bargaining_unit_code IS NOT NULL THEN
1539: lv_bargaining_unit := pay_emp_action_arch.get_bargaining_unit(lv_bargaining_unit_code
1540: ,p_effective_date);

Line 1543: hr_utility.set_location(gv_package || lv_procedure_name, 130);

1539: lv_bargaining_unit := pay_emp_action_arch.get_bargaining_unit(lv_bargaining_unit_code
1540: ,p_effective_date);
1541: END IF;
1542:
1543: hr_utility.set_location(gv_package || lv_procedure_name, 130);
1544:
1545: IF ln_collective_agreement_id IS NOT NULL THEN
1546: lv_collective_agreement := pay_emp_action_arch.get_collective_agreement(
1547: ln_collective_agreement_id

Line 1552: hr_utility.set_location(gv_package || lv_procedure_name, 140);

1548: ,p_effective_date
1549: );
1550: END IF;
1551:
1552: hr_utility.set_location(gv_package || lv_procedure_name, 140);
1553:
1554: IF ln_contract_id IS NOT NULL THEN
1555: lv_contract := pay_emp_action_arch.get_contract(ln_contract_id
1556: ,p_effective_date) ;

Line 1559: hr_utility.set_location(gv_package || lv_procedure_name, 150);

1555: lv_contract := pay_emp_action_arch.get_contract(ln_contract_id
1556: ,p_effective_date) ;
1557: END IF;
1558:
1559: hr_utility.set_location(gv_package || lv_procedure_name, 150);
1560:
1561: IF lv_hourly_salaried_code IS NOT NULL THEN
1562: lv_hourly_salaried_desc := pay_emp_action_arch.get_hourly_salaried_code(
1563: lv_hourly_salaried_code

Line 1567: hr_utility.set_location(gv_package || lv_procedure_name, 160);

1563: lv_hourly_salaried_code
1564: ,p_effective_date) ;
1565: END IF;
1566:
1567: hr_utility.set_location(gv_package || lv_procedure_name, 160);
1568:
1569: IF ln_soft_coding_keyflex_id IS NOT NULL THEN
1570: lv_shift_desc := pay_emp_action_arch.get_shift( ln_soft_coding_keyflex_id
1571: ,p_effective_date,ln_business_group_id) ;

Line 1574: hr_utility.set_location(gv_package || lv_procedure_name, 170);

1570: lv_shift_desc := pay_emp_action_arch.get_shift( ln_soft_coding_keyflex_id
1571: ,p_effective_date,ln_business_group_id) ;
1572: END IF;
1573:
1574: hr_utility.set_location(gv_package || lv_procedure_name, 170);
1575:
1576: OPEN er_phone_number(ln_organization_id);
1577: FETCH er_phone_number INTO lv_er_phone_number;
1578: CLOSE er_phone_number;

Line 1586: hr_utility.set_location(gv_package || lv_procedure_name, 180);

1582: FETCH c_step INTO lv_step;
1583: CLOSE c_step;
1584: END IF;
1585:
1586: hr_utility.set_location(gv_package || lv_procedure_name, 180);
1587:
1588: ln_index := pay_emp_action_arch.lrr_act_tab.count;
1589:
1590: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category

Line 1612: hr_utility.trace('lv_full_name is'||lv_full_name);

1608: := lv_employee_name;
1609:
1610: END IF;
1611:
1612: hr_utility.trace('lv_full_name is'||lv_full_name);
1613:
1614: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
1615: := ln_organization_id;
1616: hr_utility.trace('ln_organization_id is'||ln_organization_id);

Line 1616: hr_utility.trace('ln_organization_id is'||ln_organization_id);

1612: hr_utility.trace('lv_full_name is'||lv_full_name);
1613:
1614: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
1615: := ln_organization_id;
1616: hr_utility.trace('ln_organization_id is'||ln_organization_id);
1617:
1618: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
1619: := lv_national_identifier ;
1620:

Line 1621: hr_utility.trace('lv_national_identifier is'||lv_national_identifier);

1617:
1618: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
1619: := lv_national_identifier ;
1620:
1621: hr_utility.trace('lv_national_identifier is'||lv_national_identifier);
1622:
1623: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5 := lv_pay_basis;
1624:
1625: hr_utility.trace('lv_pay_basis is'||lv_pay_basis);

Line 1625: hr_utility.trace('lv_pay_basis is'||lv_pay_basis);

1621: hr_utility.trace('lv_national_identifier is'||lv_national_identifier);
1622:
1623: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5 := lv_pay_basis;
1624:
1625: hr_utility.trace('lv_pay_basis is'||lv_pay_basis);
1626:
1627: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
1628: := lv_frequency_desc;
1629:

Line 1630: hr_utility.trace('lv_frequency_desc is'||lv_frequency_desc);

1626:
1627: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
1628: := lv_frequency_desc;
1629:
1630: hr_utility.trace('lv_frequency_desc is'||lv_frequency_desc);
1631:
1632: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
1633: := lv_grade;
1634:

Line 1635: hr_utility.trace('lv_grade is'||lv_grade);

1631:
1632: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
1633: := lv_grade;
1634:
1635: hr_utility.trace('lv_grade is'||lv_grade);
1636:
1637: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
1638: := lv_bargaining_unit;
1639:

Line 1640: hr_utility.trace('lv_bargaining_unit is'||lv_bargaining_unit);

1636:
1637: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
1638: := lv_bargaining_unit;
1639:
1640: hr_utility.trace('lv_bargaining_unit is'||lv_bargaining_unit);
1641: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
1642: := lv_collective_agreement;
1643:
1644: hr_utility.trace('lv_collective_agreement is'||lv_collective_agreement);

Line 1644: hr_utility.trace('lv_collective_agreement is'||lv_collective_agreement);

1640: hr_utility.trace('lv_bargaining_unit is'||lv_bargaining_unit);
1641: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
1642: := lv_collective_agreement;
1643:
1644: hr_utility.trace('lv_collective_agreement is'||lv_collective_agreement);
1645: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
1646: := lv_employee_number ;
1647:
1648: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11

Line 1693: hr_utility.set_location(gv_package || lv_procedure_name, 190);

1689: := fnd_number.number_to_canonical(ln_pay_annualization_factor) ;
1690: pay_emp_action_arch.lrr_act_tab(ln_index).act_info30
1691: := lv_location_code ;
1692:
1693: hr_utility.set_location(gv_package || lv_procedure_name, 190);
1694:
1695: /* Below Procedure is used to retrieve all the Organization (Or Business Group)
1696: Level Balances and Elements selected in "Payslip Information" Category and
1697: determine the corresponding values. Please note that as of now we are Archiving

Line 1712: hr_utility.set_location(gv_package || lv_procedure_name, 200);

1708: ,p_ppp_source_action_id => p_assignment_action_id
1709: ,p_ytd_balcall_aaid => p_assignment_action_id
1710: ) ;
1711:
1712: hr_utility.set_location(gv_package || lv_procedure_name, 200);
1713:
1714: pay_emp_action_arch.get_employee_addr (ln_person_id
1715: ,p_effective_date);
1716:

Line 1717: hr_utility.set_location(gv_package || lv_procedure_name, 210);

1713:
1714: pay_emp_action_arch.get_employee_addr (ln_person_id
1715: ,p_effective_date);
1716:
1717: hr_utility.set_location(gv_package || lv_procedure_name, 210);
1718:
1719: IF pay_emp_action_arch.lrr_act_tab.count > 0 THEN
1720:
1721: hr_utility.set_location(gv_package || lv_procedure_name, 220);

Line 1721: hr_utility.set_location(gv_package || lv_procedure_name, 220);

1717: hr_utility.set_location(gv_package || lv_procedure_name, 210);
1718:
1719: IF pay_emp_action_arch.lrr_act_tab.count > 0 THEN
1720:
1721: hr_utility.set_location(gv_package || lv_procedure_name, 220);
1722:
1723: pay_simulator_pkg.insert_simulation_rows(
1724: p_action_context_id => p_assignment_action_id
1725: ,p_action_context_type => 'AAP'

Line 1733: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);

1729: ,p_tab_rec_data => pay_emp_action_arch.lrr_act_tab
1730: );
1731: END IF;
1732:
1733: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);
1734:
1735: END get_personal_information;
1736:
1737: /* Procedure : populate_elements

Line 1837: hr_utility.trace('Entering '||gv_package||lv_procedure_name);

1833: lv_simulation_name VARCHAR2(200);
1834:
1835: BEGIN
1836:
1837: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
1838:
1839: IF pay_emp_action_arch.gv_multi_leg_rule IS NULL THEN
1840:
1841: hr_utility.set_location(gv_package || lv_procedure_name, 10);

Line 1841: hr_utility.set_location(gv_package || lv_procedure_name, 10);

1837: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
1838:
1839: IF pay_emp_action_arch.gv_multi_leg_rule IS NULL THEN
1840:
1841: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1842:
1843: pay_emp_action_arch.gv_multi_leg_rule
1844: := pay_emp_action_arch.get_multi_legislative_rule(
1845: p_legislation_code);

Line 1849: hr_utility.set_location(gv_package || lv_procedure_name, 20);

1845: p_legislation_code);
1846:
1847: END IF;
1848:
1849: hr_utility.set_location(gv_package || lv_procedure_name, 20);
1850:
1851: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
1852:
1853: hr_utility.set_location(gv_package || lv_procedure_name, 30);

Line 1853: hr_utility.set_location(gv_package || lv_procedure_name, 30);

1849: hr_utility.set_location(gv_package || lv_procedure_name, 20);
1850:
1851: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
1852:
1853: hr_utility.set_location(gv_package || lv_procedure_name, 30);
1854:
1855: IF p_jurisdiction_code <> '00-000-0000' THEN
1856:
1857: hr_utility.set_location(gv_package || lv_procedure_name, 40);

Line 1857: hr_utility.set_location(gv_package || lv_procedure_name, 40);

1853: hr_utility.set_location(gv_package || lv_procedure_name, 30);
1854:
1855: IF p_jurisdiction_code <> '00-000-0000' THEN
1856:
1857: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1858:
1859: pay_balance_pkg.set_context('JURISDICTION_CODE', p_jurisdiction_code);
1860: gv_ytd_balance_dimension := gv_dim_asg_jd_gre_ytd;
1861: gv_ptd_balance_dimension := gv_dim_asg_jd_gre_ptd;

Line 1865: hr_utility.set_location(gv_package || lv_procedure_name, 50);

1861: gv_ptd_balance_dimension := gv_dim_asg_jd_gre_ptd;
1862:
1863: ELSE
1864:
1865: hr_utility.set_location(gv_package || lv_procedure_name, 50);
1866:
1867: pay_balance_pkg.set_context('JURISDICTION_CODE', p_jurisdiction_code);
1868:
1869: IF gv_reporting_level = 'TAXGRP' THEN

Line 1871: hr_utility.set_location(gv_package || lv_procedure_name, 60);

1867: pay_balance_pkg.set_context('JURISDICTION_CODE', p_jurisdiction_code);
1868:
1869: IF gv_reporting_level = 'TAXGRP' THEN
1870:
1871: hr_utility.set_location(gv_package || lv_procedure_name, 60);
1872:
1873: gv_ytd_balance_dimension := gv_dim_asg_tg_ytd;
1874: /* Review Defined Balances are not present as of now for TG as needed*/
1875: gv_ptd_balance_dimension := gv_dim_asg_tg_ptd;

Line 1879: hr_utility.set_location(gv_package || lv_procedure_name, 70);

1875: gv_ptd_balance_dimension := gv_dim_asg_tg_ptd;
1876:
1877: ELSE
1878:
1879: hr_utility.set_location(gv_package || lv_procedure_name, 70);
1880:
1881: gv_ytd_balance_dimension := gv_dim_asg_gre_ytd;
1882: gv_ptd_balance_dimension := gv_dim_asg_gre_ptd;
1883:

Line 1888: hr_utility.set_location(gv_package || lv_procedure_name, 80);

1884: END IF;
1885:
1886: END IF;
1887:
1888: hr_utility.set_location(gv_package || lv_procedure_name, 80);
1889:
1890: /*Get YTD Defined Balance ID*/
1891:
1892: ln_ytd_defined_balance_id

Line 1898: hr_utility.set_location(gv_package || lv_procedure_name, 90);

1894: p_business_group_id,
1895: p_primary_balance_id,
1896: gv_ytd_balance_dimension);
1897:
1898: hr_utility.set_location(gv_package || lv_procedure_name, 90);
1899:
1900: ln_ptd_defined_balance_id
1901: := get_defined_balance_id(p_legislation_code,
1902: p_business_group_id,

Line 1908: hr_utility.set_location(gv_package || lv_procedure_name, 100);

1904: gv_ptd_balance_dimension);
1905:
1906: IF p_hours_balance_id IS NOT NULL THEN
1907:
1908: hr_utility.set_location(gv_package || lv_procedure_name, 100);
1909:
1910: ln_ytd_hours_balance_id
1911: := get_defined_balance_id(p_legislation_code,
1912: p_business_group_id,

Line 1916: hr_utility.set_location(gv_package || lv_procedure_name, 110);

1912: p_business_group_id,
1913: p_hours_balance_id,
1914: gv_ytd_balance_dimension);
1915:
1916: hr_utility.set_location(gv_package || lv_procedure_name, 110);
1917:
1918: ln_ptd_hours_balance_id
1919: := get_defined_balance_id(p_legislation_code,
1920: p_business_group_id,

Line 1926: hr_utility.set_location(gv_package || lv_procedure_name, 120);

1922: gv_ptd_balance_dimension);
1923:
1924: END IF;
1925:
1926: hr_utility.set_location(gv_package || lv_procedure_name, 120);
1927:
1928: /*Review
1929:
1930: if p_legislation_code <> 'US' THEN

Line 1931: hr_utility.set_location(gv_package || lv_procedure_name, 30);

1927:
1928: /*Review
1929:
1930: if p_legislation_code <> 'US' THEN
1931: hr_utility.set_location(gv_package || lv_procedure_name, 30);
1932: ln_step := 6;
1933: check_hours_by_rate(
1934: p_xfr_action_id => p_xfr_action_id
1935: ,p_puv_assignment_action_id => p_pymt_assignment_action_id

Line 1954: hr_utility.set_location(gv_package || lv_procedure_name, 130);

1950: */
1951:
1952: IF lv_rate_exists = 'N' THEN
1953:
1954: hr_utility.set_location(gv_package || lv_procedure_name, 130);
1955:
1956: IF ln_ytd_defined_balance_id IS NOT NULL THEN
1957:
1958: hr_utility.set_location(gv_package || lv_procedure_name, 140);

Line 1958: hr_utility.set_location(gv_package || lv_procedure_name, 140);

1954: hr_utility.set_location(gv_package || lv_procedure_name, 130);
1955:
1956: IF ln_ytd_defined_balance_id IS NOT NULL THEN
1957:
1958: hr_utility.set_location(gv_package || lv_procedure_name, 140);
1959:
1960: ln_ytd_amount := NVL(pay_balance_pkg.get_value(
1961: ln_ytd_defined_balance_id,
1962: p_ytd_balcall_aaid),0);

Line 1966: hr_utility.set_location(gv_package || lv_procedure_name, 150);

1962: p_ytd_balcall_aaid),0);
1963:
1964: END IF;
1965:
1966: hr_utility.set_location(gv_package || lv_procedure_name, 150);
1967:
1968: IF ln_ptd_defined_balance_id IS NOT NULL THEN
1969:
1970: hr_utility.set_location(gv_package || lv_procedure_name, 160);

Line 1970: hr_utility.set_location(gv_package || lv_procedure_name, 160);

1966: hr_utility.set_location(gv_package || lv_procedure_name, 150);
1967:
1968: IF ln_ptd_defined_balance_id IS NOT NULL THEN
1969:
1970: hr_utility.set_location(gv_package || lv_procedure_name, 160);
1971:
1972: ln_current_amount := NVL(pay_balance_pkg.get_value(
1973: ln_ptd_defined_balance_id,
1974: p_ytd_balcall_aaid),0);

Line 1995: hr_utility.set_location(gv_package || lv_procedure_name, 170);

1991: END IF;
1992:
1993: END IF;
1994:
1995: hr_utility.set_location(gv_package || lv_procedure_name, 170);
1996:
1997: IF p_hours_balance_id IS NOT NULL THEN
1998:
1999: hr_utility.set_location(gv_package || lv_procedure_name, 180);

Line 1999: hr_utility.set_location(gv_package || lv_procedure_name, 180);

1995: hr_utility.set_location(gv_package || lv_procedure_name, 170);
1996:
1997: IF p_hours_balance_id IS NOT NULL THEN
1998:
1999: hr_utility.set_location(gv_package || lv_procedure_name, 180);
2000:
2001: IF ln_ytd_hours_balance_id IS NOT NULL THEN
2002:
2003: hr_utility.set_location(gv_package || lv_procedure_name, 190);

Line 2003: hr_utility.set_location(gv_package || lv_procedure_name, 190);

1999: hr_utility.set_location(gv_package || lv_procedure_name, 180);
2000:
2001: IF ln_ytd_hours_balance_id IS NOT NULL THEN
2002:
2003: hr_utility.set_location(gv_package || lv_procedure_name, 190);
2004:
2005: ln_ytd_hours := NVL(pay_balance_pkg.get_value(
2006: ln_ytd_hours_balance_id,
2007: p_ytd_balcall_aaid),0);

Line 2011: hr_utility.set_location(gv_package || lv_procedure_name, 200);

2007: p_ytd_balcall_aaid),0);
2008:
2009: END IF;
2010:
2011: hr_utility.set_location(gv_package || lv_procedure_name, 200);
2012:
2013: IF ln_ptd_hours_balance_id IS NOT NULL THEN
2014:
2015: hr_utility.set_location(gv_package || lv_procedure_name, 210);

Line 2015: hr_utility.set_location(gv_package || lv_procedure_name, 210);

2011: hr_utility.set_location(gv_package || lv_procedure_name, 200);
2012:
2013: IF ln_ptd_hours_balance_id IS NOT NULL THEN
2014:
2015: hr_utility.set_location(gv_package || lv_procedure_name, 210);
2016:
2017: ln_current_hours := NVL(pay_balance_pkg.get_value(
2018: ln_ptd_hours_balance_id,
2019: p_ytd_balcall_aaid),0);

Line 2025: hr_utility.set_location(gv_package || lv_procedure_name, 220);

2021: END IF;
2022:
2023: END IF; /* p_hours_balance_id IS NOT NULL IF*/
2024:
2025: hr_utility.set_location(gv_package || lv_procedure_name, 220);
2026:
2027: IF NVL(ln_ytd_amount,0) <> 0 OR NVL(ln_ytd_hours,0) <> 0 OR
2028: NVL(ln_current_amount,0) <> 0 OR NVL(ln_current_hours,0) <> 0 THEN
2029:

Line 2030: hr_utility.set_location(gv_package || lv_procedure_name, 230);

2026:
2027: IF NVL(ln_ytd_amount,0) <> 0 OR NVL(ln_ytd_hours,0) <> 0 OR
2028: NVL(ln_current_amount,0) <> 0 OR NVL(ln_current_hours,0) <> 0 THEN
2029:
2030: hr_utility.set_location(gv_package || lv_procedure_name, 230);
2031:
2032: ln_index := pay_us_payslip_simulation_main.lrr_act_tab.count;
2033:
2034: IF p_element_classification_name in ('Earnings',

Line 2048: hr_utility.set_location(gv_package || lv_procedure_name, 240);

2044: := fnd_number.number_to_canonical(ln_current_hours);
2045:
2046: IF ln_current_hours <> 0 AND ln_current_amount <> 0 THEN
2047:
2048: hr_utility.set_location(gv_package || lv_procedure_name, 240);
2049:
2050: OPEN c_hoursbyrate(p_ytd_balcall_aaid,
2051: p_element_type_id,
2052: p_legislation_code);

Line 2067: hr_utility.set_location(gv_package || lv_procedure_name, 250);

2063:
2064: IF ROUND(ln_rate,5) <> round((ln_current_amount/ln_current_hours),5) OR ln_rate IS NULL
2065: THEN
2066:
2067: hr_utility.set_location(gv_package || lv_procedure_name, 250);
2068:
2069: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info22:=
2070: ROUND((ln_current_amount/ln_current_hours),5);
2071:

Line 2074: hr_utility.set_location(gv_package || lv_procedure_name, 260);

2070: ROUND((ln_current_amount/ln_current_hours),5);
2071:
2072: ELSE
2073:
2074: hr_utility.set_location(gv_package || lv_procedure_name, 260);
2075:
2076: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info22:=ln_rate;
2077:
2078: END IF;

Line 2082: hr_utility.set_location(gv_package || lv_procedure_name, 270);

2078: END IF;
2079:
2080: ELSE
2081:
2082: hr_utility.set_location(gv_package || lv_procedure_name, 270);
2083:
2084: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info22 := null;
2085:
2086: END IF;

Line 2167: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);

2163: END IF; /* NVL(ln_ytd_amount, 0) <> 0 OR NVL(ln_ytd_hours,0) <> 0 IF */
2164:
2165: END IF; /*lv_rate_exists = 'N' IF*/
2166:
2167: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);
2168:
2169: END populate_elements;
2170:
2171: /* Procedure : get_current_elements

Line 2463: hr_utility.trace('Entering '||gv_package||lv_procedure_name);

2459: lv_run_bal_status VARCHAR2(1) := 'N';
2460:
2461: BEGIN
2462:
2463: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
2464:
2465: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2466:
2467: /*Review

Line 2465: hr_utility.set_location(gv_package || lv_procedure_name, 10);

2461: BEGIN
2462:
2463: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
2464:
2465: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2466:
2467: /*Review
2468:
2469: IF p_legislation_code <> 'US' THEN

Line 2486: hr_utility.set_location(gv_package || lv_procedure_name, 20);

2482: END IF;
2483:
2484: */
2485:
2486: hr_utility.set_location(gv_package || lv_procedure_name, 20);
2487:
2488: lv_run_bal_status := NULL;
2489:
2490: lv_run_bal_status := pay_ac_action_arch.check_run_balance_status(

Line 2497: hr_utility.set_location(gv_package || lv_procedure_name, 30);

2493: ,p_legislation_code => p_legislation_code);
2494:
2495: IF lv_run_bal_status = 'Y' THEN
2496:
2497: hr_utility.set_location(gv_package || lv_procedure_name, 30);
2498:
2499: OPEN c_cur_action_elements_rb(p_source_action_id,
2500: p_assignment_id,
2501: p_business_group_id,

Line 2506: hr_utility.set_location(gv_package || lv_procedure_name, 40);

2502: p_legislation_code);
2503:
2504: ELSE
2505:
2506: hr_utility.set_location(gv_package || lv_procedure_name, 40);
2507:
2508: OPEN c_cur_action_elements_rr(p_source_action_id,
2509: p_assignment_id,
2510: p_legislation_code);

Line 2518: hr_utility.set_location(gv_package || lv_procedure_name, 50);

2514: LOOP /* Start of c_cur_action_elements_rb OR c_cur_action_elements_rr LOOP */
2515:
2516: IF lv_run_bal_status = 'Y' THEN
2517:
2518: hr_utility.set_location(gv_package || lv_procedure_name, 50);
2519:
2520: FETCH c_cur_action_elements_rb INTO
2521: ln_element_type_id,
2522: lv_element_classification_name,

Line 2530: hr_utility.set_location(gv_package || lv_procedure_name, 55);

2526: ln_hours_balance_id,
2527: ln_processing_priority;
2528:
2529: IF c_cur_action_elements_rb%NOTFOUND THEN
2530: hr_utility.set_location(gv_package || lv_procedure_name, 55);
2531: EXIT;
2532: END IF;
2533:
2534: ELSE

Line 2536: hr_utility.set_location(gv_package || lv_procedure_name, 60);

2532: END IF;
2533:
2534: ELSE
2535:
2536: hr_utility.set_location(gv_package || lv_procedure_name, 60);
2537:
2538: FETCH c_cur_action_elements_rr INTO
2539: ln_element_type_id,
2540: lv_element_classification_name,

Line 2548: hr_utility.set_location(gv_package || lv_procedure_name, 65);

2544: ln_hours_balance_id,
2545: ln_processing_priority;
2546:
2547: IF c_cur_action_elements_rr%NOTFOUND THEN
2548: hr_utility.set_location(gv_package || lv_procedure_name, 65);
2549: EXIT;
2550: END IF;
2551:
2552: END IF;

Line 2554: hr_utility.trace('Element Details fetched are : ');

2550: END IF;
2551:
2552: END IF;
2553:
2554: hr_utility.trace('Element Details fetched are : ');
2555: hr_utility.trace('Element Type ID : '||ln_element_type_id);
2556:
2557: /* Review
2558:

Line 2555: hr_utility.trace('Element Type ID : '||ln_element_type_id);

2551:
2552: END IF;
2553:
2554: hr_utility.trace('Element Details fetched are : ');
2555: hr_utility.trace('Element Type ID : '||ln_element_type_id);
2556:
2557: /* Review
2558:
2559: if p_legislation_code <> 'US' THEN

Line 2576: hr_utility.set_location(gv_package || lv_procedure_name, 70);

2572: */
2573:
2574: IF lv_element_classification_name <> 'Tax Deductions' THEN
2575:
2576: hr_utility.set_location(gv_package || lv_procedure_name, 70);
2577:
2578: OPEN c_get_wrkathome(p_assignment_id);
2579: FETCH c_get_wrkathome INTO lv_wrk_at_home
2580: ,ln_person_id

Line 2586: hr_utility.set_location(gv_package || lv_procedure_name, 80);

2582: CLOSE c_get_wrkathome;
2583:
2584: IF lv_wrk_at_home = 'Y' THEN
2585:
2586: hr_utility.set_location(gv_package || lv_procedure_name, 80);
2587:
2588: OPEN c_cur_home_state_jd(ln_person_id,
2589: ln_business_group_id,
2590: p_effective_date,

Line 2597: hr_utility.set_location(gv_package || lv_procedure_name, 90);

2593: CLOSE c_cur_home_state_jd;
2594:
2595: ELSE
2596:
2597: hr_utility.set_location(gv_package || lv_procedure_name, 90);
2598:
2599: OPEN get_element_entry_id(p_source_action_id,
2600: p_assignment_id,
2601: ln_element_type_id);

Line 2611: hr_utility.set_location(gv_package || lv_procedure_name, 100);

2607: CLOSE c_ele_entry_jd;
2608:
2609: IF l_ele_entry_jd IS NULL THEN
2610:
2611: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2612:
2613: OPEN c_work_loc_jd(p_assignment_id,p_effective_date);
2614: FETCH c_work_loc_jd INTO l_work_loc_jd;
2615: CLOSE c_work_loc_jd;

Line 2621: hr_utility.set_location(gv_package || lv_procedure_name, 110);

2617: lv_jurisdiction_flag := l_work_loc_jd;
2618:
2619: ELSE
2620:
2621: hr_utility.set_location(gv_package || lv_procedure_name, 110);
2622:
2623: lv_jurisdiction_flag := l_ele_entry_jd;
2624:
2625: END IF;

Line 2654: hr_utility.set_location(gv_package || lv_procedure_name, 120);

2650: := ln_hours_balance_id;
2651: pay_us_payslip_simulation_main.emp_elements_tab(ln_element_index).jurisdiction_code
2652: := lv_jurisdiction_code;
2653:
2654: hr_utility.set_location(gv_package || lv_procedure_name, 120);
2655:
2656: populate_elements(p_source_action_id => p_source_action_id
2657: ,p_effective_date => p_effective_date
2658: ,p_element_type_id => ln_element_type_id

Line 2673: hr_utility.set_location(gv_package || lv_procedure_name, 130);

2669: ,p_legislation_code => p_legislation_code
2670: ,p_el_jurisdiction_code => lv_jurisdiction_flag
2671: );
2672:
2673: hr_utility.set_location(gv_package || lv_procedure_name, 130);
2674:
2675: /*Clearing variables for Next Element */
2676:
2677: lv_element_classification_name := NULL;

Line 2704: hr_utility.trace('after populate_elements ftp' ||

2700:
2701: FOR i IN pay_us_payslip_simulation_main.lrr_act_tab.FIRST ..
2702: pay_us_payslip_simulation_main.lrr_act_tab.LAST LOOP
2703:
2704: hr_utility.trace('after populate_elements ftp' ||
2705: ' action_context_id is ' ||
2706: to_char(pay_us_payslip_simulation_main.lrr_act_tab(i).action_context_id));
2707: hr_utility.trace('action_info_category ' ||
2708: pay_us_payslip_simulation_main.lrr_act_tab(i).action_info_category);

Line 2707: hr_utility.trace('action_info_category ' ||

2703:
2704: hr_utility.trace('after populate_elements ftp' ||
2705: ' action_context_id is ' ||
2706: to_char(pay_us_payslip_simulation_main.lrr_act_tab(i).action_context_id));
2707: hr_utility.trace('action_info_category ' ||
2708: pay_us_payslip_simulation_main.lrr_act_tab(i).action_info_category);
2709: hr_utility.trace('act_info1 is ' ||
2710: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info1);
2711: hr_utility.trace('act_info10 ' ||

Line 2709: hr_utility.trace('act_info1 is ' ||

2705: ' action_context_id is ' ||
2706: to_char(pay_us_payslip_simulation_main.lrr_act_tab(i).action_context_id));
2707: hr_utility.trace('action_info_category ' ||
2708: pay_us_payslip_simulation_main.lrr_act_tab(i).action_info_category);
2709: hr_utility.trace('act_info1 is ' ||
2710: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info1);
2711: hr_utility.trace('act_info10 ' ||
2712: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info10);
2713: hr_utility.trace('act_info3 ' ||

Line 2711: hr_utility.trace('act_info10 ' ||

2707: hr_utility.trace('action_info_category ' ||
2708: pay_us_payslip_simulation_main.lrr_act_tab(i).action_info_category);
2709: hr_utility.trace('act_info1 is ' ||
2710: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info1);
2711: hr_utility.trace('act_info10 ' ||
2712: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info10);
2713: hr_utility.trace('act_info3 ' ||
2714: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info3);
2715: hr_utility.trace('act_info4 ' ||

Line 2713: hr_utility.trace('act_info3 ' ||

2709: hr_utility.trace('act_info1 is ' ||
2710: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info1);
2711: hr_utility.trace('act_info10 ' ||
2712: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info10);
2713: hr_utility.trace('act_info3 ' ||
2714: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info3);
2715: hr_utility.trace('act_info4 ' ||
2716: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info4);
2717: hr_utility.trace('act_info5 ' ||

Line 2715: hr_utility.trace('act_info4 ' ||

2711: hr_utility.trace('act_info10 ' ||
2712: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info10);
2713: hr_utility.trace('act_info3 ' ||
2714: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info3);
2715: hr_utility.trace('act_info4 ' ||
2716: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info4);
2717: hr_utility.trace('act_info5 ' ||
2718: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info5);
2719: hr_utility.trace('act_info6 ' ||

Line 2717: hr_utility.trace('act_info5 ' ||

2713: hr_utility.trace('act_info3 ' ||
2714: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info3);
2715: hr_utility.trace('act_info4 ' ||
2716: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info4);
2717: hr_utility.trace('act_info5 ' ||
2718: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info5);
2719: hr_utility.trace('act_info6 ' ||
2720: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info6);
2721: hr_utility.trace('act_info7 ' ||

Line 2719: hr_utility.trace('act_info6 ' ||

2715: hr_utility.trace('act_info4 ' ||
2716: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info4);
2717: hr_utility.trace('act_info5 ' ||
2718: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info5);
2719: hr_utility.trace('act_info6 ' ||
2720: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info6);
2721: hr_utility.trace('act_info7 ' ||
2722: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info7);
2723: hr_utility.trace('act_info8 ' ||

Line 2721: hr_utility.trace('act_info7 ' ||

2717: hr_utility.trace('act_info5 ' ||
2718: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info5);
2719: hr_utility.trace('act_info6 ' ||
2720: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info6);
2721: hr_utility.trace('act_info7 ' ||
2722: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info7);
2723: hr_utility.trace('act_info8 ' ||
2724: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8);
2725:

Line 2723: hr_utility.trace('act_info8 ' ||

2719: hr_utility.trace('act_info6 ' ||
2720: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info6);
2721: hr_utility.trace('act_info7 ' ||
2722: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info7);
2723: hr_utility.trace('act_info8 ' ||
2724: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8);
2725:
2726: END LOOP;
2727:

Line 2730: hr_utility.set_location(gv_package || lv_procedure_name, 140);

2726: END LOOP;
2727:
2728: END IF;
2729:
2730: hr_utility.set_location(gv_package || lv_procedure_name, 140);
2731:
2732: IF pay_us_payslip_simulation_main.emp_elements_tab.count > 0 THEN
2733:
2734: hr_utility.set_location(gv_package || lv_procedure_name, 150);

Line 2734: hr_utility.set_location(gv_package || lv_procedure_name, 150);

2730: hr_utility.set_location(gv_package || lv_procedure_name, 140);
2731:
2732: IF pay_us_payslip_simulation_main.emp_elements_tab.count > 0 THEN
2733:
2734: hr_utility.set_location(gv_package || lv_procedure_name, 150);
2735:
2736: FOR j in pay_us_payslip_simulation_main.emp_elements_tab.FIRST ..
2737: pay_us_payslip_simulation_main.emp_elements_tab.LAST LOOP
2738:

Line 2739: hr_utility.trace('emp_elements_tab.element_type ' ||

2735:
2736: FOR j in pay_us_payslip_simulation_main.emp_elements_tab.FIRST ..
2737: pay_us_payslip_simulation_main.emp_elements_tab.LAST LOOP
2738:
2739: hr_utility.trace('emp_elements_tab.element_type ' ||
2740: to_char(pay_us_payslip_simulation_main.emp_elements_tab(j).element_type_id));
2741:
2742: END LOOP;
2743:

Line 2746: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);

2742: END LOOP;
2743:
2744: END IF;
2745:
2746: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);
2747:
2748: END get_current_elements;
2749:
2750: PROCEDURE populate_emp_hours_by_rate(p_assignment_action_id NUMBER

Line 2791: hr_utility.trace('Entering '||gv_package||lv_procedure_name);

2787: ln_index NUMBER;
2788:
2789: BEGIN
2790:
2791: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
2792:
2793: ln_rate := 0;
2794: ln_hours := 0;
2795: ln_multiple := 1;

Line 2800: hr_utility.set_location(gv_package || lv_procedure_name, 10);

2796:
2797: OPEN c_hoursbyrate(p_ytd_balcall_aaid);
2798: LOOP
2799:
2800: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2801:
2802: FETCH c_hoursbyrate INTO ln_element_type_id
2803: ,lv_element_name
2804: ,lv_processing_priority

Line 2812: hr_utility.set_location(gv_package || lv_procedure_name, 15);

2808: ,ln_amount;
2809:
2810: IF c_hoursbyrate%NOTFOUND THEN
2811:
2812: hr_utility.set_location(gv_package || lv_procedure_name, 15);
2813: EXIT;
2814:
2815: END IF;
2816:

Line 2828: hr_utility.set_location(gv_package || lv_procedure_name, 20);

2824: END IF;
2825:
2826: CLOSE get_simulation_name;
2827:
2828: hr_utility.set_location(gv_package || lv_procedure_name, 20);
2829:
2830: ln_index := pay_ac_action_arch.lrr_act_tab.count;
2831:
2832: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category

Line 2855: hr_utility.set_location(gv_package || lv_procedure_name, 30);

2851: := fnd_number.number_to_canonical(ln_multiple);
2852: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
2853: := fnd_number.number_to_canonical(ln_amount);
2854:
2855: hr_utility.set_location(gv_package || lv_procedure_name, 30);
2856:
2857: END LOOP;
2858:
2859: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);

Line 2859: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);

2855: hr_utility.set_location(gv_package || lv_procedure_name, 30);
2856:
2857: END LOOP;
2858:
2859: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);
2860:
2861: END populate_emp_hours_by_rate;
2862:
2863: PROCEDURE populate_summary(p_assignment_action_id NUMBER,

Line 2958: hr_utility.trace('Entering '||gv_package||lv_procedure_name);

2954: j NUMBER := 0;
2955:
2956: BEGIN
2957:
2958: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
2959:
2960: IF pay_us_payslip_simulation_main.lrr_act_tab.count > 0 THEN
2961:
2962: hr_utility.set_location(gv_package || lv_procedure_name, 10);

Line 2962: hr_utility.set_location(gv_package || lv_procedure_name, 10);

2958: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
2959:
2960: IF pay_us_payslip_simulation_main.lrr_act_tab.count > 0 THEN
2961:
2962: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2963:
2964: FOR i in pay_us_payslip_simulation_main.lrr_act_tab.FIRST ..
2965: pay_us_payslip_simulation_main.lrr_act_tab.LAST LOOP
2966:

Line 3083: hr_utility.set_location(gv_package || lv_procedure_name, 20);

3079: END LOOP;
3080:
3081: END IF; /* pay_us_payslip_simulation_main.lrr_act_tab.count > 0 IF */
3082:
3083: hr_utility.set_location(gv_package || lv_procedure_name, 20);
3084:
3085: j := 0;
3086:
3087: IF pay_us_payslip_simulation_main.ltr_summary_labels.count > 0 THEN

Line 3113: hr_utility.trace('ln_index = ' || ln_index);

3109:
3110: /* CURRENT Values */
3111:
3112: ln_index := pay_us_payslip_simulation_main.lrr_act_tab.count;
3113: hr_utility.trace('ln_index = ' || ln_index);
3114: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).action_info_category
3115: := 'AC SUMMARY CURRENT';
3116: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).jurisdiction_code
3117: := '00-000-0000';

Line 3202: hr_utility.trace('ln_index = ' || ln_index);

3198:
3199: /* Archive Estimated Values for Summary */
3200:
3201: ln_index := pay_us_payslip_simulation_main.lrr_act_tab.count;
3202: hr_utility.trace('ln_index = ' || ln_index);
3203: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).action_info_category
3204: := 'AC SIM GRAPH ESTIMATED';
3205: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).jurisdiction_code
3206: := '00-000-0000';

Line 3266: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);

3262: - fnd_number.canonical_to_number(lv_prev_tax_deductions)
3263: + fnd_number.canonical_to_number(lv_prev_alien_expat_earnings)
3264: + fnd_number.canonical_to_number(lv_prev_non_payroll_payments));
3265:
3266: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);
3267:
3268: END populate_summary;
3269:
3270: PROCEDURE process_actions(p_payroll_action_id NUMBER

Line 3319: hr_utility.trace('Entering '||gv_package||lv_procedure_name);

3315: ld_run_date_earned DATE;
3316:
3317: BEGIN
3318:
3319: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
3320: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3321:
3322: pay_balance_pkg.set_context('TAX_UNIT_ID', p_tax_unit_id);
3323:

Line 3320: hr_utility.set_location(gv_package || lv_procedure_name, 10);

3316:
3317: BEGIN
3318:
3319: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
3320: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3321:
3322: pay_balance_pkg.set_context('TAX_UNIT_ID', p_tax_unit_id);
3323:
3324: OPEN c_get_ytd_aaid(p_source_action_id,

Line 3335: hr_utility.set_location(gv_package || lv_procedure_name, 20);

3331: FETCH c_time_period INTO ln_time_period_id,
3332: ld_run_date_earned;
3333: CLOSE c_time_period;
3334:
3335: hr_utility.set_location(gv_package || lv_procedure_name, 20);
3336:
3337: initialization_process(p_legislation_code,p_payroll_action_id);
3338:
3339: hr_utility.set_location(gv_package || lv_procedure_name, 30);

Line 3339: hr_utility.set_location(gv_package || lv_procedure_name, 30);

3335: hr_utility.set_location(gv_package || lv_procedure_name, 20);
3336:
3337: initialization_process(p_legislation_code,p_payroll_action_id);
3338:
3339: hr_utility.set_location(gv_package || lv_procedure_name, 30);
3340:
3341: hr_utility.set_location(gv_package || lv_procedure_name, 100);
3342:
3343: IF p_archive_balance_info = 'Y' THEN

Line 3341: hr_utility.set_location(gv_package || lv_procedure_name, 100);

3337: initialization_process(p_legislation_code,p_payroll_action_id);
3338:
3339: hr_utility.set_location(gv_package || lv_procedure_name, 30);
3340:
3341: hr_utility.set_location(gv_package || lv_procedure_name, 100);
3342:
3343: IF p_archive_balance_info = 'Y' THEN
3344:
3345: get_current_elements(

Line 3357: hr_utility.set_location(gv_package || lv_procedure_name, 120);

3353: );
3354:
3355: END IF;
3356:
3357: hr_utility.set_location(gv_package || lv_procedure_name, 120);
3358:
3359: /*Determine the Employee Resident Jurisdiction Code*/
3360: /*This is necessary to determine Employee Withholding Information*/
3361:

Line 3406: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);

3402: ,p_effective_date => p_effective_date
3403: ,p_tab_rec_data => pay_ac_action_arch.lrr_act_tab
3404: );
3405:
3406: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);
3407:
3408: END process_actions;
3409:
3410: PROCEDURE archive_action_information(p_payroll_action_id NUMBER,

Line 3488: hr_utility.trace('Entering '||gv_package||lv_procedure_name);

3484: ln_tax_unit_id per_all_assignments_f.organization_id%TYPE;
3485:
3486: BEGIN
3487:
3488: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
3489:
3490: OPEN c_get_organization(p_payroll_id,
3491: p_assignment_id,
3492: p_effective_date);

Line 3545: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);

3541: );
3542:
3543: END IF;
3544:
3545: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);
3546:
3547: END archive_payroll_level_data;
3548:
3549: /* Procedure : archive_data

Line 3648: hr_utility.trace('Entering '||gv_package||lv_procedure_name);

3644: lv_archive_balance_info VARCHAR2(2);
3645:
3646: BEGIN
3647:
3648: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
3649:
3650: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3651:
3652: /*Get Action related Information*/

Line 3650: hr_utility.set_location(gv_package || lv_procedure_name, 10);

3646: BEGIN
3647:
3648: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
3649:
3650: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3651:
3652: /*Get Action related Information*/
3653:
3654: OPEN c_get_action_info(p_source_action_id);

Line 3698: hr_utility.set_location(gv_package || lv_procedure_name, 20);

3694: NULL;
3695:
3696: END IF;
3697:
3698: hr_utility.set_location(gv_package || lv_procedure_name, 20);
3699:
3700: /*Retrieve the Assignment related information*/
3701:
3702: OPEN c_get_assignment_actions(p_source_action_id);

Line 3803: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);

3799: END IF;
3800:
3801: /*End of Payroll Action Level Data archiving */
3802:
3803: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);
3804:
3805: END archive_data;
3806:
3807: PROCEDURE build_sql(

Line 3818: hr_utility.trace ('Entering '||gv_package||lv_procedure_name);

3814: lv_procedure_name varchar2(100) := '.build_sql';
3815:
3816: BEGIN
3817:
3818: hr_utility.trace ('Entering '||gv_package||lv_procedure_name);
3819:
3820: p_sqlstr_tab(p_cntr) := p_string;
3821: p_cntr := p_cntr + 1;
3822:

Line 3823: hr_utility.trace ('Leaving '||gv_package||lv_procedure_name);

3819:
3820: p_sqlstr_tab(p_cntr) := p_string;
3821: p_cntr := p_cntr + 1;
3822:
3823: hr_utility.trace ('Leaving '||gv_package||lv_procedure_name);
3824:
3825: END build_sql;
3826:
3827: PROCEDURE print_blob(p_blob BLOB)

Line 3869: hr_utility.trace ('Entering '||gv_package||lv_procedure_name);

3865: BEGIN
3866:
3867: lv_procedure_name := '.flex_seg_enabled';
3868:
3869: hr_utility.trace ('Entering '||gv_package||lv_procedure_name);
3870:
3871: OPEN csr_seg_enabled;
3872: FETCH csr_seg_enabled INTO l_exists;
3873: CLOSE csr_seg_enabled;

Line 3875: hr_utility.trace ('Leaving '||gv_package||lv_procedure_name);

3871: OPEN csr_seg_enabled;
3872: FETCH csr_seg_enabled INTO l_exists;
3873: CLOSE csr_seg_enabled;
3874:
3875: hr_utility.trace ('Leaving '||gv_package||lv_procedure_name);
3876:
3877: IF l_exists = 'Y' THEN
3878: RETURN (TRUE);
3879: ELSE

Line 3932: hr_utility.trace('Entering '||gv_package||lv_procedure_name);

3928: BEGIN
3929:
3930: lv_procedure_name := '.simulation_generate';
3931:
3932: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
3933:
3934: hr_utility.trace('Parameters ....');
3935: hr_utility.trace('P_ACTION_INFORMATION_ID ='||P_ACTION_INFORMATION_ID);
3936: hr_utility.trace('P_ACTION_CONTEXT_ID ='||P_ACTION_CONTEXT_ID);

Line 3934: hr_utility.trace('Parameters ....');

3930: lv_procedure_name := '.simulation_generate';
3931:
3932: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
3933:
3934: hr_utility.trace('Parameters ....');
3935: hr_utility.trace('P_ACTION_INFORMATION_ID ='||P_ACTION_INFORMATION_ID);
3936: hr_utility.trace('P_ACTION_CONTEXT_ID ='||P_ACTION_CONTEXT_ID);
3937:
3938: IF p_generate_header_flag = 'Y' THEN

Line 3935: hr_utility.trace('P_ACTION_INFORMATION_ID ='||P_ACTION_INFORMATION_ID);

3931:
3932: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
3933:
3934: hr_utility.trace('Parameters ....');
3935: hr_utility.trace('P_ACTION_INFORMATION_ID ='||P_ACTION_INFORMATION_ID);
3936: hr_utility.trace('P_ACTION_CONTEXT_ID ='||P_ACTION_CONTEXT_ID);
3937:
3938: IF p_generate_header_flag = 'Y' THEN
3939: hr_utility.trace ('P_GENERATE_HEADER_FLAG = TRUE');

Line 3936: hr_utility.trace('P_ACTION_CONTEXT_ID ='||P_ACTION_CONTEXT_ID);

3932: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
3933:
3934: hr_utility.trace('Parameters ....');
3935: hr_utility.trace('P_ACTION_INFORMATION_ID ='||P_ACTION_INFORMATION_ID);
3936: hr_utility.trace('P_ACTION_CONTEXT_ID ='||P_ACTION_CONTEXT_ID);
3937:
3938: IF p_generate_header_flag = 'Y' THEN
3939: hr_utility.trace ('P_GENERATE_HEADER_FLAG = TRUE');
3940: ELSE

Line 3939: hr_utility.trace ('P_GENERATE_HEADER_FLAG = TRUE');

3935: hr_utility.trace('P_ACTION_INFORMATION_ID ='||P_ACTION_INFORMATION_ID);
3936: hr_utility.trace('P_ACTION_CONTEXT_ID ='||P_ACTION_CONTEXT_ID);
3937:
3938: IF p_generate_header_flag = 'Y' THEN
3939: hr_utility.trace ('P_GENERATE_HEADER_FLAG = TRUE');
3940: ELSE
3941: hr_utility.trace ('P_GENERATE_HEADER_FLAG = FALSE');
3942: END IF;
3943:

Line 3941: hr_utility.trace ('P_GENERATE_HEADER_FLAG = FALSE');

3937:
3938: IF p_generate_header_flag = 'Y' THEN
3939: hr_utility.trace ('P_GENERATE_HEADER_FLAG = TRUE');
3940: ELSE
3941: hr_utility.trace ('P_GENERATE_HEADER_FLAG = FALSE');
3942: END IF;
3943:
3944: hr_utility.trace ('P_CUSTOM_ACTION_INFO_CAT ='||P_CUSTOM_ACTION_INFO_CAT);
3945:

Line 3944: hr_utility.trace ('P_CUSTOM_ACTION_INFO_CAT ='||P_CUSTOM_ACTION_INFO_CAT);

3940: ELSE
3941: hr_utility.trace ('P_GENERATE_HEADER_FLAG = FALSE');
3942: END IF;
3943:
3944: hr_utility.trace ('P_CUSTOM_ACTION_INFO_CAT ='||P_CUSTOM_ACTION_INFO_CAT);
3945:
3946: pay_payroll_xml_extract_pkg.g_xml_table.delete();
3947: l_flex_col_num := 30;
3948: l_kff_seg_start := 5;

Line 4087: hr_utility.trace('Entering employee net pay '||g_install_leg_check);

4083: IF csr_get_archived_regions_rec.action_information_category =
4084: 'EMPLOYEE NET PAY DISTRIBUTION'
4085: AND g_install_leg_check = 'N' THEN
4086:
4087: hr_utility.trace('Entering employee net pay '||g_install_leg_check);
4088:
4089: build_sql(sqlstr,l_cntr_sql,
4090: 'csr_get_sim_arch_info_rec.action_information4 :=
4091: pay_ip_utility.get_check_number(csr_get_sim_arch_info_rec.action_information17

Line 4411: hr_utility.trace(sqlstr(cntr));

4407: l_cntr_sql,
4408: 'end;');
4409:
4410: FOR cntr IN sqlstr.first()..sqlstr.last() LOOP
4411: hr_utility.trace(sqlstr(cntr));
4412: END LOOP;
4413:
4414: csr := dbms_sql.open_cursor;
4415: dbms_sql.parse (csr,

Line 4440: hr_utility.trace (pay_payroll_xml_extract_pkg.g_xml_table(cntr));

4436: dbms_lob.writeAppend(l_xml,
4437: ln_amt,
4438: lr_xml);
4439:
4440: hr_utility.trace (pay_payroll_xml_extract_pkg.g_xml_table(cntr));
4441: END LOOP;
4442: p_xml := l_xml;
4443: dbms_lob.freeTemporary(l_xml);
4444: END IF;

Line 4452: hr_utility.trace ('Leaving '||gv_package||lv_procedure_name);

4448: -- Unset globals before exit;
4449: pay_payroll_xml_extract_pkg.g_xml_table.delete();
4450: g_custom_context := NULL;
4451:
4452: hr_utility.trace ('Leaving '||gv_package||lv_procedure_name);
4453:
4454: END simulation_generate;
4455:
4456:

Line 4499: hr_utility.trace('Entering '||gv_package||lv_procedure_name);

4495: ln_assignment_action_id NUMBER;
4496:
4497: BEGIN
4498:
4499: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
4500:
4501: OPEN get_asg_action(p_assignment_id);
4502: FETCH get_asg_action INTO ln_assignment_action_id;
4503: CLOSE get_asg_action;

Line 4512: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);

4508: ,p_root_tag => 'PAYSLIP'
4509: ,p_document_type => 'PAYSLIP'
4510: ,p_xml => p_xml);
4511:
4512: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);
4513:
4514: END generate_xml;
4515:
4516: /* Procedure : pre_processing

Line 4645: hr_utility.trace('Entering '||gv_package||lv_procedure_name);

4641: ln_exclusion_set_id pay_element_sets.element_set_id%TYPE := NULL;
4642:
4643: BEGIN
4644:
4645: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
4646:
4647: IF p_effective_date IS NULL THEN
4648:
4649: OPEN get_effective_date;

Line 4911: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);

4907: OR pel.people_group_id IS NULL
4908: )
4909: );
4910:
4911: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);
4912:
4913: END pre_processing;
4914:
4915: END pay_us_payslip_simulation_main;