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

Line 49: x_return_status := FND_API.G_RET_STS_SUCCESS;

45: x_rsrv_cursor OUT NOCOPY t_genref)
46: IS
47: l_date_format VARCHAR2(100);
48: BEGIN
49: x_return_status := FND_API.G_RET_STS_SUCCESS;
50: x_error_msg := ' ';
51:
52: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);
53:

Line 89: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

85: IF g_debug <= gme_debug.g_log_unexpected THEN
86: gme_debug.put_line('When others exception in Fetch Lot Reservation');
87: END IF;
88: fnd_msg_pub.add_exc_msg('GME_MOBILE_RSRV','fetch_lot_reservations');
89: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
90: x_error_msg := fnd_message.get;
91:
92: END Fetch_Lot_Reservations;
93:

Line 120: x_return_status := FND_API.G_RET_STS_SUCCESS;

116: x_error_msg OUT NOCOPY VARCHAR2,
117: x_rsrv_cursor OUT NOCOPY t_genref)
118: IS
119: BEGIN
120: x_return_status := FND_API.G_RET_STS_SUCCESS;
121: x_error_msg := ' ';
122:
123:
124: OPEN x_rsrv_cursor FOR

Line 151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

147: IF g_debug <= gme_debug.g_log_unexpected THEN
148: gme_debug.put_line('When others exception in Check Rsrv Exist');
149: END IF;
150: fnd_msg_pub.add_exc_msg('GME_MOBILE_RSRV','Check_Rsrv_Exist');
151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
152: x_error_msg := fnd_message.get;
153:
154: END Check_Rsrv_Exist;
155:

Line 182: x_return_status := FND_API.G_RET_STS_SUCCESS;

178: x_rsrv_cursor OUT NOCOPY t_genref)
179: IS
180: l_date_format VARCHAR2(100);
181: BEGIN
182: x_return_status := FND_API.G_RET_STS_SUCCESS;
183: x_error_msg := ' ';
184:
185: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);
186:

Line 235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

231: IF g_debug <= gme_debug.g_log_unexpected THEN
232: gme_debug.put_line('When others exception in get Mtl Reservation');
233: END IF;
234: fnd_msg_pub.add_exc_msg('GME_MOBILE_RSRV','get_material_reservations');
235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
236: x_error_msg := fnd_message.get;
237:
238: END get_material_reservations;
239:

Line 258: x_return_status := FND_API.G_RET_STS_SUCCESS;

254: x_rsrv_cursor OUT NOCOPY t_genref)
255: IS
256: l_date_format VARCHAR2(100);
257: BEGIN
258: x_return_status := FND_API.G_RET_STS_SUCCESS;
259: x_error_msg := ' ';
260:
261: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);
262:

Line 312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

308: IF g_debug <= gme_debug.g_log_unexpected THEN
309: gme_debug.put_line('When others exception in get Mtl detail Reservation');
310: END IF;
311: fnd_msg_pub.add_exc_msg('GME_MOBILE_RSRV','Get_Material_Detail_Reservations');
312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
313: x_error_msg := fnd_message.get;
314:
315: END Get_Material_Dtl_Reservations;
316:

Line 390: p_init_msg_lst => fnd_api.g_false,

386: end if;
387:
388: Inv_Quantity_Tree_Pub.Query_Quantities (
389: p_api_version_number => 1.0,
390: p_init_msg_lst => fnd_api.g_false,
391: x_return_status => l_return_status,
392: x_msg_count => l_msg_count,
393: x_msg_data => l_msg_data,
394: p_organization_id => p_organization_id,

Line 487: x_return_status := FND_API.G_RET_STS_SUCCESS;

483: IF (g_debug IS NOT NULL) THEN
484: gme_debug.log_initialize ('MobileCreQtyTree');
485: END IF;
486:
487: x_return_status := FND_API.G_RET_STS_SUCCESS;
488: x_error_msg := ' ';
489:
490: IF upper(p_revision_control) = 'TRUE' THEN
491: l_is_revision_control := TRUE;

Line 534: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

530: , x_tree_id => x_tree_id
531: );
532:
533:
534: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
535: RAISE CREATE_TREE_ERROR;
536: END IF;
537:
538: IF (l_primary_qty <> 0) THEN

Line 599: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

595: );
596:
597: END IF;
598:
599: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
600: RAISE CREATE_TREE_ERROR;
601: END IF;
602:
603: INV_Quantity_Tree_Pvt.Prepare_Reservation_Quantities(

Line 607: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

603: INV_Quantity_Tree_Pvt.Prepare_Reservation_Quantities(
604: x_return_status => x_return_status
605: , p_tree_id => x_tree_id);
606:
607: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
608: fnd_message.set_name('INV', 'ERR_PREPARE_RSV_QTY');
609: x_error_msg := fnd_message.get;
610: END IF;
611:

Line 624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

620: IF g_debug <= gme_debug.g_log_unexpected THEN
621: gme_debug.put_line('When others exception in Update Qty Tree');
622: END IF;
623: fnd_msg_pub.add_exc_msg('GME_MOBILE_RSRV','Update_Qty_Tree_For_Rsrv');
624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
625: x_error_msg := fnd_message.get;
626:
627: END Update_Qty_Tree_For_Rsrv;
628:

Line 674: x_return_status := FND_API.G_RET_STS_SUCCESS;

670: IF (g_debug IS NOT NULL) THEN
671: gme_debug.log_initialize ('MobileFetchAtrQty');
672: END IF;
673:
674: x_return_status := FND_API.G_RET_STS_SUCCESS;
675: x_error_msg := ' ';
676:
677: INV_Quantity_Tree_Grp.Query_Tree(
678: p_api_version_number => 1

Line 703: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

699: , x_satt => l_satt
700: , x_satr => x_satr
701: );
702:
703: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
704: RAISE QUERY_TREE_ERROR;
705: END IF;
706:
707: EXCEPTION

Line 718: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

714: IF g_debug <= gme_debug.g_log_unexpected THEN
715: gme_debug.put_line('When others exception in Fetch_Atr_Qty');
716: END IF;
717: fnd_msg_pub.add_exc_msg('GME_MOBILE_RSRV','fetch_Atr_Qty');
718: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
719: x_error_msg := fnd_message.get;
720:
721: END Fetch_Atr_Qty;
722:

Line 754: x_return_status := FND_API.G_RET_STS_SUCCESS;

750: l_msg_index_out NUMBER;
751:
752: BEGIN
753:
754: x_return_status := FND_API.G_RET_STS_SUCCESS;
755: x_error_msg := '';
756:
757: -- Validate the quantities within deviation
758: l_is_valid := INV_CONVERT.within_deviation(

Line 770: x_return_status := FND_API.G_RET_STS_ERROR;

766: , p_uom_code2 => p_secondary_uom_code);
767: IF (l_is_valid = 0)
768: THEN
769:
770: x_return_status := FND_API.G_RET_STS_ERROR;
771:
772: FND_MSG_PUB.Get(
773: p_msg_index => 1,
774: p_data => x_error_msg,

Line 775: p_encoded => FND_API.G_FALSE,

771:
772: FND_MSG_PUB.Get(
773: p_msg_index => 1,
774: p_data => x_error_msg,
775: p_encoded => FND_API.G_FALSE,
776: p_msg_index_out => l_msg_index_out);
777: END IF;
778:
779: END Check_UoM_Conv_Deviation;

Line 802: (p_encoded => FND_API.g_false,

798: l_msg_count NUMBER;
799: BEGIN
800:
801: fnd_msg_pub.Count_And_Get
802: (p_encoded => FND_API.g_false,
803: p_count => l_msg_count,
804: p_data => l_message
805: );
806:

Line 853: x_return_status := FND_API.G_RET_STS_SUCCESS;

849: l_matl_dtl_rec gme_material_details%ROWTYPE;
850: l_msg_count NUMBER;
851: BEGIN
852:
853: x_return_status := FND_API.G_RET_STS_SUCCESS;
854: x_error_msg := ' ';
855:
856: IF (g_debug IS NOT NULL) THEN
857: gme_debug.log_initialize ('MobileCreRsrv');

Line 863: RAISE fnd_api.g_exc_error;

859:
860: l_matl_dtl_rec.material_detail_id := p_material_detail_id;
861: IF NOT gme_material_details_dbl.fetch_row (l_matl_dtl_rec
862: ,l_matl_dtl_rec) THEN
863: RAISE fnd_api.g_exc_error;
864: END IF;
865:
866: l_matl_dtl_rec.material_requirement_date := p_requirement_date;
867: l_matl_dtl_rec.organization_id := p_organization_id;

Line 882: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

878: p_locator_id => p_locator_id,
879: p_lot_number => p_lot_number,
880: x_return_status => x_return_status);
881:
882: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
883: Get_Stacked_Messages(x_message => x_error_msg);
884: /* Bug 5438355: Added success message. */
885: ELSE
886: gme_common_pvt.log_message('GME_RESERVATION_CREATED');

Line 888: ,p_encoded => fnd_api.g_false

884: /* Bug 5438355: Added success message. */
885: ELSE
886: gme_common_pvt.log_message('GME_RESERVATION_CREATED');
887: gme_common_pvt.count_and_get (x_count => l_msg_count
888: ,p_encoded => fnd_api.g_false
889: ,x_data => x_error_msg);
890: COMMIT;
891: END IF;
892:

Line 894: WHEN FND_API.G_EXC_ERROR THEN

890: COMMIT;
891: END IF;
892:
893: EXCEPTION
894: WHEN FND_API.G_EXC_ERROR THEN
895: x_return_status := fnd_api.g_ret_sts_error;
896: gme_common_pvt.count_and_get (x_count => l_msg_count
897: ,p_encoded => fnd_api.g_false
898: ,x_data => x_error_msg);

Line 895: x_return_status := fnd_api.g_ret_sts_error;

891: END IF;
892:
893: EXCEPTION
894: WHEN FND_API.G_EXC_ERROR THEN
895: x_return_status := fnd_api.g_ret_sts_error;
896: gme_common_pvt.count_and_get (x_count => l_msg_count
897: ,p_encoded => fnd_api.g_false
898: ,x_data => x_error_msg);
899: WHEN OTHERS THEN

Line 897: ,p_encoded => fnd_api.g_false

893: EXCEPTION
894: WHEN FND_API.G_EXC_ERROR THEN
895: x_return_status := fnd_api.g_ret_sts_error;
896: gme_common_pvt.count_and_get (x_count => l_msg_count
897: ,p_encoded => fnd_api.g_false
898: ,x_data => x_error_msg);
899: WHEN OTHERS THEN
900: IF g_debug <= gme_debug.g_log_unexpected THEN
901: gme_debug.put_line('When others exception in Create Reservation');

Line 904: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

900: IF g_debug <= gme_debug.g_log_unexpected THEN
901: gme_debug.put_line('When others exception in Create Reservation');
902: END IF;
903: fnd_msg_pub.add_exc_msg('GME_MOBILE_RSRV','create_reservation');
904: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
905: x_error_msg := fnd_message.get;
906:
907: END Create_Reservation;
908:

Line 938: x_return_status := FND_API.G_RET_STS_SUCCESS;

934:
935: IS
936: BEGIN
937:
938: x_return_status := FND_API.G_RET_STS_SUCCESS;
939: x_error_msg := ' ';
940:
941: IF (g_debug IS NOT NULL) THEN
942: gme_debug.log_initialize ('MobileUpdRsrv');

Line 969: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

965: p_new_uom => p_reserved_uom_code,
966: p_new_date => p_requirement_date,
967: x_return_status => x_return_status);
968:
969: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
970: Get_Stacked_Messages(x_message => x_error_msg);
971: /* Bug 5438355: Added success message. */
972: ELSE
973: gme_common_pvt.log_message('GME_RESERVATION_UPDATED');

Line 984: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

980: IF g_debug <= gme_debug.g_log_unexpected THEN
981: gme_debug.put_line('When others exception in Update Reservation');
982: END IF;
983: fnd_msg_pub.add_exc_msg('GME_MOBILE_RSRV','update_reservation');
984: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
985: x_error_msg := fnd_message.get;
986:
987: END Update_Reservation;
988: