DBA Data[Home] [Help]

APPS.QP_VALIDATE_PRICING_ATTR dependencies on QP_PRC_UTIL

Line 221: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('EXCLUDER_FLAG')); -- Fix For Bug-1974413

217: oe_debug_pub.add('excluder flag null');
218: l_return_status := FND_API.G_RET_STS_ERROR;
219:
220: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
221: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('EXCLUDER_FLAG')); -- Fix For Bug-1974413
222: OE_MSG_PUB.Add;
223:
224: ELSIF ( p_PRICING_ATTR_rec.excluder_flag <> 'Y' AND
225: p_PRICING_ATTR_rec.excluder_flag <> 'N' )

Line 252: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('COMPARISON_OPERATOR_CODE')); -- Fix For Bug-1974413

248:
249: l_return_status := FND_API.G_RET_STS_ERROR;
250:
251: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
252: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('COMPARISON_OPERATOR_CODE')); -- Fix For Bug-1974413
253: OE_MSG_PUB.Add;
254:
255: END IF;
256:

Line 277: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTR_VALUE_FROM')||'/'||

273:
274: l_return_status := FND_API.G_RET_STS_ERROR;
275:
276: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
277: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTR_VALUE_FROM')||'/'||
278: QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTR_VALUE_TO')); --Fix For Bug-1974413
279: OE_MSG_PUB.Add;
280:
281: -- Do not check for value to null. This change is to avoid an error being thrown

Line 278: QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTR_VALUE_TO')); --Fix For Bug-1974413

274: l_return_status := FND_API.G_RET_STS_ERROR;
275:
276: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
277: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTR_VALUE_FROM')||'/'||
278: QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTR_VALUE_TO')); --Fix For Bug-1974413
279: OE_MSG_PUB.Add;
280:
281: -- Do not check for value to null. This change is to avoid an error being thrown
282: -- when a null value to is entered for the last price break (infinite value)

Line 292: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTR_VALUE_FROM')||'/'||

288:
289: l_return_status := FND_API.G_RET_STS_ERROR;
290:
291: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
292: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTR_VALUE_FROM')||'/'||
293: QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTR_VALUE_TO')); --Fix For Bug-1974413
294: OE_MSG_PUB.Add;
295:
296: ELSIF p_PRICING_ATTR_rec.comparison_operator_code = 'BETWEEN'

Line 293: QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTR_VALUE_TO')); --Fix For Bug-1974413

289: l_return_status := FND_API.G_RET_STS_ERROR;
290:
291: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
292: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTR_VALUE_FROM')||'/'||
293: QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTR_VALUE_TO')); --Fix For Bug-1974413
294: OE_MSG_PUB.Add;
295:
296: ELSIF p_PRICING_ATTR_rec.comparison_operator_code = 'BETWEEN'
297: AND p_PRICING_ATTR_rec.pricing_attr_value_from IS NULL

Line 303: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTR_VALUE_FROM')); -- Fix For Bug-1974413

299:
300: l_return_status := FND_API.G_RET_STS_ERROR;
301:
302: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
303: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTR_VALUE_FROM')); -- Fix For Bug-1974413
304: OE_MSG_PUB.Add;
305: END IF;
306:
307:

Line 363: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTR_VALUE_FROM')||'/'||

359:
360: l_return_status := FND_API.G_RET_STS_ERROR;
361:
362: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
363: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTR_VALUE_FROM')||'/'||
364: QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTR_VALUE_TO')); -- Fix For Bug-1974413
365: OE_MSG_PUB.Add;
366:
367: ELSIF p_PRICING_ATTR_rec.pricing_attribute_context

Line 364: QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTR_VALUE_TO')); -- Fix For Bug-1974413

360: l_return_status := FND_API.G_RET_STS_ERROR;
361:
362: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
363: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTR_VALUE_FROM')||'/'||
364: QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTR_VALUE_TO')); -- Fix For Bug-1974413
365: OE_MSG_PUB.Add;
366:
367: ELSIF p_PRICING_ATTR_rec.pricing_attribute_context
368: <> 'VOLUME'

Line 379: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTR_VALUE_FROM')||'/'|| QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTR_VALUE_TO')); --Fix For Bug-1974413

375:
376: l_return_status := FND_API.G_RET_STS_ERROR;
377:
378: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
379: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTR_VALUE_FROM')||'/'|| QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTR_VALUE_TO')); --Fix For Bug-1974413
380: OE_MSG_PUB.Add;
381:
382:
383: END IF;

Line 632: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRODUCT_UOM_CODE')); -- Fix For Bug-1974413

628: p_PRICING_ATTR_rec.PRICING_ATTRIBUTE = 'PRICING_ATTRIBUTE10') THEN
629: l_return_status := FND_API.G_RET_STS_ERROR;
630:
631: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
632: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRODUCT_UOM_CODE')); -- Fix For Bug-1974413
633: OE_MSG_PUB.Add;
634: END IF;
635: END IF;
636:

Line 647: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRODUCT_ATTRIBUTE')||'/'||

643:
644: l_return_status := FND_API.G_RET_STS_ERROR;
645:
646: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
647: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRODUCT_ATTRIBUTE')||'/'||
648: QP_PRC_UTIL.Get_Attribute_Name('PRODUCT_ATTR_VALUE')); -- Fix For Bug-1974413
649: OE_MSG_PUB.Add;
650:
651: ELSE

Line 648: QP_PRC_UTIL.Get_Attribute_Name('PRODUCT_ATTR_VALUE')); -- Fix For Bug-1974413

644: l_return_status := FND_API.G_RET_STS_ERROR;
645:
646: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
647: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRODUCT_ATTRIBUTE')||'/'||
648: QP_PRC_UTIL.Get_Attribute_Name('PRODUCT_ATTR_VALUE')); -- Fix For Bug-1974413
649: OE_MSG_PUB.Add;
650:
651: ELSE
652:

Line 867: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRODUCT_ATTRIBUTE_CONTEXT')||'/'||

863:
864: l_return_status := FND_API.G_RET_STS_ERROR;
865:
866: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
867: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRODUCT_ATTRIBUTE_CONTEXT')||'/'||
868: QP_PRC_UTIL.Get_Attribute_Name('PRODUCT_ATTRIBUTE')||'/'||
869: QP_PRC_UTIL.Get_Attribute_Name('PRODUCT_ATTR_VALUE')); -- Fix For Bug-1974413
870: OE_MSG_PUB.Add;
871:

Line 868: QP_PRC_UTIL.Get_Attribute_Name('PRODUCT_ATTRIBUTE')||'/'||

864: l_return_status := FND_API.G_RET_STS_ERROR;
865:
866: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
867: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRODUCT_ATTRIBUTE_CONTEXT')||'/'||
868: QP_PRC_UTIL.Get_Attribute_Name('PRODUCT_ATTRIBUTE')||'/'||
869: QP_PRC_UTIL.Get_Attribute_Name('PRODUCT_ATTR_VALUE')); -- Fix For Bug-1974413
870: OE_MSG_PUB.Add;
871:
872: END IF;

Line 869: QP_PRC_UTIL.Get_Attribute_Name('PRODUCT_ATTR_VALUE')); -- Fix For Bug-1974413

865:
866: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
867: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRODUCT_ATTRIBUTE_CONTEXT')||'/'||
868: QP_PRC_UTIL.Get_Attribute_Name('PRODUCT_ATTRIBUTE')||'/'||
869: QP_PRC_UTIL.Get_Attribute_Name('PRODUCT_ATTR_VALUE')); -- Fix For Bug-1974413
870: OE_MSG_PUB.Add;
871:
872: END IF;
873:

Line 993: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRODUCT_PRECEDENCE')); -- Fix For Bug-1974413

989: if p_PRICING_ATTR_rec.excluder_flag = 'N' then
990: l_return_status := FND_API.G_RET_STS_ERROR;
991:
992: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
993: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRODUCT_PRECEDENCE')); -- Fix For Bug-1974413
994: OE_MSG_PUB.Add;
995: end if;
996:
997: END IF;

Line 1090: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRORATION_TYPE_CODE')); -- Fix For Bug-1974413

1086:
1087: l_return_status := FND_API.G_RET_STS_ERROR;
1088:
1089: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
1090: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRORATION_TYPE_CODE')); -- Fix For Bug-1974413
1091: OE_MSG_PUB.Add;
1092:
1093: END IF;
1094:

Line 1106: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRORATION_TYPE_CODE')); -- Fix For Bug-1974413

1102:
1103: l_return_status := FND_API.G_RET_STS_ERROR;
1104:
1105: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
1106: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRORATION_TYPE_CODE')); -- Fix For Bug-1974413
1107: OE_MSG_PUB.Add;
1108:
1109: END IF;
1110: