339: OR TRANSLATE(l_trans_no,'M0123456789','M9999999999') <> 'MM999999' THEN
340: hr_utility.trace('Incorrect Transmitter No format');
341: hr_utility.set_message(801,'PAY_74155_INCORRECT_TRANSMT_NO');
342: hr_utility.set_message_token('GRE_NAME',l_trans_name);
343: pay_core_utils.push_message(801,'PAY_74155_INCORRECT_TRANSMT_NO','P');
344: pay_core_utils.push_token('GRE_NAME',l_trans_name);
345: hr_utility.raise_error;
346: RETURN '1';
347: END IF;
340: hr_utility.trace('Incorrect Transmitter No format');
341: hr_utility.set_message(801,'PAY_74155_INCORRECT_TRANSMT_NO');
342: hr_utility.set_message_token('GRE_NAME',l_trans_name);
343: pay_core_utils.push_message(801,'PAY_74155_INCORRECT_TRANSMT_NO','P');
344: pay_core_utils.push_token('GRE_NAME',l_trans_name);
345: hr_utility.raise_error;
346: RETURN '1';
347: END IF;
348:
353: l_lang IS NULL THEN
354: hr_utility.trace('Technical contact details missing');
355: hr_utility.set_message(801,'PAY_74158_INCORRECT_TCHN_INFO');
356: hr_utility.set_message_token('GRE_NAME',l_trans_name);
357: pay_core_utils.push_message(801,'PAY_74158_INCORRECT_TCHN_INFO','P');
358: pay_core_utils.push_token('GRE_NAME',l_trans_name);
359: hr_utility.raise_error;
360: RETURN '1';
361: END IF;
354: hr_utility.trace('Technical contact details missing');
355: hr_utility.set_message(801,'PAY_74158_INCORRECT_TCHN_INFO');
356: hr_utility.set_message_token('GRE_NAME',l_trans_name);
357: pay_core_utils.push_message(801,'PAY_74158_INCORRECT_TCHN_INFO','P');
358: pay_core_utils.push_token('GRE_NAME',l_trans_name);
359: hr_utility.raise_error;
360: RETURN '1';
361: END IF;
362:
403: OR TRANSLATE(l_bus_no,'0123456789RP','9999999999RP') <> '999999999RP9999' THEN
404: hr_utility.trace('No Business Number Entereed ');
405: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
406: hr_utility.set_message_token('GRE_NAME',l_gre_name);
407: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
408: pay_core_utils.push_token('GRE_NAME',l_gre_name);
409: hr_utility.raise_error;
410: RETURN '1';
411: END IF;
404: hr_utility.trace('No Business Number Entereed ');
405: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
406: hr_utility.set_message_token('GRE_NAME',l_gre_name);
407: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
408: pay_core_utils.push_token('GRE_NAME',l_gre_name);
409: hr_utility.raise_error;
410: RETURN '1';
411: END IF;
412:
416: l_acc_info_flag = 'N' THEN
417: hr_utility.trace('No Accounting Contact info present');
418: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
419: hr_utility.set_message_token('GRE_NAME',l_gre_name);
420: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
421: pay_core_utils.push_token('GRE_NAME',l_gre_name);
422: hr_utility.raise_error;
423: RETURN '1';
424: END IF;
417: hr_utility.trace('No Accounting Contact info present');
418: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
419: hr_utility.set_message_token('GRE_NAME',l_gre_name);
420: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
421: pay_core_utils.push_token('GRE_NAME',l_gre_name);
422: hr_utility.raise_error;
423: RETURN '1';
424: END IF;
425:
429: OR TRANSLATE(l_trans_bus_no,'0123456789RP','9999999999RP') <> '999999999RP9999' THEN
430: hr_utility.trace('No Business Number Entereed ');
431: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
432: hr_utility.set_message_token('GRE_NAME',l_trans_name);
433: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
434: pay_core_utils.push_token('GRE_NAME',l_trans_name);
435: hr_utility.raise_error;
436: RETURN '1';
437: END IF;
430: hr_utility.trace('No Business Number Entereed ');
431: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
432: hr_utility.set_message_token('GRE_NAME',l_trans_name);
433: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
434: pay_core_utils.push_token('GRE_NAME',l_trans_name);
435: hr_utility.raise_error;
436: RETURN '1';
437: END IF;
438:
439: IF l_acc_info_flag = 'N' THEN
440: hr_utility.trace('No Accounting Contact info present');
441: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
442: hr_utility.set_message_token('GRE_NAME',l_trans_name);
443: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
444: pay_core_utils.push_token('GRE_NAME',l_trans_name);
445: hr_utility.raise_error;
446: RETURN '1';
447: END IF;
440: hr_utility.trace('No Accounting Contact info present');
441: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
442: hr_utility.set_message_token('GRE_NAME',l_trans_name);
443: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
444: pay_core_utils.push_token('GRE_NAME',l_trans_name);
445: hr_utility.raise_error;
446: RETURN '1';
447: END IF;
448: END IF;
842: hr_utility.set_location('Error in the following fields: ' || l_field_name,20);
843: hr_utility.trace('Technical contact details missing');
844: hr_utility.set_message(801,'PAY_74158_INCORRECT_TCHN_INFO');
845: hr_utility.set_message_token('GRE_NAME',l_return);
846: pay_core_utils.push_message(801,'PAY_74158_INCORRECT_TCHN_INFO','P');
847: pay_core_utils.push_token('GRE_NAME',l_return);
848: hr_utility.raise_error;
849: END IF;
850: ----
843: hr_utility.trace('Technical contact details missing');
844: hr_utility.set_message(801,'PAY_74158_INCORRECT_TCHN_INFO');
845: hr_utility.set_message_token('GRE_NAME',l_return);
846: pay_core_utils.push_message(801,'PAY_74158_INCORRECT_TCHN_INFO','P');
847: pay_core_utils.push_token('GRE_NAME',l_return);
848: hr_utility.raise_error;
849: END IF;
850: ----
851: l_final_xml := '