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 845: APP_EXCEPTION.raise_exception;

841: ELSIF (p_remit_total_low IS NULL) OR
842: (p_remit_total_high IS NULL) OR
843: (p_remit_total_high < p_remit_total_low) THEN
844: FND_MESSAGE.set_name('AR','AR_BR_BAD_PARAM_REMIT_AMOUNT');
845: APP_EXCEPTION.raise_exception;
846: END IF;
847:
848: -- maturity date
849: IF (p_maturity_date_low IS NULL) AND (p_maturity_date_high IS NULL) THEN

Line 857: APP_EXCEPTION.raise_exception;

853: ELSIF (p_maturity_date_low IS NULL) OR
854: (p_maturity_date_high IS NULL) OR
855: (p_maturity_date_high < p_maturity_date_low) THEN
856: FND_MESSAGE.set_name('AR','AR_BR_BAD_PARAM_BR_DUE_DATE');
857: APP_EXCEPTION.raise_exception;
858: END IF;
859:
860: -- BR number
861: IF (p_br_number_low IS NULL) AND (p_br_number_high IS NULL) THEN

Line 869: APP_EXCEPTION.raise_exception;

865: ELSIF (p_br_number_low IS NULL) OR
866: (p_br_number_high IS NULL) OR
867: (p_br_number_high < p_br_number_low) THEN
868: FND_MESSAGE.set_name('AR','AR_BR_BAD_PARAM_BR_NUMBER');
869: APP_EXCEPTION.raise_exception;
870: END IF;
871:
872: -- BR amount
873: IF (p_br_amount_low IS NULL) AND (p_br_amount_high IS NULL) THEN

Line 881: APP_EXCEPTION.raise_exception;

877: ELSIF (p_br_amount_low IS NULL) OR
878: (p_br_amount_high IS NULL) OR
879: (p_br_amount_high < p_br_amount_low) THEN
880: FND_MESSAGE.set_name('AR','AR_BR_BAD_PARAM_BR_AMOUNT');
881: APP_EXCEPTION.raise_exception;
882: END IF;
883:
884: -- Drawee number
885: IF (p_drawee_number_low IS NULL) AND (p_drawee_number_high IS NULL) THEN

Line 893: APP_EXCEPTION.raise_exception;

889: ELSIF (p_drawee_number_low IS NULL) OR
890: (p_drawee_number_high IS NULL) OR
891: (p_drawee_number_high < p_drawee_number_low) THEN
892: FND_MESSAGE.set_name('AR','AR_BR_BAD_PARAM_DRAWEE_NUMBER');
893: APP_EXCEPTION.raise_exception;
894: END IF;
895:
896: -- parameter unsigned_flag
897: IF (NVL(p_unsigned_flag,'T') NOT IN ('Y','N')) THEN

Line 902: APP_EXCEPTION.raise_exception;

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

Line 911: APP_EXCEPTION.raise_exception;

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

Line 920: APP_EXCEPTION.raise_exception;

916: l_field := 'p_drawee_issued_flag';
917: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
918: FND_MESSAGE.set_token('PROCEDURE','validate_br_search_criteria');
919: FND_MESSAGE.set_token('PARAMETER', l_field);
920: APP_EXCEPTION.raise_exception;
921: END IF;
922:
923: -- parameter include_unpaid_flag
924: IF (NVL(p_include_unpaid_flag,'T') NOT IN ('Y','N')) THEN

Line 929: APP_EXCEPTION.raise_exception;

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

Line 938: APP_EXCEPTION.raise_exception;

934: l_field := 'p_br_order';
935: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
936: FND_MESSAGE.set_token('PROCEDURE','validate_br_search_criteria');
937: FND_MESSAGE.set_token('PARAMETER', l_field);
938: APP_EXCEPTION.raise_exception;
939: END IF;
940:
941: -- parameter drawee_order
942: IF (NVL(p_drawee_order,'T') NOT IN ('ASC','DESC')) THEN

Line 947: APP_EXCEPTION.raise_exception;

943: l_field := 'p_drawee_order';
944: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
945: FND_MESSAGE.set_token('PROCEDURE','validate_br_search_criteria');
946: FND_MESSAGE.set_token('PARAMETER', l_field);
947: APP_EXCEPTION.raise_exception;
948: END IF;
949:
950: -- parameter BR sort criteria
951: IF p_br_sort_criteria IS NULL THEN

Line 962: APP_EXCEPTION.raise_exception;

958: l_field := 'p_br_sort_criteria';
959: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
960: FND_MESSAGE.set_token('PROCEDURE','validate_br_search_criteria');
961: FND_MESSAGE.set_token('PARAMETER', l_field);
962: APP_EXCEPTION.raise_exception;
963: END IF;
964:
965: -- parameter drawee sort criteria
966: IF p_drawee_sort_criteria IS NULL THEN

Line 983: APP_EXCEPTION.raise_exception;

979: l_field := 'p_drawee_sort_criteria';
980: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
981: FND_MESSAGE.set_token('PROCEDURE','validate_br_search_criteria');
982: FND_MESSAGE.set_token('PARAMETER', l_field);
983: APP_EXCEPTION.raise_exception;
984: END IF;
985:
986: IF PG_DEBUG in ('Y', 'C') THEN
987: arp_util.debug('create_remit_batch: ' || 'ARP_PROCESS_BR_REMIT.validate_br_search_criteria (-)');

Line 1212: APP_EXCEPTION.raise_exception;

1208: l_field := 'p_action_flag';
1209: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1210: FND_MESSAGE.set_token('PROCEDURE','add_or_rm_br_to_remit');
1211: FND_MESSAGE.set_token('PARAMETER', l_field);
1212: APP_EXCEPTION.raise_exception;
1213: END IF;
1214:
1215: -- the batch id isn't NULL ??
1216: IF (p_batch_id IS NULL) THEN

Line 1221: APP_EXCEPTION.raise_exception;

1217: l_field := 'p_batch_id';
1218: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1219: FND_MESSAGE.set_token('PROCEDURE','add_or_rm_br_to_remit');
1220: FND_MESSAGE.set_token('PARAMETER', l_field);
1221: APP_EXCEPTION.raise_exception;
1222: END IF;
1223:
1224: -- fetch the remittance batch row
1225: ARP_CR_BATCHES_PKG.fetch_p(p_batch_id,l_batch_rec);

Line 1232: APP_EXCEPTION.raise_exception;

1228:
1229: -- The remittance has been approved; no changes are allowed
1230: IF (l_batch_rec.batch_applied_status NOT IN ('STARTED_CREATION','COMPLETED_CREATION','STARTED_APPROVAL')) THEN
1231: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_UPDATE_REMIT');
1232: APP_EXCEPTION.raise_exception;
1233: END IF;
1234:
1235: -- the payment schedule isn't NULL ??
1236: IF (p_ps_id IS NULL) THEN

Line 1241: APP_EXCEPTION.raise_exception;

1237: l_field := 'p_ps_id';
1238: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1239: FND_MESSAGE.set_token('PROCEDURE','add_or_rm_br_to_remit');
1240: FND_MESSAGE.set_token('PARAMETER', l_field);
1241: APP_EXCEPTION.raise_exception;
1242: END IF;
1243:
1244: -- fetch the assigned trx payment schedule row
1245: ARP_PS_PKG.fetch_p(p_ps_id,l_ps_rec);

Line 1427: APP_EXCEPTION.raise_exception;

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

Line 1436: APP_EXCEPTION.raise_exception;

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

Line 1444: APP_EXCEPTION.raise_exception;

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

Line 1452: APP_EXCEPTION.raise_exception;

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

Line 1460: APP_EXCEPTION.raise_exception;

1456: l_field := 'p_cancel_flag';
1457: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1458: FND_MESSAGE.set_token('PROCEDURE','create_remit_batch_conc_req');
1459: FND_MESSAGE.set_token('PARAMETER', l_field);
1460: APP_EXCEPTION.raise_exception;
1461: END IF;
1462:
1463: IF p_print_bills_flag NOT IN ('Y','N') THEN
1464: l_field := 'p_print_bills_flag';

Line 1468: APP_EXCEPTION.raise_exception;

1464: l_field := 'p_print_bills_flag';
1465: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1466: FND_MESSAGE.set_token('PROCEDURE','create_remit_batch_conc_req');
1467: FND_MESSAGE.set_token('PARAMETER', l_field);
1468: APP_EXCEPTION.raise_exception;
1469: END IF;
1470:
1471: select org_id into l_org_id
1472: from ar_system_parameters;

Line 1525: APP_EXCEPTION.raise_exception;

1521:
1522: IF (l_request_id = 0) THEN
1523: FND_MESSAGE.set_name('AR','AR_BR_BATCH_SUBMIT_FAILED');
1524: FND_MESSAGE.set_token('PROCEDURE','ARP_PROCESS_BR_REMIT.create_remit_batch_conc_req');
1525: APP_EXCEPTION.raise_exception;
1526: ELSE
1527: IF PG_DEBUG in ('Y', 'C') THEN
1528: arp_util.debug('create_remit_batch: ' || 'Submitted Request - '||l_program||'. Request ID ='||to_char(l_request_id));
1529: END IF;

Line 1657: APP_EXCEPTION.raise_exception;

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

Line 1665: APP_EXCEPTION.raise_exception;

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

Line 1673: APP_EXCEPTION.raise_exception;

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

Line 1681: APP_EXCEPTION.raise_exception;

1677: l_field := 'p_cancel_flag';
1678: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1679: FND_MESSAGE.set_token('PROCEDURE','maintain_remit_batch_conc_req');
1680: FND_MESSAGE.set_token('PARAMETER', l_field);
1681: APP_EXCEPTION.raise_exception;
1682: END IF;
1683:
1684: IF p_print_bills_flag NOT IN ('Y','N') THEN
1685: l_field := 'p_print_bills_flag';

Line 1689: APP_EXCEPTION.raise_exception;

1685: l_field := 'p_print_bills_flag';
1686: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1687: FND_MESSAGE.set_token('PROCEDURE','maintain_remit_batch_conc_req');
1688: FND_MESSAGE.set_token('PARAMETER', l_field);
1689: APP_EXCEPTION.raise_exception;
1690: END IF;
1691:
1692: --MOAC changes
1693: select org_id into l_org_id

Line 1702: APP_EXCEPTION.raise_exception;

1698:
1699: -- Validation
1700: IF (p_cancel_flag = 'Y') AND (l_batch_rec.batch_applied_status NOT IN ('STARTED_CREATION','COMPLETED_CREATION','STARTED_APPROVAL','STARTED_CANCELLATION')) THEN
1701: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_CANCEL_REMIT');
1702: APP_EXCEPTION.raise_exception;
1703: END IF;
1704:
1705: IF (p_approve_flag = 'Y') AND (l_batch_rec.batch_applied_status NOT IN ('STARTED_CREATION','COMPLETED_CREATION','STARTED_APPROVAL')) THEN
1706: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_APPROVE_REMIT');

Line 1707: APP_EXCEPTION.raise_exception;

1703: END IF;
1704:
1705: IF (p_approve_flag = 'Y') AND (l_batch_rec.batch_applied_status NOT IN ('STARTED_CREATION','COMPLETED_CREATION','STARTED_APPROVAL')) THEN
1706: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_APPROVE_REMIT');
1707: APP_EXCEPTION.raise_exception;
1708: END IF;
1709:
1710: --MOAC changes
1711: FND_REQUEST.SET_ORG_ID(l_org_id);

Line 1759: APP_EXCEPTION.raise_exception;

1755:
1756: IF (l_request_id = 0) THEN
1757: FND_MESSAGE.set_name('AR','AR_BR_BATCH_SUBMIT_FAILED');
1758: FND_MESSAGE.set_token('PROCEDURE','ARP_PROCESS_BR_REMIT.maintain_remit_batch_conc_req');
1759: APP_EXCEPTION.raise_exception;
1760: ELSE
1761: IF PG_DEBUG in ('Y', 'C') THEN
1762: arp_util.debug('maintain_remit_batch_conc_req: ' || 'Submitted Request - '||l_program||'. Request ID ='||to_char(l_request_id));
1763: END IF;