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.ARP_TRX_COMPLETE_CHK dependencies on ARP_TRX_VALIDATE

Line 48: | arp_trx_validate.validate_trx_date |

44: | arp_non_db_pkg.check_creation_sign |
45: | arp_non_db_pkg.check_natural_application |
46: | arp_trx_global.profile_info.use_inv_acct_for_cm_flag |
47: | arp_trx_util.get_summary_trx_balances |
48: | arp_trx_validate.validate_trx_date |
49: | arp_util.debug |
50: | arp_util.validate_and_default_gl_date |
51: | |
52: | ARGUMENTS : IN: |

Line 239: arp_util.debug('arp_trx_validate.check_tax_and_accounting()+');

235:
236: BEGIN
237:
238: IF PG_DEBUG in ('Y', 'C') THEN
239: arp_util.debug('arp_trx_validate.check_tax_and_accounting()+');
240: END IF;
241:
242:
243: /*-----------------------------------------------------------------------+

Line 304: arp_trx_validate.add_to_error_list(

300: ' class: ' || l_error_rec.account_class);
301: END IF;
302:
303:
304: arp_trx_validate.add_to_error_list(
305: l_error_mode,
306: p_error_count,
307: p_customer_trx_id,
308: p_trx_number,

Line 347: arp_trx_validate to log and raise messages based on the p_mode

343:
344: /* 5373072 - Added call to arp_etax_services_pkg.validate_for_tax
345: This routine determines if the tax is still active/valid at
346: the point of completion. It uses the error handling from
347: arp_trx_validate to log and raise messages based on the p_mode
348: parameter */
349:
350: arp_etax_services_pkg.validate_for_tax(
351: p_customer_trx_id => p_customer_trx_id,

Line 360: arp_util.debug('arp_trx_validate.check_tax_and_accounting()-');

356: p_error_count := p_error_count + l_error_count;
357:
358: IF PG_DEBUG in ('Y', 'C') THEN
359: arp_util.debug(' num of etax validation errors = ' || l_error_count);
360: arp_util.debug('arp_trx_validate.check_tax_and_accounting()-');
361: END IF;
362:
363: RETURN(TRUE);
364:

Line 369: 'EXCEPTION: arp_trx_validate.check_tax_and_accounting()');

365: EXCEPTION
366: WHEN OTHERS THEN
367: IF PG_DEBUG in ('Y', 'C') THEN
368: arp_util.debug('check_tax_and_accounting: ' ||
369: 'EXCEPTION: arp_trx_validate.check_tax_and_accounting()');
370: END IF;
371: RAISE;
372:
373: END check_tax_and_accounting;

Line 406: | arp_trx_validate.validate_trx_date |

402: | arp_non_db_pkg.check_creation_sign |
403: | arp_non_db_pkg.check_natural_application |
404: | arp_trx_global.profile_info.use_inv_acct_for_cm_flag |
405: | arp_trx_util.get_summary_trx_balances |
406: | arp_trx_validate.validate_trx_date |
407: | arp_util.debug |
408: | arp_util.validate_and_default_gl_date |
409: | |
410: | ARGUMENTS : IN: |

Line 452: arp_util.debug('arp_trx_validate.check_tax_and_accounting()+');

448:
449: BEGIN
450:
451: IF PG_DEBUG in ('Y', 'C') THEN
452: arp_util.debug('arp_trx_validate.check_tax_and_accounting()+');
453: END IF;
454:
455: -- Bug 540962: error count variable needs to be initialized
456:

Line 551: 'arp_trx_validate.check_tax_and_accounting()-');

547:
548: IF PG_DEBUG in ('Y', 'C') THEN
549: arp_util.debug('check_tax_and_accounting: ' || 'returning FALSE');
550: arp_util.debug('check_tax_and_accounting: ' ||
551: 'arp_trx_validate.check_tax_and_accounting()-');
552: END IF;
553:
554: RETURN(FALSE);
555: END IF;

Line 566: arp_util.debug('arp_trx_validate.check_tax_and_accounting()-');

562: dbms_sql.close_cursor(l_cursor);
563:
564: IF PG_DEBUG in ('Y', 'C') THEN
565: arp_util.debug('check_tax_and_accounting: ' || 'returning TRUE');
566: arp_util.debug('arp_trx_validate.check_tax_and_accounting()-');
567: END IF;
568:
569: RETURN(TRUE);
570:

Line 575: 'EXCEPTION: arp_trx_validate.check_tax_and_accounting()');

571: EXCEPTION
572: WHEN OTHERS THEN
573: IF PG_DEBUG in ('Y', 'C') THEN
574: arp_util.debug('check_tax_and_accounting: ' ||
575: 'EXCEPTION: arp_trx_validate.check_tax_and_accounting()');
576: arp_util.debug('======= parameters for check_tax_and_accounting: ' ||
577: '=======');
578: arp_util.debug('check_tax_and_accounting: ' || 'p_query_string = ' || p_query_string );
579: END IF;

Line 640: | arp_trx_validate.validate_trx_date |

636: | arp_non_db_pkg.check_creation_sign |
637: | arp_non_db_pkg.check_natural_application |
638: | arp_trx_global.profile_info.use_inv_acct_for_cm_flag |
639: | arp_trx_util.get_summary_trx_balances |
640: | arp_trx_validate.validate_trx_date |
641: | arp_util.debug |
642: | arp_util.validate_and_default_gl_date |
643: | |
644: | ARGUMENTS : IN: |

Line 856: arp_trx_validate.add_to_error_list(

852:
853: IF l_trx_rec.reversed_cash_receipt_id IS NOT NULL THEN
854: dm_reversal_amount_chk(l_trx_rec.customer_trx_id,l_trx_rec.reversed_cash_receipt_id,l_status);
855: IF l_status='E' THEN
856: arp_trx_validate.add_to_error_list(
857: p_error_mode,
858: l_error_count,
859: l_trx_rec.customer_trx_id,
860: l_trx_rec.trx_number,

Line 936: arp_trx_validate.validate_trx_number( l_trx_rec.batch_source_id,

932: arp_util.debug('Insure that the transaction number is unique.');
933: END IF;
934:
935: BEGIN
936: arp_trx_validate.validate_trx_number( l_trx_rec.batch_source_id,
937: l_trx_rec.trx_number,
938: l_trx_rec.customer_trx_id);
939:
940: EXCEPTION

Line 946: arp_trx_validate.add_to_error_list(

942: IF PG_DEBUG in ('Y', 'C') THEN
943: arp_util.debug('ERROR: transaction number uniqueness check failed');
944: END IF;
945:
946: arp_trx_validate.add_to_error_list(
947: p_error_mode,
948: l_error_count,
949: l_trx_rec.customer_trx_id,
950: l_trx_rec.trx_number,

Line 976: arp_trx_validate.validate_doc_number( l_trx_rec.batch_source_id,

972: it was using validate_trx_number (typo) before. Also exception
973: block was coded to raise another exception */
974:
975: BEGIN
976: arp_trx_validate.validate_doc_number( l_trx_rec.batch_source_id,
977: l_trx_rec.doc_sequence_value,
978: l_trx_rec.customer_trx_id);
979:
980: EXCEPTION

Line 986: arp_trx_validate.add_to_error_list(

982: IF PG_DEBUG in ('Y', 'C') THEN
983: arp_util.debug('ERROR: document number uniqueness check failed');
984: END IF;
985:
986: arp_trx_validate.add_to_error_list(
987: p_error_mode,
988: l_error_count,
989: l_trx_rec.customer_trx_id,
990: l_trx_rec.trx_number,

Line 1022: arp_trx_validate.add_to_error_list(

1018: IF PG_DEBUG in ('Y', 'C') THEN
1019: arp_util.debug('ERROR: line existance validation failed');
1020: END IF;
1021:
1022: arp_trx_validate.add_to_error_list(
1023: p_error_mode,
1024: l_error_count,
1025: l_trx_rec.customer_trx_id,
1026: l_trx_rec.trx_number,

Line 1073: arp_trx_validate.add_to_error_list(

1069: THEN
1070: IF PG_DEBUG in ('Y', 'C') THEN
1071: arp_util.debug('ERROR: Tax and payment term conflict exist');
1072: END IF;
1073: arp_trx_validate.add_to_error_list(
1074: p_error_mode,
1075: l_error_count,
1076: l_trx_rec.customer_trx_id,
1077: l_trx_rec.trx_number,

Line 1099: arp_trx_validate.validate_trx_date(

1095: IF PG_DEBUG in ('Y', 'C') THEN
1096: arp_util.debug('Check date ranges');
1097: END IF;
1098:
1099: arp_trx_validate.validate_trx_date(
1100: p_error_mode,
1101: l_trx_rec.trx_date,
1102: l_prev_trx_rec.trx_date,
1103: l_commit_trx_rec.trx_date,

Line 1171: arp_trx_validate.add_to_error_list(

1167: IF PG_DEBUG in ('Y', 'C') THEN
1168: arp_util.debug( 'ERROR: exchange rate is null');
1169: END IF;
1170:
1171: arp_trx_validate.add_to_error_list(
1172: p_error_mode,
1173: l_error_count,
1174: l_trx_rec.customer_trx_id,
1175: l_trx_rec.trx_number,

Line 1195: arp_trx_validate.add_to_error_list(

1191: IF PG_DEBUG in ('Y', 'C') THEN
1192: arp_util.debug( 'ERROR: exchange rate type is null');
1193: END IF;
1194:
1195: arp_trx_validate.add_to_error_list(
1196: p_error_mode,
1197: l_error_count,
1198: l_trx_rec.customer_trx_id,
1199: l_trx_rec.trx_number,

Line 1219: arp_trx_validate.add_to_error_list(

1215: IF PG_DEBUG in ('Y', 'C') THEN
1216: arp_util.debug( 'ERROR: exchange rate date is null');
1217: END IF;
1218:
1219: arp_trx_validate.add_to_error_list(
1220: p_error_mode,
1221: l_error_count,
1222: l_trx_rec.customer_trx_id,
1223: l_trx_rec.trx_number,

Line 1271: arp_trx_validate.add_to_error_list(

1267: arp_util.debug(
1268: 'ERROR: commitment dates do not include the trx_date');
1269: END IF;
1270:
1271: arp_trx_validate.add_to_error_list(
1272: p_error_mode,
1273: l_error_count,
1274: l_trx_rec.customer_trx_id,
1275: l_trx_rec.trx_number,

Line 1306: arp_trx_validate.add_to_error_list(

1302: arp_util.debug( 'ERROR: The transaction''s GL date is before '||
1303: 'the commitment''s GL date');
1304: END IF;
1305:
1306: arp_trx_validate.add_to_error_list(
1307: p_error_mode,
1308: l_error_count,
1309: l_trx_rec.customer_trx_id,
1310: l_trx_rec.trx_number,

Line 1349: arp_trx_validate.add_to_error_list(

1345: ' are invalid');
1346: END IF;
1347:
1348: /* Bug 2215439 - call to public sector API for industry specific message */
1349: arp_trx_validate.add_to_error_list(
1350: p_error_mode,
1351: l_error_count,
1352: l_trx_rec.customer_trx_id,
1353: l_trx_rec.trx_number,

Line 1430: arp_trx_validate.add_to_error_list(

1426: ' for line ' ||
1427: TO_CHAR(l_error_rec.line_number));
1428: END IF;
1429:
1430: arp_trx_validate.add_to_error_list(
1431: p_error_mode,
1432: l_error_count,
1433: l_trx_rec.customer_trx_id,
1434: l_trx_rec.trx_number,

Line 1477: arp_trx_validate.add_to_error_list(

1473: IF PG_DEBUG in ('Y', 'C') THEN
1474: arp_util.debug( 'ERROR: the transaction violate the creation sign');
1475: END IF;
1476:
1477: arp_trx_validate.add_to_error_list(
1478: p_error_mode,
1479: l_error_count,
1480: l_trx_rec.customer_trx_id,
1481: l_trx_rec.trx_number,

Line 1532: arp_trx_validate.add_to_error_list(

1528: IF PG_DEBUG in ('Y', 'C') THEN
1529: arp_util.debug( 'ERROR: the GL date is invalid');
1530: END IF;
1531:
1532: arp_trx_validate.add_to_error_list(
1533: p_error_mode,
1534: l_error_count,
1535: l_trx_rec.customer_trx_id,
1536: l_trx_rec.trx_number,

Line 1704: arp_trx_validate.add_to_error_list(

1700: IF PG_DEBUG in ('Y', 'C') THEN
1701: arp_util.debug( 'ERROR: overapplication of the total amount');
1702: END IF;
1703:
1704: arp_trx_validate.add_to_error_list(
1705: p_error_mode,
1706: l_error_count,
1707: l_trx_rec.customer_trx_id,
1708: l_trx_rec.trx_number,

Line 1753: arp_trx_validate.add_to_error_list(

1749: IF PG_DEBUG in ('Y', 'C') THEN
1750: arp_util.debug( 'ERROR: overapplication of the line amount');
1751: END IF;
1752:
1753: arp_trx_validate.add_to_error_list(
1754: p_error_mode,
1755: l_error_count,
1756: l_trx_rec.customer_trx_id,
1757: l_trx_rec.trx_number,

Line 1800: arp_trx_validate.add_to_error_list(

1796: IF PG_DEBUG in ('Y', 'C') THEN
1797: arp_util.debug( 'ERROR: overapplication of the tax amount');
1798: END IF;
1799:
1800: arp_trx_validate.add_to_error_list(
1801: p_error_mode,
1802: l_error_count,
1803: l_trx_rec.customer_trx_id,
1804: l_trx_rec.trx_number,

Line 1847: arp_trx_validate.add_to_error_list(

1843: IF PG_DEBUG in ('Y', 'C') THEN
1844: arp_util.debug( 'ERROR: overapplication of the freight amount');
1845: END IF;
1846:
1847: arp_trx_validate.add_to_error_list(
1848: p_error_mode,
1849: l_error_count,
1850: l_trx_rec.customer_trx_id,
1851: l_trx_rec.trx_number,

Line 1933: arp_trx_validate.add_to_error_list(

1929: arp_util.debug(
1930: 'ERROR: overapplication of the commitment balance');
1931: END IF;
1932:
1933: arp_trx_validate.add_to_error_list(
1934: p_error_mode,
1935: l_error_count,
1936: l_trx_rec.customer_trx_id,
1937: l_trx_rec.trx_number,

Line 1968: arp_trx_validate.add_to_error_list(

1964: arp_util.debug(
1965: 'ERROR: GL date is before the credited transaction''s');
1966: END IF;
1967:
1968: arp_trx_validate.add_to_error_list(
1969: p_error_mode,
1970: l_error_count,
1971: l_trx_rec.customer_trx_id,
1972: l_trx_rec.trx_number,

Line 2020: arp_trx_validate.add_to_error_list(

2016: IF PG_DEBUG in ('Y', 'C') THEN
2017: arp_util.debug( 'ERROR: later credit memos exist');
2018: END IF;
2019:
2020: arp_trx_validate.add_to_error_list(
2021: p_error_mode,
2022: l_error_count,
2023: l_trx_rec.customer_trx_id,
2024: l_trx_rec.trx_number,

Line 2121: arp_trx_validate.add_to_error_list(

2117: IF PG_DEBUG in ('Y', 'C') THEN
2118: arp_util.debug(
2119: 'Error: Atleast one of the GL Accounts is either invalid or end dated');
2120: END IF;
2121: arp_trx_validate.add_to_error_list(
2122: p_error_mode,
2123: l_error_count,
2124: l_trx_rec.customer_trx_id,
2125: l_trx_rec.trx_number,