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 2604: csi_item_instance_pub.get_item_instances (

2600:
2601: --3.0 Get original values from install base
2602: l_instance_query_rec.instance_id := to_number(l_ib_line_rec.object1_id1);
2603:
2604: csi_item_instance_pub.get_item_instances (
2605: p_api_version => p_api_version,
2606: p_commit => FND_API.G_FALSE,
2607: p_init_msg_list => FND_API.G_FALSE,
2608: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 2734: csi_item_instance_pub.update_item_instance

2730: END IF;
2731:
2732: l_instance_rec.instance_id := l_instance_header_rec.instance_id;
2733: l_instance_rec.object_version_number := l_instance_header_rec.object_version_number;
2734: csi_item_instance_pub.update_item_instance
2735: (
2736: p_api_version => p_api_version
2737: ,p_commit => fnd_api.g_false
2738: ,p_init_msg_list => p_init_msg_list

Line 3334: csi_item_instance_pub.get_item_instances (

3330:
3331: l_instance_query_rec.instance_id := srl_num_to_update_rec.instance_id;
3332: -- gboomina Bug 5362977 - End
3333:
3334: csi_item_instance_pub.get_item_instances (
3335: p_api_version => p_api_version,
3336: p_commit => FND_API.G_FALSE,
3337: p_init_msg_list => FND_API.G_FALSE,
3338: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 3385: csi_item_instance_pub.expire_item_instance

3381: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3382: RAISE OKL_API.G_EXCEPTION_ERROR;
3383: END IF;
3384:
3385: csi_item_instance_pub.expire_item_instance
3386: (
3387: p_api_version => p_api_version
3388: ,p_commit => fnd_api.g_false
3389: ,p_init_msg_list => p_init_msg_list

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

3395: ,x_return_status => x_return_status
3396: ,x_msg_count => x_msg_count
3397: ,x_msg_data => x_msg_data);
3398:
3399: --okl_debug_pub.logmessage(' csi_item_instance_pub.update_item_instance x_return_status = ' || x_return_status);
3400: --dbms_output.put_line(' csi_item_instance_pub.update_item_instance x_return_status = ' || x_return_status);
3401: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3402: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3403: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

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

3396: ,x_msg_count => x_msg_count
3397: ,x_msg_data => x_msg_data);
3398:
3399: --okl_debug_pub.logmessage(' csi_item_instance_pub.update_item_instance x_return_status = ' || x_return_status);
3400: --dbms_output.put_line(' csi_item_instance_pub.update_item_instance x_return_status = ' || x_return_status);
3401: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3402: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3403: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3404: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 3510: csi_item_instance_pub.get_item_instances (

3506: l_instance_rec := l_instance_temp_rec;
3507:
3508: l_instance_query_rec.instance_id := to_number(srl_num_to_exp_rec.instance_id);
3509:
3510: csi_item_instance_pub.get_item_instances (
3511: p_api_version => p_api_version,
3512: p_commit => FND_API.G_FALSE,
3513: p_init_msg_list => FND_API.G_FALSE,
3514: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 3559: csi_item_instance_pub.expire_item_instance

3555: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3556: RAISE OKL_API.G_EXCEPTION_ERROR;
3557: END IF;
3558:
3559: csi_item_instance_pub.expire_item_instance
3560: (
3561: p_api_version => p_api_version
3562: ,p_commit => fnd_api.g_false
3563: ,p_init_msg_list => p_init_msg_list

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

3569: ,x_return_status => x_return_status
3570: ,x_msg_count => x_msg_count
3571: ,x_msg_data => x_msg_data);
3572:
3573: --okl_debug_pub.logmessage('csi_item_instance_pub.expire_item_instance x_return_status= ' || x_return_status);
3574: --dbms_output.put_line('csi_item_instance_pub.expire_item_instance x_return_status= ' || x_return_status);
3575: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3576: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3577: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

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

3570: ,x_msg_count => x_msg_count
3571: ,x_msg_data => x_msg_data);
3572:
3573: --okl_debug_pub.logmessage('csi_item_instance_pub.expire_item_instance x_return_status= ' || x_return_status);
3574: --dbms_output.put_line('csi_item_instance_pub.expire_item_instance x_return_status= ' || x_return_status);
3575: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3576: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3577: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3578: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 3739: csi_item_instance_pub.get_item_instances (

3735: CLose ib_line_csr;
3736:
3737: l_instance_query_rec.instance_id := to_number(l_instance_id);
3738:
3739: csi_item_instance_pub.get_item_instances (
3740: p_api_version => p_api_version,
3741: p_commit => FND_API.G_FALSE,
3742: p_init_msg_list => FND_API.G_FALSE,
3743: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 3789: csi_item_instance_pub.update_item_instance

3785: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3786: RAISE OKL_API.G_EXCEPTION_ERROR;
3787: END IF;
3788:
3789: csi_item_instance_pub.update_item_instance
3790: (
3791: p_api_version => p_api_version
3792: ,p_commit => fnd_api.g_false
3793: ,p_init_msg_list => p_init_msg_list

Line 3850: csi_item_instance_pub.get_item_instances (

3846: l_upd_instance_rec := l_instance_temp_rec;
3847:
3848: l_instance_query_rec.instance_id := srl_num_to_update_rec.instance_id;
3849:
3850: csi_item_instance_pub.get_item_instances (
3851: p_api_version => p_api_version,
3852: p_commit => FND_API.G_FALSE,
3853: p_init_msg_list => FND_API.G_FALSE,
3854: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 3900: csi_item_instance_pub.update_item_instance

3896: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3897: RAISE OKL_API.G_EXCEPTION_ERROR;
3898: END IF;
3899:
3900: csi_item_instance_pub.update_item_instance
3901: (
3902: p_api_version => p_api_version
3903: ,p_commit => fnd_api.g_false
3904: ,p_init_msg_list => p_init_msg_list

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

3916: ,x_msg_count => x_msg_count
3917: ,x_msg_data => x_msg_data
3918: );
3919:
3920: --okl_debug_pub.logmessage('csi_item_instance_pub.update_item_instance 2 x_return_status= ' || x_return_status);
3921: --dbms_output.put_line('csi_item_instance_pub.update_item_instance 2 x_return_status= ' || x_return_status);
3922: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3923: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3924: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

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

3917: ,x_msg_data => x_msg_data
3918: );
3919:
3920: --okl_debug_pub.logmessage('csi_item_instance_pub.update_item_instance 2 x_return_status= ' || x_return_status);
3921: --dbms_output.put_line('csi_item_instance_pub.update_item_instance 2 x_return_status= ' || x_return_status);
3922: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3923: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3924: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3925: RAISE OKL_API.G_EXCEPTION_ERROR;