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.7 2005/12/05 20:03:55 sgnagara 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 49: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Gl_Date ()-');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1191:
1192: BEGIN
1193:
1194: IF PG_DEBUG in ('Y', 'C') THEN
1195: arp_util.debug('AR_BILLS_CREATION_VAL_PVT.Validate_Update_BR_Header ()+');
1196: END IF;
1197:
1198: -- Validate GL Date
1199:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1711: END AR_BILLS_CREATION_VAL_PVT;

1707: END Validate_BR_Assignment;
1708:
1709:
1710:
1711: END AR_BILLS_CREATION_VAL_PVT;