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_DELIVERY_PVT dependencies on FND_MESSAGE

Line 223: return_msg1 := FND_MESSAGE.get;

219: -- Handle any exceptions
220: Exception
221:
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));

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

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

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

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

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

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;
231:
232: END Close_Delivery;

Line 264: FND_MESSAGE.SET_NAME('OE','WSH_NO_DOCS');

260: CLOSE c1;
261: END IF;
262: END IF;
263: IF ( x_report_set_id IS NULL ) THEN
264: FND_MESSAGE.SET_NAME('OE','WSH_NO_DOCS');
265: return_message := FND_MESSAGE.GET;
266: x_return_msg := return_message;
267: RETURN TRUE;
268: END IF;

Line 265: return_message := FND_MESSAGE.GET;

261: END IF;
262: END IF;
263: IF ( x_report_set_id IS NULL ) THEN
264: FND_MESSAGE.SET_NAME('OE','WSH_NO_DOCS');
265: return_message := FND_MESSAGE.GET;
266: x_return_msg := return_message;
267: RETURN TRUE;
268: END IF;
269:

Line 284: FND_MESSAGE.SET_NAME('OE','WSH_SC_INVALID_PARA');

280: WHEN invalid_parameters THEN
281: IF ( c1%ISOPEN) THEN
282: CLOSE c1;
283: END IF;
284: FND_MESSAGE.SET_NAME('OE','WSH_SC_INVALID_PARA');
285: return_message := FND_MESSAGE.GET;
286: x_return_msg := return_message;
287: RETURN FALSE;
288: WHEN others THEN

Line 285: return_message := FND_MESSAGE.GET;

281: IF ( c1%ISOPEN) THEN
282: CLOSE c1;
283: END IF;
284: FND_MESSAGE.SET_NAME('OE','WSH_SC_INVALID_PARA');
285: return_message := FND_MESSAGE.GET;
286: x_return_msg := return_message;
287: RETURN FALSE;
288: WHEN others THEN
289: return_msg1 := FND_MESSAGE.get;

Line 289: return_msg1 := FND_MESSAGE.get;

285: return_message := FND_MESSAGE.GET;
286: x_return_msg := return_message;
287: RETURN FALSE;
288: WHEN others THEN
289: return_msg1 := FND_MESSAGE.get;
290: wsh_del_oi_core.println('msg ='|| return_msg1);
291: IF ( c1%ISOPEN) THEN
292: CLOSE c1;
293: END IF;

Line 375: return_msg1 := FND_MESSAGE.get;

371: return TRUE;
372:
373: Exception
374: WHEN OTHERS THEN
375: return_msg1 := FND_MESSAGE.get;
376: wsh_del_oi_core.println('msg ='|| return_msg1);
377: IF ( c1%ISOPEN) THEN
378: CLOSE c1;
379: END IF;

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

376: wsh_del_oi_core.println('msg ='|| return_msg1);
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;

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

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

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

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;
386:
387: END Backorder_Delivery;

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

433: --handle any exceptions
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;

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

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

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

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;
443:
444: END Unpack_Delivery;

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

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

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

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

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

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;
1077:
1078: END Auto_Create_Departure;

Line 1115: FND_MESSAGE.SET_NAME('OE', 'WSH_FAIL_TO_LOCK_PLD');

1111: ROLLBACK TO before_lock;
1112: IF c1%ISOPEN THEN
1113: CLOSE c1;
1114: END IF;
1115: FND_MESSAGE.SET_NAME('OE', 'WSH_FAIL_TO_LOCK_PLD');
1116: RETURN FALSE;
1117: END Delete_Container_Contents;
1118:
1119: