DBA Data[Home] [Help]

APPS.PAY_CA_YEER_PKG dependencies on HR_UTILITY

Line 547: hr_utility.set_location(fp_lookup_code||' '||lv_meaning, 1111 );

543: lv_meaning := sv_lkup(i).dbi_value;
544: exit;
545: end if;
546: end loop;
547: hr_utility.set_location(fp_lookup_code||' '||lv_meaning, 1111 );
548: return(lv_meaning);
549: end get_lookup_meaning;
550:
551: /* The function print_spaces returns spaces to print spaces in the file */

Line 616: -- hr_utility.trace_on(null,'VALIDATE_SIN');

612: check_format VARCHAR2(40);
613: return_value BOOLEAN := true;
614:
615: begin
616: -- hr_utility.trace_on(null,'VALIDATE_SIN');
617: check_format := hr_ni_chk_pkg.chk_nat_id_format(national_identifier,'DDD DDD DDD');
618: hr_utility.trace('check_format ----'||check_format);
619: if ( check_format <>'0' ) then
620: /* check digit is the last digit of SIN */

Line 618: hr_utility.trace('check_format ----'||check_format);

614:
615: begin
616: -- hr_utility.trace_on(null,'VALIDATE_SIN');
617: check_format := hr_ni_chk_pkg.chk_nat_id_format(national_identifier,'DDD DDD DDD');
618: hr_utility.trace('check_format ----'||check_format);
619: if ( check_format <>'0' ) then
620: /* check digit is the last digit of SIN */
621: check_digit := substr(check_format,-1,1);
622: hr_utility.trace('check_digit ----'||check_digit);

Line 622: hr_utility.trace('check_digit ----'||check_digit);

618: hr_utility.trace('check_format ----'||check_format);
619: if ( check_format <>'0' ) then
620: /* check digit is the last digit of SIN */
621: check_digit := substr(check_format,-1,1);
622: hr_utility.trace('check_digit ----'||check_digit);
623:
624: /* Make a number from the second and each alternate number */
625: num1 := substr(check_format,2,1) || substr(check_format,5,1) ||
626: substr(check_format,7,1) || substr(check_format,10,1) ;

Line 627: hr_utility.trace('num1 ----'||num1);

623:
624: /* Make a number from the second and each alternate number */
625: num1 := substr(check_format,2,1) || substr(check_format,5,1) ||
626: substr(check_format,7,1) || substr(check_format,10,1) ;
627: hr_utility.trace('num1 ----'||num1);
628:
629: /* Multiply the number by 2 /*
630: /* NOTE : '0000' is appended to ensure that substr will not fail in the next step */
631: num2 := num1 * 2 ||'0000';

Line 632: hr_utility.trace('num2 ----'||num2);

628:
629: /* Multiply the number by 2 /*
630: /* NOTE : '0000' is appended to ensure that substr will not fail in the next step */
631: num2 := num1 * 2 ||'0000';
632: hr_utility.trace('num2 ----'||num2);
633:
634: /* Cross add the digits in the sum */
635: num2_add := substr(num2,1,1) + substr(num2,2,1) + substr(num2,3,1)
636: + substr(num2,4,1) + substr(num2,5,1);

Line 637: hr_utility.trace('num2_add ----'||num2_add);

633:
634: /* Cross add the digits in the sum */
635: num2_add := substr(num2,1,1) + substr(num2,2,1) + substr(num2,3,1)
636: + substr(num2,4,1) + substr(num2,5,1);
637: hr_utility.trace('num2_add ----'||num2_add);
638:
639: /* Cross add intervening digits of SIN i.e digit1 + digit3 + ... */
640: num3 := substr(check_format,1,1) + substr(check_format,3,1) +
641: substr(check_format,6,1) + substr(check_format,9,1);

Line 642: hr_utility.trace('num3 ----'||num3);

638:
639: /* Cross add intervening digits of SIN i.e digit1 + digit3 + ... */
640: num3 := substr(check_format,1,1) + substr(check_format,3,1) +
641: substr(check_format,6,1) + substr(check_format,9,1);
642: hr_utility.trace('num3 ----'||num3);
643:
644: /* Total the above two numbers */
645: num4 := num2_add + num3;
646: hr_utility.trace('num4 ----'||num4);

Line 646: hr_utility.trace('num4 ----'||num4);

642: hr_utility.trace('num3 ----'||num3);
643:
644: /* Total the above two numbers */
645: num4 := num2_add + num3;
646: hr_utility.trace('num4 ----'||num4);
647:
648: /* If the resulting total is a multiple of 10, the check digit is 0;
649: otherwise check digit will be the difference of the total calculated and the
650: next highest number ending in zero */

Line 663: -- hr_utility.trace_off();

659: end if;
660: else
661: return_value := false;
662: end if;
663: -- hr_utility.trace_off();
664: return return_value;
665: end validateSIN;
666:
667: /* The procedure employee_header prints the header of Employee Exceptions */

Line 1074: hr_utility.set_location(to_char(sv_neg_bal.count),888);

1070:
1071: while sv_neg_bal.count > 0
1072: loop
1073:
1074: hr_utility.set_location(to_char(sv_neg_bal.count),888);
1075: i := 0;
1076: l := 0;
1077: l_juris_cd := sv_neg_bal(1).dbi_name;
1078:

Line 1083: hr_utility.set_location('K = '||to_char(k),888);

1079: for k in sv_neg_bal.first..sv_neg_bal.last
1080: loop
1081:
1082: l_juris_cd1 := sv_neg_bal(k).dbi_name;
1083: hr_utility.set_location('K = '||to_char(k),888);
1084: hr_utility.set_location('JURI = *'||sv_neg_bal(k).dbi_name||'*',888);
1085:
1086: if l_juris_cd1 = l_juris_cd then
1087: i := i + 1;

Line 1084: hr_utility.set_location('JURI = *'||sv_neg_bal(k).dbi_name||'*',888);

1080: loop
1081:
1082: l_juris_cd1 := sv_neg_bal(k).dbi_name;
1083: hr_utility.set_location('K = '||to_char(k),888);
1084: hr_utility.set_location('JURI = *'||sv_neg_bal(k).dbi_name||'*',888);
1085:
1086: if l_juris_cd1 = l_juris_cd then
1087: i := i + 1;
1088:

Line 1089: hr_utility.set_location('I = '||to_char(i),888);

1085:
1086: if l_juris_cd1 = l_juris_cd then
1087: i := i + 1;
1088:
1089: hr_utility.set_location('I = '||to_char(i),888);
1090:
1091: if mod(i,5) = 1 then
1092: if i = 1 then
1093: lv_format := ''||

Line 1124: hr_utility.set_location('L = '||to_char(l),888);

1120: sv_neg_bal(k).dbi_value||'';
1121: end if;
1122: else
1123: l := l + 1;
1124: hr_utility.set_location('L = '||to_char(l),888);
1125: l_sort_neg(l).dbi_name := sv_neg_bal(k).dbi_name;
1126: l_sort_neg(l).dbi_value := sv_neg_bal(k).dbi_value;
1127: l_sort_neg(l).dbi_short_name := sv_neg_bal(k).dbi_short_name;
1128: end if;

Line 1164: hr_utility.set_location(to_char(mod(i,5)),888);

1160: else
1161:
1162: for i in 1..sv_nb loop
1163:
1164: hr_utility.set_location(to_char(mod(i,5)),888);
1165: if mod(i,5) = 1 then
1166: if i = 1 then
1167: lv_format := ''||
1168: get_lookup_meaning('R_NEG_BOX')||''

Line 1216: hr_utility.set_location('5',888);

1212: end if;
1213:
1214: if ( ( sv_c + sv_m ) > 0 ) then
1215:
1216: hr_utility.set_location('5',888);
1217: lv_format := ' ';
1218: format_data(lv_format);
1219:
1220: hr_utility.set_location('6',888);

Line 1220: hr_utility.set_location('6',888);

1216: hr_utility.set_location('5',888);
1217: lv_format := ' ';
1218: format_data(lv_format);
1219:
1220: hr_utility.set_location('6',888);
1221: lv_format := ''||get_lookup_meaning('R_REASON')||'';
1222: format_data(lv_format);
1223:
1224: if ( sv_m > 0 ) then

Line 1227: hr_utility.set_location('7',888);

1223:
1224: if ( sv_m > 0 ) then
1225: for i in 1..sv_m
1226: loop
1227: hr_utility.set_location('7',888);
1228: lv_format := ''||print_spaces(30);
1229: lv_format := lv_format||' '||to_char(i)||'. '||sv_msg(i)||'';
1230: format_data(lv_format);
1231: end loop;

Line 1234: hr_utility.set_location('8',888);

1230: format_data(lv_format);
1231: end loop;
1232: end if;
1233: if sv_c > 0 then
1234: hr_utility.set_location('8',888);
1235: lv_format := ''||print_spaces(30);
1236: lv_format := lv_format||' '||to_char(sv_m+1)||'. '||
1237: get_lookup_meaning('R_REQ_FIELDS')||'';
1238: format_data(lv_format);

Line 1251: hr_utility.set_location('9',888);

1247: if ( length(lv_req_flds) < 135 ) then
1248: lv_req_flds := lv_req_flds ||
1249: print_spaces( 135 - length(lv_req_flds) );
1250: end if;
1251: hr_utility.set_location('9',888);
1252: lv_format := ''||print_spaces(30);
1253: lv_format := lv_format||' '||lv_req_flds||'';
1254: format_data(lv_format);
1255: end if;

Line 1257: hr_utility.set_location('10',888);

1253: lv_format := lv_format||' '||lv_req_flds||'';
1254: format_data(lv_format);
1255: end if;
1256: end if;
1257: hr_utility.set_location('10',888);
1258: lv_format := ''||print_line('-',156)||'';
1259: format_data(lv_format);
1260: end print_employee;
1261:

Line 1453: hr_utility.set_location(to_char(i)||'. '||sv_dbi(i).dbi_name||' '||

1449: if sv_report_type in ('RL1','CAEOY_RL1_AMEND_PP') then
1450:
1451: for i in sv_dbi.first..sv_dbi.last
1452: loop
1453: hr_utility.set_location(to_char(i)||'. '||sv_dbi(i).dbi_name||' '||
1454: sv_dbi(i).dbi_value||' '||sv_dbi(i).dbi_short_name, 999 );
1455:
1456: if sv_dbi(i).dbi_name = 'CAEOY_PERSON_ID' then
1457: lv_person_id := to_number(sv_dbi(i).dbi_value);

Line 1588: hr_utility.trace('sv_total_earnings ='|| sv_total_earnings);

1584: end if;
1585:
1586: if sv_dbi(i).dbi_name = 'CAEOY_GROSS_EARNINGS_PER_JD_YTD' then
1587: sv_total_earnings := nvl(sv_total_earnings,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);
1588: hr_utility.trace('sv_total_earnings ='|| sv_total_earnings);
1589: end if;
1590:
1591: if sv_dbi(i).dbi_name = 'CAEOY_QPP_EE_TAXABLE_PER_JD_YTD' then
1592: sv_pensionable_earnings := nvl(sv_pensionable_earnings,0) +fnd_number.canonical_to_number(sv_dbi(i).dbi_value);

Line 2128: hr_utility.set_location(sv_dbi(i).dbi_short_name, 601);

2124: begin
2125: if sv_report_type in ('RL1','CAEOY_RL1_AMEND_PP') then
2126: for i in sv_dbi.first..sv_dbi.last
2127: loop
2128: hr_utility.set_location(sv_dbi(i).dbi_short_name, 601);
2129: if sv_trans_y_n = 'Y' then
2130: if sv_dbi(i).dbi_name = 'CAEOY_RL1_TRANSMITTER_NUMBER' then
2131: if sv_dbi(i).dbi_value is null then
2132: sv_c := sv_c + 1;

Line 2134: hr_utility.set_location('Required column '||sv_col(sv_c), 610);

2130: if sv_dbi(i).dbi_name = 'CAEOY_RL1_TRANSMITTER_NUMBER' then
2131: if sv_dbi(i).dbi_value is null then
2132: sv_c := sv_c + 1;
2133: sv_col(sv_c) := sv_dbi(i).dbi_short_name;
2134: hr_utility.set_location('Required column '||sv_col(sv_c), 610);
2135: else
2136: if ( ( substr(sv_dbi(i).dbi_value,1,2) <> 'NP' ) or
2137: ( length(sv_dbi(i).dbi_value) <> 8 ) or
2138: ( not ( substr(sv_dbi(i).dbi_value,3) >= '000000' ) and

Line 2143: hr_utility.set_location(sv_msg(sv_m)|| ' '||sv_dbi(i).dbi_value, 611);

2139: ( substr(sv_dbi(i).dbi_value,3) <= '999999' ) ) )
2140: then
2141: sv_m := sv_m + 1;
2142: sv_msg(sv_m) := get_lookup_meaning('R_INVALID_TRANS_NO');
2143: hr_utility.set_location(sv_msg(sv_m)|| ' '||sv_dbi(i).dbi_value, 611);
2144: end if;
2145: end if;
2146: end if;
2147: if sv_dbi(i).dbi_name = 'CAEOY_RL1_TRANSMITTER_NAME' and

Line 2151: hr_utility.set_location('Required column '||sv_col(sv_c), 612);

2147: if sv_dbi(i).dbi_name = 'CAEOY_RL1_TRANSMITTER_NAME' and
2148: sv_dbi(i).dbi_value is null then
2149: sv_c := sv_c + 1;
2150: sv_col(sv_c) := sv_dbi(i).dbi_short_name;
2151: hr_utility.set_location('Required column '||sv_col(sv_c), 612);
2152: end if;
2153: if sv_dbi(i).dbi_name = 'CAEOY_RL1_TRANSMITTER_CITY' and
2154: sv_dbi(i).dbi_value is null then
2155: sv_c := sv_c + 1;

Line 2157: hr_utility.set_location('Required column '||sv_col(sv_c), 613);

2153: if sv_dbi(i).dbi_name = 'CAEOY_RL1_TRANSMITTER_CITY' and
2154: sv_dbi(i).dbi_value is null then
2155: sv_c := sv_c + 1;
2156: sv_col(sv_c) := sv_dbi(i).dbi_short_name;
2157: hr_utility.set_location('Required column '||sv_col(sv_c), 613);
2158: end if;
2159: if sv_dbi(i).dbi_name = 'CAEOY_RL1_TRANSMITTER_PROVINCE' and
2160: sv_dbi(i).dbi_value is null then
2161: sv_c := sv_c + 1;

Line 2163: hr_utility.set_location('Required column '||sv_col(sv_c), 614);

2159: if sv_dbi(i).dbi_name = 'CAEOY_RL1_TRANSMITTER_PROVINCE' and
2160: sv_dbi(i).dbi_value is null then
2161: sv_c := sv_c + 1;
2162: sv_col(sv_c) := sv_dbi(i).dbi_short_name;
2163: hr_utility.set_location('Required column '||sv_col(sv_c), 614);
2164: end if;
2165: if sv_dbi(i).dbi_name = 'CAEOY_RL1_TRANSMITTER_POSTAL_CODE' and
2166: sv_dbi(i).dbi_value is null then
2167: sv_c := sv_c + 1;

Line 2169: hr_utility.set_location('Required column '||sv_col(sv_c), 615);

2165: if sv_dbi(i).dbi_name = 'CAEOY_RL1_TRANSMITTER_POSTAL_CODE' and
2166: sv_dbi(i).dbi_value is null then
2167: sv_c := sv_c + 1;
2168: sv_col(sv_c) := sv_dbi(i).dbi_short_name;
2169: hr_utility.set_location('Required column '||sv_col(sv_c), 615);
2170: end if;
2171: if sv_dbi(i).dbi_name = 'CAEOY_RL1_TECHNICAL_CONTACT_NAME' and
2172: sv_dbi(i).dbi_value is null then
2173: sv_c := sv_c + 1;

Line 2175: hr_utility.set_location('Required column '||sv_col(sv_c), 616);

2171: if sv_dbi(i).dbi_name = 'CAEOY_RL1_TECHNICAL_CONTACT_NAME' and
2172: sv_dbi(i).dbi_value is null then
2173: sv_c := sv_c + 1;
2174: sv_col(sv_c) := sv_dbi(i).dbi_short_name;
2175: hr_utility.set_location('Required column '||sv_col(sv_c), 616);
2176: end if;
2177: if sv_dbi(i).dbi_name = 'CAEOY_RL1_TECHNICAL_CONTACT_PHONE' and
2178: sv_dbi(i).dbi_value is null then
2179: sv_c := sv_c + 1;

Line 2181: hr_utility.set_location('Required column '||sv_col(sv_c), 617);

2177: if sv_dbi(i).dbi_name = 'CAEOY_RL1_TECHNICAL_CONTACT_PHONE' and
2178: sv_dbi(i).dbi_value is null then
2179: sv_c := sv_c + 1;
2180: sv_col(sv_c) := sv_dbi(i).dbi_short_name;
2181: hr_utility.set_location('Required column '||sv_col(sv_c), 617);
2182: end if;
2183: if sv_dbi(i).dbi_name = 'CAEOY_RL1_TECHNICAL_CONTACT_AREA_CODE' and
2184: sv_dbi(i).dbi_value is null then
2185: sv_c := sv_c + 1;

Line 2187: hr_utility.set_location('Required column '||sv_col(sv_c), 618);

2183: if sv_dbi(i).dbi_name = 'CAEOY_RL1_TECHNICAL_CONTACT_AREA_CODE' and
2184: sv_dbi(i).dbi_value is null then
2185: sv_c := sv_c + 1;
2186: sv_col(sv_c) := sv_dbi(i).dbi_short_name;
2187: hr_utility.set_location('Required column '||sv_col(sv_c), 618);
2188: end if;
2189: if sv_dbi(i).dbi_name = 'CAEOY_RL1_TECHNICAL_CONTACT_LANGUAGE' and
2190: sv_dbi(i).dbi_value is null then
2191: sv_c := sv_c + 1;

Line 2193: hr_utility.set_location('Required column '||sv_col(sv_c), 619);

2189: if sv_dbi(i).dbi_name = 'CAEOY_RL1_TECHNICAL_CONTACT_LANGUAGE' and
2190: sv_dbi(i).dbi_value is null then
2191: sv_c := sv_c + 1;
2192: sv_col(sv_c) := sv_dbi(i).dbi_short_name;
2193: hr_utility.set_location('Required column '||sv_col(sv_c), 619);
2194: end if;
2195: if sv_dbi(i).dbi_name = 'CAEOY_RL1_TRANSMITTER_ADDRESS_LINE1' and
2196: sv_dbi(i).dbi_value is null then
2197: sv_c := sv_c + 1;

Line 2199: hr_utility.set_location('Required column '||sv_col(sv_c), 620);

2195: if sv_dbi(i).dbi_name = 'CAEOY_RL1_TRANSMITTER_ADDRESS_LINE1' and
2196: sv_dbi(i).dbi_value is null then
2197: sv_c := sv_c + 1;
2198: sv_col(sv_c) := sv_dbi(i).dbi_short_name;
2199: hr_utility.set_location('Required column '||sv_col(sv_c), 620);
2200: end if;
2201: if sv_dbi(i).dbi_name = 'CAEOY_RL1_TRANSMITTER_PACKAGE_TYPE' and
2202: sv_dbi(i).dbi_value is null then
2203: sv_c := sv_c + 1;

Line 2205: hr_utility.set_location('Required column '||sv_col(sv_c), 621);

2201: if sv_dbi(i).dbi_name = 'CAEOY_RL1_TRANSMITTER_PACKAGE_TYPE' and
2202: sv_dbi(i).dbi_value is null then
2203: sv_c := sv_c + 1;
2204: sv_col(sv_c) := sv_dbi(i).dbi_short_name;
2205: hr_utility.set_location('Required column '||sv_col(sv_c), 621);
2206: end if;
2207: if sv_dbi(i).dbi_name = 'CAEOY_RL1_SOURCE_OF_SLIPS' and
2208: sv_dbi(i).dbi_value is null then
2209: sv_c := sv_c + 1;

Line 2211: hr_utility.set_location('Required column '||sv_col(sv_c), 622);

2207: if sv_dbi(i).dbi_name = 'CAEOY_RL1_SOURCE_OF_SLIPS' and
2208: sv_dbi(i).dbi_value is null then
2209: sv_c := sv_c + 1;
2210: sv_col(sv_c) := sv_dbi(i).dbi_short_name;
2211: hr_utility.set_location('Required column '||sv_col(sv_c), 622);
2212: end if;
2213: end if;
2214:
2215: if sv_dbi(i).dbi_name = 'CAEOY_RL1_QUEBEC_BN' then

Line 2221: hr_utility.set_location('Required column '||sv_col(sv_c), 650);

2217: if sv_dbi(i).dbi_value is null then
2218: sv_c := sv_c + 1;
2219: --sv_col(sv_c) := sv_dbi(i).dbi_short_name;
2220: sv_col(sv_c) := get_lookup_meaning('L_QCID_NUMBER');
2221: hr_utility.set_location('Required column '||sv_col(sv_c), 650);
2222: else
2223: if length(sv_dbi(i).dbi_value) <> 16 then
2224: sv_m := sv_m + 1;
2225: sv_msg(sv_m) := get_lookup_meaning('R_QIN_LENGTH');

Line 2226: hr_utility.set_location(sv_msg(sv_m)|| ' '||sv_dbi(i).dbi_value, 603);

2222: else
2223: if length(sv_dbi(i).dbi_value) <> 16 then
2224: sv_m := sv_m + 1;
2225: sv_msg(sv_m) := get_lookup_meaning('R_QIN_LENGTH');
2226: hr_utility.set_location(sv_msg(sv_m)|| ' '||sv_dbi(i).dbi_value, 603);
2227: else
2228: for j in 1..length(sv_dbi(i).dbi_value)
2229: loop
2230: if ( j not in ( 11, 12 ) ) then

Line 2234: hr_utility.set_location(sv_msg(sv_m)|| ' '||sv_dbi(i).dbi_value, 651);

2230: if ( j not in ( 11, 12 ) ) then
2231: if instr('1234567890',substr(sv_dbi(i).dbi_value,j,1)) = 0 then
2232: sv_m := sv_m + 1;
2233: sv_msg(sv_m) := get_lookup_meaning('R_QIN_INVALID');
2234: hr_utility.set_location(sv_msg(sv_m)|| ' '||sv_dbi(i).dbi_value, 651);
2235: exit;
2236: end if;
2237: else
2238: if instr('ABCDEFGHIJKLMNOPQRSTUVWXYZ',

Line 2242: hr_utility.set_location(sv_msg(sv_m)|| ' '||sv_dbi(i).dbi_value, 652);

2238: if instr('ABCDEFGHIJKLMNOPQRSTUVWXYZ',
2239: substr(sv_dbi(i).dbi_value,j,1)) = 0 then
2240: sv_m := sv_m + 1;
2241: sv_msg(sv_m) := get_lookup_meaning('R_QIN_INVALID');
2242: hr_utility.set_location(sv_msg(sv_m)|| ' '||sv_dbi(i).dbi_value, 652);
2243: exit;
2244: end if;
2245: end if;
2246: end loop;

Line 2256: hr_utility.set_location('Required column '||sv_col(sv_c), 653);

2252: sv_employer_name := sv_dbi(i).dbi_value;
2253: if sv_dbi(i).dbi_value is null then
2254: sv_c := sv_c + 1;
2255: sv_col(sv_c) := sv_dbi(i).dbi_short_name;
2256: hr_utility.set_location('Required column '||sv_col(sv_c), 653);
2257: end if;
2258: end if;
2259:
2260: if sv_dbi(i).dbi_name = 'CAEOY_RL1_EMPLOYER_CITY' then

Line 2265: hr_utility.set_location('Required column '||sv_col(sv_c), 654);

2261: sv_employer_city := sv_dbi(i).dbi_value;
2262: if sv_dbi(i).dbi_value is null then
2263: sv_c := sv_c + 1;
2264: sv_col(sv_c) := sv_dbi(i).dbi_short_name;
2265: hr_utility.set_location('Required column '||sv_col(sv_c), 654);
2266: end if;
2267: end if;
2268:
2269: if sv_dbi(i).dbi_name = 'CAEOY_RL1_EMPLOYER_PROVINCE' then

Line 2274: hr_utility.set_location('Required column '||sv_col(sv_c), 655);

2270: sv_employer_province := sv_dbi(i).dbi_value;
2271: if sv_dbi(i).dbi_value is null then
2272: sv_c := sv_c + 1;
2273: sv_col(sv_c) := sv_dbi(i).dbi_short_name;
2274: hr_utility.set_location('Required column '||sv_col(sv_c), 655);
2275: end if;
2276: end if;
2277:
2278: if sv_dbi(i).dbi_name = 'CAEOY_RL1_EMPLOYER_POSTAL_CODE' then

Line 2283: hr_utility.set_location('Required column '||sv_col(sv_c), 656);

2279: sv_employer_postal_code := sv_dbi(i).dbi_value;
2280: if sv_dbi(i).dbi_value is null then
2281: sv_c := sv_c + 1;
2282: sv_col(sv_c) := sv_dbi(i).dbi_short_name;
2283: hr_utility.set_location('Required column '||sv_col(sv_c), 656);
2284: end if;
2285: end if;
2286:
2287: if sv_dbi(i).dbi_name = 'CAEOY_RL1_ACCOUNTING_CONTACT_NAME' and

Line 2291: hr_utility.set_location('Required column '||sv_col(sv_c), 657);

2287: if sv_dbi(i).dbi_name = 'CAEOY_RL1_ACCOUNTING_CONTACT_NAME' and
2288: sv_dbi(i).dbi_value is null then
2289: sv_c := sv_c + 1;
2290: sv_col(sv_c) := sv_dbi(i).dbi_short_name;
2291: hr_utility.set_location('Required column '||sv_col(sv_c), 657);
2292: end if;
2293:
2294: if sv_dbi(i).dbi_name = 'CAEOY_RL1_ACCOUNTING_CONTACT_PHONE' and
2295: sv_dbi(i).dbi_value is null then

Line 2298: hr_utility.set_location('Required column '||sv_col(sv_c), 658);

2294: if sv_dbi(i).dbi_name = 'CAEOY_RL1_ACCOUNTING_CONTACT_PHONE' and
2295: sv_dbi(i).dbi_value is null then
2296: sv_c := sv_c + 1;
2297: sv_col(sv_c) := sv_dbi(i).dbi_short_name;
2298: hr_utility.set_location('Required column '||sv_col(sv_c), 658);
2299: end if;
2300:
2301: if sv_dbi(i).dbi_name = 'CAEOY_TAXATION_YEAR' and
2302: sv_dbi(i).dbi_value is null then

Line 2305: hr_utility.set_location('Required column '||sv_col(sv_c), 659);

2301: if sv_dbi(i).dbi_name = 'CAEOY_TAXATION_YEAR' and
2302: sv_dbi(i).dbi_value is null then
2303: sv_c := sv_c + 1;
2304: sv_col(sv_c) := sv_dbi(i).dbi_short_name;
2305: hr_utility.set_location('Required column '||sv_col(sv_c), 659);
2306: end if;
2307:
2308: if sv_dbi(i).dbi_name = 'CAEOY_RL1_EMPLOYER_ADDRESS_LINE1' then
2309: sv_employer_address_line1 := sv_dbi(i).dbi_value;

Line 2330: hr_utility.set_location('RL2 Employer validation', 699);

2326:
2327: end if; -- End if for sv_report_type in ('RL1','CAEOY_RL1_AMEND_PP')
2328:
2329: /* Start of RL2 Employer Validation */
2330: hr_utility.set_location('RL2 Employer validation', 699);
2331: if sv_report_type = 'RL2' then
2332:
2333: if sv_trans_y_n = 'Y' then
2334:

Line 2338: hr_utility.set_location('Required column '||sv_col(sv_c), 710);

2334:
2335: if lr_rl2_transrec.TRANSMITTER_NUMBER is null then
2336: sv_c := sv_c + 1;
2337: sv_col(sv_c) := 'Transmitter Number';
2338: hr_utility.set_location('Required column '||sv_col(sv_c), 710);
2339: else
2340: if ( ( substr(lr_rl2_transrec.TRANSMITTER_NUMBER,1,2) <> 'NP' ) or
2341: ( length(lr_rl2_transrec.TRANSMITTER_NUMBER) <> 8 ) or
2342: ( not ( substr(lr_rl2_transrec.TRANSMITTER_NUMBER,3) >= '000000' ) and

Line 2347: hr_utility.set_location(sv_msg(sv_m)|| ' '||lr_rl2_transrec.TRANSMITTER_NUMBER, 711);

2343: ( substr(lr_rl2_transrec.TRANSMITTER_NUMBER,3) <= '999999' ) ) )
2344: then
2345: sv_m := sv_m + 1;
2346: sv_msg(sv_m) := get_lookup_meaning('R_INVALID_TRANS_NO');
2347: hr_utility.set_location(sv_msg(sv_m)|| ' '||lr_rl2_transrec.TRANSMITTER_NUMBER, 711);
2348: end if;
2349: end if;
2350:
2351: if lr_rl2_transrec.TRANSMITTER_NAME is null then

Line 2354: hr_utility.set_location('Required column '||sv_col(sv_c), 712);

2350:
2351: if lr_rl2_transrec.TRANSMITTER_NAME is null then
2352: sv_c := sv_c + 1;
2353: sv_col(sv_c) := 'Transmitter Name';
2354: hr_utility.set_location('Required column '||sv_col(sv_c), 712);
2355: end if;
2356:
2357: if lr_rl2_transrec.TRANSMITTER_CITY is null then
2358: sv_c := sv_c + 1;

Line 2360: hr_utility.set_location('Required column '||sv_col(sv_c), 713);

2356:
2357: if lr_rl2_transrec.TRANSMITTER_CITY is null then
2358: sv_c := sv_c + 1;
2359: sv_col(sv_c) := 'Transmitter City';
2360: hr_utility.set_location('Required column '||sv_col(sv_c), 713);
2361: end if;
2362:
2363: if lr_rl2_transrec.TRANSMITTER_PROVINCE is null then
2364: sv_c := sv_c + 1;

Line 2366: hr_utility.set_location('Required column '||sv_col(sv_c), 714);

2362:
2363: if lr_rl2_transrec.TRANSMITTER_PROVINCE is null then
2364: sv_c := sv_c + 1;
2365: sv_col(sv_c) := 'Transmitter Province';
2366: hr_utility.set_location('Required column '||sv_col(sv_c), 714);
2367: end if;
2368:
2369: if lr_rl2_transrec.TRANSMITTER_POSTAL_CODE is null then
2370: sv_c := sv_c + 1;

Line 2372: hr_utility.set_location('Required column '||sv_col(sv_c), 715);

2368:
2369: if lr_rl2_transrec.TRANSMITTER_POSTAL_CODE is null then
2370: sv_c := sv_c + 1;
2371: sv_col(sv_c) := 'Transmitter Postal Code';
2372: hr_utility.set_location('Required column '||sv_col(sv_c), 715);
2373: end if;
2374:
2375: if lr_rl2_transrec.TRANSMITTER_TECH_CONTACT_NAME is null then
2376: sv_c := sv_c + 1;

Line 2378: hr_utility.set_location('Required column '||sv_col(sv_c), 716);

2374:
2375: if lr_rl2_transrec.TRANSMITTER_TECH_CONTACT_NAME is null then
2376: sv_c := sv_c + 1;
2377: sv_col(sv_c) := 'Technical Contact Name';
2378: hr_utility.set_location('Required column '||sv_col(sv_c), 716);
2379: end if;
2380:
2381: if lr_rl2_transrec.TRANSMITTER_TECH_CONTACT_PHONE is null then
2382: sv_c := sv_c + 1;

Line 2384: hr_utility.set_location('Required column '||sv_col(sv_c), 717);

2380:
2381: if lr_rl2_transrec.TRANSMITTER_TECH_CONTACT_PHONE is null then
2382: sv_c := sv_c + 1;
2383: sv_col(sv_c) := 'Technical Contact Phone';
2384: hr_utility.set_location('Required column '||sv_col(sv_c), 717);
2385: end if;
2386:
2387: if lr_rl2_transrec.TRANSMITTER_TECH_CONTACT_CODE is null then
2388: sv_c := sv_c + 1;

Line 2390: hr_utility.set_location('Required column '||sv_col(sv_c), 718);

2386:
2387: if lr_rl2_transrec.TRANSMITTER_TECH_CONTACT_CODE is null then
2388: sv_c := sv_c + 1;
2389: sv_col(sv_c) := 'Technical Contact Area Code';
2390: hr_utility.set_location('Required column '||sv_col(sv_c), 718);
2391: end if;
2392:
2393: if lr_rl2_transrec.TRANSMITTER_TECH_CONTACT_LANG is null then
2394: sv_c := sv_c + 1;

Line 2396: hr_utility.set_location('Required column '||sv_col(sv_c), 719);

2392:
2393: if lr_rl2_transrec.TRANSMITTER_TECH_CONTACT_LANG is null then
2394: sv_c := sv_c + 1;
2395: sv_col(sv_c) := 'Technical Contact Language';
2396: hr_utility.set_location('Required column '||sv_col(sv_c), 719);
2397: end if;
2398:
2399: if lr_rl2_transrec.TRANSMITTER_PACKAGE_TYPE is null then
2400: sv_c := sv_c + 1;

Line 2402: hr_utility.set_location('Required column '||sv_col(sv_c), 720);

2398:
2399: if lr_rl2_transrec.TRANSMITTER_PACKAGE_TYPE is null then
2400: sv_c := sv_c + 1;
2401: sv_col(sv_c) := 'Transmitter Package Type';
2402: hr_utility.set_location('Required column '||sv_col(sv_c), 720);
2403: end if;
2404:
2405: if lr_rl2_transrec.SOURCE_OF_SLIPS is null then
2406: sv_c := sv_c + 1;

Line 2408: hr_utility.set_location('Required column '||sv_col(sv_c), 721);

2404:
2405: if lr_rl2_transrec.SOURCE_OF_SLIPS is null then
2406: sv_c := sv_c + 1;
2407: sv_col(sv_c) := 'Source of Slips';
2408: hr_utility.set_location('Required column '||sv_col(sv_c), 721);
2409: end if;
2410:
2411: if lr_rl2_transrec.TRANSMITTER_ADDRESS_LINE1 is null then
2412: sv_c := sv_c + 1;

Line 2414: hr_utility.set_location('Required column '||sv_col(sv_c), 722);

2410:
2411: if lr_rl2_transrec.TRANSMITTER_ADDRESS_LINE1 is null then
2412: sv_c := sv_c + 1;
2413: sv_col(sv_c) := 'Transmitter Address Line 1';
2414: hr_utility.set_location('Required column '||sv_col(sv_c), 722);
2415: end if;
2416:
2417: end if; -- end of sv_trans_y_n = 'Y'
2418:

Line 2424: hr_utility.set_location('Required column '||sv_col(sv_c), 750);

2420: sv_qin := lr_rl2_transrec.QUEBEC_BUSINESS_NUMBER;
2421: if lr_rl2_transrec.QUEBEC_BUSINESS_NUMBER is null then
2422: sv_c := sv_c + 1;
2423: sv_col(sv_c) := get_lookup_meaning('L_QCID_NUMBER');
2424: hr_utility.set_location('Required column '||sv_col(sv_c), 750);
2425: else
2426: if length(lr_rl2_transrec.QUEBEC_BUSINESS_NUMBER) <> 16 then
2427: sv_m := sv_m + 1;
2428: sv_msg(sv_m) := get_lookup_meaning('R_QIN_LENGTH');

Line 2429: hr_utility.set_location(sv_msg(sv_m)|| ' '||lr_rl2_transrec.QUEBEC_BUSINESS_NUMBER, 703);

2425: else
2426: if length(lr_rl2_transrec.QUEBEC_BUSINESS_NUMBER) <> 16 then
2427: sv_m := sv_m + 1;
2428: sv_msg(sv_m) := get_lookup_meaning('R_QIN_LENGTH');
2429: hr_utility.set_location(sv_msg(sv_m)|| ' '||lr_rl2_transrec.QUEBEC_BUSINESS_NUMBER, 703);
2430: else
2431: for j in 1..length(lr_rl2_transrec.QUEBEC_BUSINESS_NUMBER)
2432: loop
2433: if ( j not in ( 11, 12 ) ) then

Line 2437: hr_utility.set_location(sv_msg(sv_m)|| ' '||lr_rl2_transrec.QUEBEC_BUSINESS_NUMBER, 751);

2433: if ( j not in ( 11, 12 ) ) then
2434: if instr('1234567890',substr(lr_rl2_transrec.QUEBEC_BUSINESS_NUMBER,j,1)) = 0 then
2435: sv_m := sv_m + 1;
2436: sv_msg(sv_m) := get_lookup_meaning('R_QIN_INVALID');
2437: hr_utility.set_location(sv_msg(sv_m)|| ' '||lr_rl2_transrec.QUEBEC_BUSINESS_NUMBER, 751);
2438: exit;
2439: end if;
2440: else
2441: if instr('ABCDEFGHIJKLMNOPQRSTUVWXYZ',

Line 2445: hr_utility.set_location(sv_msg(sv_m)|| ' '||lr_rl2_transrec.QUEBEC_BUSINESS_NUMBER, 752);

2441: if instr('ABCDEFGHIJKLMNOPQRSTUVWXYZ',
2442: substr(lr_rl2_transrec.QUEBEC_BUSINESS_NUMBER,j,1)) = 0 then
2443: sv_m := sv_m + 1;
2444: sv_msg(sv_m) := get_lookup_meaning('R_QIN_INVALID');
2445: hr_utility.set_location(sv_msg(sv_m)|| ' '||lr_rl2_transrec.QUEBEC_BUSINESS_NUMBER, 752);
2446: exit;
2447: end if;
2448: end if;
2449: end loop;

Line 2458: hr_utility.set_location('Required column '||sv_col(sv_c), 753);

2454: sv_employer_name := lr_rl2_transrec.EMPLOYER_NAME;
2455: if lr_rl2_transrec.EMPLOYER_NAME is null then
2456: sv_c := sv_c + 1;
2457: sv_col(sv_c) := 'Employer Name';
2458: hr_utility.set_location('Required column '||sv_col(sv_c), 753);
2459: end if;
2460:
2461: sv_employer_city := lr_rl2_transrec.EMPLOYER_CITY;
2462: if lr_rl2_transrec.EMPLOYER_CITY is null then

Line 2465: hr_utility.set_location('Required column '||sv_col(sv_c), 754);

2461: sv_employer_city := lr_rl2_transrec.EMPLOYER_CITY;
2462: if lr_rl2_transrec.EMPLOYER_CITY is null then
2463: sv_c := sv_c + 1;
2464: sv_col(sv_c) := 'Employer City';
2465: hr_utility.set_location('Required column '||sv_col(sv_c), 754);
2466: end if;
2467:
2468: sv_employer_province := lr_rl2_transrec.EMPLOYER_PROVINCE;
2469: if lr_rl2_transrec.EMPLOYER_PROVINCE is null then

Line 2472: hr_utility.set_location('Required column '||sv_col(sv_c), 755);

2468: sv_employer_province := lr_rl2_transrec.EMPLOYER_PROVINCE;
2469: if lr_rl2_transrec.EMPLOYER_PROVINCE is null then
2470: sv_c := sv_c + 1;
2471: sv_col(sv_c) := 'Employer Province';
2472: hr_utility.set_location('Required column '||sv_col(sv_c), 755);
2473: end if;
2474:
2475: sv_employer_postal_code := lr_rl2_transrec.EMPLOYER_POSTAL_CODE;
2476: if lr_rl2_transrec.EMPLOYER_POSTAL_CODE is null then

Line 2479: hr_utility.set_location('Required column '||sv_col(sv_c), 756);

2475: sv_employer_postal_code := lr_rl2_transrec.EMPLOYER_POSTAL_CODE;
2476: if lr_rl2_transrec.EMPLOYER_POSTAL_CODE is null then
2477: sv_c := sv_c + 1;
2478: sv_col(sv_c) := 'Employer Postal Code';
2479: hr_utility.set_location('Required column '||sv_col(sv_c), 756);
2480: end if;
2481:
2482: if lr_rl2_transrec.TRANSMITTER_ACCT_CONTACT_NAME is null then
2483: sv_c := sv_c + 1;

Line 2485: hr_utility.set_location('Required column '||sv_col(sv_c), 757);

2481:
2482: if lr_rl2_transrec.TRANSMITTER_ACCT_CONTACT_NAME is null then
2483: sv_c := sv_c + 1;
2484: sv_col(sv_c) := 'Accounting Contact Name';
2485: hr_utility.set_location('Required column '||sv_col(sv_c), 757);
2486: end if;
2487:
2488: if lr_rl2_transrec.TRANSMITTER_ACCT_CONTACT_PHONE is null then
2489: sv_c := sv_c + 1;

Line 2491: hr_utility.set_location('Required column '||sv_col(sv_c), 758);

2487:
2488: if lr_rl2_transrec.TRANSMITTER_ACCT_CONTACT_PHONE is null then
2489: sv_c := sv_c + 1;
2490: sv_col(sv_c) := 'Accounting Contact Phone';
2491: hr_utility.set_location('Required column '||sv_col(sv_c), 758);
2492: end if;
2493:
2494: if lr_rl2_transrec.REPORTING_YEAR is null then
2495: sv_c := sv_c + 1;

Line 2497: hr_utility.set_location('Required column '||sv_col(sv_c), 759);

2493:
2494: if lr_rl2_transrec.REPORTING_YEAR is null then
2495: sv_c := sv_c + 1;
2496: sv_col(sv_c) := 'Taxation Year';
2497: hr_utility.set_location('Required column '||sv_col(sv_c), 759);
2498: end if;
2499:
2500: sv_employer_address_line1 := lr_rl2_transrec.EMPLOYER_ADD_LINE1;
2501: if lr_rl2_transrec.EMPLOYER_ADD_LINE1 is null then

Line 2532: hr_utility.set_location(to_char(i)||'. '||sv_dbi(i).dbi_name||' '||

2528: addr_line_2_3 number(10) := 0;
2529: begin
2530: for i in sv_dbi.first..sv_dbi.last
2531: loop
2532: hr_utility.set_location(to_char(i)||'. '||sv_dbi(i).dbi_name||' '||
2533: sv_dbi(i).dbi_value||' '||sv_dbi(i).dbi_short_name, 999 );
2534: if sv_dbi(i).dbi_name = 'CAEOY_PERSON_ID' then
2535: lv_person_id := to_number(sv_dbi(i).dbi_value);
2536: end if;

Line 2651: hr_utility.set_location('Multi Jurisdiction : '||

2647: end if;
2648: if sv_dbi(i).dbi_name = 'CAEOY_GROSS_EARNINGS_PER_JD_GRE_YTD' then
2649: sv_total_earnings :=nvl(sv_total_earnings,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);
2650: --lv_multi_jurisdiction := lv_multi_jurisdiction + 1;
2651: hr_utility.set_location('Multi Jurisdiction : '||
2652: to_char(lv_multi_jurisdiction), 999 );
2653: end if;
2654: if sv_dbi(i).dbi_name = 'CAEOY_CPP_EE_TAXABLE_PER_JD_GRE_YTD' then
2655: sv_pensionable_earnings :=nvl(sv_pensionable_earnings,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);

Line 2685: hr_utility.trace('Emp JD is '||sv_emp_jurisdiction);

2681: from ff_archive_item_contexts
2682: where archive_item_id = sv_dbi(i).archive_item_id
2683: and context_id = sv_context_id;
2684:
2685: hr_utility.trace('Emp JD is '||sv_emp_jurisdiction);
2686:
2687: if sv_emp_jurisdiction = 'QC' then
2688:
2689: if sv_dbi(i).dbi_name = 'CAEOY_EI_EE_TAXABLE_PER_JD_GRE_YTD' then

Line 2691: hr_utility.trace('QC Insurable Earning : '|| sv_qc_insurable_earnings);

2687: if sv_emp_jurisdiction = 'QC' then
2688:
2689: if sv_dbi(i).dbi_name = 'CAEOY_EI_EE_TAXABLE_PER_JD_GRE_YTD' then
2690: sv_qc_insurable_earnings := nvl(sv_qc_insurable_earnings,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);
2691: hr_utility.trace('QC Insurable Earning : '|| sv_qc_insurable_earnings);
2692: end if;
2693:
2694: if sv_dbi(i).dbi_name = 'CAEOY_EI_EE_WITHHELD_PER_JD_GRE_YTD' then
2695: sv_qc_ded_reported_18 := nvl(sv_qc_ded_reported_18,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);

Line 2696: hr_utility.trace('QC Withheld : '|| sv_qc_ded_reported_18);

2692: end if;
2693:
2694: if sv_dbi(i).dbi_name = 'CAEOY_EI_EE_WITHHELD_PER_JD_GRE_YTD' then
2695: sv_qc_ded_reported_18 := nvl(sv_qc_ded_reported_18,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);
2696: hr_utility.trace('QC Withheld : '|| sv_qc_ded_reported_18);
2697: end if;
2698:
2699: else
2700:

Line 2703: hr_utility.trace('FED Insurable Earning : '|| sv_insurable_earnings);

2699: else
2700:
2701: if sv_dbi(i).dbi_name = 'CAEOY_EI_EE_TAXABLE_PER_JD_GRE_YTD' then
2702: sv_insurable_earnings := nvl(sv_insurable_earnings,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);
2703: hr_utility.trace('FED Insurable Earning : '|| sv_insurable_earnings);
2704: end if;
2705:
2706: if sv_dbi(i).dbi_name = 'CAEOY_EI_EE_WITHHELD_PER_JD_GRE_YTD' then
2707: sv_ded_reported_18 := nvl(sv_ded_reported_18,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);

Line 2708: hr_utility.trace('FED Withheld : '|| sv_ded_reported_18);

2704: end if;
2705:
2706: if sv_dbi(i).dbi_name = 'CAEOY_EI_EE_WITHHELD_PER_JD_GRE_YTD' then
2707: sv_ded_reported_18 := nvl(sv_ded_reported_18,0) + fnd_number.canonical_to_number(sv_dbi(i).dbi_value);
2708: hr_utility.trace('FED Withheld : '|| sv_ded_reported_18);
2709: end if;
2710:
2711: end if; /* 'QC' */
2712:

Line 2804: hr_utility.trace('QC EI Dedn Req. ' || sv_qc_ei_ded_required);

2800:
2801: sv_ei_ded_required := (( sv_insurable_earnings * sv_ei_rate )/ 100 );
2802: sv_ei_max_exempt := ( ( sv_ei_max_earn ) * sv_ei_rate / 100 );
2803:
2804: hr_utility.trace('QC EI Dedn Req. ' || sv_qc_ei_ded_required);
2805: hr_utility.trace('QC EI Max Exempt ' || sv_qc_ei_max_exempt);
2806: hr_utility.trace('QC EI Withheld ' || sv_qc_ded_reported_18);
2807:
2808: hr_utility.trace('FED EI Dedn Req. ' || sv_ei_ded_required);

Line 2805: hr_utility.trace('QC EI Max Exempt ' || sv_qc_ei_max_exempt);

2801: sv_ei_ded_required := (( sv_insurable_earnings * sv_ei_rate )/ 100 );
2802: sv_ei_max_exempt := ( ( sv_ei_max_earn ) * sv_ei_rate / 100 );
2803:
2804: hr_utility.trace('QC EI Dedn Req. ' || sv_qc_ei_ded_required);
2805: hr_utility.trace('QC EI Max Exempt ' || sv_qc_ei_max_exempt);
2806: hr_utility.trace('QC EI Withheld ' || sv_qc_ded_reported_18);
2807:
2808: hr_utility.trace('FED EI Dedn Req. ' || sv_ei_ded_required);
2809: hr_utility.trace('FED EI Max Exempt ' || sv_ei_max_exempt);

Line 2806: hr_utility.trace('QC EI Withheld ' || sv_qc_ded_reported_18);

2802: sv_ei_max_exempt := ( ( sv_ei_max_earn ) * sv_ei_rate / 100 );
2803:
2804: hr_utility.trace('QC EI Dedn Req. ' || sv_qc_ei_ded_required);
2805: hr_utility.trace('QC EI Max Exempt ' || sv_qc_ei_max_exempt);
2806: hr_utility.trace('QC EI Withheld ' || sv_qc_ded_reported_18);
2807:
2808: hr_utility.trace('FED EI Dedn Req. ' || sv_ei_ded_required);
2809: hr_utility.trace('FED EI Max Exempt ' || sv_ei_max_exempt);
2810: hr_utility.trace('FED EI Withheld ' || sv_ded_reported_18);

Line 2808: hr_utility.trace('FED EI Dedn Req. ' || sv_ei_ded_required);

2804: hr_utility.trace('QC EI Dedn Req. ' || sv_qc_ei_ded_required);
2805: hr_utility.trace('QC EI Max Exempt ' || sv_qc_ei_max_exempt);
2806: hr_utility.trace('QC EI Withheld ' || sv_qc_ded_reported_18);
2807:
2808: hr_utility.trace('FED EI Dedn Req. ' || sv_ei_ded_required);
2809: hr_utility.trace('FED EI Max Exempt ' || sv_ei_max_exempt);
2810: hr_utility.trace('FED EI Withheld ' || sv_ded_reported_18);
2811:
2812: /* overlimit condition */

Line 2809: hr_utility.trace('FED EI Max Exempt ' || sv_ei_max_exempt);

2805: hr_utility.trace('QC EI Max Exempt ' || sv_qc_ei_max_exempt);
2806: hr_utility.trace('QC EI Withheld ' || sv_qc_ded_reported_18);
2807:
2808: hr_utility.trace('FED EI Dedn Req. ' || sv_ei_ded_required);
2809: hr_utility.trace('FED EI Max Exempt ' || sv_ei_max_exempt);
2810: hr_utility.trace('FED EI Withheld ' || sv_ded_reported_18);
2811:
2812: /* overlimit condition */
2813: if sv_ei_ded_required > sv_ei_max_exempt then

Line 2810: hr_utility.trace('FED EI Withheld ' || sv_ded_reported_18);

2806: hr_utility.trace('QC EI Withheld ' || sv_qc_ded_reported_18);
2807:
2808: hr_utility.trace('FED EI Dedn Req. ' || sv_ei_ded_required);
2809: hr_utility.trace('FED EI Max Exempt ' || sv_ei_max_exempt);
2810: hr_utility.trace('FED EI Withheld ' || sv_ded_reported_18);
2811:
2812: /* overlimit condition */
2813: if sv_ei_ded_required > sv_ei_max_exempt then
2814: sv_ei_ded_required := sv_ei_max_exempt;

Line 2836: hr_utility.trace('sv_ei_ded_required : '|| sv_ei_ded_required);

2832: /* difference */
2833:
2834: sv_qc_insurable_earnings := sv_qc_insurable_earnings;
2835:
2836: hr_utility.trace('sv_ei_ded_required : '|| sv_ei_ded_required);
2837: hr_utility.trace('sv_ded_reported_18 : '|| sv_ded_reported_18);
2838: hr_utility.trace('sv_insurable_earnings : '|| sv_insurable_earnings);
2839:
2840: hr_utility.trace('sv_qc_ei_ded_required : '|| sv_qc_ei_ded_required);

Line 2837: hr_utility.trace('sv_ded_reported_18 : '|| sv_ded_reported_18);

2833:
2834: sv_qc_insurable_earnings := sv_qc_insurable_earnings;
2835:
2836: hr_utility.trace('sv_ei_ded_required : '|| sv_ei_ded_required);
2837: hr_utility.trace('sv_ded_reported_18 : '|| sv_ded_reported_18);
2838: hr_utility.trace('sv_insurable_earnings : '|| sv_insurable_earnings);
2839:
2840: hr_utility.trace('sv_qc_ei_ded_required : '|| sv_qc_ei_ded_required);
2841: hr_utility.trace('sv_qc_ded_reported_18 : '|| sv_qc_ded_reported_18);

Line 2838: hr_utility.trace('sv_insurable_earnings : '|| sv_insurable_earnings);

2834: sv_qc_insurable_earnings := sv_qc_insurable_earnings;
2835:
2836: hr_utility.trace('sv_ei_ded_required : '|| sv_ei_ded_required);
2837: hr_utility.trace('sv_ded_reported_18 : '|| sv_ded_reported_18);
2838: hr_utility.trace('sv_insurable_earnings : '|| sv_insurable_earnings);
2839:
2840: hr_utility.trace('sv_qc_ei_ded_required : '|| sv_qc_ei_ded_required);
2841: hr_utility.trace('sv_qc_ded_reported_18 : '|| sv_qc_ded_reported_18);
2842: hr_utility.trace('sv_qc_insurable_earnings : '|| sv_qc_insurable_earnings);

Line 2840: hr_utility.trace('sv_qc_ei_ded_required : '|| sv_qc_ei_ded_required);

2836: hr_utility.trace('sv_ei_ded_required : '|| sv_ei_ded_required);
2837: hr_utility.trace('sv_ded_reported_18 : '|| sv_ded_reported_18);
2838: hr_utility.trace('sv_insurable_earnings : '|| sv_insurable_earnings);
2839:
2840: hr_utility.trace('sv_qc_ei_ded_required : '|| sv_qc_ei_ded_required);
2841: hr_utility.trace('sv_qc_ded_reported_18 : '|| sv_qc_ded_reported_18);
2842: hr_utility.trace('sv_qc_insurable_earnings : '|| sv_qc_insurable_earnings);
2843:
2844: sv_ei_deficiency := sv_ei_ded_required - sv_ded_reported_18 ;

Line 2841: hr_utility.trace('sv_qc_ded_reported_18 : '|| sv_qc_ded_reported_18);

2837: hr_utility.trace('sv_ded_reported_18 : '|| sv_ded_reported_18);
2838: hr_utility.trace('sv_insurable_earnings : '|| sv_insurable_earnings);
2839:
2840: hr_utility.trace('sv_qc_ei_ded_required : '|| sv_qc_ei_ded_required);
2841: hr_utility.trace('sv_qc_ded_reported_18 : '|| sv_qc_ded_reported_18);
2842: hr_utility.trace('sv_qc_insurable_earnings : '|| sv_qc_insurable_earnings);
2843:
2844: sv_ei_deficiency := sv_ei_ded_required - sv_ded_reported_18 ;
2845: sv_qc_ei_deficiency := sv_qc_ei_ded_required - sv_qc_ded_reported_18 ;

Line 2842: hr_utility.trace('sv_qc_insurable_earnings : '|| sv_qc_insurable_earnings);

2838: hr_utility.trace('sv_insurable_earnings : '|| sv_insurable_earnings);
2839:
2840: hr_utility.trace('sv_qc_ei_ded_required : '|| sv_qc_ei_ded_required);
2841: hr_utility.trace('sv_qc_ded_reported_18 : '|| sv_qc_ded_reported_18);
2842: hr_utility.trace('sv_qc_insurable_earnings : '|| sv_qc_insurable_earnings);
2843:
2844: sv_ei_deficiency := sv_ei_ded_required - sv_ded_reported_18 ;
2845: sv_qc_ei_deficiency := sv_qc_ei_ded_required - sv_qc_ded_reported_18 ;
2846:

Line 2847: hr_utility.trace('sv_ei_deficiency : '|| sv_ei_deficiency);

2843:
2844: sv_ei_deficiency := sv_ei_ded_required - sv_ded_reported_18 ;
2845: sv_qc_ei_deficiency := sv_qc_ei_ded_required - sv_qc_ded_reported_18 ;
2846:
2847: hr_utility.trace('sv_ei_deficiency : '|| sv_ei_deficiency);
2848: hr_utility.trace('sv_qc_ei_deficiency : '|| sv_qc_ei_deficiency);
2849:
2850: if sv_ei_deficiency < 0 then
2851: sv_ei_deficiency := 0;

Line 2848: hr_utility.trace('sv_qc_ei_deficiency : '|| sv_qc_ei_deficiency);

2844: sv_ei_deficiency := sv_ei_ded_required - sv_ded_reported_18 ;
2845: sv_qc_ei_deficiency := sv_qc_ei_ded_required - sv_qc_ded_reported_18 ;
2846:
2847: hr_utility.trace('sv_ei_deficiency : '|| sv_ei_deficiency);
2848: hr_utility.trace('sv_qc_ei_deficiency : '|| sv_qc_ei_deficiency);
2849:
2850: if sv_ei_deficiency < 0 then
2851: sv_ei_deficiency := 0;
2852: end if;

Line 3034: --hr_utility.set_location(p_dbi_short_name, 201);

3030: PROCEDURE fed_employer_validation ( p_dbi_name in varchar2,
3031: p_dbi_value in varchar2,
3032: p_dbi_short_name in varchar2) is
3033: begin
3034: --hr_utility.set_location(p_dbi_short_name, 201);
3035: if sv_trans_y_n = 'Y' then
3036: if p_dbi_name = 'CAEOY_TRANSMITTER_NUMBER' then
3037: if p_dbi_value is null then
3038: sv_c := sv_c + 1;

Line 3040: hr_utility.set_location('Required column '||sv_col(sv_c), 210);

3036: if p_dbi_name = 'CAEOY_TRANSMITTER_NUMBER' then
3037: if p_dbi_value is null then
3038: sv_c := sv_c + 1;
3039: sv_col(sv_c) := p_dbi_short_name;
3040: hr_utility.set_location('Required column '||sv_col(sv_c), 210);
3041: else
3042: if ( ( substr(p_dbi_value,1,2) <> 'MM' ) or
3043: ( length(p_dbi_value) <> 8 ) or
3044: ( not ( substr(p_dbi_value,3) >= '000000' ) and

Line 3049: hr_utility.set_location(sv_msg(sv_m)|| ' '||p_dbi_value, 211);

3045: ( substr(p_dbi_value,3) <= '999999' ) ) )
3046: then
3047: sv_m := sv_m + 1;
3048: sv_msg(sv_m) := get_lookup_meaning('R_INVALID_TRANS_NO');
3049: hr_utility.set_location(sv_msg(sv_m)|| ' '||p_dbi_value, 211);
3050: end if;
3051: end if;
3052: end if;
3053: if p_dbi_name = 'CAEOY_TRANSMITTER_NAME' and

Line 3057: hr_utility.set_location('Required column '||sv_col(sv_c), 212);

3053: if p_dbi_name = 'CAEOY_TRANSMITTER_NAME' and
3054: p_dbi_value is null then
3055: sv_c := sv_c + 1;
3056: sv_col(sv_c) := p_dbi_short_name;
3057: hr_utility.set_location('Required column '||sv_col(sv_c), 212);
3058: end if;
3059: if p_dbi_name = 'CAEOY_TRANSMITTER_CITY' and
3060: p_dbi_value is null then
3061: sv_c := sv_c + 1;

Line 3063: hr_utility.set_location('Required column '||sv_col(sv_c), 213);

3059: if p_dbi_name = 'CAEOY_TRANSMITTER_CITY' and
3060: p_dbi_value is null then
3061: sv_c := sv_c + 1;
3062: sv_col(sv_c) := p_dbi_short_name;
3063: hr_utility.set_location('Required column '||sv_col(sv_c), 213);
3064: end if;
3065: if p_dbi_name = 'CAEOY_TRANSMITTER_PROVINCE' and
3066: p_dbi_value is null then
3067: sv_c := sv_c + 1;

Line 3069: hr_utility.set_location('Required column '||sv_col(sv_c), 214);

3065: if p_dbi_name = 'CAEOY_TRANSMITTER_PROVINCE' and
3066: p_dbi_value is null then
3067: sv_c := sv_c + 1;
3068: sv_col(sv_c) := p_dbi_short_name;
3069: hr_utility.set_location('Required column '||sv_col(sv_c), 214);
3070: end if;
3071: if p_dbi_name = 'CAEOY_TRANSMITTER_POSTAL_CODE' and
3072: p_dbi_value is null then
3073: sv_c := sv_c + 1;

Line 3075: hr_utility.set_location('Required column '||sv_col(sv_c), 215);

3071: if p_dbi_name = 'CAEOY_TRANSMITTER_POSTAL_CODE' and
3072: p_dbi_value is null then
3073: sv_c := sv_c + 1;
3074: sv_col(sv_c) := p_dbi_short_name;
3075: hr_utility.set_location('Required column '||sv_col(sv_c), 215);
3076: end if;
3077: if p_dbi_name = 'CAEOY_TECHNICAL_CONTACT_NAME' and
3078: p_dbi_value is null then
3079: sv_c := sv_c + 1;

Line 3081: hr_utility.set_location('Required column '||sv_col(sv_c), 216);

3077: if p_dbi_name = 'CAEOY_TECHNICAL_CONTACT_NAME' and
3078: p_dbi_value is null then
3079: sv_c := sv_c + 1;
3080: sv_col(sv_c) := p_dbi_short_name;
3081: hr_utility.set_location('Required column '||sv_col(sv_c), 216);
3082: end if;
3083: if p_dbi_name = 'CAEOY_TECHNICAL_CONTACT_PHONE' and
3084: p_dbi_value is null then
3085: sv_c := sv_c + 1;

Line 3087: hr_utility.set_location('Required column '||sv_col(sv_c), 217);

3083: if p_dbi_name = 'CAEOY_TECHNICAL_CONTACT_PHONE' and
3084: p_dbi_value is null then
3085: sv_c := sv_c + 1;
3086: sv_col(sv_c) := p_dbi_short_name;
3087: hr_utility.set_location('Required column '||sv_col(sv_c), 217);
3088: end if;
3089: if p_dbi_name = 'CAEOY_TECHNICAL_CONTACT_AREA_CODE' and
3090: p_dbi_value is null then
3091: sv_c := sv_c + 1;

Line 3093: hr_utility.set_location('Required column '||sv_col(sv_c), 218);

3089: if p_dbi_name = 'CAEOY_TECHNICAL_CONTACT_AREA_CODE' and
3090: p_dbi_value is null then
3091: sv_c := sv_c + 1;
3092: sv_col(sv_c) := p_dbi_short_name;
3093: hr_utility.set_location('Required column '||sv_col(sv_c), 218);
3094: end if;
3095: if p_dbi_name = 'CAEOY_TECHNICAL_CONTACT_LANGUAGE' and
3096: p_dbi_value is null then
3097: sv_c := sv_c + 1;

Line 3099: hr_utility.set_location('Required column '||sv_col(sv_c), 219);

3095: if p_dbi_name = 'CAEOY_TECHNICAL_CONTACT_LANGUAGE' and
3096: p_dbi_value is null then
3097: sv_c := sv_c + 1;
3098: sv_col(sv_c) := p_dbi_short_name;
3099: hr_utility.set_location('Required column '||sv_col(sv_c), 219);
3100: end if;
3101: if p_dbi_name = 'CAEOY_TRANSMITTER_TYPE_INDICATOR' and
3102: p_dbi_value is null then
3103: sv_c := sv_c + 1;

Line 3105: hr_utility.set_location('Required column '||sv_col(sv_c), 220);

3101: if p_dbi_name = 'CAEOY_TRANSMITTER_TYPE_INDICATOR' and
3102: p_dbi_value is null then
3103: sv_c := sv_c + 1;
3104: sv_col(sv_c) := p_dbi_short_name;
3105: hr_utility.set_location('Required column '||sv_col(sv_c), 220);
3106: end if;
3107: end if;
3108: if p_dbi_name = 'CAEOY_EMPLOYER_IDENTIFICATION_NUMBER' then
3109: sv_busi_no := p_dbi_value;

Line 3113: hr_utility.set_location('Required column '||sv_col(sv_c), 250);

3109: sv_busi_no := p_dbi_value;
3110: if p_dbi_value is null then
3111: sv_c := sv_c + 1;
3112: sv_col(sv_c) := p_dbi_short_name;
3113: hr_utility.set_location('Required column '||sv_col(sv_c), 250);
3114: else
3115: if length(p_dbi_value) <> 15 then
3116: sv_m := sv_m + 1;
3117: sv_msg(sv_m) := get_lookup_meaning('R_BN_LENGTH');

Line 3118: hr_utility.set_location(sv_msg(sv_m)|| ' '||p_dbi_value, 203);

3114: else
3115: if length(p_dbi_value) <> 15 then
3116: sv_m := sv_m + 1;
3117: sv_msg(sv_m) := get_lookup_meaning('R_BN_LENGTH');
3118: hr_utility.set_location(sv_msg(sv_m)|| ' '||p_dbi_value, 203);
3119: else
3120: for i in 1..length(p_dbi_value)
3121: loop
3122: if ( i not in ( 10, 11 ) ) then

Line 3126: hr_utility.set_location(sv_msg(sv_m)|| ' '||p_dbi_value, 251);

3122: if ( i not in ( 10, 11 ) ) then
3123: if instr('1234567890',substr(p_dbi_value,i,1)) = 0 then
3124: sv_m := sv_m + 1;
3125: sv_msg(sv_m) := get_lookup_meaning('R_BN_INVALID');
3126: hr_utility.set_location(sv_msg(sv_m)|| ' '||p_dbi_value, 251);
3127: exit;
3128: end if;
3129: else
3130: if instr('ABCDEFGHIJKLMNOPQRSTUVWXYZ',substr(p_dbi_value,i,1)) =

Line 3134: hr_utility.set_location(sv_msg(sv_m)|| ' '||p_dbi_value, 252);

3130: if instr('ABCDEFGHIJKLMNOPQRSTUVWXYZ',substr(p_dbi_value,i,1)) =
3131: 0 then
3132: sv_m := sv_m + 1;
3133: sv_msg(sv_m) := get_lookup_meaning('R_BN_INVALID');
3134: hr_utility.set_location(sv_msg(sv_m)|| ' '||p_dbi_value, 252);
3135: exit;
3136: end if;
3137: end if;
3138:

Line 3148: hr_utility.set_location('Required column '||sv_col(sv_c), 253);

3144: sv_employer_name := p_dbi_value;
3145: if p_dbi_value is null then
3146: sv_c := sv_c + 1;
3147: sv_col(sv_c) := p_dbi_short_name;
3148: hr_utility.set_location('Required column '||sv_col(sv_c), 253);
3149: end if;
3150: end if;
3151: if p_dbi_name = 'CAEOY_EMPLOYER_CITY' then
3152: sv_employer_city := p_dbi_value;

Line 3156: hr_utility.set_location('Required column '||sv_col(sv_c), 254);

3152: sv_employer_city := p_dbi_value;
3153: if p_dbi_value is null then
3154: sv_c := sv_c + 1;
3155: sv_col(sv_c) := p_dbi_short_name;
3156: hr_utility.set_location('Required column '||sv_col(sv_c), 254);
3157: end if;
3158: end if;
3159: if p_dbi_name = 'CAEOY_EMPLOYER_PROVINCE' then
3160: sv_employer_province := p_dbi_value;

Line 3164: hr_utility.set_location('Required column '||sv_col(sv_c), 255);

3160: sv_employer_province := p_dbi_value;
3161: if p_dbi_value is null then
3162: sv_c := sv_c + 1;
3163: sv_col(sv_c) := p_dbi_short_name;
3164: hr_utility.set_location('Required column '||sv_col(sv_c), 255);
3165: end if;
3166: end if;
3167: if p_dbi_name = 'CAEOY_EMPLOYER_POSTAL_CODE' then
3168: sv_employer_postal_code := p_dbi_value;

Line 3172: hr_utility.set_location('Required column '||sv_col(sv_c), 256);

3168: sv_employer_postal_code := p_dbi_value;
3169: if p_dbi_value is null then
3170: sv_c := sv_c + 1;
3171: sv_col(sv_c) := p_dbi_short_name;
3172: hr_utility.set_location('Required column '||sv_col(sv_c), 256);
3173: end if;
3174: end if;
3175: if p_dbi_name = 'CAEOY_ACCOUNTING_CONTACT_NAME' and
3176: p_dbi_value is null then

Line 3179: hr_utility.set_location('Required column '||sv_col(sv_c), 257);

3175: if p_dbi_name = 'CAEOY_ACCOUNTING_CONTACT_NAME' and
3176: p_dbi_value is null then
3177: sv_c := sv_c + 1;
3178: sv_col(sv_c) := p_dbi_short_name;
3179: hr_utility.set_location('Required column '||sv_col(sv_c), 257);
3180: end if;
3181: if p_dbi_name = 'CAEOY_ACCOUNTING_CONTACT_PHONE' and
3182: p_dbi_value is null then
3183: sv_c := sv_c + 1;

Line 3185: hr_utility.set_location('Required column '||sv_col(sv_c), 258);

3181: if p_dbi_name = 'CAEOY_ACCOUNTING_CONTACT_PHONE' and
3182: p_dbi_value is null then
3183: sv_c := sv_c + 1;
3184: sv_col(sv_c) := p_dbi_short_name;
3185: hr_utility.set_location('Required column '||sv_col(sv_c), 258);
3186: end if;
3187: if p_dbi_name = 'CAEOY_TAXATION_YEAR' and
3188: p_dbi_value is null then
3189: sv_c := sv_c + 1;

Line 3191: hr_utility.set_location('Required column '||sv_col(sv_c), 259);

3187: if p_dbi_name = 'CAEOY_TAXATION_YEAR' and
3188: p_dbi_value is null then
3189: sv_c := sv_c + 1;
3190: sv_col(sv_c) := p_dbi_short_name;
3191: hr_utility.set_location('Required column '||sv_col(sv_c), 259);
3192: end if;
3193: /*
3194: if p_dbi_name = 'CAEOY_FEDERAL_YOUTH_HIRE_PROGRAM_INDICATOR' and
3195: p_dbi_value is null then

Line 3198: hr_utility.set_location('Required column '||sv_col(sv_c), 260);

3194: if p_dbi_name = 'CAEOY_FEDERAL_YOUTH_HIRE_PROGRAM_INDICATOR' and
3195: p_dbi_value is null then
3196: sv_c := sv_c + 1;
3197: sv_col(sv_c) := p_dbi_short_name;
3198: hr_utility.set_location('Required column '||sv_col(sv_c), 260);
3199:
3200: end if;
3201: */
3202: if p_dbi_name = 'CAEOY_EMPLOYER_ADDRESS_LINE1' then

Line 3508: hr_utility.set_location('PACTID ' || to_char(l_payroll_action_id), 510);

3504: sv_qin;
3505:
3506: exit when cur_rl_pay_act%notfound;
3507:
3508: hr_utility.set_location('PACTID ' || to_char(l_payroll_action_id), 510);
3509: hr_utility.set_location('ORG ID ' || to_char(l_org_id), 520);
3510: hr_utility.set_location('BUSI NO. ' || l_business_number, 530);
3511: hr_utility.set_location('PRE NAME ' || l_pre_name, 540);
3512: hr_utility.set_location('QIN ' || sv_qin, 550);

Line 3509: hr_utility.set_location('ORG ID ' || to_char(l_org_id), 520);

3505:
3506: exit when cur_rl_pay_act%notfound;
3507:
3508: hr_utility.set_location('PACTID ' || to_char(l_payroll_action_id), 510);
3509: hr_utility.set_location('ORG ID ' || to_char(l_org_id), 520);
3510: hr_utility.set_location('BUSI NO. ' || l_business_number, 530);
3511: hr_utility.set_location('PRE NAME ' || l_pre_name, 540);
3512: hr_utility.set_location('QIN ' || sv_qin, 550);
3513:

Line 3510: hr_utility.set_location('BUSI NO. ' || l_business_number, 530);

3506: exit when cur_rl_pay_act%notfound;
3507:
3508: hr_utility.set_location('PACTID ' || to_char(l_payroll_action_id), 510);
3509: hr_utility.set_location('ORG ID ' || to_char(l_org_id), 520);
3510: hr_utility.set_location('BUSI NO. ' || l_business_number, 530);
3511: hr_utility.set_location('PRE NAME ' || l_pre_name, 540);
3512: hr_utility.set_location('QIN ' || sv_qin, 550);
3513:
3514: sv_busi_no := l_business_number;

Line 3511: hr_utility.set_location('PRE NAME ' || l_pre_name, 540);

3507:
3508: hr_utility.set_location('PACTID ' || to_char(l_payroll_action_id), 510);
3509: hr_utility.set_location('ORG ID ' || to_char(l_org_id), 520);
3510: hr_utility.set_location('BUSI NO. ' || l_business_number, 530);
3511: hr_utility.set_location('PRE NAME ' || l_pre_name, 540);
3512: hr_utility.set_location('QIN ' || sv_qin, 550);
3513:
3514: sv_busi_no := l_business_number;
3515: sv_pre_name := l_pre_name;

Line 3512: hr_utility.set_location('QIN ' || sv_qin, 550);

3508: hr_utility.set_location('PACTID ' || to_char(l_payroll_action_id), 510);
3509: hr_utility.set_location('ORG ID ' || to_char(l_org_id), 520);
3510: hr_utility.set_location('BUSI NO. ' || l_business_number, 530);
3511: hr_utility.set_location('PRE NAME ' || l_pre_name, 540);
3512: hr_utility.set_location('QIN ' || sv_qin, 550);
3513:
3514: sv_busi_no := l_business_number;
3515: sv_pre_name := l_pre_name;
3516:

Line 3524: hr_utility.set_location('Transmitter ? ' || sv_trans_y_n, 550);

3520: fetch cur_rl_trans_y_n into l_transmitter_y_n;
3521: close cur_rl_trans_y_n;
3522:
3523: sv_trans_y_n := l_transmitter_y_n;
3524: hr_utility.set_location('Transmitter ? ' || sv_trans_y_n, 550);
3525:
3526: if (sv_report_type <> 'CAEOY_RL1_AMEND_PP') then
3527:
3528: if sv_p_y = 'E' then

Line 3546: hr_utility.set_location(' Cursor DBI Before Validation ', 560);

3542:
3543: else
3544: open cur_rl_dbi(l_payroll_action_id);
3545:
3546: hr_utility.set_location(' Cursor DBI Before Validation ', 560);
3547: i := 0;
3548: loop
3549: fetch cur_rl_dbi into l_dbi_name,
3550: l_dbi_value,

Line 3560: hr_utility.set_location(' Cursor DBI After Validation ', 570);

3556: sv_dbi(i).dbi_value := l_dbi_value;
3557: sv_dbi(i).dbi_short_name := l_dbi_short_name;
3558: end loop;
3559:
3560: hr_utility.set_location(' Cursor DBI After Validation ', 570);
3561: close cur_rl_dbi;
3562:
3563: end if; /* End of RL2 report type validation */
3564:

Line 3613: hr_utility.set_location(' CUR_TAX_UNIT_ID', 587 );

3609: open cur_get_location (l_assignment_action_id);
3610: fetch cur_get_location into sv_location_id;
3611: close cur_get_location;
3612:
3613: hr_utility.set_location(' CUR_TAX_UNIT_ID', 587 );
3614:
3615: open cur_rl_tax_unit_id( l_assignment_id );
3616: fetch cur_rl_tax_unit_id into l_tax_unit_id;
3617: close cur_rl_tax_unit_id;

Line 3621: hr_utility.set_location(' CUR_DOB', 588 );

3617: close cur_rl_tax_unit_id;
3618:
3619: sv_gre := l_tax_unit_id;
3620:
3621: hr_utility.set_location(' CUR_DOB', 588 );
3622:
3623: open cur_rl_dob( l_person_id, l_effective_date);
3624: fetch cur_rl_dob into sv_date_of_birth, sv_hire_date;
3625: close cur_rl_dob;

Line 3627: hr_utility.set_location('CUR_TERMINATE',577);

3623: open cur_rl_dob( l_person_id, l_effective_date);
3624: fetch cur_rl_dob into sv_date_of_birth, sv_hire_date;
3625: close cur_rl_dob;
3626:
3627: hr_utility.set_location('CUR_TERMINATE',577);
3628:
3629: open cur_rl_terminate( l_person_id);
3630: fetch cur_rl_terminate into sv_terminate_date;
3631: close cur_rl_terminate;

Line 3633: hr_utility.set_location('CUR_QPP_BLOCK',566);

3629: open cur_rl_terminate( l_person_id);
3630: fetch cur_rl_terminate into sv_terminate_date;
3631: close cur_rl_terminate;
3632:
3633: hr_utility.set_location('CUR_QPP_BLOCK',566);
3634:
3635: open cur_rl_qpp_block(fp_b_g_id, l_person_id, l_effective_date);
3636: fetch cur_rl_qpp_block into sv_cpp_block;
3637: close cur_rl_qpp_block;

Line 3639: hr_utility.set_location('CUR_PPIP_BLOCK',566);

3635: open cur_rl_qpp_block(fp_b_g_id, l_person_id, l_effective_date);
3636: fetch cur_rl_qpp_block into sv_cpp_block;
3637: close cur_rl_qpp_block;
3638:
3639: hr_utility.set_location('CUR_PPIP_BLOCK',566);
3640:
3641: open cur_rl_qpip_block(fp_b_g_id, l_person_id, l_effective_date);
3642: fetch cur_rl_qpip_block into sv_ppip_block;
3643: close cur_rl_qpip_block;

Line 3645: hr_utility.set_location('CUR_DBI',555);

3641: open cur_rl_qpip_block(fp_b_g_id, l_person_id, l_effective_date);
3642: fetch cur_rl_qpip_block into sv_ppip_block;
3643: close cur_rl_qpip_block;
3644:
3645: hr_utility.set_location('CUR_DBI',555);
3646:
3647: if sv_report_type = 'RL2' then
3648:
3649: open cur_rl2_employee(fp_b_g_id,

Line 3674: hr_utility.set_location(' Cursor Assignment actions '||to_char(l_assignment_action_id), 199);

3670:
3671: else
3672:
3673: open cur_rl_dbi(l_assignment_action_id);
3674: hr_utility.set_location(' Cursor Assignment actions '||to_char(l_assignment_action_id), 199);
3675: i := 0;
3676: loop
3677: fetch cur_rl_dbi into l_dbi_name,
3678: l_dbi_value,

Line 4041: hr_utility.set_location('PACTID ' || to_char(l_payroll_action_id), 110);

4037: sv_report_type;
4038:
4039: exit when cur_pay_act%notfound;
4040:
4041: hr_utility.set_location('PACTID ' || to_char(l_payroll_action_id), 110);
4042: hr_utility.set_location('ORG ID ' || to_char(l_org_id), 120);
4043: hr_utility.set_location('BUSI NO. ' || l_business_number, 130);
4044: hr_utility.set_location('GRE NAME ' || l_gre_name, 140);
4045:

Line 4042: hr_utility.set_location('ORG ID ' || to_char(l_org_id), 120);

4038:
4039: exit when cur_pay_act%notfound;
4040:
4041: hr_utility.set_location('PACTID ' || to_char(l_payroll_action_id), 110);
4042: hr_utility.set_location('ORG ID ' || to_char(l_org_id), 120);
4043: hr_utility.set_location('BUSI NO. ' || l_business_number, 130);
4044: hr_utility.set_location('GRE NAME ' || l_gre_name, 140);
4045:
4046: sv_busi_no := l_business_number;

Line 4043: hr_utility.set_location('BUSI NO. ' || l_business_number, 130);

4039: exit when cur_pay_act%notfound;
4040:
4041: hr_utility.set_location('PACTID ' || to_char(l_payroll_action_id), 110);
4042: hr_utility.set_location('ORG ID ' || to_char(l_org_id), 120);
4043: hr_utility.set_location('BUSI NO. ' || l_business_number, 130);
4044: hr_utility.set_location('GRE NAME ' || l_gre_name, 140);
4045:
4046: sv_busi_no := l_business_number;
4047: sv_gre_name := l_gre_name;

Line 4044: hr_utility.set_location('GRE NAME ' || l_gre_name, 140);

4040:
4041: hr_utility.set_location('PACTID ' || to_char(l_payroll_action_id), 110);
4042: hr_utility.set_location('ORG ID ' || to_char(l_org_id), 120);
4043: hr_utility.set_location('BUSI NO. ' || l_business_number, 130);
4044: hr_utility.set_location('GRE NAME ' || l_gre_name, 140);
4045:
4046: sv_busi_no := l_business_number;
4047: sv_gre_name := l_gre_name;
4048: sv_gre := l_org_id;

Line 4057: hr_utility.set_location('Transmitter ? ' || sv_trans_y_n, 150);

4053: fetch cur_trans_y_n into l_transmitter_y_n;
4054: close cur_trans_y_n;
4055:
4056: sv_trans_y_n := l_transmitter_y_n;
4057: hr_utility.set_location('Transmitter ? ' || sv_trans_y_n, 150);
4058:
4059: if ((sv_report_type <> 'CAEOY_T4_AMEND_PP') and
4060: (sv_report_type <> 'CAEOY_T4A_AMEND_PP')) then
4061:

Line 4067: hr_utility.set_location(' Cursor DBI Before Validation ', 160);

4063:
4064: initialize_static_var('R');
4065: open cur_dbi(l_payroll_action_id);
4066:
4067: hr_utility.set_location(' Cursor DBI Before Validation ', 160);
4068: loop
4069:
4070: fetch cur_dbi into l_dbi_name,
4071: l_dbi_value,

Line 4080: hr_utility.set_location(' Cursor DBI After Validation ', 170);

4076: fed_employer_validation(l_dbi_name,l_dbi_value,l_dbi_short_name);
4077:
4078: end loop;
4079:
4080: hr_utility.set_location(' Cursor DBI After Validation ', 170);
4081: close cur_dbi;
4082: employer_header;
4083: print_employer;
4084: end if;

Line 4125: hr_utility.set_location(' CUR_DOB', 188 );

4121: sv_asg_id := l_assignment_id;
4122:
4123: initialize_static_var('E');
4124:
4125: hr_utility.set_location(' CUR_DOB', 188 );
4126:
4127: open cur_dob( l_person_id, l_effective_date);
4128: fetch cur_dob into sv_date_of_birth, sv_hire_date;
4129: close cur_dob;

Line 4131: hr_utility.set_location('CUR_TERMINATE',177);

4127: open cur_dob( l_person_id, l_effective_date);
4128: fetch cur_dob into sv_date_of_birth, sv_hire_date;
4129: close cur_dob;
4130:
4131: hr_utility.set_location('CUR_TERMINATE',177);
4132:
4133: open cur_terminate( l_person_id);
4134: fetch cur_terminate into sv_terminate_date;
4135: close cur_terminate;

Line 4137: hr_utility.set_location('CUR_CPP_BLOCK',166);

4133: open cur_terminate( l_person_id);
4134: fetch cur_terminate into sv_terminate_date;
4135: close cur_terminate;
4136:
4137: hr_utility.set_location('CUR_CPP_BLOCK',166);
4138:
4139: open cur_cpp_block( fp_b_g_id, l_person_id, l_effective_date);
4140: fetch cur_cpp_block into sv_cpp_block;
4141: close cur_cpp_block;

Line 4143: hr_utility.set_location('CUR_CPP_DATE_BLOCK',169);

4139: open cur_cpp_block( fp_b_g_id, l_person_id, l_effective_date);
4140: fetch cur_cpp_block into sv_cpp_block;
4141: close cur_cpp_block;
4142:
4143: hr_utility.set_location('CUR_CPP_DATE_BLOCK',169);
4144:
4145: open cur_cpp_date_block( fp_b_g_id, l_person_id, l_effective_date);
4146: i := 0;
4147: loop

Line 4157: hr_utility.set_location('CUR_EI_BLOCK',156);

4153: sv_cpp_date(i).cpp_revocation_date := l_cpp_revocation_date;
4154: end loop;
4155: close cur_cpp_date_block;
4156:
4157: hr_utility.set_location('CUR_EI_BLOCK',156);
4158:
4159: open cur_ei_block( fp_b_g_id, l_person_id, l_effective_date);
4160: fetch cur_ei_block into sv_ei_block;
4161: close cur_ei_block;

Line 4163: hr_utility.set_location('JURISDICTION_CODE',157);

4159: open cur_ei_block( fp_b_g_id, l_person_id, l_effective_date);
4160: fetch cur_ei_block into sv_ei_block;
4161: close cur_ei_block;
4162:
4163: hr_utility.set_location('JURISDICTION_CODE',157);
4164:
4165: open get_jurisdiction_code(l_assignment_action_id);
4166: fetch get_jurisdiction_code into sv_jurisdiction;
4167: close get_jurisdiction_code;

Line 4169: hr_utility.set_location('CUR_DBI',159);

4165: open get_jurisdiction_code(l_assignment_action_id);
4166: fetch get_jurisdiction_code into sv_jurisdiction;
4167: close get_jurisdiction_code;
4168:
4169: hr_utility.set_location('CUR_DBI',159);
4170:
4171: open cur_dbi(l_assignment_action_id);
4172: hr_utility.set_location(' Cursor Assignment actions '||
4173: to_char(l_assignment_action_id), 199);

Line 4172: hr_utility.set_location(' Cursor Assignment actions '||

4168:
4169: hr_utility.set_location('CUR_DBI',159);
4170:
4171: open cur_dbi(l_assignment_action_id);
4172: hr_utility.set_location(' Cursor Assignment actions '||
4173: to_char(l_assignment_action_id), 199);
4174: i := 0;
4175: loop
4176: fetch cur_dbi into l_dbi_name,

Line 4295: -- hr_utility.trace_on(null,'VRP');

4291: lv_meaning varchar2(80);
4292: lv_description varchar2(240);
4293: i number := 0;
4294: BEGIN
4295: -- hr_utility.trace_on(null,'VRP');
4296: hr_utility.set_location(gv_package_name || '.pier_yeer', 10);
4297: hr_utility.set_location('Reporting Year ' || p_reporting_year, 20);
4298: hr_utility.set_location('Report Name ' || p_pier_yeer, 30);
4299: hr_utility.set_location('Fed/Prov ' || p_fed_prov, 40);

Line 4296: hr_utility.set_location(gv_package_name || '.pier_yeer', 10);

4292: lv_description varchar2(240);
4293: i number := 0;
4294: BEGIN
4295: -- hr_utility.trace_on(null,'VRP');
4296: hr_utility.set_location(gv_package_name || '.pier_yeer', 10);
4297: hr_utility.set_location('Reporting Year ' || p_reporting_year, 20);
4298: hr_utility.set_location('Report Name ' || p_pier_yeer, 30);
4299: hr_utility.set_location('Fed/Prov ' || p_fed_prov, 40);
4300: hr_utility.set_location('GRE ' || to_char(p_gre), 50);

Line 4297: hr_utility.set_location('Reporting Year ' || p_reporting_year, 20);

4293: i number := 0;
4294: BEGIN
4295: -- hr_utility.trace_on(null,'VRP');
4296: hr_utility.set_location(gv_package_name || '.pier_yeer', 10);
4297: hr_utility.set_location('Reporting Year ' || p_reporting_year, 20);
4298: hr_utility.set_location('Report Name ' || p_pier_yeer, 30);
4299: hr_utility.set_location('Fed/Prov ' || p_fed_prov, 40);
4300: hr_utility.set_location('GRE ' || to_char(p_gre), 50);
4301: hr_utility.set_location('PRE ' || to_char(p_pre), 60);

Line 4298: hr_utility.set_location('Report Name ' || p_pier_yeer, 30);

4294: BEGIN
4295: -- hr_utility.trace_on(null,'VRP');
4296: hr_utility.set_location(gv_package_name || '.pier_yeer', 10);
4297: hr_utility.set_location('Reporting Year ' || p_reporting_year, 20);
4298: hr_utility.set_location('Report Name ' || p_pier_yeer, 30);
4299: hr_utility.set_location('Fed/Prov ' || p_fed_prov, 40);
4300: hr_utility.set_location('GRE ' || to_char(p_gre), 50);
4301: hr_utility.set_location('PRE ' || to_char(p_pre), 60);
4302: hr_utility.set_location('BGID ' || to_char(p_b_g_id), 70);

Line 4299: hr_utility.set_location('Fed/Prov ' || p_fed_prov, 40);

4295: -- hr_utility.trace_on(null,'VRP');
4296: hr_utility.set_location(gv_package_name || '.pier_yeer', 10);
4297: hr_utility.set_location('Reporting Year ' || p_reporting_year, 20);
4298: hr_utility.set_location('Report Name ' || p_pier_yeer, 30);
4299: hr_utility.set_location('Fed/Prov ' || p_fed_prov, 40);
4300: hr_utility.set_location('GRE ' || to_char(p_gre), 50);
4301: hr_utility.set_location('PRE ' || to_char(p_pre), 60);
4302: hr_utility.set_location('BGID ' || to_char(p_b_g_id), 70);
4303:

Line 4300: hr_utility.set_location('GRE ' || to_char(p_gre), 50);

4296: hr_utility.set_location(gv_package_name || '.pier_yeer', 10);
4297: hr_utility.set_location('Reporting Year ' || p_reporting_year, 20);
4298: hr_utility.set_location('Report Name ' || p_pier_yeer, 30);
4299: hr_utility.set_location('Fed/Prov ' || p_fed_prov, 40);
4300: hr_utility.set_location('GRE ' || to_char(p_gre), 50);
4301: hr_utility.set_location('PRE ' || to_char(p_pre), 60);
4302: hr_utility.set_location('BGID ' || to_char(p_b_g_id), 70);
4303:
4304: open cur_lkup;

Line 4301: hr_utility.set_location('PRE ' || to_char(p_pre), 60);

4297: hr_utility.set_location('Reporting Year ' || p_reporting_year, 20);
4298: hr_utility.set_location('Report Name ' || p_pier_yeer, 30);
4299: hr_utility.set_location('Fed/Prov ' || p_fed_prov, 40);
4300: hr_utility.set_location('GRE ' || to_char(p_gre), 50);
4301: hr_utility.set_location('PRE ' || to_char(p_pre), 60);
4302: hr_utility.set_location('BGID ' || to_char(p_b_g_id), 70);
4303:
4304: open cur_lkup;
4305: loop

Line 4302: hr_utility.set_location('BGID ' || to_char(p_b_g_id), 70);

4298: hr_utility.set_location('Report Name ' || p_pier_yeer, 30);
4299: hr_utility.set_location('Fed/Prov ' || p_fed_prov, 40);
4300: hr_utility.set_location('GRE ' || to_char(p_gre), 50);
4301: hr_utility.set_location('PRE ' || to_char(p_pre), 60);
4302: hr_utility.set_location('BGID ' || to_char(p_b_g_id), 70);
4303:
4304: open cur_lkup;
4305: loop
4306: fetch cur_lkup into lv_lookup_code,

Line 4318: hr_utility.set_location('DATE ' || sv_date, 80);

4314: end loop;
4315: close cur_lkup;
4316:
4317: select to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') into sv_date from dual;
4318: hr_utility.set_location('DATE ' || sv_date, 80);
4319:
4320: /* Report Parameters print first using static_header procedure */
4321:
4322: sv_gre := p_gre;

Line 4357: hr_utility.set_location('Report: ' || p_pier_yeer, 85);

4353: else
4354: sv_ei_max_exempt := ( ( sv_ei_max_earn ) * sv_ei_rate / 100 );
4355: end if;
4356: */
4357: hr_utility.set_location('Report: ' || p_pier_yeer, 85);
4358:
4359: if ( p_pier_yeer = 'P' ) then
4360: if ( p_fed_prov = 'F' ) then
4361: sv_pier_yeer := get_lookup_meaning('L_PIER');

Line 4369: hr_utility.set_location('Report: ' || sv_pier_yeer, 90);

4365: else
4366: sv_pier_yeer := get_lookup_meaning('L_YEER');
4367: end if;
4368:
4369: hr_utility.set_location('Report: ' || sv_pier_yeer, 90);
4370:
4371:
4372: if p_fed_prov = 'P' then
4373: sv_fed_prov := get_lookup_meaning('L_PROV');

Line 4377: hr_utility.set_location('FEd/Prov: ' || sv_fed_prov, 100);

4373: sv_fed_prov := get_lookup_meaning('L_PROV');
4374: else
4375: sv_fed_prov := get_lookup_meaning('L_FED');
4376: end if;
4377: hr_utility.set_location('FEd/Prov: ' || sv_fed_prov, 100);
4378:
4379: if ( p_gre is not null ) then
4380: begin
4381: /* Used to print GRE name as report parameter. */

Line 4395: hr_utility.set_location('GRE ' || sv_gre_name, 110);

4391: exception
4392: when others then
4393: null;
4394: end;
4395: hr_utility.set_location('GRE ' || sv_gre_name, 110);
4396: end if;
4397:
4398: if ( p_pre is not null ) then
4399: begin

Line 4417: hr_utility.set_location('PRE ' || sv_pre_name, 120);

4413: exception
4414: when others then
4415: null;
4416: end;
4417: hr_utility.set_location('PRE ' || sv_pre_name, 120);
4418: hr_utility.set_location('QIN ' || sv_qin, 120);
4419: end if;
4420:
4421: begin

Line 4418: hr_utility.set_location('QIN ' || sv_qin, 120);

4414: when others then
4415: null;
4416: end;
4417: hr_utility.set_location('PRE ' || sv_pre_name, 120);
4418: hr_utility.set_location('QIN ' || sv_qin, 120);
4419: end if;
4420:
4421: begin
4422: