[Home] [Help]
18: g_program_id number;
19:
20: /*logging variables*/
21:
22: g_log_level_unexpected NUMBER := FND_LOG.LEVEL_UNEXPECTED ;
23: g_log_level_error number := FND_LOG.LEVEL_ERROR ;
24: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;
25: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
26: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;
19:
20: /*logging variables*/
21:
22: g_log_level_unexpected NUMBER := FND_LOG.LEVEL_UNEXPECTED ;
23: g_log_level_error number := FND_LOG.LEVEL_ERROR ;
24: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;
25: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
26: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;
27: g_log_level_statement number := FND_LOG.LEVEL_STATEMENT ;
20: /*logging variables*/
21:
22: g_log_level_unexpected NUMBER := FND_LOG.LEVEL_UNEXPECTED ;
23: g_log_level_error number := FND_LOG.LEVEL_ERROR ;
24: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;
25: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
26: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;
27: g_log_level_statement number := FND_LOG.LEVEL_STATEMENT ;
28:
21:
22: g_log_level_unexpected NUMBER := FND_LOG.LEVEL_UNEXPECTED ;
23: g_log_level_error number := FND_LOG.LEVEL_ERROR ;
24: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;
25: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
26: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;
27: g_log_level_statement number := FND_LOG.LEVEL_STATEMENT ;
28:
29: g_msg_lvl_unexp_error NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ;
22: g_log_level_unexpected NUMBER := FND_LOG.LEVEL_UNEXPECTED ;
23: g_log_level_error number := FND_LOG.LEVEL_ERROR ;
24: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;
25: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
26: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;
27: g_log_level_statement number := FND_LOG.LEVEL_STATEMENT ;
28:
29: g_msg_lvl_unexp_error NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ;
30: g_msg_lvl_error NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR ;
23: g_log_level_error number := FND_LOG.LEVEL_ERROR ;
24: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;
25: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
26: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;
27: g_log_level_statement number := FND_LOG.LEVEL_STATEMENT ;
28:
29: g_msg_lvl_unexp_error NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ;
30: g_msg_lvl_error NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR ;
31: g_msg_lvl_success NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS ;
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';
175: -- Logging variables...
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 ,
252: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
253: p_run_log_level => l_log_level
254: );
255: END IF;
256: RAISE FND_API.G_EXC_ERROR;
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,
266: p_run_log_level => l_log_level
267: );
268: End if;
269: END IF;
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,
279: p_run_log_level => l_log_level
280: );
281: End if;
282:
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,
355: p_run_log_level => l_log_level
356: );
357: End if;
358: ELSE
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 ,
367: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
368: p_run_log_level => l_log_level
369: );
370: END IF;
371: RAISE FND_API.G_EXC_ERROR;
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,
390: p_run_log_level => l_log_level
391: );
392: End if;
393:
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,
413: p_run_log_level => l_log_level
414: );
415: End if;
416:
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 ,
440: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
441: p_run_log_level => l_log_level
442: );
443: END IF;
444: RAISE FND_API.G_EXC_ERROR;
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,
457: p_run_log_level => l_log_level
458: );
459: End if;
460:
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 ,
486: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
487: p_run_log_level => l_log_level
488: );
489: END IF;
490: RAISE FND_API.G_EXC_ERROR;
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,
500: p_run_log_level => l_log_level
501: );
502: End if;
503:
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: );
538: END IF;
539:
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';
580: -- Logging variables...
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,
654: p_run_log_level => l_log_level
655: );
656: End if;
657:
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,
698: p_fnd_log_level => g_log_level_statement,
699: p_run_log_level => l_log_level
700: );
701: End if;
702:
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,
755: p_fnd_log_level => g_log_level_statement,
756: p_run_log_level => l_log_level
757: );
758: End if;
759:
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,
778: p_fnd_log_level => g_log_level_statement,
779: p_run_log_level => l_log_level
780: );
781: End if;
782:
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,
1004: p_fnd_log_level => g_log_level_statement,
1005: p_run_log_level => l_log_level
1006: );
1007: End if;
1008:
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,
1117: p_run_log_level => l_log_level
1118: );
1119: End if;
1120:
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 ,
1143: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
1144: p_run_log_level => l_log_level
1145: );
1146: END IF;
1147:
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,
1269: p_run_log_level => l_log_level
1270: );
1271: End if;
1272:
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,
1297: p_run_log_level => l_log_level
1298: );
1299: End if;
1300:
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,
1326: p_run_log_level => l_log_level
1327: );
1328: End if;
1329:
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,
1369: p_run_log_level => l_log_level
1370: );
1371: End if;
1372:
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 ,
1398: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
1399: p_run_log_level => l_log_level
1400: );
1401: fnd_file.put_line(fnd_file.log,l_error_msg);
1402: END IF;
1488: p_msg_appl_name => 'WSM' ,
1489: p_msg_tokens => l_msg_tokens ,
1490: p_stmt_num => l_stmt_num ,
1491: p_fnd_msg_level => G_MSG_LVL_ERROR ,
1492: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
1493: p_run_log_level => l_log_level
1494: );
1495: END IF;
1496: END IF;
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,
1522: p_run_log_level => l_log_level
1523: );
1524: End if;
1525:
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 ,
1541: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
1542: p_run_log_level => l_log_level
1543: );
1544: END IF;
1545: l_program_status := nvl(l_program_status,-1);
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,
1582: p_run_log_level => l_log_level
1583: );
1584: END IF;
1585: END IF ;
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,
1650: p_run_log_level => l_log_level
1651: );
1652: End if;
1653:
1660: p_msg_appl_name => 'WSM' ,
1661: p_msg_tokens => l_msg_tokens ,
1662: p_stmt_num => l_stmt_num ,
1663: p_fnd_msg_level => G_MSG_LVL_ERROR ,
1664: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
1665: p_run_log_level => l_log_level
1666: );
1667: END IF;
1668:
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,
1688: p_run_log_level => l_log_level
1689: );
1690: End if;
1691:
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,
1709: p_run_log_level => l_log_level
1710: );
1711: End if;
1712:
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,
1727: p_run_log_level => l_log_level
1728: );
1729: End if;
1730:
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,
1744: p_run_log_level => l_log_level
1745: );
1746: End if;
1747: l_stmt_num := 155;
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,
1762: p_run_log_level => l_log_level
1763: );
1764: End if;
1765:
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 ,
1788: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
1789: p_run_log_level => l_log_level
1790: );
1791: fnd_file.put_line(FND_FILE.LOG,l_error_msg);
1792: ELSE
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: );
1813: END IF;
1814: