eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_VALIDATE_CURR_DETAILS dependencies on OE_MSG_PUB

Line 89: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

85:
86: l_return_status := FND_API.G_RET_STS_ERROR;
87: -- oe_debug_pub.add('ERROR: currency_detail_id is NULL');
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');

Line 94: OE_MSG_PUB.Add;

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:
98: END IF;

Line 115: OE_MSG_PUB.Add;

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');
119: -- oe_debug_pub.add('. start_date: '||NVL(p_CURR_DETAILS_rec.start_date_active, sysdate));

Line 116: -- oe_debug_pub.add(' Start_date End_Date Check; G_MSG_CONTEXT_COUNT: '||OE_MSG_PUB.G_MSG_CONTEXT_COUNT);

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');
119: -- oe_debug_pub.add('. start_date: '||NVL(p_CURR_DETAILS_rec.start_date_active, sysdate));
120: -- oe_debug_pub.add('. end_date: '||NVL(p_CURR_DETAILS_rec.end_date_active, sysdate));

Line 117: -- oe_debug_pub.add(' Start_date End_Date Check; G_MSG_COUNT: '||OE_MSG_PUB.G_MSG_COUNT);

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');
119: -- oe_debug_pub.add('. start_date: '||NVL(p_CURR_DETAILS_rec.start_date_active, sysdate));
120: -- oe_debug_pub.add('. end_date: '||NVL(p_CURR_DETAILS_rec.end_date_active, sysdate));
121: -- raise FND_API.G_EXC_ERROR;

Line 155: OE_MSG_PUB.Add;

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));
159: -- oe_debug_pub.add('. Existing record start_date: '||NVL(detail_rec.start_date_active, l_default_start_date_d));

Line 186: OE_MSG_PUB.Add;

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;
190:

Line 215: OE_MSG_PUB.Add;

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;
219:

Line 240: OE_MSG_PUB.Add;

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;
244: END IF;

Line 258: OE_MSG_PUB.Add;

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
262: IF ((p_CURR_DETAILS_rec.markup_operator IS NULL) AND

Line 270: OE_MSG_PUB.Add;

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:
274: -- Validate detail records' markup_formula

Line 307: OE_MSG_PUB.Add;

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;
311: END IF;

Line 329: OE_MSG_PUB.Add;

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;
333: */

Line 367: OE_MSG_PUB.Add;

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;
371: END IF;

Line 392: OE_MSG_PUB.Add;

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;
396: END IF;

Line 421: OE_MSG_PUB.Add;

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
425: WHEN NO_DATA_FOUND THEN

Line 429: OE_MSG_PUB.Add;

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;
433: ELSE

Line 443: OE_MSG_PUB.Add;

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:
447: -- Below statements Validate detail records' conditionally required columns

Line 462: OE_MSG_PUB.Add;

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);
466: -- --oe_debug_pub.add('Conversion Method: '||p_CURR_DETAILS_rec.CONVERSION_METHOD);

Line 474: OE_MSG_PUB.Add;

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
478: p_CURR_DETAILS_rec.FIXED_VALUE is NOT NULL OR

Line 490: OE_MSG_PUB.Add;

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:
494: ELSE -- to_currency_code is different from base_currency_code

Line 503: OE_MSG_PUB.Add;

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
507: If (p_CURR_DETAILS_rec.FIXED_VALUE is NOT NULL OR

Line 515: OE_MSG_PUB.Add;

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')
519: THEN

Line 525: OE_MSG_PUB.Add;

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
529: -- p_CURR_DETAILS_rec.CONVERSION_TYPE is not NULL OR

Line 536: OE_MSG_PUB.Add;

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'))
540: THEN

Line 547: OE_MSG_PUB.Add;

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
551: p_CURR_DETAILS_rec.FIXED_VALUE is not NULL)

Line 556: OE_MSG_PUB.Add;

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')
560: then

Line 565: OE_MSG_PUB.Add;

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
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''');

Line 572: OE_MSG_PUB.Add;

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;
576: ELSIF (p_CURR_DETAILS_rec.CONVERSION_TYPE = 'FORMULA')

Line 582: OE_MSG_PUB.Add;

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
586: p_CURR_DETAILS_rec.CONVERSION_DATE_TYPE is not NULL OR

Line 593: OE_MSG_PUB.Add;

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
597:

Line 618: OE_MSG_PUB.Add;

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;
622: END IF;

Line 668: OE_MSG_PUB.Add;

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;
670:
671: If (l_attribute_flag = 'N' AND l_error_code = 8) -- invalid attribute
672: Then

Line 687: OE_MSG_PUB.Add;

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;
689:
690: If (l_value_flag = 'N' AND l_error_code = 9) -- invalid value
691: Then

Line 707: OE_MSG_PUB.Add;

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;
709:
710:
711: -- Precedence should be NOT NULL

Line 716: OE_MSG_PUB.Add;

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:
720: -- Validate the Inventory_item_id/category_id if the type is PRODUCT and attribute

Line 742: OE_MSG_PUB.Add;

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;
746:

Line 765: OE_MSG_PUB.Add;

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;*/
769:

Line 792: OE_MSG_PUB.Add;

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:
796: END;

Line 810: OE_MSG_PUB.Add;

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;
814:

Line 824: OE_MSG_PUB.Add;

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
828: BEGIN

Line 854: OE_MSG_PUB.Add;

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
858: END LOOP;

Line 893: oe_msg_pub.add;

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:
897: END;

Line 900: -- oe_debug_pub.add('G_MSG_CONTEXT_COUNT: '||OE_MSG_PUB.G_MSG_CONTEXT_COUNT);

896:
897: END;
898: -- Above statements Validate detail records' conditionally required columns
899:
900: -- oe_debug_pub.add('G_MSG_CONTEXT_COUNT: '||OE_MSG_PUB.G_MSG_CONTEXT_COUNT);
901: -- oe_debug_pub.add('Coming Out of CDT L package');
902: -- Above validations Added by Sunil Pandey
903:
904:

Line 970: OE_MSG_PUB.Add;

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;
973:
974: IF l_sourcing_status <> 'Y' THEN

Line 982: OE_MSG_PUB.Add;

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;
985:
986: END IF; --If sourcing_method = 'ATTRIBUTE MAPPING'

Line 1013: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1009: WHEN OTHERS THEN
1010:
1011: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1012:
1013: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1014: THEN
1015: OE_MSG_PUB.Add_Exc_Msg
1016: ( G_PKG_NAME
1017: , 'Entity'

Line 1015: OE_MSG_PUB.Add_Exc_Msg

1011: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1012:
1013: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1014: THEN
1015: OE_MSG_PUB.Add_Exc_Msg
1016: ( G_PKG_NAME
1017: , 'Entity'
1018: );
1019: END IF;

Line 1499: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1495: WHEN OTHERS THEN
1496:
1497: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1498:
1499: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1500: THEN
1501: OE_MSG_PUB.Add_Exc_Msg
1502: ( G_PKG_NAME
1503: , 'Attributes'

Line 1501: OE_MSG_PUB.Add_Exc_Msg

1497: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1498:
1499: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1500: THEN
1501: OE_MSG_PUB.Add_Exc_Msg
1502: ( G_PKG_NAME
1503: , 'Attributes'
1504: );
1505: END IF;

Line 1541: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1537: WHEN OTHERS THEN
1538:
1539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1540:
1541: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1542: THEN
1543: OE_MSG_PUB.Add_Exc_Msg
1544: ( G_PKG_NAME
1545: , 'Entity_Delete'

Line 1543: OE_MSG_PUB.Add_Exc_Msg

1539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1540:
1541: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1542: THEN
1543: OE_MSG_PUB.Add_Exc_Msg
1544: ( G_PKG_NAME
1545: , 'Entity_Delete'
1546: );
1547: END IF;