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.AR_BILLS_CREATION_VAL_PVT dependencies on AR_BILLS_CREATION_VAL_PVT

Line 1: Package Body AR_BILLS_CREATION_VAL_PVT AS

1: Package Body AR_BILLS_CREATION_VAL_PVT AS
2: /* $Header: ARBRCRVB.pls 120.9 2011/07/10 01:19:09 dgaurab ship $ */
3:
4:
5:

Line 32: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Gl_Date ()+');

28:
29: BEGIN
30:
31: IF PG_DEBUG in ('Y', 'C') THEN
32: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Gl_Date ()+');
33: END IF;
34:
35: IF (p_gl_date IS NOT NULL)
36: THEN

Line 50: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Gl_Date ()-');

46: END IF;
47: END IF;
48:
49: IF PG_DEBUG in ('Y', 'C') THEN
50: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Gl_Date ()-');
51: END IF;
52:
53: EXCEPTION
54: WHEN OTHERS THEN

Line 56: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_VAL_PVT.Validate_GL_Date() ');

52:
53: EXCEPTION
54: WHEN OTHERS THEN
55: IF PG_DEBUG in ('Y', 'C') THEN
56: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_VAL_PVT.Validate_GL_Date() ');
57: arp_util.debug('Validate_Gl_Date: ' || 'p_gl_date = ' || p_gl_date);
58: END IF;
59: RAISE;
60:

Line 86: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Update_Maturity_Date ()+');

82:
83: BEGIN
84:
85: IF PG_DEBUG in ('Y', 'C') THEN
86: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Update_Maturity_Date ()+');
87: END IF;
88:
89:
90: /*----------------------------------------------+

Line 130: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Update_Maturity_Date ()-');

126:
127: END IF;
128:
129: IF PG_DEBUG in ('Y', 'C') THEN
130: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Update_Maturity_Date ()-');
131: END IF;
132:
133: EXCEPTION
134: WHEN OTHERS THEN

Line 136: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_VAL_PVT.Validate_Update_Maturity_Date() ');

132:
133: EXCEPTION
134: WHEN OTHERS THEN
135: IF PG_DEBUG in ('Y', 'C') THEN
136: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_VAL_PVT.Validate_Update_Maturity_Date() ');
137: arp_util.debug('Validate_Update_Maturity_Date: ' || 'p_customer_trx_id = ' || p_customer_trx_id);
138: arp_util.debug('Validate_Update_Maturity_Date: ' || 'p_term_due_date = ' || p_term_due_date);
139: END IF;
140: RAISE;

Line 167: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Batch_Source()+');

163: l_status VARCHAR2(1);
164:
165: BEGIN
166: IF PG_DEBUG in ('Y', 'C') THEN
167: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Batch_Source()+');
168: END IF;
169:
170: SELECT start_date, end_date, status
171: INTO l_start_date, l_end_date, l_status

Line 213: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Batch_Source()-');

209: END IF;
210:
211:
212: IF PG_DEBUG in ('Y', 'C') THEN
213: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Batch_Source()-');
214: END IF;
215:
216: EXCEPTION
217: WHEN NO_DATA_FOUND THEN

Line 219: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_VAL_PVT.Validate_Batch_Source() ');

215:
216: EXCEPTION
217: WHEN NO_DATA_FOUND THEN
218: IF PG_DEBUG in ('Y', 'C') THEN
219: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_VAL_PVT.Validate_Batch_Source() ');
220: arp_util.debug('Validate_Batch_Source: ' || '>>>>>>>>>> Invalid Batch Source');
221: arp_util.debug('Validate_Batch_Source: ' || ' p_batch_source_id = ' || p_batch_source_id);
222: arp_util.debug('Validate_Batch_Source: ' || ' p_issue_date = ' || p_issue_date);
223: END IF;

Line 229: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_VAL_PVT.Validate_Batch_Source() ');

225: app_exception.raise_exception;
226:
227: WHEN OTHERS THEN
228: IF PG_DEBUG in ('Y', 'C') THEN
229: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_VAL_PVT.Validate_Batch_Source() ');
230: arp_util.debug('Validate_Batch_Source: ' || ' p_batch_source_id = ' || p_batch_source_id);
231: arp_util.debug('Validate_Batch_Source: ' || ' p_issue_date = ' || p_issue_date);
232: END IF;
233: RAISE;

Line 261: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Transaction_Type()+');

257:
258: BEGIN
259:
260: IF PG_DEBUG in ('Y', 'C') THEN
261: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Transaction_Type()+');
262: END IF;
263:
264: SELECT status, start_date, end_date
265: INTO l_status, l_start_date, l_end_date

Line 308: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Transaction_Type()-');

304: app_exception.raise_exception;
305: END IF;
306:
307: IF PG_DEBUG in ('Y', 'C') THEN
308: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Transaction_Type()-');
309: END IF;
310:
311: EXCEPTION
312: WHEN NO_DATA_FOUND THEN

Line 314: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_VAL_PVT.Validate_Transaction_Type() ');

310:
311: EXCEPTION
312: WHEN NO_DATA_FOUND THEN
313: IF PG_DEBUG in ('Y', 'C') THEN
314: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_VAL_PVT.Validate_Transaction_Type() ');
315: arp_util.debug('Validate_Transaction_Type: ' || '>>>>>>>>>> Invalid Transaction Type');
316: arp_util.debug('Validate_Transaction_Type: ' || ' p_cust_trx_type_id = ' || p_cust_trx_type_id);
317: arp_util.debug('Validate_Transaction_Type: ' || ' p_issue_date = ' || p_issue_date);
318: END IF;

Line 324: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_VAL_PVT.Validate_Transaction_Type() ');

320: app_exception.raise_exception;
321:
322: WHEN OTHERS THEN
323: IF PG_DEBUG in ('Y', 'C') THEN
324: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_VAL_PVT.Validate_Transaction_Type() ');
325: arp_util.debug('Validate_Transaction_Type: ' || ' p_cust_trx_type_id = ' || p_cust_trx_type_id);
326: arp_util.debug('Validate_Transaction_Type: ' || ' p_issue_date = ' || p_issue_date);
327: END IF;
328: RAISE;

Line 349: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Drawee ()+');

345: l_drawee_valid VARCHAR2(1);
346:
347: BEGIN
348: IF PG_DEBUG in ('Y', 'C') THEN
349: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Drawee ()+');
350: END IF;
351:
352: /* modified for tca uptake */
353: SELECT 'Y'

Line 359: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Drawee ()-');

355: FROM HZ_CUST_ACCOUNTS
356: WHERE cust_account_id = p_drawee_id;
357:
358: IF PG_DEBUG in ('Y', 'C') THEN
359: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Drawee ()-');
360: END IF;
361:
362: EXCEPTION
363: WHEN NO_DATA_FOUND THEN

Line 365: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_VAL_PVT.Validate_Drawee () ');

361:
362: EXCEPTION
363: WHEN NO_DATA_FOUND THEN
364: IF PG_DEBUG in ('Y', 'C') THEN
365: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_VAL_PVT.Validate_Drawee () ');
366: arp_util.debug('Validate_Drawee: ' || '>>>>>>>>>> Invalid Drawee');
367: arp_util.debug('Validate_Drawee: ' || ' p_drawee_id = ' || p_drawee_id);
368: END IF;
369: FND_MESSAGE.SET_NAME ('AR', 'AR_BR_INVALID_DRAWEE');

Line 374: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_VAL_PVT.Validate_Drawee () ');

370: app_exception.raise_exception;
371:
372: WHEN OTHERS THEN
373: IF PG_DEBUG in ('Y', 'C') THEN
374: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_VAL_PVT.Validate_Drawee () ');
375: arp_util.debug('Validate_Drawee: ' || ' p_drawee_id = ' || p_drawee_id);
376: END IF;
377: RAISE;
378:

Line 399: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Drawee_Location ()+');

395: l_status VARCHAR2(1);
396:
397: BEGIN
398: IF PG_DEBUG in ('Y', 'C') THEN
399: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Drawee_Location ()+');
400: END IF;
401:
402: IF (p_drawee_site_use_id IS NOT NULL)
403: THEN

Line 426: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Drawee_Location ()-');

422: END IF;
423: END IF;
424:
425: IF PG_DEBUG in ('Y', 'C') THEN
426: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Drawee_Location ()-');
427: END IF;
428:
429: EXCEPTION
430: WHEN NO_DATA_FOUND THEN

Line 432: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_VAL_PVT.Validate_Drawee_Location () ');

428:
429: EXCEPTION
430: WHEN NO_DATA_FOUND THEN
431: IF PG_DEBUG in ('Y', 'C') THEN
432: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_VAL_PVT.Validate_Drawee_Location () ');
433: arp_util.debug('Validate_Drawee: ' || '>>>>>>>>>> Invalid Location');
434: arp_util.debug('Validate_Drawee: ' || ' p_drawee_site_use_id = ' || p_drawee_site_use_id);
435: END IF;
436: FND_MESSAGE.SET_NAME ('AR', 'AR_BR_INVALID_DRAWEE_SITE');

Line 441: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_VAL_PVT.Validate_Drawee_Location () ');

437: app_exception.raise_exception;
438:
439: WHEN OTHERS THEN
440: IF PG_DEBUG in ('Y', 'C') THEN
441: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_VAL_PVT.Validate_Drawee_Location () ');
442: arp_util.debug('Validate_Drawee: ' || ' p_drawee_site_use_id = ' || p_drawee_site_use_id);
443: END IF;
444: RAISE;
445:

Line 466: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Drawee_Contact ()+');

462: l_status VARCHAR2(1);
463:
464: BEGIN
465: IF PG_DEBUG in ('Y', 'C') THEN
466: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Drawee_Contact ()+');
467: END IF;
468:
469: IF (p_drawee_contact_id IS NOT NULL)
470: THEN

Line 492: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Drawee_Contact ()-');

488:
489: END IF;
490:
491: IF PG_DEBUG in ('Y', 'C') THEN
492: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Drawee_Contact ()-');
493: END IF;
494:
495: EXCEPTION
496: WHEN NO_DATA_FOUND THEN

Line 498: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_VAL_PVT.Validate_Drawee_Contact () ');

494:
495: EXCEPTION
496: WHEN NO_DATA_FOUND THEN
497: IF PG_DEBUG in ('Y', 'C') THEN
498: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_VAL_PVT.Validate_Drawee_Contact () ');
499: arp_util.debug('Validate_Drawee: ' || '>>>>>>>>>> Invalid Contact');
500: arp_util.debug('Validate_Drawee: ' || ' p_drawee_contact_id = ' || p_drawee_contact_id);
501: arp_util.debug('Validate_Drawee: ' || ' p_drawee_id = ' || p_drawee_id);
502: END IF;

Line 508: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_VAL_PVT.Validate_Drawee_Contact () ');

504: app_exception.raise_exception;
505:
506: WHEN OTHERS THEN
507: IF PG_DEBUG in ('Y', 'C') THEN
508: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_VAL_PVT.Validate_Drawee_Contact () ');
509: arp_util.debug('Validate_Drawee: ' || ' p_drawee_contact_id = ' || p_drawee_contact_id);
510: arp_util.debug('Validate_Drawee: ' || ' p_drawee_id = ' || p_drawee_id);
511: END IF;
512: RAISE;

Line 535: arp_util.debug('Validate_Drawee: ' || 'AR_BILLS_CREATION_VAL_PVT.Validate_Currency ()+');

531: l_end_date DATE;
532:
533: BEGIN
534: IF PG_DEBUG in ('Y', 'C') THEN
535: arp_util.debug('Validate_Drawee: ' || 'AR_BILLS_CREATION_VAL_PVT.Validate_Currency ()+');
536: END IF;
537:
538: SELECT start_date_active, end_date_active
539: INTO l_start_date , l_end_date

Line 564: arp_util.debug('Validate_Drawee: ' || 'AR_BILLS_CREATION_VAL_PVT.Validate_Currency ()-');

560: END IF;
561:
562:
563: IF PG_DEBUG in ('Y', 'C') THEN
564: arp_util.debug('Validate_Drawee: ' || 'AR_BILLS_CREATION_VAL_PVT.Validate_Currency ()-');
565: END IF;
566:
567: EXCEPTION
568: WHEN NO_DATA_FOUND THEN

Line 570: arp_util.debug('Validate_Drawee: ' || '>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_VAL_PVT.Validate_Currency () ');

566:
567: EXCEPTION
568: WHEN NO_DATA_FOUND THEN
569: IF PG_DEBUG in ('Y', 'C') THEN
570: arp_util.debug('Validate_Drawee: ' || '>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_VAL_PVT.Validate_Currency () ');
571: arp_util.debug('Validate_Drawee: ' || '>>>>>>>>>> Invalid Currency');
572: arp_util.debug('Validate_Drawee: ' || ' p_invoice_currency_code = : ' || p_invoice_currency_code);
573: arp_util.debug('Validate_Drawee: ' || ' p_issue_date = : ' || p_issue_date);
574: END IF;

Line 580: arp_util.debug('Validate_Drawee: ' || '>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_VAL_PVT.Validate_Currency () ');

576: app_exception.raise_exception;
577:
578: WHEN OTHERS THEN
579: IF PG_DEBUG in ('Y', 'C') THEN
580: arp_util.debug('Validate_Drawee: ' || '>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_VAL_PVT.Validate_Currency () ');
581: arp_util.debug('Validate_Drawee: ' || ' p_invoice_currency_code = : ' || p_invoice_currency_code);
582: arp_util.debug('Validate_Drawee: ' || ' p_issue_date = : ' || p_issue_date);
583: END IF;
584: RAISE;

Line 612: arp_util.debug('Validate_Drawee: ' || 'AR_BILLS_CREATION_VAL_PVT.Validate_Printing_Option ()+');

608: printing_option_invalid EXCEPTION;
609:
610: BEGIN
611: IF PG_DEBUG in ('Y', 'C') THEN
612: arp_util.debug('Validate_Drawee: ' || 'AR_BILLS_CREATION_VAL_PVT.Validate_Printing_Option ()+');
613: END IF;
614:
615:
616: /*----------------------------------------------+

Line 677: arp_util.debug('Validate_Drawee: ' || 'AR_BILLS_CREATION_VAL_PVT.Validate_Printing_Option ()-');

673: app_exception.raise_exception;
674: END IF;
675:
676: IF PG_DEBUG in ('Y', 'C') THEN
677: arp_util.debug('Validate_Drawee: ' || 'AR_BILLS_CREATION_VAL_PVT.Validate_Printing_Option ()-');
678: END IF;
679:
680: EXCEPTION
681: WHEN printing_option_invalid THEN

Line 693: arp_util.debug('Validate_Drawee: ' || '>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_VAL_PVT.Validate_Printing_Option () ');

689: app_exception.raise_exception;
690:
691: WHEN OTHERS THEN
692: IF PG_DEBUG in ('Y', 'C') THEN
693: arp_util.debug('Validate_Drawee: ' || '>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_VAL_PVT.Validate_Printing_Option () ');
694: arp_util.debug('Validate_Drawee: ' || ' p_printing_option = ' || p_printing_option);
695: arp_util.debug('Validate_Drawee: ' || ' p_cust_trx_type_id = ' || p_cust_trx_type_id);
696: END IF;
697: RAISE;

Line 738: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Drawee_Account ()+');

734: l_bank_ok NUMBER; /* bug 1798699 */
735:
736: BEGIN
737: IF PG_DEBUG in ('Y', 'C') THEN
738: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Drawee_Account ()+');
739: END IF;
740:
741: /* bug 1758982: Unable to create Manual BR when customer has
742: more then 1 drawee site with same bank account assigned */

Line 747: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Drawee_Account ()-');

743:
744: /* PAYMENT_UPTAKE: Removed validation bcoz Drawee_bank_account_id is obsoleted */
745:
746: IF PG_DEBUG in ('Y', 'C') THEN
747: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Drawee_Account ()-');
748: END IF;
749:
750: END Validate_Drawee_Account;
751:

Line 799: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Remit_Account ()+');

795:
796: BEGIN
797:
798: IF pg_debug IN ('Y', 'C') THEN
799: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Remit_Account ()+');
800: END IF;
801:
802: IF (p_remit_bank_account_id IS NOT NULL) THEN
803:

Line 863: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Remit_Account ()-');

859:
860: END IF;
861:
862: IF pg_debug IN ('Y', 'C') THEN
863: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Remit_Account ()-');
864: END IF;
865:
866: EXCEPTION
867: WHEN NO_DATA_FOUND THEN

Line 869: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_VAL_PVT.Validate_Remit_Account () ');

865:
866: EXCEPTION
867: WHEN NO_DATA_FOUND THEN
868: IF pg_debug IN ('Y', 'C') THEN
869: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_VAL_PVT.Validate_Remit_Account () ');
870: arp_util.debug('Validate_Remit_Account: ' || '>>>>>>>>>> Invalid Remittance Account');
871: arp_util.debug('Validate_Remit_Account: ' || ' remit bank account use id = ' || p_remit_bank_account_id);
872: arp_util.debug('Validate_Remit_Account: ' || ' p_invoice_currency_code = ' || p_invoice_currency_code);
873: arp_util.debug('Validate_Remit_Account: ' || ' p_issue_date = ' || p_issue_date);

Line 881: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_VAL_PVT.Validate_Remit_Account () ');

877: app_exception.raise_exception;
878:
879: WHEN OTHERS THEN
880: IF pg_debug IN ('Y', 'C') THEN
881: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_VAL_PVT.Validate_Remit_Account () ');
882: arp_util.debug('Validate_Remit_Account: ' || ' remit bank account use id = ' || p_remit_bank_account_id);
883: arp_util.debug('Validate_Remit_Account: ' || ' p_invoice_currency_code = ' || p_invoice_currency_code);
884: arp_util.debug('Validate_Remit_Account: ' || ' p_issue_date = ' || p_issue_date);
885: END IF;

Line 906: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Override_Flag ()+');

902: PROCEDURE Validate_Override_Flag ( p_override_remit_account_flag IN VARCHAR2) IS
903:
904: BEGIN
905: IF PG_DEBUG in ('Y', 'C') THEN
906: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Override_Flag ()+');
907: END IF;
908:
909: IF p_override_remit_account_flag NOT IN ('Y', 'N')
910: THEN

Line 922: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Override_Flag ()-');

918: app_exception.raise_exception;
919: END IF;
920:
921: IF PG_DEBUG in ('Y', 'C') THEN
922: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Override_Flag ()-');
923: END IF;
924:
925: EXCEPTION
926: WHEN OTHERS THEN

Line 928: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_VAL_PVT.Validate_Override_Flag () ');

924:
925: EXCEPTION
926: WHEN OTHERS THEN
927: IF PG_DEBUG in ('Y', 'C') THEN
928: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_VAL_PVT.Validate_Override_Flag () ');
929: arp_util.debug('Validate_Override_Flag: ' || ' p_override_remit_account_flag = ' || p_override_remit_account_flag);
930: END IF;
931: app_exception.raise_exception;
932:

Line 952: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Batch_ID ()+');

948: l_batch_id_valid VARCHAR2(1);
949:
950: BEGIN
951: IF PG_DEBUG in ('Y', 'C') THEN
952: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Batch_ID ()+');
953: END IF;
954:
955: IF (p_batch_id IS NOT NULL)
956: THEN

Line 965: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Batch_ID ()-');

961: AND status = 'A';
962: END IF;
963:
964: IF PG_DEBUG in ('Y', 'C') THEN
965: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Batch_ID ()-');
966: END IF;
967:
968: EXCEPTION
969: WHEN NO_DATA_FOUND THEN

Line 971: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_VAL_PVT.Validate_Batch_ID () ');

967:
968: EXCEPTION
969: WHEN NO_DATA_FOUND THEN
970: IF PG_DEBUG in ('Y', 'C') THEN
971: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_VAL_PVT.Validate_Batch_ID () ');
972: arp_util.debug('Validate_Batch_ID: ' || '>>>>>>>>>> Invalid Batch ID');
973: arp_util.debug('Validate_Batch_ID: ' || ' p_batch_id = ' || p_batch_id);
974: END IF;
975: FND_MESSAGE.SET_NAME ('AR', 'AR_BR_INVALID_BATCH_ID');

Line 980: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_VAL_PVT.Validate_Batch_ID () ');

976: app_exception.raise_exception;
977:
978: WHEN OTHERS THEN
979: IF PG_DEBUG in ('Y', 'C') THEN
980: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_VAL_PVT.Validate_Batch_ID () ');
981: arp_util.debug('Validate_Batch_ID: ' || ' p_batch_id = ' || p_batch_id);
982: END IF;
983: RAISE;
984:

Line 1005: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Customer_Trx_ID ()+');

1001: l_customer_trx_id_valid VARCHAR2(1);
1002:
1003: BEGIN
1004: IF PG_DEBUG in ('Y', 'C') THEN
1005: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Customer_Trx_ID ()+');
1006: END IF;
1007:
1008: SELECT 'Y'
1009: INTO l_customer_trx_id_valid

Line 1014: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Customer_Trx_ID ()-');

1010: FROM RA_CUSTOMER_TRX
1011: WHERE customer_trx_id = p_customer_trx_id;
1012:
1013: IF PG_DEBUG in ('Y', 'C') THEN
1014: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Customer_Trx_ID ()-');
1015: END IF;
1016:
1017: EXCEPTION
1018: WHEN NO_DATA_FOUND THEN

Line 1020: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_VAL_PVT.Validate_Customer_Trx_ID () ');

1016:
1017: EXCEPTION
1018: WHEN NO_DATA_FOUND THEN
1019: IF PG_DEBUG in ('Y', 'C') THEN
1020: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_VAL_PVT.Validate_Customer_Trx_ID () ');
1021: arp_util.debug('Validate_Customer_Trx_ID: ' || '>>>>>>>>>> Invalid BR ID');
1022: arp_util.debug('Validate_Customer_Trx_ID: ' || ' Customer Trx ID : ' || p_customer_trx_id);
1023: END IF;
1024: FND_MESSAGE.SET_NAME ('AR', 'AR_BR_INVALID_BR_ID');

Line 1029: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_VAL_PVT.Validate_Customer_Trx_ID () ');

1025: app_exception.raise_exception;
1026:
1027: WHEN OTHERS THEN
1028: IF PG_DEBUG in ('Y', 'C') THEN
1029: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_VAL_PVT.Validate_Customer_Trx_ID () ');
1030: arp_util.debug('Validate_Customer_Trx_ID: ' || ' p_customer_trx_id = ' || p_customer_trx_id);
1031: END IF;
1032: RAISE;
1033:

Line 1053: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Customer_Trx_Line_ID ()+');

1049: l_valid VARCHAR2(1);
1050:
1051: BEGIN
1052: IF PG_DEBUG in ('Y', 'C') THEN
1053: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Customer_Trx_Line_ID ()+');
1054: END IF;
1055:
1056: SELECT 'Y'
1057: INTO l_valid

Line 1062: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Customer_Trx_Line_ID ()-');

1058: FROM RA_CUSTOMER_TRX_LINES
1059: WHERE customer_trx_line_id = p_customer_trx_line_id;
1060:
1061: IF PG_DEBUG in ('Y', 'C') THEN
1062: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Customer_Trx_Line_ID ()-');
1063: END IF;
1064:
1065: EXCEPTION
1066: WHEN NO_DATA_FOUND THEN

Line 1068: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_VAL_PVT.Validate_Customer_Trx_Line_ID () ');

1064:
1065: EXCEPTION
1066: WHEN NO_DATA_FOUND THEN
1067: IF PG_DEBUG in ('Y', 'C') THEN
1068: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_VAL_PVT.Validate_Customer_Trx_Line_ID () ');
1069: arp_util.debug('Validate_Customer_Trx_Line_ID: ' || '>>>>>>>>>> Invalid BR Assignment ID');
1070: arp_util.debug('Validate_Customer_Trx_Line_ID: ' || ' p_customer_trx_line_id = ' || p_customer_trx_line_id);
1071: END IF;
1072: FND_MESSAGE.SET_NAME ('AR', 'AR_BR_INVALID_ASSIGNMENT_ID');

Line 1077: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_VAL_PVT.Validate_Customer_Trx_Line_ID () ');

1073: app_exception.raise_exception;
1074:
1075: WHEN OTHERS THEN
1076: IF PG_DEBUG in ('Y', 'C') THEN
1077: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_VAL_PVT.Validate_Customer_Trx_Line_ID () ');
1078: arp_util.debug('Validate_Customer_Trx_Line_ID: ' || ' p_customer_trx_line_id = ' || p_customer_trx_line_id);
1079: END IF;
1080: RAISE;
1081:

Line 1104: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Create_BR_Header ()+');

1100:
1101: BEGIN
1102:
1103: IF PG_DEBUG in ('Y', 'C') THEN
1104: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Create_BR_Header ()+');
1105: END IF;
1106:
1107:
1108: -- Validate GL Date

Line 1165: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Create_BR_Header ()-');

1161:
1162: Validate_Batch_ID (p_trx_rec.batch_id);
1163:
1164: IF PG_DEBUG in ('Y', 'C') THEN
1165: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Create_BR_Header ()-');
1166: END IF;
1167:
1168: EXCEPTION
1169: WHEN Others THEN

Line 1171: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_VAL_PVT.Validate_Create_BR_Header () ');

1167:
1168: EXCEPTION
1169: WHEN Others THEN
1170: IF PG_DEBUG in ('Y', 'C') THEN
1171: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_VAL_PVT.Validate_Create_BR_Header () ');
1172: END IF;
1173: RAISE;
1174:
1175: END Validate_Create_BR_Header;

Line 1197: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Update_BR_Header ()+');

1193:
1194: BEGIN
1195:
1196: IF PG_DEBUG in ('Y', 'C') THEN
1197: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Update_BR_Header ()+');
1198: END IF;
1199:
1200: -- Validate GL Date
1201: --Commented by Yao Zhang for bug 10125134

Line 1255: arp_util.debug('Validate_Update_BR_Header: ' || 'AR_BILLS_CREATION_VAL_PVT.Validate_BR_Update_Header ()-');

1251:
1252: Validate_Override_Flag (p_trx_rec.override_remit_account_flag);
1253:
1254: IF PG_DEBUG in ('Y', 'C') THEN
1255: arp_util.debug('Validate_Update_BR_Header: ' || 'AR_BILLS_CREATION_VAL_PVT.Validate_BR_Update_Header ()-');
1256: END IF;
1257:
1258:
1259: EXCEPTION

Line 1262: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_VAL_PVT.Validate_Update_BR_Header () ');

1258:
1259: EXCEPTION
1260: WHEN Others THEN
1261: IF PG_DEBUG in ('Y', 'C') THEN
1262: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_VAL_PVT.Validate_Update_BR_Header () ');
1263: END IF;
1264: RAISE;
1265:
1266: END Validate_Update_BR_Header;

Line 1297: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Assigned_Amount ()+');

1293:
1294:
1295: BEGIN
1296: IF PG_DEBUG in ('Y', 'C') THEN
1297: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Assigned_Amount ()+');
1298: arp_util.debug ('Validate_Assigned_Amount: ' || 'Exchange rate : ' || p_ps_rec.exchange_rate);
1299: arp_util.debug ('Validate_Assigned_Amount: ' || 'Amount Due Remaining : ' || p_ps_rec.amount_due_remaining);
1300: arp_util.debug ('Validate_Assigned_Amount: ' || 'Acctd Amount Due Remaining : ' || p_ps_rec.acctd_amount_due_remaining);
1301: END IF;

Line 1357: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Assigned_Amount ()-');

1353:
1354: IF PG_DEBUG in ('Y', 'C') THEN
1355: arp_util.debug('Validate_Assigned_Amount: ' || 'Amount_applied : ' || p_trl_rec.extended_amount);
1356: arp_util.debug('Validate_Assigned_Amount: ' || 'Acctd Amount Applied : ' || p_trl_rec.extended_acctd_amount);
1357: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Assigned_Amount ()-');
1358: END IF;
1359:
1360: EXCEPTION
1361: WHEN OTHERS THEN

Line 1363: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_VAL_PVT.Validate_Assigned_Amount () ');

1359:
1360: EXCEPTION
1361: WHEN OTHERS THEN
1362: IF PG_DEBUG in ('Y', 'C') THEN
1363: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_VAL_PVT.Validate_Assigned_Amount () ');
1364: END IF;
1365: RAISE;
1366:
1367: END Validate_Assigned_Amount;

Line 1387: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Is_Transaction_BR ()+');

1383: l_type VARCHAR2(20);
1384:
1385: BEGIN
1386: IF PG_DEBUG in ('Y', 'C') THEN
1387: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Is_Transaction_BR ()+');
1388: END IF;
1389:
1390: SELECT type
1391: INTO l_type

Line 1406: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Is_Transaction_BR ()-');

1402: RETURN (FALSE);
1403: END IF;
1404:
1405: IF PG_DEBUG in ('Y', 'C') THEN
1406: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Is_Transaction_BR ()-');
1407: END IF;
1408:
1409: EXCEPTION
1410: WHEN NO_DATA_FOUND THEN

Line 1412: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_VAL_PVT.Is_Transaction_BR () ');

1408:
1409: EXCEPTION
1410: WHEN NO_DATA_FOUND THEN
1411: IF PG_DEBUG in ('Y', 'C') THEN
1412: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_VAL_PVT.Is_Transaction_BR () ');
1413: arp_util.debug('Is_Transaction_BR: ' || '>>>>>>>>>> Invalid Transaction Type ID');
1414: arp_util.debug('Is_Transaction_BR: ' || ' p_cust_trx_type_id : ' || p_cust_trx_type_id);
1415: END IF;
1416: FND_MESSAGE.SET_NAME ('AR', 'AR_BR_INVALID_TRX_TYPE');

Line 1446: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_BR_Status ()+');

1442:
1443:
1444: BEGIN
1445: IF PG_DEBUG in ('Y', 'C') THEN
1446: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_BR_Status ()+');
1447: END IF;
1448:
1449: -- Fetch the BR history information
1450:

Line 1471: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_BR_Status ()-');

1467: END IF;
1468:
1469:
1470: IF PG_DEBUG in ('Y', 'C') THEN
1471: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_BR_Status ()-');
1472: END IF;
1473:
1474: EXCEPTION
1475: WHEN OTHERS THEN

Line 1477: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_VAL_PVT.Validate_BR_Status () ');

1473:
1474: EXCEPTION
1475: WHEN OTHERS THEN
1476: IF PG_DEBUG in ('Y', 'C') THEN
1477: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_VAL_PVT.Validate_BR_Status () ');
1478: arp_util.debug('Validate_BR_Status: ' || ' p_customer_trx_id = ' || p_customer_trx_id);
1479: END IF;
1480: RAISE;
1481:

Line 1503: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Assignment_Status ()+');

1499: l_trx_rec RA_CUSTOMER_TRX%ROWTYPE;
1500:
1501: BEGIN
1502: IF PG_DEBUG in ('Y', 'C') THEN
1503: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Assignment_Status ()+');
1504: END IF;
1505:
1506: l_trh_rec.customer_trx_id := p_customer_trx_id;
1507: ARP_TRANSACTION_HISTORY_PKG.fetch_f_trx_id (l_trh_rec);

Line 1523: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Assignment_Status ()-');

1519: app_exception.raise_exception;
1520: END IF;
1521:
1522: IF PG_DEBUG in ('Y', 'C') THEN
1523: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Assignment_Status ()-');
1524: END IF;
1525:
1526: EXCEPTION
1527: WHEN NO_DATA_FOUND THEN

Line 1568: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_BR_Assignment ()+');

1564:
1565: BEGIN
1566:
1567: IF PG_DEBUG in ('Y', 'C') THEN
1568: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_BR_Assignment ()+');
1569: END IF;
1570:
1571:
1572: /*----------------------------------------------+

Line 1698: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_BR_Assignment ()-');

1694: END IF;
1695:
1696:
1697: IF PG_DEBUG in ('Y', 'C') THEN
1698: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_BR_Assignment ()-');
1699: END IF;
1700:
1701:
1702: EXCEPTION

Line 1705: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_VAL_PVT.Validate_BR_Assignment () ');

1701:
1702: EXCEPTION
1703: WHEN Others THEN
1704: IF PG_DEBUG in ('Y', 'C') THEN
1705: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_VAL_PVT.Validate_BR_Assignment () ');
1706: END IF;
1707: RAISE;
1708:
1709: END Validate_BR_Assignment;

Line 1713: END AR_BILLS_CREATION_VAL_PVT;

1709: END Validate_BR_Assignment;
1710:
1711:
1712:
1713: END AR_BILLS_CREATION_VAL_PVT;