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

Line 100: l_msg_tokens WSM_Log_PVT.token_rec_tbl;

96:
97: l_counter number;
98: l_index number;
99: -- Logging variables.....
100: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
101: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
102:
103: l_stmt_num NUMBER;
104: l_module VARCHAR2(100) := 'wsm.plsql.WSMPJUPD.process_mes_info';

Line 105: l_param_tbl WSM_Log_PVT.param_tbl_type;

101: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
102:
103: l_stmt_num NUMBER;
104: l_module VARCHAR2(100) := 'wsm.plsql.WSMPJUPD.process_mes_info';
105: l_param_tbl WSM_Log_PVT.param_tbl_type;
106:
107: BEGIN
108:
109: savepoint start_secondary_quantities;

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

118:
119: l_param_tbl(2).paramName := 'p_rep_job_index';
120: l_param_tbl(2).paramValue := p_rep_job_index;
121:
122: WSM_Log_PVT.logProcParams(p_module_name => l_module ,
123: p_param_tbl => l_param_tbl,
124: p_fnd_log_level => l_log_level
125: );
126: END IF;

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

135: END IF;
136:
137: if( g_log_level_statement >= l_log_level ) then
138: l_msg_tokens.delete;
139: WSM_log_PVT.logMessage(p_module_name => l_module ,
140: p_msg_text => 'l_sj_rj_wip_entity_id ' || l_sj_rj_wip_entity_id ||
141: 'l_sj_rj_wip_entity_name ' || l_sj_rj_wip_entity_name ||
142: 'l_sj_rj_inventory_item_id ' || l_sj_rj_inventory_item_id ,
143: p_stmt_num => l_stmt_num ,

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

173: and currently_active= 1;
174:
175: if( g_log_level_statement >= l_log_level ) then
176: l_msg_tokens.delete;
177: WSM_log_PVT.logMessage(p_module_name => l_module ,
178: p_msg_text => 'Current Secondary quantitites Count : ' || l_job_qty_tbl.count,
179: p_stmt_num => l_stmt_num ,
180: p_msg_tokens => l_msg_tokens,
181: p_fnd_log_level => g_log_level_statement,

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

214: values l_wsm_sj_sec_qty_tbl(i);
215: end if;
216: if( g_log_level_statement >= l_log_level ) then
217: l_msg_tokens.delete;
218: WSM_log_PVT.logMessage(p_module_name => l_module ,
219: p_msg_text => 'Population of Histroy information for Starting Jobs done.',
220: p_stmt_num => l_stmt_num ,
221: p_msg_tokens => l_msg_tokens,
222: p_fnd_log_level => g_log_level_statement,

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

340: where inventory_item_id =l_sj_rj_inventory_item_id);
341:
342: if( g_log_level_statement >= l_log_level ) then
343: l_msg_tokens.delete;
344: WSM_log_PVT.logMessage(p_module_name => l_module ,
345: p_msg_text => 'Updated ' || SQL%ROWCOUNT || ' rows to be inactive in job secondary quantities',
346: p_stmt_num => l_stmt_num ,
347: p_msg_tokens => l_msg_tokens,
348: p_fnd_log_level => g_log_level_statement,

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

364: AND currently_active = 2; --Bugfix 4765660, left out of fix for 5046332
365:
366: if( g_log_level_statement >= l_log_level ) then
367: l_msg_tokens.delete;
368: WSM_log_PVT.logMessage(p_module_name => l_module ,
369: p_msg_text => 'Updated ' || SQL%ROWCOUNT || ' rows to be active in job secondary quantities',
370: p_stmt_num => l_stmt_num ,
371: p_msg_tokens => l_msg_tokens,
372: p_fnd_log_level => g_log_level_statement,

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

416: );
417:
418: IF( g_log_level_statement >= l_log_level ) THEN
419: l_msg_tokens.delete;
420: WSM_log_PVT.logMessage(p_module_name => l_module ,
421: p_msg_text => 'Inserted ' || SQL%ROWCOUNT || ' new rows in in job secondary quantities tables',
422: p_stmt_num => l_stmt_num ,
423: p_msg_tokens => l_msg_tokens,
424: p_fnd_log_level => g_log_level_statement,

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

453:
454: l_stmt_num := 90;
455: if( g_log_level_statement >= l_log_level ) then
456: l_msg_tokens.delete;
457: WSM_log_PVT.logMessage(p_module_name => l_module ,
458: p_msg_text => 'Processing for Split Merge, Update Assembly Done',
459: p_stmt_num => l_stmt_num ,
460: p_msg_tokens => l_msg_tokens,
461: p_fnd_log_level => g_log_level_statement,

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

488: and wip_entity_id = p_wltx_starting_jobs_tbl(p_rep_job_index).wip_entity_id;
489:
490: if( g_log_level_statement >= l_log_level ) then
491: l_msg_tokens.delete;
492: WSM_log_PVT.logMessage(p_module_name => l_module ,
493: p_msg_text => 'Starting Job Reason codes count : ' || l_sj_op_reason_codes_tbl.count,
494: p_stmt_num => l_stmt_num ,
495: p_msg_tokens => l_msg_tokens,
496: p_fnd_log_level => g_log_level_statement,

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

539: -- Bulk insert now...
540: IF l_rj_op_reason_codes_tbl.count > 0 then
541: if( g_log_level_statement >= l_log_level ) then
542: l_msg_tokens.delete;
543: WSM_log_PVT.logMessage(p_module_name => l_module ,
544: p_msg_text => 'Resulting Jobs Reason codes count : ' || l_rj_op_reason_codes_tbl.count,
545: p_stmt_num => l_stmt_num ,
546: p_msg_tokens => l_msg_tokens,
547: p_fnd_log_level => g_log_level_statement,

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

555: END IF;
556:
557: if( g_log_level_statement >= l_log_level ) then
558: l_msg_tokens.delete;
559: WSM_log_PVT.logMessage(p_module_name => l_module ,
560: p_msg_text => 'Processing Reason codes for non-SpUA and Merge resulting Jobs done',
561: p_stmt_num => l_stmt_num ,
562: p_msg_tokens => l_msg_tokens,
563: p_fnd_log_level => g_log_level_statement,

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

611: );
612:
613: if( g_log_level_statement >= l_log_level ) then
614: l_msg_tokens.delete;
615: WSM_log_PVT.logMessage(p_module_name => l_module ,
616: p_msg_text => 'Inserted ' || SQL%ROWCOUNT || ' new rows in in job secondary quantities tables for bonus',
617: p_stmt_num => l_stmt_num ,
618: p_msg_tokens => l_msg_tokens,
619: p_fnd_log_level => g_log_level_statement,

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

649: end if;
650:
651: if( g_log_level_statement >= l_log_level ) then
652: l_msg_tokens.delete;
653: WSM_log_PVT.logMessage(p_module_name => l_module ,
654: p_msg_text => 'Processing Secondary Qty and Reason codes for SpUA Split and Upd Assy and Upd Rtg Jobs done',
655: p_stmt_num => l_stmt_num ,
656: p_msg_tokens => l_msg_tokens,
657: p_fnd_log_level => g_log_level_statement,

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

705: end if;
706:
707: if( g_log_level_statement >= l_log_level ) then
708: l_msg_tokens.delete;
709: WSM_log_PVT.logMessage(p_module_name => l_module ,
710: p_msg_text => 'History Information for Resulting Jobs Done',
711: p_stmt_num => l_stmt_num ,
712: p_msg_tokens => l_msg_tokens,
713: p_fnd_log_level => g_log_level_statement,

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

740:
741: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
742: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
743: THEN
744: WSM_log_PVT.handle_others( p_module_name => l_module ,
745: p_stmt_num => l_stmt_num ,
746: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
747: p_run_log_level => l_log_level
748: );

Line 776: l_msg_tokens WSM_Log_PVT.token_rec_tbl;

772: g_code_type_bonus CONSTANT NUMBER := 1 ;
773: g_code_type_scrap CONSTANT NUMBER := 2 ;
774:
775: -- Logging variables.....
776: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
777: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
778: l_stmt_num NUMBER;
779: l_module VARCHAR2(100) := 'wsm.plsql.WSMPJUPD.copy_wsm_op_reason_codes';
780:

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

922: x_return_status := G_RET_UNEXPECTED;
923: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
924: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
925: THEN
926: WSM_log_PVT.handle_others( p_module_name => l_module ,
927: p_stmt_num => l_stmt_num ,
928: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
929: p_run_log_level => l_log_level
930: );

Line 957: l_msg_tokens WSM_Log_PVT.token_rec_tbl;

953:
954: l_counter NUMBER;
955:
956: -- Logging variables.....
957: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
958: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
959:
960: l_stmt_num NUMBER;
961: l_module VARCHAR2(100) := 'wsm.plsql.WSMPJUPD.copy_wsm_substitute_components';

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

1112: x_return_status := G_RET_UNEXPECTED;
1113: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
1114: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
1115: THEN
1116: WSM_log_PVT.handle_others( p_module_name => l_module ,
1117: p_stmt_num => l_stmt_num ,
1118: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
1119: p_run_log_level => l_log_level
1120: );

Line 1150: l_msg_tokens WSM_Log_PVT.token_rec_tbl;

1146: l_qty_RUN NUMBER;
1147: l_qty_TM NUMBER;
1148:
1149: -- Logging variables.....
1150: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
1151: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1152:
1153: l_stmt_num NUMBER;
1154: l_module VARCHAR2(100) := 'wsm.plsql.WSMPJUPD.GET_JOB_CURR_OP_INFO';

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

1208:
1209: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
1210:
1211: l_msg_tokens.delete;
1212: WSM_log_PVT.logMessage(p_module_name => l_module ,
1213: p_msg_text => x_err_buf ,
1214: p_stmt_num => l_stmt_num ,
1215: p_msg_tokens => l_msg_tokens,
1216: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

1228:
1229: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
1230:
1231: l_msg_tokens.delete;
1232: WSM_log_PVT.logMessage(p_module_name => l_module ,
1233: p_msg_text => x_err_buf ,
1234: p_stmt_num => l_stmt_num ,
1235: p_msg_tokens => l_msg_tokens,
1236: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

1257:
1258: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
1259: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
1260: THEN
1261: WSM_log_PVT.handle_others( p_module_name => l_module ,
1262: p_stmt_num => l_stmt_num ,
1263: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
1264: p_run_log_level => l_log_level
1265: );

Line 1296: l_msg_tokens WSM_Log_PVT.token_rec_tbl;

1292: l_counter2 number;
1293: l_counter number;
1294:
1295: -- Logging variables.....
1296: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
1297: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1298:
1299: l_stmt_num NUMBER;
1300: l_module VARCHAR2(100) := 'wsm.plsql.WSMJUPDB.COPY_REP_JOB_WO_FA';

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

1303: l_stmt_num := 10;
1304:
1305: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
1306: l_msg_tokens.delete;
1307: WSM_log_PVT.logMessage (p_module_name => l_module ,
1308: p_msg_text => 'Inside COPY_REP_JOB_WO_FA : New Jobs count ' || p_new_rj_we_id_tbl.count
1309: || ' ' || p_curr_op_seq_num || ' ' || p_rep_we_id,
1310: p_stmt_num => l_stmt_num ,
1311: p_msg_tokens => l_msg_tokens ,

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

1539:
1540: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
1541: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
1542: THEN
1543: WSM_log_PVT.handle_others( p_module_name => l_module ,
1544: p_stmt_num => l_stmt_num ,
1545: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
1546: p_run_log_level => l_log_level
1547: );

Line 1567: l_msg_tokens WSM_Log_PVT.token_rec_tbl;

1563: x_err_buf OUT NOCOPY VARCHAR2)
1564: IS
1565:
1566: -- Logging variables.....
1567: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
1568: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1569: l_stmt_num NUMBER;
1570: l_module VARCHAR2(100) := 'wsm.plsql.WSMPJUPD.COPY_REP_JOB_WOR';
1571:

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

1696:
1697: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
1698: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
1699: THEN
1700: WSM_log_PVT.handle_others( p_module_name => l_module ,
1701: p_stmt_num => l_stmt_num ,
1702: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
1703: p_run_log_level => l_log_level
1704: );

Line 1725: l_msg_tokens WSM_Log_PVT.token_rec_tbl;

1721: x_err_buf OUT NOCOPY VARCHAR2)
1722: IS
1723:
1724: -- Logging variables.....
1725: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
1726: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1727:
1728: l_stmt_num NUMBER;
1729: l_module VARCHAR2(100) := 'wsm.plsql.WSMJUPDB.COPY_REP_JOB_WSOR';

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

1871:
1872: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
1873: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
1874: THEN
1875: WSM_log_PVT.handle_others( p_module_name => l_module ,
1876: p_stmt_num => l_stmt_num ,
1877: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
1878: p_run_log_level => l_log_level
1879: );

Line 1902: l_msg_tokens WSM_Log_PVT.token_rec_tbl;

1898: )
1899: IS
1900:
1901: -- Logging variables.....
1902: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
1903: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1904:
1905: l_stmt_num NUMBER;
1906: l_module VARCHAR2(100) := 'wsm.plsql.WSMJUPDB.COPY_REP_JOB_WORI';

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

1959:
1960: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
1961: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
1962: THEN
1963: WSM_log_PVT.handle_others( p_module_name => l_module ,
1964: p_stmt_num => l_stmt_num ,
1965: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
1966: p_run_log_level => l_log_level
1967: );

Line 1990: l_msg_tokens WSM_Log_PVT.token_rec_tbl;

1986: x_err_buf OUT NOCOPY VARCHAR2)
1987: IS
1988:
1989: -- Logging variables.....
1990: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
1991: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1992:
1993: l_stmt_num NUMBER;
1994: l_module VARCHAR2(100) := 'wsm.plsql.WSMJUPDB.COPY_REP_JOB_WRO';

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

2177:
2178: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
2179: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
2180: THEN
2181: WSM_log_PVT.handle_others( p_module_name => l_module ,
2182: p_stmt_num => l_stmt_num ,
2183: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
2184: p_run_log_level => l_log_level
2185: );

Line 2206: l_msg_tokens WSM_Log_PVT.token_rec_tbl;

2202: )
2203: IS
2204:
2205: -- Logging variables.....
2206: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
2207: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2208:
2209: l_stmt_num NUMBER;
2210: l_module VARCHAR2(100) := 'wsm.plsql.WSMJUPDB.COPY_REP_JOB_WOY';

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

2263:
2264: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
2265: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
2266: THEN
2267: WSM_log_PVT.handle_others( p_module_name => l_module ,
2268: p_stmt_num => l_stmt_num ,
2269: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
2270: p_run_log_level => l_log_level
2271: );

Line 2320: l_msg_tokens WSM_Log_PVT.token_rec_tbl;

2316: )
2317: IS
2318:
2319: -- Logging variables.....
2320: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
2321: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2322:
2323: l_stmt_num NUMBER;
2324: l_module VARCHAR2(100) := 'wsm.plsql.WSMJUPDB.CHANGE_QUANTITY';

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

2429:
2430: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
2431: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
2432: THEN
2433: WSM_log_PVT.handle_others( p_module_name => l_module ,
2434: p_stmt_num => l_stmt_num ,
2435: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
2436: p_run_log_level => l_log_level
2437: );

Line 2468: l_msg_tokens WSM_Log_PVT.token_rec_tbl;

2464: l_sub_loc_change_flag number;
2465: l_ret_status varchar2(1);
2466:
2467: -- Logging variables.....
2468: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
2469: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2470:
2471: l_stmt_num NUMBER;
2472: l_module VARCHAR2(100) := 'wsm.plsql.WSMJUPDB.handle_kanban_sub_loc_change';

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

2525:
2526: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
2527: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
2528: THEN
2529: WSM_log_PVT.handle_others( p_module_name => l_module ,
2530: p_stmt_num => l_stmt_num ,
2531: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
2532: p_run_log_level => l_log_level
2533: );

Line 2574: l_msg_tokens WSM_Log_PVT.token_rec_tbl;

2570: )
2571: IS
2572:
2573: -- Logging variables.....
2574: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
2575: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2576:
2577: l_stmt_num NUMBER;
2578: l_module VARCHAR2(100) := 'wsm.plsql.WSMJUPDB.UPDATE_QTY_ISSUED';

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

2757:
2758: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
2759: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
2760: THEN
2761: WSM_log_PVT.handle_others( p_module_name => l_module ,
2762: p_stmt_num => l_stmt_num ,
2763: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
2764: p_run_log_level => l_log_level
2765: );

Line 2793: l_msg_tokens WSM_Log_PVT.token_rec_tbl;

2789: x_err_code OUT NOCOPY NUMBER,
2790: x_err_buf OUT NOCOPY VARCHAR2)
2791: IS
2792: -- Logging variables.....
2793: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
2794: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2795:
2796: l_stmt_num NUMBER;
2797: l_module VARCHAR2(100) := 'wsm.plsql.WSMJUPDB.CREATE_WSOR_WLBJ_RECORDS';

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

2933:
2934: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
2935: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
2936: THEN
2937: WSM_log_PVT.handle_others( p_module_name => l_module ,
2938: p_stmt_num => l_stmt_num ,
2939: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
2940: p_run_log_level => l_log_level
2941: );

Line 2984: l_msg_tokens WSM_Log_PVT.token_rec_tbl;

2980: l_op_seq_num NUMBER; -- Added for APS-WLT --
2981: l_fnd_err_msg VARCHAR2(2000);
2982: x_msg_count number;
2983: -- Logging variables.....
2984: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
2985: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2986:
2987: l_stmt_num NUMBER;
2988: l_module VARCHAR2(100) := 'wsm.plsql.WSMJUPDB.CHANGE_ROUTING';

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

3002: l_stmt_num := 20;
3003:
3004: if( g_log_level_statement >= l_log_level ) then
3005: l_msg_tokens.delete;
3006: WSM_log_PVT.logMessage(p_module_name => l_module ,
3007: p_msg_text => 'Entered procedure CHANGE_ROUTING',
3008: p_stmt_num => l_stmt_num ,
3009: p_msg_tokens => l_msg_tokens,
3010: p_fnd_log_level => g_log_level_statement,

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

3032:
3033: IF (x_err_code <> 0) THEN
3034: IF G_LOG_LEVEL_STATEMENT >= l_log_level THEN
3035: l_msg_tokens.delete;
3036: WSM_log_PVT.logMessage(p_module_name => l_module ,
3037: p_msg_text => 'GET_JOB_CURR_OP_INFO returned failure',
3038: p_stmt_num => l_stmt_num ,
3039: p_msg_tokens => l_msg_tokens,
3040: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

3072:
3073: IF (x_err_code <> 0) THEN
3074: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
3075: l_msg_tokens.delete;
3076: WSM_log_PVT.logMessage(p_module_name => l_module ,
3077: p_msg_text => x_err_buf ,
3078: p_stmt_num => l_stmt_num ,
3079: p_msg_tokens => l_msg_tokens ,
3080: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

3095:
3096: l_msg_tokens.delete;
3097: l_msg_tokens(1).TokenName := 'ELEMENT';
3098: l_msg_tokens(1).TokenValue := 'Resources';
3099: WSM_log_PVT.logMessage(p_module_name => l_module ,
3100: p_msg_name => 'WSM_MANUAL_CHARGES_EXIST',
3101: p_msg_appl_name => 'WSM' ,
3102: p_msg_tokens => l_msg_tokens ,
3103: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

3117:
3118: l_msg_tokens.delete;
3119: l_msg_tokens(1).TokenName := 'ELEMENT';
3120: l_msg_tokens(1).TokenValue := 'Materials';
3121: WSM_log_PVT.logMessage(p_module_name => l_module ,
3122: p_msg_name => 'WSM_MANUAL_CHARGES_EXIST',
3123: p_msg_appl_name => 'WSM' ,
3124: p_msg_tokens => l_msg_tokens ,
3125: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

3136:
3137: IF g_log_level_event >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_SUCCESS) then
3138:
3139: l_msg_tokens.delete;
3140: WSM_log_PVT.logMessage(p_module_name => l_module ,
3141: p_msg_name => 'WSM_PHANTOM_COMPONENTS_EXIST',
3142: p_msg_appl_name => 'WSM' ,
3143: p_msg_tokens => l_msg_tokens ,
3144: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

3238: l_stmt_num := 85;
3239:
3240: if( g_log_level_statement >= l_log_level ) then
3241: l_msg_tokens.delete;
3242: WSM_log_PVT.logMessage(p_module_name => l_module ,
3243: p_msg_text => 'Calling WSMPLBJI.insert_procedure :' ||p_rj_job_rec.starting_operation_seq_id,
3244: p_stmt_num => l_stmt_num ,
3245: p_msg_tokens => l_msg_tokens,
3246: p_fnd_log_level => g_log_level_statement,

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

3290: IF (x_err_code <> 0) THEN
3291:
3292: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
3293: l_msg_tokens.delete;
3294: WSM_log_PVT.logMessage(p_module_name => l_module ,
3295: p_msg_text => 'Returned failure from WSMPLBJI.insert_procedure.Error:'|| x_err_buf,
3296: p_stmt_num => l_stmt_num ,
3297: p_msg_tokens => l_msg_tokens,
3298: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

3341: IF (x_err_code <> 0) THEN
3342: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
3343:
3344: l_msg_tokens.delete;
3345: WSM_log_PVT.logMessage(p_module_name => l_module ,
3346: p_msg_text => 'Returned failure from CREATE_WSOR_WLBJ_RECORDS',
3347: p_stmt_num => l_stmt_num ,
3348: p_msg_tokens => l_msg_tokens,
3349: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

3355: ELSE
3356:
3357: if( g_log_level_statement >= l_log_level ) then
3358: l_msg_tokens.delete;
3359: WSM_log_PVT.logMessage(p_module_name => l_module ,
3360: p_msg_text => 'Created WSOR records for new job with id='||p_wip_entity_id,
3361: p_stmt_num => l_stmt_num ,
3362: p_msg_tokens => l_msg_tokens,
3363: p_fnd_log_level => g_log_level_statement,

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

3419:
3420: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
3421: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
3422: THEN
3423: WSM_log_PVT.handle_others( p_module_name => l_module ,
3424: p_stmt_num => l_stmt_num ,
3425: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
3426: p_run_log_level => l_log_level
3427: );

Line 3469: l_msg_tokens WSM_Log_PVT.token_rec_tbl;

3465: translated_meaning VARCHAR2(240); --abbkanban
3466: l_rtg_op_seq_num NUMBER;
3467:
3468: -- Logging variables.....
3469: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
3470: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3471:
3472: l_stmt_num NUMBER;
3473: l_module VARCHAR2(100) := 'wsm.plsql.WSMJUPDB.UPDATE_ASSEMBLY_OR_ROUTING';

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

3503: IF (x_err_code <> 0) THEN
3504: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
3505:
3506: l_msg_tokens.delete;
3507: WSM_log_PVT.logMessage(p_module_name => l_module ,
3508: p_msg_text => 'Handle_kanban_sub_loc_change returned error: ' || x_err_buf,
3509: p_stmt_num => l_stmt_num ,
3510: p_msg_tokens => l_msg_tokens,
3511: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

3573:
3574: l_msg_tokens.delete;
3575: l_msg_tokens(1).TokenName := 'STATUS';
3576: l_msg_tokens(1).TokenValue := g_translated_meaning;
3577: WSM_log_PVT.logMessage(p_module_name => l_module ,
3578: p_msg_name => 'WSM_KNBN_CARD_STS_FAIL',
3579: p_msg_appl_name => 'WSM' ,
3580: p_msg_tokens => l_msg_tokens ,
3581: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

3636: IF (x_err_code <> 0) THEN
3637: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
3638:
3639: l_msg_tokens.delete;
3640: WSM_log_PVT.logMessage(p_module_name => l_module ,
3641: p_msg_text => 'CHANGE_ROUTING returned error:'||x_err_buf,
3642: p_stmt_num => l_stmt_num ,
3643: p_msg_tokens => l_msg_tokens,
3644: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

3651:
3652: IF (l_new_op_added IS NOT NULL) THEN -- Added condition check for APS-WLT --
3653: if( g_log_level_statement >= l_log_level ) then
3654: l_msg_tokens.delete;
3655: WSM_log_PVT.logMessage(p_module_name => l_module ,
3656: p_msg_text => 'Added new operation sequence '||l_new_op_added||' to the job',
3657: p_stmt_num => l_stmt_num ,
3658: p_msg_tokens => l_msg_tokens,
3659: p_fnd_log_level => g_log_level_statement,

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

3745:
3746: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
3747: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
3748: THEN
3749: WSM_log_PVT.handle_others( p_module_name => l_module ,
3750: p_stmt_num => l_stmt_num ,
3751: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
3752: p_run_log_level => l_log_level
3753: );

Line 3786: l_msg_tokens WSM_Log_PVT.token_rec_tbl;

3782: l_err_code number;
3783: l_err_buf varchar2(2000);
3784:
3785: -- Logging variables.....
3786: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
3787: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3788:
3789: l_stmt_num NUMBER;
3790: l_module VARCHAR2(100) := 'wsm.plsql.WSMJUPDB.Insert_MMT_record';

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

3814: IF (l_err_code <> 0) THEN
3815: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
3816:
3817: l_msg_tokens.delete;
3818: WSM_log_PVT.logMessage(p_module_name => l_module ,
3819: p_msg_text => 'WSMPUTIL.GET_INV_ACCT_PERIOD returned error:' || l_err_buf,
3820: p_stmt_num => l_stmt_num ,
3821: p_msg_tokens => l_msg_tokens,
3822: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

3915:
3916: l_msg_tokens.delete;
3917: l_msg_tokens(1).TokenName := 'ELEMENT';
3918: l_msg_tokens(1).TokenValue := 'mtl_material_transactions';
3919: WSM_log_PVT.logMessage(p_module_name => l_module ,
3920: p_msg_name => 'WSM_INS_TBL_FAILED',
3921: p_msg_appl_name => 'WSM' ,
3922: p_msg_tokens => l_msg_tokens ,
3923: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

3953: x_return_status := fnd_api.g_ret_sts_error;
3954: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) THEN
3955:
3956: l_msg_tokens.delete;
3957: WSM_log_PVT.logMessage (p_module_name => l_module ,
3958: p_msg_text => SUBSTRB('Unexpected Error : SQLCODE '|| SQLCODE ||' : SQLERRM : '|| SQLERRM, 1, 2000),
3959: p_stmt_num => l_stmt_num ,
3960: p_msg_tokens => l_msg_tokens ,
3961: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

3966:
3967: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
3968: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
3969: THEN
3970: WSM_log_PVT.handle_others( p_module_name => l_module ,
3971: p_stmt_num => l_stmt_num ,
3972: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
3973: p_run_log_level => l_log_level
3974: );

Line 4011: l_msg_tokens WSM_Log_PVT.token_rec_tbl;

4007: l_sj_counter NUMBER;
4008: l_rep_wip_entity_id NUMBER;
4009:
4010: -- Logging variables.....
4011: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
4012: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4013:
4014: l_stmt_num NUMBER;
4015: l_module VARCHAR2(100) := 'wsm.plsql.WSMPJUPDB.CREATE_COPIES_OR_SET_COPY_DATA';

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

4109: x_err_code := 0; -- Fix for bug #3421662 --
4110: ELSE
4111: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
4112: l_msg_tokens.delete;
4113: WSM_log_PVT.logMessage(p_module_name => l_module ,
4114: p_msg_text => 'WSM_JobCopies_PVT.Create_JobCopies returned error:' || x_err_buf,
4115: p_stmt_num => l_stmt_num ,
4116: p_msg_tokens => l_msg_tokens,
4117: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

4123: END IF;
4124:
4125: if( g_log_level_statement >= l_log_level ) then
4126: l_msg_tokens.delete;
4127: WSM_log_PVT.logMessage(p_module_name => l_module ,
4128: p_msg_text => 'WSM_JobCopies_PVT.Create_JobCopies returned success',
4129: p_stmt_num => l_stmt_num ,
4130: p_msg_tokens => l_msg_tokens,
4131: p_fnd_log_level => g_log_level_statement,

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

4141: WHERE wip_entity_id = p_wltx_resulting_jobs_tbl(l_rj_counter).wip_entity_id;
4142:
4143: if( g_log_level_statement >= l_log_level ) then
4144: l_msg_tokens.delete;
4145: WSM_log_PVT.logMessage(p_module_name => l_module ,
4146: p_msg_text => 'Set internal_copy_type = 2 for we_id=',
4147: p_stmt_num => l_stmt_num ,
4148: p_msg_tokens => l_msg_tokens,
4149: p_fnd_log_level => g_log_level_statement,

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

4192: l_stmt_num := 60;
4193:
4194: if( g_log_level_statement >= l_log_level ) then
4195: l_msg_tokens.delete;
4196: WSM_log_PVT.logMessage(p_module_name => l_module ,
4197: p_msg_text => 'new we_id :'||p_wltx_resulting_jobs_tbl(l_job_counter).wip_entity_id||
4198: 'rep_job_we_id :'||l_rep_wip_entity_id,
4199: p_stmt_num => l_stmt_num ,
4200: p_msg_tokens => l_msg_tokens,

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

4225: IF (x_err_code <> 0) THEN
4226: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
4227:
4228: l_msg_tokens.delete;
4229: WSM_log_PVT.logMessage(p_module_name => l_module ,
4230: p_msg_text => 'WSM_JobCopies_PVT.Create_RepJobCopies returned error:' || x_err_buf,
4231: p_stmt_num => l_stmt_num ,
4232: p_msg_tokens => l_msg_tokens,
4233: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

4241: l_stmt_num := 70;
4242:
4243: if( g_log_level_statement >= l_log_level ) then
4244: l_msg_tokens.delete;
4245: WSM_log_PVT.logMessage(p_module_name => l_module ,
4246: p_msg_text => 'WSM_JobCopies_PVT.Create_RepJobCopies returned success',
4247: p_stmt_num => l_stmt_num ,
4248: p_msg_tokens => l_msg_tokens,
4249: p_fnd_log_level => g_log_level_statement,

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

4260: WHERE wip_entity_id = p_wltx_resulting_jobs_tbl(l_job_counter).wip_entity_id;
4261:
4262: if( g_log_level_statement >= l_log_level ) then
4263: l_msg_tokens.delete;
4264: WSM_log_PVT.logMessage(p_module_name => l_module ,
4265: p_msg_text => 'Set internal_copy_type = '||l_new_job_int_copy_type||' for we_id=',
4266: p_stmt_num => l_stmt_num ,
4267: p_msg_tokens => l_msg_tokens,
4268: p_fnd_log_level => g_log_level_statement,

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

4279: WHERE wip_entity_id = p_wltx_resulting_jobs_tbl(l_job_counter).wip_entity_id;
4280:
4281: if( g_log_level_statement >= l_log_level ) then
4282: l_msg_tokens.delete;
4283: WSM_log_PVT.logMessage(p_module_name => l_module ,
4284: p_msg_text => 'Set copy_parent_wip_entity_id = '||nvl(l_rep_job_par_we_id, l_rep_wip_entity_id)||' for we_id=',
4285: p_stmt_num => l_stmt_num ,
4286: p_msg_tokens => l_msg_tokens,
4287: p_fnd_log_level => g_log_level_statement,

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

4370: ELSE
4371: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
4372:
4373: l_msg_tokens.delete;
4374: WSM_log_PVT.logMessage(p_module_name => l_module ,
4375: p_msg_text => 'WSM_JobCopies_PVT.Create_JobCopies returned error:' || x_err_buf,
4376: p_stmt_num => l_stmt_num ,
4377: p_msg_tokens => l_msg_tokens,
4378: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

4384: END IF;
4385:
4386: if( g_log_level_statement >= l_log_level ) then
4387: l_msg_tokens.delete;
4388: WSM_log_PVT.logMessage(p_module_name => l_module ,
4389: p_msg_text => 'WSM_JobCopies_PVT.Create_JobCopies returned success',
4390: p_stmt_num => l_stmt_num ,
4391: p_msg_tokens => l_msg_tokens,
4392: p_fnd_log_level => g_log_level_statement,

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

4403: WHERE wip_entity_id = p_wltx_resulting_jobs_tbl(l_job_counter).wip_entity_id;
4404:
4405: if( g_log_level_statement >= l_log_level ) then
4406: l_msg_tokens.delete;
4407: WSM_log_PVT.logMessage(p_module_name => l_module ,
4408: p_msg_text => 'Set internal_copy_type = 2 for we_id=',
4409: p_stmt_num => l_stmt_num ,
4410: p_msg_tokens => l_msg_tokens,
4411: p_fnd_log_level => g_log_level_statement,

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

4502: ELSE
4503: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
4504:
4505: l_msg_tokens.delete;
4506: WSM_log_PVT.logMessage(p_module_name => l_module ,
4507: p_msg_text => 'WSM_JobCopies_PVT.Create_JobCopies returned error:' || x_err_buf,
4508: p_stmt_num => l_stmt_num ,
4509: p_msg_tokens => l_msg_tokens,
4510: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

4516: END IF;
4517:
4518: if( g_log_level_statement >= l_log_level ) then
4519: l_msg_tokens.delete;
4520: WSM_log_PVT.logMessage(p_module_name => l_module ,
4521: p_msg_text => 'WSM_JobCopies_PVT.Create_JobCopies returned success',
4522: p_stmt_num => l_stmt_num ,
4523: p_msg_tokens => l_msg_tokens,
4524: p_fnd_log_level => g_log_level_statement,

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

4534: WHERE wip_entity_id = l_rep_wip_entity_id;
4535:
4536: if( g_log_level_statement >= l_log_level ) then
4537: l_msg_tokens.delete;
4538: WSM_log_PVT.logMessage(p_module_name => l_module ,
4539: p_msg_text => 'Set internal_copy_type = 2 for we_id='||l_rep_wip_entity_id,
4540: p_stmt_num => l_stmt_num ,
4541: p_msg_tokens => l_msg_tokens,
4542: p_fnd_log_level => g_log_level_statement,

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

4584:
4585: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
4586: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
4587: THEN
4588: WSM_log_PVT.handle_others( p_module_name => l_module ,
4589: p_stmt_num => l_stmt_num ,
4590: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
4591: p_run_log_level => l_log_level
4592: );

Line 4625: l_msg_tokens WSM_Log_PVT.token_rec_tbl;

4621: l_job_op_comp_dt DATE;
4622: l_returnStatus VARCHAR2(1);
4623: x_msg_count number;
4624: -- Logging variables.....
4625: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
4626: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4627:
4628: l_stmt_num NUMBER;
4629: l_module VARCHAR2(100) := 'wsm.plsql.WSMPJUPDB.CALL_INF_SCH_OR_SET_SCH_DATA';

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

4658:
4659: IF (x_err_code <> 0) THEN
4660: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
4661: l_msg_tokens.delete;
4662: WSM_log_PVT.logMessage(p_module_name => l_module ,
4663: p_msg_text => 'GET_JOB_CURR_OP_INFO returned error:' || x_err_buf,
4664: p_stmt_num => l_stmt_num ,
4665: p_msg_tokens => l_msg_tokens,
4666: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

4695: IF(l_returnStatus <> FND_API.G_RET_STS_SUCCESS) THEN
4696: x_err_code := -1;
4697: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
4698: l_msg_tokens.delete;
4699: WSM_log_PVT.logMessage(p_module_name => l_module ,
4700: p_msg_text => 'WSM_infinite_scheduler_PVT.schedule returned error:' || x_err_buf,
4701: p_stmt_num => l_stmt_num ,
4702: p_msg_tokens => l_msg_tokens,
4703: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

4749:
4750: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
4751: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
4752: THEN
4753: WSM_log_PVT.handle_others( p_module_name => l_module ,
4754: p_stmt_num => l_stmt_num ,
4755: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
4756: p_run_log_level => l_log_level
4757: );

Line 4838: l_msg_tokens WSM_log_PVT.token_rec_tbl;

4834: l_msg_data varchar2(2000);
4835:
4836: /*logging variables*/
4837: l_stmt_num number := 0;
4838: l_msg_tokens WSM_log_PVT.token_rec_tbl;
4839: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4840: l_module VARCHAR2(100) := 'wsm.plsql.WSMPJUPD.process_lots';
4841:
4842:

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

4963: --remove this
4964:
4965: if( g_log_level_statement >= l_log_level ) then
4966: l_msg_tokens.delete;
4967: WSM_log_PVT.logMessage(p_module_name => l_module ,
4968: p_msg_text => 'Calling WSMPLBJI.build_lbji_info procedure',
4969: p_stmt_num => l_stmt_num ,
4970: p_msg_tokens => l_msg_tokens,
4971: p_fnd_log_level => g_log_level_statement,

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

5059:
5060: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
5061:
5062: l_msg_tokens.delete;
5063: WSM_log_PVT.logMessage(p_module_name => l_module ,
5064: p_msg_text => 'Returned failure from WSMPLBJI.build_lbji_info procedure' ,
5065: p_stmt_num => l_stmt_num ,
5066: p_msg_tokens => l_msg_tokens,
5067: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

5073: ELSE
5074: -- success... now the program would have returned the id ....
5075: if( g_log_level_statement >= l_log_level ) then
5076: l_msg_tokens.delete;
5077: WSM_log_PVT.logMessage(p_module_name => l_module ,
5078: p_msg_text => 'Returned successfully from WSMPLBJI.build_lbji_info procedure',
5079: p_stmt_num => l_stmt_num ,
5080: p_msg_tokens => l_msg_tokens,
5081: p_fnd_log_level => g_log_level_statement,

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

5097: l_err_buf := null;
5098:
5099: if( g_log_level_statement >= l_log_level ) then
5100: l_msg_tokens.delete;
5101: WSM_log_PVT.logMessage(p_module_name => l_module ,
5102: p_msg_text => 'Calling WSM_lbj_interface_PVT.build_job_header_info',
5103: p_stmt_num => l_stmt_num ,
5104: p_msg_tokens => l_msg_tokens,
5105: p_fnd_log_level => g_log_level_statement,

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

5190: IF (l_err_code <> 0) THEN
5191: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
5192:
5193: l_msg_tokens.delete;
5194: WSM_log_PVT.logMessage(p_module_name => l_module ,
5195: p_msg_text => 'Returned failure from WSM_lbj_interface_PVT.build_job_header_info'||l_err_buf,
5196: p_stmt_num => l_stmt_num ,
5197: p_msg_tokens => l_msg_tokens,
5198: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

5205: ELSE
5206: -- success... now the program would have returned the id ....
5207: if( g_log_level_statement >= l_log_level ) then
5208: l_msg_tokens.delete;
5209: WSM_log_PVT.logMessage(p_module_name => l_module ,
5210: p_msg_text => 'Returned success from WSM_lbj_interface_PVT.build_job_header_info',
5211: p_stmt_num => l_stmt_num ,
5212: p_msg_tokens => l_msg_tokens,
5213: p_fnd_log_level => g_log_level_statement,

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

5250: -- this means this kanban_card_id is inherited by resulting job, while examining the starting jobs
5251: -- do not set the kanban card to Exception just because the qties of the starting jobs have become 0
5252: if( g_log_level_statement >= l_log_level ) then
5253: l_msg_tokens.delete;
5254: WSM_log_PVT.logMessage(p_module_name => l_module ,
5255: p_msg_text => 'Calling INV_Kanban_PVT.Update_Card_Supply_Status',
5256: p_stmt_num => l_stmt_num ,
5257: p_msg_tokens => l_msg_tokens,
5258: p_fnd_log_level => g_log_level_statement,

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

5274:
5275: l_msg_tokens.delete;
5276: l_msg_tokens(1).TokenName := 'STATUS';
5277: l_msg_tokens(1).TokenValue := g_translated_meaning;
5278: WSM_log_PVT.logMessage(p_module_name => l_module ,
5279: p_msg_name => 'WSM_KNBN_CARD_STS_FAIL',
5280: p_msg_appl_name => 'WSM' ,
5281: p_msg_tokens => l_msg_tokens ,
5282: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

5318: l_stmt_num := 220;
5319:
5320: if( g_log_level_statement >= l_log_level ) then
5321: l_msg_tokens.delete;
5322: WSM_log_PVT.logMessage(p_module_name => l_module ,
5323: p_msg_text => 'Calling COPY_REP_JOB_WO_FA ' || p_wltx_starting_jobs_tbl(l_rep_sj_index).operation_seq_num,
5324: p_stmt_num => l_stmt_num ,
5325: p_msg_tokens => l_msg_tokens,
5326: p_fnd_log_level => g_log_level_statement,

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

5346: IF (l_err_code <> 0) THEN
5347: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
5348:
5349: l_msg_tokens.delete;
5350: WSM_log_PVT.logMessage(p_module_name => l_module ,
5351: p_msg_text => 'Returned failure from COPY_REP_JOB_WO_FA',
5352: p_stmt_num => l_stmt_num ,
5353: p_msg_tokens => l_msg_tokens,
5354: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

5362:
5363: l_stmt_num := 230;
5364: if( g_log_level_statement >= l_log_level ) then
5365: l_msg_tokens.delete;
5366: WSM_log_PVT.logMessage(p_module_name => l_module ,
5367: p_msg_text => 'Calling COPY_REP_JOB_WOR ',
5368: p_stmt_num => l_stmt_num ,
5369: p_msg_tokens => l_msg_tokens,
5370: p_fnd_log_level => g_log_level_statement,

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

5385: IF (l_err_code <> 0) THEN
5386: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
5387:
5388: l_msg_tokens.delete;
5389: WSM_log_PVT.logMessage(p_module_name => l_module ,
5390: p_msg_text => 'Returned failure from COPY_REP_JOB_WOR',
5391: p_stmt_num => l_stmt_num ,
5392: p_msg_tokens => l_msg_tokens,
5393: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

5411: ELSE -- Copies are to be made i.e. Option C
5412: -- Make copies immediately or at the end
5413: if( g_log_level_statement >= l_log_level ) then
5414: l_msg_tokens.delete;
5415: WSM_log_PVT.logMessage(p_module_name => l_module ,
5416: p_msg_text => 'Calling COPY_REP_JOB_WSOR ',
5417: p_stmt_num => l_stmt_num ,
5418: p_msg_tokens => l_msg_tokens,
5419: p_fnd_log_level => g_log_level_statement,

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

5432: IF (l_err_code <> 0) THEN
5433: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
5434:
5435: l_msg_tokens.delete;
5436: WSM_log_PVT.logMessage(p_module_name => l_module ,
5437: p_msg_text => 'Returned failure from COPY_REP_JOB_WSOR',
5438: p_stmt_num => l_stmt_num ,
5439: p_msg_tokens => l_msg_tokens,
5440: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

5463: IF (l_err_code <> 0) THEN
5464: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
5465:
5466: l_msg_tokens.delete;
5467: WSM_log_PVT.logMessage(p_module_name => l_module ,
5468: p_msg_text => 'Returned failure from COPY_REP_JOB_WORI',
5469: p_stmt_num => l_stmt_num,
5470: p_msg_tokens => l_msg_tokens,
5471: p_fnd_msg_level => G_MSG_LVL_ERROR,

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

5479:
5480: l_stmt_num := 250;
5481: if( g_log_level_statement >= l_log_level ) then
5482: l_msg_tokens.delete;
5483: WSM_log_PVT.logMessage(p_module_name => l_module,
5484: p_msg_text => 'Calling COPY_REP_JOB_WRO',
5485: p_stmt_num => l_stmt_num,
5486: p_msg_tokens => l_msg_tokens,
5487: p_fnd_log_level => g_log_level_statement,

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

5506: IF (l_err_code <> 0) THEN
5507: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
5508:
5509: l_msg_tokens.delete;
5510: WSM_log_PVT.logMessage(p_module_name => l_module ,
5511: p_msg_text => 'Returned failure from COPY_REP_JOB_WRO',
5512: p_stmt_num => l_stmt_num ,
5513: p_msg_tokens => l_msg_tokens,
5514: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

5522:
5523: l_stmt_num := 260;
5524: if( g_log_level_statement >= l_log_level ) then
5525: l_msg_tokens.delete;
5526: WSM_log_PVT.logMessage(p_module_name => l_module ,
5527: p_msg_text => 'Calling COPY_REP_JOB_WOY ',
5528: p_stmt_num => l_stmt_num ,
5529: p_msg_tokens => l_msg_tokens,
5530: p_fnd_log_level => g_log_level_statement,

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

5545:
5546: IF (l_err_code <> 0) THEN
5547: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
5548: l_msg_tokens.delete;
5549: WSM_log_PVT.logMessage(p_module_name => l_module ,
5550: p_msg_text => 'Returned failure from COPY_REP_JOB_WOY',
5551: p_stmt_num => l_stmt_num ,
5552: p_msg_tokens => l_msg_tokens,
5553: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

5560:
5561: -- ok now process the starting jobs...
5562: if( g_log_level_statement >= l_log_level ) then
5563: l_msg_tokens.delete;
5564: WSM_log_PVT.logMessage(p_module_name => l_module ,
5565: p_msg_text => ' processing the starting jobs...',
5566: p_stmt_num => l_stmt_num ,
5567: p_msg_tokens => l_msg_tokens,
5568: p_fnd_log_level => g_log_level_statement,

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

5582: (l_sj_also_rj_index is not null)
5583: then -- indicates that the starting job is also a resulting job
5584: if( g_log_level_statement >= l_log_level ) then
5585: l_msg_tokens.delete;
5586: WSM_log_PVT.logMessage(p_module_name => l_module ,
5587: p_msg_text => 'Representative Starting Job ' || p_wltx_starting_jobs_tbl(l_job_counter).wip_entity_name
5588: || ' is also a resulting job..'
5589: || ' Starting Job index(l_job_counter) : ' || l_job_counter
5590: || ' Resulting Job index(l_sj_also_rj_index) : ' || l_sj_also_rj_index,

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

5625:
5626: l_stmt_num := 120;
5627: if( g_log_level_statement >= l_log_level ) then
5628: l_msg_tokens.delete;
5629: WSM_log_PVT.logMessage(p_module_name => l_module ,
5630: p_msg_text => ' Calling INV_Kanban_PVT.Update_Card_Supply_Status...',
5631: p_stmt_num => l_stmt_num ,
5632: p_msg_tokens => l_msg_tokens,
5633: p_fnd_log_level => g_log_level_statement,

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

5647:
5648: l_msg_tokens.delete;
5649: l_msg_tokens(1).TokenName := 'STATUS';
5650: l_msg_tokens(1).TokenValue := g_translated_meaning;
5651: WSM_log_PVT.logMessage(p_module_name => l_module ,
5652: p_msg_name => 'WSM_KNBN_CARD_STS_FAIL',
5653: p_msg_appl_name => 'WSM' ,
5654: p_msg_tokens => l_msg_tokens ,
5655: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

5666: else
5667: -- now check if the resulting job has changed
5668: if( g_log_level_statement >= l_log_level ) then
5669: l_msg_tokens.delete;
5670: WSM_log_PVT.logMessage(p_module_name => l_module ,
5671: p_msg_text => ' Calling handle_kanban_sub_loc_change...',
5672: p_stmt_num => l_stmt_num ,
5673: p_msg_tokens => l_msg_tokens,
5674: p_fnd_log_level => g_log_level_statement,

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

5692: IF (l_err_code <> 0) THEN
5693: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
5694:
5695: l_msg_tokens.delete;
5696: WSM_log_PVT.logMessage(p_module_name => l_module ,
5697: p_msg_text => 'Returned failure from handle_kanban_sub_loc_change',
5698: p_stmt_num => l_stmt_num ,
5699: p_msg_tokens => l_msg_tokens,
5700: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

5714:
5715: l_stmt_num := 147;
5716: if( g_log_level_statement >= l_log_level ) then
5717: l_msg_tokens.delete;
5718: WSM_log_PVT.logMessage(p_module_name => l_module ,
5719: p_msg_text => ' Calling INV_Kanban_PVT.Update_Card_Supply_Status...',
5720: p_stmt_num => l_stmt_num ,
5721: p_msg_tokens => l_msg_tokens,
5722: p_fnd_log_level => g_log_level_statement,

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

5739:
5740: l_msg_tokens.delete;
5741: l_msg_tokens(1).TokenName := 'STATUS';
5742: l_msg_tokens(1).TokenValue := g_translated_meaning;
5743: WSM_log_PVT.logMessage(p_module_name => l_module ,
5744: p_msg_name => 'WSM_KNBN_CARD_STS_FAIL',
5745: p_msg_appl_name => 'WSM' ,
5746: p_msg_tokens => l_msg_tokens ,
5747: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

5763: p_wltx_resulting_jobs_tbl(l_sj_also_rj_index).kanban_card_id := l_kanban_card_id;
5764:
5765: if( g_log_level_statement >= l_log_level ) then
5766: l_msg_tokens.delete;
5767: WSM_log_PVT.logMessage(p_module_name => l_module ,
5768: p_msg_text => 'Updating the completion subinv and the kanban card id ...',
5769: p_stmt_num => l_stmt_num ,
5770: p_msg_tokens => l_msg_tokens,
5771: p_fnd_log_level => g_log_level_statement,

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

5788:
5789: l_stmt_num := 160;
5790: if( g_log_level_statement >= l_log_level ) then
5791: l_msg_tokens.delete;
5792: WSM_log_PVT.logMessage(p_module_name => l_module ,
5793: p_msg_text => 'starting job has been completely merged/split or a non-representative job... ',
5794: p_stmt_num => l_stmt_num ,
5795: p_msg_tokens => l_msg_tokens,
5796: p_fnd_log_level => g_log_level_statement,

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

5845:
5846: l_msg_tokens.delete;
5847: l_msg_tokens(1).TokenName := 'STATUS';
5848: l_msg_tokens(1).TokenValue := g_translated_meaning;
5849: WSM_log_PVT.logMessage(p_module_name => l_module ,
5850: p_msg_name => 'WSM_KNBN_CARD_STS_FAIL',
5851: p_msg_appl_name => 'WSM' ,
5852: p_msg_tokens => l_msg_tokens ,
5853: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

5902: if l_err_buf is null then
5903: l_err_buf := 'Returned failure from WSMPOPRN.update_job_name';
5904: end if;
5905: /* End bugfix 5738550 */
5906: WSM_log_PVT.logMessage(p_module_name => l_module ,
5907: p_msg_text => l_err_buf , /* Bugfix 5738550 removed hardcoding */
5908: p_stmt_num => l_stmt_num ,
5909: p_msg_tokens => l_msg_tokens,
5910: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

5916: else
5917: -- success.. got the new name for the job ...
5918: if( g_log_level_statement >= l_log_level ) then
5919: l_msg_tokens.delete;
5920: WSM_log_PVT.logMessage(p_module_name => l_module ,
5921: p_msg_text => 'WSMPOPRN.update_job_name success.Got new job name',
5922: p_stmt_num => l_stmt_num ,
5923: p_msg_tokens => l_msg_tokens,
5924: p_fnd_log_level => g_log_level_statement,

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

5937:
5938: l_stmt_num := 210;
5939: if( g_log_level_statement >= l_log_level ) then
5940: l_msg_tokens.delete;
5941: WSM_log_PVT.logMessage(p_module_name => l_module ,
5942: p_msg_text => 'Calling CHANGE_QUANTITY',
5943: p_stmt_num => l_stmt_num ,
5944: p_msg_tokens => l_msg_tokens,
5945: p_fnd_log_level => g_log_level_statement,

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

5970:
5971: IF (l_err_code <> 0) THEN
5972: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
5973: l_msg_tokens.delete;
5974: WSM_log_PVT.logMessage(p_module_name => l_module ,
5975: p_msg_text => 'CHANGE_QUANTITY returned failure' ,
5976: p_stmt_num => l_stmt_num ,
5977: p_msg_tokens => l_msg_tokens,
5978: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

5985:
5986: l_stmt_num := 270;
5987: if( g_log_level_statement >= l_log_level ) then
5988: l_msg_tokens.delete;
5989: WSM_log_PVT.logMessage(p_module_name => l_module ,
5990: p_msg_text => 'Calling UPDATE_QTY_ISSUED',
5991: p_stmt_num => l_stmt_num ,
5992: p_msg_tokens => l_msg_tokens,
5993: p_fnd_log_level => g_log_level_statement,

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

6015: if l_err_code <> 0 then
6016: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6017:
6018: l_msg_tokens.delete;
6019: WSM_log_PVT.logMessage(p_module_name => l_module ,
6020: p_msg_text => 'UPDATE_QTY_ISSUED returned failure' ,
6021: p_stmt_num => l_stmt_num ,
6022: p_msg_tokens => l_msg_tokens,
6023: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

6040:
6041: l_stmt_num := 290;
6042: if( g_log_level_statement >= l_log_level ) then
6043: l_msg_tokens.delete;
6044: WSM_log_PVT.logMessage(p_module_name => l_module ,
6045: p_msg_text => 'Calling UPDATE_ASSEMBLY_OR_ROUTING',
6046: p_stmt_num => l_stmt_num ,
6047: p_msg_tokens => l_msg_tokens,
6048: p_fnd_log_level => g_log_level_statement,

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

6072: IF (l_err_code <> 0) THEN
6073: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6074:
6075: l_msg_tokens.delete;
6076: WSM_log_PVT.logMessage(p_module_name => l_module ,
6077: p_msg_text => 'UPDATE_ASSEMBLY_OR_ROUTING returned failure' ,
6078: p_stmt_num => l_stmt_num ,
6079: p_msg_tokens => l_msg_tokens,
6080: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

6146: IF (l_err_code <> 0) THEN
6147: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6148:
6149: l_msg_tokens.delete;
6150: WSM_log_PVT.logMessage(p_module_name => l_module ,
6151: p_msg_text => 'CREATE_COPIES_OR_SET_COPY_DATA returned '||l_err_code,
6152: p_stmt_num => l_stmt_num ,
6153: p_msg_tokens => l_msg_tokens,
6154: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

6187: -- error out...
6188: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6189:
6190: l_msg_tokens.delete;
6191: WSM_log_PVT.logMessage(p_module_name => l_module ,
6192: p_msg_text => ' CALL_INF_SCH_OR_SET_SCH_DATA returned '||l_err_code,
6193: p_stmt_num => l_stmt_num ,
6194: p_msg_tokens => l_msg_tokens,
6195: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

6281: l_stmt_num := 360;
6282: IF (l_ret_status = 'S') THEN
6283: if( g_log_level_statement >= l_log_level ) then
6284: l_msg_tokens.delete;
6285: WSM_log_PVT.logMessage(p_module_name => l_module ,
6286: p_msg_text => 'inv_genealogy_pub.insert_genealogy returned success',
6287: p_stmt_num => l_stmt_num ,
6288: p_msg_tokens => l_msg_tokens,
6289: p_fnd_log_level => g_log_level_statement,

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

6295:
6296: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6297:
6298: l_msg_tokens.delete;
6299: WSM_log_PVT.logMessage(p_module_name => l_module ,
6300: p_msg_text => 'inv_genealogy_pub.insert_genealogy failed',
6301: p_stmt_num => l_stmt_num ,
6302: p_msg_tokens => l_msg_tokens,
6303: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

6387: l_stmt_num := 374;
6388: IF (l_ret_status = 'S') THEN
6389: if( g_log_level_statement >= l_log_level ) then
6390: l_msg_tokens.delete;
6391: WSM_log_PVT.logMessage(p_module_name => l_module ,
6392: p_msg_text => 'inv_genealogy_pub.insert_genealogy returned success',
6393: p_stmt_num => l_stmt_num ,
6394: p_msg_tokens => l_msg_tokens,
6395: p_fnd_log_level => g_log_level_statement,

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

6399: ELSE
6400: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6401:
6402: l_msg_tokens.delete;
6403: WSM_log_PVT.logMessage(p_module_name => l_module ,
6404: p_msg_text => 'inv_genealogy_pub.insert_genealogy failed',
6405: p_stmt_num => l_stmt_num ,
6406: p_msg_tokens => l_msg_tokens,
6407: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

6455: -- error out...
6456: l_stmt_num := 395;
6457: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6458: l_msg_tokens.delete;
6459: WSM_log_PVT.logMessage(p_module_name => l_module ,
6460: p_msg_text => 'Insert_MMT_record failed',
6461: p_stmt_num => l_stmt_num ,
6462: p_msg_tokens => l_msg_tokens,
6463: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

6496:
6497: IF (l_err_code <> 0) THEN
6498: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6499: l_msg_tokens.delete;
6500: WSM_log_PVT.logMessage(p_module_name => l_module ,
6501: p_msg_text => 'UPDATE_ASSEMBLY_OR_ROUTING failed',
6502: p_stmt_num => l_stmt_num ,
6503: p_msg_tokens => l_msg_tokens,
6504: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

6527: IF (l_err_code <> 0) THEN
6528: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6529:
6530: l_msg_tokens.delete;
6531: WSM_log_PVT.logMessage(p_module_name => l_module ,
6532: p_msg_text => 'UPDATE_ASSEMBLY_OR_ROUTING failed',
6533: p_stmt_num => l_stmt_num ,
6534: p_msg_tokens => l_msg_tokens,
6535: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

6602: IF (l_err_code <> 0) THEN
6603: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6604:
6605: l_msg_tokens.delete;
6606: WSM_log_PVT.logMessage(p_module_name => l_module ,
6607: p_msg_text => 'CHANGE_QUANTITY failed',
6608: p_stmt_num => l_stmt_num ,
6609: p_msg_tokens => l_msg_tokens,
6610: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

6642: if l_err_code <> 0 then
6643: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6644:
6645: l_msg_tokens.delete;
6646: WSM_log_PVT.logMessage(p_module_name => l_module ,
6647: p_msg_text => 'UPDATE_QTY_ISSUED failed',
6648: p_stmt_num => l_stmt_num ,
6649: p_msg_tokens => l_msg_tokens,
6650: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

6680: IF (l_err_code <> 0) THEN
6681: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6682:
6683: l_msg_tokens.delete;
6684: WSM_log_PVT.logMessage(p_module_name => l_module ,
6685: p_msg_text => 'handle_kanban_sub_loc_change failed',
6686: p_stmt_num => l_stmt_num ,
6687: p_msg_tokens => l_msg_tokens,
6688: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

6721:
6722: l_msg_tokens.delete;
6723: l_msg_tokens(1).TokenName := 'STATUS';
6724: l_msg_tokens(1).TokenValue := g_translated_meaning;
6725: WSM_log_PVT.logMessage(p_module_name => l_module ,
6726: p_msg_name => 'WSM_KNBN_CARD_STS_FAIL',
6727: p_msg_appl_name => 'WSM' ,
6728: p_msg_tokens => l_msg_tokens ,
6729: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

6815: -- error out...
6816: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6817:
6818: l_msg_tokens.delete;
6819: WSM_log_PVT.logMessage(p_module_name => l_module ,
6820: p_msg_text => 'CALL_INF_SCH_OR_SET_SCH_DATA returned failure:'||l_err_code,
6821: p_stmt_num => l_stmt_num ,
6822: p_msg_tokens => l_msg_tokens,
6823: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

6879: l_stmt_num := 395;
6880: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6881:
6882: l_msg_tokens.delete;
6883: WSM_log_PVT.logMessage(p_module_name => l_module ,
6884: p_msg_text => 'Insert_MMT_record failed',
6885: p_stmt_num => l_stmt_num ,
6886: p_msg_tokens => l_msg_tokens,
6887: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

6903: l_stmt_num := 550;
6904:
6905: if( g_log_level_statement >= l_log_level ) then
6906: l_msg_tokens.delete;
6907: WSM_log_PVT.logMessage(p_module_name => l_module ,
6908: p_msg_text => 'Transaction type is Update Lotname:',
6909: p_stmt_num => l_stmt_num ,
6910: p_msg_tokens => l_msg_tokens,
6911: p_fnd_log_level => g_log_level_statement,

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

6955: else
6956: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6957:
6958: l_msg_tokens.delete;
6959: WSM_log_PVT.logMessage(p_module_name=> l_module ,
6960: p_msg_name => 'WSM_RESULT_LOT_REQUIRED',
6961: p_msg_appl_name => 'WSM',
6962: p_msg_tokens => l_msg_tokens ,
6963: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

6976: l_err_buf := null;
6977: --remove this
6978: if( g_log_level_statement >= l_log_level ) then
6979: l_msg_tokens.delete;
6980: WSM_log_PVT.logMessage(p_module_name => l_module ,
6981: p_msg_text => 'Calling WSMPLBJI.build_lbji_info procedure'||p_wltx_resulting_jobs_tbl(l_rj_index).class_code,
6982: p_stmt_num => l_stmt_num ,
6983: p_msg_tokens => l_msg_tokens,
6984: p_fnd_log_level => g_log_level_statement,

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

7072: --remove this
7073: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
7074:
7075: l_msg_tokens.delete;
7076: WSM_log_PVT.logMessage(p_module_name => l_module ,
7077: p_msg_text => 'Returned failure from WSMPLBJI.build_lbji_info procedure'||l_err_buf,
7078: p_stmt_num => l_stmt_num ,
7079: p_msg_tokens => l_msg_tokens,
7080: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

7086: ELSE
7087: -- success... now the program would have returned the id ....
7088: if( g_log_level_statement >= l_log_level ) then
7089: l_msg_tokens.delete;
7090: WSM_log_PVT.logMessage(p_module_name => l_module ,
7091: p_msg_text => 'Returned successfully from WSMPLBJI.build_lbji_info procedure',
7092: p_stmt_num => l_stmt_num ,
7093: p_msg_tokens => l_msg_tokens,
7094: p_fnd_log_level => g_log_level_statement,

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

7124: IF (l_err_code <> 0) THEN
7125: if( g_log_level_statement >= l_log_level ) then
7126:
7127: l_msg_tokens.delete;
7128: WSM_log_PVT.logMessage(p_module_name => l_module ,
7129: p_msg_text => 'Returned failure from CREATE_WSOR_WLBJ_RECORDS',
7130: p_stmt_num => l_stmt_num ,
7131: p_msg_tokens => l_msg_tokens,
7132: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

7137: RAISE FND_API.G_EXC_ERROR;
7138: ELSE
7139: if( g_log_level_statement >= l_log_level ) then
7140: l_msg_tokens.delete;
7141: WSM_log_PVT.logMessage(p_module_name => l_module ,
7142: p_msg_text => 'Created WSOR records for new job with id='||l_new_we_id,
7143: p_stmt_num => l_stmt_num ,
7144: p_msg_tokens => l_msg_tokens,
7145: p_fnd_log_level => g_log_level_statement,

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

7159: p_wltx_resulting_jobs_tbl(l_rj_index).job_operation_seq_num := l_bonus_job_st_op_seq;
7160:
7161: if( g_log_level_statement >= l_log_level ) then
7162: l_msg_tokens.delete;
7163: WSM_log_PVT.logMessage(p_module_name => l_module ,
7164: p_msg_text => 'Updated the job seq num in resulting job record : ' || l_bonus_job_st_op_seq,
7165: p_stmt_num => l_stmt_num ,
7166: p_msg_tokens => l_msg_tokens,
7167: p_fnd_log_level => g_log_level_statement,

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

7176: AND operation_seq_num = l_bonus_job_st_op_seq;
7177:
7178: if( g_log_level_statement >= l_log_level ) then
7179: l_msg_tokens.delete;
7180: WSM_log_PVT.logMessage(p_module_name => l_module ,
7181: p_msg_text => 'Updated the op seq num in wip_operations',
7182: p_stmt_num => l_stmt_num,
7183: p_msg_tokens => l_msg_tokens,
7184: p_fnd_log_level => g_log_level_statement,

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

7231: l_stmt_num := 110;
7232:
7233: if( g_log_level_statement >= l_log_level ) then
7234: l_msg_tokens.delete;
7235: WSM_log_PVT.logMessage(p_module_name => l_module ,
7236: p_msg_text => 'Checking for open a/c period',
7237: p_stmt_num => l_stmt_num,
7238: p_msg_tokens => l_msg_tokens,
7239: p_fnd_log_level => g_log_level_statement,

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

7253: /*error out*/
7254: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
7255:
7256: l_msg_tokens.delete;
7257: WSM_log_PVT.logMessage(p_module_name => l_module ,
7258: p_msg_text => 'Accounting Period not open',
7259: p_stmt_num => l_stmt_num ,
7260: p_msg_tokens => l_msg_tokens,
7261: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

7272: l_msg_data := null;
7273:
7274: if( g_log_level_statement >= l_log_level ) then
7275: l_msg_tokens.delete;
7276: WSM_log_PVT.logMessage(p_module_name => l_module ,
7277: p_msg_text => 'Inserting MMT record',
7278: p_stmt_num => l_stmt_num,
7279: p_msg_tokens => l_msg_tokens,
7280: p_fnd_log_level => g_log_level_statement,

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

7303: l_stmt_num := 395;
7304: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
7305:
7306: l_msg_tokens.delete;
7307: WSM_log_PVT.logMessage(p_module_name => l_module ,
7308: p_msg_text => 'Insert_MMT_record failed:'||l_msg_data,
7309: p_stmt_num => l_stmt_num ,
7310: p_msg_tokens => l_msg_tokens,
7311: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

7335: IF (l_err_code <> 0) THEN
7336: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
7337:
7338: l_msg_tokens.delete;
7339: WSM_log_PVT.logMessage(p_module_name => l_module ,
7340: p_msg_text => 'CREATE_COPIES_OR_SET_COPY_DATA returned failure ' || l_err_buf,
7341: p_stmt_num => l_stmt_num ,
7342: p_msg_tokens => l_msg_tokens,
7343: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

7381: -- error out....
7382: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
7383:
7384: l_msg_tokens.delete;
7385: WSM_log_PVT.logMessage(p_module_name => l_module ,
7386: p_msg_text => 'Invalid Txn type',
7387: p_stmt_num => l_stmt_num ,
7388: p_msg_tokens => l_msg_tokens,
7389: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

7428:
7429: if( g_log_level_statement >= l_log_level ) then
7430:
7431: l_msg_tokens.delete;
7432: WSM_log_PVT.logMessage(p_module_name => l_module ,
7433: p_msg_text => 'WSM_RESERVATIONS_PVT.Modify_reservations_jobupdate failed:'||l_msg_data,
7434: p_stmt_num => l_stmt_num ,
7435: p_msg_tokens => l_msg_tokens,
7436: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

7459: -- error out...
7460: if( g_log_level_statement >= l_log_level ) then
7461:
7462: l_msg_tokens.delete;
7463: WSM_log_PVT.logMessage(p_module_name => l_module ,
7464: p_msg_text => 'WSM_RESERVATIONS_PVT.modify_reservations_wlt failed:'||l_msg_data,
7465: p_stmt_num => l_stmt_num ,
7466: p_msg_tokens => l_msg_tokens,
7467: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

7493: l_stmt_num := 200;
7494: if( g_log_level_statement >= l_log_level ) then
7495:
7496: l_msg_tokens.delete;
7497: WSM_log_PVT.logMessage(p_module_name => l_module ,
7498: p_msg_text => 'WSM_RESERVATIONS_PVT.modify_reservations_wlt failed:'||l_msg_data,
7499: p_stmt_num => l_stmt_num ,
7500: p_msg_tokens => l_msg_tokens,
7501: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

7533:
7534: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
7535: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
7536: THEN
7537: WSM_log_PVT.handle_others( p_module_name => l_module ,
7538: p_stmt_num => l_stmt_num ,
7539: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
7540: p_run_log_level => l_log_level
7541: );

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

7551:
7552: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
7553: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
7554: THEN
7555: WSM_log_PVT.handle_others( p_module_name => l_module ,
7556: p_stmt_num => l_stmt_num ,
7557: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
7558: p_run_log_level => l_log_level
7559: );