145: EXCEPTION
146: WHEN INVALID_NUMBER THEN
147: hr_utility.set_message(800,'PAY_CA_RL1_INVALID_TRANSMITTER');
148: hr_utility.set_message_token('PRE_NAME',l_transmitter_name);
149: pay_core_utils.push_message(800,'PAY_CA_RL1_INVALID_TRANSMITTER','P');
150: pay_core_utils.push_token('PRE_NAME',l_transmitter_name);
151: hr_utility.raise_error;
152: END;
153:
146: WHEN INVALID_NUMBER THEN
147: hr_utility.set_message(800,'PAY_CA_RL1_INVALID_TRANSMITTER');
148: hr_utility.set_message_token('PRE_NAME',l_transmitter_name);
149: pay_core_utils.push_message(800,'PAY_CA_RL1_INVALID_TRANSMITTER','P');
150: pay_core_utils.push_token('PRE_NAME',l_transmitter_name);
151: hr_utility.raise_error;
152: END;
153:
154: l_type_of_package := pay_ca_rl2_mag.get_transmitter_item(p_bg_id,
157:
158: hr_utility.trace('l_type_of_package = ' || l_type_of_package);
159:
160: IF l_type_of_package IS NULL THEN
161: pay_core_utils.push_message(800,'PAY_CA_RL1_MISSING_TYPE_OF_PKG','P');
162: hr_utility.raise_error;
163: END IF;
164:
165: l_source_of_slips := pay_ca_rl2_mag.get_transmitter_item(p_bg_id,
167: 'CAEOY_RL2_SOURCE_OF_SLIPS');
168: hr_utility.trace('l_source_of_slips = ' || l_source_of_slips);
169:
170: IF l_source_of_slips IS NULL THEN
171: pay_core_utils.push_message(800,'PAY_CA_RL1_MISSING_RLSLIP_SRC','P');
172: hr_utility.raise_error;
173: END IF;
174:
175: l_address_line1 := pay_ca_rl2_mag.get_transmitter_item(p_bg_id,
177: 'CAEOY_RL2_TRANSMITTER_ADDRESS_LINE1');
178: hr_utility.trace('l_address_line1 = ' || l_address_line1);
179:
180: IF l_address_line1 IS NULL THEN
181: pay_core_utils.push_message(800,'PAY_CA_RL1_MISSING_TRNMTR_ADDR','P');
182: hr_utility.raise_error;
183: END IF;
184:
185: END;
397: /* Fix for Bug# 4038551 */
398: if (l_file_no = '0000' and l_quebec_no = '0000000000') or
399: length(l_file_no) < 4
400: then
401: pay_core_utils.push_message(801,'PAY_74156_INCORRECT_QIN_INFO','P');
402: pay_core_utils.push_token('PRE_NAME',l_emplyer_name);
403: hr_utility.raise_error;
404: end if;
405:
398: if (l_file_no = '0000' and l_quebec_no = '0000000000') or
399: length(l_file_no) < 4
400: then
401: pay_core_utils.push_message(801,'PAY_74156_INCORRECT_QIN_INFO','P');
402: pay_core_utils.push_token('PRE_NAME',l_emplyer_name);
403: hr_utility.raise_error;
404: end if;
405:
406:
411: l_payroll_act,
412: 'CAEOY_RL2_EMPLOYER_ADDRESS_LINE1');
413: if l_addr_line = ' '
414: then
415: pay_core_utils.push_message(800,'PAY_CA_RL2_MISSING_ADDRESS','P');
416: hr_utility.raise_error;
417: end if;
418: hr_utility.trace('First 10 digits of the QIN: '||l_quebec_no);
419: l_return := validate_quebec_number(l_quebec_no,l_emplyer_name);
3375:
3376: if l_chk_digit <> l_act_chk_number then
3377: hr_utility.set_message(801,'PAY_74156_INCORRECT_QIN_INFO');
3378: hr_utility.set_message_token('PRE_NAME',p_qin_name);
3379: pay_core_utils.push_message(801,'PAY_74156_INCORRECT_QIN_INFO','P');
3380: pay_core_utils.push_token('PRE_NAME',p_qin_name);
3381: hr_utility.raise_error;
3382: end if;
3383: else
3376: if l_chk_digit <> l_act_chk_number then
3377: hr_utility.set_message(801,'PAY_74156_INCORRECT_QIN_INFO');
3378: hr_utility.set_message_token('PRE_NAME',p_qin_name);
3379: pay_core_utils.push_message(801,'PAY_74156_INCORRECT_QIN_INFO','P');
3380: pay_core_utils.push_token('PRE_NAME',p_qin_name);
3381: hr_utility.raise_error;
3382: end if;
3383: else
3384:
3383: else
3384:
3385: hr_utility.set_message(801,'PAY_74156_INCORRECT_QIN_INFO');
3386: hr_utility.set_message_token('PRE_NAME',p_qin_name);
3387: pay_core_utils.push_message(801,'PAY_74156_INCORRECT_QIN_INFO','P');
3388: pay_core_utils.push_token('PRE_NAME',p_qin_name);
3389: hr_utility.raise_error;
3390:
3391: end if;
3384:
3385: hr_utility.set_message(801,'PAY_74156_INCORRECT_QIN_INFO');
3386: hr_utility.set_message_token('PRE_NAME',p_qin_name);
3387: pay_core_utils.push_message(801,'PAY_74156_INCORRECT_QIN_INFO','P');
3388: pay_core_utils.push_token('PRE_NAME',p_qin_name);
3389: hr_utility.raise_error;
3390:
3391: end if;
3392: