166: EXCEPTION
167: WHEN INVALID_NUMBER THEN
168: hr_utility.set_message(800,'PAY_CA_RL1_INVALID_TRANSMITTER');
169: hr_utility.set_message_token('PRE_NAME',l_transmitter_name);
170: pay_core_utils.push_message(800,'PAY_CA_RL1_INVALID_TRANSMITTER','P');
171: pay_core_utils.push_token('PRE_NAME',l_transmitter_name);
172: hr_utility.raise_error;
173: END;
174:
167: WHEN INVALID_NUMBER THEN
168: hr_utility.set_message(800,'PAY_CA_RL1_INVALID_TRANSMITTER');
169: hr_utility.set_message_token('PRE_NAME',l_transmitter_name);
170: pay_core_utils.push_message(800,'PAY_CA_RL1_INVALID_TRANSMITTER','P');
171: pay_core_utils.push_token('PRE_NAME',l_transmitter_name);
172: hr_utility.raise_error;
173: END;
174:
175: l_type_of_package := pay_ca_rl2_can_mag.get_transmitter_item(p_bg_id,
178:
179: hr_utility.trace('l_type_of_package = ' || l_type_of_package);
180:
181: IF l_type_of_package IS NULL THEN
182: pay_core_utils.push_message(800,'PAY_CA_RL1_MISSING_TYPE_OF_PKG','P');
183: hr_utility.raise_error;
184: END IF;
185:
186: l_source_of_slips := pay_ca_rl2_can_mag.get_transmitter_item(p_bg_id,
188: 'CAEOY_RL2_SOURCE_OF_SLIPS');
189: hr_utility.trace('l_source_of_slips = ' || l_source_of_slips);
190:
191: IF l_source_of_slips IS NULL THEN
192: pay_core_utils.push_message(800,'PAY_CA_RL1_MISSING_RLSLIP_SRC','P');
193: hr_utility.raise_error;
194: END IF;
195:
196: l_address_line1 := pay_ca_rl2_can_mag.get_transmitter_item(p_bg_id,
198: 'CAEOY_RL2_TRANSMITTER_ADDRESS_LINE1');
199: hr_utility.trace('l_address_line1 = ' || l_address_line1);
200:
201: IF l_address_line1 IS NULL THEN
202: pay_core_utils.push_message(800,'PAY_CA_RL1_MISSING_TRNMTR_ADDR','P');
203: hr_utility.raise_error;
204: END IF;
205:
206: END;
479: /* Fix for Bug# 4038551 */
480: if (l_file_no = '0000' and l_quebec_no = '0000000000') or
481: length(l_file_no) < 4
482: then
483: pay_core_utils.push_message(801,'PAY_74156_INCORRECT_QIN_INFO','P');
484: pay_core_utils.push_token('PRE_NAME',l_emplyer_name);
485: hr_utility.raise_error;
486: end if;
487:
480: if (l_file_no = '0000' and l_quebec_no = '0000000000') or
481: length(l_file_no) < 4
482: then
483: pay_core_utils.push_message(801,'PAY_74156_INCORRECT_QIN_INFO','P');
484: pay_core_utils.push_token('PRE_NAME',l_emplyer_name);
485: hr_utility.raise_error;
486: end if;
487:
488:
493: l_payroll_act,
494: 'CAEOY_RL2_EMPLOYER_ADDRESS_LINE1');
495: if l_addr_line = ' '
496: then
497: pay_core_utils.push_message(800,'PAY_CA_RL2_MISSING_ADDRESS','P');
498: hr_utility.raise_error;
499: end if;
500: hr_utility.trace('First 10 digits of the QIN: '||l_quebec_no);
501: l_return := validate_quebec_number(l_quebec_no,l_emplyer_name);
2971:
2972: if l_chk_digit <> l_act_chk_number then
2973: hr_utility.set_message(801,'PAY_74156_INCORRECT_QIN_INFO');
2974: hr_utility.set_message_token('PRE_NAME',p_qin_name);
2975: pay_core_utils.push_message(801,'PAY_74156_INCORRECT_QIN_INFO','P');
2976: pay_core_utils.push_token('PRE_NAME',p_qin_name);
2977: hr_utility.raise_error;
2978: end if;
2979: else
2972: if l_chk_digit <> l_act_chk_number then
2973: hr_utility.set_message(801,'PAY_74156_INCORRECT_QIN_INFO');
2974: hr_utility.set_message_token('PRE_NAME',p_qin_name);
2975: pay_core_utils.push_message(801,'PAY_74156_INCORRECT_QIN_INFO','P');
2976: pay_core_utils.push_token('PRE_NAME',p_qin_name);
2977: hr_utility.raise_error;
2978: end if;
2979: else
2980:
2979: else
2980:
2981: hr_utility.set_message(801,'PAY_74156_INCORRECT_QIN_INFO');
2982: hr_utility.set_message_token('PRE_NAME',p_qin_name);
2983: pay_core_utils.push_message(801,'PAY_74156_INCORRECT_QIN_INFO','P');
2984: pay_core_utils.push_token('PRE_NAME',p_qin_name);
2985: hr_utility.raise_error;
2986:
2987: end if;
2980:
2981: hr_utility.set_message(801,'PAY_74156_INCORRECT_QIN_INFO');
2982: hr_utility.set_message_token('PRE_NAME',p_qin_name);
2983: pay_core_utils.push_message(801,'PAY_74156_INCORRECT_QIN_INFO','P');
2984: pay_core_utils.push_token('PRE_NAME',p_qin_name);
2985: hr_utility.raise_error;
2986:
2987: end if;
2988: