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 1726: oe_debug_pub.add( 'OEXUHADB: BEFORE QUERYING HEADER ID : '|| p_x_header_adj_rec.header_id ) ;

1722: IF (l_verify_payment_flag = 'Y') THEN
1723: --Start bug#5961160
1724: -- Query the Order Header
1725: IF l_debug_level > 0 THEN
1726: oe_debug_pub.add( 'OEXUHADB: BEFORE QUERYING HEADER ID : '|| p_x_header_adj_rec.header_id ) ;
1727: END IF;
1728:
1729: OE_Header_UTIL.Query_Row
1730: (p_header_id => p_x_header_adj_rec.header_id

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

1732: );
1733:
1734: IF l_debug_level > 0
1735: THEN
1736: OE_DEBUG_PUB.ADD('after query header ');
1737: OE_DEBUG_PUB.ADD(' ');
1738: OE_DEBUG_PUB.ADD('================================================');
1739: OE_DEBUG_PUB.ADD('Header ID = '|| l_header_rec.header_id );
1740: OE_DEBUG_PUB.ADD('order_category_code = '|| l_header_rec.order_category_code );

Line 1737: OE_DEBUG_PUB.ADD(' ');

1733:
1734: IF l_debug_level > 0
1735: THEN
1736: OE_DEBUG_PUB.ADD('after query header ');
1737: OE_DEBUG_PUB.ADD(' ');
1738: OE_DEBUG_PUB.ADD('================================================');
1739: OE_DEBUG_PUB.ADD('Header ID = '|| l_header_rec.header_id );
1740: OE_DEBUG_PUB.ADD('order_category_code = '|| l_header_rec.order_category_code );
1741: OE_DEBUG_PUB.ADD('Booked flag = '|| l_header_rec.booked_flag );

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

1734: IF l_debug_level > 0
1735: THEN
1736: OE_DEBUG_PUB.ADD('after query header ');
1737: OE_DEBUG_PUB.ADD(' ');
1738: OE_DEBUG_PUB.ADD('================================================');
1739: OE_DEBUG_PUB.ADD('Header ID = '|| l_header_rec.header_id );
1740: OE_DEBUG_PUB.ADD('order_category_code = '|| l_header_rec.order_category_code );
1741: OE_DEBUG_PUB.ADD('Booked flag = '|| l_header_rec.booked_flag );
1742: OE_DEBUG_PUB.ADD('Order number = '|| l_header_rec.order_number );

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

1735: THEN
1736: OE_DEBUG_PUB.ADD('after query header ');
1737: OE_DEBUG_PUB.ADD(' ');
1738: OE_DEBUG_PUB.ADD('================================================');
1739: OE_DEBUG_PUB.ADD('Header ID = '|| l_header_rec.header_id );
1740: OE_DEBUG_PUB.ADD('order_category_code = '|| l_header_rec.order_category_code );
1741: OE_DEBUG_PUB.ADD('Booked flag = '|| l_header_rec.booked_flag );
1742: OE_DEBUG_PUB.ADD('Order number = '|| l_header_rec.order_number );
1743: OE_DEBUG_PUB.ADD('payment_term_id = '|| l_header_rec.payment_term_id );

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

1736: OE_DEBUG_PUB.ADD('after query header ');
1737: OE_DEBUG_PUB.ADD(' ');
1738: OE_DEBUG_PUB.ADD('================================================');
1739: OE_DEBUG_PUB.ADD('Header ID = '|| l_header_rec.header_id );
1740: OE_DEBUG_PUB.ADD('order_category_code = '|| l_header_rec.order_category_code );
1741: OE_DEBUG_PUB.ADD('Booked flag = '|| l_header_rec.booked_flag );
1742: OE_DEBUG_PUB.ADD('Order number = '|| l_header_rec.order_number );
1743: OE_DEBUG_PUB.ADD('payment_term_id = '|| l_header_rec.payment_term_id );
1744: OE_DEBUG_PUB.ADD('order_type_id = '|| l_header_rec.order_type_id );

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

1737: OE_DEBUG_PUB.ADD(' ');
1738: OE_DEBUG_PUB.ADD('================================================');
1739: OE_DEBUG_PUB.ADD('Header ID = '|| l_header_rec.header_id );
1740: OE_DEBUG_PUB.ADD('order_category_code = '|| l_header_rec.order_category_code );
1741: OE_DEBUG_PUB.ADD('Booked flag = '|| l_header_rec.booked_flag );
1742: OE_DEBUG_PUB.ADD('Order number = '|| l_header_rec.order_number );
1743: OE_DEBUG_PUB.ADD('payment_term_id = '|| l_header_rec.payment_term_id );
1744: OE_DEBUG_PUB.ADD('order_type_id = '|| l_header_rec.order_type_id );
1745: OE_DEBUG_PUB.ADD(' ');

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

1738: OE_DEBUG_PUB.ADD('================================================');
1739: OE_DEBUG_PUB.ADD('Header ID = '|| l_header_rec.header_id );
1740: OE_DEBUG_PUB.ADD('order_category_code = '|| l_header_rec.order_category_code );
1741: OE_DEBUG_PUB.ADD('Booked flag = '|| l_header_rec.booked_flag );
1742: OE_DEBUG_PUB.ADD('Order number = '|| l_header_rec.order_number );
1743: OE_DEBUG_PUB.ADD('payment_term_id = '|| l_header_rec.payment_term_id );
1744: OE_DEBUG_PUB.ADD('order_type_id = '|| l_header_rec.order_type_id );
1745: OE_DEBUG_PUB.ADD(' ');
1746: OE_DEBUG_PUB.ADD('================================================');

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

1739: OE_DEBUG_PUB.ADD('Header ID = '|| l_header_rec.header_id );
1740: OE_DEBUG_PUB.ADD('order_category_code = '|| l_header_rec.order_category_code );
1741: OE_DEBUG_PUB.ADD('Booked flag = '|| l_header_rec.booked_flag );
1742: OE_DEBUG_PUB.ADD('Order number = '|| l_header_rec.order_number );
1743: OE_DEBUG_PUB.ADD('payment_term_id = '|| l_header_rec.payment_term_id );
1744: OE_DEBUG_PUB.ADD('order_type_id = '|| l_header_rec.order_type_id );
1745: OE_DEBUG_PUB.ADD(' ');
1746: OE_DEBUG_PUB.ADD('================================================');
1747: END IF;

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

1740: OE_DEBUG_PUB.ADD('order_category_code = '|| l_header_rec.order_category_code );
1741: OE_DEBUG_PUB.ADD('Booked flag = '|| l_header_rec.booked_flag );
1742: OE_DEBUG_PUB.ADD('Order number = '|| l_header_rec.order_number );
1743: OE_DEBUG_PUB.ADD('payment_term_id = '|| l_header_rec.payment_term_id );
1744: OE_DEBUG_PUB.ADD('order_type_id = '|| l_header_rec.order_type_id );
1745: OE_DEBUG_PUB.ADD(' ');
1746: OE_DEBUG_PUB.ADD('================================================');
1747: END IF;
1748:

Line 1745: OE_DEBUG_PUB.ADD(' ');

1741: OE_DEBUG_PUB.ADD('Booked flag = '|| l_header_rec.booked_flag );
1742: OE_DEBUG_PUB.ADD('Order number = '|| l_header_rec.order_number );
1743: OE_DEBUG_PUB.ADD('payment_term_id = '|| l_header_rec.payment_term_id );
1744: OE_DEBUG_PUB.ADD('order_type_id = '|| l_header_rec.order_type_id );
1745: OE_DEBUG_PUB.ADD(' ');
1746: OE_DEBUG_PUB.ADD('================================================');
1747: END IF;
1748:
1749: -- Call Which_Rule function to find out Which Rule to Apply

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

1742: OE_DEBUG_PUB.ADD('Order number = '|| l_header_rec.order_number );
1743: OE_DEBUG_PUB.ADD('payment_term_id = '|| l_header_rec.payment_term_id );
1744: OE_DEBUG_PUB.ADD('order_type_id = '|| l_header_rec.order_type_id );
1745: OE_DEBUG_PUB.ADD(' ');
1746: OE_DEBUG_PUB.ADD('================================================');
1747: END IF;
1748:
1749: -- Call Which_Rule function to find out Which Rule to Apply
1750: IF l_debug_level > 0 THEN

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

1747: END IF;
1748:
1749: -- Call Which_Rule function to find out Which Rule to Apply
1750: IF l_debug_level > 0 THEN
1751: oe_debug_pub.add( 'OEXUHADB: BEFORE CALLING WHICH RULE ' ) ;
1752: END IF;
1753:
1754: l_calling_action := OE_Verify_Payment_PUB.Which_Rule(p_header_id => p_x_header_adj_rec.header_id);
1755:

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

1753:
1754: l_calling_action := OE_Verify_Payment_PUB.Which_Rule(p_header_id => p_x_header_adj_rec.header_id);
1755:
1756: IF l_debug_level > 0 THEN
1757: oe_debug_pub.add( 'OEXUHADB: RULE TO BE USED IS : '|| l_calling_action ) ;
1758: END IF;
1759:
1760: IF l_debug_level > 0 THEN
1761: oe_debug_pub.add( 'OEXUHADB: BEFORE CHECKING IF THE RULE IS DEFINED OR NOT' ) ;

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

1757: oe_debug_pub.add( 'OEXUHADB: RULE TO BE USED IS : '|| l_calling_action ) ;
1758: END IF;
1759:
1760: IF l_debug_level > 0 THEN
1761: oe_debug_pub.add( 'OEXUHADB: BEFORE CHECKING IF THE RULE IS DEFINED OR NOT' ) ;
1762: END IF;
1763:
1764: l_rule_defined := OE_Verify_Payment_PUB.Check_Rule_Defined
1765: ( p_header_rec => l_header_rec

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

1766: , p_calling_action => l_calling_action
1767: ) ;
1768:
1769: IF l_debug_level > 0 THEN
1770: oe_debug_pub.add( 'OEXUHADB: OUT OF RULE DEFINED : '|| l_rule_defined);
1771: END IF;
1772:
1773: IF l_rule_defined = 'Y' THEN
1774: l_credit_check_rule_id := NULL ;

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

1774: l_credit_check_rule_id := NULL ;
1775:
1776: -- Check the Rule to Apply
1777: IF l_debug_level > 0 THEN
1778: oe_debug_pub.add( 'Before L_CREDIT_CHECK_RULE_ID => '|| l_credit_check_rule_id ) ;
1779: END IF;
1780:
1781: OE_CREDIT_CHECK_UTIL.Get_Credit_Check_Rule_ID
1782: ( p_calling_action => l_calling_action

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

1784: , x_credit_rule_id => l_credit_check_rule_id
1785: );
1786:
1787: IF l_debug_level > 0 THEN
1788: oe_debug_pub.add( 'After L_CREDIT_CHECK_RULE_ID => '|| l_credit_check_rule_id ) ;
1789: END IF;
1790:
1791: OE_CREDIT_CHECK_UTIL.GET_credit_check_rule
1792: ( p_credit_check_rule_id => l_credit_check_rule_id

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

1793: , x_credit_check_rules_rec => l_credit_check_rule_rec
1794: );
1795:
1796: IF l_debug_level > 0 THEN
1797: oe_debug_pub.add( 'OEXUHADB: INCL FREIGHT CHARGE FLAG : '|| l_credit_check_rule_rec.incl_freight_charges_flag);
1798: END IF;
1799:
1800: IF NVL(l_credit_check_rule_rec.incl_freight_charges_flag,'N') = 'Y' THEN
1801: -- Log a request for Verify Payment

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

1798: END IF;
1799:
1800: IF NVL(l_credit_check_rule_rec.incl_freight_charges_flag,'N') = 'Y' THEN
1801: -- Log a request for Verify Payment
1802: oe_debug_pub.add('OEXUHADB: Logging Delayed Request for Verify Payment',3);
1803: OE_delayed_requests_Pvt.log_request
1804: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1805: p_entity_id => p_x_header_adj_rec.header_id,
1806: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,

Line 1813: oe_debug_pub.ADD('OEXUHADB: Logging delayed request for Verify Payment CC Reversal',5);

1809: x_return_status => l_return_status);
1810: --CC Reversal ER#16014135 Start
1811: ELSIF OE_VERIFY_PAYMENT_PUB.Get_CC_Rev_Reauth_Code(p_x_header_adj_rec.header_id) IS NOT NULL THEN
1812: IF l_debug_level > 0 THEN
1813: oe_debug_pub.ADD('OEXUHADB: Logging delayed request for Verify Payment CC Reversal',5);
1814: END IF;
1815: oe_verify_payment_pub.G_credit_check_flag := 'N' ;
1816: OE_delayed_requests_Pvt.log_request
1817: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

Line 1829: oe_debug_pub.ADD('OEXUHADB: Logging delayed request for Verify Payment CC Reversal when rule not exists',5);

1825: --CC Reversal ER#16014135 Start
1826: ELSIF OE_VERIFY_PAYMENT_PUB.Get_CC_Rev_Reauth_Code(p_x_header_adj_rec.header_id) IS NOT NULL THEN
1827: -- if no rule defined .. Need to log verify payment request for processing authorization.
1828: IF l_debug_level > 0 THEN
1829: oe_debug_pub.ADD('OEXUHADB: Logging delayed request for Verify Payment CC Reversal when rule not exists',5);
1830: END IF;
1831: oe_verify_payment_pub.G_credit_check_flag := 'N' ;
1832: OE_delayed_requests_Pvt.log_request
1833: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

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

1846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1847: END IF;
1848:
1849: IF l_debug_level > 0 THEN
1850: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.APPLY_ATTRIBUTE_CHANGES' , 1 ) ;
1851: END IF;
1852:
1853: END Apply_Attribute_Changes;
1854:

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

1860: )
1861: IS
1862: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type := p_x_Header_Adj_rec;
1863: --
1864: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1865: --
1866: BEGIN
1867:
1868: IF l_debug_level > 0 THEN

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

1865: --
1866: BEGIN
1867:
1868: IF l_debug_level > 0 THEN
1869: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_UTIL.COMPLETE_RECORD' , 1 ) ;
1870: END IF;
1871:
1872: IF l_Header_Adj_rec.price_adjustment_id = FND_API.G_MISS_NUM THEN
1873: l_Header_Adj_rec.price_adjustment_id := p_old_Header_Adj_rec.price_adjustment_id;

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

2305: --12611888 end
2306:
2307:
2308: IF l_debug_level > 0 THEN
2309: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.COMPLETE_RECORD' , 1 ) ;
2310: END IF;
2311:
2312: -- RETURN l_Header_Adj_rec;
2313: p_x_Header_Adj_rec := l_Header_Adj_rec;

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

2321: )
2322: IS
2323: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type := p_x_Header_Adj_rec;
2324: --
2325: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2326: --
2327: BEGIN
2328:
2329: IF l_debug_level > 0 THEN

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

2326: --
2327: BEGIN
2328:
2329: IF l_debug_level > 0 THEN
2330: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_UTIL.CONVERT_MISS_TO_NULL' , 1 ) ;
2331: END IF;
2332:
2333: IF l_Header_Adj_rec.price_adjustment_id = FND_API.G_MISS_NUM THEN
2334: l_Header_Adj_rec.price_adjustment_id := NULL;

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

2732: END IF;
2733: --12611888 end
2734:
2735: IF l_debug_level > 0 THEN
2736: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.CONVERT_MISS_TO_NULL' , 1 ) ;
2737: END IF;
2738:
2739: -- RETURN l_Header_Adj_rec;
2740: p_x_Header_Adj_rec := l_Header_Adj_rec;

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

2753: l_index NUMBER;
2754: l_return_status VARCHAR2(1);
2755:
2756: --
2757: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2758: --
2759: BEGIN
2760:
2761: IF l_debug_level > 0 THEN

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

2758: --
2759: BEGIN
2760:
2761: IF l_debug_level > 0 THEN
2762: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_UTIL.UPDATE_ROW' , 1 ) ;
2763: END IF;
2764:
2765: -- increment lock_control by 1 whenever the record is updated
2766: SELECT lock_control

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

2775: -- check code release level first. Notification framework is at Pack H level
2776:
2777: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
2778: IF l_debug_level > 0 THEN
2779: oe_debug_pub.add( 'HDR_ADJ_ID= ' || P_HEADER_ADJ_REC.PRICE_ADJUSTMENT_ID ) ;
2780: END IF;
2781: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,
2782: p_Hdr_adj_rec =>p_header_adj_rec,
2783: p_hdr_adj_id => p_header_adj_rec.price_adjustment_id,

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

2784: x_index => l_index,
2785: x_return_status => l_return_status);
2786:
2787: IF l_debug_level > 0 THEN
2788: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_HEADER_ADJ_UTIL.UPDATE_ROE IS: ' || L_RETURN_STATUS ) ;
2789: END IF;
2790:
2791: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2792: IF l_debug_level > 0 THEN

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

2789: END IF;
2790:
2791: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2792: IF l_debug_level > 0 THEN
2793: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
2794: END IF;
2795: IF l_debug_level > 0 THEN
2796: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.UPDATE_ROW' , 1 ) ;
2797: END IF;

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

2792: IF l_debug_level > 0 THEN
2793: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
2794: END IF;
2795: IF l_debug_level > 0 THEN
2796: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.UPDATE_ROW' , 1 ) ;
2797: END IF;
2798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2799: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2800: IF l_debug_level > 0 THEN

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

2797: END IF;
2798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2799: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2800: IF l_debug_level > 0 THEN
2801: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_ADJ_UTIL.UPDATE_ROW' ) ;
2802: END IF;
2803: IF l_debug_level > 0 THEN
2804: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.UPDATE_ROW' , 1 ) ;
2805: END IF;

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

2800: IF l_debug_level > 0 THEN
2801: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_ADJ_UTIL.UPDATE_ROW' ) ;
2802: END IF;
2803: IF l_debug_level > 0 THEN
2804: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.UPDATE_ROW' , 1 ) ;
2805: END IF;
2806: RAISE FND_API.G_EXC_ERROR;
2807: END IF;
2808: END IF; /*code_release_level*/

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

2917: ;
2918:
2919: p_Header_Adj_rec.lock_control := l_lock_control;
2920: IF l_debug_level > 0 THEN
2921: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.UPDATE_ROW' , 1 ) ;
2922: END IF;
2923:
2924: EXCEPTION
2925:

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

2948: l_index NUMBER;
2949: l_return_status VARCHAR2(1);
2950:
2951: --
2952: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2953: --
2954: BEGIN
2955:
2956: IF l_debug_level > 0 THEN

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

2953: --
2954: BEGIN
2955:
2956: IF l_debug_level > 0 THEN
2957: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_UTIL.INSERT_ROW' , 1 ) ;
2958: END IF;
2959:
2960: INSERT INTO OE_PRICE_ADJUSTMENTS
2961: ( PRICE_ADJUSTMENT_ID

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

3182: x_index => l_index,
3183: x_return_status => l_return_status);
3184:
3185: IF l_debug_level > 0 THEN
3186: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_HEADER_ADJ_UTIL.INSERT_ROW IS: ' || L_RETURN_STATUS ) ;
3187: END IF;
3188: IF l_debug_level > 0 THEN
3189: oe_debug_pub.add( 'RETURNED INDEX IS: ' || L_INDEX , 1 ) ;
3190: END IF;

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

3185: IF l_debug_level > 0 THEN
3186: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_HEADER_ADJ_UTIL.INSERT_ROW IS: ' || L_RETURN_STATUS ) ;
3187: END IF;
3188: IF l_debug_level > 0 THEN
3189: oe_debug_pub.add( 'RETURNED INDEX IS: ' || L_INDEX , 1 ) ;
3190: END IF;
3191:
3192: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3193: IF l_debug_level > 0 THEN

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

3190: END IF;
3191:
3192: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3193: IF l_debug_level > 0 THEN
3194: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
3195: END IF;
3196: IF l_debug_level > 0 THEN
3197: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.INSERT_ROW' , 1 ) ;
3198: END IF;

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

3193: IF l_debug_level > 0 THEN
3194: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
3195: END IF;
3196: IF l_debug_level > 0 THEN
3197: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.INSERT_ROW' , 1 ) ;
3198: END IF;
3199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3200: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3201: IF l_debug_level > 0 THEN

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

3198: END IF;
3199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3200: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3201: IF l_debug_level > 0 THEN
3202: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_ADJ_UTIL.INSERT_ROW' ) ;
3203: END IF;
3204: IF l_debug_level > 0 THEN
3205: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.INSERT_ROW' , 1 ) ;
3206: END IF;

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

3201: IF l_debug_level > 0 THEN
3202: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_ADJ_UTIL.INSERT_ROW' ) ;
3203: END IF;
3204: IF l_debug_level > 0 THEN
3205: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.INSERT_ROW' , 1 ) ;
3206: END IF;
3207: RAISE FND_API.G_EXC_ERROR;
3208: END IF;
3209: END IF; /* code_release_level*/

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

3209: END IF; /* code_release_level*/
3210: -- notification framework end
3211:
3212: IF l_debug_level > 0 THEN
3213: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.INSERT_ROW' , 1 ) ;
3214: END IF;
3215:
3216: EXCEPTION
3217:

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

3280: l_new_header_adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
3281: l_index NUMBER;
3282:
3283: --
3284: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3285: --
3286: BEGIN
3287:
3288: IF l_debug_level > 0 THEN

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

3285: --
3286: BEGIN
3287:
3288: IF l_debug_level > 0 THEN
3289: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_UTIL.DELETE_ROW' , 1 ) ;
3290: END IF;
3291:
3292: IF p_header_id <> FND_API.G_MISS_NUM
3293: THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

3359: --added for notification framework
3360: --check code release level first. Notification framework is at Pack H level
3361: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
3362: IF l_debug_level > 0 THEN
3363: oe_debug_pub.add( 'JFC:IN DELETE ROW , HEADER_ID IS G_MISS_NUM , PRICE_ADJUSTMENT_ID= '|| P_PRICE_ADJUSTMENT_ID , 1 ) ;
3364: END IF;
3365:
3366: /* Set the operation on the record so that globals are updated as well */
3367: l_new_header_adj_rec.operation := OE_GLOBALS.G_OPR_DELETE;

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

3371: p_hdr_adj_id => p_price_adjustment_id,
3372: x_index => l_index,
3373: x_return_status => l_return_status);
3374: IF l_debug_level > 0 THEN
3375: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_HEADER_ADJ_UTIL.DELETE_ROW IS: ' || L_RETURN_STATUS ) ;
3376: END IF;
3377:
3378: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3379: IF l_debug_level > 0 THEN

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

3376: END IF;
3377:
3378: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3379: IF l_debug_level > 0 THEN
3380: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
3381: END IF;
3382: IF l_debug_level > 0 THEN
3383: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.DELETE_ROW' , 1 ) ;
3384: END IF;

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

3379: IF l_debug_level > 0 THEN
3380: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
3381: END IF;
3382: IF l_debug_level > 0 THEN
3383: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.DELETE_ROW' , 1 ) ;
3384: END IF;
3385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3386: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3387: IF l_debug_level > 0 THEN

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

3384: END IF;
3385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3386: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3387: IF l_debug_level > 0 THEN
3388: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_ADJ_UTIL.DELETE_ROW' ) ;
3389: END IF;
3390: IF l_debug_level > 0 THEN
3391: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.DELETE_ROW' , 1 ) ;
3392: END IF;

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

3387: IF l_debug_level > 0 THEN
3388: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_ADJ_UTIL.DELETE_ROW' ) ;
3389: END IF;
3390: IF l_debug_level > 0 THEN
3391: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.DELETE_ROW' , 1 ) ;
3392: END IF;
3393: RAISE FND_API.G_EXC_ERROR;
3394: END IF;
3395: END IF; /*code_release_level*/

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

3427: ;
3428: END IF;
3429:
3430: IF l_debug_level > 0 THEN
3431: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.DELETE_ROW' , 1 ) ;
3432: END IF;
3433:
3434: EXCEPTION
3435:

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

3456: )
3457: IS
3458: l_Header_Adj_Tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3459: --
3460: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3461: --
3462: BEGIN
3463: IF l_debug_level > 0 THEN
3464: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_UTIL.QUERY_ROW' , 1 ) ;

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

3460: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3461: --
3462: BEGIN
3463: IF l_debug_level > 0 THEN
3464: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_UTIL.QUERY_ROW' , 1 ) ;
3465: END IF;
3466:
3467: Query_Rows
3468: ( p_price_adjustment_id => p_price_adjustment_id

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

3470: );
3471: x_Header_Adj_Rec := l_Header_Adj_Tbl(1);
3472:
3473: IF l_debug_level > 0 THEN
3474: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.QUERY_ROW' , 1 ) ;
3475: END IF;
3476:
3477: END Query_Row;
3478:

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

3705: l_implicit_rec l_header_adj_csr_p%ROWTYPE;
3706: l_entity NUMBER;
3707:
3708: --
3709: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3710: --
3711: BEGIN
3712:
3713: IF

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

3929: l_price_adjustment_id NUMBER;
3930: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
3931: l_lock_control NUMBER;
3932: --
3933: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3934: --
3935: BEGIN
3936:
3937: IF l_debug_level > 0 THEN

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

3934: --
3935: BEGIN
3936:
3937: IF l_debug_level > 0 THEN
3938: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_UTIL.LOCK_ROW' , 1 ) ;
3939: END IF;
3940:
3941: SAVEPOINT Lock_Row;
3942:

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

3957: WHERE price_adjustment_id = l_price_adjustment_id
3958: FOR UPDATE NOWAIT;
3959:
3960: IF l_debug_level > 0 THEN
3961: oe_debug_pub.add( 'SELECTING FOR UPDATE.' , 1 ) ;
3962: END IF;
3963:
3964: OE_Header_Adj_Util.Query_Row
3965: (p_price_adjustment_id => l_price_adjustment_id

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

3966: ,x_Header_Adj_rec => p_x_Header_Adj_rec
3967: );
3968:
3969: IF l_debug_level > 0 THEN
3970: oe_debug_pub.add( 'QUERIED LOCK_CONTROL: '|| P_X_HEADER_ADJ_REC.LOCK_CONTROL , 1 ) ;
3971: END IF;
3972:
3973: -- If lock_control is not passed(is null or missing), then return the locked record.
3974:

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

3989: -- Row locked. If the whole record is passed, then
3990: -- Compare lock_control.
3991:
3992: IF l_debug_level > 0 THEN
3993: oe_debug_pub.add( 'COMPARE ' , 1 ) ;
3994: END IF;
3995:
3996: IF OE_GLOBALS.Equal(p_x_header_adj_rec.lock_control,
3997: l_lock_control)

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

3999:
4000: -- Row has not changed. Set out parameter.
4001:
4002: IF l_debug_level > 0 THEN
4003: oe_debug_pub.add( 'LOCKED ROW' , 1 ) ;
4004: END IF;
4005:
4006: -- Set return status
4007:

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

4011: ELSE
4012:
4013: -- Row has changed by another user.
4014: IF l_debug_level > 0 THEN
4015: oe_debug_pub.add( 'ROW CHANGED BY OTHER USER' , 1 ) ;
4016: END IF;
4017:
4018: x_return_status := FND_API.G_RET_STS_ERROR;
4019: p_x_header_adj_rec.return_status := FND_API.G_RET_STS_ERROR;

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

4031:
4032: END IF;
4033:
4034: IF l_debug_level > 0 THEN
4035: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.LOCK_ROW' , 1 ) ;
4036: END IF;
4037:
4038: EXCEPTION
4039:

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

4097: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4098: l_lock_control NUMBER;
4099:
4100: --
4101: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4102: --
4103: BEGIN
4104:
4105: IF l_debug_level > 0 THEN

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

4102: --
4103: BEGIN
4104:
4105: IF l_debug_level > 0 THEN
4106: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_UTIL.LOCK_ROWS.' , 1 ) ;
4107: END IF;
4108:
4109: IF (p_price_adjustment_id IS NOT NULL AND
4110: p_price_adjustment_id <> FND_API.G_MISS_NUM) AND

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

4190: );
4191: END IF;
4192:
4193: IF l_debug_level > 0 THEN
4194: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.LOCK_ROWS.' , 1 ) ;
4195: END IF;
4196:
4197: END Lock_Rows;
4198:

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

4204: , p_delete_flag IN BOOLEAN DEFAULT FALSE
4205: ) IS
4206:
4207: --
4208: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4209: --
4210: BEGIN
4211:
4212: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

4256: ) RETURN OE_Order_PUB.Header_Adj_Val_Rec_Type
4257: IS
4258: l_Header_Adj_val_rec OE_Order_PUB.Header_Adj_Val_Rec_Type;
4259: --
4260: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4261: --
4262: BEGIN
4263:
4264: IF (p_Header_Adj_rec.discount_id IS NULL OR

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

4283: )
4284: IS
4285: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
4286: --
4287: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4288: --
4289: BEGIN
4290:
4291: -- initialize return_status.

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

4341: is
4342: l_adj_total NUMBER := 0;
4343: Is_fmt Boolean;
4344: --
4345: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4346: --
4347: BEGIN
4348:
4349: IF l_debug_level > 0 THEN

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

4346: --
4347: BEGIN
4348:
4349: IF l_debug_level > 0 THEN
4350: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_UTIL.GET_ADJ_TOTAL' , 1 ) ;
4351: END IF;
4352:
4353: IF (p_header_id IS NOT NULL AND
4354: NVL(p_header_id,-1)<>NVL(OE_ORDER_UTIL.G_Header_id,-10))

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

4397:
4398: END IF;
4399:
4400: IF l_debug_level > 0 THEN
4401: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.GET_ADJ_TOTAL' , 1 ) ;
4402: END IF;
4403:
4404: RETURN l_adj_total;
4405:

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

4428: )
4429: is
4430: l_index number := 0;
4431: --
4432: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4433: --
4434: BEGIN
4435:
4436: IF l_debug_level > 0 THEN

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

4433: --
4434: BEGIN
4435:
4436: IF l_debug_level > 0 THEN
4437: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_UTIL.GET_LINE_ADJUSTMENTS' , 1 ) ;
4438: END IF;
4439:
4440: for adj_cur in
4441: ( SELECT opa.price_adjustment_id

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

4501: end loop;
4502:
4503:
4504: IF l_debug_level > 0 THEN
4505: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.GET_LINE_ADJUSTMENTS' , 1 ) ;
4506: END IF;
4507:
4508:
4509: EXCEPTION

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

4529: p_old_header_adj_rec IN OE_ORDER_PUB.header_adj_rec_type := OE_ORDER_PUB.G_MISS_HEADER_ADJ_REC) IS
4530: /*local */
4531: l_return_status varchar2(30);
4532: --
4533: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4534: --
4535: l_org_id NUMBER(15):=MO_GLOBAL.Get_Current_Org_Id; --TaxER
4536: l_current_event number := 0; --TaxER
4537: l_tax_calculation_event_code number := 0; --TaxER

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

4550: OE_GLOBALS.G_REASON_COMMENTS := p_x_header_adj_rec.change_reason_text;
4551: OE_GLOBALS.G_CAPTURED_REASON := 'Y';
4552: ELSE
4553: IF l_debug_level > 0 THEN
4554: OE_DEBUG_PUB.add('Reason code for versioning is missing', 1);
4555: END IF;
4556: IF OE_GLOBALS.G_UI_FLAG THEN
4557: raise FND_API.G_EXC_ERROR;
4558: END IF;

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

4559: END IF;
4560: END IF;
4561:
4562: --log delayed request
4563: oe_debug_pub.add('log versioning request',1);
4564: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
4565: p_entity_id => p_x_header_adj_rec.header_id,
4566: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER_ADJ,
4567: p_requesting_entity_id => p_x_header_adj_rec.price_adjustment_id,

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

4574: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG = 'Y' OR
4575: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG = 'Y' THEN
4576:
4577: IF l_debug_level > 0 THEN
4578: oe_debug_pub.add( 'CALL TO RECORD HEADER PRICE ADJ HISTORY' , 5 ) ;
4579: END IF;
4580: --11.5.10 Versioning/Audit Trail updates
4581: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
4582: OE_Versioning_Util.Capture_Audit_Info(p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_ADJ,

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

4605: END IF;
4606:
4607: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
4608: IF l_debug_level > 0 THEN
4609: oe_debug_pub.add( 'INSERT INTO HEADER PRICE ADJUSTMENTS AUDIT HISTORY CAUSED ERROR' , 1 ) ;
4610: END IF;
4611: IF l_return_status = FND_API.G_RET_STS_ERROR then
4612: raise FND_API.G_EXC_ERROR;
4613: ELSE

Line 4658: oe_debug_pub.add('OEXUHADB:Failed while trying to query up tax_calcualtion_event for order_type_id ');

4654: WHEN NO_DATA_FOUND THEN
4655: l_tax_calculation_event_code := 0;
4656: WHEN OTHERS THEN
4657: IF l_debug_level > 0 THEN
4658: oe_debug_pub.add('OEXUHADB:Failed while trying to query up tax_calcualtion_event for order_type_id ');
4659: END IF;
4660:
4661: RAISE;
4662: END;

Line 4678: oe_debug_pub.add('OEXUHADB:Tax Event Code :'||l_tax_calculation_event_code);

4674: l_current_event := 1; /* current event is booking or higher */
4675: END IF;
4676:
4677: IF l_debug_level > 0 THEN
4678: oe_debug_pub.add('OEXUHADB:Tax Event Code :'||l_tax_calculation_event_code);
4679: oe_debug_pub.add('OEXUHADB:Current Event :'||l_current_event);
4680: END IF;
4681:
4682:

Line 4679: oe_debug_pub.add('OEXUHADB:Current Event :'||l_current_event);

4675: END IF;
4676:
4677: IF l_debug_level > 0 THEN
4678: oe_debug_pub.add('OEXUHADB:Tax Event Code :'||l_tax_calculation_event_code);
4679: oe_debug_pub.add('OEXUHADB:Current Event :'||l_current_event);
4680: END IF;
4681:
4682:
4683: IF l_current_event >= l_tax_calculation_event_code THEN

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

4751: where header_id = p_from_header_id;
4752:
4753: BEGIN
4754:
4755: oe_debug_pub.add('Entering OE_Header_Adj_Util.copy_header_adjustments ', 1);
4756:
4757: /* Get Order category of the order FROM which adjustments are being copied. */
4758: for c1_rec in c1 loop
4759: l_from_order_category := c1_rec.order_category_code;

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

4774:
4775: i := l_from_header_adj_tbl.First;
4776: While i is not null Loop
4777:
4778: oe_debug_pub.add('inside copy header adj '||l_from_header_adj_tbl(i).list_line_type_code);
4779:
4780: /* If it's a Freight Charge then ... */
4781: If l_from_header_adj_tbl(i).list_line_type_code <> 'FREIGHT_CHARGE' and
4782: l_from_header_adj_tbl(i).list_line_type_code <> 'OM_CALLED_FREIGHT_RATES' and -- bug 4304163

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

4829: l_control_rec.process := FALSE;
4830: l_control_rec.clear_api_cache := FALSE;
4831: l_control_rec.clear_api_requests := FALSE;
4832:
4833: oe_debug_pub.add('Before OE_Order_PVT.Process_order',3);
4834:
4835: -- OE_Globals.G_RECURSION_MODE := 'Y';
4836:
4837: -- Call OE_Order_PVT.Process_order

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

4866: End If;
4867:
4868: End If;
4869:
4870: oe_debug_pub.add('Exiting OE_Header_Adj_Util.copy_header_adjustments ', 1);
4871:
4872: EXCEPTION
4873:
4874: WHEN FND_API.G_EXC_ERROR THEN

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

4875: x_return_status := FND_API.G_RET_STS_ERROR;
4876:
4877: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4878: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4879: oe_debug_pub.add(G_PKG_NAME||':copy_header_adjuetments :'||SQLERRM);
4880:
4881: WHEN OTHERS THEN
4882: If FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) Then
4883: OE_MSG_PUB.Add_Exc_Msg

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

4934: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
4935: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
4936: --serla end
4937: --
4938: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4939: --
4940: BEGIN
4941:
4942: IF l_debug_level > 0 THEN

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

4939: --
4940: BEGIN
4941:
4942: IF l_debug_level > 0 THEN
4943: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_UTIL.COPY_FREIGHT_CHARGES' , 1 ) ;
4944: END IF;
4945:
4946: /* Get Order category of the order FROM which charges are being copied. */
4947: for c1_rec in c1 loop

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

4962:
4963: i := l_from_header_adj_tbl.First;
4964: While i is not null Loop
4965:
4966: oe_debug_pub.add('Inside copy frieght charges .. '||l_from_header_adj_tbl(i).list_line_type_code);
4967:
4968: l_copy_freight_charge := 'N';
4969:
4970: /* If it's a Freight Charge then ... */

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

5067: l_control_rec.clear_api_cache := FALSE;
5068: l_control_rec.clear_api_requests := FALSE;
5069:
5070: IF l_debug_level > 0 THEN
5071: oe_debug_pub.add( 'BEFORE OE_ORDER_PVT.PROCESS_ORDER' , 3 ) ;
5072: END IF;
5073:
5074: -- OE_Globals.G_RECURSION_MODE := 'Y';
5075:

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

5112:
5113: End If;
5114:
5115: IF l_debug_level > 0 THEN
5116: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.COPY_FREIGHT_CHARGES' , 1 ) ;
5117: END IF;
5118:
5119: EXCEPTION
5120:

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

5123:
5124: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5126: IF l_debug_level > 0 THEN
5127: oe_debug_pub.add( G_PKG_NAME||':COPY_FREIGHT_CHARGES:'||SQLERRM ) ;
5128: END IF;
5129:
5130: WHEN OTHERS THEN
5131: If FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) Then

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

5148: is
5149: l_adj_total NUMBER := 0;
5150: Is_fmt Boolean;
5151: --
5152: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5153: --
5154: BEGIN
5155:
5156: IF l_debug_level > 0 THEN

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

5153: --
5154: BEGIN
5155:
5156: IF l_debug_level > 0 THEN
5157: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_UTIL.GET_ADJ_TOTAL' , 1 ) ;
5158: END IF;
5159:
5160: IF (p_header_id IS NOT NULL AND
5161: NVL(p_header_id,-1)<>NVL(OE_ORDER_UTIL.G_Header_id,-10))

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

