[Home] [Help]
749: BEGIN
750: SELECT 'N'
751: INTO l_do_update_mmtt
752: FROM mtl_transaction_reasons mtr
753: , wms_exceptions we
754: WHERE we.reason_id = mtr.reason_id
755: AND we.task_id = l_mmtt_id
756: AND mtr.workflow_process = 'WMS_CYC_COUNT'
757: AND mtr.reason_context_code IN ('CP','PP');
1480: l_proc_name VARCHAR2(30) := 'Log_exception';
1481: BEGIN
1482:
1483: --Calculate Sequence Number
1484: select wms_exceptions_s.NEXTVAL INTO l_sequence from dual;
1485: g_debug := l_debug;
1486: g_module_name := l_proc_name;
1487: IF (l_debug = 1) THEN
1488: mdebug('Inserting into exceptions');
1487: IF (l_debug = 1) THEN
1488: mdebug('Inserting into exceptions');
1489: mdebug(l_sequence);
1490: END IF;
1491: INSERT INTO wms_exceptions(
1492: TASK_ID,
1493: SEQUENCE_NUMBER,
1494: ORGANIZATION_ID,
1495: INVENTORY_ITEM_ID,
1546: exception
1547: when others THEN
1548: x_return_status:=FND_API.G_RET_STS_ERROR;
1549:
1550: l_return_err := 'Insert into WMS_Exceptions failed'||
1551: substrb(sqlerrm,1,55);
1552: raise_application_error(-20000,l_return_err);
1553:
1554:
2320: l_discrepancy VARCHAR2(1000);
2321: l_reason_context_code VARCHAR2(2);
2322: l_reason_id NUMBER;
2323: l_transaction_temp_id NUMBER;
2324: l_subinventory_code wms_exceptions.subinventory_code%TYPE;
2325: l_locator_id NUMBER;
2326: l_lpn_id NUMBER;
2327: l_lot_number mtl_lot_numbers.lot_number%TYPE;
2328: l_workflow_name mtl_transaction_reasons.workflow_name%TYPE;
2529:
2530: EXCEPTION
2531: WHEN OTHERS THEN
2532: x_return_status:=FND_API.G_RET_STS_ERROR;
2533: l_return_err := 'Insert into WMS_Exceptions failed'|| substrb(sqlerrm,1,55);
2534: raise_application_error(-20000,l_return_err);
2535:
2536: END Log_exception;
2537: