DBA Data[Home] [Help]

APPS.OE_ORDER_PRICE_PVT dependencies on OE_MSG_REQUEST_ID_S

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

7355: IF l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM THEN
7356: vmsg := FND_MESSAGE.GET;
7357: oe_debug_pub.add('vmsg = '||vmsg,1);
7358: pricing_errors_hold(l_line_rec.header_id,l_line_rec.line_id,vmsg);
7359: -- select oe_msg_request_id_s.nextval into l_request_id from dual;
7360: -- OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, l_request_id,'U');
7361: -- 4919922
7362: IF (OE_GLOBALS.G_UI_FLAG ) THEN
7363: IF (G_REQUEST_ID IS NULL) THEN

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

7360: -- OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, l_request_id,'U');
7361: -- 4919922
7362: IF (OE_GLOBALS.G_UI_FLAG ) THEN
7363: IF (G_REQUEST_ID IS NULL) THEN
7364: select oe_msg_request_id_s.nextval into g_request_id from dual;
7365: END IF;
7366: OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, G_REQUEST_ID,'U');
7367: END IF;
7368:

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

7394: IF l_debug_level > 0 THEN
7395: oe_debug_pub.add('vmsg = '||vmsg,1);
7396: END IF;
7397: pricing_errors_hold(l_line_rec.header_id,l_line_rec.line_id,vmsg);
7398: -- select oe_msg_request_id_s.nextval into l_request_id from dual;
7399:
7400: -- OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, l_request_id,'U');
7401: -- 4919922
7402: IF (OE_GLOBALS.G_UI_FLAG ) THEN

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

7400: -- OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, l_request_id,'U');
7401: -- 4919922
7402: IF (OE_GLOBALS.G_UI_FLAG ) THEN
7403: IF (G_REQUEST_ID IS NULL) THEN
7404: select oe_msg_request_id_s.nextval into g_request_id from dual;
7405: END IF;
7406: OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, G_REQUEST_ID,'U');
7407: END IF;
7408:

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

7413: l_temp_line_rec.ordered_quantity := Wrong_line.line_quantity;
7414: oe_debug_pub.add('has invalid line3');
7415: l_temp_line_rec.pricing_quantity := Wrong_line.priced_quantity;
7416: oe_debug_pub.add('has invalid line4');
7417: -- select oe_msg_request_id_s.nextval into l_request_id from dual;
7418:
7419: -- OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, l_request_id,'U');
7420: -- 4919922
7421: IF (OE_GLOBALS.G_UI_FLAG ) THEN

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

7419: -- OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, l_request_id,'U');
7420: -- 4919922
7421: IF (OE_GLOBALS.G_UI_FLAG ) THEN
7422: IF (G_REQUEST_ID IS NULL) THEN
7423: select oe_msg_request_id_s.nextval into g_request_id from dual;
7424: END IF;
7425: OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, G_REQUEST_ID,'U');
7426: END IF;
7427:

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

7431: else
7432: l_temp_line_rec.line_id := Wrong_line.line_id;
7433: l_temp_line_rec.ordered_quantity := Wrong_line.line_quantity;
7434: l_temp_line_rec.pricing_quantity := Wrong_line.priced_quantity;
7435: -- select oe_msg_request_id_s.nextval into l_request_id from dual;
7436:
7437: -- OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, l_request_id,'U');
7438: -- 4919922
7439: IF (OE_GLOBALS.G_UI_FLAG ) THEN

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

7437: -- OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, l_request_id,'U');
7438: -- 4919922
7439: IF (OE_GLOBALS.G_UI_FLAG ) THEN
7440: IF (G_REQUEST_ID IS NULL) THEN
7441: select oe_msg_request_id_s.nextval into g_request_id from dual;
7442: END IF;
7443: OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, G_REQUEST_ID,'U');
7444: END IF;
7445: