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 OE_DEBUG_PUB

Line 54: oe_debug_pub.add('BEGIN Entity in QPXLMLLB');

50: benefit_qty_t VARCHAR2(240); --Bug 8474533
51:
52: BEGIN
53:
54: oe_debug_pub.add('BEGIN Entity in QPXLMLLB');
55:
56: -- Check whether Source System Code matches
57: -- mkarya for bug 1728764, Prevent update of Trade Management Data in QP
58: QP_UTIL.Check_Source_System_Code

Line 160: oe_debug_pub.add('11');

156:
157: END IF;
158:
159:
160: oe_debug_pub.add('11');
161:
162: /* List Line Type Code is mandatory and these are the types applicable for Modifiers */
163:
164: IF p_MODIFIERS_rec.list_line_type_code IS NULL

Line 167: oe_debug_pub.add('list line type code manda');

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

Line 196: oe_debug_pub.add('list line type code invalid');

192: p_MODIFIERS_rec.list_line_type_code <> 'IUE' )
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;

Line 215: oe_debug_pub.add('list line type code invalid');

211: p_MODIFIERS_rec.list_line_type_code <> 'FREIGHT_CHARGE')
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;

Line 357: oe_debug_pub.add('22');

353:
354: END IF;
355:
356: --dbms_output.put_line('1');
357: oe_debug_pub.add('22');
358:
359: /* Automatic Flag is mandatory for these Modifier types */
360:
361: IF ( p_MODIFIERS_rec.list_line_type_code = 'DIS' OR

Line 374: oe_debug_pub.add('auto flag mand');

370: p_MODIFIERS_rec.rltd_modifier_grp_type IS NULL AND
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

Line 389: oe_debug_pub.add('auto flag invalid');

385: AND p_MODIFIERS_rec.automatic_flag <> 'Y'
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;

Line 451: oe_debug_pub.add('33');

447:
448: END IF; -- list_line_type_code <> 'PMR'
449:
450: --dbms_output.put_line('2');
451: oe_debug_pub.add('33');
452:
453: /* Modifier Level Code is mandatory for all list lines except for Price Modifier and related*/
454:
455: IF p_MODIFIERS_rec.list_line_type_code <> 'PMR'

Line 461: oe_debug_pub.add('modifier level manda');

457: THEN
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

Line 489: oe_debug_pub.add('modifier level invalid');

485: p_MODIFIERS_rec.modifier_level_code <> 'ORDER' AND
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;

Line 568: oe_debug_pub.add('arith op mand');

564: p_MODIFIERS_rec.operand IS NULL AND
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

Line 579: oe_debug_pub.add('44');

575: END IF;
576:
577: /* Arithmetic Operator is mandatory for these Qualifier list lines */
578:
579: oe_debug_pub.add('44');
580: IF p_MODIFIERS_rec.list_line_type_code <> 'PMR' THEN
581: IF (p_MODIFIERS_rec.list_line_type_code = 'DIS' OR
582: p_MODIFIERS_rec.list_line_type_code = 'SUR' OR
583: p_MODIFIERS_rec.list_line_type_code = 'FREIGHT_CHARGE') AND

Line 588: oe_debug_pub.add('arith op mand');

584: p_MODIFIERS_rec.rltd_modifier_grp_type IS NULL AND
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

Line 599: oe_debug_pub.add('list line = '||p_MODIFIERS_rec.list_line_type_code);

595: END IF;
596:
597: /* Arithmetic Operator is mandatory for these Benefit list lines */
598:
599: oe_debug_pub.add('list line = '||p_MODIFIERS_rec.list_line_type_code);
600: oe_debug_pub.add('group type = '||p_MODIFIERS_rec.rltd_modifier_grp_type);
601: oe_debug_pub.add('arithme oper = '||p_MODIFIERS_rec.arithmetic_operator);
602:
603:

Line 600: oe_debug_pub.add('group type = '||p_MODIFIERS_rec.rltd_modifier_grp_type);

596:
597: /* Arithmetic Operator is mandatory for these Benefit list lines */
598:
599: oe_debug_pub.add('list line = '||p_MODIFIERS_rec.list_line_type_code);
600: oe_debug_pub.add('group type = '||p_MODIFIERS_rec.rltd_modifier_grp_type);
601: oe_debug_pub.add('arithme oper = '||p_MODIFIERS_rec.arithmetic_operator);
602:
603:
604: IF p_MODIFIERS_rec.list_line_type_code <> 'PRG' AND

Line 601: oe_debug_pub.add('arithme oper = '||p_MODIFIERS_rec.arithmetic_operator);

597: /* Arithmetic Operator is mandatory for these Benefit list lines */
598:
599: oe_debug_pub.add('list line = '||p_MODIFIERS_rec.list_line_type_code);
600: oe_debug_pub.add('group type = '||p_MODIFIERS_rec.rltd_modifier_grp_type);
601: oe_debug_pub.add('arithme oper = '||p_MODIFIERS_rec.arithmetic_operator);
602:
603:
604: IF p_MODIFIERS_rec.list_line_type_code <> 'PRG' AND
605: p_MODIFIERS_rec.list_line_type_code <> 'RLTD' AND

Line 611: oe_debug_pub.add('arith op mand');

607: p_MODIFIERS_rec.rltd_modifier_grp_type IS NOT NULL AND
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

Line 627: oe_debug_pub.add('arith op mand');

623: p_MODIFIERS_rec.modifier_level_code = 'ORDER' AND
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;

Line 658: oe_debug_pub.add('arith op mand');

654: p_MODIFIERS_rec.modifier_level_code = 'ORDER' AND
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;

Line 668: oe_debug_pub.add('list line = '||p_MODIFIERS_rec.list_line_type_code);

664: END IF;
665:
666: /* Operand is mandatory for these Benefit list lines */
667:
668: oe_debug_pub.add('list line = '||p_MODIFIERS_rec.list_line_type_code);
669: oe_debug_pub.add('group type = '||p_MODIFIERS_rec.rltd_modifier_grp_type);
670: oe_debug_pub.add('operand = '||to_char(p_MODIFIERS_rec.operand));
671: oe_debug_pub.add('formula = '||to_char(p_MODIFIERS_rec.price_by_formula_id));
672:

Line 669: oe_debug_pub.add('group type = '||p_MODIFIERS_rec.rltd_modifier_grp_type);

665:
666: /* Operand is mandatory for these Benefit list lines */
667:
668: oe_debug_pub.add('list line = '||p_MODIFIERS_rec.list_line_type_code);
669: oe_debug_pub.add('group type = '||p_MODIFIERS_rec.rltd_modifier_grp_type);
670: oe_debug_pub.add('operand = '||to_char(p_MODIFIERS_rec.operand));
671: oe_debug_pub.add('formula = '||to_char(p_MODIFIERS_rec.price_by_formula_id));
672:
673: IF p_MODIFIERS_rec.list_line_type_code <> 'PRG' AND

Line 670: oe_debug_pub.add('operand = '||to_char(p_MODIFIERS_rec.operand));

666: /* Operand is mandatory for these Benefit list lines */
667:
668: oe_debug_pub.add('list line = '||p_MODIFIERS_rec.list_line_type_code);
669: oe_debug_pub.add('group type = '||p_MODIFIERS_rec.rltd_modifier_grp_type);
670: oe_debug_pub.add('operand = '||to_char(p_MODIFIERS_rec.operand));
671: oe_debug_pub.add('formula = '||to_char(p_MODIFIERS_rec.price_by_formula_id));
672:
673: IF p_MODIFIERS_rec.list_line_type_code <> 'PRG' AND
674: p_MODIFIERS_rec.list_line_type_code <> 'RLTD' AND

Line 671: oe_debug_pub.add('formula = '||to_char(p_MODIFIERS_rec.price_by_formula_id));

667:
668: oe_debug_pub.add('list line = '||p_MODIFIERS_rec.list_line_type_code);
669: oe_debug_pub.add('group type = '||p_MODIFIERS_rec.rltd_modifier_grp_type);
670: oe_debug_pub.add('operand = '||to_char(p_MODIFIERS_rec.operand));
671: oe_debug_pub.add('formula = '||to_char(p_MODIFIERS_rec.price_by_formula_id));
672:
673: IF p_MODIFIERS_rec.list_line_type_code <> 'PRG' AND
674: p_MODIFIERS_rec.list_line_type_code <> 'RLTD' AND
675: p_MODIFIERS_rec.list_line_type_code <> 'CIE' AND

Line 681: oe_debug_pub.add('arith op mand');

677: p_MODIFIERS_rec.operand IS NULL AND
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

Line 715: oe_debug_pub.add('arith op invalid');

711: p_MODIFIERS_rec.arithmetic_operator <> 'BLOCK_PRICE' AND
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;

Line 744: oe_debug_pub.add('list line type code invalid');

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

Line 760: oe_debug_pub.add('override flag invalid');

756: p_MODIFIERS_rec.override_flag <> 'Y' AND
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;

Line 821: oe_debug_pub.add('list line type code invalid');

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

Line 837: oe_debug_pub.add('print flag invalid');

833: p_MODIFIERS_rec.print_on_invoice_flag <> 'Y' AND
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;

Line 858: oe_debug_pub.add('start date after end date');

854: IF nvl( p_MODIFIERS_rec.start_date_active,to_date('01/01/1951','mm/dd/yyyy')) >
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;

Line 878: oe_debug_pub.add('sub con, attr, value mand');

874: OR p_MODIFIERS_rec.substitution_attribute IS NULL
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');

Line 887: oe_debug_pub.add('before valida subs');

883: OE_MSG_PUB.Add;
884:
885: END IF;
886:
887: oe_debug_pub.add('before valida subs');
888: oe_debug_pub.add('context = '||p_MODIFIERS_rec.substitution_context);
889: oe_debug_pub.add('attr = '||p_MODIFIERS_rec.substitution_attribute);
890: oe_debug_pub.add('value = '||p_MODIFIERS_rec.substitution_value);
891:

Line 888: oe_debug_pub.add('context = '||p_MODIFIERS_rec.substitution_context);

884:
885: END IF;
886:
887: oe_debug_pub.add('before valida subs');
888: oe_debug_pub.add('context = '||p_MODIFIERS_rec.substitution_context);
889: oe_debug_pub.add('attr = '||p_MODIFIERS_rec.substitution_attribute);
890: oe_debug_pub.add('value = '||p_MODIFIERS_rec.substitution_value);
891:
892: /* Validating the Substitution Context, Attribute and Value */

Line 889: oe_debug_pub.add('attr = '||p_MODIFIERS_rec.substitution_attribute);

885: END IF;
886:
887: oe_debug_pub.add('before valida subs');
888: oe_debug_pub.add('context = '||p_MODIFIERS_rec.substitution_context);
889: oe_debug_pub.add('attr = '||p_MODIFIERS_rec.substitution_attribute);
890: oe_debug_pub.add('value = '||p_MODIFIERS_rec.substitution_value);
891:
892: /* Validating the Substitution Context, Attribute and Value */
893:

Line 890: oe_debug_pub.add('value = '||p_MODIFIERS_rec.substitution_value);

886:
887: oe_debug_pub.add('before valida subs');
888: oe_debug_pub.add('context = '||p_MODIFIERS_rec.substitution_context);
889: oe_debug_pub.add('attr = '||p_MODIFIERS_rec.substitution_attribute);
890: oe_debug_pub.add('value = '||p_MODIFIERS_rec.substitution_value);
891:
892: /* Validating the Substitution Context, Attribute and Value */
893:
894: QP_UTIL.validate_qp_flexfield(flexfield_name =>'QP_ATTR_DEFNS_QUALIFIER'

Line 907: oe_debug_pub.add('error code = '||to_char(l_error_code));

903: ,precedence =>l_precedence
904: ,error_code =>l_error_code
905: );
906:
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;

Line 954: oe_debug_pub.add('inven item = '|| p_MODIFIERS_rec.inventory_item_id);

950: --dbms_output.put_line('7');
951:
952: /* Inventory Item Id, Organization Id, Related Item Id and Relationship Type are mandatory for list line typr of Item Upgrade */
953:
954: oe_debug_pub.add('inven item = '|| p_MODIFIERS_rec.inventory_item_id);
955: oe_debug_pub.add('org = '|| p_MODIFIERS_rec.organization_id);
956: oe_debug_pub.add('related item = '|| p_MODIFIERS_rec.related_item_id);
957: oe_debug_pub.add('relate = '|| p_MODIFIERS_rec.relationship_type_id);
958:

Line 955: oe_debug_pub.add('org = '|| p_MODIFIERS_rec.organization_id);

951:
952: /* Inventory Item Id, Organization Id, Related Item Id and Relationship Type are mandatory for list line typr of Item Upgrade */
953:
954: oe_debug_pub.add('inven item = '|| p_MODIFIERS_rec.inventory_item_id);
955: oe_debug_pub.add('org = '|| p_MODIFIERS_rec.organization_id);
956: oe_debug_pub.add('related item = '|| p_MODIFIERS_rec.related_item_id);
957: oe_debug_pub.add('relate = '|| p_MODIFIERS_rec.relationship_type_id);
958:
959: IF p_MODIFIERS_rec.list_line_type_code = 'IUE'

Line 956: oe_debug_pub.add('related item = '|| p_MODIFIERS_rec.related_item_id);

952: /* Inventory Item Id, Organization Id, Related Item Id and Relationship Type are mandatory for list line typr of Item Upgrade */
953:
954: oe_debug_pub.add('inven item = '|| p_MODIFIERS_rec.inventory_item_id);
955: oe_debug_pub.add('org = '|| p_MODIFIERS_rec.organization_id);
956: oe_debug_pub.add('related item = '|| p_MODIFIERS_rec.related_item_id);
957: oe_debug_pub.add('relate = '|| p_MODIFIERS_rec.relationship_type_id);
958:
959: IF p_MODIFIERS_rec.list_line_type_code = 'IUE'
960: THEN

Line 957: oe_debug_pub.add('relate = '|| p_MODIFIERS_rec.relationship_type_id);

953:
954: oe_debug_pub.add('inven item = '|| p_MODIFIERS_rec.inventory_item_id);
955: oe_debug_pub.add('org = '|| p_MODIFIERS_rec.organization_id);
956: oe_debug_pub.add('related item = '|| p_MODIFIERS_rec.related_item_id);
957: oe_debug_pub.add('relate = '|| p_MODIFIERS_rec.relationship_type_id);
958:
959: IF p_MODIFIERS_rec.list_line_type_code = 'IUE'
960: THEN
961:

Line 968: oe_debug_pub.add('itm , org, related item and rrelationship type manda');

964: OR p_MODIFIERS_rec.related_item_id IS NULL
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');

Line 991: oe_debug_pub.add('item upgrade data is invalid');

987: and relationship_type_id = 14;
988:
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');

Line 1004: oe_debug_pub.add('55');

1000: END IF;
1001:
1002: END IF; --list_line_type_code = 'IUE'
1003:
1004: oe_debug_pub.add('55');
1005: --dbms_output.put_line('55');
1006:
1007: --dbms_output.put_line('8');
1008:

Line 1056: oe_debug_pub.add('arith oper % or AMT invalid');

1052: AND p_MODIFIERS_rec.arithmetic_operator <> 'NEWPRICE'
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;

Line 1085: oe_debug_pub.add('formula id is invalid');

1081: */
1082: EXCEPTION
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');

Line 1110: oe_debug_pub.add('77');

1106: OE_MSG_PUB.Add;
1107: END IF;
1108: */
1109:
1110: oe_debug_pub.add('77');
1111: END IF; --If list_line_type_code <> 'PMR'
1112:
1113: /* Price Break Type Code is mandatory for list line type of Price Break Header */
1114:

Line 1121: oe_debug_pub.add('price brek type is manda');

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

Line 1142: oe_debug_pub.add('price brek type can be point or range');

1138: AND p_MODIFIERS_rec.price_break_type_code <> 'RANGE'
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;

Line 1243: oe_debug_pub.add('88');

1239: END IF;
1240: END IF; --list_line_type_code <> 'PMR'
1241:
1242: --dbms_output.put_line('11');
1243: oe_debug_pub.add('88');
1244:
1245: /* Product Precedence is mandatory for the Primary discount lines of type Other Item Discount, Price Break Header and Item Upgrade */
1246:
1247: IF p_MODIFIERS_rec.list_line_type_code <> 'PMR'

Line 1258: oe_debug_pub.add('prece 11 ');

1254:
1255: IF p_MODIFIERS_rec.product_precedence IS NULL
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');

Line 1272: oe_debug_pub.add('99');

1268: END IF;
1269:
1270: END IF;
1271:
1272: oe_debug_pub.add('99');
1273:
1274: /* Benefit Price List is mandatory for the benefit DIS line of PRG */
1275: oe_debug_pub.add('benefit = '||to_char( p_MODIFIERS_rec.benefit_price_list_line_id));
1276:

Line 1275: oe_debug_pub.add('benefit = '||to_char( p_MODIFIERS_rec.benefit_price_list_line_id));

1271:
1272: oe_debug_pub.add('99');
1273:
1274: /* Benefit Price List is mandatory for the benefit DIS line of PRG */
1275: oe_debug_pub.add('benefit = '||to_char( p_MODIFIERS_rec.benefit_price_list_line_id));
1276:
1277: IF p_MODIFIERS_rec.list_line_type_code = 'DIS'
1278: AND l_primary_list_line_type_code = 'PRG'
1279: AND p_MODIFIERS_rec.benefit_price_list_line_id IS NULL

Line 1295: oe_debug_pub.add('benefit = '||to_char( p_MODIFIERS_rec.benefit_price_list_line_id));

1291: /* jhkuo (2853657,2862465): PRG benefit price list lines now cannot be based on any service items
1292: or any price break headers (and child lines).
1293: */
1294:
1295: oe_debug_pub.add('benefit = '||to_char( p_MODIFIERS_rec.benefit_price_list_line_id));
1296:
1297: IF l_primary_list_line_type_code = 'PRG'
1298: AND p_MODIFIERS_rec.benefit_price_list_line_id IS NOT NULL
1299: THEN

Line 1520: oe_debug_pub.add('here9');

1516: END IF;
1517:
1518: END IF;
1519:
1520: oe_debug_pub.add('here9');
1521: /* If Discount is a Primary line with accrual, then if benefit quantity is entered, benefit UOM must be enetered and vice-versa */
1522:
1523: IF ((p_MODIFIERS_rec.list_line_type_code = 'DIS'
1524: OR p_MODIFIERS_rec.list_line_type_code = 'CIE' )

Line 1654: oe_debug_pub.add('here95');

1650: END IF;
1651:
1652: /* Phase is mandatory for these Primary Modifier types */
1653:
1654: oe_debug_pub.add('here95');
1655: IF ( p_MODIFIERS_rec.list_line_type_code = 'OID' OR
1656: p_MODIFIERS_rec.list_line_type_code = 'SUR' OR
1657: p_MODIFIERS_rec.list_line_type_code = 'PRG' OR
1658: p_MODIFIERS_rec.list_line_type_code = 'DIS' OR

Line 1823: oe_debug_pub.add('line type = '||p_MODIFIERS_rec.list_line_type_code);

1819:
1820:
1821: /* Accrual not allowed for these Modifier types */
1822:
1823: oe_debug_pub.add('line type = '||p_MODIFIERS_rec.list_line_type_code);
1824: oe_debug_pub.add('accrual flag = '||p_MODIFIERS_rec.accrual_flag);
1825:
1826: IF ( p_MODIFIERS_rec.list_line_type_code = 'OID' OR
1827: p_MODIFIERS_rec.list_line_type_code = 'SUR' OR

Line 1824: oe_debug_pub.add('accrual flag = '||p_MODIFIERS_rec.accrual_flag);

1820:
1821: /* Accrual not allowed for these Modifier types */
1822:
1823: oe_debug_pub.add('line type = '||p_MODIFIERS_rec.list_line_type_code);
1824: oe_debug_pub.add('accrual flag = '||p_MODIFIERS_rec.accrual_flag);
1825:
1826: IF ( p_MODIFIERS_rec.list_line_type_code = 'OID' OR
1827: p_MODIFIERS_rec.list_line_type_code = 'SUR' OR
1828: p_MODIFIERS_rec.list_line_type_code = 'PRG' OR

Line 1839: oe_debug_pub.add('list line type code invalid');

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

Line 1876: oe_debug_pub.add('HERE');

1872: END IF;
1873:
1874: /* Accrual flag must be Y when accrual related fields are entered
1875:
1876: oe_debug_pub.add('HERE');
1877: oe_debug_pub.add('exp date = '||to_char(p_MODIFIERS_rec.expiration_date));
1878:
1879: IF (( p_MODIFIERS_rec.benefit_qty IS NOT NULL
1880: OR p_MODIFIERS_rec.benefit_uom_code IS NOT NULL

Line 1877: oe_debug_pub.add('exp date = '||to_char(p_MODIFIERS_rec.expiration_date));

1873:
1874: /* Accrual flag must be Y when accrual related fields are entered
1875:
1876: oe_debug_pub.add('HERE');
1877: oe_debug_pub.add('exp date = '||to_char(p_MODIFIERS_rec.expiration_date));
1878:
1879: IF (( p_MODIFIERS_rec.benefit_qty IS NOT NULL
1880: OR p_MODIFIERS_rec.benefit_uom_code IS NOT NULL
1881: OR p_MODIFIERS_rec.expiration_date IS NOT NULL

Line 1908: oe_debug_pub.add('list line type code invalid');

1904: p_MODIFIERS_rec.list_line_type_code <> 'DIS'
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:

Line 1929: oe_debug_pub.add('proration 11111');

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

Line 1959: oe_debug_pub.add('list line type code invalid');

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

Line 1977: oe_debug_pub.add('proration 22222');

1973: OR l_primary_list_line_type_code = 'PRG')
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

Line 2128: oe_debug_pub.add('here10');

2124:
2125: END IF;
2126:
2127:
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

Line 2134: oe_debug_pub.add('before raise');

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

Line 2180: oe_debug_pub.add('about to log a request to check duplicate modifier list lines ');

2176:
2177: IF (fnd_profile.value('QP_ALLOW_DUPLICATE_MODIFIERS') <> 'Y'
2178: AND (l_qp_status = 'S' OR l_gsa_indicator = 'Y')) THEN
2179:
2180: oe_debug_pub.add('about to log a request to check duplicate modifier list lines ');
2181:
2182: QP_DELAYED_REQUESTS_PVT.Log_Request
2183: ( p_entity_code => QP_GLOBALS.G_ENTITY_ALL
2184: , p_entity_id => p_modifiers_rec.list_line_id

Line 2199: oe_debug_pub.add('failed in logging delayed request for Duplicate Modifiers ');

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

Line 2205: oe_debug_pub.add('after logging delayed request ');

2201: RAISE FND_API.G_EXC_ERROR;
2202:
2203: END IF;
2204:
2205: oe_debug_pub.add('after logging delayed request ');
2206:
2207: END IF;
2208:
2209: -- end bug2091362

Line 2212: oe_debug_pub.add('END Entity in QPXLMLLB');

2208:
2209: -- end bug2091362
2210:
2211:
2212: oe_debug_pub.add('END Entity in QPXLMLLB');
2213:
2214: EXCEPTION
2215:
2216: WHEN FND_API.G_EXC_ERROR THEN

Line 2218: oe_debug_pub.add('EXP error');

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:
2221: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2222:

Line 2223: oe_debug_pub.add('EXP unexpected');

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:
2226: WHEN OTHERS THEN
2227:

Line 2228: oe_debug_pub.add('EXP others');

2224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2225:
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)

Line 2229: oe_debug_pub.add('error =' || sqlerrm);

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

Line 2253: oe_debug_pub.add('BEGIN Attributes in QPXLMLLB');

2249: )
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:

Line 2280: oe_debug_pub.add('here3');

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:
2282: IF p_MODIFIERS_rec.automatic_flag IS NOT NULL AND
2283: ( p_MODIFIERS_rec.automatic_flag <>
2284: p_old_MODIFIERS_rec.automatic_flag OR

Line 2312: oe_debug_pub.add('here4');

2308: x_return_status := FND_API.G_RET_STS_ERROR;
2309: END IF;
2310: END IF;
2311:
2312: oe_debug_pub.add('here4');
2313: /* IF p_MODIFIERS_rec.base_uom_code IS NOT NULL AND
2314: ( p_MODIFIERS_rec.base_uom_code <>
2315: p_old_MODIFIERS_rec.base_uom_code OR
2316: p_old_MODIFIERS_rec.base_uom_code IS NULL )

Line 2443: oe_debug_pub.add('here5');

2439: x_return_status := FND_API.G_RET_STS_ERROR;
2440: END IF;
2441: END IF;
2442:
2443: oe_debug_pub.add('here5');
2444: IF p_MODIFIERS_rec.list_header_id IS NOT NULL AND
2445: ( p_MODIFIERS_rec.list_header_id <>
2446: p_old_MODIFIERS_rec.list_header_id OR
2447: p_old_MODIFIERS_rec.list_header_id IS NULL )

Line 2524: oe_debug_pub.add('here6');

2520: x_return_status := FND_API.G_RET_STS_ERROR;
2521: END IF;
2522: END IF;
2523:
2524: oe_debug_pub.add('here6');
2525: IF p_MODIFIERS_rec.operand IS NOT NULL AND
2526: ( p_MODIFIERS_rec.operand <>
2527: p_old_MODIFIERS_rec.operand OR
2528: p_old_MODIFIERS_rec.operand IS NULL )

Line 2530: oe_debug_pub.add('here7');

2526: ( p_MODIFIERS_rec.operand <>
2527: p_old_MODIFIERS_rec.operand OR
2528: p_old_MODIFIERS_rec.operand IS NULL )
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;

Line 2532: oe_debug_pub.add('here8');

2528: p_old_MODIFIERS_rec.operand IS NULL )
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:

Line 2537: oe_debug_pub.add('here9');

2533: x_return_status := FND_API.G_RET_STS_ERROR;
2534: END IF;
2535: END IF;
2536:
2537: oe_debug_pub.add('here9');
2538: IF p_MODIFIERS_rec.organization_id IS NOT NULL AND
2539: ( p_MODIFIERS_rec.organization_id <>
2540: p_old_MODIFIERS_rec.organization_id OR
2541: p_old_MODIFIERS_rec.organization_id IS NULL )

Line 2548: oe_debug_pub.add('here10');

2544: x_return_status := FND_API.G_RET_STS_ERROR;
2545: END IF;
2546: END IF;
2547:
2548: oe_debug_pub.add('here10');
2549: IF p_MODIFIERS_rec.override_flag IS NOT NULL AND
2550: ( p_MODIFIERS_rec.override_flag <>
2551: p_old_MODIFIERS_rec.override_flag OR
2552: p_old_MODIFIERS_rec.override_flag IS NULL )

Line 2559: oe_debug_pub.add('here11');

2555: x_return_status := FND_API.G_RET_STS_ERROR;
2556: END IF;
2557: END IF;
2558:
2559: oe_debug_pub.add('here11');
2560: IF p_MODIFIERS_rec.percent_price IS NOT NULL AND
2561: ( p_MODIFIERS_rec.percent_price <>
2562: p_old_MODIFIERS_rec.percent_price OR
2563: p_old_MODIFIERS_rec.percent_price IS NULL )

Line 2792: oe_debug_pub.add('here12');

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
2794: ( p_MODIFIERS_rec.incompatibility_grp_code <>
2795: p_old_MODIFIERS_rec.incompatibility_grp_code OR
2796: p_old_MODIFIERS_rec.incompatibility_grp_code IS NULL )

Line 2803: oe_debug_pub.add('here13');

2799: x_return_status := FND_API.G_RET_STS_ERROR;
2800: END IF;
2801: END IF;
2802:
2803: oe_debug_pub.add('here13');
2804: IF p_MODIFIERS_rec.list_line_no IS NOT NULL AND
2805: ( p_MODIFIERS_rec.list_line_no <>
2806: p_old_MODIFIERS_rec.list_line_no OR
2807: p_old_MODIFIERS_rec.list_line_no IS NULL )

Line 3038: oe_debug_pub.add('here14');

3034: END IF;
3035:
3036:
3037:
3038: oe_debug_pub.add('here14');
3039: IF (p_MODIFIERS_rec.attribute1 IS NOT NULL AND
3040: ( p_MODIFIERS_rec.attribute1 <>
3041: p_old_MODIFIERS_rec.attribute1 OR
3042: p_old_MODIFIERS_rec.attribute1 IS NULL ))

Line 3184: oe_debug_pub.add('END Attributes in QPXLMLLB');

3180: END IF;
3181:
3182: -- Done validating attributes
3183:
3184: oe_debug_pub.add('END Attributes in QPXLMLLB');
3185:
3186: EXCEPTION
3187:
3188: WHEN FND_API.G_EXC_ERROR THEN

Line 3208: oe_debug_pub.add('EXP Attributes in QPXLMLLB');

3204: , 'Attributes'
3205: );
3206: END IF;
3207:
3208: oe_debug_pub.add('EXP Attributes in QPXLMLLB');
3209: END Attributes;
3210:
3211: -- Procedure Entity_Delete
3212:

Line 3221: oe_debug_pub.add('BEGIN Entity_Delete in QPXLMLLB');

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:
3223: -- Validate entity delete.
3224:
3225: NULL;

Line 3238: oe_debug_pub.add('BEGIN Entity_Delete in QPXLMLLB');

3234: -- Done.
3235:
3236: x_return_status := l_return_status;
3237:
3238: oe_debug_pub.add('BEGIN Entity_Delete in QPXLMLLB');
3239:
3240: EXCEPTION
3241:
3242: WHEN FND_API.G_EXC_ERROR THEN