APPS.ARP_GROUP_INV dependencies on ARP_GROUP_INV

Line 1: PACKAGE BODY arp_group_inv AS

1: PACKAGE BODY arp_group_inv AS
2: /*$Header: ARPMINVB.pls 120.10 2008/04/30 13:44:31 mgaleti ship $*/
3: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
4:
5: /** Store the Cons billing Number in a PL/SQL table of cons_inv_id **/

Line 86: arp_standard.debug('arp_group_inv.generate()+');

82: l_group_inv_line_number AR_CONS_INV_TRX.cons_inv_line_number%TYPE:=1;
83:
84: BEGIN
85:
86: arp_standard.debug('arp_group_inv.generate()+');
87:
88: update_ps(p_request_id=>p_request_id);
89:
90: FOR c_group_inv_rec IN c_group_inv (p_request_id) LOOP

Line 186: arp_standard.debug('arp_group_inv.generate()-');

182: SQL%ROWCOUNT);
183:
184: END LOOP;
185:
186: arp_standard.debug('arp_group_inv.generate()-');
187:
188: EXCEPTION
189: WHEN OTHERS THEN
190: arp_standard.debug( 'EXCEPTION: arp_group_inv.generate()' );

Line 190: arp_standard.debug( 'EXCEPTION: arp_group_inv.generate()' );

186: arp_standard.debug('arp_group_inv.generate()-');
187:
188: EXCEPTION
189: WHEN OTHERS THEN
190: arp_standard.debug( 'EXCEPTION: arp_group_inv.generate()' );
191: RAISE;
192: END;
193: --
194: /*----------------------------------------------------------------------------*

Line 221: arp_standard.debug('arp_group_inv.validate_data()+');

217: PROCEDURE validate_data (P_request_id IN NUMBER) IS
218: l_message_text VARCHAR2(2000);
219: BEGIN
220:
221: arp_standard.debug('arp_group_inv.validate_data()+');
222:
223: /******************************************************************
224: *** All the transactions grouped under one Group must belong to **
225: *** the same bill-to customer **

Line 394: arp_standard.debug('arp_group_inv.validate_data()-');

390: AND NVL(sp.cons_inv_type, cp.cons_inv_type) <> 'IMPORTED'
391: );
392: arp_standard.debug('Inserted [5]:' || SQL%ROWCOUNT);
393:
394: arp_standard.debug('arp_group_inv.validate_data()-');
395:
396: EXCEPTION
397: WHEN OTHERS THEN
398: IF PG_DEBUG in ('Y', 'C') THEN

Line 455: arp_standard.debug('arp_group_inv.update_ps()+');

451: l_tot_rec_updated NUMBER:=0;
452:
453: BEGIN
454: --
455: arp_standard.debug('arp_group_inv.update_ps()+');
456: --
457: FOR c01_rec IN c01 LOOP
458: --
459: IF old_cons_billing_number <> c01_rec.cons_billing_number THEN

Line 498: arp_standard.debug('arp_group_inv.update_ps()-');

494:
495: --
496: arp_standard.debug('Updated :' || l_tot_rec_updated);
497: --
498: arp_standard.debug('arp_group_inv.update_ps()-');
499: --
500: EXCEPTION
501: WHEN OTHERS THEN
502: IF PG_DEBUG in ('Y', 'C') THEN

Line 503: arp_standard.debug( ' Exception: arp_group_inv.update_ps()');

499: --
500: EXCEPTION
501: WHEN OTHERS THEN
502: IF PG_DEBUG in ('Y', 'C') THEN
503: arp_standard.debug( ' Exception: arp_group_inv.update_ps()');
504: END IF;
505: RAISE;
506: END update_ps;
507:

Line 537: arp_standard.debug('arp_group_inv.validate_group()+');

533: *----------------------------------------------------------------------------*/
534: PROCEDURE validate_group(p_request_id IN NUMBER,o_rows_rejected OUT NOCOPY NUMBER) IS
535: l_message_text VARCHAR2(2000);
536: BEGIN
537: arp_standard.debug('arp_group_inv.validate_group()+');
538:
539: l_message_text := arp_standard.fnd_message('AR_RAXTRX-1819');
540:
541: INSERT INTO RA_INTERFACE_ERRORS

Line 568: arp_standard.debug('arp_group_inv.validate_group()-');

564:
565: arp_standard.debug('validate_group: No of Invoices Rejected- '||
566: o_rows_rejected);
567:
568: arp_standard.debug('arp_group_inv.validate_group()-');
569:
570: EXCEPTION
571: WHEN OTHERS THEN
572: IF PG_DEBUG in ('Y', 'C') THEN

Line 578: END arp_group_inv;

574: END IF;
575: RAISE;
576: END validate_group;
577:
578: END arp_group_inv;