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 53: oe_debug_pub.add('BEGIN Entity in QPXLMLLB');

49: l_profile_source_system_code qp_list_headers_b.source_system_code%type := fnd_profile.value('QP_SOURCE_SYSTEM_CODE');
50:
51: BEGIN
52:
53: oe_debug_pub.add('BEGIN Entity in QPXLMLLB');
54:
55: -- Check whether Source System Code matches
56: -- mkarya for bug 1728764, Prevent update of Trade Management Data in QP
57: QP_UTIL.Check_Source_System_Code

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

879: OE_MSG_PUB.Add;
880:
881: END IF;
882:
883: oe_debug_pub.add('before valida subs');
884: oe_debug_pub.add('context = '||p_MODIFIERS_rec.substitution_context);
885: oe_debug_pub.add('attr = '||p_MODIFIERS_rec.substitution_attribute);
886: oe_debug_pub.add('value = '||p_MODIFIERS_rec.substitution_value);
887:

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

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

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

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

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

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

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

899: ,precedence =>l_precedence
900: ,error_code =>l_error_code
901: );
902:
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;

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

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

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

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

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

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

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

949:
950: oe_debug_pub.add('inven item = '|| p_MODIFIERS_rec.inventory_item_id);
951: oe_debug_pub.add('org = '|| p_MODIFIERS_rec.organization_id);
952: oe_debug_pub.add('related item = '|| p_MODIFIERS_rec.related_item_id);
953: oe_debug_pub.add('relate = '|| p_MODIFIERS_rec.relationship_type_id);
954:
955: IF p_MODIFIERS_rec.list_line_type_code = 'IUE'
956: THEN
957:

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

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

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

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

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

996: END IF;
997:
998: END IF; --list_line_type_code = 'IUE'
999:
1000: oe_debug_pub.add('55');
1001: --dbms_output.put_line('55');
1002:
1003: --dbms_output.put_line('8');
1004:

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

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

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

