244:
245: WHEN OTHERS THEN
246: Rollback to Update_Req_Info_Grp;
247: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
248: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
249: THEN
250: OE_MSG_PUB.Add_Exc_Msg(G_PKG_Name,L_API_Name);
251: END IF;
252: OE_MSG_PUB.Count_And_Get (P_Count => P_MSG_Count,
246: Rollback to Update_Req_Info_Grp;
247: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
248: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
249: THEN
250: OE_MSG_PUB.Add_Exc_Msg(G_PKG_Name,L_API_Name);
251: END IF;
252: OE_MSG_PUB.Count_And_Get (P_Count => P_MSG_Count,
253: P_Data => P_MSG_Data);
254: END Update_Req_Info;
248: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
249: THEN
250: OE_MSG_PUB.Add_Exc_Msg(G_PKG_Name,L_API_Name);
251: END IF;
252: OE_MSG_PUB.Count_And_Get (P_Count => P_MSG_Count,
253: P_Data => P_MSG_Data);
254: END Update_Req_Info;
255:
256:
345:
346: WHEN OTHERS THEN
347: ROLLBACK TO UPDATE_ALL_REQS_IN_PROCESS;
348: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
349: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
350: THEN
351: OE_MSG_PUB.Add_Exc_Msg(G_PKG_Name,L_API_Name);
352: END IF;
353: OE_MSG_PUB.Count_And_Get (P_Count => P_MSG_Count,
347: ROLLBACK TO UPDATE_ALL_REQS_IN_PROCESS;
348: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
349: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
350: THEN
351: OE_MSG_PUB.Add_Exc_Msg(G_PKG_Name,L_API_Name);
352: END IF;
353: OE_MSG_PUB.Count_And_Get (P_Count => P_MSG_Count,
354: P_Data => P_MSG_Data);
355: END Update_All_Reqs_In_Process;
349: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
350: THEN
351: OE_MSG_PUB.Add_Exc_Msg(G_PKG_Name,L_API_Name);
352: END IF;
353: OE_MSG_PUB.Count_And_Get (P_Count => P_MSG_Count,
354: P_Data => P_MSG_Data);
355: END Update_All_Reqs_In_Process;
356:
357: /*-----------------------------------------------------------------
466:
467: WHEN OTHERS THEN
468: ROLLBACK TO Update_PO_Info_GRP;
469: P_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
470: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
471: THEN
472: OE_MSG_PUB.Add_Exc_Msg(G_PKG_Name,L_API_Name);
473: END IF;
474: OE_MSG_PUB.Count_And_Get (P_Count => P_MSG_Count,
468: ROLLBACK TO Update_PO_Info_GRP;
469: P_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
470: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
471: THEN
472: OE_MSG_PUB.Add_Exc_Msg(G_PKG_Name,L_API_Name);
473: END IF;
474: OE_MSG_PUB.Count_And_Get (P_Count => P_MSG_Count,
475: P_Data => P_MSG_Data);
476: END Update_PO_Info;
470: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
471: THEN
472: OE_MSG_PUB.Add_Exc_Msg(G_PKG_Name,L_API_Name);
473: END IF;
474: OE_MSG_PUB.Count_And_Get (P_Count => P_MSG_Count,
475: P_Data => P_MSG_Data);
476: END Update_PO_Info;
477: --
478:
632: ROLLBACK TO Update_Drop_Ship_Links;
633:
634: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
635:
636: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
637: THEN
638: OE_MSG_PUB.Add_Exc_Msg(
639: G_PKG_Name,
640: 'Update_Drop_Ship_Links');
634: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
635:
636: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
637: THEN
638: OE_MSG_PUB.Add_Exc_Msg(
639: G_PKG_Name,
640: 'Update_Drop_Ship_Links');
641: END IF;
642:
639: G_PKG_Name,
640: 'Update_Drop_Ship_Links');
641: END IF;
642:
643: OE_MSG_PUB.Count_And_Get (p_Count => x_msg_count,
644: p_Data => x_msg_data);
645: END Update_Drop_Ship_Links;
646:
647: /*--------------------------------------------------
877: RAISE;
878:
879: WHEN OTHERS THEN
880:
881: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
882: THEN
883: OE_MSG_PUB.Add_Exc_Msg
884: ( G_PKG_NAME,
885: 'Get_Drop_Ship_Line_ids');
879: WHEN OTHERS THEN
880:
881: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
882: THEN
883: OE_MSG_PUB.Add_Exc_Msg
884: ( G_PKG_NAME,
885: 'Get_Drop_Ship_Line_ids');
886: END IF;
887:
976: ROLLBACK TO Update_Drop_Ship_Links;
977:
978: WHEN OTHERS THEN
979:
980: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
981: THEN
982: OE_MSG_PUB.Add_Exc_Msg
983: ( G_PKG_NAME,
984: 'Get_Order_Line_Status');
978: WHEN OTHERS THEN
979:
980: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
981: THEN
982: OE_MSG_PUB.Add_Exc_Msg
983: ( G_PKG_NAME,
984: 'Get_Order_Line_Status');
985: END IF;
986:
1458: IF l_debug_level > 0 THEN
1459: OE_DEBUG_PUB.Add('error in Get_Order_Line_Info '||sqlerrm,1);
1460: END IF;
1461:
1462: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1463: THEN
1464: OE_MSG_PUB.Add_Exc_Msg(G_PKG_Name, 'Get_Order_Line_Info');
1465: END IF;
1466:
1460: END IF;
1461:
1462: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1463: THEN
1464: OE_MSG_PUB.Add_Exc_Msg(G_PKG_Name, 'Get_Order_Line_Info');
1465: END IF;
1466:
1467: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
1468: P_Data => x_msg_Data);
1463: THEN
1464: OE_MSG_PUB.Add_Exc_Msg(G_PKG_Name, 'Get_Order_Line_Info');
1465: END IF;
1466:
1467: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
1468: P_Data => x_msg_Data);
1469: END Get_Order_Line_Info;
1470:
1471:
1557: IF l_debug_level > 0 THEN
1558: OE_DEBUG_PUB.Add('UnExp Error in Purge_Drop_Ship_PO_Links...'||sqlerrm,4);
1559: END IF;
1560:
1561: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1562: THEN
1563: OE_MSG_PUB.Add_Exc_Msg
1564: (G_PKG_NAME
1565: ,'Purge_Drop_Ship_PO_Links'
1559: END IF;
1560:
1561: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1562: THEN
1563: OE_MSG_PUB.Add_Exc_Msg
1564: (G_PKG_NAME
1565: ,'Purge_Drop_Ship_PO_Links'
1566: );
1567: END IF;
1565: ,'Purge_Drop_Ship_PO_Links'
1566: );
1567: END IF;
1568:
1569: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
1570: P_Data => x_msg_Data);
1571: END Purge_Drop_Ship_PO_Links;
1572:
1573: /*-----------------------------------------------------
1675: IF l_debug_level > 0 THEN
1676: OE_DEBUG_PUB.Add('UnExp Error in Purge_Drop_Ship_PO_Validation...'||sqlerrm,4);
1677: END IF;
1678:
1679: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1680: THEN
1681: OE_MSG_PUB.Add_Exc_Msg
1682: (G_PKG_NAME
1683: ,'Purge_Drop_Ship_PO_Validation'
1677: END IF;
1678:
1679: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1680: THEN
1681: OE_MSG_PUB.Add_Exc_Msg
1682: (G_PKG_NAME
1683: ,'Purge_Drop_Ship_PO_Validation'
1684: );
1685: END IF;
1683: ,'Purge_Drop_Ship_PO_Validation'
1684: );
1685: END IF;
1686:
1687: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
1688: P_Data => x_msg_Data);
1689:
1690: END Purge_Drop_Ship_PO_Validation;
1691: