eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSMPLBMI dependencies on WSM_LOG_PVT

Line 295: l_msg_tokens WSM_Log_PVT.token_rec_tbl;

291: l_wmt_scrap_acc NUMBER;
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);

Line 298: l_param_tbl WSM_Log_PVT.param_tbl_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;
301: l_msg_data varchar2(4000);
302: --mes end

Line 815: WSM_log_PVT.logMessage (

811: END IF;
812:
813: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
814: l_msg_tokens.delete;
815: WSM_log_PVT.logMessage (
816: p_module_name => l_module,
817: p_msg_text => 'B4 IF (l_wlmti_last_upd_name IS NULL) '||
818: ';l_wlmti_last_upd_by '||
819: l_wlmti_last_upd_by||

Line 862: WSM_log_PVT.logMessage (

858: --***VJ End Additions***--
859:
860: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
861: l_msg_tokens.delete;
862: WSM_log_PVT.logMessage (
863: p_module_name => l_module,
864: p_msg_text => 'B4 IF (l_wlmti_last_upd_name IS NULL) '||
865: ';l_wlmti_last_upd_name '||
866: l_wlmti_last_upd_name||

Line 1256: WSM_log_PVT.logMessage (

1252: where organization_id = p_org_id;
1253:
1254: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
1255: l_msg_tokens.delete;
1256: WSM_log_PVT.logMessage (
1257: p_module_name => l_module,
1258: p_msg_text => 'Check for no move statuses'||
1259: ';p_fm_op_seq_num '||
1260: p_fm_op_seq_num||

Line 1275: WSM_log_PVT.logMessage (

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,
1277: p_msg_text => 'Value returned by WIP_SF_STATUS.COUNT_NO_MOVE_STATUSES '||
1278: WIP_SF_STATUS.COUNT_NO_MOVE_STATUSES(
1279: p_org_id, /* organization_id */

Line 4598: WSM_log_PVT.logMessage (

4594: END;
4595:
4596: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
4597: l_msg_tokens.delete;
4598: WSM_log_PVT.logMessage (
4599: p_module_name => l_module,
4600: p_msg_text => 'After select on WIP_MOVE_TRANSACTIONS: '||
4601: 'l_wmt_scrap_qty '||l_wmt_scrap_qty||
4602: '; l_wmt_pri_scrap_qty '||l_wmt_pri_scrap_qty||

Line 4712: WSM_log_PVT.logMessage (

4708:
4709: l_converted_scrap_qty := l_wmt_pri_scrap_qty;
4710: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
4711: l_msg_tokens.delete;
4712: WSM_log_PVT.logMessage (
4713: p_module_name => l_module,
4714: p_msg_text => 'In IF (x_err_buf IS NOT NULL) THEN '||
4715: ';l_converted_scrap_qty '||
4716: l_converted_scrap_qty,

Line 4823: WSM_log_PVT.logMessage (

4819: from_name => NULL,
4820: to_name => NULL);
4821: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
4822: l_msg_tokens.delete;
4823: WSM_log_PVT.logMessage (
4824: p_module_name => l_module,
4825: p_msg_text => 'After inv_convert.inv_um_convert '||
4826: ';l_converted_scrap_qty '||
4827: l_converted_scrap_qty,

Line 5145: WSM_log_PVT.logMessage (

5141: END IF;
5142:
5143: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
5144: l_msg_tokens.delete;
5145: WSM_log_PVT.logMessage (
5146: p_module_name => l_module,
5147: p_msg_text => 'B4 UPDATE WSM_LOT_MOVE_TXN_INTERFACE WLMTI'||
5148: ';l_converted_scrap_qty '||
5149: l_converted_scrap_qty,

Line 5616: l_msg_tokens WSM_Log_PVT.token_rec_tbl;

5612: x_undone_batch_id number;
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);

Line 5619: l_param_tbl WSM_Log_PVT.param_tbl_type;

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;
5622: l_msg_data varchar2(4000);
5623: BEGIN

Line 5626: WSM_log_PVT.logMessage (

5622: l_msg_data varchar2(4000);
5623: BEGIN
5624: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
5625: l_msg_tokens.delete;
5626: WSM_log_PVT.logMessage (
5627: p_module_name => l_module,
5628: p_msg_text => 'Begin set_undo_txn_id '
5629: ||';p_org_id '
5630: ||p_org_id

Line 5665: WSM_log_PVT.logMessage (

5661: end if;
5662:
5663: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
5664: l_msg_tokens.delete;
5665: WSM_log_PVT.logMessage (
5666: p_module_name => l_module,
5667: p_msg_text => 'x_undone_batch_id '
5668: ||x_undone_batch_id,
5669: p_stmt_num => l_stmt_num,

Line 6207: l_msg_tokens WSM_Log_PVT.token_rec_tbl;

6203: --MES END
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...

Line 6210: l_param_tbl WSM_Log_PVT.param_tbl_type;

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:
6213: BEGIN
6214: IF (G_LOG_LEVEL_PROCEDURE >= l_log_level) THEN

Line 6216: WSM_log_PVT.logMessage (

6212:
6213: BEGIN
6214: IF (G_LOG_LEVEL_PROCEDURE >= l_log_level) THEN
6215: l_msg_tokens.delete;
6216: WSM_log_PVT.logMessage (
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 ,

Line 6250: WSM_Log_PVT.logProcParams(p_module_name => l_module ,

6246: l_param_tbl(10).paramValue := p_source_code;
6247: l_param_tbl(11).paramName := 'p_mtl_txn_hdr_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;

Line 6291: WSM_log_PVT.logMessage (

6287: l_count := 0;
6288: l_stmt_num := 20;
6289: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
6290: l_msg_tokens.delete;
6291: WSM_log_PVT.logMessage (
6292: p_module_name => l_module,
6293: p_msg_text => 'B4 UPDATE wsm_lot_move_txn_interface wlmti '||
6294: ';g_user_id '||
6295: g_user_id||

Line 6540: WSM_log_PVT.logMessage (

6536: , x_error_msg => x_err_msg);
6537: IF (x_err_code <> 0) THEN
6538: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
6539: l_msg_tokens.delete;
6540: WSM_log_PVT.logMessage (
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 ,

Line 6557: WSM_log_PVT.logMessage (

6553: fnd_file.put_line(fnd_file.log, 'custom_validation returned failure. Rolled back to validation');
6554: END IF;
6555: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
6556: l_msg_tokens.delete;
6557: WSM_log_PVT.logMessage (
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 ,

Line 6573: WSM_log_PVT.logMessage (

6569: fnd_file.put_line(fnd_file.log, 'custom_validation returned success');
6570: END IF;
6571: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
6572: l_msg_tokens.delete;
6573: WSM_log_PVT.logMessage (
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 ,

Line 6714: WSM_log_PVT.logMessage (

6710: END IF;
6711:
6712: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
6713: l_msg_tokens.delete;
6714: WSM_log_PVT.logMessage (
6715: p_module_name => l_module ,
6716: p_msg_text => 'SELECT from WLMTI after custom_validations '||
6717: ';l_transaction_type '||
6718: l_transaction_type||

Line 6762: WSM_log_PVT.logMessage (

6758: --MES
6759: IF (nvl(p_source_code, 'interface') = 'move out oa page') THEN
6760: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
6761: l_msg_tokens.delete;
6762: WSM_log_PVT.logMessage (
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 ,

Line 6787: WSM_LOG_PVT.LogMessage(

6783: l_stmt_num := 253.14;
6784: l_put_job_on_hold := 1;
6785: /*************************No need to throw error************************************
6786: l_msg_tokens.delete;
6787: WSM_LOG_PVT.LogMessage(
6788: p_module_name => l_module,
6789: p_msg_name => 'WSM_MES_SCRAP_YIELD_LIMIT',
6790: p_msg_appl_name => 'WSM',
6791: p_msg_text => NULL,

Line 6810: WSM_log_PVT.logMessage (

6806: AND (p_scrap_codes_tbls(l_header_id).count > 0))
6807: THEN
6808: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
6809: l_msg_tokens.delete;
6810: WSM_log_PVT.logMessage (
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 ,

Line 6824: WSM_log_PVT.logMessage (

6820: l_stmt_num := 110.4;
6821: FOR i in 1..p_scrap_codes_tbls(l_header_id).last LOOP
6822: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
6823: l_msg_tokens.delete;
6824: WSM_log_PVT.logMessage (
6825: p_module_name => l_module ,
6826: p_msg_text =>
6827: '; i '||
6828: i||

Line 6852: WSM_log_PVT.LogMessage(

6848: l_msg_tokens(0).TokenValue := reason_code_err_info(
6849: p_reason_code_num => to_number(p_scrap_codes_tbls(l_header_id)(i))
6850: , p_reason_code_type => 1
6851: );
6852: WSM_log_PVT.LogMessage(
6853: p_module_name => l_module,
6854: p_msg_name => 'WSM_MES_FIELD_NEGATIVE',
6855: p_msg_appl_name => 'WSM',
6856: p_msg_text => NULL,

Line 6893: WSM_LOG_PVT.LogMessage(

6889: l_msg_tokens(0).TokenValue := reason_code_err_info(
6890: p_reason_code_num => to_number(p_scrap_codes_tbls(l_header_id)(i))
6891: , p_reason_code_type => 1
6892: );
6893: WSM_LOG_PVT.LogMessage(
6894: p_module_name => l_module,
6895: p_msg_name => 'WSM_MES_SCRAP_CODE_MAX_QTY',
6896: p_msg_appl_name => 'WSM',
6897: p_msg_text => NULL,

Line 6918: WSM_log_PVT.LogMessage(

6914:
6915: IF (nvl(l_total_scrap_code_qty, 0) <> nvl(l_scrap_qty, 0)) THEN
6916: l_stmt_num := 110.801;
6917: l_msg_tokens.delete;
6918: WSM_log_PVT.LogMessage(
6919: p_module_name => l_module,
6920: p_msg_name => 'WSM_MES_SCRAPCODEQTY_MISMATCH',
6921: p_msg_appl_name => 'WSM',
6922: p_msg_text => NULL,

Line 6937: WSM_log_PVT.logMessage (

6933:
6934: END IF;
6935: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
6936: l_msg_tokens.delete;
6937: WSM_log_PVT.logMessage (
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 ,

Line 6955: WSM_log_PVT.logMessage (

6951: AND (p_bonus_codes_tbls(l_header_id).count > 0)) THEN
6952: l_stmt_num := 110.10;
6953: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
6954: l_msg_tokens.delete;
6955: WSM_log_PVT.logMessage (
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 ,

Line 6976: WSM_log_PVT.LogMessage(

6972: l_msg_tokens(0).TokenValue := reason_code_err_info(
6973: p_reason_code_num => to_number(p_bonus_codes_tbls(l_header_id)(i))
6974: , p_reason_code_type => 2
6975: );
6976: WSM_log_PVT.LogMessage(
6977: p_module_name => l_module,
6978: p_msg_name => 'WSM_MES_FIELD_NEGATIVE',
6979: p_msg_appl_name => 'WSM',
6980: p_msg_text => NULL,

Line 7005: WSM_log_PVT.LogMessage(

7001:
7002: IF (nvl(l_total_bonus_code_qty, 0) <> nvl(p_bonus_quantity, 0)) THEN
7003: l_stmt_num := 110.121;
7004: l_msg_tokens.delete;
7005: WSM_log_PVT.LogMessage(
7006: p_module_name => l_module,
7007: p_msg_name => 'WSM_MES_BONUSCODEQTY_MISMATCH',
7008: p_msg_appl_name => 'WSM',
7009: p_msg_text => NULL,

Line 7024: WSM_log_PVT.logMessage (

7020:
7021: END IF;
7022: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
7023: l_msg_tokens.delete;
7024: WSM_log_PVT.logMessage (
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 ,

Line 7045: WSM_log_PVT.logMessage (

7041: THEN
7042: l_stmt_num := 110.131;
7043: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
7044: l_msg_tokens.delete;
7045: WSM_log_PVT.logMessage (
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 ,

Line 7055: WSM_log_PVT.logMessage (

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;
7055: WSM_log_PVT.logMessage (
7056: p_module_name => l_module ,
7057: p_msg_text => 'p_jobop_scrap_serials_tbls '
7058: ||';i '
7059: ||i

Line 7072: WSM_log_PVT.LogMessage(

7068: END IF;
7069:
7070: IF (nvl(l_scrap_qty, 0) <> (nvl(p_jobop_scrap_serials_tbls(l_header_id).last, 0))) THEN
7071: l_msg_tokens.delete;
7072: WSM_log_PVT.LogMessage(
7073: p_module_name => l_module,
7074: p_msg_name => 'WSM_MES_SCRAPSERIAL_QTY',
7075: p_msg_appl_name => 'WSM',
7076: p_msg_text => NULL,

Line 7091: WSM_log_PVT.logMessage (

7087: END IF;
7088:
7089: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
7090: l_msg_tokens.delete;
7091: WSM_log_PVT.logMessage (
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,

Line 7111: WSM_log_PVT.logMessage (

7107: THEN
7108: l_stmt_num := 110.141;
7109: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
7110: l_msg_tokens.delete;
7111: WSM_log_PVT.logMessage (
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 ,

Line 7121: WSM_log_PVT.logMessage (

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;
7121: WSM_log_PVT.logMessage (
7122: p_module_name => l_module ,
7123: p_msg_text => 'p_jobop_bonus_serials_tbls '
7124: ||';i '
7125: ||i

Line 7137: WSM_log_PVT.LogMessage(

7133: END LOOP;
7134: END IF;
7135:
7136: l_msg_tokens.delete;
7137: WSM_log_PVT.LogMessage(
7138: p_module_name => l_module,
7139: p_msg_name => 'WSM_MES_BONUSSERIAL_QTY',
7140: p_msg_appl_name => 'WSM',
7141: p_msg_text => NULL,

Line 7155: WSM_log_PVT.logMessage (

7151: RAISE FND_API.G_EXC_ERROR;
7152:
7153: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
7154: l_msg_tokens.delete;
7155: WSM_log_PVT.logMessage (
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,

Line 7174: WSM_log_PVT.logMessage (

7170:
7171: l_stmt_num := 110.16;
7172: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
7173: l_msg_tokens.delete;
7174: WSM_log_PVT.logMessage (
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 ,

Line 7188: WSM_log_PVT.logMessage (

7184: l_stmt_num := 110.17;
7185: --removed check on null start, comletion dates in
7186: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
7187: l_msg_tokens.delete;
7188: WSM_log_PVT.logMessage (
7189: p_module_name => l_module,
7190: p_msg_text => 'Resource info '||
7191: ';i '||
7192: i||

Line 7215: WSM_log_PVT.LogMessage(

7211: IF (p_jobop_resource_usages_tbls(l_header_id)(i).start_date IS NOT NULL)
7212: AND (p_jobop_resource_usages_tbls(l_header_id)(i).start_date > sysdate) THEN
7213: l_stmt_num := 110.191;
7214: l_msg_tokens.delete;
7215: WSM_log_PVT.LogMessage(
7216: p_module_name => l_module,
7217: p_msg_name => 'WSM_MES_START>CURRENTDATE',
7218: p_msg_appl_name => 'WSM',
7219: p_msg_text => NULL,

Line 7248: WSM_log_PVT.LogMessage(

7244: p_jobop_resource_usages_tbls(l_header_id)(i).start_date)
7245: THEN
7246: l_stmt_num := 110.201;
7247: l_msg_tokens.delete;
7248: WSM_log_PVT.LogMessage(
7249: p_module_name => l_module,
7250: p_msg_name => 'WSM_MES_RESCOMPL 7251: p_msg_appl_name => 'WSM',
7252: p_msg_text => NULL,

Line 7284: WSM_log_PVT.logMessage (

7280: l_j_end DATE := p_jobop_resource_usages_tbls(l_header_id)(j).end_date;
7281: BEGIN
7282: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
7283: l_msg_tokens.delete;
7284: WSM_log_PVT.logMessage (
7285: p_module_name => l_module,
7286: p_msg_text => 'B4 move out overlap dates check '||
7287: ';i '||
7288: i||

Line 7340: WSM_log_PVT.LogMessage(

7336: )
7337: THEN
7338: l_stmt_num := 110.221;
7339: l_msg_tokens.delete;
7340: WSM_log_PVT.LogMessage(
7341: p_module_name => l_module,
7342: p_msg_name => 'WSM_MES_OVERLAP_RES_DATES',
7343: p_msg_appl_name => 'WSM',
7344: p_msg_text => NULL,

Line 7373: WSM_log_PVT.LogMessage(

7369: AND (p_jobop_resource_usages_tbls(l_header_id)(i).start_date IS NOT NULL)
7370: AND (p_jobop_resource_usages_tbls(l_header_id)(i).start_date < p_operation_start_date) THEN
7371: l_stmt_num := 110.231;
7372: l_msg_tokens.delete;
7373: WSM_log_PVT.LogMessage(
7374: p_module_name => l_module,
7375: p_msg_name => 'WSM_MES_START>RESSTARTDATE',
7376: p_msg_appl_name => 'WSM',
7377: p_msg_text => NULL,

Line 7404: WSM_log_PVT.LogMessage(

7400: AND (p_jobop_resource_usages_tbls(l_header_id)(i).end_date IS NOT NULL)
7401: AND (p_jobop_resource_usages_tbls(l_header_id)(i).end_date > p_operation_completion_date) THEN
7402: l_stmt_num := 110.241;
7403: l_msg_tokens.delete;
7404: WSM_log_PVT.LogMessage(
7405: p_module_name => l_module,
7406: p_msg_name => 'WSM_MES_COMPL 7407: p_msg_appl_name => 'WSM',
7408: p_msg_text => NULL,

Line 7430: WSM_log_PVT.logMessage (

7426:
7427: END LOOP;
7428: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
7429: l_msg_tokens.delete;
7430: WSM_log_PVT.logMessage (
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,

Line 7448: WSM_log_PVT.LogMessage(

7444: AND (p_operation_start_date > p_operation_completion_date)
7445: THEN
7446: l_stmt_num := 110.251;
7447: l_msg_tokens.delete;
7448: WSM_log_PVT.LogMessage(
7449: p_module_name => l_module,
7450: p_msg_name => 'WSM_MES_COMPL 7451: p_msg_appl_name => 'WSM',
7452: p_msg_text => NULL,

Line 7468: WSM_log_PVT.logMessage (

7464: END IF;
7465: l_stmt_num := 110.252;
7466: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
7467: l_msg_tokens.delete;
7468: WSM_log_PVT.logMessage (
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 ,

Line 7480: WSM_log_PVT.logMessage (

7476: END IF;
7477: ELSIF (nvl(p_source_code, 'interface') = 'move in oa page') THEN
7478: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
7479: l_msg_tokens.delete;
7480: WSM_log_PVT.logMessage (
7481: p_module_name => l_module ,
7482: p_msg_text => 'Begin MES Move In Validations '||
7483: 'p_jobop_resource_usages_tbls(l_header_id).count '||
7484: p_jobop_resource_usages_tbls(l_header_id).count,

Line 7500: WSM_log_PVT.logMessage (

7496: --FOR j in 1..p_jobop_resource_usages_tbls(l_header_id).last LOOP
7497: FOR i in 1..p_jobop_resource_usages_tbls(l_header_id).last LOOP
7498: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
7499: l_msg_tokens.delete;
7500: WSM_log_PVT.logMessage (
7501: p_module_name => l_module ,
7502: p_msg_text => 'Begin MES Move In Validations '||
7503: 'i '||
7504: i||

Line 7528: WSM_log_PVT.logMessage (

7524: END IF;
7525: IF nvl(p_jobop_resource_usages_tbls(l_header_id)(i).start_date, sysdate) > sysdate THEN
7526: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
7527: l_msg_tokens.delete;
7528: WSM_log_PVT.logMessage (
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 ,

Line 7539: WSM_log_PVT.LogMessage(

7535: );
7536: END IF;
7537: l_stmt_num := 110.191;
7538: l_msg_tokens.delete;
7539: WSM_log_PVT.LogMessage(
7540: p_module_name => l_module,
7541: p_msg_name => 'WSM_MES_START>CURRENTDATE',
7542: p_msg_appl_name => 'WSM',
7543: p_msg_text => NULL,

Line 7567: WSM_log_PVT.LogMessage(

7563: IF nvl(p_jobop_resource_usages_tbls(l_header_id)(i).projected_completion_date, sysdate) <
7564: nvl(p_jobop_resource_usages_tbls(l_header_id)(i).start_date, sysdate) THEN
7565: l_stmt_num := 110.201;
7566: l_msg_tokens.delete;
7567: WSM_log_PVT.LogMessage(
7568: p_module_name => l_module,
7569: p_msg_name => 'WSM_MES_RESPROJCOMPL 7570: p_msg_appl_name => 'WSM',
7571: p_msg_text => NULL,

Line 7593: WSM_log_PVT.LogMessage(

7589:
7590: IF (p_operation_start_date IS NOT NULL) AND (p_jobop_resource_usages_tbls(l_header_id)(i).start_date < p_operation_start_date) THEN
7591: l_stmt_num := 110.231;
7592: l_msg_tokens.delete;
7593: WSM_log_PVT.LogMessage(
7594: p_module_name => l_module,
7595: p_msg_name => 'WSM_MES_START>RESSTARTDATE',
7596: p_msg_appl_name => 'WSM',
7597: p_msg_text => NULL,

Line 7621: WSM_log_PVT.LogMessage(

7617:
7618: IF nvl(p_jobop_resource_usages_tbls(l_header_id)(i).projected_completion_date, sysdate) > p_expected_completion_date THEN
7619: l_stmt_num := 110.241;
7620: l_msg_tokens.delete;
7621: WSM_log_PVT.LogMessage(
7622: p_module_name => l_module,
7623: p_msg_name => 'WSM_MES_PROJCOMPL 7624: p_msg_appl_name => 'WSM',
7625: p_msg_text => NULL,

Line 7652: WSM_log_PVT.LogMessage(

7648: AND (p_operation_start_date > p_expected_completion_date)
7649: THEN
7650: l_stmt_num := 110.251;
7651: l_msg_tokens.delete;
7652: WSM_log_PVT.LogMessage(
7653: p_module_name => l_module,
7654: p_msg_name => 'WSM_MES_PROJCOMPL 7655: p_msg_appl_name => 'WSM',
7656: p_msg_text => NULL,

Line 7675: WSM_log_PVT.logMessage (

7671: END IF;
7672:
7673: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
7674: l_msg_tokens.delete;
7675: WSM_log_PVT.logMessage (
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 ,

Line 7852: WSM_log_PVT.logMessage (

7848: END IF;
7849: -- ST : Serial Support Project ---
7850: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
7851: l_msg_tokens.delete;
7852: WSM_log_PVT.logMessage (
7853: p_module_name => l_module,
7854: p_msg_text => 'B4 IF ((l_transaction_type=2) OR (l_transaction_type = 3))'||
7855: ';l_transaction_type '||
7856: l_transaction_type,

Line 7866: WSM_log_PVT.logMessage (

7862: END IF;
7863:
7864: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
7865: l_msg_tokens.delete;
7866: WSM_log_PVT.logMessage (
7867: p_module_name => l_module,
7868: p_msg_text => 'B4 IF ((l_transaction_type=2) OR (l_transaction_type = 3)) '||
7869: ';l_transaction_type '||
7870: l_transaction_type,

Line 7880: WSM_log_PVT.logMessage (

7876: END IF;
7877:
7878: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
7879: l_msg_tokens.delete;
7880: WSM_log_PVT.logMessage (
7881: p_module_name => l_module,
7882: p_msg_text => 'B4 IF ((l_transaction_type=2) OR (l_transaction_type = 3)) '||
7883: 'l_scrap_qty '||l_scrap_qty||
7884: ' l_available_qty '||l_available_qty||

Line 7921: WSM_log_PVT.logMessage (

7917: END IF;
7918:
7919: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
7920: l_msg_tokens.delete;
7921: WSM_log_PVT.logMessage (
7922: p_module_name => l_module,
7923: p_msg_text => 'In IF ((l_transaction_type=2) OR (l_transaction_type = 3)) '||
7924: 'l_wip_entity_id '||l_wip_entity_id||
7925: ' l_subinventory '||l_subinventory||

Line 7954: WSM_log_PVT.logMessage (

7950: END IF;
7951:
7952: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
7953: l_msg_tokens.delete;
7954: WSM_log_PVT.logMessage (
7955: p_module_name => l_module,
7956: p_msg_text => 'In IF ((l_transaction_type=2) OR (l_transaction_type = 3)) '||
7957: ' x_error_msg '||x_error_msg||
7958: ' l_new_name '||l_new_name,

Line 7995: WSM_log_PVT.logMessage (

7991: END IF;
7992:
7993: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
7994: l_msg_tokens.delete;
7995: WSM_log_PVT.logMessage (
7996: p_module_name => l_module,
7997: p_msg_text =>
7998: 'l_transaction_type '||l_transaction_type||
7999: ' l_converted_scrap_qty '||l_converted_scrap_qty||

Line 8052: WSM_log_PVT.logMessage (

8048: END IF;
8049:
8050: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
8051: l_msg_tokens.delete;
8052: WSM_log_PVT.logMessage (
8053: p_module_name => l_module,
8054: p_msg_text => 'In IF ((l_transaction_type=2) OR (l_transaction_type = 3)) '||
8055: 'l_wip_entity_id '||l_wip_entity_id||
8056: ' l_subinventory '||l_subinventory||

Line 8096: WSM_log_PVT.logMessage (

8092: END IF;
8093:
8094: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
8095: l_msg_tokens.delete;
8096: WSM_log_PVT.logMessage (
8097: p_module_name => l_module,
8098: p_msg_text => 'In IF ((l_transaction_type=2) OR (l_transaction_type = 3)) '||
8099: ' x_error_msg '||x_error_msg||
8100: ' l_new_name '||l_new_name,

Line 8241: WSM_log_PVT.logMessage (

8237: END IF;
8238: END IF;
8239: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
8240: l_msg_tokens.delete;
8241: WSM_log_PVT.logMessage (
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 ,

Line 8472: WSM_log_PVT.logMessage (

8468: l_stmt_num := 210;
8469:
8470: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
8471: l_msg_tokens.delete;
8472: WSM_log_PVT.logMessage (
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 ,

Line 8485: WSM_log_PVT.logMessage (

8481:
8482: IF (l_transaction_quantity > 0) THEN
8483: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
8484: l_msg_tokens.delete;
8485: WSM_log_PVT.logMessage (
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 ,

Line 8896: WSM_log_PVT.logMessage (

8892: IF (nvl(p_source_code, 'interface') IN ('move in oa page', 'move out oa page', 'move to next op oa page',
8893: 'jump oa page', 'undo oa page' )) THEN
8894: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
8895: l_msg_tokens.delete;
8896: WSM_log_PVT.logMessage (
8897: p_module_name => l_module ,
8898: p_msg_text => 'Begin MES processing'||
8899: ';l_converted_scrap_qty '||
8900: l_converted_scrap_qty||

Line 8936: WSM_log_PVT.logMessage ( p_module_name => l_module ,

8932:
8933: BEGIN
8934: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
8935: l_msg_tokens.delete;
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 ,

Line 8961: WSM_log_PVT.logMessage (p_module_name => l_module ,

8957: END IF;
8958:
8959: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
8960: l_msg_tokens.delete;
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 ,

Line 8972: WSM_log_PVT.logMessage ( p_module_name => l_module ,

8968: END IF;
8969: ELSE
8970: IF (G_LOG_LEVEL_ERROR >= l_log_level) THEN
8971: l_msg_tokens.delete;
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 ,

Line 9007: WSM_log_PVT.logMessage (

9003: IF (l_scrap_qty > 0) THEN
9004: l_stmt_num := 251;
9005: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
9006: l_msg_tokens.delete;
9007: WSM_log_PVT.logMessage (
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 ,

Line 9047: WSM_log_PVT.logMessage (

9043: , x_error_msg => x_error_msg);
9044: x_error_msg := l_error_msg;
9045: IF (G_LOG_LEVEL_ERROR >= l_log_level) THEN
9046: l_msg_tokens.delete;
9047: WSM_log_PVT.logMessage (
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,

Line 9061: WSM_log_PVT.logMessage (

9057: ELSIF (l_return_status = 'S') THEN
9058: x_wip_move_api_sucess_msg := fnd_msg_pub.get;
9059: IF (G_LOG_LEVEL_ERROR >= l_log_level) THEN
9060: l_msg_tokens.delete;
9061: WSM_log_PVT.logMessage (
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,

Line 9084: WSM_log_PVT.logMessage (

9080: and (l_fm_intraoperation_step_type <> WIP_CONSTANTS.SCRAP)) THEN
9081: l_stmt_num := 252;
9082: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
9083: l_msg_tokens.delete;
9084: WSM_log_PVT.logMessage (
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 ,

Line 9115: WSM_log_PVT.logMessage (

9111: , x_error_msg => x_error_msg);
9112: x_error_msg := l_error_msg;
9113: IF (G_LOG_LEVEL_ERROR >= l_log_level) THEN
9114: l_msg_tokens.delete;
9115: WSM_log_PVT.logMessage (
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,

Line 9133: WSM_log_PVT.logMessage (

9129: x_wip_move_api_sucess_msg := fnd_msg_pub.get;
9130: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
9131: IF (l_return_status = 'S') THEN
9132: l_msg_tokens.delete;
9133: WSM_log_PVT.logMessage (
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,

Line 9160: WSM_log_PVT.logMessage (

9156: IF (nvl(p_source_code, 'interface') = 'move out oa page') THEN
9157: l_stmt_num := 253.1;
9158: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
9159: l_msg_tokens.delete;
9160: WSM_log_PVT.logMessage (
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 ,

Line 9193: WSM_log_PVT.logMessage (

9189: and uom_code = p_sec_uom_code_tbls(l_header_id)(i);
9190:
9191: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
9192: l_msg_tokens.delete;
9193: WSM_log_PVT.logMessage (
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,

Line 9222: WSM_log_PVT.logMessage (

9218: and REASON_CODE = p_scrap_codes_tbls(l_header_id)(i);
9219:
9220: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
9221: l_msg_tokens.delete;
9222: WSM_log_PVT.logMessage (
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,

Line 9240: WSM_log_PVT.logMessage (

9236: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
9237: FOR i in p_bonus_codes_tbls(l_header_id).first..p_bonus_codes_tbls(l_header_id).last
9238: LOOP
9239: l_msg_tokens.delete;
9240: WSM_log_PVT.logMessage (
9241: p_module_name => l_module,
9242: p_msg_text => 'i '||i||'; bonus code '||
9243: p_bonus_codes_tbls(l_header_id)(i)
9244: ||'; bonus code qty '

Line 9267: WSM_log_PVT.logMessage (

9263: and REASON_CODE = p_bonus_codes_tbls(l_header_id)(i);
9264:
9265: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
9266: l_msg_tokens.delete;
9267: WSM_log_PVT.logMessage (
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,

Line 9288: WSM_log_PVT.logMessage (

9284: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
9285: FOR i in p_jobop_resource_usages_tbls(l_header_id).first..p_jobop_resource_usages_tbls(l_header_id).last
9286: LOOP
9287: l_msg_tokens.delete;
9288: WSM_log_PVT.logMessage (
9289: p_module_name => l_module,
9290: p_msg_text => 'i '||i||'; RESOURCE_ID '||
9291: p_jobop_resource_usages_tbls(l_header_id)(i).RESOURCE_ID
9292: ||'; INSTANCE_ID '

Line 9321: WSM_log_PVT.logMessage (

9317: errors := SQL%BULK_EXCEPTIONS.COUNT;
9318: FOR i IN 1..errors LOOP
9319: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) THEN
9320: l_msg_tokens.delete;
9321: WSM_log_PVT.logMessage (
9322: p_module_name => l_module,
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,

Line 9331: WSM_log_PVT.logMessage (

9327: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED,
9328: p_run_log_level => l_log_level
9329: );
9330:
9331: WSM_log_PVT.logMessage (
9332: p_module_name => l_module,
9333: p_msg_text => 'Error message is ' ||
9334: SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE),
9335: p_stmt_num => l_stmt_num,

Line 9387: WSM_log_PVT.logMessage (

9383: END;
9384:
9385: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
9386: l_msg_tokens.delete;
9387: WSM_log_PVT.logMessage (
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,

Line 9416: WSM_log_PVT.logMessage (

9412: IF (p_jobop_resource_usages_tbls IS NOT NULL) AND p_jobop_resource_usages_tbls.exists(l_header_id)
9413: AND (p_jobop_resource_usages_tbls(l_header_id).count > 0)THEN
9414: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
9415: l_msg_tokens.delete;
9416: WSM_log_PVT.logMessage (
9417: p_module_name => l_module,
9418: p_msg_text => 'Begin inserting resource usage'
9419: ||'; l_wip_entity_id: '
9420: ||l_wip_entity_id

Line 9439: WSM_log_PVT.logMessage (

9435: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
9436: FOR i in p_jobop_resource_usages_tbls(l_header_id).first..p_jobop_resource_usages_tbls(l_header_id).last
9437: LOOP
9438: l_msg_tokens.delete;
9439: WSM_log_PVT.logMessage (
9440: p_module_name => l_module,
9441: p_msg_text => 'i '||i||'; RESOURCE_ID '||
9442: p_jobop_resource_usages_tbls(l_header_id)(i).RESOURCE_ID
9443: ||'; INSTANCE_ID '

Line 9473: WSM_log_PVT.logMessage (

9469: errors := SQL%BULK_EXCEPTIONS.COUNT;
9470: FOR i IN 1..errors LOOP
9471: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) THEN
9472: l_msg_tokens.delete;
9473: WSM_log_PVT.logMessage (
9474: p_module_name => l_module,
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,

Line 9483: WSM_log_PVT.logMessage (

9479: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED,
9480: p_run_log_level => l_log_level
9481: );
9482:
9483: WSM_log_PVT.logMessage (
9484: p_module_name => l_module,
9485: p_msg_text => 'Error message is ' ||
9486: SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE),
9487: p_stmt_num => l_stmt_num,

Line 9530: WSM_log_PVT.logMessage (

9526: END;
9527:
9528: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
9529: l_msg_tokens.delete;
9530: WSM_log_PVT.logMessage (
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,

Line 9803: WSM_log_PVT.logMessage (

9799: l_wltx_resulting_job_tbl(0).SPLIT_HAS_UPDATE_ASSY := 0;
9800:
9801: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
9802: l_msg_tokens.delete;
9803: WSM_log_PVT.logMessage (
9804: p_module_name => l_module,
9805: p_msg_text => 'Populated l_wltx_transactions_rec'
9806: ||'; TRANSACTION_TYPE_ID '
9807: ||l_wltx_transactions_rec.TRANSACTION_TYPE_ID

Line 9848: WSM_log_PVT.logMessage (

9844: l_wltx_secondary_qty_tbl(i).uom_code := p_sec_uom_code_tbls(l_header_id)(i);
9845: l_wltx_secondary_qty_tbl(i).current_quantity := p_sec_move_out_qty_tbls(l_header_id)(i);
9846: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
9847: l_msg_tokens.delete;
9848: WSM_log_PVT.logMessage (
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,

Line 9869: WSM_log_PVT.logMessage (

9865: l_WSM_SERIAL_NUM_TBL(i) := p_jobop_bonus_serials_tbls(l_header_id)(i);
9866: l_WSM_SERIAL_NUM_TBL(i).action_flag := 1;
9867: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
9868: l_msg_tokens.delete;
9869: WSM_log_PVT.logMessage (
9870: p_module_name => l_module,
9871: p_msg_text => 'Populating l_WSM_SERIAL_NUM_TBL '||
9872: ';i '||
9873: i||

Line 9897: WSM_log_PVT.logMessage (

9893: FROM WIP_DISCRETE_JOBS
9894: WHERE wip_entity_id = l_wip_entity_id;
9895:
9896: l_msg_tokens.delete;
9897: WSM_log_PVT.logMessage (
9898: p_module_name => l_module,
9899: p_msg_text => 'B4 Calling WSM_WIP_LOT_TXN_PVT.invoke_txn_API '||
9900: ';wdj l_start_qty '||
9901: l_start_qty,

Line 9933: WSM_log_PVT.logMessage (

9929:
9930: IF (G_LOG_LEVEL_PROCEDURE >= l_log_level) THEN
9931: IF (x_return_status = g_ret_success) THEN
9932: l_msg_tokens.delete;
9933: WSM_log_PVT.logMessage (
9934: p_module_name => l_module,
9935: p_msg_text => 'WSM_WIP_LOT_TXN_PVT.invoke_txn_API returned '||
9936: ';x_return_status '||
9937: x_return_status||

Line 9959: WSM_log_PVT.logMessage (

9955:
9956: IF (G_LOG_LEVEL_PROCEDURE >= l_log_level) THEN
9957: IF (x_return_status = g_ret_success) THEN
9958: l_msg_tokens.delete;
9959: WSM_log_PVT.logMessage (
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,

Line 10075: WSM_log_PVT.logMessage ( p_module_name => l_module ,

10071:
10072: BEGIN
10073: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
10074: l_msg_tokens.delete;
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 ,

Line 10098: WSM_log_PVT.logMessage (p_module_name => l_module ,

10094: END IF;
10095:
10096: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
10097: l_msg_tokens.delete;
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 ,

Line 10109: WSM_log_PVT.logMessage ( p_module_name => l_module ,

10105: END IF;
10106: ELSE
10107: IF (G_LOG_LEVEL_ERROR >= l_log_level) THEN
10108: l_msg_tokens.delete;
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 ,

Line 10146: WSM_log_PVT.logMessage( p_module_name => l_module ,

10142: -- 'jump oa page', 'undo oa page' ) THEN
10143:
10144: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
10145: l_msg_tokens.delete;
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 ,

Line 10180: WSM_log_PVT.logMessage(

10176: WRO.segment1;
10177: BEGIN
10178: FOR rec in C_WRO LOOP
10179: l_msg_tokens.delete;
10180: WSM_log_PVT.logMessage(
10181: p_module_name => l_module ,
10182: p_msg_text => 'B4 calling Wip_movProc_grp.processInterface '||
10183: '; wip_entity_id '||rec.wip_entity_id||
10184: '; operation_seq_num '||rec.operation_seq_num||

Line 10235: WSM_log_PVT.logMessage(

10231: WRO.segment1;
10232: BEGIN
10233: FOR rec in C_WRO LOOP
10234: l_msg_tokens.delete;
10235: WSM_log_PVT.logMessage(
10236: p_module_name => l_module ,
10237: p_msg_text => 'After calling Wip_movProc_grp.processInterface '||
10238: '; wip_entity_id '||rec.wip_entity_id||
10239: '; operation_seq_num '||rec.operation_seq_num||

Line 10289: WSM_log_PVT.logMessage (

10285: l_success := 0;
10286: fnd_file.put_line(fnd_file.log, 'Returned unsuccessfully from Wip_movProc_grp.processInterface');
10287: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) THEN
10288: l_msg_tokens.delete;
10289: WSM_log_PVT.logMessage (
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 ,

Line 10316: WSM_log_PVT.logMessage (

10312: l_success := 0;
10313: ELSE
10314: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
10315: l_msg_tokens.delete;
10316: WSM_log_PVT.logMessage (
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 ,

Line 10334: WSM_log_PVT.logMessage (

10330: END IF;
10331: IF (l_success=0) THEN
10332: IF (G_LOG_LEVEL_ERROR >= l_log_level) THEN
10333: l_msg_tokens.delete;
10334: WSM_log_PVT.logMessage (
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 ,

Line 10370: WSM_log_PVT.logMessage (

10366: END IF; --p_source_code NOT IN ('move in oa page', 'move out oa page', 'move to next op oa page',
10367:
10368: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
10369: l_msg_tokens.delete;
10370: WSM_log_PVT.logMessage (
10371: p_module_name => l_module,
10372: p_msg_text => 'B4 UPDATE WIP_OPERATION_YIELDS woy '
10373: ||';p_group_id '
10374: ||p_group_id

Line 10757: WSM_log_PVT.logMessage (

10753:
10754: l_stmt_num := 290;
10755: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
10756: l_msg_tokens.delete;
10757: WSM_log_PVT.logMessage (
10758: p_module_name => l_module,
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,

Line 10818: WSM_log_PVT.logMessage (

10814: FOR rec IN ac_ar_txns LOOP
10815:
10816: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
10817: l_msg_tokens.delete;
10818: WSM_log_PVT.logMessage (
10819: p_module_name => l_module,
10820: p_msg_text => 'b4 UPDATE wip_entities '||
10821: ' rec.new_wip_entity_name '||rec.new_wip_entity_name||
10822: ' rec.wip_entity_id '||rec.wip_entity_id,

Line 11143: WSM_log_PVT.logMessage (

11139: END IF;
11140:
11141: IF (G_LOG_LEVEL_PROCEDURE >= l_log_level) THEN
11142: l_msg_tokens.delete;
11143: WSM_log_PVT.logMessage (
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 ,

Line 11157: WSM_log_PVT.logMessage (

11153: EXCEPTION
11154: WHEN FND_API.G_EXC_ERROR THEN
11155: IF (x_return_status = g_ret_success) THEN
11156: l_msg_tokens.delete;
11157: WSM_log_PVT.logMessage (
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,

Line 11178: WSM_log_PVT.logMessage (

11174:
11175: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11176: IF (x_return_status = g_ret_success) THEN
11177: l_msg_tokens.delete;
11178: WSM_log_PVT.logMessage (
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,

Line 11232: WSM_log_PVT.handle_others(

11228: WHEN OTHERS THEN
11229: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
11230: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
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

Line 11347: l_msg_tokens WSM_Log_PVT.token_rec_tbl;

11343: x_message VARCHAR2(4000);
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;

Line 11350: l_param_tbl WSM_Log_PVT.param_tbl_type;

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;
11353: x_error_msg VARCHAR2(4000);
11354: BEGIN

Line 11358: WSM_log_PVT.logMessage (

11354: BEGIN
11355: x_return_status := G_RET_SUCCESS;
11356: IF (G_LOG_LEVEL_PROCEDURE >= l_log_level) THEN
11357: l_msg_tokens.delete;
11358: WSM_log_PVT.logMessage (
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 ,

Line 11448: WSM_Log_PVT.logProcParams(p_module_name => l_module ,

11444: l_param_tbl(37).paramValue := p_expected_completion_date;
11445: l_param_tbl(38).paramName := 'p_mtl_txn_hdr_id';
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;

Line 11514: WSM_log_PVT.logMessage (

11510: AND MTI.TRANSACTION_INTERFACE_ID = MTLI.TRANSACTION_INTERFACE_ID;
11511: BEGIN
11512: FOR rec in C_MTLI LOOP
11513: l_msg_tokens.delete;
11514: WSM_log_PVT.logMessage (
11515: p_module_name => l_module ,
11516: p_msg_text => 'B4 call to INV_TXN_MANAGER_GRP.Validate_Transactions: '
11517: ||'p_mtl_txn_hdr_id: '
11518: ||p_mtl_txn_hdr_id

Line 11535: WSM_log_PVT.logMessage (

11531: );
11532: END LOOP;
11533: END;
11534: l_msg_tokens.delete;
11535: WSM_log_PVT.logMessage (
11536: p_module_name => l_module ,
11537: p_msg_text => 'B4 call to INV_TXN_MANAGER_GRP.Validate_Transactions: '
11538: ||'Number of mti rows: '
11539: ||l_mti_rows,

Line 11584: WSM_log_PVT.logMessage (

11580: where transaction_header_id = p_mtl_txn_hdr_id;
11581:
11582: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
11583: l_msg_tokens.delete;
11584: WSM_log_PVT.logMessage (
11585: p_module_name => l_module ,
11586: p_msg_text => 'B4 call to INV_TXN_MANAGER_GRP.Validate_Transactions: '
11587: ||'Number of mti rows: '
11588: ||l_numErrRows

Line 11622: WSM_log_PVT.logMessage (

11618: p_msg_index_out => x_msg_index
11619: );
11620: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
11621: l_msg_tokens.delete;
11622: WSM_log_PVT.logMessage (
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 ,

Line 11638: WSM_log_PVT.logMessage (

11634: END IF;
11635:
11636: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
11637: l_msg_tokens.delete;
11638: WSM_log_PVT.logMessage (
11639: p_module_name => l_module ,
11640: p_msg_text => 'After call to INV_TXN_MANAGER_GRP.Validate_Transactions: '||
11641: 'x_return_status '||x_return_status||
11642: '; no of rows in mmtt '||l_numTempRows,

Line 11652: WSM_log_PVT.logMessage (

11648: END IF;
11649: ELSIF (x_return_status = g_ret_error) THEN
11650: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
11651: l_msg_tokens.delete;
11652: WSM_log_PVT.logMessage (
11653: p_module_name => l_module ,
11654: p_msg_text => 'Error from INV_TXN_MANAGER_GRP.Validate_Transactions '
11655: ||x_msg_data,
11656: p_stmt_num => l_stmt_num ,

Line 11715: WSM_log_PVT.logMessage (

11711: AND msnt.TRANSACTION_TEMP_ID = mmtt.TRANSACTION_TEMP_ID;
11712:
11713: IF (x_return_status = g_ret_success) THEN
11714: l_msg_tokens.delete;
11715: WSM_log_PVT.logMessage (
11716: p_module_name => l_module ,
11717: p_msg_text => 'WSM_Serial_support_GRP.populate_components returned successfully '||
11718: ';l_mmtt_rows '||
11719: l_mmtt_rows||

Line 11871: WSM_log_PVT.logMessage (

11867:
11868: l_stmt_num := 20;
11869: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
11870: l_msg_tokens.delete;
11871: WSM_log_PVT.logMessage (
11872: p_module_name => l_module,
11873: p_msg_text => 'B4 UPDATE wsm_lot_move_txn_interface wlmti '||
11874: ';g_user_id '||
11875: g_user_id||

Line 11925: WSM_log_PVT.logMessage (

11921: );
11922:
11923: IF (x_return_status = g_ret_success) THEN
11924: l_msg_tokens.delete;
11925: WSM_log_PVT.logMessage (
11926: p_module_name => l_module,
11927: p_msg_text => 'WSMPLBMI.MoveTransaction returned '||
11928: ';x_wip_move_api_sucess_msg '||
11929: x_wip_move_api_sucess_msg||

Line 11979: WSM_log_PVT.logMessage (

11975: );
11976:
11977: IF (G_LOG_LEVEL_PROCEDURE >= l_log_level) THEN
11978: l_msg_tokens.delete;
11979: WSM_log_PVT.logMessage (
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 ,

Line 12014: WSM_log_PVT.handle_others( p_module_name => l_module ,

12010:
12011: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
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: );

Line 12091: l_msg_tokens WSM_Log_PVT.token_rec_tbl;

12087: l_serialization_started NUMBER := 0; --bug 5444062 initialize to 0
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

Line 12094: l_param_tbl WSM_Log_PVT.param_tbl_type;

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;
12097: x_return_code NUMBER;
12098: x_error_msg VARCHAR2(4000);

Line 12110: WSM_log_PVT.logMessage (

12106: -- debug_pkg.ins('session_id '||fnd_global.session_id);
12107: x_return_status := g_ret_success;
12108: IF (G_LOG_LEVEL_PROCEDURE >= l_log_level) THEN
12109: l_msg_tokens.delete;
12110: WSM_log_PVT.logMessage (
12111: p_module_name => l_module ,
12112: p_msg_text => 'Begin getMoveOutPageProperties '||
12113: '; p_organization_id '||p_organization_id||
12114: ' ;p_wip_entity_id '||p_wip_entity_id||

Line 12236: WSM_log_PVT.logMessage(

12232: IF g_log_level_error >= l_log_level OR
12233: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
12234: THEN
12235: l_msg_tokens.delete;
12236: WSM_log_PVT.logMessage(
12237: p_module_name => l_module,
12238: p_msg_name => 'WSM_MES_WIP_WSM_MOVE',
12239: p_msg_appl_name => 'WSM',
12240: p_msg_tokens => l_msg_tokens,

Line 12255: WSM_log_PVT.logMessage(

12251: IF g_log_level_error >= l_log_level OR
12252: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
12253: THEN
12254: l_msg_tokens.delete;
12255: WSM_log_PVT.logMessage(
12256: p_module_name => l_module,
12257: p_msg_name => 'WSM_MES_WIP_BOS_MOVE',
12258: p_msg_appl_name => 'WSM',
12259: p_msg_tokens => l_msg_tokens,

Line 12282: WSM_log_PVT.logMessage(

12278: IF g_log_level_error >= l_log_level OR
12279: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
12280: THEN
12281: l_msg_tokens.delete;
12282: WSM_log_PVT.logMessage(
12283: p_module_name => l_module,
12284: p_msg_name => 'WSM_MES_MOVE_OUT_RUN_MAND',
12285: p_msg_appl_name => 'WSM',
12286: p_msg_tokens => l_msg_tokens,

Line 12562: WSM_log_PVT.logMessage (

12558: );
12559:
12560: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
12561: l_msg_tokens.delete;
12562: WSM_log_PVT.logMessage (
12563: p_module_name => l_module ,
12564: p_msg_text => 'End procedure getMoveOutPageProperties '
12565: ||';x_last_operation '
12566: ||x_last_operation

Line 12640: WSM_log_PVT.handle_others(

12636:
12637: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
12638: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
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

Line 12689: l_msg_tokens WSM_Log_PVT.token_rec_tbl;

12685: l_end_routing_operation NUMBER; --bug 5444062
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;

Line 12692: l_param_tbl WSM_Log_PVT.param_tbl_type;

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;
12695: x_error_msg VARCHAR2(4000);
12696: BEGIN

Line 12701: WSM_log_PVT.logMessage (

12697: l_stmt_num := 10;
12698: x_return_status := 'S';
12699: IF (G_LOG_LEVEL_PROCEDURE >= l_log_level) THEN
12700: l_msg_tokens.delete;
12701: WSM_log_PVT.logMessage (
12702: p_module_name => l_module ,
12703: p_msg_text => 'Begin getMoveOutPageProperties: '||
12704: 'p_organization_id '||p_organization_id||
12705: '; p_wip_entity_id '||p_wip_entity_id||

Line 12887: WSM_Log_PVT.logProcParams(

12883: l_param_tbl(10).paramName := 'x_msg_count';
12884: l_param_tbl(10).paramValue := x_msg_count;
12885: l_param_tbl(11).paramName := 'x_msg_data';
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: );

Line 12923: WSM_log_PVT.handle_others(

12919:
12920: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
12921: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
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

Line 12958: l_msg_tokens WSM_Log_PVT.token_rec_tbl;

12954: IS
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

Line 12965: WSM_log_PVT.logMessage (

12961: l_stmt_num NUMBER := 0;
12962: BEGIN
12963: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
12964: l_msg_tokens.delete;
12965: WSM_log_PVT.logMessage (
12966: p_module_name => l_module,
12967: p_msg_text => 'Begin procedure update_costed_qty_compl'
12968: ||';p_transaction_type '
12969: ||p_transaction_type