587: AND ps.terms_sequence_number = p_installment
588: ;
589: EXCEPTION
590: WHEN no_data_found THEN
591: IF ar_cm_api_pub.Original_cm_unapp_info.inv_customer_trx_id IS NOT NULL THEN
592: FND_MESSAGE.SET_NAME('AR','AR_RAPI_TRX_ID_INST_INVALID');
593: FND_MSG_PUB.Add;
594: p_return_status := FND_API.G_RET_STS_ERROR;
595: ELSIF ar_cm_api_pub.Original_cm_unapp_info.inv_trx_number IS NOT NULL THEN
591: IF ar_cm_api_pub.Original_cm_unapp_info.inv_customer_trx_id IS NOT NULL THEN
592: FND_MESSAGE.SET_NAME('AR','AR_RAPI_TRX_ID_INST_INVALID');
593: FND_MSG_PUB.Add;
594: p_return_status := FND_API.G_RET_STS_ERROR;
595: ELSIF ar_cm_api_pub.Original_cm_unapp_info.inv_trx_number IS NOT NULL THEN
596: FND_MESSAGE.SET_NAME('AR','AR_RAPI_TRX_NUM_INST_INVALID');
597: FND_MSG_PUB.Add;
598: p_return_status := FND_API.G_RET_STS_ERROR;
599: END IF;
813: END IF;
814: --validate the receivable application id only if it was passed in
815: --directly as a parameter. No need to validate if it was derived.
816: IF p_receivable_application_id IS NOT NULL AND
817: ar_cm_api_pub.original_cm_unapp_info.receivable_application_id IS NOT NULL
818: THEN
819: SELECT count(*)
820: INTO l_valid
821: FROM AR_RECEIVABLE_APPLICATIONS ra
830: p_return_status := FND_API.G_RET_STS_ERROR;
831: END IF;
832:
833: ELSIF p_receivable_application_id IS NULL THEN
834: IF ar_cm_api_pub.original_cm_unapp_info.cm_trx_number IS NULL AND
835: ar_cm_api_pub.original_cm_unapp_info.cm_customer_trx_id IS NULL AND
836: ar_cm_api_pub.original_cm_unapp_info.applied_ps_id IS NULL AND
837: ar_cm_api_pub.original_cm_unapp_info.inv_customer_trx_id IS NULL AND
838: ar_cm_api_pub.original_cm_unapp_info.inv_trx_number IS NULL
831: END IF;
832:
833: ELSIF p_receivable_application_id IS NULL THEN
834: IF ar_cm_api_pub.original_cm_unapp_info.cm_trx_number IS NULL AND
835: ar_cm_api_pub.original_cm_unapp_info.cm_customer_trx_id IS NULL AND
836: ar_cm_api_pub.original_cm_unapp_info.applied_ps_id IS NULL AND
837: ar_cm_api_pub.original_cm_unapp_info.inv_customer_trx_id IS NULL AND
838: ar_cm_api_pub.original_cm_unapp_info.inv_trx_number IS NULL
839: THEN
832:
833: ELSIF p_receivable_application_id IS NULL THEN
834: IF ar_cm_api_pub.original_cm_unapp_info.cm_trx_number IS NULL AND
835: ar_cm_api_pub.original_cm_unapp_info.cm_customer_trx_id IS NULL AND
836: ar_cm_api_pub.original_cm_unapp_info.applied_ps_id IS NULL AND
837: ar_cm_api_pub.original_cm_unapp_info.inv_customer_trx_id IS NULL AND
838: ar_cm_api_pub.original_cm_unapp_info.inv_trx_number IS NULL
839: THEN
840: --receivable application id is null
833: ELSIF p_receivable_application_id IS NULL THEN
834: IF ar_cm_api_pub.original_cm_unapp_info.cm_trx_number IS NULL AND
835: ar_cm_api_pub.original_cm_unapp_info.cm_customer_trx_id IS NULL AND
836: ar_cm_api_pub.original_cm_unapp_info.applied_ps_id IS NULL AND
837: ar_cm_api_pub.original_cm_unapp_info.inv_customer_trx_id IS NULL AND
838: ar_cm_api_pub.original_cm_unapp_info.inv_trx_number IS NULL
839: THEN
840: --receivable application id is null
841: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REC_APP_ID_NULL');
834: IF ar_cm_api_pub.original_cm_unapp_info.cm_trx_number IS NULL AND
835: ar_cm_api_pub.original_cm_unapp_info.cm_customer_trx_id IS NULL AND
836: ar_cm_api_pub.original_cm_unapp_info.applied_ps_id IS NULL AND
837: ar_cm_api_pub.original_cm_unapp_info.inv_customer_trx_id IS NULL AND
838: ar_cm_api_pub.original_cm_unapp_info.inv_trx_number IS NULL
839: THEN
840: --receivable application id is null
841: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REC_APP_ID_NULL');
842: FND_MSG_PUB.Add;
840: --receivable application id is null
841: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REC_APP_ID_NULL');
842: FND_MSG_PUB.Add;
843: p_return_status := FND_API.G_RET_STS_ERROR;
844: ELSIF ar_cm_api_pub.original_cm_unapp_info.inv_trx_number IS NULL AND
845: ar_cm_api_pub.original_cm_unapp_info.inv_customer_trx_id IS NULL AND
846: ar_cm_api_pub.original_cm_unapp_info.applied_ps_id IS NULL AND
847: (ar_cm_api_pub.original_cm_unapp_info.cm_customer_trx_id IS NOT NULL OR
848: ar_cm_api_pub.original_cm_unapp_info.cm_trx_number IS NOT NULL)
841: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REC_APP_ID_NULL');
842: FND_MSG_PUB.Add;
843: p_return_status := FND_API.G_RET_STS_ERROR;
844: ELSIF ar_cm_api_pub.original_cm_unapp_info.inv_trx_number IS NULL AND
845: ar_cm_api_pub.original_cm_unapp_info.inv_customer_trx_id IS NULL AND
846: ar_cm_api_pub.original_cm_unapp_info.applied_ps_id IS NULL AND
847: (ar_cm_api_pub.original_cm_unapp_info.cm_customer_trx_id IS NOT NULL OR
848: ar_cm_api_pub.original_cm_unapp_info.cm_trx_number IS NOT NULL)
849: THEN
842: FND_MSG_PUB.Add;
843: p_return_status := FND_API.G_RET_STS_ERROR;
844: ELSIF ar_cm_api_pub.original_cm_unapp_info.inv_trx_number IS NULL AND
845: ar_cm_api_pub.original_cm_unapp_info.inv_customer_trx_id IS NULL AND
846: ar_cm_api_pub.original_cm_unapp_info.applied_ps_id IS NULL AND
847: (ar_cm_api_pub.original_cm_unapp_info.cm_customer_trx_id IS NOT NULL OR
848: ar_cm_api_pub.original_cm_unapp_info.cm_trx_number IS NOT NULL)
849: THEN
850: --the transaction was not specified
843: p_return_status := FND_API.G_RET_STS_ERROR;
844: ELSIF ar_cm_api_pub.original_cm_unapp_info.inv_trx_number IS NULL AND
845: ar_cm_api_pub.original_cm_unapp_info.inv_customer_trx_id IS NULL AND
846: ar_cm_api_pub.original_cm_unapp_info.applied_ps_id IS NULL AND
847: (ar_cm_api_pub.original_cm_unapp_info.cm_customer_trx_id IS NOT NULL OR
848: ar_cm_api_pub.original_cm_unapp_info.cm_trx_number IS NOT NULL)
849: THEN
850: --the transaction was not specified
851: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUST_TRX_ID_NULL');
844: ELSIF ar_cm_api_pub.original_cm_unapp_info.inv_trx_number IS NULL AND
845: ar_cm_api_pub.original_cm_unapp_info.inv_customer_trx_id IS NULL AND
846: ar_cm_api_pub.original_cm_unapp_info.applied_ps_id IS NULL AND
847: (ar_cm_api_pub.original_cm_unapp_info.cm_customer_trx_id IS NOT NULL OR
848: ar_cm_api_pub.original_cm_unapp_info.cm_trx_number IS NOT NULL)
849: THEN
850: --the transaction was not specified
851: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUST_TRX_ID_NULL');
852: FND_MSG_PUB.Add;
850: --the transaction was not specified
851: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUST_TRX_ID_NULL');
852: FND_MSG_PUB.Add;
853: p_return_status := FND_API.G_RET_STS_ERROR;
854: ELSIF (ar_cm_api_pub.original_cm_unapp_info.inv_trx_number IS NOT NULL OR
855: ar_cm_api_pub.original_cm_unapp_info.inv_customer_trx_id IS NOT NULL OR
856: ar_cm_api_pub.original_cm_unapp_info.applied_ps_id IS NOT NULL) AND
857: ar_cm_api_pub.original_cm_unapp_info.cm_customer_trx_id IS NULL AND
858: ar_cm_api_pub.original_cm_unapp_info.cm_trx_number IS NULL
851: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUST_TRX_ID_NULL');
852: FND_MSG_PUB.Add;
853: p_return_status := FND_API.G_RET_STS_ERROR;
854: ELSIF (ar_cm_api_pub.original_cm_unapp_info.inv_trx_number IS NOT NULL OR
855: ar_cm_api_pub.original_cm_unapp_info.inv_customer_trx_id IS NOT NULL OR
856: ar_cm_api_pub.original_cm_unapp_info.applied_ps_id IS NOT NULL) AND
857: ar_cm_api_pub.original_cm_unapp_info.cm_customer_trx_id IS NULL AND
858: ar_cm_api_pub.original_cm_unapp_info.cm_trx_number IS NULL
859: THEN
852: FND_MSG_PUB.Add;
853: p_return_status := FND_API.G_RET_STS_ERROR;
854: ELSIF (ar_cm_api_pub.original_cm_unapp_info.inv_trx_number IS NOT NULL OR
855: ar_cm_api_pub.original_cm_unapp_info.inv_customer_trx_id IS NOT NULL OR
856: ar_cm_api_pub.original_cm_unapp_info.applied_ps_id IS NOT NULL) AND
857: ar_cm_api_pub.original_cm_unapp_info.cm_customer_trx_id IS NULL AND
858: ar_cm_api_pub.original_cm_unapp_info.cm_trx_number IS NULL
859: THEN
860: --the credit memo was not specified
853: p_return_status := FND_API.G_RET_STS_ERROR;
854: ELSIF (ar_cm_api_pub.original_cm_unapp_info.inv_trx_number IS NOT NULL OR
855: ar_cm_api_pub.original_cm_unapp_info.inv_customer_trx_id IS NOT NULL OR
856: ar_cm_api_pub.original_cm_unapp_info.applied_ps_id IS NOT NULL) AND
857: ar_cm_api_pub.original_cm_unapp_info.cm_customer_trx_id IS NULL AND
858: ar_cm_api_pub.original_cm_unapp_info.cm_trx_number IS NULL
859: THEN
860: --the credit memo was not specified
861: FND_MESSAGE.SET_NAME('AR','AR_CMAPI_CM_TRX_ID_NULL');
854: ELSIF (ar_cm_api_pub.original_cm_unapp_info.inv_trx_number IS NOT NULL OR
855: ar_cm_api_pub.original_cm_unapp_info.inv_customer_trx_id IS NOT NULL OR
856: ar_cm_api_pub.original_cm_unapp_info.applied_ps_id IS NOT NULL) AND
857: ar_cm_api_pub.original_cm_unapp_info.cm_customer_trx_id IS NULL AND
858: ar_cm_api_pub.original_cm_unapp_info.cm_trx_number IS NULL
859: THEN
860: --the credit memo was not specified
861: FND_MESSAGE.SET_NAME('AR','AR_CMAPI_CM_TRX_ID_NULL');
862: FND_MSG_PUB.Add;
1465:
1466: IF nvl( l_ra_app_ps_id,-99) <> nvl(p_applied_payment_schedule_id,
1467: nvl( l_ra_app_ps_id,-99))
1468: THEN
1469: IF ar_cm_api_pub.original_cm_unapp_info.inv_customer_trx_id IS NOT NULL OR
1470: ar_cm_api_pub.original_cm_unapp_info.inv_trx_number IS NOT NULL THEN
1471: FND_MESSAGE.SET_NAME('AR','AR_RAPI_TRX_RA_ID_X_INVALID');
1472: FND_MSG_PUB.Add;
1473: p_return_status := FND_API.G_RET_STS_ERROR;
1466: IF nvl( l_ra_app_ps_id,-99) <> nvl(p_applied_payment_schedule_id,
1467: nvl( l_ra_app_ps_id,-99))
1468: THEN
1469: IF ar_cm_api_pub.original_cm_unapp_info.inv_customer_trx_id IS NOT NULL OR
1470: ar_cm_api_pub.original_cm_unapp_info.inv_trx_number IS NOT NULL THEN
1471: FND_MESSAGE.SET_NAME('AR','AR_RAPI_TRX_RA_ID_X_INVALID');
1472: FND_MSG_PUB.Add;
1473: p_return_status := FND_API.G_RET_STS_ERROR;
1474: ELSIF ar_cm_api_pub.original_cm_unapp_info.applied_ps_id IS NOT NULL THEN
1470: ar_cm_api_pub.original_cm_unapp_info.inv_trx_number IS NOT NULL THEN
1471: FND_MESSAGE.SET_NAME('AR','AR_RAPI_TRX_RA_ID_X_INVALID');
1472: FND_MSG_PUB.Add;
1473: p_return_status := FND_API.G_RET_STS_ERROR;
1474: ELSIF ar_cm_api_pub.original_cm_unapp_info.applied_ps_id IS NOT NULL THEN
1475: FND_MESSAGE.SET_NAME('AR','AR_RAPI_APP_PS_RA_ID_X_INVALID');
1476: FND_MSG_PUB.Add;
1477: p_return_status := FND_API.G_RET_STS_ERROR;
1478: END IF;