[Home] [Help]
70: END IF;
71:
72: x_return_status := FND_API.G_RET_STS_SUCCESS;
73:
74: INSERT INTO ar_trx_errors_gt (
75: trx_header_id,
76: error_message,
77: invalid_value)
78: SELECT trx_header_id,
110: END IF;
111:
112: x_return_status := FND_API.G_RET_STS_SUCCESS;
113:
114: INSERT INTO ar_trx_errors_gt (
115: trx_header_id,
116: error_message,
117: invalid_value)
118: SELECT trx_header_id,
146: END IF;
147:
148: x_return_status := FND_API.G_RET_STS_SUCCESS;
149:
150: INSERT INTO ar_trx_errors_gt (
151: trx_header_id,
152: error_message,
153: invalid_value)
154: SELECT trx_header_id,
187: END IF;
188:
189: x_return_status := FND_API.G_RET_STS_SUCCESS;
190:
191: INSERT INTO ar_trx_errors_gt (
192: trx_header_id,
193: error_message,
194: invalid_value)
195: SELECT trx_header_id,
229: END IF;
230:
231: x_return_status := FND_API.G_RET_STS_SUCCESS;
232:
233: INSERT INTO ar_trx_errors_gt (
234: trx_header_id,
235: error_message,
236: invalid_value)
237: SELECT trx_header_id,
272: END IF;
273:
274: x_return_status := FND_API.G_RET_STS_SUCCESS;
275:
276: INSERT INTO ar_trx_errors_gt (
277: trx_header_id,
278: error_message,
279: invalid_value)
280: SELECT trx_header_id,
288: WHERE rm.receipt_method_id = gt.receipt_method_id
289: AND gt.trx_date BETWEEN NVL(rm.start_date, gt.trx_date)
290: AND NVL(rm.end_date, gt.trx_date));
291:
292: INSERT INTO ar_trx_errors_gt (
293: trx_header_id,
294: error_message,
295: invalid_value)
296: SELECT trx_header_id,
301: AND arpt_sql_func_util.check_boe_paymeth(gt.receipt_method_id) = 'Y';
302:
303: /* PAYMENT UPTAKE */
304:
305: INSERT INTO ar_trx_errors_gt (
306: trx_header_id,
307: error_message,
308: invalid_value)
309: SELECT trx_header_id,
318: WHERE rm.receipt_method_id = gt.receipt_method_id
319: AND rm.receipt_class_id = rc.receipt_class_id
320: AND rc.creation_method_code = 'MANUAL' );
321:
322: INSERT INTO ar_trx_errors_gt (
323: trx_header_id,
324: error_message,
325: invalid_value)
326: SELECT trx_header_id,
335: WHERE rm.receipt_method_id = gt.receipt_method_id
336: AND iby.trxn_extension_id= gt.payment_trxn_extension_id
337: AND iby.PAYMENT_CHANNEL_CODE <> rm.payment_channel_code );
338:
339: INSERT INTO ar_trx_errors_gt (
340: trx_header_id,
341: error_message,
342: invalid_value)
343: SELECT trx_header_id,
353: WHERE rm.receipt_method_id = gt.receipt_method_id
354: AND rm.receipt_class_id = rc.receipt_class_id
355: AND rc.creation_method_code = 'AUTOMATIC' );
356:
357: INSERT INTO ar_trx_errors_gt (
358: trx_header_id,
359: error_message,
360: invalid_value)
361: SELECT trx_header_id,
390: END IF;
391:
392: x_return_status := FND_API.G_RET_STS_SUCCESS;
393:
394: INSERT INTO ar_trx_errors_gt (
395: trx_header_id,
396: error_message,
397: invalid_value)
398: SELECT trx_header_id,
449: x_return_status := FND_API.G_RET_STS_SUCCESS;
450: -- Removed the prospect join as per the bug 3310138
451: IF p_trx_system_param_rec.pay_unrelated_invoices_flag = 'Y'
452: THEN
453: INSERT INTO ar_trx_errors_gt (
454: trx_header_id,
455: error_message,
456: invalid_value)
457: SELECT trx_header_id,
465: WHERE cust_acct.cust_account_id = gt.paying_customer_id
466: AND cust_acct.status = 'A' );
467: ELSIF p_trx_system_param_rec.pay_unrelated_invoices_flag = 'N'
468: THEN
469: INSERT INTO ar_trx_errors_gt (
470: trx_header_id,
471: error_message,
472: invalid_value)
473: SELECT trx_header_id,
525: END IF;
526:
527: x_return_status := FND_API.G_RET_STS_SUCCESS;
528:
529: INSERT INTO ar_trx_errors_gt (
530: trx_header_id,
531: error_message,
532: invalid_value)
533: SELECT trx_header_id,
571: END IF;
572:
573: x_return_status := FND_API.G_RET_STS_SUCCESS;
574:
575: INSERT INTO ar_trx_errors_gt (
576: trx_header_id,
577: error_message,
578: invalid_value)
579: SELECT trx_header_id,
612: END IF;
613:
614: x_return_status := FND_API.G_RET_STS_SUCCESS;
615:
616: INSERT INTO ar_trx_errors_gt (
617: trx_header_id,
618: error_message,
619: invalid_value)
620: SELECT trx_header_id,
654: END IF;
655:
656: x_return_status := FND_API.G_RET_STS_SUCCESS;
657:
658: INSERT INTO ar_trx_errors_gt (
659: trx_header_id,
660: error_message,
661: invalid_value)
662: SELECT trx_header_id,
694: END IF;
695:
696: x_return_status := FND_API.G_RET_STS_SUCCESS;
697:
698: INSERT INTO ar_trx_errors_gt (
699: trx_header_id,
700: error_message,
701: invalid_value)
702: SELECT trx_header_id,
736: END IF;
737:
738: x_return_status := FND_API.G_RET_STS_SUCCESS;
739:
740: INSERT INTO ar_trx_errors_gt (
741: trx_header_id,
742: error_message,
743: invalid_value)
744: SELECT trx_header_id,
776: END IF;
777:
778: x_return_status := FND_API.G_RET_STS_SUCCESS;
779:
780: INSERT INTO ar_trx_errors_gt (
781: trx_header_id,
782: error_message,
783: invalid_value)
784: SELECT trx_header_id,
831: END IF;
832:
833: x_return_status := FND_API.G_RET_STS_SUCCESS;
834:
835: INSERT INTO ar_trx_errors_gt (
836: trx_header_id,
837: error_message,
838: invalid_value)
839: SELECT trx_header_id,
886: END IF;
887:
888: x_return_status := FND_API.G_RET_STS_SUCCESS;
889:
890: INSERT INTO ar_trx_errors_gt (
891: trx_header_id,
892: error_message,
893: invalid_value)
894: SELECT trx_header_id,
968:
969: IF (l_seq_num_profile = 'N')
970: AND SUBSTRB(l_doc_sequence_type,1,1) IN ( 'A', 'G') THEN
971:
972: INSERT INTO ar_trx_errors_gt (
973: trx_header_id,
974: error_message,
975: invalid_value)
976: VALUES
991: debug ('validate_bfb(+)');
992: END IF;
993:
994: -- R12:BFB : billing_date is required if BFB is event-based
995: INSERT INTO ar_trx_errors_gt (
996: trx_header_id,
997: error_message,
998: invalid_value)
999: SELECT trx_header_id,
1005: AND ar_bfb_utils_pvt.is_payment_term_bfb(term_id) = 'Y'
1006: AND nvl(ar_bfb_utils_pvt.get_cycle_type (ar_bfb_utils_pvt.get_billing_cycle(term_id)),'XXX') = 'EVENT';
1007:
1008: -- R12:BFB : BFB is not allowed with open Rec = No
1009: INSERT INTO ar_trx_errors_gt (
1010: trx_header_id,
1011: error_message,
1012: invalid_value)
1013: SELECT trx_header_id,
1019: AND ar_bfb_utils_pvt.is_payment_term_bfb(term_id) = 'Y'
1020: AND ar_bfb_utils_pvt.get_open_rec(cust_trx_type_id) = 'N';
1021:
1022: -- R12:BFB : billing_date validation
1023: INSERT INTO ar_trx_errors_gt (
1024: trx_header_id,
1025: error_message,
1026: invalid_value)
1027: SELECT trx_header_id,
1067: had the opposite setting as the record for the current org.
1068:
1069: REMOVED _ALL from ra_batch_sources in exists clauses */
1070:
1071: INSERT INTO ar_trx_errors_gt (
1072: trx_header_id,
1073: error_message,
1074: invalid_value)
1075: SELECT trx_header_id,
1087:
1088: -- Accept Customer Bank Account ID only when payment method
1089: -- is passed and it is automatic.
1090:
1091: INSERT INTO ar_trx_errors_gt (
1092: trx_header_id,
1093: error_message,
1094: invalid_value)
1095: SELECT trx_header_id,
1107:
1108: -- If paying_site_use_id must be entered when paying_customer_id is
1109: -- entered.
1110:
1111: INSERT INTO ar_trx_errors_gt (
1112: trx_header_id,
1113: error_message,
1114: invalid_value)
1115: SELECT trx_header_id,
1122:
1123: -- Purchase Order Reveision and Date should be accepted only
1124: -- when purchase order is passed.
1125:
1126: INSERT INTO ar_trx_errors_gt (
1127: trx_header_id,
1128: error_message,
1129: invalid_value)
1130: SELECT trx_header_id,
1137:
1138: -- Accounting Rule ID and Duration should be entered only
1139: -- invoicing rule id is populated at header.
1140:
1141: INSERT INTO ar_trx_errors_gt (
1142: trx_header_id,
1143: trx_line_id,
1144: error_message,
1145: invalid_value)
1154: AND lgt.trx_header_id = hgt.trx_header_id
1155: AND hgt.invoicing_rule_id IS NULL;
1156:
1157: -- Link_to_line_id should always point to a line of type LINE
1158: INSERT INTO ar_trx_errors_gt (
1159: trx_header_id,
1160: trx_line_id,
1161: error_message,
1162: invalid_value)
1172: WHERE gt2.trx_line_id = gt.link_to_trx_line_id
1173: AND gt2.line_type = 'LINE');
1174:
1175: -- Sub Lines can not have a line type of 'LINE'
1176: INSERT INTO ar_trx_errors_gt (
1177: trx_header_id,
1178: trx_line_id,
1179: error_message,
1180: invalid_value)
1189:
1190: -- Exchange rate info is required only if exchange rate type
1191: -- is 'User'
1192:
1193: INSERT INTO ar_trx_errors_gt (
1194: trx_header_id,
1195: error_message,
1196: invalid_value)
1197: SELECT trx_header_id,
1205: AND gt.trx_currency <> p_trx_system_param_rec.base_currency_code;
1206:
1207: -- Exchange rate should not be entered for rate type != 'User'.
1208:
1209: INSERT INTO ar_trx_errors_gt (
1210: trx_header_id,
1211: error_message,
1212: invalid_value)
1213: SELECT trx_header_id,
1218: AND exchange_rate_type <> 'User';
1219:
1220: -- Exchange rate cannot be specified for base currency trxns.
1221:
1222: INSERT INTO ar_trx_errors_gt (
1223: trx_header_id,
1224: error_message,
1225: invalid_value)
1226: SELECT trx_header_id,
1233: AND trx_currency = p_trx_system_param_rec.base_currency_code;
1234:
1235: -- amount includes tax flag should be NULL, Y or N
1236:
1237: INSERT INTO ar_trx_errors_gt (
1238: trx_header_id,
1239: trx_line_id,
1240: error_message,
1241: invalid_value)
1270:
1271: x_return_status := FND_API.G_RET_STS_SUCCESS;
1272:
1273: -- Every header level row should have atleast one line level row.
1274: INSERT INTO ar_trx_errors_gt (
1275: trx_header_id,
1276: error_message,
1277: invalid_value)
1278: SELECT trx_header_id,
1284: FROM ar_trx_lines_gt lgt
1285: WHERE lgt.trx_header_id = gt.trx_header_id);
1286:
1287: -- Every line level row should have a corresponding header level row.
1288: INSERT INTO ar_trx_errors_gt (
1289: trx_header_id,
1290: trx_line_id,
1291: error_message,
1292: invalid_value)
1300: FROM ar_trx_header_gt hgt
1301: WHERE hgt.trx_header_id = lgt.trx_header_id);
1302:
1303: -- Line numbers must be unique
1304: INSERT INTO ar_trx_errors_gt (
1305: trx_header_id,
1306: trx_line_id,
1307: error_message,
1308: invalid_value)
1320: GROUP BY lgt2.trx_header_id, lgt2.line_number
1321: HAVING count(*) > 1);
1322:
1323: -- Line IDs must be unique
1324: INSERT INTO ar_trx_errors_gt (
1325: trx_header_id,
1326: trx_line_id,
1327: error_message,
1328: invalid_value)
1339: GROUP BY lgt2.trx_header_id, lgt2.trx_line_id
1340: HAVING count(*) > 1);
1341:
1342: -- Header IDs must be unique
1343: INSERT INTO ar_trx_errors_gt (
1344: trx_header_id,
1345: error_message,
1346: invalid_value)
1347: SELECT trx_header_id,
1385: END IF;
1386:
1387: x_return_status := FND_API.G_RET_STS_SUCCESS;
1388:
1389: INSERT INTO ar_trx_errors_gt (
1390: trx_header_id,
1391: error_message,
1392: invalid_value)
1393: SELECT trx_header_id,
1452: END IF;
1453:
1454: x_return_status := FND_API.G_RET_STS_SUCCESS;
1455:
1456: INSERT INTO ar_trx_errors_gt (
1457: trx_header_id,
1458: error_message,
1459: invalid_value)
1460: SELECT trx_header_id,
1490:
1491: x_return_status := FND_API.G_RET_STS_SUCCESS;
1492:
1493: BEGIN
1494: INSERT INTO ar_trx_errors_gt (
1495: trx_header_id,
1496: error_message,
1497: invalid_value)
1498: SELECT trx_header_id,
1536: END IF;
1537:
1538: x_return_status := FND_API.G_RET_STS_SUCCESS;
1539:
1540: INSERT INTO ar_trx_errors_gt
1541: ( trx_header_id,
1542: error_message,
1543: invalid_value)
1544: SELECT trx_header_id,
1574: debug ('AR_INVOICE_UTILS.validate_transaction_type(+)' );
1575: END IF;
1576:
1577: x_return_status := FND_API.G_RET_STS_SUCCESS;
1578: INSERT INTO ar_trx_errors_gt (
1579: trx_header_id,
1580: error_message,
1581: invalid_value)
1582: SELECT trx_header_id,
1584: cust_trx_type_id
1585: FROM ar_trx_header_gt gt
1586: WHERE gt.cust_trx_type_id IS NULL;
1587:
1588: INSERT INTO ar_trx_errors_gt (
1589: trx_header_id,
1590: error_message,
1591: invalid_value)
1592: SELECT trx_header_id,
1625: END IF;
1626:
1627: x_return_status := FND_API.G_RET_STS_SUCCESS;
1628:
1629: INSERT INTO ar_trx_errors_gt (
1630: trx_header_id,
1631: error_message,
1632: invalid_value)
1633: SELECT trx_header_id,
1664: END IF;
1665: x_return_status := FND_API.G_RET_STS_SUCCESS;
1666:
1667: if(nvl(FND_PROFILE.value('AR_TRX_DEFAULT_PRIM_SITE_USE'),'BILL_SHIP_TO') not in ('BILL_TO','BILL_SHIP_TO')) then
1668: INSERT INTO ar_trx_errors_gt (
1669: trx_header_id,
1670: error_message,
1671: invalid_value)
1672: SELECT trx_header_id,
1676: WHERE gt.bill_to_site_use_id IS NULL
1677: and gt.bill_to_customer_id is not null;
1678: end if;
1679:
1680: INSERT INTO ar_trx_errors_gt (
1681: trx_header_id,
1682: error_message,
1683: invalid_value)
1684: SELECT trx_header_id,
1722: END IF;
1723:
1724: x_return_status := FND_API.G_RET_STS_SUCCESS;
1725:
1726: INSERT INTO ar_trx_errors_gt (
1727: trx_header_id,
1728: error_message,
1729: invalid_value)
1730: SELECT trx_header_id,
1777: END IF;
1778:
1779: x_return_status := FND_API.G_RET_STS_SUCCESS;
1780:
1781: INSERT INTO ar_trx_errors_gt (
1782: trx_header_id,
1783: error_message,
1784: invalid_value)
1785: SELECT trx_header_id,
1822: -- The below if condition is added to validate ship_to_site_use_id before defaulting ship_to details
1823: if(x_called = 'BEFORE') then
1824: if( nvl(FND_PROFILE.value('AR_TRX_DEFAULT_PRIM_SITE_USE'),'BILL_SHIP_TO') not in ('SHIP_TO','BILL_SHIP_TO')) then
1825:
1826: INSERT INTO ar_trx_errors_gt (
1827: trx_header_id,
1828: error_message,
1829: invalid_value)
1830: SELECT trx_header_id,
1834: WHERE gt.ship_to_site_use_id IS NULL
1835: AND gt.ship_to_customer_id IS NOT NULL;
1836: end if;
1837:
1838: INSERT INTO ar_trx_errors_gt (
1839: trx_header_id,
1840: error_message,
1841: invalid_value)
1842: SELECT trx_header_id,
1854: where cust_account_id = gt.ship_to_customer_id)
1855: and site_use_id = gt.ship_to_site_use_id);
1856:
1857: else
1858: INSERT INTO ar_trx_errors_gt (
1859: trx_header_id,
1860: error_message,
1861: invalid_value)
1862: SELECT trx_header_id,
1889: END IF;
1890:
1891: x_return_status := FND_API.G_RET_STS_SUCCESS;
1892:
1893: INSERT INTO ar_trx_errors_gt (
1894: trx_header_id,
1895: error_message,
1896: invalid_value)
1897: SELECT trx_header_id,
2022: x_return_status => x_return_status);
2023:
2024: x_return_status := FND_API.G_RET_STS_SUCCESS;
2025:
2026: INSERT INTO ar_trx_errors_gt (
2027: trx_header_id,
2028: error_message,
2029: invalid_value)
2030: SELECT trx_header_id,
2077: debug ('AR_INVOICE_UTILS.validate_terms(+)' );
2078: END IF;
2079: x_return_status := FND_API.G_RET_STS_SUCCESS;
2080:
2081: INSERT INTO ar_trx_errors_gt (
2082: trx_header_id,
2083: error_message,
2084: invalid_value)
2085: SELECT gt.trx_header_id,
2100: and t.term_id = gt.term_id );
2101:
2102: -- Term id not allowed for Credit Memo
2103: -- added for ER 5869149
2104: INSERT INTO ar_trx_errors_gt (
2105: trx_header_id,
2106: error_message,
2107: invalid_value)
2108: SELECT gt.trx_header_id,
2142:
2143: x_return_status := FND_API.G_RET_STS_SUCCESS;
2144:
2145: /*
2146: INSERT INTO ar_trx_errors_gt (
2147: trx_header_id,
2148: error_message,
2149: invalid_value)
2150: SELECT trx_header_id,
2182: l_message_name := gl_public_sector.get_message_name (
2183: p_message_name => 'AR_INVALID_PRIMARY_SALESREP',
2184: p_app_short_name => 'AR');
2185:
2186: INSERT INTO ar_trx_errors_gt (
2187: trx_header_id,
2188: error_message,
2189: invalid_value)
2190: SELECT trx_header_id,
2203: l_message_name := gl_public_sector.get_message_name (
2204: p_message_name => 'AR_INAPI_SALESREP_REQUIRED',
2205: p_app_short_name => 'AR');
2206:
2207: INSERT INTO ar_trx_errors_gt (
2208: trx_header_id,
2209: error_message,
2210: invalid_value)
2211: SELECT trx_header_id,
2241: x_return_status := FND_API.G_RET_STS_SUCCESS;
2242:
2243: -- in case of debit memo invoice rule id is not required
2244: -- in case of credit memo invoice rule id is not required ER 5869149
2245: INSERT INTO ar_trx_errors_gt (
2246: trx_header_id,
2247: error_message,
2248: invalid_value)
2249: SELECT trx_header_id,
2256: FROM ra_cust_trx_types tt
2257: WHERE tt.cust_trx_type_id = gt.cust_trx_type_id
2258: AND tt.type = 'INV' );
2259:
2260: INSERT INTO ar_trx_errors_gt (
2261: trx_header_id,
2262: error_message,
2263: invalid_value)
2264: SELECT trx_header_id,
2294: END IF;
2295:
2296: x_return_status := FND_API.G_RET_STS_SUCCESS;
2297:
2298: INSERT INTO ar_trx_errors_gt (
2299: trx_header_id,
2300: error_message,
2301: invalid_value)
2302: SELECT trx_header_id,
2379: END IF;
2380: RETURN;
2381: END;
2382:
2383: INSERT INTO ar_trx_errors_gt (
2384: trx_header_id,
2385: error_message,
2386: invalid_value)
2387: SELECT trx_header_id,
2423: END IF;
2424:
2425: x_return_status := FND_API.G_RET_STS_SUCCESS;
2426:
2427: INSERT INTO ar_trx_errors_gt (
2428: trx_header_id,
2429: error_message,
2430: invalid_value)
2431: SELECT trx_header_id,
2460: END IF;
2461:
2462: x_return_status := FND_API.G_RET_STS_SUCCESS;
2463:
2464: INSERT INTO ar_trx_errors_gt (
2465: trx_header_id,
2466: error_message,
2467: invalid_value)
2468: SELECT trx_header_id,
2499: END IF;
2500:
2501: x_return_status := FND_API.G_RET_STS_SUCCESS;
2502:
2503: INSERT INTO ar_trx_errors_gt (
2504: trx_header_id,
2505: error_message,
2506: invalid_value)
2507: SELECT trx_header_id,
2594: AND trunc(cglDateRec.gl_date) between start_date and end_date;
2595:
2596: IF l_period_status NOT IN ( 'O', 'F')
2597: THEN
2598: INSERT INTO ar_trx_errors_gt (
2599: trx_header_id,
2600: error_message,
2601: invalid_value)
2602: values
2610: IF cglDateRec.invoicing_rule_id = -2
2611: THEN
2612: IF l_period_status not in ('O', 'F' , 'U')
2613: THEN
2614: INSERT INTO ar_trx_errors_gt (
2615: trx_header_id,
2616: error_message,
2617: invalid_value)
2618: values
2623: ELSIF cglDateRec.invoicing_rule_id = -3
2624: THEN
2625: IF l_period_status not in ('O', 'F' , 'U', 'N')
2626: THEN
2627: INSERT INTO ar_trx_errors_gt (
2628: trx_header_id,
2629: error_message,
2630: invalid_value)
2631: values
2637: END IF;
2638:
2639: EXCEPTION
2640: WHEN NO_DATA_FOUND THEN
2641: INSERT INTO ar_trx_errors_gt (
2642: trx_header_id,
2643: error_message,
2644: invalid_value)
2645: values
2652: /* post_to_gl = 'N'.. if a gl_date is supplied,
2653: then it's an error */
2654: IF cglDateRec.gl_date IS NOT NULL
2655: THEN
2656: INSERT INTO ar_trx_errors_gt (
2657: trx_header_id,
2658: error_message,
2659: invalid_value)
2660: values
2688: END IF;
2689:
2690: x_return_status := FND_API.G_RET_STS_SUCCESS;
2691:
2692: INSERT INTO ar_trx_errors_gt (
2693: trx_header_id,
2694: error_message,
2695: invalid_value)
2696: SELECT trx_header_id,
2811: END IF;
2812:
2813: EXCEPTION
2814: WHEN NO_DATA_FOUND THEN
2815: INSERT INTO ar_trx_errors_gt (
2816: trx_header_id,
2817: error_message,
2818: invalid_value)
2819: SELECT gt.trx_header_id,
2910: WHERE cust_trx_type_id = cust_trx_type_rec.cust_trx_type_id;
2911:
2912: EXCEPTION
2913: WHEN NO_DATA_FOUND THEN
2914: INSERT INTO ar_trx_errors_gt (
2915: trx_header_id,
2916: error_message,
2917: invalid_value)
2918: SELECT gt.trx_header_id,
3882: WHERE gt.term_id IS NOT NULL
3883: AND ar_bfb_utils_pvt.is_payment_term_bfb(gt.term_id) = 'N'
3884: AND NOT EXISTS
3885: (SELECT 'X'
3886: FROM ar_trx_errors_gt errgt
3887: WHERE errgt.trx_header_id = gt.trx_header_id);
3888:
3889: -- get due_date for BFB enabled
3890: UPDATE ar_trx_header_gt gt
3893: AND ar_bfb_utils_pvt.is_payment_term_bfb(gt.term_id) = 'Y'
3894: AND gt.billing_date IS NOT NULL
3895: AND NOT EXISTS
3896: (SELECT 'X'
3897: FROM ar_trx_errors_gt errgt
3898: WHERE errgt.trx_header_id = gt.trx_header_id);
3899:
3900: IF pg_debug = 'Y'
3901: THEN
3925: x_return_status => x_return_status );
3926: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3927: RETURN;
3928: ELSE
3929: INSERT INTO ar_trx_errors_gt (
3930: trx_header_id,
3931: error_message,
3932: invalid_value)
3933: SELECT trx_header_id,
3956:
3957: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3958: RETURN;
3959: ELSE
3960: INSERT INTO ar_trx_errors_gt (
3961: trx_header_id,
3962: error_message,
3963: invalid_value)
3964: SELECT trx_header_id,
4128: x_return_status := FND_API.G_RET_STS_SUCCESS;
4129:
4130: l_so_org_id := to_number(oe_profile.value('SO_ORGANIZATION_ID')); /*Bug 3752043*/
4131:
4132: INSERT INTO ar_trx_errors_gt
4133: ( trx_header_id,
4134: trx_line_id,
4135: error_message,
4136: invalid_value )
4143: AND gt.line_type <> 'LINE';
4144:
4145: -- UOM Code not allowed for CM
4146:
4147: INSERT INTO ar_trx_errors_gt
4148: ( trx_header_id,
4149: trx_line_id,
4150: error_message,
4151: invalid_value )
4158: AND gt.line_type = 'LINE'
4159: AND gt2.trx_header_id = gt.trx_header_id
4160: AND gt2.trx_class = 'CM'; -- added for ER 5869149
4161:
4162: INSERT INTO ar_trx_errors_gt
4163: ( trx_header_id,
4164: trx_line_id,
4165: error_message,
4166: invalid_value )
4243: END IF;
4244:
4245: x_return_status := FND_API.G_RET_STS_SUCCESS;
4246:
4247: INSERT INTO ar_trx_errors_gt
4248: ( trx_header_id,
4249: trx_line_id,
4250: error_message,
4251: invalid_value )
4256: FROM ar_trx_lines_gt gt
4257: WHERE extended_amount IS NULL
4258: AND line_type in ('TAX', 'FREIGHT');
4259:
4260: INSERT INTO ar_trx_errors_gt
4261: ( trx_header_id,
4262: trx_line_id,
4263: error_message,
4264: invalid_value )
4272: OR unit_selling_price IS NOT NULL );
4273:
4274: /* In etax, a manual tax line must have regime, tax, juris,
4275: rate, and status -- no exceptions */
4276: INSERT INTO ar_trx_errors_gt
4277: ( trx_header_id,
4278: trx_line_id,
4279: error_message,
4280: invalid_value )
4344: IF pg_debug = 'Y'
4345: THEN
4346: debug ('Tax use customer exempt Flag ' || l_tax_use_exempt_flag);
4347: END IF;
4348: INSERT INTO ar_trx_errors_gt
4349: ( trx_header_id,
4350: trx_line_id,
4351: error_message,
4352: invalid_value )
4369: and tax_exempt_flag = lookup_code);
4370:
4371: -- now validate the reson code in case the exempt flag = 'E'
4372: -- if exempt flag is E then reason code must be supplied.
4373: INSERT INTO ar_trx_errors_gt
4374: ( trx_header_id,
4375: trx_line_id,
4376: error_message)
4377: SELECT trx_header_id,
4387: tax_exempt_number = null
4388: WHERE tax_exempt_flag in ( 'R', 'S');
4389:
4390: -- Validate the reason code
4391: INSERT INTO ar_trx_errors_gt
4392: ( trx_header_id,
4393: trx_line_id,
4394: error_message,
4395: invalid_value)
4433:
4434: x_return_status := FND_API.G_RET_STS_SUCCESS;
4435:
4436: -- reason code
4437: INSERT INTO ar_trx_errors_gt
4438: ( trx_header_id,
4439: trx_line_id,
4440: error_message,
4441: invalid_value )
4447: WHERE gt.reason_code IS NOT NULL
4448: AND gt.line_type = 'TAX';
4449:
4450:
4451: INSERT INTO ar_trx_errors_gt
4452: ( trx_header_id,
4453: trx_line_id,
4454: error_message,
4455: invalid_value )
4492: END IF;
4493:
4494: x_return_status := FND_API.G_RET_STS_SUCCESS;
4495:
4496: INSERT INTO ar_trx_errors_gt
4497: ( trx_header_id,
4498: error_message)
4499: SELECT trx_header_id,
4500: arp_standard.fnd_message('AR_INAPI_INV_DESC_NULL')
4503: AND gt.inventory_item_id IS NULL
4504: AND gt.memo_line_id IS NULL
4505: AND gt.line_type = 'LINE';
4506:
4507: INSERT INTO ar_trx_errors_gt
4508: ( trx_header_id,
4509: trx_line_id,
4510: error_message)
4511: SELECT trx_header_id,
4564: END IF;
4565:
4566: x_return_status := FND_API.G_RET_STS_SUCCESS;
4567:
4568: INSERT INTO ar_trx_errors_gt
4569: ( trx_header_id,
4570: error_message)
4571: SELECT gt.trx_header_id,
4572: arp_standard.fnd_message('AR_INAPI_QTY_NOT_NULL')
4599: END IF;
4600:
4601: x_return_status := FND_API.G_RET_STS_SUCCESS;
4602:
4603: INSERT INTO ar_trx_errors_gt
4604: ( trx_header_id,
4605: error_message)
4606: SELECT gt.trx_header_id,
4607: arp_standard.fnd_message('AR_INAPI_UNIT_PRICE_NOT_NULL')
4631: debug ('AR_INVOICE_UTILS.validate_line_type (+)' );
4632: END IF;
4633: x_return_status := FND_API.G_RET_STS_SUCCESS;
4634:
4635: INSERT INTO ar_trx_errors_gt
4636: ( trx_header_id,
4637: error_message,
4638: invalid_value )
4639: SELECT trx_header_id,
4663: debug ('AR_INVOICE_UTILS.check_dup_line_number (+)' );
4664: END IF;
4665: x_return_status := FND_API.G_RET_STS_SUCCESS;
4666: -- first check if line number is null or not
4667: INSERT INTO ar_trx_errors_gt
4668: ( trx_header_id,
4669: error_message)
4670: SELECT trx_header_id,
4671: arp_standard.fnd_message('AR_INAPI_LINE_NUM_NOT_NULL')
4672: FROM ar_trx_lines_gt gt
4673: WHERE gt.line_number IS NULL;
4674:
4675: -- check for duplicate line number
4676: /* INSERT INTO ar_trx_errors_gt
4677: ( trx_header_id,
4678: error_message
4679: SELECT trx_header_id,
4680: 'Duplicate Line Number'
4716:
4717: x_return_status := FND_API.G_RET_STS_SUCCESS;
4718:
4719: -- first check whether all lines have line and header id
4720: INSERT INTO ar_trx_errors_gt
4721: ( trx_header_id,
4722: trx_line_id,
4723: error_message)
4724: SELECT trx_header_id,
4729: OR gt.trx_line_id IS NULL;
4730:
4731: -- Now check if the line is of Tax type then
4732: -- link_to link_to_trx_line_id not null
4733: INSERT INTO ar_trx_errors_gt
4734: ( trx_header_id,
4735: trx_line_id,
4736: error_message)
4737: SELECT trx_header_id,
4762: WHERE gt.trx_header_id = c_freight_rec.trx_header_id;
4763:
4764: IF l_allow_freight_flag = 'N'
4765: THEN
4766: INSERT INTO ar_trx_errors_gt
4767: ( trx_header_id,
4768: error_message)
4769: VALUES
4770: ( c_freight_rec.trx_header_id,
4797: END;
4798: IF ( nvl(l_header_freight_count, 0) >= 1 and
4799: nvl(l_line_freight_count, 0) >= 1 )
4800: THEN
4801: INSERT INTO ar_trx_errors_gt
4802: ( trx_header_id,
4803: error_message)
4804: SELECT trx_header_id,
4805: arp_standard.fnd_message('AR_TAPI_TOO_MANY_FREIGHT_LINE')
4830: debug ('AR_INVOICE_UTILS.validate_freight (+)' );
4831: END IF;
4832: x_return_status := FND_API.G_RET_STS_SUCCESS;
4833:
4834: INSERT INTO ar_trx_errors_gt
4835: ( trx_header_id,
4836: trx_line_id,
4837: error_message)
4838: SELECT trx_header_id,
4848: and gt.trx_date <= nvl(trunc(disable_date), gt.trx_date)
4849: and freight_code = gt.ship_via);
4850:
4851: -- validate FOB
4852: INSERT INTO ar_trx_errors_gt
4853: ( trx_header_id,
4854: trx_line_id,
4855: error_message)
4856: SELECT trx_header_id,
4866: and lookup_code = gt.fob_point
4867: and gt.trx_date between start_date_active and nvl(end_date_active, gt.trx_date));
4868:
4869: -- error if extended_amount is null
4870: INSERT INTO ar_trx_errors_gt
4871: ( trx_header_id,
4872: trx_line_id,
4873: error_message)
4874: SELECT trx_header_id,
4950: NULL;
4951: ELSIF ( c_line_rec.creation_sign = 'P' ) THEN
4952: IF ( (NVL( c_line_rec.extended_amount, 0 ) < 0)
4953: OR ( NVL( c_line_rec.revenue_amount, 0 ) < 0 )) THEN
4954: INSERT INTO ar_trx_errors_gt
4955: ( trx_header_id,
4956: error_message)
4957: VALUES
4958: ( c_line_rec.trx_header_id,
4960: END IF;
4961: ELSIF ( c_line_rec.creation_sign = 'N' ) THEN
4962: IF ( (NVL( c_line_rec.extended_amount, 0 ) > 0)
4963: OR ( NVL( c_line_rec.revenue_amount, 0 ) > 0 )) THEN
4964: INSERT INTO ar_trx_errors_gt
4965: ( trx_header_id,
4966: error_message)
4967: VALUES
4968: ( c_line_rec.trx_header_id,
4985: /* Bug 13635700, FP bug of 9063570, Set the amount precision as per currency precision*/
4986: --IF (c_line_rec.quantity_invoiced*c_line_rec.unit_selling_price <>
4987: IF (arpcurr.currround((c_line_rec.quantity_invoiced*c_line_rec.unit_selling_price),c_line_rec.currency_code) <>
4988: c_line_rec.extended_amount) THEN
4989: INSERT INTO ar_trx_errors_gt
4990: ( trx_header_id,
4991: trx_line_id,
4992: error_message)
4993: VALUES
5039: debug ('AR_INVOICE_UTILS.validate_doc_sequence (+)' );
5040: END IF;
5041: x_return_status := FND_API.G_RET_STS_SUCCESS;
5042:
5043: INSERT INTO ar_trx_errors_gt
5044: ( trx_header_id,
5045: error_message)
5046: SELECT trx_header_id,
5047: arp_standard.fnd_message('AR_INAPI_DUP_DOC_SEQUENCE')
5091: SELECT * FROM
5092: ar_trx_header_gt
5093: WHERE trx_header_id NOT IN (
5094: SELECT trx_header_id FROM
5095: ar_trx_errors_gt);
5096:
5097: l_sequence_name FND_DOCUMENT_SEQUENCES.NAME%TYPE;
5098: l_doc_sequence_id ra_customer_trx.doc_sequence_id%type;
5099: l_doc_sequence_value ra_customer_trx.doc_sequence_value%type;
5150:
5151: IF l_sequence_type IS NULL
5152: AND l_seq_num_profile = 'A'
5153: THEN
5154: INSERT into ar_trx_errors_gt (
5155: trx_header_id,
5156: error_message )
5157: VALUES
5158: ( ctrxHeaderRec.trx_header_id,
5178:
5179: l_update_trx := TRUE;
5180: EXCEPTION
5181: WHEN OTHERS THEN
5182: INSERT into ar_trx_errors_gt (
5183: trx_header_id,
5184: error_message,
5185: invalid_value)
5186: VALUES
5277: SELECT * FROM
5278: ar_trx_header_gt
5279: WHERE trx_header_id NOT IN (
5280: SELECT trx_header_id FROM
5281: ar_trx_errors_gt)
5282: AND payment_trxn_extension_id is not null;
5283:
5284: l_payer_rec IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type;
5285: l_cpy_msg_data VARCHAR2(2000);
5393: l_cpy_msg_data := substrb( l_response_rec.Result_Code || ': '||
5394: l_response_rec.Result_Message , 1, 240);
5395:
5396:
5397: INSERT into ar_trx_errors_gt (
5398: trx_header_id,
5399: error_message,
5400: invalid_value)
5401: VALUES
5455: THEN
5456: -- check whether invoice_enable_flag is 'Y'
5457: IF fnd_flex_keyval.column_value(1) <> 'Y'
5458: THEN
5459: INSERT into ar_trx_errors_gt (
5460: trx_header_id,
5461: trx_line_id,
5462: error_message,
5463: invalid_value)
5480: WHERE trx_line_id = cItemFlexRec.trx_line_id
5481: AND description is NULL;
5482: END IF;
5483: ELSE
5484: INSERT into ar_trx_errors_gt (
5485: trx_header_id,
5486: trx_line_id,
5487: error_message,
5488: invalid_value)
5529: structure_number => 101,
5530: combination_id => cTerritoryRec.territory_id)
5531: <> TRUE )
5532: THEN
5533: INSERT into ar_trx_errors_gt (
5534: trx_header_id,
5535: error_message,
5536: invalid_value)
5537: VALUES
5561: END IF;
5562:
5563: x_return_status := FND_API.G_RET_STS_SUCCESS;
5564:
5565: INSERT INTO ar_trx_errors_gt
5566: ( trx_line_id,
5567: trx_header_id,
5568: error_message,
5569: Invalid_value )
5633:
5634: x_return_status := FND_API.G_RET_STS_SUCCESS;
5635:
5636: --PPRR Added PP rule types in the type condition
5637: INSERT INTO ar_trx_errors_gt
5638: ( trx_header_id,
5639: trx_line_id,
5640: error_message)
5641: SELECT gt.trx_header_id,
5651: WHERE rr.type in ('A', 'ACC_DUR','PP_DR_ALL','PP_DR_PP')
5652: and rr.status = 'A'
5653: AND rr.rule_id = gt.accounting_rule_id);
5654:
5655: INSERT INTO ar_trx_errors_gt
5656: ( trx_header_id,
5657: trx_line_id,
5658: error_message)
5659: SELECT gt.trx_header_id,
5667: AND gt.line_type = 'LINE';
5668:
5669: -- Rule name is not allowed for Credit Memos
5670:
5671: INSERT INTO ar_trx_errors_gt
5672: ( trx_header_id,
5673: trx_line_id,
5674: error_message)
5675: SELECT gt.trx_header_id,
5687: -- first check whether accounting rule name is supplied or not
5688: -- in case it is not supplied then log a error
5689: IF ( c_invoicing_rule_rec.accounting_rule_id IS NULL )
5690: THEN
5691: INSERT INTO ar_trx_errors_gt
5692: ( trx_header_id,
5693: trx_line_id,
5694: error_message) VALUES
5695: ( c_invoicing_rule_rec.trx_header_id,
5697: arp_standard.fnd_message('AR_INAPI_RULE_NAME_NOT_NULL') );
5698: --PPRR Accounting rule Validations
5699: ELSIF c_invoicing_rule_rec.type in ('PP_DR_ALL','PP_DR_PP') THEN
5700: IF c_invoicing_rule_rec.RULE_START_DATE IS NULL THEN
5701: INSERT INTO ar_trx_errors_gt
5702: ( trx_header_id,
5703: trx_line_id,
5704: error_message) VALUES
5705: ( c_invoicing_rule_rec.trx_header_id,
5707: arp_standard.fnd_message('AR_RAXTRX_RULE_START_DT_NULL'));
5708: END IF;
5709:
5710: IF c_invoicing_rule_rec.RULE_END_DATE IS NULL THEN
5711: INSERT INTO ar_trx_errors_gt
5712: ( trx_header_id,
5713: trx_line_id,
5714: error_message) VALUES
5715: ( c_invoicing_rule_rec.trx_header_id,
5718: END IF;
5719:
5720: IF c_invoicing_rule_rec.RULE_END_DATE < c_invoicing_rule_rec.RULE_START_DATE
5721: THEN
5722: INSERT INTO ar_trx_errors_gt
5723: ( trx_header_id,
5724: trx_line_id,
5725: error_message) VALUES
5726: ( c_invoicing_rule_rec.trx_header_id,
5755: IF c_invoicing_rule_rec.accounting_rule_duration IS NULL
5756: THEN
5757: IF c_invoicing_rule_rec.type = 'ACC_DUR'
5758: THEN
5759: INSERT INTO ar_trx_errors_gt
5760: ( trx_header_id,
5761: trx_line_id,
5762: error_message) VALUES
5763: ( c_invoicing_rule_rec.trx_header_id,
5858:
5859: /* Bug 5444387 - Removed the check for trx_date to be equal to rule_start_date of each line
5860: as it is unnecessory and not always satisfied */
5861: IF ( l_period_exist <> 1 ) THEN
5862: INSERT INTO ar_trx_errors_gt
5863: ( trx_header_id,
5864: trx_line_id,
5865: error_message) VALUES
5866: ( c_invoicing_rule_rec.trx_header_id,
5899: END IF;
5900:
5901: x_return_status := FND_API.G_RET_STS_SUCCESS;
5902:
5903: INSERT INTO ar_trx_errors_gt (
5904: trx_header_id,
5905: trx_line_id,
5906: error_message,
5907: invalid_value)
6006: AND nvl(exchange_rate_type,
6007: p_trx_profile_rec.default_exchange_rate_type) <> 'User'
6008: AND NOT EXISTS
6009: (SELECT 'X'
6010: FROM ar_trx_errors_gt errgt
6011: WHERE errgt.trx_header_id = gt.trx_header_id
6012: AND errgt.invalid_value = gt.trx_currency);
6013:
6014: BEGIN
6071: EXCEPTION
6072: WHEN OTHERS THEN
6073: -- in case gl_api fails it will insert record
6074: -- into error table
6075: INSERT INTO ar_trx_errors_gt
6076: ( trx_header_id,
6077: error_message,
6078: invalid_value)
6079: VALUES
6092: AND exchange_date IS NULL;
6093:
6094: -- Now validates whether all exchange information is populated
6095: -- in case trxn currecny <> func currency
6096: INSERT INTO ar_trx_errors_gt (
6097: trx_header_id,
6098: error_message,
6099: invalid_value)
6100: SELECT trx_header_id,
7049: key_flex_code => 'GL#',
7050: structure_number => ARP_GLOBAL.chart_of_accounts_id,
7051: combination_id => CccidRec.code_combination_id )
7052: THEN
7053: INSERT INTO ar_trx_errors_gt
7054: ( trx_header_id,
7055: trx_line_id,
7056: trx_dist_id,
7057: error_message,
7100: l_precision := p_trx_system_parameters_rec.precision;
7101: l_min_acc_unit :=
7102: p_trx_system_parameters_rec.MINIMUM_ACCOUNTABLE_UNIT;
7103:
7104: INSERT INTO ar_trx_errors_gt
7105: ( trx_header_id,
7106: trx_line_id,
7107: trx_dist_id,
7108: error_message)
7115: -- the user can pass either amount or percent. If both amount and percent
7116: -- is passed then amount will take precendence.
7117:
7118: --First check whether user passed either amounts or percent.
7119: INSERT INTO ar_trx_errors_gt
7120: ( trx_header_id,
7121: trx_line_id,
7122: trx_dist_id,
7123: error_message)
7134: -- ignored.
7135: -- first check if account _class is 'REC' and if any accounting rule is passed
7136: -- then only percent is allowed. Amount is not allowed.
7137:
7138: INSERT INTO ar_trx_errors_gt
7139: ( trx_header_id,
7140: trx_line_id,
7141: trx_dist_id,
7142: error_message)
7160:
7161:
7162: -- check whether line type and account class matches
7163:
7164: INSERT INTO ar_trx_errors_gt
7165: (trx_header_id,
7166: trx_line_id,
7167: trx_dist_ID,
7168: error_message)
7292: | FREIGHT must equal the amount at the line of line type FREIGHT |
7293: | CHARGES must equal the amount at the line of line type CHARGES |
7294: +----------------------------------------------------------------*/
7295: /* 4652982 - fixed message name */
7296: INSERT INTO ar_trx_errors_gt
7297: ( trx_header_id,
7298: trx_line_id,
7299: error_message,
7300: invalid_value)
7324:
7325: /*-----------------------------------------------------------------+
7326: | Percent should total to 100 for each account class |
7327: +-----------------------------------------------------------------*/
7328: INSERT INTO ar_trx_errors_gt
7329: (trx_header_id,
7330: trx_LINE_ID,
7331: error_message,
7332: invalid_value)
7342:
7343: /*-----------------------------------------------------------------+
7344: | Percent should total to 100 for REC class in case it is passed |
7345: +-----------------------------------------------------------------*/
7346: INSERT INTO ar_trx_errors_gt
7347: (trx_header_id,
7348: error_message,
7349: invalid_value)
7350: SELECT d.trx_header_id,
7638: p_message_name => 'AR_INAPI_INVALID_SALESREP_ID',
7639: p_app_short_name => 'AR');
7640:
7641: -- validate salesrep_id
7642: INSERT INTO ar_trx_errors_gt
7643: (trx_header_id,
7644: trx_LINE_ID,
7645: trx_salescredit_id,
7646: error_MESSAGE,
7661: p_message_name => 'AR_INAPI_NVALID_SALESREP_NUM',
7662: p_app_short_name => 'AR');
7663:
7664: -- validate salesrep number
7665: INSERT INTO ar_trx_errors_gt
7666: (trx_header_id,
7667: trx_LINE_ID,
7668: trx_salescredit_id,
7669: error_MESSAGE,
7690: p_message_name => 'AR_INAPI_INVALID_SCR_TYPE_ID',
7691: p_app_short_name => 'AR');
7692:
7693: -- validate sales credit type ID
7694: INSERT INTO ar_trx_errors_gt
7695: (trx_header_id,
7696: trx_LINE_ID,
7697: trx_salescredit_id,
7698: error_MESSAGE,
7713: p_message_name => 'AR_INAPI_INVLD_SCR_TYPE_NAME',
7714: p_app_short_name => 'AR');
7715:
7716: -- validate sales credit type name
7717: INSERT INTO ar_trx_errors_gt
7718: (trx_header_id,
7719: trx_LINE_ID,
7720: trx_salescredit_id,
7721: error_MESSAGE,
7744: p_message_name => 'AR_INAPI_SCR_AMT_PERCENT_REQ',
7745: p_app_short_name => 'AR');
7746:
7747: -- validate either amount or percent has been passed by user
7748: INSERT INTO ar_trx_errors_gt
7749: (trx_header_id,
7750: trx_LINE_ID,
7751: trx_salescredit_id,
7752: error_MESSAGE)
7768:
7769: /*--------------------------------------------------------------+
7770: | Verify that sales credit assignments are for line type LINE |
7771: +--------------------------------------------------------------*/
7772: INSERT INTO ar_trx_errors_gt
7773: (trx_header_id,
7774: trx_LINE_ID,
7775: trx_salescredit_id,
7776: error_MESSAGE,
7994:
7995: END LOOP;
7996:
7997: -- validate amount precision
7998: INSERT INTO ar_trx_errors_gt
7999: (trx_header_id,
8000: trx_LINE_ID,
8001: trx_salescredit_id,
8002: error_MESSAGE,
8032: l_message_name := gl_public_sector.get_message_name (
8033: p_message_name => 'AR_INAPI_INVALID_PERCENT_SPLIT',
8034: p_app_short_name => 'AR');
8035:
8036: INSERT INTO ar_trx_errors_gt
8037: (trx_header_id,
8038: trx_LINE_ID,
8039: trx_salescredit_id,
8040: error_MESSAGE,
8057:
8058: /*------------------------------------------------------------+
8059: | Identify un-foot sales credit |
8060: +------------------------------------------------------------*/
8061: INSERT INTO ar_trx_errors_gt
8062: (trx_header_id,
8063: trx_line_id,
8064: error_MESSAGE)
8065: SELECT SC.trx_header_id,
8084: p_app_short_name => 'AR');
8085:
8086: -- identify un-foot sales credit for amount
8087: -- Sum of sales credit does not equal to line amount
8088: INSERT INTO ar_trx_errors_gt
8089: (trx_header_id,
8090: trx_line_id,
8091: error_message,
8092: invalid_value)
8125: l_message_name := gl_public_sector.get_message_name (
8126: p_message_name => 'AR_INAPI_ONE_SALESCREDIT_ROW',
8127: p_app_short_name => 'AR');
8128:
8129: INSERT INTO ar_trx_errors_gt
8130: (trx_header_id,
8131: trx_line_id,
8132: error_message)
8133: SELECT lgt.trx_header_id,