DBA Data[Home] [Help]

APPS.WMS_TASK_SKIPPED dependencies on WMS_TASK_SKIPPED

Line 1: PACKAGE BODY wms_task_skipped AS

1: PACKAGE BODY wms_task_skipped AS
2: --/* $Header: WMSSKIPB.pls 120.5 2011/08/16 21:24:49 sahmahes ship $ */
3:
4:
5: PROCEDURE mydebug(msg in varchar2)

Line 247: mydebug('wms_task_skipped:: No MSN record found.');

243: and current_organization_id = l_org_id;
244:
245: IF SQL%NOTFOUND THEN
246: IF (l_debug = 1) THEN
247: mydebug('wms_task_skipped:: No MSN record found.');
248: END IF;
249:
250: ELSE
251: delete mtl_serial_numbers_temp

Line 256: mydebug('wms_task_skipped:: No MSNT found to delete anything');

252: where transaction_temp_id in (l_task_id, l_serial_transaction_temp_id);
253:
254: IF SQL%NOTFOUND THEN
255: IF (l_debug =1 ) then
256: mydebug('wms_task_skipped:: No MSNT found to delete anything');
257: END IF;
258: END IF;
259: END IF;
260: end if;

Line 266: mydebug('wms_task_skipped:: Successfully done with skip_task_adjustments');

262: END IF;
263: x_return_status:=FND_API.g_ret_sts_success;
264:
265: IF (l_debug =1 ) then
266: mydebug('wms_task_skipped:: Successfully done with skip_task_adjustments');
267: END IF;
268:
269:
270: COMMIT;

Line 305: END wms_task_skipped;

301:
302:
303:
304:
305: END wms_task_skipped;