APPS.PAY_US_PSD_GENERIC_EXTRACT dependencies on FND_GLOBAL

Line 600: SELECT fnd_global.local_chr(13) || fnd_global.local_chr(10) INTO EOL

596: /*
597: Consturct XML Elements using all the RA record data items stored in the
598: ''|| EOL ||
599: */
600: SELECT fnd_global.local_chr(13) || fnd_global.local_chr(10) INTO EOL
601: FROM dual;
602:
603: l_final_xml_string := ''||EOL;
604:

Line 1083: SELECT fnd_global.local_chr(13) || fnd_global.local_chr(10) INTO EOL

1079: /*Success||Employer PSD Code--Added this tag to compare it with EE_EXCEPTION_WORK_PSD (for successful employees)in templates*/
1080: g_re_record(ER_SUCCESS_PSD_CODE).employer_data := 'SUCCESS'||g_re_record(ER_PSD_CODE).employer_data;
1081: g_re_record(ER_SUCCESS_PSD_CODE).employer_tag := ltr_re_data_tag(ER_SUCCESS_PSD_CODE);
1082:
1083: SELECT fnd_global.local_chr(13) || fnd_global.local_chr(10) INTO EOL
1084: FROM dual;
1085: l_final_xml_string := ''||EOL;
1086:
1087: FOR I IN 1 .. g_re_no_of_tag LOOP

Line 1592: ||fnd_global.local_chr(13) || fnd_global.local_chr(10)||' ',1,1500);*/

1588: THEN
1589: l_status := 'FAILED';
1590: /*l_status_description := SUBSTR(l_status_description || 'Archive Item ' || ltr_ue_name_table(j).ue_name || ' has negative balance(' || trunc(ltr_ue_name_table(j).ue_value)||
1591: decode(abs(ltr_ue_name_table(j).ue_value)-abs(trunc(ltr_ue_name_table(j).ue_value)),0,'.00',rpad(abs(ltr_ue_name_table(j).ue_value)-abs(trunc(ltr_ue_name_table(j).ue_value)),3,'0'))||').'
1592: ||fnd_global.local_chr(13) || fnd_global.local_chr(10)||' ',1,1500);*/
1593: select SUBSTR(l_status_description || 'Archive Item ' || ltr_ue_name_table(j).ue_name || ' has negative balance(' || trunc(ltr_ue_name_table(j).ue_value)||
1594: decode(abs(ltr_ue_name_table(j).ue_value)-abs(trunc(ltr_ue_name_table(j).ue_value)),0,'.00',rpad(abs(ltr_ue_name_table(j).ue_value)-abs(trunc(ltr_ue_name_table(j).ue_value)),3,'0'))||').'
1595: ||fnd_global.local_chr(13) || fnd_global.local_chr(10)||' ',1,1500) into l_status_description
1596: from dual;

Line 1595: ||fnd_global.local_chr(13) || fnd_global.local_chr(10)||' ',1,1500) into l_status_description

1591: decode(abs(ltr_ue_name_table(j).ue_value)-abs(trunc(ltr_ue_name_table(j).ue_value)),0,'.00',rpad(abs(ltr_ue_name_table(j).ue_value)-abs(trunc(ltr_ue_name_table(j).ue_value)),3,'0'))||').'
1592: ||fnd_global.local_chr(13) || fnd_global.local_chr(10)||' ',1,1500);*/
1593: select SUBSTR(l_status_description || 'Archive Item ' || ltr_ue_name_table(j).ue_name || ' has negative balance(' || trunc(ltr_ue_name_table(j).ue_value)||
1594: decode(abs(ltr_ue_name_table(j).ue_value)-abs(trunc(ltr_ue_name_table(j).ue_value)),0,'.00',rpad(abs(ltr_ue_name_table(j).ue_value)-abs(trunc(ltr_ue_name_table(j).ue_value)),3,'0'))||').'
1595: ||fnd_global.local_chr(13) || fnd_global.local_chr(10)||' ',1,1500) into l_status_description
1596: from dual;
1597: END IF;
1598: ELSIF ltr_ue_name_table(J).ue_data_level ='STATE' THEN
1599: ltr_ue_name_table(j).ue_value :=

Line 1615: ||fnd_global.local_chr(13) || fnd_global.local_chr(10)||' ',1,1500);*/

1611: THEN
1612: l_status := 'FAILED';
1613: /*l_status_description := SUBSTR(l_status_description || 'Archive Item ' || ltr_ue_name_table(j).ue_name || ' has negative balance(' || trunc(ltr_ue_name_table(j).ue_value)||
1614: decode(abs(ltr_ue_name_table(j).ue_value)-abs(trunc(ltr_ue_name_table(j).ue_value)),0,'.00',rpad(abs(ltr_ue_name_table(j).ue_value)-abs(trunc(ltr_ue_name_table(j).ue_value)),3,'0'))||').'
1615: ||fnd_global.local_chr(13) || fnd_global.local_chr(10)||' ',1,1500);*/
1616: select SUBSTR(l_status_description || 'Archive Item ' || ltr_ue_name_table(j).ue_name || ' has negative balance(' || trunc(ltr_ue_name_table(j).ue_value)||
1617: decode(abs(ltr_ue_name_table(j).ue_value)-abs(trunc(ltr_ue_name_table(j).ue_value)),0,'.00',rpad(abs(ltr_ue_name_table(j).ue_value)-abs(trunc(ltr_ue_name_table(j).ue_value)),3,'0'))||').'
1618: ||fnd_global.local_chr(13) || fnd_global.local_chr(10)||' ',1,1500) into l_status_description
1619: from dual;

Line 1618: ||fnd_global.local_chr(13) || fnd_global.local_chr(10)||' ',1,1500) into l_status_description

1614: decode(abs(ltr_ue_name_table(j).ue_value)-abs(trunc(ltr_ue_name_table(j).ue_value)),0,'.00',rpad(abs(ltr_ue_name_table(j).ue_value)-abs(trunc(ltr_ue_name_table(j).ue_value)),3,'0'))||').'
1615: ||fnd_global.local_chr(13) || fnd_global.local_chr(10)||' ',1,1500);*/
1616: select SUBSTR(l_status_description || 'Archive Item ' || ltr_ue_name_table(j).ue_name || ' has negative balance(' || trunc(ltr_ue_name_table(j).ue_value)||
1617: decode(abs(ltr_ue_name_table(j).ue_value)-abs(trunc(ltr_ue_name_table(j).ue_value)),0,'.00',rpad(abs(ltr_ue_name_table(j).ue_value)-abs(trunc(ltr_ue_name_table(j).ue_value)),3,'0'))||').'
1618: ||fnd_global.local_chr(13) || fnd_global.local_chr(10)||' ',1,1500) into l_status_description
1619: from dual;
1620: END IF;
1621: ELSIF ltr_ue_name_table(J).ue_data_level ='PSD' THEN
1622: ltr_ue_name_table(j).ue_value :=

Line 1636: ||fnd_global.local_chr(13) || fnd_global.local_chr(10)||' ',1,1500);*/

1632: THEN
1633: l_status := 'FAILED';
1634: /*l_status_description := SUBSTR(l_status_description || 'Archive Item ' || ltr_ue_name_table(j).ue_name || ' has negative balance(' || trunc(ltr_ue_name_table(j).ue_value)||
1635: decode(abs(ltr_ue_name_table(j).ue_value)-abs(trunc(ltr_ue_name_table(j).ue_value)),0,'.00',rpad(abs(ltr_ue_name_table(j).ue_value)-abs(trunc(ltr_ue_name_table(j).ue_value)),3,'0'))||').'
1636: ||fnd_global.local_chr(13) || fnd_global.local_chr(10)||' ',1,1500);*/
1637: select SUBSTR(l_status_description || 'Archive Item ' || ltr_ue_name_table(j).ue_name || ' has negative balance(' || trunc(ltr_ue_name_table(j).ue_value)||
1638: decode(abs(ltr_ue_name_table(j).ue_value)-abs(trunc(ltr_ue_name_table(j).ue_value)),0,'.00',rpad(abs(ltr_ue_name_table(j).ue_value)-abs(trunc(ltr_ue_name_table(j).ue_value)),3,'0'))||').'
1639: ||fnd_global.local_chr(13) || fnd_global.local_chr(10)||' ',1,1500) into l_status_description
1640: from dual;

Line 1639: ||fnd_global.local_chr(13) || fnd_global.local_chr(10)||' ',1,1500) into l_status_description

1635: decode(abs(ltr_ue_name_table(j).ue_value)-abs(trunc(ltr_ue_name_table(j).ue_value)),0,'.00',rpad(abs(ltr_ue_name_table(j).ue_value)-abs(trunc(ltr_ue_name_table(j).ue_value)),3,'0'))||').'
1636: ||fnd_global.local_chr(13) || fnd_global.local_chr(10)||' ',1,1500);*/
1637: select SUBSTR(l_status_description || 'Archive Item ' || ltr_ue_name_table(j).ue_name || ' has negative balance(' || trunc(ltr_ue_name_table(j).ue_value)||
1638: decode(abs(ltr_ue_name_table(j).ue_value)-abs(trunc(ltr_ue_name_table(j).ue_value)),0,'.00',rpad(abs(ltr_ue_name_table(j).ue_value)-abs(trunc(ltr_ue_name_table(j).ue_value)),3,'0'))||').'
1639: ||fnd_global.local_chr(13) || fnd_global.local_chr(10)||' ',1,1500) into l_status_description
1640: from dual;
1641: END IF;
1642: --Added for the Bug 14799833
1643: ELSIF ltr_ue_name_table(J).ue_data_level ='PSD_YTD' THEN

Line 1651: ||fnd_global.local_chr(13) || fnd_global.local_chr(10)||' ',1,1500) into l_status_description

1647: THEN
1648: l_status := 'FAILED';
1649: select SUBSTR(l_status_description || 'Archive Item ' || ltr_ue_name_table(j).ue_name || ' has negative balance(' || trunc(ltr_ue_name_table(j).ue_value)||
1650: decode(abs(ltr_ue_name_table(j).ue_value)-abs(trunc(ltr_ue_name_table(j).ue_value)),0,'.00',rpad(abs(ltr_ue_name_table(j).ue_value)-abs(trunc(ltr_ue_name_table(j).ue_value)),3,'0'))||').'
1651: ||fnd_global.local_chr(13) || fnd_global.local_chr(10)||' ',1,1500) into l_status_description
1652: from dual;
1653: END IF;
1654: ELSIF ltr_ue_name_table(J).ue_data_level ='GRE' THEN
1655: ltr_ue_name_table(j).ue_value :=

Line 1710: SELECT fnd_global.local_chr(13) || fnd_global.local_chr(10) INTO EOL

1706: -- Pouplate All the Tags to be used for RE record Data Items
1707: --
1708: pay_us_psd_generic_extract.populate_ee_data_tag;
1709:
1710: SELECT fnd_global.local_chr(13) || fnd_global.local_chr(10) INTO EOL
1711: FROM dual;
1712:
1713: /* Initialize with Default Value */
1714: