299: x_return_status := FND_API.G_RET_STS_SUCCESS;
300:
301: -- Get message count and data
302:
303: oe_msg_pub.count_and_get
304: ( p_count => x_msg_count
305: , p_data => x_msg_data
306: );
307:
318: x_return_status := FND_API.G_RET_STS_ERROR;
319:
320: -- Get message count and data
321:
322: oe_msg_pub.count_and_get
323: ( p_count => x_msg_count
324: , p_data => x_msg_data
325: );
326:
331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
332:
333: -- Get message count and data
334:
335: oe_msg_pub.count_and_get
336: ( p_count => x_msg_count
337: , p_data => x_msg_data
338: );
339:
342: OE_GLOBALS.G_UI_FLAG := FALSE;
343:
344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
345:
346: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
347: THEN
348: oe_msg_pub.Add_Exc_Msg
349: ( G_PKG_NAME
350: , 'Default_Attributes' || l_error
344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
345:
346: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
347: THEN
348: oe_msg_pub.Add_Exc_Msg
349: ( G_PKG_NAME
350: , 'Default_Attributes' || l_error
351: );
352: END IF;
352: END IF;
353:
354: -- Get message count and data
355:
356: oe_msg_pub.count_and_get
357: ( p_count => x_msg_count
358: , p_data => x_msg_data
359: );
360:
1104: END IF;
1105:
1106: -- Unexpected error, unrecognized attribute
1107:
1108: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1109: THEN
1110: oe_msg_pub.Add_Exc_Msg
1111: ( G_PKG_NAME
1112: , 'Change_Attribute'
1106: -- Unexpected error, unrecognized attribute
1107:
1108: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1109: THEN
1110: oe_msg_pub.Add_Exc_Msg
1111: ( G_PKG_NAME
1112: , 'Change_Attribute'
1113: , 'Unrecognized attribute'
1114: );
1120:
1121:
1122: EXCEPTION
1123: WHEN OTHERS THEN
1124: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1125: THEN
1126: oe_msg_pub.Add_Exc_Msg
1127: ( G_PKG_NAME
1128: , 'Copy_Attribute_To_Rec'
1122: EXCEPTION
1123: WHEN OTHERS THEN
1124: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1125: THEN
1126: oe_msg_pub.Add_Exc_Msg
1127: ( G_PKG_NAME
1128: , 'Copy_Attribute_To_Rec'
1129: );
1130: END IF;
2015: END IF;
2016:
2017: -- Unexpected error, unrecognized attribute
2018:
2019: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2020: THEN
2021: oe_msg_pub.Add_Exc_Msg
2022: ( G_PKG_NAME
2023: , 'Change_Attribute'
2017: -- Unexpected error, unrecognized attribute
2018:
2019: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2020: THEN
2021: oe_msg_pub.Add_Exc_Msg
2022: ( G_PKG_NAME
2023: , 'Change_Attribute'
2024: , 'Unrecognized attribute'
2025: );
2062:
2063: IF nvl(l_order_date_type_code,'SHIP') = 'ARRIVAL' THEN
2064:
2065: FND_MESSAGE.SET_NAME('ONT','OE_SCH_INV_SHP_DATE');
2066: OE_MSG_PUB.Add;
2067:
2068: l_return_status := FND_API.G_RET_STS_ERROR;
2069:
2070: END IF;
2094:
2095: IF nvl(l_order_date_type_code,'SHIP') = 'SHIP' THEN
2096:
2097: FND_MESSAGE.SET_NAME('ONT','OE_SCH_INV_ARR_DATE');
2098: OE_MSG_PUB.Add;
2099:
2100: l_return_status := FND_API.G_RET_STS_ERROR;
2101:
2102: END IF;
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;
2129: RAISE FND_API.G_EXC_ERROR;
2130: END IF;
2131: -- end for 3998402
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;
2152: RAISE FND_API.G_EXC_ERROR;
2153: END IF;
2154: END IF;
2243: x_return_status := FND_API.G_RET_STS_SUCCESS;
2244:
2245: -- Get message count and data
2246:
2247: oe_msg_pub.count_and_get
2248: ( p_count => x_msg_count
2249: , p_data => x_msg_data
2250: );
2251:
2262: x_return_status := FND_API.G_RET_STS_ERROR;
2263:
2264: -- Get message count and data
2265:
2266: oe_msg_pub.count_and_get
2267: ( p_count => x_msg_count
2268: , p_data => x_msg_data
2269: );
2270:
2275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2276:
2277: -- Get message count and data
2278:
2279: oe_msg_pub.count_and_get
2280: ( p_count => x_msg_count
2281: , p_data => x_msg_data
2282: );
2283:
2286: OE_GLOBALS.G_UI_FLAG := FALSE;
2287:
2288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2289:
2290: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2291: THEN
2292: oe_msg_pub.Add_Exc_Msg
2293: ( G_PKG_NAME
2294: , 'Change_Attribute'
2288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2289:
2290: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2291: THEN
2292: oe_msg_pub.Add_Exc_Msg
2293: ( G_PKG_NAME
2294: , 'Change_Attribute'
2295: );
2296: END IF;
2296: END IF;
2297:
2298: -- Get message count and data
2299:
2300: oe_msg_pub.count_and_get
2301: ( p_count => x_msg_count
2302: , p_data => x_msg_data
2303: );
2304:
2713: x_return_status := FND_API.G_RET_STS_SUCCESS;
2714:
2715: -- Get message count and data
2716:
2717: oe_msg_pub.count_and_get
2718: ( p_count => x_msg_count
2719: , p_data => x_msg_data
2720: );
2721:
2749: x_return_status := FND_API.G_RET_STS_ERROR;
2750:
2751: -- Get message count and data
2752:
2753: oe_msg_pub.count_and_get
2754: ( p_count => x_msg_count
2755: , p_data => x_msg_data
2756: );
2757:
2769: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2770:
2771: -- Get message count and data
2772:
2773: oe_msg_pub.count_and_get
2774: ( p_count => x_msg_count
2775: , p_data => x_msg_data
2776: );
2777:
2787: OE_GLOBALS.G_START_LINE_FLOWS_TBL.delete(l_last_index);
2788: END IF;
2789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2790:
2791: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2792: THEN
2793: oe_msg_pub.Add_Exc_Msg
2794: ( G_PKG_NAME
2795: , 'Validate_And_Write'
2789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2790:
2791: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2792: THEN
2793: oe_msg_pub.Add_Exc_Msg
2794: ( G_PKG_NAME
2795: , 'Validate_And_Write'
2796: );
2797: END IF;
2797: END IF;
2798:
2799: -- Get message count and data
2800:
2801: oe_msg_pub.count_and_get
2802: ( p_count => x_msg_count
2803: , p_data => x_msg_data
2804: );
2805:
2899: x_return_status := FND_API.G_RET_STS_SUCCESS;
2900:
2901: -- Get message count and data
2902:
2903: oe_msg_pub.count_and_get
2904: ( p_count => x_msg_count
2905: , p_data => x_msg_data
2906: );
2907:
2918: x_return_status := FND_API.G_RET_STS_ERROR;
2919:
2920: -- Get message count and data
2921:
2922: oe_msg_pub.count_and_get
2923: ( p_count => x_msg_count
2924: , p_data => x_msg_data
2925: );
2926:
2932: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2933:
2934: -- Get message count and data
2935:
2936: oe_msg_pub.count_and_get
2937: ( p_count => x_msg_count
2938: , p_data => x_msg_data
2939: );
2940:
2944: OE_GLOBALS.G_UI_FLAG := FALSE;
2945:
2946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2947:
2948: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2949: THEN
2950: oe_msg_pub.Add_Exc_Msg
2951: ( G_PKG_NAME
2952: , 'Delete_Row'
2946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2947:
2948: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2949: THEN
2950: oe_msg_pub.Add_Exc_Msg
2951: ( G_PKG_NAME
2952: , 'Delete_Row'
2953: );
2954: END IF;
2954: END IF;
2955:
2956: -- Get message count and data
2957:
2958: oe_msg_pub.count_and_get
2959: ( p_count => x_msg_count
2960: , p_data => x_msg_data
2961: );
2962:
3071: x_return_status := FND_API.G_RET_STS_SUCCESS;
3072:
3073: -- Get message count and data
3074:
3075: oe_msg_pub.count_and_get
3076: ( p_count => x_msg_count
3077: , p_data => x_msg_data
3078: );
3079:
3090: x_return_status := FND_API.G_RET_STS_ERROR;
3091:
3092: -- Get message count and data
3093:
3094: oe_msg_pub.count_and_get
3095: ( p_count => x_msg_count
3096: , p_data => x_msg_data
3097: );
3098:
3103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3104:
3105: -- Get message count and data
3106:
3107: oe_msg_pub.count_and_get
3108: ( p_count => x_msg_count
3109: , p_data => x_msg_data
3110: );
3111:
3114: OE_GLOBALS.G_UI_FLAG := FALSE;
3115:
3116: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3117:
3118: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
3119: THEN
3120: oe_msg_pub.Add_Exc_Msg
3121: ( G_PKG_NAME
3122: , 'Process_Entity'
3116: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3117:
3118: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
3119: THEN
3120: oe_msg_pub.Add_Exc_Msg
3121: ( G_PKG_NAME
3122: , 'Process_Entity'
3123: );
3124: END IF;
3124: END IF;
3125:
3126: -- Get message count and data
3127:
3128: oe_msg_pub.count_and_get
3129: ( p_count => x_msg_count
3130: , p_data => x_msg_data
3131: );
3132:
3164: --Bug 3025978
3165: OE_GLOBALS.G_UI_FLAG := TRUE;
3166:
3167: -- Call OE_Line_Util.Lock_Row instead of Oe_Order_Pvt.Lock_order
3168: OE_MSG_PUB.initialize;
3169: OE_Line_Util.Lock_Row
3170: ( x_return_status => l_return_status
3171: , p_x_line_rec => l_x_line_rec
3172: , p_line_id => p_line_id);
3197: END IF;
3198:
3199: -- Get message count and data
3200:
3201: oe_msg_pub.count_and_get
3202: ( p_count => x_msg_count
3203: , p_data => x_msg_data
3204: );
3205:
3215: x_return_status := FND_API.G_RET_STS_ERROR;
3216:
3217: -- Get message count and data
3218:
3219: oe_msg_pub.count_and_get
3220: ( p_count => x_msg_count
3221: , p_data => x_msg_data
3222: );
3223:
3228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3229:
3230: -- Get message count and data
3231:
3232: oe_msg_pub.count_and_get
3233: ( p_count => x_msg_count
3234: , p_data => x_msg_data
3235: );
3236:
3235: );
3236:
3237: WHEN OTHERS THEN
3238:
3239: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
3240: THEN
3241: oe_msg_pub.Add_Exc_Msg
3242: ( G_PKG_NAME
3243: , 'Lock_Row'
3237: WHEN OTHERS THEN
3238:
3239: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
3240: THEN
3241: oe_msg_pub.Add_Exc_Msg
3242: ( G_PKG_NAME
3243: , 'Lock_Row'
3244: );
3245: END IF;
3247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3248:
3249: -- Get message count and data
3250:
3251: oe_msg_pub.count_and_get
3252: ( p_count => x_msg_count
3253: , p_data => x_msg_data
3254: );
3255:
6169: x_return_status := FND_API.G_RET_STS_SUCCESS;
6170:
6171: -- Get message count and data
6172:
6173: oe_msg_pub.count_and_get
6174: ( p_count => x_msg_count
6175: , p_data => x_msg_data
6176: );
6177:
6182: x_return_status := FND_API.G_RET_STS_ERROR;
6183:
6184: -- Get message count and data
6185:
6186: oe_msg_pub.count_and_get
6187: ( p_count => x_msg_count
6188: , p_data => x_msg_data
6189: );
6190:
6193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6194:
6195: -- Get message count and data
6196:
6197: oe_msg_pub.count_and_get
6198: ( p_count => x_msg_count
6199: , p_data => x_msg_data
6200: );
6201:
6202: WHEN OTHERS THEN
6203:
6204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6205:
6206: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
6207: THEN
6208: oe_msg_pub.Add_Exc_Msg
6209: ( G_PKG_NAME
6210: , 'Split Lines'
6204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6205:
6206: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
6207: THEN
6208: oe_msg_pub.Add_Exc_Msg
6209: ( G_PKG_NAME
6210: , 'Split Lines'
6211: );
6212: END IF;
6212: END IF;
6213:
6214: -- Get message count and data
6215:
6216: oe_msg_pub.count_and_get
6217: ( p_count => x_msg_count
6218: , p_data => x_msg_data
6219: );
6220:
6238: l_old_line_rec OE_Order_PUB.Line_Rec_Type; --3445778
6239: l_index NUMBER; --3445778 */
6240: l_header_id NUMBER;
6241: BEGIN
6242: OE_MSG_PUB.initialize;
6243: x_return_status := FND_API.G_RET_STS_SUCCESS;
6244:
6245: -- Bug 3800577
6246: -- Clear versioning globals if request was not logged. If request was
6317:
6318: --Close for bug #6059554--
6319:
6320:
6321: OE_MSG_PUB.Count_And_Get
6322: ( p_count => x_msg_count
6323: , p_data => x_msg_data
6324: );
6325:
6330: Clear_line;
6331:
6332: EXCEPTION
6333: WHEN OTHERS THEN
6334: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6335: THEN
6336: OE_MSG_PUB.Add_Exc_Msg
6337: ( G_PKG_NAME
6338: , 'Clear_Record'
6332: EXCEPTION
6333: WHEN OTHERS THEN
6334: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6335: THEN
6336: OE_MSG_PUB.Add_Exc_Msg
6337: ( G_PKG_NAME
6338: , 'Clear_Record'
6339: );
6340: END IF;
6338: , 'Clear_Record'
6339: );
6340: END IF;
6341: -- Get message count and data
6342: OE_MSG_PUB.Count_And_Get
6343: ( p_count => x_msg_count
6344: , p_data => x_msg_data
6345: );
6346: x_return_status := FND_API.G_RET_STS_ERROR;
6487: EXCEPTION
6488:
6489: WHEN OTHERS THEN
6490:
6491: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6492: THEN
6493: OE_MSG_PUB.Add_Exc_Msg
6494: ( G_PKG_NAME
6495: , 'Get_Line_Shipment_Number'
6489: WHEN OTHERS THEN
6490:
6491: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6492: THEN
6493: OE_MSG_PUB.Add_Exc_Msg
6494: ( G_PKG_NAME
6495: , 'Get_Line_Shipment_Number'
6496: );
6497: END IF;
6601: EXCEPTION
6602:
6603: WHEN OTHERS THEN
6604:
6605: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6606: THEN
6607: OE_MSG_PUB.Add_Exc_Msg
6608: ( G_PKG_NAME
6609: , 'GET_ORDERED_ITEM'
6603: WHEN OTHERS THEN
6604:
6605: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6606: THEN
6607: OE_MSG_PUB.Add_Exc_Msg
6608: ( G_PKG_NAME
6609: , 'GET_ORDERED_ITEM'
6610: );
6611: END IF;