470: l_interface_line_id
471: , l_message_text
472: , l_invalid_value)
473: THEN
474: arp_standard.debug('-- Found exception in ja_tw_sh_gui_utils.val_src_type_rel.');
475: arp_standard.debug('-- Cannot insert the error record into ra_interface_errors.');
476: RETURN 'FATAL';
477: ELSE
478: RETURN 'FAIL';
471: , l_message_text
472: , l_invalid_value)
473: THEN
474: arp_standard.debug('-- Found exception in ja_tw_sh_gui_utils.val_src_type_rel.');
475: arp_standard.debug('-- Cannot insert the error record into ra_interface_errors.');
476: RETURN 'FATAL';
477: ELSE
478: RETURN 'FAIL';
479: END IF;
480: ELSIF l_created_from IN ('ARXTWMAI','ARXREC') THEN --bug7133650
481: RETURN 'FAIL';
482: END IF;
483: WHEN OTHERS THEN
484: arp_standard.debug('-- Found exception in ja_tw_sh_gui_utils.val_src_type_rel.');
485: RETURN 'FATAL';
486: END val_src_type_rel;
487:
488: FUNCTION val_trx_num(
540: RETURN 'SUCCESS';
541:
542: EXCEPTION
543: WHEN put_error_mesg THEN
544: arp_standard.debug('-- Found exception in ja_tw_sh_gui_utils.val_trx_num.');
545: arp_standard.debug('-- Cannot insert the error record into ra_interface_errors.');
546: RETURN 'FATAL';
547: WHEN OTHERS THEN
548: arp_standard.debug('-- Found exception in ja_tw_sh_gui_utils.val_trx_num.');
541:
542: EXCEPTION
543: WHEN put_error_mesg THEN
544: arp_standard.debug('-- Found exception in ja_tw_sh_gui_utils.val_trx_num.');
545: arp_standard.debug('-- Cannot insert the error record into ra_interface_errors.');
546: RETURN 'FATAL';
547: WHEN OTHERS THEN
548: arp_standard.debug('-- Found exception in ja_tw_sh_gui_utils.val_trx_num.');
549: arp_standard.debug('-- ' || SQLERRM);
544: arp_standard.debug('-- Found exception in ja_tw_sh_gui_utils.val_trx_num.');
545: arp_standard.debug('-- Cannot insert the error record into ra_interface_errors.');
546: RETURN 'FATAL';
547: WHEN OTHERS THEN
548: arp_standard.debug('-- Found exception in ja_tw_sh_gui_utils.val_trx_num.');
549: arp_standard.debug('-- ' || SQLERRM);
550: RETURN 'FATAL';
551: END;
552:
545: arp_standard.debug('-- Cannot insert the error record into ra_interface_errors.');
546: RETURN 'FATAL';
547: WHEN OTHERS THEN
548: arp_standard.debug('-- Found exception in ja_tw_sh_gui_utils.val_trx_num.');
549: arp_standard.debug('-- ' || SQLERRM);
550: RETURN 'FATAL';
551: END;
552:
553: --
603: IF l_created_from = 'RAXTRX' THEN
604: IF SQLCODE = -54 THEN
605: fnd_message.set_name('JA','JA_TW_AR_LAST_ISSD_DT_LOCKED');
606: l_message_text := fnd_message.get;
607: arp_standard.debug('-- Found exception in ja_tw_sh_gui_utils.val_trx_date.');
608: arp_standard.debug('-- '|| l_message_text);
609: ELSE
610: arp_standard.debug('-- Found exception in ja_tw_sh_gui_utils.val_trx_date.');
611: arp_standard.debug('-- '|| SQLERRM);
604: IF SQLCODE = -54 THEN
605: fnd_message.set_name('JA','JA_TW_AR_LAST_ISSD_DT_LOCKED');
606: l_message_text := fnd_message.get;
607: arp_standard.debug('-- Found exception in ja_tw_sh_gui_utils.val_trx_date.');
608: arp_standard.debug('-- '|| l_message_text);
609: ELSE
610: arp_standard.debug('-- Found exception in ja_tw_sh_gui_utils.val_trx_date.');
611: arp_standard.debug('-- '|| SQLERRM);
612: END IF;
606: l_message_text := fnd_message.get;
607: arp_standard.debug('-- Found exception in ja_tw_sh_gui_utils.val_trx_date.');
608: arp_standard.debug('-- '|| l_message_text);
609: ELSE
610: arp_standard.debug('-- Found exception in ja_tw_sh_gui_utils.val_trx_date.');
611: arp_standard.debug('-- '|| SQLERRM);
612: END IF;
613: RETURN 'FATAL';
614: ELSIF l_created_from IN ('ARXTWMAI','ARXREC') THEN --bug7133650
607: arp_standard.debug('-- Found exception in ja_tw_sh_gui_utils.val_trx_date.');
608: arp_standard.debug('-- '|| l_message_text);
609: ELSE
610: arp_standard.debug('-- Found exception in ja_tw_sh_gui_utils.val_trx_date.');
611: arp_standard.debug('-- '|| SQLERRM);
612: END IF;
613: RETURN 'FATAL';
614: ELSIF l_created_from IN ('ARXTWMAI','ARXREC') THEN --bug7133650
615: RETURN TO_CHAR(SQLCODE);
640: RETURN 'SUCCESS';
641:
642: EXCEPTION
643: WHEN put_error_mesg THEN
644: arp_standard.debug('-- Found exception in ja_tw_sh_gui_utils.val_trx_date.');
645: arp_standard.debug('-- Cannot insert the error record into ra_interface_errors.');
646: arp_standard.debug('-- '|| SQLERRM);
647: RETURN 'FATAL';
648: WHEN OTHERS THEN
641:
642: EXCEPTION
643: WHEN put_error_mesg THEN
644: arp_standard.debug('-- Found exception in ja_tw_sh_gui_utils.val_trx_date.');
645: arp_standard.debug('-- Cannot insert the error record into ra_interface_errors.');
646: arp_standard.debug('-- '|| SQLERRM);
647: RETURN 'FATAL';
648: WHEN OTHERS THEN
649: arp_standard.debug('-- Found exception in ja_tw_sh_gui_utils.val_trx_date. ');
642: EXCEPTION
643: WHEN put_error_mesg THEN
644: arp_standard.debug('-- Found exception in ja_tw_sh_gui_utils.val_trx_date.');
645: arp_standard.debug('-- Cannot insert the error record into ra_interface_errors.');
646: arp_standard.debug('-- '|| SQLERRM);
647: RETURN 'FATAL';
648: WHEN OTHERS THEN
649: arp_standard.debug('-- Found exception in ja_tw_sh_gui_utils.val_trx_date. ');
650: arp_standard.debug('-- '|| SQLERRM);
645: arp_standard.debug('-- Cannot insert the error record into ra_interface_errors.');
646: arp_standard.debug('-- '|| SQLERRM);
647: RETURN 'FATAL';
648: WHEN OTHERS THEN
649: arp_standard.debug('-- Found exception in ja_tw_sh_gui_utils.val_trx_date. ');
650: arp_standard.debug('-- '|| SQLERRM);
651: RETURN 'FATAL';
652: END val_trx_date;
653:
646: arp_standard.debug('-- '|| SQLERRM);
647: RETURN 'FATAL';
648: WHEN OTHERS THEN
649: arp_standard.debug('-- Found exception in ja_tw_sh_gui_utils.val_trx_date. ');
650: arp_standard.debug('-- '|| SQLERRM);
651: RETURN 'FATAL';
652: END val_trx_date;
653:
654: --
733: RETURN 'SUCCESS';
734: END IF;
735: EXCEPTION
736: WHEN put_error_mesg THEN
737: arp_standard.debug('-- Found exception in ja_tw_sh_gui_utils.val_mixed_tax_codes.');
738: arp_standard.debug('-- Cannot insert the error record into ra_interface_errors.');
739: arp_standard.debug('-- '|| SQLERRM);
740: RETURN 'FATAL';
741: WHEN OTHERS THEN
734: END IF;
735: EXCEPTION
736: WHEN put_error_mesg THEN
737: arp_standard.debug('-- Found exception in ja_tw_sh_gui_utils.val_mixed_tax_codes.');
738: arp_standard.debug('-- Cannot insert the error record into ra_interface_errors.');
739: arp_standard.debug('-- '|| SQLERRM);
740: RETURN 'FATAL';
741: WHEN OTHERS THEN
742: arp_standard.debug('-- Found exception in ja_tw_sh_gui_utils.val_mixed_tax_codes.');
735: EXCEPTION
736: WHEN put_error_mesg THEN
737: arp_standard.debug('-- Found exception in ja_tw_sh_gui_utils.val_mixed_tax_codes.');
738: arp_standard.debug('-- Cannot insert the error record into ra_interface_errors.');
739: arp_standard.debug('-- '|| SQLERRM);
740: RETURN 'FATAL';
741: WHEN OTHERS THEN
742: arp_standard.debug('-- Found exception in ja_tw_sh_gui_utils.val_mixed_tax_codes.');
743: arp_standard.debug('-- '|| SQLERRM);
738: arp_standard.debug('-- Cannot insert the error record into ra_interface_errors.');
739: arp_standard.debug('-- '|| SQLERRM);
740: RETURN 'FATAL';
741: WHEN OTHERS THEN
742: arp_standard.debug('-- Found exception in ja_tw_sh_gui_utils.val_mixed_tax_codes.');
743: arp_standard.debug('-- '|| SQLERRM);
744: RETURN 'FATAL';
745: END;
746:
739: arp_standard.debug('-- '|| SQLERRM);
740: RETURN 'FATAL';
741: WHEN OTHERS THEN
742: arp_standard.debug('-- Found exception in ja_tw_sh_gui_utils.val_mixed_tax_codes.');
743: arp_standard.debug('-- '|| SQLERRM);
744: RETURN 'FATAL';
745: END;
746:
747: --
823: RETURN TRUE;
824: EXCEPTION
825: WHEN OTHERS THEN
826: IF l_created_from = 'RAXTRX' THEN
827: arp_standard.debug('-- Found exception in ja_tw_sh_gui_utils.copy_gui_type.');
828: arp_standard.debug('-- '|| SQLERRM);
829: END IF;
830: RETURN FALSE;
831: END;
824: EXCEPTION
825: WHEN OTHERS THEN
826: IF l_created_from = 'RAXTRX' THEN
827: arp_standard.debug('-- Found exception in ja_tw_sh_gui_utils.copy_gui_type.');
828: arp_standard.debug('-- '|| SQLERRM);
829: END IF;
830: RETURN FALSE;
831: END;
832: