DBA Data[Home] [Help]

APPS.OKL_RECEIPTS_PVT dependencies on AR_RECEIPT_API_PUB

Line 785: l_attribute_rec AR_RECEIPT_API_PUB.attribute_rec_type;

781: l_msg_data VARCHAR2(2000);
782: l_api_name CONSTANT VARCHAR2(30) := 'create_unapplied_receipt';
783: l_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE;
784: l_rcpt_rec RCPT_REC_TYPE;
785: l_attribute_rec AR_RECEIPT_API_PUB.attribute_rec_type;
786: BEGIN
787: l_return_status := okl_api.start_activity(l_api_name,
788: g_pkg_name,
789: p_init_msg_list,

Line 817: Ar_receipt_api_pub.Create_cash( p_api_version => l_api_version

813: l_attribute_rec.attribute12 := l_rcpt_rec.dff_attribute12;
814: l_attribute_rec.attribute13 := l_rcpt_rec.dff_attribute13;
815: l_attribute_rec.attribute14 := l_rcpt_rec.dff_attribute14;
816: l_attribute_rec.attribute15 := l_rcpt_rec.dff_attribute15;
817: Ar_receipt_api_pub.Create_cash( p_api_version => l_api_version
818: ,p_init_msg_list => l_init_msg_list
819: ,x_return_status => l_return_status
820: ,x_msg_count => l_msg_count
821: ,x_msg_data => l_msg_data

Line 914: l_attribute_rec AR_RECEIPT_API_PUB.attribute_rec_type;

910: l_msg_data VARCHAR2(2000);
911: l_api_name CONSTANT VARCHAR2(30) := 'create_onaccount_receipt';
912: l_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE;
913: l_rcpt_rec RCPT_REC_TYPE;
914: l_attribute_rec AR_RECEIPT_API_PUB.attribute_rec_type;
915: BEGIN
916: log_debug('create_onaccount_receipt start ');
917: l_return_status := okl_api.start_activity(l_api_name,
918: g_pkg_name,

Line 949: Ar_receipt_api_pub.Apply_on_account( p_api_version => l_api_version

945: RAISE okl_api.g_exception_error;
946: END IF;
947: l_cash_receipt_id:=x_cash_receipt_id;
948:
949: Ar_receipt_api_pub.Apply_on_account( p_api_version => l_api_version
950: ,p_init_msg_list => l_init_msg_list
951: ,x_return_status => l_return_status
952: ,x_msg_count => l_msg_count
953: ,x_msg_data => l_msg_data

Line 962: log_debug('Return status from Ar_receipt_api_pub.Create_Apply_On_Acc = '||l_return_status);

958: ,p_org_id => l_rcpt_rec.org_id
959: );
960:
961: x_cash_receipt_id := l_cash_receipt_id;
962: log_debug('Return status from Ar_receipt_api_pub.Create_Apply_On_Acc = '||l_return_status);
963: x_cash_receipt_id := l_cash_receipt_id;
964:
965: x_return_status := l_return_status;
966:

Line 1093: AR_RECEIPT_API_PUB.Unapply( p_api_version => l_api_version

1089: FETCH c_ver_dup_applic INTO l_receivable_application_id;
1090: CLOSE c_ver_dup_applic;
1091:
1092: IF l_receivable_application_id IS NOT NULL THEN
1093: AR_RECEIPT_API_PUB.Unapply( p_api_version => l_api_version
1094: ,p_init_msg_list => l_init_msg_list
1095: ,x_return_status => l_return_status
1096: ,x_msg_count => l_msg_count
1097: ,x_msg_data => l_msg_data

Line 1180: l_ar_llca_tbl ar_receipt_api_pub.llca_trx_lines_tbl_type;

1176:
1177: l_customer_trx_id NUMBER DEFAULT p_customer_trx_id;
1178: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT p_cash_receipt_id;
1179: l_llca_tbl llca_tbl_type := p_llca_tbl;
1180: l_ar_llca_tbl ar_receipt_api_pub.llca_trx_lines_tbl_type;
1181: l_receivable_application_id AR_RECEIVABLE_APPLICATIONS_ALL.RECEIVABLE_APPLICATION_ID%TYPE DEFAULT NULL;
1182: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE DEFAULT p_gl_date;
1183: l_org_id NUMBER := p_org_id;
1184: l_apply_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;

Line 1332: log_debug('calling AR_RECEIPT_API_PUB.apply_in_detail');

1328: i := l_llca_tbl.FIRST;
1329: l_ar_llca_tbl(i).customer_trx_line_id := l_llca_tbl(i).invoice_line_id;
1330: l_ar_llca_tbl(i).amount_applied := l_llca_tbl(i).amount_applied;
1331: END IF;
1332: log_debug('calling AR_RECEIPT_API_PUB.apply_in_detail');
1333: log_debug('Parameters: p_cash_receipt_id = '||l_cash_receipt_id);
1334: log_debug('p_customer_trx_id = '||l_customer_trx_id);
1335: log_debug('p_apply_gl_date = '||p_apply_gl_date);
1336: log_debug('l_apply_rcpt_date = '||l_apply_rcpt_date);

Line 1341: AR_RECEIPT_API_PUB.apply_in_detail( p_api_version => l_api_version

1337: log_debug('l_trans_to_receipt_rate = '||l_trans_to_receipt_rate);
1338: IF l_ar_llca_tbl.COUNT > 0 THEN
1339: lla_exists := okl_lckbx_csh_app_pvt.get_line_level_app(l_customer_trx_id , l_org_id);
1340: IF NVL(lla_exists,'N') = 'Y' THEN
1341: AR_RECEIPT_API_PUB.apply_in_detail( p_api_version => l_api_version
1342: ,p_init_msg_list => l_init_msg_list
1343: ,x_return_status => l_return_status
1344: ,x_msg_count => l_msg_count
1345: ,x_msg_data => l_msg_data

Line 1357: log_debug('Return status of AR_RECEIPT_API_PUB.apply_in_detail = '|| l_return_status);

1353: ,p_freight_amount => p_freight_amount
1354: ,p_charges_amount => p_charges_amount
1355: ,p_trans_to_receipt_rate => l_trans_to_receipt_rate
1356: );
1357: log_debug('Return status of AR_RECEIPT_API_PUB.apply_in_detail = '|| l_return_status);
1358: ELSE
1359: AR_RECEIPT_API_PUB.apply( p_api_version => l_api_version
1360: ,p_init_msg_list => l_init_msg_list
1361: ,x_return_status => l_return_status

Line 1359: AR_RECEIPT_API_PUB.apply( p_api_version => l_api_version

1355: ,p_trans_to_receipt_rate => l_trans_to_receipt_rate
1356: );
1357: log_debug('Return status of AR_RECEIPT_API_PUB.apply_in_detail = '|| l_return_status);
1358: ELSE
1359: AR_RECEIPT_API_PUB.apply( p_api_version => l_api_version
1360: ,p_init_msg_list => l_init_msg_list
1361: ,x_return_status => l_return_status
1362: ,x_msg_count => l_msg_count
1363: ,x_msg_data => l_msg_data

Line 1373: log_debug('Return status of AR_RECEIPT_API_PUB.apply = '|| l_return_status);

1369: ,p_trans_to_receipt_rate => l_trans_to_receipt_rate
1370: ,p_comments => NULL
1371: ,p_amount_applied => l_ar_llca_tbl(l_ar_llca_tbl.FIRST).amount_applied
1372: );
1373: log_debug('Return status of AR_RECEIPT_API_PUB.apply = '|| l_return_status);
1374: END IF;
1375:
1376: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1377: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1509: Ar_receipt_api_pub.Unapply_on_account( p_api_version => l_api_version,

1505: CLOSE c_get_onacc_app_id;
1506:
1507: IF l_onacc_appplication_id IS NOT NULL THEN
1508: -- Unapply the on-account amount
1509: Ar_receipt_api_pub.Unapply_on_account( p_api_version => l_api_version,
1510: p_init_msg_list => l_init_msg_list,
1511: x_return_status => l_return_status ,
1512: x_msg_count => l_msg_count ,
1513: x_msg_data => l_msg_data,

Line 1519: log_debug('Return status of AR_RECEIPT_API_PUB.Unapply_on_account = '|| l_return_status);

1515: p_receivable_application_id =>l_onacc_appplication_id,
1516: p_reversal_gl_date => NULL,
1517: p_org_id => l_org_id
1518: );
1519: log_debug('Return status of AR_RECEIPT_API_PUB.Unapply_on_account = '|| l_return_status);
1520: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1521: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1522: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1523: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1529: log_debug('Ar_receipt_api_pub.Apply_on_account l_cash_receipt_id '||l_cash_receipt_id);

1525: END IF;
1526: END IF;
1527: -- Check if any On-Account amount to be applied
1528: If ( Nvl(l_apply_onacc_amount,0) > 0 ) Then
1529: log_debug('Ar_receipt_api_pub.Apply_on_account l_cash_receipt_id '||l_cash_receipt_id);
1530: log_debug('Ar_receipt_api_pub.Apply_on_account l_apply_onacc_amount '||l_apply_onacc_amount);
1531: log_debug('Ar_receipt_api_pub.Apply_on_account l_rcpt_date '||l_rcpt_date);
1532: log_debug('Ar_receipt_api_pub.Apply_on_account l_gl_date '||l_gl_date);
1533: -- Apply the on-account amount

Line 1530: log_debug('Ar_receipt_api_pub.Apply_on_account l_apply_onacc_amount '||l_apply_onacc_amount);

1526: END IF;
1527: -- Check if any On-Account amount to be applied
1528: If ( Nvl(l_apply_onacc_amount,0) > 0 ) Then
1529: log_debug('Ar_receipt_api_pub.Apply_on_account l_cash_receipt_id '||l_cash_receipt_id);
1530: log_debug('Ar_receipt_api_pub.Apply_on_account l_apply_onacc_amount '||l_apply_onacc_amount);
1531: log_debug('Ar_receipt_api_pub.Apply_on_account l_rcpt_date '||l_rcpt_date);
1532: log_debug('Ar_receipt_api_pub.Apply_on_account l_gl_date '||l_gl_date);
1533: -- Apply the on-account amount
1534: Ar_receipt_api_pub.Apply_on_account( p_api_version => l_api_version

Line 1531: log_debug('Ar_receipt_api_pub.Apply_on_account l_rcpt_date '||l_rcpt_date);

1527: -- Check if any On-Account amount to be applied
1528: If ( Nvl(l_apply_onacc_amount,0) > 0 ) Then
1529: log_debug('Ar_receipt_api_pub.Apply_on_account l_cash_receipt_id '||l_cash_receipt_id);
1530: log_debug('Ar_receipt_api_pub.Apply_on_account l_apply_onacc_amount '||l_apply_onacc_amount);
1531: log_debug('Ar_receipt_api_pub.Apply_on_account l_rcpt_date '||l_rcpt_date);
1532: log_debug('Ar_receipt_api_pub.Apply_on_account l_gl_date '||l_gl_date);
1533: -- Apply the on-account amount
1534: Ar_receipt_api_pub.Apply_on_account( p_api_version => l_api_version
1535: ,p_init_msg_list => l_init_msg_list

Line 1532: log_debug('Ar_receipt_api_pub.Apply_on_account l_gl_date '||l_gl_date);

1528: If ( Nvl(l_apply_onacc_amount,0) > 0 ) Then
1529: log_debug('Ar_receipt_api_pub.Apply_on_account l_cash_receipt_id '||l_cash_receipt_id);
1530: log_debug('Ar_receipt_api_pub.Apply_on_account l_apply_onacc_amount '||l_apply_onacc_amount);
1531: log_debug('Ar_receipt_api_pub.Apply_on_account l_rcpt_date '||l_rcpt_date);
1532: log_debug('Ar_receipt_api_pub.Apply_on_account l_gl_date '||l_gl_date);
1533: -- Apply the on-account amount
1534: Ar_receipt_api_pub.Apply_on_account( p_api_version => l_api_version
1535: ,p_init_msg_list => l_init_msg_list
1536: ,x_return_status => l_return_status

Line 1534: Ar_receipt_api_pub.Apply_on_account( p_api_version => l_api_version

1530: log_debug('Ar_receipt_api_pub.Apply_on_account l_apply_onacc_amount '||l_apply_onacc_amount);
1531: log_debug('Ar_receipt_api_pub.Apply_on_account l_rcpt_date '||l_rcpt_date);
1532: log_debug('Ar_receipt_api_pub.Apply_on_account l_gl_date '||l_gl_date);
1533: -- Apply the on-account amount
1534: Ar_receipt_api_pub.Apply_on_account( p_api_version => l_api_version
1535: ,p_init_msg_list => l_init_msg_list
1536: ,x_return_status => l_return_status
1537: ,x_msg_count => l_msg_count
1538: ,x_msg_data => l_msg_data

Line 1545: log_debug('Return status of AR_RECEIPT_API_PUB.Apply_on_account = '|| l_return_status);

1541: ,p_apply_date => l_rcpt_date
1542: ,p_apply_gl_date => l_gl_date
1543: ,p_org_id => l_org_id
1544: );
1545: log_debug('Return status of AR_RECEIPT_API_PUB.Apply_on_account = '|| l_return_status);
1546: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1547: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1548: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1549: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 2235: Ar_receipt_api_pub.Unapply_on_account( p_api_version => l_api_version,

2231: FETCH c_get_onacc_app_id INTO l_onacc_appplication_id;
2232: CLOSE c_get_onacc_app_id;
2233:
2234: -- Unapply the on-account amount
2235: Ar_receipt_api_pub.Unapply_on_account( p_api_version => l_api_version,
2236: p_init_msg_list => l_init_msg_list,
2237: x_return_status => l_return_status ,
2238: x_msg_count => l_msg_count ,
2239: x_msg_data => l_msg_data,

Line 2245: log_debug('Return status of AR_RECEIPT_API_PUB.Unapply_on_account = '|| l_return_status);

2241: p_receivable_application_id =>l_onacc_appplication_id,
2242: p_reversal_gl_date => NULL,
2243: p_org_id => l_org_id
2244: );
2245: log_debug('Return status of AR_RECEIPT_API_PUB.Unapply_on_account = '|| l_return_status);
2246: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2247: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2248: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2249: RAISE OKL_API.G_EXCEPTION_ERROR;