DBA Data[Home] [Help]

APPS.WSM_RESERVATIONS_PVT dependencies on FND_MSG_PUB

Line 20: g_msg_lvl_unexp_error NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ;

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 ;
23: g_msg_lvl_debug_high NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH ;
24: g_msg_lvl_debug_medium NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM ;

Line 21: g_msg_lvl_error NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR ;

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 ;
23: g_msg_lvl_debug_high NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH ;
24: g_msg_lvl_debug_medium NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM ;
25: g_msg_lvl_debug_low NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ;

Line 22: g_msg_lvl_success NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS ;

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 ;
23: g_msg_lvl_debug_high NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH ;
24: g_msg_lvl_debug_medium NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM ;
25: g_msg_lvl_debug_low NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ;
26:

Line 23: g_msg_lvl_debug_high NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH ;

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 ;
23: g_msg_lvl_debug_high NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH ;
24: g_msg_lvl_debug_medium NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM ;
25: g_msg_lvl_debug_low NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ;
26:
27: g_ret_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 24: g_msg_lvl_debug_medium NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM ;

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 ;
23: g_msg_lvl_debug_high NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH ;
24: g_msg_lvl_debug_medium NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM ;
25: g_msg_lvl_debug_low NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ;
26:
27: g_ret_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
28: g_ret_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

Line 25: g_msg_lvl_debug_low NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ;

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 ;
23: g_msg_lvl_debug_high NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH ;
24: g_msg_lvl_debug_medium NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM ;
25: g_msg_lvl_debug_low NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ;
26:
27: g_ret_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
28: g_ret_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
29: g_ret_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

Line 100: l_msg_index := fnd_msg_pub.count_msg;

96: l_return_status := FND_API.G_RET_STS_SUCCESS;
97: l_msg_count := 0;
98: l_msg_data := null;
99:
100: l_msg_index := fnd_msg_pub.count_msg;
101:
102: --MP Delete Changes Start
103: BEGIN
104: select *

Line 176: l_msg_index := fnd_msg_pub.count_msg;

172: l_return_status := FND_API.G_RET_STS_SUCCESS;
173: l_msg_count := 0;
174: l_msg_data := null;
175:
176: l_msg_index := fnd_msg_pub.count_msg;
177:
178: --log proc entry
179: --MP Delete Changes Start
180: BEGIN

Line 262: l_msg_index := fnd_msg_pub.count_msg;

258: l_return_status := FND_API.G_RET_STS_SUCCESS;
259: l_msg_count := 0;
260: l_msg_data := null;
261:
262: l_msg_index := fnd_msg_pub.count_msg;
263: --log proc entry
264: inv_maintain_reservation_pub.reduce_reservation
265: (
266: x_return_status => l_return_status

Line 309: l_msg_index := fnd_msg_pub.count_msg;

305: l_return_status := FND_API.G_RET_STS_SUCCESS;
306: l_msg_count := 0;
307: l_msg_data := null;
308:
309: l_msg_index := fnd_msg_pub.count_msg;
310: --log proc entry
311: --MP Delete Changes Start
312: BEGIN
313: select *

Line 423: l_msg_index := fnd_msg_pub.count_msg;

419: l_return_status := FND_API.G_RET_STS_SUCCESS;
420: l_msg_count := 0;
421: l_msg_data := null;
422:
423: l_msg_index := fnd_msg_pub.count_msg;
424:
425: inv_reservation_pub.transfer_reservation(
426: p_api_version_number => 1.0
427: , p_init_msg_lst => fnd_api.g_true

Line 479: l_msg_index := fnd_msg_pub.count_msg;

475: l_return_status := FND_API.G_RET_STS_SUCCESS;
476: l_msg_count := 0;
477: l_msg_data := null;
478:
479: l_msg_index := fnd_msg_pub.count_msg;
480: --log proc entry
481: --MP Delete Changes Start
482: BEGIN
483: select *

Line 580: FND_MSG_PUB.Count_And_Get

576: END IF; --Check on reserved quantity > net_quantity
577: end if;
578:
579: -- Standard call to get message count and if count is 1, get message info.
580: FND_MSG_PUB.Count_And_Get
581: ( p_encoded => 'F' ,
582: p_count => x_msg_count ,
583: p_data => x_msg_data
584: );

Line 592: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,

588: WHEN FND_API.G_EXC_ERROR THEN
589:
590: ROLLBACK TO start_modify_rsv_wlt;
591: x_return_status := G_RET_ERROR;
592: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
593: p_count => x_msg_count ,
594: p_data => x_msg_data
595: );
596:

Line 602: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,

598:
599: ROLLBACK TO start_modify_rsv_wlt;
600: x_return_status := G_RET_UNEXPECTED;
601:
602: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
603: p_count => x_msg_count ,
604: p_data => x_msg_data
605: );
606: WHEN OTHERS THEN

Line 612: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

608: ROLLBACK TO start_modify_rsv_wlt;
609: x_return_status := G_RET_UNEXPECTED;
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 ,

Line 621: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,

617: p_run_log_level => l_log_level
618: );
619: END IF;
620:
621: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
622: p_count => x_msg_count ,
623: p_data => x_msg_data
624: );
625: end;

Line 717: l_msg_index := fnd_msg_pub.count_msg;

713: l_return_status := FND_API.G_RET_STS_SUCCESS;
714: l_msg_count := 0;
715: l_msg_data := null;
716:
717: l_msg_index := fnd_msg_pub.count_msg;
718:
719: --inv_reservation_pub.reduce_reservations (
720: -- x_return_status => l_return_status
721: -- , x_msg_count =>l_msg_count

Line 855: l_msg_index := fnd_msg_pub.count_msg;

851: l_return_status := FND_API.G_RET_STS_SUCCESS;
852: l_msg_count := 0;
853: l_msg_data := null;
854:
855: l_msg_index := fnd_msg_pub.count_msg;
856:
857: inv_reservation_pub.transfer_reservation( p_api_version_number => 1.0
858: , p_init_msg_lst => fnd_api.g_true
859: , x_return_status => l_return_status

Line 911: FND_MSG_PUB.Count_And_Get

907: where wip_entity_id = p_wip_entity_id;
908: end if;
909:
910: -- Standard call to get message count and if count is 1, get message info.
911: FND_MSG_PUB.Count_And_Get
912: ( p_encoded => 'F' ,
913: p_count => x_msg_count ,
914: p_data => x_msg_data
915: );

Line 923: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,

919: WHEN FND_API.G_EXC_ERROR THEN
920:
921: ROLLBACK TO start_modify_rsv_move;
922: x_return_status := G_RET_ERROR;
923: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
924: p_count => x_msg_count ,
925: p_data => x_msg_data
926: );
927:

Line 933: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,

929:
930: ROLLBACK TO start_modify_rsv_move;
931: x_return_status := G_RET_UNEXPECTED;
932:
933: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
934: p_count => x_msg_count ,
935: p_data => x_msg_data
936: );
937: WHEN OTHERS THEN

Line 943: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

939: ROLLBACK TO start_modify_rsv_move;
940: x_return_status := G_RET_UNEXPECTED;
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 ,

Line 952: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,

948: p_run_log_level => l_log_level
949: );
950: END IF;
951:
952: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
953: p_count => x_msg_count ,
954: p_data => x_msg_data
955: );
956: end;

Line 1030: l_msg_index := fnd_msg_pub.count_msg;

1026: l_return_status := FND_API.G_RET_STS_SUCCESS;
1027: l_msg_count := 0;
1028: l_msg_data := null;
1029:
1030: l_msg_index := fnd_msg_pub.count_msg;
1031:
1032: --inv_reservation_pub.reduce_reservations (
1033: -- x_return_status => l_return_status
1034: -- , x_msg_count =>l_msg_count

Line 1065: l_msg_index := fnd_msg_pub.count_msg;

1061: l_return_status := FND_API.G_RET_STS_SUCCESS;
1062: l_msg_count := 0;
1063: l_msg_data := null;
1064:
1065: l_msg_index := fnd_msg_pub.count_msg;
1066: inv_maintain_reservation_pub.reduce_reservation
1067: (
1068: x_return_status => l_return_status
1069: , x_msg_count => l_msg_count

Line 1108: l_msg_index := fnd_msg_pub.count_msg;

1104: l_return_status := FND_API.G_RET_STS_SUCCESS;
1105: l_msg_count := 0;
1106: l_msg_data := null;
1107:
1108: l_msg_index := fnd_msg_pub.count_msg;
1109:
1110: --log proc entry
1111:
1112: -- START: Adding for bug fix 5347562.

Line 1178: l_msg_index := fnd_msg_pub.count_msg;

1174: l_return_status := FND_API.G_RET_STS_SUCCESS;
1175: l_msg_count := 0;
1176: l_msg_data := null;
1177:
1178: l_msg_index := fnd_msg_pub.count_msg;
1179: -- Commenting call to delete_reservation API for bug 5347562.
1180: /*
1181: inv_reservation_pub.delete_reservation
1182: (

Line 1240: FND_MSG_PUB.Count_And_Get

1236:
1237:
1238: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1239: -- Standard call to get message count and if count is 1, get message info.
1240: FND_MSG_PUB.Count_And_Get
1241: ( p_encoded => 'F' ,
1242: p_count => x_msg_count ,
1243: p_data => x_msg_data
1244: );

Line 1252: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,

1248: WHEN FND_API.G_EXC_ERROR THEN
1249:
1250: ROLLBACK TO start_modify_rsv_jobupdate;
1251: x_return_status := G_RET_ERROR;
1252: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
1253: p_count => x_msg_count ,
1254: p_data => x_msg_data
1255: );
1256:

Line 1262: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,

1258:
1259: ROLLBACK TO start_modify_rsv_jobupdate;
1260: x_return_status := G_RET_UNEXPECTED;
1261:
1262: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
1263: p_count => x_msg_count ,
1264: p_data => x_msg_data
1265: );
1266: WHEN OTHERS THEN

Line 1272: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

1268: ROLLBACK TO start_modify_rsv_jobupdate;
1269: x_return_status := G_RET_UNEXPECTED;
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 ,

Line 1281: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,

1277: p_run_log_level => l_log_level
1278: );
1279: END IF;
1280:
1281: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
1282: p_count => x_msg_count ,
1283: p_data => x_msg_data
1284: );
1285: end;