[Home] [Help]
5: g_pkg_name VARCHAR2(20) := 'WSM_WIP_LOT_TXN_PVT';
6:
7: /*logging variables*/
8:
9: g_log_level_unexpected NUMBER := FND_LOG.LEVEL_UNEXPECTED ;
10: g_log_level_error number := FND_LOG.LEVEL_ERROR ;
11: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;
12: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
13: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;
6:
7: /*logging variables*/
8:
9: g_log_level_unexpected NUMBER := FND_LOG.LEVEL_UNEXPECTED ;
10: g_log_level_error number := FND_LOG.LEVEL_ERROR ;
11: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;
12: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
13: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;
14: g_log_level_statement number := FND_LOG.LEVEL_STATEMENT ;
7: /*logging variables*/
8:
9: g_log_level_unexpected NUMBER := FND_LOG.LEVEL_UNEXPECTED ;
10: g_log_level_error number := FND_LOG.LEVEL_ERROR ;
11: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;
12: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
13: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;
14: g_log_level_statement number := FND_LOG.LEVEL_STATEMENT ;
15:
8:
9: g_log_level_unexpected NUMBER := FND_LOG.LEVEL_UNEXPECTED ;
10: g_log_level_error number := FND_LOG.LEVEL_ERROR ;
11: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;
12: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
13: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;
14: g_log_level_statement number := FND_LOG.LEVEL_STATEMENT ;
15:
16: g_msg_lvl_unexp_error NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ;
9: g_log_level_unexpected NUMBER := FND_LOG.LEVEL_UNEXPECTED ;
10: g_log_level_error number := FND_LOG.LEVEL_ERROR ;
11: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;
12: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
13: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;
14: g_log_level_statement number := FND_LOG.LEVEL_STATEMENT ;
15:
16: g_msg_lvl_unexp_error NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ;
17: g_msg_lvl_error NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR ;
10: g_log_level_error number := FND_LOG.LEVEL_ERROR ;
11: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;
12: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
13: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;
14: g_log_level_statement number := FND_LOG.LEVEL_STATEMENT ;
15:
16: g_msg_lvl_unexp_error NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ;
17: g_msg_lvl_error NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR ;
18: g_msg_lvl_success NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS ;
36:
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:
44:
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);
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,
71: p_run_log_level => l_log_level
72: );
73:
74: WSM_log_PVT.logMessage(p_module_name => l_module ,
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,
79: p_run_log_level => l_log_level
80: );
81: l_message_tbl.delete;
82:
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 ,
121: p_run_log_level => l_log_level
122: );
123: l_log_message := null;
124: END IF;
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 ,
139: p_run_log_level => l_log_level
140: );
141:
142: END IF;
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 ,
152: p_run_log_level => l_log_level
153: );
154: l_index := p_starting_jobs_tbl.first;
155:
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 ,
233: p_run_log_level => l_log_level
234: );
235: l_log_message := null;
236: END IF;
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 ,
251: p_run_log_level => l_log_level
252: );
253:
254: END IF;
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 ,
266: p_run_log_level => l_log_level
267: );
268:
269: l_index := p_resulting_jobs_tbl.first;
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 ,
347: p_run_log_level => l_log_level
348: );
349: l_log_message := null;
350: END IF;
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 ,
365: p_run_log_level => l_log_level
366: );
367:
368: END IF;
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 ,
379: p_run_log_level => l_log_level
380: );
381:
382: l_index := p_secondary_qty_tbl.first;
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 ,
407: p_run_log_level => l_log_level
408: );
409: l_log_message := null;
410: END IF;
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 ,
425: p_run_log_level => l_log_level
426: );
427:
428: END IF;
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 ,
439: p_run_log_level => l_log_level
440: );
441:
442: END IF;
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: );
457: END IF;
458:
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';
537:
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,
559: p_run_log_level => l_log_level
560: );
561:
562: -- Log the transaction data...
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,
595: p_run_log_level => l_log_level
596: );
597: End if;
598:
608: p_msg_appl_name => 'WSM',
609: p_msg_tokens => l_msg_tokens ,
610: p_stmt_num => l_stmt_num ,
611: p_fnd_msg_level => G_MSG_LVL_ERROR ,
612: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
613: p_run_log_level => l_log_level
614: );
615: END IF;
616: RAISE FND_API.G_EXC_ERROR;
627: p_msg_appl_name => 'WSM',
628: p_msg_tokens => l_msg_tokens ,
629: p_stmt_num => l_stmt_num ,
630: p_fnd_msg_level => G_MSG_LVL_ERROR ,
631: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
632: p_run_log_level => l_log_level
633: );
634: END IF;
635: RAISE FND_API.G_EXC_ERROR;
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,
647: p_run_log_level => l_log_level
648: );
649: End if;
650:
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,
675: p_run_log_level => l_log_level
676: );
677: End if;
678:
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 ,
704: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
705: p_run_log_level => l_log_level
706: );
707: END IF;
708: RAISE FND_API.G_EXC_ERROR;
719: p_msg_appl_name => 'WSM',
720: p_msg_tokens => l_msg_tokens ,
721: p_stmt_num => l_stmt_num ,
722: p_fnd_msg_level => G_MSG_LVL_ERROR ,
723: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
724: p_run_log_level => l_log_level
725: );
726: END IF;
727: RAISE FND_API.G_EXC_ERROR;
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 ,
760: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
761: p_run_log_level => l_log_level
762: );
763: END IF;
764: RAISE FND_API.G_EXC_ERROR;
786: p_msg_appl_name => 'WSM',
787: p_msg_tokens => l_msg_tokens ,
788: p_stmt_num => l_stmt_num ,
789: p_fnd_msg_level => G_MSG_LVL_ERROR ,
790: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
791: p_run_log_level => l_log_level
792: );
793: END IF;
794: RAISE FND_API.G_EXC_ERROR;
804: p_msg_appl_name => 'WSM',
805: p_msg_tokens => l_msg_tokens ,
806: p_stmt_num => l_stmt_num ,
807: p_fnd_msg_level => G_MSG_LVL_ERROR ,
808: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
809: p_run_log_level => l_log_level
810: );
811: END IF;
812: RAISE FND_API.G_EXC_ERROR;
826: x_msg_data => x_error_msg
827: );
828:
829: /* if not success return error.... */ --Start AH
830: --log exit to fnd_log
831:
832: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
833: /* Txn errored....*/
834: /* Log the Procedure exit point.... */
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 ,
843: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
844: p_run_log_level => l_log_level
845: );
846: END IF;
847: RAISE FND_API.G_EXC_ERROR;
868: p_msg_appl_name => 'WSM',
869: p_stmt_num => l_stmt_num ,
870: p_msg_tokens => l_msg_tokens ,
871: p_fnd_msg_level => G_MSG_LVL_ERROR ,
872: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
873: p_run_log_level => l_log_level
874: );
875: END IF;
876: RAISE FND_API.G_EXC_ERROR;
886: p_msg_appl_name => 'WSM',
887: p_stmt_num => l_stmt_num ,
888: p_msg_tokens => l_msg_tokens ,
889: p_fnd_msg_level => G_MSG_LVL_ERROR ,
890: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
891: p_run_log_level => l_log_level
892: );
893: END IF;
894: RAISE FND_API.G_EXC_ERROR;
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 ,
922: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
923: p_run_log_level => l_log_level
924: );
925: END IF;
926: RAISE FND_API.G_EXC_ERROR;
948: p_msg_appl_name => 'WSM',
949: p_stmt_num => l_stmt_num ,
950: p_msg_tokens => l_msg_tokens ,
951: p_fnd_msg_level => G_MSG_LVL_ERROR ,
952: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
953: p_run_log_level => l_log_level
954: );
955: END IF;
956: RAISE FND_API.G_EXC_ERROR;
966: p_msg_appl_name => 'WSM',
967: p_stmt_num => l_stmt_num ,
968: p_msg_tokens => l_msg_tokens ,
969: p_fnd_msg_level => G_MSG_LVL_ERROR ,
970: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
971: p_run_log_level => l_log_level
972: );
973: END IF;
974: RAISE FND_API.G_EXC_ERROR;
994: /* Log the Procedure exit point.... */
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,
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 ,
1004: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
1005: p_run_log_level => l_log_level
1006: );
1007: END IF;
1008: RAISE FND_API.G_EXC_ERROR;
1029: p_msg_appl_name => 'WSM',
1030: p_msg_tokens => l_msg_tokens ,
1031: p_stmt_num => l_stmt_num ,
1032: p_fnd_msg_level => G_MSG_LVL_ERROR ,
1033: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
1034: p_run_log_level => l_log_level
1035: );
1036: END IF;
1037: RAISE FND_API.G_EXC_ERROR;
1047: p_msg_appl_name => 'WSM',
1048: p_msg_tokens => l_msg_tokens ,
1049: p_stmt_num => l_stmt_num ,
1050: p_fnd_msg_level => G_MSG_LVL_ERROR ,
1051: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
1052: p_run_log_level => l_log_level
1053: );
1054: END IF;
1055: RAISE FND_API.G_EXC_ERROR;
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 ,
1084: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
1085: p_run_log_level => l_log_level
1086: );
1087: END IF;
1088: RAISE FND_API.G_EXC_ERROR;
1110: p_msg_appl_name => 'WSM',
1111: p_msg_tokens => l_msg_tokens ,
1112: p_stmt_num => l_stmt_num ,
1113: p_fnd_msg_level => G_MSG_LVL_ERROR ,
1114: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
1115: p_run_log_level => l_log_level
1116: );
1117: END IF;
1118: RAISE FND_API.G_EXC_ERROR;
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 ,
1146: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
1147: p_run_log_level => l_log_level
1148: );
1149: END IF;
1150: RAISE FND_API.G_EXC_ERROR;
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 ,
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_UNEXPECTED_ERROR;
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,
1242: p_run_log_level => l_log_level
1243: );
1244: End if;
1245: --Bug 5263262:Req import was not invoked because of
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,
1271: -- p_run_log_level => l_log_level
1272: -- );
1273: --End if;
1274: --END IF;
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,
1289: p_run_log_level => l_log_level
1290: );
1291: End if;
1292:
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: );
1324: END IF;
1325:
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...
1367:
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,
1387: p_run_log_level => l_log_level
1388: );
1389: End if;
1390:
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 ,
1417: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
1418: p_run_log_level => l_log_level
1419: );
1420: END IF;
1421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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,
1433: p_run_log_level => l_log_level
1434: );
1435: End if;
1436:
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,
1451: p_run_log_level => l_log_level
1452: );
1453: End if;
1454:
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,
1471: p_run_log_level => l_log_level
1472: );
1473: End if;
1474:
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 ,
1485: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
1486: p_run_log_level => l_log_level
1487: );
1488: END IF;
1489: if x_return_status <> G_RET_SUCCESS then
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,
1506: p_run_log_level => l_log_level
1507: );
1508: End if;
1509:
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,
1522: p_run_log_level => l_log_level
1523: );
1524: End if;
1525:
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,
1544: p_run_log_level => l_log_level
1545: );
1546: End if;
1547:
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 ,
1559: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
1560: p_run_log_level => l_log_level
1561: );
1562: END IF;
1563: if x_return_status <> G_RET_SUCCESS then
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,
1580: p_run_log_level => l_log_level
1581: );
1582: End if;
1583:
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,
1594: p_run_log_level => l_log_level
1595: );
1596: End if;
1597:
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,
1617: p_run_log_level => l_log_level
1618: );
1619: End if;
1620:
1622: /* Txn errored....*/
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,
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 ,
1632: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
1633: p_run_log_level => l_log_level
1634: );
1635: END IF;
1636: if x_return_status <> G_RET_SUCCESS then
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,
1652: p_run_log_level => l_log_level
1653: );
1654: End if;
1655:
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,
1669: p_run_log_level => l_log_level
1670: );
1671: End if;
1672:
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,
1696: p_run_log_level => l_log_level
1697: );
1698: End if;
1699:
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 ,
1710: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
1711: p_run_log_level => l_log_level
1712: );
1713: END IF;
1714: if x_return_status <> G_RET_SUCCESS then
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,
1734: p_run_log_level => l_log_level
1735: );
1736: End if;
1737:
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,
1753: p_run_log_level => l_log_level
1754: );
1755: End if;
1756: END IF;
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: );
1798: END IF;
1799:
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';
1847: -- Logging variables...
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,
1870: p_run_log_level => l_log_level
1871: );
1872: End if;
1873:
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 ,
1906: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
1907: p_run_log_level => l_log_level
1908: );
1909: END IF;
1910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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,
1929: p_run_log_level => l_log_level
1930: );
1931: End if;
1932: WSM_WLT_VALIDATE_PVT.validate_txn_header ( p_wltx_header => p_wltx_header,
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,
1947: p_run_log_level => l_log_level
1948: );
1949: End if;
1950:
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 ,
1961: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
1962: p_run_log_level => l_log_level
1963: );
1964: END IF;
1965: if x_return_status <> G_RET_SUCCESS then
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,
1982: p_run_log_level => l_log_level
1983: );
1984: End if;
1985:
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,
1997: p_run_log_level => l_log_level
1998: );
1999: End if;
2000:
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,
2024: p_run_log_level => l_log_level
2025: );
2026: End if;
2027:
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 ,
2038: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
2039: p_run_log_level => l_log_level
2040: );
2041: END IF;
2042: if x_return_status <> G_RET_SUCCESS then
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,
2059: p_run_log_level => l_log_level
2060: );
2061: End if;
2062:
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,
2073: p_run_log_level => l_log_level
2074: );
2075: End if;
2076:
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,
2102: p_run_log_level => l_log_level
2103: );
2104: End if;
2105:
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 ,
2116: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
2117: p_run_log_level => l_log_level
2118: );
2119: END IF;
2120: if x_return_status <> G_RET_SUCCESS then
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,
2137: p_run_log_level => l_log_level
2138: );
2139: End if;
2140:
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,
2160: p_run_log_level => l_log_level
2161: );
2162: End if;
2163:
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,
2186: p_run_log_level => l_log_level
2187: );
2188: End if;
2189:
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 ,
2200: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
2201: p_run_log_level => l_log_level
2202: );
2203: END IF;
2204: if x_return_status <> G_RET_SUCCESS then
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,
2224: p_run_log_level => l_log_level
2225: );
2226: End if;
2227:
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,
2242: p_run_log_level => l_log_level
2243: );
2244: End if;
2245: END IF;
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: );
2285: END IF;
2286:
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';
2323:
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 ,
2389: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
2390: p_run_log_level => l_log_level
2391: );
2392: END IF;
2393: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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,
2418: p_run_log_level => l_log_level
2419: );
2420: End if;
2421:
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,
2437: p_run_log_level => l_log_level
2438: );
2439: End if;
2440:
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 ,
2451: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
2452: p_run_log_level => l_log_level
2453: );
2454: END IF;
2455: if x_return_status <> G_RET_SUCCESS then
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,
2472: p_run_log_level => l_log_level
2473: );
2474: End if;
2475:
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,
2487: p_run_log_level => l_log_level
2488: );
2489: End if;
2490:
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,
2509: p_run_log_level => l_log_level
2510: );
2511: End if;
2512:
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 ,
2523: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
2524: p_run_log_level => l_log_level
2525: );
2526: END IF;
2527: if x_return_status <> G_RET_SUCCESS then
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,
2544: p_run_log_level => l_log_level
2545: );
2546: End if;
2547:
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,
2558: p_run_log_level => l_log_level
2559: );
2560: End if;
2561:
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,
2582: p_run_log_level => l_log_level
2583: );
2584: End if;
2585:
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 ,
2596: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
2597: p_run_log_level => l_log_level
2598: );
2599: END IF;
2600: if x_return_status <> G_RET_SUCCESS then
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,
2617: p_run_log_level => l_log_level
2618: );
2619: End if;
2620:
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,
2632: p_run_log_level => l_log_level
2633: );
2634: End if;
2635:
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,
2660: p_run_log_level => l_log_level
2661: );
2662: End if;
2663:
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 ,
2674: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
2675: p_run_log_level => l_log_level
2676: );
2677: END IF;
2678: if x_return_status <> G_RET_SUCCESS then
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,
2699: p_run_log_level => l_log_level
2700: );
2701: End if;
2702:
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,
2717: p_run_log_level => l_log_level
2718: );
2719: End if;
2720:
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: );
2760: END IF;
2761:
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';
2799:
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 ,
2866: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
2867: p_run_log_level => l_log_level
2868: );
2869: END IF;
2870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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,
2894: p_run_log_level => l_log_level
2895: );
2896: End if;
2897:
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,
2913: p_run_log_level => l_log_level
2914: );
2915: End if;
2916:
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 ,
2927: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
2928: p_run_log_level => l_log_level
2929: );
2930: END IF;
2931: if x_return_status <> G_RET_SUCCESS then
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,
2948: p_run_log_level => l_log_level
2949: );
2950: End if;
2951:
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,
2963: p_run_log_level => l_log_level
2964: );
2965: End if;
2966:
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,
2985: p_run_log_level => l_log_level
2986: );
2987: End if;
2988:
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 ,
2999: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3000: p_run_log_level => l_log_level
3001: );
3002: END IF;
3003: if x_return_status <> G_RET_SUCCESS then
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,
3020: p_run_log_level => l_log_level
3021: );
3022: End if;
3023:
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,
3034: p_run_log_level => l_log_level
3035: );
3036: End if;
3037:
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,
3058: p_run_log_level => l_log_level
3059: );
3060: End if;
3061:
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 ,
3074: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3075: p_run_log_level => l_log_level
3076: );
3077: END IF;
3078: if x_return_status <> G_RET_SUCCESS then
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,
3095: p_run_log_level => l_log_level
3096: );
3097: End if;
3098:
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,
3111: p_run_log_level => l_log_level
3112: );
3113: End if;
3114:
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,
3139: p_run_log_level => l_log_level
3140: );
3141: End if;
3142:
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 ,
3153: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3154: p_run_log_level => l_log_level
3155: );
3156: END IF;
3157: if x_return_status <> G_RET_SUCCESS then
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,
3178: p_run_log_level => l_log_level
3179: );
3180: End if;
3181:
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,
3195: p_run_log_level => l_log_level
3196: );
3197: End if;
3198: END IF;
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: );
3235: END IF;
3236:
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';
3272:
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 ,
3338: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3339: p_run_log_level => l_log_level
3340: );
3341: END IF;
3342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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,
3368: p_run_log_level => l_log_level
3369: );
3370: End if;
3371:
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,
3387: p_run_log_level => l_log_level
3388: );
3389: End if;
3390:
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 ,
3401: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3402: p_run_log_level => l_log_level
3403: );
3404: END IF;
3405: if x_return_status <> G_RET_SUCCESS then
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,
3422: p_run_log_level => l_log_level
3423: );
3424: End if;
3425:
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,
3437: p_run_log_level => l_log_level
3438: );
3439: End if;
3440:
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,
3459: p_run_log_level => l_log_level
3460: );
3461: End if;
3462:
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 ,
3473: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3474: p_run_log_level => l_log_level
3475: );
3476: END IF;
3477: if x_return_status <> G_RET_SUCCESS then
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,
3494: p_run_log_level => l_log_level
3495: );
3496: End if;
3497:
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,
3508: p_run_log_level => l_log_level
3509: );
3510: End if;
3511:
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,
3532: p_run_log_level => l_log_level
3533: );
3534: End if;
3535:
3537: /* Txn errored....*/
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,
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 ,
3547: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
3548: p_run_log_level => l_log_level
3549: );
3550: END IF;
3551: if x_return_status <> G_RET_SUCCESS then
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,
3568: p_run_log_level => l_log_level
3569: );
3570: End if;
3571: end if ; --end of validation procs
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,
3586: p_run_log_level => l_log_level
3587: );
3588: End if;
3589:
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,
3614: p_run_log_level => l_log_level
3615: );
3616: End if;
3617:
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 ,
3628: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3629: p_run_log_level => l_log_level
3630: );
3631: END IF;
3632: if x_return_status <> G_RET_SUCCESS then
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,
3653: p_run_log_level => l_log_level
3654: );
3655: End if;
3656:
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,
3670: p_run_log_level => l_log_level
3671: );
3672: End if;
3673:
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: );
3712: END IF;
3713:
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';
3748:
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,
3773: p_run_log_level => l_log_level
3774: );
3775: End if;
3776:
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,
3792: p_run_log_level => l_log_level
3793: );
3794: End if;
3795: end if;
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 ,
3815: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3816: p_run_log_level => l_log_level
3817: );
3818: END IF;
3819: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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,
3838: p_run_log_level => l_log_level
3839: );
3840: End if;
3841:
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,
3857: p_run_log_level => l_log_level
3858: );
3859: End if;
3860:
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 ,
3871: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3872: p_run_log_level => l_log_level
3873: );
3874: END IF;
3875: if x_return_status <> G_RET_SUCCESS then
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,
3892: p_run_log_level => l_log_level
3893: );
3894: End if;
3895:
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,
3907: p_run_log_level => l_log_level
3908: );
3909: End if;
3910:
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,
3929: p_run_log_level => l_log_level
3930: );
3931: End if;
3932:
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 ,
3943: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3944: p_run_log_level => l_log_level
3945: );
3946: END IF;
3947: if x_return_status <> G_RET_SUCCESS then
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,
3964: p_run_log_level => l_log_level
3965: );
3966: End if;
3967:
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,
3978: p_run_log_level => l_log_level
3979: );
3980: End if;
3981:
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,
4002: p_run_log_level => l_log_level
4003: );
4004: End if;
4005:
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 ,
4016: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4017: p_run_log_level => l_log_level
4018: );
4019: END IF;
4020: if x_return_status <> G_RET_SUCCESS then
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,
4037: p_run_log_level => l_log_level
4038: );
4039: End if;
4040:
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,
4057: p_run_log_level => l_log_level
4058: );
4059: End if;
4060:
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,
4085: p_run_log_level => l_log_level
4086: );
4087: End if;
4088:
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 ,
4099: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4100: p_run_log_level => l_log_level
4101: );
4102: END IF;
4103: if x_return_status <> G_RET_SUCCESS then
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,
4124: p_run_log_level => l_log_level
4125: );
4126: End if;
4127:
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,
4141: p_run_log_level => l_log_level
4142: );
4143: End if;
4144:
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: );
4180: END IF;
4181:
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';
4217:
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,
4244: p_run_log_level => l_log_level
4245: );
4246: End if;
4247:
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 ,
4275: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4276: p_run_log_level => l_log_level
4277: );
4278: END IF;
4279: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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,
4298: p_run_log_level => l_log_level
4299: );
4300: End if;
4301:
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,
4317: p_run_log_level => l_log_level
4318: );
4319: End if;
4320:
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 ,
4331: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4332: p_run_log_level => l_log_level
4333: );
4334: END IF;
4335: if x_return_status <> G_RET_SUCCESS then
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,
4352: p_run_log_level => l_log_level
4353: );
4354: End if;
4355:
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,
4366: p_run_log_level => l_log_level
4367: );
4368: End if;
4369:
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,
4389: p_run_log_level => l_log_level
4390: );
4391: End if;
4392:
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 ,
4403: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4404: p_run_log_level => l_log_level
4405: );
4406: END IF;
4407: if x_return_status <> G_RET_SUCCESS then
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,
4424: p_run_log_level => l_log_level
4425: );
4426: End if;
4427:
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,
4443: p_run_log_level => l_log_level
4444: );
4445: End if;
4446:
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,
4470: p_run_log_level => l_log_level
4471: );
4472: End if;
4473:
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 ,
4484: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4485: p_run_log_level => l_log_level
4486: );
4487: END IF;
4488: if x_return_status <> G_RET_SUCCESS then
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,
4509: p_run_log_level => l_log_level
4510: );
4511: End if;
4512:
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,
4526: p_run_log_level => l_log_level
4527: );
4528: End if;
4529:
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: );
4566: END IF;
4567: