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

APPS.PAY_US_MMRF_SQWL_FORMAT_RECORD dependencies on HR_UTILITY

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

119: IF ((p_record_name = 'RS') AND
120: (p_input_3 = 'Other State Data')
121: ) THEN
122: l_length := 10;
123: hr_utility.trace('RS. Other State Data.l_length = '||to_char(l_length));
124: ELSIF p_record_name = 'RS' THEN
125: --{
126: IF p_report_qualifier = 'GA_SQWL' THEN
127: IF p_input_3 = 'SUI Insurance Wages' THEN

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

339: r_input_39 varchar2(300);
340:
341: BEGIN
342: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);
343: hr_utility.trace('RA Record Formatting started ');
344: hr_utility.trace('Format_SQWL_RA_Record Begin for Company '|| p_input_7);
345: -- Initializing local variables with parameter value
346: --{
347: r_input_2 := p_input_2;

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

340:
341: BEGIN
342: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);
343: hr_utility.trace('RA Record Formatting started ');
344: hr_utility.trace('Format_SQWL_RA_Record Begin for Company '|| p_input_7);
345: -- Initializing local variables with parameter value
346: --{
347: r_input_2 := p_input_2;
348: r_input_3 := p_input_3;

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

405:
406: IF p_exclude_from_output = 'Y' THEN
407: l_exclude_from_output_chk := TRUE;
408: END IF;
409: hr_utility.trace('Valid EIN '||l_emp_ein);
410: -- Validation Ends
411: --
412: -- Formatiing Starts
413: /*Pos:3-11 EIN blank for LA,NH SQWL. */

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

470: END IF;
471: --}
472: ELSE
473: l_pin := rpad(substr(nvl(p_input_3,' '),1,17),17);
474: hr_utility.trace(' l_pin = '||l_pin);
475: --}
476: END IF;
477:
478: IF ( p_report_qualifier = 'AL_SQWL' ) THEN

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

509: IF ((p_input_32 = '1' ) OR
510: (p_input_32 = '2' ) OR
511: (p_input_32 = '3' ) OR
512: (p_input_32 = '4' ) ) THEN
513: hr_utility.trace('Preferred method of code is correct. it is '||p_input_32);
514: l_pblm_code:= p_input_32;
515: ELSE
516: hr_utility.trace('Preferred method of code is incorrect. it is '||p_input_32);
517: l_pblm_code:= lpad(' ',1);

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

512: (p_input_32 = '4' ) ) THEN
513: hr_utility.trace('Preferred method of code is correct. it is '||p_input_32);
514: l_pblm_code:= p_input_32;
515: ELSE
516: hr_utility.trace('Preferred method of code is incorrect. it is '||p_input_32);
517: l_pblm_code:= lpad(' ',1);
518: END IF;
519:
520: If( (p_input_33 = 'A' )OR

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

522: (p_input_33 = 'L' )OR
523: (p_input_33 = 'P' )OR
524: (p_input_33 = 'O' )) THEN
525: l_preparer_code:= p_input_33;
526: hr_utility.trace('l_preparer_code is correct. it is '||p_input_33);
527: ELSE
528: IF (p_report_qualifier = 'AL_SQWL') THEN
529: l_preparer_code := lpad('O',1);
530: ELSE

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

