[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: e_upd_txn Exception;
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_EXISTS',
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: if l_issued_resource <> 0 then
3124: p_msg_name => 'WSM_MANUAL_CHARGES_EXISTS',
3125: p_msg_appl_name => 'WSM' ,
3126: p_msg_tokens => l_msg_tokens ,
3127: p_fnd_msg_level => G_MSG_LVL_ERROR ,
3128: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3129: p_run_log_level => l_log_level
3130: );
3131: END IF;
3132: if l_issued_material <> 0 then
3145: p_msg_name => 'WSM_PHANTOM_COMPONENTS_EXISTS',
3146: p_msg_appl_name => 'WSM' ,
3147: p_msg_tokens => l_msg_tokens ,
3148: p_fnd_msg_level => G_MSG_LVL_ERROR ,
3149: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3150: p_run_log_level => l_log_level
3151: );
3152: END IF;
3153: END IF;
3245: WSM_log_PVT.logMessage(p_module_name => l_module ,
3246: p_msg_text => 'Calling WSMPLBJI.insert_procedure :' ||p_rj_job_rec.starting_operation_seq_id,
3247: p_stmt_num => l_stmt_num ,
3248: p_msg_tokens => l_msg_tokens,
3249: p_fnd_log_level => g_log_level_statement,
3250: p_run_log_level => l_log_level
3251: );
3252: End if;
3253:
3298: p_msg_text => 'Returned failure from WSMPLBJI.insert_procedure.Error:'|| x_err_buf,
3299: p_stmt_num => l_stmt_num ,
3300: p_msg_tokens => l_msg_tokens,
3301: p_fnd_msg_level => G_MSG_LVL_ERROR ,
3302: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3303: p_run_log_level => l_log_level
3304: );
3305: END IF;
3306: RAISE FND_API.G_EXC_ERROR;
3349: p_msg_text => 'Returned failure from CREATE_WSOR_WLBJ_RECORDS',
3350: p_stmt_num => l_stmt_num ,
3351: p_msg_tokens => l_msg_tokens,
3352: p_fnd_msg_level => G_MSG_LVL_ERROR ,
3353: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3354: p_run_log_level => l_log_level
3355: );
3356: END IF;
3357: RAISE FND_API.G_EXC_ERROR;
3362: WSM_log_PVT.logMessage(p_module_name => l_module ,
3363: p_msg_text => 'Created WSOR records for new job with id='||p_wip_entity_id,
3364: p_stmt_num => l_stmt_num ,
3365: p_msg_tokens => l_msg_tokens,
3366: p_fnd_log_level => g_log_level_statement,
3367: p_run_log_level => l_log_level
3368: );
3369: End if;
3370:
3427: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
3428: THEN
3429: WSM_log_PVT.handle_others( p_module_name => l_module ,
3430: p_stmt_num => l_stmt_num ,
3431: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
3432: p_run_log_level => l_log_level
3433: );
3434: END IF;
3435: END CHANGE_ROUTING;
3472: l_rtg_op_seq_num NUMBER;
3473:
3474: -- Logging variables.....
3475: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
3476: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3477:
3478: l_stmt_num NUMBER;
3479: l_module VARCHAR2(100) := 'wsm.plsql.WSMJUPDB.UPDATE_ASSEMBLY_OR_ROUTING';
3480:
3514: p_msg_text => 'Handle_kanban_sub_loc_change returned error: ' || x_err_buf,
3515: p_stmt_num => l_stmt_num ,
3516: p_msg_tokens => l_msg_tokens,
3517: p_fnd_msg_level => G_MSG_LVL_ERROR ,
3518: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3519: p_run_log_level => l_log_level
3520: );
3521: END IF;
3522: RAISE FND_API.G_EXC_ERROR;
3584: p_msg_name => 'WSM_KNBN_CARD_STS_FAIL',
3585: p_msg_appl_name => 'WSM' ,
3586: p_msg_tokens => l_msg_tokens ,
3587: p_fnd_msg_level => G_MSG_LVL_ERROR ,
3588: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3589: p_run_log_level => l_log_level
3590: );
3591: END IF;
3592: RAISE FND_API.G_EXC_ERROR;
3647: p_msg_text => 'CHANGE_ROUTING returned error:'||x_err_buf,
3648: p_stmt_num => l_stmt_num ,
3649: p_msg_tokens => l_msg_tokens,
3650: p_fnd_msg_level => G_MSG_LVL_ERROR ,
3651: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3652: p_run_log_level => l_log_level
3653: );
3654: END IF;
3655: RAISE FND_API.G_EXC_ERROR;
3661: WSM_log_PVT.logMessage(p_module_name => l_module ,
3662: p_msg_text => 'Added new operation sequence '||l_new_op_added||' to the job',
3663: p_stmt_num => l_stmt_num ,
3664: p_msg_tokens => l_msg_tokens,
3665: p_fnd_log_level => g_log_level_statement,
3666: p_run_log_level => l_log_level
3667: );
3668: End if;
3669: END IF;
3753: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
3754: THEN
3755: WSM_log_PVT.handle_others( p_module_name => l_module ,
3756: p_stmt_num => l_stmt_num ,
3757: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
3758: p_run_log_level => l_log_level
3759: );
3760: END IF;
3761:
3789: l_err_buf varchar2(2000);
3790:
3791: -- Logging variables.....
3792: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
3793: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3794:
3795: l_stmt_num NUMBER;
3796: l_module VARCHAR2(100) := 'wsm.plsql.WSMJUPDB.Insert_MMT_record';
3797:
3825: p_msg_text => 'WSMPUTIL.GET_INV_ACCT_PERIOD returned error:' || l_err_buf,
3826: p_stmt_num => l_stmt_num ,
3827: p_msg_tokens => l_msg_tokens,
3828: p_fnd_msg_level => G_MSG_LVL_ERROR ,
3829: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3830: p_run_log_level => l_log_level
3831: );
3832: END IF;
3833: RAISE FND_API.G_EXC_ERROR;
3926: p_msg_name => 'WSM_INS_TBL_FAILED',
3927: p_msg_appl_name => 'WSM' ,
3928: p_msg_tokens => l_msg_tokens ,
3929: p_fnd_msg_level => G_MSG_LVL_ERROR ,
3930: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3931: p_run_log_level => l_log_level
3932: );
3933: END IF;
3934:
3963: WSM_log_PVT.logMessage (p_module_name => l_module ,
3964: p_msg_text => SUBSTRB('Unexpected Error : SQLCODE '|| SQLCODE ||' : SQLERRM : '|| SQLERRM, 1, 2000),
3965: p_stmt_num => l_stmt_num ,
3966: p_msg_tokens => l_msg_tokens ,
3967: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
3968: p_run_log_level => l_log_level
3969: );
3970:
3971: END IF;
3974: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
3975: THEN
3976: WSM_log_PVT.handle_others( p_module_name => l_module ,
3977: p_stmt_num => l_stmt_num ,
3978: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
3979: p_run_log_level => l_log_level
3980: );
3981: END IF;
3982:
4014: l_rep_wip_entity_id NUMBER;
4015:
4016: -- Logging variables.....
4017: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
4018: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4019:
4020: l_stmt_num NUMBER;
4021: l_module VARCHAR2(100) := 'wsm.plsql.WSMPJUPDB.CREATE_COPIES_OR_SET_COPY_DATA';
4022: -- Logging variables...
4120: p_msg_text => 'WSM_JobCopies_PVT.Create_JobCopies returned error:' || x_err_buf,
4121: p_stmt_num => l_stmt_num ,
4122: p_msg_tokens => l_msg_tokens,
4123: p_fnd_msg_level => G_MSG_LVL_ERROR ,
4124: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4125: p_run_log_level => l_log_level
4126: );
4127: END IF;
4128: RAISE FND_API.G_EXC_ERROR;
4133: WSM_log_PVT.logMessage(p_module_name => l_module ,
4134: p_msg_text => 'WSM_JobCopies_PVT.Create_JobCopies returned success',
4135: p_stmt_num => l_stmt_num ,
4136: p_msg_tokens => l_msg_tokens,
4137: p_fnd_log_level => g_log_level_statement,
4138: p_run_log_level => l_log_level
4139: );
4140: End if;
4141:
4153: WSM_log_PVT.logMessage(p_module_name => l_module ,
4154: p_msg_text => 'Set internal_copy_type = 2 for we_id=',
4155: p_stmt_num => l_stmt_num ,
4156: p_msg_tokens => l_msg_tokens,
4157: p_fnd_log_level => g_log_level_statement,
4158: p_run_log_level => l_log_level
4159: );
4160: End if;
4161:
4205: p_msg_text => 'new we_id :'||p_wltx_resulting_jobs_tbl(l_job_counter).wip_entity_id||
4206: 'rep_job_we_id :'||l_rep_wip_entity_id,
4207: p_stmt_num => l_stmt_num ,
4208: p_msg_tokens => l_msg_tokens,
4209: p_fnd_log_level => g_log_level_statement,
4210: p_run_log_level => l_log_level
4211: );
4212: End if;
4213:
4238: p_msg_text => 'WSM_JobCopies_PVT.Create_RepJobCopies returned error:' || x_err_buf,
4239: p_stmt_num => l_stmt_num ,
4240: p_msg_tokens => l_msg_tokens,
4241: p_fnd_msg_level => G_MSG_LVL_ERROR ,
4242: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4243: p_run_log_level => l_log_level
4244: );
4245: END IF;
4246: RAISE FND_API.G_EXC_ERROR;
4253: WSM_log_PVT.logMessage(p_module_name => l_module ,
4254: p_msg_text => 'WSM_JobCopies_PVT.Create_RepJobCopies returned success',
4255: p_stmt_num => l_stmt_num ,
4256: p_msg_tokens => l_msg_tokens,
4257: p_fnd_log_level => g_log_level_statement,
4258: p_run_log_level => l_log_level
4259: );
4260: End if;
4261:
4272: WSM_log_PVT.logMessage(p_module_name => l_module ,
4273: p_msg_text => 'Set internal_copy_type = '||l_new_job_int_copy_type||' for we_id=',
4274: p_stmt_num => l_stmt_num ,
4275: p_msg_tokens => l_msg_tokens,
4276: p_fnd_log_level => g_log_level_statement,
4277: p_run_log_level => l_log_level
4278: );
4279: End if;
4280:
4291: WSM_log_PVT.logMessage(p_module_name => l_module ,
4292: p_msg_text => 'Set copy_parent_wip_entity_id = '||nvl(l_rep_job_par_we_id, l_rep_wip_entity_id)||' for we_id=',
4293: p_stmt_num => l_stmt_num ,
4294: p_msg_tokens => l_msg_tokens,
4295: p_fnd_log_level => g_log_level_statement,
4296: p_run_log_level => l_log_level
4297: );
4298: End if;
4299:
4383: p_msg_text => 'WSM_JobCopies_PVT.Create_JobCopies returned error:' || x_err_buf,
4384: p_stmt_num => l_stmt_num ,
4385: p_msg_tokens => l_msg_tokens,
4386: p_fnd_msg_level => G_MSG_LVL_ERROR ,
4387: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4388: p_run_log_level => l_log_level
4389: );
4390: END IF;
4391: RAISE FND_API.G_EXC_ERROR;
4396: WSM_log_PVT.logMessage(p_module_name => l_module ,
4397: p_msg_text => 'WSM_JobCopies_PVT.Create_JobCopies returned success',
4398: p_stmt_num => l_stmt_num ,
4399: p_msg_tokens => l_msg_tokens,
4400: p_fnd_log_level => g_log_level_statement,
4401: p_run_log_level => l_log_level
4402: );
4403: End if;
4404:
4415: WSM_log_PVT.logMessage(p_module_name => l_module ,
4416: p_msg_text => 'Set internal_copy_type = 2 for we_id=',
4417: p_stmt_num => l_stmt_num ,
4418: p_msg_tokens => l_msg_tokens,
4419: p_fnd_log_level => g_log_level_statement,
4420: p_run_log_level => l_log_level
4421: );
4422: End if;
4423:
4515: p_msg_text => 'WSM_JobCopies_PVT.Create_JobCopies returned error:' || x_err_buf,
4516: p_stmt_num => l_stmt_num ,
4517: p_msg_tokens => l_msg_tokens,
4518: p_fnd_msg_level => G_MSG_LVL_ERROR ,
4519: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4520: p_run_log_level => l_log_level
4521: );
4522: END IF;
4523: RAISE FND_API.G_EXC_ERROR;
4528: WSM_log_PVT.logMessage(p_module_name => l_module ,
4529: p_msg_text => 'WSM_JobCopies_PVT.Create_JobCopies returned success',
4530: p_stmt_num => l_stmt_num ,
4531: p_msg_tokens => l_msg_tokens,
4532: p_fnd_log_level => g_log_level_statement,
4533: p_run_log_level => l_log_level
4534: );
4535: End if;
4536:
4546: WSM_log_PVT.logMessage(p_module_name => l_module ,
4547: p_msg_text => 'Set internal_copy_type = 2 for we_id='||l_rep_wip_entity_id,
4548: p_stmt_num => l_stmt_num ,
4549: p_msg_tokens => l_msg_tokens,
4550: p_fnd_log_level => g_log_level_statement,
4551: p_run_log_level => l_log_level
4552: );
4553: End if;
4554:
4594: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
4595: THEN
4596: WSM_log_PVT.handle_others( p_module_name => l_module ,
4597: p_stmt_num => l_stmt_num ,
4598: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
4599: p_run_log_level => l_log_level
4600: );
4601: END IF;
4602:
4630: l_returnStatus VARCHAR2(1);
4631: x_msg_count number;
4632: -- Logging variables.....
4633: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
4634: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4635:
4636: l_stmt_num NUMBER;
4637: l_module VARCHAR2(100) := 'wsm.plsql.WSMPJUPDB.CALL_INF_SCH_OR_SET_SCH_DATA';
4638: -- Logging variables...
4671: p_msg_text => 'GET_JOB_CURR_OP_INFO returned error:' || x_err_buf,
4672: p_stmt_num => l_stmt_num ,
4673: p_msg_tokens => l_msg_tokens,
4674: p_fnd_msg_level => G_MSG_LVL_ERROR ,
4675: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4676: p_run_log_level => l_log_level
4677: );
4678: END IF;
4679: RAISE FND_API.G_EXC_ERROR;
4708: p_msg_text => 'WSM_infinite_scheduler_PVT.schedule returned error:' || x_err_buf,
4709: p_stmt_num => l_stmt_num ,
4710: p_msg_tokens => l_msg_tokens,
4711: p_fnd_msg_level => G_MSG_LVL_ERROR ,
4712: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4713: p_run_log_level => l_log_level
4714: );
4715: END IF;
4716: RAISE FND_API.G_EXC_ERROR;
4759: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
4760: THEN
4761: WSM_log_PVT.handle_others( p_module_name => l_module ,
4762: p_stmt_num => l_stmt_num ,
4763: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
4764: p_run_log_level => l_log_level
4765: );
4766: END IF;
4767:
4843:
4844: /*logging variables*/
4845: l_stmt_num number := 0;
4846: l_msg_tokens WSM_log_PVT.token_rec_tbl;
4847: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4848: l_module VARCHAR2(100) := 'wsm.plsql.WSMPJUPD.process_lots';
4849: l_schedule_group_id NUMBER; -- Bug 6676148
4850:
4851: l_attribute_category varchar2(30);
5031: WSM_log_PVT.logMessage(p_module_name => l_module ,
5032: p_msg_text => 'Calling WSMPLBJI.build_lbji_info procedure',
5033: p_stmt_num => l_stmt_num ,
5034: p_msg_tokens => l_msg_tokens,
5035: p_fnd_log_level => g_log_level_statement,
5036: p_run_log_level => l_log_level
5037: );
5038: End if;
5039:
5128: p_msg_text => 'Returned failure from WSMPLBJI.build_lbji_info procedure' ,
5129: p_stmt_num => l_stmt_num ,
5130: p_msg_tokens => l_msg_tokens,
5131: p_fnd_msg_level => G_MSG_LVL_ERROR ,
5132: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5133: p_run_log_level => l_log_level
5134: );
5135: END IF;
5136: RAISE FND_API.G_EXC_ERROR;
5141: WSM_log_PVT.logMessage(p_module_name => l_module ,
5142: p_msg_text => 'Returned successfully from WSMPLBJI.build_lbji_info procedure',
5143: p_stmt_num => l_stmt_num ,
5144: p_msg_tokens => l_msg_tokens,
5145: p_fnd_log_level => g_log_level_statement,
5146: p_run_log_level => l_log_level
5147: );
5148: End if;
5149: p_wltx_resulting_jobs_tbl(l_job_counter).wip_entity_id := l_new_we_id;
5165: WSM_log_PVT.logMessage(p_module_name => l_module ,
5166: p_msg_text => 'Calling WSM_lbj_interface_PVT.build_job_header_info',
5167: p_stmt_num => l_stmt_num ,
5168: p_msg_tokens => l_msg_tokens,
5169: p_fnd_log_level => g_log_level_statement,
5170: p_run_log_level => l_log_level
5171: );
5172: End if;
5173:
5259: p_msg_text => 'Returned failure from WSM_lbj_interface_PVT.build_job_header_info'||l_err_buf,
5260: p_stmt_num => l_stmt_num ,
5261: p_msg_tokens => l_msg_tokens,
5262: p_fnd_msg_level => G_MSG_LVL_ERROR ,
5263: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5264: p_run_log_level => l_log_level
5265: );
5266: END IF;
5267: RAISE FND_API.G_EXC_ERROR;
5273: WSM_log_PVT.logMessage(p_module_name => l_module ,
5274: p_msg_text => 'Returned success from WSM_lbj_interface_PVT.build_job_header_info',
5275: p_stmt_num => l_stmt_num ,
5276: p_msg_tokens => l_msg_tokens,
5277: p_fnd_log_level => g_log_level_statement,
5278: p_run_log_level => l_log_level
5279: );
5280: End if;
5281:
5318: WSM_log_PVT.logMessage(p_module_name => l_module ,
5319: p_msg_text => 'Calling INV_Kanban_PVT.Update_Card_Supply_Status',
5320: p_stmt_num => l_stmt_num ,
5321: p_msg_tokens => l_msg_tokens,
5322: p_fnd_log_level => g_log_level_statement,
5323: p_run_log_level => l_log_level
5324: );
5325: End if;
5326:
5343: p_msg_name => 'WSM_KNBN_CARD_STS_FAIL',
5344: p_msg_appl_name => 'WSM' ,
5345: p_msg_tokens => l_msg_tokens ,
5346: p_fnd_msg_level => G_MSG_LVL_ERROR ,
5347: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5348: p_run_log_level => l_log_level
5349: );
5350: END IF;
5351:
5386: WSM_log_PVT.logMessage(p_module_name => l_module ,
5387: p_msg_text => 'Calling COPY_REP_JOB_WO_FA ' || p_wltx_starting_jobs_tbl(l_rep_sj_index).operation_seq_num,
5388: p_stmt_num => l_stmt_num ,
5389: p_msg_tokens => l_msg_tokens,
5390: p_fnd_log_level => g_log_level_statement,
5391: p_run_log_level => l_log_level
5392: );
5393: End if;
5394: l_err_code := 0;
5415: p_msg_text => 'Returned failure from COPY_REP_JOB_WO_FA',
5416: p_stmt_num => l_stmt_num ,
5417: p_msg_tokens => l_msg_tokens,
5418: p_fnd_msg_level => G_MSG_LVL_ERROR ,
5419: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5420: p_run_log_level => l_log_level
5421: );
5422: END IF;
5423: RAISE FND_API.G_EXC_ERROR;
5430: WSM_log_PVT.logMessage(p_module_name => l_module ,
5431: p_msg_text => 'Calling COPY_REP_JOB_WOR ',
5432: p_stmt_num => l_stmt_num ,
5433: p_msg_tokens => l_msg_tokens,
5434: p_fnd_log_level => g_log_level_statement,
5435: p_run_log_level => l_log_level
5436: );
5437: End if;
5438: l_err_code := 0;
5454: p_msg_text => 'Returned failure from COPY_REP_JOB_WOR',
5455: p_stmt_num => l_stmt_num ,
5456: p_msg_tokens => l_msg_tokens,
5457: p_fnd_msg_level => G_MSG_LVL_ERROR ,
5458: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5459: p_run_log_level => l_log_level
5460: );
5461: END IF;
5462: RAISE FND_API.G_EXC_ERROR;
5479: WSM_log_PVT.logMessage(p_module_name => l_module ,
5480: p_msg_text => 'Calling COPY_REP_JOB_WSOR ',
5481: p_stmt_num => l_stmt_num ,
5482: p_msg_tokens => l_msg_tokens,
5483: p_fnd_log_level => g_log_level_statement,
5484: p_run_log_level => l_log_level
5485: );
5486: End if;
5487:
5501: p_msg_text => 'Returned failure from COPY_REP_JOB_WSOR',
5502: p_stmt_num => l_stmt_num ,
5503: p_msg_tokens => l_msg_tokens,
5504: p_fnd_msg_level => G_MSG_LVL_ERROR ,
5505: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5506: p_run_log_level => l_log_level
5507: );
5508: END IF;
5509: RAISE FND_API.G_EXC_ERROR;
5532: p_msg_text => 'Returned failure from COPY_REP_JOB_WORI',
5533: p_stmt_num => l_stmt_num,
5534: p_msg_tokens => l_msg_tokens,
5535: p_fnd_msg_level => G_MSG_LVL_ERROR,
5536: p_fnd_log_level => G_LOG_LEVEL_ERROR,
5537: p_run_log_level => l_log_level
5538: );
5539: END IF;
5540: RAISE FND_API.G_EXC_ERROR;
5547: WSM_log_PVT.logMessage(p_module_name => l_module,
5548: p_msg_text => 'Calling COPY_REP_JOB_WRO',
5549: p_stmt_num => l_stmt_num,
5550: p_msg_tokens => l_msg_tokens,
5551: p_fnd_log_level => g_log_level_statement,
5552: p_run_log_level => l_log_level
5553: );
5554: End if;
5555:
5575: p_msg_text => 'Returned failure from COPY_REP_JOB_WRO',
5576: p_stmt_num => l_stmt_num ,
5577: p_msg_tokens => l_msg_tokens,
5578: p_fnd_msg_level => G_MSG_LVL_ERROR ,
5579: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5580: p_run_log_level => l_log_level
5581: );
5582: END IF;
5583: RAISE FND_API.G_EXC_ERROR;
5590: WSM_log_PVT.logMessage(p_module_name => l_module ,
5591: p_msg_text => 'Calling COPY_REP_JOB_WOY ',
5592: p_stmt_num => l_stmt_num ,
5593: p_msg_tokens => l_msg_tokens,
5594: p_fnd_log_level => g_log_level_statement,
5595: p_run_log_level => l_log_level
5596: );
5597: End if;
5598: l_err_code := 0;
5614: p_msg_text => 'Returned failure from COPY_REP_JOB_WOY',
5615: p_stmt_num => l_stmt_num ,
5616: p_msg_tokens => l_msg_tokens,
5617: p_fnd_msg_level => G_MSG_LVL_ERROR ,
5618: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5619: p_run_log_level => l_log_level
5620: );
5621: END IF;
5622: RAISE FND_API.G_EXC_ERROR;
5628: WSM_log_PVT.logMessage(p_module_name => l_module ,
5629: p_msg_text => ' processing the starting jobs...',
5630: p_stmt_num => l_stmt_num ,
5631: p_msg_tokens => l_msg_tokens,
5632: p_fnd_log_level => g_log_level_statement,
5633: p_run_log_level => l_log_level
5634: );
5635: End if;
5636:
5653: || ' Starting Job index(l_job_counter) : ' || l_job_counter
5654: || ' Resulting Job index(l_sj_also_rj_index) : ' || l_sj_also_rj_index,
5655: p_stmt_num => l_stmt_num ,
5656: p_msg_tokens => l_msg_tokens,
5657: p_fnd_log_level => g_log_level_statement,
5658: p_run_log_level => l_log_level
5659: );
5660: End if;
5661: -- related bugs : 3181486
5693: WSM_log_PVT.logMessage(p_module_name => l_module ,
5694: p_msg_text => ' Calling INV_Kanban_PVT.Update_Card_Supply_Status...',
5695: p_stmt_num => l_stmt_num ,
5696: p_msg_tokens => l_msg_tokens,
5697: p_fnd_log_level => g_log_level_statement,
5698: p_run_log_level => l_log_level
5699: );
5700: End if;
5701:
5716: p_msg_name => 'WSM_KNBN_CARD_STS_FAIL',
5717: p_msg_appl_name => 'WSM' ,
5718: p_msg_tokens => l_msg_tokens ,
5719: p_fnd_msg_level => G_MSG_LVL_ERROR ,
5720: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5721: p_run_log_level => l_log_level
5722: );
5723: END IF;
5724: RAISE FND_API.G_EXC_ERROR;
5734: WSM_log_PVT.logMessage(p_module_name => l_module ,
5735: p_msg_text => ' Calling handle_kanban_sub_loc_change...',
5736: p_stmt_num => l_stmt_num ,
5737: p_msg_tokens => l_msg_tokens,
5738: p_fnd_log_level => g_log_level_statement,
5739: p_run_log_level => l_log_level
5740: );
5741: End if;
5742:
5761: p_msg_text => 'Returned failure from handle_kanban_sub_loc_change',
5762: p_stmt_num => l_stmt_num ,
5763: p_msg_tokens => l_msg_tokens,
5764: p_fnd_msg_level => G_MSG_LVL_ERROR ,
5765: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5766: p_run_log_level => l_log_level
5767: );
5768: END IF;
5769: RAISE FND_API.G_EXC_ERROR;
5782: WSM_log_PVT.logMessage(p_module_name => l_module ,
5783: p_msg_text => ' Calling INV_Kanban_PVT.Update_Card_Supply_Status...',
5784: p_stmt_num => l_stmt_num ,
5785: p_msg_tokens => l_msg_tokens,
5786: p_fnd_log_level => g_log_level_statement,
5787: p_run_log_level => l_log_level
5788: );
5789: End if;
5790:
5808: p_msg_name => 'WSM_KNBN_CARD_STS_FAIL',
5809: p_msg_appl_name => 'WSM' ,
5810: p_msg_tokens => l_msg_tokens ,
5811: p_fnd_msg_level => G_MSG_LVL_ERROR ,
5812: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5813: p_run_log_level => l_log_level
5814: );
5815: END IF;
5816: RAISE FND_API.G_EXC_ERROR;
5831: WSM_log_PVT.logMessage(p_module_name => l_module ,
5832: p_msg_text => 'Updating the completion subinv and the kanban card id ...',
5833: p_stmt_num => l_stmt_num ,
5834: p_msg_tokens => l_msg_tokens,
5835: p_fnd_log_level => g_log_level_statement,
5836: p_run_log_level => l_log_level
5837: );
5838: End if;
5839:
5856: WSM_log_PVT.logMessage(p_module_name => l_module ,
5857: p_msg_text => 'starting job has been completely merged/split or a non-representative job... ',
5858: p_stmt_num => l_stmt_num ,
5859: p_msg_tokens => l_msg_tokens,
5860: p_fnd_log_level => g_log_level_statement,
5861: p_run_log_level => l_log_level
5862: );
5863: End if;
5864:
5914: p_msg_name => 'WSM_KNBN_CARD_STS_FAIL',
5915: p_msg_appl_name => 'WSM' ,
5916: p_msg_tokens => l_msg_tokens ,
5917: p_fnd_msg_level => G_MSG_LVL_ERROR ,
5918: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5919: p_run_log_level => l_log_level
5920: );
5921: END IF;
5922: RAISE FND_API.G_EXC_ERROR;
5971: p_msg_text => l_err_buf , /* Bugfix 5738550 removed hardcoding */
5972: p_stmt_num => l_stmt_num ,
5973: p_msg_tokens => l_msg_tokens,
5974: p_fnd_msg_level => G_MSG_LVL_ERROR ,
5975: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5976: p_run_log_level => l_log_level
5977: );
5978: END IF;
5979: RAISE FND_API.G_EXC_ERROR;
5984: WSM_log_PVT.logMessage(p_module_name => l_module ,
5985: p_msg_text => 'WSMPOPRN.update_job_name success.Got new job name',
5986: p_stmt_num => l_stmt_num ,
5987: p_msg_tokens => l_msg_tokens,
5988: p_fnd_log_level => g_log_level_statement,
5989: p_run_log_level => l_log_level
5990: );
5991: End if;
5992: end if;
6005: WSM_log_PVT.logMessage(p_module_name => l_module ,
6006: p_msg_text => 'Calling CHANGE_QUANTITY',
6007: p_stmt_num => l_stmt_num ,
6008: p_msg_tokens => l_msg_tokens,
6009: p_fnd_log_level => g_log_level_statement,
6010: p_run_log_level => l_log_level
6011: );
6012: End if;
6013:
6039: p_msg_text => 'CHANGE_QUANTITY returned failure' ,
6040: p_stmt_num => l_stmt_num ,
6041: p_msg_tokens => l_msg_tokens,
6042: p_fnd_msg_level => G_MSG_LVL_ERROR ,
6043: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6044: p_run_log_level => l_log_level
6045: );
6046: END IF;
6047: RAISE FND_API.G_EXC_ERROR;
6053: WSM_log_PVT.logMessage(p_module_name => l_module ,
6054: p_msg_text => 'Calling UPDATE_QTY_ISSUED',
6055: p_stmt_num => l_stmt_num ,
6056: p_msg_tokens => l_msg_tokens,
6057: p_fnd_log_level => g_log_level_statement,
6058: p_run_log_level => l_log_level
6059: );
6060: End if;
6061:
6084: p_msg_text => 'UPDATE_QTY_ISSUED returned failure' ,
6085: p_stmt_num => l_stmt_num ,
6086: p_msg_tokens => l_msg_tokens,
6087: p_fnd_msg_level => G_MSG_LVL_ERROR ,
6088: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6089: p_run_log_level => l_log_level
6090: );
6091: END IF;
6092: RAISE FND_API.G_EXC_ERROR;
6108: WSM_log_PVT.logMessage(p_module_name => l_module ,
6109: p_msg_text => 'Calling UPDATE_ASSEMBLY_OR_ROUTING',
6110: p_stmt_num => l_stmt_num ,
6111: p_msg_tokens => l_msg_tokens,
6112: p_fnd_log_level => g_log_level_statement,
6113: p_run_log_level => l_log_level
6114: );
6115: End if;
6116:
6141: p_msg_text => 'UPDATE_ASSEMBLY_OR_ROUTING returned failure' ,
6142: p_stmt_num => l_stmt_num ,
6143: p_msg_tokens => l_msg_tokens,
6144: p_fnd_msg_level => G_MSG_LVL_ERROR ,
6145: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6146: p_run_log_level => l_log_level
6147: );
6148: END IF;
6149: RAISE FND_API.G_EXC_ERROR;
6215: p_msg_text => 'CREATE_COPIES_OR_SET_COPY_DATA returned '||l_err_code,
6216: p_stmt_num => l_stmt_num ,
6217: p_msg_tokens => l_msg_tokens,
6218: p_fnd_msg_level => G_MSG_LVL_ERROR ,
6219: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6220: p_run_log_level => l_log_level
6221: );
6222: END IF;
6223: RAISE FND_API.G_EXC_ERROR; --x_err_code has errcode, x_err_buf has the error message
6256: p_msg_text => ' CALL_INF_SCH_OR_SET_SCH_DATA returned '||l_err_code,
6257: p_stmt_num => l_stmt_num ,
6258: p_msg_tokens => l_msg_tokens,
6259: p_fnd_msg_level => G_MSG_LVL_ERROR ,
6260: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6261: p_run_log_level => l_log_level
6262: );
6263: END IF;
6264: RAISE FND_API.G_EXC_ERROR;
6349: WSM_log_PVT.logMessage(p_module_name => l_module ,
6350: p_msg_text => 'inv_genealogy_pub.insert_genealogy returned success',
6351: p_stmt_num => l_stmt_num ,
6352: p_msg_tokens => l_msg_tokens,
6353: p_fnd_log_level => g_log_level_statement,
6354: p_run_log_level => l_log_level
6355: );
6356: End if;
6357:
6364: p_msg_text => 'inv_genealogy_pub.insert_genealogy failed',
6365: p_stmt_num => l_stmt_num ,
6366: p_msg_tokens => l_msg_tokens,
6367: p_fnd_msg_level => G_MSG_LVL_ERROR ,
6368: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6369: p_run_log_level => l_log_level
6370: );
6371: END IF;
6372:
6455: WSM_log_PVT.logMessage(p_module_name => l_module ,
6456: p_msg_text => 'inv_genealogy_pub.insert_genealogy returned success',
6457: p_stmt_num => l_stmt_num ,
6458: p_msg_tokens => l_msg_tokens,
6459: p_fnd_log_level => g_log_level_statement,
6460: p_run_log_level => l_log_level
6461: );
6462: End if;
6463: ELSE
6468: p_msg_text => 'inv_genealogy_pub.insert_genealogy failed',
6469: p_stmt_num => l_stmt_num ,
6470: p_msg_tokens => l_msg_tokens,
6471: p_fnd_msg_level => G_MSG_LVL_ERROR ,
6472: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6473: p_run_log_level => l_log_level
6474: );
6475: END IF;
6476:
6524: p_msg_text => 'Insert_MMT_record failed',
6525: p_stmt_num => l_stmt_num ,
6526: p_msg_tokens => l_msg_tokens,
6527: p_fnd_msg_level => G_MSG_LVL_ERROR ,
6528: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6529: p_run_log_level => l_log_level
6530: );
6531: END IF;
6532: RAISE FND_API.G_EXC_ERROR;
6565: p_msg_text => 'UPDATE_ASSEMBLY_OR_ROUTING failed',
6566: p_stmt_num => l_stmt_num ,
6567: p_msg_tokens => l_msg_tokens,
6568: p_fnd_msg_level => G_MSG_LVL_ERROR ,
6569: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6570: p_run_log_level => l_log_level
6571: );
6572: END IF;
6573: RAISE FND_API.G_EXC_ERROR;
6596: p_msg_text => 'CREATE_COPIES_OR_SET_COPY_DATA failed',
6597: p_stmt_num => l_stmt_num ,
6598: p_msg_tokens => l_msg_tokens,
6599: p_fnd_msg_level => G_MSG_LVL_ERROR ,
6600: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6601: p_run_log_level => l_log_level
6602: );
6603: END IF;
6604: RAISE FND_API.G_EXC_ERROR;
6671: p_msg_text => 'CHANGE_QUANTITY failed',
6672: p_stmt_num => l_stmt_num ,
6673: p_msg_tokens => l_msg_tokens,
6674: p_fnd_msg_level => G_MSG_LVL_ERROR ,
6675: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6676: p_run_log_level => l_log_level
6677: );
6678: END IF;
6679: RAISE FND_API.G_EXC_ERROR;
6711: p_msg_text => 'UPDATE_QTY_ISSUED failed',
6712: p_stmt_num => l_stmt_num ,
6713: p_msg_tokens => l_msg_tokens,
6714: p_fnd_msg_level => G_MSG_LVL_ERROR ,
6715: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6716: p_run_log_level => l_log_level
6717: );
6718: END IF;
6719: RAISE FND_API.G_EXC_ERROR;
6749: p_msg_text => 'handle_kanban_sub_loc_change failed',
6750: p_stmt_num => l_stmt_num ,
6751: p_msg_tokens => l_msg_tokens,
6752: p_fnd_msg_level => G_MSG_LVL_ERROR ,
6753: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6754: p_run_log_level => l_log_level
6755: );
6756: END IF;
6757: RAISE FND_API.G_EXC_ERROR;
6790: p_msg_name => 'WSM_KNBN_CARD_STS_FAIL',
6791: p_msg_appl_name => 'WSM' ,
6792: p_msg_tokens => l_msg_tokens ,
6793: p_fnd_msg_level => G_MSG_LVL_ERROR ,
6794: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6795: p_run_log_level => l_log_level
6796: );
6797: END IF;
6798:
6884: p_msg_text => 'CALL_INF_SCH_OR_SET_SCH_DATA returned failure:'||l_err_code,
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;
6948: p_msg_text => 'Insert_MMT_record failed',
6949: p_stmt_num => l_stmt_num ,
6950: p_msg_tokens => l_msg_tokens,
6951: p_fnd_msg_level => G_MSG_LVL_ERROR ,
6952: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6953: p_run_log_level => l_log_level
6954: );
6955: END IF;
6956: RAISE FND_API.G_EXC_ERROR;
6971: WSM_log_PVT.logMessage(p_module_name => l_module ,
6972: p_msg_text => 'Transaction type is Update Lotname:',
6973: p_stmt_num => l_stmt_num ,
6974: p_msg_tokens => l_msg_tokens,
6975: p_fnd_log_level => g_log_level_statement,
6976: p_run_log_level => l_log_level
6977: );
6978: End if;
6979:
7024: p_msg_name => 'WSM_RESULT_LOT_REQUIRED',
7025: p_msg_appl_name => 'WSM',
7026: p_msg_tokens => l_msg_tokens ,
7027: p_fnd_msg_level => G_MSG_LVL_ERROR ,
7028: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
7029: p_run_log_level => l_log_level
7030: );
7031: END IF;
7032: RAISE FND_API.G_EXC_ERROR;
7044: WSM_log_PVT.logMessage(p_module_name => l_module ,
7045: p_msg_text => 'Calling WSMPLBJI.build_lbji_info procedure'||p_wltx_resulting_jobs_tbl(l_rj_index).class_code,
7046: p_stmt_num => l_stmt_num ,
7047: p_msg_tokens => l_msg_tokens,
7048: p_fnd_log_level => g_log_level_statement,
7049: p_run_log_level => l_log_level
7050: );
7051: End if;
7052:
7141: p_msg_text => 'Returned failure from WSMPLBJI.build_lbji_info procedure'||l_err_buf,
7142: p_stmt_num => l_stmt_num ,
7143: p_msg_tokens => l_msg_tokens,
7144: p_fnd_msg_level => G_MSG_LVL_ERROR ,
7145: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
7146: p_run_log_level => l_log_level
7147: );
7148: END IF;
7149: RAISE FND_API.G_EXC_ERROR;
7154: WSM_log_PVT.logMessage(p_module_name => l_module ,
7155: p_msg_text => 'Returned successfully from WSMPLBJI.build_lbji_info procedure',
7156: p_stmt_num => l_stmt_num ,
7157: p_msg_tokens => l_msg_tokens,
7158: p_fnd_log_level => g_log_level_statement,
7159: p_run_log_level => l_log_level
7160: );
7161: End if;
7162: p_wltx_resulting_jobs_tbl(l_rj_index).wip_entity_id := l_new_we_id;
7193: p_msg_text => 'Returned failure from CREATE_WSOR_WLBJ_RECORDS',
7194: p_stmt_num => l_stmt_num ,
7195: p_msg_tokens => l_msg_tokens,
7196: p_fnd_msg_level => G_MSG_LVL_ERROR ,
7197: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
7198: p_run_log_level => l_log_level
7199: );
7200: END IF;
7201: RAISE FND_API.G_EXC_ERROR;
7205: WSM_log_PVT.logMessage(p_module_name => l_module ,
7206: p_msg_text => 'Created WSOR records for new job with id='||l_new_we_id,
7207: p_stmt_num => l_stmt_num ,
7208: p_msg_tokens => l_msg_tokens,
7209: p_fnd_log_level => g_log_level_statement,
7210: p_run_log_level => l_log_level
7211: );
7212: End if;
7213: END IF;
7227: WSM_log_PVT.logMessage(p_module_name => l_module ,
7228: p_msg_text => 'Updated the job seq num in resulting job record : ' || l_bonus_job_st_op_seq,
7229: p_stmt_num => l_stmt_num ,
7230: p_msg_tokens => l_msg_tokens,
7231: p_fnd_log_level => g_log_level_statement,
7232: p_run_log_level => l_log_level
7233: );
7234: End if;
7235:
7244: WSM_log_PVT.logMessage(p_module_name => l_module ,
7245: p_msg_text => 'Updated the op seq num in wip_operations',
7246: p_stmt_num => l_stmt_num,
7247: p_msg_tokens => l_msg_tokens,
7248: p_fnd_log_level => g_log_level_statement,
7249: p_run_log_level => l_log_level
7250: );
7251: End if;
7252:
7299: WSM_log_PVT.logMessage(p_module_name => l_module ,
7300: p_msg_text => 'Checking for open a/c period',
7301: p_stmt_num => l_stmt_num,
7302: p_msg_tokens => l_msg_tokens,
7303: p_fnd_log_level => g_log_level_statement,
7304: p_run_log_level => l_log_level
7305: );
7306: End if;
7307:
7322: p_msg_text => 'Accounting Period not open',
7323: p_stmt_num => l_stmt_num ,
7324: p_msg_tokens => l_msg_tokens,
7325: p_fnd_msg_level => G_MSG_LVL_ERROR ,
7326: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
7327: p_run_log_level => l_log_level
7328: );
7329: END IF;
7330: RAISE FND_API.G_EXC_ERROR;
7340: WSM_log_PVT.logMessage(p_module_name => l_module ,
7341: p_msg_text => 'Inserting MMT record',
7342: p_stmt_num => l_stmt_num,
7343: p_msg_tokens => l_msg_tokens,
7344: p_fnd_log_level => g_log_level_statement,
7345: p_run_log_level => l_log_level
7346: );
7347: End if;
7348:
7372: p_msg_text => 'Insert_MMT_record failed:'||l_msg_data,
7373: p_stmt_num => l_stmt_num ,
7374: p_msg_tokens => l_msg_tokens,
7375: p_fnd_msg_level => G_MSG_LVL_ERROR ,
7376: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
7377: p_run_log_level => l_log_level
7378: );
7379: END IF;
7380: RAISE FND_API.G_EXC_ERROR;
7404: p_msg_text => 'CREATE_COPIES_OR_SET_COPY_DATA returned failure ' || l_err_buf,
7405: p_stmt_num => l_stmt_num ,
7406: p_msg_tokens => l_msg_tokens,
7407: p_fnd_msg_level => G_MSG_LVL_ERROR ,
7408: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
7409: p_run_log_level => l_log_level
7410: );
7411: END IF;
7412: RAISE FND_API.G_EXC_ERROR; --x_err_code has errcode, x_err_buf has the error message
7450: p_msg_text => 'Invalid Txn type',
7451: p_stmt_num => l_stmt_num ,
7452: p_msg_tokens => l_msg_tokens,
7453: p_fnd_msg_level => G_MSG_LVL_ERROR ,
7454: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
7455: p_run_log_level => l_log_level
7456: );
7457: END IF;
7458: raise FND_API.G_EXC_ERROR;
7497: p_msg_text => 'WSM_RESERVATIONS_PVT.Modify_reservations_jobupdate failed:'||l_msg_data,
7498: p_stmt_num => l_stmt_num ,
7499: p_msg_tokens => l_msg_tokens,
7500: p_fnd_msg_level => G_MSG_LVL_ERROR ,
7501: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
7502: p_run_log_level => l_log_level
7503: );
7504: END IF;
7505: RAISE FND_API.G_EXC_ERROR;
7528: p_msg_text => 'WSM_RESERVATIONS_PVT.modify_reservations_wlt failed:'||l_msg_data,
7529: p_stmt_num => l_stmt_num ,
7530: p_msg_tokens => l_msg_tokens,
7531: p_fnd_msg_level => G_MSG_LVL_ERROR ,
7532: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
7533: p_run_log_level => l_log_level
7534: );
7535: END IF;
7536: --To be reverted
7562: p_msg_text => 'WSM_RESERVATIONS_PVT.modify_reservations_wlt failed:'||l_msg_data,
7563: p_stmt_num => l_stmt_num ,
7564: p_msg_tokens => l_msg_tokens,
7565: p_fnd_msg_level => G_MSG_LVL_ERROR ,
7566: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
7567: p_run_log_level => l_log_level
7568: );
7569: END IF;
7570: --To be reverted
7599: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
7600: THEN
7601: WSM_log_PVT.handle_others( p_module_name => l_module ,
7602: p_stmt_num => l_stmt_num ,
7603: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
7604: p_run_log_level => l_log_level
7605: );
7606: END IF;
7607:
7617: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
7618: THEN
7619: WSM_log_PVT.handle_others( p_module_name => l_module ,
7620: p_stmt_num => l_stmt_num ,
7621: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
7622: p_run_log_level => l_log_level
7623: );
7624: END IF;
7625: