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_LINE_ADJ_UTIL dependencies on OE_DEBUG_PUB

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

163: cnt PLS_INTEGER:=0;
164: l_found1 Boolean := False;
165: l_found2 Boolean := False;
166: --
167: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
168: --
169: Begin
170: IF l_debug_level > 0 THEN
171: oe_debug_pub.add( 'ENTERING OE_LINE_ADJ_UTIL.APPEND_ASSOCIATIONS' , 1 ) ;

Line 171: oe_debug_pub.add( 'ENTERING OE_LINE_ADJ_UTIL.APPEND_ASSOCIATIONS' , 1 ) ;

167: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
168: --
169: Begin
170: IF l_debug_level > 0 THEN
171: oe_debug_pub.add( 'ENTERING OE_LINE_ADJ_UTIL.APPEND_ASSOCIATIONS' , 1 ) ;
172: END IF;
173: I:=p_pbh_tbl.first;
174: while I is not null loop
175: IF l_debug_level > 0 THEN

Line 176: oe_debug_pub.add( 'PBH'||P_PBH_TBL ( I ) , 1 ) ;

172: END IF;
173: I:=p_pbh_tbl.first;
174: while I is not null loop
175: IF l_debug_level > 0 THEN
176: oe_debug_pub.add( 'PBH'||P_PBH_TBL ( I ) , 1 ) ;
177: END IF;
178: I:=p_pbh_tbl.next(I);
179: end loop;
180:

Line 184: oe_debug_pub.add( 'LINE ADJ'||P_LINE_ADJ_TBL ( I ) .PRICE_ADJUSTMENT_ID||' '||P_LINE_ADJ_TBL ( I ) .LIST_LINE_TYPE_CODE , 1 ) ;

180:
181: I:=p_line_adj_tbl.first;
182: while I is not null loop
183: IF l_debug_level > 0 THEN
184: oe_debug_pub.add( 'LINE ADJ'||P_LINE_ADJ_TBL ( I ) .PRICE_ADJUSTMENT_ID||' '||P_LINE_ADJ_TBL ( I ) .LIST_LINE_TYPE_CODE , 1 ) ;
185: END IF;
186: I:=p_line_adj_tbl.next(I);
187: end loop;
188:

Line 214: oe_debug_pub.add( 'EXITING OE_LINE_ADJ_UTIL.APPEND_ASSOCIATIONS' , 1 ) ;

210: End Loop;
211: I:=p_pbh_tbl.next(I);
212: End Loop;
213: IF l_debug_level > 0 THEN
214: oe_debug_pub.add( 'EXITING OE_LINE_ADJ_UTIL.APPEND_ASSOCIATIONS' , 1 ) ;
215: END IF;
216: End;
217:
218: PROCEDURE API_Rec_To_Rowtype_Rec

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

339: )
340: iS
341:
342: --
343: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
344: --
345: BEGIN
346: IF l_debug_level > 0 THEN
347: oe_debug_pub.add( 'BEFORE ASSIGN COST_ID '||TO_CHAR ( P_RECORD.COST_ID ) , 1 ) ;

Line 347: oe_debug_pub.add( 'BEFORE ASSIGN COST_ID '||TO_CHAR ( P_RECORD.COST_ID ) , 1 ) ;

343: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
344: --
345: BEGIN
346: IF l_debug_level > 0 THEN
347: oe_debug_pub.add( 'BEFORE ASSIGN COST_ID '||TO_CHAR ( P_RECORD.COST_ID ) , 1 ) ;
348: END IF;
349:
350: x_api_rec.ATTRIBUTE1 := p_record.ATTRIBUTE1;
351: x_api_rec.ATTRIBUTE10 := p_record.ATTRIBUTE10;

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

471: l_index NUMBER :=0;
472: l_src_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
473: l_dep_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
474: --
475: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
476: --
477: BEGIN
478:
479: -- Load out record

Line 486: oe_debug_pub.add( 'ENTERING CLEAR_DEPENDENT_ATTR' ) ;

482:
483: -- If attr_id is missing compare old and new records and for
484: -- every changed attribute clear its dependent fields.
485: IF l_debug_level > 0 THEN
486: oe_debug_pub.add( 'ENTERING CLEAR_DEPENDENT_ATTR' ) ;
487: END IF;
488: IF p_attr_id = FND_API.G_MISS_NUM THEN
489:
490:

Line 1202: oe_debug_pub.add( 'LEAVING CLEAR_DEPENDENT_ATTR' ) ;

1198: END IF;
1199: END LOOP;
1200: END IF;
1201: IF l_debug_level > 0 THEN
1202: oe_debug_pub.add( 'LEAVING CLEAR_DEPENDENT_ATTR' ) ;
1203: END IF;
1204: END Clear_Dependent_Attr;
1205:
1206:

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

1215: l_old_Line_Adj_rec OE_AK_Line_PRCADJS_V%ROWTYPE ;
1216: l_initial_Line_Adj_rec OE_AK_Line_PRCADJS_V%ROWTYPE;
1217:
1218: --
1219: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1220: --
1221: BEGIN
1222:
1223: -- Load out record

Line 1225: oe_debug_pub.add( 'ENTERING CLEAR_DEPENDENT_ATTR' ) ;

1221: BEGIN
1222:
1223: -- Load out record
1224: IF l_debug_level > 0 THEN
1225: oe_debug_pub.add( 'ENTERING CLEAR_DEPENDENT_ATTR' ) ;
1226: END IF;
1227: API_Rec_To_Rowtype_Rec(p_x_Line_Adj_rec , l_Line_Adj_rec);
1228: API_Rec_To_Rowtype_Rec(p_Old_Line_Adj_rec , l_Old_Line_Adj_rec);
1229: l_Initial_Line_Adj_rec := l_Line_Adj_rec;

Line 1240: oe_debug_pub.add( 'LEAVING CLEAR_DEPENDENT_ATTR' ) ;

1236: );
1237:
1238: Rowtype_Rec_To_API_Rec(l_Line_Adj_rec,p_x_Line_Adj_Rec);
1239: IF l_debug_level > 0 THEN
1240: oe_debug_pub.add( 'LEAVING CLEAR_DEPENDENT_ATTR' ) ;
1241: END IF;
1242: END Clear_Dependent_Attr;
1243:
1244: -- Procedure Apply_Attribute_Changes

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

1267: l_credit_check_rule_id NUMBER;
1268: l_credit_check_rule_rec OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type ;
1269:
1270: --
1271: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1272: --
1273: BEGIN
1274:
1275: -- Load out record

Line 1279: oe_debug_pub.add( 'ENTERING OE_LINE_ADJ_UTIL.APPLY ATTRIBUTE CHANGES' ) ;

1275: -- Load out record
1276:
1277: --x_Line_Adj_rec := p_Line_Adj_rec;
1278: IF l_debug_level > 0 THEN
1279: oe_debug_pub.add( 'ENTERING OE_LINE_ADJ_UTIL.APPLY ATTRIBUTE CHANGES' ) ;
1280: END IF;
1281: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.adjusted_amount,p_old_Line_Adj_rec.adjusted_amount)
1282: THEN
1283: NULL;

Line 1757: oe_debug_pub.add( 'RECURSION_MODE'||OE_GLOBALS.G_RECURSION_MODE||' PRICING:'||OE_GLOBALS.G_PRICING_RECURSION , 1 ) ;

1753: NULL;
1754: END IF;
1755:
1756: IF l_debug_level > 0 THEN
1757: oe_debug_pub.add( 'RECURSION_MODE'||OE_GLOBALS.G_RECURSION_MODE||' PRICING:'||OE_GLOBALS.G_PRICING_RECURSION , 1 ) ;
1758: oe_debug_pub.add( 'HEADER_ID'||P_X_LINE_ADJ_REC.HEADER_ID , 1 ) ;
1759: oe_debug_pub.add( 'LINE_ID'||P_X_LINE_ADJ_REC.LINE_ID , 1 ) ;
1760: END IF;
1761: if (l_price_flag) then

Line 1758: oe_debug_pub.add( 'HEADER_ID'||P_X_LINE_ADJ_REC.HEADER_ID , 1 ) ;

1754: END IF;
1755:
1756: IF l_debug_level > 0 THEN
1757: oe_debug_pub.add( 'RECURSION_MODE'||OE_GLOBALS.G_RECURSION_MODE||' PRICING:'||OE_GLOBALS.G_PRICING_RECURSION , 1 ) ;
1758: oe_debug_pub.add( 'HEADER_ID'||P_X_LINE_ADJ_REC.HEADER_ID , 1 ) ;
1759: oe_debug_pub.add( 'LINE_ID'||P_X_LINE_ADJ_REC.LINE_ID , 1 ) ;
1760: END IF;
1761: if (l_price_flag) then
1762: IF l_debug_level > 0 THEN

Line 1759: oe_debug_pub.add( 'LINE_ID'||P_X_LINE_ADJ_REC.LINE_ID , 1 ) ;

1755:
1756: IF l_debug_level > 0 THEN
1757: oe_debug_pub.add( 'RECURSION_MODE'||OE_GLOBALS.G_RECURSION_MODE||' PRICING:'||OE_GLOBALS.G_PRICING_RECURSION , 1 ) ;
1758: oe_debug_pub.add( 'HEADER_ID'||P_X_LINE_ADJ_REC.HEADER_ID , 1 ) ;
1759: oe_debug_pub.add( 'LINE_ID'||P_X_LINE_ADJ_REC.LINE_ID , 1 ) ;
1760: END IF;
1761: if (l_price_flag) then
1762: IF l_debug_level > 0 THEN
1763: oe_debug_pub.add( 'PRICE FLAG:Y' , 1 ) ;

Line 1763: oe_debug_pub.add( 'PRICE FLAG:Y' , 1 ) ;

1759: oe_debug_pub.add( 'LINE_ID'||P_X_LINE_ADJ_REC.LINE_ID , 1 ) ;
1760: END IF;
1761: if (l_price_flag) then
1762: IF l_debug_level > 0 THEN
1763: oe_debug_pub.add( 'PRICE FLAG:Y' , 1 ) ;
1764: END IF;
1765: else
1766: IF l_debug_level > 0 THEN
1767: oe_debug_pub.add( 'PRICE FLAG:N' , 1 ) ;

Line 1767: oe_debug_pub.add( 'PRICE FLAG:N' , 1 ) ;

1763: oe_debug_pub.add( 'PRICE FLAG:Y' , 1 ) ;
1764: END IF;
1765: else
1766: IF l_debug_level > 0 THEN
1767: oe_debug_pub.add( 'PRICE FLAG:N' , 1 ) ;
1768: END IF;
1769: end if;
1770:
1771: -- bug 2378843: don't log request when g_pricing_recursion is set

Line 1786: oe_debug_pub.add( ' UI FLAG IS TRUE , LOGGING UI DELAYED REQUEST FOR ADJ' ) ;

1782: */
1783: If OE_GLOBALS.G_UI_FLAG and nvl(p_x_Line_adj_rec.automatic_flag,'Y') = 'N' Then
1784: --we need to log different delayed request for manual adjustments.
1785: IF l_debug_level > 0 THEN
1786: oe_debug_pub.add( ' UI FLAG IS TRUE , LOGGING UI DELAYED REQUEST FOR ADJ' ) ;
1787: END IF;
1788: oe_delayed_requests_pvt.log_request(
1789: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1790: p_entity_id => p_x_Line_adj_rec.Line_id,

Line 1854: oe_debug_pub.add( 'OEXULADB: BEFORE QUERYING HEADER ID : '|| p_x_line_adj_rec.header_id ) ;

1850: IF (l_verify_payment_flag = 'Y') THEN
1851: --Start bug# 5961160
1852: -- Query the Order Header
1853: IF l_debug_level > 0 THEN
1854: oe_debug_pub.add( 'OEXULADB: BEFORE QUERYING HEADER ID : '|| p_x_line_adj_rec.header_id ) ;
1855: END IF;
1856:
1857: OE_Header_UTIL.Query_Row
1858: (p_header_id => p_x_line_adj_rec.header_id

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

1860: );
1861:
1862: IF l_debug_level > 0
1863: THEN
1864: OE_DEBUG_PUB.ADD('after query header ');
1865: OE_DEBUG_PUB.ADD(' ');
1866: OE_DEBUG_PUB.ADD('================================================');
1867: OE_DEBUG_PUB.ADD('Header ID = '|| l_header_rec.header_id );
1868: OE_DEBUG_PUB.ADD('order_category_code = '|| l_header_rec.order_category_code );

Line 1865: OE_DEBUG_PUB.ADD(' ');

1861:
1862: IF l_debug_level > 0
1863: THEN
1864: OE_DEBUG_PUB.ADD('after query header ');
1865: OE_DEBUG_PUB.ADD(' ');
1866: OE_DEBUG_PUB.ADD('================================================');
1867: OE_DEBUG_PUB.ADD('Header ID = '|| l_header_rec.header_id );
1868: OE_DEBUG_PUB.ADD('order_category_code = '|| l_header_rec.order_category_code );
1869: OE_DEBUG_PUB.ADD('Booked flag = '|| l_header_rec.booked_flag );

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

1862: IF l_debug_level > 0
1863: THEN
1864: OE_DEBUG_PUB.ADD('after query header ');
1865: OE_DEBUG_PUB.ADD(' ');
1866: OE_DEBUG_PUB.ADD('================================================');
1867: OE_DEBUG_PUB.ADD('Header ID = '|| l_header_rec.header_id );
1868: OE_DEBUG_PUB.ADD('order_category_code = '|| l_header_rec.order_category_code );
1869: OE_DEBUG_PUB.ADD('Booked flag = '|| l_header_rec.booked_flag );
1870: OE_DEBUG_PUB.ADD('Order number = '|| l_header_rec.order_number );

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

1863: THEN
1864: OE_DEBUG_PUB.ADD('after query header ');
1865: OE_DEBUG_PUB.ADD(' ');
1866: OE_DEBUG_PUB.ADD('================================================');
1867: OE_DEBUG_PUB.ADD('Header ID = '|| l_header_rec.header_id );
1868: OE_DEBUG_PUB.ADD('order_category_code = '|| l_header_rec.order_category_code );
1869: OE_DEBUG_PUB.ADD('Booked flag = '|| l_header_rec.booked_flag );
1870: OE_DEBUG_PUB.ADD('Order number = '|| l_header_rec.order_number );
1871: OE_DEBUG_PUB.ADD('payment_term_id = '|| l_header_rec.payment_term_id );

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

1864: OE_DEBUG_PUB.ADD('after query header ');
1865: OE_DEBUG_PUB.ADD(' ');
1866: OE_DEBUG_PUB.ADD('================================================');
1867: OE_DEBUG_PUB.ADD('Header ID = '|| l_header_rec.header_id );
1868: OE_DEBUG_PUB.ADD('order_category_code = '|| l_header_rec.order_category_code );
1869: OE_DEBUG_PUB.ADD('Booked flag = '|| l_header_rec.booked_flag );
1870: OE_DEBUG_PUB.ADD('Order number = '|| l_header_rec.order_number );
1871: OE_DEBUG_PUB.ADD('payment_term_id = '|| l_header_rec.payment_term_id );
1872: OE_DEBUG_PUB.ADD('order_type_id = '|| l_header_rec.order_type_id );

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

1865: OE_DEBUG_PUB.ADD(' ');
1866: OE_DEBUG_PUB.ADD('================================================');
1867: OE_DEBUG_PUB.ADD('Header ID = '|| l_header_rec.header_id );
1868: OE_DEBUG_PUB.ADD('order_category_code = '|| l_header_rec.order_category_code );
1869: OE_DEBUG_PUB.ADD('Booked flag = '|| l_header_rec.booked_flag );
1870: OE_DEBUG_PUB.ADD('Order number = '|| l_header_rec.order_number );
1871: OE_DEBUG_PUB.ADD('payment_term_id = '|| l_header_rec.payment_term_id );
1872: OE_DEBUG_PUB.ADD('order_type_id = '|| l_header_rec.order_type_id );
1873: OE_DEBUG_PUB.ADD(' ');

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

1866: OE_DEBUG_PUB.ADD('================================================');
1867: OE_DEBUG_PUB.ADD('Header ID = '|| l_header_rec.header_id );
1868: OE_DEBUG_PUB.ADD('order_category_code = '|| l_header_rec.order_category_code );
1869: OE_DEBUG_PUB.ADD('Booked flag = '|| l_header_rec.booked_flag );
1870: OE_DEBUG_PUB.ADD('Order number = '|| l_header_rec.order_number );
1871: OE_DEBUG_PUB.ADD('payment_term_id = '|| l_header_rec.payment_term_id );
1872: OE_DEBUG_PUB.ADD('order_type_id = '|| l_header_rec.order_type_id );
1873: OE_DEBUG_PUB.ADD(' ');
1874: OE_DEBUG_PUB.ADD('================================================');

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

1867: OE_DEBUG_PUB.ADD('Header ID = '|| l_header_rec.header_id );
1868: OE_DEBUG_PUB.ADD('order_category_code = '|| l_header_rec.order_category_code );
1869: OE_DEBUG_PUB.ADD('Booked flag = '|| l_header_rec.booked_flag );
1870: OE_DEBUG_PUB.ADD('Order number = '|| l_header_rec.order_number );
1871: OE_DEBUG_PUB.ADD('payment_term_id = '|| l_header_rec.payment_term_id );
1872: OE_DEBUG_PUB.ADD('order_type_id = '|| l_header_rec.order_type_id );
1873: OE_DEBUG_PUB.ADD(' ');
1874: OE_DEBUG_PUB.ADD('================================================');
1875: END IF;

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

1868: OE_DEBUG_PUB.ADD('order_category_code = '|| l_header_rec.order_category_code );
1869: OE_DEBUG_PUB.ADD('Booked flag = '|| l_header_rec.booked_flag );
1870: OE_DEBUG_PUB.ADD('Order number = '|| l_header_rec.order_number );
1871: OE_DEBUG_PUB.ADD('payment_term_id = '|| l_header_rec.payment_term_id );
1872: OE_DEBUG_PUB.ADD('order_type_id = '|| l_header_rec.order_type_id );
1873: OE_DEBUG_PUB.ADD(' ');
1874: OE_DEBUG_PUB.ADD('================================================');
1875: END IF;
1876:

Line 1873: OE_DEBUG_PUB.ADD(' ');

1869: OE_DEBUG_PUB.ADD('Booked flag = '|| l_header_rec.booked_flag );
1870: OE_DEBUG_PUB.ADD('Order number = '|| l_header_rec.order_number );
1871: OE_DEBUG_PUB.ADD('payment_term_id = '|| l_header_rec.payment_term_id );
1872: OE_DEBUG_PUB.ADD('order_type_id = '|| l_header_rec.order_type_id );
1873: OE_DEBUG_PUB.ADD(' ');
1874: OE_DEBUG_PUB.ADD('================================================');
1875: END IF;
1876:
1877: -- Call Which_Rule function to find out Which Rule to Apply

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

1870: OE_DEBUG_PUB.ADD('Order number = '|| l_header_rec.order_number );
1871: OE_DEBUG_PUB.ADD('payment_term_id = '|| l_header_rec.payment_term_id );
1872: OE_DEBUG_PUB.ADD('order_type_id = '|| l_header_rec.order_type_id );
1873: OE_DEBUG_PUB.ADD(' ');
1874: OE_DEBUG_PUB.ADD('================================================');
1875: END IF;
1876:
1877: -- Call Which_Rule function to find out Which Rule to Apply
1878: IF l_debug_level > 0 THEN

Line 1879: oe_debug_pub.add( 'OEXULADB: BEFORE CALLING WHICH RULE ' ) ;

1875: END IF;
1876:
1877: -- Call Which_Rule function to find out Which Rule to Apply
1878: IF l_debug_level > 0 THEN
1879: oe_debug_pub.add( 'OEXULADB: BEFORE CALLING WHICH RULE ' ) ;
1880: END IF;
1881:
1882: l_calling_action := OE_Verify_Payment_PUB.Which_Rule(p_header_id => p_x_line_adj_rec.header_id);
1883:

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

1881:
1882: l_calling_action := OE_Verify_Payment_PUB.Which_Rule(p_header_id => p_x_line_adj_rec.header_id);
1883:
1884: IF l_debug_level > 0 THEN
1885: oe_debug_pub.add( 'OEXULADB: RULE TO BE USED IS : '|| l_calling_action ) ;
1886: END IF;
1887:
1888: IF l_debug_level > 0 THEN
1889: oe_debug_pub.add( 'OEXULADB: BEFORE CHECKING IF THE RULE IS DEFINED OR NOT' ) ;

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

1885: oe_debug_pub.add( 'OEXULADB: RULE TO BE USED IS : '|| l_calling_action ) ;
1886: END IF;
1887:
1888: IF l_debug_level > 0 THEN
1889: oe_debug_pub.add( 'OEXULADB: BEFORE CHECKING IF THE RULE IS DEFINED OR NOT' ) ;
1890: END IF;
1891:
1892: l_rule_defined := OE_Verify_Payment_PUB.Check_Rule_Defined
1893: ( p_header_rec => l_header_rec

Line 1898: oe_debug_pub.add( 'OEXULADB: OUT OF RULE DEFINED : '|| l_rule_defined);

1894: , p_calling_action => l_calling_action
1895: ) ;
1896:
1897: IF l_debug_level > 0 THEN
1898: oe_debug_pub.add( 'OEXULADB: OUT OF RULE DEFINED : '|| l_rule_defined);
1899: END IF;
1900:
1901: IF l_rule_defined = 'Y' THEN
1902: l_credit_check_rule_id := NULL ;

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

1902: l_credit_check_rule_id := NULL ;
1903:
1904: -- Check the Rule to Apply
1905: IF l_debug_level > 0 THEN
1906: oe_debug_pub.add( 'Before L_CREDIT_CHECK_RULE_ID => '|| l_credit_check_rule_id ) ;
1907: END IF;
1908:
1909: OE_CREDIT_CHECK_UTIL.Get_Credit_Check_Rule_ID
1910: ( p_calling_action => l_calling_action

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

1912: , x_credit_rule_id => l_credit_check_rule_id
1913: );
1914:
1915: IF l_debug_level > 0 THEN
1916: oe_debug_pub.add( 'After L_CREDIT_CHECK_RULE_ID => '|| l_credit_check_rule_id ) ;
1917: END IF;
1918:
1919: OE_CREDIT_CHECK_UTIL.GET_credit_check_rule
1920: ( p_credit_check_rule_id => l_credit_check_rule_id

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

1921: , x_credit_check_rules_rec => l_credit_check_rule_rec
1922: );
1923:
1924: IF l_debug_level > 0 THEN
1925: oe_debug_pub.add( 'OEXULADB: INCL FREIGHT CHARGE FLAG : '|| l_credit_check_rule_rec.incl_freight_charges_flag);
1926: END IF;
1927:
1928: IF NVL(l_credit_check_rule_rec.incl_freight_charges_flag,'N') = 'Y' THEN
1929: BEGIN

Line 1938: oe_debug_pub.ADD('OEXULADB: Logging delayed request for Verify Payment');

1934: EXCEPTION WHEN NO_DATA_FOUND THEN
1935: null;
1936: END;
1937: IF l_line_category_code <> 'RETURN' THEN
1938: oe_debug_pub.ADD('OEXULADB: Logging delayed request for Verify Payment');
1939: OE_delayed_requests_Pvt.log_request
1940: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1941: p_entity_id => p_x_line_adj_rec.header_id,
1942: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

Line 1957: oe_debug_pub.add( 'OE_LINE_ADJ_UTIL.LEAVING APPLY_ATTRIBUTE_CHANGES' ) ;

1953: THEN
1954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1955: END IF;
1956: IF l_debug_level > 0 THEN
1957: oe_debug_pub.add( 'OE_LINE_ADJ_UTIL.LEAVING APPLY_ATTRIBUTE_CHANGES' ) ;
1958: END IF;
1959: END Apply_Attribute_Changes;
1960:
1961: -- Procedure Complete_Record

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

2418: )
2419: IS
2420: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type := p_x_Line_Adj_rec;
2421: --
2422: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2423: --
2424: BEGIN
2425:
2426: IF l_Line_Adj_rec.adjusted_amount = FND_API.G_MISS_NUM THEN

Line 2833: oe_debug_pub.add( 'EXITING OE_LINE_ADJ_UTIL.CONVERT_MISS_TO_NULL' , 1 ) ;

2829:
2830: -- end eBTax changes
2831:
2832: IF l_debug_level > 0 THEN
2833: oe_debug_pub.add( 'EXITING OE_LINE_ADJ_UTIL.CONVERT_MISS_TO_NULL' , 1 ) ;
2834: END IF;
2835:
2836: -- RETURN l_Line_Adj_rec;
2837: p_x_Line_Adj_rec := l_Line_Adj_rec;

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

2847: l_lock_control NUMBER;
2848: l_index NUMBER;
2849: l_return_status VARCHAR2(1);
2850: --
2851: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2852: --
2853: BEGIN
2854: IF l_debug_level > 0 THEN
2855: oe_debug_pub.add( 'ENTERING OE_LINE_ADJ_UTIL.UPDATE_ROW' , 1 ) ;

Line 2855: oe_debug_pub.add( 'ENTERING OE_LINE_ADJ_UTIL.UPDATE_ROW' , 1 ) ;

2851: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2852: --
2853: BEGIN
2854: IF l_debug_level > 0 THEN
2855: oe_debug_pub.add( 'ENTERING OE_LINE_ADJ_UTIL.UPDATE_ROW' , 1 ) ;
2856: END IF;
2857:
2858: -- increment lock_control by 1 whenever the record is updated
2859: SELECT lock_control

Line 2870: oe_debug_pub.add( 'JFC: LINE_PRICE_ADJ_ID=' || P_LINE_ADJ_REC.PRICE_ADJUSTMENT_ID ) ;

2866: --calling notification framework to update global picture
2867: --check code release level first. Notification framework is at Pack H level
2868: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
2869: IF l_debug_level > 0 THEN
2870: oe_debug_pub.add( 'JFC: LINE_PRICE_ADJ_ID=' || P_LINE_ADJ_REC.PRICE_ADJUSTMENT_ID ) ;
2871: END IF;
2872: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,
2873: p_Line_adj_rec =>p_line_adj_rec,
2874: p_line_adj_id => p_line_adj_rec.price_adjustment_id,

Line 2878: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_LINE_ADJ_UTIL.UPDATE_ROW IS: ' || L_RETURN_STATUS ) ;

2874: p_line_adj_id => p_line_adj_rec.price_adjustment_id,
2875: x_index => l_index,
2876: x_return_status => l_return_status);
2877: IF l_debug_level > 0 THEN
2878: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_LINE_ADJ_UTIL.UPDATE_ROW IS: ' || L_RETURN_STATUS ) ;
2879: END IF;
2880: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2881: IF l_debug_level > 0 THEN
2882: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;

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

2878: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_LINE_ADJ_UTIL.UPDATE_ROW IS: ' || L_RETURN_STATUS ) ;
2879: END IF;
2880: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2881: IF l_debug_level > 0 THEN
2882: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
2883: oe_debug_pub.add( 'EXITING OE_LINE_ADJ_UTIL.UPDATE_ROW' , 1 ) ;
2884: END IF;
2885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2886: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 2883: oe_debug_pub.add( 'EXITING OE_LINE_ADJ_UTIL.UPDATE_ROW' , 1 ) ;

2879: END IF;
2880: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2881: IF l_debug_level > 0 THEN
2882: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
2883: oe_debug_pub.add( 'EXITING OE_LINE_ADJ_UTIL.UPDATE_ROW' , 1 ) ;
2884: END IF;
2885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2886: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2887: IF l_debug_level > 0 THEN

Line 2888: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_ADJ_UTIL.UPDATE_ROW' ) ;

2884: END IF;
2885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2886: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2887: IF l_debug_level > 0 THEN
2888: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_ADJ_UTIL.UPDATE_ROW' ) ;
2889: oe_debug_pub.add( 'EXITING OE_LINE_ADJ_UTIL.UPDATE_ROW' , 1 ) ;
2890: END IF;
2891: RAISE FND_API.G_EXC_ERROR;
2892: END IF;

Line 2889: oe_debug_pub.add( 'EXITING OE_LINE_ADJ_UTIL.UPDATE_ROW' , 1 ) ;

2885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2886: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2887: IF l_debug_level > 0 THEN
2888: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_ADJ_UTIL.UPDATE_ROW' ) ;
2889: oe_debug_pub.add( 'EXITING OE_LINE_ADJ_UTIL.UPDATE_ROW' , 1 ) ;
2890: END IF;
2891: RAISE FND_API.G_EXC_ERROR;
2892: END IF;
2893: END IF; /* code_release_level*/

Line 3008: oe_debug_pub.add( 'EXITING OE_LINE_ADJ_UTIL.UPDATE_ROW.' , 1 ) ;

3004: ;
3005:
3006: p_Line_Adj_rec.lock_control := l_lock_control;
3007: IF l_debug_level > 0 THEN
3008: oe_debug_pub.add( 'EXITING OE_LINE_ADJ_UTIL.UPDATE_ROW.' , 1 ) ;
3009: END IF;
3010:
3011: EXCEPTION
3012:

Line 3023: oe_debug_pub.add( 'EXCEPTION IN UPDATE_ROW'||SQLERRM , 2 ) ;

3019: , 'Update_Row'
3020: );
3021: END IF;
3022: IF l_debug_level > 0 THEN
3023: oe_debug_pub.add( 'EXCEPTION IN UPDATE_ROW'||SQLERRM , 2 ) ;
3024: END IF;
3025: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3026:
3027: END Update_Row;

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

3060: l_lock_control NUMBER := 1;
3061: l_index NUMBER;
3062: l_return_status VARCHAR2(1);
3063: --
3064: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3065: --
3066: BEGIN
3067: IF l_debug_level > 0 THEN
3068: oe_debug_pub.add( 'ENTERING OE_LINE_ADJ_UTIL.INSERT_ROW' , 1 ) ;

Line 3068: oe_debug_pub.add( 'ENTERING OE_LINE_ADJ_UTIL.INSERT_ROW' , 1 ) ;

3064: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3065: --
3066: BEGIN
3067: IF l_debug_level > 0 THEN
3068: oe_debug_pub.add( 'ENTERING OE_LINE_ADJ_UTIL.INSERT_ROW' , 1 ) ;
3069: oe_debug_pub.add(' list_line_id insert:'|| p_Line_Adj_rec.list_line_id||
3070: ' ,operand insert:'||p_line_adj_rec.operand||
3071: ' ,operand pqty insert:'||p_line_adj_rec.operand_per_pqty||
3072: ' ,applied_flag insert:'||p_line_adj_rec.applied_flag||

Line 3069: oe_debug_pub.add(' list_line_id insert:'|| p_Line_Adj_rec.list_line_id||

3065: --
3066: BEGIN
3067: IF l_debug_level > 0 THEN
3068: oe_debug_pub.add( 'ENTERING OE_LINE_ADJ_UTIL.INSERT_ROW' , 1 ) ;
3069: oe_debug_pub.add(' list_line_id insert:'|| p_Line_Adj_rec.list_line_id||
3070: ' ,operand insert:'||p_line_adj_rec.operand||
3071: ' ,operand pqty insert:'||p_line_adj_rec.operand_per_pqty||
3072: ' ,applied_flag insert:'||p_line_adj_rec.applied_flag||
3073: ' ,list_line_type_code:'||p_line_adj_rec.list_line_type_code||

Line 3310: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_LINE_ADJ_UTIL.INSERT_RO IS: ' || L_RETURN_STATUS ) ;

3306: p_line_adj_id => p_line_adj_rec.price_adjustment_id,
3307: x_index => l_index,
3308: x_return_status => l_return_status);
3309: IF l_debug_level > 0 THEN
3310: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_LINE_ADJ_UTIL.INSERT_RO IS: ' || L_RETURN_STATUS ) ;
3311: oe_debug_pub.add( 'RETURNED INDEX IS: ' || L_INDEX , 1 ) ;
3312: END IF;
3313:
3314: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

3307: x_index => l_index,
3308: x_return_status => l_return_status);
3309: IF l_debug_level > 0 THEN
3310: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_LINE_ADJ_UTIL.INSERT_RO IS: ' || L_RETURN_STATUS ) ;
3311: oe_debug_pub.add( 'RETURNED INDEX IS: ' || L_INDEX , 1 ) ;
3312: END IF;
3313:
3314: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3315: IF l_debug_level > 0 THEN

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

3312: END IF;
3313:
3314: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3315: IF l_debug_level > 0 THEN
3316: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
3317: oe_debug_pub.add( 'EXITING OE_LINE_ADJ_UTIL.INSERT_ROW' , 1 ) ;
3318: END IF;
3319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3320: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 3317: oe_debug_pub.add( 'EXITING OE_LINE_ADJ_UTIL.INSERT_ROW' , 1 ) ;

3313:
3314: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3315: IF l_debug_level > 0 THEN
3316: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
3317: oe_debug_pub.add( 'EXITING OE_LINE_ADJ_UTIL.INSERT_ROW' , 1 ) ;
3318: END IF;
3319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3320: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3321: IF l_debug_level > 0 THEN

Line 3322: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_ADJ_UTIL.INSERT_ROW' ) ;

3318: END IF;
3319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3320: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3321: IF l_debug_level > 0 THEN
3322: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_ADJ_UTIL.INSERT_ROW' ) ;
3323: oe_debug_pub.add( 'EXITINGOE_LINE_ADJ_UTIL.INSERT_ROW' , 1 ) ;
3324: END IF;
3325: RAISE FND_API.G_EXC_ERROR;
3326: END IF;

Line 3323: oe_debug_pub.add( 'EXITINGOE_LINE_ADJ_UTIL.INSERT_ROW' , 1 ) ;

3319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3320: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3321: IF l_debug_level > 0 THEN
3322: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_ADJ_UTIL.INSERT_ROW' ) ;
3323: oe_debug_pub.add( 'EXITINGOE_LINE_ADJ_UTIL.INSERT_ROW' , 1 ) ;
3324: END IF;
3325: RAISE FND_API.G_EXC_ERROR;
3326: END IF;
3327: END IF; /*code_release_level*/

Line 3331: oe_debug_pub.add( 'EXITING OE_LINE_ADJ_UTIL.INSERT_ROW.' , 1 ) ;

3327: END IF; /*code_release_level*/
3328: -- notification framework end
3329:
3330: IF l_debug_level > 0 THEN
3331: oe_debug_pub.add( 'EXITING OE_LINE_ADJ_UTIL.INSERT_ROW.' , 1 ) ;
3332: END IF;
3333:
3334: EXCEPTION
3335:

Line 3339: oe_debug_pub.add( G_PKG_NAME||':INSER_ROW:'||SQLERRM ) ;

3335:
3336: WHEN DUP_VAL_ON_INDEX Then
3337: Reset_Sequence;
3338: IF l_debug_level > 0 THEN
3339: oe_debug_pub.add( G_PKG_NAME||':INSER_ROW:'||SQLERRM ) ;
3340: END IF;
3341: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3342: THEN
3343: OE_MSG_PUB.Add_Exc_Msg

Line 3355: oe_debug_pub.add( G_PKG_NAME||':INSER_ROW:'||SQLERRM ) ;

3351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3352:
3353: WHEN OTHERS THEN
3354: IF l_debug_level > 0 THEN
3355: oe_debug_pub.add( G_PKG_NAME||':INSER_ROW:'||SQLERRM ) ;
3356: END IF;
3357: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3358: THEN
3359: OE_MSG_PUB.Add_Exc_Msg

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

3387: l_new_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3388: l_index NUMBER;
3389:
3390: --
3391: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3392: --
3393: BEGIN
3394: IF l_debug_level > 0 THEN
3395: oe_debug_pub.add( 'ENTERING OE_LINE_ADJ_UTIL.DELETE_ROW' ) ;

Line 3395: oe_debug_pub.add( 'ENTERING OE_LINE_ADJ_UTIL.DELETE_ROW' ) ;

3391: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3392: --
3393: BEGIN
3394: IF l_debug_level > 0 THEN
3395: oe_debug_pub.add( 'ENTERING OE_LINE_ADJ_UTIL.DELETE_ROW' ) ;
3396: END IF;
3397: IF p_line_id <> FND_API.G_MISS_NUM
3398: THEN
3399: IF l_debug_level > 0 THEN

Line 3400: oe_debug_pub.add( ' P_LINE_ID <> G_MISS_NUM' ) ;

3396: END IF;
3397: IF p_line_id <> FND_API.G_MISS_NUM
3398: THEN
3399: IF l_debug_level > 0 THEN
3400: oe_debug_pub.add( ' P_LINE_ID <> G_MISS_NUM' ) ;
3401: END IF;
3402: FOR l_adj IN price_adj LOOP
3403:
3404: --added for notification framework

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

3404: --added for notification framework
3405: --check code release level first. Notification framework is at Pack H level
3406: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
3407: IF l_debug_level > 0 THEN
3408: oe_debug_pub.add( 'JFC: IN DELETE ROW , PRICE_ADJUSTMENT_ID'||L_ADJ.PRICE_ADJUSTMENT_ID , 1 ) ;
3409: END IF;
3410: /* Set the operation on the record so that globals are updated as well */
3411: l_new_line_adj_rec.operation := OE_GLOBALS.G_OPR_DELETE;
3412: l_new_line_adj_rec.price_adjustment_id := l_adj.price_adjustment_id;

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

3415: p_line_adj_id => l_adj.price_adjustment_id,
3416: x_index => l_index,
3417: x_return_status => l_return_status);
3418: IF l_debug_level > 0 THEN
3419: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_LINE_ADJ_UTIL.DELETE_ROW IS: ' || L_RETURN_STATUS ) ;
3420: END IF;
3421:
3422: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3423: IF l_debug_level > 0 THEN

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

3420: END IF;
3421:
3422: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3423: IF l_debug_level > 0 THEN
3424: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
3425: oe_debug_pub.add( 'EXITING OE_LINE_ADJ_UTIL.DELETE_ROW' , 1 ) ;
3426: END IF;
3427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3428: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 3425: oe_debug_pub.add( 'EXITING OE_LINE_ADJ_UTIL.DELETE_ROW' , 1 ) ;

3421:
3422: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3423: IF l_debug_level > 0 THEN
3424: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
3425: oe_debug_pub.add( 'EXITING OE_LINE_ADJ_UTIL.DELETE_ROW' , 1 ) ;
3426: END IF;
3427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3428: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3429: IF l_debug_level > 0 THEN

Line 3430: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_ADJ_UTIL.DELETE_ROW' ) ;

3426: END IF;
3427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3428: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3429: IF l_debug_level > 0 THEN
3430: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_ADJ_UTIL.DELETE_ROW' ) ;
3431: oe_debug_pub.add( 'EXITING OE_LINE_ADJ_UTIL.DELETE_ROW' , 1 ) ;
3432: END IF;
3433: RAISE FND_API.G_EXC_ERROR;
3434: END IF;

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

3427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3428: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3429: IF l_debug_level > 0 THEN
3430: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_ADJ_UTIL.DELETE_ROW' ) ;
3431: oe_debug_pub.add( 'EXITING OE_LINE_ADJ_UTIL.DELETE_ROW' , 1 ) ;
3432: END IF;
3433: RAISE FND_API.G_EXC_ERROR;
3434: END IF;
3435: END IF; /*code_release_level*/

Line 3457: oe_debug_pub.add( ' P_LINE_ID = G_MISS_NUM' ) ;

3453: DELETE FROM OE_PRICE_ADJUSTMENTS
3454: WHERE LINE_ID = p_line_id;
3455: ELSE
3456: IF l_debug_level > 0 THEN
3457: oe_debug_pub.add( ' P_LINE_ID = G_MISS_NUM' ) ;
3458: END IF;
3459:
3460: --added for notification framework
3461: --check code release level first. Notification framework is at Pack H level

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

3460: --added for notification framework
3461: --check code release level first. Notification framework is at Pack H level
3462: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
3463: IF l_debug_level > 0 THEN
3464: oe_debug_pub.add( 'JFC: IN DELETE ROW , LINE_ID IS G_MISS_NUM , PRICE_ADJUSTMENT_ID'||P_PRICE_ADJUSTMENT_ID , 1 ) ;
3465: END IF;
3466: /* Set the operation on the record so that globals are updated as well */
3467: l_new_line_adj_rec.operation := OE_GLOBALS.G_OPR_DELETE;
3468: l_new_line_adj_rec.price_adjustment_id := p_price_adjustment_id;

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

3471: p_line_adj_id => p_price_adjustment_id,
3472: x_index => l_index,
3473: x_return_status => l_return_status);
3474: IF l_debug_level > 0 THEN
3475: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_LINE_ADJ_UTIL.DELETE_ROW IS: ' || L_RETURN_STATUS ) ;
3476: END IF;
3477: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3478: IF l_debug_level > 0 THEN
3479: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;

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

3475: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_LINE_ADJ_UTIL.DELETE_ROW IS: ' || L_RETURN_STATUS ) ;
3476: END IF;
3477: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3478: IF l_debug_level > 0 THEN
3479: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
3480: oe_debug_pub.add( 'EXITING OE_LINE_ADJ_UTIL.DELETE_ROW' , 1 ) ;
3481: END IF;
3482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3483: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 3480: oe_debug_pub.add( 'EXITING OE_LINE_ADJ_UTIL.DELETE_ROW' , 1 ) ;

3476: END IF;
3477: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3478: IF l_debug_level > 0 THEN
3479: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
3480: oe_debug_pub.add( 'EXITING OE_LINE_ADJ_UTIL.DELETE_ROW' , 1 ) ;
3481: END IF;
3482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3483: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3484: IF l_debug_level > 0 THEN

Line 3485: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_ADJ_UTIL.DELETE_ROW' ) ;

3481: END IF;
3482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3483: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3484: IF l_debug_level > 0 THEN
3485: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_ADJ_UTIL.DELETE_ROW' ) ;
3486: oe_debug_pub.add( 'EXITING OE_LINE_ADJ_UTIL.DELETE_ROW' , 1 ) ;
3487: END IF;
3488: RAISE FND_API.G_EXC_ERROR;
3489: END IF;

Line 3486: oe_debug_pub.add( 'EXITING OE_LINE_ADJ_UTIL.DELETE_ROW' , 1 ) ;

3482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3483: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3484: IF l_debug_level > 0 THEN
3485: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_ADJ_UTIL.DELETE_ROW' ) ;
3486: oe_debug_pub.add( 'EXITING OE_LINE_ADJ_UTIL.DELETE_ROW' , 1 ) ;
3487: END IF;
3488: RAISE FND_API.G_EXC_ERROR;
3489: END IF;
3490: END IF; /*code_release_level*/

Line 3518: oe_debug_pub.add('pviprana: Deleted '|| SQL%ROWCOUNT || ' Child Lines');

3514: WHERE ASSOCS.PRICE_ADJUSTMENT_ID=PARENT.PRICE_ADJUSTMENT_ID
3515: AND PARENT.PRICE_ADJUSTMENT_ID=p_price_adjustment_id
3516: AND PARENT.LIST_LINE_TYPE_CODE='PBH');
3517: IF l_debug_level > 0 THEN
3518: oe_debug_pub.add('pviprana: Deleted '|| SQL%ROWCOUNT || ' Child Lines');
3519: END IF;
3520: --bug3528335 end
3521:
3522:

Line 3529: oe_debug_pub.add( 'LEAVING OE_LINE_ADJ_UTIL.DELETE_ROW' ) ;

3525: WHERE PRICE_ADJUSTMENT_ID = p_price_adjustment_id;
3526:
3527: END IF;
3528: IF l_debug_level > 0 THEN
3529: oe_debug_pub.add( 'LEAVING OE_LINE_ADJ_UTIL.DELETE_ROW' ) ;
3530: END IF;
3531: EXCEPTION
3532:
3533: WHEN OTHERS THEN

Line 3535: oe_debug_pub.add( G_PKG_NAME||':DELETE_ROW:'||SQLERRM ) ;

3531: EXCEPTION
3532:
3533: WHEN OTHERS THEN
3534: IF l_debug_level > 0 THEN
3535: oe_debug_pub.add( G_PKG_NAME||':DELETE_ROW:'||SQLERRM ) ;
3536: END IF;
3537: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3538: THEN
3539: OE_MSG_PUB.Add_Exc_Msg

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

4033:
4034: l_implicit_rec l_line_adj_csr%ROWTYPE;
4035: l_entity NUMBER;
4036: --
4037: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4038: --
4039: BEGIN
4040:
4041: IF

Line 4253: oe_debug_pub.add( G_PKG_NAME||':QUERY_ROW:'||SQLERRM ) ;

4249: EXCEPTION
4250:
4251: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4252: IF l_debug_level > 0 THEN
4253: oe_debug_pub.add( G_PKG_NAME||':QUERY_ROW:'||SQLERRM ) ;
4254: END IF;
4255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4256:
4257: WHEN OTHERS THEN

Line 4259: oe_debug_pub.add( G_PKG_NAME||':QUERY_ROW:'||SQLERRM ) ;

4255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4256:
4257: WHEN OTHERS THEN
4258: IF l_debug_level > 0 THEN
4259: oe_debug_pub.add( G_PKG_NAME||':QUERY_ROW:'||SQLERRM ) ;
4260: END IF;
4261: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4262: THEN
4263: OE_MSG_PUB.Add_Exc_Msg

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

4286: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
4287: l_lock_control NUMBER;
4288:
4289: --
4290: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4291: --
4292: BEGIN
4293:
4294: IF l_debug_level > 0 THEN

Line 4295: oe_debug_pub.add( 'ENTERING OE_LINE_ADJ_UTIL.LOCK_ROW' , 1 ) ;

4291: --
4292: BEGIN
4293:
4294: IF l_debug_level > 0 THEN
4295: oe_debug_pub.add( 'ENTERING OE_LINE_ADJ_UTIL.LOCK_ROW' , 1 ) ;
4296: END IF;
4297:
4298: SAVEPOINT Lock_Row;
4299:

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

4315: WHERE price_adjustment_id = l_price_adjustment_id
4316: FOR UPDATE NOWAIT;
4317:
4318: IF l_debug_level > 0 THEN
4319: oe_debug_pub.add( 'SELECTING FOR UPDATE.' , 1 ) ;
4320: END IF;
4321:
4322: OE_Line_Adj_Util.Query_Row
4323: (p_price_adjustment_id => l_price_adjustment_id

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

4342: -- Row locked. If the whole record is passed, then
4343: -- Compare lock_control.
4344:
4345: IF l_debug_level > 0 THEN
4346: oe_debug_pub.add( 'COMPARE ' , 1 ) ;
4347: END IF;
4348:
4349: IF OE_GLOBALS.Equal(p_x_line_adj_rec.lock_control,
4350: l_lock_control)

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

4352:
4353: -- Row has not changed. Set out parameter.
4354:
4355: IF l_debug_level > 0 THEN
4356: oe_debug_pub.add( 'LOCKED ROW' , 1 ) ;
4357: END IF;
4358:
4359: -- Set return status
4360:

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

4364: ELSE
4365:
4366: -- Row has changed by another user.
4367: IF l_debug_level > 0 THEN
4368: oe_debug_pub.add( 'ROW CHANGED BY OTHER USER' , 1 ) ;
4369: END IF;
4370:
4371: x_return_status := FND_API.G_RET_STS_ERROR;
4372: p_x_line_adj_rec.return_status := FND_API.G_RET_STS_ERROR;

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

4448: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4449: l_lock_control NUMBER;
4450:
4451: --
4452: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4453: --
4454: BEGIN
4455:
4456: IF l_debug_level > 0 THEN

Line 4457: oe_debug_pub.add( 'ENTERING OE_LINE_ADJ_UTIL.LOCK_ROWS.' , 1 ) ;

4453: --
4454: BEGIN
4455:
4456: IF l_debug_level > 0 THEN
4457: oe_debug_pub.add( 'ENTERING OE_LINE_ADJ_UTIL.LOCK_ROWS.' , 1 ) ;
4458: END IF;
4459:
4460: IF (p_price_adjustment_id IS NOT NULL AND
4461: p_price_adjustment_id <> FND_API.G_MISS_NUM) AND

Line 4545: oe_debug_pub.add( 'EXITING OE_LINE_ADJ_UTIL.LOCK_ROWS.' , 1 ) ;

4541: );
4542: END IF;
4543:
4544: IF l_debug_level > 0 THEN
4545: oe_debug_pub.add( 'EXITING OE_LINE_ADJ_UTIL.LOCK_ROWS.' , 1 ) ;
4546: END IF;
4547:
4548: END Lock_Rows;
4549:

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

4832: l_ordered_quantity NUMBER;
4833: l_sign NUMBER;
4834: l_pricing_quantity NUMBER;
4835: --
4836: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4837: --
4838: Begin
4839: IF l_debug_level > 0 THEN
4840: oe_debug_pub.add( 'ENTERING PROCEDURE PRORATE_LUMPSUM' ) ;

Line 4840: oe_debug_pub.add( 'ENTERING PROCEDURE PRORATE_LUMPSUM' ) ;

4836: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4837: --
4838: Begin
4839: IF l_debug_level > 0 THEN
4840: oe_debug_pub.add( 'ENTERING PROCEDURE PRORATE_LUMPSUM' ) ;
4841: END IF;
4842:
4843: If px_line_adj_rec.operand = 0 or px_line_adj_rec.operand is null Then
4844: IF l_debug_level > 0 THEN

Line 4845: oe_debug_pub.add( ' NOTHING TO PRORATE , OPERAND IS 0' ) ;

4841: END IF;
4842:
4843: If px_line_adj_rec.operand = 0 or px_line_adj_rec.operand is null Then
4844: IF l_debug_level > 0 THEN
4845: oe_debug_pub.add( ' NOTHING TO PRORATE , OPERAND IS 0' ) ;
4846: END IF;
4847: x_copy_from_line_adj_rec.operation := OE_GLOBALS.G_OPR_NONE;
4848: Return;
4849: End If;

Line 4869: oe_debug_pub.add( 'OPERAND'||PX_LINE_ADJ_REC.OPERAND ||'<>'||L_ORDERED_QUANTITY||'*'||PX_LINE_ADJ_REC.ADJUSTED_AMOUNT ) ;

4865: abs(l_ordered_quantity * px_line_adj_rec.adjusted_amount/ px_line_adj_rec.operand),20))
4866: <> 0
4867: THEN
4868: IF l_debug_level > 0 THEN
4869: oe_debug_pub.add( 'OPERAND'||PX_LINE_ADJ_REC.OPERAND ||'<>'||L_ORDERED_QUANTITY||'*'||PX_LINE_ADJ_REC.ADJUSTED_AMOUNT ) ;
4870: END IF;
4871:
4872: x_copy_from_line_adj_rec := px_line_adj_rec;
4873: x_copy_from_line_adj_rec.operation := oe_globals.g_opr_update;

Line 4885: oe_debug_pub.add( ' PRORATED ADJUSTED_AMOUNT_PER_PQTY:'||X_COPY_FROM_LINE_ADJ_REC.ADJUSTED_AMOUNT_PER_PQTY ) ;

4881: x_copy_from_line_adj_rec.operand_per_pqty:=nvl(x_copy_from_line_adj_rec.operand_per_pqty,
4882: x_copy_from_line_adj_rec.operand);
4883:
4884: IF l_debug_level > 0 THEN
4885: oe_debug_pub.add( ' PRORATED ADJUSTED_AMOUNT_PER_PQTY:'||X_COPY_FROM_LINE_ADJ_REC.ADJUSTED_AMOUNT_PER_PQTY ) ;
4886: oe_debug_pub.add( ' PRORATED ADJUSTED_AMOUNT:'||X_COPY_FROM_LINE_ADJ_REC.ADJUSTED_AMOUNT ) ;
4887: END IF;
4888:
4889: ELSE

Line 4886: oe_debug_pub.add( ' PRORATED ADJUSTED_AMOUNT:'||X_COPY_FROM_LINE_ADJ_REC.ADJUSTED_AMOUNT ) ;

4882: x_copy_from_line_adj_rec.operand);
4883:
4884: IF l_debug_level > 0 THEN
4885: oe_debug_pub.add( ' PRORATED ADJUSTED_AMOUNT_PER_PQTY:'||X_COPY_FROM_LINE_ADJ_REC.ADJUSTED_AMOUNT_PER_PQTY ) ;
4886: oe_debug_pub.add( ' PRORATED ADJUSTED_AMOUNT:'||X_COPY_FROM_LINE_ADJ_REC.ADJUSTED_AMOUNT ) ;
4887: END IF;
4888:
4889: ELSE
4890: x_copy_from_line_adj_rec.operation := OE_GLOBALS.G_OPR_NONE;

Line 4914: oe_debug_pub.add( 'LEAVING PROCEDURE PRORATE_LUMPSUM' ) ;

4910:
4911: END IF;
4912:
4913: IF l_debug_level > 0 THEN
4914: oe_debug_pub.add( 'LEAVING PROCEDURE PRORATE_LUMPSUM' ) ;
4915: END IF;
4916: EXCEPTION
4917:
4918: WHEN OTHERS THEN

Line 4928: oe_debug_pub.add( 'EXCEPTION IN PRORATE_LUMPSUM'||SQLERRM , 2 ) ;

4924: , 'Update_Row'
4925: );
4926: END IF;
4927: IF l_debug_level > 0 THEN
4928: oe_debug_pub.add( 'EXCEPTION IN PRORATE_LUMPSUM'||SQLERRM , 2 ) ;
4929: END IF;
4930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4931:
4932: End Prorate_Lumpsum;

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

4955: l_pbh_tbl Pbh_Tbl_Type;
4956: cnt Pls_Integer:=0;
4957: l_copy_from_line_adj_rec OE_Order_pub.Line_Adj_Rec_Type;
4958: --
4959: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4960: --
4961: l_from_line_category VARCHAR2(100);
4962: --RT{
4963: l_ulp NUMBER;

Line 4977: oe_debug_pub.add( 'ENTERING OE_LINE_ADJ_UTIL.APPEND_ADJUSTMENT_LINES' , 1 ) ;

4973: l_charges_for_backorders VARCHAR2(1):=NVL(FND_PROFILE.VALUE('ONT_CHARGES_FOR_BACKORDERS'),'N');
4974: begin
4975:
4976: IF l_debug_level > 0 THEN
4977: oe_debug_pub.add( 'ENTERING OE_LINE_ADJ_UTIL.APPEND_ADJUSTMENT_LINES' , 1 ) ;
4978: oe_debug_pub.add(' operation:'|| p_operation);
4979: END IF;
4980:
4981:

Line 4978: oe_debug_pub.add(' operation:'|| p_operation);

4974: begin
4975:
4976: IF l_debug_level > 0 THEN
4977: oe_debug_pub.add( 'ENTERING OE_LINE_ADJ_UTIL.APPEND_ADJUSTMENT_LINES' , 1 ) ;
4978: oe_debug_pub.add(' operation:'|| p_operation);
4979: END IF;
4980:
4981:
4982: -- Manish Changes

Line 5011: oe_debug_pub.add(' input line id to retro api:'||p_line_id||' output line id:'|| l_line_id);

5007: , p_phase_change_flag => OE_ORDER_COPY_UTIL.G_LN_PHASE_CHANGE_FLAG
5008: , x_Line_Adj_Tbl => l_Line_Adj_Tbl);
5009:
5010: If l_debug_level > 0 Then
5011: oe_debug_pub.add(' input line id to retro api:'||p_line_id||' output line id:'|| l_line_id);
5012: oe_debug_pub.add(' l_line_adj_tbl.count from versioning:'|| l_Line_Adj_Tbl.count);
5013: End If;
5014:
5015: ELSE

Line 5012: oe_debug_pub.add(' l_line_adj_tbl.count from versioning:'|| l_Line_Adj_Tbl.count);

5008: , x_Line_Adj_Tbl => l_Line_Adj_Tbl);
5009:
5010: If l_debug_level > 0 Then
5011: oe_debug_pub.add(' input line id to retro api:'||p_line_id||' output line id:'|| l_line_id);
5012: oe_debug_pub.add(' l_line_adj_tbl.count from versioning:'|| l_Line_Adj_Tbl.count);
5013: End If;
5014:
5015: ELSE
5016: oe_debug_pub.add('pre 11510, using old query row');

Line 5016: oe_debug_pub.add('pre 11510, using old query row');

5012: oe_debug_pub.add(' l_line_adj_tbl.count from versioning:'|| l_Line_Adj_Tbl.count);
5013: End If;
5014:
5015: ELSE
5016: oe_debug_pub.add('pre 11510, using old query row');
5017: OE_Line_Adj_Util.Query_Rows(p_Line_Id => p_line_id
5018: , x_Line_Adj_Tbl => l_Line_Adj_Tbl);
5019: END IF;
5020:

Line 5040: oe_debug_pub.add(' input Header id to retro api:'||p_header_id||' output Header id:'|| l_header_id);

5036: , p_phase_change_flag => OE_ORDER_COPY_UTIL.G_LN_PHASE_CHANGE_FLAG
5037: , x_Line_Adj_Tbl => l_Line_Adj_Tbl);
5038:
5039: If l_debug_level > 0 Then
5040: oe_debug_pub.add(' input Header id to retro api:'||p_header_id||' output Header id:'|| l_header_id);
5041: oe_debug_pub.add(' l_line_adj_tbl.count from versioning:'|| l_Line_Adj_Tbl.count);
5042: End If;
5043:
5044: ELSE

Line 5041: oe_debug_pub.add(' l_line_adj_tbl.count from versioning:'|| l_Line_Adj_Tbl.count);

5037: , x_Line_Adj_Tbl => l_Line_Adj_Tbl);
5038:
5039: If l_debug_level > 0 Then
5040: oe_debug_pub.add(' input Header id to retro api:'||p_header_id||' output Header id:'|| l_header_id);
5041: oe_debug_pub.add(' l_line_adj_tbl.count from versioning:'|| l_Line_Adj_Tbl.count);
5042: End If;
5043:
5044: ELSE
5045: OE_Line_Adj_Util.Query_Rows(p_header_Id => p_header_id

Line 5063: oe_debug_pub.add('Retro:list line type code:'||l_Line_Adj_Tbl(i).list_line_type_code);

5059: Else
5060:
5061: /* Modified IF condition to process only Line Level Freight Charges for Bug # 1559906 */
5062: -- bug 1937110, added type 'IUE'.
5063: oe_debug_pub.add('Retro:list line type code:'||l_Line_Adj_Tbl(i).list_line_type_code);
5064:
5065: --RT{
5066: IF NOT(nvl(p_mode,'xx-') = 'RETROBILL' and l_Line_Adj_Tbl(i).list_line_type_code = 'FREIGHT_CHARGE') AND
5067: NOT (l_has_retrobilled_before = 'Y' and l_line_adj_tbl(i).retrobill_request_id IS NULL)

Line 5089: oe_debug_pub.add('No Charges are Copied');

5085: (NVL(l_Line_Adj_Tbl(i).include_on_returns_flag,'N') <> 'Y' OR
5086: NVL(l_Line_Adj_Tbl(i).applied_flag,'N') = 'N' )) OR
5087: (p_split_by = 'SYSTEM' and l_charges_for_backorders = 'N' and
5088: l_line_adj_tbl(i).arithmetic_operator = 'LUMPSUM') then
5089: oe_debug_pub.add('No Charges are Copied');
5090: Null;
5091: Else
5092:
5093: -- prorate lumpsum

Line 5098: oe_debug_pub.add( ' P_HEADER_ID:'||P_HEADER_ID|| 'P_TO_HEADER_ID:'||P_TO_HEADER_ID ) ;

5094: IF (l_line_adj_tbl(i).modifier_level_code='LINE'
5095: and l_line_adj_tbl(i).arithmetic_operator = 'LUMPSUM')
5096: THEN
5097: IF l_debug_level > 0 THEN
5098: oe_debug_pub.add( ' P_HEADER_ID:'||P_HEADER_ID|| 'P_TO_HEADER_ID:'||P_TO_HEADER_ID ) ;
5099: oe_debug_pub.add( ' P_SPLIT_BY:'||P_SPLIT_BY ) ;
5100: END IF;
5101: --BTEA
5102: --Only when split we need to do this.

Line 5099: oe_debug_pub.add( ' P_SPLIT_BY:'||P_SPLIT_BY ) ;

5095: and l_line_adj_tbl(i).arithmetic_operator = 'LUMPSUM')
5096: THEN
5097: IF l_debug_level > 0 THEN
5098: oe_debug_pub.add( ' P_HEADER_ID:'||P_HEADER_ID|| 'P_TO_HEADER_ID:'||P_TO_HEADER_ID ) ;
5099: oe_debug_pub.add( ' P_SPLIT_BY:'||P_SPLIT_BY ) ;
5100: END IF;
5101: --BTEA
5102: --Only when split we need to do this.
5103: --during split we will have same to_ and from_ header_id

Line 5118: oe_debug_pub.add( ' UPDATING OPERAND FOR LINE ID:'||L_COPY_FROM_LINE_ADJ_REC.LINE_ID ) ;

5114:
5115: IF l_copy_from_line_adj_rec.operation
5116: = OE_GLOBALS.G_OPR_UPDATE THEN
5117: IF l_debug_level > 0 THEN
5118: oe_debug_pub.add( ' UPDATING OPERAND FOR LINE ID:'||L_COPY_FROM_LINE_ADJ_REC.LINE_ID ) ;
5119: END IF;
5120: px_line_adj_tbl(px_line_adj_tbl.count+1)
5121: := l_copy_from_line_adj_rec;
5122: END IF;

Line 5149: oe_debug_pub.add('pviprana: l_ulp :' || l_ulp);

5145: IF l_Line_Adj_Tbl(i).arithmetic_operator = '%' THEN
5146: open get_ulp(p_key_line_id);
5147: fetch get_ulp INTO l_ulp;
5148: close get_ulp;
5149: oe_debug_pub.add('pviprana: l_ulp :' || l_ulp);
5150: --bug3392650 ( Changed the condition l_Line_Adj_Tbl(i).adjusted_amount < 0)
5151: IF (l_Line_Adj_Tbl(i).list_line_type_code = 'DIS') THEN
5152: l_sign := -1;
5153: ELSE

Line 5157: oe_debug_pub.add('pviprana: adjusted amt'||l_Line_Adj_Tbl(i).adjusted_amount);

5153: ELSE
5154: l_sign := 1;
5155: END IF;
5156: --bug3392650 Calculating adjusted amount only if l_ulp is not null
5157: oe_debug_pub.add('pviprana: adjusted amt'||l_Line_Adj_Tbl(i).adjusted_amount);
5158: IF(l_ulp IS NOT NULL ) THEN
5159: l_Line_Adj_Tbl(i).adjusted_amount:= (l_Line_Adj_Tbl(i).operand/100) * l_ulp *l_sign;
5160: END IF;
5161: oe_debug_pub.add('Converting Order level to line, unit list price:'|| l_ulp);

Line 5161: oe_debug_pub.add('Converting Order level to line, unit list price:'|| l_ulp);

5157: oe_debug_pub.add('pviprana: adjusted amt'||l_Line_Adj_Tbl(i).adjusted_amount);
5158: IF(l_ulp IS NOT NULL ) THEN
5159: l_Line_Adj_Tbl(i).adjusted_amount:= (l_Line_Adj_Tbl(i).operand/100) * l_ulp *l_sign;
5160: END IF;
5161: oe_debug_pub.add('Converting Order level to line, unit list price:'|| l_ulp);
5162: oe_debug_pub.add('Adjusted amount:'||l_Line_Adj_Tbl(i).adjusted_amount);
5163: END IF;
5164: --RT}
5165: END IF;

Line 5162: oe_debug_pub.add('Adjusted amount:'||l_Line_Adj_Tbl(i).adjusted_amount);

5158: IF(l_ulp IS NOT NULL ) THEN
5159: l_Line_Adj_Tbl(i).adjusted_amount:= (l_Line_Adj_Tbl(i).operand/100) * l_ulp *l_sign;
5160: END IF;
5161: oe_debug_pub.add('Converting Order level to line, unit list price:'|| l_ulp);
5162: oe_debug_pub.add('Adjusted amount:'||l_Line_Adj_Tbl(i).adjusted_amount);
5163: END IF;
5164: --RT}
5165: END IF;
5166:

Line 5183: oe_debug_pub.add('p_line_category_code :'||p_line_category_code);

5179: select line_category_code into l_from_line_category
5180: from oe_order_lines_all
5181: where line_id = p_line_id ;
5182:
5183: oe_debug_pub.add('p_line_category_code :'||p_line_category_code);
5184: oe_debug_pub.add('l_from_line_category :'||l_from_line_category);
5185: oe_debug_pub.add('l_Line_Adj_Tbl(i).credit_or_charge_flag :'||l_Line_Adj_Tbl(i).credit_or_charge_flag);
5186:
5187: --Added for bug 7328969 End

Line 5184: oe_debug_pub.add('l_from_line_category :'||l_from_line_category);

5180: from oe_order_lines_all
5181: where line_id = p_line_id ;
5182:
5183: oe_debug_pub.add('p_line_category_code :'||p_line_category_code);
5184: oe_debug_pub.add('l_from_line_category :'||l_from_line_category);
5185: oe_debug_pub.add('l_Line_Adj_Tbl(i).credit_or_charge_flag :'||l_Line_Adj_Tbl(i).credit_or_charge_flag);
5186:
5187: --Added for bug 7328969 End
5188: */

Line 5185: oe_debug_pub.add('l_Line_Adj_Tbl(i).credit_or_charge_flag :'||l_Line_Adj_Tbl(i).credit_or_charge_flag);

5181: where line_id = p_line_id ;
5182:
5183: oe_debug_pub.add('p_line_category_code :'||p_line_category_code);
5184: oe_debug_pub.add('l_from_line_category :'||l_from_line_category);
5185: oe_debug_pub.add('l_Line_Adj_Tbl(i).credit_or_charge_flag :'||l_Line_Adj_Tbl(i).credit_or_charge_flag);
5186:
5187: --Added for bug 7328969 End
5188: */
5189: -- Commented for 7683779 End

Line 5199: oe_debug_pub.add('p_line_category_code :'||p_line_category_code);

5195: from oe_order_lines_all
5196: where line_id = p_line_id ;
5197:
5198: IF l_debug_level > 0 THEN
5199: oe_debug_pub.add('p_line_category_code :'||p_line_category_code);
5200: oe_debug_pub.add('l_from_line_category :'||l_from_line_category);
5201: oe_debug_pub.add('l_Line_Adj_Tbl(i).credit_or_charge_flag :'||l_Line_Adj_Tbl(i).credit_or_charge_flag);
5202: END IF;
5203:

Line 5200: oe_debug_pub.add('l_from_line_category :'||l_from_line_category);

5196: where line_id = p_line_id ;
5197:
5198: IF l_debug_level > 0 THEN
5199: oe_debug_pub.add('p_line_category_code :'||p_line_category_code);
5200: oe_debug_pub.add('l_from_line_category :'||l_from_line_category);
5201: oe_debug_pub.add('l_Line_Adj_Tbl(i).credit_or_charge_flag :'||l_Line_Adj_Tbl(i).credit_or_charge_flag);
5202: END IF;
5203:
5204: --Added for bug 7683779 End

Line 5201: oe_debug_pub.add('l_Line_Adj_Tbl(i).credit_or_charge_flag :'||l_Line_Adj_Tbl(i).credit_or_charge_flag);

5197:
5198: IF l_debug_level > 0 THEN
5199: oe_debug_pub.add('p_line_category_code :'||p_line_category_code);
5200: oe_debug_pub.add('l_from_line_category :'||l_from_line_category);
5201: oe_debug_pub.add('l_Line_Adj_Tbl(i).credit_or_charge_flag :'||l_Line_Adj_Tbl(i).credit_or_charge_flag);
5202: END IF;
5203:
5204: --Added for bug 7683779 End
5205:

Line 5219: oe_debug_pub.add('l_Line_Adj_Tbl(i).credit_or_charge_flag :'||l_Line_Adj_Tbl(i).credit_or_charge_flag);

5215: ELSE
5216: l_Line_Adj_Tbl(i).credit_or_charge_flag := 'C';
5217: END IF;
5218:
5219: oe_debug_pub.add('l_Line_Adj_Tbl(i).credit_or_charge_flag :'||l_Line_Adj_Tbl(i).credit_or_charge_flag);
5220:
5221: l_Line_Adj_Tbl(i).updated_flag := 'Y';
5222: l_Line_Adj_Tbl(i).change_reason_code := 'MISC';
5223: l_Line_Adj_Tbl(i).change_reason_text := 'Reversing Credit';

Line 5284: oe_debug_pub.add('operand:'||px_line_adj_tbl(i).operand);

5280: while I is not null loop
5281: IF (px_line_adj_tbl(i).operation = OE_GLOBALS.G_OPR_CREATE) THEN
5282: px_line_adj_tbl(i).price_adjustment_id:=fnd_api.g_miss_num;
5283: --RT{
5284: oe_debug_pub.add('operand:'||px_line_adj_tbl(i).operand);
5285: oe_debug_pub.add('operand per pqty:'||px_line_adj_tbl(i).operand_per_pqty);
5286: oe_debug_pub.add('Retro:p_mode:'||p_mode);
5287: IF nvl(p_mode,'NULLMODE') = 'RETROBILL' THEN
5288: IF px_line_adj_tbl(i).retrobill_request_id IS NOT NULL

Line 5285: oe_debug_pub.add('operand per pqty:'||px_line_adj_tbl(i).operand_per_pqty);

5281: IF (px_line_adj_tbl(i).operation = OE_GLOBALS.G_OPR_CREATE) THEN
5282: px_line_adj_tbl(i).price_adjustment_id:=fnd_api.g_miss_num;
5283: --RT{
5284: oe_debug_pub.add('operand:'||px_line_adj_tbl(i).operand);
5285: oe_debug_pub.add('operand per pqty:'||px_line_adj_tbl(i).operand_per_pqty);
5286: oe_debug_pub.add('Retro:p_mode:'||p_mode);
5287: IF nvl(p_mode,'NULLMODE') = 'RETROBILL' THEN
5288: IF px_line_adj_tbl(i).retrobill_request_id IS NOT NULL
5289: and px_line_adj_tbl(i).applied_flag = 'N' THEN

Line 5286: oe_debug_pub.add('Retro:p_mode:'||p_mode);

5282: px_line_adj_tbl(i).price_adjustment_id:=fnd_api.g_miss_num;
5283: --RT{
5284: oe_debug_pub.add('operand:'||px_line_adj_tbl(i).operand);
5285: oe_debug_pub.add('operand per pqty:'||px_line_adj_tbl(i).operand_per_pqty);
5286: oe_debug_pub.add('Retro:p_mode:'||p_mode);
5287: IF nvl(p_mode,'NULLMODE') = 'RETROBILL' THEN
5288: IF px_line_adj_tbl(i).retrobill_request_id IS NOT NULL
5289: and px_line_adj_tbl(i).applied_flag = 'N' THEN
5290: --applied flag needs to remain 'Y'. Becomes 'N' only after

Line 5299: oe_debug_pub.add('RETRO:ADJ:Copied list line id:'|| px_line_adj_tbl(i).list_line_id);

5295: --replace with new retrobill request id.
5296: px_line_adj_tbl(i).retrobill_request_id:= p_retrobill_request_id;
5297:
5298: --px_line_adj_tbl(i).applied_flag:='N';
5299: oe_debug_pub.add('RETRO:ADJ:Copied list line id:'|| px_line_adj_tbl(i).list_line_id);
5300: oe_debug_pub.add('RETRO:ADJ:Operand:'|| px_line_adj_tbl(i).operand);
5301: oe_debug_pub.add('RETRO:ADJ:Operand pqty:'||px_line_adj_tbl(i).operand_per_pqty);
5302: END IF;
5303: --RT}

Line 5300: oe_debug_pub.add('RETRO:ADJ:Operand:'|| px_line_adj_tbl(i).operand);

5296: px_line_adj_tbl(i).retrobill_request_id:= p_retrobill_request_id;
5297:
5298: --px_line_adj_tbl(i).applied_flag:='N';
5299: oe_debug_pub.add('RETRO:ADJ:Copied list line id:'|| px_line_adj_tbl(i).list_line_id);
5300: oe_debug_pub.add('RETRO:ADJ:Operand:'|| px_line_adj_tbl(i).operand);
5301: oe_debug_pub.add('RETRO:ADJ:Operand pqty:'||px_line_adj_tbl(i).operand_per_pqty);
5302: END IF;
5303: --RT}
5304: END IF;

Line 5301: oe_debug_pub.add('RETRO:ADJ:Operand pqty:'||px_line_adj_tbl(i).operand_per_pqty);

5297:
5298: --px_line_adj_tbl(i).applied_flag:='N';
5299: oe_debug_pub.add('RETRO:ADJ:Copied list line id:'|| px_line_adj_tbl(i).list_line_id);
5300: oe_debug_pub.add('RETRO:ADJ:Operand:'|| px_line_adj_tbl(i).operand);
5301: oe_debug_pub.add('RETRO:ADJ:Operand pqty:'||px_line_adj_tbl(i).operand_per_pqty);
5302: END IF;
5303: --RT}
5304: END IF;
5305: I:=px_line_adj_tbl.next(I);

Line 5310: oe_debug_pub.add( 'EXITING OE_LINE_ADJ_UTIL.APPEND_ADJUSTMENT_LINES' , 1 ) ;

5306: end loop;
5307: END IF;
5308:
5309: IF l_debug_level > 0 THEN
5310: oe_debug_pub.add( 'EXITING OE_LINE_ADJ_UTIL.APPEND_ADJUSTMENT_LINES' , 1 ) ;
5311: END IF;
5312:
5313: end Append_Adjustment_Lines;
5314:

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

5356: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
5357: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
5358: --serla end
5359: --
5360: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5361: --
5362: begin
5363: IF l_debug_level > 0 THEN
5364: oe_debug_pub.add( 'ENTERING OE_LINE_ADJ_UTIL.COPY_ADJUSTMENT_LINES' , 1 ) ;

Line 5364: oe_debug_pub.add( 'ENTERING OE_LINE_ADJ_UTIL.COPY_ADJUSTMENT_LINES' , 1 ) ;

5360: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5361: --
5362: begin
5363: IF l_debug_level > 0 THEN
5364: oe_debug_pub.add( 'ENTERING OE_LINE_ADJ_UTIL.COPY_ADJUSTMENT_LINES' , 1 ) ;
5365: oe_debug_pub.add( 'SPLIT BY:'||P_SPLIT_BY ) ;
5366: END IF;
5367: -- Set the existing rows to delete
5368: Append_Adjustment_Lines(

Line 5365: oe_debug_pub.add( 'SPLIT BY:'||P_SPLIT_BY ) ;

5361: --
5362: begin
5363: IF l_debug_level > 0 THEN
5364: oe_debug_pub.add( 'ENTERING OE_LINE_ADJ_UTIL.COPY_ADJUSTMENT_LINES' , 1 ) ;
5365: oe_debug_pub.add( 'SPLIT BY:'||P_SPLIT_BY ) ;
5366: END IF;
5367: -- Set the existing rows to delete
5368: Append_Adjustment_Lines(
5369: p_line_id => p_to_line_id

Line 5397: oe_debug_pub.add('pviprana: p_from_header_id'||p_from_header_id);

5393: END IF;
5394: --RT}
5395: -- Append Header level adjustments only if the order is different
5396: /* Modified the following if condition to fix the bug 2170086 */
5397: oe_debug_pub.add('pviprana: p_from_header_id'||p_from_header_id);
5398: oe_debug_pub.add('pviprana: p_to_header_id'||p_to_header_id);
5399: oe_debug_pub.add('pviprana: p_from_line_id'||p_from_line_id);
5400: oe_debug_pub.add('pviprana: p_to_line_id'||p_to_line_id);
5401: If p_from_Header_id <> p_to_Header_id and

Line 5398: oe_debug_pub.add('pviprana: p_to_header_id'||p_to_header_id);

5394: --RT}
5395: -- Append Header level adjustments only if the order is different
5396: /* Modified the following if condition to fix the bug 2170086 */
5397: oe_debug_pub.add('pviprana: p_from_header_id'||p_from_header_id);
5398: oe_debug_pub.add('pviprana: p_to_header_id'||p_to_header_id);
5399: oe_debug_pub.add('pviprana: p_from_line_id'||p_from_line_id);
5400: oe_debug_pub.add('pviprana: p_to_line_id'||p_to_line_id);
5401: If p_from_Header_id <> p_to_Header_id and
5402: OE_ORDER_COPY_UTIL.G_ORDER_LEVEL_COPY = 0 then

Line 5399: oe_debug_pub.add('pviprana: p_from_line_id'||p_from_line_id);

5395: -- Append Header level adjustments only if the order is different
5396: /* Modified the following if condition to fix the bug 2170086 */
5397: oe_debug_pub.add('pviprana: p_from_header_id'||p_from_header_id);
5398: oe_debug_pub.add('pviprana: p_to_header_id'||p_to_header_id);
5399: oe_debug_pub.add('pviprana: p_from_line_id'||p_from_line_id);
5400: oe_debug_pub.add('pviprana: p_to_line_id'||p_to_line_id);
5401: If p_from_Header_id <> p_to_Header_id and
5402: OE_ORDER_COPY_UTIL.G_ORDER_LEVEL_COPY = 0 then
5403: --bug3392650 passing an extra parameter p_key_line_id if the mode is 'RETROBILL' so that l_ulp is obtained properly in

Line 5400: oe_debug_pub.add('pviprana: p_to_line_id'||p_to_line_id);

5396: /* Modified the following if condition to fix the bug 2170086 */
5397: oe_debug_pub.add('pviprana: p_from_header_id'||p_from_header_id);
5398: oe_debug_pub.add('pviprana: p_to_header_id'||p_to_header_id);
5399: oe_debug_pub.add('pviprana: p_from_line_id'||p_from_line_id);
5400: oe_debug_pub.add('pviprana: p_to_line_id'||p_to_line_id);
5401: If p_from_Header_id <> p_to_Header_id and
5402: OE_ORDER_COPY_UTIL.G_ORDER_LEVEL_COPY = 0 then
5403: --bug3392650 passing an extra parameter p_key_line_id if the mode is 'RETROBILL' so that l_ulp is obtained properly in
5404: --append_adjustment_lines when the order level modifier is being converted to line level.

Line 5458: oe_debug_pub.add( 'BEFORE OE_ORDER_PVT.PROCESS_ORDER'||L_LINE_ADJ_TBL.COUNT , 1 ) ;

5454:
5455: -- Call OE_Order_PVT.Process_order
5456:
5457: IF l_debug_level > 0 THEN
5458: oe_debug_pub.add( 'BEFORE OE_ORDER_PVT.PROCESS_ORDER'||L_LINE_ADJ_TBL.COUNT , 1 ) ;
5459: END IF ;
5460:
5461: OE_Globals.G_PRICING_RECURSION := 'Y';
5462:

Line 5508: oe_debug_pub.add( 'EXITING OE_LINE_ADJ_UTIL.COPY_ADJUSTMENT_LINES' , 1 ) ;

5504: RAISE FND_API.G_EXC_ERROR;
5505: END IF;
5506:
5507: IF l_debug_level > 0 THEN
5508: oe_debug_pub.add( 'EXITING OE_LINE_ADJ_UTIL.COPY_ADJUSTMENT_LINES' , 1 ) ;
5509: END IF;
5510:
5511: Exception
5512: WHEN FND_API.G_EXC_ERROR THEN

Line 5519: oe_debug_pub.add( G_PKG_NAME||':COPY_ADJUSTMENT_LINES:'||SQLERRM ) ;

5515: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5516:
5517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5518: IF l_debug_level > 0 THEN
5519: oe_debug_pub.add( G_PKG_NAME||':COPY_ADJUSTMENT_LINES:'||SQLERRM ) ;
5520: END IF;
5521:
5522: end copy_adjustment_lines;
5523:

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

5527: p_old_line_adj_rec IN OE_ORDER_PUB.line_adj_rec_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_REC) IS
5528: /*local */
5529: l_return_status varchar2(30);
5530: --
5531: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5532: --
5533: BEGIN
5534:
5535: --11.5.10 Versioning/Audit Trail updates

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

5544: OE_GLOBALS.G_REASON_COMMENTS := p_x_line_adj_rec.change_reason_text;
5545: OE_GLOBALS.G_CAPTURED_REASON := 'Y';
5546: ELSE
5547: if l_debug_level > 0 then
5548: OE_DEBUG_PUB.add('Reason code for versioning is missing or invalid', 1);
5549: end if;
5550: --bug 3775971
5551: if OE_GLOBALS.G_UI_FLAG AND
5552: (OE_GLOBALS.G_PRICING_RECURSION = 'Y' OR

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

5556: END IF;
5557: END IF;
5558:
5559: --log delayed request
5560: oe_debug_pub.add('log versioning request',1);
5561: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
5562: p_entity_id => p_x_line_adj_rec.header_id,
5563: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ,
5564: p_requesting_entity_id => p_x_line_adj_rec.price_adjustment_id,

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

5571: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG = 'Y' OR
5572: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG = 'Y' THEN
5573:
5574: IF l_debug_level > 0 THEN
5575: oe_debug_pub.add( 'CALL TO RECORD LINE PRICE ADJ HISTORY' , 5 ) ;
5576: END IF;
5577: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
5578: OE_Versioning_Util.Capture_Audit_Info(p_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ,
5579: p_entity_id => p_x_line_adj_rec.price_adjustment_id,

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

5601: END IF;
5602:
5603: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
5604: IF l_debug_level > 0 THEN
5605: oe_debug_pub.add( 'INSERT INTO LINE PRICE ADJUSTMENTS AUDIT HISTORY CAUSED ERROR' , 1 ) ;
5606: END IF;
5607: IF l_return_status = FND_API.G_RET_STS_ERROR then
5608: raise FND_API.G_EXC_ERROR;
5609: ELSE

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

5616: /* End AuditTrail */
5617:
5618: Function Is_Pricing_Related_Change(p_new_line_rec In Oe_Order_Pub.Line_Rec_Type,
5619: p_old_line_rec In Oe_Order_Pub.Line_Rec_Type) Return Boolean As
5620: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5621: Begin
5622:
5623: IF l_debug_level > 0 THEN
5624: oe_debug_pub.add( ' Check if any pricing related changes has occured' ) ;

Line 5624: oe_debug_pub.add( ' Check if any pricing related changes has occured' ) ;

5620: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5621: Begin
5622:
5623: IF l_debug_level > 0 THEN
5624: oe_debug_pub.add( ' Check if any pricing related changes has occured' ) ;
5625: END IF;
5626:
5627: IF NOT OE_GLOBALS.Equal(p_new_line_rec.agreement_id,p_old_line_rec.agreement_id)
5628: OR NOT OE_GLOBALS.Equal(p_new_line_rec.cust_po_number,p_old_line_rec.cust_po_number)

Line 5674: oe_debug_pub.add( ' PRICING RELATED FIELDS HAS CHANGED' ) ;

5670: --Bug 4332307
5671:
5672: Then
5673: IF l_debug_level > 0 THEN
5674: oe_debug_pub.add( ' PRICING RELATED FIELDS HAS CHANGED' ) ;
5675: END IF;
5676: Return True;
5677:
5678: Else

Line 5680: oe_debug_pub.add( ' NO pricing related Fields Has Changed' ) ;

5676: Return True;
5677:
5678: Else
5679: IF l_debug_level > 0 THEN
5680: oe_debug_pub.add( ' NO pricing related Fields Has Changed' ) ;
5681: END IF;
5682: Return False;
5683: End If;
5684:

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

5719: l_delete_prg varchar2(1);
5720: l_dummy NUMBER;
5721: l_rltd_price_adj_id NUMBER;
5722: --
5723: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5724: --
5725: l_reason_code VARCHAR2(30);
5726: l_reason_comments VARCHAR2(2000);
5727: l_captured_reason varchar2(1);

Line 5731: oe_debug_pub.add( 'ENTERING OEXULADB.DELETE_PRG_LINES WITH LINE_ID = ' || P_LINE_ID ) ;

5727: l_captured_reason varchar2(1);
5728:
5729: Begin
5730: IF l_debug_level > 0 THEN
5731: oe_debug_pub.add( 'ENTERING OEXULADB.DELETE_PRG_LINES WITH LINE_ID = ' || P_LINE_ID ) ;
5732: END IF;
5733: if l_debug_level > 0 then
5734: oe_debug_pub.add('reason:'||OE_GLOBALS.G_REASON_CODE,3);
5735: oe_debug_pub.add('captured:'||OE_GLOBALS.G_captured_reason,3);

Line 5734: oe_debug_pub.add('reason:'||OE_GLOBALS.G_REASON_CODE,3);

5730: IF l_debug_level > 0 THEN
5731: oe_debug_pub.add( 'ENTERING OEXULADB.DELETE_PRG_LINES WITH LINE_ID = ' || P_LINE_ID ) ;
5732: END IF;
5733: if l_debug_level > 0 then
5734: oe_debug_pub.add('reason:'||OE_GLOBALS.G_REASON_CODE,3);
5735: oe_debug_pub.add('captured:'||OE_GLOBALS.G_captured_reason,3);
5736: oe_debug_pub.add('audit:'||OE_GLOBALS.G_version_audit,3);
5737: end if;
5738: l_reason_code := OE_GLOBALS.G_REASON_CODE;

Line 5735: oe_debug_pub.add('captured:'||OE_GLOBALS.G_captured_reason,3);

5731: oe_debug_pub.add( 'ENTERING OEXULADB.DELETE_PRG_LINES WITH LINE_ID = ' || P_LINE_ID ) ;
5732: END IF;
5733: if l_debug_level > 0 then
5734: oe_debug_pub.add('reason:'||OE_GLOBALS.G_REASON_CODE,3);
5735: oe_debug_pub.add('captured:'||OE_GLOBALS.G_captured_reason,3);
5736: oe_debug_pub.add('audit:'||OE_GLOBALS.G_version_audit,3);
5737: end if;
5738: l_reason_code := OE_GLOBALS.G_REASON_CODE;
5739: l_reason_comments := OE_GLOBALS.G_REASON_COMMENTS;

Line 5736: oe_debug_pub.add('audit:'||OE_GLOBALS.G_version_audit,3);

5732: END IF;
5733: if l_debug_level > 0 then
5734: oe_debug_pub.add('reason:'||OE_GLOBALS.G_REASON_CODE,3);
5735: oe_debug_pub.add('captured:'||OE_GLOBALS.G_captured_reason,3);
5736: oe_debug_pub.add('audit:'||OE_GLOBALS.G_version_audit,3);
5737: end if;
5738: l_reason_code := OE_GLOBALS.G_REASON_CODE;
5739: l_reason_comments := OE_GLOBALS.G_REASON_COMMENTS;
5740: l_captured_reason := OE_GLOBALS.G_CAPTURED_REASON;

Line 5745: oe_debug_pub.add( 'PRG LINE ID = ' || L_PRG_LINE_ID ) ;

5741: OPEN prg_lines;
5742: FETCH prg_lines into l_prg_line_id, l_rltd_price_adj_id;
5743: WHILE prg_lines%FOUND Loop
5744: IF l_debug_level > 0 THEN
5745: oe_debug_pub.add( 'PRG LINE ID = ' || L_PRG_LINE_ID ) ;
5746: END IF;
5747: OE_LINE_UTIL.QUERY_ROW(p_line_id => l_prg_line_id,
5748: x_line_rec => l_line_rec);
5749:

Line 5755: oe_debug_pub.add( 'ORDER NOT BOOKED' ) ;

5751:
5752: if (l_line_rec.booked_flag <> 'Y') Then
5753:
5754: IF l_debug_level > 0 THEN
5755: oe_debug_pub.add( 'ORDER NOT BOOKED' ) ;
5756: END IF;
5757: l_line_rec.operation := OE_GLOBALS.G_OPR_DELETE;
5758:
5759: else

Line 5762: oe_debug_pub.add( 'BOOKED ORDER , LINE NOT SHIPPED' ) ;

5758:
5759: else
5760: if (l_line_rec.shipped_quantity is NULL) Then
5761: IF l_debug_level > 0 THEN
5762: oe_debug_pub.add( 'BOOKED ORDER , LINE NOT SHIPPED' ) ;
5763: END IF;
5764: if (p_operation = OE_GLOBALS.G_OPR_DELETE) Then
5765: -- bug 2756288, if buy line can be deleted, so can get line
5766: l_line_rec.operation := OE_GLOBALS.G_OPR_DELETE;

Line 5774: oe_debug_pub.add( 'BOOKED ORDER , SHIPPED LINE' ) ;

5770: l_line_rec.pricing_quantity := 0;
5771: end if;
5772: else
5773: IF l_debug_level > 0 THEN
5774: oe_debug_pub.add( 'BOOKED ORDER , SHIPPED LINE' ) ;
5775: END IF;
5776: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
5777: l_line_rec.calculate_price_flag := 'Y';
5778: end if;

Line 5787: oe_debug_pub.add( 'PRICE ADJ ID = ' || I.PRICE_ADJUSTMENT_ID ) ;

5783: for i in prg_adjs LOOP
5784: -- Delete PRG adjustment record and the association
5785: -- between the buy line and the get line
5786: IF l_debug_level > 0 THEN
5787: oe_debug_pub.add( 'PRICE ADJ ID = ' || I.PRICE_ADJUSTMENT_ID ) ;
5788: END IF;
5789: OE_LINE_ADJ_UTIL.DELETE_ROW(p_price_adjustment_id => i.price_adjustment_id);
5790:
5791: DELETE FROM OE_PRICE_ADJ_ASSOCS WHERE PRICE_ADJUSTMENT_ID = i.price_adjustment_id;

Line 5802: oe_debug_pub.add( 'ASSOC ID:'||L_DUMMY ) ;

5798: WHEN NO_DATA_FOUND THEN
5799: l_delete_prg := 'Y';
5800: END;
5801: IF l_debug_level > 0 THEN
5802: oe_debug_pub.add( 'ASSOC ID:'||L_DUMMY ) ;
5803: END IF;
5804:
5805: IF (l_delete_prg = 'Y') THEN
5806: -- Call Process Order

Line 5832: oe_debug_pub.add('reason:'||OE_GLOBALS.G_REASON_CODE,3);

5828: FETCH prg_lines into l_prg_line_id, l_rltd_price_adj_id;
5829: End Loop;
5830: CLOSE prg_lines;
5831: if l_debug_level > 0 then
5832: oe_debug_pub.add('reason:'||OE_GLOBALS.G_REASON_CODE,3);
5833: oe_debug_pub.add('captured:'||OE_GLOBALS.G_captured_reason,3);
5834: oe_debug_pub.add('audit:'||OE_GLOBALS.G_version_audit,3);
5835: end if;
5836: OE_GLOBALS.G_REASON_CODE := l_reason_code;

Line 5833: oe_debug_pub.add('captured:'||OE_GLOBALS.G_captured_reason,3);

5829: End Loop;
5830: CLOSE prg_lines;
5831: if l_debug_level > 0 then
5832: oe_debug_pub.add('reason:'||OE_GLOBALS.G_REASON_CODE,3);
5833: oe_debug_pub.add('captured:'||OE_GLOBALS.G_captured_reason,3);
5834: oe_debug_pub.add('audit:'||OE_GLOBALS.G_version_audit,3);
5835: end if;
5836: OE_GLOBALS.G_REASON_CODE := l_reason_code;
5837: OE_GLOBALS.G_REASON_COMMENTS := l_reason_comments;

Line 5834: oe_debug_pub.add('audit:'||OE_GLOBALS.G_version_audit,3);

5830: CLOSE prg_lines;
5831: if l_debug_level > 0 then
5832: oe_debug_pub.add('reason:'||OE_GLOBALS.G_REASON_CODE,3);
5833: oe_debug_pub.add('captured:'||OE_GLOBALS.G_captured_reason,3);
5834: oe_debug_pub.add('audit:'||OE_GLOBALS.G_version_audit,3);
5835: end if;
5836: OE_GLOBALS.G_REASON_CODE := l_reason_code;
5837: OE_GLOBALS.G_REASON_COMMENTS := l_reason_comments;
5838: OE_GLOBALS.G_CAPTURED_REASON := l_captured_reason;

Line 5841: oe_debug_pub.add( 'EXITING OEXULADB.DELETE_PRG_LINES' ) ;

5837: OE_GLOBALS.G_REASON_COMMENTS := l_reason_comments;
5838: OE_GLOBALS.G_CAPTURED_REASON := l_captured_reason;
5839:
5840: IF l_debug_level > 0 THEN
5841: oe_debug_pub.add( 'EXITING OEXULADB.DELETE_PRG_LINES' ) ;
5842: END IF;
5843: EXCEPTION
5844: WHEN OTHERS THEN
5845: IF l_debug_level > 0 THEN

Line 5846: oe_debug_pub.add( 'EXCEPTION IN DELETE_PRG_LINES'||SQLERRM , 3 ) ;

5842: END IF;
5843: EXCEPTION
5844: WHEN OTHERS THEN
5845: IF l_debug_level > 0 THEN
5846: oe_debug_pub.add( 'EXCEPTION IN DELETE_PRG_LINES'||SQLERRM , 3 ) ;
5847: END IF;
5848: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5849: End Delete_PRG_Lines;
5850:

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

5850:
5851: Procedure Check_Canceled_PRG(p_old_line_rec in Oe_Order_Pub.line_rec_type,
5852: p_new_line_rec in Oe_Order_Pub.line_rec_type) Is
5853: --
5854: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5855: --
5856: Begin
5857:
5858: IF p_new_line_rec.operation = OE_GLOBALS.G_OPR_DELETE OR NOT OE_GLOBALS.EQUAL(p_new_line_rec.ordered_quantity, p_old_line_rec.ordered_quantity) Then

Line 5862: oe_debug_pub.add( 'OPEN ORDER , ORDERED QTY CHANGED TO ZERO , DELETE ALL PRG LINES' ) ;

5858: IF p_new_line_rec.operation = OE_GLOBALS.G_OPR_DELETE OR NOT OE_GLOBALS.EQUAL(p_new_line_rec.ordered_quantity, p_old_line_rec.ordered_quantity) Then
5859: IF (nvl(p_new_line_rec.booked_flag, 'X') <> 'Y') Then
5860: IF (p_new_line_rec.operation = OE_GLOBALS.G_OPR_DELETE OR p_new_line_rec.ordered_quantity = 0) Then
5861: IF l_debug_level > 0 THEN
5862: oe_debug_pub.add( 'OPEN ORDER , ORDERED QTY CHANGED TO ZERO , DELETE ALL PRG LINES' ) ;
5863: END IF;
5864: Delete_PRG_Lines(p_new_line_rec.line_id, p_new_line_rec.operation);
5865: END IF;
5866: ELSE

Line 5872: oe_debug_pub.add( 'BOOKED ORDER , ORDERED QTY CHANGED TO ZERO , DELETE ALL PRG LINES' ) ;

5868: (p_new_line_rec.change_reason is NOT NULL OR
5869: p_new_line_rec.change_reason <> FND_API.G_MISS_CHAR))
5870: OR p_new_line_rec.operation = OE_GLOBALS.G_OPR_DELETE Then
5871: IF l_debug_level > 0 THEN
5872: oe_debug_pub.add( 'BOOKED ORDER , ORDERED QTY CHANGED TO ZERO , DELETE ALL PRG LINES' ) ;
5873: END IF;
5874: Delete_PRG_Lines(p_new_line_rec.line_id, p_new_line_rec.operation);
5875: END IF;
5876: END IF;

Line 5881: oe_debug_pub.add( 'EXCEPTION IN CHECK_CANCELED_PRG'||SQLERRM , 3 ) ;

5877: End if;
5878: EXCEPTION
5879: WHEN OTHERS THEN
5880: IF l_debug_level > 0 THEN
5881: oe_debug_pub.add( 'EXCEPTION IN CHECK_CANCELED_PRG'||SQLERRM , 3 ) ;
5882: END IF;
5883: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5884: End Check_Canceled_PRG;
5885:

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

5897: l_pricing_related_changes Boolean :=False;
5898: l_margin_related_changes Boolean :=False;
5899:
5900: --
5901: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5902: --
5903: Begin
5904: IF l_debug_level > 0 THEN
5905: oe_debug_pub.add( 'ENTERING OE_LINE_ADJ_UTIL.PROCESS_PRICING CALLED FROM ULINB' ) ;

Line 5905: oe_debug_pub.add( 'ENTERING OE_LINE_ADJ_UTIL.PROCESS_PRICING CALLED FROM ULINB' ) ;

5901: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5902: --
5903: Begin
5904: IF l_debug_level > 0 THEN
5905: oe_debug_pub.add( 'ENTERING OE_LINE_ADJ_UTIL.PROCESS_PRICING CALLED FROM ULINB' ) ;
5906: END IF;
5907:
5908: IF NOT OE_GLOBALS.Equal(p_x_new_line_rec.cancelled_quantity,p_old_line_rec.cancelled_quantity)
5909: and p_x_new_line_rec.cancelled_quantity > 0

Line 5912: oe_debug_pub.add( ' USER CANCELS LINE , CANCELLED QUANTITY:'||P_X_NEW_LINE_REC.CANCELLED_QUANTITY ) ;

5908: IF NOT OE_GLOBALS.Equal(p_x_new_line_rec.cancelled_quantity,p_old_line_rec.cancelled_quantity)
5909: and p_x_new_line_rec.cancelled_quantity > 0
5910: Then
5911: IF l_debug_level > 0 THEN
5912: oe_debug_pub.add( ' USER CANCELS LINE , CANCELLED QUANTITY:'||P_X_NEW_LINE_REC.CANCELLED_QUANTITY ) ;
5913: END IF;
5914:
5915: --bug7491829 added p_ordered_quantity
5916: Process_Cancelled_Lines(p_x_new_line_rec=>p_x_new_line_rec,

Line 5930: oe_debug_pub.add( ' BOOKED FLAG OR UNIT COST CHANGES' ) ;

5926:
5927: IF NOT OE_GLOBALS.Equal(p_x_new_line_rec.unit_cost,p_old_line_rec.unit_cost)
5928: Then
5929: IF l_debug_level > 0 THEN
5930: oe_debug_pub.add( ' BOOKED FLAG OR UNIT COST CHANGES' ) ;
5931: END IF;
5932: l_margin_related_changes := True;
5933: End If;
5934:

Line 5953: oe_debug_pub.add('G_GROUP_PRICING_DSP = '||G_GROUP_PRICING_DSP);

5949: else
5950: G_SEND_ALL_LINES_FOR_DSP := 'Y';
5951: end if;
5952: If l_debug_level > 0 Then
5953: oe_debug_pub.add('G_GROUP_PRICING_DSP = '||G_GROUP_PRICING_DSP);
5954: End If;
5955:
5956: If G_CODE_RELEASE_LEVEL IS NULL THEN
5957: G_CODE_RELEASE_LEVEL := OE_CODE_CONTROL.CODE_RELEASE_LEVEL;

Line 5961: oe_debug_pub.add('G_CODE_RELEASE_LEVEL = '||G_CODE_RELEASE_LEVEL);

5957: G_CODE_RELEASE_LEVEL := OE_CODE_CONTROL.CODE_RELEASE_LEVEL;
5958: End If;
5959:
5960: If l_debug_level > 0 Then
5961: oe_debug_pub.add('G_CODE_RELEASE_LEVEL = '||G_CODE_RELEASE_LEVEL);
5962: End If;
5963:
5964: if p_x_new_line_rec.ordered_quantity2 is not null and G_CODE_RELEASE_LEVEL < '110509' Then
5965: G_OPM_ITEM_CATCHWEIGHT_USED := 'Y';

Line 5978: oe_debug_pub.add( 'LOGGING DELAYED REQUEST FOR MARGIN HOLD FOR BOOKED LINE_ID:'||P_X_NEW_LINE_REC.LINE_ID ) ;

5974: --evaluate margin, margin_hold procedure will hold the order if
5975: --margin falls below a intended setup margin
5976: IF Oe_Sys_Parameters.Value('COMPUTE_MARGIN') <> 'N' Then
5977: IF l_debug_level > 0 THEN
5978: oe_debug_pub.add( 'LOGGING DELAYED REQUEST FOR MARGIN HOLD FOR BOOKED LINE_ID:'||P_X_NEW_LINE_REC.LINE_ID ) ;
5979: END IF;
5980: oe_delayed_requests_pvt.log_request(
5981: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
5982: p_entity_id => p_x_new_line_rec.header_id,

Line 5999: oe_debug_pub.add( 'NEW INV ITEM ID = '||P_X_NEW_LINE_REC.INVENTORY_ITEM_ID , 1 ) ;

5995: --MRG BGN, performance bug 4580260 (fp of bug 4273309)
5996: IF OE_FEATURES_PVT.Is_Margin_Avail
5997: AND p_x_new_line_rec.item_type_code NOT IN ('KIT','MODEL','INCLUDED','CLASS','CONFIG','OPTION') THEN
5998: IF l_debug_level > 0 THEN
5999: oe_debug_pub.add( 'NEW INV ITEM ID = '||P_X_NEW_LINE_REC.INVENTORY_ITEM_ID , 1 ) ;
6000: oe_debug_pub.add( 'OLD INV ITEM ID = '||P_OLD_LINE_REC.INVENTORY_ITEM_ID , 1 ) ;
6001: oe_debug_pub.add( 'NEW SHIP_FROM_ORG_ID = '||P_X_NEW_LINE_REC.SHIP_FROM_ORG_ID , 1 ) ;
6002: oe_debug_pub.add( 'OLD SHIP_FROM_ORG_ID = '||P_OLD_LINE_REC.SHIP_FROM_ORG_ID , 1 ) ;
6003: oe_debug_pub.add( 'NEW PROJECT_ID = '||P_X_NEW_LINE_REC.PROJECT_ID , 1 ) ;

Line 6000: oe_debug_pub.add( 'OLD INV ITEM ID = '||P_OLD_LINE_REC.INVENTORY_ITEM_ID , 1 ) ;

5996: IF OE_FEATURES_PVT.Is_Margin_Avail
5997: AND p_x_new_line_rec.item_type_code NOT IN ('KIT','MODEL','INCLUDED','CLASS','CONFIG','OPTION') THEN
5998: IF l_debug_level > 0 THEN
5999: oe_debug_pub.add( 'NEW INV ITEM ID = '||P_X_NEW_LINE_REC.INVENTORY_ITEM_ID , 1 ) ;
6000: oe_debug_pub.add( 'OLD INV ITEM ID = '||P_OLD_LINE_REC.INVENTORY_ITEM_ID , 1 ) ;
6001: oe_debug_pub.add( 'NEW SHIP_FROM_ORG_ID = '||P_X_NEW_LINE_REC.SHIP_FROM_ORG_ID , 1 ) ;
6002: oe_debug_pub.add( 'OLD SHIP_FROM_ORG_ID = '||P_OLD_LINE_REC.SHIP_FROM_ORG_ID , 1 ) ;
6003: oe_debug_pub.add( 'NEW PROJECT_ID = '||P_X_NEW_LINE_REC.PROJECT_ID , 1 ) ;
6004: oe_debug_pub.add( 'OLD PROJECT_ID = '||P_OLD_LINE_REC.PROJECT_ID , 1 ) ;

Line 6001: oe_debug_pub.add( 'NEW SHIP_FROM_ORG_ID = '||P_X_NEW_LINE_REC.SHIP_FROM_ORG_ID , 1 ) ;

5997: AND p_x_new_line_rec.item_type_code NOT IN ('KIT','MODEL','INCLUDED','CLASS','CONFIG','OPTION') THEN
5998: IF l_debug_level > 0 THEN
5999: oe_debug_pub.add( 'NEW INV ITEM ID = '||P_X_NEW_LINE_REC.INVENTORY_ITEM_ID , 1 ) ;
6000: oe_debug_pub.add( 'OLD INV ITEM ID = '||P_OLD_LINE_REC.INVENTORY_ITEM_ID , 1 ) ;
6001: oe_debug_pub.add( 'NEW SHIP_FROM_ORG_ID = '||P_X_NEW_LINE_REC.SHIP_FROM_ORG_ID , 1 ) ;
6002: oe_debug_pub.add( 'OLD SHIP_FROM_ORG_ID = '||P_OLD_LINE_REC.SHIP_FROM_ORG_ID , 1 ) ;
6003: oe_debug_pub.add( 'NEW PROJECT_ID = '||P_X_NEW_LINE_REC.PROJECT_ID , 1 ) ;
6004: oe_debug_pub.add( 'OLD PROJECT_ID = '||P_OLD_LINE_REC.PROJECT_ID , 1 ) ;
6005: oe_debug_pub.add( 'NEW ACTUAL_SHIPMENT_DATE = '||P_X_NEW_LINE_REC.ACTUAL_SHIPMENT_DATE , 1 ) ;

Line 6002: oe_debug_pub.add( 'OLD SHIP_FROM_ORG_ID = '||P_OLD_LINE_REC.SHIP_FROM_ORG_ID , 1 ) ;

5998: IF l_debug_level > 0 THEN
5999: oe_debug_pub.add( 'NEW INV ITEM ID = '||P_X_NEW_LINE_REC.INVENTORY_ITEM_ID , 1 ) ;
6000: oe_debug_pub.add( 'OLD INV ITEM ID = '||P_OLD_LINE_REC.INVENTORY_ITEM_ID , 1 ) ;
6001: oe_debug_pub.add( 'NEW SHIP_FROM_ORG_ID = '||P_X_NEW_LINE_REC.SHIP_FROM_ORG_ID , 1 ) ;
6002: oe_debug_pub.add( 'OLD SHIP_FROM_ORG_ID = '||P_OLD_LINE_REC.SHIP_FROM_ORG_ID , 1 ) ;
6003: oe_debug_pub.add( 'NEW PROJECT_ID = '||P_X_NEW_LINE_REC.PROJECT_ID , 1 ) ;
6004: oe_debug_pub.add( 'OLD PROJECT_ID = '||P_OLD_LINE_REC.PROJECT_ID , 1 ) ;
6005: oe_debug_pub.add( 'NEW ACTUAL_SHIPMENT_DATE = '||P_X_NEW_LINE_REC.ACTUAL_SHIPMENT_DATE , 1 ) ;
6006: oe_debug_pub.add( 'OLD ACTUAL_SHIPMENT_DATE = '||P_OLD_LINE_REC.ACTUAL_SHIPMENT_DATE , 1 ) ;

Line 6003: oe_debug_pub.add( 'NEW PROJECT_ID = '||P_X_NEW_LINE_REC.PROJECT_ID , 1 ) ;

5999: oe_debug_pub.add( 'NEW INV ITEM ID = '||P_X_NEW_LINE_REC.INVENTORY_ITEM_ID , 1 ) ;
6000: oe_debug_pub.add( 'OLD INV ITEM ID = '||P_OLD_LINE_REC.INVENTORY_ITEM_ID , 1 ) ;
6001: oe_debug_pub.add( 'NEW SHIP_FROM_ORG_ID = '||P_X_NEW_LINE_REC.SHIP_FROM_ORG_ID , 1 ) ;
6002: oe_debug_pub.add( 'OLD SHIP_FROM_ORG_ID = '||P_OLD_LINE_REC.SHIP_FROM_ORG_ID , 1 ) ;
6003: oe_debug_pub.add( 'NEW PROJECT_ID = '||P_X_NEW_LINE_REC.PROJECT_ID , 1 ) ;
6004: oe_debug_pub.add( 'OLD PROJECT_ID = '||P_OLD_LINE_REC.PROJECT_ID , 1 ) ;
6005: oe_debug_pub.add( 'NEW ACTUAL_SHIPMENT_DATE = '||P_X_NEW_LINE_REC.ACTUAL_SHIPMENT_DATE , 1 ) ;
6006: oe_debug_pub.add( 'OLD ACTUAL_SHIPMENT_DATE = '||P_OLD_LINE_REC.ACTUAL_SHIPMENT_DATE , 1 ) ;
6007: oe_debug_pub.add( 'NEW FULFILLMENT_DATE = '||P_X_NEW_LINE_REC.FULFILLMENT_DATE , 1 ) ;

Line 6004: oe_debug_pub.add( 'OLD PROJECT_ID = '||P_OLD_LINE_REC.PROJECT_ID , 1 ) ;

6000: oe_debug_pub.add( 'OLD INV ITEM ID = '||P_OLD_LINE_REC.INVENTORY_ITEM_ID , 1 ) ;
6001: oe_debug_pub.add( 'NEW SHIP_FROM_ORG_ID = '||P_X_NEW_LINE_REC.SHIP_FROM_ORG_ID , 1 ) ;
6002: oe_debug_pub.add( 'OLD SHIP_FROM_ORG_ID = '||P_OLD_LINE_REC.SHIP_FROM_ORG_ID , 1 ) ;
6003: oe_debug_pub.add( 'NEW PROJECT_ID = '||P_X_NEW_LINE_REC.PROJECT_ID , 1 ) ;
6004: oe_debug_pub.add( 'OLD PROJECT_ID = '||P_OLD_LINE_REC.PROJECT_ID , 1 ) ;
6005: oe_debug_pub.add( 'NEW ACTUAL_SHIPMENT_DATE = '||P_X_NEW_LINE_REC.ACTUAL_SHIPMENT_DATE , 1 ) ;
6006: oe_debug_pub.add( 'OLD ACTUAL_SHIPMENT_DATE = '||P_OLD_LINE_REC.ACTUAL_SHIPMENT_DATE , 1 ) ;
6007: oe_debug_pub.add( 'NEW FULFILLMENT_DATE = '||P_X_NEW_LINE_REC.FULFILLMENT_DATE , 1 ) ;
6008: oe_debug_pub.add( 'OLD FULFILLMENT_DATE = '||P_OLD_LINE_REC.FULFILLMENT_DATE , 1 ) ;

Line 6005: oe_debug_pub.add( 'NEW ACTUAL_SHIPMENT_DATE = '||P_X_NEW_LINE_REC.ACTUAL_SHIPMENT_DATE , 1 ) ;

6001: oe_debug_pub.add( 'NEW SHIP_FROM_ORG_ID = '||P_X_NEW_LINE_REC.SHIP_FROM_ORG_ID , 1 ) ;
6002: oe_debug_pub.add( 'OLD SHIP_FROM_ORG_ID = '||P_OLD_LINE_REC.SHIP_FROM_ORG_ID , 1 ) ;
6003: oe_debug_pub.add( 'NEW PROJECT_ID = '||P_X_NEW_LINE_REC.PROJECT_ID , 1 ) ;
6004: oe_debug_pub.add( 'OLD PROJECT_ID = '||P_OLD_LINE_REC.PROJECT_ID , 1 ) ;
6005: oe_debug_pub.add( 'NEW ACTUAL_SHIPMENT_DATE = '||P_X_NEW_LINE_REC.ACTUAL_SHIPMENT_DATE , 1 ) ;
6006: oe_debug_pub.add( 'OLD ACTUAL_SHIPMENT_DATE = '||P_OLD_LINE_REC.ACTUAL_SHIPMENT_DATE , 1 ) ;
6007: oe_debug_pub.add( 'NEW FULFILLMENT_DATE = '||P_X_NEW_LINE_REC.FULFILLMENT_DATE , 1 ) ;
6008: oe_debug_pub.add( 'OLD FULFILLMENT_DATE = '||P_OLD_LINE_REC.FULFILLMENT_DATE , 1 ) ;
6009: oe_debug_pub.add( 'NEW PRICING_DATE = '||P_X_NEW_LINE_REC.PRICING_DATE , 1 ) ;

Line 6006: oe_debug_pub.add( 'OLD ACTUAL_SHIPMENT_DATE = '||P_OLD_LINE_REC.ACTUAL_SHIPMENT_DATE , 1 ) ;

6002: oe_debug_pub.add( 'OLD SHIP_FROM_ORG_ID = '||P_OLD_LINE_REC.SHIP_FROM_ORG_ID , 1 ) ;
6003: oe_debug_pub.add( 'NEW PROJECT_ID = '||P_X_NEW_LINE_REC.PROJECT_ID , 1 ) ;
6004: oe_debug_pub.add( 'OLD PROJECT_ID = '||P_OLD_LINE_REC.PROJECT_ID , 1 ) ;
6005: oe_debug_pub.add( 'NEW ACTUAL_SHIPMENT_DATE = '||P_X_NEW_LINE_REC.ACTUAL_SHIPMENT_DATE , 1 ) ;
6006: oe_debug_pub.add( 'OLD ACTUAL_SHIPMENT_DATE = '||P_OLD_LINE_REC.ACTUAL_SHIPMENT_DATE , 1 ) ;
6007: oe_debug_pub.add( 'NEW FULFILLMENT_DATE = '||P_X_NEW_LINE_REC.FULFILLMENT_DATE , 1 ) ;
6008: oe_debug_pub.add( 'OLD FULFILLMENT_DATE = '||P_OLD_LINE_REC.FULFILLMENT_DATE , 1 ) ;
6009: oe_debug_pub.add( 'NEW PRICING_DATE = '||P_X_NEW_LINE_REC.PRICING_DATE , 1 ) ;
6010: oe_debug_pub.add( 'OLD PRICING_DATE = '||P_OLD_LINE_REC.PRICING_DATE , 1 ) ;

Line 6007: oe_debug_pub.add( 'NEW FULFILLMENT_DATE = '||P_X_NEW_LINE_REC.FULFILLMENT_DATE , 1 ) ;

6003: oe_debug_pub.add( 'NEW PROJECT_ID = '||P_X_NEW_LINE_REC.PROJECT_ID , 1 ) ;
6004: oe_debug_pub.add( 'OLD PROJECT_ID = '||P_OLD_LINE_REC.PROJECT_ID , 1 ) ;
6005: oe_debug_pub.add( 'NEW ACTUAL_SHIPMENT_DATE = '||P_X_NEW_LINE_REC.ACTUAL_SHIPMENT_DATE , 1 ) ;
6006: oe_debug_pub.add( 'OLD ACTUAL_SHIPMENT_DATE = '||P_OLD_LINE_REC.ACTUAL_SHIPMENT_DATE , 1 ) ;
6007: oe_debug_pub.add( 'NEW FULFILLMENT_DATE = '||P_X_NEW_LINE_REC.FULFILLMENT_DATE , 1 ) ;
6008: oe_debug_pub.add( 'OLD FULFILLMENT_DATE = '||P_OLD_LINE_REC.FULFILLMENT_DATE , 1 ) ;
6009: oe_debug_pub.add( 'NEW PRICING_DATE = '||P_X_NEW_LINE_REC.PRICING_DATE , 1 ) ;
6010: oe_debug_pub.add( 'OLD PRICING_DATE = '||P_OLD_LINE_REC.PRICING_DATE , 1 ) ;
6011: END IF;

Line 6008: oe_debug_pub.add( 'OLD FULFILLMENT_DATE = '||P_OLD_LINE_REC.FULFILLMENT_DATE , 1 ) ;

6004: oe_debug_pub.add( 'OLD PROJECT_ID = '||P_OLD_LINE_REC.PROJECT_ID , 1 ) ;
6005: oe_debug_pub.add( 'NEW ACTUAL_SHIPMENT_DATE = '||P_X_NEW_LINE_REC.ACTUAL_SHIPMENT_DATE , 1 ) ;
6006: oe_debug_pub.add( 'OLD ACTUAL_SHIPMENT_DATE = '||P_OLD_LINE_REC.ACTUAL_SHIPMENT_DATE , 1 ) ;
6007: oe_debug_pub.add( 'NEW FULFILLMENT_DATE = '||P_X_NEW_LINE_REC.FULFILLMENT_DATE , 1 ) ;
6008: oe_debug_pub.add( 'OLD FULFILLMENT_DATE = '||P_OLD_LINE_REC.FULFILLMENT_DATE , 1 ) ;
6009: oe_debug_pub.add( 'NEW PRICING_DATE = '||P_X_NEW_LINE_REC.PRICING_DATE , 1 ) ;
6010: oe_debug_pub.add( 'OLD PRICING_DATE = '||P_OLD_LINE_REC.PRICING_DATE , 1 ) ;
6011: END IF;
6012:

Line 6009: oe_debug_pub.add( 'NEW PRICING_DATE = '||P_X_NEW_LINE_REC.PRICING_DATE , 1 ) ;

6005: oe_debug_pub.add( 'NEW ACTUAL_SHIPMENT_DATE = '||P_X_NEW_LINE_REC.ACTUAL_SHIPMENT_DATE , 1 ) ;
6006: oe_debug_pub.add( 'OLD ACTUAL_SHIPMENT_DATE = '||P_OLD_LINE_REC.ACTUAL_SHIPMENT_DATE , 1 ) ;
6007: oe_debug_pub.add( 'NEW FULFILLMENT_DATE = '||P_X_NEW_LINE_REC.FULFILLMENT_DATE , 1 ) ;
6008: oe_debug_pub.add( 'OLD FULFILLMENT_DATE = '||P_OLD_LINE_REC.FULFILLMENT_DATE , 1 ) ;
6009: oe_debug_pub.add( 'NEW PRICING_DATE = '||P_X_NEW_LINE_REC.PRICING_DATE , 1 ) ;
6010: oe_debug_pub.add( 'OLD PRICING_DATE = '||P_OLD_LINE_REC.PRICING_DATE , 1 ) ;
6011: END IF;
6012:
6013: IF NOT OE_GLOBALS.Equal(p_x_new_line_rec.inventory_item_id,p_old_line_rec.inventory_item_id)

Line 6010: oe_debug_pub.add( 'OLD PRICING_DATE = '||P_OLD_LINE_REC.PRICING_DATE , 1 ) ;

6006: oe_debug_pub.add( 'OLD ACTUAL_SHIPMENT_DATE = '||P_OLD_LINE_REC.ACTUAL_SHIPMENT_DATE , 1 ) ;
6007: oe_debug_pub.add( 'NEW FULFILLMENT_DATE = '||P_X_NEW_LINE_REC.FULFILLMENT_DATE , 1 ) ;
6008: oe_debug_pub.add( 'OLD FULFILLMENT_DATE = '||P_OLD_LINE_REC.FULFILLMENT_DATE , 1 ) ;
6009: oe_debug_pub.add( 'NEW PRICING_DATE = '||P_X_NEW_LINE_REC.PRICING_DATE , 1 ) ;
6010: oe_debug_pub.add( 'OLD PRICING_DATE = '||P_OLD_LINE_REC.PRICING_DATE , 1 ) ;
6011: END IF;
6012:
6013: IF NOT OE_GLOBALS.Equal(p_x_new_line_rec.inventory_item_id,p_old_line_rec.inventory_item_id)
6014: OR NOT OE_GLOBALS.Equal(p_x_new_line_rec.ship_from_org_id,p_old_line_rec.ship_from_org_id)

Line 6022: oe_debug_pub.add( 'BEFORE OE_DELAYED_REQUESTS_PVT.LOG_REQUEST CALL' ) ;

6018: OR NOT OE_GLOBALS.Equal(p_x_new_line_rec.pricing_date,p_old_line_rec.pricing_date)
6019: THEN
6020: IF Oe_Sys_Parameters.Value('COMPUTE_MARGIN') <> 'N' Then
6021: IF l_debug_level > 0 THEN
6022: oe_debug_pub.add( 'BEFORE OE_DELAYED_REQUESTS_PVT.LOG_REQUEST CALL' ) ;
6023: oe_debug_pub.add( 'IN PROCESS_PRICING OEXULADB.PLS' ) ;
6024: END IF;
6025:
6026: oe_delayed_requests_pvt.log_request(

Line 6023: oe_debug_pub.add( 'IN PROCESS_PRICING OEXULADB.PLS' ) ;

6019: THEN
6020: IF Oe_Sys_Parameters.Value('COMPUTE_MARGIN') <> 'N' Then
6021: IF l_debug_level > 0 THEN
6022: oe_debug_pub.add( 'BEFORE OE_DELAYED_REQUESTS_PVT.LOG_REQUEST CALL' ) ;
6023: oe_debug_pub.add( 'IN PROCESS_PRICING OEXULADB.PLS' ) ;
6024: END IF;
6025:
6026: oe_delayed_requests_pvt.log_request(
6027: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,

Line 6043: oe_debug_pub.add( 'LEAVING OE_LINE_ADJ_UTIL.PROCESS_PRICING' ) ;

6039:
6040: l_pricing_related_changes :=False;
6041: l_margin_related_changes :=False;
6042: IF l_debug_level > 0 THEN
6043: oe_debug_pub.add( 'LEAVING OE_LINE_ADJ_UTIL.PROCESS_PRICING' ) ;
6044: END IF;
6045: End Process_Pricing;
6046:
6047: Procedure Log_Pricing_Requests (p_x_new_line_rec in Out Nocopy Oe_Order_Pub.Line_Rec_Type,

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

6055: l_return_status Varchar2(5);
6056: i PLS_INTEGER;
6057: l_x_result_out Varchar2(5);
6058: --
6059: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6060: --
6061: Begin
6062:
6063: IF p_price_flag = 'Y' and

Line 6119: oe_debug_pub.add( 'LOGGING DELAYED REQUEST FOR PRICING' ) ;

6115: End If;
6116: End If; --end if for UI Flag Check
6117:
6118: IF l_debug_level > 0 THEN
6119: oe_debug_pub.add( 'LOGGING DELAYED REQUEST FOR PRICING' ) ;
6120: END IF;
6121:
6122: IF ((OE_GLOBALS.G_UI_FLAG) and (nvl(Oe_Config_Pvt.oecfg_configuration_pricing,'N')='N')) OR
6123: p_x_new_line_rec.item_type_code = 'INCLUDED' THEN

Line 6125: oe_debug_pub.add( 'UI MODE OR CONFIG , INCLUDED ITEM'||P_X_NEW_LINE_REC.LINE_ID ) ;

6121:
6122: IF ((OE_GLOBALS.G_UI_FLAG) and (nvl(Oe_Config_Pvt.oecfg_configuration_pricing,'N')='N')) OR
6123: p_x_new_line_rec.item_type_code = 'INCLUDED' THEN
6124: IF l_debug_level > 0 THEN
6125: oe_debug_pub.add( 'UI MODE OR CONFIG , INCLUDED ITEM'||P_X_NEW_LINE_REC.LINE_ID ) ;
6126: END IF;
6127: IF NOT l_zero_line_qty THEN
6128: --bsadri don't call this for a cancelled line
6129: OE_delayed_requests_Pvt.log_request(

Line 6155: oe_debug_pub.add( 'BATCH MODE' ) ;

6151: x_return_status => l_return_status);
6152: END IF;
6153: ELSE
6154: IF l_debug_level > 0 THEN
6155: oe_debug_pub.add( 'BATCH MODE' ) ;
6156: END IF;
6157:
6158: OE_delayed_requests_Pvt.log_request(
6159: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

Line 6194: oe_debug_pub.add( 'PRICE_FLAG = ' || P_PRICE_FLAG ) ;

6190:
6191: */
6192:
6193: IF l_debug_level > 0 THEN
6194: oe_debug_pub.add( 'PRICE_FLAG = ' || P_PRICE_FLAG ) ;
6195: oe_debug_pub.add( 'G_PRICING_RECURSION = ' || OE_GLOBALS.G_PRICING_RECURSION ) ;
6196: oe_debug_pub.add( 'ORDERED QUANTITY = '|| TO_CHAR ( P_X_NEW_LINE_REC.ORDERED_QUANTITY ) ) ;
6197: oe_debug_pub.add( 'ORDERED QTY UOM = ' || P_X_NEW_LINE_REC.ORDER_QUANTITY_UOM ) ;
6198: oe_debug_pub.add( 'CALCULATE_PRICE_FLAG = '|| P_X_NEW_LINE_REC.CALCULATE_PRICE_FLAG ) ;

Line 6195: oe_debug_pub.add( 'G_PRICING_RECURSION = ' || OE_GLOBALS.G_PRICING_RECURSION ) ;

6191: */
6192:
6193: IF l_debug_level > 0 THEN
6194: oe_debug_pub.add( 'PRICE_FLAG = ' || P_PRICE_FLAG ) ;
6195: oe_debug_pub.add( 'G_PRICING_RECURSION = ' || OE_GLOBALS.G_PRICING_RECURSION ) ;
6196: oe_debug_pub.add( 'ORDERED QUANTITY = '|| TO_CHAR ( P_X_NEW_LINE_REC.ORDERED_QUANTITY ) ) ;
6197: oe_debug_pub.add( 'ORDERED QTY UOM = ' || P_X_NEW_LINE_REC.ORDER_QUANTITY_UOM ) ;
6198: oe_debug_pub.add( 'CALCULATE_PRICE_FLAG = '|| P_X_NEW_LINE_REC.CALCULATE_PRICE_FLAG ) ;
6199: END IF;

Line 6196: oe_debug_pub.add( 'ORDERED QUANTITY = '|| TO_CHAR ( P_X_NEW_LINE_REC.ORDERED_QUANTITY ) ) ;

6192:
6193: IF l_debug_level > 0 THEN
6194: oe_debug_pub.add( 'PRICE_FLAG = ' || P_PRICE_FLAG ) ;
6195: oe_debug_pub.add( 'G_PRICING_RECURSION = ' || OE_GLOBALS.G_PRICING_RECURSION ) ;
6196: oe_debug_pub.add( 'ORDERED QUANTITY = '|| TO_CHAR ( P_X_NEW_LINE_REC.ORDERED_QUANTITY ) ) ;
6197: oe_debug_pub.add( 'ORDERED QTY UOM = ' || P_X_NEW_LINE_REC.ORDER_QUANTITY_UOM ) ;
6198: oe_debug_pub.add( 'CALCULATE_PRICE_FLAG = '|| P_X_NEW_LINE_REC.CALCULATE_PRICE_FLAG ) ;
6199: END IF;
6200:

Line 6197: oe_debug_pub.add( 'ORDERED QTY UOM = ' || P_X_NEW_LINE_REC.ORDER_QUANTITY_UOM ) ;

6193: IF l_debug_level > 0 THEN
6194: oe_debug_pub.add( 'PRICE_FLAG = ' || P_PRICE_FLAG ) ;
6195: oe_debug_pub.add( 'G_PRICING_RECURSION = ' || OE_GLOBALS.G_PRICING_RECURSION ) ;
6196: oe_debug_pub.add( 'ORDERED QUANTITY = '|| TO_CHAR ( P_X_NEW_LINE_REC.ORDERED_QUANTITY ) ) ;
6197: oe_debug_pub.add( 'ORDERED QTY UOM = ' || P_X_NEW_LINE_REC.ORDER_QUANTITY_UOM ) ;
6198: oe_debug_pub.add( 'CALCULATE_PRICE_FLAG = '|| P_X_NEW_LINE_REC.CALCULATE_PRICE_FLAG ) ;
6199: END IF;
6200:
6201:

Line 6198: oe_debug_pub.add( 'CALCULATE_PRICE_FLAG = '|| P_X_NEW_LINE_REC.CALCULATE_PRICE_FLAG ) ;

6194: oe_debug_pub.add( 'PRICE_FLAG = ' || P_PRICE_FLAG ) ;
6195: oe_debug_pub.add( 'G_PRICING_RECURSION = ' || OE_GLOBALS.G_PRICING_RECURSION ) ;
6196: oe_debug_pub.add( 'ORDERED QUANTITY = '|| TO_CHAR ( P_X_NEW_LINE_REC.ORDERED_QUANTITY ) ) ;
6197: oe_debug_pub.add( 'ORDERED QTY UOM = ' || P_X_NEW_LINE_REC.ORDER_QUANTITY_UOM ) ;
6198: oe_debug_pub.add( 'CALCULATE_PRICE_FLAG = '|| P_X_NEW_LINE_REC.CALCULATE_PRICE_FLAG ) ;
6199: END IF;
6200:
6201:
6202: if (p_price_flag = 'Y' and

Line 6213: oe_debug_pub.add( 'NEW LINE CREATED BY PROMOTIONAL MODIFIER' ) ;

6209: p_x_new_line_rec.calculate_price_flag = 'R')
6210: then
6211:
6212: IF l_debug_level > 0 THEN
6213: oe_debug_pub.add( 'NEW LINE CREATED BY PROMOTIONAL MODIFIER' ) ;
6214: oe_debug_pub.add( 'RESETTING CALC. PRICE. FLAG TO P' ) ;
6215: END IF;
6216: p_x_new_line_rec.calculate_price_flag := 'P';
6217: IF l_debug_level > 0 THEN

Line 6214: oe_debug_pub.add( 'RESETTING CALC. PRICE. FLAG TO P' ) ;

6210: then
6211:
6212: IF l_debug_level > 0 THEN
6213: oe_debug_pub.add( 'NEW LINE CREATED BY PROMOTIONAL MODIFIER' ) ;
6214: oe_debug_pub.add( 'RESETTING CALC. PRICE. FLAG TO P' ) ;
6215: END IF;
6216: p_x_new_line_rec.calculate_price_flag := 'P';
6217: IF l_debug_level > 0 THEN
6218: oe_debug_pub.add( 'LOGGING A REQUEST TO PRICE_LINE IN BATCH MODE' ) ;

Line 6218: oe_debug_pub.add( 'LOGGING A REQUEST TO PRICE_LINE IN BATCH MODE' ) ;

6214: oe_debug_pub.add( 'RESETTING CALC. PRICE. FLAG TO P' ) ;
6215: END IF;
6216: p_x_new_line_rec.calculate_price_flag := 'P';
6217: IF l_debug_level > 0 THEN
6218: oe_debug_pub.add( 'LOGGING A REQUEST TO PRICE_LINE IN BATCH MODE' ) ;
6219: END IF;
6220: OE_delayed_requests_Pvt.log_request(
6221: p_entity_code =>OE_GLOBALS.G_ENTITY_ALL,
6222: p_entity_id => p_x_new_line_rec.line_Id,

Line 6234: oe_debug_pub.add( 'BOOKED ORDER -- LOG A REQUEST TO PRICE LINE' ) ;

6230:
6231: if (p_x_new_line_rec.booked_flag = 'Y')
6232: then
6233: IF l_debug_level > 0 THEN
6234: oe_debug_pub.add( 'BOOKED ORDER -- LOG A REQUEST TO PRICE LINE' ) ;
6235: END IF;
6236: OE_delayed_requests_Pvt.log_request(
6237: p_entity_code =>OE_GLOBALS.G_ENTITY_ALL,
6238: p_entity_id => p_x_new_line_rec.line_Id,

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

6313: l_order_status_rec QP_UTIL_PUB.ORDER_LINES_STATUS_REC_TYPE;
6314: l_return_status Varchar2(5);
6315: l_event_str Varchar2(25);
6316: --
6317: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6318: --
6319: Begin
6320:
6321: --User trying to cancle line, different processing for cancelation due to performance

Line 6324: oe_debug_pub.add( ' ENTERING PROCESS_CANCELLED_LINES' ) ;

6320:
6321: --User trying to cancle line, different processing for cancelation due to performance
6322: --considerations
6323: IF l_debug_level > 0 THEN
6324: oe_debug_pub.add( ' ENTERING PROCESS_CANCELLED_LINES' ) ;
6325: END IF;
6326:
6327: ------------------------------------------------------
6328: --Special case, bypass regular pricing path

Line 6341: oe_debug_pub.add( ' ALL LINES FLAG RETURNED FROM QP_UTIL_PUB:'||L_ORDER_STATUS_REC.ALL_LINES_FLAG ) ;

6337: --line has no effect since the quantity is 0. Therefore, only pass
6338: --all the lines to pricing engine when all_lines_flag = 'Y'
6339: ----------------------------------------------------------------------
6340: IF l_debug_level > 0 THEN
6341: oe_debug_pub.add( ' ALL LINES FLAG RETURNED FROM QP_UTIL_PUB:'||L_ORDER_STATUS_REC.ALL_LINES_FLAG ) ;
6342: oe_debug_pub.add( ' CHANGED LINES FLAG RETURNED FROM QP_UTIL_PUB:'||L_ORDER_STATUS_REC.CHANGED_LINES_FLAG ) ;
6343: oe_debug_pub.add( ' SUMMARY LINE FLAG RETURNED FROM QP_UTIL_PUB:'||L_ORDER_STATUS_REC.SUMMARY_LINE_FLAG ) ;
6344: END IF;
6345:

Line 6342: oe_debug_pub.add( ' CHANGED LINES FLAG RETURNED FROM QP_UTIL_PUB:'||L_ORDER_STATUS_REC.CHANGED_LINES_FLAG ) ;

6338: --all the lines to pricing engine when all_lines_flag = 'Y'
6339: ----------------------------------------------------------------------
6340: IF l_debug_level > 0 THEN
6341: oe_debug_pub.add( ' ALL LINES FLAG RETURNED FROM QP_UTIL_PUB:'||L_ORDER_STATUS_REC.ALL_LINES_FLAG ) ;
6342: oe_debug_pub.add( ' CHANGED LINES FLAG RETURNED FROM QP_UTIL_PUB:'||L_ORDER_STATUS_REC.CHANGED_LINES_FLAG ) ;
6343: oe_debug_pub.add( ' SUMMARY LINE FLAG RETURNED FROM QP_UTIL_PUB:'||L_ORDER_STATUS_REC.SUMMARY_LINE_FLAG ) ;
6344: END IF;
6345:
6346:

Line 6343: oe_debug_pub.add( ' SUMMARY LINE FLAG RETURNED FROM QP_UTIL_PUB:'||L_ORDER_STATUS_REC.SUMMARY_LINE_FLAG ) ;

6339: ----------------------------------------------------------------------
6340: IF l_debug_level > 0 THEN
6341: oe_debug_pub.add( ' ALL LINES FLAG RETURNED FROM QP_UTIL_PUB:'||L_ORDER_STATUS_REC.ALL_LINES_FLAG ) ;
6342: oe_debug_pub.add( ' CHANGED LINES FLAG RETURNED FROM QP_UTIL_PUB:'||L_ORDER_STATUS_REC.CHANGED_LINES_FLAG ) ;
6343: oe_debug_pub.add( ' SUMMARY LINE FLAG RETURNED FROM QP_UTIL_PUB:'||L_ORDER_STATUS_REC.SUMMARY_LINE_FLAG ) ;
6344: END IF;
6345:
6346:
6347:

Line 6350: oe_debug_pub.add( ' USER HAS TOTALLY CANCELLED THE LINE' ) ;

6346:
6347:
6348: If p_x_new_line_rec.ordered_quantity = 0 Then
6349: IF l_debug_level > 0 THEN
6350: oe_debug_pub.add( ' USER HAS TOTALLY CANCELLED THE LINE' ) ;
6351: END IF;
6352:
6353: If p_x_new_line_rec.booked_flag = 'Y' Then
6354: l_event_str:= 'ORDER,BOOK';

Line 6377: oe_debug_pub.add( 'LOG REVERSE_LIMITS DELAYED REQUEST FROM PROCESS_CANCELLED_LINES ' , 1 ) ;

6373: End If;
6374: End If;
6375: /* BUG 2013611 BEGIN */
6376: IF l_debug_level > 0 THEN
6377: oe_debug_pub.add( 'LOG REVERSE_LIMITS DELAYED REQUEST FROM PROCESS_CANCELLED_LINES ' , 1 ) ;
6378: END IF;
6379: OE_delayed_requests_Pvt.log_request(
6380: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
6381: p_entity_id => p_x_new_line_rec.line_id,

Line 6394: oe_debug_pub.add( 'REVERSE_LIMITS DELAYED REQUEST HAS BEEN LOGGED' , 1 ) ;

6390: p_param6 => NULL,
6391: p_request_type => OE_GLOBALS.G_REVERSE_LIMITS,
6392: x_return_status => l_return_status);
6393: IF l_debug_level > 0 THEN
6394: oe_debug_pub.add( 'REVERSE_LIMITS DELAYED REQUEST HAS BEEN LOGGED' , 1 ) ;
6395: END IF;
6396: /* BUG 2013611 END */
6397: Else --User partially cancel the line
6398: IF l_debug_level > 0 THEN

Line 6399: oe_debug_pub.add( ' USER HAS PARTIALLY CANCELLED THE LINE' ) ;

6395: END IF;
6396: /* BUG 2013611 END */
6397: Else --User partially cancel the line
6398: IF l_debug_level > 0 THEN
6399: oe_debug_pub.add( ' USER HAS PARTIALLY CANCELLED THE LINE' ) ;
6400: END IF;
6401:
6402:
6403: If p_x_new_line_rec.booked_flag = 'Y' Then

Line 6435: oe_debug_pub.add( 'LOG REVERSE_LIMITS DELAYED REQUEST FROM

6431:
6432: --bug7491829
6433:
6434: IF l_debug_level > 0 THEN
6435: oe_debug_pub.add( 'LOG REVERSE_LIMITS DELAYED REQUEST FROM
6436: PROCESS_CANCELLED_LINES FOR PARTIAL CANCEL CASE' , 1 ) ;
6437: END IF;
6438:
6439: OE_delayed_requests_Pvt.log_request(

Line 6455: oe_debug_pub.add( 'REVERSE_LIMITS DELAYED REQUEST HAS BEEN LOGGED' , 1 ) ;

6451: p_request_type =>OE_GLOBALS.G_REVERSE_LIMITS,
6452: x_return_status => l_return_status);
6453:
6454: IF l_debug_level > 0 THEN
6455: oe_debug_pub.add( 'REVERSE_LIMITS DELAYED REQUEST HAS BEEN LOGGED' , 1 ) ;
6456: END IF;
6457:
6458: --bug7491829
6459:

Line 6463: oe_debug_pub.add( ' LEAVING PROCESS_CANCELLED_LINES' ) ;

6459:
6460: End If;
6461:
6462: IF l_debug_level > 0 THEN
6463: oe_debug_pub.add( ' LEAVING PROCESS_CANCELLED_LINES' ) ;
6464: END IF;
6465: End;
6466:
6467: /*----------------------------------------------------------------------------*/

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

6471: p_header_id in Number,
6472: p_operation in Varchar2) Is
6473: l_return_status Varchar2(15);
6474: --
6475: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6476: --
6477: Begin
6478: IF l_debug_level > 0 THEN
6479: oe_debug_pub.add( ' ENTERING OE_LINE_ADJ_UTIL.REGISTER_CHANGED_LINES' ) ;

Line 6479: oe_debug_pub.add( ' ENTERING OE_LINE_ADJ_UTIL.REGISTER_CHANGED_LINES' ) ;

6475: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6476: --
6477: Begin
6478: IF l_debug_level > 0 THEN
6479: oe_debug_pub.add( ' ENTERING OE_LINE_ADJ_UTIL.REGISTER_CHANGED_LINES' ) ;
6480: oe_debug_pub.add( ' P_LINE_ID:'||P_LINE_ID||'+P_HEADER_ID:'||P_HEADER_ID ) ;
6481: END IF;
6482:
6483: -----------------------------------------------------------------------------------

Line 6480: oe_debug_pub.add( ' P_LINE_ID:'||P_LINE_ID||'+P_HEADER_ID:'||P_HEADER_ID ) ;

6476: --
6477: Begin
6478: IF l_debug_level > 0 THEN
6479: oe_debug_pub.add( ' ENTERING OE_LINE_ADJ_UTIL.REGISTER_CHANGED_LINES' ) ;
6480: oe_debug_pub.add( ' P_LINE_ID:'||P_LINE_ID||'+P_HEADER_ID:'||P_HEADER_ID ) ;
6481: END IF;
6482:
6483: -----------------------------------------------------------------------------------
6484: --For performance reason, we only need to log delay request to reset the cache once

Line 6491: oe_debug_pub.add( ' LOGGING DELAYED REQUEST TO RESET G_CHANGED_LINE_TBL' ) ;

6487: --the cahce has been logged; therefore, I need not log it.
6488: ------------------------------------------------------------------------------------
6489: If G_CHANGED_LINE_TBL.Count = 0 Then
6490: IF l_debug_level > 0 THEN
6491: oe_debug_pub.add( ' LOGGING DELAYED REQUEST TO RESET G_CHANGED_LINE_TBL' ) ;
6492: END IF;
6493: oe_delayed_requests_pvt.log_request(
6494: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6495: p_entity_id => p_header_id,

Line 6501: oe_debug_pub.add( ' RETURN STATUS FROM THE DELAYED REQUEST:'||L_RETURN_STATUS ) ;

6497: p_requesting_entity_id => p_header_id,
6498: p_request_type => OE_GLOBALS.G_DEL_CHG_LINES,
6499: x_return_status => l_return_status);
6500: IF l_debug_level > 0 THEN
6501: oe_debug_pub.add( ' RETURN STATUS FROM THE DELAYED REQUEST:'||L_RETURN_STATUS ) ;
6502: END IF;
6503: End If;
6504:
6505: If p_operation In (OE_GLOBALS.G_OPR_CREATE,OE_GLOBALS.G_OPR_UPDATE) Then

Line 6517: oe_debug_pub.add( ' LEAVING OE_LINE_ADJ_UTIL.REGISTER_CHANGED_LINES' ) ;

6513: End If;
6514: End If;
6515:
6516: IF l_debug_level > 0 THEN
6517: oe_debug_pub.add( ' LEAVING OE_LINE_ADJ_UTIL.REGISTER_CHANGED_LINES' ) ;
6518: END IF;
6519: End;
6520:
6521: Procedure Get_Service_Lines(p_header_id IN NUMBER,

Line 6545: Oe_Debug_Pub.add(' Entering OE_LINE_ADJ_UTIL.Change_adj_for_uom_change');

6541: l_old_pricing_qty NUMBER;
6542: l_new_pricing_qty NUMBER;
6543:
6544: Begin
6545: Oe_Debug_Pub.add(' Entering OE_LINE_ADJ_UTIL.Change_adj_for_uom_change');
6546:
6547: IF p_x_line_rec.Pricing_quantity is not null and
6548: p_x_line_rec.Pricing_quantity <> FND_API.G_MISS_NUM and
6549: p_x_line_rec.Pricing_quantity <> 0 THEN

Line 6576: Oe_Debug_Pub.add(' Leaving OE_LINE_ADJ_UTIL.Change_adj_for_uom_change');

6572: and updated_flag = 'Y'
6573: and arithmetic_operator in ('AMT' , 'NEWPRICE');
6574: END IF;
6575:
6576: Oe_Debug_Pub.add(' Leaving OE_LINE_ADJ_UTIL.Change_adj_for_uom_change');
6577: End;
6578:
6579: /* End of the procedure added to fix the bug 2917690 */
6580: