DBA Data[Home] [Help]

APPS.OE_DROP_SHIP_GRP dependencies on OE_MSG_PUB

Line 248: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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,

Line 250: OE_MSG_PUB.Add_Exc_Msg(G_PKG_Name,L_API_Name);

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;

Line 252: OE_MSG_PUB.Count_And_Get (P_Count => P_MSG_Count,

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:

Line 349: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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,

Line 351: OE_MSG_PUB.Add_Exc_Msg(G_PKG_Name,L_API_Name);

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;

Line 353: OE_MSG_PUB.Count_And_Get (P_Count => P_MSG_Count,

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: /*-----------------------------------------------------------------

Line 470: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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,

Line 472: OE_MSG_PUB.Add_Exc_Msg(G_PKG_Name,L_API_Name);

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;

Line 474: OE_MSG_PUB.Count_And_Get (P_Count => P_MSG_Count,

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:

Line 636: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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');

Line 638: OE_MSG_PUB.Add_Exc_Msg(

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:

Line 643: OE_MSG_PUB.Count_And_Get (p_Count => x_msg_count,

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: /*--------------------------------------------------

Line 881: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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');

Line 883: OE_MSG_PUB.Add_Exc_Msg

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:

Line 980: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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');

Line 982: OE_MSG_PUB.Add_Exc_Msg

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:

Line 1460: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1456: IF l_debug_level > 0 THEN
1457: OE_DEBUG_PUB.Add('error in Get_Order_Line_Info '||sqlerrm,1);
1458: END IF;
1459:
1460: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1461: THEN
1462: OE_MSG_PUB.Add_Exc_Msg(G_PKG_Name, 'Get_Order_Line_Info');
1463: END IF;
1464:

Line 1462: OE_MSG_PUB.Add_Exc_Msg(G_PKG_Name, 'Get_Order_Line_Info');

1458: END IF;
1459:
1460: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1461: THEN
1462: OE_MSG_PUB.Add_Exc_Msg(G_PKG_Name, 'Get_Order_Line_Info');
1463: END IF;
1464:
1465: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
1466: P_Data => x_msg_Data);

Line 1465: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,

1461: THEN
1462: OE_MSG_PUB.Add_Exc_Msg(G_PKG_Name, 'Get_Order_Line_Info');
1463: END IF;
1464:
1465: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
1466: P_Data => x_msg_Data);
1467: END Get_Order_Line_Info;
1468:
1469:

Line 1559: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1555: IF l_debug_level > 0 THEN
1556: OE_DEBUG_PUB.Add('UnExp Error in Purge_Drop_Ship_PO_Links...'||sqlerrm,4);
1557: END IF;
1558:
1559: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1560: THEN
1561: OE_MSG_PUB.Add_Exc_Msg
1562: (G_PKG_NAME
1563: ,'Purge_Drop_Ship_PO_Links'

Line 1561: OE_MSG_PUB.Add_Exc_Msg

1557: END IF;
1558:
1559: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1560: THEN
1561: OE_MSG_PUB.Add_Exc_Msg
1562: (G_PKG_NAME
1563: ,'Purge_Drop_Ship_PO_Links'
1564: );
1565: END IF;

Line 1567: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,

1563: ,'Purge_Drop_Ship_PO_Links'
1564: );
1565: END IF;
1566:
1567: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
1568: P_Data => x_msg_Data);
1569: END Purge_Drop_Ship_PO_Links;
1570:
1571: /*-----------------------------------------------------

Line 1677: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1673: IF l_debug_level > 0 THEN
1674: OE_DEBUG_PUB.Add('UnExp Error in Purge_Drop_Ship_PO_Validation...'||sqlerrm,4);
1675: END IF;
1676:
1677: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1678: THEN
1679: OE_MSG_PUB.Add_Exc_Msg
1680: (G_PKG_NAME
1681: ,'Purge_Drop_Ship_PO_Validation'

Line 1679: OE_MSG_PUB.Add_Exc_Msg

1675: END IF;
1676:
1677: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1678: THEN
1679: OE_MSG_PUB.Add_Exc_Msg
1680: (G_PKG_NAME
1681: ,'Purge_Drop_Ship_PO_Validation'
1682: );
1683: END IF;

Line 1685: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,

1681: ,'Purge_Drop_Ship_PO_Validation'
1682: );
1683: END IF;
1684:
1685: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
1686: P_Data => x_msg_Data);
1687:
1688: END Purge_Drop_Ship_PO_Validation;
1689: