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

Line 140: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.get_collector_name()+' );

136: l_collector_name ar_collectors.name%TYPE;
137: l_collector_id NUMBER;
138: BEGIN
139: IF PG_DEBUG in ('Y', 'C') THEN
140: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.get_collector_name()+' );
141: END IF;
142: SELECT prof.collector_id INTO l_collector_id
143: FROM hz_customer_profiles prof
144: WHERE prof.cust_account_id = p_customer_id AND

Line 153: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.get_collector_name()-' );

149: FROM ar_collectors
150: WHERE collector_id = l_collector_id;
151:
152: IF PG_DEBUG in ('Y', 'C') THEN
153: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.get_collector_name()-' );
154: END IF;
155: RETURN l_collector_name;
156: EXCEPTION
157: WHEN NO_DATA_FOUND THEN

Line 168: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.get_collector_name()-' );

164: INTO l_collector_name
165: FROM ar_collectors
166: WHERE collector_id = l_collector_id;
167: IF PG_DEBUG in ('Y', 'C') THEN
168: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.get_collector_name()-' );
169: END IF;
170: RETURN l_collector_name;
171: WHEN OTHERS THEN
172: RETURN null;

Line 209: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.cc_mapping_exist()+' );

205: RETURN VARCHAR2 IS
206: l_return VARCHAR2(1);
207: BEGIN
208: IF PG_DEBUG in ('Y', 'C') THEN
209: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.cc_mapping_exist()+' );
210: END IF;
211: SELECT 'Y'
212: INTO l_return
213: FROM dual

Line 220: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.cc_mapping_exist()-' );

216: WHERE cc_error_code = p_cc_error_code
217: AND cc_trx_category = p_cc_trx_category
218: AND receipt_method_id = p_receipt_method_id);
219: IF PG_DEBUG in ('Y', 'C') THEN
220: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.cc_mapping_exist()-' );
221: END IF;
222: RETURN l_return;
223: EXCEPTION
224: WHEN OTHERS THEN

Line 281: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.get_action_code()+' );

277: l_subsequent_action_code VARCHAR2(30);
278:
279: BEGIN
280: IF PG_DEBUG in ('Y', 'C') THEN
281: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.get_action_code()+' );
282: END IF;
283:
284: IF PG_DEBUG in ('Y', 'C') THEN
285: ---Print input parameters

Line 286: arp_standard.debug( '--- Input Parameters : ---');

282: END IF;
283:
284: IF PG_DEBUG in ('Y', 'C') THEN
285: ---Print input parameters
286: arp_standard.debug( '--- Input Parameters : ---');
287: arp_standard.debug( 'p_cc_trx_id :'|| p_cc_trx_id);
288: arp_standard.debug( 'p_cc_trx_category :'|| p_cc_trx_category);
289: arp_standard.debug( 'p_customer_bank_account_id: ' ||
290: p_customer_bank_account_id);

Line 287: arp_standard.debug( 'p_cc_trx_id :'|| p_cc_trx_id);

283:
284: IF PG_DEBUG in ('Y', 'C') THEN
285: ---Print input parameters
286: arp_standard.debug( '--- Input Parameters : ---');
287: arp_standard.debug( 'p_cc_trx_id :'|| p_cc_trx_id);
288: arp_standard.debug( 'p_cc_trx_category :'|| p_cc_trx_category);
289: arp_standard.debug( 'p_customer_bank_account_id: ' ||
290: p_customer_bank_account_id);
291: arp_standard.debug( 'p_cc_error_code: ' || p_cc_error_code);

Line 288: arp_standard.debug( 'p_cc_trx_category :'|| p_cc_trx_category);

284: IF PG_DEBUG in ('Y', 'C') THEN
285: ---Print input parameters
286: arp_standard.debug( '--- Input Parameters : ---');
287: arp_standard.debug( 'p_cc_trx_id :'|| p_cc_trx_id);
288: arp_standard.debug( 'p_cc_trx_category :'|| p_cc_trx_category);
289: arp_standard.debug( 'p_customer_bank_account_id: ' ||
290: p_customer_bank_account_id);
291: arp_standard.debug( 'p_cc_error_code: ' || p_cc_error_code);
292: arp_standard.debug( 'p_receipt_method_id: ' || p_receipt_method_id);

Line 289: arp_standard.debug( 'p_customer_bank_account_id: ' ||

285: ---Print input parameters
286: arp_standard.debug( '--- Input Parameters : ---');
287: arp_standard.debug( 'p_cc_trx_id :'|| p_cc_trx_id);
288: arp_standard.debug( 'p_cc_trx_category :'|| p_cc_trx_category);
289: arp_standard.debug( 'p_customer_bank_account_id: ' ||
290: p_customer_bank_account_id);
291: arp_standard.debug( 'p_cc_error_code: ' || p_cc_error_code);
292: arp_standard.debug( 'p_receipt_method_id: ' || p_receipt_method_id);
293:

Line 291: arp_standard.debug( 'p_cc_error_code: ' || p_cc_error_code);

287: arp_standard.debug( 'p_cc_trx_id :'|| p_cc_trx_id);
288: arp_standard.debug( 'p_cc_trx_category :'|| p_cc_trx_category);
289: arp_standard.debug( 'p_customer_bank_account_id: ' ||
290: p_customer_bank_account_id);
291: arp_standard.debug( 'p_cc_error_code: ' || p_cc_error_code);
292: arp_standard.debug( 'p_receipt_method_id: ' || p_receipt_method_id);
293:
294: END IF;
295:

Line 292: arp_standard.debug( 'p_receipt_method_id: ' || p_receipt_method_id);

288: arp_standard.debug( 'p_cc_trx_category :'|| p_cc_trx_category);
289: arp_standard.debug( 'p_customer_bank_account_id: ' ||
290: p_customer_bank_account_id);
291: arp_standard.debug( 'p_cc_error_code: ' || p_cc_error_code);
292: arp_standard.debug( 'p_receipt_method_id: ' || p_receipt_method_id);
293:
294: END IF;
295:
296:

Line 300: arp_standard.debug( 'get_action_code()+' );

296:
297: -- Check if there is action code in ar_cc_error_mappings
298: BEGIN
299: IF PG_DEBUG in ('Y', 'C') THEN
300: arp_standard.debug( 'get_action_code()+' );
301: END IF;
302: SELECT cc_action_code,
303: cc_error_text,
304: no_days,

Line 319: arp_standard.debug( 'cc_action_code: '|| l_cc_action_code );

315: AND receipt_method_id = p_receipt_method_id;
316:
317:
318: IF PG_DEBUG in ('Y', 'C') THEN
319: arp_standard.debug( 'cc_action_code: '|| l_cc_action_code );
320: arp_standard.debug( 'no_days: '|| l_no_days );
321: arp_standard.debug( 'subsequent_action_code: '|| l_subsequent_action_code );
322:
323: END IF;

Line 320: arp_standard.debug( 'no_days: '|| l_no_days );

316:
317:
318: IF PG_DEBUG in ('Y', 'C') THEN
319: arp_standard.debug( 'cc_action_code: '|| l_cc_action_code );
320: arp_standard.debug( 'no_days: '|| l_no_days );
321: arp_standard.debug( 'subsequent_action_code: '|| l_subsequent_action_code );
322:
323: END IF;
324:

Line 321: arp_standard.debug( 'subsequent_action_code: '|| l_subsequent_action_code );

317:
318: IF PG_DEBUG in ('Y', 'C') THEN
319: arp_standard.debug( 'cc_action_code: '|| l_cc_action_code );
320: arp_standard.debug( 'no_days: '|| l_no_days );
321: arp_standard.debug( 'subsequent_action_code: '|| l_subsequent_action_code );
322:
323: END IF;
324:
325:

Line 335: arp_standard.debug( 'EXCEPTION ARP_CORRECT_CC_ERRORS.get_action_code()' );

331: x_error_notes := NULL;
332: RETURN;
333: WHEN OTHERS THEN
334: IF PG_DEBUG in ('Y', 'C') THEN
335: arp_standard.debug( 'EXCEPTION ARP_CORRECT_CC_ERRORS.get_action_code()' );
336: END IF;
337: raise;
338: END;
339:

Line 362: arp_standard.debug( 'EXCEPTION ARP_CORRECT_CC_ERRORS.get_action_code()' );

358: x_error_notes := NULL;
359: RETURN;
360: WHEN OTHERS THEN
361: IF PG_DEBUG in ('Y', 'C') THEN
362: arp_standard.debug( 'EXCEPTION ARP_CORRECT_CC_ERRORS.get_action_code()' );
363: END IF;
364: raise;
365: END;
366:

Line 379: arp_standard.debug( 'First CC error Date; '|| l_first_cc_error_date );

375: AND cc_error_code = p_cc_error_code
376: AND first_record_flag = 'Y';
377:
378: IF PG_DEBUG in ('Y', 'C') THEN
379: arp_standard.debug( 'First CC error Date; '|| l_first_cc_error_date );
380: END IF;
381:
382: EXCEPTION
383: WHEN NO_DATA_FOUND THEN

Line 390: arp_standard.debug( 'EXCEPTION ARP_CORRECT_CC_ERRORS.get_action_code()' );

386: x_first_record_flag := 'Y';
387: RETURN;
388: WHEN OTHERS THEN
389: IF PG_DEBUG in ('Y', 'C') THEN
390: arp_standard.debug( 'EXCEPTION ARP_CORRECT_CC_ERRORS.get_action_code()' );
391: END IF;
392: raise;
393: END;
394:

Line 412: arp_standard.debug( ' Action or Subsequent Action x_cc_action_type : ' ||

408: x_first_record_flag := 'N';
409: END IF;
410:
411: IF PG_DEBUG in ('Y', 'C') THEN
412: arp_standard.debug( ' Action or Subsequent Action x_cc_action_type : ' ||
413: x_cc_action_type );
414: END IF;
415:
416: IF PG_DEBUG in ('Y', 'C') THEN

Line 417: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.get_action_code()-' );

413: x_cc_action_type );
414: END IF;
415:
416: IF PG_DEBUG in ('Y', 'C') THEN
417: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.get_action_code()-' );
418: END IF;
419: END get_action_code;
420:
421: /*===========================================================================+

Line 447: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.insert_p()+' );

443: +===========================================================================*/
444: PROCEDURE insert_p(p_cc_error_hist IN ar_cc_error_history%ROWTYPE) IS
445: BEGIN
446: IF PG_DEBUG in ('Y', 'C') THEN
447: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.insert_p()+' );
448: END IF;
449: INSERT INTO ar_cc_error_history
450: (
451: request_id,

Line 492: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.insert_p()-' );

488: NVL(pg_login_id,pg_conc_login_id),
489: pg_user_id
490: );
491: IF PG_DEBUG in ('Y', 'C') THEN
492: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.insert_p()-' );
493: END IF;
494: EXCEPTION
495: WHEN OTHERS THEN
496: arp_standard.debug( 'EXCEPTION ARP_CORRECT_CC_ERRORS.insert_p()' );

Line 496: arp_standard.debug( 'EXCEPTION ARP_CORRECT_CC_ERRORS.insert_p()' );

492: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.insert_p()-' );
493: END IF;
494: EXCEPTION
495: WHEN OTHERS THEN
496: arp_standard.debug( 'EXCEPTION ARP_CORRECT_CC_ERRORS.insert_p()' );
497: raise;
498: END insert_p;
499:
500: /*===========================================================================+

Line 562: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.clear_invoice_pay_info()+' );

558: l_billto_contact varchar2(150);
559: l_salesrep_name ra_salesreps.name%TYPE;
560: BEGIN
561: IF PG_DEBUG in ('Y', 'C') THEN
562: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.clear_invoice_pay_info()+' );
563: END IF;
564: SELECT NVL(trx.cc_error_code,'Unknown'),
565: NVL(trx.cc_error_text,'Unknown Error'),
566: ARPT_SQL_FUNC_UTIL.get_lookup_meaning('CC_TRX_CATEGORY',p_cc_trx_category),

Line 685: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.clear_invoice_pay_info()-' );

681:
682:
683:
684: IF PG_DEBUG in ('Y', 'C') THEN
685: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.clear_invoice_pay_info()-' );
686: END IF;
687: EXCEPTION
688: WHEN OTHERS THEN
689: IF PG_DEBUG in ('Y', 'C') THEN

Line 690: arp_standard.debug( 'Exception ARP_CORRECT_CC_ERRORS.clear_invoice_pay_info()' );

686: END IF;
687: EXCEPTION
688: WHEN OTHERS THEN
689: IF PG_DEBUG in ('Y', 'C') THEN
690: arp_standard.debug( 'Exception ARP_CORRECT_CC_ERRORS.clear_invoice_pay_info()' );
691: END IF;
692: raise;
693: END clear_invoice_pay_info;
694:

Line 726: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.default_reversal_gl_date()+' );

722: l_default_gl_date DATE;
723: l_gl_date DATE;
724: BEGIN
725: IF PG_DEBUG in ('Y', 'C') THEN
726: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.default_reversal_gl_date()+' );
727: END IF;
728: SELECT max(gl_date)
729: INTO l_gl_date
730: FROM ar_cash_receipt_history

Line 766: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.default_reversal_gl_date()-' );

762: FND_MSG_PUB.Add;
763: app_exception.raise_exception;
764: END IF;
765: IF PG_DEBUG in ('Y', 'C') THEN
766: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.default_reversal_gl_date()-' );
767: END IF;
768: EXCEPTION
769: WHEN OTHERS THEN
770: IF PG_DEBUG in ('Y', 'C') THEN

Line 771: arp_standard.debug( 'EXCEPTION ARP_CORRECT_CC_ERRORS.default_reversal_gl_date()' );

767: END IF;
768: EXCEPTION
769: WHEN OTHERS THEN
770: IF PG_DEBUG in ('Y', 'C') THEN
771: arp_standard.debug( 'EXCEPTION ARP_CORRECT_CC_ERRORS.default_reversal_gl_date()' );
772: END IF;
773: raise;
774: END default_reversal_gl_date;
775:

Line 803: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.default_reversal_date()+' );

799: FUNCTION default_reversal_date(p_cash_receipt_id IN NUMBER) RETURN DATE IS
800: l_receipt_date DATE;
801: BEGIN
802: IF PG_DEBUG in ('Y', 'C') THEN
803: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.default_reversal_date()+' );
804: END IF;
805: SELECT receipt_date
806: INTO l_receipt_date
807: FROM ar_cash_receipts

Line 816: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.default_reversal_date()+' );

812: ELSE
813: RETURN l_receipt_date;
814: END IF;
815: IF PG_DEBUG in ('Y', 'C') THEN
816: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.default_reversal_date()+' );
817: END IF;
818: END default_reversal_date;
819:
820: /*===========================================================================+

Line 856: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.reverse_receipt()+' );

852: l_msg_index NUMBER;
853: API_exception EXCEPTION;
854: BEGIN
855: IF PG_DEBUG in ('Y', 'C') THEN
856: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.reverse_receipt()+' );
857: END IF;
858: --
859: -- Populate the arguments to pass to AR_RECEIPT_API_PUB.Reverse
860: --

Line 938: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.reverse_receipt()-' );

934:
935: END IF; -- l_return_status
936:
937: IF PG_DEBUG in ('Y', 'C') THEN
938: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.reverse_receipt()-' );
939: END IF;
940: EXCEPTION
941: WHEN API_exception THEN
942: IF PG_DEBUG in ('Y', 'C') THEN