eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 1340: log_debug('calling AR_RECEIPT_API_PUB.apply_in_detail');

1336: i := l_llca_tbl.FIRST;
1337: l_ar_llca_tbl(i).customer_trx_line_id := l_llca_tbl(i).invoice_line_id;
1338: l_ar_llca_tbl(i).amount_applied := l_llca_tbl(i).amount_applied;
1339: END IF;
1340: log_debug('calling AR_RECEIPT_API_PUB.apply_in_detail');
1341: log_debug('Parameters: p_cash_receipt_id = '||l_cash_receipt_id);
1342: log_debug('p_customer_trx_id = '||l_customer_trx_id);
1343: log_debug('p_apply_gl_date = '||p_apply_gl_date);
1344: log_debug('l_apply_rcpt_date = '||l_apply_rcpt_date);

Line 1349: AR_RECEIPT_API_PUB.apply_in_detail( p_api_version => l_api_version

1345: log_debug('l_trans_to_receipt_rate = '||l_trans_to_receipt_rate);
1346: IF l_ar_llca_tbl.COUNT > 0 THEN
1347: lla_exists := okl_lckbx_csh_app_pvt.get_line_level_app(l_customer_trx_id , l_org_id);
1348: IF NVL(lla_exists,'N') = 'Y' THEN
1349: AR_RECEIPT_API_PUB.apply_in_detail( p_api_version => l_api_version
1350: ,p_init_msg_list => l_init_msg_list
1351: ,x_return_status => l_return_status
1352: ,x_msg_count => l_msg_count
1353: ,x_msg_data => l_msg_data

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

1361: ,p_freight_amount => p_freight_amount
1362: ,p_charges_amount => p_charges_amount
1363: ,p_trans_to_receipt_rate => l_trans_to_receipt_rate
1364: );
1365: log_debug('Return status of AR_RECEIPT_API_PUB.apply_in_detail = '|| l_return_status);
1366: ELSE
1367: AR_RECEIPT_API_PUB.apply( p_api_version => l_api_version
1368: ,p_init_msg_list => l_init_msg_list
1369: ,x_return_status => l_return_status

Line 1367: AR_RECEIPT_API_PUB.apply( p_api_version => l_api_version

1363: ,p_trans_to_receipt_rate => l_trans_to_receipt_rate
1364: );
1365: log_debug('Return status of AR_RECEIPT_API_PUB.apply_in_detail = '|| l_return_status);
1366: ELSE
1367: AR_RECEIPT_API_PUB.apply( p_api_version => l_api_version
1368: ,p_init_msg_list => l_init_msg_list
1369: ,x_return_status => l_return_status
1370: ,x_msg_count => l_msg_count
1371: ,x_msg_data => l_msg_data

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

1377: ,p_trans_to_receipt_rate => l_trans_to_receipt_rate
1378: ,p_comments => NULL
1379: ,p_amount_applied => l_ar_llca_tbl(l_ar_llca_tbl.FIRST).amount_applied
1380: );
1381: log_debug('Return status of AR_RECEIPT_API_PUB.apply = '|| l_return_status);
1382: END IF;
1383:
1384: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1385: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

1562: CLOSE c_get_onacc_app_id;
1563:
1564: IF l_onacc_appplication_id IS NOT NULL THEN
1565: -- Unapply the on-account amount
1566: Ar_receipt_api_pub.Unapply_on_account( p_api_version => l_api_version,
1567: p_init_msg_list => l_init_msg_list,
1568: x_return_status => l_return_status ,
1569: x_msg_count => l_msg_count ,
1570: x_msg_data => l_msg_data,

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

1572: p_receivable_application_id =>l_onacc_appplication_id,
1573: p_reversal_gl_date => NULL,
1574: p_org_id => l_org_id
1575: );
1576: log_debug('Return status of AR_RECEIPT_API_PUB.Unapply_on_account = '|| l_return_status);
1577: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1578: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1579: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1580: RAISE OKL_API.G_EXCEPTION_ERROR;

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

1582: END IF;
1583: END IF;
1584: -- Check if any On-Account amount to be applied
1585: If ( Nvl(l_apply_onacc_amount,0) > 0 ) Then
1586: log_debug('Ar_receipt_api_pub.Apply_on_account l_cash_receipt_id '||l_cash_receipt_id);
1587: log_debug('Ar_receipt_api_pub.Apply_on_account l_apply_onacc_amount '||l_apply_onacc_amount);
1588: log_debug('Ar_receipt_api_pub.Apply_on_account l_rcpt_date '||l_rcpt_date);
1589: log_debug('Ar_receipt_api_pub.Apply_on_account l_gl_date '||l_gl_date);
1590: -- Apply the on-account amount

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

1583: END IF;
1584: -- Check if any On-Account amount to be applied
1585: If ( Nvl(l_apply_onacc_amount,0) > 0 ) Then
1586: log_debug('Ar_receipt_api_pub.Apply_on_account l_cash_receipt_id '||l_cash_receipt_id);
1587: log_debug('Ar_receipt_api_pub.Apply_on_account l_apply_onacc_amount '||l_apply_onacc_amount);
1588: log_debug('Ar_receipt_api_pub.Apply_on_account l_rcpt_date '||l_rcpt_date);
1589: log_debug('Ar_receipt_api_pub.Apply_on_account l_gl_date '||l_gl_date);
1590: -- Apply the on-account amount
1591: Ar_receipt_api_pub.Apply_on_account( p_api_version => l_api_version

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

1584: -- Check if any On-Account amount to be applied
1585: If ( Nvl(l_apply_onacc_amount,0) > 0 ) Then
1586: log_debug('Ar_receipt_api_pub.Apply_on_account l_cash_receipt_id '||l_cash_receipt_id);
1587: log_debug('Ar_receipt_api_pub.Apply_on_account l_apply_onacc_amount '||l_apply_onacc_amount);
1588: log_debug('Ar_receipt_api_pub.Apply_on_account l_rcpt_date '||l_rcpt_date);
1589: log_debug('Ar_receipt_api_pub.Apply_on_account l_gl_date '||l_gl_date);
1590: -- Apply the on-account amount
1591: Ar_receipt_api_pub.Apply_on_account( p_api_version => l_api_version
1592: ,p_init_msg_list => l_init_msg_list

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

1585: If ( Nvl(l_apply_onacc_amount,0) > 0 ) Then
1586: log_debug('Ar_receipt_api_pub.Apply_on_account l_cash_receipt_id '||l_cash_receipt_id);
1587: log_debug('Ar_receipt_api_pub.Apply_on_account l_apply_onacc_amount '||l_apply_onacc_amount);
1588: log_debug('Ar_receipt_api_pub.Apply_on_account l_rcpt_date '||l_rcpt_date);
1589: log_debug('Ar_receipt_api_pub.Apply_on_account l_gl_date '||l_gl_date);
1590: -- Apply the on-account amount
1591: Ar_receipt_api_pub.Apply_on_account( p_api_version => l_api_version
1592: ,p_init_msg_list => l_init_msg_list
1593: ,x_return_status => l_return_status

Line 1591: Ar_receipt_api_pub.Apply_on_account( p_api_version => l_api_version

1587: log_debug('Ar_receipt_api_pub.Apply_on_account l_apply_onacc_amount '||l_apply_onacc_amount);
1588: log_debug('Ar_receipt_api_pub.Apply_on_account l_rcpt_date '||l_rcpt_date);
1589: log_debug('Ar_receipt_api_pub.Apply_on_account l_gl_date '||l_gl_date);
1590: -- Apply the on-account amount
1591: Ar_receipt_api_pub.Apply_on_account( p_api_version => l_api_version
1592: ,p_init_msg_list => l_init_msg_list
1593: ,x_return_status => l_return_status
1594: ,x_msg_count => l_msg_count
1595: ,x_msg_data => l_msg_data

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

1598: ,p_apply_date => l_rcpt_date
1599: ,p_apply_gl_date => l_gl_date
1600: ,p_org_id => l_org_id
1601: );
1602: log_debug('Return status of AR_RECEIPT_API_PUB.Apply_on_account = '|| l_return_status);
1603: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1604: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1605: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1606: RAISE OKL_API.G_EXCEPTION_ERROR;

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

2288: FETCH c_get_onacc_app_id INTO l_onacc_appplication_id;
2289: CLOSE c_get_onacc_app_id;
2290:
2291: -- Unapply the on-account amount
2292: Ar_receipt_api_pub.Unapply_on_account( p_api_version => l_api_version,
2293: p_init_msg_list => l_init_msg_list,
2294: x_return_status => l_return_status ,
2295: x_msg_count => l_msg_count ,
2296: x_msg_data => l_msg_data,

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

2298: p_receivable_application_id =>l_onacc_appplication_id,
2299: p_reversal_gl_date => NULL,
2300: p_org_id => l_org_id
2301: );
2302: log_debug('Return status of AR_RECEIPT_API_PUB.Unapply_on_account = '|| l_return_status);
2303: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2304: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2305: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2306: RAISE OKL_API.G_EXCEPTION_ERROR;