DBA Data[Home] [Help]

APPS.ARP_BR_REMIT_BATCHES dependencies on APP_EXCEPTION

Line 152: APP_EXCEPTION.raise_exception;

148:
149: -- Check that the Batch source is valid
150: IF (SQL%ROWCOUNT = 0) THEN
151: FND_MESSAGE.set_name('AR','AR_UPDNA_LAST_BATCH_NO');
152: APP_EXCEPTION.raise_exception;
153: END IF;
154:
155: SELECT NVL(last_batch_num,0)
156: INTO l_batch_rec.name

Line 249: APP_EXCEPTION.raise_exception;

245: IF (l_field IS NOT NULL) THEN
246: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
247: FND_MESSAGE.set_token('PROCEDURE','validate_args_insert_remit');
248: FND_MESSAGE.set_token('PARAMETER', l_field);
249: APP_EXCEPTION.raise_exception;
250: END IF;
251:
252: -- Check that the Batch Name is unique for the batch source
253: arp_rw_batches_check_pkg.check_unique_batch_name(l_row_id,

Line 342: APP_EXCEPTION.raise_exception;

338: AND p_batch_date BETWEEN NVL(start_date_active,p_batch_date) and NVL(end_date_active,p_batch_date);
339:
340: IF (NB = 0) THEN
341: FND_MESSAGE.set_name('AR','AR_BR_INVALID_CURRENCY');
342: APP_EXCEPTION.raise_exception;
343: END IF;
344:
345: IF PG_DEBUG in ('Y', 'C') THEN
346: arp_util.debug('ARP_BR_REMIT_BATCHES.validate_currency_code (-)');

Line 423: APP_EXCEPTION.raise_exception;

419: FETCH Receipt_method INTO l_receipt_inherit_inv_num_flag, l_receipt_name;
420:
421: IF (Receipt_method%NOTFOUND) THEN
422: FND_MESSAGE.set_name('AR','AR_BR_INVALID_RECEIPT_METHOD');
423: APP_EXCEPTION.raise_exception;
424: END IF;
425:
426: CLOSE Receipt_method;
427:

Line 464: APP_EXCEPTION.raise_exception;

460: give the standard information. */
461:
462: IF (l_doc_seq_ret_stat = -2) THEN
463: FND_MESSAGE.set_name('AR','AR_RAPI_DOC_SEQ_NOT_EXIST_P');
464: APP_EXCEPTION.raise_exception;
465: END IF;
466:
467: IF PG_DEBUG in ('Y', 'C') THEN
468: arp_util.debug('ARP_BR_REMIT_BATCHES.validate_receipt_method (-)');

Line 540: APP_EXCEPTION.raise_exception;

536: AND p_batch_date BETWEEN p_batch_date and NVL(end_date,p_batch_date);
537:
538: IF (NB = 0) THEN
539: FND_MESSAGE.set_name('AR','AR_BR_INVALID_REMIT_BRANCH');
540: APP_EXCEPTION.raise_exception;
541: END IF;
542:
543: IF PG_DEBUG in ('Y', 'C') THEN
544: arp_util.debug('ARP_BR_REMIT_BATCHES.validate_remit_bank_branch (-)');

Line 604: APP_EXCEPTION.raise_exception;

600: CLOSE accounts;
601:
602: IF (NB = 0) THEN
603: FND_MESSAGE.set_name('AR','AR_BR_INVALID_REMIT_ACCOUNT');
604: APP_EXCEPTION.raise_exception;
605: END IF;
606:
607: IF PG_DEBUG in ('Y', 'C') THEN
608: arp_util.debug('ARP_BR_REMIT_BATCHES.validate_remit_bank_account (-)');

Line 655: APP_EXCEPTION.raise_exception;

651:
652: -- the with recourse flag must be 'N' with the remittance method Standard
653: IF (p_remit_method_code = 'STANDARD' AND p_with_recourse_flag = 'Y') THEN
654: FND_MESSAGE.set_name('AR','AR_BR_INVALID_REMIT_METHOD');
655: APP_EXCEPTION.raise_exception;
656: END IF;
657:
658: IF PG_DEBUG in ('Y', 'C') THEN
659: arp_util.debug('ARP_BR_REMIT_BATCHES.validate_remit_method_code (-)');

Line 714: APP_EXCEPTION.raise_exception;

710: AND program_type like 'REMIT_TRANSMIT';
711:
712: IF (NB = 0) THEN
713: FND_MESSAGE.set_name('AR','AR_BR_INVALID_REMIT_PROGRAM');
714: APP_EXCEPTION.raise_exception;
715: END IF;
716:
717: END IF;
718:

Line 805: APP_EXCEPTION.raise_exception;

801: l_field := 'P_BATCH_ID';
802: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
803: FND_MESSAGE.set_token('PROCEDURE','batch id');
804: FND_MESSAGE.set_token('PARAMETER', l_field);
805: APP_EXCEPTION.raise_exception;
806: END IF;
807:
808: -- fetch and lock of the batch row
809: l_batch_rec.batch_id := p_batch_id;

Line 928: APP_EXCEPTION.raise_exception;

924: IF (l_field IS NOT NULL) THEN
925: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
926: FND_MESSAGE.set_token('PROCEDURE','validate_args_insert_remit');
927: FND_MESSAGE.set_token('PARAMETER', l_field);
928: APP_EXCEPTION.raise_exception;
929: END IF;
930:
931: -- Check that the gl date is valid
932: arp_util.validate_gl_date(p_batch_rec.gl_date, NULL, NULL);

Line 1319: APP_EXCEPTION.raise_exception;

1315: IF PG_DEBUG in ('Y', 'C') THEN
1316: arp_standard.debug('update_br_remit_batch_to_crh: ' || 'current receipt history record cannot be found cr_id = '||to_char(p_cr_id));
1317: END IF;
1318: CLOSE receipt_cur;
1319: APP_EXCEPTION.raise_exception;
1320:
1321: END IF;
1322:
1323: CLOSE receipt_cur;