1077: */
1078: EXCEPTION
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');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1640: END IF; --list_line_type_code <> 'PMR'
1641:
1642: /* Phase is mandatory for these Primary Modifier types */
1643:
1644: oe_debug_pub.add('here95');
1645: IF ( p_MODIFIERS_rec.list_line_type_code = 'OID' OR
1646: p_MODIFIERS_rec.list_line_type_code = 'SUR' OR
1647: p_MODIFIERS_rec.list_line_type_code = 'PRG' OR
1648: p_MODIFIERS_rec.list_line_type_code = 'DIS' OR

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

1809:
1810:
1811: /* Accrual not allowed for these Modifier types */
1812:
1813: oe_debug_pub.add('line type = '||p_MODIFIERS_rec.list_line_type_code);
1814: oe_debug_pub.add('accrual flag = '||p_MODIFIERS_rec.accrual_flag);
1815:
1816: IF ( p_MODIFIERS_rec.list_line_type_code = 'OID' OR
1817: p_MODIFIERS_rec.list_line_type_code = 'SUR' OR

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

1810:
1811: /* Accrual not allowed for these Modifier types */
1812:
1813: oe_debug_pub.add('line type = '||p_MODIFIERS_rec.list_line_type_code);
1814: oe_debug_pub.add('accrual flag = '||p_MODIFIERS_rec.accrual_flag);
1815:
1816: IF ( p_MODIFIERS_rec.list_line_type_code = 'OID' OR
1817: p_MODIFIERS_rec.list_line_type_code = 'SUR' OR
1818: p_MODIFIERS_rec.list_line_type_code = 'PRG' OR

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

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

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

1862: END IF;
1863:
1864: /* Accrual flag must be Y when accrual related fields are entered
1865:
1866: oe_debug_pub.add('HERE');
1867: oe_debug_pub.add('exp date = '||to_char(p_MODIFIERS_rec.expiration_date));
1868:
1869: IF (( p_MODIFIERS_rec.benefit_qty IS NOT NULL
1870: OR p_MODIFIERS_rec.benefit_uom_code IS NOT NULL

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

1863:
1864: /* Accrual flag must be Y when accrual related fields are entered
1865:
1866: oe_debug_pub.add('HERE');
1867: oe_debug_pub.add('exp date = '||to_char(p_MODIFIERS_rec.expiration_date));
1868:
1869: IF (( p_MODIFIERS_rec.benefit_qty IS NOT NULL
1870: OR p_MODIFIERS_rec.benefit_uom_code IS NOT NULL
1871: OR p_MODIFIERS_rec.expiration_date IS NOT NULL

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

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

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

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

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

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

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

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

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

2114:
2115: END IF;
2116:
2117:
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

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

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

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

2166:
2167: IF (fnd_profile.value('QP_ALLOW_DUPLICATE_MODIFIERS') <> 'Y'
2168: AND (l_qp_status = 'S' OR l_gsa_indicator = 'Y')) THEN
2169:
2170: oe_debug_pub.add('about to log a request to check duplicate modifier list lines ');
2171:
2172: QP_DELAYED_REQUESTS_PVT.Log_Request
2173: ( p_entity_code => QP_GLOBALS.G_ENTITY_ALL
2174: , p_entity_id => p_modifiers_rec.list_line_id

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

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

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

2191: RAISE FND_API.G_EXC_ERROR;
2192:
2193: END IF;
2194:
2195: oe_debug_pub.add('after logging delayed request ');
2196:
2197: END IF;
2198:
2199: -- end bug2091362

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

2198:
2199: -- end bug2091362
2200:
2201:
2202: oe_debug_pub.add('END Entity in QPXLMLLB');
2203:
2204: EXCEPTION
2205:
2206: WHEN FND_API.G_EXC_ERROR THEN

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

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:
2211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2212:

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

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:
2216: WHEN OTHERS THEN
2217:

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

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

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

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

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

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

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

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:
2269: IF p_MODIFIERS_rec.automatic_flag IS NOT NULL AND
2270: ( p_MODIFIERS_rec.automatic_flag <>
2271: p_old_MODIFIERS_rec.automatic_flag OR

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

2295: x_return_status := FND_API.G_RET_STS_ERROR;
2296: END IF;
2297: END IF;
2298:
2299: oe_debug_pub.add('here4');
2300: /* IF p_MODIFIERS_rec.base_uom_code IS NOT NULL AND
2301: ( p_MODIFIERS_rec.base_uom_code <>
2302: p_old_MODIFIERS_rec.base_uom_code OR
2303: p_old_MODIFIERS_rec.base_uom_code IS NULL )

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

2426: x_return_status := FND_API.G_RET_STS_ERROR;
2427: END IF;
2428: END IF;
2429:
2430: oe_debug_pub.add('here5');
2431: IF p_MODIFIERS_rec.list_header_id IS NOT NULL AND
2432: ( p_MODIFIERS_rec.list_header_id <>
2433: p_old_MODIFIERS_rec.list_header_id OR
2434: p_old_MODIFIERS_rec.list_header_id IS NULL )

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

2507: x_return_status := FND_API.G_RET_STS_ERROR;
2508: END IF;
2509: END IF;
2510:
2511: oe_debug_pub.add('here6');
2512: IF p_MODIFIERS_rec.operand IS NOT NULL AND
2513: ( p_MODIFIERS_rec.operand <>
2514: p_old_MODIFIERS_rec.operand OR
2515: p_old_MODIFIERS_rec.operand IS NULL )

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

2513: ( p_MODIFIERS_rec.operand <>
2514: p_old_MODIFIERS_rec.operand OR
2515: p_old_MODIFIERS_rec.operand IS NULL )
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;

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

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

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

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

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

2531: x_return_status := FND_API.G_RET_STS_ERROR;
2532: END IF;
2533: END IF;
2534:
2535: oe_debug_pub.add('here10');
2536: IF p_MODIFIERS_rec.override_flag IS NOT NULL AND
2537: ( p_MODIFIERS_rec.override_flag <>
2538: p_old_MODIFIERS_rec.override_flag OR
2539: p_old_MODIFIERS_rec.override_flag IS NULL )

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

2542: x_return_status := FND_API.G_RET_STS_ERROR;
2543: END IF;
2544: END IF;
2545:
2546: oe_debug_pub.add('here11');
2547: IF p_MODIFIERS_rec.percent_price IS NOT NULL AND
2548: ( p_MODIFIERS_rec.percent_price <>
2549: p_old_MODIFIERS_rec.percent_price OR
2550: p_old_MODIFIERS_rec.percent_price IS NULL )

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

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
2778: ( p_MODIFIERS_rec.incompatibility_grp_code <>
2779: p_old_MODIFIERS_rec.incompatibility_grp_code OR
2780: p_old_MODIFIERS_rec.incompatibility_grp_code IS NULL )

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

2783: x_return_status := FND_API.G_RET_STS_ERROR;
2784: END IF;
2785: END IF;
2786:
2787: oe_debug_pub.add('here13');
2788: IF p_MODIFIERS_rec.list_line_no IS NOT NULL AND
2789: ( p_MODIFIERS_rec.list_line_no <>
2790: p_old_MODIFIERS_rec.list_line_no OR
2791: p_old_MODIFIERS_rec.list_line_no IS NULL )

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

3018: END IF;
3019:
3020:
3021:
3022: oe_debug_pub.add('here14');
3023: IF (p_MODIFIERS_rec.attribute1 IS NOT NULL AND
3024: ( p_MODIFIERS_rec.attribute1 <>
3025: p_old_MODIFIERS_rec.attribute1 OR
3026: p_old_MODIFIERS_rec.attribute1 IS NULL ))

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

3164: END IF;
3165:
3166: -- Done validating attributes
3167:
3168: oe_debug_pub.add('END Attributes in QPXLMLLB');
3169:
3170: EXCEPTION
3171:
3172: WHEN FND_API.G_EXC_ERROR THEN

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

3188: , 'Attributes'
3189: );
3190: END IF;
3191:
3192: oe_debug_pub.add('EXP Attributes in QPXLMLLB');
3193: END Attributes;
3194:
3195: -- Procedure Entity_Delete
3196:

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

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:
3207: -- Validate entity delete.
3208:
3209: NULL;

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

3218: -- Done.
3219:
3220: x_return_status := l_return_status;
3221:
3222: oe_debug_pub.add('BEGIN Entity_Delete in QPXLMLLB');
3223:
3224: EXCEPTION
3225:
3226: WHEN FND_API.G_EXC_ERROR THEN