414: OR TRANSLATE(l_trans_no,'M0123456789','M9999999999') <> 'MM999999' THEN
415: hr_utility.trace('Incorrect Transmitter No format');
416: hr_utility.set_message(801,'PAY_74155_INCORRECT_TRANSMT_NO');
417: hr_utility.set_message_token('GRE_NAME',l_trans_name);
418: pay_core_utils.push_message(801,'PAY_74155_INCORRECT_TRANSMT_NO','P');
419: pay_core_utils.push_token('GRE_NAME',l_trans_name);
420: hr_utility.raise_error;
421: RETURN '1';
422: END IF;
415: hr_utility.trace('Incorrect Transmitter No format');
416: hr_utility.set_message(801,'PAY_74155_INCORRECT_TRANSMT_NO');
417: hr_utility.set_message_token('GRE_NAME',l_trans_name);
418: pay_core_utils.push_message(801,'PAY_74155_INCORRECT_TRANSMT_NO','P');
419: pay_core_utils.push_token('GRE_NAME',l_trans_name);
420: hr_utility.raise_error;
421: RETURN '1';
422: END IF;
423:
428: l_lang IS NULL THEN
429: hr_utility.trace('Technical contact details missing');
430: hr_utility.set_message(801,'PAY_74158_INCORRECT_TCHN_INFO');
431: hr_utility.set_message_token('GRE_NAME',l_trans_name);
432: pay_core_utils.push_message(801,'PAY_74158_INCORRECT_TCHN_INFO','P');
433: pay_core_utils.push_token('GRE_NAME',l_trans_name);
434: hr_utility.raise_error;
435: RETURN '1';
436: END IF;
429: hr_utility.trace('Technical contact details missing');
430: hr_utility.set_message(801,'PAY_74158_INCORRECT_TCHN_INFO');
431: hr_utility.set_message_token('GRE_NAME',l_trans_name);
432: pay_core_utils.push_message(801,'PAY_74158_INCORRECT_TCHN_INFO','P');
433: pay_core_utils.push_token('GRE_NAME',l_trans_name);
434: hr_utility.raise_error;
435: RETURN '1';
436: END IF;
437:
478: OR TRANSLATE(l_bus_no,'0123456789RP','9999999999RP') <> '999999999RP9999' THEN
479: hr_utility.trace('No Business Number Entereed ');
480: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
481: hr_utility.set_message_token('GRE_NAME',l_gre_name);
482: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
483: pay_core_utils.push_token('GRE_NAME',l_gre_name);
484: hr_utility.raise_error;
485: RETURN '1';
486: END IF;
479: hr_utility.trace('No Business Number Entereed ');
480: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
481: hr_utility.set_message_token('GRE_NAME',l_gre_name);
482: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
483: pay_core_utils.push_token('GRE_NAME',l_gre_name);
484: hr_utility.raise_error;
485: RETURN '1';
486: END IF;
487:
491: l_acc_info_flag = 'N' THEN
492: hr_utility.trace('No Accounting Contact info present');
493: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
494: hr_utility.set_message_token('GRE_NAME',l_gre_name);
495: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
496: pay_core_utils.push_token('GRE_NAME',l_gre_name);
497: hr_utility.raise_error;
498: RETURN '1';
499: END IF;
492: hr_utility.trace('No Accounting Contact info present');
493: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
494: hr_utility.set_message_token('GRE_NAME',l_gre_name);
495: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
496: pay_core_utils.push_token('GRE_NAME',l_gre_name);
497: hr_utility.raise_error;
498: RETURN '1';
499: END IF;
500:
504: OR TRANSLATE(l_trans_bus_no,'0123456789RP','9999999999RP') <> '999999999RP9999' THEN
505: hr_utility.trace('No Business Number Entereed ');
506: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
507: hr_utility.set_message_token('GRE_NAME',l_trans_name);
508: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
509: pay_core_utils.push_token('GRE_NAME',l_trans_name);
510: hr_utility.raise_error;
511: RETURN '1';
512: END IF;
505: hr_utility.trace('No Business Number Entereed ');
506: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
507: hr_utility.set_message_token('GRE_NAME',l_trans_name);
508: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
509: pay_core_utils.push_token('GRE_NAME',l_trans_name);
510: hr_utility.raise_error;
511: RETURN '1';
512: END IF;
513:
514: IF l_acc_info_flag = 'N' THEN
515: hr_utility.trace('No Accounting Contact info present');
516: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
517: hr_utility.set_message_token('GRE_NAME',l_trans_name);
518: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
519: pay_core_utils.push_token('GRE_NAME',l_trans_name);
520: hr_utility.raise_error;
521: RETURN '1';
522: END IF;
515: hr_utility.trace('No Accounting Contact info present');
516: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
517: hr_utility.set_message_token('GRE_NAME',l_trans_name);
518: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
519: pay_core_utils.push_token('GRE_NAME',l_trans_name);
520: hr_utility.raise_error;
521: RETURN '1';
522: END IF;
523: END IF;