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.FTE_VEHICLE_PKG dependencies on WSH_DEBUG_SV

Line 194: --l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;

190: errorTable INV_ITEM_GRP.Error_tbl_type;
191: errorRec INV_ITEM_GRP.Error_rec_type;
192: i NUMBER := 0;
193:
194: --l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
195: l_debug_on CONSTANT BOOLEAN := TRUE;
196: l_module_name CONSTANT VARCHAR2(100) := 'FTE_VEHICLE_PKG';
197: l_inventory_item_id NUMBER;
198:

Line 230: WSH_DEBUG_SV.PUSH(l_module_name);

226: newItem.ATTRIBUTE14 := p_attribute14;
227: newItem.ATTRIBUTE15 := p_attribute15;
228:
229: IF l_debug_on THEN
230: WSH_DEBUG_SV.PUSH(l_module_name);
231: END IF;
232:
233: VALIDATE_VEHICLE_TYPE(p_organization_name => p_organization_name,
234: p_status => p_status,

Line 246: WSH_DEBUG_SV.LOGMSG(l_module_name, 'ValidateVehicleType-'||x_return_status);

242: x_return_status => x_return_status,
243: x_error_table => x_error_table);
244:
245: IF l_debug_on THEN
246: WSH_DEBUG_SV.LOGMSG(l_module_name, 'ValidateVehicleType-'||x_return_status);
247: END IF;
248:
249: if (x_return_status = 'E')
250: then

Line 305: WSH_DEBUG_SV.LOGMSG(l_module_name, 'BeforeCreate');

301: END;
302: -- End : Check whether the given Name already exists
303:
304: IF l_debug_on THEN
305: WSH_DEBUG_SV.LOGMSG(l_module_name, 'BeforeCreate');
306: END IF;
307: INV_ITEM_GRP.Create_Item(p_Item_rec => newItem,
308: x_Item_rec => savedItem,
309: x_return_status => x_return_status,

Line 312: WSH_DEBUG_SV.LOGMSG(l_module_name, 'AfterCreate-'||x_return_status);

308: x_Item_rec => savedItem,
309: x_return_status => x_return_status,
310: x_Error_tbl => errorTable);
311: IF l_debug_on THEN
312: WSH_DEBUG_SV.LOGMSG(l_module_name, 'AfterCreate-'||x_return_status);
313: END IF;
314:
315: if (x_return_status = 'S')
316: then

Line 343: WSH_DEBUG_SV.LOGMSG(l_module_name, 'AfterInsertType');

339: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID)
340: RETURNING vehicle_type_id INTO x_vehicle_type_id;
341:
342: IF l_debug_on THEN
343: WSH_DEBUG_SV.LOGMSG(l_module_name, 'AfterInsertType');
344: END IF;
345:
346: FOR i IN 1..p_features_table.COUNT LOOP
347: INSERT INTO FTE_VEHICLE_FEATURES

Line 358: WSH_DEBUG_SV.LOGMSG(l_module_name, 'AfterInsertFeature');

354: SYSDATE, FND_GLOBAL.USER_ID,
355: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID);
356: END LOOP;
357: IF l_debug_on THEN
358: WSH_DEBUG_SV.LOGMSG(l_module_name, 'AfterInsertFeature');
359: END IF;
360:
361: end if;
362: -- UPDATE

Line 365: WSH_DEBUG_SV.LOGMSG(l_module_name, 'BeforeUpdate');

361: end if;
362: -- UPDATE
363: else
364: IF l_debug_on THEN
365: WSH_DEBUG_SV.LOGMSG(l_module_name, 'BeforeUpdate');
366: END IF;
367: newItem.INVENTORY_ITEM_ID := p_inventory_item_id;
368: INV_ITEM_GRP.Update_Item(p_Item_rec => newItem,
369: x_Item_rec => savedItem,

Line 373: WSH_DEBUG_SV.LOGMSG(l_module_name, 'AfterUpdate-'||x_return_status);

369: x_Item_rec => savedItem,
370: x_return_status => x_return_status,
371: x_Error_tbl => errorTable);
372: IF l_debug_on THEN
373: WSH_DEBUG_SV.LOGMSG(l_module_name, 'AfterUpdate-'||x_return_status);
374: END IF;
375: if (x_return_status = 'S')
376: then
377: UPDATE FTE_VEHICLE_TYPES

Line 400: WSH_DEBUG_SV.LOGMSG(l_module_name, 'AfterInsertType');

396: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
397: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
398: WHERE VEHICLE_TYPE_ID = p_vehicle_type_id;
399: IF l_debug_on THEN
400: WSH_DEBUG_SV.LOGMSG(l_module_name, 'AfterInsertType');
401: END IF;
402:
403: DELETE FTE_VEHICLE_FEATURES
404: WHERE VEHICLE_TYPE_ID = p_vehicle_type_id;

Line 406: WSH_DEBUG_SV.LOGMSG(l_module_name, 'AfterDeleteFeature');

402:
403: DELETE FTE_VEHICLE_FEATURES
404: WHERE VEHICLE_TYPE_ID = p_vehicle_type_id;
405: IF l_debug_on THEN
406: WSH_DEBUG_SV.LOGMSG(l_module_name, 'AfterDeleteFeature');
407: END IF;
408:
409: FOR i IN 1..p_features_table.COUNT LOOP
410: INSERT INTO FTE_VEHICLE_FEATURES

Line 421: WSH_DEBUG_SV.LOGMSG(l_module_name, 'AfterInsertFeature-Update');

417: SYSDATE, FND_GLOBAL.USER_ID,
418: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID);
419: END LOOP;
420: IF l_debug_on THEN
421: WSH_DEBUG_SV.LOGMSG(l_module_name, 'AfterInsertFeature-Update');
422: END IF;
423: end if;
424:
425: end if;

Line 430: WSH_DEBUG_SV.LOGMSG(l_module_name, errorRec.message_text);

426:
427: FOR i IN 1..errorTable.COUNT LOOP
428: errorRec := errorTable(i);
429: x_error_table(i) := errorRec.message_text;
430: WSH_DEBUG_SV.LOGMSG(l_module_name, errorRec.message_text);
431: END LOOP;
432:
433: IF l_debug_on THEN
434: WSH_DEBUG_SV.POP(l_module_name);

Line 434: WSH_DEBUG_SV.POP(l_module_name);

430: WSH_DEBUG_SV.LOGMSG(l_module_name, errorRec.message_text);
431: END LOOP;
432:
433: IF l_debug_on THEN
434: WSH_DEBUG_SV.POP(l_module_name);
435: END IF;
436:
437: IF (x_return_status <> 'S') THEN
438: ROLLBACK TO Create_Update_Vehicle_Type;

Line 445: WSH_DEBUG_SV.LOGMSG(l_module_name, 'Exception Others'||SQLERRM);

441: EXCEPTION WHEN OTHERS THEN
442: x_return_status := 'E';
443: x_error_table(1) := SQLERRM;
444: IF l_debug_on THEN
445: WSH_DEBUG_SV.LOGMSG(l_module_name, 'Exception Others'||SQLERRM);
446: WSH_DEBUG_SV.POP(l_module_name);
447: END IF;
448: ROLLBACK TO Create_Update_Vehicle_Type;
449: END CREATE_UPDATE_VEHICLE_TYPE;

Line 446: WSH_DEBUG_SV.POP(l_module_name);

442: x_return_status := 'E';
443: x_error_table(1) := SQLERRM;
444: IF l_debug_on THEN
445: WSH_DEBUG_SV.LOGMSG(l_module_name, 'Exception Others'||SQLERRM);
446: WSH_DEBUG_SV.POP(l_module_name);
447: END IF;
448: ROLLBACK TO Create_Update_Vehicle_Type;
449: END CREATE_UPDATE_VEHICLE_TYPE;
450: