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_MODIFIERS dependencies on FND_API

Line 17: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

13: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type :=
14: QP_Modifiers_PUB.G_MISS_MODIFIERS_REC
15: )
16: IS
17: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
18: l_organization_id NUMBER;
19: l_context_flag VARCHAR2(1);
20: l_attribute_flag VARCHAR2(1);
21: l_value_flag VARCHAR2(1);

Line 69: l_return_status := FND_API.G_RET_STS_ERROR;

65:
66: IF p_MODIFIERS_rec.list_line_id IS NULL
67: THEN
68:
69: l_return_status := FND_API.G_RET_STS_ERROR;
70:
71: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
72: THEN
73:

Line 91: AND p_old_MODIFIERS_rec.list_line_type_code <> FND_API.G_MISS_CHAR

87: IF p_MODIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE
88: THEN
89:
90: IF p_old_MODIFIERS_rec.list_line_type_code IS NOT NULL
91: AND p_old_MODIFIERS_rec.list_line_type_code <> FND_API.G_MISS_CHAR
92: AND p_old_MODIFIERS_rec.list_line_type_code <> p_MODIFIERS_rec.list_line_type_code
93: THEN
94:
95: l_return_status := FND_API.G_RET_STS_ERROR;

Line 95: l_return_status := FND_API.G_RET_STS_ERROR;

91: AND p_old_MODIFIERS_rec.list_line_type_code <> FND_API.G_MISS_CHAR
92: AND p_old_MODIFIERS_rec.list_line_type_code <> p_MODIFIERS_rec.list_line_type_code
93: THEN
94:
95: l_return_status := FND_API.G_RET_STS_ERROR;
96:
97: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_UPDATE_LIST_LINE_TYP');
98: OE_MSG_PUB.Add;
99:

Line 103: AND p_old_MODIFIERS_rec.modifier_level_code <> FND_API.G_MISS_CHAR

99:
100: END IF;
101:
102: IF p_old_MODIFIERS_rec.modifier_level_code IS NOT NULL
103: AND p_old_MODIFIERS_rec.modifier_level_code <> FND_API.G_MISS_CHAR
104: AND p_old_MODIFIERS_rec.modifier_level_code <> p_MODIFIERS_rec.modifier_level_code
105: THEN
106:
107: l_return_status := FND_API.G_RET_STS_ERROR;

Line 107: l_return_status := FND_API.G_RET_STS_ERROR;

103: AND p_old_MODIFIERS_rec.modifier_level_code <> FND_API.G_MISS_CHAR
104: AND p_old_MODIFIERS_rec.modifier_level_code <> p_MODIFIERS_rec.modifier_level_code
105: THEN
106:
107: l_return_status := FND_API.G_RET_STS_ERROR;
108:
109: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_UPDATE_MOD_LVL');
110: OE_MSG_PUB.Add;
111:

Line 115: AND p_old_MODIFIERS_rec.list_line_no <> FND_API.G_MISS_CHAR

111:
112: END IF;
113:
114: IF p_old_MODIFIERS_rec.list_line_no IS NOT NULL
115: AND p_old_MODIFIERS_rec.list_line_no <> FND_API.G_MISS_CHAR
116: AND p_old_MODIFIERS_rec.list_line_no <> p_MODIFIERS_rec.list_line_no
117: THEN
118:
119: l_return_status := FND_API.G_RET_STS_ERROR;

Line 119: l_return_status := FND_API.G_RET_STS_ERROR;

115: AND p_old_MODIFIERS_rec.list_line_no <> FND_API.G_MISS_CHAR
116: AND p_old_MODIFIERS_rec.list_line_no <> p_MODIFIERS_rec.list_line_no
117: THEN
118:
119: l_return_status := FND_API.G_RET_STS_ERROR;
120:
121: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_UPDATE_LIST_LINE_NO');
122: OE_MSG_PUB.Add;
123:

Line 130: l_return_status := FND_API.G_RET_STS_ERROR;

126: p_old_MODIFIERS_rec.list_line_type_code = 'FREIGHT_CHARGE')
127: AND nvl(p_old_MODIFIERS_rec.proration_type_code,'X') <> nvl(p_MODIFIERS_rec.proration_type_code,'X')
128: THEN
129:
130: l_return_status := FND_API.G_RET_STS_ERROR;
131:
132: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_UPDATE_ATTRIBUTE');
133: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Proration Type Code');
134:

Line 168: l_return_status := FND_API.G_RET_STS_ERROR;

164: IF p_MODIFIERS_rec.list_line_type_code IS NULL
165: THEN
166:
167: oe_debug_pub.add('list line type code manda');
168: l_return_status := FND_API.G_RET_STS_ERROR;
169:
170: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
171: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('LIST_LINE_TYPE_CODE')); -- Fix For Bug-1974413
172: OE_MSG_PUB.Add;

Line 197: l_return_status := FND_API.G_RET_STS_ERROR;

193: THEN
194:
195:
196: oe_debug_pub.add('list line type code invalid');
197: l_return_status := FND_API.G_RET_STS_ERROR;
198:
199: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIST_LINE_TYPE');
200: OE_MSG_PUB.Add;
201:

Line 216: l_return_status := FND_API.G_RET_STS_ERROR;

212: THEN
213:
214:
215: oe_debug_pub.add('list line type code invalid');
216: l_return_status := FND_API.G_RET_STS_ERROR;
217:
218: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIST_LINE_TYPE');
219: OE_MSG_PUB.Add;
220:

Line 231: l_return_status := FND_API.G_RET_STS_ERROR;

227: IF l_gsa_indicator = 'Y'
228: AND p_MODIFIERS_rec.list_line_type_code <> 'DIS'
229: THEN
230:
231: l_return_status := FND_API.G_RET_STS_ERROR;
232:
233: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIST_LINE_TYPE');
234: OE_MSG_PUB.Add;
235:

Line 266: l_return_status := FND_API.G_RET_STS_ERROR;

262: AND p_MODIFIERS_rec.start_date_active IS NOT NULL
263: AND p_MODIFIERS_rec.start_date_active < l_start_date_active
264: THEN
265:
266: l_return_status := FND_API.G_RET_STS_ERROR;
267: FND_MESSAGE.SET_NAME('QP','QP_MOD_DATES_WITHIN_MODLIST');
268: OE_MSG_PUB.Add;
269:
270: END IF;

Line 277: l_return_status := FND_API.G_RET_STS_ERROR;

273: AND p_MODIFIERS_rec.end_date_active IS NOT NULL
274: AND p_MODIFIERS_rec.end_date_active > l_end_date_active
275: THEN
276:
277: l_return_status := FND_API.G_RET_STS_ERROR;
278: FND_MESSAGE.SET_NAME('QP','QP_MOD_DATES_WITHIN_MODLIST');
279: OE_MSG_PUB.Add;
280:
281: END IF;

Line 288: l_return_status := FND_API.G_RET_STS_ERROR;

284: AND p_MODIFIERS_rec.end_date_active IS NOT NULL
285: AND p_MODIFIERS_rec.end_date_active < l_start_date_active
286: THEN
287:
288: l_return_status := FND_API.G_RET_STS_ERROR;
289: FND_MESSAGE.SET_NAME('QP','QP_MOD_DATES_WITHIN_MODLIST');
290: OE_MSG_PUB.Add;
291:
292: END IF;

Line 299: l_return_status := FND_API.G_RET_STS_ERROR;

295: AND p_MODIFIERS_rec.start_date_active IS NOT NULL
296: AND p_MODIFIERS_rec.start_date_active > l_end_date_active
297: THEN
298:
299: l_return_status := FND_API.G_RET_STS_ERROR;
300: FND_MESSAGE.SET_NAME('QP','QP_MOD_DATES_WITHIN_MODLIST');
301: OE_MSG_PUB.Add;
302:
303: END IF;

Line 315: l_return_status := FND_API.G_RET_STS_ERROR;

311: OR (p_MODIFIERS_rec.list_line_type_code = 'FREIGHT_CHARGE'
312: AND l_list_type_code <> 'CHARGES')
313: THEN
314:
315: l_return_status := FND_API.G_RET_STS_ERROR;
316: FND_MESSAGE.SET_NAME('QP','QP_FRT_CHRG_ALLOW_CHRGS');
317: OE_MSG_PUB.Add;
318:
319: END IF;

Line 335: l_return_status := FND_API.G_RET_STS_ERROR;

331: p_MODIFIERS_rec.list_line_no IS NULL AND
332: l_ask_for_flag = 'Y'
333:
334: THEN
335: l_return_status := FND_API.G_RET_STS_ERROR;
336:
337: FND_MESSAGE.SET_NAME('QP','QP_LIST_NO_MAND_IF_ASK_FOR');
338: OE_MSG_PUB.Add;
339:

Line 349: l_return_status := FND_API.G_RET_STS_ERROR;

345: p_MODIFIERS_rec.rltd_modifier_grp_type IS NULL AND
346: p_MODIFIERS_rec.list_line_no IS NULL
347:
348: THEN
349: l_return_status := FND_API.G_RET_STS_ERROR;
350:
351: FND_MESSAGE.SET_NAME('QP','QP_LIST_NO_MAND_FOR_CIE');
352: OE_MSG_PUB.Add;
353:

Line 375: l_return_status := FND_API.G_RET_STS_ERROR;

371: p_MODIFIERS_rec.automatic_flag is NULL
372:
373: THEN
374: oe_debug_pub.add('auto flag mand');
375: l_return_status := FND_API.G_RET_STS_ERROR;
376:
377: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
378: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('AUTOMATIC_FLAG')); -- Fix For Bug-1974413
379: OE_MSG_PUB.Add;

Line 390: l_return_status := FND_API.G_RET_STS_ERROR;

386: AND p_MODIFIERS_rec.automatic_flag <> 'N'
387: THEN
388:
389: oe_debug_pub.add('auto flag invalid');
390: l_return_status := FND_API.G_RET_STS_ERROR;
391:
392: FND_MESSAGE.SET_NAME('QP','QP_AUTO_FLAG_Y_OR_N');
393: OE_MSG_PUB.Add;
394:

Line 404: l_return_status := FND_API.G_RET_STS_ERROR;

400: AND p_MODIFIERS_rec.rltd_modifier_grp_type IS NOT NULL
401: AND p_MODIFIERS_rec.automatic_flag IS NULL
402: THEN
403:
404: l_return_status := FND_API.G_RET_STS_ERROR;
405:
406: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
407: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('AUTOMATIC_FLAG')); -- Fix For Bug-1974413
408: OE_MSG_PUB.Add;

Line 423: l_return_status := FND_API.G_RET_STS_ERROR;

419: p_MODIFIERS_rec.automatic_flag <> 'Y'
420:
421: THEN
422:
423: l_return_status := FND_API.G_RET_STS_ERROR;
424:
425: FND_MESSAGE.SET_NAME('QP','QP_AUTO_FLAG_MUST_BE_Y');
426: OE_MSG_PUB.Add;
427:

Line 441: l_return_status := FND_API.G_RET_STS_ERROR;

437: p_MODIFIERS_rec.automatic_flag = 'N' )
438:
439: THEN
440:
441: l_return_status := FND_API.G_RET_STS_ERROR;
442:
443: FND_MESSAGE.SET_NAME('QP','QP_DIS_SUR_FREIGHT_MANUAL');
444: OE_MSG_PUB.Add;
445:

Line 462: l_return_status := FND_API.G_RET_STS_ERROR;

458: IF p_MODIFIERS_rec.modifier_level_code IS NULL
459: THEN
460:
461: oe_debug_pub.add('modifier level manda');
462: l_return_status := FND_API.G_RET_STS_ERROR;
463:
464: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
465: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('MODIFIER_LEVEL_CODE')); --Fix For Bug-1974413
466: OE_MSG_PUB.Add;

Line 477: l_return_status := FND_API.G_RET_STS_ERROR;

473: --added on request by jholla due to invoicing problems in OM for orde
474: --level modifiers
475: /* Bug 1957062 Check Bypassed for Basic Pricing */
476:
477: l_return_status := FND_API.G_RET_STS_ERROR;
478: FND_MESSAGE.SET_NAME('QP','QP_ORD_LVL_NULL_BUCKET');
479: OE_MSG_PUB.Add;
480:
481:

Line 490: l_return_status := FND_API.G_RET_STS_ERROR;

486: p_MODIFIERS_rec.modifier_level_code <> 'LINEGROUP' )
487: THEN
488:
489: oe_debug_pub.add('modifier level invalid');
490: l_return_status := FND_API.G_RET_STS_ERROR;
491:
492: FND_MESSAGE.SET_NAME('QP','QP_MOD_LVL_LN_LNGRP_OR_ORD');
493: OE_MSG_PUB.Add;
494:

Line 505: l_return_status := FND_API.G_RET_STS_ERROR;

501: AND p_MODIFIERS_rec.modifier_level_code <> 'LINE'
502: AND p_MODIFIERS_rec.modifier_level_code <> 'ORDER'
503: THEN
504:
505: l_return_status := FND_API.G_RET_STS_ERROR;
506:
507: FND_MESSAGE.SET_NAME('QP','QP_MOD_LVL_LN_OR_ORD');
508: OE_MSG_PUB.Add;
509:

Line 520: l_return_status := FND_API.G_RET_STS_ERROR;

516: AND p_MODIFIERS_rec.modifier_level_code <> 'LINE'
517: AND p_MODIFIERS_rec.modifier_level_code <> 'LINEGROUP'
518: THEN
519:
520: l_return_status := FND_API.G_RET_STS_ERROR;
521:
522: IF QP_UTIL.get_qp_status = 'I' THEN
523: FND_MESSAGE.SET_NAME('QP','QP_MOD_LVL_LN_OR_LNGRP');
524: ELSE

Line 537: l_return_status := FND_API.G_RET_STS_ERROR;

533: IF p_MODIFIERS_rec.list_line_type_code = 'IUE'
534: AND p_MODIFIERS_rec.modifier_level_code <> 'LINE'
535: THEN
536:
537: l_return_status := FND_API.G_RET_STS_ERROR;
538:
539: FND_MESSAGE.SET_NAME('QP','QP_MOD_LVL_LN');
540: OE_MSG_PUB.Add;
541:

Line 550: l_return_status := FND_API.G_RET_STS_ERROR;

546: IF l_gsa_indicator = 'Y'
547: AND p_MODIFIERS_rec.modifier_level_code <> 'LINE'
548: THEN
549:
550: l_return_status := FND_API.G_RET_STS_ERROR;
551:
552: FND_MESSAGE.SET_NAME('QP','QP_MOD_LVL_LN');
553: OE_MSG_PUB.Add;
554:

Line 569: l_return_status := FND_API.G_RET_STS_ERROR;

565: p_MODIFIERS_rec.price_by_formula_id IS NULL
566: THEN
567:
568: oe_debug_pub.add('arith op mand');
569: l_return_status := FND_API.G_RET_STS_ERROR;
570:
571: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
572: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRICE_BY_FORMULA_ID')); -- Fix For Bug-1974413
573: OE_MSG_PUB.Add;

Line 589: l_return_status := FND_API.G_RET_STS_ERROR;

585: p_MODIFIERS_rec.arithmetic_operator IS NULL
586: THEN
587:
588: oe_debug_pub.add('arith op mand');
589: l_return_status := FND_API.G_RET_STS_ERROR;
590:
591: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
592: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('ARITHMETIC_OPERATOR')); -- Fix For Bug-1974413
593: OE_MSG_PUB.Add;

Line 612: l_return_status := FND_API.G_RET_STS_ERROR;

608: p_MODIFIERS_rec.arithmetic_operator IS NULL
609: THEN
610:
611: oe_debug_pub.add('arith op mand');
612: l_return_status := FND_API.G_RET_STS_ERROR;
613:
614: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
615: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('ARITHMETIC_OPERATOR')); -- Fix For Bug-1974413
616: OE_MSG_PUB.Add;

Line 628: l_return_status := FND_API.G_RET_STS_ERROR;

624: p_MODIFIERS_rec.arithmetic_operator <> 'LUMPSUM'
625: THEN
626:
627: oe_debug_pub.add('arith op mand');
628: l_return_status := FND_API.G_RET_STS_ERROR;
629:
630: FND_MESSAGE.SET_NAME('QP','QP_LUMPSUM_FOR_ORDER');
631: OE_MSG_PUB.Add;
632:

Line 644: l_return_status := FND_API.G_RET_STS_ERROR;

640: p_MODIFIERS_rec.arithmetic_operator <> 'LUMPSUM' AND
641: p_MODIFIERS_rec.arithmetic_operator <> 'AMT' )
642: THEN
643:
644: l_return_status := FND_API.G_RET_STS_ERROR;
645:
646: FND_MESSAGE.SET_NAME('QP','QP_DIS_PERCNT_OR_AMT');
647: OE_MSG_PUB.Add;
648:

Line 659: l_return_status := FND_API.G_RET_STS_ERROR;

655: p_MODIFIERS_rec.arithmetic_operator <> '%'
656: THEN
657:
658: oe_debug_pub.add('arith op mand');
659: l_return_status := FND_API.G_RET_STS_ERROR;
660:
661: FND_MESSAGE.SET_NAME('QP','QP_PERCENT_FOR_ORDER');
662: OE_MSG_PUB.Add;
663:

Line 682: l_return_status := FND_API.G_RET_STS_ERROR;

678: p_MODIFIERS_rec.price_by_formula_id IS NULL
679: THEN
680:
681: oe_debug_pub.add('arith op mand');
682: l_return_status := FND_API.G_RET_STS_ERROR;
683:
684: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
685: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRICE_BY_FORMULA_ID')); -- Fix For Bug-1974413
686: OE_MSG_PUB.Add;

Line 697: l_return_status := FND_API.G_RET_STS_ERROR;

693: IF l_gsa_indicator = 'Y'
694: AND p_MODIFIERS_rec.arithmetic_operator <> 'NEWPRICE'
695: THEN
696:
697: l_return_status := FND_API.G_RET_STS_ERROR;
698:
699: FND_MESSAGE.SET_NAME('QP','QP_GSA_NEWPRICE_ONLY');
700: OE_MSG_PUB.Add;
701:

Line 716: l_return_status := FND_API.G_RET_STS_ERROR;

712: p_MODIFIERS_rec.arithmetic_operator <> 'LUMPSUM' )
713: THEN
714:
715: oe_debug_pub.add('arith op invalid');
716: l_return_status := FND_API.G_RET_STS_ERROR;
717:
718: FND_MESSAGE.SET_NAME('QP','QP_DIS_PERCNT_AMT_OR_NEWPRICE');
719: OE_MSG_PUB.Add;
720:

Line 745: l_return_status := FND_API.G_RET_STS_ERROR;

741: THEN
742:
743:
744: oe_debug_pub.add('list line type code invalid');
745: l_return_status := FND_API.G_RET_STS_ERROR;
746:
747: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
748: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('OVERRIDE_FLAG')); -- Fix For Bug-1974413
749: OE_MSG_PUB.Add;

Line 761: l_return_status := FND_API.G_RET_STS_ERROR;

757: p_MODIFIERS_rec.override_flag <> 'N' )
758: THEN
759:
760: oe_debug_pub.add('override flag invalid');
761: l_return_status := FND_API.G_RET_STS_ERROR;
762:
763: FND_MESSAGE.SET_NAME('QP','QP_OVERRIDE_FLAG_Y_OR_N');
764: OE_MSG_PUB.Add;
765:

Line 775: l_return_status := FND_API.G_RET_STS_ERROR;

771: AND p_MODIFIERS_rec.rltd_modifier_grp_type IS NOT NULL
772: AND p_MODIFIERS_rec.override_flag IS NULL
773: THEN
774:
775: l_return_status := FND_API.G_RET_STS_ERROR;
776:
777: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
778: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('OVERRIDE_FLAG')); -- Fix For Bug-1974413
779: OE_MSG_PUB.Add;

Line 794: l_return_status := FND_API.G_RET_STS_ERROR;

790: p_MODIFIERS_rec.override_flag <> 'N'
791:
792: THEN
793:
794: l_return_status := FND_API.G_RET_STS_ERROR;
795:
796: FND_MESSAGE.SET_NAME('QP','QP_OVERRIDE_FLAG_MUST_BE_N');
797: OE_MSG_PUB.Add;
798:

Line 822: l_return_status := FND_API.G_RET_STS_ERROR;

818: THEN
819:
820:
821: oe_debug_pub.add('list line type code invalid');
822: l_return_status := FND_API.G_RET_STS_ERROR;
823:
824: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
825: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRINT_ON_INVOICE_FLAG')); -- Fix For Bug-1974413
826: OE_MSG_PUB.Add;

Line 838: l_return_status := FND_API.G_RET_STS_ERROR;

834: p_MODIFIERS_rec.print_on_invoice_flag <> 'N' )
835: THEN
836:
837: oe_debug_pub.add('print flag invalid');
838: l_return_status := FND_API.G_RET_STS_ERROR;
839:
840: FND_MESSAGE.SET_NAME('QP','QP_PRNT_INV_FLAG_Y_OR_N');
841: OE_MSG_PUB.Add;
842:

Line 859: l_return_status := FND_API.G_RET_STS_ERROR;

855: nvl( p_MODIFIERS_rec.end_date_active,to_date('12/31/9999','mm/dd/yyyy'))
856: THEN
857:
858: oe_debug_pub.add('start date after end date');
859: l_return_status := FND_API.G_RET_STS_ERROR;
860:
861: FND_MESSAGE.SET_NAME('QP','QP_STRT_DATE_BFR_END_DATE');
862: OE_MSG_PUB.Add;
863:

Line 879: l_return_status := FND_API.G_RET_STS_ERROR;

875: OR p_MODIFIERS_rec.substitution_value IS NULL
876: THEN
877:
878: oe_debug_pub.add('sub con, attr, value mand');
879: l_return_status := FND_API.G_RET_STS_ERROR;
880:
881: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
882: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Terms Attr and Terms Value');
883: OE_MSG_PUB.Add;

Line 911: l_return_status := FND_API.G_RET_STS_ERROR;

907: oe_debug_pub.add('error code = '||to_char(l_error_code));
908:
909: If (l_context_flag = 'N' AND l_error_code = 7) -- invalid context
910: Then
911: l_return_status := FND_API.G_RET_STS_ERROR;
912:
913: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
914: THEN
915:

Line 924: l_return_status := FND_API.G_RET_STS_ERROR;

920: End If;
921:
922: If (l_attribute_flag = 'N' AND l_error_code = 8) -- invalid attribute
923: Then
924: l_return_status := FND_API.G_RET_STS_ERROR;
925:
926: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
927: THEN
928:

Line 937: l_return_status := FND_API.G_RET_STS_ERROR;

933: End If;
934:
935: If (l_value_flag = 'N' AND l_error_code = 9) -- invalid value
936: Then
937: l_return_status := FND_API.G_RET_STS_ERROR;
938:
939: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
940: THEN
941:

Line 969: l_return_status := FND_API.G_RET_STS_ERROR;

965: OR p_MODIFIERS_rec.relationship_type_id IS NULL
966: THEN
967:
968: oe_debug_pub.add('itm , org, related item and rrelationship type manda');
969: l_return_status := FND_API.G_RET_STS_ERROR;
970:
971: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
972: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Prod Attr Value and Upgrade Item');
973: OE_MSG_PUB.Add;

Line 993: l_return_status := FND_API.G_RET_STS_ERROR;

989: EXCEPTION
990: WHEN NO_DATA_FOUND THEN
991: oe_debug_pub.add('item upgrade data is invalid');
992:
993: l_return_status := FND_API.G_RET_STS_ERROR;
994:
995: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ITEM_UPGRD');
996: OE_MSG_PUB.Add;
997:

Line 1021: l_return_status := FND_API.G_RET_STS_ERROR;

1017: IF p_MODIFIERS_rec.modifier_level_code IN ('ORDER', 'LINE')
1018: AND p_MODIFIERS_rec.list_line_type_code NOT IN ('DIS', 'SUR', 'FREIGHT_CHARGE') THEN
1019:
1020: --dbms_output.put_line('formula id is applicable with DIS,SUR ');
1021: l_return_status := FND_API.G_RET_STS_ERROR;
1022:
1023: FND_MESSAGE.SET_NAME('QP','QP_DIS_SUR_OR_FRT_FOR_FORMULA');
1024: OE_MSG_PUB.Add;
1025:

Line 1035: l_return_status := FND_API.G_RET_STS_ERROR;

1031: OR l_primary_list_line_type_code = 'PRG')
1032: AND p_MODIFIERS_rec.rltd_modifier_grp_type = 'BENEFIT')
1033: THEN
1034:
1035: l_return_status := FND_API.G_RET_STS_ERROR;
1036:
1037: FND_MESSAGE.SET_NAME('QP','QP_FORMULA_NOT_IN_GET');
1038: OE_MSG_PUB.Add;
1039:

Line 1057: l_return_status := FND_API.G_RET_STS_ERROR;

1053: THEN
1054:
1055: --dbms_output.put_line('arith op can be % or AMT with formula');
1056: oe_debug_pub.add('arith oper % or AMT invalid');
1057: l_return_status := FND_API.G_RET_STS_ERROR;
1058:
1059: FND_MESSAGE.SET_NAME('QP','QP_DIS_PERCNT_OR_AMT');
1060: OE_MSG_PUB.Add;
1061:

Line 1087: l_return_status := FND_API.G_RET_STS_ERROR;

1083: WHEN NO_DATA_FOUND THEN
1084: --dbms_output.put_line('invalid formula id');
1085: oe_debug_pub.add('formula id is invalid');
1086:
1087: l_return_status := FND_API.G_RET_STS_ERROR;
1088:
1089: FND_MESSAGE.SET_NAME('QP','QP_FORMULA_NOT_FOUND');
1090: OE_MSG_PUB.Add;
1091:

Line 1103: l_return_status := FND_API.G_RET_STS_ERROR;

1099: AND p_MODIFIERS_rec.operand IS NOT NULL
1100: THEN
1101:
1102: --dbms_output.put_line('no operand if formula is given = '|| to_char(p_MODIFIERS_rec.operand));
1103: l_return_status := FND_API.G_RET_STS_ERROR;
1104:
1105: FND_MESSAGE.SET_NAME('QP','QP_OPERAND_OR_FORMULA');
1106: OE_MSG_PUB.Add;
1107: END IF;

Line 1122: l_return_status := FND_API.G_RET_STS_ERROR;

1118: IF p_MODIFIERS_rec.price_break_type_code IS NULL
1119: THEN
1120:
1121: oe_debug_pub.add('price brek type is manda');
1122: l_return_status := FND_API.G_RET_STS_ERROR;
1123:
1124: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
1125: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRICE_BREAK_TYPE_CODE')); --Fix For Bug-1974413
1126: OE_MSG_PUB.Add;

Line 1143: l_return_status := FND_API.G_RET_STS_ERROR;

1139: AND p_MODIFIERS_rec.price_break_type_code <> 'RECURRING'
1140: THEN
1141:
1142: oe_debug_pub.add('price brek type can be point or range');
1143: l_return_status := FND_API.G_RET_STS_ERROR;
1144:
1145: FND_MESSAGE.SET_NAME('QP','QP_PRCBRK_POINT_OR_RANGE');
1146: OE_MSG_PUB.Add;
1147:

Line 1162: l_return_status := FND_API.G_RET_STS_ERROR;

1158: p_MODIFIERS_rec.price_break_type_code = 'RECURRING'
1159:
1160: THEN
1161:
1162: l_return_status := FND_API.G_RET_STS_ERROR;
1163:
1164: FND_MESSAGE.SET_NAME('QP','QP_RECURRING_NOT_ALLOWED');
1165: OE_MSG_PUB.Add;
1166:

Line 1180: l_return_status := FND_API.G_RET_STS_ERROR;

1176: p_MODIFIERS_rec.arithmetic_operator <> 'LUMPSUM'
1177:
1178: THEN
1179:
1180: l_return_status := FND_API.G_RET_STS_ERROR;
1181:
1182: FND_MESSAGE.SET_NAME('QP','QP_LUMPSUM_RECUR_DIS_SUR');
1183: OE_MSG_PUB.Add;
1184:

Line 1198: l_return_status := FND_API.G_RET_STS_ERROR;

1194: p_MODIFIERS_rec.price_break_type_code <> 'RECURRING'
1195:
1196: THEN
1197:
1198: l_return_status := FND_API.G_RET_STS_ERROR;
1199:
1200: FND_MESSAGE.SET_NAME('QP','QP_BREAK_TYPE_POINT_OR_RECUR');
1201: OE_MSG_PUB.Add;
1202:

Line 1216: l_return_status := FND_API.G_RET_STS_ERROR;

1212: p_MODIFIERS_rec.price_break_type_code <> 'RANGE'
1213:
1214: THEN
1215:
1216: l_return_status := FND_API.G_RET_STS_ERROR;
1217:
1218: FND_MESSAGE.SET_NAME('QP','QP_BREAK_TYPE_POINT_OR_RANGE');
1219: OE_MSG_PUB.Add;
1220:

Line 1234: l_return_status := FND_API.G_RET_STS_ERROR;

1230: p_MODIFIERS_rec.price_break_type_code = 'RECURRING'
1231:
1232: THEN
1233:
1234: l_return_status := FND_API.G_RET_STS_ERROR;
1235:
1236: FND_MESSAGE.SET_NAME('QP','QP_RECURRING_NOT_ALLOWED');
1237: OE_MSG_PUB.Add;
1238:

Line 1260: l_return_status := FND_API.G_RET_STS_ERROR;

1256: THEN
1257:
1258: oe_debug_pub.add('prece 11 ');
1259: --dbms_output.put_line('product precedence is mandatory for primary');
1260: l_return_status := FND_API.G_RET_STS_ERROR;
1261:
1262: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
1263: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRODUCT_PRECEDENCE')); -- Fix For Bug-1974413
1264: OE_MSG_PUB.Add;

Line 1282: l_return_status := FND_API.G_RET_STS_ERROR;

1278: AND l_primary_list_line_type_code = 'PRG'
1279: AND p_MODIFIERS_rec.benefit_price_list_line_id IS NULL
1280: THEN
1281:
1282: l_return_status := FND_API.G_RET_STS_ERROR;
1283:
1284: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
1285: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Get Price');
1286: OE_MSG_PUB.Add;

Line 1309: l_return_status := FND_API.G_RET_STS_ERROR;

1305: -- service project
1306: IF l_list_line_type_code = 'PBH' OR
1307: (l_list_line_type_code <> 'PBH' AND l_qualification_ind NOT IN (2,4,6,8,10,12,14,20,22,28,30))
1308: THEN
1309: l_return_status := FND_API.G_RET_STS_ERROR;
1310: FND_MESSAGE.SET_NAME('QP','QP_INVALID_GET_PRICE_LIST_LINE');
1311: OE_MSG_PUB.Add;
1312: END IF;
1313:

Line 1338: l_return_status := FND_API.G_RET_STS_ERROR;

1334: OR p_MODIFIERS_rec.expiration_period_uom IS NOT NULL
1335: THEN
1336:
1337: --dbms_output.put_line('either exp date or other 2 values');
1338: l_return_status := FND_API.G_RET_STS_ERROR;
1339:
1340: FND_MESSAGE.SET_NAME('QP','QP_EXP_DATE_OR_EXP_PERIODS');
1341: OE_MSG_PUB.Add;
1342:

Line 1356: l_return_status := FND_API.G_RET_STS_ERROR;

1352: AND p_MODIFIERS_rec.expiration_period_uom IS NOT NULL ))
1353: THEN
1354:
1355: --dbms_output.put_line('all these 3 values are mandatory');
1356: l_return_status := FND_API.G_RET_STS_ERROR;
1357:
1358: FND_MESSAGE.SET_NAME('QP','QP_EXP_UOM_NUM_STRTDT_MAND');
1359: OE_MSG_PUB.Add;
1360:

Line 1379: l_return_status := FND_API.G_RET_STS_ERROR;

1375:
1376: EXCEPTION
1377: WHEN NO_DATA_FOUND THEN
1378: --dbms_output.put_line('invalid exp uom');
1379: l_return_status := FND_API.G_RET_STS_ERROR;
1380:
1381: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PERIOD_UOM');
1382: OE_MSG_PUB.Add;
1383:

Line 1403: l_return_status := FND_API.G_RET_STS_ERROR;

1399:
1400: THEN
1401:
1402: --dbms_output.put_line('estim gl value only for coupons');
1403: l_return_status := FND_API.G_RET_STS_ERROR;
1404:
1405: FND_MESSAGE.SET_NAME('QP','QP_GL_VAL_FOR_CIE_IUE_TSN');
1406: OE_MSG_PUB.Add;
1407:

Line 1420: l_return_status := FND_API.G_RET_STS_ERROR;

1416:
1417: THEN
1418:
1419: --dbms_output.put_line('estim accrual rate is mand for coupons or accrual');
1420: l_return_status := FND_API.G_RET_STS_ERROR;
1421:
1422: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
1423: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('ESTIM_ACCRUAL_RATE')); -- Fix For Bug-1974413
1424: OE_MSG_PUB.Add;

Line 1437: l_return_status := FND_API.G_RET_STS_ERROR;

1433: IF p_MODIFIERS_rec.charge_type_code IS NULL
1434: THEN
1435:
1436: --dbms_output.put_line('charge tyep and subtype mand for freight charge');
1437: l_return_status := FND_API.G_RET_STS_ERROR;
1438:
1439: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
1440: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Charge Name');
1441: OE_MSG_PUB.Add;

Line 1484: l_return_status := FND_API.G_RET_STS_ERROR;

1480:
1481: EXCEPTION
1482: WHEN NO_DATA_FOUND THEN
1483: --dbms_output.put_line('invalid charge and subcharge type');
1484: l_return_status := FND_API.G_RET_STS_ERROR;
1485:
1486: FND_MESSAGE.SET_NAME('QP','QP_INVALID_CHARGE_TYPE_SUBTYPE');
1487: OE_MSG_PUB.Add;
1488:

Line 1508: l_return_status := FND_API.G_RET_STS_ERROR;

1504:
1505: THEN
1506:
1507: --dbms_output.put_line('accru conv rate mand');
1508: l_return_status := FND_API.G_RET_STS_ERROR;
1509:
1510: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
1511: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('ACCRUAL_CONVERSION_RATE')); -- Fix For Bug-1974413
1512: OE_MSG_PUB.Add;

Line 1535: l_return_status := FND_API.G_RET_STS_ERROR;

1531: OR (p_MODIFIERS_rec.benefit_uom_code IS NULL
1532: AND p_MODIFIERS_rec.benefit_qty IS NOT NULL )
1533: THEN
1534:
1535: l_return_status := FND_API.G_RET_STS_ERROR;
1536:
1537: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
1538: --FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('BENEFIT_QTY')||'/'||
1539: -- QP_PRC_UTIL.Get_Attribute_Name('BENEFIT_UOM_CODE')); -- Fix For Bug-1974413

Line 1555: l_return_status := FND_API.G_RET_STS_ERROR;

1551: AND (p_MODIFIERS_rec.benefit_qty IS NULL
1552: OR p_MODIFIERS_rec.benefit_uom_code IS NULL )
1553: THEN
1554:
1555: l_return_status := FND_API.G_RET_STS_ERROR;
1556:
1557: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
1558: --FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('BENEFIT_QTY')||'/'||
1559: -- QP_PRC_UTIL.Get_Attribute_Name('BENEFIT_UOM_CODE')); -- Fix For Bug-1974413

Line 1579: l_return_status := FND_API.G_RET_STS_ERROR;

1575: OR (p_MODIFIERS_rec.benefit_uom_code IS NULL
1576: AND p_MODIFIERS_rec.benefit_qty IS NOT NULL )
1577: THEN
1578:
1579: l_return_status := FND_API.G_RET_STS_ERROR;
1580:
1581: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
1582: --FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('BENEFIT_QTY')||'/'||
1583: -- QP_PRC_UTIL.Get_Attribute_Name('BENEFIT_UOM_CODE')); -- Fix For Bug-1974413

Line 1613: l_return_status := FND_API.G_RET_STS_ERROR;

1609:
1610: EXCEPTION
1611: WHEN NO_DATA_FOUND THEN
1612: --dbms_output.put_line('invalid bene uom');
1613: l_return_status := FND_API.G_RET_STS_ERROR;
1614:
1615: FND_MESSAGE.SET_NAME('QP','QP_INVALID_BENEFIT_UOM');
1616: OE_MSG_PUB.Add;
1617:

Line 1634: l_return_status := FND_API.G_RET_STS_ERROR;

1630:
1631: EXCEPTION
1632: WHEN NO_DATA_FOUND THEN
1633: --dbms_output.put_line('invalid bene uom');
1634: l_return_status := FND_API.G_RET_STS_ERROR;
1635:
1636: FND_MESSAGE.SET_NAME('QP','QP_INVALID_BENEFIT_UOM');
1637: OE_MSG_PUB.Add;
1638:

Line 1669: l_return_status := FND_API.G_RET_STS_ERROR;

1665: p_MODIFIERS_rec.pricing_phase_id IS NULL
1666: THEN
1667:
1668: --dbms_output.put_line('phase is mand');
1669: l_return_status := FND_API.G_RET_STS_ERROR;
1670:
1671: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
1672: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Phase');
1673: OE_MSG_PUB.Add;

Line 1686: l_return_status := FND_API.G_RET_STS_ERROR;

1682: AND p_MODIFIERS_rec.pricing_phase_id IS NULL
1683: THEN
1684:
1685: --dbms_output.put_line('phase is mand');
1686: l_return_status := FND_API.G_RET_STS_ERROR;
1687:
1688: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
1689: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Phase');
1690: OE_MSG_PUB.Add;

Line 1713: l_return_status := FND_API.G_RET_STS_ERROR;

1709: AND PRICING_PHASE_ID = p_MODIFIERS_rec.pricing_phase_id;
1710:
1711: EXCEPTION
1712: WHEN NO_DATA_FOUND THEN
1713: l_return_status := FND_API.G_RET_STS_ERROR;
1714:
1715: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PHASE');
1716: OE_MSG_PUB.Add;
1717:

Line 1733: l_return_status := FND_API.G_RET_STS_ERROR;

1729: WHERE PRICING_PHASE_ID = p_MODIFIERS_rec.pricing_phase_id
1730: AND nvl(MODIFIER_LEVEL_CODE, '*') <> 'LINE';
1731: EXCEPTION
1732: WHEN NO_DATA_FOUND THEN */
1733: l_return_status := FND_API.G_RET_STS_ERROR;
1734: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PHASE_RLTD');
1735: OE_MSG_PUB.Add;
1736: -- END;
1737: END IF;

Line 1755: l_return_status := FND_API.G_RET_STS_ERROR;

1751: WHEN NO_DATA_FOUND THEN
1752: l_rltd_exist := 'N';
1753: END;
1754: IF l_rltd_exist = 'Y' THEN
1755: l_return_status := FND_API.G_RET_STS_ERROR;
1756: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PHASE_RLTD');
1757: OE_MSG_PUB.Add;
1758: END IF;
1759: END IF;

Line 1775: l_return_status := FND_API.G_RET_STS_ERROR;

1771: NULL;
1772: end;
1773:
1774: IF l_phase_price_evt = 'Y' THEN
1775: l_return_status := FND_API.G_RET_STS_ERROR;
1776:
1777: FND_MESSAGE.SET_NAME('QP','QP_PHASE_PRICE_EVT_ERROR');
1778: OE_MSG_PUB.Add;
1779:

Line 1797: l_return_status := FND_API.G_RET_STS_ERROR;

1793: NULL;
1794: end;
1795:
1796: IF l_phase_freeze_set = 'Y' THEN
1797: l_return_status := FND_API.G_RET_STS_ERROR;
1798:
1799: FND_MESSAGE.SET_NAME('QP','QP_PHASE_FREEZE_ERROR');
1800: OE_MSG_PUB.Add;
1801:

Line 1811: l_return_status := FND_API.G_RET_STS_ERROR;

1807: IF l_gsa_indicator = 'Y'
1808: AND l_phase_sequence <> 10
1809: THEN
1810:
1811: l_return_status := FND_API.G_RET_STS_ERROR;
1812:
1813: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PHASE');
1814: OE_MSG_PUB.Add;
1815:

Line 1840: l_return_status := FND_API.G_RET_STS_ERROR;

1836: THEN
1837:
1838:
1839: oe_debug_pub.add('list line type code invalid');
1840: l_return_status := FND_API.G_RET_STS_ERROR;
1841:
1842: FND_MESSAGE.SET_NAME('QP','QP_ACCRUALS_NOT_ALLOWED');
1843: OE_MSG_PUB.Add;
1844:

Line 1853: l_return_status := FND_API.G_RET_STS_ERROR;

1849: IF l_gsa_indicator = 'Y'
1850: AND p_MODIFIERS_rec.accrual_flag = 'Y'
1851: THEN
1852:
1853: l_return_status := FND_API.G_RET_STS_ERROR;
1854:
1855: FND_MESSAGE.SET_NAME('QP','QP_ACCRUALS_NOT_ALLOWED');
1856: OE_MSG_PUB.Add;
1857:

Line 1867: l_return_status := FND_API.G_RET_STS_ERROR;

1863: AND p_MODIFIERS_rec.accrual_flag <> 'Y'
1864:
1865: THEN
1866:
1867: l_return_status := FND_API.G_RET_STS_ERROR;
1868:
1869: FND_MESSAGE.SET_NAME('QP','QP_ACCRUALS_MAND_FOR_CIE');
1870: OE_MSG_PUB.Add;
1871:

Line 1891: l_return_status := FND_API.G_RET_STS_ERROR;

1887: OR p_MODIFIERS_rec.accrual_conversion_rate IS NOT NULL )
1888: AND p_MODIFIERS_rec.accrual_flag = 'N')
1889: THEN
1890:
1891: l_return_status := FND_API.G_RET_STS_ERROR;
1892:
1893: FND_MESSAGE.SET_NAME('QP','QP_ACCRUAL_COLUMNS');
1894: OE_MSG_PUB.Add;
1895:

Line 1909: l_return_status := FND_API.G_RET_STS_ERROR;

1905:
1906: THEN
1907:
1908: oe_debug_pub.add('list line type code invalid');
1909: l_return_status := FND_API.G_RET_STS_ERROR;
1910:
1911: FND_MESSAGE.SET_NAME('QP','QP_ACCRUALS_FOR_DIS_ONLY');
1912:
1913: OE_MSG_PUB.Add;

Line 1930: l_return_status := FND_API.G_RET_STS_ERROR;

1926: THEN
1927:
1928:
1929: oe_debug_pub.add('proration 11111');
1930: l_return_status := FND_API.G_RET_STS_ERROR;
1931:
1932: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
1933: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRORATION_TYPE_CODE')); -- Fix For Bug-1974413
1934: OE_MSG_PUB.Add;

Line 1944: l_return_status := FND_API.G_RET_STS_ERROR;

1940: IF l_gsa_indicator = 'Y'
1941: AND p_MODIFIERS_rec.proration_type_code <> 'N'
1942: THEN
1943:
1944: l_return_status := FND_API.G_RET_STS_ERROR;
1945:
1946: FND_MESSAGE.SET_NAME('QP','QP_GSA_PRORATION_ALWAYS_N');
1947: OE_MSG_PUB.Add;
1948:

Line 1960: l_return_status := FND_API.G_RET_STS_ERROR;

1956: THEN
1957:
1958:
1959: oe_debug_pub.add('list line type code invalid');
1960: l_return_status := FND_API.G_RET_STS_ERROR;
1961:
1962: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
1963: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRORATION_TYPE_CODE')); -- Fix For Bug-1974413
1964: OE_MSG_PUB.Add;

Line 1978: l_return_status := FND_API.G_RET_STS_ERROR;

1974: AND p_MODIFIERS_rec.proration_type_code IS NULL
1975: THEN
1976:
1977: oe_debug_pub.add('proration 22222');
1978: l_return_status := FND_API.G_RET_STS_ERROR;
1979:
1980: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
1981: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRORATION_TYPE_CODE')); -- Fix For Bug-1974413
1982: OE_MSG_PUB.Add;

Line 1995: l_return_status := FND_API.G_RET_STS_ERROR;

1991: AND p_MODIFIERS_rec.rltd_modifier_grp_type IS NOT NULL
1992: AND p_MODIFIERS_rec.proration_type_code IS NULL
1993: THEN
1994:
1995: l_return_status := FND_API.G_RET_STS_ERROR;
1996:
1997: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
1998: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRORATION_TYPE_CODE')); -- Fix For Bug-1974413
1999: OE_MSG_PUB.Add;

Line 2010: l_return_status := FND_API.G_RET_STS_ERROR;

2006: AND p_MODIFIERS_rec.list_line_type_code <> 'DIS'
2007: AND p_MODIFIERS_rec.list_line_type_code <> 'PRG'
2008: THEN
2009:
2010: l_return_status := FND_API.G_RET_STS_ERROR;
2011:
2012: FND_MESSAGE.SET_NAME('QP','QP_CIE_CHILD_DIS_OR_PRG');
2013: OE_MSG_PUB.Add;
2014:

Line 2028: l_return_status := FND_API.G_RET_STS_ERROR;

2024: AND p_MODIFIERS_rec.list_line_type_code <> 'DIS'
2025: AND p_MODIFIERS_rec.list_line_type_code <> 'SUR'
2026: THEN
2027:
2028: l_return_status := FND_API.G_RET_STS_ERROR;
2029:
2030: FND_MESSAGE.SET_NAME('QP','QP_PBH_CHILD_DIS_OR_SUR');
2031: OE_MSG_PUB.Add;
2032:

Line 2050: l_return_status := FND_API.G_RET_STS_ERROR;

2046: p_MODIFIERS_rec.automatic_flag = 'Y' AND
2047: p_MODIFIERS_rec.pricing_group_sequence IS NULL
2048: THEN
2049:
2050: l_return_status := FND_API.G_RET_STS_ERROR;
2051:
2052: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
2053: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Bucket');
2054: OE_MSG_PUB.Add;

Line 2065: l_return_status := FND_API.G_RET_STS_ERROR;

2061: IF l_gsa_indicator = 'Y'
2062: AND p_MODIFIERS_rec.pricing_group_sequence <> 1
2063: THEN
2064:
2065: l_return_status := FND_API.G_RET_STS_ERROR;
2066:
2067: FND_MESSAGE.SET_NAME('QP','QP_GSA_BUCKET_VALUE_1');
2068: OE_MSG_PUB.Add;
2069:

Line 2083: l_return_status := FND_API.G_RET_STS_ERROR;

2079: AND p_MODIFIERS_rec.pricing_group_sequence IS NULL
2080: THEN
2081:
2082: --dbms_output.put_line('phase is mand');
2083: l_return_status := FND_API.G_RET_STS_ERROR;
2084:
2085: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
2086: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Bucket');
2087: OE_MSG_PUB.Add;

Line 2105: l_return_status := FND_API.G_RET_STS_ERROR;

2101: fnd_profile.value ('QP_MANUAL_MODIFIER_BUCKET') <> 'Y'
2102: )
2103: THEN
2104:
2105: l_return_status := FND_API.G_RET_STS_ERROR;
2106:
2107: FND_MESSAGE.SET_NAME('QP','QP_MANUAL_DIS_BUCKET_NULL');
2108: OE_MSG_PUB.Add;
2109:

Line 2120: l_return_status := FND_API.G_RET_STS_ERROR;

2116: AND p_MODIFIERS_rec.incompatibility_grp_code IS NOT NULL
2117: AND p_MODIFIERS_rec.incompatibility_grp_code <> 'LVL 1'
2118: THEN
2119:
2120: l_return_status := FND_API.G_RET_STS_ERROR;
2121:
2122: FND_MESSAGE.SET_NAME('QP','QP_GSA_INCOMP_ALWAYS_LVL1');
2123: OE_MSG_PUB.Add;
2124:

Line 2132: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2128: oe_debug_pub.add('here10');
2129: END IF; -- If list_line_type_code <> 'PMR'
2130: -- Return Error if a required attribute is missing.
2131:
2132: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2133:
2134: oe_debug_pub.add('before raise');
2135: RAISE FND_API.G_EXC_ERROR;
2136:

Line 2135: RAISE FND_API.G_EXC_ERROR;

2131:
2132: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2133:
2134: oe_debug_pub.add('before raise');
2135: RAISE FND_API.G_EXC_ERROR;
2136:
2137: END IF;
2138:
2139: IF p_MODIFIERS_rec.accum_attribute IS NOT NULL THEN

Line 2148: l_return_status := FND_API.G_RET_STS_ERROR;

2144: ,p_error_code => l_error_code);
2145:
2146: IF (l_error_code <> 0 ) -- invalid context
2147: THEN
2148: l_return_status := FND_API.G_RET_STS_ERROR;
2149:
2150: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2151: THEN
2152:

Line 2197: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2193: , p_param6 => NULL
2194: , x_return_status => l_return_status
2195: );
2196:
2197: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2198:
2199: oe_debug_pub.add('failed in logging delayed request for Duplicate Modifiers ');
2200:
2201: RAISE FND_API.G_EXC_ERROR;

Line 2201: RAISE FND_API.G_EXC_ERROR;

2197: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2198:
2199: oe_debug_pub.add('failed in logging delayed request for Duplicate Modifiers ');
2200:
2201: RAISE FND_API.G_EXC_ERROR;
2202:
2203: END IF;
2204:
2205: oe_debug_pub.add('after logging delayed request ');

Line 2216: WHEN FND_API.G_EXC_ERROR THEN

2212: oe_debug_pub.add('END Entity in QPXLMLLB');
2213:
2214: EXCEPTION
2215:
2216: WHEN FND_API.G_EXC_ERROR THEN
2217:
2218: oe_debug_pub.add('EXP error');
2219: x_return_status := FND_API.G_RET_STS_ERROR;
2220:

Line 2219: x_return_status := FND_API.G_RET_STS_ERROR;

2215:
2216: WHEN FND_API.G_EXC_ERROR THEN
2217:
2218: oe_debug_pub.add('EXP error');
2219: x_return_status := FND_API.G_RET_STS_ERROR;
2220:
2221: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2222:
2223: oe_debug_pub.add('EXP unexpected');

Line 2221: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2217:
2218: oe_debug_pub.add('EXP error');
2219: x_return_status := FND_API.G_RET_STS_ERROR;
2220:
2221: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2222:
2223: oe_debug_pub.add('EXP unexpected');
2224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2225:

Line 2224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2220:
2221: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2222:
2223: oe_debug_pub.add('EXP unexpected');
2224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2225:
2226: WHEN OTHERS THEN
2227:
2228: oe_debug_pub.add('EXP others');

Line 2230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2226: WHEN OTHERS THEN
2227:
2228: oe_debug_pub.add('EXP others');
2229: oe_debug_pub.add('error =' || sqlerrm);
2230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2231:
2232: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2233: THEN
2234: OE_MSG_PUB.Add_Exc_Msg

Line 2254: x_return_status := FND_API.G_RET_STS_SUCCESS;

2250: IS
2251: BEGIN
2252:
2253: oe_debug_pub.add('BEGIN Attributes in QPXLMLLB');
2254: x_return_status := FND_API.G_RET_STS_SUCCESS;
2255:
2256: /* changes to fix bug # 1724169 */
2257:
2258: IF p_MODIFIERS_rec.list_line_type_code <> 'PMR' --Bug No: 8609021,

Line 2264: x_return_status := FND_API.G_RET_STS_ERROR;

2260: AND FND_PROFILE.VALUE('QP_NEGATIVE_PRICING') = 'N' AND p_MODIFIERS_rec.operand < 0
2261: THEN
2262: FND_MESSAGE.SET_NAME('QP','OE_PR_NEGATIVE_AMOUNT');
2263: OE_MSG_PUB.Add;
2264: x_return_status := FND_API.G_RET_STS_ERROR;
2265: END IF;
2266:
2267:
2268:

Line 2277: x_return_status := FND_API.G_RET_STS_ERROR;

2273: p_old_MODIFIERS_rec.arithmetic_operator OR
2274: p_old_MODIFIERS_rec.arithmetic_operator IS NULL )
2275: THEN
2276: IF NOT QP_Validate.Arithmetic_Operator(p_MODIFIERS_rec.arithmetic_operator) THEN
2277: x_return_status := FND_API.G_RET_STS_ERROR;
2278: END IF;
2279: END IF;
2280: oe_debug_pub.add('here3');
2281:

Line 2288: x_return_status := FND_API.G_RET_STS_ERROR;

2284: p_old_MODIFIERS_rec.automatic_flag OR
2285: p_old_MODIFIERS_rec.automatic_flag IS NULL )
2286: THEN
2287: IF NOT QP_Validate.Automatic(p_MODIFIERS_rec.automatic_flag) THEN
2288: x_return_status := FND_API.G_RET_STS_ERROR;
2289: END IF;
2290: END IF;
2291:
2292: /* IF p_MODIFIERS_rec.base_qty IS NOT NULL AND

Line 2298: x_return_status := FND_API.G_RET_STS_ERROR;

2294: p_old_MODIFIERS_rec.base_qty OR
2295: p_old_MODIFIERS_rec.base_qty IS NULL )
2296: THEN
2297: IF NOT QP_Validate.Base_Qty(p_MODIFIERS_rec.base_qty) THEN
2298: x_return_status := FND_API.G_RET_STS_ERROR;
2299: END IF;
2300: END IF;
2301: */
2302: IF p_MODIFIERS_rec.pricing_phase_id IS NOT NULL AND

Line 2308: x_return_status := FND_API.G_RET_STS_ERROR;

2304: p_old_MODIFIERS_rec.pricing_phase_id OR
2305: p_old_MODIFIERS_rec.pricing_phase_id IS NULL )
2306: THEN
2307: IF NOT QP_Validate.Pricing_Phase(p_MODIFIERS_rec.pricing_phase_id) THEN
2308: x_return_status := FND_API.G_RET_STS_ERROR;
2309: END IF;
2310: END IF;
2311:
2312: oe_debug_pub.add('here4');

Line 2319: x_return_status := FND_API.G_RET_STS_ERROR;

2315: p_old_MODIFIERS_rec.base_uom_code OR
2316: p_old_MODIFIERS_rec.base_uom_code IS NULL )
2317: THEN
2318: IF NOT QP_Validate.Base_Uom(p_MODIFIERS_rec.base_uom_code) THEN
2319: x_return_status := FND_API.G_RET_STS_ERROR;
2320: END IF;
2321: END IF;
2322: */
2323: IF p_MODIFIERS_rec.comments IS NOT NULL AND

Line 2329: x_return_status := FND_API.G_RET_STS_ERROR;

2325: p_old_MODIFIERS_rec.comments OR
2326: p_old_MODIFIERS_rec.comments IS NULL )
2327: THEN
2328: IF NOT QP_Validate.Comments(p_MODIFIERS_rec.comments) THEN
2329: x_return_status := FND_API.G_RET_STS_ERROR;
2330: END IF;
2331: END IF;
2332:
2333: IF p_MODIFIERS_rec.created_by IS NOT NULL AND

Line 2339: x_return_status := FND_API.G_RET_STS_ERROR;

2335: p_old_MODIFIERS_rec.created_by OR
2336: p_old_MODIFIERS_rec.created_by IS NULL )
2337: THEN
2338: IF NOT QP_Validate.Created_By(p_MODIFIERS_rec.created_by) THEN
2339: x_return_status := FND_API.G_RET_STS_ERROR;
2340: END IF;
2341: END IF;
2342:
2343: IF p_MODIFIERS_rec.creation_date IS NOT NULL AND

Line 2349: x_return_status := FND_API.G_RET_STS_ERROR;

2345: p_old_MODIFIERS_rec.creation_date OR
2346: p_old_MODIFIERS_rec.creation_date IS NULL )
2347: THEN
2348: IF NOT QP_Validate.Creation_Date(p_MODIFIERS_rec.creation_date) THEN
2349: x_return_status := FND_API.G_RET_STS_ERROR;
2350: END IF;
2351: END IF;
2352:
2353: IF p_MODIFIERS_rec.effective_period_uom IS NOT NULL AND

Line 2359: x_return_status := FND_API.G_RET_STS_ERROR;

2355: p_old_MODIFIERS_rec.effective_period_uom OR
2356: p_old_MODIFIERS_rec.effective_period_uom IS NULL )
2357: THEN
2358: IF NOT QP_Validate.Effective_Period_Uom(p_MODIFIERS_rec.effective_period_uom) THEN
2359: x_return_status := FND_API.G_RET_STS_ERROR;
2360: END IF;
2361: END IF;
2362:
2363: IF p_MODIFIERS_rec.end_date_active IS NOT NULL AND

Line 2369: x_return_status := FND_API.G_RET_STS_ERROR;

2365: p_old_MODIFIERS_rec.end_date_active OR
2366: p_old_MODIFIERS_rec.end_date_active IS NULL )
2367: THEN
2368: IF NOT QP_Validate.End_Date_Active(p_MODIFIERS_rec.end_date_active) THEN
2369: x_return_status := FND_API.G_RET_STS_ERROR;
2370: END IF;
2371: END IF;
2372:
2373: IF p_MODIFIERS_rec.estim_accrual_rate IS NOT NULL AND

Line 2379: x_return_status := FND_API.G_RET_STS_ERROR;

2375: p_old_MODIFIERS_rec.estim_accrual_rate OR
2376: p_old_MODIFIERS_rec.estim_accrual_rate IS NULL )
2377: THEN
2378: IF NOT QP_Validate.Estim_Accrual_Rate(p_MODIFIERS_rec.estim_accrual_rate) THEN
2379: x_return_status := FND_API.G_RET_STS_ERROR;
2380: END IF;
2381: END IF;
2382:
2383: IF p_MODIFIERS_rec.generate_using_formula_id IS NOT NULL AND

Line 2389: x_return_status := FND_API.G_RET_STS_ERROR;

2385: p_old_MODIFIERS_rec.generate_using_formula_id OR
2386: p_old_MODIFIERS_rec.generate_using_formula_id IS NULL )
2387: THEN
2388: IF NOT QP_Validate.Generate_Using_Formula(p_MODIFIERS_rec.generate_using_formula_id) THEN
2389: x_return_status := FND_API.G_RET_STS_ERROR;
2390: END IF;
2391: END IF;
2392:
2393: /* IF p_MODIFIERS_rec.gl_class_id IS NOT NULL AND

Line 2399: x_return_status := FND_API.G_RET_STS_ERROR;

2395: p_old_MODIFIERS_rec.gl_class_id OR
2396: p_old_MODIFIERS_rec.gl_class_id IS NULL )
2397: THEN
2398: IF NOT QP_Validate.Gl_Class(p_MODIFIERS_rec.gl_class_id) THEN
2399: x_return_status := FND_API.G_RET_STS_ERROR;
2400: END IF;
2401: END IF;
2402: */
2403: IF p_MODIFIERS_rec.inventory_item_id IS NOT NULL AND

Line 2409: x_return_status := FND_API.G_RET_STS_ERROR;

2405: p_old_MODIFIERS_rec.inventory_item_id OR
2406: p_old_MODIFIERS_rec.inventory_item_id IS NULL )
2407: THEN
2408: IF NOT QP_Validate.Inventory_Item(p_MODIFIERS_rec.inventory_item_id) THEN
2409: x_return_status := FND_API.G_RET_STS_ERROR;
2410: END IF;
2411: END IF;
2412:
2413: IF p_MODIFIERS_rec.last_updated_by IS NOT NULL AND

Line 2419: x_return_status := FND_API.G_RET_STS_ERROR;

2415: p_old_MODIFIERS_rec.last_updated_by OR
2416: p_old_MODIFIERS_rec.last_updated_by IS NULL )
2417: THEN
2418: IF NOT QP_Validate.Last_Updated_By(p_MODIFIERS_rec.last_updated_by) THEN
2419: x_return_status := FND_API.G_RET_STS_ERROR;
2420: END IF;
2421: END IF;
2422:
2423: IF p_MODIFIERS_rec.last_update_date IS NOT NULL AND

Line 2429: x_return_status := FND_API.G_RET_STS_ERROR;

2425: p_old_MODIFIERS_rec.last_update_date OR
2426: p_old_MODIFIERS_rec.last_update_date IS NULL )
2427: THEN
2428: IF NOT QP_Validate.Last_Update_Date(p_MODIFIERS_rec.last_update_date) THEN
2429: x_return_status := FND_API.G_RET_STS_ERROR;
2430: END IF;
2431: END IF;
2432:
2433: IF p_MODIFIERS_rec.last_update_login IS NOT NULL AND

Line 2439: x_return_status := FND_API.G_RET_STS_ERROR;

2435: p_old_MODIFIERS_rec.last_update_login OR
2436: p_old_MODIFIERS_rec.last_update_login IS NULL )
2437: THEN
2438: IF NOT QP_Validate.Last_Update_Login(p_MODIFIERS_rec.last_update_login) THEN
2439: x_return_status := FND_API.G_RET_STS_ERROR;
2440: END IF;
2441: END IF;
2442:
2443: oe_debug_pub.add('here5');

Line 2450: x_return_status := FND_API.G_RET_STS_ERROR;

2446: p_old_MODIFIERS_rec.list_header_id OR
2447: p_old_MODIFIERS_rec.list_header_id IS NULL )
2448: THEN
2449: IF NOT QP_Validate.List_Header(p_MODIFIERS_rec.list_header_id) THEN
2450: x_return_status := FND_API.G_RET_STS_ERROR;
2451: END IF;
2452: END IF;
2453:
2454: IF p_MODIFIERS_rec.list_line_id IS NOT NULL AND

Line 2460: x_return_status := FND_API.G_RET_STS_ERROR;

2456: p_old_MODIFIERS_rec.list_line_id OR
2457: p_old_MODIFIERS_rec.list_line_id IS NULL )
2458: THEN
2459: IF NOT QP_Validate.List_Line(p_MODIFIERS_rec.list_line_id) THEN
2460: x_return_status := FND_API.G_RET_STS_ERROR;
2461: END IF;
2462: END IF;
2463:
2464: IF p_MODIFIERS_rec.list_line_type_code IS NOT NULL AND

Line 2470: x_return_status := FND_API.G_RET_STS_ERROR;

2466: p_old_MODIFIERS_rec.list_line_type_code OR
2467: p_old_MODIFIERS_rec.list_line_type_code IS NULL )
2468: THEN
2469: IF NOT QP_Validate.List_Line_Type(p_MODIFIERS_rec.list_line_type_code) THEN
2470: x_return_status := FND_API.G_RET_STS_ERROR;
2471: END IF;
2472: END IF;
2473:
2474: IF p_MODIFIERS_rec.list_price IS NOT NULL AND

Line 2480: x_return_status := FND_API.G_RET_STS_ERROR;

2476: p_old_MODIFIERS_rec.list_price OR
2477: p_old_MODIFIERS_rec.list_price IS NULL )
2478: THEN
2479: IF NOT QP_Validate.List_Price(p_MODIFIERS_rec.list_price) THEN
2480: x_return_status := FND_API.G_RET_STS_ERROR;
2481: END IF;
2482: END IF;
2483:
2484: /* IF p_MODIFIERS_rec.list_price_uom_code IS NOT NULL AND

Line 2490: x_return_status := FND_API.G_RET_STS_ERROR;

2486: p_old_MODIFIERS_rec.list_price_uom_code OR
2487: p_old_MODIFIERS_rec.list_price_uom_code IS NULL )
2488: THEN
2489: IF NOT QP_Validate.List_Price_Uom(p_MODIFIERS_rec.list_price_uom_code) THEN
2490: x_return_status := FND_API.G_RET_STS_ERROR;
2491: END IF;
2492: END IF;
2493: */
2494: IF p_MODIFIERS_rec.modifier_level_code IS NOT NULL AND

Line 2500: x_return_status := FND_API.G_RET_STS_ERROR;

2496: p_old_MODIFIERS_rec.modifier_level_code OR
2497: p_old_MODIFIERS_rec.modifier_level_code IS NULL )
2498: THEN
2499: IF NOT QP_Validate.Modifier_Level(p_MODIFIERS_rec.modifier_level_code) THEN
2500: x_return_status := FND_API.G_RET_STS_ERROR;
2501: END IF;
2502: END IF;
2503:
2504: /* IF p_MODIFIERS_rec.new_price IS NOT NULL AND

Line 2510: x_return_status := FND_API.G_RET_STS_ERROR;

2506: p_old_MODIFIERS_rec.new_price OR
2507: p_old_MODIFIERS_rec.new_price IS NULL )
2508: THEN
2509: IF NOT QP_Validate.New_Price(p_MODIFIERS_rec.new_price) THEN
2510: x_return_status := FND_API.G_RET_STS_ERROR;
2511: END IF;
2512: END IF;
2513: */
2514: IF p_MODIFIERS_rec.number_effective_periods IS NOT NULL AND

Line 2520: x_return_status := FND_API.G_RET_STS_ERROR;

2516: p_old_MODIFIERS_rec.number_effective_periods OR
2517: p_old_MODIFIERS_rec.number_effective_periods IS NULL )
2518: THEN
2519: IF NOT QP_Validate.Number_Effective_Periods(p_MODIFIERS_rec.number_effective_periods) THEN
2520: x_return_status := FND_API.G_RET_STS_ERROR;
2521: END IF;
2522: END IF;
2523:
2524: oe_debug_pub.add('here6');

Line 2533: x_return_status := FND_API.G_RET_STS_ERROR;

2529: THEN
2530: oe_debug_pub.add('here7');
2531: IF NOT QP_Validate.Operand(p_MODIFIERS_rec.operand) THEN
2532: oe_debug_pub.add('here8');
2533: x_return_status := FND_API.G_RET_STS_ERROR;
2534: END IF;
2535: END IF;
2536:
2537: oe_debug_pub.add('here9');

Line 2544: x_return_status := FND_API.G_RET_STS_ERROR;

2540: p_old_MODIFIERS_rec.organization_id OR
2541: p_old_MODIFIERS_rec.organization_id IS NULL )
2542: THEN
2543: IF NOT QP_Validate.Organization(p_MODIFIERS_rec.organization_id) THEN
2544: x_return_status := FND_API.G_RET_STS_ERROR;
2545: END IF;
2546: END IF;
2547:
2548: oe_debug_pub.add('here10');

Line 2555: x_return_status := FND_API.G_RET_STS_ERROR;

2551: p_old_MODIFIERS_rec.override_flag OR
2552: p_old_MODIFIERS_rec.override_flag IS NULL )
2553: THEN
2554: IF NOT QP_Validate.Override(p_MODIFIERS_rec.override_flag) THEN
2555: x_return_status := FND_API.G_RET_STS_ERROR;
2556: END IF;
2557: END IF;
2558:
2559: oe_debug_pub.add('here11');

Line 2566: x_return_status := FND_API.G_RET_STS_ERROR;

2562: p_old_MODIFIERS_rec.percent_price OR
2563: p_old_MODIFIERS_rec.percent_price IS NULL )
2564: THEN
2565: IF NOT QP_Validate.Percent_Price(p_MODIFIERS_rec.percent_price) THEN
2566: x_return_status := FND_API.G_RET_STS_ERROR;
2567: END IF;
2568: END IF;
2569:
2570: IF p_MODIFIERS_rec.price_break_type_code IS NOT NULL AND

Line 2576: x_return_status := FND_API.G_RET_STS_ERROR;

2572: p_old_MODIFIERS_rec.price_break_type_code OR
2573: p_old_MODIFIERS_rec.price_break_type_code IS NULL )
2574: THEN
2575: IF NOT QP_Validate.Price_Break_Type(p_MODIFIERS_rec.price_break_type_code) THEN
2576: x_return_status := FND_API.G_RET_STS_ERROR;
2577: END IF;
2578: END IF;
2579:
2580: IF p_MODIFIERS_rec.price_by_formula_id IS NOT NULL AND

Line 2586: x_return_status := FND_API.G_RET_STS_ERROR;

2582: p_old_MODIFIERS_rec.price_by_formula_id OR
2583: p_old_MODIFIERS_rec.price_by_formula_id IS NULL )
2584: THEN
2585: IF NOT QP_Validate.Price_By_Formula(p_MODIFIERS_rec.price_by_formula_id) THEN
2586: x_return_status := FND_API.G_RET_STS_ERROR;
2587: END IF;
2588: END IF;
2589:
2590: IF p_MODIFIERS_rec.primary_uom_flag IS NOT NULL AND

Line 2596: x_return_status := FND_API.G_RET_STS_ERROR;

2592: p_old_MODIFIERS_rec.primary_uom_flag OR
2593: p_old_MODIFIERS_rec.primary_uom_flag IS NULL )
2594: THEN
2595: IF NOT QP_Validate.Primary_Uom(p_MODIFIERS_rec.primary_uom_flag) THEN
2596: x_return_status := FND_API.G_RET_STS_ERROR;
2597: END IF;
2598: END IF;
2599:
2600: --ER 11828647

Line 2608: x_return_status := FND_API.G_RET_STS_ERROR;

2604: p_old_MODIFIERS_rec.print_on_invoice_flag OR
2605: p_old_MODIFIERS_rec.print_on_invoice_flag IS NULL )
2606: THEN
2607: IF NOT QP_Validate.Print_On_Invoice(p_MODIFIERS_rec.print_on_invoice_flag) THEN
2608: x_return_status := FND_API.G_RET_STS_ERROR;
2609: END IF;
2610: END IF;
2611: */
2612:

Line 2619: x_return_status := FND_API.G_RET_STS_ERROR;

2615: p_old_MODIFIERS_rec.program_application_id OR
2616: p_old_MODIFIERS_rec.program_application_id IS NULL )
2617: THEN
2618: IF NOT QP_Validate.Program_Application(p_MODIFIERS_rec.program_application_id) THEN
2619: x_return_status := FND_API.G_RET_STS_ERROR;
2620: END IF;
2621: END IF;
2622:
2623: IF p_MODIFIERS_rec.program_id IS NOT NULL AND

Line 2629: x_return_status := FND_API.G_RET_STS_ERROR;

2625: p_old_MODIFIERS_rec.program_id OR
2626: p_old_MODIFIERS_rec.program_id IS NULL )
2627: THEN
2628: IF NOT QP_Validate.Program(p_MODIFIERS_rec.program_id) THEN
2629: x_return_status := FND_API.G_RET_STS_ERROR;
2630: END IF;
2631: END IF;
2632:
2633: IF p_MODIFIERS_rec.program_update_date IS NOT NULL AND

Line 2639: x_return_status := FND_API.G_RET_STS_ERROR;

2635: p_old_MODIFIERS_rec.program_update_date OR
2636: p_old_MODIFIERS_rec.program_update_date IS NULL )
2637: THEN
2638: IF NOT QP_Validate.Program_Update_Date(p_MODIFIERS_rec.program_update_date) THEN
2639: x_return_status := FND_API.G_RET_STS_ERROR;
2640: END IF;
2641: END IF;
2642:
2643: /* IF p_MODIFIERS_rec.rebate_subtype_code IS NOT NULL AND

Line 2649: x_return_status := FND_API.G_RET_STS_ERROR;

2645: p_old_MODIFIERS_rec.rebate_subtype_code OR
2646: p_old_MODIFIERS_rec.rebate_subtype_code IS NULL )
2647: THEN
2648: IF NOT QP_Validate.Rebate_Subtype(p_MODIFIERS_rec.rebate_subtype_code) THEN
2649: x_return_status := FND_API.G_RET_STS_ERROR;
2650: END IF;
2651: END IF;
2652: */
2653: IF p_MODIFIERS_rec.rebate_trxn_type_code IS NOT NULL AND

Line 2659: x_return_status := FND_API.G_RET_STS_ERROR;

2655: p_old_MODIFIERS_rec.rebate_trxn_type_code OR
2656: p_old_MODIFIERS_rec.rebate_trxn_type_code IS NULL )
2657: THEN
2658: IF NOT QP_Validate.Rebate_Transaction_Type(p_MODIFIERS_rec.rebate_trxn_type_code) THEN
2659: x_return_status := FND_API.G_RET_STS_ERROR;
2660: END IF;
2661: END IF;
2662:
2663: IF p_MODIFIERS_rec.related_item_id IS NOT NULL AND

Line 2669: x_return_status := FND_API.G_RET_STS_ERROR;

2665: p_old_MODIFIERS_rec.related_item_id OR
2666: p_old_MODIFIERS_rec.related_item_id IS NULL )
2667: THEN
2668: IF NOT QP_Validate.Related_Item(p_MODIFIERS_rec.related_item_id) THEN
2669: x_return_status := FND_API.G_RET_STS_ERROR;
2670: END IF;
2671: END IF;
2672:
2673: IF p_MODIFIERS_rec.relationship_type_id IS NOT NULL AND

Line 2679: x_return_status := FND_API.G_RET_STS_ERROR;

2675: p_old_MODIFIERS_rec.relationship_type_id OR
2676: p_old_MODIFIERS_rec.relationship_type_id IS NULL )
2677: THEN
2678: IF NOT QP_Validate.Relationship_Type(p_MODIFIERS_rec.relationship_type_id) THEN
2679: x_return_status := FND_API.G_RET_STS_ERROR;
2680: END IF;
2681: END IF;
2682:
2683: IF p_MODIFIERS_rec.reprice_flag IS NOT NULL AND

Line 2689: x_return_status := FND_API.G_RET_STS_ERROR;

2685: p_old_MODIFIERS_rec.reprice_flag OR
2686: p_old_MODIFIERS_rec.reprice_flag IS NULL )
2687: THEN
2688: IF NOT QP_Validate.Reprice(p_MODIFIERS_rec.reprice_flag) THEN
2689: x_return_status := FND_API.G_RET_STS_ERROR;
2690: END IF;
2691: END IF;
2692:
2693: IF p_MODIFIERS_rec.request_id IS NOT NULL AND

Line 2699: x_return_status := FND_API.G_RET_STS_ERROR;

2695: p_old_MODIFIERS_rec.request_id OR
2696: p_old_MODIFIERS_rec.request_id IS NULL )
2697: THEN
2698: IF NOT QP_Validate.Request(p_MODIFIERS_rec.request_id) THEN
2699: x_return_status := FND_API.G_RET_STS_ERROR;
2700: END IF;
2701: END IF;
2702:
2703: IF p_MODIFIERS_rec.revision IS NOT NULL AND

Line 2709: x_return_status := FND_API.G_RET_STS_ERROR;

2705: p_old_MODIFIERS_rec.revision OR
2706: p_old_MODIFIERS_rec.revision IS NULL )
2707: THEN
2708: IF NOT QP_Validate.Revision(p_MODIFIERS_rec.revision) THEN
2709: x_return_status := FND_API.G_RET_STS_ERROR;
2710: END IF;
2711: END IF;
2712:
2713: IF p_MODIFIERS_rec.revision_date IS NOT NULL AND

Line 2719: x_return_status := FND_API.G_RET_STS_ERROR;

2715: p_old_MODIFIERS_rec.revision_date OR
2716: p_old_MODIFIERS_rec.revision_date IS NULL )
2717: THEN
2718: IF NOT QP_Validate.Revision_Date(p_MODIFIERS_rec.revision_date) THEN
2719: x_return_status := FND_API.G_RET_STS_ERROR;
2720: END IF;
2721: END IF;
2722:
2723: IF p_MODIFIERS_rec.revision_reason_code IS NOT NULL AND

Line 2729: x_return_status := FND_API.G_RET_STS_ERROR;

2725: p_old_MODIFIERS_rec.revision_reason_code OR
2726: p_old_MODIFIERS_rec.revision_reason_code IS NULL )
2727: THEN
2728: IF NOT QP_Validate.Revision_Reason(p_MODIFIERS_rec.revision_reason_code) THEN
2729: x_return_status := FND_API.G_RET_STS_ERROR;
2730: END IF;
2731: END IF;
2732:
2733: IF p_MODIFIERS_rec.start_date_active IS NOT NULL AND

Line 2739: x_return_status := FND_API.G_RET_STS_ERROR;

2735: p_old_MODIFIERS_rec.start_date_active OR
2736: p_old_MODIFIERS_rec.start_date_active IS NULL )
2737: THEN
2738: IF NOT QP_Validate.Start_Date_Active(p_MODIFIERS_rec.start_date_active) THEN
2739: x_return_status := FND_API.G_RET_STS_ERROR;
2740: END IF;
2741: END IF;
2742:
2743: IF p_MODIFIERS_rec.substitution_attribute IS NOT NULL AND

Line 2749: x_return_status := FND_API.G_RET_STS_ERROR;

2745: p_old_MODIFIERS_rec.substitution_attribute OR
2746: p_old_MODIFIERS_rec.substitution_attribute IS NULL )
2747: THEN
2748: IF NOT QP_Validate.Substitution_Attribute(p_MODIFIERS_rec.substitution_attribute) THEN
2749: x_return_status := FND_API.G_RET_STS_ERROR;
2750: END IF;
2751: END IF;
2752:
2753: IF p_MODIFIERS_rec.substitution_context IS NOT NULL AND

Line 2759: x_return_status := FND_API.G_RET_STS_ERROR;

2755: p_old_MODIFIERS_rec.substitution_context OR
2756: p_old_MODIFIERS_rec.substitution_context IS NULL )
2757: THEN
2758: IF NOT QP_Validate.Substitution_Context(p_MODIFIERS_rec.substitution_context) THEN
2759: x_return_status := FND_API.G_RET_STS_ERROR;
2760: END IF;
2761: END IF;
2762:
2763: IF p_MODIFIERS_rec.substitution_value IS NOT NULL AND

Line 2769: x_return_status := FND_API.G_RET_STS_ERROR;

2765: p_old_MODIFIERS_rec.substitution_value OR
2766: p_old_MODIFIERS_rec.substitution_value IS NULL )
2767: THEN
2768: IF NOT QP_Validate.Substitution_Value(p_MODIFIERS_rec.substitution_value) THEN
2769: x_return_status := FND_API.G_RET_STS_ERROR;
2770: END IF;
2771: END IF;
2772:
2773: IF p_MODIFIERS_rec.accrual_flag IS NOT NULL AND

Line 2779: x_return_status := FND_API.G_RET_STS_ERROR;

2775: p_old_MODIFIERS_rec.accrual_flag OR
2776: p_old_MODIFIERS_rec.accrual_flag IS NULL )
2777: THEN
2778: IF NOT QP_Validate.Accrual_Flag(p_MODIFIERS_rec.accrual_flag) THEN
2779: x_return_status := FND_API.G_RET_STS_ERROR;
2780: END IF;
2781: END IF;
2782:
2783: IF p_MODIFIERS_rec.pricing_group_sequence IS NOT NULL AND

Line 2789: x_return_status := FND_API.G_RET_STS_ERROR;

2785: p_old_MODIFIERS_rec.pricing_group_sequence OR
2786: p_old_MODIFIERS_rec.pricing_group_sequence IS NULL )
2787: THEN
2788: IF NOT QP_Validate.Pricing_Group_Sequence(p_MODIFIERS_rec.pricing_group_sequence) THEN
2789: x_return_status := FND_API.G_RET_STS_ERROR;
2790: END IF;
2791: END IF;
2792: oe_debug_pub.add('here12');
2793: IF p_MODIFIERS_rec.incompatibility_grp_code IS NOT NULL AND

Line 2799: x_return_status := FND_API.G_RET_STS_ERROR;

2795: p_old_MODIFIERS_rec.incompatibility_grp_code OR
2796: p_old_MODIFIERS_rec.incompatibility_grp_code IS NULL )
2797: THEN
2798: IF NOT QP_Validate.Incompatibility_Grp_Code(p_MODIFIERS_rec.incompatibility_grp_code) THEN
2799: x_return_status := FND_API.G_RET_STS_ERROR;
2800: END IF;
2801: END IF;
2802:
2803: oe_debug_pub.add('here13');

Line 2810: x_return_status := FND_API.G_RET_STS_ERROR;

2806: p_old_MODIFIERS_rec.list_line_no OR
2807: p_old_MODIFIERS_rec.list_line_no IS NULL )
2808: THEN
2809: IF NOT QP_Validate.List_Line_No(p_MODIFIERS_rec.list_line_no) THEN
2810: x_return_status := FND_API.G_RET_STS_ERROR;
2811: END IF;
2812: END IF;
2813:
2814: IF p_MODIFIERS_rec.product_precedence IS NOT NULL AND

Line 2820: x_return_status := FND_API.G_RET_STS_ERROR;

2816: p_old_MODIFIERS_rec.product_precedence OR
2817: p_old_MODIFIERS_rec.product_precedence IS NULL )
2818: THEN
2819: IF NOT QP_Validate.Product_Precedence(p_MODIFIERS_rec.product_precedence) THEN
2820: x_return_status := FND_API.G_RET_STS_ERROR;
2821: END IF;
2822: END IF;
2823:
2824: IF p_MODIFIERS_rec.expiration_period_start_date IS NOT NULL AND

Line 2830: x_return_status := FND_API.G_RET_STS_ERROR;

2826: p_old_MODIFIERS_rec.expiration_period_start_date OR
2827: p_old_MODIFIERS_rec.expiration_period_start_date IS NULL )
2828: THEN
2829: IF NOT QP_Validate.Exp_Period_Start_Date(p_MODIFIERS_rec.expiration_period_start_date) THEN
2830: x_return_status := FND_API.G_RET_STS_ERROR;
2831: END IF;
2832: END IF;
2833:
2834: IF p_MODIFIERS_rec.number_expiration_periods IS NOT NULL AND

Line 2840: x_return_status := FND_API.G_RET_STS_ERROR;

2836: p_old_MODIFIERS_rec.number_expiration_periods OR
2837: p_old_MODIFIERS_rec.number_expiration_periods IS NULL )
2838: THEN
2839: IF NOT QP_Validate.Number_Expiration_Periods(p_MODIFIERS_rec.number_expiration_periods) THEN
2840: x_return_status := FND_API.G_RET_STS_ERROR;
2841: END IF;
2842: END IF;
2843:
2844: IF p_MODIFIERS_rec.number_expiration_periods IS NOT NULL AND

Line 2850: x_return_status := FND_API.G_RET_STS_ERROR;

2846: p_old_MODIFIERS_rec.number_expiration_periods OR
2847: p_old_MODIFIERS_rec.number_expiration_periods IS NULL )
2848: THEN
2849: IF NOT QP_Validate.Number_Expiration_Periods(p_MODIFIERS_rec.number_expiration_periods) THEN
2850: x_return_status := FND_API.G_RET_STS_ERROR;
2851: END IF;
2852: END IF;
2853:
2854: IF p_MODIFIERS_rec.expiration_period_uom IS NOT NULL AND

Line 2860: x_return_status := FND_API.G_RET_STS_ERROR;

2856: p_old_MODIFIERS_rec.expiration_period_uom OR
2857: p_old_MODIFIERS_rec.expiration_period_uom IS NULL )
2858: THEN
2859: IF NOT QP_Validate.Expiration_Period_Uom(p_MODIFIERS_rec.expiration_period_uom) THEN
2860: x_return_status := FND_API.G_RET_STS_ERROR;
2861: END IF;
2862: END IF;
2863:
2864: IF p_MODIFIERS_rec.expiration_date IS NOT NULL AND

Line 2870: x_return_status := FND_API.G_RET_STS_ERROR;

2866: p_old_MODIFIERS_rec.expiration_date OR
2867: p_old_MODIFIERS_rec.expiration_date IS NULL )
2868: THEN
2869: IF NOT QP_Validate.Expiration_Date(p_MODIFIERS_rec.expiration_date) THEN
2870: x_return_status := FND_API.G_RET_STS_ERROR;
2871: END IF;
2872: END IF;
2873:
2874: IF p_MODIFIERS_rec.estim_gl_value IS NOT NULL AND

Line 2880: x_return_status := FND_API.G_RET_STS_ERROR;

2876: p_old_MODIFIERS_rec.estim_gl_value OR
2877: p_old_MODIFIERS_rec.estim_gl_value IS NULL )
2878: THEN
2879: IF NOT QP_Validate.Estim_Gl_Value(p_MODIFIERS_rec.estim_gl_value) THEN
2880: x_return_status := FND_API.G_RET_STS_ERROR;
2881: END IF;
2882: END IF;
2883:
2884: IF p_MODIFIERS_rec.benefit_price_list_line_id IS NOT NULL AND

Line 2890: x_return_status := FND_API.G_RET_STS_ERROR;

2886: p_old_MODIFIERS_rec.benefit_price_list_line_id OR
2887: p_old_MODIFIERS_rec.benefit_price_list_line_id IS NULL )
2888: THEN
2889: IF NOT QP_Validate.Ben_Price_List_Line(p_MODIFIERS_rec.benefit_price_list_line_id) THEN
2890: x_return_status := FND_API.G_RET_STS_ERROR;
2891: END IF;
2892: END IF;
2893:
2894: /* IF p_MODIFIERS_rec.recurring_flag IS NOT NULL AND

Line 2900: x_return_status := FND_API.G_RET_STS_ERROR;

2896: p_old_MODIFIERS_rec.recurring_flag OR
2897: p_old_MODIFIERS_rec.recurring_flag IS NULL )
2898: THEN
2899: IF NOT QP_Validate.Recurring(p_MODIFIERS_rec.recurring_flag) THEN
2900: x_return_status := FND_API.G_RET_STS_ERROR;
2901: END IF;
2902: END IF;
2903: */
2904: IF p_MODIFIERS_rec.benefit_limit IS NOT NULL AND

Line 2910: x_return_status := FND_API.G_RET_STS_ERROR;

2906: p_old_MODIFIERS_rec.benefit_limit OR
2907: p_old_MODIFIERS_rec.benefit_limit IS NULL )
2908: THEN
2909: IF NOT QP_Validate.Benefit_Limit(p_MODIFIERS_rec.benefit_limit) THEN
2910: x_return_status := FND_API.G_RET_STS_ERROR;
2911: END IF;
2912: END IF;
2913:
2914: IF p_MODIFIERS_rec.charge_type_code IS NOT NULL AND

Line 2920: x_return_status := FND_API.G_RET_STS_ERROR;

2916: p_old_MODIFIERS_rec.charge_type_code OR
2917: p_old_MODIFIERS_rec.charge_type_code IS NULL )
2918: THEN
2919: IF NOT QP_Validate.Charge_Type(p_MODIFIERS_rec.charge_type_code) THEN
2920: x_return_status := FND_API.G_RET_STS_ERROR;
2921: END IF;
2922: END IF;
2923:
2924: IF p_MODIFIERS_rec.charge_subtype_code IS NOT NULL AND

Line 2930: x_return_status := FND_API.G_RET_STS_ERROR;

2926: p_old_MODIFIERS_rec.charge_subtype_code OR
2927: p_old_MODIFIERS_rec.charge_subtype_code IS NULL )
2928: THEN
2929: IF NOT QP_Validate.Charge_Subtype(p_MODIFIERS_rec.charge_subtype_code) THEN
2930: x_return_status := FND_API.G_RET_STS_ERROR;
2931: END IF;
2932: END IF;
2933:
2934: IF p_MODIFIERS_rec.benefit_qty IS NOT NULL AND

Line 2940: x_return_status := FND_API.G_RET_STS_ERROR;

2936: p_old_MODIFIERS_rec.benefit_qty OR
2937: p_old_MODIFIERS_rec.benefit_qty IS NULL )
2938: THEN
2939: IF NOT QP_Validate.Benefit_Qty(p_MODIFIERS_rec.benefit_qty) THEN
2940: x_return_status := FND_API.G_RET_STS_ERROR;
2941: END IF;
2942: END IF;
2943:
2944: IF p_MODIFIERS_rec.benefit_uom_code IS NOT NULL AND

Line 2950: x_return_status := FND_API.G_RET_STS_ERROR;

2946: p_old_MODIFIERS_rec.benefit_uom_code OR
2947: p_old_MODIFIERS_rec.benefit_uom_code IS NULL )
2948: THEN
2949: IF NOT QP_Validate.Benefit_Uom(p_MODIFIERS_rec.benefit_uom_code) THEN
2950: x_return_status := FND_API.G_RET_STS_ERROR;
2951: END IF;
2952: END IF;
2953:
2954: IF p_MODIFIERS_rec.accrual_conversion_rate IS NOT NULL AND

Line 2960: x_return_status := FND_API.G_RET_STS_ERROR;

2956: p_old_MODIFIERS_rec.accrual_conversion_rate OR
2957: p_old_MODIFIERS_rec.accrual_conversion_rate IS NULL )
2958: THEN
2959: IF NOT QP_Validate.Accrual_Conversion_Rate(p_MODIFIERS_rec.accrual_conversion_rate) THEN
2960: x_return_status := FND_API.G_RET_STS_ERROR;
2961: END IF;
2962: END IF;
2963:
2964: IF p_MODIFIERS_rec.proration_type_code IS NOT NULL AND

Line 2970: x_return_status := FND_API.G_RET_STS_ERROR;

2966: p_old_MODIFIERS_rec.proration_type_code OR
2967: p_old_MODIFIERS_rec.proration_type_code IS NULL )
2968: THEN
2969: IF NOT QP_Validate.Proration_Type(p_MODIFIERS_rec.proration_type_code) THEN
2970: x_return_status := FND_API.G_RET_STS_ERROR;
2971: END IF;
2972: END IF;
2973:
2974: IF p_MODIFIERS_rec.from_rltd_modifier_id IS NOT NULL AND

Line 2980: x_return_status := FND_API.G_RET_STS_ERROR;

2976: p_old_MODIFIERS_rec.from_rltd_modifier_id OR
2977: p_old_MODIFIERS_rec.from_rltd_modifier_id IS NULL )
2978: THEN
2979: IF NOT QP_Validate.From_Rltd_Modifier(p_MODIFIERS_rec.from_rltd_modifier_id) THEN
2980: x_return_status := FND_API.G_RET_STS_ERROR;
2981: END IF;
2982: END IF;
2983:
2984: IF p_MODIFIERS_rec.to_rltd_modifier_id IS NOT NULL AND

Line 2990: x_return_status := FND_API.G_RET_STS_ERROR;

2986: p_old_MODIFIERS_rec.to_rltd_modifier_id OR
2987: p_old_MODIFIERS_rec.to_rltd_modifier_id IS NULL )
2988: THEN
2989: IF NOT QP_Validate.To_Rltd_Modifier(p_MODIFIERS_rec.to_rltd_modifier_id) THEN
2990: x_return_status := FND_API.G_RET_STS_ERROR;
2991: END IF;
2992: END IF;
2993:
2994: IF p_MODIFIERS_rec.rltd_modifier_grp_no IS NOT NULL AND

Line 3000: x_return_status := FND_API.G_RET_STS_ERROR;

2996: p_old_MODIFIERS_rec.rltd_modifier_grp_no OR
2997: p_old_MODIFIERS_rec.rltd_modifier_grp_no IS NULL )
2998: THEN
2999: IF NOT QP_Validate.Rltd_Modifier_Grp_No(p_MODIFIERS_rec.rltd_modifier_grp_no) THEN
3000: x_return_status := FND_API.G_RET_STS_ERROR;
3001: END IF;
3002: END IF;
3003:
3004: IF p_MODIFIERS_rec.rltd_modifier_grp_type IS NOT NULL AND

Line 3010: x_return_status := FND_API.G_RET_STS_ERROR;

3006: p_old_MODIFIERS_rec.rltd_modifier_grp_type OR
3007: p_old_MODIFIERS_rec.rltd_modifier_grp_type IS NULL )
3008: THEN
3009: IF NOT QP_Validate.Rltd_Modifier_Grp_Type(p_MODIFIERS_rec.rltd_modifier_grp_type) THEN
3010: x_return_status := FND_API.G_RET_STS_ERROR;
3011: END IF;
3012: END IF;
3013:
3014: --Item Amount

Line 3021: x_return_status := FND_API.G_RET_STS_ERROR;

3017: p_old_MODIFIERS_rec.net_amount_flag OR
3018: p_old_MODIFIERS_rec.net_amount_flag IS NULL )
3019: THEN
3020: IF NOT QP_Validate.Net_Amount(p_MODIFIERS_rec.net_amount_flag) THEN
3021: x_return_status := FND_API.G_RET_STS_ERROR;
3022: END IF;
3023: END IF;
3024:
3025: -- Accumulation of range breaks

Line 3032: x_return_status := FND_API.G_RET_STS_ERROR;

3028: p_old_MODIFIERS_rec.accum_attribute OR
3029: p_old_MODIFIERS_rec.accum_attribute IS NULL )
3030: THEN
3031: IF NOT QP_Validate.Accum_Attribute(p_MODIFIERS_rec.accum_attribute) THEN
3032: x_return_status := FND_API.G_RET_STS_ERROR;
3033: END IF;
3034: END IF;
3035:
3036:

Line 3177: x_return_status := FND_API.G_RET_STS_ERROR;

3173:
3174: -- Validate descriptive flexfield.
3175:
3176: IF NOT QP_Validate.Desc_Flex( 'MODIFIERS' ) THEN
3177: x_return_status := FND_API.G_RET_STS_ERROR;
3178: END IF;
3179:
3180: END IF;
3181:

Line 3188: WHEN FND_API.G_EXC_ERROR THEN

3184: oe_debug_pub.add('END Attributes in QPXLMLLB');
3185:
3186: EXCEPTION
3187:
3188: WHEN FND_API.G_EXC_ERROR THEN
3189:
3190: x_return_status := FND_API.G_RET_STS_ERROR;
3191:
3192: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3190: x_return_status := FND_API.G_RET_STS_ERROR;

3186: EXCEPTION
3187:
3188: WHEN FND_API.G_EXC_ERROR THEN
3189:
3190: x_return_status := FND_API.G_RET_STS_ERROR;
3191:
3192: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3193:
3194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3192: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3188: WHEN FND_API.G_EXC_ERROR THEN
3189:
3190: x_return_status := FND_API.G_RET_STS_ERROR;
3191:
3192: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3193:
3194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3195:
3196: WHEN OTHERS THEN

Line 3194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3190: x_return_status := FND_API.G_RET_STS_ERROR;
3191:
3192: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3193:
3194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3195:
3196: WHEN OTHERS THEN
3197:
3198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3195:
3196: WHEN OTHERS THEN
3197:
3198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3199:
3200: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3201: THEN
3202: OE_MSG_PUB.Add_Exc_Msg

Line 3218: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

3214: ( x_return_status OUT NOCOPY VARCHAR2
3215: , p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
3216: )
3217: IS
3218: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3219: BEGIN
3220:
3221: oe_debug_pub.add('BEGIN Entity_Delete in QPXLMLLB');
3222:

Line 3242: WHEN FND_API.G_EXC_ERROR THEN

3238: oe_debug_pub.add('BEGIN Entity_Delete in QPXLMLLB');
3239:
3240: EXCEPTION
3241:
3242: WHEN FND_API.G_EXC_ERROR THEN
3243:
3244: x_return_status := FND_API.G_RET_STS_ERROR;
3245:
3246: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3244: x_return_status := FND_API.G_RET_STS_ERROR;

3240: EXCEPTION
3241:
3242: WHEN FND_API.G_EXC_ERROR THEN
3243:
3244: x_return_status := FND_API.G_RET_STS_ERROR;
3245:
3246: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3247:
3248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3246: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3242: WHEN FND_API.G_EXC_ERROR THEN
3243:
3244: x_return_status := FND_API.G_RET_STS_ERROR;
3245:
3246: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3247:
3248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3249:
3250: WHEN OTHERS THEN

Line 3248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3244: x_return_status := FND_API.G_RET_STS_ERROR;
3245:
3246: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3247:
3248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3249:
3250: WHEN OTHERS THEN
3251:
3252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3249:
3250: WHEN OTHERS THEN
3251:
3252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3253:
3254: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3255: THEN
3256: OE_MSG_PUB.Add_Exc_Msg