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 APP_EXCEPTION

Line 45: app_exception.raise_exception;

41: END IF;
42: FND_MESSAGE.set_name ( 'AR', 'AR_INVALID_APP_GL_DATE' );
43: --Bug12734873
44: FND_MESSAGE.set_token('GL_DATE', fnd_date.date_to_chardate(p_gl_date, calendar_aware=> FND_DATE.calendar_aware_alt ));
45: app_exception.raise_exception;
46: END IF;
47: END IF;
48:
49: IF PG_DEBUG in ('Y', 'C') THEN

Line 110: app_exception.raise_exception;

106: arp_util.debug('Validate_Update_Maturity_Date: ' || 'Maturity Date parameter : ' || p_term_due_date);
107: arp_util.debug('Validate_Update_Maturity_Date: ' || 'Maturity Date of the BR : ' || l_trx_rec.term_due_date);
108: END IF;
109: FND_MESSAGE.set_name( 'AR','AR_BR_CANNOT_UPDATE_MAT_DATE');
110: app_exception.raise_exception;
111: END IF;
112:
113: IF trunc(p_term_due_date) <= trunc(SYSDATE)
114: THEN

Line 124: app_exception.raise_exception;

120: FND_MESSAGE.set_token ( 'ACTION', NULL);
121: --Bug12734873
122: FND_MESSAGE.set_token ( 'NEW_TRX_DATE', fnd_date.date_to_chardate(p_term_due_date, calendar_aware=> FND_DATE.calendar_aware_alt));
123: FND_MESSAGE.set_token ( 'OLD_TRX_DATE', fnd_date.date_to_chardate(trunc(sysdate), calendar_aware=> FND_DATE.calendar_aware_alt));
124: app_exception.raise_exception;
125: END IF;
126:
127: END IF;
128:

Line 188: app_exception.raise_exception;

184: arp_util.debug ('Validate_Batch_Source: ' || 'p_issue_date = ' || p_issue_date);
185: arp_util.debug ('Validate_Batch_Source: ' || 'status = ' || l_status);
186: END IF;
187: FND_MESSAGE.SET_NAME ('AR', 'AR_BR_INACTIVE_BATCH_SOURCE');
188: app_exception.raise_exception;
189: END IF;
190:
191:
192: /*----------------------------------------------+

Line 208: app_exception.raise_exception;

204: arp_util.debug('Validate_Batch_Source: ' || 'start_date = ' || l_start_date);
205: arp_util.debug('Validate_Batch_Source: ' || 'end_date = ' || l_end_date);
206: END IF;
207: FND_MESSAGE.SET_NAME ('AR', 'AR_BR_BAD_DATE_SOURCE');
208: app_exception.raise_exception;
209: END IF;
210:
211:
212: IF PG_DEBUG in ('Y', 'C') THEN

Line 225: app_exception.raise_exception;

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;
224: FND_MESSAGE.SET_NAME ('AR', 'AR_BR_INVALID_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() ');

Line 284: app_exception.raise_exception;

280: arp_util.debug ('Validate_Transaction_Type: ' || 'p_issue_date = ' || p_issue_date);
281: arp_util.debug ('Validate_Transaction_Type: ' || 'status = ' || l_status);
282: END IF;
283: FND_MESSAGE.SET_NAME ('AR', 'AR_BR_INACTIVE_TRX_TYPE');
284: app_exception.raise_exception;
285: END IF;
286:
287:
288: /*----------------------------------------------+

Line 304: app_exception.raise_exception;

300: arp_util.debug ('Validate_Transaction_Type: ' || 'start_date = ' || l_start_date);
301: arp_util.debug ('Validate_Transaction_Type: ' || 'end_date = ' || l_end_date);
302: END IF;
303: FND_MESSAGE.SET_NAME ('AR', 'AR_BR_BAD_DATE_TRX_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()-');

Line 320: app_exception.raise_exception;

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;
319: FND_MESSAGE.SET_NAME ('AR', 'AR_BR_INVALID_TRX_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() ');

Line 370: app_exception.raise_exception;

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');
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 () ');

Line 421: app_exception.raise_exception;

417: IF PG_DEBUG in ('Y', 'C') THEN
418: arp_util.debug('Validate_Drawee: ' || '>>>>>>>>>> Drawee Location Inactive');
419: END IF;
420: FND_MESSAGE.SET_NAME ('AR', 'AR_BR_INACTIVE_DRAWEE_SITE');
421: app_exception.raise_exception;
422: END IF;
423: END IF;
424:
425: IF PG_DEBUG in ('Y', 'C') THEN

Line 437: app_exception.raise_exception;

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');
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 () ');

Line 486: app_exception.raise_exception;

482: IF PG_DEBUG in ('Y', 'C') THEN
483: arp_util.debug('Validate_Drawee: ' || '>>>>>>>>>> Drawee Contact Inactive');
484: END IF;
485: FND_MESSAGE.SET_NAME ('AR', 'AR_BR_INACTIVE_DRAWEE_CONTACT');
486: app_exception.raise_exception;
487: END IF;
488:
489: END IF;
490:

Line 504: app_exception.raise_exception;

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;
503: FND_MESSAGE.SET_NAME ('AR', 'AR_BR_INVALID_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 () ');

Line 559: app_exception.raise_exception;

555: arp_util.debug('Validate_Drawee: ' || 'Issue Date : ' || p_issue_date);
556: arp_util.debug('Validate_Drawee: ' || 'Currency : ' || p_invoice_currency_code);
557: END IF;
558: FND_MESSAGE.SET_NAME ('AR', 'AR_BR_BAD_DATE_CURRENCY');
559: app_exception.raise_exception;
560: END IF;
561:
562:
563: IF PG_DEBUG in ('Y', 'C') THEN

Line 576: app_exception.raise_exception;

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;
575: FND_MESSAGE.SET_NAME ('AR', 'AR_BR_INVALID_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 () ');

Line 658: app_exception.raise_exception;

654: IF PG_DEBUG in ('Y', 'C') THEN
655: arp_util.debug('Validate_Drawee: ' || '>>>>>>>>>> Printing is mandatory');
656: END IF;
657: FND_MESSAGE.SET_NAME ('AR', 'AR_BR_PRINTING_MANDATORY');
658: app_exception.raise_exception;
659: END IF;
660:
661:
662: /*----------------------------------------------+

Line 673: app_exception.raise_exception;

669: IF PG_DEBUG in ('Y', 'C') THEN
670: arp_util.debug('Validate_Drawee: ' || '>>>>>>>>>> No format program id');
671: END IF;
672: FND_MESSAGE.SET_NAME ('AR', 'AR_BR_NO_PRINT_FORMAT');
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 ()-');

Line 689: app_exception.raise_exception;

685: END IF;
686: FND_MESSAGE.SET_NAME ('AR', 'AR_PROCEDURE_VALID_ARGS_FAIL');
687: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'Printing Option');
688: FND_MESSAGE.SET_TOKEN ('PROCEDURE', 'BR CREATION API');
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 () ');

Line 831: app_exception.raise_exception;

827: ' Multi Currency Flag : ' || l_receipt_multi_currency_flag);
828: END IF;
829:
830: fnd_message.set_name ('AR', 'AR_BR_INVALID_REMIT_CURRENCY');
831: app_exception.raise_exception;
832:
833: END IF;
834:
835:

Line 856: app_exception.raise_exception;

852: p_remit_bank_account_id);
853: END IF;
854:
855: fnd_message.set_name('AR', 'AR_BR_BAD_DATE_REMIT_ACCOUNT');
856: app_exception.raise_exception;
857:
858: END IF;
859:
860: END IF;

Line 877: app_exception.raise_exception;

873: arp_util.debug('Validate_Remit_Account: ' || ' p_issue_date = ' || p_issue_date);
874: END IF;
875:
876: fnd_message.set_name('AR', 'AR_BR_INVALID_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 () ');

Line 918: app_exception.raise_exception;

914: END IF;
915: FND_MESSAGE.SET_NAME ('AR', 'AR_PROCEDURE_VALID_ARGS_FAIL');
916: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'Override Remittance Flag');
917: FND_MESSAGE.SET_TOKEN ('PROCEDURE', 'BR CREATION API');
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 ()-');

Line 931: app_exception.raise_exception;

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:
933: END Validate_Override_Flag;
934:
935:

Line 976: app_exception.raise_exception;

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');
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 () ');

Line 1025: app_exception.raise_exception;

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');
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 () ');

Line 1073: app_exception.raise_exception;

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');
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 () ');

Line 1311: app_exception.raise_exception;

1307: arp_util.debug('Validate_Assigned_Amount: ' || '>>>>>>>>>> The amount of the assignment must not be null');
1308: arp_util.debug('Validate_Assigned_Amount: ' || ' Amount Assigned : ' || p_trl_rec.extended_amount);
1309: END IF;
1310: FND_MESSAGE.SET_NAME ('AR', 'AR_BR_INVALID_AMOUNT');
1311: app_exception.raise_exception;
1312: END IF;
1313:
1314:
1315: /*----------------------------------------------+

Line 1330: app_exception.raise_exception;

1326: arp_util.debug('Validate_Assigned_Amount: ' || ' Amount Remaining : ' || p_ps_rec.amount_due_remaining);
1327: END IF;
1328: FND_MESSAGE.SET_NAME ('AR', 'AR_BR_OVERAPPLY');
1329: FND_MESSAGE.SET_TOKEN ('TRXNUM', p_ps_rec.trx_number);
1330: app_exception.raise_exception;
1331: END IF;
1332:
1333:
1334: /*----------------------------------------------+

Line 1417: app_exception.raise_exception;

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');
1417: app_exception.raise_exception;
1418:
1419: WHEN OTHERS THEN
1420: IF PG_DEBUG in ('Y', 'C') THEN
1421: arp_util.debug('>>>>>>>>>> EXCEPTION : Is_Transaction_BR () ');

Line 1466: app_exception.raise_exception;

1462: IF PG_DEBUG in ('Y', 'C') THEN
1463: arp_util.debug ('Validate_BR_Status: ' || 'You cannot update the assignments when the BR has a status : ' || l_trh_rec.status);
1464: END IF;
1465: FND_MESSAGE.SET_NAME ('AR', 'AR_BR_ASSIGN_FORBIDDEN');
1466: app_exception.raise_exception;
1467: END IF;
1468:
1469:
1470: IF PG_DEBUG in ('Y', 'C') THEN

Line 1519: app_exception.raise_exception;

1515: arp_util.debug('Validate_Assignment_Status: ' || ' Event : ' || l_trh_rec.event);
1516: END IF;
1517: FND_MESSAGE.SET_NAME ('AR' , 'AR_BR_CANNOT_ASSIGN');
1518: FND_MESSAGE.set_token ('TRXNUM', p_trx_number);
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 ()-');

Line 1534: app_exception.raise_exception;

1530: arp_util.debug('Validate_Assignment_Status: ' || '>>>>>>>>>> Invalid BR ID');
1531: arp_util.debug('Validate_Assignment_Status: ' || ' Customer Trx ID : ' || p_customer_trx_id);
1532: END IF;
1533: FND_MESSAGE.SET_NAME ('AR', 'AR_BR_INVALID_BR_ID');
1534: app_exception.raise_exception;
1535:
1536: WHEN OTHERS THEN
1537: IF PG_DEBUG in ('Y', 'C') THEN
1538: arp_util.debug('>>>>>>>>>> EXCEPTION : Validate_Assignment_Status () ');

Line 1597: app_exception.raise_exception;

1593: IF PG_DEBUG in ('Y', 'C') THEN
1594: arp_util.debug ('Validate_BR_Assignment: ' || '>>>>>>>>>> Guarantee cannot be exchanged for BR');
1595: END IF;
1596: FND_MESSAGE.SET_NAME ('AR', 'AR_BR_INVALID_TRX_TYPE');
1597: app_exception.raise_exception;
1598:
1599: ELSIF (l_type = 'BR')
1600: THEN
1601:

Line 1623: app_exception.raise_exception;

1619: arp_util.debug ('Validate_BR_Assignment: ' || ' amount_due_remaining : ' || p_ps_rec.amount_due_remaining);
1620: END IF;
1621: FND_MESSAGE.SET_NAME ('AR', 'AR_BR_CANNOT_ASSIGN');
1622: FND_MESSAGE.SET_TOKEN ('TRXNUM', p_trx_rec.trx_number);
1623: app_exception.raise_exception;
1624: END IF;
1625:
1626:
1627: IF (p_trl_rec.extended_amount <> p_ps_rec.amount_due_original)

Line 1637: app_exception.raise_exception;

1633: arp_util.debug ('Validate_BR_Assignment: ' || ' amount_due_original : ' || p_ps_rec.amount_due_original);
1634: END IF;
1635: FND_MESSAGE.SET_NAME ('AR', 'AR_BR_CANNOT_ASSIGN');
1636: FND_MESSAGE.SET_TOKEN ('TRXNUM', p_trx_rec.trx_number);
1637: app_exception.raise_exception;
1638: END IF;
1639:
1640: END IF;
1641:

Line 1655: app_exception.raise_exception;

1651: arp_util.debug ('Validate_BR_Assignment: ' || 'The transaction ' || p_trx_rec.trx_number || ' is reserved, it cannot be assigned');
1652: END IF;
1653: FND_MESSAGE.SET_NAME ('AR', 'AR_BR_TRX_ALREADY_ASSIGN');
1654: FND_MESSAGE.SET_TOKEN ('TRXNUM', p_trx_rec.trx_number);
1655: app_exception.raise_exception;
1656: END IF;
1657:
1658:
1659: /*----------------------------------------------+