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

Line 81: hr_utility.trace('RS. Other State Data.l_length = '||to_char(l_length));

77: IF ((p_record_name = 'RS') AND
78: (p_input_3 = 'Other State Data')
79: ) THEN
80: l_length := 10;
81: hr_utility.trace('RS. Other State Data.l_length = '||to_char(l_length));
82: ELSIF p_record_name = 'RS' THEN
83: --{
84: IF p_report_qualifier = 'GA_SQWL' THEN
85: IF p_input_3 = 'SUI Insurance Wages' THEN

Line 301: hr_utility.trace('RA Record Formatting started ');

297: r_input_39 varchar2(300);
298:
299: BEGIN
300: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);
301: hr_utility.trace('RA Record Formatting started ');
302: hr_utility.trace('Format_SQWL_RA_Record Begin for Company '|| p_input_7);
303: -- Initializing local variables with parameter value
304: --{
305: r_input_2 := p_input_2;

Line 302: hr_utility.trace('Format_SQWL_RA_Record Begin for Company '|| p_input_7);

298:
299: BEGIN
300: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);
301: hr_utility.trace('RA Record Formatting started ');
302: hr_utility.trace('Format_SQWL_RA_Record Begin for Company '|| p_input_7);
303: -- Initializing local variables with parameter value
304: --{
305: r_input_2 := p_input_2;
306: r_input_3 := p_input_3;

Line 367: hr_utility.trace('Valid EIN '||l_emp_ein);

363:
364: IF p_exclude_from_output = 'Y' THEN
365: l_exclude_from_output_chk := TRUE;
366: END IF;
367: hr_utility.trace('Valid EIN '||l_emp_ein);
368: -- Validation Ends
369: --
370: -- Formatiing Starts
371: /*Pos:3-11 EIN blank for LA,NH SQWL. */

Line 428: hr_utility.trace(' l_pin = '||l_pin);

424: END IF;
425: --}
426: ELSE
427: l_pin := rpad(substr(nvl(p_input_3,' '),1,17),17);
428: hr_utility.trace(' l_pin = '||l_pin);
429: --}
430: END IF;
431:
432: IF ( p_report_qualifier = 'AL_SQWL' ) THEN

Line 467: hr_utility.trace('Preferred method of code is correct. it is '||p_input_32);

463: IF ((p_input_32 = '1' ) OR
464: (p_input_32 = '2' ) OR
465: (p_input_32 = '3' ) OR
466: (p_input_32 = '4' ) ) THEN
467: hr_utility.trace('Preferred method of code is correct. it is '||p_input_32);
468: l_pblm_code:= p_input_32;
469: ELSE
470: hr_utility.trace('Preferred method of code is incorrect. it is '||p_input_32);
471: l_pblm_code:= lpad(' ',1);

Line 470: hr_utility.trace('Preferred method of code is incorrect. it is '||p_input_32);

466: (p_input_32 = '4' ) ) THEN
467: hr_utility.trace('Preferred method of code is correct. it is '||p_input_32);
468: l_pblm_code:= p_input_32;
469: ELSE
470: hr_utility.trace('Preferred method of code is incorrect. it is '||p_input_32);
471: l_pblm_code:= lpad(' ',1);
472: END IF;
473:
474: If( (p_input_33 = 'A' )OR

Line 480: hr_utility.trace('l_preparer_code is correct. it is '||p_input_33);

476: (p_input_33 = 'L' )OR
477: (p_input_33 = 'P' )OR
478: (p_input_33 = 'O' )) THEN
479: l_preparer_code:= p_input_33;
480: hr_utility.trace('l_preparer_code is correct. it is '||p_input_33);
481: ELSE
482: IF (p_report_qualifier = 'AL_SQWL') THEN
483: l_preparer_code := lpad('O',1);
484: ELSE

Line 487: hr_utility.trace('l_preparer_code is incorrect. it is '||p_input_33);

483: l_preparer_code := lpad('O',1);
484: ELSE
485: l_preparer_code:= lpad(' ',1);
486: END IF;
487: hr_utility.trace('l_preparer_code is incorrect. it is '||p_input_33);
488: END IF;
489:
490: IF ((p_report_qualifier = 'LA_SQWL')OR
491: (p_report_qualifier = 'NH_SQWL')OR

Line 561: hr_utility.trace('p_input_40 = '||p_input_40);

557: l_pblm_code:= lpad(' ',1);
558: l_preparer_code:= lpad(' ',1);
559: END IF;
560:
561: hr_utility.trace('p_input_40 = '||p_input_40);
562: IF (p_report_qualifier = 'NY_SQWL') THEN
563: /* Bug 3527986 Removed Delimiters fro NY */
564: --l_end_of_rec := p_end_of_rec;
565: return_value:='RA'

Line 632: hr_utility.trace('---------------------FLAT----------------------------');

628: ||l_preparer_code
629: ||lpad(' ',12)
630: ||l_end_of_rec ;
631: ret_str_len:=length(return_value);
632: hr_utility.trace('---------------------FLAT----------------------------');
633: END IF;
634: ELSIF p_input_40 = 'CSV' THEN
635: hr_utility.trace('---------------------CSV----------------------------');
636: return_value:='RA'||','||p_input_2||','||p_input_3

Line 635: hr_utility.trace('---------------------CSV----------------------------');

631: ret_str_len:=length(return_value);
632: hr_utility.trace('---------------------FLAT----------------------------');
633: END IF;
634: ELSIF p_input_40 = 'CSV' THEN
635: hr_utility.trace('---------------------CSV----------------------------');
636: return_value:='RA'||','||p_input_2||','||p_input_3
637: ||','||rpad(substr(nvl(p_input_4,'0'),1,1),1)
638: ||','||rpad(substr(nvl(p_input_5,' '),1,6),6)
639: ||','||rpad(substr(nvl(p_input_6,' '),1,2),2)

Line 672: hr_utility.trace('---------------------CSV----------------------------');

668: ||','||rpad(substr(nvl(p_input_31,' '),1,10),10)
669: ||','||p_input_32
670: ||','||p_input_33
671: ||','||lpad(' ',12);
672: hr_utility.trace('---------------------CSV----------------------------');
673: hr_utility.trace(return_value);
674: END IF;
675: p_error := l_exclude_from_output_chk;
676: ret_str_len:=length(return_value);

Line 673: hr_utility.trace(return_value);

669: ||','||p_input_32
670: ||','||p_input_33
671: ||','||lpad(' ',12);
672: hr_utility.trace('---------------------CSV----------------------------');
673: hr_utility.trace(return_value);
674: END IF;
675: p_error := l_exclude_from_output_chk;
676: ret_str_len:=length(return_value);
677: return return_value;

Line 824: hr_utility.trace('RE Record Formatting started ');

820:
821: p_end_of_rec varchar2(20);
822: BEGIN
823: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);
824: hr_utility.trace('RE Record Formatting started ');
825: -- Initializing local variables with parameter value
826: --{
827: r_input_2 := p_input_2;
828: r_input_3 := p_input_3;

Line 871: hr_utility.trace('agent indicator is Y');

867: IF p_record_name = 'RE' THEN -- p_record_name
868: --{
869: /* Check for agent indicator code p_input_3 */
870: IF p_input_3 = 'Y' THEN
871: hr_utility.trace('agent indicator is Y');
872: l_agent_indicator := '1';
873: l_emp_ein := p_input_5;
874: l_agent_ein := p_input_4;
875: ELSE

Line 877: hr_utility.trace('agent indicator is not 1');

873: l_emp_ein := p_input_5;
874: l_agent_ein := p_input_4;
875: ELSE
876: l_agent_indicator:=lpad(' ','1');
877: hr_utility.trace('agent indicator is not 1');
878: l_emp_ein := p_input_4;
879: l_agent_ein := lpad(' ',9);
880: END IF;
881:

Line 948: hr_utility.trace('before data_validation of ein');

944: -- Validation for RE Record starts
945: -- These validation are used only for mf file only.
946: -- not for any of the audit report
947: --
948: hr_utility.trace('before data_validation of ein');
949: l_emp_ein :=
950: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
951: p_report_type,
952: p_format,

Line 991: hr_utility.trace('after data_validation of EIN');

987: END IF;
988: --}
989: END IF; -- agent_indicator
990:
991: hr_utility.trace('after data_validation of EIN');
992: l_input_8 := replace(r_input_8,' ');
993:
994: IF l_input_8 IS NOT NULL THEN --Checking Other EIN for validation
995: --{

Line 996: hr_utility.trace('before data_validation of other EIN');

992: l_input_8 := replace(r_input_8,' ');
993:
994: IF l_input_8 IS NOT NULL THEN --Checking Other EIN for validation
995: --{
996: hr_utility.trace('before data_validation of other EIN');
997: l_other_ein:=
998: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
999: p_report_type,
1000: p_format,

Line 1013: hr_utility.trace('after data_validation of Other EIN');

1009: p_exclude_from_output,
1010: sp_out_1,
1011: sp_out_2
1012: );
1013: hr_utility.trace('after data_validation of Other EIN');
1014: IF p_exclude_from_output = 'Y' THEN
1015: l_exclude_from_output_chk := TRUE;
1016: END IF;
1017: --}

Line 1545: hr_utility.trace('Formatting RS record for SQWL ');

1541: r_input_39 varchar2(300);
1542:
1543: BEGIN
1544: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);
1545: hr_utility.trace('Formatting RS record for SQWL ');
1546: hr_utility.trace('p_report_qualifier = '||p_report_qualifier);
1547: -- Initializing local variables with parameter value
1548: --{
1549: r_input_2 := p_input_2;

Line 1546: hr_utility.trace('p_report_qualifier = '||p_report_qualifier);

1542:
1543: BEGIN
1544: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);
1545: hr_utility.trace('Formatting RS record for SQWL ');
1546: hr_utility.trace('p_report_qualifier = '||p_report_qualifier);
1547: -- Initializing local variables with parameter value
1548: --{
1549: r_input_2 := p_input_2;
1550: r_input_3 := p_input_3;

Line 1596: hr_utility.trace('l_state_length = '||to_char(l_state_length));

1592:
1593: r_input_2 := lpad(replace(p_input_2,' '),2,0);
1594: r_input_26 := lpad(replace(p_input_26,' '),2,0);
1595:
1596: hr_utility.trace('l_state_length = '||to_char(l_state_length));
1597: hr_utility.trace('l_state_length < 2.State code r_input_2 = '||r_input_2);
1598: hr_utility.trace('State code r_input_26 = '||r_input_26);
1599: END IF;
1600:

Line 1597: hr_utility.trace('l_state_length < 2.State code r_input_2 = '||r_input_2);

1593: r_input_2 := lpad(replace(p_input_2,' '),2,0);
1594: r_input_26 := lpad(replace(p_input_26,' '),2,0);
1595:
1596: hr_utility.trace('l_state_length = '||to_char(l_state_length));
1597: hr_utility.trace('l_state_length < 2.State code r_input_2 = '||r_input_2);
1598: hr_utility.trace('State code r_input_26 = '||r_input_26);
1599: END IF;
1600:
1601: /* Pos:3 - 4 State Code Blank for GA SQWL, State Abbreviation for AL SQWL */

Line 1598: hr_utility.trace('State code r_input_26 = '||r_input_26);

1594: r_input_26 := lpad(replace(p_input_26,' '),2,0);
1595:
1596: hr_utility.trace('l_state_length = '||to_char(l_state_length));
1597: hr_utility.trace('l_state_length < 2.State code r_input_2 = '||r_input_2);
1598: hr_utility.trace('State code r_input_26 = '||r_input_26);
1599: END IF;
1600:
1601: /* Pos:3 - 4 State Code Blank for GA SQWL, State Abbreviation for AL SQWL */
1602: IF (p_report_qualifier = 'GA_SQWL') OR

Line 1654: hr_utility.trace('SSN after Validation and Formatting = '||l_ssn);

1650: ELSE
1651: l_ssn := replace(replace(r_input_4,'-'),',');
1652: END IF;
1653:
1654: hr_utility.trace('SSN after Validation and Formatting = '||l_ssn);
1655:
1656:
1657: IF p_report_qualifier = 'LA_SQWL' THEN
1658: --{

Line 1689: hr_utility.trace('l_suffix = '||l_suffix);

1685: nvl(substr(r_input_7,1,20),' '),20));
1686: l_suffix := pay_us_reporting_utils_pkg.Character_check(rpad(
1687: nvl(substr(r_input_8,1,4),' '),4));
1688: END IF;
1689: hr_utility.trace('l_suffix = '||l_suffix);
1690:
1691: /* Middle Name blank for MD_SQWL. */
1692: IF p_report_qualifier = 'MD_SQWL' THEN
1693: l_middle_name := lpad(' ',15);

Line 1714: hr_utility.trace('Pos:69 - 149 blank for AL and NC');

1710: (p_report_qualifier = 'NE_SQWL') OR /* Bug# 5189831*/
1711: (p_report_qualifier = 'KS_SQWL') OR /* Bug 6036926 */
1712: (p_report_qualifier = 'FL_SQWL')) THEN
1713: --{
1714: hr_utility.trace('Pos:69 - 149 blank for AL and NC');
1715: l_suffix := lpad(' ',4);
1716: r_input_9 := lpad(' ',22);
1717: r_input_10 := lpad(' ',22);
1718: r_input_11 := lpad(' ',22);

Line 1817: hr_utility.trace('Seasonal worker for NC is '||p_input_18);

1813: ELSIF p_report_qualifier = 'MO_SQWL' THEN
1814: r_input_18 := '00';
1815: ELSIF p_report_qualifier = 'NC_SQWL' THEN
1816: r_input_18 := replace(nvl(p_input_18,'N'),'Y','S')||' ';
1817: hr_utility.trace('Seasonal worker for NC is '||p_input_18);
1818: ELSIF (p_report_qualifier = 'CA_SQWL') THEN
1819: r_input_18 := p_input_18||' ';
1820: ELSIF (p_report_qualifier = 'NY_SQWL') THEN
1821: r_input_18 := lpad(' ',2);

Line 1916: hr_utility.trace('l_hours_worked = '||to_char(l_hours_worked));

1912: IF ((p_report_qualifier = 'MN_SQWL') OR
1913: (p_report_qualifier = 'OR_SQWL')) THEN
1914:
1915: l_hours_worked := to_number(replace(r_input_34,' '));
1916: hr_utility.trace('l_hours_worked = '||to_char(l_hours_worked));
1917:
1918: IF l_hours_worked <0 THEN
1919: hr_utility.trace('Error in RS record for Employee '||p_input_1||
1920: ' Negative hours');

Line 1919: hr_utility.trace('Error in RS record for Employee '||p_input_1||

1915: l_hours_worked := to_number(replace(r_input_34,' '));
1916: hr_utility.trace('l_hours_worked = '||to_char(l_hours_worked));
1917:
1918: IF l_hours_worked <0 THEN
1919: hr_utility.trace('Error in RS record for Employee '||p_input_1||
1920: ' Negative hours');
1921: l_exclude_from_output_chk := TRUE;
1922: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','A');
1923: pay_core_utils.push_token('record_name',p_record_name);

Line 2172: hr_utility.trace(' Other state data AL,MD,OH ');

2168:
2169: /* Pos:298-307 State Excess Wages for LA_SQWL. */
2170: IF (p_report_qualifier = 'LA_SQWL') THEN
2171: IF p_input_40 = 'FLAT' THEN
2172: hr_utility.trace(' Other state data AL,MD,OH ');
2173: r_input_29 :=
2174: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
2175: p_report_type,
2176: p_format,

Line 2198: hr_utility.trace('State Control No for NC is '||r_input_29);

2194: END IF;
2195:
2196: IF p_report_qualifier = 'NC_SQWL' THEN
2197: r_input_29 := rpad(upper(rpad(p_input_29, 6, ' ')),10);
2198: hr_utility.trace('State Control No for NC is '||r_input_29);
2199: END IF;
2200:
2201: /* Pos:308 - 308 Tax type code formatting */
2202: IF p_report_qualifier = 'VA_SQWL' THEN

Line 2211: hr_utility.trace('Zero fill for SQWLs. p_report_qualifier = '||p_report_qualifier);

2207:
2208: /* Pos:309 - 319 Local taxable wages filled with zeros
2209: Pos:320 - 330 Local Income tax withheld filled with zeros */
2210:
2211: hr_utility.trace('Zero fill for SQWLs. p_report_qualifier = '||p_report_qualifier);
2212: r_input_31 := rpad(0,11,0);
2213: r_input_32 := rpad(0,11,0);
2214: hr_utility.trace('r_input_31 '||r_input_31);
2215: hr_utility.trace('r_input_32 '||r_input_32);

Line 2214: hr_utility.trace('r_input_31 '||r_input_31);

2210:
2211: hr_utility.trace('Zero fill for SQWLs. p_report_qualifier = '||p_report_qualifier);
2212: r_input_31 := rpad(0,11,0);
2213: r_input_32 := rpad(0,11,0);
2214: hr_utility.trace('r_input_31 '||r_input_31);
2215: hr_utility.trace('r_input_32 '||r_input_32);
2216:
2217: /* Pos:309-330 Blank for SC_SQWL. State wages and SIT withheld. */
2218: IF ((p_report_qualifier = 'SC_SQWL') OR

Line 2215: hr_utility.trace('r_input_32 '||r_input_32);

2211: hr_utility.trace('Zero fill for SQWLs. p_report_qualifier = '||p_report_qualifier);
2212: r_input_31 := rpad(0,11,0);
2213: r_input_32 := rpad(0,11,0);
2214: hr_utility.trace('r_input_31 '||r_input_31);
2215: hr_utility.trace('r_input_32 '||r_input_32);
2216:
2217: /* Pos:309-330 Blank for SC_SQWL. State wages and SIT withheld. */
2218: IF ((p_report_qualifier = 'SC_SQWL') OR
2219: (p_report_qualifier = 'GA_SQWL') OR

Line 2274: hr_utility.trace(' r_input_34 := '|| r_input_34 ) ;

2270: r_input_34 := rpad(lpad(nvl(r_input_34,' '),9,0),75);
2271: r_input_35 := lpad(' ',75);
2272: /* 4559359 */
2273: /* ELSIF p_report_qualifier = 'TX_SQWL' THEN
2274: hr_utility.trace(' r_input_34 := '|| r_input_34 ) ;
2275: r_input_34 := lpad(nvl(r_input_34,' '),3,'0') ||
2276: lpad(substr(nvl(r_input_35,' '),1,3),3) || /* County Code * /
2277: lpad(' ',1) ||
2278: lpad(' ',6) || /* NAICS Code * /

Line 2299: hr_utility.trace('WA_SQWL');

2295: l_last_field := lpad(' ',25);
2296: END IF;
2297:
2298: IF p_report_qualifier = 'WA_SQWL' THEN
2299: hr_utility.trace('WA_SQWL');
2300: r_input_4 :=
2301: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
2302: p_report_type,
2303: p_format,

Line 2319: hr_utility.trace('l_hours_worked = '||to_char(l_hours_worked));

2315: IF p_exclude_from_output = 'Y' THEN
2316: l_exclude_from_output_chk := TRUE;
2317: END IF;
2318: l_hours_worked := to_number(replace(p_input_3,' '));
2319: hr_utility.trace('l_hours_worked = '||to_char(l_hours_worked));
2320: IF l_hours_worked <0 THEN
2321: hr_utility.trace('Error in RS record for Employee '||p_input_2||
2322: ' Negative hours');
2323: l_exclude_from_output_chk := TRUE;

Line 2321: hr_utility.trace('Error in RS record for Employee '||p_input_2||

2317: END IF;
2318: l_hours_worked := to_number(replace(p_input_3,' '));
2319: hr_utility.trace('l_hours_worked = '||to_char(l_hours_worked));
2320: IF l_hours_worked <0 THEN
2321: hr_utility.trace('Error in RS record for Employee '||p_input_2||
2322: ' Negative hours');
2323: l_exclude_from_output_chk := TRUE;
2324: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','A');
2325: pay_core_utils.push_token('record_name',p_record_name);

Line 2329: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);

2325: pay_core_utils.push_token('record_name',p_record_name);
2326: pay_core_utils.push_token('name_or_number',substr(p_input_2,1,50));
2327: pay_core_utils.push_token('description','Negative hours');
2328: END IF;
2329: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
2330: -- Validation Starts
2331: -- EIN Validation
2332: r_input_5 :=
2333: pay_us_reporting_utils_pkg.data_validation(p_effective_date,

Line 2351: hr_utility.trace('Valid EIN '||r_input_5);

2347:
2348: IF p_exclude_from_output = 'Y' THEN
2349: l_exclude_from_output_chk := TRUE;
2350: END IF;
2351: hr_utility.trace('Valid EIN '||r_input_5);
2352: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
2353: -- Validation Ends
2354: r_input_2 := replace(p_input_2,',');
2355: r_input_4 := to_char(to_number(r_input_4/100),'000000.00');

Line 2352: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);

2348: IF p_exclude_from_output = 'Y' THEN
2349: l_exclude_from_output_chk := TRUE;
2350: END IF;
2351: hr_utility.trace('Valid EIN '||r_input_5);
2352: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
2353: -- Validation Ends
2354: r_input_2 := replace(p_input_2,',');
2355: r_input_4 := to_char(to_number(r_input_4/100),'000000.00');
2356: /*

Line 2360: hr_utility.trace('l_wa_sqwl_outstring = '||l_wa_sqwl_outstring);

2356: /*
2357: l_wa_sqwl_outstring := p_input_1||','||r_input_2||','||p_input_3||','||r_input_4;
2358: */
2359: l_wa_sqwl_outstring := r_input_5||','||p_input_1||','||r_input_2||','||p_input_3||','||r_input_4;
2360: hr_utility.trace('l_wa_sqwl_outstring = '||l_wa_sqwl_outstring);
2361: END IF;
2362:
2363: IF p_input_40 = 'FLAT' THEN
2364: --{ Start of formatting FLAT type RS Record

Line 2452: hr_utility.trace('Length of return value = '||to_char(length(return_value)));

2448: ||r_input_35
2449: ||l_last_field
2450: ||l_end_of_rec;
2451: END IF;
2452: hr_utility.trace('Length of return value = '||to_char(length(return_value)));
2453: --} End of formatting FLAT Type RS Record
2454: ELSIF p_input_40 = 'CSV' THEN
2455: --{ Start of formatting RS record in CSV format
2456: return_value := 'RS'

Line 2660: hr_utility.trace('RT Record Formatting started for SQWL reporting ');

2656: parameter_record input_parameter_record;
2657:
2658: BEGIN
2659: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);
2660: hr_utility.trace('RT Record Formatting started for SQWL reporting ');
2661:
2662: -- Validation Starts
2663: If p_input_40='FLAT' THEN
2664: --{

Line 2772: hr_utility.trace(parameter_record(i).p_parameter_name||' = '

2768: sp_out_2);
2769: IF p_exclude_from_output = 'Y' THEN
2770: l_exclude_from_output_chk := TRUE;
2771: END IF;
2772: hr_utility.trace(parameter_record(i).p_parameter_name||' = '
2773: ||parameter_record(i).p_output_value);
2774: hr_utility.trace('After validating the parameter for -ve Value p_exclude_from_output = '||p_exclude_from_output);
2775: END LOOP;
2776: -- Validation Ends here

Line 2774: hr_utility.trace('After validating the parameter for -ve Value p_exclude_from_output = '||p_exclude_from_output);

2770: l_exclude_from_output_chk := TRUE;
2771: END IF;
2772: hr_utility.trace(parameter_record(i).p_parameter_name||' = '
2773: ||parameter_record(i).p_output_value);
2774: hr_utility.trace('After validating the parameter for -ve Value p_exclude_from_output = '||p_exclude_from_output);
2775: END LOOP;
2776: -- Validation Ends here
2777:
2778: -- For Alabama, Zero Fill Pos : 250 - 264 /* Employer Contributions to Health Savings Account */

Line 2985: hr_utility.trace('RSSUMM Record Formatting started for SQWL reporting ');

2981: parameter_record input_parameter_record;
2982:
2983: BEGIN
2984: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);
2985: hr_utility.trace('RSSUMM Record Formatting started for SQWL reporting ');
2986:
2987: l_emp_ein := p_input_4;
2988: l_other_ein := p_input_5;
2989: hr_utility.trace('Before Valaditing Values are ...');

Line 2989: hr_utility.trace('Before Valaditing Values are ...');

2985: hr_utility.trace('RSSUMM Record Formatting started for SQWL reporting ');
2986:
2987: l_emp_ein := p_input_4;
2988: l_other_ein := p_input_5;
2989: hr_utility.trace('Before Valaditing Values are ...');
2990: hr_utility.trace('p_input_1 = '||p_input_1);
2991: hr_utility.trace('p_input_2 = '||p_input_2);
2992: hr_utility.trace('p_input_3 = '||p_input_3);
2993: hr_utility.trace('p_input_4 = '||p_input_4);

Line 2990: hr_utility.trace('p_input_1 = '||p_input_1);

2986:
2987: l_emp_ein := p_input_4;
2988: l_other_ein := p_input_5;
2989: hr_utility.trace('Before Valaditing Values are ...');
2990: hr_utility.trace('p_input_1 = '||p_input_1);
2991: hr_utility.trace('p_input_2 = '||p_input_2);
2992: hr_utility.trace('p_input_3 = '||p_input_3);
2993: hr_utility.trace('p_input_4 = '||p_input_4);
2994: hr_utility.trace('p_input_5 = '||p_input_5);

Line 2991: hr_utility.trace('p_input_2 = '||p_input_2);

2987: l_emp_ein := p_input_4;
2988: l_other_ein := p_input_5;
2989: hr_utility.trace('Before Valaditing Values are ...');
2990: hr_utility.trace('p_input_1 = '||p_input_1);
2991: hr_utility.trace('p_input_2 = '||p_input_2);
2992: hr_utility.trace('p_input_3 = '||p_input_3);
2993: hr_utility.trace('p_input_4 = '||p_input_4);
2994: hr_utility.trace('p_input_5 = '||p_input_5);
2995: hr_utility.trace('p_input_6 = '||p_input_6);

Line 2992: hr_utility.trace('p_input_3 = '||p_input_3);

2988: l_other_ein := p_input_5;
2989: hr_utility.trace('Before Valaditing Values are ...');
2990: hr_utility.trace('p_input_1 = '||p_input_1);
2991: hr_utility.trace('p_input_2 = '||p_input_2);
2992: hr_utility.trace('p_input_3 = '||p_input_3);
2993: hr_utility.trace('p_input_4 = '||p_input_4);
2994: hr_utility.trace('p_input_5 = '||p_input_5);
2995: hr_utility.trace('p_input_6 = '||p_input_6);
2996: hr_utility.trace('p_input_7 = '||p_input_7);

Line 2993: hr_utility.trace('p_input_4 = '||p_input_4);

2989: hr_utility.trace('Before Valaditing Values are ...');
2990: hr_utility.trace('p_input_1 = '||p_input_1);
2991: hr_utility.trace('p_input_2 = '||p_input_2);
2992: hr_utility.trace('p_input_3 = '||p_input_3);
2993: hr_utility.trace('p_input_4 = '||p_input_4);
2994: hr_utility.trace('p_input_5 = '||p_input_5);
2995: hr_utility.trace('p_input_6 = '||p_input_6);
2996: hr_utility.trace('p_input_7 = '||p_input_7);
2997: hr_utility.trace('p_input_8 = '||p_input_8);

Line 2994: hr_utility.trace('p_input_5 = '||p_input_5);

2990: hr_utility.trace('p_input_1 = '||p_input_1);
2991: hr_utility.trace('p_input_2 = '||p_input_2);
2992: hr_utility.trace('p_input_3 = '||p_input_3);
2993: hr_utility.trace('p_input_4 = '||p_input_4);
2994: hr_utility.trace('p_input_5 = '||p_input_5);
2995: hr_utility.trace('p_input_6 = '||p_input_6);
2996: hr_utility.trace('p_input_7 = '||p_input_7);
2997: hr_utility.trace('p_input_8 = '||p_input_8);
2998: hr_utility.trace('p_input_9 = '||p_input_9);

Line 2995: hr_utility.trace('p_input_6 = '||p_input_6);

2991: hr_utility.trace('p_input_2 = '||p_input_2);
2992: hr_utility.trace('p_input_3 = '||p_input_3);
2993: hr_utility.trace('p_input_4 = '||p_input_4);
2994: hr_utility.trace('p_input_5 = '||p_input_5);
2995: hr_utility.trace('p_input_6 = '||p_input_6);
2996: hr_utility.trace('p_input_7 = '||p_input_7);
2997: hr_utility.trace('p_input_8 = '||p_input_8);
2998: hr_utility.trace('p_input_9 = '||p_input_9);
2999: hr_utility.trace('p_input_10 = '||p_input_10);

Line 2996: hr_utility.trace('p_input_7 = '||p_input_7);

2992: hr_utility.trace('p_input_3 = '||p_input_3);
2993: hr_utility.trace('p_input_4 = '||p_input_4);
2994: hr_utility.trace('p_input_5 = '||p_input_5);
2995: hr_utility.trace('p_input_6 = '||p_input_6);
2996: hr_utility.trace('p_input_7 = '||p_input_7);
2997: hr_utility.trace('p_input_8 = '||p_input_8);
2998: hr_utility.trace('p_input_9 = '||p_input_9);
2999: hr_utility.trace('p_input_10 = '||p_input_10);
3000: hr_utility.trace('p_input_11 = '||p_input_11);

Line 2997: hr_utility.trace('p_input_8 = '||p_input_8);

2993: hr_utility.trace('p_input_4 = '||p_input_4);
2994: hr_utility.trace('p_input_5 = '||p_input_5);
2995: hr_utility.trace('p_input_6 = '||p_input_6);
2996: hr_utility.trace('p_input_7 = '||p_input_7);
2997: hr_utility.trace('p_input_8 = '||p_input_8);
2998: hr_utility.trace('p_input_9 = '||p_input_9);
2999: hr_utility.trace('p_input_10 = '||p_input_10);
3000: hr_utility.trace('p_input_11 = '||p_input_11);
3001: hr_utility.trace('p_input_12 = '||p_input_12);

Line 2998: hr_utility.trace('p_input_9 = '||p_input_9);

2994: hr_utility.trace('p_input_5 = '||p_input_5);
2995: hr_utility.trace('p_input_6 = '||p_input_6);
2996: hr_utility.trace('p_input_7 = '||p_input_7);
2997: hr_utility.trace('p_input_8 = '||p_input_8);
2998: hr_utility.trace('p_input_9 = '||p_input_9);
2999: hr_utility.trace('p_input_10 = '||p_input_10);
3000: hr_utility.trace('p_input_11 = '||p_input_11);
3001: hr_utility.trace('p_input_12 = '||p_input_12);
3002: hr_utility.trace('p_input_13 = '||p_input_13);

Line 2999: hr_utility.trace('p_input_10 = '||p_input_10);

2995: hr_utility.trace('p_input_6 = '||p_input_6);
2996: hr_utility.trace('p_input_7 = '||p_input_7);
2997: hr_utility.trace('p_input_8 = '||p_input_8);
2998: hr_utility.trace('p_input_9 = '||p_input_9);
2999: hr_utility.trace('p_input_10 = '||p_input_10);
3000: hr_utility.trace('p_input_11 = '||p_input_11);
3001: hr_utility.trace('p_input_12 = '||p_input_12);
3002: hr_utility.trace('p_input_13 = '||p_input_13);
3003: hr_utility.trace('p_input_14 = '||p_input_14);

Line 3000: hr_utility.trace('p_input_11 = '||p_input_11);

2996: hr_utility.trace('p_input_7 = '||p_input_7);
2997: hr_utility.trace('p_input_8 = '||p_input_8);
2998: hr_utility.trace('p_input_9 = '||p_input_9);
2999: hr_utility.trace('p_input_10 = '||p_input_10);
3000: hr_utility.trace('p_input_11 = '||p_input_11);
3001: hr_utility.trace('p_input_12 = '||p_input_12);
3002: hr_utility.trace('p_input_13 = '||p_input_13);
3003: hr_utility.trace('p_input_14 = '||p_input_14);
3004: hr_utility.trace('p_input_15 = '||p_input_15);

Line 3001: hr_utility.trace('p_input_12 = '||p_input_12);

2997: hr_utility.trace('p_input_8 = '||p_input_8);
2998: hr_utility.trace('p_input_9 = '||p_input_9);
2999: hr_utility.trace('p_input_10 = '||p_input_10);
3000: hr_utility.trace('p_input_11 = '||p_input_11);
3001: hr_utility.trace('p_input_12 = '||p_input_12);
3002: hr_utility.trace('p_input_13 = '||p_input_13);
3003: hr_utility.trace('p_input_14 = '||p_input_14);
3004: hr_utility.trace('p_input_15 = '||p_input_15);
3005: -- Validation Starts

Line 3002: hr_utility.trace('p_input_13 = '||p_input_13);

2998: hr_utility.trace('p_input_9 = '||p_input_9);
2999: hr_utility.trace('p_input_10 = '||p_input_10);
3000: hr_utility.trace('p_input_11 = '||p_input_11);
3001: hr_utility.trace('p_input_12 = '||p_input_12);
3002: hr_utility.trace('p_input_13 = '||p_input_13);
3003: hr_utility.trace('p_input_14 = '||p_input_14);
3004: hr_utility.trace('p_input_15 = '||p_input_15);
3005: -- Validation Starts
3006: If p_input_40='FLAT' THEN

Line 3003: hr_utility.trace('p_input_14 = '||p_input_14);

2999: hr_utility.trace('p_input_10 = '||p_input_10);
3000: hr_utility.trace('p_input_11 = '||p_input_11);
3001: hr_utility.trace('p_input_12 = '||p_input_12);
3002: hr_utility.trace('p_input_13 = '||p_input_13);
3003: hr_utility.trace('p_input_14 = '||p_input_14);
3004: hr_utility.trace('p_input_15 = '||p_input_15);
3005: -- Validation Starts
3006: If p_input_40='FLAT' THEN
3007: --{

Line 3004: hr_utility.trace('p_input_15 = '||p_input_15);

3000: hr_utility.trace('p_input_11 = '||p_input_11);
3001: hr_utility.trace('p_input_12 = '||p_input_12);
3002: hr_utility.trace('p_input_13 = '||p_input_13);
3003: hr_utility.trace('p_input_14 = '||p_input_14);
3004: hr_utility.trace('p_input_15 = '||p_input_15);
3005: -- Validation Starts
3006: If p_input_40='FLAT' THEN
3007: --{
3008: -- These validation are used only for mf file only.

Line 3011: hr_utility.trace('before data_validation of ein');

3007: --{
3008: -- These validation are used only for mf file only.
3009: -- not for any of the audit report
3010: --
3011: hr_utility.trace('before data_validation of ein');
3012: l_emp_ein :=
3013: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
3014: p_report_type,
3015: p_format,

Line 3033: hr_utility.trace('before data_validation of Other EIN');

3029: END IF;
3030:
3031: IF l_other_ein is not null then
3032: --{
3033: hr_utility.trace('before data_validation of Other EIN');
3034: l_other_ein :=
3035: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
3036: p_report_type,
3037: p_format,

Line 3073: hr_utility.trace(parameter_record(i).p_parameter_name||' = '

3069: -- Validating above data based on the report_qualifier and number entries
3070: --
3071: FOR i in 1..l_records
3072: LOOP
3073: hr_utility.trace(parameter_record(i).p_parameter_name||' = '
3074: ||parameter_record(i).p_parameter_value);
3075:
3076: hr_utility.trace('value of(i)|| = '|| to_char(i));
3077:

Line 3076: hr_utility.trace('value of(i)|| = '|| to_char(i));

3072: LOOP
3073: hr_utility.trace(parameter_record(i).p_parameter_name||' = '
3074: ||parameter_record(i).p_parameter_value);
3075:
3076: hr_utility.trace('value of(i)|| = '|| to_char(i));
3077:
3078: parameter_record(i).p_output_value :=
3079: pay_us_reporting_utils_pkg.data_validation( p_effective_date,
3080: p_report_type,

Line 3096: hr_utility.trace(parameter_record(i).p_parameter_name||' = '

3092: sp_out_2);
3093: IF p_exclude_from_output = 'Y' THEN
3094: l_exclude_from_output_chk := TRUE;
3095: END IF;
3096: hr_utility.trace(parameter_record(i).p_parameter_name||' = '
3097: ||parameter_record(i).p_output_value);
3098: hr_utility.trace('After validating the parameter for -ve Value p_exclude_from_output = '||p_exclude_from_output);
3099: END LOOP;
3100: -- Validation Ends here

Line 3098: hr_utility.trace('After validating the parameter for -ve Value p_exclude_from_output = '||p_exclude_from_output);

3094: l_exclude_from_output_chk := TRUE;
3095: END IF;
3096: hr_utility.trace(parameter_record(i).p_parameter_name||' = '
3097: ||parameter_record(i).p_output_value);
3098: hr_utility.trace('After validating the parameter for -ve Value p_exclude_from_output = '||p_exclude_from_output);
3099: END LOOP;
3100: -- Validation Ends here
3101: --
3102: -- Formatting RSSUMM Record depending on report_qualifier

Line 3166: hr_utility.trace(' Length of ret_str_len = ' || to_char(ret_str_len));

3162: ||lpad(' ',384);
3163: --}
3164: END IF;
3165: ret_str_len:=length(return_value);
3166: hr_utility.trace(' Length of ret_str_len = ' || to_char(ret_str_len));
3167: --}
3168: ELSIF p_input_40 = 'CSV' THEN
3169: --{
3170: l_rt_end_of_rec := lpad(' ',158);

Line 3272: hr_utility.trace('Report Qualifier before Formatting RST Record '

3268: r_sit_tax := p_sit_tax;
3269: r_month1_no_employee := p_month1_no_employee;
3270: r_month2_no_employee := p_month2_no_employee;
3271: r_month3_no_employee := p_month3_no_employee;
3272: hr_utility.trace('Report Qualifier before Formatting RST Record '
3273: ||p_report_qualifier);
3274: /*r_input_2 := lpad(' ',7);*/
3275: r_total_no_of_employee := lpad(substr(nvl(p_total_no_of_employee,'0'),1,7),7,0);
3276: r_sui_reduction_wages := lpad(nvl(r_sui_reduction_wages,'0'), 14, '0');

Line 3346: hr_utility.trace('Formatting RU Record');

3342: l_end_of_rec varchar2(20) ;
3343:
3344: BEGIN
3345: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);
3346: hr_utility.trace('Formatting RU Record');
3347: hr_utility.trace('RU Record Format Mode '||p_record_format_mode);
3348: l_no_of_rs_record := lpad(substr(nvl(p_number_of_RS_record,'0'),1,7),7,0);
3349:
3350: /* Bug 3527986 Removed Delimiters fro NY */

Line 3347: hr_utility.trace('RU Record Format Mode '||p_record_format_mode);

3343:
3344: BEGIN
3345: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);
3346: hr_utility.trace('Formatting RU Record');
3347: hr_utility.trace('RU Record Format Mode '||p_record_format_mode);
3348: l_no_of_rs_record := lpad(substr(nvl(p_number_of_RS_record,'0'),1,7),7,0);
3349:
3350: /* Bug 3527986 Removed Delimiters fro NY */
3351: /*

Line 3414: hr_utility.trace('Report Qualifier before Formatting RF Record '

3410:
3411: BEGIN
3412: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);
3413: -- Formatting RF Record
3414: hr_utility.trace('Report Qualifier before Formatting RF Record '
3415: ||p_report_qualifier);
3416:
3417: /* Bug:2259849. */
3418: IF ((p_report_qualifier = 'LA_SQWL' ) OR

Line 3456: --hr_utility.trace_on(null, 'NVSQWL');

3452: END format_SQWL_RF_record; -- End of Formatting RF Record for SQWL Reporting
3453: --
3454: --BEGIN
3455:
3456: --hr_utility.trace_on(null, 'NVSQWL');
3457:
3458: END pay_us_mmrf_sqwl_format_record; -- End of Package Body