APPS.WSH_SC_PLD_PKG dependencies on APP_EXCEPTION

Line 108: APP_EXCEPTION.Raise_Exception;

104: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
105: FND_MESSAGE.Set_Token('PACKAGE','SHP_SC_PLD_PKG.Close_Details');
106: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
107: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
108: APP_EXCEPTION.Raise_Exception;
109:
110: END Close_Details;
111:
112: --

Line 160: APP_EXCEPTION.Raise_Exception;

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

Line 166: APP_EXCEPTION.Raise_Exception;

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:
168: END Update_Details;
169:
170: --

Line 415: APP_EXCEPTION.Raise_Exception;

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

Line 421: APP_EXCEPTION.Raise_Exception;

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:
423: END;
424:
425:

Line 467: APP_EXCEPTION.Raise_Exception;

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;
469:
470:
471: --

Line 593: APP_EXCEPTION.Raise_Exception;

589: WHEN OTHERS THEN
590: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
591: FND_MESSAGE.Set_Token('PACKAGE','WSH_SC_PDB_PKG.Explode_lines');
592: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
593: APP_EXCEPTION.Raise_Exception;
594:
595: END Explode_Lines;
596:
597: --

Line 666: APP_EXCEPTION.Raise_Exception;

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;
668: END WSH_SC_PLD_PKG;