1: PACKAGE BODY WSMPLBMI AS
2: /* $Header: WSMLBMIB.pls 120.97.12010000.3 2009/12/23 12:02:50 sisankar ship $ */
3:
4: --mes
5: g_log_level_unexpected NUMBER := FND_LOG.LEVEL_UNEXPECTED ;
6: g_log_level_error number := FND_LOG.LEVEL_ERROR ;
7: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;
8: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
9: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;
2: /* $Header: WSMLBMIB.pls 120.97.12010000.3 2009/12/23 12:02:50 sisankar ship $ */
3:
4: --mes
5: g_log_level_unexpected NUMBER := FND_LOG.LEVEL_UNEXPECTED ;
6: g_log_level_error number := FND_LOG.LEVEL_ERROR ;
7: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;
8: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
9: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;
10: g_log_level_statement number := FND_LOG.LEVEL_STATEMENT ;
3:
4: --mes
5: g_log_level_unexpected NUMBER := FND_LOG.LEVEL_UNEXPECTED ;
6: g_log_level_error number := FND_LOG.LEVEL_ERROR ;
7: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;
8: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
9: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;
10: g_log_level_statement number := FND_LOG.LEVEL_STATEMENT ;
11:
4: --mes
5: g_log_level_unexpected NUMBER := FND_LOG.LEVEL_UNEXPECTED ;
6: g_log_level_error number := FND_LOG.LEVEL_ERROR ;
7: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;
8: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
9: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;
10: g_log_level_statement number := FND_LOG.LEVEL_STATEMENT ;
11:
12: g_msg_lvl_unexp_error NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ;
5: g_log_level_unexpected NUMBER := FND_LOG.LEVEL_UNEXPECTED ;
6: g_log_level_error number := FND_LOG.LEVEL_ERROR ;
7: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;
8: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
9: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;
10: g_log_level_statement number := FND_LOG.LEVEL_STATEMENT ;
11:
12: g_msg_lvl_unexp_error NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ;
13: g_msg_lvl_error NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR ;
6: g_log_level_error number := FND_LOG.LEVEL_ERROR ;
7: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;
8: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
9: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;
10: g_log_level_statement number := FND_LOG.LEVEL_STATEMENT ;
11:
12: g_msg_lvl_unexp_error NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ;
13: g_msg_lvl_error NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR ;
14: g_msg_lvl_success NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS ;
292: --mes
293: l_source_code WSM_LOT_MOVE_TXN_INTERFACE.source_code%type;
294: -- Logging variables.....
295: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
296: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
297: l_module CONSTANT VARCHAR2(100) := 'wsm.plsql.WSMPLBMI.custom_validations';
298: l_param_tbl WSM_Log_PVT.param_tbl_type;
299: l_return_status VARCHAR2(1);
300: l_msg_count number;
820: ';g_prev_upd_user_id '||
821: g_prev_upd_user_id,
822: p_stmt_num => l_stmt_num,
823: p_msg_tokens => l_msg_tokens,
824: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
825: p_run_log_level => l_log_level
826: );
827: END IF;
828:
867: ';g_prev_upd_user_name '||
868: g_prev_upd_user_name,
869: p_stmt_num => l_stmt_num,
870: p_msg_tokens => l_msg_tokens,
871: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
872: p_run_log_level => l_log_level
873: );
874: END IF;
875: IF (l_wlmti_last_upd_name IS NULL) THEN
1268: l_override_no_move_no_skip
1269: ,
1270: p_stmt_num => l_stmt_num,
1271: p_msg_tokens => l_msg_tokens,
1272: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
1273: p_run_log_level => l_log_level
1274: );
1275: WSM_log_PVT.logMessage (
1276: p_module_name => l_module,
1286: p_to_intraop_step_type /* to_intraoperation_step_type */
1287: ),
1288: p_stmt_num => l_stmt_num,
1289: p_msg_tokens => l_msg_tokens,
1290: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
1291: p_run_log_level => l_log_level
1292: );
1293:
1294: END IF;
4605: '; l_wmt_txn_qty '||l_wmt_txn_qty||
4606: '; l_wmt_scrap_acct_id '||l_wmt_scrap_acct_id,
4607: p_stmt_num => l_stmt_num,
4608: p_msg_tokens => l_msg_tokens,
4609: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
4610: p_run_log_level => l_log_level
4611: );
4612: END IF;
4613:
4715: ';l_converted_scrap_qty '||
4716: l_converted_scrap_qty,
4717: p_stmt_num => l_stmt_num,
4718: p_msg_tokens => l_msg_tokens,
4719: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
4720: p_run_log_level => l_log_level
4721: );
4722: END IF;
4723: l_stmt_num := 440;
4826: ';l_converted_scrap_qty '||
4827: l_converted_scrap_qty,
4828: p_stmt_num => l_stmt_num,
4829: p_msg_tokens => l_msg_tokens,
4830: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
4831: p_run_log_level => l_log_level
4832: );
4833: END IF;
4834: if (l_debug = 'Y') then
5148: ';l_converted_scrap_qty '||
5149: l_converted_scrap_qty,
5150: p_stmt_num => l_stmt_num,
5151: p_msg_tokens => l_msg_tokens,
5152: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
5153: p_run_log_level => l_log_level
5154: );
5155: END IF;
5156:
5613: l_stmt_num NUMBER;
5614: x_return_code NUMBER;
5615: -- Logging variables.....
5616: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
5617: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5618: l_module CONSTANT VARCHAR2(100) := 'wsm.plsql.WSMPLBMI.set_undo_txn_id';
5619: l_param_tbl WSM_Log_PVT.param_tbl_type;
5620: l_return_status VARCHAR2(1);
5621: l_msg_count number;
5633: ||';p_undo_txn_id '
5634: ||p_undo_txn_id,
5635: p_stmt_num => l_stmt_num,
5636: p_msg_tokens => l_msg_tokens,
5637: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
5638: p_run_log_level => l_log_level
5639: );
5640: END IF;
5641: x_return_code := 0;
5667: p_msg_text => 'x_undone_batch_id '
5668: ||x_undone_batch_id,
5669: p_stmt_num => l_stmt_num,
5670: p_msg_tokens => l_msg_tokens,
5671: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
5672: p_run_log_level => l_log_level
5673: );
5674: END IF;
5675: -- update transaction idi, so that
6140: AND status = g_running -- WIP_CONSTANTS.RUNNING --Added condition to fix bug #1815584
6141: ORDER BY transaction_date, organization_id, wip_entity_id, processing_order;
6142:
6143: --move enh To be used when we switch to the new logging scheme
6144: /* l_current_runtime_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6145: l_module := 'WSM.Plsql.WSMPLMTI.MoveTransactions';
6146: l_level_unexpected := FND_LOG.LEVEL_UNEXPECTED;
6147: l_level_error := FND_LOG.LEVEL_ERROR;
6148: l_level_exception := FND_LOG.LEVEL_EXCEPTION;
6142:
6143: --move enh To be used when we switch to the new logging scheme
6144: /* l_current_runtime_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6145: l_module := 'WSM.Plsql.WSMPLMTI.MoveTransactions';
6146: l_level_unexpected := FND_LOG.LEVEL_UNEXPECTED;
6147: l_level_error := FND_LOG.LEVEL_ERROR;
6148: l_level_exception := FND_LOG.LEVEL_EXCEPTION;
6149: l_level_event := FND_LOG.LEVEL_EVENT;
6150: l_level_procedure := FND_LOG.LEVEL_PROCEDURE;
6143: --move enh To be used when we switch to the new logging scheme
6144: /* l_current_runtime_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6145: l_module := 'WSM.Plsql.WSMPLMTI.MoveTransactions';
6146: l_level_unexpected := FND_LOG.LEVEL_UNEXPECTED;
6147: l_level_error := FND_LOG.LEVEL_ERROR;
6148: l_level_exception := FND_LOG.LEVEL_EXCEPTION;
6149: l_level_event := FND_LOG.LEVEL_EVENT;
6150: l_level_procedure := FND_LOG.LEVEL_PROCEDURE;
6151: l_level_statement := FND_LOG.LEVEL_STATEMENT; */
6144: /* l_current_runtime_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6145: l_module := 'WSM.Plsql.WSMPLMTI.MoveTransactions';
6146: l_level_unexpected := FND_LOG.LEVEL_UNEXPECTED;
6147: l_level_error := FND_LOG.LEVEL_ERROR;
6148: l_level_exception := FND_LOG.LEVEL_EXCEPTION;
6149: l_level_event := FND_LOG.LEVEL_EVENT;
6150: l_level_procedure := FND_LOG.LEVEL_PROCEDURE;
6151: l_level_statement := FND_LOG.LEVEL_STATEMENT; */
6152: x_error_msg VARCHAR2(4000);
6145: l_module := 'WSM.Plsql.WSMPLMTI.MoveTransactions';
6146: l_level_unexpected := FND_LOG.LEVEL_UNEXPECTED;
6147: l_level_error := FND_LOG.LEVEL_ERROR;
6148: l_level_exception := FND_LOG.LEVEL_EXCEPTION;
6149: l_level_event := FND_LOG.LEVEL_EVENT;
6150: l_level_procedure := FND_LOG.LEVEL_PROCEDURE;
6151: l_level_statement := FND_LOG.LEVEL_STATEMENT; */
6152: x_error_msg VARCHAR2(4000);
6153: x_err_code NUMBER;
6146: l_level_unexpected := FND_LOG.LEVEL_UNEXPECTED;
6147: l_level_error := FND_LOG.LEVEL_ERROR;
6148: l_level_exception := FND_LOG.LEVEL_EXCEPTION;
6149: l_level_event := FND_LOG.LEVEL_EVENT;
6150: l_level_procedure := FND_LOG.LEVEL_PROCEDURE;
6151: l_level_statement := FND_LOG.LEVEL_STATEMENT; */
6152: x_error_msg VARCHAR2(4000);
6153: x_err_code NUMBER;
6154: x_error_code NUMBER;
6147: l_level_error := FND_LOG.LEVEL_ERROR;
6148: l_level_exception := FND_LOG.LEVEL_EXCEPTION;
6149: l_level_event := FND_LOG.LEVEL_EVENT;
6150: l_level_procedure := FND_LOG.LEVEL_PROCEDURE;
6151: l_level_statement := FND_LOG.LEVEL_STATEMENT; */
6152: x_error_msg VARCHAR2(4000);
6153: x_err_code NUMBER;
6154: x_error_code NUMBER;
6155: e_proc_exception EXCEPTION;
6204:
6205: l_temp_txn_type NUMBER; --bug 4380374
6206: -- Logging variables.....
6207: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
6208: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6209: l_module CONSTANT VARCHAR2(100) := 'wsm.plsql.wsmplbmi.movetransaction.main';
6210: l_param_tbl WSM_Log_PVT.param_tbl_type;
6211: -- Logging variables...
6212:
6217: p_module_name => l_module ,
6218: p_msg_text => 'Begin MoveTransactions Main',
6219: p_stmt_num => l_stmt_num ,
6220: p_msg_tokens => l_msg_tokens ,
6221: p_fnd_log_level => G_LOG_LEVEL_PROCEDURE ,
6222: p_run_log_level => l_log_level
6223: );
6224: END IF;
6225:
6222: p_run_log_level => l_log_level
6223: );
6224: END IF;
6225:
6226: IF FND_LOG.LEVEL_PROCEDURE >= l_log_level THEN
6227:
6228: l_param_tbl.delete;
6229: l_param_tbl(1).paramName := 'p_group_id';
6230: l_param_tbl(1).paramValue := p_group_id;
6248: l_param_tbl(11).paramValue := p_mtl_txn_hdr_id;
6249:
6250: WSM_Log_PVT.logProcParams(p_module_name => l_module ,
6251: p_param_tbl => l_param_tbl,
6252: p_fnd_log_level => G_LOG_LEVEL_PROCEDURE
6253: );
6254: END IF;
6255:
6256:
6296: ';g_login_id '||
6297: g_login_id,
6298: p_stmt_num => l_stmt_num,
6299: p_msg_tokens => l_msg_tokens,
6300: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
6301: p_run_log_level => l_log_level
6302: );
6303: END IF;
6304: UPDATE wsm_lot_move_txn_interface wlmti
6541: p_module_name => l_module ,
6542: p_msg_text => 'error_handler returned error '||l_error_msg,
6543: p_stmt_num => l_stmt_num ,
6544: p_msg_tokens => l_msg_tokens ,
6545: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
6546: p_run_log_level => l_log_level
6547: );
6548: END IF;
6549: raise e_proc_exception;
6558: p_module_name => l_module ,
6559: p_msg_text => 'custom_validation returned error '||l_error_msg,
6560: p_stmt_num => l_stmt_num ,
6561: p_msg_tokens => l_msg_tokens ,
6562: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
6563: p_run_log_level => l_log_level
6564: );
6565: END IF;
6566: GOTO inner_loop; /* go to get next entry */
6574: p_module_name => l_module ,
6575: p_msg_text => 'custom_validation returned success',
6576: p_stmt_num => l_stmt_num ,
6577: p_msg_tokens => l_msg_tokens ,
6578: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
6579: p_run_log_level => l_log_level
6580: );
6581: END IF;
6582: END IF;
6749: ';l_job_to_op_seq_num '||
6750: l_job_to_op_seq_num,
6751: p_stmt_num => l_stmt_num ,
6752: p_msg_tokens => l_msg_tokens ,
6753: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
6754: p_run_log_level => l_log_level
6755: );
6756: END IF;
6757:
6763: p_module_name => l_module ,
6764: p_msg_text => 'Begin MES Validations',
6765: p_stmt_num => l_stmt_num ,
6766: p_msg_tokens => l_msg_tokens ,
6767: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
6768: p_run_log_level => l_log_level
6769: );
6770: END IF;
6771:
6791: p_msg_text => NULL,
6792: p_stmt_num => l_stmt_num,
6793: p_msg_tokens => l_msg_tokens,
6794: p_wsm_warning => 1,
6795: p_fnd_log_level => G_LOG_LEVEL_ERROR,
6796: p_run_log_level => l_log_level
6797: );
6798:
6799: FND_MESSAGE.SET_NAME('WSM','WSM_MES_SCRAP_YIELD_LIMIT');
6811: p_module_name => l_module ,
6812: p_msg_text => 'Begin Scrap code Validations',
6813: p_stmt_num => l_stmt_num ,
6814: p_msg_tokens => l_msg_tokens ,
6815: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
6816: p_run_log_level => l_log_level
6817: );
6818: END IF;
6819:
6836: '; Scrap code qty'||
6837: p_scrap_code_qty_tbls(l_header_id)(i),
6838: p_stmt_num => l_stmt_num ,
6839: p_msg_tokens => l_msg_tokens ,
6840: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
6841: p_run_log_level => l_log_level
6842: );
6843: END IF;
6844: l_stmt_num := 110.5;
6856: p_msg_text => NULL,
6857: p_stmt_num => l_stmt_num,
6858: p_msg_tokens => l_msg_tokens,
6859: p_wsm_warning => NULL,
6860: p_fnd_log_level => G_LOG_LEVEL_ERROR,
6861: p_run_log_level => l_log_level
6862: );
6863: FND_MESSAGE.SET_NAME('WSM','WSM_MES_FIELD_NEGATIVE');
6864: FND_MESSAGE.SET_TOKEN('FIELD_NAME', l_msg_tokens(0).TokenValue);
6897: p_msg_text => NULL,
6898: p_stmt_num => l_stmt_num,
6899: p_msg_tokens => l_msg_tokens,
6900: p_wsm_warning => 1,
6901: p_fnd_log_level => G_LOG_LEVEL_ERROR,
6902: p_run_log_level => l_log_level
6903: );
6904:
6905: FND_MESSAGE.SET_NAME('WSM','WSM_MES_SCRAP_CODE_MAX_QTY');
6922: p_msg_text => NULL,
6923: p_stmt_num => l_stmt_num,
6924: p_msg_tokens => l_msg_tokens,
6925: p_wsm_warning => NULL,
6926: p_fnd_log_level => G_LOG_LEVEL_ERROR,
6927: p_run_log_level => l_log_level
6928: );
6929: FND_MESSAGE.SET_NAME('WSM','WSM_MES_SCRAPCODEQTY_MISMATCH');
6930: FND_MSG_PUB.add;
6938: p_module_name => l_module ,
6939: p_msg_text => 'Validated scrap codes successfully',
6940: p_stmt_num => l_stmt_num ,
6941: p_msg_tokens => l_msg_tokens ,
6942: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
6943: p_run_log_level => l_log_level
6944: );
6945: END IF;
6946: END IF;
6956: p_module_name => l_module ,
6957: p_msg_text => 'Begin Bonus code Validations',
6958: p_stmt_num => l_stmt_num ,
6959: p_msg_tokens => l_msg_tokens ,
6960: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
6961: p_run_log_level => l_log_level
6962: );
6963: END IF;
6964:
6980: p_msg_text => NULL,
6981: p_stmt_num => l_stmt_num,
6982: p_msg_tokens => l_msg_tokens,
6983: p_wsm_warning => NULL,
6984: p_fnd_log_level => G_LOG_LEVEL_ERROR,
6985: p_run_log_level => l_log_level
6986: );
6987: FND_MESSAGE.SET_NAME('WSM','WSM_MES_FIELD_NEGATIVE');
6988: FND_MESSAGE.SET_TOKEN('FIELD_NAME', l_msg_tokens(0).TokenValue);
7009: p_msg_text => NULL,
7010: p_stmt_num => l_stmt_num,
7011: p_msg_tokens => l_msg_tokens,
7012: p_wsm_warning => NULL,
7013: p_fnd_log_level => G_LOG_LEVEL_ERROR,
7014: p_run_log_level => l_log_level
7015: );
7016: FND_MESSAGE.SET_NAME('WSM','WSM_MES_BONUSCODEQTY_MISMATCH');
7017: FND_MSG_PUB.add;
7025: p_module_name => l_module ,
7026: p_msg_text => 'Validated bonus codes successfully',
7027: p_stmt_num => l_stmt_num ,
7028: p_msg_tokens => l_msg_tokens ,
7029: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
7030: p_run_log_level => l_log_level
7031: );
7032: END IF;
7033: END IF;
7046: p_module_name => l_module ,
7047: p_msg_text => 'Begin Scrap Serials Validations',
7048: p_stmt_num => l_stmt_num ,
7049: p_msg_tokens => l_msg_tokens ,
7050: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
7051: p_run_log_level => l_log_level
7052: );
7053: FOR i in p_jobop_scrap_serials_tbls(l_header_id).first..p_jobop_scrap_serials_tbls(l_header_id).last LOOP
7054: l_msg_tokens.delete;
7060: ||';serial '
7061: ||p_jobop_scrap_serials_tbls(l_header_id)(i).Serial_Number,
7062: p_stmt_num => l_stmt_num ,
7063: p_msg_tokens => l_msg_tokens ,
7064: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
7065: p_run_log_level => l_log_level
7066: );
7067: END LOOP;
7068: END IF;
7076: p_msg_text => NULL,
7077: p_stmt_num => l_stmt_num,
7078: p_msg_tokens => l_msg_tokens,
7079: p_wsm_warning => NULL,
7080: p_fnd_log_level => G_LOG_LEVEL_ERROR,
7081: p_run_log_level => l_log_level
7082: );
7083: FND_MESSAGE.SET_NAME('WSM','WSM_MES_SCRAPSERIAL_QTY');
7084: FND_MSG_PUB.add;
7092: p_module_name => l_module,
7093: p_msg_text => 'Validated scrap serials successfully',
7094: p_stmt_num => l_stmt_num,
7095: p_msg_tokens => l_msg_tokens,
7096: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
7097: p_run_log_level => l_log_level
7098: );
7099: END IF;
7100: END IF;
7112: p_module_name => l_module ,
7113: p_msg_text => 'Begin Bonus Serials Validations',
7114: p_stmt_num => l_stmt_num ,
7115: p_msg_tokens => l_msg_tokens ,
7116: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
7117: p_run_log_level => l_log_level
7118: );
7119: FOR i in p_jobop_bonus_serials_tbls(l_header_id).first..p_jobop_bonus_serials_tbls(l_header_id).last LOOP
7120: l_msg_tokens.delete;
7126: ||';serial '
7127: ||p_jobop_bonus_serials_tbls(l_header_id)(i).Serial_Number,
7128: p_stmt_num => l_stmt_num ,
7129: p_msg_tokens => l_msg_tokens ,
7130: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
7131: p_run_log_level => l_log_level
7132: );
7133: END LOOP;
7134: END IF;
7141: p_msg_text => NULL,
7142: p_stmt_num => l_stmt_num,
7143: p_msg_tokens => l_msg_tokens,
7144: p_wsm_warning => NULL,
7145: p_fnd_log_level => G_LOG_LEVEL_ERROR,
7146: p_run_log_level => l_log_level
7147: );
7148: FND_MESSAGE.SET_NAME('WSM','WSM_MES_BONUSSERIAL_QTY');
7149: FND_MSG_PUB.add;
7156: p_module_name => l_module,
7157: p_msg_text => 'Validated bonus serials successfully',
7158: p_stmt_num => l_stmt_num,
7159: p_msg_tokens => l_msg_tokens,
7160: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
7161: p_run_log_level => l_log_level
7162: );
7163: END IF;
7164: END IF;
7175: p_module_name => l_module ,
7176: p_msg_text => 'Begin Resource Validations',
7177: p_stmt_num => l_stmt_num ,
7178: p_msg_tokens => l_msg_tokens ,
7179: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
7180: p_run_log_level => l_log_level
7181: );
7182: END IF;
7183: FOR i in 1..p_jobop_resource_usages_tbls(l_header_id).last LOOP
7201: ';l_organization_id '||
7202: l_organization_id,
7203: p_stmt_num => l_stmt_num,
7204: p_msg_tokens => l_msg_tokens,
7205: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
7206: p_run_log_level => l_log_level
7207: );
7208: END IF;
7209: l_stmt_num := 110.19;
7219: p_msg_text => NULL,
7220: p_stmt_num => l_stmt_num,
7221: p_msg_tokens => l_msg_tokens,
7222: p_wsm_warning => NULL,
7223: p_fnd_log_level => G_LOG_LEVEL_ERROR,
7224: p_run_log_level => l_log_level
7225: );
7226: add_Resource_error_info(
7227: p_resource_id => p_jobop_resource_usages_tbls(l_header_id)(i).resource_id
7252: p_msg_text => NULL,
7253: p_stmt_num => l_stmt_num,
7254: p_msg_tokens => l_msg_tokens,
7255: p_wsm_warning => NULL,
7256: p_fnd_log_level => G_LOG_LEVEL_ERROR,
7257: p_run_log_level => l_log_level
7258: );
7259: add_Resource_error_info(
7260: p_resource_id => p_jobop_resource_usages_tbls(l_header_id)(i).resource_id
7309: ';serial_number '||
7310: p_jobop_resource_usages_tbls(l_header_id)(j).serial_number,
7311: p_stmt_num => l_stmt_num,
7312: p_msg_tokens => l_msg_tokens,
7313: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
7314: p_run_log_level => l_log_level
7315: );
7316: END IF;
7317: IF (i <> j)
7344: p_msg_text => NULL,
7345: p_stmt_num => l_stmt_num,
7346: p_msg_tokens => l_msg_tokens,
7347: p_wsm_warning => NULL,
7348: p_fnd_log_level => G_LOG_LEVEL_ERROR,
7349: p_run_log_level => l_log_level
7350: );
7351: add_Resource_error_info(
7352: p_resource_id => p_jobop_resource_usages_tbls(l_header_id)(i).resource_id
7377: p_msg_text => NULL,
7378: p_stmt_num => l_stmt_num,
7379: p_msg_tokens => l_msg_tokens,
7380: p_wsm_warning => NULL,
7381: p_fnd_log_level => G_LOG_LEVEL_ERROR,
7382: p_run_log_level => l_log_level
7383: );
7384: add_Resource_error_info(
7385: p_resource_id => p_jobop_resource_usages_tbls(l_header_id)(i).resource_id
7408: p_msg_text => NULL,
7409: p_stmt_num => l_stmt_num,
7410: p_msg_tokens => l_msg_tokens,
7411: p_wsm_warning => NULL,
7412: p_fnd_log_level => G_LOG_LEVEL_ERROR,
7413: p_run_log_level => l_log_level
7414: );
7415: add_Resource_error_info(
7416: p_resource_id => p_jobop_resource_usages_tbls(l_header_id)(i).resource_id
7431: p_module_name => l_module,
7432: p_msg_text => 'Validated resource usage successfully',
7433: p_stmt_num => l_stmt_num,
7434: p_msg_tokens => l_msg_tokens,
7435: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
7436: p_run_log_level => l_log_level
7437: );
7438: END IF;
7439: END IF;
7452: p_msg_text => NULL,
7453: p_stmt_num => l_stmt_num,
7454: p_msg_tokens => l_msg_tokens,
7455: p_wsm_warning => NULL,
7456: p_fnd_log_level => G_LOG_LEVEL_ERROR,
7457: p_run_log_level => l_log_level
7458: );
7459: FND_MESSAGE.SET_NAME('WSM','WSM_MES_COMPL
7469: p_module_name => l_module ,
7470: p_msg_text => 'End MES Move Out Validations',
7471: p_stmt_num => l_stmt_num ,
7472: p_msg_tokens => l_msg_tokens ,
7473: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
7474: p_run_log_level => l_log_level
7475: );
7476: END IF;
7477: ELSIF (nvl(p_source_code, 'interface') = 'move in oa page') THEN
7483: 'p_jobop_resource_usages_tbls(l_header_id).count '||
7484: p_jobop_resource_usages_tbls(l_header_id).count,
7485: p_stmt_num => l_stmt_num ,
7486: p_msg_tokens => l_msg_tokens ,
7487: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
7488: p_run_log_level => l_log_level
7489: );
7490: END IF;
7491:
7517: ';projected_completion_date '||
7518: p_jobop_resource_usages_tbls(l_header_id)(i).projected_completion_date,
7519: p_stmt_num => l_stmt_num ,
7520: p_msg_tokens => l_msg_tokens ,
7521: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
7522: p_run_log_level => l_log_level
7523: );
7524: END IF;
7525: IF nvl(p_jobop_resource_usages_tbls(l_header_id)(i).start_date, sysdate) > sysdate THEN
7529: p_module_name => l_module ,
7530: p_msg_text => 'inside IF nvl(p_jobop_resource_usages_tbls(l_header_id)(i).start_date, sysdate) > sysdate ',
7531: p_stmt_num => l_stmt_num ,
7532: p_msg_tokens => l_msg_tokens ,
7533: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
7534: p_run_log_level => l_log_level
7535: );
7536: END IF;
7537: l_stmt_num := 110.191;
7543: p_msg_text => NULL,
7544: p_stmt_num => l_stmt_num,
7545: p_msg_tokens => l_msg_tokens,
7546: p_wsm_warning => NULL,
7547: p_fnd_log_level => G_LOG_LEVEL_ERROR,
7548: p_run_log_level => l_log_level
7549: );
7550:
7551: add_Resource_error_info(
7571: p_msg_text => NULL,
7572: p_stmt_num => l_stmt_num,
7573: p_msg_tokens => l_msg_tokens,
7574: p_wsm_warning => NULL,
7575: p_fnd_log_level => G_LOG_LEVEL_ERROR,
7576: p_run_log_level => l_log_level
7577: );
7578: add_Resource_error_info(
7579: p_resource_id => p_jobop_resource_usages_tbls(l_header_id)(i).resource_id
7597: p_msg_text => NULL,
7598: p_stmt_num => l_stmt_num,
7599: p_msg_tokens => l_msg_tokens,
7600: p_wsm_warning => NULL,
7601: p_fnd_log_level => G_LOG_LEVEL_ERROR,
7602: p_run_log_level => l_log_level
7603: );
7604: add_Resource_error_info(
7605: p_resource_id => p_jobop_resource_usages_tbls(l_header_id)(i).resource_id
7625: p_msg_text => NULL,
7626: p_stmt_num => l_stmt_num,
7627: p_msg_tokens => l_msg_tokens,
7628: p_wsm_warning => NULL,
7629: p_fnd_log_level => G_LOG_LEVEL_ERROR,
7630: p_run_log_level => l_log_level
7631: );
7632: add_Resource_error_info(
7633: p_resource_id => p_jobop_resource_usages_tbls(l_header_id)(i).resource_id
7656: p_msg_text => NULL,
7657: p_stmt_num => l_stmt_num,
7658: p_msg_tokens => l_msg_tokens,
7659: p_wsm_warning => NULL,
7660: p_fnd_log_level => G_LOG_LEVEL_ERROR,
7661: p_run_log_level => l_log_level
7662: );
7663:
7664: FND_MESSAGE.SET_NAME('WSM','WSM_MES_PROJCOMPL
7676: p_module_name => l_module ,
7677: p_msg_text => 'End MES Move In Validations',
7678: p_stmt_num => l_stmt_num ,
7679: p_msg_tokens => l_msg_tokens ,
7680: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
7681: p_run_log_level => l_log_level
7682: );
7683: END IF;
7684: END IF;
7855: ';l_transaction_type '||
7856: l_transaction_type,
7857: p_stmt_num => l_stmt_num,
7858: p_msg_tokens => l_msg_tokens,
7859: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
7860: p_run_log_level => l_log_level
7861: );
7862: END IF;
7863:
7869: ';l_transaction_type '||
7870: l_transaction_type,
7871: p_stmt_num => l_stmt_num,
7872: p_msg_tokens => l_msg_tokens,
7873: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
7874: p_run_log_level => l_log_level
7875: );
7876: END IF;
7877:
7884: ' l_available_qty '||l_available_qty||
7885: ' l_primary_quantity '||l_primary_quantity,
7886: p_stmt_num => l_stmt_num,
7887: p_msg_tokens => l_msg_tokens,
7888: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
7889: p_run_log_level => l_log_level
7890: );
7891: END IF;
7892:
7927: ' l_transaction_type '||l_transaction_type||
7928: ' l_dup_name '||l_dup_name,
7929: p_stmt_num => l_stmt_num,
7930: p_msg_tokens => l_msg_tokens,
7931: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
7932: p_run_log_level => l_log_level
7933: );
7934: END IF;
7935:
7957: ' x_error_msg '||x_error_msg||
7958: ' l_new_name '||l_new_name,
7959: p_stmt_num => l_stmt_num,
7960: p_msg_tokens => l_msg_tokens,
7961: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
7962: p_run_log_level => l_log_level
7963: );
7964: END IF;
7965:
8000: ' l_available_qty '||l_available_qty||
8001: ' l_primary_quantity '||l_primary_quantity,
8002: p_stmt_num => l_stmt_num,
8003: p_msg_tokens => l_msg_tokens,
8004: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
8005: p_run_log_level => l_log_level
8006: );
8007: END IF;
8008: --bug 4380374
8063: ' l_to_intraoperation_step_type '||l_to_intraoperation_step_type||
8064: ' l_primary_quantity '||l_primary_quantity,
8065: p_stmt_num => l_stmt_num,
8066: p_msg_tokens => l_msg_tokens,
8067: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
8068: p_run_log_level => l_log_level
8069: );
8070: END IF;
8071:
8099: ' x_error_msg '||x_error_msg||
8100: ' l_new_name '||l_new_name,
8101: p_stmt_num => l_stmt_num,
8102: p_msg_tokens => l_msg_tokens,
8103: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
8104: p_run_log_level => l_log_level
8105: );
8106: END IF;
8107:
8242: p_module_name => l_module ,
8243: p_msg_text => 'Inserting WMTI row for scrap qty',
8244: p_stmt_num => l_stmt_num ,
8245: p_msg_tokens => l_msg_tokens ,
8246: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
8247: p_run_log_level => l_log_level
8248: );
8249: END IF;
8250:
8473: p_module_name => l_module ,
8474: p_msg_text => 'B4 IF (l_transaction_quantity>0) l_transaction_quantity '||l_transaction_quantity,
8475: p_stmt_num => l_stmt_num ,
8476: p_msg_tokens => l_msg_tokens ,
8477: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
8478: p_run_log_level => l_log_level
8479: );
8480: END IF;
8481:
8486: p_module_name => l_module ,
8487: p_msg_text => 'Inserting WMTI row for move qty',
8488: p_stmt_num => l_stmt_num ,
8489: p_msg_tokens => l_msg_tokens ,
8490: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
8491: p_run_log_level => l_log_level
8492: );
8493: END IF;
8494:
8905: ';l_fm_intraoperation_step_type '||
8906: l_fm_intraoperation_step_type,
8907: p_stmt_num => l_stmt_num ,
8908: p_msg_tokens => l_msg_tokens ,
8909: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
8910: p_run_log_level => l_log_level
8911: );
8912: END IF;
8913:
8936: WSM_log_PVT.logMessage ( p_module_name => l_module ,
8937: p_msg_text => 'B4 calling WSM_Serial_support_PVT.Insert_MOVE_attr',
8938: p_stmt_num => l_stmt_num ,
8939: p_msg_tokens => l_msg_tokens ,
8940: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
8941: p_run_log_level => l_log_level
8942: );
8943: END IF;
8944:
8961: WSM_log_PVT.logMessage (p_module_name => l_module ,
8962: p_msg_text => 'WSM_Serial_support_PVT.Insert_MOVE_attr returned successfully',
8963: p_stmt_num => l_stmt_num ,
8964: p_msg_tokens => l_msg_tokens ,
8965: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
8966: p_run_log_level => l_log_level
8967: );
8968: END IF;
8969: ELSE
8972: WSM_log_PVT.logMessage ( p_module_name => l_module ,
8973: p_msg_text => 'WSM_Serial_support_PVT.Insert_MOVE_attr returned error',
8974: p_stmt_num => l_stmt_num ,
8975: p_msg_tokens => l_msg_tokens ,
8976: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
8977: p_run_log_level => l_log_level
8978: );
8979: END IF;
8980: IF (l_error_count = 1) THEN
9008: p_module_name => l_module ,
9009: p_msg_text => 'Calling wip move api for scrap qty',
9010: p_stmt_num => l_stmt_num ,
9011: p_msg_tokens => l_msg_tokens ,
9012: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
9013: p_run_log_level => l_log_level
9014: );
9015: END IF;
9016:
9048: p_module_name => l_module,
9049: p_msg_text => 'wip_movProc_grp.processInterface for scrap txn returned error: '||l_error_msg,
9050: p_stmt_num => l_stmt_num,
9051: p_msg_tokens => l_msg_tokens,
9052: p_fnd_log_level => G_LOG_LEVEL_ERROR,
9053: p_run_log_level => l_log_level
9054: );
9055: END IF;
9056: raise e_proc_exception;
9062: p_module_name => l_module,
9063: p_msg_text => 'wip_movProc_grp.processInterface for scrap txn returned success: ',
9064: p_stmt_num => l_stmt_num,
9065: p_msg_tokens => l_msg_tokens,
9066: p_fnd_log_level => G_LOG_LEVEL_ERROR,
9067: p_run_log_level => l_log_level
9068: );
9069: END IF;
9070: END IF;
9085: p_module_name => l_module ,
9086: p_msg_text => 'Calling wip move api for move qty',
9087: p_stmt_num => l_stmt_num ,
9088: p_msg_tokens => l_msg_tokens ,
9089: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
9090: p_run_log_level => l_log_level
9091: );
9092: END IF;
9093:
9116: p_module_name => l_module,
9117: p_msg_text => 'wip_movProc_grp.processInterface for move txn returned error: '||l_error_msg,
9118: p_stmt_num => l_stmt_num,
9119: p_msg_tokens => l_msg_tokens,
9120: p_fnd_log_level => G_LOG_LEVEL_ERROR,
9121: p_run_log_level => l_log_level
9122: );
9123: END IF;
9124: raise e_proc_exception;
9134: p_module_name => l_module,
9135: p_msg_text => 'wip_movProc_grp.processInterface for move txn returned success: '||x_wip_move_api_sucess_msg,
9136: p_stmt_num => l_stmt_num,
9137: p_msg_tokens => l_msg_tokens,
9138: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
9139: p_run_log_level => l_log_level
9140: );
9141: END IF;
9142: END IF;
9161: p_module_name => l_module ,
9162: p_msg_text => 'Begin inserting MES data',
9163: p_stmt_num => l_stmt_num ,
9164: p_msg_tokens => l_msg_tokens ,
9165: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
9166: p_run_log_level => l_log_level
9167: );
9168: END IF;
9169: IF ((p_sec_uom_code_tbls IS NOT NULL) AND (p_sec_uom_code_tbls.exists(l_header_id))
9194: p_module_name => l_module,
9195: p_msg_text => 'Updated secondary quantities successfully',
9196: p_stmt_num => l_stmt_num,
9197: p_msg_tokens => l_msg_tokens,
9198: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
9199: p_run_log_level => l_log_level
9200: );
9201: END IF;
9202: END IF;
9223: p_module_name => l_module,
9224: p_msg_text => 'Updated scrap codes successfully',
9225: p_stmt_num => l_stmt_num,
9226: p_msg_tokens => l_msg_tokens,
9227: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
9228: p_run_log_level => l_log_level
9229: );
9230: END IF;
9231: END IF;
9244: ||'; bonus code qty '
9245: ||p_bonus_code_qty_tbls(l_header_id)(i),
9246: p_stmt_num => l_stmt_num,
9247: p_msg_tokens => l_msg_tokens,
9248: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
9249: p_run_log_level => l_log_level
9250: );
9251: END LOOP;
9252: END IF;
9268: p_module_name => l_module,
9269: p_msg_text => 'Updated bonus codes successfully',
9270: p_stmt_num => l_stmt_num,
9271: p_msg_tokens => l_msg_tokens,
9272: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
9273: p_run_log_level => l_log_level
9274: );
9275: END IF;
9276: END IF;
9294: ||'; SERIAL_NUMBER '
9295: ||p_jobop_resource_usages_tbls(l_header_id)(i).SERIAL_NUMBER,
9296: p_stmt_num => l_stmt_num,
9297: p_msg_tokens => l_msg_tokens,
9298: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
9299: p_run_log_level => l_log_level
9300: );
9301: END LOOP;
9302: END IF;
9323: p_msg_text => 'Number of statements that failed: ' || errors||'Error #' || i || ' occurred during '||
9324: 'iteration #' || SQL%BULK_EXCEPTIONS(i).ERROR_INDEX,
9325: p_stmt_num => l_stmt_num,
9326: p_msg_tokens => l_msg_tokens,
9327: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED,
9328: p_run_log_level => l_log_level
9329: );
9330:
9331: WSM_log_PVT.logMessage (
9333: p_msg_text => 'Error message is ' ||
9334: SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE),
9335: p_stmt_num => l_stmt_num,
9336: p_msg_tokens => l_msg_tokens,
9337: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED,
9338: p_run_log_level => l_log_level
9339: );
9340: END IF;
9341:
9388: p_module_name => l_module,
9389: p_msg_text => 'Updated resource usage successfully',
9390: p_stmt_num => l_stmt_num,
9391: p_msg_tokens => l_msg_tokens,
9392: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
9393: p_run_log_level => l_log_level
9394: );
9395: END IF;
9396:
9421: ||'; l_fm_op_seq_num: '
9422: ||l_fm_op_seq_num,
9423: p_stmt_num => l_stmt_num,
9424: p_msg_tokens => l_msg_tokens,
9425: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
9426: p_run_log_level => l_log_level
9427: );
9428: END IF;
9429:
9445: ||'; SERIAL_NUMBER '
9446: ||p_jobop_resource_usages_tbls(l_header_id)(i).SERIAL_NUMBER,
9447: p_stmt_num => l_stmt_num,
9448: p_msg_tokens => l_msg_tokens,
9449: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
9450: p_run_log_level => l_log_level
9451: );
9452: END LOOP;
9453: END IF;
9475: p_msg_text => 'Number of statements that failed: ' || errors||'Error #' || i || ' occurred during '||
9476: 'iteration #' || SQL%BULK_EXCEPTIONS(i).ERROR_INDEX,
9477: p_stmt_num => l_stmt_num,
9478: p_msg_tokens => l_msg_tokens,
9479: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED,
9480: p_run_log_level => l_log_level
9481: );
9482:
9483: WSM_log_PVT.logMessage (
9485: p_msg_text => 'Error message is ' ||
9486: SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE),
9487: p_stmt_num => l_stmt_num,
9488: p_msg_tokens => l_msg_tokens,
9489: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED,
9490: p_run_log_level => l_log_level
9491: );
9492: END IF;
9493:
9531: p_module_name => l_module,
9532: p_msg_text => 'Updated resource usage successfully',
9533: p_stmt_num => l_stmt_num,
9534: p_msg_tokens => l_msg_tokens,
9535: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
9536: p_run_log_level => l_log_level
9537: );
9538: END IF;
9539:
9829: ||'; BONUS_ACCT_ID '
9830: ||l_wltx_resulting_job_tbl(0).BONUS_ACCT_ID,
9831: p_stmt_num => l_stmt_num,
9832: p_msg_tokens => l_msg_tokens,
9833: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
9834: p_run_log_level => l_log_level
9835: );
9836: END IF;
9837: l_stmt_num := 253.10;
9849: p_module_name => l_module,
9850: p_msg_text => 'Populating l_wltx_secondary_qty_tbl',
9851: p_stmt_num => l_stmt_num,
9852: p_msg_tokens => l_msg_tokens,
9853: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
9854: p_run_log_level => l_log_level
9855: );
9856: END IF;
9857: END LOOP;
9876: ';action_flag '||
9877: l_WSM_SERIAL_NUM_TBL(i).action_flag,
9878: p_stmt_num => l_stmt_num,
9879: p_msg_tokens => l_msg_tokens,
9880: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
9881: p_run_log_level => l_log_level
9882: );
9883: END IF;
9884: END LOOP;
9900: ';wdj l_start_qty '||
9901: l_start_qty,
9902: p_stmt_num => l_stmt_num,
9903: p_msg_tokens => l_msg_tokens,
9904: p_fnd_log_level => G_LOG_LEVEL_PROCEDURE,
9905: p_run_log_level => l_log_level
9906: );
9907: EXCEPTION
9908: WHEN others THEN
9940: '; x_error_msg '||
9941: x_error_msg,
9942: p_stmt_num => l_stmt_num,
9943: p_msg_tokens => l_msg_tokens,
9944: p_fnd_log_level => G_LOG_LEVEL_PROCEDURE,
9945: p_run_log_level => l_log_level
9946: );
9947: END IF;
9948: END IF;
9960: p_module_name => l_module,
9961: p_msg_text => 'WSM_WIP_LOT_TXN_PVT.invoke_txn_API returned successfully',
9962: p_stmt_num => l_stmt_num,
9963: p_msg_tokens => l_msg_tokens,
9964: p_fnd_log_level => G_LOG_LEVEL_PROCEDURE,
9965: p_run_log_level => l_log_level
9966: );
9967: END IF;
9968: END IF;
10075: WSM_log_PVT.logMessage ( p_module_name => l_module ,
10076: p_msg_text => 'B4 calling WSM_Serial_support_PVT.Insert_MOVE_attr',
10077: p_stmt_num => l_stmt_num ,
10078: p_msg_tokens => l_msg_tokens ,
10079: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
10080: p_run_log_level => l_log_level
10081: );
10082: END IF;
10083:
10098: WSM_log_PVT.logMessage (p_module_name => l_module ,
10099: p_msg_text => 'WSM_Serial_support_PVT.Insert_MOVE_attr returned successfully',
10100: p_stmt_num => l_stmt_num ,
10101: p_msg_tokens => l_msg_tokens ,
10102: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
10103: p_run_log_level => l_log_level
10104: );
10105: END IF;
10106: ELSE
10109: WSM_log_PVT.logMessage ( p_module_name => l_module ,
10110: p_msg_text => 'WSM_Serial_support_PVT.Insert_MOVE_attr returned error',
10111: p_stmt_num => l_stmt_num ,
10112: p_msg_tokens => l_msg_tokens ,
10113: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
10114: p_run_log_level => l_log_level
10115: );
10116: END IF;
10117: IF (l_error_count = 1) THEN
10146: WSM_log_PVT.logMessage( p_module_name => l_module ,
10147: p_msg_text => 'B4 calling Wip_movProc_grp.processInterface',
10148: p_stmt_num => l_stmt_num ,
10149: p_msg_tokens => l_msg_tokens ,
10150: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
10151: p_run_log_level => l_log_level
10152: );
10153: END IF;
10154: /*******
10192: '; basis_type '||rec.basis_type
10193: ,
10194: p_stmt_num => l_stmt_num ,
10195: p_msg_tokens => l_msg_tokens ,
10196: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
10197: p_run_log_level => l_log_level
10198: );
10199: END LOOP;
10200: END;
10247: '; basis_type '||rec.basis_type
10248: ,
10249: p_stmt_num => l_stmt_num ,
10250: p_msg_tokens => l_msg_tokens ,
10251: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
10252: p_run_log_level => l_log_level
10253: );
10254: END LOOP;
10255: END;
10290: p_module_name => l_module ,
10291: p_msg_text => 'Wip_movProc_grp.processInterface returned unexpected failure',
10292: p_stmt_num => l_stmt_num ,
10293: p_msg_tokens => l_msg_tokens ,
10294: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
10295: p_run_log_level => l_log_level
10296: );
10297: END IF;
10298: raise e_proc_exception;
10317: p_module_name => l_module ,
10318: p_msg_text => 'Wip_movProc_grp.processInterface returned successfully',
10319: p_stmt_num => l_stmt_num ,
10320: p_msg_tokens => l_msg_tokens ,
10321: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
10322: p_run_log_level => l_log_level
10323: );
10324: END IF;
10325: l_success := 1;
10335: p_module_name => l_module ,
10336: p_msg_text => 'Wip_movProc_grp.processInterface returned failure',
10337: p_stmt_num => l_stmt_num ,
10338: p_msg_tokens => l_msg_tokens ,
10339: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
10340: p_run_log_level => l_log_level
10341: );
10342: END IF;
10343: fnd_file.put_line(fnd_file.log, 'Returned unsuccessfully from Wip_movProc_grp.processInterface');
10375: ||';l_wmti_group_id '
10376: ||l_wmti_group_id ,
10377: p_stmt_num => l_stmt_num,
10378: p_msg_tokens => l_msg_tokens,
10379: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
10380: p_run_log_level => l_log_level
10381: );
10382: END IF;
10383:
10759: p_msg_text => 'b4 IF (l_ac_ar_exists=1) '||
10760: ' l_ac_ar_exists '||l_ac_ar_exists,
10761: p_stmt_num => l_stmt_num,
10762: p_msg_tokens => l_msg_tokens,
10763: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
10764: p_run_log_level => l_log_level
10765: );
10766: END IF;
10767:
10821: ' rec.new_wip_entity_name '||rec.new_wip_entity_name||
10822: ' rec.wip_entity_id '||rec.wip_entity_id,
10823: p_stmt_num => l_stmt_num,
10824: p_msg_tokens => l_msg_tokens,
10825: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
10826: p_run_log_level => l_log_level
10827: );
10828: END IF;
10829:
11144: p_module_name => l_module ,
11145: p_msg_text => 'End MoveTransactions Main',
11146: p_stmt_num => l_stmt_num ,
11147: p_msg_tokens => l_msg_tokens ,
11148: p_fnd_log_level => G_LOG_LEVEL_PROCEDURE ,
11149: p_run_log_level => l_log_level
11150: );
11151: END IF;
11152:
11158: p_module_name => l_module,
11159: p_msg_text => 'inside WHEN FND_API.G_EXC_ERROR THEN',
11160: p_stmt_num => l_stmt_num,
11161: p_msg_tokens => l_msg_tokens,
11162: p_fnd_log_level => G_LOG_LEVEL_PROCEDURE,
11163: p_run_log_level => l_log_level
11164: );
11165: END IF;
11166: retcode := 1;
11179: p_module_name => l_module,
11180: p_msg_text => 'inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN',
11181: p_stmt_num => l_stmt_num,
11182: p_msg_tokens => l_msg_tokens,
11183: p_fnd_log_level => G_LOG_LEVEL_PROCEDURE,
11184: p_run_log_level => l_log_level
11185: );
11186: END IF;
11187: retcode := -1;
11231: THEN
11232: WSM_log_PVT.handle_others(
11233: p_module_name => l_module ,
11234: p_stmt_num => l_stmt_num ,
11235: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
11236: p_run_log_level => l_log_level
11237: );
11238: END IF;
11239:
11344: x_msg_index NUMBER;
11345:
11346: -- Logging variables.....
11347: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
11348: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
11349: l_module CONSTANT VARCHAR2(100) := 'wsm.plsql.WSMPLBMI.MoveTransactions.html';
11350: l_param_tbl WSM_Log_PVT.param_tbl_type;
11351: x_error_count NUMBER;
11352: x_return_code NUMBER;
11359: p_module_name => l_module ,
11360: p_msg_text => 'Begin MoveTransactions html',
11361: p_stmt_num => l_stmt_num ,
11362: p_msg_tokens => l_msg_tokens ,
11363: p_fnd_log_level => G_LOG_LEVEL_PROCEDURE ,
11364: p_run_log_level => l_log_level
11365: );
11366: END IF;
11367:
11446: l_param_tbl(38).paramValue := p_mtl_txn_hdr_id;
11447:
11448: WSM_Log_PVT.logProcParams(p_module_name => l_module ,
11449: p_param_tbl => l_param_tbl,
11450: p_fnd_log_level => G_LOG_LEVEL_PROCEDURE
11451: );
11452: END IF;
11453:
11454: l_stmt_num := 10;
11525: ||'MTLI.PRIMARY_QUANTITY: '
11526: ||rec.PRIMARY_QUANTITY,
11527: p_stmt_num => l_stmt_num ,
11528: p_msg_tokens => l_msg_tokens ,
11529: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
11530: p_run_log_level => l_log_level
11531: );
11532: END LOOP;
11533: END;
11538: ||'Number of mti rows: '
11539: ||l_mti_rows,
11540: p_stmt_num => l_stmt_num ,
11541: p_msg_tokens => l_msg_tokens ,
11542: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
11543: p_run_log_level => l_log_level
11544: );
11545: END IF;
11546:
11589: ||'; Number of mmtt rows: '
11590: ||l_numTempRows,
11591: p_stmt_num => l_stmt_num ,
11592: p_msg_tokens => l_msg_tokens ,
11593: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
11594: p_run_log_level => l_log_level
11595: );
11596: END IF;
11597:
11623: p_module_name => l_module ,
11624: p_msg_text => 'Error from INV_TXN_MANAGER_GRP.Validate_Transactions '||x_message,
11625: p_stmt_num => l_stmt_num ,
11626: p_msg_tokens => l_msg_tokens ,
11627: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
11628: p_run_log_level => l_log_level
11629: );
11630: END IF;
11631: end loop;
11641: 'x_return_status '||x_return_status||
11642: '; no of rows in mmtt '||l_numTempRows,
11643: p_stmt_num => l_stmt_num ,
11644: p_msg_tokens => l_msg_tokens ,
11645: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
11646: p_run_log_level => l_log_level
11647: );
11648: END IF;
11649: ELSIF (x_return_status = g_ret_error) THEN
11654: p_msg_text => 'Error from INV_TXN_MANAGER_GRP.Validate_Transactions '
11655: ||x_msg_data,
11656: p_stmt_num => l_stmt_num ,
11657: p_msg_tokens => l_msg_tokens ,
11658: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
11659: p_run_log_level => l_log_level
11660: );
11661: END IF;
11662: RAISE FND_API.G_EXC_ERROR;
11722: ';l_msnt_rows '||
11723: l_msnt_rows,
11724: p_stmt_num => l_stmt_num ,
11725: p_msg_tokens => l_msg_tokens ,
11726: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
11727: p_run_log_level => l_log_level
11728: );
11729: END IF;
11730: END;
11876: ';fnd_global.user_name '||
11877: fnd_global.user_name,
11878: p_stmt_num => l_stmt_num,
11879: p_msg_tokens => l_msg_tokens,
11880: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
11881: p_run_log_level => l_log_level
11882: );
11883: END IF;
11884:
11932: ';errbuf '||
11933: errbuf,
11934: p_stmt_num => l_stmt_num,
11935: p_msg_tokens => l_msg_tokens,
11936: p_fnd_log_level => G_LOG_LEVEL_PROCEDURE,
11937: p_run_log_level => l_log_level
11938: );
11939: END IF;
11940:
11980: p_module_name => l_module ,
11981: p_msg_text => 'End MoveTransactions html',
11982: p_stmt_num => l_stmt_num ,
11983: p_msg_tokens => l_msg_tokens ,
11984: p_fnd_log_level => G_LOG_LEVEL_PROCEDURE ,
11985: p_run_log_level => l_log_level
11986: );
11987: END IF;
11988:
12012: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
12013: THEN
12014: WSM_log_PVT.handle_others( p_module_name => l_module ,
12015: p_stmt_num => l_stmt_num ,
12016: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
12017: p_run_log_level => l_log_level
12018: );
12019: END IF;
12020:
12088: l_job_type NUMBER;
12089: l_first_serial_txn_id NUMBER; --bug 5444062
12090: -- Logging variables.....
12091: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
12092: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
12093: l_module CONSTANT VARCHAR2(100) := 'wsm.plsql.WSMPLBMI.getMoveOutPageProperties';
12094: l_param_tbl WSM_Log_PVT.param_tbl_type;
12095: l_next_links_exist NUMBER := 0; --bug 5531107
12096: x_error_count NUMBER;
12118: ' ;p_current_step '||p_current_step||
12119: ' ;p_user_id '||p_user_id,
12120: p_stmt_num => l_stmt_num ,
12121: p_msg_tokens => l_msg_tokens ,
12122: p_fnd_log_level => G_LOG_LEVEL_PROCEDURE ,
12123: p_run_log_level => l_log_level
12124: );
12125: END IF;
12126:
12239: p_msg_appl_name => 'WSM',
12240: p_msg_tokens => l_msg_tokens,
12241: p_stmt_num => l_stmt_num,
12242: p_fnd_msg_level => G_MSG_LVL_ERROR,
12243: p_fnd_log_level => G_LOG_LEVEL_ERROR,
12244: p_run_log_level => l_log_level
12245: );
12246: END IF;
12247: RAISE FND_API.G_EXC_ERROR;
12258: p_msg_appl_name => 'WSM',
12259: p_msg_tokens => l_msg_tokens,
12260: p_stmt_num => l_stmt_num,
12261: p_fnd_msg_level => G_MSG_LVL_ERROR,
12262: p_fnd_log_level => G_LOG_LEVEL_ERROR,
12263: p_run_log_level => l_log_level
12264: );
12265: END IF;
12266: RAISE FND_API.G_EXC_ERROR;
12285: p_msg_appl_name => 'WSM',
12286: p_msg_tokens => l_msg_tokens,
12287: p_stmt_num => l_stmt_num,
12288: p_fnd_msg_level => G_MSG_LVL_ERROR,
12289: p_fnd_log_level => G_LOG_LEVEL_ERROR,
12290: p_run_log_level => l_log_level
12291: );
12292: END IF;
12293: RAISE FND_API.G_EXC_ERROR;
12609: ||';x_msg_data '
12610: ||x_msg_data,
12611: p_stmt_num => l_stmt_num ,
12612: p_msg_tokens => l_msg_tokens ,
12613: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
12614: p_run_log_level => l_log_level
12615: );
12616: END IF;
12617:
12639: THEN
12640: WSM_log_PVT.handle_others(
12641: p_module_name => l_module ,
12642: p_stmt_num => l_stmt_num ,
12643: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
12644: p_run_log_level => l_log_level
12645: );
12646: END IF;
12647:
12686: l_move_codemask NUMBER;
12687: l_current_job_op_seq_num NUMBER;
12688: -- Logging variables.....
12689: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
12690: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
12691: l_module CONSTANT VARCHAR2(100) := 'wsm.plsql.WSMPLBMI.getJobOpPageProperties';
12692: l_param_tbl WSM_Log_PVT.param_tbl_type;
12693: x_error_count NUMBER;
12694: x_return_code NUMBER;
12710: '; p_current_step_type '||p_current_step_type||
12711: '; p_status_type '||p_status_type,
12712: p_stmt_num => l_stmt_num ,
12713: p_msg_tokens => l_msg_tokens ,
12714: p_fnd_log_level => G_LOG_LEVEL_PROCEDURE ,
12715: p_run_log_level => l_log_level
12716: );
12717: END IF;
12718:
12886: l_param_tbl(11).paramValue := x_msg_data;
12887: WSM_Log_PVT.logProcParams(
12888: p_module_name => l_module ,
12889: p_param_tbl => l_param_tbl,
12890: p_fnd_log_level => G_LOG_LEVEL_PROCEDURE
12891: );
12892: END IF;
12893:
12894:
12922: THEN
12923: WSM_log_PVT.handle_others(
12924: p_module_name => l_module,
12925: p_stmt_num => l_stmt_num,
12926: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED,
12927: p_run_log_level => l_log_level
12928: );
12929: END IF;
12930:
12955: l_costed_quantity_completed NUMBER := 0;
12956: l_fm_costed_quantity_completed NUMBER := 0;
12957: l_to_costed_quantity_completed NUMBER := 0;
12958: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
12959: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
12960: l_module VARCHAR2(100) := 'wsm.plsql.WSMPLBMI.update_costed_qty_compl';
12961: l_stmt_num NUMBER := 0;
12962: BEGIN
12963: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
12984: ||';p_scrap_at_op '
12985: ||p_scrap_at_op,
12986: p_stmt_num => l_stmt_num,
12987: p_msg_tokens => l_msg_tokens,
12988: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
12989: p_run_log_level => l_log_level
12990: );
12991: END IF;
12992: