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 116: if FND_API.To_Boolean( p_commit ) then

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

Line 126: WHEN FND_API.G_EXC_ERROR THEN

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

Line 127: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

166: l_api_name CONSTANT VARCHAR2(30):= 'Close_Order';
167: l_header_id Number := p_header_id;
168: l_hdr_status Number;
169: l_request_number Varchar2(25) := NULL;
170: l_return_status Varchar2(1) := FND_API.G_RET_STS_SUCCESS;
171: l_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
172: l_line_status NUMBER := 0;
173:
174: BEGIN

Line 177: IF NOT FND_API.Compatible_API_Call ( l_api_version,

173:
174: BEGIN
175:
176: -- Standard call to check compatibility
177: IF NOT FND_API.Compatible_API_Call ( l_api_version,
178: p_api_version,
179: l_api_name,
180: G_PKG_NAME ) THEN
181: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 181: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

177: IF NOT FND_API.Compatible_API_Call ( l_api_version,
178: p_api_version,
179: l_api_name,
180: G_PKG_NAME ) THEN
181: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
182: END IF;
183:
184: -- Initailize message list
185: If FND_API.To_Boolean( p_init_msg_list ) Then

Line 185: If FND_API.To_Boolean( p_init_msg_list ) Then

181: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
182: END IF;
183:
184: -- Initailize message list
185: If FND_API.To_Boolean( p_init_msg_list ) Then
186: FND_MSG_PUB.initialize;
187: End If;
188:
189: -- API Body

Line 197: RAISE FND_API.G_EXC_ERROR;

193: FROM mtl_txn_request_headers
194: WHERE Header_id = l_header_id;
195: EXCEPTION
196: WHEN No_Data_Found THEN
197: RAISE FND_API.G_EXC_ERROR;
198: WHEN OTHERS THEN
199: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Close Order');
200: RAISE FND_API.G_EXC_ERROR;
201: END;

Line 200: RAISE FND_API.G_EXC_ERROR;

196: WHEN No_Data_Found THEN
197: RAISE FND_API.G_EXC_ERROR;
198: WHEN OTHERS THEN
199: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Close Order');
200: RAISE FND_API.G_EXC_ERROR;
201: END;
202:
203: IF ( l_hdr_status = 5 ) THEN
204: x_return_status := l_return_status;

Line 226: RAISE FND_API.G_EXC_ERROR;

222:
223: IF ( l_hdr_status = 1 OR l_line_status = 1 ) THEN
224: FND_MESSAGE.SET_NAME('INV','INV_TO_HEADER_STATUS');
225: FND_MSG_PUB.ADD;
226: RAISE FND_API.G_EXC_ERROR;
227: END IF;
228:
229: l_trolin_tbl := Inv_Trolin_Util.Get_Lines( l_header_id );
230: For I in 1..l_trolin_tbl.count Loop

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

234: x_msg_count => x_msg_count,
235: x_msg_data => x_msg_data,
236: x_return_status => l_return_status
237: );
238: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
239: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
240: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
241: END IF;
242: IF l_return_status = FND_API.G_RET_STS_ERROR then

Line 239: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

235: x_msg_data => x_msg_data,
236: x_return_status => l_return_status
237: );
238: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
239: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
240: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
241: END IF;
242: IF l_return_status = FND_API.G_RET_STS_ERROR then
243: RAISE FND_API.G_EXC_ERROR;

Line 240: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

236: x_return_status => l_return_status
237: );
238: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
239: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
240: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
241: END IF;
242: IF l_return_status = FND_API.G_RET_STS_ERROR then
243: RAISE FND_API.G_EXC_ERROR;
244: end if;

Line 242: IF l_return_status = FND_API.G_RET_STS_ERROR then

238: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
239: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
240: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
241: END IF;
242: IF l_return_status = FND_API.G_RET_STS_ERROR then
243: RAISE FND_API.G_EXC_ERROR;
244: end if;
245: END IF;
246: End Loop;

Line 243: RAISE FND_API.G_EXC_ERROR;

239: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
240: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
241: END IF;
242: IF l_return_status = FND_API.G_RET_STS_ERROR then
243: RAISE FND_API.G_EXC_ERROR;
244: end if;
245: END IF;
246: End Loop;
247:

Line 261: if FND_API.To_Boolean( p_commit ) then

257:
258: x_return_status := l_return_status;
259:
260: -- Std check of p_commit
261: if FND_API.To_Boolean( p_commit ) then
262: COMMIT WORK;
263: end if;
264:
265: -- Call to get msg count and data

Line 271: WHEN FND_API.G_EXC_ERROR THEN

267: p_count => x_msg_count,
268: p_data => x_msg_data ) ;
269:
270: EXCEPTION
271: WHEN FND_API.G_EXC_ERROR THEN
272: x_return_status := FND_API.G_RET_STS_ERROR;
273: FND_MSG_PUB.Count_And_Get(
274: p_count => x_msg_count,
275: p_data => x_msg_data) ;

Line 272: x_return_status := FND_API.G_RET_STS_ERROR;

268: p_data => x_msg_data ) ;
269:
270: EXCEPTION
271: WHEN FND_API.G_EXC_ERROR THEN
272: x_return_status := FND_API.G_RET_STS_ERROR;
273: FND_MSG_PUB.Count_And_Get(
274: p_count => x_msg_count,
275: p_data => x_msg_data) ;
276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

272: x_return_status := FND_API.G_RET_STS_ERROR;
273: FND_MSG_PUB.Count_And_Get(
274: p_count => x_msg_count,
275: p_data => x_msg_data) ;
276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
278: FND_MSG_PUB.Count_And_Get(
279: p_count => x_msg_count,
280: p_data => x_msg_data) ;

Line 277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

273: FND_MSG_PUB.Count_And_Get(
274: p_count => x_msg_count,
275: p_data => x_msg_data) ;
276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
278: FND_MSG_PUB.Count_And_Get(
279: p_count => x_msg_count,
280: p_data => x_msg_data) ;
281: WHEN OTHERS THEN

Line 282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

278: FND_MSG_PUB.Count_And_Get(
279: p_count => x_msg_count,
280: p_data => x_msg_data) ;
281: WHEN OTHERS THEN
282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
283: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
284: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Close_Order');
285: END IF;
286: FND_MSG_PUB.Count_And_Get(

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

311: l_api_name CONSTANT VARCHAR2(30):= 'Purge_Order';
312: l_header_id Number := p_header_id;
313: l_hdr_status Number;
314: l_request_number Varchar2(25) := NULL;
315: l_return_status Varchar2(1) := FND_API.G_RET_STS_SUCCESS;
316:
317: BEGIN
318:
319: -- Standard call to check compatibility

Line 320: IF NOT FND_API.Compatible_API_Call ( l_api_version,

316:
317: BEGIN
318:
319: -- Standard call to check compatibility
320: IF NOT FND_API.Compatible_API_Call ( l_api_version,
321: p_api_version,
322: l_api_name,
323: G_PKG_NAME ) THEN
324: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 324: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

320: IF NOT FND_API.Compatible_API_Call ( l_api_version,
321: p_api_version,
322: l_api_name,
323: G_PKG_NAME ) THEN
324: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
325: END IF;
326:
327: -- Initailize message list
328: If FND_API.To_Boolean( p_init_msg_list ) Then

Line 328: If FND_API.To_Boolean( p_init_msg_list ) Then

324: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
325: END IF;
326:
327: -- Initailize message list
328: If FND_API.To_Boolean( p_init_msg_list ) Then
329: FND_MSG_PUB.initialize;
330: End If;
331:
332: -- API Body

Line 341: RAISE FND_API.G_EXC_ERROR;

337: where
338: Header_id = l_header_id;
339: Exception
340: When No_Data_Found Then
341: RAISE FND_API.G_EXC_ERROR;
342: When OTHERS then
343: FND_MSG_PUB.Add_Exc_Msg
344: ( G_PKG_NAME
345: , 'purge Order'

Line 348: RAISE FND_API.G_EXC_ERROR;

344: ( G_PKG_NAME
345: , 'purge Order'
346: );
347:
348: RAISE FND_API.G_EXC_ERROR;
349: End;
350:
351: IF ( l_hdr_status <> 5 ) THEN
352: FND_MESSAGE.SET_NAME('INV','INV_TO_HEADER_STATUS');

Line 354: RAISE FND_API.G_EXC_ERROR;

350:
351: IF ( l_hdr_status <> 5 ) THEN
352: FND_MESSAGE.SET_NAME('INV','INV_TO_HEADER_STATUS');
353: FND_MSG_PUB.ADD;
354: RAISE FND_API.G_EXC_ERROR;
355: END IF;
356:
357: Delete MTL_TXN_REQUEST_LINES
358: where

Line 369: if FND_API.To_Boolean( p_commit ) then

365: x_return_status := l_return_status;
366:
367:
368: -- Std check of p_commit
369: if FND_API.To_Boolean( p_commit ) then
370: COMMIT WORK;
371: end if;
372:
373: -- Call to get msg count and data

Line 379: WHEN FND_API.G_EXC_ERROR THEN

375: p_count => x_msg_count,
376: p_data => x_msg_data ) ;
377:
378: Exception
379: WHEN FND_API.G_EXC_ERROR THEN
380: x_return_status := FND_API.G_RET_STS_ERROR;
381: FND_MSG_PUB.Count_And_Get(
382: p_count => x_msg_count,
383: p_data => x_msg_data ) ;

Line 380: x_return_status := FND_API.G_RET_STS_ERROR;

376: p_data => x_msg_data ) ;
377:
378: Exception
379: WHEN FND_API.G_EXC_ERROR THEN
380: x_return_status := FND_API.G_RET_STS_ERROR;
381: FND_MSG_PUB.Count_And_Get(
382: p_count => x_msg_count,
383: p_data => x_msg_data ) ;
384:

Line 386: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

382: p_count => x_msg_count,
383: p_data => x_msg_data ) ;
384:
385:
386: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
387:
388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
389: FND_MSG_PUB.Count_And_Get(
390: p_count => x_msg_count,

Line 388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

384:
385:
386: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
387:
388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
389: FND_MSG_PUB.Count_And_Get(
390: p_count => x_msg_count,
391: p_data => x_msg_data ) ;
392:

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

427: l_api_name CONSTANT VARCHAR2(30):= 'Cancel_Line';
428: l_Line_Id Number := p_line_Id;
429: l_line_status Number;
430: l_request_number Varchar2(25) := NULL;
431: l_return_status Varchar2(1) := FND_API.G_RET_STS_SUCCESS;
432: l_old_trolin_tbl INV_Move_Order_PUB.Trolin_tbl_Type;
433: l_new_trolin_tbl INV_Move_Order_PUB.Trolin_tbl_Type;
434: l_x_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
435: l_x_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;

Line 449: IF NOT FND_API.Compatible_API_Call ( l_api_version,

445:
446: BEGIN
447:
448: -- Standard call to check compatibility
449: IF NOT FND_API.Compatible_API_Call ( l_api_version,
450: p_api_version,
451: l_api_name,
452: G_PKG_NAME ) THEN
453: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 453: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

449: IF NOT FND_API.Compatible_API_Call ( l_api_version,
450: p_api_version,
451: l_api_name,
452: G_PKG_NAME ) THEN
453: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
454: END IF;
455:
456: -- Initailize message list
457: If FND_API.To_Boolean( p_init_msg_list ) Then

Line 457: If FND_API.To_Boolean( p_init_msg_list ) Then

453: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
454: END IF;
455:
456: -- Initailize message list
457: If FND_API.To_Boolean( p_init_msg_list ) Then
458: FND_MSG_PUB.initialize;
459: End If;
460:
461: -- API Body

Line 473: RAISE FND_API.G_EXC_ERROR;

469: WHERE Line_Id = l_Line_Id
470: FOR UPDATE NOWAIT;
471: EXCEPTION
472: WHEN No_Data_Found THEN
473: RAISE FND_API.G_EXC_ERROR;
474: WHEN app_exceptions.record_lock_exception THEN
475: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
476: fnd_message.set_name('ONT', 'OE_LOCK_ROW_ALREADY_LOCKED');
477: fnd_msg_pub.ADD;

Line 479: RAISE FND_API.G_EXC_ERROR;

475: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
476: fnd_message.set_name('ONT', 'OE_LOCK_ROW_ALREADY_LOCKED');
477: fnd_msg_pub.ADD;
478: END IF;
479: RAISE FND_API.G_EXC_ERROR;
480: WHEN OTHERS THEN
481: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Cancel Line');
482: RAISE FND_API.G_EXC_ERROR;
483: END;

Line 482: RAISE FND_API.G_EXC_ERROR;

478: END IF;
479: RAISE FND_API.G_EXC_ERROR;
480: WHEN OTHERS THEN
481: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Cancel Line');
482: RAISE FND_API.G_EXC_ERROR;
483: END;
484:
485:
486: IF ( l_Line_status = 6 ) THEN

Line 494: RAISE FND_API.G_EXC_ERROR;

490:
491: IF ( l_Line_status = 5 ) THEN
492: FND_MESSAGE.SET_NAME('INV','INV_TO_HEADER_STATUS');
493: FND_MSG_PUB.ADD;
494: RAISE FND_API.G_EXC_ERROR;
495: END IF;
496:
497: IF ( l_mo_type <> 3 ) then /* 3 - pickwave type MO */
498: IF ( NVL(l_qty_del,0) <> 0 ) then

Line 500: RAISE FND_API.G_EXC_ERROR;

496:
497: IF ( l_mo_type <> 3 ) then /* 3 - pickwave type MO */
498: IF ( NVL(l_qty_del,0) <> 0 ) then
499:
500: RAISE FND_API.G_EXC_ERROR;
501: END IF;
502: END IF;
503:
504: l_old_trolin_rec := Inv_Trolin_Util.Query_Row( l_line_id );

Line 545: RAISE FND_API.G_EXC_ERROR;

541: ( G_PKG_NAME
542: , 'Cancel Line'
543: );
544:
545: RAISE FND_API.G_EXC_ERROR;
546: End;
547: ELSE
548: l_new_trolin_tbl(1).line_status := 6;
549: l_new_trolin_tbl(1).status_date := sysdate; --bug 5053725

Line 559: p_init_msg_list => FND_API.G_TRUE,

555:
556: /** call update line API **/
557: INV_Transfer_Order_PVT.Process_Transfer_Order
558: ( p_api_version_number => 1.0 ,
559: p_init_msg_list => FND_API.G_TRUE,
560: x_return_status => l_return_status,
561: x_msg_count => l_msg_count,
562: x_msg_data => l_msg_data,
563: p_trolin_tbl => l_new_trolin_tbl,

Line 570: if l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

566: x_trolin_tbl => l_x_trolin_tbl,
567: p_delete_mmtt => l_delete_mmtt --Added bug3524130
568: );
569:
570: if l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
572: elsif l_return_status = FND_API.G_RET_STS_ERROR then
573: RAISE FND_API.G_EXC_ERROR;
574: end if;

Line 571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

567: p_delete_mmtt => l_delete_mmtt --Added bug3524130
568: );
569:
570: if l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
572: elsif l_return_status = FND_API.G_RET_STS_ERROR then
573: RAISE FND_API.G_EXC_ERROR;
574: end if;
575:

Line 572: elsif l_return_status = FND_API.G_RET_STS_ERROR then

568: );
569:
570: if l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
572: elsif l_return_status = FND_API.G_RET_STS_ERROR then
573: RAISE FND_API.G_EXC_ERROR;
574: end if;
575:
576: x_return_status := l_return_status;

Line 573: RAISE FND_API.G_EXC_ERROR;

569:
570: if l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
572: elsif l_return_status = FND_API.G_RET_STS_ERROR then
573: RAISE FND_API.G_EXC_ERROR;
574: end if;
575:
576: x_return_status := l_return_status;
577:

Line 580: if FND_API.To_Boolean( p_commit ) then

576: x_return_status := l_return_status;
577:
578:
579: -- Std check of p_commit
580: if FND_API.To_Boolean( p_commit ) then
581: COMMIT WORK;
582: end if;
583:
584: -- Call to get msg count and data

Line 590: WHEN FND_API.G_EXC_ERROR THEN

586: p_count => x_msg_count,
587: p_data => x_msg_data ) ;
588:
589: EXCEPTION
590: WHEN FND_API.G_EXC_ERROR THEN
591: x_return_status := FND_API.G_RET_STS_ERROR;
592: FND_MSG_PUB.Count_And_Get(
593: p_count => x_msg_count,
594: p_data => x_msg_data) ;

Line 591: x_return_status := FND_API.G_RET_STS_ERROR;

587: p_data => x_msg_data ) ;
588:
589: EXCEPTION
590: WHEN FND_API.G_EXC_ERROR THEN
591: x_return_status := FND_API.G_RET_STS_ERROR;
592: FND_MSG_PUB.Count_And_Get(
593: p_count => x_msg_count,
594: p_data => x_msg_data) ;
595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

591: x_return_status := FND_API.G_RET_STS_ERROR;
592: FND_MSG_PUB.Count_And_Get(
593: p_count => x_msg_count,
594: p_data => x_msg_data) ;
595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
596: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
597: FND_MSG_PUB.Count_And_Get(
598: p_count => x_msg_count,
599: p_data => x_msg_data) ;

Line 596: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

592: FND_MSG_PUB.Count_And_Get(
593: p_count => x_msg_count,
594: p_data => x_msg_data) ;
595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
596: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
597: FND_MSG_PUB.Count_And_Get(
598: p_count => x_msg_count,
599: p_data => x_msg_data) ;
600: WHEN OTHERS THEN

Line 601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

597: FND_MSG_PUB.Count_And_Get(
598: p_count => x_msg_count,
599: p_data => x_msg_data) ;
600: WHEN OTHERS THEN
601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
602: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
603: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Cancel line');
604: END IF;
605: FND_MSG_PUB.Count_And_Get(

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

633: l_line_status Number;
634: l_qty_del Number;
635: l_qty Number;
636: l_request_number Varchar2(25) := NULL;
637: l_return_status Varchar2(1) := FND_API.G_RET_STS_SUCCESS;
638: l_loaded_lpn_exists Number; --Added bug3524130
639: l_org_id Number;
640: l_wms_org_flag Boolean;
641: l_wrd_exists NUMBER := 0;

Line 646: IF NOT FND_API.Compatible_API_Call ( l_api_version,

642:
643: BEGIN
644:
645: -- Standard call to check compatibility
646: IF NOT FND_API.Compatible_API_Call ( l_api_version,
647: p_api_version,
648: l_api_name,
649: G_PKG_NAME ) THEN
650: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 650: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

646: IF NOT FND_API.Compatible_API_Call ( l_api_version,
647: p_api_version,
648: l_api_name,
649: G_PKG_NAME ) THEN
650: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
651: END IF;
652:
653: -- Initailize message list
654: If FND_API.To_Boolean( p_init_msg_list ) Then

Line 654: If FND_API.To_Boolean( p_init_msg_list ) Then

650: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
651: END IF;
652:
653: -- Initailize message list
654: If FND_API.To_Boolean( p_init_msg_list ) Then
655: FND_MSG_PUB.initialize;
656: End If;
657:
658: -- API Body

Line 670: RAISE FND_API.G_EXC_ERROR;

666: WHERE Line_Id = l_Line_Id
667: FOR UPDATE NOWAIT;
668: EXCEPTION
669: WHEN No_Data_Found THEN
670: RAISE FND_API.G_EXC_ERROR;
671: WHEN app_exceptions.record_lock_exception THEN
672: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
673: fnd_message.set_name('ONT', 'OE_LOCK_ROW_ALREADY_LOCKED');
674: fnd_msg_pub.ADD;

Line 676: RAISE FND_API.G_EXC_ERROR;

672: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
673: fnd_message.set_name('ONT', 'OE_LOCK_ROW_ALREADY_LOCKED');
674: fnd_msg_pub.ADD;
675: END IF;
676: RAISE FND_API.G_EXC_ERROR;
677: WHEN OTHERS THEN
678: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Close Line');
679: RAISE FND_API.G_EXC_ERROR;
680: END;

Line 679: RAISE FND_API.G_EXC_ERROR;

675: END IF;
676: RAISE FND_API.G_EXC_ERROR;
677: WHEN OTHERS THEN
678: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Close Line');
679: RAISE FND_API.G_EXC_ERROR;
680: END;
681:
682: IF ( l_Line_status = 5 ) THEN
683: x_return_status := l_return_status ;

Line 690: RAISE FND_API.G_EXC_ERROR;

686:
687:
688: /*IF ( l_line_status in ( 3, 7 ) ) then
689: if ( nvl(l_qty_del, 0) < l_qty ) then
690: RAISE FND_API.G_EXC_ERROR;
691: end if;
692: END IF; */
693:
694: IF ( l_Line_status not in (3,4,6,7,9) ) THEN

Line 697: RAISE FND_API.G_EXC_ERROR;

693:
694: IF ( l_Line_status not in (3,4,6,7,9) ) THEN
695: FND_MESSAGE.SET_NAME('INV','INV_TO_HEADER_STATUS');
696: FND_MSG_PUB.ADD;
697: RAISE FND_API.G_EXC_ERROR;
698: END IF;
699:
700: /*Added bug3524130*/
701: l_loaded_lpn_exists := 0;

Line 740: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

736: EXCEPTION
737: When No_Data_Found Then
738: l_loaded_lpn_exists := 0;
739: When OTHERS then
740: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
741: END;
742: END IF; -- ( l_wms_org_flag ) THEN
743:
744:

Line 764: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

760: Exception
761: when NO_DATA_FOUND then
762: Null;
763: when OTHERS then
764: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
765: END;
766:
767:
768: -- Updating the who columns for bug 3277406

Line 783: if FND_API.To_Boolean( p_commit ) then

779: x_return_status := l_return_status;
780:
781:
782: -- Std check of p_commit
783: if FND_API.To_Boolean( p_commit ) then
784: COMMIT WORK;
785: end if;
786:
787: -- Call to get msg coount and data

Line 793: WHEN FND_API.G_EXC_ERROR THEN

789: p_count => x_msg_count,
790: p_data => x_msg_data ) ;
791:
792: Exception
793: WHEN FND_API.G_EXC_ERROR THEN
794: x_return_status := FND_API.G_RET_STS_ERROR;
795: FND_MSG_PUB.Count_And_Get(
796: p_count => x_msg_count,
797: p_data => x_msg_data ) ;

Line 794: x_return_status := FND_API.G_RET_STS_ERROR;

790: p_data => x_msg_data ) ;
791:
792: Exception
793: WHEN FND_API.G_EXC_ERROR THEN
794: x_return_status := FND_API.G_RET_STS_ERROR;
795: FND_MSG_PUB.Count_And_Get(
796: p_count => x_msg_count,
797: p_data => x_msg_data ) ;
798:

Line 799: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

795: FND_MSG_PUB.Count_And_Get(
796: p_count => x_msg_count,
797: p_data => x_msg_data ) ;
798:
799: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
800: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
801: FND_MSG_PUB.Count_And_Get(
802: p_count => x_msg_count,
803: p_data => x_msg_data ) ;

Line 800: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

796: p_count => x_msg_count,
797: p_data => x_msg_data ) ;
798:
799: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
800: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
801: FND_MSG_PUB.Count_And_Get(
802: p_count => x_msg_count,
803: p_data => x_msg_data ) ;
804: WHEN OTHERS THEN

Line 805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

801: FND_MSG_PUB.Count_And_Get(
802: p_count => x_msg_count,
803: p_data => x_msg_data ) ;
804: WHEN OTHERS THEN
805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
806: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
807: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Close line');
808: END IF;
809: FND_MSG_PUB.Count_And_Get(