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.

[Home] [Help]

APPS.PAY_US_SQWL_ARCHIVE dependencies on HR_UTILITY

Line 306: raise hr_utility.hr_error;

302: open csr_defined_balance;
303: fetch csr_defined_balance into l_defined_balance_id;
304: if csr_defined_balance%notfound then
305: close csr_defined_balance;
306: raise hr_utility.hr_error;
307: else
308: close csr_defined_balance;
309: end if;
310:

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

448:
449: else
450:
451: /* Default settings for State Quarterly Wage Listing. */
452: hr_utility.set_location ('State',1);
453: p_period_start := p_quarter_start;
454: p_period_end := p_quarter_end;
455: p_defined_balance_id := bal_db_item('SUI_ER_SUBJ_WHABLE_PER_JD_GRE_QTD');
456: p_group_by_gre := TRUE;

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

457: p_group_by_medicare := TRUE;
458: p_tax_unit_context := TRUE;
459: p_jurisdiction_context := TRUE;
460:
461: hr_utility.set_location ('p_period_start -> '|| p_period_start,1);
462: hr_utility.set_location ('p_period_end -> '|| p_period_end,1);
463: hr_utility.set_location ('p_defined_balance -> SUI_ER_SUBJ_WHABLE_PER_JD_GRE_QTD',1);
464: hr_utility.set_location ('p_defined_balance_id -> '|| p_defined_balance_id,1);
465:

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

458: p_tax_unit_context := TRUE;
459: p_jurisdiction_context := TRUE;
460:
461: hr_utility.set_location ('p_period_start -> '|| p_period_start,1);
462: hr_utility.set_location ('p_period_end -> '|| p_period_end,1);
463: hr_utility.set_location ('p_defined_balance -> SUI_ER_SUBJ_WHABLE_PER_JD_GRE_QTD',1);
464: hr_utility.set_location ('p_defined_balance_id -> '|| p_defined_balance_id,1);
465:
466: end if;

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

459: p_jurisdiction_context := TRUE;
460:
461: hr_utility.set_location ('p_period_start -> '|| p_period_start,1);
462: hr_utility.set_location ('p_period_end -> '|| p_period_end,1);
463: hr_utility.set_location ('p_defined_balance -> SUI_ER_SUBJ_WHABLE_PER_JD_GRE_QTD',1);
464: hr_utility.set_location ('p_defined_balance_id -> '|| p_defined_balance_id,1);
465:
466: end if;
467:

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

460:
461: hr_utility.set_location ('p_period_start -> '|| p_period_start,1);
462: hr_utility.set_location ('p_period_end -> '|| p_period_end,1);
463: hr_utility.set_location ('p_defined_balance -> SUI_ER_SUBJ_WHABLE_PER_JD_GRE_QTD',1);
464: hr_utility.set_location ('p_defined_balance_id -> '|| p_defined_balance_id,1);
465:
466: end if;
467:
468: else /* An invalid report type has been passed so fail. */

Line 470: raise hr_utility.hr_error;

466: end if;
467:
468: else /* An invalid report type has been passed so fail. */
469:
470: raise hr_utility.hr_error;
471:
472: end if;
473:
474: end get_selection_information;

Line 504: raise hr_utility.hr_error;

500: open csr_jurisdiction_code;
501: fetch csr_jurisdiction_code into l_jurisdiction_code;
502: if csr_jurisdiction_code%notfound then
503: close csr_jurisdiction_code;
504: raise hr_utility.hr_error;
505: else
506: close csr_jurisdiction_code;
507: end if;
508:

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

554: EXCEPTION when no_data_found then
555: l_resides_true := '0';
556: END;
557:
558: hr_utility.trace('l_resides_true =' || l_resides_true);
559:
560: IF (l_resides_true = '1' AND
561: pay_balance_pkg.get_value(bal_db_item('GROSS_EARNINGS_PER_GRE_QTD'),
562: p_assignment_id, least(p_period_end, p_effective_end_date)) <> 0) THEN

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

560: IF (l_resides_true = '1' AND
561: pay_balance_pkg.get_value(bal_db_item('GROSS_EARNINGS_PER_GRE_QTD'),
562: p_assignment_id, least(p_period_end, p_effective_end_date)) <> 0) THEN
563:
564: hr_utility.trace('Returning TRUE from check_residence_state');
565:
566: RETURN TRUE;
567: ELSE
568: RETURN FALSE;

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

659: return l_user_entity_id;
660:
661: exception
662: when others then
663: hr_utility.trace('Error while getting the user_entity_id'
664: || to_char(sqlcode));
665: raise hr_utility.hr_error;
666:
667: end get_user_entity_id;

Line 665: raise hr_utility.hr_error;

661: exception
662: when others then
663: hr_utility.trace('Error while getting the user_entity_id'
664: || to_char(sqlcode));
665: raise hr_utility.hr_error;
666:
667: end get_user_entity_id;
668:
669: /* Name : action_creation

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

1102:
1103:
1104: --
1105: begin
1106: hr_utility.trace('Entered action creation');
1107:
1108: /* added initalization for l_prev_tax_unit_id */
1109:
1110: l_prev_tax_unit_id := -99999999;

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

1126: from pay_payroll_actions
1127: where payroll_action_id = pactid;
1128:
1129:
1130: hr_utility.set_location ('actio_creation',1);
1131: --
1132: get_dates(l_report_type,
1133: l_effective_date,
1134: l_period_end,

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

1136: l_quarter_end,
1137: l_year_start,
1138: l_year_end);
1139:
1140: hr_utility.set_location ('actio_creation',2);
1141: --
1142: get_selection_information
1143: (l_report_type,
1144: l_state,

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

1153: l_group_by_medicare,
1154: l_tax_unit_context,
1155: l_jurisdiction_context);
1156:
1157: hr_utility.set_location ('actio_creation',3);
1158:
1159: --
1160: -- Get the jurisdiction code for the state if appropriate.
1161: --

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

1218: --
1219:
1220: LOOP
1221: if (l_state = 'LA' and l_report_cat = 'RTLAQ') then
1222: hr_utility.set_location ('actio_creation',4);
1223: if l_person_on then
1224: FETCH c_state_la_quality_person_on INTO l_person_id,
1225: l_assignment_id,
1226: l_tax_unit_id,

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

1234: EXIT WHEN c_state_la_quality%NOTFOUND;
1235: end if ;
1236:
1237: elsif (l_state = 'CT' and l_report_cat = 'RTCTN') then
1238: hr_utility.set_location ('actio_creation',4);
1239: if l_person_on then
1240: FETCH c_ct_non_profit_person_on INTO l_person_id,
1241: l_assignment_id,
1242: l_tax_unit_id,

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

1250: EXIT WHEN c_ct_non_profit%NOTFOUND;
1251: end if ;
1252:
1253: elsif (l_state = 'PR') THEN
1254: hr_utility.set_location ('actio_creation',4);
1255: if l_person_on then
1256: FETCH c_state_pr_person_on INTO l_person_id,
1257: l_assignment_id,
1258: l_tax_unit_id,

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

1266: EXIT WHEN c_state_pr%NOTFOUND;
1267: end if ;
1268:
1269: else
1270: hr_utility.set_location ('actio_creation',5);
1271: -- If it is on then fetch from c_state_person_on cursor else c_state
1272: if l_person_on then
1273: FETCH c_state_person_on INTO l_person_id,
1274: l_assignment_id,

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

1306: -- If the balance is non zero then an assignment action is created to
1307: -- indicate their inclusion in the magnetic tape report.
1308: --
1309: else
1310: hr_utility.set_location ('actio_creation',6);
1311: --
1312: -- Set up contexts required to test the balance.
1313: --
1314: -- Set up TAX_UNIT_ID context if appropriate.

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

1359:
1360:
1361: if (l_value = 0 AND l_state = 'NY') then /*Check for NY Bug:2922028*/
1362:
1363: hr_utility.trace('Entered NY Checking ');
1364:
1365: if instr(to_char(l_quarter_end,'MM'), '12') <> 0 then /*Check for Last Quarter*/
1366:
1367: hr_utility.trace('Last Quarter.Check the values for SIT_SUBJ_NWHABLE_PER_JD_GRE_YTD');

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

1363: hr_utility.trace('Entered NY Checking ');
1364:
1365: if instr(to_char(l_quarter_end,'MM'), '12') <> 0 then /*Check for Last Quarter*/
1366:
1367: hr_utility.trace('Last Quarter.Check the values for SIT_SUBJ_NWHABLE_PER_JD_GRE_YTD');
1368:
1369: l_value := pay_balance_pkg.get_value
1370: (bal_db_item('SIT_SUBJ_NWHABLE_PER_JD_GRE_YTD'),
1371: l_assignment_id,

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

1370: (bal_db_item('SIT_SUBJ_NWHABLE_PER_JD_GRE_YTD'),
1371: l_assignment_id,
1372: least(l_period_end,l_effective_end_date));
1373:
1374: hr_utility.trace('Value of SIT_SUBJ_NWHABLE_PER_JD_GRE_YTD = '||l_value);
1375:
1376: if l_value = 0 then /*Check for SUBJ_WHABLE*/
1377:
1378: hr_utility.trace('Value of SIT_SUBJ_NWHABLE_PER_JD_GRE_YTD is 0');

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

1374: hr_utility.trace('Value of SIT_SUBJ_NWHABLE_PER_JD_GRE_YTD = '||l_value);
1375:
1376: if l_value = 0 then /*Check for SUBJ_WHABLE*/
1377:
1378: hr_utility.trace('Value of SIT_SUBJ_NWHABLE_PER_JD_GRE_YTD is 0');
1379:
1380: If l_effective_end_date < l_quarter_start THEN /*l_effective_end_date checking */
1381: /*Bug:3281209*/
1382:

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

1379:
1380: If l_effective_end_date < l_quarter_start THEN /*l_effective_end_date checking */
1381: /*Bug:3281209*/
1382:
1383: hr_utility.trace('l_effective_end_date < l_quarter_start');
1384: l_value := 0;
1385:
1386: ELSE
1387:

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

1389: (bal_db_item('SUI_ER_SUBJ_WHABLE_PER_JD_GRE_QTD'),
1390: l_assignment_id,
1391: least(l_period_end,l_effective_end_date));
1392:
1393: hr_utility.trace('Value of SUI_ER_SUBJ_WHABLE_PER = '||l_value);
1394:
1395: End if; /*l_effective_end_date checking */
1396:
1397: end if; /*Check for SUBJ_WHABLE*/

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

1403: else
1404: l_value := 0;
1405: end if;
1406:
1407: hr_utility.trace('l_value = ' || to_char(l_value));
1408: hr_utility.trace('l_assignment_id = ' || to_char(l_assignment_id));
1409: hr_utility.trace('l_period_start = ' || l_period_start);
1410: hr_utility.trace('l_quarter_start = ' || l_quarter_start);
1411: hr_utility.trace('l_period_end = ' || l_period_end);

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

1404: l_value := 0;
1405: end if;
1406:
1407: hr_utility.trace('l_value = ' || to_char(l_value));
1408: hr_utility.trace('l_assignment_id = ' || to_char(l_assignment_id));
1409: hr_utility.trace('l_period_start = ' || l_period_start);
1410: hr_utility.trace('l_quarter_start = ' || l_quarter_start);
1411: hr_utility.trace('l_period_end = ' || l_period_end);
1412: hr_utility.trace('l_state = ' || l_state);

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

1405: end if;
1406:
1407: hr_utility.trace('l_value = ' || to_char(l_value));
1408: hr_utility.trace('l_assignment_id = ' || to_char(l_assignment_id));
1409: hr_utility.trace('l_period_start = ' || l_period_start);
1410: hr_utility.trace('l_quarter_start = ' || l_quarter_start);
1411: hr_utility.trace('l_period_end = ' || l_period_end);
1412: hr_utility.trace('l_state = ' || l_state);
1413: hr_utility.trace('l_effective_end_date = ' || l_effective_end_date);

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

1406:
1407: hr_utility.trace('l_value = ' || to_char(l_value));
1408: hr_utility.trace('l_assignment_id = ' || to_char(l_assignment_id));
1409: hr_utility.trace('l_period_start = ' || l_period_start);
1410: hr_utility.trace('l_quarter_start = ' || l_quarter_start);
1411: hr_utility.trace('l_period_end = ' || l_period_end);
1412: hr_utility.trace('l_state = ' || l_state);
1413: hr_utility.trace('l_effective_end_date = ' || l_effective_end_date);
1414: hr_utility.trace('l_1099R_ind = ' || l_1099R_ind);

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

1407: hr_utility.trace('l_value = ' || to_char(l_value));
1408: hr_utility.trace('l_assignment_id = ' || to_char(l_assignment_id));
1409: hr_utility.trace('l_period_start = ' || l_period_start);
1410: hr_utility.trace('l_quarter_start = ' || l_quarter_start);
1411: hr_utility.trace('l_period_end = ' || l_period_end);
1412: hr_utility.trace('l_state = ' || l_state);
1413: hr_utility.trace('l_effective_end_date = ' || l_effective_end_date);
1414: hr_utility.trace('l_1099R_ind = ' || l_1099R_ind);
1415:

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

1408: hr_utility.trace('l_assignment_id = ' || to_char(l_assignment_id));
1409: hr_utility.trace('l_period_start = ' || l_period_start);
1410: hr_utility.trace('l_quarter_start = ' || l_quarter_start);
1411: hr_utility.trace('l_period_end = ' || l_period_end);
1412: hr_utility.trace('l_state = ' || l_state);
1413: hr_utility.trace('l_effective_end_date = ' || l_effective_end_date);
1414: hr_utility.trace('l_1099R_ind = ' || l_1099R_ind);
1415:
1416: if ((l_value <> 0) OR

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

1409: hr_utility.trace('l_period_start = ' || l_period_start);
1410: hr_utility.trace('l_quarter_start = ' || l_quarter_start);
1411: hr_utility.trace('l_period_end = ' || l_period_end);
1412: hr_utility.trace('l_state = ' || l_state);
1413: hr_utility.trace('l_effective_end_date = ' || l_effective_end_date);
1414: hr_utility.trace('l_1099R_ind = ' || l_1099R_ind);
1415:
1416: if ((l_value <> 0) OR
1417: report_person_on_tape(l_assignment_id, l_period_start,

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

1410: hr_utility.trace('l_quarter_start = ' || l_quarter_start);
1411: hr_utility.trace('l_period_end = ' || l_period_end);
1412: hr_utility.trace('l_state = ' || l_state);
1413: hr_utility.trace('l_effective_end_date = ' || l_effective_end_date);
1414: hr_utility.trace('l_1099R_ind = ' || l_1099R_ind);
1415:
1416: if ((l_value <> 0) OR
1417: report_person_on_tape(l_assignment_id, l_period_start,
1418: l_period_end, l_state, l_effective_end_date, l_1099R_ind)) then

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

1415:
1416: if ((l_value <> 0) OR
1417: report_person_on_tape(l_assignment_id, l_period_start,
1418: l_period_end, l_state, l_effective_end_date, l_1099R_ind)) then
1419: hr_utility.set_location ('actio_creation',7);
1420: --
1421: -- Have found a person that needs to be reported in the federal W2 so
1422: -- need to create an assignment action for it.
1423:

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

1447:
1448: FOR c_rec IN c_chk_asg_wp (l_assignment_id)
1449: LOOP
1450: IF c_rec.ct = 0 THEN
1451: hr_utility.set_message(801, 'PAY_7024_USERTAB_BAD_ROW_VALUE');
1452: hr_utility.set_message_token('FORMAT',' wage plan not defined at GRE');
1453: hr_utility.raise_error;
1454: END IF;
1455: END LOOP;

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

1448: FOR c_rec IN c_chk_asg_wp (l_assignment_id)
1449: LOOP
1450: IF c_rec.ct = 0 THEN
1451: hr_utility.set_message(801, 'PAY_7024_USERTAB_BAD_ROW_VALUE');
1452: hr_utility.set_message_token('FORMAT',' wage plan not defined at GRE');
1453: hr_utility.raise_error;
1454: END IF;
1455: END LOOP;
1456:

Line 1453: hr_utility.raise_error;

1449: LOOP
1450: IF c_rec.ct = 0 THEN
1451: hr_utility.set_message(801, 'PAY_7024_USERTAB_BAD_ROW_VALUE');
1452: hr_utility.set_message_token('FORMAT',' wage plan not defined at GRE');
1453: hr_utility.raise_error;
1454: END IF;
1455: END LOOP;
1456:
1457: END IF;

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

1471: --
1472: -- insert into pay_assignment_actions.
1473: hr_nonrun_asact.insact(lockingactid,l_assignment_id,
1474: pactid,chunk,l_tax_unit_id);
1475: hr_utility.set_location ('actio_creation',8);
1476:
1477: archive_asg_locs( lockingactid, pactid, l_assignment_id);
1478:
1479:

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

1512:
1513: /* End of Bug 773937 */
1514:
1515: begin
1516: hr_utility.set_location ('archinit',1);
1517:
1518: -- Derive state
1519: select report_qualifier,
1520: report_category

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

1525:
1526: /* Added the select of report_category field in the above SQL on
1527: 10-FEB-2000 by Ashu Gupta (ashgupta) */
1528:
1529: hr_utility.set_location ('archinit',2);
1530:
1531: -- Get jurisdiction code and store as a context
1532: IF l_state <> 'FED' THEN
1533: SELECT sr.jurisdiction_code

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

1547:
1548: pay_balance_pkg.set_context ('JURISDICTION_CODE',jurisdiction_code);
1549: END IF;
1550: /* Bug 773937 */
1551: hr_utility.set_location ('archinit getting min chunk number',10);
1552: open c_get_min_chunk;
1553: fetch c_get_min_chunk into g_min_chunk;
1554: if c_get_min_chunk%NOTFOUND then
1555: g_min_chunk := -1;

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

1552: open c_get_min_chunk;
1553: fetch c_get_min_chunk into g_min_chunk;
1554: if c_get_min_chunk%NOTFOUND then
1555: g_min_chunk := -1;
1556: hr_utility.set_location ('archinit min chunk is -1',11);
1557: raise hr_utility.hr_error;
1558: end if;
1559: close c_get_min_chunk;
1560:

Line 1557: raise hr_utility.hr_error;

1553: fetch c_get_min_chunk into g_min_chunk;
1554: if c_get_min_chunk%NOTFOUND then
1555: g_min_chunk := -1;
1556: hr_utility.set_location ('archinit min chunk is -1',11);
1557: raise hr_utility.hr_error;
1558: end if;
1559: close c_get_min_chunk;
1560:
1561: /* Check if GRE level data has been archived or not and set the g_archive_flag to Y or N*/

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

1595: exception
1596: when no_data_found then
1597: return(0);
1598: when others then
1599: hr_utility.trace('Error while getting the jursd. value ' ||
1600: to_char(sqlcode));
1601:
1602: end eoy_get_jursd_level;
1603:

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

1646:
1647: exception
1648: when others then
1649: if l_step = 1 then
1650: hr_utility.trace('Error while inserting into ff_archive_items'
1651: || to_char(sqlcode));
1652: raise hr_utility.hr_error;
1653:
1654: elsif l_step = 2 then

Line 1652: raise hr_utility.hr_error;

1648: when others then
1649: if l_step = 1 then
1650: hr_utility.trace('Error while inserting into ff_archive_items'
1651: || to_char(sqlcode));
1652: raise hr_utility.hr_error;
1653:
1654: elsif l_step = 2 then
1655: hr_utility.trace('Error while inserting into ff_archive_item_contexts'
1656: || to_char(sqlcode));

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

1651: || to_char(sqlcode));
1652: raise hr_utility.hr_error;
1653:
1654: elsif l_step = 2 then
1655: hr_utility.trace('Error while inserting into ff_archive_item_contexts'
1656: || to_char(sqlcode));
1657: raise hr_utility.hr_error;
1658:
1659: end if;

Line 1657: raise hr_utility.hr_error;

1653:
1654: elsif l_step = 2 then
1655: hr_utility.trace('Error while inserting into ff_archive_item_contexts'
1656: || to_char(sqlcode));
1657: raise hr_utility.hr_error;
1658:
1659: end if;
1660:
1661: end create_archive;

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

1810: where fai.context1 = p_payroll_action_id
1811: and archive_type = 'PPA'); /* Bug:2965887 */
1812: begin
1813:
1814: hr_utility.trace('chk_gre_archive - checking g_archive_flag');
1815:
1816: if g_archive_flag = 'Y' then
1817: hr_utility.trace('chk_gre_archive - g_archive_flag is Y');
1818: return (TRUE);

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

1813:
1814: hr_utility.trace('chk_gre_archive - checking g_archive_flag');
1815:
1816: if g_archive_flag = 'Y' then
1817: hr_utility.trace('chk_gre_archive - g_archive_flag is Y');
1818: return (TRUE);
1819: else
1820:
1821: hr_utility.trace('chk_gre_archive - opening cursor');

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

1817: hr_utility.trace('chk_gre_archive - g_archive_flag is Y');
1818: return (TRUE);
1819: else
1820:
1821: hr_utility.trace('chk_gre_archive - opening cursor');
1822:
1823: open c_chk_payroll_action;
1824: fetch c_chk_payroll_action into l_flag;
1825: if c_chk_payroll_action%FOUND then

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

1822:
1823: open c_chk_payroll_action;
1824: fetch c_chk_payroll_action into l_flag;
1825: if c_chk_payroll_action%FOUND then
1826: hr_utility.trace('chk_gre_archive - found in cursor');
1827: g_archive_flag := 'Y';
1828: else
1829: hr_utility.trace('chk_gre_archive - not found in cursor');
1830: g_archive_flag := 'N';

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

1825: if c_chk_payroll_action%FOUND then
1826: hr_utility.trace('chk_gre_archive - found in cursor');
1827: g_archive_flag := 'Y';
1828: else
1829: hr_utility.trace('chk_gre_archive - not found in cursor');
1830: g_archive_flag := 'N';
1831: end if;
1832:
1833: hr_utility.trace('chk_gre_archive - closing cursor');

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

1829: hr_utility.trace('chk_gre_archive - not found in cursor');
1830: g_archive_flag := 'N';
1831: end if;
1832:
1833: hr_utility.trace('chk_gre_archive - closing cursor');
1834: close c_chk_payroll_action;
1835: if g_archive_flag = 'Y' then
1836: hr_utility.trace('chk_gre_archive - returning true');
1837: return (TRUE);

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

1832:
1833: hr_utility.trace('chk_gre_archive - closing cursor');
1834: close c_chk_payroll_action;
1835: if g_archive_flag = 'Y' then
1836: hr_utility.trace('chk_gre_archive - returning true');
1837: return (TRUE);
1838: else
1839: hr_utility.trace('chk_gre_archive - returning false');
1840: return(FALSE);

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

1835: if g_archive_flag = 'Y' then
1836: hr_utility.trace('chk_gre_archive - returning true');
1837: return (TRUE);
1838: else
1839: hr_utility.trace('chk_gre_archive - returning false');
1840: return(FALSE);
1841: end if;
1842: end if;
1843: end chk_gre_archive;

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

2098: ORDER BY PAA.ACTION_SEQUENCE DESC;
2099:
2100:
2101: begin
2102: hr_utility.set_location ('archive_data',1);
2103:
2104: SELECT aa.assignment_id,
2105: pay_magtape_generic.date_earned (p_effective_date,aa.assignment_id),
2106: aa.tax_unit_id,

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

2140: -- OPEN c_archive_wage_plan_code_rts;
2141: -- END IF;
2142: --
2143: -- LOOP
2144: -- hr_utility.trace('In Archive Wage Plan Code RTM loop ');
2145: --
2146: -- IF (g_report_cat = 'RTM') THEN
2147: -- FETCH c_archive_wage_plan_code_rtm INTO l_wage_plan_code,
2148: -- l_assignment_id ;

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

2188:
2189: FOR c_rec in c_archive_wage_plan_code
2190: LOOP
2191:
2192: hr_utility.trace('In Archive Wage Plan Code loop ');
2193:
2194: l_wage_plan_code := c_rec.aei_information3;
2195:
2196: INSERT INTO ff_archive_items (archive_item_id,

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

2219:
2220: FOR c_rec in c_gre_wage_plan_code
2221: LOOP
2222:
2223: hr_utility.trace('In Archive GRE Wage Plan Code loop ');
2224:
2225: l_wage_plan_code := c_rec.wage_plan;
2226:
2227: END LOOP;

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

2251: END IF;
2252:
2253:
2254:
2255: hr_utility.set_location ('archive_data',2);
2256: /* Bug 773937 */
2257: /* If the chunk of the assignment is same as the minimun chunk
2258: for the payroll_action_id and the gre data has not yet been
2259: archived then archive the gre data i.e. the employer data */

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

2258: for the payroll_action_id and the gre data has not yet been
2259: archived then archive the gre data i.e. the employer data */
2260:
2261: if l_chunk = g_min_chunk and g_archive_flag = 'N' then
2262: hr_utility.trace('archive_data archiving employer data');
2263: archive_gre_data(p_payroll_action_id => l_payroll_action_id,
2264: p_tax_unit_id => taxunitid);
2265: hr_utility.trace('archive_data archiving employer data');
2266: end if;

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

2261: if l_chunk = g_min_chunk and g_archive_flag = 'N' then
2262: hr_utility.trace('archive_data archiving employer data');
2263: archive_gre_data(p_payroll_action_id => l_payroll_action_id,
2264: p_tax_unit_id => taxunitid);
2265: hr_utility.trace('archive_data archiving employer data');
2266: end if;
2267: /* End of Bug 773937 */
2268:
2269: /* Setup contexts */

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

2296:
2297: open c_get_city;
2298: loop
2299:
2300: hr_utility.trace('In city loop ');
2301:
2302: fetch c_get_city into l_jurisdiction;
2303: exit when c_get_city%NOTFOUND;
2304:

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

2339:
2340: begin
2341: open c_get_latest_asg(asgid );
2342: fetch c_get_latest_asg into aaid,eff_date;
2343: hr_utility.trace('aaid in action creation code'||to_char(aaid));
2344: close c_get_latest_asg;
2345:
2346: exception
2347: when no_data_found then

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

2415: return 'Y';
2416:
2417: EXCEPTION
2418: when OTHERS then
2419: hr_utility.trace('Error while updating ff_archive_items ');
2420: return 'N';
2421: END Update_ff_archive_items;
2422:
2423:

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

2511: l_distinct_wage_plan_code NUMBER := 0 ;
2512:
2513:
2514: BEGIN
2515: hr_utility.set_location('pay_us_sqwl_archive.preprocess_check', 10);
2516:
2517: IF (l_report_cat = 'RTM') THEN
2518:
2519: l_counter := 0;

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

2525:
2526: END LOOP;
2527:
2528: IF (l_counter > 0) THEN
2529: hr_utility.set_location('pay_us_sqwl_archive.preprocess_check', 30);
2530: hr_utility.set_message(801, 'PAY_7024_USERTAB_BAD_ROW_VALUE');
2531: hr_utility.set_message_token('FORMAT', '> 1 row in hoi for wg plcd');
2532: hr_utility.raise_error;
2533: END IF;

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

2526: END LOOP;
2527:
2528: IF (l_counter > 0) THEN
2529: hr_utility.set_location('pay_us_sqwl_archive.preprocess_check', 30);
2530: hr_utility.set_message(801, 'PAY_7024_USERTAB_BAD_ROW_VALUE');
2531: hr_utility.set_message_token('FORMAT', '> 1 row in hoi for wg plcd');
2532: hr_utility.raise_error;
2533: END IF;
2534: END IF;

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

2527:
2528: IF (l_counter > 0) THEN
2529: hr_utility.set_location('pay_us_sqwl_archive.preprocess_check', 30);
2530: hr_utility.set_message(801, 'PAY_7024_USERTAB_BAD_ROW_VALUE');
2531: hr_utility.set_message_token('FORMAT', '> 1 row in hoi for wg plcd');
2532: hr_utility.raise_error;
2533: END IF;
2534: END IF;
2535:

Line 2532: hr_utility.raise_error;

2528: IF (l_counter > 0) THEN
2529: hr_utility.set_location('pay_us_sqwl_archive.preprocess_check', 30);
2530: hr_utility.set_message(801, 'PAY_7024_USERTAB_BAD_ROW_VALUE');
2531: hr_utility.set_message_token('FORMAT', '> 1 row in hoi for wg plcd');
2532: hr_utility.raise_error;
2533: END IF;
2534: END IF;
2535:
2536: IF (l_report_cat = 'RTM') THEN

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

2544:
2545: END LOOP;
2546:
2547: IF l_counter > 0 THEN
2548: hr_utility.set_location('pay_us_sqwl_archive.preprocess_check', 40);
2549: hr_utility.set_message(801, 'PAY_7024_USERTAB_BAD_ROW_VALUE');
2550: hr_utility.set_message_token('FORMAT',' Default Wage Plan not marked');
2551: hr_utility.raise_error;
2552: END IF;

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

2545: END LOOP;
2546:
2547: IF l_counter > 0 THEN
2548: hr_utility.set_location('pay_us_sqwl_archive.preprocess_check', 40);
2549: hr_utility.set_message(801, 'PAY_7024_USERTAB_BAD_ROW_VALUE');
2550: hr_utility.set_message_token('FORMAT',' Default Wage Plan not marked');
2551: hr_utility.raise_error;
2552: END IF;
2553:

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

2546:
2547: IF l_counter > 0 THEN
2548: hr_utility.set_location('pay_us_sqwl_archive.preprocess_check', 40);
2549: hr_utility.set_message(801, 'PAY_7024_USERTAB_BAD_ROW_VALUE');
2550: hr_utility.set_message_token('FORMAT',' Default Wage Plan not marked');
2551: hr_utility.raise_error;
2552: END IF;
2553:
2554: l_counter := 0;

Line 2551: hr_utility.raise_error;

2547: IF l_counter > 0 THEN
2548: hr_utility.set_location('pay_us_sqwl_archive.preprocess_check', 40);
2549: hr_utility.set_message(801, 'PAY_7024_USERTAB_BAD_ROW_VALUE');
2550: hr_utility.set_message_token('FORMAT',' Default Wage Plan not marked');
2551: hr_utility.raise_error;
2552: END IF;
2553:
2554: l_counter := 0;
2555:

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

2560:
2561: END LOOP;
2562:
2563: IF l_counter > 0 THEN
2564: hr_utility.set_location('pay_us_sqwl_archive.preprocess_check', 50);
2565: hr_utility.set_message(801, 'PAY_7024_USERTAB_BAD_ROW_VALUE');
2566: hr_utility.set_message_token('FORMAT',' wage plan not defined at GRE');
2567: hr_utility.raise_error;
2568: END IF;

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

2561: END LOOP;
2562:
2563: IF l_counter > 0 THEN
2564: hr_utility.set_location('pay_us_sqwl_archive.preprocess_check', 50);
2565: hr_utility.set_message(801, 'PAY_7024_USERTAB_BAD_ROW_VALUE');
2566: hr_utility.set_message_token('FORMAT',' wage plan not defined at GRE');
2567: hr_utility.raise_error;
2568: END IF;
2569:

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

2562:
2563: IF l_counter > 0 THEN
2564: hr_utility.set_location('pay_us_sqwl_archive.preprocess_check', 50);
2565: hr_utility.set_message(801, 'PAY_7024_USERTAB_BAD_ROW_VALUE');
2566: hr_utility.set_message_token('FORMAT',' wage plan not defined at GRE');
2567: hr_utility.raise_error;
2568: END IF;
2569:
2570: END IF;

Line 2567: hr_utility.raise_error;

2563: IF l_counter > 0 THEN
2564: hr_utility.set_location('pay_us_sqwl_archive.preprocess_check', 50);
2565: hr_utility.set_message(801, 'PAY_7024_USERTAB_BAD_ROW_VALUE');
2566: hr_utility.set_message_token('FORMAT',' wage plan not defined at GRE');
2567: hr_utility.raise_error;
2568: END IF;
2569:
2570: END IF;
2571: RETURN TRUE;

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

2655: order by paf.effective_end_date desc;
2656:
2657: BEGIN
2658:
2659: hr_utility.set_location('archive_asg_locs.' || l_procedure , 10);
2660: hr_utility.trace('p_asg_act_id = '||to_char(p_asg_act_id));
2661: hr_utility.trace('p_asg_id = '||to_char(p_asg_id));
2662: hr_utility.trace('p_pay_act_id = '||to_char(p_pay_act_id));
2663:

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

2656:
2657: BEGIN
2658:
2659: hr_utility.set_location('archive_asg_locs.' || l_procedure , 10);
2660: hr_utility.trace('p_asg_act_id = '||to_char(p_asg_act_id));
2661: hr_utility.trace('p_asg_id = '||to_char(p_asg_id));
2662: hr_utility.trace('p_pay_act_id = '||to_char(p_pay_act_id));
2663:
2664:

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

2657: BEGIN
2658:
2659: hr_utility.set_location('archive_asg_locs.' || l_procedure , 10);
2660: hr_utility.trace('p_asg_act_id = '||to_char(p_asg_act_id));
2661: hr_utility.trace('p_asg_id = '||to_char(p_asg_id));
2662: hr_utility.trace('p_pay_act_id = '||to_char(p_pay_act_id));
2663:
2664:
2665: FOR i IN 1 .. 3 LOOP

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

2658:
2659: hr_utility.set_location('archive_asg_locs.' || l_procedure , 10);
2660: hr_utility.trace('p_asg_act_id = '||to_char(p_asg_act_id));
2661: hr_utility.trace('p_asg_id = '||to_char(p_asg_id));
2662: hr_utility.trace('p_pay_act_id = '||to_char(p_pay_act_id));
2663:
2664:
2665: FOR i IN 1 .. 3 LOOP
2666: OPEN c_asg_loc_mon(p_asg_act_id,

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

2674: CLOSE c_asg_loc_mon;
2675:
2676: IF l_location_id is not NULL THEN
2677:
2678: hr_utility.set_location('archive_asg_locs.' || l_procedure , 20);
2679:
2680: -- set the correct user_entity_id for the archive call
2681: BEGIN
2682: SELECT user_entity_id

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

2684: FROM ff_user_entities
2685: WHERE user_entity_name = 'A_SQWL_LOC_MON_' || to_char(i);
2686: EXCEPTION
2687: WHEN NO_DATA_FOUND THEN
2688: hr_utility.trace('User entities SQWL_LOC_MON_* not define contact your system administrator');
2689: raise hr_utility.hr_error;
2690: END;
2691:
2692: hr_utility.set_location('archive_asg_locs.' || l_procedure , 30);

Line 2689: raise hr_utility.hr_error;

2685: WHERE user_entity_name = 'A_SQWL_LOC_MON_' || to_char(i);
2686: EXCEPTION
2687: WHEN NO_DATA_FOUND THEN
2688: hr_utility.trace('User entities SQWL_LOC_MON_* not define contact your system administrator');
2689: raise hr_utility.hr_error;
2690: END;
2691:
2692: hr_utility.set_location('archive_asg_locs.' || l_procedure , 30);
2693:

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

2688: hr_utility.trace('User entities SQWL_LOC_MON_* not define contact your system administrator');
2689: raise hr_utility.hr_error;
2690: END;
2691:
2692: hr_utility.set_location('archive_asg_locs.' || l_procedure , 30);
2693:
2694: -- Call the create archive item api procedure
2695: ff_archive_api.create_archive_item(
2696: p_archive_item_id => l_archive_item_id

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

2703: ,p_some_warning => l_some_warning
2704: );
2705:
2706: IF l_some_warning THEN
2707: hr_utility.trace('Error occurrecd when creating archive item ');
2708: raise hr_utility.hr_error;
2709: END IF;
2710: END IF;
2711:

Line 2708: raise hr_utility.hr_error;

2704: );
2705:
2706: IF l_some_warning THEN
2707: hr_utility.trace('Error occurrecd when creating archive item ');
2708: raise hr_utility.hr_error;
2709: END IF;
2710: END IF;
2711:
2712: END LOOP;

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

2710: END IF;
2711:
2712: END LOOP;
2713:
2714: hr_utility.set_location('archive_asg_locs.' || l_procedure , 40);
2715:
2716: -- Process the location id for the end of the period.
2717: OPEN c_asg_loc_end(p_asg_act_id);
2718:

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

2719: FETCH c_asg_loc_end INTO l_location_id;
2720:
2721: IF c_asg_loc_end%NOTFOUND THEN
2722: close c_asg_loc_end;
2723: hr_utility.trace('Error occurrecd when creating archive item ');
2724: hr_utility.trace('Error occurrecd : Assignment Location not found for p_asg_act_id ='|| to_char(p_asg_act_id));
2725: raise hr_utility.hr_error;
2726: END IF;
2727: close c_asg_loc_end;

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

2720:
2721: IF c_asg_loc_end%NOTFOUND THEN
2722: close c_asg_loc_end;
2723: hr_utility.trace('Error occurrecd when creating archive item ');
2724: hr_utility.trace('Error occurrecd : Assignment Location not found for p_asg_act_id ='|| to_char(p_asg_act_id));
2725: raise hr_utility.hr_error;
2726: END IF;
2727: close c_asg_loc_end;
2728:

Line 2725: raise hr_utility.hr_error;

2721: IF c_asg_loc_end%NOTFOUND THEN
2722: close c_asg_loc_end;
2723: hr_utility.trace('Error occurrecd when creating archive item ');
2724: hr_utility.trace('Error occurrecd : Assignment Location not found for p_asg_act_id ='|| to_char(p_asg_act_id));
2725: raise hr_utility.hr_error;
2726: END IF;
2727: close c_asg_loc_end;
2728:
2729:

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

2726: END IF;
2727: close c_asg_loc_end;
2728:
2729:
2730: hr_utility.set_location('archive_asg_locs.' || l_procedure , 50);
2731:
2732: -- set the correct user_entity_id for the archive call
2733: BEGIN
2734: SELECT user_entity_id

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

2736: FROM ff_user_entities
2737: WHERE user_entity_name = 'A_SQWL_LOC_QTR_END';
2738: EXCEPTION
2739: WHEN NO_DATA_FOUND THEN
2740: hr_utility.trace('User entities A_SQWL_LOC_END_QTR not define contact your system administrator');
2741: raise hr_utility.hr_error;
2742: END;
2743:
2744: hr_utility.set_location('archive_asg_locs.' || l_procedure , 60);

Line 2741: raise hr_utility.hr_error;

2737: WHERE user_entity_name = 'A_SQWL_LOC_QTR_END';
2738: EXCEPTION
2739: WHEN NO_DATA_FOUND THEN
2740: hr_utility.trace('User entities A_SQWL_LOC_END_QTR not define contact your system administrator');
2741: raise hr_utility.hr_error;
2742: END;
2743:
2744: hr_utility.set_location('archive_asg_locs.' || l_procedure , 60);
2745:

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

2740: hr_utility.trace('User entities A_SQWL_LOC_END_QTR not define contact your system administrator');
2741: raise hr_utility.hr_error;
2742: END;
2743:
2744: hr_utility.set_location('archive_asg_locs.' || l_procedure , 60);
2745:
2746: -- Call the create archive item api procedure
2747: ff_archive_api.create_archive_item(
2748: p_archive_item_id => l_archive_item_id

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

2755: ,p_some_warning => l_some_warning
2756: );
2757:
2758: IF l_some_warning THEN
2759: hr_utility.trace('Error occurrecd when creating archive item ');
2760: hr_utility.trace('Error occurrecd when creating archive item for User entity A_SQWL_LOC_END_QTR');
2761: raise hr_utility.hr_error;
2762: END IF;
2763:

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

2756: );
2757:
2758: IF l_some_warning THEN
2759: hr_utility.trace('Error occurrecd when creating archive item ');
2760: hr_utility.trace('Error occurrecd when creating archive item for User entity A_SQWL_LOC_END_QTR');
2761: raise hr_utility.hr_error;
2762: END IF;
2763:
2764: EXCEPTION

Line 2761: raise hr_utility.hr_error;

2757:
2758: IF l_some_warning THEN
2759: hr_utility.trace('Error occurrecd when creating archive item ');
2760: hr_utility.trace('Error occurrecd when creating archive item for User entity A_SQWL_LOC_END_QTR');
2761: raise hr_utility.hr_error;
2762: END IF;
2763:
2764: EXCEPTION
2765: WHEN OTHERS THEN

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

2762: END IF;
2763:
2764: EXCEPTION
2765: WHEN OTHERS THEN
2766: hr_utility.trace('Error occurrecd when creating archive item ');
2767: hr_utility.trace('Error occurrecd when othersof archive_asg_locs ');
2768: raise hr_utility.hr_error;
2769:
2770: END archive_asg_locs;

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

2763:
2764: EXCEPTION
2765: WHEN OTHERS THEN
2766: hr_utility.trace('Error occurrecd when creating archive item ');
2767: hr_utility.trace('Error occurrecd when othersof archive_asg_locs ');
2768: raise hr_utility.hr_error;
2769:
2770: END archive_asg_locs;
2771:

Line 2768: raise hr_utility.hr_error;

2764: EXCEPTION
2765: WHEN OTHERS THEN
2766: hr_utility.trace('Error occurrecd when creating archive item ');
2767: hr_utility.trace('Error occurrecd when othersof archive_asg_locs ');
2768: raise hr_utility.hr_error;
2769:
2770: END archive_asg_locs;
2771:
2772:

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

2823: l_business_group_id
2824: FROM pay_payroll_actions
2825: WHERE payroll_action_id = pactid;
2826:
2827: hr_utility.trace('Selected from pay_payroll_actions ');
2828:
2829: /* Bug 1220213 */
2830: /* If New York state and last quarter SQWL, then the date range is full year */
2831: if ( l_state = 'NY' and to_char(l_effective_date,'DD-MON') = '31-DEC' ) then

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

2955: END IF;
2956:
2957: end if;
2958:
2959: hr_utility.trace('Bulit sqlstr for range ');
2960:
2961: sqlstr := sqwl_range;
2962:
2963: /* Bug 773937 */

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

2967: into l_from
2968: from pay_payroll_actions
2969: where payroll_action_id = pactid;
2970:
2971: hr_utility.trace('l_from is '||to_char(l_from));
2972:
2973:
2974: /* End position of state in legislative parameters */
2975:

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

2977: into l_to
2978: from pay_payroll_actions
2979: where payroll_action_id = pactid;
2980:
2981: hr_utility.trace('l_to is '||to_char(l_to));
2982:
2983: l_length := l_to - l_from - 1 ;
2984:
2985: hr_utility.trace('l_length is '||to_char(l_length));

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

2981: hr_utility.trace('l_to is '||to_char(l_to));
2982:
2983: l_length := l_to - l_from - 1 ;
2984:
2985: hr_utility.trace('l_length is '||to_char(l_length));
2986:
2987: select fnd_number.canonical_to_number(substr(legislative_parameters, l_from , l_length ))
2988: into l_tax_unit_id
2989: from pay_payroll_actions

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

2988: into l_tax_unit_id
2989: from pay_payroll_actions
2990: where payroll_action_id = pactid;
2991:
2992: hr_utility.trace('Transmitter GRS is '||to_char(l_tax_unit_id));
2993: hr_utility.trace('Report Category is '||l_report_cat);
2994:
2995: /* Commenting this check as there's no need to define W2 reporting rules
2996: for SQWL's except for PR, which checks if a GRE is a PR GRE or not.

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

2989: from pay_payroll_actions
2990: where payroll_action_id = pactid;
2991:
2992: hr_utility.trace('Transmitter GRS is '||to_char(l_tax_unit_id));
2993: hr_utility.trace('Report Category is '||l_report_cat);
2994:
2995: /* Commenting this check as there's no need to define W2 reporting rules
2996: for SQWL's except for PR, which checks if a GRE is a PR GRE or not.
2997: if l_report_cat in ('RM', 'RTLAQ') then

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

3005: message_preprocess := 'SQWL process - W2 Reporting Rules Missing';
3006: message_text := 'Define these for tax unit id '||to_char(l_tax_unit_id);
3007:
3008:
3009: hr_utility.trace('W2 Reporting rules have not been setup');
3010:
3011: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
3012: pay_core_utils.push_token('record_name',message_preprocess);
3013: pay_core_utils.push_token('description',message_text);

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

3017:
3018: end if;
3019: */
3020:
3021: hr_utility.trace('Finished with W2 Reporting Rules check ');
3022:
3023: l_archive := chk_gre_archive(pactid);
3024:
3025: hr_utility.trace('after gre archive ');

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

3021: hr_utility.trace('Finished with W2 Reporting Rules check ');
3022:
3023: l_archive := chk_gre_archive(pactid);
3024:
3025: hr_utility.trace('after gre archive ');
3026:
3027: if g_archive_flag = 'N' then
3028:
3029: hr_utility.trace('range_cursor archiving employer data');

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

3025: hr_utility.trace('after gre archive ');
3026:
3027: if g_archive_flag = 'N' then
3028:
3029: hr_utility.trace('range_cursor archiving employer data');
3030:
3031: archive_gre_data(p_payroll_action_id => pactid,
3032: p_tax_unit_id => l_tax_unit_id);
3033:

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

3030:
3031: archive_gre_data(p_payroll_action_id => pactid,
3032: p_tax_unit_id => l_tax_unit_id);
3033:
3034: hr_utility.trace('range_cursor archiving employer data');
3035:
3036: end if;
3037: /* End of Bug 773937 */
3038:

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

3039: end range_cursor;
3040:
3041: --begin
3042:
3043: --hr_utility.trace_on(null,'sqwl');
3044:
3045: end pay_us_sqwl_archive;