DBA Data[Home] [Help]

APPS.AR_CM_VAL_PVT dependencies on AR_CM_API_PUB

Line 590: IF ar_cm_api_pub.Original_cm_unapp_info.inv_customer_trx_id IS NOT NULL THEN

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

Line 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;

Line 816: ar_cm_api_pub.original_cm_unapp_info.receivable_application_id IS NOT NULL

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

Line 833: IF ar_cm_api_pub.original_cm_unapp_info.cm_trx_number IS NULL AND

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

Line 834: ar_cm_api_pub.original_cm_unapp_info.cm_customer_trx_id IS NULL AND

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

Line 835: ar_cm_api_pub.original_cm_unapp_info.applied_ps_id IS NULL AND

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

Line 836: ar_cm_api_pub.original_cm_unapp_info.inv_customer_trx_id IS NULL AND

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');

Line 837: ar_cm_api_pub.original_cm_unapp_info.inv_trx_number IS 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;

Line 843: ELSIF ar_cm_api_pub.original_cm_unapp_info.inv_trx_number IS NULL AND

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)

Line 844: ar_cm_api_pub.original_cm_unapp_info.inv_customer_trx_id IS NULL AND

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

Line 845: ar_cm_api_pub.original_cm_unapp_info.applied_ps_id IS NULL AND

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

Line 846: (ar_cm_api_pub.original_cm_unapp_info.cm_customer_trx_id IS NOT NULL OR

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');

Line 847: ar_cm_api_pub.original_cm_unapp_info.cm_trx_number IS NOT 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;

Line 853: ELSIF (ar_cm_api_pub.original_cm_unapp_info.inv_trx_number IS NOT NULL OR

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

Line 854: ar_cm_api_pub.original_cm_unapp_info.inv_customer_trx_id IS NOT NULL OR

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

Line 855: ar_cm_api_pub.original_cm_unapp_info.applied_ps_id IS NOT NULL) AND

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

Line 856: ar_cm_api_pub.original_cm_unapp_info.cm_customer_trx_id IS NULL AND

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');

Line 857: ar_cm_api_pub.original_cm_unapp_info.cm_trx_number IS 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;

Line 1437: IF ar_cm_api_pub.original_cm_unapp_info.inv_customer_trx_id IS NOT NULL OR

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;

Line 1438: ar_cm_api_pub.original_cm_unapp_info.inv_trx_number IS NOT NULL THEN

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

Line 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;