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_GROUP_INV dependencies on STANDARD

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 136: arp_standard.profile.request_id, -- Request Id

132: (new_cons_inv_id, -- Cons Inv Id
133: new_cons_billing_number, -- Cons Billing Number
134: c_group_inv_rec.customer_id, -- Customer Id
135: c_group_inv_rec.site_use_id, -- Site Use Id
136: arp_standard.profile.request_id, -- Request Id
137: arp_global.last_update_date, -- Last Update Date
138: arp_global.last_updated_by, -- Last Updated By
139: arp_global.creation_date, -- Creation Date
140: arp_global.created_by, -- Created By

Line 148: arp_standard.sysparm.org_id);

144: 'PRINTED', -- Print Status
145: TRUNC(sysdate), -- Issue Date
146: NULL, -- Cutoff Date
147: NULL, -- Due Date
148: arp_standard.sysparm.org_id);
149:
150: arp_standard.debug('Inserted cons :' || SQL%ROWCOUNT);
151:
152: END IF;

Line 150: arp_standard.debug('Inserted cons :' || SQL%ROWCOUNT);

146: NULL, -- Cutoff Date
147: NULL, -- Due Date
148: arp_standard.sysparm.org_id);
149:
150: arp_standard.debug('Inserted cons :' || SQL%ROWCOUNT);
151:
152: END IF;
153:
154: END IF; /** New group ***/

Line 181: arp_standard.debug('Inserted ['|| l_group_inv_line_number||'] :' ||

177: c_group_inv_rec.org_id);
178:
179: l_group_inv_line_number := l_group_inv_line_number + 1;
180:
181: arp_standard.debug('Inserted ['|| l_group_inv_line_number||'] :' ||
182: SQL%ROWCOUNT);
183:
184: END LOOP;
185:

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 228: l_message_text := arp_standard.fnd_message('AR_RAXTRX-1810');

224: *** All the transactions grouped under one Group must belong to **
225: *** the same bill-to customer **
226: ******************************************************************/
227:
228: l_message_text := arp_standard.fnd_message('AR_RAXTRX-1810');
229:
230: INSERT INTO ra_interface_errors
231: (interface_line_id,
232: message_text,

Line 250: arp_standard.debug('Inserted [1]:' || SQL%ROWCOUNT);

246: WHERE l2.request_id = l.request_id
247: AND l2.cons_billing_number = l.cons_billing_number
248: AND l2.orig_system_bill_customer_id <> l.orig_system_bill_customer_id);
249:
250: arp_standard.debug('Inserted [1]:' || SQL%ROWCOUNT);
251:
252: /******************************************************************
253: *** Imported Billing Number must be unique for given type MINV **
254: ******************************************************************/

Line 256: l_message_text := arp_standard.fnd_message('AR_RAXTRX-1811');

252: /******************************************************************
253: *** Imported Billing Number must be unique for given type MINV **
254: ******************************************************************/
255:
256: l_message_text := arp_standard.fnd_message('AR_RAXTRX-1811');
257:
258: INSERT INTO RA_INTERFACE_ERRORS
259: (interface_line_id,
260: message_text,

Line 281: arp_standard.debug('Inserted [2]:' || SQL%ROWCOUNT);

277: WHERE l2.request_id > 0
278: AND l2.request_id <> l.request_iD
279: AND l2.cons_billing_number = l.cons_billing_number));
280:
281: arp_standard.debug('Inserted [2]:' || SQL%ROWCOUNT);
282:
283: /******************************************************************
284: *** All the transactions grouped under one Group must belong to **
285: *** the same bill-to address **

Line 288: l_message_text := arp_standard.fnd_message('AR_RAXTRX-1812');

284: *** All the transactions grouped under one Group must belong to **
285: *** the same bill-to address **
286: ******************************************************************/
287:
288: l_message_text := arp_standard.fnd_message('AR_RAXTRX-1812');
289:
290: INSERT INTO RA_INTERFACE_ERRORS
291: (interface_line_id,
292: message_text,

Line 310: arp_standard.debug('Inserted [3]:' || SQL%ROWCOUNT);

306: WHERE l2.request_id = l.request_id
307: AND l2.cons_billing_number = l.cons_billing_number
308: AND l2.orig_system_bill_address_id <> l.orig_system_bill_address_id);
309:
310: arp_standard.debug('Inserted [3]:' || SQL%ROWCOUNT);
311:
312: /******************************************************************
313: *** Customer must be enabled to Import billing Number **
314: ******************************************************************/

Line 317: l_message_text := arp_standard.fnd_message('AR_RAXTRX-1814');

313: *** Customer must be enabled to Import billing Number **
314: ******************************************************************/
315: -- Bug 2501153: To avoid the merge join cartesian, added a table hz_cust_acct_sites
316:
317: l_message_text := arp_standard.fnd_message('AR_RAXTRX-1814');
318:
319: INSERT INTO RA_INTERFACE_ERRORS
320: (interface_line_id,
321: message_text,

Line 350: arp_standard.debug('Inserted [4]:' || SQL%ROWCOUNT);

346: AND ac.cust_account_id = cp.cust_account_id
347: AND su.site_use_id = sp.site_use_id (+)
348: AND NVL(NVL(sp.cons_inv_flag, cp.cons_inv_flag), 'N') = 'N'
349: );
350: arp_standard.debug('Inserted [4]:' || SQL%ROWCOUNT);
351:
352: /******************************************************************
353: *** You cannot import Billing Number for the customer using ***
354: *** Consolidated Billing functionality ***

Line 358: l_message_text := arp_standard.fnd_message('AR_RAXTRX-1813');

354: *** Consolidated Billing functionality ***
355: ******************************************************************/
356: -- Bug 2501153: To avoid the merge join cartesian, added a table hz_cust_acct_sites
357:
358: l_message_text := arp_standard.fnd_message('AR_RAXTRX-1813');
359:
360: INSERT INTO RA_INTERFACE_ERRORS
361: (interface_line_id,
362: message_text,

Line 392: arp_standard.debug('Inserted [5]:' || SQL%ROWCOUNT);

388: AND su.site_use_id = sp.site_use_id (+)
389: AND NVL(sp.cons_inv_flag, cp.cons_inv_flag) = 'Y'
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

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 399: arp_standard.debug( ' Exception: validate_data: ');

395:
396: EXCEPTION
397: WHEN OTHERS THEN
398: IF PG_DEBUG in ('Y', 'C') THEN
399: arp_standard.debug( ' Exception: validate_data: ');
400: END IF;
401: RAISE;
402: END validate_data;
403: --

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 496: arp_standard.debug('Updated :' || l_tot_rec_updated);

492: --
493: END LOOP;
494:
495: --
496: arp_standard.debug('Updated :' || l_tot_rec_updated);
497: --
498: arp_standard.debug('arp_group_inv.update_ps()-');
499: --
500: EXCEPTION

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 539: l_message_text := arp_standard.fnd_message('AR_RAXTRX-1819');

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
542: (interface_line_id,
543: message_text,

Line 565: arp_standard.debug('validate_group: No of Invoices Rejected- '||

561: AND l2.request_id = l.request_id );
562:
563: o_rows_rejected := SQL%ROWCOUNT;
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:

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 573: arp_standard.debug( ' Exception: validate_group: '||SQLERRM);

569:
570: EXCEPTION
571: WHEN OTHERS THEN
572: IF PG_DEBUG in ('Y', 'C') THEN
573: arp_standard.debug( ' Exception: validate_group: '||SQLERRM);
574: END IF;
575: RAISE;
576: END validate_group;
577: