DBA Data[Home] [Help]

APPS.EGO_ITEM_PUB dependencies on EGO_ITEM_PVT

Line 186: EGO_Item_PVT.G_Item_Tbl := l_item_tbl;

182: END IF;
183: l_tab_index := l_tab_index + 1;
184: END LOOP;
185:
186: EGO_Item_PVT.G_Item_Tbl := l_item_tbl;
187:
188: -- Call the Private API to process items table.
189:
190: EGO_Item_PVT.Process_Items (

Line 190: EGO_Item_PVT.Process_Items (

186: EGO_Item_PVT.G_Item_Tbl := l_item_tbl;
187:
188: -- Call the Private API to process items table.
189:
190: EGO_Item_PVT.Process_Items (
191: p_commit => p_commit
192: ,x_return_status => l_return_status
193: ,x_msg_count => x_msg_count );
194:

Line 196: x_Item_Tbl := EGO_Item_PVT.G_Item_Tbl;

192: ,x_return_status => l_return_status
193: ,x_msg_count => x_msg_count );
194:
195: x_return_status := l_return_status;
196: x_Item_Tbl := EGO_Item_PVT.G_Item_Tbl;
197:
198: EXCEPTION
199: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
200: x_return_status := G_RET_STS_UNEXP_ERROR;

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

199: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
200: x_return_status := G_RET_STS_UNEXP_ERROR;
201: WHEN others THEN
202: x_return_status := G_RET_STS_UNEXP_ERROR;
203: EGO_Item_Msg.Add_Error_Message ( EGO_Item_PVT.G_Item_indx, 'INV', 'INV_ITEM_UNEXPECTED_ERROR',
204: 'PACKAGE_NAME', G_PKG_NAME, FALSE,
205: 'PROCEDURE_NAME', l_api_name, FALSE,
206: 'ERROR_TEXT', SQLERRM, FALSE );
207: END Process_Items;

Line 1521: EGO_Item_PVT.G_Item_Tbl := l_item_tbl;

1517: l_Revision_Tbl(indx).Attribute13 := p_rev_attribute13;
1518: l_Revision_Tbl(indx).Attribute14 := p_rev_attribute14;
1519: l_Revision_Tbl(indx).Attribute15 := p_rev_attribute15;
1520:
1521: EGO_Item_PVT.G_Item_Tbl := l_item_tbl;
1522: EGO_Item_PVT.G_Revision_Tbl := l_Revision_Tbl;
1523:
1524: INV_EGO_REVISION_VALIDATE.Set_Process_Control(NVL(p_process_control,'PLM_UI:Y'));--Bug:3777954
1525:

Line 1522: EGO_Item_PVT.G_Revision_Tbl := l_Revision_Tbl;

1518: l_Revision_Tbl(indx).Attribute14 := p_rev_attribute14;
1519: l_Revision_Tbl(indx).Attribute15 := p_rev_attribute15;
1520:
1521: EGO_Item_PVT.G_Item_Tbl := l_item_tbl;
1522: EGO_Item_PVT.G_Revision_Tbl := l_Revision_Tbl;
1523:
1524: INV_EGO_REVISION_VALIDATE.Set_Process_Control(NVL(p_process_control,'PLM_UI:Y'));--Bug:3777954
1525:
1526: EGO_Item_PVT.Process_Items (

Line 1526: EGO_Item_PVT.Process_Items (

1522: EGO_Item_PVT.G_Revision_Tbl := l_Revision_Tbl;
1523:
1524: INV_EGO_REVISION_VALIDATE.Set_Process_Control(NVL(p_process_control,'PLM_UI:Y'));--Bug:3777954
1525:
1526: EGO_Item_PVT.Process_Items (
1527: p_commit => p_commit
1528: ,x_return_status => x_return_status
1529: ,x_msg_count => x_msg_count);
1530:

Line 1535: l_item_created_tbl := EGO_Item_PVT.G_Item_Tbl;

1531: x_msg_data := FND_MESSAGE.get; --Retrieving error message in the case of p_process_control = "Interface_Handler"
1532:
1533: INV_EGO_REVISION_VALIDATE.Set_Process_Control(NULL);
1534:
1535: l_item_created_tbl := EGO_Item_PVT.G_Item_Tbl;
1536:
1537: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND l_item_tbl(indx).process_item_record = 1 THEN
1538:
1539: x_inventory_item_id := l_item_created_tbl(indx).inventory_item_id;

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

1565: IF FND_API.To_Boolean(p_commit) THEN
1566: COMMIT WORK;
1567: END IF;
1568:
1569: --EGO_Item_PVT.Process_Items returns the status which is correct, please donot override that.
1570: --x_return_status := G_RET_STS_SUCCESS;
1571: --Bug 5997870.. Clear the values before returning so that it does not stick around till next call..
1572: Clear_Object_Version_Values;
1573:

Line 1642: EGO_Item_PVT.G_Item_Org_Assignment_Tbl := p_Item_Org_Assignment_Tbl;

1638: -- Set business object identifier in the System Information record
1639: Error_Handler.Set_BO_Identifier ( p_bo_identifier => G_BO_Identifier );
1640:
1641: -- Store item org assignment data in the global table
1642: EGO_Item_PVT.G_Item_Org_Assignment_Tbl := p_Item_Org_Assignment_Tbl;
1643:
1644: EGO_Item_PVT.Process_Item_Org_Assignments(
1645: p_commit => p_commit
1646: , x_return_status => l_return_status

Line 1644: EGO_Item_PVT.Process_Item_Org_Assignments(

1640:
1641: -- Store item org assignment data in the global table
1642: EGO_Item_PVT.G_Item_Org_Assignment_Tbl := p_Item_Org_Assignment_Tbl;
1643:
1644: EGO_Item_PVT.Process_Item_Org_Assignments(
1645: p_commit => p_commit
1646: , x_return_status => l_return_status
1647: , x_msg_count => x_msg_count);
1648:

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

1652: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
1653: x_return_status := G_RET_STS_UNEXP_ERROR;
1654: WHEN others THEN
1655: x_return_status := G_RET_STS_UNEXP_ERROR;
1656: EGO_Item_Msg.Add_Error_Message ( EGO_Item_PVT.G_Item_Org_indx, 'INV', 'INV_ITEM_UNEXPECTED_ERROR',
1657: 'PACKAGE_NAME', G_PKG_NAME, FALSE,
1658: 'PROCEDURE_NAME', l_api_name, FALSE,
1659: 'ERROR_TEXT', SQLERRM, FALSE );
1660: END Process_Item_Org_Assignments;

Line 1906: EGO_Item_PVT.Seed_Item_Long_Desc_Attr_Group(

1902: ,x_msg_data OUT NOCOPY VARCHAR2)IS
1903:
1904: BEGIN
1905:
1906: EGO_Item_PVT.Seed_Item_Long_Desc_Attr_Group(
1907: p_inventory_item_id => p_inventory_item_id
1908: ,p_organization_id => p_organization_id
1909: ,p_item_catalog_group_id => p_item_catalog_group_id
1910: ,x_return_status => x_return_status

Line 1931: EGO_Item_PVT.Seed_Item_Long_Desc_In_Bulk(

1927: ) IS
1928:
1929: BEGIN
1930:
1931: EGO_Item_PVT.Seed_Item_Long_Desc_In_Bulk(
1932: p_set_process_id => p_set_process_id
1933: ,x_return_status => x_return_status
1934: ,x_msg_data => x_msg_data
1935: );

Line 1969: EGO_ITEM_PVT.Process_User_Attrs_For_Item(

1965: ) IS
1966:
1967: BEGIN
1968:
1969: EGO_ITEM_PVT.Process_User_Attrs_For_Item(
1970: p_api_version => p_api_version
1971: ,p_inventory_item_id => p_inventory_item_id
1972: ,p_organization_id => p_organization_id
1973: ,p_attributes_row_table => p_attributes_row_table

Line 2018: EGO_ITEM_PVT.Get_User_Attrs_For_Item(

2014: ) IS
2015:
2016: BEGIN
2017:
2018: EGO_ITEM_PVT.Get_User_Attrs_For_Item(
2019: p_api_version => p_api_version
2020: ,p_inventory_item_id => p_inventory_item_id
2021: ,p_organization_id => p_organization_id
2022: ,p_attr_group_request_table => p_attr_group_request_table

Line 4190: EGO_ITEM_PVT.Process_item_role

4186: ,x_msg_count OUT NOCOPY NUMBER
4187: ,x_msg_data OUT NOCOPY VARCHAR2
4188: ) IS
4189: BEGIN
4190: EGO_ITEM_PVT.Process_item_role
4191: (p_api_version => p_api_version
4192: ,p_commit => p_commit
4193: ,p_init_msg_list => p_init_msg_list
4194: ,p_transaction_type => p_transaction_type

Line 4240: EGO_ITEM_PVT.Process_item_phase_and_status

4236: ,x_msg_count OUT NOCOPY NUMBER
4237: ,x_msg_data OUT NOCOPY VARCHAR2
4238: ) IS
4239: BEGIN
4240: EGO_ITEM_PVT.Process_item_phase_and_status
4241: (p_api_version => p_api_version
4242: ,p_commit => p_commit
4243: ,p_init_msg_list => p_init_msg_list
4244: ,p_transaction_type => p_transaction_type

Line 4279: EGO_ITEM_PVT.Implement_Item_Pending_Changes

4275: ,x_msg_count OUT NOCOPY NUMBER
4276: ,x_msg_data OUT NOCOPY VARCHAR2
4277: ) IS
4278: BEGIN
4279: EGO_ITEM_PVT.Implement_Item_Pending_Changes
4280: (p_api_version => p_api_version
4281: ,p_commit => p_commit
4282: ,p_init_msg_list => p_init_msg_list
4283: ,p_inventory_item_id => p_inventory_item_id

Line 4511: EGO_Item_Msg.Add_Error_Message ( EGO_Item_PVT.G_Item_indx,

4507: EXCEPTION
4508: WHEN others THEN
4509: l_err_text := SUBSTRB(SQLERRM, 1,240);
4510: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
4511: EGO_Item_Msg.Add_Error_Message ( EGO_Item_PVT.G_Item_indx,
4512: 'INV', 'INV_ITEM_UNEXPECTED_ERROR',
4513: 'PACKAGE_NAME', G_PKG_NAME, FALSE,
4514: 'PROCEDURE_NAME', l_api_name, FALSE,
4515: 'ERROR_TEXT', l_err_text, FALSE );

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

4562: ,p_instance_pk1_value => p_inventory_item_id
4563: ,p_instance_pk2_value => p_organization_id
4564: ,P_User_Id => FND_GLOBAL.user_id) <> 'T'
4565: THEN
4566: EGO_Item_Msg.Add_Error_Message (p_Entity_Index => EGO_Item_PVT.G_Item_indx,
4567: p_Application_Short_Name =>'INV',
4568: p_Message_Name =>'INV_IOI_ITEM_UPDATE_PRIV');
4569: RAISE FND_API.g_EXC_ERROR;
4570: ELSE

Line 4615: EGO_Item_Msg.Add_Error_Message ( EGO_Item_PVT.G_Item_indx,

4611: );
4612: WHEN others THEN
4613: l_err_text := SUBSTRB(SQLERRM, 1,240);
4614: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
4615: EGO_Item_Msg.Add_Error_Message ( EGO_Item_PVT.G_Item_indx,
4616: 'INV', 'INV_ITEM_UNEXPECTED_ERROR',
4617: 'PACKAGE_NAME', G_PKG_NAME, FALSE,
4618: 'PROCEDURE_NAME', l_api_name, FALSE,
4619: 'ERROR_TEXT', l_err_text, FALSE );

Line 4680: EGO_ITEM_PVT.Validate_Required_Attrs(

4676: ) IS
4677:
4678: BEGIN
4679:
4680: EGO_ITEM_PVT.Validate_Required_Attrs(
4681: p_api_version => p_api_version
4682: ,p_inventory_item_id => p_inventory_item_id
4683: ,p_organization_id => p_organization_id
4684: ,p_revision_id => p_revision_id

Line 4720: EGO_ITEM_MSG.Add_Error_Message ( EGO_ITEM_PVT.G_ITEM_INDX,

4716: EXCEPTION
4717: WHEN OTHERS THEN
4718: l_err_text := SUBSTRB(SQLERRM, 1,240);
4719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4720: EGO_ITEM_MSG.Add_Error_Message ( EGO_ITEM_PVT.G_ITEM_INDX,
4721: 'EGO', 'EGO_ITEM_UNEXPECTED_ERROR',
4722: 'PACKAGE_NAME', G_PKG_NAME, FALSE,
4723: 'PROCEDURE_NAME', l_api_name, FALSE,
4724: 'ERROR_TEXT', l_err_text, FALSE );