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.WSMPLOAD dependencies on WSM_LOG_PVT

Line 170: l_msg_tokens WSM_Log_PVT.token_rec_tbl;

166: l_phantom_exists NUMBER;
167: --OPTII-PERF Changes
168:
169: -- Logging variables.....
170: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
171: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
172:
173: l_stmt_num NUMBER;
174: l_module VARCHAR2(100) := 'wsm.plsql.WSMPLOAD.algo_create_copies';

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

243: IF (l_error_code <> 0) THEN
244: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
245:
246: l_msg_tokens.delete;
247: WSM_log_PVT.logMessage(p_module_name => l_module ,
248: p_msg_text => 'WSM_JobCopies_PVT.Create_RepJobCopies returned error:'||l_error_msg,
249: p_msg_tokens => l_msg_tokens,
250: p_stmt_num => l_stmt_num ,
251: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

257:
258: ELSE
259: if( g_log_level_statement >= l_log_level ) then
260: l_msg_tokens.delete;
261: WSM_log_PVT.logMessage(p_module_name => l_module ,
262: p_msg_text => 'WSM_JobCopies_PVT.Create_RepJobCopies returned success',
263: p_stmt_num => l_stmt_num ,
264: p_msg_tokens => l_msg_tokens,
265: p_fnd_log_level => g_log_level_statement,

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

270:
271: ELSIF (c_algorithm_rec.internal_copy_type = 2) THEN
272: if( g_log_level_statement >= l_log_level ) then
273: l_msg_tokens.delete;
274: WSM_log_PVT.logMessage(p_module_name => l_module ,
275: p_msg_text => 'Calling WSM_JobCopies_PVT.Create_JobCopies',
276: p_stmt_num => l_stmt_num ,
277: p_msg_tokens => l_msg_tokens,
278: p_fnd_log_level => g_log_level_statement,

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

346: (l_error_code = -1) -- Warning
347: THEN
348: if( g_log_level_statement >= l_log_level ) then
349: l_msg_tokens.delete;
350: WSM_log_PVT.logMessage(p_module_name => l_module ,
351: p_msg_text => 'WSM_JobCopies_PVT.Create_JobCopies returned success',
352: p_stmt_num => l_stmt_num ,
353: p_msg_tokens => l_msg_tokens,
354: p_fnd_log_level => g_log_level_statement,

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

358: ELSE
359: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
360:
361: l_msg_tokens.delete;
362: WSM_log_PVT.logMessage(p_module_name => l_module ,
363: p_msg_text => 'WSM_JobCopies_PVT.Create_JobCopies returned error:'||l_error_msg,
364: p_stmt_num => l_stmt_num ,
365: p_msg_tokens => l_msg_tokens,
366: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

381: WHERE wip_entity_id = c_algorithm_rec.wip_entity_id;
382:
383: if( g_log_level_statement >= l_log_level ) then
384: l_msg_tokens.delete;
385: WSM_log_PVT.logMessage(p_module_name => l_module ,
386: p_msg_text => 'Reset internal_copy_type, copy_parent_wip_entity_id for we_id='||c_algorithm_rec.wip_entity_id,
387: p_stmt_num => l_stmt_num ,
388: p_msg_tokens => l_msg_tokens,
389: p_fnd_log_level => g_log_level_statement,

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

404: EXIT WHEN C_INF_SCH_PAR_REP_JOBS%NOTFOUND;
405:
406: if( g_log_level_statement >= l_log_level ) then
407: l_msg_tokens.delete;
408: WSM_log_PVT.logMessage(p_module_name => l_module ,
409: p_msg_text => 'Calling WSMPJUPD.GET_JOB_CURR_OP_INFO',
410: p_stmt_num => l_stmt_num ,
411: p_msg_tokens => l_msg_tokens,
412: p_fnd_log_level => g_log_level_statement,

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

431: IF (l_error_code <> 0) THEN
432: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
433:
434: l_msg_tokens.delete;
435: WSM_log_PVT.logMessage(p_module_name => l_module ,
436: p_msg_text => 'WSMPJUPD.GET_JOB_CURR_OP_INFO returned error:'||l_error_code,
437: p_stmt_num => l_stmt_num ,
438: p_msg_tokens => l_msg_tokens,
439: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

448: l_stmt_num := 47.7;
449:
450: if( g_log_level_statement >= l_log_level ) then
451: l_msg_tokens.delete;
452: WSM_log_PVT.logMessage(p_module_name => l_module ,
453: p_msg_text => 'Calling WSM_infinite_scheduler_PVT.schedule',
454: p_stmt_num => l_stmt_num ,
455: p_msg_tokens => l_msg_tokens,
456: p_fnd_log_level => g_log_level_statement,

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

477: -- x_error_code := -1;
478: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
479:
480: l_msg_tokens.delete;
481: WSM_log_PVT.logMessage(p_module_name => l_module ,
482: p_msg_text => 'WSM_infinite_scheduler_PVT.schedule returned error:'||l_error_msg,
483: p_stmt_num => l_stmt_num ,
484: p_msg_tokens => l_msg_tokens,
485: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

491: ELSE
492: -- x_error_code := 0;
493: if( g_log_level_statement >= l_log_level ) then
494: l_msg_tokens.delete;
495: WSM_log_PVT.logMessage(p_module_name => l_module ,
496: p_msg_text => 'WSM_infinite_scheduler_PVT.schedule returned success',
497: p_stmt_num => l_stmt_num ,
498: p_msg_tokens => l_msg_tokens,
499: p_fnd_log_level => g_log_level_statement,

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

529:
530: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
531: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
532: THEN
533: WSM_log_PVT.handle_others( p_module_name => l_module ,
534: p_stmt_num => l_stmt_num ,
535: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
536: p_run_log_level => l_log_level
537: );

Line 575: l_msg_tokens WSM_Log_PVT.token_rec_tbl;

571: l_error_msg VARCHAR2(2000);
572: l_error_txn number := 0;
573:
574: -- Logging variables.....
575: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
576: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
577:
578: l_stmt_num NUMBER;
579: l_module VARCHAR2(100) := 'wsm.plsql.WSMPLOAD.load';

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

645:
646: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Entered LOAD procedure'); --Remove
647: if( g_log_level_statement >= l_log_level ) then
648: l_msg_tokens.delete;
649: WSM_log_PVT.logMessage(p_module_name => l_module ,
650: p_msg_text => 'Entered LOAD procedure' ,
651: p_stmt_num => l_stmt_num ,
652: p_msg_tokens => l_msg_tokens,
653: p_fnd_log_level => g_log_level_statement,

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

689:
690:
691: if( g_log_level_statement >= l_log_level ) then
692: l_msg_tokens.delete;
693: WSM_log_PVT.logMessage(p_module_name => l_module ,
694: p_msg_text => 'The no of records in WSMTI: -> '
695: ||l_wsm_wtxn_hdr_tbl.count ,
696: p_stmt_num => l_stmt_num ,
697: p_msg_tokens => l_msg_tokens,

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

746: order by wsmti.transaction_date,wsmti.header_id;
747:
748: if( g_log_level_statement >= l_log_level ) then
749: l_msg_tokens.delete;
750: WSM_log_PVT.logMessage(p_module_name => l_module ,
751: p_msg_text => 'The no of starting records : -> '
752: ||l_wsm_wtxn_sj_tbl.count ,
753: p_stmt_num => l_stmt_num ,
754: p_msg_tokens => l_msg_tokens,

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

769: order by wsmti.transaction_date,wsmti.header_id;
770:
771: if( g_log_level_statement >= l_log_level ) then
772: l_msg_tokens.delete;
773: WSM_log_PVT.logMessage(p_module_name => l_module ,
774: p_msg_text => 'The no of resulting records : -> '
775: ||l_wsm_wtxn_rj_tbl.count ,
776: p_stmt_num => l_stmt_num ,
777: p_msg_tokens => l_msg_tokens,

Line 874: -- WSM_log_Pvt.PopulateIntfInfo (l_txn_header_rec.transaction_id, l_wsm_wtxn_hdr_tbl(l_txn_counter).header_id);

870: --populate the txn details for logging--
871:
872: -- bug 5557667 header_id and transaction_id were being passed in incorrect order. changed the following line
873:
874: -- WSM_log_Pvt.PopulateIntfInfo (l_txn_header_rec.transaction_id, l_wsm_wtxn_hdr_tbl(l_txn_counter).header_id);
875: WSM_log_Pvt.PopulateIntfInfo (l_wsm_wtxn_hdr_tbl(l_txn_counter).header_id,l_txn_header_rec.transaction_id);
876:
877: -- bug 5557667 end changes
878:

Line 875: WSM_log_Pvt.PopulateIntfInfo (l_wsm_wtxn_hdr_tbl(l_txn_counter).header_id,l_txn_header_rec.transaction_id);

871:
872: -- bug 5557667 header_id and transaction_id were being passed in incorrect order. changed the following line
873:
874: -- WSM_log_Pvt.PopulateIntfInfo (l_txn_header_rec.transaction_id, l_wsm_wtxn_hdr_tbl(l_txn_counter).header_id);
875: WSM_log_Pvt.PopulateIntfInfo (l_wsm_wtxn_hdr_tbl(l_txn_counter).header_id,l_txn_header_rec.transaction_id);
876:
877: -- bug 5557667 end changes
878:
879: l_sj_api_counter := 1;

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

995:
996:
997: if( g_log_level_statement >= l_log_level ) then
998: l_msg_tokens.delete;
999: WSM_log_PVT.logMessage(p_module_name => l_module ,
1000: p_msg_text => 'The no of resulting records for this Txn : -> '
1001: ||l_resulting_jobs_tbl.count ,
1002: p_stmt_num => l_stmt_num ,
1003: p_msg_tokens => l_msg_tokens,

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

1108: THEN
1109:
1110: if( g_log_level_statement >= l_log_level ) then
1111: l_msg_tokens.delete;
1112: WSM_log_PVT.logMessage(p_module_name => l_module ,
1113: p_msg_text => 'Invoking WSM_Serial_Support_PVT.WLT_serial_intf_proc',
1114: p_stmt_num => l_stmt_num ,
1115: p_msg_tokens => l_msg_tokens,
1116: p_fnd_log_level => g_log_level_statement,

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

1134: -- error out..
1135: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
1136:
1137: l_msg_tokens.delete;
1138: WSM_log_PVT.logMessage(p_module_name => l_module ,
1139: p_msg_text => 'WSM_Serial_Support_PVT.WLT_serial_intf_proc Failed',
1140: p_stmt_num => l_stmt_num ,
1141: p_msg_tokens => l_msg_tokens,
1142: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

1260: -- ST : Fix for bug 5233265 --
1261:
1262: if( g_log_level_statement >= l_log_level ) then
1263: l_msg_tokens.delete;
1264: WSM_log_PVT.logMessage(p_module_name => l_module ,
1265: p_msg_text => 'Calling WSM_WIP_LOT_TXN_PVT.invoke_txn_API',
1266: p_stmt_num => l_stmt_num ,
1267: p_msg_tokens => l_msg_tokens,
1268: p_fnd_log_level => g_log_level_statement,

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

1288: );
1289:
1290: if( g_log_level_statement >= l_log_level ) then
1291: l_msg_tokens.delete;
1292: WSM_log_PVT.logMessage(p_module_name => l_module ,
1293: p_msg_text => 'WSM_WIP_LOT_TXN_PVT.invoke_txn_API returned :'||l_return_status,
1294: p_stmt_num => l_stmt_num ,
1295: p_msg_tokens => l_msg_tokens,
1296: p_fnd_log_level => g_log_level_statement,

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

1317: if l_return_status = fnd_api.g_ret_sts_success then
1318:
1319: if( g_log_level_statement >= l_log_level ) then
1320: l_msg_tokens.delete;
1321: WSM_log_PVT.logMessage(p_module_name => l_module ,
1322: p_msg_text => 'WSM_WIP_LOT_TXN_PVT.invoke_txn_API returned success',
1323: p_stmt_num => l_stmt_num ,
1324: p_msg_tokens => l_msg_tokens,
1325: p_fnd_log_level => g_log_level_statement,

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

1360: -- Call lot attr
1361:
1362: if( g_log_level_statement >= l_log_level ) then
1363: l_msg_tokens.delete;
1364: WSM_log_PVT.logMessage(p_module_name => l_module ,
1365: p_msg_text => 'Calling WSM_LotAttr_PVT.create_update_lotattr',
1366: p_stmt_num => l_stmt_num ,
1367: p_msg_tokens => l_msg_tokens,
1368: p_fnd_log_level => g_log_level_statement,

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

1389: -- error out..
1390: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
1391:
1392: l_msg_tokens.delete;
1393: WSM_log_PVT.logMessage(p_module_name => l_module ,
1394: p_msg_text => l_error_msg ,
1395: p_stmt_num => l_stmt_num ,
1396: p_msg_tokens => l_msg_tokens ,
1397: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

1482: l_msg_tokens.delete;
1483: l_msg_tokens(1).TokenName := 'TABLE';
1484: l_msg_tokens(1).TokenValue := 'WSM_STARTING_JOBS_INTERFACE (header_id = ' || l_wsm_wtxn_hdr_tbl(l_txn_counter).header_id
1485: || ' )';
1486: WSM_log_PVT.logMessage(p_module_name => l_module ,
1487: p_msg_name => 'WSM_PENDING_TXN' ,
1488: p_msg_appl_name => 'WSM' ,
1489: p_msg_tokens => l_msg_tokens ,
1490: p_stmt_num => l_stmt_num ,

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

1513: l_stmt_num := 125;
1514:
1515: if( g_log_level_statement >= l_log_level ) then
1516: l_msg_tokens.delete;
1517: WSM_log_PVT.logMessage(p_module_name => l_module ,
1518: p_msg_text => 'Calling algo_create_copies',
1519: p_stmt_num => l_stmt_num ,
1520: p_msg_tokens => l_msg_tokens,
1521: p_fnd_log_level => g_log_level_statement,

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

1532: if l_return_code <> 0 then
1533: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
1534:
1535: l_msg_tokens.delete;
1536: WSM_log_PVT.logMessage(p_module_name => l_module ,
1537: p_msg_text => l_error_msg ,
1538: p_stmt_num => l_stmt_num ,
1539: p_msg_tokens => l_msg_tokens ,
1540: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

1573: ) ;
1574:
1575: if( g_log_level_statement >= l_log_level ) then
1576: l_msg_tokens.delete;
1577: WSM_log_PVT.logMessage(p_module_name => l_module ,
1578: p_msg_text => 'Concurrent Request for Requisition Import Submitted',
1579: p_stmt_num => l_stmt_num ,
1580: p_msg_tokens => l_msg_tokens,
1581: p_fnd_log_level => g_log_level_statement,

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

1641: -- end the loop here....
1642:
1643: if( g_log_level_statement >= l_log_level ) then
1644: l_msg_tokens.delete;
1645: WSM_log_PVT.logMessage(p_module_name => l_module ,
1646: p_msg_text => 'Total Transactions Processed : ' || l_txn_processed,
1647: p_stmt_num => l_stmt_num ,
1648: p_msg_tokens => l_msg_tokens,
1649: p_fnd_log_level => g_log_level_statement,

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

1654: -- ST : Fix for bug 4859986
1655: -- log a message for no pending rows (at error level so that it appears in the log..)
1656: IF (l_txn_processed = 0 AND (g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR))) THEN
1657: l_msg_tokens.delete;
1658: WSM_log_PVT.logMessage( p_module_name => l_module ,
1659: p_msg_name => 'WSM_NO_PEND_TXNS' ,
1660: p_msg_appl_name => 'WSM' ,
1661: p_msg_tokens => l_msg_tokens ,
1662: p_stmt_num => l_stmt_num ,

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

1679: SYSDATE - l_del_int_prof_value));
1680:
1681: if( g_log_level_statement >= l_log_level ) then
1682: l_msg_tokens.delete;
1683: WSM_log_PVT.logMessage(p_module_name => l_module ,
1684: p_msg_text => 'Deleted : ' || SQL%ROWCOUNT || ' rows from wsm_starting_jobs_interface',
1685: p_stmt_num => l_stmt_num ,
1686: p_msg_tokens => l_msg_tokens,
1687: p_fnd_log_level => g_log_level_statement,

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

1700:
1701:
1702: if( g_log_level_statement >= l_log_level ) then
1703: l_msg_tokens.delete;
1704: WSM_log_PVT.logMessage(p_module_name => l_module ,
1705: p_msg_text => 'Deleted : ' || SQL%ROWCOUNT || ' rows from wsm_resulting_jobs_interface',
1706: p_stmt_num => l_stmt_num ,
1707: p_msg_tokens => l_msg_tokens,
1708: p_fnd_log_level => g_log_level_statement,

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

1718:
1719: -- delete from wsm_split_merge_txn_interface
1720: if( g_log_level_statement >= l_log_level ) then
1721: l_msg_tokens.delete;
1722: WSM_log_PVT.logMessage(p_module_name => l_module ,
1723: p_msg_text => 'Deleted : ' || SQL%ROWCOUNT || ' rows from wsm_split_merge_txn_interface',
1724: p_stmt_num => l_stmt_num ,
1725: p_msg_tokens => l_msg_tokens,
1726: p_fnd_log_level => g_log_level_statement,

Line 1732: WSM_log_Pvt.writetoWIE;

1728: );
1729: End if;
1730:
1731: --log the errors/warnings to WIE table--
1732: WSM_log_Pvt.writetoWIE;
1733:
1734: if l_program_status is null then -- no errors...
1735: -- gotto to set the concurrent program status...
1736:

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

1735: -- gotto to set the concurrent program status...
1736:
1737: if( g_log_level_statement >= l_log_level ) then
1738: l_msg_tokens.delete;
1739: WSM_log_PVT.logMessage(p_module_name => l_module ,
1740: p_msg_text => 'Procedure Load suuccessful',
1741: p_stmt_num => l_stmt_num ,
1742: p_msg_tokens => l_msg_tokens,
1743: p_fnd_log_level => g_log_level_statement,

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

1753: retcode := -1;
1754:
1755: if( g_log_level_statement >= l_log_level ) then
1756: l_msg_tokens.delete;
1757: WSM_log_PVT.logMessage(p_module_name => l_module ,
1758: p_msg_text => 'Procedure Load unsuccessful: Error :',
1759: p_stmt_num => l_stmt_num ,
1760: p_msg_tokens => l_msg_tokens,
1761: p_fnd_log_level => g_log_level_statement,

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

1779: fnd_message.set_token('FLD_NAME','Wip Entity Name/Wip Entity ID/organization id');
1780: l_error_msg := fnd_message.get;
1781:
1782: l_msg_tokens.delete;
1783: WSM_log_PVT.logMessage(p_module_name => l_module ,
1784: p_msg_text => l_error_msg ,
1785: p_msg_tokens => l_msg_tokens ,
1786: p_stmt_num => l_stmt_num ,
1787: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

1804: WHEN OTHERS THEN
1805: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
1806: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
1807: THEN
1808: WSM_log_PVT.handle_others( p_module_name => l_module ,
1809: p_stmt_num => l_stmt_num ,
1810: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
1811: p_run_log_level => l_log_level
1812: );