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

APPS.PAY_CA_WF_PKG dependencies on WF_CORE

Line 1652: lv_prc_list := lv_prc_list||lv_conc_prog_name(1)||wf_core.newline;

1648:
1649: -- BEE Transfer
1650: if p_batch_id is not null then
1651: lv_is_batch := 'Y';
1652: lv_prc_list := lv_prc_list||lv_conc_prog_name(1)||wf_core.newline;
1653: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS01';
1654: else
1655: lv_is_batch := 'N';
1656: end if;

Line 1664: lv_prc_list := lv_prc_list||lv_conc_prog_name(2)||wf_core.newline;

1660: if ((p_retro_assignment_set is not null) and
1661: (p_retro_event_group is not null)) then
1662:
1663: lv_is_retro_notification := 'Y';
1664: lv_prc_list := lv_prc_list||lv_conc_prog_name(2)||wf_core.newline;
1665: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS02';
1666:
1667: -- If the Retro Notification is going to be run
1668: -- then the RetroPay assignment set should be the

Line 1684: lv_prc_list := lv_prc_list||lv_conc_prog_name(3)||wf_core.newline;

1680: (p_retro_assignment_set is not null)) and
1681: (p_retropay_element_set is not null) and
1682: (p_retro_start_date is not null)) then
1683: lv_is_retropay := 'Y';
1684: lv_prc_list := lv_prc_list||lv_conc_prog_name(3)||wf_core.newline;
1685: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS03';
1686: else
1687: lv_is_retropay := 'N';
1688: end if;

Line 1690: lv_prc_list := lv_prc_list||lv_conc_prog_name(4)||wf_core.newline;

1686: else
1687: lv_is_retropay := 'N';
1688: end if;
1689:
1690: lv_prc_list := lv_prc_list||lv_conc_prog_name(4)||wf_core.newline;
1691: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS04';
1692:
1693: -- Gross to Net Summary
1694:

Line 1697: lv_prc_list := lv_prc_list||lv_conc_prog_name(5)||wf_core.newline;

1693: -- Gross to Net Summary
1694:
1695: if ((p_gross_to_net_period is not null)) then
1696: lv_is_gtn := 'Y';
1697: lv_prc_list := lv_prc_list||lv_conc_prog_name(5)||wf_core.newline;
1698: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS05';
1699: else
1700: lv_is_gtn := 'N';
1701: end if;

Line 1703: lv_prc_list := lv_prc_list||lv_conc_prog_name(6)||wf_core.newline;

1699: else
1700: lv_is_gtn := 'N';
1701: end if;
1702:
1703: lv_prc_list := lv_prc_list||lv_conc_prog_name(6)||wf_core.newline;
1704: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS06';
1705:
1706: -- Employee Assignments Not Paid
1707: if ((p_consolidation_set_id is not null)) then

Line 1709: lv_prc_list := lv_prc_list||lv_conc_prog_name(7)||wf_core.newline;

1705:
1706: -- Employee Assignments Not Paid
1707: if ((p_consolidation_set_id is not null)) then
1708: lv_is_consolidation_set := 'Y';
1709: lv_prc_list := lv_prc_list||lv_conc_prog_name(7)||wf_core.newline;
1710: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS07';
1711: else
1712: lv_is_consolidation_set := 'N';
1713: end if;

Line 1720: lv_prc_list := lv_prc_list||lv_conc_prog_name(8)||wf_core.newline;

1716: if ((p_consolidation_set_id is not null) and
1717: ((p_exp_report_name is not null) or
1718: (p_exp_group_name is not null))) then
1719: lv_is_exception := 'Y';
1720: lv_prc_list := lv_prc_list||lv_conc_prog_name(8)||wf_core.newline;
1721: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS08';
1722: else
1723: lv_is_exception := 'N';
1724: end if;

Line 1731: lv_prc_list := lv_prc_list||lv_conc_prog_name(9)||wf_core.newline;

1727:
1728: if ((p_sdr_federal is not null) and
1729: (p_sdr_reporting_dimension is not null)) then
1730: lv_is_sdr := 'Y';
1731: lv_prc_list := lv_prc_list||lv_conc_prog_name(9)||wf_core.newline;
1732: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS09';
1733: else
1734: lv_is_sdr := 'N';
1735: end if;

Line 1740: lv_prc_list := lv_prc_list||lv_conc_prog_name(10)||wf_core.newline;

1736:
1737: -- Quebec Health Services Fund
1738:
1739: if (p_quebec = 'Y') then
1740: lv_prc_list := lv_prc_list||lv_conc_prog_name(10)||wf_core.newline;
1741: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS10';
1742: end if;
1743:
1744:

Line 1748: lv_prc_list := lv_prc_list||lv_conc_prog_name(11)||wf_core.newline;

1744:
1745: -- Pre Payment
1746:
1747: if (p_consolidation_set_id is not null) then
1748: lv_prc_list := lv_prc_list||lv_conc_prog_name(11)||wf_core.newline;
1749: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS11';
1750: end if;
1751:
1752:

Line 1760: lv_prc_list := lv_prc_list||lv_conc_prog_name(12)||wf_core.newline;

1756: (p_reg_suppress_zero is not null) and
1757: (p_reg_req_num is not null) and
1758: (p_reg_reporting_dim is not null)) then
1759: lv_is_payroll_register := 'Y';
1760: lv_prc_list := lv_prc_list||lv_conc_prog_name(12)||wf_core.newline;
1761: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS12';
1762: else
1763: lv_is_payroll_register := 'N';
1764: end if;

Line 1771: lv_prc_list := lv_prc_list||lv_conc_prog_name(13)||wf_core.newline;

1767:
1768: if (p_ele_selection_criterion is not null)
1769: then
1770: lv_is_element_register := 'Y';
1771: lv_prc_list := lv_prc_list||lv_conc_prog_name(13)||wf_core.newline;
1772: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS13';
1773: else
1774: lv_is_element_register := 'N';
1775: end if;

Line 1784: lv_prc_list := lv_prc_list||lv_conc_prog_name(14)||wf_core.newline;

1780: (p_deduction_sort_two is not null) and
1781: (p_deduction_sort_three is not null))
1782: then
1783: lv_is_deductions := 'Y';
1784: lv_prc_list := lv_prc_list||lv_conc_prog_name(14)||wf_core.newline;
1785: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS14';
1786: else
1787: lv_is_deductions := 'N';
1788: end if;

Line 1796: lv_prc_list := lv_prc_list||lv_conc_prog_name(15)||wf_core.newline;

1792: if ((p_consolidation_set_id is not null) and
1793: (p_dd_payment_method is not null))
1794: then
1795: lv_is_direct_deposit := 'Y';
1796: lv_prc_list := lv_prc_list||lv_conc_prog_name(15)||wf_core.newline;
1797: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS15';
1798: else
1799: lv_is_direct_deposit := 'N';
1800: end if;

Line 1806: lv_prc_list := lv_prc_list||lv_conc_prog_name(16)||wf_core.newline;

1802:
1803: -- Canadian Payroll Archiver
1804:
1805: if (p_consolidation_set_id is not null) then
1806: lv_prc_list := lv_prc_list||lv_conc_prog_name(16)||wf_core.newline;
1807: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS16';
1808: end if;
1809:
1810:

Line 1820: lv_prc_list := lv_prc_list||lv_conc_prog_name(17)||wf_core.newline;

1816: (p_cheque_sort_sequence is not null) and
1817: (p_cheque_style is not null) and
1818: (p_start_cheque_number is not null)) then
1819: lv_is_chequewriter := 'Y';
1820: lv_prc_list := lv_prc_list||lv_conc_prog_name(17)||wf_core.newline;
1821: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS17';
1822: else
1823: lv_is_chequewriter := 'N';
1824: end if;

Line 1831: lv_prc_list := lv_prc_list||lv_conc_prog_name(18)||wf_core.newline;

1827:
1828: if ((p_da_data_type is not null) and
1829: (p_consolidation_set_id is not null)) then
1830: lv_is_deposit_advice := 'Y';
1831: lv_prc_list := lv_prc_list||lv_conc_prog_name(18)||wf_core.newline;
1832: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS18';
1833: else
1834: lv_is_deposit_advice := 'N';
1835: end if;

Line 1840: lv_prc_list := lv_prc_list||lv_conc_prog_name(19)||wf_core.newline;

1836:
1837: -- Payment Report
1838:
1839: if (p_consolidation_set_id is not null) then
1840: lv_prc_list := lv_prc_list||lv_conc_prog_name(19)||wf_core.newline;
1841: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS19';
1842: end if;
1843:
1844: -- Record of Employment

Line 1848: lv_prc_list := lv_prc_list||lv_conc_prog_name(20)||wf_core.newline;

1844: -- Record of Employment
1845:
1846: if ((p_roe_assignment_set is not null)) then
1847: lv_is_roe := 'Y';
1848: lv_prc_list := lv_prc_list||lv_conc_prog_name(20)||wf_core.newline;
1849: lv_prc_list := lv_prc_list||lv_conc_prog_name(21)||wf_core.newline;
1850: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS20';
1851: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS21';
1852:

Line 1849: lv_prc_list := lv_prc_list||lv_conc_prog_name(21)||wf_core.newline;

1845:
1846: if ((p_roe_assignment_set is not null)) then
1847: lv_is_roe := 'Y';
1848: lv_prc_list := lv_prc_list||lv_conc_prog_name(20)||wf_core.newline;
1849: lv_prc_list := lv_prc_list||lv_conc_prog_name(21)||wf_core.newline;
1850: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS20';
1851: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS21';
1852:
1853: if (p_roe_mag_roe_type is not null) then

Line 1855: lv_prc_list := lv_prc_list||lv_conc_prog_name(22)||wf_core.newline;

1851: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS21';
1852:
1853: if (p_roe_mag_roe_type is not null) then
1854: lv_is_roe_mag := 'Y';
1855: lv_prc_list := lv_prc_list||lv_conc_prog_name(22)||wf_core.newline;
1856: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS22';
1857: else
1858: lv_is_roe_mag := 'N';
1859: end if;

Line 1868: lv_prc_list := lv_prc_list||lv_conc_prog_name(23)||wf_core.newline;

1864:
1865: -- Costing
1866:
1867: if ((p_consolidation_set_id is not null)) then
1868: lv_prc_list := lv_prc_list||lv_conc_prog_name(23)||wf_core.newline;
1869: lv_prc_list := lv_prc_list||lv_conc_prog_name(24)||wf_core.newline;
1870: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS23';
1871: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS24';
1872:

Line 1869: lv_prc_list := lv_prc_list||lv_conc_prog_name(24)||wf_core.newline;

1865: -- Costing
1866:
1867: if ((p_consolidation_set_id is not null)) then
1868: lv_prc_list := lv_prc_list||lv_conc_prog_name(23)||wf_core.newline;
1869: lv_prc_list := lv_prc_list||lv_conc_prog_name(24)||wf_core.newline;
1870: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS23';
1871: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS24';
1872:
1873: if (p_cost_summary_file_out is not null) then

Line 1875: lv_prc_list := lv_prc_list||lv_conc_prog_name(25)||wf_core.newline;

1871: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS24';
1872:
1873: if (p_cost_summary_file_out is not null) then
1874: lv_is_costing_summary := 'Y';
1875: lv_prc_list := lv_prc_list||lv_conc_prog_name(25)||wf_core.newline;
1876: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS25';
1877: else
1878: lv_is_costing_summary := 'N';
1879: end if;

Line 1888: lv_process_list_text := 'Review the List of Processes and Reports which will be submitted based on the input parameters, please click on the '||''''||'Continue'||''''||' button to start processing.'||wf_core.newline||wf_core.newline||lv_prc_list;

1884: lv_process_list_subject := 'List of Processes and Reports which will be submitted';
1885:
1886: if lv_workflow_mode = 'W' then
1887:
1888: lv_process_list_text := 'Review the List of Processes and Reports which will be submitted based on the input parameters, please click on the '||''''||'Continue'||''''||' button to start processing.'||wf_core.newline||wf_core.newline||lv_prc_list;
1889:
1890: lv_process_list_html_1 := 'Review the List of Processes and Reports which will be submitted based on the input parameters, please click on the '||''''||'Continue'||''''||' button to start processing.';
1891:
1892: else

Line 1894: lv_process_list_text := 'Review the List of Processes and Reports which will be submitted based on the input parameters.'||wf_core.newline||wf_core.newline||lv_prc_list;

1890: lv_process_list_html_1 := 'Review the List of Processes and Reports which will be submitted based on the input parameters, please click on the '||''''||'Continue'||''''||' button to start processing.';
1891:
1892: else
1893:
1894: lv_process_list_text := 'Review the List of Processes and Reports which will be submitted based on the input parameters.'||wf_core.newline||wf_core.newline||lv_prc_list;
1895:
1896: lv_process_list_html_1 := 'Review the List of Processes and Reports which will be submitted based on the input parameters.';
1897:
1898: end if;

Line 2687: wf_core.Context('pay_ca_wf_pkg',

2683:
2684:
2685: exception
2686: when others then
2687: wf_core.Context('pay_ca_wf_pkg',
2688: 'StartProcess',
2689: ItemType,
2690: RequestorUsername,
2691: ProcessOwner,

Line 3788: lv_prc_list := lv_prc_list||lv_conc_prog_name(1)||wf_core.newline;

3784:
3785: -- BEE Transfer
3786: if p_batch_id is not null then
3787: lv_is_batch := 'Y';
3788: lv_prc_list := lv_prc_list||lv_conc_prog_name(1)||wf_core.newline;
3789: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS01';
3790: else
3791: lv_is_batch := 'N';
3792: end if;

Line 3800: lv_prc_list := lv_prc_list||lv_conc_prog_name(2)||wf_core.newline;

3796: /* if ((p_retro_assignment_set is not null) and
3797: (p_retro_event_group is not null)) then
3798:
3799: lv_is_retro_notification := 'Y';
3800: lv_prc_list := lv_prc_list||lv_conc_prog_name(2)||wf_core.newline;
3801: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS02';
3802:
3803: -- If the Retro Notification is going to be run
3804: -- then the RetroPay assignment set should be the

Line 3817: lv_prc_list := lv_prc_list||lv_conc_prog_name(2)||wf_core.newline;

3813: -- bug 12704242
3814: if (p_retro_template_name is not null) then
3815:
3816: lv_is_retro_notification := 'Y';
3817: lv_prc_list := lv_prc_list||lv_conc_prog_name(2)||wf_core.newline;
3818: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS02';
3819:
3820: -- If the Retro Notification is going to be run
3821: -- then the RetroPay assignment set should be the

Line 3837: lv_prc_list := lv_prc_list||lv_conc_prog_name(3)||wf_core.newline;

3833: (p_retro_assignment_set is not null)) and
3834: (p_retropay_element_set is not null) and
3835: (p_retro_start_date is not null)) then
3836: lv_is_retropay := 'Y';
3837: lv_prc_list := lv_prc_list||lv_conc_prog_name(3)||wf_core.newline;
3838: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS03';
3839: else
3840: lv_is_retropay := 'N';
3841: end if;

Line 3843: lv_prc_list := lv_prc_list||lv_conc_prog_name(4)||wf_core.newline;

3839: else
3840: lv_is_retropay := 'N';
3841: end if;
3842:
3843: lv_prc_list := lv_prc_list||lv_conc_prog_name(4)||wf_core.newline;
3844: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS04';*/
3845:
3846: -- RetroPay (enhanced)
3847: -- bug 12704242

Line 3851: lv_prc_list := lv_prc_list||lv_conc_prog_name(3)||wf_core.newline;

3847: -- bug 12704242
3848:
3849: if (lv_is_retro_notification = 'Y') then
3850: lv_is_retropay := 'Y';
3851: lv_prc_list := lv_prc_list||lv_conc_prog_name(3)||wf_core.newline;
3852: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS03';
3853: else
3854: lv_is_retropay := 'N';
3855: end if;

Line 3857: lv_prc_list := lv_prc_list||lv_conc_prog_name(4)||wf_core.newline;

3853: else
3854: lv_is_retropay := 'N';
3855: end if;
3856:
3857: lv_prc_list := lv_prc_list||lv_conc_prog_name(4)||wf_core.newline;
3858: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS04';
3859:
3860: -- Gross to Net Summary
3861:

Line 3864: lv_prc_list := lv_prc_list||lv_conc_prog_name(5)||wf_core.newline;

3860: -- Gross to Net Summary
3861:
3862: if ((p_gross_to_net_period is not null)) then
3863: lv_is_gtn := 'Y';
3864: lv_prc_list := lv_prc_list||lv_conc_prog_name(5)||wf_core.newline;
3865: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS05';
3866: else
3867: lv_is_gtn := 'N';
3868: end if;

Line 3870: lv_prc_list := lv_prc_list||lv_conc_prog_name(6)||wf_core.newline;

3866: else
3867: lv_is_gtn := 'N';
3868: end if;
3869:
3870: lv_prc_list := lv_prc_list||lv_conc_prog_name(6)||wf_core.newline;
3871: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS06';
3872:
3873: -- Employee Assignments Not Paid
3874: if ((p_consolidation_set_id is not null)) then

Line 3876: lv_prc_list := lv_prc_list||lv_conc_prog_name(7)||wf_core.newline;

3872:
3873: -- Employee Assignments Not Paid
3874: if ((p_consolidation_set_id is not null)) then
3875: lv_is_consolidation_set := 'Y';
3876: lv_prc_list := lv_prc_list||lv_conc_prog_name(7)||wf_core.newline;
3877: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS07';
3878: else
3879: lv_is_consolidation_set := 'N';
3880: end if;

Line 3887: lv_prc_list := lv_prc_list||lv_conc_prog_name(8)||wf_core.newline;

3883: if ((p_consolidation_set_id is not null) and
3884: ((p_exp_report_name is not null) or
3885: (p_exp_group_name is not null))) then
3886: lv_is_exception := 'Y';
3887: lv_prc_list := lv_prc_list||lv_conc_prog_name(8)||wf_core.newline;
3888: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS08';
3889: else
3890: lv_is_exception := 'N';
3891: end if;

Line 3898: lv_prc_list := lv_prc_list||lv_conc_prog_name(9)||wf_core.newline;

3894:
3895: if ((p_sdr_federal is not null) and
3896: (p_sdr_reporting_dimension is not null)) then
3897: lv_is_sdr := 'Y';
3898: lv_prc_list := lv_prc_list||lv_conc_prog_name(9)||wf_core.newline;
3899: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS09';
3900: else
3901: lv_is_sdr := 'N';
3902: end if;

Line 3907: lv_prc_list := lv_prc_list||lv_conc_prog_name(10)||wf_core.newline;

3903:
3904: -- Quebec Health Services Fund
3905:
3906: if (p_quebec = 'Y') then
3907: lv_prc_list := lv_prc_list||lv_conc_prog_name(10)||wf_core.newline;
3908: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS10';
3909: end if;
3910:
3911:

Line 3915: lv_prc_list := lv_prc_list||lv_conc_prog_name(11)||wf_core.newline;

3911:
3912: -- Pre Payment
3913:
3914: if (p_consolidation_set_id is not null) then
3915: lv_prc_list := lv_prc_list||lv_conc_prog_name(11)||wf_core.newline;
3916: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS11';
3917: end if;
3918:
3919:

Line 3927: lv_prc_list := lv_prc_list||lv_conc_prog_name(12)||wf_core.newline;

3923: (p_reg_suppress_zero is not null) and
3924: (p_reg_req_num is not null) and
3925: (p_reg_reporting_dim is not null)) then
3926: lv_is_payroll_register := 'Y';
3927: lv_prc_list := lv_prc_list||lv_conc_prog_name(12)||wf_core.newline;
3928: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS12';
3929: else
3930: lv_is_payroll_register := 'N';
3931: end if;

Line 3938: lv_prc_list := lv_prc_list||lv_conc_prog_name(13)||wf_core.newline;

3934:
3935: if (p_ele_selection_criterion is not null)
3936: then
3937: lv_is_element_register := 'Y';
3938: lv_prc_list := lv_prc_list||lv_conc_prog_name(13)||wf_core.newline;
3939: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS13';
3940: else
3941: lv_is_element_register := 'N';
3942: end if;

Line 3951: lv_prc_list := lv_prc_list||lv_conc_prog_name(14)||wf_core.newline;

3947: (p_deduction_sort_two is not null) and
3948: (p_deduction_sort_three is not null))
3949: then
3950: lv_is_deductions := 'Y';
3951: lv_prc_list := lv_prc_list||lv_conc_prog_name(14)||wf_core.newline;
3952: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS14';
3953: else
3954: lv_is_deductions := 'N';
3955: end if;

Line 3963: lv_prc_list := lv_prc_list||lv_conc_prog_name(15)||wf_core.newline;

3959: if ((p_consolidation_set_id is not null) and
3960: (p_dd_payment_method is not null))
3961: then
3962: lv_is_direct_deposit := 'Y';
3963: lv_prc_list := lv_prc_list||lv_conc_prog_name(15)||wf_core.newline;
3964: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS15';
3965: else
3966: lv_is_direct_deposit := 'N';
3967: end if;

Line 3973: lv_prc_list := lv_prc_list||lv_conc_prog_name(16)||wf_core.newline;

3969:
3970: -- Canadian Payroll Archiver
3971:
3972: if (p_consolidation_set_id is not null) then
3973: lv_prc_list := lv_prc_list||lv_conc_prog_name(16)||wf_core.newline;
3974: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS16';
3975: end if;
3976:
3977:

Line 3987: lv_prc_list := lv_prc_list||lv_conc_prog_name(17)||wf_core.newline;

3983: (p_cheque_sort_sequence is not null) and
3984: (p_cheque_style is not null) and
3985: (p_start_cheque_number is not null)) then
3986: lv_is_chequewriter := 'Y';
3987: lv_prc_list := lv_prc_list||lv_conc_prog_name(17)||wf_core.newline;
3988: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS17';
3989: else
3990: lv_is_chequewriter := 'N';
3991: end if;

Line 3998: lv_prc_list := lv_prc_list||lv_conc_prog_name(18)||wf_core.newline;

3994:
3995: if ((p_da_data_type is not null) and
3996: (p_consolidation_set_id is not null)) then
3997: lv_is_deposit_advice := 'Y';
3998: lv_prc_list := lv_prc_list||lv_conc_prog_name(18)||wf_core.newline;
3999: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS18';
4000: else
4001: lv_is_deposit_advice := 'N';
4002: end if;

Line 4007: lv_prc_list := lv_prc_list||lv_conc_prog_name(19)||wf_core.newline;

4003:
4004: -- Payment Report
4005:
4006: if (p_consolidation_set_id is not null) then
4007: lv_prc_list := lv_prc_list||lv_conc_prog_name(19)||wf_core.newline;
4008: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS19';
4009: end if;
4010:
4011: -- Record of Employment

Line 4015: lv_prc_list := lv_prc_list||lv_conc_prog_name(20)||wf_core.newline;

4011: -- Record of Employment
4012:
4013: if ((p_roe_assignment_set is not null)) then
4014: lv_is_roe := 'Y';
4015: lv_prc_list := lv_prc_list||lv_conc_prog_name(20)||wf_core.newline;
4016: lv_prc_list := lv_prc_list||lv_conc_prog_name(21)||wf_core.newline;
4017: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS20';
4018: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS21';
4019:

Line 4016: lv_prc_list := lv_prc_list||lv_conc_prog_name(21)||wf_core.newline;

