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.GMO_DISPENSE_GRP dependencies on FND_API

Line 26: IF NOT FND_API.Compatible_API_Call (l_api_version ,

22: -- Standard Start of API savepoint
23: SAVEPOINT MAINTAIN_RESERVATION;
24:
25: -- Standard call to check for call compatibility.
26: IF NOT FND_API.Compatible_API_Call (l_api_version ,
27: p_api_version,
28: l_api_name,
29: G_PKG_NAME )
30: THEN

Line 31: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

27: p_api_version,
28: l_api_name,
29: G_PKG_NAME )
30: THEN
31: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
32: END IF;
33: -- Initialize message list if p_init_msg_list is set to TRUE.
34: IF FND_API.to_Boolean( p_init_msg_list ) THEN
35: FND_MSG_PUB.initialize;

Line 34: IF FND_API.to_Boolean( p_init_msg_list ) THEN

30: THEN
31: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
32: END IF;
33: -- Initialize message list if p_init_msg_list is set to TRUE.
34: IF FND_API.to_Boolean( p_init_msg_list ) THEN
35: FND_MSG_PUB.initialize;
36: END IF;
37:
38: -- check if GMO is enabled

Line 40: x_return_status := FND_API.G_RET_STS_SUCCESS;

36: END IF;
37:
38: -- check if GMO is enabled
39: IF (GMO_SETUP_GRP.IS_GMO_ENABLED = GMO_CONSTANTS_GRP.NO) THEN
40: x_return_status := FND_API.G_RET_STS_SUCCESS;
41: FND_MESSAGE.SET_NAME('GMO','GMO_DISABLED_ERR');
42: FND_MSG_PUB.ADD;
43: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
44: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 70: x_return_status := FND_API.G_RET_STS_SUCCESS;

66: and reservation_id = p_old_reservation_id
67: and nvl(batch_step_id,1) = nvl(p_batchstep_id,1);
68:
69: -- Initialize API return status to success
70: x_return_status := FND_API.G_RET_STS_SUCCESS;
71:
72: IF FND_API.To_Boolean( p_commit ) THEN
73: COMMIT;
74: END IF;

Line 72: IF FND_API.To_Boolean( p_commit ) THEN

68:
69: -- Initialize API return status to success
70: x_return_status := FND_API.G_RET_STS_SUCCESS;
71:
72: IF FND_API.To_Boolean( p_commit ) THEN
73: COMMIT;
74: END IF;
75:
76: -- Standard call to get message count and if count is 1, get message info.

Line 82: WHEN FND_API.G_EXC_ERROR THEN

78: ( p_count=> x_msg_count,
79: p_data => x_msg_data
80: );
81: EXCEPTION
82: WHEN FND_API.G_EXC_ERROR THEN
83: ROLLBACK TO MAINTAIN_RESERVATION;
84: x_return_status := FND_API.G_RET_STS_ERROR ;
85: FND_MSG_PUB.ADD;
86: FND_MSG_PUB.Count_And_Get

Line 84: x_return_status := FND_API.G_RET_STS_ERROR ;

80: );
81: EXCEPTION
82: WHEN FND_API.G_EXC_ERROR THEN
83: ROLLBACK TO MAINTAIN_RESERVATION;
84: x_return_status := FND_API.G_RET_STS_ERROR ;
85: FND_MSG_PUB.ADD;
86: FND_MSG_PUB.Count_And_Get
87: ( p_count=> x_msg_count ,
88: p_data=> x_msg_data

Line 90: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

86: FND_MSG_PUB.Count_And_Get
87: ( p_count=> x_msg_count ,
88: p_data=> x_msg_data
89: );
90: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
91: ROLLBACK TO MAINTAIN_RESERVATION;
92: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
93: FND_MSG_PUB.ADD;
94: FND_MSG_PUB.Count_And_Get

Line 92: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

88: p_data=> x_msg_data
89: );
90: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
91: ROLLBACK TO MAINTAIN_RESERVATION;
92: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
93: FND_MSG_PUB.ADD;
94: FND_MSG_PUB.Count_And_Get
95: ( p_count=> x_msg_count ,
96: p_data=> x_msg_data

Line 100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

96: p_data=> x_msg_data
97: );
98: WHEN OTHERS THEN
99: ROLLBACK TO MAINTAIN_RESERVATION;
100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
101: IF FND_MSG_PUB.Check_Msg_Level
102: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
103: THEN
104: FND_MSG_PUB.Add_Exc_Msg

Line 137: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

133:
134: -- Standard Start of API savepoint
135: SAVEPOINT CHANGE_DISPENSE_STATUS;
136: -- Standard call to check for call compatibility.
137: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
138: p_api_version ,
139: l_api_name ,
140: G_PKG_NAME )
141: THEN

Line 142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

138: p_api_version ,
139: l_api_name ,
140: G_PKG_NAME )
141: THEN
142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
143:
144: END IF;
145: -- Initialize message list if p_init_msg_list is set to TRUE.
146: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 146: IF FND_API.to_Boolean( p_init_msg_list ) THEN

142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
143:
144: END IF;
145: -- Initialize message list if p_init_msg_list is set to TRUE.
146: IF FND_API.to_Boolean( p_init_msg_list ) THEN
147: FND_MSG_PUB.initialize;
148: END IF;
149: -- check if GMO is enabled
150: IF (GMO_SETUP_GRP.IS_GMO_ENABLED = GMO_CONSTANTS_GRP.NO) THEN

Line 151: x_return_status := FND_API.G_RET_STS_SUCCESS;

147: FND_MSG_PUB.initialize;
148: END IF;
149: -- check if GMO is enabled
150: IF (GMO_SETUP_GRP.IS_GMO_ENABLED = GMO_CONSTANTS_GRP.NO) THEN
151: x_return_status := FND_API.G_RET_STS_SUCCESS;
152: FND_MESSAGE.SET_NAME('GMO','GMO_DISABLED_ERR');
153: FND_MSG_PUB.ADD;
154: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
155: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 180: x_return_status := FND_API.G_RET_STS_SUCCESS;

176: DISPENSE_SOURCE_TRANSACTION_ID = nvl(DISPENSE_SOURCE_TRANSACTION_ID, p_transaction_id)
177: WHERE dispense_id = p_dispense_id;
178:
179: -- Initialize API return status to success
180: x_return_status := FND_API.G_RET_STS_SUCCESS;
181:
182: IF FND_API.To_Boolean( p_commit ) THEN
183: COMMIT;
184: END IF;

Line 182: IF FND_API.To_Boolean( p_commit ) THEN

178:
179: -- Initialize API return status to success
180: x_return_status := FND_API.G_RET_STS_SUCCESS;
181:
182: IF FND_API.To_Boolean( p_commit ) THEN
183: COMMIT;
184: END IF;
185:
186:

Line 194: WHEN FND_API.G_EXC_ERROR THEN

190: p_data => x_msg_data
191: );
192:
193: EXCEPTION
194: WHEN FND_API.G_EXC_ERROR THEN
195: ROLLBACK TO CHANGE_DISPENSE_STATUS;
196: x_return_status := FND_API.G_RET_STS_ERROR ;
197: FND_MSG_PUB.ADD;
198: FND_MSG_PUB.Count_And_Get

Line 196: x_return_status := FND_API.G_RET_STS_ERROR ;

