DBA Data[Home] [Help]

APPS.JA_TW_SH_GUI_UTILS dependencies on STANDARD

Line 474: arp_standard.debug('-- Found exception in ja_tw_sh_gui_utils.val_src_type_rel.');

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';

Line 475: arp_standard.debug('-- Cannot insert the error record into ra_interface_errors.');

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;

Line 484: arp_standard.debug('-- Found exception in ja_tw_sh_gui_utils.val_src_type_rel.');

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(

Line 544: arp_standard.debug('-- Found exception in ja_tw_sh_gui_utils.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.');

Line 545: arp_standard.debug('-- Cannot insert the error record into ra_interface_errors.');

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);

Line 548: arp_standard.debug('-- Found exception in ja_tw_sh_gui_utils.val_trx_num.');

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:

Line 549: arp_standard.debug('-- ' || SQLERRM);

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: --

Line 607: arp_standard.debug('-- Found exception in ja_tw_sh_gui_utils.val_trx_date.');

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);

Line 608: arp_standard.debug('-- '|| l_message_text);

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;

Line 610: arp_standard.debug('-- Found exception in ja_tw_sh_gui_utils.val_trx_date.');

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

Line 611: arp_standard.debug('-- '|| SQLERRM);

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);

Line 644: arp_standard.debug('-- Found exception in ja_tw_sh_gui_utils.val_trx_date.');

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

Line 645: arp_standard.debug('-- Cannot insert the error record into ra_interface_errors.');

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. ');

Line 646: arp_standard.debug('-- '|| SQLERRM);

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);

Line 649: 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);
651: RETURN 'FATAL';
652: END val_trx_date;
653:

Line 650: arp_standard.debug('-- '|| SQLERRM);

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: --

Line 737: arp_standard.debug('-- Found exception in ja_tw_sh_gui_utils.val_mixed_tax_codes.');

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

Line 738: arp_standard.debug('-- Cannot insert the error record into ra_interface_errors.');

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.');

Line 739: arp_standard.debug('-- '|| SQLERRM);

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);

Line 742: 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);
744: RETURN 'FATAL';
745: END;
746:

Line 743: arp_standard.debug('-- '|| SQLERRM);

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: --

Line 827: arp_standard.debug('-- Found exception in ja_tw_sh_gui_utils.copy_gui_type.');

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;

Line 828: arp_standard.debug('-- '|| SQLERRM);

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: