DBA Data[Home] [Help]

APPS.QP_PRICE_FORMULA_UPG_UTIL_PVT dependencies on QP_UTIL

Line 140: QP_UTIL.Log_Error (

136:
137: WHEN OTHERS THEN
138: err_msg := substr(sqlerrm, 1, 240);
139: rollback;
140: QP_UTIL.Log_Error (
141: p_id1 => 'Price Formula Id' || to_char(p_price_formula_id),
142: p_id2 => 'Formula Name' || p_name,
143: p_error_type => 'FORMULA',
144: p_error_desc => err_msg,

Line 268: QP_UTIL.Log_Error (

264:
265: WHEN OTHERS THEN
266: err_msg := substr(sqlerrm, 1, 240);
267: rollback;
268: QP_UTIL.Log_Error (
269: p_id1 => 'Price Formula Id' || to_char(p_price_formula_id),
270: p_id2 => 'Price Formula Line Id' || to_char(p_price_formula_line_id),
271: p_error_type => 'FORMULA',
272: p_error_desc => err_msg,

Line 394: QP_UTIL.Log_Error (

390: EXCEPTION
391: WHEN OTHERS THEN
392: err_msg := substr(sqlerrm, 1, 240);
393: rollback;
394: QP_UTIL.Log_Error (
395: p_id1 => 'List Header Id' || to_char(p_list_header_id),
396: p_id2 => 'Price Modifier List Name' || p_name,
397: p_error_type => 'FORMULA',
398: p_error_desc => err_msg,

Line 520: QP_UTIL.Log_Error (

516: EXCEPTION
517: WHEN OTHERS THEN
518: err_msg := substr(sqlerrm, 1, 240);
519: rollback;
520: QP_UTIL.Log_Error (
521: p_id1 => 'List Header Id' || to_char(p_list_header_id),
522: p_id2 => 'List Line Id' || to_char(p_list_line_id),
523: p_error_type => 'FORMULA',
524: p_error_desc => err_msg,

Line 615: QP_UTIL.Log_Error (

611: EXCEPTION
612: WHEN OTHERS THEN
613: err_msg := substr(sqlerrm, 1, 240);
614: rollback;
615: QP_UTIL.Log_Error (
616: p_id1 => 'List Line Id' || to_char(p_list_line_id),
617: p_id2 => 'Pricing Attribute Id' || to_char(l_pricing_attribute_id),
618: p_id3 => 'Pricing Attribute Value' || p_pricing_attr_value_from,
619: p_error_type => 'FORMULA',

Line 747: QP_UTIL.Log_Error (

743: EXCEPTION
744: WHEN OTHERS THEN
745: err_msg := substr(sqlerrm, 1, 240);
746: rollback;
747: QP_UTIL.Log_Error (
748: p_id1 => 'Modifier List Id ' || to_char(l_list_header_id) ,
749: p_error_type => 'FORMULA',
750: p_error_desc => err_msg,
751: p_error_module => 'Upgrade_Unused_Components');

Line 761: QP_UTIL.Log_Error (

757: EXCEPTION
758: WHEN OTHERS THEN
759: err_msg := substr(sqlerrm, 1, 240);
760: rollback;
761: QP_UTIL.Log_Error (
762: p_id1 => 'Modifier List Id ' || to_char(l_list_header_id),
763: p_error_type => 'FORMULA',
764: p_error_desc => err_msg,
765: p_error_module => 'Upgrade_Unused_Components');

Line 832: QP_UTIL.Log_Error (

828: EXCEPTION
829: WHEN OTHERS THEN
830: err_msg := substr(sqlerrm, 1, 240);
831: rollback;
832: QP_UTIL.Log_Error (
833: p_id1 => 'Attribute Display Value' || p_attr_display_value,
834: p_error_type => 'FORMULA',
835: p_error_desc => err_msg,
836: p_error_module => 'Get_Attr_Value');

Line 875: QP_UTIL.Get_Context_Attribute( p_entity_id,

871: '1029','1030','1031','1032','1033','1034',
872: '1035','1036','1037','1038','1039')
873: THEN
874: --For Item related entity-codes get the Context and Attribute using API
875: QP_UTIL.Get_Context_Attribute( p_entity_id,
876: l_ctx_var,
877: l_attribute);
878: --dbms_output.put_line('In get_ctx..');
879: x_contexts(1) := l_ctx_var;

Line 935: QP_UTIL.Log_Error (

931: EXCEPTION
932: WHEN OTHERS THEN
933: err_msg := substr(sqlerrm, 1, 240);
934: rollback;
935: QP_UTIL.Log_Error (
936: p_id1 => 'Entity Id ' || to_char(p_entity_id),
937: p_error_type => 'FORMULA',
938: p_error_desc => err_msg,
939: p_error_module => 'Get_Ctx_Attr');

Line 967: QP_UTIL.Log_Error (

963: EXCEPTION
964: WHEN OTHERS THEN
965: err_msg := substr(sqlerrm, 1, 240);
966: rollback;
967: QP_UTIL.Log_Error (
968: p_id1 => 'Entity Id ' || to_char(p_entity_id),
969: p_error_type => 'FORMULA',
970: p_error_desc => err_msg,
971: p_error_module => 'Get_Attribute');

Line 1371: QP_UTIL.validate_qp_flexfield(

1367:
1368: l_attr_value :=
1369: Get_Attr_Value(l_context1, l_attribute1, l_value_rec.value1);
1370:
1371: QP_UTIL.validate_qp_flexfield(
1372: flexfield_name => 'QP_ATTR_DEFNS_PRICING',
1373: context => l_context1, attribute => l_attribute1,
1374: value => l_attr_value, application_short_name => 'QP',
1375: context_flag => x_context_flag,

Line 1395: QP_UTIL.validate_qp_flexfield(

1391:
1392: l_attr_value :=
1393: Get_Attr_Value(l_context2, l_attribute2, l_value_rec.value2);
1394:
1395: QP_UTIL.validate_qp_flexfield(
1396: flexfield_name => 'QP_ATTR_DEFNS_PRICING',
1397: context => l_context2, attribute => l_attribute2,
1398: value => l_attr_value, application_short_name => 'QP',
1399: context_flag => x_context_flag,

Line 1418: QP_UTIL.validate_qp_flexfield(

1414:
1415: l_attr_value :=
1416: Get_Attr_Value(l_context3, l_attribute3, l_value_rec.value3);
1417:
1418: QP_UTIL.validate_qp_flexfield(
1419: flexfield_name => 'QP_ATTR_DEFNS_PRICING',
1420: context => l_context3, attribute => l_attribute3,
1421: value => l_attr_value,
1422: application_short_name => 'QP',

Line 1442: QP_UTIL.validate_qp_flexfield(

1438:
1439: l_attr_value :=
1440: Get_Attr_Value(l_context4, l_attribute4, l_value_rec.value4);
1441:
1442: QP_UTIL.validate_qp_flexfield(
1443: flexfield_name => 'QP_ATTR_DEFNS_PRICING',
1444: context => l_context4, attribute => l_attribute4,
1445: value => l_attr_value,
1446: application_short_name => 'QP',

Line 1466: QP_UTIL.validate_qp_flexfield(

1462:
1463: l_attr_value :=
1464: Get_Attr_Value(l_context5, l_attribute5, l_value_rec.value5);
1465:
1466: QP_UTIL.validate_qp_flexfield(
1467: flexfield_name => 'QP_ATTR_DEFNS_PRICING',
1468: context => l_context5, attribute => l_attribute5,
1469: value => l_attr_value,
1470: application_short_name => 'QP',

Line 1530: QP_UTIL.Log_Error (

1526: EXCEPTION
1527: WHEN NO_DATA_FOUND OR DUP_VAL_ON_INDEX OR VALUE_ERROR THEN
1528: err_msg := substr(sqlerrm, 1, 240);
1529: rollback;
1530: QP_UTIL.Log_Error (
1531: p_id1 => 'Price Formula Id' || to_char(l_rec.pricing_rule_id),
1532: p_error_type => 'FORMULA',
1533: p_error_desc => err_msg,
1534: p_error_module => 'Upgrade_Price_Formulas');

Line 1539: QP_UTIL.Log_Error (

1535:
1536: WHEN OTHERS THEN
1537: err_msg := substr(sqlerrm, 1, 240);
1538: rollback;
1539: QP_UTIL.Log_Error (
1540: p_id1 => 'Price Formula Id' || to_char(l_rec.pricing_rule_id),
1541: p_error_type => 'FORMULA',
1542: p_error_desc => err_msg,
1543: p_error_module => 'Upgrade_Price_Formulas');

Line 1556: -- QP_UTIL.qp_upgrade_context('OE', 'QP', 'SO_PRICING_RULES', 'QP_PRICE_FORMULAS_B');

1552:
1553: -- Flexfield Merging
1554: -- Run the utility procedure to upgrade Descriptive Flexfields
1555: -- from Pricing to Price Formulas
1556: -- QP_UTIL.qp_upgrade_context('OE', 'QP', 'SO_PRICING_RULES', 'QP_PRICE_FORMULAS_B');
1557: -- QP_UTIL.qp_upgrade_context('OE', 'QP', 'SO_PRICING_RULE_LINES', 'QP_PRICE_FORMULA_LINES');
1558: -- QP_UTIL.qp_upgrade_context('OE', 'QP', 'SO_RULE_FORMULA_COMPONENTS', 'QP_LIST_HEADERS');
1559: -- QP_UTIL.qp_upgrade_context('OE', 'QP', 'SO_PRICING_RULE_LINE_VALUES', 'QP_LIST_LINES');
1560: commit;

Line 1557: -- QP_UTIL.qp_upgrade_context('OE', 'QP', 'SO_PRICING_RULE_LINES', 'QP_PRICE_FORMULA_LINES');

1553: -- Flexfield Merging
1554: -- Run the utility procedure to upgrade Descriptive Flexfields
1555: -- from Pricing to Price Formulas
1556: -- QP_UTIL.qp_upgrade_context('OE', 'QP', 'SO_PRICING_RULES', 'QP_PRICE_FORMULAS_B');
1557: -- QP_UTIL.qp_upgrade_context('OE', 'QP', 'SO_PRICING_RULE_LINES', 'QP_PRICE_FORMULA_LINES');
1558: -- QP_UTIL.qp_upgrade_context('OE', 'QP', 'SO_RULE_FORMULA_COMPONENTS', 'QP_LIST_HEADERS');
1559: -- QP_UTIL.qp_upgrade_context('OE', 'QP', 'SO_PRICING_RULE_LINE_VALUES', 'QP_LIST_LINES');
1560: commit;
1561:

Line 1558: -- QP_UTIL.qp_upgrade_context('OE', 'QP', 'SO_RULE_FORMULA_COMPONENTS', 'QP_LIST_HEADERS');

1554: -- Run the utility procedure to upgrade Descriptive Flexfields
1555: -- from Pricing to Price Formulas
1556: -- QP_UTIL.qp_upgrade_context('OE', 'QP', 'SO_PRICING_RULES', 'QP_PRICE_FORMULAS_B');
1557: -- QP_UTIL.qp_upgrade_context('OE', 'QP', 'SO_PRICING_RULE_LINES', 'QP_PRICE_FORMULA_LINES');
1558: -- QP_UTIL.qp_upgrade_context('OE', 'QP', 'SO_RULE_FORMULA_COMPONENTS', 'QP_LIST_HEADERS');
1559: -- QP_UTIL.qp_upgrade_context('OE', 'QP', 'SO_PRICING_RULE_LINE_VALUES', 'QP_LIST_LINES');
1560: commit;
1561:
1562: EXCEPTION

Line 1559: -- QP_UTIL.qp_upgrade_context('OE', 'QP', 'SO_PRICING_RULE_LINE_VALUES', 'QP_LIST_LINES');

1555: -- from Pricing to Price Formulas
1556: -- QP_UTIL.qp_upgrade_context('OE', 'QP', 'SO_PRICING_RULES', 'QP_PRICE_FORMULAS_B');
1557: -- QP_UTIL.qp_upgrade_context('OE', 'QP', 'SO_PRICING_RULE_LINES', 'QP_PRICE_FORMULA_LINES');
1558: -- QP_UTIL.qp_upgrade_context('OE', 'QP', 'SO_RULE_FORMULA_COMPONENTS', 'QP_LIST_HEADERS');
1559: -- QP_UTIL.qp_upgrade_context('OE', 'QP', 'SO_PRICING_RULE_LINE_VALUES', 'QP_LIST_LINES');
1560: commit;
1561:
1562: EXCEPTION
1563: WHEN OTHERS THEN

Line 1566: QP_UTIL.Log_Error (

1562: EXCEPTION
1563: WHEN OTHERS THEN
1564: err_msg := substr(sqlerrm, 1, 240);
1565: rollback;
1566: QP_UTIL.Log_Error (
1567: p_id1 => null,
1568: p_error_type => 'FORMULA',
1569: p_error_desc => err_msg,
1570: p_error_module => 'Upgrade_Price_Formulas');