eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_HOLDS_PVT dependencies on FND_MESSAGE

Line 1238: FND_MESSAGE.SET_NAME('ONT', 'OE_NO_HOLD_ALL_LINES');

1234: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
1235: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 1239: FND_MESSAGE.SET_TOKEN('WF_ACT', l_user_activity_name);

1235: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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:

Line 1276: FND_MESSAGE.SET_NAME('ONT', 'OE_NO_HOLD_FEW_LINES');

1272: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
1273: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 1277: FND_MESSAGE.SET_TOKEN('WF_ACT', l_user_activity_name);

1273: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 1538: FND_MESSAGE.SET_NAME('ONT', 'OE_NO_HOLD_ALL_LINES');

1534: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
1535: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 1539: FND_MESSAGE.SET_TOKEN('WF_ACT',l_user_activity_name);

1535: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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:

Line 1576: FND_MESSAGE.SET_NAME('ONT', 'OE_NO_HOLD_FEW_LINES');

1572: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
1573: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 1577: FND_MESSAGE.SET_TOKEN('WF_ACT',l_user_activity_name);

1573: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 2202: FND_MESSAGE.SET_NAME('ONT','OE_ORDER_HOLD_INVALID_CRITERIA');

2198: (p_hold_source_rec.hold_entity_code = 'O' AND
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

Line 2211: FND_MESSAGE.SET_NAME('ONT','OE_LINE_HOLD_INVALID_CRITERIA');

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;

Line 2241: FND_MESSAGE.SET_NAME('ONT','OE_LINE_HOLD_INVALID_CRITERIA');

2237: NULL;
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

Line 2254: FND_MESSAGE.SET_NAME('ONT','OE_ORDER_HOLD_INVALID_CRITERIA');

2250: NULL;
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;

Line 2271: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ENTITY_CONBINATION');

2267: if p_hold_source_rec.hold_entity_code = 'I' then
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

Line 2279: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ENTITY_CONBINATION');

2275: --ER# 13331078 start
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

Line 2288: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ENTITY_CONBINATION');

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

Line 2295: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ENTITY_CONBINATION');

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
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

Line 2303: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ENTITY_CONBINATION');

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
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

Line 2311: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ENTITY_CONBINATION');

2307: --ER#7479609 start
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

Line 2318: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ENTITY_CONBINATION');

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
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

Line 2325: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ENTITY_CONBINATION');

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
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

Line 2333: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ENTITY_CONBINATION');

2329: --ER# 11824468 start
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

Line 2342: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ENTITY_CONBINATION');

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

Line 2350: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ENTITY_CONBINATION');

2346: --ER#12571983 end
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

Line 2357: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ENTITY_CONBINATION');

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
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

Line 2364: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ENTITY_CONBINATION');

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
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

Line 2509: FND_MESSAGE.SET_NAME('ONT', 'OE_MISSING_ENTITY_CODE');

2505: AND lookup_type = 'SHIP_METHOD';
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:

Line 2670: FND_MESSAGE.SET_NAME('ONT', 'OE_MISSING_ENTITY_CODE');

2666: where currency_code = p_hold_source_rec.hold_entity_id2;
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;

Line 2683: FND_MESSAGE.SET_NAME('ONT', 'OE_MISSING_ENTITY_ID');

2679: null;
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

Line 2690: FND_MESSAGE.SET_NAME('ONT', 'OE_ENTITY_NOT_ON_ORDER_OR_LINE');

2686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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;

Line 2723: FND_MESSAGE.SET_NAME('ONT', 'OE_MISSING_HOLD_ID');

2719:
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:

Line 2744: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_HOLD_ID');

2740: EXCEPTION
2741:
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:

Line 2745: FND_MESSAGE.SET_TOKEN('HOLD_ID',p_hold_id);

2741:
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

Line 2779: FND_MESSAGE.SET_NAME('FND','MO_ORG_REQUIRED');

2775: IF l_org_id IS NULL THEN
2776: -- org_id is null, raise an error.
2777: oe_debug_pub.add('Org_Id is NULL',1);
2778: x_return_status := FND_API.G_RET_STS_ERROR;
2779: FND_MESSAGE.SET_NAME('FND','MO_ORG_REQUIRED');
2780: FND_MSG_PUB.ADD;
2781: RAISE FND_API.G_EXC_ERROR;
2782: END IF;
2783:

Line 2810: --FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD');

2806:
2807: IF l_count > 0 THEN
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;

Line 2811: FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD_SOURCE');

2807: IF l_count > 0 THEN
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;

Line 2841: --FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD');

2837:
2838: IF l_count > 0 THEN
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;

Line 2842: FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD_SOURCE');

2838: IF l_count > 0 THEN
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;

Line 2869: --FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD');

2865:
2866: IF l_count > 0 THEN
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;

Line 2870: FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD_SOURCE');

2866: IF l_count > 0 THEN
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;

Line 3021: FND_MESSAGE.SET_NAME('FND','MO_ORG_REQUIRED');

3017: IF l_org_id IS NULL THEN
3018: -- org_id is null, raise an error.
3019: oe_debug_pub.add('Org_Id is NULL',1);
3020: x_return_status := FND_API.G_RET_STS_ERROR;
3021: FND_MESSAGE.SET_NAME('FND','MO_ORG_REQUIRED');
3022: FND_MSG_PUB.ADD;
3023: RAISE FND_API.G_EXC_ERROR;
3024: END IF;
3025:

Line 3051: --FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD');

3047:
3048: IF l_count > 0 THEN
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;

Line 3052: FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD_SOURCE');

3048: IF l_count > 0 THEN
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;

Line 3080: --FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD');

3076:
3077: IF l_count > 0 THEN
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;

Line 3081: FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD_SOURCE');

3077: IF l_count > 0 THEN
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;

Line 3112: --FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD');

3108:
3109: IF l_count > 0 THEN
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;

Line 3113: FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD_SOURCE');

3109: IF l_count > 0 THEN
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;

Line 3351: FND_MESSAGE.SET_NAME('FND','MO_ORG_REQUIRED');

3347: IF l_org_id IS NULL THEN
3348: -- org_id is null, raise an error.
3349: oe_debug_pub.add('Org_Id is NULL',1);
3350: x_return_status := FND_API.G_RET_STS_ERROR;
3351: FND_MESSAGE.SET_NAME('FND','MO_ORG_REQUIRED');
3352: FND_MSG_PUB.ADD;
3353: RAISE FND_API.G_EXC_ERROR;
3354: END IF;
3355:

Line 5434: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_REASON_CODE');

5430:
5431: WHEN NO_DATA_FOUND THEN
5432: oe_debug_pub.add('Invalid Reason Code:' ||
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;

Line 5435: FND_MESSAGE.SET_TOKEN('REASON_CODE',

5431: WHEN NO_DATA_FOUND THEN
5432: oe_debug_pub.add('Invalid Reason Code:' ||
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:

Line 5611: FND_MESSAGE.SET_NAME('ONT', 'OE_MISSING_HOLD_SOURCE');

5607: p_hold_source_rec.line_id,1);
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;

Line 5630: FND_MESSAGE.SET_NAME('ONT', 'OE_MISSING_HOLD_SOURCE');

5626: to_char(p_hold_source_rec.hold_entity_id) ,1);
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;

Line 5701: FND_MESSAGE.SET_NAME('ONT', 'OE_ENTER_HEADER_OR_LINE_ID');

5697: BEGIN
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

Line 5722: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_HEADER_ID');

5718: WHEN NO_DATA_FOUND THEN
5719: -- Modified below code for bug 7112725
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');

Line 5723: FND_MESSAGE.SET_TOKEN('HEADER_ID',p_header_id);

5719: -- Modified below code for bug 7112725
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);

Line 5726: FND_MESSAGE.SET_NAME('ONT', 'OE_COGS_INVALID_LINE_ID');

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;
5729: END IF;
5730: oe_debug_pub.add('Return Status : ' || x_return_status, 5);

Line 5727: FND_MESSAGE.SET_TOKEN('LINE_ID',p_line_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;
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

Line 5812: FND_MESSAGE.SET_NAME('ONT', 'OE_ENTER_HEADER_OR_LINE_ID');

5808:
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;

Line 5996: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');

5992: x_msg_data => x_msg_data) = 'N' THEN
5993:
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

Line 5997: fnd_message.set_token('ACTION', l_msg_token);

5993:
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

Line 6028: fnd_message.set_name('ONT','ONT_APPLY');

6024: ,x_msg_count => x_msg_count
6025: ,x_msg_data => x_msg_data
6026: ) = 'N' THEN
6027: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(p_hold_id));
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;

Line 6029: l_msg_token := fnd_message.get;

6025: ,x_msg_data => x_msg_data
6026: ) = 'N' THEN
6027: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(p_hold_id));
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;

Line 6030: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');

6026: ) = 'N' THEN
6027: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(p_hold_id));
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

Line 6031: fnd_message.set_token('ACTION', l_msg_token);

6027: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(p_hold_id));
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

Line 6188: fnd_message.set_name('ONT', 'OE_NO_HOLD_FOR_ACTIVITY');

6184: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
6185: and lookup_code = l_wf_activity_name;
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;

Line 6189: fnd_message.set_token('WF_ACT',l_user_activity_name);

6185: and lookup_code = l_wf_activity_name;
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

Line 6195: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');

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
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;

Line 6196: fnd_message.set_token('WF_ACT',l_user_activity_name);

6192: RAISE FND_API.G_EXC_ERROR;
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

Line 6202: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');

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
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

Line 6203: fnd_message.set_token('WF_ACT',l_user_activity_name);

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
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.

Line 6349: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');

6345: ,x_msg_data => x_msg_data
6346: ) = 'N' THEN
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

Line 6350: fnd_message.set_token('ACTION', l_msg_token);

6346: ) = 'N' THEN
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

Line 6382: fnd_message.set_name('ONT','ONT_RELEASE');

6378: ,x_msg_count => x_msg_count
6379: ,x_msg_data => x_msg_data
6380: ) = 'N' THEN
6381: OE_DEBUG_PUB.Add('Not authorize to Release this Hold:'|| to_char(p_hold_source_rec.hold_id));
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;

Line 6383: l_msg_token := fnd_message.get;

6379: ,x_msg_data => x_msg_data
6380: ) = 'N' THEN
6381: OE_DEBUG_PUB.Add('Not authorize to Release this Hold:'|| to_char(p_hold_source_rec.hold_id));
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;

Line 6384: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');

6380: ) = 'N' THEN
6381: OE_DEBUG_PUB.Add('Not authorize to Release this Hold:'|| to_char(p_hold_source_rec.hold_id));
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

Line 6385: fnd_message.set_token('ACTION', l_msg_token);

6381: OE_DEBUG_PUB.Add('Not authorize to Release this Hold:'|| to_char(p_hold_source_rec.hold_id));
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

Line 6503: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');

6499: ,x_msg_data => x_msg_data
6500: ) = 'N' THEN
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

Line 6504: fnd_message.set_token('ACTION', l_msg_token);

6500: ) = 'N' THEN
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

Line 6535: fnd_message.set_name('ONT','ONT_RELEASE');

6531: ,x_msg_count => x_msg_count
6532: ,x_msg_data => x_msg_data
6533: ) = 'N' THEN
6534: OE_DEBUG_PUB.Add('Not authorize to Release this Hold:'|| to_char(p_hold_id));
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;

Line 6536: l_msg_token := fnd_message.get;

6532: ,x_msg_data => x_msg_data
6533: ) = 'N' THEN
6534: OE_DEBUG_PUB.Add('Not authorize to Release this Hold:'|| to_char(p_hold_id));
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;

Line 6537: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');

6533: ) = 'N' THEN
6534: OE_DEBUG_PUB.Add('Not authorize to Release this Hold:'|| to_char(p_hold_id));
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

Line 6538: fnd_message.set_token('ACTION', l_msg_token);

6534: OE_DEBUG_PUB.Add('Not authorize to Release this Hold:'|| to_char(p_hold_id));
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

Line 6733: fnd_message.set_name('ONT', 'ONT_HOLDS_SYSTEM_CHECK');

6729: x_msg_count => x_msg_count,
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

Line 6754: fnd_message.set_name('ONT','ONT_APPLY');

6750: ,x_msg_data => x_msg_data
6751: ) = 'N' THEN
6752: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(p_hold_id));
6753:
6754: fnd_message.set_name('ONT','ONT_APPLY');
6755: l_msg_token := fnd_message.get;
6756:
6757: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
6758: fnd_message.set_token('ACTION', l_msg_token);

Line 6755: l_msg_token := fnd_message.get;

6751: ) = 'N' THEN
6752: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(p_hold_id));
6753:
6754: fnd_message.set_name('ONT','ONT_APPLY');
6755: l_msg_token := fnd_message.get;
6756:
6757: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
6758: fnd_message.set_token('ACTION', l_msg_token);
6759:

Line 6757: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');

6753:
6754: fnd_message.set_name('ONT','ONT_APPLY');
6755: l_msg_token := fnd_message.get;
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;

Line 6758: fnd_message.set_token('ACTION', l_msg_token);

6754: fnd_message.set_name('ONT','ONT_APPLY');
6755: l_msg_token := fnd_message.get;
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;

Line 6870: fnd_message.set_name('ONT', 'OE_NO_HOLD_FOR_ACTIVITY');

6866: and lookup_code = l_activity_name;
6867:
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;

Line 6871: fnd_message.set_token('WF_ACT',l_user_activity_name);

6867:
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

Line 6877: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');

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
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;

Line 6878: fnd_message.set_token('WF_ACT',l_user_activity_name);

6874: RAISE FND_API.G_EXC_ERROR;
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

Line 6884: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');

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
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

Line 6885: fnd_message.set_token('WF_ACT',l_user_activity_name);

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
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.

Line 6982: fnd_message.set_name('ONT', 'ONT_HOLDS_SYSTEM_CHECK');

6978: , x_msg_count => x_msg_count
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

Line 7004: fnd_message.set_name('ONT','ONT_APPLY');

7000: , x_msg_data => x_msg_data
7001: ) = 'N' THEN
7002: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(p_hold_id));
7003:
7004: fnd_message.set_name('ONT','ONT_APPLY');
7005: l_msg_token := fnd_message.get;
7006:
7007: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
7008: fnd_message.set_token('ACTION', l_msg_token);

Line 7005: l_msg_token := fnd_message.get;

7001: ) = 'N' THEN
7002: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(p_hold_id));
7003:
7004: fnd_message.set_name('ONT','ONT_APPLY');
7005: l_msg_token := fnd_message.get;
7006:
7007: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
7008: fnd_message.set_token('ACTION', l_msg_token);
7009:

Line 7007: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');

7003:
7004: fnd_message.set_name('ONT','ONT_APPLY');
7005: l_msg_token := fnd_message.get;
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;

Line 7008: fnd_message.set_token('ACTION', l_msg_token);

7004: fnd_message.set_name('ONT','ONT_APPLY');
7005: l_msg_token := fnd_message.get;
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;

Line 7104: fnd_message.set_name('ONT', 'OE_NO_HOLD_FOR_ACTIVITY');

7100: and lookup_code = l_activity_name;
7101:
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;

Line 7105: fnd_message.set_token('WF_ACT',l_user_activity_name);

7101:
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

Line 7111: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');

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
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;

Line 7112: fnd_message.set_token('WF_ACT',l_user_activity_name);

7108: RAISE FND_API.G_EXC_ERROR;
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

Line 7118: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');

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
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

Line 7119: fnd_message.set_token('WF_ACT',l_user_activity_name);

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
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.

Line 7220: fnd_message.set_name('ONT', 'ONT_HOLDS_SYSTEM_CHECK');

7216: ,x_msg_count => x_msg_count
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

Line 7241: fnd_message.set_name('ONT','ONT_RELEASE');

7237: ,x_msg_count => x_msg_count
7238: ,x_msg_data => x_msg_data
7239: ) = 'N' THEN
7240: OE_DEBUG_PUB.Add('Not authorize to Release this Hold:'||to_char(p_hold_id));
7241: fnd_message.set_name('ONT','ONT_RELEASE');
7242: l_msg_token := fnd_message.get;
7243:
7244: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
7245: fnd_message.set_token('ACTION', l_msg_token);

Line 7242: l_msg_token := fnd_message.get;

7238: ,x_msg_data => x_msg_data
7239: ) = 'N' THEN
7240: OE_DEBUG_PUB.Add('Not authorize to Release this Hold:'||to_char(p_hold_id));
7241: fnd_message.set_name('ONT','ONT_RELEASE');
7242: l_msg_token := fnd_message.get;
7243:
7244: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
7245: fnd_message.set_token('ACTION', l_msg_token);
7246:

Line 7244: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');

7240: OE_DEBUG_PUB.Add('Not authorize to Release this Hold:'||to_char(p_hold_id));
7241: fnd_message.set_name('ONT','ONT_RELEASE');
7242: l_msg_token := fnd_message.get;
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;

Line 7245: fnd_message.set_token('ACTION', l_msg_token);

7241: fnd_message.set_name('ONT','ONT_RELEASE');
7242: l_msg_token := fnd_message.get;
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;

Line 7396: fnd_message.set_name('ONT', 'ONT_HOLDS_SYSTEM_CHECK');

7392: ,x_msg_count => x_msg_count
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

Line 7417: fnd_message.set_name('ONT','ONT_RELEASE');

7413: ,x_msg_count => x_msg_count
7414: ,x_msg_data => x_msg_data
7415: ) = 'N' THEN
7416: OE_DEBUG_PUB.Add('Not authorize to Release this Hold:'|| to_char(p_hold_id),1);
7417: fnd_message.set_name('ONT','ONT_RELEASE');
7418: l_msg_token := fnd_message.get;
7419:
7420: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
7421: fnd_message.set_token('ACTION', l_msg_token);

Line 7418: l_msg_token := fnd_message.get;

7414: ,x_msg_data => x_msg_data
7415: ) = 'N' THEN
7416: OE_DEBUG_PUB.Add('Not authorize to Release this Hold:'|| to_char(p_hold_id),1);
7417: fnd_message.set_name('ONT','ONT_RELEASE');
7418: l_msg_token := fnd_message.get;
7419:
7420: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
7421: fnd_message.set_token('ACTION', l_msg_token);
7422:

Line 7420: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');

7416: OE_DEBUG_PUB.Add('Not authorize to Release this Hold:'|| to_char(p_hold_id),1);
7417: fnd_message.set_name('ONT','ONT_RELEASE');
7418: l_msg_token := fnd_message.get;
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;

Line 7421: fnd_message.set_token('ACTION', l_msg_token);

7417: fnd_message.set_name('ONT','ONT_RELEASE');
7418: l_msg_token := fnd_message.get;
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;

Line 7589: fnd_message.set_name('ONT', 'ONT_HOLDS_SYSTEM_CHECK');

7585: ,x_msg_count => x_msg_count
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

Line 7610: fnd_message.set_name('ONT','ONT_APPLY');

7606: ) = 'N' THEN
7607: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'||
7608: to_char(l_hold_source_rec.hold_id));
7609:
7610: fnd_message.set_name('ONT','ONT_APPLY');
7611: l_msg_token := fnd_message.get;
7612:
7613: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
7614: fnd_message.set_token('ACTION', l_msg_token);

Line 7611: l_msg_token := fnd_message.get;

7607: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'||
7608: to_char(l_hold_source_rec.hold_id));
7609:
7610: fnd_message.set_name('ONT','ONT_APPLY');
7611: l_msg_token := fnd_message.get;
7612:
7613: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
7614: fnd_message.set_token('ACTION', l_msg_token);
7615:

Line 7613: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');

7609:
7610: fnd_message.set_name('ONT','ONT_APPLY');
7611: l_msg_token := fnd_message.get;
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;

Line 7614: fnd_message.set_token('ACTION', l_msg_token);

7610: fnd_message.set_name('ONT','ONT_APPLY');
7611: l_msg_token := fnd_message.get;
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;

Line 7816: fnd_message.set_name('ONT', 'OE_CC_AR_HOLD_NOT_RELEASED');

7812:
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

Line 7836: fnd_message.set_name('ONT', 'ONT_HOLDS_SYSTEM_CHECK');

7832: ,x_msg_count => x_msg_count
7833: ,x_msg_data => x_msg_data
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

Line 7837: fnd_message.set_token('ACTION', 'Release');

7833: ,x_msg_data => x_msg_data
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

Line 7857: fnd_message.set_name('ONT','ONT_RELEASE');

7853: ,x_msg_data => x_msg_data
7854: ) = 'N' THEN
7855: OE_DEBUG_PUB.Add('Not authorize to Release this Hold:'|| to_char(l_hold_id));
7856:
7857: fnd_message.set_name('ONT','ONT_RELEASE');
7858: l_msg_token := fnd_message.get;
7859:
7860: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
7861: fnd_message.set_token('ACTION', l_msg_token);

Line 7858: l_msg_token := fnd_message.get;

7854: ) = 'N' THEN
7855: OE_DEBUG_PUB.Add('Not authorize to Release this Hold:'|| to_char(l_hold_id));
7856:
7857: fnd_message.set_name('ONT','ONT_RELEASE');
7858: l_msg_token := fnd_message.get;
7859:
7860: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
7861: fnd_message.set_token('ACTION', l_msg_token);
7862:

Line 7860: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');

7856:
7857: fnd_message.set_name('ONT','ONT_RELEASE');
7858: l_msg_token := fnd_message.get;
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;

Line 7861: fnd_message.set_token('ACTION', l_msg_token);

7857: fnd_message.set_name('ONT','ONT_RELEASE');
7858: l_msg_token := fnd_message.get;
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;

Line 8003: fnd_message.set_name('ONT', 'ONT_HOLDS_SYSTEM_CHECK');

7999: ,x_msg_count => x_msg_count
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

Line 8024: fnd_message.set_name('ONT','ONT_RELEASE');

8020: ,x_msg_count => x_msg_count
8021: ,x_msg_data => x_msg_data
8022: ) = 'N' THEN
8023: OE_DEBUG_PUB.Add('Not authorize to Release this Hold:'||to_char(p_hold_id));
8024: fnd_message.set_name('ONT','ONT_RELEASE');
8025: l_msg_token := fnd_message.get;
8026:
8027: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
8028: fnd_message.set_token('ACTION', l_msg_token);

Line 8025: l_msg_token := fnd_message.get;

8021: ,x_msg_data => x_msg_data
8022: ) = 'N' THEN
8023: OE_DEBUG_PUB.Add('Not authorize to Release this Hold:'||to_char(p_hold_id));
8024: fnd_message.set_name('ONT','ONT_RELEASE');
8025: l_msg_token := fnd_message.get;
8026:
8027: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
8028: fnd_message.set_token('ACTION', l_msg_token);
8029:

Line 8027: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');

8023: OE_DEBUG_PUB.Add('Not authorize to Release this Hold:'||to_char(p_hold_id));
8024: fnd_message.set_name('ONT','ONT_RELEASE');
8025: l_msg_token := fnd_message.get;
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;

Line 8028: fnd_message.set_token('ACTION', l_msg_token);

8024: fnd_message.set_name('ONT','ONT_RELEASE');
8025: l_msg_token := fnd_message.get;
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;

Line 8212: fnd_message.set_name('ONT', 'ONT_HOLDS_SYSTEM_CHECK');

8208: ,x_msg_count => x_msg_count
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

Line 8233: fnd_message.set_name('ONT','ONT_RELEASE');

8229: ,x_msg_count => x_msg_count
8230: ,x_msg_data => x_msg_data
8231: ) = 'N' THEN
8232: OE_DEBUG_PUB.Add('Not authorize to Release this Hold:'|| to_char(p_hold_id),1);
8233: fnd_message.set_name('ONT','ONT_RELEASE');
8234: l_msg_token := fnd_message.get;
8235:
8236: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
8237: fnd_message.set_token('ACTION', l_msg_token);

Line 8234: l_msg_token := fnd_message.get;

8230: ,x_msg_data => x_msg_data
8231: ) = 'N' THEN
8232: OE_DEBUG_PUB.Add('Not authorize to Release this Hold:'|| to_char(p_hold_id),1);
8233: fnd_message.set_name('ONT','ONT_RELEASE');
8234: l_msg_token := fnd_message.get;
8235:
8236: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
8237: fnd_message.set_token('ACTION', l_msg_token);
8238:

Line 8236: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');

8232: OE_DEBUG_PUB.Add('Not authorize to Release this Hold:'|| to_char(p_hold_id),1);
8233: fnd_message.set_name('ONT','ONT_RELEASE');
8234: l_msg_token := fnd_message.get;
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;

Line 8237: fnd_message.set_token('ACTION', l_msg_token);

8233: fnd_message.set_name('ONT','ONT_RELEASE');
8234: l_msg_token := fnd_message.get;
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;

Line 8409: fnd_message.set_name('ONT', 'OE_CC_AR_HOLD_NOT_RELEASED');

8405:
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

Line 8429: fnd_message.set_name('ONT', 'ONT_HOLDS_SYSTEM_CHECK');

8425: ,x_msg_count => x_msg_count
8426: ,x_msg_data => x_msg_data
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

Line 8430: fnd_message.set_token('ACTION', 'Release');

8426: ,x_msg_data => x_msg_data
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

Line 8451: fnd_message.set_name('ONT','ONT_RELEASE');

8447: ,x_msg_data => x_msg_data
8448: ) = 'N' THEN
8449: OE_DEBUG_PUB.Add('Not authorize to Release this Hold:'|| to_char(l_hold_id));
8450:
8451: fnd_message.set_name('ONT','ONT_RELEASE');
8452: l_msg_token := fnd_message.get;
8453:
8454: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
8455: fnd_message.set_token('ACTION', l_msg_token);

Line 8452: l_msg_token := fnd_message.get;

8448: ) = 'N' THEN
8449: OE_DEBUG_PUB.Add('Not authorize to Release this Hold:'|| to_char(l_hold_id));
8450:
8451: fnd_message.set_name('ONT','ONT_RELEASE');
8452: l_msg_token := fnd_message.get;
8453:
8454: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
8455: fnd_message.set_token('ACTION', l_msg_token);
8456:

Line 8454: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');

8450:
8451: fnd_message.set_name('ONT','ONT_RELEASE');
8452: l_msg_token := fnd_message.get;
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;

Line 8455: fnd_message.set_token('ACTION', l_msg_token);

8451: fnd_message.set_name('ONT','ONT_RELEASE');
8452: l_msg_token := fnd_message.get;
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;

Line 8754: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');

8750: x_msg_data => x_msg_data) = 'N' THEN
8751:
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

Line 8755: fnd_message.set_token('ACTION', l_msg_token);

8751:
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

Line 8786: fnd_message.set_name('ONT','ONT_APPLY');

8782: ,x_msg_count => x_msg_count
8783: ,x_msg_data => x_msg_data
8784: ) = 'N' THEN
8785: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(p_hold_source_rec.hold_id));
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;

Line 8787: l_msg_token := fnd_message.get;

8783: ,x_msg_data => x_msg_data
8784: ) = 'N' THEN
8785: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(p_hold_source_rec.hold_id));
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;

Line 8788: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');

8784: ) = 'N' THEN
8785: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(p_hold_source_rec.hold_id));
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

Line 8789: fnd_message.set_token('ACTION', l_msg_token);

8785: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(p_hold_source_rec.hold_id));
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

Line 9033: FND_MESSAGE.SET_NAME('FND','MO_ORG_REQUIRED');

9029: IF l_org_id IS NULL THEN
9030: -- org_id is null, raise an error.
9031: oe_debug_pub.add('Org_Id is NULL',1);
9032: x_return_status := FND_API.G_RET_STS_ERROR;
9033: FND_MESSAGE.SET_NAME('FND','MO_ORG_REQUIRED');
9034: FND_MSG_PUB.ADD;
9035: RAISE FND_API.G_EXC_ERROR;
9036: END IF;
9037:

Line 9244: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');

9240: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
9241: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 9245: fnd_message.set_token('WF_ACT', l_user_activity_name);

9241: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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

Line 9277: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');

9273: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
9274: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 9278: fnd_message.set_token('WF_ACT', l_user_activity_name);

9274: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 9566: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');

9562: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
9563: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 9567: fnd_message.set_token('WF_ACT', l_user_activity_name);

9563: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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

Line 9601: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');

9597: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
9598: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 9602: fnd_message.set_token('WF_ACT', l_user_activity_name);

9598: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 9783: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');

9779: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
9780: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 9784: fnd_message.set_token('WF_ACT', l_user_activity_name);

9780: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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

Line 9816: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');

9812: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
9813: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 9817: fnd_message.set_token('WF_ACT', l_user_activity_name);

9813: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 9996: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');

9992: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
9993: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 9997: fnd_message.set_token('WF_ACT', l_user_activity_name);

9993: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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

Line 10028: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');

10024: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
10025: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 10029: fnd_message.set_token('WF_ACT', l_user_activity_name);

10025: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 10210: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');

10206: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
10207: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 10211: fnd_message.set_token('WF_ACT', l_user_activity_name);

10207: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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

Line 10243: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');

10239: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
10240: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 10244: fnd_message.set_token('WF_ACT', l_user_activity_name);

10240: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 10445: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');

10441: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
10442: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 10446: fnd_message.set_token('WF_ACT', l_user_activity_name);

10442: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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

Line 10478: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');

10474: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
10475: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 10479: fnd_message.set_token('WF_ACT', l_user_activity_name);

10475: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 10958: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');

10954: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
10955: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 10959: fnd_message.set_token('WF_ACT', l_user_activity_name);

10955: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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

Line 10991: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');

10987: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
10988: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 10992: fnd_message.set_token('WF_ACT', l_user_activity_name);

10988: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 11263: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');

11259: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
11260: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 11264: fnd_message.set_token('WF_ACT', l_user_activity_name);

11260: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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

Line 11296: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');

11292: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
11293: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 11297: fnd_message.set_token('WF_ACT', l_user_activity_name);

11293: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 11477: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');

11473: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
11474: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 11478: fnd_message.set_token('WF_ACT', l_user_activity_name);

11474: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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

Line 11510: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');

11506: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
11507: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 11511: fnd_message.set_token('WF_ACT', l_user_activity_name);

11507: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 11694: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');

11690: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
11691: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 11695: fnd_message.set_token('WF_ACT', l_user_activity_name);

11691: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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

Line 11727: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');

11723: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
11724: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 11728: fnd_message.set_token('WF_ACT', l_user_activity_name);

11724: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 12019: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');

12015: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
12016: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 12020: fnd_message.set_token('WF_ACT', l_user_activity_name);

12016: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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

Line 12052: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');

12048: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
12049: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 12053: fnd_message.set_token('WF_ACT', l_user_activity_name);

12049: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 12233: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');

12229: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
12230: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 12234: fnd_message.set_token('WF_ACT', l_user_activity_name);

12230: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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

Line 12266: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');

12262: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
12263: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 12267: fnd_message.set_token('WF_ACT', l_user_activity_name);

12263: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 12447: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');

12443: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
12444: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 12448: fnd_message.set_token('WF_ACT', l_user_activity_name);

12444: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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

Line 12480: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');

12476: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
12477: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 12481: fnd_message.set_token('WF_ACT', l_user_activity_name);

12477: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 12658: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');

12654: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
12655: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 12659: fnd_message.set_token('WF_ACT', l_user_activity_name);

12655: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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

Line 12690: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');

12686: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
12687: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 12691: fnd_message.set_token('WF_ACT', l_user_activity_name);

12687: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 12844: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');

12840: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
12841: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 12845: fnd_message.set_token('WF_ACT', l_user_activity_name);

12841: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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

Line 12878: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');

12874: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
12875: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 12879: fnd_message.set_token('WF_ACT', l_user_activity_name);

12875: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 13101: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');

13097: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
13098: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 13102: fnd_message.set_token('WF_ACT', l_user_activity_name);

13098: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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

Line 13131: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');

13127: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
13128: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 13132: fnd_message.set_token('WF_ACT', l_user_activity_name);

13128: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 13574: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');

13570: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
13571: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 13575: fnd_message.set_token('WF_ACT', l_user_activity_name);

13571: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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

Line 13606: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');

13602: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
13603: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 13607: fnd_message.set_token('WF_ACT', l_user_activity_name);

13603: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 13786: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');

13782: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
13783: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 13787: fnd_message.set_token('WF_ACT', l_user_activity_name);

13783: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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

Line 13818: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');

13814: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
13815: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 13819: fnd_message.set_token('WF_ACT', l_user_activity_name);

13815: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 13997: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');

13993: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
13994: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 13998: fnd_message.set_token('WF_ACT', l_user_activity_name);

13994: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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

Line 14029: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');

14025: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
14026: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 14030: fnd_message.set_token('WF_ACT', l_user_activity_name);

14026: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 14209: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');

14205: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
14206: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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

Line 14210: fnd_message.set_token('WF_ACT', l_user_activity_name);

14206: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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(*)

Line 14240: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');

14236: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
14237: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;

Line 14241: fnd_message.set_token('WF_ACT', l_user_activity_name);

14237: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
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;