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_CONSIGNED_VALIDATIONS_GRP dependencies on FND_API

Line 117: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

113: ) IS
114:
115: l_api_version_number CONSTANT NUMBER := 1.0;
116: l_api_name CONSTANT VARCHAR2(30) := 'GET_CONSIGNED_QUANTITY';
117: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
118: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
119:
120: BEGIN
121: -- Standard call to check for call compatibility

Line 122: IF NOT fnd_api.compatible_api_call(l_api_version_number

118: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
119:
120: BEGIN
121: -- Standard call to check for call compatibility
122: IF NOT fnd_api.compatible_api_call(l_api_version_number
123: , p_api_version_number
124: , l_api_name
125: , G_PKG_NAME
126: ) THEN

Line 127: RAISE fnd_api.g_exc_unexpected_error;

123: , p_api_version_number
124: , l_api_name
125: , G_PKG_NAME
126: ) THEN
127: RAISE fnd_api.g_exc_unexpected_error;
128: END IF;
129:
130: -- Initialize message list.
131: IF fnd_api.to_boolean(p_init_msg_lst) THEN

Line 131: IF fnd_api.to_boolean(p_init_msg_lst) THEN

127: RAISE fnd_api.g_exc_unexpected_error;
128: END IF;
129:
130: -- Initialize message list.
131: IF fnd_api.to_boolean(p_init_msg_lst) THEN
132: fnd_msg_pub.initialize;
133: END IF;
134:
135: IF (l_debug = 1) THEN

Line 181: IF l_return_status = fnd_api.g_ret_sts_error THEN

177: , x_satt => x_satt -- invConv change
178: );
179:
180:
181: IF l_return_status = fnd_api.g_ret_sts_error THEN
182: RAISE fnd_api.g_exc_error;
183: END IF ;
184:
185: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 182: RAISE fnd_api.g_exc_error;

178: );
179:
180:
181: IF l_return_status = fnd_api.g_ret_sts_error THEN
182: RAISE fnd_api.g_exc_error;
183: END IF ;
184:
185: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
186: RAISE fnd_api.g_exc_unexpected_error;

Line 185: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

181: IF l_return_status = fnd_api.g_ret_sts_error THEN
182: RAISE fnd_api.g_exc_error;
183: END IF ;
184:
185: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
186: RAISE fnd_api.g_exc_unexpected_error;
187: END IF;
188:
189: x_return_status := l_return_status;

Line 186: RAISE fnd_api.g_exc_unexpected_error;

182: RAISE fnd_api.g_exc_error;
183: END IF ;
184:
185: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
186: RAISE fnd_api.g_exc_unexpected_error;
187: END IF;
188:
189: x_return_status := l_return_status;
190:

Line 196: WHEN fnd_api.g_exc_error THEN

192: inv_log_util.trace('Finished calling INV_CONSIGNED_VALIDATIONS.GET_CONSIGNED_QUANTITY','CONSIGNED_VALIDATIONS',9);
193: END IF;
194:
195: EXCEPTION
196: WHEN fnd_api.g_exc_error THEN
197: x_return_status := fnd_api.g_ret_sts_error;
198:
199: -- Get message count and data
200: fnd_msg_pub.count_and_get

Line 197: x_return_status := fnd_api.g_ret_sts_error;

193: END IF;
194:
195: EXCEPTION
196: WHEN fnd_api.g_exc_error THEN
197: x_return_status := fnd_api.g_ret_sts_error;
198:
199: -- Get message count and data
200: fnd_msg_pub.count_and_get
201: ( p_count => x_msg_count

Line 205: WHEN fnd_api.g_exc_unexpected_error THEN

201: ( p_count => x_msg_count
202: , p_data => x_msg_data
203: );
204:
205: WHEN fnd_api.g_exc_unexpected_error THEN
206: x_return_status := fnd_api.g_ret_sts_unexp_error ;
207:
208: -- Get message count and data
209: fnd_msg_pub.count_and_get

Line 206: x_return_status := fnd_api.g_ret_sts_unexp_error ;

202: , p_data => x_msg_data
203: );
204:
205: WHEN fnd_api.g_exc_unexpected_error THEN
206: x_return_status := fnd_api.g_ret_sts_unexp_error ;
207:
208: -- Get message count and data
209: fnd_msg_pub.count_and_get
210: ( p_count => x_msg_count

Line 215: x_return_status := fnd_api.g_ret_sts_unexp_error ;

211: , p_data => x_msg_data
212: );
213:
214: WHEN OTHERS THEN
215: x_return_status := fnd_api.g_ret_sts_unexp_error ;
216:
217: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
218: THEN
219: fnd_msg_pub.add_exc_msg

Line 290: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

286:
287:
288: l_api_version_number CONSTANT NUMBER := 1.0;
289: l_api_name CONSTANT VARCHAR2(30) := 'GET_PLANNING_QUANTITY';
290: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
291: l_qty NUMBER := 0;
292: l_sqty NUMBER := NULL;
293: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
294:

Line 297: IF NOT fnd_api.compatible_api_call(l_api_version_number

293: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
294:
295: BEGIN
296: -- Standard call to check for call compatibility
297: IF NOT fnd_api.compatible_api_call(l_api_version_number
298: , p_api_version_number
299: , l_api_name
300: , G_PKG_NAME
301: ) THEN

Line 302: RAISE fnd_api.g_exc_unexpected_error;

298: , p_api_version_number
299: , l_api_name
300: , G_PKG_NAME
301: ) THEN
302: RAISE fnd_api.g_exc_unexpected_error;
303: END IF;
304:
305: -- Initialize message list.
306: IF fnd_api.to_boolean(p_init_msg_lst) THEN

Line 306: IF fnd_api.to_boolean(p_init_msg_lst) THEN

302: RAISE fnd_api.g_exc_unexpected_error;
303: END IF;
304:
305: -- Initialize message list.
306: IF fnd_api.to_boolean(p_init_msg_lst) THEN
307: fnd_msg_pub.initialize;
308: END IF;
309:
310: IF (l_debug=1) THEN

Line 344: WHEN fnd_api.g_exc_error THEN

340: x_planning_qty := l_qty;
341: x_planning_sqty := l_sqty; -- invConv changes
342:
343: EXCEPTION
344: WHEN fnd_api.g_exc_error THEN
345: x_return_status := fnd_api.g_ret_sts_error;
346:
347: -- Get message count and data
348: fnd_msg_pub.count_and_get

Line 345: x_return_status := fnd_api.g_ret_sts_error;

341: x_planning_sqty := l_sqty; -- invConv changes
342:
343: EXCEPTION
344: WHEN fnd_api.g_exc_error THEN
345: x_return_status := fnd_api.g_ret_sts_error;
346:
347: -- Get message count and data
348: fnd_msg_pub.count_and_get
349: ( p_count => x_msg_count

Line 353: WHEN fnd_api.g_exc_unexpected_error THEN

349: ( p_count => x_msg_count
350: , p_data => x_msg_data
351: );
352:
353: WHEN fnd_api.g_exc_unexpected_error THEN
354: x_return_status := fnd_api.g_ret_sts_unexp_error ;
355:
356: -- Get message count and data
357: fnd_msg_pub.count_and_get

Line 354: x_return_status := fnd_api.g_ret_sts_unexp_error ;

350: , p_data => x_msg_data
351: );
352:
353: WHEN fnd_api.g_exc_unexpected_error THEN
354: x_return_status := fnd_api.g_ret_sts_unexp_error ;
355:
356: -- Get message count and data
357: fnd_msg_pub.count_and_get
358: ( p_count => x_msg_count

Line 363: x_return_status := fnd_api.g_ret_sts_unexp_error ;

359: , p_data => x_msg_data
360: );
361:
362: WHEN OTHERS THEN
363: x_return_status := fnd_api.g_ret_sts_unexp_error ;
364:
365: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
366: THEN
367: fnd_msg_pub.add_exc_msg

Line 399: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

395: ) IS
396:
397: l_api_version_number CONSTANT NUMBER := 1.0;
398: l_api_name CONSTANT VARCHAR2(30) := 'GET_PLANNING_SD_QUANTITY';
399: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
400: l_qty NUMBER := 0;
401: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
402:
403: BEGIN

Line 405: IF NOT fnd_api.compatible_api_call

401: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
402:
403: BEGIN
404: -- Standard call to check for call compatibility
405: IF NOT fnd_api.compatible_api_call
406: (l_api_version_number
407: , p_api_version_number
408: , l_api_name
409: , G_PKG_NAME

Line 411: RAISE fnd_api.g_exc_unexpected_error;

407: , p_api_version_number
408: , l_api_name
409: , G_PKG_NAME
410: ) THEN
411: RAISE fnd_api.g_exc_unexpected_error;
412: END IF;
413:
414: -- Initialize message list.
415: IF fnd_api.to_boolean(p_init_msg_lst) THEN

Line 415: IF fnd_api.to_boolean(p_init_msg_lst) THEN

411: RAISE fnd_api.g_exc_unexpected_error;
412: END IF;
413:
414: -- Initialize message list.
415: IF fnd_api.to_boolean(p_init_msg_lst) THEN
416: fnd_msg_pub.initialize;
417: END IF;
418:
419: IF (l_debug=1) THEN

Line 437: WHEN fnd_api.g_exc_error THEN

433: x_return_status := l_return_status;
434: x_planning_qty := l_qty;
435:
436: EXCEPTION
437: WHEN fnd_api.g_exc_error THEN
438: x_return_status := fnd_api.g_ret_sts_error;
439:
440: -- Get message count and data
441: fnd_msg_pub.count_and_get

Line 438: x_return_status := fnd_api.g_ret_sts_error;

434: x_planning_qty := l_qty;
435:
436: EXCEPTION
437: WHEN fnd_api.g_exc_error THEN
438: x_return_status := fnd_api.g_ret_sts_error;
439:
440: -- Get message count and data
441: fnd_msg_pub.count_and_get
442: ( p_count => x_msg_count

Line 446: WHEN fnd_api.g_exc_unexpected_error THEN

442: ( p_count => x_msg_count
443: , p_data => x_msg_data
444: );
445:
446: WHEN fnd_api.g_exc_unexpected_error THEN
447: x_return_status := fnd_api.g_ret_sts_unexp_error ;
448:
449: -- Get message count and data
450: fnd_msg_pub.count_and_get

Line 447: x_return_status := fnd_api.g_ret_sts_unexp_error ;

443: , p_data => x_msg_data
444: );
445:
446: WHEN fnd_api.g_exc_unexpected_error THEN
447: x_return_status := fnd_api.g_ret_sts_unexp_error ;
448:
449: -- Get message count and data
450: fnd_msg_pub.count_and_get
451: ( p_count => x_msg_count

Line 456: x_return_status := fnd_api.g_ret_sts_unexp_error ;

452: , p_data => x_msg_data
453: );
454:
455: WHEN OTHERS THEN
456: x_return_status := fnd_api.g_ret_sts_unexp_error ;
457:
458: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
459: THEN
460: fnd_msg_pub.add_exc_msg