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 68: l_return_status := FND_API.G_RET_STS_ERROR;

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

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

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

Line 94: l_return_status := FND_API.G_RET_STS_ERROR;

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

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

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

Line 106: l_return_status := FND_API.G_RET_STS_ERROR;

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

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

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

Line 118: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 129: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 167: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 196: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 215: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 230: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 265: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 276: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 287: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 298: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 314: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 334: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 348: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 374: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 389: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 403: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 422: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 440: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 461: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 476: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 489: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 504: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 519: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 536: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 549: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 568: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 588: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 611: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 627: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 643: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 658: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 681: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 696: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 715: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 744: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 760: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 774: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 793: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 820: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 836: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 855: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 875: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 907: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 920: l_return_status := FND_API.G_RET_STS_ERROR;

916: End If;
917:
918: If (l_attribute_flag = 'N' AND l_error_code = 8) -- invalid attribute
919: Then
920: l_return_status := FND_API.G_RET_STS_ERROR;
921:
922: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
923: THEN
924:

Line 933: l_return_status := FND_API.G_RET_STS_ERROR;

929: End If;
930:
931: If (l_value_flag = 'N' AND l_error_code = 9) -- invalid value
932: Then
933: l_return_status := FND_API.G_RET_STS_ERROR;
934:
935: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
936: THEN
937:

Line 965: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 989: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1017: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1031: l_return_status := FND_API.G_RET_STS_ERROR;

1027: OR l_primary_list_line_type_code = 'PRG')
1028: AND p_MODIFIERS_rec.rltd_modifier_grp_type = 'BENEFIT')
1029: THEN
1030:
1031: l_return_status := FND_API.G_RET_STS_ERROR;
1032:
1033: FND_MESSAGE.SET_NAME('QP','QP_FORMULA_NOT_IN_GET');
1034: OE_MSG_PUB.Add;
1035:

Line 1053: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1083: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1099: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1118: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1139: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1158: l_return_status := FND_API.G_RET_STS_ERROR;

1154: p_MODIFIERS_rec.price_break_type_code = 'RECURRING'
1155:
1156: THEN
1157:
1158: l_return_status := FND_API.G_RET_STS_ERROR;
1159:
1160: FND_MESSAGE.SET_NAME('QP','QP_RECURRING_NOT_ALLOWED');
1161: OE_MSG_PUB.Add;
1162:

Line 1176: l_return_status := FND_API.G_RET_STS_ERROR;

1172: p_MODIFIERS_rec.arithmetic_operator <> 'LUMPSUM'
1173:
1174: THEN
1175:
1176: l_return_status := FND_API.G_RET_STS_ERROR;
1177:
1178: FND_MESSAGE.SET_NAME('QP','QP_LUMPSUM_RECUR_DIS_SUR');
1179: OE_MSG_PUB.Add;
1180:

Line 1194: l_return_status := FND_API.G_RET_STS_ERROR;

1190: p_MODIFIERS_rec.price_break_type_code <> 'RECURRING'
1191:
1192: THEN
1193:
1194: l_return_status := FND_API.G_RET_STS_ERROR;
1195:
1196: FND_MESSAGE.SET_NAME('QP','QP_BREAK_TYPE_POINT_OR_RECUR');
1197: OE_MSG_PUB.Add;
1198:

Line 1212: l_return_status := FND_API.G_RET_STS_ERROR;

1208: p_MODIFIERS_rec.price_break_type_code <> 'RANGE'
1209:
1210: THEN
1211:
1212: l_return_status := FND_API.G_RET_STS_ERROR;
1213:
1214: FND_MESSAGE.SET_NAME('QP','QP_BREAK_TYPE_POINT_OR_RANGE');
1215: OE_MSG_PUB.Add;
1216:

Line 1230: l_return_status := FND_API.G_RET_STS_ERROR;

1226: p_MODIFIERS_rec.price_break_type_code = 'RECURRING'
1227:
1228: THEN
1229:
1230: l_return_status := FND_API.G_RET_STS_ERROR;
1231:
1232: FND_MESSAGE.SET_NAME('QP','QP_RECURRING_NOT_ALLOWED');
1233: OE_MSG_PUB.Add;
1234:

Line 1256: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1278: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1306: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1335: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1353: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1376: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1400: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1417: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1434: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1481: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1505: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1532: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1552: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1576: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1610: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1631: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1659: l_return_status := FND_API.G_RET_STS_ERROR;

1655: p_MODIFIERS_rec.pricing_phase_id IS NULL
1656: THEN
1657:
1658: --dbms_output.put_line('phase is mand');
1659: l_return_status := FND_API.G_RET_STS_ERROR;
1660:
1661: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
1662: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Phase');
1663: OE_MSG_PUB.Add;

Line 1676: l_return_status := FND_API.G_RET_STS_ERROR;

1672: AND p_MODIFIERS_rec.pricing_phase_id IS NULL
1673: THEN
1674:
1675: --dbms_output.put_line('phase is mand');
1676: l_return_status := FND_API.G_RET_STS_ERROR;
1677:
1678: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
1679: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Phase');
1680: OE_MSG_PUB.Add;

Line 1703: l_return_status := FND_API.G_RET_STS_ERROR;

1699: AND PRICING_PHASE_ID = p_MODIFIERS_rec.pricing_phase_id;
1700:
1701: EXCEPTION
1702: WHEN NO_DATA_FOUND THEN
1703: l_return_status := FND_API.G_RET_STS_ERROR;
1704:
1705: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PHASE');
1706: OE_MSG_PUB.Add;
1707:

Line 1723: l_return_status := FND_API.G_RET_STS_ERROR;

1719: WHERE PRICING_PHASE_ID = p_MODIFIERS_rec.pricing_phase_id
1720: AND nvl(MODIFIER_LEVEL_CODE, '*') <> 'LINE';
1721: EXCEPTION
1722: WHEN NO_DATA_FOUND THEN */
1723: l_return_status := FND_API.G_RET_STS_ERROR;
1724: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PHASE_RLTD');
1725: OE_MSG_PUB.Add;
1726: -- END;
1727: END IF;

Line 1745: l_return_status := FND_API.G_RET_STS_ERROR;

1741: WHEN NO_DATA_FOUND THEN
1742: l_rltd_exist := 'N';
1743: END;
1744: IF l_rltd_exist = 'Y' THEN
1745: l_return_status := FND_API.G_RET_STS_ERROR;
1746: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PHASE_RLTD');
1747: OE_MSG_PUB.Add;
1748: END IF;
1749: END IF;

Line 1765: l_return_status := FND_API.G_RET_STS_ERROR;

1761: NULL;
1762: end;
1763:
1764: IF l_phase_price_evt = 'Y' THEN
1765: l_return_status := FND_API.G_RET_STS_ERROR;
1766:
1767: FND_MESSAGE.SET_NAME('QP','QP_PHASE_PRICE_EVT_ERROR');
1768: OE_MSG_PUB.Add;
1769:

Line 1787: l_return_status := FND_API.G_RET_STS_ERROR;

1783: NULL;
1784: end;
1785:
1786: IF l_phase_freeze_set = 'Y' THEN
1787: l_return_status := FND_API.G_RET_STS_ERROR;
1788:
1789: FND_MESSAGE.SET_NAME('QP','QP_PHASE_FREEZE_ERROR');
1790: OE_MSG_PUB.Add;
1791:

Line 1801: l_return_status := FND_API.G_RET_STS_ERROR;

1797: IF l_gsa_indicator = 'Y'
1798: AND l_phase_sequence <> 10
1799: THEN
1800:
1801: l_return_status := FND_API.G_RET_STS_ERROR;
1802:
1803: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PHASE');
1804: OE_MSG_PUB.Add;
1805:

Line 1830: l_return_status := FND_API.G_RET_STS_ERROR;

1826: THEN
1827:
1828:
1829: oe_debug_pub.add('list line type code invalid');
1830: l_return_status := FND_API.G_RET_STS_ERROR;
1831:
1832: FND_MESSAGE.SET_NAME('QP','QP_ACCRUALS_NOT_ALLOWED');
1833: OE_MSG_PUB.Add;
1834:

Line 1843: l_return_status := FND_API.G_RET_STS_ERROR;

1839: IF l_gsa_indicator = 'Y'
1840: AND p_MODIFIERS_rec.accrual_flag = 'Y'
1841: THEN
1842:
1843: l_return_status := FND_API.G_RET_STS_ERROR;
1844:
1845: FND_MESSAGE.SET_NAME('QP','QP_ACCRUALS_NOT_ALLOWED');
1846: OE_MSG_PUB.Add;
1847:

Line 1857: l_return_status := FND_API.G_RET_STS_ERROR;

1853: AND p_MODIFIERS_rec.accrual_flag <> 'Y'
1854:
1855: THEN
1856:
1857: l_return_status := FND_API.G_RET_STS_ERROR;
1858:
1859: FND_MESSAGE.SET_NAME('QP','QP_ACCRUALS_MAND_FOR_CIE');
1860: OE_MSG_PUB.Add;
1861:

Line 1881: l_return_status := FND_API.G_RET_STS_ERROR;

1877: OR p_MODIFIERS_rec.accrual_conversion_rate IS NOT NULL )
1878: AND p_MODIFIERS_rec.accrual_flag = 'N')
1879: THEN
1880:
1881: l_return_status := FND_API.G_RET_STS_ERROR;
1882:
1883: FND_MESSAGE.SET_NAME('QP','QP_ACCRUAL_COLUMNS');
1884: OE_MSG_PUB.Add;
1885:

Line 1899: l_return_status := FND_API.G_RET_STS_ERROR;

1895:
1896: THEN
1897:
1898: oe_debug_pub.add('list line type code invalid');
1899: l_return_status := FND_API.G_RET_STS_ERROR;
1900:
1901: FND_MESSAGE.SET_NAME('QP','QP_ACCRUALS_FOR_DIS_ONLY');
1902:
1903: OE_MSG_PUB.Add;

Line 1920: l_return_status := FND_API.G_RET_STS_ERROR;

1916: THEN
1917:
1918:
1919: oe_debug_pub.add('proration 11111');
1920: l_return_status := FND_API.G_RET_STS_ERROR;
1921:
1922: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
1923: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRORATION_TYPE_CODE')); -- Fix For Bug-1974413
1924: OE_MSG_PUB.Add;

Line 1934: l_return_status := FND_API.G_RET_STS_ERROR;

1930: IF l_gsa_indicator = 'Y'
1931: AND p_MODIFIERS_rec.proration_type_code <> 'N'
1932: THEN
1933:
1934: l_return_status := FND_API.G_RET_STS_ERROR;
1935:
1936: FND_MESSAGE.SET_NAME('QP','QP_GSA_PRORATION_ALWAYS_N');
1937: OE_MSG_PUB.Add;
1938:

Line 1950: l_return_status := FND_API.G_RET_STS_ERROR;

1946: THEN
1947:
1948:
1949: oe_debug_pub.add('list line type code invalid');
1950: l_return_status := FND_API.G_RET_STS_ERROR;
1951:
1952: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
1953: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRORATION_TYPE_CODE')); -- Fix For Bug-1974413
1954: OE_MSG_PUB.Add;

Line 1968: l_return_status := FND_API.G_RET_STS_ERROR;

1964: AND p_MODIFIERS_rec.proration_type_code IS NULL
1965: THEN
1966:
1967: oe_debug_pub.add('proration 22222');
1968: l_return_status := FND_API.G_RET_STS_ERROR;
1969:
1970: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
1971: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRORATION_TYPE_CODE')); -- Fix For Bug-1974413
1972: OE_MSG_PUB.Add;

Line 1985: l_return_status := FND_API.G_RET_STS_ERROR;

1981: AND p_MODIFIERS_rec.rltd_modifier_grp_type IS NOT NULL
1982: AND p_MODIFIERS_rec.proration_type_code IS NULL
1983: THEN
1984:
1985: l_return_status := FND_API.G_RET_STS_ERROR;
1986:
1987: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
1988: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRORATION_TYPE_CODE')); -- Fix For Bug-1974413
1989: OE_MSG_PUB.Add;

Line 2000: l_return_status := FND_API.G_RET_STS_ERROR;

1996: AND p_MODIFIERS_rec.list_line_type_code <> 'DIS'
1997: AND p_MODIFIERS_rec.list_line_type_code <> 'PRG'
1998: THEN
1999:
2000: l_return_status := FND_API.G_RET_STS_ERROR;
2001:
2002: FND_MESSAGE.SET_NAME('QP','QP_CIE_CHILD_DIS_OR_PRG');
2003: OE_MSG_PUB.Add;
2004:

Line 2018: l_return_status := FND_API.G_RET_STS_ERROR;

2014: AND p_MODIFIERS_rec.list_line_type_code <> 'DIS'
2015: AND p_MODIFIERS_rec.list_line_type_code <> 'SUR'
2016: THEN
2017:
2018: l_return_status := FND_API.G_RET_STS_ERROR;
2019:
2020: FND_MESSAGE.SET_NAME('QP','QP_PBH_CHILD_DIS_OR_SUR');
2021: OE_MSG_PUB.Add;
2022:

Line 2040: l_return_status := FND_API.G_RET_STS_ERROR;

2036: p_MODIFIERS_rec.automatic_flag = 'Y' AND
2037: p_MODIFIERS_rec.pricing_group_sequence IS NULL
2038: THEN
2039:
2040: l_return_status := FND_API.G_RET_STS_ERROR;
2041:
2042: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
2043: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Bucket');
2044: OE_MSG_PUB.Add;

Line 2055: l_return_status := FND_API.G_RET_STS_ERROR;

2051: IF l_gsa_indicator = 'Y'
2052: AND p_MODIFIERS_rec.pricing_group_sequence <> 1
2053: THEN
2054:
2055: l_return_status := FND_API.G_RET_STS_ERROR;
2056:
2057: FND_MESSAGE.SET_NAME('QP','QP_GSA_BUCKET_VALUE_1');
2058: OE_MSG_PUB.Add;
2059:

Line 2073: l_return_status := FND_API.G_RET_STS_ERROR;

2069: AND p_MODIFIERS_rec.pricing_group_sequence IS NULL
2070: THEN
2071:
2072: --dbms_output.put_line('phase is mand');
2073: l_return_status := FND_API.G_RET_STS_ERROR;
2074:
2075: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
2076: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Bucket');
2077: OE_MSG_PUB.Add;

Line 2095: l_return_status := FND_API.G_RET_STS_ERROR;

2091: fnd_profile.value ('QP_MANUAL_MODIFIER_BUCKET') <> 'Y'
2092: )
2093: THEN
2094:
2095: l_return_status := FND_API.G_RET_STS_ERROR;
2096:
2097: FND_MESSAGE.SET_NAME('QP','QP_MANUAL_DIS_BUCKET_NULL');
2098: OE_MSG_PUB.Add;
2099:

Line 2110: l_return_status := FND_API.G_RET_STS_ERROR;

2106: AND p_MODIFIERS_rec.incompatibility_grp_code IS NOT NULL
2107: AND p_MODIFIERS_rec.incompatibility_grp_code <> 'LVL 1'
2108: THEN
2109:
2110: l_return_status := FND_API.G_RET_STS_ERROR;
2111:
2112: FND_MESSAGE.SET_NAME('QP','QP_GSA_INCOMP_ALWAYS_LVL1');
2113: OE_MSG_PUB.Add;
2114:

Line 2122: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2118: oe_debug_pub.add('here10');
2119: END IF; -- If list_line_type_code <> 'PMR'
2120: -- Return Error if a required attribute is missing.
2121:
2122: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2123:
2124: oe_debug_pub.add('before raise');
2125: RAISE FND_API.G_EXC_ERROR;
2126:

Line 2125: RAISE FND_API.G_EXC_ERROR;

2121:
2122: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2123:
2124: oe_debug_pub.add('before raise');
2125: RAISE FND_API.G_EXC_ERROR;
2126:
2127: END IF;
2128:
2129: IF p_MODIFIERS_rec.accum_attribute IS NOT NULL THEN

Line 2138: l_return_status := FND_API.G_RET_STS_ERROR;

2134: ,p_error_code => l_error_code);
2135:
2136: IF (l_error_code <> 0 ) -- invalid context
2137: THEN
2138: l_return_status := FND_API.G_RET_STS_ERROR;
2139:
2140: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2141: THEN
2142:

Line 2187: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2183: , p_param6 => NULL
2184: , x_return_status => l_return_status
2185: );
2186:
2187: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2188:
2189: oe_debug_pub.add('failed in logging delayed request for Duplicate Modifiers ');
2190:
2191: RAISE FND_API.G_EXC_ERROR;

Line 2191: RAISE FND_API.G_EXC_ERROR;

2187: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2188:
2189: oe_debug_pub.add('failed in logging delayed request for Duplicate Modifiers ');
2190:
2191: RAISE FND_API.G_EXC_ERROR;
2192:
2193: END IF;
2194:
2195: oe_debug_pub.add('after logging delayed request ');

Line 2206: WHEN FND_API.G_EXC_ERROR THEN

2202: oe_debug_pub.add('END Entity in QPXLMLLB');
2203:
2204: EXCEPTION
2205:
2206: WHEN FND_API.G_EXC_ERROR THEN
2207:
2208: oe_debug_pub.add('EXP error');
2209: x_return_status := FND_API.G_RET_STS_ERROR;
2210:

Line 2209: x_return_status := FND_API.G_RET_STS_ERROR;

2205:
2206: WHEN FND_API.G_EXC_ERROR THEN
2207:
2208: oe_debug_pub.add('EXP error');
2209: x_return_status := FND_API.G_RET_STS_ERROR;
2210:
2211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2212:
2213: oe_debug_pub.add('EXP unexpected');

Line 2211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2207:
2208: oe_debug_pub.add('EXP error');
2209: x_return_status := FND_API.G_RET_STS_ERROR;
2210:
2211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2212:
2213: oe_debug_pub.add('EXP unexpected');
2214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2215:

Line 2214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2210:
2211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2212:
2213: oe_debug_pub.add('EXP unexpected');
2214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2215:
2216: WHEN OTHERS THEN
2217:
2218: oe_debug_pub.add('EXP others');

Line 2220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2216: WHEN OTHERS THEN
2217:
2218: oe_debug_pub.add('EXP others');
2219: oe_debug_pub.add('error =' || sqlerrm);
2220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2221:
2222: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2223: THEN
2224: OE_MSG_PUB.Add_Exc_Msg

Line 2244: x_return_status := FND_API.G_RET_STS_SUCCESS;

2240: IS
2241: BEGIN
2242:
2243: oe_debug_pub.add('BEGIN Attributes in QPXLMLLB');
2244: x_return_status := FND_API.G_RET_STS_SUCCESS;
2245:
2246: /* changes to fix bug # 1724169 */
2247:
2248: IF FND_PROFILE.VALUE('QP_NEGATIVE_PRICING') = 'N' AND p_MODIFIERS_rec.operand < 0 THEN

Line 2251: x_return_status := FND_API.G_RET_STS_ERROR;

2247:
2248: IF FND_PROFILE.VALUE('QP_NEGATIVE_PRICING') = 'N' AND p_MODIFIERS_rec.operand < 0 THEN
2249: FND_MESSAGE.SET_NAME('QP','OE_PR_NEGATIVE_AMOUNT');
2250: OE_MSG_PUB.Add;
2251: x_return_status := FND_API.G_RET_STS_ERROR;
2252: END IF;
2253:
2254:
2255:

Line 2264: x_return_status := FND_API.G_RET_STS_ERROR;

2260: p_old_MODIFIERS_rec.arithmetic_operator OR
2261: p_old_MODIFIERS_rec.arithmetic_operator IS NULL )
2262: THEN
2263: IF NOT QP_Validate.Arithmetic_Operator(p_MODIFIERS_rec.arithmetic_operator) THEN
2264: x_return_status := FND_API.G_RET_STS_ERROR;
2265: END IF;
2266: END IF;
2267: oe_debug_pub.add('here3');
2268:

Line 2275: x_return_status := FND_API.G_RET_STS_ERROR;

2271: p_old_MODIFIERS_rec.automatic_flag OR
2272: p_old_MODIFIERS_rec.automatic_flag IS NULL )
2273: THEN
2274: IF NOT QP_Validate.Automatic(p_MODIFIERS_rec.automatic_flag) THEN
2275: x_return_status := FND_API.G_RET_STS_ERROR;
2276: END IF;
2277: END IF;
2278:
2279: /* IF p_MODIFIERS_rec.base_qty IS NOT NULL AND

Line 2285: x_return_status := FND_API.G_RET_STS_ERROR;

2281: p_old_MODIFIERS_rec.base_qty OR
2282: p_old_MODIFIERS_rec.base_qty IS NULL )
2283: THEN
2284: IF NOT QP_Validate.Base_Qty(p_MODIFIERS_rec.base_qty) THEN
2285: x_return_status := FND_API.G_RET_STS_ERROR;
2286: END IF;
2287: END IF;
2288: */
2289: IF p_MODIFIERS_rec.pricing_phase_id IS NOT NULL AND

Line 2295: x_return_status := FND_API.G_RET_STS_ERROR;

2291: p_old_MODIFIERS_rec.pricing_phase_id OR
2292: p_old_MODIFIERS_rec.pricing_phase_id IS NULL )
2293: THEN
2294: IF NOT QP_Validate.Pricing_Phase(p_MODIFIERS_rec.pricing_phase_id) THEN
2295: x_return_status := FND_API.G_RET_STS_ERROR;
2296: END IF;
2297: END IF;
2298:
2299: oe_debug_pub.add('here4');

Line 2306: x_return_status := FND_API.G_RET_STS_ERROR;

2302: p_old_MODIFIERS_rec.base_uom_code OR
2303: p_old_MODIFIERS_rec.base_uom_code IS NULL )
2304: THEN
2305: IF NOT QP_Validate.Base_Uom(p_MODIFIERS_rec.base_uom_code) THEN
2306: x_return_status := FND_API.G_RET_STS_ERROR;
2307: END IF;
2308: END IF;
2309: */
2310: IF p_MODIFIERS_rec.comments IS NOT NULL AND

Line 2316: x_return_status := FND_API.G_RET_STS_ERROR;

2312: p_old_MODIFIERS_rec.comments OR
2313: p_old_MODIFIERS_rec.comments IS NULL )
2314: THEN
2315: IF NOT QP_Validate.Comments(p_MODIFIERS_rec.comments) THEN
2316: x_return_status := FND_API.G_RET_STS_ERROR;
2317: END IF;
2318: END IF;
2319:
2320: IF p_MODIFIERS_rec.created_by IS NOT NULL AND

Line 2326: x_return_status := FND_API.G_RET_STS_ERROR;

2322: p_old_MODIFIERS_rec.created_by OR
2323: p_old_MODIFIERS_rec.created_by IS NULL )
2324: THEN
2325: IF NOT QP_Validate.Created_By(p_MODIFIERS_rec.created_by) THEN
2326: x_return_status := FND_API.G_RET_STS_ERROR;
2327: END IF;
2328: END IF;
2329:
2330: IF p_MODIFIERS_rec.creation_date IS NOT NULL AND

Line 2336: x_return_status := FND_API.G_RET_STS_ERROR;

2332: p_old_MODIFIERS_rec.creation_date OR
2333: p_old_MODIFIERS_rec.creation_date IS NULL )
2334: THEN
2335: IF NOT QP_Validate.Creation_Date(p_MODIFIERS_rec.creation_date) THEN
2336: x_return_status := FND_API.G_RET_STS_ERROR;
2337: END IF;
2338: END IF;
2339:
2340: IF p_MODIFIERS_rec.effective_period_uom IS NOT NULL AND

Line 2346: x_return_status := FND_API.G_RET_STS_ERROR;

2342: p_old_MODIFIERS_rec.effective_period_uom OR
2343: p_old_MODIFIERS_rec.effective_period_uom IS NULL )
2344: THEN
2345: IF NOT QP_Validate.Effective_Period_Uom(p_MODIFIERS_rec.effective_period_uom) THEN
2346: x_return_status := FND_API.G_RET_STS_ERROR;
2347: END IF;
2348: END IF;
2349:
2350: IF p_MODIFIERS_rec.end_date_active IS NOT NULL AND

Line 2356: x_return_status := FND_API.G_RET_STS_ERROR;

2352: p_old_MODIFIERS_rec.end_date_active OR
2353: p_old_MODIFIERS_rec.end_date_active IS NULL )
2354: THEN
2355: IF NOT QP_Validate.End_Date_Active(p_MODIFIERS_rec.end_date_active) THEN
2356: x_return_status := FND_API.G_RET_STS_ERROR;
2357: END IF;
2358: END IF;
2359:
2360: IF p_MODIFIERS_rec.estim_accrual_rate IS NOT NULL AND

Line 2366: x_return_status := FND_API.G_RET_STS_ERROR;

2362: p_old_MODIFIERS_rec.estim_accrual_rate OR
2363: p_old_MODIFIERS_rec.estim_accrual_rate IS NULL )
2364: THEN
2365: IF NOT QP_Validate.Estim_Accrual_Rate(p_MODIFIERS_rec.estim_accrual_rate) THEN
2366: x_return_status := FND_API.G_RET_STS_ERROR;
2367: END IF;
2368: END IF;
2369:
2370: IF p_MODIFIERS_rec.generate_using_formula_id IS NOT NULL AND

Line 2376: x_return_status := FND_API.G_RET_STS_ERROR;

2372: p_old_MODIFIERS_rec.generate_using_formula_id OR
2373: p_old_MODIFIERS_rec.generate_using_formula_id IS NULL )
2374: THEN
2375: IF NOT QP_Validate.Generate_Using_Formula(p_MODIFIERS_rec.generate_using_formula_id) THEN
2376: x_return_status := FND_API.G_RET_STS_ERROR;
2377: END IF;
2378: END IF;
2379:
2380: /* IF p_MODIFIERS_rec.gl_class_id IS NOT NULL AND

Line 2386: x_return_status := FND_API.G_RET_STS_ERROR;

2382: p_old_MODIFIERS_rec.gl_class_id OR
2383: p_old_MODIFIERS_rec.gl_class_id IS NULL )
2384: THEN
2385: IF NOT QP_Validate.Gl_Class(p_MODIFIERS_rec.gl_class_id) THEN
2386: x_return_status := FND_API.G_RET_STS_ERROR;
2387: END IF;
2388: END IF;
2389: */
2390: IF p_MODIFIERS_rec.inventory_item_id IS NOT NULL AND

Line 2396: x_return_status := FND_API.G_RET_STS_ERROR;

2392: p_old_MODIFIERS_rec.inventory_item_id OR
2393: p_old_MODIFIERS_rec.inventory_item_id IS NULL )
2394: THEN
2395: IF NOT QP_Validate.Inventory_Item(p_MODIFIERS_rec.inventory_item_id) THEN
2396: x_return_status := FND_API.G_RET_STS_ERROR;
2397: END IF;
2398: END IF;
2399:
2400: IF p_MODIFIERS_rec.last_updated_by IS NOT NULL AND

Line 2406: x_return_status := FND_API.G_RET_STS_ERROR;

2402: p_old_MODIFIERS_rec.last_updated_by OR
2403: p_old_MODIFIERS_rec.last_updated_by IS NULL )
2404: THEN
2405: IF NOT QP_Validate.Last_Updated_By(p_MODIFIERS_rec.last_updated_by) THEN
2406: x_return_status := FND_API.G_RET_STS_ERROR;
2407: END IF;
2408: END IF;
2409:
2410: IF p_MODIFIERS_rec.last_update_date IS NOT NULL AND

Line 2416: x_return_status := FND_API.G_RET_STS_ERROR;

2412: p_old_MODIFIERS_rec.last_update_date OR
2413: p_old_MODIFIERS_rec.last_update_date IS NULL )
2414: THEN
2415: IF NOT QP_Validate.Last_Update_Date(p_MODIFIERS_rec.last_update_date) THEN
2416: x_return_status := FND_API.G_RET_STS_ERROR;
2417: END IF;
2418: END IF;
2419:
2420: IF p_MODIFIERS_rec.last_update_login IS NOT NULL AND

Line 2426: x_return_status := FND_API.G_RET_STS_ERROR;

2422: p_old_MODIFIERS_rec.last_update_login OR
2423: p_old_MODIFIERS_rec.last_update_login IS NULL )
2424: THEN
2425: IF NOT QP_Validate.Last_Update_Login(p_MODIFIERS_rec.last_update_login) THEN
2426: x_return_status := FND_API.G_RET_STS_ERROR;
2427: END IF;
2428: END IF;
2429:
2430: oe_debug_pub.add('here5');

Line 2437: x_return_status := FND_API.G_RET_STS_ERROR;

2433: p_old_MODIFIERS_rec.list_header_id OR
2434: p_old_MODIFIERS_rec.list_header_id IS NULL )
2435: THEN
2436: IF NOT QP_Validate.List_Header(p_MODIFIERS_rec.list_header_id) THEN
2437: x_return_status := FND_API.G_RET_STS_ERROR;
2438: END IF;
2439: END IF;
2440:
2441: IF p_MODIFIERS_rec.list_line_id IS NOT NULL AND

Line 2447: x_return_status := FND_API.G_RET_STS_ERROR;

2443: p_old_MODIFIERS_rec.list_line_id OR
2444: p_old_MODIFIERS_rec.list_line_id IS NULL )
2445: THEN
2446: IF NOT QP_Validate.List_Line(p_MODIFIERS_rec.list_line_id) THEN
2447: x_return_status := FND_API.G_RET_STS_ERROR;
2448: END IF;
2449: END IF;
2450:
2451: IF p_MODIFIERS_rec.list_line_type_code IS NOT NULL AND

Line 2457: x_return_status := FND_API.G_RET_STS_ERROR;

2453: p_old_MODIFIERS_rec.list_line_type_code OR
2454: p_old_MODIFIERS_rec.list_line_type_code IS NULL )
2455: THEN
2456: IF NOT QP_Validate.List_Line_Type(p_MODIFIERS_rec.list_line_type_code) THEN
2457: x_return_status := FND_API.G_RET_STS_ERROR;
2458: END IF;
2459: END IF;
2460:
2461: IF p_MODIFIERS_rec.list_price IS NOT NULL AND

Line 2467: x_return_status := FND_API.G_RET_STS_ERROR;

2463: p_old_MODIFIERS_rec.list_price OR
2464: p_old_MODIFIERS_rec.list_price IS NULL )
2465: THEN
2466: IF NOT QP_Validate.List_Price(p_MODIFIERS_rec.list_price) THEN
2467: x_return_status := FND_API.G_RET_STS_ERROR;
2468: END IF;
2469: END IF;
2470:
2471: /* IF p_MODIFIERS_rec.list_price_uom_code IS NOT NULL AND

Line 2477: x_return_status := FND_API.G_RET_STS_ERROR;

2473: p_old_MODIFIERS_rec.list_price_uom_code OR
2474: p_old_MODIFIERS_rec.list_price_uom_code IS NULL )
2475: THEN
2476: IF NOT QP_Validate.List_Price_Uom(p_MODIFIERS_rec.list_price_uom_code) THEN
2477: x_return_status := FND_API.G_RET_STS_ERROR;
2478: END IF;
2479: END IF;
2480: */
2481: IF p_MODIFIERS_rec.modifier_level_code IS NOT NULL AND

Line 2487: x_return_status := FND_API.G_RET_STS_ERROR;

2483: p_old_MODIFIERS_rec.modifier_level_code OR
2484: p_old_MODIFIERS_rec.modifier_level_code IS NULL )
2485: THEN
2486: IF NOT QP_Validate.Modifier_Level(p_MODIFIERS_rec.modifier_level_code) THEN
2487: x_return_status := FND_API.G_RET_STS_ERROR;
2488: END IF;
2489: END IF;
2490:
2491: /* IF p_MODIFIERS_rec.new_price IS NOT NULL AND

Line 2497: x_return_status := FND_API.G_RET_STS_ERROR;

2493: p_old_MODIFIERS_rec.new_price OR
2494: p_old_MODIFIERS_rec.new_price IS NULL )
2495: THEN
2496: IF NOT QP_Validate.New_Price(p_MODIFIERS_rec.new_price) THEN
2497: x_return_status := FND_API.G_RET_STS_ERROR;
2498: END IF;
2499: END IF;
2500: */
2501: IF p_MODIFIERS_rec.number_effective_periods IS NOT NULL AND

Line 2507: x_return_status := FND_API.G_RET_STS_ERROR;

2503: p_old_MODIFIERS_rec.number_effective_periods OR
2504: p_old_MODIFIERS_rec.number_effective_periods IS NULL )
2505: THEN
2506: IF NOT QP_Validate.Number_Effective_Periods(p_MODIFIERS_rec.number_effective_periods) THEN
2507: x_return_status := FND_API.G_RET_STS_ERROR;
2508: END IF;
2509: END IF;
2510:
2511: oe_debug_pub.add('here6');

Line 2520: x_return_status := FND_API.G_RET_STS_ERROR;

2516: THEN
2517: oe_debug_pub.add('here7');
2518: IF NOT QP_Validate.Operand(p_MODIFIERS_rec.operand) THEN
2519: oe_debug_pub.add('here8');
2520: x_return_status := FND_API.G_RET_STS_ERROR;
2521: END IF;
2522: END IF;
2523:
2524: oe_debug_pub.add('here9');

Line 2531: x_return_status := FND_API.G_RET_STS_ERROR;

2527: p_old_MODIFIERS_rec.organization_id OR
2528: p_old_MODIFIERS_rec.organization_id IS NULL )
2529: THEN
2530: IF NOT QP_Validate.Organization(p_MODIFIERS_rec.organization_id) THEN
2531: x_return_status := FND_API.G_RET_STS_ERROR;
2532: END IF;
2533: END IF;
2534:
2535: oe_debug_pub.add('here10');

Line 2542: x_return_status := FND_API.G_RET_STS_ERROR;

2538: p_old_MODIFIERS_rec.override_flag OR
2539: p_old_MODIFIERS_rec.override_flag IS NULL )
2540: THEN
2541: IF NOT QP_Validate.Override(p_MODIFIERS_rec.override_flag) THEN
2542: x_return_status := FND_API.G_RET_STS_ERROR;
2543: END IF;
2544: END IF;
2545:
2546: oe_debug_pub.add('here11');

Line 2553: x_return_status := FND_API.G_RET_STS_ERROR;

2549: p_old_MODIFIERS_rec.percent_price OR
2550: p_old_MODIFIERS_rec.percent_price IS NULL )
2551: THEN
2552: IF NOT QP_Validate.Percent_Price(p_MODIFIERS_rec.percent_price) THEN
2553: x_return_status := FND_API.G_RET_STS_ERROR;
2554: END IF;
2555: END IF;
2556:
2557: IF p_MODIFIERS_rec.price_break_type_code IS NOT NULL AND

Line 2563: x_return_status := FND_API.G_RET_STS_ERROR;

2559: p_old_MODIFIERS_rec.price_break_type_code OR
2560: p_old_MODIFIERS_rec.price_break_type_code IS NULL )
2561: THEN
2562: IF NOT QP_Validate.Price_Break_Type(p_MODIFIERS_rec.price_break_type_code) THEN
2563: x_return_status := FND_API.G_RET_STS_ERROR;
2564: END IF;
2565: END IF;
2566:
2567: IF p_MODIFIERS_rec.price_by_formula_id IS NOT NULL AND

Line 2573: x_return_status := FND_API.G_RET_STS_ERROR;

2569: p_old_MODIFIERS_rec.price_by_formula_id OR
2570: p_old_MODIFIERS_rec.price_by_formula_id IS NULL )
2571: THEN
2572: IF NOT QP_Validate.Price_By_Formula(p_MODIFIERS_rec.price_by_formula_id) THEN
2573: x_return_status := FND_API.G_RET_STS_ERROR;
2574: END IF;
2575: END IF;
2576:
2577: IF p_MODIFIERS_rec.primary_uom_flag IS NOT NULL AND

Line 2583: x_return_status := FND_API.G_RET_STS_ERROR;

2579: p_old_MODIFIERS_rec.primary_uom_flag OR
2580: p_old_MODIFIERS_rec.primary_uom_flag IS NULL )
2581: THEN
2582: IF NOT QP_Validate.Primary_Uom(p_MODIFIERS_rec.primary_uom_flag) THEN
2583: x_return_status := FND_API.G_RET_STS_ERROR;
2584: END IF;
2585: END IF;
2586:
2587: IF p_MODIFIERS_rec.print_on_invoice_flag IS NOT NULL AND

Line 2593: x_return_status := FND_API.G_RET_STS_ERROR;

2589: p_old_MODIFIERS_rec.print_on_invoice_flag OR
2590: p_old_MODIFIERS_rec.print_on_invoice_flag IS NULL )
2591: THEN
2592: IF NOT QP_Validate.Print_On_Invoice(p_MODIFIERS_rec.print_on_invoice_flag) THEN
2593: x_return_status := FND_API.G_RET_STS_ERROR;
2594: END IF;
2595: END IF;
2596:
2597: IF p_MODIFIERS_rec.program_application_id IS NOT NULL AND

Line 2603: x_return_status := FND_API.G_RET_STS_ERROR;

2599: p_old_MODIFIERS_rec.program_application_id OR
2600: p_old_MODIFIERS_rec.program_application_id IS NULL )
2601: THEN
2602: IF NOT QP_Validate.Program_Application(p_MODIFIERS_rec.program_application_id) THEN
2603: x_return_status := FND_API.G_RET_STS_ERROR;
2604: END IF;
2605: END IF;
2606:
2607: IF p_MODIFIERS_rec.program_id IS NOT NULL AND

Line 2613: x_return_status := FND_API.G_RET_STS_ERROR;

2609: p_old_MODIFIERS_rec.program_id OR
2610: p_old_MODIFIERS_rec.program_id IS NULL )
2611: THEN
2612: IF NOT QP_Validate.Program(p_MODIFIERS_rec.program_id) THEN
2613: x_return_status := FND_API.G_RET_STS_ERROR;
2614: END IF;
2615: END IF;
2616:
2617: IF p_MODIFIERS_rec.program_update_date IS NOT NULL AND

Line 2623: x_return_status := FND_API.G_RET_STS_ERROR;

2619: p_old_MODIFIERS_rec.program_update_date OR
2620: p_old_MODIFIERS_rec.program_update_date IS NULL )
2621: THEN
2622: IF NOT QP_Validate.Program_Update_Date(p_MODIFIERS_rec.program_update_date) THEN
2623: x_return_status := FND_API.G_RET_STS_ERROR;
2624: END IF;
2625: END IF;
2626:
2627: /* IF p_MODIFIERS_rec.rebate_subtype_code IS NOT NULL AND

Line 2633: x_return_status := FND_API.G_RET_STS_ERROR;

2629: p_old_MODIFIERS_rec.rebate_subtype_code OR
2630: p_old_MODIFIERS_rec.rebate_subtype_code IS NULL )
2631: THEN
2632: IF NOT QP_Validate.Rebate_Subtype(p_MODIFIERS_rec.rebate_subtype_code) THEN
2633: x_return_status := FND_API.G_RET_STS_ERROR;
2634: END IF;
2635: END IF;
2636: */
2637: IF p_MODIFIERS_rec.rebate_trxn_type_code IS NOT NULL AND

Line 2643: x_return_status := FND_API.G_RET_STS_ERROR;

2639: p_old_MODIFIERS_rec.rebate_trxn_type_code OR
2640: p_old_MODIFIERS_rec.rebate_trxn_type_code IS NULL )
2641: THEN
2642: IF NOT QP_Validate.Rebate_Transaction_Type(p_MODIFIERS_rec.rebate_trxn_type_code) THEN
2643: x_return_status := FND_API.G_RET_STS_ERROR;
2644: END IF;
2645: END IF;
2646:
2647: IF p_MODIFIERS_rec.related_item_id IS NOT NULL AND

Line 2653: x_return_status := FND_API.G_RET_STS_ERROR;

2649: p_old_MODIFIERS_rec.related_item_id OR
2650: p_old_MODIFIERS_rec.related_item_id IS NULL )
2651: THEN
2652: IF NOT QP_Validate.Related_Item(p_MODIFIERS_rec.related_item_id) THEN
2653: x_return_status := FND_API.G_RET_STS_ERROR;
2654: END IF;
2655: END IF;
2656:
2657: IF p_MODIFIERS_rec.relationship_type_id IS NOT NULL AND

Line 2663: x_return_status := FND_API.G_RET_STS_ERROR;

2659: p_old_MODIFIERS_rec.relationship_type_id OR
2660: p_old_MODIFIERS_rec.relationship_type_id IS NULL )
2661: THEN
2662: IF NOT QP_Validate.Relationship_Type(p_MODIFIERS_rec.relationship_type_id) THEN
2663: x_return_status := FND_API.G_RET_STS_ERROR;
2664: END IF;
2665: END IF;
2666:
2667: IF p_MODIFIERS_rec.reprice_flag IS NOT NULL AND

Line 2673: x_return_status := FND_API.G_RET_STS_ERROR;

2669: p_old_MODIFIERS_rec.reprice_flag OR
2670: p_old_MODIFIERS_rec.reprice_flag IS NULL )
2671: THEN
2672: IF NOT QP_Validate.Reprice(p_MODIFIERS_rec.reprice_flag) THEN
2673: x_return_status := FND_API.G_RET_STS_ERROR;
2674: END IF;
2675: END IF;
2676:
2677: IF p_MODIFIERS_rec.request_id IS NOT NULL AND

Line 2683: x_return_status := FND_API.G_RET_STS_ERROR;

2679: p_old_MODIFIERS_rec.request_id OR
2680: p_old_MODIFIERS_rec.request_id IS NULL )
2681: THEN
2682: IF NOT QP_Validate.Request(p_MODIFIERS_rec.request_id) THEN
2683: x_return_status := FND_API.G_RET_STS_ERROR;
2684: END IF;
2685: END IF;
2686:
2687: IF p_MODIFIERS_rec.revision IS NOT NULL AND

Line 2693: x_return_status := FND_API.G_RET_STS_ERROR;

2689: p_old_MODIFIERS_rec.revision OR
2690: p_old_MODIFIERS_rec.revision IS NULL )
2691: THEN
2692: IF NOT QP_Validate.Revision(p_MODIFIERS_rec.revision) THEN
2693: x_return_status := FND_API.G_RET_STS_ERROR;
2694: END IF;
2695: END IF;
2696:
2697: IF p_MODIFIERS_rec.revision_date IS NOT NULL AND

Line 2703: x_return_status := FND_API.G_RET_STS_ERROR;

2699: p_old_MODIFIERS_rec.revision_date OR
2700: p_old_MODIFIERS_rec.revision_date IS NULL )
2701: THEN
2702: IF NOT QP_Validate.Revision_Date(p_MODIFIERS_rec.revision_date) THEN
2703: x_return_status := FND_API.G_RET_STS_ERROR;
2704: END IF;
2705: END IF;
2706:
2707: IF p_MODIFIERS_rec.revision_reason_code IS NOT NULL AND

Line 2713: x_return_status := FND_API.G_RET_STS_ERROR;

2709: p_old_MODIFIERS_rec.revision_reason_code OR
2710: p_old_MODIFIERS_rec.revision_reason_code IS NULL )
2711: THEN
2712: IF NOT QP_Validate.Revision_Reason(p_MODIFIERS_rec.revision_reason_code) THEN
2713: x_return_status := FND_API.G_RET_STS_ERROR;
2714: END IF;
2715: END IF;
2716:
2717: IF p_MODIFIERS_rec.start_date_active IS NOT NULL AND

Line 2723: x_return_status := FND_API.G_RET_STS_ERROR;

2719: p_old_MODIFIERS_rec.start_date_active OR
2720: p_old_MODIFIERS_rec.start_date_active IS NULL )
2721: THEN
2722: IF NOT QP_Validate.Start_Date_Active(p_MODIFIERS_rec.start_date_active) THEN
2723: x_return_status := FND_API.G_RET_STS_ERROR;
2724: END IF;
2725: END IF;
2726:
2727: IF p_MODIFIERS_rec.substitution_attribute IS NOT NULL AND

Line 2733: x_return_status := FND_API.G_RET_STS_ERROR;

2729: p_old_MODIFIERS_rec.substitution_attribute OR
2730: p_old_MODIFIERS_rec.substitution_attribute IS NULL )
2731: THEN
2732: IF NOT QP_Validate.Substitution_Attribute(p_MODIFIERS_rec.substitution_attribute) THEN
2733: x_return_status := FND_API.G_RET_STS_ERROR;
2734: END IF;
2735: END IF;
2736:
2737: IF p_MODIFIERS_rec.substitution_context IS NOT NULL AND

Line 2743: x_return_status := FND_API.G_RET_STS_ERROR;

2739: p_old_MODIFIERS_rec.substitution_context OR
2740: p_old_MODIFIERS_rec.substitution_context IS NULL )
2741: THEN
2742: IF NOT QP_Validate.Substitution_Context(p_MODIFIERS_rec.substitution_context) THEN
2743: x_return_status := FND_API.G_RET_STS_ERROR;
2744: END IF;
2745: END IF;
2746:
2747: IF p_MODIFIERS_rec.substitution_value IS NOT NULL AND

Line 2753: x_return_status := FND_API.G_RET_STS_ERROR;

2749: p_old_MODIFIERS_rec.substitution_value OR
2750: p_old_MODIFIERS_rec.substitution_value IS NULL )
2751: THEN
2752: IF NOT QP_Validate.Substitution_Value(p_MODIFIERS_rec.substitution_value) THEN
2753: x_return_status := FND_API.G_RET_STS_ERROR;
2754: END IF;
2755: END IF;
2756:
2757: IF p_MODIFIERS_rec.accrual_flag IS NOT NULL AND

Line 2763: x_return_status := FND_API.G_RET_STS_ERROR;

2759: p_old_MODIFIERS_rec.accrual_flag OR
2760: p_old_MODIFIERS_rec.accrual_flag IS NULL )
2761: THEN
2762: IF NOT QP_Validate.Accrual_Flag(p_MODIFIERS_rec.accrual_flag) THEN
2763: x_return_status := FND_API.G_RET_STS_ERROR;
2764: END IF;
2765: END IF;
2766:
2767: IF p_MODIFIERS_rec.pricing_group_sequence IS NOT NULL AND

Line 2773: x_return_status := FND_API.G_RET_STS_ERROR;

2769: p_old_MODIFIERS_rec.pricing_group_sequence OR
2770: p_old_MODIFIERS_rec.pricing_group_sequence IS NULL )
2771: THEN
2772: IF NOT QP_Validate.Pricing_Group_Sequence(p_MODIFIERS_rec.pricing_group_sequence) THEN
2773: x_return_status := FND_API.G_RET_STS_ERROR;
2774: END IF;
2775: END IF;
2776: oe_debug_pub.add('here12');
2777: IF p_MODIFIERS_rec.incompatibility_grp_code IS NOT NULL AND

Line 2783: x_return_status := FND_API.G_RET_STS_ERROR;

2779: p_old_MODIFIERS_rec.incompatibility_grp_code OR
2780: p_old_MODIFIERS_rec.incompatibility_grp_code IS NULL )
2781: THEN
2782: IF NOT QP_Validate.Incompatibility_Grp_Code(p_MODIFIERS_rec.incompatibility_grp_code) THEN
2783: x_return_status := FND_API.G_RET_STS_ERROR;
2784: END IF;
2785: END IF;
2786:
2787: oe_debug_pub.add('here13');

Line 2794: x_return_status := FND_API.G_RET_STS_ERROR;

2790: p_old_MODIFIERS_rec.list_line_no OR
2791: p_old_MODIFIERS_rec.list_line_no IS NULL )
2792: THEN
2793: IF NOT QP_Validate.List_Line_No(p_MODIFIERS_rec.list_line_no) THEN
2794: x_return_status := FND_API.G_RET_STS_ERROR;
2795: END IF;
2796: END IF;
2797:
2798: IF p_MODIFIERS_rec.product_precedence IS NOT NULL AND

Line 2804: x_return_status := FND_API.G_RET_STS_ERROR;

2800: p_old_MODIFIERS_rec.product_precedence OR
2801: p_old_MODIFIERS_rec.product_precedence IS NULL )
2802: THEN
2803: IF NOT QP_Validate.Product_Precedence(p_MODIFIERS_rec.product_precedence) THEN
2804: x_return_status := FND_API.G_RET_STS_ERROR;
2805: END IF;
2806: END IF;
2807:
2808: IF p_MODIFIERS_rec.expiration_period_start_date IS NOT NULL AND

Line 2814: x_return_status := FND_API.G_RET_STS_ERROR;

2810: p_old_MODIFIERS_rec.expiration_period_start_date OR
2811: p_old_MODIFIERS_rec.expiration_period_start_date IS NULL )
2812: THEN
2813: IF NOT QP_Validate.Exp_Period_Start_Date(p_MODIFIERS_rec.expiration_period_start_date) THEN
2814: x_return_status := FND_API.G_RET_STS_ERROR;
2815: END IF;
2816: END IF;
2817:
2818: IF p_MODIFIERS_rec.number_expiration_periods IS NOT NULL AND

Line 2824: x_return_status := FND_API.G_RET_STS_ERROR;

2820: p_old_MODIFIERS_rec.number_expiration_periods OR
2821: p_old_MODIFIERS_rec.number_expiration_periods IS NULL )
2822: THEN
2823: IF NOT QP_Validate.Number_Expiration_Periods(p_MODIFIERS_rec.number_expiration_periods) THEN
2824: x_return_status := FND_API.G_RET_STS_ERROR;
2825: END IF;
2826: END IF;
2827:
2828: IF p_MODIFIERS_rec.number_expiration_periods IS NOT NULL AND

Line 2834: x_return_status := FND_API.G_RET_STS_ERROR;

2830: p_old_MODIFIERS_rec.number_expiration_periods OR
2831: p_old_MODIFIERS_rec.number_expiration_periods IS NULL )
2832: THEN
2833: IF NOT QP_Validate.Number_Expiration_Periods(p_MODIFIERS_rec.number_expiration_periods) THEN
2834: x_return_status := FND_API.G_RET_STS_ERROR;
2835: END IF;
2836: END IF;
2837:
2838: IF p_MODIFIERS_rec.expiration_period_uom IS NOT NULL AND

Line 2844: x_return_status := FND_API.G_RET_STS_ERROR;

2840: p_old_MODIFIERS_rec.expiration_period_uom OR
2841: p_old_MODIFIERS_rec.expiration_period_uom IS NULL )
2842: THEN
2843: IF NOT QP_Validate.Expiration_Period_Uom(p_MODIFIERS_rec.expiration_period_uom) THEN
2844: x_return_status := FND_API.G_RET_STS_ERROR;
2845: END IF;
2846: END IF;
2847:
2848: IF p_MODIFIERS_rec.expiration_date IS NOT NULL AND

Line 2854: x_return_status := FND_API.G_RET_STS_ERROR;

2850: p_old_MODIFIERS_rec.expiration_date OR
2851: p_old_MODIFIERS_rec.expiration_date IS NULL )
2852: THEN
2853: IF NOT QP_Validate.Expiration_Date(p_MODIFIERS_rec.expiration_date) THEN
2854: x_return_status := FND_API.G_RET_STS_ERROR;
2855: END IF;
2856: END IF;
2857:
2858: IF p_MODIFIERS_rec.estim_gl_value IS NOT NULL AND

Line 2864: x_return_status := FND_API.G_RET_STS_ERROR;

2860: p_old_MODIFIERS_rec.estim_gl_value OR
2861: p_old_MODIFIERS_rec.estim_gl_value IS NULL )
2862: THEN
2863: IF NOT QP_Validate.Estim_Gl_Value(p_MODIFIERS_rec.estim_gl_value) THEN
2864: x_return_status := FND_API.G_RET_STS_ERROR;
2865: END IF;
2866: END IF;
2867:
2868: IF p_MODIFIERS_rec.benefit_price_list_line_id IS NOT NULL AND

Line 2874: x_return_status := FND_API.G_RET_STS_ERROR;

2870: p_old_MODIFIERS_rec.benefit_price_list_line_id OR
2871: p_old_MODIFIERS_rec.benefit_price_list_line_id IS NULL )
2872: THEN
2873: IF NOT QP_Validate.Ben_Price_List_Line(p_MODIFIERS_rec.benefit_price_list_line_id) THEN
2874: x_return_status := FND_API.G_RET_STS_ERROR;
2875: END IF;
2876: END IF;
2877:
2878: /* IF p_MODIFIERS_rec.recurring_flag IS NOT NULL AND

Line 2884: x_return_status := FND_API.G_RET_STS_ERROR;

2880: p_old_MODIFIERS_rec.recurring_flag OR
2881: p_old_MODIFIERS_rec.recurring_flag IS NULL )
2882: THEN
2883: IF NOT QP_Validate.Recurring(p_MODIFIERS_rec.recurring_flag) THEN
2884: x_return_status := FND_API.G_RET_STS_ERROR;
2885: END IF;
2886: END IF;
2887: */
2888: IF p_MODIFIERS_rec.benefit_limit IS NOT NULL AND

Line 2894: x_return_status := FND_API.G_RET_STS_ERROR;

2890: p_old_MODIFIERS_rec.benefit_limit OR
2891: p_old_MODIFIERS_rec.benefit_limit IS NULL )
2892: THEN
2893: IF NOT QP_Validate.Benefit_Limit(p_MODIFIERS_rec.benefit_limit) THEN
2894: x_return_status := FND_API.G_RET_STS_ERROR;
2895: END IF;
2896: END IF;
2897:
2898: IF p_MODIFIERS_rec.charge_type_code IS NOT NULL AND

Line 2904: x_return_status := FND_API.G_RET_STS_ERROR;

2900: p_old_MODIFIERS_rec.charge_type_code OR
2901: p_old_MODIFIERS_rec.charge_type_code IS NULL )
2902: THEN
2903: IF NOT QP_Validate.Charge_Type(p_MODIFIERS_rec.charge_type_code) THEN
2904: x_return_status := FND_API.G_RET_STS_ERROR;
2905: END IF;
2906: END IF;
2907:
2908: IF p_MODIFIERS_rec.charge_subtype_code IS NOT NULL AND

Line 2914: x_return_status := FND_API.G_RET_STS_ERROR;

2910: p_old_MODIFIERS_rec.charge_subtype_code OR
2911: p_old_MODIFIERS_rec.charge_subtype_code IS NULL )
2912: THEN
2913: IF NOT QP_Validate.Charge_Subtype(p_MODIFIERS_rec.charge_subtype_code) THEN
2914: x_return_status := FND_API.G_RET_STS_ERROR;
2915: END IF;
2916: END IF;
2917:
2918: IF p_MODIFIERS_rec.benefit_qty IS NOT NULL AND

Line 2924: x_return_status := FND_API.G_RET_STS_ERROR;

2920: p_old_MODIFIERS_rec.benefit_qty OR
2921: p_old_MODIFIERS_rec.benefit_qty IS NULL )
2922: THEN
2923: IF NOT QP_Validate.Benefit_Qty(p_MODIFIERS_rec.benefit_qty) THEN
2924: x_return_status := FND_API.G_RET_STS_ERROR;
2925: END IF;
2926: END IF;
2927:
2928: IF p_MODIFIERS_rec.benefit_uom_code IS NOT NULL AND

Line 2934: x_return_status := FND_API.G_RET_STS_ERROR;

2930: p_old_MODIFIERS_rec.benefit_uom_code OR
2931: p_old_MODIFIERS_rec.benefit_uom_code IS NULL )
2932: THEN
2933: IF NOT QP_Validate.Benefit_Uom(p_MODIFIERS_rec.benefit_uom_code) THEN
2934: x_return_status := FND_API.G_RET_STS_ERROR;
2935: END IF;
2936: END IF;
2937:
2938: IF p_MODIFIERS_rec.accrual_conversion_rate IS NOT NULL AND

Line 2944: x_return_status := FND_API.G_RET_STS_ERROR;

2940: p_old_MODIFIERS_rec.accrual_conversion_rate OR
2941: p_old_MODIFIERS_rec.accrual_conversion_rate IS NULL )
2942: THEN
2943: IF NOT QP_Validate.Accrual_Conversion_Rate(p_MODIFIERS_rec.accrual_conversion_rate) THEN
2944: x_return_status := FND_API.G_RET_STS_ERROR;
2945: END IF;
2946: END IF;
2947:
2948: IF p_MODIFIERS_rec.proration_type_code IS NOT NULL AND

Line 2954: x_return_status := FND_API.G_RET_STS_ERROR;

2950: p_old_MODIFIERS_rec.proration_type_code OR
2951: p_old_MODIFIERS_rec.proration_type_code IS NULL )
2952: THEN
2953: IF NOT QP_Validate.Proration_Type(p_MODIFIERS_rec.proration_type_code) THEN
2954: x_return_status := FND_API.G_RET_STS_ERROR;
2955: END IF;
2956: END IF;
2957:
2958: IF p_MODIFIERS_rec.from_rltd_modifier_id IS NOT NULL AND

Line 2964: x_return_status := FND_API.G_RET_STS_ERROR;

2960: p_old_MODIFIERS_rec.from_rltd_modifier_id OR
2961: p_old_MODIFIERS_rec.from_rltd_modifier_id IS NULL )
2962: THEN
2963: IF NOT QP_Validate.From_Rltd_Modifier(p_MODIFIERS_rec.from_rltd_modifier_id) THEN
2964: x_return_status := FND_API.G_RET_STS_ERROR;
2965: END IF;
2966: END IF;
2967:
2968: IF p_MODIFIERS_rec.to_rltd_modifier_id IS NOT NULL AND

Line 2974: x_return_status := FND_API.G_RET_STS_ERROR;

2970: p_old_MODIFIERS_rec.to_rltd_modifier_id OR
2971: p_old_MODIFIERS_rec.to_rltd_modifier_id IS NULL )
2972: THEN
2973: IF NOT QP_Validate.To_Rltd_Modifier(p_MODIFIERS_rec.to_rltd_modifier_id) THEN
2974: x_return_status := FND_API.G_RET_STS_ERROR;
2975: END IF;
2976: END IF;
2977:
2978: IF p_MODIFIERS_rec.rltd_modifier_grp_no IS NOT NULL AND

Line 2984: x_return_status := FND_API.G_RET_STS_ERROR;

2980: p_old_MODIFIERS_rec.rltd_modifier_grp_no OR
2981: p_old_MODIFIERS_rec.rltd_modifier_grp_no IS NULL )
2982: THEN
2983: IF NOT QP_Validate.Rltd_Modifier_Grp_No(p_MODIFIERS_rec.rltd_modifier_grp_no) THEN
2984: x_return_status := FND_API.G_RET_STS_ERROR;
2985: END IF;
2986: END IF;
2987:
2988: IF p_MODIFIERS_rec.rltd_modifier_grp_type IS NOT NULL AND

Line 2994: x_return_status := FND_API.G_RET_STS_ERROR;

2990: p_old_MODIFIERS_rec.rltd_modifier_grp_type OR
2991: p_old_MODIFIERS_rec.rltd_modifier_grp_type IS NULL )
2992: THEN
2993: IF NOT QP_Validate.Rltd_Modifier_Grp_Type(p_MODIFIERS_rec.rltd_modifier_grp_type) THEN
2994: x_return_status := FND_API.G_RET_STS_ERROR;
2995: END IF;
2996: END IF;
2997:
2998: --Item Amount

Line 3005: x_return_status := FND_API.G_RET_STS_ERROR;

3001: p_old_MODIFIERS_rec.net_amount_flag OR
3002: p_old_MODIFIERS_rec.net_amount_flag IS NULL )
3003: THEN
3004: IF NOT QP_Validate.Net_Amount(p_MODIFIERS_rec.net_amount_flag) THEN
3005: x_return_status := FND_API.G_RET_STS_ERROR;
3006: END IF;
3007: END IF;
3008:
3009: -- Accumulation of range breaks

Line 3016: x_return_status := FND_API.G_RET_STS_ERROR;

3012: p_old_MODIFIERS_rec.accum_attribute OR
3013: p_old_MODIFIERS_rec.accum_attribute IS NULL )
3014: THEN
3015: IF NOT QP_Validate.Accum_Attribute(p_MODIFIERS_rec.accum_attribute) THEN
3016: x_return_status := FND_API.G_RET_STS_ERROR;
3017: END IF;
3018: END IF;
3019:
3020:

Line 3161: x_return_status := FND_API.G_RET_STS_ERROR;

3157:
3158: -- Validate descriptive flexfield.
3159:
3160: IF NOT QP_Validate.Desc_Flex( 'MODIFIERS' ) THEN
3161: x_return_status := FND_API.G_RET_STS_ERROR;
3162: END IF;
3163:
3164: END IF;
3165:

Line 3172: WHEN FND_API.G_EXC_ERROR THEN

3168: oe_debug_pub.add('END Attributes in QPXLMLLB');
3169:
3170: EXCEPTION
3171:
3172: WHEN FND_API.G_EXC_ERROR THEN
3173:
3174: x_return_status := FND_API.G_RET_STS_ERROR;
3175:
3176: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3174: x_return_status := FND_API.G_RET_STS_ERROR;

3170: EXCEPTION
3171:
3172: WHEN FND_API.G_EXC_ERROR THEN
3173:
3174: x_return_status := FND_API.G_RET_STS_ERROR;
3175:
3176: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3177:
3178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3176: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3172: WHEN FND_API.G_EXC_ERROR THEN
3173:
3174: x_return_status := FND_API.G_RET_STS_ERROR;
3175:
3176: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3177:
3178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3179:
3180: WHEN OTHERS THEN

Line 3178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3174: x_return_status := FND_API.G_RET_STS_ERROR;
3175:
3176: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3177:
3178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3179:
3180: WHEN OTHERS THEN
3181:
3182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3179:
3180: WHEN OTHERS THEN
3181:
3182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3183:
3184: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3185: THEN
3186: OE_MSG_PUB.Add_Exc_Msg

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

3198: ( x_return_status OUT NOCOPY VARCHAR2
3199: , p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
3200: )
3201: IS
3202: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3203: BEGIN
3204:
3205: oe_debug_pub.add('BEGIN Entity_Delete in QPXLMLLB');
3206:

Line 3226: WHEN FND_API.G_EXC_ERROR THEN

3222: oe_debug_pub.add('BEGIN Entity_Delete in QPXLMLLB');
3223:
3224: EXCEPTION
3225:
3226: WHEN FND_API.G_EXC_ERROR THEN
3227:
3228: x_return_status := FND_API.G_RET_STS_ERROR;
3229:
3230: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3228: x_return_status := FND_API.G_RET_STS_ERROR;

3224: EXCEPTION
3225:
3226: WHEN FND_API.G_EXC_ERROR THEN
3227:
3228: x_return_status := FND_API.G_RET_STS_ERROR;
3229:
3230: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3231:
3232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3230: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3226: WHEN FND_API.G_EXC_ERROR THEN
3227:
3228: x_return_status := FND_API.G_RET_STS_ERROR;
3229:
3230: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3231:
3232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3233:
3234: WHEN OTHERS THEN

Line 3232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3228: x_return_status := FND_API.G_RET_STS_ERROR;
3229:
3230: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3231:
3232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3233:
3234: WHEN OTHERS THEN
3235:
3236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3233:
3234: WHEN OTHERS THEN
3235:
3236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3237:
3238: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3239: THEN
3240: OE_MSG_PUB.Add_Exc_Msg