[Home] [Help]
1: PACKAGE BODY WSMPLBMI AS
2: /* $Header: WSMLBMIB.pls 120.97.12010000.2 2008/09/22 14:59:32 tbhande 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.2 2008/09/22 14:59:32 tbhande 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:
8903: ';l_fm_intraoperation_step_type '||
8904: l_fm_intraoperation_step_type,
8905: p_stmt_num => l_stmt_num ,
8906: p_msg_tokens => l_msg_tokens ,
8907: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
8908: p_run_log_level => l_log_level
8909: );
8910: END IF;
8911:
8934: WSM_log_PVT.logMessage ( p_module_name => l_module ,
8935: p_msg_text => 'B4 calling WSM_Serial_support_PVT.Insert_MOVE_attr',
8936: p_stmt_num => l_stmt_num ,
8937: p_msg_tokens => l_msg_tokens ,
8938: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
8939: p_run_log_level => l_log_level
8940: );
8941: END IF;
8942:
8959: WSM_log_PVT.logMessage (p_module_name => l_module ,
8960: p_msg_text => 'WSM_Serial_support_PVT.Insert_MOVE_attr returned successfully',
8961: p_stmt_num => l_stmt_num ,
8962: p_msg_tokens => l_msg_tokens ,
8963: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
8964: p_run_log_level => l_log_level
8965: );
8966: END IF;
8967: ELSE
8970: WSM_log_PVT.logMessage ( p_module_name => l_module ,
8971: p_msg_text => 'WSM_Serial_support_PVT.Insert_MOVE_attr returned error',
8972: p_stmt_num => l_stmt_num ,
8973: p_msg_tokens => l_msg_tokens ,
8974: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
8975: p_run_log_level => l_log_level
8976: );
8977: END IF;
8978: IF (l_error_count = 1) THEN
9006: p_module_name => l_module ,
9007: p_msg_text => 'Calling wip move api for scrap qty',
9008: p_stmt_num => l_stmt_num ,
9009: p_msg_tokens => l_msg_tokens ,
9010: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
9011: p_run_log_level => l_log_level
9012: );
9013: END IF;
9014:
9046: p_module_name => l_module,
9047: p_msg_text => 'wip_movProc_grp.processInterface for scrap txn returned error: '||l_error_msg,
9048: p_stmt_num => l_stmt_num,
9049: p_msg_tokens => l_msg_tokens,
9050: p_fnd_log_level => G_LOG_LEVEL_ERROR,
9051: p_run_log_level => l_log_level
9052: );
9053: END IF;
9054: raise e_proc_exception;
9060: p_module_name => l_module,
9061: p_msg_text => 'wip_movProc_grp.processInterface for scrap txn returned success: ',
9062: p_stmt_num => l_stmt_num,
9063: p_msg_tokens => l_msg_tokens,
9064: p_fnd_log_level => G_LOG_LEVEL_ERROR,
9065: p_run_log_level => l_log_level
9066: );
9067: END IF;
9068: END IF;
9083: p_module_name => l_module ,
9084: p_msg_text => 'Calling wip move api for move qty',
9085: p_stmt_num => l_stmt_num ,
9086: p_msg_tokens => l_msg_tokens ,
9087: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
9088: p_run_log_level => l_log_level
9089: );
9090: END IF;
9091:
9114: p_module_name => l_module,
9115: p_msg_text => 'wip_movProc_grp.processInterface for move txn returned error: '||l_error_msg,
9116: p_stmt_num => l_stmt_num,
9117: p_msg_tokens => l_msg_tokens,
9118: p_fnd_log_level => G_LOG_LEVEL_ERROR,
9119: p_run_log_level => l_log_level
9120: );
9121: END IF;
9122: raise e_proc_exception;
9132: p_module_name => l_module,
9133: p_msg_text => 'wip_movProc_grp.processInterface for move txn returned success: '||x_wip_move_api_sucess_msg,
9134: p_stmt_num => l_stmt_num,
9135: p_msg_tokens => l_msg_tokens,
9136: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
9137: p_run_log_level => l_log_level
9138: );
9139: END IF;
9140: END IF;
9159: p_module_name => l_module ,
9160: p_msg_text => 'Begin inserting MES data',
9161: p_stmt_num => l_stmt_num ,
9162: p_msg_tokens => l_msg_tokens ,
9163: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
9164: p_run_log_level => l_log_level
9165: );
9166: END IF;
9167: IF ((p_sec_uom_code_tbls IS NOT NULL) AND (p_sec_uom_code_tbls.exists(l_header_id))
9192: p_module_name => l_module,
9193: p_msg_text => 'Updated secondary quantities successfully',
9194: p_stmt_num => l_stmt_num,
9195: p_msg_tokens => l_msg_tokens,
9196: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
9197: p_run_log_level => l_log_level
9198: );
9199: END IF;
9200: END IF;
9221: p_module_name => l_module,
9222: p_msg_text => 'Updated scrap codes successfully',
9223: p_stmt_num => l_stmt_num,
9224: p_msg_tokens => l_msg_tokens,
9225: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
9226: p_run_log_level => l_log_level
9227: );
9228: END IF;
9229: END IF;
9242: ||'; bonus code qty '
9243: ||p_bonus_code_qty_tbls(l_header_id)(i),
9244: p_stmt_num => l_stmt_num,
9245: p_msg_tokens => l_msg_tokens,
9246: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
9247: p_run_log_level => l_log_level
9248: );
9249: END LOOP;
9250: END IF;
9266: p_module_name => l_module,
9267: p_msg_text => 'Updated bonus codes successfully',
9268: p_stmt_num => l_stmt_num,
9269: p_msg_tokens => l_msg_tokens,
9270: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
9271: p_run_log_level => l_log_level
9272: );
9273: END IF;
9274: END IF;
9292: ||'; SERIAL_NUMBER '
9293: ||p_jobop_resource_usages_tbls(l_header_id)(i).SERIAL_NUMBER,
9294: p_stmt_num => l_stmt_num,
9295: p_msg_tokens => l_msg_tokens,
9296: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
9297: p_run_log_level => l_log_level
9298: );
9299: END LOOP;
9300: END IF;
9321: p_msg_text => 'Number of statements that failed: ' || errors||'Error #' || i || ' occurred during '||
9322: 'iteration #' || SQL%BULK_EXCEPTIONS(i).ERROR_INDEX,
9323: p_stmt_num => l_stmt_num,
9324: p_msg_tokens => l_msg_tokens,
9325: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED,
9326: p_run_log_level => l_log_level
9327: );
9328:
9329: WSM_log_PVT.logMessage (
9331: p_msg_text => 'Error message is ' ||
9332: SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE),
9333: p_stmt_num => l_stmt_num,
9334: p_msg_tokens => l_msg_tokens,
9335: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED,
9336: p_run_log_level => l_log_level
9337: );
9338: END IF;
9339:
9386: p_module_name => l_module,
9387: p_msg_text => 'Updated resource usage successfully',
9388: p_stmt_num => l_stmt_num,
9389: p_msg_tokens => l_msg_tokens,
9390: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
9391: p_run_log_level => l_log_level
9392: );
9393: END IF;
9394:
9419: ||'; l_fm_op_seq_num: '
9420: ||l_fm_op_seq_num,
9421: p_stmt_num => l_stmt_num,
9422: p_msg_tokens => l_msg_tokens,
9423: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
9424: p_run_log_level => l_log_level
9425: );
9426: END IF;
9427:
9443: ||'; SERIAL_NUMBER '
9444: ||p_jobop_resource_usages_tbls(l_header_id)(i).SERIAL_NUMBER,
9445: p_stmt_num => l_stmt_num,
9446: p_msg_tokens => l_msg_tokens,
9447: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
9448: p_run_log_level => l_log_level
9449: );
9450: END LOOP;
9451: END IF;
9473: p_msg_text => 'Number of statements that failed: ' || errors||'Error #' || i || ' occurred during '||
9474: 'iteration #' || SQL%BULK_EXCEPTIONS(i).ERROR_INDEX,
9475: p_stmt_num => l_stmt_num,
9476: p_msg_tokens => l_msg_tokens,
9477: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED,
9478: p_run_log_level => l_log_level
9479: );
9480:
9481: WSM_log_PVT.logMessage (
9483: p_msg_text => 'Error message is ' ||
9484: SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE),
9485: p_stmt_num => l_stmt_num,
9486: p_msg_tokens => l_msg_tokens,
9487: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED,
9488: p_run_log_level => l_log_level
9489: );
9490: END IF;
9491:
9529: p_module_name => l_module,
9530: p_msg_text => 'Updated resource usage successfully',
9531: p_stmt_num => l_stmt_num,
9532: p_msg_tokens => l_msg_tokens,
9533: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
9534: p_run_log_level => l_log_level
9535: );
9536: END IF;
9537:
9827: ||'; BONUS_ACCT_ID '
9828: ||l_wltx_resulting_job_tbl(0).BONUS_ACCT_ID,
9829: p_stmt_num => l_stmt_num,
9830: p_msg_tokens => l_msg_tokens,
9831: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
9832: p_run_log_level => l_log_level
9833: );
9834: END IF;
9835: l_stmt_num := 253.10;
9847: p_module_name => l_module,
9848: p_msg_text => 'Populating l_wltx_secondary_qty_tbl',
9849: p_stmt_num => l_stmt_num,
9850: p_msg_tokens => l_msg_tokens,
9851: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
9852: p_run_log_level => l_log_level
9853: );
9854: END IF;
9855: END LOOP;
9874: ';action_flag '||
9875: l_WSM_SERIAL_NUM_TBL(i).action_flag,
9876: p_stmt_num => l_stmt_num,
9877: p_msg_tokens => l_msg_tokens,
9878: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
9879: p_run_log_level => l_log_level
9880: );
9881: END IF;
9882: END LOOP;
9898: ';wdj l_start_qty '||
9899: l_start_qty,
9900: p_stmt_num => l_stmt_num,
9901: p_msg_tokens => l_msg_tokens,
9902: p_fnd_log_level => G_LOG_LEVEL_PROCEDURE,
9903: p_run_log_level => l_log_level
9904: );
9905: EXCEPTION
9906: WHEN others THEN
9938: '; x_error_msg '||
9939: x_error_msg,
9940: p_stmt_num => l_stmt_num,
9941: p_msg_tokens => l_msg_tokens,
9942: p_fnd_log_level => G_LOG_LEVEL_PROCEDURE,
9943: p_run_log_level => l_log_level
9944: );
9945: END IF;
9946: END IF;
9958: p_module_name => l_module,
9959: p_msg_text => 'WSM_WIP_LOT_TXN_PVT.invoke_txn_API returned successfully',
9960: p_stmt_num => l_stmt_num,
9961: p_msg_tokens => l_msg_tokens,
9962: p_fnd_log_level => G_LOG_LEVEL_PROCEDURE,
9963: p_run_log_level => l_log_level
9964: );
9965: END IF;
9966: END IF;
10073: WSM_log_PVT.logMessage ( p_module_name => l_module ,
10074: p_msg_text => 'B4 calling WSM_Serial_support_PVT.Insert_MOVE_attr',
10075: p_stmt_num => l_stmt_num ,
10076: p_msg_tokens => l_msg_tokens ,
10077: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
10078: p_run_log_level => l_log_level
10079: );
10080: END IF;
10081:
10096: WSM_log_PVT.logMessage (p_module_name => l_module ,
10097: p_msg_text => 'WSM_Serial_support_PVT.Insert_MOVE_attr returned successfully',
10098: p_stmt_num => l_stmt_num ,
10099: p_msg_tokens => l_msg_tokens ,
10100: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
10101: p_run_log_level => l_log_level
10102: );
10103: END IF;
10104: ELSE
10107: WSM_log_PVT.logMessage ( p_module_name => l_module ,
10108: p_msg_text => 'WSM_Serial_support_PVT.Insert_MOVE_attr returned error',
10109: p_stmt_num => l_stmt_num ,
10110: p_msg_tokens => l_msg_tokens ,
10111: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
10112: p_run_log_level => l_log_level
10113: );
10114: END IF;
10115: IF (l_error_count = 1) THEN
10144: WSM_log_PVT.logMessage( p_module_name => l_module ,
10145: p_msg_text => 'B4 calling Wip_movProc_grp.processInterface',
10146: p_stmt_num => l_stmt_num ,
10147: p_msg_tokens => l_msg_tokens ,
10148: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
10149: p_run_log_level => l_log_level
10150: );
10151: END IF;
10152: /*******
10190: '; basis_type '||rec.basis_type
10191: ,
10192: p_stmt_num => l_stmt_num ,
10193: p_msg_tokens => l_msg_tokens ,
10194: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
10195: p_run_log_level => l_log_level
10196: );
10197: END LOOP;
10198: END;
10245: '; basis_type '||rec.basis_type
10246: ,
10247: p_stmt_num => l_stmt_num ,
10248: p_msg_tokens => l_msg_tokens ,
10249: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
10250: p_run_log_level => l_log_level
10251: );
10252: END LOOP;
10253: END;
10288: p_module_name => l_module ,
10289: p_msg_text => 'Wip_movProc_grp.processInterface returned unexpected failure',
10290: p_stmt_num => l_stmt_num ,
10291: p_msg_tokens => l_msg_tokens ,
10292: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
10293: p_run_log_level => l_log_level
10294: );
10295: END IF;
10296: raise e_proc_exception;
10315: p_module_name => l_module ,
10316: p_msg_text => 'Wip_movProc_grp.processInterface returned successfully',
10317: p_stmt_num => l_stmt_num ,
10318: p_msg_tokens => l_msg_tokens ,
10319: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
10320: p_run_log_level => l_log_level
10321: );
10322: END IF;
10323: l_success := 1;
10333: p_module_name => l_module ,
10334: p_msg_text => 'Wip_movProc_grp.processInterface returned failure',
10335: p_stmt_num => l_stmt_num ,
10336: p_msg_tokens => l_msg_tokens ,
10337: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
10338: p_run_log_level => l_log_level
10339: );
10340: END IF;
10341: fnd_file.put_line(fnd_file.log, 'Returned unsuccessfully from Wip_movProc_grp.processInterface');
10373: ||';l_wmti_group_id '
10374: ||l_wmti_group_id ,
10375: p_stmt_num => l_stmt_num,
10376: p_msg_tokens => l_msg_tokens,
10377: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
10378: p_run_log_level => l_log_level
10379: );
10380: END IF;
10381:
10757: p_msg_text => 'b4 IF (l_ac_ar_exists=1) '||
10758: ' l_ac_ar_exists '||l_ac_ar_exists,
10759: p_stmt_num => l_stmt_num,
10760: p_msg_tokens => l_msg_tokens,
10761: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
10762: p_run_log_level => l_log_level
10763: );
10764: END IF;
10765:
10819: ' rec.new_wip_entity_name '||rec.new_wip_entity_name||
10820: ' rec.wip_entity_id '||rec.wip_entity_id,
10821: p_stmt_num => l_stmt_num,
10822: p_msg_tokens => l_msg_tokens,
10823: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
10824: p_run_log_level => l_log_level
10825: );
10826: END IF;
10827:
11142: p_module_name => l_module ,
11143: p_msg_text => 'End MoveTransactions Main',
11144: p_stmt_num => l_stmt_num ,
11145: p_msg_tokens => l_msg_tokens ,
11146: p_fnd_log_level => G_LOG_LEVEL_PROCEDURE ,
11147: p_run_log_level => l_log_level
11148: );
11149: END IF;
11150:
11156: p_module_name => l_module,
11157: p_msg_text => 'inside WHEN FND_API.G_EXC_ERROR THEN',
11158: p_stmt_num => l_stmt_num,
11159: p_msg_tokens => l_msg_tokens,
11160: p_fnd_log_level => G_LOG_LEVEL_PROCEDURE,
11161: p_run_log_level => l_log_level
11162: );
11163: END IF;
11164: retcode := 1;
11177: p_module_name => l_module,
11178: p_msg_text => 'inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN',
11179: p_stmt_num => l_stmt_num,
11180: p_msg_tokens => l_msg_tokens,
11181: p_fnd_log_level => G_LOG_LEVEL_PROCEDURE,
11182: p_run_log_level => l_log_level
11183: );
11184: END IF;
11185: retcode := -1;
11229: THEN
11230: WSM_log_PVT.handle_others(
11231: p_module_name => l_module ,
11232: p_stmt_num => l_stmt_num ,
11233: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
11234: p_run_log_level => l_log_level
11235: );
11236: END IF;
11237:
11342: x_msg_index NUMBER;
11343:
11344: -- Logging variables.....
11345: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
11346: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
11347: l_module CONSTANT VARCHAR2(100) := 'wsm.plsql.WSMPLBMI.MoveTransactions.html';
11348: l_param_tbl WSM_Log_PVT.param_tbl_type;
11349: x_error_count NUMBER;
11350: x_return_code NUMBER;
11357: p_module_name => l_module ,
11358: p_msg_text => 'Begin MoveTransactions html',
11359: p_stmt_num => l_stmt_num ,
11360: p_msg_tokens => l_msg_tokens ,
11361: p_fnd_log_level => G_LOG_LEVEL_PROCEDURE ,
11362: p_run_log_level => l_log_level
11363: );
11364: END IF;
11365:
11444: l_param_tbl(38).paramValue := p_mtl_txn_hdr_id;
11445:
11446: WSM_Log_PVT.logProcParams(p_module_name => l_module ,
11447: p_param_tbl => l_param_tbl,
11448: p_fnd_log_level => G_LOG_LEVEL_PROCEDURE
11449: );
11450: END IF;
11451:
11452: l_stmt_num := 10;
11523: ||'MTLI.PRIMARY_QUANTITY: '
11524: ||rec.PRIMARY_QUANTITY,
11525: p_stmt_num => l_stmt_num ,
11526: p_msg_tokens => l_msg_tokens ,
11527: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
11528: p_run_log_level => l_log_level
11529: );
11530: END LOOP;
11531: END;
11536: ||'Number of mti rows: '
11537: ||l_mti_rows,
11538: p_stmt_num => l_stmt_num ,
11539: p_msg_tokens => l_msg_tokens ,
11540: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
11541: p_run_log_level => l_log_level
11542: );
11543: END IF;
11544:
11587: ||'; Number of mmtt rows: '
11588: ||l_numTempRows,
11589: p_stmt_num => l_stmt_num ,
11590: p_msg_tokens => l_msg_tokens ,
11591: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
11592: p_run_log_level => l_log_level
11593: );
11594: END IF;
11595:
11621: p_module_name => l_module ,
11622: p_msg_text => 'Error from INV_TXN_MANAGER_GRP.Validate_Transactions '||x_message,
11623: p_stmt_num => l_stmt_num ,
11624: p_msg_tokens => l_msg_tokens ,
11625: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
11626: p_run_log_level => l_log_level
11627: );
11628: END IF;
11629: end loop;
11639: 'x_return_status '||x_return_status||
11640: '; no of rows in mmtt '||l_numTempRows,
11641: p_stmt_num => l_stmt_num ,
11642: p_msg_tokens => l_msg_tokens ,
11643: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
11644: p_run_log_level => l_log_level
11645: );
11646: END IF;
11647: ELSIF (x_return_status = g_ret_error) THEN
11652: p_msg_text => 'Error from INV_TXN_MANAGER_GRP.Validate_Transactions '
11653: ||x_msg_data,
11654: p_stmt_num => l_stmt_num ,
11655: p_msg_tokens => l_msg_tokens ,
11656: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
11657: p_run_log_level => l_log_level
11658: );
11659: END IF;
11660: RAISE FND_API.G_EXC_ERROR;
11720: ';l_msnt_rows '||
11721: l_msnt_rows,
11722: p_stmt_num => l_stmt_num ,
11723: p_msg_tokens => l_msg_tokens ,
11724: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
11725: p_run_log_level => l_log_level
11726: );
11727: END IF;
11728: END;
11874: ';fnd_global.user_name '||
11875: fnd_global.user_name,
11876: p_stmt_num => l_stmt_num,
11877: p_msg_tokens => l_msg_tokens,
11878: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
11879: p_run_log_level => l_log_level
11880: );
11881: END IF;
11882:
11930: ';errbuf '||
11931: errbuf,
11932: p_stmt_num => l_stmt_num,
11933: p_msg_tokens => l_msg_tokens,
11934: p_fnd_log_level => G_LOG_LEVEL_PROCEDURE,
11935: p_run_log_level => l_log_level
11936: );
11937: END IF;
11938:
11978: p_module_name => l_module ,
11979: p_msg_text => 'End MoveTransactions html',
11980: p_stmt_num => l_stmt_num ,
11981: p_msg_tokens => l_msg_tokens ,
11982: p_fnd_log_level => G_LOG_LEVEL_PROCEDURE ,
11983: p_run_log_level => l_log_level
11984: );
11985: END IF;
11986:
12010: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
12011: THEN
12012: WSM_log_PVT.handle_others( p_module_name => l_module ,
12013: p_stmt_num => l_stmt_num ,
12014: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
12015: p_run_log_level => l_log_level
12016: );
12017: END IF;
12018:
12086: l_job_type NUMBER;
12087: l_first_serial_txn_id NUMBER; --bug 5444062
12088: -- Logging variables.....
12089: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
12090: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
12091: l_module CONSTANT VARCHAR2(100) := 'wsm.plsql.WSMPLBMI.getMoveOutPageProperties';
12092: l_param_tbl WSM_Log_PVT.param_tbl_type;
12093: l_next_links_exist NUMBER := 0; --bug 5531107
12094: x_error_count NUMBER;
12116: ' ;p_current_step '||p_current_step||
12117: ' ;p_user_id '||p_user_id,
12118: p_stmt_num => l_stmt_num ,
12119: p_msg_tokens => l_msg_tokens ,
12120: p_fnd_log_level => G_LOG_LEVEL_PROCEDURE ,
12121: p_run_log_level => l_log_level
12122: );
12123: END IF;
12124:
12237: p_msg_appl_name => 'WSM',
12238: p_msg_tokens => l_msg_tokens,
12239: p_stmt_num => l_stmt_num,
12240: p_fnd_msg_level => G_MSG_LVL_ERROR,
12241: p_fnd_log_level => G_LOG_LEVEL_ERROR,
12242: p_run_log_level => l_log_level
12243: );
12244: END IF;
12245: RAISE FND_API.G_EXC_ERROR;
12256: p_msg_appl_name => 'WSM',
12257: p_msg_tokens => l_msg_tokens,
12258: p_stmt_num => l_stmt_num,
12259: p_fnd_msg_level => G_MSG_LVL_ERROR,
12260: p_fnd_log_level => G_LOG_LEVEL_ERROR,
12261: p_run_log_level => l_log_level
12262: );
12263: END IF;
12264: RAISE FND_API.G_EXC_ERROR;
12283: p_msg_appl_name => 'WSM',
12284: p_msg_tokens => l_msg_tokens,
12285: p_stmt_num => l_stmt_num,
12286: p_fnd_msg_level => G_MSG_LVL_ERROR,
12287: p_fnd_log_level => G_LOG_LEVEL_ERROR,
12288: p_run_log_level => l_log_level
12289: );
12290: END IF;
12291: RAISE FND_API.G_EXC_ERROR;
12607: ||';x_msg_data '
12608: ||x_msg_data,
12609: p_stmt_num => l_stmt_num ,
12610: p_msg_tokens => l_msg_tokens ,
12611: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
12612: p_run_log_level => l_log_level
12613: );
12614: END IF;
12615:
12637: THEN
12638: WSM_log_PVT.handle_others(
12639: p_module_name => l_module ,
12640: p_stmt_num => l_stmt_num ,
12641: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
12642: p_run_log_level => l_log_level
12643: );
12644: END IF;
12645:
12684: l_move_codemask NUMBER;
12685: l_current_job_op_seq_num NUMBER;
12686: -- Logging variables.....
12687: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
12688: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
12689: l_module CONSTANT VARCHAR2(100) := 'wsm.plsql.WSMPLBMI.getJobOpPageProperties';
12690: l_param_tbl WSM_Log_PVT.param_tbl_type;
12691: x_error_count NUMBER;
12692: x_return_code NUMBER;
12708: '; p_current_step_type '||p_current_step_type||
12709: '; p_status_type '||p_status_type,
12710: p_stmt_num => l_stmt_num ,
12711: p_msg_tokens => l_msg_tokens ,
12712: p_fnd_log_level => G_LOG_LEVEL_PROCEDURE ,
12713: p_run_log_level => l_log_level
12714: );
12715: END IF;
12716:
12884: l_param_tbl(11).paramValue := x_msg_data;
12885: WSM_Log_PVT.logProcParams(
12886: p_module_name => l_module ,
12887: p_param_tbl => l_param_tbl,
12888: p_fnd_log_level => G_LOG_LEVEL_PROCEDURE
12889: );
12890: END IF;
12891:
12892:
12920: THEN
12921: WSM_log_PVT.handle_others(
12922: p_module_name => l_module,
12923: p_stmt_num => l_stmt_num,
12924: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED,
12925: p_run_log_level => l_log_level
12926: );
12927: END IF;
12928:
12953: l_costed_quantity_completed NUMBER := 0;
12954: l_fm_costed_quantity_completed NUMBER := 0;
12955: l_to_costed_quantity_completed NUMBER := 0;
12956: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
12957: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
12958: l_module VARCHAR2(100) := 'wsm.plsql.WSMPLBMI.update_costed_qty_compl';
12959: l_stmt_num NUMBER := 0;
12960: BEGIN
12961: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
12982: ||';p_scrap_at_op '
12983: ||p_scrap_at_op,
12984: p_stmt_num => l_stmt_num,
12985: p_msg_tokens => l_msg_tokens,
12986: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
12987: p_run_log_level => l_log_level
12988: );
12989: END IF;
12990: