APPS.QP_PRC_UTIL dependencies on OE_DEBUG_PUB

Line 54: oe_debug_pub.add('Entering QP_PRC_UTIL.EQUAL', 1);

50: ) RETURN BOOLEAN
51: IS
52: BEGIN
53:
54: oe_debug_pub.add('Entering QP_PRC_UTIL.EQUAL', 1);
55:
56: RETURN ( p_attr1 IS NULL AND
57: p_attr2 IS NULL ) OR
58: ( p_attr1 IS NOT NULL AND

Line 62: oe_debug_pub.add('Exiting QP_PRC_UTIL.EQUAL', 1);

58: ( p_attr1 IS NOT NULL AND
59: p_attr2 IS NOT NULL AND
60: p_attr1 = p_attr2 );
61:
62: oe_debug_pub.add('Exiting QP_PRC_UTIL.EQUAL', 1);
63:
64: END Equal;
65:
66: FUNCTION Equal

Line 107: oe_debug_pub.add('Entering QP_PRC_UTIL.GET_HDR_ADJ_TOTAL', 1);

103: IS
104: l_adj_total NUMBER := 0;
105: BEGIN
106:
107: oe_debug_pub.add('Entering QP_PRC_UTIL.GET_HDR_ADJ_TOTAL', 1);
108:
109: -- If p_header_id is NULL, return 0
110:
111: IF p_header_id IS NULL THEN

Line 113: oe_debug_pub.add('Exiting QP_PRC_UTIL.GET_HDR_ADJ_TOTAL', 1);

109: -- If p_header_id is NULL, return 0
110:
111: IF p_header_id IS NULL THEN
112:
113: oe_debug_pub.add('Exiting QP_PRC_UTIL.GET_HDR_ADJ_TOTAL', 1);
114:
115: RETURN 0;
116: END IF;
117:

Line 132: oe_debug_pub.add('Exiting QP_PRC_UTIL.GET_HDR_ADJ_TOTAL', 1);

128: l_adj_total := 0;
129:
130: END IF;
131:
132: oe_debug_pub.add('Exiting QP_PRC_UTIL.GET_HDR_ADJ_TOTAL', 1);
133:
134: RETURN l_adj_total;
135:
136: EXCEPTION

Line 163: oe_debug_pub.add('Entering QP_PRC_UTIL.GET_AGR_TYPE', 1);

159: IS
160: l_agr_type_code VARCHAR2(30);
161: BEGIN
162:
163: oe_debug_pub.add('Entering QP_PRC_UTIL.GET_AGR_TYPE', 1);
164:
165: -- If p_agreement_id is NULL, return NULL
166:
167: IF p_agreement_id IS NULL THEN

Line 169: oe_debug_pub.add('Exiting QP_PRC_UTIL.GET_AGR_TYPE', 1);

165: -- If p_agreement_id is NULL, return NULL
166:
167: IF p_agreement_id IS NULL THEN
168:
169: oe_debug_pub.add('Exiting QP_PRC_UTIL.GET_AGR_TYPE', 1);
170:
171: RETURN NULL;
172: END IF;
173:

Line 181: oe_debug_pub.add('Exiting QP_PRC_UTIL.GET_AGR_TYPE', 1);

177: INTO l_agr_type_code
178: FROM OE_AGREEMENTS
179: WHERE AGREEMENT_ID = p_agreement_id;
180:
181: oe_debug_pub.add('Exiting QP_PRC_UTIL.GET_AGR_TYPE', 1);
182:
183: RETURN l_agr_type_code;
184:
185: EXCEPTION

Line 221: oe_debug_pub.add('Entering QP_PRC_UTIL.GET_ITEM_CATEGORY', 1);

217: l_org_id NUMBER := NULL;
218: l_item_category_id NUMBER := NULL;
219: BEGIN
220:
221: oe_debug_pub.add('Entering QP_PRC_UTIL.GET_ITEM_CATEGORY', 1);
222:
223: IF p_item_id IS NOT NULL THEN
224:
225: -- Fetch validation org.

Line 244: oe_debug_pub.add('Exiting QP_PRC_UTIL.GET_ITEM_CATEGORY', 1);

240: END IF;
241:
242: END IF;
243:
244: oe_debug_pub.add('Exiting QP_PRC_UTIL.GET_ITEM_CATEGORY', 1);
245:
246: RETURN l_item_category_id;
247:
248:

Line 283: oe_debug_pub.add('Entering QP_PRC_UTIL.GET_CUST_CLASS', 1);

279: IS
280: l_class_code VARCHAR2(30);
281: BEGIN
282:
283: oe_debug_pub.add('Entering QP_PRC_UTIL.GET_CUST_CLASS', 1);
284:
285: -- If p_customer_id is NULL, return NULL
286:
287: IF p_sold_to_org_id IS NULL THEN

Line 289: oe_debug_pub.add('Exiting QP_PRC_UTIL.GET_CUST_CLASS', 1);

285: -- If p_customer_id is NULL, return NULL
286:
287: IF p_sold_to_org_id IS NULL THEN
288:
289: oe_debug_pub.add('Exiting QP_PRC_UTIL.GET_CUST_CLASS', 1);
290:
291: RETURN NULL;
292: END IF;
293:

Line 301: oe_debug_pub.add('Exiting QP_PRC_UTIL.GET_CUST_CLASS', 1);

297: INTO l_class_code
298: FROM HZ_CUST_ACCOUNTS
299: WHERE CUST_ACCOUNT_ID = p_sold_to_org_id;
300:
301: oe_debug_pub.add('Exiting QP_PRC_UTIL.GET_CUST_CLASS', 1);
302:
303: RETURN l_class_code;
304:
305: EXCEPTION

Line 388: oe_debug_pub.add('Entering QP_PRC_UTIL.QUERY_ADJUSTMENTS', 1);

384: adj_number NUMBER := 0;
385:
386: BEGIN
387:
388: oe_debug_pub.add('Entering QP_PRC_UTIL.QUERY_ADJUSTMENTS', 1);
389:
390: -- Header level adjustments.
391:
392: IF p_header_id IS NOT NULL THEN

Line 453: oe_debug_pub.add('Exiting QP_PRC_UTIL.QUERY_ADJUSTMENTS', 1);

449: CLOSE l_line_adj_csr;
450:
451: END IF;
452:
453: oe_debug_pub.add('Exiting QP_PRC_UTIL.QUERY_ADJUSTMENTS', 1);
454:
455: EXCEPTION
456:
457: WHEN OTHERS THEN

Line 543: oe_debug_pub.add('Entering QP_PRC_UTIL.ATTRIBUTE_USED', 1);

539: --QP END
540:
541: BEGIN
542:
543: oe_debug_pub.add('Entering QP_PRC_UTIL.ATTRIBUTE_USED', 1);
544:
545: IF NOT G_ATTRIBUTES_QUERIED THEN
546:
547: -- First time to call this function. Fetch values from DB.

Line 619: oe_debug_pub.add('Exiting QP_PRC_UTIL.ATTRIBUTE_USED', 1);

615: END IF;
616:
617: END IF;
618:
619: oe_debug_pub.add('Exiting QP_PRC_UTIL.ATTRIBUTE_USED', 1);
620:
621: RETURN G_ATTRIBUTE_USED(p_attribute_id);
622:
623: EXCEPTION

Line 695: oe_debug_pub.add('Entering QP_PRC_UTIL.GET_ADJUSTMENT', 1);

691: l_qp_discount_line_rec QP_PRICING_ENGINE_PVT.l_discount_line_rec;
692:
693: BEGIN
694:
695: oe_debug_pub.add('Entering QP_PRC_UTIL.GET_ADJUSTMENT', 1);
696:
697:
698:
699: IF p_list_price = 0 THEN

Line 732: OE_DEBUG_PUB.ADD('+================================+');

728: --DBMS_OUTPUT.PUT_LINE('+================================+');
729: --DBMS_OUTPUT.PUT_LINE('Discounting type is low--ASC');
730: --DBMS_OUTPUT.PUT_LINE('p_gsa : '||p_gsa);
731: --DBMS_OUTPUT.PUT_LINE('l_pricing_date : '||l_pricing_date);
732: OE_DEBUG_PUB.ADD('+================================+');
733: OE_DEBUG_PUB.ADD('|IN Big select statement --Header| ');
734: OE_DEBUG_PUB.ADD('+================================+');
735: OE_DEBUG_PUB.ADD('Discounting type is low--ASC');
736: OE_DEBUG_PUB.ADD('p_gsa : '||p_gsa);

Line 733: OE_DEBUG_PUB.ADD('|IN Big select statement --Header| ');

729: --DBMS_OUTPUT.PUT_LINE('Discounting type is low--ASC');
730: --DBMS_OUTPUT.PUT_LINE('p_gsa : '||p_gsa);
731: --DBMS_OUTPUT.PUT_LINE('l_pricing_date : '||l_pricing_date);
732: OE_DEBUG_PUB.ADD('+================================+');
733: OE_DEBUG_PUB.ADD('|IN Big select statement --Header| ');
734: OE_DEBUG_PUB.ADD('+================================+');
735: OE_DEBUG_PUB.ADD('Discounting type is low--ASC');
736: OE_DEBUG_PUB.ADD('p_gsa : '||p_gsa);
737: OE_DEBUG_PUB.ADD('l_pricing_date : '||l_pricing_date);

Line 734: OE_DEBUG_PUB.ADD('+================================+');

730: --DBMS_OUTPUT.PUT_LINE('p_gsa : '||p_gsa);
731: --DBMS_OUTPUT.PUT_LINE('l_pricing_date : '||l_pricing_date);
732: OE_DEBUG_PUB.ADD('+================================+');
733: OE_DEBUG_PUB.ADD('|IN Big select statement --Header| ');
734: OE_DEBUG_PUB.ADD('+================================+');
735: OE_DEBUG_PUB.ADD('Discounting type is low--ASC');
736: OE_DEBUG_PUB.ADD('p_gsa : '||p_gsa);
737: OE_DEBUG_PUB.ADD('l_pricing_date : '||l_pricing_date);
738:

Line 735: OE_DEBUG_PUB.ADD('Discounting type is low--ASC');

731: --DBMS_OUTPUT.PUT_LINE('l_pricing_date : '||l_pricing_date);
732: OE_DEBUG_PUB.ADD('+================================+');
733: OE_DEBUG_PUB.ADD('|IN Big select statement --Header| ');
734: OE_DEBUG_PUB.ADD('+================================+');
735: OE_DEBUG_PUB.ADD('Discounting type is low--ASC');
736: OE_DEBUG_PUB.ADD('p_gsa : '||p_gsa);
737: OE_DEBUG_PUB.ADD('l_pricing_date : '||l_pricing_date);
738:
739:

Line 736: OE_DEBUG_PUB.ADD('p_gsa : '||p_gsa);

732: OE_DEBUG_PUB.ADD('+================================+');
733: OE_DEBUG_PUB.ADD('|IN Big select statement --Header| ');
734: OE_DEBUG_PUB.ADD('+================================+');
735: OE_DEBUG_PUB.ADD('Discounting type is low--ASC');
736: OE_DEBUG_PUB.ADD('p_gsa : '||p_gsa);
737: OE_DEBUG_PUB.ADD('l_pricing_date : '||l_pricing_date);
738:
739:
740:

Line 737: OE_DEBUG_PUB.ADD('l_pricing_date : '||l_pricing_date);

733: OE_DEBUG_PUB.ADD('|IN Big select statement --Header| ');
734: OE_DEBUG_PUB.ADD('+================================+');
735: OE_DEBUG_PUB.ADD('Discounting type is low--ASC');
736: OE_DEBUG_PUB.ADD('p_gsa : '||p_gsa);
737: OE_DEBUG_PUB.ADD('l_pricing_date : '||l_pricing_date);
738:
739:
740:
741: OPEN l_discount_csr FOR

Line 802: OE_DEBUG_PUB.ADD('+================================+');

798: --DBMS_OUTPUT.PUT_LINE('+================================+');
799: --DBMS_OUTPUT.PUT_LINE('Discounting type is low--DESC');
800: --DBMS_OUTPUT.PUT_LINE('p_gsa : '||p_gsa);
801: --DBMS_OUTPUT.PUT_LINE('l_pricing_date : '||l_pricing_date);
802: OE_DEBUG_PUB.ADD('+================================+');
803: OE_DEBUG_PUB.ADD('|IN Big select statement --Header| ');
804: OE_DEBUG_PUB.ADD('+================================+');
805: OE_DEBUG_PUB.ADD('Discounting type is low--DESC');
806: OE_DEBUG_PUB.ADD('p_gsa : '||p_gsa);

Line 803: OE_DEBUG_PUB.ADD('|IN Big select statement --Header| ');

799: --DBMS_OUTPUT.PUT_LINE('Discounting type is low--DESC');
800: --DBMS_OUTPUT.PUT_LINE('p_gsa : '||p_gsa);
801: --DBMS_OUTPUT.PUT_LINE('l_pricing_date : '||l_pricing_date);
802: OE_DEBUG_PUB.ADD('+================================+');
803: OE_DEBUG_PUB.ADD('|IN Big select statement --Header| ');
804: OE_DEBUG_PUB.ADD('+================================+');
805: OE_DEBUG_PUB.ADD('Discounting type is low--DESC');
806: OE_DEBUG_PUB.ADD('p_gsa : '||p_gsa);
807: OE_DEBUG_PUB.ADD('l_pricing_date : '||l_pricing_date);

Line 804: OE_DEBUG_PUB.ADD('+================================+');

800: --DBMS_OUTPUT.PUT_LINE('p_gsa : '||p_gsa);
801: --DBMS_OUTPUT.PUT_LINE('l_pricing_date : '||l_pricing_date);
802: OE_DEBUG_PUB.ADD('+================================+');
803: OE_DEBUG_PUB.ADD('|IN Big select statement --Header| ');
804: OE_DEBUG_PUB.ADD('+================================+');
805: OE_DEBUG_PUB.ADD('Discounting type is low--DESC');
806: OE_DEBUG_PUB.ADD('p_gsa : '||p_gsa);
807: OE_DEBUG_PUB.ADD('l_pricing_date : '||l_pricing_date);
808:

Line 805: OE_DEBUG_PUB.ADD('Discounting type is low--DESC');

801: --DBMS_OUTPUT.PUT_LINE('l_pricing_date : '||l_pricing_date);
802: OE_DEBUG_PUB.ADD('+================================+');
803: OE_DEBUG_PUB.ADD('|IN Big select statement --Header| ');
804: OE_DEBUG_PUB.ADD('+================================+');
805: OE_DEBUG_PUB.ADD('Discounting type is low--DESC');
806: OE_DEBUG_PUB.ADD('p_gsa : '||p_gsa);
807: OE_DEBUG_PUB.ADD('l_pricing_date : '||l_pricing_date);
808:
809: OPEN l_discount_csr FOR

Line 806: OE_DEBUG_PUB.ADD('p_gsa : '||p_gsa);

802: OE_DEBUG_PUB.ADD('+================================+');
803: OE_DEBUG_PUB.ADD('|IN Big select statement --Header| ');
804: OE_DEBUG_PUB.ADD('+================================+');
805: OE_DEBUG_PUB.ADD('Discounting type is low--DESC');
806: OE_DEBUG_PUB.ADD('p_gsa : '||p_gsa);
807: OE_DEBUG_PUB.ADD('l_pricing_date : '||l_pricing_date);
808:
809: OPEN l_discount_csr FOR
810: SELECT QPH.LIST_HEADER_ID,QPL.LIST_LINE_ID, QPH.NAME,

Line 807: OE_DEBUG_PUB.ADD('l_pricing_date : '||l_pricing_date);

803: OE_DEBUG_PUB.ADD('|IN Big select statement --Header| ');
804: OE_DEBUG_PUB.ADD('+================================+');
805: OE_DEBUG_PUB.ADD('Discounting type is low--DESC');
806: OE_DEBUG_PUB.ADD('p_gsa : '||p_gsa);
807: OE_DEBUG_PUB.ADD('l_pricing_date : '||l_pricing_date);
808:
809: OPEN l_discount_csr FOR
810: SELECT QPH.LIST_HEADER_ID,QPL.LIST_LINE_ID, QPH.NAME,
811: DECODE(QPL.ARITHMETIC_OPERATOR,'AMT',NVL(QPL.OPERAND/p_list_price * 100,0),

Line 1194: oe_debug_pub.add('Exiting QP_PRC_UTIL.GET_ADJUSTMENT', 1);

1190:
1191:
1192: END IF;
1193:
1194: oe_debug_pub.add('Exiting QP_PRC_UTIL.GET_ADJUSTMENT', 1);
1195:
1196: EXCEPTION
1197:
1198: WHEN OTHERS THEN

Line 1230: oe_debug_pub.add('Entering QP_PRC_UTIL.GET_GSA', 1);

1226: l_error_msg VARCHAR2(240);
1227:
1228: BEGIN
1229:
1230: oe_debug_pub.add('Entering QP_PRC_UTIL.GET_GSA', 1);
1231:
1232: -- If the invoice to is NULL, then the order is automatically not GSA
1233:
1234: IF p_invoice_to_id IS NULL THEN

Line 1236: oe_debug_pub.add('Exiting QP_PRC_UTIL.GET_GSA', 1);

1232: -- If the invoice to is NULL, then the order is automatically not GSA
1233:
1234: IF p_invoice_to_id IS NULL THEN
1235:
1236: oe_debug_pub.add('Exiting QP_PRC_UTIL.GET_GSA', 1);
1237:
1238: RETURN 'N';
1239:
1240: ELSE

Line 1279: oe_debug_pub.add('Exiting QP_PRC_UTIL.GET_GSA', 1);

1275:
1276:
1277: -- Return the GSA Value
1278:
1279: oe_debug_pub.add('Exiting QP_PRC_UTIL.GET_GSA', 1);
1280:
1281: RETURN l_gsa;
1282:
1283: EXCEPTION

Line 1387: oe_debug_pub.add('Entering QP_PRC_UTIL.FETCH_BEST_ADJUSTMENT', 1);

1383: l_adj_rec Adj_Short_Rec_Type;
1384:
1385: BEGIN
1386:
1387: oe_debug_pub.add('Entering QP_PRC_UTIL.FETCH_BEST_ADJUSTMENT', 1);
1388:
1389: -- Price list and list price are required
1390:
1391: IF p_price_list_id IS NULL OR

Line 1413: OE_DEBUG_PUB.ADD('+==========================================+');

1409: l_adj_rec.pricing_date := p_pricing_date;
1410:
1411:
1412: -- Initial fetch (no pricing entities)
1413: OE_DEBUG_PUB.ADD('+==========================================+');
1414: OE_DEBUG_PUB.ADD('|Befor calling header big select statement|');
1415: OE_DEBUG_PUB.ADD('+==========================================+');
1416: OE_DEBUG_PUB.ADD('l_adj_percent '||l_adj_percent);
1417: OE_DEBUG_PUB.ADD('adjustment id '||l_adj_rec.adjustment_id);

Line 1414: OE_DEBUG_PUB.ADD('|Befor calling header big select statement|');

1410:
1411:
1412: -- Initial fetch (no pricing entities)
1413: OE_DEBUG_PUB.ADD('+==========================================+');
1414: OE_DEBUG_PUB.ADD('|Befor calling header big select statement|');
1415: OE_DEBUG_PUB.ADD('+==========================================+');
1416: OE_DEBUG_PUB.ADD('l_adj_percent '||l_adj_percent);
1417: OE_DEBUG_PUB.ADD('adjustment id '||l_adj_rec.adjustment_id);
1418: OE_DEBUG_PUB.ADD('discount id '||l_adj_rec.discount_id);

Line 1415: OE_DEBUG_PUB.ADD('+==========================================+');

1411:
1412: -- Initial fetch (no pricing entities)
1413: OE_DEBUG_PUB.ADD('+==========================================+');
1414: OE_DEBUG_PUB.ADD('|Befor calling header big select statement|');
1415: OE_DEBUG_PUB.ADD('+==========================================+');
1416: OE_DEBUG_PUB.ADD('l_adj_percent '||l_adj_percent);
1417: OE_DEBUG_PUB.ADD('adjustment id '||l_adj_rec.adjustment_id);
1418: OE_DEBUG_PUB.ADD('discount id '||l_adj_rec.discount_id);
1419: OE_DEBUG_PUB.ADD('discount line id '||l_adj_rec.discount_line_id);

Line 1416: OE_DEBUG_PUB.ADD('l_adj_percent '||l_adj_percent);

1412: -- Initial fetch (no pricing entities)
1413: OE_DEBUG_PUB.ADD('+==========================================+');
1414: OE_DEBUG_PUB.ADD('|Befor calling header big select statement|');
1415: OE_DEBUG_PUB.ADD('+==========================================+');
1416: OE_DEBUG_PUB.ADD('l_adj_percent '||l_adj_percent);
1417: OE_DEBUG_PUB.ADD('adjustment id '||l_adj_rec.adjustment_id);
1418: OE_DEBUG_PUB.ADD('discount id '||l_adj_rec.discount_id);
1419: OE_DEBUG_PUB.ADD('discount line id '||l_adj_rec.discount_line_id);
1420: OE_DEBUG_PUB.ADD('automatic discount flag '||l_adj_rec.automatic_flag);

Line 1417: OE_DEBUG_PUB.ADD('adjustment id '||l_adj_rec.adjustment_id);

1413: OE_DEBUG_PUB.ADD('+==========================================+');
1414: OE_DEBUG_PUB.ADD('|Befor calling header big select statement|');
1415: OE_DEBUG_PUB.ADD('+==========================================+');
1416: OE_DEBUG_PUB.ADD('l_adj_percent '||l_adj_percent);
1417: OE_DEBUG_PUB.ADD('adjustment id '||l_adj_rec.adjustment_id);
1418: OE_DEBUG_PUB.ADD('discount id '||l_adj_rec.discount_id);
1419: OE_DEBUG_PUB.ADD('discount line id '||l_adj_rec.discount_line_id);
1420: OE_DEBUG_PUB.ADD('automatic discount flag '||l_adj_rec.automatic_flag);
1421: OE_DEBUG_PUB.ADD('percent '|| l_adj_rec.percent);

Line 1418: OE_DEBUG_PUB.ADD('discount id '||l_adj_rec.discount_id);

1414: OE_DEBUG_PUB.ADD('|Befor calling header big select statement|');
1415: OE_DEBUG_PUB.ADD('+==========================================+');
1416: OE_DEBUG_PUB.ADD('l_adj_percent '||l_adj_percent);
1417: OE_DEBUG_PUB.ADD('adjustment id '||l_adj_rec.adjustment_id);
1418: OE_DEBUG_PUB.ADD('discount id '||l_adj_rec.discount_id);
1419: OE_DEBUG_PUB.ADD('discount line id '||l_adj_rec.discount_line_id);
1420: OE_DEBUG_PUB.ADD('automatic discount flag '||l_adj_rec.automatic_flag);
1421: OE_DEBUG_PUB.ADD('percent '|| l_adj_rec.percent);
1422: OE_DEBUG_PUB.ADD('line id '||l_adj_rec.line_id);

Line 1419: OE_DEBUG_PUB.ADD('discount line id '||l_adj_rec.discount_line_id);

1415: OE_DEBUG_PUB.ADD('+==========================================+');
1416: OE_DEBUG_PUB.ADD('l_adj_percent '||l_adj_percent);
1417: OE_DEBUG_PUB.ADD('adjustment id '||l_adj_rec.adjustment_id);
1418: OE_DEBUG_PUB.ADD('discount id '||l_adj_rec.discount_id);
1419: OE_DEBUG_PUB.ADD('discount line id '||l_adj_rec.discount_line_id);
1420: OE_DEBUG_PUB.ADD('automatic discount flag '||l_adj_rec.automatic_flag);
1421: OE_DEBUG_PUB.ADD('percent '|| l_adj_rec.percent);
1422: OE_DEBUG_PUB.ADD('line id '||l_adj_rec.line_id);
1423: OE_DEBUG_PUB.ADD('header id' || l_adj_rec.header_id);

Line 1420: OE_DEBUG_PUB.ADD('automatic discount flag '||l_adj_rec.automatic_flag);

1416: OE_DEBUG_PUB.ADD('l_adj_percent '||l_adj_percent);
1417: OE_DEBUG_PUB.ADD('adjustment id '||l_adj_rec.adjustment_id);
1418: OE_DEBUG_PUB.ADD('discount id '||l_adj_rec.discount_id);
1419: OE_DEBUG_PUB.ADD('discount line id '||l_adj_rec.discount_line_id);
1420: OE_DEBUG_PUB.ADD('automatic discount flag '||l_adj_rec.automatic_flag);
1421: OE_DEBUG_PUB.ADD('percent '|| l_adj_rec.percent);
1422: OE_DEBUG_PUB.ADD('line id '||l_adj_rec.line_id);
1423: OE_DEBUG_PUB.ADD('header id' || l_adj_rec.header_id);
1424: OE_DEBUG_PUB.ADD('discount_name '||l_adj_rec.discount_name);

Line 1421: OE_DEBUG_PUB.ADD('percent '|| l_adj_rec.percent);

1417: OE_DEBUG_PUB.ADD('adjustment id '||l_adj_rec.adjustment_id);
1418: OE_DEBUG_PUB.ADD('discount id '||l_adj_rec.discount_id);
1419: OE_DEBUG_PUB.ADD('discount line id '||l_adj_rec.discount_line_id);
1420: OE_DEBUG_PUB.ADD('automatic discount flag '||l_adj_rec.automatic_flag);
1421: OE_DEBUG_PUB.ADD('percent '|| l_adj_rec.percent);
1422: OE_DEBUG_PUB.ADD('line id '||l_adj_rec.line_id);
1423: OE_DEBUG_PUB.ADD('header id' || l_adj_rec.header_id);
1424: OE_DEBUG_PUB.ADD('discount_name '||l_adj_rec.discount_name);
1425: OE_DEBUG_PUB.ADD('pricing_date '||l_adj_rec.pricing_date);

Line 1422: OE_DEBUG_PUB.ADD('line id '||l_adj_rec.line_id);

1418: OE_DEBUG_PUB.ADD('discount id '||l_adj_rec.discount_id);
1419: OE_DEBUG_PUB.ADD('discount line id '||l_adj_rec.discount_line_id);
1420: OE_DEBUG_PUB.ADD('automatic discount flag '||l_adj_rec.automatic_flag);
1421: OE_DEBUG_PUB.ADD('percent '|| l_adj_rec.percent);
1422: OE_DEBUG_PUB.ADD('line id '||l_adj_rec.line_id);
1423: OE_DEBUG_PUB.ADD('header id' || l_adj_rec.header_id);
1424: OE_DEBUG_PUB.ADD('discount_name '||l_adj_rec.discount_name);
1425: OE_DEBUG_PUB.ADD('pricing_date '||l_adj_rec.pricing_date);
1426: OE_DEBUG_PUB.ADD('operation '||l_adj_rec.operation);

Line 1423: OE_DEBUG_PUB.ADD('header id' || l_adj_rec.header_id);

1419: OE_DEBUG_PUB.ADD('discount line id '||l_adj_rec.discount_line_id);
1420: OE_DEBUG_PUB.ADD('automatic discount flag '||l_adj_rec.automatic_flag);
1421: OE_DEBUG_PUB.ADD('percent '|| l_adj_rec.percent);
1422: OE_DEBUG_PUB.ADD('line id '||l_adj_rec.line_id);
1423: OE_DEBUG_PUB.ADD('header id' || l_adj_rec.header_id);
1424: OE_DEBUG_PUB.ADD('discount_name '||l_adj_rec.discount_name);
1425: OE_DEBUG_PUB.ADD('pricing_date '||l_adj_rec.pricing_date);
1426: OE_DEBUG_PUB.ADD('operation '||l_adj_rec.operation);
1427: OE_DEBUG_PUB.ADD('line_tbl_index '||l_adj_rec.line_tbl_index);

Line 1424: OE_DEBUG_PUB.ADD('discount_name '||l_adj_rec.discount_name);

1420: OE_DEBUG_PUB.ADD('automatic discount flag '||l_adj_rec.automatic_flag);
1421: OE_DEBUG_PUB.ADD('percent '|| l_adj_rec.percent);
1422: OE_DEBUG_PUB.ADD('line id '||l_adj_rec.line_id);
1423: OE_DEBUG_PUB.ADD('header id' || l_adj_rec.header_id);
1424: OE_DEBUG_PUB.ADD('discount_name '||l_adj_rec.discount_name);
1425: OE_DEBUG_PUB.ADD('pricing_date '||l_adj_rec.pricing_date);
1426: OE_DEBUG_PUB.ADD('operation '||l_adj_rec.operation);
1427: OE_DEBUG_PUB.ADD('line_tbl_index '||l_adj_rec.line_tbl_index);
1428: OE_DEBUG_PUB.ADD('p_price_list_id '||p_price_list_id);

Line 1425: OE_DEBUG_PUB.ADD('pricing_date '||l_adj_rec.pricing_date);

1421: OE_DEBUG_PUB.ADD('percent '|| l_adj_rec.percent);
1422: OE_DEBUG_PUB.ADD('line id '||l_adj_rec.line_id);
1423: OE_DEBUG_PUB.ADD('header id' || l_adj_rec.header_id);
1424: OE_DEBUG_PUB.ADD('discount_name '||l_adj_rec.discount_name);
1425: OE_DEBUG_PUB.ADD('pricing_date '||l_adj_rec.pricing_date);
1426: OE_DEBUG_PUB.ADD('operation '||l_adj_rec.operation);
1427: OE_DEBUG_PUB.ADD('line_tbl_index '||l_adj_rec.line_tbl_index);
1428: OE_DEBUG_PUB.ADD('p_price_list_id '||p_price_list_id);
1429: OE_DEBUG_PUB.ADD('p_quantity '||p_quantity);

Line 1426: OE_DEBUG_PUB.ADD('operation '||l_adj_rec.operation);

1422: OE_DEBUG_PUB.ADD('line id '||l_adj_rec.line_id);
1423: OE_DEBUG_PUB.ADD('header id' || l_adj_rec.header_id);
1424: OE_DEBUG_PUB.ADD('discount_name '||l_adj_rec.discount_name);
1425: OE_DEBUG_PUB.ADD('pricing_date '||l_adj_rec.pricing_date);
1426: OE_DEBUG_PUB.ADD('operation '||l_adj_rec.operation);
1427: OE_DEBUG_PUB.ADD('line_tbl_index '||l_adj_rec.line_tbl_index);
1428: OE_DEBUG_PUB.ADD('p_price_list_id '||p_price_list_id);
1429: OE_DEBUG_PUB.ADD('p_quantity '||p_quantity);
1430: OE_DEBUG_PUB.ADD('p_list_price '||p_list_price);

Line 1427: OE_DEBUG_PUB.ADD('line_tbl_index '||l_adj_rec.line_tbl_index);

1423: OE_DEBUG_PUB.ADD('header id' || l_adj_rec.header_id);
1424: OE_DEBUG_PUB.ADD('discount_name '||l_adj_rec.discount_name);
1425: OE_DEBUG_PUB.ADD('pricing_date '||l_adj_rec.pricing_date);
1426: OE_DEBUG_PUB.ADD('operation '||l_adj_rec.operation);
1427: OE_DEBUG_PUB.ADD('line_tbl_index '||l_adj_rec.line_tbl_index);
1428: OE_DEBUG_PUB.ADD('p_price_list_id '||p_price_list_id);
1429: OE_DEBUG_PUB.ADD('p_quantity '||p_quantity);
1430: OE_DEBUG_PUB.ADD('p_list_price '||p_list_price);
1431: OE_DEBUG_PUB.ADD('p_sold_to_org_id '||p_sold_to_org_id);

Line 1428: OE_DEBUG_PUB.ADD('p_price_list_id '||p_price_list_id);

1424: OE_DEBUG_PUB.ADD('discount_name '||l_adj_rec.discount_name);
1425: OE_DEBUG_PUB.ADD('pricing_date '||l_adj_rec.pricing_date);
1426: OE_DEBUG_PUB.ADD('operation '||l_adj_rec.operation);
1427: OE_DEBUG_PUB.ADD('line_tbl_index '||l_adj_rec.line_tbl_index);
1428: OE_DEBUG_PUB.ADD('p_price_list_id '||p_price_list_id);
1429: OE_DEBUG_PUB.ADD('p_quantity '||p_quantity);
1430: OE_DEBUG_PUB.ADD('p_list_price '||p_list_price);
1431: OE_DEBUG_PUB.ADD('p_sold_to_org_id '||p_sold_to_org_id);
1432: OE_DEBUG_PUB.ADD('p_customer_class_code '||p_customer_class_code);

Line 1429: OE_DEBUG_PUB.ADD('p_quantity '||p_quantity);

1425: OE_DEBUG_PUB.ADD('pricing_date '||l_adj_rec.pricing_date);
1426: OE_DEBUG_PUB.ADD('operation '||l_adj_rec.operation);
1427: OE_DEBUG_PUB.ADD('line_tbl_index '||l_adj_rec.line_tbl_index);
1428: OE_DEBUG_PUB.ADD('p_price_list_id '||p_price_list_id);
1429: OE_DEBUG_PUB.ADD('p_quantity '||p_quantity);
1430: OE_DEBUG_PUB.ADD('p_list_price '||p_list_price);
1431: OE_DEBUG_PUB.ADD('p_sold_to_org_id '||p_sold_to_org_id);
1432: OE_DEBUG_PUB.ADD('p_customer_class_code '||p_customer_class_code);
1433: OE_DEBUG_PUB.ADD('p_ship_to_id '||p_ship_to_id );

Line 1430: OE_DEBUG_PUB.ADD('p_list_price '||p_list_price);

1426: OE_DEBUG_PUB.ADD('operation '||l_adj_rec.operation);
1427: OE_DEBUG_PUB.ADD('line_tbl_index '||l_adj_rec.line_tbl_index);
1428: OE_DEBUG_PUB.ADD('p_price_list_id '||p_price_list_id);
1429: OE_DEBUG_PUB.ADD('p_quantity '||p_quantity);
1430: OE_DEBUG_PUB.ADD('p_list_price '||p_list_price);
1431: OE_DEBUG_PUB.ADD('p_sold_to_org_id '||p_sold_to_org_id);
1432: OE_DEBUG_PUB.ADD('p_customer_class_code '||p_customer_class_code);
1433: OE_DEBUG_PUB.ADD('p_ship_to_id '||p_ship_to_id );
1434: OE_DEBUG_PUB.ADD('p_invoice_to_id '||p_invoice_to_id);

Line 1431: OE_DEBUG_PUB.ADD('p_sold_to_org_id '||p_sold_to_org_id);

1427: OE_DEBUG_PUB.ADD('line_tbl_index '||l_adj_rec.line_tbl_index);
1428: OE_DEBUG_PUB.ADD('p_price_list_id '||p_price_list_id);
1429: OE_DEBUG_PUB.ADD('p_quantity '||p_quantity);
1430: OE_DEBUG_PUB.ADD('p_list_price '||p_list_price);
1431: OE_DEBUG_PUB.ADD('p_sold_to_org_id '||p_sold_to_org_id);
1432: OE_DEBUG_PUB.ADD('p_customer_class_code '||p_customer_class_code);
1433: OE_DEBUG_PUB.ADD('p_ship_to_id '||p_ship_to_id );
1434: OE_DEBUG_PUB.ADD('p_invoice_to_id '||p_invoice_to_id);
1435: OE_DEBUG_PUB.ADD('p_unit_code '||p_unit_code );

Line 1432: OE_DEBUG_PUB.ADD('p_customer_class_code '||p_customer_class_code);

1428: OE_DEBUG_PUB.ADD('p_price_list_id '||p_price_list_id);
1429: OE_DEBUG_PUB.ADD('p_quantity '||p_quantity);
1430: OE_DEBUG_PUB.ADD('p_list_price '||p_list_price);
1431: OE_DEBUG_PUB.ADD('p_sold_to_org_id '||p_sold_to_org_id);
1432: OE_DEBUG_PUB.ADD('p_customer_class_code '||p_customer_class_code);
1433: OE_DEBUG_PUB.ADD('p_ship_to_id '||p_ship_to_id );
1434: OE_DEBUG_PUB.ADD('p_invoice_to_id '||p_invoice_to_id);
1435: OE_DEBUG_PUB.ADD('p_unit_code '||p_unit_code );
1436:

Line 1433: OE_DEBUG_PUB.ADD('p_ship_to_id '||p_ship_to_id );

1429: OE_DEBUG_PUB.ADD('p_quantity '||p_quantity);
1430: OE_DEBUG_PUB.ADD('p_list_price '||p_list_price);
1431: OE_DEBUG_PUB.ADD('p_sold_to_org_id '||p_sold_to_org_id);
1432: OE_DEBUG_PUB.ADD('p_customer_class_code '||p_customer_class_code);
1433: OE_DEBUG_PUB.ADD('p_ship_to_id '||p_ship_to_id );
1434: OE_DEBUG_PUB.ADD('p_invoice_to_id '||p_invoice_to_id);
1435: OE_DEBUG_PUB.ADD('p_unit_code '||p_unit_code );
1436:
1437:

Line 1434: OE_DEBUG_PUB.ADD('p_invoice_to_id '||p_invoice_to_id);

1430: OE_DEBUG_PUB.ADD('p_list_price '||p_list_price);
1431: OE_DEBUG_PUB.ADD('p_sold_to_org_id '||p_sold_to_org_id);
1432: OE_DEBUG_PUB.ADD('p_customer_class_code '||p_customer_class_code);
1433: OE_DEBUG_PUB.ADD('p_ship_to_id '||p_ship_to_id );
1434: OE_DEBUG_PUB.ADD('p_invoice_to_id '||p_invoice_to_id);
1435: OE_DEBUG_PUB.ADD('p_unit_code '||p_unit_code );
1436:
1437:
1438: --DBMS_OUTPUT.PUT_LINE('+==========================================+');

Line 1435: OE_DEBUG_PUB.ADD('p_unit_code '||p_unit_code );

1431: OE_DEBUG_PUB.ADD('p_sold_to_org_id '||p_sold_to_org_id);
1432: OE_DEBUG_PUB.ADD('p_customer_class_code '||p_customer_class_code);
1433: OE_DEBUG_PUB.ADD('p_ship_to_id '||p_ship_to_id );
1434: OE_DEBUG_PUB.ADD('p_invoice_to_id '||p_invoice_to_id);
1435: OE_DEBUG_PUB.ADD('p_unit_code '||p_unit_code );
1436:
1437:
1438: --DBMS_OUTPUT.PUT_LINE('+==========================================+');
1439: --DBMS_OUTPUT.PUT_LINE('|Before calling header big select statement|');

Line 1482: OE_DEBUG_PUB.ADD('+==========================================+');

1478: );
1479:
1480: --DBMS_output.put_line('In fetch best adjustment without attributes : '|| p_adj_rec.percent);
1481:
1482: OE_DEBUG_PUB.ADD('+==========================================+');
1483: OE_DEBUG_PUB.ADD('|After calling header big select statement|');
1484: OE_DEBUG_PUB.ADD('+==========================================+');
1485: OE_DEBUG_PUB.ADD('l_adj_percent '||l_adj_percent);
1486: OE_DEBUG_PUB.ADD('adjustment id '||l_adj_rec.adjustment_id);

Line 1483: OE_DEBUG_PUB.ADD('|After calling header big select statement|');

1479:
1480: --DBMS_output.put_line('In fetch best adjustment without attributes : '|| p_adj_rec.percent);
1481:
1482: OE_DEBUG_PUB.ADD('+==========================================+');
1483: OE_DEBUG_PUB.ADD('|After calling header big select statement|');
1484: OE_DEBUG_PUB.ADD('+==========================================+');
1485: OE_DEBUG_PUB.ADD('l_adj_percent '||l_adj_percent);
1486: OE_DEBUG_PUB.ADD('adjustment id '||l_adj_rec.adjustment_id);
1487: OE_DEBUG_PUB.ADD('discount id '||l_adj_rec.discount_id);

Line 1484: OE_DEBUG_PUB.ADD('+==========================================+');

1480: --DBMS_output.put_line('In fetch best adjustment without attributes : '|| p_adj_rec.percent);
1481:
1482: OE_DEBUG_PUB.ADD('+==========================================+');
1483: OE_DEBUG_PUB.ADD('|After calling header big select statement|');
1484: OE_DEBUG_PUB.ADD('+==========================================+');
1485: OE_DEBUG_PUB.ADD('l_adj_percent '||l_adj_percent);
1486: OE_DEBUG_PUB.ADD('adjustment id '||l_adj_rec.adjustment_id);
1487: OE_DEBUG_PUB.ADD('discount id '||l_adj_rec.discount_id);
1488: OE_DEBUG_PUB.ADD('discount line id '||l_adj_rec.discount_line_id);

Line 1485: OE_DEBUG_PUB.ADD('l_adj_percent '||l_adj_percent);

1481:
1482: OE_DEBUG_PUB.ADD('+==========================================+');
1483: OE_DEBUG_PUB.ADD('|After calling header big select statement|');
1484: OE_DEBUG_PUB.ADD('+==========================================+');
1485: OE_DEBUG_PUB.ADD('l_adj_percent '||l_adj_percent);
1486: OE_DEBUG_PUB.ADD('adjustment id '||l_adj_rec.adjustment_id);
1487: OE_DEBUG_PUB.ADD('discount id '||l_adj_rec.discount_id);
1488: OE_DEBUG_PUB.ADD('discount line id '||l_adj_rec.discount_line_id);
1489: OE_DEBUG_PUB.ADD('automatic discount flag '||l_adj_rec.automatic_flag);

Line 1486: OE_DEBUG_PUB.ADD('adjustment id '||l_adj_rec.adjustment_id);

1482: OE_DEBUG_PUB.ADD('+==========================================+');
1483: OE_DEBUG_PUB.ADD('|After calling header big select statement|');
1484: OE_DEBUG_PUB.ADD('+==========================================+');
1485: OE_DEBUG_PUB.ADD('l_adj_percent '||l_adj_percent);
1486: OE_DEBUG_PUB.ADD('adjustment id '||l_adj_rec.adjustment_id);
1487: OE_DEBUG_PUB.ADD('discount id '||l_adj_rec.discount_id);
1488: OE_DEBUG_PUB.ADD('discount line id '||l_adj_rec.discount_line_id);
1489: OE_DEBUG_PUB.ADD('automatic discount flag '||l_adj_rec.automatic_flag);
1490: OE_DEBUG_PUB.ADD('percent '|| l_adj_rec.percent);

Line 1487: OE_DEBUG_PUB.ADD('discount id '||l_adj_rec.discount_id);

1483: OE_DEBUG_PUB.ADD('|After calling header big select statement|');
1484: OE_DEBUG_PUB.ADD('+==========================================+');
1485: OE_DEBUG_PUB.ADD('l_adj_percent '||l_adj_percent);
1486: OE_DEBUG_PUB.ADD('adjustment id '||l_adj_rec.adjustment_id);
1487: OE_DEBUG_PUB.ADD('discount id '||l_adj_rec.discount_id);
1488: OE_DEBUG_PUB.ADD('discount line id '||l_adj_rec.discount_line_id);
1489: OE_DEBUG_PUB.ADD('automatic discount flag '||l_adj_rec.automatic_flag);
1490: OE_DEBUG_PUB.ADD('percent '|| l_adj_rec.percent);
1491: OE_DEBUG_PUB.ADD('line id '||l_adj_rec.line_id);

Line 1488: OE_DEBUG_PUB.ADD('discount line id '||l_adj_rec.discount_line_id);

1484: OE_DEBUG_PUB.ADD('+==========================================+');
1485: OE_DEBUG_PUB.ADD('l_adj_percent '||l_adj_percent);
1486: OE_DEBUG_PUB.ADD('adjustment id '||l_adj_rec.adjustment_id);
1487: OE_DEBUG_PUB.ADD('discount id '||l_adj_rec.discount_id);
1488: OE_DEBUG_PUB.ADD('discount line id '||l_adj_rec.discount_line_id);
1489: OE_DEBUG_PUB.ADD('automatic discount flag '||l_adj_rec.automatic_flag);
1490: OE_DEBUG_PUB.ADD('percent '|| l_adj_rec.percent);
1491: OE_DEBUG_PUB.ADD('line id '||l_adj_rec.line_id);
1492: OE_DEBUG_PUB.ADD('header id' || l_adj_rec.header_id);

Line 1489: OE_DEBUG_PUB.ADD('automatic discount flag '||l_adj_rec.automatic_flag);

1485: OE_DEBUG_PUB.ADD('l_adj_percent '||l_adj_percent);
1486: OE_DEBUG_PUB.ADD('adjustment id '||l_adj_rec.adjustment_id);
1487: OE_DEBUG_PUB.ADD('discount id '||l_adj_rec.discount_id);
1488: OE_DEBUG_PUB.ADD('discount line id '||l_adj_rec.discount_line_id);
1489: OE_DEBUG_PUB.ADD('automatic discount flag '||l_adj_rec.automatic_flag);
1490: OE_DEBUG_PUB.ADD('percent '|| l_adj_rec.percent);
1491: OE_DEBUG_PUB.ADD('line id '||l_adj_rec.line_id);
1492: OE_DEBUG_PUB.ADD('header id' || l_adj_rec.header_id);
1493: OE_DEBUG_PUB.ADD('discount_name '||l_adj_rec.discount_name);

Line 1490: OE_DEBUG_PUB.ADD('percent '|| l_adj_rec.percent);

1486: OE_DEBUG_PUB.ADD('adjustment id '||l_adj_rec.adjustment_id);
1487: OE_DEBUG_PUB.ADD('discount id '||l_adj_rec.discount_id);
1488: OE_DEBUG_PUB.ADD('discount line id '||l_adj_rec.discount_line_id);
1489: OE_DEBUG_PUB.ADD('automatic discount flag '||l_adj_rec.automatic_flag);
1490: OE_DEBUG_PUB.ADD('percent '|| l_adj_rec.percent);
1491: OE_DEBUG_PUB.ADD('line id '||l_adj_rec.line_id);
1492: OE_DEBUG_PUB.ADD('header id' || l_adj_rec.header_id);
1493: OE_DEBUG_PUB.ADD('discount_name '||l_adj_rec.discount_name);
1494: OE_DEBUG_PUB.ADD('pricing_date '||l_adj_rec.pricing_date);

Line 1491: OE_DEBUG_PUB.ADD('line id '||l_adj_rec.line_id);

1487: OE_DEBUG_PUB.ADD('discount id '||l_adj_rec.discount_id);
1488: OE_DEBUG_PUB.ADD('discount line id '||l_adj_rec.discount_line_id);
1489: OE_DEBUG_PUB.ADD('automatic discount flag '||l_adj_rec.automatic_flag);
1490: OE_DEBUG_PUB.ADD('percent '|| l_adj_rec.percent);
1491: OE_DEBUG_PUB.ADD('line id '||l_adj_rec.line_id);
1492: OE_DEBUG_PUB.ADD('header id' || l_adj_rec.header_id);
1493: OE_DEBUG_PUB.ADD('discount_name '||l_adj_rec.discount_name);
1494: OE_DEBUG_PUB.ADD('pricing_date '||l_adj_rec.pricing_date);
1495: OE_DEBUG_PUB.ADD('operation '||l_adj_rec.operation);

Line 1492: OE_DEBUG_PUB.ADD('header id' || l_adj_rec.header_id);

1488: OE_DEBUG_PUB.ADD('discount line id '||l_adj_rec.discount_line_id);
1489: OE_DEBUG_PUB.ADD('automatic discount flag '||l_adj_rec.automatic_flag);
1490: OE_DEBUG_PUB.ADD('percent '|| l_adj_rec.percent);
1491: OE_DEBUG_PUB.ADD('line id '||l_adj_rec.line_id);
1492: OE_DEBUG_PUB.ADD('header id' || l_adj_rec.header_id);
1493: OE_DEBUG_PUB.ADD('discount_name '||l_adj_rec.discount_name);
1494: OE_DEBUG_PUB.ADD('pricing_date '||l_adj_rec.pricing_date);
1495: OE_DEBUG_PUB.ADD('operation '||l_adj_rec.operation);
1496: OE_DEBUG_PUB.ADD('line_tbl_index '||l_adj_rec.line_tbl_index);

Line 1493: OE_DEBUG_PUB.ADD('discount_name '||l_adj_rec.discount_name);

1489: OE_DEBUG_PUB.ADD('automatic discount flag '||l_adj_rec.automatic_flag);
1490: OE_DEBUG_PUB.ADD('percent '|| l_adj_rec.percent);
1491: OE_DEBUG_PUB.ADD('line id '||l_adj_rec.line_id);
1492: OE_DEBUG_PUB.ADD('header id' || l_adj_rec.header_id);
1493: OE_DEBUG_PUB.ADD('discount_name '||l_adj_rec.discount_name);
1494: OE_DEBUG_PUB.ADD('pricing_date '||l_adj_rec.pricing_date);
1495: OE_DEBUG_PUB.ADD('operation '||l_adj_rec.operation);
1496: OE_DEBUG_PUB.ADD('line_tbl_index '||l_adj_rec.line_tbl_index);
1497:

Line 1494: OE_DEBUG_PUB.ADD('pricing_date '||l_adj_rec.pricing_date);

1490: OE_DEBUG_PUB.ADD('percent '|| l_adj_rec.percent);
1491: OE_DEBUG_PUB.ADD('line id '||l_adj_rec.line_id);
1492: OE_DEBUG_PUB.ADD('header id' || l_adj_rec.header_id);
1493: OE_DEBUG_PUB.ADD('discount_name '||l_adj_rec.discount_name);
1494: OE_DEBUG_PUB.ADD('pricing_date '||l_adj_rec.pricing_date);
1495: OE_DEBUG_PUB.ADD('operation '||l_adj_rec.operation);
1496: OE_DEBUG_PUB.ADD('line_tbl_index '||l_adj_rec.line_tbl_index);
1497:
1498: --DBMS_OUTPUT.PUT_LINE('+==========================================+');

Line 1495: OE_DEBUG_PUB.ADD('operation '||l_adj_rec.operation);

1491: OE_DEBUG_PUB.ADD('line id '||l_adj_rec.line_id);
1492: OE_DEBUG_PUB.ADD('header id' || l_adj_rec.header_id);
1493: OE_DEBUG_PUB.ADD('discount_name '||l_adj_rec.discount_name);
1494: OE_DEBUG_PUB.ADD('pricing_date '||l_adj_rec.pricing_date);
1495: OE_DEBUG_PUB.ADD('operation '||l_adj_rec.operation);
1496: OE_DEBUG_PUB.ADD('line_tbl_index '||l_adj_rec.line_tbl_index);
1497:
1498: --DBMS_OUTPUT.PUT_LINE('+==========================================+');
1499: --DBMS_OUTPUT.PUT_LINE('|After calling header big select statement|');

Line 1496: OE_DEBUG_PUB.ADD('line_tbl_index '||l_adj_rec.line_tbl_index);

1492: OE_DEBUG_PUB.ADD('header id' || l_adj_rec.header_id);
1493: OE_DEBUG_PUB.ADD('discount_name '||l_adj_rec.discount_name);
1494: OE_DEBUG_PUB.ADD('pricing_date '||l_adj_rec.pricing_date);
1495: OE_DEBUG_PUB.ADD('operation '||l_adj_rec.operation);
1496: OE_DEBUG_PUB.ADD('line_tbl_index '||l_adj_rec.line_tbl_index);
1497:
1498: --DBMS_OUTPUT.PUT_LINE('+==========================================+');
1499: --DBMS_OUTPUT.PUT_LINE('|After calling header big select statement|');
1500: --DBMS_OUTPUT.PUT_LINE('+==========================================+');

Line 1538: OE_DEBUG_PUB.ADD('In fetch best adjustment in ITEM percent After: '|| p_adj_rec.percent);

1534: p_adj_rec => l_adj_rec ,
1535: p_adj_percent => l_adj_percent
1536: );
1537: --DBMS_output.put_line('In fetch best adjustment in ITEM percent After: '|| p_adj_rec.percent);
1538: OE_DEBUG_PUB.ADD('In fetch best adjustment in ITEM percent After: '|| p_adj_rec.percent);
1539: END IF;
1540:
1541: END IF;
1542:

Line 1548: OE_DEBUG_PUB.ADD('In fetch best adj --p_attribute_value: '||p_item_category_id);

1544:
1545: IF Attribute_Used(G_ATTR_ITEM_CATEGORY) THEN
1546: --DBMS_output.put_line('In fetch best adjustment G_ATTR_ITEM_CAT: '||G_ATTR_ITEM_CATEGORY );
1547: --DBMS_output.put_line('In fetch best adj --p_attribute_value: '||p_item_category_id);
1548: OE_DEBUG_PUB.ADD('In fetch best adj --p_attribute_value: '||p_item_category_id);
1549: Get_Adjustment
1550: ( p_best_adj_rec => l_adj_rec ,
1551: p_best_adj_percent=> l_adj_percent ,
1552: p_attribute_id => G_ATTR_ITEM_CATEGORY ,

Line 1576: OE_DEBUG_PUB.ADD('In fetch best adjustment PRC_ATTRIBUTE1: '|| p_adj_rec.percent);

1572: IF p_pricing_attribute1 IS NOT NULL THEN
1573:
1574: IF Attribute_Used(G_ATTR_PRC_ATTRIBUTE1) THEN
1575: --DBMS_output.put_line('In fetch best adjustment PRC_ATTRIBUTE1: '|| p_adj_rec.percent);
1576: OE_DEBUG_PUB.ADD('In fetch best adjustment PRC_ATTRIBUTE1: '|| p_adj_rec.percent);
1577: Get_Adjustment
1578: ( p_best_adj_rec => l_adj_rec ,
1579: p_best_adj_percent=> l_adj_percent ,
1580: p_attribute_id => G_ATTR_PRC_ATTRIBUTE1 ,

Line 1604: OE_DEBUG_PUB.ADD('In fetch best adjustment PRC_ATTRIBUTE2: '|| p_adj_rec.percent);

1600: IF p_pricing_attribute2 IS NOT NULL THEN
1601:
1602: IF Attribute_Used(G_ATTR_PRC_ATTRIBUTE2) THEN
1603: --DBMS_output.put_line('In fetch best adjustment in PRC_ATTRIB2: '|| p_adj_rec.percent);
1604: OE_DEBUG_PUB.ADD('In fetch best adjustment PRC_ATTRIBUTE2: '|| p_adj_rec.percent);
1605: Get_Adjustment
1606: ( p_best_adj_rec => l_adj_rec ,
1607: p_best_adj_percent=> l_adj_percent ,
1608: p_attribute_id => G_ATTR_PRC_ATTRIBUTE2 ,

Line 1632: OE_DEBUG_PUB.ADD('In fetch best adjustment PRC_ATTRIBUTE3: '|| p_adj_rec.percent);

1628: IF p_pricing_attribute3 IS NOT NULL THEN
1629:
1630: IF Attribute_Used(G_ATTR_PRC_ATTRIBUTE3) THEN
1631: --DBMS_output.put_line('In fetch best adjustment PRC_ATTR3: '|| p_adj_rec.percent);
1632: OE_DEBUG_PUB.ADD('In fetch best adjustment PRC_ATTRIBUTE3: '|| p_adj_rec.percent);
1633: Get_Adjustment
1634: ( p_best_adj_rec => l_adj_rec ,
1635: p_best_adj_percent=> l_adj_percent ,
1636: p_attribute_id => G_ATTR_PRC_ATTRIBUTE3 ,

Line 1660: OE_DEBUG_PUB.ADD('In fetch best adjustment PRC_ATTRIBUTE4: '|| p_adj_rec.percent);

1656: IF p_pricing_attribute4 IS NOT NULL THEN
1657:
1658: IF Attribute_Used(G_ATTR_PRC_ATTRIBUTE4) THEN
1659: --DBMS_output.put_line('In fetch best adjustment PRC_ATTR4: '|| p_adj_rec.percent);
1660: OE_DEBUG_PUB.ADD('In fetch best adjustment PRC_ATTRIBUTE4: '|| p_adj_rec.percent);
1661: Get_Adjustment
1662: ( p_best_adj_rec => l_adj_rec ,
1663: p_best_adj_percent=> l_adj_percent ,
1664: p_attribute_id => G_ATTR_PRC_ATTRIBUTE4 ,

Line 1688: OE_DEBUG_PUB.ADD('In fetch best adjustment PRC_ATTRIBUTE5: '|| p_adj_rec.percent);

1684: IF p_pricing_attribute5 IS NOT NULL THEN
1685:
1686: IF Attribute_Used(G_ATTR_PRC_ATTRIBUTE5) THEN
1687: --DBMS_output.put_line('In fetch best adjustment PRC_ATTR5: '|| p_adj_rec.percent);
1688: OE_DEBUG_PUB.ADD('In fetch best adjustment PRC_ATTRIBUTE5: '|| p_adj_rec.percent);
1689: Get_Adjustment
1690: ( p_best_adj_rec => l_adj_rec ,
1691: p_best_adj_percent=> l_adj_percent ,
1692: p_attribute_id => G_ATTR_PRC_ATTRIBUTE5 ,

Line 1716: OE_DEBUG_PUB.ADD('In fetch best adjustment PRC_ATTRIBUTE6: '|| p_adj_rec.percent);

1712: IF p_pricing_attribute6 IS NOT NULL THEN
1713:
1714: IF Attribute_Used(G_ATTR_PRC_ATTRIBUTE6) THEN
1715: --DBMS_output.put_line('In fetch best adjustment PRC_ATTR6: '|| p_adj_rec.percent);
1716: OE_DEBUG_PUB.ADD('In fetch best adjustment PRC_ATTRIBUTE6: '|| p_adj_rec.percent);
1717: Get_Adjustment
1718: ( p_best_adj_rec => l_adj_rec ,
1719: p_best_adj_percent=> l_adj_percent ,
1720: p_attribute_id => G_ATTR_PRC_ATTRIBUTE6 ,

Line 1744: OE_DEBUG_PUB.ADD('In fetch best adjustment PRC_ATTRIBUTE7: '|| p_adj_rec.percent);

1740: IF p_pricing_attribute7 IS NOT NULL THEN
1741:
1742: IF Attribute_Used(G_ATTR_PRC_ATTRIBUTE7) THEN
1743: --DBMS_output.put_line('In fetch best adjustment PRC_ATTR7: '|| p_adj_rec.percent);
1744: OE_DEBUG_PUB.ADD('In fetch best adjustment PRC_ATTRIBUTE7: '|| p_adj_rec.percent);
1745: Get_Adjustment
1746: ( p_best_adj_rec => l_adj_rec ,
1747: p_best_adj_percent=> l_adj_percent ,
1748: p_attribute_id => G_ATTR_PRC_ATTRIBUTE7 ,

Line 1772: OE_DEBUG_PUB.ADD('In fetch best adjustment PRC_ATTRIBUTE8: '|| p_adj_rec.percent);

1768: IF p_pricing_attribute8 IS NOT NULL THEN
1769:
1770: IF Attribute_Used(G_ATTR_PRC_ATTRIBUTE8) THEN
1771: --DBMS_output.put_line('In fetch best adjustment PRC_ATTR8: '|| p_adj_rec.percent);
1772: OE_DEBUG_PUB.ADD('In fetch best adjustment PRC_ATTRIBUTE8: '|| p_adj_rec.percent);
1773: Get_Adjustment
1774: ( p_best_adj_rec => l_adj_rec ,
1775: p_best_adj_percent=> l_adj_percent ,
1776: p_attribute_id => G_ATTR_PRC_ATTRIBUTE8 ,

Line 1800: OE_DEBUG_PUB.ADD('In fetch best adjustment PRC_ATTRIBUTE9: '|| p_adj_rec.percent);

1796: IF p_pricing_attribute9 IS NOT NULL THEN
1797:
1798: IF Attribute_Used(G_ATTR_PRC_ATTRIBUTE9) THEN
1799: --DBMS_output.put_line('In fetch best adjustment PRC_ATTR9: '|| p_adj_rec.percent);
1800: OE_DEBUG_PUB.ADD('In fetch best adjustment PRC_ATTRIBUTE9: '|| p_adj_rec.percent);
1801: Get_Adjustment
1802: ( p_best_adj_rec => l_adj_rec ,
1803: p_best_adj_percent=> l_adj_percent ,
1804: p_attribute_id => G_ATTR_PRC_ATTRIBUTE9 ,

Line 1828: OE_DEBUG_PUB.ADD('In fetch best adjustment PRC_ATTRIBUTE10: '|| p_adj_rec.percent);

1824: IF p_pricing_attribute10 IS NOT NULL THEN
1825:
1826: IF Attribute_Used(G_ATTR_PRC_ATTRIBUTE10) THEN
1827: --DBMS_output.put_line('In fetch best adjustment PRC_ATTR10: '|| p_adj_rec.percent);
1828: OE_DEBUG_PUB.ADD('In fetch best adjustment PRC_ATTRIBUTE10: '|| p_adj_rec.percent);
1829: Get_Adjustment
1830: ( p_best_adj_rec => l_adj_rec ,
1831: p_best_adj_percent=> l_adj_percent ,
1832: p_attribute_id => G_ATTR_PRC_ATTRIBUTE10 ,

Line 1856: OE_DEBUG_PUB.ADD('In fetch best adjustment PRC_ATTRIBUTE11: '|| p_adj_rec.percent);

1852: IF p_pricing_attribute11 IS NOT NULL THEN
1853:
1854: IF Attribute_Used(G_ATTR_PRC_ATTRIBUTE11) THEN
1855: --DBMS_output.put_line('In fetch best adjustment PRC_ATTR11: '|| p_adj_rec.percent);
1856: OE_DEBUG_PUB.ADD('In fetch best adjustment PRC_ATTRIBUTE11: '|| p_adj_rec.percent);
1857: Get_Adjustment
1858: ( p_best_adj_rec => l_adj_rec ,
1859: p_best_adj_percent=> l_adj_percent ,
1860: p_attribute_id => G_ATTR_PRC_ATTRIBUTE11 ,

Line 1884: OE_DEBUG_PUB.ADD('In fetch best adjustment PRC_ATTRIBUTE12: '|| p_adj_rec.percent);

1880: IF p_pricing_attribute12 IS NOT NULL THEN
1881:
1882: IF Attribute_Used(G_ATTR_PRC_ATTRIBUTE12) THEN
1883: --DBMS_output.put_line('In fetch best adjustment PRC_ATTR12: '|| p_adj_rec.percent);
1884: OE_DEBUG_PUB.ADD('In fetch best adjustment PRC_ATTRIBUTE12: '|| p_adj_rec.percent);
1885: Get_Adjustment
1886: ( p_best_adj_rec => l_adj_rec ,
1887: p_best_adj_percent=> l_adj_percent ,
1888: p_attribute_id => G_ATTR_PRC_ATTRIBUTE12 ,

Line 1912: OE_DEBUG_PUB.ADD('In fetch best adjustment PRC_ATTRIBUTE13: '|| p_adj_rec.percent);

1908: IF p_pricing_attribute13 IS NOT NULL THEN
1909:
1910: IF Attribute_Used(G_ATTR_PRC_ATTRIBUTE13) THEN
1911: --DBMS_OUTPUT.PUT_LINE('In fetch best adjustment PRC_ATTRIBUTE13: '|| p_adj_rec.percent);
1912: OE_DEBUG_PUB.ADD('In fetch best adjustment PRC_ATTRIBUTE13: '|| p_adj_rec.percent);
1913: Get_Adjustment
1914: ( p_best_adj_rec => l_adj_rec ,
1915: p_best_adj_percent=> l_adj_percent ,
1916: p_attribute_id => G_ATTR_PRC_ATTRIBUTE13 ,

Line 1940: OE_DEBUG_PUB.ADD('In fetch best adjustment PRC_ATTRIBUTE14: '|| p_adj_rec.percent);

1936: IF p_pricing_attribute14 IS NOT NULL THEN
1937:
1938: IF Attribute_Used(G_ATTR_PRC_ATTRIBUTE13) THEN
1939: --DBMS_OUTPUT.PUT_LINE('In fetch best adjustment PRC_ATTRIBUTE14: '|| p_adj_rec.percent);
1940: OE_DEBUG_PUB.ADD('In fetch best adjustment PRC_ATTRIBUTE14: '|| p_adj_rec.percent);
1941: Get_Adjustment
1942: ( p_best_adj_rec => l_adj_rec ,
1943: p_best_adj_percent=> l_adj_percent ,
1944: p_attribute_id => G_ATTR_PRC_ATTRIBUTE14 ,

Line 1987: OE_DEBUG_PUB.ADD('In fetch best adjustment PRC_ATTRIBUTE15: '|| p_adj_rec.percent);

1983: p_adj_percent => l_adj_percent
1984: );
1985:
1986: --DBMS_OUTPUT.PUT_LINE('In fetch best adjustment PRC_ATTRIBUTE15: '|| p_adj_rec.percent);
1987: OE_DEBUG_PUB.ADD('In fetch best adjustment PRC_ATTRIBUTE15: '|| p_adj_rec.percent);
1988:
1989: END IF;
1990:
1991: END IF;

Line 2106: oe_debug_pub.add('Exiting QP_PRC_UTIL.FETCH_BEST_ADJUSTMENT', 1);

2102: -- Return values collected in l_adj_rec to p_adj_rec out variable
2103:
2104: p_adj_rec := l_adj_rec;
2105: --DBMS_output.put_line('In Fetch Best Adjustment percent :'||p_adj_rec.percent);
2106: oe_debug_pub.add('Exiting QP_PRC_UTIL.FETCH_BEST_ADJUSTMENT', 1);
2107:
2108: EXCEPTION
2109:
2110: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2202: oe_debug_pub.add('Entering QP_PRC_UTIL.CALCULATE_SELLING_PRICE', 1);

2198: l_rounding_factor NUMBER;
2199:
2200: BEGIN
2201:
2202: oe_debug_pub.add('Entering QP_PRC_UTIL.CALCULATE_SELLING_PRICE', 1);
2203:
2204: -- p_price_list_id and p_pricing_method_code are required. If
2205: -- either is null, set all out parameters to NULL and return.
2206: --DBMS_output.put_line('In cal selling price--price_list_id: '||p_price_list_id);

Line 2328: oe_debug_pub.add('Exiting QP_PRC_UTIL.CALCULATE_SELLING_PRICE', 1);

2324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2325:
2326: END IF;
2327:
2328: oe_debug_pub.add('Exiting QP_PRC_UTIL.CALCULATE_SELLING_PRICE', 1);
2329:
2330: EXCEPTION
2331:
2332: WHEN OTHERS THEN

Line 2411: oe_debug_pub.add('Entering QP_PRC_UTIL.PRICE_ITEM', 1);

2407: BEGIN
2408:
2409: --DBMS_output.put_line('I am in Price Item');
2410:
2411: oe_debug_pub.add('Entering QP_PRC_UTIL.PRICE_ITEM', 1);
2412:
2413: -- Initialize p_return_status
2414:
2415: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2527: OE_DEBUG_PUB.ADD('+============================+');

2523: */
2524:
2525: -- Fetch highest automatic discount
2526:
2527: OE_DEBUG_PUB.ADD('+============================+');
2528: OE_DEBUG_PUB.ADD('|Before fetch best adjustment|');
2529: OE_DEBUG_PUB.ADD('+============================+');
2530: OE_DEBUG_PUB.ADD('l_item_rec.inventory_item_id '||l_item_rec.inventory_item_id);
2531: OE_DEBUG_PUB.ADD('l_item_rec.price_list_id '||l_item_rec.price_list_id);

Line 2528: OE_DEBUG_PUB.ADD('|Before fetch best adjustment|');

2524:
2525: -- Fetch highest automatic discount
2526:
2527: OE_DEBUG_PUB.ADD('+============================+');
2528: OE_DEBUG_PUB.ADD('|Before fetch best adjustment|');
2529: OE_DEBUG_PUB.ADD('+============================+');
2530: OE_DEBUG_PUB.ADD('l_item_rec.inventory_item_id '||l_item_rec.inventory_item_id);
2531: OE_DEBUG_PUB.ADD('l_item_rec.price_list_id '||l_item_rec.price_list_id);
2532: OE_DEBUG_PUB.ADD('l_item_rec.list_price '||l_item_rec.list_price);

Line 2529: OE_DEBUG_PUB.ADD('+============================+');

2525: -- Fetch highest automatic discount
2526:
2527: OE_DEBUG_PUB.ADD('+============================+');
2528: OE_DEBUG_PUB.ADD('|Before fetch best adjustment|');
2529: OE_DEBUG_PUB.ADD('+============================+');
2530: OE_DEBUG_PUB.ADD('l_item_rec.inventory_item_id '||l_item_rec.inventory_item_id);
2531: OE_DEBUG_PUB.ADD('l_item_rec.price_list_id '||l_item_rec.price_list_id);
2532: OE_DEBUG_PUB.ADD('l_item_rec.list_price '||l_item_rec.list_price);
2533: OE_DEBUG_PUB.ADD('l_item_rec.quantity '||l_item_rec.quantity);

Line 2530: OE_DEBUG_PUB.ADD('l_item_rec.inventory_item_id '||l_item_rec.inventory_item_id);

2526:
2527: OE_DEBUG_PUB.ADD('+============================+');
2528: OE_DEBUG_PUB.ADD('|Before fetch best adjustment|');
2529: OE_DEBUG_PUB.ADD('+============================+');
2530: OE_DEBUG_PUB.ADD('l_item_rec.inventory_item_id '||l_item_rec.inventory_item_id);
2531: OE_DEBUG_PUB.ADD('l_item_rec.price_list_id '||l_item_rec.price_list_id);
2532: OE_DEBUG_PUB.ADD('l_item_rec.list_price '||l_item_rec.list_price);
2533: OE_DEBUG_PUB.ADD('l_item_rec.quantity '||l_item_rec.quantity);
2534: OE_DEBUG_PUB.ADD('l_item_rec.pricing_date '||l_item_rec.pricing_date);

Line 2531: OE_DEBUG_PUB.ADD('l_item_rec.price_list_id '||l_item_rec.price_list_id);

2527: OE_DEBUG_PUB.ADD('+============================+');
2528: OE_DEBUG_PUB.ADD('|Before fetch best adjustment|');
2529: OE_DEBUG_PUB.ADD('+============================+');
2530: OE_DEBUG_PUB.ADD('l_item_rec.inventory_item_id '||l_item_rec.inventory_item_id);
2531: OE_DEBUG_PUB.ADD('l_item_rec.price_list_id '||l_item_rec.price_list_id);
2532: OE_DEBUG_PUB.ADD('l_item_rec.list_price '||l_item_rec.list_price);
2533: OE_DEBUG_PUB.ADD('l_item_rec.quantity '||l_item_rec.quantity);
2534: OE_DEBUG_PUB.ADD('l_item_rec.pricing_date '||l_item_rec.pricing_date);
2535: OE_DEBUG_PUB.ADD('l_item_rec.unit_code '||l_item_rec.unit_code);

Line 2532: OE_DEBUG_PUB.ADD('l_item_rec.list_price '||l_item_rec.list_price);

2528: OE_DEBUG_PUB.ADD('|Before fetch best adjustment|');
2529: OE_DEBUG_PUB.ADD('+============================+');
2530: OE_DEBUG_PUB.ADD('l_item_rec.inventory_item_id '||l_item_rec.inventory_item_id);
2531: OE_DEBUG_PUB.ADD('l_item_rec.price_list_id '||l_item_rec.price_list_id);
2532: OE_DEBUG_PUB.ADD('l_item_rec.list_price '||l_item_rec.list_price);
2533: OE_DEBUG_PUB.ADD('l_item_rec.quantity '||l_item_rec.quantity);
2534: OE_DEBUG_PUB.ADD('l_item_rec.pricing_date '||l_item_rec.pricing_date);
2535: OE_DEBUG_PUB.ADD('l_item_rec.unit_code '||l_item_rec.unit_code);
2536: OE_DEBUG_PUB.ADD('l_item_rec.ship_to_site_use_id '||l_item_rec.ship_to_site_use_id);

Line 2533: OE_DEBUG_PUB.ADD('l_item_rec.quantity '||l_item_rec.quantity);

2529: OE_DEBUG_PUB.ADD('+============================+');
2530: OE_DEBUG_PUB.ADD('l_item_rec.inventory_item_id '||l_item_rec.inventory_item_id);
2531: OE_DEBUG_PUB.ADD('l_item_rec.price_list_id '||l_item_rec.price_list_id);
2532: OE_DEBUG_PUB.ADD('l_item_rec.list_price '||l_item_rec.list_price);
2533: OE_DEBUG_PUB.ADD('l_item_rec.quantity '||l_item_rec.quantity);
2534: OE_DEBUG_PUB.ADD('l_item_rec.pricing_date '||l_item_rec.pricing_date);
2535: OE_DEBUG_PUB.ADD('l_item_rec.unit_code '||l_item_rec.unit_code);
2536: OE_DEBUG_PUB.ADD('l_item_rec.ship_to_site_use_id '||l_item_rec.ship_to_site_use_id);
2537: OE_DEBUG_PUB.ADD('l_item_rec.item_category_id '||l_item_rec.item_category_id);

Line 2534: OE_DEBUG_PUB.ADD('l_item_rec.pricing_date '||l_item_rec.pricing_date);

2530: OE_DEBUG_PUB.ADD('l_item_rec.inventory_item_id '||l_item_rec.inventory_item_id);
2531: OE_DEBUG_PUB.ADD('l_item_rec.price_list_id '||l_item_rec.price_list_id);
2532: OE_DEBUG_PUB.ADD('l_item_rec.list_price '||l_item_rec.list_price);
2533: OE_DEBUG_PUB.ADD('l_item_rec.quantity '||l_item_rec.quantity);
2534: OE_DEBUG_PUB.ADD('l_item_rec.pricing_date '||l_item_rec.pricing_date);
2535: OE_DEBUG_PUB.ADD('l_item_rec.unit_code '||l_item_rec.unit_code);
2536: OE_DEBUG_PUB.ADD('l_item_rec.ship_to_site_use_id '||l_item_rec.ship_to_site_use_id);
2537: OE_DEBUG_PUB.ADD('l_item_rec.item_category_id '||l_item_rec.item_category_id);
2538: OE_DEBUG_PUB.ADD('l_item_rec.sold_to_org_id '||l_item_rec.sold_to_org_id);

Line 2535: OE_DEBUG_PUB.ADD('l_item_rec.unit_code '||l_item_rec.unit_code);

2531: OE_DEBUG_PUB.ADD('l_item_rec.price_list_id '||l_item_rec.price_list_id);
2532: OE_DEBUG_PUB.ADD('l_item_rec.list_price '||l_item_rec.list_price);
2533: OE_DEBUG_PUB.ADD('l_item_rec.quantity '||l_item_rec.quantity);
2534: OE_DEBUG_PUB.ADD('l_item_rec.pricing_date '||l_item_rec.pricing_date);
2535: OE_DEBUG_PUB.ADD('l_item_rec.unit_code '||l_item_rec.unit_code);
2536: OE_DEBUG_PUB.ADD('l_item_rec.ship_to_site_use_id '||l_item_rec.ship_to_site_use_id);
2537: OE_DEBUG_PUB.ADD('l_item_rec.item_category_id '||l_item_rec.item_category_id);
2538: OE_DEBUG_PUB.ADD('l_item_rec.sold_to_org_id '||l_item_rec.sold_to_org_id);
2539: OE_DEBUG_PUB.ADD('l_item_rec.customer_class_code '||l_item_rec.customer_class_code);

Line 2536: OE_DEBUG_PUB.ADD('l_item_rec.ship_to_site_use_id '||l_item_rec.ship_to_site_use_id);

2532: OE_DEBUG_PUB.ADD('l_item_rec.list_price '||l_item_rec.list_price);
2533: OE_DEBUG_PUB.ADD('l_item_rec.quantity '||l_item_rec.quantity);
2534: OE_DEBUG_PUB.ADD('l_item_rec.pricing_date '||l_item_rec.pricing_date);
2535: OE_DEBUG_PUB.ADD('l_item_rec.unit_code '||l_item_rec.unit_code);
2536: OE_DEBUG_PUB.ADD('l_item_rec.ship_to_site_use_id '||l_item_rec.ship_to_site_use_id);
2537: OE_DEBUG_PUB.ADD('l_item_rec.item_category_id '||l_item_rec.item_category_id);
2538: OE_DEBUG_PUB.ADD('l_item_rec.sold_to_org_id '||l_item_rec.sold_to_org_id);
2539: OE_DEBUG_PUB.ADD('l_item_rec.customer_class_code '||l_item_rec.customer_class_code);
2540: OE_DEBUG_PUB.ADD('l_item_rec.invoice_to_org_id '||l_item_rec.invoice_to_org_id);

Line 2537: OE_DEBUG_PUB.ADD('l_item_rec.item_category_id '||l_item_rec.item_category_id);

2533: OE_DEBUG_PUB.ADD('l_item_rec.quantity '||l_item_rec.quantity);
2534: OE_DEBUG_PUB.ADD('l_item_rec.pricing_date '||l_item_rec.pricing_date);
2535: OE_DEBUG_PUB.ADD('l_item_rec.unit_code '||l_item_rec.unit_code);
2536: OE_DEBUG_PUB.ADD('l_item_rec.ship_to_site_use_id '||l_item_rec.ship_to_site_use_id);
2537: OE_DEBUG_PUB.ADD('l_item_rec.item_category_id '||l_item_rec.item_category_id);
2538: OE_DEBUG_PUB.ADD('l_item_rec.sold_to_org_id '||l_item_rec.sold_to_org_id);
2539: OE_DEBUG_PUB.ADD('l_item_rec.customer_class_code '||l_item_rec.customer_class_code);
2540: OE_DEBUG_PUB.ADD('l_item_rec.invoice_to_org_id '||l_item_rec.invoice_to_org_id);
2541: OE_DEBUG_PUB.ADD('l_item_rec.po_number '||l_item_rec.po_number);

Line 2538: OE_DEBUG_PUB.ADD('l_item_rec.sold_to_org_id '||l_item_rec.sold_to_org_id);

2534: OE_DEBUG_PUB.ADD('l_item_rec.pricing_date '||l_item_rec.pricing_date);
2535: OE_DEBUG_PUB.ADD('l_item_rec.unit_code '||l_item_rec.unit_code);
2536: OE_DEBUG_PUB.ADD('l_item_rec.ship_to_site_use_id '||l_item_rec.ship_to_site_use_id);
2537: OE_DEBUG_PUB.ADD('l_item_rec.item_category_id '||l_item_rec.item_category_id);
2538: OE_DEBUG_PUB.ADD('l_item_rec.sold_to_org_id '||l_item_rec.sold_to_org_id);
2539: OE_DEBUG_PUB.ADD('l_item_rec.customer_class_code '||l_item_rec.customer_class_code);
2540: OE_DEBUG_PUB.ADD('l_item_rec.invoice_to_org_id '||l_item_rec.invoice_to_org_id);
2541: OE_DEBUG_PUB.ADD('l_item_rec.po_number '||l_item_rec.po_number);
2542: OE_DEBUG_PUB.ADD('l_item_rec.agreement_id '||l_item_rec.agreement_id);

Line 2539: OE_DEBUG_PUB.ADD('l_item_rec.customer_class_code '||l_item_rec.customer_class_code);

2535: OE_DEBUG_PUB.ADD('l_item_rec.unit_code '||l_item_rec.unit_code);
2536: OE_DEBUG_PUB.ADD('l_item_rec.ship_to_site_use_id '||l_item_rec.ship_to_site_use_id);
2537: OE_DEBUG_PUB.ADD('l_item_rec.item_category_id '||l_item_rec.item_category_id);
2538: OE_DEBUG_PUB.ADD('l_item_rec.sold_to_org_id '||l_item_rec.sold_to_org_id);
2539: OE_DEBUG_PUB.ADD('l_item_rec.customer_class_code '||l_item_rec.customer_class_code);
2540: OE_DEBUG_PUB.ADD('l_item_rec.invoice_to_org_id '||l_item_rec.invoice_to_org_id);
2541: OE_DEBUG_PUB.ADD('l_item_rec.po_number '||l_item_rec.po_number);
2542: OE_DEBUG_PUB.ADD('l_item_rec.agreement_id '||l_item_rec.agreement_id);
2543: OE_DEBUG_PUB.ADD('p_order_type_id '||l_item_rec.order_type_id);

Line 2540: OE_DEBUG_PUB.ADD('l_item_rec.invoice_to_org_id '||l_item_rec.invoice_to_org_id);

2536: OE_DEBUG_PUB.ADD('l_item_rec.ship_to_site_use_id '||l_item_rec.ship_to_site_use_id);
2537: OE_DEBUG_PUB.ADD('l_item_rec.item_category_id '||l_item_rec.item_category_id);
2538: OE_DEBUG_PUB.ADD('l_item_rec.sold_to_org_id '||l_item_rec.sold_to_org_id);
2539: OE_DEBUG_PUB.ADD('l_item_rec.customer_class_code '||l_item_rec.customer_class_code);
2540: OE_DEBUG_PUB.ADD('l_item_rec.invoice_to_org_id '||l_item_rec.invoice_to_org_id);
2541: OE_DEBUG_PUB.ADD('l_item_rec.po_number '||l_item_rec.po_number);
2542: OE_DEBUG_PUB.ADD('l_item_rec.agreement_id '||l_item_rec.agreement_id);
2543: OE_DEBUG_PUB.ADD('p_order_type_id '||l_item_rec.order_type_id);
2544: OE_DEBUG_PUB.ADD('p_gsa '||l_item_rec.gsa);

Line 2541: OE_DEBUG_PUB.ADD('l_item_rec.po_number '||l_item_rec.po_number);

2537: OE_DEBUG_PUB.ADD('l_item_rec.item_category_id '||l_item_rec.item_category_id);
2538: OE_DEBUG_PUB.ADD('l_item_rec.sold_to_org_id '||l_item_rec.sold_to_org_id);
2539: OE_DEBUG_PUB.ADD('l_item_rec.customer_class_code '||l_item_rec.customer_class_code);
2540: OE_DEBUG_PUB.ADD('l_item_rec.invoice_to_org_id '||l_item_rec.invoice_to_org_id);
2541: OE_DEBUG_PUB.ADD('l_item_rec.po_number '||l_item_rec.po_number);
2542: OE_DEBUG_PUB.ADD('l_item_rec.agreement_id '||l_item_rec.agreement_id);
2543: OE_DEBUG_PUB.ADD('p_order_type_id '||l_item_rec.order_type_id);
2544: OE_DEBUG_PUB.ADD('p_gsa '||l_item_rec.gsa);
2545: OE_DEBUG_PUB.ADD('l_item_rec.pricing_attribute1'||l_item_rec.pricing_attribute1);

Line 2542: OE_DEBUG_PUB.ADD('l_item_rec.agreement_id '||l_item_rec.agreement_id);

2538: OE_DEBUG_PUB.ADD('l_item_rec.sold_to_org_id '||l_item_rec.sold_to_org_id);
2539: OE_DEBUG_PUB.ADD('l_item_rec.customer_class_code '||l_item_rec.customer_class_code);
2540: OE_DEBUG_PUB.ADD('l_item_rec.invoice_to_org_id '||l_item_rec.invoice_to_org_id);
2541: OE_DEBUG_PUB.ADD('l_item_rec.po_number '||l_item_rec.po_number);
2542: OE_DEBUG_PUB.ADD('l_item_rec.agreement_id '||l_item_rec.agreement_id);
2543: OE_DEBUG_PUB.ADD('p_order_type_id '||l_item_rec.order_type_id);
2544: OE_DEBUG_PUB.ADD('p_gsa '||l_item_rec.gsa);
2545: OE_DEBUG_PUB.ADD('l_item_rec.pricing_attribute1'||l_item_rec.pricing_attribute1);
2546:

Line 2543: OE_DEBUG_PUB.ADD('p_order_type_id '||l_item_rec.order_type_id);

2539: OE_DEBUG_PUB.ADD('l_item_rec.customer_class_code '||l_item_rec.customer_class_code);
2540: OE_DEBUG_PUB.ADD('l_item_rec.invoice_to_org_id '||l_item_rec.invoice_to_org_id);
2541: OE_DEBUG_PUB.ADD('l_item_rec.po_number '||l_item_rec.po_number);
2542: OE_DEBUG_PUB.ADD('l_item_rec.agreement_id '||l_item_rec.agreement_id);
2543: OE_DEBUG_PUB.ADD('p_order_type_id '||l_item_rec.order_type_id);
2544: OE_DEBUG_PUB.ADD('p_gsa '||l_item_rec.gsa);
2545: OE_DEBUG_PUB.ADD('l_item_rec.pricing_attribute1'||l_item_rec.pricing_attribute1);
2546:
2547: --DBMS_OUTPUT.PUT_LINE('+============================+');

Line 2544: OE_DEBUG_PUB.ADD('p_gsa '||l_item_rec.gsa);

2540: OE_DEBUG_PUB.ADD('l_item_rec.invoice_to_org_id '||l_item_rec.invoice_to_org_id);
2541: OE_DEBUG_PUB.ADD('l_item_rec.po_number '||l_item_rec.po_number);
2542: OE_DEBUG_PUB.ADD('l_item_rec.agreement_id '||l_item_rec.agreement_id);
2543: OE_DEBUG_PUB.ADD('p_order_type_id '||l_item_rec.order_type_id);
2544: OE_DEBUG_PUB.ADD('p_gsa '||l_item_rec.gsa);
2545: OE_DEBUG_PUB.ADD('l_item_rec.pricing_attribute1'||l_item_rec.pricing_attribute1);
2546:
2547: --DBMS_OUTPUT.PUT_LINE('+============================+');
2548: --DBMS_OUTPUT.PUT_LINE('|Before fetch best adjustment|');

Line 2545: OE_DEBUG_PUB.ADD('l_item_rec.pricing_attribute1'||l_item_rec.pricing_attribute1);

2541: OE_DEBUG_PUB.ADD('l_item_rec.po_number '||l_item_rec.po_number);
2542: OE_DEBUG_PUB.ADD('l_item_rec.agreement_id '||l_item_rec.agreement_id);
2543: OE_DEBUG_PUB.ADD('p_order_type_id '||l_item_rec.order_type_id);
2544: OE_DEBUG_PUB.ADD('p_gsa '||l_item_rec.gsa);
2545: OE_DEBUG_PUB.ADD('l_item_rec.pricing_attribute1'||l_item_rec.pricing_attribute1);
2546:
2547: --DBMS_OUTPUT.PUT_LINE('+============================+');
2548: --DBMS_OUTPUT.PUT_LINE('|Before fetch best adjustment|');
2549: --DBMS_OUTPUT.PUT_LINE('+============================+');

Line 2679: oe_debug_pub.add('Exiting QP_PRC_UTIL.PRICE_ITEM', 1);

2675: p_selling_percent => p_selling_percent ,
2676: p_list_price_out => p_list_price_out
2677: );
2678:
2679: oe_debug_pub.add('Exiting QP_PRC_UTIL.PRICE_ITEM', 1);
2680:
2681: EXCEPTION
2682:
2683: WHEN FND_API.G_EXC_ERROR THEN