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 FND_API

Line 244: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE

240:
241: l_error := 3;
242:
243: Oe_Order_Pvt.Lines
244: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
245: , p_init_msg_list => FND_API.G_TRUE
246: , p_control_rec => l_control_rec
247: , p_x_line_tbl => x_line_tbl
248: , p_x_old_line_tbl => x_old_line_tbl

Line 245: , p_init_msg_list => FND_API.G_TRUE

241: l_error := 3;
242:
243: Oe_Order_Pvt.Lines
244: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
245: , p_init_msg_list => FND_API.G_TRUE
246: , p_control_rec => l_control_rec
247: , p_x_line_tbl => x_line_tbl
248: , p_x_old_line_tbl => x_old_line_tbl
249: , x_return_status => l_return_status

Line 257: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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;
259: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
260: RAISE FND_API.G_EXC_ERROR;
261: END IF;

Line 258: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
259: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
260: RAISE FND_API.G_EXC_ERROR;
261: END IF;
262:

Line 259: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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;
259: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
260: RAISE FND_API.G_EXC_ERROR;
261: END IF;
262:
263:

Line 260: RAISE FND_API.G_EXC_ERROR;

256:
257: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
258: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
259: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
260: RAISE FND_API.G_EXC_ERROR;
261: END IF;
262:
263:
264: -- Unload OUT

Line 281: x_line_tbl(1).db_flag := FND_API.G_FALSE;

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:
283: Write_line
284: ( p_line_rec => x_line_tbl(1)
285: );

Line 292: x_return_status := FND_API.G_RET_STS_SUCCESS;

288: OE_GLOBALS.G_UI_FLAG := FALSE;
289:
290: -- Set return status.
291:
292: x_return_status := FND_API.G_RET_STS_SUCCESS;
293:
294: -- Get message count and data
295:
296: oe_msg_pub.count_and_get

Line 307: WHEN FND_API.G_EXC_ERROR THEN

303: END IF;
304:
305: EXCEPTION
306:
307: WHEN FND_API.G_EXC_ERROR THEN
308:
309: OE_GLOBALS.G_UI_FLAG := FALSE;
310:
311: x_return_status := FND_API.G_RET_STS_ERROR;

Line 311: x_return_status := FND_API.G_RET_STS_ERROR;

307: WHEN FND_API.G_EXC_ERROR THEN
308:
309: OE_GLOBALS.G_UI_FLAG := FALSE;
310:
311: x_return_status := FND_API.G_RET_STS_ERROR;
312:
313: -- Get message count and data
314:
315: oe_msg_pub.count_and_get

Line 320: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

316: ( p_count => x_msg_count
317: , p_data => x_msg_data
318: );
319:
320: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
321:
322: OE_GLOBALS.G_UI_FLAG := FALSE;
323:
324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

320: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
321:
322: OE_GLOBALS.G_UI_FLAG := FALSE;
323:
324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
325:
326: -- Get message count and data
327:
328: oe_msg_pub.count_and_get

Line 337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

333: WHEN OTHERS THEN
334:
335: OE_GLOBALS.G_UI_FLAG := FALSE;
336:
337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
338:
339: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
340: THEN
341: oe_msg_pub.Add_Exc_Msg

Line 503: x_line_tbl(1).line_type_id := FND_API.G_MISS_NUM;

499: ELSIF p_attr_id = OE_Line_Util.G_LATE_DEMAND_PENALTY_FACTOR THEN
500: x_line_tbl(1).late_demand_penalty_factor := TO_NUMBER(p_attr_value);
501: ELSIF p_attr_id = OE_Line_Util.G_LINE_CATEGORY THEN
502: x_line_tbl(1).line_category_code := p_attr_value;
503: x_line_tbl(1).line_type_id := FND_API.G_MISS_NUM;
504: ELSIF p_attr_id = OE_Line_Util.G_LINE THEN
505: x_line_tbl(1).line_id := TO_NUMBER(p_attr_value);
506: ELSIF p_attr_id = OE_Line_Util.G_LINE_NUMBER THEN
507: x_line_tbl(1).line_number := TO_NUMBER(p_attr_value);

Line 1098: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1094: , 'Unrecognized attribute'
1095: );
1096: END IF;
1097:
1098: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1099:
1100: END IF;
1101:
1102:

Line 1112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1108: ( G_PKG_NAME
1109: , 'Copy_Attribute_To_Rec'
1110: );
1111: END IF;
1112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1113: END Copy_Attribute_To_Rec;
1114:
1115: -- Procedure : Change_Attribute
1116: --

Line 1155: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1151:
1152: )
1153: IS
1154: l_control_rec OE_GLOBALS.Control_Rec_Type;
1155: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1156: l_date_format_mask VARCHAR2(30) := p_date_format_mask;
1157: l_order_date_type_code VARCHAR2(30) := null;
1158: l_orig_ship_from_org_id OE_Order_LINES.ship_from_org_id%TYPE;
1159: l_x_item_rec_type OE_ORDER_CACHE.item_rec_type; -- OPM 2/JUN/00

Line 1194: x_line_tbl(1).db_flag := FND_API.G_FALSE;

1190: -- Read line from cache
1191:
1192: IF p_default_cache_line_rec.line_id IS NOT NULL THEN
1193: x_line_tbl(1):=p_default_cache_line_rec;
1194: x_line_tbl(1).db_flag := FND_API.G_FALSE;
1195: Write_line
1196: ( p_line_rec => x_line_tbl(1)
1197: );
1198:

Line 1210: IF FND_API.To_Boolean(x_line_tbl(1).db_flag) THEN

1206: l_control_rec.default_attributes := FALSE;
1207: l_control_rec.clear_dependents := FALSE;
1208: l_control_rec.check_security := FALSE;
1209:
1210: IF FND_API.To_Boolean(x_line_tbl(1).db_flag) THEN
1211: x_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
1212: ELSE
1213: x_line_tbl(1).operation := OE_GLOBALS.G_OPR_CREATE;
1214: END IF;

Line 1218: p_validation_level => FND_API.G_VALID_LEVEL_NONE

1214: END IF;
1215:
1216: Oe_Order_Pvt.Lines
1217: (
1218: p_validation_level => FND_API.G_VALID_LEVEL_NONE
1219: , p_init_msg_list => FND_API.G_TRUE
1220: , p_control_rec => l_control_rec
1221: , p_x_line_tbl => x_line_tbl
1222: , p_x_old_line_tbl => x_old_line_tbl

Line 1219: , p_init_msg_list => FND_API.G_TRUE

1215:
1216: Oe_Order_Pvt.Lines
1217: (
1218: p_validation_level => FND_API.G_VALID_LEVEL_NONE
1219: , p_init_msg_list => FND_API.G_TRUE
1220: , p_control_rec => l_control_rec
1221: , p_x_line_tbl => x_line_tbl
1222: , p_x_old_line_tbl => x_old_line_tbl
1223: , x_return_status => l_return_status

Line 1225: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1221: , p_x_line_tbl => x_line_tbl
1222: , p_x_old_line_tbl => x_old_line_tbl
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;

Line 1229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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
1232: oe_debug_pub.add( 'DATE TYPE RETURN RET_STS_ERROR' , 2 ) ;
1233: END IF;

Line 1230: ELSIF l_return_status = FND_API.G_RET_STS_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
1232: oe_debug_pub.add( 'DATE TYPE RETURN RET_STS_ERROR' , 2 ) ;
1233: END IF;
1234: RAISE FND_API.G_EXC_ERROR;

Line 1234: RAISE FND_API.G_EXC_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:
1237: x_old_line_tbl(1) := x_line_tbl(1);
1238: ELSE

Line 1424: x_line_tbl(1).line_type_id := FND_API.G_MISS_NUM;

1420: ELSIF p_attr_id = OE_Line_Util.G_LATE_DEMAND_PENALTY_FACTOR THEN
1421: x_line_tbl(1).late_demand_penalty_factor := TO_NUMBER(p_attr_value);
1422: ELSIF p_attr_id = OE_Line_Util.G_LINE_CATEGORY THEN
1423: x_line_tbl(1).line_category_code := p_attr_value;
1424: x_line_tbl(1).line_type_id := FND_API.G_MISS_NUM;
1425: ELSIF p_attr_id = OE_Line_Util.G_LINE THEN
1426: x_line_tbl(1).line_id := TO_NUMBER(p_attr_value);
1427: ELSIF p_attr_id = OE_Line_Util.G_LINE_NUMBER THEN
1428: x_line_tbl(1).line_number := TO_NUMBER(p_attr_value);

Line 1992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1988: , 'Unrecognized attribute'
1989: );
1990: END IF;
1991:
1992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1993:
1994: END IF;
1995:
1996: -- PLEASE ADD THE ABOVE IF LOGIC FOR NEW ATTRIBUTES TO THE PROCEDURE

Line 2008: IF FND_API.To_Boolean(x_line_tbl(1).db_flag) THEN

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;
2010: ELSE
2011: x_line_tbl(1).operation := OE_GLOBALS.G_OPR_CREATE;
2012: END IF;

Line 2032: l_return_status := FND_API.G_RET_STS_ERROR;

2028:
2029: FND_MESSAGE.SET_NAME('ONT','OE_SCH_INV_SHP_DATE');
2030: OE_MSG_PUB.Add;
2031:
2032: l_return_status := FND_API.G_RET_STS_ERROR;
2033:
2034: END IF;
2035:
2036: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2036: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2032: l_return_status := FND_API.G_RET_STS_ERROR;
2033:
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;

Line 2040: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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
2043: oe_debug_pub.add( 'DATE TYPE RETURN RET_STS_ERROR' , 2 ) ;
2044: END IF;

Line 2041: ELSIF l_return_status = FND_API.G_RET_STS_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
2043: oe_debug_pub.add( 'DATE TYPE RETURN RET_STS_ERROR' , 2 ) ;
2044: END IF;
2045: RAISE FND_API.G_EXC_ERROR;

Line 2045: RAISE FND_API.G_EXC_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:
2048: END IF;
2049:

Line 2064: l_return_status := FND_API.G_RET_STS_ERROR;

2060:
2061: FND_MESSAGE.SET_NAME('ONT','OE_SCH_INV_ARR_DATE');
2062: OE_MSG_PUB.Add;
2063:
2064: l_return_status := FND_API.G_RET_STS_ERROR;
2065:
2066: END IF;
2067:
2068: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2068: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2064: l_return_status := FND_API.G_RET_STS_ERROR;
2065:
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;

Line 2072: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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
2075: oe_debug_pub.add( 'DATE TYPE RETURN RET_STS_ERROR' , 2 ) ;
2076: END IF;

Line 2073: ELSIF l_return_status = FND_API.G_RET_STS_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
2075: oe_debug_pub.add( 'DATE TYPE RETURN RET_STS_ERROR' , 2 ) ;
2076: END IF;
2077: RAISE FND_API.G_EXC_ERROR;

Line 2077: RAISE FND_API.G_EXC_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:
2080: END IF;
2081: END IF;

Line 2092: l_return_status := FND_API.G_RET_STS_ERROR;

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;
2093: RAISE FND_API.G_EXC_ERROR;
2094: END IF;
2095: -- end for 3998402
2096:

Line 2093: RAISE FND_API.G_EXC_ERROR;

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;
2093: RAISE FND_API.G_EXC_ERROR;
2094: END IF;
2095: -- end for 3998402
2096:
2097: IF l_debug_level > 0 THEN

Line 2105: p_validation_level => FND_API.G_VALID_LEVEL_NONE

2101:
2102: -- Call Oe_Order_Pvt.Process_order
2103: Oe_Order_Pvt.Lines
2104: (
2105: p_validation_level => FND_API.G_VALID_LEVEL_NONE
2106: , p_init_msg_list => FND_API.G_TRUE
2107: , p_control_rec => l_control_rec
2108: , p_x_line_tbl => x_line_tbl
2109: , p_x_old_line_tbl => x_old_line_tbl

Line 2106: , p_init_msg_list => FND_API.G_TRUE

2102: -- Call Oe_Order_Pvt.Process_order
2103: Oe_Order_Pvt.Lines
2104: (
2105: p_validation_level => FND_API.G_VALID_LEVEL_NONE
2106: , p_init_msg_list => FND_API.G_TRUE
2107: , p_control_rec => l_control_rec
2108: , p_x_line_tbl => x_line_tbl
2109: , p_x_old_line_tbl => x_old_line_tbl
2110: , x_return_status => l_return_status

Line 2117: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN -- Fix for bug3546224

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
2119: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
2120: (p_request_type =>OE_GLOBALS.G_COPY_ADJUSTMENTS
2121: ,p_delete => FND_API.G_TRUE

Line 2121: ,p_delete => FND_API.G_TRUE

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
2119: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
2120: (p_request_type =>OE_GLOBALS.G_COPY_ADJUSTMENTS
2121: ,p_delete => FND_API.G_TRUE
2122: ,x_return_status => l_return_status
2123: );
2124: END IF;
2125: END IF;

Line 2128: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2124: END IF;
2125: END IF;
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;

Line 2132: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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
2135: oe_debug_pub.add( 'PROCESS ORDER RETURN RET_STS_ERROR' , 2 ) ;
2136: END IF;

Line 2133: ELSIF l_return_status = FND_API.G_RET_STS_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
2135: oe_debug_pub.add( 'PROCESS ORDER RETURN RET_STS_ERROR' , 2 ) ;
2136: END IF;
2137: RAISE FND_API.G_EXC_ERROR;

Line 2137: RAISE FND_API.G_EXC_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:
2140:
2141: -- Unload OUT tbl

Line 2183: x_return_status := FND_API.G_RET_STS_SUCCESS;

2179: OE_GLOBALS.G_UI_FLAG := FALSE;
2180:
2181: -- Set return status.
2182:
2183: x_return_status := FND_API.G_RET_STS_SUCCESS;
2184:
2185: -- Get message count and data
2186:
2187: oe_msg_pub.count_and_get

Line 2198: WHEN FND_API.G_EXC_ERROR THEN

2194: END IF;
2195:
2196: EXCEPTION
2197:
2198: WHEN FND_API.G_EXC_ERROR THEN
2199:
2200: OE_GLOBALS.G_UI_FLAG := FALSE;
2201:
2202: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2202: x_return_status := FND_API.G_RET_STS_ERROR;

2198: WHEN FND_API.G_EXC_ERROR THEN
2199:
2200: OE_GLOBALS.G_UI_FLAG := FALSE;
2201:
2202: x_return_status := FND_API.G_RET_STS_ERROR;
2203:
2204: -- Get message count and data
2205:
2206: oe_msg_pub.count_and_get

Line 2211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2207: ( p_count => x_msg_count
2208: , p_data => x_msg_data
2209: );
2210:
2211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2212:
2213: OE_GLOBALS.G_UI_FLAG := FALSE;
2214:
2215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2212:
2213: OE_GLOBALS.G_UI_FLAG := FALSE;
2214:
2215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2216:
2217: -- Get message count and data
2218:
2219: oe_msg_pub.count_and_get

Line 2228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2224: WHEN OTHERS THEN
2225:
2226: OE_GLOBALS.G_UI_FLAG := FALSE;
2227:
2228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2229:
2230: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2231: THEN
2232: oe_msg_pub.Add_Exc_Msg

Line 2325: IF FND_API.To_Boolean(l_x_line_tbl(1).db_flag) THEN

2321: /* End Audit Trail */
2322:
2323: -- Set Operation.
2324:
2325: IF FND_API.To_Boolean(l_x_line_tbl(1).db_flag) THEN
2326: l_x_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
2327: ELSE
2328: l_x_line_tbl(1).operation := OE_GLOBALS.G_OPR_CREATE;
2329:

Line 2332: l_x_old_line_tbl(1).reserved_quantity := FND_API.G_MISS_NUM;

2328: l_x_line_tbl(1).operation := OE_GLOBALS.G_OPR_CREATE;
2329:
2330: /* We are passing the miss quantity for reserved filed
2331: since we are not converting this to null in OE_LINE_UTIL_EXT' */
2332: l_x_old_line_tbl(1).reserved_quantity := FND_API.G_MISS_NUM;
2333:
2334: END IF;
2335:
2336: -- Populate line table

Line 2347: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE

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
2350: , p_x_line_tbl => l_x_line_tbl
2351: , p_x_old_line_tbl => l_x_old_line_tbl

Line 2348: , p_init_msg_list => FND_API.G_TRUE

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
2350: , p_x_line_tbl => l_x_line_tbl
2351: , p_x_old_line_tbl => l_x_old_line_tbl
2352: , x_return_Status => l_return_status

Line 2355: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2351: , p_x_old_line_tbl => l_x_old_line_tbl
2352: , x_return_Status => l_return_status
2353: );
2354:
2355: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2357: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2358: RAISE FND_API.G_EXC_ERROR;
2359: END IF;

Line 2356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2352: , x_return_Status => l_return_status
2353: );
2354:
2355: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2357: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2358: RAISE FND_API.G_EXC_ERROR;
2359: END IF;
2360:

Line 2357: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2353: );
2354:
2355: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2357: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2358: RAISE FND_API.G_EXC_ERROR;
2359: END IF;
2360:
2361: /* The Process Requests and Notify should be invoked for */

Line 2358: RAISE FND_API.G_EXC_ERROR;

2354:
2355: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2357: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2358: RAISE FND_API.G_EXC_ERROR;
2359: END IF;
2360:
2361: /* The Process Requests and Notify should be invoked for */
2362: /* Pre-Pack H code level */

Line 2367: , p_init_msg_list => FND_API.G_FALSE

2363:
2364: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL < '110508' THEN
2365: Oe_Order_Pvt.Process_Requests_And_Notify
2366: ( p_process_requests => FALSE
2367: , p_init_msg_list => FND_API.G_FALSE
2368: , p_notify => TRUE
2369: , x_return_status => l_return_status
2370: , p_line_tbl => l_x_line_tbl
2371: , p_old_line_tbl => l_x_old_line_tbl

Line 2374: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2370: , p_line_tbl => l_x_line_tbl
2371: , p_old_line_tbl => l_x_old_line_tbl
2372: );
2373:
2374: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2376: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2377: RAISE FND_API.G_EXC_ERROR;
2378: END IF;

Line 2375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2371: , p_old_line_tbl => l_x_old_line_tbl
2372: );
2373:
2374: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2376: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2377: RAISE FND_API.G_EXC_ERROR;
2378: END IF;
2379:

Line 2376: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2372: );
2373:
2374: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2376: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2377: RAISE FND_API.G_EXC_ERROR;
2378: END IF;
2379:
2380: END IF;

Line 2377: RAISE FND_API.G_EXC_ERROR;

2373:
2374: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2376: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2377: RAISE FND_API.G_EXC_ERROR;
2378: END IF;
2379:
2380: END IF;
2381:

Line 2387: ,p_delete => FND_API.G_TRUE

2383: -- before processing for G_PRICE_LINE.
2384: IF OE_GLOBALS.G_DEFER_PRICING='N' THEN
2385: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
2386: (p_request_type =>OE_GLOBALS.G_COPY_ADJUSTMENTS
2387: ,p_delete => FND_API.G_TRUE
2388: ,x_return_status => l_return_status
2389: );
2390: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2390: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2386: (p_request_type =>OE_GLOBALS.G_COPY_ADJUSTMENTS
2387: ,p_delete => FND_API.G_TRUE
2388: ,x_return_status => l_return_status
2389: );
2390: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2392: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2393: RAISE FND_API.G_EXC_ERROR;
2394: END IF;

Line 2391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2387: ,p_delete => FND_API.G_TRUE
2388: ,x_return_status => l_return_status
2389: );
2390: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2392: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2393: RAISE FND_API.G_EXC_ERROR;
2394: END IF;
2395: END IF;

Line 2392: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2388: ,x_return_status => l_return_status
2389: );
2390: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2392: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2393: RAISE FND_API.G_EXC_ERROR;
2394: END IF;
2395: END IF;
2396:

Line 2393: RAISE FND_API.G_EXC_ERROR;

2389: );
2390: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2392: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2393: RAISE FND_API.G_EXC_ERROR;
2394: END IF;
2395: END IF;
2396:
2397: IF OE_GLOBALS.G_DEFER_PRICING='N' THEN

Line 2400: ,p_delete => FND_API.G_TRUE

2396:
2397: IF OE_GLOBALS.G_DEFER_PRICING='N' THEN
2398: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
2399: (p_request_type =>OE_GLOBALS.G_PRICE_LINE
2400: ,p_delete => FND_API.G_TRUE
2401: ,x_return_status => l_return_status
2402: );
2403: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2403: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2399: (p_request_type =>OE_GLOBALS.G_PRICE_LINE
2400: ,p_delete => FND_API.G_TRUE
2401: ,x_return_status => l_return_status
2402: );
2403: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2405: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2406: RAISE FND_API.G_EXC_ERROR;
2407: END IF;

Line 2404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2400: ,p_delete => FND_API.G_TRUE
2401: ,x_return_status => l_return_status
2402: );
2403: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2405: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2406: RAISE FND_API.G_EXC_ERROR;
2407: END IF;
2408: END IF;

Line 2405: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2401: ,x_return_status => l_return_status
2402: );
2403: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2405: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2406: RAISE FND_API.G_EXC_ERROR;
2407: END IF;
2408: END IF;
2409:

Line 2406: RAISE FND_API.G_EXC_ERROR;

2402: );
2403: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2405: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2406: RAISE FND_API.G_EXC_ERROR;
2407: END IF;
2408: END IF;
2409:
2410: IF OE_GLOBALS.G_DEFER_PRICING='N' THEN

Line 2413: ,p_delete => FND_API.G_TRUE

2409:
2410: IF OE_GLOBALS.G_DEFER_PRICING='N' THEN
2411: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
2412: (p_request_type =>OE_GLOBALS.G_TAX_LINE
2413: ,p_delete => FND_API.G_TRUE
2414: ,x_return_status => l_return_status
2415: );
2416: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2416: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2412: (p_request_type =>OE_GLOBALS.G_TAX_LINE
2413: ,p_delete => FND_API.G_TRUE
2414: ,x_return_status => l_return_status
2415: );
2416: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2418: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2419: RAISE FND_API.G_EXC_ERROR;
2420: END IF;

Line 2417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2413: ,p_delete => FND_API.G_TRUE
2414: ,x_return_status => l_return_status
2415: );
2416: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2418: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2419: RAISE FND_API.G_EXC_ERROR;
2420: END IF;
2421: END IF;

Line 2418: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2414: ,x_return_status => l_return_status
2415: );
2416: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2418: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2419: RAISE FND_API.G_EXC_ERROR;
2420: END IF;
2421: END IF;
2422:

Line 2419: RAISE FND_API.G_EXC_ERROR;

2415: );
2416: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2418: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2419: RAISE FND_API.G_EXC_ERROR;
2420: END IF;
2421: END IF;
2422:
2423: -- lkxu, commitment enhancement

Line 2431: ,p_delete => FND_API.G_TRUE

2427:
2428: IF OE_GLOBALS.G_DEFER_PRICING='N' THEN
2429: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
2430: (p_request_type =>OE_GLOBALS.G_CALCULATE_COMMITMENT
2431: ,p_delete => FND_API.G_TRUE
2432: ,x_return_status => l_return_status
2433: );
2434: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2434: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2430: (p_request_type =>OE_GLOBALS.G_CALCULATE_COMMITMENT
2431: ,p_delete => FND_API.G_TRUE
2432: ,x_return_status => l_return_status
2433: );
2434: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2436: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2437: RAISE FND_API.G_EXC_ERROR;
2438: END IF;

Line 2435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2431: ,p_delete => FND_API.G_TRUE
2432: ,x_return_status => l_return_status
2433: );
2434: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2436: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2437: RAISE FND_API.G_EXC_ERROR;
2438: END IF;
2439:

Line 2436: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2432: ,x_return_status => l_return_status
2433: );
2434: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2436: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2437: RAISE FND_API.G_EXC_ERROR;
2438: END IF;
2439:
2440: --bug 3560198

Line 2437: RAISE FND_API.G_EXC_ERROR;

2433: );
2434: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2436: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2437: RAISE FND_API.G_EXC_ERROR;
2438: END IF;
2439:
2440: --bug 3560198
2441: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

Line 2443: ,p_delete => FND_API.G_TRUE

2439:
2440: --bug 3560198
2441: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
2442: (p_request_type =>OE_GLOBALS.G_UPDATE_COMMITMENT_APPLIED
2443: ,p_delete => FND_API.G_TRUE
2444: ,x_return_status => l_return_status
2445: );
2446: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2447: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2446: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2442: (p_request_type =>OE_GLOBALS.G_UPDATE_COMMITMENT_APPLIED
2443: ,p_delete => FND_API.G_TRUE
2444: ,x_return_status => l_return_status
2445: );
2446: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2447: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2448: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2449: RAISE FND_API.G_EXC_ERROR;
2450: END IF;

Line 2447: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2443: ,p_delete => FND_API.G_TRUE
2444: ,x_return_status => l_return_status
2445: );
2446: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2447: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2448: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2449: RAISE FND_API.G_EXC_ERROR;
2450: END IF;
2451: --bug 3560198

Line 2448: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2444: ,x_return_status => l_return_status
2445: );
2446: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2447: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2448: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2449: RAISE FND_API.G_EXC_ERROR;
2450: END IF;
2451: --bug 3560198
2452: END IF;

Line 2449: RAISE FND_API.G_EXC_ERROR;

2445: );
2446: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2447: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2448: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2449: RAISE FND_API.G_EXC_ERROR;
2450: END IF;
2451: --bug 3560198
2452: END IF;
2453:

Line 2578: p_init_msg_list => FND_API.G_FALSE ,

2574: -- Call the charges API to get the Line level charges.
2575: IF OE_GLOBALS.G_DEFER_PRICING='N' THEN
2576: OE_CHARGE_PVT.Get_Charge_Amount(
2577: p_api_version_number => 1.1 ,
2578: p_init_msg_list => FND_API.G_FALSE ,
2579: p_header_id => l_x_line_rec.header_id ,
2580: p_line_id => l_x_line_rec.line_id ,
2581: p_all_charges => FND_API.G_FALSE ,
2582: x_return_status => l_return_status ,

Line 2581: p_all_charges => FND_API.G_FALSE ,

2577: p_api_version_number => 1.1 ,
2578: p_init_msg_list => FND_API.G_FALSE ,
2579: p_header_id => l_x_line_rec.header_id ,
2580: p_line_id => l_x_line_rec.line_id ,
2581: p_all_charges => FND_API.G_FALSE ,
2582: x_return_status => l_return_status ,
2583: x_msg_count => x_msg_count ,
2584: x_msg_data => x_msg_data ,
2585: x_charge_amount => l_charge_amount );

Line 2587: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2583: x_msg_count => x_msg_count ,
2584: x_msg_data => x_msg_data ,
2585: x_charge_amount => l_charge_amount );
2586:
2587: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2589: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2590: RAISE FND_API.G_EXC_ERROR;
2591: END IF;

Line 2588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2584: x_msg_data => x_msg_data ,
2585: x_charge_amount => l_charge_amount );
2586:
2587: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2589: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2590: RAISE FND_API.G_EXC_ERROR;
2591: END IF;
2592: x_line_val_rec.x_charges := l_charge_amount;

Line 2589: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2585: x_charge_amount => l_charge_amount );
2586:
2587: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2589: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2590: RAISE FND_API.G_EXC_ERROR;
2591: END IF;
2592: x_line_val_rec.x_charges := l_charge_amount;
2593: END IF;

Line 2590: RAISE FND_API.G_EXC_ERROR;

2586:
2587: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2589: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2590: RAISE FND_API.G_EXC_ERROR;
2591: END IF;
2592: x_line_val_rec.x_charges := l_charge_amount;
2593: END IF;
2594:

Line 2625: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2621: x_line_val_rec.x_commitment_applied_amount := OE_COMMITMENT_PVT.get_commitment_applied_amount
2622: (p_header_id => l_x_line_rec.header_id ,
2623: p_line_id => l_x_line_rec.line_id ,
2624: p_commitment_id => l_x_line_rec.commitment_id);
2625: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2627: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2628: RAISE FND_API.G_EXC_ERROR;
2629: END IF;

Line 2626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2622: (p_header_id => l_x_line_rec.header_id ,
2623: p_line_id => l_x_line_rec.line_id ,
2624: p_commitment_id => l_x_line_rec.commitment_id);
2625: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2627: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2628: RAISE FND_API.G_EXC_ERROR;
2629: END IF;
2630: END IF;

Line 2627: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2623: p_line_id => l_x_line_rec.line_id ,
2624: p_commitment_id => l_x_line_rec.commitment_id);
2625: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2627: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2628: RAISE FND_API.G_EXC_ERROR;
2629: END IF;
2630: END IF;
2631: END IF;

Line 2628: RAISE FND_API.G_EXC_ERROR;

2624: p_commitment_id => l_x_line_rec.commitment_id);
2625: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2627: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2628: RAISE FND_API.G_EXC_ERROR;
2629: END IF;
2630: END IF;
2631: END IF;
2632: -- Override List Price

Line 2649: x_return_status := FND_API.G_RET_STS_SUCCESS;

2645: OE_GLOBALS.G_UI_FLAG := FALSE;
2646:
2647: -- Set return status.
2648:
2649: x_return_status := FND_API.G_RET_STS_SUCCESS;
2650:
2651: -- Get message count and data
2652:
2653: oe_msg_pub.count_and_get

Line 2665: WHEN FND_API.G_EXC_ERROR THEN

2661:
2662:
2663: EXCEPTION
2664:
2665: WHEN FND_API.G_EXC_ERROR THEN
2666:
2667: OE_GLOBALS.G_UI_FLAG := FALSE;
2668:
2669: ROLLBACK TO SAVEPOINT Line_Validate_And_Write;

Line 2685: x_return_status := FND_API.G_RET_STS_ERROR;

2681: AND l_last_index IS NOT NULL -- 2068070
2682: AND OE_GLOBALS.G_START_LINE_FLOWS_TBL(l_last_index).line_id = p_line_id) THEN --Bug 3000619
2683: OE_GLOBALS.G_START_LINE_FLOWS_TBL.delete(l_last_index);
2684: END IF;
2685: x_return_status := FND_API.G_RET_STS_ERROR;
2686:
2687: -- Get message count and data
2688:
2689: oe_msg_pub.count_and_get

Line 2694: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2690: ( p_count => x_msg_count
2691: , p_data => x_msg_data
2692: );
2693:
2694: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2695:
2696: OE_GLOBALS.G_UI_FLAG := FALSE;
2697:
2698: ROLLBACK TO SAVEPOINT Line_Validate_And_Write;

Line 2705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2701: AND l_last_index IS NOT NULL -- 2068070
2702: AND OE_GLOBALS.G_START_LINE_FLOWS_TBL(l_last_index).line_id = p_line_id) THEN --Bug 3000619
2703: OE_GLOBALS.G_START_LINE_FLOWS_TBL.delete(l_last_index);
2704: END IF;
2705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2706:
2707: -- Get message count and data
2708:
2709: oe_msg_pub.count_and_get

Line 2725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2721: AND l_last_index IS NOT NULL -- 2068070
2722: AND OE_GLOBALS.G_START_LINE_FLOWS_TBL(l_last_index).line_id = p_line_id) THEN --Bug 3000619
2723: OE_GLOBALS.G_START_LINE_FLOWS_TBL.delete(l_last_index);
2724: END IF;
2725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2726:
2727: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2728: THEN
2729: oe_msg_pub.Add_Exc_Msg

Line 2810: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE

2806:
2807: -- Call Oe_Order_Pvt.Process_order
2808:
2809: Oe_Order_Pvt.Lines
2810: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
2811: , p_init_msg_list => FND_API.G_TRUE
2812: , p_control_rec => l_control_rec
2813: , p_x_line_tbl => l_x_line_tbl
2814: , p_x_old_line_tbl => l_x_old_line_tbl

Line 2811: , p_init_msg_list => FND_API.G_TRUE

2807: -- Call Oe_Order_Pvt.Process_order
2808:
2809: Oe_Order_Pvt.Lines
2810: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
2811: , p_init_msg_list => FND_API.G_TRUE
2812: , p_control_rec => l_control_rec
2813: , p_x_line_tbl => l_x_line_tbl
2814: , p_x_old_line_tbl => l_x_old_line_tbl
2815: , x_return_status => l_return_status

Line 2820: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2816:
2817: );
2818:
2819:
2820: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2822: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2823: RAISE FND_API.G_EXC_ERROR;
2824: END IF;

Line 2821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2817: );
2818:
2819:
2820: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2822: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2823: RAISE FND_API.G_EXC_ERROR;
2824: END IF;
2825:

Line 2822: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2818:
2819:
2820: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2822: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2823: RAISE FND_API.G_EXC_ERROR;
2824: END IF;
2825:
2826: -- Re-set the UI flag to FALSE

Line 2823: RAISE FND_API.G_EXC_ERROR;

2819:
2820: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2822: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2823: RAISE FND_API.G_EXC_ERROR;
2824: END IF;
2825:
2826: -- Re-set the UI flag to FALSE
2827: OE_GLOBALS.G_UI_FLAG := FALSE;

Line 2835: x_return_status := FND_API.G_RET_STS_SUCCESS;

2831: Clear_line;
2832:
2833: -- Set return status.
2834:
2835: x_return_status := FND_API.G_RET_STS_SUCCESS;
2836:
2837: -- Get message count and data
2838:
2839: oe_msg_pub.count_and_get

Line 2850: WHEN FND_API.G_EXC_ERROR THEN

2846: END IF;
2847:
2848: EXCEPTION
2849:
2850: WHEN FND_API.G_EXC_ERROR THEN
2851: ROLLBACK TO SAVEPOINT Line_Delete;
2852: OE_GLOBALS.G_UI_FLAG := FALSE;
2853:
2854: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2854: x_return_status := FND_API.G_RET_STS_ERROR;

2850: WHEN FND_API.G_EXC_ERROR THEN
2851: ROLLBACK TO SAVEPOINT Line_Delete;
2852: OE_GLOBALS.G_UI_FLAG := FALSE;
2853:
2854: x_return_status := FND_API.G_RET_STS_ERROR;
2855:
2856: -- Get message count and data
2857:
2858: oe_msg_pub.count_and_get

Line 2863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2859: ( p_count => x_msg_count
2860: , p_data => x_msg_data
2861: );
2862:
2863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2864: ROLLBACK TO SAVEPOINT Line_Delete;
2865:
2866: OE_GLOBALS.G_UI_FLAG := FALSE;
2867:

Line 2868: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2864: ROLLBACK TO SAVEPOINT Line_Delete;
2865:
2866: OE_GLOBALS.G_UI_FLAG := FALSE;
2867:
2868: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2869:
2870: -- Get message count and data
2871:
2872: oe_msg_pub.count_and_get

Line 2882: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2878: ROLLBACK TO SAVEPOINT Line_Delete;
2879:
2880: OE_GLOBALS.G_UI_FLAG := FALSE;
2881:
2882: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2883:
2884: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2885: THEN
2886: oe_msg_pub.Add_Exc_Msg

Line 2969: , p_init_msg_list => FND_API.G_TRUE

2965: -- Call Oe_Order_Pvt.Process_order
2966:
2967: Oe_Order_Pvt.Process_order
2968: ( p_api_version_number => 1.0
2969: , p_init_msg_list => FND_API.G_TRUE
2970: , x_return_status => l_return_status
2971: , x_msg_count => x_msg_count
2972: , x_msg_data => x_msg_data
2973: , p_control_rec => l_control_rec

Line 2996: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2992: , p_x_action_request_tbl => l_x_Action_Request_tbl
2993: , p_x_lot_serial_tbl => l_x_lot_serial_tbl
2994: );
2995:
2996: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2998: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2999: RAISE FND_API.G_EXC_ERROR;
3000: END IF;

Line 2997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2993: , p_x_lot_serial_tbl => l_x_lot_serial_tbl
2994: );
2995:
2996: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2998: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2999: RAISE FND_API.G_EXC_ERROR;
3000: END IF;
3001:

Line 2998: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2994: );
2995:
2996: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2998: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2999: RAISE FND_API.G_EXC_ERROR;
3000: END IF;
3001:
3002: -- Re-set the UI flag to FALSE

Line 2999: RAISE FND_API.G_EXC_ERROR;

2995:
2996: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2998: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2999: RAISE FND_API.G_EXC_ERROR;
3000: END IF;
3001:
3002: -- Re-set the UI flag to FALSE
3003: OE_GLOBALS.G_UI_FLAG := FALSE;

