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

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

74: l_return_status VARCHAR2(1);
75: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
76: l_error NUMBER := 0;
77: --
78: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
79: --
80: BEGIN
81:
82: IF l_debug_level > 0 THEN

Line 83: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE.DEFAULT_ATTRIBUTES' , 1 ) ;

79: --
80: BEGIN
81:
82: IF l_debug_level > 0 THEN
83: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE.DEFAULT_ATTRIBUTES' , 1 ) ;
84: END IF;
85:
86: l_error := 1;
87: -- Set UI flag to TRUE

Line 236: oe_debug_pub.add( 'LINE CONTROLLER - DEFAULT ATTRIBUTES - CALLING PROCESS' , 2 ) ;

232: -- Populate line table
233:
234:
235: IF l_debug_level > 0 THEN
236: oe_debug_pub.add( 'LINE CONTROLLER - DEFAULT ATTRIBUTES - CALLING PROCESS' , 2 ) ;
237: END IF;
238:
239: -- Call Oe_Order_Pvt.Process_order
240:

Line 254: oe_debug_pub.add( 'LINE CONTROLLER - DEFAULT ATTRIBUTES - AFTER PROCESS' , 2 ) ;

250: );
251:
252: l_error := 3;
253: IF l_debug_level > 0 THEN
254: oe_debug_pub.add( 'LINE CONTROLLER - DEFAULT ATTRIBUTES - AFTER PROCESS' , 2 ) ;
255: END IF;
256:
257: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
258: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 278: oe_debug_pub.add( 'LINE CONTROLLER - DEFAULT ATTRIBUTES - CALLING WRITE LINE' , 2 ) ;

274: -- Write to cache.
275: -- Set db_flag to False before writing to cache
276:
277: IF l_debug_level > 0 THEN
278: oe_debug_pub.add( 'LINE CONTROLLER - DEFAULT ATTRIBUTES - CALLING WRITE LINE' , 2 ) ;
279: END IF;
280:
281: x_line_tbl(1).db_flag := FND_API.G_FALSE;
282:

Line 302: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE.DEFAULT_ATTRIBUTES' , 1 ) ;

298: , p_data => x_msg_data
299: );
300:
301: IF l_debug_level > 0 THEN
302: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE.DEFAULT_ATTRIBUTES' , 1 ) ;
303: END IF;
304:
305: EXCEPTION
306:

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

363: )
364: IS
365: l_date_format_mask VARCHAR2(30) := p_date_format_mask;
366: --
367: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
368: --
369: BEGIN
370: IF l_debug_level > 0 THEN
371: oe_debug_pub.add( 'ATTRIBUTE VALUE : '|| P_ATTR_VALUE ) ; --bug 5179564

Line 371: oe_debug_pub.add( 'ATTRIBUTE VALUE : '|| P_ATTR_VALUE ) ; --bug 5179564

367: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
368: --
369: BEGIN
370: IF l_debug_level > 0 THEN
371: oe_debug_pub.add( 'ATTRIBUTE VALUE : '|| P_ATTR_VALUE ) ; --bug 5179564
372: END IF;
373:
374: IF p_attr_id = OE_Line_Util.G_ACCOUNTING_RULE THEN
375: x_line_tbl(1).accounting_rule_id := TO_NUMBER(p_attr_value);

Line 627: oe_debug_pub.add( 'SHIP TO CONTACT1'|| X_LINE_TBL ( 1 ) .SHIP_TO_CONTACT_ID , 1 ) ;

623: x_line_tbl(1).shipping_interfaced_flag := p_attr_value;
624: ELSIF p_attr_id = OE_Line_Util.G_SHIP_TO_CONTACT THEN
625: x_line_tbl(1).ship_to_contact_id := TO_NUMBER(p_attr_value);
626: IF l_debug_level > 0 THEN
627: oe_debug_pub.add( 'SHIP TO CONTACT1'|| X_LINE_TBL ( 1 ) .SHIP_TO_CONTACT_ID , 1 ) ;
628: END IF;
629: ELSIF p_attr_id = OE_Line_Util.G_SHIP_TO_ORG THEN
630: x_line_tbl(1).ship_to_org_id := TO_NUMBER(p_attr_value);
631: ELSIF p_attr_id = OE_Line_Util.G_SHIP_MODEL_COMPLETE_FLAG THEN

Line 692: oe_debug_pub.add( 'RAJ CONTROLLER - ATTRIBUTE CHANGE'|| P_ATTR_VALUE ) ;

688: ELSIF p_attr_id = OE_Line_Util.G_ARRIVAL_SET THEN
689: x_line_tbl(1).arrival_set_id := TO_NUMBER(p_attr_value);
690: ELSIF p_attr_id = OE_Line_Util.G_ARRIVAL_SET_NAME THEN
691: IF l_debug_level > 0 THEN
692: oe_debug_pub.add( 'RAJ CONTROLLER - ATTRIBUTE CHANGE'|| P_ATTR_VALUE ) ;
693: END IF;
694: IF p_attr_value IS NULL THEN
695: x_line_tbl(1).arrival_set_id := NULL;
696: x_line_tbl(1).arrival_set := p_attr_value;

Line 1017: oe_debug_pub.add( 'JYOTHI: I AM IN CHANGE ATTRIBUTE' ) ;

1013: OR p_attr_id = OE_Line_Util.G_TP_ATTRIBUTE9
1014: OR p_attr_id = OE_Line_Util.G_TP_CONTEXT
1015: THEN
1016: IF l_debug_level > 0 THEN
1017: oe_debug_pub.add( 'JYOTHI: I AM IN CHANGE ATTRIBUTE' ) ;
1018: END IF;
1019:
1020: x_line_tbl(1).tp_attribute1 := p_line_dff_rec.tp_attribute1;
1021: x_line_tbl(1).tp_attribute10 := p_line_dff_rec.tp_attribute10;

Line 1038: oe_debug_pub.add( 'JYOTHI- TP ATTRIBUTE IS ' || X_LINE_TBL ( 1 ) .TP_ATTRIBUTE1 ) ;

1034: x_line_tbl(1).tp_attribute9 := p_line_dff_rec.tp_attribute9;
1035: x_line_tbl(1).tp_context := p_line_dff_rec.tp_context;
1036:
1037: IF l_debug_level > 0 THEN
1038: oe_debug_pub.add( 'JYOTHI- TP ATTRIBUTE IS ' || X_LINE_TBL ( 1 ) .TP_ATTRIBUTE1 ) ;
1039: END IF;
1040: ELSIF p_attr_id = OE_Line_Util.G_COMMITMENT THEN
1041: x_line_tbl(1).commitment_id := TO_NUMBER(p_attr_value);
1042: ELSIF p_attr_id = OE_Line_Util.G_COMMITMENT_APPLIED_AMOUNT THEN

Line 1047: oe_debug_pub.add( 'P_ATTR_VALUE='||P_ATTR_VALUE ) ;

1043: x_line_tbl(1).commitment_applied_amount := TO_NUMBER(p_attr_value);
1044: --MRG BGN
1045: ELSIF p_attr_id = OE_LINE_UTIL.G_UNIT_COST Then
1046: IF l_debug_level > 0 THEN
1047: oe_debug_pub.add( 'P_ATTR_VALUE='||P_ATTR_VALUE ) ;
1048: END IF;
1049: x_line_tbl(1).unit_cost := TO_NUMBER(p_attr_value);
1050: IF l_debug_level > 0 THEN
1051: oe_debug_pub.add( 'FLINB:UNIT_COST:'||P_ATTR_VALUE ) ;

Line 1051: oe_debug_pub.add( 'FLINB:UNIT_COST:'||P_ATTR_VALUE ) ;

1047: oe_debug_pub.add( 'P_ATTR_VALUE='||P_ATTR_VALUE ) ;
1048: END IF;
1049: x_line_tbl(1).unit_cost := TO_NUMBER(p_attr_value);
1050: IF l_debug_level > 0 THEN
1051: oe_debug_pub.add( 'FLINB:UNIT_COST:'||P_ATTR_VALUE ) ;
1052: END IF;
1053: --MRG END
1054: --retro{
1055: ELSIF p_attr_id = OE_Line_Util.G_RETROBILL_REQUEST THEN

Line 1084: oe_debug_pub.add( 'UNRECOGNIZED ATTRIBUTE EXCEPTION' , 2 ) ;

1080:
1081: ELSE
1082:
1083: IF l_debug_level > 0 THEN
1084: oe_debug_pub.add( 'UNRECOGNIZED ATTRIBUTE EXCEPTION' , 2 ) ;
1085: END IF;
1086:
1087: -- Unexpected error, unrecognized attribute
1088:

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

1160: file_name varchar2(100);
1161: i pls_Integer;
1162: L_PRICE_CONTROL_REC QP_PREQ_GRP.control_record_type;
1163: --
1164: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1165: --
1166: BEGIN
1167:
1168: IF l_debug_level > 0 THEN

Line 1169: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE.CHANGE_ATTRIBUTES' , 1 ) ;

1165: --
1166: BEGIN
1167:
1168: IF l_debug_level > 0 THEN
1169: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE.CHANGE_ATTRIBUTES' , 1 ) ;
1170: END IF;
1171:
1172: -- Set UI flag to TRUE
1173: OE_GLOBALS.G_UI_FLAG := TRUE;

Line 1227: oe_debug_pub.add( 'DATE TYPE RETURNED UNEXP_ERROR' , 2 ) ;

1223: , x_return_status => l_return_status
1224: );
1225: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1226: IF l_debug_level > 0 THEN
1227: oe_debug_pub.add( 'DATE TYPE RETURNED UNEXP_ERROR' , 2 ) ;
1228: END IF;
1229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1230: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1231: IF l_debug_level > 0 THEN

Line 1232: oe_debug_pub.add( 'DATE TYPE RETURN RET_STS_ERROR' , 2 ) ;

1228: END IF;
1229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1230: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1231: IF l_debug_level > 0 THEN
1232: oe_debug_pub.add( 'DATE TYPE RETURN RET_STS_ERROR' , 2 ) ;
1233: END IF;
1234: RAISE FND_API.G_EXC_ERROR;
1235: END IF;
1236:

Line 1247: oe_debug_pub.add( 'JPN:AFTER LINE QUERY : ' || X_LINE_TBL ( 1 ) .TP_ATTRIBUTE1 ) ;

1243: , x_line_rec => x_line_tbl(1)
1244: );
1245:
1246: IF l_debug_level > 0 THEN
1247: oe_debug_pub.add( 'JPN:AFTER LINE QUERY : ' || X_LINE_TBL ( 1 ) .TP_ATTRIBUTE1 ) ;
1248: END IF;
1249:
1250: x_old_line_tbl(1) := x_line_tbl(1);
1251:

Line 1260: oe_debug_pub.add( 'Code Release is >= 11.5.9') ;

1256:
1257: IF OE_CODE_CONTROL.Code_Release_Level >= '110509' THEN
1258:
1259: IF l_debug_level > 0 THEN
1260: oe_debug_pub.add( 'Code Release is >= 11.5.9') ;
1261: END IF;
1262:
1263: Copy_Attribute_To_Rec
1264: (p_attr_id => p_attr_id

Line 1288: oe_debug_pub.add( 'Code Release is < 11.5.9') ;

1284:
1285: ELSE
1286:
1287: IF l_debug_level > 0 THEN
1288: oe_debug_pub.add( 'Code Release is < 11.5.9') ;
1289: END IF;
1290:
1291: -- PLEASE ADD THIS IF LOGIC FOR NEW ATTRIBUTES TO THE PROCEDURE
1292: -- COPY_ATTRIBUTE_TO_REC ALSO. THIS NEW PROCEDURE WILL REPLACE

Line 1548: oe_debug_pub.add( 'SHIP TO CONTACT1'|| X_LINE_TBL ( 1 ) .SHIP_TO_CONTACT_ID , 1 ) ;

1544: x_line_tbl(1).shipping_interfaced_flag := p_attr_value;
1545: ELSIF p_attr_id = OE_Line_Util.G_SHIP_TO_CONTACT THEN
1546: x_line_tbl(1).ship_to_contact_id := TO_NUMBER(p_attr_value);
1547: IF l_debug_level > 0 THEN
1548: oe_debug_pub.add( 'SHIP TO CONTACT1'|| X_LINE_TBL ( 1 ) .SHIP_TO_CONTACT_ID , 1 ) ;
1549: END IF;
1550: ELSIF p_attr_id = OE_Line_Util.G_SHIP_TO_ORG THEN
1551: x_line_tbl(1).ship_to_org_id := TO_NUMBER(p_attr_value);
1552: ELSIF p_attr_id = OE_Line_Util.G_SHIP_MODEL_COMPLETE_FLAG THEN

Line 1616: oe_debug_pub.add( 'RAJ CONTROLLER - ATTRIBUTE CHANGE'|| P_ATTR_VALUE ) ;

1612: ELSIF p_attr_id = OE_LINE_UTIL.G_CHARGE_PERIODICITY THEN
1613: x_line_tbl(1).charge_periodicity_code := p_attr_value;
1614: ELSIF p_attr_id = OE_Line_Util.G_ARRIVAL_SET_NAME THEN
1615: IF l_debug_level > 0 THEN
1616: oe_debug_pub.add( 'RAJ CONTROLLER - ATTRIBUTE CHANGE'|| P_ATTR_VALUE ) ;
1617: END IF;
1618: IF p_attr_value IS NULL THEN
1619: x_line_tbl(1).arrival_set_id := NULL;
1620: x_line_tbl(1).arrival_set := p_attr_value;

Line 1925: oe_debug_pub.add( 'JYOTHI: I AM IN CHANGE ATTRIBUTE' ) ;

1921: OR p_attr_id = OE_Line_Util.G_TP_ATTRIBUTE9
1922: OR p_attr_id = OE_Line_Util.G_TP_CONTEXT
1923: THEN
1924: IF l_debug_level > 0 THEN
1925: oe_debug_pub.add( 'JYOTHI: I AM IN CHANGE ATTRIBUTE' ) ;
1926: END IF;
1927:
1928: x_line_tbl(1).tp_attribute1 := p_line_dff_rec.tp_attribute1;
1929: x_line_tbl(1).tp_attribute10 := p_line_dff_rec.tp_attribute10;

Line 1946: oe_debug_pub.add( 'JYOTHI- TP ATTRIBUTE IS ' || X_LINE_TBL ( 1 ) .TP_ATTRIBUTE1 ) ;

1942: x_line_tbl(1).tp_attribute9 := p_line_dff_rec.tp_attribute9;
1943: x_line_tbl(1).tp_context := p_line_dff_rec.tp_context;
1944:
1945: IF l_debug_level > 0 THEN
1946: oe_debug_pub.add( 'JYOTHI- TP ATTRIBUTE IS ' || X_LINE_TBL ( 1 ) .TP_ATTRIBUTE1 ) ;
1947: END IF;
1948: ELSIF p_attr_id = OE_Line_Util.G_COMMITMENT THEN
1949: x_line_tbl(1).commitment_id := TO_NUMBER(p_attr_value);
1950: --MRG BGN

Line 1953: oe_debug_pub.add( 'P_ATTR_VALUE='||P_ATTR_VALUE ) ;

1949: x_line_tbl(1).commitment_id := TO_NUMBER(p_attr_value);
1950: --MRG BGN
1951: ELSIF p_attr_id = OE_LINE_UTIL.G_UNIT_COST Then
1952: IF l_debug_level > 0 THEN
1953: oe_debug_pub.add( 'P_ATTR_VALUE='||P_ATTR_VALUE ) ;
1954: END IF;
1955: x_line_tbl(1).unit_cost := TO_NUMBER(p_attr_value);
1956: IF l_debug_level > 0 THEN
1957: oe_debug_pub.add( 'FLINB:UNIT_COST:'||P_ATTR_VALUE ) ;

Line 1957: oe_debug_pub.add( 'FLINB:UNIT_COST:'||P_ATTR_VALUE ) ;

1953: oe_debug_pub.add( 'P_ATTR_VALUE='||P_ATTR_VALUE ) ;
1954: END IF;
1955: x_line_tbl(1).unit_cost := TO_NUMBER(p_attr_value);
1956: IF l_debug_level > 0 THEN
1957: oe_debug_pub.add( 'FLINB:UNIT_COST:'||P_ATTR_VALUE ) ;
1958: END IF;
1959: --MRG END
1960: -- INVCONV
1961: ELSIF p_attr_id = OE_Line_Util.G_CANCELLED_QUANTITY2 THEN

Line 1978: oe_debug_pub.add( 'UNRECOGNIZED ATTRIBUTE EXCEPTION' , 2 ) ;

1974: -- INVCONV
1975: ELSE
1976:
1977: IF l_debug_level > 0 THEN
1978: oe_debug_pub.add( 'UNRECOGNIZED ATTRIBUTE EXCEPTION' , 2 ) ;
1979: END IF;
1980:
1981: -- Unexpected error, unrecognized attribute
1982:

Line 2005: oe_debug_pub.add( 'SETTING OPERATION' , 2 ) ;

2001:
2002: -- Set Operation.
2003:
2004: IF l_debug_level > 0 THEN
2005: oe_debug_pub.add( 'SETTING OPERATION' , 2 ) ;
2006: END IF;
2007:
2008: IF FND_API.To_Boolean(x_line_tbl(1).db_flag) THEN
2009: x_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;

Line 2038: oe_debug_pub.add( 'DATE TYPE RETURNED UNEXP_ERROR' , 2 ) ;

2034: END IF;
2035:
2036: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2037: IF l_debug_level > 0 THEN
2038: oe_debug_pub.add( 'DATE TYPE RETURNED UNEXP_ERROR' , 2 ) ;
2039: END IF;
2040: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2041: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2042: IF l_debug_level > 0 THEN

Line 2043: oe_debug_pub.add( 'DATE TYPE RETURN RET_STS_ERROR' , 2 ) ;

2039: END IF;
2040: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2041: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2042: IF l_debug_level > 0 THEN
2043: oe_debug_pub.add( 'DATE TYPE RETURN RET_STS_ERROR' , 2 ) ;
2044: END IF;
2045: RAISE FND_API.G_EXC_ERROR;
2046: END IF;
2047:

Line 2070: oe_debug_pub.add( 'DATE TYPE RETURNED UNEXP_ERROR' , 2 ) ;

2066: END IF;
2067:
2068: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2069: IF l_debug_level > 0 THEN
2070: oe_debug_pub.add( 'DATE TYPE RETURNED UNEXP_ERROR' , 2 ) ;
2071: END IF;
2072: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2073: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2074: IF l_debug_level > 0 THEN

Line 2075: oe_debug_pub.add( 'DATE TYPE RETURN RET_STS_ERROR' , 2 ) ;

2071: END IF;
2072: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2073: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2074: IF l_debug_level > 0 THEN
2075: oe_debug_pub.add( 'DATE TYPE RETURN RET_STS_ERROR' , 2 ) ;
2076: END IF;
2077: RAISE FND_API.G_EXC_ERROR;
2078: END IF;
2079:

Line 2088: oe_debug_pub.add('Cannot change source type',2);

2084: = OE_GLOBALS.G_SOURCE_EXTERNAL
2085: AND (x_line_tbl(1).ship_set_id is not null
2086: OR x_line_tbl(1).arrival_set_id is not null)) THEN
2087: IF l_debug_level > 0 THEN
2088: oe_debug_pub.add('Cannot change source type',2);
2089: END IF;
2090: FND_MESSAGE.SET_NAME('ONT','ONT_CANT_CHG_SRC_TYPE');
2091: OE_MSG_PUB.Add;
2092: l_return_status := FND_API.G_RET_STS_ERROR;

Line 2098: oe_debug_pub.add( 'CALLING PROCESS ORDER' , 2 ) ;

2094: END IF;
2095: -- end for 3998402
2096:
2097: IF l_debug_level > 0 THEN
2098: oe_debug_pub.add( 'CALLING PROCESS ORDER' , 2 ) ;
2099: oe_debug_pub.add( 'BEFORE CALLING PROCESS ORDER' , 1 ) ;
2100: END IF;
2101:
2102: -- Call Oe_Order_Pvt.Process_order

Line 2099: oe_debug_pub.add( 'BEFORE CALLING PROCESS ORDER' , 1 ) ;

2095: -- end for 3998402
2096:
2097: IF l_debug_level > 0 THEN
2098: oe_debug_pub.add( 'CALLING PROCESS ORDER' , 2 ) ;
2099: oe_debug_pub.add( 'BEFORE CALLING PROCESS ORDER' , 1 ) ;
2100: END IF;
2101:
2102: -- Call Oe_Order_Pvt.Process_order
2103: Oe_Order_Pvt.Lines

Line 2114: oe_debug_pub.add( 'AFTER CALLING PROCESS ORDER' , 1 ) ;

2110: , x_return_status => l_return_status
2111: );
2112:
2113: IF l_debug_level > 0 THEN
2114: oe_debug_pub.add( 'AFTER CALLING PROCESS ORDER' , 1 ) ;
2115: END IF;
2116: --bug 2438466 begin
2117: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN -- Fix for bug3546224
2118: IF p_attr_id = OE_Line_Util.G_RETURN_CONTEXT THEN

Line 2130: oe_debug_pub.add( 'PROCESS ORDER RETURN UNEXP_ERROR' , 2 ) ;

2126: --bug 2438466 end
2127:
2128: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2129: IF l_debug_level > 0 THEN
2130: oe_debug_pub.add( 'PROCESS ORDER RETURN UNEXP_ERROR' , 2 ) ;
2131: END IF;
2132: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2133: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2134: IF l_debug_level > 0 THEN

Line 2135: oe_debug_pub.add( 'PROCESS ORDER RETURN RET_STS_ERROR' , 2 ) ;

2131: END IF;
2132: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2133: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2134: IF l_debug_level > 0 THEN
2135: oe_debug_pub.add( 'PROCESS ORDER RETURN RET_STS_ERROR' , 2 ) ;
2136: END IF;
2137: RAISE FND_API.G_EXC_ERROR;
2138: END IF;
2139:

Line 2171: oe_debug_pub.add( 'WRITING TO CACHE' , 2 ) ;

2167: x_lot_divisible_flag := l_x_item_rec_type.lot_divisible_flag; -- INVCONV
2168:
2169: -- Write to cache.
2170: IF l_debug_level > 0 THEN
2171: oe_debug_pub.add( 'WRITING TO CACHE' , 2 ) ;
2172: END IF;
2173:
2174: Write_line
2175: ( p_line_rec => x_line_tbl(1)

Line 2193: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE.CHANGE_ATTRIBUTE' , 1 ) ;

2189: , p_data => x_msg_data
2190: );
2191:
2192: IF l_debug_level > 0 THEN
2193: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE.CHANGE_ATTRIBUTE' , 1 ) ;
2194: END IF;
2195:
2196: EXCEPTION
2197:

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

2268: l_last_index NUMBER;
2269: l_organization_id NUMBER:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
2270: l_set_rec OE_ORDER_CACHE.set_rec_type; -- 2806483
2271: --
2272: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2273: --
2274: BEGIN
2275:
2276: SAVEPOINT Line_Validate_And_Write;

Line 2279: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE.VALIDATE_AND_WRITE' , 1 ) ;

2275:
2276: SAVEPOINT Line_Validate_And_Write;
2277:
2278: IF l_debug_level > 0 THEN
2279: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE.VALIDATE_AND_WRITE' , 1 ) ;
2280: END IF;
2281:
2282: -- Set UI flag to TRUE
2283: OE_GLOBALS.G_UI_FLAG := TRUE;

Line 2343: oe_debug_pub.add( 'IN VALIDATE_AND_WRITE' ) ;

2339:
2340: -- Call Oe_Order_Pvt.Process_order
2341:
2342: IF l_debug_level > 0 THEN
2343: oe_debug_pub.add( 'IN VALIDATE_AND_WRITE' ) ;
2344: END IF;
2345: oe_debug_pub.add( 'IN VALIDATE_AND_WRITE Change Reason'||p_change_reason_code ) ;
2346: Oe_Order_Pvt.Lines
2347: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE

Line 2345: oe_debug_pub.add( 'IN VALIDATE_AND_WRITE Change Reason'||p_change_reason_code ) ;

2341:
2342: IF l_debug_level > 0 THEN
2343: oe_debug_pub.add( 'IN VALIDATE_AND_WRITE' ) ;
2344: END IF;
2345: oe_debug_pub.add( 'IN VALIDATE_AND_WRITE Change Reason'||p_change_reason_code ) ;
2346: Oe_Order_Pvt.Lines
2347: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
2348: , p_init_msg_list => FND_API.G_TRUE
2349: , p_control_rec => l_control_rec

Line 2425: oe_debug_pub.add( 'CALLING TO PROCESS DELAYED REQUEST FOR COMMITMENT!' , 1 ) ;

2421: END IF;
2422:
2423: -- lkxu, commitment enhancement
2424: IF l_debug_level > 0 THEN
2425: oe_debug_pub.add( 'CALLING TO PROCESS DELAYED REQUEST FOR COMMITMENT!' , 1 ) ;
2426: END IF;
2427:
2428: IF OE_GLOBALS.G_DEFER_PRICING='N' THEN
2429: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

Line 2563: oe_debug_pub.add( 'ARRIVALSET-'|| TO_CHAR ( L_X_LINE_REC.ARRIVAL_SET_ID ) , 2 ) ;

2559: END IF;
2560: -- 2817915
2561:
2562: IF l_debug_level > 0 THEN
2563: oe_debug_pub.add( 'ARRIVALSET-'|| TO_CHAR ( L_X_LINE_REC.ARRIVAL_SET_ID ) , 2 ) ;
2564: END IF;
2565: -- Calculate Tax
2566:
2567: x_line_val_rec.x_line_tax_value := l_x_line_rec.tax_value;

Line 2570: oe_debug_pub.add( 'TAX VALUE IS'|| TO_CHAR ( L_X_LINE_REC.TAX_VALUE ) , 1 ) ;

2566:
2567: x_line_val_rec.x_line_tax_value := l_x_line_rec.tax_value;
2568:
2569: IF l_debug_level > 0 THEN
2570: oe_debug_pub.add( 'TAX VALUE IS'|| TO_CHAR ( L_X_LINE_REC.TAX_VALUE ) , 1 ) ;
2571: oe_debug_pub.add( 'CALLING ORDER TOTAL' , 2 ) ;
2572: END IF;
2573:
2574: -- Call the charges API to get the Line level charges.

