DBA Data[Home] [Help]

APPS.WSH_SC_DELIVERY_PVT dependencies on WSH_SC_DELIVERY_PVT

Line 1: PACKAGE BODY WSH_SC_DELIVERY_PVT as

1: PACKAGE BODY WSH_SC_DELIVERY_PVT as
2: /* $Header: WSHSDELB.pls 115.7 99/10/18 18:46:56 porting ship $ */
3:
4: -- Function Name : Close_Delivery
5:

Line 226: FND_MESSAGE.Set_Token('PACKAGE','WSH_SC_DELIVERY_PVT.Close_Delivery');

222: WHEN OTHERS THEN
223: return_msg1 := FND_MESSAGE.get;
224: wsh_del_oi_core.println('msg ='|| return_msg1);
225: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
226: FND_MESSAGE.Set_Token('PACKAGE','WSH_SC_DELIVERY_PVT.Close_Delivery');
227: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
228: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
229: APP_EXCEPTION.Raise_Exception;
230: return FALSE;

Line 381: FND_MESSAGE.Set_Token('PACKAGE','WSH_SC_DELIVERY_PVT.Backorder_Delivery');

377: IF ( c1%ISOPEN) THEN
378: CLOSE c1;
379: END IF;
380: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
381: FND_MESSAGE.Set_Token('PACKAGE','WSH_SC_DELIVERY_PVT.Backorder_Delivery');
382: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
383: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
384: APP_EXCEPTION.Raise_Exception;
385: return FALSE;

Line 438: FND_MESSAGE.Set_Token('PACKAGE','WSH_SC_DELIVERY_PVT.Unpack_Delivery');

434: Exception
435:
436: WHEN OTHERS THEN
437: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
438: FND_MESSAGE.Set_Token('PACKAGE','WSH_SC_DELIVERY_PVT.Unpack_Delivery');
439: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
440: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
441: APP_EXCEPTION.Raise_Exception;
442: return FALSE;

Line 1072: FND_MESSAGE.Set_Token('PACKAGE','WSH_SC_DELIVERY_PVT.Auto_Create_Departure');

1068: Exception
1069:
1070: WHEN OTHERS THEN
1071: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
1072: FND_MESSAGE.Set_Token('PACKAGE','WSH_SC_DELIVERY_PVT.Auto_Create_Departure');
1073: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
1074: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
1075: APP_EXCEPTION.Raise_Exception;
1076: Return -1;

Line 1121: END WSH_SC_DELIVERY_PVT;

1117: END Delete_Container_Contents;
1118:
1119:
1120:
1121: END WSH_SC_DELIVERY_PVT;