DBA Data[Home] [Help]

APPS.ENG_REVISED_ITEM_UTIL dependencies on FND_MSG_PUB

Line 195: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

191: WHERE ORGANIZATION_ID = p_organization_id
192: AND CHANGE_NOTICE = p_change_notice;
193: X_EcoStatus := 6;
194:
195: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
196: THEN
197: Error_Handler.Add_Error_Token
198: ( p_Message_Name => 'ENG_LAST_ITEM_CANCL_ECO_IMPL'
199: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 218: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

214: LAST_UPDATE_LOGIN = p_login
215: WHERE ORGANIZATION_ID = p_organization_id
216: AND CHANGE_NOTICE = p_change_notice;
217:
218: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
219: THEN
220: Error_Handler.Add_Error_Token
221: ( p_Message_Name => 'ENG_LAST_ITEM_CANCL_ECO_CANCL'
222: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 887: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

883:
884: EXCEPTION
885: WHEN NO_DATA_FOUND THEN
886: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('no data stmt_num '|| l_stmt_num); END IF;
887: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
888: THEN
889: Error_Handler.Add_Error_Token
890: ( p_Message_Name => 'ENG_REV_ITEM_REC_DELETED'
891: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 899: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
896:
897: WHEN OTHERS THEN
898: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('un exp stmt_num '|| l_stmt_num); END IF;
899: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
900: THEN
901: l_err_text := G_PKG_NAME || ' : Utility (Revised Item Update) '
902: || SUBSTR(SQLERRM, 1, 200);
903: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug(l_err_text); END IF;

Line 904: IF FND_MSG_PUB.Check_Msg_Level

900: THEN
901: l_err_text := G_PKG_NAME || ' : Utility (Revised Item Update) '
902: || SUBSTR(SQLERRM, 1, 200);
903: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug(l_err_text); END IF;
904: IF FND_MSG_PUB.Check_Msg_Level
905: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
906: THEN
907: Error_Handler.Add_Error_Token
908: ( p_Message_Name => NULL

Line 905: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

901: l_err_text := G_PKG_NAME || ' : Utility (Revised Item Update) '
902: || SUBSTR(SQLERRM, 1, 200);
903: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug(l_err_text); END IF;
904: IF FND_MSG_PUB.Check_Msg_Level
905: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
906: THEN
907: Error_Handler.Add_Error_Token
908: ( p_Message_Name => NULL
909: , p_Message_Text => l_Err_Text

Line 2132: IF FND_MSG_PUB.Check_Msg_Level

2128: WHEN NO_DATA_FOUND THEN
2129: NULL;
2130:
2131: WHEN OTHERS THEN
2132: IF FND_MSG_PUB.Check_Msg_Level
2133: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2134: THEN
2135: l_err_text := G_PKG_NAME ||
2136: ' : (Deleting Revised Item Details ' ||

Line 2133: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2129: NULL;
2130:
2131: WHEN OTHERS THEN
2132: IF FND_MSG_PUB.Check_Msg_Level
2133: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2134: THEN
2135: l_err_text := G_PKG_NAME ||
2136: ' : (Deleting Revised Item Details ' ||
2137: substrb(SQLERRM,1,200);

Line 2514: FND_MSG_PUB.initialize;

2510: END IF;
2511:
2512: -- Initialize message list if p_init_msg_list is set to TRUE.
2513: IF FND_API.to_Boolean(p_init_msg_list) THEN
2514: FND_MSG_PUB.initialize;
2515: END IF;
2516:
2517: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Fetch the revised Item Details'); END IF;
2518: OPEN c_revised_item(cp_revised_item_sequence_id => p_revised_item_sequence_id);

Line 2593: FND_MSG_PUB.Count_And_Get

2589: IF FND_API.To_Boolean (p_commit)
2590: THEN
2591: COMMIT WORK;
2592: END IF;
2593: FND_MSG_PUB.Count_And_Get
2594: ( p_count => x_msg_count
2595: , p_data => x_msg_data );
2596: IF Bom_Globals.Get_Debug = 'Y'
2597: THEN

Line 2607: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2603: WHEN OTHERS THEN
2604: ROLLBACK TO Reschedule_Revised_Item_SP;
2605: CLOSE c_revised_item;
2606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2607: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2608: THEN
2609: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
2610: END IF;
2611: FND_MSG_PUB.Count_And_Get

Line 2609: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);

2605: CLOSE c_revised_item;
2606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2607: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2608: THEN
2609: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
2610: END IF;
2611: FND_MSG_PUB.Count_And_Get
2612: ( p_count => x_msg_count
2613: , p_data => x_msg_data );

Line 2611: FND_MSG_PUB.Count_And_Get

2607: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2608: THEN
2609: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
2610: END IF;
2611: FND_MSG_PUB.Count_And_Get
2612: ( p_count => x_msg_count
2613: , p_data => x_msg_data );
2614: IF Bom_Globals.Get_Debug = 'Y'
2615: THEN