5197:
5198: END IF;
5199:
5200: IF l_debug_level > 0 THEN
5201: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.GET_ADJ_TOTAL' , 1 ) ;
5202: END IF;
5203:
5204: RETURN l_adj_total;
5205:

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

5237: l_price_list_id NUMBER;
5238: l_currency_code VARCHAR2(15);
5239: l_pricing_date DATE;
5240: l_header_id NUMBER;
5241: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5242:
5243: BEGIN
5244: IF l_debug_level > 0 THEN
5245: oe_debug_pub.add('ENTERING OE_HEADER_ADJ_UTIL.GET_REC_ORDER_ADJ_TOTAL');

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

5241: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5242:
5243: BEGIN
5244: IF l_debug_level > 0 THEN
5245: oe_debug_pub.add('ENTERING OE_HEADER_ADJ_UTIL.GET_REC_ORDER_ADJ_TOTAL');
5246: END IF;
5247:
5248: IF p_price_adjustment_id IS NULL OR
5249: p_charge_periodicity_code IS NULL THEN

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

5260: END IF;
5261: EXCEPTION
5262: WHEN OTHERS THEN
5263: IF l_debug_level > 0 THEN
5264: oe_debug_pub.add('Exception while querying for the adjustment record : ' || SQLERRM);
5265: END IF;
5266: RETURN NULL;
5267: END;
5268: ELSE

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

5270: END IF;
5271: END IF;
5272:
5273: IF l_debug_level > 0 THEN
5274: oe_debug_pub.add('l_header_id : ' || l_header_id);
5275: oe_debug_pub.add('p_price_adjustment_id : ' || p_price_adjustment_id);
5276: oe_debug_pub.add('p_charge_periodicity_code : ' || p_charge_periodicity_code);
5277: END IF;
5278:

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

5271: END IF;
5272:
5273: IF l_debug_level > 0 THEN
5274: oe_debug_pub.add('l_header_id : ' || l_header_id);
5275: oe_debug_pub.add('p_price_adjustment_id : ' || p_price_adjustment_id);
5276: oe_debug_pub.add('p_charge_periodicity_code : ' || p_charge_periodicity_code);
5277: END IF;
5278:
5279:

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

5272:
5273: IF l_debug_level > 0 THEN
5274: oe_debug_pub.add('l_header_id : ' || l_header_id);
5275: oe_debug_pub.add('p_price_adjustment_id : ' || p_price_adjustment_id);
5276: oe_debug_pub.add('p_charge_periodicity_code : ' || p_charge_periodicity_code);
5277: END IF;
5278:
5279:
5280: SELECT nvl(sum(unit_list_price * ordered_quantity), 0) --bug5354658

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

5284: AND charge_periodicity_code = p_charge_periodicity_code
5285: AND nvl(cancelled_flag,'N') ='N';
5286:
5287: IF l_debug_level > 0 THEN
5288: oe_debug_pub.add('l_rec_list_price_total : ' || l_rec_list_price_total);
5289: END IF;
5290:
5291: SELECT nvl(operand,0) * decode(list_line_type_code, 'DIS', -1, 'SUR', 1)
5292: INTO l_operand

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

5295: AND line_id IS NULL
5296: AND arithmetic_operator = '%';
5297:
5298: IF l_debug_level > 0 THEN
5299: oe_debug_pub.add('l_operand : ' || l_operand);
5300: END IF;
5301:
5302: l_order_adj_total := l_rec_list_price_total * (l_operand / 100);
5303:

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

5323: );
5324:
5325: IF l_order_adj_total IS NULL Then
5326: IF l_debug_level > 0 THEN
5327: oe_debug_pub.add('Error in QP_UTIL_PUB.round_price. Unable to perform rounding');
5328: END IF;
5329: --pricing has some errors retore the old adjusted_amount
5330: l_order_adj_total := l_rec_list_price_total * (l_operand / 100);
5331: END IF;

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

5331: END IF;
5332: EXCEPTION
5333: WHEN NO_DATA_FOUND THEN
5334: IF l_debug_level > 0 THEN
5335: oe_debug_pub.add('Unable to query header to perform rounding:'||p_header_id);
5336: END IF;
5337: l_order_adj_total := 0;
5338: WHEN OTHERS THEN
5339: IF l_debug_level > 0 THEN

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

5336: END IF;
5337: l_order_adj_total := 0;
5338: WHEN OTHERS THEN
5339: IF l_debug_level > 0 THEN
5340: oe_debug_pub.add('OEXUHADB.pls'||SQLERRM);
5341: END IF;
5342:
5343: l_order_adj_total := l_rec_list_price_total * (l_operand / 100);
5344: END;

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

5345:
5346: END IF;
5347:
5348: IF l_debug_level > 0 THEN
5349: oe_debug_pub.add('l_order_adj_total : ' || l_order_adj_total);
5350: oe_debug_pub.add('EXITING OE_HEADER_ADJ_UTIL.GET_REC_ORDER_ADJ_TOTAL');
5351: END IF;
5352:
5353: Return l_order_adj_total;

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

5346: END IF;
5347:
5348: IF l_debug_level > 0 THEN
5349: oe_debug_pub.add('l_order_adj_total : ' || l_order_adj_total);
5350: oe_debug_pub.add('EXITING OE_HEADER_ADJ_UTIL.GET_REC_ORDER_ADJ_TOTAL');
5351: END IF;
5352:
5353: Return l_order_adj_total;
5354: