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_ORDER_PRICE_PVT dependencies on OE_ORDER_PUB

Line 235: x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type

231: -- Function Query_Header
232:
233: PROCEDURE Query_Header
234: ( p_header_id IN NUMBER,
235: x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
236: )
237: IS
238: l_org_id NUMBER;
239: l_x_header_rec_oper VARCHAR2(30);

Line 337: , x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type

333:
334: PROCEDURE Query_Lines
335: ( p_line_id IN NUMBER
336: , p_header_id IN NUMBER
337: , x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
338: )
339: IS
340: l_org_id NUMBER;
341: l_count NUMBER;

Line 633: , x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

629: -- Procedure Query_Line
630:
631: PROCEDURE Query_Line
632: ( p_line_id IN NUMBER
633: , x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
634: )
635: IS
636: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
637: --

Line 636: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

632: ( p_line_id IN NUMBER
633: , x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
634: )
635: IS
636: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
637: --
638: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
639: --
640: BEGIN

Line 671: IF ( OE_Order_PUB.G_Line.Line_Type_id is not null

667: begin
668:
669: G_STMT_NO := 'Enforce_Price_lists_Flag#10';
670: -- changes for bug 4200055
671: IF ( OE_Order_PUB.G_Line.Line_Type_id is not null
672: AND OE_Order_PUB.G_Line.Line_Type_id <> FND_API.G_MISS_NUM ) THEN
673: if (OE_Order_Cache.g_line_type_rec.line_type_id <> OE_Order_PUB.G_Line.Line_Type_id) then
674: OE_Order_Cache.Load_Line_type(OE_Order_PUB.G_Line.Line_Type_id) ;
675: end if ;

Line 672: AND OE_Order_PUB.G_Line.Line_Type_id <> FND_API.G_MISS_NUM ) THEN

668:
669: G_STMT_NO := 'Enforce_Price_lists_Flag#10';
670: -- changes for bug 4200055
671: IF ( OE_Order_PUB.G_Line.Line_Type_id is not null
672: AND OE_Order_PUB.G_Line.Line_Type_id <> FND_API.G_MISS_NUM ) THEN
673: if (OE_Order_Cache.g_line_type_rec.line_type_id <> OE_Order_PUB.G_Line.Line_Type_id) then
674: OE_Order_Cache.Load_Line_type(OE_Order_PUB.G_Line.Line_Type_id) ;
675: end if ;
676: if (OE_Order_Cache.g_line_type_rec.line_type_id = OE_Order_PUB.G_Line.Line_Type_id ) then

Line 673: if (OE_Order_Cache.g_line_type_rec.line_type_id <> OE_Order_PUB.G_Line.Line_Type_id) then

669: G_STMT_NO := 'Enforce_Price_lists_Flag#10';
670: -- changes for bug 4200055
671: IF ( OE_Order_PUB.G_Line.Line_Type_id is not null
672: AND OE_Order_PUB.G_Line.Line_Type_id <> FND_API.G_MISS_NUM ) THEN
673: if (OE_Order_Cache.g_line_type_rec.line_type_id <> OE_Order_PUB.G_Line.Line_Type_id) then
674: OE_Order_Cache.Load_Line_type(OE_Order_PUB.G_Line.Line_Type_id) ;
675: end if ;
676: if (OE_Order_Cache.g_line_type_rec.line_type_id = OE_Order_PUB.G_Line.Line_Type_id ) then
677: l_enforce_price_flag := nvl(OE_Order_Cache.g_line_type_rec.enforce_line_prices_flag,'N') ;

Line 674: OE_Order_Cache.Load_Line_type(OE_Order_PUB.G_Line.Line_Type_id) ;

670: -- changes for bug 4200055
671: IF ( OE_Order_PUB.G_Line.Line_Type_id is not null
672: AND OE_Order_PUB.G_Line.Line_Type_id <> FND_API.G_MISS_NUM ) THEN
673: if (OE_Order_Cache.g_line_type_rec.line_type_id <> OE_Order_PUB.G_Line.Line_Type_id) then
674: OE_Order_Cache.Load_Line_type(OE_Order_PUB.G_Line.Line_Type_id) ;
675: end if ;
676: if (OE_Order_Cache.g_line_type_rec.line_type_id = OE_Order_PUB.G_Line.Line_Type_id ) then
677: l_enforce_price_flag := nvl(OE_Order_Cache.g_line_type_rec.enforce_line_prices_flag,'N') ;
678: else

Line 676: if (OE_Order_Cache.g_line_type_rec.line_type_id = OE_Order_PUB.G_Line.Line_Type_id ) then

672: AND OE_Order_PUB.G_Line.Line_Type_id <> FND_API.G_MISS_NUM ) THEN
673: if (OE_Order_Cache.g_line_type_rec.line_type_id <> OE_Order_PUB.G_Line.Line_Type_id) then
674: OE_Order_Cache.Load_Line_type(OE_Order_PUB.G_Line.Line_Type_id) ;
675: end if ;
676: if (OE_Order_Cache.g_line_type_rec.line_type_id = OE_Order_PUB.G_Line.Line_Type_id ) then
677: l_enforce_price_flag := nvl(OE_Order_Cache.g_line_type_rec.enforce_line_prices_flag,'N') ;
678: else
679: l_enforce_price_flag := 'N';
680: end if ;

Line 685: from oe_line_types_v where line_type_id=OE_Order_PUB.G_Line.Line_Type_id; */

681: ELSE
682: l_enforce_price_flag := 'N';
683: END IF ;
684: /* select nvl(enforce_line_prices_flag,'N') into l_enforce_price_flag
685: from oe_line_types_v where line_type_id=OE_Order_PUB.G_Line.Line_Type_id; */
686: --end bug 4200055
687: -- exception when no_data_found then
688: exception when others then
689: l_enforce_price_flag := 'N';

Line 696: IF ( OE_Order_PUB.G_Hdr.Order_Type_id is not null

692: If l_enforce_price_flag='N' then
693: begin
694: G_STMT_NO := 'Enforce_Price_lists_Flag#20';
695: --changes for bug 4200055
696: IF ( OE_Order_PUB.G_Hdr.Order_Type_id is not null
697: AND OE_Order_PUB.G_Hdr.Order_Type_id <> FND_API.G_MISS_NUM ) THEN
698: if (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_PUB.G_Hdr.Order_Type_id) then
699: OE_Order_Cache.Load_Order_type(OE_Order_PUB.G_Hdr.Order_Type_id) ;
700: end if ;

Line 697: AND OE_Order_PUB.G_Hdr.Order_Type_id <> FND_API.G_MISS_NUM ) THEN

693: begin
694: G_STMT_NO := 'Enforce_Price_lists_Flag#20';
695: --changes for bug 4200055
696: IF ( OE_Order_PUB.G_Hdr.Order_Type_id is not null
697: AND OE_Order_PUB.G_Hdr.Order_Type_id <> FND_API.G_MISS_NUM ) THEN
698: if (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_PUB.G_Hdr.Order_Type_id) then
699: OE_Order_Cache.Load_Order_type(OE_Order_PUB.G_Hdr.Order_Type_id) ;
700: end if ;
701: if (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_PUB.G_Hdr.Order_Type_id ) then

Line 698: if (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_PUB.G_Hdr.Order_Type_id) then

694: G_STMT_NO := 'Enforce_Price_lists_Flag#20';
695: --changes for bug 4200055
696: IF ( OE_Order_PUB.G_Hdr.Order_Type_id is not null
697: AND OE_Order_PUB.G_Hdr.Order_Type_id <> FND_API.G_MISS_NUM ) THEN
698: if (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_PUB.G_Hdr.Order_Type_id) then
699: OE_Order_Cache.Load_Order_type(OE_Order_PUB.G_Hdr.Order_Type_id) ;
700: end if ;
701: if (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_PUB.G_Hdr.Order_Type_id ) then
702: l_enforce_price_flag := nvl(OE_Order_Cache.g_order_type_rec.enforce_line_prices_flag,'N') ;

Line 699: OE_Order_Cache.Load_Order_type(OE_Order_PUB.G_Hdr.Order_Type_id) ;

695: --changes for bug 4200055
696: IF ( OE_Order_PUB.G_Hdr.Order_Type_id is not null
697: AND OE_Order_PUB.G_Hdr.Order_Type_id <> FND_API.G_MISS_NUM ) THEN
698: if (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_PUB.G_Hdr.Order_Type_id) then
699: OE_Order_Cache.Load_Order_type(OE_Order_PUB.G_Hdr.Order_Type_id) ;
700: end if ;
701: if (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_PUB.G_Hdr.Order_Type_id ) then
702: l_enforce_price_flag := nvl(OE_Order_Cache.g_order_type_rec.enforce_line_prices_flag,'N') ;
703: else

Line 701: if (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_PUB.G_Hdr.Order_Type_id ) then

697: AND OE_Order_PUB.G_Hdr.Order_Type_id <> FND_API.G_MISS_NUM ) THEN
698: if (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_PUB.G_Hdr.Order_Type_id) then
699: OE_Order_Cache.Load_Order_type(OE_Order_PUB.G_Hdr.Order_Type_id) ;
700: end if ;
701: if (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_PUB.G_Hdr.Order_Type_id ) then
702: l_enforce_price_flag := nvl(OE_Order_Cache.g_order_type_rec.enforce_line_prices_flag,'N') ;
703: else
704: l_enforce_price_flag := 'N';
705: end if ;

Line 710: from oe_Order_types_v where Order_type_id=OE_Order_PUB.g_hdr.Order_Type_Id;*/

706: ELSE
707: l_enforce_price_flag := 'N';
708: END IF ;
709: /*select nvl(enforce_line_prices_flag,'N') into l_enforce_price_flag
710: from oe_Order_types_v where Order_type_id=OE_Order_PUB.g_hdr.Order_Type_Id;*/
711: -- end bug 4200055
712: -- exception when no_data_found then
713: exception when others then
714: l_enforce_price_flag := 'N';

Line 1745: , px_Line_Tbl in out nocopy OE_Order_Pub.Line_Tbl_Type

1741: end Append_asked_for;
1742:
1743: procedure Get_the_parent_Line(
1744: p_Reference_line_Id Number
1745: , px_Line_Tbl in out nocopy OE_Order_Pub.Line_Tbl_Type
1746: , p_line_Tbl_index Number
1747: )
1748: is
1749: l_Line_Rec OE_Order_Pub.Line_Rec_Type;

Line 1749: l_Line_Rec OE_Order_Pub.Line_Rec_Type;

1745: , px_Line_Tbl in out nocopy OE_Order_Pub.Line_Tbl_Type
1746: , p_line_Tbl_index Number
1747: )
1748: is
1749: l_Line_Rec OE_Order_Pub.Line_Rec_Type;
1750: line_Tbl_Index pls_integer;
1751: l_line_index QP_PREQ_GRP.PLS_INTEGER_TYPE;
1752: l_line_detail_index QP_PREQ_GRP.PLS_INTEGER_TYPE;
1753: l_relationship_type_code QP_PREQ_GRP.VARCHAR_TYPE;

Line 1822: IF (nvl(l_transactional_curr_code, 'XXX') <> nvl(oe_order_pub.g_hdr.transactional_curr_code,'XXX')) THEN

1818: oe_debug_pub.add('pviprana: l_conversion_rate_date ' || l_conversion_rate_date);
1819: oe_debug_pub.add('pviprana: l_conversion_rate' || l_conversion_rate);
1820: END IF;
1821:
1822: IF (nvl(l_transactional_curr_code, 'XXX') <> nvl(oe_order_pub.g_hdr.transactional_curr_code,'XXX')) THEN
1823: IF (nvl(l_transactional_curr_code, 'XXX') <> nvl(l_set_of_books.currency_code,'XXX') AND
1824: (l_conversion_type_code IS NULL OR
1825: (l_conversion_type_code= 'User' AND
1826: l_conversion_rate IS NULL))) OR

Line 1827: (nvl(oe_order_pub.g_hdr.transactional_curr_code,'XXX') <> nvl(l_set_of_books.currency_code,'XXX') AND

1823: IF (nvl(l_transactional_curr_code, 'XXX') <> nvl(l_set_of_books.currency_code,'XXX') AND
1824: (l_conversion_type_code IS NULL OR
1825: (l_conversion_type_code= 'User' AND
1826: l_conversion_rate IS NULL))) OR
1827: (nvl(oe_order_pub.g_hdr.transactional_curr_code,'XXX') <> nvl(l_set_of_books.currency_code,'XXX') AND
1828: (oe_order_pub.g_hdr.conversion_type_code IS NULL OR
1829: (oe_order_pub.g_hdr.conversion_type_code= 'User' AND
1830: oe_order_pub.g_hdr.conversion_rate IS NULL))) THEN
1831: FND_MESSAGE.SET_NAME('ONT', 'ONT_CONV_INFO_NEEDED');

Line 1828: (oe_order_pub.g_hdr.conversion_type_code IS NULL OR

1824: (l_conversion_type_code IS NULL OR
1825: (l_conversion_type_code= 'User' AND
1826: l_conversion_rate IS NULL))) OR
1827: (nvl(oe_order_pub.g_hdr.transactional_curr_code,'XXX') <> nvl(l_set_of_books.currency_code,'XXX') AND
1828: (oe_order_pub.g_hdr.conversion_type_code IS NULL OR
1829: (oe_order_pub.g_hdr.conversion_type_code= 'User' AND
1830: oe_order_pub.g_hdr.conversion_rate IS NULL))) THEN
1831: FND_MESSAGE.SET_NAME('ONT', 'ONT_CONV_INFO_NEEDED');
1832: FND_MESSAGE.SET_TOKEN('SERVICE_CURR', oe_order_pub.g_hdr.transactional_curr_code);

Line 1829: (oe_order_pub.g_hdr.conversion_type_code= 'User' AND

1825: (l_conversion_type_code= 'User' AND
1826: l_conversion_rate IS NULL))) OR
1827: (nvl(oe_order_pub.g_hdr.transactional_curr_code,'XXX') <> nvl(l_set_of_books.currency_code,'XXX') AND
1828: (oe_order_pub.g_hdr.conversion_type_code IS NULL OR
1829: (oe_order_pub.g_hdr.conversion_type_code= 'User' AND
1830: oe_order_pub.g_hdr.conversion_rate IS NULL))) THEN
1831: FND_MESSAGE.SET_NAME('ONT', 'ONT_CONV_INFO_NEEDED');
1832: FND_MESSAGE.SET_TOKEN('SERVICE_CURR', oe_order_pub.g_hdr.transactional_curr_code);
1833: FND_MESSAGE.SET_TOKEN('PARENT_CURR',l_transactional_curr_code);

Line 1830: oe_order_pub.g_hdr.conversion_rate IS NULL))) THEN

1826: l_conversion_rate IS NULL))) OR
1827: (nvl(oe_order_pub.g_hdr.transactional_curr_code,'XXX') <> nvl(l_set_of_books.currency_code,'XXX') AND
1828: (oe_order_pub.g_hdr.conversion_type_code IS NULL OR
1829: (oe_order_pub.g_hdr.conversion_type_code= 'User' AND
1830: oe_order_pub.g_hdr.conversion_rate IS NULL))) THEN
1831: FND_MESSAGE.SET_NAME('ONT', 'ONT_CONV_INFO_NEEDED');
1832: FND_MESSAGE.SET_TOKEN('SERVICE_CURR', oe_order_pub.g_hdr.transactional_curr_code);
1833: FND_MESSAGE.SET_TOKEN('PARENT_CURR',l_transactional_curr_code);
1834: FND_MESSAGE.SET_TOKEN('FUNC_CURR', l_set_of_books.currency_code);

Line 1832: FND_MESSAGE.SET_TOKEN('SERVICE_CURR', oe_order_pub.g_hdr.transactional_curr_code);

1828: (oe_order_pub.g_hdr.conversion_type_code IS NULL OR
1829: (oe_order_pub.g_hdr.conversion_type_code= 'User' AND
1830: oe_order_pub.g_hdr.conversion_rate IS NULL))) THEN
1831: FND_MESSAGE.SET_NAME('ONT', 'ONT_CONV_INFO_NEEDED');
1832: FND_MESSAGE.SET_TOKEN('SERVICE_CURR', oe_order_pub.g_hdr.transactional_curr_code);
1833: FND_MESSAGE.SET_TOKEN('PARENT_CURR',l_transactional_curr_code);
1834: FND_MESSAGE.SET_TOKEN('FUNC_CURR', l_set_of_books.currency_code);
1835: OE_MSG_PUB.Add;
1836: px_Line_Tbl(line_Tbl_index).unit_list_price := null;

Line 1860: IF nvl(l_set_of_books.currency_code,'XXX') <> nvl(oe_order_pub.g_hdr.transactional_curr_code,'XXX') THEN

1856: );
1857:
1858: END IF;
1859:
1860: IF nvl(l_set_of_books.currency_code,'XXX') <> nvl(oe_order_pub.g_hdr.transactional_curr_code,'XXX') THEN
1861: IF l_debug_level > 0 THEN
1862: oe_debug_pub.add('pviprana: second conversion: conversion_type is '|| oe_order_pub.g_hdr.conversion_type_code);
1863: END IF;
1864: gl_currency_api.convert_closest_amount

Line 1862: oe_debug_pub.add('pviprana: second conversion: conversion_type is '|| oe_order_pub.g_hdr.conversion_type_code);

1858: END IF;
1859:
1860: IF nvl(l_set_of_books.currency_code,'XXX') <> nvl(oe_order_pub.g_hdr.transactional_curr_code,'XXX') THEN
1861: IF l_debug_level > 0 THEN
1862: oe_debug_pub.add('pviprana: second conversion: conversion_type is '|| oe_order_pub.g_hdr.conversion_type_code);
1863: END IF;
1864: gl_currency_api.convert_closest_amount
1865: ( x_from_currency => l_set_of_books.currency_code
1866: , x_to_currency => oe_order_pub.g_hdr.transactional_curr_code

Line 1866: , x_to_currency => oe_order_pub.g_hdr.transactional_curr_code

1862: oe_debug_pub.add('pviprana: second conversion: conversion_type is '|| oe_order_pub.g_hdr.conversion_type_code);
1863: END IF;
1864: gl_currency_api.convert_closest_amount
1865: ( x_from_currency => l_set_of_books.currency_code
1866: , x_to_currency => oe_order_pub.g_hdr.transactional_curr_code
1867: , x_conversion_date => nvl(oe_order_pub.g_hdr.conversion_rate_date,sysdate)
1868: , x_conversion_type => oe_order_pub.g_hdr.conversion_type_code
1869: , x_amount => px_Line_Tbl(line_Tbl_index).unit_list_price
1870: , x_user_rate => oe_order_pub.g_hdr.conversion_rate

Line 1867: , x_conversion_date => nvl(oe_order_pub.g_hdr.conversion_rate_date,sysdate)

1863: END IF;
1864: gl_currency_api.convert_closest_amount
1865: ( x_from_currency => l_set_of_books.currency_code
1866: , x_to_currency => oe_order_pub.g_hdr.transactional_curr_code
1867: , x_conversion_date => nvl(oe_order_pub.g_hdr.conversion_rate_date,sysdate)
1868: , x_conversion_type => oe_order_pub.g_hdr.conversion_type_code
1869: , x_amount => px_Line_Tbl(line_Tbl_index).unit_list_price
1870: , x_user_rate => oe_order_pub.g_hdr.conversion_rate
1871: , x_max_roll_days => -1

Line 1868: , x_conversion_type => oe_order_pub.g_hdr.conversion_type_code

1864: gl_currency_api.convert_closest_amount
1865: ( x_from_currency => l_set_of_books.currency_code
1866: , x_to_currency => oe_order_pub.g_hdr.transactional_curr_code
1867: , x_conversion_date => nvl(oe_order_pub.g_hdr.conversion_rate_date,sysdate)
1868: , x_conversion_type => oe_order_pub.g_hdr.conversion_type_code
1869: , x_amount => px_Line_Tbl(line_Tbl_index).unit_list_price
1870: , x_user_rate => oe_order_pub.g_hdr.conversion_rate
1871: , x_max_roll_days => -1
1872: , x_converted_amount => px_Line_Tbl(line_Tbl_index).unit_list_price

Line 1870: , x_user_rate => oe_order_pub.g_hdr.conversion_rate

1866: , x_to_currency => oe_order_pub.g_hdr.transactional_curr_code
1867: , x_conversion_date => nvl(oe_order_pub.g_hdr.conversion_rate_date,sysdate)
1868: , x_conversion_type => oe_order_pub.g_hdr.conversion_type_code
1869: , x_amount => px_Line_Tbl(line_Tbl_index).unit_list_price
1870: , x_user_rate => oe_order_pub.g_hdr.conversion_rate
1871: , x_max_roll_days => -1
1872: , x_converted_amount => px_Line_Tbl(line_Tbl_index).unit_list_price
1873: , x_denominator => l_denominator
1874: , x_numerator => l_numerator

Line 1970: , px_Line_Tbl in out nocopy OE_Order_Pub.Line_Tbl_Type

1966: End Get_the_parent_Line;
1967:
1968: procedure Get_PRG_Lines(
1969: p_line_Id Number
1970: , px_Line_Tbl in out nocopy OE_Order_Pub.Line_Tbl_Type
1971: , p_line_Tbl_index Number
1972: )
1973: is
1974: l_Line_Rec OE_Order_Pub.Line_Rec_Type;

Line 1974: l_Line_Rec OE_Order_Pub.Line_Rec_Type;

1970: , px_Line_Tbl in out nocopy OE_Order_Pub.Line_Tbl_Type
1971: , p_line_Tbl_index Number
1972: )
1973: is
1974: l_Line_Rec OE_Order_Pub.Line_Rec_Type;
1975: line_Tbl_Index pls_integer;
1976: Cursor prg_lines is
1977: select adj1.line_id prg_line_id, assoc.rltd_price_adj_id
1978: from oe_price_adjustments adj1,

Line 2026: , px_Line_Tbl in out nocopy OE_Order_Pub.Line_Tbl_Type

2022: -- in the case of overriding the list price of the parent
2023: procedure Get_Service_Lines(
2024: p_line_Id Number
2025: , p_header_id Number
2026: , px_Line_Tbl in out nocopy OE_Order_Pub.Line_Tbl_Type
2027: , p_line_Tbl_index Number
2028: )
2029: is
2030: l_Line_Rec OE_Order_Pub.Line_Rec_Type;

Line 2030: l_Line_Rec OE_Order_Pub.Line_Rec_Type;

2026: , px_Line_Tbl in out nocopy OE_Order_Pub.Line_Tbl_Type
2027: , p_line_Tbl_index Number
2028: )
2029: is
2030: l_Line_Rec OE_Order_Pub.Line_Rec_Type;
2031: line_Tbl_Index pls_integer;
2032:
2033: CURSOR service_lines is
2034: select line_id from oe_order_lines_all

Line 2073: procedure Get_item_for_iue(px_line_rec in out nocopy OE_Order_PUB.line_rec_type)

2069: End LOOP;
2070: END Get_Service_Lines;
2071: -- 3529369
2072:
2073: procedure Get_item_for_iue(px_line_rec in out nocopy OE_Order_PUB.line_rec_type)
2074: is
2075: -- This change is required since we are dropping the profile OE_ORGANIZATION -- _ID. Change made by Esha.
2076: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
2077: /*l_org_id NUMBER := FND_PROFILE.Value('OE_ORGANIZATION_ID');*/

Line 2198: PROCEDURE UPDATE_GLOBAL(p_old_line_rec IN OE_ORDER_PUB.LINE_REC_TYPE,

2194: oe_debug_pub.add( L_ROUTINE||': '||SQLERRM , 1 ) ;
2195: END IF;
2196: END reset_all_tbls;
2197:
2198: PROCEDURE UPDATE_GLOBAL(p_old_line_rec IN OE_ORDER_PUB.LINE_REC_TYPE,
2199: p_line_rec IN OE_ORDER_PUB.LINE_REC_TYPE)
2200: IS
2201: l_notify_index NUMBER;
2202: l_return_status VARCHAR2(1);

Line 2199: p_line_rec IN OE_ORDER_PUB.LINE_REC_TYPE)

2195: END IF;
2196: END reset_all_tbls;
2197:
2198: PROCEDURE UPDATE_GLOBAL(p_old_line_rec IN OE_ORDER_PUB.LINE_REC_TYPE,
2199: p_line_rec IN OE_ORDER_PUB.LINE_REC_TYPE)
2200: IS
2201: l_notify_index NUMBER;
2202: l_return_status VARCHAR2(1);
2203: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;

Line 2203: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;

2199: p_line_rec IN OE_ORDER_PUB.LINE_REC_TYPE)
2200: IS
2201: l_notify_index NUMBER;
2202: l_return_status VARCHAR2(1);
2203: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
2204: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2205: --
2206: BEGIN
2207: l_line_rec:= p_line_rec;

Line 2282: px_line_tbl IN OUT NOCOPY OE_ORDER_PUB.LINE_TBL_TYPE

2278: END;
2279:
2280:
2281: PROCEDURE POPULATE_LINE_TBL(
2282: px_line_tbl IN OUT NOCOPY OE_ORDER_PUB.LINE_TBL_TYPE
2283: )
2284: IS
2285: lx_old_line_price_tbl OE_ORDER_PUB.LINE_TBL_TYPE;
2286: l_control_rec OE_GLOBALS.Control_Rec_Type;

Line 2285: lx_old_line_price_tbl OE_ORDER_PUB.LINE_TBL_TYPE;

2281: PROCEDURE POPULATE_LINE_TBL(
2282: px_line_tbl IN OUT NOCOPY OE_ORDER_PUB.LINE_TBL_TYPE
2283: )
2284: IS
2285: lx_old_line_price_tbl OE_ORDER_PUB.LINE_TBL_TYPE;
2286: l_control_rec OE_GLOBALS.Control_Rec_Type;
2287: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2288: l_call_lines BOOLEAN := FALSE;
2289: l_check_sec BOOLEAN := FALSE;

Line 2291: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;

2287: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2288: l_call_lines BOOLEAN := FALSE;
2289: l_check_sec BOOLEAN := FALSE;
2290: l_line_index NUMBER;
2291: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
2292: --
2293: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2294: --
2295: l_validate_desc_flex varchar2(1) := 'N';

Line 2414: px_line_tbl IN OUT NOCOPY OE_ORDER_PUB.LINE_TBL_TYPE,

2410: --bug 3702538
2411: END POPULATE_LINE_TBL;
2412:
2413: PROCEDURE SECURITY_AND_GLOBAL_PICTURE(
2414: px_line_tbl IN OUT NOCOPY OE_ORDER_PUB.LINE_TBL_TYPE,
2415: p_write_to_db IN BOOLEAN
2416: )
2417: IS
2418: l_line_index NUMBER;

Line 2419: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;

2415: p_write_to_db IN BOOLEAN
2416: )
2417: IS
2418: l_line_index NUMBER;
2419: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
2420: l_old_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
2421: l_sec_result varchar2(1);
2422: l_return_status varchar2(1);
2423: --

Line 2420: l_old_line_rec OE_ORDER_PUB.LINE_REC_TYPE;

2416: )
2417: IS
2418: l_line_index NUMBER;
2419: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
2420: l_old_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
2421: l_sec_result varchar2(1);
2422: l_return_status varchar2(1);
2423: --
2424: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 2614: l_header_id NUMBER:=oe_order_pub.g_hdr.header_id;

2610: l_x_msg_count number;
2611: l_x_msg_data Varchar2(2000);
2612: l_x_result_out Varchar2(30);
2613: l_msg_text Varchar2(200);
2614: l_header_id NUMBER:=oe_order_pub.g_hdr.header_id;
2615: --bug 2028480 begin
2616: l_gsa_released varchar2(1) := 'N';
2617: --bug 2028480 end
2618: CURSOR gsa_violators IS

Line 2842: px_header_rec IN OE_ORDER_PUB.HEADER_REC_TYPE

2838: END IF; -- gsa_enabled
2839: END Check_GSA;
2840:
2841: PROCEDURE UPDATE_ORDER_HEADER(
2842: px_header_rec IN OE_ORDER_PUB.HEADER_REC_TYPE
2843: )
2844: IS
2845: --
2846: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 2871: px_line_tbl IN OUT NOCOPY OE_ORDER_PUB.LINE_TBL_TYPE

2867: NULL;
2868: END UPDATE_ORDER_HEADER;
2869:
2870: PROCEDURE LOG_REQUEST(
2871: px_line_tbl IN OUT NOCOPY OE_ORDER_PUB.LINE_TBL_TYPE
2872: )
2873: IS
2874: l_verify_payment varchar2(1);
2875: l_commitment_sequencing boolean

Line 2881: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;

2877: l_return_status varchar2(1);
2878: l_tax_event_code number := 0;
2879: l_tax_calculation_flag varchar2(1):=NULL;
2880: l_tax_calc_rec OE_ORDER_CACHE.Tax_Calc_Rec_Type;
2881: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
2882: l_order_adj_changed_flag varchar2(1);
2883: l_commt_tax_flag varchar2(1); --bug 2505961
2884: cursor updated_lines IS
2885: SELECT l.LINE_ID

Line 2940: IF OE_Order_pub.g_hdr.order_type_id is not null THEN

2936: Begin
2937:
2938: -- Log delayed requests for the attributes change on the line
2939: BEGIN
2940: IF OE_Order_pub.g_hdr.order_type_id is not null THEN
2941:
2942: --changes for bug 4200055
2943: IF ( OE_Order_PUB.G_Hdr.Order_Type_id <> FND_API.G_MISS_NUM ) THEN
2944: if (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_PUB.G_Hdr.Order_Type_id) then

Line 2943: IF ( OE_Order_PUB.G_Hdr.Order_Type_id <> FND_API.G_MISS_NUM ) THEN

2939: BEGIN
2940: IF OE_Order_pub.g_hdr.order_type_id is not null THEN
2941:
2942: --changes for bug 4200055
2943: IF ( OE_Order_PUB.G_Hdr.Order_Type_id <> FND_API.G_MISS_NUM ) THEN
2944: if (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_PUB.G_Hdr.Order_Type_id) then
2945: OE_Order_Cache.Load_Order_type(OE_Order_PUB.G_Hdr.Order_Type_id) ;
2946: end if ;
2947: if (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_PUB.G_Hdr.Order_Type_id ) then

Line 2944: if (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_PUB.G_Hdr.Order_Type_id) then

2940: IF OE_Order_pub.g_hdr.order_type_id is not null THEN
2941:
2942: --changes for bug 4200055
2943: IF ( OE_Order_PUB.G_Hdr.Order_Type_id <> FND_API.G_MISS_NUM ) THEN
2944: if (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_PUB.G_Hdr.Order_Type_id) then
2945: OE_Order_Cache.Load_Order_type(OE_Order_PUB.G_Hdr.Order_Type_id) ;
2946: end if ;
2947: if (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_PUB.G_Hdr.Order_Type_id ) then
2948: if (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'ENTERING') then

Line 2945: OE_Order_Cache.Load_Order_type(OE_Order_PUB.G_Hdr.Order_Type_id) ;

2941:
2942: --changes for bug 4200055
2943: IF ( OE_Order_PUB.G_Hdr.Order_Type_id <> FND_API.G_MISS_NUM ) THEN
2944: if (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_PUB.G_Hdr.Order_Type_id) then
2945: OE_Order_Cache.Load_Order_type(OE_Order_PUB.G_Hdr.Order_Type_id) ;
2946: end if ;
2947: if (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_PUB.G_Hdr.Order_Type_id ) then
2948: if (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'ENTERING') then
2949: l_tax_event_code := 0;

Line 2947: if (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_PUB.G_Hdr.Order_Type_id ) then

2943: IF ( OE_Order_PUB.G_Hdr.Order_Type_id <> FND_API.G_MISS_NUM ) THEN
2944: if (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_PUB.G_Hdr.Order_Type_id) then
2945: OE_Order_Cache.Load_Order_type(OE_Order_PUB.G_Hdr.Order_Type_id) ;
2946: end if ;
2947: if (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_PUB.G_Hdr.Order_Type_id ) then
2948: if (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'ENTERING') then
2949: l_tax_event_code := 0;
2950: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'BOOKING') then
2951: l_tax_event_code := 1;

Line 2973: where transaction_type_id = OE_Order_pub.g_hdr.order_type_id;*/

2969: 'INVOICING', 3,
2970: -1)
2971: into l_tax_event_code
2972: from oe_transaction_types_all
2973: where transaction_type_id = OE_Order_pub.g_hdr.order_type_id;*/
2974: -- end bug 4200055
2975: END IF;
2976:
2977: EXCEPTION

Line 3093: IF OE_ORDER_PUB.G_HDR.PAYMENT_TYPE_CODE = 'CREDIT_CARD' THEN

3089: oe_globals.g_tax_flag := 'N';
3090: END IF;
3091:
3092: l_verify_payment := 'N';
3093: IF OE_ORDER_PUB.G_HDR.PAYMENT_TYPE_CODE = 'CREDIT_CARD' THEN
3094: IF l_debug_level > 0 THEN
3095: oe_debug_pub.add( 'CREDIT CARD:'||UPDATE_LINE.ADJUSTED_UNIT_PRICE||'>'||UPDATE_LINE.UNIT_SELLING_PRICE_PER_PQTY||'?' ) ;
3096: END IF;
3097: IF update_line.adjusted_unit_price > update_line.unit_selling_price_per_pqty or

Line 3114: oe_debug_pub.add( 'PAYMENT TYPE:'||OE_ORDER_PUB.G_HDR.PAYMENT_TYPE_CODE||' BOOKED?'||UPDATE_LINE.BOOKED_FLAG ) ;

3110: END IF;
3111: END IF;
3112: ELSE
3113: IF l_debug_level > 0 THEN
3114: oe_debug_pub.add( 'PAYMENT TYPE:'||OE_ORDER_PUB.G_HDR.PAYMENT_TYPE_CODE||' BOOKED?'||UPDATE_LINE.BOOKED_FLAG ) ;
3115: END IF;
3116: IF nvl(update_line.booked_flag,'X') = 'Y' THEN
3117: IF l_debug_level > 0 THEN
3118: oe_debug_pub.add( 'LOG VERIFY PAYMENT REQUEST' ) ;

Line 3131: p_entity_id => oe_order_pub.g_hdr.header_id,

3127: END IF;
3128: --
3129: OE_delayed_requests_Pvt.log_request
3130: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
3131: p_entity_id => oe_order_pub.g_hdr.header_id,
3132: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
3133: p_requesting_entity_id => update_line.line_id,
3134: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,
3135: x_return_status => l_return_status);

Line 3296: p_entity_id => oe_order_pub.g_hdr.header_id,

3292: oe_debug_pub.add( 'LOGGING REQUEST TO UPDATE ALL LINES FOR HEADER LEVEL ADJUSTMENT.' , 1 ) ;
3293: END IF;
3294: OE_DELAYED_REQUESTS_PVT.LOG_REQUEST(
3295: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
3296: p_entity_id => oe_order_pub.g_hdr.header_id,
3297: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
3298: p_requesting_entity_id => oe_order_pub.g_hdr.header_id,
3299: p_request_type => OE_GLOBALS.G_PRICE_ADJ,
3300: x_return_status => l_return_status);

Line 3298: p_requesting_entity_id => oe_order_pub.g_hdr.header_id,

3294: OE_DELAYED_REQUESTS_PVT.LOG_REQUEST(
3295: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
3296: p_entity_id => oe_order_pub.g_hdr.header_id,
3297: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
3298: p_requesting_entity_id => oe_order_pub.g_hdr.header_id,
3299: p_request_type => OE_GLOBALS.G_PRICE_ADJ,
3300: x_return_status => l_return_status);
3301:
3302: END IF;

Line 3329: px_line_tbl IN OUT NOCOPY OE_ORDER_PUB.LINE_TBL_TYPE

3325: raise fnd_api.g_exc_error;
3326: End LOG_REQUEST;
3327:
3328: PROCEDURE UPDATE_ORDER_LINES(
3329: px_line_tbl IN OUT NOCOPY OE_ORDER_PUB.LINE_TBL_TYPE
3330: , x_num_changed_lines OUT NOCOPY NUMBER
3331: ,p_write_to_db BOOLEAN DEFAULT FALSE
3332: )
3333: IS

Line 3407: --l.header_id=oe_order_pub.g_hdr.header_id

3403: and lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_UPDATED, QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
3404: and lines.process_status <> 'NOT_VALID'
3405: )
3406: where
3407: --l.header_id=oe_order_pub.g_hdr.header_id
3408: --and
3409: l.ordered_quantity <> 0
3410: and l.open_flag <> 'N'
3411: and l.line_id in (select line_id from qp_preq_lines_tmp lines

Line 3456: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

3452: p_applied_flag_tbl IN OUT NOCOPY VARCHAR_TYPE,
3453: p_adjusted_amount_tbl IN OUT NOCOPY NUMBER_TYPE
3454: ) IS
3455: i NUMBER;
3456: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3457: l_return_status VARCHAR2(30);
3458: l_index NUMBER;
3459: l_booked_flag varchar2(1) := oe_order_cache.g_header_rec.booked_flag;
3460:

Line 3576: WHERE HEADER_ID=oe_order_pub.g_hdr.header_id

3572: QP_PREQ_PUB.G_STATUS_GSA_VIOLATION
3573: )
3574: THEN
3575: DELETE FROM OE_PRICE_ADJUSTMENTS
3576: WHERE HEADER_ID=oe_order_pub.g_hdr.header_id
3577: AND LINE_ID IS NULL
3578: AND LIST_LINE_TYPE_CODE NOT IN ('TAX')
3579: AND NVL(UPDATED_FLAG, 'N')='N'
3580: AND PRICING_PHASE_ID IN (select b.pricing_phase_id

Line 3593: and p_hdr_line_id = oe_order_pub.g_hdr.header_id)

3589: where ld.process_code in (QP_PREQ_GRP.G_STATUS_NEW, --bug 4190357
3590: QP_PREQ_GRP.G_STATUS_UPDATED,
3591: QP_PREQ_GRP.G_STATUS_UNCHANGED)
3592: and ld.line_index = p_hdr_line_index
3593: and p_hdr_line_id = oe_order_pub.g_hdr.header_id)
3594: returning price_adjustment_id,
3595: header_id,
3596: line_id,
3597: list_line_id,

Line 3650: WHERE --HEADER_ID=oe_order_pub.g_hdr.header_id

3646: l_line_type_code := 'LINE';
3647: For one_line in updated_order_lines(l_line_type_code) loop
3648: DELETE /*+ index (adj oe_price_adjustments_n2) */
3649: FROM OE_PRICE_ADJUSTMENTS adj
3650: WHERE --HEADER_ID=oe_order_pub.g_hdr.header_id
3651: LINE_ID = one_line.line_id
3652: AND LIST_LINE_TYPE_CODE NOT IN ('TAX','IUE') --bug 2858712
3653: AND NVL(UPDATED_FLAG, 'N')='N'
3654: AND PRICING_PHASE_ID IN (select b.pricing_phase_id

Line 3732: WHERE HEADER_ID=oe_order_pub.g_hdr.header_id

3728: and pricing_status_code in (QP_PREQ_PUB.G_STATUS_UPDATED,
3729: QP_PREQ_PUB.G_STATUS_GSA_VIOLATION);
3730:
3731: DELETE FROM OE_PRICE_ADJUSTMENTS
3732: WHERE HEADER_ID=oe_order_pub.g_hdr.header_id
3733: AND LINE_ID=p_line_id
3734: AND NVL(UPDATED_FLAG, 'N')='N'
3735: AND PRICING_PHASE_ID IN (select b.pricing_phase_id
3736: from qp_event_phases a,

Line 4035: adj.header_id=oe_order_pub.g_hdr.header_id

4031: from OE_PRICE_ADJUSTMENTS adj
4032: , QP_LDETS_v ldets
4033: , QP_PREQ_LINES_TMP lines
4034: WHERE
4035: adj.header_id=oe_order_pub.g_hdr.header_id
4036: and lines.line_index = ldets.line_index
4037: and lines.process_status <> 'NOT_VALID'
4038: and ldets.list_line_id = adj.list_line_id
4039: and lines.line_type_code='ORDER' and lines.line_id=adj.header_id

Line 4081: adj.header_id=oe_order_pub.g_hdr.header_id

4077: from OE_PRICE_ADJUSTMENTS adj
4078: , QP_LDETS_v ldets
4079: , QP_PREQ_LINES_TMP lines
4080: WHERE
4081: adj.header_id=oe_order_pub.g_hdr.header_id
4082: and lines.line_index = ldets.line_index
4083: and lines.process_status <> 'NOT_VALID'
4084: and ldets.list_line_id = adj.list_line_id
4085: and lines.line_type_code='LINE' and lines.line_id=adj.line_id

Line 4371: , oe_order_pub.g_hdr.header_id --p_Line_Adj_rec.header_id

4367: , NULL --p_Line_Adj_rec.program_application_id
4368: , NULL --p_Line_Adj_rec.program_id
4369: , NULL --p_Line_Adj_rec.program_update_date
4370: , NULL --p_Line_Adj_rec.request_id
4371: , oe_order_pub.g_hdr.header_id --p_Line_Adj_rec.header_id
4372: , NULL --p_Line_Adj_rec.discount_id
4373: , NULL --p_Line_Adj_rec.discount_line_id
4374: , ldets.automatic_flag
4375: , NULL --p_Line_Adj_rec.percent

Line 4623: --AND LDETS.LINE_INDEX = oe_order_pub.g_hdr.header_id + l_line_id_tbl(i)

4619: --AND LDETS.LIST_LINE_ID = l_list_line_id_tbl(i)
4620: --AND LDETS.PROCESS_CODE IN (QP_PREQ_PUB.G_STATUS_UNCHANGED,
4621: -- QP_PREQ_PUB.G_STATUS_UPDATED)
4622: --AND LDETS.LINE_INDEX = ADJ.HEADER_ID + ADJ.LINE_ID
4623: --AND LDETS.LINE_INDEX = oe_order_pub.g_hdr.header_id + l_line_id_tbl(i)
4624: --AND ADJ.PRICE_ADJUSTMENT_ID = l_adj_id_tbl(i)
4625: ) ;
4626: IF l_debug_level > 0 THEN
4627: oe_debug_pub.add( 'DELETED '||SQL%ROWCOUNT||' ATTRIBUTES' ) ;

Line 4878: AND ADJ.HEADER_ID = oe_order_pub.g_hdr.header_id

4874: , OE_PRICE_ADJUSTMENTS ADJ
4875: WHERE QPLAT.pricing_status_code=QP_PREQ_PUB.G_STATUS_NEW
4876: -- AND LDETS.LINE_INDEX = ADJ.HEADER_ID
4877: AND ADJ.LINE_ID IS NULL
4878: AND ADJ.HEADER_ID = oe_order_pub.g_hdr.header_id
4879: AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX
4880: AND QPLAT.LINE_INDEX = LDETS.LINE_INDEX
4881: AND LDETS.LIST_LINE_ID=ADJ.LIST_LINE_ID
4882: AND LDETS.PROCESS_CODE=QP_PREQ_PUB.G_STATUS_NEW

Line 4884: AND l_hdr_line_id = oe_order_pub.g_hdr.header_id

4880: AND QPLAT.LINE_INDEX = LDETS.LINE_INDEX
4881: AND LDETS.LIST_LINE_ID=ADJ.LIST_LINE_ID
4882: AND LDETS.PROCESS_CODE=QP_PREQ_PUB.G_STATUS_NEW
4883: AND LDETS.LINE_INDEX = l_hdr_line_index
4884: AND l_hdr_line_id = oe_order_pub.g_hdr.header_id
4885: --AND QPL.PRICING_STATUS_CODE IN (QP_PREQ_PUB.G_STATUS_UPDATED,
4886: -- QP_PREQ_PUB.G_STATUS_GSA_VIOLATION)
4887: );
4888: l_stmt:=14;

Line 4940: -- AND ADJ.HEADER_ID = oe_order_pub.g_hdr.header_id

4936: AND QPLAT.LINE_INDEX = LDETS.LINE_INDEX
4937: AND LDETS.LIST_LINE_ID=ADJ.LIST_LINE_ID
4938: AND LDETS.PROCESS_CODE=QP_PREQ_PUB.G_STATUS_NEW
4939: AND LDETS.LINE_INDEX = QPLINE.LINE_INDEX
4940: -- AND ADJ.HEADER_ID = oe_order_pub.g_hdr.header_id
4941: AND QPLINE.LINE_ID = ADJ.LINE_ID
4942: AND QPLINE.LINE_TYPE_CODE = 'LINE'
4943: AND QPLINE.PRICING_STATUS_CODE IN (QP_PREQ_PUB.G_STATUS_UPDATED,
4944: QP_PREQ_PUB.G_STATUS_GSA_VIOLATION)

Line 4974: p_header_rec OE_Order_PUB.Header_Rec_Type

4970: --end AG change
4971:
4972: -- AG change --
4973: procedure copy_Header_to_request(
4974: p_header_rec OE_Order_PUB.Header_Rec_Type
4975: ,px_req_line_tbl in out NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE
4976: --,p_pricing_event varchar2
4977: ,p_Request_Type_Code varchar2
4978: ,p_calculate_price_flag varchar2

Line 5094: p_Line_rec OE_Order_PUB.Line_Rec_Type

5090:
5091: end copy_Header_to_request;
5092:
5093: procedure copy_Line_to_request(
5094: p_Line_rec OE_Order_PUB.Line_Rec_Type
5095: ,px_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE
5096: ,p_pricing_events varchar2
5097: ,p_request_type_code varchar2
5098: ,p_honor_price_flag varchar2

Line 5187: OE_Order_PUB.g_hdr.transactional_curr_code;

5183: l_req_line_rec.PRICED_QUANTITY := p_Line_rec.pricing_quantity;
5184: l_req_line_rec.PRICED_UOM_CODE := p_Line_rec.pricing_quantity_uom;
5185:
5186: l_req_line_rec.CURRENCY_CODE :=
5187: OE_Order_PUB.g_hdr.transactional_curr_code;
5188: IF l_debug_level > 0 THEN
5189: oe_debug_pub.add( 'UNIT PRICE'||P_LINE_REC.UNIT_LIST_PRICE||L_REQ_LINE_REC.CURRENCY_CODE , 3 ) ;
5190: END IF;
5191: If p_Line_rec.unit_list_price_per_pqty <> FND_API.G_MISS_NUM Then

Line 5344: l_req_line_rec.Active_date_first := OE_Order_Pub.G_HDR.Ordered_date;

5340: oe_debug_pub.add( 'ITEM TYPE CODE'||P_LINE_REC.ITEM_TYPE_CODE , 3 ) ;
5341: END IF;
5342:
5343: l_req_line_rec.Active_date_first_type := 'ORD';
5344: l_req_line_rec.Active_date_first := OE_Order_Pub.G_HDR.Ordered_date;
5345:
5346: If p_Line_rec.schedule_ship_date is not null then
5347: l_req_line_rec.Active_date_Second_type := 'SHIP';
5348: l_req_line_rec.Active_date_Second := p_Line_rec.schedule_ship_date;

Line 5851: x_line_tbl OUT NOCOPY OE_ORDER_PUB.LINE_TBL_TYPE ) AS

5847:
5848:
5849: -- bug4529937
5850: PROCEDURE Query_Changed_Lines(p_header_id IN NUMBER,
5851: x_line_tbl OUT NOCOPY OE_ORDER_PUB.LINE_TBL_TYPE ) AS
5852: i PLS_INTEGER;
5853: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
5854: j PLS_INTEGER;
5855: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 5853: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;

5849: -- bug4529937
5850: PROCEDURE Query_Changed_Lines(p_header_id IN NUMBER,
5851: x_line_tbl OUT NOCOPY OE_ORDER_PUB.LINE_TBL_TYPE ) AS
5852: i PLS_INTEGER;
5853: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
5854: j PLS_INTEGER;
5855: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5856: BEGIN
5857: i := Oe_Line_Adj_Util.G_CHANGED_LINE_TBL.FIRST;

Line 5917: ,x_Header_Rec out nocopy oe_Order_Pub.Header_REc_Type

5913: ,p_Control_Rec OE_ORDER_PRICE_PVT.CONTROL_REC_TYPE
5914: ,p_action_code in Varchar2
5915: ,x_any_frozen_line out nocopy Boolean
5916:
5917: ,x_Header_Rec out nocopy oe_Order_Pub.Header_REc_Type
5918:
5919: ,px_line_Tbl in out nocopy oe_Order_Pub.Line_Tbl_Type
5920: )
5921: is

Line 5919: ,px_line_Tbl in out nocopy oe_Order_Pub.Line_Tbl_Type

5915: ,x_any_frozen_line out nocopy Boolean
5916:
5917: ,x_Header_Rec out nocopy oe_Order_Pub.Header_REc_Type
5918:
5919: ,px_line_Tbl in out nocopy oe_Order_Pub.Line_Tbl_Type
5920: )
5921: is
5922: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
5923: l_return_status_Text varchar2(240) ;

Line 5924: l_header_rec OE_Order_PUB.Header_Rec_Type;

5920: )
5921: is
5922: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
5923: l_return_status_Text varchar2(240) ;
5924: l_header_rec OE_Order_PUB.Header_Rec_Type;
5925: l_Line_Tbl OE_Order_PUB.Line_Tbl_Type;
5926:
5927: --1472635
5928: l_temp_line_tbl OE_Order_PUB.Line_Tbl_type;

Line 5925: l_Line_Tbl OE_Order_PUB.Line_Tbl_Type;

5921: is
5922: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
5923: l_return_status_Text varchar2(240) ;
5924: l_header_rec OE_Order_PUB.Header_Rec_Type;
5925: l_Line_Tbl OE_Order_PUB.Line_Tbl_Type;
5926:
5927: --1472635
5928: l_temp_line_tbl OE_Order_PUB.Line_Tbl_type;
5929: i2 PLS_INTEGER;

Line 5928: l_temp_line_tbl OE_Order_PUB.Line_Tbl_type;

5924: l_header_rec OE_Order_PUB.Header_Rec_Type;
5925: l_Line_Tbl OE_Order_PUB.Line_Tbl_Type;
5926:
5927: --1472635
5928: l_temp_line_tbl OE_Order_PUB.Line_Tbl_type;
5929: i2 PLS_INTEGER;
5930: l_all_lines_from_db Boolean :=False;
5931:
5932: l_Line_Rec OE_Order_PUB.Line_Rec_Type;

Line 5932: l_Line_Rec OE_Order_PUB.Line_Rec_Type;

5928: l_temp_line_tbl OE_Order_PUB.Line_Tbl_type;
5929: i2 PLS_INTEGER;
5930: l_all_lines_from_db Boolean :=False;
5931:
5932: l_Line_Rec OE_Order_PUB.Line_Rec_Type;
5933:
5934: -- AG change
5935: l_line_index NUMBER := 0;
5936: line_tbl_index pls_integer;

Line 6015: -- OE_Order_PUB.g_hdr := OE_ORDER_CACHE.g_header_rec;

6011: G_STMT_NO := 'calculate_adjustments#30';
6012:
6013: Begin
6014:
6015: -- OE_Order_PUB.g_hdr := OE_ORDER_CACHE.g_header_rec;
6016: query_header(
6017: p_header_id => p_header_id
6018: , x_header_rec=>oe_order_pub.g_hdr);
6019: Exception when no_data_found then

Line 6018: , x_header_rec=>oe_order_pub.g_hdr);

6014:
6015: -- OE_Order_PUB.g_hdr := OE_ORDER_CACHE.g_header_rec;
6016: query_header(
6017: p_header_id => p_header_id
6018: , x_header_rec=>oe_order_pub.g_hdr);
6019: Exception when no_data_found then
6020: x_return_status := 'NOOP';
6021: IF l_debug_level > 0 THEN
6022: oe_debug_pub.add( G_STMT_NO||'INVALID HEADER_ID '||P_HEADER_ID , 1 ) ;

Line 6157: , oe_order_pub.g_hdr);

6153: If p_control_rec.p_use_current_header = FALSE Then
6154: Begin
6155:
6156: query_header(l_line_tbl(1).header_id
6157: , oe_order_pub.g_hdr);
6158: Exception when no_data_found then
6159: -- No need to process this order
6160: x_return_status := 'NOOP';
6161: oe_debug_pub.add(G_STMT_NO||'Invalid header_id '||l_line_Tbl(1).Header_id,1);

Line 6170: x_header_rec := oe_order_pub.g_hdr;

6166: NULL;
6167: End If;
6168: end if;
6169:
6170: x_header_rec := oe_order_pub.g_hdr;
6171: G_STMT_NO := 'calculate_adjustments#110';
6172: line_Tbl_Index := l_Line_Tbl.First;
6173: While line_Tbl_Index is not null loop
6174:

Line 6214: OE_Order_PUB.G_LINE := l_Line_Tbl(line_Tbl_Index);

6210: End If;
6211: --End 2740845
6212:
6213: -- Populate that Global Structure
6214: OE_Order_PUB.G_LINE := l_Line_Tbl(line_Tbl_Index);
6215: If OE_Order_PUB.G_LINE.unit_list_price = fnd_api.g_miss_num then
6216: OE_Order_PUB.G_LINE.unit_list_price:= Null;
6217: End If;
6218:

Line 6215: If OE_Order_PUB.G_LINE.unit_list_price = fnd_api.g_miss_num then

6211: --End 2740845
6212:
6213: -- Populate that Global Structure
6214: OE_Order_PUB.G_LINE := l_Line_Tbl(line_Tbl_Index);
6215: If OE_Order_PUB.G_LINE.unit_list_price = fnd_api.g_miss_num then
6216: OE_Order_PUB.G_LINE.unit_list_price:= Null;
6217: End If;
6218:
6219:

Line 6216: OE_Order_PUB.G_LINE.unit_list_price:= Null;

6212:
6213: -- Populate that Global Structure
6214: OE_Order_PUB.G_LINE := l_Line_Tbl(line_Tbl_Index);
6215: If OE_Order_PUB.G_LINE.unit_list_price = fnd_api.g_miss_num then
6216: OE_Order_PUB.G_LINE.unit_list_price:= Null;
6217: End If;
6218:
6219:
6220: --RT{

Line 6233: If (OE_Order_PUB.G_LINE.Service_Reference_Line_Id <>

6229: END IF;
6230: --RT}
6231:
6232:
6233: If (OE_Order_PUB.G_LINE.Service_Reference_Line_Id <>
6234: FND_API.G_MISS_NUM and
6235: OE_Order_PUB.G_LINE.Service_Reference_Line_Id is not null)
6236: Then
6237: /* Added the following if condition for fixing the bug 1828553 */

Line 6235: OE_Order_PUB.G_LINE.Service_Reference_Line_Id is not null)

6231:
6232:
6233: If (OE_Order_PUB.G_LINE.Service_Reference_Line_Id <>
6234: FND_API.G_MISS_NUM and
6235: OE_Order_PUB.G_LINE.Service_Reference_Line_Id is not null)
6236: Then
6237: /* Added the following if condition for fixing the bug 1828553 */
6238: /* If the service reference context is ORDER, then the service_reference*/
6239: /*line_id is the line_id of the parent. However, if the service ref */

Line 6324: Get_item_for_iue(px_line_rec => OE_Order_PUB.G_LINE);

6320: G_STMT_NO := 'calculate_adjustments#125';
6321:
6322: -- Set the old item during pricing
6323: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
6324: Get_item_for_iue(px_line_rec => OE_Order_PUB.G_LINE);
6325: END IF;
6326:
6327: G_STMT_NO := 'calculate_adjustments#135';
6328:

Line 6590: p_header_rec => OE_Order_PUB.g_hdr

6586:
6587:
6588: -- AG change --
6589: copy_Header_to_request(
6590: p_header_rec => OE_Order_PUB.g_hdr
6591: ,px_req_line_tbl => l_req_line_tbl
6592: ,p_Request_Type_Code => p_control_rec.p_Request_Type_Code
6593: ,p_calculate_price_flag =>l_calculate_price_flag
6594: ,px_line_index => l_line_index

Line 6605: p_line_index=> l_line_index, --oe_order_pub.g_hdr.header_id,

6601: oe_debug_pub.add('Before QP_Attr_Mapping_PUB.Build_Contexts for Header',1);
6602: QP_Attr_Mapping_PUB.Build_Contexts(
6603: p_request_type_code => 'ONT',
6604: --p_line_index=> l_line_index,
6605: p_line_index=> l_line_index, --oe_order_pub.g_hdr.header_id,
6606: p_pricing_type_code => 'H'
6607: );
6608:
6609: END IF;

Line 6643: x_header_Rec := OE_Order_PUB.g_hdr;

6639: Populate_Temp_Table;
6640:
6641: END IF;
6642:
6643: x_header_Rec := OE_Order_PUB.g_hdr;
6644: px_line_tbl := l_line_tbl;
6645:
6646: exception
6647: when FND_API.G_EXC_ERROR then

Line 6702: l_control_rec.USER_CONVERSION_RATE:= OE_ORDER_PUB.G_HDR.CONVERSION_RATE;

6698: --now pricing take care of all the roundings.
6699: l_control_rec.rounding_flag := 'Q';
6700: --For multi_currency price list
6701: l_control_rec.use_multi_currency:='Y';
6702: l_control_rec.USER_CONVERSION_RATE:= OE_ORDER_PUB.G_HDR.CONVERSION_RATE;
6703: l_control_rec.USER_CONVERSION_TYPE:= OE_ORDER_PUB.G_HDR.CONVERSION_TYPE_CODE;
6704: l_set_of_books := Oe_Order_Cache.Load_Set_Of_Books;
6705: l_control_rec.FUNCTION_CURRENCY := l_set_of_books.currency_code;
6706:

Line 6703: l_control_rec.USER_CONVERSION_TYPE:= OE_ORDER_PUB.G_HDR.CONVERSION_TYPE_CODE;

6699: l_control_rec.rounding_flag := 'Q';
6700: --For multi_currency price list
6701: l_control_rec.use_multi_currency:='Y';
6702: l_control_rec.USER_CONVERSION_RATE:= OE_ORDER_PUB.G_HDR.CONVERSION_RATE;
6703: l_control_rec.USER_CONVERSION_TYPE:= OE_ORDER_PUB.G_HDR.CONVERSION_TYPE_CODE;
6704: l_set_of_books := Oe_Order_Cache.Load_Set_Of_Books;
6705: l_control_rec.FUNCTION_CURRENCY := l_set_of_books.currency_code;
6706:
6707: If l_Control_Rec.pricing_event IN ('BATCH','RETROBILL') OR

Line 6862: , px_line_Tbl in out NOCOPY oe_Order_Pub.Line_Tbl_Type

6858: procedure Report_Engine_Errors(
6859: x_return_status out nocopy Varchar2
6860:
6861: , p_Control_Rec IN OE_ORDER_PRICE_PVT.Control_rec_type
6862: , px_line_Tbl in out NOCOPY oe_Order_Pub.Line_Tbl_Type
6863: , p_header_rec IN oe_Order_Pub.header_rec_type
6864: )
6865: is
6866: l_line_rec oe_order_pub.line_rec_type;

Line 6863: , p_header_rec IN oe_Order_Pub.header_rec_type

6859: x_return_status out nocopy Varchar2
6860:
6861: , p_Control_Rec IN OE_ORDER_PRICE_PVT.Control_rec_type
6862: , px_line_Tbl in out NOCOPY oe_Order_Pub.Line_Tbl_Type
6863: , p_header_rec IN oe_Order_Pub.header_rec_type
6864: )
6865: is
6866: l_line_rec oe_order_pub.line_rec_type;
6867: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 6866: l_line_rec oe_order_pub.line_rec_type;

6862: , px_line_Tbl in out NOCOPY oe_Order_Pub.Line_Tbl_Type
6863: , p_header_rec IN oe_Order_Pub.header_rec_type
6864: )
6865: is
6866: l_line_rec oe_order_pub.line_rec_type;
6867: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
6868: i pls_Integer;
6869: j pls_Integer:=0;
6870: l_price_list Varchar2(240);

Line 6867: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

6863: , p_header_rec IN oe_Order_Pub.header_rec_type
6864: )
6865: is
6866: l_line_rec oe_order_pub.line_rec_type;
6867: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
6868: i pls_Integer;
6869: j pls_Integer:=0;
6870: l_price_list Varchar2(240);
6871: l_allow_negative_price Varchar2(30) := nvl(fnd_profile.value('ONT_NEGATIVE_PRICING'),'N');

Line 6873: l_temp_line_rec oe_order_pub.line_rec_type;

6869: j pls_Integer:=0;
6870: l_price_list Varchar2(240);
6871: l_allow_negative_price Varchar2(30) := nvl(fnd_profile.value('ONT_NEGATIVE_PRICING'),'N');
6872: l_invalid_line Varchar2(1):='N';
6873: l_temp_line_rec oe_order_pub.line_rec_type;
6874: l_request_id NUMBER;
6875: vmsg Varchar2(2000);
6876: l_list_line_no Varchar2(2000);
6877: --bug 3696768

Line 7511: px_line_Tbl in out NOCOPY oe_Order_Pub.Line_Tbl_Type,

7507: x_return_status out nocopy Varchar2,
7508:
7509: p_Control_Rec OE_ORDER_PRICE_PVT.Control_rec_type,
7510: p_any_frozen_line in Boolean,
7511: px_line_Tbl in out NOCOPY oe_Order_Pub.Line_Tbl_Type,
7512: p_header_id in number,
7513: p_line_id in number,
7514: p_header_rec oe_Order_Pub.header_rec_type,
7515: p_pricing_events in varchar2

Line 7514: p_header_rec oe_Order_Pub.header_rec_type,

7510: p_any_frozen_line in Boolean,
7511: px_line_Tbl in out NOCOPY oe_Order_Pub.Line_Tbl_Type,
7512: p_header_id in number,
7513: p_line_id in number,
7514: p_header_rec oe_Order_Pub.header_rec_type,
7515: p_pricing_events in varchar2
7516: )
7517: is
7518: l_line_rec oe_order_pub.line_rec_type;

Line 7518: l_line_rec oe_order_pub.line_rec_type;

7514: p_header_rec oe_Order_Pub.header_rec_type,
7515: p_pricing_events in varchar2
7516: )
7517: is
7518: l_line_rec oe_order_pub.line_rec_type;
7519: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
7520: i pls_Integer;
7521: j pls_Integer;
7522: l_price_list Varchar2(240);

Line 7519: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

7515: p_pricing_events in varchar2
7516: )
7517: is
7518: l_line_rec oe_order_pub.line_rec_type;
7519: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
7520: i pls_Integer;
7521: j pls_Integer;
7522: l_price_list Varchar2(240);
7523: l_allow_negative_price Varchar2(30) := nvl(fnd_profile.value('ONT_NEGAT

Line 7527: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

7523: l_allow_negative_price Varchar2(30) := nvl(fnd_profile.value('ONT_NEGAT
7524: IVE_PRICING'),'N');
7525: l_sec_result NUMBER;
7526: l_adjustment_count NUMBER:=0;
7527: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
7528: l_num_changed_lines NUMBER := 0;
7529: l_process_requests BOOLEAN := FALSE;
7530: l_process_ack BOOLEAN := FALSE;
7531: l_notify_flag BOOLEAN;

Line 7759: ,px_line_Tbl IN OUT NOCOPY oe_Order_Pub.Line_Tbl_Type

7755: -- It can be used to Price an order, an order line, or multiple lines
7756: Procedure Price_line(
7757: p_Header_id IN NUMBER
7758: ,p_Line_id IN NUMBER
7759: ,px_line_Tbl IN OUT NOCOPY oe_Order_Pub.Line_Tbl_Type
7760: ,p_Control_Rec IN OE_ORDER_PRICE_PVT.control_rec_type
7761: ,p_action_code IN VARCHAR2
7762: ,p_Pricing_Events IN VARCHAR2
7763: --RT{

Line 7764: ,p_request_rec OE_Order_PUB.request_rec_type default oe_order_pub.G_MISS_REQUEST_REC

7760: ,p_Control_Rec IN OE_ORDER_PRICE_PVT.control_rec_type
7761: ,p_action_code IN VARCHAR2
7762: ,p_Pricing_Events IN VARCHAR2
7763: --RT{
7764: ,p_request_rec OE_Order_PUB.request_rec_type default oe_order_pub.G_MISS_REQUEST_REC
7765: --RT}
7766: ,x_Return_Status OUT NOCOPY VARCHAR2
7767:
7768: )

Line 7771: lx_header_rec OE_ORDER_PUB.HEADER_REC_TYPE;

7767:
7768: )
7769: is
7770: l_any_frozen_line BOOLEAN;
7771: lx_header_rec OE_ORDER_PUB.HEADER_REC_TYPE;
7772: --
7773: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
7774: --
7775: Begin

Line 7841: OE_Order_PUB.G_LINE := NULL;

7837: If x_return_status = 'NOOP' Then
7838: IF l_debug_level > 0 THEN
7839: oe_debug_pub.add( 'THERE ARE NO ORDER LINES FOR '||P_LINE_ID ) ;
7840: END IF;
7841: OE_Order_PUB.G_LINE := NULL;
7842: OE_Order_PUB.G_HDR := NULL;
7843: Return;
7844: End If;
7845:

Line 7842: OE_Order_PUB.G_HDR := NULL;

7838: IF l_debug_level > 0 THEN
7839: oe_debug_pub.add( 'THERE ARE NO ORDER LINES FOR '||P_LINE_ID ) ;
7840: END IF;
7841: OE_Order_PUB.G_LINE := NULL;
7842: OE_Order_PUB.G_HDR := NULL;
7843: Return;
7844: End If;
7845:
7846: IF l_debug_level > 0 THEN

Line 7883: OE_Order_PUB.G_LINE := NULL;

7879: END IF;
7880: raise fnd_api.g_exc_error;
7881: END IF;
7882: --reseting global structure after engine call
7883: OE_Order_PUB.G_LINE := NULL;
7884: OE_Order_PUB.G_HDR := NULL;
7885:
7886: IF l_debug_level > 0 THEN
7887: oe_debug_pub.add( 'EXITING OE_ORDER_PRICE_PVT.PRICE_LINE' , 1 ) ;

Line 7884: OE_Order_PUB.G_HDR := NULL;

7880: raise fnd_api.g_exc_error;
7881: END IF;
7882: --reseting global structure after engine call
7883: OE_Order_PUB.G_LINE := NULL;
7884: OE_Order_PUB.G_HDR := NULL;
7885:
7886: IF l_debug_level > 0 THEN
7887: oe_debug_pub.add( 'EXITING OE_ORDER_PRICE_PVT.PRICE_LINE' , 1 ) ;
7888: END IF;

Line 7894: OE_Order_PUB.G_LINE := NULL;

7890: Exception
7891: WHEN FND_API.G_EXC_ERROR THEN
7892:
7893: --reseting global structure after engine call
7894: OE_Order_PUB.G_LINE := NULL;
7895: OE_Order_PUB.G_HDR := NULL;
7896: x_return_status := FND_API.G_RET_STS_ERROR;
7897:
7898: IF l_debug_level > 0 THEN

Line 7895: OE_Order_PUB.G_HDR := NULL;

7891: WHEN FND_API.G_EXC_ERROR THEN
7892:
7893: --reseting global structure after engine call
7894: OE_Order_PUB.G_LINE := NULL;
7895: OE_Order_PUB.G_HDR := NULL;
7896: x_return_status := FND_API.G_RET_STS_ERROR;
7897:
7898: IF l_debug_level > 0 THEN
7899: oe_debug_pub.add( 'EXITING PRICE_LINE WITH EXC ERROR' , 1 ) ;

Line 7905: OE_Order_PUB.G_LINE := NULL;

7901: RAISE FND_API.G_EXC_ERROR;
7902: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7903:
7904: --reseting global structure after engine call
7905: OE_Order_PUB.G_LINE := NULL;
7906: OE_Order_PUB.G_HDR := NULL;
7907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7908: IF l_debug_level > 0 THEN
7909: oe_debug_pub.add( 'EXITING PRICE_LINE WITH UNEXPECTED ERROR' , 1 ) ;

Line 7906: OE_Order_PUB.G_HDR := NULL;

7902: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7903:
7904: --reseting global structure after engine call
7905: OE_Order_PUB.G_LINE := NULL;
7906: OE_Order_PUB.G_HDR := NULL;
7907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7908: IF l_debug_level > 0 THEN
7909: oe_debug_pub.add( 'EXITING PRICE_LINE WITH UNEXPECTED ERROR' , 1 ) ;
7910: END IF;

Line 7916: OE_Order_PUB.G_LINE := NULL;

7912: WHEN OTHERS THEN
7913:
7914: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7915: --reseting global structure after engine call
7916: OE_Order_PUB.G_LINE := NULL;
7917: OE_Order_PUB.G_HDR := NULL;
7918: IF l_debug_level > 0 THEN
7919: oe_debug_pub.add( 'ERROR IN OE_ORDER_PRICE_PVT.PRICE_LINE' , 1 ) ;
7920: END IF;

Line 7917: OE_Order_PUB.G_HDR := NULL;

7913:
7914: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7915: --reseting global structure after engine call
7916: OE_Order_PUB.G_LINE := NULL;
7917: OE_Order_PUB.G_HDR := NULL;
7918: IF l_debug_level > 0 THEN
7919: oe_debug_pub.add( 'ERROR IN OE_ORDER_PRICE_PVT.PRICE_LINE' , 1 ) ;
7920: END IF;
7921: IF l_debug_level > 0 THEN