25: --arp_util.debug( p_message);
26: end if;
27: */
28:
29: arp_standard.debug(p_message);
30:
31: END debug;
32:
33: PROCEDURE validate_gdf(
75: trx_header_id,
76: error_message,
77: invalid_value)
78: SELECT trx_header_id,
79: arp_standard.fnd_message('AR_INAPI_INVALID_REMIT_ADDR_ID'),
80: remit_to_address_id
81: FROM ar_trx_header_gt gt
82: WHERE gt.remit_to_address_id IS NOT NULL
83: AND NOT EXISTS
115: trx_header_id,
116: error_message,
117: invalid_value)
118: SELECT trx_header_id,
119: arp_standard.fnd_message('AR_INAPI_INVALID_TRX_CLASS'),
120: trx_class
121: FROM ar_trx_header_gt gt
122: WHERE gt.trx_class NOT IN ('INV', 'DM' , 'CM') -- added CM for ER 5869149
123: AND gt.trx_class IS NOT NULL;
151: trx_header_id,
152: error_message,
153: invalid_value)
154: SELECT trx_header_id,
155: arp_standard.fnd_message('AR_INAPI_INVALID_SHIP_VIA'),
156: ship_via
157: FROM ar_trx_header_gt gt
158: WHERE gt.ship_via IS NOT NULL
159: AND NOT EXISTS
192: trx_header_id,
193: error_message,
194: invalid_value)
195: SELECT trx_header_id,
196: arp_standard.fnd_message('AR_INAPI_INVALID_FOB'),
197: fob_point
198: FROM ar_trx_header_gt gt
199: WHERE gt.fob_point IS NOT NULL
200: AND NOT EXISTS
234: trx_header_id,
235: error_message,
236: invalid_value)
237: SELECT trx_header_id,
238: arp_standard.fnd_message('AR_INAPI_INVALID_USSGL_CODE'),
239: default_ussgl_transaction_code
240: FROM ar_trx_header_gt gt
241: WHERE gt.default_ussgl_transaction_code IS NOT NULL
242: AND NOT EXISTS
277: trx_header_id,
278: error_message,
279: invalid_value)
280: SELECT trx_header_id,
281: arp_standard.fnd_message('AR_INVALID_PAYMENT_METHOD'),
282: receipt_method_id
283: FROM ar_trx_header_gt gt
284: WHERE gt.receipt_method_id IS NOT NULL
285: AND NOT EXISTS
293: trx_header_id,
294: error_message,
295: invalid_value)
296: SELECT trx_header_id,
297: arp_standard.fnd_message('AR_BOE_OBSOLETE'),
298: receipt_method_id
299: FROM ar_trx_header_gt gt
300: WHERE gt.receipt_method_id IS NOT NULL
301: AND arpt_sql_func_util.check_boe_paymeth(gt.receipt_method_id) = 'Y';
306: trx_header_id,
307: error_message,
308: invalid_value)
309: SELECT trx_header_id,
310: arp_standard.fnd_message('AR_INVALID_PAYMENT_METHOD'),
311: receipt_method_id
312: FROM ar_trx_header_gt gt
313: WHERE gt.payment_trxn_extension_id IS NOT NULL
314: AND EXISTS
323: trx_header_id,
324: error_message,
325: invalid_value)
326: SELECT trx_header_id,
327: arp_standard.fnd_message('AR_INVALID_PAYMENT_METHOD'),
328: receipt_method_id
329: FROM ar_trx_header_gt gt
330: WHERE gt.payment_trxn_extension_id IS NOT NULL
331: AND EXISTS
340: trx_header_id,
341: error_message,
342: invalid_value)
343: SELECT trx_header_id,
344: arp_standard.fnd_message('AR_INVALID_PAYMENT_METHOD'),
345: receipt_method_id
346: FROM ar_trx_header_gt gt
347: WHERE gt.receipt_method_id IS NOT NULL
348: AND gt.payment_trxn_extension_id IS NULL;
351: trx_header_id,
352: error_message,
353: invalid_value)
354: SELECT trx_header_id,
355: arp_standard.fnd_message('AR_INVALID_PAYMENT_METHOD'),
356: receipt_method_id
357: FROM ar_trx_header_gt gt
358: WHERE gt.receipt_method_id IS NULL
359: AND gt.payment_trxn_extension_id IS NOT NULL;
388: trx_header_id,
389: error_message,
390: invalid_value)
391: SELECT trx_header_id,
392: arp_standard.fnd_message('AR_INVALID_LEGAL_ENTITY'),
393: legal_entity_id
394: FROM ar_trx_header_gt gt
395: WHERE gt.legal_entity_id IS NOT NULL
396: AND NOT EXISTS (
447: trx_header_id,
448: error_message,
449: invalid_value)
450: SELECT trx_header_id,
451: arp_standard.fnd_message('AR_INAPI_INVALID_PAYING_CUS_ID'),
452: paying_customer_id
453: FROM ar_trx_header_gt gt
454: WHERE gt.paying_customer_id IS NOT NULL
455: AND NOT EXISTS (
463: trx_header_id,
464: error_message,
465: invalid_value)
466: SELECT trx_header_id,
467: arp_standard.fnd_message('AR_INAPI_INVALID_PAYING_CUS_ID'),
468: paying_customer_id
469: FROM ar_trx_header_gt gt
470: WHERE gt.paying_customer_id IS NOT NULL
471: AND NOT EXISTS
523: trx_header_id,
524: error_message,
525: invalid_value)
526: SELECT trx_header_id,
527: arp_standard.fnd_message('AR_INAPI_INVALID_PAYING_SIT_ID'),
528: paying_site_use_id
529: FROM ar_trx_header_gt gt
530: WHERE gt.paying_site_use_id IS NOT NULL
531: AND NOT EXISTS
569: trx_header_id,
570: error_message,
571: invalid_value)
572: SELECT trx_header_id,
573: arp_standard.fnd_message('AR_DAPI_SOLD_CUST_ID_INVALID'),
574: sold_to_customer_id
575: FROM ar_trx_header_gt gt
576: WHERE gt.sold_to_customer_id IS NOT NULL
577: AND NOT EXISTS
610: trx_header_id,
611: error_message,
612: invalid_value)
613: SELECT trx_header_id,
614: arp_standard.fnd_message('AR_INAPI_INV_SHIP_TO_CUST_NAME'),
615: ship_to_customer_name
616: FROM ar_trx_header_gt gt
617: WHERE gt.ship_to_customer_name IS NOT NULL
618: AND NOT EXISTS
652: trx_header_id,
653: error_message,
654: invalid_value)
655: SELECT trx_header_id,
656: arp_standard.fnd_message('AR_INAPI_INV_SHIP_TO_CUST_NUM'),
657: ship_to_account_number
658: FROM ar_trx_header_gt gt
659: WHERE gt.ship_to_account_number IS NOT NULL
660: AND NOT EXISTS
692: trx_header_id,
693: error_message,
694: invalid_value)
695: SELECT trx_header_id,
696: arp_standard.fnd_message('AR_INAPI_INV_BILL_TO_CUST_NAME'),
697: bill_to_customer_name
698: FROM ar_trx_header_gt gt
699: WHERE gt.bill_to_customer_name IS NOT NULL
700: AND NOT EXISTS
734: trx_header_id,
735: error_message,
736: invalid_value)
737: SELECT trx_header_id,
738: arp_standard.fnd_message('AR_INAPI_INV_BILL_TO_CUST_NUM'),
739: bill_to_account_number
740: FROM ar_trx_header_gt gt
741: WHERE gt.bill_to_account_number IS NOT NULL
742: AND NOT EXISTS
774: trx_header_id,
775: error_message,
776: invalid_value)
777: SELECT trx_header_id,
778: arp_standard.fnd_message('AR_INAPI_BAD_BLL_TO_CONTACT_ID'),
779: bill_to_contact_id
780: FROM ar_trx_header_gt gt
781: WHERE gt.bill_to_contact_id IS NOT NULL
782: AND NOT EXISTS
829: trx_header_id,
830: error_message,
831: invalid_value)
832: SELECT trx_header_id,
833: arp_standard.fnd_message('AR_INAPI_BAD_SHP_TO_CONTACT_ID'),
834: ship_to_contact_id
835: FROM ar_trx_header_gt gt
836: WHERE gt.ship_to_contact_id IS NOT NULL
837: AND NOT EXISTS
884: trx_header_id,
885: error_message,
886: invalid_value)
887: SELECT trx_header_id,
888: arp_standard.fnd_message('AR_INAPI_INV_XCHNG_RATE_TYPE'),
889: exchange_rate_type
890: FROM ar_trx_header_gt gt
891: WHERE gt.exchange_rate_type IS NOT NULL
892: AND NOT EXISTS
967: error_message,
968: invalid_value)
969: VALUES
970: (header_rec.trx_header_id,
971: arp_standard.fnd_message('AR', 'AR_RAPI_DOC_SEQ_AUTOMATIC'),
972: header_rec.doc_sequence_value);
973:
974: END IF;
975:
989: trx_header_id,
990: error_message,
991: invalid_value)
992: SELECT trx_header_id,
993: arp_standard.fnd_message('AR_TAPI_BFB_BILLING_DATE_REQD'),
994: billing_date
995: FROM ar_trx_header_gt
996: WHERE term_id IS NOT NULL
997: AND billing_date IS NULL
1003: trx_header_id,
1004: error_message,
1005: invalid_value)
1006: SELECT trx_header_id,
1007: arp_standard.fnd_message('AR_TAPI_BFB_OPEN_REC'),
1008: term_id
1009: FROM ar_trx_header_gt
1010: WHERE term_id IS NOT NULL
1011: AND cust_trx_type_id IS NOT NULL
1017: trx_header_id,
1018: error_message,
1019: invalid_value)
1020: SELECT trx_header_id,
1021: arp_standard.fnd_message('AR_TAPI_BFB_BILLING_DATE_INV'),
1022: billing_date
1023: FROM ar_trx_header_gt
1024: WHERE term_id IS NOT NULL
1025: AND billing_date IS NOT NULL
1066: error_message,
1067: invalid_value)
1068: SELECT trx_header_id,
1069: DECODE(b.auto_trx_numbering_flag, 'Y',
1070: arp_standard.fnd_message('AR_INAPI_TRX_NUM_NOT_REQUIRED'),
1071: arp_standard.fnd_message('AR_TW_NULL_TRX_NUMBER')),
1072: trx_number
1073: FROM ar_trx_header_gt gt,
1074: ra_batch_sources b
1067: invalid_value)
1068: SELECT trx_header_id,
1069: DECODE(b.auto_trx_numbering_flag, 'Y',
1070: arp_standard.fnd_message('AR_INAPI_TRX_NUM_NOT_REQUIRED'),
1071: arp_standard.fnd_message('AR_TW_NULL_TRX_NUMBER')),
1072: trx_number
1073: FROM ar_trx_header_gt gt,
1074: ra_batch_sources b
1075: WHERE b.batch_source_id = gt.batch_source_id
1085: trx_header_id,
1086: error_message,
1087: invalid_value)
1088: SELECT trx_header_id,
1089: arp_standard.fnd_message('AR_INAPI_BANK_ACC_NOT_REQUIRED'),
1090: customer_bank_account_id
1091: FROM ar_trx_header_gt gt
1092: WHERE gt.customer_bank_account_id IS NOT NULL
1093: AND NOT EXISTS (
1105: trx_header_id,
1106: error_message,
1107: invalid_value)
1108: SELECT trx_header_id,
1109: arp_standard.fnd_message('AR_INAPI_PAYING_SITE_REQUIRED'),
1110: paying_customer_id
1111: FROM ar_trx_header_gt gt
1112: WHERE gt.paying_customer_id IS NOT NULL
1113: AND gt.paying_site_use_id IS NULL;
1120: trx_header_id,
1121: error_message,
1122: invalid_value)
1123: SELECT trx_header_id,
1124: arp_standard.fnd_message('AR_INAPI_PO_REQUIRED'),
1125: paying_customer_id
1126: FROM ar_trx_header_gt gt
1127: WHERE (gt.purchase_order_revision IS NOT NULL
1128: OR gt.purchase_order_date IS NOT NULL)
1137: error_message,
1138: invalid_value)
1139: SELECT lgt.trx_header_id,
1140: lgt.trx_line_id,
1141: arp_standard.fnd_message('AR_INAPI_RULE_INFO_UNNECESSARY'),
1142: NVL(lgt.accounting_rule_id, lgt.accounting_rule_duration)
1143: FROM ar_trx_lines_gt lgt,
1144: ar_trx_header_gt hgt
1145: WHERE (lgt.accounting_rule_id IS NOT NULL
1154: error_message,
1155: invalid_value)
1156: SELECT trx_header_id,
1157: trx_line_id,
1158: arp_standard.fnd_message('AR_INAPI_INV_MASTER_LINE_TYPE'),
1159: link_to_trx_line_id
1160: FROM ar_trx_lines_gt gt
1161: WHERE gt.link_to_trx_line_id IS NOT NULL
1162: AND NOT EXISTS
1172: error_message,
1173: invalid_value)
1174: SELECT trx_header_id,
1175: trx_line_id,
1176: arp_standard.fnd_message('AR_INAPI_INVALID_SUB_LINE_TYPE'),
1177: link_to_trx_line_id
1178: FROM ar_trx_lines_gt gt
1179: WHERE gt.link_to_trx_line_id IS NOT NULL
1180: AND gt.line_type NOT IN ('TAX', 'FREIGHT');
1187: trx_header_id,
1188: error_message,
1189: invalid_value)
1190: SELECT trx_header_id,
1191: arp_standard.fnd_message('AR_TAPI_EXCHANGE_RATE_REQUIRED'),
1192: gt.trx_currency
1193: FROM ar_trx_header_gt gt
1194: WHERE gt.trx_currency IS NOT NULL
1195: AND ( exchange_rate IS NULL
1203: trx_header_id,
1204: error_message,
1205: invalid_value)
1206: SELECT trx_header_id,
1207: arp_standard.fnd_message('AR_INAPI_RATE_NOT_REQUIRED2'),
1208: exchange_rate
1209: FROM ar_trx_header_gt
1210: WHERE exchange_rate IS NOT NULL
1211: AND exchange_rate_type <> 'User';
1216: trx_header_id,
1217: error_message,
1218: invalid_value)
1219: SELECT trx_header_id,
1220: arp_standard.fnd_message('AR_TAPI_EXCHG_INFO_NOT_ALLOWED'),
1221: trx_currency
1222: FROM ar_trx_header_gt
1223: WHERE ( exchange_rate IS NOT NULL
1224: OR exchange_rate_type IS NOT NULL
1233: error_message,
1234: invalid_value)
1235: SELECT trx_header_id,
1236: trx_line_id,
1237: arp_standard.fnd_message('AR_TAX_CHOOSE_YES_NO'),
1238: amount_includes_tax_flag
1239: FROM ar_trx_lines_gt lgt
1240: WHERE amount_includes_tax_flag IS NOT NULL
1241: AND amount_includes_tax_flag NOT IN ('Y', 'N');
1268: trx_header_id,
1269: error_message,
1270: invalid_value)
1271: SELECT trx_header_id,
1272: arp_standard.fnd_message('AR_TW_NO_LINES'),
1273: null
1274: FROM ar_trx_header_gt gt
1275: WHERE NOT EXISTS
1276: (SELECT 'X'
1284: error_message,
1285: invalid_value)
1286: SELECT trx_header_id,
1287: trx_line_id,
1288: arp_standard.fnd_message('AR_INAPI_ORPHAN_LINES'),
1289: null
1290: FROM ar_trx_lines_gt lgt
1291: WHERE NOT EXISTS
1292: (SELECT 'X'
1300: error_message,
1301: invalid_value)
1302: SELECT trx_header_id,
1303: trx_line_id,
1304: arp_standard.fnd_message('AR_INAPI_LINE_NUMS_NOT_UNIQUE'),
1305: lgt.line_number
1306: FROM ar_trx_lines_gt lgt
1307: WHERE EXISTS
1308: (SELECT 'X'
1320: error_message,
1321: invalid_value)
1322: SELECT trx_header_id,
1323: trx_line_id,
1324: arp_standard.fnd_message('AR_INAPI_LINE_ID_NOT_UNIQUE'),
1325: null
1326: FROM ar_trx_lines_gt lgt
1327: WHERE EXISTS
1328: (SELECT 'X'
1337: trx_header_id,
1338: error_message,
1339: invalid_value)
1340: SELECT trx_header_id,
1341: arp_standard.fnd_message('AR_INAPI_HEADER_ID_NOT_UNIQUE'),
1342: null
1343: FROM ar_trx_header_gt hgt
1344: WHERE EXISTS
1345: (SELECT 'X'
1383: trx_header_id,
1384: error_message,
1385: invalid_value)
1386: SELECT trx_header_id,
1387: arp_standard.fnd_message('AR_TW_INVALID_TRX_NUMBER'),
1388: trx_number
1389: FROM ar_trx_header_gt gt
1390: WHERE gt.trx_number IS NOT NULL
1391: AND gt.batch_source_id IS NOT NULL
1454: trx_header_id,
1455: error_message,
1456: invalid_value)
1457: SELECT trx_header_id,
1458: arp_standard.fnd_message('AR_INAPI_INVALID_BATCH_SOURCE'),
1459: batch_source_id
1460: FROM ar_trx_header_gt gt
1461: WHERE NOT EXISTS (
1462: SELECT 'X'
1500: ( trx_header_id,
1501: error_message,
1502: invalid_value)
1503: SELECT trx_header_id,
1504: arp_standard.fnd_message('AR_INVALID_CURRENCY'),
1505: trx_currency
1506: FROM ar_trx_header_gt gt
1507: WHERE gt.trx_currency IS NOT NULL
1508: AND NOT EXISTS (
1538: trx_header_id,
1539: error_message,
1540: invalid_value)
1541: SELECT trx_header_id,
1542: arp_standard.fnd_message('AR_BR_TRX_TYPE_NULL'),
1543: cust_trx_type_id
1544: FROM ar_trx_header_gt gt
1545: WHERE gt.cust_trx_type_id IS NULL;
1546:
1548: trx_header_id,
1549: error_message,
1550: invalid_value)
1551: SELECT trx_header_id,
1552: arp_standard.fnd_message('AR_INVALID_TRX_TYPE'),
1553: cust_trx_type_id
1554: FROM ar_trx_header_gt gt
1555: WHERE gt.cust_trx_type_id IS NOT NULL
1556: AND NOT EXISTS (
1589: trx_header_id,
1590: error_message,
1591: invalid_value)
1592: SELECT trx_header_id,
1593: arp_standard.fnd_message('AR_INAPI_INV_BILL_TO_CUST_ID'),
1594: bill_to_customer_id
1595: FROM ar_trx_header_gt gt
1596: WHERE gt.bill_to_customer_id IS NOT NULL
1597: AND NOT EXISTS (
1627: trx_header_id,
1628: error_message,
1629: invalid_value)
1630: SELECT trx_header_id,
1631: arp_standard.fnd_message('AR_INAPI_INV_BILL_TO_SITE_USE'),
1632: bill_to_site_use_id
1633: FROM ar_trx_header_gt gt
1634: WHERE gt.bill_to_site_use_id IS NOT NULL
1635: AND NOT EXISTS (
1673: trx_header_id,
1674: error_message,
1675: invalid_value)
1676: SELECT trx_header_id,
1677: arp_standard.fnd_message('AR_INAPI_INVALID_BILL_ADDR_ID'),
1678: bill_to_address_id
1679: FROM ar_trx_header_gt gt
1680: WHERE gt.bill_to_address_id IS NOT NULL
1681: AND NOT EXISTS (
1728: trx_header_id,
1729: error_message,
1730: invalid_value)
1731: SELECT trx_header_id,
1732: arp_standard.fnd_message('AR_INAPI_INV_SHIP_TO_CUST_ID'),
1733: ship_to_customer_id
1734: FROM ar_trx_header_gt gt
1735: WHERE gt.ship_to_customer_id IS NOT NULL
1736: AND NOT EXISTS (
1768: trx_header_id,
1769: error_message,
1770: invalid_value)
1771: SELECT trx_header_id,
1772: arp_standard.fnd_message('AR_INAPI_INVALID_SHIP_SITE_USE'),
1773: ship_to_site_use_id
1774: FROM ar_trx_header_gt gt
1775: WHERE gt.ship_to_site_use_id IS NOT NULL
1776: AND gt.ship_to_customer_id IS NOT NULL
1787: trx_header_id,
1788: error_message,
1789: invalid_value)
1790: SELECT trx_header_id,
1791: arp_standard.fnd_message('AR_INAPI_NULL_SHIP_TO_SITE'),
1792: ship_to_site_use_id
1793: FROM ar_trx_header_gt gt
1794: WHERE gt.ship_to_site_use_id IS NULL
1795: AND gt.ship_to_customer_id IS NOT NULL;
1820: trx_header_id,
1821: error_message,
1822: invalid_value)
1823: SELECT trx_header_id,
1824: arp_standard.fnd_message('AR_INAPI_INVALID_SHIP_SITE_USE'),
1825: ship_to_site_use_id
1826: FROM ar_trx_header_gt gt
1827: WHERE gt.ship_to_site_use_id IS NOT NULL
1828: AND NOT EXISTS (
1937: trx_header_id,
1938: error_message,
1939: invalid_value)
1940: SELECT trx_header_id,
1941: arp_standard.fnd_message('AR_INAPI_INVALID_SHIP_SITE_USE'),
1942: gt.ship_to_site_use_id
1943: FROM ar_trx_header_gt gt
1944: WHERE gt.ship_to_customer_id IS NOT NULL
1945: AND gt.ship_to_site_use_id IS NOT NULL
1992: trx_header_id,
1993: error_message,
1994: invalid_value)
1995: SELECT gt.trx_header_id,
1996: arp_standard.fnd_message('AR_INVALID_TERM'),
1997: gt.term_id
1998: FROM ar_trx_header_gt gt,
1999: ra_cust_trx_types ctt
2000: WHERE gt.term_id IS NOT NULL
2015: trx_header_id,
2016: error_message,
2017: invalid_value)
2018: SELECT gt.trx_header_id,
2019: arp_standard.fnd_message('AR_INAPI_TERM_NOT_ALLOWED'),
2020: gt.term_id
2021: FROM ar_trx_header_gt gt,
2022: ra_cust_trx_types ctt
2023: WHERE gt.term_id IS NOT NULL
2029: trx_header_id,
2030: error_message,
2031: invalid_value)
2032: SELECT trx_header_id,
2033: arp_standard.fnd_message('AR_TAPI_BFB_INVALID_TERM'),
2034: term_id
2035: FROM ar_trx_header_gt gt
2036: WHERE gt.term_id IS NOT NULL
2037: AND ar_bfb_utils_pvt.is_payment_term_bfb(term_id) = 'Y'
2070: trx_header_id,
2071: error_message,
2072: invalid_value)
2073: SELECT trx_header_id,
2074: arp_standard.fnd_message('AR_INVALID_PRIMARY_SALESREP'),
2075: primary_salesrep_id
2076: FROM ar_trx_header_gt gt
2077: WHERE gt.primary_salesrep_id IS NOT NULL
2078: AND NOT EXISTS (
2110: trx_header_id,
2111: error_message,
2112: invalid_value)
2113: SELECT trx_header_id,
2114: arp_standard.fnd_message(l_message_name),
2115: primary_salesrep_id
2116: FROM ar_trx_header_gt gt
2117: WHERE gt.primary_salesrep_id IS NOT NULL
2118: AND NOT EXISTS (
2131: trx_header_id,
2132: error_message,
2133: invalid_value)
2134: SELECT trx_header_id,
2135: arp_standard.fnd_message(l_message_name),
2136: primary_salesrep_id
2137: FROM ar_trx_header_gt gt
2138: WHERE gt.primary_salesrep_id IS NULL
2139: AND p_trx_system_param_rec.salesrep_required_flag = 'Y';
2169: trx_header_id,
2170: error_message,
2171: invalid_value)
2172: SELECT trx_header_id,
2173: arp_standard.fnd_message('AR_INAPI_INV_RULE_NOT_REQUIRED'),
2174: invoicing_rule_id
2175: FROM ar_trx_header_gt gt
2176: WHERE gt.invoicing_rule_id IS NOT NULL
2177: AND gt.cust_trx_type_id NOT IN (
2184: trx_header_id,
2185: error_message,
2186: invalid_value)
2187: SELECT trx_header_id,
2188: arp_standard.fnd_message('AR_INAPI_INVALID_INV_RULE_ID'),
2189: invoicing_rule_id
2190: FROM ar_trx_header_gt gt
2191: WHERE gt.invoicing_rule_id IS NOT NULL
2192: AND gt.invoicing_rule_id not in ( -2, -3);
2222: trx_header_id,
2223: error_message,
2224: invalid_value)
2225: SELECT trx_header_id,
2226: arp_standard.fnd_message('AR_INAPI_INVALID_PRINT_OPTION'),
2227: printing_option
2228: FROM ar_trx_header_gt gt
2229: WHERE gt.printing_option IS NOT NULL
2230: AND gt.printing_option NOT IN ( 'PRI', 'NOT');
2307: trx_header_id,
2308: error_message,
2309: invalid_value)
2310: SELECT trx_header_id,
2311: arp_standard.fnd_message('AR_INAPI_INV_TAX_EXEMPT_FLAG'),
2312: default_tax_exempt_flag
2313: FROM ar_trx_header_gt gt
2314: WHERE default_tax_exempt_flag IS NOT NULL
2315: AND NOT EXISTS (
2351: trx_header_id,
2352: error_message,
2353: invalid_value)
2354: SELECT trx_header_id,
2355: arp_standard.fnd_message('AR_INAPI_INVALID_TRX_STATUS'),
2356: status_trx
2357: FROM ar_trx_header_gt
2358: WHERE status_trx IS NOT NULL
2359: AND status_trx not in ( 'OP','CL','PEN','VD');
2388: trx_header_id,
2389: error_message,
2390: invalid_value)
2391: SELECT trx_header_id,
2392: arp_standard.fnd_message('AR_INAPI_INVALID_FIN_CHARGE'),
2393: finance_charges
2394: FROM ar_trx_header_gt
2395: WHERE finance_charges IS NOT NULL
2396: AND finance_charges not in ( 'Y','N');
2427: trx_header_id,
2428: error_message,
2429: invalid_value)
2430: SELECT trx_header_id,
2431: arp_standard.fnd_message('AR_INAPI_INAVLID_CROSS_REF'),
2432: related_customer_trx_id
2433: FROM ar_trx_header_gt gt
2434: WHERE gt.related_customer_trx_id IS NOT NULL
2435: AND NOT EXISTS (
2523: error_message,
2524: invalid_value)
2525: values
2526: ( cglDateRec.trx_header_id,
2527: arp_standard.fnd_message('AR_INAPI_NO_PERIOD_FOR_GL_DATE'),
2528: cglDateRec.gl_date );
2529: END IF;
2530:
2531: IF cglDateRec.invoicing_rule_id IS NOT NULL
2539: error_message,
2540: invalid_value)
2541: values
2542: ( cglDateRec.trx_header_id,
2543: arp_standard.fnd_message('AR_INAPI_BAD_GL_DATE_FOR_ADV'),
2544: cglDateRec.gl_date );
2545: END IF;
2546: ELSIF cglDateRec.invoicing_rule_id = -3
2547: THEN
2552: error_message,
2553: invalid_value)
2554: values
2555: ( cglDateRec.trx_header_id,
2556: arp_standard.fnd_message('AR_INAPI_BAD_GL_DATE_FOR_ARR'),
2557: cglDateRec.gl_date );
2558: END IF;
2559: END IF;
2560: END IF;
2566: error_message,
2567: invalid_value)
2568: values
2569: ( cglDateRec.trx_header_id,
2570: arp_standard.fnd_message('AR_TAPI_NO_PERIOD_FOR_GL_DATE'),
2571: cglDateRec.gl_date );
2572:
2573: END;
2574: ELSE
2581: error_message,
2582: invalid_value)
2583: values
2584: ( cglDateRec.trx_header_id,
2585: arp_standard.fnd_message('AR_RAXTRX-1785'),
2586: cglDateRec.gl_date );
2587:
2588: END IF;
2589: END IF;
2616: trx_header_id,
2617: error_message,
2618: invalid_value)
2619: SELECT trx_header_id,
2620: arp_standard.fnd_message('AR_INAPI_INVALID_AGREEMENT_ID'),
2621: agreement_id
2622: FROM ar_trx_header_gt gt
2623: WHERE gt.agreement_id IS NOT NULL
2624: AND NOT EXISTS (
2739: trx_header_id,
2740: error_message,
2741: invalid_value)
2742: SELECT gt.trx_header_id,
2743: arp_standard.fnd_message('AR_INAPI_INVALID_BATCH_SOURCE'),
2744: gt.batch_source_id
2745: FROM ar_trx_header_gt gt;
2746: WHEN OTHERS THEN
2747: x_errmsg := 'Error in AR_INVOICE_UTILS.Get_batch_source_details '||sqlerrm;
2838: trx_header_id,
2839: error_message,
2840: invalid_value)
2841: SELECT gt.trx_header_id,
2842: arp_standard.fnd_message('ARTA_INVALID_TRX_TYPE'),
2843: gt.cust_trx_type_id
2844: FROM ar_trx_header_gt gt
2845: WHERE gt.cust_trx_type_id = cust_trx_type_rec.cust_trx_type_id;
2846:
3703: AND cp2.cust_account_id = gt.bill_to_customer_id
3704: AND su.site_use_id = cp1.site_use_id(+)
3705: AND cp2.site_use_id IS NULL
3706: AND su.payment_term_id = t_su.term_id(+)
3707: AND cp1.standard_terms = t_cp1.term_id(+)
3708: AND cp2.standard_terms = t_cp2.term_id(+)
3709: AND NVL(
3710: t_su.term_id,
3711: NVL(
3704: AND su.site_use_id = cp1.site_use_id(+)
3705: AND cp2.site_use_id IS NULL
3706: AND su.payment_term_id = t_su.term_id(+)
3707: AND cp1.standard_terms = t_cp1.term_id(+)
3708: AND cp2.standard_terms = t_cp2.term_id(+)
3709: AND NVL(
3710: t_su.term_id,
3711: NVL(
3712: t_cp1.term_id,
3834: trx_header_id,
3835: error_message,
3836: invalid_value)
3837: SELECT trx_header_id,
3838: arp_standard.fnd_message('AR_INAPI_INV_BILL_TO_CUST_ID'),
3839: bill_to_address_id
3840: FROM ar_trx_header_gt gt
3841: WHERE gt.bill_to_customer_id IS NULL;
3842: END IF;
3865: trx_header_id,
3866: error_message,
3867: invalid_value)
3868: SELECT trx_header_id,
3869: arp_standard.fnd_message('AR_INAPI_INVALID_BILL_ADDR_ID'),
3870: bill_to_address_id
3871: FROM ar_trx_header_gt gt
3872: WHERE gt.bill_to_address_id IS NULL;
3873: END IF;
4039: error_message,
4040: invalid_value )
4041: SELECT trx_header_id,
4042: trx_line_id,
4043: arp_standard.fnd_message('AR_INAPI_UOM_NOT_REQ'),
4044: gt.uom_code
4045: FROM ar_trx_lines_gt gt
4046: WHERE gt.uom_code IS NOT NULL
4047: AND gt.line_type <> 'LINE';
4054: error_message,
4055: invalid_value )
4056: SELECT gt.trx_header_id,
4057: gt.trx_line_id,
4058: arp_standard.fnd_message('AR_INAPI_CM_UOM_NOT_ALLOWED'),
4059: gt.uom_code
4060: FROM ar_trx_lines_gt gt, ar_trx_header_gt gt2
4061: WHERE gt.uom_code IS NOT NULL
4062: AND gt.line_type = 'LINE'
4069: error_message,
4070: invalid_value )
4071: SELECT gt.trx_header_id,
4072: gt.trx_line_id,
4073: arp_standard.fnd_message('AR_INAPI_INVALID_UOM'),
4074: gt.uom_code
4075: FROM ar_trx_lines_gt gt , ar_trx_header_gt gt2
4076: WHERE gt.uom_code IS NOT NULL
4077: AND gt.line_type = 'LINE'
4154: error_message,
4155: invalid_value )
4156: SELECT trx_header_id,
4157: trx_line_id,
4158: arp_standard.fnd_message('AR_INAPI_INVALID_TAX_LINE'),
4159: gt.vat_tax_id
4160: FROM ar_trx_lines_gt gt
4161: WHERE extended_amount IS NULL
4162: AND line_type in ('TAX', 'FREIGHT');
4167: error_message,
4168: invalid_value )
4169: SELECT trx_header_id,
4170: trx_line_id,
4171: arp_standard.fnd_message('AR_INAPI_QTY_NOT_ALLOWED'),
4172: gt.vat_tax_id
4173: FROM ar_trx_lines_gt gt
4174: WHERE line_type in ('TAX', 'FREIGHT')
4175: AND (quantity_invoiced IS NOT NULL
4183: error_message,
4184: invalid_value )
4185: SELECT trx_header_id,
4186: trx_line_id,
4187: arp_standard.fnd_message('AR_RAXTRX-1706B'),
4188: gt.tax_regime_code || ', ' ||
4189: gt.tax || ', ' ||
4190: gt.tax_status_code || ', ' ||
4191: gt.tax_rate_code || ', ' ||
4245: error_message,
4246: invalid_value )
4247: SELECT trx_header_id,
4248: trx_line_id,
4249: arp_standard.fnd_message('AR_INAPI_INV_TAX_EXEMPT_FLAG'),
4250: tax_exempt_flag
4251: FROM ar_trx_lines_gt
4252: WHERE tax_exempt_flag IS NOT NULL
4253: AND NOT EXISTS
4269: trx_line_id,
4270: error_message)
4271: SELECT trx_header_id,
4272: trx_line_id,
4273: arp_standard.fnd_message('AR_INAPI_REASON_NOT_REQ')
4274: FROM ar_trx_lines_gt
4275: WHERE tax_exempt_flag = 'E'
4276: AND TAX_EXEMPT_REASON_CODE IS NULL;
4277:
4288: error_message,
4289: invalid_value)
4290: SELECT trx_header_id,
4291: trx_line_id,
4292: arp_standard.fnd_message('AR_INAPI_INVALID_TAX_EXEMPT_CODE'),
4293: TAX_EXEMPT_REASON_CODE
4294: FROM ar_trx_lines_gt
4295: WHERE TAX_EXEMPT_REASON_CODE IS NOT null
4296: AND NOT EXISTS (
4334: error_message,
4335: invalid_value )
4336: SELECT trx_header_id,
4337: trx_line_id,
4338: arp_standard.fnd_message('AR_INAPI_REASON_NOT_REQ'),
4339: gt.reason_code
4340: FROM ar_trx_lines_gt gt
4341: WHERE gt.reason_code IS NOT NULL
4342: AND gt.line_type = 'TAX';
4348: error_message,
4349: invalid_value )
4350: SELECT trx_header_id,
4351: trx_line_id,
4352: arp_standard.fnd_message('AR_INAPI_INVALID_REASON'),
4353: gt.reason_code
4354: FROM ar_trx_lines_gt gt
4355: WHERE gt.reason_code IS NOT NULL
4356: AND NOT EXISTS (
4390: INSERT INTO ar_trx_errors_gt
4391: ( trx_header_id,
4392: error_message)
4393: SELECT trx_header_id,
4394: arp_standard.fnd_message('AR_INAPI_INV_DESC_NULL')
4395: FROM ar_trx_lines_gt gt
4396: WHERE gt.description IS NULL
4397: AND gt.inventory_item_id IS NULL
4398: AND gt.memo_line_id IS NULL
4403: trx_line_id,
4404: error_message)
4405: SELECT trx_header_id,
4406: trx_line_id,
4407: arp_standard.fnd_message('AR_DAPI_MEMO_NAME_INVALID')
4408: FROM ar_trx_lines_gt gt
4409: WHERE gt.memo_line_id IS NOT NULL
4410: AND gt.line_type = 'LINE'
4411: AND NOT EXISTS (
4462: INSERT INTO ar_trx_errors_gt
4463: ( trx_header_id,
4464: error_message)
4465: SELECT gt.trx_header_id,
4466: arp_standard.fnd_message('AR_INAPI_QTY_NOT_NULL')
4467: FROM ar_trx_lines_gt gt ,
4468: ar_trx_header_gt gt2
4469: WHERE gt.quantity_invoiced IS NULL
4470: AND gt.trx_header_id = gt2.trx_header_id
4497: INSERT INTO ar_trx_errors_gt
4498: ( trx_header_id,
4499: error_message)
4500: SELECT gt.trx_header_id,
4501: arp_standard.fnd_message('AR_INAPI_UNIT_PRICE_NOT_NULL')
4502: FROM ar_trx_lines_gt gt ,
4503: ar_trx_header_gt gt2
4504: WHERE gt.unit_selling_price IS NULL
4505: AND gt.trx_header_id = gt2.trx_header_id
4530: ( trx_header_id,
4531: error_message,
4532: invalid_value )
4533: SELECT trx_header_id,
4534: arp_standard.fnd_message('AR_INAPI_INAVLID_LINE_TYPE'),
4535: gt.line_type
4536: FROM ar_trx_lines_gt gt
4537: WHERE gt.line_type not in ('LINE', 'TAX', 'FREIGHT');
4538: IF pg_debug = 'Y'
4561: INSERT INTO ar_trx_errors_gt
4562: ( trx_header_id,
4563: error_message)
4564: SELECT trx_header_id,
4565: arp_standard.fnd_message('AR_INAPI_LINE_NUM_NOT_NULL')
4566: FROM ar_trx_lines_gt gt
4567: WHERE gt.line_number IS NULL;
4568:
4569: -- check for duplicate line number
4616: trx_line_id,
4617: error_message)
4618: SELECT trx_header_id,
4619: trx_line_id,
4620: arp_standard.fnd_message('AR_INAPI_HDR_ID_NOT_NULL')
4621: FROM ar_trx_lines_gt gt
4622: WHERE gt.trx_header_id IS NULL
4623: OR gt.trx_line_id IS NULL;
4624:
4629: trx_line_id,
4630: error_message)
4631: SELECT trx_header_id,
4632: trx_line_id,
4633: arp_standard.fnd_message('AR_INAPI_LINK_LINE_ID_NOT_NULL')
4634: FROM ar_trx_lines_gt gt
4635: WHERE gt.line_type = 'TAX'
4636: AND gt.link_to_trx_line_id IS NULL;
4637:
4661: ( trx_header_id,
4662: error_message)
4663: VALUES
4664: ( c_freight_rec.trx_header_id,
4665: arp_standard.fnd_message('AR_TAPI_FREIGHT_NOT_ALLOWED'));
4666: END IF;
4667: END;
4668:
4669: IF ( c_freight_rec.number_of_freight_lines > 1 )
4695: INSERT INTO ar_trx_errors_gt
4696: ( trx_header_id,
4697: error_message)
4698: SELECT trx_header_id,
4699: arp_standard.fnd_message('AR_TAPI_TOO_MANY_FREIGHT_LINE')
4700: FROM ar_trx_header_gt gt
4701: WHERE gt.trx_header_id = c_freight_rec.trx_header_id;
4702: END IF;
4703: END IF;
4730: trx_line_id,
4731: error_message)
4732: SELECT trx_header_id,
4733: trx_line_id,
4734: arp_standard.fnd_message('AR_INAPI_INVALID_SHIP_VIA')
4735: FROM ar_trx_lines_gt gt
4736: WHERE gt.line_type = 'FREIGHT'
4737: AND gt.ship_via IS NOT NULL
4738: AND NOT EXISTS (
4748: trx_line_id,
4749: error_message)
4750: SELECT trx_header_id,
4751: trx_line_id,
4752: arp_standard.fnd_message('AR_INAPI_INVALID_FOB')
4753: FROM ar_trx_lines_gt gt
4754: WHERE gt.line_type = 'FREIGHT'
4755: AND gt.fob_point IS NOT NULL
4756: AND NOT EXISTS (
4766: trx_line_id,
4767: error_message)
4768: SELECT trx_header_id,
4769: trx_line_id,
4770: arp_standard.fnd_message('AR_INAPI_EXT_AMT_NOT_NULL')
4771: FROM ar_trx_lines_gt gt
4772: WHERE gt.line_type = 'FREIGHT'
4773: AND gt.extended_amount IS NULL;
4774:
4852: error_message)
4853: VALUES
4854: ( c_line_rec.trx_header_id,
4855: c_line_rec.trx_line_id,
4856: arp_standard.fnd_message('AR_INAPI_AMT_SIGN_INVALID'));
4857: END IF;
4858: ELSIF ( c_line_rec.creation_sign = 'N' ) THEN
4859: IF ( (NVL( c_line_rec.extended_amount, 0 ) > 0)
4860: OR ( NVL( c_line_rec.revenue_amount, 0 ) > 0 )) THEN
4864: error_message)
4865: VALUES
4866: ( c_line_rec.trx_header_id,
4867: c_line_rec.trx_line_id,
4868: arp_standard.fnd_message('AR_INAPI_AMT_SIGN_INVALID'));
4869: END IF;
4870: END IF;
4871:
4872: -- Check if amount matches quantity_invoiced*unit_selling_price
4882: error_message)
4883: VALUES
4884: ( c_line_rec.trx_header_id,
4885: c_line_rec.trx_line_id,
4886: arp_standard.fnd_message('AR_INAPI_AMT_INVALID'));
4887: END IF;
4888: END IF;
4889:
4890: END LOOP;
4916: INSERT INTO ar_trx_errors_gt
4917: ( trx_header_id,
4918: error_message)
4919: SELECT trx_header_id,
4920: arp_standard.fnd_message('AR_INAPI_DUP_DOC_SEQUENCE')
4921: FROM ar_trx_header_gt gt
4922: WHERE gt.cust_trx_type_id IS NOT NULL
4923: AND gt.doc_sequence_value IS NOT NULL
4924: AND EXISTS (
5057: error_message,
5058: invalid_value)
5059: VALUES
5060: ( ctrxHeaderRec.trx_header_id,
5061: arp_standard.fnd_message('AR_INAPI_DUP_DOC_SEQUENCE'),
5062: l_doc_sequence_value );
5063:
5064: l_seq_err := TRUE;
5065: END;
5173:
5174: BEGIN
5175:
5176:
5177: arp_standard.debug ( 'inside Copy payment trxn ');
5178:
5179: IF pg_debug = 'Y'
5180: THEN
5181: arp_standard.debug ( 'inside Copy payment trxn ');
5177: arp_standard.debug ( 'inside Copy payment trxn ');
5178:
5179: IF pg_debug = 'Y'
5180: THEN
5181: arp_standard.debug ( 'inside Copy payment trxn ');
5182: END IF;
5183: x_return_status := FND_API.G_RET_STS_SUCCESS;
5184:
5185: FOR ctrxHeaderRec IN ctrxHeader
5212: l_payer_rec.org_type := NULL;
5213:
5214: end if;
5215:
5216: l_trxn_attribs_rec.Originating_Application_Id := arp_standard.application_id;
5217: l_trxn_attribs_rec.order_id := ctrxHeaderRec.customer_trx_id ;
5218: l_trxn_attribs_rec.Trxn_Ref_Number1 := 'INVOICE';
5219: l_trxn_attribs_rec.Trxn_Ref_Number2 := ctrxHeaderRec.trx_number;
5220: l_assignment_id := l_assignment_id;
5220: l_assignment_id := l_assignment_id;
5221: l_pmt_trxn_extension_id(1) := ctrxHeaderRec.payment_trxn_extension_id;
5222:
5223:
5224: arp_standard.debug('l_payer.payment_function :<' || l_payer_rec.payment_function || '>');
5225: arp_standard.debug('l_payer.Party_Id :<' || l_payer_rec.Party_Id || '>');
5226: arp_standard.debug('l_payer.Org_Type :<' || l_payer_rec.Org_Type || '>');
5227: arp_standard.debug('l_payer.Org_id :<' || l_payer_rec.Org_id || '>');
5228: arp_standard.debug('l_payer.Cust_Account_Id :<' || l_payer_rec.Cust_Account_Id || '>');
5221: l_pmt_trxn_extension_id(1) := ctrxHeaderRec.payment_trxn_extension_id;
5222:
5223:
5224: arp_standard.debug('l_payer.payment_function :<' || l_payer_rec.payment_function || '>');
5225: arp_standard.debug('l_payer.Party_Id :<' || l_payer_rec.Party_Id || '>');
5226: arp_standard.debug('l_payer.Org_Type :<' || l_payer_rec.Org_Type || '>');
5227: arp_standard.debug('l_payer.Org_id :<' || l_payer_rec.Org_id || '>');
5228: arp_standard.debug('l_payer.Cust_Account_Id :<' || l_payer_rec.Cust_Account_Id || '>');
5229: arp_standard.debug('l_trxn_attribs.order_id :<'|| l_trxn_attribs_rec.order_id || '>');
5222:
5223:
5224: arp_standard.debug('l_payer.payment_function :<' || l_payer_rec.payment_function || '>');
5225: arp_standard.debug('l_payer.Party_Id :<' || l_payer_rec.Party_Id || '>');
5226: arp_standard.debug('l_payer.Org_Type :<' || l_payer_rec.Org_Type || '>');
5227: arp_standard.debug('l_payer.Org_id :<' || l_payer_rec.Org_id || '>');
5228: arp_standard.debug('l_payer.Cust_Account_Id :<' || l_payer_rec.Cust_Account_Id || '>');
5229: arp_standard.debug('l_trxn_attribs.order_id :<'|| l_trxn_attribs_rec.order_id || '>');
5230: arp_standard.debug('l_assignment_id :<'|| l_assignment_id || '>');
5223:
5224: arp_standard.debug('l_payer.payment_function :<' || l_payer_rec.payment_function || '>');
5225: arp_standard.debug('l_payer.Party_Id :<' || l_payer_rec.Party_Id || '>');
5226: arp_standard.debug('l_payer.Org_Type :<' || l_payer_rec.Org_Type || '>');
5227: arp_standard.debug('l_payer.Org_id :<' || l_payer_rec.Org_id || '>');
5228: arp_standard.debug('l_payer.Cust_Account_Id :<' || l_payer_rec.Cust_Account_Id || '>');
5229: arp_standard.debug('l_trxn_attribs.order_id :<'|| l_trxn_attribs_rec.order_id || '>');
5230: arp_standard.debug('l_assignment_id :<'|| l_assignment_id || '>');
5231: arp_standard.debug('payment_trx_extension_id :<'|| l_pmt_trxn_extension_id(1) || '>');
5224: arp_standard.debug('l_payer.payment_function :<' || l_payer_rec.payment_function || '>');
5225: arp_standard.debug('l_payer.Party_Id :<' || l_payer_rec.Party_Id || '>');
5226: arp_standard.debug('l_payer.Org_Type :<' || l_payer_rec.Org_Type || '>');
5227: arp_standard.debug('l_payer.Org_id :<' || l_payer_rec.Org_id || '>');
5228: arp_standard.debug('l_payer.Cust_Account_Id :<' || l_payer_rec.Cust_Account_Id || '>');
5229: arp_standard.debug('l_trxn_attribs.order_id :<'|| l_trxn_attribs_rec.order_id || '>');
5230: arp_standard.debug('l_assignment_id :<'|| l_assignment_id || '>');
5231: arp_standard.debug('payment_trx_extension_id :<'|| l_pmt_trxn_extension_id(1) || '>');
5232:
5225: arp_standard.debug('l_payer.Party_Id :<' || l_payer_rec.Party_Id || '>');
5226: arp_standard.debug('l_payer.Org_Type :<' || l_payer_rec.Org_Type || '>');
5227: arp_standard.debug('l_payer.Org_id :<' || l_payer_rec.Org_id || '>');
5228: arp_standard.debug('l_payer.Cust_Account_Id :<' || l_payer_rec.Cust_Account_Id || '>');
5229: arp_standard.debug('l_trxn_attribs.order_id :<'|| l_trxn_attribs_rec.order_id || '>');
5230: arp_standard.debug('l_assignment_id :<'|| l_assignment_id || '>');
5231: arp_standard.debug('payment_trx_extension_id :<'|| l_pmt_trxn_extension_id(1) || '>');
5232:
5233: IBY_FNDCPT_TRXN_PUB.Copy_Transaction_Extension
5226: arp_standard.debug('l_payer.Org_Type :<' || l_payer_rec.Org_Type || '>');
5227: arp_standard.debug('l_payer.Org_id :<' || l_payer_rec.Org_id || '>');
5228: arp_standard.debug('l_payer.Cust_Account_Id :<' || l_payer_rec.Cust_Account_Id || '>');
5229: arp_standard.debug('l_trxn_attribs.order_id :<'|| l_trxn_attribs_rec.order_id || '>');
5230: arp_standard.debug('l_assignment_id :<'|| l_assignment_id || '>');
5231: arp_standard.debug('payment_trx_extension_id :<'|| l_pmt_trxn_extension_id(1) || '>');
5232:
5233: IBY_FNDCPT_TRXN_PUB.Copy_Transaction_Extension
5234: ( p_api_version => 1.0,
5227: arp_standard.debug('l_payer.Org_id :<' || l_payer_rec.Org_id || '>');
5228: arp_standard.debug('l_payer.Cust_Account_Id :<' || l_payer_rec.Cust_Account_Id || '>');
5229: arp_standard.debug('l_trxn_attribs.order_id :<'|| l_trxn_attribs_rec.order_id || '>');
5230: arp_standard.debug('l_assignment_id :<'|| l_assignment_id || '>');
5231: arp_standard.debug('payment_trx_extension_id :<'|| l_pmt_trxn_extension_id(1) || '>');
5232:
5233: IBY_FNDCPT_TRXN_PUB.Copy_Transaction_Extension
5234: ( p_api_version => 1.0,
5235: p_init_msg_list => FND_API.G_TRUE,
5249: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
5250:
5251: o_payment_trxn_extension_id := p_trxn_entity_id ;
5252:
5253: arp_standard.debug('the copied value of trx_entn is ' || o_payment_trxn_extension_id );
5254:
5255: UPDATE ar_trx_header_gt
5256: SET payment_trxn_extension_id = o_payment_trxn_extension_id
5257: WHERE trx_header_id = ctrxHeaderRec.trx_header_id;
5271: error_message,
5272: invalid_value)
5273: VALUES
5274: ( ctrxHeaderRec.trx_header_id,
5275: arp_standard.fnd_message('AR_CC_AUTH_FAILED'),
5276: ctrxHeaderRec.payment_trxn_extension_id );
5277:
5278: END IF;
5279:
5335: invalid_value)
5336: VALUES
5337: ( cItemFlexRec.trx_header_id,
5338: cItemFlexRec.trx_line_id,
5339: arp_standard.fnd_message('AR_INAPI_INVALID_ITEM_D'),
5340: cItemFlexRec.inventory_item_id );
5341: ELSE
5342: /*Bug 3844408*/
5343: /*This update should be fired only when the description isn't populated
5360: invalid_value)
5361: VALUES
5362: ( cItemFlexRec.trx_header_id,
5363: cItemFlexRec.trx_line_id,
5364: arp_standard.fnd_message('AR_INAPI_INVALID_ITEM_ID'),
5365: cItemFlexRec.inventory_item_id );
5366: END IF;
5367: END LOOP;
5368:
5407: error_message,
5408: invalid_value)
5409: VALUES
5410: ( cTerritoryRec.trx_header_id,
5411: arp_standard.fnd_message('AR_INAPI_INVALID_TERRITORY'),
5412: cTerritoryRec.territory_id );
5413: END IF;
5414: END LOOP;
5415: IF pg_debug = 'Y'
5440: error_message,
5441: Invalid_value )
5442: select l.trx_line_id,
5443: l.trx_header_id,
5444: arp_standard.fnd_message('AR_RAXTRX_INV_WAREHOUSE'),
5445: l.warehouse_id
5446: from ar_trx_lines_gt l
5447: where l.line_type = 'LINE'
5448: and l.warehouse_id is not null
5511: trx_line_id,
5512: error_message)
5513: SELECT gt.trx_header_id,
5514: gt.trx_line_id,
5515: arp_standard.fnd_message('AR_INAPI_INVALID_RULE_NAME')
5516: FROM ar_trx_lines_gt gt , ar_trx_header_gt gt2
5517: WHERE gt.accounting_rule_id IS NOT NULL
5518: AND gt2.trx_header_id = gt.trx_header_id
5519: AND gt2.trx_class <> 'CM' -- Added for ER 5869149
5529: trx_line_id,
5530: error_message)
5531: SELECT gt.trx_header_id,
5532: gt.trx_line_id,
5533: arp_standard.fnd_message('AR_INAPI_RULE_NAME_NOT_NULL')
5534: FROM ar_trx_lines_gt gt, ar_trx_header_gt gth
5535: WHERE gt.accounting_rule_id IS NULL
5536: AND gt.trx_header_id = gth.trx_header_id
5537: AND gth.invoicing_rule_id IS NOT NULL
5545: trx_line_id,
5546: error_message)
5547: SELECT gt.trx_header_id,
5548: gt.trx_line_id,
5549: arp_standard.fnd_message('AR_INAPI_RULE_NOT_ALLOWED')
5550: FROM ar_trx_lines_gt gt, ar_trx_header_gt gth
5551: WHERE (gt.accounting_rule_id IS NOT NULL
5552: OR gth.invoicing_rule_id IS NOT NULL)
5553: AND gt.trx_header_id = gth.trx_header_id
5565: trx_line_id,
5566: error_message) VALUES
5567: ( c_invoicing_rule_rec.trx_header_id,
5568: c_invoicing_rule_rec.trx_line_id,
5569: arp_standard.fnd_message('AR_INAPI_RULE_NAME_NOT_NULL') );
5570: --PPRR Accounting rule Validations
5571: ELSIF c_invoicing_rule_rec.type in ('PP_DR_ALL','PP_DR_PP') THEN
5572: IF c_invoicing_rule_rec.RULE_START_DATE IS NULL THEN
5573: INSERT INTO ar_trx_errors_gt
5575: trx_line_id,
5576: error_message) VALUES
5577: ( c_invoicing_rule_rec.trx_header_id,
5578: c_invoicing_rule_rec.trx_line_id,
5579: arp_standard.fnd_message('AR_RAXTRX_RULE_START_DT_NULL'));
5580: END IF;
5581:
5582: IF c_invoicing_rule_rec.RULE_END_DATE IS NULL THEN
5583: INSERT INTO ar_trx_errors_gt
5585: trx_line_id,
5586: error_message) VALUES
5587: ( c_invoicing_rule_rec.trx_header_id,
5588: c_invoicing_rule_rec.trx_line_id,
5589: arp_standard.fnd_message('AR_RAXTRX_RULE_END_DT_NULL'));
5590: END IF;
5591:
5592: IF c_invoicing_rule_rec.RULE_END_DATE < c_invoicing_rule_rec.RULE_START_DATE
5593: THEN
5596: trx_line_id,
5597: error_message) VALUES
5598: ( c_invoicing_rule_rec.trx_header_id,
5599: c_invoicing_rule_rec.trx_line_id,
5600: arp_standard.fnd_message('AR_RAXTRX_RSD_LT_RED'));
5601: ELSE
5602: UPDATE ar_trx_lines_gt a
5603: SET ACCOUNTING_RULE_DURATION =
5604: (SELECT COUNT(*)
5633: trx_line_id,
5634: error_message) VALUES
5635: ( c_invoicing_rule_rec.trx_header_id,
5636: c_invoicing_rule_rec.trx_line_id,
5637: arp_standard.fnd_message('AR_INAPI_RULE_DUR_NOT_NULL' ));
5638: ELSE
5639: UPDATE ar_trx_lines_gt
5640: SET ACCOUNTING_RULE_DURATION = c_invoicing_rule_rec.occurrences
5641: WHERE trx_line_id = c_invoicing_rule_rec.trx_line_id
5737: trx_line_id,
5738: error_message) VALUES
5739: ( c_invoicing_rule_rec.trx_header_id,
5740: c_invoicing_rule_rec.trx_line_id,
5741: arp_standard.fnd_message('AR_INAPI_RULE_START_DT_NO_NULL') );
5742: END IF;
5743: END IF;
5744: END IF;
5745: END;
5779: error_message,
5780: invalid_value)
5781: SELECT trx_header_id,
5782: trx_line_id,
5783: arp_standard.fnd_message('AR_INAPI_INVALID_USSGL_CODE'),
5784: default_ussgl_transaction_code
5785: FROM ar_trx_lines_gt gt
5786: WHERE gt.default_ussgl_transaction_code IS NOT NULL
5787: AND NOT EXISTS
5950: error_message,
5951: invalid_value)
5952: VALUES
5953: ( cExchangeRateRec.trx_header_id,
5954: arp_standard.fnd_message('AR_INAPI_NO_EXCH_DEFINE'),
5955: cExchangeRateRec.trx_currency);
5956:
5957: END;
5958: END LOOP;
5970: trx_header_id,
5971: error_message,
5972: invalid_value)
5973: SELECT trx_header_id,
5974: arp_standard.fnd_message('AR_EXCHANGE_RATE_NEEDED'),
5975: gt.trx_currency
5976: FROM ar_trx_header_gt gt
5977: WHERE gt.trx_currency IS NOT NULL
5978: AND ( exchange_rate IS NULL
6735: VALUES
6736: ( CccidRec.trx_header_id,
6737: CccidRec.trx_line_id,
6738: CccidRec.trx_dist_id,
6739: arp_standard.fnd_message('AR_INVALID_CCID'),
6740: CccidRec.code_combination_id);
6741: END IF;
6742: END LOOP;
6743: IF pg_debug = 'Y'
6780: error_message)
6781: SELECT d.trx_header_id,
6782: d.trx_line_id,
6783: D.trx_DIST_ID,
6784: arp_standard.fnd_message('AR_INAPI_CCID_NULL')
6785: FROM ar_trx_DIST_gt D
6786: WHERE code_combination_id IS NULL;
6787: -- the user can pass either amount or percent. If both amount and percent
6788: -- is passed then amount will take precendence.
6795: error_message)
6796: SELECT d.trx_header_id,
6797: d.trx_line_id,
6798: D.trx_DIST_ID,
6799: arp_standard.fnd_message('AR_INAPI_AMT_PER_REQUIRED')
6800: FROM ar_trx_DIST_gt D
6801: WHERE d.PERCENT IS NULL
6802: AND d.amount IS NULL;
6803:
6814: error_message)
6815: SELECT d.trx_header_id,
6816: L.trx_line_id,
6817: D.trx_DIST_ID,
6818: arp_standard.fnd_message('AR_INAPI_ONLY_PER_ALLOWED')
6819: FROM ar_trx_DIST_gt D,
6820: ar_trx_lines_GT L
6821: WHERE (L.ACCOUNTING_RULE_ID IS NOT NULL
6822: OR D.ACCOUNT_CLASS = 'REC')
6840: error_message)
6841: SELECT d.trx_header_id,
6842: L.trx_LINE_ID,
6843: D.trx_DIST_ID,
6844: arp_standard.fnd_message('AR_INAPI_INAVLID_LINE_TYPE')
6845: FROM ar_trx_dist_gt D,
6846: ar_trx_LINES_GT L
6847: WHERE L.trx_LINE_ID = D.trx_LINE_ID
6848: AND DECODE(D.ACCOUNT_CLASS,
6964: error_message,
6965: invalid_value)
6966: SELECT l.trx_header_id,
6967: L.trx_LINE_ID,
6968: arp_standard.fnd_message('AR_INAPI_NVALID_SUM_DIST_AMT'),
6969: d.account_class || ':'||SUM(d.amount)
6970: FROM ar_trx_DIST_gt D,
6971: ar_trx_lines_GT L
6972: WHERE L.ACCOUNTING_RULE_ID IS NULL
6994: error_message,
6995: invalid_value)
6996: SELECT d.trx_header_id,
6997: d.trx_line_ID,
6998: arp_standard.fnd_message('AR_INAPI_100_PERCENT'),
6999: sum(d.percent)
7000: FROM ar_trx_dist_gt d, ar_trx_lines_gt L, ar_trx_header_gt h
7001: WHERE d.trx_line_id = l.trx_line_id
7002: AND l.trx_header_id = h.trx_header_id
7010: (trx_header_id,
7011: error_message,
7012: invalid_value)
7013: SELECT d.trx_header_id,
7014: arp_standard.fnd_message('AR_INAPI_100_PERCENT'),
7015: sum(d.percent)
7016: FROM ar_trx_dist_gt d
7017: WHERE d.account_class = 'REC'
7018: GROUP BY d.trx_header_id
7308: INVALID_VALUE)
7309: SELECT trx_header_id,
7310: trx_LINE_ID,
7311: trx_SALESCREDIT_ID,
7312: arp_standard.fnd_message(l_message_name),
7313: sc.salesrep_id
7314: FROM ar_trx_salescredits_gt SC
7315: WHERE salesrep_id IS NOT NULL
7316: AND NOT EXISTS
7331: INVALID_VALUE)
7332: SELECT trx_header_id,
7333: trx_LINE_ID,
7334: trx_salescredit_id,
7335: arp_standard.fnd_message(l_message_name),
7336: sc.salesrep_num
7337: FROM ar_trx_salescredits_gt SC
7338: WHERE sc.salesrep_num IS NOT NULL
7339: AND NOT EXISTS
7360: INVALID_VALUE)
7361: SELECT trx_header_id,
7362: trx_LINE_ID,
7363: trx_SALESCREDIT_ID,
7364: arp_standard.fnd_message(l_message_name),
7365: sc.sales_credit_type_id
7366: FROM ar_trx_salescredits_gt SC
7367: WHERE sales_credit_type_id IS NOT NULL
7368: AND NOT EXISTS
7383: INVALID_VALUE)
7384: SELECT trx_header_id,
7385: trx_line_id,
7386: trx_salescredit_id,
7387: arp_standard.fnd_message(l_message_name),
7388: sc.sales_credit_type_name
7389: FROM ar_trx_salescredits_gt SC
7390: WHERE sales_credit_type_name IS NOT NULL
7391: AND NOT EXISTS
7413: error_MESSAGE)
7414: SELECT trx_header_id,
7415: trx_LINE_ID,
7416: trx_SALESCREDIT_ID,
7417: arp_standard.fnd_message(l_message_name)
7418: FROM ar_trx_salescredits_gt SC
7419: WHERE revenue_amount_split IS NULL
7420: AND revenue_percent_split IS NULL;
7421:
7435: INVALID_VALUE)
7436: SELECT S.trx_header_id,
7437: S.trx_LINE_ID,
7438: S.trx_SALESCREDIT_ID,
7439: arp_standard.fnd_message(l_message_name),
7440: L.LINE_TYPE
7441: FROM ar_trx_LINES_GT L,
7442: ar_trx_SALESCREDITS_gt S
7443: WHERE S.trx_LINE_ID = L.trx_LINE_ID
7563: invalid_value)
7564: SELECT S.trx_header_id,
7565: S.trx_LINE_ID,
7566: S.trx_SALESCREDIT_ID,
7567: arp_standard.fnd_message('AR_INAPI_INVALID_PRECISION'),
7568: S.revenue_amount_split
7569: FROM ar_trx_salescredits_gt S,
7570: ar_trx_LINES_GT L,
7571: FND_CURRENCIES C
7601: invalid_value)
7602: SELECT SC.trx_header_id,
7603: SC.trx_LINE_ID,
7604: SC.trx_SALESCREDIT_ID,
7605: arp_standard.fnd_message(l_message_name),
7606: SC.revenue_percent_split
7607: FROM ar_trx_salescredits_gt SC,
7608: SO_SALES_CREDIT_TYPES SCT
7609: WHERE SC.SALES_CREDIT_TYPE_ID = SCT.SALES_CREDIT_TYPE_ID
7622: trx_line_id,
7623: error_MESSAGE)
7624: SELECT SC.trx_header_id,
7625: SC.trx_LINE_ID,
7626: arp_standard.fnd_message(l_message_name)
7627: FROM
7628: ar_trx_salescredits_gt SC,
7629: SO_SALES_CREDIT_TYPES CR
7630: WHERE SC.SALES_CREDIT_TYPE_ID = CR.SALES_CREDIT_TYPE_ID
7649: error_message,
7650: invalid_value)
7651: SELECT s.trx_header_id,
7652: s.trx_line_id,
7653: arp_standard.fnd_message(l_message_name),
7654: SUM(S.revenue_amount_split)
7655: FROM ar_trx_salescredits_gt s,
7656: so_sales_credit_types t
7657: WHERE s.sales_credit_type_id = t.sales_credit_type_id
7689: trx_line_id,
7690: error_message)
7691: SELECT lgt.trx_header_id,
7692: lgt.trx_line_id,
7693: arp_standard.fnd_message(l_message_name)
7694: FROM ar_trx_lines_gt lgt
7695: WHERE lgt.line_type = 'LINE'
7696: AND NOT EXISTS
7697: (SELECT 'X'