[Home] [Help]
12: g_pkg_name VARCHAR2(20) := 'WSMPJUPD';
13:
14: /*logging variables*/
15:
16: g_log_level_unexpected NUMBER := FND_LOG.LEVEL_UNEXPECTED ;
17: g_log_level_error number := FND_LOG.LEVEL_ERROR ;
18: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;
19: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
20: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;
13:
14: /*logging variables*/
15:
16: g_log_level_unexpected NUMBER := FND_LOG.LEVEL_UNEXPECTED ;
17: g_log_level_error number := FND_LOG.LEVEL_ERROR ;
18: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;
19: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
20: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;
21: g_log_level_statement number := FND_LOG.LEVEL_STATEMENT ;
14: /*logging variables*/
15:
16: g_log_level_unexpected NUMBER := FND_LOG.LEVEL_UNEXPECTED ;
17: g_log_level_error number := FND_LOG.LEVEL_ERROR ;
18: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;
19: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
20: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;
21: g_log_level_statement number := FND_LOG.LEVEL_STATEMENT ;
22:
15:
16: g_log_level_unexpected NUMBER := FND_LOG.LEVEL_UNEXPECTED ;
17: g_log_level_error number := FND_LOG.LEVEL_ERROR ;
18: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;
19: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
20: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;
21: g_log_level_statement number := FND_LOG.LEVEL_STATEMENT ;
22:
23: g_msg_lvl_unexp_error NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ;
16: g_log_level_unexpected NUMBER := FND_LOG.LEVEL_UNEXPECTED ;
17: g_log_level_error number := FND_LOG.LEVEL_ERROR ;
18: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;
19: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
20: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;
21: g_log_level_statement number := FND_LOG.LEVEL_STATEMENT ;
22:
23: g_msg_lvl_unexp_error NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ;
24: g_msg_lvl_error NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR ;
17: g_log_level_error number := FND_LOG.LEVEL_ERROR ;
18: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;
19: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
20: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;
21: g_log_level_statement number := FND_LOG.LEVEL_STATEMENT ;
22:
23: g_msg_lvl_unexp_error NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ;
24: g_msg_lvl_error NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR ;
25: g_msg_lvl_success NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS ;
97: l_counter number;
98: l_index number;
99: -- Logging variables.....
100: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
101: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
102:
103: l_stmt_num NUMBER;
104: l_module VARCHAR2(100) := 'wsm.plsql.WSMPJUPD.process_mes_info';
105: l_param_tbl WSM_Log_PVT.param_tbl_type;
109: savepoint start_secondary_quantities;
110:
111: x_return_status := FND_API.G_RET_STS_SUCCESS;
112:
113: IF FND_LOG.LEVEL_PROCEDURE >= l_log_level THEN
114: l_stmt_num := 5;
115: l_param_tbl.delete;
116: l_param_tbl(1).paramName := 'p_sj_also_rj_index';
117: l_param_tbl(1).paramValue := p_sj_also_rj_index;
120: l_param_tbl(2).paramValue := p_rep_job_index;
121:
122: WSM_Log_PVT.logProcParams(p_module_name => l_module ,
123: p_param_tbl => l_param_tbl,
124: p_fnd_log_level => l_log_level
125: );
126: END IF;
127:
128: l_stmt_num := 8;
141: 'l_sj_rj_wip_entity_name ' || l_sj_rj_wip_entity_name ||
142: 'l_sj_rj_inventory_item_id ' || l_sj_rj_inventory_item_id ,
143: p_stmt_num => l_stmt_num ,
144: p_msg_tokens => l_msg_tokens,
145: p_fnd_log_level => g_log_level_statement,
146: p_run_log_level => l_log_level
147: );
148: End if;
149:
177: WSM_log_PVT.logMessage(p_module_name => l_module ,
178: p_msg_text => 'Current Secondary quantitites Count : ' || l_job_qty_tbl.count,
179: p_stmt_num => l_stmt_num ,
180: p_msg_tokens => l_msg_tokens,
181: p_fnd_log_level => g_log_level_statement,
182: p_run_log_level => l_log_level
183: );
184: End if;
185: l_stmt_num := 20;
218: WSM_log_PVT.logMessage(p_module_name => l_module ,
219: p_msg_text => 'Population of Histroy information for Starting Jobs done.',
220: p_stmt_num => l_stmt_num ,
221: p_msg_tokens => l_msg_tokens,
222: p_fnd_log_level => g_log_level_statement,
223: p_run_log_level => l_log_level
224: );
225: End if;
226: --********* End Insert SJ sec qty info into history table******************--
344: WSM_log_PVT.logMessage(p_module_name => l_module ,
345: p_msg_text => 'Updated ' || SQL%ROWCOUNT || ' rows to be inactive in job secondary quantities',
346: p_stmt_num => l_stmt_num ,
347: p_msg_tokens => l_msg_tokens,
348: p_fnd_log_level => g_log_level_statement,
349: p_run_log_level => l_log_level
350: );
351: End if;
352:
368: WSM_log_PVT.logMessage(p_module_name => l_module ,
369: p_msg_text => 'Updated ' || SQL%ROWCOUNT || ' rows to be active in job secondary quantities',
370: p_stmt_num => l_stmt_num ,
371: p_msg_tokens => l_msg_tokens,
372: p_fnd_log_level => g_log_level_statement,
373: p_run_log_level => l_log_level
374: );
375: End if;
376: -- ST : Bug fix 5046332 : End --
420: WSM_log_PVT.logMessage(p_module_name => l_module ,
421: p_msg_text => 'Inserted ' || SQL%ROWCOUNT || ' new rows in in job secondary quantities tables',
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: END IF;
428: END IF;
457: WSM_log_PVT.logMessage(p_module_name => l_module ,
458: p_msg_text => 'Processing for Split Merge, Update Assembly Done',
459: p_stmt_num => l_stmt_num ,
460: p_msg_tokens => l_msg_tokens,
461: p_fnd_log_level => g_log_level_statement,
462: p_run_log_level => l_log_level
463: );
464: End if;
465:
492: WSM_log_PVT.logMessage(p_module_name => l_module ,
493: p_msg_text => 'Starting Job Reason codes count : ' || l_sj_op_reason_codes_tbl.count,
494: p_stmt_num => l_stmt_num ,
495: p_msg_tokens => l_msg_tokens,
496: p_fnd_log_level => g_log_level_statement,
497: p_run_log_level => l_log_level
498: );
499: End if;
500:
543: WSM_log_PVT.logMessage(p_module_name => l_module ,
544: p_msg_text => 'Resulting Jobs Reason codes count : ' || l_rj_op_reason_codes_tbl.count,
545: p_stmt_num => l_stmt_num ,
546: p_msg_tokens => l_msg_tokens,
547: p_fnd_log_level => g_log_level_statement,
548: p_run_log_level => l_log_level
549: );
550: End if;
551: forall i in indices of l_rj_op_reason_codes_tbl
559: WSM_log_PVT.logMessage(p_module_name => l_module ,
560: p_msg_text => 'Processing Reason codes for non-SpUA and Merge resulting Jobs done',
561: p_stmt_num => l_stmt_num ,
562: p_msg_tokens => l_msg_tokens,
563: p_fnd_log_level => g_log_level_statement,
564: p_run_log_level => l_log_level
565: );
566: End if;
567: END IF;
615: WSM_log_PVT.logMessage(p_module_name => l_module ,
616: p_msg_text => 'Inserted ' || SQL%ROWCOUNT || ' new rows in in job secondary quantities tables for bonus',
617: p_stmt_num => l_stmt_num ,
618: p_msg_tokens => l_msg_tokens,
619: p_fnd_log_level => g_log_level_statement,
620: p_run_log_level => l_log_level
621: );
622: End if;
623:
653: WSM_log_PVT.logMessage(p_module_name => l_module ,
654: p_msg_text => 'Processing Secondary Qty and Reason codes for SpUA Split and Upd Assy and Upd Rtg Jobs done',
655: p_stmt_num => l_stmt_num ,
656: p_msg_tokens => l_msg_tokens,
657: p_fnd_log_level => g_log_level_statement,
658: p_run_log_level => l_log_level
659: );
660: End if;
661:
709: WSM_log_PVT.logMessage(p_module_name => l_module ,
710: p_msg_text => 'History Information for Resulting Jobs Done',
711: p_stmt_num => l_stmt_num ,
712: p_msg_tokens => l_msg_tokens,
713: p_fnd_log_level => g_log_level_statement,
714: p_run_log_level => l_log_level
715: );
716: End if;
717:
742: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
743: THEN
744: WSM_log_PVT.handle_others( p_module_name => l_module ,
745: p_stmt_num => l_stmt_num ,
746: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
747: p_run_log_level => l_log_level
748: );
749: END IF;
750: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
773: g_code_type_scrap CONSTANT NUMBER := 2 ;
774:
775: -- Logging variables.....
776: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
777: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
778: l_stmt_num NUMBER;
779: l_module VARCHAR2(100) := 'wsm.plsql.WSMPJUPD.copy_wsm_op_reason_codes';
780:
781: BEGIN
924: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
925: THEN
926: WSM_log_PVT.handle_others( p_module_name => l_module ,
927: p_stmt_num => l_stmt_num ,
928: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
929: p_run_log_level => l_log_level
930: );
931: END IF;
932: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
954: l_counter NUMBER;
955:
956: -- Logging variables.....
957: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
958: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
959:
960: l_stmt_num NUMBER;
961: l_module VARCHAR2(100) := 'wsm.plsql.WSMPJUPD.copy_wsm_substitute_components';
962:
1114: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
1115: THEN
1116: WSM_log_PVT.handle_others( p_module_name => l_module ,
1117: p_stmt_num => l_stmt_num ,
1118: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
1119: p_run_log_level => l_log_level
1120: );
1121: END IF;
1122:
1147: l_qty_TM NUMBER;
1148:
1149: -- Logging variables.....
1150: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
1151: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1152:
1153: l_stmt_num NUMBER;
1154: l_module VARCHAR2(100) := 'wsm.plsql.WSMPJUPD.GET_JOB_CURR_OP_INFO';
1155:
1213: p_msg_text => x_err_buf ,
1214: p_stmt_num => l_stmt_num ,
1215: p_msg_tokens => l_msg_tokens,
1216: p_fnd_msg_level => G_MSG_LVL_ERROR ,
1217: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
1218: p_run_log_level => l_log_level
1219: );
1220: END IF;
1221: RAISE FND_API.G_EXC_ERROR;
1233: p_msg_text => x_err_buf ,
1234: p_stmt_num => l_stmt_num ,
1235: p_msg_tokens => l_msg_tokens,
1236: p_fnd_msg_level => G_MSG_LVL_ERROR ,
1237: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
1238: p_run_log_level => l_log_level
1239: );
1240: END IF;
1241: RAISE FND_API.G_EXC_ERROR;
1259: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
1260: THEN
1261: WSM_log_PVT.handle_others( p_module_name => l_module ,
1262: p_stmt_num => l_stmt_num ,
1263: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
1264: p_run_log_level => l_log_level
1265: );
1266: END IF;
1267:
1293: l_counter number;
1294:
1295: -- Logging variables.....
1296: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
1297: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1298:
1299: l_stmt_num NUMBER;
1300: l_module VARCHAR2(100) := 'wsm.plsql.WSMJUPDB.COPY_REP_JOB_WO_FA';
1301: BEGIN
1308: p_msg_text => 'Inside COPY_REP_JOB_WO_FA : New Jobs count ' || p_new_rj_we_id_tbl.count
1309: || ' ' || p_curr_op_seq_num || ' ' || p_rep_we_id,
1310: p_stmt_num => l_stmt_num ,
1311: p_msg_tokens => l_msg_tokens ,
1312: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
1313: p_run_log_level => l_log_level
1314: );
1315: END IF;
1316:
1541: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
1542: THEN
1543: WSM_log_PVT.handle_others( p_module_name => l_module ,
1544: p_stmt_num => l_stmt_num ,
1545: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
1546: p_run_log_level => l_log_level
1547: );
1548: END IF;
1549:
1564: IS
1565:
1566: -- Logging variables.....
1567: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
1568: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1569: l_stmt_num NUMBER;
1570: l_module VARCHAR2(100) := 'wsm.plsql.WSMPJUPD.COPY_REP_JOB_WOR';
1571:
1572: BEGIN
1698: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
1699: THEN
1700: WSM_log_PVT.handle_others( p_module_name => l_module ,
1701: p_stmt_num => l_stmt_num ,
1702: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
1703: p_run_log_level => l_log_level
1704: );
1705: END IF;
1706:
1722: IS
1723:
1724: -- Logging variables.....
1725: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
1726: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1727:
1728: l_stmt_num NUMBER;
1729: l_module VARCHAR2(100) := 'wsm.plsql.WSMJUPDB.COPY_REP_JOB_WSOR';
1730: BEGIN
1873: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
1874: THEN
1875: WSM_log_PVT.handle_others( p_module_name => l_module ,
1876: p_stmt_num => l_stmt_num ,
1877: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
1878: p_run_log_level => l_log_level
1879: );
1880: END IF;
1881:
1899: IS
1900:
1901: -- Logging variables.....
1902: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
1903: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1904:
1905: l_stmt_num NUMBER;
1906: l_module VARCHAR2(100) := 'wsm.plsql.WSMJUPDB.COPY_REP_JOB_WORI';
1907:
1961: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
1962: THEN
1963: WSM_log_PVT.handle_others( p_module_name => l_module ,
1964: p_stmt_num => l_stmt_num ,
1965: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
1966: p_run_log_level => l_log_level
1967: );
1968: END IF;
1969:
1987: IS
1988:
1989: -- Logging variables.....
1990: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
1991: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1992:
1993: l_stmt_num NUMBER;
1994: l_module VARCHAR2(100) := 'wsm.plsql.WSMJUPDB.COPY_REP_JOB_WRO';
1995: BEGIN
2179: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
2180: THEN
2181: WSM_log_PVT.handle_others( p_module_name => l_module ,
2182: p_stmt_num => l_stmt_num ,
2183: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
2184: p_run_log_level => l_log_level
2185: );
2186: END IF;
2187:
2203: IS
2204:
2205: -- Logging variables.....
2206: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
2207: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2208:
2209: l_stmt_num NUMBER;
2210: l_module VARCHAR2(100) := 'wsm.plsql.WSMJUPDB.COPY_REP_JOB_WOY';
2211: BEGIN
2265: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
2266: THEN
2267: WSM_log_PVT.handle_others( p_module_name => l_module ,
2268: p_stmt_num => l_stmt_num ,
2269: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
2270: p_run_log_level => l_log_level
2271: );
2272: END IF;
2273:
2317: IS
2318:
2319: -- Logging variables.....
2320: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
2321: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2322:
2323: l_stmt_num NUMBER;
2324: l_module VARCHAR2(100) := 'wsm.plsql.WSMJUPDB.CHANGE_QUANTITY';
2325: --Bug 5254440: Added the parameter p_op_seq_num.
2431: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
2432: THEN
2433: WSM_log_PVT.handle_others( p_module_name => l_module ,
2434: p_stmt_num => l_stmt_num ,
2435: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
2436: p_run_log_level => l_log_level
2437: );
2438: END IF;
2439:
2465: l_ret_status varchar2(1);
2466:
2467: -- Logging variables.....
2468: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
2469: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2470:
2471: l_stmt_num NUMBER;
2472: l_module VARCHAR2(100) := 'wsm.plsql.WSMJUPDB.handle_kanban_sub_loc_change';
2473:
2527: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
2528: THEN
2529: WSM_log_PVT.handle_others( p_module_name => l_module ,
2530: p_stmt_num => l_stmt_num ,
2531: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
2532: p_run_log_level => l_log_level
2533: );
2534: END IF;
2535:
2571: IS
2572:
2573: -- Logging variables.....
2574: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
2575: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2576:
2577: l_stmt_num NUMBER;
2578: l_module VARCHAR2(100) := 'wsm.plsql.WSMJUPDB.UPDATE_QTY_ISSUED';
2579: BEGIN
2759: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
2760: THEN
2761: WSM_log_PVT.handle_others( p_module_name => l_module ,
2762: p_stmt_num => l_stmt_num ,
2763: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
2764: p_run_log_level => l_log_level
2765: );
2766: END IF;
2767:
2790: x_err_buf OUT NOCOPY VARCHAR2)
2791: IS
2792: -- Logging variables.....
2793: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
2794: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2795:
2796: l_stmt_num NUMBER;
2797: l_module VARCHAR2(100) := 'wsm.plsql.WSMJUPDB.CREATE_WSOR_WLBJ_RECORDS';
2798:
2935: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
2936: THEN
2937: WSM_log_PVT.handle_others( p_module_name => l_module ,
2938: p_stmt_num => l_stmt_num ,
2939: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
2940: p_run_log_level => l_log_level
2941: );
2942: END IF;
2943:
2981: l_fnd_err_msg VARCHAR2(2000);
2982: x_msg_count number;
2983: -- Logging variables.....
2984: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
2985: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2986:
2987: l_stmt_num NUMBER;
2988: l_module VARCHAR2(100) := 'wsm.plsql.WSMJUPDB.CHANGE_ROUTING';
2989:
3006: WSM_log_PVT.logMessage(p_module_name => l_module ,
3007: p_msg_text => 'Entered procedure CHANGE_ROUTING',
3008: p_stmt_num => l_stmt_num ,
3009: p_msg_tokens => l_msg_tokens,
3010: p_fnd_log_level => g_log_level_statement,
3011: p_run_log_level => l_log_level
3012: );
3013: End if;
3014:
3037: p_msg_text => 'GET_JOB_CURR_OP_INFO returned failure',
3038: p_stmt_num => l_stmt_num ,
3039: p_msg_tokens => l_msg_tokens,
3040: p_fnd_msg_level => G_MSG_LVL_ERROR ,
3041: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3042: p_run_log_level => l_log_level
3043: );
3044: END IF;
3045: RAISE FND_API.G_EXC_ERROR;
3077: p_msg_text => x_err_buf ,
3078: p_stmt_num => l_stmt_num ,
3079: p_msg_tokens => l_msg_tokens ,
3080: p_fnd_msg_level => G_MSG_LVL_ERROR ,
3081: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3082: p_run_log_level => l_log_level
3083: );
3084: END IF;
3085: RAISE FND_API.G_EXC_ERROR;
3100: p_msg_name => 'WSM_MANUAL_CHARGES_EXIST',
3101: p_msg_appl_name => 'WSM' ,
3102: p_msg_tokens => l_msg_tokens ,
3103: p_fnd_msg_level => G_MSG_LVL_ERROR ,
3104: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3105: p_run_log_level => l_log_level
3106: );
3107: END IF;
3108:
3122: p_msg_name => 'WSM_MANUAL_CHARGES_EXIST',
3123: p_msg_appl_name => 'WSM' ,
3124: p_msg_tokens => l_msg_tokens ,
3125: p_fnd_msg_level => G_MSG_LVL_ERROR ,
3126: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3127: p_run_log_level => l_log_level
3128: );
3129: END IF;
3130:
3141: p_msg_name => 'WSM_PHANTOM_COMPONENTS_EXIST',
3142: p_msg_appl_name => 'WSM' ,
3143: p_msg_tokens => l_msg_tokens ,
3144: p_fnd_msg_level => G_MSG_LVL_ERROR ,
3145: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3146: p_run_log_level => l_log_level
3147: );
3148: END IF;
3149:
3242: WSM_log_PVT.logMessage(p_module_name => l_module ,
3243: p_msg_text => 'Calling WSMPLBJI.insert_procedure :' ||p_rj_job_rec.starting_operation_seq_id,
3244: p_stmt_num => l_stmt_num ,
3245: p_msg_tokens => l_msg_tokens,
3246: p_fnd_log_level => g_log_level_statement,
3247: p_run_log_level => l_log_level
3248: );
3249: End if;
3250:
3295: p_msg_text => 'Returned failure from WSMPLBJI.insert_procedure.Error:'|| x_err_buf,
3296: p_stmt_num => l_stmt_num ,
3297: p_msg_tokens => l_msg_tokens,
3298: p_fnd_msg_level => G_MSG_LVL_ERROR ,
3299: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3300: p_run_log_level => l_log_level
3301: );
3302: END IF;
3303: RAISE FND_API.G_EXC_ERROR;
3346: p_msg_text => 'Returned failure from CREATE_WSOR_WLBJ_RECORDS',
3347: p_stmt_num => l_stmt_num ,
3348: p_msg_tokens => l_msg_tokens,
3349: p_fnd_msg_level => G_MSG_LVL_ERROR ,
3350: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3351: p_run_log_level => l_log_level
3352: );
3353: END IF;
3354: RAISE FND_API.G_EXC_ERROR;
3359: WSM_log_PVT.logMessage(p_module_name => l_module ,
3360: p_msg_text => 'Created WSOR records for new job with id='||p_wip_entity_id,
3361: p_stmt_num => l_stmt_num ,
3362: p_msg_tokens => l_msg_tokens,
3363: p_fnd_log_level => g_log_level_statement,
3364: p_run_log_level => l_log_level
3365: );
3366: End if;
3367:
3421: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
3422: THEN
3423: WSM_log_PVT.handle_others( p_module_name => l_module ,
3424: p_stmt_num => l_stmt_num ,
3425: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
3426: p_run_log_level => l_log_level
3427: );
3428: END IF;
3429: END CHANGE_ROUTING;
3466: l_rtg_op_seq_num NUMBER;
3467:
3468: -- Logging variables.....
3469: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
3470: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3471:
3472: l_stmt_num NUMBER;
3473: l_module VARCHAR2(100) := 'wsm.plsql.WSMJUPDB.UPDATE_ASSEMBLY_OR_ROUTING';
3474:
3508: p_msg_text => 'Handle_kanban_sub_loc_change returned error: ' || x_err_buf,
3509: p_stmt_num => l_stmt_num ,
3510: p_msg_tokens => l_msg_tokens,
3511: p_fnd_msg_level => G_MSG_LVL_ERROR ,
3512: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3513: p_run_log_level => l_log_level
3514: );
3515: END IF;
3516: RAISE FND_API.G_EXC_ERROR;
3578: p_msg_name => 'WSM_KNBN_CARD_STS_FAIL',
3579: p_msg_appl_name => 'WSM' ,
3580: p_msg_tokens => l_msg_tokens ,
3581: p_fnd_msg_level => G_MSG_LVL_ERROR ,
3582: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3583: p_run_log_level => l_log_level
3584: );
3585: END IF;
3586: RAISE FND_API.G_EXC_ERROR;
3641: p_msg_text => 'CHANGE_ROUTING returned error:'||x_err_buf,
3642: p_stmt_num => l_stmt_num ,
3643: p_msg_tokens => l_msg_tokens,
3644: p_fnd_msg_level => G_MSG_LVL_ERROR ,
3645: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3646: p_run_log_level => l_log_level
3647: );
3648: END IF;
3649: RAISE FND_API.G_EXC_ERROR;
3655: WSM_log_PVT.logMessage(p_module_name => l_module ,
3656: p_msg_text => 'Added new operation sequence '||l_new_op_added||' to the job',
3657: p_stmt_num => l_stmt_num ,
3658: p_msg_tokens => l_msg_tokens,
3659: p_fnd_log_level => g_log_level_statement,
3660: p_run_log_level => l_log_level
3661: );
3662: End if;
3663: END IF;
3747: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
3748: THEN
3749: WSM_log_PVT.handle_others( p_module_name => l_module ,
3750: p_stmt_num => l_stmt_num ,
3751: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
3752: p_run_log_level => l_log_level
3753: );
3754: END IF;
3755:
3783: l_err_buf varchar2(2000);
3784:
3785: -- Logging variables.....
3786: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
3787: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3788:
3789: l_stmt_num NUMBER;
3790: l_module VARCHAR2(100) := 'wsm.plsql.WSMJUPDB.Insert_MMT_record';
3791:
3819: p_msg_text => 'WSMPUTIL.GET_INV_ACCT_PERIOD returned error:' || l_err_buf,
3820: p_stmt_num => l_stmt_num ,
3821: p_msg_tokens => l_msg_tokens,
3822: p_fnd_msg_level => G_MSG_LVL_ERROR ,
3823: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3824: p_run_log_level => l_log_level
3825: );
3826: END IF;
3827: RAISE FND_API.G_EXC_ERROR;
3920: p_msg_name => 'WSM_INS_TBL_FAILED',
3921: p_msg_appl_name => 'WSM' ,
3922: p_msg_tokens => l_msg_tokens ,
3923: p_fnd_msg_level => G_MSG_LVL_ERROR ,
3924: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3925: p_run_log_level => l_log_level
3926: );
3927: END IF;
3928:
3957: WSM_log_PVT.logMessage (p_module_name => l_module ,
3958: p_msg_text => SUBSTRB('Unexpected Error : SQLCODE '|| SQLCODE ||' : SQLERRM : '|| SQLERRM, 1, 2000),
3959: p_stmt_num => l_stmt_num ,
3960: p_msg_tokens => l_msg_tokens ,
3961: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
3962: p_run_log_level => l_log_level
3963: );
3964:
3965: END IF;
3968: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
3969: THEN
3970: WSM_log_PVT.handle_others( p_module_name => l_module ,
3971: p_stmt_num => l_stmt_num ,
3972: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
3973: p_run_log_level => l_log_level
3974: );
3975: END IF;
3976:
4008: l_rep_wip_entity_id NUMBER;
4009:
4010: -- Logging variables.....
4011: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
4012: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4013:
4014: l_stmt_num NUMBER;
4015: l_module VARCHAR2(100) := 'wsm.plsql.WSMPJUPDB.CREATE_COPIES_OR_SET_COPY_DATA';
4016: -- Logging variables...
4114: p_msg_text => 'WSM_JobCopies_PVT.Create_JobCopies returned error:' || x_err_buf,
4115: p_stmt_num => l_stmt_num ,
4116: p_msg_tokens => l_msg_tokens,
4117: p_fnd_msg_level => G_MSG_LVL_ERROR ,
4118: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4119: p_run_log_level => l_log_level
4120: );
4121: END IF;
4122: RAISE FND_API.G_EXC_ERROR;
4127: WSM_log_PVT.logMessage(p_module_name => l_module ,
4128: p_msg_text => 'WSM_JobCopies_PVT.Create_JobCopies returned success',
4129: p_stmt_num => l_stmt_num ,
4130: p_msg_tokens => l_msg_tokens,
4131: p_fnd_log_level => g_log_level_statement,
4132: p_run_log_level => l_log_level
4133: );
4134: End if;
4135:
4145: WSM_log_PVT.logMessage(p_module_name => l_module ,
4146: p_msg_text => 'Set internal_copy_type = 2 for we_id=',
4147: p_stmt_num => l_stmt_num ,
4148: p_msg_tokens => l_msg_tokens,
4149: p_fnd_log_level => g_log_level_statement,
4150: p_run_log_level => l_log_level
4151: );
4152: End if;
4153:
4197: p_msg_text => 'new we_id :'||p_wltx_resulting_jobs_tbl(l_job_counter).wip_entity_id||
4198: 'rep_job_we_id :'||l_rep_wip_entity_id,
4199: p_stmt_num => l_stmt_num ,
4200: p_msg_tokens => l_msg_tokens,
4201: p_fnd_log_level => g_log_level_statement,
4202: p_run_log_level => l_log_level
4203: );
4204: End if;
4205:
4230: p_msg_text => 'WSM_JobCopies_PVT.Create_RepJobCopies returned error:' || x_err_buf,
4231: p_stmt_num => l_stmt_num ,
4232: p_msg_tokens => l_msg_tokens,
4233: p_fnd_msg_level => G_MSG_LVL_ERROR ,
4234: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4235: p_run_log_level => l_log_level
4236: );
4237: END IF;
4238: RAISE FND_API.G_EXC_ERROR;
4245: WSM_log_PVT.logMessage(p_module_name => l_module ,
4246: p_msg_text => 'WSM_JobCopies_PVT.Create_RepJobCopies returned success',
4247: p_stmt_num => l_stmt_num ,
4248: p_msg_tokens => l_msg_tokens,
4249: p_fnd_log_level => g_log_level_statement,
4250: p_run_log_level => l_log_level
4251: );
4252: End if;
4253:
4264: WSM_log_PVT.logMessage(p_module_name => l_module ,
4265: p_msg_text => 'Set internal_copy_type = '||l_new_job_int_copy_type||' for we_id=',
4266: p_stmt_num => l_stmt_num ,
4267: p_msg_tokens => l_msg_tokens,
4268: p_fnd_log_level => g_log_level_statement,
4269: p_run_log_level => l_log_level
4270: );
4271: End if;
4272:
4283: WSM_log_PVT.logMessage(p_module_name => l_module ,
4284: p_msg_text => 'Set copy_parent_wip_entity_id = '||nvl(l_rep_job_par_we_id, l_rep_wip_entity_id)||' for we_id=',
4285: p_stmt_num => l_stmt_num ,
4286: p_msg_tokens => l_msg_tokens,
4287: p_fnd_log_level => g_log_level_statement,
4288: p_run_log_level => l_log_level
4289: );
4290: End if;
4291:
4375: p_msg_text => 'WSM_JobCopies_PVT.Create_JobCopies returned error:' || x_err_buf,
4376: p_stmt_num => l_stmt_num ,
4377: p_msg_tokens => l_msg_tokens,
4378: p_fnd_msg_level => G_MSG_LVL_ERROR ,
4379: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4380: p_run_log_level => l_log_level
4381: );
4382: END IF;
4383: RAISE FND_API.G_EXC_ERROR;
4388: WSM_log_PVT.logMessage(p_module_name => l_module ,
4389: p_msg_text => 'WSM_JobCopies_PVT.Create_JobCopies returned success',
4390: p_stmt_num => l_stmt_num ,
4391: p_msg_tokens => l_msg_tokens,
4392: p_fnd_log_level => g_log_level_statement,
4393: p_run_log_level => l_log_level
4394: );
4395: End if;
4396:
4407: WSM_log_PVT.logMessage(p_module_name => l_module ,
4408: p_msg_text => 'Set internal_copy_type = 2 for we_id=',
4409: p_stmt_num => l_stmt_num ,
4410: p_msg_tokens => l_msg_tokens,
4411: p_fnd_log_level => g_log_level_statement,
4412: p_run_log_level => l_log_level
4413: );
4414: End if;
4415:
4507: p_msg_text => 'WSM_JobCopies_PVT.Create_JobCopies returned error:' || x_err_buf,
4508: p_stmt_num => l_stmt_num ,
4509: p_msg_tokens => l_msg_tokens,
4510: p_fnd_msg_level => G_MSG_LVL_ERROR ,
4511: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4512: p_run_log_level => l_log_level
4513: );
4514: END IF;
4515: RAISE FND_API.G_EXC_ERROR;
4520: WSM_log_PVT.logMessage(p_module_name => l_module ,
4521: p_msg_text => 'WSM_JobCopies_PVT.Create_JobCopies returned success',
4522: p_stmt_num => l_stmt_num ,
4523: p_msg_tokens => l_msg_tokens,
4524: p_fnd_log_level => g_log_level_statement,
4525: p_run_log_level => l_log_level
4526: );
4527: End if;
4528:
4538: WSM_log_PVT.logMessage(p_module_name => l_module ,
4539: p_msg_text => 'Set internal_copy_type = 2 for we_id='||l_rep_wip_entity_id,
4540: p_stmt_num => l_stmt_num ,
4541: p_msg_tokens => l_msg_tokens,
4542: p_fnd_log_level => g_log_level_statement,
4543: p_run_log_level => l_log_level
4544: );
4545: End if;
4546:
4586: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
4587: THEN
4588: WSM_log_PVT.handle_others( p_module_name => l_module ,
4589: p_stmt_num => l_stmt_num ,
4590: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
4591: p_run_log_level => l_log_level
4592: );
4593: END IF;
4594:
4622: l_returnStatus VARCHAR2(1);
4623: x_msg_count number;
4624: -- Logging variables.....
4625: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
4626: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4627:
4628: l_stmt_num NUMBER;
4629: l_module VARCHAR2(100) := 'wsm.plsql.WSMPJUPDB.CALL_INF_SCH_OR_SET_SCH_DATA';
4630: -- Logging variables...
4663: p_msg_text => 'GET_JOB_CURR_OP_INFO returned error:' || x_err_buf,
4664: p_stmt_num => l_stmt_num ,
4665: p_msg_tokens => l_msg_tokens,
4666: p_fnd_msg_level => G_MSG_LVL_ERROR ,
4667: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4668: p_run_log_level => l_log_level
4669: );
4670: END IF;
4671: RAISE FND_API.G_EXC_ERROR;
4700: p_msg_text => 'WSM_infinite_scheduler_PVT.schedule returned error:' || x_err_buf,
4701: p_stmt_num => l_stmt_num ,
4702: p_msg_tokens => l_msg_tokens,
4703: p_fnd_msg_level => G_MSG_LVL_ERROR ,
4704: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4705: p_run_log_level => l_log_level
4706: );
4707: END IF;
4708: RAISE FND_API.G_EXC_ERROR;
4751: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
4752: THEN
4753: WSM_log_PVT.handle_others( p_module_name => l_module ,
4754: p_stmt_num => l_stmt_num ,
4755: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
4756: p_run_log_level => l_log_level
4757: );
4758: END IF;
4759:
4835:
4836: /*logging variables*/
4837: l_stmt_num number := 0;
4838: l_msg_tokens WSM_log_PVT.token_rec_tbl;
4839: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4840: l_module VARCHAR2(100) := 'wsm.plsql.WSMPJUPD.process_lots';
4841:
4842:
4843: BEGIN
4967: WSM_log_PVT.logMessage(p_module_name => l_module ,
4968: p_msg_text => 'Calling WSMPLBJI.build_lbji_info procedure',
4969: p_stmt_num => l_stmt_num ,
4970: p_msg_tokens => l_msg_tokens,
4971: p_fnd_log_level => g_log_level_statement,
4972: p_run_log_level => l_log_level
4973: );
4974: End if;
4975:
5064: p_msg_text => 'Returned failure from WSMPLBJI.build_lbji_info procedure' ,
5065: p_stmt_num => l_stmt_num ,
5066: p_msg_tokens => l_msg_tokens,
5067: p_fnd_msg_level => G_MSG_LVL_ERROR ,
5068: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5069: p_run_log_level => l_log_level
5070: );
5071: END IF;
5072: RAISE FND_API.G_EXC_ERROR;
5077: WSM_log_PVT.logMessage(p_module_name => l_module ,
5078: p_msg_text => 'Returned successfully from WSMPLBJI.build_lbji_info procedure',
5079: p_stmt_num => l_stmt_num ,
5080: p_msg_tokens => l_msg_tokens,
5081: p_fnd_log_level => g_log_level_statement,
5082: p_run_log_level => l_log_level
5083: );
5084: End if;
5085: p_wltx_resulting_jobs_tbl(l_job_counter).wip_entity_id := l_new_we_id;
5101: WSM_log_PVT.logMessage(p_module_name => l_module ,
5102: p_msg_text => 'Calling WSM_lbj_interface_PVT.build_job_header_info',
5103: p_stmt_num => l_stmt_num ,
5104: p_msg_tokens => l_msg_tokens,
5105: p_fnd_log_level => g_log_level_statement,
5106: p_run_log_level => l_log_level
5107: );
5108: End if;
5109:
5195: p_msg_text => 'Returned failure from WSM_lbj_interface_PVT.build_job_header_info'||l_err_buf,
5196: p_stmt_num => l_stmt_num ,
5197: p_msg_tokens => l_msg_tokens,
5198: p_fnd_msg_level => G_MSG_LVL_ERROR ,
5199: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5200: p_run_log_level => l_log_level
5201: );
5202: END IF;
5203: RAISE FND_API.G_EXC_ERROR;
5209: WSM_log_PVT.logMessage(p_module_name => l_module ,
5210: p_msg_text => 'Returned success from WSM_lbj_interface_PVT.build_job_header_info',
5211: p_stmt_num => l_stmt_num ,
5212: p_msg_tokens => l_msg_tokens,
5213: p_fnd_log_level => g_log_level_statement,
5214: p_run_log_level => l_log_level
5215: );
5216: End if;
5217:
5254: WSM_log_PVT.logMessage(p_module_name => l_module ,
5255: p_msg_text => 'Calling INV_Kanban_PVT.Update_Card_Supply_Status',
5256: p_stmt_num => l_stmt_num ,
5257: p_msg_tokens => l_msg_tokens,
5258: p_fnd_log_level => g_log_level_statement,
5259: p_run_log_level => l_log_level
5260: );
5261: End if;
5262:
5279: p_msg_name => 'WSM_KNBN_CARD_STS_FAIL',
5280: p_msg_appl_name => 'WSM' ,
5281: p_msg_tokens => l_msg_tokens ,
5282: p_fnd_msg_level => G_MSG_LVL_ERROR ,
5283: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5284: p_run_log_level => l_log_level
5285: );
5286: END IF;
5287:
5322: WSM_log_PVT.logMessage(p_module_name => l_module ,
5323: p_msg_text => 'Calling COPY_REP_JOB_WO_FA ' || p_wltx_starting_jobs_tbl(l_rep_sj_index).operation_seq_num,
5324: p_stmt_num => l_stmt_num ,
5325: p_msg_tokens => l_msg_tokens,
5326: p_fnd_log_level => g_log_level_statement,
5327: p_run_log_level => l_log_level
5328: );
5329: End if;
5330: l_err_code := 0;
5351: p_msg_text => 'Returned failure from COPY_REP_JOB_WO_FA',
5352: p_stmt_num => l_stmt_num ,
5353: p_msg_tokens => l_msg_tokens,
5354: p_fnd_msg_level => G_MSG_LVL_ERROR ,
5355: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5356: p_run_log_level => l_log_level
5357: );
5358: END IF;
5359: RAISE FND_API.G_EXC_ERROR;
5366: WSM_log_PVT.logMessage(p_module_name => l_module ,
5367: p_msg_text => 'Calling COPY_REP_JOB_WOR ',
5368: p_stmt_num => l_stmt_num ,
5369: p_msg_tokens => l_msg_tokens,
5370: p_fnd_log_level => g_log_level_statement,
5371: p_run_log_level => l_log_level
5372: );
5373: End if;
5374: l_err_code := 0;
5390: p_msg_text => 'Returned failure from COPY_REP_JOB_WOR',
5391: p_stmt_num => l_stmt_num ,
5392: p_msg_tokens => l_msg_tokens,
5393: p_fnd_msg_level => G_MSG_LVL_ERROR ,
5394: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5395: p_run_log_level => l_log_level
5396: );
5397: END IF;
5398: RAISE FND_API.G_EXC_ERROR;
5415: WSM_log_PVT.logMessage(p_module_name => l_module ,
5416: p_msg_text => 'Calling COPY_REP_JOB_WSOR ',
5417: p_stmt_num => l_stmt_num ,
5418: p_msg_tokens => l_msg_tokens,
5419: p_fnd_log_level => g_log_level_statement,
5420: p_run_log_level => l_log_level
5421: );
5422: End if;
5423:
5437: p_msg_text => 'Returned failure from COPY_REP_JOB_WSOR',
5438: p_stmt_num => l_stmt_num ,
5439: p_msg_tokens => l_msg_tokens,
5440: p_fnd_msg_level => G_MSG_LVL_ERROR ,
5441: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5442: p_run_log_level => l_log_level
5443: );
5444: END IF;
5445: RAISE FND_API.G_EXC_ERROR;
5468: p_msg_text => 'Returned failure from COPY_REP_JOB_WORI',
5469: p_stmt_num => l_stmt_num,
5470: p_msg_tokens => l_msg_tokens,
5471: p_fnd_msg_level => G_MSG_LVL_ERROR,
5472: p_fnd_log_level => G_LOG_LEVEL_ERROR,
5473: p_run_log_level => l_log_level
5474: );
5475: END IF;
5476: RAISE FND_API.G_EXC_ERROR;
5483: WSM_log_PVT.logMessage(p_module_name => l_module,
5484: p_msg_text => 'Calling COPY_REP_JOB_WRO',
5485: p_stmt_num => l_stmt_num,
5486: p_msg_tokens => l_msg_tokens,
5487: p_fnd_log_level => g_log_level_statement,
5488: p_run_log_level => l_log_level
5489: );
5490: End if;
5491:
5511: p_msg_text => 'Returned failure from COPY_REP_JOB_WRO',
5512: p_stmt_num => l_stmt_num ,
5513: p_msg_tokens => l_msg_tokens,
5514: p_fnd_msg_level => G_MSG_LVL_ERROR ,
5515: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5516: p_run_log_level => l_log_level
5517: );
5518: END IF;
5519: RAISE FND_API.G_EXC_ERROR;
5526: WSM_log_PVT.logMessage(p_module_name => l_module ,
5527: p_msg_text => 'Calling COPY_REP_JOB_WOY ',
5528: p_stmt_num => l_stmt_num ,
5529: p_msg_tokens => l_msg_tokens,
5530: p_fnd_log_level => g_log_level_statement,
5531: p_run_log_level => l_log_level
5532: );
5533: End if;
5534: l_err_code := 0;
5550: p_msg_text => 'Returned failure from COPY_REP_JOB_WOY',
5551: p_stmt_num => l_stmt_num ,
5552: p_msg_tokens => l_msg_tokens,
5553: p_fnd_msg_level => G_MSG_LVL_ERROR ,
5554: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5555: p_run_log_level => l_log_level
5556: );
5557: END IF;
5558: RAISE FND_API.G_EXC_ERROR;
5564: WSM_log_PVT.logMessage(p_module_name => l_module ,
5565: p_msg_text => ' processing the starting jobs...',
5566: p_stmt_num => l_stmt_num ,
5567: p_msg_tokens => l_msg_tokens,
5568: p_fnd_log_level => g_log_level_statement,
5569: p_run_log_level => l_log_level
5570: );
5571: End if;
5572:
5589: || ' Starting Job index(l_job_counter) : ' || l_job_counter
5590: || ' Resulting Job index(l_sj_also_rj_index) : ' || l_sj_also_rj_index,
5591: p_stmt_num => l_stmt_num ,
5592: p_msg_tokens => l_msg_tokens,
5593: p_fnd_log_level => g_log_level_statement,
5594: p_run_log_level => l_log_level
5595: );
5596: End if;
5597: -- related bugs : 3181486
5629: WSM_log_PVT.logMessage(p_module_name => l_module ,
5630: p_msg_text => ' Calling INV_Kanban_PVT.Update_Card_Supply_Status...',
5631: p_stmt_num => l_stmt_num ,
5632: p_msg_tokens => l_msg_tokens,
5633: p_fnd_log_level => g_log_level_statement,
5634: p_run_log_level => l_log_level
5635: );
5636: End if;
5637:
5652: p_msg_name => 'WSM_KNBN_CARD_STS_FAIL',
5653: p_msg_appl_name => 'WSM' ,
5654: p_msg_tokens => l_msg_tokens ,
5655: p_fnd_msg_level => G_MSG_LVL_ERROR ,
5656: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5657: p_run_log_level => l_log_level
5658: );
5659: END IF;
5660: RAISE FND_API.G_EXC_ERROR;
5670: WSM_log_PVT.logMessage(p_module_name => l_module ,
5671: p_msg_text => ' Calling handle_kanban_sub_loc_change...',
5672: p_stmt_num => l_stmt_num ,
5673: p_msg_tokens => l_msg_tokens,
5674: p_fnd_log_level => g_log_level_statement,
5675: p_run_log_level => l_log_level
5676: );
5677: End if;
5678:
5697: p_msg_text => 'Returned failure from handle_kanban_sub_loc_change',
5698: p_stmt_num => l_stmt_num ,
5699: p_msg_tokens => l_msg_tokens,
5700: p_fnd_msg_level => G_MSG_LVL_ERROR ,
5701: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5702: p_run_log_level => l_log_level
5703: );
5704: END IF;
5705: RAISE FND_API.G_EXC_ERROR;
5718: WSM_log_PVT.logMessage(p_module_name => l_module ,
5719: p_msg_text => ' Calling INV_Kanban_PVT.Update_Card_Supply_Status...',
5720: p_stmt_num => l_stmt_num ,
5721: p_msg_tokens => l_msg_tokens,
5722: p_fnd_log_level => g_log_level_statement,
5723: p_run_log_level => l_log_level
5724: );
5725: End if;
5726:
5744: p_msg_name => 'WSM_KNBN_CARD_STS_FAIL',
5745: p_msg_appl_name => 'WSM' ,
5746: p_msg_tokens => l_msg_tokens ,
5747: p_fnd_msg_level => G_MSG_LVL_ERROR ,
5748: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5749: p_run_log_level => l_log_level
5750: );
5751: END IF;
5752: RAISE FND_API.G_EXC_ERROR;
5767: WSM_log_PVT.logMessage(p_module_name => l_module ,
5768: p_msg_text => 'Updating the completion subinv and the kanban card id ...',
5769: p_stmt_num => l_stmt_num ,
5770: p_msg_tokens => l_msg_tokens,
5771: p_fnd_log_level => g_log_level_statement,
5772: p_run_log_level => l_log_level
5773: );
5774: End if;
5775:
5792: WSM_log_PVT.logMessage(p_module_name => l_module ,
5793: p_msg_text => 'starting job has been completely merged/split or a non-representative job... ',
5794: p_stmt_num => l_stmt_num ,
5795: p_msg_tokens => l_msg_tokens,
5796: p_fnd_log_level => g_log_level_statement,
5797: p_run_log_level => l_log_level
5798: );
5799: End if;
5800:
5850: p_msg_name => 'WSM_KNBN_CARD_STS_FAIL',
5851: p_msg_appl_name => 'WSM' ,
5852: p_msg_tokens => l_msg_tokens ,
5853: p_fnd_msg_level => G_MSG_LVL_ERROR ,
5854: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5855: p_run_log_level => l_log_level
5856: );
5857: END IF;
5858: RAISE FND_API.G_EXC_ERROR;
5907: p_msg_text => l_err_buf , /* Bugfix 5738550 removed hardcoding */
5908: p_stmt_num => l_stmt_num ,
5909: p_msg_tokens => l_msg_tokens,
5910: p_fnd_msg_level => G_MSG_LVL_ERROR ,
5911: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5912: p_run_log_level => l_log_level
5913: );
5914: END IF;
5915: RAISE FND_API.G_EXC_ERROR;
5920: WSM_log_PVT.logMessage(p_module_name => l_module ,
5921: p_msg_text => 'WSMPOPRN.update_job_name success.Got new job name',
5922: p_stmt_num => l_stmt_num ,
5923: p_msg_tokens => l_msg_tokens,
5924: p_fnd_log_level => g_log_level_statement,
5925: p_run_log_level => l_log_level
5926: );
5927: End if;
5928: end if;
5941: WSM_log_PVT.logMessage(p_module_name => l_module ,
5942: p_msg_text => 'Calling CHANGE_QUANTITY',
5943: p_stmt_num => l_stmt_num ,
5944: p_msg_tokens => l_msg_tokens,
5945: p_fnd_log_level => g_log_level_statement,
5946: p_run_log_level => l_log_level
5947: );
5948: End if;
5949:
5975: p_msg_text => 'CHANGE_QUANTITY returned failure' ,
5976: p_stmt_num => l_stmt_num ,
5977: p_msg_tokens => l_msg_tokens,
5978: p_fnd_msg_level => G_MSG_LVL_ERROR ,
5979: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5980: p_run_log_level => l_log_level
5981: );
5982: END IF;
5983: RAISE FND_API.G_EXC_ERROR;
5989: WSM_log_PVT.logMessage(p_module_name => l_module ,
5990: p_msg_text => 'Calling UPDATE_QTY_ISSUED',
5991: p_stmt_num => l_stmt_num ,
5992: p_msg_tokens => l_msg_tokens,
5993: p_fnd_log_level => g_log_level_statement,
5994: p_run_log_level => l_log_level
5995: );
5996: End if;
5997:
6020: p_msg_text => 'UPDATE_QTY_ISSUED returned failure' ,
6021: p_stmt_num => l_stmt_num ,
6022: p_msg_tokens => l_msg_tokens,
6023: p_fnd_msg_level => G_MSG_LVL_ERROR ,
6024: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6025: p_run_log_level => l_log_level
6026: );
6027: END IF;
6028: RAISE FND_API.G_EXC_ERROR;
6044: WSM_log_PVT.logMessage(p_module_name => l_module ,
6045: p_msg_text => 'Calling UPDATE_ASSEMBLY_OR_ROUTING',
6046: p_stmt_num => l_stmt_num ,
6047: p_msg_tokens => l_msg_tokens,
6048: p_fnd_log_level => g_log_level_statement,
6049: p_run_log_level => l_log_level
6050: );
6051: End if;
6052:
6077: p_msg_text => 'UPDATE_ASSEMBLY_OR_ROUTING returned failure' ,
6078: p_stmt_num => l_stmt_num ,
6079: p_msg_tokens => l_msg_tokens,
6080: p_fnd_msg_level => G_MSG_LVL_ERROR ,
6081: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6082: p_run_log_level => l_log_level
6083: );
6084: END IF;
6085: RAISE FND_API.G_EXC_ERROR;
6151: p_msg_text => 'CREATE_COPIES_OR_SET_COPY_DATA returned '||l_err_code,
6152: p_stmt_num => l_stmt_num ,
6153: p_msg_tokens => l_msg_tokens,
6154: p_fnd_msg_level => G_MSG_LVL_ERROR ,
6155: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6156: p_run_log_level => l_log_level
6157: );
6158: END IF;
6159: RAISE FND_API.G_EXC_ERROR; --x_err_code has errcode, x_err_buf has the error message
6192: p_msg_text => ' CALL_INF_SCH_OR_SET_SCH_DATA returned '||l_err_code,
6193: p_stmt_num => l_stmt_num ,
6194: p_msg_tokens => l_msg_tokens,
6195: p_fnd_msg_level => G_MSG_LVL_ERROR ,
6196: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6197: p_run_log_level => l_log_level
6198: );
6199: END IF;
6200: RAISE FND_API.G_EXC_ERROR;
6285: WSM_log_PVT.logMessage(p_module_name => l_module ,
6286: p_msg_text => 'inv_genealogy_pub.insert_genealogy returned success',
6287: p_stmt_num => l_stmt_num ,
6288: p_msg_tokens => l_msg_tokens,
6289: p_fnd_log_level => g_log_level_statement,
6290: p_run_log_level => l_log_level
6291: );
6292: End if;
6293:
6300: p_msg_text => 'inv_genealogy_pub.insert_genealogy failed',
6301: p_stmt_num => l_stmt_num ,
6302: p_msg_tokens => l_msg_tokens,
6303: p_fnd_msg_level => G_MSG_LVL_ERROR ,
6304: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6305: p_run_log_level => l_log_level
6306: );
6307: END IF;
6308:
6391: WSM_log_PVT.logMessage(p_module_name => l_module ,
6392: p_msg_text => 'inv_genealogy_pub.insert_genealogy returned success',
6393: p_stmt_num => l_stmt_num ,
6394: p_msg_tokens => l_msg_tokens,
6395: p_fnd_log_level => g_log_level_statement,
6396: p_run_log_level => l_log_level
6397: );
6398: End if;
6399: ELSE
6404: p_msg_text => 'inv_genealogy_pub.insert_genealogy failed',
6405: p_stmt_num => l_stmt_num ,
6406: p_msg_tokens => l_msg_tokens,
6407: p_fnd_msg_level => G_MSG_LVL_ERROR ,
6408: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6409: p_run_log_level => l_log_level
6410: );
6411: END IF;
6412:
6460: p_msg_text => 'Insert_MMT_record failed',
6461: p_stmt_num => l_stmt_num ,
6462: p_msg_tokens => l_msg_tokens,
6463: p_fnd_msg_level => G_MSG_LVL_ERROR ,
6464: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6465: p_run_log_level => l_log_level
6466: );
6467: END IF;
6468: RAISE FND_API.G_EXC_ERROR;
6501: p_msg_text => 'UPDATE_ASSEMBLY_OR_ROUTING failed',
6502: p_stmt_num => l_stmt_num ,
6503: p_msg_tokens => l_msg_tokens,
6504: p_fnd_msg_level => G_MSG_LVL_ERROR ,
6505: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6506: p_run_log_level => l_log_level
6507: );
6508: END IF;
6509: RAISE FND_API.G_EXC_ERROR;
6532: p_msg_text => 'UPDATE_ASSEMBLY_OR_ROUTING failed',
6533: p_stmt_num => l_stmt_num ,
6534: p_msg_tokens => l_msg_tokens,
6535: p_fnd_msg_level => G_MSG_LVL_ERROR ,
6536: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6537: p_run_log_level => l_log_level
6538: );
6539: END IF;
6540: RAISE FND_API.G_EXC_ERROR;
6607: p_msg_text => 'CHANGE_QUANTITY failed',
6608: p_stmt_num => l_stmt_num ,
6609: p_msg_tokens => l_msg_tokens,
6610: p_fnd_msg_level => G_MSG_LVL_ERROR ,
6611: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6612: p_run_log_level => l_log_level
6613: );
6614: END IF;
6615: RAISE FND_API.G_EXC_ERROR;
6647: p_msg_text => 'UPDATE_QTY_ISSUED failed',
6648: p_stmt_num => l_stmt_num ,
6649: p_msg_tokens => l_msg_tokens,
6650: p_fnd_msg_level => G_MSG_LVL_ERROR ,
6651: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6652: p_run_log_level => l_log_level
6653: );
6654: END IF;
6655: RAISE FND_API.G_EXC_ERROR;
6685: p_msg_text => 'handle_kanban_sub_loc_change failed',
6686: p_stmt_num => l_stmt_num ,
6687: p_msg_tokens => l_msg_tokens,
6688: p_fnd_msg_level => G_MSG_LVL_ERROR ,
6689: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6690: p_run_log_level => l_log_level
6691: );
6692: END IF;
6693: RAISE FND_API.G_EXC_ERROR;
6726: p_msg_name => 'WSM_KNBN_CARD_STS_FAIL',
6727: p_msg_appl_name => 'WSM' ,
6728: p_msg_tokens => l_msg_tokens ,
6729: p_fnd_msg_level => G_MSG_LVL_ERROR ,
6730: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6731: p_run_log_level => l_log_level
6732: );
6733: END IF;
6734:
6820: p_msg_text => 'CALL_INF_SCH_OR_SET_SCH_DATA returned failure:'||l_err_code,
6821: p_stmt_num => l_stmt_num ,
6822: p_msg_tokens => l_msg_tokens,
6823: p_fnd_msg_level => G_MSG_LVL_ERROR ,
6824: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6825: p_run_log_level => l_log_level
6826: );
6827: END IF;
6828: RAISE FND_API.G_EXC_ERROR;
6884: p_msg_text => 'Insert_MMT_record failed',
6885: p_stmt_num => l_stmt_num ,
6886: p_msg_tokens => l_msg_tokens,
6887: p_fnd_msg_level => G_MSG_LVL_ERROR ,
6888: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6889: p_run_log_level => l_log_level
6890: );
6891: END IF;
6892: RAISE FND_API.G_EXC_ERROR;
6907: WSM_log_PVT.logMessage(p_module_name => l_module ,
6908: p_msg_text => 'Transaction type is Update Lotname:',
6909: p_stmt_num => l_stmt_num ,
6910: p_msg_tokens => l_msg_tokens,
6911: p_fnd_log_level => g_log_level_statement,
6912: p_run_log_level => l_log_level
6913: );
6914: End if;
6915:
6960: p_msg_name => 'WSM_RESULT_LOT_REQUIRED',
6961: p_msg_appl_name => 'WSM',
6962: p_msg_tokens => l_msg_tokens ,
6963: p_fnd_msg_level => G_MSG_LVL_ERROR ,
6964: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6965: p_run_log_level => l_log_level
6966: );
6967: END IF;
6968: RAISE FND_API.G_EXC_ERROR;
6980: WSM_log_PVT.logMessage(p_module_name => l_module ,
6981: p_msg_text => 'Calling WSMPLBJI.build_lbji_info procedure'||p_wltx_resulting_jobs_tbl(l_rj_index).class_code,
6982: p_stmt_num => l_stmt_num ,
6983: p_msg_tokens => l_msg_tokens,
6984: p_fnd_log_level => g_log_level_statement,
6985: p_run_log_level => l_log_level
6986: );
6987: End if;
6988:
7077: p_msg_text => 'Returned failure from WSMPLBJI.build_lbji_info procedure'||l_err_buf,
7078: p_stmt_num => l_stmt_num ,
7079: p_msg_tokens => l_msg_tokens,
7080: p_fnd_msg_level => G_MSG_LVL_ERROR ,
7081: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
7082: p_run_log_level => l_log_level
7083: );
7084: END IF;
7085: RAISE FND_API.G_EXC_ERROR;
7090: WSM_log_PVT.logMessage(p_module_name => l_module ,
7091: p_msg_text => 'Returned successfully from WSMPLBJI.build_lbji_info procedure',
7092: p_stmt_num => l_stmt_num ,
7093: p_msg_tokens => l_msg_tokens,
7094: p_fnd_log_level => g_log_level_statement,
7095: p_run_log_level => l_log_level
7096: );
7097: End if;
7098: p_wltx_resulting_jobs_tbl(l_rj_index).wip_entity_id := l_new_we_id;
7129: p_msg_text => 'Returned failure from CREATE_WSOR_WLBJ_RECORDS',
7130: p_stmt_num => l_stmt_num ,
7131: p_msg_tokens => l_msg_tokens,
7132: p_fnd_msg_level => G_MSG_LVL_ERROR ,
7133: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
7134: p_run_log_level => l_log_level
7135: );
7136: END IF;
7137: RAISE FND_API.G_EXC_ERROR;
7141: WSM_log_PVT.logMessage(p_module_name => l_module ,
7142: p_msg_text => 'Created WSOR records for new job with id='||l_new_we_id,
7143: p_stmt_num => l_stmt_num ,
7144: p_msg_tokens => l_msg_tokens,
7145: p_fnd_log_level => g_log_level_statement,
7146: p_run_log_level => l_log_level
7147: );
7148: End if;
7149: END IF;
7163: WSM_log_PVT.logMessage(p_module_name => l_module ,
7164: p_msg_text => 'Updated the job seq num in resulting job record : ' || l_bonus_job_st_op_seq,
7165: p_stmt_num => l_stmt_num ,
7166: p_msg_tokens => l_msg_tokens,
7167: p_fnd_log_level => g_log_level_statement,
7168: p_run_log_level => l_log_level
7169: );
7170: End if;
7171:
7180: WSM_log_PVT.logMessage(p_module_name => l_module ,
7181: p_msg_text => 'Updated the op seq num in wip_operations',
7182: p_stmt_num => l_stmt_num,
7183: p_msg_tokens => l_msg_tokens,
7184: p_fnd_log_level => g_log_level_statement,
7185: p_run_log_level => l_log_level
7186: );
7187: End if;
7188:
7235: WSM_log_PVT.logMessage(p_module_name => l_module ,
7236: p_msg_text => 'Checking for open a/c period',
7237: p_stmt_num => l_stmt_num,
7238: p_msg_tokens => l_msg_tokens,
7239: p_fnd_log_level => g_log_level_statement,
7240: p_run_log_level => l_log_level
7241: );
7242: End if;
7243:
7258: p_msg_text => 'Accounting Period not open',
7259: p_stmt_num => l_stmt_num ,
7260: p_msg_tokens => l_msg_tokens,
7261: p_fnd_msg_level => G_MSG_LVL_ERROR ,
7262: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
7263: p_run_log_level => l_log_level
7264: );
7265: END IF;
7266: RAISE FND_API.G_EXC_ERROR;
7276: WSM_log_PVT.logMessage(p_module_name => l_module ,
7277: p_msg_text => 'Inserting MMT record',
7278: p_stmt_num => l_stmt_num,
7279: p_msg_tokens => l_msg_tokens,
7280: p_fnd_log_level => g_log_level_statement,
7281: p_run_log_level => l_log_level
7282: );
7283: End if;
7284:
7308: p_msg_text => 'Insert_MMT_record failed:'||l_msg_data,
7309: p_stmt_num => l_stmt_num ,
7310: p_msg_tokens => l_msg_tokens,
7311: p_fnd_msg_level => G_MSG_LVL_ERROR ,
7312: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
7313: p_run_log_level => l_log_level
7314: );
7315: END IF;
7316: RAISE FND_API.G_EXC_ERROR;
7340: p_msg_text => 'CREATE_COPIES_OR_SET_COPY_DATA returned failure ' || l_err_buf,
7341: p_stmt_num => l_stmt_num ,
7342: p_msg_tokens => l_msg_tokens,
7343: p_fnd_msg_level => G_MSG_LVL_ERROR ,
7344: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
7345: p_run_log_level => l_log_level
7346: );
7347: END IF;
7348: RAISE FND_API.G_EXC_ERROR; --x_err_code has errcode, x_err_buf has the error message
7386: p_msg_text => 'Invalid Txn type',
7387: p_stmt_num => l_stmt_num ,
7388: p_msg_tokens => l_msg_tokens,
7389: p_fnd_msg_level => G_MSG_LVL_ERROR ,
7390: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
7391: p_run_log_level => l_log_level
7392: );
7393: END IF;
7394: raise FND_API.G_EXC_ERROR;
7433: p_msg_text => 'WSM_RESERVATIONS_PVT.Modify_reservations_jobupdate failed:'||l_msg_data,
7434: p_stmt_num => l_stmt_num ,
7435: p_msg_tokens => l_msg_tokens,
7436: p_fnd_msg_level => G_MSG_LVL_ERROR ,
7437: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
7438: p_run_log_level => l_log_level
7439: );
7440: END IF;
7441: RAISE FND_API.G_EXC_ERROR;
7464: p_msg_text => 'WSM_RESERVATIONS_PVT.modify_reservations_wlt failed:'||l_msg_data,
7465: p_stmt_num => l_stmt_num ,
7466: p_msg_tokens => l_msg_tokens,
7467: p_fnd_msg_level => G_MSG_LVL_ERROR ,
7468: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
7469: p_run_log_level => l_log_level
7470: );
7471: END IF;
7472: --To be reverted
7498: p_msg_text => 'WSM_RESERVATIONS_PVT.modify_reservations_wlt failed:'||l_msg_data,
7499: p_stmt_num => l_stmt_num ,
7500: p_msg_tokens => l_msg_tokens,
7501: p_fnd_msg_level => G_MSG_LVL_ERROR ,
7502: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
7503: p_run_log_level => l_log_level
7504: );
7505: END IF;
7506: --To be reverted
7535: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
7536: THEN
7537: WSM_log_PVT.handle_others( p_module_name => l_module ,
7538: p_stmt_num => l_stmt_num ,
7539: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
7540: p_run_log_level => l_log_level
7541: );
7542: END IF;
7543:
7553: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
7554: THEN
7555: WSM_log_PVT.handle_others( p_module_name => l_module ,
7556: p_stmt_num => l_stmt_num ,
7557: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
7558: p_run_log_level => l_log_level
7559: );
7560: END IF;
7561: