DBA Data[Home] [Help]

APPS.WSH_SC_PLD_PKG dependencies on WSH_SC_PLD_PKG

Line 1: PACKAGE BODY WSH_SC_PLD_PKG as

1: PACKAGE BODY WSH_SC_PLD_PKG as
2: /* $Header: WSHSCPDB.pls 115.5 99/07/16 08:20:47 porting shi $ */
3:
4: --
5: -- Package

Line 6: -- WSH_SC_PLD_PKG

2: /* $Header: WSHSCPDB.pls 115.5 99/07/16 08:20:47 porting shi $ */
3:
4: --
5: -- Package
6: -- WSH_SC_PLD_PKG
7: --
8: -- Purpose
9: -- This package is used by the confirm delivery form to update
10: -- serial number information (details) entered on a delivery line

Line 157: FND_MESSAGE.Set_Token('PACKAGE','WSH_SC_PLD_PKG.Update_Details');

153: EXCEPTION
154: WHEN NO_DATA_FOUND THEN
155: -- Replace this with real error? How to reflect in form?
156: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
157: FND_MESSAGE.Set_Token('PACKAGE','WSH_SC_PLD_PKG.Update_Details');
158: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
159: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
160: APP_EXCEPTION.Raise_Exception;
161: WHEN OTHERS THEN

Line 163: FND_MESSAGE.Set_Token('PACKAGE','WSH_SC_PLD_PKG.Update_Details');

159: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
160: APP_EXCEPTION.Raise_Exception;
161: WHEN OTHERS THEN
162: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
163: FND_MESSAGE.Set_Token('PACKAGE','WSH_SC_PLD_PKG.Update_Details');
164: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
165: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
166: APP_EXCEPTION.Raise_Exception;
167:

Line 412: FND_MESSAGE.Set_Token('PACKAGE','WSH_SC_PLD_PKG.Insert_Details');

408: EXCEPTION
409: WHEN NO_DATA_FOUND THEN
410: -- Replace this with real error? How to reflect in form?
411: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
412: FND_MESSAGE.Set_Token('PACKAGE','WSH_SC_PLD_PKG.Insert_Details');
413: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
414: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
415: APP_EXCEPTION.Raise_Exception;
416: WHEN OTHERS THEN

Line 418: FND_MESSAGE.Set_Token('PACKAGE','WSH_SC_PLD_PKG.Insert_Details');

414: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
415: APP_EXCEPTION.Raise_Exception;
416: WHEN OTHERS THEN
417: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
418: FND_MESSAGE.Set_Token('PACKAGE','WSH_SC_PLD_PKG.Insert_Details');
419: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
420: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
421: APP_EXCEPTION.Raise_Exception;
422:

Line 464: FND_MESSAGE.Set_Token('PACKAGE','WSH_SC_PLD_PKG.Create_Remainders');

460: WHEN NO_DATA_FOUND THEN
461: RETURN;
462: WHEN OTHERS THEN
463: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
464: FND_MESSAGE.Set_Token('PACKAGE','WSH_SC_PLD_PKG.Create_Remainders');
465: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
466: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
467: APP_EXCEPTION.Raise_Exception;
468: END;

Line 663: FND_MESSAGE.Set_Token('PACKAGE','WSH_SC_PLD_PKG.Delete_From_Msnt');

659: WHEN NO_DATA_FOUND THEN
660: RETURN;
661: WHEN OTHERS THEN
662: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
663: FND_MESSAGE.Set_Token('PACKAGE','WSH_SC_PLD_PKG.Delete_From_Msnt');
664: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
665: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
666: APP_EXCEPTION.Raise_Exception;
667: END;

Line 668: END WSH_SC_PLD_PKG;

664: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
665: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
666: APP_EXCEPTION.Raise_Exception;
667: END;
668: END WSH_SC_PLD_PKG;