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

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

32: , p_file_name IN VARCHAR2
33: , p_program_name IN VARCHAR2
34: , p_new_or_append IN NUMBER
35: ) IS
36: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
37: l_buff VARCHAR2(2000); -- translated message
38: BEGIN
39: /* get translation for mesage code into l_buff */
40: FND_MESSAGE.SET_NAME(p_appl_short_name, p_msg_to_append);

Line 58: x_return_status := fnd_api.g_ret_sts_unexp_error ;

54: -- utl_file.invalid_mode - the open_mode string was invalid
55: -- utl_file.invalid_filehandle - file handle is invalid
56: -- utl_file.invalid_operation - file is not open for writing/appending
57: -- utl_file.write_error - OS error occured during write operation
58: x_return_status := fnd_api.g_ret_sts_unexp_error ;
59:
60: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
61: THEN
62: fnd_msg_pub.add_exc_msg

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

73: , p_inventory_item_id IN NUMBER
74: , p_organization_id IN NUMBER
75: , x_index OUT NOCOPY NUMBER
76: ) IS
77: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
78: l_index NUMBER;
79: l_rec inv_reservation_global.item_record;
80: BEGIN
81: IF inv_reservation_global.g_item_record_cache.EXISTS(p_inventory_item_id) THEN

Line 113: x_return_status := fnd_api.g_ret_sts_unexp_error ;

109: x_return_status := l_return_status;
110:
111: EXCEPTION
112: WHEN OTHERS THEN
113: x_return_status := fnd_api.g_ret_sts_unexp_error ;
114:
115: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
116: THEN
117: fnd_msg_pub.add_exc_msg

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

127: x_return_status OUT NOCOPY VARCHAR2
128: , p_item_record IN inv_reservation_global.item_record
129: , x_index OUT NOCOPY NUMBER
130: ) IS
131: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
132: l_index NUMBER;
133: BEGIN
134: --l_index := inv_reservation_global.g_item_record_cache.COUNT+1;
135: l_index := p_item_record.inventory_item_id;

Line 144: x_return_status := fnd_api.g_ret_sts_unexp_error ;

140: x_return_status := l_return_status;
141:
142: EXCEPTION
143: WHEN OTHERS THEN
144: x_return_status := fnd_api.g_ret_sts_unexp_error ;
145:
146: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
147: THEN
148: fnd_msg_pub.add_exc_msg

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

158: x_return_status OUT NOCOPY VARCHAR2
159: , p_organization_id IN NUMBER
160: , x_index OUT NOCOPY NUMBER
161: ) IS
162: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
163: l_index NUMBER;
164: l_rec inv_reservation_global.organization_record;
165: BEGIN
166: IF inv_reservation_global.g_organization_record_cache.EXISTS(p_organization_id) THEN

Line 196: x_return_status := fnd_api.g_ret_sts_unexp_error ;

192: x_return_status := l_return_status;
193:
194: EXCEPTION
195: WHEN OTHERS THEN
196: x_return_status := fnd_api.g_ret_sts_unexp_error ;
197:
198: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
199: THEN
200: fnd_msg_pub.add_exc_msg

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

210: x_return_status OUT NOCOPY VARCHAR2
211: , p_organization_record IN inv_reservation_global.organization_record
212: , x_index OUT NOCOPY NUMBER
213: ) IS
214: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
215: l_index NUMBER;
216: BEGIN
217: --l_index := inv_reservation_global.g_organization_record_cache.COUNT+1;
218: l_index := p_organization_record.organization_id;

Line 227: x_return_status := fnd_api.g_ret_sts_unexp_error ;

223: x_return_status := l_return_status;
224:
225: EXCEPTION
226: WHEN OTHERS THEN
227: x_return_status := fnd_api.g_ret_sts_unexp_error ;
228:
229: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
230: THEN
231: fnd_msg_pub.add_exc_msg

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

244: , p_demand_source_line_id IN NUMBER
245: , p_demand_source_name IN VARCHAR2
246: , x_index OUT NOCOPY NUMBER
247: ) IS
248: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
249: l_index NUMBER;
250: l_rec inv_reservation_global.demand_record;
251: BEGIN
252:

Line 311: x_return_status := fnd_api.g_ret_sts_unexp_error ;

307: x_return_status := l_return_status;
308:
309: EXCEPTION
310: WHEN OTHERS THEN
311: x_return_status := fnd_api.g_ret_sts_unexp_error ;
312:
313: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
314: THEN
315: fnd_msg_pub.add_exc_msg

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

325: x_return_status OUT NOCOPY VARCHAR2
326: , p_demand_record IN inv_reservation_global.demand_record
327: , x_index OUT NOCOPY NUMBER
328: ) IS
329: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
330: l_index NUMBER;
331: BEGIN
332: IF p_demand_record.demand_source_line_id IS NOT NULL THEN
333: l_index := p_demand_record.demand_source_line_id;

Line 355: x_return_status := fnd_api.g_ret_sts_unexp_error ;

351: x_return_status := l_return_status;
352:
353: EXCEPTION
354: WHEN OTHERS THEN
355: x_return_status := fnd_api.g_ret_sts_unexp_error ;
356:
357: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
358: THEN
359: fnd_msg_pub.add_exc_msg

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

372: , p_supply_source_line_id IN NUMBER
373: , p_supply_source_name IN VARCHAR2
374: , x_index OUT NOCOPY NUMBER
375: ) IS
376: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
377: l_index NUMBER;
378: l_rec inv_reservation_global.supply_record;
379: BEGIN
380:

Line 424: x_return_status := fnd_api.g_ret_sts_unexp_error ;

420: x_return_status := l_return_status;
421:
422: EXCEPTION
423: WHEN OTHERS THEN
424: x_return_status := fnd_api.g_ret_sts_unexp_error ;
425:
426: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
427: THEN
428: fnd_msg_pub.add_exc_msg

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

438: x_return_status OUT NOCOPY VARCHAR2
439: , p_supply_record IN inv_reservation_global.supply_record
440: , x_index OUT NOCOPY NUMBER
441: ) IS
442: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
443: l_index NUMBER;
444: BEGIN
445: l_index := inv_reservation_global.g_supply_record_cache.COUNT+1;
446: inv_reservation_global.g_supply_record_cache(l_index)

Line 454: x_return_status := fnd_api.g_ret_sts_unexp_error ;

450: x_return_status := l_return_status;
451:
452: EXCEPTION
453: WHEN OTHERS THEN
454: x_return_status := fnd_api.g_ret_sts_unexp_error ;
455:
456: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
457: THEN
458: fnd_msg_pub.add_exc_msg

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

469: , p_subinventory_code IN VARCHAR2
470: , p_organization_id IN NUMBER
471: , x_index OUT NOCOPY NUMBER
472: ) IS
473: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
474: l_index NUMBER;
475: BEGIN
476: -- Modified for common API. Secondary_inventory_name replaces
477: -- subinventory_code

Line 509: x_return_status := fnd_api.g_ret_sts_unexp_error ;

505: x_return_status := l_return_status;
506:
507: EXCEPTION
508: WHEN OTHERS THEN
509: x_return_status := fnd_api.g_ret_sts_unexp_error ;
510:
511: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
512: THEN
513: fnd_msg_pub.add_exc_msg

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

523: x_return_status OUT NOCOPY VARCHAR2
524: , p_sub_record IN inv_reservation_global.sub_record
525: , x_index OUT NOCOPY NUMBER
526: ) IS
527: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
528: l_index NUMBER;
529: BEGIN
530: l_index := inv_reservation_global.g_sub_record_cache.COUNT+1;
531: inv_reservation_global.g_sub_record_cache(l_index)

Line 539: x_return_status := fnd_api.g_ret_sts_unexp_error ;

535: x_return_status := l_return_status;
536:
537: EXCEPTION
538: WHEN OTHERS THEN
539: x_return_status := fnd_api.g_ret_sts_unexp_error ;
540:
541: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
542: THEN
543: fnd_msg_pub.add_exc_msg

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

644: (
645: x_return_status OUT NOCOPY VARCHAR2
646: , p_wip_entity_id IN NUMBER
647: ) IS
648: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
649: l_msg_count NUMBER;
650: l_msg_data VARCHAR2(1000);
651: l_wip_entity_type NUMBER;
652: l_wip_job_type VARCHAR2(15);

Line 659: , p_init_msg_lst => fnd_api.g_false

655: IF (NOT inv_reservation_global.g_wip_record_cache.EXISTS(p_wip_entity_id)) THEN
656: -- call get_wip_entity API
657: inv_reservation_pvt.get_wip_entity_type
658: ( p_api_version_number => 1.0
659: , p_init_msg_lst => fnd_api.g_false
660: , x_return_status => l_return_status
661: , x_msg_count => l_msg_count
662: , x_msg_data => l_msg_data
663: , p_organization_id => null

Line 673: IF (l_return_status = fnd_api.g_ret_sts_error) THEN

669: , x_wip_entity_type => l_wip_entity_type
670: , x_wip_job_type => l_wip_job_type
671: );
672:
673: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
674: RAISE fnd_api.g_exc_error;
675: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
676: RAISE fnd_api.g_exc_unexpected_error;
677: END IF;

Line 674: RAISE fnd_api.g_exc_error;

670: , x_wip_job_type => l_wip_job_type
671: );
672:
673: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
674: RAISE fnd_api.g_exc_error;
675: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
676: RAISE fnd_api.g_exc_unexpected_error;
677: END IF;
678:

Line 675: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN

671: );
672:
673: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
674: RAISE fnd_api.g_exc_error;
675: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
676: RAISE fnd_api.g_exc_unexpected_error;
677: END IF;
678:
679: inv_reservation_global.g_wip_record_cache(p_wip_entity_id).wip_entity_id

Line 676: RAISE fnd_api.g_exc_unexpected_error;

672:
673: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
674: RAISE fnd_api.g_exc_error;
675: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
676: RAISE fnd_api.g_exc_unexpected_error;
677: END IF;
678:
679: inv_reservation_global.g_wip_record_cache(p_wip_entity_id).wip_entity_id
680: := p_wip_entity_id;

Line 691: WHEN fnd_api.g_exc_error THEN

687: END IF;
688:
689: x_return_status := l_return_status;
690: EXCEPTION
691: WHEN fnd_api.g_exc_error THEN
692: x_return_status := fnd_api.g_ret_sts_error;
693: --
694: WHEN fnd_api.g_exc_unexpected_error THEN
695: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 692: x_return_status := fnd_api.g_ret_sts_error;

688:
689: x_return_status := l_return_status;
690: EXCEPTION
691: WHEN fnd_api.g_exc_error THEN
692: x_return_status := fnd_api.g_ret_sts_error;
693: --
694: WHEN fnd_api.g_exc_unexpected_error THEN
695: x_return_status := fnd_api.g_ret_sts_unexp_error ;
696: WHEN OTHERS THEN

Line 694: WHEN fnd_api.g_exc_unexpected_error THEN

690: EXCEPTION
691: WHEN fnd_api.g_exc_error THEN
692: x_return_status := fnd_api.g_ret_sts_error;
693: --
694: WHEN fnd_api.g_exc_unexpected_error THEN
695: x_return_status := fnd_api.g_ret_sts_unexp_error ;
696: WHEN OTHERS THEN
697: x_return_status := fnd_api.g_ret_sts_unexp_error ;
698:

Line 695: x_return_status := fnd_api.g_ret_sts_unexp_error ;

691: WHEN fnd_api.g_exc_error THEN
692: x_return_status := fnd_api.g_ret_sts_error;
693: --
694: WHEN fnd_api.g_exc_unexpected_error THEN
695: x_return_status := fnd_api.g_ret_sts_unexp_error ;
696: WHEN OTHERS THEN
697: x_return_status := fnd_api.g_ret_sts_unexp_error ;
698:
699: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 697: x_return_status := fnd_api.g_ret_sts_unexp_error ;

693: --
694: WHEN fnd_api.g_exc_unexpected_error THEN
695: x_return_status := fnd_api.g_ret_sts_unexp_error ;
696: WHEN OTHERS THEN
697: x_return_status := fnd_api.g_ret_sts_unexp_error ;
698:
699: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
700: fnd_msg_pub.add_exc_msg
701: ( g_pkg_name