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

Line 361: raise hr_utility.hr_error;

357: open csr_defined_balance;
358: fetch csr_defined_balance into l_defined_balance_id;
359: if csr_defined_balance%notfound then
360: close csr_defined_balance;
361: raise hr_utility.hr_error;
362: else
363: close csr_defined_balance;
364: end if;
365:

Line 512: hr_utility.set_location ('State',1);

508:
509: else
510:
511: /* Default settings for State Quarterly Wage Listing. */
512: hr_utility.set_location ('State',1);
513: p_period_start := p_quarter_start;
514: p_period_end := p_quarter_end;
515: IF p_report_type = 'SMWL' THEN /*bug 14456648*/
516: p_defined_balance_id := bal_db_item('SUI_ER_SUBJ_WHABLE_PER_JD_GRE_MONTH');

Line 525: hr_utility.set_location ('p_period_start -> '|| p_period_start,1);

521: p_group_by_medicare := TRUE;
522: p_tax_unit_context := TRUE;
523: p_jurisdiction_context := TRUE;
524:
525: hr_utility.set_location ('p_period_start -> '|| p_period_start,1);
526: hr_utility.set_location ('p_period_end -> '|| p_period_end,1);
527: hr_utility.set_location ('p_defined_balance -> SUI_ER_SUBJ_WHABLE_PER_JD_GRE_QTD',1);
528: hr_utility.set_location ('p_defined_balance_id -> '|| p_defined_balance_id,1);
529:

Line 526: hr_utility.set_location ('p_period_end -> '|| p_period_end,1);

522: p_tax_unit_context := TRUE;
523: p_jurisdiction_context := TRUE;
524:
525: hr_utility.set_location ('p_period_start -> '|| p_period_start,1);
526: hr_utility.set_location ('p_period_end -> '|| p_period_end,1);
527: hr_utility.set_location ('p_defined_balance -> SUI_ER_SUBJ_WHABLE_PER_JD_GRE_QTD',1);
528: hr_utility.set_location ('p_defined_balance_id -> '|| p_defined_balance_id,1);
529:
530: end if;

Line 527: hr_utility.set_location ('p_defined_balance -> SUI_ER_SUBJ_WHABLE_PER_JD_GRE_QTD',1);

523: p_jurisdiction_context := TRUE;
524:
525: hr_utility.set_location ('p_period_start -> '|| p_period_start,1);
526: hr_utility.set_location ('p_period_end -> '|| p_period_end,1);
527: hr_utility.set_location ('p_defined_balance -> SUI_ER_SUBJ_WHABLE_PER_JD_GRE_QTD',1);
528: hr_utility.set_location ('p_defined_balance_id -> '|| p_defined_balance_id,1);
529:
530: end if;
531:

Line 528: hr_utility.set_location ('p_defined_balance_id -> '|| p_defined_balance_id,1);

524:
525: hr_utility.set_location ('p_period_start -> '|| p_period_start,1);
526: hr_utility.set_location ('p_period_end -> '|| p_period_end,1);
527: hr_utility.set_location ('p_defined_balance -> SUI_ER_SUBJ_WHABLE_PER_JD_GRE_QTD',1);
528: hr_utility.set_location ('p_defined_balance_id -> '|| p_defined_balance_id,1);
529:
530: end if;
531:
532: else /* An invalid report type has been passed so fail. */

Line 534: raise hr_utility.hr_error;

530: end if;
531:
532: else /* An invalid report type has been passed so fail. */
533:
534: raise hr_utility.hr_error;
535:
536: end if;
537:
538: end get_selection_information;

Line 568: raise hr_utility.hr_error;

564: open csr_jurisdiction_code;
565: fetch csr_jurisdiction_code into l_jurisdiction_code;
566: if csr_jurisdiction_code%notfound then
567: close csr_jurisdiction_code;
568: raise hr_utility.hr_error;
569: else
570: close csr_jurisdiction_code;
571: end if;
572:

Line 622: hr_utility.trace('l_resides_true =' || l_resides_true);

618: EXCEPTION when no_data_found then
619: l_resides_true := '0';
620: END;
621:
622: hr_utility.trace('l_resides_true =' || l_resides_true);
623:
624: IF (l_resides_true = '1' AND
625: pay_balance_pkg.get_value(bal_db_item('GROSS_EARNINGS_PER_GRE_QTD'),
626: p_assignment_id, least(p_period_end, p_effective_end_date)) <> 0) THEN

Line 628: hr_utility.trace('Returning TRUE from check_residence_state');

624: IF (l_resides_true = '1' AND
625: pay_balance_pkg.get_value(bal_db_item('GROSS_EARNINGS_PER_GRE_QTD'),
626: p_assignment_id, least(p_period_end, p_effective_end_date)) <> 0) THEN
627:
628: hr_utility.trace('Returning TRUE from check_residence_state');
629:
630: RETURN TRUE;
631: ELSE
632: RETURN FALSE;

Line 732: hr_utility.trace('Error while getting the user_entity_id'

728: return l_user_entity_id;
729:
730: exception
731: when others then
732: hr_utility.trace('Error while getting the user_entity_id'
733: || to_char(sqlcode));
734: raise hr_utility.hr_error;
735:
736: end get_user_entity_id;

Line 734: raise hr_utility.hr_error;

730: exception
731: when others then
732: hr_utility.trace('Error while getting the user_entity_id'
733: || to_char(sqlcode));
734: raise hr_utility.hr_error;
735:
736: end get_user_entity_id;
737:
738: /* Name : action_creation

Line 1176: hr_utility.trace('Entered action creation');

1172:
1173:
1174: --
1175: begin
1176: hr_utility.trace('Entered action creation');
1177:
1178: /* added initalization for l_prev_tax_unit_id */
1179:
1180: l_prev_tax_unit_id := -99999999;

Line 1200: hr_utility.set_location ('actio_creation',1);

1196: from pay_payroll_actions
1197: where payroll_action_id = pactid;
1198:
1199:
1200: hr_utility.set_location ('actio_creation',1);
1201: --
1202: get_dates(l_report_type,
1203: l_effective_date,
1204: l_period_end,

Line 1210: hr_utility.set_location ('actio_creation',2);

1206: l_quarter_end,
1207: l_year_start,
1208: l_year_end);
1209:
1210: hr_utility.set_location ('actio_creation',2);
1211: --
1212: get_selection_information
1213: (l_report_type,
1214: l_state,

Line 1227: hr_utility.set_location ('actio_creation',3);

1223: l_group_by_medicare,
1224: l_tax_unit_context,
1225: l_jurisdiction_context);
1226:
1227: hr_utility.set_location ('actio_creation',3);
1228:
1229: --
1230: -- Get the jurisdiction code for the state if appropriate.
1231: --

Line 1292: hr_utility.set_location ('actio_creation',4);

1288: --
1289:
1290: LOOP
1291: if (l_state = 'LA' and l_report_cat = 'RTLAQ') then
1292: hr_utility.set_location ('actio_creation',4);
1293: if l_person_on then
1294: FETCH c_state_la_quality_person_on INTO l_person_id,
1295: l_assignment_id,
1296: l_tax_unit_id,

Line 1308: hr_utility.set_location ('actio_creation',4);

1304: EXIT WHEN c_state_la_quality%NOTFOUND;
1305: end if ;
1306:
1307: elsif (l_state = 'CT' and l_report_cat = 'RTCTN') then
1308: hr_utility.set_location ('actio_creation',4);
1309: if l_person_on then
1310: FETCH c_ct_non_profit_person_on INTO l_person_id,
1311: l_assignment_id,
1312: l_tax_unit_id,

Line 1324: hr_utility.set_location ('actio_creation',4);

1320: EXIT WHEN c_ct_non_profit%NOTFOUND;
1321: end if ;
1322:
1323: elsif (l_state = 'PR') THEN
1324: hr_utility.set_location ('actio_creation',4);
1325: if l_person_on then
1326: FETCH c_state_pr_person_on INTO l_person_id,
1327: l_assignment_id,
1328: l_tax_unit_id,

Line 1340: hr_utility.set_location ('actio_creation',5);

1336: EXIT WHEN c_state_pr%NOTFOUND;
1337: end if ;
1338:
1339: else
1340: hr_utility.set_location ('actio_creation',5);
1341: -- If it is on then fetch from c_state_person_on cursor else c_state
1342: if l_person_on then
1343: FETCH c_state_person_on INTO l_person_id,
1344: l_assignment_id,

Line 1380: hr_utility.set_location ('actio_creation',6);

1376: -- If the balance is non zero then an assignment action is created to
1377: -- indicate their inclusion in the magnetic tape report.
1378: --
1379: else
1380: hr_utility.set_location ('actio_creation',6);
1381: --
1382: -- Set up contexts required to test the balance.
1383: --
1384: -- Set up TAX_UNIT_ID context if appropriate.

Line 1444: hr_utility.trace('Entered NY Checking ');

1440:
1441:
1442: if (l_value = 0 AND l_state = 'NY') then /*Check for NY Bug:2922028*/
1443:
1444: hr_utility.trace('Entered NY Checking ');
1445:
1446: if instr(to_char(l_quarter_end,'MM'), '12') <> 0 then /*Check for Last Quarter*/
1447:
1448: hr_utility.trace('Last Quarter.Check the values for SIT_SUBJ_NWHABLE_PER_JD_GRE_YTD');

Line 1448: hr_utility.trace('Last Quarter.Check the values for SIT_SUBJ_NWHABLE_PER_JD_GRE_YTD');

1444: hr_utility.trace('Entered NY Checking ');
1445:
1446: if instr(to_char(l_quarter_end,'MM'), '12') <> 0 then /*Check for Last Quarter*/
1447:
1448: hr_utility.trace('Last Quarter.Check the values for SIT_SUBJ_NWHABLE_PER_JD_GRE_YTD');
1449:
1450: l_value := pay_balance_pkg.get_value
1451: (bal_db_item('SIT_SUBJ_NWHABLE_PER_JD_GRE_YTD'),
1452: l_assignment_id,

Line 1455: hr_utility.trace('Value of SIT_SUBJ_NWHABLE_PER_JD_GRE_YTD = '||l_value);

1451: (bal_db_item('SIT_SUBJ_NWHABLE_PER_JD_GRE_YTD'),
1452: l_assignment_id,
1453: least(l_period_end,l_effective_end_date));
1454:
1455: hr_utility.trace('Value of SIT_SUBJ_NWHABLE_PER_JD_GRE_YTD = '||l_value);
1456:
1457: if l_value = 0 then /*Check for SUBJ_WHABLE*/
1458:
1459: hr_utility.trace('Value of SIT_SUBJ_NWHABLE_PER_JD_GRE_YTD is 0');

Line 1459: hr_utility.trace('Value of SIT_SUBJ_NWHABLE_PER_JD_GRE_YTD is 0');

1455: hr_utility.trace('Value of SIT_SUBJ_NWHABLE_PER_JD_GRE_YTD = '||l_value);
1456:
1457: if l_value = 0 then /*Check for SUBJ_WHABLE*/
1458:
1459: hr_utility.trace('Value of SIT_SUBJ_NWHABLE_PER_JD_GRE_YTD is 0');
1460:
1461: If l_effective_end_date < l_quarter_start THEN /*l_effective_end_date checking */
1462: /*Bug:3281209*/
1463:

Line 1464: hr_utility.trace('l_effective_end_date < l_quarter_start');

1460:
1461: If l_effective_end_date < l_quarter_start THEN /*l_effective_end_date checking */
1462: /*Bug:3281209*/
1463:
1464: hr_utility.trace('l_effective_end_date < l_quarter_start');
1465: l_value := 0;
1466:
1467: ELSE
1468:

Line 1474: hr_utility.trace('Value of SUI_ER_SUBJ_WHABLE_PER = '||l_value);

1470: (bal_db_item('SUI_ER_SUBJ_WHABLE_PER_JD_GRE_QTD'),
1471: l_assignment_id,
1472: least(l_period_end,l_effective_end_date));
1473:
1474: hr_utility.trace('Value of SUI_ER_SUBJ_WHABLE_PER = '||l_value);
1475:
1476: End if; /*l_effective_end_date checking */
1477:
1478: end if; /*Check for SUBJ_WHABLE*/

Line 1488: hr_utility.trace('l_value = ' || to_char(l_value));

1484: else
1485: l_value := 0;
1486: end if;
1487:
1488: hr_utility.trace('l_value = ' || to_char(l_value));
1489: hr_utility.trace('l_assignment_id = ' || to_char(l_assignment_id));
1490: hr_utility.trace('l_period_start = ' || l_period_start);
1491: hr_utility.trace('l_quarter_start = ' || l_quarter_start);
1492: hr_utility.trace('l_period_end = ' || l_period_end);

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

1485: l_value := 0;
1486: end if;
1487:
1488: hr_utility.trace('l_value = ' || to_char(l_value));
1489: hr_utility.trace('l_assignment_id = ' || to_char(l_assignment_id));
1490: hr_utility.trace('l_period_start = ' || l_period_start);
1491: hr_utility.trace('l_quarter_start = ' || l_quarter_start);
1492: hr_utility.trace('l_period_end = ' || l_period_end);
1493: hr_utility.trace('l_state = ' || l_state);

Line 1490: hr_utility.trace('l_period_start = ' || l_period_start);

1486: end if;
1487:
1488: hr_utility.trace('l_value = ' || to_char(l_value));
1489: hr_utility.trace('l_assignment_id = ' || to_char(l_assignment_id));
1490: hr_utility.trace('l_period_start = ' || l_period_start);
1491: hr_utility.trace('l_quarter_start = ' || l_quarter_start);
1492: hr_utility.trace('l_period_end = ' || l_period_end);
1493: hr_utility.trace('l_state = ' || l_state);
1494: hr_utility.trace('l_effective_end_date = ' || l_effective_end_date);

Line 1491: hr_utility.trace('l_quarter_start = ' || l_quarter_start);

1487:
1488: hr_utility.trace('l_value = ' || to_char(l_value));
1489: hr_utility.trace('l_assignment_id = ' || to_char(l_assignment_id));
1490: hr_utility.trace('l_period_start = ' || l_period_start);
1491: hr_utility.trace('l_quarter_start = ' || l_quarter_start);
1492: hr_utility.trace('l_period_end = ' || l_period_end);
1493: hr_utility.trace('l_state = ' || l_state);
1494: hr_utility.trace('l_effective_end_date = ' || l_effective_end_date);
1495: hr_utility.trace('l_1099R_ind = ' || l_1099R_ind);

Line 1492: hr_utility.trace('l_period_end = ' || l_period_end);

1488: hr_utility.trace('l_value = ' || to_char(l_value));
1489: hr_utility.trace('l_assignment_id = ' || to_char(l_assignment_id));
1490: hr_utility.trace('l_period_start = ' || l_period_start);
1491: hr_utility.trace('l_quarter_start = ' || l_quarter_start);
1492: hr_utility.trace('l_period_end = ' || l_period_end);
1493: hr_utility.trace('l_state = ' || l_state);
1494: hr_utility.trace('l_effective_end_date = ' || l_effective_end_date);
1495: hr_utility.trace('l_1099R_ind = ' || l_1099R_ind);
1496:

Line 1493: hr_utility.trace('l_state = ' || l_state);

1489: hr_utility.trace('l_assignment_id = ' || to_char(l_assignment_id));
1490: hr_utility.trace('l_period_start = ' || l_period_start);
1491: hr_utility.trace('l_quarter_start = ' || l_quarter_start);
1492: hr_utility.trace('l_period_end = ' || l_period_end);
1493: hr_utility.trace('l_state = ' || l_state);
1494: hr_utility.trace('l_effective_end_date = ' || l_effective_end_date);
1495: hr_utility.trace('l_1099R_ind = ' || l_1099R_ind);
1496:
1497: if ((l_value <> 0) OR

Line 1494: hr_utility.trace('l_effective_end_date = ' || l_effective_end_date);

1490: hr_utility.trace('l_period_start = ' || l_period_start);
1491: hr_utility.trace('l_quarter_start = ' || l_quarter_start);
1492: hr_utility.trace('l_period_end = ' || l_period_end);
1493: hr_utility.trace('l_state = ' || l_state);
1494: hr_utility.trace('l_effective_end_date = ' || l_effective_end_date);
1495: hr_utility.trace('l_1099R_ind = ' || l_1099R_ind);
1496:
1497: if ((l_value <> 0) OR
1498: report_person_on_tape(l_assignment_id, l_period_start,

Line 1495: hr_utility.trace('l_1099R_ind = ' || l_1099R_ind);

1491: hr_utility.trace('l_quarter_start = ' || l_quarter_start);
1492: hr_utility.trace('l_period_end = ' || l_period_end);
1493: hr_utility.trace('l_state = ' || l_state);
1494: hr_utility.trace('l_effective_end_date = ' || l_effective_end_date);
1495: hr_utility.trace('l_1099R_ind = ' || l_1099R_ind);
1496:
1497: if ((l_value <> 0) OR
1498: report_person_on_tape(l_assignment_id, l_period_start,
1499: l_period_end, l_state, l_effective_end_date, l_1099R_ind, l_report_type)) then

Line 1500: hr_utility.set_location ('actio_creation',7);

1496:
1497: if ((l_value <> 0) OR
1498: report_person_on_tape(l_assignment_id, l_period_start,
1499: l_period_end, l_state, l_effective_end_date, l_1099R_ind, l_report_type)) then
1500: hr_utility.set_location ('actio_creation',7);
1501: --
1502: -- Have found a person that needs to be reported in the federal W2 so
1503: -- need to create an assignment action for it.
1504:

Line 1532: hr_utility.set_message(801, 'PAY_7024_USERTAB_BAD_ROW_VALUE');

1528:
1529: FOR c_rec IN c_chk_asg_wp (l_assignment_id)
1530: LOOP
1531: IF c_rec.ct = 0 THEN
1532: hr_utility.set_message(801, 'PAY_7024_USERTAB_BAD_ROW_VALUE');
1533: hr_utility.set_message_token('FORMAT',' wage plan not defined at GRE');
1534: hr_utility.raise_error;
1535: END IF;
1536: END LOOP;

Line 1533: hr_utility.set_message_token('FORMAT',' wage plan not defined at GRE');

1529: FOR c_rec IN c_chk_asg_wp (l_assignment_id)
1530: LOOP
1531: IF c_rec.ct = 0 THEN
1532: hr_utility.set_message(801, 'PAY_7024_USERTAB_BAD_ROW_VALUE');
1533: hr_utility.set_message_token('FORMAT',' wage plan not defined at GRE');
1534: hr_utility.raise_error;
1535: END IF;
1536: END LOOP;
1537:

Line 1534: hr_utility.raise_error;

1530: LOOP
1531: IF c_rec.ct = 0 THEN
1532: hr_utility.set_message(801, 'PAY_7024_USERTAB_BAD_ROW_VALUE');
1533: hr_utility.set_message_token('FORMAT',' wage plan not defined at GRE');
1534: hr_utility.raise_error;
1535: END IF;
1536: END LOOP;
1537:
1538: END IF;

Line 1559: hr_utility.set_location ('actio_creation',8);

1555: INTO l_transfer_gre_id
1556: FROM pay_payroll_actions
1557: WHERE payroll_action_id = pactid;
1558:
1559: hr_utility.set_location ('actio_creation',8);
1560: -- insert into pay_assignment_actions.
1561: /* Bug: 10649380 : Create Assignment action only if GRE is equal to the
1562: Tranfer GRE parameter which is getting passed through the new SQWL process
1563: State Quarterly Wage Listing (Enhanced) */

Line 1566: hr_utility.set_location ('actio_creation',9);

1562: Tranfer GRE parameter which is getting passed through the new SQWL process
1563: State Quarterly Wage Listing (Enhanced) */
1564: IF l_transfer_gre_id is null OR l_transfer_gre_id = l_tax_unit_id THEN
1565:
1566: hr_utility.set_location ('actio_creation',9);
1567: hr_nonrun_asact.insact(lockingactid,l_assignment_id,
1568: pactid,chunk,l_tax_unit_id);
1569: hr_utility.set_location ('actio_creation',10);
1570: IF l_value= 0 THEN /*bug 14456648 */

Line 1569: hr_utility.set_location ('actio_creation',10);

1565:
1566: hr_utility.set_location ('actio_creation',9);
1567: hr_nonrun_asact.insact(lockingactid,l_assignment_id,
1568: pactid,chunk,l_tax_unit_id);
1569: hr_utility.set_location ('actio_creation',10);
1570: IF l_value= 0 THEN /*bug 14456648 */
1571: UPDATE pay_assignment_actions
1572: SET SERIAL_NUMBER = 'X'
1573: WHERE assignment_action_id = lockingactid;

Line 1615: hr_utility.set_location ('archinit',1);

1611:
1612: /* End of Bug 773937 */
1613:
1614: begin
1615: hr_utility.set_location ('archinit',1);
1616:
1617: -- Derive state
1618: select report_qualifier,
1619: report_category

Line 1628: hr_utility.set_location ('archinit',2);

1624:
1625: /* Added the select of report_category field in the above SQL on
1626: 10-FEB-2000 by Ashu Gupta (ashgupta) */
1627:
1628: hr_utility.set_location ('archinit',2);
1629:
1630: -- Get jurisdiction code and store as a context
1631: IF l_state <> 'FED' THEN
1632: SELECT sr.jurisdiction_code

Line 1650: hr_utility.set_location ('archinit getting min chunk number',10);

1646:
1647: pay_balance_pkg.set_context ('JURISDICTION_CODE',jurisdiction_code);
1648: END IF;
1649: /* Bug 773937 */
1650: hr_utility.set_location ('archinit getting min chunk number',10);
1651: open c_get_min_chunk;
1652: fetch c_get_min_chunk into g_min_chunk;
1653: if c_get_min_chunk%NOTFOUND then
1654: g_min_chunk := -1;

Line 1655: hr_utility.set_location ('archinit min chunk is -1',11);

1651: open c_get_min_chunk;
1652: fetch c_get_min_chunk into g_min_chunk;
1653: if c_get_min_chunk%NOTFOUND then
1654: g_min_chunk := -1;
1655: hr_utility.set_location ('archinit min chunk is -1',11);
1656: raise hr_utility.hr_error;
1657: end if;
1658: close c_get_min_chunk;
1659:

Line 1656: raise hr_utility.hr_error;

1652: fetch c_get_min_chunk into g_min_chunk;
1653: if c_get_min_chunk%NOTFOUND then
1654: g_min_chunk := -1;
1655: hr_utility.set_location ('archinit min chunk is -1',11);
1656: raise hr_utility.hr_error;
1657: end if;
1658: close c_get_min_chunk;
1659:
1660: /* Check if GRE level data has been archived or not and set the g_archive_flag to Y or N*/

Line 1698: hr_utility.trace('Error while getting the jursd. value ' ||

1694: exception
1695: when no_data_found then
1696: return(0);
1697: when others then
1698: hr_utility.trace('Error while getting the jursd. value ' ||
1699: to_char(sqlcode));
1700:
1701: end eoy_get_jursd_level;
1702:

Line 1749: hr_utility.trace('Error while inserting into ff_archive_items'

1745:
1746: exception
1747: when others then
1748: if l_step = 1 then
1749: hr_utility.trace('Error while inserting into ff_archive_items'
1750: || to_char(sqlcode));
1751: raise hr_utility.hr_error;
1752:
1753: elsif l_step = 2 then

Line 1751: raise hr_utility.hr_error;

1747: when others then
1748: if l_step = 1 then
1749: hr_utility.trace('Error while inserting into ff_archive_items'
1750: || to_char(sqlcode));
1751: raise hr_utility.hr_error;
1752:
1753: elsif l_step = 2 then
1754: hr_utility.trace('Error while inserting into ff_archive_item_contexts'
1755: || to_char(sqlcode));

Line 1754: hr_utility.trace('Error while inserting into ff_archive_item_contexts'

1750: || to_char(sqlcode));
1751: raise hr_utility.hr_error;
1752:
1753: elsif l_step = 2 then
1754: hr_utility.trace('Error while inserting into ff_archive_item_contexts'
1755: || to_char(sqlcode));
1756: raise hr_utility.hr_error;
1757:
1758: end if;

Line 1756: raise hr_utility.hr_error;

1752:
1753: elsif l_step = 2 then
1754: hr_utility.trace('Error while inserting into ff_archive_item_contexts'
1755: || to_char(sqlcode));
1756: raise hr_utility.hr_error;
1757:
1758: end if;
1759:
1760: end create_archive;

Line 1913: hr_utility.trace('chk_gre_archive - checking g_archive_flag');

1909: where fai.context1 = p_payroll_action_id
1910: and archive_type = 'PPA'); /* Bug:2965887 */
1911: begin
1912:
1913: hr_utility.trace('chk_gre_archive - checking g_archive_flag');
1914:
1915: if g_archive_flag = 'Y' then
1916: hr_utility.trace('chk_gre_archive - g_archive_flag is Y');
1917: return (TRUE);

Line 1916: hr_utility.trace('chk_gre_archive - g_archive_flag is Y');

1912:
1913: hr_utility.trace('chk_gre_archive - checking g_archive_flag');
1914:
1915: if g_archive_flag = 'Y' then
1916: hr_utility.trace('chk_gre_archive - g_archive_flag is Y');
1917: return (TRUE);
1918: else
1919:
1920: hr_utility.trace('chk_gre_archive - opening cursor');

Line 1920: hr_utility.trace('chk_gre_archive - opening cursor');

1916: hr_utility.trace('chk_gre_archive - g_archive_flag is Y');
1917: return (TRUE);
1918: else
1919:
1920: hr_utility.trace('chk_gre_archive - opening cursor');
1921:
1922: open c_chk_payroll_action;
1923: fetch c_chk_payroll_action into l_flag;
1924: if c_chk_payroll_action%FOUND then

Line 1925: hr_utility.trace('chk_gre_archive - found in cursor');

1921:
1922: open c_chk_payroll_action;
1923: fetch c_chk_payroll_action into l_flag;
1924: if c_chk_payroll_action%FOUND then
1925: hr_utility.trace('chk_gre_archive - found in cursor');
1926: g_archive_flag := 'Y';
1927: else
1928: hr_utility.trace('chk_gre_archive - not found in cursor');
1929: g_archive_flag := 'N';

Line 1928: hr_utility.trace('chk_gre_archive - not found in cursor');

1924: if c_chk_payroll_action%FOUND then
1925: hr_utility.trace('chk_gre_archive - found in cursor');
1926: g_archive_flag := 'Y';
1927: else
1928: hr_utility.trace('chk_gre_archive - not found in cursor');
1929: g_archive_flag := 'N';
1930: end if;
1931:
1932: hr_utility.trace('chk_gre_archive - closing cursor');

Line 1932: hr_utility.trace('chk_gre_archive - closing cursor');

1928: hr_utility.trace('chk_gre_archive - not found in cursor');
1929: g_archive_flag := 'N';
1930: end if;
1931:
1932: hr_utility.trace('chk_gre_archive - closing cursor');
1933: close c_chk_payroll_action;
1934: if g_archive_flag = 'Y' then
1935: hr_utility.trace('chk_gre_archive - returning true');
1936: return (TRUE);

Line 1935: hr_utility.trace('chk_gre_archive - returning true');

1931:
1932: hr_utility.trace('chk_gre_archive - closing cursor');
1933: close c_chk_payroll_action;
1934: if g_archive_flag = 'Y' then
1935: hr_utility.trace('chk_gre_archive - returning true');
1936: return (TRUE);
1937: else
1938: hr_utility.trace('chk_gre_archive - returning false');
1939: return(FALSE);

Line 1938: hr_utility.trace('chk_gre_archive - returning false');

1934: if g_archive_flag = 'Y' then
1935: hr_utility.trace('chk_gre_archive - returning true');
1936: return (TRUE);
1937: else
1938: hr_utility.trace('chk_gre_archive - returning false');
1939: return(FALSE);
1940: end if;
1941: end if;
1942: end chk_gre_archive;

Line 2439: hr_utility.set_location ('archive_data',1);

2435: l_sui_ar_oos_state_code VARCHAR2(2);
2436: /* Added for Bug#14097843 ends here */
2437:
2438: begin
2439: hr_utility.set_location ('archive_data',1);
2440:
2441: SELECT aa.assignment_id,
2442: pay_magtape_generic.date_earned (p_effective_date,aa.assignment_id),
2443: aa.tax_unit_id,

Line 2464: hr_utility.trace('Adjusting the Ohio Taxable');

2460: */
2461:
2462: IF (g_sqwl_state = 'OH') then
2463:
2464: hr_utility.trace('Adjusting the Ohio Taxable');
2465: l_user_entity_id :=get_user_entity_id('A_SUI_OH_ER_ADJ_TAXABLE_ASG_GRE_QTD');
2466: l_oh_jurisdiction_code := '36-000-0000';
2467:
2468: pay_balance_pkg.set_context('TAX_UNIT_ID',taxunitid);

Line 2486: hr_utility.trace('Modified l_effective_date'||to_char(l_effective_date));

2482: open get_effective_date(add_months(last_day(p_effective_date),-3)+1,last_day(p_effective_date));
2483: fetch get_effective_date into l_effective_date;
2484: close get_effective_date;
2485:
2486: hr_utility.trace('Modified l_effective_date'||to_char(l_effective_date));
2487:
2488: ELSE
2489:
2490: l_effective_date := p_effective_date;

Line 2492: hr_utility.trace('Use original l_effective_date'||to_char(l_effective_date));

2488: ELSE
2489:
2490: l_effective_date := p_effective_date;
2491:
2492: hr_utility.trace('Use original l_effective_date'||to_char(l_effective_date));
2493:
2494: END IF;
2495:
2496: open c_get_defined_balance_id_oh;

Line 2509: hr_utility.trace('l_sui_oh_taxable_qtd '||l_sui_oh_taxable_qtd);

2505: l_sui_oh_taxable_qtd := pay_balance_pkg.get_value( l_def_bal_id,
2506: asgid,
2507: l_effective_date);
2508:
2509: hr_utility.trace('l_sui_oh_taxable_qtd '||l_sui_oh_taxable_qtd);
2510: else
2511:
2512:
2513: l_sui_total_taxable_qtd :=pay_balance_pkg.get_value( l_def_bal_id,

Line 2516: hr_utility.trace('l_sui_total_taxable_qtd '||l_sui_total_taxable_qtd);

2512:
2513: l_sui_total_taxable_qtd :=pay_balance_pkg.get_value( l_def_bal_id,
2514: asgid,
2515: l_effective_date);
2516: hr_utility.trace('l_sui_total_taxable_qtd '||l_sui_total_taxable_qtd);
2517:
2518: end if;
2519:
2520: fetch c_get_defined_balance_id_oh into l_def_bal_id,l_dimension_name;

Line 2544: hr_utility.trace('Archived the adjusted OH Taxable');

2540: l_user_entity_id ,
2541: p_assactid ,
2542: l_sui_oh_taxable_qtd );
2543:
2544: hr_utility.trace('Archived the adjusted OH Taxable');
2545:
2546: SELECT context_id
2547: INTO l_context_id_tax_unit_id
2548: FROM ff_contexts

Line 2586: hr_utility.trace('Adjusting the Arkansas Taxable and Out of State Wages');

2582: l_ar_state_abbrev := 'AR';
2583: l_ar_jurisdiction_code := '04-000-0000';
2584: l_sui_ar_oos_state_code := NULL;
2585:
2586: hr_utility.trace('Adjusting the Arkansas Taxable and Out of State Wages');
2587:
2588: l_sui_ar_tax_user_ent_id := get_user_entity_id('SUI_ER_AR_ADJ_TAXABLE_PER_JD_GRE_QTD');
2589: l_sui_ar_oos_rpt_user_ent_id := get_user_entity_id('SUI_ER_AR_ADJ_OOSW_RPT_PER_JD_GRE_QTD');
2590: l_sui_ar_oos_stcd_user_ent_id := get_user_entity_id('SUI_ER_AR_OOSW_STATE_CODE');

Line 2592: hr_utility.trace('l_sui_ar_tax_user_ent_id: ' || TO_CHAR(l_sui_ar_tax_user_ent_id));

2588: l_sui_ar_tax_user_ent_id := get_user_entity_id('SUI_ER_AR_ADJ_TAXABLE_PER_JD_GRE_QTD');
2589: l_sui_ar_oos_rpt_user_ent_id := get_user_entity_id('SUI_ER_AR_ADJ_OOSW_RPT_PER_JD_GRE_QTD');
2590: l_sui_ar_oos_stcd_user_ent_id := get_user_entity_id('SUI_ER_AR_OOSW_STATE_CODE');
2591:
2592: hr_utility.trace('l_sui_ar_tax_user_ent_id: ' || TO_CHAR(l_sui_ar_tax_user_ent_id));
2593: hr_utility.trace('l_sui_ar_oos_rpt_user_ent_id: ' || TO_CHAR(l_sui_ar_oos_rpt_user_ent_id));
2594: hr_utility.trace('l_sui_ar_oos_stcd_user_ent_id: ' || TO_CHAR(l_sui_ar_oos_stcd_user_ent_id));
2595:
2596: pay_balance_pkg.set_context('TAX_UNIT_ID',taxunitid);

Line 2593: hr_utility.trace('l_sui_ar_oos_rpt_user_ent_id: ' || TO_CHAR(l_sui_ar_oos_rpt_user_ent_id));

2589: l_sui_ar_oos_rpt_user_ent_id := get_user_entity_id('SUI_ER_AR_ADJ_OOSW_RPT_PER_JD_GRE_QTD');
2590: l_sui_ar_oos_stcd_user_ent_id := get_user_entity_id('SUI_ER_AR_OOSW_STATE_CODE');
2591:
2592: hr_utility.trace('l_sui_ar_tax_user_ent_id: ' || TO_CHAR(l_sui_ar_tax_user_ent_id));
2593: hr_utility.trace('l_sui_ar_oos_rpt_user_ent_id: ' || TO_CHAR(l_sui_ar_oos_rpt_user_ent_id));
2594: hr_utility.trace('l_sui_ar_oos_stcd_user_ent_id: ' || TO_CHAR(l_sui_ar_oos_stcd_user_ent_id));
2595:
2596: pay_balance_pkg.set_context('TAX_UNIT_ID',taxunitid);
2597: pay_balance_pkg.set_context('JURISDICTION_CODE',l_ar_jurisdiction_code);

Line 2594: hr_utility.trace('l_sui_ar_oos_stcd_user_ent_id: ' || TO_CHAR(l_sui_ar_oos_stcd_user_ent_id));

2590: l_sui_ar_oos_stcd_user_ent_id := get_user_entity_id('SUI_ER_AR_OOSW_STATE_CODE');
2591:
2592: hr_utility.trace('l_sui_ar_tax_user_ent_id: ' || TO_CHAR(l_sui_ar_tax_user_ent_id));
2593: hr_utility.trace('l_sui_ar_oos_rpt_user_ent_id: ' || TO_CHAR(l_sui_ar_oos_rpt_user_ent_id));
2594: hr_utility.trace('l_sui_ar_oos_stcd_user_ent_id: ' || TO_CHAR(l_sui_ar_oos_stcd_user_ent_id));
2595:
2596: pay_balance_pkg.set_context('TAX_UNIT_ID',taxunitid);
2597: pay_balance_pkg.set_context('JURISDICTION_CODE',l_ar_jurisdiction_code);
2598:

Line 2622: hr_utility.trace('Modified l_effective_date: '||to_char(l_effective_date));

2618: IF l_effective_date IS NULL THEN
2619: OPEN get_effective_date(ADD_MONTHS(LAST_DAY(p_effective_date),-3)+1, LAST_DAY(p_effective_date));
2620: FETCH get_effective_date INTO l_effective_date;
2621: CLOSE get_effective_date;
2622: hr_utility.trace('Modified l_effective_date: '||to_char(l_effective_date));
2623: END IF;
2624:
2625: hr_utility.trace('asgid: '||TO_CHAR(asgid));
2626: hr_utility.trace('g_sqwl_state: '||TO_CHAR(g_sqwl_state));

Line 2625: hr_utility.trace('asgid: '||TO_CHAR(asgid));

2621: CLOSE get_effective_date;
2622: hr_utility.trace('Modified l_effective_date: '||to_char(l_effective_date));
2623: END IF;
2624:
2625: hr_utility.trace('asgid: '||TO_CHAR(asgid));
2626: hr_utility.trace('g_sqwl_state: '||TO_CHAR(g_sqwl_state));
2627: hr_utility.trace('Original p_effective_date: '||TO_CHAR(p_effective_date));
2628: hr_utility.trace('Modified l_effective_date: '||TO_CHAR(l_effective_date));
2629:

Line 2626: hr_utility.trace('g_sqwl_state: '||TO_CHAR(g_sqwl_state));

2622: hr_utility.trace('Modified l_effective_date: '||to_char(l_effective_date));
2623: END IF;
2624:
2625: hr_utility.trace('asgid: '||TO_CHAR(asgid));
2626: hr_utility.trace('g_sqwl_state: '||TO_CHAR(g_sqwl_state));
2627: hr_utility.trace('Original p_effective_date: '||TO_CHAR(p_effective_date));
2628: hr_utility.trace('Modified l_effective_date: '||TO_CHAR(l_effective_date));
2629:
2630: /* Previous Taxable Out of State Wages in the Year */

Line 2627: hr_utility.trace('Original p_effective_date: '||TO_CHAR(p_effective_date));

2623: END IF;
2624:
2625: hr_utility.trace('asgid: '||TO_CHAR(asgid));
2626: hr_utility.trace('g_sqwl_state: '||TO_CHAR(g_sqwl_state));
2627: hr_utility.trace('Original p_effective_date: '||TO_CHAR(p_effective_date));
2628: hr_utility.trace('Modified l_effective_date: '||TO_CHAR(l_effective_date));
2629:
2630: /* Previous Taxable Out of State Wages in the Year */
2631: OPEN get_previous_ar_value(l_sui_ar_oos_rpt_user_ent_id);

Line 2628: hr_utility.trace('Modified l_effective_date: '||TO_CHAR(l_effective_date));

2624:
2625: hr_utility.trace('asgid: '||TO_CHAR(asgid));
2626: hr_utility.trace('g_sqwl_state: '||TO_CHAR(g_sqwl_state));
2627: hr_utility.trace('Original p_effective_date: '||TO_CHAR(p_effective_date));
2628: hr_utility.trace('Modified l_effective_date: '||TO_CHAR(l_effective_date));
2629:
2630: /* Previous Taxable Out of State Wages in the Year */
2631: OPEN get_previous_ar_value(l_sui_ar_oos_rpt_user_ent_id);
2632: FETCH get_previous_ar_value into l_prev_ar_oos_rpt;

Line 2638: hr_utility.trace('l_prev_ar_oos_rpt: '||TO_CHAR(l_prev_ar_oos_rpt));

2634: l_prev_ar_oos_rpt := 0;
2635: END IF;
2636: CLOSE get_previous_ar_value;
2637:
2638: hr_utility.trace('l_prev_ar_oos_rpt: '||TO_CHAR(l_prev_ar_oos_rpt));
2639:
2640: /* AR SUI Wage Limit */
2641: l_ar_sui_er_limit := hr_us_ff_udf1.get_jit_data (l_ar_jurisdiction_code,
2642: p_effective_date,

Line 2645: hr_utility.trace('l_ar_sui_er_limit: '||TO_CHAR(l_ar_sui_er_limit));

2641: l_ar_sui_er_limit := hr_us_ff_udf1.get_jit_data (l_ar_jurisdiction_code,
2642: p_effective_date,
2643: 'SUI_ER_WAGE_LIMIT');
2644:
2645: hr_utility.trace('l_ar_sui_er_limit: '||TO_CHAR(l_ar_sui_er_limit));
2646:
2647: /* Get the Defined balance ids for
2648: - SUI ER Arkansas Taxable Wages in Year
2649: - SUI ER Total Taxable Wages in Year - This includes all states

Line 2668: hr_utility.trace('l_sui_ar_subj_whable_qtd: '|| TO_CHAR(l_sui_ar_subj_whable_qtd));

2664: l_sui_ar_subj_whable_qtd := pay_balance_pkg.get_value(l_def_bal_id,
2665: asgid,
2666: l_effective_date);
2667:
2668: hr_utility.trace('l_sui_ar_subj_whable_qtd: '|| TO_CHAR(l_sui_ar_subj_whable_qtd));
2669:
2670: ELSIF l_balance_name = 'SUI ER Pre Tax Redns' THEN
2671: /* AR Pre Tax Redn Wages till Last Effective Date of Employee in AR in Quarter */
2672: l_sui_ar_pre_tax_redn_qtd := pay_balance_pkg.get_value(l_def_bal_id,

Line 2676: hr_utility.trace('l_sui_ar_pre_tax_redn_qtd: '|| TO_CHAR(l_sui_ar_pre_tax_redn_qtd));

2672: l_sui_ar_pre_tax_redn_qtd := pay_balance_pkg.get_value(l_def_bal_id,
2673: asgid,
2674: l_effective_date);
2675:
2676: hr_utility.trace('l_sui_ar_pre_tax_redn_qtd: '|| TO_CHAR(l_sui_ar_pre_tax_redn_qtd));
2677: END IF;
2678:
2679: ELSIF l_dimension_name = 'Person in JD within GRE Year to Date' THEN
2680:

Line 2687: hr_utility.trace('l_sui_ar_taxable_ytd: '|| TO_CHAR(l_sui_ar_taxable_ytd));

2683: l_sui_ar_taxable_ytd := pay_balance_pkg.get_value(l_def_bal_id,
2684: asgid,
2685: l_effective_date);
2686:
2687: hr_utility.trace('l_sui_ar_taxable_ytd: '|| TO_CHAR(l_sui_ar_taxable_ytd));
2688:
2689: ELSIF l_balance_name = 'SUI ER Subj Whable' THEN
2690: /* AR Subj Whable Wages till Last Effective Date of Employee in AR in Year */
2691: l_sui_ar_subj_whable_ytd := pay_balance_pkg.get_value(l_def_bal_id,

Line 2695: hr_utility.trace('l_sui_ar_subj_whable_ytd: '|| TO_CHAR(l_sui_ar_subj_whable_ytd));

2691: l_sui_ar_subj_whable_ytd := pay_balance_pkg.get_value(l_def_bal_id,
2692: asgid,
2693: l_effective_date);
2694:
2695: hr_utility.trace('l_sui_ar_subj_whable_ytd: '|| TO_CHAR(l_sui_ar_subj_whable_ytd));
2696:
2697: ELSIF l_balance_name = 'SUI ER Pre Tax Redns' THEN
2698: /* AR Pre Tax Redn Wages till Last Effective Date of Employee in AR in Year */
2699: l_sui_ar_pre_tax_redn_ytd := pay_balance_pkg.get_value(l_def_bal_id,

Line 2703: hr_utility.trace('l_sui_ar_pre_tax_redn_ytd: '|| TO_CHAR(l_sui_ar_pre_tax_redn_ytd));

2699: l_sui_ar_pre_tax_redn_ytd := pay_balance_pkg.get_value(l_def_bal_id,
2700: asgid,
2701: l_effective_date);
2702:
2703: hr_utility.trace('l_sui_ar_pre_tax_redn_ytd: '|| TO_CHAR(l_sui_ar_pre_tax_redn_ytd));
2704: END IF;
2705:
2706: ELSIF l_dimension_name = 'Person within Government Reporting Entity Year to Date' THEN
2707:

Line 2713: hr_utility.trace('l_sui_ar_total_taxable_ytd '|| TO_CHAR(l_sui_ar_total_taxable_ytd));

2709: l_sui_ar_total_taxable_ytd := pay_balance_pkg.get_value(l_def_bal_id,
2710: asgid,
2711: l_effective_date);
2712:
2713: hr_utility.trace('l_sui_ar_total_taxable_ytd '|| TO_CHAR(l_sui_ar_total_taxable_ytd));
2714: END IF;
2715:
2716: FETCH c_get_defined_balance_id_ar INTO l_def_bal_id, l_balance_name, l_dimension_name;
2717:

Line 2724: hr_utility.trace('l_sui_ar_oos_ytd '|| TO_CHAR(l_sui_ar_oos_ytd));

2720:
2721: /* Total Out of State Wages in Year till Last Date in AR = Total Wages in Year till Last Date in AR
2722: - AR Wages in Year */
2723: l_sui_ar_oos_ytd := l_sui_ar_total_taxable_ytd - l_sui_ar_taxable_ytd;
2724: hr_utility.trace('l_sui_ar_oos_ytd '|| TO_CHAR(l_sui_ar_oos_ytd));
2725:
2726: /* Total Reduced Subject Wages in Year till Last Date in AR */
2727: l_sui_ar_redsubj_whable_ytd := l_sui_ar_subj_whable_ytd - l_sui_ar_pre_tax_redn_ytd;
2728: hr_utility.trace('l_sui_ar_redsubj_whable_ytd '|| TO_CHAR(l_sui_ar_redsubj_whable_ytd));

Line 2728: hr_utility.trace('l_sui_ar_redsubj_whable_ytd '|| TO_CHAR(l_sui_ar_redsubj_whable_ytd));

2724: hr_utility.trace('l_sui_ar_oos_ytd '|| TO_CHAR(l_sui_ar_oos_ytd));
2725:
2726: /* Total Reduced Subject Wages in Year till Last Date in AR */
2727: l_sui_ar_redsubj_whable_ytd := l_sui_ar_subj_whable_ytd - l_sui_ar_pre_tax_redn_ytd;
2728: hr_utility.trace('l_sui_ar_redsubj_whable_ytd '|| TO_CHAR(l_sui_ar_redsubj_whable_ytd));
2729:
2730: /* Total Reduced Subject Wages in Quarter till Last Date in AR */
2731: l_sui_ar_redsubj_whable_qtd := l_sui_ar_subj_whable_qtd - l_sui_ar_pre_tax_redn_qtd;
2732: hr_utility.trace('l_sui_ar_redsubj_whable_qtd '|| TO_CHAR(l_sui_ar_redsubj_whable_qtd));

Line 2732: hr_utility.trace('l_sui_ar_redsubj_whable_qtd '|| TO_CHAR(l_sui_ar_redsubj_whable_qtd));

2728: hr_utility.trace('l_sui_ar_redsubj_whable_ytd '|| TO_CHAR(l_sui_ar_redsubj_whable_ytd));
2729:
2730: /* Total Reduced Subject Wages in Quarter till Last Date in AR */
2731: l_sui_ar_redsubj_whable_qtd := l_sui_ar_subj_whable_qtd - l_sui_ar_pre_tax_redn_qtd;
2732: hr_utility.trace('l_sui_ar_redsubj_whable_qtd '|| TO_CHAR(l_sui_ar_redsubj_whable_qtd));
2733:
2734: IF (l_sui_ar_redsubj_whable_ytd - l_sui_ar_redsubj_whable_qtd) < l_ar_sui_er_limit THEN
2735: /* Reduced Subject Withholdable Wages reported in Previous Quarters does not reach the AR limit */
2736:

Line 2737: hr_utility.set_location('From archive_data AR', 10);

2733:
2734: IF (l_sui_ar_redsubj_whable_ytd - l_sui_ar_redsubj_whable_qtd) < l_ar_sui_er_limit THEN
2735: /* Reduced Subject Withholdable Wages reported in Previous Quarters does not reach the AR limit */
2736:
2737: hr_utility.set_location('From archive_data AR', 10);
2738:
2739: /* Total Out of State Wages not reported in Year = Total Out of State Wages in Year till Last Date in AR
2740: - Out of State Wages previously reported */
2741: l_total_oos_rpt_remaining := l_sui_ar_oos_ytd - l_prev_ar_oos_rpt;

Line 2742: hr_utility.trace('l_total_oos_rpt_remaining '|| TO_CHAR(l_total_oos_rpt_remaining));

2738:
2739: /* Total Out of State Wages not reported in Year = Total Out of State Wages in Year till Last Date in AR
2740: - Out of State Wages previously reported */
2741: l_total_oos_rpt_remaining := l_sui_ar_oos_ytd - l_prev_ar_oos_rpt;
2742: hr_utility.trace('l_total_oos_rpt_remaining '|| TO_CHAR(l_total_oos_rpt_remaining));
2743:
2744: /* Amount required to reach Arkansas Wage Limit */
2745: l_amt_req_to_reach_ar_lmt := l_ar_sui_er_limit - (l_sui_ar_redsubj_whable_ytd - l_sui_ar_redsubj_whable_qtd);
2746: hr_utility.trace('l_amt_req_to_reach_ar_lmt '|| TO_CHAR(l_amt_req_to_reach_ar_lmt));

Line 2746: hr_utility.trace('l_amt_req_to_reach_ar_lmt '|| TO_CHAR(l_amt_req_to_reach_ar_lmt));

2742: hr_utility.trace('l_total_oos_rpt_remaining '|| TO_CHAR(l_total_oos_rpt_remaining));
2743:
2744: /* Amount required to reach Arkansas Wage Limit */
2745: l_amt_req_to_reach_ar_lmt := l_ar_sui_er_limit - (l_sui_ar_redsubj_whable_ytd - l_sui_ar_redsubj_whable_qtd);
2746: hr_utility.trace('l_amt_req_to_reach_ar_lmt '|| TO_CHAR(l_amt_req_to_reach_ar_lmt));
2747:
2748: /* Out of State Wages reported is the Least of Amount required to reach AR Limit,
2749: AR Quarterly Reduced Subj Whable Wages and remaining Out of State yearly Wages */
2750: l_sui_ar_oos_rpt_qtd := LEAST(l_amt_req_to_reach_ar_lmt,

Line 2753: hr_utility.trace('l_sui_ar_oos_rpt_qtd '|| TO_CHAR(l_sui_ar_oos_rpt_qtd));

2749: AR Quarterly Reduced Subj Whable Wages and remaining Out of State yearly Wages */
2750: l_sui_ar_oos_rpt_qtd := LEAST(l_amt_req_to_reach_ar_lmt,
2751: l_sui_ar_redsubj_whable_qtd,
2752: l_total_oos_rpt_remaining);
2753: hr_utility.trace('l_sui_ar_oos_rpt_qtd '|| TO_CHAR(l_sui_ar_oos_rpt_qtd));
2754:
2755: /* Remaining AR Taxable Wages = AR Reduced Subj Whable Wages - Out of State Wages reported */
2756: l_sui_ar_taxable_qtd_rem := l_sui_ar_redsubj_whable_qtd - l_sui_ar_oos_rpt_qtd;
2757: hr_utility.trace('l_sui_ar_taxable_qtd_rem '|| TO_CHAR(l_sui_ar_taxable_qtd_rem));

Line 2757: hr_utility.trace('l_sui_ar_taxable_qtd_rem '|| TO_CHAR(l_sui_ar_taxable_qtd_rem));

2753: hr_utility.trace('l_sui_ar_oos_rpt_qtd '|| TO_CHAR(l_sui_ar_oos_rpt_qtd));
2754:
2755: /* Remaining AR Taxable Wages = AR Reduced Subj Whable Wages - Out of State Wages reported */
2756: l_sui_ar_taxable_qtd_rem := l_sui_ar_redsubj_whable_qtd - l_sui_ar_oos_rpt_qtd;
2757: hr_utility.trace('l_sui_ar_taxable_qtd_rem '|| TO_CHAR(l_sui_ar_taxable_qtd_rem));
2758:
2759: /* Amount required to reach Arkansas Wage Limit */
2760: l_amt_req_to_reach_ar_lmt := l_ar_sui_er_limit - (l_sui_ar_redsubj_whable_ytd - l_sui_ar_redsubj_whable_qtd)
2761: - l_sui_ar_oos_rpt_qtd;

Line 2762: hr_utility.trace('l_amt_req_to_reach_ar_lmt '|| TO_CHAR(l_amt_req_to_reach_ar_lmt));

2758:
2759: /* Amount required to reach Arkansas Wage Limit */
2760: l_amt_req_to_reach_ar_lmt := l_ar_sui_er_limit - (l_sui_ar_redsubj_whable_ytd - l_sui_ar_redsubj_whable_qtd)
2761: - l_sui_ar_oos_rpt_qtd;
2762: hr_utility.trace('l_amt_req_to_reach_ar_lmt '|| TO_CHAR(l_amt_req_to_reach_ar_lmt));
2763:
2764: /* Adjusted AR Taxable Wages is least of Amount required to reach AR Wage Limit and Remaining AR Taxable Wages */
2765: l_sui_ar_adj_taxable_qtd := LEAST(l_amt_req_to_reach_ar_lmt, l_sui_ar_taxable_qtd_rem);
2766: hr_utility.trace('l_sui_ar_adj_taxable_qtd '|| TO_CHAR(l_sui_ar_adj_taxable_qtd));

Line 2766: hr_utility.trace('l_sui_ar_adj_taxable_qtd '|| TO_CHAR(l_sui_ar_adj_taxable_qtd));

2762: hr_utility.trace('l_amt_req_to_reach_ar_lmt '|| TO_CHAR(l_amt_req_to_reach_ar_lmt));
2763:
2764: /* Adjusted AR Taxable Wages is least of Amount required to reach AR Wage Limit and Remaining AR Taxable Wages */
2765: l_sui_ar_adj_taxable_qtd := LEAST(l_amt_req_to_reach_ar_lmt, l_sui_ar_taxable_qtd_rem);
2766: hr_utility.trace('l_sui_ar_adj_taxable_qtd '|| TO_CHAR(l_sui_ar_adj_taxable_qtd));
2767:
2768: ELSE
2769: /* Previous Adjusted AR Taxable + Out of State Wages has reached the AR limit */
2770: l_sui_ar_oos_rpt_qtd := 0;

Line 2772: hr_utility.set_location('From archive_data AR', 60);

2768: ELSE
2769: /* Previous Adjusted AR Taxable + Out of State Wages has reached the AR limit */
2770: l_sui_ar_oos_rpt_qtd := 0;
2771: l_sui_ar_adj_taxable_qtd := 0;
2772: hr_utility.set_location('From archive_data AR', 60);
2773: hr_utility.trace('l_sui_ar_oos_rpt_qtd '|| TO_CHAR(l_sui_ar_oos_rpt_qtd));
2774: hr_utility.trace('l_sui_ar_adj_taxable_qtd '|| TO_CHAR(l_sui_ar_adj_taxable_qtd));
2775: END IF;
2776:

Line 2773: hr_utility.trace('l_sui_ar_oos_rpt_qtd '|| TO_CHAR(l_sui_ar_oos_rpt_qtd));

2769: /* Previous Adjusted AR Taxable + Out of State Wages has reached the AR limit */
2770: l_sui_ar_oos_rpt_qtd := 0;
2771: l_sui_ar_adj_taxable_qtd := 0;
2772: hr_utility.set_location('From archive_data AR', 60);
2773: hr_utility.trace('l_sui_ar_oos_rpt_qtd '|| TO_CHAR(l_sui_ar_oos_rpt_qtd));
2774: hr_utility.trace('l_sui_ar_adj_taxable_qtd '|| TO_CHAR(l_sui_ar_adj_taxable_qtd));
2775: END IF;
2776:
2777: /* Report Out of State Wages State Code only if Out of State Wages are reported */

Line 2774: hr_utility.trace('l_sui_ar_adj_taxable_qtd '|| TO_CHAR(l_sui_ar_adj_taxable_qtd));

2770: l_sui_ar_oos_rpt_qtd := 0;
2771: l_sui_ar_adj_taxable_qtd := 0;
2772: hr_utility.set_location('From archive_data AR', 60);
2773: hr_utility.trace('l_sui_ar_oos_rpt_qtd '|| TO_CHAR(l_sui_ar_oos_rpt_qtd));
2774: hr_utility.trace('l_sui_ar_adj_taxable_qtd '|| TO_CHAR(l_sui_ar_adj_taxable_qtd));
2775: END IF;
2776:
2777: /* Report Out of State Wages State Code only if Out of State Wages are reported */
2778: IF l_sui_ar_oos_rpt_qtd <> 0 THEN

Line 2832: hr_utility.trace('Archived the adjusted AR Taxable');

2828: l_sui_ar_tax_user_ent_id ,
2829: p_assactid ,
2830: l_sui_ar_adj_taxable_qtd );
2831:
2832: hr_utility.trace('Archived the adjusted AR Taxable');
2833:
2834: SELECT context_id
2835: INTO l_context_id_tax_unit_id
2836: FROM ff_contexts

Line 2862: hr_utility.trace('Archived the AR Out of State Wages');

2858: l_sui_ar_oos_rpt_user_ent_id,
2859: p_assactid ,
2860: l_sui_ar_oos_rpt_qtd );
2861:
2862: hr_utility.trace('Archived the AR Out of State Wages');
2863:
2864: INSERT INTO ff_archive_item_contexts
2865: (archive_item_id,sequence_no,context,context_id)
2866: VALUES (ff_archive_items_s.CURRVAL,1,taxunitid,l_context_id_tax_unit_id);

Line 2882: hr_utility.trace('Archived the Out of State Wages State Code');

2878: l_sui_ar_oos_stcd_user_ent_id,
2879: p_assactid ,
2880: l_sui_ar_oos_state_code );
2881:
2882: hr_utility.trace('Archived the Out of State Wages State Code');
2883:
2884: /* Added for Bug#14097843 Ends here */
2885:
2886: /*

Line 2892: hr_utility.trace('Adjusting the Florida Taxable');

2888: take care of archiving of Wage Plan Codes in California
2889: */
2890: ELSIF (g_sqwl_state = 'FL') THEN
2891:
2892: hr_utility.trace('Adjusting the Florida Taxable');
2893:
2894: l_user_entity_id :=get_user_entity_id('SUI_ER_FL_ADJ_TAXABLE_PER_JD_GRE_QTD');
2895:
2896: fl_jurisdiction_code := '10-000-0000';

Line 2923: hr_utility.trace('Modified l_effective_date'||to_char(l_effective_date));

2919: open get_effective_date(add_months(last_day(p_effective_date),-3)+1,last_day(p_effective_date));
2920: fetch get_effective_date into l_effective_date;
2921: close get_effective_date;
2922:
2923: hr_utility.trace('Modified l_effective_date'||to_char(l_effective_date));
2924:
2925: ELSE
2926:
2927: l_effective_date := p_effective_date;

Line 2929: hr_utility.trace('Use original l_effective_date'||to_char(l_effective_date));

2925: ELSE
2926:
2927: l_effective_date := p_effective_date;
2928:
2929: hr_utility.trace('Use original l_effective_date'||to_char(l_effective_date));
2930:
2931: END IF;
2932:
2933: /* End Bug#9561700*/

Line 2949: hr_utility.trace('l_sui_fl_taxable_qtd'||l_sui_fl_taxable_qtd);

2945: l_sui_fl_taxable_qtd := pay_balance_pkg.get_value( l_def_bal_id,
2946: asgid,
2947: l_effective_date);
2948:
2949: hr_utility.trace('l_sui_fl_taxable_qtd'||l_sui_fl_taxable_qtd);
2950:
2951:
2952: elsif l_dimension_name = 'Person in JD within GRE Year to Date' then
2953:

Line 2959: hr_utility.trace('l_sui_fl_taxable_ytd'||l_sui_fl_taxable_ytd);

2955: l_sui_fl_taxable_ytd := pay_balance_pkg.get_value( l_def_bal_id,
2956: asgid,
2957: l_effective_date);
2958:
2959: hr_utility.trace('l_sui_fl_taxable_ytd'||l_sui_fl_taxable_ytd);
2960:
2961:
2962: else
2963:

Line 2968: hr_utility.trace('l_sui_taxable_ytd'||l_sui_taxable_ytd);

2964: l_sui_taxable_ytd := pay_balance_pkg.get_value( l_def_bal_id,
2965: asgid,
2966: l_effective_date);
2967:
2968: hr_utility.trace('l_sui_taxable_ytd'||l_sui_taxable_ytd);
2969:
2970: end if;
2971:
2972: fetch get_defined_balance_id into l_def_bal_id,l_dimension_name;

Line 2980: hr_utility.trace('l_outstate_sui_taxable_ytd'||l_outstate_sui_taxable_ytd);

2976: close get_defined_balance_id;
2977:
2978: l_outstate_sui_taxable_ytd := l_sui_taxable_ytd - l_sui_fl_taxable_ytd;
2979:
2980: hr_utility.trace('l_outstate_sui_taxable_ytd'||l_outstate_sui_taxable_ytd);
2981:
2982: l_fl_sui_er_limit := hr_us_ff_udf1.get_jit_data ( fl_jurisdiction_code,p_effective_date,'SUI_ER_WAGE_LIMIT');
2983:
2984: hr_utility.trace('l_fl_sui_er_limit'||l_fl_sui_er_limit);

Line 2984: hr_utility.trace('l_fl_sui_er_limit'||l_fl_sui_er_limit);

2980: hr_utility.trace('l_outstate_sui_taxable_ytd'||l_outstate_sui_taxable_ytd);
2981:
2982: l_fl_sui_er_limit := hr_us_ff_udf1.get_jit_data ( fl_jurisdiction_code,p_effective_date,'SUI_ER_WAGE_LIMIT');
2983:
2984: hr_utility.trace('l_fl_sui_er_limit'||l_fl_sui_er_limit);
2985:
2986: if l_outstate_sui_taxable_ytd >= l_fl_sui_er_limit
2987: then
2988:

Line 2991: hr_utility.trace('l_outstate_sui_taxable_ytd greater than l_fl_sui_er_limit');

2987: then
2988:
2989: l_sui_fl_taxable_qtd := 0;
2990:
2991: hr_utility.trace('l_outstate_sui_taxable_ytd greater than l_fl_sui_er_limit');
2992:
2993: else
2994:
2995:

Line 3013: hr_utility.trace('l_outstate_sui_taxable_ytd and l_previous_fl_taxable greater than l_fl_sui_er_limit');

3009: then
3010:
3011: l_sui_fl_taxable_qtd := 0;
3012:
3013: hr_utility.trace('l_outstate_sui_taxable_ytd and l_previous_fl_taxable greater than l_fl_sui_er_limit');
3014:
3015: else
3016:
3017: l_sui_fl_taxable_qtd := least(l_sui_fl_taxable_qtd,l_fl_sui_er_limit - l_outstate_sui_taxable_ytd - l_previous_fl_taxable);

Line 3024: hr_utility.trace('l_sui_fl_taxable_qtd after adjustment is'||l_sui_fl_taxable_qtd);

3020:
3021: end if;
3022:
3023:
3024: hr_utility.trace('l_sui_fl_taxable_qtd after adjustment is'||l_sui_fl_taxable_qtd);
3025:
3026: INSERT INTO ff_archive_items (archive_item_id,
3027: user_entity_id,
3028: context1,

Line 3035: hr_utility.trace('Archived the adjusted FL Taxable');

3031: l_user_entity_id ,
3032: p_assactid ,
3033: l_sui_fl_taxable_qtd );
3034:
3035: hr_utility.trace('Archived the adjusted FL Taxable');
3036:
3037: SELECT context_id
3038: INTO l_context_id_tax_unit_id
3039: FROM ff_contexts

Line 3077: -- hr_utility.trace('In Archive Wage Plan Code RTM loop ');

3073: -- OPEN c_archive_wage_plan_code_rts;
3074: -- END IF;
3075: --
3076: -- LOOP
3077: -- hr_utility.trace('In Archive Wage Plan Code RTM loop ');
3078: --
3079: -- IF (g_report_cat = 'RTM') THEN
3080: -- FETCH c_archive_wage_plan_code_rtm INTO l_wage_plan_code,
3081: -- l_assignment_id ;

Line 3125: hr_utility.trace('In Archive Wage Plan Code loop ');

3121:
3122: FOR c_rec in c_archive_wage_plan_code
3123: LOOP
3124:
3125: hr_utility.trace('In Archive Wage Plan Code loop ');
3126:
3127: l_wage_plan_code := c_rec.aei_information3;
3128:
3129: INSERT INTO ff_archive_items (archive_item_id,

Line 3156: hr_utility.trace('In Archive GRE Wage Plan Code loop ');

3152:
3153: FOR c_rec in c_gre_wage_plan_code
3154: LOOP
3155:
3156: hr_utility.trace('In Archive GRE Wage Plan Code loop ');
3157:
3158: l_wage_plan_code := c_rec.wage_plan;
3159:
3160: END LOOP;

Line 3188: hr_utility.set_location ('archive_data',2);

3184: END IF;
3185:
3186:
3187:
3188: hr_utility.set_location ('archive_data',2);
3189: /* Bug 773937 */
3190: /* If the chunk of the assignment is same as the minimun chunk
3191: for the payroll_action_id and the gre data has not yet been
3192: archived then archive the gre data i.e. the employer data */

Line 3195: hr_utility.trace('archive_data archiving employer data');

3191: for the payroll_action_id and the gre data has not yet been
3192: archived then archive the gre data i.e. the employer data */
3193:
3194: if l_chunk = g_min_chunk and g_archive_flag = 'N' then
3195: hr_utility.trace('archive_data archiving employer data');
3196: archive_gre_data(p_payroll_action_id => l_payroll_action_id,
3197: p_tax_unit_id => taxunitid);
3198: hr_utility.trace('archive_data archiving employer data');
3199: end if;

Line 3198: hr_utility.trace('archive_data archiving employer data');

3194: if l_chunk = g_min_chunk and g_archive_flag = 'N' then
3195: hr_utility.trace('archive_data archiving employer data');
3196: archive_gre_data(p_payroll_action_id => l_payroll_action_id,
3197: p_tax_unit_id => taxunitid);
3198: hr_utility.trace('archive_data archiving employer data');
3199: end if;
3200: /* End of Bug 773937 */
3201:
3202: /* Setup contexts */

Line 3233: hr_utility.trace('In city loop ');

3229:
3230: open c_get_city;
3231: loop
3232:
3233: hr_utility.trace('In city loop ');
3234:
3235: fetch c_get_city into l_jurisdiction;
3236: exit when c_get_city%NOTFOUND;
3237:

Line 3276: hr_utility.trace('aaid in action creation code'||to_char(aaid));

3272:
3273: begin
3274: open c_get_latest_asg(asgid );
3275: fetch c_get_latest_asg into aaid,eff_date;
3276: hr_utility.trace('aaid in action creation code'||to_char(aaid));
3277: close c_get_latest_asg;
3278:
3279: exception
3280: when no_data_found then

Line 3303: hr_utility.trace('Problem in archive_data');

3299: pay_archive.balance_aa := aaid;
3300:
3301: exception
3302: when others then
3303: hr_utility.trace('Problem in archive_data');
3304:
3305: end archive_data;
3306:
3307: /* Name : update_ff_archive_items

Line 3356: hr_utility.trace('Error while updating ff_archive_items ');

3352: return 'Y';
3353:
3354: EXCEPTION
3355: when OTHERS then
3356: hr_utility.trace('Error while updating ff_archive_items ');
3357: return 'N';
3358: END Update_ff_archive_items;
3359:
3360:

Line 3452: hr_utility.set_location('pay_us_sqwl_archive.preprocess_check', 10);

3448: l_distinct_wage_plan_code NUMBER := 0 ;
3449:
3450:
3451: BEGIN
3452: hr_utility.set_location('pay_us_sqwl_archive.preprocess_check', 10);
3453:
3454: IF (l_report_cat = 'RTM') THEN
3455:
3456: l_counter := 0;

Line 3466: hr_utility.set_location('pay_us_sqwl_archive.preprocess_check', 30);

3462:
3463: END LOOP;
3464:
3465: IF (l_counter > 0) THEN
3466: hr_utility.set_location('pay_us_sqwl_archive.preprocess_check', 30);
3467: hr_utility.set_message(801, 'PAY_7024_USERTAB_BAD_ROW_VALUE');
3468: hr_utility.set_message_token('FORMAT', '> 1 row in hoi for wg plcd');
3469: hr_utility.raise_error;
3470: END IF;

Line 3467: hr_utility.set_message(801, 'PAY_7024_USERTAB_BAD_ROW_VALUE');

3463: END LOOP;
3464:
3465: IF (l_counter > 0) THEN
3466: hr_utility.set_location('pay_us_sqwl_archive.preprocess_check', 30);
3467: hr_utility.set_message(801, 'PAY_7024_USERTAB_BAD_ROW_VALUE');
3468: hr_utility.set_message_token('FORMAT', '> 1 row in hoi for wg plcd');
3469: hr_utility.raise_error;
3470: END IF;
3471: END IF;

Line 3468: hr_utility.set_message_token('FORMAT', '> 1 row in hoi for wg plcd');

3464:
3465: IF (l_counter > 0) THEN
3466: hr_utility.set_location('pay_us_sqwl_archive.preprocess_check', 30);
3467: hr_utility.set_message(801, 'PAY_7024_USERTAB_BAD_ROW_VALUE');
3468: hr_utility.set_message_token('FORMAT', '> 1 row in hoi for wg plcd');
3469: hr_utility.raise_error;
3470: END IF;
3471: END IF;
3472:

Line 3469: hr_utility.raise_error;

3465: IF (l_counter > 0) THEN
3466: hr_utility.set_location('pay_us_sqwl_archive.preprocess_check', 30);
3467: hr_utility.set_message(801, 'PAY_7024_USERTAB_BAD_ROW_VALUE');
3468: hr_utility.set_message_token('FORMAT', '> 1 row in hoi for wg plcd');
3469: hr_utility.raise_error;
3470: END IF;
3471: END IF;
3472:
3473: IF (l_report_cat = 'RTM') THEN

Line 3485: hr_utility.set_location('pay_us_sqwl_archive.preprocess_check', 40);

3481:
3482: END LOOP;
3483:
3484: IF l_counter > 0 THEN
3485: hr_utility.set_location('pay_us_sqwl_archive.preprocess_check', 40);
3486: hr_utility.set_message(801, 'PAY_7024_USERTAB_BAD_ROW_VALUE');
3487: hr_utility.set_message_token('FORMAT',' Default Wage Plan not marked');
3488: hr_utility.raise_error;
3489: END IF;

Line 3486: hr_utility.set_message(801, 'PAY_7024_USERTAB_BAD_ROW_VALUE');

3482: END LOOP;
3483:
3484: IF l_counter > 0 THEN
3485: hr_utility.set_location('pay_us_sqwl_archive.preprocess_check', 40);
3486: hr_utility.set_message(801, 'PAY_7024_USERTAB_BAD_ROW_VALUE');
3487: hr_utility.set_message_token('FORMAT',' Default Wage Plan not marked');
3488: hr_utility.raise_error;
3489: END IF;
3490:

Line 3487: hr_utility.set_message_token('FORMAT',' Default Wage Plan not marked');

3483:
3484: IF l_counter > 0 THEN
3485: hr_utility.set_location('pay_us_sqwl_archive.preprocess_check', 40);
3486: hr_utility.set_message(801, 'PAY_7024_USERTAB_BAD_ROW_VALUE');
3487: hr_utility.set_message_token('FORMAT',' Default Wage Plan not marked');
3488: hr_utility.raise_error;
3489: END IF;
3490:
3491: l_counter := 0;

Line 3488: hr_utility.raise_error;

3484: IF l_counter > 0 THEN
3485: hr_utility.set_location('pay_us_sqwl_archive.preprocess_check', 40);
3486: hr_utility.set_message(801, 'PAY_7024_USERTAB_BAD_ROW_VALUE');
3487: hr_utility.set_message_token('FORMAT',' Default Wage Plan not marked');
3488: hr_utility.raise_error;
3489: END IF;
3490:
3491: l_counter := 0;
3492:

Line 3501: hr_utility.set_location('pay_us_sqwl_archive.preprocess_check', 50);

3497:
3498: END LOOP;
3499:
3500: IF l_counter > 0 THEN
3501: hr_utility.set_location('pay_us_sqwl_archive.preprocess_check', 50);
3502: hr_utility.set_message(801, 'PAY_7024_USERTAB_BAD_ROW_VALUE');
3503: hr_utility.set_message_token('FORMAT',' wage plan not defined at GRE');
3504: hr_utility.raise_error;
3505: END IF;

Line 3502: hr_utility.set_message(801, 'PAY_7024_USERTAB_BAD_ROW_VALUE');

3498: END LOOP;
3499:
3500: IF l_counter > 0 THEN
3501: hr_utility.set_location('pay_us_sqwl_archive.preprocess_check', 50);
3502: hr_utility.set_message(801, 'PAY_7024_USERTAB_BAD_ROW_VALUE');
3503: hr_utility.set_message_token('FORMAT',' wage plan not defined at GRE');
3504: hr_utility.raise_error;
3505: END IF;
3506:

Line 3503: hr_utility.set_message_token('FORMAT',' wage plan not defined at GRE');

3499:
3500: IF l_counter > 0 THEN
3501: hr_utility.set_location('pay_us_sqwl_archive.preprocess_check', 50);
3502: hr_utility.set_message(801, 'PAY_7024_USERTAB_BAD_ROW_VALUE');
3503: hr_utility.set_message_token('FORMAT',' wage plan not defined at GRE');
3504: hr_utility.raise_error;
3505: END IF;
3506:
3507: END IF;

Line 3504: hr_utility.raise_error;

3500: IF l_counter > 0 THEN
3501: hr_utility.set_location('pay_us_sqwl_archive.preprocess_check', 50);
3502: hr_utility.set_message(801, 'PAY_7024_USERTAB_BAD_ROW_VALUE');
3503: hr_utility.set_message_token('FORMAT',' wage plan not defined at GRE');
3504: hr_utility.raise_error;
3505: END IF;
3506:
3507: END IF;
3508: RETURN TRUE;

Line 3613: hr_utility.set_location('archive_asg_locs.' || l_procedure , 10);

3609: order by paf.effective_end_date desc;
3610:
3611: BEGIN
3612:
3613: hr_utility.set_location('archive_asg_locs.' || l_procedure , 10);
3614: hr_utility.trace('p_asg_act_id = '||to_char(p_asg_act_id));
3615: hr_utility.trace('p_asg_id = '||to_char(p_asg_id));
3616: hr_utility.trace('p_pay_act_id = '||to_char(p_pay_act_id));
3617:

Line 3614: hr_utility.trace('p_asg_act_id = '||to_char(p_asg_act_id));

3610:
3611: BEGIN
3612:
3613: hr_utility.set_location('archive_asg_locs.' || l_procedure , 10);
3614: hr_utility.trace('p_asg_act_id = '||to_char(p_asg_act_id));
3615: hr_utility.trace('p_asg_id = '||to_char(p_asg_id));
3616: hr_utility.trace('p_pay_act_id = '||to_char(p_pay_act_id));
3617:
3618:

Line 3615: hr_utility.trace('p_asg_id = '||to_char(p_asg_id));

3611: BEGIN
3612:
3613: hr_utility.set_location('archive_asg_locs.' || l_procedure , 10);
3614: hr_utility.trace('p_asg_act_id = '||to_char(p_asg_act_id));
3615: hr_utility.trace('p_asg_id = '||to_char(p_asg_id));
3616: hr_utility.trace('p_pay_act_id = '||to_char(p_pay_act_id));
3617:
3618:
3619: FOR i IN 1 .. 3 LOOP

Line 3616: hr_utility.trace('p_pay_act_id = '||to_char(p_pay_act_id));

3612:
3613: hr_utility.set_location('archive_asg_locs.' || l_procedure , 10);
3614: hr_utility.trace('p_asg_act_id = '||to_char(p_asg_act_id));
3615: hr_utility.trace('p_asg_id = '||to_char(p_asg_id));
3616: hr_utility.trace('p_pay_act_id = '||to_char(p_pay_act_id));
3617:
3618:
3619: FOR i IN 1 .. 3 LOOP
3620: OPEN c_asg_loc_mon(p_asg_act_id,

Line 3629: hr_utility.trace('Entered into c_asg_loc_mon2 cursor assignment id'||to_char(p_asg_act_id));

3625: -- l_location_id := Null;
3626: OPEN c_asg_loc_mon2(p_asg_act_id,
3627: i);
3628: Fetch c_asg_loc_mon2 into l_location_id;
3629: hr_utility.trace('Entered into c_asg_loc_mon2 cursor assignment id'||to_char(p_asg_act_id));
3630: hr_utility.trace('Entered into c_asg_loc_mon2 cursor location_id '||to_char(l_location_id));
3631: IF c_asg_loc_mon2%NOTFOUND THEN
3632: l_location_id := Null;
3633: END IF;

Line 3630: hr_utility.trace('Entered into c_asg_loc_mon2 cursor location_id '||to_char(l_location_id));

3626: OPEN c_asg_loc_mon2(p_asg_act_id,
3627: i);
3628: Fetch c_asg_loc_mon2 into l_location_id;
3629: hr_utility.trace('Entered into c_asg_loc_mon2 cursor assignment id'||to_char(p_asg_act_id));
3630: hr_utility.trace('Entered into c_asg_loc_mon2 cursor location_id '||to_char(l_location_id));
3631: IF c_asg_loc_mon2%NOTFOUND THEN
3632: l_location_id := Null;
3633: END IF;
3634:

Line 3642: hr_utility.set_location('archive_asg_locs.' || l_procedure , 20);

3638: CLOSE c_asg_loc_mon;
3639:
3640: IF l_location_id is not NULL THEN
3641:
3642: hr_utility.set_location('archive_asg_locs.' || l_procedure , 20);
3643:
3644: -- set the correct user_entity_id for the archive call
3645: BEGIN
3646: SELECT user_entity_id

Line 3652: hr_utility.trace('User entities SQWL_LOC_MON_* not define contact your system administrator');

3648: FROM ff_user_entities
3649: WHERE user_entity_name = 'A_SQWL_LOC_MON_' || to_char(i);
3650: EXCEPTION
3651: WHEN NO_DATA_FOUND THEN
3652: hr_utility.trace('User entities SQWL_LOC_MON_* not define contact your system administrator');
3653: raise hr_utility.hr_error;
3654: END;
3655:
3656: hr_utility.set_location('archive_asg_locs.' || l_procedure , 30);

Line 3653: raise hr_utility.hr_error;

3649: WHERE user_entity_name = 'A_SQWL_LOC_MON_' || to_char(i);
3650: EXCEPTION
3651: WHEN NO_DATA_FOUND THEN
3652: hr_utility.trace('User entities SQWL_LOC_MON_* not define contact your system administrator');
3653: raise hr_utility.hr_error;
3654: END;
3655:
3656: hr_utility.set_location('archive_asg_locs.' || l_procedure , 30);
3657:

Line 3656: hr_utility.set_location('archive_asg_locs.' || l_procedure , 30);

3652: hr_utility.trace('User entities SQWL_LOC_MON_* not define contact your system administrator');
3653: raise hr_utility.hr_error;
3654: END;
3655:
3656: hr_utility.set_location('archive_asg_locs.' || l_procedure , 30);
3657:
3658: -- Call the create archive item api procedure
3659: ff_archive_api.create_archive_item(
3660: p_archive_item_id => l_archive_item_id

Line 3671: hr_utility.trace('Error occurrecd when creating archive item ');

3667: ,p_some_warning => l_some_warning
3668: );
3669:
3670: IF l_some_warning THEN
3671: hr_utility.trace('Error occurrecd when creating archive item ');
3672: raise hr_utility.hr_error;
3673: END IF;
3674: END IF;
3675:

Line 3672: raise hr_utility.hr_error;

3668: );
3669:
3670: IF l_some_warning THEN
3671: hr_utility.trace('Error occurrecd when creating archive item ');
3672: raise hr_utility.hr_error;
3673: END IF;
3674: END IF;
3675:
3676: END LOOP;

Line 3678: hr_utility.set_location('archive_asg_locs.' || l_procedure , 40);

3674: END IF;
3675:
3676: END LOOP;
3677:
3678: hr_utility.set_location('archive_asg_locs.' || l_procedure , 40);
3679:
3680: -- Process the location id for the end of the period.
3681: OPEN c_asg_loc_end(p_asg_act_id);
3682:

Line 3687: hr_utility.trace('Error occurrecd when creating archive item ');

3683: FETCH c_asg_loc_end INTO l_location_id;
3684:
3685: IF c_asg_loc_end%NOTFOUND THEN
3686: close c_asg_loc_end;
3687: hr_utility.trace('Error occurrecd when creating archive item ');
3688: hr_utility.trace('Error occurrecd : Assignment Location not found for p_asg_act_id ='|| to_char(p_asg_act_id));
3689: raise hr_utility.hr_error;
3690: END IF;
3691: close c_asg_loc_end;

Line 3688: hr_utility.trace('Error occurrecd : Assignment Location not found for p_asg_act_id ='|| to_char(p_asg_act_id));

3684:
3685: IF c_asg_loc_end%NOTFOUND THEN
3686: close c_asg_loc_end;
3687: hr_utility.trace('Error occurrecd when creating archive item ');
3688: hr_utility.trace('Error occurrecd : Assignment Location not found for p_asg_act_id ='|| to_char(p_asg_act_id));
3689: raise hr_utility.hr_error;
3690: END IF;
3691: close c_asg_loc_end;
3692:

Line 3689: raise hr_utility.hr_error;

3685: IF c_asg_loc_end%NOTFOUND THEN
3686: close c_asg_loc_end;
3687: hr_utility.trace('Error occurrecd when creating archive item ');
3688: hr_utility.trace('Error occurrecd : Assignment Location not found for p_asg_act_id ='|| to_char(p_asg_act_id));
3689: raise hr_utility.hr_error;
3690: END IF;
3691: close c_asg_loc_end;
3692:
3693:

Line 3694: hr_utility.set_location('archive_asg_locs.' || l_procedure , 50);

3690: END IF;
3691: close c_asg_loc_end;
3692:
3693:
3694: hr_utility.set_location('archive_asg_locs.' || l_procedure , 50);
3695:
3696: -- set the correct user_entity_id for the archive call
3697: BEGIN
3698: SELECT user_entity_id

Line 3704: hr_utility.trace('User entities A_SQWL_LOC_END_QTR not define contact your system administrator');

3700: FROM ff_user_entities
3701: WHERE user_entity_name = 'A_SQWL_LOC_QTR_END';
3702: EXCEPTION
3703: WHEN NO_DATA_FOUND THEN
3704: hr_utility.trace('User entities A_SQWL_LOC_END_QTR not define contact your system administrator');
3705: raise hr_utility.hr_error;
3706: END;
3707:
3708: hr_utility.set_location('archive_asg_locs.' || l_procedure , 60);

Line 3705: raise hr_utility.hr_error;

3701: WHERE user_entity_name = 'A_SQWL_LOC_QTR_END';
3702: EXCEPTION
3703: WHEN NO_DATA_FOUND THEN
3704: hr_utility.trace('User entities A_SQWL_LOC_END_QTR not define contact your system administrator');
3705: raise hr_utility.hr_error;
3706: END;
3707:
3708: hr_utility.set_location('archive_asg_locs.' || l_procedure , 60);
3709:

Line 3708: hr_utility.set_location('archive_asg_locs.' || l_procedure , 60);

3704: hr_utility.trace('User entities A_SQWL_LOC_END_QTR not define contact your system administrator');
3705: raise hr_utility.hr_error;
3706: END;
3707:
3708: hr_utility.set_location('archive_asg_locs.' || l_procedure , 60);
3709:
3710: -- Call the create archive item api procedure
3711: ff_archive_api.create_archive_item(
3712: p_archive_item_id => l_archive_item_id

Line 3723: hr_utility.trace('Error occurrecd when creating archive item ');

3719: ,p_some_warning => l_some_warning
3720: );
3721:
3722: IF l_some_warning THEN
3723: hr_utility.trace('Error occurrecd when creating archive item ');
3724: hr_utility.trace('Error occurrecd when creating archive item for User entity A_SQWL_LOC_END_QTR');
3725: raise hr_utility.hr_error;
3726: END IF;
3727:

Line 3724: hr_utility.trace('Error occurrecd when creating archive item for User entity A_SQWL_LOC_END_QTR');

3720: );
3721:
3722: IF l_some_warning THEN
3723: hr_utility.trace('Error occurrecd when creating archive item ');
3724: hr_utility.trace('Error occurrecd when creating archive item for User entity A_SQWL_LOC_END_QTR');
3725: raise hr_utility.hr_error;
3726: END IF;
3727:
3728: EXCEPTION

Line 3725: raise hr_utility.hr_error;

3721:
3722: IF l_some_warning THEN
3723: hr_utility.trace('Error occurrecd when creating archive item ');
3724: hr_utility.trace('Error occurrecd when creating archive item for User entity A_SQWL_LOC_END_QTR');
3725: raise hr_utility.hr_error;
3726: END IF;
3727:
3728: EXCEPTION
3729: WHEN OTHERS THEN

Line 3730: hr_utility.trace('Error occurrecd when creating archive item ');

3726: END IF;
3727:
3728: EXCEPTION
3729: WHEN OTHERS THEN
3730: hr_utility.trace('Error occurrecd when creating archive item ');
3731: hr_utility.trace('Error occurrecd when othersof archive_asg_locs ');
3732: raise hr_utility.hr_error;
3733:
3734: END archive_asg_locs;

Line 3731: hr_utility.trace('Error occurrecd when othersof archive_asg_locs ');

3727:
3728: EXCEPTION
3729: WHEN OTHERS THEN
3730: hr_utility.trace('Error occurrecd when creating archive item ');
3731: hr_utility.trace('Error occurrecd when othersof archive_asg_locs ');
3732: raise hr_utility.hr_error;
3733:
3734: END archive_asg_locs;
3735:

Line 3732: raise hr_utility.hr_error;

3728: EXCEPTION
3729: WHEN OTHERS THEN
3730: hr_utility.trace('Error occurrecd when creating archive item ');
3731: hr_utility.trace('Error occurrecd when othersof archive_asg_locs ');
3732: raise hr_utility.hr_error;
3733:
3734: END archive_asg_locs;
3735:
3736:

Line 3793: hr_utility.trace('Selected from pay_payroll_actions ');

3789: l_business_group_id
3790: FROM pay_payroll_actions
3791: WHERE payroll_action_id = pactid;
3792:
3793: hr_utility.trace('Selected from pay_payroll_actions ');
3794:
3795: /* bug: 10649380 : code to check parent payroll action, this code has been added to stop the use
3796: of old sqwl process "State Quarterly Wage Listing", customer need use
3797: new enhanced SQWL Process.

Line 3804: hr_utility.trace('l_parent_payroll_action_id '||l_parent_payroll_action_id);

3800: SELECT pay_us_payroll_utils.get_parameter('TRANSFER_PARENT_PAYROLL_ACTION',legislative_parameters)
3801: INTO l_parent_payroll_action_id
3802: FROM pay_payroll_actions
3803: WHERE payroll_action_id = pactid;
3804: hr_utility.trace('l_parent_payroll_action_id '||l_parent_payroll_action_id);
3805:
3806: IF l_parent_payroll_action_id is NULL THEN
3807: hr_utility.trace('No parent payroll action');
3808: PY_ROLLBACK_PKG.rollback_payroll_action(pactid);

Line 3807: hr_utility.trace('No parent payroll action');

3803: WHERE payroll_action_id = pactid;
3804: hr_utility.trace('l_parent_payroll_action_id '||l_parent_payroll_action_id);
3805:
3806: IF l_parent_payroll_action_id is NULL THEN
3807: hr_utility.trace('No parent payroll action');
3808: PY_ROLLBACK_PKG.rollback_payroll_action(pactid);
3809: commit;
3810: hr_utility.set_message(801, 'PAY_75270_SQWL_NO_PARENT_EXIST');
3811: hr_utility.raise_error;

Line 3810: hr_utility.set_message(801, 'PAY_75270_SQWL_NO_PARENT_EXIST');

3806: IF l_parent_payroll_action_id is NULL THEN
3807: hr_utility.trace('No parent payroll action');
3808: PY_ROLLBACK_PKG.rollback_payroll_action(pactid);
3809: commit;
3810: hr_utility.set_message(801, 'PAY_75270_SQWL_NO_PARENT_EXIST');
3811: hr_utility.raise_error;
3812: END IF;
3813:
3814: SELECT pay_us_payroll_utils.get_parameter('TRANSFER_GRE',legislative_parameters)

Line 3811: hr_utility.raise_error;

3807: hr_utility.trace('No parent payroll action');
3808: PY_ROLLBACK_PKG.rollback_payroll_action(pactid);
3809: commit;
3810: hr_utility.set_message(801, 'PAY_75270_SQWL_NO_PARENT_EXIST');
3811: hr_utility.raise_error;
3812: END IF;
3813:
3814: SELECT pay_us_payroll_utils.get_parameter('TRANSFER_GRE',legislative_parameters)
3815: INTO l_gre

Line 3819: hr_utility.trace('Transferr GRE is '||to_char(l_gre));

3815: INTO l_gre
3816: FROM pay_payroll_actions
3817: WHERE payroll_action_id = pactid;
3818:
3819: hr_utility.trace('Transferr GRE is '||to_char(l_gre));
3820: hr_utility.trace('Report Category is '||l_report_cat);
3821:
3822: /* Bug 1220213 */
3823: /* If New York state and last quarter SQWL, then the date range is full year */

Line 3820: hr_utility.trace('Report Category is '||l_report_cat);

3816: FROM pay_payroll_actions
3817: WHERE payroll_action_id = pactid;
3818:
3819: hr_utility.trace('Transferr GRE is '||to_char(l_gre));
3820: hr_utility.trace('Report Category is '||l_report_cat);
3821:
3822: /* Bug 1220213 */
3823: /* If New York state and last quarter SQWL, then the date range is full year */
3824: if ( l_state = 'NY' and to_char(l_effective_date,'DD-MON') = '31-DEC' ) then

Line 3955: hr_utility.trace('Bulit sqlstr for range ');

3951: END IF;
3952:
3953: end if;
3954:
3955: hr_utility.trace('Bulit sqlstr for range ');
3956:
3957: sqlstr := sqwl_range;
3958:
3959: /* Bug 773937 */

Line 3967: hr_utility.trace('l_from is '||to_char(l_from));

3963: into l_from
3964: from pay_payroll_actions
3965: where payroll_action_id = pactid;
3966:
3967: hr_utility.trace('l_from is '||to_char(l_from));
3968:
3969:
3970: /* End position of state in legislative parameters */
3971:

Line 3977: hr_utility.trace('l_to is '||to_char(l_to));

3973: into l_to
3974: from pay_payroll_actions
3975: where payroll_action_id = pactid;
3976:
3977: hr_utility.trace('l_to is '||to_char(l_to));
3978:
3979: l_length := l_to - l_from - 1 ;
3980:
3981: hr_utility.trace('l_length is '||to_char(l_length));

Line 3981: hr_utility.trace('l_length is '||to_char(l_length));

3977: hr_utility.trace('l_to is '||to_char(l_to));
3978:
3979: l_length := l_to - l_from - 1 ;
3980:
3981: hr_utility.trace('l_length is '||to_char(l_length));
3982:
3983: select fnd_number.canonical_to_number(substr(legislative_parameters, l_from , l_length ))
3984: into l_tax_unit_id
3985: from pay_payroll_actions

Line 3988: hr_utility.trace('Transmitter GRS is '||to_char(l_tax_unit_id));

3984: into l_tax_unit_id
3985: from pay_payroll_actions
3986: where payroll_action_id = pactid;
3987:
3988: hr_utility.trace('Transmitter GRS is '||to_char(l_tax_unit_id));
3989: hr_utility.trace('Report Category is '||l_report_cat);
3990:
3991: /* Commenting this check as there's no need to define W2 reporting rules
3992: for SQWL's except for PR, which checks if a GRE is a PR GRE or not.

Line 3989: hr_utility.trace('Report Category is '||l_report_cat);

3985: from pay_payroll_actions
3986: where payroll_action_id = pactid;
3987:
3988: hr_utility.trace('Transmitter GRS is '||to_char(l_tax_unit_id));
3989: hr_utility.trace('Report Category is '||l_report_cat);
3990:
3991: /* Commenting this check as there's no need to define W2 reporting rules
3992: for SQWL's except for PR, which checks if a GRE is a PR GRE or not.
3993: if l_report_cat in ('RM', 'RTLAQ') then

Line 4005: hr_utility.trace('W2 Reporting rules have not been setup');

4001: message_preprocess := 'SQWL process - W2 Reporting Rules Missing';
4002: message_text := 'Define these for tax unit id '||to_char(l_tax_unit_id);
4003:
4004:
4005: hr_utility.trace('W2 Reporting rules have not been setup');
4006:
4007: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
4008: pay_core_utils.push_token('record_name',message_preprocess);
4009: pay_core_utils.push_token('description',message_text);

Line 4017: hr_utility.trace('Finished with W2 Reporting Rules check ');

4013:
4014: end if;
4015: */
4016:
4017: hr_utility.trace('Finished with W2 Reporting Rules check ');
4018:
4019: l_archive := chk_gre_archive(pactid);
4020:
4021: hr_utility.trace('after gre archive ');

Line 4021: hr_utility.trace('after gre archive ');

4017: hr_utility.trace('Finished with W2 Reporting Rules check ');
4018:
4019: l_archive := chk_gre_archive(pactid);
4020:
4021: hr_utility.trace('after gre archive ');
4022:
4023: if g_archive_flag = 'N' then
4024:
4025: hr_utility.trace('range_cursor archiving employer data');

Line 4025: hr_utility.trace('range_cursor archiving employer data');

4021: hr_utility.trace('after gre archive ');
4022:
4023: if g_archive_flag = 'N' then
4024:
4025: hr_utility.trace('range_cursor archiving employer data');
4026:
4027: archive_gre_data(p_payroll_action_id => pactid,
4028: p_tax_unit_id => l_tax_unit_id);
4029:

Line 4030: hr_utility.trace('range_cursor archiving employer data');

4026:
4027: archive_gre_data(p_payroll_action_id => pactid,
4028: p_tax_unit_id => l_tax_unit_id);
4029:
4030: hr_utility.trace('range_cursor archiving employer data');
4031:
4032: end if;
4033: /* End of Bug 773937 */
4034:

Line 4039: --hr_utility.trace_on(null,'sqwl');

4035: end range_cursor;
4036:
4037: --begin
4038:
4039: --hr_utility.trace_on(null,'sqwl');
4040:
4041: end pay_us_sqwl_archive;