Line 3007: x_return_status := FND_API.G_RET_STS_SUCCESS;

3003: OE_GLOBALS.G_UI_FLAG := FALSE;
3004:
3005: -- Set return status.
3006:
3007: x_return_status := FND_API.G_RET_STS_SUCCESS;
3008:
3009: -- Get message count and data
3010:
3011: oe_msg_pub.count_and_get

Line 3022: WHEN FND_API.G_EXC_ERROR THEN

3018: END IF;
3019:
3020: EXCEPTION
3021:
3022: WHEN FND_API.G_EXC_ERROR THEN
3023:
3024: OE_GLOBALS.G_UI_FLAG := FALSE;
3025:
3026: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3026: x_return_status := FND_API.G_RET_STS_ERROR;

3022: WHEN FND_API.G_EXC_ERROR THEN
3023:
3024: OE_GLOBALS.G_UI_FLAG := FALSE;
3025:
3026: x_return_status := FND_API.G_RET_STS_ERROR;
3027:
3028: -- Get message count and data
3029:
3030: oe_msg_pub.count_and_get

Line 3035: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3031: ( p_count => x_msg_count
3032: , p_data => x_msg_data
3033: );
3034:
3035: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3036:
3037: OE_GLOBALS.G_UI_FLAG := FALSE;
3038:
3039: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 3039: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3035: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3036:
3037: OE_GLOBALS.G_UI_FLAG := FALSE;
3038:
3039: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3040:
3041: -- Get message count and data
3042:
3043: oe_msg_pub.count_and_get

Line 3052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3048: WHEN OTHERS THEN
3049:
3050: OE_GLOBALS.G_UI_FLAG := FALSE;
3051:
3052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3053:
3054: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
3055: THEN
3056: oe_msg_pub.Add_Exc_Msg

Line 3110: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

3106: ( x_return_status => l_return_status
3107: , p_x_line_rec => l_x_line_rec
3108: , p_line_id => p_line_id);
3109:
3110: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
3111:
3112: -- Set DB flag and write record to cache.
3113:
3114: l_x_line_rec.db_flag := FND_API.G_TRUE;

Line 3114: l_x_line_rec.db_flag := FND_API.G_TRUE;

3110: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
3111:
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:

Line 3129: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3125:
3126: -- Set return status.
3127:
3128: x_return_status := l_return_status;
3129: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3131: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3132: RAISE FND_API.G_EXC_ERROR;
3133: END IF;

Line 3130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3126: -- Set return status.
3127:
3128: x_return_status := l_return_status;
3129: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3131: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3132: RAISE FND_API.G_EXC_ERROR;
3133: END IF;
3134:

Line 3131: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3127:
3128: x_return_status := l_return_status;
3129: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3131: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3132: RAISE FND_API.G_EXC_ERROR;
3133: END IF;
3134:
3135: -- Get message count and data

Line 3132: RAISE FND_API.G_EXC_ERROR;

3128: x_return_status := l_return_status;
3129: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3131: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3132: RAISE FND_API.G_EXC_ERROR;
3133: END IF;
3134:
3135: -- Get message count and data
3136:

Line 3147: WHEN FND_API.G_EXC_ERROR 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
3148:
3149: OE_GLOBALS.G_UI_FLAG := FALSE;
3150:
3151: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3151: x_return_status := FND_API.G_RET_STS_ERROR;

3147: WHEN FND_API.G_EXC_ERROR THEN
3148:
3149: OE_GLOBALS.G_UI_FLAG := FALSE;
3150:
3151: x_return_status := FND_API.G_RET_STS_ERROR;
3152:
3153: -- Get message count and data
3154:
3155: oe_msg_pub.count_and_get

Line 3160: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3156: ( p_count => x_msg_count
3157: , p_data => x_msg_data
3158: );
3159:
3160: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3161:
3162: OE_GLOBALS.G_UI_FLAG := FALSE;
3163:
3164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 3164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3160: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3161:
3162: OE_GLOBALS.G_UI_FLAG := FALSE;
3163:
3164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3165:
3166: -- Get message count and data
3167:
3168: oe_msg_pub.count_and_get

Line 3183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3179: , 'Lock_Row'
3180: );
3181: END IF;
3182:
3183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3184:
3185: -- Get message count and data
3186:
3187: oe_msg_pub.count_and_get

Line 3242: IF p_line_id <> NVL(g_line_rec.line_id,FND_API.G_MISS_NUM)

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
3242: IF p_line_id <> NVL(g_line_rec.line_id,FND_API.G_MISS_NUM)
3243: THEN
3244:
3245: -- Query row from DB
3246: IF l_debug_level > 0 THEN

Line 3255: g_line_rec.db_flag := FND_API.G_TRUE;

3251: ( p_line_id => p_line_id,
3252: x_line_rec =>g_line_rec
3253: );
3254:
3255: g_line_rec.db_flag := FND_API.G_TRUE;
3256:
3257: -- Load DB record
3258:
3259: g_db_line_rec := g_line_rec;

Line 4803: p_line_rec.charge_periodicity_code <> FND_API.G_MISS_CHAR AND

4799: x_blanket_agr_name => x_line_val_rec.blanket_agreement_name);
4800: END If;
4801: --{ recurring charges
4802: /* IF p_line_rec.charge_periodicity_code IS NOT NULL AND
4803: p_line_rec.charge_periodicity_code <> FND_API.G_MISS_CHAR AND
4804: OE_SYS_PARAMETERS.Value('RECURRING_CHARGES',p_line_rec.org_id) = 'Y' THEN
4805:
4806: SELECT unit_of_measure
4807: INTO l_charge_periodicity

Line 5549: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5545: ( x_return_status => l_return_status
5546: , p_x_line_rec => l_x_line_tbl(i)
5547: , p_line_id => x_line_tbl_type(i).line_id);
5548:
5549: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5551: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5552: RAISE FND_API.G_EXC_ERROR;
5553: END IF;

Line 5550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5546: , p_x_line_rec => l_x_line_tbl(i)
5547: , p_line_id => x_line_tbl_type(i).line_id);
5548:
5549: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5551: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5552: RAISE FND_API.G_EXC_ERROR;
5553: END IF;
5554:

Line 5551: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

5547: , p_line_id => x_line_tbl_type(i).line_id);
5548:
5549: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5551: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5552: RAISE FND_API.G_EXC_ERROR;
5553: END IF;
5554:
5555: IF l_debug_level > 0 THEN

Line 5552: RAISE FND_API.G_EXC_ERROR;

5548:
5549: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5551: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
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 ) ;

Line 5599: , p_init_msg_list => FND_API.G_TRUE

5595: END IF;
5596:
5597: Oe_Order_Pvt.Process_order
5598: ( p_api_version_number => 1.0
5599: , p_init_msg_list => FND_API.G_TRUE
5600: , x_return_status => l_return_status
5601: , x_msg_count => x_msg_count
5602: , x_msg_data => x_msg_data
5603: , p_control_rec => l_control_rec

Line 5632: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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;
5634: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5635: RAISE FND_API.G_EXC_ERROR;
5636: END IF;

Line 5633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
5634: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5635: RAISE FND_API.G_EXC_ERROR;
5636: END IF;
5637:

Line 5634: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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;
5634: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5635: RAISE FND_API.G_EXC_ERROR;
5636: END IF;
5637:
5638:

Line 5635: RAISE FND_API.G_EXC_ERROR;

5631:
5632: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5634: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5635: RAISE FND_API.G_EXC_ERROR;
5636: END IF;
5637:
5638:
5639: IF l_x_line_tbl.count>0 THEN

Line 5665: l_line_tbl(i).split_action_code:=fnd_api.g_miss_char;

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;
5666: l_line_tbl(i).line_id:=l_x_line_tbl(i).line_id;
5667: l_line_tbl(i).header_id:=l_x_line_tbl(i).header_id;
5668:
5669: IF x_line_tbl_type(i).ship_from_org_id is not null THEN

Line 5753: l_line_tbl(l_rec_count).split_action_code := fnd_api.g_miss_char;

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;
5754: l_line_tbl(l_rec_count).line_id := l_x_line_tbl(i).line_id;
5755: l_line_tbl(l_rec_count).header_id := l_x_line_tbl(i).header_id;
5756:
5757: l_rec_count := l_rec_count + 1;

Line 5784: , p_init_msg_list => FND_API.G_TRUE

5780:
5781: IF l_process_add_attributes THEN
5782: Oe_Order_Pvt.Process_order
5783: ( p_api_version_number => 1.0
5784: , p_init_msg_list => FND_API.G_TRUE
5785: , x_return_status => l_return_status
5786: , x_msg_count => x_msg_count
5787: , x_msg_data => x_msg_data
5788: , p_control_rec => l_control_rec

Line 5814: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5810: );
5811:
5812:
5813: END IF;
5814: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5816: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5817: RAISE FND_API.G_EXC_ERROR;
5818: END IF;

Line 5815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5811:
5812:
5813: END IF;
5814: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5816: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5817: RAISE FND_API.G_EXC_ERROR;
5818: END IF;
5819:

Line 5816: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

5812:
5813: END IF;
5814: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5816: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5817: RAISE FND_API.G_EXC_ERROR;
5818: END IF;
5819:
5820: END IF;

Line 5817: RAISE FND_API.G_EXC_ERROR;

5813: END IF;
5814: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5816: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5817: RAISE FND_API.G_EXC_ERROR;
5818: END IF;
5819:
5820: END IF;
5821: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5821: x_return_status := FND_API.G_RET_STS_SUCCESS;

5817: RAISE FND_API.G_EXC_ERROR;
5818: END IF;
5819:
5820: END IF;
5821: x_return_status := FND_API.G_RET_STS_SUCCESS;
5822:
5823: -- Get message count and data
5824:
5825: oe_msg_pub.count_and_get

Line 5832: WHEN FND_API.G_EXC_ERROR THEN

5828: );
5829:
5830: EXCEPTION
5831:
5832: WHEN FND_API.G_EXC_ERROR THEN
5833:
5834: x_return_status := FND_API.G_RET_STS_ERROR;
5835:
5836: -- Get message count and data

Line 5834: x_return_status := FND_API.G_RET_STS_ERROR;

5830: EXCEPTION
5831:
5832: WHEN FND_API.G_EXC_ERROR THEN
5833:
5834: x_return_status := FND_API.G_RET_STS_ERROR;
5835:
5836: -- Get message count and data
5837:
5838: oe_msg_pub.count_and_get

Line 5843: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5839: ( p_count => x_msg_count
5840: , p_data => x_msg_data
5841: );
5842:
5843: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5844:
5845: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5846:
5847: -- Get message count and data

Line 5845: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

5841: );
5842:
5843: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5844:
5845: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5846:
5847: -- Get message count and data
5848:
5849: oe_msg_pub.count_and_get

Line 5856: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

5852: );
5853:
5854: WHEN OTHERS THEN
5855:
5856: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5857:
5858: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
5859: THEN
5860: oe_msg_pub.Add_Exc_Msg

Line 5895: x_return_status := FND_API.G_RET_STS_SUCCESS;

5891: l_index NUMBER; --3445778 */
5892: l_header_id NUMBER;
5893: BEGIN
5894: OE_MSG_PUB.initialize;
5895: x_return_status := FND_API.G_RET_STS_SUCCESS;
5896:
5897: -- Bug 3800577
5898: -- Clear versioning globals if request was not logged. If request was
5899: -- logged, that indicates that a change on another record had logged the

Line 5919: l_return_status := FND_API.G_RET_STS_ERROR;

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;
5922: END IF;
5923:

Line 5998: x_return_status := FND_API.G_RET_STS_ERROR;

5994: OE_MSG_PUB.Count_And_Get
5995: ( p_count => x_msg_count
5996: , p_data => x_msg_data
5997: );
5998: x_return_status := FND_API.G_RET_STS_ERROR;
5999:
6000: END Clear_Record;
6001:
6002: FUNCTION Get_Date_Type

Line 6132: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6128: , 'Get_Line_Shipment_Number'
6129: );
6130: END IF;
6131:
6132: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6133:
6134: END GET_LINE_SHIPMENT_NUMBER;
6135:
6136:

Line 6221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6217: , 'GET_ORDERED_ITEM'
6218: );
6219: END IF;
6220:
6221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6222:
6223: END GET_ORDERED_ITEM;
6224: /*--- Bug 1823073 end----- */
6225: