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

Line 56: l_msg_tokens WSM_Log_PVT.token_rec_tbl;

52: l_msg_count NUMBER;
53: l_msg_data VARCHAR2(2000);
54:
55: -- Logging variables.....
56: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
57: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
58:
59: l_stmt_num NUMBER;
60: l_module CONSTANT VARCHAR2(100) := 'wsm.plsql.WSM_RESERVATIONS_PVT.modify_reservations_wlt';

Line 61: l_param_tbl WSM_Log_PVT.param_tbl_type;

57: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
58:
59: l_stmt_num NUMBER;
60: l_module CONSTANT VARCHAR2(100) := 'wsm.plsql.WSM_RESERVATIONS_PVT.modify_reservations_wlt';
61: l_param_tbl WSM_Log_PVT.param_tbl_type;
62:
63: l_msg_index number;
64: l_quantity_modified NUMBER;
65: l_expected_quantity_uom VARCHAR2(3);

Line 131: WSM_log_PVT.update_errtbl(l_msg_index,l_msg_count);

127:
128: --proc exit
129: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
130: /*API failed*/
131: WSM_log_PVT.update_errtbl(l_msg_index,l_msg_count);
132: --log that rsv api failed
133: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
134: l_msg_tokens.delete;
135: WSM_log_PVT.logMessage (p_module_name => l_module ,

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

131: WSM_log_PVT.update_errtbl(l_msg_index,l_msg_count);
132: --log that rsv api failed
133: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
134: l_msg_tokens.delete;
135: WSM_log_PVT.logMessage (p_module_name => l_module ,
136: p_msg_text => 'inv_reservation_pub.delete_reservation failed',
137: p_stmt_num => l_stmt_num ,
138: p_msg_tokens => l_msg_tokens ,
139: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,

Line 207: WSM_log_PVT.update_errtbl(l_msg_index,l_msg_count);

203: );
204:
205: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
206: --API failed--
207: WSM_log_PVT.update_errtbl(l_msg_index,l_msg_count);
208: --log that rsv api failed
209: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
210: l_msg_tokens.delete;
211: WSM_log_PVT.logMessage (p_module_name => l_module ,

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

207: WSM_log_PVT.update_errtbl(l_msg_index,l_msg_count);
208: --log that rsv api failed
209: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
210: l_msg_tokens.delete;
211: WSM_log_PVT.logMessage (p_module_name => l_module ,
212: p_msg_text => 'inv_reservation_pub.delete_reservation failed',
213: p_stmt_num => l_stmt_num ,
214: p_msg_tokens => l_msg_tokens ,
215: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,

Line 279: WSM_log_PVT.update_errtbl(l_msg_index,l_msg_count);

275: );
276:
277: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
278: --API failed--
279: WSM_log_PVT.update_errtbl(l_msg_index,l_msg_count);
280: --log that rsv api failed
281: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
282: l_msg_tokens.delete;
283: WSM_log_PVT.logMessage (p_module_name => l_module ,

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

279: WSM_log_PVT.update_errtbl(l_msg_index,l_msg_count);
280: --log that rsv api failed
281: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
282: l_msg_tokens.delete;
283: WSM_log_PVT.logMessage (p_module_name => l_module ,
284: p_msg_text => 'inv_reservation_pub.reduce_reservation failed',
285: p_stmt_num => l_stmt_num ,
286: p_msg_tokens => l_msg_tokens ,
287: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,

Line 341: WSM_log_PVT.update_errtbl(l_msg_index,l_msg_count);

337: --log return
338:
339: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
340: --API failed--
341: WSM_log_PVT.update_errtbl(l_msg_index,l_msg_count);
342: --log that rsv api failed
343: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
344: l_msg_tokens.delete;
345: WSM_log_PVT.logMessage (p_module_name => l_module ,

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

341: WSM_log_PVT.update_errtbl(l_msg_index,l_msg_count);
342: --log that rsv api failed
343: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
344: l_msg_tokens.delete;
345: WSM_log_PVT.logMessage (p_module_name => l_module ,
346: p_msg_text => 'inv_reservation_pub.delete_reservation failed',
347: p_stmt_num => l_stmt_num ,
348: p_msg_tokens => l_msg_tokens ,
349: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,

Line 443: WSM_log_PVT.update_errtbl(l_msg_index,l_msg_count);

439:
440: --proc exit
441: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
442: --API failed--
443: WSM_log_PVT.update_errtbl(l_msg_index,l_msg_count);
444: --log that rsv api failed
445: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
446: l_msg_tokens.delete;
447: WSM_log_PVT.logMessage (p_module_name => l_module ,

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

443: WSM_log_PVT.update_errtbl(l_msg_index,l_msg_count);
444: --log that rsv api failed
445: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
446: l_msg_tokens.delete;
447: WSM_log_PVT.logMessage (p_module_name => l_module ,
448: p_msg_text => 'inv_reservation_pub.transfer_reservation failed',
449: p_stmt_num => l_stmt_num ,
450: p_msg_tokens => l_msg_tokens ,
451: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,

Line 509: WSM_log_PVT.update_errtbl(l_msg_index,l_msg_count);

505:
506: --proc exit
507: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
508: --API failed--
509: WSM_log_PVT.update_errtbl(l_msg_index,l_msg_count);
510: --log that rsv api failed
511: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
512: l_msg_tokens.delete;
513: WSM_log_PVT.logMessage (p_module_name => l_module ,

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

509: WSM_log_PVT.update_errtbl(l_msg_index,l_msg_count);
510: --log that rsv api failed
511: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
512: l_msg_tokens.delete;
513: WSM_log_PVT.logMessage (p_module_name => l_module ,
514: p_msg_text => 'inv_reservation_pub.reduce_reservation failed',
515: p_stmt_num => l_stmt_num ,
516: p_msg_tokens => l_msg_tokens ,
517: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,

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

561:
562: if( g_log_level_statement >= l_log_level ) then
563:
564: l_msg_tokens.delete;
565: WSM_log_PVT.logMessage(p_module_name => l_module ,
566: p_msg_text => 'WSM_RESERVATIONS_PVT.Modify_reservations_jobupdate failed:'||l_msg_data,
567: p_stmt_num => l_stmt_num ,
568: p_msg_tokens => l_msg_tokens,
569: p_fnd_msg_level => G_MSG_LVL_ERROR ,

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

610:
611: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
612: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
613: THEN
614: WSM_log_PVT.handle_others( p_module_name => l_module ,
615: p_stmt_num => l_stmt_num ,
616: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
617: p_run_log_level => l_log_level
618: );

Line 656: l_msg_tokens WSM_Log_PVT.token_rec_tbl;

652:
653: l_status_type NUMBER; -- Added for bug 5286219
654:
655: -- Logging variables.....
656: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
657: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
658:
659: l_stmt_num NUMBER;
660: l_module CONSTANT VARCHAR2(100) := 'wsm.plsql.WSM_ITEM_PVT.ProcA';

Line 661: l_param_tbl WSM_Log_PVT.param_tbl_type;

657: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
658:
659: l_stmt_num NUMBER;
660: l_module CONSTANT VARCHAR2(100) := 'wsm.plsql.WSM_ITEM_PVT.ProcA';
661: l_param_tbl WSM_Log_PVT.param_tbl_type;
662:
663: l_msg_index number;
664: -- Logging variables...
665:

Line 745: WSM_log_PVT.update_errtbl(l_msg_index,l_msg_count);

741: , p_sort_by_criteria => null
742: );
743: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
744: /*API failed*/
745: WSM_log_PVT.update_errtbl(l_msg_index,l_msg_count);
746: --log that rsv api failed
747: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
748: l_msg_tokens.delete;
749: WSM_log_PVT.logMessage (p_module_name => l_module ,

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

745: WSM_log_PVT.update_errtbl(l_msg_index,l_msg_count);
746: --log that rsv api failed
747: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
748: l_msg_tokens.delete;
749: WSM_log_PVT.logMessage (p_module_name => l_module ,
750: p_msg_text => 'inv_reservation_pub.reduce_reservation failed',
751: p_stmt_num => l_stmt_num ,
752: p_msg_tokens => l_msg_tokens ,
753: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,

Line 874: WSM_log_PVT.update_errtbl(l_msg_index,l_msg_count);

870:
871: --proc exit
872: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
873: /*API failed*/
874: WSM_log_PVT.update_errtbl(l_msg_index,l_msg_count);
875: --log that rsv api failed
876: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
877: l_msg_tokens.delete;
878: WSM_log_PVT.logMessage (p_module_name => l_module ,

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

874: WSM_log_PVT.update_errtbl(l_msg_index,l_msg_count);
875: --log that rsv api failed
876: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
877: l_msg_tokens.delete;
878: WSM_log_PVT.logMessage (p_module_name => l_module ,
879: p_msg_text => 'inv_reservation_pub.transfer_reservation failed',
880: p_stmt_num => l_stmt_num ,
881: p_msg_tokens => l_msg_tokens ,
882: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,

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

941:
942: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
943: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
944: THEN
945: WSM_log_PVT.handle_others( p_module_name => l_module ,
946: p_stmt_num => l_stmt_num ,
947: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
948: p_run_log_level => l_log_level
949: );

Line 983: l_msg_tokens WSM_Log_PVT.token_rec_tbl;

979: l_msg_count NUMBER;
980: l_msg_data VARCHAR2(2000);
981:
982: -- Logging variables.....
983: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
984: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
985:
986: l_stmt_num NUMBER;
987: l_module CONSTANT VARCHAR2(100) := 'wsm.plsql.WSM_RESERVATIONS_PVT.modify_reservations_jobupdate';

Line 988: l_param_tbl WSM_Log_PVT.param_tbl_type;

984: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
985:
986: l_stmt_num NUMBER;
987: l_module CONSTANT VARCHAR2(100) := 'wsm.plsql.WSM_RESERVATIONS_PVT.modify_reservations_jobupdate';
988: l_param_tbl WSM_Log_PVT.param_tbl_type;
989:
990: l_msg_index number;
991: -- Logging variables...
992:

Line 1080: WSM_log_PVT.update_errtbl(l_msg_index,l_msg_count);

1076: , p_sort_by_criteria => null
1077: );
1078: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1079: /*API failed*/
1080: WSM_log_PVT.update_errtbl(l_msg_index,l_msg_count);
1081: --log that rsv api failed
1082: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
1083: l_msg_tokens.delete;
1084: WSM_log_PVT.logMessage (p_module_name => l_module ,

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

1080: WSM_log_PVT.update_errtbl(l_msg_index,l_msg_count);
1081: --log that rsv api failed
1082: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
1083: l_msg_tokens.delete;
1084: WSM_log_PVT.logMessage (p_module_name => l_module ,
1085: p_msg_text => 'inv_reservation_pub.reduce_reservation failed',
1086: p_stmt_num => l_stmt_num ,
1087: p_msg_tokens => l_msg_tokens ,
1088: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,

Line 1151: WSM_log_PVT.update_errtbl(l_msg_index,l_msg_count);

1147:
1148: --proc exit
1149: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1150: /*API failed*/
1151: WSM_log_PVT.update_errtbl(l_msg_index,l_msg_count);
1152: --log that rsv api failed
1153: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
1154: l_msg_tokens.delete;
1155: WSM_log_PVT.logMessage (p_module_name => l_module ,

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

1151: WSM_log_PVT.update_errtbl(l_msg_index,l_msg_count);
1152: --log that rsv api failed
1153: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
1154: l_msg_tokens.delete;
1155: WSM_log_PVT.logMessage (p_module_name => l_module ,
1156: p_msg_text => 'inv_maintain_reservation_pub.reduce_reservation',
1157: p_stmt_num => l_stmt_num ,
1158: p_msg_tokens => l_msg_tokens ,
1159: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,

Line 1217: WSM_log_PVT.update_errtbl(l_msg_index,l_msg_count);

1213: , p_sort_by_criteria => null
1214: );
1215: -- END: Adding for bug fix 5347562.
1216: if l_return_status <> FND_API.G_RET_STS_SUCCESS then /*API failed*/
1217: WSM_log_PVT.update_errtbl(l_msg_index,l_msg_count);
1218: --log that rsv api failed
1219: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
1220: l_msg_tokens.delete;
1221: WSM_log_PVT.logMessage (p_module_name => l_module ,

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

1217: WSM_log_PVT.update_errtbl(l_msg_index,l_msg_count);
1218: --log that rsv api failed
1219: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
1220: l_msg_tokens.delete;
1221: WSM_log_PVT.logMessage (p_module_name => l_module ,
1222: p_msg_text => 'inv_maintain_reservation_pub.reduce_reservation',
1223: p_stmt_num => l_stmt_num ,
1224: p_msg_tokens => l_msg_tokens ,
1225: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,

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

1270:
1271: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
1272: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
1273: THEN
1274: WSM_log_PVT.handle_others( p_module_name => l_module ,
1275: p_stmt_num => l_stmt_num ,
1276: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
1277: p_run_log_level => l_log_level
1278: );