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 1305: arp_trx_validate.add_to_error_list(

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

Line 1347: arp_trx_validate.add_to_error_list(

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

Line 1428: arp_trx_validate.add_to_error_list(

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

Line 1475: arp_trx_validate.add_to_error_list(

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

Line 1530: arp_trx_validate.add_to_error_list(

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

Line 1702: arp_trx_validate.add_to_error_list(

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

Line 1751: arp_trx_validate.add_to_error_list(

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

Line 1798: arp_trx_validate.add_to_error_list(

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

Line 1845: arp_trx_validate.add_to_error_list(

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

Line 1931: arp_trx_validate.add_to_error_list(

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

Line 1966: arp_trx_validate.add_to_error_list(

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

Line 2017: arp_trx_validate.add_to_error_list(

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

Line 2118: arp_trx_validate.add_to_error_list(

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