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

Line 42: x_return_status := FND_API.G_RET_STS_SUCCESS;

38: , X_msg_data OUT NOCOPY VARCHAR2
39: ) IS
40: l_res_rec gml_batch_so_reservations%rowtype;
41: BEGIN
42: x_return_status := FND_API.G_RET_STS_SUCCESS;
43: GMI_RESERVATION_UTIL.Println(' In query reservation');
44: GMI_RESERVATION_UTIL.Println(' In query reservation, so_line_id '|| p_so_line_rec.so_line_id);
45: GMI_RESERVATION_UTIL.Println(' In query reservation, batch_line_id '|| p_batch_line_rec.batch_line_id);
46: GMI_RESERVATION_UTIL.Println(' In query reservation, batch_res '|| p_gme_om_reservation_rec.batch_res_id);

Line 97: x_return_status := FND_API.G_RET_STS_SUCCESS;

93: , X_msg_data OUT NOCOPY VARCHAR2
94: ) IS
95: l_batch_res_id NUMBER;
96: BEGIN
97: x_return_status := FND_API.G_RET_STS_SUCCESS;
98: GMI_RESERVATION_UTIL.Println(' In insert reservations');
99: /* insert gme_om_reservation_rec into gml_batch_so_reservations table */
100: select gml_so_reservation_s.nextval
101: into l_batch_res_id

Line 155: WHEN FND_API.G_EXC_ERROR THEN

151: , sysdate
152: );
153: GMI_RESERVATION_UTIL.Println(' In insert reservations, new batch_res_id '||l_batch_res_id);
154: EXCEPTION
155: WHEN FND_API.G_EXC_ERROR THEN
156: /* Get message count and data*/
157: FND_MSG_PUB.count_and_get
158: ( p_count => x_msg_cont
159: , p_data => x_msg_data

Line 183: x_return_status := FND_API.G_RET_STS_SUCCESS;

179: , X_msg_cont OUT NOCOPY NUMBER
180: , X_msg_data OUT NOCOPY VARCHAR2
181: ) IS
182: BEGIN
183: x_return_status := FND_API.G_RET_STS_SUCCESS;
184: update gml_batch_so_reservations
185: Set
186: batch_id = p_gme_om_reservation_rec.batch_id
187: , batch_line_id = p_gme_om_reservation_rec.batch_line_id

Line 215: x_return_status := FND_API.G_RET_STS_SUCCESS;

211: , X_msg_cont OUT NOCOPY NUMBER
212: , X_msg_data OUT NOCOPY VARCHAR2
213: ) IS
214: BEGIN
215: x_return_status := FND_API.G_RET_STS_SUCCESS;
216: IF p_batch_res_id is not null Then
217: update gml_batch_so_reservations
218: set delete_mark = 1
219: Where batch_res_id = p_batch_res_id;

Line 244: x_return_status := FND_API.G_RET_STS_SUCCESS;

240: l_alloc_rec_id NUMBER;
241: l_history_row gml_batch_so_alloc_history%rowtype;
242: l_history_rec GML_BATCH_OM_UTIL.alloc_history_rec;
243: BEGIN
244: x_return_status := FND_API.G_RET_STS_SUCCESS;
245: IF p_alloc_history_rec.alloc_rec_id is not null THEN
246: Select *
247: Into l_history_row
248: from gml_batch_so_alloc_history

Line 280: x_return_status := FND_API.G_RET_STS_SUCCESS;

276: , X_msg_data OUT NOCOPY VARCHAR2
277: ) IS
278: l_alloc_rec_id NUMBER;
279: BEGIN
280: x_return_status := FND_API.G_RET_STS_SUCCESS;
281: /* insert gme_om_reservation_rec into gml_batch_so_reservations table */
282: GMI_RESERVATION_UTIL.println('inserting alloc history');
283: select gml_so_alloc_history_s.nextval
284: into l_alloc_rec_id

Line 348: x_return_status := FND_API.G_RET_STS_SUCCESS;

344:
345: l_exist Number; -- default := 0;
346:
347: BEGIN
348: x_return_status := FND_API.G_RET_STS_SUCCESS;
349: GMI_reservation_Util.PrintLn('Check reservation ');
350: GMI_reservation_Util.PrintLn(' p_batch_res_id '||p_batch_res_id);
351: GMI_reservation_Util.PrintLn(' p_batch_line_id '||p_batch_line_id);
352: GMI_reservation_Util.PrintLn(' p_batch_id '||p_batch_id);

Line 410: WHEN FND_API.G_EXC_ERROR THEN

406:
407: return true;
408:
409: EXCEPTION
410: WHEN FND_API.G_EXC_ERROR THEN
411: /* Get message count and data*/
412: FND_MSG_PUB.count_and_get
413: ( p_count => x_msg_cont
414: , p_data => x_msg_data

Line 476: x_return_status := FND_API.G_RET_STS_SUCCESS;

472: TYPE rc IS REF CURSOR;
473: check_rule_assign rc;
474:
475: BEGIN
476: x_return_status := FND_API.G_RET_STS_SUCCESS;
477: /* get the most suitable rule first */
478: GMI_reservation_Util.PrintLn('IN check Rule');
479: Open get_the_rule;
480: Fetch get_the_rule

Line 638: x_return_status := FND_API.G_RET_STS_SUCCESS;

634: From ic_whse_mst
635: Where mtl_organization_id = p_org_id;
636:
637: BEGIN
638: x_return_status := FND_API.G_RET_STS_SUCCESS;
639: l_so_line_rec := p_so_line_rec;
640:
641: /* assign the gme_om_config_assign record */
642: /* if batch line is passed

Line 762: IF x_return_status <> fnd_api.g_ret_sts_success Then

758: , X_msg_cont => x_msg_cont
759: , X_msg_data => x_msg_data
760: );
761:
762: IF x_return_status <> fnd_api.g_ret_sts_success Then
763: GMI_reservation_Util.PrintLn('OM_UTIL, checking rule failure');
764: --FND_MESSAGE.SET_NAME('GMI','GMI_QTY_RSV_NOT_FOUND');
765: --FND_MESSAGE.Set_Token('WHERE', 'Check rules');
766: --FND_MSG_PUB.ADD;

Line 767: RAISE FND_API.G_EXC_ERROR;

763: GMI_reservation_Util.PrintLn('OM_UTIL, checking rule failure');
764: --FND_MESSAGE.SET_NAME('GMI','GMI_QTY_RSV_NOT_FOUND');
765: --FND_MESSAGE.Set_Token('WHERE', 'Check rules');
766: --FND_MSG_PUB.ADD;
767: RAISE FND_API.G_EXC_ERROR;
768: END IF;
769: IF l_rule_count = 0 Then
770: GMI_reservation_Util.PrintLn('OM_UTIL, No rule found');
771: --FND_MESSAGE.SET_NAME('GMI','GMI_QTY_RSV_NOT_FOUND');

Line 774: RAISE FND_API.G_EXC_ERROR;

770: GMI_reservation_Util.PrintLn('OM_UTIL, No rule found');
771: --FND_MESSAGE.SET_NAME('GMI','GMI_QTY_RSV_NOT_FOUND');
772: --FND_MESSAGE.Set_Token('WHERE', 'Check rules');
773: --FND_MSG_PUB.ADD;
774: RAISE FND_API.G_EXC_ERROR;
775: END IF;
776: IF l_rule_count > 1 Then
777: GMI_reservation_Util.PrintLn('OM_UTIL, Multiple rules found');
778: --FND_MESSAGE.SET_NAME('GMI','GMI_QTY_RSV_NOT_FOUND');

Line 781: RAISE FND_API.G_EXC_ERROR;

777: GMI_reservation_Util.PrintLn('OM_UTIL, Multiple rules found');
778: --FND_MESSAGE.SET_NAME('GMI','GMI_QTY_RSV_NOT_FOUND');
779: --FND_MESSAGE.Set_Token('WHERE', 'Check rules');
780: --FND_MSG_PUB.ADD;
781: RAISE FND_API.G_EXC_ERROR;
782: END IF;
783: /* get the rule rec if it is unique */
784: Select *
785: Into l_rule_rec

Line 813: x_return_status := FND_API.G_RET_STS_SUCCESS;

809: x_gme_om_rule_rec.batch_attachment := l_rule_rec.batch_attachment;
810: x_gme_om_rule_rec.batch_creation_notification := l_rule_rec.batch_creation_notification;
811: GMI_reservation_Util.PrintLn('get_rule: rule name '|| x_gme_om_rule_rec.rule_name);
812:
813: x_return_status := FND_API.G_RET_STS_SUCCESS;
814:
815: EXCEPTION
816: WHEN FND_API.G_EXC_ERROR THEN
817: x_return_status := FND_API.G_RET_STS_ERROR;

Line 816: WHEN FND_API.G_EXC_ERROR THEN

812:
813: x_return_status := FND_API.G_RET_STS_SUCCESS;
814:
815: EXCEPTION
816: WHEN FND_API.G_EXC_ERROR THEN
817: x_return_status := FND_API.G_RET_STS_ERROR;
818: /* Get message count and data*/
819: FND_MSG_PUB.count_and_get
820: ( p_count => x_msg_cont

Line 817: x_return_status := FND_API.G_RET_STS_ERROR;

813: x_return_status := FND_API.G_RET_STS_SUCCESS;
814:
815: EXCEPTION
816: WHEN FND_API.G_EXC_ERROR THEN
817: x_return_status := FND_API.G_RET_STS_ERROR;
818: /* Get message count and data*/
819: FND_MSG_PUB.count_and_get
820: ( p_count => x_msg_cont
821: , p_data => x_msg_data

Line 825: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

821: , p_data => x_msg_data
822: );
823: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT u EXCEPTION: Expected');
824: WHEN OTHERS THEN
825: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
826:
827: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
828: , 'get_rule'
829: );