eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_INVOICE_UTILS dependencies on STANDARD

Line 29: arp_standard.debug(p_message);

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(

Line 79: arp_standard.fnd_message('AR_INAPI_INVALID_REMIT_ADDR_ID'),

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

Line 119: arp_standard.fnd_message('AR_INAPI_INVALID_TRX_CLASS'),

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;

Line 155: arp_standard.fnd_message('AR_INAPI_INVALID_SHIP_VIA'),

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

Line 196: arp_standard.fnd_message('AR_INAPI_INVALID_FOB'),

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

Line 238: arp_standard.fnd_message('AR_INAPI_INVALID_USSGL_CODE'),

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

Line 281: arp_standard.fnd_message('AR_INVALID_PAYMENT_METHOD'),

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

Line 297: arp_standard.fnd_message('AR_BOE_OBSOLETE'),

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

Line 310: arp_standard.fnd_message('AR_INVALID_PAYMENT_METHOD'),

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

Line 327: arp_standard.fnd_message('AR_INVALID_PAYMENT_METHOD'),

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

Line 344: arp_standard.fnd_message('AR_INVALID_PAYMENT_METHOD'),

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

Line 362: arp_standard.fnd_message('AR_INVALID_PAYMENT_METHOD'),

358: trx_header_id,
359: error_message,
360: invalid_value)
361: SELECT trx_header_id,
362: arp_standard.fnd_message('AR_INVALID_PAYMENT_METHOD'),
363: receipt_method_id
364: FROM ar_trx_header_gt gt
365: WHERE gt.receipt_method_id IS NULL
366: AND gt.payment_trxn_extension_id IS NOT NULL;

Line 399: arp_standard.fnd_message('AR_INVALID_LEGAL_ENTITY'),

395: trx_header_id,
396: error_message,
397: invalid_value)
398: SELECT trx_header_id,
399: arp_standard.fnd_message('AR_INVALID_LEGAL_ENTITY'),
400: legal_entity_id
401: FROM ar_trx_header_gt gt
402: WHERE gt.legal_entity_id IS NOT NULL
403: AND NOT EXISTS (

Line 458: arp_standard.fnd_message('AR_INAPI_INVALID_PAYING_CUS_ID'),

454: trx_header_id,
455: error_message,
456: invalid_value)
457: SELECT trx_header_id,
458: arp_standard.fnd_message('AR_INAPI_INVALID_PAYING_CUS_ID'),
459: paying_customer_id
460: FROM ar_trx_header_gt gt
461: WHERE gt.paying_customer_id IS NOT NULL
462: AND NOT EXISTS (

Line 474: arp_standard.fnd_message('AR_INAPI_INVALID_PAYING_CUS_ID'),

470: trx_header_id,
471: error_message,
472: invalid_value)
473: SELECT trx_header_id,
474: arp_standard.fnd_message('AR_INAPI_INVALID_PAYING_CUS_ID'),
475: paying_customer_id
476: FROM ar_trx_header_gt gt
477: WHERE gt.paying_customer_id IS NOT NULL
478: AND NOT EXISTS

Line 534: arp_standard.fnd_message('AR_INAPI_INVALID_PAYING_SIT_ID'),

530: trx_header_id,
531: error_message,
532: invalid_value)
533: SELECT trx_header_id,
534: arp_standard.fnd_message('AR_INAPI_INVALID_PAYING_SIT_ID'),
535: paying_site_use_id
536: FROM ar_trx_header_gt gt
537: WHERE gt.paying_site_use_id IS NOT NULL
538: AND NOT EXISTS

Line 580: arp_standard.fnd_message('AR_DAPI_SOLD_CUST_ID_INVALID'),

576: trx_header_id,
577: error_message,
578: invalid_value)
579: SELECT trx_header_id,
580: arp_standard.fnd_message('AR_DAPI_SOLD_CUST_ID_INVALID'),
581: sold_to_customer_id
582: FROM ar_trx_header_gt gt
583: WHERE gt.sold_to_customer_id IS NOT NULL
584: AND NOT EXISTS

Line 621: arp_standard.fnd_message('AR_INAPI_INV_SHIP_TO_CUST_NAME'),

617: trx_header_id,
618: error_message,
619: invalid_value)
620: SELECT trx_header_id,
621: arp_standard.fnd_message('AR_INAPI_INV_SHIP_TO_CUST_NAME'),
622: ship_to_customer_name
623: FROM ar_trx_header_gt gt
624: WHERE gt.ship_to_customer_name IS NOT NULL
625: AND NOT EXISTS

Line 663: arp_standard.fnd_message('AR_INAPI_INV_SHIP_TO_CUST_NUM'),

659: trx_header_id,
660: error_message,
661: invalid_value)
662: SELECT trx_header_id,
663: arp_standard.fnd_message('AR_INAPI_INV_SHIP_TO_CUST_NUM'),
664: ship_to_account_number
665: FROM ar_trx_header_gt gt
666: WHERE gt.ship_to_account_number IS NOT NULL
667: AND NOT EXISTS

Line 703: arp_standard.fnd_message('AR_INAPI_INV_BILL_TO_CUST_NAME'),

699: trx_header_id,
700: error_message,
701: invalid_value)
702: SELECT trx_header_id,
703: arp_standard.fnd_message('AR_INAPI_INV_BILL_TO_CUST_NAME'),
704: bill_to_customer_name
705: FROM ar_trx_header_gt gt
706: WHERE gt.bill_to_customer_name IS NOT NULL
707: AND NOT EXISTS

Line 745: arp_standard.fnd_message('AR_INAPI_INV_BILL_TO_CUST_NUM'),

741: trx_header_id,
742: error_message,
743: invalid_value)
744: SELECT trx_header_id,
745: arp_standard.fnd_message('AR_INAPI_INV_BILL_TO_CUST_NUM'),
746: bill_to_account_number
747: FROM ar_trx_header_gt gt
748: WHERE gt.bill_to_account_number IS NOT NULL
749: AND NOT EXISTS

Line 785: arp_standard.fnd_message('AR_INAPI_BAD_BLL_TO_CONTACT_ID'),

781: trx_header_id,
782: error_message,
783: invalid_value)
784: SELECT trx_header_id,
785: arp_standard.fnd_message('AR_INAPI_BAD_BLL_TO_CONTACT_ID'),
786: bill_to_contact_id
787: FROM ar_trx_header_gt gt
788: WHERE gt.bill_to_contact_id IS NOT NULL
789: AND NOT EXISTS

Line 840: arp_standard.fnd_message('AR_INAPI_BAD_SHP_TO_CONTACT_ID'),

836: trx_header_id,
837: error_message,
838: invalid_value)
839: SELECT trx_header_id,
840: arp_standard.fnd_message('AR_INAPI_BAD_SHP_TO_CONTACT_ID'),
841: ship_to_contact_id
842: FROM ar_trx_header_gt gt
843: WHERE gt.ship_to_contact_id IS NOT NULL
844: AND NOT EXISTS

Line 895: arp_standard.fnd_message('AR_INAPI_INV_XCHNG_RATE_TYPE'),

891: trx_header_id,
892: error_message,
893: invalid_value)
894: SELECT trx_header_id,
895: arp_standard.fnd_message('AR_INAPI_INV_XCHNG_RATE_TYPE'),
896: exchange_rate_type
897: FROM ar_trx_header_gt gt
898: WHERE gt.exchange_rate_type IS NOT NULL
899: AND NOT EXISTS

Line 978: arp_standard.fnd_message('AR', 'AR_RAPI_DOC_SEQ_AUTOMATIC'),

974: error_message,
975: invalid_value)
976: VALUES
977: (header_rec.trx_header_id,
978: arp_standard.fnd_message('AR', 'AR_RAPI_DOC_SEQ_AUTOMATIC'),
979: header_rec.doc_sequence_value);
980:
981: END IF;
982:

Line 1000: arp_standard.fnd_message('AR_TAPI_BFB_BILLING_DATE_REQD'),

996: trx_header_id,
997: error_message,
998: invalid_value)
999: SELECT trx_header_id,
1000: arp_standard.fnd_message('AR_TAPI_BFB_BILLING_DATE_REQD'),
1001: billing_date
1002: FROM ar_trx_header_gt
1003: WHERE term_id IS NOT NULL
1004: AND billing_date IS NULL

Line 1014: arp_standard.fnd_message('AR_TAPI_BFB_OPEN_REC'),

1010: trx_header_id,
1011: error_message,
1012: invalid_value)
1013: SELECT trx_header_id,
1014: arp_standard.fnd_message('AR_TAPI_BFB_OPEN_REC'),
1015: term_id
1016: FROM ar_trx_header_gt
1017: WHERE term_id IS NOT NULL
1018: AND cust_trx_type_id IS NOT NULL

Line 1028: arp_standard.fnd_message('AR_TAPI_BFB_BILLING_DATE_INV'),

1024: trx_header_id,
1025: error_message,
1026: invalid_value)
1027: SELECT trx_header_id,
1028: arp_standard.fnd_message('AR_TAPI_BFB_BILLING_DATE_INV'),
1029: billing_date
1030: FROM ar_trx_header_gt
1031: WHERE term_id IS NOT NULL
1032: AND billing_date IS NOT NULL

Line 1077: arp_standard.fnd_message('AR_INAPI_TRX_NUM_NOT_REQUIRED'),

1073: error_message,
1074: invalid_value)
1075: SELECT trx_header_id,
1076: DECODE(b.auto_trx_numbering_flag, 'Y',
1077: arp_standard.fnd_message('AR_INAPI_TRX_NUM_NOT_REQUIRED'),
1078: arp_standard.fnd_message('AR_TW_NULL_TRX_NUMBER')),
1079: trx_number
1080: FROM ar_trx_header_gt gt,
1081: ra_batch_sources b

Line 1078: arp_standard.fnd_message('AR_TW_NULL_TRX_NUMBER')),

1074: invalid_value)
1075: SELECT trx_header_id,
1076: DECODE(b.auto_trx_numbering_flag, 'Y',
1077: arp_standard.fnd_message('AR_INAPI_TRX_NUM_NOT_REQUIRED'),
1078: arp_standard.fnd_message('AR_TW_NULL_TRX_NUMBER')),
1079: trx_number
1080: FROM ar_trx_header_gt gt,
1081: ra_batch_sources b
1082: WHERE b.batch_source_id = gt.batch_source_id

Line 1096: arp_standard.fnd_message('AR_INAPI_BANK_ACC_NOT_REQUIRED'),

1092: trx_header_id,
1093: error_message,
1094: invalid_value)
1095: SELECT trx_header_id,
1096: arp_standard.fnd_message('AR_INAPI_BANK_ACC_NOT_REQUIRED'),
1097: customer_bank_account_id
1098: FROM ar_trx_header_gt gt
1099: WHERE gt.customer_bank_account_id IS NOT NULL
1100: AND NOT EXISTS (

Line 1116: arp_standard.fnd_message('AR_INAPI_PAYING_SITE_REQUIRED'),

1112: trx_header_id,
1113: error_message,
1114: invalid_value)
1115: SELECT trx_header_id,
1116: arp_standard.fnd_message('AR_INAPI_PAYING_SITE_REQUIRED'),
1117: paying_customer_id
1118: FROM ar_trx_header_gt gt
1119: WHERE gt.paying_customer_id IS NOT NULL
1120: AND gt.paying_site_use_id IS NULL;

Line 1131: arp_standard.fnd_message('AR_INAPI_PO_REQUIRED'),

1127: trx_header_id,
1128: error_message,
1129: invalid_value)
1130: SELECT trx_header_id,
1131: arp_standard.fnd_message('AR_INAPI_PO_REQUIRED'),
1132: paying_customer_id
1133: FROM ar_trx_header_gt gt
1134: WHERE (gt.purchase_order_revision IS NOT NULL
1135: OR gt.purchase_order_date IS NOT NULL)

Line 1148: arp_standard.fnd_message('AR_INAPI_RULE_INFO_UNNECESSARY'),

1144: error_message,
1145: invalid_value)
1146: SELECT lgt.trx_header_id,
1147: lgt.trx_line_id,
1148: arp_standard.fnd_message('AR_INAPI_RULE_INFO_UNNECESSARY'),
1149: NVL(lgt.accounting_rule_id, lgt.accounting_rule_duration)
1150: FROM ar_trx_lines_gt lgt,
1151: ar_trx_header_gt hgt
1152: WHERE (lgt.accounting_rule_id IS NOT NULL

Line 1165: arp_standard.fnd_message('AR_INAPI_INV_MASTER_LINE_TYPE'),

1161: error_message,
1162: invalid_value)
1163: SELECT trx_header_id,
1164: trx_line_id,
1165: arp_standard.fnd_message('AR_INAPI_INV_MASTER_LINE_TYPE'),
1166: link_to_trx_line_id
1167: FROM ar_trx_lines_gt gt
1168: WHERE gt.link_to_trx_line_id IS NOT NULL
1169: AND NOT EXISTS

Line 1183: arp_standard.fnd_message('AR_INAPI_INVALID_SUB_LINE_TYPE'),

1179: error_message,
1180: invalid_value)
1181: SELECT trx_header_id,
1182: trx_line_id,
1183: arp_standard.fnd_message('AR_INAPI_INVALID_SUB_LINE_TYPE'),
1184: link_to_trx_line_id
1185: FROM ar_trx_lines_gt gt
1186: WHERE gt.link_to_trx_line_id IS NOT NULL
1187: AND gt.line_type NOT IN ('TAX', 'FREIGHT');

Line 1198: arp_standard.fnd_message('AR_TAPI_EXCHANGE_RATE_REQUIRED'),

1194: trx_header_id,
1195: error_message,
1196: invalid_value)
1197: SELECT trx_header_id,
1198: arp_standard.fnd_message('AR_TAPI_EXCHANGE_RATE_REQUIRED'),
1199: gt.trx_currency
1200: FROM ar_trx_header_gt gt
1201: WHERE gt.trx_currency IS NOT NULL
1202: AND ( exchange_rate IS NULL

Line 1214: arp_standard.fnd_message('AR_INAPI_RATE_NOT_REQUIRED2'),

1210: trx_header_id,
1211: error_message,
1212: invalid_value)
1213: SELECT trx_header_id,
1214: arp_standard.fnd_message('AR_INAPI_RATE_NOT_REQUIRED2'),
1215: exchange_rate
1216: FROM ar_trx_header_gt
1217: WHERE exchange_rate IS NOT NULL
1218: AND exchange_rate_type <> 'User';

Line 1227: arp_standard.fnd_message('AR_TAPI_EXCHG_INFO_NOT_ALLOWED'),

1223: trx_header_id,
1224: error_message,
1225: invalid_value)
1226: SELECT trx_header_id,
1227: arp_standard.fnd_message('AR_TAPI_EXCHG_INFO_NOT_ALLOWED'),
1228: trx_currency
1229: FROM ar_trx_header_gt
1230: WHERE ( exchange_rate IS NOT NULL
1231: OR exchange_rate_type IS NOT NULL

Line 1244: arp_standard.fnd_message('AR_TAX_CHOOSE_YES_NO'),

1240: error_message,
1241: invalid_value)
1242: SELECT trx_header_id,
1243: trx_line_id,
1244: arp_standard.fnd_message('AR_TAX_CHOOSE_YES_NO'),
1245: amount_includes_tax_flag
1246: FROM ar_trx_lines_gt lgt
1247: WHERE amount_includes_tax_flag IS NOT NULL
1248: AND amount_includes_tax_flag NOT IN ('Y', 'N');

Line 1279: arp_standard.fnd_message('AR_TW_NO_LINES'),

1275: trx_header_id,
1276: error_message,
1277: invalid_value)
1278: SELECT trx_header_id,
1279: arp_standard.fnd_message('AR_TW_NO_LINES'),
1280: null
1281: FROM ar_trx_header_gt gt
1282: WHERE NOT EXISTS
1283: (SELECT 'X'

Line 1295: arp_standard.fnd_message('AR_INAPI_ORPHAN_LINES'),

1291: error_message,
1292: invalid_value)
1293: SELECT trx_header_id,
1294: trx_line_id,
1295: arp_standard.fnd_message('AR_INAPI_ORPHAN_LINES'),
1296: null
1297: FROM ar_trx_lines_gt lgt
1298: WHERE NOT EXISTS
1299: (SELECT 'X'

Line 1311: arp_standard.fnd_message('AR_INAPI_LINE_NUMS_NOT_UNIQUE'),

1307: error_message,
1308: invalid_value)
1309: SELECT trx_header_id,
1310: trx_line_id,
1311: arp_standard.fnd_message('AR_INAPI_LINE_NUMS_NOT_UNIQUE'),
1312: lgt.line_number
1313: FROM ar_trx_lines_gt lgt
1314: WHERE EXISTS
1315: (SELECT 'X'

Line 1331: arp_standard.fnd_message('AR_INAPI_LINE_ID_NOT_UNIQUE'),

1327: error_message,
1328: invalid_value)
1329: SELECT trx_header_id,
1330: trx_line_id,
1331: arp_standard.fnd_message('AR_INAPI_LINE_ID_NOT_UNIQUE'),
1332: null
1333: FROM ar_trx_lines_gt lgt
1334: WHERE EXISTS
1335: (SELECT 'X'

Line 1348: arp_standard.fnd_message('AR_INAPI_HEADER_ID_NOT_UNIQUE'),

1344: trx_header_id,
1345: error_message,
1346: invalid_value)
1347: SELECT trx_header_id,
1348: arp_standard.fnd_message('AR_INAPI_HEADER_ID_NOT_UNIQUE'),
1349: null
1350: FROM ar_trx_header_gt hgt
1351: WHERE EXISTS
1352: (SELECT 'X'

Line 1394: arp_standard.fnd_message('AR_TW_INVALID_TRX_NUMBER'),

1390: trx_header_id,
1391: error_message,
1392: invalid_value)
1393: SELECT trx_header_id,
1394: arp_standard.fnd_message('AR_TW_INVALID_TRX_NUMBER'),
1395: trx_number
1396: FROM ar_trx_header_gt gt
1397: WHERE gt.trx_number IS NOT NULL
1398: AND gt.batch_source_id IS NOT NULL

Line 1461: arp_standard.fnd_message('AR_INVALID_MANDATE_FLAG_VALUE'),

1457: trx_header_id,
1458: error_message,
1459: invalid_value)
1460: SELECT trx_header_id,
1461: arp_standard.fnd_message('AR_INVALID_MANDATE_FLAG_VALUE'),
1462: trx_number
1463: FROM ar_trx_header_gt gt
1464: WHERE nvl(upper(mandate_last_trx_flag),'N') not in ('Y','N');
1465:

Line 1499: arp_standard.fnd_message('AR_INAPI_INVALID_BATCH_SOURCE'),

1495: trx_header_id,
1496: error_message,
1497: invalid_value)
1498: SELECT trx_header_id,
1499: arp_standard.fnd_message('AR_INAPI_INVALID_BATCH_SOURCE'),
1500: batch_source_id
1501: FROM ar_trx_header_gt gt
1502: WHERE NOT EXISTS (
1503: SELECT 'X'

Line 1545: arp_standard.fnd_message('AR_INVALID_CURRENCY'),

1541: ( trx_header_id,
1542: error_message,
1543: invalid_value)
1544: SELECT trx_header_id,
1545: arp_standard.fnd_message('AR_INVALID_CURRENCY'),
1546: trx_currency
1547: FROM ar_trx_header_gt gt
1548: WHERE gt.trx_currency IS NOT NULL
1549: AND NOT EXISTS (

Line 1583: arp_standard.fnd_message('AR_BR_TRX_TYPE_NULL'),

1579: trx_header_id,
1580: error_message,
1581: invalid_value)
1582: SELECT trx_header_id,
1583: arp_standard.fnd_message('AR_BR_TRX_TYPE_NULL'),
1584: cust_trx_type_id
1585: FROM ar_trx_header_gt gt
1586: WHERE gt.cust_trx_type_id IS NULL;
1587:

Line 1593: arp_standard.fnd_message('AR_INVALID_TRX_TYPE'),

1589: trx_header_id,
1590: error_message,
1591: invalid_value)
1592: SELECT trx_header_id,
1593: arp_standard.fnd_message('AR_INVALID_TRX_TYPE'),
1594: cust_trx_type_id
1595: FROM ar_trx_header_gt gt
1596: WHERE gt.cust_trx_type_id IS NOT NULL
1597: AND NOT EXISTS (

Line 1634: arp_standard.fnd_message('AR_INAPI_INV_BILL_TO_CUST_ID'),

1630: trx_header_id,
1631: error_message,
1632: invalid_value)
1633: SELECT trx_header_id,
1634: arp_standard.fnd_message('AR_INAPI_INV_BILL_TO_CUST_ID'),
1635: bill_to_customer_id
1636: FROM ar_trx_header_gt gt
1637: WHERE gt.bill_to_customer_id IS NOT NULL
1638: AND NOT EXISTS (

Line 1673: arp_standard.fnd_message('AR_INAPI_BILL_TO_SITE_ID_REQ'),

1669: trx_header_id,
1670: error_message,
1671: invalid_value)
1672: SELECT trx_header_id,
1673: arp_standard.fnd_message('AR_INAPI_BILL_TO_SITE_ID_REQ'),
1674: bill_to_site_use_id
1675: FROM ar_trx_header_gt gt
1676: WHERE gt.bill_to_site_use_id IS NULL
1677: and gt.bill_to_customer_id is not null;

Line 1685: arp_standard.fnd_message('AR_INAPI_INV_BILL_TO_SITE_USE'),

1681: trx_header_id,
1682: error_message,
1683: invalid_value)
1684: SELECT trx_header_id,
1685: arp_standard.fnd_message('AR_INAPI_INV_BILL_TO_SITE_USE'),
1686: bill_to_site_use_id
1687: FROM ar_trx_header_gt gt
1688: WHERE gt.bill_to_site_use_id IS NOT NULL
1689: AND NOT EXISTS (

Line 1731: arp_standard.fnd_message('AR_INAPI_INVALID_BILL_ADDR_ID'),

1727: trx_header_id,
1728: error_message,
1729: invalid_value)
1730: SELECT trx_header_id,
1731: arp_standard.fnd_message('AR_INAPI_INVALID_BILL_ADDR_ID'),
1732: bill_to_address_id
1733: FROM ar_trx_header_gt gt
1734: WHERE gt.bill_to_address_id IS NOT NULL
1735: AND NOT EXISTS (

Line 1786: arp_standard.fnd_message('AR_INAPI_INV_SHIP_TO_CUST_ID'),

1782: trx_header_id,
1783: error_message,
1784: invalid_value)
1785: SELECT trx_header_id,
1786: arp_standard.fnd_message('AR_INAPI_INV_SHIP_TO_CUST_ID'),
1787: ship_to_customer_id
1788: FROM ar_trx_header_gt gt
1789: WHERE gt.ship_to_customer_id IS NOT NULL
1790: AND NOT EXISTS (

Line 1831: arp_standard.fnd_message('AR_INAPI_SHIP_TO_SITE_ID_REQ'),

1827: trx_header_id,
1828: error_message,
1829: invalid_value)
1830: SELECT trx_header_id,
1831: arp_standard.fnd_message('AR_INAPI_SHIP_TO_SITE_ID_REQ'),
1832: ship_to_site_use_id
1833: FROM ar_trx_header_gt gt
1834: WHERE gt.ship_to_site_use_id IS NULL
1835: AND gt.ship_to_customer_id IS NOT NULL;

Line 1843: arp_standard.fnd_message('AR_INAPI_INVALID_SHIP_SITE_USE'),

1839: trx_header_id,
1840: error_message,
1841: invalid_value)
1842: SELECT trx_header_id,
1843: arp_standard.fnd_message('AR_INAPI_INVALID_SHIP_SITE_USE'),
1844: ship_to_site_use_id
1845: FROM ar_trx_header_gt gt
1846: WHERE gt.ship_to_site_use_id IS NOT NULL
1847: AND gt.ship_to_customer_id IS NOT NULL

Line 1863: arp_standard.fnd_message('AR_INAPI_NULL_SHIP_TO_SITE'),

1859: trx_header_id,
1860: error_message,
1861: invalid_value)
1862: SELECT trx_header_id,
1863: arp_standard.fnd_message('AR_INAPI_NULL_SHIP_TO_SITE'),
1864: ship_to_site_use_id
1865: FROM ar_trx_header_gt gt
1866: WHERE gt.ship_to_site_use_id IS NULL
1867: AND gt.ship_to_customer_id IS NOT NULL;

Line 1898: arp_standard.fnd_message('AR_INAPI_INVALID_SHIP_SITE_USE'),

1894: trx_header_id,
1895: error_message,
1896: invalid_value)
1897: SELECT trx_header_id,
1898: arp_standard.fnd_message('AR_INAPI_INVALID_SHIP_SITE_USE'),
1899: ship_to_site_use_id
1900: FROM ar_trx_header_gt gt
1901: WHERE gt.ship_to_site_use_id IS NOT NULL
1902: AND NOT EXISTS (

Line 2031: arp_standard.fnd_message('AR_INAPI_INVALID_SHIP_SITE_USE'),

2027: trx_header_id,
2028: error_message,
2029: invalid_value)
2030: SELECT trx_header_id,
2031: arp_standard.fnd_message('AR_INAPI_INVALID_SHIP_SITE_USE'),
2032: gt.ship_to_site_use_id
2033: FROM ar_trx_header_gt gt
2034: WHERE gt.ship_to_customer_id IS NOT NULL
2035: AND gt.ship_to_site_use_id IS NOT NULL

Line 2086: arp_standard.fnd_message('AR_INVALID_TERM'),

2082: trx_header_id,
2083: error_message,
2084: invalid_value)
2085: SELECT gt.trx_header_id,
2086: arp_standard.fnd_message('AR_INVALID_TERM'),
2087: gt.term_id
2088: FROM ar_trx_header_gt gt,
2089: ra_cust_trx_types ctt
2090: WHERE gt.term_id IS NOT NULL

Line 2109: arp_standard.fnd_message('AR_INAPI_TERM_NOT_ALLOWED'),

2105: trx_header_id,
2106: error_message,
2107: invalid_value)
2108: SELECT gt.trx_header_id,
2109: arp_standard.fnd_message('AR_INAPI_TERM_NOT_ALLOWED'),
2110: gt.term_id
2111: FROM ar_trx_header_gt gt,
2112: ra_cust_trx_types ctt
2113: WHERE gt.term_id IS NOT NULL

Line 2151: arp_standard.fnd_message('AR_INVALID_PRIMARY_SALESREP'),

2147: trx_header_id,
2148: error_message,
2149: invalid_value)
2150: SELECT trx_header_id,
2151: arp_standard.fnd_message('AR_INVALID_PRIMARY_SALESREP'),
2152: primary_salesrep_id
2153: FROM ar_trx_header_gt gt
2154: WHERE gt.primary_salesrep_id IS NOT NULL
2155: AND NOT EXISTS (

Line 2191: arp_standard.fnd_message(l_message_name),

2187: trx_header_id,
2188: error_message,
2189: invalid_value)
2190: SELECT trx_header_id,
2191: arp_standard.fnd_message(l_message_name),
2192: primary_salesrep_id
2193: FROM ar_trx_header_gt gt
2194: WHERE gt.primary_salesrep_id IS NOT NULL
2195: AND NOT EXISTS (

Line 2212: arp_standard.fnd_message(l_message_name),

2208: trx_header_id,
2209: error_message,
2210: invalid_value)
2211: SELECT trx_header_id,
2212: arp_standard.fnd_message(l_message_name),
2213: primary_salesrep_id
2214: FROM ar_trx_header_gt gt
2215: WHERE gt.primary_salesrep_id IS NULL
2216: AND p_trx_system_param_rec.salesrep_required_flag = 'Y';

Line 2250: arp_standard.fnd_message('AR_INAPI_INV_RULE_NOT_REQUIRED'),

2246: trx_header_id,
2247: error_message,
2248: invalid_value)
2249: SELECT trx_header_id,
2250: arp_standard.fnd_message('AR_INAPI_INV_RULE_NOT_REQUIRED'),
2251: invoicing_rule_id
2252: FROM ar_trx_header_gt gt
2253: WHERE gt.invoicing_rule_id IS NOT NULL
2254: AND gt.cust_trx_type_id NOT IN (

Line 2265: arp_standard.fnd_message('AR_INAPI_INVALID_INV_RULE_ID'),

2261: trx_header_id,
2262: error_message,
2263: invalid_value)
2264: SELECT trx_header_id,
2265: arp_standard.fnd_message('AR_INAPI_INVALID_INV_RULE_ID'),
2266: invoicing_rule_id
2267: FROM ar_trx_header_gt gt
2268: WHERE gt.invoicing_rule_id IS NOT NULL
2269: AND gt.invoicing_rule_id not in ( -2, -3);

Line 2303: arp_standard.fnd_message('AR_INAPI_INVALID_PRINT_OPTION'),

2299: trx_header_id,
2300: error_message,
2301: invalid_value)
2302: SELECT trx_header_id,
2303: arp_standard.fnd_message('AR_INAPI_INVALID_PRINT_OPTION'),
2304: printing_option
2305: FROM ar_trx_header_gt gt
2306: WHERE gt.printing_option IS NOT NULL
2307: AND gt.printing_option NOT IN ( 'PRI', 'NOT');

Line 2388: arp_standard.fnd_message('AR_INAPI_INV_TAX_EXEMPT_FLAG'),

2384: trx_header_id,
2385: error_message,
2386: invalid_value)
2387: SELECT trx_header_id,
2388: arp_standard.fnd_message('AR_INAPI_INV_TAX_EXEMPT_FLAG'),
2389: default_tax_exempt_flag
2390: FROM ar_trx_header_gt gt
2391: WHERE default_tax_exempt_flag IS NOT NULL
2392: AND NOT EXISTS (

Line 2432: arp_standard.fnd_message('AR_INAPI_INVALID_TRX_STATUS'),

2428: trx_header_id,
2429: error_message,
2430: invalid_value)
2431: SELECT trx_header_id,
2432: arp_standard.fnd_message('AR_INAPI_INVALID_TRX_STATUS'),
2433: status_trx
2434: FROM ar_trx_header_gt
2435: WHERE status_trx IS NOT NULL
2436: AND status_trx not in ( 'OP','CL','PEN','VD');

Line 2469: arp_standard.fnd_message('AR_INAPI_INVALID_FIN_CHARGE'),

2465: trx_header_id,
2466: error_message,
2467: invalid_value)
2468: SELECT trx_header_id,
2469: arp_standard.fnd_message('AR_INAPI_INVALID_FIN_CHARGE'),
2470: finance_charges
2471: FROM ar_trx_header_gt
2472: WHERE finance_charges IS NOT NULL
2473: AND finance_charges not in ( 'Y','N');

Line 2508: arp_standard.fnd_message('AR_INAPI_INAVLID_CROSS_REF'),

2504: trx_header_id,
2505: error_message,
2506: invalid_value)
2507: SELECT trx_header_id,
2508: arp_standard.fnd_message('AR_INAPI_INAVLID_CROSS_REF'),
2509: related_customer_trx_id
2510: FROM ar_trx_header_gt gt
2511: WHERE gt.related_customer_trx_id IS NOT NULL
2512: AND NOT EXISTS (

Line 2604: arp_standard.fnd_message('AR_INAPI_NO_PERIOD_FOR_GL_DATE'),

2600: error_message,
2601: invalid_value)
2602: values
2603: ( cglDateRec.trx_header_id,
2604: arp_standard.fnd_message('AR_INAPI_NO_PERIOD_FOR_GL_DATE'),
2605: cglDateRec.gl_date );
2606: END IF;
2607:
2608: IF cglDateRec.invoicing_rule_id IS NOT NULL

Line 2620: arp_standard.fnd_message('AR_INAPI_BAD_GL_DATE_FOR_ADV'),

2616: error_message,
2617: invalid_value)
2618: values
2619: ( cglDateRec.trx_header_id,
2620: arp_standard.fnd_message('AR_INAPI_BAD_GL_DATE_FOR_ADV'),
2621: cglDateRec.gl_date );
2622: END IF;
2623: ELSIF cglDateRec.invoicing_rule_id = -3
2624: THEN

Line 2633: arp_standard.fnd_message('AR_INAPI_BAD_GL_DATE_FOR_ARR'),

2629: error_message,
2630: invalid_value)
2631: values
2632: ( cglDateRec.trx_header_id,
2633: arp_standard.fnd_message('AR_INAPI_BAD_GL_DATE_FOR_ARR'),
2634: cglDateRec.gl_date );
2635: END IF;
2636: END IF;
2637: END IF;

Line 2647: arp_standard.fnd_message('AR_TAPI_NO_PERIOD_FOR_GL_DATE'),

2643: error_message,
2644: invalid_value)
2645: values
2646: ( cglDateRec.trx_header_id,
2647: arp_standard.fnd_message('AR_TAPI_NO_PERIOD_FOR_GL_DATE'),
2648: cglDateRec.gl_date );
2649:
2650: END;
2651: ELSE

Line 2662: arp_standard.fnd_message('AR_RAXTRX-1785'),

2658: error_message,
2659: invalid_value)
2660: values
2661: ( cglDateRec.trx_header_id,
2662: arp_standard.fnd_message('AR_RAXTRX-1785'),
2663: cglDateRec.gl_date );
2664:
2665: END IF;
2666: END IF;

Line 2697: arp_standard.fnd_message('AR_INAPI_INVALID_AGREEMENT_ID'),

2693: trx_header_id,
2694: error_message,
2695: invalid_value)
2696: SELECT trx_header_id,
2697: arp_standard.fnd_message('AR_INAPI_INVALID_AGREEMENT_ID'),
2698: agreement_id
2699: FROM ar_trx_header_gt gt
2700: WHERE gt.agreement_id IS NOT NULL
2701: AND NOT EXISTS (

Line 2820: arp_standard.fnd_message('AR_INAPI_INVALID_BATCH_SOURCE'),

2816: trx_header_id,
2817: error_message,
2818: invalid_value)
2819: SELECT gt.trx_header_id,
2820: arp_standard.fnd_message('AR_INAPI_INVALID_BATCH_SOURCE'),
2821: gt.batch_source_id
2822: FROM ar_trx_header_gt gt;
2823: WHEN OTHERS THEN
2824: x_errmsg := 'Error in AR_INVOICE_UTILS.Get_batch_source_details '||sqlerrm;

Line 2919: arp_standard.fnd_message('ARTA_INVALID_TRX_TYPE'),

2915: trx_header_id,
2916: error_message,
2917: invalid_value)
2918: SELECT gt.trx_header_id,
2919: arp_standard.fnd_message('ARTA_INVALID_TRX_TYPE'),
2920: gt.cust_trx_type_id
2921: FROM ar_trx_header_gt gt
2922: WHERE gt.cust_trx_type_id = cust_trx_type_rec.cust_trx_type_id;
2923:

Line 3803: AND cp1.standard_terms = t_cp1.term_id(+)

3799: AND cp2.cust_account_id = gt.bill_to_customer_id
3800: AND su.site_use_id = cp1.site_use_id(+)
3801: AND cp2.site_use_id IS NULL
3802: AND su.payment_term_id = t_su.term_id(+)
3803: AND cp1.standard_terms = t_cp1.term_id(+)
3804: AND cp2.standard_terms = t_cp2.term_id(+)
3805: AND NVL(
3806: t_su.term_id,
3807: NVL(

Line 3804: AND cp2.standard_terms = t_cp2.term_id(+)

3800: AND su.site_use_id = cp1.site_use_id(+)
3801: AND cp2.site_use_id IS NULL
3802: AND su.payment_term_id = t_su.term_id(+)
3803: AND cp1.standard_terms = t_cp1.term_id(+)
3804: AND cp2.standard_terms = t_cp2.term_id(+)
3805: AND NVL(
3806: t_su.term_id,
3807: NVL(
3808: t_cp1.term_id,

Line 3934: arp_standard.fnd_message('AR_INAPI_INV_BILL_TO_CUST_ID'),

3930: trx_header_id,
3931: error_message,
3932: invalid_value)
3933: SELECT trx_header_id,
3934: arp_standard.fnd_message('AR_INAPI_INV_BILL_TO_CUST_ID'),
3935: bill_to_address_id
3936: FROM ar_trx_header_gt gt
3937: WHERE gt.bill_to_customer_id IS NULL;
3938: END IF;

Line 3965: arp_standard.fnd_message('AR_INAPI_INVALID_BILL_ADDR_ID'),

3961: trx_header_id,
3962: error_message,
3963: invalid_value)
3964: SELECT trx_header_id,
3965: arp_standard.fnd_message('AR_INAPI_INVALID_BILL_ADDR_ID'),
3966: bill_to_address_id
3967: FROM ar_trx_header_gt gt
3968: WHERE gt.bill_to_address_id IS NULL;
3969: END IF;

Line 4139: arp_standard.fnd_message('AR_INAPI_UOM_NOT_REQ'),

4135: error_message,
4136: invalid_value )
4137: SELECT trx_header_id,
4138: trx_line_id,
4139: arp_standard.fnd_message('AR_INAPI_UOM_NOT_REQ'),
4140: gt.uom_code
4141: FROM ar_trx_lines_gt gt
4142: WHERE gt.uom_code IS NOT NULL
4143: AND gt.line_type <> 'LINE';

Line 4154: arp_standard.fnd_message('AR_INAPI_CM_UOM_NOT_ALLOWED'),

4150: error_message,
4151: invalid_value )
4152: SELECT gt.trx_header_id,
4153: gt.trx_line_id,
4154: arp_standard.fnd_message('AR_INAPI_CM_UOM_NOT_ALLOWED'),
4155: gt.uom_code
4156: FROM ar_trx_lines_gt gt, ar_trx_header_gt gt2
4157: WHERE gt.uom_code IS NOT NULL
4158: AND gt.line_type = 'LINE'

Line 4169: arp_standard.fnd_message('AR_INAPI_INVALID_UOM'),

4165: error_message,
4166: invalid_value )
4167: SELECT gt.trx_header_id,
4168: gt.trx_line_id,
4169: arp_standard.fnd_message('AR_INAPI_INVALID_UOM'),
4170: gt.uom_code
4171: FROM ar_trx_lines_gt gt , ar_trx_header_gt gt2
4172: WHERE gt.uom_code IS NOT NULL
4173: AND gt.line_type = 'LINE'

Line 4254: arp_standard.fnd_message('AR_INAPI_INVALID_TAX_LINE'),

4250: error_message,
4251: invalid_value )
4252: SELECT trx_header_id,
4253: trx_line_id,
4254: arp_standard.fnd_message('AR_INAPI_INVALID_TAX_LINE'),
4255: gt.vat_tax_id
4256: FROM ar_trx_lines_gt gt
4257: WHERE extended_amount IS NULL
4258: AND line_type in ('TAX', 'FREIGHT');

Line 4267: arp_standard.fnd_message('AR_INAPI_QTY_NOT_ALLOWED'),

4263: error_message,
4264: invalid_value )
4265: SELECT trx_header_id,
4266: trx_line_id,
4267: arp_standard.fnd_message('AR_INAPI_QTY_NOT_ALLOWED'),
4268: gt.vat_tax_id
4269: FROM ar_trx_lines_gt gt
4270: WHERE line_type in ('TAX', 'FREIGHT')
4271: AND (quantity_invoiced IS NOT NULL

Line 4283: arp_standard.fnd_message('AR_RAXTRX-1706B'),

4279: error_message,
4280: invalid_value )
4281: SELECT trx_header_id,
4282: trx_line_id,
4283: arp_standard.fnd_message('AR_RAXTRX-1706B'),
4284: gt.tax_regime_code || ', ' ||
4285: gt.tax || ', ' ||
4286: gt.tax_status_code || ', ' ||
4287: gt.tax_rate_code || ', ' ||

Line 4355: arp_standard.fnd_message('AR_INAPI_INV_TAX_EXEMPT_FLAG'),

4351: error_message,
4352: invalid_value )
4353: SELECT trx_header_id,
4354: trx_line_id,
4355: arp_standard.fnd_message('AR_INAPI_INV_TAX_EXEMPT_FLAG'),
4356: tax_exempt_flag
4357: FROM ar_trx_lines_gt
4358: WHERE tax_exempt_flag IS NOT NULL
4359: AND NOT EXISTS

Line 4379: arp_standard.fnd_message('AR_INAPI_REASON_NOT_REQ')

4375: trx_line_id,
4376: error_message)
4377: SELECT trx_header_id,
4378: trx_line_id,
4379: arp_standard.fnd_message('AR_INAPI_REASON_NOT_REQ')
4380: FROM ar_trx_lines_gt
4381: WHERE tax_exempt_flag = 'E'
4382: AND TAX_EXEMPT_REASON_CODE IS NULL;
4383:

Line 4398: arp_standard.fnd_message('AR_INAPI_INVALID_TAX_EXEMPT_CODE'),

4394: error_message,
4395: invalid_value)
4396: SELECT trx_header_id,
4397: trx_line_id,
4398: arp_standard.fnd_message('AR_INAPI_INVALID_TAX_EXEMPT_CODE'),
4399: TAX_EXEMPT_REASON_CODE
4400: FROM ar_trx_lines_gt
4401: WHERE TAX_EXEMPT_REASON_CODE IS NOT null
4402: AND NOT EXISTS (

Line 4444: arp_standard.fnd_message('AR_INAPI_REASON_NOT_REQ'),

4440: error_message,
4441: invalid_value )
4442: SELECT trx_header_id,
4443: trx_line_id,
4444: arp_standard.fnd_message('AR_INAPI_REASON_NOT_REQ'),
4445: gt.reason_code
4446: FROM ar_trx_lines_gt gt
4447: WHERE gt.reason_code IS NOT NULL
4448: AND gt.line_type = 'TAX';

Line 4458: arp_standard.fnd_message('AR_INAPI_INVALID_REASON'),

4454: error_message,
4455: invalid_value )
4456: SELECT trx_header_id,
4457: trx_line_id,
4458: arp_standard.fnd_message('AR_INAPI_INVALID_REASON'),
4459: gt.reason_code
4460: FROM ar_trx_lines_gt gt
4461: WHERE gt.reason_code IS NOT NULL
4462: AND NOT EXISTS (

Line 4500: arp_standard.fnd_message('AR_INAPI_INV_DESC_NULL')

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')
4501: FROM ar_trx_lines_gt gt
4502: WHERE gt.description IS NULL
4503: AND gt.inventory_item_id IS NULL
4504: AND gt.memo_line_id IS NULL

Line 4513: arp_standard.fnd_message('AR_DAPI_MEMO_NAME_INVALID')

4509: trx_line_id,
4510: error_message)
4511: SELECT trx_header_id,
4512: trx_line_id,
4513: arp_standard.fnd_message('AR_DAPI_MEMO_NAME_INVALID')
4514: FROM ar_trx_lines_gt gt
4515: WHERE gt.memo_line_id IS NOT NULL
4516: AND gt.line_type = 'LINE'
4517: AND NOT EXISTS (

Line 4572: arp_standard.fnd_message('AR_INAPI_QTY_NOT_NULL')

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')
4573: FROM ar_trx_lines_gt gt ,
4574: ar_trx_header_gt gt2
4575: WHERE gt.quantity_invoiced IS NULL
4576: AND gt.trx_header_id = gt2.trx_header_id

Line 4607: arp_standard.fnd_message('AR_INAPI_UNIT_PRICE_NOT_NULL')

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')
4608: FROM ar_trx_lines_gt gt ,
4609: ar_trx_header_gt gt2
4610: WHERE gt.unit_selling_price IS NULL
4611: AND gt.trx_header_id = gt2.trx_header_id

Line 4640: arp_standard.fnd_message('AR_INAPI_INAVLID_LINE_TYPE'),

4636: ( trx_header_id,
4637: error_message,
4638: invalid_value )
4639: SELECT trx_header_id,
4640: arp_standard.fnd_message('AR_INAPI_INAVLID_LINE_TYPE'),
4641: gt.line_type
4642: FROM ar_trx_lines_gt gt
4643: WHERE gt.line_type not in ('LINE', 'TAX', 'FREIGHT');
4644: IF pg_debug = 'Y'

Line 4671: arp_standard.fnd_message('AR_INAPI_LINE_NUM_NOT_NULL')

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

Line 4726: arp_standard.fnd_message('AR_INAPI_HDR_ID_NOT_NULL')

4722: trx_line_id,
4723: error_message)
4724: SELECT trx_header_id,
4725: trx_line_id,
4726: arp_standard.fnd_message('AR_INAPI_HDR_ID_NOT_NULL')
4727: FROM ar_trx_lines_gt gt
4728: WHERE gt.trx_header_id IS NULL
4729: OR gt.trx_line_id IS NULL;
4730:

Line 4739: arp_standard.fnd_message('AR_INAPI_LINK_LINE_ID_NOT_NULL')

4735: trx_line_id,
4736: error_message)
4737: SELECT trx_header_id,
4738: trx_line_id,
4739: arp_standard.fnd_message('AR_INAPI_LINK_LINE_ID_NOT_NULL')
4740: FROM ar_trx_lines_gt gt
4741: WHERE gt.line_type = 'TAX'
4742: AND gt.link_to_trx_line_id IS NULL;
4743:

Line 4771: arp_standard.fnd_message('AR_TAPI_FREIGHT_NOT_ALLOWED'));

4767: ( trx_header_id,
4768: error_message)
4769: VALUES
4770: ( c_freight_rec.trx_header_id,
4771: arp_standard.fnd_message('AR_TAPI_FREIGHT_NOT_ALLOWED'));
4772: END IF;
4773: END;
4774:
4775: IF ( c_freight_rec.number_of_freight_lines > 1 )

Line 4805: arp_standard.fnd_message('AR_TAPI_TOO_MANY_FREIGHT_LINE')

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')
4806: FROM ar_trx_header_gt gt
4807: WHERE gt.trx_header_id = c_freight_rec.trx_header_id;
4808: END IF;
4809: END IF;

Line 4840: arp_standard.fnd_message('AR_INAPI_INVALID_SHIP_VIA')

4836: trx_line_id,
4837: error_message)
4838: SELECT trx_header_id,
4839: trx_line_id,
4840: arp_standard.fnd_message('AR_INAPI_INVALID_SHIP_VIA')
4841: FROM ar_trx_lines_gt gt
4842: WHERE gt.line_type = 'FREIGHT'
4843: AND gt.ship_via IS NOT NULL
4844: AND NOT EXISTS (

Line 4858: arp_standard.fnd_message('AR_INAPI_INVALID_FOB')

4854: trx_line_id,
4855: error_message)
4856: SELECT trx_header_id,
4857: trx_line_id,
4858: arp_standard.fnd_message('AR_INAPI_INVALID_FOB')
4859: FROM ar_trx_lines_gt gt
4860: WHERE gt.line_type = 'FREIGHT'
4861: AND gt.fob_point IS NOT NULL
4862: AND NOT EXISTS (

Line 4876: arp_standard.fnd_message('AR_INAPI_EXT_AMT_NOT_NULL')

4872: trx_line_id,
4873: error_message)
4874: SELECT trx_header_id,
4875: trx_line_id,
4876: arp_standard.fnd_message('AR_INAPI_EXT_AMT_NOT_NULL')
4877: FROM ar_trx_lines_gt gt
4878: WHERE gt.line_type = 'FREIGHT'
4879: AND gt.extended_amount IS NULL;
4880:

Line 4959: arp_standard.fnd_message('AR_INAPI_AMT_SIGN_INVALID'));

4955: ( trx_header_id,
4956: error_message)
4957: VALUES
4958: ( c_line_rec.trx_header_id,
4959: arp_standard.fnd_message('AR_INAPI_AMT_SIGN_INVALID'));
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

Line 4969: arp_standard.fnd_message('AR_INAPI_AMT_SIGN_INVALID'));

4965: ( trx_header_id,
4966: error_message)
4967: VALUES
4968: ( c_line_rec.trx_header_id,
4969: arp_standard.fnd_message('AR_INAPI_AMT_SIGN_INVALID'));
4970: END IF;
4971: END IF;
4972: END LOOP;
4973: */

Line 4996: arp_standard.fnd_message('AR_INAPI_AMT_INVALID'));

4992: error_message)
4993: VALUES
4994: ( c_line_rec.trx_header_id,
4995: c_line_rec.trx_line_id,
4996: arp_standard.fnd_message('AR_INAPI_AMT_INVALID'));
4997: END IF;
4998: END IF;
4999:
5000: END LOOP;

Line 5047: arp_standard.fnd_message('AR_INAPI_DUP_DOC_SEQUENCE')

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')
5048: FROM ar_trx_header_gt gt
5049: WHERE gt.cust_trx_type_id IS NOT NULL
5050: AND gt.doc_sequence_value IS NOT NULL
5051: AND EXISTS (

Line 5188: arp_standard.fnd_message('AR_INAPI_DUP_DOC_SEQUENCE'),

5184: error_message,
5185: invalid_value)
5186: VALUES
5187: ( ctrxHeaderRec.trx_header_id,
5188: arp_standard.fnd_message('AR_INAPI_DUP_DOC_SEQUENCE'),
5189: l_doc_sequence_value );
5190:
5191: l_seq_err := TRUE;
5192: END;

Line 5304: arp_standard.debug ( 'inside Copy payment trxn ');

5300:
5301: BEGIN
5302:
5303:
5304: arp_standard.debug ( 'inside Copy payment trxn ');
5305:
5306: IF pg_debug = 'Y'
5307: THEN
5308: arp_standard.debug ( 'inside Copy payment trxn ');

Line 5308: arp_standard.debug ( 'inside Copy payment trxn ');

5304: arp_standard.debug ( 'inside Copy payment trxn ');
5305:
5306: IF pg_debug = 'Y'
5307: THEN
5308: arp_standard.debug ( 'inside Copy payment trxn ');
5309: END IF;
5310: x_return_status := FND_API.G_RET_STS_SUCCESS;
5311:
5312: FOR ctrxHeaderRec IN ctrxHeader

Line 5343: l_trxn_attribs_rec.Originating_Application_Id := arp_standard.application_id;

5339: l_payer_rec.org_type := NULL;
5340:
5341: end if;
5342:
5343: l_trxn_attribs_rec.Originating_Application_Id := arp_standard.application_id;
5344: l_trxn_attribs_rec.order_id := ctrxHeaderRec.customer_trx_id ;
5345: l_trxn_attribs_rec.Trxn_Ref_Number1 := 'INVOICE';
5346: l_trxn_attribs_rec.Trxn_Ref_Number2 := ctrxHeaderRec.trx_number;
5347: l_trxn_attribs_rec.seq_type_last := ctrxHeaderRec.mandate_last_trx_flag;

Line 5352: arp_standard.debug('l_payer.payment_function :<' || l_payer_rec.payment_function || '>');

5348: l_assignment_id := l_assignment_id;
5349: l_pmt_trxn_extension_id(1) := ctrxHeaderRec.payment_trxn_extension_id;
5350:
5351:
5352: arp_standard.debug('l_payer.payment_function :<' || l_payer_rec.payment_function || '>');
5353: arp_standard.debug('l_payer.Party_Id :<' || l_payer_rec.Party_Id || '>');
5354: arp_standard.debug('l_payer.Org_Type :<' || l_payer_rec.Org_Type || '>');
5355: arp_standard.debug('l_payer.Org_id :<' || l_payer_rec.Org_id || '>');
5356: arp_standard.debug('l_payer.Cust_Account_Id :<' || l_payer_rec.Cust_Account_Id || '>');

Line 5353: arp_standard.debug('l_payer.Party_Id :<' || l_payer_rec.Party_Id || '>');

5349: l_pmt_trxn_extension_id(1) := ctrxHeaderRec.payment_trxn_extension_id;
5350:
5351:
5352: arp_standard.debug('l_payer.payment_function :<' || l_payer_rec.payment_function || '>');
5353: arp_standard.debug('l_payer.Party_Id :<' || l_payer_rec.Party_Id || '>');
5354: arp_standard.debug('l_payer.Org_Type :<' || l_payer_rec.Org_Type || '>');
5355: arp_standard.debug('l_payer.Org_id :<' || l_payer_rec.Org_id || '>');
5356: arp_standard.debug('l_payer.Cust_Account_Id :<' || l_payer_rec.Cust_Account_Id || '>');
5357: arp_standard.debug('l_trxn_attribs.order_id :<'|| l_trxn_attribs_rec.order_id || '>');

Line 5354: arp_standard.debug('l_payer.Org_Type :<' || l_payer_rec.Org_Type || '>');

5350:
5351:
5352: arp_standard.debug('l_payer.payment_function :<' || l_payer_rec.payment_function || '>');
5353: arp_standard.debug('l_payer.Party_Id :<' || l_payer_rec.Party_Id || '>');
5354: arp_standard.debug('l_payer.Org_Type :<' || l_payer_rec.Org_Type || '>');
5355: arp_standard.debug('l_payer.Org_id :<' || l_payer_rec.Org_id || '>');
5356: arp_standard.debug('l_payer.Cust_Account_Id :<' || l_payer_rec.Cust_Account_Id || '>');
5357: arp_standard.debug('l_trxn_attribs.order_id :<'|| l_trxn_attribs_rec.order_id || '>');
5358: arp_standard.debug('l_assignment_id :<'|| l_assignment_id || '>');

Line 5355: arp_standard.debug('l_payer.Org_id :<' || l_payer_rec.Org_id || '>');

5351:
5352: arp_standard.debug('l_payer.payment_function :<' || l_payer_rec.payment_function || '>');
5353: arp_standard.debug('l_payer.Party_Id :<' || l_payer_rec.Party_Id || '>');
5354: arp_standard.debug('l_payer.Org_Type :<' || l_payer_rec.Org_Type || '>');
5355: arp_standard.debug('l_payer.Org_id :<' || l_payer_rec.Org_id || '>');
5356: arp_standard.debug('l_payer.Cust_Account_Id :<' || l_payer_rec.Cust_Account_Id || '>');
5357: arp_standard.debug('l_trxn_attribs.order_id :<'|| l_trxn_attribs_rec.order_id || '>');
5358: arp_standard.debug('l_assignment_id :<'|| l_assignment_id || '>');
5359: arp_standard.debug('payment_trx_extension_id :<'|| l_pmt_trxn_extension_id(1) || '>');

Line 5356: arp_standard.debug('l_payer.Cust_Account_Id :<' || l_payer_rec.Cust_Account_Id || '>');

5352: arp_standard.debug('l_payer.payment_function :<' || l_payer_rec.payment_function || '>');
5353: arp_standard.debug('l_payer.Party_Id :<' || l_payer_rec.Party_Id || '>');
5354: arp_standard.debug('l_payer.Org_Type :<' || l_payer_rec.Org_Type || '>');
5355: arp_standard.debug('l_payer.Org_id :<' || l_payer_rec.Org_id || '>');
5356: arp_standard.debug('l_payer.Cust_Account_Id :<' || l_payer_rec.Cust_Account_Id || '>');
5357: arp_standard.debug('l_trxn_attribs.order_id :<'|| l_trxn_attribs_rec.order_id || '>');
5358: arp_standard.debug('l_assignment_id :<'|| l_assignment_id || '>');
5359: arp_standard.debug('payment_trx_extension_id :<'|| l_pmt_trxn_extension_id(1) || '>');
5360:

Line 5357: arp_standard.debug('l_trxn_attribs.order_id :<'|| l_trxn_attribs_rec.order_id || '>');

5353: arp_standard.debug('l_payer.Party_Id :<' || l_payer_rec.Party_Id || '>');
5354: arp_standard.debug('l_payer.Org_Type :<' || l_payer_rec.Org_Type || '>');
5355: arp_standard.debug('l_payer.Org_id :<' || l_payer_rec.Org_id || '>');
5356: arp_standard.debug('l_payer.Cust_Account_Id :<' || l_payer_rec.Cust_Account_Id || '>');
5357: arp_standard.debug('l_trxn_attribs.order_id :<'|| l_trxn_attribs_rec.order_id || '>');
5358: arp_standard.debug('l_assignment_id :<'|| l_assignment_id || '>');
5359: arp_standard.debug('payment_trx_extension_id :<'|| l_pmt_trxn_extension_id(1) || '>');
5360:
5361: IBY_FNDCPT_TRXN_PUB.Copy_Transaction_Extension

Line 5358: arp_standard.debug('l_assignment_id :<'|| l_assignment_id || '>');

5354: arp_standard.debug('l_payer.Org_Type :<' || l_payer_rec.Org_Type || '>');
5355: arp_standard.debug('l_payer.Org_id :<' || l_payer_rec.Org_id || '>');
5356: arp_standard.debug('l_payer.Cust_Account_Id :<' || l_payer_rec.Cust_Account_Id || '>');
5357: arp_standard.debug('l_trxn_attribs.order_id :<'|| l_trxn_attribs_rec.order_id || '>');
5358: arp_standard.debug('l_assignment_id :<'|| l_assignment_id || '>');
5359: arp_standard.debug('payment_trx_extension_id :<'|| l_pmt_trxn_extension_id(1) || '>');
5360:
5361: IBY_FNDCPT_TRXN_PUB.Copy_Transaction_Extension
5362: ( p_api_version => 1.0,

Line 5359: arp_standard.debug('payment_trx_extension_id :<'|| l_pmt_trxn_extension_id(1) || '>');

5355: arp_standard.debug('l_payer.Org_id :<' || l_payer_rec.Org_id || '>');
5356: arp_standard.debug('l_payer.Cust_Account_Id :<' || l_payer_rec.Cust_Account_Id || '>');
5357: arp_standard.debug('l_trxn_attribs.order_id :<'|| l_trxn_attribs_rec.order_id || '>');
5358: arp_standard.debug('l_assignment_id :<'|| l_assignment_id || '>');
5359: arp_standard.debug('payment_trx_extension_id :<'|| l_pmt_trxn_extension_id(1) || '>');
5360:
5361: IBY_FNDCPT_TRXN_PUB.Copy_Transaction_Extension
5362: ( p_api_version => 1.0,
5363: p_init_msg_list => FND_API.G_TRUE,

Line 5381: arp_standard.debug('the copied value of trx_entn is ' || o_payment_trxn_extension_id );

5377: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
5378:
5379: o_payment_trxn_extension_id := p_trxn_entity_id ;
5380:
5381: arp_standard.debug('the copied value of trx_entn is ' || o_payment_trxn_extension_id );
5382:
5383: UPDATE ar_trx_header_gt
5384: SET payment_trxn_extension_id = o_payment_trxn_extension_id
5385: WHERE trx_header_id = ctrxHeaderRec.trx_header_id;

Line 5403: arp_standard.fnd_message('AR_CC_AUTH_FAILED'),

5399: error_message,
5400: invalid_value)
5401: VALUES
5402: ( ctrxHeaderRec.trx_header_id,
5403: arp_standard.fnd_message('AR_CC_AUTH_FAILED'),
5404: ctrxHeaderRec.payment_trxn_extension_id );
5405:
5406: END IF;
5407:

Line 5467: arp_standard.fnd_message('AR_INAPI_INVALID_ITEM_D'),

5463: invalid_value)
5464: VALUES
5465: ( cItemFlexRec.trx_header_id,
5466: cItemFlexRec.trx_line_id,
5467: arp_standard.fnd_message('AR_INAPI_INVALID_ITEM_D'),
5468: cItemFlexRec.inventory_item_id );
5469: ELSE
5470: /*Bug 3844408*/
5471: /*This update should be fired only when the description isn't populated

Line 5492: arp_standard.fnd_message('AR_INAPI_INVALID_ITEM_ID'),

5488: invalid_value)
5489: VALUES
5490: ( cItemFlexRec.trx_header_id,
5491: cItemFlexRec.trx_line_id,
5492: arp_standard.fnd_message('AR_INAPI_INVALID_ITEM_ID'),
5493: cItemFlexRec.inventory_item_id );
5494: END IF;
5495: END LOOP;
5496:

Line 5539: arp_standard.fnd_message('AR_INAPI_INVALID_TERRITORY'),

5535: error_message,
5536: invalid_value)
5537: VALUES
5538: ( cTerritoryRec.trx_header_id,
5539: arp_standard.fnd_message('AR_INAPI_INVALID_TERRITORY'),
5540: cTerritoryRec.territory_id );
5541: END IF;
5542: END LOOP;
5543: IF pg_debug = 'Y'

Line 5572: arp_standard.fnd_message('AR_RAXTRX_INV_WAREHOUSE'),

5568: error_message,
5569: Invalid_value )
5570: select l.trx_line_id,
5571: l.trx_header_id,
5572: arp_standard.fnd_message('AR_RAXTRX_INV_WAREHOUSE'),
5573: l.warehouse_id
5574: from ar_trx_lines_gt l
5575: where l.line_type = 'LINE'
5576: and l.warehouse_id is not null

Line 5643: arp_standard.fnd_message('AR_INAPI_INVALID_RULE_NAME')

5639: trx_line_id,
5640: error_message)
5641: SELECT gt.trx_header_id,
5642: gt.trx_line_id,
5643: arp_standard.fnd_message('AR_INAPI_INVALID_RULE_NAME')
5644: FROM ar_trx_lines_gt gt , ar_trx_header_gt gt2
5645: WHERE gt.accounting_rule_id IS NOT NULL
5646: AND gt2.trx_header_id = gt.trx_header_id
5647: AND gt2.trx_class <> 'CM' -- Added for ER 5869149

Line 5661: arp_standard.fnd_message('AR_INAPI_RULE_NAME_NOT_NULL')

5657: trx_line_id,
5658: error_message)
5659: SELECT gt.trx_header_id,
5660: gt.trx_line_id,
5661: arp_standard.fnd_message('AR_INAPI_RULE_NAME_NOT_NULL')
5662: FROM ar_trx_lines_gt gt, ar_trx_header_gt gth
5663: WHERE gt.accounting_rule_id IS NULL
5664: AND gt.trx_header_id = gth.trx_header_id
5665: AND gth.invoicing_rule_id IS NOT NULL

Line 5677: arp_standard.fnd_message('AR_INAPI_RULE_NOT_ALLOWED')

5673: trx_line_id,
5674: error_message)
5675: SELECT gt.trx_header_id,
5676: gt.trx_line_id,
5677: arp_standard.fnd_message('AR_INAPI_RULE_NOT_ALLOWED')
5678: FROM ar_trx_lines_gt gt, ar_trx_header_gt gth
5679: WHERE (gt.accounting_rule_id IS NOT NULL
5680: OR gth.invoicing_rule_id IS NOT NULL)
5681: AND gt.trx_header_id = gth.trx_header_id

Line 5697: arp_standard.fnd_message('AR_INAPI_RULE_NAME_NOT_NULL') );

5693: trx_line_id,
5694: error_message) VALUES
5695: ( c_invoicing_rule_rec.trx_header_id,
5696: c_invoicing_rule_rec.trx_line_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

Line 5707: arp_standard.fnd_message('AR_RAXTRX_RULE_START_DT_NULL'));

5703: trx_line_id,
5704: error_message) VALUES
5705: ( c_invoicing_rule_rec.trx_header_id,
5706: c_invoicing_rule_rec.trx_line_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

Line 5717: arp_standard.fnd_message('AR_RAXTRX_RULE_END_DT_NULL'));

5713: trx_line_id,
5714: error_message) VALUES
5715: ( c_invoicing_rule_rec.trx_header_id,
5716: c_invoicing_rule_rec.trx_line_id,
5717: arp_standard.fnd_message('AR_RAXTRX_RULE_END_DT_NULL'));
5718: END IF;
5719:
5720: IF c_invoicing_rule_rec.RULE_END_DATE < c_invoicing_rule_rec.RULE_START_DATE
5721: THEN

Line 5728: arp_standard.fnd_message('AR_RAXTRX_RSD_LT_RED'));

5724: trx_line_id,
5725: error_message) VALUES
5726: ( c_invoicing_rule_rec.trx_header_id,
5727: c_invoicing_rule_rec.trx_line_id,
5728: arp_standard.fnd_message('AR_RAXTRX_RSD_LT_RED'));
5729: ELSE
5730: UPDATE ar_trx_lines_gt a
5731: SET ACCOUNTING_RULE_DURATION =
5732: (SELECT COUNT(*)

Line 5765: arp_standard.fnd_message('AR_INAPI_RULE_DUR_NOT_NULL' ));

5761: trx_line_id,
5762: error_message) VALUES
5763: ( c_invoicing_rule_rec.trx_header_id,
5764: c_invoicing_rule_rec.trx_line_id,
5765: arp_standard.fnd_message('AR_INAPI_RULE_DUR_NOT_NULL' ));
5766: ELSE
5767: UPDATE ar_trx_lines_gt
5768: SET ACCOUNTING_RULE_DURATION = c_invoicing_rule_rec.occurrences
5769: WHERE trx_line_id = c_invoicing_rule_rec.trx_line_id

Line 5868: arp_standard.fnd_message('AR_INAPI_RULE_START_DT_NO_NULL') );

5864: trx_line_id,
5865: error_message) VALUES
5866: ( c_invoicing_rule_rec.trx_header_id,
5867: c_invoicing_rule_rec.trx_line_id,
5868: arp_standard.fnd_message('AR_INAPI_RULE_START_DT_NO_NULL') );
5869: END IF;
5870: END IF;
5871: END IF;
5872: END;

Line 5910: arp_standard.fnd_message('AR_INAPI_INVALID_USSGL_CODE'),

5906: error_message,
5907: invalid_value)
5908: SELECT trx_header_id,
5909: trx_line_id,
5910: arp_standard.fnd_message('AR_INAPI_INVALID_USSGL_CODE'),
5911: default_ussgl_transaction_code
5912: FROM ar_trx_lines_gt gt
5913: WHERE gt.default_ussgl_transaction_code IS NOT NULL
5914: AND NOT EXISTS

Line 6081: arp_standard.fnd_message('AR_INAPI_NO_EXCH_DEFINE'),

6077: error_message,
6078: invalid_value)
6079: VALUES
6080: ( cExchangeRateRec.trx_header_id,
6081: arp_standard.fnd_message('AR_INAPI_NO_EXCH_DEFINE'),
6082: cExchangeRateRec.trx_currency);
6083:
6084: END;
6085: END LOOP;

Line 6101: arp_standard.fnd_message('AR_EXCHANGE_RATE_NEEDED'),

6097: trx_header_id,
6098: error_message,
6099: invalid_value)
6100: SELECT trx_header_id,
6101: arp_standard.fnd_message('AR_EXCHANGE_RATE_NEEDED'),
6102: gt.trx_currency
6103: FROM ar_trx_header_gt gt
6104: WHERE gt.trx_currency IS NOT NULL
6105: AND ( exchange_rate IS NULL

Line 6320: arp_standard.debug('Processing customer_trx_id :- '||cCustDetailsRec.customer_trx_id);

6316: payment_trxn_extension_id=l_entity_id
6317: WHERE trx_header_id = cCustDetailsRec.trx_header_id;
6318:
6319: ELSE
6320: arp_standard.debug('Processing customer_trx_id :- '||cCustDetailsRec.customer_trx_id);
6321: arp_standard.debug('result_code :- '||l_response.result_code);
6322: arp_standard.debug('result_category :- '||l_response.result_category);
6323: arp_standard.debug('result_message :- '||l_response.result_message);
6324: arp_standard.debug('l_return_status :- '||l_return_status);

Line 6321: arp_standard.debug('result_code :- '||l_response.result_code);

6317: WHERE trx_header_id = cCustDetailsRec.trx_header_id;
6318:
6319: ELSE
6320: arp_standard.debug('Processing customer_trx_id :- '||cCustDetailsRec.customer_trx_id);
6321: arp_standard.debug('result_code :- '||l_response.result_code);
6322: arp_standard.debug('result_category :- '||l_response.result_category);
6323: arp_standard.debug('result_message :- '||l_response.result_message);
6324: arp_standard.debug('l_return_status :- '||l_return_status);
6325: arp_standard.debug('l_msg_count :- '||l_msg_count);

Line 6322: arp_standard.debug('result_category :- '||l_response.result_category);

6318:
6319: ELSE
6320: arp_standard.debug('Processing customer_trx_id :- '||cCustDetailsRec.customer_trx_id);
6321: arp_standard.debug('result_code :- '||l_response.result_code);
6322: arp_standard.debug('result_category :- '||l_response.result_category);
6323: arp_standard.debug('result_message :- '||l_response.result_message);
6324: arp_standard.debug('l_return_status :- '||l_return_status);
6325: arp_standard.debug('l_msg_count :- '||l_msg_count);
6326: arp_standard.debug('l_msg_data :- '||l_msg_data);

Line 6323: arp_standard.debug('result_message :- '||l_response.result_message);

6319: ELSE
6320: arp_standard.debug('Processing customer_trx_id :- '||cCustDetailsRec.customer_trx_id);
6321: arp_standard.debug('result_code :- '||l_response.result_code);
6322: arp_standard.debug('result_category :- '||l_response.result_category);
6323: arp_standard.debug('result_message :- '||l_response.result_message);
6324: arp_standard.debug('l_return_status :- '||l_return_status);
6325: arp_standard.debug('l_msg_count :- '||l_msg_count);
6326: arp_standard.debug('l_msg_data :- '||l_msg_data);
6327: END IF;

Line 6324: arp_standard.debug('l_return_status :- '||l_return_status);

6320: arp_standard.debug('Processing customer_trx_id :- '||cCustDetailsRec.customer_trx_id);
6321: arp_standard.debug('result_code :- '||l_response.result_code);
6322: arp_standard.debug('result_category :- '||l_response.result_category);
6323: arp_standard.debug('result_message :- '||l_response.result_message);
6324: arp_standard.debug('l_return_status :- '||l_return_status);
6325: arp_standard.debug('l_msg_count :- '||l_msg_count);
6326: arp_standard.debug('l_msg_data :- '||l_msg_data);
6327: END IF;
6328:

Line 6325: arp_standard.debug('l_msg_count :- '||l_msg_count);

6321: arp_standard.debug('result_code :- '||l_response.result_code);
6322: arp_standard.debug('result_category :- '||l_response.result_category);
6323: arp_standard.debug('result_message :- '||l_response.result_message);
6324: arp_standard.debug('l_return_status :- '||l_return_status);
6325: arp_standard.debug('l_msg_count :- '||l_msg_count);
6326: arp_standard.debug('l_msg_data :- '||l_msg_data);
6327: END IF;
6328:
6329:

Line 6326: arp_standard.debug('l_msg_data :- '||l_msg_data);

6322: arp_standard.debug('result_category :- '||l_response.result_category);
6323: arp_standard.debug('result_message :- '||l_response.result_message);
6324: arp_standard.debug('l_return_status :- '||l_return_status);
6325: arp_standard.debug('l_msg_count :- '||l_msg_count);
6326: arp_standard.debug('l_msg_data :- '||l_msg_data);
6327: END IF;
6328:
6329:
6330: END IF;

Line 6335: arp_standard.debug('Error in Default Payment Transaction Extension ID');

6331: END LOOP;
6332:
6333: EXCEPTION
6334: WHEN OTHERS THEN
6335: arp_standard.debug('Error in Default Payment Transaction Extension ID');
6336: arp_standard.debug('[' || SQLERRM(SQLCODE) || ']');
6337: x_errmsg := 'Error in Default Payment Transaction Extension ID' || SQLERRM;
6338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6339:

Line 6336: arp_standard.debug('[' || SQLERRM(SQLCODE) || ']');

6332:
6333: EXCEPTION
6334: WHEN OTHERS THEN
6335: arp_standard.debug('Error in Default Payment Transaction Extension ID');
6336: arp_standard.debug('[' || SQLERRM(SQLCODE) || ']');
6337: x_errmsg := 'Error in Default Payment Transaction Extension ID' || SQLERRM;
6338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6339:
6340: RAISE;

Line 7063: arp_standard.fnd_message('AR_INVALID_CCID'),

7059: VALUES
7060: ( CccidRec.trx_header_id,
7061: CccidRec.trx_line_id,
7062: CccidRec.trx_dist_id,
7063: arp_standard.fnd_message('AR_INVALID_CCID'),
7064: CccidRec.code_combination_id);
7065: END IF;
7066: END LOOP;
7067: IF pg_debug = 'Y'

Line 7112: arp_standard.fnd_message('AR_INAPI_CCID_NULL')

7108: error_message)
7109: SELECT d.trx_header_id,
7110: d.trx_line_id,
7111: D.trx_DIST_ID,
7112: arp_standard.fnd_message('AR_INAPI_CCID_NULL')
7113: FROM ar_trx_DIST_gt D
7114: WHERE code_combination_id IS NULL;
7115: -- the user can pass either amount or percent. If both amount and percent
7116: -- is passed then amount will take precendence.

Line 7127: arp_standard.fnd_message('AR_INAPI_AMT_PER_REQUIRED')

7123: error_message)
7124: SELECT d.trx_header_id,
7125: d.trx_line_id,
7126: D.trx_DIST_ID,
7127: arp_standard.fnd_message('AR_INAPI_AMT_PER_REQUIRED')
7128: FROM ar_trx_DIST_gt D
7129: WHERE d.PERCENT IS NULL
7130: AND d.amount IS NULL;
7131:

Line 7146: arp_standard.fnd_message('AR_INAPI_ONLY_PER_ALLOWED')

7142: error_message)
7143: SELECT d.trx_header_id,
7144: L.trx_line_id,
7145: D.trx_DIST_ID,
7146: arp_standard.fnd_message('AR_INAPI_ONLY_PER_ALLOWED')
7147: FROM ar_trx_DIST_gt D,
7148: ar_trx_lines_GT L
7149: WHERE (L.ACCOUNTING_RULE_ID IS NOT NULL
7150: OR D.ACCOUNT_CLASS = 'REC')

Line 7172: arp_standard.fnd_message('AR_INAPI_INAVLID_LINE_TYPE')

7168: error_message)
7169: SELECT d.trx_header_id,
7170: L.trx_LINE_ID,
7171: D.trx_DIST_ID,
7172: arp_standard.fnd_message('AR_INAPI_INAVLID_LINE_TYPE')
7173: FROM ar_trx_dist_gt D,
7174: ar_trx_LINES_GT L
7175: WHERE L.trx_LINE_ID = D.trx_LINE_ID
7176: AND DECODE(D.ACCOUNT_CLASS,

Line 7303: arp_standard.fnd_message('AR_INAPI_NVALID_SUM_DIST_AMT'),

7299: error_message,
7300: invalid_value)
7301: SELECT l.trx_header_id,
7302: L.trx_LINE_ID,
7303: arp_standard.fnd_message('AR_INAPI_NVALID_SUM_DIST_AMT'),
7304: d.account_class || ':'||SUM(d.amount)
7305: FROM ar_trx_DIST_gt D,
7306: ar_trx_lines_GT L
7307: WHERE L.ACCOUNTING_RULE_ID IS NULL

Line 7335: arp_standard.fnd_message('AR_INAPI_100_PERCENT'),

7331: error_message,
7332: invalid_value)
7333: SELECT d.trx_header_id,
7334: d.trx_line_ID,
7335: arp_standard.fnd_message('AR_INAPI_100_PERCENT'),
7336: sum(d.percent)
7337: FROM ar_trx_dist_gt d, ar_trx_lines_gt L, ar_trx_header_gt h
7338: WHERE d.trx_line_id = l.trx_line_id
7339: AND l.trx_header_id = h.trx_header_id

Line 7351: arp_standard.fnd_message('AR_INAPI_100_PERCENT'),

7347: (trx_header_id,
7348: error_message,
7349: invalid_value)
7350: SELECT d.trx_header_id,
7351: arp_standard.fnd_message('AR_INAPI_100_PERCENT'),
7352: sum(d.percent)
7353: FROM ar_trx_dist_gt d
7354: WHERE d.account_class = 'REC'
7355: GROUP BY d.trx_header_id

Line 7651: arp_standard.fnd_message(l_message_name),

7647: INVALID_VALUE)
7648: SELECT trx_header_id,
7649: trx_LINE_ID,
7650: trx_SALESCREDIT_ID,
7651: arp_standard.fnd_message(l_message_name),
7652: sc.salesrep_id
7653: FROM ar_trx_salescredits_gt SC
7654: WHERE salesrep_id IS NOT NULL
7655: AND NOT EXISTS

Line 7674: arp_standard.fnd_message(l_message_name),

7670: INVALID_VALUE)
7671: SELECT trx_header_id,
7672: trx_LINE_ID,
7673: trx_salescredit_id,
7674: arp_standard.fnd_message(l_message_name),
7675: sc.salesrep_num
7676: FROM ar_trx_salescredits_gt SC
7677: WHERE sc.salesrep_num IS NOT NULL
7678: AND NOT EXISTS

Line 7703: arp_standard.fnd_message(l_message_name),

7699: INVALID_VALUE)
7700: SELECT trx_header_id,
7701: trx_LINE_ID,
7702: trx_SALESCREDIT_ID,
7703: arp_standard.fnd_message(l_message_name),
7704: sc.sales_credit_type_id
7705: FROM ar_trx_salescredits_gt SC
7706: WHERE sales_credit_type_id IS NOT NULL
7707: AND NOT EXISTS

Line 7726: arp_standard.fnd_message(l_message_name),

7722: INVALID_VALUE)
7723: SELECT trx_header_id,
7724: trx_line_id,
7725: trx_salescredit_id,
7726: arp_standard.fnd_message(l_message_name),
7727: sc.sales_credit_type_name
7728: FROM ar_trx_salescredits_gt SC
7729: WHERE sales_credit_type_name IS NOT NULL
7730: AND NOT EXISTS

Line 7756: arp_standard.fnd_message(l_message_name)

7752: error_MESSAGE)
7753: SELECT trx_header_id,
7754: trx_LINE_ID,
7755: trx_SALESCREDIT_ID,
7756: arp_standard.fnd_message(l_message_name)
7757: FROM ar_trx_salescredits_gt SC,
7758: so_sales_credit_types CR --Bug8202014
7759: WHERE sc.sales_credit_type_id = cr.sales_credit_type_id --Bug8202014
7760: AND revenue_amount_split IS NULL

Line 7781: arp_standard.fnd_message(l_message_name),

7777: INVALID_VALUE)
7778: SELECT S.trx_header_id,
7779: S.trx_LINE_ID,
7780: S.trx_SALESCREDIT_ID,
7781: arp_standard.fnd_message(l_message_name),
7782: L.LINE_TYPE
7783: FROM ar_trx_LINES_GT L,
7784: ar_trx_SALESCREDITS_gt S
7785: WHERE S.trx_LINE_ID = L.trx_LINE_ID

Line 8007: arp_standard.fnd_message('AR_INAPI_INVALID_PRECISION'),

8003: invalid_value)
8004: SELECT S.trx_header_id,
8005: S.trx_LINE_ID,
8006: S.trx_SALESCREDIT_ID,
8007: arp_standard.fnd_message('AR_INAPI_INVALID_PRECISION'),
8008: S.revenue_amount_split
8009: FROM ar_trx_salescredits_gt S,
8010: ar_trx_LINES_GT L,
8011: FND_CURRENCIES C

Line 8045: arp_standard.fnd_message(l_message_name),

8041: invalid_value)
8042: SELECT SC.trx_header_id,
8043: SC.trx_LINE_ID,
8044: SC.trx_SALESCREDIT_ID,
8045: arp_standard.fnd_message(l_message_name),
8046: SC.revenue_percent_split
8047: FROM ar_trx_salescredits_gt SC,
8048: SO_SALES_CREDIT_TYPES SCT
8049: WHERE SC.SALES_CREDIT_TYPE_ID = SCT.SALES_CREDIT_TYPE_ID

Line 8067: arp_standard.fnd_message(l_message_name)

8063: trx_line_id,
8064: error_MESSAGE)
8065: SELECT SC.trx_header_id,
8066: SC.trx_LINE_ID,
8067: arp_standard.fnd_message(l_message_name)
8068: FROM
8069: ar_trx_salescredits_gt SC,
8070: SO_SALES_CREDIT_TYPES CR
8071: WHERE SC.SALES_CREDIT_TYPE_ID = CR.SALES_CREDIT_TYPE_ID

Line 8095: arp_standard.fnd_message(l_message_name),

8091: error_message,
8092: invalid_value)
8093: SELECT s.trx_header_id,
8094: s.trx_line_id,
8095: arp_standard.fnd_message(l_message_name),
8096: SUM(S.revenue_amount_split)
8097: FROM ar_trx_salescredits_gt s,
8098: so_sales_credit_types t
8099: WHERE s.sales_credit_type_id = t.sales_credit_type_id

Line 8135: arp_standard.fnd_message(l_message_name)

8131: trx_line_id,
8132: error_message)
8133: SELECT lgt.trx_header_id,
8134: lgt.trx_line_id,
8135: arp_standard.fnd_message(l_message_name)
8136: FROM ar_trx_lines_gt lgt
8137: WHERE lgt.line_type = 'LINE'
8138: AND NOT EXISTS
8139: (SELECT 'X'