4012:
4013: if ((p_roe_assignment_set is not null)) then
4014: lv_is_roe := 'Y';
4015: lv_prc_list := lv_prc_list||lv_conc_prog_name(20)||wf_core.newline;
4016: lv_prc_list := lv_prc_list||lv_conc_prog_name(21)||wf_core.newline;
4017: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS20';
4018: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS21';
4019:
4020: if (p_roe_mag_roe_type is not null) then

Line 4022: lv_prc_list := lv_prc_list||lv_conc_prog_name(22)||wf_core.newline;

4018: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS21';
4019:
4020: if (p_roe_mag_roe_type is not null) then
4021: lv_is_roe_mag := 'Y';
4022: lv_prc_list := lv_prc_list||lv_conc_prog_name(22)||wf_core.newline;
4023: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS22';
4024: else
4025: lv_is_roe_mag := 'N';
4026: end if;

Line 4035: lv_prc_list := lv_prc_list||lv_conc_prog_name(23)||wf_core.newline;

4031:
4032: -- Costing
4033:
4034: if ((p_consolidation_set_id is not null)) then
4035: lv_prc_list := lv_prc_list||lv_conc_prog_name(23)||wf_core.newline;
4036: lv_prc_list := lv_prc_list||lv_conc_prog_name(24)||wf_core.newline;
4037: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS23';
4038: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS24';
4039:

Line 4036: lv_prc_list := lv_prc_list||lv_conc_prog_name(24)||wf_core.newline;

4032: -- Costing
4033:
4034: if ((p_consolidation_set_id is not null)) then
4035: lv_prc_list := lv_prc_list||lv_conc_prog_name(23)||wf_core.newline;
4036: lv_prc_list := lv_prc_list||lv_conc_prog_name(24)||wf_core.newline;
4037: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS23';
4038: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS24';
4039:
4040: if (p_cost_summary_file_out is not null) then

Line 4042: lv_prc_list := lv_prc_list||lv_conc_prog_name(25)||wf_core.newline;

4038: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS24';
4039:
4040: if (p_cost_summary_file_out is not null) then
4041: lv_is_costing_summary := 'Y';
4042: lv_prc_list := lv_prc_list||lv_conc_prog_name(25)||wf_core.newline;
4043: lv_process_list_html_2 := lv_process_list_html_2||',PROCESS25';
4044: else
4045: lv_is_costing_summary := 'N';
4046: end if;

Line 4055: lv_process_list_text := 'Review the List of Processes and Reports which will be submitted based on the input parameters, please click on the '||''''||'Continue'||''''||' button to start processing.'||wf_core.newline||wf_core.newline||lv_prc_list;

4051: lv_process_list_subject := 'List of Processes and Reports which will be submitted';
4052:
4053: if lv_workflow_mode = 'W' then
4054:
4055: lv_process_list_text := 'Review the List of Processes and Reports which will be submitted based on the input parameters, please click on the '||''''||'Continue'||''''||' button to start processing.'||wf_core.newline||wf_core.newline||lv_prc_list;
4056:
4057: lv_process_list_html_1 := 'Review the List of Processes and Reports which will be submitted based on the input parameters, please click on the '||''''||'Continue'||''''||' button to start processing.';
4058:
4059: else

Line 4061: lv_process_list_text := 'Review the List of Processes and Reports which will be submitted based on the input parameters.'||wf_core.newline||wf_core.newline||lv_prc_list;

4057: lv_process_list_html_1 := 'Review the List of Processes and Reports which will be submitted based on the input parameters, please click on the '||''''||'Continue'||''''||' button to start processing.';
4058:
4059: else
4060:
4061: lv_process_list_text := 'Review the List of Processes and Reports which will be submitted based on the input parameters.'||wf_core.newline||wf_core.newline||lv_prc_list;
4062:
4063: lv_process_list_html_1 := 'Review the List of Processes and Reports which will be submitted based on the input parameters.';
4064:
4065: end if;

Line 4874: wf_core.Context('pay_ca_wf_pkg',

4870:
4871:
4872: exception
4873: when others then
4874: wf_core.Context('pay_ca_wf_pkg',
4875: 'StartProcess',
4876: ItemType,
4877: RequestorUsername,
4878: ProcessOwner,

Line 4969: hr_utility.trace('Errname: '||wf_core.error_name);

4965: begin
4966:
4967: hr_utility.trace('Run time error in test script');
4968: hr_utility.trace('Sqlerror: '||sqlerrm);
4969: hr_utility.trace('Errname: '||wf_core.error_name);
4970: hr_utility.trace('Errmsg: '||substr(wf_core.error_message, 1, 200));
4971: hr_utility.trace('Stack1: '||substr(wf_core.error_stack, 1, 200));
4972: hr_utility.trace('Stack2: '||substr(wf_core.error_stack, 200, 200));
4973: hr_utility.trace('Stack3: '||substr(wf_core.error_stack, 400, 200));

Line 4970: hr_utility.trace('Errmsg: '||substr(wf_core.error_message, 1, 200));

4966:
4967: hr_utility.trace('Run time error in test script');
4968: hr_utility.trace('Sqlerror: '||sqlerrm);
4969: hr_utility.trace('Errname: '||wf_core.error_name);
4970: hr_utility.trace('Errmsg: '||substr(wf_core.error_message, 1, 200));
4971: hr_utility.trace('Stack1: '||substr(wf_core.error_stack, 1, 200));
4972: hr_utility.trace('Stack2: '||substr(wf_core.error_stack, 200, 200));
4973: hr_utility.trace('Stack3: '||substr(wf_core.error_stack, 400, 200));
4974: hr_utility.trace('Stack4: '||substr(wf_core.error_stack, 600, 200));

Line 4971: hr_utility.trace('Stack1: '||substr(wf_core.error_stack, 1, 200));

4967: hr_utility.trace('Run time error in test script');
4968: hr_utility.trace('Sqlerror: '||sqlerrm);
4969: hr_utility.trace('Errname: '||wf_core.error_name);
4970: hr_utility.trace('Errmsg: '||substr(wf_core.error_message, 1, 200));
4971: hr_utility.trace('Stack1: '||substr(wf_core.error_stack, 1, 200));
4972: hr_utility.trace('Stack2: '||substr(wf_core.error_stack, 200, 200));
4973: hr_utility.trace('Stack3: '||substr(wf_core.error_stack, 400, 200));
4974: hr_utility.trace('Stack4: '||substr(wf_core.error_stack, 600, 200));
4975: hr_utility.trace('Stack5: '||substr(wf_core.error_stack, 800, 200));

Line 4972: hr_utility.trace('Stack2: '||substr(wf_core.error_stack, 200, 200));

4968: hr_utility.trace('Sqlerror: '||sqlerrm);
4969: hr_utility.trace('Errname: '||wf_core.error_name);
4970: hr_utility.trace('Errmsg: '||substr(wf_core.error_message, 1, 200));
4971: hr_utility.trace('Stack1: '||substr(wf_core.error_stack, 1, 200));
4972: hr_utility.trace('Stack2: '||substr(wf_core.error_stack, 200, 200));
4973: hr_utility.trace('Stack3: '||substr(wf_core.error_stack, 400, 200));
4974: hr_utility.trace('Stack4: '||substr(wf_core.error_stack, 600, 200));
4975: hr_utility.trace('Stack5: '||substr(wf_core.error_stack, 800, 200));
4976: hr_utility.trace('Stack6: '||substr(wf_core.error_stack, 1000, 200));

Line 4973: hr_utility.trace('Stack3: '||substr(wf_core.error_stack, 400, 200));

4969: hr_utility.trace('Errname: '||wf_core.error_name);
4970: hr_utility.trace('Errmsg: '||substr(wf_core.error_message, 1, 200));
4971: hr_utility.trace('Stack1: '||substr(wf_core.error_stack, 1, 200));
4972: hr_utility.trace('Stack2: '||substr(wf_core.error_stack, 200, 200));
4973: hr_utility.trace('Stack3: '||substr(wf_core.error_stack, 400, 200));
4974: hr_utility.trace('Stack4: '||substr(wf_core.error_stack, 600, 200));
4975: hr_utility.trace('Stack5: '||substr(wf_core.error_stack, 800, 200));
4976: hr_utility.trace('Stack6: '||substr(wf_core.error_stack, 1000, 200));
4977: hr_utility.trace('Stack7: '||substr(wf_core.error_stack, 1200, 200));

Line 4974: hr_utility.trace('Stack4: '||substr(wf_core.error_stack, 600, 200));

4970: hr_utility.trace('Errmsg: '||substr(wf_core.error_message, 1, 200));
4971: hr_utility.trace('Stack1: '||substr(wf_core.error_stack, 1, 200));
4972: hr_utility.trace('Stack2: '||substr(wf_core.error_stack, 200, 200));
4973: hr_utility.trace('Stack3: '||substr(wf_core.error_stack, 400, 200));
4974: hr_utility.trace('Stack4: '||substr(wf_core.error_stack, 600, 200));
4975: hr_utility.trace('Stack5: '||substr(wf_core.error_stack, 800, 200));
4976: hr_utility.trace('Stack6: '||substr(wf_core.error_stack, 1000, 200));
4977: hr_utility.trace('Stack7: '||substr(wf_core.error_stack, 1200, 200));
4978: hr_utility.trace('Stack8: '||substr(wf_core.error_stack, 1400, 200));

Line 4975: hr_utility.trace('Stack5: '||substr(wf_core.error_stack, 800, 200));

4971: hr_utility.trace('Stack1: '||substr(wf_core.error_stack, 1, 200));
4972: hr_utility.trace('Stack2: '||substr(wf_core.error_stack, 200, 200));
4973: hr_utility.trace('Stack3: '||substr(wf_core.error_stack, 400, 200));
4974: hr_utility.trace('Stack4: '||substr(wf_core.error_stack, 600, 200));
4975: hr_utility.trace('Stack5: '||substr(wf_core.error_stack, 800, 200));
4976: hr_utility.trace('Stack6: '||substr(wf_core.error_stack, 1000, 200));
4977: hr_utility.trace('Stack7: '||substr(wf_core.error_stack, 1200, 200));
4978: hr_utility.trace('Stack8: '||substr(wf_core.error_stack, 1400, 200));
4979: hr_utility.trace('Stack9: '||substr(wf_core.error_stack, 1600, 200));

Line 4976: hr_utility.trace('Stack6: '||substr(wf_core.error_stack, 1000, 200));

4972: hr_utility.trace('Stack2: '||substr(wf_core.error_stack, 200, 200));
4973: hr_utility.trace('Stack3: '||substr(wf_core.error_stack, 400, 200));
4974: hr_utility.trace('Stack4: '||substr(wf_core.error_stack, 600, 200));
4975: hr_utility.trace('Stack5: '||substr(wf_core.error_stack, 800, 200));
4976: hr_utility.trace('Stack6: '||substr(wf_core.error_stack, 1000, 200));
4977: hr_utility.trace('Stack7: '||substr(wf_core.error_stack, 1200, 200));
4978: hr_utility.trace('Stack8: '||substr(wf_core.error_stack, 1400, 200));
4979: hr_utility.trace('Stack9: '||substr(wf_core.error_stack, 1600, 200));
4980: hr_utility.trace('Stack10: '||substr(wf_core.error_stack, 1800, 200));

Line 4977: hr_utility.trace('Stack7: '||substr(wf_core.error_stack, 1200, 200));

4973: hr_utility.trace('Stack3: '||substr(wf_core.error_stack, 400, 200));
4974: hr_utility.trace('Stack4: '||substr(wf_core.error_stack, 600, 200));
4975: hr_utility.trace('Stack5: '||substr(wf_core.error_stack, 800, 200));
4976: hr_utility.trace('Stack6: '||substr(wf_core.error_stack, 1000, 200));
4977: hr_utility.trace('Stack7: '||substr(wf_core.error_stack, 1200, 200));
4978: hr_utility.trace('Stack8: '||substr(wf_core.error_stack, 1400, 200));
4979: hr_utility.trace('Stack9: '||substr(wf_core.error_stack, 1600, 200));
4980: hr_utility.trace('Stack10: '||substr(wf_core.error_stack, 1800, 200));
4981:

Line 4978: hr_utility.trace('Stack8: '||substr(wf_core.error_stack, 1400, 200));

4974: hr_utility.trace('Stack4: '||substr(wf_core.error_stack, 600, 200));
4975: hr_utility.trace('Stack5: '||substr(wf_core.error_stack, 800, 200));
4976: hr_utility.trace('Stack6: '||substr(wf_core.error_stack, 1000, 200));
4977: hr_utility.trace('Stack7: '||substr(wf_core.error_stack, 1200, 200));
4978: hr_utility.trace('Stack8: '||substr(wf_core.error_stack, 1400, 200));
4979: hr_utility.trace('Stack9: '||substr(wf_core.error_stack, 1600, 200));
4980: hr_utility.trace('Stack10: '||substr(wf_core.error_stack, 1800, 200));
4981:
4982: end error;

Line 4979: hr_utility.trace('Stack9: '||substr(wf_core.error_stack, 1600, 200));

4975: hr_utility.trace('Stack5: '||substr(wf_core.error_stack, 800, 200));
4976: hr_utility.trace('Stack6: '||substr(wf_core.error_stack, 1000, 200));
4977: hr_utility.trace('Stack7: '||substr(wf_core.error_stack, 1200, 200));
4978: hr_utility.trace('Stack8: '||substr(wf_core.error_stack, 1400, 200));
4979: hr_utility.trace('Stack9: '||substr(wf_core.error_stack, 1600, 200));
4980: hr_utility.trace('Stack10: '||substr(wf_core.error_stack, 1800, 200));
4981:
4982: end error;
4983:

Line 4980: hr_utility.trace('Stack10: '||substr(wf_core.error_stack, 1800, 200));

4976: hr_utility.trace('Stack6: '||substr(wf_core.error_stack, 1000, 200));
4977: hr_utility.trace('Stack7: '||substr(wf_core.error_stack, 1200, 200));
4978: hr_utility.trace('Stack8: '||substr(wf_core.error_stack, 1400, 200));
4979: hr_utility.trace('Stack9: '||substr(wf_core.error_stack, 1600, 200));
4980: hr_utility.trace('Stack10: '||substr(wf_core.error_stack, 1800, 200));
4981:
4982: end error;
4983:
4984: