[Home] [Help]
565: END LOOP;
566:
567: wf_engine.threshold := l_rel_threshold;
568: x_return_status := FND_API.G_RET_STS_SUCCESS;
569: Oe_msg_pub.Count_And_Get
570: ( p_count => x_msg_count
571: ,p_data => x_msg_data
572: );
573: RETURN;
725: END LOOP;
726:
727: wf_engine.threshold := l_rel_threshold;
728: x_return_status := FND_API.G_RET_STS_SUCCESS;
729: Oe_msg_pub.Count_And_Get
730: ( p_count => x_msg_count
731: ,p_data => x_msg_data
732: );
733:
735: WHEN OTHERS THEN
736: Oe_debug_pub.ADD('Failed from progress order.');
737: wf_engine.threshold := l_rel_threshold;
738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
739: Oe_msg_pub.Count_And_Get
740: ( p_count => x_msg_count
741: ,p_data => x_msg_data
742: );
743: ROLLBACK TO progress_order;
936: END LOOP;
937:
938: wf_engine.threshold := l_rel_threshold;
939: x_return_status := FND_API.G_RET_STS_SUCCESS;
940: Oe_msg_pub.Count_And_Get
941: ( p_count => x_msg_count
942: ,p_data => x_msg_data
943: );
944:
946: WHEN OTHERS THEN
947: OE_debug_pub.ADD('Failed from progress order');
948: wf_engine.threshold := l_rel_threshold;
949: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
950: Oe_msg_pub.Count_And_Get
951: ( p_count => x_msg_count
952: ,p_data => x_msg_data
953: );
954: ROLLBACK TO progress_order;
1236: AND lookup_code = p_activity_name;
1237:
1238: FND_MESSAGE.SET_NAME('ONT', 'OE_NO_HOLD_ALL_LINES');
1239: FND_MESSAGE.SET_TOKEN('WF_ACT', l_user_activity_name);
1240: OE_MSG_PUB.ADD;
1241: OE_DEBUG_PUB.ADD(' Hold Not applied for All requested records');
1242: RAISE FND_API.G_EXC_ERROR;
1243:
1244: ELSIF l_sql_rowcount > 0 THEN
1274: AND lookup_code = p_activity_name;
1275:
1276: FND_MESSAGE.SET_NAME('ONT', 'OE_NO_HOLD_FEW_LINES');
1277: FND_MESSAGE.SET_TOKEN('WF_ACT', l_user_activity_name);
1278: OE_MSG_PUB.ADD;
1279: OE_DEBUG_PUB.ADD(' Hold Not applied for FEW of the requested records');
1280: END IF;
1281: END IF;
1282: END IF;
1536: AND lookup_code = p_activity_name;
1537:
1538: FND_MESSAGE.SET_NAME('ONT', 'OE_NO_HOLD_ALL_LINES');
1539: FND_MESSAGE.SET_TOKEN('WF_ACT',l_user_activity_name);
1540: OE_MSG_PUB.ADD;
1541: OE_DEBUG_PUB.ADD(' Hold Not applied for All requested records');
1542: RAISE FND_API.G_EXC_ERROR;
1543:
1544: ELSIF l_sql_rowcount > 0 THEN
1574: AND lookup_code = p_activity_name;
1575:
1576: FND_MESSAGE.SET_NAME('ONT', 'OE_NO_HOLD_FEW_LINES');
1577: FND_MESSAGE.SET_TOKEN('WF_ACT',l_user_activity_name);
1578: OE_MSG_PUB.ADD;
1579: OE_DEBUG_PUB.ADD(' Hold Not applied for FEW of the requested records');
1580: END IF;
1581: END IF;
1582: END IF;
2199: p_hold_source_rec.line_id IS NOT NULL) OR
2200: p_hold_source_rec.hold_entity_code2 IS NOT NULL THEN
2201: oe_debug_pub.add('Error: Order WF Hold, being applied at Line Level');
2202: FND_MESSAGE.SET_NAME('ONT','OE_ORDER_HOLD_INVALID_CRITERIA');
2203: OE_MSG_PUB.ADD;
2204: RAISE FND_API.G_EXC_ERROR;
2205: END IF;
2206: ELSIF l_item_type = 'OEOL' THEN
2207: IF p_hold_source_rec.hold_entity_code IN ('C','O') AND
2208: p_hold_source_rec.line_id IS NULL AND
2209: l_apply_to_flag = 'N' THEN
2210: oe_debug_pub.add('Error: Line WF Hold, being applied at Order Level');
2211: FND_MESSAGE.SET_NAME('ONT','OE_LINE_HOLD_INVALID_CRITERIA');
2212: OE_MSG_PUB.ADD;
2213: RAISE FND_API.G_EXC_ERROR;
2214: END IF;
2215: END IF;
2216: ER#7479609*/
2238: oe_debug_pub.add('Order WF HOLD');
2239: ELSIF l_item_type = 'OEOL' AND l_apply_to_flag = 'N' THEN
2240: oe_debug_pub.add('Error: Line WF Hold, being applied at Order Level');
2241: FND_MESSAGE.SET_NAME('ONT','OE_LINE_HOLD_INVALID_CRITERIA');
2242: OE_MSG_PUB.ADD;
2243: RAISE FND_API.G_EXC_ERROR;
2244: END IF;
2245: ELSE
2246: IF (p_hold_source_rec.hold_entity_code = 'P' and p_hold_source_rec.hold_entity_code2 IS NULL) THEN
2251: oe_debug_pub.add('Line WF HOLD');
2252: ELSIF l_item_type = 'OEOH' THEN
2253: oe_debug_pub.add('Error: Order WF Hold, being applied at Line Level');
2254: FND_MESSAGE.SET_NAME('ONT','OE_ORDER_HOLD_INVALID_CRITERIA');
2255: OE_MSG_PUB.ADD;
2256: RAISE FND_API.G_EXC_ERROR;
2257: END IF;
2258: END IF;
2259: END IF;
2268: --ER#7479609 if p_hold_source_rec.hold_entity_code2 not in ('C', 'S', 'B', 'W','H') then
2269: if p_hold_source_rec.hold_entity_code2 not in ('C', 'S', 'B', 'W','H','SM','D','PL','PR','ST','LT','CN','EC','EN') then --ER#7479609 --ER#11824468, added 'CN' --ER#12571983 added ,'EC','EN'
2270: OE_Debug_PUB.Add('Invalid Entity Combination',1);
2271: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ENTITY_CONBINATION');
2272: OE_MSG_PUB.ADD;
2273: RAISE FND_API.G_EXC_ERROR;
2274: end if;
2275: --ER# 13331078 start
2276: elsif p_hold_source_rec.hold_entity_code = 'IC' then
2276: elsif p_hold_source_rec.hold_entity_code = 'IC' then
2277: if p_hold_source_rec.hold_entity_code2 not in ('C', 'S', 'B', 'W','H','SM','D','PL','PR','ST','LT','CN','EC','EN') then --ER#11824468, added 'CN' --ER#12571983 added ,'EC','EN'
2278: OE_Debug_PUB.Add('Invalid Entity Combination',1);
2279: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ENTITY_CONBINATION');
2280: OE_MSG_PUB.ADD;
2281: RAISE FND_API.G_EXC_ERROR;
2282: end if;
2283: --ER# 13331078 end
2284: elsif p_hold_source_rec.hold_entity_code = 'W' then
2285: --ER#7479609 if p_hold_source_rec.hold_entity_code2 not in ('C', 'S', 'B') then
2286: if p_hold_source_rec.hold_entity_code2 not in ('C', 'S', 'B','LT','SM','D','ST','CN','EC','EN') then --ER#7479609 --ER#11824468, added 'CN' --ER#12571983 added ,'EC','EN'
2287: OE_Debug_PUB.Add('Invalid Entity Combination',1);
2288: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ENTITY_CONBINATION');
2289: OE_MSG_PUB.ADD;
2290: RAISE FND_API.G_EXC_ERROR;
2291: end if;
2292: elsif p_hold_source_rec.hold_entity_code = 'B' then
2293: if p_hold_source_rec.hold_entity_code2 not in ('O') then
2292: elsif p_hold_source_rec.hold_entity_code = 'B' then
2293: if p_hold_source_rec.hold_entity_code2 not in ('O') then
2294: OE_Debug_PUB.Add('Invalid Entity Combination',1);
2295: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ENTITY_CONBINATION');
2296: OE_MSG_PUB.ADD;
2297: RAISE FND_API.G_EXC_ERROR;
2298: end if;
2299: elsif p_hold_source_rec.hold_entity_code = 'H' then
2300: --ER#7479609 if p_hold_source_rec.hold_entity_code2 not in ('S', 'B', 'W', 'L') then
2300: --ER#7479609 if p_hold_source_rec.hold_entity_code2 not in ('S', 'B', 'W', 'L') then
2301: if p_hold_source_rec.hold_entity_code2 not in ('S', 'B', 'W', 'L','PL','PT','SM','D','LT') then --ER#7479609
2302: OE_Debug_PUB.Add('Invalid Entity Combination',1);
2303: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ENTITY_CONBINATION');
2304: OE_MSG_PUB.ADD;
2305: RAISE FND_API.G_EXC_ERROR;
2306: end if;
2307: --ER#7479609 start
2308: elsif p_hold_source_rec.hold_entity_code = 'TM' then
2308: elsif p_hold_source_rec.hold_entity_code = 'TM' then
2309: if p_hold_source_rec.hold_entity_code2 not in ('OI') then
2310: OE_Debug_PUB.Add('Invalid Entity Combination',1);
2311: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ENTITY_CONBINATION');
2312: OE_MSG_PUB.ADD;
2313: RAISE FND_API.G_EXC_ERROR;
2314: end if;
2315: elsif p_hold_source_rec.hold_entity_code = 'PR' then
2316: if p_hold_source_rec.hold_entity_code2 not in ('T') then
2315: elsif p_hold_source_rec.hold_entity_code = 'PR' then
2316: if p_hold_source_rec.hold_entity_code2 not in ('T') then
2317: OE_Debug_PUB.Add('Invalid Entity Combination',1);
2318: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ENTITY_CONBINATION');
2319: OE_MSG_PUB.ADD;
2320: RAISE FND_API.G_EXC_ERROR;
2321: end if;
2322: elsif p_hold_source_rec.hold_entity_code = 'C' then
2323: if p_hold_source_rec.hold_entity_code2 not in ('ST','B','S','D','PL','LT','PT','OT','P','TC','SC') then
2322: elsif p_hold_source_rec.hold_entity_code = 'C' then
2323: if p_hold_source_rec.hold_entity_code2 not in ('ST','B','S','D','PL','LT','PT','OT','P','TC','SC') then
2324: OE_Debug_PUB.Add('Invalid Entity Combination',1);
2325: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ENTITY_CONBINATION');
2326: OE_MSG_PUB.ADD;
2327: RAISE FND_API.G_EXC_ERROR;
2328: end if;
2329: --ER# 11824468 start
2330: elsif p_hold_source_rec.hold_entity_code = 'CN' then
2330: elsif p_hold_source_rec.hold_entity_code = 'CN' then
2331: if p_hold_source_rec.hold_entity_code2 not in ('ST','B','S','D','PL','LT','PT','OT','P','TC','SC') then
2332: OE_Debug_PUB.Add('Invalid Entity Combination',1);
2333: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ENTITY_CONBINATION');
2334: OE_MSG_PUB.ADD;
2335: RAISE FND_API.G_EXC_ERROR;
2336: end if;
2337: --ER# 11824468 end
2338: --ER#12571983 start
2339: elsif p_hold_source_rec.hold_entity_code IN('EC','EN') then
2340: if p_hold_source_rec.hold_entity_code2 not in ('ST','B','S','D','PL','LT','PT','OT','P','TC','SC','EL') then
2341: OE_Debug_PUB.Add('Invalid Entity Combination',1);
2342: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ENTITY_CONBINATION');
2343: OE_MSG_PUB.ADD;
2344: RAISE FND_API.G_EXC_ERROR;
2345: end if;
2346: --ER#12571983 end
2347: elsif p_hold_source_rec.hold_entity_code = 'PL' then
2347: elsif p_hold_source_rec.hold_entity_code = 'PL' then
2348: if p_hold_source_rec.hold_entity_code2 not in ('TC') then
2349: OE_Debug_PUB.Add('Invalid Entity Combination',1);
2350: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ENTITY_CONBINATION');
2351: OE_MSG_PUB.ADD;
2352: RAISE FND_API.G_EXC_ERROR;
2353: end if;
2354: elsif p_hold_source_rec.hold_entity_code = 'OT' then
2355: if p_hold_source_rec.hold_entity_code2 not in ('LT','TC') then
2354: elsif p_hold_source_rec.hold_entity_code = 'OT' then
2355: if p_hold_source_rec.hold_entity_code2 not in ('LT','TC') then
2356: OE_Debug_PUB.Add('Invalid Entity Combination',1);
2357: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ENTITY_CONBINATION');
2358: OE_MSG_PUB.ADD;
2359: RAISE FND_API.G_EXC_ERROR;
2360: end if;
2361: elsif p_hold_source_rec.hold_entity_code = 'CD' then
2362: if p_hold_source_rec.hold_entity_code2 not in ('CB') then
2361: elsif p_hold_source_rec.hold_entity_code = 'CD' then
2362: if p_hold_source_rec.hold_entity_code2 not in ('CB') then
2363: OE_Debug_PUB.Add('Invalid Entity Combination',1);
2364: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ENTITY_CONBINATION');
2365: OE_MSG_PUB.ADD;
2366: RAISE FND_API.G_EXC_ERROR;
2367: end if;
2368: --ER#7479609 end
2369: else
2506: --ER#7479609 end
2507: ELSE
2508: OE_Debug_PUB.Add('Invalid Entity Code');
2509: FND_MESSAGE.SET_NAME('ONT', 'OE_MISSING_ENTITY_CODE');
2510: OE_MSG_PUB.ADD;
2511: RAISE FND_API.G_EXC_ERROR;
2512: END IF;
2513:
2514: /*********************************
2667: --ER#7479609 end
2668: ELSE
2669: OE_Debug_PUB.Add('Invalid Second Entity Code');
2670: FND_MESSAGE.SET_NAME('ONT', 'OE_MISSING_ENTITY_CODE');
2671: OE_MSG_PUB.ADD;
2672: RAISE FND_API.G_EXC_ERROR;
2673: END IF;
2674: END IF;
2675: ------------------------------
2680: WHEN NO_DATA_FOUND THEN
2681: /* XXX Error message here */
2682: OE_Debug_PUB.Add('Hold Entity ID not found for entity',1);
2683: FND_MESSAGE.SET_NAME('ONT', 'OE_MISSING_ENTITY_ID');
2684: OE_MSG_PUB.ADD;
2685: RAISE FND_API.G_EXC_ERROR;
2686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2687: WHEN FND_API.G_EXC_ERROR THEN
2688: /*
2687: WHEN FND_API.G_EXC_ERROR THEN
2688: /*
2689: ** This message is not required.
2690: FND_MESSAGE.SET_NAME('ONT', 'OE_ENTITY_NOT_ON_ORDER_OR_LINE');
2691: OE_MSG_PUB.ADD;
2692: */
2693: OE_Debug_PUB.Add('Expected error in Validate_Hold_source',1);
2694: x_return_status := FND_API.G_RET_STS_ERROR;
2695: WHEN OTHERS THEN
2693: OE_Debug_PUB.Add('Expected error in Validate_Hold_source',1);
2694: x_return_status := FND_API.G_RET_STS_ERROR;
2695: WHEN OTHERS THEN
2696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2697: IF OE_MSG_PUB.Check_Msg_Level
2698: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2699: THEN
2700: OE_MSG_PUB.Add_Exc_Msg
2701: ( G_PKG_NAME
2694: x_return_status := FND_API.G_RET_STS_ERROR;
2695: WHEN OTHERS THEN
2696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2697: IF OE_MSG_PUB.Check_Msg_Level
2698: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2699: THEN
2700: OE_MSG_PUB.Add_Exc_Msg
2701: ( G_PKG_NAME
2702: , l_api_name
2696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2697: IF OE_MSG_PUB.Check_Msg_Level
2698: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2699: THEN
2700: OE_MSG_PUB.Add_Exc_Msg
2701: ( G_PKG_NAME
2702: , l_api_name
2703: );
2704: END IF;
2720:
2721: -- Check for Missing Values
2722: IF p_hold_id IS NULL THEN
2723: FND_MESSAGE.SET_NAME('ONT', 'OE_MISSING_HOLD_ID');
2724: OE_MSG_PUB.ADD;
2725: RAISE FND_API.G_EXC_ERROR;
2726: END IF;
2727:
2728:
2742: WHEN NO_DATA_FOUND THEN
2743: OE_Debug_PUB.Add('Invalid Hold ID'||to_char(p_hold_id),1);
2744: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_HOLD_ID');
2745: FND_MESSAGE.SET_TOKEN('HOLD_ID',p_hold_id);
2746: OE_MSG_PUB.ADD;
2747: x_return_status := FND_API.G_RET_STS_ERROR;
2748:
2749: END; -- Validate Hold ID
2750:
2808: OE_Debug_PUB.Add('Duplicate Hold Source for EntityID'||
2809: to_char(p_hold_source_rec.hold_entity_id) ,1);
2810: --FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD');
2811: FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD_SOURCE');
2812: OE_MSG_PUB.ADD;
2813: x_hold_exists := 'Y';
2814: RETURN;
2815: --RAISE FND_API.G_EXC_ERROR;
2816: END IF;
2839: OE_Debug_PUB.Add('Duplicate Hold Source for EntityID'||
2840: to_char(p_hold_source_rec.hold_entity_id) ,1);
2841: --FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD');
2842: FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD_SOURCE');
2843: OE_MSG_PUB.ADD;
2844: x_hold_exists := 'Y';
2845: RETURN;
2846: --RAISE FND_API.G_EXC_ERROR;
2847: END IF;
2867: OE_Debug_PUB.Add('Duplicate Hold Source for EntityID'||
2868: to_char(p_hold_source_rec.hold_entity_id) ,1);
2869: --FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD');
2870: FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD_SOURCE');
2871: OE_MSG_PUB.ADD;
2872: --RETURN;
2873: RAISE FND_API.G_EXC_ERROR;
2874: END IF;
2875: end if;
2966: EXCEPTION
2967: WHEN FND_API.G_EXC_ERROR THEN
2968: --ROLLBACK TO Create_Hold_Source;
2969: x_return_status := FND_API.G_RET_STS_ERROR;
2970: OE_MSG_PUB.Count_And_Get
2971: ( p_count => x_msg_count
2972: , p_data => x_msg_data
2973: );
2974: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2973: );
2974: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2975: --ROLLBACK TO Create_Hold_Source;
2976: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2977: OE_MSG_PUB.Count_And_Get
2978: ( p_count => x_msg_count
2979: , p_data => x_msg_data
2980: );
2981: WHEN OTHERS THEN
2980: );
2981: WHEN OTHERS THEN
2982: --ROLLBACK TO Create_Hold_Source;
2983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2984: IF OE_MSG_PUB.Check_Msg_Level
2985: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2986: THEN
2987: OE_MSG_PUB.Add_Exc_Msg
2988: ( G_PKG_NAME,
2981: WHEN OTHERS THEN
2982: --ROLLBACK TO Create_Hold_Source;
2983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2984: IF OE_MSG_PUB.Check_Msg_Level
2985: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2986: THEN
2987: OE_MSG_PUB.Add_Exc_Msg
2988: ( G_PKG_NAME,
2989: l_api_name);
2983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2984: IF OE_MSG_PUB.Check_Msg_Level
2985: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2986: THEN
2987: OE_MSG_PUB.Add_Exc_Msg
2988: ( G_PKG_NAME,
2989: l_api_name);
2990: END IF;
2991: OE_MSG_PUB.Count_And_Get
2987: OE_MSG_PUB.Add_Exc_Msg
2988: ( G_PKG_NAME,
2989: l_api_name);
2990: END IF;
2991: OE_MSG_PUB.Count_And_Get
2992: ( p_count => x_msg_count
2993: , p_data => x_msg_data
2994: );
2995: END Create_Hold_Source;
3049: OE_Debug_PUB.Add('Duplicate Hold Source for EntityID'||
3050: to_char(p_hold_source_rec.hold_entity_id) ,1);
3051: --FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD');
3052: FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD_SOURCE');
3053: OE_MSG_PUB.ADD;
3054: --RETURN;
3055: RAISE FND_API.G_EXC_ERROR;
3056: END IF;
3057: /* If Order Level Hold */
3078: OE_Debug_PUB.Add('Duplicate Hold Source for EntityID'||
3079: to_char(p_hold_source_rec.hold_entity_id) ,1);
3080: --FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD');
3081: FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD_SOURCE');
3082: OE_MSG_PUB.ADD;
3083: --RETURN;
3084: RAISE FND_API.G_EXC_ERROR;
3085: END IF;
3086:
3110: OE_Debug_PUB.Add('Duplicate Hold Source for EntityID'||
3111: to_char(p_hold_source_rec.hold_entity_id) ,1);
3112: --FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD');
3113: FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD_SOURCE');
3114: OE_MSG_PUB.ADD;
3115: --RETURN;
3116: RAISE FND_API.G_EXC_ERROR;
3117: END IF;
3118:
3241: EXCEPTION
3242: WHEN FND_API.G_EXC_ERROR THEN
3243: --ROLLBACK TO Create_Hold_Source;
3244: x_return_status := FND_API.G_RET_STS_ERROR;
3245: OE_MSG_PUB.Count_And_Get
3246: ( p_count => x_msg_count
3247: , p_data => x_msg_data
3248: );
3249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3248: );
3249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3250: --ROLLBACK TO Create_Hold_Source;
3251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3252: OE_MSG_PUB.Count_And_Get
3253: ( p_count => x_msg_count
3254: , p_data => x_msg_data
3255: );
3256: WHEN OTHERS THEN
3255: );
3256: WHEN OTHERS THEN
3257: --ROLLBACK TO Create_Hold_Source;
3258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3259: IF OE_MSG_PUB.Check_Msg_Level
3260: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3261: THEN
3262: OE_MSG_PUB.Add_Exc_Msg
3263: ( G_PKG_NAME,
3256: WHEN OTHERS THEN
3257: --ROLLBACK TO Create_Hold_Source;
3258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3259: IF OE_MSG_PUB.Check_Msg_Level
3260: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3261: THEN
3262: OE_MSG_PUB.Add_Exc_Msg
3263: ( G_PKG_NAME,
3264: l_api_name);
3258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3259: IF OE_MSG_PUB.Check_Msg_Level
3260: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3261: THEN
3262: OE_MSG_PUB.Add_Exc_Msg
3263: ( G_PKG_NAME,
3264: l_api_name);
3265: END IF;
3266: OE_MSG_PUB.Count_And_Get
3262: OE_MSG_PUB.Add_Exc_Msg
3263: ( G_PKG_NAME,
3264: l_api_name);
3265: END IF;
3266: OE_MSG_PUB.Count_And_Get
3267: ( p_count => x_msg_count
3268: , p_data => x_msg_data
3269: );
3270: END Create_Hold_Source;
5199: EXCEPTION
5200: WHEN FND_API.G_EXC_ERROR THEN
5201: --ROLLBACK TO APPLY_HOLDS_PUB;
5202: x_return_status := FND_API.G_RET_STS_ERROR;
5203: OE_MSG_PUB.Count_And_Get
5204: ( p_count => x_msg_count
5205: , p_data => x_msg_data
5206: );
5207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5206: );
5207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5208: --ROLLBACK TO APPLY_HOLDS_PUB;
5209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5210: OE_MSG_PUB.Count_And_Get
5211: ( p_count => x_msg_count
5212: , p_data => x_msg_data
5213: );
5214: WHEN OTHERS THEN
5213: );
5214: WHEN OTHERS THEN
5215: --ROLLBACK TO APPLY_HOLDS_PUB;
5216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5217: IF OE_MSG_PUB.Check_Msg_Level
5218: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5219: THEN
5220: OE_MSG_PUB.Add_Exc_Msg
5221: ( G_PKG_NAME
5214: WHEN OTHERS THEN
5215: --ROLLBACK TO APPLY_HOLDS_PUB;
5216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5217: IF OE_MSG_PUB.Check_Msg_Level
5218: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5219: THEN
5220: OE_MSG_PUB.Add_Exc_Msg
5221: ( G_PKG_NAME
5222: , l_api_name
5216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5217: IF OE_MSG_PUB.Check_Msg_Level
5218: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5219: THEN
5220: OE_MSG_PUB.Add_Exc_Msg
5221: ( G_PKG_NAME
5222: , l_api_name
5223: );
5224: END IF;
5221: ( G_PKG_NAME
5222: , l_api_name
5223: );
5224: END IF;
5225: OE_MSG_PUB.Count_And_Get
5226: ( p_count => x_msg_count
5227: , p_data => x_msg_data
5228: );
5229:
5433: p_hold_release_rec.release_reason_code ,2);
5434: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_REASON_CODE');
5435: FND_MESSAGE.SET_TOKEN('REASON_CODE',
5436: p_hold_release_rec.release_reason_code);
5437: OE_MSG_PUB.ADD;
5438: RAISE FND_API.G_EXC_ERROR;
5439:
5440: END; -- Validate Reason Code
5441:
5529: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5531: ROLLBACK TO insert_hold_release;
5532: WHEN OTHERS THEN
5533: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5534: OE_MSG_PUB.Add_Exc_Msg
5535: (G_PKG_NAME
5536: ,'Insert_Hold_Release');
5537: END IF;
5530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5531: ROLLBACK TO insert_hold_release;
5532: WHEN OTHERS THEN
5533: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5534: OE_MSG_PUB.Add_Exc_Msg
5535: (G_PKG_NAME
5536: ,'Insert_Hold_Release');
5537: END IF;
5538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5608: oe_debug_pub.add('Entity Code2/ID2' ||
5609: p_hold_source_rec.hold_entity_code2 || '/' ||
5610: to_char(p_hold_source_rec.hold_entity_id2) ,1);
5611: FND_MESSAGE.SET_NAME('ONT', 'OE_MISSING_HOLD_SOURCE');
5612: OE_MSG_PUB.ADD;
5613: RAISE FND_API.G_EXC_ERROR;
5614: */
5615: CLOSE order_hold_source;
5616: RETURN;
5627: oe_debug_pub.add('Entity Code2/ID2' ||
5628: p_hold_source_rec.hold_entity_code2 || '/' ||
5629: to_char(p_hold_source_rec.hold_entity_id2) ,1);
5630: FND_MESSAGE.SET_NAME('ONT', 'OE_MISSING_HOLD_SOURCE');
5631: OE_MSG_PUB.ADD;
5632: RAISE FND_API.G_EXC_ERROR;
5633: END IF; -- hold_source%NOTFOUND
5634: CLOSE hold_source;
5635: END IF; -- p_hold_source_rec.hold_entity_code = 'O'
5673: x_return_status := FND_API.G_RET_STS_ERROR;
5674: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5676: WHEN OTHERS THEN
5677: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5678: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME
5679: ,'Insert_Hold_Release');
5680: END IF;
5681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5674: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5676: WHEN OTHERS THEN
5677: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5678: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME
5679: ,'Insert_Hold_Release');
5680: END IF;
5681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5682:
5698: x_return_status := FND_API.G_RET_STS_SUCCESS;
5699:
5700: IF p_line_id IS NULL AND p_header_id IS NULL THEN
5701: FND_MESSAGE.SET_NAME('ONT', 'OE_ENTER_HEADER_OR_LINE_ID');
5702: OE_MSG_PUB.ADD;
5703: RAISE FND_API.G_EXC_ERROR;
5704: ELSIF p_header_id IS NULL THEN
5705: l_dummy := 'LINE'; -- Added for bug 7112725
5706: SELECT header_id
5720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5721: IF l_dummy = 'HEADER' THEN
5722: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_HEADER_ID');
5723: FND_MESSAGE.SET_TOKEN('HEADER_ID',p_header_id);
5724: OE_MSG_PUB.ADD;
5725: ELSIF l_dummy = 'LINE' THEN
5726: FND_MESSAGE.SET_NAME('ONT', 'OE_COGS_INVALID_LINE_ID');
5727: FND_MESSAGE.SET_TOKEN('LINE_ID',p_line_id);
5728: OE_MSG_PUB.ADD;
5724: OE_MSG_PUB.ADD;
5725: ELSIF l_dummy = 'LINE' THEN
5726: FND_MESSAGE.SET_NAME('ONT', 'OE_COGS_INVALID_LINE_ID');
5727: FND_MESSAGE.SET_TOKEN('LINE_ID',p_line_id);
5728: OE_MSG_PUB.ADD;
5729: END IF;
5730: oe_debug_pub.add('Return Status : ' || x_return_status, 5);
5731: -- RAISE FND_API.G_EXC_ERROR; -- Commented for bug 7112725
5732: END Validate_Order;
5809: IF (p_order_rec.header_id = FND_API.G_MISS_NUM
5810: AND p_order_rec.line_id = FND_API.G_MISS_NUM) THEN
5811:
5812: FND_MESSAGE.SET_NAME('ONT', 'OE_ENTER_HEADER_OR_LINE_ID');
5813: OE_MSG_PUB.ADD;
5814: RAISE FND_API.G_EXC_ERROR;
5815:
5816: END IF;
5817:
5922: CLOSE line_hold;
5923: END IF;
5924: ROLLBACK TO DELETE_HOLDS_PUB;
5925: x_return_status := FND_API.G_RET_STS_ERROR;
5926: OE_MSG_PUB.Count_And_Get
5927: ( p_count => x_msg_count
5928: , p_data => x_msg_data
5929: );
5930: WHEN OTHERS THEN
5938: CLOSE line_hold;
5939: END IF;
5940: ROLLBACK TO DELETE_HOLDS_PUB;
5941: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5942: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5943: THEN
5944: OE_MSG_PUB.Add_Exc_Msg
5945: ( G_PKG_NAME
5946: , l_api_name
5940: ROLLBACK TO DELETE_HOLDS_PUB;
5941: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5942: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5943: THEN
5944: OE_MSG_PUB.Add_Exc_Msg
5945: ( G_PKG_NAME
5946: , l_api_name
5947: );
5948: END IF;
5945: ( G_PKG_NAME
5946: , l_api_name
5947: );
5948: END IF;
5949: OE_MSG_PUB.Count_And_Get
5950: ( p_count => x_msg_count
5951: , p_data => x_msg_data
5952: );
5953: END Delete_Holds;
5994: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(p_hold_id));
5995: l_msg_token := 'APPLY(System Hold)';
5996: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
5997: fnd_message.set_token('ACTION', l_msg_token);
5998: OE_MSG_PUB.ADD;
5999: x_return_status := FND_API.G_RET_STS_ERROR;
6000: OE_MSG_PUB.Count_And_Get
6001: ( p_count => x_msg_count
6002: , p_data => x_msg_data
5996: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
5997: fnd_message.set_token('ACTION', l_msg_token);
5998: OE_MSG_PUB.ADD;
5999: x_return_status := FND_API.G_RET_STS_ERROR;
6000: OE_MSG_PUB.Count_And_Get
6001: ( p_count => x_msg_count
6002: , p_data => x_msg_data
6003: );
6004: RETURN;
6028: fnd_message.set_name('ONT','ONT_APPLY');
6029: l_msg_token := fnd_message.get;
6030: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
6031: fnd_message.set_token('ACTION', l_msg_token);
6032: OE_MSG_PUB.ADD;
6033: x_return_status := FND_API.G_RET_STS_ERROR;
6034: OE_MSG_PUB.Count_And_Get
6035: ( p_count => x_msg_count
6036: , p_data => x_msg_data
6030: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
6031: fnd_message.set_token('ACTION', l_msg_token);
6032: OE_MSG_PUB.ADD;
6033: x_return_status := FND_API.G_RET_STS_ERROR;
6034: OE_MSG_PUB.Count_And_Get
6035: ( p_count => x_msg_count
6036: , p_data => x_msg_data
6037: );
6038: RETURN;
6186:
6187: IF p_order_tbl.COUNT = 1 AND l_count_of_holds_applied = 0 THEN
6188: fnd_message.set_name('ONT', 'OE_NO_HOLD_FOR_ACTIVITY');
6189: fnd_message.set_token('WF_ACT',l_user_activity_name);
6190: OE_MSG_PUB.ADD;
6191: oe_debug_pub.add(' Hold Not applied for the requested line');
6192: RAISE FND_API.G_EXC_ERROR;
6193: ELSIF l_count_of_holds_applied = 0
6194: AND p_order_tbl.COUNT > 1 THEN
6193: ELSIF l_count_of_holds_applied = 0
6194: AND p_order_tbl.COUNT > 1 THEN
6195: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
6196: fnd_message.set_token('WF_ACT',l_user_activity_name);
6197: OE_MSG_PUB.ADD;
6198: oe_debug_pub.add('Hold Not applied for ALL requested lines');
6199: RAISE FND_API.G_EXC_ERROR;
6200: ELSIF p_order_tbl.COUNT > l_count_of_holds_applied
6201: AND p_order_tbl.COUNT > 1 THEN
6200: ELSIF p_order_tbl.COUNT > l_count_of_holds_applied
6201: AND p_order_tbl.COUNT > 1 THEN
6202: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
6203: fnd_message.set_token('WF_ACT',l_user_activity_name);
6204: OE_MSG_PUB.ADD;
6205: oe_debug_pub.add('Hold Not applied for FEW requested lines');
6206: ELSE
6207: NULL; -- No messages are required to be logged.
6208: END IF;
6347: OE_DEBUG_PUB.Add('Not authorize to Release this Hold:'|| to_char(p_hold_source_rec.hold_id));
6348: l_msg_token := 'RELEASE(System Hold)';
6349: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
6350: fnd_message.set_token('ACTION', l_msg_token);
6351: OE_MSG_PUB.ADD;
6352: x_return_status := FND_API.G_RET_STS_ERROR;
6353: OE_MSG_PUB.Count_And_Get
6354: ( p_count => x_msg_count
6355: , p_data => x_msg_data
6349: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
6350: fnd_message.set_token('ACTION', l_msg_token);
6351: OE_MSG_PUB.ADD;
6352: x_return_status := FND_API.G_RET_STS_ERROR;
6353: OE_MSG_PUB.Count_And_Get
6354: ( p_count => x_msg_count
6355: , p_data => x_msg_data
6356: );
6357: RETURN;
6382: fnd_message.set_name('ONT','ONT_RELEASE');
6383: l_msg_token := fnd_message.get;
6384: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
6385: fnd_message.set_token('ACTION', l_msg_token);
6386: OE_MSG_PUB.ADD;
6387: x_return_status := FND_API.G_RET_STS_ERROR;
6388: OE_MSG_PUB.Count_And_Get
6389: ( p_count => x_msg_count
6390: , p_data => x_msg_data
6384: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
6385: fnd_message.set_token('ACTION', l_msg_token);
6386: OE_MSG_PUB.ADD;
6387: x_return_status := FND_API.G_RET_STS_ERROR;
6388: OE_MSG_PUB.Count_And_Get
6389: ( p_count => x_msg_count
6390: , p_data => x_msg_data
6391: );
6392: RETURN;
6501: OE_DEBUG_PUB.Add('Not authorize to Release this Hold:'|| to_char(p_hold_id));
6502: l_msg_token := 'RELEASE(System Hold)';
6503: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
6504: fnd_message.set_token('ACTION', l_msg_token);
6505: OE_MSG_PUB.ADD;
6506: x_return_status := FND_API.G_RET_STS_ERROR;
6507: OE_MSG_PUB.Count_And_Get
6508: ( p_count => x_msg_count
6509: , p_data => x_msg_data
6503: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
6504: fnd_message.set_token('ACTION', l_msg_token);
6505: OE_MSG_PUB.ADD;
6506: x_return_status := FND_API.G_RET_STS_ERROR;
6507: OE_MSG_PUB.Count_And_Get
6508: ( p_count => x_msg_count
6509: , p_data => x_msg_data
6510: );
6511: RETURN;
6535: fnd_message.set_name('ONT','ONT_RELEASE');
6536: l_msg_token := fnd_message.get;
6537: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
6538: fnd_message.set_token('ACTION', l_msg_token);
6539: OE_MSG_PUB.ADD;
6540: x_return_status := FND_API.G_RET_STS_ERROR;
6541: OE_MSG_PUB.Count_And_Get
6542: ( p_count => x_msg_count
6543: , p_data => x_msg_data
6537: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
6538: fnd_message.set_token('ACTION', l_msg_token);
6539: OE_MSG_PUB.ADD;
6540: x_return_status := FND_API.G_RET_STS_ERROR;
6541: OE_MSG_PUB.Count_And_Get
6542: ( p_count => x_msg_count
6543: , p_data => x_msg_data
6544: );
6545: RETURN;
6718: l_user_activity_name VARCHAR2(80);
6719:
6720:
6721: BEGIN
6722: oe_msg_pub.initialize;
6723:
6724: OE_DEBUG_PUB.Add('Entering OE_Holds_PVT.process_apply_holds_lines',1);
6725:
6726: IF check_system_holds(
6730: x_msg_data => x_msg_data) = 'N' THEN
6731:
6732: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(p_hold_id));
6733: fnd_message.set_name('ONT', 'ONT_HOLDS_SYSTEM_CHECK');
6734: OE_MSG_PUB.ADD;
6735: x_return_status := FND_API.G_RET_STS_ERROR;
6736: OE_MSG_PUB.Count_And_Get
6737: ( p_count => x_msg_count
6738: , p_data => x_msg_data
6732: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(p_hold_id));
6733: fnd_message.set_name('ONT', 'ONT_HOLDS_SYSTEM_CHECK');
6734: OE_MSG_PUB.ADD;
6735: x_return_status := FND_API.G_RET_STS_ERROR;
6736: OE_MSG_PUB.Count_And_Get
6737: ( p_count => x_msg_count
6738: , p_data => x_msg_data
6739: );
6740: RETURN;
6756:
6757: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
6758: fnd_message.set_token('ACTION', l_msg_token);
6759:
6760: OE_MSG_PUB.ADD;
6761: --RAISE FND_API.G_EXC_ERROR;
6762: x_return_status := FND_API.G_RET_STS_ERROR;
6763: OE_MSG_PUB.Count_And_Get
6764: ( p_count => x_msg_count
6759:
6760: OE_MSG_PUB.ADD;
6761: --RAISE FND_API.G_EXC_ERROR;
6762: x_return_status := FND_API.G_RET_STS_ERROR;
6763: OE_MSG_PUB.Count_And_Get
6764: ( p_count => x_msg_count
6765: , p_data => x_msg_data
6766: );
6767: RETURN;
6868: IF p_sel_rec_tbl.COUNT = 1 AND l_count_of_holds_applied = 0
6869: THEN
6870: fnd_message.set_name('ONT', 'OE_NO_HOLD_FOR_ACTIVITY');
6871: fnd_message.set_token('WF_ACT',l_user_activity_name);
6872: OE_MSG_PUB.ADD;
6873: oe_debug_pub.add(' Hold Not applied for the requested line');
6874: RAISE FND_API.G_EXC_ERROR;
6875: ELSIF l_count_of_holds_applied = 0
6876: AND p_sel_rec_tbl.COUNT > 1 THEN
6875: ELSIF l_count_of_holds_applied = 0
6876: AND p_sel_rec_tbl.COUNT > 1 THEN
6877: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
6878: fnd_message.set_token('WF_ACT',l_user_activity_name);
6879: OE_MSG_PUB.ADD;
6880: oe_debug_pub.add('Hold Not applied for ALL requested lines');
6881: RAISE FND_API.G_EXC_ERROR;
6882: ELSIF p_sel_rec_tbl.COUNT > l_count_of_holds_applied
6883: AND p_sel_rec_tbl.COUNT > 1 THEN
6882: ELSIF p_sel_rec_tbl.COUNT > l_count_of_holds_applied
6883: AND p_sel_rec_tbl.COUNT > 1 THEN
6884: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
6885: fnd_message.set_token('WF_ACT',l_user_activity_name);
6886: OE_MSG_PUB.ADD;
6887: oe_debug_pub.add('Hold Not applied for FEW requested lines');
6888: ELSE
6889: NULL; -- No messages are required to be logged.
6890: END IF;
6891: END IF; -- End of WF_HOLDS ER (bug 6449458) IF Condition
6892:
6893: x_return_status := FND_API.G_RET_STS_SUCCESS;
6894: -- Get message count and data
6895: OE_MSG_PUB.Count_And_Get
6896: ( p_count => x_msg_count
6897: , p_data => x_msg_data
6898: );
6899:
6902: EXCEPTION /* Procedure exception handler */
6903:
6904: WHEN FND_API.G_EXC_ERROR THEN
6905: x_return_status := FND_API.G_RET_STS_ERROR ;
6906: OE_MSG_PUB.Count_And_Get
6907: ( p_count => x_msg_count,
6908: p_data => x_msg_data
6909: );
6910: ROLLBACK TO SAVEPOINT process_apply_holds_lines;
6910: ROLLBACK TO SAVEPOINT process_apply_holds_lines;
6911:
6912: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6913: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6914: OE_MSG_PUB.Count_And_Get
6915: ( p_count => x_msg_count,
6916: p_data => x_msg_data
6917: );
6918: ROLLBACK TO SAVEPOINT process_apply_holds_lines;
6918: ROLLBACK TO SAVEPOINT process_apply_holds_lines;
6919:
6920: WHEN OTHERS THEN
6921: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6922: IF OE_MSG_PUB.Check_Msg_Level
6923: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6924: THEN
6925: OE_MSG_PUB.Add_Exc_Msg
6926: (G_PKG_NAME,
6919:
6920: WHEN OTHERS THEN
6921: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6922: IF OE_MSG_PUB.Check_Msg_Level
6923: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6924: THEN
6925: OE_MSG_PUB.Add_Exc_Msg
6926: (G_PKG_NAME,
6927: l_api_name
6921: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6922: IF OE_MSG_PUB.Check_Msg_Level
6923: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6924: THEN
6925: OE_MSG_PUB.Add_Exc_Msg
6926: (G_PKG_NAME,
6927: l_api_name
6928: );
6929: END IF;
6926: (G_PKG_NAME,
6927: l_api_name
6928: );
6929: END IF;
6930: OE_MSG_PUB.Count_And_Get
6931: ( p_count => x_msg_count,
6932: p_data => x_msg_data);
6933: ROLLBACK TO SAVEPOINT process_apply_holds_lines;
6934:
6968: l_count_of_holds_applied NUMBER := 0;
6969: l_user_activity_name VARCHAR2(80);
6970:
6971: BEGIN
6972: oe_msg_pub.initialize;
6973:
6974: OE_DEBUG_PUB.Add('Entering OE_Holds_PVT.process_apply_holds_orders',1);
6975:
6976: IF check_system_holds( p_hold_id => p_hold_id
6979: , x_msg_data => x_msg_data
6980: ) = 'N' THEN
6981: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(p_hold_id));
6982: fnd_message.set_name('ONT', 'ONT_HOLDS_SYSTEM_CHECK');
6983: OE_MSG_PUB.ADD;
6984: x_return_status := FND_API.G_RET_STS_ERROR;
6985: OE_MSG_PUB.Count_And_Get
6986: ( p_count => x_msg_count
6987: , p_data => x_msg_data
6981: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(p_hold_id));
6982: fnd_message.set_name('ONT', 'ONT_HOLDS_SYSTEM_CHECK');
6983: OE_MSG_PUB.ADD;
6984: x_return_status := FND_API.G_RET_STS_ERROR;
6985: OE_MSG_PUB.Count_And_Get
6986: ( p_count => x_msg_count
6987: , p_data => x_msg_data
6988: );
6989: RETURN;
7006:
7007: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
7008: fnd_message.set_token('ACTION', l_msg_token);
7009:
7010: OE_MSG_PUB.ADD;
7011: -- RAISE FND_API.G_EXC_ERROR;
7012: x_return_status := FND_API.G_RET_STS_ERROR;
7013: OE_MSG_PUB.Count_And_Get
7014: ( p_count => x_msg_count
7009:
7010: OE_MSG_PUB.ADD;
7011: -- RAISE FND_API.G_EXC_ERROR;
7012: x_return_status := FND_API.G_RET_STS_ERROR;
7013: OE_MSG_PUB.Count_And_Get
7014: ( p_count => x_msg_count
7015: , p_data => x_msg_data
7016: );
7017: RETURN;
7102: IF p_sel_rec_tbl.COUNT = 1 AND l_count_of_holds_applied = 0
7103: THEN
7104: fnd_message.set_name('ONT', 'OE_NO_HOLD_FOR_ACTIVITY');
7105: fnd_message.set_token('WF_ACT',l_user_activity_name);
7106: OE_MSG_PUB.ADD;
7107: oe_debug_pub.add(' Hold Not applied for the requested line');
7108: RAISE FND_API.G_EXC_ERROR;
7109: ELSIF l_count_of_holds_applied = 0
7110: AND p_sel_rec_tbl.COUNT > 1 THEN
7109: ELSIF l_count_of_holds_applied = 0
7110: AND p_sel_rec_tbl.COUNT > 1 THEN
7111: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
7112: fnd_message.set_token('WF_ACT',l_user_activity_name);
7113: OE_MSG_PUB.ADD;
7114: oe_debug_pub.add('Hold Not applied for ALL requested lines');
7115: RAISE FND_API.G_EXC_ERROR;
7116: ELSIF p_sel_rec_tbl.COUNT > l_count_of_holds_applied
7117: AND p_sel_rec_tbl.COUNT > 1 THEN
7116: ELSIF p_sel_rec_tbl.COUNT > l_count_of_holds_applied
7117: AND p_sel_rec_tbl.COUNT > 1 THEN
7118: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
7119: fnd_message.set_token('WF_ACT',l_user_activity_name);
7120: OE_MSG_PUB.ADD;
7121: oe_debug_pub.add('Hold Not applied for FEW requested lines');
7122: ELSE
7123: NULL; -- No messages are required to be logged.
7124: END IF;
7125: END IF; -- End of WF_HOLDS ER (bug 6449458) IF Condition
7126:
7127: x_return_status := FND_API.G_RET_STS_SUCCESS;
7128: -- Get message count and data
7129: OE_MSG_PUB.Count_And_Get
7130: ( p_count => x_msg_count
7131: , p_data => x_msg_data
7132: );
7133:
7136: EXCEPTION /* Procedure exception handler */
7137:
7138: WHEN FND_API.G_EXC_ERROR THEN
7139: x_return_status := FND_API.G_RET_STS_ERROR ;
7140: OE_MSG_PUB.Count_And_Get
7141: ( p_count => x_msg_count,
7142: p_data => x_msg_data
7143: );
7144: ROLLBACK TO SAVEPOINT process_apply_holds_orders;
7144: ROLLBACK TO SAVEPOINT process_apply_holds_orders;
7145:
7146: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7148: OE_MSG_PUB.Count_And_Get
7149: ( p_count => x_msg_count,
7150: p_data => x_msg_data
7151: );
7152: ROLLBACK TO SAVEPOINT process_apply_holds_orders;
7152: ROLLBACK TO SAVEPOINT process_apply_holds_orders;
7153:
7154: WHEN OTHERS THEN
7155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7156: IF OE_MSG_PUB.Check_Msg_Level
7157: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7158: THEN
7159: OE_MSG_PUB.Add_Exc_Msg
7160: (G_PKG_NAME,
7153:
7154: WHEN OTHERS THEN
7155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7156: IF OE_MSG_PUB.Check_Msg_Level
7157: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7158: THEN
7159: OE_MSG_PUB.Add_Exc_Msg
7160: (G_PKG_NAME,
7161: l_api_name
7155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7156: IF OE_MSG_PUB.Check_Msg_Level
7157: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7158: THEN
7159: OE_MSG_PUB.Add_Exc_Msg
7160: (G_PKG_NAME,
7161: l_api_name
7162: );
7163: END IF;
7160: (G_PKG_NAME,
7161: l_api_name
7162: );
7163: END IF;
7164: OE_MSG_PUB.Count_And_Get
7165: ( p_count => x_msg_count,
7166: p_data => x_msg_data);
7167: ROLLBACK TO SAVEPOINT process_apply_holds_orders;
7168:
7206: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID;
7207: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;
7208: l_msg_token VARCHAR2(100);
7209: BEGIN
7210: oe_msg_pub.initialize;
7211:
7212: OE_DEBUG_PUB.Add('Entering OE_Holds_PVT.process_release_holds_lines',1);
7213:
7214: IF check_system_holds( p_hold_id => p_hold_id
7217: ,x_msg_data => x_msg_data
7218: ) = 'N' THEN
7219: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(p_hold_id));
7220: fnd_message.set_name('ONT', 'ONT_HOLDS_SYSTEM_CHECK');
7221: OE_MSG_PUB.ADD;
7222: x_return_status := FND_API.G_RET_STS_ERROR;
7223: OE_MSG_PUB.Count_And_Get
7224: ( p_count => x_msg_count
7225: , p_data => x_msg_data
7219: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(p_hold_id));
7220: fnd_message.set_name('ONT', 'ONT_HOLDS_SYSTEM_CHECK');
7221: OE_MSG_PUB.ADD;
7222: x_return_status := FND_API.G_RET_STS_ERROR;
7223: OE_MSG_PUB.Count_And_Get
7224: ( p_count => x_msg_count
7225: , p_data => x_msg_data
7226: );
7227: RETURN;
7243:
7244: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
7245: fnd_message.set_token('ACTION', l_msg_token);
7246:
7247: OE_MSG_PUB.ADD;
7248: -- RAISE FND_API.G_EXC_ERROR;
7249: x_return_status := FND_API.G_RET_STS_ERROR;
7250: OE_MSG_PUB.Count_And_Get
7251: ( p_count => x_msg_count
7246:
7247: OE_MSG_PUB.ADD;
7248: -- RAISE FND_API.G_EXC_ERROR;
7249: x_return_status := FND_API.G_RET_STS_ERROR;
7250: OE_MSG_PUB.Count_And_Get
7251: ( p_count => x_msg_count
7252: , p_data => x_msg_data
7253: );
7254: RETURN;
7307: END LOOP;
7308:
7309: x_return_status := FND_API.G_RET_STS_SUCCESS;
7310: -- Get message count and data
7311: OE_MSG_PUB.Count_And_Get
7312: ( p_count => x_msg_count
7313: , p_data => x_msg_data
7314: );
7315:
7318: EXCEPTION /* Procedure exception handler */
7319:
7320: WHEN FND_API.G_EXC_ERROR THEN
7321: x_return_status := FND_API.G_RET_STS_ERROR ;
7322: OE_MSG_PUB.Count_And_Get
7323: ( p_count => x_msg_count,
7324: p_data => x_msg_data
7325: );
7326: ROLLBACK TO SAVEPOINT process_release_holds_lines;
7326: ROLLBACK TO SAVEPOINT process_release_holds_lines;
7327:
7328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7329: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7330: OE_MSG_PUB.Count_And_Get
7331: ( p_count => x_msg_count,
7332: p_data => x_msg_data
7333: );
7334: ROLLBACK TO SAVEPOINT process_release_holds_lines;
7334: ROLLBACK TO SAVEPOINT process_release_holds_lines;
7335:
7336: WHEN OTHERS THEN
7337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7338: IF OE_MSG_PUB.Check_Msg_Level
7339: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7340: THEN
7341: OE_MSG_PUB.Add_Exc_Msg
7342: (G_PKG_NAME,
7335:
7336: WHEN OTHERS THEN
7337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7338: IF OE_MSG_PUB.Check_Msg_Level
7339: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7340: THEN
7341: OE_MSG_PUB.Add_Exc_Msg
7342: (G_PKG_NAME,
7343: l_api_name
7337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7338: IF OE_MSG_PUB.Check_Msg_Level
7339: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7340: THEN
7341: OE_MSG_PUB.Add_Exc_Msg
7342: (G_PKG_NAME,
7343: l_api_name
7344: );
7345: END IF;
7342: (G_PKG_NAME,
7343: l_api_name
7344: );
7345: END IF;
7346: OE_MSG_PUB.Count_And_Get
7347: ( p_count => x_msg_count,
7348: p_data => x_msg_data);
7349: ROLLBACK TO SAVEPOINT process_release_holds_lines;
7350:
7382: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID;
7383: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;
7384: l_msg_token VARCHAR2(100);
7385: BEGIN
7386: oe_msg_pub.initialize;
7387:
7388: OE_DEBUG_PUB.Add('Entering OE_Holds_PVT.process_release_holds_orders',1);
7389:
7390: IF check_system_holds( p_hold_id => p_hold_id
7393: ,x_msg_data => x_msg_data
7394: ) = 'N' THEN
7395: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(p_hold_id));
7396: fnd_message.set_name('ONT', 'ONT_HOLDS_SYSTEM_CHECK');
7397: OE_MSG_PUB.ADD;
7398: x_return_status := FND_API.G_RET_STS_ERROR;
7399: OE_MSG_PUB.Count_And_Get
7400: ( p_count => x_msg_count
7401: , p_data => x_msg_data
7395: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(p_hold_id));
7396: fnd_message.set_name('ONT', 'ONT_HOLDS_SYSTEM_CHECK');
7397: OE_MSG_PUB.ADD;
7398: x_return_status := FND_API.G_RET_STS_ERROR;
7399: OE_MSG_PUB.Count_And_Get
7400: ( p_count => x_msg_count
7401: , p_data => x_msg_data
7402: );
7403: RETURN;
7419:
7420: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
7421: fnd_message.set_token('ACTION', l_msg_token);
7422:
7423: OE_MSG_PUB.ADD;
7424: -- RAISE FND_API.G_EXC_ERROR;
7425: x_return_status := FND_API.G_RET_STS_ERROR;
7426:
7427: OE_MSG_PUB.Count_And_Get
7423: OE_MSG_PUB.ADD;
7424: -- RAISE FND_API.G_EXC_ERROR;
7425: x_return_status := FND_API.G_RET_STS_ERROR;
7426:
7427: OE_MSG_PUB.Count_And_Get
7428: ( p_count => x_msg_count
7429: , p_data => x_msg_data
7430: );
7431:
7477: END LOOP;
7478:
7479: x_return_status := FND_API.G_RET_STS_SUCCESS;
7480: -- Get message count and data
7481: OE_MSG_PUB.Count_And_Get
7482: ( p_count => x_msg_count
7483: , p_data => x_msg_data
7484: );
7485:
7488: EXCEPTION /* Procedure exception handler */
7489:
7490: WHEN FND_API.G_EXC_ERROR THEN
7491: x_return_status := FND_API.G_RET_STS_ERROR ;
7492: OE_MSG_PUB.Count_And_Get
7493: ( p_count => x_msg_count,
7494: p_data => x_msg_data
7495: );
7496: ROLLBACK TO SAVEPOINT process_release_holds_orders;
7496: ROLLBACK TO SAVEPOINT process_release_holds_orders;
7497:
7498: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7500: OE_MSG_PUB.Count_And_Get
7501: ( p_count => x_msg_count,
7502: p_data => x_msg_data
7503: );
7504: ROLLBACK TO SAVEPOINT process_release_holds_orders;
7504: ROLLBACK TO SAVEPOINT process_release_holds_orders;
7505:
7506: WHEN OTHERS THEN
7507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7508: IF OE_MSG_PUB.Check_Msg_Level
7509: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7510: THEN
7511: OE_MSG_PUB.Add_Exc_Msg
7512: (G_PKG_NAME,
7505:
7506: WHEN OTHERS THEN
7507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7508: IF OE_MSG_PUB.Check_Msg_Level
7509: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7510: THEN
7511: OE_MSG_PUB.Add_Exc_Msg
7512: (G_PKG_NAME,
7513: l_api_name
7507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7508: IF OE_MSG_PUB.Check_Msg_Level
7509: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7510: THEN
7511: OE_MSG_PUB.Add_Exc_Msg
7512: (G_PKG_NAME,
7513: l_api_name
7514: );
7515: END IF;
7512: (G_PKG_NAME,
7513: l_api_name
7514: );
7515: END IF;
7516: OE_MSG_PUB.Count_And_Get
7517: ( p_count => x_msg_count,
7518: p_data => x_msg_data);
7519: ROLLBACK TO SAVEPOINT process_release_holds_orders;
7520:
7553:
7554: --
7555: BEGIN
7556: oe_debug_pub.add('In process_create_holds', 1);
7557: oe_msg_pub.initialize; --bug 5548778
7558: l_hold_source_rec := p_hold_source_rec;
7559:
7560:
7561: -- ER #11824468
7586: ,x_msg_data => x_msg_data
7587: ) = 'N' THEN
7588: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(l_hold_source_rec.hold_id));
7589: fnd_message.set_name('ONT', 'ONT_HOLDS_SYSTEM_CHECK');
7590: OE_MSG_PUB.ADD;
7591: x_return_status := FND_API.G_RET_STS_ERROR;
7592: OE_MSG_PUB.Count_And_Get
7593: ( p_count => x_msg_count
7594: , p_data => x_msg_data
7588: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(l_hold_source_rec.hold_id));
7589: fnd_message.set_name('ONT', 'ONT_HOLDS_SYSTEM_CHECK');
7590: OE_MSG_PUB.ADD;
7591: x_return_status := FND_API.G_RET_STS_ERROR;
7592: OE_MSG_PUB.Count_And_Get
7593: ( p_count => x_msg_count
7594: , p_data => x_msg_data
7595: );
7596: return;
7612:
7613: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
7614: fnd_message.set_token('ACTION', l_msg_token);
7615:
7616: OE_MSG_PUB.ADD;
7617: RAISE FND_API.G_EXC_ERROR;
7618: x_return_status := FND_API.G_RET_STS_ERROR;
7619: OE_MSG_PUB.Count_And_Get
7620: ( p_count => x_msg_count
7615:
7616: OE_MSG_PUB.ADD;
7617: RAISE FND_API.G_EXC_ERROR;
7618: x_return_status := FND_API.G_RET_STS_ERROR;
7619: OE_MSG_PUB.Count_And_Get
7620: ( p_count => x_msg_count
7621: , p_data => x_msg_data
7622: );
7623: return;
7731: oe_debug_pub.add ('Do nothing',3);
7732: end if; -- (p_hold_existing_flg = 'Y' AND p_hold_future_flg 'Y')
7733: -- Get message count and data
7734:
7735: OE_MSG_PUB.Count_And_Get
7736: ( p_count => x_msg_count
7737: , p_data => x_msg_data
7738: );
7739:
7741: EXCEPTION /* Procedure exception handler */
7742:
7743: WHEN FND_API.G_EXC_ERROR THEN
7744: x_return_status := FND_API.G_RET_STS_ERROR ;
7745: OE_MSG_PUB.Count_And_Get
7746: ( p_count => x_msg_count,
7747: p_data => x_msg_data
7748: );
7749:
7748: );
7749:
7750: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7752: OE_MSG_PUB.Count_And_Get
7753: ( p_count => x_msg_count,
7754: p_data => x_msg_data
7755: );
7756:
7755: );
7756:
7757: WHEN OTHERS THEN
7758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7759: IF OE_MSG_PUB.Check_Msg_Level
7760: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7761: THEN
7762: OE_MSG_PUB.Add_Exc_Msg
7763: (G_PKG_NAME,
7756:
7757: WHEN OTHERS THEN
7758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7759: IF OE_MSG_PUB.Check_Msg_Level
7760: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7761: THEN
7762: OE_MSG_PUB.Add_Exc_Msg
7763: (G_PKG_NAME,
7764: l_api_name
7758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7759: IF OE_MSG_PUB.Check_Msg_Level
7760: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7761: THEN
7762: OE_MSG_PUB.Add_Exc_Msg
7763: (G_PKG_NAME,
7764: l_api_name
7765: );
7766: END IF;
7763: (G_PKG_NAME,
7764: l_api_name
7765: );
7766: END IF;
7767: OE_MSG_PUB.Count_And_Get
7768: ( p_count => x_msg_count,
7769: p_data => x_msg_data);
7770:
7771:
7813: If l_hold_id = 1 AND (l_hold_entity_code ='C' OR l_hold_entity_code = 'B') then
7814: OE_DEBUG_PUB.Add('Bug 1946783 Credit Hold should be released from AR',1);
7815:
7816: fnd_message.set_name('ONT', 'OE_CC_AR_HOLD_NOT_RELEASED');
7817: OE_MSG_PUB.ADD;
7818: RAISE FND_API.G_EXC_ERROR;
7819: x_return_status := FND_API.G_RET_STS_ERROR;
7820: OE_MSG_PUB.Count_And_Get
7821: ( p_count => x_msg_count
7816: fnd_message.set_name('ONT', 'OE_CC_AR_HOLD_NOT_RELEASED');
7817: OE_MSG_PUB.ADD;
7818: RAISE FND_API.G_EXC_ERROR;
7819: x_return_status := FND_API.G_RET_STS_ERROR;
7820: OE_MSG_PUB.Count_And_Get
7821: ( p_count => x_msg_count
7822: , p_data => x_msg_data
7823: );
7824: return;
7834: ) = 'N' THEN
7835: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(l_hold_id));
7836: fnd_message.set_name('ONT', 'ONT_HOLDS_SYSTEM_CHECK');
7837: fnd_message.set_token('ACTION', 'Release');
7838: OE_MSG_PUB.ADD;
7839: x_return_status := FND_API.G_RET_STS_ERROR;
7840: OE_MSG_PUB.Count_And_Get
7841: ( p_count => x_msg_count
7842: , p_data => x_msg_data
7836: fnd_message.set_name('ONT', 'ONT_HOLDS_SYSTEM_CHECK');
7837: fnd_message.set_token('ACTION', 'Release');
7838: OE_MSG_PUB.ADD;
7839: x_return_status := FND_API.G_RET_STS_ERROR;
7840: OE_MSG_PUB.Count_And_Get
7841: ( p_count => x_msg_count
7842: , p_data => x_msg_data
7843: );
7844: return;
7859:
7860: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
7861: fnd_message.set_token('ACTION', l_msg_token);
7862:
7863: OE_MSG_PUB.ADD;
7864: RAISE FND_API.G_EXC_ERROR;
7865: x_return_status := FND_API.G_RET_STS_ERROR;
7866: OE_MSG_PUB.Count_And_Get
7867: ( p_count => x_msg_count
7862:
7863: OE_MSG_PUB.ADD;
7864: RAISE FND_API.G_EXC_ERROR;
7865: x_return_status := FND_API.G_RET_STS_ERROR;
7866: OE_MSG_PUB.Count_And_Get
7867: ( p_count => x_msg_count
7868: , p_data => x_msg_data
7869: );
7870: return;
7894: END IF;
7895:
7896: x_return_status := FND_API.G_RET_STS_SUCCESS;
7897: -- Get message count and data
7898: OE_MSG_PUB.Count_And_Get
7899: ( p_count => x_msg_count
7900: , p_data => x_msg_data
7901: );
7902:
7904: EXCEPTION /* Procedure exception handler */
7905:
7906: WHEN FND_API.G_EXC_ERROR THEN
7907: x_return_status := FND_API.G_RET_STS_ERROR ;
7908: OE_MSG_PUB.Count_And_Get
7909: ( p_count => x_msg_count,
7910: p_data => x_msg_data
7911: );
7912:
7911: );
7912:
7913: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7914: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7915: OE_MSG_PUB.Count_And_Get
7916: ( p_count => x_msg_count,
7917: p_data => x_msg_data
7918: );
7919:
7918: );
7919:
7920: WHEN OTHERS THEN
7921: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7922: IF OE_MSG_PUB.Check_Msg_Level
7923: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7924: THEN
7925: OE_MSG_PUB.Add_Exc_Msg
7926: (G_PKG_NAME,
7919:
7920: WHEN OTHERS THEN
7921: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7922: IF OE_MSG_PUB.Check_Msg_Level
7923: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7924: THEN
7925: OE_MSG_PUB.Add_Exc_Msg
7926: (G_PKG_NAME,
7927: l_api_name
7921: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7922: IF OE_MSG_PUB.Check_Msg_Level
7923: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7924: THEN
7925: OE_MSG_PUB.Add_Exc_Msg
7926: (G_PKG_NAME,
7927: l_api_name
7928: );
7929: END IF;
7926: (G_PKG_NAME,
7927: l_api_name
7928: );
7929: END IF;
7930: OE_MSG_PUB.Count_And_Get
7931: ( p_count => x_msg_count,
7932: p_data => x_msg_data);
7933:
7934: end process_release_source;
7989: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID;
7990: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;
7991: l_msg_token VARCHAR2(100);
7992: BEGIN
7993: oe_msg_pub.initialize;
7994:
7995: OE_DEBUG_PUB.Add('Entering OE_Holds_PVT.process_release_holds_lines',1);
7996:
7997: IF check_system_holds( p_hold_id => p_hold_id
8000: ,x_msg_data => x_msg_data
8001: ) = 'N' THEN
8002: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(p_hold_id));
8003: fnd_message.set_name('ONT', 'ONT_HOLDS_SYSTEM_CHECK');
8004: OE_MSG_PUB.ADD;
8005: x_return_status := FND_API.G_RET_STS_ERROR;
8006: OE_MSG_PUB.Count_And_Get
8007: ( p_count => x_msg_count
8008: , p_data => x_msg_data
8002: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(p_hold_id));
8003: fnd_message.set_name('ONT', 'ONT_HOLDS_SYSTEM_CHECK');
8004: OE_MSG_PUB.ADD;
8005: x_return_status := FND_API.G_RET_STS_ERROR;
8006: OE_MSG_PUB.Count_And_Get
8007: ( p_count => x_msg_count
8008: , p_data => x_msg_data
8009: );
8010: RETURN;
8026:
8027: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
8028: fnd_message.set_token('ACTION', l_msg_token);
8029:
8030: OE_MSG_PUB.ADD;
8031: -- RAISE FND_API.G_EXC_ERROR;
8032: x_return_status := FND_API.G_RET_STS_ERROR;
8033: OE_MSG_PUB.Count_And_Get
8034: ( p_count => x_msg_count
8029:
8030: OE_MSG_PUB.ADD;
8031: -- RAISE FND_API.G_EXC_ERROR;
8032: x_return_status := FND_API.G_RET_STS_ERROR;
8033: OE_MSG_PUB.Count_And_Get
8034: ( p_count => x_msg_count
8035: , p_data => x_msg_data
8036: );
8037: RETURN;
8104: END LOOP;
8105:
8106: x_return_status := FND_API.G_RET_STS_SUCCESS;
8107: -- Get message count and data
8108: OE_MSG_PUB.Count_And_Get
8109: ( p_count => x_msg_count
8110: , p_data => x_msg_data
8111: );
8112:
8115: EXCEPTION /* Procedure exception handler */
8116:
8117: WHEN FND_API.G_EXC_ERROR THEN
8118: x_return_status := FND_API.G_RET_STS_ERROR ;
8119: OE_MSG_PUB.Count_And_Get
8120: ( p_count => x_msg_count,
8121: p_data => x_msg_data
8122: );
8123: ROLLBACK TO SAVEPOINT process_release_holds_lines;
8123: ROLLBACK TO SAVEPOINT process_release_holds_lines;
8124:
8125: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8127: OE_MSG_PUB.Count_And_Get
8128: ( p_count => x_msg_count,
8129: p_data => x_msg_data
8130: );
8131: ROLLBACK TO SAVEPOINT process_release_holds_lines;
8131: ROLLBACK TO SAVEPOINT process_release_holds_lines;
8132:
8133: WHEN OTHERS THEN
8134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8135: IF OE_MSG_PUB.Check_Msg_Level
8136: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8137: THEN
8138: OE_MSG_PUB.Add_Exc_Msg
8139: (G_PKG_NAME,
8132:
8133: WHEN OTHERS THEN
8134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8135: IF OE_MSG_PUB.Check_Msg_Level
8136: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8137: THEN
8138: OE_MSG_PUB.Add_Exc_Msg
8139: (G_PKG_NAME,
8140: l_api_name
8134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8135: IF OE_MSG_PUB.Check_Msg_Level
8136: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8137: THEN
8138: OE_MSG_PUB.Add_Exc_Msg
8139: (G_PKG_NAME,
8140: l_api_name
8141: );
8142: END IF;
8139: (G_PKG_NAME,
8140: l_api_name
8141: );
8142: END IF;
8143: OE_MSG_PUB.Count_And_Get
8144: ( p_count => x_msg_count,
8145: p_data => x_msg_data);
8146: ROLLBACK TO SAVEPOINT process_release_holds_lines;
8147:
8198: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID;
8199: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;
8200: l_msg_token VARCHAR2(100);
8201: BEGIN
8202: oe_msg_pub.initialize;
8203:
8204: OE_DEBUG_PUB.Add('Entering OE_Holds_PVT.process_release_holds_orders',1);
8205:
8206: IF check_system_holds( p_hold_id => p_hold_id
8209: ,x_msg_data => x_msg_data
8210: ) = 'N' THEN
8211: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(p_hold_id));
8212: fnd_message.set_name('ONT', 'ONT_HOLDS_SYSTEM_CHECK');
8213: OE_MSG_PUB.ADD;
8214: x_return_status := FND_API.G_RET_STS_ERROR;
8215: OE_MSG_PUB.Count_And_Get
8216: ( p_count => x_msg_count
8217: , p_data => x_msg_data
8211: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(p_hold_id));
8212: fnd_message.set_name('ONT', 'ONT_HOLDS_SYSTEM_CHECK');
8213: OE_MSG_PUB.ADD;
8214: x_return_status := FND_API.G_RET_STS_ERROR;
8215: OE_MSG_PUB.Count_And_Get
8216: ( p_count => x_msg_count
8217: , p_data => x_msg_data
8218: );
8219: RETURN;
8235:
8236: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
8237: fnd_message.set_token('ACTION', l_msg_token);
8238:
8239: OE_MSG_PUB.ADD;
8240: -- RAISE FND_API.G_EXC_ERROR;
8241: x_return_status := FND_API.G_RET_STS_ERROR;
8242:
8243: OE_MSG_PUB.Count_And_Get
8239: OE_MSG_PUB.ADD;
8240: -- RAISE FND_API.G_EXC_ERROR;
8241: x_return_status := FND_API.G_RET_STS_ERROR;
8242:
8243: OE_MSG_PUB.Count_And_Get
8244: ( p_count => x_msg_count
8245: , p_data => x_msg_data
8246: );
8247:
8307: END LOOP;
8308:
8309: x_return_status := FND_API.G_RET_STS_SUCCESS;
8310: -- Get message count and data
8311: OE_MSG_PUB.Count_And_Get
8312: ( p_count => x_msg_count
8313: , p_data => x_msg_data
8314: );
8315:
8318: EXCEPTION /* Procedure exception handler */
8319:
8320: WHEN FND_API.G_EXC_ERROR THEN
8321: x_return_status := FND_API.G_RET_STS_ERROR ;
8322: OE_MSG_PUB.Count_And_Get
8323: ( p_count => x_msg_count,
8324: p_data => x_msg_data
8325: );
8326: ROLLBACK TO SAVEPOINT process_release_holds_orders;
8326: ROLLBACK TO SAVEPOINT process_release_holds_orders;
8327:
8328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8329: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8330: OE_MSG_PUB.Count_And_Get
8331: ( p_count => x_msg_count,
8332: p_data => x_msg_data
8333: );
8334: ROLLBACK TO SAVEPOINT process_release_holds_orders;
8334: ROLLBACK TO SAVEPOINT process_release_holds_orders;
8335:
8336: WHEN OTHERS THEN
8337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8338: IF OE_MSG_PUB.Check_Msg_Level
8339: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8340: THEN
8341: OE_MSG_PUB.Add_Exc_Msg
8342: (G_PKG_NAME,
8335:
8336: WHEN OTHERS THEN
8337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8338: IF OE_MSG_PUB.Check_Msg_Level
8339: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8340: THEN
8341: OE_MSG_PUB.Add_Exc_Msg
8342: (G_PKG_NAME,
8343: l_api_name
8337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8338: IF OE_MSG_PUB.Check_Msg_Level
8339: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8340: THEN
8341: OE_MSG_PUB.Add_Exc_Msg
8342: (G_PKG_NAME,
8343: l_api_name
8344: );
8345: END IF;
8342: (G_PKG_NAME,
8343: l_api_name
8344: );
8345: END IF;
8346: OE_MSG_PUB.Count_And_Get
8347: ( p_count => x_msg_count,
8348: p_data => x_msg_data);
8349: ROLLBACK TO SAVEPOINT process_release_holds_orders;
8350:
8406: If l_hold_id = 1 AND (l_hold_entity_code ='C' OR l_hold_entity_code = 'B') then
8407: OE_DEBUG_PUB.Add('Bug 1946783 Credit Hold should be released from AR',1);
8408:
8409: fnd_message.set_name('ONT', 'OE_CC_AR_HOLD_NOT_RELEASED');
8410: OE_MSG_PUB.ADD;
8411: RAISE FND_API.G_EXC_ERROR;
8412: x_return_status := FND_API.G_RET_STS_ERROR;
8413: OE_MSG_PUB.Count_And_Get
8414: ( p_count => x_msg_count
8409: fnd_message.set_name('ONT', 'OE_CC_AR_HOLD_NOT_RELEASED');
8410: OE_MSG_PUB.ADD;
8411: RAISE FND_API.G_EXC_ERROR;
8412: x_return_status := FND_API.G_RET_STS_ERROR;
8413: OE_MSG_PUB.Count_And_Get
8414: ( p_count => x_msg_count
8415: , p_data => x_msg_data
8416: );
8417: return;
8427: ) = 'N' THEN
8428: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(l_hold_id));
8429: fnd_message.set_name('ONT', 'ONT_HOLDS_SYSTEM_CHECK');
8430: fnd_message.set_token('ACTION', 'Release');
8431: OE_MSG_PUB.ADD;
8432: x_return_status := FND_API.G_RET_STS_ERROR;
8433: OE_MSG_PUB.Count_And_Get
8434: ( p_count => x_msg_count
8435: , p_data => x_msg_data
8429: fnd_message.set_name('ONT', 'ONT_HOLDS_SYSTEM_CHECK');
8430: fnd_message.set_token('ACTION', 'Release');
8431: OE_MSG_PUB.ADD;
8432: x_return_status := FND_API.G_RET_STS_ERROR;
8433: OE_MSG_PUB.Count_And_Get
8434: ( p_count => x_msg_count
8435: , p_data => x_msg_data
8436: );
8437: return;
8453:
8454: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
8455: fnd_message.set_token('ACTION', l_msg_token);
8456:
8457: OE_MSG_PUB.ADD;
8458: RAISE FND_API.G_EXC_ERROR;
8459: x_return_status := FND_API.G_RET_STS_ERROR;
8460: OE_MSG_PUB.Count_And_Get
8461: ( p_count => x_msg_count
8456:
8457: OE_MSG_PUB.ADD;
8458: RAISE FND_API.G_EXC_ERROR;
8459: x_return_status := FND_API.G_RET_STS_ERROR;
8460: OE_MSG_PUB.Count_And_Get
8461: ( p_count => x_msg_count
8462: , p_data => x_msg_data
8463: );
8464: return;
8503: END IF;
8504:
8505: x_return_status := FND_API.G_RET_STS_SUCCESS;
8506: -- Get message count and data
8507: OE_MSG_PUB.Count_And_Get
8508: ( p_count => x_msg_count
8509: , p_data => x_msg_data
8510: );
8511:
8513: EXCEPTION /* Procedure exception handler */
8514:
8515: WHEN FND_API.G_EXC_ERROR THEN
8516: x_return_status := FND_API.G_RET_STS_ERROR ;
8517: OE_MSG_PUB.Count_And_Get
8518: ( p_count => x_msg_count,
8519: p_data => x_msg_data
8520: );
8521:
8520: );
8521:
8522: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8524: OE_MSG_PUB.Count_And_Get
8525: ( p_count => x_msg_count,
8526: p_data => x_msg_data
8527: );
8528:
8527: );
8528:
8529: WHEN OTHERS THEN
8530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8531: IF OE_MSG_PUB.Check_Msg_Level
8532: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8533: THEN
8534: OE_MSG_PUB.Add_Exc_Msg
8535: (G_PKG_NAME,
8528:
8529: WHEN OTHERS THEN
8530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8531: IF OE_MSG_PUB.Check_Msg_Level
8532: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8533: THEN
8534: OE_MSG_PUB.Add_Exc_Msg
8535: (G_PKG_NAME,
8536: l_api_name
8530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8531: IF OE_MSG_PUB.Check_Msg_Level
8532: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8533: THEN
8534: OE_MSG_PUB.Add_Exc_Msg
8535: (G_PKG_NAME,
8536: l_api_name
8537: );
8538: END IF;
8535: (G_PKG_NAME,
8536: l_api_name
8537: );
8538: END IF;
8539: OE_MSG_PUB.Count_And_Get
8540: ( p_count => x_msg_count,
8541: p_data => x_msg_data);
8542:
8543: end process_release_source;
8680: WHEN NO_DATA_FOUND then
8681: null; -- its ok if there is not holds on the orignal line
8682: WHEN FND_API.G_EXC_ERROR THEN
8683: x_return_status := FND_API.G_RET_STS_ERROR;
8684: OE_MSG_PUB.Count_And_Get
8685: ( p_count => x_msg_count
8686: , p_data => x_msg_data
8687: );
8688: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8686: , p_data => x_msg_data
8687: );
8688: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8690: OE_MSG_PUB.Count_And_Get
8691: ( p_count => x_msg_count
8692: , p_data => x_msg_data
8693: );
8694: WHEN OTHERS THEN
8692: , p_data => x_msg_data
8693: );
8694: WHEN OTHERS THEN
8695: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8696: IF OE_MSG_PUB.Check_Msg_Level
8697: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8698: THEN
8699: OE_MSG_PUB.Add_Exc_Msg
8700: ( G_PKG_NAME,
8693: );
8694: WHEN OTHERS THEN
8695: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8696: IF OE_MSG_PUB.Check_Msg_Level
8697: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8698: THEN
8699: OE_MSG_PUB.Add_Exc_Msg
8700: ( G_PKG_NAME,
8701: l_api_name);
8695: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8696: IF OE_MSG_PUB.Check_Msg_Level
8697: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8698: THEN
8699: OE_MSG_PUB.Add_Exc_Msg
8700: ( G_PKG_NAME,
8701: l_api_name);
8702: END IF;
8703: OE_MSG_PUB.Count_And_Get
8699: OE_MSG_PUB.Add_Exc_Msg
8700: ( G_PKG_NAME,
8701: l_api_name);
8702: END IF;
8703: OE_MSG_PUB.Count_And_Get
8704: ( p_count => x_msg_count
8705: , p_data => x_msg_data
8706: );
8707:
8752: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(p_hold_source_rec.hold_id));
8753: l_msg_token := 'APPLY(System Hold)';
8754: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
8755: fnd_message.set_token('ACTION', l_msg_token);
8756: OE_MSG_PUB.ADD;
8757: x_return_status := FND_API.G_RET_STS_ERROR;
8758: OE_MSG_PUB.Count_And_Get
8759: ( p_count => x_msg_count
8760: , p_data => x_msg_data
8754: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
8755: fnd_message.set_token('ACTION', l_msg_token);
8756: OE_MSG_PUB.ADD;
8757: x_return_status := FND_API.G_RET_STS_ERROR;
8758: OE_MSG_PUB.Count_And_Get
8759: ( p_count => x_msg_count
8760: , p_data => x_msg_data
8761: );
8762: RETURN;
8786: fnd_message.set_name('ONT','ONT_APPLY');
8787: l_msg_token := fnd_message.get;
8788: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
8789: fnd_message.set_token('ACTION', l_msg_token);
8790: OE_MSG_PUB.ADD;
8791: x_return_status := FND_API.G_RET_STS_ERROR;
8792: OE_MSG_PUB.Count_And_Get
8793: ( p_count => x_msg_count
8794: , p_data => x_msg_data
8788: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
8789: fnd_message.set_token('ACTION', l_msg_token);
8790: OE_MSG_PUB.ADD;
8791: x_return_status := FND_API.G_RET_STS_ERROR;
8792: OE_MSG_PUB.Count_And_Get
8793: ( p_count => x_msg_count
8794: , p_data => x_msg_data
8795: );
8796: RETURN;
9242: and lookup_code = p_activity_name;
9243:
9244: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
9245: fnd_message.set_token('WF_ACT', l_user_activity_name);
9246: OE_MSG_PUB.ADD;
9247: oe_debug_pub.add(' Hold Not applied for All requested records');
9248: RAISE FND_API.G_EXC_ERROR;
9249: ELSIF l_sql_rowcount > 0 THEN
9250: SELECT count(*)
9275: and lookup_code = p_activity_name;
9276:
9277: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
9278: fnd_message.set_token('WF_ACT', l_user_activity_name);
9279: OE_MSG_PUB.ADD;
9280: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
9281: END IF;
9282: END IF;
9283: END IF;
9564: and lookup_code = p_activity_name;
9565:
9566: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
9567: fnd_message.set_token('WF_ACT', l_user_activity_name);
9568: OE_MSG_PUB.ADD;
9569: oe_debug_pub.add(' Hold Not applied for All requested records');
9570: RAISE FND_API.G_EXC_ERROR;
9571: ELSIF l_sql_rowcount > 0 THEN
9572: SELECT count(*)
9599: and lookup_code = p_activity_name;
9600:
9601: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
9602: fnd_message.set_token('WF_ACT', l_user_activity_name);
9603: OE_MSG_PUB.ADD;
9604: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
9605: END IF;
9606: END IF;
9607: END IF;
9781: and lookup_code = p_activity_name;
9782:
9783: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
9784: fnd_message.set_token('WF_ACT', l_user_activity_name);
9785: OE_MSG_PUB.ADD;
9786: oe_debug_pub.add(' Hold Not applied for All requested records');
9787: RAISE FND_API.G_EXC_ERROR;
9788: ELSIF l_sql_rowcount > 0 THEN
9789: SELECT count(*)
9814: and lookup_code = p_activity_name;
9815:
9816: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
9817: fnd_message.set_token('WF_ACT', l_user_activity_name);
9818: OE_MSG_PUB.ADD;
9819: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
9820: END IF;
9821: END IF;
9822: END IF;
9994: and lookup_code = p_activity_name;
9995:
9996: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
9997: fnd_message.set_token('WF_ACT', l_user_activity_name);
9998: OE_MSG_PUB.ADD;
9999: oe_debug_pub.add(' Hold Not applied for All requested records');
10000: RAISE FND_API.G_EXC_ERROR;
10001: ELSIF l_sql_rowcount > 0 THEN
10002: SELECT count(*)
10026: and lookup_code = p_activity_name;
10027:
10028: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
10029: fnd_message.set_token('WF_ACT', l_user_activity_name);
10030: OE_MSG_PUB.ADD;
10031: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
10032: END IF;
10033: END IF;
10034: END IF;
10208: and lookup_code = p_activity_name;
10209:
10210: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
10211: fnd_message.set_token('WF_ACT', l_user_activity_name);
10212: OE_MSG_PUB.ADD;
10213: oe_debug_pub.add(' Hold Not applied for All requested records');
10214: RAISE FND_API.G_EXC_ERROR;
10215: ELSIF l_sql_rowcount > 0 THEN
10216: SELECT count(*)
10241: and lookup_code = p_activity_name;
10242:
10243: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
10244: fnd_message.set_token('WF_ACT', l_user_activity_name);
10245: OE_MSG_PUB.ADD;
10246: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
10247: END IF;
10248: END IF;
10249: END IF;
10443: and lookup_code = p_activity_name;
10444:
10445: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
10446: fnd_message.set_token('WF_ACT', l_user_activity_name);
10447: OE_MSG_PUB.ADD;
10448: oe_debug_pub.add(' Hold Not applied for All requested records');
10449: RAISE FND_API.G_EXC_ERROR;
10450: ELSIF l_sql_rowcount > 0 THEN
10451: SELECT count(*)
10476: and lookup_code = p_activity_name;
10477:
10478: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
10479: fnd_message.set_token('WF_ACT', l_user_activity_name);
10480: OE_MSG_PUB.ADD;
10481: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
10482: END IF;
10483: END IF;
10484: END IF;
10956: and lookup_code = p_activity_name;
10957:
10958: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
10959: fnd_message.set_token('WF_ACT', l_user_activity_name);
10960: OE_MSG_PUB.ADD;
10961: oe_debug_pub.add(' Hold Not applied for All requested records');
10962: RAISE FND_API.G_EXC_ERROR;
10963: ELSIF l_sql_rowcount > 0 THEN
10964: SELECT count(*)
10989: and lookup_code = p_activity_name;
10990:
10991: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
10992: fnd_message.set_token('WF_ACT', l_user_activity_name);
10993: OE_MSG_PUB.ADD;
10994: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
10995: END IF;
10996: END IF;
10997: END IF;
11261: and lookup_code = p_activity_name;
11262:
11263: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
11264: fnd_message.set_token('WF_ACT', l_user_activity_name);
11265: OE_MSG_PUB.ADD;
11266: oe_debug_pub.add(' Hold Not applied for All requested records');
11267: RAISE FND_API.G_EXC_ERROR;
11268: ELSIF l_sql_rowcount > 0 THEN
11269: SELECT count(*)
11294: and lookup_code = p_activity_name;
11295:
11296: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
11297: fnd_message.set_token('WF_ACT', l_user_activity_name);
11298: OE_MSG_PUB.ADD;
11299: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
11300: END IF;
11301: END IF;
11302: END IF;
11475: and lookup_code = p_activity_name;
11476:
11477: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
11478: fnd_message.set_token('WF_ACT', l_user_activity_name);
11479: OE_MSG_PUB.ADD;
11480: oe_debug_pub.add(' Hold Not applied for All requested records');
11481: RAISE FND_API.G_EXC_ERROR;
11482: ELSIF l_sql_rowcount > 0 THEN
11483: SELECT count(*)
11508: and lookup_code = p_activity_name;
11509:
11510: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
11511: fnd_message.set_token('WF_ACT', l_user_activity_name);
11512: OE_MSG_PUB.ADD;
11513: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
11514: END IF;
11515: END IF;
11516: END IF;
11692: and lookup_code = p_activity_name;
11693:
11694: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
11695: fnd_message.set_token('WF_ACT', l_user_activity_name);
11696: OE_MSG_PUB.ADD;
11697: oe_debug_pub.add(' Hold Not applied for All requested records');
11698: RAISE FND_API.G_EXC_ERROR;
11699: ELSIF l_sql_rowcount > 0 THEN
11700: SELECT count(*)
11725: and lookup_code = p_activity_name;
11726:
11727: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
11728: fnd_message.set_token('WF_ACT', l_user_activity_name);
11729: OE_MSG_PUB.ADD;
11730: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
11731: END IF;
11732: END IF;
11733: END IF;
12017: and lookup_code = p_activity_name;
12018:
12019: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
12020: fnd_message.set_token('WF_ACT', l_user_activity_name);
12021: OE_MSG_PUB.ADD;
12022: oe_debug_pub.add(' Hold Not applied for All requested records');
12023: RAISE FND_API.G_EXC_ERROR;
12024: ELSIF l_sql_rowcount > 0 THEN
12025: SELECT count(*)
12050: and lookup_code = p_activity_name;
12051:
12052: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
12053: fnd_message.set_token('WF_ACT', l_user_activity_name);
12054: OE_MSG_PUB.ADD;
12055: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
12056: END IF;
12057: END IF;
12058: END IF;
12231: and lookup_code = p_activity_name;
12232:
12233: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
12234: fnd_message.set_token('WF_ACT', l_user_activity_name);
12235: OE_MSG_PUB.ADD;
12236: oe_debug_pub.add(' Hold Not applied for All requested records');
12237: RAISE FND_API.G_EXC_ERROR;
12238: ELSIF l_sql_rowcount > 0 THEN
12239: SELECT count(*)
12264: and lookup_code = p_activity_name;
12265:
12266: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
12267: fnd_message.set_token('WF_ACT', l_user_activity_name);
12268: OE_MSG_PUB.ADD;
12269: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
12270: END IF;
12271: END IF;
12272: END IF;
12445: and lookup_code = p_activity_name;
12446:
12447: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
12448: fnd_message.set_token('WF_ACT', l_user_activity_name);
12449: OE_MSG_PUB.ADD;
12450: oe_debug_pub.add(' Hold Not applied for All requested records');
12451: RAISE FND_API.G_EXC_ERROR;
12452: ELSIF l_sql_rowcount > 0 THEN
12453: SELECT count(*)
12478: and lookup_code = p_activity_name;
12479:
12480: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
12481: fnd_message.set_token('WF_ACT', l_user_activity_name);
12482: OE_MSG_PUB.ADD;
12483: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
12484: END IF;
12485: END IF;
12486: END IF;
12656: and lookup_code = p_activity_name;
12657:
12658: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
12659: fnd_message.set_token('WF_ACT', l_user_activity_name);
12660: OE_MSG_PUB.ADD;
12661: oe_debug_pub.add(' Hold Not applied for All requested records');
12662: RAISE FND_API.G_EXC_ERROR;
12663: ELSIF l_sql_rowcount > 0 THEN
12664: SELECT count(*)
12688: and lookup_code = p_activity_name;
12689:
12690: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
12691: fnd_message.set_token('WF_ACT', l_user_activity_name);
12692: OE_MSG_PUB.ADD;
12693: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
12694: END IF;
12695: END IF;
12696: END IF;
12842: and lookup_code = p_activity_name;
12843:
12844: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
12845: fnd_message.set_token('WF_ACT', l_user_activity_name);
12846: OE_MSG_PUB.ADD;
12847: oe_debug_pub.add(' Hold Not applied for All requested records');
12848: RAISE FND_API.G_EXC_ERROR;
12849: ELSIF l_sql_rowcount > 0 THEN
12850: x_is_hold_applied := TRUE;
12876: and lookup_code = p_activity_name;
12877:
12878: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
12879: fnd_message.set_token('WF_ACT', l_user_activity_name);
12880: OE_MSG_PUB.ADD;
12881: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
12882: END IF;
12883: END IF;
12884: END IF;
13099: and lookup_code = p_activity_name;
13100:
13101: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
13102: fnd_message.set_token('WF_ACT', l_user_activity_name);
13103: OE_MSG_PUB.ADD;
13104: oe_debug_pub.add(' Hold Not applied for All requested records');
13105: RAISE FND_API.G_EXC_ERROR;
13106: ELSIF l_sql_rowcount > 0 THEN
13107: SELECT count(*)
13129: and lookup_code = p_activity_name;
13130:
13131: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
13132: fnd_message.set_token('WF_ACT', l_user_activity_name);
13133: OE_MSG_PUB.ADD;
13134: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
13135: END IF;
13136: END IF;
13137: END IF;
13572: and lookup_code = p_activity_name;
13573:
13574: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
13575: fnd_message.set_token('WF_ACT', l_user_activity_name);
13576: OE_MSG_PUB.ADD;
13577: oe_debug_pub.add(' Hold Not applied for All requested records');
13578: RAISE FND_API.G_EXC_ERROR;
13579: ELSIF l_sql_rowcount > 0 THEN
13580: SELECT count(*)
13604: and lookup_code = p_activity_name;
13605:
13606: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
13607: fnd_message.set_token('WF_ACT', l_user_activity_name);
13608: OE_MSG_PUB.ADD;
13609: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
13610: END IF;
13611: END IF;
13612: END IF;
13784: and lookup_code = p_activity_name;
13785:
13786: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
13787: fnd_message.set_token('WF_ACT', l_user_activity_name);
13788: OE_MSG_PUB.ADD;
13789: oe_debug_pub.add(' Hold Not applied for All requested records');
13790: RAISE FND_API.G_EXC_ERROR;
13791: ELSIF l_sql_rowcount > 0 THEN
13792: SELECT count(*)
13816: and lookup_code = p_activity_name;
13817:
13818: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
13819: fnd_message.set_token('WF_ACT', l_user_activity_name);
13820: OE_MSG_PUB.ADD;
13821: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
13822: END IF;
13823: END IF;
13824: END IF;
13995: and lookup_code = p_activity_name;
13996:
13997: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
13998: fnd_message.set_token('WF_ACT', l_user_activity_name);
13999: OE_MSG_PUB.ADD;
14000: oe_debug_pub.add(' Hold Not applied for All requested records');
14001: RAISE FND_API.G_EXC_ERROR;
14002: ELSIF l_sql_rowcount > 0 THEN
14003: SELECT count(*)
14027: and lookup_code = p_activity_name;
14028:
14029: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
14030: fnd_message.set_token('WF_ACT', l_user_activity_name);
14031: OE_MSG_PUB.ADD;
14032: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
14033: END IF;
14034: END IF;
14035: END IF;
14207: and lookup_code = p_activity_name;
14208:
14209: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
14210: fnd_message.set_token('WF_ACT', l_user_activity_name);
14211: OE_MSG_PUB.ADD;
14212: RAISE FND_API.G_EXC_ERROR;
14213: ELSIF l_sql_rowcount > 0 THEN
14214: SELECT count(*)
14215: into l_parent_count
14238: and lookup_code = p_activity_name;
14239:
14240: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
14241: fnd_message.set_token('WF_ACT', l_user_activity_name);
14242: OE_MSG_PUB.ADD;
14243:
14244: END IF;
14245: END IF;
14246: END IF;
15125: EXCEPTION
15126: WHEN FND_API.G_EXC_ERROR THEN
15127: --ROLLBACK TO APPLY_HOLDS_PUB;
15128: x_return_status := FND_API.G_RET_STS_ERROR;
15129: OE_MSG_PUB.Count_And_Get
15130: ( p_count => x_msg_count
15131: , p_data => x_msg_data
15132: );
15133: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
15132: );
15133: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
15134: --ROLLBACK TO APPLY_HOLDS_PUB;
15135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
15136: OE_MSG_PUB.Count_And_Get
15137: ( p_count => x_msg_count
15138: , p_data => x_msg_data
15139: );
15140: WHEN OTHERS THEN
15139: );
15140: WHEN OTHERS THEN
15141: --ROLLBACK TO APPLY_HOLDS_PUB;
15142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
15143: IF OE_MSG_PUB.Check_Msg_Level
15144: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
15145: THEN
15146: OE_MSG_PUB.Add_Exc_Msg
15147: ( G_PKG_NAME
15140: WHEN OTHERS THEN
15141: --ROLLBACK TO APPLY_HOLDS_PUB;
15142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
15143: IF OE_MSG_PUB.Check_Msg_Level
15144: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
15145: THEN
15146: OE_MSG_PUB.Add_Exc_Msg
15147: ( G_PKG_NAME
15148: , l_api_name
15142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
15143: IF OE_MSG_PUB.Check_Msg_Level
15144: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
15145: THEN
15146: OE_MSG_PUB.Add_Exc_Msg
15147: ( G_PKG_NAME
15148: , l_api_name
15149: );
15150: END IF;
15147: ( G_PKG_NAME
15148: , l_api_name
15149: );
15150: END IF;
15151: OE_MSG_PUB.Count_And_Get
15152: ( p_count => x_msg_count
15153: , p_data => x_msg_data
15154: );
15155: