DBA Data[Home] [Help]

APPS.OE_ADV_PRICE_PVT dependencies on FND_MESSAGE

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

1125: FROM mtl_system_items_kfv
1126: WHERE inventory_item_id = l_line_rec.inventory_item_id
1127: AND organization_id = l_org_id;
1128: Exception when no_data_found then
1129: FND_MESSAGE.SET_NAME('ONT', 'ONT_PRG_INVALID_MASTER_ORG');
1130: SELECT QH.NAME, LDET.LIST_LINE_NO
1131: INTO l_modifier
1132: , l_list_line_no
1133: FROM QP_PREQ_RLTD_LINES_TMP RLTD

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

1138: AND RLTD.LINE_DETAIL_INDEX = LDET.LINE_DETAIL_INDEX
1139: AND LDET.LIST_HEADER_ID = QH.LIST_HEADER_ID AND ROWNUM=1;
1140:
1141:
1142: FND_MESSAGE.SET_TOKEN('MODIFIER', l_modifier);
1143: FND_MESSAGE.SET_TOKEN('LIST_LINE_NO', l_list_line_no);
1144: FND_MESSAGE.SET_TOKEN('ITEM', l_line_rec.inventory_item_id);
1145: BEGIN
1146: SELECT ORGANIZATION_NAME

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

1139: AND LDET.LIST_HEADER_ID = QH.LIST_HEADER_ID AND ROWNUM=1;
1140:
1141:
1142: FND_MESSAGE.SET_TOKEN('MODIFIER', l_modifier);
1143: FND_MESSAGE.SET_TOKEN('LIST_LINE_NO', l_list_line_no);
1144: FND_MESSAGE.SET_TOKEN('ITEM', l_line_rec.inventory_item_id);
1145: BEGIN
1146: SELECT ORGANIZATION_NAME
1147: INTO l_org

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

1140:
1141:
1142: FND_MESSAGE.SET_TOKEN('MODIFIER', l_modifier);
1143: FND_MESSAGE.SET_TOKEN('LIST_LINE_NO', l_list_line_no);
1144: FND_MESSAGE.SET_TOKEN('ITEM', l_line_rec.inventory_item_id);
1145: BEGIN
1146: SELECT ORGANIZATION_NAME
1147: INTO l_org
1148: FROM ORG_ORGANIZATION_DEFINITIONS

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

1149: WHERE ORGANIZATION_ID = l_org_id;
1150: EXCEPTION WHEN OTHERS THEN
1151: l_org := l_org_id;
1152: END;
1153: FND_MESSAGE.SET_TOKEN('ORG', l_org);
1154: OE_MSG_PUB.ADD;
1155: l_line_rec.operation := OE_GLOBALS.G_OPR_NONE;
1156: QP_UTIL_PUB.Update_Lines('MAKE_STATUS_INVALID',l_line_rec.line_id,
1157: NULL,NULL);

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

1484: , i.price_request_code
1485: );
1486: IF (l_line_rec.operation <> OE_GLOBALS.G_OPR_NONE) THEN
1487: -- Display the PRG Item
1488: FND_MESSAGE.SET_NAME('ONT','ONT_CREATED_NEW_LINE');
1489: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.ordered_item,l_line_rec.inventory_item_id));
1490: --bug 2412868 begin
1491: if l_line_rec.line_category_code = 'RETURN' then
1492: FND_MESSAGE.SET_TOKEN('QUANTITY',(-1) * l_line_rec.Ordered_quantity);

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

1485: );
1486: IF (l_line_rec.operation <> OE_GLOBALS.G_OPR_NONE) THEN
1487: -- Display the PRG Item
1488: FND_MESSAGE.SET_NAME('ONT','ONT_CREATED_NEW_LINE');
1489: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.ordered_item,l_line_rec.inventory_item_id));
1490: --bug 2412868 begin
1491: if l_line_rec.line_category_code = 'RETURN' then
1492: FND_MESSAGE.SET_TOKEN('QUANTITY',(-1) * l_line_rec.Ordered_quantity);
1493: else

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

1488: FND_MESSAGE.SET_NAME('ONT','ONT_CREATED_NEW_LINE');
1489: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.ordered_item,l_line_rec.inventory_item_id));
1490: --bug 2412868 begin
1491: if l_line_rec.line_category_code = 'RETURN' then
1492: FND_MESSAGE.SET_TOKEN('QUANTITY',(-1) * l_line_rec.Ordered_quantity);
1493: else
1494: --bug 2412868 end
1495: FND_MESSAGE.SET_TOKEN('QUANTITY',l_line_rec.Ordered_quantity);
1496: end if;

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

1491: if l_line_rec.line_category_code = 'RETURN' then
1492: FND_MESSAGE.SET_TOKEN('QUANTITY',(-1) * l_line_rec.Ordered_quantity);
1493: else
1494: --bug 2412868 end
1495: FND_MESSAGE.SET_TOKEN('QUANTITY',l_line_rec.Ordered_quantity);
1496: end if;
1497: OE_MSG_PUB.Add('N');
1498: px_line_tbl(px_line_tbl.last+1) := l_line_rec;
1499: px_price_line_id_tbl(l_line_rec.line_id) := px_line_tbl.last;

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

1599: );
1600:
1601: If l_return_status = FND_API.g_ret_sts_success then
1602: IF (p_line_id IS NULL) THEN
1603: FND_MESSAGE.SET_NAME('ONT','ONT_PROMO_HOLD_APPLIED');
1604: ELSE
1605: FND_MESSAGE.SET_NAME('ONT', 'ONT_LINE_PROMO_HOLD_APPLIED');
1606: END IF;
1607: OE_MSG_PUB.Add;

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

1601: If l_return_status = FND_API.g_ret_sts_success then
1602: IF (p_line_id IS NULL) THEN
1603: FND_MESSAGE.SET_NAME('ONT','ONT_PROMO_HOLD_APPLIED');
1604: ELSE
1605: FND_MESSAGE.SET_NAME('ONT', 'ONT_LINE_PROMO_HOLD_APPLIED');
1606: END IF;
1607: OE_MSG_PUB.Add;
1608: Else
1609: IF l_debug_level > 0 THEN

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

1667: IF (l_limit_hold_action = 'NO_HOLD' or
1668: i.hold_code = QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED or
1669: nvl(l_TRANSACTION_PHASE_CODE, 'F') <> 'F'
1670: ) THEN
1671: FND_MESSAGE.SET_NAME('ONT','ONT_PROMO_LIMIT_EXCEEDED');
1672: OE_MSG_PUB.ADD;
1673: ELSE
1674: IF ( i.line_type_code = 'LINE')
1675: Then

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

1765: ,p_source_document_type_id => nvl(l_source_document_type_id,
1766: oe_order_cache.g_header_rec.source_document_type_id));
1767: END IF;
1768:
1769: FND_MESSAGE.SET_NAME('ONT','ONT_PROMO_LIMIT_EXCEEDED');
1770: FND_MESSAGE.SET_TOKEN('ERR_TEXT', i.LIMIT_TEXT);
1771: OE_MSG_PUB.Add;
1772: IF (OE_GLOBALS.G_UI_FLAG ) THEN
1773: IF (G_REQUEST_ID IS NULL) THEN

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

1766: oe_order_cache.g_header_rec.source_document_type_id));
1767: END IF;
1768:
1769: FND_MESSAGE.SET_NAME('ONT','ONT_PROMO_LIMIT_EXCEEDED');
1770: FND_MESSAGE.SET_TOKEN('ERR_TEXT', i.LIMIT_TEXT);
1771: OE_MSG_PUB.Add;
1772: IF (OE_GLOBALS.G_UI_FLAG ) THEN
1773: IF (G_REQUEST_ID IS NULL) THEN
1774: select oe_msg_request_id_s.nextval into g_request_id from dual;