DBA Data[Home] [Help]

APPS.GML_BATCH_OM_UTIL dependencies on FND_MSG_PUB

Line 157: FND_MSG_PUB.count_and_get

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
160: );
161: GMI_RESERVATION_UTIL.println('sqlerror'|| SUBSTRB(SQLERRM, 1, 100));

Line 163: --FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

159: , p_data => x_msg_data
160: );
161: GMI_RESERVATION_UTIL.println('sqlerror'|| SUBSTRB(SQLERRM, 1, 100));
162: WHEN OTHERS THEN
163: --FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
164: -- , 'check_reservations'
165: -- );
166: --/* Get message count and data*/
167: --FND_MSG_PUB.count_and_get

Line 167: --FND_MSG_PUB.count_and_get

163: --FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
164: -- , 'check_reservations'
165: -- );
166: --/* Get message count and data*/
167: --FND_MSG_PUB.count_and_get
168: -- ( p_count => x_msg_cont
169: -- , p_data => x_msg_data
170: -- );
171: GMI_RESERVATION_UTIL.println('sqlerror'|| SUBSTRB(SQLERRM, 1, 100));

Line 412: FND_MSG_PUB.count_and_get

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
415: );
416: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT u EXCEPTION: Expected');

Line 418: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

414: , p_data => x_msg_data
415: );
416: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT u EXCEPTION: Expected');
417: WHEN OTHERS THEN
418: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
419: , 'check_reservations'
420: );
421: /* Get message count and data*/
422: --FND_MSG_PUB.count_and_get

Line 422: --FND_MSG_PUB.count_and_get

418: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
419: , 'check_reservations'
420: );
421: /* Get message count and data*/
422: --FND_MSG_PUB.count_and_get
423: -- ( p_count => x_msg_cont
424: -- , p_data => x_msg_data
425: -- );
426: GMI_RESERVATION_UTIL.println('sqlerror'|| SUBSTRB(SQLERRM, 1, 100));

Line 766: --FND_MSG_PUB.ADD;

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;
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');

Line 773: --FND_MSG_PUB.ADD;

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');
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');

Line 780: --FND_MSG_PUB.ADD;

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');
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 *

Line 819: FND_MSG_PUB.count_and_get

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
822: );
823: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT u EXCEPTION: Expected');

Line 827: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

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: );
830: /* Get message count and data*/
831: FND_MSG_PUB.count_and_get

Line 831: FND_MSG_PUB.count_and_get

827: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
828: , 'get_rule'
829: );
830: /* Get message count and data*/
831: FND_MSG_PUB.count_and_get
832: ( p_count => x_msg_cont
833: , p_data => x_msg_data
834: );
835: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT u EXCEPTION: Others');