240: EXCEPTION
241: WHEN INVALID_NUMBER THEN
242: hr_utility.set_message(800,'PAY_CA_RL1_INVALID_TRANSMITTER');
243: hr_utility.set_message_token('PRE_NAME',l_transmitter_name);
244: pay_core_utils.push_message(800,'PAY_CA_RL1_INVALID_TRANSMITTER','P');
245: pay_core_utils.push_token('PRE_NAME',l_transmitter_name);
246: hr_utility.raise_error;
247: END;
248:
241: WHEN INVALID_NUMBER THEN
242: hr_utility.set_message(800,'PAY_CA_RL1_INVALID_TRANSMITTER');
243: hr_utility.set_message_token('PRE_NAME',l_transmitter_name);
244: pay_core_utils.push_message(800,'PAY_CA_RL1_INVALID_TRANSMITTER','P');
245: pay_core_utils.push_token('PRE_NAME',l_transmitter_name);
246: hr_utility.raise_error;
247: END;
248:
249: hr_utility.trace('l_type_of_package = ' || l_type_of_package);
248:
249: hr_utility.trace('l_type_of_package = ' || l_type_of_package);
250:
251: IF l_type_of_package IS NULL THEN
252: pay_core_utils.push_message(800,'PAY_CA_RL1_MISSING_TYPE_OF_PKG','P');
253: hr_utility.raise_error;
254: END IF;
255:
256: hr_utility.trace('l_source_of_slips = ' || l_source_of_slips);
255:
256: hr_utility.trace('l_source_of_slips = ' || l_source_of_slips);
257:
258: IF l_source_of_slips IS NULL THEN
259: pay_core_utils.push_message(800,'PAY_CA_RL1_MISSING_RLSLIP_SRC','P');
260: hr_utility.raise_error;
261: END IF;
262:
263: hr_utility.trace('l_address_line1 = ' || l_address_line1);
262:
263: hr_utility.trace('l_address_line1 = ' || l_address_line1);
264:
265: IF l_address_line1 IS NULL THEN
266: pay_core_utils.push_message(800,'PAY_CA_RL1_MISSING_TRNMTR_ADDR','P');
267: hr_utility.raise_error;
268: END IF;
269:
270: END;
616: /* Fix for Bug# 4038551 */
617: if (l_file_no = '0000' and l_quebec_no = '0000000000') or
618: length(l_file_no) < 4
619: then
620: pay_core_utils.push_message(801,'PAY_74156_INCORRECT_QIN_INFO','P');
621: pay_core_utils.push_token('PRE_NAME',l_emplyer_name);
622: hr_utility.raise_error;
623: end if;
624:
617: if (l_file_no = '0000' and l_quebec_no = '0000000000') or
618: length(l_file_no) < 4
619: then
620: pay_core_utils.push_message(801,'PAY_74156_INCORRECT_QIN_INFO','P');
621: pay_core_utils.push_token('PRE_NAME',l_emplyer_name);
622: hr_utility.raise_error;
623: end if;
624:
625:
627: mandatory information is missing i.e Address Line 1 */
628:
629: if l_addr_line = ' '
630: then
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);
680: lv_record_name := 'RL2 Amendment Magnetic Media';
681:
682: lv_message := 'Latest amendment details not available for this employee';
683:
684: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','A');
685: pay_core_utils.push_token('record_name',lv_record_name);
686: pay_core_utils.push_token('name_or_number',lv_full_name);
687: pay_core_utils.push_token('description',lv_message);
688:
681:
682: lv_message := 'Latest amendment details not available for this employee';
683:
684: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','A');
685: pay_core_utils.push_token('record_name',lv_record_name);
686: pay_core_utils.push_token('name_or_number',lv_full_name);
687: pay_core_utils.push_token('description',lv_message);
688:
689: end if;
682: lv_message := 'Latest amendment details not available for this employee';
683:
684: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','A');
685: pay_core_utils.push_token('record_name',lv_record_name);
686: pay_core_utils.push_token('name_or_number',lv_full_name);
687: pay_core_utils.push_token('description',lv_message);
688:
689: end if;
690: exit;
683:
684: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','A');
685: pay_core_utils.push_token('record_name',lv_record_name);
686: pay_core_utils.push_token('name_or_number',lv_full_name);
687: pay_core_utils.push_token('description',lv_message);
688:
689: end if;
690: exit;
691: