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.1 2008/07/24 16:58:23 appldev 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 1176: arp_util.debug('ARP_TRX_VALIDATE.validate_paying_customer()-');

1172: EXCEPTION
1173: WHEN OTHERS THEN RAISE;
1174: END;
1175:
1176: arp_util.debug('ARP_TRX_VALIDATE.validate_paying_customer()-');
1177:
1178: EXCEPTION
1179: WHEN OTHERS THEN
1180: arp_util.debug('EXCEPTION: ARP_TRX_VALIDATE.validate_paying_customer()');

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

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

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

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

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

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

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

2220:
2221:
2222: EXCEPTION
2223: WHEN OTHERS THEN
2224: arp_util.debug('EXCEPTION: ARP_TRX_VALIDATE.validate_trx_date()');
2225: RAISE;
2226:
2227: END;
2228:

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

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

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

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

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

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

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

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

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

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

Line 2703: | arp_trx_validate.validate_trx_date |

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

Line 2754: END ARP_TRX_VALIDATE;

2750: END init;
2751:
2752: BEGIN
2753: init;
2754: END ARP_TRX_VALIDATE;