DBA Data[Home] [Help]

APPS.ENG_REVISED_ITEM_UTIL dependencies on FND_MSG_PUB

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

208: WHERE ORGANIZATION_ID = p_organization_id
209: AND CHANGE_NOTICE = p_change_notice;
210: X_EcoStatus := 6;
211:
212: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
213: THEN
214: Error_Handler.Add_Error_Token
215: ( p_Message_Name => 'ENG_LAST_ITEM_CANCL_ECO_IMPL'
216: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

231: LAST_UPDATE_LOGIN = p_login
232: WHERE ORGANIZATION_ID = p_organization_id
233: AND CHANGE_NOTICE = p_change_notice;
234:
235: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
236: THEN
237: Error_Handler.Add_Error_Token
238: ( p_Message_Name => 'ENG_LAST_ITEM_CANCL_ECO_CANCL'
239: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

900:
901: EXCEPTION
902: WHEN NO_DATA_FOUND THEN
903: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('no data stmt_num '|| l_stmt_num); END IF;
904: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
905: THEN
906: Error_Handler.Add_Error_Token
907: ( p_Message_Name => 'ENG_REV_ITEM_REC_DELETED'
908: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

912: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
913:
914: WHEN OTHERS THEN
915: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('un exp stmt_num '|| l_stmt_num); END IF;
916: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
917: THEN
918: l_err_text := G_PKG_NAME || ' : Utility (Revised Item Update) '
919: || SUBSTR(SQLERRM, 1, 200);
920: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug(l_err_text); END IF;

Line 921: IF FND_MSG_PUB.Check_Msg_Level

917: THEN
918: l_err_text := G_PKG_NAME || ' : Utility (Revised Item Update) '
919: || SUBSTR(SQLERRM, 1, 200);
920: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug(l_err_text); END IF;
921: IF FND_MSG_PUB.Check_Msg_Level
922: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
923: THEN
924: Error_Handler.Add_Error_Token
925: ( p_Message_Name => NULL

Line 922: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

918: l_err_text := G_PKG_NAME || ' : Utility (Revised Item Update) '
919: || SUBSTR(SQLERRM, 1, 200);
920: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug(l_err_text); END IF;
921: IF FND_MSG_PUB.Check_Msg_Level
922: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
923: THEN
924: Error_Handler.Add_Error_Token
925: ( p_Message_Name => NULL
926: , p_Message_Text => l_Err_Text

Line 2156: IF FND_MSG_PUB.Check_Msg_Level

2152: WHEN NO_DATA_FOUND THEN
2153: NULL;
2154:
2155: WHEN OTHERS THEN
2156: IF FND_MSG_PUB.Check_Msg_Level
2157: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2158: THEN
2159: l_err_text := G_PKG_NAME ||
2160: ' : (Deleting Revised Item Details ' ||

Line 2157: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2153: NULL;
2154:
2155: WHEN OTHERS THEN
2156: IF FND_MSG_PUB.Check_Msg_Level
2157: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2158: THEN
2159: l_err_text := G_PKG_NAME ||
2160: ' : (Deleting Revised Item Details ' ||
2161: substrb(SQLERRM,1,200);

Line 2538: FND_MSG_PUB.initialize;

2534: END IF;
2535:
2536: -- Initialize message list if p_init_msg_list is set to TRUE.
2537: IF FND_API.to_Boolean(p_init_msg_list) THEN
2538: FND_MSG_PUB.initialize;
2539: END IF;
2540:
2541: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Fetch the revised Item Details'); END IF;
2542: OPEN c_revised_item(cp_revised_item_sequence_id => p_revised_item_sequence_id);

Line 2617: FND_MSG_PUB.Count_And_Get

2613: IF FND_API.To_Boolean (p_commit)
2614: THEN
2615: COMMIT WORK;
2616: END IF;
2617: FND_MSG_PUB.Count_And_Get
2618: ( p_count => x_msg_count
2619: , p_data => x_msg_data );
2620: IF Bom_Globals.Get_Debug = 'Y'
2621: THEN

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

2627: WHEN OTHERS THEN
2628: ROLLBACK TO Reschedule_Revised_Item_SP;
2629: CLOSE c_revised_item;
2630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2631: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2632: THEN
2633: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
2634: END IF;
2635: FND_MSG_PUB.Count_And_Get

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

2629: CLOSE c_revised_item;
2630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2631: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2632: THEN
2633: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
2634: END IF;
2635: FND_MSG_PUB.Count_And_Get
2636: ( p_count => x_msg_count
2637: , p_data => x_msg_data );

Line 2635: FND_MSG_PUB.Count_And_Get

2631: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2632: THEN
2633: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
2634: END IF;
2635: FND_MSG_PUB.Count_And_Get
2636: ( p_count => x_msg_count
2637: , p_data => x_msg_data );
2638: IF Bom_Globals.Get_Debug = 'Y'
2639: THEN