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_EXISTS',
3101: p_msg_appl_name => 'WSM' ,
3102: p_msg_tokens => l_msg_tokens ,
3103: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

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

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

3140:
3141: IF g_log_level_event >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_SUCCESS) then
3142:
3143: l_msg_tokens.delete;
3144: WSM_log_PVT.logMessage(p_module_name => l_module ,
3145: p_msg_name => 'WSM_PHANTOM_COMPONENTS_EXISTS',
3146: p_msg_appl_name => 'WSM' ,
3147: p_msg_tokens => l_msg_tokens ,
3148: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

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

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

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

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

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

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

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

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

3425:
3426: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
3427: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
3428: THEN
3429: WSM_log_PVT.handle_others( p_module_name => l_module ,
3430: p_stmt_num => l_stmt_num ,
3431: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
3432: p_run_log_level => l_log_level
3433: );

Line 3475: l_msg_tokens WSM_Log_PVT.token_rec_tbl;

3471: translated_meaning VARCHAR2(240); --abbkanban
3472: l_rtg_op_seq_num NUMBER;
3473:
3474: -- Logging variables.....
3475: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
3476: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3477:
3478: l_stmt_num NUMBER;
3479: l_module VARCHAR2(100) := 'wsm.plsql.WSMJUPDB.UPDATE_ASSEMBLY_OR_ROUTING';

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

3509: IF (x_err_code <> 0) THEN
3510: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
3511:
3512: l_msg_tokens.delete;
3513: WSM_log_PVT.logMessage(p_module_name => l_module ,
3514: p_msg_text => 'Handle_kanban_sub_loc_change returned error: ' || x_err_buf,
3515: p_stmt_num => l_stmt_num ,
3516: p_msg_tokens => l_msg_tokens,
3517: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

3579:
3580: l_msg_tokens.delete;
3581: l_msg_tokens(1).TokenName := 'STATUS';
3582: l_msg_tokens(1).TokenValue := g_translated_meaning;
3583: WSM_log_PVT.logMessage(p_module_name => l_module ,
3584: p_msg_name => 'WSM_KNBN_CARD_STS_FAIL',
3585: p_msg_appl_name => 'WSM' ,
3586: p_msg_tokens => l_msg_tokens ,
3587: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

3642: IF (x_err_code <> 0) THEN
3643: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
3644:
3645: l_msg_tokens.delete;
3646: WSM_log_PVT.logMessage(p_module_name => l_module ,
3647: p_msg_text => 'CHANGE_ROUTING returned error:'||x_err_buf,
3648: p_stmt_num => l_stmt_num ,
3649: p_msg_tokens => l_msg_tokens,
3650: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

3657:
3658: IF (l_new_op_added IS NOT NULL) THEN -- Added condition check for APS-WLT --
3659: if( g_log_level_statement >= l_log_level ) then
3660: l_msg_tokens.delete;
3661: WSM_log_PVT.logMessage(p_module_name => l_module ,
3662: p_msg_text => 'Added new operation sequence '||l_new_op_added||' to the job',
3663: p_stmt_num => l_stmt_num ,
3664: p_msg_tokens => l_msg_tokens,
3665: p_fnd_log_level => g_log_level_statement,

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

3751:
3752: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
3753: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
3754: THEN
3755: WSM_log_PVT.handle_others( p_module_name => l_module ,
3756: p_stmt_num => l_stmt_num ,
3757: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
3758: p_run_log_level => l_log_level
3759: );

Line 3792: l_msg_tokens WSM_Log_PVT.token_rec_tbl;

3788: l_err_code number;
3789: l_err_buf varchar2(2000);
3790:
3791: -- Logging variables.....
3792: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
3793: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3794:
3795: l_stmt_num NUMBER;
3796: l_module VARCHAR2(100) := 'wsm.plsql.WSMJUPDB.Insert_MMT_record';

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

3820: IF (l_err_code <> 0) THEN
3821: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
3822:
3823: l_msg_tokens.delete;
3824: WSM_log_PVT.logMessage(p_module_name => l_module ,
3825: p_msg_text => 'WSMPUTIL.GET_INV_ACCT_PERIOD returned error:' || l_err_buf,
3826: p_stmt_num => l_stmt_num ,
3827: p_msg_tokens => l_msg_tokens,
3828: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

3921:
3922: l_msg_tokens.delete;
3923: l_msg_tokens(1).TokenName := 'ELEMENT';
3924: l_msg_tokens(1).TokenValue := 'mtl_material_transactions';
3925: WSM_log_PVT.logMessage(p_module_name => l_module ,
3926: p_msg_name => 'WSM_INS_TBL_FAILED',
3927: p_msg_appl_name => 'WSM' ,
3928: p_msg_tokens => l_msg_tokens ,
3929: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

3959: x_return_status := fnd_api.g_ret_sts_error;
3960: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) THEN
3961:
3962: l_msg_tokens.delete;
3963: WSM_log_PVT.logMessage (p_module_name => l_module ,
3964: p_msg_text => SUBSTRB('Unexpected Error : SQLCODE '|| SQLCODE ||' : SQLERRM : '|| SQLERRM, 1, 2000),
3965: p_stmt_num => l_stmt_num ,
3966: p_msg_tokens => l_msg_tokens ,
3967: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

3972:
3973: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
3974: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
3975: THEN
3976: WSM_log_PVT.handle_others( p_module_name => l_module ,
3977: p_stmt_num => l_stmt_num ,
3978: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
3979: p_run_log_level => l_log_level
3980: );

Line 4017: l_msg_tokens WSM_Log_PVT.token_rec_tbl;

4013: l_sj_counter NUMBER;
4014: l_rep_wip_entity_id NUMBER;
4015:
4016: -- Logging variables.....
4017: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
4018: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4019:
4020: l_stmt_num NUMBER;
4021: l_module VARCHAR2(100) := 'wsm.plsql.WSMPJUPDB.CREATE_COPIES_OR_SET_COPY_DATA';

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

4115: x_err_code := 0; -- Fix for bug #3421662 --
4116: ELSE
4117: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
4118: l_msg_tokens.delete;
4119: WSM_log_PVT.logMessage(p_module_name => l_module ,
4120: p_msg_text => 'WSM_JobCopies_PVT.Create_JobCopies returned error:' || x_err_buf,
4121: p_stmt_num => l_stmt_num ,
4122: p_msg_tokens => l_msg_tokens,
4123: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

4129: END IF;
4130:
4131: if( g_log_level_statement >= l_log_level ) then
4132: l_msg_tokens.delete;
4133: WSM_log_PVT.logMessage(p_module_name => l_module ,
4134: p_msg_text => 'WSM_JobCopies_PVT.Create_JobCopies returned success',
4135: p_stmt_num => l_stmt_num ,
4136: p_msg_tokens => l_msg_tokens,
4137: p_fnd_log_level => g_log_level_statement,

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

4149: WHERE wip_entity_id = p_wltx_resulting_jobs_tbl(l_rj_counter).wip_entity_id;
4150:
4151: if( g_log_level_statement >= l_log_level ) then
4152: l_msg_tokens.delete;
4153: WSM_log_PVT.logMessage(p_module_name => l_module ,
4154: p_msg_text => 'Set internal_copy_type = 2 for we_id=',
4155: p_stmt_num => l_stmt_num ,
4156: p_msg_tokens => l_msg_tokens,
4157: p_fnd_log_level => g_log_level_statement,

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

4200: l_stmt_num := 60;
4201:
4202: if( g_log_level_statement >= l_log_level ) then
4203: l_msg_tokens.delete;
4204: WSM_log_PVT.logMessage(p_module_name => l_module ,
4205: p_msg_text => 'new we_id :'||p_wltx_resulting_jobs_tbl(l_job_counter).wip_entity_id||
4206: 'rep_job_we_id :'||l_rep_wip_entity_id,
4207: p_stmt_num => l_stmt_num ,
4208: p_msg_tokens => l_msg_tokens,

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

4233: IF (x_err_code <> 0) THEN
4234: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
4235:
4236: l_msg_tokens.delete;
4237: WSM_log_PVT.logMessage(p_module_name => l_module ,
4238: p_msg_text => 'WSM_JobCopies_PVT.Create_RepJobCopies returned error:' || x_err_buf,
4239: p_stmt_num => l_stmt_num ,
4240: p_msg_tokens => l_msg_tokens,
4241: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

4249: l_stmt_num := 70;
4250:
4251: if( g_log_level_statement >= l_log_level ) then
4252: l_msg_tokens.delete;
4253: WSM_log_PVT.logMessage(p_module_name => l_module ,
4254: p_msg_text => 'WSM_JobCopies_PVT.Create_RepJobCopies returned success',
4255: p_stmt_num => l_stmt_num ,
4256: p_msg_tokens => l_msg_tokens,
4257: p_fnd_log_level => g_log_level_statement,

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

4268: WHERE wip_entity_id = p_wltx_resulting_jobs_tbl(l_job_counter).wip_entity_id;
4269:
4270: if( g_log_level_statement >= l_log_level ) then
4271: l_msg_tokens.delete;
4272: WSM_log_PVT.logMessage(p_module_name => l_module ,
4273: p_msg_text => 'Set internal_copy_type = '||l_new_job_int_copy_type||' for we_id=',
4274: p_stmt_num => l_stmt_num ,
4275: p_msg_tokens => l_msg_tokens,
4276: p_fnd_log_level => g_log_level_statement,

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

4287: WHERE wip_entity_id = p_wltx_resulting_jobs_tbl(l_job_counter).wip_entity_id;
4288:
4289: if( g_log_level_statement >= l_log_level ) then
4290: l_msg_tokens.delete;
4291: WSM_log_PVT.logMessage(p_module_name => l_module ,
4292: p_msg_text => 'Set copy_parent_wip_entity_id = '||nvl(l_rep_job_par_we_id, l_rep_wip_entity_id)||' for we_id=',
4293: p_stmt_num => l_stmt_num ,
4294: p_msg_tokens => l_msg_tokens,
4295: p_fnd_log_level => g_log_level_statement,

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

4378: ELSE
4379: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
4380:
4381: l_msg_tokens.delete;
4382: WSM_log_PVT.logMessage(p_module_name => l_module ,
4383: p_msg_text => 'WSM_JobCopies_PVT.Create_JobCopies returned error:' || x_err_buf,
4384: p_stmt_num => l_stmt_num ,
4385: p_msg_tokens => l_msg_tokens,
4386: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

4392: END IF;
4393:
4394: if( g_log_level_statement >= l_log_level ) then
4395: l_msg_tokens.delete;
4396: WSM_log_PVT.logMessage(p_module_name => l_module ,
4397: p_msg_text => 'WSM_JobCopies_PVT.Create_JobCopies returned success',
4398: p_stmt_num => l_stmt_num ,
4399: p_msg_tokens => l_msg_tokens,
4400: p_fnd_log_level => g_log_level_statement,

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

4411: WHERE wip_entity_id = p_wltx_resulting_jobs_tbl(l_job_counter).wip_entity_id;
4412:
4413: if( g_log_level_statement >= l_log_level ) then
4414: l_msg_tokens.delete;
4415: WSM_log_PVT.logMessage(p_module_name => l_module ,
4416: p_msg_text => 'Set internal_copy_type = 2 for we_id=',
4417: p_stmt_num => l_stmt_num ,
4418: p_msg_tokens => l_msg_tokens,
4419: p_fnd_log_level => g_log_level_statement,

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

4510: ELSE
4511: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
4512:
4513: l_msg_tokens.delete;
4514: WSM_log_PVT.logMessage(p_module_name => l_module ,
4515: p_msg_text => 'WSM_JobCopies_PVT.Create_JobCopies returned error:' || x_err_buf,
4516: p_stmt_num => l_stmt_num ,
4517: p_msg_tokens => l_msg_tokens,
4518: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

4524: END IF;
4525:
4526: if( g_log_level_statement >= l_log_level ) then
4527: l_msg_tokens.delete;
4528: WSM_log_PVT.logMessage(p_module_name => l_module ,
4529: p_msg_text => 'WSM_JobCopies_PVT.Create_JobCopies returned success',
4530: p_stmt_num => l_stmt_num ,
4531: p_msg_tokens => l_msg_tokens,
4532: p_fnd_log_level => g_log_level_statement,

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

4542: WHERE wip_entity_id = l_rep_wip_entity_id;
4543:
4544: if( g_log_level_statement >= l_log_level ) then
4545: l_msg_tokens.delete;
4546: WSM_log_PVT.logMessage(p_module_name => l_module ,
4547: p_msg_text => 'Set internal_copy_type = 2 for we_id='||l_rep_wip_entity_id,
4548: p_stmt_num => l_stmt_num ,
4549: p_msg_tokens => l_msg_tokens,
4550: p_fnd_log_level => g_log_level_statement,

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

4592:
4593: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
4594: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
4595: THEN
4596: WSM_log_PVT.handle_others( p_module_name => l_module ,
4597: p_stmt_num => l_stmt_num ,
4598: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
4599: p_run_log_level => l_log_level
4600: );

Line 4633: l_msg_tokens WSM_Log_PVT.token_rec_tbl;

4629: l_job_op_comp_dt DATE;
4630: l_returnStatus VARCHAR2(1);
4631: x_msg_count number;
4632: -- Logging variables.....
4633: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
4634: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4635:
4636: l_stmt_num NUMBER;
4637: l_module VARCHAR2(100) := 'wsm.plsql.WSMPJUPDB.CALL_INF_SCH_OR_SET_SCH_DATA';

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

4666:
4667: IF (x_err_code <> 0) THEN
4668: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
4669: l_msg_tokens.delete;
4670: WSM_log_PVT.logMessage(p_module_name => l_module ,
4671: p_msg_text => 'GET_JOB_CURR_OP_INFO returned error:' || x_err_buf,
4672: p_stmt_num => l_stmt_num ,
4673: p_msg_tokens => l_msg_tokens,
4674: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

4703: IF(l_returnStatus <> FND_API.G_RET_STS_SUCCESS) THEN
4704: x_err_code := -1;
4705: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
4706: l_msg_tokens.delete;
4707: WSM_log_PVT.logMessage(p_module_name => l_module ,
4708: p_msg_text => 'WSM_infinite_scheduler_PVT.schedule returned error:' || x_err_buf,
4709: p_stmt_num => l_stmt_num ,
4710: p_msg_tokens => l_msg_tokens,
4711: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

4757:
4758: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
4759: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
4760: THEN
4761: WSM_log_PVT.handle_others( p_module_name => l_module ,
4762: p_stmt_num => l_stmt_num ,
4763: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
4764: p_run_log_level => l_log_level
4765: );

Line 4846: l_msg_tokens WSM_log_PVT.token_rec_tbl;

4842: l_msg_data varchar2(2000);
4843:
4844: /*logging variables*/
4845: l_stmt_num number := 0;
4846: l_msg_tokens WSM_log_PVT.token_rec_tbl;
4847: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4848: l_module VARCHAR2(100) := 'wsm.plsql.WSMPJUPD.process_lots';
4849: l_schedule_group_id NUMBER; -- Bug 6676148
4850:

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

5027: --remove this
5028:
5029: if( g_log_level_statement >= l_log_level ) then
5030: l_msg_tokens.delete;
5031: WSM_log_PVT.logMessage(p_module_name => l_module ,
5032: p_msg_text => 'Calling WSMPLBJI.build_lbji_info procedure',
5033: p_stmt_num => l_stmt_num ,
5034: p_msg_tokens => l_msg_tokens,
5035: p_fnd_log_level => g_log_level_statement,

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

5123:
5124: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
5125:
5126: l_msg_tokens.delete;
5127: WSM_log_PVT.logMessage(p_module_name => l_module ,
5128: p_msg_text => 'Returned failure from WSMPLBJI.build_lbji_info procedure' ,
5129: p_stmt_num => l_stmt_num ,
5130: p_msg_tokens => l_msg_tokens,
5131: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

5137: ELSE
5138: -- success... now the program would have returned the id ....
5139: if( g_log_level_statement >= l_log_level ) then
5140: l_msg_tokens.delete;
5141: WSM_log_PVT.logMessage(p_module_name => l_module ,
5142: p_msg_text => 'Returned successfully from WSMPLBJI.build_lbji_info procedure',
5143: p_stmt_num => l_stmt_num ,
5144: p_msg_tokens => l_msg_tokens,
5145: p_fnd_log_level => g_log_level_statement,

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

5161: l_err_buf := null;
5162:
5163: if( g_log_level_statement >= l_log_level ) then
5164: l_msg_tokens.delete;
5165: WSM_log_PVT.logMessage(p_module_name => l_module ,
5166: p_msg_text => 'Calling WSM_lbj_interface_PVT.build_job_header_info',
5167: p_stmt_num => l_stmt_num ,
5168: p_msg_tokens => l_msg_tokens,
5169: p_fnd_log_level => g_log_level_statement,

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

5254: IF (l_err_code <> 0) THEN
5255: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
5256:
5257: l_msg_tokens.delete;
5258: WSM_log_PVT.logMessage(p_module_name => l_module ,
5259: p_msg_text => 'Returned failure from WSM_lbj_interface_PVT.build_job_header_info'||l_err_buf,
5260: p_stmt_num => l_stmt_num ,
5261: p_msg_tokens => l_msg_tokens,
5262: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

5269: ELSE
5270: -- success... now the program would have returned the id ....
5271: if( g_log_level_statement >= l_log_level ) then
5272: l_msg_tokens.delete;
5273: WSM_log_PVT.logMessage(p_module_name => l_module ,
5274: p_msg_text => 'Returned success from WSM_lbj_interface_PVT.build_job_header_info',
5275: p_stmt_num => l_stmt_num ,
5276: p_msg_tokens => l_msg_tokens,
5277: p_fnd_log_level => g_log_level_statement,

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

5314: -- this means this kanban_card_id is inherited by resulting job, while examining the starting jobs
5315: -- do not set the kanban card to Exception just because the qties of the starting jobs have become 0
5316: if( g_log_level_statement >= l_log_level ) then
5317: l_msg_tokens.delete;
5318: WSM_log_PVT.logMessage(p_module_name => l_module ,
5319: p_msg_text => 'Calling INV_Kanban_PVT.Update_Card_Supply_Status',
5320: p_stmt_num => l_stmt_num ,
5321: p_msg_tokens => l_msg_tokens,
5322: p_fnd_log_level => g_log_level_statement,

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

5338:
5339: l_msg_tokens.delete;
5340: l_msg_tokens(1).TokenName := 'STATUS';
5341: l_msg_tokens(1).TokenValue := g_translated_meaning;
5342: WSM_log_PVT.logMessage(p_module_name => l_module ,
5343: p_msg_name => 'WSM_KNBN_CARD_STS_FAIL',
5344: p_msg_appl_name => 'WSM' ,
5345: p_msg_tokens => l_msg_tokens ,
5346: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

5382: l_stmt_num := 220;
5383:
5384: if( g_log_level_statement >= l_log_level ) then
5385: l_msg_tokens.delete;
5386: WSM_log_PVT.logMessage(p_module_name => l_module ,
5387: p_msg_text => 'Calling COPY_REP_JOB_WO_FA ' || p_wltx_starting_jobs_tbl(l_rep_sj_index).operation_seq_num,
5388: p_stmt_num => l_stmt_num ,
5389: p_msg_tokens => l_msg_tokens,
5390: p_fnd_log_level => g_log_level_statement,

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

5410: IF (l_err_code <> 0) THEN
5411: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
5412:
5413: l_msg_tokens.delete;
5414: WSM_log_PVT.logMessage(p_module_name => l_module ,
5415: p_msg_text => 'Returned failure from COPY_REP_JOB_WO_FA',
5416: p_stmt_num => l_stmt_num ,
5417: p_msg_tokens => l_msg_tokens,
5418: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

5426:
5427: l_stmt_num := 230;
5428: if( g_log_level_statement >= l_log_level ) then
5429: l_msg_tokens.delete;
5430: WSM_log_PVT.logMessage(p_module_name => l_module ,
5431: p_msg_text => 'Calling COPY_REP_JOB_WOR ',
5432: p_stmt_num => l_stmt_num ,
5433: p_msg_tokens => l_msg_tokens,
5434: p_fnd_log_level => g_log_level_statement,

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

5449: IF (l_err_code <> 0) THEN
5450: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
5451:
5452: l_msg_tokens.delete;
5453: WSM_log_PVT.logMessage(p_module_name => l_module ,
5454: p_msg_text => 'Returned failure from COPY_REP_JOB_WOR',
5455: p_stmt_num => l_stmt_num ,
5456: p_msg_tokens => l_msg_tokens,
5457: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

5475: ELSE -- Copies are to be made i.e. Option C
5476: -- Make copies immediately or at the end
5477: if( g_log_level_statement >= l_log_level ) then
5478: l_msg_tokens.delete;
5479: WSM_log_PVT.logMessage(p_module_name => l_module ,
5480: p_msg_text => 'Calling COPY_REP_JOB_WSOR ',
5481: p_stmt_num => l_stmt_num ,
5482: p_msg_tokens => l_msg_tokens,
5483: p_fnd_log_level => g_log_level_statement,

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

5496: IF (l_err_code <> 0) THEN
5497: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
5498:
5499: l_msg_tokens.delete;
5500: WSM_log_PVT.logMessage(p_module_name => l_module ,
5501: p_msg_text => 'Returned failure from COPY_REP_JOB_WSOR',
5502: p_stmt_num => l_stmt_num ,
5503: p_msg_tokens => l_msg_tokens,
5504: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

5527: IF (l_err_code <> 0) THEN
5528: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
5529:
5530: l_msg_tokens.delete;
5531: WSM_log_PVT.logMessage(p_module_name => l_module ,
5532: p_msg_text => 'Returned failure from COPY_REP_JOB_WORI',
5533: p_stmt_num => l_stmt_num,
5534: p_msg_tokens => l_msg_tokens,
5535: p_fnd_msg_level => G_MSG_LVL_ERROR,

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

5543:
5544: l_stmt_num := 250;
5545: if( g_log_level_statement >= l_log_level ) then
5546: l_msg_tokens.delete;
5547: WSM_log_PVT.logMessage(p_module_name => l_module,
5548: p_msg_text => 'Calling COPY_REP_JOB_WRO',
5549: p_stmt_num => l_stmt_num,
5550: p_msg_tokens => l_msg_tokens,
5551: p_fnd_log_level => g_log_level_statement,

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

5570: IF (l_err_code <> 0) THEN
5571: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
5572:
5573: l_msg_tokens.delete;
5574: WSM_log_PVT.logMessage(p_module_name => l_module ,
5575: p_msg_text => 'Returned failure from COPY_REP_JOB_WRO',
5576: p_stmt_num => l_stmt_num ,
5577: p_msg_tokens => l_msg_tokens,
5578: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

5586:
5587: l_stmt_num := 260;
5588: if( g_log_level_statement >= l_log_level ) then
5589: l_msg_tokens.delete;
5590: WSM_log_PVT.logMessage(p_module_name => l_module ,
5591: p_msg_text => 'Calling COPY_REP_JOB_WOY ',
5592: p_stmt_num => l_stmt_num ,
5593: p_msg_tokens => l_msg_tokens,
5594: p_fnd_log_level => g_log_level_statement,

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

5609:
5610: IF (l_err_code <> 0) THEN
5611: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
5612: l_msg_tokens.delete;
5613: WSM_log_PVT.logMessage(p_module_name => l_module ,
5614: p_msg_text => 'Returned failure from COPY_REP_JOB_WOY',
5615: p_stmt_num => l_stmt_num ,
5616: p_msg_tokens => l_msg_tokens,
5617: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

5624:
5625: -- ok now process the starting jobs...
5626: if( g_log_level_statement >= l_log_level ) then
5627: l_msg_tokens.delete;
5628: WSM_log_PVT.logMessage(p_module_name => l_module ,
5629: p_msg_text => ' processing the starting jobs...',
5630: p_stmt_num => l_stmt_num ,
5631: p_msg_tokens => l_msg_tokens,
5632: p_fnd_log_level => g_log_level_statement,

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

5646: (l_sj_also_rj_index is not null)
5647: then -- indicates that the starting job is also a resulting job
5648: if( g_log_level_statement >= l_log_level ) then
5649: l_msg_tokens.delete;
5650: WSM_log_PVT.logMessage(p_module_name => l_module ,
5651: p_msg_text => 'Representative Starting Job ' || p_wltx_starting_jobs_tbl(l_job_counter).wip_entity_name
5652: || ' is also a resulting job..'
5653: || ' Starting Job index(l_job_counter) : ' || l_job_counter
5654: || ' Resulting Job index(l_sj_also_rj_index) : ' || l_sj_also_rj_index,

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

5689:
5690: l_stmt_num := 120;
5691: if( g_log_level_statement >= l_log_level ) then
5692: l_msg_tokens.delete;
5693: WSM_log_PVT.logMessage(p_module_name => l_module ,
5694: p_msg_text => ' Calling INV_Kanban_PVT.Update_Card_Supply_Status...',
5695: p_stmt_num => l_stmt_num ,
5696: p_msg_tokens => l_msg_tokens,
5697: p_fnd_log_level => g_log_level_statement,

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

5711:
5712: l_msg_tokens.delete;
5713: l_msg_tokens(1).TokenName := 'STATUS';
5714: l_msg_tokens(1).TokenValue := g_translated_meaning;
5715: WSM_log_PVT.logMessage(p_module_name => l_module ,
5716: p_msg_name => 'WSM_KNBN_CARD_STS_FAIL',
5717: p_msg_appl_name => 'WSM' ,
5718: p_msg_tokens => l_msg_tokens ,
5719: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

5730: else
5731: -- now check if the resulting job has changed
5732: if( g_log_level_statement >= l_log_level ) then
5733: l_msg_tokens.delete;
5734: WSM_log_PVT.logMessage(p_module_name => l_module ,
5735: p_msg_text => ' Calling handle_kanban_sub_loc_change...',
5736: p_stmt_num => l_stmt_num ,
5737: p_msg_tokens => l_msg_tokens,
5738: p_fnd_log_level => g_log_level_statement,

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

5756: IF (l_err_code <> 0) THEN
5757: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
5758:
5759: l_msg_tokens.delete;
5760: WSM_log_PVT.logMessage(p_module_name => l_module ,
5761: p_msg_text => 'Returned failure from handle_kanban_sub_loc_change',
5762: p_stmt_num => l_stmt_num ,
5763: p_msg_tokens => l_msg_tokens,
5764: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

5778:
5779: l_stmt_num := 147;
5780: if( g_log_level_statement >= l_log_level ) then
5781: l_msg_tokens.delete;
5782: WSM_log_PVT.logMessage(p_module_name => l_module ,
5783: p_msg_text => ' Calling INV_Kanban_PVT.Update_Card_Supply_Status...',
5784: p_stmt_num => l_stmt_num ,
5785: p_msg_tokens => l_msg_tokens,
5786: p_fnd_log_level => g_log_level_statement,

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

5803:
5804: l_msg_tokens.delete;
5805: l_msg_tokens(1).TokenName := 'STATUS';
5806: l_msg_tokens(1).TokenValue := g_translated_meaning;
5807: WSM_log_PVT.logMessage(p_module_name => l_module ,
5808: p_msg_name => 'WSM_KNBN_CARD_STS_FAIL',
5809: p_msg_appl_name => 'WSM' ,
5810: p_msg_tokens => l_msg_tokens ,
5811: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

5827: p_wltx_resulting_jobs_tbl(l_sj_also_rj_index).kanban_card_id := l_kanban_card_id;
5828:
5829: if( g_log_level_statement >= l_log_level ) then
5830: l_msg_tokens.delete;
5831: WSM_log_PVT.logMessage(p_module_name => l_module ,
5832: p_msg_text => 'Updating the completion subinv and the kanban card id ...',
5833: p_stmt_num => l_stmt_num ,
5834: p_msg_tokens => l_msg_tokens,
5835: p_fnd_log_level => g_log_level_statement,

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

5852:
5853: l_stmt_num := 160;
5854: if( g_log_level_statement >= l_log_level ) then
5855: l_msg_tokens.delete;
5856: WSM_log_PVT.logMessage(p_module_name => l_module ,
5857: p_msg_text => 'starting job has been completely merged/split or a non-representative job... ',
5858: p_stmt_num => l_stmt_num ,
5859: p_msg_tokens => l_msg_tokens,
5860: p_fnd_log_level => g_log_level_statement,

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

5909:
5910: l_msg_tokens.delete;
5911: l_msg_tokens(1).TokenName := 'STATUS';
5912: l_msg_tokens(1).TokenValue := g_translated_meaning;
5913: WSM_log_PVT.logMessage(p_module_name => l_module ,
5914: p_msg_name => 'WSM_KNBN_CARD_STS_FAIL',
5915: p_msg_appl_name => 'WSM' ,
5916: p_msg_tokens => l_msg_tokens ,
5917: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

5966: if l_err_buf is null then
5967: l_err_buf := 'Returned failure from WSMPOPRN.update_job_name';
5968: end if;
5969: /* End bugfix 5738550 */
5970: WSM_log_PVT.logMessage(p_module_name => l_module ,
5971: p_msg_text => l_err_buf , /* Bugfix 5738550 removed hardcoding */
5972: p_stmt_num => l_stmt_num ,
5973: p_msg_tokens => l_msg_tokens,
5974: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

5980: else
5981: -- success.. got the new name for the job ...
5982: if( g_log_level_statement >= l_log_level ) then
5983: l_msg_tokens.delete;
5984: WSM_log_PVT.logMessage(p_module_name => l_module ,
5985: p_msg_text => 'WSMPOPRN.update_job_name success.Got new job name',
5986: p_stmt_num => l_stmt_num ,
5987: p_msg_tokens => l_msg_tokens,
5988: p_fnd_log_level => g_log_level_statement,

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

6001:
6002: l_stmt_num := 210;
6003: if( g_log_level_statement >= l_log_level ) then
6004: l_msg_tokens.delete;
6005: WSM_log_PVT.logMessage(p_module_name => l_module ,
6006: p_msg_text => 'Calling CHANGE_QUANTITY',
6007: p_stmt_num => l_stmt_num ,
6008: p_msg_tokens => l_msg_tokens,
6009: p_fnd_log_level => g_log_level_statement,

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

6034:
6035: IF (l_err_code <> 0) THEN
6036: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6037: l_msg_tokens.delete;
6038: WSM_log_PVT.logMessage(p_module_name => l_module ,
6039: p_msg_text => 'CHANGE_QUANTITY returned failure' ,
6040: p_stmt_num => l_stmt_num ,
6041: p_msg_tokens => l_msg_tokens,
6042: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

6049:
6050: l_stmt_num := 270;
6051: if( g_log_level_statement >= l_log_level ) then
6052: l_msg_tokens.delete;
6053: WSM_log_PVT.logMessage(p_module_name => l_module ,
6054: p_msg_text => 'Calling UPDATE_QTY_ISSUED',
6055: p_stmt_num => l_stmt_num ,
6056: p_msg_tokens => l_msg_tokens,
6057: p_fnd_log_level => g_log_level_statement,

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

6079: if l_err_code <> 0 then
6080: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6081:
6082: l_msg_tokens.delete;
6083: WSM_log_PVT.logMessage(p_module_name => l_module ,
6084: p_msg_text => 'UPDATE_QTY_ISSUED returned failure' ,
6085: p_stmt_num => l_stmt_num ,
6086: p_msg_tokens => l_msg_tokens,
6087: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

6104:
6105: l_stmt_num := 290;
6106: if( g_log_level_statement >= l_log_level ) then
6107: l_msg_tokens.delete;
6108: WSM_log_PVT.logMessage(p_module_name => l_module ,
6109: p_msg_text => 'Calling UPDATE_ASSEMBLY_OR_ROUTING',
6110: p_stmt_num => l_stmt_num ,
6111: p_msg_tokens => l_msg_tokens,
6112: p_fnd_log_level => g_log_level_statement,

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

6136: IF (l_err_code <> 0) THEN
6137: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6138:
6139: l_msg_tokens.delete;
6140: WSM_log_PVT.logMessage(p_module_name => l_module ,
6141: p_msg_text => 'UPDATE_ASSEMBLY_OR_ROUTING returned failure' ,
6142: p_stmt_num => l_stmt_num ,
6143: p_msg_tokens => l_msg_tokens,
6144: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

6210: IF (l_err_code <> 0) THEN
6211: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6212:
6213: l_msg_tokens.delete;
6214: WSM_log_PVT.logMessage(p_module_name => l_module ,
6215: p_msg_text => 'CREATE_COPIES_OR_SET_COPY_DATA returned '||l_err_code,
6216: p_stmt_num => l_stmt_num ,
6217: p_msg_tokens => l_msg_tokens,
6218: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

6251: -- error out...
6252: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6253:
6254: l_msg_tokens.delete;
6255: WSM_log_PVT.logMessage(p_module_name => l_module ,
6256: p_msg_text => ' CALL_INF_SCH_OR_SET_SCH_DATA returned '||l_err_code,
6257: p_stmt_num => l_stmt_num ,
6258: p_msg_tokens => l_msg_tokens,
6259: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

6345: l_stmt_num := 360;
6346: IF (l_ret_status = 'S') THEN
6347: if( g_log_level_statement >= l_log_level ) then
6348: l_msg_tokens.delete;
6349: WSM_log_PVT.logMessage(p_module_name => l_module ,
6350: p_msg_text => 'inv_genealogy_pub.insert_genealogy returned success',
6351: p_stmt_num => l_stmt_num ,
6352: p_msg_tokens => l_msg_tokens,
6353: p_fnd_log_level => g_log_level_statement,

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

6359:
6360: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6361:
6362: l_msg_tokens.delete;
6363: WSM_log_PVT.logMessage(p_module_name => l_module ,
6364: p_msg_text => 'inv_genealogy_pub.insert_genealogy failed',
6365: p_stmt_num => l_stmt_num ,
6366: p_msg_tokens => l_msg_tokens,
6367: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

6451: l_stmt_num := 374;
6452: IF (l_ret_status = 'S') THEN
6453: if( g_log_level_statement >= l_log_level ) then
6454: l_msg_tokens.delete;
6455: WSM_log_PVT.logMessage(p_module_name => l_module ,
6456: p_msg_text => 'inv_genealogy_pub.insert_genealogy returned success',
6457: p_stmt_num => l_stmt_num ,
6458: p_msg_tokens => l_msg_tokens,
6459: p_fnd_log_level => g_log_level_statement,

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

6463: ELSE
6464: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6465:
6466: l_msg_tokens.delete;
6467: WSM_log_PVT.logMessage(p_module_name => l_module ,
6468: p_msg_text => 'inv_genealogy_pub.insert_genealogy failed',
6469: p_stmt_num => l_stmt_num ,
6470: p_msg_tokens => l_msg_tokens,
6471: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

6519: -- error out...
6520: l_stmt_num := 395;
6521: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6522: l_msg_tokens.delete;
6523: WSM_log_PVT.logMessage(p_module_name => l_module ,
6524: p_msg_text => 'Insert_MMT_record failed',
6525: p_stmt_num => l_stmt_num ,
6526: p_msg_tokens => l_msg_tokens,
6527: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

6560:
6561: IF (l_err_code <> 0) THEN
6562: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6563: l_msg_tokens.delete;
6564: WSM_log_PVT.logMessage(p_module_name => l_module ,
6565: p_msg_text => 'UPDATE_ASSEMBLY_OR_ROUTING failed',
6566: p_stmt_num => l_stmt_num ,
6567: p_msg_tokens => l_msg_tokens,
6568: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

6591: IF (l_err_code <> 0) THEN
6592: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6593:
6594: l_msg_tokens.delete;
6595: WSM_log_PVT.logMessage(p_module_name => l_module ,
6596: p_msg_text => 'CREATE_COPIES_OR_SET_COPY_DATA failed',
6597: p_stmt_num => l_stmt_num ,
6598: p_msg_tokens => l_msg_tokens,
6599: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

6666: IF (l_err_code <> 0) THEN
6667: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6668:
6669: l_msg_tokens.delete;
6670: WSM_log_PVT.logMessage(p_module_name => l_module ,
6671: p_msg_text => 'CHANGE_QUANTITY failed',
6672: p_stmt_num => l_stmt_num ,
6673: p_msg_tokens => l_msg_tokens,
6674: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

6706: if l_err_code <> 0 then
6707: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6708:
6709: l_msg_tokens.delete;
6710: WSM_log_PVT.logMessage(p_module_name => l_module ,
6711: p_msg_text => 'UPDATE_QTY_ISSUED failed',
6712: p_stmt_num => l_stmt_num ,
6713: p_msg_tokens => l_msg_tokens,
6714: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

6744: IF (l_err_code <> 0) THEN
6745: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6746:
6747: l_msg_tokens.delete;
6748: WSM_log_PVT.logMessage(p_module_name => l_module ,
6749: p_msg_text => 'handle_kanban_sub_loc_change failed',
6750: p_stmt_num => l_stmt_num ,
6751: p_msg_tokens => l_msg_tokens,
6752: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

6785:
6786: l_msg_tokens.delete;
6787: l_msg_tokens(1).TokenName := 'STATUS';
6788: l_msg_tokens(1).TokenValue := g_translated_meaning;
6789: WSM_log_PVT.logMessage(p_module_name => l_module ,
6790: p_msg_name => 'WSM_KNBN_CARD_STS_FAIL',
6791: p_msg_appl_name => 'WSM' ,
6792: p_msg_tokens => l_msg_tokens ,
6793: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

6879: -- error out...
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 => 'CALL_INF_SCH_OR_SET_SCH_DATA returned failure:'||l_err_code,
6885: p_stmt_num => l_stmt_num ,
6886: p_msg_tokens => l_msg_tokens,
6887: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

6943: l_stmt_num := 395;
6944: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6945:
6946: l_msg_tokens.delete;
6947: WSM_log_PVT.logMessage(p_module_name => l_module ,
6948: p_msg_text => 'Insert_MMT_record failed',
6949: p_stmt_num => l_stmt_num ,
6950: p_msg_tokens => l_msg_tokens,
6951: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

6967: l_stmt_num := 550;
6968:
6969: if( g_log_level_statement >= l_log_level ) then
6970: l_msg_tokens.delete;
6971: WSM_log_PVT.logMessage(p_module_name => l_module ,
6972: p_msg_text => 'Transaction type is Update Lotname:',
6973: p_stmt_num => l_stmt_num ,
6974: p_msg_tokens => l_msg_tokens,
6975: p_fnd_log_level => g_log_level_statement,

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

7019: else
7020: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
7021:
7022: l_msg_tokens.delete;
7023: WSM_log_PVT.logMessage(p_module_name=> l_module ,
7024: p_msg_name => 'WSM_RESULT_LOT_REQUIRED',
7025: p_msg_appl_name => 'WSM',
7026: p_msg_tokens => l_msg_tokens ,
7027: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

7040: l_err_buf := null;
7041: --remove this
7042: if( g_log_level_statement >= l_log_level ) then
7043: l_msg_tokens.delete;
7044: WSM_log_PVT.logMessage(p_module_name => l_module ,
7045: p_msg_text => 'Calling WSMPLBJI.build_lbji_info procedure'||p_wltx_resulting_jobs_tbl(l_rj_index).class_code,
7046: p_stmt_num => l_stmt_num ,
7047: p_msg_tokens => l_msg_tokens,
7048: p_fnd_log_level => g_log_level_statement,

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

7136: --remove this
7137: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
7138:
7139: l_msg_tokens.delete;
7140: WSM_log_PVT.logMessage(p_module_name => l_module ,
7141: p_msg_text => 'Returned failure from WSMPLBJI.build_lbji_info procedure'||l_err_buf,
7142: p_stmt_num => l_stmt_num ,
7143: p_msg_tokens => l_msg_tokens,
7144: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

7150: ELSE
7151: -- success... now the program would have returned the id ....
7152: if( g_log_level_statement >= l_log_level ) then
7153: l_msg_tokens.delete;
7154: WSM_log_PVT.logMessage(p_module_name => l_module ,
7155: p_msg_text => 'Returned successfully from WSMPLBJI.build_lbji_info procedure',
7156: p_stmt_num => l_stmt_num ,
7157: p_msg_tokens => l_msg_tokens,
7158: p_fnd_log_level => g_log_level_statement,

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

7188: IF (l_err_code <> 0) THEN
7189: if( g_log_level_statement >= l_log_level ) then
7190:
7191: l_msg_tokens.delete;
7192: WSM_log_PVT.logMessage(p_module_name => l_module ,
7193: p_msg_text => 'Returned failure from CREATE_WSOR_WLBJ_RECORDS',
7194: p_stmt_num => l_stmt_num ,
7195: p_msg_tokens => l_msg_tokens,
7196: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

7201: RAISE FND_API.G_EXC_ERROR;
7202: ELSE
7203: if( g_log_level_statement >= l_log_level ) then
7204: l_msg_tokens.delete;
7205: WSM_log_PVT.logMessage(p_module_name => l_module ,
7206: p_msg_text => 'Created WSOR records for new job with id='||l_new_we_id,
7207: p_stmt_num => l_stmt_num ,
7208: p_msg_tokens => l_msg_tokens,
7209: p_fnd_log_level => g_log_level_statement,

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

7223: p_wltx_resulting_jobs_tbl(l_rj_index).job_operation_seq_num := l_bonus_job_st_op_seq;
7224:
7225: if( g_log_level_statement >= l_log_level ) then
7226: l_msg_tokens.delete;
7227: WSM_log_PVT.logMessage(p_module_name => l_module ,
7228: p_msg_text => 'Updated the job seq num in resulting job record : ' || l_bonus_job_st_op_seq,
7229: p_stmt_num => l_stmt_num ,
7230: p_msg_tokens => l_msg_tokens,
7231: p_fnd_log_level => g_log_level_statement,

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

7240: AND operation_seq_num = l_bonus_job_st_op_seq;
7241:
7242: if( g_log_level_statement >= l_log_level ) then
7243: l_msg_tokens.delete;
7244: WSM_log_PVT.logMessage(p_module_name => l_module ,
7245: p_msg_text => 'Updated the op seq num in wip_operations',
7246: p_stmt_num => l_stmt_num,
7247: p_msg_tokens => l_msg_tokens,
7248: p_fnd_log_level => g_log_level_statement,

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

7295: l_stmt_num := 110;
7296:
7297: if( g_log_level_statement >= l_log_level ) then
7298: l_msg_tokens.delete;
7299: WSM_log_PVT.logMessage(p_module_name => l_module ,
7300: p_msg_text => 'Checking for open a/c period',
7301: p_stmt_num => l_stmt_num,
7302: p_msg_tokens => l_msg_tokens,
7303: p_fnd_log_level => g_log_level_statement,

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

7317: /*error out*/
7318: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
7319:
7320: l_msg_tokens.delete;
7321: WSM_log_PVT.logMessage(p_module_name => l_module ,
7322: p_msg_text => 'Accounting Period not open',
7323: p_stmt_num => l_stmt_num ,
7324: p_msg_tokens => l_msg_tokens,
7325: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

7336: l_msg_data := null;
7337:
7338: if( g_log_level_statement >= l_log_level ) then
7339: l_msg_tokens.delete;
7340: WSM_log_PVT.logMessage(p_module_name => l_module ,
7341: p_msg_text => 'Inserting MMT record',
7342: p_stmt_num => l_stmt_num,
7343: p_msg_tokens => l_msg_tokens,
7344: p_fnd_log_level => g_log_level_statement,

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

7367: l_stmt_num := 395;
7368: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
7369:
7370: l_msg_tokens.delete;
7371: WSM_log_PVT.logMessage(p_module_name => l_module ,
7372: p_msg_text => 'Insert_MMT_record failed:'||l_msg_data,
7373: p_stmt_num => l_stmt_num ,
7374: p_msg_tokens => l_msg_tokens,
7375: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

7399: IF (l_err_code <> 0) THEN
7400: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
7401:
7402: l_msg_tokens.delete;
7403: WSM_log_PVT.logMessage(p_module_name => l_module ,
7404: p_msg_text => 'CREATE_COPIES_OR_SET_COPY_DATA returned failure ' || l_err_buf,
7405: p_stmt_num => l_stmt_num ,
7406: p_msg_tokens => l_msg_tokens,
7407: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

7445: -- error out....
7446: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
7447:
7448: l_msg_tokens.delete;
7449: WSM_log_PVT.logMessage(p_module_name => l_module ,
7450: p_msg_text => 'Invalid Txn type',
7451: p_stmt_num => l_stmt_num ,
7452: p_msg_tokens => l_msg_tokens,
7453: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

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

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

7523: -- error out...
7524: if( g_log_level_statement >= l_log_level ) then
7525:
7526: l_msg_tokens.delete;
7527: WSM_log_PVT.logMessage(p_module_name => l_module ,
7528: p_msg_text => 'WSM_RESERVATIONS_PVT.modify_reservations_wlt failed:'||l_msg_data,
7529: p_stmt_num => l_stmt_num ,
7530: p_msg_tokens => l_msg_tokens,
7531: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

7557: l_stmt_num := 200;
7558: if( g_log_level_statement >= l_log_level ) then
7559:
7560: l_msg_tokens.delete;
7561: WSM_log_PVT.logMessage(p_module_name => l_module ,
7562: p_msg_text => 'WSM_RESERVATIONS_PVT.modify_reservations_wlt failed:'||l_msg_data,
7563: p_stmt_num => l_stmt_num ,
7564: p_msg_tokens => l_msg_tokens,
7565: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

7597:
7598: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
7599: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
7600: THEN
7601: WSM_log_PVT.handle_others( p_module_name => l_module ,
7602: p_stmt_num => l_stmt_num ,
7603: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
7604: p_run_log_level => l_log_level
7605: );

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

7615:
7616: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
7617: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
7618: THEN
7619: WSM_log_PVT.handle_others( p_module_name => l_module ,
7620: p_stmt_num => l_stmt_num ,
7621: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
7622: p_run_log_level => l_log_level
7623: );