DBA Data[Home] [Help]

APPS.WSM_RESERVATIONS_PVT dependencies on FND_LOG

Line 13: g_log_level_unexpected NUMBER := FND_LOG.LEVEL_UNEXPECTED ;

9: --type r_mtl_rsv_rec_type is record of mtl_reservations%rowtype;
10: --MP: Sale order changes
11: l_mtl_rsv_rec inv_reservation_global.mtl_maintain_rsv_rec_type;
12:
13: g_log_level_unexpected NUMBER := FND_LOG.LEVEL_UNEXPECTED ;
14: g_log_level_error number := FND_LOG.LEVEL_ERROR ;
15: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;
16: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
17: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;

Line 14: g_log_level_error number := FND_LOG.LEVEL_ERROR ;

10: --MP: Sale order changes
11: l_mtl_rsv_rec inv_reservation_global.mtl_maintain_rsv_rec_type;
12:
13: g_log_level_unexpected NUMBER := FND_LOG.LEVEL_UNEXPECTED ;
14: g_log_level_error number := FND_LOG.LEVEL_ERROR ;
15: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;
16: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
17: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;
18: g_log_level_statement number := FND_LOG.LEVEL_STATEMENT ;

Line 15: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;

11: l_mtl_rsv_rec inv_reservation_global.mtl_maintain_rsv_rec_type;
12:
13: g_log_level_unexpected NUMBER := FND_LOG.LEVEL_UNEXPECTED ;
14: g_log_level_error number := FND_LOG.LEVEL_ERROR ;
15: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;
16: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
17: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;
18: g_log_level_statement number := FND_LOG.LEVEL_STATEMENT ;
19:

Line 16: g_log_level_event number := FND_LOG.LEVEL_EVENT ;

12:
13: g_log_level_unexpected NUMBER := FND_LOG.LEVEL_UNEXPECTED ;
14: g_log_level_error number := FND_LOG.LEVEL_ERROR ;
15: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;
16: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
17: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;
18: g_log_level_statement number := FND_LOG.LEVEL_STATEMENT ;
19:
20: g_msg_lvl_unexp_error NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ;

Line 17: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;

13: g_log_level_unexpected NUMBER := FND_LOG.LEVEL_UNEXPECTED ;
14: g_log_level_error number := FND_LOG.LEVEL_ERROR ;
15: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;
16: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
17: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;
18: g_log_level_statement number := FND_LOG.LEVEL_STATEMENT ;
19:
20: g_msg_lvl_unexp_error NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ;
21: g_msg_lvl_error NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR ;

Line 18: g_log_level_statement number := FND_LOG.LEVEL_STATEMENT ;

14: g_log_level_error number := FND_LOG.LEVEL_ERROR ;
15: g_log_level_exception number := FND_LOG.LEVEL_EXCEPTION ;
16: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
17: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;
18: g_log_level_statement number := FND_LOG.LEVEL_STATEMENT ;
19:
20: g_msg_lvl_unexp_error NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ;
21: g_msg_lvl_error NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR ;
22: g_msg_lvl_success NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS ;

Line 57: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

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';
61: l_param_tbl WSM_Log_PVT.param_tbl_type;

Line 139: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,

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 ,
140: p_run_log_level => l_log_level
141: );
142: END IF;
143:

Line 215: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,

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 ,
216: p_run_log_level => l_log_level
217: );
218: END IF;
219:

Line 287: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,

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 ,
288: p_run_log_level => l_log_level
289: );
290: END IF;
291: IF l_return_status = fnd_api.g_ret_sts_error THEN

Line 349: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,

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 ,
350: p_run_log_level => l_log_level
351: );
352: END IF;
353: IF l_return_status = fnd_api.g_ret_sts_error THEN

Line 451: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,

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 ,
452: p_run_log_level => l_log_level
453: );
454: END IF;
455: IF l_return_status = fnd_api.g_ret_sts_error THEN

Line 517: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,

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 ,
518: p_run_log_level => l_log_level
519: );
520: END IF;
521: IF l_return_status = fnd_api.g_ret_sts_error THEN

Line 570: p_fnd_log_level => G_LOG_LEVEL_ERROR ,

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 ,
570: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
571: p_run_log_level => l_log_level
572: );
573: END IF;
574: RAISE FND_API.G_EXC_ERROR;

Line 616: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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: );
619: END IF;
620:

Line 657: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

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';
661: l_param_tbl WSM_Log_PVT.param_tbl_type;

Line 753: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,

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 ,
754: p_run_log_level => l_log_level
755: );
756: END IF;
757: IF l_return_status = fnd_api.g_ret_sts_error THEN

Line 882: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,

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 ,
883: p_run_log_level => l_log_level
884: );
885: END IF;
886: IF l_return_status = fnd_api.g_ret_sts_error THEN

Line 947: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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: );
950: END IF;
951:

Line 984: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

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';
988: l_param_tbl WSM_Log_PVT.param_tbl_type;

Line 1088: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,

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 ,
1089: p_run_log_level => l_log_level
1090: );
1091: END IF;
1092: IF l_return_status = fnd_api.g_ret_sts_error THEN

Line 1159: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,

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 ,
1160: p_run_log_level => l_log_level
1161: );
1162: END IF;
1163: IF l_return_status = fnd_api.g_ret_sts_error THEN

Line 1225: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,

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 ,
1226: p_run_log_level => l_log_level
1227: );
1228: END IF;
1229: IF l_return_status = fnd_api.g_ret_sts_error THEN

Line 1276: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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: );
1279: END IF;
1280: