[Home] [Help]
15: g_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
16: g_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
17: g_wms_installed NUMBER;
18:
19: g_log_level_unexpected NUMBER := FND_LOG.LEVEL_UNEXPECTED ;
20: g_log_level_error number := FND_LOG.LEVEL_ERROR ;
21: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;
22: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
23: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;
16: g_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
17: g_wms_installed NUMBER;
18:
19: g_log_level_unexpected NUMBER := FND_LOG.LEVEL_UNEXPECTED ;
20: g_log_level_error number := FND_LOG.LEVEL_ERROR ;
21: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;
22: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
23: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;
24: g_log_level_statement number := FND_LOG.LEVEL_STATEMENT ;
17: g_wms_installed NUMBER;
18:
19: g_log_level_unexpected NUMBER := FND_LOG.LEVEL_UNEXPECTED ;
20: g_log_level_error number := FND_LOG.LEVEL_ERROR ;
21: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;
22: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
23: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;
24: g_log_level_statement number := FND_LOG.LEVEL_STATEMENT ;
25:
18:
19: g_log_level_unexpected NUMBER := FND_LOG.LEVEL_UNEXPECTED ;
20: g_log_level_error number := FND_LOG.LEVEL_ERROR ;
21: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;
22: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
23: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;
24: g_log_level_statement number := FND_LOG.LEVEL_STATEMENT ;
25:
26: g_msg_lvl_unexp_error NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ;
19: g_log_level_unexpected NUMBER := FND_LOG.LEVEL_UNEXPECTED ;
20: g_log_level_error number := FND_LOG.LEVEL_ERROR ;
21: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;
22: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
23: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;
24: g_log_level_statement number := FND_LOG.LEVEL_STATEMENT ;
25:
26: g_msg_lvl_unexp_error NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ;
27: g_msg_lvl_error NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR ;
20: g_log_level_error number := FND_LOG.LEVEL_ERROR ;
21: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;
22: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
23: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;
24: g_log_level_statement number := FND_LOG.LEVEL_STATEMENT ;
25:
26: g_msg_lvl_unexp_error NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ;
27: g_msg_lvl_error NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR ;
28: g_msg_lvl_success NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS ;
324: l_status_type NUMBER;
325:
326: -- Logging variables.....
327: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
328: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
329:
330: l_stmt_num NUMBER;
331: l_module VARCHAR2(100) := 'wsm.plsql.WSM_SERIAL_SUPPORT_PVT.LBJ_serial_intf_proc';
332: l_param_tbl WSM_Log_PVT.param_tbl_type;
339: x_return_status := G_RET_SUCCESS;
340: x_error_msg := NULL;
341: x_error_count := 0;
342:
343: IF FND_LOG.LEVEL_PROCEDURE >= l_log_level THEN
344: l_stmt_num := 15;
345: l_param_tbl.delete;
346: l_param_tbl(1).paramName := 'p_wip_entity_id';
347: l_param_tbl(1).paramValue := p_wip_entity_id;
356: l_param_tbl(4).paramValue := p_header_id;
357:
358: WSM_Log_PVT.logProcParams(p_module_name => l_module ,
359: p_param_tbl => l_param_tbl,
360: p_fnd_log_level => l_log_level
361: );
362: END IF;
363:
364:
398: p_msg_appl_name => 'WSM' ,
399: p_msg_tokens => l_msg_tokens ,
400: p_stmt_num => l_stmt_num ,
401: p_fnd_msg_level => G_MSG_LVL_ERROR ,
402: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
403: p_run_log_level => l_log_level
404: );
405: END IF;
406: RAISE FND_API.G_EXC_ERROR;
412: WSM_log_PVT.logMessage (p_module_name => l_module ,
413: p_msg_text => 'Invoking LBJ_serial_processor',
414: p_stmt_num => l_stmt_num ,
415: p_msg_tokens => l_msg_tokens ,
416: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
417: p_run_log_level => l_log_level
418: );
419: END IF;
420:
465: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
466: THEN
467: WSM_log_PVT.handle_others( p_module_name => l_module ,
468: p_stmt_num => l_stmt_num ,
469: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
470: p_run_log_level => l_log_level
471: );
472: END IF;
473:
502: l_serial_tbl t_varchar2;
503:
504: -- Logging variables.....
505: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
506: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
507:
508: l_stmt_num NUMBER;
509: l_module VARCHAR2(100) := 'wsm.plsql.WSM_SERIAL_SUPPORT_PVT.LBJ_serial_processor';
510: l_param_tbl WSM_Log_PVT.param_tbl_type;
516: x_return_status := G_RET_SUCCESS;
517: x_error_msg := NULL;
518: x_error_count := 0;
519:
520: IF FND_LOG.LEVEL_PROCEDURE >= l_log_level THEN
521:
522: l_param_tbl.delete;
523: l_param_tbl(1).paramName := 'p_calling_mode';
524: l_param_tbl(1).paramValue := p_calling_mode;
533: l_param_tbl(4).paramValue := p_wsm_serial_nums_tbl.count;
534:
535: WSM_Log_PVT.logProcParams(p_module_name => l_module,
536: p_param_tbl => l_param_tbl,
537: p_fnd_log_level => l_log_level
538: );
539: END IF;
540:
541: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
595: p_msg_appl_name => 'WSM' ,
596: p_msg_tokens => l_msg_tokens ,
597: p_stmt_num => l_stmt_num ,
598: p_fnd_msg_level => G_MSG_LVL_ERROR ,
599: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
600: p_run_log_level => l_log_level
601: );
602: END IF;
603: RAISE FND_API.G_EXC_ERROR;
614: WSM_log_PVT.logMessage (p_module_name => l_module ,
615: p_msg_text => 'Invoking process_serial_info',
616: p_stmt_num => l_stmt_num ,
617: p_msg_tokens => l_msg_tokens ,
618: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
619: p_run_log_level => l_log_level
620: );
621: END IF;
622: -- invoke process_serial_info
667: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
668: THEN
669: WSM_log_PVT.handle_others( p_module_name => l_module ,
670: p_stmt_num => l_stmt_num ,
671: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
672: p_run_log_level => l_log_level
673: );
674: END IF;
675:
697: IS
698:
699: -- Logging variables.....
700: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
701: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
702:
703: l_stmt_num NUMBER;
704: l_module VARCHAR2(100) := 'wsm.plsql.WSM_SERIAL_SUPPORT_PVT.get_serial_track_info';
705: -- Logging variables...
742: p_msg_appl_name => 'WSM' ,
743: p_msg_tokens => l_msg_tokens ,
744: p_stmt_num => l_stmt_num ,
745: p_fnd_msg_level => G_MSG_LVL_ERROR ,
746: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
747: p_run_log_level => l_log_level
748: );
749: END IF;
750: RAISE FND_API.G_EXC_ERROR;
791: p_msg_appl_name => 'WSM' ,
792: p_msg_tokens => l_msg_tokens ,
793: p_stmt_num => l_stmt_num ,
794: p_fnd_msg_level => G_MSG_LVL_ERROR ,
795: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
796: p_run_log_level => l_log_level
797: );
798: END IF;
799: RAISE FND_API.G_EXC_ERROR;
816: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
817: THEN
818: WSM_log_PVT.handle_others( p_module_name => l_module ,
819: p_stmt_num => l_stmt_num ,
820: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
821: p_run_log_level => l_log_level
822: );
823: END IF;
824:
866: l_serial_number MTL_SERIAL_NUMBERS.SERIAL_NUMBER%TYPE;
867:
868: -- Logging variables.....
869: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
870: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
871:
872: l_stmt_num NUMBER;
873: l_module VARCHAR2(100) := 'wsm.plsql.WSM_SERIAL_SUPPORT_PVT.process_serial_info';
874: l_param_tbl WSM_Log_PVT.param_tbl_type;
880: x_return_status := G_RET_SUCCESS;
881: x_error_msg := NULL;
882: x_error_count := 0;
883:
884: IF FND_LOG.LEVEL_PROCEDURE >= l_log_level THEN
885:
886: l_param_tbl.delete;
887: l_param_tbl(1).paramName := 'p_operation_seq_num';
888: l_param_tbl(1).paramValue := p_operation_seq_num;
891: l_param_tbl(2).paramValue := p_intraoperation_step;
892:
893: WSM_Log_PVT.logProcParams(p_module_name => l_module ,
894: p_param_tbl => l_param_tbl,
895: p_fnd_log_level => l_log_level
896: );
897: END IF;
898:
899: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
901: WSM_log_PVT.logMessage (p_module_name => l_module ,
902: p_msg_text => 'Inside WSM_SERIAL_SUPPORT_PVT.process_serial_info',
903: p_stmt_num => l_stmt_num ,
904: p_msg_tokens => l_msg_tokens ,
905: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
906: p_run_log_level => l_log_level
907: );
908: END IF;
909:
1002: p_msg_appl_name => 'WSM' ,
1003: p_msg_tokens => l_msg_tokens ,
1004: p_stmt_num => l_stmt_num ,
1005: p_fnd_msg_level => G_MSG_LVL_ERROR ,
1006: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
1007: p_run_log_level => l_log_level
1008: );
1009: END IF;
1010: RAISE FND_API.G_EXC_ERROR;
1027: p_msg_appl_name => 'WSM' ,
1028: p_msg_tokens => l_msg_tokens ,
1029: p_stmt_num => l_stmt_num ,
1030: p_fnd_msg_level => G_MSG_LVL_ERROR ,
1031: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
1032: p_run_log_level => l_log_level
1033: );
1034: END IF;
1035: RAISE FND_API.G_EXC_ERROR;
1116: p_msg_appl_name => 'WSM' ,
1117: p_msg_tokens => l_msg_tokens ,
1118: p_stmt_num => l_stmt_num ,
1119: p_fnd_msg_level => G_MSG_LVL_ERROR ,
1120: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
1121: p_run_log_level => l_log_level
1122: );
1123: END IF;
1124: RAISE FND_API.G_EXC_ERROR;
1140: p_msg_appl_name => 'WSM' ,
1141: p_msg_tokens => l_msg_tokens ,
1142: p_stmt_num => l_stmt_num ,
1143: p_fnd_msg_level => G_MSG_LVL_ERROR ,
1144: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
1145: p_run_log_level => l_log_level
1146: );
1147: END IF;
1148: RAISE FND_API.G_EXC_ERROR;
1225: p_msg_appl_name => 'WSM' ,
1226: p_msg_tokens => l_msg_tokens ,
1227: p_stmt_num => l_stmt_num ,
1228: p_fnd_msg_level => G_MSG_LVL_ERROR ,
1229: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
1230: p_run_log_level => l_log_level
1231: );
1232: END IF;
1233: RAISE FND_API.G_EXC_ERROR;
1264: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
1265: THEN
1266: WSM_log_PVT.handle_others( p_module_name => l_module ,
1267: p_stmt_num => l_stmt_num ,
1268: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
1269: p_run_log_level => l_log_level
1270: );
1271: END IF;
1272:
1300: l_quantity NUMBER;
1301:
1302: -- Logging variables.....
1303: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
1304: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1305:
1306: l_stmt_num NUMBER;
1307: l_module VARCHAR2(100) := 'wsm.plsql.WSM_SERIAL_SUPPORT_PVT.add_assoc_serial_number';
1308: -- Logging variables...
1323: WSM_log_PVT.logMessage (p_module_name => l_module ,
1324: p_msg_text => 'Invoking inv_serial_number_pub.generate_serials',
1325: p_stmt_num => l_stmt_num ,
1326: p_msg_tokens => l_msg_tokens ,
1327: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
1328: p_run_log_level => l_log_level
1329: );
1330: END IF;
1331:
1357: p_msg_appl_name => 'WSM' ,
1358: p_msg_tokens => l_msg_tokens ,
1359: p_stmt_num => l_stmt_num ,
1360: p_fnd_msg_level => G_MSG_LVL_ERROR ,
1361: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
1362: p_run_log_level => l_log_level
1363: );
1364: END IF;
1365: RAISE FND_API.G_EXC_ERROR;
1373: WSM_log_PVT.logMessage (p_module_name => l_module ,
1374: p_msg_text => 'Invoke inv_serial_number_pub.generate_serials Success',
1375: p_stmt_num => l_stmt_num ,
1376: p_msg_tokens => l_msg_tokens ,
1377: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
1378: p_run_log_level => l_log_level
1379: );
1380: END IF;
1381:
1412: p_msg_appl_name => 'WSM' ,
1413: p_msg_tokens => l_msg_tokens ,
1414: p_stmt_num => l_stmt_num ,
1415: p_fnd_msg_level => G_MSG_LVL_ERROR ,
1416: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
1417: p_run_log_level => l_log_level
1418: );
1419:
1420:
1525: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
1526: THEN
1527: WSM_log_PVT.handle_others( p_module_name => l_module ,
1528: p_stmt_num => l_stmt_num ,
1529: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
1530: p_run_log_level => l_log_level
1531: );
1532: END IF;
1533:
1562:
1563:
1564: -- Logging variables.....
1565: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
1566: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1567:
1568: l_stmt_num NUMBER;
1569: l_module VARCHAR2(100) := 'wsm.plsql.WSM_SERIAL_SUPPORT_PVT.add_assoc_serial_number(2)';
1570: -- Logging variables...
1586: WSM_log_PVT.logMessage (p_module_name => l_module ,
1587: p_msg_text => 'Invoking inv_serial_number_pub.generate_serials',
1588: p_stmt_num => l_stmt_num ,
1589: p_msg_tokens => l_msg_tokens ,
1590: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
1591: p_run_log_level => l_log_level
1592: );
1593: END IF;
1594:
1620: p_msg_appl_name => 'WSM' ,
1621: p_msg_tokens => l_msg_tokens ,
1622: p_stmt_num => l_stmt_num ,
1623: p_fnd_msg_level => G_MSG_LVL_ERROR ,
1624: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
1625: p_run_log_level => l_log_level
1626: );
1627: END IF;
1628: RAISE FND_API.G_EXC_ERROR;
1661: p_msg_appl_name => 'WSM' ,
1662: p_msg_tokens => l_msg_tokens ,
1663: p_stmt_num => l_stmt_num ,
1664: p_fnd_msg_level => G_MSG_LVL_ERROR ,
1665: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
1666: p_run_log_level => l_log_level
1667: );
1668:
1669:
1681: WSM_log_PVT.logMessage (p_module_name => l_module ,
1682: p_msg_text => 'Invoking add_serial_number',
1683: p_stmt_num => l_stmt_num ,
1684: p_msg_tokens => l_msg_tokens ,
1685: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
1686: p_run_log_level => l_log_level
1687: );
1688: END IF;
1689:
1719: WSM_log_PVT.logMessage (p_module_name => l_module ,
1720: p_msg_text => 'Invoking update_serial',
1721: p_stmt_num => l_stmt_num ,
1722: p_msg_tokens => l_msg_tokens ,
1723: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
1724: p_run_log_level => l_log_level
1725: );
1726: END IF;
1727:
1776: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
1777: THEN
1778: WSM_log_PVT.handle_others( p_module_name => l_module ,
1779: p_stmt_num => l_stmt_num ,
1780: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
1781: p_run_log_level => l_log_level
1782: );
1783: END IF;
1784:
1816: l_gen_object_id NUMBER;
1817:
1818: -- Logging variables.....
1819: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
1820: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1821:
1822: l_stmt_num NUMBER;
1823: l_module VARCHAR2(100) := 'wsm.plsql.WSM_SERIAL_SUPPORT_PVT.add_serial_number';
1824: -- Logging variables...
1895: p_msg_appl_name => 'WIP' ,
1896: p_msg_tokens => l_msg_tokens ,
1897: p_stmt_num => l_stmt_num ,
1898: p_fnd_msg_level => G_MSG_LVL_ERROR ,
1899: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
1900: p_run_log_level => l_log_level
1901: );
1902: END IF;
1903: RAISE FND_API.G_EXC_ERROR;
1912: p_msg_appl_name => 'WIP' ,
1913: p_msg_tokens => l_msg_tokens ,
1914: p_stmt_num => l_stmt_num ,
1915: p_fnd_msg_level => G_MSG_LVL_ERROR ,
1916: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
1917: p_run_log_level => l_log_level
1918: );
1919: END IF;
1920: RAISE FND_API.G_EXC_ERROR;
1939: WSM_log_PVT.logMessage (p_module_name => l_module ,
1940: p_msg_text => 'Invoking inv_serial_number_pub.validate_serials',
1941: p_stmt_num => l_stmt_num ,
1942: p_msg_tokens => l_msg_tokens ,
1943: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
1944: p_run_log_level => l_log_level
1945: );
1946: END IF;
1947:
1994: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
1995: THEN
1996: WSM_log_PVT.handle_others( p_module_name => l_module ,
1997: p_stmt_num => l_stmt_num ,
1998: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
1999: p_run_log_level => l_log_level
2000: );
2001: END IF;
2002:
2040:
2041:
2042: -- Logging variables.....
2043: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
2044: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2045:
2046: l_stmt_num NUMBER;
2047: l_module VARCHAR2(100) := 'wsm.plsql.WSM_SERIAL_SUPPORT_PVT.update_serial_attr';
2048: l_param_tbl WSM_Log_PVT.param_tbl_type;
2054: x_return_status := G_RET_SUCCESS;
2055: x_error_msg := NULL;
2056: x_error_count := 0;
2057:
2058: IF FND_LOG.LEVEL_PROCEDURE >= l_log_level THEN
2059:
2060: l_param_tbl.delete;
2061: l_param_tbl(1).paramName := 'p_inventory_item_id';
2062: l_param_tbl(1).paramValue := p_inventory_item_id;
2068: l_param_tbl(3).paramValue := p_serial_attr_context;
2069:
2070: WSM_Log_PVT.logProcParams(p_module_name => l_module,
2071: p_param_tbl => l_param_tbl,
2072: p_fnd_log_level => l_log_level
2073: );
2074: END IF;
2075:
2076:
2108: WSM_log_PVT.logMessage (p_module_name => l_module ,
2109: p_msg_text => 'Value of l_update_serial_attr ' || l_update_serial_attr,
2110: p_stmt_num => l_stmt_num ,
2111: p_msg_tokens => l_msg_tokens ,
2112: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
2113: p_run_log_level => l_log_level
2114: );
2115: END IF;
2116:
2144: p_msg_name => 'WSM_INVALID_FIELD' ,
2145: p_msg_appl_name => 'WSM' ,
2146: p_msg_tokens => l_msg_tokens ,
2147: p_fnd_msg_level => G_MSG_LVL_SUCCESS ,
2148: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
2149: p_run_log_level => l_log_level ,
2150: p_wsm_warning => 1
2151: );
2152: END IF;
2312: WSM_log_PVT.logMessage (p_module_name => l_module ,
2313: p_msg_text => 'Value of p_update_desc_attr ' || p_update_desc_attr,
2314: p_stmt_num => l_stmt_num ,
2315: p_msg_tokens => l_msg_tokens ,
2316: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
2317: p_run_log_level => l_log_level
2318: );
2319: END IF;
2320:
2374: WSM_log_PVT.logMessage (p_module_name => l_module ,
2375: p_msg_text => 'Invoking the procedure update_serial_attr(2)',
2376: p_stmt_num => l_stmt_num ,
2377: p_msg_tokens => l_msg_tokens ,
2378: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
2379: p_run_log_level => l_log_level
2380: );
2381: END IF;
2382:
2427: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
2428: THEN
2429: WSM_log_PVT.handle_others( p_module_name => l_module ,
2430: p_stmt_num => l_stmt_num ,
2431: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
2432: p_run_log_level => l_log_level
2433: );
2434: END IF;
2435:
2460: l_context_value MTL_SERIAL_NUMBERS.serial_attribute_category%type;
2461:
2462: -- Logging variables.....
2463: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
2464: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2465:
2466: l_stmt_num NUMBER;
2467: l_module VARCHAR2(100) := 'wsm.plsql.WSM_SERIAL_SUPPORT_PVT.update_serial_attr(2)';
2468: l_param_tbl WSM_Log_PVT.param_tbl_type;
2474: x_return_status := G_RET_SUCCESS;
2475: x_error_msg := NULL;
2476: x_error_count := 0;
2477:
2478: IF FND_LOG.LEVEL_PROCEDURE >= l_log_level THEN
2479:
2480: l_param_tbl.delete;
2481: l_param_tbl(1).paramName := 'p_update_serial_attr';
2482: l_param_tbl(1).paramValue := p_update_serial_attr;
2485: l_param_tbl(2).paramValue := p_update_desc_attr;
2486:
2487: WSM_Log_PVT.logProcParams(p_module_name => l_module,
2488: p_param_tbl => l_param_tbl,
2489: p_fnd_log_level => l_log_level
2490: );
2491: END IF;
2492:
2493: l_update_serial_attr := p_update_serial_attr;
2523: WSM_log_PVT.logMessage (p_module_name => l_module ,
2524: p_msg_text => 'Value of l_update_serial_attr : ' || l_update_serial_attr,
2525: p_stmt_num => l_stmt_num ,
2526: p_msg_tokens => l_msg_tokens ,
2527: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
2528: p_run_log_level => l_log_level
2529: );
2530: END IF;
2531:
2538: WSM_log_PVT.logMessage (p_module_name => l_module ,
2539: p_msg_text => 'Invoking INV_SERIAL_NUMBER_PUB.validate_update_serial_att',
2540: p_stmt_num => l_stmt_num ,
2541: p_msg_tokens => l_msg_tokens ,
2542: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
2543: p_run_log_level => l_log_level
2544: );
2545: END IF;
2546:
2575: WSM_log_PVT.logMessage (p_module_name => l_module ,
2576: p_msg_text => 'Invoking INV_SERIAL_NUMBER_ATTR.Update_Serial_number_attr',
2577: p_stmt_num => l_stmt_num ,
2578: p_msg_tokens => l_msg_tokens ,
2579: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
2580: p_run_log_level => l_log_level
2581: );
2582: END IF;
2583:
2628: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
2629: THEN
2630: WSM_log_PVT.handle_others( p_module_name => l_module ,
2631: p_stmt_num => l_stmt_num ,
2632: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
2633: p_run_log_level => l_log_level
2634: );
2635: END IF;
2636:
2649: IS
2650:
2651: -- Logging variables.....
2652: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
2653: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2654:
2655: l_stmt_num NUMBER;
2656: l_module VARCHAR2(100) := 'wsm.plsql.WSM_SERIAL_SUPPORT_PVT.wms_installed';
2657: -- Logging variables...
2687: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
2688: THEN
2689: WSM_log_PVT.handle_others( p_module_name => l_module ,
2690: p_stmt_num => l_stmt_num ,
2691: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
2692: p_run_log_level => l_log_level
2693: );
2694: END IF;
2695:
2739: l_last_status NUMBER;
2740:
2741: -- Logging variables.....
2742: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
2743: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2744:
2745: l_stmt_num NUMBER;
2746: l_module VARCHAR2(100) := 'wsm.plsql.WSM_SERIAL_SUPPORT_PVT.update_serial';
2747: l_param_tbl WSM_Log_PVT.param_tbl_type;
2753: x_return_status := G_RET_SUCCESS;
2754: x_error_msg := NULL;
2755: x_error_count := 0;
2756:
2757: IF FND_LOG.LEVEL_PROCEDURE >= l_log_level THEN
2758:
2759: l_param_tbl.delete;
2760: l_param_tbl(1).paramName := 'p_serial_number';
2761: l_param_tbl(1).paramValue := p_serial_number;
2770: l_param_tbl(4).paramValue := p_intraoperation_step_type;
2771:
2772: WSM_Log_PVT.logProcParams(p_module_name => l_module,
2773: p_param_tbl => l_param_tbl,
2774: p_fnd_log_level => l_log_level
2775: );
2776: END IF;
2777:
2778: SAVEPOINT update_serial;
2840: WSM_log_PVT.logMessage (p_module_name => l_module ,
2841: p_msg_text => 'Invoking INV_SERIAL_NUMBER_PUB.updateserial',
2842: p_stmt_num => l_stmt_num ,
2843: p_msg_tokens => l_msg_tokens ,
2844: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
2845: p_run_log_level => l_log_level
2846: );
2847: END IF;
2848:
2913: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
2914: THEN
2915: WSM_log_PVT.handle_others( p_module_name => l_module ,
2916: p_stmt_num => l_stmt_num ,
2917: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
2918: p_run_log_level => l_log_level
2919: );
2920: END IF;
2921:
3163: l_row_updated NUMBER;
3164:
3165: -- Logging variables.....
3166: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
3167: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3168:
3169: l_stmt_num NUMBER;
3170: l_module VARCHAR2(100) := 'wsm.plsql.WSM_SERIAL_SUPPORT_PVT.Move_serial_intf_proc';
3171: l_param_tbl WSM_Log_PVT.param_tbl_type;
3177: x_return_status := G_RET_SUCCESS;
3178: x_error_msg := NULL;
3179: x_error_count := 0;
3180:
3181: IF FND_LOG.LEVEL_PROCEDURE >= l_log_level THEN
3182: l_stmt_num := 15;
3183: l_param_tbl.delete;
3184: l_param_tbl(1).paramName := 'p_wip_entity_id';
3185: l_param_tbl(1).paramValue := p_wip_entity_id;
3194: l_param_tbl(4).paramValue := p_header_id;
3195:
3196: WSM_Log_PVT.logProcParams(p_module_name => l_module ,
3197: p_param_tbl => l_param_tbl,
3198: p_fnd_log_level => l_log_level
3199: );
3200: END IF;
3201:
3202: -- first get all the serial numbers to be inserted/delinked/updated...
3253: p_msg_appl_name => 'WSM' ,
3254: p_msg_tokens => l_msg_tokens ,
3255: p_stmt_num => l_stmt_num ,
3256: p_fnd_msg_level => G_MSG_LVL_ERROR ,
3257: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3258: p_run_log_level => l_log_level
3259: );
3260: END IF;
3261: RAISE FND_API.G_EXC_ERROR;
3280: WSM_log_PVT.logMessage (p_module_name => l_module ,
3281: p_msg_text => 'Inside process_serial_info to process : ' || l_wsm_serial_nums_tbl.count || ' records',
3282: p_stmt_num => l_stmt_num ,
3283: p_msg_tokens => l_msg_tokens ,
3284: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
3285: p_run_log_level => l_log_level
3286: );
3287: END IF;
3288: process_serial_info (p_calling_mode => 1,
3338: p_msg_name => 'WSM_NO_FOR_SERIAL_UNDO_ASSYRET',
3339: p_msg_appl_name => 'WSM' ,
3340: p_msg_tokens => l_msg_tokens ,
3341: p_fnd_msg_level => G_MSG_LVL_ERROR ,
3342: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3343: p_run_log_level => l_log_level
3344: );
3345: END IF;
3346: RAISE FND_API.G_EXC_ERROR;
3380: p_msg_appl_name => 'WSM' ,
3381: p_msg_tokens => l_msg_tokens ,
3382: p_stmt_num => l_stmt_num ,
3383: p_fnd_msg_level => G_MSG_LVL_ERROR ,
3384: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3385: p_run_log_level => l_log_level
3386: );
3387: END IF;
3388: RAISE FND_API.G_EXC_ERROR;
3405: WSM_log_PVT.logMessage (p_module_name => l_module ,
3406: p_msg_text => 'Invoking Move_serial_processor',
3407: p_stmt_num => l_stmt_num ,
3408: p_msg_tokens => l_msg_tokens ,
3409: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
3410: p_run_log_level => l_log_level
3411: );
3412: END IF;
3413: -- then call the Move Serial Processor..
3453: WSM_log_PVT.logMessage (p_module_name => l_module ,
3454: p_msg_text => 'Move_serial_intf_proc Sucess',
3455: p_stmt_num => l_stmt_num ,
3456: p_msg_tokens => l_msg_tokens ,
3457: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
3458: p_run_log_level => l_log_level
3459: );
3460: END IF;
3461:
3485: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
3486: THEN
3487: WSM_log_PVT.handle_others( p_module_name => l_module ,
3488: p_stmt_num => l_stmt_num ,
3489: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
3490: p_run_log_level => l_log_level
3491: );
3492: END IF;
3493:
3532: l_old_serial_track_flag NUMBER;
3533:
3534: -- Logging variables.....
3535: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
3536: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3537:
3538: l_stmt_num NUMBER;
3539: l_module VARCHAR2(100) := 'wsm.plsql.WSM_SERIAL_SUPPORT_PVT.Move_serial_processor';
3540: l_param_tbl WSM_Log_PVT.param_tbl_type;
3547: x_error_msg := NULL;
3548: x_error_count := 0;
3549:
3550: l_stmt_num := 10;
3551: IF FND_LOG.LEVEL_PROCEDURE >= l_log_level THEN
3552:
3553: l_param_tbl.delete;
3554: l_param_tbl(1).paramName := 'p_calling_mode';
3555: l_param_tbl(1).paramValue := p_calling_mode;
3570: l_param_tbl(6).paramValue := p_scrap_at_operation;
3571:
3572: WSM_Log_PVT.logProcParams(p_module_name => l_module,
3573: p_param_tbl => l_param_tbl,
3574: p_fnd_log_level => l_log_level
3575: );
3576: END IF;
3577:
3578: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
3601: WSM_log_PVT.logMessage (p_module_name => l_module ,
3602: p_msg_text => 'Invoking WSM_SERIAL_SUPPORT_PVT.check_move_serial_qty',
3603: p_stmt_num => l_stmt_num ,
3604: p_msg_tokens => l_msg_tokens ,
3605: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
3606: p_run_log_level => l_log_level
3607: );
3608: END IF;
3609:
3652: WSM_log_PVT.logMessage (p_module_name => l_module ,
3653: p_msg_text => 'Value of x_serial_track_flag : ' || x_serial_track_flag,
3654: p_stmt_num => l_stmt_num ,
3655: p_msg_tokens => l_msg_tokens ,
3656: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
3657: p_run_log_level => l_log_level
3658: );
3659: END IF;
3660:
3678: WSM_log_PVT.logMessage (p_module_name => l_module ,
3679: p_msg_text => 'Updated WIP_DISCRETE_JOBS to set the serialization_start_op',
3680: p_stmt_num => l_stmt_num ,
3681: p_msg_tokens => l_msg_tokens ,
3682: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
3683: p_run_log_level => l_log_level
3684: );
3685: END IF;
3686:
3697: WSM_log_PVT.logMessage (p_module_name => l_module ,
3698: p_msg_text => 'Invoking WSM_Serial_support_PVT.populate_undo_txn',
3699: p_stmt_num => l_stmt_num ,
3700: p_msg_tokens => l_msg_tokens ,
3701: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
3702: p_run_log_level => l_log_level
3703: );
3704: END IF;
3705:
3741: WSM_log_PVT.logMessage (p_module_name => l_module ,
3742: p_msg_text => 'Updated ' || SQL%ROWCOUNT || ' records in WSM_LOT_BASED_JOBS',
3743: p_stmt_num => l_stmt_num ,
3744: p_msg_tokens => l_msg_tokens ,
3745: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
3746: p_run_log_level => l_log_level
3747: );
3748: END IF;
3749: END IF;
3774: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
3775: THEN
3776: WSM_log_PVT.handle_others( p_module_name => l_module ,
3777: p_stmt_num => l_stmt_num ,
3778: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
3779: p_run_log_level => l_log_level
3780: );
3781: END IF;
3782:
3845: and msn.wip_entity_id = p_wip_entity_id;
3846:
3847: -- Logging variables.....
3848: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
3849: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3850:
3851: l_stmt_num NUMBER;
3852: l_module VARCHAR2(100) := 'wsm.plsql.WSM_SERIAL_SUPPORT_PVT.check_move_serial_qty';
3853: l_param_tbl WSM_Log_PVT.param_tbl_type;
3861: x_return_status := G_RET_SUCCESS;
3862: x_error_msg := NULL;
3863: x_error_count := 0;
3864:
3865: IF FND_LOG.LEVEL_PROCEDURE >= l_log_level THEN
3866:
3867: l_param_tbl.delete;
3868: l_param_tbl(1).paramName := 'p_available_qty';
3869: l_param_tbl(1).paramValue := p_available_qty;
3884: l_param_tbl(6).paramValue := p_serial_num_tbl.count;
3885:
3886: WSM_Log_PVT.logProcParams(p_module_name => l_module,
3887: p_param_tbl => l_param_tbl,
3888: p_fnd_log_level => l_log_level
3889: );
3890: END IF;
3891:
3892: l_old_serial_track_status := x_serial_track_flag;
3940: WSM_log_PVT.logMessage (p_module_name => l_module ,
3941: p_msg_text => 'Serial Tracking for the Job : ' || x_serial_track_flag,
3942: p_stmt_num => l_stmt_num ,
3943: p_msg_tokens => l_msg_tokens ,
3944: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
3945: p_run_log_level => l_log_level
3946: );
3947: END IF;
3948:
3959: p_msg_appl_name => 'WSM' ,
3960: p_msg_tokens => l_msg_tokens ,
3961: p_stmt_num => l_stmt_num ,
3962: p_fnd_msg_level => G_MSG_LVL_ERROR ,
3963: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3964: p_run_log_level => l_log_level
3965: );
3966: END IF;
3967: RAISE FND_API.G_EXC_ERROR;
4001: p_msg_name => 'WSM_PARTIAL_EXCESS_SERIAL',
4002: p_msg_appl_name => 'WSM' ,
4003: p_msg_tokens => l_msg_tokens ,
4004: p_fnd_msg_level => G_MSG_LVL_ERROR ,
4005: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4006: p_run_log_level => l_log_level
4007: );
4008: END IF;
4009: RAISE FND_API.G_EXC_ERROR;
4024: p_msg_appl_name => 'WSM' ,
4025: p_msg_tokens => l_msg_tokens ,
4026: p_stmt_num => l_stmt_num ,
4027: p_fnd_msg_level => G_MSG_LVL_ERROR ,
4028: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4029: p_run_log_level => l_log_level
4030: );
4031: END IF;
4032: RAISE FND_API.G_EXC_ERROR;
4055: p_msg_appl_name => 'WSM' ,
4056: p_msg_tokens => l_msg_tokens ,
4057: p_stmt_num => l_stmt_num ,
4058: p_fnd_msg_level => G_MSG_LVL_ERROR ,
4059: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4060: p_run_log_level => l_log_level
4061: );
4062: END IF;
4063: RAISE FND_API.G_EXC_ERROR;
4081: WSM_log_PVT.logMessage (p_module_name => l_module ,
4082: p_msg_text => 'User provided serials to be moved : ' || l_move_serial_qty || ' : Serials to be scrapped : ' || l_scrap_serial_qty,
4083: p_stmt_num => l_stmt_num ,
4084: p_msg_tokens => l_msg_tokens ,
4085: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
4086: p_run_log_level => l_log_level
4087: );
4088: END IF;
4089: l_stmt_num := 70;
4108: p_msg_appl_name => 'WSM' ,
4109: p_msg_tokens => l_msg_tokens ,
4110: p_stmt_num => l_stmt_num ,
4111: p_fnd_msg_level => G_MSG_LVL_ERROR ,
4112: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4113: p_run_log_level => l_log_level
4114: );
4115: END IF;
4116: RAISE FND_API.G_EXC_ERROR;
4165: WSM_log_PVT.logMessage (p_module_name => l_module ,
4166: p_msg_text => 'Going to Insert ' || l_count || ' user provided records into wip_serial_move_interface for move and scrap',
4167: p_stmt_num => l_stmt_num ,
4168: p_msg_tokens => l_msg_tokens ,
4169: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
4170: p_run_log_level => l_log_level
4171: );
4172: END IF;
4173:
4238: WSM_log_PVT.logMessage (p_module_name => l_module ,
4239: p_msg_text => 'Inserted ' || SQL%ROWCOUNT || ' records into wip_serial_move_interface for scrap',
4240: p_stmt_num => l_stmt_num ,
4241: p_msg_tokens => l_msg_tokens ,
4242: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
4243: p_run_log_level => l_log_level
4244: );
4245: END IF;
4246:
4297: WSM_log_PVT.logMessage (p_module_name => l_module ,
4298: p_msg_text => 'Going to Insert ' || l_count || ' user provided records into wip_serial_move_interface for move and scrap',
4299: p_stmt_num => l_stmt_num ,
4300: p_msg_tokens => l_msg_tokens ,
4301: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
4302: p_run_log_level => l_log_level
4303: );
4304: END IF;
4305:
4371: WSM_log_PVT.logMessage (p_module_name => l_module ,
4372: p_msg_text => 'Inserted ' || SQL%ROWCOUNT || ' records into wip_serial_move_interface for Move',
4373: p_stmt_num => l_stmt_num ,
4374: p_msg_tokens => l_msg_tokens ,
4375: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
4376: p_run_log_level => l_log_level
4377: );
4378: END IF;
4379:
4433: WSM_log_PVT.logMessage (p_module_name => l_module ,
4434: p_msg_text => 'Inserted ' || SQL%ROWCOUNT || ' records into WIP_SERIAL_MOVE_INTERFACE to be moved',
4435: p_stmt_num => l_stmt_num ,
4436: p_msg_tokens => l_msg_tokens ,
4437: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
4438: p_run_log_level => l_log_level
4439: );
4440: END IF;
4441:
4491: WSM_log_PVT.logMessage (p_module_name => l_module ,
4492: p_msg_text => 'Inserted ' || SQL%ROWCOUNT || ' records into WIP_SERIAL_MOVE_INTERFACE to be scrapped',
4493: p_stmt_num => l_stmt_num ,
4494: p_msg_tokens => l_msg_tokens ,
4495: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
4496: p_run_log_level => l_log_level
4497: );
4498: END IF;
4499:
4515: p_msg_appl_name => 'WSM' ,
4516: p_msg_tokens => l_msg_tokens ,
4517: p_stmt_num => l_stmt_num ,
4518: p_fnd_msg_level => G_MSG_LVL_ERROR ,
4519: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4520: p_run_log_level => l_log_level
4521: );
4522: END IF;
4523: RAISE FND_API.G_EXC_ERROR;
4571: WSM_log_PVT.logMessage (p_module_name => l_module ,
4572: p_msg_text => 'Going to insert ' || l_wip_serial_nums_tbl.count || ' records into WIP_SERIAL_MOVE_INTERFACE to be scrapped',
4573: p_stmt_num => l_stmt_num ,
4574: p_msg_tokens => l_msg_tokens ,
4575: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
4576: p_run_log_level => l_log_level
4577: );
4578: END IF;
4579:
4592: WSM_log_PVT.logMessage (p_module_name => l_module ,
4593: p_msg_text => 'Serial Attributes updation start',
4594: p_stmt_num => l_stmt_num ,
4595: p_msg_tokens => l_msg_tokens ,
4596: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
4597: p_run_log_level => l_log_level
4598: );
4599: END IF;
4600:
4609: 'Serial Attributes updation for serial number ' ||
4610: p_serial_num_tbl(l_cntr).serial_number,
4611: p_stmt_num => l_stmt_num ,
4612: p_msg_tokens => l_msg_tokens ,
4613: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
4614: p_run_log_level => l_log_level
4615: );
4616: END IF;
4617:
4653: || ' Operation : ' || p_curr_job_op_seq_num
4654: || ' Op Step : ' || p_curr_job_intraop_step,
4655: p_stmt_num => l_stmt_num ,
4656: p_msg_tokens => l_msg_tokens ,
4657: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
4658: p_run_log_level => l_log_level
4659: );
4660: END IF;
4661:
4708: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
4709: THEN
4710: WSM_log_PVT.handle_others( p_module_name => l_module ,
4711: p_stmt_num => l_stmt_num ,
4712: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
4713: p_run_log_level => l_log_level
4714: );
4715: END IF;
4716:
4781: l_pos NUMBER;
4782:
4783: -- Logging variables.....
4784: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
4785: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4786:
4787: l_stmt_num NUMBER;
4788: l_module VARCHAR2(100) := 'wsm.plsql.WSM_SERIAL_SUPPORT_PVT.populate_undo_txn';
4789: l_param_tbl WSM_Log_PVT.param_tbl_type;
4796: x_return_status := G_RET_SUCCESS;
4797: x_error_msg := NULL;
4798: x_error_count := 0;
4799:
4800: IF FND_LOG.LEVEL_PROCEDURE >= l_log_level THEN
4801:
4802: l_param_tbl.delete;
4803: l_param_tbl(1).paramName := 'p_move_qty';
4804: l_param_tbl(1).paramValue := p_move_qty;
4816: l_param_tbl(5).paramValue := p_old_scrap_txn_id;
4817:
4818: WSM_Log_PVT.logProcParams(p_module_name => l_module,
4819: p_param_tbl => l_param_tbl,
4820: p_fnd_log_level => l_log_level
4821: );
4822: END IF;
4823:
4824: IF p_move_txn_type = 3 THEN -- assembly return
4844: WSM_log_PVT.logMessage (p_module_name => l_module ,
4845: p_msg_text => 'Undo Transaction (Move): Serial Records found for p_old_move_txn_id: ' || l_move_serial_num_list.count,
4846: p_stmt_num => l_stmt_num ,
4847: p_msg_tokens => l_msg_tokens ,
4848: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
4849: p_run_log_level => l_log_level
4850: );
4851: END IF;
4852:
4867: p_msg_appl_name => 'WSM' ,
4868: p_msg_tokens => l_msg_tokens ,
4869: p_stmt_num => l_stmt_num ,
4870: p_fnd_msg_level => G_MSG_LVL_ERROR ,
4871: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4872: p_run_log_level => l_log_level
4873: );
4874: END IF;
4875: RAISE FND_API.G_EXC_ERROR;
4903: WSM_log_PVT.logMessage (p_module_name => l_module ,
4904: p_msg_text => 'Undo Transaction (Scrap): Serial Records found : ' || l_scrap_serial_num_list.count,
4905: p_stmt_num => l_stmt_num ,
4906: p_msg_tokens => l_msg_tokens ,
4907: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
4908: p_run_log_level => l_log_level
4909: );
4910: END IF;
4911:
4924: p_msg_appl_name => 'WSM' ,
4925: p_msg_tokens => l_msg_tokens ,
4926: p_stmt_num => l_stmt_num ,
4927: p_fnd_msg_level => G_MSG_LVL_ERROR ,
4928: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4929: p_run_log_level => l_log_level
4930: );
4931: END IF;
4932: RAISE FND_API.G_EXC_ERROR;
4990: WSM_log_PVT.logMessage (p_module_name => l_module ,
4991: p_msg_text => 'Undo Transaction : Going to insert : ' || l_wip_serial_rows_tbl.count || ' records',
4992: p_stmt_num => l_stmt_num ,
4993: p_msg_tokens => l_msg_tokens ,
4994: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
4995: p_run_log_level => l_log_level
4996: );
4997: END IF;
4998:
5024: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
5025: THEN
5026: WSM_log_PVT.handle_others( p_module_name => l_module ,
5027: p_stmt_num => l_stmt_num ,
5028: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
5029: p_run_log_level => l_log_level
5030: );
5031: END IF;
5032:
5156: -- first process Delete and then add
5157:
5158: -- Logging variables.....
5159: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
5160: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5161:
5162: l_stmt_num NUMBER;
5163: l_module VARCHAR2(100) := 'wsm.plsql.WSM_SERIAL_SUPPORT_PVT.WLT_serial_intf_proc';
5164: l_param_tbl WSM_Log_PVT.param_tbl_type;
5170: x_return_status := G_RET_SUCCESS;
5171: x_error_msg := NULL;
5172: x_error_count := 0;
5173:
5174: IF FND_LOG.LEVEL_PROCEDURE >= l_log_level THEN
5175: l_stmt_num := 15;
5176: l_param_tbl.delete;
5177: l_param_tbl(1).paramName := 'p_wip_entity_id';
5178: l_param_tbl(1).paramValue := p_wip_entity_id;
5187: l_param_tbl(4).paramValue := p_header_id;
5188:
5189: WSM_Log_PVT.logProcParams(p_module_name => l_module ,
5190: p_param_tbl => l_param_tbl,
5191: p_fnd_log_level => l_log_level
5192: );
5193: END IF;
5194:
5195: if p_wlt_txn_type = (WSMPCNST.SPLIT) THEN -- check for the correctness..
5228: p_msg_appl_name => 'WSM' ,
5229: p_msg_tokens => l_msg_tokens ,
5230: p_stmt_num => l_stmt_num ,
5231: p_fnd_msg_level => G_MSG_LVL_ERROR ,
5232: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5233: p_run_log_level => l_log_level
5234: );
5235: END IF;
5236: RAISE FND_API.G_EXC_ERROR;
5272: p_msg_appl_name => 'WSM' ,
5273: p_msg_tokens => l_msg_tokens ,
5274: p_stmt_num => l_stmt_num ,
5275: p_fnd_msg_level => G_MSG_LVL_ERROR ,
5276: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5277: p_run_log_level => l_log_level
5278: );
5279: END IF;
5280: RAISE FND_API.G_EXC_ERROR;
5288: WSM_log_PVT.logMessage (p_module_name => l_module ,
5289: p_msg_text => 'l_wip_entity_id : ' || l_wip_entity_id || ' l_inventory_item_id : ' || l_inventory_item_id,
5290: p_stmt_num => l_stmt_num ,
5291: p_msg_tokens => l_msg_tokens ,
5292: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
5293: p_run_log_level => l_log_level
5294: );
5295: END IF;
5296:
5321: p_msg_appl_name => 'WSM' ,
5322: p_msg_tokens => l_msg_tokens ,
5323: p_stmt_num => l_stmt_num ,
5324: p_fnd_msg_level => G_MSG_LVL_ERROR ,
5325: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5326: p_run_log_level => l_log_level
5327: );
5328: END IF;
5329: RAISE FND_API.G_EXC_ERROR;
5359: p_msg_appl_name => 'WSM' ,
5360: p_msg_tokens => l_msg_tokens ,
5361: p_stmt_num => l_stmt_num ,
5362: p_fnd_msg_level => G_MSG_LVL_ERROR ,
5363: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5364: p_run_log_level => l_log_level
5365: );
5366: END IF;
5367: RAISE FND_API.G_EXC_ERROR;
5394: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
5395: THEN
5396: WSM_log_PVT.handle_others( p_module_name => l_module ,
5397: p_stmt_num => l_stmt_num ,
5398: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
5399: p_run_log_level => l_log_level
5400: );
5401: END IF;
5402:
5436: l_new_index NUMBER;
5437:
5438: -- Logging variables.....
5439: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
5440: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5441:
5442: l_stmt_num NUMBER;
5443: l_module VARCHAR2(100) := 'wsm.plsql.WSM_SERIAL_SUPPORT_PVT.fetch_wlt_serials';
5444: l_param_tbl WSM_Log_PVT.param_tbl_type;
5457: WSM_log_PVT.logMessage (p_module_name => l_module ,
5458: p_msg_text => 'Inside fetch_wlt_serials',
5459: p_stmt_num => l_stmt_num ,
5460: p_msg_tokens => l_msg_tokens ,
5461: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
5462: p_run_log_level => l_log_level
5463: );
5464: END IF;
5465:
5492: WSM_log_PVT.logMessage (p_module_name => l_module ,
5493: p_msg_text => 'Inside fetch_wlt_serials : Serial Numbers count : ' || p_serial_num_tbl.count,
5494: p_stmt_num => l_stmt_num ,
5495: p_msg_tokens => l_msg_tokens ,
5496: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
5497: p_run_log_level => l_log_level
5498: );
5499: END IF;
5500:
5507: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
5508: THEN
5509: WSM_log_PVT.handle_others( p_module_name => l_module ,
5510: p_stmt_num => l_stmt_num ,
5511: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
5512: p_run_log_level => l_log_level
5513: );
5514: END IF;
5515:
5536: IS
5537:
5538: -- Logging variables.....
5539: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
5540: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5541:
5542: l_stmt_num NUMBER;
5543: l_module VARCHAR2(100) := 'wsm.plsql.WSM_SERIAL_SUPPORT_PVT.Insert_into_WST';
5544: l_param_tbl WSM_Log_PVT.param_tbl_type;
5550: x_return_status := G_RET_SUCCESS;
5551: x_error_msg := NULL;
5552: x_error_count := 0;
5553:
5554: IF FND_LOG.LEVEL_PROCEDURE >= l_log_level THEN
5555: l_stmt_num := 15;
5556: l_param_tbl.delete;
5557: l_param_tbl(1).paramName := 'p_transaction_type_id';
5558: l_param_tbl(1).paramValue := p_transaction_type_id;
5567: l_param_tbl(4).paramValue := p_transaction_id;
5568:
5569: WSM_Log_PVT.logProcParams(p_module_name => l_module ,
5570: p_param_tbl => l_param_tbl,
5571: p_fnd_log_level => l_log_level
5572: );
5573: END IF;
5574:
5575: l_stmt_num := 20;
5630: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
5631: THEN
5632: WSM_log_PVT.handle_others( p_module_name => l_module ,
5633: p_stmt_num => l_stmt_num ,
5634: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
5635: p_run_log_level => l_log_level
5636: );
5637: END IF;
5638:
5729: AND msn.current_organization_id = p_organization_id;
5730:
5731: -- Logging variables.....
5732: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
5733: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5734:
5735: l_stmt_num NUMBER;
5736: l_module VARCHAR2(100) := 'wsm.plsql.WSM_SERIAL_SUPPORT_PVT.WLT_serial_processor';
5737: l_param_tbl WSM_Log_PVT.param_tbl_type;
5745: x_return_status := G_RET_SUCCESS;
5746: x_error_msg := NULL;
5747: x_error_count := 0;
5748:
5749: IF FND_LOG.LEVEL_PROCEDURE >= l_log_level THEN
5750:
5751: l_param_tbl.delete;
5752: l_param_tbl(1).paramName := 'p_calling_mode';
5753: l_param_tbl(1).paramValue := p_calling_mode;
5765: l_param_tbl(5).paramValue := p_wlt_txn_type;
5766:
5767: WSM_Log_PVT.logProcParams(p_module_name => l_module,
5768: p_param_tbl => l_param_tbl,
5769: p_fnd_log_level => l_log_level
5770: );
5771: END IF;
5772:
5773: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
5862: || ' l_curr_job_op_step : ' || l_curr_job_op_step
5863: || ' p_serial_num_tbl.count ' || p_serial_num_tbl.count,
5864: p_stmt_num => l_stmt_num ,
5865: p_msg_tokens => l_msg_tokens ,
5866: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
5867: p_run_log_level => l_log_level
5868: );
5869: END IF;
5870:
5885: p_msg_appl_name => 'WSM' ,
5886: p_stmt_num => l_stmt_num ,
5887: p_msg_tokens => l_msg_tokens ,
5888: p_fnd_msg_level => G_MSG_LVL_ERROR ,
5889: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5890: p_run_log_level => l_log_level
5891: );
5892: END IF;
5893: RAISE FND_API.G_EXC_ERROR;
5917: p_msg_text => 'Serial Numbers of Parent Job : ' || l_serial_num_count ||
5918: ' Provided Serial Numbers : ' || p_serial_num_tbl.count,
5919: p_stmt_num => l_stmt_num ,
5920: p_msg_tokens => l_msg_tokens ,
5921: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
5922: p_run_log_level => l_log_level
5923: );
5924: END IF;
5925: IF (l_serial_num_count = 0 and p_serial_num_tbl.count = 0) THEN
5939: p_msg_appl_name => 'WSM' ,
5940: p_msg_tokens => l_msg_tokens ,
5941: p_stmt_num => l_stmt_num ,
5942: p_fnd_msg_level => G_MSG_LVL_ERROR ,
5943: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5944: p_run_log_level => l_log_level
5945: );
5946: END IF;
5947: RAISE FND_API.G_EXC_ERROR;
5974: p_msg_appl_name => 'WSM' ,
5975: p_msg_tokens => l_msg_tokens ,
5976: p_stmt_num => l_stmt_num ,
5977: p_fnd_msg_level => G_MSG_LVL_ERROR ,
5978: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5979: p_run_log_level => l_log_level
5980: );
5981: END IF;
5982: RAISE FND_API.G_EXC_ERROR;
6044: p_msg_appl_name => 'WSM' ,
6045: p_msg_tokens => l_msg_tokens ,
6046: p_stmt_num => l_stmt_num ,
6047: p_fnd_msg_level => G_MSG_LVL_ERROR ,
6048: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6049: p_run_log_level => l_log_level
6050: );
6051: END IF;
6052: RAISE FND_API.G_EXC_ERROR;
6071: ' Job Index Start : ' || l_job_ser_info_tbl(l_temp_job).l_index_start ||
6072: ' Count : ' || l_job_ser_info_tbl(l_temp_job).l_count ,
6073: p_stmt_num => l_stmt_num ,
6074: p_msg_tokens => l_msg_tokens ,
6075: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
6076: p_run_log_level => l_log_level
6077: );
6078: l_temp_job := l_job_ser_info_tbl.next(l_temp_job);
6079: END LOOP;
6137: p_msg_appl_name => 'WSM' ,
6138: p_msg_tokens => l_msg_tokens ,
6139: p_stmt_num => l_stmt_num ,
6140: p_fnd_msg_level => G_MSG_LVL_ERROR ,
6141: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6142: p_run_log_level => l_log_level
6143: );
6144: END IF;
6145: RAISE FND_API.G_EXC_ERROR;
6175: p_msg_appl_name => 'WSM' ,
6176: p_msg_tokens => l_msg_tokens ,
6177: p_stmt_num => l_stmt_num ,
6178: p_fnd_msg_level => G_MSG_LVL_ERROR ,
6179: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6180: p_run_log_level => l_log_level
6181: );
6182: END IF;
6183: RAISE FND_API.G_EXC_ERROR;
6191: WSM_log_PVT.logMessage (p_module_name => l_module ,
6192: p_msg_text => 'Deriving serial numbers for the job : ' || l_filling_job_name,
6193: p_stmt_num => l_stmt_num ,
6194: p_msg_tokens => l_msg_tokens ,
6195: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
6196: p_run_log_level => l_log_level
6197: );
6198: END IF;
6199:
6234: WSM_log_PVT.logMessage (p_module_name => l_module ,
6235: p_msg_text => 'After decrementing all the subsequent indices',
6236: p_stmt_num => l_stmt_num ,
6237: p_msg_tokens => l_msg_tokens ,
6238: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
6239: p_run_log_level => l_log_level
6240: );
6241: l_temp_job := l_job_ser_info_tbl.first;
6242: WHILE l_temp_job IS NOT NULL LOOP
6246: ' Job Index Start : ' || l_job_ser_info_tbl(l_temp_job).l_index_start ||
6247: ' Count : ' || l_job_ser_info_tbl(l_temp_job).l_count ,
6248: p_stmt_num => l_stmt_num ,
6249: p_msg_tokens => l_msg_tokens ,
6250: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
6251: p_run_log_level => l_log_level
6252: );
6253: l_temp_job := l_job_ser_info_tbl.next(l_temp_job);
6254: END LOOP;
6260: ' Serial Number : ' || p_serial_num_tbl(l_index1).serial_number ||
6261: ' Job Name : ' || p_serial_num_tbl(l_index1).changed_wip_entity_name ,
6262: p_stmt_num => l_stmt_num ,
6263: p_msg_tokens => l_msg_tokens ,
6264: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
6265: p_run_log_level => l_log_level
6266: );
6267: l_index1 := p_serial_num_tbl.next(l_index1);
6268: END LOOP;
6336: WSM_log_PVT.logMessage (p_module_name => l_module ,
6337: p_msg_text => 'After all operations',
6338: p_stmt_num => l_stmt_num ,
6339: p_msg_tokens => l_msg_tokens ,
6340: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
6341: p_run_log_level => l_log_level
6342: );
6343:
6344: l_temp_job := l_job_ser_info_tbl.first;
6349: ' Job Index Start : ' || l_job_ser_info_tbl(l_temp_job).l_index_start ||
6350: ' Count : ' || l_job_ser_info_tbl(l_temp_job).l_count ,
6351: p_stmt_num => l_stmt_num ,
6352: p_msg_tokens => l_msg_tokens ,
6353: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
6354: p_run_log_level => l_log_level
6355: );
6356: l_temp_job := l_job_ser_info_tbl.next(l_temp_job);
6357: END LOOP;
6363: ' Serial Number : ' || p_serial_num_tbl(l_index1).serial_number ||
6364: ' Job Name : ' || p_serial_num_tbl(l_index1).changed_wip_entity_name ,
6365: p_stmt_num => l_stmt_num ,
6366: p_msg_tokens => l_msg_tokens ,
6367: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
6368: p_run_log_level => l_log_level
6369: );
6370: l_index1 := p_serial_num_tbl.next(l_index1);
6371: END LOOP;
6380: p_msg_text => 'Total Serial Numbers : Old count : ' || l_old_count
6381: || ' New Count (After Derivation) : '|| l_new_count,
6382: p_stmt_num => l_stmt_num ,
6383: p_msg_tokens => l_msg_tokens ,
6384: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
6385: p_run_log_level => l_log_level
6386: );
6387: END IF;
6388:
6405: p_msg_appl_name => 'WSM' ,
6406: p_msg_tokens => l_msg_tokens ,
6407: p_stmt_num => l_stmt_num ,
6408: p_fnd_msg_level => G_MSG_LVL_ERROR ,
6409: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6410: p_run_log_level => l_log_level
6411: );
6412: END IF;
6413: RAISE FND_API.G_EXC_ERROR;
6441: p_msg_appl_name => 'WSM' ,
6442: p_msg_tokens => l_msg_tokens ,
6443: p_stmt_num => l_stmt_num ,
6444: p_fnd_msg_level => G_MSG_LVL_ERROR ,
6445: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6446: p_run_log_level => l_log_level
6447: );
6448: END IF;
6449: RAISE FND_API.G_EXC_ERROR;
6464: p_msg_appl_name => 'WSM' ,
6465: p_msg_tokens => l_msg_tokens ,
6466: p_stmt_num => l_stmt_num ,
6467: p_fnd_msg_level => G_MSG_LVL_ERROR ,
6468: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6469: p_run_log_level => l_log_level
6470: );
6471: END IF;
6472: RAISE FND_API.G_EXC_ERROR;
6516: p_msg_name => 'WSM_SERIAL_CLEAR_ATTR' ,
6517: p_msg_appl_name => 'WSM' ,
6518: p_msg_tokens => l_msg_tokens ,
6519: p_fnd_msg_level => G_MSG_LVL_SUCCESS ,
6520: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6521: p_run_log_level => l_log_level ,
6522: p_wsm_warning => 1
6523: );
6524: END IF;
6555: p_msg_text => 'Job Name : ' || p_resulting_jobs_tbl(l_index).wip_entity_name
6556: || 'Serial number : ' || p_serial_num_tbl(l_index1).serial_number,
6557: p_stmt_num => l_stmt_num ,
6558: p_msg_tokens => l_msg_tokens ,
6559: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
6560: p_run_log_level => l_log_level
6561: );
6562: END IF;
6563:
6624: WSM_log_PVT.logMessage (p_module_name => l_module ,
6625: p_msg_text => 'Invoking INV_LOT_TRX_VALIDATION_PUB.update_item_serial',
6626: p_stmt_num => l_stmt_num ,
6627: p_msg_tokens => l_msg_tokens ,
6628: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
6629: p_run_log_level => l_log_level
6630: );
6631: END IF;
6632:
6672: p_msg_text => 'Job Name : ' || p_resulting_jobs_tbl(l_index).wip_entity_name
6673: || 'Serial number : ' || p_serial_num_tbl(l_index1).serial_number,
6674: p_stmt_num => l_stmt_num ,
6675: p_msg_tokens => l_msg_tokens ,
6676: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
6677: p_run_log_level => l_log_level
6678: );
6679: END IF;
6680:
6924: p_msg_name => 'WSM_SERIAL_CLEAR_ATTR' ,
6925: p_msg_appl_name => 'WSM' ,
6926: p_msg_tokens => l_msg_tokens ,
6927: p_fnd_msg_level => G_MSG_LVL_SUCCESS ,
6928: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6929: p_run_log_level => l_log_level ,
6930: p_wsm_warning => 1
6931: );
6932: END IF;
6941: WSM_log_PVT.logMessage (p_module_name => l_module ,
6942: p_msg_text => 'Invoking INV_LOT_TRX_VALIDATION_PUB.update_item_serial : for Res wip_entity_id ' || p_resulting_jobs_tbl(p_resulting_jobs_tbl.first).wip_entity_id,
6943: p_stmt_num => l_stmt_num ,
6944: p_msg_tokens => l_msg_tokens ,
6945: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
6946: p_run_log_level => l_log_level
6947: );
6948: END IF;
6949:
6980: WSM_log_PVT.logMessage (p_module_name => l_module ,
6981: p_msg_text => 'Invoking INV_LOT_TRX_VALIDATION_PUB.update_item_serial',
6982: p_stmt_num => l_stmt_num ,
6983: p_msg_tokens => l_msg_tokens ,
6984: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
6985: p_run_log_level => l_log_level
6986: );
6987: END IF;
6988:
7083: p_msg_name => 'WSM_SERIAL_CLEAR_ATTR' ,
7084: p_msg_appl_name => 'WSM' ,
7085: p_msg_tokens => l_msg_tokens ,
7086: p_fnd_msg_level => G_MSG_LVL_SUCCESS ,
7087: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
7088: p_run_log_level => l_log_level ,
7089: p_wsm_warning => 1
7090: );
7091: END IF;
7101: WSM_log_PVT.logMessage (p_module_name => l_module ,
7102: p_msg_text => 'Invoking INV_LOT_TRX_VALIDATION_PUB.update_item_serial',
7103: p_stmt_num => l_stmt_num ,
7104: p_msg_tokens => l_msg_tokens ,
7105: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
7106: p_run_log_level => l_log_level
7107: );
7108: END IF;
7109:
7159: WSM_log_PVT.logMessage (p_module_name => l_module ,
7160: p_msg_text => 'Invoking INV_LOT_TRX_VALIDATION_PUB.update_item_serial',
7161: p_stmt_num => l_stmt_num ,
7162: p_msg_tokens => l_msg_tokens ,
7163: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
7164: p_run_log_level => l_log_level
7165: );
7166: END IF;
7167:
7249: p_msg_appl_name => 'WSM' ,
7250: p_msg_tokens => l_msg_tokens ,
7251: p_stmt_num => l_stmt_num ,
7252: p_fnd_msg_level => G_MSG_LVL_ERROR ,
7253: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
7254: p_run_log_level => l_log_level
7255: );
7256: END IF;
7257: RAISE FND_API.G_EXC_ERROR;
7337: p_msg_appl_name => 'WSM' ,
7338: p_msg_tokens => l_msg_tokens ,
7339: p_stmt_num => l_stmt_num ,
7340: p_fnd_msg_level => G_MSG_LVL_ERROR ,
7341: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
7342: p_run_log_level => l_log_level
7343: );
7344: END IF;
7345: RAISE FND_API.G_EXC_ERROR;
7475: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
7476: THEN
7477: WSM_log_PVT.handle_others( p_module_name => l_module ,
7478: p_stmt_num => l_stmt_num ,
7479: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
7480: p_run_log_level => l_log_level
7481: );
7482: END IF;
7483:
7503: IS
7504: l_serial_cntrl_code NUMBER;
7505: l_conv_rate NUMBER;
7506: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
7507: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
7508:
7509: l_module VARCHAR2(100) := 'wsm.plsql.WSM_SERIAL_SUPPORT_PVT.validate_qty';
7510: l_stmt_num NUMBER;
7511:
7551: p_msg_appl_name => 'WSM' ,
7552: p_msg_tokens => l_msg_tokens ,
7553: p_stmt_num => l_stmt_num ,
7554: p_fnd_msg_level => G_MSG_LVL_ERROR ,
7555: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
7556: p_run_log_level => l_log_level
7557: );
7558: END IF;
7559: RAISE FND_API.G_EXC_ERROR;
7577: p_msg_appl_name => 'WSM' ,
7578: p_msg_tokens => l_msg_tokens ,
7579: p_stmt_num => l_stmt_num ,
7580: p_fnd_msg_level => G_MSG_LVL_ERROR ,
7581: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
7582: p_run_log_level => l_log_level
7583: );
7584: END IF;
7585: RAISE FND_API.G_EXC_ERROR;
7609: p_msg_appl_name => 'WSM' ,
7610: p_msg_tokens => l_msg_tokens ,
7611: p_stmt_num => l_stmt_num ,
7612: p_fnd_msg_level => G_MSG_LVL_ERROR ,
7613: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
7614: p_run_log_level => l_log_level
7615: );
7616: END IF;
7617: RAISE FND_API.G_EXC_ERROR;
7636: p_msg_appl_name => 'WSM' ,
7637: p_msg_tokens => l_msg_tokens ,
7638: p_stmt_num => l_stmt_num ,
7639: p_fnd_msg_level => G_MSG_LVL_ERROR ,
7640: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
7641: p_run_log_level => l_log_level
7642: );
7643: END IF;
7644: RAISE FND_API.G_EXC_ERROR;
7674: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
7675: THEN
7676: WSM_log_PVT.handle_others( p_module_name => l_module ,
7677: p_stmt_num => l_stmt_num ,
7678: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
7679: p_run_log_level => l_log_level
7680: );
7681: END IF;
7682:
7698:
7699: IS
7700: -- Logging variables.....
7701: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
7702: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
7703:
7704: l_stmt_num NUMBER;
7705: l_module VARCHAR2(100) := 'wsm.plsql.WSM_SERIAL_SUPPORT_PVT.Insert_move_attr';
7706: l_param_tbl WSM_Log_PVT.param_tbl_type;
7713:
7714: l_stmt_num := 10;
7715:
7716: -- This procedure is no longer used....
7717: IF FND_LOG.LEVEL_PROCEDURE >= l_log_level THEN
7718: l_stmt_num := 15;
7719: l_param_tbl.delete;
7720: l_param_tbl(1).paramName := 'p_move_txn_id';
7721: l_param_tbl(1).paramValue := p_move_txn_id;
7728:
7729:
7730: WSM_Log_PVT.logProcParams(p_module_name => l_module ,
7731: p_param_tbl => l_param_tbl,
7732: p_fnd_log_level => l_log_level
7733: );
7734: END IF;
7735:
7736: IF p_group_id IS NOT NULL THEN
7945: WSM_log_PVT.logMessage (p_module_name => l_module ,
7946: p_msg_text => 'Total Serial Numbers inserted : ' || SQL%ROWCOUNT,
7947: p_stmt_num => l_stmt_num ,
7948: p_msg_tokens => l_msg_tokens ,
7949: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
7950: p_run_log_level => l_log_level
7951: );
7952: END IF;
7953: ELSE
8159: WSM_log_PVT.logMessage (p_module_name => l_module ,
8160: p_msg_text => 'Total Serial Numbers inserted : ' || SQL%ROWCOUNT,
8161: p_stmt_num => l_stmt_num ,
8162: p_msg_tokens => l_msg_tokens ,
8163: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
8164: p_run_log_level => l_log_level
8165: );
8166: END IF;
8167: END IF;
8470: l_wsm_serial_attrs_tbl WSM_Serial_Support_GRP.WSM_SERIAL_NUM_TBL;
8471:
8472: -- Logging variables.....
8473: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
8474: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
8475:
8476: l_stmt_num NUMBER;
8477: l_module VARCHAR2(100) := 'wsm.plsql.WSM_SERIAL_SUPPORT_PVT.update_attr_move';
8478: l_param_tbl WSM_Log_PVT.param_tbl_type;
8483: x_return_status := G_RET_SUCCESS;
8484: x_error_msg := NULL;
8485: x_error_count := 0;
8486:
8487: IF FND_LOG.LEVEL_PROCEDURE >= l_log_level THEN
8488:
8489: l_param_tbl.delete;
8490: l_param_tbl(1).paramName := 'p_move_txn_id';
8491: l_param_tbl(1).paramValue := p_move_txn_id;
8503: l_param_tbl(5).paramValue := p_organization_id;
8504:
8505: WSM_Log_PVT.logProcParams(p_module_name => l_module,
8506: p_param_tbl => l_param_tbl,
8507: p_fnd_log_level => l_log_level
8508: );
8509: END IF;
8510:
8511: -- This fist part is to clear the serials' op information when serial tracking ends...
8528: WSM_log_PVT.logMessage (p_module_name => l_module ,
8529: p_msg_text => 'Total Serial Numbers : ' || l_serial_info_tbl.count,
8530: p_stmt_num => l_stmt_num ,
8531: p_msg_tokens => l_msg_tokens ,
8532: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
8533: p_run_log_level => l_log_level
8534: );
8535: END IF;
8536:
8583: WSM_log_PVT.logMessage (p_module_name => l_module ,
8584: p_msg_text => 'Total Serial Numbers : ' || l_serial_info_tbl.count,
8585: p_stmt_num => l_stmt_num ,
8586: p_msg_tokens => l_msg_tokens ,
8587: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
8588: p_run_log_level => l_log_level
8589: );
8590: END IF;
8591:
8643: WSM_log_PVT.logMessage (p_module_name => l_module ,
8644: p_msg_text => 'Total Serial Numbers : ' || l_serial_info_tbl.count,
8645: p_stmt_num => l_stmt_num ,
8646: p_msg_tokens => l_msg_tokens ,
8647: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
8648: p_run_log_level => l_log_level
8649: );
8650: END IF;
8651:
8698: WSM_log_PVT.logMessage (p_module_name => l_module ,
8699: p_msg_text => 'Total Serial Numbers : ' || l_serial_info_tbl.count,
8700: p_stmt_num => l_stmt_num ,
8701: p_msg_tokens => l_msg_tokens ,
8702: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
8703: p_run_log_level => l_log_level
8704: );
8705: END IF;
8706:
8755: WSM_log_PVT.logMessage (p_module_name => l_module ,
8756: p_msg_text => 'Total Serial Numbers : ' || l_wsm_serial_attrs_tbl.count,
8757: p_stmt_num => l_stmt_num ,
8758: p_msg_tokens => l_msg_tokens ,
8759: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
8760: p_run_log_level => l_log_level
8761: );
8762: END IF;
8763:
8821: p_msg_text => 'Total Serial Numbers for attributes updation : '
8822: || l_wsm_serial_attrs_tbl.count,
8823: p_stmt_num => l_stmt_num ,
8824: p_msg_tokens => l_msg_tokens ,
8825: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
8826: p_run_log_level => l_log_level
8827: );
8828: END IF;
8829:
8869: WSM_log_PVT.logMessage (p_module_name => l_module,
8870: p_msg_text => 'Deleted ' || SQL%ROWCOUNT || ' records inserted for attributes reason',
8871: p_stmt_num => l_stmt_num ,
8872: p_msg_tokens => l_msg_tokens ,
8873: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
8874: p_run_log_level => l_log_level
8875: );
8876: END IF;
8877: END IF;
8882: WSM_log_PVT.logMessage (p_module_name => l_module ,
8883: p_msg_text => 'Completed updation of the attributes',
8884: p_stmt_num => l_stmt_num ,
8885: p_msg_tokens => l_msg_tokens ,
8886: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
8887: p_run_log_level => l_log_level
8888: );
8889: END IF;
8890:
8914: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
8915: THEN
8916: WSM_log_PVT.handle_others( p_module_name => l_module ,
8917: p_stmt_num => l_stmt_num ,
8918: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
8919: p_run_log_level => l_log_level
8920: );
8921: END IF;
8922:
8942: ) IS
8943:
8944: -- Logging variables.....
8945: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
8946: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
8947:
8948: l_stmt_num NUMBER;
8949: l_module VARCHAR2(100) := 'wsm.plsql.WSM_SERIAL_SUPPORT_PVT.find_undo_ret_serials';
8950: l_param_tbl WSM_Log_PVT.param_tbl_type;
8969: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
8970: THEN
8971: WSM_log_PVT.handle_others( p_module_name => l_module ,
8972: p_stmt_num => l_stmt_num ,
8973: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
8974: p_run_log_level => l_log_level
8975: );
8976: END IF;
8977:
9103:
9104:
9105: -- Logging variables.....
9106: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
9107: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
9108:
9109: l_stmt_num NUMBER;
9110: l_module VARCHAR2(100) := 'wsm.plsql.WSM_SERIAL_SUPPORT_PVT.Move_forms_serial_proc';
9111: l_param_tbl WSM_Log_PVT.param_tbl_type;
9118: WSM_log_PVT.logMessage (p_module_name => l_module ,
9119: p_msg_text => 'Entered wsm.plsql.WSM_SERIAL_SUPPORT_PVT.Move_forms_serial_proc',
9120: p_stmt_num => l_stmt_num ,
9121: p_msg_tokens => l_msg_tokens ,
9122: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
9123: p_run_log_level => l_log_level
9124: );
9125: END IF;
9126:
9161: WSM_log_PVT.logMessage (p_module_name => l_module ,
9162: p_msg_text => 'Total Rows : ' || l_wsm_serial_num_tbl.count,
9163: p_stmt_num => l_stmt_num ,
9164: p_msg_tokens => l_msg_tokens ,
9165: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
9166: p_run_log_level => l_log_level
9167: );
9168: END IF;
9169: ELSE
9194: WSM_log_PVT.logMessage (p_module_name => l_module ,
9195: p_msg_text => 'Invoking WSM_Serial_support_PVT.Move_serial_processor',
9196: p_stmt_num => l_stmt_num ,
9197: p_msg_tokens => l_msg_tokens ,
9198: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
9199: p_run_log_level => l_log_level
9200: );
9201: END IF;
9202:
9239: WSM_log_PVT.logMessage (p_module_name => l_module ,
9240: p_msg_text => 'Invoking WSM_Serial_support_PVT.Insert_move_attr',
9241: p_stmt_num => l_stmt_num ,
9242: p_msg_tokens => l_msg_tokens ,
9243: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
9244: p_run_log_level => l_log_level
9245: );
9246: END IF;
9247:
9268: WSM_log_PVT.logMessage (p_module_name => l_module ,
9269: p_msg_text => 'Processing in WSM_Serial_support_PVT.Move_forms_serial_proc complete',
9270: p_stmt_num => l_stmt_num ,
9271: p_msg_tokens => l_msg_tokens ,
9272: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
9273: p_run_log_level => l_log_level
9274: );
9275: END IF;
9276:
9300: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
9301: THEN
9302: WSM_log_PVT.handle_others( p_module_name => l_module ,
9303: p_stmt_num => l_stmt_num ,
9304: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
9305: p_run_log_level => l_log_level
9306: );
9307: END IF;
9308:
9321:
9322: -- This assumption is based that each individual column to be logged doesnt exceed 3900 chars... (that's the max...)
9323: type t_log_message_tbl IS table OF varchar2(3900) index by binary_integer;
9324:
9325: -- MESSAGE_TEXT column in FND_LOG_MESSAGES is 4000 characters long..
9326: -- WSM_Log_PVT adds the date information in the start,,, so leave 50 characters for that
9327: -- Effective length we would use is 3900
9328:
9329: -- Logging variables.....
9327: -- Effective length we would use is 3900
9328:
9329: -- Logging variables.....
9330: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
9331: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
9332:
9333: l_stmt_num NUMBER;
9334: l_module VARCHAR2(100) := 'wsm.plsql.WSM_SERIAL_SUPPORT_PVT.log_serial_data';
9335: l_param_tbl WSM_Log_PVT.param_tbl_type;
9335: l_param_tbl WSM_Log_PVT.param_tbl_type;
9336: -- Logging variables...
9337:
9338: l_message_tbl t_log_message_tbl;
9339: l_log_message FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
9340: l_counter NUMBER;
9341: l_index NUMBER;
9342:
9343: BEGIN
9345: x_return_status := G_RET_SUCCESS;
9346: x_error_msg := NULL;
9347: x_error_count := 0;
9348:
9349: IF FND_LOG.LEVEL_PROCEDURE >= l_log_level THEN
9350:
9351: l_param_tbl.delete;
9352: l_param_tbl(1).paramName := 'p_serial_num_tbl.count';
9353: l_param_tbl(1).paramValue := p_serial_num_tbl.count;
9353: l_param_tbl(1).paramValue := p_serial_num_tbl.count;
9354:
9355: WSM_Log_PVT.logProcParams(p_module_name => l_module,
9356: p_param_tbl => l_param_tbl,
9357: p_fnd_log_level => l_log_level
9358: );
9359: END IF;
9360:
9361: IF( g_log_level_statement >= l_log_level ) THEN
9363: WSM_log_PVT.logMessage(p_module_name => l_module ,
9364: p_msg_text => 'Logging the transaction serial data..',
9365: p_stmt_num => l_stmt_num ,
9366: p_msg_tokens => l_msg_tokens,
9367: p_fnd_log_level => g_log_level_statement,
9368: p_run_log_level => l_log_level
9369: );
9370:
9371: l_stmt_num := 20;
9469: WSM_log_PVT.logMessage(p_module_name => l_module ,
9470: p_msg_text => l_log_message ,
9471: p_stmt_num => l_stmt_num ,
9472: p_msg_tokens => l_msg_tokens ,
9473: p_fnd_log_level => g_log_level_statement ,
9474: p_run_log_level => l_log_level
9475: );
9476: l_log_message := null;
9477: END IF;
9488: WSM_log_PVT.logMessage(p_module_name => l_module ,
9489: p_msg_text => l_log_message ,
9490: p_stmt_num => l_stmt_num ,
9491: p_msg_tokens => l_msg_tokens ,
9492: p_fnd_log_level => g_log_level_statement ,
9493: p_run_log_level => l_log_level
9494: );
9495:
9496: END IF;
9508: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
9509: THEN
9510: WSM_log_PVT.handle_others( p_module_name => l_module ,
9511: p_stmt_num => l_stmt_num ,
9512: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
9513: p_run_log_level => l_log_level
9514: );
9515: END IF;
9516: