eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_MO_ADMIN_PUB dependencies on FND_API

Line 30: l_return_status Varchar2(1) := FND_API.G_RET_STS_SUCCESS;

26: ) IS
27:
28: l_api_version CONSTANT NUMBER := 1.0;
29: l_api_name CONSTANT VARCHAR2(30):= 'Cancel_Order';
30: l_return_status Varchar2(1) := FND_API.G_RET_STS_SUCCESS;
31: l_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
32: l_trolin_rec INV_Move_Order_PUB.Trolin_Rec_Type;
33: l_trohdr_val_rec INV_Move_Order_PUB.Trohdr_Val_Rec_Type;
34: l_trolin_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;

Line 43: IF NOT FND_API.Compatible_API_Call ( l_api_version,

39:
40: BEGIN
41:
42: -- Standard call to check compatibility
43: IF NOT FND_API.Compatible_API_Call ( l_api_version,
44: p_api_version,
45: l_api_name,
46: G_PKG_NAME ) THEN
47: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 47: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

43: IF NOT FND_API.Compatible_API_Call ( l_api_version,
44: p_api_version,
45: l_api_name,
46: G_PKG_NAME ) THEN
47: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
48: END IF;
49:
50: -- Initailize message list
51: If FND_API.To_Boolean( p_init_msg_list ) Then

Line 51: If FND_API.To_Boolean( p_init_msg_list ) Then

47: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
48: END IF;
49:
50: -- Initailize message list
51: If FND_API.To_Boolean( p_init_msg_list ) Then
52: FND_MSG_PUB.initialize;
53: End If;
54:
55: -- API Body

Line 58: p_init_msg_list => FND_API.G_TRUE,

54:
55: -- API Body
56: INV_Move_Order_Pub.Get_Move_Order(
57: p_api_version_number => 1.0,
58: p_init_msg_list => FND_API.G_TRUE,
59: x_return_status => l_return_status,
60: x_msg_count => l_msg_count,
61: x_msg_data => l_msg_data,
62: p_header_id => l_header_Id,

Line 68: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

64: x_trohdr_val_rec => l_trohdr_val_rec,
65: x_trolin_tbl => l_trolin_tbl,
66: x_trolin_val_tbl => l_trolin_val_tbl);
67:
68: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
69: IF l_return_status = FND_API.G_RET_STS_ERROR then
70: RAISE FND_API.G_EXC_ERROR;
71: END IF;
72: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

Line 69: IF l_return_status = FND_API.G_RET_STS_ERROR then

65: x_trolin_tbl => l_trolin_tbl,
66: x_trolin_val_tbl => l_trolin_val_tbl);
67:
68: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
69: IF l_return_status = FND_API.G_RET_STS_ERROR then
70: RAISE FND_API.G_EXC_ERROR;
71: END IF;
72: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
73: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 70: RAISE FND_API.G_EXC_ERROR;

66: x_trolin_val_tbl => l_trolin_val_tbl);
67:
68: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
69: IF l_return_status = FND_API.G_RET_STS_ERROR then
70: RAISE FND_API.G_EXC_ERROR;
71: END IF;
72: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
73: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
74: END IF;

Line 72: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

68: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
69: IF l_return_status = FND_API.G_RET_STS_ERROR then
70: RAISE FND_API.G_EXC_ERROR;
71: END IF;
72: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
73: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
74: END IF;
75: END IF;
76: -- Header Status 5 is closed, 6 is canceled

Line 73: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

69: IF l_return_status = FND_API.G_RET_STS_ERROR then
70: RAISE FND_API.G_EXC_ERROR;
71: END IF;
72: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
73: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
74: END IF;
75: END IF;
76: -- Header Status 5 is closed, 6 is canceled
77: IF ( l_trohdr_rec.header_status = 6 ) THEN

Line 85: RAISE FND_API.G_EXC_ERROR;

81:
82: IF ( l_trohdr_rec.header_status = 5 ) THEN
83: FND_MESSAGE.SET_NAME('INV','INV_TO_HEADER_STATUS');
84: FND_MSG_PUB.ADD;
85: RAISE FND_API.G_EXC_ERROR;
86: END IF;
87:
88: for I in 1..l_trolin_tbl.count loop
89: Cancel_Line(

Line 96: if l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

92: x_msg_count => l_msg_count,
93: x_msg_data => l_msg_data,
94: x_return_status => l_return_status
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;

Line 97: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

93: x_msg_data => l_msg_data,
94: x_return_status => l_return_status
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: end loop;

Line 98: elsif l_return_status = FND_API.G_RET_STS_ERROR then

94: x_return_status => l_return_status
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: end loop;
102:

Line 99: RAISE FND_API.G_EXC_ERROR;

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: end loop;
102:
103:

Line 118: if FND_API.To_Boolean( p_commit ) then

114:
115: x_return_status := l_return_status;
116:
117: -- Std check of p_commit
118: if FND_API.To_Boolean( p_commit ) then
119: COMMIT WORK;
120: end if;
121:
122: -- Call to get msg count

Line 128: WHEN FND_API.G_EXC_ERROR THEN

124: p_count => x_msg_count,
125: p_data => x_msg_data ) ;
126:
127: EXCEPTION
128: WHEN FND_API.G_EXC_ERROR THEN
129: x_return_status := FND_API.G_RET_STS_ERROR;
130: FND_MSG_PUB.Count_And_Get(
131: p_count => x_msg_count,
132: p_data => x_msg_data) ;

Line 129: x_return_status := FND_API.G_RET_STS_ERROR;

125: p_data => x_msg_data ) ;
126:
127: EXCEPTION
128: WHEN FND_API.G_EXC_ERROR THEN
129: x_return_status := FND_API.G_RET_STS_ERROR;
130: FND_MSG_PUB.Count_And_Get(
131: p_count => x_msg_count,
132: p_data => x_msg_data) ;
133: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 133: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

129: x_return_status := FND_API.G_RET_STS_ERROR;
130: FND_MSG_PUB.Count_And_Get(
131: p_count => x_msg_count,
132: p_data => x_msg_data) ;
133: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
135: FND_MSG_PUB.Count_And_Get(
136: p_count => x_msg_count,
137: p_data => x_msg_data) ;

Line 134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

130: FND_MSG_PUB.Count_And_Get(
131: p_count => x_msg_count,
132: p_data => x_msg_data) ;
133: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
135: FND_MSG_PUB.Count_And_Get(
136: p_count => x_msg_count,
137: p_data => x_msg_data) ;
138: WHEN OTHERS THEN

Line 139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

135: FND_MSG_PUB.Count_And_Get(
136: p_count => x_msg_count,
137: p_data => x_msg_data) ;
138: WHEN OTHERS THEN
139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
140: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
141: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Cancel_Order');
142: END IF;
143: FND_MSG_PUB.Count_And_Get(

Line 175: l_return_status Varchar2(1) := FND_API.G_RET_STS_SUCCESS;

171: --l_request_number Varchar2(25) := NULL;
172: --Bug 9118049, Request_number column in MTRH is defined to accept 30 characters.
173: --Stretching the variable from 25 char to 30 chars.
174: l_request_number MTL_TXN_REQUEST_HEADERS.request_number%type := NULL;
175: l_return_status Varchar2(1) := FND_API.G_RET_STS_SUCCESS;
176: l_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
177: l_line_status NUMBER := 0;
178:
179: BEGIN

Line 182: IF NOT FND_API.Compatible_API_Call ( l_api_version,

178:
179: BEGIN
180:
181: -- Standard call to check compatibility
182: IF NOT FND_API.Compatible_API_Call ( l_api_version,
183: p_api_version,
184: l_api_name,
185: G_PKG_NAME ) THEN
186: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 186: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

182: IF NOT FND_API.Compatible_API_Call ( l_api_version,
183: p_api_version,
184: l_api_name,
185: G_PKG_NAME ) THEN
186: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
187: END IF;
188:
189: -- Initailize message list
190: If FND_API.To_Boolean( p_init_msg_list ) Then

Line 190: If FND_API.To_Boolean( p_init_msg_list ) Then

186: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
187: END IF;
188:
189: -- Initailize message list
190: If FND_API.To_Boolean( p_init_msg_list ) Then
191: FND_MSG_PUB.initialize;
192: End If;
193:
194: -- API Body

Line 202: RAISE FND_API.G_EXC_ERROR;

198: FROM mtl_txn_request_headers
199: WHERE Header_id = l_header_id;
200: EXCEPTION
201: WHEN No_Data_Found THEN
202: RAISE FND_API.G_EXC_ERROR;
203: WHEN OTHERS THEN
204: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Close Order');
205: RAISE FND_API.G_EXC_ERROR;
206: END;

Line 205: RAISE FND_API.G_EXC_ERROR;

201: WHEN No_Data_Found THEN
202: RAISE FND_API.G_EXC_ERROR;
203: WHEN OTHERS THEN
204: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Close Order');
205: RAISE FND_API.G_EXC_ERROR;
206: END;
207:
208: IF ( l_hdr_status = 5 ) THEN
209: x_return_status := l_return_status;

Line 231: RAISE FND_API.G_EXC_ERROR;

227:
228: IF ( l_hdr_status = 1 OR l_line_status = 1 ) THEN
229: FND_MESSAGE.SET_NAME('INV','INV_TO_HEADER_STATUS');
230: FND_MSG_PUB.ADD;
231: RAISE FND_API.G_EXC_ERROR;
232: END IF;
233:
234: l_trolin_tbl := Inv_Trolin_Util.Get_Lines( l_header_id );
235: For I in 1..l_trolin_tbl.count Loop

Line 243: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

239: x_msg_count => x_msg_count,
240: x_msg_data => x_msg_data,
241: x_return_status => l_return_status
242: );
243: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
244: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
246: END IF;
247: IF l_return_status = FND_API.G_RET_STS_ERROR then

Line 244: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

240: x_msg_data => x_msg_data,
241: x_return_status => l_return_status
242: );
243: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
244: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
246: END IF;
247: IF l_return_status = FND_API.G_RET_STS_ERROR then
248: RAISE FND_API.G_EXC_ERROR;

Line 245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

241: x_return_status => l_return_status
242: );
243: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
244: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
246: END IF;
247: IF l_return_status = FND_API.G_RET_STS_ERROR then
248: RAISE FND_API.G_EXC_ERROR;
249: end if;

Line 247: IF l_return_status = FND_API.G_RET_STS_ERROR then

243: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
244: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
246: END IF;
247: IF l_return_status = FND_API.G_RET_STS_ERROR then
248: RAISE FND_API.G_EXC_ERROR;
249: end if;
250: END IF;
251: End Loop;

Line 248: RAISE FND_API.G_EXC_ERROR;

244: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
246: END IF;
247: IF l_return_status = FND_API.G_RET_STS_ERROR then
248: RAISE FND_API.G_EXC_ERROR;
249: end if;
250: END IF;
251: End Loop;
252:

Line 268: if FND_API.To_Boolean( p_commit ) then

264:
265: x_return_status := l_return_status;
266:
267: -- Std check of p_commit
268: if FND_API.To_Boolean( p_commit ) then
269: COMMIT WORK;
270: end if;
271:
272: -- Call to get msg count and data

Line 278: WHEN FND_API.G_EXC_ERROR THEN

274: p_count => x_msg_count,
275: p_data => x_msg_data ) ;
276:
277: EXCEPTION
278: WHEN FND_API.G_EXC_ERROR THEN
279: x_return_status := FND_API.G_RET_STS_ERROR;
280: FND_MSG_PUB.Count_And_Get(
281: p_count => x_msg_count,
282: p_data => x_msg_data) ;

Line 279: x_return_status := FND_API.G_RET_STS_ERROR;

275: p_data => x_msg_data ) ;
276:
277: EXCEPTION
278: WHEN FND_API.G_EXC_ERROR THEN
279: x_return_status := FND_API.G_RET_STS_ERROR;
280: FND_MSG_PUB.Count_And_Get(
281: p_count => x_msg_count,
282: p_data => x_msg_data) ;
283: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 283: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

279: x_return_status := FND_API.G_RET_STS_ERROR;
280: FND_MSG_PUB.Count_And_Get(
281: p_count => x_msg_count,
282: p_data => x_msg_data) ;
283: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
285: FND_MSG_PUB.Count_And_Get(
286: p_count => x_msg_count,
287: p_data => x_msg_data) ;

Line 284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

280: FND_MSG_PUB.Count_And_Get(
281: p_count => x_msg_count,
282: p_data => x_msg_data) ;
283: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
285: FND_MSG_PUB.Count_And_Get(
286: p_count => x_msg_count,
287: p_data => x_msg_data) ;
288: WHEN OTHERS THEN

Line 289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

285: FND_MSG_PUB.Count_And_Get(
286: p_count => x_msg_count,
287: p_data => x_msg_data) ;
288: WHEN OTHERS THEN
289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
290: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
291: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Close_Order');
292: END IF;
293: FND_MSG_PUB.Count_And_Get(

Line 325: l_return_status Varchar2(1) := FND_API.G_RET_STS_SUCCESS;

321: --l_request_number Varchar2(25) := NULL;
322: --Bug 9118049, Request_number column in MTRH is defined to accept 30 characters.
323: --Stretching the variable from 25 char to 30 chars.
324: l_request_number MTL_TXN_REQUEST_HEADERS.request_number%type := NULL;
325: l_return_status Varchar2(1) := FND_API.G_RET_STS_SUCCESS;
326:
327: BEGIN
328:
329: -- Standard call to check compatibility

Line 330: IF NOT FND_API.Compatible_API_Call ( l_api_version,

326:
327: BEGIN
328:
329: -- Standard call to check compatibility
330: IF NOT FND_API.Compatible_API_Call ( l_api_version,
331: p_api_version,
332: l_api_name,
333: G_PKG_NAME ) THEN
334: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 334: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

330: IF NOT FND_API.Compatible_API_Call ( l_api_version,
331: p_api_version,
332: l_api_name,
333: G_PKG_NAME ) THEN
334: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
335: END IF;
336:
337: -- Initailize message list
338: If FND_API.To_Boolean( p_init_msg_list ) Then

Line 338: If FND_API.To_Boolean( p_init_msg_list ) Then

334: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
335: END IF;
336:
337: -- Initailize message list
338: If FND_API.To_Boolean( p_init_msg_list ) Then
339: FND_MSG_PUB.initialize;
340: End If;
341:
342: -- API Body

Line 351: RAISE FND_API.G_EXC_ERROR;

347: where
348: Header_id = l_header_id;
349: Exception
350: When No_Data_Found Then
351: RAISE FND_API.G_EXC_ERROR;
352: When OTHERS then
353: FND_MSG_PUB.Add_Exc_Msg
354: ( G_PKG_NAME
355: , 'purge Order'

Line 358: RAISE FND_API.G_EXC_ERROR;

354: ( G_PKG_NAME
355: , 'purge Order'
356: );
357:
358: RAISE FND_API.G_EXC_ERROR;
359: End;
360:
361: IF ( l_hdr_status <> 5 ) THEN
362: FND_MESSAGE.SET_NAME('INV','INV_TO_HEADER_STATUS');

Line 364: RAISE FND_API.G_EXC_ERROR;

360:
361: IF ( l_hdr_status <> 5 ) THEN
362: FND_MESSAGE.SET_NAME('INV','INV_TO_HEADER_STATUS');
363: FND_MSG_PUB.ADD;
364: RAISE FND_API.G_EXC_ERROR;
365: END IF;
366:
367: Delete MTL_TXN_REQUEST_LINES
368: where

Line 379: if FND_API.To_Boolean( p_commit ) then

375: x_return_status := l_return_status;
376:
377:
378: -- Std check of p_commit
379: if FND_API.To_Boolean( p_commit ) then
380: COMMIT WORK;
381: end if;
382:
383: -- Call to get msg count and data

Line 389: WHEN FND_API.G_EXC_ERROR THEN

385: p_count => x_msg_count,
386: p_data => x_msg_data ) ;
387:
388: Exception
389: WHEN FND_API.G_EXC_ERROR THEN
390: x_return_status := FND_API.G_RET_STS_ERROR;
391: FND_MSG_PUB.Count_And_Get(
392: p_count => x_msg_count,
393: p_data => x_msg_data ) ;

Line 390: x_return_status := FND_API.G_RET_STS_ERROR;

386: p_data => x_msg_data ) ;
387:
388: Exception
389: WHEN FND_API.G_EXC_ERROR THEN
390: x_return_status := FND_API.G_RET_STS_ERROR;
391: FND_MSG_PUB.Count_And_Get(
392: p_count => x_msg_count,
393: p_data => x_msg_data ) ;
394:

Line 396: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

392: p_count => x_msg_count,
393: p_data => x_msg_data ) ;
394:
395:
396: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
397:
398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
399: FND_MSG_PUB.Count_And_Get(
400: p_count => x_msg_count,

Line 398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

394:
395:
396: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
397:
398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
399: FND_MSG_PUB.Count_And_Get(
400: p_count => x_msg_count,
401: p_data => x_msg_data ) ;
402:

Line 441: l_return_status Varchar2(1) := FND_API.G_RET_STS_SUCCESS;

437: l_api_name CONSTANT VARCHAR2(30):= 'Cancel_Line';
438: l_Line_Id Number := p_line_Id;
439: l_line_status Number;
440: l_request_number Varchar2(25) := NULL;
441: l_return_status Varchar2(1) := FND_API.G_RET_STS_SUCCESS;
442: l_old_trolin_tbl INV_Move_Order_PUB.Trolin_tbl_Type;
443: l_new_trolin_tbl INV_Move_Order_PUB.Trolin_tbl_Type;
444: l_x_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
445: l_x_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;

Line 459: IF NOT FND_API.Compatible_API_Call ( l_api_version,

455:
456: BEGIN
457:
458: -- Standard call to check compatibility
459: IF NOT FND_API.Compatible_API_Call ( l_api_version,
460: p_api_version,
461: l_api_name,
462: G_PKG_NAME ) THEN
463: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 463: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

459: IF NOT FND_API.Compatible_API_Call ( l_api_version,
460: p_api_version,
461: l_api_name,
462: G_PKG_NAME ) THEN
463: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
464: END IF;
465:
466: -- Initailize message list
467: If FND_API.To_Boolean( p_init_msg_list ) Then

Line 467: If FND_API.To_Boolean( p_init_msg_list ) Then

463: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
464: END IF;
465:
466: -- Initailize message list
467: If FND_API.To_Boolean( p_init_msg_list ) Then
468: FND_MSG_PUB.initialize;
469: End If;
470:
471: -- API Body

Line 483: RAISE FND_API.G_EXC_ERROR;

479: WHERE Line_Id = l_Line_Id
480: FOR UPDATE NOWAIT;
481: EXCEPTION
482: WHEN No_Data_Found THEN
483: RAISE FND_API.G_EXC_ERROR;
484: WHEN app_exceptions.record_lock_exception THEN
485: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
486: fnd_message.set_name('ONT', 'OE_LOCK_ROW_ALREADY_LOCKED');
487: fnd_msg_pub.ADD;

Line 489: RAISE FND_API.G_EXC_ERROR;

485: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
486: fnd_message.set_name('ONT', 'OE_LOCK_ROW_ALREADY_LOCKED');
487: fnd_msg_pub.ADD;
488: END IF;
489: RAISE FND_API.G_EXC_ERROR;
490: WHEN OTHERS THEN
491: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Cancel Line');
492: RAISE FND_API.G_EXC_ERROR;
493: END;

Line 492: RAISE FND_API.G_EXC_ERROR;

488: END IF;
489: RAISE FND_API.G_EXC_ERROR;
490: WHEN OTHERS THEN
491: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Cancel Line');
492: RAISE FND_API.G_EXC_ERROR;
493: END;
494:
495:
496: IF ( l_Line_status = 6 ) THEN

Line 504: RAISE FND_API.G_EXC_ERROR;

500:
501: IF ( l_Line_status = 5 ) THEN
502: FND_MESSAGE.SET_NAME('INV','INV_TO_HEADER_STATUS');
503: FND_MSG_PUB.ADD;
504: RAISE FND_API.G_EXC_ERROR;
505: END IF;
506:
507: IF ( l_mo_type <> 3 ) then /* 3 - pickwave type MO */
508: IF ( NVL(l_qty_del,0) <> 0 ) then

Line 510: RAISE FND_API.G_EXC_ERROR;

506:
507: IF ( l_mo_type <> 3 ) then /* 3 - pickwave type MO */
508: IF ( NVL(l_qty_del,0) <> 0 ) then
509:
510: RAISE FND_API.G_EXC_ERROR;
511: END IF;
512: END IF;
513:
514: l_old_trolin_rec := Inv_Trolin_Util.Query_Row( l_line_id );

Line 555: RAISE FND_API.G_EXC_ERROR;

551: ( G_PKG_NAME
552: , 'Cancel Line'
553: );
554:
555: RAISE FND_API.G_EXC_ERROR;
556: End;
557: ELSE
558: l_new_trolin_tbl(1).line_status := 6;
559: l_new_trolin_tbl(1).status_date := sysdate; --bug 5053725

Line 569: p_init_msg_list => FND_API.G_TRUE,

565:
566: /** call update line API **/
567: INV_Transfer_Order_PVT.Process_Transfer_Order
568: ( p_api_version_number => 1.0 ,
569: p_init_msg_list => FND_API.G_TRUE,
570: x_return_status => l_return_status,
571: x_msg_count => l_msg_count,
572: x_msg_data => l_msg_data,
573: p_trolin_tbl => l_new_trolin_tbl,

Line 580: if l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

576: x_trolin_tbl => l_x_trolin_tbl,
577: p_delete_mmtt => l_delete_mmtt --Added bug3524130
578: );
579:
580: if l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
582: elsif l_return_status = FND_API.G_RET_STS_ERROR then
583: RAISE FND_API.G_EXC_ERROR;
584: end if;

Line 581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

577: p_delete_mmtt => l_delete_mmtt --Added bug3524130
578: );
579:
580: if l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
582: elsif l_return_status = FND_API.G_RET_STS_ERROR then
583: RAISE FND_API.G_EXC_ERROR;
584: end if;
585:

Line 582: elsif l_return_status = FND_API.G_RET_STS_ERROR then

578: );
579:
580: if l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
582: elsif l_return_status = FND_API.G_RET_STS_ERROR then
583: RAISE FND_API.G_EXC_ERROR;
584: end if;
585:
586: x_return_status := l_return_status;

Line 583: RAISE FND_API.G_EXC_ERROR;

579:
580: if l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
582: elsif l_return_status = FND_API.G_RET_STS_ERROR then
583: RAISE FND_API.G_EXC_ERROR;
584: end if;
585:
586: x_return_status := l_return_status;
587:

Line 590: if FND_API.To_Boolean( p_commit ) then

586: x_return_status := l_return_status;
587:
588:
589: -- Std check of p_commit
590: if FND_API.To_Boolean( p_commit ) then
591: COMMIT WORK;
592: end if;
593:
594: -- Call to get msg count and data

Line 600: WHEN FND_API.G_EXC_ERROR THEN

596: p_count => x_msg_count,
597: p_data => x_msg_data ) ;
598:
599: EXCEPTION
600: WHEN FND_API.G_EXC_ERROR THEN
601: x_return_status := FND_API.G_RET_STS_ERROR;
602: FND_MSG_PUB.Count_And_Get(
603: p_count => x_msg_count,
604: p_data => x_msg_data) ;

Line 601: x_return_status := FND_API.G_RET_STS_ERROR;

597: p_data => x_msg_data ) ;
598:
599: EXCEPTION
600: WHEN FND_API.G_EXC_ERROR THEN
601: x_return_status := FND_API.G_RET_STS_ERROR;
602: FND_MSG_PUB.Count_And_Get(
603: p_count => x_msg_count,
604: p_data => x_msg_data) ;
605: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 605: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

601: x_return_status := FND_API.G_RET_STS_ERROR;
602: FND_MSG_PUB.Count_And_Get(
603: p_count => x_msg_count,
604: p_data => x_msg_data) ;
605: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
607: FND_MSG_PUB.Count_And_Get(
608: p_count => x_msg_count,
609: p_data => x_msg_data) ;

Line 606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

602: FND_MSG_PUB.Count_And_Get(
603: p_count => x_msg_count,
604: p_data => x_msg_data) ;
605: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
607: FND_MSG_PUB.Count_And_Get(
608: p_count => x_msg_count,
609: p_data => x_msg_data) ;
610: WHEN OTHERS THEN

Line 611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

607: FND_MSG_PUB.Count_And_Get(
608: p_count => x_msg_count,
609: p_data => x_msg_data) ;
610: WHEN OTHERS THEN
611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
612: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
613: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Cancel line');
614: END IF;
615: FND_MSG_PUB.Count_And_Get(

Line 647: l_return_status Varchar2(1) := FND_API.G_RET_STS_SUCCESS;

643: l_line_status Number;
644: l_qty_del Number;
645: l_qty Number;
646: l_request_number Varchar2(25) := NULL;
647: l_return_status Varchar2(1) := FND_API.G_RET_STS_SUCCESS;
648: l_loaded_lpn_exists Number; --Added bug3524130
649: l_org_id Number;
650: l_wms_org_flag Boolean;
651: l_wrd_exists NUMBER := 0;

Line 656: IF NOT FND_API.Compatible_API_Call ( l_api_version,

652:
653: BEGIN
654:
655: -- Standard call to check compatibility
656: IF NOT FND_API.Compatible_API_Call ( l_api_version,
657: p_api_version,
658: l_api_name,
659: G_PKG_NAME ) THEN
660: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 660: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

656: IF NOT FND_API.Compatible_API_Call ( l_api_version,
657: p_api_version,
658: l_api_name,
659: G_PKG_NAME ) THEN
660: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
661: END IF;
662:
663: -- Initailize message list
664: If FND_API.To_Boolean( p_init_msg_list ) Then

Line 664: If FND_API.To_Boolean( p_init_msg_list ) Then

660: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
661: END IF;
662:
663: -- Initailize message list
664: If FND_API.To_Boolean( p_init_msg_list ) Then
665: FND_MSG_PUB.initialize;
666: End If;
667:
668: -- API Body

Line 680: RAISE FND_API.G_EXC_ERROR;

676: WHERE Line_Id = l_Line_Id
677: FOR UPDATE NOWAIT;
678: EXCEPTION
679: WHEN No_Data_Found THEN
680: RAISE FND_API.G_EXC_ERROR;
681: WHEN app_exceptions.record_lock_exception THEN
682: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
683: fnd_message.set_name('ONT', 'OE_LOCK_ROW_ALREADY_LOCKED');
684: fnd_msg_pub.ADD;

Line 686: RAISE FND_API.G_EXC_ERROR;

682: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
683: fnd_message.set_name('ONT', 'OE_LOCK_ROW_ALREADY_LOCKED');
684: fnd_msg_pub.ADD;
685: END IF;
686: RAISE FND_API.G_EXC_ERROR;
687: WHEN OTHERS THEN
688: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Close Line');
689: RAISE FND_API.G_EXC_ERROR;
690: END;

Line 689: RAISE FND_API.G_EXC_ERROR;

685: END IF;
686: RAISE FND_API.G_EXC_ERROR;
687: WHEN OTHERS THEN
688: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Close Line');
689: RAISE FND_API.G_EXC_ERROR;
690: END;
691:
692: IF ( l_Line_status = 5 ) THEN
693: x_return_status := l_return_status ;

Line 700: RAISE FND_API.G_EXC_ERROR;

696:
697:
698: /*IF ( l_line_status in ( 3, 7 ) ) then
699: if ( nvl(l_qty_del, 0) < l_qty ) then
700: RAISE FND_API.G_EXC_ERROR;
701: end if;
702: END IF; */
703:
704: IF ( l_Line_status not in (3,4,6,7,9) ) THEN

Line 707: RAISE FND_API.G_EXC_ERROR;

703:
704: IF ( l_Line_status not in (3,4,6,7,9) ) THEN
705: FND_MESSAGE.SET_NAME('INV','INV_TO_HEADER_STATUS');
706: FND_MSG_PUB.ADD;
707: RAISE FND_API.G_EXC_ERROR;
708: END IF;
709:
710: /*Added bug3524130*/
711: l_loaded_lpn_exists := 0;

Line 750: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

746: EXCEPTION
747: When No_Data_Found Then
748: l_loaded_lpn_exists := 0;
749: When OTHERS then
750: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
751: END;
752: END IF; -- ( l_wms_org_flag ) THEN
753:
754:

Line 774: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

770: Exception
771: when NO_DATA_FOUND then
772: Null;
773: when OTHERS then
774: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
775: END;
776:
777:
778: -- Updating the who columns for bug 3277406

Line 793: if FND_API.To_Boolean( p_commit ) then

789: x_return_status := l_return_status;
790:
791:
792: -- Std check of p_commit
793: if FND_API.To_Boolean( p_commit ) then
794: COMMIT WORK;
795: end if;
796:
797: -- Call to get msg coount and data

Line 803: WHEN FND_API.G_EXC_ERROR THEN

799: p_count => x_msg_count,
800: p_data => x_msg_data ) ;
801:
802: Exception
803: WHEN FND_API.G_EXC_ERROR THEN
804: x_return_status := FND_API.G_RET_STS_ERROR;
805: FND_MSG_PUB.Count_And_Get(
806: p_count => x_msg_count,
807: p_data => x_msg_data ) ;

Line 804: x_return_status := FND_API.G_RET_STS_ERROR;

800: p_data => x_msg_data ) ;
801:
802: Exception
803: WHEN FND_API.G_EXC_ERROR THEN
804: x_return_status := FND_API.G_RET_STS_ERROR;
805: FND_MSG_PUB.Count_And_Get(
806: p_count => x_msg_count,
807: p_data => x_msg_data ) ;
808:

Line 809: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

805: FND_MSG_PUB.Count_And_Get(
806: p_count => x_msg_count,
807: p_data => x_msg_data ) ;
808:
809: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
810: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
811: FND_MSG_PUB.Count_And_Get(
812: p_count => x_msg_count,
813: p_data => x_msg_data ) ;

Line 810: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

806: p_count => x_msg_count,
807: p_data => x_msg_data ) ;
808:
809: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
810: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
811: FND_MSG_PUB.Count_And_Get(
812: p_count => x_msg_count,
813: p_data => x_msg_data ) ;
814: WHEN OTHERS THEN

Line 815: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

811: FND_MSG_PUB.Count_And_Get(
812: p_count => x_msg_count,
813: p_data => x_msg_data ) ;
814: WHEN OTHERS THEN
815: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
816: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
817: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Close line');
818: END IF;
819: FND_MSG_PUB.Count_And_Get(