Line 2571: oe_debug_pub.add( 'CALLING ORDER TOTAL' , 2 ) ;

2567: x_line_val_rec.x_line_tax_value := l_x_line_rec.tax_value;
2568:
2569: IF l_debug_level > 0 THEN
2570: oe_debug_pub.add( 'TAX VALUE IS'|| TO_CHAR ( L_X_LINE_REC.TAX_VALUE ) , 1 ) ;
2571: oe_debug_pub.add( 'CALLING ORDER TOTAL' , 2 ) ;
2572: END IF;
2573:
2574: -- Call the charges API to get the Line level charges.
2575: IF OE_GLOBALS.G_DEFER_PRICING='N' THEN

Line 2659: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE.VALIDATE_AND_WRITE' , 1 ) ;

2655: , p_data => x_msg_data
2656: );
2657:
2658: IF l_debug_level > 0 THEN
2659: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE.VALIDATE_AND_WRITE' , 1 ) ;
2660: END IF;
2661:
2662:
2663: EXCEPTION

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

2758: l_x_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
2759: l_control_rec OE_GLOBALS.Control_Rec_Type;
2760: l_return_status VARCHAR2(1);
2761: --
2762: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2763: --
2764: BEGIN
2765: SAVEPOINT LINE_DELETE;
2766: IF l_debug_level > 0 THEN

Line 2767: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE.DELETE_ROW' , 1 ) ;

2763: --
2764: BEGIN
2765: SAVEPOINT LINE_DELETE;
2766: IF l_debug_level > 0 THEN
2767: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE.DELETE_ROW' , 1 ) ;
2768: END IF;
2769:
2770: -- Set UI flag to TRUE
2771: OE_GLOBALS.G_UI_FLAG := TRUE;

Line 2845: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE.DELETE_ROW' , 1 ) ;

2841: , p_data => x_msg_data
2842: );
2843:
2844: IF l_debug_level > 0 THEN
2845: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE.DELETE_ROW' , 1 ) ;
2846: END IF;
2847:
2848: EXCEPTION
2849:

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

2932: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2933: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2934: --serla end
2935: --
2936: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2937: --
2938: BEGIN
2939:
2940: IF l_debug_level > 0 THEN

Line 2941: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE.PROCESS_ENTITY' , 1 ) ;

2937: --
2938: BEGIN
2939:
2940: IF l_debug_level > 0 THEN
2941: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE.PROCESS_ENTITY' , 1 ) ;
2942: END IF;
2943:
2944: -- Set UI flag to TRUE
2945: OE_GLOBALS.G_UI_FLAG := TRUE;

Line 3017: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE.PROCESS_ENTITY' , 1 ) ;

3013: , p_data => x_msg_data
3014: );
3015:
3016: IF l_debug_level > 0 THEN
3017: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE.PROCESS_ENTITY' , 1 ) ;
3018: END IF;
3019:
3020: EXCEPTION
3021:

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

3082: IS
3083: l_return_status VARCHAR2(1);
3084: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
3085: --
3086: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3087: --
3088: BEGIN
3089:
3090: IF l_debug_level > 0 THEN

Line 3091: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE.LOCK_ROW' , 1 ) ;

3087: --
3088: BEGIN
3089:
3090: IF l_debug_level > 0 THEN
3091: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE.LOCK_ROW' , 1 ) ;
3092: END IF;
3093:
3094: -- Load line record
3095:

Line 3116: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE.LOCK_ROW'||L_X_LINE_REC.LINE_ID , 1 ) ;

3112: -- Set DB flag and write record to cache.
3113:
3114: l_x_line_rec.db_flag := FND_API.G_TRUE;
3115: IF l_debug_level > 0 THEN
3116: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE.LOCK_ROW'||L_X_LINE_REC.LINE_ID , 1 ) ;
3117: END IF;
3118:
3119: Write_line
3120: ( p_line_rec => l_x_line_rec

Line 3143: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE.LOCK_ROW' , 1 ) ;

3139: , p_data => x_msg_data
3140: );
3141:
3142: IF l_debug_level > 0 THEN
3143: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE.LOCK_ROW' , 1 ) ;
3144: END IF;
3145:
3146: EXCEPTION
3147: WHEN FND_API.G_EXC_ERROR THEN

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

3200: , p_db_record IN BOOLEAN := FALSE
3201: )
3202: IS
3203: --
3204: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3205: --
3206: BEGIN
3207:
3208: IF l_debug_level > 0 THEN

Line 3209: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE.WRITE_LINE' , 1 ) ;

3205: --
3206: BEGIN
3207:
3208: IF l_debug_level > 0 THEN
3209: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE.WRITE_LINE' , 1 ) ;
3210: END IF;
3211: g_line_rec := p_line_rec;
3212:
3213: IF p_db_record THEN

Line 3220: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE.WRITE_LINE' , 1 ) ;

3216:
3217: END IF;
3218:
3219: IF l_debug_level > 0 THEN
3220: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE.WRITE_LINE' , 1 ) ;
3221: END IF;
3222:
3223: END Write_Line;
3224:

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

3228: , x_line_rec OUT NOCOPY OE_Order_PUB.Line_Rec_Type
3229: )
3230: IS
3231: --
3232: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3233: --
3234: BEGIN
3235:
3236: IF l_debug_level > 0 THEN

Line 3237: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE.GET_LINE'||P_LINE_ID , 1 ) ;

3233: --
3234: BEGIN
3235:
3236: IF l_debug_level > 0 THEN
3237: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE.GET_LINE'||P_LINE_ID , 1 ) ;
3238: END IF;
3239: --reverting back the fix made for bug 2103000 as the problem
3240: --is fixed in file OEXOEFRM.pld(version 115.251)
3241: --Fixes the issue reported in bug 2150247

Line 3247: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE.GET_LINE QUERY '||P_LINE_ID , 1 ) ;

3243: THEN
3244:
3245: -- Query row from DB
3246: IF l_debug_level > 0 THEN
3247: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE.GET_LINE QUERY '||P_LINE_ID , 1 ) ;
3248: END IF;
3249:
3250: OE_Line_Util.Query_Row
3251: ( p_line_id => p_line_id,

Line 3264: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE.GET_LINE' , 1 ) ;

3260:
3261: END IF;
3262:
3263: IF l_debug_level > 0 THEN
3264: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE.GET_LINE' , 1 ) ;
3265: END IF;
3266:
3267: IF p_db_record THEN
3268: --Added for bug3911285

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

3283:
3284: PROCEDURE Clear_Line
3285: IS
3286: --
3287: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3288: --
3289: BEGIN
3290:
3291: IF l_debug_level > 0 THEN

Line 3292: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE.CLEAR_LINE' , 1 ) ;

3288: --
3289: BEGIN
3290:
3291: IF l_debug_level > 0 THEN
3292: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE.CLEAR_LINE' , 1 ) ;
3293: END IF;
3294:
3295: g_line_rec := OE_Order_PUB.G_MISS_LINE_REC;
3296: g_db_line_rec := OE_Order_PUB.G_MISS_LINE_REC;

Line 3299: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE.CLEAR_LINE' , 1 ) ;

3295: g_line_rec := OE_Order_PUB.G_MISS_LINE_REC;
3296: g_db_line_rec := OE_Order_PUB.G_MISS_LINE_REC;
3297:
3298: IF l_debug_level > 0 THEN
3299: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE.CLEAR_LINE' , 1 ) ;
3300: END IF;
3301:
3302: END Clear_Line;
3303:

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

3409: l_order_margin_amount NUMBER;
3410: --MRG END
3411:
3412: --
3413: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3414: --
3415: --7832836 l_cascade_hold_non_smc VARCHAR2(1) := NVL(OE_SYS_PARAMETERS.VALUE('ONT_CASCADE_HOLD_NONSMC_PTO'),'N'); --ER#7479609
3416: l_cascade_hold_non_smc VARCHAR2(1); -- 7832836
3417: BEGIN

Line 3540: oe_debug_pub.add('GOING TO CHECK FOR CONFIG VALIDATION HOLD FOR '||l_top_model_line_id,1);

3536: --5737464
3537: IF l_smc_flag = 'N' AND x_line_val_rec.cascaded_hold_exists_flag = 'N'
3538: THEN
3539: IF l_debug_level > 0 THEN
3540: oe_debug_pub.add('GOING TO CHECK FOR CONFIG VALIDATION HOLD FOR '||l_top_model_line_id,1);
3541: END IF;
3542:
3543: BEGIN
3544: l_hold_exists := NULL;

Line 3575: oe_debug_pub.add('HOLD CASCADED TO LINE ID '||p_line_rec.line_id,1);

3571:
3572: IF p_line_rec.cancelled_flag = 'N' and p_line_rec.open_flag = 'Y'
3573: THEN
3574: IF l_debug_level > 0 THEN
3575: oe_debug_pub.add('HOLD CASCADED TO LINE ID '||p_line_rec.line_id,1);
3576: END IF;
3577: x_line_val_rec.cascaded_hold_exists_flag := 'Y';
3578: END IF;
3579: END IF;

Line 3648: oe_debug_pub.add('In NO Data Found ');

3644: and h.header_id=l.header_id;
3645: EXCEPTION
3646: WHEN NO_DATA_FOUND THEN
3647: Null;
3648: oe_debug_pub.add('In NO Data Found ');
3649: When too_many_rows then
3650: Null;
3651: When others then
3652: oe_debug_pub.add('In Others Found ');

Line 3652: oe_debug_pub.add('In Others Found ');

3648: oe_debug_pub.add('In NO Data Found ');
3649: When too_many_rows then
3650: Null;
3651: When others then
3652: oe_debug_pub.add('In Others Found ');
3653: Null;
3654: END;
3655: END IF;
3656:

Line 3854: oe_debug_pub.add( 'IN OEXFLINB. ITEM IDENTIFIER IS INT' ) ;

3850:
3851: IF NVL(p_line_rec.item_identifier_type, 'INT') = 'INT' THEN
3852: BEGIN
3853: IF l_debug_level > 0 THEN
3854: oe_debug_pub.add( 'IN OEXFLINB. ITEM IDENTIFIER IS INT' ) ;
3855: END IF;
3856: SELECT description
3857: ,concatenated_segments
3858: ,concatenated_segments /*Bug 1766327 chhung*/

Line 3866: oe_debug_pub.add( 'DESCRIPTION: '||X_LINE_VAL_REC.ITEM_DESCRIPTION ) ;

3862: FROM mtl_system_items_vl
3863: WHERE inventory_item_id = p_line_rec.inventory_item_id
3864: AND organization_id = l_organization_id;
3865: IF l_debug_level > 0 THEN
3866: oe_debug_pub.add( 'DESCRIPTION: '||X_LINE_VAL_REC.ITEM_DESCRIPTION ) ;
3867: oe_debug_pub.add( 'ORDERED_ITEM_DSP: '||X_LINE_VAL_REC.ORDERED_ITEM_DSP ) ;
3868: oe_debug_pub.add( 'INVENTORY_ITEM: '|| X_LINE_VAL_REC.INVENTORY_ITEM ) ;
3869: END IF;
3870:

Line 3867: oe_debug_pub.add( 'ORDERED_ITEM_DSP: '||X_LINE_VAL_REC.ORDERED_ITEM_DSP ) ;

3863: WHERE inventory_item_id = p_line_rec.inventory_item_id
3864: AND organization_id = l_organization_id;
3865: IF l_debug_level > 0 THEN
3866: oe_debug_pub.add( 'DESCRIPTION: '||X_LINE_VAL_REC.ITEM_DESCRIPTION ) ;
3867: oe_debug_pub.add( 'ORDERED_ITEM_DSP: '||X_LINE_VAL_REC.ORDERED_ITEM_DSP ) ;
3868: oe_debug_pub.add( 'INVENTORY_ITEM: '|| X_LINE_VAL_REC.INVENTORY_ITEM ) ;
3869: END IF;
3870:
3871: EXCEPTION

Line 3868: oe_debug_pub.add( 'INVENTORY_ITEM: '|| X_LINE_VAL_REC.INVENTORY_ITEM ) ;

3864: AND organization_id = l_organization_id;
3865: IF l_debug_level > 0 THEN
3866: oe_debug_pub.add( 'DESCRIPTION: '||X_LINE_VAL_REC.ITEM_DESCRIPTION ) ;
3867: oe_debug_pub.add( 'ORDERED_ITEM_DSP: '||X_LINE_VAL_REC.ORDERED_ITEM_DSP ) ;
3868: oe_debug_pub.add( 'INVENTORY_ITEM: '|| X_LINE_VAL_REC.INVENTORY_ITEM ) ;
3869: END IF;
3870:
3871: EXCEPTION
3872: WHEN NO_DATA_FOUND THEN

Line 3882: oe_debug_pub.add( 'IN OEXFLINB. ITEM IDENTIFIER IS CUST' ) ;

3878: END;
3879: ELSIF NVL(p_line_rec.item_identifier_type, 'INT') = 'CUST' THEN
3880: BEGIN
3881: IF l_debug_level > 0 THEN
3882: oe_debug_pub.add( 'IN OEXFLINB. ITEM IDENTIFIER IS CUST' ) ;
3883: END IF;
3884: SELECT nvl(citems.customer_item_desc, sitems.description)
3885: ,citems.customer_item_number
3886: ,sitems.concatenated_segments /*Bug 1766327 chhung*/

Line 3903: oe_debug_pub.add( 'DESCRIPTION: '||X_LINE_VAL_REC.ITEM_DESCRIPTION ) ;

3899: AND citems.customer_id = p_line_rec.sold_to_org_id
3900: AND cxref.master_organization_id = mp.master_organization_id
3901: AND mp.organization_id = sitems.organization_id ; -- bug 3918771
3902: IF l_debug_level > 0 THEN
3903: oe_debug_pub.add( 'DESCRIPTION: '||X_LINE_VAL_REC.ITEM_DESCRIPTION ) ;
3904: oe_debug_pub.add( 'ORDERED_ITEM_DSP: '||X_LINE_VAL_REC.ORDERED_ITEM_DSP ) ;
3905: oe_debug_pub.add( 'INVENTORY_ITEM: '|| X_LINE_VAL_REC.INVENTORY_ITEM ) ;
3906: END IF;
3907:

Line 3904: oe_debug_pub.add( 'ORDERED_ITEM_DSP: '||X_LINE_VAL_REC.ORDERED_ITEM_DSP ) ;

3900: AND cxref.master_organization_id = mp.master_organization_id
3901: AND mp.organization_id = sitems.organization_id ; -- bug 3918771
3902: IF l_debug_level > 0 THEN
3903: oe_debug_pub.add( 'DESCRIPTION: '||X_LINE_VAL_REC.ITEM_DESCRIPTION ) ;
3904: oe_debug_pub.add( 'ORDERED_ITEM_DSP: '||X_LINE_VAL_REC.ORDERED_ITEM_DSP ) ;
3905: oe_debug_pub.add( 'INVENTORY_ITEM: '|| X_LINE_VAL_REC.INVENTORY_ITEM ) ;
3906: END IF;
3907:
3908: EXCEPTION

Line 3905: oe_debug_pub.add( 'INVENTORY_ITEM: '|| X_LINE_VAL_REC.INVENTORY_ITEM ) ;

3901: AND mp.organization_id = sitems.organization_id ; -- bug 3918771
3902: IF l_debug_level > 0 THEN
3903: oe_debug_pub.add( 'DESCRIPTION: '||X_LINE_VAL_REC.ITEM_DESCRIPTION ) ;
3904: oe_debug_pub.add( 'ORDERED_ITEM_DSP: '||X_LINE_VAL_REC.ORDERED_ITEM_DSP ) ;
3905: oe_debug_pub.add( 'INVENTORY_ITEM: '|| X_LINE_VAL_REC.INVENTORY_ITEM ) ;
3906: END IF;
3907:
3908: EXCEPTION
3909: WHEN NO_DATA_FOUND THEN

Line 3926: oe_debug_pub.add('DESCRIPTION: '||X_LINE_VAL_REC.ITEM_DESCRIPTION ) ;

3922: WHERE inventory_item_id = p_line_rec.inventory_item_id
3923: AND organization_id = l_organization_id;
3924:
3925: IF l_debug_level > 0 THEN
3926: oe_debug_pub.add('DESCRIPTION: '||X_LINE_VAL_REC.ITEM_DESCRIPTION ) ;
3927: oe_debug_pub.add('ORDERED_ITEM_DSP: '||X_LINE_VAL_REC.ORDERED_ITEM_DSP ) ;
3928: oe_debug_pub.add('INVENTORY_ITEM: '|| X_LINE_VAL_REC.INVENTORY_ITEM ) ;
3929: END IF;
3930: END IF;

Line 3927: oe_debug_pub.add('ORDERED_ITEM_DSP: '||X_LINE_VAL_REC.ORDERED_ITEM_DSP ) ;

3923: AND organization_id = l_organization_id;
3924:
3925: IF l_debug_level > 0 THEN
3926: oe_debug_pub.add('DESCRIPTION: '||X_LINE_VAL_REC.ITEM_DESCRIPTION ) ;
3927: oe_debug_pub.add('ORDERED_ITEM_DSP: '||X_LINE_VAL_REC.ORDERED_ITEM_DSP ) ;
3928: oe_debug_pub.add('INVENTORY_ITEM: '|| X_LINE_VAL_REC.INVENTORY_ITEM ) ;
3929: END IF;
3930: END IF;
3931: When too_many_rows then

Line 3928: oe_debug_pub.add('INVENTORY_ITEM: '|| X_LINE_VAL_REC.INVENTORY_ITEM ) ;

3924:
3925: IF l_debug_level > 0 THEN
3926: oe_debug_pub.add('DESCRIPTION: '||X_LINE_VAL_REC.ITEM_DESCRIPTION ) ;
3927: oe_debug_pub.add('ORDERED_ITEM_DSP: '||X_LINE_VAL_REC.ORDERED_ITEM_DSP ) ;
3928: oe_debug_pub.add('INVENTORY_ITEM: '|| X_LINE_VAL_REC.INVENTORY_ITEM ) ;
3929: END IF;
3930: END IF;
3931: When too_many_rows then
3932: Null;

Line 3939: oe_debug_pub.add( 'IN OEXFLINB. ITEM IDENTIFIER IS '||P_LINE_REC.ITEM_IDENTIFIER_TYPE ) ;

3935: END;
3936: ELSE
3937: BEGIN
3938: IF l_debug_level > 0 THEN
3939: oe_debug_pub.add( 'IN OEXFLINB. ITEM IDENTIFIER IS '||P_LINE_REC.ITEM_IDENTIFIER_TYPE ) ;
3940: oe_debug_pub.add( 'ORDERED_ITEM_ID: '||P_LINE_REC.ORDERED_ITEM_ID ) ;
3941: END IF;
3942: IF p_line_rec.ordered_item_id IS NULL THEN
3943: IF l_debug_level > 0 THEN

Line 3940: oe_debug_pub.add( 'ORDERED_ITEM_ID: '||P_LINE_REC.ORDERED_ITEM_ID ) ;

3936: ELSE
3937: BEGIN
3938: IF l_debug_level > 0 THEN
3939: oe_debug_pub.add( 'IN OEXFLINB. ITEM IDENTIFIER IS '||P_LINE_REC.ITEM_IDENTIFIER_TYPE ) ;
3940: oe_debug_pub.add( 'ORDERED_ITEM_ID: '||P_LINE_REC.ORDERED_ITEM_ID ) ;
3941: END IF;
3942: IF p_line_rec.ordered_item_id IS NULL THEN
3943: IF l_debug_level > 0 THEN
3944: oe_debug_pub.add( 'ORDERED_ITEM_ID IS NULL ' ) ;

Line 3944: oe_debug_pub.add( 'ORDERED_ITEM_ID IS NULL ' ) ;

3940: oe_debug_pub.add( 'ORDERED_ITEM_ID: '||P_LINE_REC.ORDERED_ITEM_ID ) ;
3941: END IF;
3942: IF p_line_rec.ordered_item_id IS NULL THEN
3943: IF l_debug_level > 0 THEN
3944: oe_debug_pub.add( 'ORDERED_ITEM_ID IS NULL ' ) ;
3945: oe_debug_pub.add( 'ORDERED_ITEM: '||P_LINE_REC.ORDERED_ITEM ) ;
3946: END IF;
3947: SELECT nvl(items.description, sitems.description)
3948: ,items.cross_reference

Line 3945: oe_debug_pub.add( 'ORDERED_ITEM: '||P_LINE_REC.ORDERED_ITEM ) ;

3941: END IF;
3942: IF p_line_rec.ordered_item_id IS NULL THEN
3943: IF l_debug_level > 0 THEN
3944: oe_debug_pub.add( 'ORDERED_ITEM_ID IS NULL ' ) ;
3945: oe_debug_pub.add( 'ORDERED_ITEM: '||P_LINE_REC.ORDERED_ITEM ) ;
3946: END IF;
3947: SELECT nvl(items.description, sitems.description)
3948: ,items.cross_reference
3949: ,sitems.concatenated_segments /*Bug 1766327 chhung*/

Line 3963: oe_debug_pub.add( 'DESCRIPTION: '||X_LINE_VAL_REC.ITEM_DESCRIPTION ) ;

3959: AND sitems.inventory_item_id = p_line_rec.inventory_item_id
3960: AND items.cross_reference_type = p_line_rec.item_identifier_type
3961: AND items.cross_reference = p_line_rec.ordered_item;
3962: IF l_debug_level > 0 THEN
3963: oe_debug_pub.add( 'DESCRIPTION: '||X_LINE_VAL_REC.ITEM_DESCRIPTION ) ;
3964: oe_debug_pub.add( 'ORDERED_ITEM_DSP: '||X_LINE_VAL_REC.ORDERED_ITEM_DSP ) ;
3965: oe_debug_pub.add( 'INVENTORY_ITEM: '|| X_LINE_VAL_REC.INVENTORY_ITEM ) ;
3966: END IF;
3967: END IF;

Line 3964: oe_debug_pub.add( 'ORDERED_ITEM_DSP: '||X_LINE_VAL_REC.ORDERED_ITEM_DSP ) ;

3960: AND items.cross_reference_type = p_line_rec.item_identifier_type
3961: AND items.cross_reference = p_line_rec.ordered_item;
3962: IF l_debug_level > 0 THEN
3963: oe_debug_pub.add( 'DESCRIPTION: '||X_LINE_VAL_REC.ITEM_DESCRIPTION ) ;
3964: oe_debug_pub.add( 'ORDERED_ITEM_DSP: '||X_LINE_VAL_REC.ORDERED_ITEM_DSP ) ;
3965: oe_debug_pub.add( 'INVENTORY_ITEM: '|| X_LINE_VAL_REC.INVENTORY_ITEM ) ;
3966: END IF;
3967: END IF;
3968:

Line 3965: oe_debug_pub.add( 'INVENTORY_ITEM: '|| X_LINE_VAL_REC.INVENTORY_ITEM ) ;

3961: AND items.cross_reference = p_line_rec.ordered_item;
3962: IF l_debug_level > 0 THEN
3963: oe_debug_pub.add( 'DESCRIPTION: '||X_LINE_VAL_REC.ITEM_DESCRIPTION ) ;
3964: oe_debug_pub.add( 'ORDERED_ITEM_DSP: '||X_LINE_VAL_REC.ORDERED_ITEM_DSP ) ;
3965: oe_debug_pub.add( 'INVENTORY_ITEM: '|| X_LINE_VAL_REC.INVENTORY_ITEM ) ;
3966: END IF;
3967: END IF;
3968:
3969: EXCEPTION

Line 3987: oe_debug_pub.add('DESCRIPTION: '||X_LINE_VAL_REC.ITEM_DESCRIPTION ) ;

3983: WHERE inventory_item_id = p_line_rec.inventory_item_id
3984: AND organization_id = l_organization_id;
3985:
3986: IF l_debug_level > 0 THEN
3987: oe_debug_pub.add('DESCRIPTION: '||X_LINE_VAL_REC.ITEM_DESCRIPTION ) ;
3988: oe_debug_pub.add('ORDERED_ITEM_DSP: '||X_LINE_VAL_REC.ORDERED_ITEM_DSP ) ;
3989: oe_debug_pub.add('INVENTORY_ITEM: '|| X_LINE_VAL_REC.INVENTORY_ITEM ) ;
3990: END IF;
3991: END IF;

Line 3988: oe_debug_pub.add('ORDERED_ITEM_DSP: '||X_LINE_VAL_REC.ORDERED_ITEM_DSP ) ;

3984: AND organization_id = l_organization_id;
3985:
3986: IF l_debug_level > 0 THEN
3987: oe_debug_pub.add('DESCRIPTION: '||X_LINE_VAL_REC.ITEM_DESCRIPTION ) ;
3988: oe_debug_pub.add('ORDERED_ITEM_DSP: '||X_LINE_VAL_REC.ORDERED_ITEM_DSP ) ;
3989: oe_debug_pub.add('INVENTORY_ITEM: '|| X_LINE_VAL_REC.INVENTORY_ITEM ) ;
3990: END IF;
3991: END IF;
3992: When too_many_rows then

Line 3989: oe_debug_pub.add('INVENTORY_ITEM: '|| X_LINE_VAL_REC.INVENTORY_ITEM ) ;

3985:
3986: IF l_debug_level > 0 THEN
3987: oe_debug_pub.add('DESCRIPTION: '||X_LINE_VAL_REC.ITEM_DESCRIPTION ) ;
3988: oe_debug_pub.add('ORDERED_ITEM_DSP: '||X_LINE_VAL_REC.ORDERED_ITEM_DSP ) ;
3989: oe_debug_pub.add('INVENTORY_ITEM: '|| X_LINE_VAL_REC.INVENTORY_ITEM ) ;
3990: END IF;
3991: END IF;
3992: When too_many_rows then
3993: --Null;

Line 4815: OE_DEBUG_PUB.Add ('PCode:'||p_line_rec.charge_periodicity_code,5);

4811:
4812: x_line_val_rec.charge_periodicity := l_charge_periodicity;
4813:
4814: IF l_debug_level > 0 THEN
4815: OE_DEBUG_PUB.Add ('PCode:'||p_line_rec.charge_periodicity_code,5);
4816: OE_DEBUG_PUB.Add ('Populate value for Charge Periodicity',5);
4817: OE_DEBUG_PUB.Add ('Periodicity='||l_charge_periodicity,3);
4818: END IF;
4819: END IF;

Line 4816: OE_DEBUG_PUB.Add ('Populate value for Charge Periodicity',5);

4812: x_line_val_rec.charge_periodicity := l_charge_periodicity;
4813:
4814: IF l_debug_level > 0 THEN
4815: OE_DEBUG_PUB.Add ('PCode:'||p_line_rec.charge_periodicity_code,5);
4816: OE_DEBUG_PUB.Add ('Populate value for Charge Periodicity',5);
4817: OE_DEBUG_PUB.Add ('Periodicity='||l_charge_periodicity,3);
4818: END IF;
4819: END IF;
4820: */

Line 4817: OE_DEBUG_PUB.Add ('Periodicity='||l_charge_periodicity,3);

4813:
4814: IF l_debug_level > 0 THEN
4815: OE_DEBUG_PUB.Add ('PCode:'||p_line_rec.charge_periodicity_code,5);
4816: OE_DEBUG_PUB.Add ('Populate value for Charge Periodicity',5);
4817: OE_DEBUG_PUB.Add ('Periodicity='||l_charge_periodicity,3);
4818: END IF;
4819: END IF;
4820: */
4821: -- recurring charges }

Line 4849: oe_debug_pub.add( 'RETROBILLED_PRICE: '||x_line_val_rec.retrobilled_price) ;

4845: x_line_val_rec.retrobilled_price := l_unit_selling_price+l_retrobilled_price_diff;
4846: ELSE
4847: x_line_val_rec.retrobilled_price := null;
4848: END IF;
4849: oe_debug_pub.add( 'RETROBILLED_PRICE: '||x_line_val_rec.retrobilled_price) ;
4850:
4851: IF(p_line_rec.order_source_id=27) THEN
4852: SELECT orig_head.order_number,
4853: orig_lin.line_number,

Line 4878: oe_debug_pub.add( 'IN EXCEPTION: ' ||SQLERRM);

4874:
4875:
4876: EXCEPTION
4877: WHEN NO_DATA_FOUND THEN
4878: oe_debug_pub.add( 'IN EXCEPTION: ' ||SQLERRM);
4879: WHEN OTHERS THEN
4880: oe_debug_pub.add( 'IN EXCEPTION: ' ||SQLERRM);
4881: END;
4882: END IF;

Line 4880: oe_debug_pub.add( 'IN EXCEPTION: ' ||SQLERRM);

4876: EXCEPTION
4877: WHEN NO_DATA_FOUND THEN
4878: oe_debug_pub.add( 'IN EXCEPTION: ' ||SQLERRM);
4879: WHEN OTHERS THEN
4880: oe_debug_pub.add( 'IN EXCEPTION: ' ||SQLERRM);
4881: END;
4882: END IF;
4883: END IF;
4884: --retro}

Line 4887: oe_debug_pub.add( 'MACD configuration_id'||p_line_rec.configuration_id);

4883: END IF;
4884: --retro}
4885: --Macd
4886: IF l_debug_level > 0 THEN
4887: oe_debug_pub.add( 'MACD configuration_id'||p_line_rec.configuration_id);
4888: oe_debug_pub.add( 'MACD config_rev_nbr'||p_line_rec.config_rev_nbr);
4889: oe_debug_pub.add( 'MACD config_header_id'||p_line_rec.config_header_id);
4890: END IF;
4891: IF p_line_rec.configuration_id IS NOT NULL THEN

Line 4888: oe_debug_pub.add( 'MACD config_rev_nbr'||p_line_rec.config_rev_nbr);

4884: --retro}
4885: --Macd
4886: IF l_debug_level > 0 THEN
4887: oe_debug_pub.add( 'MACD configuration_id'||p_line_rec.configuration_id);
4888: oe_debug_pub.add( 'MACD config_rev_nbr'||p_line_rec.config_rev_nbr);
4889: oe_debug_pub.add( 'MACD config_header_id'||p_line_rec.config_header_id);
4890: END IF;
4891: IF p_line_rec.configuration_id IS NOT NULL THEN
4892: BEGIN

Line 4889: oe_debug_pub.add( 'MACD config_header_id'||p_line_rec.config_header_id);

4885: --Macd
4886: IF l_debug_level > 0 THEN
4887: oe_debug_pub.add( 'MACD configuration_id'||p_line_rec.configuration_id);
4888: oe_debug_pub.add( 'MACD config_rev_nbr'||p_line_rec.config_rev_nbr);
4889: oe_debug_pub.add( 'MACD config_header_id'||p_line_rec.config_header_id);
4890: END IF;
4891: IF p_line_rec.configuration_id IS NOT NULL THEN
4892: BEGIN
4893: select cz.name

Line 4900: oe_debug_pub.add( 'MACD instance name'||x_line_val_rec.instance_name);

4896: where cz.config_hdr_id = p_line_rec.config_header_id
4897: and cz.config_rev_nbr = p_line_rec.config_rev_nbr
4898: and cz.config_item_id = p_line_rec.configuration_id;
4899: IF l_debug_level > 0 THEN
4900: oe_debug_pub.add( 'MACD instance name'||x_line_val_rec.instance_name);
4901: END IF;
4902:
4903: EXCEPTION
4904:

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

5022:
5023:
5024: l_item_rec OE_Order_Cache.Item_Rec_Type;
5025: --
5026: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5027: --
5028: BEGIN
5029:
5030: POPULATE_CONTROL_FIELDS

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

5065: -- This change is required since we are dropping the profile OE_ORGANIZATION -- _ID. Change made by Esha.
5066: l_organization_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
5067: l_count NUMBER := 0;
5068: --
5069: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5070: --
5071: BEGIN
5072:
5073: IF l_debug_level > 0 THEN

Line 5074: oe_debug_pub.add( 'P_ITEM_IDENTIFIER_TYPE:'||P_ITEM_IDENTIFIER_TYPE ) ;

5070: --
5071: BEGIN
5072:
5073: IF l_debug_level > 0 THEN
5074: oe_debug_pub.add( 'P_ITEM_IDENTIFIER_TYPE:'||P_ITEM_IDENTIFIER_TYPE ) ;
5075: oe_debug_pub.add( 'P_ORDERED_ITEM_ID: '||P_ORDERED_ITEM_ID ) ;
5076: oe_debug_pub.add( 'P_INVENTORY_ITEM_ID: '||P_INVENTORY_ITEM_ID ) ;
5077: oe_debug_pub.add( 'P_ORDERED_ITEM: '||P_ORDERED_ITEM ) ;
5078: oe_debug_pub.add( 'P_SOLD_TO_ORG_ID: '||P_SOLD_TO_ORG_ID ) ;

Line 5075: oe_debug_pub.add( 'P_ORDERED_ITEM_ID: '||P_ORDERED_ITEM_ID ) ;

5071: BEGIN
5072:
5073: IF l_debug_level > 0 THEN
5074: oe_debug_pub.add( 'P_ITEM_IDENTIFIER_TYPE:'||P_ITEM_IDENTIFIER_TYPE ) ;
5075: oe_debug_pub.add( 'P_ORDERED_ITEM_ID: '||P_ORDERED_ITEM_ID ) ;
5076: oe_debug_pub.add( 'P_INVENTORY_ITEM_ID: '||P_INVENTORY_ITEM_ID ) ;
5077: oe_debug_pub.add( 'P_ORDERED_ITEM: '||P_ORDERED_ITEM ) ;
5078: oe_debug_pub.add( 'P_SOLD_TO_ORG_ID: '||P_SOLD_TO_ORG_ID ) ;
5079: oe_debug_pub.add( 'P_DESCRIPTION: '||P_DESCRIPTION ) ;

Line 5076: oe_debug_pub.add( 'P_INVENTORY_ITEM_ID: '||P_INVENTORY_ITEM_ID ) ;

5072:
5073: IF l_debug_level > 0 THEN
5074: oe_debug_pub.add( 'P_ITEM_IDENTIFIER_TYPE:'||P_ITEM_IDENTIFIER_TYPE ) ;
5075: oe_debug_pub.add( 'P_ORDERED_ITEM_ID: '||P_ORDERED_ITEM_ID ) ;
5076: oe_debug_pub.add( 'P_INVENTORY_ITEM_ID: '||P_INVENTORY_ITEM_ID ) ;
5077: oe_debug_pub.add( 'P_ORDERED_ITEM: '||P_ORDERED_ITEM ) ;
5078: oe_debug_pub.add( 'P_SOLD_TO_ORG_ID: '||P_SOLD_TO_ORG_ID ) ;
5079: oe_debug_pub.add( 'P_DESCRIPTION: '||P_DESCRIPTION ) ;
5080: oe_debug_pub.add( 'L_ORGANIZATION_ID: '||L_ORGANIZATION_ID ) ;

Line 5077: oe_debug_pub.add( 'P_ORDERED_ITEM: '||P_ORDERED_ITEM ) ;

5073: IF l_debug_level > 0 THEN
5074: oe_debug_pub.add( 'P_ITEM_IDENTIFIER_TYPE:'||P_ITEM_IDENTIFIER_TYPE ) ;
5075: oe_debug_pub.add( 'P_ORDERED_ITEM_ID: '||P_ORDERED_ITEM_ID ) ;
5076: oe_debug_pub.add( 'P_INVENTORY_ITEM_ID: '||P_INVENTORY_ITEM_ID ) ;
5077: oe_debug_pub.add( 'P_ORDERED_ITEM: '||P_ORDERED_ITEM ) ;
5078: oe_debug_pub.add( 'P_SOLD_TO_ORG_ID: '||P_SOLD_TO_ORG_ID ) ;
5079: oe_debug_pub.add( 'P_DESCRIPTION: '||P_DESCRIPTION ) ;
5080: oe_debug_pub.add( 'L_ORGANIZATION_ID: '||L_ORGANIZATION_ID ) ;
5081: END IF;

Line 5078: oe_debug_pub.add( 'P_SOLD_TO_ORG_ID: '||P_SOLD_TO_ORG_ID ) ;

5074: oe_debug_pub.add( 'P_ITEM_IDENTIFIER_TYPE:'||P_ITEM_IDENTIFIER_TYPE ) ;
5075: oe_debug_pub.add( 'P_ORDERED_ITEM_ID: '||P_ORDERED_ITEM_ID ) ;
5076: oe_debug_pub.add( 'P_INVENTORY_ITEM_ID: '||P_INVENTORY_ITEM_ID ) ;
5077: oe_debug_pub.add( 'P_ORDERED_ITEM: '||P_ORDERED_ITEM ) ;
5078: oe_debug_pub.add( 'P_SOLD_TO_ORG_ID: '||P_SOLD_TO_ORG_ID ) ;
5079: oe_debug_pub.add( 'P_DESCRIPTION: '||P_DESCRIPTION ) ;
5080: oe_debug_pub.add( 'L_ORGANIZATION_ID: '||L_ORGANIZATION_ID ) ;
5081: END IF;
5082:

Line 5079: oe_debug_pub.add( 'P_DESCRIPTION: '||P_DESCRIPTION ) ;

5075: oe_debug_pub.add( 'P_ORDERED_ITEM_ID: '||P_ORDERED_ITEM_ID ) ;
5076: oe_debug_pub.add( 'P_INVENTORY_ITEM_ID: '||P_INVENTORY_ITEM_ID ) ;
5077: oe_debug_pub.add( 'P_ORDERED_ITEM: '||P_ORDERED_ITEM ) ;
5078: oe_debug_pub.add( 'P_SOLD_TO_ORG_ID: '||P_SOLD_TO_ORG_ID ) ;
5079: oe_debug_pub.add( 'P_DESCRIPTION: '||P_DESCRIPTION ) ;
5080: oe_debug_pub.add( 'L_ORGANIZATION_ID: '||L_ORGANIZATION_ID ) ;
5081: END IF;
5082:
5083: IF NVL(p_item_identifier_type, 'INT') = 'INT' THEN

Line 5080: oe_debug_pub.add( 'L_ORGANIZATION_ID: '||L_ORGANIZATION_ID ) ;

5076: oe_debug_pub.add( 'P_INVENTORY_ITEM_ID: '||P_INVENTORY_ITEM_ID ) ;
5077: oe_debug_pub.add( 'P_ORDERED_ITEM: '||P_ORDERED_ITEM ) ;
5078: oe_debug_pub.add( 'P_SOLD_TO_ORG_ID: '||P_SOLD_TO_ORG_ID ) ;
5079: oe_debug_pub.add( 'P_DESCRIPTION: '||P_DESCRIPTION ) ;
5080: oe_debug_pub.add( 'L_ORGANIZATION_ID: '||L_ORGANIZATION_ID ) ;
5081: END IF;
5082:
5083: IF NVL(p_item_identifier_type, 'INT') = 'INT' THEN
5084: IF (Instr(p_description, '%') = 0) THEN

Line 5086: oe_debug_pub.add( 'ENTERING INT::EXACT MATCH' ) ;

5082:
5083: IF NVL(p_item_identifier_type, 'INT') = 'INT' THEN
5084: IF (Instr(p_description, '%') = 0) THEN
5085: IF l_debug_level > 0 THEN
5086: oe_debug_pub.add( 'ENTERING INT::EXACT MATCH' ) ;
5087: END IF;
5088: SELECT count(*)
5089: INTO l_count
5090: FROM mtl_system_items_vl

Line 5096: oe_debug_pub.add( 'ENTERING INT::PARTIAL' ) ;

5092: AND organization_id = l_organization_id
5093: AND description = p_description;
5094: ELSE
5095: IF l_debug_level > 0 THEN
5096: oe_debug_pub.add( 'ENTERING INT::PARTIAL' ) ;
5097: END IF;
5098:
5099: SELECT count(*)
5100: INTO l_count

Line 5111: oe_debug_pub.add( 'ENTERING CUST::EXACT MATCH' ) ;

5107:
5108: ELSIF NVL(p_item_identifier_type, 'INT') = 'CUST' THEN
5109: IF (Instr(p_description, '%') = 0) THEN
5110: IF l_debug_level > 0 THEN
5111: oe_debug_pub.add( 'ENTERING CUST::EXACT MATCH' ) ;
5112: END IF;
5113: SELECT count(*)
5114: INTO l_count
5115: FROM mtl_customer_items citems

Line 5127: oe_debug_pub.add( 'ENTERING CUST::PARTIAL' ) ;

5123: AND citems.customer_id = p_sold_to_org_id
5124: AND nvl(citems.customer_item_desc, sitems.description) = p_description;
5125: ELSE
5126: IF l_debug_level > 0 THEN
5127: oe_debug_pub.add( 'ENTERING CUST::PARTIAL' ) ;
5128: END IF;
5129: SELECT count(*)
5130: INTO l_count
5131: FROM mtl_customer_items citems

Line 5146: oe_debug_pub.add( 'ENTERING GENERIC::EXACT MATCH' ) ;

5142: ELSE
5143: IF p_ordered_item_id IS NULL THEN
5144: IF (Instr(p_description, '%') = 0) THEN
5145: IF l_debug_level > 0 THEN
5146: oe_debug_pub.add( 'ENTERING GENERIC::EXACT MATCH' ) ;
5147: END IF;
5148: SELECT count(*)
5149: INTO l_count
5150: FROM mtl_cross_reference_types types

Line 5162: oe_debug_pub.add( 'ENTERING GENERIC::PARTIAL' ) ;

5158: AND items.cross_reference = p_ordered_item
5159: AND nvl(items.description, sitems.description) = p_description;
5160: ELSE
5161: IF l_debug_level > 0 THEN
5162: oe_debug_pub.add( 'ENTERING GENERIC::PARTIAL' ) ;
5163: END IF;
5164: SELECT count(*)
5165: INTO l_count
5166: FROM mtl_cross_reference_types types

Line 5182: oe_debug_pub.add( 'NO MATCHES' ) ;

5178: END IF;
5179:
5180: IF l_count = 0 THEN
5181: IF l_debug_level > 0 THEN
5182: oe_debug_pub.add( 'NO MATCHES' ) ;
5183: END IF;
5184: RETURN 'N';
5185: ELSE
5186: IF l_debug_level > 0 THEN

Line 5187: oe_debug_pub.add( 'THERE ARE MATCHES' ) ;

5183: END IF;
5184: RETURN 'N';
5185: ELSE
5186: IF l_debug_level > 0 THEN
5187: oe_debug_pub.add( 'THERE ARE MATCHES' ) ;
5188: END IF;
5189: RETURN 'Y';
5190: END IF;
5191:

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

5203: ) RETURN VARCHAR2 IS
5204: l_organization_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
5205: l_count NUMBER := 0;
5206: --
5207: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5208: --
5209: BEGIN
5210:
5211:

Line 5214: oe_debug_pub.add( 'P_ITEM_IDENTIFIER_TYPE: '||P_ITEM_IDENTIFIER_TYPE ) ;

5210:
5211:
5212: IF l_debug_level > 0 THEN
5213:
5214: oe_debug_pub.add( 'P_ITEM_IDENTIFIER_TYPE: '||P_ITEM_IDENTIFIER_TYPE ) ;
5215: oe_debug_pub.add( 'P_ORDERED_ITEM_ID: '||P_ORDERED_ITEM_ID ) ;
5216: oe_debug_pub.add( 'P_INVENTORY_ITEM_ID: '||P_INVENTORY_ITEM_ID ) ;
5217: oe_debug_pub.add( 'P_ORDERED_ITEM: '||P_ORDERED_ITEM ) ;
5218: oe_debug_pub.add( 'P_SOLD_TO_ORG_ID: '||P_SOLD_TO_ORG_ID ) ;

Line 5215: oe_debug_pub.add( 'P_ORDERED_ITEM_ID: '||P_ORDERED_ITEM_ID ) ;

5211:
5212: IF l_debug_level > 0 THEN
5213:
5214: oe_debug_pub.add( 'P_ITEM_IDENTIFIER_TYPE: '||P_ITEM_IDENTIFIER_TYPE ) ;
5215: oe_debug_pub.add( 'P_ORDERED_ITEM_ID: '||P_ORDERED_ITEM_ID ) ;
5216: oe_debug_pub.add( 'P_INVENTORY_ITEM_ID: '||P_INVENTORY_ITEM_ID ) ;
5217: oe_debug_pub.add( 'P_ORDERED_ITEM: '||P_ORDERED_ITEM ) ;
5218: oe_debug_pub.add( 'P_SOLD_TO_ORG_ID: '||P_SOLD_TO_ORG_ID ) ;
5219: oe_debug_pub.add( 'p_inventory_item: '||p_inventory_item ) ;

Line 5216: oe_debug_pub.add( 'P_INVENTORY_ITEM_ID: '||P_INVENTORY_ITEM_ID ) ;

5212: IF l_debug_level > 0 THEN
5213:
5214: oe_debug_pub.add( 'P_ITEM_IDENTIFIER_TYPE: '||P_ITEM_IDENTIFIER_TYPE ) ;
5215: oe_debug_pub.add( 'P_ORDERED_ITEM_ID: '||P_ORDERED_ITEM_ID ) ;
5216: oe_debug_pub.add( 'P_INVENTORY_ITEM_ID: '||P_INVENTORY_ITEM_ID ) ;
5217: oe_debug_pub.add( 'P_ORDERED_ITEM: '||P_ORDERED_ITEM ) ;
5218: oe_debug_pub.add( 'P_SOLD_TO_ORG_ID: '||P_SOLD_TO_ORG_ID ) ;
5219: oe_debug_pub.add( 'p_inventory_item: '||p_inventory_item ) ;
5220: oe_debug_pub.add( 'L_ORGANIZATION_ID: '||L_ORGANIZATION_ID ) ;

Line 5217: oe_debug_pub.add( 'P_ORDERED_ITEM: '||P_ORDERED_ITEM ) ;

5213:
5214: oe_debug_pub.add( 'P_ITEM_IDENTIFIER_TYPE: '||P_ITEM_IDENTIFIER_TYPE ) ;
5215: oe_debug_pub.add( 'P_ORDERED_ITEM_ID: '||P_ORDERED_ITEM_ID ) ;
5216: oe_debug_pub.add( 'P_INVENTORY_ITEM_ID: '||P_INVENTORY_ITEM_ID ) ;
5217: oe_debug_pub.add( 'P_ORDERED_ITEM: '||P_ORDERED_ITEM ) ;
5218: oe_debug_pub.add( 'P_SOLD_TO_ORG_ID: '||P_SOLD_TO_ORG_ID ) ;
5219: oe_debug_pub.add( 'p_inventory_item: '||p_inventory_item ) ;
5220: oe_debug_pub.add( 'L_ORGANIZATION_ID: '||L_ORGANIZATION_ID ) ;
5221: END IF;

Line 5218: oe_debug_pub.add( 'P_SOLD_TO_ORG_ID: '||P_SOLD_TO_ORG_ID ) ;

5214: oe_debug_pub.add( 'P_ITEM_IDENTIFIER_TYPE: '||P_ITEM_IDENTIFIER_TYPE ) ;
5215: oe_debug_pub.add( 'P_ORDERED_ITEM_ID: '||P_ORDERED_ITEM_ID ) ;
5216: oe_debug_pub.add( 'P_INVENTORY_ITEM_ID: '||P_INVENTORY_ITEM_ID ) ;
5217: oe_debug_pub.add( 'P_ORDERED_ITEM: '||P_ORDERED_ITEM ) ;
5218: oe_debug_pub.add( 'P_SOLD_TO_ORG_ID: '||P_SOLD_TO_ORG_ID ) ;
5219: oe_debug_pub.add( 'p_inventory_item: '||p_inventory_item ) ;
5220: oe_debug_pub.add( 'L_ORGANIZATION_ID: '||L_ORGANIZATION_ID ) ;
5221: END IF;
5222:

Line 5219: oe_debug_pub.add( 'p_inventory_item: '||p_inventory_item ) ;

5215: oe_debug_pub.add( 'P_ORDERED_ITEM_ID: '||P_ORDERED_ITEM_ID ) ;
5216: oe_debug_pub.add( 'P_INVENTORY_ITEM_ID: '||P_INVENTORY_ITEM_ID ) ;
5217: oe_debug_pub.add( 'P_ORDERED_ITEM: '||P_ORDERED_ITEM ) ;
5218: oe_debug_pub.add( 'P_SOLD_TO_ORG_ID: '||P_SOLD_TO_ORG_ID ) ;
5219: oe_debug_pub.add( 'p_inventory_item: '||p_inventory_item ) ;
5220: oe_debug_pub.add( 'L_ORGANIZATION_ID: '||L_ORGANIZATION_ID ) ;
5221: END IF;
5222:
5223: IF NVL(p_item_identifier_type, 'INT') = 'INT' THEN

Line 5220: oe_debug_pub.add( 'L_ORGANIZATION_ID: '||L_ORGANIZATION_ID ) ;

5216: oe_debug_pub.add( 'P_INVENTORY_ITEM_ID: '||P_INVENTORY_ITEM_ID ) ;
5217: oe_debug_pub.add( 'P_ORDERED_ITEM: '||P_ORDERED_ITEM ) ;
5218: oe_debug_pub.add( 'P_SOLD_TO_ORG_ID: '||P_SOLD_TO_ORG_ID ) ;
5219: oe_debug_pub.add( 'p_inventory_item: '||p_inventory_item ) ;
5220: oe_debug_pub.add( 'L_ORGANIZATION_ID: '||L_ORGANIZATION_ID ) ;
5221: END IF;
5222:
5223: IF NVL(p_item_identifier_type, 'INT') = 'INT' THEN
5224: IF (Instr(p_inventory_item, '%') = 0) THEN

Line 5226: oe_debug_pub.add( 'ENTERING INT::EXACT MATCH' ) ;

5222:
5223: IF NVL(p_item_identifier_type, 'INT') = 'INT' THEN
5224: IF (Instr(p_inventory_item, '%') = 0) THEN
5225: IF l_debug_level > 0 THEN
5226: oe_debug_pub.add( 'ENTERING INT::EXACT MATCH' ) ;
5227: END IF;
5228: SELECT count(*)
5229: INTO l_count
5230: FROM mtl_system_items_vl

Line 5236: oe_debug_pub.add( 'ENTERING INT::PARTIAL' ) ;

5232: AND organization_id = l_organization_id
5233: AND concatenated_segments = p_inventory_item;
5234: ELSE
5235: IF l_debug_level > 0 THEN
5236: oe_debug_pub.add( 'ENTERING INT::PARTIAL' ) ;
5237: END IF;
5238: SELECT count(*)
5239: INTO l_count
5240: FROM mtl_system_items_vl

Line 5249: oe_debug_pub.add( 'ENTERING CUST::EXACT MATCH' ) ;

5245:
5246: ELSIF NVL(p_item_identifier_type, 'INT') = 'CUST' THEN
5247: IF (Instr(p_inventory_item, '%') = 0) THEN
5248: IF l_debug_level > 0 THEN
5249: oe_debug_pub.add( 'ENTERING CUST::EXACT MATCH' ) ;
5250: END IF;
5251: SELECT count(*)
5252: INTO l_count
5253: FROM mtl_customer_items citems

Line 5265: oe_debug_pub.add( 'ENTERING CUST::PARTIAL' ) ;

5261: AND citems.customer_id = p_sold_to_org_id
5262: AND sitems.concatenated_segments = p_inventory_item;
5263: ELSE
5264: IF l_debug_level > 0 THEN
5265: oe_debug_pub.add( 'ENTERING CUST::PARTIAL' ) ;
5266: END IF;
5267: SELECT count(*)
5268: INTO l_count
5269: FROM mtl_customer_items citems

Line 5285: oe_debug_pub.add( 'ENTERING GENERIC::EXACT MATCH' ) ;

5281: ELSE
5282: IF p_ordered_item_id IS NULL THEN
5283: IF (Instr(p_inventory_item, '%') = 0) THEN
5284: IF l_debug_level > 0 THEN
5285: oe_debug_pub.add( 'ENTERING GENERIC::EXACT MATCH' ) ;
5286: END IF;
5287: SELECT count(*)
5288: INTO l_count
5289: FROM mtl_cross_reference_types types

Line 5301: oe_debug_pub.add( 'ENTERING GENERIC::PARTIAL' ) ;

5297: AND items.cross_reference = p_ordered_item
5298: AND sitems.concatenated_segments = p_inventory_item;
5299: ELSE
5300: IF l_debug_level > 0 THEN
5301: oe_debug_pub.add( 'ENTERING GENERIC::PARTIAL' ) ;
5302: END IF;
5303: SELECT count(*)
5304: INTO l_count
5305: FROM mtl_cross_reference_types types

Line 5321: oe_debug_pub.add( 'NO MATCHES' ) ;

5317: END IF;
5318:
5319: IF l_count = 0 THEN
5320: IF l_debug_level > 0 THEN
5321: oe_debug_pub.add( 'NO MATCHES' ) ;
5322: END IF;
5323: RETURN 'N';
5324: ELSE
5325: IF l_debug_level > 0 THEN

Line 5326: oe_debug_pub.add( 'THERE ARE MATCHES' ) ;

5322: END IF;
5323: RETURN 'N';
5324: ELSE
5325: IF l_debug_level > 0 THEN
5326: oe_debug_pub.add( 'THERE ARE MATCHES' ) ;
5327: END IF;
5328: RETURN 'Y';
5329: END IF;
5330: END Is_Internal_Item_Matched;

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

5342: ) RETURN VARCHAR2 IS
5343: l_organization_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
5344: l_count NUMBER := 0;
5345: --
5346: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5347: --
5348: BEGIN
5349:
5350: IF l_debug_level > 0 THEN

Line 5351: oe_debug_pub.add( 'P_ITEM_IDENTIFIER_TYPE: '||P_ITEM_IDENTIFIER_TYPE ) ;

5347: --
5348: BEGIN
5349:
5350: IF l_debug_level > 0 THEN
5351: oe_debug_pub.add( 'P_ITEM_IDENTIFIER_TYPE: '||P_ITEM_IDENTIFIER_TYPE ) ;
5352: oe_debug_pub.add( 'P_ORDERED_ITEM_ID: '||P_ORDERED_ITEM_ID ) ;
5353: oe_debug_pub.add( 'P_INVENTORY_ITEM_ID: '||P_INVENTORY_ITEM_ID ) ;
5354: oe_debug_pub.add( 'P_ORDERED_ITEM: '||P_ORDERED_ITEM ) ;
5355: oe_debug_pub.add( 'P_SOLD_TO_ORG_ID: '||P_SOLD_TO_ORG_ID ) ;

Line 5352: oe_debug_pub.add( 'P_ORDERED_ITEM_ID: '||P_ORDERED_ITEM_ID ) ;

5348: BEGIN
5349:
5350: IF l_debug_level > 0 THEN
5351: oe_debug_pub.add( 'P_ITEM_IDENTIFIER_TYPE: '||P_ITEM_IDENTIFIER_TYPE ) ;
5352: oe_debug_pub.add( 'P_ORDERED_ITEM_ID: '||P_ORDERED_ITEM_ID ) ;
5353: oe_debug_pub.add( 'P_INVENTORY_ITEM_ID: '||P_INVENTORY_ITEM_ID ) ;
5354: oe_debug_pub.add( 'P_ORDERED_ITEM: '||P_ORDERED_ITEM ) ;
5355: oe_debug_pub.add( 'P_SOLD_TO_ORG_ID: '||P_SOLD_TO_ORG_ID ) ;
5356: oe_debug_pub.add( 'P_ITEM: '||P_ITEM ) ;

Line 5353: oe_debug_pub.add( 'P_INVENTORY_ITEM_ID: '||P_INVENTORY_ITEM_ID ) ;

5349:
5350: IF l_debug_level > 0 THEN
5351: oe_debug_pub.add( 'P_ITEM_IDENTIFIER_TYPE: '||P_ITEM_IDENTIFIER_TYPE ) ;
5352: oe_debug_pub.add( 'P_ORDERED_ITEM_ID: '||P_ORDERED_ITEM_ID ) ;
5353: oe_debug_pub.add( 'P_INVENTORY_ITEM_ID: '||P_INVENTORY_ITEM_ID ) ;
5354: oe_debug_pub.add( 'P_ORDERED_ITEM: '||P_ORDERED_ITEM ) ;
5355: oe_debug_pub.add( 'P_SOLD_TO_ORG_ID: '||P_SOLD_TO_ORG_ID ) ;
5356: oe_debug_pub.add( 'P_ITEM: '||P_ITEM ) ;
5357: oe_debug_pub.add( 'L_ORGANIZATION_ID: '||L_ORGANIZATION_ID ) ;

Line 5354: oe_debug_pub.add( 'P_ORDERED_ITEM: '||P_ORDERED_ITEM ) ;

5350: IF l_debug_level > 0 THEN
5351: oe_debug_pub.add( 'P_ITEM_IDENTIFIER_TYPE: '||P_ITEM_IDENTIFIER_TYPE ) ;
5352: oe_debug_pub.add( 'P_ORDERED_ITEM_ID: '||P_ORDERED_ITEM_ID ) ;
5353: oe_debug_pub.add( 'P_INVENTORY_ITEM_ID: '||P_INVENTORY_ITEM_ID ) ;
5354: oe_debug_pub.add( 'P_ORDERED_ITEM: '||P_ORDERED_ITEM ) ;
5355: oe_debug_pub.add( 'P_SOLD_TO_ORG_ID: '||P_SOLD_TO_ORG_ID ) ;
5356: oe_debug_pub.add( 'P_ITEM: '||P_ITEM ) ;
5357: oe_debug_pub.add( 'L_ORGANIZATION_ID: '||L_ORGANIZATION_ID ) ;
5358: END IF;

Line 5355: oe_debug_pub.add( 'P_SOLD_TO_ORG_ID: '||P_SOLD_TO_ORG_ID ) ;

5351: oe_debug_pub.add( 'P_ITEM_IDENTIFIER_TYPE: '||P_ITEM_IDENTIFIER_TYPE ) ;
5352: oe_debug_pub.add( 'P_ORDERED_ITEM_ID: '||P_ORDERED_ITEM_ID ) ;
5353: oe_debug_pub.add( 'P_INVENTORY_ITEM_ID: '||P_INVENTORY_ITEM_ID ) ;
5354: oe_debug_pub.add( 'P_ORDERED_ITEM: '||P_ORDERED_ITEM ) ;
5355: oe_debug_pub.add( 'P_SOLD_TO_ORG_ID: '||P_SOLD_TO_ORG_ID ) ;
5356: oe_debug_pub.add( 'P_ITEM: '||P_ITEM ) ;
5357: oe_debug_pub.add( 'L_ORGANIZATION_ID: '||L_ORGANIZATION_ID ) ;
5358: END IF;
5359:

Line 5356: oe_debug_pub.add( 'P_ITEM: '||P_ITEM ) ;

5352: oe_debug_pub.add( 'P_ORDERED_ITEM_ID: '||P_ORDERED_ITEM_ID ) ;
5353: oe_debug_pub.add( 'P_INVENTORY_ITEM_ID: '||P_INVENTORY_ITEM_ID ) ;
5354: oe_debug_pub.add( 'P_ORDERED_ITEM: '||P_ORDERED_ITEM ) ;
5355: oe_debug_pub.add( 'P_SOLD_TO_ORG_ID: '||P_SOLD_TO_ORG_ID ) ;
5356: oe_debug_pub.add( 'P_ITEM: '||P_ITEM ) ;
5357: oe_debug_pub.add( 'L_ORGANIZATION_ID: '||L_ORGANIZATION_ID ) ;
5358: END IF;
5359:
5360: IF NVL(p_item_identifier_type, 'INT') = 'INT' THEN

Line 5357: oe_debug_pub.add( 'L_ORGANIZATION_ID: '||L_ORGANIZATION_ID ) ;

5353: oe_debug_pub.add( 'P_INVENTORY_ITEM_ID: '||P_INVENTORY_ITEM_ID ) ;
5354: oe_debug_pub.add( 'P_ORDERED_ITEM: '||P_ORDERED_ITEM ) ;
5355: oe_debug_pub.add( 'P_SOLD_TO_ORG_ID: '||P_SOLD_TO_ORG_ID ) ;
5356: oe_debug_pub.add( 'P_ITEM: '||P_ITEM ) ;
5357: oe_debug_pub.add( 'L_ORGANIZATION_ID: '||L_ORGANIZATION_ID ) ;
5358: END IF;
5359:
5360: IF NVL(p_item_identifier_type, 'INT') = 'INT' THEN
5361: IF (Instr(p_item, '%') = 0) THEN

Line 5363: oe_debug_pub.add( 'ENTERING INT::EXACT MATCH' ) ;

5359:
5360: IF NVL(p_item_identifier_type, 'INT') = 'INT' THEN
5361: IF (Instr(p_item, '%') = 0) THEN
5362: IF l_debug_level > 0 THEN
5363: oe_debug_pub.add( 'ENTERING INT::EXACT MATCH' ) ;
5364: END IF;
5365: SELECT count(*)
5366: INTO l_count
5367: FROM mtl_system_items_vl

Line 5373: oe_debug_pub.add( 'ENTERING INT::PARTIAL' ) ;

5369: AND organization_id = l_organization_id
5370: AND concatenated_segments = p_item;
5371: ELSE
5372: IF l_debug_level > 0 THEN
5373: oe_debug_pub.add( 'ENTERING INT::PARTIAL' ) ;
5374: END IF;
5375: SELECT count(*)
5376: INTO l_count
5377: FROM mtl_system_items_vl

Line 5386: oe_debug_pub.add( 'ENTERING CUST::EXACT MATCH' ) ;

5382:
5383: ELSIF NVL(p_item_identifier_type, 'INT') = 'CUST' THEN
5384: IF (Instr(p_item, '%') = 0) THEN
5385: IF l_debug_level > 0 THEN
5386: oe_debug_pub.add( 'ENTERING CUST::EXACT MATCH' ) ;
5387: END IF;
5388: SELECT count(*)
5389: INTO l_count
5390: FROM mtl_customer_items citems

Line 5402: oe_debug_pub.add( 'ENTERING CUST::PARTIAL' ) ;

5398: AND citems.customer_id = p_sold_to_org_id
5399: AND nvl(citems.customer_item_number, sitems.concatenated_segments) =p_item;
5400: ELSE
5401: IF l_debug_level > 0 THEN
5402: oe_debug_pub.add( 'ENTERING CUST::PARTIAL' ) ;
5403: END IF;
5404: SELECT count(*)
5405: INTO l_count
5406: FROM mtl_customer_items citems

Line 5421: oe_debug_pub.add( 'ENTERING GENERIC::EXACT MATCH' ) ;

5417: ELSE
5418: IF p_ordered_item_id IS NULL THEN
5419: IF (Instr(p_item, '%') = 0) THEN
5420: IF l_debug_level > 0 THEN
5421: oe_debug_pub.add( 'ENTERING GENERIC::EXACT MATCH' ) ;
5422: END IF;
5423: SELECT count(*)
5424: INTO l_count
5425: FROM mtl_cross_reference_types types

Line 5437: oe_debug_pub.add( 'ENTERING GENERIC::PARTIAL' ) ;

5433: AND items.cross_reference = p_ordered_item
5434: AND nvl(items.cross_reference, sitems.concatenated_segments) = p_item;
5435: ELSE
5436: IF l_debug_level > 0 THEN
5437: oe_debug_pub.add( 'ENTERING GENERIC::PARTIAL' ) ;
5438: END IF;
5439: SELECT count(*)
5440: INTO l_count
5441: FROM mtl_cross_reference_types types

Line 5457: oe_debug_pub.add( 'NO MATCHES' ) ;

5453: END IF;
5454:
5455: IF l_count = 0 THEN
5456: IF l_debug_level > 0 THEN
5457: oe_debug_pub.add( 'NO MATCHES' ) ;
5458: END IF;
5459: RETURN 'N';
5460: ELSE
5461: IF l_debug_level > 0 THEN

Line 5462: oe_debug_pub.add( 'THERE ARE MATCHES' ) ;

5458: END IF;
5459: RETURN 'N';
5460: ELSE
5461: IF l_debug_level > 0 THEN
5462: oe_debug_pub.add( 'THERE ARE MATCHES' ) ;
5463: END IF;
5464: RETURN 'Y';
5465: END IF;
5466: END Is_Item_Matched;

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

5505: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
5506: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
5507: --serla end
5508: --
5509: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5510: --
5511: BEGIN
5512:
5513: IF l_debug_level > 0 THEN

Line 5514: oe_debug_pub.add( 'LINE CONTROLLER - IN SPLIT ' , 1 ) ;

5510: --
5511: BEGIN
5512:
5513: IF l_debug_level > 0 THEN
5514: oe_debug_pub.add( 'LINE CONTROLLER - IN SPLIT ' , 1 ) ;
5515: END IF;
5516:
5517: /* l_control_rec.controlled_operation := TRUE;
5518: l_control_rec.validate_entity := TRUE;

Line 5536: oe_debug_pub.add( 'LINE CONTROLLER - BEFORE GET LINE'|| X_LINE_TBL_TYPE ( I ) .LINE_ID , 1 ) ;

5532: IF i =1 THEN
5533: IF x_line_tbl_type(i).line_id is not null THEN
5534: l_line_id:=x_line_tbl_type(i).line_id;
5535: IF l_debug_level > 0 THEN
5536: oe_debug_pub.add( 'LINE CONTROLLER - BEFORE GET LINE'|| X_LINE_TBL_TYPE ( I ) .LINE_ID , 1 ) ;
5537: END IF;
5538: -- l_x_line_tbl(i):=OE_ORDER_PUB.G_MISS_LINE_REC;
5539: /* Get_line
5540: ( p_db_record => FALSE

Line 5556: oe_debug_pub.add( 'LINE CONTROLLER - AFTER GET LINE ' , 1 ) ;

5552: RAISE FND_API.G_EXC_ERROR;
5553: END IF;
5554:
5555: IF l_debug_level > 0 THEN
5556: oe_debug_pub.add( 'LINE CONTROLLER - AFTER GET LINE ' , 1 ) ;
5557: END IF;
5558: END IF;
5559: l_x_line_tbl(i).line_id:=x_line_tbl_type(i).line_id;
5560: l_x_line_tbl(i).split_action_code:='SPLIT';

Line 5569: OE_DEBUG_PUB.add('Audit Trail Reason Code being passed as '||p_change_reason_code,1);

5565: l_x_line_tbl(i).split_by:='USER';
5566: END IF;
5567: l_x_line_tbl(i).operation:= OE_GLOBALS.G_OPR_UPDATE;
5568: IF l_debug_level > 0 THEN
5569: OE_DEBUG_PUB.add('Audit Trail Reason Code being passed as '||p_change_reason_code,1);
5570: END IF;
5571: l_x_line_tbl(i).change_reason := p_change_reason_code;
5572: l_x_line_tbl(i).change_comments := p_change_comments;
5573: -- Bug# 4008409

Line 5594: oe_debug_pub.add( 'LINE CONTROLLER - IN SPLIT - CALLING PROCESS' , 1 ) ;

5590: l_x_line_tbl(i).ordered_quantity2:= x_line_tbl_type(i).ordered_quantity2;
5591: end loop;
5592:
5593: IF l_debug_level > 0 THEN
5594: oe_debug_pub.add( 'LINE CONTROLLER - IN SPLIT - CALLING PROCESS' , 1 ) ;
5595: END IF;
5596:
5597: Oe_Order_Pvt.Process_order
5598: ( p_api_version_number => 1.0

Line 5629: oe_debug_pub.add( 'LINE CONTROLLER - IN SPLIT - AFTER CALLING PROCESS' , 1 ) ;

5625: );
5626:
5627: END IF;
5628: IF l_debug_level > 0 THEN
5629: oe_debug_pub.add( 'LINE CONTROLLER - IN SPLIT - AFTER CALLING PROCESS' , 1 ) ;
5630: END IF;
5631:
5632: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5661: OE_DEBUG_PUB.add('Reason code being passed : '||l_line_tbl(i).change_reason,1);

5657: -- This is to fix a p1 bug on tst115. The second call should not
5658: -- come as split
5659: l_line_tbl(i).operation:= OE_GLOBALS.G_OPR_UPDATE;
5660: IF l_debug_level > 0 THEN
5661: OE_DEBUG_PUB.add('Reason code being passed : '||l_line_tbl(i).change_reason,1);
5662: END IF;
5663: l_line_tbl(i).change_reason := p_change_reason_code;
5664: l_line_tbl(i).change_comments := p_change_comments;
5665: l_line_tbl(i).split_action_code:=fnd_api.g_miss_char;

Line 5749: OE_DEBUG_PUB.add('Reason code being passed : '||l_line_tbl(l_rec_count).change_reason,1);

5745: END IF;
5746:
5747: l_line_tbl(l_rec_count).operation := OE_GLOBALS.G_OPR_UPDATE;
5748: IF l_debug_level > 0 THEN
5749: OE_DEBUG_PUB.add('Reason code being passed : '||l_line_tbl(l_rec_count).change_reason,1);
5750: END IF;
5751: l_line_tbl(l_rec_count).change_reason := p_change_reason_code;
5752: l_line_tbl(l_rec_count).change_comments := p_change_comments;
5753: l_line_tbl(l_rec_count).split_action_code := fnd_api.g_miss_char;

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

5883: IS
5884: l_return_status Varchar2(30);
5885: l_count_to_keep NUMBER;
5886: --
5887: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5888: --
5889: /* l_new_line_rec OE_Order_PUB.Line_Rec_Type; --3445778
5890: l_old_line_rec OE_Order_PUB.Line_Rec_Type; --3445778
5891: l_index NUMBER; --3445778 */

Line 5907: oe_debug_pub.add('Roll version global is set');

5903:
5904: l_header_id := g_line_rec.header_id;
5905:
5906: if l_debug_level > 0 then
5907: oe_debug_pub.add('Roll version global is set');
5908: oe_debug_pub.add('Header ID: '||l_header_id);
5909: end if;
5910:
5911: IF NOT OE_Delayed_Requests_Pvt.Check_For_Request

Line 5908: oe_debug_pub.add('Header ID: '||l_header_id);

5904: l_header_id := g_line_rec.header_id;
5905:
5906: if l_debug_level > 0 then
5907: oe_debug_pub.add('Roll version global is set');
5908: oe_debug_pub.add('Header ID: '||l_header_id);
5909: end if;
5910:
5911: IF NOT OE_Delayed_Requests_Pvt.Check_For_Request
5912: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL

Line 5917: oe_debug_pub.add('Request does not exist, reset versioning globals');

5913: ,p_entity_id => l_header_id
5914: ,p_request_type => OE_GLOBALS.G_VERSION_AUDIT
5915: )
5916: THEN
5917: oe_debug_pub.add('Request does not exist, reset versioning globals');
5918: IF (NOT OE_Versioning_Util.Reset_Globals) THEN
5919: l_return_status := FND_API.G_RET_STS_ERROR;
5920: RETURN;
5921: END IF;

Line 5935: oe_debug_pub.add('Executing code for updating global picture, line_id: ' || p_line_id, 1);

5931: ,p_delete_against => FALSE
5932: ,x_return_status => l_return_status);
5933:
5934: /* -- Added for bug 3445778 --Commenting the code for 3575018
5935: oe_debug_pub.add('Executing code for updating global picture, line_id: ' || p_line_id, 1);
5936:
5937: -- Set the operation on the record so that globals are updated
5938: l_new_line_rec.operation := OE_GLOBALS.G_OPR_DELETE;
5939: l_new_line_rec.line_id := p_line_id;

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

6004: RETURN VARCHAR2
6005: IS
6006: l_order_date_type_code VARCHAR2(30) := null;
6007: --
6008: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6009: --
6010: BEGIN
6011:
6012: SELECT order_date_type_code

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

6030: ) IS
6031: l_site_use_code VARCHAR2(30);
6032:
6033: --
6034: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6035: --
6036: BEGIN
6037: l_site_use_code := 'SHIP_TO';
6038:

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

6061: ) IS
6062:
6063: l_site_use_code VARCHAR2(30);
6064: --
6065: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6066: --
6067: BEGIN
6068: l_site_use_code := 'BILL_TO';
6069:

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

6096: , x_shipment_number OUT NOCOPY Number
6097: ) IS
6098: l_line_number Number;
6099: --
6100: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6101: --
6102: BEGIN
6103: SELECT OE_ORDER_LINES_S.NEXTVAL
6104: INTO x_line_id

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

6150:
6151: l_organization_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
6152:
6153: --
6154: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6155: --
6156: BEGIN
6157: IF l_debug_level > 0 THEN
6158: oe_debug_pub.add( 'ENTER GET_ORDERED_ITEM PROCEDURE' ) ;

Line 6158: oe_debug_pub.add( 'ENTER GET_ORDERED_ITEM PROCEDURE' ) ;

6154: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6155: --
6156: BEGIN
6157: IF l_debug_level > 0 THEN
6158: oe_debug_pub.add( 'ENTER GET_ORDERED_ITEM PROCEDURE' ) ;
6159: oe_debug_pub.add( 'ITEM_IDENTIFIER_TYPE : '||P_ITEM_IDENTIFIER_TYPE ) ;
6160: oe_debug_pub.add( 'INVENTORY_ITEM_ID : '||P_INVENTORY_ITEM_ID ) ;
6161: oe_debug_pub.add( 'ORDERED_ITEM_ID : '||P_ORDERED_ITEM_ID ) ;
6162: oe_debug_pub.add( 'SOLD_TO_ORG_ID : '||P_SOLD_TO_ORG_ID ) ;

Line 6159: oe_debug_pub.add( 'ITEM_IDENTIFIER_TYPE : '||P_ITEM_IDENTIFIER_TYPE ) ;

6155: --
6156: BEGIN
6157: IF l_debug_level > 0 THEN
6158: oe_debug_pub.add( 'ENTER GET_ORDERED_ITEM PROCEDURE' ) ;
6159: oe_debug_pub.add( 'ITEM_IDENTIFIER_TYPE : '||P_ITEM_IDENTIFIER_TYPE ) ;
6160: oe_debug_pub.add( 'INVENTORY_ITEM_ID : '||P_INVENTORY_ITEM_ID ) ;
6161: oe_debug_pub.add( 'ORDERED_ITEM_ID : '||P_ORDERED_ITEM_ID ) ;
6162: oe_debug_pub.add( 'SOLD_TO_ORG_ID : '||P_SOLD_TO_ORG_ID ) ;
6163: END IF;

Line 6160: oe_debug_pub.add( 'INVENTORY_ITEM_ID : '||P_INVENTORY_ITEM_ID ) ;

6156: BEGIN
6157: IF l_debug_level > 0 THEN
6158: oe_debug_pub.add( 'ENTER GET_ORDERED_ITEM PROCEDURE' ) ;
6159: oe_debug_pub.add( 'ITEM_IDENTIFIER_TYPE : '||P_ITEM_IDENTIFIER_TYPE ) ;
6160: oe_debug_pub.add( 'INVENTORY_ITEM_ID : '||P_INVENTORY_ITEM_ID ) ;
6161: oe_debug_pub.add( 'ORDERED_ITEM_ID : '||P_ORDERED_ITEM_ID ) ;
6162: oe_debug_pub.add( 'SOLD_TO_ORG_ID : '||P_SOLD_TO_ORG_ID ) ;
6163: END IF;
6164:

Line 6161: oe_debug_pub.add( 'ORDERED_ITEM_ID : '||P_ORDERED_ITEM_ID ) ;

6157: IF l_debug_level > 0 THEN
6158: oe_debug_pub.add( 'ENTER GET_ORDERED_ITEM PROCEDURE' ) ;
6159: oe_debug_pub.add( 'ITEM_IDENTIFIER_TYPE : '||P_ITEM_IDENTIFIER_TYPE ) ;
6160: oe_debug_pub.add( 'INVENTORY_ITEM_ID : '||P_INVENTORY_ITEM_ID ) ;
6161: oe_debug_pub.add( 'ORDERED_ITEM_ID : '||P_ORDERED_ITEM_ID ) ;
6162: oe_debug_pub.add( 'SOLD_TO_ORG_ID : '||P_SOLD_TO_ORG_ID ) ;
6163: END IF;
6164:
6165: IF NVL(p_item_identifier_type, 'INT') = 'INT' THEN

Line 6162: oe_debug_pub.add( 'SOLD_TO_ORG_ID : '||P_SOLD_TO_ORG_ID ) ;

6158: oe_debug_pub.add( 'ENTER GET_ORDERED_ITEM PROCEDURE' ) ;
6159: oe_debug_pub.add( 'ITEM_IDENTIFIER_TYPE : '||P_ITEM_IDENTIFIER_TYPE ) ;
6160: oe_debug_pub.add( 'INVENTORY_ITEM_ID : '||P_INVENTORY_ITEM_ID ) ;
6161: oe_debug_pub.add( 'ORDERED_ITEM_ID : '||P_ORDERED_ITEM_ID ) ;
6162: oe_debug_pub.add( 'SOLD_TO_ORG_ID : '||P_SOLD_TO_ORG_ID ) ;
6163: END IF;
6164:
6165: IF NVL(p_item_identifier_type, 'INT') = 'INT' THEN
6166:

Line 6206: oe_debug_pub.add( 'EXIT GET_ORDERED_ITEM PROCEDURE' ) ;

6202: Null;
6203: END;
6204: END IF;
6205: IF l_debug_level > 0 THEN
6206: oe_debug_pub.add( 'EXIT GET_ORDERED_ITEM PROCEDURE' ) ;
6207: END IF;
6208:
6209: EXCEPTION
6210:

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

6233:
6234: l_return_status Varchar2(1);
6235:
6236: --
6237: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6238: --
6239: BEGIN
6240: OE_LINE_ADJ_UTIL.Delete_Row(p_line_id=>x_line_id);
6241:

Line 6246: oe_debug_pub.add('delete the request logged for this line too');

6242: /* 1905650
6243: This is no longer required, since G_PRICE_ADJ request
6244: is logged against LINE entity now
6245:
6246: oe_debug_pub.add('delete the request logged for this line too');
6247: oe_delayed_requests_pvt.delete_request(
6248: p_entity_code =>OE_GLOBALS.G_ENTITY_LINE_ADJ,
6249: p_entity_id => x_line_id,
6250: p_request_type => OE_GLOBALS.G_PRICE_ADJ,

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

6260: x_customer_number OUT NOCOPY VARCHAR2
6261: ) IS
6262:
6263: --
6264: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6265: --
6266: BEGIN
6267:
6268: /* 2172651*/