529: l_preparer_code := lpad('O',1);
530: ELSE
531: l_preparer_code:= lpad(' ',1);
532: END IF;
533: hr_utility.trace('l_preparer_code is incorrect. it is '||p_input_33);
534: END IF;
535:
536: IF ((p_report_qualifier = 'LA_SQWL')OR
537: (p_report_qualifier = 'NH_SQWL')OR

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

604: l_pblm_code:= lpad(' ',1);
605: l_preparer_code:= lpad(' ',1);
606: END IF;
607:
608: hr_utility.trace('p_input_40 = '||p_input_40);
609: IF (p_report_qualifier = 'NY_SQWL') THEN
610: /* Bug 3527986 Removed Delimiters fro NY */
611: --l_end_of_rec := p_end_of_rec;
612: return_value:='RA'

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

675: ||l_preparer_code
676: ||lpad(' ',12)
677: ||l_end_of_rec ;
678: ret_str_len:=length(return_value);
679: hr_utility.trace('---------------------FLAT----------------------------');
680: END IF;
681: ELSIF p_input_40 = 'CSV' THEN
682: hr_utility.trace('---------------------CSV----------------------------');
683: return_value:='RA'||','||p_input_2||','||p_input_3

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

678: ret_str_len:=length(return_value);
679: hr_utility.trace('---------------------FLAT----------------------------');
680: END IF;
681: ELSIF p_input_40 = 'CSV' THEN
682: hr_utility.trace('---------------------CSV----------------------------');
683: return_value:='RA'||','||p_input_2||','||p_input_3
684: ||','||rpad(substr(nvl(p_input_4,'0'),1,1),1)
685: ||','||rpad(substr(nvl(p_input_5,' '),1,6),6)
686: ||','||rpad(substr(nvl(p_input_6,' '),1,2),2)

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

715: ||','||rpad(substr(nvl(p_input_31,' '),1,10),10)
716: ||','||p_input_32
717: ||','||p_input_33
718: ||','||lpad(' ',12);
719: hr_utility.trace('---------------------CSV----------------------------');
720: hr_utility.trace(return_value);
721: END IF;
722: p_error := l_exclude_from_output_chk;
723: ret_str_len:=length(return_value);

Line 720: hr_utility.trace(return_value);

716: ||','||p_input_32
717: ||','||p_input_33
718: ||','||lpad(' ',12);
719: hr_utility.trace('---------------------CSV----------------------------');
720: hr_utility.trace(return_value);
721: END IF;
722: p_error := l_exclude_from_output_chk;
723: ret_str_len:=length(return_value);
724: return return_value;

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

867:
868: p_end_of_rec varchar2(20);
869: BEGIN
870: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);
871: hr_utility.trace('RE Record Formatting started ');
872: -- Initializing local variables with parameter value
873: --{
874: r_input_2 := p_input_2;
875: r_input_3 := p_input_3;

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

914: IF p_record_name = 'RE' THEN -- p_record_name
915: --{
916: /* Check for agent indicator code p_input_3 */
917: IF p_input_3 = 'Y' THEN
918: hr_utility.trace('agent indicator is Y');
919: l_agent_indicator := '1';
920: l_emp_ein := p_input_5;
921: l_agent_ein := p_input_4;
922: ELSE

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

920: l_emp_ein := p_input_5;
921: l_agent_ein := p_input_4;
922: ELSE
923: l_agent_indicator:=lpad(' ','1');
924: hr_utility.trace('agent indicator is not 1');
925: l_emp_ein := p_input_4;
926: l_agent_ein := lpad(' ',9);
927: END IF;
928:

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

993: -- Validation for RE Record starts
994: -- These validation are used only for mf file only.
995: -- not for any of the audit report
996: --
997: hr_utility.trace('before data_validation of ein');
998: l_emp_ein :=
999: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
1000: p_report_type,
1001: p_format,

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

1036: END IF;
1037: --}
1038: END IF; -- agent_indicator
1039:
1040: hr_utility.trace('after data_validation of EIN');
1041: l_input_8 := replace(r_input_8,' ');
1042:
1043: IF l_input_8 IS NOT NULL THEN --Checking Other EIN for validation
1044: --{

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

1041: l_input_8 := replace(r_input_8,' ');
1042:
1043: IF l_input_8 IS NOT NULL THEN --Checking Other EIN for validation
1044: --{
1045: hr_utility.trace('before data_validation of other EIN');
1046: l_other_ein:=
1047: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
1048: p_report_type,
1049: p_format,

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

1058: p_exclude_from_output,
1059: sp_out_1,
1060: sp_out_2
1061: );
1062: hr_utility.trace('after data_validation of Other EIN');
1063: IF p_exclude_from_output = 'Y' THEN
1064: l_exclude_from_output_chk := TRUE;
1065: END IF;
1066: --}

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

1662: r_input_39 varchar2(300);
1663:
1664: BEGIN
1665: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);
1666: hr_utility.trace('Formatting RS record for SQWL ');
1667: hr_utility.trace('p_report_qualifier = '||p_report_qualifier);
1668: -- Initializing local variables with parameter value
1669: --{
1670: r_input_2 := p_input_2;

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

1663:
1664: BEGIN
1665: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);
1666: hr_utility.trace('Formatting RS record for SQWL ');
1667: hr_utility.trace('p_report_qualifier = '||p_report_qualifier);
1668: -- Initializing local variables with parameter value
1669: --{
1670: r_input_2 := p_input_2;
1671: r_input_3 := p_input_3;

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

1713:
1714: r_input_2 := lpad(replace(p_input_2,' '),2,0);
1715: r_input_26 := lpad(replace(p_input_26,' '),2,0);
1716:
1717: hr_utility.trace('l_state_length = '||to_char(l_state_length));
1718: hr_utility.trace('l_state_length < 2.State code r_input_2 = '||r_input_2);
1719: hr_utility.trace('State code r_input_26 = '||r_input_26);
1720: END IF;
1721:

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

1714: r_input_2 := lpad(replace(p_input_2,' '),2,0);
1715: r_input_26 := lpad(replace(p_input_26,' '),2,0);
1716:
1717: hr_utility.trace('l_state_length = '||to_char(l_state_length));
1718: hr_utility.trace('l_state_length < 2.State code r_input_2 = '||r_input_2);
1719: hr_utility.trace('State code r_input_26 = '||r_input_26);
1720: END IF;
1721:
1722: /* Pos:3 - 4 State Code Blank for GA SQWL, State Abbreviation for AL SQWL */

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

1715: r_input_26 := lpad(replace(p_input_26,' '),2,0);
1716:
1717: hr_utility.trace('l_state_length = '||to_char(l_state_length));
1718: hr_utility.trace('l_state_length < 2.State code r_input_2 = '||r_input_2);
1719: hr_utility.trace('State code r_input_26 = '||r_input_26);
1720: END IF;
1721:
1722: /* Pos:3 - 4 State Code Blank for GA SQWL, State Abbreviation for AL SQWL */
1723: IF (p_report_qualifier = 'GA_SQWL') OR

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

1771: ELSE
1772: l_ssn := replace(replace(r_input_4,'-'),',');
1773: END IF;
1774:
1775: hr_utility.trace('SSN after Validation and Formatting = '||l_ssn);
1776:
1777:
1778: IF p_report_qualifier = 'LA_SQWL' THEN
1779: --{

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

1806: nvl(substr(r_input_7,1,20),' '),20));
1807: l_suffix := pay_us_reporting_utils_pkg.Character_check(rpad(
1808: nvl(substr(r_input_8,1,4),' '),4));
1809: END IF;
1810: hr_utility.trace('l_suffix = '||l_suffix);
1811:
1812: /* Middle Name blank for MD_SQWL. */
1813: IF p_report_qualifier = 'MD_SQWL' THEN
1814: l_middle_name := lpad(' ',15);

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

1833: (p_report_qualifier = 'UT_SQWL') OR /* Bug 9913439 */
1834: (p_report_qualifier = 'FL_SQWL') OR
1835: (p_report_qualifier = 'NM_SQWL')) THEN /* Bug# 14356614*/
1836: --{
1837: hr_utility.trace('Pos:69 - 149 blank for AL and NC');
1838: l_suffix := lpad(' ',4);
1839: r_input_9 := lpad(' ',22);
1840: r_input_10 := lpad(' ',22);
1841: r_input_11 := lpad(' ',22);

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

1939: ELSIF p_report_qualifier = 'MO_SQWL' THEN
1940: r_input_18 := '00';
1941: ELSIF p_report_qualifier = 'NC_SQWL' THEN
1942: r_input_18 := replace(nvl(p_input_18,'N'),'Y','S')||' ';
1943: hr_utility.trace('Seasonal worker for NC is '||p_input_18);
1944: ELSIF (p_report_qualifier = 'CA_SQWL') THEN
1945: r_input_18 := p_input_18||' ';
1946: ELSIF (p_report_qualifier = 'NY_SQWL') THEN
1947: r_input_18 := lpad(' ',2);

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

2108: IF ((p_report_qualifier = 'MN_SQWL') OR
2109: (p_report_qualifier = 'OR_SQWL')) THEN
2110:
2111: l_hours_worked := to_number(replace(r_input_34,' '));
2112: hr_utility.trace('l_hours_worked = '||to_char(l_hours_worked));
2113:
2114: IF l_hours_worked <0 THEN
2115: hr_utility.trace('Error in RS record for Employee '||p_input_1||
2116: ' Negative hours');

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

2111: l_hours_worked := to_number(replace(r_input_34,' '));
2112: hr_utility.trace('l_hours_worked = '||to_char(l_hours_worked));
2113:
2114: IF l_hours_worked <0 THEN
2115: hr_utility.trace('Error in RS record for Employee '||p_input_1||
2116: ' Negative hours');
2117: l_exclude_from_output_chk := TRUE;
2118: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','A');
2119: pay_core_utils.push_token('record_name',p_record_name);

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

2424:
2425: /* Pos:298-307 State Excess Wages for LA_SQWL. */
2426: IF (p_report_qualifier = 'LA_SQWL') THEN
2427: IF p_input_40 = 'FLAT' THEN
2428: hr_utility.trace(' Other state data AL,MD,OH ');
2429: r_input_29 :=
2430: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
2431: p_report_type,
2432: p_format,

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

2450: END IF;
2451:
2452: IF p_report_qualifier = 'NC_SQWL' THEN
2453: r_input_29 := rpad(upper(rpad(p_input_29, 6, ' ')),10);
2454: hr_utility.trace('State Control No for NC is '||r_input_29);
2455: END IF;
2456:
2457: /* Pos:308 - 308 Tax type code formatting */
2458: /* Modified for Bug#13377871 */

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

2465:
2466: /* Pos:309 - 319 Local taxable wages filled with zeros
2467: Pos:320 - 330 Local Income tax withheld filled with zeros */
2468:
2469: hr_utility.trace('Zero fill for SQWLs. p_report_qualifier = '||p_report_qualifier);
2470: r_input_31 := rpad(0,11,0);
2471: r_input_32 := rpad(0,11,0);
2472: hr_utility.trace('r_input_31 '||r_input_31);
2473: hr_utility.trace('r_input_32 '||r_input_32);

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

2468:
2469: hr_utility.trace('Zero fill for SQWLs. p_report_qualifier = '||p_report_qualifier);
2470: r_input_31 := rpad(0,11,0);
2471: r_input_32 := rpad(0,11,0);
2472: hr_utility.trace('r_input_31 '||r_input_31);
2473: hr_utility.trace('r_input_32 '||r_input_32);
2474:
2475: /* Pos:309-330 Blank for SC_SQWL. State wages and SIT withheld. */
2476: IF ((p_report_qualifier = 'SC_SQWL') OR

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

2469: hr_utility.trace('Zero fill for SQWLs. p_report_qualifier = '||p_report_qualifier);
2470: r_input_31 := rpad(0,11,0);
2471: r_input_32 := rpad(0,11,0);
2472: hr_utility.trace('r_input_31 '||r_input_31);
2473: hr_utility.trace('r_input_32 '||r_input_32);
2474:
2475: /* Pos:309-330 Blank for SC_SQWL. State wages and SIT withheld. */
2476: IF ((p_report_qualifier = 'SC_SQWL') OR
2477: (p_report_qualifier = 'GA_SQWL') OR

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

2563: r_input_34 := rpad(lpad(nvl(r_input_34,' '),9,0),75);
2564: r_input_35 := lpad(' ',75);
2565: /* 4559359 */
2566: /* ELSIF p_report_qualifier = 'TX_SQWL' THEN
2567: hr_utility.trace(' r_input_34 := '|| r_input_34 ) ;
2568: r_input_34 := lpad(nvl(r_input_34,' '),3,'0') ||
2569: lpad(substr(nvl(r_input_35,' '),1,3),3) || /* County Code * /
2570: lpad(' ',1) ||
2571: lpad(' ',6) || /* NAICS Code * /

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

2604: l_end_of_rec := p_end_of_rec;
2605: END IF;
2606:
2607: IF p_report_qualifier = 'WA_SQWL' THEN
2608: hr_utility.trace('WA_SQWL');
2609: r_input_4 :=
2610: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
2611: p_report_type,
2612: p_format,

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

2624: IF p_exclude_from_output = 'Y' THEN
2625: l_exclude_from_output_chk := TRUE;
2626: END IF;
2627: l_hours_worked := to_number(replace(p_input_3,' '));
2628: hr_utility.trace('l_hours_worked = '||to_char(l_hours_worked));
2629: IF l_hours_worked <0 THEN
2630: hr_utility.trace('Error in RS record for Employee '||p_input_2||
2631: ' Negative hours');
2632: l_exclude_from_output_chk := TRUE;

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

2626: END IF;
2627: l_hours_worked := to_number(replace(p_input_3,' '));
2628: hr_utility.trace('l_hours_worked = '||to_char(l_hours_worked));
2629: IF l_hours_worked <0 THEN
2630: hr_utility.trace('Error in RS record for Employee '||p_input_2||
2631: ' Negative hours');
2632: l_exclude_from_output_chk := TRUE;
2633: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','A');
2634: pay_core_utils.push_token('record_name',p_record_name);

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

2634: pay_core_utils.push_token('record_name',p_record_name);
2635: pay_core_utils.push_token('name_or_number',substr(p_input_2,1,50));
2636: pay_core_utils.push_token('description','Negative hours');
2637: END IF;
2638: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
2639: -- Validation Starts
2640: -- EIN Validation
2641: r_input_5 :=
2642: pay_us_reporting_utils_pkg.data_validation(p_effective_date,

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

2656:
2657: IF p_exclude_from_output = 'Y' THEN
2658: l_exclude_from_output_chk := TRUE;
2659: END IF;
2660: hr_utility.trace('Valid EIN '||r_input_5);
2661: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
2662: -- Validation Ends
2663: r_input_2 := replace(p_input_2,',');
2664: r_input_4 := to_char(to_number(r_input_4/100),'000000.00');

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

2657: IF p_exclude_from_output = 'Y' THEN
2658: l_exclude_from_output_chk := TRUE;
2659: END IF;
2660: hr_utility.trace('Valid EIN '||r_input_5);
2661: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
2662: -- Validation Ends
2663: r_input_2 := replace(p_input_2,',');
2664: r_input_4 := to_char(to_number(r_input_4/100),'000000.00');
2665: /*

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

2665: /*
2666: l_wa_sqwl_outstring := p_input_1||','||r_input_2||','||p_input_3||','||r_input_4;
2667: */
2668: l_wa_sqwl_outstring := r_input_5||','||p_input_1||','||r_input_2||','||p_input_3||','||r_input_4;
2669: hr_utility.trace('l_wa_sqwl_outstring = '||l_wa_sqwl_outstring);
2670: END IF;
2671:
2672: IF p_input_40 = 'FLAT' THEN
2673: --{ Start of formatting FLAT type RS Record

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

2796: ||r_input_35
2797: ||l_last_field
2798: ||l_end_of_rec;
2799: END IF;
2800: hr_utility.trace('Length of return value = '||to_char(length(return_value)));
2801: --} End of formatting FLAT Type RS Record
2802: ELSIF p_input_40 = 'CSV' THEN
2803: --{ Start of formatting RS record in CSV format
2804:

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

3105: parameter_record input_parameter_record;
3106:
3107: BEGIN
3108: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);
3109: hr_utility.trace('RT Record Formatting started for SQWL reporting ');
3110:
3111: -- Validation Starts
3112: If p_input_40='FLAT' THEN
3113: --{

Line 3161: hr_utility.trace('parameter_record(7).p_parameter_value '||parameter_record(7).p_parameter_value);

3157:
3158: parameter_record(7).p_parameter_name:= 'UT Tax Rate';
3159: parameter_record(7).p_parameter_value:=lpad(to_char(l_sui_tax_rate*10),5,'0');
3160:
3161: hr_utility.trace('parameter_record(7).p_parameter_value '||parameter_record(7).p_parameter_value);
3162:
3163: parameter_record(8).p_parameter_name:= 'UT Tax Due';
3164: parameter_record(8).p_parameter_value:= lpad(to_char(l_sui_tax_due*100),9,'0');
3165:

Line 3166: hr_utility.trace('parameter_record(8).p_parameter_value '||parameter_record(8).p_parameter_value);

3162:
3163: parameter_record(8).p_parameter_name:= 'UT Tax Due';
3164: parameter_record(8).p_parameter_value:= lpad(to_char(l_sui_tax_due*100),9,'0');
3165:
3166: hr_utility.trace('parameter_record(8).p_parameter_value '||parameter_record(8).p_parameter_value);
3167: --}
3168: l_records :=8;
3169: l_end_of_rec := p_end_of_rec;
3170: --}

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

3254: sp_out_2);
3255: IF p_exclude_from_output = 'Y' THEN
3256: l_exclude_from_output_chk := TRUE;
3257: END IF;
3258: hr_utility.trace(parameter_record(i).p_parameter_name||' = '
3259: ||parameter_record(i).p_output_value);
3260: hr_utility.trace('After validating the parameter for -ve Value p_exclude_from_output = '||p_exclude_from_output);
3261: END LOOP;
3262: -- Validation Ends here

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

3256: l_exclude_from_output_chk := TRUE;
3257: END IF;
3258: hr_utility.trace(parameter_record(i).p_parameter_name||' = '
3259: ||parameter_record(i).p_output_value);
3260: hr_utility.trace('After validating the parameter for -ve Value p_exclude_from_output = '||p_exclude_from_output);
3261: END LOOP;
3262: -- Validation Ends here
3263:
3264: -- For Alabama, Zero Fill Pos : 250 - 264 /* Employer Contributions to Health Savings Account */

Line 3299: hr_utility.trace('parameter_record7.p_output_value '||parameter_record(7).p_output_value);

3295: ||l_end_of_rec;
3296:
3297: ELSIF p_report_qualifier = 'UT_SQWL' THEN /*bug 9913439 */
3298: --{
3299: hr_utility.trace('parameter_record7.p_output_value '||parameter_record(7).p_output_value);
3300: return_value := 'RT'||l_input_2
3301: ||lpad(parameter_record(1).p_parameter_value,15,'0')
3302: --||lpad(' ',456)
3303: ||lpad(' ',375)

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

3483: parameter_record input_parameter_record;
3484:
3485: BEGIN
3486: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);
3487: hr_utility.trace('RSSUMM Record Formatting started for SQWL reporting ');
3488:
3489: l_emp_ein := p_input_4;
3490: l_other_ein := p_input_5;
3491: hr_utility.trace('Before Valaditing Values are ...');

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

3487: hr_utility.trace('RSSUMM Record Formatting started for SQWL reporting ');
3488:
3489: l_emp_ein := p_input_4;
3490: l_other_ein := p_input_5;
3491: hr_utility.trace('Before Valaditing Values are ...');
3492: hr_utility.trace('p_input_1 = '||p_input_1);
3493: hr_utility.trace('p_input_2 = '||p_input_2);
3494: hr_utility.trace('p_input_3 = '||p_input_3);
3495: hr_utility.trace('p_input_4 = '||p_input_4);

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

3488:
3489: l_emp_ein := p_input_4;
3490: l_other_ein := p_input_5;
3491: hr_utility.trace('Before Valaditing Values are ...');
3492: hr_utility.trace('p_input_1 = '||p_input_1);
3493: hr_utility.trace('p_input_2 = '||p_input_2);
3494: hr_utility.trace('p_input_3 = '||p_input_3);
3495: hr_utility.trace('p_input_4 = '||p_input_4);
3496: hr_utility.trace('p_input_5 = '||p_input_5);

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

3489: l_emp_ein := p_input_4;
3490: l_other_ein := p_input_5;
3491: hr_utility.trace('Before Valaditing Values are ...');
3492: hr_utility.trace('p_input_1 = '||p_input_1);
3493: hr_utility.trace('p_input_2 = '||p_input_2);
3494: hr_utility.trace('p_input_3 = '||p_input_3);
3495: hr_utility.trace('p_input_4 = '||p_input_4);
3496: hr_utility.trace('p_input_5 = '||p_input_5);
3497: hr_utility.trace('p_input_6 = '||p_input_6);

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

3490: l_other_ein := p_input_5;
3491: hr_utility.trace('Before Valaditing Values are ...');
3492: hr_utility.trace('p_input_1 = '||p_input_1);
3493: hr_utility.trace('p_input_2 = '||p_input_2);
3494: hr_utility.trace('p_input_3 = '||p_input_3);
3495: hr_utility.trace('p_input_4 = '||p_input_4);
3496: hr_utility.trace('p_input_5 = '||p_input_5);
3497: hr_utility.trace('p_input_6 = '||p_input_6);
3498: hr_utility.trace('p_input_7 = '||p_input_7);

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

3491: hr_utility.trace('Before Valaditing Values are ...');
3492: hr_utility.trace('p_input_1 = '||p_input_1);
3493: hr_utility.trace('p_input_2 = '||p_input_2);
3494: hr_utility.trace('p_input_3 = '||p_input_3);
3495: hr_utility.trace('p_input_4 = '||p_input_4);
3496: hr_utility.trace('p_input_5 = '||p_input_5);
3497: hr_utility.trace('p_input_6 = '||p_input_6);
3498: hr_utility.trace('p_input_7 = '||p_input_7);
3499: hr_utility.trace('p_input_8 = '||p_input_8);

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

3492: hr_utility.trace('p_input_1 = '||p_input_1);
3493: hr_utility.trace('p_input_2 = '||p_input_2);
3494: hr_utility.trace('p_input_3 = '||p_input_3);
3495: hr_utility.trace('p_input_4 = '||p_input_4);
3496: hr_utility.trace('p_input_5 = '||p_input_5);
3497: hr_utility.trace('p_input_6 = '||p_input_6);
3498: hr_utility.trace('p_input_7 = '||p_input_7);
3499: hr_utility.trace('p_input_8 = '||p_input_8);
3500: hr_utility.trace('p_input_9 = '||p_input_9);

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

3493: hr_utility.trace('p_input_2 = '||p_input_2);
3494: hr_utility.trace('p_input_3 = '||p_input_3);
3495: hr_utility.trace('p_input_4 = '||p_input_4);
3496: hr_utility.trace('p_input_5 = '||p_input_5);
3497: hr_utility.trace('p_input_6 = '||p_input_6);
3498: hr_utility.trace('p_input_7 = '||p_input_7);
3499: hr_utility.trace('p_input_8 = '||p_input_8);
3500: hr_utility.trace('p_input_9 = '||p_input_9);
3501: hr_utility.trace('p_input_10 = '||p_input_10);

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

3494: hr_utility.trace('p_input_3 = '||p_input_3);
3495: hr_utility.trace('p_input_4 = '||p_input_4);
3496: hr_utility.trace('p_input_5 = '||p_input_5);
3497: hr_utility.trace('p_input_6 = '||p_input_6);
3498: hr_utility.trace('p_input_7 = '||p_input_7);
3499: hr_utility.trace('p_input_8 = '||p_input_8);
3500: hr_utility.trace('p_input_9 = '||p_input_9);
3501: hr_utility.trace('p_input_10 = '||p_input_10);
3502: hr_utility.trace('p_input_11 = '||p_input_11);

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

3495: hr_utility.trace('p_input_4 = '||p_input_4);
3496: hr_utility.trace('p_input_5 = '||p_input_5);
3497: hr_utility.trace('p_input_6 = '||p_input_6);
3498: hr_utility.trace('p_input_7 = '||p_input_7);
3499: hr_utility.trace('p_input_8 = '||p_input_8);
3500: hr_utility.trace('p_input_9 = '||p_input_9);
3501: hr_utility.trace('p_input_10 = '||p_input_10);
3502: hr_utility.trace('p_input_11 = '||p_input_11);
3503: hr_utility.trace('p_input_12 = '||p_input_12);

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

3496: hr_utility.trace('p_input_5 = '||p_input_5);
3497: hr_utility.trace('p_input_6 = '||p_input_6);
3498: hr_utility.trace('p_input_7 = '||p_input_7);
3499: hr_utility.trace('p_input_8 = '||p_input_8);
3500: hr_utility.trace('p_input_9 = '||p_input_9);
3501: hr_utility.trace('p_input_10 = '||p_input_10);
3502: hr_utility.trace('p_input_11 = '||p_input_11);
3503: hr_utility.trace('p_input_12 = '||p_input_12);
3504: hr_utility.trace('p_input_13 = '||p_input_13);

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

3497: hr_utility.trace('p_input_6 = '||p_input_6);
3498: hr_utility.trace('p_input_7 = '||p_input_7);
3499: hr_utility.trace('p_input_8 = '||p_input_8);
3500: hr_utility.trace('p_input_9 = '||p_input_9);
3501: hr_utility.trace('p_input_10 = '||p_input_10);
3502: hr_utility.trace('p_input_11 = '||p_input_11);
3503: hr_utility.trace('p_input_12 = '||p_input_12);
3504: hr_utility.trace('p_input_13 = '||p_input_13);
3505: hr_utility.trace('p_input_14 = '||p_input_14);

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

3498: hr_utility.trace('p_input_7 = '||p_input_7);
3499: hr_utility.trace('p_input_8 = '||p_input_8);
3500: hr_utility.trace('p_input_9 = '||p_input_9);
3501: hr_utility.trace('p_input_10 = '||p_input_10);
3502: hr_utility.trace('p_input_11 = '||p_input_11);
3503: hr_utility.trace('p_input_12 = '||p_input_12);
3504: hr_utility.trace('p_input_13 = '||p_input_13);
3505: hr_utility.trace('p_input_14 = '||p_input_14);
3506: hr_utility.trace('p_input_15 = '||p_input_15);

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

3499: hr_utility.trace('p_input_8 = '||p_input_8);
3500: hr_utility.trace('p_input_9 = '||p_input_9);
3501: hr_utility.trace('p_input_10 = '||p_input_10);
3502: hr_utility.trace('p_input_11 = '||p_input_11);
3503: hr_utility.trace('p_input_12 = '||p_input_12);
3504: hr_utility.trace('p_input_13 = '||p_input_13);
3505: hr_utility.trace('p_input_14 = '||p_input_14);
3506: hr_utility.trace('p_input_15 = '||p_input_15);
3507: -- Validation Starts

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

3500: hr_utility.trace('p_input_9 = '||p_input_9);
3501: hr_utility.trace('p_input_10 = '||p_input_10);
3502: hr_utility.trace('p_input_11 = '||p_input_11);
3503: hr_utility.trace('p_input_12 = '||p_input_12);
3504: hr_utility.trace('p_input_13 = '||p_input_13);
3505: hr_utility.trace('p_input_14 = '||p_input_14);
3506: hr_utility.trace('p_input_15 = '||p_input_15);
3507: -- Validation Starts
3508: If p_input_40='FLAT' THEN

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

3501: hr_utility.trace('p_input_10 = '||p_input_10);
3502: hr_utility.trace('p_input_11 = '||p_input_11);
3503: hr_utility.trace('p_input_12 = '||p_input_12);
3504: hr_utility.trace('p_input_13 = '||p_input_13);
3505: hr_utility.trace('p_input_14 = '||p_input_14);
3506: hr_utility.trace('p_input_15 = '||p_input_15);
3507: -- Validation Starts
3508: If p_input_40='FLAT' THEN
3509: --{

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

3502: hr_utility.trace('p_input_11 = '||p_input_11);
3503: hr_utility.trace('p_input_12 = '||p_input_12);
3504: hr_utility.trace('p_input_13 = '||p_input_13);
3505: hr_utility.trace('p_input_14 = '||p_input_14);
3506: hr_utility.trace('p_input_15 = '||p_input_15);
3507: -- Validation Starts
3508: If p_input_40='FLAT' THEN
3509: --{
3510: -- These validation are used only for mf file only.

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

3509: --{
3510: -- These validation are used only for mf file only.
3511: -- not for any of the audit report
3512: --
3513: hr_utility.trace('before data_validation of ein');
3514: l_emp_ein :=
3515: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
3516: p_report_type,
3517: p_format,

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

3531: END IF;
3532:
3533: IF l_other_ein is not null then
3534: --{
3535: hr_utility.trace('before data_validation of Other EIN');
3536: l_other_ein :=
3537: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
3538: p_report_type,
3539: p_format,

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

3571: -- Validating above data based on the report_qualifier and number entries
3572: --
3573: FOR i in 1..l_records
3574: LOOP
3575: hr_utility.trace(parameter_record(i).p_parameter_name||' = '
3576: ||parameter_record(i).p_parameter_value);
3577:
3578: hr_utility.trace('value of(i)|| = '|| to_char(i));
3579:

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

3574: LOOP
3575: hr_utility.trace(parameter_record(i).p_parameter_name||' = '
3576: ||parameter_record(i).p_parameter_value);
3577:
3578: hr_utility.trace('value of(i)|| = '|| to_char(i));
3579:
3580: parameter_record(i).p_output_value :=
3581: pay_us_reporting_utils_pkg.data_validation( p_effective_date,
3582: p_report_type,

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

3594: sp_out_2);
3595: IF p_exclude_from_output = 'Y' THEN
3596: l_exclude_from_output_chk := TRUE;
3597: END IF;
3598: hr_utility.trace(parameter_record(i).p_parameter_name||' = '
3599: ||parameter_record(i).p_output_value);
3600: hr_utility.trace('After validating the parameter for -ve Value p_exclude_from_output = '||p_exclude_from_output);
3601: END LOOP;
3602: -- Validation Ends here

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

3596: l_exclude_from_output_chk := TRUE;
3597: END IF;
3598: hr_utility.trace(parameter_record(i).p_parameter_name||' = '
3599: ||parameter_record(i).p_output_value);
3600: hr_utility.trace('After validating the parameter for -ve Value p_exclude_from_output = '||p_exclude_from_output);
3601: END LOOP;
3602: -- Validation Ends here
3603: --
3604: -- Formatting RSSUMM Record depending on report_qualifier

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

3664: ||lpad(' ',384);
3665: --}
3666: END IF;
3667: ret_str_len:=length(return_value);
3668: hr_utility.trace(' Length of ret_str_len = ' || to_char(ret_str_len));
3669: --}
3670: ELSIF p_input_40 = 'CSV' THEN
3671: --{
3672: l_rt_end_of_rec := lpad(' ',158);

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

3770: r_sit_tax := p_sit_tax;
3771: r_month1_no_employee := p_month1_no_employee;
3772: r_month2_no_employee := p_month2_no_employee;
3773: r_month3_no_employee := p_month3_no_employee;
3774: hr_utility.trace('Report Qualifier before Formatting RST Record '
3775: ||p_report_qualifier);
3776: /*r_input_2 := lpad(' ',7);*/
3777: r_total_no_of_employee := lpad(substr(nvl(p_total_no_of_employee,'0'),1,7),7,0);
3778: r_sui_reduction_wages := lpad(nvl(r_sui_reduction_wages,'0'), 14, '0');

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

3844: l_end_of_rec varchar2(20) ;
3845:
3846: BEGIN
3847: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);
3848: hr_utility.trace('Formatting RU Record');
3849: hr_utility.trace('RU Record Format Mode '||p_record_format_mode);
3850: l_no_of_rs_record := lpad(substr(nvl(p_number_of_RS_record,'0'),1,7),7,0);
3851:
3852: /* Bug 3527986 Removed Delimiters fro NY */

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

3845:
3846: BEGIN
3847: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);
3848: hr_utility.trace('Formatting RU Record');
3849: hr_utility.trace('RU Record Format Mode '||p_record_format_mode);
3850: l_no_of_rs_record := lpad(substr(nvl(p_number_of_RS_record,'0'),1,7),7,0);
3851:
3852: /* Bug 3527986 Removed Delimiters fro NY */
3853: /*

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

3912:
3913: BEGIN
3914: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);
3915: -- Formatting RF Record
3916: hr_utility.trace('Report Qualifier before Formatting RF Record '
3917: ||p_report_qualifier);
3918:
3919: /* Bug:2259849. */
3920: IF ((p_report_qualifier = 'LA_SQWL' ) OR

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

3954: END format_SQWL_RF_record; -- End of Formatting RF Record for SQWL Reporting
3955: --
3956: --BEGIN
3957:
3958: --hr_utility.trace_on(null, 'NVSQWL');
3959:
3960: END pay_us_mmrf_sqwl_format_record; -- End of Package Body