eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_SC_PLD_PKG dependencies on FND_MESSAGE

Line 104: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');

100: */
101:
102: EXCEPTION
103: WHEN OTHERS THEN
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;

Line 105: FND_MESSAGE.Set_Token('PACKAGE','SHP_SC_PLD_PKG.Close_Details');

101:
102: EXCEPTION
103: WHEN OTHERS THEN
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:

Line 106: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));

102: EXCEPTION
103: WHEN OTHERS THEN
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;

Line 107: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);

103: WHEN OTHERS THEN
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:

Line 156: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');

152:
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;

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 158: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));

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
162: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');

Line 159: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);

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
162: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
163: FND_MESSAGE.Set_Token('PACKAGE','WSH_SC_PLD_PKG.Update_Details');

Line 162: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');

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));
165: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
166: APP_EXCEPTION.Raise_Exception;

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 164: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));

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

Line 165: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);

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

Line 411: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');

407:
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;

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 413: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));

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
417: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');

Line 414: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);

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
417: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
418: FND_MESSAGE.Set_Token('PACKAGE','WSH_SC_PLD_PKG.Insert_Details');

Line 417: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');

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));
420: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
421: APP_EXCEPTION.Raise_Exception;

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 419: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));

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

Line 420: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);

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

Line 463: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');

459: EXCEPTION
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;

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 465: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));

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

Line 466: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);

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

Line 590: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');

586: CLOSE get_picking_line_detail;
587:
588: 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:

Line 591: FND_MESSAGE.Set_Token('PACKAGE','WSH_SC_PDB_PKG.Explode_lines');

587:
588: 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;

Line 592: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));

588: 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:

Line 662: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');

658: EXCEPTION
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;

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 664: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));

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

Line 665: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);

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