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_VALIDATE dependencies on ARP_TRX_VALIDATE

Line 1: PACKAGE BODY ARP_TRX_VALIDATE AS

1: PACKAGE BODY ARP_TRX_VALIDATE AS
2: /* $Header: ARTUVALB.pls 120.27.12010000.2 2009/08/27 13:09:52 rasarasw ship $ */
3:
4: pg_ai_pds_exist_cursor integer;
5: pg_ai_overlapping_pds_cursor integer;

Line 87: arp_util.debug('arp_trx_validate.add_to_error_list()+');

83:
84: BEGIN
85:
86: IF PG_DEBUG in ('Y', 'C') THEN
87: arp_util.debug('arp_trx_validate.add_to_error_list()+');
88: END IF;
89:
90: p_error_count := nvl(p_error_count,0) + 1;
91:

Line 197: arp_util.debug('arp_trx_validate.add_to_error_list()-');

193: END IF;
194:
195:
196: IF PG_DEBUG in ('Y', 'C') THEN
197: arp_util.debug('arp_trx_validate.add_to_error_list()-');
198: END IF;
199:
200: EXCEPTION
201: WHEN OTHERS THEN

Line 204: 'EXCEPTION: arp_trx_validate.add_to_error_list()');

200: EXCEPTION
201: WHEN OTHERS THEN
202: IF PG_DEBUG in ('Y', 'C') THEN
203: arp_util.debug('add_to_error_list: ' ||
204: 'EXCEPTION: arp_trx_validate.add_to_error_list()');
205: END IF;
206: RAISE;
207:
208: END add_to_error_list;

Line 244: arp_util.debug('ARP_TRX_VALIDATE.ar_entity_version_check()+');

240:
241:
242: BEGIN
243:
244: arp_util.debug('ARP_TRX_VALIDATE.ar_entity_version_check()+');
245:
246: arp_util.debug('ARP_TRX_VALIDATE.ar_entity_version_check()-');
247:
248: EXCEPTION

Line 246: arp_util.debug('ARP_TRX_VALIDATE.ar_entity_version_check()-');

242: BEGIN
243:
244: arp_util.debug('ARP_TRX_VALIDATE.ar_entity_version_check()+');
245:
246: arp_util.debug('ARP_TRX_VALIDATE.ar_entity_version_check()-');
247:
248: EXCEPTION
249: WHEN OTHERS THEN
250: arp_util.debug('EXCEPTION: ARP_TRX_VALIDATE.insert_batch()');

Line 250: arp_util.debug('EXCEPTION: ARP_TRX_VALIDATE.insert_batch()');

246: arp_util.debug('ARP_TRX_VALIDATE.ar_entity_version_check()-');
247:
248: EXCEPTION
249: WHEN OTHERS THEN
250: arp_util.debug('EXCEPTION: ARP_TRX_VALIDATE.insert_batch()');
251: RAISE;
252:
253: END;
254:

Line 326: arp_util.debug('arp_trx_validate.validate_trx_number()+');

322: ra_batch_sources_all.allow_duplicate_trx_num_flag%TYPE;
323:
324: BEGIN
325:
326: arp_util.debug('arp_trx_validate.validate_trx_number()+');
327:
328: /* Bug 2681166 Re-introduced the code commented out for bug 2493165 */
329:
330: /* Bug 2493165 Removed the following Document Sequencing changes

Line 366: arp_util.debug('ARP_TRX_VALIDATE.validate_trx_number()-');

362:
363: END IF;
364:
365: END IF;
366: arp_util.debug('ARP_TRX_VALIDATE.validate_trx_number()-');
367:
368: EXCEPTION
369: WHEN OTHERS THEN
370: arp_util.debug('EXCEPTION: arp_trx_validate.validate_trx_number()');

Line 370: arp_util.debug('EXCEPTION: arp_trx_validate.validate_trx_number()');

366: arp_util.debug('ARP_TRX_VALIDATE.validate_trx_number()-');
367:
368: EXCEPTION
369: WHEN OTHERS THEN
370: arp_util.debug('EXCEPTION: arp_trx_validate.validate_trx_number()');
371: RAISE;
372:
373: END validate_trx_number;
374:

Line 412: arp_util.debug('ARP_TRX_VALIDATE.validate_doc_number()+');

408: l_temp varchar2(1);
409:
410: BEGIN
411:
412: arp_util.debug('ARP_TRX_VALIDATE.validate_doc_number()+');
413:
414: BEGIN
415:
416: IF (

Line 452: arp_util.debug('ARP_TRX_VALIDATE.validate_doc_number()-');

448: THEN NULL;
449: WHEN OTHERS THEN RAISE;
450: END;
451:
452: arp_util.debug('ARP_TRX_VALIDATE.validate_doc_number()-');
453:
454: EXCEPTION
455: WHEN OTHERS THEN
456: arp_util.debug('EXCEPTION: ARP_TRX_VALIDATE.validate_doc_number()');

Line 456: arp_util.debug('EXCEPTION: ARP_TRX_VALIDATE.validate_doc_number()');

452: arp_util.debug('ARP_TRX_VALIDATE.validate_doc_number()-');
453:
454: EXCEPTION
455: WHEN OTHERS THEN
456: arp_util.debug('EXCEPTION: ARP_TRX_VALIDATE.validate_doc_number()');
457: RAISE;
458:
459: END;
460:

Line 501: arp_util.debug('arp_trx_validate.check_dup_line_number()+');

497: l_count number;
498:
499: BEGIN
500:
501: arp_util.debug('arp_trx_validate.check_dup_line_number()+');
502:
503: SELECT count(*)
504: INTO l_count
505: FROM ra_customer_trx_lines

Line 517: arp_util.debug('arp_trx_validate.check_dup_line_number()-');

513: fnd_message.set_name('AR', 'AR_TW_DUP_LINE_NUM');
514: app_exception.raise_exception;
515: END IF;
516:
517: arp_util.debug('arp_trx_validate.check_dup_line_number()-');
518:
519: EXCEPTION
520: WHEN OTHERS THEN
521: arp_util.debug('EXCEPTION: arp_trx_validate.check_dup_line_number()');

Line 521: arp_util.debug('EXCEPTION: arp_trx_validate.check_dup_line_number()');

517: arp_util.debug('arp_trx_validate.check_dup_line_number()-');
518:
519: EXCEPTION
520: WHEN OTHERS THEN
521: arp_util.debug('EXCEPTION: arp_trx_validate.check_dup_line_number()');
522:
523: arp_util.debug('');
524: arp_util.debug('----- parameters for check_dup_line_number() -------');
525:

Line 570: arp_util.debug('arp_trx_validate.check_has_one_line()+');

566: l_count number;
567:
568: BEGIN
569:
570: arp_util.debug('arp_trx_validate.check_has_one_line()+');
571:
572: SELECT count(*)
573: INTO l_count
574: FROM ra_customer_trx_lines

Line 588: arp_util.debug('arp_trx_validate.check_has_one_line()-');

584:
585: app_exception.raise_exception;
586: END IF;
587:
588: arp_util.debug('arp_trx_validate.check_has_one_line()-');
589:
590: EXCEPTION
591: WHEN OTHERS THEN
592: arp_util.debug('EXCEPTION: arp_trx_validate.check_has_one_line()');

Line 592: arp_util.debug('EXCEPTION: arp_trx_validate.check_has_one_line()');

588: arp_util.debug('arp_trx_validate.check_has_one_line()-');
589:
590: EXCEPTION
591: WHEN OTHERS THEN
592: arp_util.debug('EXCEPTION: arp_trx_validate.check_has_one_line()');
593:
594: arp_util.debug('');
595: arp_util.debug('----- parameters for check_has_one_line() -------');
596:

Line 651: arp_util.debug('arp_trx_validate.check_sign_and_overapp()+');

647:
648: BEGIN
649:
650: IF PG_DEBUG in ('Y', 'C') THEN
651: arp_util.debug('arp_trx_validate.check_sign_and_overapp()+');
652: END IF;
653:
654: check_sign_and_overapp(
655: p_customer_trx_id => p_customer_trx_id,

Line 667: arp_util.debug('arp_trx_validate.check_sign_and_overapp()-');

663: p_error_count => l_error_count
664: );
665:
666: IF PG_DEBUG in ('Y', 'C') THEN
667: arp_util.debug('arp_trx_validate.check_sign_and_overapp()-');
668: END IF;
669:
670:
671: END check_sign_and_overapp;

Line 764: arp_util.debug('Overloaded:arp_trx_validate.check_sign_and_overapp()+');

760:
761: BEGIN
762:
763: IF PG_DEBUG in ('Y', 'C') THEN
764: arp_util.debug('Overloaded:arp_trx_validate.check_sign_and_overapp()+');
765: END IF;
766:
767:
768: /*-------------------------------------------------------------------+

Line 825: arp_trx_validate.add_to_error_list(

821:
822: /*Bug3041195*/
823: IF ( l_error_message IS NOT NULL )
824: THEN
825: arp_trx_validate.add_to_error_list(
826: p_error_mode,
827: l_error_count,
828: p_previous_customer_trx_id,
829: NULL, -- trx_number,

Line 911: arp_trx_validate.add_to_error_list(

907:
908: /*Bug3041195*/
909: IF ( l_error_message IS NOT NULL )
910: THEN
911: arp_trx_validate.add_to_error_list(
912: p_error_mode,
913: l_error_count,
914: p_previous_customer_trx_id,
915: NULL, -- trx_number,

Line 954: arp_trx_validate.add_to_error_list(

950:
951: /*Bug3041195*/
952: IF ( l_error_message IS NOT NULL )
953: THEN
954: arp_trx_validate.add_to_error_list(
955: p_error_mode,
956: l_error_count,
957: p_previous_customer_trx_id,
958: NULL, -- trx_number,

Line 996: arp_trx_validate.add_to_error_list(

992:
993: /*Bug3041195*/
994: IF ( l_error_message IS NOT NULL )
995: THEN
996: arp_trx_validate.add_to_error_list(
997: p_error_mode,
998: l_error_count,
999: p_previous_customer_trx_id,
1000: NULL, -- trx_number,

Line 1019: arp_util.debug('Overloaded:arp_trx_validate.check_sign_and_overapp()+');

1015: END IF;
1016:
1017: p_error_count := l_error_count;
1018: IF PG_DEBUG in ('Y', 'C') THEN
1019: arp_util.debug('Overloaded:arp_trx_validate.check_sign_and_overapp()+');
1020: END IF;
1021:
1022:
1023: EXCEPTION

Line 1025: arp_util.debug('EXCEPTION: arp_trx_validate.check_sign_and_overapp()');

1021:
1022:
1023: EXCEPTION
1024: WHEN OTHERS THEN
1025: arp_util.debug('EXCEPTION: arp_trx_validate.check_sign_and_overapp()');
1026: p_error_count := l_error_count;
1027: arp_util.debug('');
1028: arp_util.debug('----- parameters for check_sign_and_overapp() ------');
1029:

Line 1096: arp_util.debug('ARP_TRX_VALIDATE.validate_paying_customer()+');

1092: l_paying_customer_is_valid varchar2(1);
1093:
1094: BEGIN
1095:
1096: arp_util.debug('ARP_TRX_VALIDATE.validate_paying_customer()+');
1097:
1098: BEGIN
1099:
1100: --ajay bug 1081390

Line 1179: arp_util.debug('ARP_TRX_VALIDATE.validate_paying_customer()-');

1175: EXCEPTION
1176: WHEN OTHERS THEN RAISE;
1177: END;
1178:
1179: arp_util.debug('ARP_TRX_VALIDATE.validate_paying_customer()-');
1180:
1181: EXCEPTION
1182: WHEN OTHERS THEN
1183: arp_util.debug('EXCEPTION: ARP_TRX_VALIDATE.validate_paying_customer()');

Line 1183: arp_util.debug('EXCEPTION: ARP_TRX_VALIDATE.validate_paying_customer()');

1179: arp_util.debug('ARP_TRX_VALIDATE.validate_paying_customer()-');
1180:
1181: EXCEPTION
1182: WHEN OTHERS THEN
1183: arp_util.debug('EXCEPTION: ARP_TRX_VALIDATE.validate_paying_customer()');
1184: RAISE;
1185:
1186: END;
1187:

Line 1336: arp_util.debug('ARP_TRX_VALIDATE.validate_trx_date()+');

1332: l_paying_customer_id ra_customer_trx.paying_customer_id%TYPE;
1333:
1334: BEGIN
1335:
1336: arp_util.debug('ARP_TRX_VALIDATE.validate_trx_date()+');
1337:
1338: p_result_flag := TRUE;
1339:
1340: /*------------------------------------------------------------------+

Line 2222: arp_util.debug('ARP_TRX_VALIDATE.validate_trx_date()-');

2218:
2219: p_due_date := arpt_sql_func_util.Get_First_Due_Date( p_term_id,
2220: p_trx_date );
2221:
2222: arp_util.debug('ARP_TRX_VALIDATE.validate_trx_date()-');
2223:
2224:
2225: EXCEPTION
2226: WHEN OTHERS THEN

Line 2227: arp_util.debug('EXCEPTION: ARP_TRX_VALIDATE.validate_trx_date()');

2223:
2224:
2225: EXCEPTION
2226: WHEN OTHERS THEN
2227: arp_util.debug('EXCEPTION: ARP_TRX_VALIDATE.validate_trx_date()');
2228: RAISE;
2229:
2230: END;
2231:

Line 2417: arp_util.debug('ARP_TRX_VALIDATE.val_gl_dist_amounts()+');

2413:
2414: BEGIN
2415:
2416: IF PG_DEBUG in ('Y', 'C') THEN
2417: arp_util.debug('ARP_TRX_VALIDATE.val_gl_dist_amounts()+');
2418: END IF;
2419:
2420: OPEN val_gl_dist_amounts;
2421:

Line 2456: arp_util.debug('ARP_TRX_VALIDATE.val_gl_dist_amounts()-');

2452:
2453: END IF;
2454:
2455: IF PG_DEBUG in ('Y', 'C') THEN
2456: arp_util.debug('ARP_TRX_VALIDATE.val_gl_dist_amounts()-');
2457: END IF;
2458:
2459: EXCEPTION
2460: WHEN OTHERS

Line 2463: arp_util.debug('EXCEPTION: ARP_TRX_VALIDATE.val_gl_dist_amounts()');

2459: EXCEPTION
2460: WHEN OTHERS
2461: THEN
2462: IF PG_DEBUG in ('Y', 'C') THEN
2463: arp_util.debug('EXCEPTION: ARP_TRX_VALIDATE.val_gl_dist_amounts()');
2464: arp_util.debug('val_gl_dist_amounts: ' || ' p_customer_trx_line_id = ' ||
2465: p_customer_trx_line_id );
2466: arp_util.debug('val_gl_dist_amounts: ' || ' l_gl_date = ' || l_gl_date );
2467: arp_util.debug('val_gl_dist_amounts: ' || ' l_amount = ' || l_amount );

Line 2549: arp_util.debug('arp_trx_validate.val_and_dflt_pay_mthd_and_bank()+');

2545:
2546: BEGIN
2547:
2548: IF PG_DEBUG in ('Y', 'C') THEN
2549: arp_util.debug('arp_trx_validate.val_and_dflt_pay_mthd_and_bank()+');
2550: END IF;
2551:
2552: IF ( arp_process_credit_util.check_payment_method
2553: (

Line 2620: arp_util.debug('arp_trx_validater.val_and_dflt_pay_mthd_and_bank()-');

2616: END IF;
2617: END IF;
2618:
2619: IF PG_DEBUG in ('Y', 'C') THEN
2620: arp_util.debug('arp_trx_validater.val_and_dflt_pay_mthd_and_bank()-');
2621: END IF;
2622:
2623: EXCEPTION
2624: WHEN NO_DATA_FOUND THEN NULL;

Line 2706: | arp_trx_validate.validate_trx_date |

2702: | arp_non_db_pkg.check_creation_sign |
2703: | arp_non_db_pkg.check_natural_application |
2704: | arp_trx_global.profile_info.use_inv_acct_for_cm_flag |
2705: | arp_trx_util.get_summary_trx_balances |
2706: | arp_trx_validate.validate_trx_date |
2707: | arp_util.debug |
2708: | arp_util.validate_and_default_gl_date |
2709: | |
2710: | ARGUMENTS : IN: |

Line 2757: END ARP_TRX_VALIDATE;

2753: END init;
2754:
2755: BEGIN
2756: init;
2757: END ARP_TRX_VALIDATE;