DBA Data[Home] [Help]

APPS.ARP_BR_REMIT_BATCHES dependencies on FND_MESSAGE

Line 151: FND_MESSAGE.set_name('AR','AR_UPDNA_LAST_BATCH_NO');

147: WHERE batch_source_id = l_batch_rec.batch_source_id;
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)

Line 246: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');

242: l_field := 'WITH_RECOURSE_FLAG';
243: END IF;
244:
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;

Line 247: FND_MESSAGE.set_token('PROCEDURE','validate_args_insert_remit');

243: END IF;
244:
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:

Line 248: FND_MESSAGE.set_token('PARAMETER', l_field);

244:
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

Line 341: FND_MESSAGE.set_name('AR','AR_BR_INVALID_CURRENCY');

337: WHERE currency_code = p_currency_code
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

Line 422: FND_MESSAGE.set_name('AR','AR_BR_INVALID_RECEIPT_METHOD');

418: OPEN Receipt_method;
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;

Line 463: FND_MESSAGE.set_name('AR','AR_RAPI_DOC_SEQ_NOT_EXIST_P');

459: All other exceptions raised by the get_seq_info procedure will be raised to
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

Line 477: FND_MESSAGE.set_name('AR','AR_BR_INVALID_RECEIPT_METHOD');

473: WHEN NO_DATA_FOUND THEN
474: IF PG_DEBUG in ('Y', 'C') THEN
475: arp_util.debug('exception NO_DATA_FOUND in ARP_BR_REMIT_BATCHES.validate_receipt_method');
476: END IF;
477: FND_MESSAGE.set_name('AR','AR_BR_INVALID_RECEIPT_METHOD');
478:
479: IF Receipt_method%ISOPEN THEN
480: CLOSE Receipt_method;
481: END IF;

Line 539: FND_MESSAGE.set_name('AR','AR_BR_INVALID_REMIT_BRANCH');

535: WHERE branch_party_id = p_remittance_bank_branch_id
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

Line 603: FND_MESSAGE.set_name('AR','AR_BR_INVALID_REMIT_ACCOUNT');

599: FETCH accounts INTO nb;
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

Line 654: FND_MESSAGE.set_name('AR','AR_BR_INVALID_REMIT_METHOD');

650: END IF;
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

Line 713: FND_MESSAGE.set_name('AR','AR_BR_INVALID_REMIT_PROGRAM');

709: WHERE program_id = p_auto_trans_program_id
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;

Line 844: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');

840:
841:
842: IF (p_batch_id IS NULL) THEN
843: l_field := 'P_BATCH_ID';
844: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
845: FND_MESSAGE.set_token('PROCEDURE','batch id');
846: FND_MESSAGE.set_token('PARAMETER', l_field);
847: APP_EXCEPTION.raise_exception;
848: END IF;

Line 845: FND_MESSAGE.set_token('PROCEDURE','batch id');

841:
842: IF (p_batch_id IS NULL) THEN
843: l_field := 'P_BATCH_ID';
844: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
845: FND_MESSAGE.set_token('PROCEDURE','batch id');
846: FND_MESSAGE.set_token('PARAMETER', l_field);
847: APP_EXCEPTION.raise_exception;
848: END IF;
849:

Line 846: FND_MESSAGE.set_token('PARAMETER', l_field);

842: IF (p_batch_id IS NULL) THEN
843: l_field := 'P_BATCH_ID';
844: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
845: FND_MESSAGE.set_token('PROCEDURE','batch id');
846: FND_MESSAGE.set_token('PARAMETER', l_field);
847: APP_EXCEPTION.raise_exception;
848: END IF;
849:
850: -- fetch and lock of the batch row

Line 967: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');

963: l_field := 'WITH_RECOURSE_FLAG';
964: END IF;
965:
966: IF (l_field IS NOT NULL) THEN
967: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
968: FND_MESSAGE.set_token('PROCEDURE','validate_args_insert_remit');
969: FND_MESSAGE.set_token('PARAMETER', l_field);
970: APP_EXCEPTION.raise_exception;
971: END IF;

Line 968: FND_MESSAGE.set_token('PROCEDURE','validate_args_insert_remit');

964: END IF;
965:
966: IF (l_field IS NOT NULL) THEN
967: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
968: FND_MESSAGE.set_token('PROCEDURE','validate_args_insert_remit');
969: FND_MESSAGE.set_token('PARAMETER', l_field);
970: APP_EXCEPTION.raise_exception;
971: END IF;
972:

Line 969: FND_MESSAGE.set_token('PARAMETER', l_field);

965:
966: IF (l_field IS NOT NULL) THEN
967: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
968: FND_MESSAGE.set_token('PROCEDURE','validate_args_insert_remit');
969: FND_MESSAGE.set_token('PARAMETER', l_field);
970: APP_EXCEPTION.raise_exception;
971: END IF;
972:
973: -- Check that the gl date is valid