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_PROCESS_BR_REMIT dependencies on APP_EXCEPTION

Line 270: APP_EXCEPTION.raise_exception;

266: END IF;
267: ELSE
268: -- NO BR have been selected -> the remittance batch row isn't inserted in the table AR_BATCHES
269: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_CREATE_REMIT');
270: APP_EXCEPTION.raise_exception;
271: END IF;
272:
273: p_batch_id := l_batch_id;
274: p_batch_name := l_batch_name;

Line 433: APP_EXCEPTION.raise_exception;

429:
430: -- The action Create is enabled only if the batch status is STARTED_CREATION
431: IF l_batch_rec.batch_applied_status NOT IN ('STARTED_CREATION') THEN
432: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_RECREATE_REMIT');
433: APP_EXCEPTION.raise_exception;
434: END IF;
435:
436: -- BR search criteria validation
437: ARP_PROCESS_BR_REMIT.validate_br_search_criteria(

Line 834: APP_EXCEPTION.raise_exception;

830: ELSIF (p_remit_total_low IS NULL) OR
831: (p_remit_total_high IS NULL) OR
832: (p_remit_total_high < p_remit_total_low) THEN
833: FND_MESSAGE.set_name('AR','AR_BR_BAD_PARAM_REMIT_AMOUNT');
834: APP_EXCEPTION.raise_exception;
835: END IF;
836:
837: -- maturity date
838: IF (p_maturity_date_low IS NULL) AND (p_maturity_date_high IS NULL) THEN

Line 846: APP_EXCEPTION.raise_exception;

842: ELSIF (p_maturity_date_low IS NULL) OR
843: (p_maturity_date_high IS NULL) OR
844: (p_maturity_date_high < p_maturity_date_low) THEN
845: FND_MESSAGE.set_name('AR','AR_BR_BAD_PARAM_BR_DUE_DATE');
846: APP_EXCEPTION.raise_exception;
847: END IF;
848:
849: -- BR number
850: IF (p_br_number_low IS NULL) AND (p_br_number_high IS NULL) THEN

Line 858: APP_EXCEPTION.raise_exception;

854: ELSIF (p_br_number_low IS NULL) OR
855: (p_br_number_high IS NULL) OR
856: (p_br_number_high < p_br_number_low) THEN
857: FND_MESSAGE.set_name('AR','AR_BR_BAD_PARAM_BR_NUMBER');
858: APP_EXCEPTION.raise_exception;
859: END IF;
860:
861: -- BR amount
862: IF (p_br_amount_low IS NULL) AND (p_br_amount_high IS NULL) THEN

Line 870: APP_EXCEPTION.raise_exception;

866: ELSIF (p_br_amount_low IS NULL) OR
867: (p_br_amount_high IS NULL) OR
868: (p_br_amount_high < p_br_amount_low) THEN
869: FND_MESSAGE.set_name('AR','AR_BR_BAD_PARAM_BR_AMOUNT');
870: APP_EXCEPTION.raise_exception;
871: END IF;
872:
873: -- Drawee number
874: IF (p_drawee_number_low IS NULL) AND (p_drawee_number_high IS NULL) THEN

Line 882: APP_EXCEPTION.raise_exception;

878: ELSIF (p_drawee_number_low IS NULL) OR
879: (p_drawee_number_high IS NULL) OR
880: (p_drawee_number_high < p_drawee_number_low) THEN
881: FND_MESSAGE.set_name('AR','AR_BR_BAD_PARAM_DRAWEE_NUMBER');
882: APP_EXCEPTION.raise_exception;
883: END IF;
884:
885: -- parameter unsigned_flag
886: IF (NVL(p_unsigned_flag,'T') NOT IN ('Y','N')) THEN

Line 891: APP_EXCEPTION.raise_exception;

887: l_field := 'p_unsigned_flag';
888: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
889: FND_MESSAGE.set_token('PROCEDURE','validate_br_search_criteria');
890: FND_MESSAGE.set_token('PARAMETER', l_field);
891: APP_EXCEPTION.raise_exception;
892: END IF;
893:
894: -- parameter signed_flag
895: IF (NVL(p_signed_flag,'T') NOT IN ('Y','N')) THEN

Line 900: APP_EXCEPTION.raise_exception;

896: l_field := 'p_signed_flag';
897: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
898: FND_MESSAGE.set_token('PROCEDURE','validate_br_search_criteria');
899: FND_MESSAGE.set_token('PARAMETER', l_field);
900: APP_EXCEPTION.raise_exception;
901: END IF;
902:
903: -- parameter drawee_issued_flag
904: IF (NVL(p_drawee_issued_flag,'T') NOT IN ('Y','N')) THEN

Line 909: APP_EXCEPTION.raise_exception;

905: l_field := 'p_drawee_issued_flag';
906: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
907: FND_MESSAGE.set_token('PROCEDURE','validate_br_search_criteria');
908: FND_MESSAGE.set_token('PARAMETER', l_field);
909: APP_EXCEPTION.raise_exception;
910: END IF;
911:
912: -- parameter include_unpaid_flag
913: IF (NVL(p_include_unpaid_flag,'T') NOT IN ('Y','N')) THEN

Line 918: APP_EXCEPTION.raise_exception;

914: l_field := 'p_include_unpaid_flag';
915: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
916: FND_MESSAGE.set_token('PROCEDURE','validate_br_search_criteria');
917: FND_MESSAGE.set_token('PARAMETER', l_field);
918: APP_EXCEPTION.raise_exception;
919: END IF;
920:
921: -- parameter br_order
922: IF (NVL(p_br_order,'T') NOT IN ('ASC','DESC')) THEN

Line 927: APP_EXCEPTION.raise_exception;

923: l_field := 'p_br_order';
924: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
925: FND_MESSAGE.set_token('PROCEDURE','validate_br_search_criteria');
926: FND_MESSAGE.set_token('PARAMETER', l_field);
927: APP_EXCEPTION.raise_exception;
928: END IF;
929:
930: -- parameter drawee_order
931: IF (NVL(p_drawee_order,'T') NOT IN ('ASC','DESC')) THEN

Line 936: APP_EXCEPTION.raise_exception;

932: l_field := 'p_drawee_order';
933: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
934: FND_MESSAGE.set_token('PROCEDURE','validate_br_search_criteria');
935: FND_MESSAGE.set_token('PARAMETER', l_field);
936: APP_EXCEPTION.raise_exception;
937: END IF;
938:
939: -- parameter BR sort criteria
940: IF p_br_sort_criteria IS NULL THEN

Line 951: APP_EXCEPTION.raise_exception;

947: l_field := 'p_br_sort_criteria';
948: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
949: FND_MESSAGE.set_token('PROCEDURE','validate_br_search_criteria');
950: FND_MESSAGE.set_token('PARAMETER', l_field);
951: APP_EXCEPTION.raise_exception;
952: END IF;
953:
954: -- parameter drawee sort criteria
955: IF p_drawee_sort_criteria IS NULL THEN

Line 972: APP_EXCEPTION.raise_exception;

968: l_field := 'p_drawee_sort_criteria';
969: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
970: FND_MESSAGE.set_token('PROCEDURE','validate_br_search_criteria');
971: FND_MESSAGE.set_token('PARAMETER', l_field);
972: APP_EXCEPTION.raise_exception;
973: END IF;
974:
975: IF PG_DEBUG in ('Y', 'C') THEN
976: arp_util.debug('create_remit_batch: ' || 'ARP_PROCESS_BR_REMIT.validate_br_search_criteria (-)');

Line 1201: APP_EXCEPTION.raise_exception;

1197: l_field := 'p_action_flag';
1198: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1199: FND_MESSAGE.set_token('PROCEDURE','add_or_rm_br_to_remit');
1200: FND_MESSAGE.set_token('PARAMETER', l_field);
1201: APP_EXCEPTION.raise_exception;
1202: END IF;
1203:
1204: -- the batch id isn't NULL ??
1205: IF (p_batch_id IS NULL) THEN

Line 1210: APP_EXCEPTION.raise_exception;

1206: l_field := 'p_batch_id';
1207: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1208: FND_MESSAGE.set_token('PROCEDURE','add_or_rm_br_to_remit');
1209: FND_MESSAGE.set_token('PARAMETER', l_field);
1210: APP_EXCEPTION.raise_exception;
1211: END IF;
1212:
1213: -- fetch the remittance batch row
1214: ARP_CR_BATCHES_PKG.fetch_p(p_batch_id,l_batch_rec);

Line 1221: APP_EXCEPTION.raise_exception;

1217:
1218: -- The remittance has been approved; no changes are allowed
1219: IF (l_batch_rec.batch_applied_status NOT IN ('STARTED_CREATION','COMPLETED_CREATION','STARTED_APPROVAL')) THEN
1220: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_UPDATE_REMIT');
1221: APP_EXCEPTION.raise_exception;
1222: END IF;
1223:
1224: -- the payment schedule isn't NULL ??
1225: IF (p_ps_id IS NULL) THEN

Line 1230: APP_EXCEPTION.raise_exception;

1226: l_field := 'p_ps_id';
1227: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1228: FND_MESSAGE.set_token('PROCEDURE','add_or_rm_br_to_remit');
1229: FND_MESSAGE.set_token('PARAMETER', l_field);
1230: APP_EXCEPTION.raise_exception;
1231: END IF;
1232:
1233: -- fetch the assigned trx payment schedule row
1234: ARP_PS_PKG.fetch_p(p_ps_id,l_ps_rec);

Line 1416: APP_EXCEPTION.raise_exception;

1412: l_field := 'p_create_flag';
1413: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1414: FND_MESSAGE.set_token('PROCEDURE','create_remit_batch_conc_req');
1415: FND_MESSAGE.set_token('PARAMETER', l_field);
1416: APP_EXCEPTION.raise_exception;
1417: END IF;
1418:
1419:
1420: IF p_approve_flag NOT IN ('Y','N') THEN

Line 1425: APP_EXCEPTION.raise_exception;

1421: l_field := 'p_approve_flag';
1422: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1423: FND_MESSAGE.set_token('PROCEDURE','create_remit_batch_conc_req');
1424: FND_MESSAGE.set_token('PARAMETER', l_field);
1425: APP_EXCEPTION.raise_exception;
1426: END IF;
1427:
1428: IF p_format_flag NOT IN ('Y','N') THEN
1429: l_field := 'p_format_flag';

Line 1433: APP_EXCEPTION.raise_exception;

1429: l_field := 'p_format_flag';
1430: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1431: FND_MESSAGE.set_token('PROCEDURE','create_remit_batch_conc_req');
1432: FND_MESSAGE.set_token('PARAMETER', l_field);
1433: APP_EXCEPTION.raise_exception;
1434: END IF;
1435:
1436: IF p_print_flag NOT IN ('Y','N') THEN
1437: l_field := 'p_print_flag';

Line 1441: APP_EXCEPTION.raise_exception;

1437: l_field := 'p_print_flag';
1438: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1439: FND_MESSAGE.set_token('PROCEDURE','create_remit_batch_conc_req');
1440: FND_MESSAGE.set_token('PARAMETER', l_field);
1441: APP_EXCEPTION.raise_exception;
1442: END IF;
1443:
1444: IF p_cancel_flag NOT IN ('Y','N') THEN
1445: l_field := 'p_cancel_flag';

Line 1449: APP_EXCEPTION.raise_exception;

1445: l_field := 'p_cancel_flag';
1446: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1447: FND_MESSAGE.set_token('PROCEDURE','create_remit_batch_conc_req');
1448: FND_MESSAGE.set_token('PARAMETER', l_field);
1449: APP_EXCEPTION.raise_exception;
1450: END IF;
1451:
1452: IF p_print_bills_flag NOT IN ('Y','N') THEN
1453: l_field := 'p_print_bills_flag';

Line 1457: APP_EXCEPTION.raise_exception;

1453: l_field := 'p_print_bills_flag';
1454: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1455: FND_MESSAGE.set_token('PROCEDURE','create_remit_batch_conc_req');
1456: FND_MESSAGE.set_token('PARAMETER', l_field);
1457: APP_EXCEPTION.raise_exception;
1458: END IF;
1459:
1460: select org_id into l_org_id
1461: from ar_system_parameters;

Line 1514: APP_EXCEPTION.raise_exception;

1510:
1511: IF (l_request_id = 0) THEN
1512: FND_MESSAGE.set_name('AR','AR_BR_BATCH_SUBMIT_FAILED');
1513: FND_MESSAGE.set_token('PROCEDURE','ARP_PROCESS_BR_REMIT.create_remit_batch_conc_req');
1514: APP_EXCEPTION.raise_exception;
1515: ELSE
1516: IF PG_DEBUG in ('Y', 'C') THEN
1517: arp_util.debug('create_remit_batch: ' || 'Submitted Request - '||l_program||'. Request ID ='||to_char(l_request_id));
1518: END IF;

Line 1646: APP_EXCEPTION.raise_exception;

1642: l_field := 'p_approve_flag';
1643: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1644: FND_MESSAGE.set_token('PROCEDURE','maintain_remit_batch_conc_req');
1645: FND_MESSAGE.set_token('PARAMETER', l_field);
1646: APP_EXCEPTION.raise_exception;
1647: END IF;
1648:
1649: IF p_format_flag NOT IN ('Y','N') THEN
1650: l_field := 'p_format_flag';

Line 1654: APP_EXCEPTION.raise_exception;

1650: l_field := 'p_format_flag';
1651: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1652: FND_MESSAGE.set_token('PROCEDURE','maintain_remit_batch_conc_req');
1653: FND_MESSAGE.set_token('PARAMETER', l_field);
1654: APP_EXCEPTION.raise_exception;
1655: END IF;
1656:
1657: IF p_print_flag NOT IN ('Y','N') THEN
1658: l_field := 'p_print_flag';

Line 1662: APP_EXCEPTION.raise_exception;

1658: l_field := 'p_print_flag';
1659: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1660: FND_MESSAGE.set_token('PROCEDURE','maintain_remit_batch_conc_req');
1661: FND_MESSAGE.set_token('PARAMETER', l_field);
1662: APP_EXCEPTION.raise_exception;
1663: END IF;
1664:
1665: IF p_cancel_flag NOT IN ('Y','N') THEN
1666: l_field := 'p_cancel_flag';

Line 1670: APP_EXCEPTION.raise_exception;

1666: l_field := 'p_cancel_flag';
1667: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1668: FND_MESSAGE.set_token('PROCEDURE','maintain_remit_batch_conc_req');
1669: FND_MESSAGE.set_token('PARAMETER', l_field);
1670: APP_EXCEPTION.raise_exception;
1671: END IF;
1672:
1673: IF p_print_bills_flag NOT IN ('Y','N') THEN
1674: l_field := 'p_print_bills_flag';

Line 1678: APP_EXCEPTION.raise_exception;

1674: l_field := 'p_print_bills_flag';
1675: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1676: FND_MESSAGE.set_token('PROCEDURE','maintain_remit_batch_conc_req');
1677: FND_MESSAGE.set_token('PARAMETER', l_field);
1678: APP_EXCEPTION.raise_exception;
1679: END IF;
1680:
1681: --MOAC changes
1682: select org_id into l_org_id

Line 1691: APP_EXCEPTION.raise_exception;

1687:
1688: -- Validation
1689: IF (p_cancel_flag = 'Y') AND (l_batch_rec.batch_applied_status NOT IN ('STARTED_CREATION','COMPLETED_CREATION','STARTED_APPROVAL','STARTED_CANCELLATION')) THEN
1690: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_CANCEL_REMIT');
1691: APP_EXCEPTION.raise_exception;
1692: END IF;
1693:
1694: IF (p_approve_flag = 'Y') AND (l_batch_rec.batch_applied_status NOT IN ('STARTED_CREATION','COMPLETED_CREATION','STARTED_APPROVAL')) THEN
1695: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_APPROVE_REMIT');

Line 1696: APP_EXCEPTION.raise_exception;

1692: END IF;
1693:
1694: IF (p_approve_flag = 'Y') AND (l_batch_rec.batch_applied_status NOT IN ('STARTED_CREATION','COMPLETED_CREATION','STARTED_APPROVAL')) THEN
1695: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_APPROVE_REMIT');
1696: APP_EXCEPTION.raise_exception;
1697: END IF;
1698:
1699: --MOAC changes
1700: FND_REQUEST.SET_ORG_ID(l_org_id);

Line 1748: APP_EXCEPTION.raise_exception;

1744:
1745: IF (l_request_id = 0) THEN
1746: FND_MESSAGE.set_name('AR','AR_BR_BATCH_SUBMIT_FAILED');
1747: FND_MESSAGE.set_token('PROCEDURE','ARP_PROCESS_BR_REMIT.maintain_remit_batch_conc_req');
1748: APP_EXCEPTION.raise_exception;
1749: ELSE
1750: IF PG_DEBUG in ('Y', 'C') THEN
1751: arp_util.debug('maintain_remit_batch_conc_req: ' || 'Submitted Request - '||l_program||'. Request ID ='||to_char(l_request_id));
1752: END IF;