APPS.INV_STAGED_RESERVATION_UTIL dependencies on FND_API

Line 15: x_return_status := fnd_api.g_ret_sts_success;

11: p_reservation_id IN NUMBER)
12: is
13: l_api_name CONSTANT VARCHAR2(30) := 'query_staged_flag';
14: BEGIN
15: x_return_status := fnd_api.g_ret_sts_success;
16:
17: SAVEPOINT query_stage_sa;
18:
19: select nvl(staged_flag,'N')

Line 25: WHEN fnd_api.g_exc_error THEN

21: from mtl_reservations
22: where reservation_id = p_reservation_id;
23:
24: EXCEPTION
25: WHEN fnd_api.g_exc_error THEN
26: ROLLBACK TO query_stage_sa;
27: x_return_status := fnd_api.g_ret_sts_error ;
28:
29: -- Get message count and data

Line 27: x_return_status := fnd_api.g_ret_sts_error ;

23:
24: EXCEPTION
25: WHEN fnd_api.g_exc_error THEN
26: ROLLBACK TO query_stage_sa;
27: x_return_status := fnd_api.g_ret_sts_error ;
28:
29: -- Get message count and data
30: fnd_msg_pub.count_and_get
31: ( p_count => x_msg_count

Line 34: WHEN fnd_api.g_exc_unexpected_error THEN

30: fnd_msg_pub.count_and_get
31: ( p_count => x_msg_count
32: , p_data => x_msg_data
33: );
34: WHEN fnd_api.g_exc_unexpected_error THEN
35: ROLLBACK TO query_stage_sa;
36: x_return_status := fnd_api.g_ret_sts_unexp_error ;
37:
38: -- Get message count and data

Line 36: x_return_status := fnd_api.g_ret_sts_unexp_error ;

32: , p_data => x_msg_data
33: );
34: WHEN fnd_api.g_exc_unexpected_error THEN
35: ROLLBACK TO query_stage_sa;
36: x_return_status := fnd_api.g_ret_sts_unexp_error ;
37:
38: -- Get message count and data
39: fnd_msg_pub.count_and_get
40: ( p_count => x_msg_count

Line 45: x_return_status := fnd_api.g_ret_sts_unexp_error ;

41: , p_data => x_msg_data
42: );
43: WHEN OTHERS THEN
44: ROLLBACK TO query_stage_sa;
45: x_return_status := fnd_api.g_ret_sts_unexp_error ;
46:
47: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
48: THEN
49: fnd_msg_pub.add_exc_msg

Line 72: x_return_status := fnd_api.g_ret_sts_success;

68: is
69: l_api_name CONSTANT VARCHAR2(30) := 'update_staged_flag';
70: l_ship_ready_flag NUMBER; -- Bug #2816312
71: BEGIN
72: x_return_status := fnd_api.g_ret_sts_success;
73: -- Bug #2816312. +5 lines.
74: -- Also updating the ship_ready_flag along with the staged_flag.
75: IF p_staged_flag = 'Y' THEN
76: l_ship_ready_flag := 1;

Line 89: WHEN fnd_api.g_exc_error THEN

85: ,ship_ready_flag = l_ship_ready_flag -- Bug #2816312
86: where reservation_id = p_reservation_id;
87:
88: EXCEPTION
89: WHEN fnd_api.g_exc_error THEN
90: ROLLBACK TO update_stage_sa;
91: x_return_status := fnd_api.g_ret_sts_error ;
92:
93: -- Get message count and data

Line 91: x_return_status := fnd_api.g_ret_sts_error ;

87:
88: EXCEPTION
89: WHEN fnd_api.g_exc_error THEN
90: ROLLBACK TO update_stage_sa;
91: x_return_status := fnd_api.g_ret_sts_error ;
92:
93: -- Get message count and data
94: fnd_msg_pub.count_and_get
95: ( p_count => x_msg_count

Line 98: WHEN fnd_api.g_exc_unexpected_error THEN

94: fnd_msg_pub.count_and_get
95: ( p_count => x_msg_count
96: , p_data => x_msg_data
97: );
98: WHEN fnd_api.g_exc_unexpected_error THEN
99: ROLLBACK TO update_stage_sa;
100: x_return_status := fnd_api.g_ret_sts_unexp_error ;
101:
102: -- Get message count and data

Line 100: x_return_status := fnd_api.g_ret_sts_unexp_error ;

96: , p_data => x_msg_data
97: );
98: WHEN fnd_api.g_exc_unexpected_error THEN
99: ROLLBACK TO update_stage_sa;
100: x_return_status := fnd_api.g_ret_sts_unexp_error ;
101:
102: -- Get message count and data
103: fnd_msg_pub.count_and_get
104: ( p_count => x_msg_count

Line 109: x_return_status := fnd_api.g_ret_sts_unexp_error ;

105: , p_data => x_msg_data
106: );
107: WHEN OTHERS THEN
108: ROLLBACK TO update_stage_sa;
109: x_return_status := fnd_api.g_ret_sts_unexp_error ;
110:
111: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
112: THEN
113: fnd_msg_pub.add_exc_msg