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 320: x_return_status := fnd_api.g_ret_sts_unexp_error ;

316: x_return_status := l_return_status;
317:
318: EXCEPTION
319: WHEN OTHERS THEN
320: x_return_status := fnd_api.g_ret_sts_unexp_error ;
321:
322: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
323: THEN
324: fnd_msg_pub.add_exc_msg

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

334: x_return_status OUT NOCOPY VARCHAR2
335: , p_demand_record IN inv_reservation_global.demand_record
336: , x_index OUT NOCOPY NUMBER
337: ) IS
338: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
339: l_index NUMBER;
340: BEGIN
341: IF p_demand_record.demand_source_line_id IS NOT NULL THEN
342: --#BUG7717612#

Line 367: x_return_status := fnd_api.g_ret_sts_unexp_error ;

363: x_return_status := l_return_status;
364:
365: EXCEPTION
366: WHEN OTHERS THEN
367: x_return_status := fnd_api.g_ret_sts_unexp_error ;
368:
369: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
370: THEN
371: fnd_msg_pub.add_exc_msg

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

384: , p_supply_source_line_id IN NUMBER
385: , p_supply_source_name IN VARCHAR2
386: , x_index OUT NOCOPY NUMBER
387: ) IS
388: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
389: l_index NUMBER;
390: l_rec inv_reservation_global.supply_record;
391: BEGIN
392:

Line 436: x_return_status := fnd_api.g_ret_sts_unexp_error ;

432: x_return_status := l_return_status;
433:
434: EXCEPTION
435: WHEN OTHERS THEN
436: x_return_status := fnd_api.g_ret_sts_unexp_error ;
437:
438: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
439: THEN
440: fnd_msg_pub.add_exc_msg

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

450: x_return_status OUT NOCOPY VARCHAR2
451: , p_supply_record IN inv_reservation_global.supply_record
452: , x_index OUT NOCOPY NUMBER
453: ) IS
454: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
455: l_index NUMBER;
456: BEGIN
457: l_index := inv_reservation_global.g_supply_record_cache.COUNT+1;
458: inv_reservation_global.g_supply_record_cache(l_index)

Line 466: x_return_status := fnd_api.g_ret_sts_unexp_error ;

462: x_return_status := l_return_status;
463:
464: EXCEPTION
465: WHEN OTHERS THEN
466: x_return_status := fnd_api.g_ret_sts_unexp_error ;
467:
468: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
469: THEN
470: fnd_msg_pub.add_exc_msg

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

481: , p_subinventory_code IN VARCHAR2
482: , p_organization_id IN NUMBER
483: , x_index OUT NOCOPY NUMBER
484: ) IS
485: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
486: l_index NUMBER;
487: BEGIN
488: -- Modified for common API. Secondary_inventory_name replaces
489: -- subinventory_code

Line 521: x_return_status := fnd_api.g_ret_sts_unexp_error ;

517: x_return_status := l_return_status;
518:
519: EXCEPTION
520: WHEN OTHERS THEN
521: x_return_status := fnd_api.g_ret_sts_unexp_error ;
522:
523: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
524: THEN
525: fnd_msg_pub.add_exc_msg

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

535: x_return_status OUT NOCOPY VARCHAR2
536: , p_sub_record IN inv_reservation_global.sub_record
537: , x_index OUT NOCOPY NUMBER
538: ) IS
539: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
540: l_index NUMBER;
541: BEGIN
542: l_index := inv_reservation_global.g_sub_record_cache.COUNT+1;
543: inv_reservation_global.g_sub_record_cache(l_index)

Line 551: x_return_status := fnd_api.g_ret_sts_unexp_error ;

547: x_return_status := l_return_status;
548:
549: EXCEPTION
550: WHEN OTHERS THEN
551: x_return_status := fnd_api.g_ret_sts_unexp_error ;
552:
553: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
554: THEN
555: fnd_msg_pub.add_exc_msg

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

656: (
657: x_return_status OUT NOCOPY VARCHAR2
658: , p_wip_entity_id IN NUMBER
659: ) IS
660: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
661: l_msg_count NUMBER;
662: l_msg_data VARCHAR2(1000);
663: l_wip_entity_type NUMBER;
664: l_wip_job_type VARCHAR2(15);

Line 671: , p_init_msg_lst => fnd_api.g_false

667: IF (NOT inv_reservation_global.g_wip_record_cache.EXISTS(p_wip_entity_id)) THEN
668: -- call get_wip_entity API
669: inv_reservation_pvt.get_wip_entity_type
670: ( p_api_version_number => 1.0
671: , p_init_msg_lst => fnd_api.g_false
672: , x_return_status => l_return_status
673: , x_msg_count => l_msg_count
674: , x_msg_data => l_msg_data
675: , p_organization_id => null

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

681: , x_wip_entity_type => l_wip_entity_type
682: , x_wip_job_type => l_wip_job_type
683: );
684:
685: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
686: RAISE fnd_api.g_exc_error;
687: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
688: RAISE fnd_api.g_exc_unexpected_error;
689: END IF;

Line 686: RAISE fnd_api.g_exc_error;

682: , x_wip_job_type => l_wip_job_type
683: );
684:
685: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
686: RAISE fnd_api.g_exc_error;
687: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
688: RAISE fnd_api.g_exc_unexpected_error;
689: END IF;
690:

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

683: );
684:
685: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
686: RAISE fnd_api.g_exc_error;
687: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
688: RAISE fnd_api.g_exc_unexpected_error;
689: END IF;
690:
691: inv_reservation_global.g_wip_record_cache(p_wip_entity_id).wip_entity_id

Line 688: RAISE fnd_api.g_exc_unexpected_error;

684:
685: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
686: RAISE fnd_api.g_exc_error;
687: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
688: RAISE fnd_api.g_exc_unexpected_error;
689: END IF;
690:
691: inv_reservation_global.g_wip_record_cache(p_wip_entity_id).wip_entity_id
692: := p_wip_entity_id;

Line 703: WHEN fnd_api.g_exc_error THEN

699: END IF;
700:
701: x_return_status := l_return_status;
702: EXCEPTION
703: WHEN fnd_api.g_exc_error THEN
704: x_return_status := fnd_api.g_ret_sts_error;
705: --
706: WHEN fnd_api.g_exc_unexpected_error THEN
707: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 704: x_return_status := fnd_api.g_ret_sts_error;

700:
701: x_return_status := l_return_status;
702: EXCEPTION
703: WHEN fnd_api.g_exc_error THEN
704: x_return_status := fnd_api.g_ret_sts_error;
705: --
706: WHEN fnd_api.g_exc_unexpected_error THEN
707: x_return_status := fnd_api.g_ret_sts_unexp_error ;
708: WHEN OTHERS THEN

Line 706: WHEN fnd_api.g_exc_unexpected_error THEN

702: EXCEPTION
703: WHEN fnd_api.g_exc_error THEN
704: x_return_status := fnd_api.g_ret_sts_error;
705: --
706: WHEN fnd_api.g_exc_unexpected_error THEN
707: x_return_status := fnd_api.g_ret_sts_unexp_error ;
708: WHEN OTHERS THEN
709: x_return_status := fnd_api.g_ret_sts_unexp_error ;
710:

Line 707: x_return_status := fnd_api.g_ret_sts_unexp_error ;

703: WHEN fnd_api.g_exc_error THEN
704: x_return_status := fnd_api.g_ret_sts_error;
705: --
706: WHEN fnd_api.g_exc_unexpected_error THEN
707: x_return_status := fnd_api.g_ret_sts_unexp_error ;
708: WHEN OTHERS THEN
709: x_return_status := fnd_api.g_ret_sts_unexp_error ;
710:
711: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 709: x_return_status := fnd_api.g_ret_sts_unexp_error ;

705: --
706: WHEN fnd_api.g_exc_unexpected_error THEN
707: x_return_status := fnd_api.g_ret_sts_unexp_error ;
708: WHEN OTHERS THEN
709: x_return_status := fnd_api.g_ret_sts_unexp_error ;
710:
711: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
712: fnd_msg_pub.add_exc_msg
713: ( g_pkg_name