DBA Data[Home] [Help]

APPS.OE_ORDER_PRICE_PVT dependencies on OE_MSG_REQUEST_ID_S

Line 7646: -- select oe_msg_request_id_s.nextval into l_request_id from dual;

7642: IF l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM THEN
7643: vmsg := FND_MESSAGE.GET;
7644: oe_debug_pub.add('vmsg = '||vmsg,1);
7645: pricing_errors_hold(l_line_rec.header_id,l_line_rec.line_id,vmsg);
7646: -- select oe_msg_request_id_s.nextval into l_request_id from dual;
7647: -- OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, l_request_id,'U');
7648: -- 4919922
7649: IF (OE_GLOBALS.G_UI_FLAG ) THEN
7650: IF (G_REQUEST_ID IS NULL) THEN

Line 7651: select oe_msg_request_id_s.nextval into g_request_id from dual;

7647: -- OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, l_request_id,'U');
7648: -- 4919922
7649: IF (OE_GLOBALS.G_UI_FLAG ) THEN
7650: IF (G_REQUEST_ID IS NULL) THEN
7651: select oe_msg_request_id_s.nextval into g_request_id from dual;
7652: END IF;
7653: OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, G_REQUEST_ID,'U');
7654: END IF;
7655:

Line 7685: -- select oe_msg_request_id_s.nextval into l_request_id from dual;

7681: IF l_debug_level > 0 THEN
7682: oe_debug_pub.add('vmsg = '||vmsg,1);
7683: END IF;
7684: pricing_errors_hold(l_line_rec.header_id,l_line_rec.line_id,vmsg);
7685: -- select oe_msg_request_id_s.nextval into l_request_id from dual;
7686:
7687: -- OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, l_request_id,'U');
7688: -- 4919922
7689: IF (OE_GLOBALS.G_UI_FLAG ) THEN

Line 7691: select oe_msg_request_id_s.nextval into g_request_id from dual;

7687: -- OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, l_request_id,'U');
7688: -- 4919922
7689: IF (OE_GLOBALS.G_UI_FLAG ) THEN
7690: IF (G_REQUEST_ID IS NULL) THEN
7691: select oe_msg_request_id_s.nextval into g_request_id from dual;
7692: END IF;
7693: OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, G_REQUEST_ID,'U');
7694: END IF;
7695:

Line 7704: -- select oe_msg_request_id_s.nextval into l_request_id from dual;

7700: l_temp_line_rec.ordered_quantity := Wrong_line.line_quantity;
7701: oe_debug_pub.add('has invalid line3');
7702: l_temp_line_rec.pricing_quantity := Wrong_line.priced_quantity;
7703: oe_debug_pub.add('has invalid line4');
7704: -- select oe_msg_request_id_s.nextval into l_request_id from dual;
7705:
7706: -- OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, l_request_id,'U');
7707: -- 4919922
7708: IF (OE_GLOBALS.G_UI_FLAG ) THEN

Line 7710: select oe_msg_request_id_s.nextval into g_request_id from dual;

7706: -- OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, l_request_id,'U');
7707: -- 4919922
7708: IF (OE_GLOBALS.G_UI_FLAG ) THEN
7709: IF (G_REQUEST_ID IS NULL) THEN
7710: select oe_msg_request_id_s.nextval into g_request_id from dual;
7711: END IF;
7712: OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, G_REQUEST_ID,'U');
7713: END IF;
7714:

Line 7722: -- select oe_msg_request_id_s.nextval into l_request_id from dual;

7718: else
7719: l_temp_line_rec.line_id := Wrong_line.line_id;
7720: l_temp_line_rec.ordered_quantity := Wrong_line.line_quantity;
7721: l_temp_line_rec.pricing_quantity := Wrong_line.priced_quantity;
7722: -- select oe_msg_request_id_s.nextval into l_request_id from dual;
7723:
7724: -- OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, l_request_id,'U');
7725: -- 4919922
7726: IF (OE_GLOBALS.G_UI_FLAG ) THEN

Line 7728: select oe_msg_request_id_s.nextval into g_request_id from dual;

7724: -- OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, l_request_id,'U');
7725: -- 4919922
7726: IF (OE_GLOBALS.G_UI_FLAG ) THEN
7727: IF (G_REQUEST_ID IS NULL) THEN
7728: select oe_msg_request_id_s.nextval into g_request_id from dual;
7729: END IF;
7730: OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, G_REQUEST_ID,'U');
7731: END IF;
7732: