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 85: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

81: l_return_status VARCHAR2(1);
82: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
83: l_error NUMBER := 0;
84: --
85: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
86: --
87: BEGIN
88:
89: IF l_debug_level > 0 THEN

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

86: --
87: BEGIN
88:
89: IF l_debug_level > 0 THEN
90: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE.DEFAULT_ATTRIBUTES' , 1 ) ;
91: END IF;
92:
93: l_error := 1;
94: -- Set UI flag to TRUE

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

239: -- Populate line table
240:
241:
242: IF l_debug_level > 0 THEN
243: oe_debug_pub.add( 'LINE CONTROLLER - DEFAULT ATTRIBUTES - CALLING PROCESS' , 2 ) ;
244: END IF;
245:
246: -- Call Oe_Order_Pvt.Process_order
247:

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

257: );
258:
259: l_error := 3;
260: IF l_debug_level > 0 THEN
261: oe_debug_pub.add( 'LINE CONTROLLER - DEFAULT ATTRIBUTES - AFTER PROCESS' , 2 ) ;
262: END IF;
263:
264: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

281: -- Write to cache.
282: -- Set db_flag to False before writing to cache
283:
284: IF l_debug_level > 0 THEN
285: oe_debug_pub.add( 'LINE CONTROLLER - DEFAULT ATTRIBUTES - CALLING WRITE LINE' , 2 ) ;
286: END IF;
287:
288: x_line_tbl(1).db_flag := FND_API.G_FALSE;
289:

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

305: , p_data => x_msg_data
306: );
307:
308: IF l_debug_level > 0 THEN
309: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE.DEFAULT_ATTRIBUTES' , 1 ) ;
310: END IF;
311:
312: EXCEPTION
313:

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

370: )
371: IS
372: l_date_format_mask VARCHAR2(30) := p_date_format_mask;
373: --
374: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
375: --
376: BEGIN
377: IF l_debug_level > 0 THEN
378: oe_debug_pub.add( 'ATTRIBUTE VALUE : '|| P_ATTR_VALUE ) ; --bug 5179564

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

374: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
375: --
376: BEGIN
377: IF l_debug_level > 0 THEN
378: oe_debug_pub.add( 'ATTRIBUTE VALUE : '|| P_ATTR_VALUE ) ; --bug 5179564
379: END IF;
380:
381: IF p_attr_id = OE_Line_Util.G_ACCOUNTING_RULE THEN
382: x_line_tbl(1).accounting_rule_id := TO_NUMBER(p_attr_value);

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

630: x_line_tbl(1).shipping_interfaced_flag := p_attr_value;
631: ELSIF p_attr_id = OE_Line_Util.G_SHIP_TO_CONTACT THEN
632: x_line_tbl(1).ship_to_contact_id := TO_NUMBER(p_attr_value);
633: IF l_debug_level > 0 THEN
634: oe_debug_pub.add( 'SHIP TO CONTACT1'|| X_LINE_TBL ( 1 ) .SHIP_TO_CONTACT_ID , 1 ) ;
635: END IF;
636: ELSIF p_attr_id = OE_Line_Util.G_SHIP_TO_ORG THEN
637: x_line_tbl(1).ship_to_org_id := TO_NUMBER(p_attr_value);
638: ELSIF p_attr_id = OE_Line_Util.G_SHIP_MODEL_COMPLETE_FLAG THEN

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

695: ELSIF p_attr_id = OE_Line_Util.G_ARRIVAL_SET THEN
696: x_line_tbl(1).arrival_set_id := TO_NUMBER(p_attr_value);
697: ELSIF p_attr_id = OE_Line_Util.G_ARRIVAL_SET_NAME THEN
698: IF l_debug_level > 0 THEN
699: oe_debug_pub.add( 'RAJ CONTROLLER - ATTRIBUTE CHANGE'|| P_ATTR_VALUE ) ;
700: END IF;
701: IF p_attr_value IS NULL THEN
702: x_line_tbl(1).arrival_set_id := NULL;
703: x_line_tbl(1).arrival_set := p_attr_value;

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

1032: OR p_attr_id = OE_Line_Util.G_TP_ATTRIBUTE9
1033: OR p_attr_id = OE_Line_Util.G_TP_CONTEXT
1034: THEN
1035: IF l_debug_level > 0 THEN
1036: oe_debug_pub.add( 'JYOTHI: I AM IN CHANGE ATTRIBUTE' ) ;
1037: END IF;
1038:
1039: x_line_tbl(1).tp_attribute1 := p_line_dff_rec.tp_attribute1;
1040: x_line_tbl(1).tp_attribute10 := p_line_dff_rec.tp_attribute10;

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

1053: x_line_tbl(1).tp_attribute9 := p_line_dff_rec.tp_attribute9;
1054: x_line_tbl(1).tp_context := p_line_dff_rec.tp_context;
1055:
1056: IF l_debug_level > 0 THEN
1057: oe_debug_pub.add( 'JYOTHI- TP ATTRIBUTE IS ' || X_LINE_TBL ( 1 ) .TP_ATTRIBUTE1 ) ;
1058: END IF;
1059: ELSIF p_attr_id = OE_Line_Util.G_COMMITMENT THEN
1060: x_line_tbl(1).commitment_id := TO_NUMBER(p_attr_value);
1061: ELSIF p_attr_id = OE_Line_Util.G_COMMITMENT_APPLIED_AMOUNT THEN

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

1062: x_line_tbl(1).commitment_applied_amount := TO_NUMBER(p_attr_value);
1063: --MRG BGN
1064: ELSIF p_attr_id = OE_LINE_UTIL.G_UNIT_COST Then
1065: IF l_debug_level > 0 THEN
1066: oe_debug_pub.add( 'P_ATTR_VALUE='||P_ATTR_VALUE ) ;
1067: END IF;
1068: x_line_tbl(1).unit_cost := TO_NUMBER(p_attr_value);
1069: IF l_debug_level > 0 THEN
1070: oe_debug_pub.add( 'FLINB:UNIT_COST:'||P_ATTR_VALUE ) ;

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

1066: oe_debug_pub.add( 'P_ATTR_VALUE='||P_ATTR_VALUE ) ;
1067: END IF;
1068: x_line_tbl(1).unit_cost := TO_NUMBER(p_attr_value);
1069: IF l_debug_level > 0 THEN
1070: oe_debug_pub.add( 'FLINB:UNIT_COST:'||P_ATTR_VALUE ) ;
1071: END IF;
1072: --MRG END
1073: --retro{
1074: ELSIF p_attr_id = OE_Line_Util.G_RETROBILL_REQUEST THEN

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

1099:
1100: ELSE
1101:
1102: IF l_debug_level > 0 THEN
1103: oe_debug_pub.add( 'UNRECOGNIZED ATTRIBUTE EXCEPTION' , 2 ) ;
1104: END IF;
1105:
1106: -- Unexpected error, unrecognized attribute
1107:

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

1179: file_name varchar2(100);
1180: i pls_Integer;
1181: L_PRICE_CONTROL_REC QP_PREQ_GRP.control_record_type;
1182: --
1183: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1184: --
1185: --bug16574638
1186: l_return_context VARCHAR2(30) := null;
1187: l_return_attrib1 VARCHAR2(240):= null;

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

1189: --bug16574638
1190: BEGIN
1191:
1192: IF l_debug_level > 0 THEN
1193: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE.CHANGE_ATTRIBUTES' , 1 ) ;
1194: END IF;
1195:
1196: -- Set UI flag to TRUE
1197: OE_GLOBALS.G_UI_FLAG := TRUE;

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

1247: , x_return_status => l_return_status
1248: );
1249: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1250: IF l_debug_level > 0 THEN
1251: oe_debug_pub.add( 'DATE TYPE RETURNED UNEXP_ERROR' , 2 ) ;
1252: END IF;
1253: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1254: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1255: IF l_debug_level > 0 THEN

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

1252: END IF;
1253: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1254: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1255: IF l_debug_level > 0 THEN
1256: oe_debug_pub.add( 'DATE TYPE RETURN RET_STS_ERROR' , 2 ) ;
1257: END IF;
1258: RAISE FND_API.G_EXC_ERROR;
1259: END IF;
1260:

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

1267: , x_line_rec => x_line_tbl(1)
1268: );
1269:
1270: IF l_debug_level > 0 THEN
1271: oe_debug_pub.add( 'JPN:AFTER LINE QUERY : ' || X_LINE_TBL ( 1 ) .TP_ATTRIBUTE1 ) ;
1272: END IF;
1273:
1274: x_old_line_tbl(1) := x_line_tbl(1);
1275:

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

1280:
1281: IF OE_CODE_CONTROL.Code_Release_Level >= '110509' THEN
1282:
1283: IF l_debug_level > 0 THEN
1284: oe_debug_pub.add( 'Code Release is >= 11.5.9') ;
1285: END IF;
1286:
1287: Copy_Attribute_To_Rec
1288: (p_attr_id => p_attr_id

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

1308:
1309: ELSE
1310:
1311: IF l_debug_level > 0 THEN
1312: oe_debug_pub.add( 'Code Release is < 11.5.9') ;
1313: END IF;
1314:
1315: -- PLEASE ADD THIS IF LOGIC FOR NEW ATTRIBUTES TO THE PROCEDURE
1316: -- COPY_ATTRIBUTE_TO_REC ALSO. THIS NEW PROCEDURE WILL REPLACE

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

1568: x_line_tbl(1).shipping_interfaced_flag := p_attr_value;
1569: ELSIF p_attr_id = OE_Line_Util.G_SHIP_TO_CONTACT THEN
1570: x_line_tbl(1).ship_to_contact_id := TO_NUMBER(p_attr_value);
1571: IF l_debug_level > 0 THEN
1572: oe_debug_pub.add( 'SHIP TO CONTACT1'|| X_LINE_TBL ( 1 ) .SHIP_TO_CONTACT_ID , 1 ) ;
1573: END IF;
1574: ELSIF p_attr_id = OE_Line_Util.G_SHIP_TO_ORG THEN
1575: x_line_tbl(1).ship_to_org_id := TO_NUMBER(p_attr_value);
1576: ELSIF p_attr_id = OE_Line_Util.G_SHIP_MODEL_COMPLETE_FLAG THEN

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

1636: ELSIF p_attr_id = OE_LINE_UTIL.G_CHARGE_PERIODICITY THEN
1637: x_line_tbl(1).charge_periodicity_code := p_attr_value;
1638: ELSIF p_attr_id = OE_Line_Util.G_ARRIVAL_SET_NAME THEN
1639: IF l_debug_level > 0 THEN
1640: oe_debug_pub.add( 'RAJ CONTROLLER - ATTRIBUTE CHANGE'|| P_ATTR_VALUE ) ;
1641: END IF;
1642: IF p_attr_value IS NULL THEN
1643: x_line_tbl(1).arrival_set_id := NULL;
1644: x_line_tbl(1).arrival_set := p_attr_value;

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

1957: OR p_attr_id = OE_Line_Util.G_TP_ATTRIBUTE9
1958: OR p_attr_id = OE_Line_Util.G_TP_CONTEXT
1959: THEN
1960: IF l_debug_level > 0 THEN
1961: oe_debug_pub.add( 'JYOTHI: I AM IN CHANGE ATTRIBUTE' ) ;
1962: END IF;
1963:
1964: x_line_tbl(1).tp_attribute1 := p_line_dff_rec.tp_attribute1;
1965: x_line_tbl(1).tp_attribute10 := p_line_dff_rec.tp_attribute10;

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

1978: x_line_tbl(1).tp_attribute9 := p_line_dff_rec.tp_attribute9;
1979: x_line_tbl(1).tp_context := p_line_dff_rec.tp_context;
1980:
1981: IF l_debug_level > 0 THEN
1982: oe_debug_pub.add( 'JYOTHI- TP ATTRIBUTE IS ' || X_LINE_TBL ( 1 ) .TP_ATTRIBUTE1 ) ;
1983: END IF;
1984: ELSIF p_attr_id = OE_Line_Util.G_COMMITMENT THEN
1985: x_line_tbl(1).commitment_id := TO_NUMBER(p_attr_value);
1986: --MRG BGN

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

1985: x_line_tbl(1).commitment_id := TO_NUMBER(p_attr_value);
1986: --MRG BGN
1987: ELSIF p_attr_id = OE_LINE_UTIL.G_UNIT_COST Then
1988: IF l_debug_level > 0 THEN
1989: oe_debug_pub.add( 'P_ATTR_VALUE='||P_ATTR_VALUE ) ;
1990: END IF;
1991: x_line_tbl(1).unit_cost := TO_NUMBER(p_attr_value);
1992: IF l_debug_level > 0 THEN
1993: oe_debug_pub.add( 'FLINB:UNIT_COST:'||P_ATTR_VALUE ) ;

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

1989: oe_debug_pub.add( 'P_ATTR_VALUE='||P_ATTR_VALUE ) ;
1990: END IF;
1991: x_line_tbl(1).unit_cost := TO_NUMBER(p_attr_value);
1992: IF l_debug_level > 0 THEN
1993: oe_debug_pub.add( 'FLINB:UNIT_COST:'||P_ATTR_VALUE ) ;
1994: END IF;
1995: --MRG END
1996: -- INVCONV
1997: ELSIF p_attr_id = OE_Line_Util.G_CANCELLED_QUANTITY2 THEN

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

2010: -- INVCONV
2011: ELSE
2012:
2013: IF l_debug_level > 0 THEN
2014: oe_debug_pub.add( 'UNRECOGNIZED ATTRIBUTE EXCEPTION' , 2 ) ;
2015: END IF;
2016:
2017: -- Unexpected error, unrecognized attribute
2018:

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

2037:
2038: -- Set Operation.
2039:
2040: IF l_debug_level > 0 THEN
2041: oe_debug_pub.add( 'SETTING OPERATION' , 2 ) ;
2042: END IF;
2043:
2044: IF FND_API.To_Boolean(x_line_tbl(1).db_flag) THEN
2045: x_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;

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

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

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

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

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

2102: END IF;
2103:
2104: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2105: IF l_debug_level > 0 THEN
2106: oe_debug_pub.add( 'DATE TYPE RETURNED UNEXP_ERROR' , 2 ) ;
2107: END IF;
2108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2109: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2110: IF l_debug_level > 0 THEN

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

2107: END IF;
2108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2109: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2110: IF l_debug_level > 0 THEN
2111: oe_debug_pub.add( 'DATE TYPE RETURN RET_STS_ERROR' , 2 ) ;
2112: END IF;
2113: RAISE FND_API.G_EXC_ERROR;
2114: END IF;
2115:

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

2120: = OE_GLOBALS.G_SOURCE_EXTERNAL
2121: AND (x_line_tbl(1).ship_set_id is not null
2122: OR x_line_tbl(1).arrival_set_id is not null)) THEN
2123: IF l_debug_level > 0 THEN
2124: oe_debug_pub.add('Cannot change source type',2);
2125: END IF;
2126: FND_MESSAGE.SET_NAME('ONT','ONT_CANT_CHG_SRC_TYPE');
2127: OE_MSG_PUB.Add;
2128: l_return_status := FND_API.G_RET_STS_ERROR;

Line 2147: oe_debug_pub.add('Cannot change reference details',2);

2143: NOT OE_GLOBALS.Equal(x_line_tbl(1).return_attribute2, l_return_attrib2))
2144: AND Nvl(x_line_tbl(1).shipped_quantity,0) > 0
2145: THEN
2146: IF l_debug_level > 0 THEN
2147: oe_debug_pub.add('Cannot change reference details',2);
2148: END IF;
2149: FND_MESSAGE.SET_NAME('ONT','OE_RMA_RECEIVED');
2150: OE_MSG_PUB.Add;
2151: l_return_status := FND_API.G_RET_STS_ERROR;

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

2154: END IF;
2155: END IF;
2156: --End for bug 16574638
2157: IF l_debug_level > 0 THEN
2158: oe_debug_pub.add( 'CALLING PROCESS ORDER' , 2 ) ;
2159: oe_debug_pub.add( 'BEFORE CALLING PROCESS ORDER' , 1 ) ;
2160: END IF;
2161:
2162: -- Call Oe_Order_Pvt.Process_order

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

2155: END IF;
2156: --End for bug 16574638
2157: IF l_debug_level > 0 THEN
2158: oe_debug_pub.add( 'CALLING PROCESS ORDER' , 2 ) ;
2159: oe_debug_pub.add( 'BEFORE CALLING PROCESS ORDER' , 1 ) ;
2160: END IF;
2161:
2162: -- Call Oe_Order_Pvt.Process_order
2163: Oe_Order_Pvt.Lines

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

2170: , x_return_status => l_return_status
2171: );
2172:
2173: IF l_debug_level > 0 THEN
2174: oe_debug_pub.add( 'AFTER CALLING PROCESS ORDER' , 1 ) ;
2175: END IF;
2176: --bug 2438466 begin
2177: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN -- Fix for bug3546224
2178: IF p_attr_id = OE_Line_Util.G_RETURN_CONTEXT THEN

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

2186: --bug 2438466 end
2187:
2188: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2189: IF l_debug_level > 0 THEN
2190: oe_debug_pub.add( 'PROCESS ORDER RETURN UNEXP_ERROR' , 2 ) ;
2191: END IF;
2192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2193: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2194: IF l_debug_level > 0 THEN

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

2191: END IF;
2192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2193: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2194: IF l_debug_level > 0 THEN
2195: oe_debug_pub.add( 'PROCESS ORDER RETURN RET_STS_ERROR' , 2 ) ;
2196: END IF;
2197: RAISE FND_API.G_EXC_ERROR;
2198: END IF;
2199:

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

2227: x_lot_divisible_flag := l_x_item_rec_type.lot_divisible_flag; -- INVCONV
2228:
2229: -- Write to cache.
2230: IF l_debug_level > 0 THEN
2231: oe_debug_pub.add( 'WRITING TO CACHE' , 2 ) ;
2232: END IF;
2233:
2234: Write_line
2235: ( p_line_rec => x_line_tbl(1)

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

2249: , p_data => x_msg_data
2250: );
2251:
2252: IF l_debug_level > 0 THEN
2253: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE.CHANGE_ATTRIBUTE' , 1 ) ;
2254: END IF;
2255:
2256: EXCEPTION
2257:

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

2328: l_last_index NUMBER;
2329: l_organization_id NUMBER:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
2330: l_set_rec OE_ORDER_CACHE.set_rec_type; -- 2806483
2331: --
2332: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2333: --
2334: BEGIN
2335:
2336: SAVEPOINT Line_Validate_And_Write;

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

2335:
2336: SAVEPOINT Line_Validate_And_Write;
2337:
2338: IF l_debug_level > 0 THEN
2339: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE.VALIDATE_AND_WRITE' , 1 ) ;
2340: END IF;
2341:
2342: -- Set UI flag to TRUE
2343: OE_GLOBALS.G_UI_FLAG := TRUE;

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

2399:
2400: -- Call Oe_Order_Pvt.Process_order
2401:
2402: IF l_debug_level > 0 THEN
2403: oe_debug_pub.add( 'IN VALIDATE_AND_WRITE' ) ;
2404: END IF;
2405: oe_debug_pub.add( 'IN VALIDATE_AND_WRITE Change Reason'||p_change_reason_code ) ;
2406: Oe_Order_Pvt.Lines
2407: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE

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

2401:
2402: IF l_debug_level > 0 THEN
2403: oe_debug_pub.add( 'IN VALIDATE_AND_WRITE' ) ;
2404: END IF;
2405: oe_debug_pub.add( 'IN VALIDATE_AND_WRITE Change Reason'||p_change_reason_code ) ;
2406: Oe_Order_Pvt.Lines
2407: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
2408: , p_init_msg_list => FND_API.G_TRUE
2409: , p_control_rec => l_control_rec

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

2485: END IF;
2486:
2487: -- lkxu, commitment enhancement
2488: IF l_debug_level > 0 THEN
2489: oe_debug_pub.add( 'CALLING TO PROCESS DELAYED REQUEST FOR COMMITMENT!' , 1 ) ;
2490: END IF;
2491:
2492: IF OE_GLOBALS.G_DEFER_PRICING='N' THEN
2493: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

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

2623: END IF;
2624: -- 2817915
2625:
2626: IF l_debug_level > 0 THEN
2627: oe_debug_pub.add( 'ARRIVALSET-'|| TO_CHAR ( L_X_LINE_REC.ARRIVAL_SET_ID ) , 2 ) ;
2628: END IF;
2629: -- Calculate Tax
2630:
2631: x_line_val_rec.x_line_tax_value := l_x_line_rec.tax_value;

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

2630:
2631: x_line_val_rec.x_line_tax_value := l_x_line_rec.tax_value;
2632:
2633: IF l_debug_level > 0 THEN
2634: oe_debug_pub.add( 'TAX VALUE IS'|| TO_CHAR ( L_X_LINE_REC.TAX_VALUE ) , 1 ) ;
2635: oe_debug_pub.add( 'CALLING ORDER TOTAL' , 2 ) ;
2636: END IF;
2637:
2638: -- Call the charges API to get the Line level charges.

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

2631: x_line_val_rec.x_line_tax_value := l_x_line_rec.tax_value;
2632:
2633: IF l_debug_level > 0 THEN
2634: oe_debug_pub.add( 'TAX VALUE IS'|| TO_CHAR ( L_X_LINE_REC.TAX_VALUE ) , 1 ) ;
2635: oe_debug_pub.add( 'CALLING ORDER TOTAL' , 2 ) ;
2636: END IF;
2637:
2638: -- Call the charges API to get the Line level charges.
2639: IF OE_GLOBALS.G_DEFER_PRICING='N' THEN

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

2719: , p_data => x_msg_data
2720: );
2721:
2722: IF l_debug_level > 0 THEN
2723: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE.VALIDATE_AND_WRITE' , 1 ) ;
2724: END IF;
2725:
2726:
2727: EXCEPTION

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

2822: l_x_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
2823: l_control_rec OE_GLOBALS.Control_Rec_Type;
2824: l_return_status VARCHAR2(1);
2825: --
2826: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2827: --
2828: BEGIN
2829: SAVEPOINT LINE_DELETE;
2830: IF l_debug_level > 0 THEN

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

2827: --
2828: BEGIN
2829: SAVEPOINT LINE_DELETE;
2830: IF l_debug_level > 0 THEN
2831: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE.DELETE_ROW' , 1 ) ;
2832: END IF;
2833:
2834: -- Set UI flag to TRUE
2835: OE_GLOBALS.G_UI_FLAG := TRUE;

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

2905: , p_data => x_msg_data
2906: );
2907:
2908: IF l_debug_level > 0 THEN
2909: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE.DELETE_ROW' , 1 ) ;
2910: END IF;
2911:
2912: EXCEPTION
2913:

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

2996: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2997: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2998: --serla end
2999: --
3000: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3001: --
3002: BEGIN
3003:
3004: IF l_debug_level > 0 THEN

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

3001: --
3002: BEGIN
3003:
3004: IF l_debug_level > 0 THEN
3005: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE.PROCESS_ENTITY' , 1 ) ;
3006: END IF;
3007:
3008: -- Set UI flag to TRUE
3009: OE_GLOBALS.G_UI_FLAG := TRUE;

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

3077: , p_data => x_msg_data
3078: );
3079:
3080: IF l_debug_level > 0 THEN
3081: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE.PROCESS_ENTITY' , 1 ) ;
3082: END IF;
3083:
3084: EXCEPTION
3085:

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

3146: IS
3147: l_return_status VARCHAR2(1);
3148: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
3149: --
3150: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3151: --
3152: BEGIN
3153:
3154: IF l_debug_level > 0 THEN

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

3151: --
3152: BEGIN
3153:
3154: IF l_debug_level > 0 THEN
3155: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE.LOCK_ROW' , 1 ) ;
3156: END IF;
3157:
3158: -- Load line record
3159:

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

3176: -- Set DB flag and write record to cache.
3177:
3178: l_x_line_rec.db_flag := FND_API.G_TRUE;
3179: IF l_debug_level > 0 THEN
3180: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE.LOCK_ROW'||L_X_LINE_REC.LINE_ID , 1 ) ;
3181: END IF;
3182:
3183: Write_line
3184: ( p_line_rec => l_x_line_rec

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

3203: , p_data => x_msg_data
3204: );
3205:
3206: IF l_debug_level > 0 THEN
3207: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE.LOCK_ROW' , 1 ) ;
3208: END IF;
3209:
3210: EXCEPTION
3211: WHEN FND_API.G_EXC_ERROR THEN

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

3264: , p_db_record IN BOOLEAN := FALSE
3265: )
3266: IS
3267: --
3268: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3269: --
3270: BEGIN
3271:
3272: IF l_debug_level > 0 THEN

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

3269: --
3270: BEGIN
3271:
3272: IF l_debug_level > 0 THEN
3273: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE.WRITE_LINE' , 1 ) ;
3274: END IF;
3275: g_line_rec := p_line_rec;
3276:
3277: IF p_db_record THEN

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

3280:
3281: END IF;
3282:
3283: IF l_debug_level > 0 THEN
3284: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE.WRITE_LINE' , 1 ) ;
3285: END IF;
3286:
3287: END Write_Line;
3288:

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

3292: , x_line_rec OUT NOCOPY OE_Order_PUB.Line_Rec_Type
3293: )
3294: IS
3295: --
3296: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3297: --
3298: BEGIN
3299:
3300: IF l_debug_level > 0 THEN

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

3297: --
3298: BEGIN
3299:
3300: IF l_debug_level > 0 THEN
3301: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE.GET_LINE'||P_LINE_ID , 1 ) ;
3302: END IF;
3303: --reverting back the fix made for bug 2103000 as the problem
3304: --is fixed in file OEXOEFRM.pld(version 115.251)
3305: --Fixes the issue reported in bug 2150247

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

3307: THEN
3308:
3309: -- Query row from DB
3310: IF l_debug_level > 0 THEN
3311: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE.GET_LINE QUERY '||P_LINE_ID , 1 ) ;
3312: END IF;
3313:
3314: OE_Line_Util.Query_Row
3315: ( p_line_id => p_line_id,

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

3324:
3325: END IF;
3326:
3327: IF l_debug_level > 0 THEN
3328: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE.GET_LINE' , 1 ) ;
3329: END IF;
3330:
3331: IF p_db_record THEN
3332: --Added for bug3911285

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

3347:
3348: PROCEDURE Clear_Line
3349: IS
3350: --
3351: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3352: --
3353: BEGIN
3354:
3355: IF l_debug_level > 0 THEN

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

3352: --
3353: BEGIN
3354:
3355: IF l_debug_level > 0 THEN
3356: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE.CLEAR_LINE' , 1 ) ;
3357: END IF;
3358:
3359: g_line_rec := OE_Order_PUB.G_MISS_LINE_REC;
3360: g_db_line_rec := OE_Order_PUB.G_MISS_LINE_REC;

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

3359: g_line_rec := OE_Order_PUB.G_MISS_LINE_REC;
3360: g_db_line_rec := OE_Order_PUB.G_MISS_LINE_REC;
3361:
3362: IF l_debug_level > 0 THEN
3363: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE.CLEAR_LINE' , 1 ) ;
3364: END IF;
3365:
3366: END Clear_Line;
3367:

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

3476: l_order_margin_amount NUMBER;
3477: --MRG END
3478:
3479: --
3480: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3481: --
3482: --7832836 l_cascade_hold_non_smc VARCHAR2(1) := NVL(OE_SYS_PARAMETERS.VALUE('ONT_CASCADE_HOLD_NONSMC_PTO'),'N'); --ER#7479609
3483: l_cascade_hold_non_smc VARCHAR2(1); -- 7832836
3484: BEGIN

Line 3491: oe_debug_pub.add('SK OEXFLINB.pls 110 '||p_line_rec.service_bill_profile_id);

3487: l_cascade_hold_non_smc := NVL(OE_SYS_PARAMETERS.VALUE('ONT_CASCADE_HOLD_NONSMC_PTO',p_line_rec.org_id),'N'); --7832836
3488: -- sol_ord_er #16014165, get Billing Profile Display
3489: IF p_line_rec.service_bill_profile_id IS NOT NULL THEN
3490: IF l_debug_level > 0 THEN
3491: oe_debug_pub.add('SK OEXFLINB.pls 110 '||p_line_rec.service_bill_profile_id);
3492: END IF;
3493: x_line_val_rec.service_bill_profile := OE_Id_To_Value.Billing_Profile(p_line_rec.service_bill_profile_id);
3494: END IF;
3495: IF p_line_rec.service_cov_template_id IS NOT NULL THEN

Line 3497: oe_debug_pub.add('SK OEXFLINB.pls 111 '||p_line_rec.service_cov_template_id);

3493: x_line_val_rec.service_bill_profile := OE_Id_To_Value.Billing_Profile(p_line_rec.service_bill_profile_id);
3494: END IF;
3495: IF p_line_rec.service_cov_template_id IS NOT NULL THEN
3496: IF l_debug_level > 0 THEN
3497: oe_debug_pub.add('SK OEXFLINB.pls 111 '||p_line_rec.service_cov_template_id);
3498: END IF;
3499: x_line_val_rec.service_cov_template := OE_Id_To_Value.Coverage_Template(p_line_rec.service_cov_template_id);
3500: END IF;
3501: IF p_line_rec.service_subs_template_id IS NOT NULL THEN

Line 3503: oe_debug_pub.add('SK OEXFLINB.pls 112 '||p_line_rec.service_subs_template_id);

3499: x_line_val_rec.service_cov_template := OE_Id_To_Value.Coverage_Template(p_line_rec.service_cov_template_id);
3500: END IF;
3501: IF p_line_rec.service_subs_template_id IS NOT NULL THEN
3502: IF l_debug_level > 0 THEN
3503: oe_debug_pub.add('SK OEXFLINB.pls 112 '||p_line_rec.service_subs_template_id);
3504: END IF;
3505: x_line_val_rec.service_subs_template := OE_Id_To_Value.Subscription_Template(p_line_rec.service_subs_template_id);
3506: END IF;
3507: IF p_line_rec.service_bill_option_code IS NOT NULL THEN

Line 3509: oe_debug_pub.add('SK OEXFLINB.pls 114 '||p_line_rec.service_bill_option_code);

3505: x_line_val_rec.service_subs_template := OE_Id_To_Value.Subscription_Template(p_line_rec.service_subs_template_id);
3506: END IF;
3507: IF p_line_rec.service_bill_option_code IS NOT NULL THEN
3508: IF l_debug_level > 0 THEN
3509: oe_debug_pub.add('SK OEXFLINB.pls 114 '||p_line_rec.service_bill_option_code);
3510: END IF;
3511: x_line_val_rec.service_bill_option := OE_Id_To_Value.Billing_Option(p_line_rec.service_bill_option_code);
3512: END IF;
3513: -- sol_ord_er #16014165 end

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

3635: --5737464
3636: IF l_smc_flag = 'N' AND x_line_val_rec.cascaded_hold_exists_flag = 'N'
3637: THEN
3638: IF l_debug_level > 0 THEN
3639: oe_debug_pub.add('GOING TO CHECK FOR CONFIG VALIDATION HOLD FOR '||l_top_model_line_id,1);
3640: END IF;
3641:
3642: BEGIN
3643: l_hold_exists := NULL;

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

3670:
3671: IF p_line_rec.cancelled_flag = 'N' and p_line_rec.open_flag = 'Y'
3672: THEN
3673: IF l_debug_level > 0 THEN
3674: oe_debug_pub.add('HOLD CASCADED TO LINE ID '||p_line_rec.line_id,1);
3675: END IF;
3676: x_line_val_rec.cascaded_hold_exists_flag := 'Y';
3677: END IF;
3678: END IF;

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

3743: and h.header_id=l.header_id;
3744: EXCEPTION
3745: WHEN NO_DATA_FOUND THEN
3746: Null;
3747: oe_debug_pub.add('In NO Data Found ');
3748: When too_many_rows then
3749: Null;
3750: When others then
3751: oe_debug_pub.add('In Others Found ');

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

3747: oe_debug_pub.add('In NO Data Found ');
3748: When too_many_rows then
3749: Null;
3750: When others then
3751: oe_debug_pub.add('In Others Found ');
3752: Null;
3753: END;
3754: END IF;
3755:

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

3949:
3950: IF NVL(p_line_rec.item_identifier_type, 'INT') = 'INT' THEN
3951: BEGIN
3952: IF l_debug_level > 0 THEN
3953: oe_debug_pub.add( 'IN OEXFLINB. ITEM IDENTIFIER IS INT' ) ;
3954: END IF;
3955: SELECT description
3956: --,concatenated_segments
3957: --,concatenated_segments /*Bug 1766327 chhung*/

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

3984:
3985: end if;
3986: --end of bug 10047225
3987: IF l_debug_level > 0 THEN
3988: oe_debug_pub.add( 'DESCRIPTION: '||X_LINE_VAL_REC.ITEM_DESCRIPTION ) ;
3989: oe_debug_pub.add( 'ORDERED_ITEM_DSP: '||X_LINE_VAL_REC.ORDERED_ITEM_DSP ) ;
3990: oe_debug_pub.add( 'INVENTORY_ITEM: '|| X_LINE_VAL_REC.INVENTORY_ITEM ) ;
3991: END IF;
3992:

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

3985: end if;
3986: --end of bug 10047225
3987: IF l_debug_level > 0 THEN
3988: oe_debug_pub.add( 'DESCRIPTION: '||X_LINE_VAL_REC.ITEM_DESCRIPTION ) ;
3989: oe_debug_pub.add( 'ORDERED_ITEM_DSP: '||X_LINE_VAL_REC.ORDERED_ITEM_DSP ) ;
3990: oe_debug_pub.add( 'INVENTORY_ITEM: '|| X_LINE_VAL_REC.INVENTORY_ITEM ) ;
3991: END IF;
3992:
3993: EXCEPTION

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

3986: --end of bug 10047225
3987: IF l_debug_level > 0 THEN
3988: oe_debug_pub.add( 'DESCRIPTION: '||X_LINE_VAL_REC.ITEM_DESCRIPTION ) ;
3989: oe_debug_pub.add( 'ORDERED_ITEM_DSP: '||X_LINE_VAL_REC.ORDERED_ITEM_DSP ) ;
3990: oe_debug_pub.add( 'INVENTORY_ITEM: '|| X_LINE_VAL_REC.INVENTORY_ITEM ) ;
3991: END IF;
3992:
3993: EXCEPTION
3994: WHEN NO_DATA_FOUND THEN

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

4000: END;
4001: ELSIF NVL(p_line_rec.item_identifier_type, 'INT') = 'CUST' THEN
4002: BEGIN
4003: IF l_debug_level > 0 THEN
4004: oe_debug_pub.add( 'IN OEXFLINB. ITEM IDENTIFIER IS CUST' ) ;
4005: END IF;
4006: SELECT nvl(citems.customer_item_desc, sitems.description)
4007: ,citems.customer_item_number
4008: --,sitems.concatenated_segments /*Bug 1766327 chhung*/

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

4043:
4044: end if;
4045: --end of bug 10047225
4046: IF l_debug_level > 0 THEN
4047: oe_debug_pub.add( 'DESCRIPTION: '||X_LINE_VAL_REC.ITEM_DESCRIPTION ) ;
4048: oe_debug_pub.add( 'ORDERED_ITEM_DSP: '||X_LINE_VAL_REC.ORDERED_ITEM_DSP ) ;
4049: oe_debug_pub.add( 'INVENTORY_ITEM: '|| X_LINE_VAL_REC.INVENTORY_ITEM ) ;
4050: END IF;
4051:

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

4044: end if;
4045: --end of bug 10047225
4046: IF l_debug_level > 0 THEN
4047: oe_debug_pub.add( 'DESCRIPTION: '||X_LINE_VAL_REC.ITEM_DESCRIPTION ) ;
4048: oe_debug_pub.add( 'ORDERED_ITEM_DSP: '||X_LINE_VAL_REC.ORDERED_ITEM_DSP ) ;
4049: oe_debug_pub.add( 'INVENTORY_ITEM: '|| X_LINE_VAL_REC.INVENTORY_ITEM ) ;
4050: END IF;
4051:
4052: EXCEPTION

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

4045: --end of bug 10047225
4046: IF l_debug_level > 0 THEN
4047: oe_debug_pub.add( 'DESCRIPTION: '||X_LINE_VAL_REC.ITEM_DESCRIPTION ) ;
4048: oe_debug_pub.add( 'ORDERED_ITEM_DSP: '||X_LINE_VAL_REC.ORDERED_ITEM_DSP ) ;
4049: oe_debug_pub.add( 'INVENTORY_ITEM: '|| X_LINE_VAL_REC.INVENTORY_ITEM ) ;
4050: END IF;
4051:
4052: EXCEPTION
4053: WHEN NO_DATA_FOUND THEN

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

4087: end if;
4088: --end of bug 10047225
4089:
4090: IF l_debug_level > 0 THEN
4091: oe_debug_pub.add('DESCRIPTION: '||X_LINE_VAL_REC.ITEM_DESCRIPTION ) ;
4092: oe_debug_pub.add('ORDERED_ITEM_DSP: '||X_LINE_VAL_REC.ORDERED_ITEM_DSP ) ;
4093: oe_debug_pub.add('INVENTORY_ITEM: '|| X_LINE_VAL_REC.INVENTORY_ITEM ) ;
4094: END IF;
4095: END IF;

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

4088: --end of bug 10047225
4089:
4090: IF l_debug_level > 0 THEN
4091: oe_debug_pub.add('DESCRIPTION: '||X_LINE_VAL_REC.ITEM_DESCRIPTION ) ;
4092: oe_debug_pub.add('ORDERED_ITEM_DSP: '||X_LINE_VAL_REC.ORDERED_ITEM_DSP ) ;
4093: oe_debug_pub.add('INVENTORY_ITEM: '|| X_LINE_VAL_REC.INVENTORY_ITEM ) ;
4094: END IF;
4095: END IF;
4096: When too_many_rows then

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

4089:
4090: IF l_debug_level > 0 THEN
4091: oe_debug_pub.add('DESCRIPTION: '||X_LINE_VAL_REC.ITEM_DESCRIPTION ) ;
4092: oe_debug_pub.add('ORDERED_ITEM_DSP: '||X_LINE_VAL_REC.ORDERED_ITEM_DSP ) ;
4093: oe_debug_pub.add('INVENTORY_ITEM: '|| X_LINE_VAL_REC.INVENTORY_ITEM ) ;
4094: END IF;
4095: END IF;
4096: When too_many_rows then
4097: Null;

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

4100: END;
4101: ELSE
4102: BEGIN
4103: IF l_debug_level > 0 THEN
4104: oe_debug_pub.add( 'IN OEXFLINB. ITEM IDENTIFIER IS '||P_LINE_REC.ITEM_IDENTIFIER_TYPE ) ;
4105: oe_debug_pub.add( 'ORDERED_ITEM_ID: '||P_LINE_REC.ORDERED_ITEM_ID ) ;
4106: END IF;
4107: IF p_line_rec.ordered_item_id IS NULL THEN
4108: IF l_debug_level > 0 THEN

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

4101: ELSE
4102: BEGIN
4103: IF l_debug_level > 0 THEN
4104: oe_debug_pub.add( 'IN OEXFLINB. ITEM IDENTIFIER IS '||P_LINE_REC.ITEM_IDENTIFIER_TYPE ) ;
4105: oe_debug_pub.add( 'ORDERED_ITEM_ID: '||P_LINE_REC.ORDERED_ITEM_ID ) ;
4106: END IF;
4107: IF p_line_rec.ordered_item_id IS NULL THEN
4108: IF l_debug_level > 0 THEN
4109: oe_debug_pub.add( 'ORDERED_ITEM_ID IS NULL ' ) ;

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

4105: oe_debug_pub.add( 'ORDERED_ITEM_ID: '||P_LINE_REC.ORDERED_ITEM_ID ) ;
4106: END IF;
4107: IF p_line_rec.ordered_item_id IS NULL THEN
4108: IF l_debug_level > 0 THEN
4109: oe_debug_pub.add( 'ORDERED_ITEM_ID IS NULL ' ) ;
4110: oe_debug_pub.add( 'ORDERED_ITEM: '||P_LINE_REC.ORDERED_ITEM ) ;
4111: END IF;
4112: SELECT nvl(items.description, sitems.description)
4113: ,items.cross_reference

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

4106: END IF;
4107: IF p_line_rec.ordered_item_id IS NULL THEN
4108: IF l_debug_level > 0 THEN
4109: oe_debug_pub.add( 'ORDERED_ITEM_ID IS NULL ' ) ;
4110: oe_debug_pub.add( 'ORDERED_ITEM: '||P_LINE_REC.ORDERED_ITEM ) ;
4111: END IF;
4112: SELECT nvl(items.description, sitems.description)
4113: ,items.cross_reference
4114: --,sitems.concatenated_segments /*Bug 1766327 chhung*/

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

4145: x_line_val_rec.inventory_item := fnd_flex_keyval.concatenated_values;
4146: end if;
4147: --end of bug 10047225
4148: IF l_debug_level > 0 THEN
4149: oe_debug_pub.add( 'DESCRIPTION: '||X_LINE_VAL_REC.ITEM_DESCRIPTION ) ;
4150: oe_debug_pub.add( 'ORDERED_ITEM_DSP: '||X_LINE_VAL_REC.ORDERED_ITEM_DSP ) ;
4151: oe_debug_pub.add( 'INVENTORY_ITEM: '|| X_LINE_VAL_REC.INVENTORY_ITEM ) ;
4152: END IF;
4153: END IF;

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

4146: end if;
4147: --end of bug 10047225
4148: IF l_debug_level > 0 THEN
4149: oe_debug_pub.add( 'DESCRIPTION: '||X_LINE_VAL_REC.ITEM_DESCRIPTION ) ;
4150: oe_debug_pub.add( 'ORDERED_ITEM_DSP: '||X_LINE_VAL_REC.ORDERED_ITEM_DSP ) ;
4151: oe_debug_pub.add( 'INVENTORY_ITEM: '|| X_LINE_VAL_REC.INVENTORY_ITEM ) ;
4152: END IF;
4153: END IF;
4154:

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

4147: --end of bug 10047225
4148: IF l_debug_level > 0 THEN
4149: oe_debug_pub.add( 'DESCRIPTION: '||X_LINE_VAL_REC.ITEM_DESCRIPTION ) ;
4150: oe_debug_pub.add( 'ORDERED_ITEM_DSP: '||X_LINE_VAL_REC.ORDERED_ITEM_DSP ) ;
4151: oe_debug_pub.add( 'INVENTORY_ITEM: '|| X_LINE_VAL_REC.INVENTORY_ITEM ) ;
4152: END IF;
4153: END IF;
4154:
4155: EXCEPTION

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

4190: end if;
4191: --end of bug 10047225
4192:
4193: IF l_debug_level > 0 THEN
4194: oe_debug_pub.add('DESCRIPTION: '||X_LINE_VAL_REC.ITEM_DESCRIPTION ) ;
4195: oe_debug_pub.add('ORDERED_ITEM_DSP: '||X_LINE_VAL_REC.ORDERED_ITEM_DSP ) ;
4196: oe_debug_pub.add('INVENTORY_ITEM: '|| X_LINE_VAL_REC.INVENTORY_ITEM ) ;
4197: END IF;
4198: END IF;

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

4191: --end of bug 10047225
4192:
4193: IF l_debug_level > 0 THEN
4194: oe_debug_pub.add('DESCRIPTION: '||X_LINE_VAL_REC.ITEM_DESCRIPTION ) ;
4195: oe_debug_pub.add('ORDERED_ITEM_DSP: '||X_LINE_VAL_REC.ORDERED_ITEM_DSP ) ;
4196: oe_debug_pub.add('INVENTORY_ITEM: '|| X_LINE_VAL_REC.INVENTORY_ITEM ) ;
4197: END IF;
4198: END IF;
4199: When too_many_rows then

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

4192:
4193: IF l_debug_level > 0 THEN
4194: oe_debug_pub.add('DESCRIPTION: '||X_LINE_VAL_REC.ITEM_DESCRIPTION ) ;
4195: oe_debug_pub.add('ORDERED_ITEM_DSP: '||X_LINE_VAL_REC.ORDERED_ITEM_DSP ) ;
4196: oe_debug_pub.add('INVENTORY_ITEM: '|| X_LINE_VAL_REC.INVENTORY_ITEM ) ;
4197: END IF;
4198: END IF;
4199: When too_many_rows then
4200: --Null;

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

5089:
5090: x_line_val_rec.charge_periodicity := l_charge_periodicity;
5091:
5092: IF l_debug_level > 0 THEN
5093: OE_DEBUG_PUB.Add ('PCode:'||p_line_rec.charge_periodicity_code,5);
5094: OE_DEBUG_PUB.Add ('Populate value for Charge Periodicity',5);
5095: OE_DEBUG_PUB.Add ('Periodicity='||l_charge_periodicity,3);
5096: END IF;
5097: END IF;

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

5090: x_line_val_rec.charge_periodicity := l_charge_periodicity;
5091:
5092: IF l_debug_level > 0 THEN
5093: OE_DEBUG_PUB.Add ('PCode:'||p_line_rec.charge_periodicity_code,5);
5094: OE_DEBUG_PUB.Add ('Populate value for Charge Periodicity',5);
5095: OE_DEBUG_PUB.Add ('Periodicity='||l_charge_periodicity,3);
5096: END IF;
5097: END IF;
5098: */

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

5091:
5092: IF l_debug_level > 0 THEN
5093: OE_DEBUG_PUB.Add ('PCode:'||p_line_rec.charge_periodicity_code,5);
5094: OE_DEBUG_PUB.Add ('Populate value for Charge Periodicity',5);
5095: OE_DEBUG_PUB.Add ('Periodicity='||l_charge_periodicity,3);
5096: END IF;
5097: END IF;
5098: */
5099: -- recurring charges }

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

5123: x_line_val_rec.retrobilled_price := l_unit_selling_price+l_retrobilled_price_diff;
5124: ELSE
5125: x_line_val_rec.retrobilled_price := null;
5126: END IF;
5127: oe_debug_pub.add( 'RETROBILLED_PRICE: '||x_line_val_rec.retrobilled_price) ;
5128:
5129: IF(p_line_rec.order_source_id=27) THEN
5130: SELECT orig_head.order_number,
5131: orig_lin.line_number,

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

5152:
5153:
5154: EXCEPTION
5155: WHEN NO_DATA_FOUND THEN
5156: oe_debug_pub.add( 'IN EXCEPTION: ' ||SQLERRM);
5157: WHEN OTHERS THEN
5158: oe_debug_pub.add( 'IN EXCEPTION: ' ||SQLERRM);
5159: END;
5160: END IF;

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

5154: EXCEPTION
5155: WHEN NO_DATA_FOUND THEN
5156: oe_debug_pub.add( 'IN EXCEPTION: ' ||SQLERRM);
5157: WHEN OTHERS THEN
5158: oe_debug_pub.add( 'IN EXCEPTION: ' ||SQLERRM);
5159: END;
5160: END IF;
5161: END IF;
5162: --retro}

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

5161: END IF;
5162: --retro}
5163: --Macd
5164: IF l_debug_level > 0 THEN
5165: oe_debug_pub.add( 'MACD configuration_id'||p_line_rec.configuration_id);
5166: oe_debug_pub.add( 'MACD config_rev_nbr'||p_line_rec.config_rev_nbr);
5167: oe_debug_pub.add( 'MACD config_header_id'||p_line_rec.config_header_id);
5168: END IF;
5169: IF p_line_rec.configuration_id IS NOT NULL THEN

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

5162: --retro}
5163: --Macd
5164: IF l_debug_level > 0 THEN
5165: oe_debug_pub.add( 'MACD configuration_id'||p_line_rec.configuration_id);
5166: oe_debug_pub.add( 'MACD config_rev_nbr'||p_line_rec.config_rev_nbr);
5167: oe_debug_pub.add( 'MACD config_header_id'||p_line_rec.config_header_id);
5168: END IF;
5169: IF p_line_rec.configuration_id IS NOT NULL THEN
5170: BEGIN

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

5163: --Macd
5164: IF l_debug_level > 0 THEN
5165: oe_debug_pub.add( 'MACD configuration_id'||p_line_rec.configuration_id);
5166: oe_debug_pub.add( 'MACD config_rev_nbr'||p_line_rec.config_rev_nbr);
5167: oe_debug_pub.add( 'MACD config_header_id'||p_line_rec.config_header_id);
5168: END IF;
5169: IF p_line_rec.configuration_id IS NOT NULL THEN
5170: BEGIN
5171: select cz.name

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

5174: where cz.config_hdr_id = p_line_rec.config_header_id
5175: and cz.config_rev_nbr = p_line_rec.config_rev_nbr
5176: and cz.config_item_id = p_line_rec.configuration_id;
5177: IF l_debug_level > 0 THEN
5178: oe_debug_pub.add( 'MACD instance name'||x_line_val_rec.instance_name);
5179: END IF;
5180:
5181: EXCEPTION
5182:

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

5300:
5301:
5302: l_item_rec OE_Order_Cache.Item_Rec_Type;
5303: --
5304: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5305: --
5306: BEGIN
5307:
5308: POPULATE_CONTROL_FIELDS

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

5344: -- This change is required since we are dropping the profile OE_ORGANIZATION -- _ID. Change made by Esha.
5345: l_organization_id Number;/*:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');*/
5346: l_count NUMBER := 0;
5347: --
5348: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5349: --
5350: BEGIN
5351: --Bug 9684561
5352: l_organization_id := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID',

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

5352: l_organization_id := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID',
5353: p_org_id);
5354:
5355: IF l_debug_level > 0 THEN
5356: oe_debug_pub.add( 'P_ITEM_IDENTIFIER_TYPE:'||P_ITEM_IDENTIFIER_TYPE ) ;
5357: oe_debug_pub.add( 'P_ORDERED_ITEM_ID: '||P_ORDERED_ITEM_ID ) ;
5358: oe_debug_pub.add( 'P_INVENTORY_ITEM_ID: '||P_INVENTORY_ITEM_ID ) ;
5359: oe_debug_pub.add( 'P_ORDERED_ITEM: '||P_ORDERED_ITEM ) ;
5360: oe_debug_pub.add( 'P_SOLD_TO_ORG_ID: '||P_SOLD_TO_ORG_ID ) ;

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

5353: p_org_id);
5354:
5355: IF l_debug_level > 0 THEN
5356: oe_debug_pub.add( 'P_ITEM_IDENTIFIER_TYPE:'||P_ITEM_IDENTIFIER_TYPE ) ;
5357: oe_debug_pub.add( 'P_ORDERED_ITEM_ID: '||P_ORDERED_ITEM_ID ) ;
5358: oe_debug_pub.add( 'P_INVENTORY_ITEM_ID: '||P_INVENTORY_ITEM_ID ) ;
5359: oe_debug_pub.add( 'P_ORDERED_ITEM: '||P_ORDERED_ITEM ) ;
5360: oe_debug_pub.add( 'P_SOLD_TO_ORG_ID: '||P_SOLD_TO_ORG_ID ) ;
5361: oe_debug_pub.add( 'P_DESCRIPTION: '||P_DESCRIPTION ) ;

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

5354:
5355: IF l_debug_level > 0 THEN
5356: oe_debug_pub.add( 'P_ITEM_IDENTIFIER_TYPE:'||P_ITEM_IDENTIFIER_TYPE ) ;
5357: oe_debug_pub.add( 'P_ORDERED_ITEM_ID: '||P_ORDERED_ITEM_ID ) ;
5358: oe_debug_pub.add( 'P_INVENTORY_ITEM_ID: '||P_INVENTORY_ITEM_ID ) ;
5359: oe_debug_pub.add( 'P_ORDERED_ITEM: '||P_ORDERED_ITEM ) ;
5360: oe_debug_pub.add( 'P_SOLD_TO_ORG_ID: '||P_SOLD_TO_ORG_ID ) ;
5361: oe_debug_pub.add( 'P_DESCRIPTION: '||P_DESCRIPTION ) ;
5362: oe_debug_pub.add( 'L_ORGANIZATION_ID: '||L_ORGANIZATION_ID ) ;

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

5355: IF l_debug_level > 0 THEN
5356: oe_debug_pub.add( 'P_ITEM_IDENTIFIER_TYPE:'||P_ITEM_IDENTIFIER_TYPE ) ;
5357: oe_debug_pub.add( 'P_ORDERED_ITEM_ID: '||P_ORDERED_ITEM_ID ) ;
5358: oe_debug_pub.add( 'P_INVENTORY_ITEM_ID: '||P_INVENTORY_ITEM_ID ) ;
5359: oe_debug_pub.add( 'P_ORDERED_ITEM: '||P_ORDERED_ITEM ) ;
5360: oe_debug_pub.add( 'P_SOLD_TO_ORG_ID: '||P_SOLD_TO_ORG_ID ) ;
5361: oe_debug_pub.add( 'P_DESCRIPTION: '||P_DESCRIPTION ) ;
5362: oe_debug_pub.add( 'L_ORGANIZATION_ID: '||L_ORGANIZATION_ID ) ;
5363: END IF;

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

5356: oe_debug_pub.add( 'P_ITEM_IDENTIFIER_TYPE:'||P_ITEM_IDENTIFIER_TYPE ) ;
5357: oe_debug_pub.add( 'P_ORDERED_ITEM_ID: '||P_ORDERED_ITEM_ID ) ;
5358: oe_debug_pub.add( 'P_INVENTORY_ITEM_ID: '||P_INVENTORY_ITEM_ID ) ;
5359: oe_debug_pub.add( 'P_ORDERED_ITEM: '||P_ORDERED_ITEM ) ;
5360: oe_debug_pub.add( 'P_SOLD_TO_ORG_ID: '||P_SOLD_TO_ORG_ID ) ;
5361: oe_debug_pub.add( 'P_DESCRIPTION: '||P_DESCRIPTION ) ;
5362: oe_debug_pub.add( 'L_ORGANIZATION_ID: '||L_ORGANIZATION_ID ) ;
5363: END IF;
5364:

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

5357: oe_debug_pub.add( 'P_ORDERED_ITEM_ID: '||P_ORDERED_ITEM_ID ) ;
5358: oe_debug_pub.add( 'P_INVENTORY_ITEM_ID: '||P_INVENTORY_ITEM_ID ) ;
5359: oe_debug_pub.add( 'P_ORDERED_ITEM: '||P_ORDERED_ITEM ) ;
5360: oe_debug_pub.add( 'P_SOLD_TO_ORG_ID: '||P_SOLD_TO_ORG_ID ) ;
5361: oe_debug_pub.add( 'P_DESCRIPTION: '||P_DESCRIPTION ) ;
5362: oe_debug_pub.add( 'L_ORGANIZATION_ID: '||L_ORGANIZATION_ID ) ;
5363: END IF;
5364:
5365: IF NVL(p_item_identifier_type, 'INT') = 'INT' THEN

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

5358: oe_debug_pub.add( 'P_INVENTORY_ITEM_ID: '||P_INVENTORY_ITEM_ID ) ;
5359: oe_debug_pub.add( 'P_ORDERED_ITEM: '||P_ORDERED_ITEM ) ;
5360: oe_debug_pub.add( 'P_SOLD_TO_ORG_ID: '||P_SOLD_TO_ORG_ID ) ;
5361: oe_debug_pub.add( 'P_DESCRIPTION: '||P_DESCRIPTION ) ;
5362: oe_debug_pub.add( 'L_ORGANIZATION_ID: '||L_ORGANIZATION_ID ) ;
5363: END IF;
5364:
5365: IF NVL(p_item_identifier_type, 'INT') = 'INT' THEN
5366: IF (Instr(p_description, '%') = 0) THEN

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

5364:
5365: IF NVL(p_item_identifier_type, 'INT') = 'INT' THEN
5366: IF (Instr(p_description, '%') = 0) THEN
5367: IF l_debug_level > 0 THEN
5368: oe_debug_pub.add( 'ENTERING INT::EXACT MATCH' ) ;
5369: END IF;
5370: SELECT count(*)
5371: INTO l_count
5372: FROM mtl_system_items_vl

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

5374: AND organization_id = l_organization_id
5375: AND description = p_description;
5376: ELSE
5377: IF l_debug_level > 0 THEN
5378: oe_debug_pub.add( 'ENTERING INT::PARTIAL' ) ;
5379: END IF;
5380:
5381: SELECT count(*)
5382: INTO l_count

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

5389:
5390: ELSIF NVL(p_item_identifier_type, 'INT') = 'CUST' THEN
5391: IF (Instr(p_description, '%') = 0) THEN
5392: IF l_debug_level > 0 THEN
5393: oe_debug_pub.add( 'ENTERING CUST::EXACT MATCH' ) ;
5394: END IF;
5395: SELECT count(*)
5396: INTO l_count
5397: FROM mtl_customer_items citems

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

5405: AND citems.customer_id = p_sold_to_org_id
5406: AND nvl(citems.customer_item_desc, sitems.description) = p_description;
5407: ELSE
5408: IF l_debug_level > 0 THEN
5409: oe_debug_pub.add( 'ENTERING CUST::PARTIAL' ) ;
5410: END IF;
5411: SELECT count(*)
5412: INTO l_count
5413: FROM mtl_customer_items citems

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

5424: ELSE
5425: IF p_ordered_item_id IS NULL THEN
5426: IF (Instr(p_description, '%') = 0) THEN
5427: IF l_debug_level > 0 THEN
5428: oe_debug_pub.add( 'ENTERING GENERIC::EXACT MATCH' ) ;
5429: END IF;
5430: SELECT count(*)
5431: INTO l_count
5432: FROM mtl_cross_reference_types types

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

5440: AND items.cross_reference = p_ordered_item
5441: AND nvl(items.description, sitems.description) = p_description;
5442: ELSE
5443: IF l_debug_level > 0 THEN
5444: oe_debug_pub.add( 'ENTERING GENERIC::PARTIAL' ) ;
5445: END IF;
5446: SELECT count(*)
5447: INTO l_count
5448: FROM mtl_cross_reference_types types

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

5460: END IF;
5461:
5462: IF l_count = 0 THEN
5463: IF l_debug_level > 0 THEN
5464: oe_debug_pub.add( 'NO MATCHES' ) ;
5465: END IF;
5466: RETURN 'N';
5467: ELSE
5468: IF l_debug_level > 0 THEN

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

5465: END IF;
5466: RETURN 'N';
5467: ELSE
5468: IF l_debug_level > 0 THEN
5469: oe_debug_pub.add( 'THERE ARE MATCHES' ) ;
5470: END IF;
5471: RETURN 'Y';
5472: END IF;
5473:

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

5486: ) RETURN VARCHAR2 IS
5487: l_organization_id Number;/*:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');*/
5488: l_count NUMBER := 0;
5489: --
5490: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5491: --
5492: BEGIN
5493: --Bug 9684561
5494: l_organization_id := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID',

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

5495: p_org_id);
5496:
5497: IF l_debug_level > 0 THEN
5498:
5499: oe_debug_pub.add( 'P_ITEM_IDENTIFIER_TYPE: '||P_ITEM_IDENTIFIER_TYPE ) ;
5500: oe_debug_pub.add( 'P_ORDERED_ITEM_ID: '||P_ORDERED_ITEM_ID ) ;
5501: oe_debug_pub.add( 'P_INVENTORY_ITEM_ID: '||P_INVENTORY_ITEM_ID ) ;
5502: oe_debug_pub.add( 'P_ORDERED_ITEM: '||P_ORDERED_ITEM ) ;
5503: oe_debug_pub.add( 'P_SOLD_TO_ORG_ID: '||P_SOLD_TO_ORG_ID ) ;

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

5496:
5497: IF l_debug_level > 0 THEN
5498:
5499: oe_debug_pub.add( 'P_ITEM_IDENTIFIER_TYPE: '||P_ITEM_IDENTIFIER_TYPE ) ;
5500: oe_debug_pub.add( 'P_ORDERED_ITEM_ID: '||P_ORDERED_ITEM_ID ) ;
5501: oe_debug_pub.add( 'P_INVENTORY_ITEM_ID: '||P_INVENTORY_ITEM_ID ) ;
5502: oe_debug_pub.add( 'P_ORDERED_ITEM: '||P_ORDERED_ITEM ) ;
5503: oe_debug_pub.add( 'P_SOLD_TO_ORG_ID: '||P_SOLD_TO_ORG_ID ) ;
5504: oe_debug_pub.add( 'p_inventory_item: '||p_inventory_item ) ;

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

5497: IF l_debug_level > 0 THEN
5498:
5499: oe_debug_pub.add( 'P_ITEM_IDENTIFIER_TYPE: '||P_ITEM_IDENTIFIER_TYPE ) ;
5500: oe_debug_pub.add( 'P_ORDERED_ITEM_ID: '||P_ORDERED_ITEM_ID ) ;
5501: oe_debug_pub.add( 'P_INVENTORY_ITEM_ID: '||P_INVENTORY_ITEM_ID ) ;
5502: oe_debug_pub.add( 'P_ORDERED_ITEM: '||P_ORDERED_ITEM ) ;
5503: oe_debug_pub.add( 'P_SOLD_TO_ORG_ID: '||P_SOLD_TO_ORG_ID ) ;
5504: oe_debug_pub.add( 'p_inventory_item: '||p_inventory_item ) ;
5505: oe_debug_pub.add( 'L_ORGANIZATION_ID: '||L_ORGANIZATION_ID ) ;

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

5498:
5499: oe_debug_pub.add( 'P_ITEM_IDENTIFIER_TYPE: '||P_ITEM_IDENTIFIER_TYPE ) ;
5500: oe_debug_pub.add( 'P_ORDERED_ITEM_ID: '||P_ORDERED_ITEM_ID ) ;
5501: oe_debug_pub.add( 'P_INVENTORY_ITEM_ID: '||P_INVENTORY_ITEM_ID ) ;
5502: oe_debug_pub.add( 'P_ORDERED_ITEM: '||P_ORDERED_ITEM ) ;
5503: oe_debug_pub.add( 'P_SOLD_TO_ORG_ID: '||P_SOLD_TO_ORG_ID ) ;
5504: oe_debug_pub.add( 'p_inventory_item: '||p_inventory_item ) ;
5505: oe_debug_pub.add( 'L_ORGANIZATION_ID: '||L_ORGANIZATION_ID ) ;
5506: END IF;

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

5499: oe_debug_pub.add( 'P_ITEM_IDENTIFIER_TYPE: '||P_ITEM_IDENTIFIER_TYPE ) ;
5500: oe_debug_pub.add( 'P_ORDERED_ITEM_ID: '||P_ORDERED_ITEM_ID ) ;
5501: oe_debug_pub.add( 'P_INVENTORY_ITEM_ID: '||P_INVENTORY_ITEM_ID ) ;
5502: oe_debug_pub.add( 'P_ORDERED_ITEM: '||P_ORDERED_ITEM ) ;
5503: oe_debug_pub.add( 'P_SOLD_TO_ORG_ID: '||P_SOLD_TO_ORG_ID ) ;
5504: oe_debug_pub.add( 'p_inventory_item: '||p_inventory_item ) ;
5505: oe_debug_pub.add( 'L_ORGANIZATION_ID: '||L_ORGANIZATION_ID ) ;
5506: END IF;
5507:

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

5500: oe_debug_pub.add( 'P_ORDERED_ITEM_ID: '||P_ORDERED_ITEM_ID ) ;
5501: oe_debug_pub.add( 'P_INVENTORY_ITEM_ID: '||P_INVENTORY_ITEM_ID ) ;
5502: oe_debug_pub.add( 'P_ORDERED_ITEM: '||P_ORDERED_ITEM ) ;
5503: oe_debug_pub.add( 'P_SOLD_TO_ORG_ID: '||P_SOLD_TO_ORG_ID ) ;
5504: oe_debug_pub.add( 'p_inventory_item: '||p_inventory_item ) ;
5505: oe_debug_pub.add( 'L_ORGANIZATION_ID: '||L_ORGANIZATION_ID ) ;
5506: END IF;
5507:
5508: IF NVL(p_item_identifier_type, 'INT') = 'INT' THEN

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

5501: oe_debug_pub.add( 'P_INVENTORY_ITEM_ID: '||P_INVENTORY_ITEM_ID ) ;
5502: oe_debug_pub.add( 'P_ORDERED_ITEM: '||P_ORDERED_ITEM ) ;
5503: oe_debug_pub.add( 'P_SOLD_TO_ORG_ID: '||P_SOLD_TO_ORG_ID ) ;
5504: oe_debug_pub.add( 'p_inventory_item: '||p_inventory_item ) ;
5505: oe_debug_pub.add( 'L_ORGANIZATION_ID: '||L_ORGANIZATION_ID ) ;
5506: END IF;
5507:
5508: IF NVL(p_item_identifier_type, 'INT') = 'INT' THEN
5509: IF (Instr(p_inventory_item, '%') = 0) THEN

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

5507:
5508: IF NVL(p_item_identifier_type, 'INT') = 'INT' THEN
5509: IF (Instr(p_inventory_item, '%') = 0) THEN
5510: IF l_debug_level > 0 THEN
5511: oe_debug_pub.add( 'ENTERING INT::EXACT MATCH' ) ;
5512: END IF;
5513: SELECT count(*)
5514: INTO l_count
5515: FROM mtl_system_items_vl

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

5517: AND organization_id = l_organization_id
5518: AND concatenated_segments = p_inventory_item;
5519: ELSE
5520: IF l_debug_level > 0 THEN
5521: oe_debug_pub.add( 'ENTERING INT::PARTIAL' ) ;
5522: END IF;
5523: SELECT count(*)
5524: INTO l_count
5525: FROM mtl_system_items_vl

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

5530:
5531: ELSIF NVL(p_item_identifier_type, 'INT') = 'CUST' THEN
5532: IF (Instr(p_inventory_item, '%') = 0) THEN
5533: IF l_debug_level > 0 THEN
5534: oe_debug_pub.add( 'ENTERING CUST::EXACT MATCH' ) ;
5535: END IF;
5536: SELECT count(*)
5537: INTO l_count
5538: FROM mtl_customer_items citems

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

5546: AND citems.customer_id = p_sold_to_org_id
5547: AND sitems.concatenated_segments = p_inventory_item;
5548: ELSE
5549: IF l_debug_level > 0 THEN
5550: oe_debug_pub.add( 'ENTERING CUST::PARTIAL' ) ;
5551: END IF;
5552: SELECT count(*)
5553: INTO l_count
5554: FROM mtl_customer_items citems

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

5566: ELSE
5567: IF p_ordered_item_id IS NULL THEN
5568: IF (Instr(p_inventory_item, '%') = 0) THEN
5569: IF l_debug_level > 0 THEN
5570: oe_debug_pub.add( 'ENTERING GENERIC::EXACT MATCH' ) ;
5571: END IF;
5572: SELECT count(*)
5573: INTO l_count
5574: FROM mtl_cross_reference_types types

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

5582: AND items.cross_reference = p_ordered_item
5583: AND sitems.concatenated_segments = p_inventory_item;
5584: ELSE
5585: IF l_debug_level > 0 THEN
5586: oe_debug_pub.add( 'ENTERING GENERIC::PARTIAL' ) ;
5587: END IF;
5588: SELECT count(*)
5589: INTO l_count
5590: FROM mtl_cross_reference_types types

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

5602: END IF;
5603:
5604: IF l_count = 0 THEN
5605: IF l_debug_level > 0 THEN
5606: oe_debug_pub.add( 'NO MATCHES' ) ;
5607: END IF;
5608: RETURN 'N';
5609: ELSE
5610: IF l_debug_level > 0 THEN

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

5607: END IF;
5608: RETURN 'N';
5609: ELSE
5610: IF l_debug_level > 0 THEN
5611: oe_debug_pub.add( 'THERE ARE MATCHES' ) ;
5612: END IF;
5613: RETURN 'Y';
5614: END IF;
5615: END Is_Internal_Item_Matched;

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

5628: ) RETURN VARCHAR2 IS
5629: l_organization_id Number;/*= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');*/
5630: l_count NUMBER := 0;
5631: --
5632: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5633: --
5634: BEGIN
5635: --Bug 9684561
5636: l_organization_id := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID',

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

5635: --Bug 9684561
5636: l_organization_id := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID',
5637: p_org_id);
5638: IF l_debug_level > 0 THEN
5639: oe_debug_pub.add( 'P_ITEM_IDENTIFIER_TYPE: '||P_ITEM_IDENTIFIER_TYPE ) ;
5640: oe_debug_pub.add( 'P_ORDERED_ITEM_ID: '||P_ORDERED_ITEM_ID ) ;
5641: oe_debug_pub.add( 'P_INVENTORY_ITEM_ID: '||P_INVENTORY_ITEM_ID ) ;
5642: oe_debug_pub.add( 'P_ORDERED_ITEM: '||P_ORDERED_ITEM ) ;
5643: oe_debug_pub.add( 'P_SOLD_TO_ORG_ID: '||P_SOLD_TO_ORG_ID ) ;

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

5636: l_organization_id := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID',
5637: p_org_id);
5638: IF l_debug_level > 0 THEN
5639: oe_debug_pub.add( 'P_ITEM_IDENTIFIER_TYPE: '||P_ITEM_IDENTIFIER_TYPE ) ;
5640: oe_debug_pub.add( 'P_ORDERED_ITEM_ID: '||P_ORDERED_ITEM_ID ) ;
5641: oe_debug_pub.add( 'P_INVENTORY_ITEM_ID: '||P_INVENTORY_ITEM_ID ) ;
5642: oe_debug_pub.add( 'P_ORDERED_ITEM: '||P_ORDERED_ITEM ) ;
5643: oe_debug_pub.add( 'P_SOLD_TO_ORG_ID: '||P_SOLD_TO_ORG_ID ) ;
5644: oe_debug_pub.add( 'P_ITEM: '||P_ITEM ) ;

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

5637: p_org_id);
5638: IF l_debug_level > 0 THEN
5639: oe_debug_pub.add( 'P_ITEM_IDENTIFIER_TYPE: '||P_ITEM_IDENTIFIER_TYPE ) ;
5640: oe_debug_pub.add( 'P_ORDERED_ITEM_ID: '||P_ORDERED_ITEM_ID ) ;
5641: oe_debug_pub.add( 'P_INVENTORY_ITEM_ID: '||P_INVENTORY_ITEM_ID ) ;
5642: oe_debug_pub.add( 'P_ORDERED_ITEM: '||P_ORDERED_ITEM ) ;
5643: oe_debug_pub.add( 'P_SOLD_TO_ORG_ID: '||P_SOLD_TO_ORG_ID ) ;
5644: oe_debug_pub.add( 'P_ITEM: '||P_ITEM ) ;
5645: oe_debug_pub.add( 'L_ORGANIZATION_ID: '||L_ORGANIZATION_ID ) ;

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

5638: IF l_debug_level > 0 THEN
5639: oe_debug_pub.add( 'P_ITEM_IDENTIFIER_TYPE: '||P_ITEM_IDENTIFIER_TYPE ) ;
5640: oe_debug_pub.add( 'P_ORDERED_ITEM_ID: '||P_ORDERED_ITEM_ID ) ;
5641: oe_debug_pub.add( 'P_INVENTORY_ITEM_ID: '||P_INVENTORY_ITEM_ID ) ;
5642: oe_debug_pub.add( 'P_ORDERED_ITEM: '||P_ORDERED_ITEM ) ;
5643: oe_debug_pub.add( 'P_SOLD_TO_ORG_ID: '||P_SOLD_TO_ORG_ID ) ;
5644: oe_debug_pub.add( 'P_ITEM: '||P_ITEM ) ;
5645: oe_debug_pub.add( 'L_ORGANIZATION_ID: '||L_ORGANIZATION_ID ) ;
5646: END IF;

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

5639: oe_debug_pub.add( 'P_ITEM_IDENTIFIER_TYPE: '||P_ITEM_IDENTIFIER_TYPE ) ;
5640: oe_debug_pub.add( 'P_ORDERED_ITEM_ID: '||P_ORDERED_ITEM_ID ) ;
5641: oe_debug_pub.add( 'P_INVENTORY_ITEM_ID: '||P_INVENTORY_ITEM_ID ) ;
5642: oe_debug_pub.add( 'P_ORDERED_ITEM: '||P_ORDERED_ITEM ) ;
5643: oe_debug_pub.add( 'P_SOLD_TO_ORG_ID: '||P_SOLD_TO_ORG_ID ) ;
5644: oe_debug_pub.add( 'P_ITEM: '||P_ITEM ) ;
5645: oe_debug_pub.add( 'L_ORGANIZATION_ID: '||L_ORGANIZATION_ID ) ;
5646: END IF;
5647:

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

5640: oe_debug_pub.add( 'P_ORDERED_ITEM_ID: '||P_ORDERED_ITEM_ID ) ;
5641: oe_debug_pub.add( 'P_INVENTORY_ITEM_ID: '||P_INVENTORY_ITEM_ID ) ;
5642: oe_debug_pub.add( 'P_ORDERED_ITEM: '||P_ORDERED_ITEM ) ;
5643: oe_debug_pub.add( 'P_SOLD_TO_ORG_ID: '||P_SOLD_TO_ORG_ID ) ;
5644: oe_debug_pub.add( 'P_ITEM: '||P_ITEM ) ;
5645: oe_debug_pub.add( 'L_ORGANIZATION_ID: '||L_ORGANIZATION_ID ) ;
5646: END IF;
5647:
5648: IF NVL(p_item_identifier_type, 'INT') = 'INT' THEN

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

5641: oe_debug_pub.add( 'P_INVENTORY_ITEM_ID: '||P_INVENTORY_ITEM_ID ) ;
5642: oe_debug_pub.add( 'P_ORDERED_ITEM: '||P_ORDERED_ITEM ) ;
5643: oe_debug_pub.add( 'P_SOLD_TO_ORG_ID: '||P_SOLD_TO_ORG_ID ) ;
5644: oe_debug_pub.add( 'P_ITEM: '||P_ITEM ) ;
5645: oe_debug_pub.add( 'L_ORGANIZATION_ID: '||L_ORGANIZATION_ID ) ;
5646: END IF;
5647:
5648: IF NVL(p_item_identifier_type, 'INT') = 'INT' THEN
5649: IF (Instr(p_item, '%') = 0) THEN

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

5647:
5648: IF NVL(p_item_identifier_type, 'INT') = 'INT' THEN
5649: IF (Instr(p_item, '%') = 0) THEN
5650: IF l_debug_level > 0 THEN
5651: oe_debug_pub.add( 'ENTERING INT::EXACT MATCH' ) ;
5652: END IF;
5653: SELECT count(*)
5654: INTO l_count
5655: FROM mtl_system_items_vl

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

5657: AND organization_id = l_organization_id
5658: AND concatenated_segments = p_item;
5659: ELSE
5660: IF l_debug_level > 0 THEN
5661: oe_debug_pub.add( 'ENTERING INT::PARTIAL' ) ;
5662: END IF;
5663: SELECT count(*)
5664: INTO l_count
5665: FROM mtl_system_items_vl

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

5670:
5671: ELSIF NVL(p_item_identifier_type, 'INT') = 'CUST' THEN
5672: IF (Instr(p_item, '%') = 0) THEN
5673: IF l_debug_level > 0 THEN
5674: oe_debug_pub.add( 'ENTERING CUST::EXACT MATCH' ) ;
5675: END IF;
5676: SELECT count(*)
5677: INTO l_count
5678: FROM mtl_customer_items citems

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

5686: AND citems.customer_id = p_sold_to_org_id
5687: AND nvl(citems.customer_item_number, sitems.concatenated_segments) =p_item;
5688: ELSE
5689: IF l_debug_level > 0 THEN
5690: oe_debug_pub.add( 'ENTERING CUST::PARTIAL' ) ;
5691: END IF;
5692: SELECT count(*)
5693: INTO l_count
5694: FROM mtl_customer_items citems

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

5705: ELSE
5706: IF p_ordered_item_id IS NULL THEN
5707: IF (Instr(p_item, '%') = 0) THEN
5708: IF l_debug_level > 0 THEN
5709: oe_debug_pub.add( 'ENTERING GENERIC::EXACT MATCH' ) ;
5710: END IF;
5711: SELECT count(*)
5712: INTO l_count
5713: FROM mtl_cross_reference_types types

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

5721: AND items.cross_reference = p_ordered_item
5722: AND nvl(items.cross_reference, sitems.concatenated_segments) = p_item;
5723: ELSE
5724: IF l_debug_level > 0 THEN
5725: oe_debug_pub.add( 'ENTERING GENERIC::PARTIAL' ) ;
5726: END IF;
5727: SELECT count(*)
5728: INTO l_count
5729: FROM mtl_cross_reference_types types

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

5741: END IF;
5742:
5743: IF l_count = 0 THEN
5744: IF l_debug_level > 0 THEN
5745: oe_debug_pub.add( 'NO MATCHES' ) ;
5746: END IF;
5747: RETURN 'N';
5748: ELSE
5749: IF l_debug_level > 0 THEN

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

5746: END IF;
5747: RETURN 'N';
5748: ELSE
5749: IF l_debug_level > 0 THEN
5750: oe_debug_pub.add( 'THERE ARE MATCHES' ) ;
5751: END IF;
5752: RETURN 'Y';
5753: END IF;
5754: END Is_Item_Matched;

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

5800: l_ref_split_ship_from VARCHAR2(10);--14654985
5801:
5802:
5803: --
5804: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5805: --
5806: BEGIN
5807:
5808: IF l_debug_level > 0 THEN

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

5805: --
5806: BEGIN
5807:
5808: IF l_debug_level > 0 THEN
5809: oe_debug_pub.add( 'LINE CONTROLLER - IN SPLIT ' , 1 ) ;
5810: END IF;
5811:
5812: /* l_control_rec.controlled_operation := TRUE;
5813: l_control_rec.validate_entity := TRUE;

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

5828: IF i =1 THEN
5829: IF x_line_tbl_type(i).line_id is not null THEN
5830: l_line_id:=x_line_tbl_type(i).line_id;
5831: IF l_debug_level > 0 THEN
5832: oe_debug_pub.add( 'LINE CONTROLLER - BEFORE GET LINE'|| X_LINE_TBL_TYPE ( I ) .LINE_ID , 1 ) ;
5833: END IF;
5834: -- l_x_line_tbl(i):=OE_ORDER_PUB.G_MISS_LINE_REC;
5835: /* Get_line
5836: ( p_db_record => FALSE

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

5848: RAISE FND_API.G_EXC_ERROR;
5849: END IF;
5850:
5851: IF l_debug_level > 0 THEN
5852: oe_debug_pub.add( 'LINE CONTROLLER - AFTER GET LINE ' , 1 ) ;
5853: END IF;
5854: --10278858
5855: l_org_request_date := l_x_line_tbl(i).request_date;
5856: l_org_ship_from_org_id := l_x_line_tbl(i).ship_from_org_id;

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

5866: l_x_line_tbl(i).split_by:='USER';
5867: END IF;
5868: l_x_line_tbl(i).operation:= OE_GLOBALS.G_OPR_UPDATE;
5869: IF l_debug_level > 0 THEN
5870: OE_DEBUG_PUB.add('Audit Trail Reason Code being passed as '||p_change_reason_code,1);
5871: END IF;
5872: l_x_line_tbl(i).change_reason := p_change_reason_code;
5873: l_x_line_tbl(i).change_comments := p_change_comments;
5874: -- Bug# 4008409

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

5926: --8706868
5927: end loop;
5928:
5929: IF l_debug_level > 0 THEN
5930: oe_debug_pub.add( 'LINE CONTROLLER - IN SPLIT - CALLING PROCESS' , 1 ) ;
5931: END IF;
5932:
5933: Oe_Order_Pvt.Process_order
5934: ( p_api_version_number => 1.0

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

5961: );
5962:
5963: END IF;
5964: IF l_debug_level > 0 THEN
5965: oe_debug_pub.add( 'LINE CONTROLLER - IN SPLIT - AFTER CALLING PROCESS' , 1 ) ;
5966: END IF;
5967:
5968: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5969: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5994: -- This is to fix a p1 bug on tst115. The second call should not
5995: -- come as split
5996: l_line_tbl(i).operation:= OE_GLOBALS.G_OPR_UPDATE;
5997: IF l_debug_level > 0 THEN
5998: OE_DEBUG_PUB.add('Reason code being passed : '||l_line_tbl(i).change_reason,1);
5999: OE_DEBUG_PUB.add('Warehouse: '||x_line_tbl_type(i).ship_from_org_id,1);
6000: END IF;
6001: l_line_tbl(i).change_reason := p_change_reason_code;
6002: l_line_tbl(i).change_comments := p_change_comments;

Line 5999: OE_DEBUG_PUB.add('Warehouse: '||x_line_tbl_type(i).ship_from_org_id,1);

5995: -- come as split
5996: l_line_tbl(i).operation:= OE_GLOBALS.G_OPR_UPDATE;
5997: IF l_debug_level > 0 THEN
5998: OE_DEBUG_PUB.add('Reason code being passed : '||l_line_tbl(i).change_reason,1);
5999: OE_DEBUG_PUB.add('Warehouse: '||x_line_tbl_type(i).ship_from_org_id,1);
6000: END IF;
6001: l_line_tbl(i).change_reason := p_change_reason_code;
6002: l_line_tbl(i).change_comments := p_change_comments;
6003: l_line_tbl(i).split_action_code:=fnd_api.g_miss_char;

Line 6075: oe_debug_pub.ADD('Inside else Condition');

6071: IF l_ref_split_ship_from = 'Y' THEN --14654985
6072: l_line_tbl(l_rec_count).ship_from_org_id := x_line_tbl_type(k).ship_from_org_id;
6073: l_line_tbl(l_rec_count).subinventory := fnd_api.g_miss_char; --Added as a part of 14654985 for Bug 13560415, do not use nullnull;
6074: ELSE
6075: oe_debug_pub.ADD('Inside else Condition');
6076: l_line_tbl(l_rec_count).ship_from_org_id := l_x_line_tbl(i).ship_from_org_id;
6077: l_line_tbl(l_rec_count).subinventory := fnd_api.g_miss_char; --Added as a part of 14654985 for Bug 13560415, do not use nullnull;
6078: end if ; --14654985
6079:

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

6091: END IF;
6092:
6093: l_line_tbl(l_rec_count).operation := OE_GLOBALS.G_OPR_UPDATE;
6094: IF l_debug_level > 0 THEN
6095: OE_DEBUG_PUB.add('Reason code being passed : '||l_line_tbl(l_rec_count).change_reason,1);
6096: OE_DEBUG_PUB.add('Warehouse :'||l_line_tbl(l_rec_count).ship_from_org_id,1);
6097: END IF;
6098: l_line_tbl(l_rec_count).change_reason := p_change_reason_code;
6099: l_line_tbl(l_rec_count).change_comments := p_change_comments;

Line 6096: OE_DEBUG_PUB.add('Warehouse :'||l_line_tbl(l_rec_count).ship_from_org_id,1);

6092:
6093: l_line_tbl(l_rec_count).operation := OE_GLOBALS.G_OPR_UPDATE;
6094: IF l_debug_level > 0 THEN
6095: OE_DEBUG_PUB.add('Reason code being passed : '||l_line_tbl(l_rec_count).change_reason,1);
6096: OE_DEBUG_PUB.add('Warehouse :'||l_line_tbl(l_rec_count).ship_from_org_id,1);
6097: END IF;
6098: l_line_tbl(l_rec_count).change_reason := p_change_reason_code;
6099: l_line_tbl(l_rec_count).change_comments := p_change_comments;
6100: l_line_tbl(l_rec_count).split_action_code := fnd_api.g_miss_char;

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

6231: IS
6232: l_return_status Varchar2(30);
6233: l_count_to_keep NUMBER;
6234: --
6235: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6236: --
6237: /* l_new_line_rec OE_Order_PUB.Line_Rec_Type; --3445778
6238: l_old_line_rec OE_Order_PUB.Line_Rec_Type; --3445778
6239: l_index NUMBER; --3445778 */

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

6251:
6252: l_header_id := g_line_rec.header_id;
6253:
6254: if l_debug_level > 0 then
6255: oe_debug_pub.add('Roll version global is set');
6256: oe_debug_pub.add('Header ID: '||l_header_id);
6257: end if;
6258:
6259: IF NOT OE_Delayed_Requests_Pvt.Check_For_Request

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

6252: l_header_id := g_line_rec.header_id;
6253:
6254: if l_debug_level > 0 then
6255: oe_debug_pub.add('Roll version global is set');
6256: oe_debug_pub.add('Header ID: '||l_header_id);
6257: end if;
6258:
6259: IF NOT OE_Delayed_Requests_Pvt.Check_For_Request
6260: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL

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

6261: ,p_entity_id => l_header_id
6262: ,p_request_type => OE_GLOBALS.G_VERSION_AUDIT
6263: )
6264: THEN
6265: oe_debug_pub.add('Request does not exist, reset versioning globals');
6266: IF (NOT OE_Versioning_Util.Reset_Globals) THEN
6267: l_return_status := FND_API.G_RET_STS_ERROR;
6268: RETURN;
6269: END IF;

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

6279: ,p_delete_against => FALSE
6280: ,x_return_status => l_return_status);
6281:
6282: /* -- Added for bug 3445778 --Commenting the code for 3575018
6283: oe_debug_pub.add('Executing code for updating global picture, line_id: ' || p_line_id, 1);
6284:
6285: -- Set the operation on the record so that globals are updated
6286: l_new_line_rec.operation := OE_GLOBALS.G_OPR_DELETE;
6287: l_new_line_rec.line_id := p_line_id;

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

6352: RETURN VARCHAR2
6353: IS
6354: l_order_date_type_code VARCHAR2(30) := null;
6355: --
6356: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6357: --
6358: BEGIN
6359:
6360: SELECT order_date_type_code

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

6397: ) IS
6398: l_site_use_code VARCHAR2(30);
6399:
6400: --
6401: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6402: --
6403: BEGIN
6404: l_site_use_code := 'SHIP_TO';
6405:

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

6428: ) IS
6429:
6430: l_site_use_code VARCHAR2(30);
6431: --
6432: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6433: --
6434: BEGIN
6435: l_site_use_code := 'BILL_TO';
6436:

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

6463: , x_shipment_number OUT NOCOPY Number
6464: ) IS
6465: l_line_number Number;
6466: --
6467: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6468: --
6469: BEGIN
6470: SELECT OE_ORDER_LINES_S.NEXTVAL
6471: INTO x_line_id

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

6518: l_organization_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
6519: --bug 10047225
6520: l_valid_kff boolean;
6521: --
6522: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6523: --
6524: BEGIN
6525: IF l_debug_level > 0 THEN
6526: oe_debug_pub.add( 'ENTER GET_ORDERED_ITEM PROCEDURE' ) ;

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

6522: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6523: --
6524: BEGIN
6525: IF l_debug_level > 0 THEN
6526: oe_debug_pub.add( 'ENTER GET_ORDERED_ITEM PROCEDURE' ) ;
6527: oe_debug_pub.add( 'ITEM_IDENTIFIER_TYPE : '||P_ITEM_IDENTIFIER_TYPE ) ;
6528: oe_debug_pub.add( 'INVENTORY_ITEM_ID : '||P_INVENTORY_ITEM_ID ) ;
6529: oe_debug_pub.add( 'ORDERED_ITEM_ID : '||P_ORDERED_ITEM_ID ) ;
6530: oe_debug_pub.add( 'SOLD_TO_ORG_ID : '||P_SOLD_TO_ORG_ID ) ;

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

6523: --
6524: BEGIN
6525: IF l_debug_level > 0 THEN
6526: oe_debug_pub.add( 'ENTER GET_ORDERED_ITEM PROCEDURE' ) ;
6527: oe_debug_pub.add( 'ITEM_IDENTIFIER_TYPE : '||P_ITEM_IDENTIFIER_TYPE ) ;
6528: oe_debug_pub.add( 'INVENTORY_ITEM_ID : '||P_INVENTORY_ITEM_ID ) ;
6529: oe_debug_pub.add( 'ORDERED_ITEM_ID : '||P_ORDERED_ITEM_ID ) ;
6530: oe_debug_pub.add( 'SOLD_TO_ORG_ID : '||P_SOLD_TO_ORG_ID ) ;
6531: END IF;

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

6524: BEGIN
6525: IF l_debug_level > 0 THEN
6526: oe_debug_pub.add( 'ENTER GET_ORDERED_ITEM PROCEDURE' ) ;
6527: oe_debug_pub.add( 'ITEM_IDENTIFIER_TYPE : '||P_ITEM_IDENTIFIER_TYPE ) ;
6528: oe_debug_pub.add( 'INVENTORY_ITEM_ID : '||P_INVENTORY_ITEM_ID ) ;
6529: oe_debug_pub.add( 'ORDERED_ITEM_ID : '||P_ORDERED_ITEM_ID ) ;
6530: oe_debug_pub.add( 'SOLD_TO_ORG_ID : '||P_SOLD_TO_ORG_ID ) ;
6531: END IF;
6532:

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

6525: IF l_debug_level > 0 THEN
6526: oe_debug_pub.add( 'ENTER GET_ORDERED_ITEM PROCEDURE' ) ;
6527: oe_debug_pub.add( 'ITEM_IDENTIFIER_TYPE : '||P_ITEM_IDENTIFIER_TYPE ) ;
6528: oe_debug_pub.add( 'INVENTORY_ITEM_ID : '||P_INVENTORY_ITEM_ID ) ;
6529: oe_debug_pub.add( 'ORDERED_ITEM_ID : '||P_ORDERED_ITEM_ID ) ;
6530: oe_debug_pub.add( 'SOLD_TO_ORG_ID : '||P_SOLD_TO_ORG_ID ) ;
6531: END IF;
6532:
6533: IF NVL(p_item_identifier_type, 'INT') = 'INT' THEN

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

6526: oe_debug_pub.add( 'ENTER GET_ORDERED_ITEM PROCEDURE' ) ;
6527: oe_debug_pub.add( 'ITEM_IDENTIFIER_TYPE : '||P_ITEM_IDENTIFIER_TYPE ) ;
6528: oe_debug_pub.add( 'INVENTORY_ITEM_ID : '||P_INVENTORY_ITEM_ID ) ;
6529: oe_debug_pub.add( 'ORDERED_ITEM_ID : '||P_ORDERED_ITEM_ID ) ;
6530: oe_debug_pub.add( 'SOLD_TO_ORG_ID : '||P_SOLD_TO_ORG_ID ) ;
6531: END IF;
6532:
6533: IF NVL(p_item_identifier_type, 'INT') = 'INT' THEN
6534:

Line 6553: oe_debug_pub.add('10047225: Proc GET_ORDERED_ITEM:l_valid_kff: TRUE');

6549: USER_ID=>NULL
6550: );
6551:
6552: if l_valid_kff then
6553: oe_debug_pub.add('10047225: Proc GET_ORDERED_ITEM:l_valid_kff: TRUE');
6554: x_ordered_item:= fnd_flex_keyval.concatenated_values;
6555:
6556: end if;
6557: oe_debug_pub.add('10047225:Proc GET_ORDERED_ITEM: x_ordered_item:'||x_ordered_item);

Line 6557: oe_debug_pub.add('10047225:Proc GET_ORDERED_ITEM: x_ordered_item:'||x_ordered_item);

6553: oe_debug_pub.add('10047225: Proc GET_ORDERED_ITEM:l_valid_kff: TRUE');
6554: x_ordered_item:= fnd_flex_keyval.concatenated_values;
6555:
6556: end if;
6557: oe_debug_pub.add('10047225:Proc GET_ORDERED_ITEM: x_ordered_item:'||x_ordered_item);
6558: --end of bug 10047225
6559: /* Commented for Bug 10047225
6560: SELECT concatenated_segments
6561: INTO x_ordered_item

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

6594: Null;
6595: END;
6596: END IF;
6597: IF l_debug_level > 0 THEN
6598: oe_debug_pub.add( 'EXIT GET_ORDERED_ITEM PROCEDURE' ) ;
6599: END IF;
6600:
6601: EXCEPTION
6602:

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

6625:
6626: l_return_status Varchar2(1);
6627:
6628: --
6629: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6630: --
6631: BEGIN
6632: OE_LINE_ADJ_UTIL.Delete_Row(p_line_id=>x_line_id);
6633:

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

6634: /* 1905650
6635: This is no longer required, since G_PRICE_ADJ request
6636: is logged against LINE entity now
6637:
6638: oe_debug_pub.add('delete the request logged for this line too');
6639: oe_delayed_requests_pvt.delete_request(
6640: p_entity_code =>OE_GLOBALS.G_ENTITY_LINE_ADJ,
6641: p_entity_id => x_line_id,
6642: p_request_type => OE_GLOBALS.G_PRICE_ADJ,

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

6652: x_customer_number OUT NOCOPY VARCHAR2
6653: ) IS
6654:
6655: --
6656: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6657: --
6658: BEGIN
6659:
6660: /* 2172651*/