[Home] [Help]
44:
45: l_rtg_item_id number;
46: l_err_code NUMBER;
47: -- Logging variables.....
48: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
49: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
50:
51: l_stmt_num NUMBER;
52: l_module VARCHAR2(100) := 'wsm.plsql.WSM_WLT_VALIDATE_PVT.routing_seq';
49: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
50:
51: l_stmt_num NUMBER;
52: l_module VARCHAR2(100) := 'wsm.plsql.WSM_WLT_VALIDATE_PVT.routing_seq';
53: l_param_tbl WSM_Log_PVT.param_tbl_type;
54: -- Logging variables...
55:
56:
57: BEGIN
86: l_param_tbl(7).paramName := 'p_default_subinv';
87: l_param_tbl(7).paramValue := p_default_subinv;
88:
89:
90: WSM_Log_PVT.logProcParams(p_module_name => l_module ,
91: p_param_tbl => l_param_tbl,
92: p_fnd_log_level => l_log_level
93: );
94: END IF;
103: IF g_log_level_error >= l_log_level OR
104: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
105: THEN
106: l_msg_tokens.delete;
107: WSM_log_PVT.logMessage(p_module_name => l_module ,
108: p_msg_name => 'WSM_NS_RTNG_REF_NULL' ,
109: p_msg_appl_name => 'WSM' ,
110: p_msg_tokens => l_msg_tokens ,
111: p_fnd_msg_level => G_MSG_LVL_ERROR ,
150: ELSE
151: l_msg_tokens(1).TokenValue := 'ROUTING_REFERENCE_ID/ALTERNATE_ROUTING_DESIGNATOR';
152: END IF;
153:
154: WSM_log_PVT.logMessage(p_module_name => l_module ,
155: p_msg_name => 'WSM_INVALID_FIELD' ,
156: p_msg_appl_name => 'WSM' ,
157: p_msg_tokens => l_msg_tokens ,
158: p_fnd_msg_level => G_MSG_LVL_ERROR ,
207: ELSE
208: l_msg_tokens(1).TokenValue := 'ROUTING_REFERENCE_ID/COMMON_ROUTING_SEQUENCE_ID';
209: END IF;
210:
211: WSM_log_PVT.logMessage(p_module_name => l_module ,
212: p_msg_name => 'WSM_INVALID_FIELD' ,
213: p_msg_appl_name => 'WSM' ,
214: p_msg_tokens => l_msg_tokens ,
215: p_fnd_msg_level => G_MSG_LVL_ERROR ,
235:
236: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
237: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
238: THEN
239: WSM_log_PVT.handle_others( p_module_name => l_module ,
240: p_stmt_num => l_stmt_num ,
241: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
242: p_run_log_level => l_log_level
243: );
268: l_temp_num number;
269: l_bom_item_id number;
270:
271: -- Logging variables.....
272: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
273: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
274:
275: l_stmt_num NUMBER;
276: l_module VARCHAR2(100) := 'wsm.plsql.WSM_WLT_VALIDATE_PVT.bom_seq';
273: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
274:
275: l_stmt_num NUMBER;
276: l_module VARCHAR2(100) := 'wsm.plsql.WSM_WLT_VALIDATE_PVT.bom_seq';
277: l_param_tbl WSM_Log_PVT.param_tbl_type;
278: -- Logging variables...
279:
280: BEGIN
281: x_return_status := G_RET_SUCCESS;
308:
309: l_param_tbl(7).paramName := 'x_bom_seq_id';
310: l_param_tbl(7).paramValue := x_bom_seq_id;
311:
312: WSM_Log_PVT.logProcParams(p_module_name => l_module ,
313: p_param_tbl => l_param_tbl,
314: p_fnd_log_level => l_log_level
315: );
316: END IF;
339: THEN
340: l_msg_tokens.delete;
341: l_msg_tokens(1).TokenName := 'FLD_NAME';
342: l_msg_tokens(1).TokenValue := 'Bom Reference Id';
343: WSM_log_PVT.logMessage(p_module_name => l_module ,
344: p_msg_name => 'WSM_INVALID_FIELD' ,
345: p_msg_appl_name => 'WSM' ,
346: p_msg_tokens => l_msg_tokens ,
347: p_fnd_msg_level => G_MSG_LVL_ERROR ,
384: IF g_log_level_error >= l_log_level OR
385: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
386: THEN
387: l_msg_tokens.delete;
388: WSM_log_PVT.logMessage(p_module_name => l_module ,
389: p_msg_name => 'WIP_BILL_DOES_NOT_EXIST',
390: p_msg_appl_name => 'WIP' ,
391: p_msg_tokens => l_msg_tokens ,
392: p_fnd_msg_level => G_MSG_LVL_ERROR ,
425: THEN
426: l_msg_tokens.delete;
427: l_msg_tokens(1).TokenName := 'FLD_NAME';
428: l_msg_tokens(1).TokenValue := 'ALTERNATE_BOM_DESIGNATOR';
429: WSM_log_PVT.logMessage(p_module_name => l_module ,
430: p_msg_name => 'WSM_INVALID_FIELD' ,
431: p_msg_appl_name => 'WSM' ,
432: p_msg_tokens => l_msg_tokens ,
433: p_fnd_msg_level => G_MSG_LVL_ERROR ,
458: THEN
459: l_msg_tokens.delete;
460: l_msg_tokens(1).TokenName := 'FLD_NAME';
461: l_msg_tokens(1).TokenValue := 'COMMON_BOM_SEQUENCE_ID';
462: WSM_log_PVT.logMessage(p_module_name => l_module ,
463: p_msg_name => 'WSM_INVALID_FIELD' ,
464: p_msg_appl_name => 'WSM' ,
465: p_msg_tokens => l_msg_tokens ,
466: p_fnd_msg_level => G_MSG_LVL_ERROR ,
489: THEN
490: l_msg_tokens.delete;
491: l_msg_tokens(1).TokenName := 'FLD_NAME';
492: l_msg_tokens(1).TokenValue := 'COMMON_BOM_SEQUENCE_ID';
493: WSM_log_PVT.logMessage(p_module_name => l_module ,
494: p_msg_name => 'WSM_INVALID_FIELD' ,
495: p_msg_appl_name => 'WSM' ,
496: p_msg_tokens => l_msg_tokens ,
497: p_fnd_msg_level => G_MSG_LVL_ERROR ,
515: l_stmt_num := 70;
516:
517: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
518: l_msg_tokens.delete;
519: WSM_log_PVT.logMessage (p_module_name => l_module ,
520: p_msg_text => l_module || ' completed sucessfully',
521: p_stmt_num => l_stmt_num ,
522: p_msg_tokens => l_msg_tokens ,
523: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
538:
539: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
540: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
541: THEN
542: WSM_log_PVT.handle_others( p_module_name => l_module ,
543: p_stmt_num => l_stmt_num ,
544: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
545: p_run_log_level => l_log_level
546: );
574: l_exists boolean;
575: l_job_name_hash number;
576:
577: -- Logging variables.....
578: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
579: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
580:
581: l_stmt_num NUMBER;
582: l_module VARCHAR2(100) := 'wsm.plsql.WSM_WLT_VALIDATE_PVT.wip_entity';
579: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
580:
581: l_stmt_num NUMBER;
582: l_module VARCHAR2(100) := 'wsm.plsql.WSM_WLT_VALIDATE_PVT.wip_entity';
583: l_param_tbl WSM_Log_PVT.param_tbl_type;
584:
585: BEGIN
586:
587: x_return_status := G_RET_SUCCESS;
605:
606: l_param_tbl(4).paramName := 'p_job_name';
607: l_param_tbl(4).paramValue := p_job_name;
608:
609: WSM_Log_PVT.logProcParams(p_module_name => l_module ,
610: p_param_tbl => l_param_tbl,
611: p_fnd_log_level => l_log_level
612: );
613: END IF;
617: -- job name should be less than 80 chars
618: IF LENGTH(p_job_name) > 80 THEN
619: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
620: l_msg_tokens.delete;
621: WSM_log_PVT.logMessage(p_module_name=> l_module ,
622: p_msg_name => 'WSM_JOB_NAME_THIRTY_CHAR',
623: p_msg_appl_name => 'WSM',
624: p_msg_tokens => l_msg_tokens ,
625: p_stmt_num => l_stmt_num ,
653:
654: IF l_temp_num = 1 then
655: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
656: l_msg_tokens.delete;
657: WSM_log_PVT.logMessage(p_module_name=> l_module ,
658: p_msg_name => 'WIP_ML_JOB_NAME',
659: p_msg_appl_name => 'WIP',
660: p_msg_tokens => l_msg_tokens ,
661: p_stmt_num => l_stmt_num ,
672:
673: WHEN OTHERS THEN
674: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
675: l_msg_tokens.delete;
676: WSM_log_PVT.logMessage(p_module_name=> l_module ,
677: p_msg_name => 'WIP_ML_JOB_NAME',
678: p_msg_appl_name => 'WIP',
679: p_msg_tokens => l_msg_tokens ,
680: p_stmt_num => l_stmt_num ,
688: END IF; -- Job update
689:
690: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
691: l_msg_tokens.delete;
692: WSM_log_PVT.logMessage (p_module_name => l_module ,
693: p_msg_text => l_module || ' completed sucessfully',
694: p_stmt_num => l_stmt_num ,
695: p_msg_tokens => l_msg_tokens ,
696: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
711:
712: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
713: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
714: THEN
715: WSM_log_PVT.handle_others( p_module_name => l_module ,
716: p_stmt_num => l_stmt_num ,
717: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
718: p_run_log_level => l_log_level
719: );
747:
748: l_field_name VARCHAR2(100);
749:
750: -- logging variables
751: l_msg_tokens WSM_log_PVT.token_rec_tbl;
752: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
753: l_module VARCHAR2(100) := 'wsm.plsql.WSM_WLT_VALIDATE_PVT.validate_txn_header';
754: l_stmt_num NUMBER := 0;
755: BEGIN
762:
763: -- Log the Procedure entry point....
764: if( g_log_level_statement >= l_log_level ) then
765: l_msg_tokens.delete;
766: WSM_log_PVT.logMessage(p_module_name => l_module ,
767: p_msg_text => 'Entered validate_txn_header',
768: p_stmt_num => l_stmt_num ,
769: p_msg_tokens => l_msg_tokens ,
770: p_fnd_log_level => g_log_level_statement,
783: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
784: l_msg_tokens.delete;
785: l_msg_tokens(1).TokenName := 'FLD_NAME';
786: l_msg_tokens(1).TokenValue := 'Both Organization_id and organization_code in Split Merge Transactions';
787: WSM_log_PVT.logMessage(p_module_name => l_module ,
788: p_msg_name => 'WSM_NULL_FIELD',
789: p_msg_appl_name => 'WSM' ,
790: p_stmt_num => l_stmt_num ,
791: p_msg_tokens => l_msg_tokens ,
811: where (organization_id = p_wltx_header.organization_id );
812:
813: if( g_log_level_statement >= l_log_level ) then
814: l_msg_tokens.delete;
815: WSM_log_PVT.logMessage(p_module_name => l_module ,
816: p_msg_text => ' Modified the organization_code in the txn header record to : ' || p_wltx_header.organization_code,
817: p_stmt_num => l_stmt_num ,
818: p_msg_tokens => l_msg_tokens ,
819: p_fnd_log_level => g_log_level_statement,
834: and organization_id = nvl(p_wltx_header.organization_id,organization_id);
835:
836: IF( g_log_level_statement >= l_log_level ) THEN
837: l_msg_tokens.delete;
838: WSM_log_PVT.logMessage(p_module_name => l_module ,
839: p_msg_text => ' Modified the organization_id in the txn header record to : ' || p_wltx_header.organization_id,
840: p_stmt_num => l_stmt_num ,
841: p_msg_tokens => l_msg_tokens ,
842: p_fnd_log_level => g_log_level_statement,
854: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
855: l_msg_tokens.delete;
856: l_msg_tokens(1).TokenName := 'FLD_NAME';
857: l_msg_tokens(1).TokenValue := 'value for field ' || l_field_name || ' in the txn header record ';
858: WSM_log_PVT.logMessage(p_module_name => l_module ,
859: p_msg_name => 'WSM_INVALID_FIELD',
860: p_msg_appl_name => 'WSM' ,
861: p_msg_tokens => l_msg_tokens ,
862: p_stmt_num => l_stmt_num ,
878: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
879: l_msg_tokens.delete;
880: l_msg_tokens(1).TokenName := 'FLD_NAME';
881: l_msg_tokens(1).TokenValue := 'Transaction Type in Split Merge Transactions';
882: WSM_log_PVT.logMessage(p_module_name => l_module ,
883: p_msg_name => 'WSM_NULL_FIELD',
884: p_msg_appl_name => 'WSM' ,
885: p_msg_tokens => l_msg_tokens ,
886: p_stmt_num => l_stmt_num ,
903: l_txn_type := p_wltx_header.transaction_type_id;
904:
905: IF( g_log_level_statement >= l_log_level ) THEN
906: l_msg_tokens.delete;
907: WSM_log_PVT.logMessage(p_module_name => l_module ,
908: p_msg_text => 'Valid transaction type' ,
909: p_stmt_num => l_stmt_num ,
910: p_msg_tokens => l_msg_tokens,
911: p_fnd_log_level => g_log_level_statement,
919: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
920: l_msg_tokens.delete;
921: l_msg_tokens(1).TokenName := 'FLD_NAME';
922: l_msg_tokens(1).TokenValue := ' value for field transaction_type_id in the txn header record ';
923: WSM_log_PVT.logMessage(p_module_name => l_module ,
924: p_msg_name => 'WSM_INVALID_FIELD',
925: p_msg_appl_name => 'WSM' ,
926: p_msg_tokens => l_msg_tokens ,
927: p_stmt_num => l_stmt_num ,
939: IF p_wltx_header.transaction_date IS NULL THEN
940: p_wltx_header.transaction_date := SYSDATE;
941: IF( g_log_level_statement >= l_log_level ) THEN
942: l_msg_tokens.delete;
943: WSM_log_PVT.logMessage(p_module_name => l_module ,
944: p_msg_text => 'Modified the transaction_date in the txn header record to : ' || p_wltx_header.transaction_date ,
945: p_stmt_num => l_stmt_num ,
946: p_msg_tokens => l_msg_tokens,
947: p_fnd_log_level => g_log_level_statement,
954: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
955: l_msg_tokens.delete;
956: l_msg_tokens(1).TokenName := 'FLD_NAME';
957: l_msg_tokens(1).TokenValue := 'value for the transaction date in the txn header record . Transaction date cannot be greater than current date';
958: WSM_log_PVT.logMessage(p_module_name => l_module ,
959: p_msg_name => 'WSM_INVALID_FIELD',
960: p_msg_appl_name => 'WSM' ,
961: p_msg_tokens => l_msg_tokens ,
962: p_stmt_num => l_stmt_num ,
983: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
984: l_msg_tokens.delete;
985: l_msg_tokens(1).TokenName := 'FLD_NAME';
986: l_msg_tokens(1).TokenValue := 'value for field reason_id in the txn header record ';
987: WSM_log_PVT.logMessage(p_module_name => l_module ,
988: p_msg_name => 'WSM_INVALID_FIELD',
989: p_msg_appl_name => 'WSM' ,
990: p_msg_tokens => l_msg_tokens ,
991: p_stmt_num => l_stmt_num ,
1016: l_stmt_num := 160;
1017: -- Log the Procedure exit point....
1018: if( g_log_level_statement >= l_log_level ) then
1019: l_msg_tokens.delete;
1020: WSM_log_PVT.logMessage(p_module_name => l_module ,
1021: p_msg_text => 'WSMPUTIL.GET_INV_ACCT_PERIOD returned failure : ' || l_msg_data ,
1022: p_stmt_num => l_stmt_num ,
1023: p_msg_tokens => l_msg_tokens,
1024: p_fnd_log_level => g_log_level_statement,
1027: End if;
1028:
1029: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
1030: l_msg_tokens.delete;
1031: WSM_log_PVT.logMessage(p_module_name=> l_module ,
1032: p_msg_name => 'WSM_ACCT_PERIOD_NOT_OPEN',
1033: p_msg_appl_name => 'WSM',
1034: p_msg_tokens => l_msg_tokens ,
1035: p_stmt_num => l_stmt_num ,
1043: END;
1044:
1045: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
1046: l_msg_tokens.delete;
1047: WSM_log_PVT.logMessage (p_module_name => l_module ,
1048: p_msg_text => 'Validation of transaction header success',
1049: p_stmt_num => l_stmt_num ,
1050: p_msg_tokens => l_msg_tokens ,
1051: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
1077:
1078: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
1079: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
1080: THEN
1081: WSM_log_PVT.handle_others( p_module_name => l_module ,
1082: p_stmt_num => l_stmt_num ,
1083: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
1084: p_run_log_level => l_log_level
1085: );
1107: l_later_txn_exists NUMBER := 0;
1108:
1109: -- local variable for debug purpose
1110: l_stmt_num NUMBER := 0;
1111: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
1112: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1113: l_module VARCHAR2(100) := 'wsm.plsql.WSM_WLT_VALIDATE_PVT.validate_sj_txn_date';
1114: l_param_tbl WSM_Log_PVT.param_tbl_type;
1115:
1110: l_stmt_num NUMBER := 0;
1111: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
1112: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1113: l_module VARCHAR2(100) := 'wsm.plsql.WSM_WLT_VALIDATE_PVT.validate_sj_txn_date';
1114: l_param_tbl WSM_Log_PVT.param_tbl_type;
1115:
1116: BEGIN
1117:
1118: l_stmt_num := 10;
1135:
1136: l_param_tbl(3).paramName := 'p_sj_date_released';
1137: l_param_tbl(3).paramValue := p_sj_date_released;
1138:
1139: WSM_Log_PVT.logProcParams(p_module_name => l_module ,
1140: p_param_tbl => l_param_tbl,
1141: p_fnd_log_level => l_log_level
1142: );
1143: END IF;
1148: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
1149: l_msg_tokens.delete;
1150: l_msg_tokens(1).TokenName := 'JOB';
1151: l_msg_tokens(1).TokenValue := p_sj_wip_entity_name;
1152: WSM_log_PVT.logMessage(p_module_name => l_module ,
1153: p_msg_name => 'WSM_INVALID_TXN_REL_DATE',
1154: p_msg_appl_name => 'WSM' ,
1155: p_msg_tokens => l_msg_tokens ,
1156: p_stmt_num => l_stmt_num ,
1180: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
1181: l_msg_tokens.delete;
1182: l_msg_tokens(1).TokenName := 'JOB';
1183: l_msg_tokens(1).TokenValue := p_sj_wip_entity_name;
1184: WSM_log_PVT.logMessage(p_module_name => l_module ,
1185: p_msg_name => 'WSM_INVALID_WLT_TXN_DATE',
1186: p_msg_appl_name => 'WSM' ,
1187: p_msg_tokens => l_msg_tokens ,
1188: p_stmt_num => l_stmt_num ,
1217: x_return_status := G_RET_UNEXPECTED;
1218: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
1219: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
1220: THEN
1221: WSM_log_PVT.handle_others( p_module_name => l_module ,
1222: p_stmt_num => l_stmt_num ,
1223: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
1224: p_run_log_level => l_log_level
1225: );
1408: e_invalid_field exception;
1409:
1410: -- local variable for debug purpose
1411: l_stmt_num NUMBER := 0;
1412: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
1413: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1414: l_module VARCHAR2(100) := 'wsm.plsql.WSM_WLT_VALIDATE_PVT.derive_val_st_job_details';
1415: l_param_tbl WSM_Log_PVT.param_tbl_type;
1416:
1411: l_stmt_num NUMBER := 0;
1412: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
1413: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1414: l_module VARCHAR2(100) := 'wsm.plsql.WSM_WLT_VALIDATE_PVT.derive_val_st_job_details';
1415: l_param_tbl WSM_Log_PVT.param_tbl_type;
1416:
1417: BEGIN
1418: SAVEPOINT start_def_start_job;
1419:
1437:
1438: l_param_tbl(2).paramName := 'p_txn_type';
1439: l_param_tbl(2).paramValue := p_txn_type;
1440:
1441: WSM_Log_PVT.logProcParams(p_module_name => l_module ,
1442: p_param_tbl => l_param_tbl,
1443: p_fnd_log_level => l_log_level
1444: );
1445: END IF;
1450: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
1451: l_msg_tokens.delete;
1452: l_msg_tokens(1).TokenName := 'FLD_NAME';
1453: l_msg_tokens(1).TokenValue := 'Entity id and Entity name';
1454: WSM_log_PVT.logMessage(p_module_name => l_module ,
1455: p_msg_name => 'WSM_NULL_FIELD',
1456: p_msg_appl_name => 'WSM' ,
1457: p_msg_tokens => l_msg_tokens ,
1458: p_stmt_num => l_stmt_num ,
1723:
1724: -- Check for OSP resource.........................................
1725: if( g_log_level_statement >= l_log_level ) then
1726: l_msg_tokens.delete;
1727: WSM_log_PVT.logMessage(p_module_name => l_module ,
1728: p_msg_text => 'Check for OSP resource' ,
1729: p_stmt_num => l_stmt_num ,
1730: p_msg_tokens => l_msg_tokens,
1731: p_fnd_log_level => g_log_level_statement,
1748: THEN
1749: -- Populate a warning message..........................event
1750: IF g_log_level_event >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_SUCCESS) then
1751: l_msg_tokens.delete;
1752: WSM_log_PVT.logMessage(p_module_name => l_module ,
1753: p_msg_name => 'WSM_OP_PURCHASE_REQ',
1754: p_msg_appl_name => 'WSM' ,
1755: p_msg_tokens => l_msg_tokens ,
1756: p_stmt_num => l_stmt_num ,
1765:
1766: l_stmt_num := 170;
1767: IF( g_log_level_statement >= l_log_level ) THEN
1768: l_msg_tokens.delete;
1769: WSM_log_PVT.logMessage(p_module_name => l_module ,
1770: p_msg_text => 'Derive validate Starting job success' ,
1771: p_stmt_num => l_stmt_num ,
1772: p_msg_tokens => l_msg_tokens ,
1773: p_fnd_log_level => g_log_level_statement ,
1783: l_msg_tokens.delete;
1784: l_msg_tokens(1).TokenName := 'FLD_NAME';
1785: l_msg_tokens(1).TokenValue := l_field_name;
1786:
1787: WSM_log_PVT.logMessage(p_module_name => l_module ,
1788: p_msg_name => 'WSM_INVALID_FIELD' ,
1789: p_msg_appl_name => 'WSM' ,
1790: p_msg_tokens => l_msg_tokens ,
1791: p_stmt_num => l_stmt_num ,
1796: l_msg_tokens.delete;
1797: l_msg_tokens(1).TokenName := 'FLD_NAME';
1798: l_msg_tokens(1).TokenValue := 'Job State : Verify Starting Job Information provided';
1799:
1800: WSM_log_PVT.logMessage(p_module_name => l_module ,
1801: p_msg_name => 'WSM_INVALID_FIELD' ,
1802: p_msg_appl_name => 'WSM' ,
1803: p_msg_tokens => l_msg_tokens ,
1804: p_stmt_num => l_stmt_num ,
1838:
1839: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
1840: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
1841: THEN
1842: WSM_log_PVT.handle_others( p_module_name => l_module ,
1843: p_stmt_num => l_stmt_num ,
1844: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
1845: p_run_log_level => l_log_level
1846: );
1885: l_code NUMBER;
1886:
1887: -- local variable for logging purpose
1888: l_stmt_num NUMBER := 0;
1889: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
1890: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1891: l_module VARCHAR2(100) := 'wsm.plsql.WSM_WLT_VALIDATE_PVT.DERIVE_VAL_ST_JOB_DETAILS';
1892:
1893: -- Loop Variable
1904:
1905: -- Log the Procedure entry point....
1906: if( g_log_level_statement >= l_log_level ) then
1907: l_msg_tokens.delete;
1908: WSM_log_PVT.logMessage(p_module_name => l_module,
1909: p_msg_text => 'Entering the Derive Validate Starting Job procedure for Merge',
1910: p_stmt_num => l_stmt_num,
1911: p_msg_tokens => l_msg_tokens,
1912: p_fnd_log_level => g_log_level_statement,
1926: l_stmt_num := 70;
1927:
1928: if( g_log_level_statement >= l_log_level ) then
1929: l_msg_tokens.delete;
1930: WSM_log_PVT.logMessage(p_module_name => l_module,
1931: p_msg_text => 'Calling WSM_WIP_LOT_TXN_PVT.derive_val_st_job_details ',
1932: p_stmt_num => l_stmt_num,
1933: p_msg_tokens => l_msg_tokens,
1934: p_fnd_log_level => g_log_level_statement,
1954: -- Log the Procedure exit point....
1955: if( g_log_level_statement >= l_log_level ) then
1956:
1957: l_msg_tokens.delete;
1958: WSM_log_PVT.logMessage(p_module_name => l_module ,
1959: p_msg_text => 'WSM_WIP_LOT_TXN_PVT.derive_val_st_job_details returned failure' ,
1960: p_stmt_num => l_stmt_num ,
1961: p_msg_tokens => l_msg_tokens,
1962: p_fnd_msg_level => G_MSG_LVL_ERROR ,
1996: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
1997: THEN
1998:
1999: l_msg_tokens.delete;
2000: WSM_log_PVT.logMessage(p_module_name => l_module ,
2001: p_msg_name => 'WSM_INVALID_MERGE_TXN' ,
2002: p_msg_appl_name => 'WSM' ,
2003: p_stmt_num => l_stmt_num ,
2004: p_msg_tokens => l_msg_tokens ,
2037: -- Error out ... cannot managed serial and non-serial tracked jobs.
2038:
2039: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
2040: l_msg_tokens.delete;
2041: WSM_log_PVT.logMessage(p_module_name=> l_module ,
2042: p_msg_name => 'WSM_INVALID_TRACK_MERGE',
2043: p_msg_appl_name => 'WSM',
2044: p_msg_tokens => l_msg_tokens ,
2045: p_stmt_num => l_stmt_num ,
2060: --error msg
2061: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
2062:
2063: l_msg_tokens.delete;
2064: WSM_log_PVT.logMessage(p_module_name=> l_module ,
2065: p_msg_name => 'WSM_CHECK_STLOT_WHILE_MERGE',
2066: p_msg_appl_name => 'WSM',
2067: p_msg_tokens => l_msg_tokens ,
2068: p_stmt_num => l_stmt_num ,
2082: l_stmt_num := 80;
2083: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
2084:
2085: l_msg_tokens.delete;
2086: WSM_log_PVT.logMessage(p_module_name=> l_module ,
2087: p_msg_name => 'WSM_DIFF_JOB_TYP_ST',
2088: p_msg_appl_name => 'WSM',
2089: p_stmt_num => l_stmt_num ,
2090: p_msg_tokens => l_msg_tokens ,
2101: IF p_starting_jobs_tbl(l_counter).standard_operation_id is NULL then
2102: l_stmt_num := 85;
2103: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) then
2104: l_msg_tokens.delete;
2105: WSM_log_PVT.logMessage(p_module_name => l_module ,
2106: p_msg_name => 'WSM_NO_MERGE_AT_NSO',
2107: p_msg_appl_name => 'WSM' ,
2108: p_msg_tokens => l_msg_tokens ,
2109: p_stmt_num => l_stmt_num ,
2125: THEN
2126: l_stmt_num := 100;
2127: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
2128: l_msg_tokens.delete;
2129: WSM_log_PVT.logMessage(p_module_name=> l_module ,
2130: p_msg_name => 'WSM_MERGE_SL_STD_OP_ID',
2131: p_msg_appl_name => 'WSM',
2132: p_msg_tokens => l_msg_tokens ,
2133: p_stmt_num => l_stmt_num ,
2148: -- error out .. only one rep job
2149: l_stmt_num := 110;
2150: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
2151: l_msg_tokens.delete;
2152: WSM_log_PVT.logMessage(p_module_name=> l_module ,
2153: p_msg_name => 'WSM_REPRESENTATIVE_LOT',
2154: p_msg_appl_name => 'WSM',
2155: p_msg_tokens => l_msg_tokens ,
2156: p_stmt_num => l_stmt_num ,
2174: l_stmt_num := 120;
2175: -- error out as atleast one rep job needed....log error
2176: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
2177: l_msg_tokens.delete;
2178: WSM_log_PVT.logMessage(p_module_name=> l_module ,
2179: p_msg_name => 'WSM_REPRESENTATIVE_LOT',
2180: p_msg_appl_name => 'WSM',
2181: p_msg_tokens => l_msg_tokens ,
2182: p_stmt_num => l_stmt_num ,
2215:
2216: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
2217: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
2218: THEN
2219: WSM_log_PVT.handle_others( p_module_name => l_module ,
2220: p_stmt_num => l_stmt_num ,
2221: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
2222: p_run_log_level => l_log_level
2223: );
2257: l_error_code NUMBER;
2258:
2259: -- local variable for logging purpose
2260: l_stmt_num NUMBER := 0;
2261: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
2262: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2263: l_module VARCHAR2(100) := 'wsm.plsql.WSM_WLT_VALIDATE_PVT.DERIVE_VAL_RES_JOB_DETAILS';
2264:
2265: -- G_MISS_NUM and G_MISS_CHAR (now use G_NULL_CHAR and equivalents..
2278:
2279: -- Log the Procedure entry point....
2280: if( g_log_level_statement >= l_log_level ) then
2281: l_msg_tokens.delete;
2282: WSM_log_PVT.logMessage(p_module_name => l_module ,
2283: p_msg_text => 'Entering the Default validate resulting Jobs' ,
2284: p_stmt_num => l_stmt_num ,
2285: p_msg_tokens => l_msg_tokens,
2286: p_fnd_log_level => g_log_level_statement,
2330: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2331: if( g_log_level_statement >= l_log_level ) then
2332:
2333: l_msg_tokens.delete;
2334: WSM_log_PVT.logMessage(p_module_name => l_module ,
2335: p_msg_text => 'derive_val_primary_item returned failure',
2336: p_stmt_num => l_stmt_num ,
2337: p_msg_tokens => l_msg_tokens,
2338: p_fnd_msg_level => G_MSG_LVL_ERROR ,
2363: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
2364: THEN
2365:
2366: l_msg_tokens.delete;
2367: WSM_log_PVT.logMessage(p_module_name => l_module ,
2368: p_msg_name => 'WSM_INVALID_UPD_ASSY' ,
2369: p_msg_appl_name => 'WSM' ,
2370: p_msg_tokens => l_msg_tokens ,
2371: p_stmt_num => l_stmt_num ,
2395:
2396: IF l_return_status <> G_RET_SUCCESS THEN
2397: if( g_log_level_statement >= l_log_level ) then
2398: l_msg_tokens.delete;
2399: WSM_log_PVT.logMessage(p_module_name => l_module ,
2400: p_msg_text => 'derive_val_bom_info returned failure',
2401: p_stmt_num => l_stmt_num ,
2402: p_msg_tokens => l_msg_tokens,
2403: p_fnd_msg_level => G_MSG_LVL_ERROR ,
2429:
2430: IF l_return_status <> G_RET_SUCCESS THEN
2431: if( g_log_level_statement >= l_log_level ) then
2432: l_msg_tokens.delete;
2433: WSM_log_PVT.logMessage(p_module_name => l_module ,
2434: p_msg_text => 'derive_val_routing_info returned failure',
2435: p_stmt_num => l_stmt_num ,
2436: p_msg_tokens => l_msg_tokens,
2437: p_fnd_msg_level => G_MSG_LVL_ERROR ,
2457:
2458: IF l_error_code < 0 THEN
2459: IF( G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) ) then
2460: l_msg_tokens.delete;
2461: WSM_log_PVT.logMessage(p_module_name => l_module ,
2462: p_msg_text => l_msg_data,
2463: p_stmt_num => l_stmt_num ,
2464: p_msg_tokens => l_msg_tokens,
2465: p_fnd_msg_level => G_MSG_LVL_ERROR ,
2483:
2484: IF l_error_code < 0 THEN
2485: IF( G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) ) then
2486: l_msg_tokens.delete;
2487: WSM_log_PVT.logMessage(p_module_name => l_module ,
2488: p_msg_text => l_msg_data,
2489: p_stmt_num => l_stmt_num ,
2490: p_msg_tokens => l_msg_tokens,
2491: p_fnd_msg_level => G_MSG_LVL_ERROR ,
2518:
2519: IF l_return_status <> G_RET_SUCCESS THEN
2520: if( g_log_level_statement >= l_log_level ) then
2521: l_msg_tokens.delete;
2522: WSM_log_PVT.logMessage(p_module_name => l_module ,
2523: p_msg_text => 'derive_val_starting_op returned failure',
2524: p_stmt_num => l_stmt_num ,
2525: p_msg_tokens => l_msg_tokens,
2526: p_fnd_msg_level => G_MSG_LVL_ERROR ,
2560:
2561: IF l_return_status <> G_RET_SUCCESS THEN
2562: if( g_log_level_statement >= l_log_level ) then
2563: l_msg_tokens.delete;
2564: WSM_log_PVT.logMessage(p_module_name => l_module ,
2565: p_msg_text => 'derive_val_compl_subinv returned failure',
2566: p_stmt_num => l_stmt_num ,
2567: p_msg_tokens => l_msg_tokens,
2568: p_fnd_msg_level => G_MSG_LVL_ERROR ,
2625:
2626: IF l_return_status <> G_RET_SUCCESS THEN
2627: if( g_log_level_statement >= l_log_level ) then
2628: l_msg_tokens.delete;
2629: WSM_log_PVT.logMessage(p_module_name => l_module ,
2630: p_msg_text => 'derive_val_bom_info returned failure',
2631: p_stmt_num => l_stmt_num ,
2632: p_msg_tokens => l_msg_tokens,
2633: p_fnd_msg_level => G_MSG_LVL_ERROR ,
2663: );
2664: IF l_return_status <> G_RET_SUCCESS THEN
2665: if( g_log_level_statement >= l_log_level ) then
2666: l_msg_tokens.delete;
2667: WSM_log_PVT.logMessage(p_module_name => l_module ,
2668: p_msg_text => 'derive_val_routing_info returned failure',
2669: p_stmt_num => l_stmt_num ,
2670: p_msg_tokens => l_msg_tokens,
2671: p_fnd_msg_level => G_MSG_LVL_ERROR ,
2688: (p_resulting_job_rec.routing_revision_date = p_starting_job_rec.routing_revision_date)
2689: then
2690: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
2691: l_msg_tokens.delete;
2692: WSM_log_PVT.logMessage(p_module_name=> l_module,
2693: p_msg_name => 'WSM_NO_ROUTING_CHANGE',
2694: p_msg_appl_name => 'WSM',
2695: p_msg_tokens => l_msg_tokens,
2696: p_stmt_num => l_stmt_num,
2713:
2714: IF l_error_code < 0 THEN
2715: IF( G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) ) then
2716: l_msg_tokens.delete;
2717: WSM_log_PVT.logMessage(p_module_name => l_module ,
2718: p_msg_text => l_msg_data,
2719: p_stmt_num => l_stmt_num ,
2720: p_msg_tokens => l_msg_tokens,
2721: p_fnd_msg_level => G_MSG_LVL_ERROR ,
2739:
2740: IF l_error_code < 0 THEN
2741: IF( G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) ) then
2742: l_msg_tokens.delete;
2743: WSM_log_PVT.logMessage(p_module_name => l_module ,
2744: p_msg_text => l_msg_data,
2745: p_stmt_num => l_stmt_num ,
2746: p_msg_tokens => l_msg_tokens,
2747: p_fnd_msg_level => G_MSG_LVL_ERROR ,
2774:
2775: IF l_return_status <> G_RET_SUCCESS THEN
2776: if( g_log_level_statement >= l_log_level ) then
2777: l_msg_tokens.delete;
2778: WSM_log_PVT.logMessage(p_module_name => l_module ,
2779: p_msg_text => 'derive_val_starting_op returned failure',
2780: p_stmt_num => l_stmt_num ,
2781: p_msg_tokens => l_msg_tokens,
2782: p_fnd_msg_level => G_MSG_LVL_ERROR ,
2820:
2821: IF l_return_status <> G_RET_SUCCESS THEN
2822: if( g_log_level_statement >= l_log_level ) then
2823: l_msg_tokens.delete;
2824: WSM_log_PVT.logMessage(p_module_name => l_module ,
2825: p_msg_text => 'derive_val_compl_subinv returned failure',
2826: p_stmt_num => l_stmt_num ,
2827: p_msg_tokens => l_msg_tokens,
2828: p_fnd_msg_level => G_MSG_LVL_ERROR ,
2891: if (p_resulting_job_rec.start_quantity is null) then
2892: -- error out as qty info is needed....
2893: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
2894: l_msg_tokens.delete;
2895: WSM_log_PVT.logMessage(p_module_name => l_module ,
2896: p_msg_name => 'WSM_QTY_INFO_REQUIRED',
2897: p_msg_appl_name => 'WSM',
2898: p_msg_tokens => l_msg_tokens,
2899: p_stmt_num => l_stmt_num ,
2911: then
2912: -- error out....
2913: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
2914: l_msg_tokens.delete;
2915: WSM_log_PVT.logMessage(p_module_name => l_module ,
2916: p_msg_name => 'WSM_QUANTITY_GREATER',
2917: p_msg_appl_name => 'WSM',
2918: p_msg_tokens => l_msg_tokens,
2919: p_stmt_num => l_stmt_num ,
2955: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
2956: l_msg_tokens.delete;
2957: l_msg_tokens(1).TokenName := 'FLD_NAME';
2958: l_msg_tokens(1).TokenValue := ' Net Quantity';
2959: WSM_log_PVT.logMessage(p_module_name => l_module ,
2960: p_msg_name => 'WSM_INVALID_FIELD',
2961: p_msg_appl_name => 'WSM' ,
2962: p_msg_tokens => l_msg_tokens ,
2963: p_stmt_num => l_stmt_num ,
2978: IF g_log_level_error >= l_log_level OR
2979: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
2980: THEN
2981: l_msg_tokens.delete;
2982: WSM_log_PVT.logMessage(p_module_name => l_module ,
2983: p_msg_name => 'WSM_INVALID_JOB_TXN_QTY',
2984: p_msg_appl_name => 'WSM' ,
2985: p_msg_tokens => l_msg_tokens ,
2986: p_stmt_num => l_stmt_num ,
2999: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
3000: l_msg_tokens.delete;
3001: l_msg_tokens(1).TokenName := 'FLD_NAME';
3002: l_msg_tokens(1).TokenValue := 'BONUS_ACCT_ID';
3003: WSM_log_PVT.logMessage(p_module_name => l_module ,
3004: p_msg_name => 'WSM_NULL_FIELD',
3005: p_msg_appl_name => 'WSM' ,
3006: p_stmt_num => l_stmt_num ,
3007: p_msg_tokens => l_msg_tokens ,
3042:
3043: l_msg_tokens.delete;
3044: l_msg_tokens(1).TokenName := 'FLD_NAME';
3045: l_msg_tokens(1).TokenValue := 'BONUS_ACCT_ID';
3046: WSM_log_PVT.logMessage(p_module_name=> l_module ,
3047: p_msg_name => 'WSM_INVALID_FIELD' ,
3048: p_msg_appl_name => 'WSM' ,
3049: p_msg_tokens => l_msg_tokens ,
3050: p_stmt_num => l_stmt_num ,
3081:
3082: IF l_return_status <> G_RET_SUCCESS THEN
3083: if( g_log_level_statement >= l_log_level ) then
3084: l_msg_tokens.delete;
3085: WSM_log_PVT.logMessage(p_module_name => l_module ,
3086: p_msg_text => 'derive_val_compl_subinv returned failure',
3087: p_stmt_num => l_stmt_num ,
3088: p_msg_tokens => l_msg_tokens,
3089: p_fnd_msg_level => G_MSG_LVL_ERROR ,
3168: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
3169: l_msg_tokens.delete;
3170: l_msg_tokens(1).TokenName := 'FLD_NAME';
3171: l_msg_tokens(1).TokenValue := 'wip_entity_name';
3172: WSM_log_PVT.logMessage(p_module_name => l_module ,
3173: p_msg_name => 'WSM_NULL_FIELD',
3174: p_msg_appl_name => 'WSM' ,
3175: p_stmt_num => l_stmt_num ,
3176: p_msg_tokens => l_msg_tokens ,
3193: then
3194: -- error out as atleast one has to change --
3195: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
3196: l_msg_tokens.delete;
3197: WSM_log_PVT.logMessage(p_module_name=> l_module ,
3198: p_msg_name => 'WSM_NO_JOB_CHANGE',
3199: p_msg_appl_name => 'WSM',
3200: p_msg_tokens => l_msg_tokens ,
3201: p_stmt_num => l_stmt_num ,
3252:
3253: IF l_return_status <> G_RET_SUCCESS THEN
3254: if( g_log_level_statement >= l_log_level ) then
3255: l_msg_tokens.delete;
3256: WSM_log_PVT.logMessage(p_module_name => l_module ,
3257: p_msg_text => 'derive_val_compl_subinv returned failure',
3258: p_stmt_num => l_stmt_num ,
3259: p_msg_tokens => l_msg_tokens,
3260: p_fnd_msg_level => G_MSG_LVL_ERROR ,
3669:
3670: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
3671: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
3672: THEN
3673: WSM_log_PVT.handle_others( p_module_name => l_module ,
3674: p_stmt_num => l_stmt_num ,
3675: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
3676: p_run_log_level => l_log_level
3677: );
3702: l_msg_count number;
3703: l_msg_data varchar2(2000);
3704: --logging variables--
3705: l_module VARCHAR2(100) := 'wsm.plsql.WSM_WLT_VALIDATE_PVT.derive_val_res_job_details';
3706: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
3707: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3708: l_stmt_num NUMBER := 0;
3709:
3710: l_null_char varchar2(10) := FND_API.G_NULL_CHAR;
3716: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
3717: l_msg_tokens.delete;
3718: l_msg_tokens(1).TokenName := 'FLD_NAME';
3719: l_msg_tokens(1).TokenValue := 'Transaction Type not Merge';
3720: WSM_log_PVT.logMessage(p_module_name => l_module ,
3721: p_msg_name => 'WSM_INVALID_FIELD',
3722: p_msg_appl_name => 'WSM' ,
3723: p_stmt_num => l_stmt_num ,
3724: p_msg_tokens => l_msg_tokens ,
3783: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
3784: l_msg_tokens.delete;
3785: l_msg_tokens(1).TokenName := 'FLD_NAME';
3786: l_msg_tokens(1).TokenValue := 'wip_entity_name';
3787: WSM_log_PVT.logMessage(p_module_name => l_module ,
3788: p_msg_name => 'WSM_NULL_FIELD',
3789: p_msg_appl_name => 'WSM' ,
3790: p_stmt_num => l_stmt_num ,
3791: p_msg_tokens => l_msg_tokens ,
3853: l_msg_tokens.delete;
3854: l_msg_tokens(1).TokenName := 'FLD_NAME';
3855: l_msg_tokens(1).TokenName := 'CoProducts Supply';
3856:
3857: WSM_log_PVT.logMessage(p_module_name => l_module ,
3858: p_msg_name => 'WSM_INVALID_FIELD' ,
3859: p_msg_appl_name => 'WSM' ,
3860: p_msg_tokens => l_msg_tokens ,
3861: p_stmt_num => l_stmt_num ,
3879: -- error out,.,,,, --
3880: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
3881:
3882: l_msg_tokens.delete;
3883: WSM_log_PVT.logMessage(p_module_name=> l_module ,
3884: p_msg_name => 'WSM_NET_QTY_MORE_START_QTY',
3885: p_msg_appl_name => 'WSM',
3886: p_msg_tokens => l_msg_tokens ,
3887: p_stmt_num => l_stmt_num ,
3910: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
3911: THEN
3912:
3913: l_msg_tokens.delete;
3914: WSM_log_PVT.logMessage(p_module_name => l_module ,
3915: p_msg_name => 'WSM_INVALID_JOB_TXN_QTY',
3916: p_msg_appl_name => 'WSM' ,
3917: p_msg_tokens => l_msg_tokens ,
3918: p_stmt_num => l_stmt_num ,
3946:
3947: IF l_return_status <> G_RET_SUCCESS THEN
3948: if( g_log_level_statement >= l_log_level ) then
3949: l_msg_tokens.delete;
3950: WSM_log_PVT.logMessage(p_module_name => l_module ,
3951: p_msg_text => 'derive_val_compl_subinv returned failure',
3952: p_stmt_num => l_stmt_num ,
3953: p_msg_tokens => l_msg_tokens ,
3954: p_fnd_msg_level => G_MSG_LVL_ERROR ,
3988:
3989: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
3990: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
3991: THEN
3992: WSM_log_PVT.handle_others( p_module_name => l_module ,
3993: p_stmt_num => l_stmt_num ,
3994: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
3995: p_run_log_level => l_log_level
3996: );
4036: l_start_as_result NUMBER := -1;
4037:
4038: --logging variables --
4039: l_module VARCHAR2(100) := 'wsm.plsql.WSM_WLT_VALIDATE_PVT.derive_val_res_job_details';
4040: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
4041: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4042: l_stmt_num NUMBER := 0;
4043:
4044: begin
4044: begin
4045: l_stmt_num := 10;
4046: if( g_log_level_statement >= l_log_level ) then
4047: l_msg_tokens.delete;
4048: WSM_log_PVT.logMessage(p_module_name => l_module ,
4049: p_msg_text => 'Entered derive_val_res_job_details for split' ,
4050: p_stmt_num => l_stmt_num ,
4051: p_msg_tokens => l_msg_tokens,
4052: p_fnd_log_level => g_log_level_statement,
4059: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
4060: l_msg_tokens.delete;
4061: l_msg_tokens(1).TokenName := 'FLD_NAME';
4062: l_msg_tokens(1).TokenValue := 'Transaction Type Not Split';
4063: WSM_log_PVT.logMessage(p_module_name => l_module ,
4064: p_msg_name => 'WSM_INVALID_FIELD',
4065: p_msg_appl_name => 'WSM' ,
4066: p_stmt_num => l_stmt_num ,
4067: p_msg_tokens => l_msg_tokens ,
4093: l_stmt_num := 30;
4094:
4095: if( g_log_level_statement >= l_log_level ) then
4096: l_msg_tokens.delete;
4097: WSM_log_PVT.logMessage(p_module_name => l_module ,
4098: p_msg_text => 'Before loop on resulting jobs' ,
4099: p_stmt_num => l_stmt_num ,
4100: p_msg_tokens => l_msg_tokens,
4101: p_fnd_log_level => g_log_level_statement,
4115:
4116: l_msg_tokens.delete;
4117: l_msg_tokens(1).TokenName := 'FLD_NAME';
4118: l_msg_tokens(1).TokenValue := 'Entity id and name ';
4119: WSM_log_PVT.logMessage(p_module_name => l_module ,
4120: p_msg_name => 'WSM_NULL_FIELD',
4121: p_msg_appl_name => 'WSM' ,
4122: p_msg_tokens => l_msg_tokens ,
4123: p_stmt_num => l_stmt_num ,
4162: if p_resulting_jobs_tbl(l_counter).wip_entity_id = p_starting_job_rec.wip_entity_id then
4163: -- copy the job name ....
4164: if( g_log_level_statement >= l_log_level ) then
4165: l_msg_tokens.delete;
4166: WSM_log_PVT.logMessage(p_module_name => l_module ,
4167: p_msg_text => 'Copying job name' ,
4168: p_stmt_num => l_stmt_num ,
4169: p_msg_tokens => l_msg_tokens,
4170: p_fnd_log_level => g_log_level_statement,
4176: else
4177: -- error out....
4178: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
4179: l_msg_tokens.delete;
4180: WSM_log_PVT.logMessage(p_module_name=> l_module ,
4181: p_msg_name => 'WSM_SJ_AS_RJ',
4182: p_msg_appl_name => 'WSM',
4183: p_msg_tokens => l_msg_tokens ,
4184: p_stmt_num => l_stmt_num ,
4197: IF l_start_as_result = -1 THEN
4198:
4199: if( g_log_level_statement >= l_log_level ) then
4200: l_msg_tokens.delete;
4201: WSM_log_PVT.logMessage(p_module_name => l_module ,
4202: p_msg_text => 'Assign l_start_as_result=1' ,
4203: p_stmt_num => l_stmt_num ,
4204: p_msg_tokens => l_msg_tokens,
4205: p_fnd_log_level => g_log_level_statement,
4212: -- error out,,,,,
4213: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
4214:
4215: l_msg_tokens.delete;
4216: WSM_log_PVT.logMessage(p_module_name=> l_module ,
4217: p_msg_name => 'WSM_SJ_AS_RJ_ONCE',
4218: p_msg_appl_name => 'WSM',
4219: p_msg_tokens => l_msg_tokens ,
4220: p_stmt_num => l_stmt_num ,
4232: If l_job_name_tbl.exists(p_resulting_jobs_tbl(l_counter).wip_entity_name) THEN
4233: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
4234:
4235: l_msg_tokens.delete;
4236: WSM_log_PVT.logMessage(p_module_name=> l_module ,
4237: p_msg_name => 'WSM_DUPLICATE_RJ_NAME',
4238: p_msg_appl_name => 'WSM',
4239: p_msg_tokens => l_msg_tokens ,
4240: p_stmt_num => l_stmt_num ,
4264: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
4265: l_msg_tokens.delete;
4266: l_msg_tokens(1).TokenName := 'FLD_NAME';
4267: l_msg_tokens(1).TokenValue := 'start_quantity';
4268: WSM_log_PVT.logMessage(p_module_name => l_module ,
4269: p_msg_name => 'WSM_NULL_FIELD',
4270: p_msg_appl_name => 'WSM' ,
4271: p_stmt_num => l_stmt_num ,
4272: p_msg_tokens => l_msg_tokens ,
4287: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
4288: THEN
4289:
4290: l_msg_tokens.delete;
4291: WSM_log_PVT.logMessage(p_module_name => l_module ,
4292: p_msg_name => 'WSM_INVALID_JOB_TXN_QTY',
4293: p_msg_appl_name => 'WSM' ,
4294: p_msg_tokens => l_msg_tokens ,
4295: p_stmt_num => l_stmt_num ,
4307: -- error out..... --
4308: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
4309:
4310: l_msg_tokens.delete;
4311: WSM_log_PVT.logMessage(p_module_name => l_module ,
4312: p_msg_name => 'WSM_SUM_RESULT_START_MORE',
4313: p_msg_appl_name => 'WSM' ,
4314: p_msg_tokens => l_msg_tokens ,
4315: p_stmt_num => l_stmt_num ,
4348:
4349: l_msg_tokens.delete;
4350: l_msg_tokens(1).TokenName := 'FLD_NAME';
4351: l_msg_tokens(1).TokenValue := 'net_quantity';
4352: WSM_log_PVT.logMessage(p_module_name => l_module ,
4353: p_msg_name => 'WSM_INVALID_FIELD',
4354: p_msg_appl_name => 'WSM' ,
4355: p_msg_tokens => l_msg_tokens ,
4356: p_stmt_num => l_stmt_num ,
4373: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
4374: THEN
4375:
4376: l_msg_tokens.delete;
4377: WSM_log_PVT.logMessage(p_module_name => l_module ,
4378: p_msg_name => 'WSM_INVALID_JOB_TXN_QTY',
4379: p_msg_appl_name => 'WSM' ,
4380: p_msg_tokens => l_msg_tokens ,
4381: p_stmt_num => l_stmt_num ,
4411: l_msg_tokens.delete;
4412: l_msg_tokens(1).TokenName := 'FLD_NAME';
4413: l_msg_tokens(1).TokenName := 'CoProducts Supply';
4414:
4415: WSM_log_PVT.logMessage(p_module_name => l_module ,
4416: p_msg_name => 'WSM_INVALID_FIELD' ,
4417: p_msg_appl_name => 'WSM' ,
4418: p_msg_tokens => l_msg_tokens ,
4419: p_stmt_num => l_stmt_num ,
4434: l_msg_tokens.delete;
4435: l_msg_tokens(1).TokenName := 'FLD_NAME';
4436: l_msg_tokens(1).TokenName := 'Split_has_update_assembly';
4437:
4438: WSM_log_PVT.logMessage(p_module_name => l_module ,
4439: p_msg_name => 'WSM_INVALID_FIELD' ,
4440: p_msg_appl_name => 'WSM' ,
4441: p_msg_tokens => l_msg_tokens ,
4442: p_stmt_num => l_stmt_num ,
4464: l_stmt_num := 110;
4465: if p_resulting_jobs_tbl(l_counter).split_has_update_assy = 0 then
4466: if( g_log_level_statement >= l_log_level ) then
4467: l_msg_tokens.delete;
4468: WSM_log_PVT.logMessage(p_module_name => l_module ,
4469: p_msg_text => 'no update of assembly ' ,
4470: p_stmt_num => l_stmt_num ,
4471: p_msg_tokens => l_msg_tokens,
4472: p_fnd_log_level => g_log_level_statement,
4509: else
4510: -- Update of assembly .....
4511: if( g_log_level_statement >= l_log_level ) then
4512: l_msg_tokens.delete;
4513: WSM_log_PVT.logMessage(p_module_name => l_module ,
4514: p_msg_text => 'There is update of assembly ' ,
4515: p_stmt_num => l_stmt_num ,
4516: p_msg_tokens => l_msg_tokens,
4517: p_fnd_log_level => g_log_level_statement,
4530: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
4531: if( g_log_level_statement >= l_log_level ) then
4532:
4533: l_msg_tokens.delete;
4534: WSM_log_PVT.logMessage(p_module_name => l_module ,
4535: p_msg_text => 'derive_val_primary_item returned failure',
4536: p_stmt_num => l_stmt_num ,
4537: p_msg_tokens => l_msg_tokens,
4538: p_fnd_msg_level => G_MSG_LVL_ERROR ,
4562: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
4563: THEN
4564:
4565: l_msg_tokens.delete;
4566: WSM_log_PVT.logMessage(p_module_name => l_module ,
4567: p_msg_name => 'WSM_INVALID_UPD_ASSY' ,
4568: p_msg_appl_name => 'WSM' ,
4569: p_msg_tokens => l_msg_tokens ,
4570: p_stmt_num => l_stmt_num ,
4596: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
4597: if( g_log_level_statement >= l_log_level ) then
4598:
4599: l_msg_tokens.delete;
4600: WSM_log_PVT.logMessage(p_module_name => l_module ,
4601: p_msg_text => 'derive_val_bom_info returned failure',
4602: p_stmt_num => l_stmt_num ,
4603: p_msg_tokens => l_msg_tokens,
4604: p_fnd_msg_level => G_MSG_LVL_ERROR ,
4633: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
4634: if( g_log_level_statement >= l_log_level ) then
4635:
4636: l_msg_tokens.delete;
4637: WSM_log_PVT.logMessage(p_module_name => l_module ,
4638: p_msg_text => 'derive_val_routing_info returned failure',
4639: p_stmt_num => l_stmt_num ,
4640: p_msg_tokens => l_msg_tokens,
4641: p_fnd_msg_level => G_MSG_LVL_ERROR ,
4662:
4663: IF l_error_code < 0 THEN
4664: IF( G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) ) then
4665: l_msg_tokens.delete;
4666: WSM_log_PVT.logMessage(p_module_name => l_module ,
4667: p_msg_text => l_msg_data,
4668: p_stmt_num => l_stmt_num ,
4669: p_msg_tokens => l_msg_tokens,
4670: p_fnd_msg_level => G_MSG_LVL_ERROR ,
4688:
4689: IF l_error_code < 0 THEN
4690: IF( G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) ) then
4691: l_msg_tokens.delete;
4692: WSM_log_PVT.logMessage(p_module_name => l_module ,
4693: p_msg_text => l_msg_data,
4694: p_stmt_num => l_stmt_num ,
4695: p_msg_tokens => l_msg_tokens,
4696: p_fnd_msg_level => G_MSG_LVL_ERROR ,
4723: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
4724: if( g_log_level_statement >= l_log_level ) then
4725:
4726: l_msg_tokens.delete;
4727: WSM_log_PVT.logMessage(p_module_name => l_module ,
4728: p_msg_text => 'derive_val_starting_op returned failure',
4729: p_stmt_num => l_stmt_num ,
4730: p_msg_tokens => l_msg_tokens,
4731: p_fnd_msg_level => G_MSG_LVL_ERROR ,
4770: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
4771: if( g_log_level_statement >= l_log_level ) then
4772:
4773: l_msg_tokens.delete;
4774: WSM_log_PVT.logMessage(p_module_name => l_module ,
4775: p_msg_text => 'derive_val_compl_subinv returned failure',
4776: p_stmt_num => l_stmt_num ,
4777: p_msg_tokens => l_msg_tokens,
4778: p_fnd_msg_level => G_MSG_LVL_ERROR ,
4795: if (l_total_quantity = p_starting_job_rec.quantity_available) and (p_resulting_jobs_tbl.count = 1) then
4796: -- error out...
4797: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
4798: l_msg_tokens.delete;
4799: WSM_log_PVT.logMessage(p_module_name => l_module ,
4800: p_msg_name => 'WSM_ONE_RES_JOB_HAS_FULL_QTY',
4801: p_msg_appl_name => 'WSM',
4802: p_msg_tokens => l_msg_tokens ,
4803: p_stmt_num => l_stmt_num ,
4819: if p_resulting_jobs_tbl.count < 1 then
4820: -- error out...
4821: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
4822: l_msg_tokens.delete;
4823: WSM_log_PVT.logMessage(p_module_name => l_module ,
4824: p_msg_name => 'WSM_RESULT_LOT_REQUIRED',
4825: p_msg_appl_name => 'WSM',
4826: p_msg_tokens => l_msg_tokens ,
4827: p_stmt_num => l_stmt_num ,
4904: IF p_resulting_jobs_tbl.count <= 1 THEN
4905: -- error out...
4906: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
4907: l_msg_tokens.delete;
4908: WSM_log_PVT.logMessage(p_module_name => l_module ,
4909: p_msg_name => 'WSM_SJ_AS_RJ_ONCE',
4910: p_msg_appl_name => 'WSM',
4911: p_msg_tokens => l_msg_tokens ,
4912: p_stmt_num => l_stmt_num ,
4961:
4962: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
4963: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
4964: THEN
4965: WSM_log_PVT.handle_others( p_module_name => l_module ,
4966: p_stmt_num => l_stmt_num ,
4967: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
4968: p_run_log_level => l_log_level
4969: );
5004: l_null_char VARCHAR2(1) := FND_API.G_NULL_CHAR;
5005:
5006: -- logging variables
5007: l_module VARCHAR2(100) := 'wsm.plsql.WSM_WLT_VALIDATE_PVT.derive_val_res_job_details';
5008: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
5009: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5010: l_stmt_num NUMBER := 0;
5011:
5012: BEGIN
5016: if p_txn_type <> WSMPCNST.BONUS then
5017: -- error out...
5018: if( g_log_level_statement >= l_log_level ) then
5019: l_msg_tokens.delete;
5020: WSM_log_PVT.logMessage(p_module_name => l_module ,
5021: p_msg_text => 'Transaction Type not bonus',
5022: p_stmt_num => l_stmt_num ,
5023: p_msg_tokens => l_msg_tokens ,
5024: p_fnd_msg_level => G_MSG_LVL_ERROR ,
5042: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
5043: l_msg_tokens.delete;
5044: l_msg_tokens(1).TokenName := 'FLD_NAME';
5045: l_msg_tokens(1).TokenValue := 'Job Type';
5046: WSM_log_PVT.logMessage(p_module_name => l_module ,
5047: p_msg_name => 'WSM_INVALID_FIELD' ,
5048: p_msg_appl_name => 'WSM' ,
5049: p_stmt_num => l_stmt_num ,
5050: p_msg_tokens => l_msg_tokens ,
5076:
5077: -- check the wip entity name for existence....
5078: if( g_log_level_statement >= l_log_level ) then
5079: l_msg_tokens.delete;
5080: WSM_log_PVT.logMessage(p_module_name => l_module ,
5081: p_msg_text => 'Checking the wip_entity_name for existence',
5082: p_stmt_num => l_stmt_num,
5083: p_msg_tokens => l_msg_tokens,
5084: p_fnd_log_level => g_log_level_statement,
5093: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
5094: l_msg_tokens.delete;
5095: l_msg_tokens(1).TokenName := 'FLD_NAME';
5096: l_msg_tokens(1).TokenValue := 'wip_entity_name';
5097: WSM_log_PVT.logMessage(p_module_name => l_module ,
5098: p_msg_name => 'WSM_NULL_FIELD',
5099: p_msg_appl_name => 'WSM' ,
5100: p_stmt_num => l_stmt_num ,
5101: p_msg_tokens => l_msg_tokens ,
5117: if l_dummy=1 then
5118: -- error out as duplicate job....
5119: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
5120: l_msg_tokens.delete;
5121: WSM_log_PVT.logMessage(p_module_name=> l_module ,
5122: p_msg_name => 'WSM_DUPLICATE_ENT_NAME',
5123: p_msg_appl_name => 'WSM',
5124: p_msg_tokens => l_msg_tokens ,
5125: p_stmt_num => l_stmt_num ,
5150: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
5151: if( g_log_level_statement >= l_log_level ) then
5152:
5153: l_msg_tokens.delete;
5154: WSM_log_PVT.logMessage(p_module_name => l_module ,
5155: p_msg_text => 'derive_val_primary_item returned failure',
5156: p_stmt_num => l_stmt_num ,
5157: p_msg_tokens => l_msg_tokens ,
5158: p_fnd_msg_level => G_MSG_LVL_ERROR ,
5180: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
5181: l_msg_tokens.delete;
5182: l_msg_tokens(1).TokenName := 'FLD_NAME';
5183: l_msg_tokens(1).TokenValue := 'start_quantity';
5184: WSM_log_PVT.logMessage(p_module_name => l_module ,
5185: p_msg_name => 'WSM_INVALID_FIELD' ,
5186: p_msg_appl_name => 'WSM' ,
5187: p_stmt_num => l_stmt_num ,
5188: p_msg_tokens => l_msg_tokens ,
5205: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
5206: l_msg_tokens.delete;
5207: l_msg_tokens(1).TokenName := 'FLD_NAME';
5208: l_msg_tokens(1).TokenValue := 'Net quantity';
5209: WSM_log_PVT.logMessage(p_module_name => l_module ,
5210: p_msg_name => 'WSM_INVALID_FIELD' ,
5211: p_msg_appl_name => 'WSM' ,
5212: p_stmt_num => l_stmt_num ,
5213: p_msg_tokens => l_msg_tokens ,
5227: then
5228: -- error out..
5229: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
5230: l_msg_tokens.delete;
5231: WSM_log_PVT.logMessage(p_module_name => l_module ,
5232: p_msg_name => 'WSM_INVALID_JOB_TXN_QTY',
5233: p_msg_appl_name => 'WSM' ,
5234: p_stmt_num => l_stmt_num ,
5235: p_msg_tokens => l_msg_tokens ,
5249:
5250: l_msg_tokens.delete;
5251: l_msg_tokens(1).TokenName := 'FLD_NAME';
5252: l_msg_tokens(1).TokenValue := 'Both scheduled_start_date and scheduled_end_date';
5253: WSM_log_PVT.logMessage(p_module_name => l_module ,
5254: p_msg_name => 'WSM_NULL_FIELD',
5255: p_msg_appl_name => 'WSM' ,
5256: p_stmt_num => l_stmt_num ,
5257: p_msg_tokens => l_msg_tokens ,
5289: -- error out.....
5290: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
5291:
5292: l_msg_tokens.delete;
5293: WSM_log_PVT.logMessage(p_module_name=> l_module ,
5294: p_msg_name => 'WSM_INVALID_DATES',
5295: p_msg_appl_name => 'WSM',
5296: p_msg_tokens => l_msg_tokens ,
5297: p_stmt_num => l_stmt_num ,
5335:
5336: l_msg_tokens.delete;
5337: l_msg_tokens(1).TokenName := 'FLD_NAME';
5338: l_msg_tokens(1).TokenValue := 'BONUS_ACCT_ID';
5339: WSM_log_PVT.logMessage(p_module_name=> l_module ,
5340: p_msg_name => 'WSM_INVALID_FIELD' ,
5341: p_msg_appl_name => 'WSM' ,
5342: p_msg_tokens => l_msg_tokens ,
5343: p_stmt_num => l_stmt_num ,
5368: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
5369: if( g_log_level_statement >= l_log_level ) then
5370:
5371: l_msg_tokens.delete;
5372: WSM_log_PVT.logMessage(p_module_name => l_module ,
5373: p_msg_text => 'derive_val_bom_info returned failure',
5374: p_stmt_num => l_stmt_num ,
5375: p_msg_tokens => l_msg_tokens,
5376: p_fnd_msg_level => G_MSG_LVL_ERROR ,
5404: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
5405: if( g_log_level_statement >= l_log_level ) then
5406:
5407: l_msg_tokens.delete;
5408: WSM_log_PVT.logMessage(p_module_name => l_module ,
5409: p_msg_text => 'derive_val_routing_info returned failure',
5410: p_stmt_num => l_stmt_num ,
5411: p_msg_tokens => l_msg_tokens,
5412: p_fnd_msg_level => G_MSG_LVL_ERROR ,
5431: l_msg_tokens.delete;
5432: l_msg_tokens(1).TokenName := 'FLD_NAME';
5433: l_msg_tokens(1).TokenValue := 'intraoperation step for bonus';
5434:
5435: WSM_log_PVT.logMessage(p_module_name=> l_module ,
5436: p_msg_name => 'WSM_INVALID_FIELD' ,
5437: p_msg_appl_name => 'WSM' ,
5438: p_msg_tokens => l_msg_tokens ,
5439: p_stmt_num => l_stmt_num ,
5461: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
5462: if( g_log_level_statement >= l_log_level ) then
5463:
5464: l_msg_tokens.delete;
5465: WSM_log_PVT.logMessage(p_module_name => l_module ,
5466: p_msg_text => 'validate_network returned failure'||l_msg_data,
5467: p_stmt_num => l_stmt_num ,
5468: p_msg_tokens => l_msg_tokens,
5469: p_fnd_msg_level => G_MSG_LVL_ERROR ,
5502: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
5503: if( g_log_level_statement >= l_log_level ) then
5504:
5505: l_msg_tokens.delete;
5506: WSM_log_PVT.logMessage(p_module_name => l_module ,
5507: p_msg_text => 'derive_val_compl_subinv returned failure',
5508: p_stmt_num => l_stmt_num ,
5509: p_msg_tokens => l_msg_tokens,
5510: p_fnd_msg_level => G_MSG_LVL_ERROR ,
5535: l_stmt_num := 120;
5536: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
5537:
5538: l_msg_tokens.delete;
5539: WSM_log_PVT.logMessage(p_module_name=> l_module ,
5540: p_msg_name => 'WSM_INVALID_CLASS_CODE',
5541: p_msg_appl_name => 'WSM',
5542: p_msg_tokens => l_msg_tokens ,
5543: p_stmt_num => l_stmt_num ,
5554: l_stmt_num := 130;
5555: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
5556:
5557: l_msg_tokens.delete;
5558: WSM_log_PVT.logMessage(p_module_name=> l_module ,
5559: p_msg_name => 'WSM_INVALID_CLASS_CODE',
5560: p_msg_appl_name => 'WSM',
5561: p_msg_tokens => l_msg_tokens ,
5562: p_stmt_num => l_stmt_num ,
5594: -- error out ...
5595: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
5596:
5597: l_msg_tokens.delete;
5598: WSM_log_PVT.logMessage(p_module_name=> l_module ,
5599: p_msg_name => 'WSM_NO_WAC_SCRAP_ACC',
5600: p_msg_appl_name => 'WSM',
5601: p_msg_tokens => l_msg_tokens ,
5602: p_stmt_num => l_stmt_num ,
5644: l_stmt_num := 170;
5645: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
5646:
5647: l_msg_tokens.delete;
5648: WSM_log_PVT.logMessage(p_module_name=> l_module ,
5649: p_msg_name => 'WSM_INVALID_CLASS_CODE',
5650: p_msg_appl_name => 'WSM',
5651: p_msg_tokens => l_msg_tokens ,
5652: p_stmt_num => l_stmt_num ,
5667: -- handle ....
5668: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
5669:
5670: l_msg_tokens.delete;
5671: WSM_log_PVT.logMessage(p_module_name=> l_module ,
5672: p_msg_name => 'WSM_INVALID_CLASS_CODE',
5673: p_msg_appl_name => 'WSM',
5674: p_msg_tokens => l_msg_tokens ,
5675: p_stmt_num => l_stmt_num ,
5707:
5708: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
5709: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
5710: THEN
5711: WSM_log_PVT.handle_others( p_module_name => l_module ,
5712: p_stmt_num => l_stmt_num ,
5713: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
5714: p_run_log_level => l_log_level
5715: );
5759: PRAGMA EXCEPTION_INIT(e_invalid_revision,-20001);
5760:
5761: -- logging variables
5762: l_module VARCHAR2(100) := 'wsm.plsql.WSM_WLT_VALIDATE_PVT.derive_val_routing_info';
5763: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
5764: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5765: l_stmt_num NUMBER := 0;
5766: l_param_tbl WSM_Log_PVT.param_tbl_type;
5767:
5762: l_module VARCHAR2(100) := 'wsm.plsql.WSM_WLT_VALIDATE_PVT.derive_val_routing_info';
5763: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
5764: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5765: l_stmt_num NUMBER := 0;
5766: l_param_tbl WSM_Log_PVT.param_tbl_type;
5767:
5768: begin
5769: x_return_status := FND_API.G_RET_STS_SUCCESS;
5770:
5801:
5802: l_param_tbl(9).paramName := 'p_rj_rtg_revision';
5803: l_param_tbl(9).paramValue := p_rj_rtg_revision;
5804:
5805: WSM_Log_PVT.logProcParams(p_module_name => l_module ,
5806: p_param_tbl => l_param_tbl,
5807: p_fnd_log_level => l_log_level
5808: );
5809: END IF;
5816: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
5817: l_msg_tokens.delete;
5818: l_msg_tokens(1).TokenName := 'FLD_NAME';
5819: l_msg_tokens(1).TokenValue := 'For NSJ,Both rtg_reference_id and rtg_reference_item ';
5820: WSM_log_PVT.logMessage(p_module_name => l_module ,
5821: p_msg_name => 'WSM_NULL_FIELD',
5822: p_msg_appl_name => 'WSM' ,
5823: p_msg_tokens => l_msg_tokens ,
5824: p_fnd_msg_level => G_MSG_LVL_ERROR ,
5830: else
5831: -- cross validate......
5832: if( g_log_level_statement >= l_log_level ) then
5833: l_msg_tokens.delete;
5834: WSM_log_PVT.logMessage(p_module_name => l_module ,
5835: p_msg_text => 'Cross validate routing_info',
5836: p_stmt_num => l_stmt_num ,
5837: p_msg_tokens => l_msg_tokens,
5838: p_fnd_log_level => g_log_level_statement,
5864:
5865: l_msg_tokens.delete;
5866: l_msg_tokens(1).TokenName := 'FLD_NAME';
5867: l_msg_tokens(1).TokenValue := 'value for rotuing reference item/routing reference id';
5868: WSM_log_PVT.logMessage(p_module_name => l_module ,
5869: p_msg_name => 'WSM_INVALID_FIELD',
5870: p_msg_appl_name => 'WSM' ,
5871: p_msg_tokens => l_msg_tokens ,
5872: p_stmt_num => l_stmt_num ,
5904: IF l_row_exists = 0 THEN
5905: -- error out as no network routing exists...
5906: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
5907:
5908: WSM_log_PVT.logMessage(p_module_name => l_module ,
5909: p_msg_name => 'WSM_NO_WSM_ROUTING' ,
5910: p_msg_appl_name => 'WSM' ,
5911: p_msg_tokens => l_msg_tokens ,
5912: p_stmt_num => l_stmt_num ,
5926: IF p_rj_rtg_revision IS NULL THEN
5927: -- yes..... assign rtg_revision_date to job start date or sysdate
5928: if( g_log_level_statement >= l_log_level ) then
5929: l_msg_tokens.delete;
5930: WSM_log_PVT.logMessage(p_module_name => l_module ,
5931: p_msg_text => 'assign rtg_revision_date to job start date or sysdate',
5932: p_stmt_num => l_stmt_num ,
5933: p_msg_tokens => l_msg_tokens,
5934: p_fnd_log_level => g_log_level_statement,
5957: );
5958:
5959: IF( g_log_level_statement >= l_log_level ) THEN
5960: l_msg_tokens.delete;
5961: WSM_log_PVT.logMessage(p_module_name => l_module ,
5962: p_msg_text => 'return from wip_revisions.routing_revision',
5963: p_stmt_num => l_stmt_num ,
5964: p_msg_tokens => l_msg_tokens,
5965: p_fnd_log_level => g_log_level_statement,
6012:
6013: l_msg_tokens.delete;
6014: l_msg_tokens(1).TokenName := 'FLD_NAME';
6015: l_msg_tokens(1).TokenValue := 'value for rotuing revision/routing revision date';
6016: WSM_log_PVT.logMessage(p_module_name => l_module ,
6017: p_msg_name => 'WSM_INVALID_FIELD' ,
6018: p_msg_appl_name => 'WSM' ,
6019: p_msg_tokens => l_msg_tokens ,
6020: p_stmt_num => l_stmt_num ,
6046: if l_return_status <> fnd_api.g_ret_sts_success then
6047: -- error our...........
6048: if( g_log_level_statement >= l_log_level ) then
6049: l_msg_tokens.delete;
6050: WSM_log_PVT.logMessage(p_module_name => l_module ,
6051: p_msg_text => 'Procedure routing_seq returned failure',
6052: p_stmt_num => l_stmt_num ,
6053: p_msg_tokens => l_msg_tokens,
6054: p_fnd_msg_level => G_MSG_LVL_ERROR ,
6086:
6087: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
6088: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
6089: THEN
6090: WSM_log_PVT.handle_others( p_module_name => l_module ,
6091: p_stmt_num => l_stmt_num ,
6092: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
6093: p_run_log_level => l_log_level
6094: );
6137: PRAGMA EXCEPTION_INIT(e_invalid_revision,-20001);
6138:
6139: -- logging variables
6140: l_module VARCHAR2(100) := 'wsm.plsql.WSM_WLT_VALIDATE_PVT.derive_val_bom_info';
6141: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
6142: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6143: l_stmt_num NUMBER := 0;
6144: l_param_tbl WSM_Log_PVT.param_tbl_type;
6145:
6140: l_module VARCHAR2(100) := 'wsm.plsql.WSM_WLT_VALIDATE_PVT.derive_val_bom_info';
6141: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
6142: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6143: l_stmt_num NUMBER := 0;
6144: l_param_tbl WSM_Log_PVT.param_tbl_type;
6145:
6146: begin
6147: x_return_status := FND_API.G_RET_STS_SUCCESS;
6148: l_stmt_num := 10;
6178:
6179: l_param_tbl(9).paramName := 'p_rj_bom_revision';
6180: l_param_tbl(9).paramValue := p_rj_bom_revision;
6181:
6182: WSM_Log_PVT.logProcParams(p_module_name => l_module ,
6183: p_param_tbl => l_param_tbl,
6184: p_fnd_log_level => l_log_level
6185: );
6186: END IF;
6222:
6223: l_msg_tokens.delete;
6224: l_msg_tokens(1).TokenName := 'FLD_NAME';
6225: l_msg_tokens(1).TokenValue := 'BOM_REFERENCE_ID in resulting jobs';
6226: WSM_log_PVT.logMessage(p_module_name => l_module ,
6227: p_msg_name => 'WSM_NULL_FIELD',
6228: p_msg_appl_name => 'WSM' ,
6229: p_msg_tokens => l_msg_tokens ,
6230: p_stmt_num => l_stmt_num ,
6259:
6260: l_msg_tokens.delete;
6261: l_msg_tokens(1).TokenName := 'FLD_NAME';
6262: l_msg_tokens(1).TokenValue := 'BOM REFERENCE ITEM/BOM REFERENCE ID in resulting jobs';
6263: WSM_log_PVT.logMessage(p_module_name => l_module ,
6264: p_msg_name => 'WSM_INVALID_FIELD',
6265: p_msg_appl_name => 'WSM' ,
6266: p_msg_tokens => l_msg_tokens ,
6267: p_stmt_num => l_stmt_num ,
6348:
6349: l_msg_tokens.delete;
6350: l_msg_tokens(1).TokenName := 'FLD_NAME';
6351: l_msg_tokens(1).TokenValue := 'value for bom_revision';
6352: WSM_log_PVT.logMessage(p_module_name => l_module ,
6353: p_msg_name => 'WSM_INVALID_FIELD',
6354: p_msg_appl_name => 'WSM' ,
6355: p_msg_tokens => l_msg_tokens ,
6356: p_stmt_num => l_stmt_num ,
6382:
6383: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
6384: if( g_log_level_statement >= l_log_level ) then
6385: l_msg_tokens.delete;
6386: WSM_log_PVT.logMessage(p_module_name => l_module ,
6387: p_msg_text => 'Procedure bom_seq returned failure',
6388: p_stmt_num => l_stmt_num ,
6389: p_msg_tokens => l_msg_tokens,
6390: p_fnd_msg_level => G_MSG_LVL_ERROR ,
6421:
6422: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
6423: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
6424: THEN
6425: WSM_log_PVT.handle_others( p_module_name => l_module ,
6426: p_stmt_num => l_stmt_num ,
6427: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
6428: p_run_log_level => l_log_level
6429: );
6465: l_rtg_item_id NUMBER;
6466:
6467: --- logging variables
6468: l_module VARCHAR2(100) := 'wsm.plsql.WSM_WLT_VALIDATE_PVT.derive_val_compl_subinv';
6469: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
6470: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6471: l_stmt_num NUMBER := 0;
6472: l_param_tbl WSM_Log_PVT.param_tbl_type;
6473:
6468: l_module VARCHAR2(100) := 'wsm.plsql.WSM_WLT_VALIDATE_PVT.derive_val_compl_subinv';
6469: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
6470: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6471: l_stmt_num NUMBER := 0;
6472: l_param_tbl WSM_Log_PVT.param_tbl_type;
6473:
6474: begin
6475: x_return_status := FND_API.G_RET_STS_SUCCESS;
6476: l_stmt_num := 10;
6515:
6516: l_param_tbl(12).paramName := 'p_rj_rtg_reference_item_id';
6517: l_param_tbl(12).paramValue := p_rj_rtg_reference_item_id;
6518:
6519: WSM_Log_PVT.logProcParams(p_module_name => l_module ,
6520: p_param_tbl => l_param_tbl,
6521: p_fnd_log_level => l_log_level
6522: );
6523: END IF;
6558:
6559: l_msg_tokens.delete;
6560: l_msg_tokens(1).TokenName := 'FLD_NAME';
6561: l_msg_tokens(1).TokenValue := 'value for completion subinventory';
6562: WSM_log_PVT.logMessage(p_module_name => l_module ,
6563: p_msg_name => 'WSM_INVALID_FIELD',
6564: p_msg_appl_name => 'WSM' ,
6565: p_msg_tokens => l_msg_tokens ,
6566: p_stmt_num => l_stmt_num ,
6593:
6594: l_msg_tokens.delete;
6595: l_msg_tokens(1).TokenName := 'FLD_NAME';
6596: l_msg_tokens(1).TokenValue := 'or no matching value for completion subinventory';
6597: WSM_log_PVT.logMessage(p_module_name => l_module ,
6598: p_msg_name => 'WSM_INVALID_FIELD',
6599: p_msg_appl_name => 'WSM' ,
6600: p_msg_tokens => l_msg_tokens ,
6601: p_stmt_num => l_stmt_num ,
6632:
6633: l_msg_tokens.delete;
6634: l_msg_tokens(1).TokenName := 'FLD_NAME';
6635: l_msg_tokens(1).TokenValue := 'Completion locator id.';
6636: WSM_log_PVT.logMessage(p_module_name => l_module ,
6637: p_msg_name => 'WSM_INVALID_FIELD',
6638: p_msg_appl_name => 'WSM' ,
6639: p_msg_tokens => l_msg_tokens ,
6640: p_stmt_num => l_stmt_num ,
6677: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
6678: l_msg_tokens.delete;
6679: l_msg_tokens(1).TokenName := 'FLD_NAME';
6680: l_msg_tokens(1).TokenValue := 'Completion locator.';
6681: WSM_log_PVT.logMessage(p_module_name => l_module ,
6682: p_msg_name => 'WSM_INVALID_FIELD',
6683: p_msg_appl_name => 'WSM' ,
6684: p_msg_tokens => l_msg_tokens ,
6685: p_stmt_num => l_stmt_num ,
6714: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
6715: l_msg_tokens.delete;
6716: l_msg_tokens(1).TokenName := 'FLD_NAME';
6717: l_msg_tokens(1).TokenValue := 'COMPLETION_LOCATOR_ID';
6718: WSM_log_PVT.logMessage(p_module_name => l_module ,
6719: p_msg_name => 'WSM_INVALID_FIELD',
6720: p_msg_appl_name => 'WSM' ,
6721: p_msg_tokens => l_msg_tokens ,
6722: p_stmt_num => l_stmt_num ,
6755:
6756: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
6757: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
6758: THEN
6759: WSM_log_PVT.handle_others( p_module_name => l_module ,
6760: p_stmt_num => l_stmt_num ,
6761: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
6762: p_run_log_level => l_log_level
6763: );
6796: l_op_rptd_times number;
6797:
6798: -- logging variables
6799: l_stmt_num number:=0;
6800: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
6801: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6802: l_module VARCHAR2(100) := 'wsm.plsql.WSM_WLT_VALIDATE_PVT.derive_val_starting_op';
6803:
6804: begin
6806: -- currently not supported for option 'a' : assumption it is not supported
6807: l_stmt_num :=10;
6808: if( g_log_level_statement >= l_log_level ) then
6809: l_msg_tokens.delete;
6810: WSM_log_PVT.logMessage(p_module_name => l_module ,
6811: p_msg_text => 'Entered derive_val_starting_op' ,
6812: p_stmt_num => l_stmt_num ,
6813: p_msg_tokens => l_msg_tokens,
6814: p_fnd_log_level => g_log_level_statement,
6819: if p_new_op_seq_num is null and p_new_op_seq_id is null then
6820:
6821: if( g_log_level_statement >= l_log_level ) then
6822: l_msg_tokens.delete;
6823: WSM_log_PVT.logMessage(p_module_name => l_module ,
6824: p_msg_text => 'p_new_op_seq_num and p_new_op_seq_id is null',
6825: p_stmt_num => l_stmt_num ,
6826: p_msg_tokens => l_msg_tokens,
6827: p_fnd_log_level => g_log_level_statement,
6833: l_stmt_num :=20;
6834:
6835: if( g_log_level_statement >= l_log_level ) then
6836: l_msg_tokens.delete;
6837: WSM_log_PVT.logMessage(p_module_name => l_module ,
6838: p_msg_text => 'Calling WSMPUTIL.operation_is_standard_repeats',
6839: p_stmt_num => l_stmt_num ,
6840: p_msg_tokens => l_msg_tokens,
6841: p_fnd_log_level => g_log_level_statement,
6860: -- error out....
6861: if( g_log_level_statement >= l_log_level ) then
6862:
6863: l_msg_tokens.delete;
6864: WSM_log_PVT.logMessage(p_module_name => l_module ,
6865: p_msg_text => 'WSMPUTIL.operation_is_standard_repeats returned failure',
6866: p_stmt_num => l_stmt_num ,
6867: p_msg_tokens => l_msg_tokens,
6868: p_fnd_msg_level => G_MSG_LVL_ERROR ,
6876: if l_op_rptd_times = 1 then -- Found a match
6877: l_stmt_num :=30;
6878: if( g_log_level_statement >= l_log_level ) then
6879: l_msg_tokens.delete;
6880: WSM_log_PVT.logMessage(p_module_name => l_module ,
6881: p_msg_text => 'Found match in resulting routing',
6882: p_stmt_num => l_stmt_num ,
6883: p_msg_tokens => l_msg_tokens,
6884: p_fnd_log_level => g_log_level_statement,
6916:
6917: l_msg_tokens.delete;
6918: l_msg_tokens(1).TokenName := 'FLD_NAME';
6919: l_msg_tokens(1).TokenValue := 'value for operation code';
6920: WSM_log_PVT.logMessage(p_module_name => l_module ,
6921: p_msg_name => 'WSM_INVALID_FIELD',
6922: p_msg_appl_name => 'WSM' ,
6923: p_msg_tokens => l_msg_tokens ,
6924: p_stmt_num => l_stmt_num ,
6936:
6937: l_msg_tokens.delete;
6938: l_msg_tokens(1).TokenName := 'FLD_NAME';
6939: l_msg_tokens(1).TokenValue := 'Starting operation information';
6940: WSM_log_PVT.logMessage(p_module_name => l_module ,
6941: p_msg_name => 'WSM_INVALID_FIELD',
6942: p_msg_appl_name => 'WSM' ,
6943: p_msg_tokens => l_msg_tokens ,
6944: p_stmt_num => l_stmt_num ,
6955: -- have to error out... repeated in the target ....
6956: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6957:
6958: l_msg_tokens.delete;
6959: WSM_log_PVT.logMessage(p_module_name=> l_module ,
6960: p_msg_name => 'WSM_JOB_AT_REPEATED_OP',
6961: p_msg_appl_name => 'WSM',
6962: p_msg_tokens => l_msg_tokens ,
6963: p_stmt_num => l_stmt_num ,
6972: -- no match found....
6973: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6974:
6975: l_msg_tokens.delete;
6976: WSM_log_PVT.logMessage(p_module_name=> l_module ,
6977: p_msg_name => 'WSM_NO_CURRENT_STDOP_TGTRTG',
6978: p_msg_appl_name => 'WSM',
6979: p_msg_tokens => l_msg_tokens ,
6980: p_stmt_num => l_stmt_num ,
6991: -- error out as for ToMove have to provide the starting op...
6992: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6993:
6994: l_msg_tokens.delete;
6995: WSM_log_PVT.logMessage(p_module_name=> l_module ,
6996: p_msg_name => 'WSM_START_OP_REQD',
6997: p_msg_appl_name => 'WSM',
6998: p_msg_tokens => l_msg_tokens ,
6999: p_stmt_num => l_stmt_num ,
7008: -- logic .....
7009: l_stmt_num :=70;
7010: if( g_log_level_statement >= l_log_level ) then
7011: l_msg_tokens.delete;
7012: WSM_log_PVT.logMessage(p_module_name => l_module ,
7013: p_msg_text => 'p_new_op_seq_num and p_new_op_seq_id is not null',
7014: p_stmt_num => l_stmt_num ,
7015: p_msg_tokens => l_msg_tokens,
7016: p_fnd_log_level => g_log_level_statement,
7024: l_stmt_num :=80;
7025:
7026: if( g_log_level_statement >= l_log_level ) then
7027: l_msg_tokens.delete;
7028: WSM_log_PVT.logMessage(p_module_name => l_module ,
7029: p_msg_text => 'p_new_std_op_id and p_new_op_seq_code is null',
7030: p_stmt_num => l_stmt_num ,
7031: p_msg_tokens => l_msg_tokens,
7032: p_fnd_log_level => g_log_level_statement,
7061: l_stmt_num :=90;
7062:
7063: if( g_log_level_statement >= l_log_level ) then
7064: l_msg_tokens.delete;
7065: WSM_log_PVT.logMessage(p_module_name => l_module ,
7066: p_msg_text => 'p_new_std_op_id and p_new_op_seq_code is not null',
7067: p_stmt_num => l_stmt_num ,
7068: p_msg_tokens => l_msg_tokens,
7069: p_fnd_log_level => g_log_level_statement,
7104:
7105: l_msg_tokens.delete;
7106: l_msg_tokens(1).TokenName := 'FLD_NAME';
7107: l_msg_tokens(1).TokenValue := 'start operation information';
7108: WSM_log_PVT.logMessage(p_module_name => l_module ,
7109: p_msg_name => 'WSM_INVALID_FIELD',
7110: p_msg_appl_name => 'WSM' ,
7111: p_msg_tokens => l_msg_tokens ,
7112: p_stmt_num => l_stmt_num ,
7128: x_err_msg => l_err_msg)
7129: THEN
7130: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
7131: l_msg_tokens.delete;
7132: WSM_log_PVT.logMessage(p_module_name => l_module ,
7133: p_msg_name => 'WSM_OP_PO_MOVE',
7134: p_msg_appl_name => 'WSM' ,
7135: p_msg_tokens => l_msg_tokens ,
7136: p_stmt_num => l_stmt_num ,
7143: END IF;
7144:
7145: if( g_log_level_statement >= l_log_level ) then
7146: l_msg_tokens.delete;
7147: WSM_log_PVT.logMessage(p_module_name => l_module ,
7148: p_msg_text => 'End of derive_val_starting_op',
7149: p_stmt_num => l_stmt_num ,
7150: p_msg_tokens => l_msg_tokens,
7151: p_fnd_log_level => g_log_level_statement,
7179:
7180: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
7181: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
7182: THEN
7183: WSM_log_PVT.handle_others( p_module_name => l_module ,
7184: p_stmt_num => l_stmt_num ,
7185: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
7186: p_run_log_level => l_log_level
7187: );
7206: l_serial_number_control_code NUMBER;
7207:
7208: -- logging variables
7209: l_stmt_num number:=0;
7210: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
7211: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
7212: l_module VARCHAR2(100) := 'wsm.plsql.WSM_WLT_VALIDATE_PVT.derive_val_primary_item';
7213:
7214: begin
7220: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
7221: l_msg_tokens.delete;
7222: l_msg_tokens(1).TokenName := 'FLD_NAME';
7223: l_msg_tokens(1).TokenValue := 'p_new_item_name and p_new_item_id ';
7224: WSM_log_PVT.logMessage(p_module_name => l_module ,
7225: p_msg_name => 'WSM_NULL_FIELD',
7226: p_msg_appl_name => 'WSM' ,
7227: p_msg_tokens => l_msg_tokens ,
7228: p_stmt_num => l_stmt_num ,
7264:
7265: l_msg_tokens.delete;
7266: l_msg_tokens(1).TokenName := 'FLD_NAME';
7267: l_msg_tokens(1).TokenValue := 'value for item name / item_id specified ';
7268: WSM_log_PVT.logMessage(p_module_name => l_module ,
7269: p_msg_name => 'WSM_INVALID_FIELD',
7270: p_msg_appl_name => 'WSM' ,
7271: p_msg_tokens => l_msg_tokens ,
7272: p_stmt_num => l_stmt_num ,
7285:
7286: l_msg_tokens.delete;
7287: l_msg_tokens(1).TokenName := 'FLD_NAME';
7288: l_msg_tokens(1).TokenValue := 'Assembly cannot be same';
7289: WSM_log_PVT.logMessage(p_module_name => l_module ,
7290: p_msg_name => 'WSM_INVALID_FIELD',
7291: p_msg_appl_name => 'WSM' ,
7292: p_msg_tokens => l_msg_tokens ,
7293: p_stmt_num => l_stmt_num ,
7305:
7306: l_msg_tokens.delete;
7307: l_msg_tokens(1).TokenName := 'FLD_NAME';
7308: l_msg_tokens(1).TokenValue := 'value for lot_control_code/serial_control_code';
7309: WSM_log_PVT.logMessage(p_module_name => l_module ,
7310: p_msg_name => 'WSM_INVALID_FIELD',
7311: p_msg_appl_name => 'WSM' ,
7312: p_msg_tokens => l_msg_tokens ,
7313: p_stmt_num => l_stmt_num ,
7346:
7347: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
7348: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
7349: THEN
7350: WSM_log_PVT.handle_others( p_module_name => l_module ,
7351: p_stmt_num => l_stmt_num ,
7352: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
7353: p_run_log_level => l_log_level
7354: );
7376: l_msg_data VARCHAR2(2000);
7377:
7378: -- local variable for logging purpose
7379: l_stmt_num NUMBER := 0;
7380: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
7381: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
7382: l_module VARCHAR2(100) := 'wsm.plsql.WSM_WLT_VALIDATE_PVT.insert_txn_data';
7383:
7384: -- Loop Variable --
7399:
7400: -- Log the Procedure entry point....
7401: if( g_log_level_statement >= l_log_level ) then
7402: l_msg_tokens.delete;
7403: WSM_log_PVT.logMessage(p_module_name => l_module ,
7404: p_msg_text => 'Entering the Insert Txn Data procedure to insert into the base tables',
7405: p_stmt_num => l_stmt_num ,
7406: p_msg_tokens => l_msg_tokens,
7407: p_fnd_log_level => g_log_level_statement,
7495: );
7496:
7497: if( g_log_level_statement >= l_log_level ) then
7498: l_msg_tokens.delete;
7499: WSM_log_PVT.logMessage(p_module_name => l_module ,
7500: p_msg_text => 'Inserted Txn Header Data into the wsm_split_merge_transactions',
7501: p_stmt_num => l_stmt_num ,
7502: p_msg_tokens => l_msg_tokens,
7503: p_fnd_log_level => g_log_level_statement,
7626: l_counter := p_wltx_starting_jobs_tbl.next(l_counter);
7627: end loop;
7628: if( g_log_level_statement >= l_log_level ) then
7629: l_msg_tokens.delete;
7630: WSM_log_PVT.logMessage(p_module_name => l_module ,
7631: p_msg_text => 'Inserted '||SQL%ROWCOUNT||' records with transaction id:'|| p_wltx_header.transaction_id ,
7632: p_stmt_num => l_stmt_num,
7633: p_msg_tokens => l_msg_tokens,
7634: p_fnd_log_level => g_log_level_statement,
7773: END LOOP;
7774:
7775: if( g_log_level_statement >= l_log_level ) then
7776: l_msg_tokens.delete;
7777: WSM_log_PVT.logMessage(p_module_name => l_module ,
7778: p_msg_text => 'Inserted '||SQL%ROWCOUNT||'records with transaction id:'|| p_wltx_header.transaction_id ,
7779: p_stmt_num => l_stmt_num ,
7780: p_msg_tokens => l_msg_tokens,
7781: p_fnd_log_level => g_log_level_statement,
7807:
7808: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
7809: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
7810: THEN
7811: WSM_log_PVT.handle_others( p_module_name => l_module ,
7812: p_stmt_num => l_stmt_num ,
7813: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
7814: p_run_log_level => l_log_level
7815: );
7845: l_flag number;
7846: l_primary number;
7847:
7848: -- Logging variables.....
7849: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
7850: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
7851:
7852: l_stmt_num NUMBER;
7853: l_module VARCHAR2(100) :='wsm.plsql.WSM_WLT_VALIDATE_PVT.validate_network';
7866: if l_err_code <> 0 then
7867: if( g_log_level_statement >= l_log_level ) then
7868:
7869: l_msg_tokens.delete;
7870: WSM_log_PVT.logMessage(p_module_name => l_module ,
7871: p_msg_text => 'WSMPUTIL.find_routing_start returned failure:'||l_err_msg,
7872: p_stmt_num => l_stmt_num ,
7873: p_msg_tokens => l_msg_tokens,
7874: p_fnd_msg_level => G_MSG_LVL_ERROR ,
7895: if l_err_code <> 0 then
7896: if( g_log_level_statement >= l_log_level ) then
7897:
7898: l_msg_tokens.delete;
7899: WSM_log_PVT.logMessage(p_module_name => l_module ,
7900: p_msg_text => 'WSMPUTIL.find_routing_end returned failure:'||l_err_msg,
7901: p_stmt_num => l_stmt_num ,
7902: p_msg_tokens => l_msg_tokens,
7903: p_fnd_msg_level => G_MSG_LVL_ERROR ,
7928: l_stmt_num := 40;
7929:
7930: if( g_log_level_statement >= l_log_level ) then
7931: l_msg_tokens.delete;
7932: WSM_log_PVT.logMessage(p_module_name => l_module ,
7933: p_msg_text => 'Start Op Seq Num : ' || p_start_op_seq_num ||
7934: ' Routing seq Id : ' || p_rtg_seq_id ||
7935: ' p_start_op_seq_id : ' || p_start_op_seq_id ||
7936: ' p_start_op_seq_code : ' || p_start_op_seq_code ||
7959: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
7960: l_msg_tokens.delete;
7961: l_msg_tokens(1).TokenName := 'FLD_NAME';
7962: l_msg_tokens(1).TokenValue := 'starting_operation';
7963: WSM_log_PVT.logMessage(p_module_name => l_module ,
7964: p_msg_name => 'WSM_INVALID_FIELD',
7965: p_msg_appl_name => 'WSM' ,
7966: p_msg_tokens => l_msg_tokens ,
7967: p_stmt_num => l_stmt_num ,
8020: -- not on the primary path....
8021: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
8022:
8023: l_msg_tokens.delete;
8024: WSM_log_PVT.logMessage(p_module_name=> l_module ,
8025: p_msg_name => 'WSM_OPRN_NOT_PRIMARY',
8026: p_msg_appl_name => 'WSM',
8027: p_msg_tokens => l_msg_tokens ,
8028: p_stmt_num => l_stmt_num ,
8048: -- Disabled primary path.............
8049: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
8050:
8051: l_msg_tokens.delete;
8052: WSM_log_PVT.logMessage(p_module_name=> l_module ,
8053: p_msg_name => 'WSM_PRIMARY_PATH_DISABLED',
8054: p_msg_appl_name => 'WSM',
8055: p_msg_tokens => l_msg_tokens ,
8056: p_stmt_num => l_stmt_num ,
8085:
8086: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
8087: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
8088: THEN
8089: WSM_log_PVT.handle_others( p_module_name => l_module ,
8090: p_stmt_num => l_stmt_num ,
8091: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
8092: p_run_log_level => l_log_level
8093: );