192:
193: EXCEPTION
194: WHEN FND_API.G_EXC_ERROR THEN
195: ROLLBACK TO CHANGE_DISPENSE_STATUS;
196: x_return_status := FND_API.G_RET_STS_ERROR ;
197: FND_MSG_PUB.ADD;
198: FND_MSG_PUB.Count_And_Get
199: ( p_count=> x_msg_count ,
200: p_data=> x_msg_data

Line 202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

198: FND_MSG_PUB.Count_And_Get
199: ( p_count=> x_msg_count ,
200: p_data=> x_msg_data
201: );
202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
203: ROLLBACK TO CHANGE_DISPENSE_STATUS;
204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
205: FND_MSG_PUB.ADD;
206: FND_MSG_PUB.Count_And_Get

Line 204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

200: p_data=> x_msg_data
201: );
202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
203: ROLLBACK TO CHANGE_DISPENSE_STATUS;
204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
205: FND_MSG_PUB.ADD;
206: FND_MSG_PUB.Count_And_Get
207: ( p_count=> x_msg_count ,
208: p_data=> x_msg_data

Line 212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

208: p_data=> x_msg_data
209: );
210: WHEN WRONG_STATUS_ERROR THEN
211: ROLLBACK TO CHANGE_DISPENSE_STATUS;
212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
213: FND_MSG_PUB.ADD;
214: FND_MSG_PUB.Count_And_Get
215: ( p_count=> x_msg_count ,
216: p_data=> x_msg_data

Line 220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

216: p_data=> x_msg_data
217: );
218: WHEN OTHERS THEN
219: ROLLBACK TO CHANGE_DISPENSE_STATUS;
220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
221: IF FND_MSG_PUB.Check_Msg_Level
222: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
223: THEN
224: FND_MSG_PUB.Add_Exc_Msg

Line 264: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )

260: GMO_ITEM_NOT_RESERVABLE_ERR EXCEPTION;
261:
262:
263: BEGIN
264: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )
265: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
266: END IF;
267:
268: -- Initialize message list if the caller asks me to do so

Line 265: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;

261:
262:
263: BEGIN
264: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )
265: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
266: END IF;
267:
268: -- Initialize message list if the caller asks me to do so
269: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 269: IF FND_API.to_Boolean( p_init_msg_list ) THEN

265: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
266: END IF;
267:
268: -- Initialize message list if the caller asks me to do so
269: IF FND_API.to_Boolean( p_init_msg_list ) THEN
270: FND_MSG_PUB.initialize;
271: END IF;
272: -- check if GMO is enabled
273: IF (GMO_SETUP_GRP.IS_GMO_ENABLED = GMO_CONSTANTS_GRP.NO) THEN

Line 274: x_return_status := FND_API.G_RET_STS_SUCCESS;

270: FND_MSG_PUB.initialize;
271: END IF;
272: -- check if GMO is enabled
273: IF (GMO_SETUP_GRP.IS_GMO_ENABLED = GMO_CONSTANTS_GRP.NO) THEN
274: x_return_status := FND_API.G_RET_STS_SUCCESS;
275: FND_MESSAGE.SET_NAME('GMO','GMO_DISABLED_ERR');
276: FND_MSG_PUB.ADD;
277: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
278: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 308: x_return_status := FND_API.G_RET_STS_SUCCESS;

304: RAISE GMO_ITEM_NOT_RESERVABLE_ERR;
305: END IF;
306: END IF;
307:
308: x_return_status := FND_API.G_RET_STS_SUCCESS;
309: FND_MSG_PUB.Add;
310: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
311:
312: EXCEPTION

Line 313: WHEN FND_API.G_EXC_ERROR THEN

309: FND_MSG_PUB.Add;
310: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
311:
312: EXCEPTION
313: WHEN FND_API.G_EXC_ERROR THEN
314: x_return_status := FND_API.G_RET_STS_ERROR ;
315: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
316:
317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 314: x_return_status := FND_API.G_RET_STS_ERROR ;

310: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
311:
312: EXCEPTION
313: WHEN FND_API.G_EXC_ERROR THEN
314: x_return_status := FND_API.G_RET_STS_ERROR ;
315: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
316:
317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

313: WHEN FND_API.G_EXC_ERROR THEN
314: x_return_status := FND_API.G_RET_STS_ERROR ;
315: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
316:
317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
319: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
320: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
321: END IF;

Line 318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

314: x_return_status := FND_API.G_RET_STS_ERROR ;
315: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
316:
317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
319: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
320: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
321: END IF;
322: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

Line 332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

328: FND_MSG_PUB.ADD;
329: FND_MSG_PUB.COUNT_AND_GET ( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
330:
331: WHEN OTHERS THEN
332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
333: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
334: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
335: END IF;
336: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

Line 353: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )

349: l_api_name CONSTANT VARCHAR2(30) := 'GET_MATERIAL_DISPENSE_DATA';
350: l_api_version CONSTANT NUMBER := 1.0;
351: BEGIN
352:
353: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )
354: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
355: END IF;
356:
357: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 354: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;

350: l_api_version CONSTANT NUMBER := 1.0;
351: BEGIN
352:
353: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )
354: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
355: END IF;
356:
357: IF FND_API.to_Boolean( p_init_msg_list ) THEN
358: FND_MSG_PUB.initialize;

Line 357: IF FND_API.to_Boolean( p_init_msg_list ) THEN

353: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )
354: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
355: END IF;
356:
357: IF FND_API.to_Boolean( p_init_msg_list ) THEN
358: FND_MSG_PUB.initialize;
359: END IF;
360: -- check if GMO is enabled
361: IF (GMO_SETUP_GRP.IS_GMO_ENABLED = GMO_CONSTANTS_GRP.NO) THEN

Line 362: x_return_status := FND_API.G_RET_STS_SUCCESS;

358: FND_MSG_PUB.initialize;
359: END IF;
360: -- check if GMO is enabled
361: IF (GMO_SETUP_GRP.IS_GMO_ENABLED = GMO_CONSTANTS_GRP.NO) THEN
362: x_return_status := FND_API.G_RET_STS_SUCCESS;
363: FND_MESSAGE.SET_NAME('GMO','GMO_DISABLED_ERR');
364: FND_MSG_PUB.ADD;
365: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
366: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 374: x_return_status := FND_API.G_RET_STS_SUCCESS;

370: END IF;
371:
372: GMO_DISPENSE_PVT.GET_MATERIAL_DISPENSE_DATA( p_material_detail_id,
373: x_dispense_data);
374: x_return_status := FND_API.G_RET_STS_SUCCESS;
375:
376: FND_MSG_PUB.Add;
377: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
378: EXCEPTION

Line 379: WHEN FND_API.G_EXC_ERROR THEN

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

Line 380: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 383: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

379: WHEN FND_API.G_EXC_ERROR THEN
380: x_return_status := FND_API.G_RET_STS_ERROR ;
381: FND_MSG_PUB.ADD;
382: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
383: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
385: FND_MSG_PUB.ADD;
386: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
387: WHEN OTHERS THEN

Line 384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

380: x_return_status := FND_API.G_RET_STS_ERROR ;
381: FND_MSG_PUB.ADD;
382: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
383: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
385: FND_MSG_PUB.ADD;
386: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
387: WHEN OTHERS THEN
388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
385: FND_MSG_PUB.ADD;
386: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
387: WHEN OTHERS THEN
388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
389: FND_MSG_PUB.ADD;
390: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
391: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
392: END IF;

Line 419: IF NOT FND_API.COMPATIBLE_API_CALL(L_API_VERSION,

415:
416: BEGIN
417:
418: --Validate the API versions.
419: IF NOT FND_API.COMPATIBLE_API_CALL(L_API_VERSION,
420: P_API_VERSION,
421: L_API_NAME,
422: G_PKG_NAME)
423: THEN

Line 425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

421: L_API_NAME,
422: G_PKG_NAME)
423: THEN
424:
425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
426:
427: END IF;
428:
429: --Initialized the message list if specified so.

Line 430: IF FND_API.TO_BOOLEAN(P_INIT_MSG_LIST) THEN

426:
427: END IF;
428:
429: --Initialized the message list if specified so.
430: IF FND_API.TO_BOOLEAN(P_INIT_MSG_LIST) THEN
431:
432: FND_MSG_PUB.INITIALIZE;
433:
434: END IF;

Line 438: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

434: END IF;
435:
436:
437: IF (GMO_SETUP_GRP.IS_GMO_ENABLED = GMO_CONSTANTS_GRP.NO) THEN
438: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
439: FND_MESSAGE.SET_NAME('GMO','GMO_DISABLED_ERR');
440: FND_MSG_PUB.ADD;
441: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
442: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 473: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;

469: EXCEPTION
470:
471: WHEN OTHERS THEN
472:
473: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
474:
475: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
476: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
477: FND_MESSAGE.SET_TOKEN('PKG_NAME','GMO_DISPENSE_GRP');