DBA Data[Home] [Help]

APPS.ARP_RW_BATCHES_PKG dependencies on APP_EXCEPTION

Line 217: APP_EXCEPTION.raise_exception;

213: WHERE batch_source_id = l_batch_rec.batch_source_id;
214: --
215: IF ( SQL%ROWCOUNT = 0 ) THEN
216: FND_MESSAGE.set_name( 'AR', 'AR_UPDNA_LAST_BATCH_NO' );
217: APP_EXCEPTION.raise_exception;
218: END IF;
219: --
220: SELECT NVL( LAST_BATCH_NUM, 0 )
221: INTO l_batch_rec.name

Line 337: APP_EXCEPTION.raise_exception;

333: IF ( l_field IS NOT NULL ) THEN
334: FND_MESSAGE.set_name( 'AR', 'AR_PROCEDURE_VALID_ARGS_FAIL' );
335: FND_MESSAGE.set_token('PROCEDURE', 'VALIDATE_ARGS_INSERT_MANUAL');
336: FND_MESSAGE.set_token('PARAMETER', l_field);
337: APP_EXCEPTION.raise_exception;
338: END IF;
339: --
340: IF PG_DEBUG in ('Y', 'C') THEN
341: arp_util.debug( 'arp_rw_batches_pkg.validate_args_insert_manual()-' );

Line 549: app_exception.raise_exception;

545: close c_valid_receipt_class;
546: fnd_message.set_name( 'AR', 'AR_PROCEDURE_VALID_ARGS_FAIL' );
547: fnd_message.set_token('PROCEDURE', 'INSERT_AUTO_BATCH');
548: fnd_message.set_token('PARAMETER', 'RECEIPT_CLASS_ID' );
549: app_exception.raise_exception;
550: end if;
551: close c_valid_receipt_class;
552: end if;
553:

Line 563: app_exception.raise_exception;

559: close c_valid_receipt_method;
560: fnd_message.set_name( 'AR', 'AR_PROCEDURE_VALID_ARGS_FAIL' );
561: fnd_message.set_token('PROCEDURE', 'INSERT_AUTO_BATCH');
562: fnd_message.set_token('PARAMETER', 'RECEIPT_METHOD_ID' );
563: app_exception.raise_exception;
564: end if;
565: close c_valid_receipt_method;
566: end if;
567:

Line 588: app_exception.raise_exception;

584: if (nvl(l_batch_rec.exchange_rate, -1) = -1) then
585: fnd_message.set_name( 'AR', 'AR_PROCEDURE_VALID_ARGS_FAIL' );
586: fnd_message.set_token('PROCEDURE', 'INSERT_AUTO_BATCH');
587: fnd_message.set_token('PARAMETER', 'EXCHANGE_RATE(_TYPE)' );
588: app_exception.raise_exception;
589: end if;
590: end if;
591:
592: --

Line 616: APP_EXCEPTION.raise_exception;

612: WHERE batch_source_id = l_batch_rec.batch_source_id;
613: --
614: IF ( SQL%ROWCOUNT = 0 ) THEN
615: FND_MESSAGE.set_name( 'AR', 'AR_UPDNA_LAST_BATCH_NO' );
616: APP_EXCEPTION.raise_exception;
617: END IF;
618: --
619: SELECT NVL( LAST_BATCH_NUM, 0 )
620: INTO l_batch_rec.name

Line 762: APP_EXCEPTION.raise_exception;

758: IF ( l_field IS NOT NULL ) THEN
759: FND_MESSAGE.set_name( 'AR', 'AR_PROCEDURE_VALID_ARGS_FAIL' );
760: FND_MESSAGE.set_token('PROCEDURE', 'VALIDATE_ARGS_INSERT_AUTO');
761: FND_MESSAGE.set_token('PARAMETER', l_field );
762: APP_EXCEPTION.raise_exception;
763: END IF;
764: --
765: IF PG_DEBUG in ('Y', 'C') THEN
766: arp_util.debug( 'arp_rw_batches_pkg.validate_args_insert_auto()-' );

Line 1022: APP_EXCEPTION.raise_exception;

1018: IF ( l_batch_rec.remit_bank_acct_use_id IS NOT NULL ) THEN
1019: FND_MESSAGE.set_name( 'AR', 'AR_PROCEDURE_VALID_ARGS_FAIL' );
1020: FND_MESSAGE.set_token('PROCEDURE', 'INSERT_REMIT_BATCH');
1021: FND_MESSAGE.set_token('PARAMETER', 'REMITTANCE_BANK_ACCOUNT_ID' );
1022: APP_EXCEPTION.raise_exception;
1023: END IF;
1024: ELSIF (l_batch_rec.remit_bank_acct_use_id IS NULL) THEN
1025: FND_MESSAGE.set_name( 'AR', 'AR_PROCEDURE_VALID_ARGS_FAIL' );
1026: FND_MESSAGE.set_token('PROCEDURE', 'INSERT_REMIT_BATCH');

Line 1028: APP_EXCEPTION.raise_exception;

1024: ELSIF (l_batch_rec.remit_bank_acct_use_id IS NULL) THEN
1025: FND_MESSAGE.set_name( 'AR', 'AR_PROCEDURE_VALID_ARGS_FAIL' );
1026: FND_MESSAGE.set_token('PROCEDURE', 'INSERT_REMIT_BATCH');
1027: FND_MESSAGE.set_token('PARAMETER', 'REMITTANCE_BANK_ACCOUNT_ID' );
1028: APP_EXCEPTION.raise_exception;
1029: END IF;
1030: -- Check for valid GL date
1031: --
1032: arp_util.validate_gl_date( l_batch_rec.gl_date,

Line 1045: app_exception.raise_exception;

1041: close c_valid_receipt_class;
1042: fnd_message.set_name( 'AR', 'AR_PROCEDURE_VALID_ARGS_FAIL' );
1043: fnd_message.set_token('PROCEDURE', 'INSERT_REMIT_BATCH');
1044: fnd_message.set_token('PARAMETER', 'RECEIPT_CLASS_ID' );
1045: app_exception.raise_exception;
1046: end if;
1047: close c_valid_receipt_class;
1048: end if;
1049:

Line 1059: app_exception.raise_exception;

1055: close c_valid_receipt_method;
1056: fnd_message.set_name( 'AR', 'AR_PROCEDURE_VALID_ARGS_FAIL' );
1057: fnd_message.set_token('PROCEDURE', 'INSERT_REMIT_BATCH');
1058: fnd_message.set_token('PARAMETER', 'RECEIPT_METHOD_ID' );
1059: app_exception.raise_exception;
1060: end if;
1061: close c_valid_receipt_method;
1062: end if;
1063:

Line 1073: app_exception.raise_exception;

1069: close c_valid_bank_branch;
1070: fnd_message.set_name( 'AR', 'AR_PROCEDURE_VALID_ARGS_FAIL' );
1071: fnd_message.set_token('PROCEDURE', 'INSERT_REMIT_BATCH');
1072: fnd_message.set_token('PARAMETER', 'BANK_BRANCH_ID' );
1073: app_exception.raise_exception;
1074: end if;
1075: close c_valid_bank_branch;
1076: end if;
1077:

Line 1087: app_exception.raise_exception;

1083: close c_valid_bank_account;
1084: fnd_message.set_name( 'AR', 'AR_PROCEDURE_VALID_ARGS_FAIL' );
1085: fnd_message.set_token('PROCEDURE', 'INSERT_REMIT_BATCH');
1086: fnd_message.set_token('PARAMETER', 'BANK_ACCOUNT_ID' );
1087: app_exception.raise_exception;
1088: end if;
1089: close c_valid_bank_account;
1090: end if;
1091:

Line 1117: APP_EXCEPTION.raise_exception;

1113: WHERE batch_source_id = l_batch_rec.batch_source_id;
1114: --
1115: IF ( SQL%ROWCOUNT = 0 ) THEN
1116: FND_MESSAGE.set_name( 'AR', 'AR_UPDNA_LAST_BATCH_NO' );
1117: APP_EXCEPTION.raise_exception;
1118: END IF;
1119: --
1120: SELECT NVL( LAST_BATCH_NUM, 0 )
1121: INTO l_batch_rec.name

Line 1228: APP_EXCEPTION.raise_exception;

1224: IF ( l_field IS NOT NULL ) THEN
1225: FND_MESSAGE.set_name( 'AR', 'AR_PROCEDURE_VALID_ARGS_FAIL' );
1226: FND_MESSAGE.set_token('PROCEDURE', 'VALIDATE_ARGS_INSERT_REMIT');
1227: FND_MESSAGE.set_token('PARAMETER', l_field );
1228: APP_EXCEPTION.raise_exception;
1229: END IF;
1230: --
1231: IF PG_DEBUG in ('Y', 'C') THEN
1232: arp_util.debug( 'arp_rw_batches_pkg.validate_args_insert_remit()-' );