DBA Data[Home] [Help]

APPS.QP_VALIDATE_CURR_DETAILS dependencies on FND_MESSAGE

Line 92: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');

88:
89: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
90: THEN
91:
92: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
93: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','currency_detail_id');
94: OE_MSG_PUB.Add;
95:
96: END IF;

Line 93: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','currency_detail_id');

89: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
90: THEN
91:
92: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
93: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','currency_detail_id');
94: OE_MSG_PUB.Add;
95:
96: END IF;
97:

Line 114: FND_MESSAGE.SET_NAME('QP','QP_STRT_DATE_BFR_END_DATE');

110: THEN
111:
112: l_return_status := FND_API.G_RET_STS_ERROR;
113:
114: FND_MESSAGE.SET_NAME('QP','QP_STRT_DATE_BFR_END_DATE');
115: OE_MSG_PUB.Add;
116: -- oe_debug_pub.add(' Start_date End_Date Check; G_MSG_CONTEXT_COUNT: '||OE_MSG_PUB.G_MSG_CONTEXT_COUNT);
117: -- oe_debug_pub.add(' Start_date End_Date Check; G_MSG_COUNT: '||OE_MSG_PUB.G_MSG_COUNT);
118: -- oe_debug_pub.add('ERROR: start_date is after end_date');

Line 153: FND_MESSAGE.SET_NAME('QP','QP_OVERLAP_NOT_ALLWD'); -- CHANGE MESG_CODE

149: )
150: then
151:
152: l_return_status := FND_API.G_RET_STS_ERROR;
153: FND_MESSAGE.SET_NAME('QP','QP_OVERLAP_NOT_ALLWD'); -- CHANGE MESG_CODE
154: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',p_CURR_DETAILS_rec.to_currency_code);
155: OE_MSG_PUB.Add;
156: -- oe_debug_pub.add('ERROR: Multiple record(s) are active for the to_currency_code: '||p_CURR_DETAILS_rec.to_currency_code);
157: -- oe_debug_pub.add('. Form record start_date: '||NVL(p_CURR_DETAILS_rec.start_date_active, l_default_start_date_d));

Line 154: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',p_CURR_DETAILS_rec.to_currency_code);

150: then
151:
152: l_return_status := FND_API.G_RET_STS_ERROR;
153: FND_MESSAGE.SET_NAME('QP','QP_OVERLAP_NOT_ALLWD'); -- CHANGE MESG_CODE
154: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',p_CURR_DETAILS_rec.to_currency_code);
155: OE_MSG_PUB.Add;
156: -- oe_debug_pub.add('ERROR: Multiple record(s) are active for the to_currency_code: '||p_CURR_DETAILS_rec.to_currency_code);
157: -- oe_debug_pub.add('. Form record start_date: '||NVL(p_CURR_DETAILS_rec.start_date_active, l_default_start_date_d));
158: -- oe_debug_pub.add('. Form record end_date: '||NVL(p_CURR_DETAILS_rec.end_date_active, l_default_end_date_d));

Line 185: FND_MESSAGE.SET_NAME('QP','QP_INVALID_CURRENCY');

181:
182: EXCEPTION
183: WHEN NO_DATA_FOUND THEN
184: l_return_status := FND_API.G_RET_STS_ERROR;
185: FND_MESSAGE.SET_NAME('QP','QP_INVALID_CURRENCY');
186: OE_MSG_PUB.Add;
187: -- oe_debug_pub.add('ERROR: Invalid To_Currency_Code');
188:
189: END;

Line 214: FND_MESSAGE.SET_NAME('QP','QP_FORMULA_NOT_FOUND');

210:
211: EXCEPTION
212: WHEN NO_DATA_FOUND THEN
213: l_return_status := FND_API.G_RET_STS_ERROR;
214: FND_MESSAGE.SET_NAME('QP','QP_FORMULA_NOT_FOUND');
215: OE_MSG_PUB.Add;
216: oe_debug_pub.add('ERROR: Invalid price_formula_id');
217:
218: END;

Line 239: FND_MESSAGE.SET_NAME('QP','QP_INVALID_FORMULA_FOR_PL');

235:
236: EXCEPTION
237: WHEN NO_DATA_FOUND THEN
238: l_return_status := FND_API.G_RET_STS_ERROR;
239: FND_MESSAGE.SET_NAME('QP','QP_INVALID_FORMULA_FOR_PL');
240: OE_MSG_PUB.Add;
241: oe_debug_pub.add('ERROR: price_formula_id has MV as line type');
242:
243: END;

Line 257: FND_MESSAGE.SET_NAME('QP','Enter_Markup_FML_OR_Value'); -- CHANGE MESG_CODE

253: )
254: THEN
255: -- oe_debug_pub.add('ERROR: Markup Formula or Value should be provided if Markup Operator is present');
256: l_return_status := FND_API.G_RET_STS_ERROR;
257: FND_MESSAGE.SET_NAME('QP','Enter_Markup_FML_OR_Value'); -- CHANGE MESG_CODE
258: OE_MSG_PUB.Add;
259: END IF;
260:
261: -- Markup Operator should be present if either value or formula is present

Line 269: FND_MESSAGE.SET_NAME('QP','First_Enter_Markup_OPRTR'); -- CHANGE MESG_CODE

265: )
266: THEN
267: -- oe_debug_pub.add('ERROR: Markup Formula or Value can be provided only if Markup Operator is present');
268: l_return_status := FND_API.G_RET_STS_ERROR;
269: FND_MESSAGE.SET_NAME('QP','First_Enter_Markup_OPRTR'); -- CHANGE MESG_CODE
270: OE_MSG_PUB.Add;
271: END IF;
272: */
273:

Line 306: FND_MESSAGE.SET_NAME('QP','QP_FORMULA_NOT_FOUND');

302:
303: EXCEPTION
304: WHEN NO_DATA_FOUND THEN
305: l_return_status := FND_API.G_RET_STS_ERROR;
306: FND_MESSAGE.SET_NAME('QP','QP_FORMULA_NOT_FOUND');
307: OE_MSG_PUB.Add;
308: -- oe_debug_pub.add('ERROR: Invalid markup_formula_id');
309:
310: END;

Line 328: FND_MESSAGE.SET_NAME('QP','Invalid_Conversion_Method'); -- CHANGE MESG_CODE

324:
325: EXCEPTION
326: WHEN NO_DATA_FOUND THEN
327: l_return_status := FND_API.G_RET_STS_ERROR;
328: FND_MESSAGE.SET_NAME('QP','Invalid_Conversion_Method'); -- CHANGE MESG_CODE
329: OE_MSG_PUB.Add;
330:
331: END;
332: END IF;

Line 365: FND_MESSAGE.SET_NAME('QP','QP_INVALID_CONV_TYPE'); -- CHANGE MESG_CODE

361: WHEN NO_DATA_FOUND THEN
362: -- If not found in either GL or lookup_code then raise error
363:
364: l_return_status := FND_API.G_RET_STS_ERROR;
365: FND_MESSAGE.SET_NAME('QP','QP_INVALID_CONV_TYPE'); -- CHANGE MESG_CODE
366: FND_MESSAGE.SET_TOKEN('CONVERSION_TYPE',p_CURR_DETAILS_rec.conversion_type);
367: OE_MSG_PUB.Add;
368: -- oe_debug_pub.add('ERROR: Invalid Conversion_Type passed');
369: End;

Line 366: FND_MESSAGE.SET_TOKEN('CONVERSION_TYPE',p_CURR_DETAILS_rec.conversion_type);

362: -- If not found in either GL or lookup_code then raise error
363:
364: l_return_status := FND_API.G_RET_STS_ERROR;
365: FND_MESSAGE.SET_NAME('QP','QP_INVALID_CONV_TYPE'); -- CHANGE MESG_CODE
366: FND_MESSAGE.SET_TOKEN('CONVERSION_TYPE',p_CURR_DETAILS_rec.conversion_type);
367: OE_MSG_PUB.Add;
368: -- oe_debug_pub.add('ERROR: Invalid Conversion_Type passed');
369: End;
370: END;

Line 390: FND_MESSAGE.SET_NAME('QP','QP_INVALID_CONV_DT_TYPE'); -- CHANGE MESG_CODE

386:
387: EXCEPTION
388: WHEN NO_DATA_FOUND THEN
389: l_return_status := FND_API.G_RET_STS_ERROR;
390: FND_MESSAGE.SET_NAME('QP','QP_INVALID_CONV_DT_TYPE'); -- CHANGE MESG_CODE
391: FND_MESSAGE.SET_TOKEN('CONVERSION_DATE_TYPE',p_CURR_DETAILS_rec.conversion_date_type);
392: OE_MSG_PUB.Add;
393: -- oe_debug_pub.add('ERROR: Invalid conversion_date_type');
394:

Line 391: FND_MESSAGE.SET_TOKEN('CONVERSION_DATE_TYPE',p_CURR_DETAILS_rec.conversion_date_type);

387: EXCEPTION
388: WHEN NO_DATA_FOUND THEN
389: l_return_status := FND_API.G_RET_STS_ERROR;
390: FND_MESSAGE.SET_NAME('QP','QP_INVALID_CONV_DT_TYPE'); -- CHANGE MESG_CODE
391: FND_MESSAGE.SET_TOKEN('CONVERSION_DATE_TYPE',p_CURR_DETAILS_rec.conversion_date_type);
392: OE_MSG_PUB.Add;
393: -- oe_debug_pub.add('ERROR: Invalid conversion_date_type');
394:
395: END;

Line 420: FND_MESSAGE.SET_NAME('QP','QP_FRML_OR_VAL_REQD'); -- CHANGE MESG_CODE

416: )
417: THEN
418: -- oe_debug_pub.add('ERROR: Markup Formula or Value should be provided if Markup Operator is present');
419: l_return_status := FND_API.G_RET_STS_ERROR;
420: FND_MESSAGE.SET_NAME('QP','QP_FRML_OR_VAL_REQD'); -- CHANGE MESG_CODE
421: OE_MSG_PUB.Add;
422: END IF;
423:
424: EXCEPTION

Line 427: FND_MESSAGE.SET_NAME('QP','QP_INVALID_MARKUP_OPRTR');

423:
424: EXCEPTION
425: WHEN NO_DATA_FOUND THEN
426: l_return_status := FND_API.G_RET_STS_ERROR;
427: FND_MESSAGE.SET_NAME('QP','QP_INVALID_MARKUP_OPRTR');
428: FND_MESSAGE.SET_TOKEN('MARKUP_OPERATOR',p_CURR_DETAILS_rec.markup_operator);
429: OE_MSG_PUB.Add;
430: -- oe_debug_pub.add('ERROR: Invalid markup_operator');
431:

Line 428: FND_MESSAGE.SET_TOKEN('MARKUP_OPERATOR',p_CURR_DETAILS_rec.markup_operator);

424: EXCEPTION
425: WHEN NO_DATA_FOUND THEN
426: l_return_status := FND_API.G_RET_STS_ERROR;
427: FND_MESSAGE.SET_NAME('QP','QP_INVALID_MARKUP_OPRTR');
428: FND_MESSAGE.SET_TOKEN('MARKUP_OPERATOR',p_CURR_DETAILS_rec.markup_operator);
429: OE_MSG_PUB.Add;
430: -- oe_debug_pub.add('ERROR: Invalid markup_operator');
431:
432: END;

Line 442: FND_MESSAGE.SET_NAME('QP','QP_MARKUP_OPRTR_REQD'); -- CHANGE MESG_CODE

438: )
439: THEN
440: -- oe_debug_pub.add('ERROR: Markup Formula or Value can be provided only if Markup Operator is present');
441: l_return_status := FND_API.G_RET_STS_ERROR;
442: FND_MESSAGE.SET_NAME('QP','QP_MARKUP_OPRTR_REQD'); -- CHANGE MESG_CODE
443: OE_MSG_PUB.Add;
444: END IF;
445: END IF;
446:

Line 460: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');

456: WHERE currency_header_id = p_CURR_DETAILS_rec.currency_header_id;
457: Exception
458: When NO_DATA_FOUND THEN
459: l_return_status := FND_API.G_RET_STS_ERROR;
460: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
461: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','currency_header_id');
462: OE_MSG_PUB.Add;
463: END;
464:

Line 461: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','currency_header_id');

457: Exception
458: When NO_DATA_FOUND THEN
459: l_return_status := FND_API.G_RET_STS_ERROR;
460: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
461: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','currency_header_id');
462: OE_MSG_PUB.Add;
463: END;
464:
465: -- oe_debug_pub.add('Header Currency Code: '||l_base_currency_code_s);

Line 473: FND_MESSAGE.SET_NAME('QP','QP_TO_DIFFERENT_FROM_BASE'); -- CHANGE MESG_CODE

469: then
470:
471: -- oe_debug_pub.add('ERROR: To_Currency_Code can not be same as Base_Currency_Code');
472: l_return_status := FND_API.G_RET_STS_ERROR;
473: FND_MESSAGE.SET_NAME('QP','QP_TO_DIFFERENT_FROM_BASE'); -- CHANGE MESG_CODE
474: OE_MSG_PUB.Add;
475:
476: /* This validation is obsolete now
477: If (--p_CURR_DETAILS_rec.CONVERSION_METHOD is NOT NULL OR

Line 489: FND_MESSAGE.SET_NAME('QP','QP_VALUE_NOT_ALLWD_CURR'); -- CHANGE MESG_CODE

485: then
486:
487: -- oe_debug_pub.add('ERROR: Value is not allowed in the following fields when to_currency is same as base_currency: FIXED_VALUE, PRICE_FORMULA_id, CONVERSION_TYPE, CONVERSION_DATE_TYPE, CONVERSION_DATE, START_DATE_ACTIVE, END_DATE_ACTIVE');
488: l_return_status := FND_API.G_RET_STS_ERROR;
489: FND_MESSAGE.SET_NAME('QP','QP_VALUE_NOT_ALLWD_CURR'); -- CHANGE MESG_CODE
490: OE_MSG_PUB.Add;
491: End if;
492: */
493:

Line 502: FND_MESSAGE.SET_NAME('QP','QP_CONV_TYPE_REQD'); -- CHANGE MESG_CODE

498: THEN
499:
500: -- oe_debug_pub.add('ERROR: CONVERSION_TYPE is required when to_currency_code is different from base_currency_code');
501: l_return_status := FND_API.G_RET_STS_ERROR;
502: FND_MESSAGE.SET_NAME('QP','QP_CONV_TYPE_REQD'); -- CHANGE MESG_CODE
503: OE_MSG_PUB.Add;
504:
505: ELSIF (p_CURR_DETAILS_rec.CONVERSION_TYPE = 'TRANSACTION')
506: THEN

Line 514: FND_MESSAGE.SET_NAME('QP','QP_VALUE_NOT_ALLWD_TXN'); -- CHANGE MESG_CODE

510: p_CURR_DETAILS_rec.CONVERSION_DATE is not NULL)
511: then
512: -- oe_debug_pub.add('ERROR: Value is not allowed in the following fields when Conversion_Type = ''TRANSACTION'': FIXED_VALUE, PRICE_FORMULA_id, CONVERSION_DATE_TYPE, CONVERSION_DATE');
513: l_return_status := FND_API.G_RET_STS_ERROR;
514: FND_MESSAGE.SET_NAME('QP','QP_VALUE_NOT_ALLWD_TXN'); -- CHANGE MESG_CODE
515: OE_MSG_PUB.Add;
516: End If;
517:
518: ELSIF (p_CURR_DETAILS_rec.CONVERSION_TYPE = 'FIXED')

Line 524: FND_MESSAGE.SET_NAME('QP','QP_FIXED_VALUE_REQD'); -- CHANGE MESG_CODE

520: If (p_CURR_DETAILS_rec.FIXED_VALUE is NULL)
521: then
522: -- oe_debug_pub.add('ERROR: FIXED_VALUE is required ehen Conversion_Type is ''FIXED''');
523: l_return_status := FND_API.G_RET_STS_ERROR;
524: FND_MESSAGE.SET_NAME('QP','QP_FIXED_VALUE_REQD'); -- CHANGE MESG_CODE
525: OE_MSG_PUB.Add;
526: End If;
527:
528: If (p_CURR_DETAILS_rec.PRICE_FORMULA_id is not NULL OR

Line 535: FND_MESSAGE.SET_NAME('QP','QP_VALUE_NOT_ALLWD_FIXED'); -- CHANGE MESG_CODE

531: p_CURR_DETAILS_rec.CONVERSION_DATE is not NULL)
532: then
533: -- oe_debug_pub.add('ERROR: Value is not allowed in the following fields when Conversion_Type = ''FIXED'': PRICE_FORMULA_id, CONVERSION_DATE_TYPE, CONVERSION_DATE');
534: l_return_status := FND_API.G_RET_STS_ERROR;
535: FND_MESSAGE.SET_NAME('QP','QP_VALUE_NOT_ALLWD_FIXED'); -- CHANGE MESG_CODE
536: OE_MSG_PUB.Add;
537: End If;
538: -- ELSIF (p_CURR_DETAILS_rec.CONVERSION_METHOD = 'GL')
539: ELSIF (p_CURR_DETAILS_rec.CONVERSION_TYPE NOT IN ('FIXED', 'FORMULA', 'TRANSACTION'))

Line 546: FND_MESSAGE.SET_NAME('QP','QP_CONV_DT_TYPE_REQD'); -- CHANGE MESG_CODE

542: If (p_CURR_DETAILS_rec.CONVERSION_DATE_TYPE is NULL)
543: then
544: -- oe_debug_pub.add('ERROR: CONVERSION_DATE_TYPE is required when Conversion_Type is Not ''FIXED'' or ''FORMULA'' or ''TRANSACTION''');
545: l_return_status := FND_API.G_RET_STS_ERROR;
546: FND_MESSAGE.SET_NAME('QP','QP_CONV_DT_TYPE_REQD'); -- CHANGE MESG_CODE
547: OE_MSG_PUB.Add;
548: End If;
549:
550: If (p_CURR_DETAILS_rec.PRICE_FORMULA_id is not NULL OR

Line 555: FND_MESSAGE.SET_NAME('QP','QP_VALUE_NOT_ALLWD_GL'); -- CHANGE MESG_CODE

551: p_CURR_DETAILS_rec.FIXED_VALUE is not NULL)
552: then
553: -- oe_debug_pub.add('ERROR: Value is not allowed in the following fields when Conversion_Type is Not ''FIXED'' or ''FORMULA'': PRICE_FORMULA_id, FIXED_VALUE');
554: l_return_status := FND_API.G_RET_STS_ERROR;
555: FND_MESSAGE.SET_NAME('QP','QP_VALUE_NOT_ALLWD_GL'); -- CHANGE MESG_CODE
556: OE_MSG_PUB.Add;
557: End If;
558:
559: if (p_CURR_DETAILS_rec.CONVERSION_DATE_TYPE = 'FIXED')

Line 564: FND_MESSAGE.SET_NAME('QP','QP_CONV_DT_REQUIRED'); -- CHANGE MESG_CODE

560: then
561: if (p_CURR_DETAILS_rec.CONVERSION_DATE is NULL) then
562: -- oe_debug_pub.add('ERROR: CONVERSION_DATE is required when CONVERSION_TYPE is Not (''FIXED'' or ''FORMULA'' or ''TRANSACTION'') and CONVERSION_DATE_TYPE = ''FIXED''');
563: l_return_status := FND_API.G_RET_STS_ERROR;
564: FND_MESSAGE.SET_NAME('QP','QP_CONV_DT_REQUIRED'); -- CHANGE MESG_CODE
565: OE_MSG_PUB.Add;
566: End if;
567: Else
568: if (p_CURR_DETAILS_rec.CONVERSION_DATE is NOT NULL) then

Line 571: FND_MESSAGE.SET_NAME('QP','QP_CONV_DT_NOT_ALLWD'); -- CHANGE MESG_CODE

567: Else
568: if (p_CURR_DETAILS_rec.CONVERSION_DATE is NOT NULL) then
569: -- oe_debug_pub.add('ERROR: CONVERSION_DATE is allowed only when CONVERSION_TYPE is Not (''FIXED'' or ''FORMULA'' or ''TRANSACTION'') and CONVERSION_DATE_TYPE <> ''FIXED''');
570: l_return_status := FND_API.G_RET_STS_ERROR;
571: FND_MESSAGE.SET_NAME('QP','QP_CONV_DT_NOT_ALLWD'); -- CHANGE MESG_CODE
572: OE_MSG_PUB.Add;
573: End if;
574:
575: End if;

Line 581: FND_MESSAGE.SET_NAME('QP','QP_PRICE_FORMULA_REQD'); -- CHANGE MESG_CODE

577: THEN
578: If p_CURR_DETAILS_rec.PRICE_FORMULA_id is NULL then
579: -- oe_debug_pub.add('ERROR: PRICE_FORMULA_id is required for Conversion_Type = ''FORMULA''');
580: l_return_status := FND_API.G_RET_STS_ERROR;
581: FND_MESSAGE.SET_NAME('QP','QP_PRICE_FORMULA_REQD'); -- CHANGE MESG_CODE
582: OE_MSG_PUB.Add;
583: End If;
584:
585: If (p_CURR_DETAILS_rec.FIXED_VALUE is not NULL OR

Line 592: FND_MESSAGE.SET_NAME('QP','QP_FVAL_OR_CONV_NOT_ALLWD'); -- CHANGE MESG_CODE

588: then
589: -- oe_debug_pub.add('ERROR: Value is not allowed in the following fields when Conversion_Type = ''FORMULA'': FIXED_VALUE, CONVERSION_DATE_TYPE, CONVERSION_DATE');
590: -- oe_debug_pub.add('. FIXED VALUE: '||p_CURR_DETAILS_rec.FIXED_VALUE);
591: l_return_status := FND_API.G_RET_STS_ERROR;
592: FND_MESSAGE.SET_NAME('QP','QP_FVAL_OR_CONV_NOT_ALLWD'); -- CHANGE MESG_CODE
593: OE_MSG_PUB.Add;
594: End If;
595: END IF; -- Conversion_Type
596: END IF; -- to_currency_code = base_currency_code

Line 616: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');

612:
613: EXCEPTION
614: WHEN NO_DATA_FOUND THEN
615: l_return_status := FND_API.G_RET_STS_ERROR;
616: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
617: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CURRENCY ATTRIBUTE TYPE');
618: OE_MSG_PUB.Add;
619: -- oe_debug_pub.add('ERROR: Invalid curr_attribute_type');
620:

Line 617: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CURRENCY ATTRIBUTE TYPE');

613: EXCEPTION
614: WHEN NO_DATA_FOUND THEN
615: l_return_status := FND_API.G_RET_STS_ERROR;
616: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
617: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CURRENCY ATTRIBUTE TYPE');
618: OE_MSG_PUB.Add;
619: -- oe_debug_pub.add('ERROR: Invalid curr_attribute_type');
620:
621: END;

Line 657: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PROD_CONTEXT' );

653: Then
654: l_return_status := FND_API.G_RET_STS_ERROR;
655:
656: If p_CURR_DETAILS_rec.curr_attribute_type = 'PRODUCT' then
657: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PROD_CONTEXT' );
658: ElsIf p_CURR_DETAILS_rec.curr_attribute_type = 'PRICING' then
659: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PRICING_CONTEXT' );
660: ElsIf p_CURR_DETAILS_rec.curr_attribute_type = 'QUALIFIER' then
661: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');

Line 659: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PRICING_CONTEXT' );

655:
656: If p_CURR_DETAILS_rec.curr_attribute_type = 'PRODUCT' then
657: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PROD_CONTEXT' );
658: ElsIf p_CURR_DETAILS_rec.curr_attribute_type = 'PRICING' then
659: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PRICING_CONTEXT' );
660: ElsIf p_CURR_DETAILS_rec.curr_attribute_type = 'QUALIFIER' then
661: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
662: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','QUALIFIER ATTRIBUTE CONTEXT');
663: Else

Line 661: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');

657: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PROD_CONTEXT' );
658: ElsIf p_CURR_DETAILS_rec.curr_attribute_type = 'PRICING' then
659: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PRICING_CONTEXT' );
660: ElsIf p_CURR_DETAILS_rec.curr_attribute_type = 'QUALIFIER' then
661: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
662: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','QUALIFIER ATTRIBUTE CONTEXT');
663: Else
664: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
665: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CURRENCY ATTRIBUTE CONTEXT');

Line 662: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','QUALIFIER ATTRIBUTE CONTEXT');

658: ElsIf p_CURR_DETAILS_rec.curr_attribute_type = 'PRICING' then
659: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PRICING_CONTEXT' );
660: ElsIf p_CURR_DETAILS_rec.curr_attribute_type = 'QUALIFIER' then
661: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
662: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','QUALIFIER ATTRIBUTE CONTEXT');
663: Else
664: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
665: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CURRENCY ATTRIBUTE CONTEXT');
666: End if;

Line 664: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');

660: ElsIf p_CURR_DETAILS_rec.curr_attribute_type = 'QUALIFIER' then
661: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
662: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','QUALIFIER ATTRIBUTE CONTEXT');
663: Else
664: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
665: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CURRENCY ATTRIBUTE CONTEXT');
666: End if;
667:
668: OE_MSG_PUB.Add;

Line 665: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CURRENCY ATTRIBUTE CONTEXT');

661: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
662: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','QUALIFIER ATTRIBUTE CONTEXT');
663: Else
664: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
665: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CURRENCY ATTRIBUTE CONTEXT');
666: End if;
667:
668: OE_MSG_PUB.Add;
669: End If;

Line 676: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PROD_ATTR' );

672: Then
673: l_return_status := FND_API.G_RET_STS_ERROR;
674:
675: If p_CURR_DETAILS_rec.curr_attribute_type = 'PRODUCT' then
676: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PROD_ATTR' );
677: ElsIf p_CURR_DETAILS_rec.curr_attribute_type = 'PRICING' then
678: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PRICING_ATTR' );
679: ElsIf p_CURR_DETAILS_rec.curr_attribute_type = 'QUALIFIER' then
680: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');

Line 678: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PRICING_ATTR' );

674:
675: If p_CURR_DETAILS_rec.curr_attribute_type = 'PRODUCT' then
676: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PROD_ATTR' );
677: ElsIf p_CURR_DETAILS_rec.curr_attribute_type = 'PRICING' then
678: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PRICING_ATTR' );
679: ElsIf p_CURR_DETAILS_rec.curr_attribute_type = 'QUALIFIER' then
680: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
681: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','QUALIFIER ATTRIBUTE');
682: Else

Line 680: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');

676: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PROD_ATTR' );
677: ElsIf p_CURR_DETAILS_rec.curr_attribute_type = 'PRICING' then
678: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PRICING_ATTR' );
679: ElsIf p_CURR_DETAILS_rec.curr_attribute_type = 'QUALIFIER' then
680: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
681: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','QUALIFIER ATTRIBUTE');
682: Else
683: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
684: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CURRENCY ATTRIBUTE');

Line 681: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','QUALIFIER ATTRIBUTE');

677: ElsIf p_CURR_DETAILS_rec.curr_attribute_type = 'PRICING' then
678: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PRICING_ATTR' );
679: ElsIf p_CURR_DETAILS_rec.curr_attribute_type = 'QUALIFIER' then
680: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
681: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','QUALIFIER ATTRIBUTE');
682: Else
683: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
684: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CURRENCY ATTRIBUTE');
685: End if;

Line 683: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');

679: ElsIf p_CURR_DETAILS_rec.curr_attribute_type = 'QUALIFIER' then
680: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
681: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','QUALIFIER ATTRIBUTE');
682: Else
683: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
684: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CURRENCY ATTRIBUTE');
685: End if;
686:
687: OE_MSG_PUB.Add;

Line 684: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CURRENCY ATTRIBUTE');

680: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
681: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','QUALIFIER ATTRIBUTE');
682: Else
683: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
684: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CURRENCY ATTRIBUTE');
685: End if;
686:
687: OE_MSG_PUB.Add;
688: End If;

Line 695: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PROD_VALUE' );

691: Then
692: l_return_status := FND_API.G_RET_STS_ERROR;
693:
694: If p_CURR_DETAILS_rec.curr_attribute_type = 'PRODUCT' then
695: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PROD_VALUE' );
696: ElsIf p_CURR_DETAILS_rec.curr_attribute_type = 'PRICING' then
697: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE' );
698: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','PRICING ATTRIBUTE VALUE');
699: ElsIf p_CURR_DETAILS_rec.curr_attribute_type = 'QUALIFIER' then

Line 697: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE' );

693:
694: If p_CURR_DETAILS_rec.curr_attribute_type = 'PRODUCT' then
695: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PROD_VALUE' );
696: ElsIf p_CURR_DETAILS_rec.curr_attribute_type = 'PRICING' then
697: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE' );
698: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','PRICING ATTRIBUTE VALUE');
699: ElsIf p_CURR_DETAILS_rec.curr_attribute_type = 'QUALIFIER' then
700: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE' );
701: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','QUALIFIER ATTRIBUTE VALUE');

Line 698: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','PRICING ATTRIBUTE VALUE');

694: If p_CURR_DETAILS_rec.curr_attribute_type = 'PRODUCT' then
695: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PROD_VALUE' );
696: ElsIf p_CURR_DETAILS_rec.curr_attribute_type = 'PRICING' then
697: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE' );
698: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','PRICING ATTRIBUTE VALUE');
699: ElsIf p_CURR_DETAILS_rec.curr_attribute_type = 'QUALIFIER' then
700: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE' );
701: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','QUALIFIER ATTRIBUTE VALUE');
702: Else

Line 700: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE' );

696: ElsIf p_CURR_DETAILS_rec.curr_attribute_type = 'PRICING' then
697: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE' );
698: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','PRICING ATTRIBUTE VALUE');
699: ElsIf p_CURR_DETAILS_rec.curr_attribute_type = 'QUALIFIER' then
700: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE' );
701: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','QUALIFIER ATTRIBUTE VALUE');
702: Else
703: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
704: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ATTRIBUTE VALUE');

Line 701: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','QUALIFIER ATTRIBUTE VALUE');

697: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE' );
698: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','PRICING ATTRIBUTE VALUE');
699: ElsIf p_CURR_DETAILS_rec.curr_attribute_type = 'QUALIFIER' then
700: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE' );
701: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','QUALIFIER ATTRIBUTE VALUE');
702: Else
703: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
704: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ATTRIBUTE VALUE');
705: End if;

Line 703: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');

699: ElsIf p_CURR_DETAILS_rec.curr_attribute_type = 'QUALIFIER' then
700: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE' );
701: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','QUALIFIER ATTRIBUTE VALUE');
702: Else
703: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
704: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ATTRIBUTE VALUE');
705: End if;
706:
707: OE_MSG_PUB.Add;

Line 704: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ATTRIBUTE VALUE');

700: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE' );
701: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','QUALIFIER ATTRIBUTE VALUE');
702: Else
703: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
704: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ATTRIBUTE VALUE');
705: End if;
706:
707: OE_MSG_PUB.Add;
708: End If;

Line 715: FND_MESSAGE.SET_NAME('QP','QP_PRECEDENCE_REQD'); -- CHANGE MESG_CODE

711: -- Precedence should be NOT NULL
712: If p_CURR_DETAILS_rec.precedence IS NULL
713: then
714: l_return_status := FND_API.G_RET_STS_ERROR;
715: FND_MESSAGE.SET_NAME('QP','QP_PRECEDENCE_REQD'); -- CHANGE MESG_CODE
716: OE_MSG_PUB.Add;
717: -- oe_debug_pub.add('ERROR: Precedence is required when Attribute type is not NULL');
718: End If; -- precedence is null
719:

Line 740: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ITEM');

736: EXCEPTION
737: WHEN NO_DATA_FOUND THEN
738: l_return_status := FND_API.G_RET_STS_ERROR;
739:
740: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ITEM');
741: FND_MESSAGE.SET_TOKEN('ITEM_ID',p_CURR_DETAILS_rec.curr_attribute_value);
742: OE_MSG_PUB.Add;
743: --** oe_debug_pub.add('ERROR: Invalid Inventory_Item_id provided');
744:

Line 741: FND_MESSAGE.SET_TOKEN('ITEM_ID',p_CURR_DETAILS_rec.curr_attribute_value);

737: WHEN NO_DATA_FOUND THEN
738: l_return_status := FND_API.G_RET_STS_ERROR;
739:
740: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ITEM');
741: FND_MESSAGE.SET_TOKEN('ITEM_ID',p_CURR_DETAILS_rec.curr_attribute_value);
742: OE_MSG_PUB.Add;
743: --** oe_debug_pub.add('ERROR: Invalid Inventory_Item_id provided');
744:
745: END;

Line 763: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ITEM_CATEGORY');

759: EXCEPTION
760: WHEN NO_DATA_FOUND THEN
761: l_return_status := FND_API.G_RET_STS_ERROR;
762:
763: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ITEM_CATEGORY');
764: FND_MESSAGE.SET_TOKEN('CATEGORY_ID',p_CURR_DETAILS_rec.curr_attribute_value);
765: OE_MSG_PUB.Add;
766: --** oe_debug_pub.add('ERROR: Invalid Category_id provided');
767:

Line 764: FND_MESSAGE.SET_TOKEN('CATEGORY_ID',p_CURR_DETAILS_rec.curr_attribute_value);

760: WHEN NO_DATA_FOUND THEN
761: l_return_status := FND_API.G_RET_STS_ERROR;
762:
763: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ITEM_CATEGORY');
764: FND_MESSAGE.SET_TOKEN('CATEGORY_ID',p_CURR_DETAILS_rec.curr_attribute_value);
765: OE_MSG_PUB.Add;
766: --** oe_debug_pub.add('ERROR: Invalid Category_id provided');
767:
768: END;*/

Line 788: FND_MESSAGE.set_name('QP', 'QP_INVALID_CAT_FUNC_PTE');

784: IF NOT l_fna_valid THEN
785:
786: l_return_status := FND_API.G_RET_STS_ERROR;
787:
788: FND_MESSAGE.set_name('QP', 'QP_INVALID_CAT_FUNC_PTE');
789: FND_MESSAGE.set_token('CATID', p_CURR_DETAILS_rec.curr_attribute_value);
790: FND_MESSAGE.set_token('PTE', l_pte_code);
791: FND_MESSAGE.set_token('SS', l_ss_code);
792: OE_MSG_PUB.Add;

Line 789: FND_MESSAGE.set_token('CATID', p_CURR_DETAILS_rec.curr_attribute_value);

785:
786: l_return_status := FND_API.G_RET_STS_ERROR;
787:
788: FND_MESSAGE.set_name('QP', 'QP_INVALID_CAT_FUNC_PTE');
789: FND_MESSAGE.set_token('CATID', p_CURR_DETAILS_rec.curr_attribute_value);
790: FND_MESSAGE.set_token('PTE', l_pte_code);
791: FND_MESSAGE.set_token('SS', l_ss_code);
792: OE_MSG_PUB.Add;
793:

Line 790: FND_MESSAGE.set_token('PTE', l_pte_code);

786: l_return_status := FND_API.G_RET_STS_ERROR;
787:
788: FND_MESSAGE.set_name('QP', 'QP_INVALID_CAT_FUNC_PTE');
789: FND_MESSAGE.set_token('CATID', p_CURR_DETAILS_rec.curr_attribute_value);
790: FND_MESSAGE.set_token('PTE', l_pte_code);
791: FND_MESSAGE.set_token('SS', l_ss_code);
792: OE_MSG_PUB.Add;
793:
794: END IF;

Line 791: FND_MESSAGE.set_token('SS', l_ss_code);

787:
788: FND_MESSAGE.set_name('QP', 'QP_INVALID_CAT_FUNC_PTE');
789: FND_MESSAGE.set_token('CATID', p_CURR_DETAILS_rec.curr_attribute_value);
790: FND_MESSAGE.set_token('PTE', l_pte_code);
791: FND_MESSAGE.set_token('SS', l_ss_code);
792: OE_MSG_PUB.Add;
793:
794: END IF;
795:

Line 809: FND_MESSAGE.SET_NAME('QP','QP_CURR_ATTRS_REQD_OR_NULL'); -- CHANGE MESG_CODE

805: THEN
806: -- This elsif checks if any of the curr_attribute is not NULL. Since the above test failed
807: -- so at least one of these attributes is NULL.
808: l_return_status := FND_API.G_RET_STS_ERROR;
809: FND_MESSAGE.SET_NAME('QP','QP_CURR_ATTRS_REQD_OR_NULL'); -- CHANGE MESG_CODE
810: OE_MSG_PUB.Add;
811: -- oe_debug_pub.add('ERROR: All of the following fields should either be NULL or NOT NULL: CURR_ATTRIBUTE_TYPE, CURR_ATTRIBUTE_CONTEXT, CURR_ATTRIBUTE, CURR_ATTRIBUTE_VALUE');
812:
813: END IF;

Line 822: FND_MESSAGE.SET_NAME('QP','QP_INTEGER_REQUIRED');

818: If ( (instr(to_char(p_CURR_DETAILS_rec.precedence), '.', 1) <> 0) OR
819: (p_CURR_DETAILS_rec.precedence < 0) )
820: then
821: l_return_status := FND_API.G_RET_STS_ERROR;
822: FND_MESSAGE.SET_NAME('QP','QP_INTEGER_REQUIRED');
823: FND_MESSAGE.SET_TOKEN('ENTITY','PRECEDENCE');
824: OE_MSG_PUB.Add;
825: -- oe_debug_pub.add('ERROR: Precedence should be a positive integer value');
826: Else

Line 823: FND_MESSAGE.SET_TOKEN('ENTITY','PRECEDENCE');

819: (p_CURR_DETAILS_rec.precedence < 0) )
820: then
821: l_return_status := FND_API.G_RET_STS_ERROR;
822: FND_MESSAGE.SET_NAME('QP','QP_INTEGER_REQUIRED');
823: FND_MESSAGE.SET_TOKEN('ENTITY','PRECEDENCE');
824: OE_MSG_PUB.Add;
825: -- oe_debug_pub.add('ERROR: Precedence should be a positive integer value');
826: Else
827: -- Validate that only one active detail record exist at any point of time

Line 853: FND_MESSAGE.SET_NAME('QP','QP_UNIQUE_PRECEDENCE'); -- CHANGE MESG_CODE

849: )
850: then
851:
852: l_return_status := FND_API.G_RET_STS_ERROR;
853: FND_MESSAGE.SET_NAME('QP','QP_UNIQUE_PRECEDENCE'); -- CHANGE MESG_CODE
854: OE_MSG_PUB.Add;
855: -- oe_debug_pub.add('ERROR: Precedence should be unique for a to_currency_code within a given period');
856: exit; -- Exit the loop
857: End if; -- date check

Line 892: FND_MESSAGE.SET_NAME('QP','QP_RNDG_FACTOR_REQD');

888: p_CURR_DETAILS_rec.selling_rounding_factor = FND_API.G_MISS_NUM )
889: then
890: l_return_status := FND_API.G_RET_STS_ERROR;
891:
892: FND_MESSAGE.SET_NAME('QP','QP_RNDG_FACTOR_REQD');
893: oe_msg_pub.add;
894:
895: end if;
896:

Line 965: FND_MESSAGE.SET_NAME('QP','QP_ENABLE_SOURCING');

961: oe_debug_pub.add('Here 4444');
962: IF l_sourcing_enabled <> 'Y' THEN
963:
964: oe_debug_pub.add('Here 5555');
965: FND_MESSAGE.SET_NAME('QP','QP_ENABLE_SOURCING');
966: FND_MESSAGE.SET_TOKEN('CONTEXT',
967: p_CURR_DETAILS_rec.curr_attribute_context);
968: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
969: p_CURR_DETAILS_rec.curr_attribute);

Line 966: FND_MESSAGE.SET_TOKEN('CONTEXT',

962: IF l_sourcing_enabled <> 'Y' THEN
963:
964: oe_debug_pub.add('Here 5555');
965: FND_MESSAGE.SET_NAME('QP','QP_ENABLE_SOURCING');
966: FND_MESSAGE.SET_TOKEN('CONTEXT',
967: p_CURR_DETAILS_rec.curr_attribute_context);
968: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
969: p_CURR_DETAILS_rec.curr_attribute);
970: OE_MSG_PUB.Add;

Line 968: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

964: oe_debug_pub.add('Here 5555');
965: FND_MESSAGE.SET_NAME('QP','QP_ENABLE_SOURCING');
966: FND_MESSAGE.SET_TOKEN('CONTEXT',
967: p_CURR_DETAILS_rec.curr_attribute_context);
968: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
969: p_CURR_DETAILS_rec.curr_attribute);
970: OE_MSG_PUB.Add;
971:
972: END IF;

Line 977: FND_MESSAGE.SET_NAME('QP','QP_BUILD_SOURCING_RULES');

973:
974: IF l_sourcing_status <> 'Y' THEN
975:
976: oe_debug_pub.add('Here 6666');
977: FND_MESSAGE.SET_NAME('QP','QP_BUILD_SOURCING_RULES');
978: FND_MESSAGE.SET_TOKEN('CONTEXT',
979: p_CURR_DETAILS_rec.curr_attribute_context);
980: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
981: p_CURR_DETAILS_rec.curr_attribute);

Line 978: FND_MESSAGE.SET_TOKEN('CONTEXT',

974: IF l_sourcing_status <> 'Y' THEN
975:
976: oe_debug_pub.add('Here 6666');
977: FND_MESSAGE.SET_NAME('QP','QP_BUILD_SOURCING_RULES');
978: FND_MESSAGE.SET_TOKEN('CONTEXT',
979: p_CURR_DETAILS_rec.curr_attribute_context);
980: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
981: p_CURR_DETAILS_rec.curr_attribute);
982: OE_MSG_PUB.Add;

Line 980: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

976: oe_debug_pub.add('Here 6666');
977: FND_MESSAGE.SET_NAME('QP','QP_BUILD_SOURCING_RULES');
978: FND_MESSAGE.SET_TOKEN('CONTEXT',
979: p_CURR_DETAILS_rec.curr_attribute_context);
980: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
981: p_CURR_DETAILS_rec.curr_attribute);
982: OE_MSG_PUB.Add;
983:
984: END IF;