DBA Data[Home] [Help]

APPS.OE_ADV_PRICE_PVT dependencies on FND_MESSAGE

Line 1426: FND_MESSAGE.SET_NAME('ONT', 'ONT_PRG_INVALID_MASTER_ORG');

1422: FROM mtl_system_items_kfv
1423: WHERE inventory_item_id = l_line_rec.inventory_item_id
1424: AND organization_id = l_org_id;
1425: Exception when no_data_found then
1426: FND_MESSAGE.SET_NAME('ONT', 'ONT_PRG_INVALID_MASTER_ORG');
1427: SELECT QH.NAME, LDET.LIST_LINE_NO
1428: INTO l_modifier
1429: , l_list_line_no
1430: FROM QP_PREQ_RLTD_LINES_TMP RLTD

Line 1439: FND_MESSAGE.SET_TOKEN('MODIFIER', l_modifier);

1435: AND RLTD.LINE_DETAIL_INDEX = LDET.LINE_DETAIL_INDEX
1436: AND LDET.LIST_HEADER_ID = QH.LIST_HEADER_ID AND ROWNUM=1;
1437:
1438:
1439: FND_MESSAGE.SET_TOKEN('MODIFIER', l_modifier);
1440: FND_MESSAGE.SET_TOKEN('LIST_LINE_NO', l_list_line_no);
1441: FND_MESSAGE.SET_TOKEN('ITEM', l_line_rec.inventory_item_id);
1442: BEGIN
1443: SELECT ORGANIZATION_NAME

Line 1440: FND_MESSAGE.SET_TOKEN('LIST_LINE_NO', l_list_line_no);

1436: AND LDET.LIST_HEADER_ID = QH.LIST_HEADER_ID AND ROWNUM=1;
1437:
1438:
1439: FND_MESSAGE.SET_TOKEN('MODIFIER', l_modifier);
1440: FND_MESSAGE.SET_TOKEN('LIST_LINE_NO', l_list_line_no);
1441: FND_MESSAGE.SET_TOKEN('ITEM', l_line_rec.inventory_item_id);
1442: BEGIN
1443: SELECT ORGANIZATION_NAME
1444: INTO l_org

Line 1441: FND_MESSAGE.SET_TOKEN('ITEM', l_line_rec.inventory_item_id);

1437:
1438:
1439: FND_MESSAGE.SET_TOKEN('MODIFIER', l_modifier);
1440: FND_MESSAGE.SET_TOKEN('LIST_LINE_NO', l_list_line_no);
1441: FND_MESSAGE.SET_TOKEN('ITEM', l_line_rec.inventory_item_id);
1442: BEGIN
1443: SELECT ORGANIZATION_NAME
1444: INTO l_org
1445: FROM ORG_ORGANIZATION_DEFINITIONS

Line 1450: FND_MESSAGE.SET_TOKEN('ORG', l_org);

1446: WHERE ORGANIZATION_ID = l_org_id;
1447: EXCEPTION WHEN OTHERS THEN
1448: l_org := l_org_id;
1449: END;
1450: FND_MESSAGE.SET_TOKEN('ORG', l_org);
1451: OE_MSG_PUB.ADD;
1452: l_line_rec.operation := OE_GLOBALS.G_OPR_NONE;
1453: QP_UTIL_PUB.Update_Lines('MAKE_STATUS_INVALID',l_line_rec.line_id,
1454: NULL,NULL);

Line 1915: FND_MESSAGE.SET_NAME('ONT','ONT_CREATED_NEW_LINE');

1911: , i.price_request_code
1912: );
1913: IF (l_line_rec.operation <> OE_GLOBALS.G_OPR_NONE) THEN
1914: -- Display the PRG Item
1915: FND_MESSAGE.SET_NAME('ONT','ONT_CREATED_NEW_LINE');
1916: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.ordered_item,l_line_rec.inventory_item_id));
1917: --bug 2412868 begin
1918: if l_line_rec.line_category_code = 'RETURN' then
1919: FND_MESSAGE.SET_TOKEN('QUANTITY',(-1) * l_line_rec.Ordered_quantity);

Line 1916: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.ordered_item,l_line_rec.inventory_item_id));

1912: );
1913: IF (l_line_rec.operation <> OE_GLOBALS.G_OPR_NONE) THEN
1914: -- Display the PRG Item
1915: FND_MESSAGE.SET_NAME('ONT','ONT_CREATED_NEW_LINE');
1916: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.ordered_item,l_line_rec.inventory_item_id));
1917: --bug 2412868 begin
1918: if l_line_rec.line_category_code = 'RETURN' then
1919: FND_MESSAGE.SET_TOKEN('QUANTITY',(-1) * l_line_rec.Ordered_quantity);
1920: else

Line 1919: FND_MESSAGE.SET_TOKEN('QUANTITY',(-1) * l_line_rec.Ordered_quantity);

1915: FND_MESSAGE.SET_NAME('ONT','ONT_CREATED_NEW_LINE');
1916: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.ordered_item,l_line_rec.inventory_item_id));
1917: --bug 2412868 begin
1918: if l_line_rec.line_category_code = 'RETURN' then
1919: FND_MESSAGE.SET_TOKEN('QUANTITY',(-1) * l_line_rec.Ordered_quantity);
1920: else
1921: --bug 2412868 end
1922: FND_MESSAGE.SET_TOKEN('QUANTITY',l_line_rec.Ordered_quantity);
1923: end if;

Line 1922: FND_MESSAGE.SET_TOKEN('QUANTITY',l_line_rec.Ordered_quantity);

1918: if l_line_rec.line_category_code = 'RETURN' then
1919: FND_MESSAGE.SET_TOKEN('QUANTITY',(-1) * l_line_rec.Ordered_quantity);
1920: else
1921: --bug 2412868 end
1922: FND_MESSAGE.SET_TOKEN('QUANTITY',l_line_rec.Ordered_quantity);
1923: end if;
1924: OE_MSG_PUB.Add('N');
1925: px_line_tbl(px_line_tbl.last+1) := l_line_rec;
1926: px_price_line_id_tbl(MOD(l_line_rec.line_id, G_BINARY_LIMIT)) := px_line_tbl.last; -- BUG 8631297

Line 2030: FND_MESSAGE.SET_NAME('ONT','ONT_PROMO_HOLD_APPLIED');

2026: );
2027:
2028: If l_return_status = FND_API.g_ret_sts_success then
2029: IF (p_line_id IS NULL) THEN
2030: FND_MESSAGE.SET_NAME('ONT','ONT_PROMO_HOLD_APPLIED');
2031: ELSE
2032: FND_MESSAGE.SET_NAME('ONT', 'ONT_LINE_PROMO_HOLD_APPLIED');
2033: END IF;
2034: OE_MSG_PUB.Add;

Line 2032: FND_MESSAGE.SET_NAME('ONT', 'ONT_LINE_PROMO_HOLD_APPLIED');

2028: If l_return_status = FND_API.g_ret_sts_success then
2029: IF (p_line_id IS NULL) THEN
2030: FND_MESSAGE.SET_NAME('ONT','ONT_PROMO_HOLD_APPLIED');
2031: ELSE
2032: FND_MESSAGE.SET_NAME('ONT', 'ONT_LINE_PROMO_HOLD_APPLIED');
2033: END IF;
2034: OE_MSG_PUB.Add;
2035: Else
2036: IF l_debug_level > 0 THEN

Line 2098: FND_MESSAGE.SET_NAME('ONT','ONT_PROMO_LIMIT_EXCEEDED');

2094: IF (l_limit_hold_action = 'NO_HOLD' or
2095: i.hold_code = QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED or
2096: nvl(l_TRANSACTION_PHASE_CODE, 'F') <> 'F'
2097: ) THEN
2098: FND_MESSAGE.SET_NAME('ONT','ONT_PROMO_LIMIT_EXCEEDED');
2099: OE_MSG_PUB.ADD;
2100: ELSE
2101: IF ( i.line_type_code = 'LINE')
2102: Then

Line 2196: FND_MESSAGE.SET_NAME('ONT','ONT_PROMO_LIMIT_EXCEEDED');

2192: ,p_source_document_type_id => nvl(l_source_document_type_id,
2193: oe_order_cache.g_header_rec.source_document_type_id));
2194: END IF;
2195:
2196: FND_MESSAGE.SET_NAME('ONT','ONT_PROMO_LIMIT_EXCEEDED');
2197: FND_MESSAGE.SET_TOKEN('ERR_TEXT', i.LIMIT_TEXT);
2198: OE_MSG_PUB.Add;
2199: IF (OE_GLOBALS.G_UI_FLAG ) THEN
2200: IF (G_REQUEST_ID IS NULL) THEN

Line 2197: FND_MESSAGE.SET_TOKEN('ERR_TEXT', i.LIMIT_TEXT);

2193: oe_order_cache.g_header_rec.source_document_type_id));
2194: END IF;
2195:
2196: FND_MESSAGE.SET_NAME('ONT','ONT_PROMO_LIMIT_EXCEEDED');
2197: FND_MESSAGE.SET_TOKEN('ERR_TEXT', i.LIMIT_TEXT);
2198: OE_MSG_PUB.Add;
2199: IF (OE_GLOBALS.G_UI_FLAG ) THEN
2200: IF (G_REQUEST_ID IS NULL) THEN
2201: select oe_msg_request_id_s.nextval into g_request_id from dual;