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.OE_HEADER_ADJ_UTIL dependencies on OE_DEBUG_PUB

Line 12: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

8: FUNCTION G_MISS_OE_AK_HEADER_ADJ_REC
9: RETURN OE_AK_HEADER_PRCADJS_V%ROWTYPE IS
10: l_rowtype_rec OE_AK_HEADER_PRCADJS_V%ROWTYPE;
11: --
12: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
13: --
14: BEGIN
15:
16: l_rowtype_rec.ATTRIBUTE1 := FND_API.G_MISS_CHAR;

Line 127: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

123: ( p_HEADER_ADJ_rec IN OE_Order_PUB.HEADER_ADJ_Rec_Type
124: , x_rowtype_rec OUT nocopy OE_AK_HEADER_PRCADJS_V%ROWTYPE
125: ) IS
126: --
127: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
128: --
129: BEGIN
130:
131: x_rowtype_rec.ATTRIBUTE1 := p_header_adj_rec.ATTRIBUTE1;

Line 246: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

242: )
243: iS
244:
245: --
246: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
247: --
248: BEGIN
249:
250: x_api_rec.ATTRIBUTE1 := p_record.ATTRIBUTE1;

Line 373: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

369: l_index NUMBER :=0;
370: l_src_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
371: l_dep_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
372: --
373: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
374: --
375: BEGIN
376:
377: IF l_debug_level > 0 THEN

Line 378: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_UTIL.CLEAR_DEPENDENT_ATTR' , 1 ) ;

374: --
375: BEGIN
376:
377: IF l_debug_level > 0 THEN
378: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_UTIL.CLEAR_DEPENDENT_ATTR' , 1 ) ;
379: END IF;
380:
381: -- Load out record
382:

Line 1103: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.CLEAR_DEPENDENT_ATTR' , 1 ) ;

1099: END LOOP;
1100: END IF;
1101:
1102: IF l_debug_level > 0 THEN
1103: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.CLEAR_DEPENDENT_ATTR' , 1 ) ;
1104: END IF;
1105:
1106: END Clear_Dependent_Attr;
1107:

Line 1126: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1122: l_old_Header_Adj_rec OE_AK_HEADER_PRCADJS_V%ROWTYPE ;
1123: l_initial_Header_Adj_rec OE_AK_HEADER_PRCADJS_V%ROWTYPE;
1124:
1125: --
1126: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1127: --
1128: BEGIN
1129:
1130: IF l_debug_level > 0 THEN

Line 1131: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_UTIL.CLEAR_DEPENDENT_ATTR' , 1 ) ;

1127: --
1128: BEGIN
1129:
1130: IF l_debug_level > 0 THEN
1131: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_UTIL.CLEAR_DEPENDENT_ATTR' , 1 ) ;
1132: END IF;
1133:
1134: -- Load out record
1135:

Line 1150: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.CLEAR_DEPENDENT_ATTR' , 1 ) ;

1146:
1147: Rowtype_Rec_To_API_Rec(l_Header_Adj_rec,p_x_Header_Adj_rec);
1148:
1149: IF l_debug_level > 0 THEN
1150: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.CLEAR_DEPENDENT_ATTR' , 1 ) ;
1151: END IF;
1152:
1153: END Clear_Dependent_Attr;
1154:

Line 1158: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1154:
1155: --bug 4060297
1156: Procedure log_request_for_margin(p_header_id in number)
1157: is
1158: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1159: l_booked_flag varchar2(1);
1160: l_return_status VARCHAR2(1);
1161: begin
1162: If l_debug_level > 0 Then

Line 1163: oe_debug_pub.add('in log_request_for_margin');

1159: l_booked_flag varchar2(1);
1160: l_return_status VARCHAR2(1);
1161: begin
1162: If l_debug_level > 0 Then
1163: oe_debug_pub.add('in log_request_for_margin');
1164: oe_debug_pub.add('p_header_id : '||p_header_id);
1165: End If;
1166: OE_Order_Cache.Load_Order_Header(p_header_id);
1167: l_booked_flag := OE_ORDER_CACHE.g_header_rec.booked_flag;

Line 1164: oe_debug_pub.add('p_header_id : '||p_header_id);

1160: l_return_status VARCHAR2(1);
1161: begin
1162: If l_debug_level > 0 Then
1163: oe_debug_pub.add('in log_request_for_margin');
1164: oe_debug_pub.add('p_header_id : '||p_header_id);
1165: End If;
1166: OE_Order_Cache.Load_Order_Header(p_header_id);
1167: l_booked_flag := OE_ORDER_CACHE.g_header_rec.booked_flag;
1168: oe_debug_pub.add('l_booked_flag : '||l_booked_flag);

Line 1168: oe_debug_pub.add('l_booked_flag : '||l_booked_flag);

1164: oe_debug_pub.add('p_header_id : '||p_header_id);
1165: End If;
1166: OE_Order_Cache.Load_Order_Header(p_header_id);
1167: l_booked_flag := OE_ORDER_CACHE.g_header_rec.booked_flag;
1168: oe_debug_pub.add('l_booked_flag : '||l_booked_flag);
1169: /*
1170: select booked_flag into l_booked_flag from oe_order_headers_all
1171: where header_id = p_header_id;
1172: */

Line 1177: oe_debug_pub.add( 'LOGGING DELAYED REQUEST FOR MARGIN HOLD FOR BOOKED HEADER ID : '||p_header_id);

1173: If OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
1174: If l_booked_flag = 'Y' Then
1175: IF nvl(Oe_Sys_Parameters.Value('COMPUTE_MARGIN'),'N') <> 'N' Then
1176: IF l_debug_level > 0 THEN
1177: oe_debug_pub.add( 'LOGGING DELAYED REQUEST FOR MARGIN HOLD FOR BOOKED HEADER ID : '||p_header_id);
1178: END IF;
1179: oe_delayed_requests_pvt.log_request(
1180: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1181: p_entity_id => p_header_id,

Line 1217: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1213: l_rule_defined VARCHAR2(1);
1214: l_credit_check_rule_id NUMBER;
1215: l_credit_check_rule_rec OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type ;
1216: --
1217: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1218: --
1219: BEGIN
1220:
1221: IF l_debug_level > 0 THEN

Line 1222: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_UTIL.APPLY_ATTRIBUTE_CHANGES' , 1 ) ;

1218: --
1219: BEGIN
1220:
1221: IF l_debug_level > 0 THEN
1222: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_UTIL.APPLY_ATTRIBUTE_CHANGES' , 1 ) ;
1223: END IF;
1224:
1225: -- Load out record
1226:

Line 1711: oe_debug_pub.add( 'OEXUHADB: BEFORE QUERYING HEADER ID : '|| p_x_header_adj_rec.header_id ) ;

1707: IF (l_verify_payment_flag = 'Y') THEN
1708: --Start bug#5961160
1709: -- Query the Order Header
1710: IF l_debug_level > 0 THEN
1711: oe_debug_pub.add( 'OEXUHADB: BEFORE QUERYING HEADER ID : '|| p_x_header_adj_rec.header_id ) ;
1712: END IF;
1713:
1714: OE_Header_UTIL.Query_Row
1715: (p_header_id => p_x_header_adj_rec.header_id

Line 1721: OE_DEBUG_PUB.ADD('after query header ');

1717: );
1718:
1719: IF l_debug_level > 0
1720: THEN
1721: OE_DEBUG_PUB.ADD('after query header ');
1722: OE_DEBUG_PUB.ADD(' ');
1723: OE_DEBUG_PUB.ADD('================================================');
1724: OE_DEBUG_PUB.ADD('Header ID = '|| l_header_rec.header_id );
1725: OE_DEBUG_PUB.ADD('order_category_code = '|| l_header_rec.order_category_code );

Line 1722: OE_DEBUG_PUB.ADD(' ');

1718:
1719: IF l_debug_level > 0
1720: THEN
1721: OE_DEBUG_PUB.ADD('after query header ');
1722: OE_DEBUG_PUB.ADD(' ');
1723: OE_DEBUG_PUB.ADD('================================================');
1724: OE_DEBUG_PUB.ADD('Header ID = '|| l_header_rec.header_id );
1725: OE_DEBUG_PUB.ADD('order_category_code = '|| l_header_rec.order_category_code );
1726: OE_DEBUG_PUB.ADD('Booked flag = '|| l_header_rec.booked_flag );

Line 1723: OE_DEBUG_PUB.ADD('================================================');

1719: IF l_debug_level > 0
1720: THEN
1721: OE_DEBUG_PUB.ADD('after query header ');
1722: OE_DEBUG_PUB.ADD(' ');
1723: OE_DEBUG_PUB.ADD('================================================');
1724: OE_DEBUG_PUB.ADD('Header ID = '|| l_header_rec.header_id );
1725: OE_DEBUG_PUB.ADD('order_category_code = '|| l_header_rec.order_category_code );
1726: OE_DEBUG_PUB.ADD('Booked flag = '|| l_header_rec.booked_flag );
1727: OE_DEBUG_PUB.ADD('Order number = '|| l_header_rec.order_number );

Line 1724: OE_DEBUG_PUB.ADD('Header ID = '|| l_header_rec.header_id );

1720: THEN
1721: OE_DEBUG_PUB.ADD('after query header ');
1722: OE_DEBUG_PUB.ADD(' ');
1723: OE_DEBUG_PUB.ADD('================================================');
1724: OE_DEBUG_PUB.ADD('Header ID = '|| l_header_rec.header_id );
1725: OE_DEBUG_PUB.ADD('order_category_code = '|| l_header_rec.order_category_code );
1726: OE_DEBUG_PUB.ADD('Booked flag = '|| l_header_rec.booked_flag );
1727: OE_DEBUG_PUB.ADD('Order number = '|| l_header_rec.order_number );
1728: OE_DEBUG_PUB.ADD('payment_term_id = '|| l_header_rec.payment_term_id );

Line 1725: OE_DEBUG_PUB.ADD('order_category_code = '|| l_header_rec.order_category_code );

1721: OE_DEBUG_PUB.ADD('after query header ');
1722: OE_DEBUG_PUB.ADD(' ');
1723: OE_DEBUG_PUB.ADD('================================================');
1724: OE_DEBUG_PUB.ADD('Header ID = '|| l_header_rec.header_id );
1725: OE_DEBUG_PUB.ADD('order_category_code = '|| l_header_rec.order_category_code );
1726: OE_DEBUG_PUB.ADD('Booked flag = '|| l_header_rec.booked_flag );
1727: OE_DEBUG_PUB.ADD('Order number = '|| l_header_rec.order_number );
1728: OE_DEBUG_PUB.ADD('payment_term_id = '|| l_header_rec.payment_term_id );
1729: OE_DEBUG_PUB.ADD('order_type_id = '|| l_header_rec.order_type_id );

Line 1726: OE_DEBUG_PUB.ADD('Booked flag = '|| l_header_rec.booked_flag );

1722: OE_DEBUG_PUB.ADD(' ');
1723: OE_DEBUG_PUB.ADD('================================================');
1724: OE_DEBUG_PUB.ADD('Header ID = '|| l_header_rec.header_id );
1725: OE_DEBUG_PUB.ADD('order_category_code = '|| l_header_rec.order_category_code );
1726: OE_DEBUG_PUB.ADD('Booked flag = '|| l_header_rec.booked_flag );
1727: OE_DEBUG_PUB.ADD('Order number = '|| l_header_rec.order_number );
1728: OE_DEBUG_PUB.ADD('payment_term_id = '|| l_header_rec.payment_term_id );
1729: OE_DEBUG_PUB.ADD('order_type_id = '|| l_header_rec.order_type_id );
1730: OE_DEBUG_PUB.ADD(' ');

Line 1727: OE_DEBUG_PUB.ADD('Order number = '|| l_header_rec.order_number );

1723: OE_DEBUG_PUB.ADD('================================================');
1724: OE_DEBUG_PUB.ADD('Header ID = '|| l_header_rec.header_id );
1725: OE_DEBUG_PUB.ADD('order_category_code = '|| l_header_rec.order_category_code );
1726: OE_DEBUG_PUB.ADD('Booked flag = '|| l_header_rec.booked_flag );
1727: OE_DEBUG_PUB.ADD('Order number = '|| l_header_rec.order_number );
1728: OE_DEBUG_PUB.ADD('payment_term_id = '|| l_header_rec.payment_term_id );
1729: OE_DEBUG_PUB.ADD('order_type_id = '|| l_header_rec.order_type_id );
1730: OE_DEBUG_PUB.ADD(' ');
1731: OE_DEBUG_PUB.ADD('================================================');

Line 1728: OE_DEBUG_PUB.ADD('payment_term_id = '|| l_header_rec.payment_term_id );

1724: OE_DEBUG_PUB.ADD('Header ID = '|| l_header_rec.header_id );
1725: OE_DEBUG_PUB.ADD('order_category_code = '|| l_header_rec.order_category_code );
1726: OE_DEBUG_PUB.ADD('Booked flag = '|| l_header_rec.booked_flag );
1727: OE_DEBUG_PUB.ADD('Order number = '|| l_header_rec.order_number );
1728: OE_DEBUG_PUB.ADD('payment_term_id = '|| l_header_rec.payment_term_id );
1729: OE_DEBUG_PUB.ADD('order_type_id = '|| l_header_rec.order_type_id );
1730: OE_DEBUG_PUB.ADD(' ');
1731: OE_DEBUG_PUB.ADD('================================================');
1732: END IF;

Line 1729: OE_DEBUG_PUB.ADD('order_type_id = '|| l_header_rec.order_type_id );

1725: OE_DEBUG_PUB.ADD('order_category_code = '|| l_header_rec.order_category_code );
1726: OE_DEBUG_PUB.ADD('Booked flag = '|| l_header_rec.booked_flag );
1727: OE_DEBUG_PUB.ADD('Order number = '|| l_header_rec.order_number );
1728: OE_DEBUG_PUB.ADD('payment_term_id = '|| l_header_rec.payment_term_id );
1729: OE_DEBUG_PUB.ADD('order_type_id = '|| l_header_rec.order_type_id );
1730: OE_DEBUG_PUB.ADD(' ');
1731: OE_DEBUG_PUB.ADD('================================================');
1732: END IF;
1733:

Line 1730: OE_DEBUG_PUB.ADD(' ');

1726: OE_DEBUG_PUB.ADD('Booked flag = '|| l_header_rec.booked_flag );
1727: OE_DEBUG_PUB.ADD('Order number = '|| l_header_rec.order_number );
1728: OE_DEBUG_PUB.ADD('payment_term_id = '|| l_header_rec.payment_term_id );
1729: OE_DEBUG_PUB.ADD('order_type_id = '|| l_header_rec.order_type_id );
1730: OE_DEBUG_PUB.ADD(' ');
1731: OE_DEBUG_PUB.ADD('================================================');
1732: END IF;
1733:
1734: -- Call Which_Rule function to find out Which Rule to Apply

Line 1731: OE_DEBUG_PUB.ADD('================================================');

1727: OE_DEBUG_PUB.ADD('Order number = '|| l_header_rec.order_number );
1728: OE_DEBUG_PUB.ADD('payment_term_id = '|| l_header_rec.payment_term_id );
1729: OE_DEBUG_PUB.ADD('order_type_id = '|| l_header_rec.order_type_id );
1730: OE_DEBUG_PUB.ADD(' ');
1731: OE_DEBUG_PUB.ADD('================================================');
1732: END IF;
1733:
1734: -- Call Which_Rule function to find out Which Rule to Apply
1735: IF l_debug_level > 0 THEN

Line 1736: oe_debug_pub.add( 'OEXUHADB: BEFORE CALLING WHICH RULE ' ) ;

1732: END IF;
1733:
1734: -- Call Which_Rule function to find out Which Rule to Apply
1735: IF l_debug_level > 0 THEN
1736: oe_debug_pub.add( 'OEXUHADB: BEFORE CALLING WHICH RULE ' ) ;
1737: END IF;
1738:
1739: l_calling_action := OE_Verify_Payment_PUB.Which_Rule(p_header_id => p_x_header_adj_rec.header_id);
1740:

Line 1742: oe_debug_pub.add( 'OEXUHADB: RULE TO BE USED IS : '|| l_calling_action ) ;

1738:
1739: l_calling_action := OE_Verify_Payment_PUB.Which_Rule(p_header_id => p_x_header_adj_rec.header_id);
1740:
1741: IF l_debug_level > 0 THEN
1742: oe_debug_pub.add( 'OEXUHADB: RULE TO BE USED IS : '|| l_calling_action ) ;
1743: END IF;
1744:
1745: IF l_debug_level > 0 THEN
1746: oe_debug_pub.add( 'OEXUHADB: BEFORE CHECKING IF THE RULE IS DEFINED OR NOT' ) ;

Line 1746: oe_debug_pub.add( 'OEXUHADB: BEFORE CHECKING IF THE RULE IS DEFINED OR NOT' ) ;

1742: oe_debug_pub.add( 'OEXUHADB: RULE TO BE USED IS : '|| l_calling_action ) ;
1743: END IF;
1744:
1745: IF l_debug_level > 0 THEN
1746: oe_debug_pub.add( 'OEXUHADB: BEFORE CHECKING IF THE RULE IS DEFINED OR NOT' ) ;
1747: END IF;
1748:
1749: l_rule_defined := OE_Verify_Payment_PUB.Check_Rule_Defined
1750: ( p_header_rec => l_header_rec

Line 1755: oe_debug_pub.add( 'OEXUHADB: OUT OF RULE DEFINED : '|| l_rule_defined);

1751: , p_calling_action => l_calling_action
1752: ) ;
1753:
1754: IF l_debug_level > 0 THEN
1755: oe_debug_pub.add( 'OEXUHADB: OUT OF RULE DEFINED : '|| l_rule_defined);
1756: END IF;
1757:
1758: IF l_rule_defined = 'Y' THEN
1759: l_credit_check_rule_id := NULL ;

Line 1763: oe_debug_pub.add( 'Before L_CREDIT_CHECK_RULE_ID => '|| l_credit_check_rule_id ) ;

1759: l_credit_check_rule_id := NULL ;
1760:
1761: -- Check the Rule to Apply
1762: IF l_debug_level > 0 THEN
1763: oe_debug_pub.add( 'Before L_CREDIT_CHECK_RULE_ID => '|| l_credit_check_rule_id ) ;
1764: END IF;
1765:
1766: OE_CREDIT_CHECK_UTIL.Get_Credit_Check_Rule_ID
1767: ( p_calling_action => l_calling_action

Line 1773: oe_debug_pub.add( 'After L_CREDIT_CHECK_RULE_ID => '|| l_credit_check_rule_id ) ;

1769: , x_credit_rule_id => l_credit_check_rule_id
1770: );
1771:
1772: IF l_debug_level > 0 THEN
1773: oe_debug_pub.add( 'After L_CREDIT_CHECK_RULE_ID => '|| l_credit_check_rule_id ) ;
1774: END IF;
1775:
1776: OE_CREDIT_CHECK_UTIL.GET_credit_check_rule
1777: ( p_credit_check_rule_id => l_credit_check_rule_id

Line 1782: oe_debug_pub.add( 'OEXUHADB: INCL FREIGHT CHARGE FLAG : '|| l_credit_check_rule_rec.incl_freight_charges_flag);

1778: , x_credit_check_rules_rec => l_credit_check_rule_rec
1779: );
1780:
1781: IF l_debug_level > 0 THEN
1782: oe_debug_pub.add( 'OEXUHADB: INCL FREIGHT CHARGE FLAG : '|| l_credit_check_rule_rec.incl_freight_charges_flag);
1783: END IF;
1784:
1785: IF NVL(l_credit_check_rule_rec.incl_freight_charges_flag,'N') = 'Y' THEN
1786: -- Log a request for Verify Payment

Line 1787: oe_debug_pub.add('OEXUHADB: Logging Delayed Request for Verify Payment',3);

1783: END IF;
1784:
1785: IF NVL(l_credit_check_rule_rec.incl_freight_charges_flag,'N') = 'Y' THEN
1786: -- Log a request for Verify Payment
1787: oe_debug_pub.add('OEXUHADB: Logging Delayed Request for Verify Payment',3);
1788: OE_delayed_requests_Pvt.log_request
1789: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1790: p_entity_id => p_x_header_adj_rec.header_id,
1791: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,

Line 1806: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.APPLY_ATTRIBUTE_CHANGES' , 1 ) ;

1802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1803: END IF;
1804:
1805: IF l_debug_level > 0 THEN
1806: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.APPLY_ATTRIBUTE_CHANGES' , 1 ) ;
1807: END IF;
1808:
1809: END Apply_Attribute_Changes;
1810:

Line 1820: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1816: )
1817: IS
1818: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type := p_x_Header_Adj_rec;
1819: --
1820: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1821: --
1822: BEGIN
1823:
1824: IF l_debug_level > 0 THEN

Line 1825: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_UTIL.COMPLETE_RECORD' , 1 ) ;

1821: --
1822: BEGIN
1823:
1824: IF l_debug_level > 0 THEN
1825: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_UTIL.COMPLETE_RECORD' , 1 ) ;
1826: END IF;
1827:
1828: IF l_Header_Adj_rec.price_adjustment_id = FND_API.G_MISS_NUM THEN
1829: l_Header_Adj_rec.price_adjustment_id := p_old_Header_Adj_rec.price_adjustment_id;

Line 2258: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.COMPLETE_RECORD' , 1 ) ;

2254: l_Header_Adj_rec.INVOICED_AMOUNT := p_old_Header_Adj_rec.INVOICED_AMOUNT;
2255: END IF;
2256:
2257: IF l_debug_level > 0 THEN
2258: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.COMPLETE_RECORD' , 1 ) ;
2259: END IF;
2260:
2261: -- RETURN l_Header_Adj_rec;
2262: p_x_Header_Adj_rec := l_Header_Adj_rec;

Line 2274: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

2270: )
2271: IS
2272: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type := p_x_Header_Adj_rec;
2273: --
2274: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2275: --
2276: BEGIN
2277:
2278: IF l_debug_level > 0 THEN

Line 2279: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_UTIL.CONVERT_MISS_TO_NULL' , 1 ) ;

2275: --
2276: BEGIN
2277:
2278: IF l_debug_level > 0 THEN
2279: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_UTIL.CONVERT_MISS_TO_NULL' , 1 ) ;
2280: END IF;
2281:
2282: IF l_Header_Adj_rec.price_adjustment_id = FND_API.G_MISS_NUM THEN
2283: l_Header_Adj_rec.price_adjustment_id := NULL;

Line 2679: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.CONVERT_MISS_TO_NULL' , 1 ) ;

2675: l_Header_Adj_rec.invoiced_amount := NULL;
2676: END IF;
2677:
2678: IF l_debug_level > 0 THEN
2679: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.CONVERT_MISS_TO_NULL' , 1 ) ;
2680: END IF;
2681:
2682: -- RETURN l_Header_Adj_rec;
2683: p_x_Header_Adj_rec := l_Header_Adj_rec;

Line 2700: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

2696: l_index NUMBER;
2697: l_return_status VARCHAR2(1);
2698:
2699: --
2700: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2701: --
2702: BEGIN
2703:
2704: IF l_debug_level > 0 THEN

Line 2705: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_UTIL.UPDATE_ROW' , 1 ) ;

2701: --
2702: BEGIN
2703:
2704: IF l_debug_level > 0 THEN
2705: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_UTIL.UPDATE_ROW' , 1 ) ;
2706: END IF;
2707:
2708: -- increment lock_control by 1 whenever the record is updated
2709: SELECT lock_control

Line 2722: oe_debug_pub.add( 'HDR_ADJ_ID= ' || P_HEADER_ADJ_REC.PRICE_ADJUSTMENT_ID ) ;

2718: -- check code release level first. Notification framework is at Pack H level
2719:
2720: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
2721: IF l_debug_level > 0 THEN
2722: oe_debug_pub.add( 'HDR_ADJ_ID= ' || P_HEADER_ADJ_REC.PRICE_ADJUSTMENT_ID ) ;
2723: END IF;
2724: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,
2725: p_Hdr_adj_rec =>p_header_adj_rec,
2726: p_hdr_adj_id => p_header_adj_rec.price_adjustment_id,

Line 2731: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_HEADER_ADJ_UTIL.UPDATE_ROE IS: ' || L_RETURN_STATUS ) ;

2727: x_index => l_index,
2728: x_return_status => l_return_status);
2729:
2730: IF l_debug_level > 0 THEN
2731: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_HEADER_ADJ_UTIL.UPDATE_ROE IS: ' || L_RETURN_STATUS ) ;
2732: END IF;
2733:
2734: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2735: IF l_debug_level > 0 THEN

Line 2736: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;

2732: END IF;
2733:
2734: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2735: IF l_debug_level > 0 THEN
2736: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
2737: END IF;
2738: IF l_debug_level > 0 THEN
2739: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.UPDATE_ROW' , 1 ) ;
2740: END IF;

Line 2739: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.UPDATE_ROW' , 1 ) ;

2735: IF l_debug_level > 0 THEN
2736: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
2737: END IF;
2738: IF l_debug_level > 0 THEN
2739: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.UPDATE_ROW' , 1 ) ;
2740: END IF;
2741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2742: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2743: IF l_debug_level > 0 THEN

Line 2744: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_ADJ_UTIL.UPDATE_ROW' ) ;

2740: END IF;
2741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2742: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2743: IF l_debug_level > 0 THEN
2744: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_ADJ_UTIL.UPDATE_ROW' ) ;
2745: END IF;
2746: IF l_debug_level > 0 THEN
2747: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.UPDATE_ROW' , 1 ) ;
2748: END IF;

Line 2747: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.UPDATE_ROW' , 1 ) ;

2743: IF l_debug_level > 0 THEN
2744: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_ADJ_UTIL.UPDATE_ROW' ) ;
2745: END IF;
2746: IF l_debug_level > 0 THEN
2747: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.UPDATE_ROW' , 1 ) ;
2748: END IF;
2749: RAISE FND_API.G_EXC_ERROR;
2750: END IF;
2751: END IF; /*code_release_level*/

Line 2864: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.UPDATE_ROW' , 1 ) ;

2860: ;
2861:
2862: p_Header_Adj_rec.lock_control := l_lock_control;
2863: IF l_debug_level > 0 THEN
2864: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.UPDATE_ROW' , 1 ) ;
2865: END IF;
2866:
2867: EXCEPTION
2868:

Line 2895: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

2891: l_index NUMBER;
2892: l_return_status VARCHAR2(1);
2893:
2894: --
2895: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2896: --
2897: BEGIN
2898:
2899: IF l_debug_level > 0 THEN

Line 2900: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_UTIL.INSERT_ROW' , 1 ) ;

2896: --
2897: BEGIN
2898:
2899: IF l_debug_level > 0 THEN
2900: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_UTIL.INSERT_ROW' , 1 ) ;
2901: END IF;
2902:
2903: INSERT INTO OE_PRICE_ADJUSTMENTS
2904: ( PRICE_ADJUSTMENT_ID

Line 3127: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_HEADER_ADJ_UTIL.INSERT_ROW IS: ' || L_RETURN_STATUS ) ;

3123: x_index => l_index,
3124: x_return_status => l_return_status);
3125:
3126: IF l_debug_level > 0 THEN
3127: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_HEADER_ADJ_UTIL.INSERT_ROW IS: ' || L_RETURN_STATUS ) ;
3128: END IF;
3129: IF l_debug_level > 0 THEN
3130: oe_debug_pub.add( 'RETURNED INDEX IS: ' || L_INDEX , 1 ) ;
3131: END IF;

Line 3130: oe_debug_pub.add( 'RETURNED INDEX IS: ' || L_INDEX , 1 ) ;

3126: IF l_debug_level > 0 THEN
3127: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_HEADER_ADJ_UTIL.INSERT_ROW IS: ' || L_RETURN_STATUS ) ;
3128: END IF;
3129: IF l_debug_level > 0 THEN
3130: oe_debug_pub.add( 'RETURNED INDEX IS: ' || L_INDEX , 1 ) ;
3131: END IF;
3132:
3133: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3134: IF l_debug_level > 0 THEN

Line 3135: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;

3131: END IF;
3132:
3133: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3134: IF l_debug_level > 0 THEN
3135: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
3136: END IF;
3137: IF l_debug_level > 0 THEN
3138: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.INSERT_ROW' , 1 ) ;
3139: END IF;

Line 3138: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.INSERT_ROW' , 1 ) ;

3134: IF l_debug_level > 0 THEN
3135: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
3136: END IF;
3137: IF l_debug_level > 0 THEN
3138: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.INSERT_ROW' , 1 ) ;
3139: END IF;
3140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3141: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3142: IF l_debug_level > 0 THEN

Line 3143: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_ADJ_UTIL.INSERT_ROW' ) ;

3139: END IF;
3140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3141: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3142: IF l_debug_level > 0 THEN
3143: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_ADJ_UTIL.INSERT_ROW' ) ;
3144: END IF;
3145: IF l_debug_level > 0 THEN
3146: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.INSERT_ROW' , 1 ) ;
3147: END IF;

Line 3146: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.INSERT_ROW' , 1 ) ;

3142: IF l_debug_level > 0 THEN
3143: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_ADJ_UTIL.INSERT_ROW' ) ;
3144: END IF;
3145: IF l_debug_level > 0 THEN
3146: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.INSERT_ROW' , 1 ) ;
3147: END IF;
3148: RAISE FND_API.G_EXC_ERROR;
3149: END IF;
3150: END IF; /* code_release_level*/

Line 3154: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.INSERT_ROW' , 1 ) ;

3150: END IF; /* code_release_level*/
3151: -- notification framework end
3152:
3153: IF l_debug_level > 0 THEN
3154: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.INSERT_ROW' , 1 ) ;
3155: END IF;
3156:
3157: EXCEPTION
3158:

Line 3225: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

3221: l_new_header_adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
3222: l_index NUMBER;
3223:
3224: --
3225: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3226: --
3227: BEGIN
3228:
3229: IF l_debug_level > 0 THEN

Line 3230: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_UTIL.DELETE_ROW' , 1 ) ;

3226: --
3227: BEGIN
3228:
3229: IF l_debug_level > 0 THEN
3230: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_UTIL.DELETE_ROW' , 1 ) ;
3231: END IF;
3232:
3233: IF p_header_id <> FND_API.G_MISS_NUM
3234: THEN

Line 3241: oe_debug_pub.add( 'JFC: IN DELETE ROW , PRICE_ADJUSTMENT_ID= '|| L_ADJ.PRICE_ADJUSTMENT_ID ) ;

3237: --added for notification framework
3238: --check code release level first. Notification framework is at Pack H level
3239: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
3240: IF l_debug_level > 0 THEN
3241: oe_debug_pub.add( 'JFC: IN DELETE ROW , PRICE_ADJUSTMENT_ID= '|| L_ADJ.PRICE_ADJUSTMENT_ID ) ;
3242: END IF;
3243:
3244: /* Set the operation on the record so that globals are updated as well */
3245: l_new_header_adj_rec.operation := OE_GLOBALS.G_OPR_DELETE;

Line 3255: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_HEADER_ADJ_UTIL.DELETE_ROW IS: ' || L_RETURN_STATUS ) ;

3251: x_index => l_index,
3252: x_return_status => l_return_status);
3253:
3254: IF l_debug_level > 0 THEN
3255: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_HEADER_ADJ_UTIL.DELETE_ROW IS: ' || L_RETURN_STATUS ) ;
3256: END IF;
3257:
3258: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3259: IF l_debug_level > 0 THEN

Line 3260: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;

3256: END IF;
3257:
3258: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3259: IF l_debug_level > 0 THEN
3260: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
3261: END IF;
3262: IF l_debug_level > 0 THEN
3263: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.DELETE_ROW' , 1 ) ;
3264: END IF;

Line 3263: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.DELETE_ROW' , 1 ) ;

3259: IF l_debug_level > 0 THEN
3260: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
3261: END IF;
3262: IF l_debug_level > 0 THEN
3263: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.DELETE_ROW' , 1 ) ;
3264: END IF;
3265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3266: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3267: IF l_debug_level > 0 THEN

Line 3268: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_ADJ_UTIL.DELETE_ROW' ) ;

3264: END IF;
3265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3266: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3267: IF l_debug_level > 0 THEN
3268: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_ADJ_UTIL.DELETE_ROW' ) ;
3269: END IF;
3270: IF l_debug_level > 0 THEN
3271: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.DELETE_ROW' , 1 ) ;
3272: END IF;

Line 3271: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.DELETE_ROW' , 1 ) ;

3267: IF l_debug_level > 0 THEN
3268: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_ADJ_UTIL.DELETE_ROW' ) ;
3269: END IF;
3270: IF l_debug_level > 0 THEN
3271: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.DELETE_ROW' , 1 ) ;
3272: END IF;
3273: RAISE FND_API.G_EXC_ERROR;
3274: END IF;
3275: END IF; /*code_release_level*/

Line 3304: oe_debug_pub.add( 'JFC:IN DELETE ROW , HEADER_ID IS G_MISS_NUM , PRICE_ADJUSTMENT_ID= '|| P_PRICE_ADJUSTMENT_ID , 1 ) ;

3300: --added for notification framework
3301: --check code release level first. Notification framework is at Pack H level
3302: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
3303: IF l_debug_level > 0 THEN
3304: oe_debug_pub.add( 'JFC:IN DELETE ROW , HEADER_ID IS G_MISS_NUM , PRICE_ADJUSTMENT_ID= '|| P_PRICE_ADJUSTMENT_ID , 1 ) ;
3305: END IF;
3306:
3307: /* Set the operation on the record so that globals are updated as well */
3308: l_new_header_adj_rec.operation := OE_GLOBALS.G_OPR_DELETE;

Line 3316: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_HEADER_ADJ_UTIL.DELETE_ROW IS: ' || L_RETURN_STATUS ) ;

3312: p_hdr_adj_id => p_price_adjustment_id,
3313: x_index => l_index,
3314: x_return_status => l_return_status);
3315: IF l_debug_level > 0 THEN
3316: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_HEADER_ADJ_UTIL.DELETE_ROW IS: ' || L_RETURN_STATUS ) ;
3317: END IF;
3318:
3319: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3320: IF l_debug_level > 0 THEN

Line 3321: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;

3317: END IF;
3318:
3319: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3320: IF l_debug_level > 0 THEN
3321: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
3322: END IF;
3323: IF l_debug_level > 0 THEN
3324: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.DELETE_ROW' , 1 ) ;
3325: END IF;

Line 3324: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.DELETE_ROW' , 1 ) ;

3320: IF l_debug_level > 0 THEN
3321: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
3322: END IF;
3323: IF l_debug_level > 0 THEN
3324: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.DELETE_ROW' , 1 ) ;
3325: END IF;
3326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3327: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3328: IF l_debug_level > 0 THEN

Line 3329: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_ADJ_UTIL.DELETE_ROW' ) ;

3325: END IF;
3326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3327: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3328: IF l_debug_level > 0 THEN
3329: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_ADJ_UTIL.DELETE_ROW' ) ;
3330: END IF;
3331: IF l_debug_level > 0 THEN
3332: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.DELETE_ROW' , 1 ) ;
3333: END IF;

Line 3332: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.DELETE_ROW' , 1 ) ;

3328: IF l_debug_level > 0 THEN
3329: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_ADJ_UTIL.DELETE_ROW' ) ;
3330: END IF;
3331: IF l_debug_level > 0 THEN
3332: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.DELETE_ROW' , 1 ) ;
3333: END IF;
3334: RAISE FND_API.G_EXC_ERROR;
3335: END IF;
3336: END IF; /*code_release_level*/

Line 3372: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.DELETE_ROW' , 1 ) ;

3368: ;
3369: END IF;
3370:
3371: IF l_debug_level > 0 THEN
3372: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.DELETE_ROW' , 1 ) ;
3373: END IF;
3374:
3375: EXCEPTION
3376:

Line 3401: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

3397: )
3398: IS
3399: l_Header_Adj_Tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3400: --
3401: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3402: --
3403: BEGIN
3404: IF l_debug_level > 0 THEN
3405: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_UTIL.QUERY_ROW' , 1 ) ;

Line 3405: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_UTIL.QUERY_ROW' , 1 ) ;

3401: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3402: --
3403: BEGIN
3404: IF l_debug_level > 0 THEN
3405: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_UTIL.QUERY_ROW' , 1 ) ;
3406: END IF;
3407:
3408: Query_Rows
3409: ( p_price_adjustment_id => p_price_adjustment_id

Line 3415: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.QUERY_ROW' , 1 ) ;

3411: );
3412: x_Header_Adj_Rec := l_Header_Adj_Tbl(1);
3413:
3414: IF l_debug_level > 0 THEN
3415: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.QUERY_ROW' , 1 ) ;
3416: END IF;
3417:
3418: END Query_Row;
3419:

Line 3650: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

3646: l_implicit_rec l_header_adj_csr_p%ROWTYPE;
3647: l_entity NUMBER;
3648:
3649: --
3650: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3651: --
3652: BEGIN
3653:
3654: IF

Line 3874: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

3870: l_price_adjustment_id NUMBER;
3871: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
3872: l_lock_control NUMBER;
3873: --
3874: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3875: --
3876: BEGIN
3877:
3878: IF l_debug_level > 0 THEN

Line 3879: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_UTIL.LOCK_ROW' , 1 ) ;

3875: --
3876: BEGIN
3877:
3878: IF l_debug_level > 0 THEN
3879: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_UTIL.LOCK_ROW' , 1 ) ;
3880: END IF;
3881:
3882: SAVEPOINT Lock_Row;
3883:

Line 3902: oe_debug_pub.add( 'SELECTING FOR UPDATE.' , 1 ) ;

3898: WHERE price_adjustment_id = l_price_adjustment_id
3899: FOR UPDATE NOWAIT;
3900:
3901: IF l_debug_level > 0 THEN
3902: oe_debug_pub.add( 'SELECTING FOR UPDATE.' , 1 ) ;
3903: END IF;
3904:
3905: OE_Header_Adj_Util.Query_Row
3906: (p_price_adjustment_id => l_price_adjustment_id

Line 3911: oe_debug_pub.add( 'QUERIED LOCK_CONTROL: '|| P_X_HEADER_ADJ_REC.LOCK_CONTROL , 1 ) ;

3907: ,x_Header_Adj_rec => p_x_Header_Adj_rec
3908: );
3909:
3910: IF l_debug_level > 0 THEN
3911: oe_debug_pub.add( 'QUERIED LOCK_CONTROL: '|| P_X_HEADER_ADJ_REC.LOCK_CONTROL , 1 ) ;
3912: END IF;
3913:
3914: -- If lock_control is not passed(is null or missing), then return the locked record.
3915:

Line 3934: oe_debug_pub.add( 'COMPARE ' , 1 ) ;

3930: -- Row locked. If the whole record is passed, then
3931: -- Compare lock_control.
3932:
3933: IF l_debug_level > 0 THEN
3934: oe_debug_pub.add( 'COMPARE ' , 1 ) ;
3935: END IF;
3936:
3937: IF OE_GLOBALS.Equal(p_x_header_adj_rec.lock_control,
3938: l_lock_control)

Line 3944: oe_debug_pub.add( 'LOCKED ROW' , 1 ) ;

3940:
3941: -- Row has not changed. Set out parameter.
3942:
3943: IF l_debug_level > 0 THEN
3944: oe_debug_pub.add( 'LOCKED ROW' , 1 ) ;
3945: END IF;
3946:
3947: -- Set return status
3948:

Line 3956: oe_debug_pub.add( 'ROW CHANGED BY OTHER USER' , 1 ) ;

3952: ELSE
3953:
3954: -- Row has changed by another user.
3955: IF l_debug_level > 0 THEN
3956: oe_debug_pub.add( 'ROW CHANGED BY OTHER USER' , 1 ) ;
3957: END IF;
3958:
3959: x_return_status := FND_API.G_RET_STS_ERROR;
3960: p_x_header_adj_rec.return_status := FND_API.G_RET_STS_ERROR;

Line 3976: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.LOCK_ROW' , 1 ) ;

3972:
3973: END IF;
3974:
3975: IF l_debug_level > 0 THEN
3976: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.LOCK_ROW' , 1 ) ;
3977: END IF;
3978:
3979: EXCEPTION
3980:

Line 4042: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

4038: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4039: l_lock_control NUMBER;
4040:
4041: --
4042: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4043: --
4044: BEGIN
4045:
4046: IF l_debug_level > 0 THEN

Line 4047: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_UTIL.LOCK_ROWS.' , 1 ) ;

4043: --
4044: BEGIN
4045:
4046: IF l_debug_level > 0 THEN
4047: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_UTIL.LOCK_ROWS.' , 1 ) ;
4048: END IF;
4049:
4050: IF (p_price_adjustment_id IS NOT NULL AND
4051: p_price_adjustment_id <> FND_API.G_MISS_NUM) AND

Line 4135: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.LOCK_ROWS.' , 1 ) ;

4131: );
4132: END IF;
4133:
4134: IF l_debug_level > 0 THEN
4135: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.LOCK_ROWS.' , 1 ) ;
4136: END IF;
4137:
4138: END Lock_Rows;
4139:

Line 4149: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

4145: , p_delete_flag IN BOOLEAN DEFAULT FALSE
4146: ) IS
4147:
4148: --
4149: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4150: --
4151: BEGIN
4152:
4153: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4201: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

4197: ) RETURN OE_Order_PUB.Header_Adj_Val_Rec_Type
4198: IS
4199: l_Header_Adj_val_rec OE_Order_PUB.Header_Adj_Val_Rec_Type;
4200: --
4201: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4202: --
4203: BEGIN
4204:
4205: IF (p_Header_Adj_rec.discount_id IS NULL OR

Line 4228: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

4224: )
4225: IS
4226: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
4227: --
4228: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4229: --
4230: BEGIN
4231:
4232: -- initialize return_status.

Line 4286: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

4282: is
4283: l_adj_total NUMBER := 0;
4284: Is_fmt Boolean;
4285: --
4286: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4287: --
4288: BEGIN
4289:
4290: IF l_debug_level > 0 THEN

Line 4291: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_UTIL.GET_ADJ_TOTAL' , 1 ) ;

4287: --
4288: BEGIN
4289:
4290: IF l_debug_level > 0 THEN
4291: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_UTIL.GET_ADJ_TOTAL' , 1 ) ;
4292: END IF;
4293:
4294: IF (p_header_id IS NOT NULL AND
4295: NVL(p_header_id,-1)<>NVL(OE_ORDER_UTIL.G_Header_id,-10))

Line 4342: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.GET_ADJ_TOTAL' , 1 ) ;

4338:
4339: END IF;
4340:
4341: IF l_debug_level > 0 THEN
4342: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.GET_ADJ_TOTAL' , 1 ) ;
4343: END IF;
4344:
4345: RETURN l_adj_total;
4346:

Line 4373: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

4369: )
4370: is
4371: l_index number := 0;
4372: --
4373: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4374: --
4375: BEGIN
4376:
4377: IF l_debug_level > 0 THEN

Line 4378: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_UTIL.GET_LINE_ADJUSTMENTS' , 1 ) ;

4374: --
4375: BEGIN
4376:
4377: IF l_debug_level > 0 THEN
4378: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_UTIL.GET_LINE_ADJUSTMENTS' , 1 ) ;
4379: END IF;
4380:
4381: for adj_cur in
4382: ( SELECT opa.price_adjustment_id

Line 4446: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.GET_LINE_ADJUSTMENTS' , 1 ) ;

4442: end loop;
4443:
4444:
4445: IF l_debug_level > 0 THEN
4446: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.GET_LINE_ADJUSTMENTS' , 1 ) ;
4447: END IF;
4448:
4449:
4450: EXCEPTION

Line 4474: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

4470: p_old_header_adj_rec IN OE_ORDER_PUB.header_adj_rec_type := OE_ORDER_PUB.G_MISS_HEADER_ADJ_REC) IS
4471: /*local */
4472: l_return_status varchar2(30);
4473: --
4474: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4475: --
4476: BEGIN
4477:
4478: --11.5.10 Versioning/Audit Trail updates

Line 4491: OE_DEBUG_PUB.add('Reason code for versioning is missing', 1);

4487: OE_GLOBALS.G_REASON_COMMENTS := p_x_header_adj_rec.change_reason_text;
4488: OE_GLOBALS.G_CAPTURED_REASON := 'Y';
4489: ELSE
4490: IF l_debug_level > 0 THEN
4491: OE_DEBUG_PUB.add('Reason code for versioning is missing', 1);
4492: END IF;
4493: IF OE_GLOBALS.G_UI_FLAG THEN
4494: raise FND_API.G_EXC_ERROR;
4495: END IF;

Line 4500: oe_debug_pub.add('log versioning request',1);

4496: END IF;
4497: END IF;
4498:
4499: --log delayed request
4500: oe_debug_pub.add('log versioning request',1);
4501: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
4502: p_entity_id => p_x_header_adj_rec.header_id,
4503: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER_ADJ,
4504: p_requesting_entity_id => p_x_header_adj_rec.price_adjustment_id,

Line 4515: oe_debug_pub.add( 'CALL TO RECORD HEADER PRICE ADJ HISTORY' , 5 ) ;

4511: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG = 'Y' OR
4512: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG = 'Y' THEN
4513:
4514: IF l_debug_level > 0 THEN
4515: oe_debug_pub.add( 'CALL TO RECORD HEADER PRICE ADJ HISTORY' , 5 ) ;
4516: END IF;
4517: --11.5.10 Versioning/Audit Trail updates
4518: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
4519: OE_Versioning_Util.Capture_Audit_Info(p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_ADJ,

Line 4546: oe_debug_pub.add( 'INSERT INTO HEADER PRICE ADJUSTMENTS AUDIT HISTORY CAUSED ERROR' , 1 ) ;

4542: END IF;
4543:
4544: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
4545: IF l_debug_level > 0 THEN
4546: oe_debug_pub.add( 'INSERT INTO HEADER PRICE ADJUSTMENTS AUDIT HISTORY CAUSED ERROR' , 1 ) ;
4547: END IF;
4548: IF l_return_status = FND_API.G_RET_STS_ERROR then
4549: raise FND_API.G_EXC_ERROR;
4550: ELSE

Line 4599: oe_debug_pub.add('Entering OE_Header_Adj_Util.copy_header_adjustments ', 1);

4595: where header_id = p_from_header_id;
4596:
4597: BEGIN
4598:
4599: oe_debug_pub.add('Entering OE_Header_Adj_Util.copy_header_adjustments ', 1);
4600:
4601: /* Get Order category of the order FROM which adjustments are being copied. */
4602: for c1_rec in c1 loop
4603: l_from_order_category := c1_rec.order_category_code;

Line 4622: oe_debug_pub.add('inside copy header adj '||l_from_header_adj_tbl(i).list_line_type_code);

4618:
4619: i := l_from_header_adj_tbl.First;
4620: While i is not null Loop
4621:
4622: oe_debug_pub.add('inside copy header adj '||l_from_header_adj_tbl(i).list_line_type_code);
4623:
4624: /* If it's a Freight Charge then ... */
4625: If l_from_header_adj_tbl(i).list_line_type_code <> 'FREIGHT_CHARGE' and
4626: l_from_header_adj_tbl(i).list_line_type_code <> 'OM_CALLED_FREIGHT_RATES' and -- bug 4304163

Line 4677: oe_debug_pub.add('Before OE_Order_PVT.Process_order',3);

4673: l_control_rec.process := FALSE;
4674: l_control_rec.clear_api_cache := FALSE;
4675: l_control_rec.clear_api_requests := FALSE;
4676:
4677: oe_debug_pub.add('Before OE_Order_PVT.Process_order',3);
4678:
4679: -- OE_Globals.G_RECURSION_MODE := 'Y';
4680:
4681: -- Call OE_Order_PVT.Process_order

Line 4714: oe_debug_pub.add('Exiting OE_Header_Adj_Util.copy_header_adjustments ', 1);

4710: End If;
4711:
4712: End If;
4713:
4714: oe_debug_pub.add('Exiting OE_Header_Adj_Util.copy_header_adjustments ', 1);
4715:
4716: EXCEPTION
4717:
4718: WHEN FND_API.G_EXC_ERROR THEN

Line 4723: oe_debug_pub.add(G_PKG_NAME||':copy_header_adjuetments :'||SQLERRM);

4719: x_return_status := FND_API.G_RET_STS_ERROR;
4720:
4721: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4722: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4723: oe_debug_pub.add(G_PKG_NAME||':copy_header_adjuetments :'||SQLERRM);
4724:
4725: WHEN OTHERS THEN
4726: If FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) Then
4727: OE_MSG_PUB.Add_Exc_Msg

Line 4782: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

4778: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
4779: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
4780: --serla end
4781: --
4782: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4783: --
4784: BEGIN
4785:
4786: IF l_debug_level > 0 THEN

Line 4787: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_UTIL.COPY_FREIGHT_CHARGES' , 1 ) ;

4783: --
4784: BEGIN
4785:
4786: IF l_debug_level > 0 THEN
4787: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_UTIL.COPY_FREIGHT_CHARGES' , 1 ) ;
4788: END IF;
4789:
4790: /* Get Order category of the order FROM which charges are being copied. */
4791: for c1_rec in c1 loop

Line 4810: oe_debug_pub.add('Inside copy frieght charges .. '||l_from_header_adj_tbl(i).list_line_type_code);

4806:
4807: i := l_from_header_adj_tbl.First;
4808: While i is not null Loop
4809:
4810: oe_debug_pub.add('Inside copy frieght charges .. '||l_from_header_adj_tbl(i).list_line_type_code);
4811:
4812: l_copy_freight_charge := 'N';
4813:
4814: /* If it's a Freight Charge then ... */

Line 4915: oe_debug_pub.add( 'BEFORE OE_ORDER_PVT.PROCESS_ORDER' , 3 ) ;

4911: l_control_rec.clear_api_cache := FALSE;
4912: l_control_rec.clear_api_requests := FALSE;
4913:
4914: IF l_debug_level > 0 THEN
4915: oe_debug_pub.add( 'BEFORE OE_ORDER_PVT.PROCESS_ORDER' , 3 ) ;
4916: END IF;
4917:
4918: -- OE_Globals.G_RECURSION_MODE := 'Y';
4919:

Line 4960: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.COPY_FREIGHT_CHARGES' , 1 ) ;

4956:
4957: End If;
4958:
4959: IF l_debug_level > 0 THEN
4960: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.COPY_FREIGHT_CHARGES' , 1 ) ;
4961: END IF;
4962:
4963: EXCEPTION
4964:

Line 4971: oe_debug_pub.add( G_PKG_NAME||':COPY_FREIGHT_CHARGES:'||SQLERRM ) ;

4967:
4968: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4969: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4970: IF l_debug_level > 0 THEN
4971: oe_debug_pub.add( G_PKG_NAME||':COPY_FREIGHT_CHARGES:'||SQLERRM ) ;
4972: END IF;
4973:
4974: WHEN OTHERS THEN
4975: If FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) Then

Line 4996: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

4992: is
4993: l_adj_total NUMBER := 0;
4994: Is_fmt Boolean;
4995: --
4996: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4997: --
4998: BEGIN
4999:
5000: IF l_debug_level > 0 THEN

Line 5001: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_UTIL.GET_ADJ_TOTAL' , 1 ) ;

4997: --
4998: BEGIN
4999:
5000: IF l_debug_level > 0 THEN
5001: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_UTIL.GET_ADJ_TOTAL' , 1 ) ;
5002: END IF;
5003:
5004: IF (p_header_id IS NOT NULL AND
5005: NVL(p_header_id,-1)<>NVL(OE_ORDER_UTIL.G_Header_id,-10))

Line 5045: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.GET_ADJ_TOTAL' , 1 ) ;

5041:
5042: END IF;
5043:
5044: IF l_debug_level > 0 THEN
5045: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.GET_ADJ_TOTAL' , 1 ) ;
5046: END IF;
5047:
5048: RETURN l_adj_total;
5049:

Line 5085: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

5081: l_price_list_id NUMBER;
5082: l_currency_code VARCHAR2(15);
5083: l_pricing_date DATE;
5084: l_header_id NUMBER;
5085: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5086:
5087: BEGIN
5088: IF l_debug_level > 0 THEN
5089: oe_debug_pub.add('ENTERING OE_HEADER_ADJ_UTIL.GET_REC_ORDER_ADJ_TOTAL');

Line 5089: oe_debug_pub.add('ENTERING OE_HEADER_ADJ_UTIL.GET_REC_ORDER_ADJ_TOTAL');

5085: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5086:
5087: BEGIN
5088: IF l_debug_level > 0 THEN
5089: oe_debug_pub.add('ENTERING OE_HEADER_ADJ_UTIL.GET_REC_ORDER_ADJ_TOTAL');
5090: END IF;
5091:
5092: IF p_price_adjustment_id IS NULL OR
5093: p_charge_periodicity_code IS NULL THEN

Line 5108: oe_debug_pub.add('Exception while querying for the adjustment record : ' || SQLERRM);

5104: END IF;
5105: EXCEPTION
5106: WHEN OTHERS THEN
5107: IF l_debug_level > 0 THEN
5108: oe_debug_pub.add('Exception while querying for the adjustment record : ' || SQLERRM);
5109: END IF;
5110: RETURN NULL;
5111: END;
5112: ELSE

Line 5118: oe_debug_pub.add('l_header_id : ' || l_header_id);

5114: END IF;
5115: END IF;
5116:
5117: IF l_debug_level > 0 THEN
5118: oe_debug_pub.add('l_header_id : ' || l_header_id);
5119: oe_debug_pub.add('p_price_adjustment_id : ' || p_price_adjustment_id);
5120: oe_debug_pub.add('p_charge_periodicity_code : ' || p_charge_periodicity_code);
5121: END IF;
5122:

Line 5119: oe_debug_pub.add('p_price_adjustment_id : ' || p_price_adjustment_id);

5115: END IF;
5116:
5117: IF l_debug_level > 0 THEN
5118: oe_debug_pub.add('l_header_id : ' || l_header_id);
5119: oe_debug_pub.add('p_price_adjustment_id : ' || p_price_adjustment_id);
5120: oe_debug_pub.add('p_charge_periodicity_code : ' || p_charge_periodicity_code);
5121: END IF;
5122:
5123:

Line 5120: oe_debug_pub.add('p_charge_periodicity_code : ' || p_charge_periodicity_code);

5116:
5117: IF l_debug_level > 0 THEN
5118: oe_debug_pub.add('l_header_id : ' || l_header_id);
5119: oe_debug_pub.add('p_price_adjustment_id : ' || p_price_adjustment_id);
5120: oe_debug_pub.add('p_charge_periodicity_code : ' || p_charge_periodicity_code);
5121: END IF;
5122:
5123:
5124: SELECT nvl(sum(unit_list_price * ordered_quantity), 0) --bug5354658

Line 5132: oe_debug_pub.add('l_rec_list_price_total : ' || l_rec_list_price_total);

5128: AND charge_periodicity_code = p_charge_periodicity_code
5129: AND nvl(cancelled_flag,'N') ='N';
5130:
5131: IF l_debug_level > 0 THEN
5132: oe_debug_pub.add('l_rec_list_price_total : ' || l_rec_list_price_total);
5133: END IF;
5134:
5135: SELECT nvl(operand,0) * decode(list_line_type_code, 'DIS', -1, 'SUR', 1)
5136: INTO l_operand

Line 5143: oe_debug_pub.add('l_operand : ' || l_operand);

5139: AND line_id IS NULL
5140: AND arithmetic_operator = '%';
5141:
5142: IF l_debug_level > 0 THEN
5143: oe_debug_pub.add('l_operand : ' || l_operand);
5144: END IF;
5145:
5146: l_order_adj_total := l_rec_list_price_total * (l_operand / 100);
5147:

Line 5171: oe_debug_pub.add('Error in QP_UTIL_PUB.round_price. Unable to perform rounding');

5167: );
5168:
5169: IF l_order_adj_total IS NULL Then
5170: IF l_debug_level > 0 THEN
5171: oe_debug_pub.add('Error in QP_UTIL_PUB.round_price. Unable to perform rounding');
5172: END IF;
5173: --pricing has some errors retore the old adjusted_amount
5174: l_order_adj_total := l_rec_list_price_total * (l_operand / 100);
5175: END IF;

Line 5179: oe_debug_pub.add('Unable to query header to perform rounding:'||p_header_id);

5175: END IF;
5176: EXCEPTION
5177: WHEN NO_DATA_FOUND THEN
5178: IF l_debug_level > 0 THEN
5179: oe_debug_pub.add('Unable to query header to perform rounding:'||p_header_id);
5180: END IF;
5181: l_order_adj_total := 0;
5182: WHEN OTHERS THEN
5183: IF l_debug_level > 0 THEN

Line 5184: oe_debug_pub.add('OEXUHADB.pls'||SQLERRM);

5180: END IF;
5181: l_order_adj_total := 0;
5182: WHEN OTHERS THEN
5183: IF l_debug_level > 0 THEN
5184: oe_debug_pub.add('OEXUHADB.pls'||SQLERRM);
5185: END IF;
5186:
5187: l_order_adj_total := l_rec_list_price_total * (l_operand / 100);
5188: END;

Line 5193: oe_debug_pub.add('l_order_adj_total : ' || l_order_adj_total);

5189:
5190: END IF;
5191:
5192: IF l_debug_level > 0 THEN
5193: oe_debug_pub.add('l_order_adj_total : ' || l_order_adj_total);
5194: oe_debug_pub.add('EXITING OE_HEADER_ADJ_UTIL.GET_REC_ORDER_ADJ_TOTAL');
5195: END IF;
5196:
5197: Return l_order_adj_total;

Line 5194: oe_debug_pub.add('EXITING OE_HEADER_ADJ_UTIL.GET_REC_ORDER_ADJ_TOTAL');

5190: END IF;
5191:
5192: IF l_debug_level > 0 THEN
5193: oe_debug_pub.add('l_order_adj_total : ' || l_order_adj_total);
5194: oe_debug_pub.add('EXITING OE_HEADER_ADJ_UTIL.GET_REC_ORDER_ADJ_TOTAL');
5195: END IF;
5196:
5197: Return l_order_adj_total;
5198: