DBA Data[Home] [Help]

APPS.JA_ZZ_VALIDATE_INVOICE_GDF dependencies on AR_INVOICE_UTILS

Line 437: ar_invoice_utils.debug('-- Found exception in ja_tw_invoice_create.val_src_type_rel.');

433: , p_trx_line_id
434: , l_invalid_value)
435: THEN
436: IF pg_debug = 'Y' THEN
437: ar_invoice_utils.debug('-- Found exception in ja_tw_invoice_create.val_src_type_rel.');
438: ar_invoice_utils.debug('-- Cannot insert the error record into ar_trx_errors.');
439: END IF;
440: RETURN 'FATAL';
441: ELSE

Line 438: ar_invoice_utils.debug('-- Cannot insert the error record into ar_trx_errors.');

434: , l_invalid_value)
435: THEN
436: IF pg_debug = 'Y' THEN
437: ar_invoice_utils.debug('-- Found exception in ja_tw_invoice_create.val_src_type_rel.');
438: ar_invoice_utils.debug('-- Cannot insert the error record into ar_trx_errors.');
439: END IF;
440: RETURN 'FATAL';
441: ELSE
442: RETURN 'FAIL';

Line 449: ar_invoice_utils.debug('-- Found exception in ja_tw_invoice_create.val_src_type_rel.');

445: RETURN 'FAIL';
446: END IF;
447: WHEN OTHERS THEN
448: IF pg_debug = 'Y' THEN
449: ar_invoice_utils.debug('-- Found exception in ja_tw_invoice_create.val_src_type_rel.');
450: END IF;
451: RETURN 'FATAL';
452: END val_src_type_rel;
453:

Line 518: ar_invoice_utils.debug('-- Found exception in ja_tw_invoice_create.val_trx_num.');

514:
515: EXCEPTION
516: WHEN put_error_mesg THEN
517: IF pg_debug = 'Y' THEN
518: ar_invoice_utils.debug('-- Found exception in ja_tw_invoice_create.val_trx_num.');
519: ar_invoice_utils.debug('-- Cannot insert the error record into ar_trx_errors.');
520: END IF;
521: RETURN 'FATAL';
522: WHEN OTHERS THEN

Line 519: ar_invoice_utils.debug('-- Cannot insert the error record into ar_trx_errors.');

515: EXCEPTION
516: WHEN put_error_mesg THEN
517: IF pg_debug = 'Y' THEN
518: ar_invoice_utils.debug('-- Found exception in ja_tw_invoice_create.val_trx_num.');
519: ar_invoice_utils.debug('-- Cannot insert the error record into ar_trx_errors.');
520: END IF;
521: RETURN 'FATAL';
522: WHEN OTHERS THEN
523: IF pg_debug = 'Y' THEN

Line 524: ar_invoice_utils.debug('-- Found exception in ja_tw_invoice_create.val_trx_num.');

520: END IF;
521: RETURN 'FATAL';
522: WHEN OTHERS THEN
523: IF pg_debug = 'Y' THEN
524: ar_invoice_utils.debug('-- Found exception in ja_tw_invoice_create.val_trx_num.');
525: ar_invoice_utils.debug('-- ' || SQLERRM);
526: END IF;
527: RETURN 'FATAL';
528: END;

Line 525: ar_invoice_utils.debug('-- ' || SQLERRM);

521: RETURN 'FATAL';
522: WHEN OTHERS THEN
523: IF pg_debug = 'Y' THEN
524: ar_invoice_utils.debug('-- Found exception in ja_tw_invoice_create.val_trx_num.');
525: ar_invoice_utils.debug('-- ' || SQLERRM);
526: END IF;
527: RETURN 'FATAL';
528: END;
529:

Line 589: ar_invoice_utils.debug('-- Found exception in ja_tw_invoice_create.val_trx_date.');

585: IF SQLCODE = -54 THEN
586: fnd_message.set_name('JA','JA_TW_AR_LAST_ISSD_DT_LOCKED');
587: l_message_text := fnd_message.get;
588: IF pg_debug = 'Y' THEN
589: ar_invoice_utils.debug('-- Found exception in ja_tw_invoice_create.val_trx_date.');
590: ar_invoice_utils.debug('-- '|| l_message_text);
591: END IF;
592: ELSE
593: IF pg_debug = 'Y' THEN

Line 590: ar_invoice_utils.debug('-- '|| l_message_text);

586: fnd_message.set_name('JA','JA_TW_AR_LAST_ISSD_DT_LOCKED');
587: l_message_text := fnd_message.get;
588: IF pg_debug = 'Y' THEN
589: ar_invoice_utils.debug('-- Found exception in ja_tw_invoice_create.val_trx_date.');
590: ar_invoice_utils.debug('-- '|| l_message_text);
591: END IF;
592: ELSE
593: IF pg_debug = 'Y' THEN
594: ar_invoice_utils.debug('-- Found exception in ja_tw_invoice_create.val_trx_date.');

Line 594: ar_invoice_utils.debug('-- Found exception in ja_tw_invoice_create.val_trx_date.');

590: ar_invoice_utils.debug('-- '|| l_message_text);
591: END IF;
592: ELSE
593: IF pg_debug = 'Y' THEN
594: ar_invoice_utils.debug('-- Found exception in ja_tw_invoice_create.val_trx_date.');
595: ar_invoice_utils.debug('-- '|| SQLERRM);
596: END IF;
597: END IF;
598: RETURN 'FATAL';

Line 595: ar_invoice_utils.debug('-- '|| SQLERRM);

591: END IF;
592: ELSE
593: IF pg_debug = 'Y' THEN
594: ar_invoice_utils.debug('-- Found exception in ja_tw_invoice_create.val_trx_date.');
595: ar_invoice_utils.debug('-- '|| SQLERRM);
596: END IF;
597: END IF;
598: RETURN 'FATAL';
599: ELSIF l_created_from = 'ARXTWMAI' THEN

Line 631: ar_invoice_utils.debug('-- Found exception in ja_tw_invoice_create.val_trx_date.');

627:
628: EXCEPTION
629: WHEN put_error_mesg THEN
630: IF pg_debug = 'Y' THEN
631: ar_invoice_utils.debug('-- Found exception in ja_tw_invoice_create.val_trx_date.');
632: ar_invoice_utils.debug('-- Cannot insert the error record into ar_trx_errors.');
633: ar_invoice_utils.debug('-- '|| SQLERRM);
634: END IF;
635: RETURN 'FATAL';

Line 632: ar_invoice_utils.debug('-- Cannot insert the error record into ar_trx_errors.');

628: EXCEPTION
629: WHEN put_error_mesg THEN
630: IF pg_debug = 'Y' THEN
631: ar_invoice_utils.debug('-- Found exception in ja_tw_invoice_create.val_trx_date.');
632: ar_invoice_utils.debug('-- Cannot insert the error record into ar_trx_errors.');
633: ar_invoice_utils.debug('-- '|| SQLERRM);
634: END IF;
635: RETURN 'FATAL';
636: WHEN OTHERS THEN

Line 633: ar_invoice_utils.debug('-- '|| SQLERRM);

629: WHEN put_error_mesg THEN
630: IF pg_debug = 'Y' THEN
631: ar_invoice_utils.debug('-- Found exception in ja_tw_invoice_create.val_trx_date.');
632: ar_invoice_utils.debug('-- Cannot insert the error record into ar_trx_errors.');
633: ar_invoice_utils.debug('-- '|| SQLERRM);
634: END IF;
635: RETURN 'FATAL';
636: WHEN OTHERS THEN
637: IF pg_debug = 'Y' THEN

Line 638: ar_invoice_utils.debug('-- Found exception in ja_tw_invoice_create.val_trx_date. ');

634: END IF;
635: RETURN 'FATAL';
636: WHEN OTHERS THEN
637: IF pg_debug = 'Y' THEN
638: ar_invoice_utils.debug('-- Found exception in ja_tw_invoice_create.val_trx_date. ');
639: ar_invoice_utils.debug('-- '|| SQLERRM);
640: END IF;
641: RETURN 'FATAL';
642: END val_trx_date;

Line 639: ar_invoice_utils.debug('-- '|| SQLERRM);

635: RETURN 'FATAL';
636: WHEN OTHERS THEN
637: IF pg_debug = 'Y' THEN
638: ar_invoice_utils.debug('-- Found exception in ja_tw_invoice_create.val_trx_date. ');
639: ar_invoice_utils.debug('-- '|| SQLERRM);
640: END IF;
641: RETURN 'FATAL';
642: END val_trx_date;
643:

Line 741: ar_invoice_utils.debug('-- Found exception in ja_tw_invoice_create.val_mixed_tax_codes.');

737: END IF;
738: EXCEPTION
739: WHEN put_error_mesg THEN
740: IF pg_debug = 'Y' THEN
741: ar_invoice_utils.debug('-- Found exception in ja_tw_invoice_create.val_mixed_tax_codes.');
742: ar_invoice_utils.debug('-- Cannot insert the error record into ar_trx_errors.');
743: ar_invoice_utils.debug('-- '|| SQLERRM);
744: END IF;
745: RETURN 'FATAL';

Line 742: ar_invoice_utils.debug('-- Cannot insert the error record into ar_trx_errors.');

738: EXCEPTION
739: WHEN put_error_mesg THEN
740: IF pg_debug = 'Y' THEN
741: ar_invoice_utils.debug('-- Found exception in ja_tw_invoice_create.val_mixed_tax_codes.');
742: ar_invoice_utils.debug('-- Cannot insert the error record into ar_trx_errors.');
743: ar_invoice_utils.debug('-- '|| SQLERRM);
744: END IF;
745: RETURN 'FATAL';
746: WHEN OTHERS THEN

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

739: WHEN put_error_mesg THEN
740: IF pg_debug = 'Y' THEN
741: ar_invoice_utils.debug('-- Found exception in ja_tw_invoice_create.val_mixed_tax_codes.');
742: ar_invoice_utils.debug('-- Cannot insert the error record into ar_trx_errors.');
743: ar_invoice_utils.debug('-- '|| SQLERRM);
744: END IF;
745: RETURN 'FATAL';
746: WHEN OTHERS THEN
747: IF pg_debug = 'Y' THEN

Line 748: ar_invoice_utils.debug('-- Found exception in ja_tw_invoice_create.val_mixed_tax_codes.');

744: END IF;
745: RETURN 'FATAL';
746: WHEN OTHERS THEN
747: IF pg_debug = 'Y' THEN
748: ar_invoice_utils.debug('-- Found exception in ja_tw_invoice_create.val_mixed_tax_codes.');
749: ar_invoice_utils.debug('-- '|| SQLERRM);
750: END IF;
751: RETURN 'FATAL';
752: END;

Line 749: ar_invoice_utils.debug('-- '|| SQLERRM);

745: RETURN 'FATAL';
746: WHEN OTHERS THEN
747: IF pg_debug = 'Y' THEN
748: ar_invoice_utils.debug('-- Found exception in ja_tw_invoice_create.val_mixed_tax_codes.');
749: ar_invoice_utils.debug('-- '|| SQLERRM);
750: END IF;
751: RETURN 'FATAL';
752: END;
753:

Line 837: ar_invoice_utils.debug('-- Found exception in ja_tw_invoice_create.copy_gui_type.');

833: EXCEPTION
834: WHEN OTHERS THEN
835: IF l_created_from = 'RAXTRX' THEN
836: IF pg_debug = 'Y' THEN
837: ar_invoice_utils.debug('-- Found exception in ja_tw_invoice_create.copy_gui_type.');
838: ar_invoice_utils.debug('-- '|| SQLERRM);
839: END IF;
840: END IF;
841: RETURN FALSE;

Line 838: ar_invoice_utils.debug('-- '|| SQLERRM);

834: WHEN OTHERS THEN
835: IF l_created_from = 'RAXTRX' THEN
836: IF pg_debug = 'Y' THEN
837: ar_invoice_utils.debug('-- Found exception in ja_tw_invoice_create.copy_gui_type.');
838: ar_invoice_utils.debug('-- '|| SQLERRM);
839: END IF;
840: END IF;
841: RETURN FALSE;
842: END;

Line 890: ar_invoice_utils.debug('-- Found exception in ja_th_invoice_create.' ||

886:
887: EXCEPTION
888: WHEN cannot_insert_error THEN
889: IF pg_debug = 'Y' THEN
890: ar_invoice_utils.debug('-- Found exception in ja_th_invoice_create.' ||
891: p_validation_name);
892: ar_invoice_utils.debug('-- Cannot insert the error record into ' ||
893: 'ar_trx_errors.');
894: END IF;

Line 892: ar_invoice_utils.debug('-- Cannot insert the error record into ' ||

888: WHEN cannot_insert_error THEN
889: IF pg_debug = 'Y' THEN
890: ar_invoice_utils.debug('-- Found exception in ja_th_invoice_create.' ||
891: p_validation_name);
892: ar_invoice_utils.debug('-- Cannot insert the error record into ' ||
893: 'ar_trx_errors.');
894: END IF;
895: return(FALSE);
896:

Line 899: ar_invoice_utils.debug('-- Found exception in ' ||

895: return(FALSE);
896:
897: WHEN others THEN
898: IF pg_debug = 'Y' THEN
899: ar_invoice_utils.debug('-- Found exception in ' ||
900: 'ja_th_invoice_create.insert_interface_errors.');
901: ar_invoice_utils.debug('-- ' || SQLERRM);
902: END IF;
903:

Line 901: ar_invoice_utils.debug('-- ' || SQLERRM);

897: WHEN others THEN
898: IF pg_debug = 'Y' THEN
899: ar_invoice_utils.debug('-- Found exception in ' ||
900: 'ja_th_invoice_create.insert_interface_errors.');
901: ar_invoice_utils.debug('-- ' || SQLERRM);
902: END IF;
903:
904: return(FALSE);
905:

Line 957: ar_invoice_utils.debug('-- Found exception in ' ||

953:
954: WHEN OTHERS THEN
955: IF p_created_from = 'RAXTRX' THEN
956: IF pg_debug = 'Y' THEN
957: ar_invoice_utils.debug('-- Found exception in ' ||
958: 'ja_th_invoice_create.validate_trx_date.');
959: ar_invoice_utils.debug('-- ' || SQLERRM);
960: END IF;
961: return(-1);

Line 959: ar_invoice_utils.debug('-- ' || SQLERRM);

955: IF p_created_from = 'RAXTRX' THEN
956: IF pg_debug = 'Y' THEN
957: ar_invoice_utils.debug('-- Found exception in ' ||
958: 'ja_th_invoice_create.validate_trx_date.');
959: ar_invoice_utils.debug('-- ' || SQLERRM);
960: END IF;
961: return(-1);
962: ELSIF p_created_from = 'ARXTWMAI' THEN
963: return(0);

Line 1038: ar_invoice_utils.debug('-- Found exception in ' ||

1034:
1035: WHEN OTHERS THEN
1036: IF p_created_from = 'RAXTRX' THEN
1037: IF pg_debug = 'Y' THEN
1038: ar_invoice_utils.debug('-- Found exception in ' ||
1039: 'ja_th_invoice_create.validate_tax_code.');
1040: ar_invoice_utils.debug('-- ' || SQLERRM);
1041: END IF;
1042: return(-1);

Line 1040: ar_invoice_utils.debug('-- ' || SQLERRM);

1036: IF p_created_from = 'RAXTRX' THEN
1037: IF pg_debug = 'Y' THEN
1038: ar_invoice_utils.debug('-- Found exception in ' ||
1039: 'ja_th_invoice_create.validate_tax_code.');
1040: ar_invoice_utils.debug('-- ' || SQLERRM);
1041: END IF;
1042: return(-1);
1043: ELSIF p_created_from = 'ARXTWMAI' THEN
1044: return(0);

Line 1127: ar_invoice_utils.debug('-- Found exception in ' ||

1123:
1124: WHEN others THEN
1125: IF p_created_from = 'RAXTRX' THEN
1126: IF pg_debug = 'Y' THEN
1127: ar_invoice_utils.debug('-- Found exception in ' ||
1128: 'ja_th_invoice_create.update_last_issued_date.');
1129: ar_invoice_utils.debug('-- ' || SQLERRM);
1130: END IF;
1131: return(-1);

Line 1129: ar_invoice_utils.debug('-- ' || SQLERRM);

1125: IF p_created_from = 'RAXTRX' THEN
1126: IF pg_debug = 'Y' THEN
1127: ar_invoice_utils.debug('-- Found exception in ' ||
1128: 'ja_th_invoice_create.update_last_issued_date.');
1129: ar_invoice_utils.debug('-- ' || SQLERRM);
1130: END IF;
1131: return(-1);
1132: ELSIF p_created_from = 'ARXTWMAI' THEN
1133: return(0);