DBA Data[Home] [Help]

APPS.OE_QUOTE_UTIL dependencies on FND_API

Line 47: x_return_status := FND_API.G_RET_STS_SUCCESS;

43: if l_debug_level > 0 then
44: oe_debug_pub.add('ENTER Complete_Negotiation',1);
45: end if;
46:
47: x_return_status := FND_API.G_RET_STS_SUCCESS;
48:
49:
50: -- Query/Lock order header and lines
51:

Line 57: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

53: (p_header_id => p_header_id
54: ,p_x_header_rec => l_old_header_rec
55: ,x_return_status => l_return_status
56: );
57: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
58: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
59: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
60: RAISE FND_API.G_EXC_ERROR;
61: END IF;

Line 58: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

54: ,p_x_header_rec => l_old_header_rec
55: ,x_return_status => l_return_status
56: );
57: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
58: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
59: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
60: RAISE FND_API.G_EXC_ERROR;
61: END IF;
62:

Line 59: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

55: ,x_return_status => l_return_status
56: );
57: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
58: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
59: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
60: RAISE FND_API.G_EXC_ERROR;
61: END IF;
62:
63: OE_Line_Util.Lock_Rows

Line 60: RAISE FND_API.G_EXC_ERROR;

56: );
57: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
58: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
59: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
60: RAISE FND_API.G_EXC_ERROR;
61: END IF;
62:
63: OE_Line_Util.Lock_Rows
64: (p_header_id => p_header_id

Line 68: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

64: (p_header_id => p_header_id
65: ,x_line_tbl => l_old_line_tbl
66: ,x_return_status => l_return_status
67: );
68: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
70: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
71: RAISE FND_API.G_EXC_ERROR;
72: END IF;

Line 69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

65: ,x_line_tbl => l_old_line_tbl
66: ,x_return_status => l_return_status
67: );
68: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
70: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
71: RAISE FND_API.G_EXC_ERROR;
72: END IF;
73:

Line 70: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

66: ,x_return_status => l_return_status
67: );
68: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
70: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
71: RAISE FND_API.G_EXC_ERROR;
72: END IF;
73:
74:

Line 71: RAISE FND_API.G_EXC_ERROR;

67: );
68: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
70: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
71: RAISE FND_API.G_EXC_ERROR;
72: END IF;
73:
74:
75: -- Set attributes on header and lines to change phase

Line 103: l_line_tbl(I).schedule_ship_date := fnd_api.g_miss_date;

99: l_line_tbl(I).transaction_phase_code := 'F';
100: l_line_tbl(I).flow_status_code := 'ENTERED';
101:
102: -- Following schedule dates should default in fulfillment phase
103: l_line_tbl(I).schedule_ship_date := fnd_api.g_miss_date;
104: l_line_tbl(I).schedule_arrival_date := fnd_api.g_miss_date;
105:
106: -- Bug 3519935
107: -- Send reason as SYSTEM, this will be used if audit constraint to

Line 104: l_line_tbl(I).schedule_arrival_date := fnd_api.g_miss_date;

100: l_line_tbl(I).flow_status_code := 'ENTERED';
101:
102: -- Following schedule dates should default in fulfillment phase
103: l_line_tbl(I).schedule_ship_date := fnd_api.g_miss_date;
104: l_line_tbl(I).schedule_arrival_date := fnd_api.g_miss_date;
105:
106: -- Bug 3519935
107: -- Send reason as SYSTEM, this will be used if audit constraint to
108: -- require reason or versioning constraint to require reason is

Line 127: ,p_validation_level => fnd_api.g_valid_level_none

123:
124: OE_Order_PVT.Process_Order
125: (p_api_version_number => 1.0
126: -- no attribute validation needed
127: ,p_validation_level => fnd_api.g_valid_level_none
128: ,p_control_rec => l_control_rec
129: ,p_x_header_rec => l_header_rec
130: ,p_old_header_rec => l_old_header_rec
131: ,p_x_line_tbl => l_line_tbl

Line 155: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

151:
152: -- Re-set global to N after process order call
153: G_COMPLETE_NEG := 'N';
154:
155: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
157: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
158: RAISE FND_API.G_EXC_ERROR;
159: END IF;

Line 156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

152: -- Re-set global to N after process order call
153: G_COMPLETE_NEG := 'N';
154:
155: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
157: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
158: RAISE FND_API.G_EXC_ERROR;
159: END IF;
160:

Line 157: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

153: G_COMPLETE_NEG := 'N';
154:
155: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
157: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
158: RAISE FND_API.G_EXC_ERROR;
159: END IF;
160:
161: OE_MSG_PUB.Count_And_Get

Line 158: RAISE FND_API.G_EXC_ERROR;

154:
155: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
157: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
158: RAISE FND_API.G_EXC_ERROR;
159: END IF;
160:
161: OE_MSG_PUB.Count_And_Get
162: ( p_count => x_msg_count

Line 172: WHEN FND_API.G_EXC_ERROR THEN

168: end if;
169:
170: EXCEPTION
171:
172: WHEN FND_API.G_EXC_ERROR THEN
173: G_COMPLETE_NEG := 'N';
174: x_return_status := FND_API.G_RET_STS_ERROR;
175: OE_MSG_PUB.Count_And_Get
176: ( p_count => x_msg_count

Line 174: x_return_status := FND_API.G_RET_STS_ERROR;

170: EXCEPTION
171:
172: WHEN FND_API.G_EXC_ERROR THEN
173: G_COMPLETE_NEG := 'N';
174: x_return_status := FND_API.G_RET_STS_ERROR;
175: OE_MSG_PUB.Count_And_Get
176: ( p_count => x_msg_count
177: , p_data => x_msg_data
178: );

Line 180: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

176: ( p_count => x_msg_count
177: , p_data => x_msg_data
178: );
179:
180: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
181: G_COMPLETE_NEG := 'N';
182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
183: OE_MSG_PUB.Count_And_Get
184: ( p_count => x_msg_count

Line 182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

178: );
179:
180: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
181: G_COMPLETE_NEG := 'N';
182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
183: OE_MSG_PUB.Count_And_Get
184: ( p_count => x_msg_count
185: , p_data => x_msg_data
186: );

Line 196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

192: (G_PKG_NAME
193: ,'Complete_Negotiation'
194: );
195: END IF;
196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
197: OE_MSG_PUB.Count_And_Get
198: ( p_count => x_msg_count
199: , p_data => x_msg_data
200: );