39: x_return_status => l_return_status,
40: x_msg_count => x_msg_count,
41: x_msg_data => x_msg_data);
42:
43: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
44: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
45: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
46: RAISE FND_API.G_EXC_ERROR;
47: END IF;
40: x_msg_count => x_msg_count,
41: x_msg_data => x_msg_data);
42:
43: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
44: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
45: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
46: RAISE FND_API.G_EXC_ERROR;
47: END IF;
48:
41: x_msg_data => x_msg_data);
42:
43: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
44: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
45: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
46: RAISE FND_API.G_EXC_ERROR;
47: END IF;
48:
49: END IF;
42:
43: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
44: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
45: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
46: RAISE FND_API.G_EXC_ERROR;
47: END IF;
48:
49: END IF;
50:
86: , p_x_line_tbl => l_line_tbl );
87:
88: Oe_Order_Pvt.Process_Requests_And_Notify
89: ( p_process_requests => TRUE
90: , p_init_msg_list => FND_API.G_TRUE
91: , p_notify => TRUE
92: , x_return_status => l_return_status
93: );
94:
92: , x_return_status => l_return_status
93: );
94:
95:
96: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
97: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
98: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
99: RAISE FND_API.G_EXC_ERROR;
100: END IF;
93: );
94:
95:
96: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
97: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
98: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
99: RAISE FND_API.G_EXC_ERROR;
100: END IF;
101:
94:
95:
96: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
97: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
98: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
99: RAISE FND_API.G_EXC_ERROR;
100: END IF;
101:
102: -- x_cascade_flag := OE_GLOBALS.G_CASCADING_REQUEST_LOGGED;
95:
96: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
97: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
98: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
99: RAISE FND_API.G_EXC_ERROR;
100: END IF;
101:
102: -- x_cascade_flag := OE_GLOBALS.G_CASCADING_REQUEST_LOGGED;
103: -- Re-set the UI flag to FALSE
104: OE_GLOBALS.G_UI_FLAG := FALSE;
105:
106: -- Set return status.
107:
108: x_return_status := FND_API.G_RET_STS_SUCCESS;
109:
110: -- Get message count and data
111:
112: OE_MSG_PUB.Count_And_Get
122: -- This call should come back with a message OE_ORDER_BOOKED
123: -- if booking completed successfully and if booking was deferred,
124: -- message OE_ORDER_BOOK_DEFERRED is added to the stack.
125: -- If booking was not successful, it should come back with a
126: -- return status of FND_API.G_RET_STS_ERROR or
127: -- FND_API.G_RET_STS_UNEXP_ERROR
128: OE_Order_Book_Util.Complete_Book_Eligible
129: ( p_api_version_number => 1.0
130: , p_init_msg_list => FND_API.G_TRUE
123: -- if booking completed successfully and if booking was deferred,
124: -- message OE_ORDER_BOOK_DEFERRED is added to the stack.
125: -- If booking was not successful, it should come back with a
126: -- return status of FND_API.G_RET_STS_ERROR or
127: -- FND_API.G_RET_STS_UNEXP_ERROR
128: OE_Order_Book_Util.Complete_Book_Eligible
129: ( p_api_version_number => 1.0
130: , p_init_msg_list => FND_API.G_TRUE
131: , p_header_id => p_header_id
126: -- return status of FND_API.G_RET_STS_ERROR or
127: -- FND_API.G_RET_STS_UNEXP_ERROR
128: OE_Order_Book_Util.Complete_Book_Eligible
129: ( p_api_version_number => 1.0
130: , p_init_msg_list => FND_API.G_TRUE
131: , p_header_id => p_header_id
132: , x_return_status => l_return_status
133: , x_msg_count => x_msg_count
134: , x_msg_data => x_msg_data);
132: , x_return_status => l_return_status
133: , x_msg_count => x_msg_count
134: , x_msg_data => x_msg_data);
135:
136: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
138: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
139: RAISE FND_API.G_EXC_ERROR;
140: END IF;
133: , x_msg_count => x_msg_count
134: , x_msg_data => x_msg_data);
135:
136: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
138: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
139: RAISE FND_API.G_EXC_ERROR;
140: END IF;
141:
134: , x_msg_data => x_msg_data);
135:
136: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
138: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
139: RAISE FND_API.G_EXC_ERROR;
140: END IF;
141:
142: -- Set return status.
135:
136: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
138: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
139: RAISE FND_API.G_EXC_ERROR;
140: END IF;
141:
142: -- Set return status.
143:
140: END IF;
141:
142: -- Set return status.
143:
144: x_return_status := FND_API.G_RET_STS_SUCCESS;
145:
146: /* -- Get message count and data
147:
148: OE_MSG_PUB.Count_And_Get
159:
160:
161: EXCEPTION
162:
163: WHEN FND_API.G_EXC_ERROR THEN
164: OE_GLOBALS.G_PROCESS_OBJECTS_FLAG := FALSE;
165: OE_GLOBALS.G_UI_FLAG := FALSE;
166:
167: x_return_status := FND_API.G_RET_STS_ERROR;
163: WHEN FND_API.G_EXC_ERROR THEN
164: OE_GLOBALS.G_PROCESS_OBJECTS_FLAG := FALSE;
165: OE_GLOBALS.G_UI_FLAG := FALSE;
166:
167: x_return_status := FND_API.G_RET_STS_ERROR;
168:
169: -- Get message count and data
170:
171: OE_MSG_PUB.Count_And_Get
172: ( p_count => x_msg_count
173: , p_data => x_msg_data
174: );
175:
176: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
177: OE_GLOBALS.G_PROCESS_OBJECTS_FLAG := FALSE;
178: OE_GLOBALS.G_UI_FLAG := FALSE;
179:
180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
176: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
177: OE_GLOBALS.G_PROCESS_OBJECTS_FLAG := FALSE;
178: OE_GLOBALS.G_UI_FLAG := FALSE;
179:
180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
181:
182: -- Get message count and data
183:
184: OE_MSG_PUB.Count_And_Get
189: WHEN OTHERS THEN
190: OE_GLOBALS.G_PROCESS_OBJECTS_FLAG := FALSE;
191: OE_GLOBALS.G_UI_FLAG := FALSE;
192:
193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
194:
195: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
196: THEN
197: OE_MSG_PUB.Add_Exc_Msg