64: , trx_line_rec.customer_trx_id
65: , trx_line_rec.cust_trx_type_id
66: , trx_line_rec.trx_date)
67: THEN
68: arp_standard.debug('-- ja_tw_ar_auto_invoice.'
69: ||'val_interface_lines routine failed');
70: l_return_code := 0;
71: END IF;
72: END LOOP;
70: l_return_code := 0;
71: END IF;
72: END LOOP;
73:
74: arp_standard.debug('Return value from ja_tw_ar_auto_invoice.'
75: ||'validate_gdff() = '||TO_CHAR(l_return_code));
76:
77: RETURN l_return_code;
78:
78:
79: EXCEPTION
80: WHEN OTHERS THEN
81:
82: arp_standard.debug('-- Return From Exception when others');
83: arp_standard.debug('-- Return Code: 0');
84: arp_standard.debug('ja_tw_ar_auto_invoice.validate_gdff()-');
85:
86: RETURN 0;
79: EXCEPTION
80: WHEN OTHERS THEN
81:
82: arp_standard.debug('-- Return From Exception when others');
83: arp_standard.debug('-- Return Code: 0');
84: arp_standard.debug('ja_tw_ar_auto_invoice.validate_gdff()-');
85:
86: RETURN 0;
87:
80: WHEN OTHERS THEN
81:
82: arp_standard.debug('-- Return From Exception when others');
83: arp_standard.debug('-- Return Code: 0');
84: arp_standard.debug('ja_tw_ar_auto_invoice.validate_gdff()-');
85:
86: RETURN 0;
87:
88: END validate_gdff;
319: RETURN TRUE;
320: WHEN auto_trx_num_no THEN
321: RETURN TRUE;
322: WHEN OTHERS THEN
323: arp_standard.debug('-- Found an exception at ' ||l_debug_loc||'.');
324: arp_standard.debug('-- ' ||SQLERRM);
325: RETURN FALSE;
326: END;
327:
320: WHEN auto_trx_num_no THEN
321: RETURN TRUE;
322: WHEN OTHERS THEN
323: arp_standard.debug('-- Found an exception at ' ||l_debug_loc||'.');
324: arp_standard.debug('-- ' ||SQLERRM);
325: RETURN FALSE;
326: END;
327:
328: END ja_tw_ar_auto_invoice;