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_MODIFIER_UPGRADE_PVT dependencies on QP_UTIL

Line 95: QP_Util.Log_Error(p_id1 => p_old_discount_id,

91: EXCEPTION
92: WHEN OTHERS THEN
93: err_msg := SQLERRM;
94: rollback;
95: QP_Util.Log_Error(p_id1 => p_old_discount_id,
96: p_id2 => p_old_discount_line_id,
97: p_id3 => p_new_list_header_id,
98: p_id4 => p_new_list_line_id,
99: p_id5 => p_old_pbl_low,

Line 109: PROCEDURE QP_Util_Get_Context_Attribute(p_entity_id VARCHAR2,

105: p_error_module => 'Create_Discount_Mapping_Record');
106: raise;
107: END ;
108:
109: PROCEDURE QP_Util_Get_Context_Attribute(p_entity_id VARCHAR2,
110: x_context OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
111: x_attribute OUT NOCOPY /* file.sql.39 change */ VARCHAR2) AS
112: v_context VARCHAR2(30);
113: v_attribute VARCHAR2(30);

Line 117: QP_Util.get_context_attribute(p_entity_id,v_context,v_attribute);

113: v_attribute VARCHAR2(30);
114: err_msg VARCHAR2(2000);
115:
116: BEGIN
117: QP_Util.get_context_attribute(p_entity_id,v_context,v_attribute);
118: x_context := v_context;
119: x_attribute := v_attribute;
120: EXCEPTION
121: WHEN OTHERS THEN

Line 124: QP_Util.Log_Error(p_id1 => p_entity_id,

120: EXCEPTION
121: WHEN OTHERS THEN
122: err_msg := SQLERRM;
123: rollback;
124: QP_Util.Log_Error(p_id1 => p_entity_id,
125: p_error_type => 'GET_CONTEXT_ATTRIBUTE',
126: p_error_desc => err_msg,
127: p_error_module => 'QP_Util_Get_Context_Attribute');
128: raise;

Line 127: p_error_module => 'QP_Util_Get_Context_Attribute');

123: rollback;
124: QP_Util.Log_Error(p_id1 => p_entity_id,
125: p_error_type => 'GET_CONTEXT_ATTRIBUTE',
126: p_error_desc => err_msg,
127: p_error_module => 'QP_Util_Get_Context_Attribute');
128: raise;
129: END;
130:
131: PROCEDURE Get_Context_Attributes(

Line 152: QP_Util_Get_Context_Attribute(p_entity_id,x_context,x_attribute);

148: x_product_flag := FALSE;
149: x_qualifier_flag := FALSE;
150: x_pricing_flag := FALSE;
151:
152: QP_Util_Get_Context_Attribute(p_entity_id,x_context,x_attribute);
153:
154: IF (p_entity_id in (G_PRODUCT_ATTRIBUTE1,G_NEW_PRODUCT_ATTRIBUTE1,G_PRODUCT_ATTRIBUTE2)) THEN
155: -- Get the attribute and context for item or item category
156: x_product_flag := TRUE;

Line 176: QP_Util.Log_Error(p_id1 => p_entity_id,

172: EXCEPTION
173: WHEN OTHERS THEN
174: err_msg := SQLERRM;
175: rollback;
176: QP_Util.Log_Error(p_id1 => p_entity_id,
177: p_error_type => 'GET_CONTEXT_ATTR',
178: p_error_desc => err_msg,
179: p_error_module => 'Get_Context_Attributes');
180: raise;

Line 400: -- qp_util.validate_qp_flexfield() uses this flag.

396:
397: -- Processing Header Level Discounts
398:
399: -- To bypass the flex validation set g_validate_flag to FALSE
400: -- qp_util.validate_qp_flexfield() uses this flag.
401:
402: qp_util.g_validate_flag :=FALSE;
403:
404: begin

Line 402: qp_util.g_validate_flag :=FALSE;

398:
399: -- To bypass the flex validation set g_validate_flag to FALSE
400: -- qp_util.validate_qp_flexfield() uses this flag.
401:
402: qp_util.g_validate_flag :=FALSE;
403:
404: begin
405:
406: select start_line_id,

Line 492: QP_UTIL_Get_Context_Attribute(G_QUALIFIER_ATTRIBUTE1,v_context , v_attribute_name);

488: IF (i.price_list_id IS NOT NULL) THEN
489:
490: v_hqual_exists := TRUE;
491:
492: QP_UTIL_Get_Context_Attribute(G_QUALIFIER_ATTRIBUTE1,v_context , v_attribute_name);
493:
494: --dbms_output.put_line('Context for Price List Is ' || v_context);
495: /* flex
496: BEGIN

Line 498: QP_UTIL.Get_Qual_Flex_Properties(v_context,

494: --dbms_output.put_line('Context for Price List Is ' || v_context);
495: /* flex
496: BEGIN
497:
498: QP_UTIL.Get_Qual_Flex_Properties(v_context,
499: v_attribute_name,
500: i.price_list_id,
501: x_qualifier_datatype,
502: x_qualifier_precedence,

Line 506: QP_Util.Log_Error(p_id1 => G_QUALIFIER_ATTRIBUTE1,

502: x_qualifier_precedence,
503: x_error_code);
504:
505: IF (x_error_code <> 0 ) THEN
506: QP_Util.Log_Error(p_id1 => G_QUALIFIER_ATTRIBUTE1,
507: p_error_type => 'QUAL_FLEX_PROPERTIES',
508: p_error_desc =>
509: 'Please Check The Context: ' || v_context || ' Attribute: ' || v_attribute_name,
510: p_error_module => 'QP_Util.Get_Qual_Flex_Properties');

Line 510: p_error_module => 'QP_Util.Get_Qual_Flex_Properties');

506: QP_Util.Log_Error(p_id1 => G_QUALIFIER_ATTRIBUTE1,
507: p_error_type => 'QUAL_FLEX_PROPERTIES',
508: p_error_desc =>
509: 'Please Check The Context: ' || v_context || ' Attribute: ' || v_attribute_name,
510: p_error_module => 'QP_Util.Get_Qual_Flex_Properties');
511: END IF;
512:
513: EXCEPTION
514: WHEN OTHERS THEN

Line 517: QP_Util.Log_Error(p_id1 => G_QUALIFIER_ATTRIBUTE1,

513: EXCEPTION
514: WHEN OTHERS THEN
515: err_msg := SQLERRM;
516: rollback;
517: QP_Util.Log_Error(p_id1 => G_QUALIFIER_ATTRIBUTE1,
518: p_error_type => 'QUAL_FLEX_PROPERTIES',
519: p_error_desc => err_msg,
520: p_error_module => 'QP_Util.Get_Qual_Flex_Properties');
521: raise;

Line 520: p_error_module => 'QP_Util.Get_Qual_Flex_Properties');

516: rollback;
517: QP_Util.Log_Error(p_id1 => G_QUALIFIER_ATTRIBUTE1,
518: p_error_type => 'QUAL_FLEX_PROPERTIES',
519: p_error_desc => err_msg,
520: p_error_module => 'QP_Util.Get_Qual_Flex_Properties');
521: raise;
522: END;
523: flex */
524:

Line 575: QP_UTIL_Get_Context_Attribute(G_QUALIFIER_ATTRIBUTE10,v_context , v_attribute_name);

571:
572: v_hqual_exists := TRUE;
573:
574: -- Get the context and attribute for the gsa qualifier
575: QP_UTIL_Get_Context_Attribute(G_QUALIFIER_ATTRIBUTE10,v_context , v_attribute_name);
576:
577: /* flex
578:
579: BEGIN

Line 581: QP_UTIL.Get_Qual_Flex_Properties(v_context,

577: /* flex
578:
579: BEGIN
580:
581: QP_UTIL.Get_Qual_Flex_Properties(v_context,
582: v_attribute_name,
583: i.gsa_indicator,
584: x_qualifier_datatype,
585: x_qualifier_precedence,

Line 588: QP_Util.Log_Error(p_id1 => G_QUALIFIER_ATTRIBUTE10,

584: x_qualifier_datatype,
585: x_qualifier_precedence,
586: x_error_code);
587: IF (x_error_code <> 0 ) THEN
588: QP_Util.Log_Error(p_id1 => G_QUALIFIER_ATTRIBUTE10,
589: p_error_type => 'QUAL_FLEX_PROPERTIES',
590: p_error_desc =>
591: 'Please Check The Context: ' || v_context || ' Attribute: ' || v_attribute_name,
592: p_error_module => 'QP_Util.Get_Qual_Flex_Properties');

Line 592: p_error_module => 'QP_Util.Get_Qual_Flex_Properties');

588: QP_Util.Log_Error(p_id1 => G_QUALIFIER_ATTRIBUTE10,
589: p_error_type => 'QUAL_FLEX_PROPERTIES',
590: p_error_desc =>
591: 'Please Check The Context: ' || v_context || ' Attribute: ' || v_attribute_name,
592: p_error_module => 'QP_Util.Get_Qual_Flex_Properties');
593: END IF;
594:
595: EXCEPTION
596: WHEN OTHERS THEN

Line 599: QP_Util.Log_Error(p_id1 => G_QUALIFIER_ATTRIBUTE10,

595: EXCEPTION
596: WHEN OTHERS THEN
597: err_msg := SQLERRM;
598: rollback;
599: QP_Util.Log_Error(p_id1 => G_QUALIFIER_ATTRIBUTE10,
600: p_error_type => 'QUAL_FLEX_PROPERTIES',
601: p_error_desc => err_msg,
602: p_error_module => 'QP_Util.Get_Qual_Flex_Properties');
603: raise;

Line 602: p_error_module => 'QP_Util.Get_Qual_Flex_Properties');

598: rollback;
599: QP_Util.Log_Error(p_id1 => G_QUALIFIER_ATTRIBUTE10,
600: p_error_type => 'QUAL_FLEX_PROPERTIES',
601: p_error_desc => err_msg,
602: p_error_module => 'QP_Util.Get_Qual_Flex_Properties');
603: raise;
604: END;
605:
606: flex */

Line 665: QP_UTIL_Get_Context_Attribute(G_QUALIFIER_ATTRIBUTE3,v_context , v_attribute_name);

661:
662: IF (l.customer_class_code IS NOT NULL) THEN
663:
664: -- Get the context and attribute for the customer class code
665: QP_UTIL_Get_Context_Attribute(G_QUALIFIER_ATTRIBUTE3,v_context , v_attribute_name);
666: /* flex
667: BEGIN
668: QP_UTIL.Get_Qual_Flex_Properties(v_context,
669: v_attribute_name,

Line 668: QP_UTIL.Get_Qual_Flex_Properties(v_context,

664: -- Get the context and attribute for the customer class code
665: QP_UTIL_Get_Context_Attribute(G_QUALIFIER_ATTRIBUTE3,v_context , v_attribute_name);
666: /* flex
667: BEGIN
668: QP_UTIL.Get_Qual_Flex_Properties(v_context,
669: v_attribute_name,
670: l.customer_class_code,
671: x_qualifier_datatype,
672: x_qualifier_precedence,

Line 675: QP_Util.Log_Error(p_id1 => G_QUALIFIER_ATTRIBUTE3,

671: x_qualifier_datatype,
672: x_qualifier_precedence,
673: x_error_code);
674: IF (x_error_code <> 0 ) THEN
675: QP_Util.Log_Error(p_id1 => G_QUALIFIER_ATTRIBUTE3,
676: p_error_type => 'QUAL_FLEX_PROPERTIES',
677: p_error_desc =>
678: 'Please Check The Context: ' || v_context || ' Attribute: ' || v_attribute_name,
679: p_error_module => 'QP_Util.Get_Qual_Flex_Properties');

Line 679: p_error_module => 'QP_Util.Get_Qual_Flex_Properties');

675: QP_Util.Log_Error(p_id1 => G_QUALIFIER_ATTRIBUTE3,
676: p_error_type => 'QUAL_FLEX_PROPERTIES',
677: p_error_desc =>
678: 'Please Check The Context: ' || v_context || ' Attribute: ' || v_attribute_name,
679: p_error_module => 'QP_Util.Get_Qual_Flex_Properties');
680: END IF;
681: EXCEPTION
682: WHEN OTHERS THEN
683: err_msg := SQLERRM;

Line 685: QP_Util.Log_Error(p_id1 => G_QUALIFIER_ATTRIBUTE3,

681: EXCEPTION
682: WHEN OTHERS THEN
683: err_msg := SQLERRM;
684: rollback;
685: QP_Util.Log_Error(p_id1 => G_QUALIFIER_ATTRIBUTE3,
686: p_error_type => 'QUAL_FLEX_PROPERTIES',
687: p_error_desc => err_msg,
688: p_error_module => 'QP_Util.Get_Qual_Flex_Properties');
689: raise;

Line 688: p_error_module => 'QP_Util.Get_Qual_Flex_Properties');

684: rollback;
685: QP_Util.Log_Error(p_id1 => G_QUALIFIER_ATTRIBUTE3,
686: p_error_type => 'QUAL_FLEX_PROPERTIES',
687: p_error_desc => err_msg,
688: p_error_module => 'QP_Util.Get_Qual_Flex_Properties');
689: raise;
690: END;
691: flex */
692: -- Create the Qualifier for customer class code

Line 741: QP_UTIL_Get_Context_Attribute(G_QUALIFIER_ATTRIBUTE4,v_context , v_attribute_name);

737:
738: IF (l.site_use_id IS NOT NULL) THEN
739:
740: -- Get the context and attribute for the site_use_id
741: QP_UTIL_Get_Context_Attribute(G_QUALIFIER_ATTRIBUTE4,v_context , v_attribute_name);
742: /* flex
743: BEGIN
744: QP_UTIL.Get_Qual_Flex_Properties(v_context,
745: v_attribute_name,

Line 744: QP_UTIL.Get_Qual_Flex_Properties(v_context,

740: -- Get the context and attribute for the site_use_id
741: QP_UTIL_Get_Context_Attribute(G_QUALIFIER_ATTRIBUTE4,v_context , v_attribute_name);
742: /* flex
743: BEGIN
744: QP_UTIL.Get_Qual_Flex_Properties(v_context,
745: v_attribute_name,
746: l.site_use_id,
747: x_qualifier_datatype,
748: x_qualifier_precedence,

Line 751: QP_Util.Log_Error(p_id1 => G_QUALIFIER_ATTRIBUTE4,

747: x_qualifier_datatype,
748: x_qualifier_precedence,
749: x_error_code);
750: IF (x_error_code <> 0 ) THEN
751: QP_Util.Log_Error(p_id1 => G_QUALIFIER_ATTRIBUTE4,
752: p_error_type => 'QUAL_FLEX_PROPERTIES',
753: p_error_desc =>
754: 'Please Check The Context: ' || v_context || ' Attribute: ' || v_attribute_name,
755: p_error_module => 'QP_Util.Get_Qual_Flex_Properties');

Line 755: p_error_module => 'QP_Util.Get_Qual_Flex_Properties');

751: QP_Util.Log_Error(p_id1 => G_QUALIFIER_ATTRIBUTE4,
752: p_error_type => 'QUAL_FLEX_PROPERTIES',
753: p_error_desc =>
754: 'Please Check The Context: ' || v_context || ' Attribute: ' || v_attribute_name,
755: p_error_module => 'QP_Util.Get_Qual_Flex_Properties');
756: END IF;
757: EXCEPTION
758: WHEN OTHERS THEN
759: err_msg := SQLERRM;

Line 761: QP_Util.Log_Error(p_id1 => G_QUALIFIER_ATTRIBUTE4,

757: EXCEPTION
758: WHEN OTHERS THEN
759: err_msg := SQLERRM;
760: rollback;
761: QP_Util.Log_Error(p_id1 => G_QUALIFIER_ATTRIBUTE4,
762: p_error_type => 'QUAL_FLEX_PROPERTIES',
763: p_error_desc => err_msg,
764: p_error_module => 'QP_Util.Get_Qual_Flex_Properties');
765: raise;

Line 764: p_error_module => 'QP_Util.Get_Qual_Flex_Properties');

760: rollback;
761: QP_Util.Log_Error(p_id1 => G_QUALIFIER_ATTRIBUTE4,
762: p_error_type => 'QUAL_FLEX_PROPERTIES',
763: p_error_desc => err_msg,
764: p_error_module => 'QP_Util.Get_Qual_Flex_Properties');
765: raise;
766: END;
767: flex */
768: -- Create the qualifier for site_use_id

Line 819: QP_UTIL_Get_Context_Attribute(G_QUALIFIER_ATTRIBUTE5,v_context , v_attribute_name);

815:
816: IF (l.customer_id IS NOT NULL) THEN
817:
818: -- Get the context and attribute for the customer_id
819: QP_UTIL_Get_Context_Attribute(G_QUALIFIER_ATTRIBUTE5,v_context , v_attribute_name);
820: /* flex
821: BEGIN
822: QP_UTIL.Get_Qual_Flex_Properties(v_context,
823: v_attribute_name,

Line 822: QP_UTIL.Get_Qual_Flex_Properties(v_context,

818: -- Get the context and attribute for the customer_id
819: QP_UTIL_Get_Context_Attribute(G_QUALIFIER_ATTRIBUTE5,v_context , v_attribute_name);
820: /* flex
821: BEGIN
822: QP_UTIL.Get_Qual_Flex_Properties(v_context,
823: v_attribute_name,
824: l.customer_id,
825: x_qualifier_datatype,
826: x_qualifier_precedence,

Line 829: QP_Util.Log_Error(p_id1 => G_QUALIFIER_ATTRIBUTE5,

825: x_qualifier_datatype,
826: x_qualifier_precedence,
827: x_error_code);
828: IF (x_error_code <> 0 ) THEN
829: QP_Util.Log_Error(p_id1 => G_QUALIFIER_ATTRIBUTE5,
830: p_error_type => 'QUAL_FLEX_PROPERTIES',
831: p_error_desc =>
832: 'Please Check The Context: ' || v_context || ' Attribute: ' || v_attribute_name,
833: p_error_module => 'QP_Util.Get_Qual_Flex_Properties');

Line 833: p_error_module => 'QP_Util.Get_Qual_Flex_Properties');

829: QP_Util.Log_Error(p_id1 => G_QUALIFIER_ATTRIBUTE5,
830: p_error_type => 'QUAL_FLEX_PROPERTIES',
831: p_error_desc =>
832: 'Please Check The Context: ' || v_context || ' Attribute: ' || v_attribute_name,
833: p_error_module => 'QP_Util.Get_Qual_Flex_Properties');
834: END IF;
835: EXCEPTION
836: WHEN OTHERS THEN
837: err_msg := SQLERRM;

Line 839: QP_Util.Log_Error(p_id1 => G_QUALIFIER_ATTRIBUTE5,

835: EXCEPTION
836: WHEN OTHERS THEN
837: err_msg := SQLERRM;
838: rollback;
839: QP_Util.Log_Error(p_id1 => G_QUALIFIER_ATTRIBUTE5,
840: p_error_type => 'QUAL_FLEX_PROPERTIES',
841: p_error_desc => err_msg,
842: p_error_module => 'QP_Util.Get_Qual_Flex_Properties');
843: raise;

Line 842: p_error_module => 'QP_Util.Get_Qual_Flex_Properties');

838: rollback;
839: QP_Util.Log_Error(p_id1 => G_QUALIFIER_ATTRIBUTE5,
840: p_error_type => 'QUAL_FLEX_PROPERTIES',
841: p_error_desc => err_msg,
842: p_error_module => 'QP_Util.Get_Qual_Flex_Properties');
843: raise;
844: END;
845: flex */
846: -- Create the qualifier for customer_id

Line 1114: QP_UTIL.Get_Prod_Flex_Properties(b.descriptive_flex_context_code,

1110: BEGIN
1111:
1112: v_contexts_flag := TRUE;
1113:
1114: QP_UTIL.Get_Prod_Flex_Properties(b.descriptive_flex_context_code,
1115: b.entity_code,
1116: j.entity_value,
1117: x_pricing_datatype,
1118: x_pricing_precedence,

Line 1121: QP_Util.Log_Error(p_id1 => j.entity_id,

1117: x_pricing_datatype,
1118: x_pricing_precedence,
1119: x_error_code);
1120: IF (x_error_code <> 0 ) THEN
1121: QP_Util.Log_Error(p_id1 => j.entity_id,
1122: p_error_type => 'PROD_FLEX_PROPERTIES',
1123: p_error_desc =>
1124: 'Please Check The Context: ' || b.descriptive_flex_context_code ||
1125: ' Attribute: ' || b.entity_code ,

Line 1126: p_error_module => 'QP_Util.Get_Prod_Flex_Properties');

1122: p_error_type => 'PROD_FLEX_PROPERTIES',
1123: p_error_desc =>
1124: 'Please Check The Context: ' || b.descriptive_flex_context_code ||
1125: ' Attribute: ' || b.entity_code ,
1126: p_error_module => 'QP_Util.Get_Prod_Flex_Properties');
1127: END IF;
1128: l_precedence := x_pricing_precedence;
1129: EXCEPTION
1130: WHEN OTHERS THEN

Line 1133: QP_Util.Log_Error(p_id1 => j.entity_id,

1129: EXCEPTION
1130: WHEN OTHERS THEN
1131: err_msg := SQLERRM;
1132: rollback;
1133: QP_Util.Log_Error(p_id1 => j.entity_id,
1134: p_error_type => 'PROD_FLEX_PROPERTIES',
1135: p_error_desc => 'Pricing Entity ' || err_msg,
1136: p_error_module => 'QP_Util.Get_Prod_Flex_Properties');
1137: raise;

Line 1136: p_error_module => 'QP_Util.Get_Prod_Flex_Properties');

1132: rollback;
1133: QP_Util.Log_Error(p_id1 => j.entity_id,
1134: p_error_type => 'PROD_FLEX_PROPERTIES',
1135: p_error_desc => 'Pricing Entity ' || err_msg,
1136: p_error_module => 'QP_Util.Get_Prod_Flex_Properties');
1137: raise;
1138: END;
1139:
1140: flex */

Line 1360: QP_UTIL.Get_Prod_Flex_Properties(v_product_context,

1356:
1357: /* flex
1358:
1359: BEGIN
1360: QP_UTIL.Get_Prod_Flex_Properties(v_product_context,
1361: v_product_attribute,
1362: j.entity_value,
1363: x_product_datatype,
1364: x_product_precedence,

Line 1367: QP_Util.Log_Error(p_id1 => j.entity_id,

1363: x_product_datatype,
1364: x_product_precedence,
1365: x_error_code);
1366: IF (x_error_code <> 0 ) THEN
1367: QP_Util.Log_Error(p_id1 => j.entity_id,
1368: p_error_type => 'PROD_FLEX_PROPERTIES',
1369: p_error_desc =>
1370: 'Please Check The Context: ' || v_product_context ||
1371: ' Attribute: ' || v_product_attribute,

Line 1372: p_error_module => 'QP_Util.Get_Prod_Flex_Properties');

1368: p_error_type => 'PROD_FLEX_PROPERTIES',
1369: p_error_desc =>
1370: 'Please Check The Context: ' || v_product_context ||
1371: ' Attribute: ' || v_product_attribute,
1372: p_error_module => 'QP_Util.Get_Prod_Flex_Properties');
1373: END IF;
1374: l_precedence := x_product_precedence;
1375: EXCEPTION
1376: WHEN OTHERS THEN

Line 1379: QP_Util.Log_Error(p_id1 => j.entity_id,

1375: EXCEPTION
1376: WHEN OTHERS THEN
1377: err_msg := SQLERRM;
1378: rollback;
1379: QP_Util.Log_Error(p_id1 => j.entity_id,
1380: p_error_type => 'PROD_FLEX_PROPERTIES',
1381: p_error_desc => 'Product Entity ' || err_msg,
1382: p_error_module => 'QP_Util.Get_Prod_Flex_Properties');
1383: raise;

Line 1382: p_error_module => 'QP_Util.Get_Prod_Flex_Properties');

1378: rollback;
1379: QP_Util.Log_Error(p_id1 => j.entity_id,
1380: p_error_type => 'PROD_FLEX_PROPERTIES',
1381: p_error_desc => 'Product Entity ' || err_msg,
1382: p_error_module => 'QP_Util.Get_Prod_Flex_Properties');
1383: raise;
1384: END;
1385:
1386: flex */

Line 1392: QP_Util.Log_Error(p_id1 => j.entity_id,

1388: EXCEPTION
1389: WHEN OTHERS THEN
1390: err_msg := SQLERRM;
1391: rollback;
1392: QP_Util.Log_Error(p_id1 => j.entity_id,
1393: p_error_type => 'PROD_FLEX_PROPERTIES',
1394: p_error_desc => 'Product Entity ' || err_msg,
1395: p_error_module => 'Prod_Flex_Properties');
1396: raise;

Line 1415: QP_UTIL.Get_Qual_Flex_Properties(v_product_context,

1411:
1412: /* flex
1413:
1414: BEGIN
1415: QP_UTIL.Get_Qual_Flex_Properties(v_product_context,
1416: v_product_attribute,
1417: j.entity_value,
1418: x_qualifier_datatype,
1419: x_qualifier_precedence,

Line 1426: QP_Util.Log_Error(p_id1 => j.entity_id,

1422: EXCEPTION
1423: WHEN OTHERS THEN
1424: err_msg := SQLERRM;
1425: rollback;
1426: QP_Util.Log_Error(p_id1 => j.entity_id,
1427: p_error_type => 'QUAL_FLEX_PROPERTIES',
1428: p_error_desc => 'Qualifier Entity ' || err_msg,
1429: p_error_module => 'QP_Util.Get_Qual_Flex_Properties');
1430: raise;

Line 1429: p_error_module => 'QP_Util.Get_Qual_Flex_Properties');

1425: rollback;
1426: QP_Util.Log_Error(p_id1 => j.entity_id,
1427: p_error_type => 'QUAL_FLEX_PROPERTIES',
1428: p_error_desc => 'Qualifier Entity ' || err_msg,
1429: p_error_module => 'QP_Util.Get_Qual_Flex_Properties');
1430: raise;
1431: END;
1432:
1433: flex */

Line 1438: QP_Util.Log_Error(p_id1 => j.entity_id,

1434: EXCEPTION
1435: WHEN OTHERS THEN
1436: err_msg := SQLERRM;
1437: rollback;
1438: QP_Util.Log_Error(p_id1 => j.entity_id,
1439: p_error_type => 'QUAL_FLEX_PROPERTIES',
1440: p_error_desc => 'Qualifier Entity ' || err_msg,
1441: p_error_module => 'Qual_Flex_Properties');
1442: raise;

Line 1458: QP_Util.Log_Error(p_id1 => j.entity_id,

1454: Create_Discount_Mapping_Record(i.discount_id,NULL,v_list_header_id,NULL,null,'L',
1455: null,null,null,null,null,null);
1456:
1457: -- Added after discounts upgrade review by Jay,Alison and Ravi
1458: QP_Util.Log_Error(p_id1 => j.entity_id,
1459: p_error_type => 'ENTITY_NOT_HANDLED',
1460: p_error_desc => 'This entity is not handled by the Upgrade:' || j.entity_id,
1461: p_error_module => 'Create_Discounts');
1462: END IF;

Line 1725: QP_UTIL_Get_Context_Attribute(G_PRICING_ATTRIBUTE_UNITS,v_price_break_context,v_price_break_attribute);

1721: -- Determine the pricing context and attribute
1722: IF (UPPER(k.method_type_code) = G_PRICING_ATTRIBUTE_UNITS) THEN
1723:
1724: -- Get the context and attribute for Units
1725: QP_UTIL_Get_Context_Attribute(G_PRICING_ATTRIBUTE_UNITS,v_price_break_context,v_price_break_attribute);
1726:
1727: ELSIF (UPPER(k.method_type_code) = G_PRICING_ATTRIBUTE_DOLLARS) THEN
1728:
1729: -- Get the context and attribute for Dollars

Line 1730: QP_UTIL_Get_Context_Attribute(G_PRICING_ATTRIBUTE_DOLLARS,v_price_break_context,v_price_break_attribute);

1726:
1727: ELSIF (UPPER(k.method_type_code) = G_PRICING_ATTRIBUTE_DOLLARS) THEN
1728:
1729: -- Get the context and attribute for Dollars
1730: QP_UTIL_Get_Context_Attribute(G_PRICING_ATTRIBUTE_DOLLARS,v_price_break_context,v_price_break_attribute);
1731: END IF;
1732:
1733: -- PBH Children
1734: v_qualification_ind := 2;

Line 1939: QP_Util.Log_Error(p_id1 => j.discount_line_id,

1935: END IF; -- j.entity_id IS NOT NULL AND v_product_flag = TRUE or v_qualifier_flag = TRUE
1936:
1937: -- Added after discounts upgrade review by Jay,Alison and Ravi
1938: IF (v_contexts_flag = FALSE and v_entity_id IS NOT NULL) THEN
1939: QP_Util.Log_Error(p_id1 => j.discount_line_id,
1940: p_error_type => 'NO_PRICING_CONTEXTS_EXIST',
1941: p_error_desc => 'There are no contexts for the entity id : ' || v_entity_id ||
1942: ' of discount id: ' || i.discount_id || ' and discount line id: '||
1943: j.discount_line_id,

Line 1956: QP_Util.Log_Error(p_id1 => i.discount_id,

1952: Create_Discount_Mapping_Record(i.discount_id,NULL,v_list_header_id,NULL,null,'O',
1953: null,null,null,null,null,null);
1954:
1955: -- Added after discounts upgrade review by Jay,Alison and Ravi
1956: QP_Util.Log_Error(p_id1 => i.discount_id,
1957: p_error_type => 'NO_DISCOUNT_LINES',
1958: p_error_desc => 'There are no discount lines for this discount id:' || i.discount_id,
1959: p_error_module => 'Create_Discounts');
1960: END IF;

Line 1972: QP_Util.Log_Error(p_id1 => i.discount_id,

1968:
1969: -- Discounts Not Migrated
1970: FOR i in get_discounts_not_migrated_cur
1971: LOOP
1972: QP_Util.Log_Error(p_id1 => i.discount_id,
1973: p_id2 => i.price_list_id,
1974: p_error_type => 'DISCOUNTS_NOT_MIGRATED',
1975: p_error_desc =>
1976: 'Discount Id ' || i.discount_id || ' is not migrated as there is problem with

Line 1986: QP_Util.Log_Error(p_id1 => v_old_discount_id,

1982: EXCEPTION
1983: WHEN OTHERS THEN
1984: err_msg := SQLERRM;
1985: rollback;
1986: QP_Util.Log_Error(p_id1 => v_old_discount_id,
1987: p_id2 => v_old_discount_line_id,
1988: p_error_type => 'DISCOUNTS',
1989: p_error_desc => err_msg,
1990: p_error_module => 'Create_Discounts');

Line 1995: QP_Util.Log_Error(p_id1 => i.discount_id,

1991:
1992: -- Discounts Not Migrated
1993: FOR i in get_discounts_not_migrated_cur
1994: LOOP
1995: QP_Util.Log_Error(p_id1 => i.discount_id,
1996: p_id2 => i.price_list_id,
1997: p_error_type => 'DISCOUNTS_NOT_MIGRATED',
1998: p_error_desc =>
1999: 'Discount Id ' || i.discount_id || ' is not migrated as there is problem with