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

Line 107: x_return_status := fnd_api.g_ret_sts_success;

103: l_lpn_contents_exist VARCHAR2(1) := 'N';
104: l_mmtt_lpn_receipts_exist VARCHAR2(1) := 'N';
105: l_serial_item VARCHAR2(1) := 'N';
106: begin
107: x_return_status := fnd_api.g_ret_sts_success;
108:
109: if p_cost_group_id is null then
110: fnd_message.set_name('INV', 'INV_MISSING_REQUIRED_PARAMETER');
111: fnd_msg_pub.add;

Line 112: RAISE fnd_api.g_exc_error;

108:
109: if p_cost_group_id is null then
110: fnd_message.set_name('INV', 'INV_MISSING_REQUIRED_PARAMETER');
111: fnd_msg_pub.add;
112: RAISE fnd_api.g_exc_error;
113: end if;
114:
115: BEGIN
116: SELECT 'Y' INTO l_serial_item

Line 555: WHEN fnd_api.g_exc_error THEN

551: x_comingling_occurs := 'N';
552:
553: EXCEPTION
554:
555: WHEN fnd_api.g_exc_error THEN
556: x_return_status := fnd_api.g_ret_sts_error;
557: fnd_msg_pub.count_and_get
558: ( p_count => x_msg_count,
559: p_data => x_msg_data

Line 556: x_return_status := fnd_api.g_ret_sts_error;

552:
553: EXCEPTION
554:
555: WHEN fnd_api.g_exc_error THEN
556: x_return_status := fnd_api.g_ret_sts_error;
557: fnd_msg_pub.count_and_get
558: ( p_count => x_msg_count,
559: p_data => x_msg_data
560: );

Line 562: WHEN fnd_api.g_exc_unexpected_error THEN

558: ( p_count => x_msg_count,
559: p_data => x_msg_data
560: );
561: --dbms_output.put_line(replace(x_msg_data,chr(0),' '));
562: WHEN fnd_api.g_exc_unexpected_error THEN
563: x_return_status := fnd_api.g_ret_sts_unexp_error ;
564: fnd_msg_pub.count_and_get
565: ( p_count => x_msg_count,
566: p_data => x_msg_data

Line 563: x_return_status := fnd_api.g_ret_sts_unexp_error ;

559: p_data => x_msg_data
560: );
561: --dbms_output.put_line(replace(x_msg_data,chr(0),' '));
562: WHEN fnd_api.g_exc_unexpected_error THEN
563: x_return_status := fnd_api.g_ret_sts_unexp_error ;
564: fnd_msg_pub.count_and_get
565: ( p_count => x_msg_count,
566: p_data => x_msg_data
567: );

Line 571: x_return_status := fnd_api.g_ret_sts_unexp_error;

567: );
568: --dbms_output.put_line(replace(x_msg_data,chr(0),' '));
569:
570: WHEN OTHERS THEN
571: x_return_status := fnd_api.g_ret_sts_unexp_error;
572: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
573: fnd_msg_pub.add_exc_msg ('inv_comingling_utils'
574: , 'comingle_check'
575: );

Line 616: x_return_status := fnd_api.g_ret_sts_unexp_error;

612:
613: EXCEPTION
614:
615: WHEN OTHERS THEN
616: x_return_status := fnd_api.g_ret_sts_unexp_error;
617: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
618: fnd_msg_pub.add_exc_msg ('inv_comingling_utils'
619: , 'comingle_check'
620: );

Line 670: x_return_status := fnd_api.g_ret_sts_success;

666: l_check_done BOOLEAN := FALSE; --4576727
667:
668: BEGIN
669:
670: x_return_status := fnd_api.g_ret_sts_success;
671: x_comingling_occurs := 'N';
672:
673:
674: IF p_mmtt_rec.transaction_temp_id IS NULL THEN

Line 675: RAISE fnd_api.g_exc_unexpected_error;

671: x_comingling_occurs := 'N';
672:
673:
674: IF p_mmtt_rec.transaction_temp_id IS NULL THEN
675: RAISE fnd_api.g_exc_unexpected_error;
676: END IF;
677:
678: /***
679: --If serials are involved, comingling cannot occur

Line 742: if (l_return_status = FND_API.G_RET_STS_ERROR) then

738: ( x_return_status =>l_return_status,
739: x_msg_count =>l_msg_count,
740: x_msg_data =>l_msg_data,
741: p_organization_id => l_comingle_org);
742: if (l_return_status = FND_API.G_RET_STS_ERROR) then
743: RAISE FND_API.G_EXC_ERROR;
744: elsif (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
746: end if;

Line 743: RAISE FND_API.G_EXC_ERROR;

739: x_msg_count =>l_msg_count,
740: x_msg_data =>l_msg_data,
741: p_organization_id => l_comingle_org);
742: if (l_return_status = FND_API.G_RET_STS_ERROR) then
743: RAISE FND_API.G_EXC_ERROR;
744: elsif (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
746: end if;
747:

Line 744: elsif (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then

740: x_msg_data =>l_msg_data,
741: p_organization_id => l_comingle_org);
742: if (l_return_status = FND_API.G_RET_STS_ERROR) then
743: RAISE FND_API.G_EXC_ERROR;
744: elsif (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
746: end if;
747:
748:

Line 745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

741: p_organization_id => l_comingle_org);
742: if (l_return_status = FND_API.G_RET_STS_ERROR) then
743: RAISE FND_API.G_EXC_ERROR;
744: elsif (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
746: end if;
747:
748:
749: l_lpn_id := p_mmtt_rec.lpn_id;

Line 828: l_return_status := fnd_api.g_ret_sts_success;

824: OPEN mtlt_cur;
825: LOOP
826:
827: l_lot_number := NULL;
828: l_return_status := fnd_api.g_ret_sts_success;
829: l_msg_data := NULL;
830: l_msg_count := NULL;
831: l_comingling_occurs := 'N';
832:

Line 870: IF l_return_status <> fnd_api.g_ret_sts_success THEN

866: , p_lpn_id => l_transfer_lpn_id
867: , p_cost_group_id => l_comingle_cg);
868:
869:
870: IF l_return_status <> fnd_api.g_ret_sts_success THEN
871:
872: x_return_status := l_return_status;
873: x_msg_count := l_msg_count;
874: x_msg_data := l_msg_data;

Line 912: WHEN fnd_api.g_exc_error THEN

908: x_comingling_occurs := 'N';
909:
910: EXCEPTION
911:
912: WHEN fnd_api.g_exc_error THEN
913: x_return_status := fnd_api.g_ret_sts_error;
914: fnd_msg_pub.count_and_get
915: ( p_count => x_msg_count,
916: p_data => x_msg_data

Line 913: x_return_status := fnd_api.g_ret_sts_error;

909:
910: EXCEPTION
911:
912: WHEN fnd_api.g_exc_error THEN
913: x_return_status := fnd_api.g_ret_sts_error;
914: fnd_msg_pub.count_and_get
915: ( p_count => x_msg_count,
916: p_data => x_msg_data
917: );

Line 922: WHEN fnd_api.g_exc_unexpected_error THEN

918: IF mtlt_cur%isopen THEN
919: CLOSE mtlt_cur;
920: END IF;
921: --dbms_output.put_line(replace(x_msg_data,chr(0),' '));
922: WHEN fnd_api.g_exc_unexpected_error THEN
923: x_return_status := fnd_api.g_ret_sts_unexp_error ;
924: fnd_msg_pub.count_and_get
925: ( p_count => x_msg_count,
926: p_data => x_msg_data

Line 923: x_return_status := fnd_api.g_ret_sts_unexp_error ;

919: CLOSE mtlt_cur;
920: END IF;
921: --dbms_output.put_line(replace(x_msg_data,chr(0),' '));
922: WHEN fnd_api.g_exc_unexpected_error THEN
923: x_return_status := fnd_api.g_ret_sts_unexp_error ;
924: fnd_msg_pub.count_and_get
925: ( p_count => x_msg_count,
926: p_data => x_msg_data
927: );

Line 933: x_return_status := fnd_api.g_ret_sts_unexp_error;

929: CLOSE mtlt_cur;
930: END IF;
931: --dbms_output.put_line(replace(x_msg_data,chr(0),' '));
932: WHEN OTHERS THEN
933: x_return_status := fnd_api.g_ret_sts_unexp_error;
934: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
935: fnd_msg_pub.add_exc_msg ('inv_comingling_utils'
936: , 'comingle_check'
937: );