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 8894: WSM_log_PVT.logMessage (

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

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

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

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

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

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

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

Line 9005: WSM_log_PVT.logMessage (

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

Line 9045: WSM_log_PVT.logMessage (

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

Line 9059: WSM_log_PVT.logMessage (

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

Line 9082: WSM_log_PVT.logMessage (

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

Line 9113: WSM_log_PVT.logMessage (

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

Line 9131: WSM_log_PVT.logMessage (

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

Line 9158: WSM_log_PVT.logMessage (

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

Line 9191: WSM_log_PVT.logMessage (

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

Line 9220: WSM_log_PVT.logMessage (

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

Line 9238: WSM_log_PVT.logMessage (

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

Line 9265: WSM_log_PVT.logMessage (

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

Line 9286: WSM_log_PVT.logMessage (

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

Line 9319: WSM_log_PVT.logMessage (

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

Line 9329: WSM_log_PVT.logMessage (

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

Line 9385: WSM_log_PVT.logMessage (

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

Line 9414: WSM_log_PVT.logMessage (

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

Line 9437: WSM_log_PVT.logMessage (

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

Line 9471: WSM_log_PVT.logMessage (

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

Line 9481: WSM_log_PVT.logMessage (

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

Line 9528: WSM_log_PVT.logMessage (

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

Line 9801: WSM_log_PVT.logMessage (

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

Line 9846: WSM_log_PVT.logMessage (

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

Line 9867: WSM_log_PVT.logMessage (

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

Line 9895: WSM_log_PVT.logMessage (

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

Line 9931: WSM_log_PVT.logMessage (

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

Line 9957: WSM_log_PVT.logMessage (

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

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

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

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

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

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

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

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

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

Line 10178: WSM_log_PVT.logMessage(

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

Line 10233: WSM_log_PVT.logMessage(

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

Line 10287: WSM_log_PVT.logMessage (

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

Line 10314: WSM_log_PVT.logMessage (

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

Line 10332: WSM_log_PVT.logMessage (

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

Line 10368: WSM_log_PVT.logMessage (

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

Line 10755: WSM_log_PVT.logMessage (

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

Line 10816: WSM_log_PVT.logMessage (

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

Line 11141: WSM_log_PVT.logMessage (

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

Line 11155: WSM_log_PVT.logMessage (

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

Line 11176: WSM_log_PVT.logMessage (

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

Line 11230: WSM_log_PVT.handle_others(

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

Line 11345: l_msg_tokens WSM_Log_PVT.token_rec_tbl;

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

Line 11348: l_param_tbl WSM_Log_PVT.param_tbl_type;

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

Line 11356: WSM_log_PVT.logMessage (

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

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

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

Line 11512: WSM_log_PVT.logMessage (

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

Line 11533: WSM_log_PVT.logMessage (

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

Line 11582: WSM_log_PVT.logMessage (

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

Line 11620: WSM_log_PVT.logMessage (

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

Line 11636: WSM_log_PVT.logMessage (

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

Line 11650: WSM_log_PVT.logMessage (

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

Line 11713: WSM_log_PVT.logMessage (

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

Line 11869: WSM_log_PVT.logMessage (

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

Line 11923: WSM_log_PVT.logMessage (

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

Line 11977: WSM_log_PVT.logMessage (

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

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

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

Line 12089: l_msg_tokens WSM_Log_PVT.token_rec_tbl;

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

Line 12092: l_param_tbl WSM_Log_PVT.param_tbl_type;

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

Line 12108: WSM_log_PVT.logMessage (

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

Line 12234: WSM_log_PVT.logMessage(

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

Line 12253: WSM_log_PVT.logMessage(

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

Line 12280: WSM_log_PVT.logMessage(

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

Line 12560: WSM_log_PVT.logMessage (

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

Line 12638: WSM_log_PVT.handle_others(

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

Line 12687: l_msg_tokens WSM_Log_PVT.token_rec_tbl;

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

Line 12690: l_param_tbl WSM_Log_PVT.param_tbl_type;

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

Line 12699: WSM_log_PVT.logMessage (

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

Line 12885: WSM_Log_PVT.logProcParams(

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

Line 12921: WSM_log_PVT.handle_others(

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

Line 12956: l_msg_tokens WSM_Log_PVT.token_rec_tbl;

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

Line 12963: WSM_log_PVT.logMessage (

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