[Home] [Help]
37: IS
38:
39: -- Logging variables.....
40: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
41: l_msg_tokens WSM_log_PVT.token_rec_tbl;
42: l_stmt_num NUMBER;
43: l_module VARCHAR2(100) := 'wsm.plsql.WSM_WIP_LOT_TXN_PVT.Log_transaction_data';
44:
45: -- This assumption is based that each individual column to be logged doesnt exceed 3900 chars... (that's the max...)
45: -- This assumption is based that each individual column to be logged doesnt exceed 3900 chars... (that's the max...)
46: type t_log_message_tbl IS table OF varchar2(3900) index by binary_integer;
47:
48: -- MESSAGE_TEXT column in FND_LOG_MESSAGES is 4000 characters long..
49: -- WSM_Log_PVT adds the date information in the start,,, so leave 50 characters for that
50: -- Effective length we would use is 3900
51: l_message_length NUMBER := 3900;
52: l_log_message VARCHAR2(3900);
53:
62: x_msg_count := 0;
63:
64: if( g_log_level_statement >= l_log_level ) then
65:
66: WSM_log_PVT.logMessage(p_module_name => l_module ,
67: p_msg_text => 'Entered Log_transaction_data procedure',
68: p_stmt_num => l_stmt_num ,
69: p_msg_tokens => l_msg_tokens,
70: p_fnd_log_level => g_log_level_statement,
70: p_fnd_log_level => g_log_level_statement,
71: p_run_log_level => l_log_level
72: );
73:
74: WSM_log_PVT.logMessage(p_module_name => l_module ,
75: p_msg_text => '------> Transaction Header Information <---------',
76: p_stmt_num => l_stmt_num ,
77: p_msg_tokens => l_msg_tokens,
78: p_fnd_log_level => g_log_level_statement,
112: while l_counter is not null loop
113:
114: IF length(l_log_message || l_message_tbl(l_counter)) > 3900 THEN
115: -- Log the data in l_log_message...
116: WSM_log_PVT.logMessage(p_module_name => l_module ,
117: p_msg_text => l_log_message ,
118: p_stmt_num => l_stmt_num ,
119: p_msg_tokens => l_msg_tokens ,
120: p_fnd_log_level => g_log_level_statement ,
130:
131: -- Log the remainder data..
132: IF l_log_message IS NOT NULL THEN
133: -- Log the data in l_log_message...
134: WSM_log_PVT.logMessage(p_module_name => l_module ,
135: p_msg_text => l_log_message ,
136: p_stmt_num => l_stmt_num ,
137: p_msg_tokens => l_msg_tokens ,
138: p_fnd_log_level => g_log_level_statement ,
143:
144: l_log_message := null;
145: l_stmt_num := 20;
146: -- Log the starting jobs data....
147: WSM_log_PVT.logMessage(p_module_name => l_module ,
148: p_msg_text => '=========------> Starting Jobs Information <---------============',
149: p_stmt_num => l_stmt_num ,
150: p_msg_tokens => l_msg_tokens ,
151: p_fnd_log_level => g_log_level_statement ,
224: while l_counter is not null loop
225:
226: IF length(l_log_message || l_message_tbl(l_counter)) > 3900 THEN
227: -- Log the data in l_log_message...
228: WSM_log_PVT.logMessage(p_module_name => l_module ,
229: p_msg_text => l_log_message ,
230: p_stmt_num => l_stmt_num ,
231: p_msg_tokens => l_msg_tokens ,
232: p_fnd_log_level => g_log_level_statement ,
242:
243: -- Log the remainder data..
244: IF l_log_message IS NOT NULL THEN
245: -- Log the data in l_log_message...
246: WSM_log_PVT.logMessage(p_module_name => l_module ,
247: p_msg_text => l_log_message ,
248: p_stmt_num => l_stmt_num ,
249: p_msg_tokens => l_msg_tokens ,
250: p_fnd_log_level => g_log_level_statement ,
257: end loop;
258:
259: l_stmt_num := 30;
260: -- Log the starting jobs data....
261: WSM_log_PVT.logMessage(p_module_name => l_module ,
262: p_msg_text => '=========------> Resulting Jobs Information <---------============',
263: p_stmt_num => l_stmt_num ,
264: p_msg_tokens => l_msg_tokens ,
265: p_fnd_log_level => g_log_level_statement ,
338: while l_counter is not null loop
339:
340: IF length(l_log_message || l_message_tbl(l_counter)) > 3900 THEN
341: -- Log the data in l_log_message...
342: WSM_log_PVT.logMessage(p_module_name => l_module ,
343: p_msg_text => l_log_message ,
344: p_stmt_num => l_stmt_num ,
345: p_msg_tokens => l_msg_tokens ,
346: p_fnd_log_level => g_log_level_statement ,
356:
357: -- Log the remainder data..
358: IF l_log_message IS NOT NULL THEN
359: -- Log the data in l_log_message...
360: WSM_log_PVT.logMessage(p_module_name => l_module ,
361: p_msg_text => l_log_message ,
362: p_stmt_num => l_stmt_num ,
363: p_msg_tokens => l_msg_tokens ,
364: p_fnd_log_level => g_log_level_statement ,
370: l_index := p_resulting_jobs_tbl.next(l_index);
371: end loop;
372: l_stmt_num := 40;
373: -- Log the starting jobs data....
374: WSM_log_PVT.logMessage(p_module_name => l_module ,
375: p_msg_text => '=========------> Secondary quantities Information <---------============',
376: p_stmt_num => l_stmt_num ,
377: p_msg_tokens => l_msg_tokens ,
378: p_fnd_log_level => g_log_level_statement ,
398: while l_counter is not null loop
399:
400: IF length(l_log_message || l_message_tbl(l_counter)) > 3900 THEN
401: -- Log the data in l_log_message...
402: WSM_log_PVT.logMessage(p_module_name => l_module ,
403: p_msg_text => l_log_message ,
404: p_stmt_num => l_stmt_num ,
405: p_msg_tokens => l_msg_tokens ,
406: p_fnd_log_level => g_log_level_statement ,
416:
417: -- Log the remainder data..
418: IF l_log_message IS NOT NULL THEN
419: -- Log the data in l_log_message...
420: WSM_log_PVT.logMessage(p_module_name => l_module ,
421: p_msg_text => l_log_message ,
422: p_stmt_num => l_stmt_num ,
423: p_msg_tokens => l_msg_tokens ,
424: p_fnd_log_level => g_log_level_statement ,
430: l_index := p_secondary_qty_tbl.next(l_index);
431: end loop;
432:
433: -- Log the data in l_log_message...
434: WSM_log_PVT.logMessage(p_module_name => l_module ,
435: p_msg_text => 'Sucessfully logged the transaction data',
436: p_stmt_num => l_stmt_num ,
437: p_msg_tokens => l_msg_tokens ,
438: p_fnd_log_level => g_log_level_statement ,
448:
449: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
450: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
451: THEN
452: WSM_log_PVT.handle_others( p_module_name => l_module ,
453: p_stmt_num => l_stmt_num ,
454: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
455: p_run_log_level => l_log_level
456: );
528:
529: l_wltx_resulting_job_rec WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_REC_TYPE; --ADD AH
530:
531: -- Logging variables.....
532: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
533: l_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
534:
535: l_stmt_num NUMBER;
536: l_module VARCHAR2(100) := 'wsm.plsql.WSM_WIP_LOT_TXN_PVT.invoke_txn_API';
550: l_secondary_qty_tbl := p_secondary_qty_tbl ;
551:
552: if( g_log_level_statement >= l_log_level ) then
553: l_msg_tokens.delete;
554: WSM_log_PVT.logMessage(p_module_name => l_module ,
555: p_msg_text => 'Entered Invoke Txn API procedure',
556: p_stmt_num => l_stmt_num ,
557: p_msg_tokens => l_msg_tokens,
558: p_fnd_log_level => g_log_level_statement,
586: */
587: l_stmt_num := 12;
588: if( g_log_level_statement >= l_log_level ) then
589: l_msg_tokens.delete;
590: WSM_log_PVT.logMessage(p_module_name => l_module,
591: p_msg_text => 'Txn type Split',
592: p_stmt_num => l_stmt_num,
593: p_msg_tokens => l_msg_tokens,
594: p_fnd_log_level => g_log_level_statement,
602: /* error out... */
603: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
604:
605: l_msg_tokens.delete;
606: WSM_log_PVT.logMessage(p_module_name=> l_module ,
607: p_msg_name => 'WSM_START_LOT_REQUIRED',
608: p_msg_appl_name => 'WSM',
609: p_msg_tokens => l_msg_tokens ,
610: p_stmt_num => l_stmt_num ,
621: /* error out... */
622: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
623:
624: l_msg_tokens.delete;
625: WSM_log_PVT.logMessage(p_module_name=> l_module ,
626: p_msg_name => 'WSM_RESULT_LOT_REQUIRED',
627: p_msg_appl_name => 'WSM',
628: p_msg_tokens => l_msg_tokens ,
629: p_stmt_num => l_stmt_num ,
638: l_stmt_num := 25;
639:
640: if( g_log_level_statement >= l_log_level ) then
641: l_msg_tokens.delete;
642: WSM_log_PVT.logMessage(p_module_name => l_module ,
643: p_msg_text => 'Before calling SPLIT TXN procedure',
644: p_stmt_num => l_stmt_num ,
645: p_msg_tokens => l_msg_tokens,
646: p_fnd_log_level => g_log_level_statement,
666: l_stmt_num := 30;
667:
668: if( g_log_level_statement >= l_log_level ) then
669: l_msg_tokens.delete;
670: WSM_log_PVT.logMessage(p_module_name => l_module,
671: p_msg_text =>'Returned from SPLIT TXN procedure.Return status:'|| x_return_status,
672: p_stmt_num => l_stmt_num ,
673: p_msg_tokens => l_msg_tokens,
674: p_fnd_log_level => g_log_level_statement,
695: /* error out... */
696: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
697:
698: l_msg_tokens.delete;
699: WSM_log_PVT.logMessage(p_module_name => l_module ,
700: p_msg_text => 'No. of SJs cannot be less than 2 in case of Merge',
701: p_stmt_num => l_stmt_num ,
702: p_msg_tokens => l_msg_tokens,
703: p_fnd_msg_level => G_MSG_LVL_ERROR ,
713: /* error out... */
714: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
715:
716: l_msg_tokens.delete;
717: WSM_log_PVT.logMessage(p_module_name=> l_module ,
718: p_msg_name => 'WSM_RESULT_LOT_REQUIRED',
719: p_msg_appl_name => 'WSM',
720: p_msg_tokens => l_msg_tokens ,
721: p_stmt_num => l_stmt_num ,
751: /* Log the Procedure exit point.... */
752: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
753:
754: l_msg_tokens.delete;
755: WSM_log_PVT.logMessage(p_module_name => l_module ,
756: p_msg_text => 'Merge API Failed',
757: p_stmt_num => l_stmt_num ,
758: p_msg_tokens => l_msg_tokens,
759: p_fnd_msg_level => G_MSG_LVL_ERROR ,
780: /* error out... */
781: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
782:
783: l_msg_tokens.delete;
784: WSM_log_PVT.logMessage(p_module_name=> l_module ,
785: p_msg_name => 'WSM_START_LOT_REQUIRED',
786: p_msg_appl_name => 'WSM',
787: p_msg_tokens => l_msg_tokens ,
788: p_stmt_num => l_stmt_num ,
798: /* error out... */
799: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
800:
801: l_msg_tokens.delete;
802: WSM_log_PVT.logMessage(p_module_name=> l_module ,
803: p_msg_name => 'WSM_RESULT_LOT_REQUIRED',
804: p_msg_appl_name => 'WSM',
805: p_msg_tokens => l_msg_tokens ,
806: p_stmt_num => l_stmt_num ,
834: /* Log the Procedure exit point.... */
835: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
836:
837: l_msg_tokens.delete;
838: WSM_log_PVT.logMessage(p_module_name => l_module ,
839: p_msg_text => 'Update Assembly Txn procedure failed.' ,
840: p_stmt_num => l_stmt_num ,
841: p_msg_tokens => l_msg_tokens,
842: p_fnd_msg_level => G_MSG_LVL_ERROR ,
862: /* error out... */
863: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
864:
865: l_msg_tokens.delete;
866: WSM_log_PVT.logMessage(p_module_name=> l_module ,
867: p_msg_name => 'WSM_START_LOT_REQUIRED',
868: p_msg_appl_name => 'WSM',
869: p_stmt_num => l_stmt_num ,
870: p_msg_tokens => l_msg_tokens ,
880: /* error out... */
881: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
882:
883: l_msg_tokens.delete;
884: WSM_log_PVT.logMessage(p_module_name=> l_module ,
885: p_msg_name => 'WSM_RESULT_LOT_REQUIRED',
886: p_msg_appl_name => 'WSM',
887: p_stmt_num => l_stmt_num ,
888: p_msg_tokens => l_msg_tokens ,
913: /* Log the Procedure exit point.... */
914: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
915:
916: l_msg_tokens.delete;
917: WSM_log_PVT.logMessage(p_module_name => l_module ,
918: p_msg_text => 'Update Routing Txn procedure failed.',
919: p_stmt_num => l_stmt_num ,
920: p_msg_tokens => l_msg_tokens,
921: p_fnd_msg_level => G_MSG_LVL_ERROR ,
942: /* error out... */
943: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
944:
945: l_msg_tokens.delete;
946: WSM_log_PVT.logMessage(p_module_name=> l_module ,
947: p_msg_name => 'WSM_START_LOT_REQUIRED',
948: p_msg_appl_name => 'WSM',
949: p_stmt_num => l_stmt_num ,
950: p_msg_tokens => l_msg_tokens ,
960: /* error out... */
961: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
962:
963: l_msg_tokens.delete;
964: WSM_log_PVT.logMessage(p_module_name=> l_module ,
965: p_msg_name => 'WSM_RESULT_LOT_REQUIRED',
966: p_msg_appl_name => 'WSM',
967: p_stmt_num => l_stmt_num ,
968: p_msg_tokens => l_msg_tokens ,
995: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
996:
997: l_msg_tokens.delete;
998: /* Bugfix 5352389 Changed p_fnd_log_level from ERROR to STATEMENT */
999: WSM_log_PVT.logMessage(p_module_name => l_module ,
1000: p_msg_text => 'Update Quantity Txn procedure failed.',
1001: p_stmt_num => l_stmt_num ,
1002: p_msg_tokens => l_msg_tokens,
1003: p_fnd_msg_level => G_MSG_LVL_ERROR ,
1023: /* error out... */
1024: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
1025:
1026: l_msg_tokens.delete;
1027: WSM_log_PVT.logMessage(p_module_name=> l_module ,
1028: p_msg_name => 'WSM_START_LOT_REQUIRED',
1029: p_msg_appl_name => 'WSM',
1030: p_msg_tokens => l_msg_tokens ,
1031: p_stmt_num => l_stmt_num ,
1041: /* error out... */
1042: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
1043:
1044: l_msg_tokens.delete;
1045: WSM_log_PVT.logMessage(p_module_name=> l_module ,
1046: p_msg_name => 'WSM_RESULT_LOT_REQUIRED',
1047: p_msg_appl_name => 'WSM',
1048: p_msg_tokens => l_msg_tokens ,
1049: p_stmt_num => l_stmt_num ,
1075: /* Log the Procedure exit point.... */
1076: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
1077:
1078: l_msg_tokens.delete;
1079: WSM_log_PVT.logMessage(p_module_name => l_module ,
1080: p_msg_text => 'Update Lot Name Txn procedure failed.',
1081: p_stmt_num => l_stmt_num ,
1082: p_msg_tokens => l_msg_tokens,
1083: p_fnd_msg_level => G_MSG_LVL_ERROR ,
1104: /* error out... */
1105: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
1106:
1107: l_msg_tokens.delete;
1108: WSM_log_PVT.logMessage(p_module_name=> l_module ,
1109: p_msg_name => 'WSM_RESULT_LOT_REQUIRED',
1110: p_msg_appl_name => 'WSM',
1111: p_msg_tokens => l_msg_tokens ,
1112: p_stmt_num => l_stmt_num ,
1137: /* Log the Procedure exit point.... */
1138: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
1139:
1140: l_msg_tokens.delete;
1141: WSM_log_PVT.logMessage(p_module_name => l_module ,
1142: p_msg_text => 'Bonus Txn procedure failed.',
1143: p_stmt_num => l_stmt_num ,
1144: p_msg_tokens => l_msg_tokens,
1145: p_fnd_msg_level => G_MSG_LVL_ERROR ,
1181: --log error
1182: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
1183:
1184: l_msg_tokens.delete;
1185: WSM_log_PVT.logMessage(p_module_name => l_module ,
1186: p_msg_text => 'WSM_WLT_VALIDATE_PVT.insert_txn_data failed',
1187: p_stmt_num => l_stmt_num ,
1188: p_msg_tokens => l_msg_tokens,
1189: p_fnd_msg_level => G_MSG_LVL_ERROR ,
1233: end if;
1234:
1235: if( g_log_level_statement >= l_log_level ) then
1236: l_msg_tokens.delete;
1237: WSM_log_PVT.logMessage(p_module_name => l_module ,
1238: p_msg_text => 'Returned sucessfully from WSM_Serial_Support_PVT.WLT_serial_processor',
1239: p_stmt_num => l_stmt_num ,
1240: p_msg_tokens => l_msg_tokens,
1241: p_fnd_log_level => g_log_level_statement,
1262: -- NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
1263: -- ) ;
1264: -- if( g_log_level_statement >= l_log_level ) then
1265: -- l_msg_tokens.delete;
1266: -- WSM_log_PVT.logMessage(p_module_name => l_module ,
1267: -- p_msg_text => 'Concurrent Request : ' || l_poreq_request_id || ' for Requisition Import Submitted',
1268: -- p_stmt_num => l_stmt_num ,
1269: -- p_msg_tokens => l_msg_tokens,
1270: -- p_fnd_log_level => g_log_level_statement,
1280: );
1281:
1282: if( g_log_level_statement >= l_log_level ) then
1283: l_msg_tokens.delete;
1284: WSM_log_PVT.logMessage(p_module_name => l_module ,
1285: p_msg_text => 'Invoke Txn API completed sucessfully',
1286: p_stmt_num => l_stmt_num ,
1287: p_msg_tokens => l_msg_tokens,
1288: p_fnd_log_level => g_log_level_statement,
1315:
1316: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
1317: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
1318: THEN
1319: WSM_log_PVT.handle_others( p_module_name => l_module ,
1320: p_stmt_num => l_stmt_num ,
1321: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
1322: p_run_log_level => l_log_level
1323: );
1358: /* Have to create a table.... for the starting job */
1359: l_wltx_starting_jobs_tbl WLTX_STARTING_JOBS_TBL_TYPE;
1360:
1361: -- Logging variables.....
1362: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
1363: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1364: l_stmt_num NUMBER;
1365: l_module VARCHAR2(100) := 'wsm.plsql.WSM_WIP_LOT_TXN_PVT.SPLIT_TXN';
1366: -- Logging variables...
1378:
1379: /* Log the Procedure entry point.... */
1380: if( g_log_level_statement >= l_log_level ) then
1381: l_msg_tokens.delete;
1382: WSM_log_PVT.logMessage(p_module_name => l_module ,
1383: p_msg_text => 'Entered Split Txn procedure' ,
1384: p_stmt_num => l_stmt_num ,
1385: p_msg_tokens => l_msg_tokens,
1386: p_fnd_log_level => g_log_level_statement,
1408: /* Incompatible versions...*/
1409: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
1410:
1411: l_msg_tokens.delete;
1412: WSM_log_PVT.logMessage(p_module_name => l_module ,
1413: p_msg_text => 'Incompatible API called for Split Txn',
1414: p_stmt_num => l_stmt_num ,
1415: p_msg_tokens => l_msg_tokens,
1416: p_fnd_msg_level => G_MSG_LVL_ERROR ,
1424:
1425: /* logginng .... */
1426: if( g_log_level_statement >= l_log_level ) then
1427: l_msg_tokens.delete;
1428: WSM_log_PVT.logMessage(p_module_name => l_module ,
1429: p_msg_text => 'API compatibility succeeded' ,
1430: p_stmt_num => l_stmt_num ,
1431: p_msg_tokens => l_msg_tokens,
1432: p_fnd_log_level => g_log_level_statement,
1442:
1443: /* Log the Procedure entry point.... */
1444: if( g_log_level_statement >= l_log_level ) then
1445: l_msg_tokens.delete;
1446: WSM_log_PVT.logMessage(p_module_name => l_module ,
1447: p_msg_text => 'Calling WSM_WLT_VALIDATE_PVT.validate_txn_details',
1448: p_stmt_num => l_stmt_num ,
1449: p_msg_tokens => l_msg_tokens,
1450: p_fnd_log_level => g_log_level_statement,
1462:
1463: /* Log the Procedure exit point.... */
1464: if( g_log_level_statement >= l_log_level ) then
1465: l_msg_tokens.delete;
1466: WSM_log_PVT.logMessage(p_module_name => l_module ,
1467: p_msg_text => 'Returning from WSM_WLT_VALIDATE_PVT.validate_txn_header',
1468: p_stmt_num => l_stmt_num ,
1469: p_msg_tokens => l_msg_tokens,
1470: p_fnd_log_level => g_log_level_statement,
1476: /* Txn errored....*/
1477: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
1478:
1479: l_msg_tokens.delete;
1480: WSM_log_PVT.logMessage(p_module_name => l_module ,
1481: p_msg_text => 'validate_txn_header failed.' ,
1482: p_stmt_num => l_stmt_num ,
1483: p_msg_tokens => l_msg_tokens,
1484: p_fnd_msg_level => G_MSG_LVL_ERROR ,
1497:
1498: /* Log the Procedure exit point.... */
1499: if( g_log_level_statement >= l_log_level ) then
1500: l_msg_tokens.delete;
1501: WSM_log_PVT.logMessage(p_module_name => l_module ,
1502: p_msg_text => 'Validated the Transaction Header Information .... Success ' ,
1503: p_stmt_num => l_stmt_num ,
1504: p_msg_tokens => l_msg_tokens,
1505: p_fnd_log_level => g_log_level_statement,
1513:
1514: /* Log the Procedure entry point.... */
1515: if( g_log_level_statement >= l_log_level ) then
1516: l_msg_tokens.delete;
1517: WSM_log_PVT.logMessage(p_module_name => l_module ,
1518: p_msg_text => 'Calling WSM_WLT_VALIDATE_PVT.default_starting_job_details',
1519: p_stmt_num => l_stmt_num ,
1520: p_msg_tokens => l_msg_tokens,
1521: p_fnd_log_level => g_log_level_statement,
1535:
1536: /* Log the Procedure exit point.... */
1537: if( g_log_level_statement >= l_log_level ) then
1538: l_msg_tokens.delete;
1539: WSM_log_PVT.logMessage(p_module_name => l_module ,
1540: p_msg_text => 'Returning from WSM_WLT_VALIDATE_PVT.default_starting_job_details',
1541: p_stmt_num => l_stmt_num ,
1542: p_msg_tokens => l_msg_tokens,
1543: p_fnd_log_level => g_log_level_statement,
1550: /* Txn errored....*/
1551: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
1552:
1553: l_msg_tokens.delete;
1554: WSM_log_PVT.logMessage(p_module_name => l_module ,
1555: p_msg_text => 'derive_val_st_job_details failed.' ,
1556: p_stmt_num => l_stmt_num ,
1557: p_msg_tokens => l_msg_tokens,
1558: p_fnd_msg_level => G_MSG_LVL_ERROR ,
1571:
1572: /* Log the Procedure exit point.... */
1573: if( g_log_level_statement >= l_log_level ) then
1574: l_msg_tokens.delete;
1575: WSM_log_PVT.logMessage(p_module_name => l_module ,
1576: p_msg_text => 'Defaulting the starting job details ... Success ',
1577: p_stmt_num => l_stmt_num ,
1578: p_msg_tokens => l_msg_tokens,
1579: p_fnd_log_level => g_log_level_statement,
1585:
1586: /* Log the Procedure entry point.... */
1587: if( g_log_level_statement >= l_log_level ) then
1588: l_msg_tokens.delete;
1589: WSM_log_PVT.logMessage(p_module_name => l_module ,
1590: p_msg_text => 'Calling WSM_WLT_VALIDATE_PVT.validate_resulting_job ',
1591: p_stmt_num => l_stmt_num ,
1592: p_msg_tokens => l_msg_tokens,
1593: p_fnd_log_level => g_log_level_statement,
1608:
1609: /* Log the Procedure exit point.... */
1610: if( g_log_level_statement >= l_log_level ) then
1611: l_msg_tokens.delete;
1612: WSM_log_PVT.logMessage(p_module_name => l_module ,
1613: p_msg_text => 'Returning from WSM_WLT_VALIDATE_PVT.validate_resulting_job',
1614: p_stmt_num => l_stmt_num ,
1615: p_msg_tokens => l_msg_tokens,
1616: p_fnd_log_level => g_log_level_statement,
1623: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
1624:
1625: l_msg_tokens.delete;
1626: /* Bugfix 5438722 Changed p_fnd_log_level from ERROR to STATEMENT */
1627: WSM_log_PVT.logMessage(p_module_name => l_module ,
1628: p_msg_text => 'derive_val_res_job_details failed.'||x_return_status,
1629: p_stmt_num => l_stmt_num ,
1630: p_msg_tokens => l_msg_tokens,
1631: p_fnd_msg_level => G_MSG_LVL_ERROR ,
1643: end if;
1644: /* Log the Procedure exit point.... */
1645: if( g_log_level_statement >= l_log_level ) then
1646: l_msg_tokens.delete;
1647: WSM_log_PVT.logMessage(p_module_name => l_module ,
1648: p_msg_text => 'Validation of the resulting jobs details ... Success',
1649: p_stmt_num => l_stmt_num ,
1650: p_msg_tokens => l_msg_tokens,
1651: p_fnd_log_level => g_log_level_statement,
1660:
1661: /* Log the Procedure entry point.... */
1662: if( g_log_level_statement >= l_log_level ) then
1663: l_msg_tokens.delete;
1664: WSM_log_PVT.logMessage(p_module_name => l_module ,
1665: p_msg_text => 'Calling WWSMPJUPD.PROCESS_LOTS : Transaction Id : ' || l_txn_id ,
1666: p_stmt_num => l_stmt_num ,
1667: p_msg_tokens => l_msg_tokens,
1668: p_fnd_log_level => g_log_level_statement,
1687:
1688: /* Log the Procedure exit point.... */
1689: if( g_log_level_statement >= l_log_level ) then
1690: l_msg_tokens.delete;
1691: WSM_log_PVT.logMessage(p_module_name => l_module ,
1692: p_msg_text => 'Returning from WWSMPJUPD.PROCESS_LOTS',
1693: p_stmt_num => l_stmt_num ,
1694: p_msg_tokens => l_msg_tokens,
1695: p_fnd_log_level => g_log_level_statement,
1701: /* Txn errored....*/
1702: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
1703:
1704: l_msg_tokens.delete;
1705: WSM_log_PVT.logMessage(p_module_name => l_module ,
1706: p_msg_text => 'PROCESS_LOTS failed.' ,
1707: p_stmt_num => l_stmt_num ,
1708: p_msg_tokens => l_msg_tokens,
1709: p_fnd_msg_level => G_MSG_LVL_ERROR ,
1725:
1726: /* Log the Procedure exit point.... */
1727: if( g_log_level_statement >= l_log_level ) then
1728: l_msg_tokens.delete;
1729: WSM_log_PVT.logMessage(p_module_name => l_module ,
1730: p_msg_text => 'Processing of the Wip Lot Transaction ... Success',
1731: p_stmt_num => l_stmt_num ,
1732: p_msg_tokens => l_msg_tokens,
1733: p_fnd_log_level => g_log_level_statement,
1744: /* Log the Procedure exit point.... */
1745: --'WIp Lot Transaction ... Commit complete')
1746: if( g_log_level_statement >= l_log_level ) then
1747: l_msg_tokens.delete;
1748: WSM_log_PVT.logMessage(p_module_name => l_module ,
1749: p_msg_text => 'Wip Lot Transaction ... Commit complete',
1750: p_stmt_num => l_stmt_num ,
1751: p_msg_tokens => l_msg_tokens,
1752: p_fnd_log_level => g_log_level_statement,
1789:
1790: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
1791: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
1792: THEN
1793: WSM_log_PVT.handle_others( p_module_name => l_module ,
1794: p_stmt_num => l_stmt_num ,
1795: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
1796: p_run_log_level => l_log_level
1797: );
1838: l_wltx_starting_jobs_tbl WLTX_STARTING_JOBS_TBL_TYPE;
1839: l_wltx_rep_job_rec WLTX_STARTING_JOBS_REC_TYPE; --Add AH
1840:
1841: -- Logging variables.....
1842: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
1843: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1844:
1845: l_stmt_num NUMBER;
1846: l_module VARCHAR2(100) := 'wsm.plsql.WSM_WIP_LOT_TXN_PVT.MERGE_TXN';
1861:
1862: /* Log the Procedure entry point.... */
1863: if( g_log_level_statement >= l_log_level ) then
1864: l_msg_tokens.delete;
1865: WSM_log_PVT.logMessage(p_module_name => l_module ,
1866: p_msg_text => 'Entering the Merge_Txn API' ,
1867: p_stmt_num => l_stmt_num ,
1868: p_msg_tokens => l_msg_tokens,
1869: p_fnd_log_level => g_log_level_statement,
1897: /* Incompatible versions...*/
1898: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
1899:
1900: l_msg_tokens.delete;
1901: WSM_log_PVT.logMessage(p_module_name => l_module ,
1902: p_msg_text => 'Incompatible API called for Merge Txn',
1903: p_stmt_num => l_stmt_num ,
1904: p_msg_tokens => l_msg_tokens,
1905: p_fnd_msg_level => G_MSG_LVL_ERROR ,
1920:
1921: /* Log the Procedure entry point.... */
1922: if( g_log_level_statement >= l_log_level ) then
1923: l_msg_tokens.delete;
1924: WSM_log_PVT.logMessage(p_module_name => l_module ,
1925: p_msg_text => 'Calling WSM_WLT_VALIDATE_PVT.validate_txn_details',
1926: p_stmt_num => l_stmt_num ,
1927: p_msg_tokens => l_msg_tokens,
1928: p_fnd_log_level => g_log_level_statement,
1938: /* End header Validation */
1939: /* Log the Procedure exit point.... */
1940: if( g_log_level_statement >= l_log_level ) then
1941: l_msg_tokens.delete;
1942: WSM_log_PVT.logMessage(p_module_name => l_module ,
1943: p_msg_text => 'Returning from WSM_WLT_VALIDATE_PVT.validate_txn_header',
1944: p_stmt_num => l_stmt_num ,
1945: p_msg_tokens => l_msg_tokens,
1946: p_fnd_log_level => g_log_level_statement,
1952: /* Txn errored....*/
1953: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
1954:
1955: l_msg_tokens.delete;
1956: WSM_log_PVT.logMessage(p_module_name => l_module ,
1957: p_msg_text => 'validate_txn_header failed.' ,
1958: p_stmt_num => l_stmt_num ,
1959: p_msg_tokens => l_msg_tokens,
1960: p_fnd_msg_level => G_MSG_LVL_ERROR ,
1973:
1974: /* Log the Procedure exit point....event level */
1975: if( g_log_level_statement >= l_log_level ) then
1976: l_msg_tokens.delete;
1977: WSM_log_PVT.logMessage(p_module_name => l_module ,
1978: p_msg_text => 'Validated the Transaction Header Information .... Success ' ,
1979: p_stmt_num => l_stmt_num ,
1980: p_msg_tokens => l_msg_tokens,
1981: p_fnd_log_level => g_log_level_statement,
1988: /* Here we actually call the code to default the job details... */
1989: /* Log the Procedure entry point.... proc level*/
1990: if( g_log_level_statement >= l_log_level ) then
1991: l_msg_tokens.delete;
1992: WSM_log_PVT.logMessage(p_module_name => l_module ,
1993: p_msg_text => 'Calling WSM_WLT_VALIDATE_PVT.default_starting_job_details',
1994: p_stmt_num => l_stmt_num ,
1995: p_msg_tokens => l_msg_tokens,
1996: p_fnd_log_level => g_log_level_statement,
2015:
2016: /* Log the Procedure exit point....proc level,stmt level*/
2017: if( g_log_level_statement >= l_log_level ) then
2018: l_msg_tokens.delete;
2019: WSM_log_PVT.logMessage(p_module_name => l_module ,
2020: p_msg_text => 'Returning from WSM_WLT_VALIDATE_PVT.default_starting_job_details',
2021: p_stmt_num => l_stmt_num ,
2022: p_msg_tokens => l_msg_tokens,
2023: p_fnd_log_level => g_log_level_statement,
2029: /* Txn errored....*/
2030: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
2031:
2032: l_msg_tokens.delete;
2033: WSM_log_PVT.logMessage(p_module_name => l_module ,
2034: p_msg_text => 'derive_val_st_job_details failed.' ,
2035: p_stmt_num => l_stmt_num ,
2036: p_msg_tokens => l_msg_tokens,
2037: p_fnd_msg_level => G_MSG_LVL_ERROR ,
2050:
2051: /* Log the Procedure exit point.... */
2052: if( g_log_level_statement >= l_log_level ) then
2053: l_msg_tokens.delete;
2054: WSM_log_PVT.logMessage(p_module_name => l_module ,
2055: p_msg_text => 'Defaulting the starting job details ... Success ',
2056: p_stmt_num => l_stmt_num ,
2057: p_msg_tokens => l_msg_tokens,
2058: p_fnd_log_level => g_log_level_statement,
2064:
2065: /* Log the Procedure entry point....proc level */
2066: if( g_log_level_statement >= l_log_level ) then
2067: l_msg_tokens.delete;
2068: WSM_log_PVT.logMessage(p_module_name => l_module ,
2069: p_msg_text => 'Calling WSM_WLT_VALIDATE_PVT.validate_resulting_job ',
2070: p_stmt_num => l_stmt_num ,
2071: p_msg_tokens => l_msg_tokens,
2072: p_fnd_log_level => g_log_level_statement,
2093:
2094: /* Log the Procedure exit point.... */
2095: if( g_log_level_statement >= l_log_level ) then
2096: l_msg_tokens.delete;
2097: WSM_log_PVT.logMessage(p_module_name => l_module ,
2098: p_msg_text => 'Returning from WSM_WLT_VALIDATE_PVT.validate_resulting_job',
2099: p_stmt_num => l_stmt_num ,
2100: p_msg_tokens => l_msg_tokens,
2101: p_fnd_log_level => g_log_level_statement,
2107: /* Txn errored....*/
2108: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
2109:
2110: l_msg_tokens.delete;
2111: WSM_log_PVT.logMessage(p_module_name => l_module ,
2112: p_msg_text => 'derive_val_res_job_details failed.' ,
2113: p_stmt_num => l_stmt_num ,
2114: p_msg_tokens => l_msg_tokens,
2115: p_fnd_msg_level => G_MSG_LVL_ERROR ,
2128:
2129: /* Log the Procedure exit point.... */
2130: if( g_log_level_statement >= l_log_level ) then
2131: l_msg_tokens.delete;
2132: WSM_log_PVT.logMessage(p_module_name => l_module ,
2133: p_msg_text => 'Validation of the resulting jobs details ... Success',
2134: p_stmt_num => l_stmt_num ,
2135: p_msg_tokens => l_msg_tokens,
2136: p_fnd_log_level => g_log_level_statement,
2151:
2152: /* Log the Procedure entry point....proc entry */
2153: if( g_log_level_statement >= l_log_level ) then
2154: l_msg_tokens.delete;
2155: WSM_log_PVT.logMessage(p_module_name => l_module ,
2156: p_msg_text => 'Calling WWSMPJUPD.PROCESS_LOTS : Transaction Id : ' || l_txn_id ,
2157: p_stmt_num => l_stmt_num,
2158: p_msg_tokens => l_msg_tokens,
2159: p_fnd_log_level => g_log_level_statement,
2177:
2178: /* Log the Procedure exit point....proc exit */
2179: if( g_log_level_statement >= l_log_level ) then
2180: l_msg_tokens.delete;
2181: WSM_log_PVT.logMessage(p_module_name => l_module ,
2182: p_msg_text => 'Returning from WWSMPJUPD.PROCESS_LOTS',
2183: p_stmt_num => l_stmt_num ,
2184: p_msg_tokens => l_msg_tokens,
2185: p_fnd_log_level => g_log_level_statement,
2191: /* Txn errored....*/
2192: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
2193:
2194: l_msg_tokens.delete;
2195: WSM_log_PVT.logMessage(p_module_name => l_module ,
2196: p_msg_text => 'PROCESS_LOTS failed.' ,
2197: p_stmt_num => l_stmt_num ,
2198: p_msg_tokens => l_msg_tokens,
2199: p_fnd_msg_level => G_MSG_LVL_ERROR ,
2215:
2216: /* Log the Procedure exit point.... */
2217: if( g_log_level_statement >= l_log_level ) then
2218: l_msg_tokens.delete;
2219: WSM_log_PVT.logMessage(p_module_name => l_module ,
2220: p_msg_text => 'Processing of the WIp Lot Transaction ... Success',
2221: p_stmt_num => l_stmt_num ,
2222: p_msg_tokens => l_msg_tokens,
2223: p_fnd_log_level => g_log_level_statement,
2233: COMMIT;
2234: /* Log the Procedure exit point.... */
2235: if( g_log_level_statement >= l_log_level ) then
2236: l_msg_tokens.delete;
2237: WSM_log_PVT.logMessage(p_module_name => l_module ,
2238: p_msg_text => 'Wip Lot Transaction ... Commit complete',
2239: p_stmt_num => l_stmt_num ,
2240: p_msg_tokens => l_msg_tokens,
2241: p_fnd_log_level => g_log_level_statement,
2276:
2277: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
2278: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
2279: THEN
2280: WSM_log_PVT.handle_others( p_module_name => l_module ,
2281: p_stmt_num => l_stmt_num ,
2282: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
2283: p_run_log_level => l_log_level
2284: );
2314: /* Other locals */
2315: l_txn_id NUMBER;
2316:
2317: -- Logging variables.....
2318: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
2319: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2320:
2321: l_stmt_num NUMBER;
2322: l_module VARCHAR2(100) := 'wsm.plsql.WSM_WIP_LOT_TXN_PVT.UPDATE_ASSEMBLY_TXN';
2380: /* Incompatible versions...*/
2381: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
2382:
2383: l_msg_tokens.delete;
2384: WSM_log_PVT.logMessage(p_module_name => l_module ,
2385: p_msg_text => 'Incompatible API called for Upd Assy Txn',
2386: p_stmt_num => l_stmt_num ,
2387: p_msg_tokens => l_msg_tokens,
2388: p_fnd_msg_level => G_MSG_LVL_ERROR ,
2409:
2410: /* Log the Procedure entry point....proc level */
2411: if( g_log_level_statement >= l_log_level ) then
2412: l_msg_tokens.delete;
2413: WSM_log_PVT.logMessage(p_module_name => l_module ,
2414: p_msg_text => 'Calling WSM_WLT_VALIDATE_PVT.validate_txn_details',
2415: p_stmt_num => l_stmt_num ,
2416: p_msg_tokens => l_msg_tokens,
2417: p_fnd_log_level => g_log_level_statement,
2428: /* End header Validation */
2429: /* Log the Procedure exit point.... */
2430: if( g_log_level_statement >= l_log_level ) then
2431: l_msg_tokens.delete;
2432: WSM_log_PVT.logMessage(p_module_name => l_module ,
2433: p_msg_text => 'Returning from WSM_WLT_VALIDATE_PVT.validate_txn_header',
2434: p_stmt_num => l_stmt_num ,
2435: p_msg_tokens => l_msg_tokens,
2436: p_fnd_log_level => g_log_level_statement,
2442: /* Txn errored....*/
2443: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
2444:
2445: l_msg_tokens.delete;
2446: WSM_log_PVT.logMessage(p_module_name => l_module ,
2447: p_msg_text => 'validate_txn_header failed.' ,
2448: p_stmt_num => l_stmt_num ,
2449: p_msg_tokens => l_msg_tokens,
2450: p_fnd_msg_level => G_MSG_LVL_ERROR ,
2463:
2464: /* Log the Procedure exit point.... */
2465: if( g_log_level_statement >= l_log_level ) then
2466: l_msg_tokens.delete;
2467: WSM_log_PVT.logMessage(p_module_name => l_module ,
2468: p_msg_text => 'Validated the Transaction Header Information .... Success ' ,
2469: p_stmt_num => l_stmt_num ,
2470: p_msg_tokens => l_msg_tokens,
2471: p_fnd_log_level => g_log_level_statement,
2478: /* Here we actually call the code to default the job details... */
2479: /* Log the Procedure entry point....proc lvl */
2480: if( g_log_level_statement >= l_log_level ) then
2481: l_msg_tokens.delete;
2482: WSM_log_PVT.logMessage(p_module_name => l_module ,
2483: p_msg_text => 'Calling WSM_WLT_VALIDATE_PVT.default_starting_job_details',
2484: p_stmt_num => l_stmt_num ,
2485: p_msg_tokens => l_msg_tokens,
2486: p_fnd_log_level => g_log_level_statement,
2500:
2501: /* Log the Procedure exit point.... */
2502: if( g_log_level_statement >= l_log_level ) then
2503: l_msg_tokens.delete;
2504: WSM_log_PVT.logMessage(p_module_name => l_module ,
2505: p_msg_text => 'Returning from WSM_WLT_VALIDATE_PVT.default_starting_job_details',
2506: p_stmt_num => l_stmt_num ,
2507: p_msg_tokens => l_msg_tokens,
2508: p_fnd_log_level => g_log_level_statement,
2514: /* Txn errored....*/
2515: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
2516:
2517: l_msg_tokens.delete;
2518: WSM_log_PVT.logMessage(p_module_name => l_module ,
2519: p_msg_text => 'derive_val_st_job_details failed.' ,
2520: p_stmt_num => l_stmt_num ,
2521: p_msg_tokens => l_msg_tokens,
2522: p_fnd_msg_level => G_MSG_LVL_ERROR ,
2535:
2536: /* Log the Procedure exit point.... */
2537: if( g_log_level_statement >= l_log_level ) then
2538: l_msg_tokens.delete;
2539: WSM_log_PVT.logMessage(p_module_name => l_module ,
2540: p_msg_text => 'Defaulting the starting job details ... Success ',
2541: p_stmt_num => l_stmt_num ,
2542: p_msg_tokens => l_msg_tokens,
2543: p_fnd_log_level => g_log_level_statement,
2549:
2550: /* Log the Procedure entry point....proc lvl */
2551: if( g_log_level_statement >= l_log_level ) then
2552: l_msg_tokens.delete;
2553: WSM_log_PVT.logMessage(p_module_name => l_module ,
2554: p_msg_text => 'Calling WSM_WLT_VALIDATE_PVT.validate_resulting_job ',
2555: p_stmt_num => l_stmt_num ,
2556: p_msg_tokens => l_msg_tokens,
2557: p_fnd_log_level => g_log_level_statement,
2573:
2574: /* Log the Procedure exit point....proc lvl */
2575: if( g_log_level_statement >= l_log_level ) then
2576: l_msg_tokens.delete;
2577: WSM_log_PVT.logMessage(p_module_name => l_module ,
2578: p_msg_text => 'Returning from WSM_WLT_VALIDATE_PVT.validate_resulting_job',
2579: p_stmt_num => l_stmt_num ,
2580: p_msg_tokens => l_msg_tokens,
2581: p_fnd_log_level => g_log_level_statement,
2587: /* Txn errored....*/
2588: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
2589:
2590: l_msg_tokens.delete;
2591: WSM_log_PVT.logMessage(p_module_name => l_module ,
2592: p_msg_text => 'derive_val_res_job_details failed.' ,
2593: p_stmt_num => l_stmt_num ,
2594: p_msg_tokens => l_msg_tokens,
2595: p_fnd_msg_level => G_MSG_LVL_ERROR ,
2608:
2609: /* Log the Procedure exit point.... */
2610: if( g_log_level_statement >= l_log_level ) then
2611: l_msg_tokens.delete;
2612: WSM_log_PVT.logMessage(p_module_name => l_module ,
2613: p_msg_text => 'Validation of the resulting jobs details ... Success',
2614: p_stmt_num => l_stmt_num ,
2615: p_msg_tokens => l_msg_tokens,
2616: p_fnd_log_level => g_log_level_statement,
2623:
2624: /* Log the Procedure entry point.... */
2625: if( g_log_level_statement >= l_log_level ) then
2626: l_msg_tokens.delete;
2627: WSM_log_PVT.logMessage(p_module_name => l_module ,
2628: p_msg_text => 'Calling WWSMPJUPD.PROCESS_LOTS : Transaction Id : ' || l_txn_id ,
2629: p_stmt_num => l_stmt_num ,
2630: p_msg_tokens => l_msg_tokens,
2631: p_fnd_log_level => g_log_level_statement,
2651:
2652: /* Log the Procedure exit point.... */
2653: if( g_log_level_statement >= l_log_level ) then
2654: l_msg_tokens.delete;
2655: WSM_log_PVT.logMessage(p_module_name => l_module ,
2656: p_msg_text => 'Returning from WWSMPJUPD.PROCESS_LOTS',
2657: p_stmt_num => l_stmt_num ,
2658: p_msg_tokens => l_msg_tokens,
2659: p_fnd_log_level => g_log_level_statement,
2665: /* Txn errored....*/
2666: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
2667:
2668: l_msg_tokens.delete;
2669: WSM_log_PVT.logMessage(p_module_name => l_module ,
2670: p_msg_text => 'PROCESS_LOTS failed.' ,
2671: p_stmt_num => l_stmt_num ,
2672: p_msg_tokens => l_msg_tokens,
2673: p_fnd_msg_level => G_MSG_LVL_ERROR ,
2690:
2691: /* Log the Procedure exit point.... */
2692: if( g_log_level_statement >= l_log_level ) then
2693: l_msg_tokens.delete;
2694: WSM_log_PVT.logMessage(p_module_name => l_module ,
2695: p_msg_text => 'Processing of the WIp Lot Transaction ... Success',
2696: p_stmt_num => l_stmt_num ,
2697: p_msg_tokens => l_msg_tokens,
2698: p_fnd_log_level => g_log_level_statement,
2708: COMMIT;
2709: /* Log the Procedure exit point....event */
2710: if( g_log_level_statement >= l_log_level ) then
2711: l_msg_tokens.delete;
2712: WSM_log_PVT.logMessage(p_module_name => l_module ,
2713: p_msg_text => 'Wip Lot Transaction ... Commit complete',
2714: p_stmt_num => l_stmt_num ,
2715: p_msg_tokens => l_msg_tokens,
2716: p_fnd_log_level => g_log_level_statement,
2751:
2752: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
2753: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
2754: THEN
2755: WSM_log_PVT.handle_others( p_module_name => l_module ,
2756: p_stmt_num => l_stmt_num ,
2757: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
2758: p_run_log_level => l_log_level
2759: );
2790: /* Other locals */
2791: l_txn_id NUMBER;
2792:
2793: -- Logging variables.....
2794: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
2795: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2796:
2797: l_stmt_num NUMBER;
2798: l_module VARCHAR2(100) := 'wsm.plsql.WSM_WIP_LOT_TXN_PVT.UPDATE_ROUTING_TXN';
2857: /* Incompatible versions...*/
2858: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
2859:
2860: l_msg_tokens.delete;
2861: WSM_log_PVT.logMessage(p_module_name => l_module ,
2862: p_msg_text => 'Incompatible API called for Upd Routing Txn',
2863: p_stmt_num => l_stmt_num ,
2864: p_msg_tokens => l_msg_tokens,
2865: p_fnd_msg_level => G_MSG_LVL_ERROR ,
2885:
2886: /* Log the Procedure entry point....proc */
2887: if( g_log_level_statement >= l_log_level ) then
2888: l_msg_tokens.delete;
2889: WSM_log_PVT.logMessage(p_module_name => l_module ,
2890: p_msg_text => 'Calling WSM_WLT_VALIDATE_PVT.validate_txn_details',
2891: p_stmt_num => l_stmt_num ,
2892: p_msg_tokens => l_msg_tokens,
2893: p_fnd_log_level => g_log_level_statement,
2904: /* End header Validation */
2905: /* Log the Procedure exit point.... */
2906: if( g_log_level_statement >= l_log_level ) then
2907: l_msg_tokens.delete;
2908: WSM_log_PVT.logMessage(p_module_name => l_module ,
2909: p_msg_text => 'Returning from WSM_WLT_VALIDATE_PVT.validate_txn_header',
2910: p_stmt_num => l_stmt_num ,
2911: p_msg_tokens => l_msg_tokens,
2912: p_fnd_log_level => g_log_level_statement,
2918: /* Txn errored....*/
2919: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
2920:
2921: l_msg_tokens.delete;
2922: WSM_log_PVT.logMessage(p_module_name => l_module ,
2923: p_msg_text => 'validate_txn_header failed.' ,
2924: p_stmt_num => l_stmt_num ,
2925: p_msg_tokens => l_msg_tokens,
2926: p_fnd_msg_level => G_MSG_LVL_ERROR ,
2939:
2940: /* Log the Procedure exit point.... */
2941: if( g_log_level_statement >= l_log_level ) then
2942: l_msg_tokens.delete;
2943: WSM_log_PVT.logMessage(p_module_name => l_module ,
2944: p_msg_text => 'Validated the Transaction Header Information .... Success ' ,
2945: p_stmt_num => l_stmt_num ,
2946: p_msg_tokens => l_msg_tokens,
2947: p_fnd_log_level => g_log_level_statement,
2954: /* Here we actually call the code to default the job details... */
2955: /* Log the Procedure entry point.... */
2956: if( g_log_level_statement >= l_log_level ) then
2957: l_msg_tokens.delete;
2958: WSM_log_PVT.logMessage(p_module_name => l_module ,
2959: p_msg_text => 'Calling WSM_WLT_VALIDATE_PVT.default_starting_job_details',
2960: p_stmt_num => l_stmt_num ,
2961: p_msg_tokens => l_msg_tokens,
2962: p_fnd_log_level => g_log_level_statement,
2976:
2977: /* Log the Procedure exit point.... */
2978: if( g_log_level_statement >= l_log_level ) then
2979: l_msg_tokens.delete;
2980: WSM_log_PVT.logMessage(p_module_name => l_module ,
2981: p_msg_text => 'Returning from WSM_WLT_VALIDATE_PVT.default_starting_job_details',
2982: p_stmt_num => l_stmt_num ,
2983: p_msg_tokens => l_msg_tokens,
2984: p_fnd_log_level => g_log_level_statement,
2990: /* Txn errored....*/
2991: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
2992:
2993: l_msg_tokens.delete;
2994: WSM_log_PVT.logMessage(p_module_name => l_module ,
2995: p_msg_text => 'derive_val_st_job_details failed.' ,
2996: p_stmt_num => l_stmt_num ,
2997: p_msg_tokens => l_msg_tokens,
2998: p_fnd_msg_level => G_MSG_LVL_ERROR ,
3011:
3012: /* Log the Procedure exit point....event */
3013: if( g_log_level_statement >= l_log_level ) then
3014: l_msg_tokens.delete;
3015: WSM_log_PVT.logMessage(p_module_name => l_module ,
3016: p_msg_text => 'Defaulting the starting job details ... Success ',
3017: p_stmt_num => l_stmt_num ,
3018: p_msg_tokens => l_msg_tokens,
3019: p_fnd_log_level => g_log_level_statement,
3025:
3026: /* Log the Procedure entry point.... */
3027: if( g_log_level_statement >= l_log_level ) then
3028: l_msg_tokens.delete;
3029: WSM_log_PVT.logMessage(p_module_name => l_module ,
3030: p_msg_text => 'Calling WSM_WLT_VALIDATE_PVT.validate_resulting_job ',
3031: p_stmt_num => l_stmt_num ,
3032: p_msg_tokens => l_msg_tokens,
3033: p_fnd_log_level => g_log_level_statement,
3049:
3050: /* Log the Procedure exit point.... */
3051: if( g_log_level_statement >= l_log_level ) then
3052: l_msg_tokens.delete;
3053: WSM_log_PVT.logMessage(p_module_name => l_module ,
3054: p_msg_text => 'Returning from WSM_WLT_VALIDATE_PVT.validate_resulting_job',
3055: p_stmt_num => l_stmt_num ,
3056: p_msg_tokens => l_msg_tokens,
3057: p_fnd_log_level => g_log_level_statement,
3065: /* Txn errored....*/
3066: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
3067:
3068: l_msg_tokens.delete;
3069: WSM_log_PVT.logMessage(p_module_name => l_module ,
3070: p_msg_text => 'derive_val_res_job_details failed.' ,
3071: p_stmt_num => l_stmt_num ,
3072: p_msg_tokens => l_msg_tokens,
3073: p_fnd_msg_level => G_MSG_LVL_ERROR ,
3086:
3087: /* Log the Procedure exit point.... event*/
3088: if( g_log_level_statement >= l_log_level ) then
3089: l_msg_tokens.delete;
3090: WSM_log_PVT.logMessage(p_module_name => l_module ,
3091: p_msg_text => 'Validation of the resulting jobs details ... Success',
3092: p_stmt_num => l_stmt_num ,
3093: p_msg_tokens => l_msg_tokens,
3094: p_fnd_log_level => g_log_level_statement,
3102:
3103: /* Log the Procedure entry point.... */
3104: if( g_log_level_statement >= l_log_level ) then
3105: l_msg_tokens.delete;
3106: WSM_log_PVT.logMessage(p_module_name => l_module ,
3107: p_msg_text => 'Calling WWSMPJUPD.PROCESS_LOTS : Transaction Id : ' || l_txn_id ,
3108: p_stmt_num => l_stmt_num ,
3109: p_msg_tokens => l_msg_tokens,
3110: p_fnd_log_level => g_log_level_statement,
3130:
3131: /* Log the Procedure exit point.... */
3132: if( g_log_level_statement >= l_log_level ) then
3133: l_msg_tokens.delete;
3134: WSM_log_PVT.logMessage(p_module_name => l_module ,
3135: p_msg_text => 'Returning from WWSMPJUPD.PROCESS_LOTS',
3136: p_stmt_num => l_stmt_num ,
3137: p_msg_tokens => l_msg_tokens,
3138: p_fnd_log_level => g_log_level_statement,
3144: /* Txn errored....*/
3145: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
3146:
3147: l_msg_tokens.delete;
3148: WSM_log_PVT.logMessage(p_module_name => l_module ,
3149: p_msg_text => 'PROCESS_LOTS failed.' ,
3150: p_stmt_num => l_stmt_num ,
3151: p_msg_tokens => l_msg_tokens,
3152: p_fnd_msg_level => G_MSG_LVL_ERROR ,
3169:
3170: /* Log the Procedure exit point.... event*/
3171: if( g_log_level_statement >= l_log_level ) then
3172: l_msg_tokens.delete;
3173: WSM_log_PVT.logMessage(p_module_name => l_module ,
3174: p_msg_text => 'Processing of the WIp Lot Transaction ... Success',
3175: p_stmt_num => l_stmt_num ,
3176: p_msg_tokens => l_msg_tokens,
3177: p_fnd_log_level => g_log_level_statement,
3186: COMMIT;
3187: /* Log the Procedure exit point....event */
3188: if( g_log_level_statement >= l_log_level ) then
3189: l_msg_tokens.delete;
3190: WSM_log_PVT.logMessage(p_module_name => l_module ,
3191: p_msg_text => 'Wip Lot Transaction ... Commit complete',
3192: p_stmt_num => l_stmt_num ,
3193: p_msg_tokens => l_msg_tokens,
3194: p_fnd_log_level => g_log_level_statement,
3226:
3227: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
3228: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
3229: THEN
3230: WSM_log_PVT.handle_others( p_module_name => l_module ,
3231: p_stmt_num => l_stmt_num ,
3232: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
3233: p_run_log_level => l_log_level
3234: );
3263: /* Other locals */
3264: l_txn_id NUMBER;
3265:
3266: -- Logging variables.....
3267: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
3268: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3269:
3270: l_stmt_num NUMBER;
3271: l_module VARCHAR2(100) := 'wsm.plsql.WSM_WIP_LOT_TXN_PVT.UPDATE_QUANTITY_TXN';
3329: /* Incompatible versions...*/
3330: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
3331:
3332: l_msg_tokens.delete;
3333: WSM_log_PVT.logMessage(p_module_name => l_module ,
3334: p_msg_text => 'Incompatible API called for Upd Qty Txn',
3335: p_stmt_num => l_stmt_num ,
3336: p_msg_tokens => l_msg_tokens,
3337: p_fnd_msg_level => G_MSG_LVL_ERROR ,
3359:
3360: /* Log the Procedure entry point....proc level */
3361: if( g_log_level_statement >= l_log_level ) then
3362: l_msg_tokens.delete;
3363: WSM_log_PVT.logMessage(p_module_name => l_module ,
3364: p_msg_text => 'Calling WSM_WLT_VALIDATE_PVT.validate_txn_details',
3365: p_stmt_num => l_stmt_num ,
3366: p_msg_tokens => l_msg_tokens,
3367: p_fnd_log_level => g_log_level_statement,
3378: /* End header Validation */
3379: /* Log the Procedure exit point.... */
3380: if( g_log_level_statement >= l_log_level ) then
3381: l_msg_tokens.delete;
3382: WSM_log_PVT.logMessage(p_module_name => l_module ,
3383: p_msg_text => 'Returning from WSM_WLT_VALIDATE_PVT.validate_txn_header',
3384: p_stmt_num => l_stmt_num ,
3385: p_msg_tokens => l_msg_tokens,
3386: p_fnd_log_level => g_log_level_statement,
3392: /* Txn errored....*/
3393: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
3394:
3395: l_msg_tokens.delete;
3396: WSM_log_PVT.logMessage(p_module_name => l_module ,
3397: p_msg_text => 'validate_txn_header failed.' ,
3398: p_stmt_num => l_stmt_num ,
3399: p_msg_tokens => l_msg_tokens,
3400: p_fnd_msg_level => G_MSG_LVL_ERROR ,
3413:
3414: /* Log the Procedure exit point.... */
3415: if( g_log_level_statement >= l_log_level ) then
3416: l_msg_tokens.delete;
3417: WSM_log_PVT.logMessage(p_module_name => l_module ,
3418: p_msg_text => 'Validated the Transaction Header Information .... Success ' ,
3419: p_stmt_num => l_stmt_num ,
3420: p_msg_tokens => l_msg_tokens,
3421: p_fnd_log_level => g_log_level_statement,
3428: /* Here we actually call the code to default the job details... */
3429: /* Log the Procedure entry point.... */
3430: if( g_log_level_statement >= l_log_level ) then
3431: l_msg_tokens.delete;
3432: WSM_log_PVT.logMessage(p_module_name => l_module ,
3433: p_msg_text => 'Calling WSM_WLT_VALIDATE_PVT.default_starting_job_details',
3434: p_stmt_num => l_stmt_num ,
3435: p_msg_tokens => l_msg_tokens,
3436: p_fnd_log_level => g_log_level_statement,
3450:
3451: /* Log the Procedure exit point.... */
3452: if( g_log_level_statement >= l_log_level ) then
3453: l_msg_tokens.delete;
3454: WSM_log_PVT.logMessage(p_module_name => l_module ,
3455: p_msg_text => 'Returning from WSM_WLT_VALIDATE_PVT.default_starting_job_details',
3456: p_stmt_num => l_stmt_num ,
3457: p_msg_tokens => l_msg_tokens,
3458: p_fnd_log_level => g_log_level_statement,
3464: /* Txn errored....*/
3465: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
3466:
3467: l_msg_tokens.delete;
3468: WSM_log_PVT.logMessage(p_module_name => l_module ,
3469: p_msg_text => 'derive_val_st_job_details failed.' ,
3470: p_stmt_num => l_stmt_num ,
3471: p_msg_tokens => l_msg_tokens,
3472: p_fnd_msg_level => G_MSG_LVL_ERROR ,
3485:
3486: /* Log the Procedure exit point.... */
3487: if (g_log_level_statement >= l_log_level ) then
3488: l_msg_tokens.delete;
3489: WSM_log_PVT.logMessage(p_module_name => l_module ,
3490: p_msg_text => 'Defaulting the starting job details ... Success ',
3491: p_stmt_num => l_stmt_num ,
3492: p_msg_tokens => l_msg_tokens,
3493: p_fnd_log_level => g_log_level_statement,
3499:
3500: /* Log the Procedure entry point.... */
3501: if( g_log_level_statement >= l_log_level ) then
3502: l_msg_tokens.delete;
3503: WSM_log_PVT.logMessage(p_module_name => l_module ,
3504: p_msg_text => 'Calling WSM_WLT_VALIDATE_PVT.validate_resulting_job ',
3505: p_stmt_num => l_stmt_num ,
3506: p_msg_tokens => l_msg_tokens,
3507: p_fnd_log_level => g_log_level_statement,
3523:
3524: /* Log the Procedure exit point.... */
3525: if( g_log_level_statement >= l_log_level ) then
3526: l_msg_tokens.delete;
3527: WSM_log_PVT.logMessage(p_module_name => l_module ,
3528: p_msg_text => 'Returning from WSM_WLT_VALIDATE_PVT.validate_resulting_job',
3529: p_stmt_num => l_stmt_num ,
3530: p_msg_tokens => l_msg_tokens,
3531: p_fnd_log_level => g_log_level_statement,
3538: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
3539:
3540: l_msg_tokens.delete;
3541: /* Bugfix 5352389 changed fnd_log_level from ERROR to STATEMENT */
3542: WSM_log_PVT.logMessage(p_module_name => l_module ,
3543: p_msg_text => 'derive_val_res_job_details failed.' ,
3544: p_stmt_num => l_stmt_num ,
3545: p_msg_tokens => l_msg_tokens,
3546: p_fnd_msg_level => G_MSG_LVL_ERROR ,
3559:
3560: /* Log the Procedure exit point....event */
3561: if( g_log_level_statement >= l_log_level ) then
3562: l_msg_tokens.delete;
3563: WSM_log_PVT.logMessage(p_module_name => l_module ,
3564: p_msg_text => 'Validation of the resulting jobs details ... Success',
3565: p_stmt_num => l_stmt_num ,
3566: p_msg_tokens => l_msg_tokens,
3567: p_fnd_log_level => g_log_level_statement,
3577:
3578: /* Log the Procedure entry point.... */
3579: if( g_log_level_statement >= l_log_level ) then
3580: l_msg_tokens.delete;
3581: WSM_log_PVT.logMessage(p_module_name => l_module ,
3582: p_msg_text => 'Calling WWSMPJUPD.PROCESS_LOTS : Transaction Id : ' || l_txn_id ,
3583: p_stmt_num => l_stmt_num ,
3584: p_msg_tokens => l_msg_tokens,
3585: p_fnd_log_level => g_log_level_statement,
3605:
3606: /* Log the Procedure exit point.... */
3607: if( g_log_level_statement >= l_log_level ) then
3608: l_msg_tokens.delete;
3609: WSM_log_PVT.logMessage(p_module_name => l_module ,
3610: p_msg_text => 'Returning from WWSMPJUPD.PROCESS_LOTS',
3611: p_stmt_num => l_stmt_num ,
3612: p_msg_tokens => l_msg_tokens,
3613: p_fnd_log_level => g_log_level_statement,
3619: /* Txn errored....*/
3620: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
3621:
3622: l_msg_tokens.delete;
3623: WSM_log_PVT.logMessage(p_module_name => l_module ,
3624: p_msg_text => 'PROCESS_LOTS failed.' ,
3625: p_stmt_num => l_stmt_num ,
3626: p_msg_tokens => l_msg_tokens,
3627: p_fnd_msg_level => G_MSG_LVL_ERROR ,
3644:
3645: /* Log the Procedure exit point.... */
3646: if( g_log_level_statement >= l_log_level ) then
3647: l_msg_tokens.delete;
3648: WSM_log_PVT.logMessage(p_module_name => l_module ,
3649: p_msg_text => 'Processing of the WIp Lot Transaction ... Success',
3650: p_stmt_num => l_stmt_num ,
3651: p_msg_tokens => l_msg_tokens,
3652: p_fnd_log_level => g_log_level_statement,
3661: COMMIT;
3662: /* Log the Procedure exit point....event */
3663: if( g_log_level_statement >= l_log_level ) then
3664: l_msg_tokens.delete;
3665: WSM_log_PVT.logMessage(p_module_name => l_module ,
3666: p_msg_text => 'Wip Lot Transaction ... Commit complete',
3667: p_stmt_num => l_stmt_num ,
3668: p_msg_tokens => l_msg_tokens,
3669: p_fnd_log_level => g_log_level_statement,
3703:
3704: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
3705: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
3706: THEN
3707: WSM_log_PVT.handle_others( p_module_name => l_module ,
3708: p_stmt_num => l_stmt_num ,
3709: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
3710: p_run_log_level => l_log_level
3711: );
3739: /* Other locals */
3740: l_txn_id NUMBER;
3741:
3742: -- Logging variables.....
3743: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
3744: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3745:
3746: l_stmt_num NUMBER;
3747: l_module VARCHAR2(100) :='wsm.plsql.WSM_WIP_LOT_TXN_PVT.UPDATE_LOTNAME_TXN';
3764:
3765: /* Log the Procedure entry point.... */
3766: if( g_log_level_statement >= l_log_level ) then
3767: l_msg_tokens.delete;
3768: WSM_log_PVT.logMessage(p_module_name => l_module ,
3769: p_msg_text => 'Entering the Update Lotname Txn API',
3770: p_stmt_num => l_stmt_num ,
3771: p_msg_tokens => l_msg_tokens,
3772: p_fnd_log_level => g_log_level_statement,
3783: FND_MSG_PUB.initialize;
3784: /* Message list enabled....-- EVENT */
3785: if( g_log_level_statement >= l_log_level ) then
3786: l_msg_tokens.delete;
3787: WSM_log_PVT.logMessage(p_module_name => l_module ,
3788: p_msg_text => 'Message Table Initialized',
3789: p_stmt_num => l_stmt_num ,
3790: p_msg_tokens => l_msg_tokens,
3791: p_fnd_log_level => g_log_level_statement,
3806: /* Incompatible versions...*/
3807: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
3808:
3809: l_msg_tokens.delete;
3810: WSM_log_PVT.logMessage(p_module_name => l_module ,
3811: p_msg_text => 'Incompatible API called for Upd Lotname Txn',
3812: p_stmt_num => l_stmt_num ,
3813: p_msg_tokens => l_msg_tokens,
3814: p_fnd_msg_level => G_MSG_LVL_ERROR ,
3829:
3830: /* Log the Procedure entry point.... */
3831: if( g_log_level_statement >= l_log_level ) then
3832: l_msg_tokens.delete;
3833: WSM_log_PVT.logMessage(p_module_name => l_module ,
3834: p_msg_text => 'Calling WSM_WLT_VALIDATE_PVT.validate_txn_details',
3835: p_stmt_num => l_stmt_num ,
3836: p_msg_tokens => l_msg_tokens,
3837: p_fnd_log_level => g_log_level_statement,
3848: /* End header Validation */
3849: /* Log the Procedure exit point.... */
3850: if( g_log_level_statement >= l_log_level ) then
3851: l_msg_tokens.delete;
3852: WSM_log_PVT.logMessage(p_module_name => l_module ,
3853: p_msg_text => 'Returning from WSM_WLT_VALIDATE_PVT.validate_txn_header',
3854: p_stmt_num => l_stmt_num ,
3855: p_msg_tokens => l_msg_tokens,
3856: p_fnd_log_level => g_log_level_statement,
3862: /* Txn errored....*/
3863: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
3864:
3865: l_msg_tokens.delete;
3866: WSM_log_PVT.logMessage(p_module_name => l_module ,
3867: p_msg_text => 'validate_txn_header failed.' ,
3868: p_stmt_num => l_stmt_num ,
3869: p_msg_tokens => l_msg_tokens,
3870: p_fnd_msg_level => G_MSG_LVL_ERROR ,
3883:
3884: /* Log the Procedure exit point.... */
3885: if( g_log_level_statement >= l_log_level ) then
3886: l_msg_tokens.delete;
3887: WSM_log_PVT.logMessage(p_module_name => l_module ,
3888: p_msg_text => 'Validated the Transaction Header Information .... Success ' ,
3889: p_stmt_num => l_stmt_num ,
3890: p_msg_tokens => l_msg_tokens,
3891: p_fnd_log_level => g_log_level_statement,
3898: /* Here we actually call the code to default the job details... */
3899: /* Log the Procedure entry point.... */
3900: if( g_log_level_statement >= l_log_level ) then
3901: l_msg_tokens.delete;
3902: WSM_log_PVT.logMessage(p_module_name => l_module ,
3903: p_msg_text => 'Calling WSM_WLT_VALIDATE_PVT.default_starting_job_details',
3904: p_stmt_num => l_stmt_num ,
3905: p_msg_tokens => l_msg_tokens,
3906: p_fnd_log_level => g_log_level_statement,
3920:
3921: /* Log the Procedure exit point.... */
3922: if( g_log_level_statement >= l_log_level ) then
3923: l_msg_tokens.delete;
3924: WSM_log_PVT.logMessage(p_module_name => l_module ,
3925: p_msg_text => 'Returning from WSM_WLT_VALIDATE_PVT.default_starting_job_details',
3926: p_stmt_num => l_stmt_num ,
3927: p_msg_tokens => l_msg_tokens,
3928: p_fnd_log_level => g_log_level_statement,
3934: /* Txn errored....*/
3935: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
3936:
3937: l_msg_tokens.delete;
3938: WSM_log_PVT.logMessage(p_module_name => l_module ,
3939: p_msg_text => 'derive_val_st_job_details failed.' ,
3940: p_stmt_num => l_stmt_num ,
3941: p_msg_tokens => l_msg_tokens,
3942: p_fnd_msg_level => G_MSG_LVL_ERROR ,
3955:
3956: /* Log the Procedure exit point.... */
3957: if( g_log_level_statement >= l_log_level ) then
3958: l_msg_tokens.delete;
3959: WSM_log_PVT.logMessage(p_module_name => l_module ,
3960: p_msg_text => 'Defaulting the starting job details ... Success ',
3961: p_stmt_num => l_stmt_num ,
3962: p_msg_tokens => l_msg_tokens,
3963: p_fnd_log_level => g_log_level_statement,
3969:
3970: /* Log the Procedure entry point.... */
3971: if( g_log_level_statement >= l_log_level ) then
3972: l_msg_tokens.delete;
3973: WSM_log_PVT.logMessage(p_module_name => l_module ,
3974: p_msg_text => 'Calling WSM_WLT_VALIDATE_PVT.validate_resulting_job ',
3975: p_stmt_num => l_stmt_num ,
3976: p_msg_tokens => l_msg_tokens,
3977: p_fnd_log_level => g_log_level_statement,
3993:
3994: /* Log the Procedure exit point.... */
3995: if( g_log_level_statement >= l_log_level ) then
3996: l_msg_tokens.delete;
3997: WSM_log_PVT.logMessage(p_module_name => l_module ,
3998: p_msg_text => 'Returning from WSM_WLT_VALIDATE_PVT.validate_resulting_job',
3999: p_stmt_num => l_stmt_num ,
4000: p_msg_tokens => l_msg_tokens,
4001: p_fnd_log_level => g_log_level_statement,
4007: /* Txn errored....*/
4008: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
4009:
4010: l_msg_tokens.delete;
4011: WSM_log_PVT.logMessage(p_module_name => l_module ,
4012: p_msg_text => 'derive_val_res_job_details failed.' ,
4013: p_stmt_num => l_stmt_num ,
4014: p_msg_tokens => l_msg_tokens,
4015: p_fnd_msg_level => G_MSG_LVL_ERROR ,
4028:
4029: /* Log the Procedure exit point.... event*/
4030: if( g_log_level_statement >= l_log_level ) then
4031: l_msg_tokens.delete;
4032: WSM_log_PVT.logMessage(p_module_name => l_module ,
4033: p_msg_text => 'Validation of the resulting jobs details ... Success',
4034: p_stmt_num => l_stmt_num ,
4035: p_msg_tokens => l_msg_tokens,
4036: p_fnd_log_level => g_log_level_statement,
4048:
4049: /* Log the Procedure entry point.... */
4050: if( g_log_level_statement >= l_log_level ) then
4051: l_msg_tokens.delete;
4052: WSM_log_PVT.logMessage(p_module_name => l_module ,
4053: p_msg_text => 'Calling WWSMPJUPD.PROCESS_LOTS : Transaction Id : ' || l_txn_id ,
4054: p_stmt_num => l_stmt_num ,
4055: p_msg_tokens => l_msg_tokens,
4056: p_fnd_log_level => g_log_level_statement,
4076:
4077: /* Log the Procedure exit point.... */
4078: if( g_log_level_statement >= l_log_level ) then
4079: l_msg_tokens.delete;
4080: WSM_log_PVT.logMessage(p_module_name => l_module ,
4081: p_msg_text => 'Returning from WWSMPJUPD.PROCESS_LOTS',
4082: p_stmt_num => l_stmt_num ,
4083: p_msg_tokens => l_msg_tokens,
4084: p_fnd_log_level => g_log_level_statement,
4090: /* Txn errored....*/
4091: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
4092:
4093: l_msg_tokens.delete;
4094: WSM_log_PVT.logMessage(p_module_name => l_module ,
4095: p_msg_text => 'PROCESS_LOTS failed.' ,
4096: p_stmt_num => l_stmt_num ,
4097: p_msg_tokens => l_msg_tokens,
4098: p_fnd_msg_level => G_MSG_LVL_ERROR ,
4115:
4116: /* Log the Procedure exit point.... event*/
4117: if( g_log_level_statement >= l_log_level ) then
4118: l_msg_tokens.delete;
4119: WSM_log_PVT.logMessage(p_module_name => l_module ,
4120: p_msg_text => 'Processing of the WIp Lot Transaction ... Success',
4121: p_stmt_num => l_stmt_num ,
4122: p_msg_tokens => l_msg_tokens,
4123: p_fnd_log_level => g_log_level_statement,
4132: COMMIT;
4133: /* Log the Procedure exit point....event */
4134: if( g_log_level_statement >= l_log_level ) then
4135: l_msg_tokens.delete;
4136: WSM_log_PVT.logMessage(p_module_name => l_module ,
4137: p_msg_text => 'Wip Lot Transaction ... Commit complete',
4138: p_stmt_num => l_stmt_num ,
4139: p_msg_tokens => l_msg_tokens,
4140: p_fnd_log_level => g_log_level_statement,
4171:
4172: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
4173: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
4174: THEN
4175: WSM_log_PVT.handle_others( p_module_name => l_module ,
4176: p_stmt_num => l_stmt_num ,
4177: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
4178: p_run_log_level => l_log_level
4179: );
4208: /* Other locals */
4209: l_txn_id NUMBER;
4210:
4211: -- Logging variables.....
4212: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
4213: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4214:
4215: l_stmt_num NUMBER;
4216: l_module VARCHAR2(100) :='wsm.plsql.WSM_WIP_LOT_TXN_PVT.BONUS_TXN';
4235:
4236: /* Log the Procedure entry point.... */
4237: if( g_log_level_statement >= l_log_level ) then
4238: l_msg_tokens.delete;
4239: WSM_log_PVT.logMessage(p_module_name => l_module ,
4240: p_msg_text => 'Entering the Bonus Txn API',
4241: p_stmt_num => l_stmt_num ,
4242: p_msg_tokens => l_msg_tokens,
4243: p_fnd_log_level => g_log_level_statement,
4266: /* Incompatible versions...*/
4267: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
4268:
4269: l_msg_tokens.delete;
4270: WSM_log_PVT.logMessage(p_module_name => l_module ,
4271: p_msg_text => 'Incompatible API called for Bonus Txn',
4272: p_stmt_num => l_stmt_num ,
4273: p_msg_tokens => l_msg_tokens,
4274: p_fnd_msg_level => G_MSG_LVL_ERROR ,
4289:
4290: /* Log the Procedure entry point.... */
4291: if( g_log_level_statement >= l_log_level ) then
4292: l_msg_tokens.delete;
4293: WSM_log_PVT.logMessage(p_module_name => l_module ,
4294: p_msg_text => 'Calling WSM_WLT_VALIDATE_PVT.validate_txn_details',
4295: p_stmt_num => l_stmt_num ,
4296: p_msg_tokens => l_msg_tokens,
4297: p_fnd_log_level => g_log_level_statement,
4308: /* End header Validation */
4309: /* Log the Procedure exit point.... */
4310: if( g_log_level_statement >= l_log_level ) then
4311: l_msg_tokens.delete;
4312: WSM_log_PVT.logMessage(p_module_name => l_module ,
4313: p_msg_text => 'Returning from WSM_WLT_VALIDATE_PVT.validate_txn_header',
4314: p_stmt_num => l_stmt_num ,
4315: p_msg_tokens => l_msg_tokens,
4316: p_fnd_log_level => g_log_level_statement,
4322: /* Txn errored....*/
4323: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
4324:
4325: l_msg_tokens.delete;
4326: WSM_log_PVT.logMessage(p_module_name => l_module ,
4327: p_msg_text => 'validate_txn_header failed.' ,
4328: p_stmt_num => l_stmt_num ,
4329: p_msg_tokens => l_msg_tokens,
4330: p_fnd_msg_level => G_MSG_LVL_ERROR ,
4343:
4344: /* Log the Procedure exit point.... */
4345: if( g_log_level_statement >= l_log_level ) then
4346: l_msg_tokens.delete;
4347: WSM_log_PVT.logMessage(p_module_name => l_module ,
4348: p_msg_text => 'Validated the Transaction Header Information .... Success ' ,
4349: p_stmt_num => l_stmt_num ,
4350: p_msg_tokens => l_msg_tokens,
4351: p_fnd_log_level => g_log_level_statement,
4357:
4358: /* Log the Procedure entry point.... */
4359: if( g_log_level_statement >= l_log_level ) then
4360: l_msg_tokens.delete;
4361: WSM_log_PVT.logMessage(p_module_name => l_module ,
4362: p_msg_text => 'Calling WSM_WLT_VALIDATE_PVT.validate_resulting_job ',
4363: p_stmt_num => l_stmt_num ,
4364: p_msg_tokens => l_msg_tokens,
4365: p_fnd_log_level => g_log_level_statement,
4380:
4381: /* Log the Procedure exit point.... */
4382: if( g_log_level_statement >= l_log_level ) then
4383: l_msg_tokens.delete;
4384: WSM_log_PVT.logMessage(p_module_name => l_module ,
4385: p_msg_text => 'Returning from WSM_WLT_VALIDATE_PVT.validate_resulting_job',
4386: p_stmt_num => l_stmt_num ,
4387: p_msg_tokens => l_msg_tokens,
4388: p_fnd_log_level => g_log_level_statement,
4394: /* Txn errored....*/
4395: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
4396:
4397: l_msg_tokens.delete;
4398: WSM_log_PVT.logMessage(p_module_name => l_module ,
4399: p_msg_text => 'derive_val_res_job_details failed.' ,
4400: p_stmt_num => l_stmt_num ,
4401: p_msg_tokens => l_msg_tokens,
4402: p_fnd_msg_level => G_MSG_LVL_ERROR ,
4415:
4416: /* Log the Procedure exit point.... event*/
4417: if( g_log_level_statement >= l_log_level ) then
4418: l_msg_tokens.delete;
4419: WSM_log_PVT.logMessage(p_module_name => l_module ,
4420: p_msg_text => 'Validation of the resulting jobs details ... Success',
4421: p_stmt_num => l_stmt_num ,
4422: p_msg_tokens => l_msg_tokens,
4423: p_fnd_log_level => g_log_level_statement,
4434:
4435: /* Log the Procedure entry point.... */
4436: if( g_log_level_statement >= l_log_level ) then
4437: l_msg_tokens.delete;
4438: WSM_log_PVT.logMessage(p_module_name => l_module ,
4439: p_msg_text => 'Calling WWSMPJUPD.PROCESS_LOTS : Transaction Id : ' || l_txn_id ,
4440: p_stmt_num => l_stmt_num,
4441: p_msg_tokens => l_msg_tokens,
4442: p_fnd_log_level => g_log_level_statement,
4461:
4462: /* Log the Procedure exit point.... */
4463: if( g_log_level_statement >= l_log_level ) then
4464: l_msg_tokens.delete;
4465: WSM_log_PVT.logMessage(p_module_name => l_module ,
4466: p_msg_text => 'Returning from WWSMPJUPD.PROCESS_LOTS',
4467: p_stmt_num => l_stmt_num ,
4468: p_msg_tokens => l_msg_tokens,
4469: p_fnd_log_level => g_log_level_statement,
4475: /* Txn errored....*/
4476: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
4477:
4478: l_msg_tokens.delete;
4479: WSM_log_PVT.logMessage(p_module_name => l_module ,
4480: p_msg_text => 'PROCESS_LOTS failed.' ,
4481: p_stmt_num => l_stmt_num ,
4482: p_msg_tokens => l_msg_tokens,
4483: p_fnd_msg_level => G_MSG_LVL_ERROR ,
4500:
4501: /* Log the Procedure exit point.... event*/
4502: if( g_log_level_statement >= l_log_level ) then
4503: l_msg_tokens.delete;
4504: WSM_log_PVT.logMessage(p_module_name => l_module ,
4505: p_msg_text => 'Processing of the WIp Lot Transaction ... Success',
4506: p_stmt_num => l_stmt_num ,
4507: p_msg_tokens => l_msg_tokens,
4508: p_fnd_log_level => g_log_level_statement,
4517: COMMIT;
4518: /* Log the Procedure exit point....event */
4519: if( g_log_level_statement >= l_log_level ) then
4520: l_msg_tokens.delete;
4521: WSM_log_PVT.logMessage(p_module_name => l_module ,
4522: p_msg_text => 'Wip Lot Transaction ... Commit complete',
4523: p_stmt_num => l_stmt_num ,
4524: p_msg_tokens => l_msg_tokens,
4525: p_fnd_log_level => g_log_level_statement,
4557:
4558: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
4559: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
4560: THEN
4561: WSM_log_PVT.handle_others( p_module_name => l_module ,
4562: p_stmt_num => l_stmt_num ,
4563: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
4564: p_run_log_level => l_log_level
4565: );