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

Line 9: QP_UTIL.QP_UPGRADE_CONTEXT('OE', 'QP', 'SO_PRICE_LISTS', 'QP_LIST_HEADERS');

5: err_num NUMBER;
6: err_msg VARCHAR2(100);
7: BEGIN
8:
9: QP_UTIL.QP_UPGRADE_CONTEXT('OE', 'QP', 'SO_PRICE_LISTS', 'QP_LIST_HEADERS');
10:
11: QP_UTIL.QP_UPGRADE_CONTEXT('OE', 'QP', 'SO_PRICE_LIST_LINES', 'QP_LIST_LINES');
12:
13: EXCEPTION

Line 11: QP_UTIL.QP_UPGRADE_CONTEXT('OE', 'QP', 'SO_PRICE_LIST_LINES', 'QP_LIST_LINES');

7: BEGIN
8:
9: QP_UTIL.QP_UPGRADE_CONTEXT('OE', 'QP', 'SO_PRICE_LISTS', 'QP_LIST_HEADERS');
10:
11: QP_UTIL.QP_UPGRADE_CONTEXT('OE', 'QP', 'SO_PRICE_LIST_LINES', 'QP_LIST_LINES');
12:
13: EXCEPTION
14:
15: WHEN OTHERS THEN

Line 19: qp_util.log_error(NULL, NULL, NULL, NULL,

15: WHEN OTHERS THEN
16: err_num := SQLCODE;
17: err_msg := SUBSTR(SQLERRM, 1, 240);
18: ROLLBACK;
19: qp_util.log_error(NULL, NULL, NULL, NULL,
20: NULL, NULL, NULL, NULL,
21: 'UPGRADE_FLEX_STRUCTURES',
22: err_msg, 'PRICE_LISTS');
23: RAISE;

Line 699: qp_util.log_error(price_list_id_T(K),NULL, NULL, NULL, NULL,

695: WHEN OTHERS THEN
696: v_errortext := SUBSTR(SQLERRM, 1,240);
697: K := sql%rowcount + l_min_price_list;
698: ROLLBACK;
699: qp_util.log_error(price_list_id_T(K),NULL, NULL, NULL, NULL,
700: NULL, NULL,NULL, 'PRICE_LIST_HEADER_B',
701: v_errortext, 'PRICE_LISTS');
702: RAISE;
703: END;

Line 749: qp_util.log_error(price_list_id_T(K),

745: v_errortext := SUBSTR(SQLERRM, 1,240);
746: K := sql%rowcount + l_min_price_list;
747: -- dbms_output.put_line('The value of K: ' || K);
748: ROLLBACK;
749: qp_util.log_error(price_list_id_T(K),
750: NULL, NULL, NULL, NULL, NULL,
751: NULL, NULL, 'PRICE_LIST_HEADER_TL',
752: v_errortext, 'PRICE_LISTS');
753: RAISE;

Line 805: qp_util.log_error(NULL, NULL, NULL, NULL, NULL, NULL, NULL,

801:
802: v_errortext := SUBSTR(SQLERRM, 1,240);
803: --dbms_output.put_line('hello 1');
804: new_prc_list_maps := prc_list_maps;
805: qp_util.log_error(NULL, NULL, NULL, NULL, NULL, NULL, NULL,
806: NULL, 'disc_map', v_errortext, 'PRICE_LISTS');
807: RAISE;
808:
809: end;

Line 848: qp_util.log_error(NULL, NULL, NULL, NULL, NULL, NULL, NULL,

844:
845: WHEN OTHERS THEN
846: v_errortext := SUBSTR(SQLERRM, 1,240);
847: ROLLBACK;
848: qp_util.log_error(NULL, NULL, NULL, NULL, NULL, NULL, NULL,
849: NULL, 'OTHERS', v_errortext, 'PRICE_LISTS');
850: RAISE;
851: END;
852:

Line 882: QP_UTIL.Get_Qual_Flex_Properties(l_context,

878:
879:
880: --dbms_output.put_line('pr4');
881:
882: QP_UTIL.Get_Qual_Flex_Properties(l_context,
883: l_attribute,
884: l_price_list_id,
885: l_datatype,
886: l_precedence,

Line 896: qp_util.log_error(l_price_list_id, l_secondary_price_list_id, NULL, NULL, NULL, NULL, NULL, NULL, 'GET_QUAL_FLEX_LISTS', err_msg, 'PRICE_LISTS');

892: EXCEPTION
893: WHEN e_validate_flexfield THEN
894: err_num := SQLCODE;
895: err_msg := SUBSTR(SQLERRM, 1, 240);
896: qp_util.log_error(l_price_list_id, l_secondary_price_list_id, NULL, NULL, NULL, NULL, NULL, NULL, 'GET_QUAL_FLEX_LISTS', err_msg, 'PRICE_LISTS');
897:
898: WHEN OTHERS THEN
899: err_num := SQLCODE;
900: err_msg := SUBSTR(SQLERRM, 1, 240);

Line 902: qp_util.log_error(l_price_list_id, l_secondary_price_list_id, NULL, NULL, NULL, NULL, NULL, NULL, 'GET_QUAL_FLEX_LISTS', err_msg, 'PRICE_LISTS');

898: WHEN OTHERS THEN
899: err_num := SQLCODE;
900: err_msg := SUBSTR(SQLERRM, 1, 240);
901: ROLLBACK;
902: qp_util.log_error(l_price_list_id, l_secondary_price_list_id, NULL, NULL, NULL, NULL, NULL, NULL, 'GET_QUAL_FLEX_LISTS', err_msg, 'PRICE_LISTS');
903: RAISE;
904: END;
905:
906: end if;

Line 982: qp_util.log_error(l_price_list_id,

978: EXCEPTION
979: WHEN OTHERS THEN
980: v_errortext := SUBSTR(SQLERRM, 1,240);
981: ROLLBACK;
982: qp_util.log_error(l_price_list_id,
983: NULL, l_secondary_price_list_id, NULL, NULL, NULL, NULL,
984: NULL, 'SECONDARY_PRICE_LISTS',
985: v_errortext, 'PRICE_LISTS');
986: RAISE;

Line 1049: qp_util.log_error(prc_list_maps(l_price_list_id).new_list_header_id,

1045: EXCEPTION
1046: WHEN OTHERS THEN
1047: v_errortext := SUBSTR(SQLERRM, 1,240);
1048: ROLLBACK;
1049: qp_util.log_error(prc_list_maps(l_price_list_id).new_list_header_id,
1050: NULL, l_secondary_price_list_id, NULL,
1051: NULL, NULL, NULL,
1052: NULL, 'SECONDARY_PRICE_LISTS',
1053: v_errortext, 'PRICE_LISTS');

Line 1076: QP_Util.Log_Error(p_id1 => invalid_prc_rec.price_list_id,

1072: --dbms_output.put_line('pr10');
1073:
1074: FOR invalid_prc_rec in invalid_prc
1075: LOOP
1076: QP_Util.Log_Error(p_id1 => invalid_prc_rec.price_list_id,
1077: p_id2 => NULL,
1078: p_error_type => 'PRICE_LIST_NOT_MIGRATED',
1079: p_error_desc => 'Price List Id ' || invalid_prc_rec.price_list_id || ' was not migrated. Please check qp_upgrade_errors for more details.',
1080: p_error_module => 'PRICE_LISTS');

Line 1089: QP_Util.Log_Error(p_id1 => invalid_sec_rec.secondary_price_list_id,

1085: -- Secondary price lists Not Migrated
1086:
1087: FOR invalid_sec_rec in invalid_sec
1088: LOOP
1089: QP_Util.Log_Error(p_id1 => invalid_sec_rec.secondary_price_list_id,
1090: p_id2 => invalid_sec_rec.price_list_id,
1091: p_error_type => 'SECONDARY_LISTS_NOT_MIGRATED',
1092: p_error_desc => 'Price List Id ' || invalid_sec_rec.secondary_price_list_id || ' does not exist. Hence Price List Id ' || invalid_sec_rec.price_list_id ||'is not created as a qualifier',
1093: p_error_module => 'PRICE_LISTS');

Line 1100: -- QP_UTIL.QP_UPGRADE_CONTEXT('OE', 'QP', 'SO_PRICE_LISTS', 'QP_LIST_HEADERS');

1096: --dbms_output.put_line('pr12');
1097:
1098: -- Upgrade_Flex_Structures;
1099:
1100: -- QP_UTIL.QP_UPGRADE_CONTEXT('OE', 'QP', 'SO_PRICE_LISTS', 'QP_LIST_HEADERS');
1101: -- QP_UTIL.QP_UPGRADE_CONTEXT('OE', 'QP', 'SO_PRICE_LIST_LINES', 'QP_LIST_LINES');
1102:
1103: EXCEPTION
1104:

Line 1101: -- QP_UTIL.QP_UPGRADE_CONTEXT('OE', 'QP', 'SO_PRICE_LIST_LINES', 'QP_LIST_LINES');

1097:
1098: -- Upgrade_Flex_Structures;
1099:
1100: -- QP_UTIL.QP_UPGRADE_CONTEXT('OE', 'QP', 'SO_PRICE_LISTS', 'QP_LIST_HEADERS');
1101: -- QP_UTIL.QP_UPGRADE_CONTEXT('OE', 'QP', 'SO_PRICE_LIST_LINES', 'QP_LIST_LINES');
1102:
1103: EXCEPTION
1104:
1105: WHEN OTHERS THEN

Line 1108: qp_util.log_error(NULL, NULL, NULL, NULL, NULL, NULL, NULL,

1104:
1105: WHEN OTHERS THEN
1106: v_errortext := SUBSTR(SQLERRM, 1,240);
1107: ROLLBACK;
1108: qp_util.log_error(NULL, NULL, NULL, NULL, NULL, NULL, NULL,
1109: NULL, 'MAIN', v_errortext, 'PRICE_LISTS');
1110:
1111: /*
1112:

Line 1117: QP_Util.Log_Error(p_id1 => invalid_prc_rec.price_list_id,

1113: -- Price Lists not migrated
1114:
1115: FOR invalid_prc_rec in invalid_prc
1116: LOOP
1117: QP_Util.Log_Error(p_id1 => invalid_prc_rec.price_list_id,
1118: p_id2 => NULL,
1119: p_error_type => 'PRICE_LIST_NOT_MIGRATED',
1120: p_error_desc => 'Price List Id ' || invalid_prc_rec.price_list_id || ' was not migrated. Please check qp_upgrade_errors for more details.',
1121: p_error_module => 'PRICE_LISTS');

Line 1127: QP_Util.Log_Error(p_id1 => invalid_sec_rec.secondary_price_list_id,

1123: -- Secondary price lists Not Migrated
1124:
1125: FOR invalid_sec_rec in invalid_sec
1126: LOOP
1127: QP_Util.Log_Error(p_id1 => invalid_sec_rec.secondary_price_list_id,
1128: p_id2 => invalid_sec_rec.price_list_id,
1129: p_error_type => 'SECONDARY_LISTS_NOT_MIGRATED',
1130: p_error_desc => 'Price List Id ' || invalid_sec_rec.secondary_price_list_id || ' does not exist. Hence Price List Id ' || invalid_sec_rec.price_list_id ||'is not created as a qualifier',
1131: p_error_module => 'PRICE_LISTS');

Line 1377: v_segs_upg_t qp_util.v_segs_upg_tab;

1373:
1374: prc_list_maps prc_list_map_tbl_type;
1375: new_prc_list_maps prc_list_map_tbl_type;
1376: l_prc_list_map_index number := 0;
1377: v_segs_upg_t qp_util.v_segs_upg_tab;
1378: l_pricing_context varchar2(30) := NULL;
1379:
1380: cursor prc_list_line IS
1381: SELECT

Line 1541: -- qp_util.log_error(NULL, NULL, NULL, NULL, NULL, NULL, NULL,

1537: FROM SO_PRICE_LISTS_B where secondary_price_list_id IS NOT NULL;
1538:
1539: begin
1540:
1541: -- qp_util.log_error(NULL, NULL, NULL, NULL, NULL, NULL, NULL,
1542: -- NULL, 'MAIN-0', v_errortext, 'PRICE_LISTS');
1543:
1544:
1545: BEGIN

Line 1547: qp_util.get_segs_for_flex(flexfield_name => 'QP_ATTR_DEFNS_PRICING',

1543:
1544:
1545: BEGIN
1546:
1547: qp_util.get_segs_for_flex(flexfield_name => 'QP_ATTR_DEFNS_PRICING',
1548: application_short_name => 'QP',
1549: x_segs_upg_t => v_segs_upg_t,
1550: error_code => l_error);
1551:

Line 1563: qp_util.log_error(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,

1559: null;
1560: err_num := SQLCODE;
1561: err_msg := 'GET_SEGS_FOR_FLEX';
1562: rollback;
1563: qp_util.log_error(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
1564: 'GET_SEGS_FOR_FLEX', err_msg, 'PRICE_LISTS');
1565: RAISE;
1566:
1567:

Line 1642: -- qp_util.log_error(NULL, NULL, NULL, NULL, NULL, NULL, NULL,

1638: numiterations := trunc((v_max_line-v_min_line)/p_batchsize) + j ;
1639: l_min_line := 0;
1640: l_max_line := v_min_line-1;
1641:
1642: -- qp_util.log_error(NULL, NULL, NULL, NULL, NULL, NULL, NULL,
1643: -- NULL, 'MAIN-0.5', v_errortext, 'PRICE_LISTS');
1644:
1645:
1646: WHILE ( numiterations > 0)

Line 1649: -- qp_util.log_error(NULL, NULL, NULL, NULL, NULL, NULL, NULL,

1645:
1646: WHILE ( numiterations > 0)
1647: LOOP
1648:
1649: -- qp_util.log_error(NULL, NULL, NULL, NULL, NULL, NULL, NULL,
1650: -- NULL, 'MAIN-1', v_errortext, 'PRICE_LISTS');
1651:
1652: --dbms_output.put_line('v_max_line 3 : ' || v_max_line);
1653:

Line 1746: -- qp_util.log_error(NULL, NULL, NULL, NULL, NULL, NULL, NULL,

1742:
1743: CLOSE prc_list_line;
1744:
1745:
1746: -- qp_util.log_error(NULL, NULL, NULL, NULL, NULL, NULL, NULL,
1747: -- NULL, 'MAIN-2', v_errortext, 'PRICE_LISTS');
1748:
1749: IF price_list_line_ids.FIRST is not null THEN
1750:

Line 1795: -- qp_util.log_error(NULL, NULL, NULL, NULL, NULL, NULL, NULL,

1791: END IF;
1792:
1793: END LOOP;
1794:
1795: -- qp_util.log_error(NULL, NULL, NULL, NULL, NULL, NULL, NULL,
1796: -- NULL, 'MAIN-3', v_errortext, 'PRICE_LISTS');
1797:
1798: --dbms_output.put_line('rowcount is : ' || sql%rowcount );
1799:

Line 1808: qp_util.get_segs_flex_precedence(p_segs_upg_t => v_segs_upg_t,

1804:
1805: l_product_context := 'ITEM';
1806: l_product_attr := 'PRICING_ATTRIBUTE1';
1807:
1808: qp_util.get_segs_flex_precedence(p_segs_upg_t => v_segs_upg_t,
1809: p_context => l_product_context,
1810: p_attribute => l_product_attr,
1811: x_precedence => l_prod_precedence,
1812: x_datatype => l_prod_datatype);

Line 1968: qp_util.log_error(price_list_ids(K),

1964: v_errortext := SUBSTR(SQLERRM, 1,240);
1965: K := sql%rowcount + start_prc_list_line_id;
1966: ROLLBACK;
1967: /*
1968: qp_util.log_error(price_list_ids(K),
1969: price_list_line_ids(K),
1970: NULL, NULL, NULL, NULL, NULL,
1971: NULL, 'PRICE_LIST_LINES', v_errortext, 'PRICE_LISTS');
1972: */

Line 1976: -- qp_util.log_error(NULL, NULL, NULL, NULL, NULL, NULL, NULL,

1972: */
1973: RAISE;
1974: END; /* exception handling for forall k in l_min_line .. l_max_line */
1975:
1976: -- qp_util.log_error(NULL, NULL, NULL, NULL, NULL, NULL, NULL,
1977: -- NULL, 'MAIN-5', v_errortext, 'PRICE_LISTS');
1978:
1979: --dbms_output.put_line('crpa 1');
1980:

Line 2083: qp_util.get_segs_flex_precedence(p_segs_upg_t => v_segs_upg_t,

2079: attr_pricing_contexts(attr_count) := l_pricing_context;
2080: attr_pricing_attrs(attr_count) := 'PRICING_ATTRIBUTE1';
2081: attr_pricing_attr_value_froms(attr_count) := pricing_attribute1s(K);
2082: attr_pricing_attr_value_tos(attr_count) := NULL;
2083: qp_util.get_segs_flex_precedence(p_segs_upg_t => v_segs_upg_t,
2084: p_context => attr_pricing_contexts(attr_count),
2085: p_attribute => attr_pricing_attrs(attr_count),
2086: x_precedence => l_prc_precedence,
2087: x_datatype => prc_datatypes(attr_count));

Line 2116: qp_util.get_segs_flex_precedence(p_segs_upg_t => v_segs_upg_t,

2112: attr_pricing_contexts(attr_count) := l_pricing_context;
2113: attr_pricing_attrs(attr_count) := 'PRICING_ATTRIBUTE2';
2114: attr_pricing_attr_value_froms(attr_count) := pricing_attribute2s(K);
2115: attr_pricing_attr_value_tos(attr_count) := NULL;
2116: qp_util.get_segs_flex_precedence(p_segs_upg_t => v_segs_upg_t,
2117: p_context => attr_pricing_contexts(attr_count),
2118: p_attribute => attr_pricing_attrs(attr_count),
2119: x_precedence => l_prc_precedence,
2120: x_datatype => prc_datatypes(attr_count));

Line 2124: qp_util.get_prod_flex_properties

2120: x_datatype => prc_datatypes(attr_count));
2121:
2122: /*
2123: BEGIN
2124: qp_util.get_prod_flex_properties
2125: ( attr_pricing_contexts(attr_count),
2126: attr_pricing_attrs(attr_count),
2127: attr_pricing_attr_value_froms(attr_count),
2128: prc_datatypes(attr_count), l_prc_precedence, l_error);

Line 2136: qp_util.log_error(price_list_ids(K), price_list_line_ids(K),

2132: EXCEPTION
2133: WHEN e_get_prod_flex_properties THEN
2134: err_num := SQLCODE;
2135: err_msg := SUBSTR(SQLERRM, 1, 240);
2136: qp_util.log_error(price_list_ids(K), price_list_line_ids(K),
2137: NULL, NULL, NULL, NULL, NULL, NULL,
2138: 'GET_PROD_FLEX_PRC', err_msg, 'PRICE_LISTS');
2139: END;
2140: */

Line 2169: qp_util.get_segs_flex_precedence(p_segs_upg_t => v_segs_upg_t,

2165: attr_pricing_contexts(attr_count) := l_pricing_context;
2166: attr_pricing_attrs(attr_count) := 'PRICING_ATTRIBUTE3';
2167: attr_pricing_attr_value_froms(attr_count) := pricing_attribute3s(K);
2168: attr_pricing_attr_value_tos(attr_count) := NULL;
2169: qp_util.get_segs_flex_precedence(p_segs_upg_t => v_segs_upg_t,
2170: p_context => attr_pricing_contexts(attr_count),
2171: p_attribute => attr_pricing_attrs(attr_count),
2172: x_precedence => l_prc_precedence,
2173: x_datatype => prc_datatypes(attr_count));

Line 2178: qp_util.get_prod_flex_properties

2174:
2175: /*
2176: --l_pricing_attr_tbl(I) := l_pricing_attr_rec;
2177: BEGIN
2178: qp_util.get_prod_flex_properties
2179: ( attr_pricing_contexts(attr_count),
2180: attr_pricing_attrs(attr_count),
2181: attr_pricing_attr_value_froms(attr_count),
2182: prc_datatypes(attr_count), l_prc_precedence, l_error);

Line 2190: qp_util.log_error(price_list_ids(K), price_list_line_ids(K),

2186: EXCEPTION
2187: WHEN e_get_prod_flex_properties THEN
2188: err_num := SQLCODE;
2189: err_msg := SUBSTR(SQLERRM, 1, 240);
2190: qp_util.log_error(price_list_ids(K), price_list_line_ids(K),
2191: NULL, NULL, NULL, NULL, NULL, NULL,
2192: 'GET_PROD_FLEX_PRC', err_msg, 'PRICE_LISTS');
2193: END;
2194: */

Line 2223: qp_util.get_segs_flex_precedence(p_segs_upg_t => v_segs_upg_t,

2219: attr_pricing_contexts(attr_count) := l_pricing_context;
2220: attr_pricing_attrs(attr_count) := 'PRICING_ATTRIBUTE4';
2221: attr_pricing_attr_value_froms(attr_count) := pricing_attribute4s(K);
2222: attr_pricing_attr_value_tos(attr_count) := NULL;
2223: qp_util.get_segs_flex_precedence(p_segs_upg_t => v_segs_upg_t,
2224: p_context => attr_pricing_contexts(attr_count),
2225: p_attribute => attr_pricing_attrs(attr_count),
2226: x_precedence => l_prc_precedence,
2227: x_datatype => prc_datatypes(attr_count));

Line 2230: qp_util.get_prod_flex_properties

2226: x_precedence => l_prc_precedence,
2227: x_datatype => prc_datatypes(attr_count));
2228: /*
2229: BEGIN
2230: qp_util.get_prod_flex_properties
2231: ( attr_pricing_contexts(attr_count),
2232: attr_pricing_attrs(attr_count),
2233: attr_pricing_attr_value_froms(attr_count),
2234: prc_datatypes(attr_count), l_prc_precedence, l_error);

Line 2242: qp_util.log_error(price_list_ids(K), price_list_line_ids(K),

2238: EXCEPTION
2239: WHEN e_get_prod_flex_properties THEN
2240: err_num := SQLCODE;
2241: err_msg := SUBSTR(SQLERRM, 1, 240);
2242: qp_util.log_error(price_list_ids(K), price_list_line_ids(K),
2243: NULL, NULL, NULL, NULL, NULL, NULL,
2244: 'GET_PROD_FLEX_PRC', err_msg, 'PRICE_LISTS');
2245: END;
2246: --l_pricing_attr_tbl(I) := l_pricing_attr_rec;

Line 2276: qp_util.get_segs_flex_precedence(p_segs_upg_t => v_segs_upg_t,

2272: attr_pricing_contexts(attr_count) := l_pricing_context;
2273: attr_pricing_attrs(attr_count) := 'PRICING_ATTRIBUTE5';
2274: attr_pricing_attr_value_froms(attr_count) := pricing_attribute5s(K);
2275: attr_pricing_attr_value_tos(attr_count) := NULL;
2276: qp_util.get_segs_flex_precedence(p_segs_upg_t => v_segs_upg_t,
2277: p_context => attr_pricing_contexts(attr_count),
2278: p_attribute => attr_pricing_attrs(attr_count),
2279: x_precedence => l_prc_precedence,
2280: x_datatype => prc_datatypes(attr_count));

Line 2283: qp_util.get_prod_flex_properties

2279: x_precedence => l_prc_precedence,
2280: x_datatype => prc_datatypes(attr_count));
2281: /*
2282: BEGIN
2283: qp_util.get_prod_flex_properties
2284: ( attr_pricing_contexts(attr_count),
2285: attr_pricing_attrs(attr_count),
2286: attr_pricing_attr_value_froms(attr_count),
2287: prc_datatypes(attr_count), l_prc_precedence, l_error);

Line 2295: qp_util.log_error(price_list_ids(K), price_list_line_ids(K),

2291: EXCEPTION
2292: WHEN e_get_prod_flex_properties THEN
2293: err_num := SQLCODE;
2294: err_msg := SUBSTR(SQLERRM, 1, 240);
2295: qp_util.log_error(price_list_ids(K), price_list_line_ids(K),
2296: NULL, NULL, NULL, NULL, NULL, NULL,
2297: 'GET_PROD_FLEX_PRC', err_msg, 'PRICE_LISTS');
2298: END;
2299: --l_pricing_attr_tbl(I) := l_pricing_attr_rec;

Line 2329: qp_util.get_segs_flex_precedence(p_segs_upg_t => v_segs_upg_t,

2325: attr_pricing_contexts(attr_count) := l_pricing_context;
2326: attr_pricing_attrs(attr_count) := 'PRICING_ATTRIBUTE6';
2327: attr_pricing_attr_value_froms(attr_count) := pricing_attribute6s(K);
2328: attr_pricing_attr_value_tos(attr_count) := NULL;
2329: qp_util.get_segs_flex_precedence(p_segs_upg_t => v_segs_upg_t,
2330: p_context => attr_pricing_contexts(attr_count),
2331: p_attribute => attr_pricing_attrs(attr_count),
2332: x_precedence => l_prc_precedence,
2333: x_datatype => prc_datatypes(attr_count));

Line 2336: qp_util.get_prod_flex_properties

2332: x_precedence => l_prc_precedence,
2333: x_datatype => prc_datatypes(attr_count));
2334: /*
2335: BEGIN
2336: qp_util.get_prod_flex_properties
2337: ( attr_pricing_contexts(attr_count),
2338: attr_pricing_attrs(attr_count),
2339: attr_pricing_attr_value_froms(attr_count),
2340: prc_datatypes(attr_count), l_prc_precedence, l_error);

Line 2348: qp_util.log_error(price_list_ids(K), price_list_line_ids(K),

2344: EXCEPTION
2345: WHEN e_get_prod_flex_properties THEN
2346: err_num := SQLCODE;
2347: err_msg := SUBSTR(SQLERRM, 1, 240);
2348: qp_util.log_error(price_list_ids(K), price_list_line_ids(K),
2349: NULL, NULL, NULL, NULL, NULL, NULL,
2350: 'GET_PROD_FLEX_PRC', err_msg, 'PRICE_LISTS');
2351: END;
2352: --l_pricing_attr_tbl(I) := l_pricing_attr_rec;

Line 2382: qp_util.get_segs_flex_precedence(p_segs_upg_t => v_segs_upg_t,

2378: attr_pricing_contexts(attr_count) := l_pricing_context;
2379: attr_pricing_attrs(attr_count) := 'PRICING_ATTRIBUTE7';
2380: attr_pricing_attr_value_froms(attr_count) := pricing_attribute7s(K);
2381: attr_pricing_attr_value_tos(attr_count) := NULL;
2382: qp_util.get_segs_flex_precedence(p_segs_upg_t => v_segs_upg_t,
2383: p_context => attr_pricing_contexts(attr_count),
2384: p_attribute => attr_pricing_attrs(attr_count),
2385: x_precedence => l_prc_precedence,
2386: x_datatype => prc_datatypes(attr_count));

Line 2389: qp_util.get_prod_flex_properties

2385: x_precedence => l_prc_precedence,
2386: x_datatype => prc_datatypes(attr_count));
2387: /*
2388: BEGIN
2389: qp_util.get_prod_flex_properties
2390: ( attr_pricing_contexts(attr_count),
2391: attr_pricing_attrs(attr_count),
2392: attr_pricing_attr_value_froms(attr_count),
2393: prc_datatypes(attr_count), l_prc_precedence, l_error);

Line 2401: qp_util.log_error(price_list_ids(K), price_list_line_ids(K),

2397: EXCEPTION
2398: WHEN e_get_prod_flex_properties THEN
2399: err_num := SQLCODE;
2400: err_msg := SUBSTR(SQLERRM, 1, 240);
2401: qp_util.log_error(price_list_ids(K), price_list_line_ids(K),
2402: NULL, NULL, NULL, NULL, NULL, NULL,
2403: 'GET_PROD_FLEX_PRC', err_msg, 'PRICE_LISTS');
2404: END;
2405: --l_pricing_attr_tbl(I) := l_pricing_attr_rec;

Line 2435: qp_util.get_segs_flex_precedence(p_segs_upg_t => v_segs_upg_t,

2431: attr_pricing_contexts(attr_count) := l_pricing_context;
2432: attr_pricing_attrs(attr_count) := 'PRICING_ATTRIBUTE8';
2433: attr_pricing_attr_value_froms(attr_count) := pricing_attribute8s(K);
2434: attr_pricing_attr_value_tos(attr_count) := NULL;
2435: qp_util.get_segs_flex_precedence(p_segs_upg_t => v_segs_upg_t,
2436: p_context => attr_pricing_contexts(attr_count),
2437: p_attribute => attr_pricing_attrs(attr_count),
2438: x_precedence => l_prc_precedence,
2439: x_datatype => prc_datatypes(attr_count));

Line 2442: qp_util.get_prod_flex_properties

2438: x_precedence => l_prc_precedence,
2439: x_datatype => prc_datatypes(attr_count));
2440: /*
2441: BEGIN
2442: qp_util.get_prod_flex_properties
2443: ( attr_pricing_contexts(attr_count),
2444: attr_pricing_attrs(attr_count),
2445: attr_pricing_attr_value_froms(attr_count),
2446: prc_datatypes(attr_count), l_prc_precedence, l_error);

Line 2454: qp_util.log_error(price_list_ids(K), price_list_line_ids(K),

2450: EXCEPTION
2451: WHEN e_get_prod_flex_properties THEN
2452: err_num := SQLCODE;
2453: err_msg := SUBSTR(SQLERRM, 1, 240);
2454: qp_util.log_error(price_list_ids(K), price_list_line_ids(K),
2455: NULL, NULL, NULL, NULL, NULL, NULL,
2456: 'GET_PROD_FLEX_PRC', err_msg, 'PRICE_LISTS');
2457: END;
2458: --l_pricing_attr_tbl(I) := l_pricing_attr_rec;

Line 2488: qp_util.get_segs_flex_precedence(p_segs_upg_t => v_segs_upg_t,

2484: attr_pricing_contexts(attr_count) := l_pricing_context;
2485: attr_pricing_attrs(attr_count) := 'PRICING_ATTRIBUTE9';
2486: attr_pricing_attr_value_froms(attr_count) := pricing_attribute9s(K);
2487: attr_pricing_attr_value_tos(attr_count) := NULL;
2488: qp_util.get_segs_flex_precedence(p_segs_upg_t => v_segs_upg_t,
2489: p_context => attr_pricing_contexts(attr_count),
2490: p_attribute => attr_pricing_attrs(attr_count),
2491: x_precedence => l_prc_precedence,
2492: x_datatype => prc_datatypes(attr_count));

Line 2495: qp_util.get_prod_flex_properties

2491: x_precedence => l_prc_precedence,
2492: x_datatype => prc_datatypes(attr_count));
2493: /*
2494: BEGIN
2495: qp_util.get_prod_flex_properties
2496: ( attr_pricing_contexts(attr_count),
2497: attr_pricing_attrs(attr_count),
2498: attr_pricing_attr_value_froms(attr_count),
2499: prc_datatypes(attr_count), l_prc_precedence, l_error);

Line 2507: qp_util.log_error(price_list_ids(K), price_list_line_ids(K),

2503: EXCEPTION
2504: WHEN e_get_prod_flex_properties THEN
2505: err_num := SQLCODE;
2506: err_msg := SUBSTR(SQLERRM, 1, 240);
2507: qp_util.log_error(price_list_ids(K), price_list_line_ids(K),
2508: NULL, NULL, NULL, NULL, NULL, NULL,
2509: 'GET_PROD_FLEX_PRC', err_msg, 'PRICE_LISTS');
2510: END;
2511: --l_pricing_attr_tbl(I) := l_pricing_attr_rec;

Line 2541: qp_util.get_segs_flex_precedence(p_segs_upg_t => v_segs_upg_t,

2537: attr_pricing_contexts(attr_count) := l_pricing_context;
2538: attr_pricing_attrs(attr_count) := 'PRICING_ATTRIBUTE10';
2539: attr_pricing_attr_value_froms(attr_count) := pricing_attribute10s(K);
2540: attr_pricing_attr_value_tos(attr_count) := NULL;
2541: qp_util.get_segs_flex_precedence(p_segs_upg_t => v_segs_upg_t,
2542: p_context => attr_pricing_contexts(attr_count),
2543: p_attribute => attr_pricing_attrs(attr_count),
2544: x_precedence => l_prc_precedence,
2545: x_datatype => prc_datatypes(attr_count));

Line 2548: qp_util.get_prod_flex_properties

2544: x_precedence => l_prc_precedence,
2545: x_datatype => prc_datatypes(attr_count));
2546: /*
2547: BEGIN
2548: qp_util.get_prod_flex_properties
2549: ( attr_pricing_contexts(attr_count),
2550: attr_pricing_attrs(attr_count),
2551: attr_pricing_attr_value_froms(attr_count),
2552: prc_datatypes(attr_count), l_prc_precedence, l_error);

Line 2560: qp_util.log_error(price_list_ids(K), price_list_line_ids(K),

2556: EXCEPTION
2557: WHEN e_get_prod_flex_properties THEN
2558: err_num := SQLCODE;
2559: err_msg := SUBSTR(SQLERRM, 1, 240);
2560: qp_util.log_error(price_list_ids(K), price_list_line_ids(K),
2561: NULL, NULL, NULL, NULL, NULL, NULL,
2562: 'GET_PROD_FLEX_PRC', err_msg, 'PRICE_LISTS');
2563: END;
2564: --l_pricing_attr_tbl(I) := l_pricing_attr_rec;

Line 2594: qp_util.get_segs_flex_precedence(p_segs_upg_t => v_segs_upg_t,

2590: attr_pricing_contexts(attr_count) := l_pricing_context;
2591: attr_pricing_attrs(attr_count) := 'PRICING_ATTRIBUTE11';
2592: attr_pricing_attr_value_froms(attr_count) := pricing_attribute11s(K);
2593: attr_pricing_attr_value_tos(attr_count) := NULL;
2594: qp_util.get_segs_flex_precedence(p_segs_upg_t => v_segs_upg_t,
2595: p_context => attr_pricing_contexts(attr_count),
2596: p_attribute => attr_pricing_attrs(attr_count),
2597: x_precedence => l_prc_precedence,
2598: x_datatype => prc_datatypes(attr_count));

Line 2601: qp_util.get_prod_flex_properties

2597: x_precedence => l_prc_precedence,
2598: x_datatype => prc_datatypes(attr_count));
2599: /*
2600: BEGIN
2601: qp_util.get_prod_flex_properties
2602: ( attr_pricing_contexts(attr_count),
2603: attr_pricing_attrs(attr_count),
2604: attr_pricing_attr_value_froms(attr_count),
2605: prc_datatypes(attr_count), l_prc_precedence, l_error);

Line 2613: qp_util.log_error(price_list_ids(K), price_list_line_ids(K),

2609: EXCEPTION
2610: WHEN e_get_prod_flex_properties THEN
2611: err_num := SQLCODE;
2612: err_msg := SUBSTR(SQLERRM, 1, 240);
2613: qp_util.log_error(price_list_ids(K), price_list_line_ids(K),
2614: NULL, NULL, NULL, NULL, NULL, NULL,
2615: 'GET_PROD_FLEX_PRC', err_msg, 'PRICE_LISTS');
2616: END;
2617: --l_pricing_attr_tbl(I) := l_pricing_attr_rec;

Line 2647: qp_util.get_segs_flex_precedence(p_segs_upg_t => v_segs_upg_t,

2643: attr_pricing_contexts(attr_count) := l_pricing_context;
2644: attr_pricing_attrs(attr_count) := 'PRICING_ATTRIBUTE12';
2645: attr_pricing_attr_value_froms(attr_count) := pricing_attribute12s(K);
2646: attr_pricing_attr_value_tos(attr_count) := NULL;
2647: qp_util.get_segs_flex_precedence(p_segs_upg_t => v_segs_upg_t,
2648: p_context => attr_pricing_contexts(attr_count),
2649: p_attribute => attr_pricing_attrs(attr_count),
2650: x_precedence => l_prc_precedence,
2651: x_datatype => prc_datatypes(attr_count));

Line 2654: qp_util.get_prod_flex_properties

2650: x_precedence => l_prc_precedence,
2651: x_datatype => prc_datatypes(attr_count));
2652: /*
2653: BEGIN
2654: qp_util.get_prod_flex_properties
2655: ( attr_pricing_contexts(attr_count),
2656: attr_pricing_attrs(attr_count),
2657: attr_pricing_attr_value_froms(attr_count),
2658: prc_datatypes(attr_count), l_prc_precedence, l_error);

Line 2666: qp_util.log_error(price_list_ids(K), price_list_line_ids(K),

2662: EXCEPTION
2663: WHEN e_get_prod_flex_properties THEN
2664: err_num := SQLCODE;
2665: err_msg := SUBSTR(SQLERRM, 1, 240);
2666: qp_util.log_error(price_list_ids(K), price_list_line_ids(K),
2667: NULL, NULL, NULL, NULL, NULL, NULL,
2668: 'GET_PROD_FLEX_PRC', err_msg, 'PRICE_LISTS');
2669: END;
2670: --l_pricing_attr_tbl(I) := l_pricing_attr_rec;

Line 2698: qp_util.get_segs_flex_precedence(p_segs_upg_t => v_segs_upg_t,

2694: attr_pricing_contexts(attr_count) := l_pricing_context;
2695: attr_pricing_attrs(attr_count) := 'PRICING_ATTRIBUTE13';
2696: attr_pricing_attr_value_froms(attr_count) := pricing_attribute13s(K);
2697: attr_pricing_attr_value_tos(attr_count) := NULL;
2698: qp_util.get_segs_flex_precedence(p_segs_upg_t => v_segs_upg_t,
2699: p_context => attr_pricing_contexts(attr_count),
2700: p_attribute => attr_pricing_attrs(attr_count),
2701: x_precedence => l_prc_precedence,
2702: x_datatype => prc_datatypes(attr_count));

Line 2705: qp_util.get_prod_flex_properties

2701: x_precedence => l_prc_precedence,
2702: x_datatype => prc_datatypes(attr_count));
2703: /*
2704: BEGIN
2705: qp_util.get_prod_flex_properties
2706: ( attr_pricing_contexts(attr_count),
2707: attr_pricing_attrs(attr_count),
2708: attr_pricing_attr_value_froms(attr_count),
2709: prc_datatypes(attr_count), l_prc_precedence, l_error);

Line 2717: qp_util.log_error(price_list_ids(K), price_list_line_ids(K),

2713: EXCEPTION
2714: WHEN e_get_prod_flex_properties THEN
2715: err_num := SQLCODE;
2716: err_msg := SUBSTR(SQLERRM, 1, 240);
2717: qp_util.log_error(price_list_ids(K), price_list_line_ids(K),
2718: NULL, NULL, NULL, NULL, NULL, NULL,
2719: 'GET_PROD_FLEX_PRC', err_msg, 'PRICE_LISTS');
2720: END;
2721: --l_pricing_attr_tbl(I) := l_pricing_attr_rec;

Line 2749: qp_util.get_segs_flex_precedence(p_segs_upg_t => v_segs_upg_t,

2745: attr_pricing_contexts(attr_count) := l_pricing_context;
2746: attr_pricing_attrs(attr_count) := 'PRICING_ATTRIBUTE14';
2747: attr_pricing_attr_value_froms(attr_count) := pricing_attribute14s(K);
2748: attr_pricing_attr_value_tos(attr_count) := NULL;
2749: qp_util.get_segs_flex_precedence(p_segs_upg_t => v_segs_upg_t,
2750: p_context => attr_pricing_contexts(attr_count),
2751: p_attribute => attr_pricing_attrs(attr_count),
2752: x_precedence => l_prc_precedence,
2753: x_datatype => prc_datatypes(attr_count));

Line 2756: qp_util.get_prod_flex_properties

2752: x_precedence => l_prc_precedence,
2753: x_datatype => prc_datatypes(attr_count));
2754: /*
2755: BEGIN
2756: qp_util.get_prod_flex_properties
2757: ( attr_pricing_contexts(attr_count),
2758: attr_pricing_attrs(attr_count),
2759: attr_pricing_attr_value_froms(attr_count),
2760: prc_datatypes(attr_count), l_prc_precedence, l_error);

Line 2768: qp_util.log_error(price_list_ids(K), price_list_line_ids(K),

2764: EXCEPTION
2765: WHEN e_get_prod_flex_properties THEN
2766: err_num := SQLCODE;
2767: err_msg := SUBSTR(SQLERRM, 1, 240);
2768: qp_util.log_error(price_list_ids(K), price_list_line_ids(K),
2769: NULL, NULL, NULL, NULL, NULL, NULL,
2770: 'GET_PROD_FLEX_PRC', err_msg, 'PRICE_LISTS');
2771: END;
2772: --l_pricing_attr_tbl(I) := l_pricing_attr_rec;

Line 2802: qp_util.get_segs_flex_precedence(p_segs_upg_t => v_segs_upg_t,

2798: attr_pricing_contexts(attr_count) := l_pricing_context;
2799: attr_pricing_attrs(attr_count) := 'PRICING_ATTRIBUTE15';
2800: attr_pricing_attr_value_froms(attr_count) := pricing_attribute15s(K);
2801: attr_pricing_attr_value_tos(attr_count) := NULL;
2802: qp_util.get_segs_flex_precedence(p_segs_upg_t => v_segs_upg_t,
2803: p_context => attr_pricing_contexts(attr_count),
2804: p_attribute => attr_pricing_attrs(attr_count),
2805: x_precedence => l_prc_precedence,
2806: x_datatype => prc_datatypes(attr_count));

Line 2809: qp_util.get_prod_flex_properties

2805: x_precedence => l_prc_precedence,
2806: x_datatype => prc_datatypes(attr_count));
2807: /*
2808: BEGIN
2809: qp_util.get_prod_flex_properties
2810: ( attr_pricing_contexts(attr_count),
2811: attr_pricing_attrs(attr_count),
2812: attr_pricing_attr_value_froms(attr_count),
2813: prc_datatypes(attr_count), l_prc_precedence, l_error);

Line 2821: qp_util.log_error(price_list_ids(K), price_list_line_ids(K),

2817: EXCEPTION
2818: WHEN e_get_prod_flex_properties THEN
2819: err_num := SQLCODE;
2820: err_msg := SUBSTR(SQLERRM, 1, 240);
2821: qp_util.log_error(price_list_ids(K), price_list_line_ids(K),
2822: NULL, NULL, NULL, NULL, NULL, NULL,
2823: 'GET_PROD_FLEX_PRC', err_msg, 'PRICE_LISTS');
2824: END;
2825: --l_pricing_attr_tbl(I) := l_pricing_attr_rec;

Line 2832: --qp_util.log_error(NULL, NULL, NULL, NULL, NULL, NULL, NULL,

2828:
2829: END LOOP;
2830:
2831: --dbms_output.put_line('crpa 117');
2832: --qp_util.log_error(NULL, NULL, NULL, NULL, NULL, NULL, NULL,
2833: -- NULL, 'MAIN-6', v_errortext, 'PRICE_LISTS');
2834:
2835: BEGIN
2836:

Line 2907: QP_Util.Log_Error(p_id1 => attr_list_line_ids(J) ,

2903: WHEN OTHERS THEN
2904: err_msg := SQLERRM;
2905: J := sql%rowcount + 1;
2906: rollback;
2907: QP_Util.Log_Error(p_id1 => attr_list_line_ids(J) ,
2908: p_id2 => NULL,
2909: p_error_type => 'PRICE_LIST_LINES_ATTR',
2910: p_error_desc => err_msg,
2911: p_error_module => 'Create_Pricing_Attribute');

Line 2916: --qp_util.log_error(NULL, NULL, NULL, NULL, NULL, NULL, NULL,

2912: raise;
2913:
2914: END;
2915:
2916: --qp_util.log_error(NULL, NULL, NULL, NULL, NULL, NULL, NULL,
2917: -- NULL, 'MAIN-7', v_errortext, 'PRICE_LISTS');
2918:
2919:
2920:

Line 2924: -- qp_util.log_error(NULL, NULL, NULL, NULL, NULL, NULL, NULL,

2920:
2921: /* insert into qp_discount_mapping table for the rows that were
2922: just now inserted */
2923:
2924: -- qp_util.log_error(NULL, NULL, NULL, NULL, NULL, NULL, NULL,
2925: -- NULL, 'MAIN-8', v_errortext, 'PRICE_LISTS');
2926:
2927: /*
2928:

Line 2957: -- qp_util.log_error(NULL, NULL, NULL, NULL, NULL, NULL, NULL,

2953: NULL);
2954:
2955: */
2956:
2957: -- qp_util.log_error(NULL, NULL, NULL, NULL, NULL, NULL, NULL,
2958: -- NULL, 'MAIN-9', v_errortext, 'PRICE_LISTS');
2959: /* vivek
2960:
2961: prc_list_maps := new_prc_list_maps;

Line 2983: qp_util.log_error(price_list_ids(K), NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'PRICE_LIST_LINES_MAIN', v_errortext, 'PRICE_LISTS');

2979: v_errortext := SUBSTR(SQLERRM, 1,240);
2980: K := sql%rowcount + l_min_line;
2981: ROLLBACK;
2982: If price_list_ids.exists(k) then
2983: qp_util.log_error(price_list_ids(K), NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'PRICE_LIST_LINES_MAIN', v_errortext, 'PRICE_LISTS');
2984: else
2985: qp_util.log_error(-1111, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'PRICE_LIST_LINES_MAIN', v_errortext, 'PRICE_LISTS');
2986: end if;
2987: RAISE;

Line 2985: qp_util.log_error(-1111, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'PRICE_LIST_LINES_MAIN', v_errortext, 'PRICE_LISTS');

2981: ROLLBACK;
2982: If price_list_ids.exists(k) then
2983: qp_util.log_error(price_list_ids(K), NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'PRICE_LIST_LINES_MAIN', v_errortext, 'PRICE_LISTS');
2984: else
2985: qp_util.log_error(-1111, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'PRICE_LIST_LINES_MAIN', v_errortext, 'PRICE_LISTS');
2986: end if;
2987: RAISE;
2988:
2989: end create_list_lines;