DBA Data[Home] [Help]

APPS.OKL_ACTIVATE_IB_PVT dependencies on CSI_ITEM_INSTANCE_PUB

Line 1274: csi_item_instance_pub.create_item_instance(p_api_version => p_api_version,

1270: --l_txn_rec.transaction_id := FND_API.G_MISS_NUM;
1271:
1272: --call create item instance
1273: --dbms_output.put_line('before calling create item instance');
1274: csi_item_instance_pub.create_item_instance(p_api_version => p_api_version,
1275: p_commit => fnd_api.g_false,
1276: p_init_msg_list => p_init_msg_list,
1277: p_instance_rec => l_instance_rec,
1278: p_validation_level => fnd_api.g_valid_level_full,

Line 1788: csi_item_instance_pub.create_item_instance(p_api_version => p_api_version,

1784:
1785: --call create item instance
1786: --dbms_output.put_line('before calling create item instance');
1787:
1788: csi_item_instance_pub.create_item_instance(p_api_version => p_api_version,
1789: p_commit => fnd_api.g_false,
1790: p_init_msg_list => p_init_msg_list,
1791: p_instance_rec => l_instance_rec,
1792: p_validation_level => fnd_api.g_valid_level_full,

Line 2577: csi_item_instance_pub.get_item_instances (

2573:
2574: --3.0 Get original values from install base
2575: l_instance_query_rec.instance_id := to_number(l_ib_line_rec.object1_id1);
2576:
2577: csi_item_instance_pub.get_item_instances (
2578: p_api_version => p_api_version,
2579: p_commit => FND_API.G_FALSE,
2580: p_init_msg_list => FND_API.G_FALSE,
2581: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 2707: csi_item_instance_pub.update_item_instance

2703: END IF;
2704:
2705: l_instance_rec.instance_id := l_instance_header_rec.instance_id;
2706: l_instance_rec.object_version_number := l_instance_header_rec.object_version_number;
2707: csi_item_instance_pub.update_item_instance
2708: (
2709: p_api_version => p_api_version
2710: ,p_commit => fnd_api.g_false
2711: ,p_init_msg_list => p_init_msg_list

Line 3297: csi_item_instance_pub.get_item_instances (

3293:
3294: l_instance_query_rec.instance_id := srl_num_to_update_rec.instance_id;
3295: -- gboomina Bug 5362977 - End
3296:
3297: csi_item_instance_pub.get_item_instances (
3298: p_api_version => p_api_version,
3299: p_commit => FND_API.G_FALSE,
3300: p_init_msg_list => FND_API.G_FALSE,
3301: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 3348: csi_item_instance_pub.expire_item_instance

3344: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3345: RAISE OKL_API.G_EXCEPTION_ERROR;
3346: END IF;
3347:
3348: csi_item_instance_pub.expire_item_instance
3349: (
3350: p_api_version => p_api_version
3351: ,p_commit => fnd_api.g_false
3352: ,p_init_msg_list => p_init_msg_list

Line 3362: --okl_debug_pub.logmessage(' csi_item_instance_pub.update_item_instance x_return_status = ' || x_return_status);

3358: ,x_return_status => x_return_status
3359: ,x_msg_count => x_msg_count
3360: ,x_msg_data => x_msg_data);
3361:
3362: --okl_debug_pub.logmessage(' csi_item_instance_pub.update_item_instance x_return_status = ' || x_return_status);
3363: --dbms_output.put_line(' csi_item_instance_pub.update_item_instance x_return_status = ' || x_return_status);
3364: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3365: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3366: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 3363: --dbms_output.put_line(' csi_item_instance_pub.update_item_instance x_return_status = ' || x_return_status);

3359: ,x_msg_count => x_msg_count
3360: ,x_msg_data => x_msg_data);
3361:
3362: --okl_debug_pub.logmessage(' csi_item_instance_pub.update_item_instance x_return_status = ' || x_return_status);
3363: --dbms_output.put_line(' csi_item_instance_pub.update_item_instance x_return_status = ' || x_return_status);
3364: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3365: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3366: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3367: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 3473: csi_item_instance_pub.get_item_instances (

3469: l_instance_rec := l_instance_temp_rec;
3470:
3471: l_instance_query_rec.instance_id := to_number(srl_num_to_exp_rec.instance_id);
3472:
3473: csi_item_instance_pub.get_item_instances (
3474: p_api_version => p_api_version,
3475: p_commit => FND_API.G_FALSE,
3476: p_init_msg_list => FND_API.G_FALSE,
3477: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 3522: csi_item_instance_pub.expire_item_instance

3518: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3519: RAISE OKL_API.G_EXCEPTION_ERROR;
3520: END IF;
3521:
3522: csi_item_instance_pub.expire_item_instance
3523: (
3524: p_api_version => p_api_version
3525: ,p_commit => fnd_api.g_false
3526: ,p_init_msg_list => p_init_msg_list

Line 3536: --okl_debug_pub.logmessage('csi_item_instance_pub.expire_item_instance x_return_status= ' || x_return_status);

3532: ,x_return_status => x_return_status
3533: ,x_msg_count => x_msg_count
3534: ,x_msg_data => x_msg_data);
3535:
3536: --okl_debug_pub.logmessage('csi_item_instance_pub.expire_item_instance x_return_status= ' || x_return_status);
3537: --dbms_output.put_line('csi_item_instance_pub.expire_item_instance x_return_status= ' || x_return_status);
3538: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3539: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3540: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 3537: --dbms_output.put_line('csi_item_instance_pub.expire_item_instance x_return_status= ' || x_return_status);

3533: ,x_msg_count => x_msg_count
3534: ,x_msg_data => x_msg_data);
3535:
3536: --okl_debug_pub.logmessage('csi_item_instance_pub.expire_item_instance x_return_status= ' || x_return_status);
3537: --dbms_output.put_line('csi_item_instance_pub.expire_item_instance x_return_status= ' || x_return_status);
3538: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3539: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3540: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3541: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 3702: csi_item_instance_pub.get_item_instances (

3698: CLose ib_line_csr;
3699:
3700: l_instance_query_rec.instance_id := to_number(l_instance_id);
3701:
3702: csi_item_instance_pub.get_item_instances (
3703: p_api_version => p_api_version,
3704: p_commit => FND_API.G_FALSE,
3705: p_init_msg_list => FND_API.G_FALSE,
3706: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 3752: csi_item_instance_pub.update_item_instance

3748: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3749: RAISE OKL_API.G_EXCEPTION_ERROR;
3750: END IF;
3751:
3752: csi_item_instance_pub.update_item_instance
3753: (
3754: p_api_version => p_api_version
3755: ,p_commit => fnd_api.g_false
3756: ,p_init_msg_list => p_init_msg_list

Line 3813: csi_item_instance_pub.get_item_instances (

3809: l_upd_instance_rec := l_instance_temp_rec;
3810:
3811: l_instance_query_rec.instance_id := srl_num_to_update_rec.instance_id;
3812:
3813: csi_item_instance_pub.get_item_instances (
3814: p_api_version => p_api_version,
3815: p_commit => FND_API.G_FALSE,
3816: p_init_msg_list => FND_API.G_FALSE,
3817: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 3863: csi_item_instance_pub.update_item_instance

3859: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3860: RAISE OKL_API.G_EXCEPTION_ERROR;
3861: END IF;
3862:
3863: csi_item_instance_pub.update_item_instance
3864: (
3865: p_api_version => p_api_version
3866: ,p_commit => fnd_api.g_false
3867: ,p_init_msg_list => p_init_msg_list

Line 3883: --okl_debug_pub.logmessage('csi_item_instance_pub.update_item_instance 2 x_return_status= ' || x_return_status);

3879: ,x_msg_count => x_msg_count
3880: ,x_msg_data => x_msg_data
3881: );
3882:
3883: --okl_debug_pub.logmessage('csi_item_instance_pub.update_item_instance 2 x_return_status= ' || x_return_status);
3884: --dbms_output.put_line('csi_item_instance_pub.update_item_instance 2 x_return_status= ' || x_return_status);
3885: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3886: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3887: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 3884: --dbms_output.put_line('csi_item_instance_pub.update_item_instance 2 x_return_status= ' || x_return_status);

3880: ,x_msg_data => x_msg_data
3881: );
3882:
3883: --okl_debug_pub.logmessage('csi_item_instance_pub.update_item_instance 2 x_return_status= ' || x_return_status);
3884: --dbms_output.put_line('csi_item_instance_pub.update_item_instance 2 x_return_status= ' || x_return_status);
3885: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3886: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3887: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3888: RAISE OKL_API.G_EXCEPTION_ERROR;