DBA Data[Home] [Help]

APPS.EGO_ITEM_PUB dependencies on EGO_ITEM_PVT

Line 189: EGO_Item_PVT.G_Item_Tbl := l_item_tbl;

185: END IF;
186: l_tab_index := l_tab_index + 1;
187: END LOOP;
188:
189: EGO_Item_PVT.G_Item_Tbl := l_item_tbl;
190:
191: /* Below code is added as the process_items is not used in HTML/EXCEL etc,
192: so madating this to be API flow only */
193: INV_EGO_REVISION_VALIDATE.Set_Process_Control_HTML_API('API'); -- Bug 9852661

Line 199: EGO_Item_PVT.Process_Items (

195: -- Call the Private API to process items table.
196: /* Below code is added as the process_items is not used in HTML/EXCEL etc,
197: so madating this to be API flow only */
198: INV_EGO_REVISION_VALIDATE.Set_Process_Control_HTML_API('API'); -- Bug 12669090
199: EGO_Item_PVT.Process_Items (
200: p_commit => p_commit
201: ,x_return_status => l_return_status
202: ,x_msg_count => x_msg_count );
203:

Line 205: x_Item_Tbl := EGO_Item_PVT.G_Item_Tbl;

201: ,x_return_status => l_return_status
202: ,x_msg_count => x_msg_count );
203:
204: x_return_status := l_return_status;
205: x_Item_Tbl := EGO_Item_PVT.G_Item_Tbl;
206:
207: EXCEPTION
208: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
209: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 212: EGO_Item_Msg.Add_Error_Message ( EGO_Item_PVT.G_Item_indx, 'INV', 'INV_ITEM_UNEXPECTED_ERROR',

208: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
209: x_return_status := G_RET_STS_UNEXP_ERROR;
210: WHEN others THEN
211: x_return_status := G_RET_STS_UNEXP_ERROR;
212: EGO_Item_Msg.Add_Error_Message ( EGO_Item_PVT.G_Item_indx, 'INV', 'INV_ITEM_UNEXPECTED_ERROR',
213: 'PACKAGE_NAME', G_PKG_NAME, FALSE,
214: 'PROCEDURE_NAME', l_api_name, FALSE,
215: 'ERROR_TEXT', SQLERRM, FALSE );
216: END Process_Items;

Line 1579: EGO_Item_PVT.G_Item_Tbl := l_item_tbl;

1575: l_Revision_Tbl(indx).Attribute13 := p_rev_attribute13;
1576: l_Revision_Tbl(indx).Attribute14 := p_rev_attribute14;
1577: l_Revision_Tbl(indx).Attribute15 := p_rev_attribute15;
1578:
1579: EGO_Item_PVT.G_Item_Tbl := l_item_tbl;
1580: EGO_Item_PVT.G_Revision_Tbl := l_Revision_Tbl;
1581:
1582: /* Added to fix Bug#8434681 : Variable G_Process_Control_HTML_API in package INV_EGO_REVISION_VALIDATE is set to API to apply template
1583: when this procedure is being called from the following paths: 1. open API, 2. excel import, 3. concurrent request (item batch import)

Line 1580: EGO_Item_PVT.G_Revision_Tbl := l_Revision_Tbl;

1576: l_Revision_Tbl(indx).Attribute14 := p_rev_attribute14;
1577: l_Revision_Tbl(indx).Attribute15 := p_rev_attribute15;
1578:
1579: EGO_Item_PVT.G_Item_Tbl := l_item_tbl;
1580: EGO_Item_PVT.G_Revision_Tbl := l_Revision_Tbl;
1581:
1582: /* Added to fix Bug#8434681 : Variable G_Process_Control_HTML_API in package INV_EGO_REVISION_VALIDATE is set to API to apply template
1583: when this procedure is being called from the following paths: 1. open API, 2. excel import, 3. concurrent request (item batch import)
1584: This variable also prevents the application of the template if the code is being called from HTML pages since template is already pre-applied there*/

Line 1601: EGO_Item_PVT.Process_Items (

1597:
1598:
1599: INV_EGO_REVISION_VALIDATE.Set_Process_Control(NVL(p_process_control,'PLM_UI:Y'));--Bug:3777954
1600:
1601: EGO_Item_PVT.Process_Items (
1602: p_commit => p_commit
1603: ,x_return_status => x_return_status
1604: ,x_msg_count => x_msg_count);
1605:

Line 1610: l_item_created_tbl := EGO_Item_PVT.G_Item_Tbl;

1606: x_msg_data := FND_MESSAGE.get; --Retrieving error message in the case of p_process_control = "Interface_Handler"
1607:
1608: INV_EGO_REVISION_VALIDATE.Set_Process_Control(NULL);
1609:
1610: l_item_created_tbl := EGO_Item_PVT.G_Item_Tbl;
1611:
1612: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND l_item_tbl(indx).process_item_record = 1 THEN
1613:
1614: x_inventory_item_id := l_item_created_tbl(indx).inventory_item_id;

Line 1651: --EGO_Item_PVT.Process_Items returns the status which is correct, please donot override that.

1647: IF FND_API.To_Boolean(p_commit) THEN
1648: COMMIT WORK;
1649: END IF;
1650:
1651: --EGO_Item_PVT.Process_Items returns the status which is correct, please donot override that.
1652: --x_return_status := G_RET_STS_SUCCESS;
1653: --Bug 5997870.. Clear the values before returning so that it does not stick around till next call..
1654: Clear_Object_Version_Values;
1655:

Line 1724: EGO_Item_PVT.G_Item_Org_Assignment_Tbl := p_Item_Org_Assignment_Tbl;

1720: -- Set business object identifier in the System Information record
1721: Error_Handler.Set_BO_Identifier ( p_bo_identifier => G_BO_Identifier );
1722:
1723: -- Store item org assignment data in the global table
1724: EGO_Item_PVT.G_Item_Org_Assignment_Tbl := p_Item_Org_Assignment_Tbl;
1725:
1726: EGO_Item_PVT.Process_Item_Org_Assignments(
1727: p_commit => p_commit
1728: , x_return_status => l_return_status

Line 1726: EGO_Item_PVT.Process_Item_Org_Assignments(

1722:
1723: -- Store item org assignment data in the global table
1724: EGO_Item_PVT.G_Item_Org_Assignment_Tbl := p_Item_Org_Assignment_Tbl;
1725:
1726: EGO_Item_PVT.Process_Item_Org_Assignments(
1727: p_commit => p_commit
1728: , x_return_status => l_return_status
1729: , x_msg_count => x_msg_count);
1730:

Line 1738: EGO_Item_Msg.Add_Error_Message ( EGO_Item_PVT.G_Item_Org_indx, 'INV', 'INV_ITEM_UNEXPECTED_ERROR',

1734: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
1735: x_return_status := G_RET_STS_UNEXP_ERROR;
1736: WHEN others THEN
1737: x_return_status := G_RET_STS_UNEXP_ERROR;
1738: EGO_Item_Msg.Add_Error_Message ( EGO_Item_PVT.G_Item_Org_indx, 'INV', 'INV_ITEM_UNEXPECTED_ERROR',
1739: 'PACKAGE_NAME', G_PKG_NAME, FALSE,
1740: 'PROCEDURE_NAME', l_api_name, FALSE,
1741: 'ERROR_TEXT', SQLERRM, FALSE );
1742: END Process_Item_Org_Assignments;

Line 2053: EGO_Item_PVT.Seed_Item_Long_Desc_Attr_Group(

2049: ,x_msg_data OUT NOCOPY VARCHAR2)IS
2050:
2051: BEGIN
2052:
2053: EGO_Item_PVT.Seed_Item_Long_Desc_Attr_Group(
2054: p_inventory_item_id => p_inventory_item_id
2055: ,p_organization_id => p_organization_id
2056: ,p_item_catalog_group_id => p_item_catalog_group_id
2057: ,x_return_status => x_return_status

Line 2078: EGO_Item_PVT.Seed_Item_Long_Desc_In_Bulk(

2074: ) IS
2075:
2076: BEGIN
2077:
2078: EGO_Item_PVT.Seed_Item_Long_Desc_In_Bulk(
2079: p_set_process_id => p_set_process_id
2080: ,x_return_status => x_return_status
2081: ,x_msg_data => x_msg_data
2082: );

Line 2116: EGO_ITEM_PVT.Process_User_Attrs_For_Item(

2112: ) IS
2113:
2114: BEGIN
2115:
2116: EGO_ITEM_PVT.Process_User_Attrs_For_Item(
2117: p_api_version => p_api_version
2118: ,p_inventory_item_id => p_inventory_item_id
2119: ,p_organization_id => p_organization_id
2120: ,p_attributes_row_table => p_attributes_row_table

Line 2165: EGO_ITEM_PVT.Get_User_Attrs_For_Item(

2161: ) IS
2162:
2163: BEGIN
2164:
2165: EGO_ITEM_PVT.Get_User_Attrs_For_Item(
2166: p_api_version => p_api_version
2167: ,p_inventory_item_id => p_inventory_item_id
2168: ,p_organization_id => p_organization_id
2169: ,p_attr_group_request_table => p_attr_group_request_table

Line 4438: EGO_ITEM_PVT.Process_item_role

4434: ,x_msg_count OUT NOCOPY NUMBER
4435: ,x_msg_data OUT NOCOPY VARCHAR2
4436: ) IS
4437: BEGIN
4438: EGO_ITEM_PVT.Process_item_role
4439: (p_api_version => p_api_version
4440: ,p_commit => p_commit
4441: ,p_init_msg_list => p_init_msg_list
4442: ,p_transaction_type => p_transaction_type

Line 4488: EGO_ITEM_PVT.Process_item_phase_and_status

4484: ,x_msg_count OUT NOCOPY NUMBER
4485: ,x_msg_data OUT NOCOPY VARCHAR2
4486: ) IS
4487: BEGIN
4488: EGO_ITEM_PVT.Process_item_phase_and_status
4489: (p_api_version => p_api_version
4490: ,p_commit => p_commit
4491: ,p_init_msg_list => p_init_msg_list
4492: ,p_transaction_type => p_transaction_type

Line 4527: EGO_ITEM_PVT.Implement_Item_Pending_Changes

4523: ,x_msg_count OUT NOCOPY NUMBER
4524: ,x_msg_data OUT NOCOPY VARCHAR2
4525: ) IS
4526: BEGIN
4527: EGO_ITEM_PVT.Implement_Item_Pending_Changes
4528: (p_api_version => p_api_version
4529: ,p_commit => p_commit
4530: ,p_init_msg_list => p_init_msg_list
4531: ,p_inventory_item_id => p_inventory_item_id

Line 4760: EGO_Item_Msg.Add_Error_Message ( EGO_Item_PVT.G_Item_indx,

4756: EXCEPTION
4757: WHEN others THEN
4758: l_err_text := SUBSTRB(SQLERRM, 1,240);
4759: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
4760: EGO_Item_Msg.Add_Error_Message ( EGO_Item_PVT.G_Item_indx,
4761: 'INV', 'INV_ITEM_UNEXPECTED_ERROR',
4762: 'PACKAGE_NAME', G_PKG_NAME, FALSE,
4763: 'PROCEDURE_NAME', l_api_name, FALSE,
4764: 'ERROR_TEXT', l_err_text, FALSE );

Line 4816: EGO_Item_Msg.Add_Error_Message (p_Entity_Index => EGO_Item_PVT.G_Item_indx,

4812: ,p_instance_pk1_value => p_inventory_item_id
4813: ,p_instance_pk2_value => p_organization_id
4814: ,P_User_Id => FND_GLOBAL.user_id) <> 'T'
4815: THEN
4816: EGO_Item_Msg.Add_Error_Message (p_Entity_Index => EGO_Item_PVT.G_Item_indx,
4817: p_Application_Short_Name =>'INV',
4818: p_Message_Name =>'INV_IOI_ITEM_UPDATE_PRIV');
4819: RAISE FND_API.g_EXC_ERROR;
4820: ELSE

Line 4885: EGO_Item_Msg.Add_Error_Message ( EGO_Item_PVT.G_Item_indx,

4881: );
4882: WHEN others THEN
4883: l_err_text := SUBSTRB(SQLERRM, 1,240);
4884: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
4885: EGO_Item_Msg.Add_Error_Message ( EGO_Item_PVT.G_Item_indx,
4886: 'INV', 'INV_ITEM_UNEXPECTED_ERROR',
4887: 'PACKAGE_NAME', G_PKG_NAME, FALSE,
4888: 'PROCEDURE_NAME', l_api_name, FALSE,
4889: 'ERROR_TEXT', l_err_text, FALSE );

Line 4950: EGO_ITEM_PVT.Validate_Required_Attrs(

4946: ) IS
4947:
4948: BEGIN
4949:
4950: EGO_ITEM_PVT.Validate_Required_Attrs(
4951: p_api_version => p_api_version
4952: ,p_inventory_item_id => p_inventory_item_id
4953: ,p_organization_id => p_organization_id
4954: ,p_revision_id => p_revision_id

Line 4990: EGO_ITEM_MSG.Add_Error_Message ( EGO_ITEM_PVT.G_ITEM_INDX,

4986: EXCEPTION
4987: WHEN OTHERS THEN
4988: l_err_text := SUBSTRB(SQLERRM, 1,240);
4989: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4990: EGO_ITEM_MSG.Add_Error_Message ( EGO_ITEM_PVT.G_ITEM_INDX,
4991: 'EGO', 'EGO_ITEM_UNEXPECTED_ERROR',
4992: 'PACKAGE_NAME', G_PKG_NAME, FALSE,
4993: 'PROCEDURE_NAME', l_api_name, FALSE,
4994: 'ERROR_TEXT', l_err_text, FALSE );