[Home] [Help]
323: l_wsm_serial_nums_tbl WSM_Serial_Support_GRP.WSM_SERIAL_NUM_TBL;
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';
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;
333: -- Logging variables...
334:
335:
336: BEGIN
354:
355: l_param_tbl(4).paramName := 'p_header_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;
392: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
393: THEN
394:
395: l_msg_tokens.delete;
396: WSM_log_PVT.logMessage(p_module_name => l_module ,
397: p_msg_name => 'WSM_SERIAL_JOB_INVALID_STATUS',
398: p_msg_appl_name => 'WSM' ,
399: p_msg_tokens => l_msg_tokens ,
400: p_stmt_num => l_stmt_num ,
408:
409: l_stmt_num := 50;
410: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
411: l_msg_tokens.delete;
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 ,
463:
464: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
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: );
501: l_error_count NUMBER;
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';
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;
511: -- Logging variables...
512:
513: BEGIN
514: l_stmt_num := 10;
531:
532: l_param_tbl(4).paramName := 'p_wsm_serial_nums_tbl.count';
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;
589: IF g_log_level_error >= l_log_level OR
590: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
591: THEN
592: l_msg_tokens.delete;
593: WSM_log_PVT.logMessage(p_module_name => l_module ,
594: p_msg_name => 'WSM_INVLAID_SERIAL_INFO',
595: p_msg_appl_name => 'WSM' ,
596: p_msg_tokens => l_msg_tokens ,
597: p_stmt_num => l_stmt_num ,
610: else
611: l_stmt_num := 70;
612: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
613: l_msg_tokens.delete;
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 ,
665:
666: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
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: );
696:
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';
736:
737: l_msg_tokens.delete;
738: l_msg_tokens(1).TokenName := 'FLD_NAME';
739: l_msg_tokens(1).TokenValue := 'Organization Identifdier or Item Identifier';
740: WSM_log_PVT.logMessage(p_module_name => l_module ,
741: p_msg_name => 'WSM_INVALID_FILED' ,
742: p_msg_appl_name => 'WSM' ,
743: p_msg_tokens => l_msg_tokens ,
744: p_stmt_num => l_stmt_num ,
785:
786: l_msg_tokens.delete;
787: l_msg_tokens(1).TokenName := 'FLD_NAME';
788: l_msg_tokens(1).TokenValue := 'Job Identifier (wip_entity_id)';
789: WSM_log_PVT.logMessage(p_module_name => l_module ,
790: p_msg_name => 'WSM_INVALID_FIELD' ,
791: p_msg_appl_name => 'WSM' ,
792: p_msg_tokens => l_msg_tokens ,
793: p_stmt_num => l_stmt_num ,
814:
815: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
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: );
865: l_op_seq_num NUMBER;
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';
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;
875: -- Logging variables...
876:
877: BEGIN
878: l_stmt_num := 10;
889:
890: l_param_tbl(2).paramName := 'p_intraoperation_step';
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;
897: END IF;
898:
899: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
900: l_msg_tokens.delete;
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 ,
996: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
997: THEN
998:
999: l_msg_tokens.delete;
1000: WSM_log_PVT.logMessage(p_module_name => l_module ,
1001: p_msg_name => 'WSM_INVLD_OP_JOB_SERIAL_TRACK',
1002: p_msg_appl_name => 'WSM' ,
1003: p_msg_tokens => l_msg_tokens ,
1004: p_stmt_num => l_stmt_num ,
1021: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
1022: THEN
1023:
1024: l_msg_tokens.delete;
1025: WSM_log_PVT.logMessage(p_module_name => l_module ,
1026: p_msg_name => 'WSM_INVALID_SERIAL_QTY',
1027: p_msg_appl_name => 'WSM' ,
1028: p_msg_tokens => l_msg_tokens ,
1029: p_stmt_num => l_stmt_num ,
1110: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
1111: THEN
1112:
1113: l_msg_tokens.delete;
1114: WSM_log_PVT.logMessage(p_module_name => l_module ,
1115: p_msg_name => 'WSM_INVALID_GEN_QTY' ,
1116: p_msg_appl_name => 'WSM' ,
1117: p_msg_tokens => l_msg_tokens ,
1118: p_stmt_num => l_stmt_num ,
1134: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
1135: THEN
1136:
1137: l_msg_tokens.delete;
1138: WSM_log_PVT.logMessage(p_module_name => l_module ,
1139: p_msg_name => 'WSM_INVALID_SERIAL_QTY',
1140: p_msg_appl_name => 'WSM' ,
1141: p_msg_tokens => l_msg_tokens ,
1142: p_stmt_num => l_stmt_num ,
1219:
1220: l_msg_tokens.delete;
1221: l_msg_tokens(1).TokenName := 'FLD_NAME';
1222: l_msg_tokens(1).TokenValue := 'Action Flag/Generate Serial Number Flag';
1223: WSM_log_PVT.logMessage(p_module_name => l_module ,
1224: p_msg_name => 'WSM_INVALID_FIELD' ,
1225: p_msg_appl_name => 'WSM' ,
1226: p_msg_tokens => l_msg_tokens ,
1227: p_stmt_num => l_stmt_num ,
1262:
1263: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
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: );
1299: l_return_code NUMBER;
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';
1319: l_quantity := 1;
1320:
1321: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
1322: l_msg_tokens.delete;
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 ,
1351: l_msg_tokens.delete;
1352: l_msg_tokens(1).TokenName := 'SERIAL_NUM';
1353: l_msg_tokens(1).TokenValue := null;
1354:
1355: WSM_log_PVT.logMessage(p_module_name => l_module ,
1356: p_msg_name => 'WSM_SERIAL_GEN_FAILED' ,
1357: p_msg_appl_name => 'WSM' ,
1358: p_msg_tokens => l_msg_tokens ,
1359: p_stmt_num => l_stmt_num ,
1369:
1370: l_stmt_num := 30;
1371: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
1372: l_msg_tokens.delete;
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 ,
1406: p_organization_id,
1407: p_inventory_item_id) = 1 ) THEN
1408:
1409: l_msg_tokens.delete;
1410: WSM_log_PVT.logMessage(p_module_name => l_module ,
1411: p_msg_name => 'WSM_ENT_MAND_SER_ATTR_FLEX',
1412: p_msg_appl_name => 'WSM' ,
1413: p_msg_tokens => l_msg_tokens ,
1414: p_stmt_num => l_stmt_num ,
1523:
1524: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
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: );
1561:
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)';
1582: l_stmt_num := 20;
1583:
1584: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
1585: l_msg_tokens.delete;
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 ,
1614: THEN
1615: l_msg_tokens.delete;
1616: l_msg_tokens(1).TokenName := 'SERIAL_NUM';
1617: l_msg_tokens(1).TokenValue := null;
1618: WSM_log_PVT.logMessage(p_module_name => l_module ,
1619: p_msg_name => 'WSM_SERIAL_GEN_FAILED' ,
1620: p_msg_appl_name => 'WSM' ,
1621: p_msg_tokens => l_msg_tokens ,
1622: p_stmt_num => l_stmt_num ,
1655: p_organization_id,
1656: p_inventory_item_id) = 1 ) THEN
1657:
1658: l_msg_tokens.delete;
1659: WSM_log_PVT.logMessage(p_module_name => l_module ,
1660: p_msg_name => 'WSM_ENT_MAND_SER_ATTR_FLEX',
1661: p_msg_appl_name => 'WSM' ,
1662: p_msg_tokens => l_msg_tokens ,
1663: p_stmt_num => l_stmt_num ,
1677: l_stmt_num := 40;
1678:
1679: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
1680: l_msg_tokens.delete;
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 ,
1715: l_stmt_num := 70;
1716:
1717: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
1718: l_msg_tokens.delete;
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 ,
1774:
1775: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
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: );
1815: l_exists NUMBER := 0;
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';
1889: IF g_log_level_error >= l_log_level OR
1890: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
1891: THEN
1892: l_msg_tokens.delete;
1893: WSM_log_PVT.logMessage(p_module_name => l_module ,
1894: p_msg_name => 'WIP_JDI_INVALID_UNUSED_SERIAL',
1895: p_msg_appl_name => 'WIP' ,
1896: p_msg_tokens => l_msg_tokens ,
1897: p_stmt_num => l_stmt_num ,
1906: IF g_log_level_error >= l_log_level OR
1907: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
1908: THEN
1909: l_msg_tokens.delete;
1910: WSM_log_PVT.logMessage(p_module_name => l_module ,
1911: p_msg_name => 'WIP_JDI_INVALID_UNUSED_SERIAL',
1912: p_msg_appl_name => 'WIP' ,
1913: p_msg_tokens => l_msg_tokens ,
1914: p_stmt_num => l_stmt_num ,
1935:
1936:
1937: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
1938: l_msg_tokens.delete;
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 ,
1992:
1993: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
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: );
2039: l_ser_context MTL_SERIAL_NUMBERS.serial_attribute_category%type;
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';
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;
2049: -- Logging variables...
2050:
2051: BEGIN
2052: l_stmt_num := 10;
2066:
2067: l_param_tbl(3).paramName := 'p_serial_attr_context';
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;
2104: l_stmt_num := 40;
2105:
2106: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
2107: l_msg_tokens.delete;
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 ,
2139: l_msg_tokens.delete;
2140: l_msg_tokens(1).TokenName := 'FLD_NAME';
2141: l_msg_tokens(1).TokenValue := 'Serial Attribute Category for Serial Number : ' || p_serial_number_rec.serial_number;
2142:
2143: WSM_log_PVT.logMessage(p_module_name => l_module ,
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 ,
2308: l_stmt_num := 72;
2309: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
2310:
2311: l_msg_tokens.delete;
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 ,
2370: l_stmt_num := 100;
2371: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
2372:
2373: l_msg_tokens.delete;
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 ,
2425:
2426: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
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: );
2459:
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)';
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;
2469: -- Logging variables...
2470:
2471: BEGIN
2472: l_stmt_num := 10;
2483:
2484: l_param_tbl(2).paramName := 'p_update_desc_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;
2519:
2520: l_stmt_num := 40;
2521: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
2522: l_msg_tokens.delete;
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 ,
2534: l_stmt_num := 50;
2535:
2536: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
2537: l_msg_tokens.delete;
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 ,
2571: l_stmt_num := 70;
2572:
2573: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
2574: l_msg_tokens.delete;
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 ,
2626:
2627: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
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: );
2648:
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';
2685:
2686: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
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: );
2738:
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';
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;
2748: -- Logging variables...
2749:
2750: begin
2751: l_stmt_num := 10;
2768:
2769: l_param_tbl(4).paramName := 'p_intraoperation_step_type';
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;
2836: l_stmt_num := 30;
2837:
2838: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
2839: l_msg_tokens.delete;
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 ,
2911: x_return_status := G_RET_UNEXPECTED;
2912: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
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: );
3162: l_serial_tbl t_varchar2;
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';
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;
3172: -- Logging variables...
3173:
3174: BEGIN
3175: l_stmt_num := 10;
3192:
3193: l_param_tbl(4).paramName := 'p_header_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;
3247: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
3248: THEN
3249:
3250: l_msg_tokens.delete;
3251: WSM_log_PVT.logMessage(p_module_name => l_module ,
3252: p_msg_name => 'WSM_INVLAID_SERIAL_INFO',
3253: p_msg_appl_name => 'WSM' ,
3254: p_msg_tokens => l_msg_tokens ,
3255: p_stmt_num => l_stmt_num ,
3276:
3277: l_stmt_num := 50;
3278: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
3279: l_msg_tokens.delete;
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 ,
3333: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
3334: THEN
3335:
3336: l_msg_tokens.delete;
3337: WSM_log_PVT.logMessage(p_module_name => l_module ,
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 ,
3374: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
3375: THEN
3376:
3377: l_msg_tokens.delete;
3378: WSM_log_PVT.logMessage(p_module_name => l_module ,
3379: p_msg_name => 'WSM_INVALID_SERIALS_SUPPLIED',
3380: p_msg_appl_name => 'WSM' ,
3381: p_msg_tokens => l_msg_tokens ,
3382: p_stmt_num => l_stmt_num ,
3401:
3402: l_stmt_num := 130;
3403: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
3404: l_msg_tokens.delete;
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 ,
3449: end if;
3450:
3451: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
3452: l_msg_tokens.delete;
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 ,
3483:
3484: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
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: );
3531:
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';
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;
3541: -- Logging variables...
3542:
3543: BEGIN
3544: SAVEPOINT Move_serial_proc;
3568:
3569: l_param_tbl(6).paramName := 'p_scrap_at_operation';
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;
3597:
3598: l_stmt_num := 20;
3599: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
3600: l_msg_tokens.delete;
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 ,
3648: l_stmt_num := 30;
3649:
3650: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
3651: l_msg_tokens.delete;
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 ,
3674: WHERE wip_entity_id = p_wip_entity_id;
3675:
3676: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
3677: l_msg_tokens.delete;
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 ,
3693: IF x_serial_track_flag IS NOT NULL THEN
3694:
3695: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
3696: l_msg_tokens.delete;
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 ,
3737: AND first_serial_txn_id = p_old_move_txn_id;
3738:
3739: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
3740: l_msg_tokens.delete;
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 ,
3772:
3773: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
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: );
3844: and msn.current_organization_id = p_organization_id
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';
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;
3854: -- Logging variables...
3855:
3856: l_charge_jump_from_queue NUMBER;
3857:
3882:
3883: l_param_tbl(6).paramName := 'p_serial_num_tbl (count)';
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;
3936:
3937: l_stmt_num := 50;
3938: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
3939: l_msg_tokens.delete;
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 ,
3953: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
3954: THEN
3955:
3956: l_msg_tokens.delete;
3957: WSM_log_PVT.logMessage(p_module_name => l_module ,
3958: p_msg_name => 'WSM_INVALID_INFO_NOT_TRACKED',
3959: p_msg_appl_name => 'WSM' ,
3960: p_msg_tokens => l_msg_tokens ,
3961: p_stmt_num => l_stmt_num ,
3996: from wip_entities
3997: where wip_entity_id = p_wip_entity_id
3998: and organization_id = p_organization_id;
3999:
4000: WSM_log_PVT.logMessage(p_module_name => l_module ,
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 ,
4018: IF g_log_level_error >= l_log_level OR
4019: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
4020: THEN
4021: l_msg_tokens.delete;
4022: WSM_log_PVT.logMessage(p_module_name => l_module ,
4023: p_msg_name => 'WSM_NO_START_SERTRACK' ,
4024: p_msg_appl_name => 'WSM' ,
4025: p_msg_tokens => l_msg_tokens ,
4026: p_stmt_num => l_stmt_num ,
4049: l_msg_tokens.delete;
4050: l_msg_tokens(1).TokenName := 'SERIAL';
4051: l_msg_tokens(1).TokenValue := p_serial_num_tbl(l_cntr).serial_number;
4052:
4053: WSM_log_PVT.logMessage(p_module_name => l_module ,
4054: p_msg_name => 'WSM_DUPLICATE_TXN_SERIAL',
4055: p_msg_appl_name => 'WSM' ,
4056: p_msg_tokens => l_msg_tokens ,
4057: p_stmt_num => l_stmt_num ,
4077: l_serial_list.delete;
4078:
4079: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
4080: l_msg_tokens.delete;
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 ,
4102: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
4103: THEN
4104:
4105: l_msg_tokens.delete;
4106: WSM_log_PVT.logMessage(p_module_name => l_module ,
4107: p_msg_name => 'WSM_SUPPLIED_QTY_INVALID',
4108: p_msg_appl_name => 'WSM' ,
4109: p_msg_tokens => l_msg_tokens ,
4110: p_stmt_num => l_stmt_num ,
4161: end loop;
4162:
4163: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
4164: l_msg_tokens.delete;
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 ,
4234: );
4235:
4236: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
4237: l_msg_tokens.delete;
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 ,
4293: end loop;
4294:
4295: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
4296: l_msg_tokens.delete;
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 ,
4367:
4368: l_stmt_num := 190;
4369: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
4370: l_msg_tokens.delete;
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 ,
4429: );
4430:
4431: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
4432: l_msg_tokens.delete;
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 ,
4487: );
4488:
4489: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
4490: l_msg_tokens.delete;
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 ,
4509: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
4510: THEN
4511:
4512: l_msg_tokens.delete;
4513: WSM_log_PVT.logMessage(p_module_name => l_module ,
4514: p_msg_name => 'WSM_SUPPLIED_QTY_INVALID',
4515: p_msg_appl_name => 'WSM' ,
4516: p_msg_tokens => l_msg_tokens ,
4517: p_stmt_num => l_stmt_num ,
4567: end loop;
4568:
4569: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
4570: l_msg_tokens.delete;
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 ,
4588:
4589: l_stmt_num := 290;
4590: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
4591: l_msg_tokens.delete;
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 ,
4603:
4604: l_stmt_num := 300;
4605: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
4606: l_msg_tokens.delete;
4607: WSM_log_PVT.logMessage (p_module_name => l_module ,
4608: p_msg_text => 'Invoking update_serial_attr(1) for ' ||
4609: 'Serial Attributes updation for serial number ' ||
4610: p_serial_num_tbl(l_cntr).serial_number,
4611: p_stmt_num => l_stmt_num ,
4647: for l_job_serial_rec in c_job_serials loop
4648:
4649: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
4650: l_msg_tokens.delete;
4651: WSM_log_PVT.logMessage (p_module_name => l_module ,
4652: p_msg_text => 'Invoking update_serial : ' || l_job_serial_rec.serial_number
4653: || ' Operation : ' || p_curr_job_op_seq_num
4654: || ' Op Step : ' || p_curr_job_intraop_step,
4655: p_stmt_num => l_stmt_num ,
4706:
4707: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
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: );
4780: l_index NUMBER;
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';
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;
4790: -- Logging variables...
4791:
4792:
4793: BEGIN
4814:
4815: l_param_tbl(5).paramName := 'p_old_scrap_txn_id';
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;
4840: END IF;
4841:
4842: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
4843: l_msg_tokens.delete;
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 ,
4861: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
4862: THEN
4863:
4864: l_msg_tokens.delete;
4865: WSM_log_PVT.logMessage(p_module_name => l_module ,
4866: p_msg_name => 'WSM_SERIAL_INSUFFICIENT',
4867: p_msg_appl_name => 'WSM' ,
4868: p_msg_tokens => l_msg_tokens ,
4869: p_stmt_num => l_stmt_num ,
4899: END IF;
4900:
4901: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
4902: l_msg_tokens.delete;
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 ,
4918: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
4919: THEN
4920:
4921: l_msg_tokens.delete;
4922: WSM_log_PVT.logMessage(p_module_name => l_module ,
4923: p_msg_name => 'WSM_SERIAL_INSUFFICIENT',
4924: p_msg_appl_name => 'WSM' ,
4925: p_msg_tokens => l_msg_tokens ,
4926: p_stmt_num => l_stmt_num ,
4986: -- obtained all the serial numbers...
4987: -- have to insert all these into wip_serial_txn_interface...
4988: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
4989: l_msg_tokens.delete;
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 ,
5022:
5023: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
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: );
5155: order by nvl(wsti.action_flag,0) desc; -- Code review remark
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';
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;
5165: -- Logging variables...
5166:
5167: BEGIN
5168:
5185:
5186: l_param_tbl(4).paramName := 'p_header_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;
5222:
5223: l_msg_tokens.delete;
5224: l_msg_tokens(1).TokenName := 'FLD_NAME';
5225: l_msg_tokens(1).TokenValue := 'Wip Entity Name';
5226: WSM_log_PVT.logMessage(p_module_name => l_module ,
5227: p_msg_name => 'WSM_INVALID_FIELD',
5228: p_msg_appl_name => 'WSM' ,
5229: p_msg_tokens => l_msg_tokens ,
5230: p_stmt_num => l_stmt_num ,
5266:
5267: l_msg_tokens.delete;
5268: l_msg_tokens(1).TokenName := 'FLD_NAME';
5269: l_msg_tokens(1).TokenValue := 'Wip Entity Name/Wip entity ID';
5270: WSM_log_PVT.logMessage(p_module_name => l_module ,
5271: p_msg_name => 'WSM_INVALID_FIELD' ,
5272: p_msg_appl_name => 'WSM' ,
5273: p_msg_tokens => l_msg_tokens ,
5274: p_stmt_num => l_stmt_num ,
5284: l_stmt_num := 40;
5285:
5286: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
5287: l_msg_tokens.delete;
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 ,
5315: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
5316: THEN
5317:
5318: l_msg_tokens.delete;
5319: WSM_log_PVT.logMessage(p_module_name => l_module ,
5320: p_msg_name => 'WSM_INVALID_SERIALS_SUPPLIED',
5321: p_msg_appl_name => 'WSM' ,
5322: p_msg_tokens => l_msg_tokens ,
5323: p_stmt_num => l_stmt_num ,
5353:
5354: l_msg_tokens.delete;
5355: l_msg_tokens(1).TokenName := 'FLD_NAME';
5356: l_msg_tokens(1).TokenValue := 'Action flag for Update Quantity transaction';
5357: WSM_log_PVT.logMessage(p_module_name => l_module ,
5358: p_msg_name => 'WSM_INVALID_JOB_TXN_QTY',
5359: p_msg_appl_name => 'WSM' ,
5360: p_msg_tokens => l_msg_tokens ,
5361: p_stmt_num => l_stmt_num ,
5392:
5393: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
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: );
5435: l_sindex NUMBER;
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';
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;
5445: -- Logging variables...
5446:
5447:
5448: BEGIN
5453: x_error_count := 0;
5454:
5455: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
5456: l_msg_tokens.delete;
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 ,
5488: end loop;
5489:
5490: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
5491: l_msg_tokens.delete;
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 ,
5505:
5506: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
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: );
5535: )
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';
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;
5545: -- Logging variables...
5546:
5547: BEGIN
5548: l_stmt_num := 10;
5565:
5566: l_param_tbl(4).paramName := 'p_transaction_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;
5628:
5629: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
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: );
5728: AND nvl(msn.INTRAOPERATION_STEP_TYPE,-1) <> WIP_CONSTANTS.SCRAP
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';
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;
5738: -- Logging variables...
5739:
5740: BEGIN
5741: l_stmt_num := 10;
5763:
5764: l_param_tbl(5).paramName := 'p_wlt_txn_type';
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;
5856: END IF;
5857:
5858: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
5859: l_msg_tokens.delete;
5860: WSM_log_PVT.logMessage (p_module_name => l_module ,
5861: p_msg_text => 'l_curr_job_op_seq_num : ' || l_curr_job_op_seq_num
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 ,
5879: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
5880: THEN
5881:
5882: l_msg_tokens.delete;
5883: WSM_log_PVT.logMessage(p_module_name => l_module ,
5884: p_msg_name => 'WSM_INVLAID_SERIAL_INFO',
5885: p_msg_appl_name => 'WSM' ,
5886: p_stmt_num => l_stmt_num ,
5887: p_msg_tokens => l_msg_tokens ,
5912: and nvl(intraoperation_step_type,-1) <> 5;
5913:
5914: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
5915: l_msg_tokens.delete;
5916: WSM_log_PVT.logMessage (p_module_name => l_module ,
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 ,
5933: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
5934: THEN
5935:
5936: l_msg_tokens.delete;
5937: WSM_log_PVT.logMessage(p_module_name => l_module ,
5938: p_msg_name => 'WSM_SPLIT_SERIAL_INFO_REQ',
5939: p_msg_appl_name => 'WSM' ,
5940: p_msg_tokens => l_msg_tokens ,
5941: p_stmt_num => l_stmt_num ,
5968: l_msg_tokens.delete;
5969: l_msg_tokens(1).TokenName := 'SERIAL';
5970: l_msg_tokens(1).TokenValue := p_serial_num_tbl(l_index2).serial_number;
5971:
5972: WSM_log_PVT.logMessage(p_module_name => l_module ,
5973: p_msg_name => 'WSM_DUPLICATE_TXN_SERIAL',
5974: p_msg_appl_name => 'WSM' ,
5975: p_msg_tokens => l_msg_tokens ,
5976: p_stmt_num => l_stmt_num ,
6038: THEN
6039: l_msg_tokens.delete;
6040: l_msg_tokens(1).TokenName := 'FLD_NAME';
6041: l_msg_tokens(1).TokenValue := 'Changed Job Name';
6042: WSM_log_PVT.logMessage(p_module_name => l_module ,
6043: p_msg_name => 'WSM_INVALID_FIELD' ,
6044: p_msg_appl_name => 'WSM' ,
6045: p_msg_tokens => l_msg_tokens ,
6046: p_stmt_num => l_stmt_num ,
6065: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
6066: l_temp_job := l_job_ser_info_tbl.first;
6067: WHILE l_temp_job IS NOT NULL LOOP
6068: l_msg_tokens.delete;
6069: WSM_log_PVT.logMessage (p_module_name => l_module ,
6070: p_msg_text => 'Job Name : ' || l_temp_job ||
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 ,
6131:
6132: l_msg_tokens.delete;
6133: l_msg_tokens(1).TokenName := 'JOB';
6134: l_msg_tokens(1).TokenValue := p_resulting_jobs_tbl(l_index).wip_entity_name;
6135: WSM_log_PVT.logMessage(p_module_name => l_module ,
6136: p_msg_name => 'WSM_INVALID_SERIAL_QTY1' ,
6137: p_msg_appl_name => 'WSM' ,
6138: p_msg_tokens => l_msg_tokens ,
6139: p_stmt_num => l_stmt_num ,
6169:
6170: l_msg_tokens.delete;
6171: l_msg_tokens(1).TokenName := 'JOB';
6172: l_msg_tokens(1).TokenValue := p_resulting_jobs_tbl(l_index).wip_entity_name;
6173: WSM_log_PVT.logMessage(p_module_name => l_module ,
6174: p_msg_name => 'WSM_SPLIT_SERIAL_INSUFF',
6175: p_msg_appl_name => 'WSM' ,
6176: p_msg_tokens => l_msg_tokens ,
6177: p_stmt_num => l_stmt_num ,
6187: l_filling_job_name := p_resulting_jobs_tbl(l_index).wip_entity_name;
6188:
6189: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
6190: l_msg_tokens.delete;
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 ,
6230: end loop;
6231:
6232: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
6233: l_msg_tokens.delete;
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 ,
6240: );
6241: l_temp_job := l_job_ser_info_tbl.first;
6242: WHILE l_temp_job IS NOT NULL LOOP
6243:
6244: WSM_log_PVT.logMessage (p_module_name => l_module ,
6245: p_msg_text => 'Job Name : ' || l_temp_job ||
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 ,
6254: END LOOP;
6255:
6256: l_index1 := p_serial_num_tbl.first;
6257: while l_index1 IS NOT NULL LOOP
6258: WSM_log_PVT.logMessage (p_module_name => l_module ,
6259: p_msg_text => 'Index : ' || l_index1 ||
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 ,
6332:
6333: l_stmt_num := 141;
6334: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
6335: l_msg_tokens.delete;
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 ,
6343:
6344: l_temp_job := l_job_ser_info_tbl.first;
6345: WHILE l_temp_job IS NOT NULL LOOP
6346:
6347: WSM_log_PVT.logMessage (p_module_name => l_module ,
6348: p_msg_text => 'Job Name : ' || l_temp_job ||
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 ,
6357: END LOOP;
6358:
6359: l_index1 := p_serial_num_tbl.first;
6360: while l_index1 IS NOT NULL LOOP
6361: WSM_log_PVT.logMessage (p_module_name => l_module ,
6362: p_msg_text => 'Index : ' || l_index1 ||
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 ,
6375: l_new_count := p_serial_num_tbl.count;
6376:
6377: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
6378: l_msg_tokens.delete;
6379: WSM_log_PVT.logMessage (p_module_name => l_module ,
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 ,
6399: THEN
6400: l_msg_tokens.delete;
6401: l_msg_tokens(1).TokenName := 'JOB';
6402: l_msg_tokens(1).TokenValue := p_resulting_jobs_tbl(l_index).wip_entity_name;
6403: WSM_log_PVT.logMessage(p_module_name => l_module ,
6404: p_msg_name => 'WSM_SPLIT_SERIAL_INSUFF',
6405: p_msg_appl_name => 'WSM' ,
6406: p_msg_tokens => l_msg_tokens ,
6407: p_stmt_num => l_stmt_num ,
6435: THEN
6436: l_msg_tokens.delete;
6437: l_msg_tokens(1).TokenName := 'JOB';
6438: l_msg_tokens(1).TokenValue := p_resulting_jobs_tbl(l_parent_as_resjob).wip_entity_name;
6439: WSM_log_PVT.logMessage(p_module_name => l_module ,
6440: p_msg_name => 'WSM_INVALID_SERIAL_QTY1',
6441: p_msg_appl_name => 'WSM' ,
6442: p_msg_tokens => l_msg_tokens ,
6443: p_stmt_num => l_stmt_num ,
6458: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
6459: THEN
6460:
6461: l_msg_tokens.delete;
6462: WSM_log_PVT.logMessage(p_module_name => l_module ,
6463: p_msg_name => 'WSM_SPLIT_SERIAL_INFO_REQ',
6464: p_msg_appl_name => 'WSM' ,
6465: p_msg_tokens => l_msg_tokens ,
6466: p_stmt_num => l_stmt_num ,
6511: l_msg_tokens.delete;
6512: l_msg_tokens(1).TokenName := 'JOB';
6513: l_msg_tokens(1).TokenValue := p_resulting_jobs_tbl(l_index).wip_entity_name;
6514:
6515: WSM_log_PVT.logMessage(p_module_name => l_module ,
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 ,
6550: if (l_start_as_res_job = 0)
6551: then
6552: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
6553: l_msg_tokens.delete;
6554: WSM_log_PVT.logMessage (p_module_name => l_module ,
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 ,
6620: -- Now call the new API proposed by the INV team that will update all the serial numbers linked
6621: -- with a particular job with new inventory item
6622: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
6623: l_msg_tokens.delete;
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 ,
6667: if l_start_as_res_job = 0 then
6668: l_stmt_num := 154;
6669: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
6670: l_msg_tokens.delete;
6671: WSM_log_PVT.logMessage (p_module_name => l_module ,
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 ,
6919: l_msg_tokens.delete;
6920: l_msg_tokens(1).TokenName := 'JOB';
6921: l_msg_tokens(1).TokenValue := p_starting_jobs_tbl(p_starting_jobs_tbl.first).wip_entity_name;
6922:
6923: WSM_log_PVT.logMessage(p_module_name => l_module ,
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 ,
6937: l_stmt_num := 195;
6938: -- invoke the mail INV API to update the wip entity id, item and op information....
6939: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
6940: l_msg_tokens.delete;
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 ,
6976: IF p_resulting_jobs_tbl(p_resulting_jobs_tbl.first).wip_entity_name <> p_starting_jobs_tbl(l_rep_job_index).wip_entity_name THEN
6977: -- In this case invoke the new INV API procedure...
6978: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
6979: l_msg_tokens.delete;
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 ,
7078: l_msg_tokens.delete;
7079: l_msg_tokens(1).TokenName := 'JOB';
7080: l_msg_tokens(1).TokenValue := p_starting_jobs_tbl(p_starting_jobs_tbl.first).wip_entity_name;
7081:
7082: WSM_log_PVT.logMessage(p_module_name => l_module ,
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 ,
7097: l_stmt_num := 230;
7098: -- Invoke the new INV API procedure...
7099: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
7100: l_msg_tokens.delete;
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 ,
7155:
7156: -- Invoke the new INV API procedure...
7157: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
7158: l_msg_tokens.delete;
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 ,
7243: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
7244: THEN
7245:
7246: l_msg_tokens.delete;
7247: WSM_log_PVT.logMessage(p_module_name => l_module ,
7248: p_msg_name => 'WSM_UPD_QTY_REC_IGNORE' ,
7249: p_msg_appl_name => 'WSM' ,
7250: p_msg_tokens => l_msg_tokens ,
7251: p_stmt_num => l_stmt_num ,
7331: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
7332: THEN
7333:
7334: l_msg_tokens.delete;
7335: WSM_log_PVT.logMessage(p_module_name => l_module ,
7336: p_msg_name => 'WSM_INVALID_SERIAL_TRACK_QTY',
7337: p_msg_appl_name => 'WSM' ,
7338: p_msg_tokens => l_msg_tokens ,
7339: p_stmt_num => l_stmt_num ,
7473:
7474: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
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: );
7502:
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;
7545: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
7546: THEN
7547:
7548: l_msg_tokens.delete;
7549: WSM_log_PVT.logMessage(p_module_name => l_module ,
7550: p_msg_name => 'WSM_INVALID_JOB_TXN_QTY',
7551: p_msg_appl_name => 'WSM' ,
7552: p_msg_tokens => l_msg_tokens ,
7553: p_stmt_num => l_stmt_num ,
7571: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
7572: THEN
7573:
7574: l_msg_tokens.delete;
7575: WSM_log_PVT.logMessage(p_module_name => l_module ,
7576: p_msg_name => 'WSM_INVALID_JOB_TXN_QTY',
7577: p_msg_appl_name => 'WSM' ,
7578: p_msg_tokens => l_msg_tokens ,
7579: p_stmt_num => l_stmt_num ,
7603: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
7604: THEN
7605:
7606: l_msg_tokens.delete;
7607: WSM_log_PVT.logMessage(p_module_name => l_module ,
7608: p_msg_name => 'WSM_UOM_CONVERSION_FAILED',
7609: p_msg_appl_name => 'WSM' ,
7610: p_msg_tokens => l_msg_tokens ,
7611: p_stmt_num => l_stmt_num ,
7630: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
7631: THEN
7632:
7633: l_msg_tokens.delete;
7634: WSM_log_PVT.logMessage(p_module_name => l_module ,
7635: p_msg_name => 'WSM_INVALID_JOB_TXN_QTY',
7636: p_msg_appl_name => 'WSM' ,
7637: p_msg_tokens => l_msg_tokens ,
7638: p_stmt_num => l_stmt_num ,
7672:
7673: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
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: );
7697: )
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';
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;
7707: -- Logging variables...
7708:
7709: BEGIN
7710: x_return_status := G_RET_SUCCESS;
7726: l_param_tbl(3).paramName := 'p_group_id';
7727: l_param_tbl(3).paramValue := p_group_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;
7941:
7942: l_stmt_num := 30;
7943: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
7944: l_msg_tokens.delete;
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 ,
8155:
8156: l_stmt_num := 50;
8157: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
8158: l_msg_tokens.delete;
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 ,
8469: l_serial_txn_tbl t_number;
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';
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;
8479: -- Logging variables...
8480:
8481: BEGIN
8482: l_stmt_num := 10;
8501:
8502: l_param_tbl(5).paramName := 'p_organization_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;
8524:
8525: l_stmt_num := 40;
8526: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
8527: l_msg_tokens.delete;
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 ,
8579: l_stmt_num := 80;
8580:
8581: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
8582: l_msg_tokens.delete;
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 ,
8639:
8640: l_stmt_num := 140;
8641: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
8642: l_msg_tokens.delete;
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 ,
8694: l_stmt_num := 180;
8695:
8696: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
8697: l_msg_tokens.delete;
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 ,
8751:
8752: l_stmt_num := 240;
8753: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
8754: l_msg_tokens.delete;
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 ,
8816: l_stmt_num := 280;
8817:
8818: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
8819: l_msg_tokens.delete;
8820: WSM_log_PVT.logMessage (p_module_name => l_module ,
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 ,
8865: and transaction_type_id = 5;
8866:
8867: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
8868: l_msg_tokens.delete;
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 ,
8878:
8879: l_stmt_num := 320;
8880: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
8881: l_msg_tokens.delete;
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 ,
8912:
8913: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
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: );
8941: x_error_count OUT NOCOPY NUMBER
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';
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;
8951: -- Logging variables...
8952:
8953: begin
8954:
8967:
8968: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
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: );
9102: l_first_serial_txn_id NUMBER;
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';
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;
9112: -- Logging variables...
9113:
9114: BEGIN
9115: l_stmt_num := 10;
9114: BEGIN
9115: l_stmt_num := 10;
9116: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
9117: l_msg_tokens.delete;
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 ,
9157: close c_move_serials;
9158:
9159: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
9160: l_msg_tokens.delete;
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 ,
9190: END IF;
9191:
9192: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
9193: l_msg_tokens.delete;
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 ,
9235:
9236: IF p_move_txn_type IN (2,3) THEN -- Assembly return and completion transaction...
9237: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
9238: l_msg_tokens.delete;
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 ,
9264: END IF;
9265:
9266: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
9267: l_msg_tokens.delete;
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 ,
9298:
9299: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
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: );
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.....
9330: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
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.....
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';
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;
9336: -- Logging variables...
9337:
9338: l_message_tbl t_log_message_tbl;
9339: l_log_message FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
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;
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;
9359: END IF;
9360:
9361: IF( g_log_level_statement >= l_log_level ) THEN
9362:
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,
9465:
9466: WHILE l_counter IS NOT NULL LOOP
9467: IF length(l_log_message || l_message_tbl(l_counter)) > 3900 THEN
9468: -- Log the data in l_log_message...
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 ,
9484: l_stmt_num := 40;
9485: -- Log the remainder data..
9486: IF l_log_message IS NOT NULL THEN
9487: -- Log the data in l_log_message...
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 ,
9506:
9507: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
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: );