DBA Data[Home] [Help]

APPS.CSI_ITEM_INSTANCE_PVT dependencies on CSI_COUNTER_TEMPLATE_PUB

Line 4556: l_ctr_id_template csi_counter_template_pub.ctr_template_autoinst_tbl;

4552: l_old_oks_cp_rec OKS_IBINT_PUB.CP_REC_TYPE;
4553: l_new_oks_cp_rec OKS_IBINT_PUB.CP_REC_TYPE;
4554: l_ctr_grp_id_template NUMBER;
4555: l_ctr_grp_id_instance NUMBER;
4556: l_ctr_id_template csi_counter_template_pub.ctr_template_autoinst_tbl;
4557: l_ctr_id_instance csi_counter_template_pub.counter_autoinstantiate_tbl;
4558: l_msg_count NUMBER;
4559: l_msg_data VARCHAR2(100);
4560: l_msg_index NUMBER;

Line 4557: l_ctr_id_instance csi_counter_template_pub.counter_autoinstantiate_tbl;

4553: l_new_oks_cp_rec OKS_IBINT_PUB.CP_REC_TYPE;
4554: l_ctr_grp_id_template NUMBER;
4555: l_ctr_grp_id_instance NUMBER;
4556: l_ctr_id_template csi_counter_template_pub.ctr_template_autoinst_tbl;
4557: l_ctr_id_instance csi_counter_template_pub.counter_autoinstantiate_tbl;
4558: l_msg_count NUMBER;
4559: l_msg_data VARCHAR2(100);
4560: l_msg_index NUMBER;
4561: l_line_count NUMBER;

Line 6116: -- Since the replacement API CSI_COUNTER_TEMPLATE_PUB does not

6112: -- by rtalluri for the enh. 2308703
6113: IF NOT((l_serial_control IN (1,6)) AND
6114: (p_instance_rec.location_type_code = 'INVENTORY')) THEN
6115:
6116: -- Since the replacement API CSI_COUNTER_TEMPLATE_PUB does not
6117: -- for CS_Counters_PUB.Ctr_Grp_Template_Exists
6118: -- does not provide a function Ctr_Grp_Template_Exists,
6119: -- Hence writing the following code...
6120: --l_counter_group_id := NULL;

Line 6140: csi_counter_template_pub.autoinstantiate_counters

6136: CS_Counters_PUB.AutoInstantiate_Counters */
6137: IF l_counter_group_id <> 0
6138: THEN
6139: -- CS_Counters_PUB.AutoInstantiate_Counters
6140: csi_counter_template_pub.autoinstantiate_counters
6141: ( p_api_version => 1.0
6142: ,p_init_msg_list => FND_API.G_FALSE
6143: ,p_commit => FND_API.G_FALSE
6144: ,x_return_status => x_return_status

Line 6159: FND_MESSAGE.SET_TOKEN('COUNTER','CSI_COUNTER_TEMPLATE_PUB.AUTOINSTANTIATE_COUNTERS');

6155:
6156: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS)
6157: THEN
6158: FND_MESSAGE.SET_NAME('CSI','CSI_API_NO_COUNTER_ASSOCIATION');
6159: FND_MESSAGE.SET_TOKEN('COUNTER','CSI_COUNTER_TEMPLATE_PUB.AUTOINSTANTIATE_COUNTERS');
6160: FND_MSG_PUB.Add;
6161: RAISE FND_API.G_EXC_ERROR;
6162: END IF;
6163: -- srramakr Bug # 2255391. In CTO, since the configured item is created as a part of Sales Order

Line 6191: csi_counter_template_pub.create_item_association

6187: l_ctr_item_associations_rec.group_id := ctr_rec.group_id;
6188: l_ctr_item_associations_rec.inventory_item_id := p_instance_rec.inventory_item_id;
6189:
6190: --CS_Counters_PUB.Create_Ctr_Association
6191: csi_counter_template_pub.create_item_association
6192: (p_api_version => 1.0
6193: ,p_commit => fnd_api.g_false
6194: ,p_init_msg_list => fnd_api.g_false
6195: ,p_validation_level => p_validation_level

Line 6207: csi_counter_template_pub.autoinstantiate_counters

6203: --
6204: --IF CS_Counters_PUB.Ctr_Grp_Template_Exists(p_instance_rec.inventory_item_id) THEN
6205: IF l_counter_group_id <> 0 THEN
6206:
6207: csi_counter_template_pub.autoinstantiate_counters
6208: ( p_api_version => 1.0
6209: ,p_init_msg_list => FND_API.G_FALSE
6210: ,p_commit => FND_API.G_FALSE
6211: ,x_return_status => x_return_status

Line 6224: FND_MESSAGE.SET_TOKEN('COUNTER','CSI_COUNTER_TEMPLATE_PUB.AUTOINSTANTIATE_COUNTERS');

6220: ,p_organization_id => l_last_vld_organization_id -- srramakr. should pass the organization_id
6221: );
6222: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6223: FND_MESSAGE.SET_NAME('CSI','CSI_API_NO_COUNTER_ASSOCIATION');
6224: FND_MESSAGE.SET_TOKEN('COUNTER','CSI_COUNTER_TEMPLATE_PUB.AUTOINSTANTIATE_COUNTERS');
6225: FND_MSG_PUB.Add;
6226: RAISE FND_API.G_EXC_ERROR;
6227: END IF; -- return status
6228: END IF; -- ctr. grp template exists1

Line 11430: l_ctr_id_template csi_counter_template_pub.ctr_template_autoinst_tbl;

11426: l_exists_flag VARCHAR2(1);
11427: l_valid_flag VARCHAR2(1);
11428: l_ctr_grp_id_template NUMBER;
11429: l_ctr_grp_id_instance NUMBER;
11430: l_ctr_id_template csi_counter_template_pub.ctr_template_autoinst_tbl;
11431: l_ctr_id_instance csi_counter_template_pub.counter_autoinstantiate_tbl;
11432: l_base_item_id NUMBER;
11433: l_ctr_association_id NUMBER;
11434: l_association_type VARCHAR2(30) := 'PROD_ITEM';

Line 11431: l_ctr_id_instance csi_counter_template_pub.counter_autoinstantiate_tbl;

11427: l_valid_flag VARCHAR2(1);
11428: l_ctr_grp_id_template NUMBER;
11429: l_ctr_grp_id_instance NUMBER;
11430: l_ctr_id_template csi_counter_template_pub.ctr_template_autoinst_tbl;
11431: l_ctr_id_instance csi_counter_template_pub.counter_autoinstantiate_tbl;
11432: l_base_item_id NUMBER;
11433: l_ctr_association_id NUMBER;
11434: l_association_type VARCHAR2(30) := 'PROD_ITEM';
11435: -- l_desc_flex CS_COUNTERS_EXT_PVT.DFF_Rec_Type;

Line 14373: -- Since the replacement API CSI_COUNTER_TEMPLATE_PUB

14369: (p_instance_rec.accounting_class_code = 'CUST_PROD' AND
14370: p_instance_rec.accounting_class_code <> l_curr_instance_rec.accounting_class_code) ) THEN
14371: IF NOT((l_serial_control IN (1,6)) AND
14372: (l_get_instance_rec.location_type_code = 'INVENTORY')) THEN
14373: -- Since the replacement API CSI_COUNTER_TEMPLATE_PUB
14374: -- for CS_Counters_PUB.Ctr_Grp_Template_Exists
14375: -- does not provide a function Ctr_Grp_Template_Exists,
14376: -- Hence writing the following code...
14377: --l_counter_group_id := NULL;

Line 14412: csi_counter_template_pub.autoinstantiate_counters

14408: FND_File.Put_Line(Fnd_File.LOG,'Calling counter instantiate');
14409:
14410: csi_gen_utility_pvt.put_line('Calling Autoinstantiate counters');
14411:
14412: csi_counter_template_pub.autoinstantiate_counters
14413: ( p_api_version => 1.0
14414: ,p_init_msg_list => FND_API.G_FALSE
14415: ,p_commit => FND_API.G_FALSE
14416: ,x_return_status => x_return_status

Line 14431: FND_MESSAGE.SET_TOKEN('COUNTER','CSI_COUNTER_TEMPLATE_PUB.AUTOINSTANTIATE_COUNTERS');

14427:
14428: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS)
14429: THEN
14430: FND_MESSAGE.SET_NAME('CSI','CSI_API_NO_COUNTER_ASSOCIATION');
14431: FND_MESSAGE.SET_TOKEN('COUNTER','CSI_COUNTER_TEMPLATE_PUB.AUTOINSTANTIATE_COUNTERS');
14432: FND_MSG_PUB.Add;
14433: RAISE FND_API.G_EXC_ERROR;
14434: END IF;
14435: END IF;

Line 14464: csi_counter_template_pub.create_item_association

14460: Begin
14461: l_ctr_item_associations_rec.group_id := ctr_rec.group_id;
14462: l_ctr_item_associations_rec.inventory_item_id := l_get_instance_rec.inventory_item_id;
14463:
14464: csi_counter_template_pub.create_item_association
14465: (p_api_version => 1.0
14466: ,p_commit => fnd_api.g_false
14467: ,p_init_msg_list => fnd_api.g_false
14468: ,p_validation_level => p_validation_level

Line 14482: csi_counter_template_pub.autoinstantiate_counters

14478: -- IF CS_Counters_PUB.Ctr_Grp_Template_Exists(l_get_instance_rec.inventory_item_id) THEN
14479: IF l_counter_group_id <> 0
14480: THEN
14481:
14482: csi_counter_template_pub.autoinstantiate_counters
14483: ( p_api_version => 1.0
14484: ,p_init_msg_list => FND_API.G_FALSE
14485: ,p_commit => FND_API.G_FALSE
14486: ,x_return_status => x_return_status

Line 14499: FND_MESSAGE.SET_TOKEN('COUNTER','CSI_COUNTER_TEMPLATE_PUB.AUTOINSTANTIATE_COUNTERS');

14495: ,p_organization_id => l_last_vld_organization_id -- srramakr. should pass the organization_id
14496: );
14497: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
14498: FND_MESSAGE.SET_NAME('CSI','CSI_API_NO_COUNTER_ASSOCIATION');
14499: FND_MESSAGE.SET_TOKEN('COUNTER','CSI_COUNTER_TEMPLATE_PUB.AUTOINSTANTIATE_COUNTERS');
14500: FND_MSG_PUB.Add;
14501: RAISE FND_API.G_EXC_ERROR;
14502: END IF;
14503: END IF; -- COunter template existance check for the new item