DBA Data[Home] [Help]

APPS.MTL_RELATED_ITEMS_PVT dependencies on MTL_RELATED_ITEMS_PVT

Line 1: PACKAGE BODY MTL_RELATED_ITEMS_PVT AS

1: PACKAGE BODY MTL_RELATED_ITEMS_PVT AS
2: /* $Header: INVVRITB.pls 120.16.12020000.3 2013/04/10 09:31:06 ccsingh ship $ */
3:
4: -----------------------------------------------
5: -- Write Debug statements to Concurrent Log --

Line 277: SAVEPOINT MTL_RELATED_ITEMS_PVT;

273:
274:
275: BEGIN
276:
277: SAVEPOINT MTL_RELATED_ITEMS_PVT;
278: x_return_status := FND_API.G_RET_STS_SUCCESS;
279: l_Rel_Item_Rec := p_Rel_Item_Rec;
280: l_Pln_Info_Tbl := p_Pln_Info_Tbl;
281: l_Cust_Ref_Tbl := p_Cust_Ref_Tbl;

Line 2146: ROLLBACK TO MTL_RELATED_ITEMS_PVT; -- rollback to savepoint

2142: x_return_status:= FND_API.g_RET_STS_ERROR;
2143: l_msg_count := l_msg_count +1;
2144: Error_Handler.Get_Entity_Message(G_Entity_Code, x_msg_list);
2145:
2146: ROLLBACK TO MTL_RELATED_ITEMS_PVT; -- rollback to savepoint
2147: WHEN resource_busy THEN
2148:
2149: Error_Handler.Add_Error_message
2150: (

Line 2160: ROLLBACK TO MTL_RELATED_ITEMS_PVT; -- rollback to savepoint

2156: ,p_entity_index => 1
2157: ,p_table_name => G_Table_Name
2158: );
2159:
2160: ROLLBACK TO MTL_RELATED_ITEMS_PVT; -- rollback to savepoint
2161: x_return_status:= FND_API.g_RET_STS_ERROR;
2162: l_msg_count := l_msg_count +1;
2163: Error_Handler.Get_Entity_Message(G_Entity_Code, x_msg_list);
2164:

Line 2192: ROLLBACK TO MTL_RELATED_ITEMS_PVT; -- rollback to savepoint

2188: x_return_status:= FND_API.g_RET_STS_ERROR;
2189: l_msg_count := l_msg_count +1;
2190: Error_Handler.Get_Entity_Message(G_Entity_Code, x_msg_list);
2191:
2192: ROLLBACK TO MTL_RELATED_ITEMS_PVT; -- rollback to savepoint
2193:
2194: -- //END; -- internal begin for transactions
2195:
2196: p_Rel_Item_Rec := l_Rel_Item_Rec;

Line 2497: Write_Debug('Calling MTL_RELATED_ITEMS_PVT.Process_Rel_Item for Transaction ' ||To_Char(l_mtl_Rel_Item_rec.Transaction_Id));

2493: --l_Rel_Item_Rec.CREATION_DATE := l_mtl_Rel_Item_rec.CREATION_DATE;
2494: --l_Rel_Item_Rec.CREATED_BY := l_mtl_Rel_Item_rec.CREATED_BY;
2495: --l_Rel_Item_Rec.LAST_UPDATE_LOGIN := l_mtl_Rel_Item_rec.LAST_UPDATE_LOGIN;
2496:
2497: Write_Debug('Calling MTL_RELATED_ITEMS_PVT.Process_Rel_Item for Transaction ' ||To_Char(l_mtl_Rel_Item_rec.Transaction_Id));
2498: MTL_RELATED_ITEMS_PVT.Process_Rel_Item
2499: (
2500: p_commit => FND_API.G_TRUE
2501: ,p_init_msg_list => FND_API.G_TRUE

Line 2498: MTL_RELATED_ITEMS_PVT.Process_Rel_Item

2494: --l_Rel_Item_Rec.CREATED_BY := l_mtl_Rel_Item_rec.CREATED_BY;
2495: --l_Rel_Item_Rec.LAST_UPDATE_LOGIN := l_mtl_Rel_Item_rec.LAST_UPDATE_LOGIN;
2496:
2497: Write_Debug('Calling MTL_RELATED_ITEMS_PVT.Process_Rel_Item for Transaction ' ||To_Char(l_mtl_Rel_Item_rec.Transaction_Id));
2498: MTL_RELATED_ITEMS_PVT.Process_Rel_Item
2499: (
2500: p_commit => FND_API.G_TRUE
2501: ,p_init_msg_list => FND_API.G_TRUE
2502: ,p_Rel_Item_Rec => l_Rel_Item_Rec

Line 2610: err_text := SUBSTR('MTL_RELATED_ITEMS_PVT.Del_Processed_Recs' || SQLERRM, 1,240);

2606:
2607: EXCEPTION
2608:
2609: WHEN OTHERS THEN
2610: err_text := SUBSTR('MTL_RELATED_ITEMS_PVT.Del_Processed_Recs' || SQLERRM, 1,240);
2611: RETURN (SQLCODE);
2612:
2613: END Del_Processed_Recs;
2614:

Line 2615: END MTL_RELATED_ITEMS_PVT;

2611: RETURN (SQLCODE);
2612:
2613: END Del_Processed_Recs;
2614:
2615: END MTL_RELATED_ITEMS_PVT;
2616: