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

APPS.PAY_CA_RL2_AMEND_MAG dependencies on PAY_CA_RL2_MAG

Line 38: pay_ca_rl2_mag.

34: Report.
35: Reused the functions
36: validate_quebec_number
37: and convert_special_char defined in
38: pay_ca_rl2_mag.
39: Added the feature to show only those
40: emloyees
41: whose assignamnents got amended since
42: the previous run of amendment mag media.

Line 161: pay_ca_rl2_mag.get_parameter('PRE_ORGANIZATION_ID',

157: ppa.report_qualifier = 'CAEOY_RL2_AMEND_PPQ' AND
158: ppa.report_category = 'ARCHIVE' AND
159: ppa.effective_date = p_effective_date AND
160: p_transmitter_org_id =
161: pay_ca_rl2_mag.get_parameter('PRE_ORGANIZATION_ID',
162: ppa.legislative_parameters);
163:
164: l_transmitter_number VARCHAR2(30);
165: l_transmitter_name VARCHAR2(100);

Line 201: l_transmitter_org_id := pay_ca_rl2_mag.get_parameter('TRANSMITTER_PRE',

197: FETCH cur_ppa
198: INTO l_legislative_parameters;
199: CLOSE cur_ppa;
200:
201: l_transmitter_org_id := pay_ca_rl2_mag.get_parameter('TRANSMITTER_PRE',
202: l_legislative_parameters);
203:
204: hr_utility.trace('l_transmitter_org_id = ' || to_char(l_transmitter_org_id));
205: hr_utility.trace('p_bg_id = ' || to_char(p_bg_id));

Line 325: and tran.reporting_year = pay_ca_rl2_mag.get_parameter(''REPORTING_YEAR'',ppa_mag.legislative_parameters)

321: and ppa_arch.report_type = ''CAEOY_RL2_AMEND_PP''
322: and ppa_arch.payroll_action_id = paa_arch.payroll_action_id
323: and tran.reporting_year = to_char(ppa_arch.effective_date,''YYYY'')
324: and tran.business_group_id = ppa_arch.business_group_id
325: and tran.reporting_year = pay_ca_rl2_mag.get_parameter(''REPORTING_YEAR'',ppa_mag.legislative_parameters)
326: and paa_arch.payroll_action_id = tran.payroll_action_id
327: and paa_arch.action_status = ''C''
328: and paa_arch.assignment_action_id = emp.assignment_action_id
329: and paa_arch.payroll_action_id = emp.payroll_action_id

Line 635: l_return := pay_ca_rl2_mag.validate_quebec_number(l_quebec_no,l_emplyer_name);

631: pay_core_utils.push_message(800,'PAY_CA_RL2_MISSING_ADDRESS','P');
632: hr_utility.raise_error;
633: end if;
634: hr_utility.trace('First 10 digits of the QIN: '||l_quebec_no);
635: l_return := pay_ca_rl2_mag.validate_quebec_number(l_quebec_no,l_emplyer_name);
636:
637: end if ;
638: hr_utility.trace('Assignment Fetched - ');
639: hr_utility.trace('Assignment Id : '|| to_char(l_assignment_id));

Line 995: pay_ca_rl2_mag.convert_special_char(l_trans_package_type) || '' || EOL; --Bug 9154497

991:
992:
993: -- TypeEnvoi
994: tab_transmitter(lTypeEnvoi) := '' ||
995: pay_ca_rl2_mag.convert_special_char(l_trans_package_type) || '' || EOL; --Bug 9154497
996:
997: hr_utility.trace('tab_transmitter(lTypeEnvoi) = ' ||
998: tab_transmitter(lTypeEnvoi));
999:

Line 1001: pay_ca_rl2_mag.convert_special_char(l_source_of_slips) || '' || EOL;

997: hr_utility.trace('tab_transmitter(lTypeEnvoi) = ' ||
998: tab_transmitter(lTypeEnvoi));
999:
1000: tab_transmitter(lProvenance) := '' ||
1001: pay_ca_rl2_mag.convert_special_char(l_source_of_slips) || '' || EOL;
1002:
1003: hr_utility.trace('tab_transmitter(lProvenance) = ' || tab_transmitter(lProvenance));
1004:
1005: tab_transmitter(lNo) := '' ||

Line 1006: pay_ca_rl2_mag.convert_special_char(l_trans_number) || '' || EOL;

1002:
1003: hr_utility.trace('tab_transmitter(lProvenance) = ' || tab_transmitter(lProvenance));
1004:
1005: tab_transmitter(lNo) := '' ||
1006: pay_ca_rl2_mag.convert_special_char(l_trans_number) || '' || EOL;
1007:
1008: hr_utility.trace('tab_transmitter(lNo) = ' || tab_transmitter(lNo));
1009:
1010:

Line 1014: pay_ca_rl2_mag.convert_special_char(l_trans_type_indicator) || '' || EOL;

1010:
1011: IF l_trans_type_indicator IS NOT NULL AND
1012: l_trans_type_indicator <> '0' THEN
1013: tab_transmitter(lType) := '' ||
1014: pay_ca_rl2_mag.convert_special_char(l_trans_type_indicator) || '' || EOL;
1015: ELSE
1016: tab_transmitter(lType) := NULL;
1017: END IF;
1018:

Line 1022: pay_ca_rl2_mag.convert_special_char(substr(l_trans_name,1,30)) || '' || EOL;

1018:
1019: hr_utility.trace('tab_transmitter(lType) = ' || tab_transmitter(lType));
1020:
1021: tab_transmitter(lNom1) := '' ||
1022: pay_ca_rl2_mag.convert_special_char(substr(l_trans_name,1,30)) || '' || EOL;
1023:
1024: hr_utility.trace('tab_transmitter(lNom1) = ' || tab_transmitter(lNom1));
1025:
1026: l_return := substr(l_trans_name,31,30);

Line 1028: tab_transmitter(lNom2) := '' || pay_ca_rl2_mag.convert_special_char(l_return) || '' || EOL;

1024: hr_utility.trace('tab_transmitter(lNom1) = ' || tab_transmitter(lNom1));
1025:
1026: l_return := substr(l_trans_name,31,30);
1027: IF l_return IS NOT NULL THEN
1028: tab_transmitter(lNom2) := '' || pay_ca_rl2_mag.convert_special_char(l_return) || '' || EOL;
1029: ELSE
1030: tab_transmitter(lNom2) := NULL;
1031: END IF;
1032:

Line 1037: pay_ca_rl2_mag.convert_special_char(substr(l_trans_address_line1,1,30)) || '' || EOL;

1033: hr_utility.trace('tab_transmitter(lNom2) = ' || tab_transmitter(lNom2));
1034:
1035:
1036: tab_transmitter(lLigne1) := '' ||
1037: pay_ca_rl2_mag.convert_special_char(substr(l_trans_address_line1,1,30)) || '' || EOL;
1038:
1039: hr_utility.trace('tab_transmitter(lLigne1) = ' || tab_transmitter(lLigne1));
1040:
1041:

Line 1045: pay_ca_rl2_mag.convert_special_char(substr(l_trans_address_line2,1,30)) || '' || EOL;

1041:
1042: IF (l_trans_address_line2 IS NOT NULL AND
1043: l_trans_address_line2 <> ' ') THEN
1044: tab_transmitter(lLigne2) := '' ||
1045: pay_ca_rl2_mag.convert_special_char(substr(l_trans_address_line2,1,30)) || '' || EOL;
1046: ELSE
1047: tab_transmitter(lLigne2) := NULL;
1048: END IF;
1049:

Line 1056: pay_ca_rl2_mag.convert_special_char(substr(l_trans_city,1,30)) || '' || EOL;

1052:
1053: IF (l_trans_city IS NOT NULL AND
1054: l_trans_city <> ' ') THEN
1055: tab_transmitter(lVille) := '' ||
1056: pay_ca_rl2_mag.convert_special_char(substr(l_trans_city,1,30)) || '' || EOL;
1057: ELSE
1058: tab_transmitter(lVille) := NULL;
1059: END IF;
1060:

Line 1066: pay_ca_rl2_mag.convert_special_char(SUBSTR(hr_general.decode_lookup(

1062:
1063: IF (l_trans_province IS NOT NULL AND
1064: l_trans_province <> ' ') THEN
1065: tab_transmitter(lProvince) := '' ||
1066: pay_ca_rl2_mag.convert_special_char(SUBSTR(hr_general.decode_lookup(
1067: 'CA_PROVINCE',l_trans_province),1,20)) || '' || EOL;
1068: ELSE
1069: tab_transmitter(lProvince) := NULL;
1070: END IF;

Line 1076: pay_ca_rl2_mag.convert_special_char(substr(l_trans_postal_code,1,6)) || '' || EOL;

1072:
1073: IF (l_trans_postal_code IS NOT NULL AND
1074: l_trans_postal_code <> ' ') THEN
1075: tab_transmitter(lCodePostal) := '' ||
1076: pay_ca_rl2_mag.convert_special_char(substr(l_trans_postal_code,1,6)) || '' || EOL;
1077: ELSE
1078: tab_transmitter(lCodePostal) := NULL;
1079: END IF;
1080: hr_utility.trace('tab_transmitter(lCodePostal) = ' || tab_transmitter(lCodePostal));

Line 1087: pay_ca_rl2_mag.convert_special_char(substr(l_trans_tech_contact_name,1,30)) || '' || EOL;

1083: IF (l_trans_tech_contact_name IS NOT NULL AND
1084: l_trans_tech_contact_name <> ' ' ) THEN
1085: l_Informatique_tag := 'Y';
1086: tab_transmitter(lNom) := '' ||
1087: pay_ca_rl2_mag.convert_special_char(substr(l_trans_tech_contact_name,1,30)) || '' || EOL;
1088: ELSE
1089: tab_transmitter(lNom) := NULL;
1090: END IF;
1091:

Line 1099: pay_ca_rl2_mag.convert_special_char(l_trans_tech_contact_code) || '' || EOL;

1095: IF (l_trans_tech_contact_code IS NOT NULL AND
1096: l_trans_tech_contact_code <> '000' ) THEN
1097: l_Informatique_tag := 'Y';
1098: tab_transmitter(lIndRegional) := '' ||
1099: pay_ca_rl2_mag.convert_special_char(l_trans_tech_contact_code) || '' || EOL;
1100: ELSE
1101: tab_transmitter(lIndRegional) := NULL;
1102: END IF;
1103:

Line 1110: tab_transmitter(lTel) := '' || pay_ca_rl2_mag.convert_special_char(l_trans_tech_contact_phone) || '' || EOL;

1106: IF (l_trans_tech_contact_phone IS NOT NULL AND
1107: l_trans_tech_contact_phone <> '0000000' ) THEN
1108: l_Informatique_tag := 'Y';
1109: l_trans_tech_contact_phone := substr(l_trans_tech_contact_phone,1,3) || '-' || substr(l_trans_tech_contact_phone,4,4);
1110: tab_transmitter(lTel) := '' || pay_ca_rl2_mag.convert_special_char(l_trans_tech_contact_phone) || '' || EOL;
1111: ELSE
1112: tab_transmitter(lTel) := NULL;
1113: END IF;
1114: hr_utility.trace('tab_transmitter(lTel) = ' || tab_transmitter(lTel));

Line 1120: tab_transmitter(lPosteTel) := '' || pay_ca_rl2_mag.convert_special_char(l_trans_tech_contact_extn) ||

1116:
1117: IF (l_trans_tech_contact_extn IS NOT NULL AND
1118: l_trans_tech_contact_extn <> '0000' ) THEN
1119: l_Informatique_tag := 'Y';
1120: tab_transmitter(lPosteTel) := '' || pay_ca_rl2_mag.convert_special_char(l_trans_tech_contact_extn) ||
1121: '' || EOL;
1122: ELSE
1123: tab_transmitter(lPosteTel) := NULL;
1124: END IF;

Line 1132: tab_transmitter(lLangue) := '' ||pay_ca_rl2_mag.convert_special_char(l_trans_tech_contact_lang) || '' || EOL;

1128:
1129: IF (l_trans_tech_contact_lang IS NOT NULL AND
1130: l_trans_tech_contact_lang <> ' ' ) THEN
1131: l_Informatique_tag := 'Y';
1132: tab_transmitter(lLangue) := '' ||pay_ca_rl2_mag.convert_special_char(l_trans_tech_contact_lang) || '' || EOL;
1133: ELSE
1134: tab_transmitter(lLangue) := NULL;
1135: END IF;
1136:

Line 1142: pay_ca_rl2_mag.convert_special_char(substr(l_trans_acct_contact_name,1,30)) || '' || EOL;

1138: IF (l_trans_acct_contact_name IS NOT NULL AND
1139: l_trans_acct_contact_name <> ' ') THEN
1140: l_Comptabilite_tag := 'Y';
1141: tab_transmitter(lANom) := '' ||
1142: pay_ca_rl2_mag.convert_special_char(substr(l_trans_acct_contact_name,1,30)) || '' || EOL;
1143: ELSE
1144: tab_transmitter(lANom) := NULL;
1145: END IF;
1146: hr_utility.trace('tab_transmitter(lANom) = ' || tab_transmitter(lANom));

Line 1152: tab_transmitter(lAIndRegional) := '' || pay_ca_rl2_mag.convert_special_char(l_trans_acct_contact_code) ||

1148:
1149: IF (l_trans_acct_contact_code IS NOT NULL AND
1150: l_trans_acct_contact_code <> '000' ) THEN
1151: l_Comptabilite_tag := 'Y';
1152: tab_transmitter(lAIndRegional) := '' || pay_ca_rl2_mag.convert_special_char(l_trans_acct_contact_code) ||
1153: '' || EOL;
1154: ELSE
1155: tab_transmitter(lAIndRegional) := NULL;
1156: END IF;

Line 1164: tab_transmitter(lATel) := '' || pay_ca_rl2_mag.convert_special_char(l_trans_acct_contact_phone) || '' || EOL;

1160: IF (l_trans_acct_contact_phone IS NOT NULL AND
1161: l_trans_acct_contact_phone <> '0000000' ) THEN
1162: l_Comptabilite_tag := 'Y';
1163: l_trans_acct_contact_phone := substr(l_trans_acct_contact_phone,1,3) || '-' || substr(l_trans_acct_contact_phone,4,4);
1164: tab_transmitter(lATel) := '' || pay_ca_rl2_mag.convert_special_char(l_trans_acct_contact_phone) || '' || EOL;
1165: ELSE
1166: tab_transmitter(lATel) := NULL;
1167: END IF;
1168: hr_utility.trace('tab_transmitter(lATel) = ' || tab_transmitter(lATel));

Line 1174: tab_transmitter(lAPosteTel) := '' || pay_ca_rl2_mag.convert_special_char(l_trans_acct_contact_extn) ||

1170:
1171: IF (l_trans_acct_contact_extn IS NOT NULL AND
1172: l_trans_acct_contact_extn <> '0000') THEN
1173: l_Comptabilite_tag := 'Y';
1174: tab_transmitter(lAPosteTel) := '' || pay_ca_rl2_mag.convert_special_char(l_trans_acct_contact_extn) ||
1175: '' || EOL;
1176: ELSE
1177: tab_transmitter(lAPosteTel) := NULL;
1178: END IF;

Line 1185: tab_transmitter(lALangue) := '' || pay_ca_rl2_mag.convert_special_char(l_trans_acct_contact_lang) ||

1181:
1182: IF (l_trans_acct_contact_lang IS NOT NULL AND
1183: l_trans_acct_contact_lang <> ' ' ) THEN
1184: l_Comptabilite_tag := 'Y';
1185: tab_transmitter(lALangue) := '' || pay_ca_rl2_mag.convert_special_char(l_trans_acct_contact_lang) ||
1186: '' || EOL;
1187: ELSE
1188: tab_transmitter(lALangue) := NULL;
1189: END IF;

Line 1216: tab_transmitter(lNoConcepteur) := ''||pay_ca_rl2_mag.convert_special_char(l_authorization_no)||''||EOL;

1212: l_authorization_no := 'RQ-'||substr(trim(l_reporting_year),3,2)||'-99-999';
1213: END IF;
1214: --- End 6736354
1215:
1216: tab_transmitter(lNoConcepteur) := ''||pay_ca_rl2_mag.convert_special_char(l_authorization_no)||''||EOL;
1217:
1218: hr_utility.trace('tab_transmitter(lALangue) = ' || tab_transmitter(lALangue));
1219:
1220: IF l_Informatique_tag = 'Y' AND

Line 1818: l_rl2_first_slip_number := pay_ca_rl2_mag.get_slip_seq_no('|',l_rl2_slip_number,1);

1814: /* Check for Mandatory Information RL-2 Slip Number missing */
1815:
1816: /* Bug 14701748 */
1817:
1818: l_rl2_first_slip_number := pay_ca_rl2_mag.get_slip_seq_no('|',l_rl2_slip_number,1);
1819:
1820: IF ( l_rl2_first_slip_number = '000000000' AND
1821: l_rl2_first_slip_number IS NOT NULL) THEN
1822: l_status := 'Failed';

Line 1827: tab_employee(lNoReleve) := '' || pay_ca_rl2_mag.convert_special_char(l_rl2_first_slip_number) ||

1823: l_msg_code := 'MISSING_SLIP_NO';
1824: tab_employee(lNoReleve) := NULL;
1825:
1826: ELSE
1827: tab_employee(lNoReleve) := '' || pay_ca_rl2_mag.convert_special_char(l_rl2_first_slip_number) ||
1828: '' || EOL;
1829:
1830: END IF;
1831: hr_utility.trace('tab_employee(lNoReleve) = ' || tab_employee(lNoReleve));

Line 1839: tab_employee(lNAS) := '' || pay_ca_rl2_mag.convert_special_char(l_employee_sin) || '' || EOL;

1835: IF (l_employee_sin IS NOT NULL AND
1836: l_employee_sin <> '000000000') THEN
1837:
1838:
1839: tab_employee(lNAS) := '' || pay_ca_rl2_mag.convert_special_char(l_employee_sin) || '' || EOL;
1840:
1841: ELSE
1842: l_status := 'Failed';
1843: l_msg_code := 'SIN';

Line 1852: tab_employee(lNo) := '' || pay_ca_rl2_mag.convert_special_char(l_employee_number) || '' || EOL;

1848:
1849: -- No
1850: IF (l_employee_number IS NOT NULL AND
1851: l_employee_number <> ' ' ) THEN
1852: tab_employee(lNo) := '' || pay_ca_rl2_mag.convert_special_char(l_employee_number) || '' || EOL;
1853:
1854: ELSE
1855: tab_employee(lNo) := NULL;
1856:

Line 1863: pay_ca_rl2_mag.convert_special_char(substr(l_employee_last_name,1,30)) || '' || EOL;

1859:
1860: -- NomFamille
1861:
1862: tab_employee(lNomFamille) := '' ||
1863: pay_ca_rl2_mag.convert_special_char(substr(l_employee_last_name,1,30)) || '' || EOL;
1864: hr_utility.trace('tab_employee(lNomFamille) = ' || tab_employee(lNomFamille));
1865: l_full_empname := pay_ca_rl2_mag.convert_special_char(substr(l_employee_last_name,1,30));
1866: -- Prenom
1867: IF (l_employee_first_name is NOT NULL AND

Line 1865: l_full_empname := pay_ca_rl2_mag.convert_special_char(substr(l_employee_last_name,1,30));

1861:
1862: tab_employee(lNomFamille) := '' ||
1863: pay_ca_rl2_mag.convert_special_char(substr(l_employee_last_name,1,30)) || '' || EOL;
1864: hr_utility.trace('tab_employee(lNomFamille) = ' || tab_employee(lNomFamille));
1865: l_full_empname := pay_ca_rl2_mag.convert_special_char(substr(l_employee_last_name,1,30));
1866: -- Prenom
1867: IF (l_employee_first_name is NOT NULL AND
1868: l_employee_first_name <> ' ') THEN
1869: tab_employee(lPrenom) := '' || pay_ca_rl2_mag.convert_special_char(substr(l_employee_first_name,1,30))

Line 1869: tab_employee(lPrenom) := '' || pay_ca_rl2_mag.convert_special_char(substr(l_employee_first_name,1,30))

1865: l_full_empname := pay_ca_rl2_mag.convert_special_char(substr(l_employee_last_name,1,30));
1866: -- Prenom
1867: IF (l_employee_first_name is NOT NULL AND
1868: l_employee_first_name <> ' ') THEN
1869: tab_employee(lPrenom) := '' || pay_ca_rl2_mag.convert_special_char(substr(l_employee_first_name,1,30))
1870: || '' || EOL;
1871: l_full_empname := l_full_empname ||','||pay_ca_rl2_mag.convert_special_char(substr(l_employee_first_name,1,30));
1872: ELSE
1873: l_msg_code := 'MISSING_EMP_FIRST_NAME';

Line 1871: l_full_empname := l_full_empname ||','||pay_ca_rl2_mag.convert_special_char(substr(l_employee_first_name,1,30));

1867: IF (l_employee_first_name is NOT NULL AND
1868: l_employee_first_name <> ' ') THEN
1869: tab_employee(lPrenom) := '' || pay_ca_rl2_mag.convert_special_char(substr(l_employee_first_name,1,30))
1870: || '' || EOL;
1871: l_full_empname := l_full_empname ||','||pay_ca_rl2_mag.convert_special_char(substr(l_employee_first_name,1,30));
1872: ELSE
1873: l_msg_code := 'MISSING_EMP_FIRST_NAME';
1874: l_status := 'Failed';
1875: tab_employee(lPrenom) := NULL;

Line 1883: tab_employee(lInitiale) := '' || pay_ca_rl2_mag.convert_special_char(substr(l_employee_middle_initial,1,1))

1879: -- Initiale
1880:
1881: IF (l_employee_middle_initial is NOT NULL AND
1882: l_employee_middle_initial <> ' ') THEN
1883: tab_employee(lInitiale) := '' || pay_ca_rl2_mag.convert_special_char(substr(l_employee_middle_initial,1,1))
1884: || '' || EOL;
1885: l_full_empname := l_full_empname ||' '||pay_ca_rl2_mag.convert_special_char(substr(l_employee_middle_initial,1,1));
1886: ELSE
1887: tab_employee(lInitiale) := NULL;

Line 1885: l_full_empname := l_full_empname ||' '||pay_ca_rl2_mag.convert_special_char(substr(l_employee_middle_initial,1,1));

1881: IF (l_employee_middle_initial is NOT NULL AND
1882: l_employee_middle_initial <> ' ') THEN
1883: tab_employee(lInitiale) := '' || pay_ca_rl2_mag.convert_special_char(substr(l_employee_middle_initial,1,1))
1884: || '' || EOL;
1885: l_full_empname := l_full_empname ||' '||pay_ca_rl2_mag.convert_special_char(substr(l_employee_middle_initial,1,1));
1886: ELSE
1887: tab_employee(lInitiale) := NULL;
1888: END IF;
1889:

Line 1935: pay_ca_rl2_mag.convert_special_char(substr(l_address_line1,1,30)) || '' || EOL;

1931:
1932: l_addr_begin_tag := '';
1933:
1934: tab_employee(lLigne1) := '' ||
1935: pay_ca_rl2_mag.convert_special_char(substr(l_address_line1,1,30)) || '' || EOL;
1936:
1937: hr_utility.trace('tab_employee(lLigne1) = ' || tab_employee(lLigne1));
1938:
1939: -- Address Line 2

Line 1947: pay_ca_rl2_mag.convert_special_char(substr(l_combined_addr,1,30)) || '' || EOL;

1943: (l_address_line3 IS NOT NULL AND
1944: l_address_line3 <> ' ') ) THEN
1945: l_combined_addr := rtrim(ltrim(l_address_line2)) || rtrim(ltrim(l_address_line3));
1946: tab_employee(lLigne2) := '' ||
1947: pay_ca_rl2_mag.convert_special_char(substr(l_combined_addr,1,30)) || '' || EOL;
1948:
1949: ELSE
1950:
1951: tab_employee(lLigne2) := NULL;

Line 1960: pay_ca_rl2_mag.convert_special_char(substr(l_city,1,30)) || '' || EOL;

1956: -- Ville (City)
1957: IF l_city IS NOT NULL AND
1958: l_city <> ' ' THEN
1959: tab_employee(lVille) := '' ||
1960: pay_ca_rl2_mag.convert_special_char(substr(l_city,1,30)) || '' || EOL;
1961: l_full_empaddr := pay_ca_rl2_mag.convert_special_char(substr(l_city,1,30));
1962:
1963: ELSE
1964: tab_employee(lVille) := NULL;

Line 1961: l_full_empaddr := pay_ca_rl2_mag.convert_special_char(substr(l_city,1,30));

1957: IF l_city IS NOT NULL AND
1958: l_city <> ' ' THEN
1959: tab_employee(lVille) := '' ||
1960: pay_ca_rl2_mag.convert_special_char(substr(l_city,1,30)) || '' || EOL;
1961: l_full_empaddr := pay_ca_rl2_mag.convert_special_char(substr(l_city,1,30));
1962:
1963: ELSE
1964: tab_employee(lVille) := NULL;
1965:

Line 1975: pay_ca_rl2_mag.convert_special_char(SUBSTR(hr_general.decode_lookup(

1971: l_emp_province <> ' ' THEN
1972:
1973: IF l_country = 'CA' THEN
1974: tab_employee(lProvince) := '' ||
1975: pay_ca_rl2_mag.convert_special_char(SUBSTR(hr_general.decode_lookup(
1976: 'CA_PROVINCE',l_emp_province),1,20)) || '' || EOL;
1977: l_full_empaddr := l_full_empaddr ||' '||pay_ca_rl2_mag.convert_special_char(l_emp_province);
1978:
1979:

Line 1977: l_full_empaddr := l_full_empaddr ||' '||pay_ca_rl2_mag.convert_special_char(l_emp_province);

1973: IF l_country = 'CA' THEN
1974: tab_employee(lProvince) := '' ||
1975: pay_ca_rl2_mag.convert_special_char(SUBSTR(hr_general.decode_lookup(
1976: 'CA_PROVINCE',l_emp_province),1,20)) || '' || EOL;
1977: l_full_empaddr := l_full_empaddr ||' '||pay_ca_rl2_mag.convert_special_char(l_emp_province);
1978:
1979:
1980: ELSIF l_country = 'US' THEN
1981: tab_employee(lProvince) := '' ||l_emp_province || '' || EOL;

Line 2000: pay_ca_rl2_mag.convert_special_char(substr(replace(l_postal_code,' '),1,6)) || '' || EOL;

1996: -- Postal Code
1997: IF l_postal_code IS NOT NULL AND
1998: l_postal_code <> ' ' THEN
1999: tab_employee(lCodePostal) := '' ||
2000: pay_ca_rl2_mag.convert_special_char(substr(replace(l_postal_code,' '),1,6)) || '' || EOL;
2001: l_full_empaddr := l_full_empaddr ||' '||pay_ca_rl2_mag.convert_special_char(substr(replace(l_country,' '),1,6))||' '||
2002: pay_ca_rl2_mag.convert_special_char(l_postal_code);
2003:
2004: ELSE

Line 2001: l_full_empaddr := l_full_empaddr ||' '||pay_ca_rl2_mag.convert_special_char(substr(replace(l_country,' '),1,6))||' '||

1997: IF l_postal_code IS NOT NULL AND
1998: l_postal_code <> ' ' THEN
1999: tab_employee(lCodePostal) := '' ||
2000: pay_ca_rl2_mag.convert_special_char(substr(replace(l_postal_code,' '),1,6)) || '' || EOL;
2001: l_full_empaddr := l_full_empaddr ||' '||pay_ca_rl2_mag.convert_special_char(substr(replace(l_country,' '),1,6))||' '||
2002: pay_ca_rl2_mag.convert_special_char(l_postal_code);
2003:
2004: ELSE
2005: tab_employee(lCodePostal) := NULL;

Line 2002: pay_ca_rl2_mag.convert_special_char(l_postal_code);

1998: l_postal_code <> ' ' THEN
1999: tab_employee(lCodePostal) := '' ||
2000: pay_ca_rl2_mag.convert_special_char(substr(replace(l_postal_code,' '),1,6)) || '' || EOL;
2001: l_full_empaddr := l_full_empaddr ||' '||pay_ca_rl2_mag.convert_special_char(substr(replace(l_country,' '),1,6))||' '||
2002: pay_ca_rl2_mag.convert_special_char(l_postal_code);
2003:
2004: ELSE
2005: tab_employee(lCodePostal) := NULL;
2006: END IF;

Line 2413: pay_ca_rl2_mag.convert_special_char(l_rl2_source_of_income) || '' || EOL;

2409: IF ( l_rl2_source_of_income = 'AUTRE' ) THEN
2410: tab_employee(lProvenance1) := null;
2411: else
2412: tab_employee(lProvenance1) := '' ||
2413: pay_ca_rl2_mag.convert_special_char(l_rl2_source_of_income) || '' || EOL;
2414: end if;
2415:
2416: ELSE
2417: /* Commented for Bug 6732992

Line 2426: l_transmitter_org_id := pay_ca_rl2_mag.get_parameter('TRANSMITTER_PRE',

2422:
2423: END IF;
2424: hr_utility.trace('tab_employee(lProvenance1) = ' ||
2425: tab_employee(lProvenance1));
2426: l_transmitter_org_id := pay_ca_rl2_mag.get_parameter('TRANSMITTER_PRE',
2427: l_legislative_parameters);
2428:
2429: /* For bug 8888411 */
2430: OPEN c_rl2_src_income(replace(l_rl2_source_of_income,'AUTRE','OTHER'), l_taxation_year);

Line 2469: l_original_slpno := pay_ca_rl2_mag.get_slip_seq_no('|',lv_org_slip_no,1);

2465: tab_employee(l_origi_slipno) := NULL;
2466: l_status := 'Failed';
2467: l_msg_code := 'MISSING_SLIP_NO';
2468: ELSE
2469: l_original_slpno := pay_ca_rl2_mag.get_slip_seq_no('|',lv_org_slip_no,1);
2470: tab_employee(l_origi_slipno) := '' ||l_original_slpno|| ''||EOL;
2471: END IF;
2472:
2473:

Line 2528: pay_ca_rl2_mag.convert_special_char(l_meaning) || '' || EOL;

2524: END IF;
2525:
2526: IF l_status = 'Failed' THEN
2527: tab_employee(lErrorDetails) := '' ||
2528: pay_ca_rl2_mag.convert_special_char(l_meaning) || '' || EOL;
2529: ELSE
2530: tab_employee(lErrorDetails) := NULL;
2531: END IF;
2532:

Line 2583: tab_employee(lNoReleve) := '' || pay_ca_rl2_mag.convert_special_char(l_rl2_slip_number) ||

2579: /* Bug 14701748 */
2580: further_info_details:= null;
2581: IF l_status = 'Failed' THEN --For Failed employees further info should be displayed in single row. 'l_other_details' should be displayed
2582: /* Bug 15972457 */
2583: tab_employee(lNoReleve) := '' || pay_ca_rl2_mag.convert_special_char(l_rl2_slip_number) ||
2584: '' || EOL;
2585: /* Bug 15972457 */
2586: /* Bug 16015640 */
2587: tab_employee(l_origi_slipno) := '' || pay_ca_rl2_mag.convert_special_char(lv_org_slip_no) ||

Line 2587: tab_employee(l_origi_slipno) := '' || pay_ca_rl2_mag.convert_special_char(lv_org_slip_no) ||

2583: tab_employee(lNoReleve) := '' || pay_ca_rl2_mag.convert_special_char(l_rl2_slip_number) ||
2584: '' || EOL;
2585: /* Bug 15972457 */
2586: /* Bug 16015640 */
2587: tab_employee(l_origi_slipno) := '' || pay_ca_rl2_mag.convert_special_char(lv_org_slip_no) ||
2588: ''||EOL;
2589: /* Bug 16015640 */
2590: l_final_xml_string :=
2591: '<' || l_status || '>' || EOL ||

Line 2752: '' || pay_ca_rl2_mag.get_slip_seq_no('|',l_rl2_slip_number,slip_count) || '' ||

2748: l_final_xml_string_fur_inf :=
2749: '<' || l_status || '>' || EOL ||
2750: '' || EOL ||
2751: tab_employee(lAnnee) ||
2752: '' || pay_ca_rl2_mag.get_slip_seq_no('|',l_rl2_slip_number,slip_count) || '' ||
2753: '' || EOL ||
2754: tab_employee(lNAS) ||
2755: tab_employee(lNo) ||
2756: tab_employee(lNomFamille) ||

Line 2768: '' || pay_ca_rl2_mag.get_slip_seq_no('|',lv_org_slip_no,slip_count) || '' ||

2764: l_addr_end_tag || EOL || '' || EOL ||
2765: '' ||
2766: '' || EOL ||
2767: further_info_details || EOL ||
2768: '' || pay_ca_rl2_mag.get_slip_seq_no('|',lv_org_slip_no,slip_count) || '' ||
2769: '' || EOL ||
2770: '' ;
2771: count1 := 0;
2772: l_final_xml_string := l_final_xml_string || l_final_xml_string_fur_inf ;

Line 2944: tab_employer(lNold) := '' || pay_ca_rl2_mag.convert_special_char(substr(l_quebec_bn,1,10)) ||

2940: l_province,
2941: l_postal_code;
2942:
2943: hr_utility.trace('The Quebec Number is '||l_quebec_bn);
2944: tab_employer(lNold) := '' || pay_ca_rl2_mag.convert_special_char(substr(l_quebec_bn,1,10)) ||
2945: '' || EOL;
2946: tab_employer(lTypeDossier) := '' || 'RS' ||
2947: '' || EOL;
2948:

Line 2949: tab_employer(lNoDossier) := '' || pay_ca_rl2_mag.convert_special_char(substr(l_quebec_bn,13,4)) ||

2945: '' || EOL;
2946: tab_employer(lTypeDossier) := '' || 'RS' ||
2947: '' || EOL;
2948:
2949: tab_employer(lNoDossier) := '' || pay_ca_rl2_mag.convert_special_char(substr(l_quebec_bn,13,4)) ||
2950: '' || EOL;
2951: hr_utility.trace('The Employer File Number : '|| substr(l_quebec_bn,13,4));
2952:
2953: tab_employer(lNom1) := '' ||

Line 2954: pay_ca_rl2_mag.convert_special_char(substr(l_employer_name,1,30)) || '' || EOL;

2950: '' || EOL;
2951: hr_utility.trace('The Employer File Number : '|| substr(l_quebec_bn,13,4));
2952:
2953: tab_employer(lNom1) := '' ||
2954: pay_ca_rl2_mag.convert_special_char(substr(l_employer_name,1,30)) || '' || EOL;
2955: hr_utility.trace('tab_employer(lNom) = ' || tab_employer(lNom1));
2956:
2957: IF (l_address_line1 IS NULL AND
2958: l_address_line1 <> ' ' ) THEN

Line 2973: pay_ca_rl2_mag.convert_special_char(substr(l_address_line1,1,30)) || '' || EOL;

2969:
2970: l_address_begin_tag := '';
2971:
2972: tab_employer(lLigne1) := '' ||
2973: pay_ca_rl2_mag.convert_special_char(substr(l_address_line1,1,30)) || '' || EOL;
2974: hr_utility.trace('tab_employer(lLigne1) = ' || tab_employer(lLigne1));
2975:
2976:
2977: -- Address Line 2

Line 2982: pay_ca_rl2_mag.convert_special_char(substr(l_address_line2,1,30)) || '' || EOL;

2978:
2979: IF (l_address_line2 IS NOT NULL AND
2980: l_address_line2 <> ' ' ) THEN
2981: tab_employer(lLigne2) := '' ||
2982: pay_ca_rl2_mag.convert_special_char(substr(l_address_line2,1,30)) || '' || EOL;
2983: ELSE
2984: tab_employer(lLigne2) := NULL;
2985: END IF;
2986: hr_utility.trace('tab_employer(lLigne2) = ' || tab_employer(lLigne2));

Line 2993: pay_ca_rl2_mag.convert_special_char(substr(l_city,1,30)) || '' || EOL;

2989:
2990: IF ( l_city IS NOT NULL AND
2991: l_city <> ' ') THEN
2992: tab_employer(lVille) := '' ||
2993: pay_ca_rl2_mag.convert_special_char(substr(l_city,1,30)) || '' || EOL;
2994: ELSE
2995: tab_employer(lVille) := NULL;
2996: END IF;
2997: hr_utility.trace('tab_employer(lVille) = ' || tab_employer(lVille));

Line 3004: pay_ca_rl2_mag.convert_special_char(SUBSTR(hr_general.decode_lookup( 'CA_PROVINCE',

3000:
3001: IF ( l_province IS NOT NULL AND
3002: l_province <> ' ' ) THEN
3003: tab_employer(lProvince) := '' ||
3004: pay_ca_rl2_mag.convert_special_char(SUBSTR(hr_general.decode_lookup( 'CA_PROVINCE',
3005: l_province),1,20)) || '' || EOL;
3006: ELSE
3007: tab_employer(lProvince) := NULL;
3008: END IF;

Line 3016: pay_ca_rl2_mag.convert_special_char(substr(l_postal_code,1,6)) || '' || EOL;

3012:
3013: IF ( l_postal_code IS NOT NULL AND
3014: l_postal_code <> ' ' ) THEN
3015: tab_employer(lCodePostal) := '' ||
3016: pay_ca_rl2_mag.convert_special_char(substr(l_postal_code,1,6)) || '' || EOL;
3017: ELSE
3018: tab_employer(lCodePostal) := NULL;
3019: END IF;
3020: hr_utility.trace('tab_employer(lCodePostal) = ' ||