[Home] [Help]
4: -- Package name
5: g_pkg_name VARCHAR2(20) := 'WSM_WLT_VALIDATE_PVT';
6:
7: --logging variables
8: g_log_level_unexpected NUMBER := FND_LOG.LEVEL_UNEXPECTED ;
9: g_log_level_error number := FND_LOG.LEVEL_ERROR ;
10: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;
11: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
12: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;
5: g_pkg_name VARCHAR2(20) := 'WSM_WLT_VALIDATE_PVT';
6:
7: --logging variables
8: g_log_level_unexpected NUMBER := FND_LOG.LEVEL_UNEXPECTED ;
9: g_log_level_error number := FND_LOG.LEVEL_ERROR ;
10: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;
11: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
12: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;
13: g_log_level_statement number := FND_LOG.LEVEL_STATEMENT ;
6:
7: --logging variables
8: g_log_level_unexpected NUMBER := FND_LOG.LEVEL_UNEXPECTED ;
9: g_log_level_error number := FND_LOG.LEVEL_ERROR ;
10: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;
11: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
12: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;
13: g_log_level_statement number := FND_LOG.LEVEL_STATEMENT ;
14:
7: --logging variables
8: g_log_level_unexpected NUMBER := FND_LOG.LEVEL_UNEXPECTED ;
9: g_log_level_error number := FND_LOG.LEVEL_ERROR ;
10: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;
11: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
12: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;
13: g_log_level_statement number := FND_LOG.LEVEL_STATEMENT ;
14:
15: g_msg_lvl_unexp_error NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ;
8: g_log_level_unexpected NUMBER := FND_LOG.LEVEL_UNEXPECTED ;
9: g_log_level_error number := FND_LOG.LEVEL_ERROR ;
10: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;
11: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
12: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;
13: g_log_level_statement number := FND_LOG.LEVEL_STATEMENT ;
14:
15: g_msg_lvl_unexp_error NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ;
16: g_msg_lvl_error NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR ;
9: g_log_level_error number := FND_LOG.LEVEL_ERROR ;
10: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;
11: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
12: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;
13: g_log_level_statement number := FND_LOG.LEVEL_STATEMENT ;
14:
15: g_msg_lvl_unexp_error NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ;
16: g_msg_lvl_error NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR ;
17: g_msg_lvl_success NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS ;
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';
53: l_param_tbl WSM_Log_PVT.param_tbl_type;
59: x_error_msg := NULL;
60: x_error_count := 0;
61:
62: l_stmt_num := 10;
63: IF FND_LOG.LEVEL_PROCEDURE >= l_log_level THEN
64:
65: l_stmt_num := 15;
66: l_param_tbl.delete;
67:
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;
95:
96: if(p_job_type = 1) then -- std job
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 ,
112: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
113: p_run_log_level => l_log_level
114: );
115: END IF;
116: RAISE FND_API.G_EXC_ERROR;
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 ,
159: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
160: p_run_log_level => l_log_level
161: );
162: END IF;
163: RAISE FND_API.G_EXC_ERROR;
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 ,
216: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
217: p_run_log_level => l_log_level
218: );
219: END IF;
220: RAISE FND_API.G_EXC_ERROR;
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: );
244: END IF;
245: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
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';
277: l_param_tbl WSM_Log_PVT.param_tbl_type;
282: x_error_msg := NULL;
283: x_error_count := 0;
284:
285: l_stmt_num := 10;
286: IF FND_LOG.LEVEL_PROCEDURE >= l_log_level THEN
287:
288: l_stmt_num := 15;
289: l_param_tbl.delete;
290:
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;
317:
318: l_stmt_num := 20;
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 ,
348: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
349: p_run_log_level => l_log_level
350: );
351: END IF;
352: RAISE FND_API.G_EXC_ERROR;
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 ,
393: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
394: p_run_log_level => l_log_level
395: );
396: END IF;
397: RAISE FND_API.G_EXC_ERROR;
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 ,
434: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
435: p_run_log_level => l_log_level
436: );
437: END IF;
438: RAISE FND_API.G_EXC_ERROR;
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 ,
467: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
468: p_run_log_level => l_log_level
469: );
470: END IF;
471: RAISE FND_API.G_EXC_ERROR;
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 ,
498: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
499: p_run_log_level => l_log_level
500: );
501: END IF;
502: RAISE FND_API.G_EXC_ERROR;
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 ,
524: p_run_log_level => l_log_level
525: );
526: END IF;
527:
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: );
547: END IF;
548: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
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';
583: l_param_tbl WSM_Log_PVT.param_tbl_type;
589: x_error_count := 0;
590:
591: l_stmt_num := 10;
592:
593: IF FND_LOG.LEVEL_PROCEDURE >= l_log_level THEN
594: l_stmt_num := 15;
595:
596: l_param_tbl.delete;
597: l_param_tbl(1).paramName := 'p_org_id';
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;
614:
615: l_stmt_num := 20;
623: p_msg_appl_name => 'WSM',
624: p_msg_tokens => l_msg_tokens ,
625: p_stmt_num => l_stmt_num ,
626: p_fnd_msg_level => G_MSG_LVL_ERROR ,
627: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
628: p_run_log_level => l_log_level
629: );
630: END IF;
631: RAISE FND_API.G_EXC_ERROR;
659: p_msg_appl_name => 'WIP',
660: p_msg_tokens => l_msg_tokens ,
661: p_stmt_num => l_stmt_num ,
662: p_fnd_msg_level => G_MSG_LVL_ERROR ,
663: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
664: p_run_log_level => l_log_level
665: );
666: END IF;
667: RAISE FND_API.G_EXC_ERROR;
678: p_msg_appl_name => 'WIP',
679: p_msg_tokens => l_msg_tokens ,
680: p_stmt_num => l_stmt_num ,
681: p_fnd_msg_level => G_MSG_LVL_ERROR ,
682: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
683: p_run_log_level => l_log_level
684: );
685: END IF;
686: RAISE FND_API.G_EXC_ERROR;
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 ,
697: p_run_log_level => l_log_level
698: );
699: END IF;
700:
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: );
720: END IF;
721: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
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
756:
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,
771: p_run_log_level => l_log_level
772: );
773: End if;
774:
789: p_msg_appl_name => 'WSM' ,
790: p_stmt_num => l_stmt_num ,
791: p_msg_tokens => l_msg_tokens ,
792: p_fnd_msg_level => G_MSG_LVL_ERROR ,
793: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
794: p_run_log_level => l_log_level
795: );
796: END IF;
797: RAISE FND_API.G_EXC_ERROR;
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,
820: p_run_log_level => l_log_level
821: );
822: End if;
823: ELSE -- p_wltx_header.organization_code is not NULL
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,
843: p_run_log_level => l_log_level
844: );
845: END IF;
846: END IF;
860: p_msg_appl_name => 'WSM' ,
861: p_msg_tokens => l_msg_tokens ,
862: p_stmt_num => l_stmt_num ,
863: p_fnd_msg_level => G_MSG_LVL_ERROR ,
864: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
865: p_run_log_level => l_log_level
866: );
867: END IF;
868: RAISE FND_API.G_EXC_ERROR;
884: p_msg_appl_name => 'WSM' ,
885: p_msg_tokens => l_msg_tokens ,
886: p_stmt_num => l_stmt_num ,
887: p_fnd_msg_level => G_MSG_LVL_ERROR ,
888: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
889: p_run_log_level => l_log_level
890: );
891: END IF;
892: RAISE FND_API.G_EXC_ERROR;
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,
912: p_run_log_level => l_log_level
913: );
914: END IF;
915: END IF;
925: p_msg_appl_name => 'WSM' ,
926: p_msg_tokens => l_msg_tokens ,
927: p_stmt_num => l_stmt_num ,
928: p_fnd_msg_level => G_MSG_LVL_ERROR ,
929: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
930: p_run_log_level => l_log_level
931: );
932: END IF;
933: RAISE FND_API.G_EXC_ERROR;
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,
948: p_run_log_level => l_log_level
949: );
950: End if;
951:
960: p_msg_appl_name => 'WSM' ,
961: p_msg_tokens => l_msg_tokens ,
962: p_stmt_num => l_stmt_num ,
963: p_fnd_msg_level => G_MSG_LVL_ERROR ,
964: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
965: p_run_log_level => l_log_level
966: );
967: END IF;
968: RAISE FND_API.G_EXC_ERROR;
989: p_msg_appl_name => 'WSM' ,
990: p_msg_tokens => l_msg_tokens ,
991: p_stmt_num => l_stmt_num ,
992: p_fnd_msg_level => G_MSG_LVL_ERROR ,
993: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
994: p_run_log_level => l_log_level
995: );
996: END IF;
997: RAISE FND_API.G_EXC_ERROR;
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,
1025: p_run_log_level => l_log_level
1026: );
1027: End if;
1028:
1033: p_msg_appl_name => 'WSM',
1034: p_msg_tokens => l_msg_tokens ,
1035: p_stmt_num => l_stmt_num ,
1036: p_fnd_msg_level => G_MSG_LVL_ERROR ,
1037: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
1038: p_run_log_level => l_log_level
1039: );
1040: END IF;
1041: raise FND_API.G_EXC_ERROR;
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 ,
1052: p_run_log_level => l_log_level
1053: );
1054: END IF;
1055:
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: );
1086: END IF;
1087:
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:
1116: BEGIN
1123:
1124: -- Initialize API return status to success
1125: x_return_status := FND_API.G_RET_STS_SUCCESS;
1126:
1127: IF FND_LOG.LEVEL_PROCEDURE >= l_log_level THEN
1128: l_param_tbl.delete;
1129:
1130: l_param_tbl(1).paramName := 'p_txn_date';
1131: l_param_tbl(1).paramValue := p_txn_date;
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;
1144:
1145: l_stmt_num := 20;
1154: p_msg_appl_name => 'WSM' ,
1155: p_msg_tokens => l_msg_tokens ,
1156: p_stmt_num => l_stmt_num ,
1157: p_fnd_msg_level => G_MSG_LVL_ERROR ,
1158: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
1159: p_run_log_level => l_log_level
1160: );
1161: END IF;
1162: RAISE FND_API.G_EXC_ERROR;
1186: p_msg_appl_name => 'WSM' ,
1187: p_msg_tokens => l_msg_tokens ,
1188: p_stmt_num => l_stmt_num ,
1189: p_fnd_msg_level => G_MSG_LVL_ERROR ,
1190: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
1191: p_run_log_level => l_log_level
1192: );
1193: END IF;
1194: RAISE FND_API.G_EXC_ERROR;
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: );
1226: END IF;
1227:
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:
1417: BEGIN
1426: -- Initialize API return status to success
1427: x_return_status := FND_API.G_RET_STS_SUCCESS;
1428:
1429:
1430: IF FND_LOG.LEVEL_PROCEDURE >= l_log_level THEN
1431:
1432: l_stmt_num := 15;
1433: l_param_tbl.delete;
1434:
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;
1446: -- what we'll be doing here is select all the required fields use cursors... and then.... compare....
1447: -- atleast wip_entity_id/ wip_entity_name is a must.....
1456: p_msg_appl_name => 'WSM' ,
1457: p_msg_tokens => l_msg_tokens ,
1458: p_stmt_num => l_stmt_num ,
1459: p_fnd_msg_level => G_MSG_LVL_ERROR ,
1460: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
1461: p_run_log_level => l_log_level
1462: );
1463: END IF;
1464: RAISE FND_API.G_EXC_ERROR;
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,
1732: p_run_log_level => l_log_level
1733: );
1734: End if;
1735:
1754: p_msg_appl_name => 'WSM' ,
1755: p_msg_tokens => l_msg_tokens ,
1756: p_stmt_num => l_stmt_num ,
1757: p_fnd_msg_level => G_MSG_LVL_SUCCESS ,
1758: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
1759: p_run_log_level => l_log_level ,
1760: p_wsm_warning => 1
1761: );
1762: END IF;
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 ,
1774: p_run_log_level => l_log_level
1775: );
1776: END IF;
1777: -- the end...
1789: p_msg_appl_name => 'WSM' ,
1790: p_msg_tokens => l_msg_tokens ,
1791: p_stmt_num => l_stmt_num ,
1792: p_fnd_msg_level => G_MSG_LVL_ERROR ,
1793: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
1794: p_run_log_level => l_log_level
1795: );
1796: l_msg_tokens.delete;
1797: l_msg_tokens(1).TokenName := 'FLD_NAME';
1802: p_msg_appl_name => 'WSM' ,
1803: p_msg_tokens => l_msg_tokens ,
1804: p_stmt_num => l_stmt_num ,
1805: p_fnd_msg_level => G_MSG_LVL_ERROR ,
1806: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
1807: p_run_log_level => l_log_level
1808: );
1809: END IF;
1810: RAISE FND_API.G_EXC_ERROR;
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: );
1847: END IF;
1848:
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
1894: l_counter NUMBER;
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,
1913: p_run_log_level => l_log_level
1914: );
1915: End if;
1916:
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,
1935: p_run_log_level => l_log_level
1936: );
1937: End if;
1938:
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 ,
1963: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
1964: p_run_log_level => l_log_level
1965: );
1966: END IF;
1967:
2002: p_msg_appl_name => 'WSM' ,
2003: p_stmt_num => l_stmt_num ,
2004: p_msg_tokens => l_msg_tokens ,
2005: p_fnd_msg_level => G_MSG_LVL_ERROR ,
2006: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
2007: p_run_log_level => l_log_level
2008: );
2009: END IF;
2010: RAISE FND_API.G_EXC_ERROR;
2043: p_msg_appl_name => 'WSM',
2044: p_msg_tokens => l_msg_tokens ,
2045: p_stmt_num => l_stmt_num ,
2046: p_fnd_msg_level => G_MSG_LVL_ERROR ,
2047: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
2048: p_run_log_level => l_log_level
2049: );
2050: END IF;
2051:
2066: p_msg_appl_name => 'WSM',
2067: p_msg_tokens => l_msg_tokens ,
2068: p_stmt_num => l_stmt_num ,
2069: p_fnd_msg_level => G_MSG_LVL_ERROR ,
2070: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
2071: p_run_log_level => l_log_level
2072: );
2073: END IF;
2074: RAISE FND_API.G_EXC_ERROR;
2088: p_msg_appl_name => 'WSM',
2089: p_stmt_num => l_stmt_num ,
2090: p_msg_tokens => l_msg_tokens ,
2091: p_fnd_msg_level => G_MSG_LVL_ERROR ,
2092: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
2093: p_run_log_level => l_log_level
2094: );
2095: END IF;
2096: RAISE FND_API.G_EXC_ERROR;
2107: p_msg_appl_name => 'WSM' ,
2108: p_msg_tokens => l_msg_tokens ,
2109: p_stmt_num => l_stmt_num ,
2110: p_fnd_msg_level => G_MSG_LVL_ERROR ,
2111: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
2112: p_run_log_level => l_log_level
2113: );
2114: END IF;
2115: RAISE FND_API.G_EXC_ERROR;
2131: p_msg_appl_name => 'WSM',
2132: p_msg_tokens => l_msg_tokens ,
2133: p_stmt_num => l_stmt_num ,
2134: p_fnd_msg_level => G_MSG_LVL_ERROR ,
2135: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
2136: p_run_log_level => l_log_level
2137: );
2138: END IF;
2139: RAISE FND_API.G_EXC_ERROR;
2154: p_msg_appl_name => 'WSM',
2155: p_msg_tokens => l_msg_tokens ,
2156: p_stmt_num => l_stmt_num ,
2157: p_fnd_msg_level => G_MSG_LVL_ERROR ,
2158: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
2159: p_run_log_level => l_log_level
2160: );
2161: END IF;
2162: RAISE FND_API.G_EXC_ERROR;
2180: p_msg_appl_name => 'WSM',
2181: p_msg_tokens => l_msg_tokens ,
2182: p_stmt_num => l_stmt_num ,
2183: p_fnd_msg_level => G_MSG_LVL_ERROR ,
2184: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
2185: p_run_log_level => l_log_level
2186: );
2187: END IF;
2188: RAISE FND_API.G_EXC_ERROR;
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: );
2224: END IF;
2225:
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..
2266: l_null_num NUMBER := FND_API.G_NULL_NUM;
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,
2287: p_run_log_level => l_log_level
2288: );
2289: End if;
2290: l_stmt_num := 40;
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 ,
2339: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
2340: p_run_log_level => l_log_level
2341: );
2342: END IF;
2343: raise FND_API.G_EXC_ERROR;
2369: p_msg_appl_name => 'WSM' ,
2370: p_msg_tokens => l_msg_tokens ,
2371: p_stmt_num => l_stmt_num ,
2372: p_fnd_msg_level => G_MSG_LVL_ERROR ,
2373: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
2374: p_run_log_level => l_log_level
2375: );
2376: END IF;
2377: RAISE FND_API.G_EXC_ERROR;
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 ,
2404: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
2405: p_run_log_level => l_log_level
2406: );
2407: END IF;
2408: IF l_return_status = G_RET_ERROR THEN
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 ,
2438: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
2439: p_run_log_level => l_log_level
2440: );
2441: END IF;
2442: IF l_return_status = G_RET_ERROR THEN
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 ,
2466: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
2467: p_run_log_level => l_log_level
2468: );
2469: END IF;
2470:
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 ,
2492: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
2493: p_run_log_level => l_log_level
2494: );
2495: END IF;
2496:
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 ,
2527: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
2528: p_run_log_level => l_log_level
2529: );
2530: END IF;
2531: IF l_return_status = G_RET_ERROR THEN
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 ,
2569: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
2570: p_run_log_level => l_log_level
2571: );
2572: END IF;
2573: IF l_return_status = G_RET_ERROR THEN
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 ,
2634: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
2635: p_run_log_level => l_log_level
2636: );
2637: END IF;
2638: IF l_return_status = G_RET_ERROR THEN
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 ,
2672: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
2673: p_run_log_level => l_log_level
2674: );
2675: END IF;
2676: IF l_return_status = G_RET_ERROR THEN
2694: p_msg_appl_name => 'WSM',
2695: p_msg_tokens => l_msg_tokens,
2696: p_stmt_num => l_stmt_num,
2697: p_fnd_msg_level => G_MSG_LVL_ERROR ,
2698: p_fnd_log_level => G_LOG_LEVEL_ERROR,
2699: p_run_log_level => l_log_level
2700: );
2701: END IF;
2702: raise FND_API.G_EXC_ERROR;
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 ,
2722: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
2723: p_run_log_level => l_log_level
2724: );
2725: END IF;
2726:
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 ,
2748: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
2749: p_run_log_level => l_log_level
2750: );
2751: END IF;
2752:
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 ,
2783: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
2784: p_run_log_level => l_log_level
2785: );
2786: END IF;
2787: IF l_return_status = G_RET_ERROR THEN
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 ,
2829: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
2830: p_run_log_level => l_log_level
2831: );
2832: END IF;
2833: IF l_return_status = G_RET_ERROR THEN
2897: p_msg_appl_name => 'WSM',
2898: p_msg_tokens => l_msg_tokens,
2899: p_stmt_num => l_stmt_num ,
2900: p_fnd_msg_level => G_MSG_LVL_ERROR ,
2901: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
2902: p_run_log_level => l_log_level
2903: );
2904: END IF;
2905: RAISE FND_API.G_EXC_ERROR;
2917: p_msg_appl_name => 'WSM',
2918: p_msg_tokens => l_msg_tokens,
2919: p_stmt_num => l_stmt_num ,
2920: p_fnd_msg_level => G_MSG_LVL_ERROR ,
2921: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
2922: p_run_log_level => l_log_level
2923: );
2924: END IF;
2925: raise FND_API.G_EXC_ERROR;
2961: p_msg_appl_name => 'WSM' ,
2962: p_msg_tokens => l_msg_tokens ,
2963: p_stmt_num => l_stmt_num ,
2964: p_fnd_msg_level => G_MSG_LVL_ERROR ,
2965: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
2966: p_run_log_level => l_log_level
2967: );
2968: END IF;
2969: raise FND_API.G_EXC_ERROR;
2984: p_msg_appl_name => 'WSM' ,
2985: p_msg_tokens => l_msg_tokens ,
2986: p_stmt_num => l_stmt_num ,
2987: p_fnd_msg_level => G_MSG_LVL_ERROR ,
2988: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
2989: p_run_log_level => l_log_level
2990: );
2991: END IF;
2992: RAISE FND_API.G_EXC_ERROR;
3005: p_msg_appl_name => 'WSM' ,
3006: p_stmt_num => l_stmt_num ,
3007: p_msg_tokens => l_msg_tokens ,
3008: p_fnd_msg_level => G_MSG_LVL_ERROR ,
3009: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3010: p_run_log_level => l_log_level
3011: );
3012: END IF;
3013: raise FND_API.G_EXC_ERROR;
3048: p_msg_appl_name => 'WSM' ,
3049: p_msg_tokens => l_msg_tokens ,
3050: p_stmt_num => l_stmt_num ,
3051: p_fnd_msg_level => G_MSG_LVL_ERROR ,
3052: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3053: p_run_log_level => l_log_level
3054: );
3055: END IF;
3056: RAISE FND_API.G_EXC_ERROR;
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 ,
3090: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3091: p_run_log_level => l_log_level
3092: );
3093: END IF;
3094: IF l_return_status = G_RET_ERROR THEN
3174: p_msg_appl_name => 'WSM' ,
3175: p_stmt_num => l_stmt_num ,
3176: p_msg_tokens => l_msg_tokens ,
3177: p_fnd_msg_level => G_MSG_LVL_ERROR ,
3178: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3179: p_run_log_level => l_log_level
3180: );
3181: END IF;
3182: RAISE FND_API.G_EXC_ERROR;
3199: p_msg_appl_name => 'WSM',
3200: p_msg_tokens => l_msg_tokens ,
3201: p_stmt_num => l_stmt_num ,
3202: p_fnd_msg_level => G_MSG_LVL_ERROR ,
3203: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3204: p_run_log_level => l_log_level
3205: );
3206: END IF;
3207: RAISE FND_API.G_EXC_ERROR;
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 ,
3261: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3262: p_run_log_level => l_log_level
3263: );
3264: END IF;
3265: IF l_return_status = G_RET_ERROR THEN
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: );
3678: END IF;
3679:
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;
3711:
3722: p_msg_appl_name => 'WSM' ,
3723: p_stmt_num => l_stmt_num ,
3724: p_msg_tokens => l_msg_tokens ,
3725: p_fnd_msg_level => G_MSG_LVL_ERROR ,
3726: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3727: p_run_log_level => l_log_level
3728: );
3729: END IF;
3730: RAISE FND_API.G_EXC_ERROR;
3789: p_msg_appl_name => 'WSM' ,
3790: p_stmt_num => l_stmt_num ,
3791: p_msg_tokens => l_msg_tokens ,
3792: p_fnd_msg_level => G_MSG_LVL_ERROR ,
3793: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3794: p_run_log_level => l_log_level
3795: );
3796: END IF;
3797: RAISE FND_API.G_EXC_ERROR;
3859: p_msg_appl_name => 'WSM' ,
3860: p_msg_tokens => l_msg_tokens ,
3861: p_stmt_num => l_stmt_num ,
3862: p_fnd_msg_level => G_MSG_LVL_ERROR ,
3863: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3864: p_run_log_level => l_log_level
3865: );
3866: END IF;
3867: raise FND_API.G_EXC_ERROR;
3885: p_msg_appl_name => 'WSM',
3886: p_msg_tokens => l_msg_tokens ,
3887: p_stmt_num => l_stmt_num ,
3888: p_fnd_msg_level => G_MSG_LVL_ERROR ,
3889: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3890: p_run_log_level => l_log_level
3891: );
3892: END IF;
3893: raise FND_API.G_EXC_ERROR;
3916: p_msg_appl_name => 'WSM' ,
3917: p_msg_tokens => l_msg_tokens ,
3918: p_stmt_num => l_stmt_num ,
3919: p_fnd_msg_level => G_MSG_LVL_ERROR ,
3920: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3921: p_run_log_level => l_log_level
3922: );
3923: END IF;
3924: RAISE FND_API.G_EXC_ERROR;
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 ,
3955: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3956: p_run_log_level => l_log_level
3957: );
3958: END IF;
3959: IF l_return_status = G_RET_ERROR THEN
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: );
3997: END IF;
3998:
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
4045: l_stmt_num := 10;
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,
4053: p_run_log_level => l_log_level
4054: );
4055: End if;
4056:
4065: p_msg_appl_name => 'WSM' ,
4066: p_stmt_num => l_stmt_num ,
4067: p_msg_tokens => l_msg_tokens ,
4068: p_fnd_msg_level => G_MSG_LVL_ERROR ,
4069: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4070: p_run_log_level => l_log_level
4071: );
4072: END IF;
4073: RAISE FND_API.G_EXC_ERROR;
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,
4102: p_run_log_level => l_log_level
4103: );
4104: End if;
4105: -- loop on the resulting records,,,, --
4121: p_msg_appl_name => 'WSM' ,
4122: p_msg_tokens => l_msg_tokens ,
4123: p_stmt_num => l_stmt_num ,
4124: p_fnd_msg_level => G_MSG_LVL_ERROR ,
4125: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4126: p_run_log_level => l_log_level
4127: );
4128: END IF;
4129: raise FND_API.G_EXC_ERROR;
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,
4171: p_run_log_level => l_log_level
4172: );
4173: End if;
4174:
4182: p_msg_appl_name => 'WSM',
4183: p_msg_tokens => l_msg_tokens ,
4184: p_stmt_num => l_stmt_num ,
4185: p_fnd_msg_level => G_MSG_LVL_ERROR ,
4186: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4187: p_run_log_level => l_log_level
4188: );
4189: END IF;
4190: RAISE FND_API.G_EXC_ERROR;
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,
4206: p_run_log_level => l_log_level
4207: );
4208: End if;
4209:
4218: p_msg_appl_name => 'WSM',
4219: p_msg_tokens => l_msg_tokens ,
4220: p_stmt_num => l_stmt_num ,
4221: p_fnd_msg_level => G_MSG_LVL_ERROR ,
4222: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4223: p_run_log_level => l_log_level
4224: );
4225: END IF;
4226: raise FND_API.G_EXC_ERROR;
4238: p_msg_appl_name => 'WSM',
4239: p_msg_tokens => l_msg_tokens ,
4240: p_stmt_num => l_stmt_num ,
4241: p_fnd_msg_level => G_MSG_LVL_ERROR ,
4242: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4243: p_run_log_level => l_log_level
4244: );
4245: END IF;
4246: raise FND_API.G_EXC_ERROR;
4270: p_msg_appl_name => 'WSM' ,
4271: p_stmt_num => l_stmt_num ,
4272: p_msg_tokens => l_msg_tokens ,
4273: p_fnd_msg_level => G_MSG_LVL_ERROR ,
4274: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4275: p_run_log_level => l_log_level
4276: );
4277: END IF;
4278: raise FND_API.G_EXC_ERROR;
4293: p_msg_appl_name => 'WSM' ,
4294: p_msg_tokens => l_msg_tokens ,
4295: p_stmt_num => l_stmt_num ,
4296: p_fnd_msg_level => G_MSG_LVL_ERROR ,
4297: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4298: p_run_log_level => l_log_level
4299: );
4300: END IF;
4301: RAISE FND_API.G_EXC_ERROR;
4313: p_msg_appl_name => 'WSM' ,
4314: p_msg_tokens => l_msg_tokens ,
4315: p_stmt_num => l_stmt_num ,
4316: p_fnd_msg_level => G_MSG_LVL_ERROR ,
4317: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4318: p_run_log_level => l_log_level
4319: );
4320: END IF;
4321: raise FND_API.G_EXC_ERROR;
4354: p_msg_appl_name => 'WSM' ,
4355: p_msg_tokens => l_msg_tokens ,
4356: p_stmt_num => l_stmt_num ,
4357: p_fnd_msg_level => G_MSG_LVL_ERROR ,
4358: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4359: p_run_log_level => l_log_level
4360: );
4361: END IF;
4362: RAISE FND_API.G_EXC_ERROR;
4379: p_msg_appl_name => 'WSM' ,
4380: p_msg_tokens => l_msg_tokens ,
4381: p_stmt_num => l_stmt_num ,
4382: p_fnd_msg_level => G_MSG_LVL_ERROR ,
4383: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4384: p_run_log_level => l_log_level
4385: );
4386: END IF;
4387: RAISE FND_API.G_EXC_ERROR;
4417: p_msg_appl_name => 'WSM' ,
4418: p_msg_tokens => l_msg_tokens ,
4419: p_stmt_num => l_stmt_num ,
4420: p_fnd_msg_level => G_MSG_LVL_ERROR ,
4421: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4422: p_run_log_level => l_log_level
4423: );
4424: END IF;
4425: raise FND_API.G_EXC_ERROR;
4440: p_msg_appl_name => 'WSM' ,
4441: p_msg_tokens => l_msg_tokens ,
4442: p_stmt_num => l_stmt_num ,
4443: p_fnd_msg_level => G_MSG_LVL_ERROR ,
4444: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4445: p_run_log_level => l_log_level
4446: );
4447: END IF;
4448: raise FND_API.G_EXC_ERROR;
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,
4473: p_run_log_level => l_log_level
4474: );
4475: End if;
4476: -- Copy all colums except for start qty, net qty and completion subinv and coproducts supply --
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,
4518: p_run_log_level => l_log_level
4519: );
4520: End if;
4521:
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 ,
4539: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4540: p_run_log_level => l_log_level
4541: );
4542: END IF;
4543: IF l_return_status = G_RET_ERROR THEN
4568: p_msg_appl_name => 'WSM' ,
4569: p_msg_tokens => l_msg_tokens ,
4570: p_stmt_num => l_stmt_num ,
4571: p_fnd_msg_level => G_MSG_LVL_ERROR ,
4572: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4573: p_run_log_level => l_log_level
4574: );
4575: END IF;
4576: RAISE FND_API.G_EXC_ERROR;
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 ,
4605: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4606: p_run_log_level => l_log_level
4607: );
4608: END IF;
4609: IF l_return_status = G_RET_ERROR THEN
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 ,
4642: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4643: p_run_log_level => l_log_level
4644: );
4645: END IF;
4646: IF l_return_status = G_RET_ERROR THEN
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 ,
4671: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4672: p_run_log_level => l_log_level
4673: );
4674: END IF;
4675:
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 ,
4697: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4698: p_run_log_level => l_log_level
4699: );
4700: END IF;
4701:
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 ,
4732: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4733: p_run_log_level => l_log_level
4734: );
4735: END IF;
4736: IF l_return_status = G_RET_ERROR THEN
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 ,
4779: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4780: p_run_log_level => l_log_level
4781: );
4782: END IF;
4783: IF l_return_status = G_RET_ERROR THEN
4801: p_msg_appl_name => 'WSM',
4802: p_msg_tokens => l_msg_tokens ,
4803: p_stmt_num => l_stmt_num ,
4804: p_fnd_msg_level => G_MSG_LVL_ERROR ,
4805: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4806: p_run_log_level => l_log_level
4807: );
4808: END IF;
4809: RAISE FND_API.G_EXC_ERROR;
4825: p_msg_appl_name => 'WSM',
4826: p_msg_tokens => l_msg_tokens ,
4827: p_stmt_num => l_stmt_num ,
4828: p_fnd_msg_level => G_MSG_LVL_ERROR ,
4829: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4830: p_run_log_level => l_log_level
4831: );
4832: END IF;
4833: RAISE FND_API.G_EXC_ERROR;
4910: p_msg_appl_name => 'WSM',
4911: p_msg_tokens => l_msg_tokens ,
4912: p_stmt_num => l_stmt_num ,
4913: p_fnd_msg_level => G_MSG_LVL_ERROR ,
4914: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4915: p_run_log_level => l_log_level
4916: );
4917: END IF;
4918: RAISE FND_API.G_EXC_ERROR;
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: );
4970: END IF;
4971:
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
5013:
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 ,
5025: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5026: p_run_log_level => l_log_level
5027: );
5028: END IF;
5029: raise FND_API.G_EXC_ERROR;
5048: p_msg_appl_name => 'WSM' ,
5049: p_stmt_num => l_stmt_num ,
5050: p_msg_tokens => l_msg_tokens ,
5051: p_fnd_msg_level => G_MSG_LVL_ERROR ,
5052: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5053: p_run_log_level => l_log_level
5054: );
5055: END IF;
5056: RAISE FND_API.G_EXC_ERROR;
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,
5085: p_run_log_level => l_log_level
5086: );
5087: END IF;
5088:
5099: p_msg_appl_name => 'WSM' ,
5100: p_stmt_num => l_stmt_num ,
5101: p_msg_tokens => l_msg_tokens ,
5102: p_fnd_msg_level => G_MSG_LVL_ERROR ,
5103: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5104: p_run_log_level => l_log_level
5105: );
5106: END IF;
5107: RAISE FND_API.G_EXC_ERROR;
5123: p_msg_appl_name => 'WSM',
5124: p_msg_tokens => l_msg_tokens ,
5125: p_stmt_num => l_stmt_num ,
5126: p_fnd_msg_level => G_MSG_LVL_ERROR ,
5127: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5128: p_run_log_level => l_log_level
5129: );
5130: END IF;
5131: RAISE FND_API.G_EXC_ERROR;
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 ,
5159: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5160: p_run_log_level => l_log_level
5161: );
5162: END IF;
5163: IF l_return_status = G_RET_ERROR THEN
5186: p_msg_appl_name => 'WSM' ,
5187: p_stmt_num => l_stmt_num ,
5188: p_msg_tokens => l_msg_tokens ,
5189: p_fnd_msg_level => G_MSG_LVL_ERROR ,
5190: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5191: p_run_log_level => l_log_level
5192: );
5193: END IF;
5194: RAISE FND_API.G_EXC_ERROR;
5211: p_msg_appl_name => 'WSM' ,
5212: p_stmt_num => l_stmt_num ,
5213: p_msg_tokens => l_msg_tokens ,
5214: p_fnd_msg_level => G_MSG_LVL_ERROR ,
5215: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5216: p_run_log_level => l_log_level
5217: );
5218: END IF;
5219: RAISE FND_API.G_EXC_ERROR;
5233: p_msg_appl_name => 'WSM' ,
5234: p_stmt_num => l_stmt_num ,
5235: p_msg_tokens => l_msg_tokens ,
5236: p_fnd_msg_level => G_MSG_LVL_ERROR ,
5237: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5238: p_run_log_level => l_log_level
5239: );
5240: END IF;
5241: RAISE FND_API.G_EXC_ERROR;
5255: p_msg_appl_name => 'WSM' ,
5256: p_stmt_num => l_stmt_num ,
5257: p_msg_tokens => l_msg_tokens ,
5258: p_fnd_msg_level => G_MSG_LVL_ERROR ,
5259: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5260: p_run_log_level => l_log_level
5261: );
5262: END IF;
5263: RAISE FND_API.G_EXC_ERROR;
5295: p_msg_appl_name => 'WSM',
5296: p_msg_tokens => l_msg_tokens ,
5297: p_stmt_num => l_stmt_num ,
5298: p_fnd_msg_level => G_MSG_LVL_ERROR ,
5299: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5300: p_run_log_level => l_log_level
5301: );
5302: END IF;
5303: RAISE FND_API.G_EXC_ERROR;
5341: p_msg_appl_name => 'WSM' ,
5342: p_msg_tokens => l_msg_tokens ,
5343: p_stmt_num => l_stmt_num ,
5344: p_fnd_msg_level => G_MSG_LVL_ERROR ,
5345: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5346: p_run_log_level => l_log_level
5347: );
5348: END IF;
5349: raise FND_API.G_EXC_ERROR;
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 ,
5377: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5378: p_run_log_level => l_log_level
5379: );
5380: END IF;
5381: IF l_return_status = G_RET_ERROR THEN
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 ,
5413: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5414: p_run_log_level => l_log_level
5415: );
5416: END IF;
5417: IF l_return_status = G_RET_ERROR THEN
5437: p_msg_appl_name => 'WSM' ,
5438: p_msg_tokens => l_msg_tokens ,
5439: p_stmt_num => l_stmt_num ,
5440: p_fnd_msg_level => G_MSG_LVL_ERROR ,
5441: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5442: p_run_log_level => l_log_level
5443: );
5444: END IF;
5445: RAISE FND_API.G_EXC_ERROR;
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 ,
5470: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5471: p_run_log_level => l_log_level
5472: );
5473: END IF;
5474: IF l_return_status = G_RET_ERROR THEN
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 ,
5511: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5512: p_run_log_level => l_log_level
5513: );
5514: END IF;
5515: IF l_return_status = G_RET_ERROR THEN
5541: p_msg_appl_name => 'WSM',
5542: p_msg_tokens => l_msg_tokens ,
5543: p_stmt_num => l_stmt_num ,
5544: p_fnd_msg_level => G_MSG_LVL_ERROR ,
5545: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5546: p_run_log_level => l_log_level
5547: );
5548: END IF;
5549: RAISE FND_API.G_EXC_ERROR;
5560: p_msg_appl_name => 'WSM',
5561: p_msg_tokens => l_msg_tokens ,
5562: p_stmt_num => l_stmt_num ,
5563: p_fnd_msg_level => G_MSG_LVL_ERROR ,
5564: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5565: p_run_log_level => l_log_level
5566: );
5567: END IF;
5568: RAISE FND_API.G_EXC_ERROR;
5600: p_msg_appl_name => 'WSM',
5601: p_msg_tokens => l_msg_tokens ,
5602: p_stmt_num => l_stmt_num ,
5603: p_fnd_msg_level => G_MSG_LVL_ERROR ,
5604: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5605: p_run_log_level => l_log_level
5606: );
5607: END IF;
5608: RAISE FND_API.G_EXC_ERROR;
5650: p_msg_appl_name => 'WSM',
5651: p_msg_tokens => l_msg_tokens ,
5652: p_stmt_num => l_stmt_num ,
5653: p_fnd_msg_level => G_MSG_LVL_ERROR ,
5654: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5655: p_run_log_level => l_log_level
5656: );
5657: END IF;
5658: RAISE FND_API.G_EXC_ERROR;
5673: p_msg_appl_name => 'WSM',
5674: p_msg_tokens => l_msg_tokens ,
5675: p_stmt_num => l_stmt_num ,
5676: p_fnd_msg_level => G_MSG_LVL_ERROR ,
5677: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5678: p_run_log_level => l_log_level
5679: );
5680: END IF;
5681: RAISE FND_API.G_EXC_ERROR;
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: );
5716: END IF;
5717:
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:
5768: begin
5769: x_return_status := FND_API.G_RET_STS_SUCCESS;
5770:
5771: l_stmt_num := 10;
5772:
5773: IF FND_LOG.LEVEL_PROCEDURE >= l_log_level THEN
5774:
5775: l_stmt_num := 15;
5776: l_param_tbl.delete;
5777:
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;
5810:
5811: if p_sj_job_type = WIP_CONSTANTS.NONSTANDARD then
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 ,
5825: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5826: p_run_log_level => l_log_level
5827: );
5828: END IF;
5829: RAISE FND_API.G_EXC_ERROR;
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,
5839: p_run_log_level => l_log_level
5840: );
5841: END IF;
5842:
5870: p_msg_appl_name => 'WSM' ,
5871: p_msg_tokens => l_msg_tokens ,
5872: p_stmt_num => l_stmt_num ,
5873: p_fnd_msg_level => G_MSG_LVL_ERROR ,
5874: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5875: p_run_log_level => l_log_level
5876: );
5877: END IF;
5878: RAISE FND_API.G_EXC_ERROR;
5910: p_msg_appl_name => 'WSM' ,
5911: p_msg_tokens => l_msg_tokens ,
5912: p_stmt_num => l_stmt_num ,
5913: p_fnd_msg_level => G_MSG_LVL_ERROR ,
5914: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5915: p_run_log_level => l_log_level
5916: );
5917: END IF;
5918: RAISE FND_API.G_EXC_ERROR;
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,
5935: p_run_log_level => l_log_level
5936: );
5937: END IF;
5938: p_rj_rtg_revision_date := sysdate;
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,
5966: p_run_log_level => l_log_level
5967: );
5968: END IF;
5969: EXCEPTION
6018: p_msg_appl_name => 'WSM' ,
6019: p_msg_tokens => l_msg_tokens ,
6020: p_stmt_num => l_stmt_num ,
6021: p_fnd_msg_level => G_MSG_LVL_ERROR ,
6022: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6023: p_run_log_level => l_log_level
6024: );
6025: END IF;
6026: RAISE FND_API.G_EXC_ERROR;
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 ,
6055: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6056: p_run_log_level => l_log_level
6057: );
6058: END IF;
6059: raise FND_API.G_EXC_ERROR;
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: );
6095: END IF;
6096:
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:
6146: begin
6146: begin
6147: x_return_status := FND_API.G_RET_STS_SUCCESS;
6148: l_stmt_num := 10;
6149:
6150: IF FND_LOG.LEVEL_PROCEDURE >= l_log_level THEN
6151:
6152: l_stmt_num := 15;
6153: l_param_tbl.delete;
6154:
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;
6187:
6188: l_stmt_num := 18;
6228: p_msg_appl_name => 'WSM' ,
6229: p_msg_tokens => l_msg_tokens ,
6230: p_stmt_num => l_stmt_num ,
6231: p_fnd_msg_level => G_MSG_LVL_ERROR ,
6232: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6233: p_run_log_level => l_log_level
6234: );
6235: END IF;
6236: RAISE FND_API.G_EXC_ERROR;
6265: p_msg_appl_name => 'WSM' ,
6266: p_msg_tokens => l_msg_tokens ,
6267: p_stmt_num => l_stmt_num ,
6268: p_fnd_msg_level => G_MSG_LVL_ERROR ,
6269: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6270: p_run_log_level => l_log_level
6271: );
6272: END IF;
6273: RAISE FND_API.G_EXC_ERROR;
6354: p_msg_appl_name => 'WSM' ,
6355: p_msg_tokens => l_msg_tokens ,
6356: p_stmt_num => l_stmt_num ,
6357: p_fnd_msg_level => G_MSG_LVL_ERROR ,
6358: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6359: p_run_log_level => l_log_level
6360: );
6361: END IF;
6362: raise FND_API.G_EXC_ERROR;
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 ,
6391: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6392: p_run_log_level => l_log_level
6393: );
6394: END IF;
6395: raise FND_API.G_EXC_ERROR;
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: );
6430: END IF;
6431:
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:
6474: begin
6474: begin
6475: x_return_status := FND_API.G_RET_STS_SUCCESS;
6476: l_stmt_num := 10;
6477:
6478: IF FND_LOG.LEVEL_PROCEDURE >= l_log_level THEN
6479:
6480: l_stmt_num := 15;
6481: l_param_tbl.delete;
6482:
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;
6524:
6525: l_stmt_num := 20;
6564: p_msg_appl_name => 'WSM' ,
6565: p_msg_tokens => l_msg_tokens ,
6566: p_stmt_num => l_stmt_num ,
6567: p_fnd_msg_level => G_MSG_LVL_ERROR ,
6568: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6569: p_run_log_level => l_log_level
6570: );
6571: END IF;
6572: RAISE FND_API.G_EXC_ERROR;
6599: p_msg_appl_name => 'WSM' ,
6600: p_msg_tokens => l_msg_tokens ,
6601: p_stmt_num => l_stmt_num ,
6602: p_fnd_msg_level => G_MSG_LVL_ERROR ,
6603: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6604: p_run_log_level => l_log_level
6605: );
6606: END IF;
6607: RAISE FND_API.G_EXC_ERROR;
6638: p_msg_appl_name => 'WSM' ,
6639: p_msg_tokens => l_msg_tokens ,
6640: p_stmt_num => l_stmt_num ,
6641: p_fnd_msg_level => G_MSG_LVL_ERROR ,
6642: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6643: p_run_log_level => l_log_level
6644: );
6645: END IF;
6646: RAISE FND_API.G_EXC_ERROR;
6683: p_msg_appl_name => 'WSM' ,
6684: p_msg_tokens => l_msg_tokens ,
6685: p_stmt_num => l_stmt_num ,
6686: p_fnd_msg_level => G_MSG_LVL_ERROR ,
6687: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6688: p_run_log_level => l_log_level
6689: );
6690: END IF;
6691: RAISE FND_API.G_EXC_ERROR;
6720: p_msg_appl_name => 'WSM' ,
6721: p_msg_tokens => l_msg_tokens ,
6722: p_stmt_num => l_stmt_num ,
6723: p_fnd_msg_level => G_MSG_LVL_ERROR ,
6724: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6725: p_run_log_level => l_log_level
6726: );
6727: END IF;
6728: RAISE FND_API.G_EXC_ERROR;
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: );
6764: END IF;
6765:
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
6805: x_return_status := FND_API.G_RET_STS_SUCCESS;
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,
6815: p_run_log_level => l_log_level
6816: );
6817: End if;
6818:
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,
6828: p_run_log_level => l_log_level
6829: );
6830: End if;
6831:
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,
6842: p_run_log_level => l_log_level
6843: );
6844: End if;
6845:
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 ,
6869: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6870: p_run_log_level => l_log_level
6871: );
6872: END IF;
6873: raise FND_API.G_EXC_ERROR;
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,
6885: p_run_log_level => l_log_level
6886: );
6887: End if;
6888:
6922: p_msg_appl_name => 'WSM' ,
6923: p_msg_tokens => l_msg_tokens ,
6924: p_stmt_num => l_stmt_num ,
6925: p_fnd_msg_level => G_MSG_LVL_ERROR ,
6926: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6927: p_run_log_level => l_log_level
6928: );
6929: END IF;
6930: raise FND_API.G_EXC_ERROR;
6942: p_msg_appl_name => 'WSM' ,
6943: p_msg_tokens => l_msg_tokens ,
6944: p_stmt_num => l_stmt_num ,
6945: p_fnd_msg_level => G_MSG_LVL_ERROR ,
6946: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6947: p_run_log_level => l_log_level
6948: );
6949: END IF;
6950: raise FND_API.G_EXC_ERROR;
6961: p_msg_appl_name => 'WSM',
6962: p_msg_tokens => l_msg_tokens ,
6963: p_stmt_num => l_stmt_num ,
6964: p_fnd_msg_level => G_MSG_LVL_ERROR ,
6965: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6966: p_run_log_level => l_log_level
6967: );
6968: END IF;
6969: raise FND_API.G_EXC_ERROR;
6978: p_msg_appl_name => 'WSM',
6979: p_msg_tokens => l_msg_tokens ,
6980: p_stmt_num => l_stmt_num ,
6981: p_fnd_msg_level => G_MSG_LVL_ERROR ,
6982: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6983: p_run_log_level => l_log_level
6984: );
6985: END IF;
6986: raise FND_API.G_EXC_ERROR;
6997: p_msg_appl_name => 'WSM',
6998: p_msg_tokens => l_msg_tokens ,
6999: p_stmt_num => l_stmt_num ,
7000: p_fnd_msg_level => G_MSG_LVL_ERROR ,
7001: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
7002: p_run_log_level => l_log_level
7003: );
7004: END IF;
7005: raise FND_API.G_EXC_ERROR;
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,
7017: p_run_log_level => l_log_level
7018: );
7019: End if;
7020:
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,
7033: p_run_log_level => l_log_level
7034: );
7035: End if;
7036:
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,
7070: p_run_log_level => l_log_level
7071: );
7072: End if;
7073:
7110: p_msg_appl_name => 'WSM' ,
7111: p_msg_tokens => l_msg_tokens ,
7112: p_stmt_num => l_stmt_num ,
7113: p_fnd_msg_level => G_MSG_LVL_ERROR ,
7114: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
7115: p_run_log_level => l_log_level
7116: );
7117: END IF;
7118: raise FND_API.G_EXC_ERROR;
7134: p_msg_appl_name => 'WSM' ,
7135: p_msg_tokens => l_msg_tokens ,
7136: p_stmt_num => l_stmt_num ,
7137: p_fnd_msg_level => G_MSG_LVL_ERROR ,
7138: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
7139: p_run_log_level => l_log_level
7140: );
7141: END IF;
7142: raise FND_API.G_EXC_ERROR;
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,
7152: p_run_log_level => l_log_level
7153: );
7154: End if;
7155:
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: );
7188: END IF;
7189:
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
7215: x_return_status := FND_API.G_RET_STS_SUCCESS;
7226: p_msg_appl_name => 'WSM' ,
7227: p_msg_tokens => l_msg_tokens ,
7228: p_stmt_num => l_stmt_num ,
7229: p_fnd_msg_level => G_MSG_LVL_ERROR ,
7230: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
7231: p_run_log_level => l_log_level
7232: );
7233: END IF;
7234:
7270: p_msg_appl_name => 'WSM' ,
7271: p_msg_tokens => l_msg_tokens ,
7272: p_stmt_num => l_stmt_num ,
7273: p_fnd_msg_level => G_MSG_LVL_ERROR ,
7274: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
7275: p_run_log_level => l_log_level
7276: );
7277: END IF;
7278: RAISE FND_API.G_EXC_ERROR;
7291: p_msg_appl_name => 'WSM' ,
7292: p_msg_tokens => l_msg_tokens ,
7293: p_stmt_num => l_stmt_num ,
7294: p_fnd_msg_level => G_MSG_LVL_ERROR ,
7295: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
7296: p_run_log_level => l_log_level
7297: );
7298: END IF;
7299: RAISE FND_API.G_EXC_ERROR;
7311: p_msg_appl_name => 'WSM' ,
7312: p_msg_tokens => l_msg_tokens ,
7313: p_stmt_num => l_stmt_num ,
7314: p_fnd_msg_level => G_MSG_LVL_ERROR ,
7315: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
7316: p_run_log_level => l_log_level
7317: );
7318: END IF;
7319: RAISE FND_API.G_EXC_ERROR;
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: );
7355: END IF;
7356:
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 --
7385: l_counter NUMBER := 0;
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,
7408: p_run_log_level => l_log_level
7409: );
7410: End if;
7411:
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,
7504: p_run_log_level => l_log_level
7505: );
7506: End if;
7507:
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,
7635: p_run_log_level => l_log_level
7636: );
7637: End if;
7638:
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,
7782: p_run_log_level => l_log_level
7783: );
7784: End if;
7785: x_return_status := FND_API.G_RET_STS_SUCCESS;
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: );
7816: END IF;
7817:
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';
7854: BEGIN
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 ,
7875: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
7876: p_run_log_level => l_log_level
7877: );
7878: END IF;
7879: RAISE FND_API.G_EXC_ERROR;
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 ,
7904: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
7905: p_run_log_level => l_log_level
7906: );
7907: END IF;
7908: RAISE FND_API.G_EXC_ERROR;
7936: ' p_start_op_seq_code : ' || p_start_op_seq_code ||
7937: ' Revision Date : ' || p_revision_date,
7938: p_stmt_num => l_stmt_num ,
7939: p_msg_tokens => l_msg_tokens,
7940: p_fnd_log_level => g_log_level_statement,
7941: p_run_log_level => l_log_level
7942: );
7943: End if;
7944:
7965: p_msg_appl_name => 'WSM' ,
7966: p_msg_tokens => l_msg_tokens ,
7967: p_stmt_num => l_stmt_num ,
7968: p_fnd_msg_level => G_MSG_LVL_ERROR ,
7969: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
7970: p_run_log_level => l_log_level
7971: );
7972: END IF;
7973: RAISE FND_API.G_EXC_ERROR;
8026: p_msg_appl_name => 'WSM',
8027: p_msg_tokens => l_msg_tokens ,
8028: p_stmt_num => l_stmt_num ,
8029: p_fnd_msg_level => G_MSG_LVL_ERROR ,
8030: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
8031: p_run_log_level => l_log_level
8032: );
8033: END IF;
8034: RAISE FND_API.G_EXC_ERROR;
8054: p_msg_appl_name => 'WSM',
8055: p_msg_tokens => l_msg_tokens ,
8056: p_stmt_num => l_stmt_num ,
8057: p_fnd_msg_level => G_MSG_LVL_ERROR ,
8058: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
8059: p_run_log_level => l_log_level
8060: );
8061: END IF;
8062: RAISE FND_API.G_EXC_ERROR;
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: );
8094: END IF;
8095: