DBA Data[Home] [Help]

APPS.AR_CM_VAL_PVT dependencies on AR_CM_API_PUB

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

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

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

Line 817: ar_cm_api_pub.original_cm_unapp_info.receivable_application_id IS NOT NULL

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

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

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

Line 835: ar_cm_api_pub.original_cm_unapp_info.cm_customer_trx_id IS NULL AND

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

Line 836: ar_cm_api_pub.original_cm_unapp_info.applied_ps_id IS NULL AND

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

Line 837: ar_cm_api_pub.original_cm_unapp_info.inv_customer_trx_id IS NULL AND

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

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

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

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)

Line 845: ar_cm_api_pub.original_cm_unapp_info.inv_customer_trx_id IS NULL AND

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

Line 846: ar_cm_api_pub.original_cm_unapp_info.applied_ps_id IS NULL AND

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

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

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

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

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

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

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

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

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

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

Line 857: ar_cm_api_pub.original_cm_unapp_info.cm_customer_trx_id IS NULL AND

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

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

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

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;

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

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

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