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