[Home] [Help]
444: END LOOP;
445:
446: wf_engine.threshold := l_rel_threshold;
447: x_return_status := FND_API.G_RET_STS_SUCCESS;
448: Oe_msg_pub.Count_And_Get
449: ( p_count => x_msg_count
450: ,p_data => x_msg_data
451: );
452: RETURN;
521: END LOOP;
522:
523: wf_engine.threshold := l_rel_threshold;
524: x_return_status := FND_API.G_RET_STS_SUCCESS;
525: Oe_msg_pub.Count_And_Get
526: ( p_count => x_msg_count
527: ,p_data => x_msg_data
528: );
529:
531: WHEN OTHERS THEN
532: Oe_debug_pub.ADD('Failed from progress order.');
533: wf_engine.threshold := l_rel_threshold;
534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
535: Oe_msg_pub.Count_And_Get
536: ( p_count => x_msg_count
537: ,p_data => x_msg_data
538: );
539: ROLLBACK TO progress_order;
662: END LOOP;
663:
664: wf_engine.threshold := l_rel_threshold;
665: x_return_status := FND_API.G_RET_STS_SUCCESS;
666: Oe_msg_pub.Count_And_Get
667: ( p_count => x_msg_count
668: ,p_data => x_msg_data
669: );
670:
672: WHEN OTHERS THEN
673: OE_debug_pub.ADD('Failed from progress order');
674: wf_engine.threshold := l_rel_threshold;
675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
676: Oe_msg_pub.Count_And_Get
677: ( p_count => x_msg_count
678: ,p_data => x_msg_data
679: );
680: ROLLBACK TO progress_order;
956: AND lookup_code = p_activity_name;
957:
958: FND_MESSAGE.SET_NAME('ONT', 'OE_NO_HOLD_ALL_LINES');
959: FND_MESSAGE.SET_TOKEN('WF_ACT', l_user_activity_name);
960: OE_MSG_PUB.ADD;
961: OE_DEBUG_PUB.ADD(' Hold Not applied for All requested records');
962: RAISE FND_API.G_EXC_ERROR;
963:
964: ELSIF l_sql_rowcount > 0 THEN
994: AND lookup_code = p_activity_name;
995:
996: FND_MESSAGE.SET_NAME('ONT', 'OE_NO_HOLD_FEW_LINES');
997: FND_MESSAGE.SET_TOKEN('WF_ACT', l_user_activity_name);
998: OE_MSG_PUB.ADD;
999: OE_DEBUG_PUB.ADD(' Hold Not applied for FEW of the requested records');
1000: END IF;
1001: END IF;
1002: END IF;
1250: AND lookup_code = p_activity_name;
1251:
1252: FND_MESSAGE.SET_NAME('ONT', 'OE_NO_HOLD_ALL_LINES');
1253: FND_MESSAGE.SET_TOKEN('WF_ACT',l_user_activity_name);
1254: OE_MSG_PUB.ADD;
1255: OE_DEBUG_PUB.ADD(' Hold Not applied for All requested records');
1256: RAISE FND_API.G_EXC_ERROR;
1257:
1258: ELSIF l_sql_rowcount > 0 THEN
1288: AND lookup_code = p_activity_name;
1289:
1290: FND_MESSAGE.SET_NAME('ONT', 'OE_NO_HOLD_FEW_LINES');
1291: FND_MESSAGE.SET_TOKEN('WF_ACT',l_user_activity_name);
1292: OE_MSG_PUB.ADD;
1293: OE_DEBUG_PUB.ADD(' Hold Not applied for FEW of the requested records');
1294: END IF;
1295: END IF;
1296: END IF;
1791: p_hold_source_rec.line_id IS NOT NULL) OR
1792: p_hold_source_rec.hold_entity_code2 IS NOT NULL THEN
1793: oe_debug_pub.add('Error: Order WF Hold, being applied at Line Level');
1794: FND_MESSAGE.SET_NAME('ONT','OE_ORDER_HOLD_INVALID_CRITERIA');
1795: OE_MSG_PUB.ADD;
1796: RAISE FND_API.G_EXC_ERROR;
1797: END IF;
1798: ELSIF l_item_type = 'OEOL' THEN
1799: IF p_hold_source_rec.hold_entity_code IN ('C','O') AND
1800: p_hold_source_rec.line_id IS NULL AND
1801: l_apply_to_flag = 'N' THEN
1802: oe_debug_pub.add('Error: Line WF Hold, being applied at Order Level');
1803: FND_MESSAGE.SET_NAME('ONT','OE_LINE_HOLD_INVALID_CRITERIA');
1804: OE_MSG_PUB.ADD;
1805: RAISE FND_API.G_EXC_ERROR;
1806: END IF;
1807: END IF;
1808: ER#7479609*/
1829: oe_debug_pub.add('Order WF HOLD');
1830: ELSIF l_item_type = 'OEOL' AND l_apply_to_flag = 'N' THEN
1831: oe_debug_pub.add('Error: Line WF Hold, being applied at Order Level');
1832: FND_MESSAGE.SET_NAME('ONT','OE_LINE_HOLD_INVALID_CRITERIA');
1833: OE_MSG_PUB.ADD;
1834: RAISE FND_API.G_EXC_ERROR;
1835: END IF;
1836: ELSE
1837: IF (p_hold_source_rec.hold_entity_code = 'P' and p_hold_source_rec.hold_entity_code2 IS NULL) THEN
1842: oe_debug_pub.add('Line WF HOLD');
1843: ELSIF l_item_type = 'OEOH' THEN
1844: oe_debug_pub.add('Error: Order WF Hold, being applied at Line Level');
1845: FND_MESSAGE.SET_NAME('ONT','OE_ORDER_HOLD_INVALID_CRITERIA');
1846: OE_MSG_PUB.ADD;
1847: RAISE FND_API.G_EXC_ERROR;
1848: END IF;
1849: END IF;
1850: END IF;
1859: --ER#7479609 if p_hold_source_rec.hold_entity_code2 not in ('C', 'S', 'B', 'W','H') then
1860: if p_hold_source_rec.hold_entity_code2 not in ('C', 'S', 'B', 'W','H','SM','D','PL','PR','ST','LT') then --ER#7479609
1861: OE_Debug_PUB.Add('Invalid Entity Combination',1);
1862: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ENTITY_CONBINATION');
1863: OE_MSG_PUB.ADD;
1864: RAISE FND_API.G_EXC_ERROR;
1865: end if;
1866: elsif p_hold_source_rec.hold_entity_code = 'W' then
1867: --ER#7479609 if p_hold_source_rec.hold_entity_code2 not in ('C', 'S', 'B') then
1867: --ER#7479609 if p_hold_source_rec.hold_entity_code2 not in ('C', 'S', 'B') then
1868: if p_hold_source_rec.hold_entity_code2 not in ('C', 'S', 'B','LT','SM','D','ST') then --ER#7479609
1869: OE_Debug_PUB.Add('Invalid Entity Combination',1);
1870: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ENTITY_CONBINATION');
1871: OE_MSG_PUB.ADD;
1872: RAISE FND_API.G_EXC_ERROR;
1873: end if;
1874: elsif p_hold_source_rec.hold_entity_code = 'B' then
1875: if p_hold_source_rec.hold_entity_code2 not in ('O') then
1874: elsif p_hold_source_rec.hold_entity_code = 'B' then
1875: if p_hold_source_rec.hold_entity_code2 not in ('O') then
1876: OE_Debug_PUB.Add('Invalid Entity Combination',1);
1877: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ENTITY_CONBINATION');
1878: OE_MSG_PUB.ADD;
1879: RAISE FND_API.G_EXC_ERROR;
1880: end if;
1881: elsif p_hold_source_rec.hold_entity_code = 'H' then
1882: --ER#7479609 if p_hold_source_rec.hold_entity_code2 not in ('S', 'B', 'W', 'L') then
1882: --ER#7479609 if p_hold_source_rec.hold_entity_code2 not in ('S', 'B', 'W', 'L') then
1883: if p_hold_source_rec.hold_entity_code2 not in ('S', 'B', 'W', 'L','PL','PT','SM','D','LT') then --ER#7479609
1884: OE_Debug_PUB.Add('Invalid Entity Combination',1);
1885: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ENTITY_CONBINATION');
1886: OE_MSG_PUB.ADD;
1887: RAISE FND_API.G_EXC_ERROR;
1888: end if;
1889: --ER#7479609 start
1890: elsif p_hold_source_rec.hold_entity_code = 'TM' then
1890: elsif p_hold_source_rec.hold_entity_code = 'TM' then
1891: if p_hold_source_rec.hold_entity_code2 not in ('OI') then
1892: OE_Debug_PUB.Add('Invalid Entity Combination',1);
1893: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ENTITY_CONBINATION');
1894: OE_MSG_PUB.ADD;
1895: RAISE FND_API.G_EXC_ERROR;
1896: end if;
1897: elsif p_hold_source_rec.hold_entity_code = 'PR' then
1898: if p_hold_source_rec.hold_entity_code2 not in ('T') then
1897: elsif p_hold_source_rec.hold_entity_code = 'PR' then
1898: if p_hold_source_rec.hold_entity_code2 not in ('T') then
1899: OE_Debug_PUB.Add('Invalid Entity Combination',1);
1900: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ENTITY_CONBINATION');
1901: OE_MSG_PUB.ADD;
1902: RAISE FND_API.G_EXC_ERROR;
1903: end if;
1904: elsif p_hold_source_rec.hold_entity_code = 'C' then
1905: if p_hold_source_rec.hold_entity_code2 not in ('ST','B','S','D','PL','LT','PT','OT','P','TC','SC') then
1904: elsif p_hold_source_rec.hold_entity_code = 'C' then
1905: if p_hold_source_rec.hold_entity_code2 not in ('ST','B','S','D','PL','LT','PT','OT','P','TC','SC') then
1906: OE_Debug_PUB.Add('Invalid Entity Combination',1);
1907: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ENTITY_CONBINATION');
1908: OE_MSG_PUB.ADD;
1909: RAISE FND_API.G_EXC_ERROR;
1910: end if;
1911: elsif p_hold_source_rec.hold_entity_code = 'PL' then
1912: if p_hold_source_rec.hold_entity_code2 not in ('TC') then
1911: elsif p_hold_source_rec.hold_entity_code = 'PL' then
1912: if p_hold_source_rec.hold_entity_code2 not in ('TC') then
1913: OE_Debug_PUB.Add('Invalid Entity Combination',1);
1914: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ENTITY_CONBINATION');
1915: OE_MSG_PUB.ADD;
1916: RAISE FND_API.G_EXC_ERROR;
1917: end if;
1918: elsif p_hold_source_rec.hold_entity_code = 'OT' then
1919: if p_hold_source_rec.hold_entity_code2 not in ('LT','TC') then
1918: elsif p_hold_source_rec.hold_entity_code = 'OT' then
1919: if p_hold_source_rec.hold_entity_code2 not in ('LT','TC') then
1920: OE_Debug_PUB.Add('Invalid Entity Combination',1);
1921: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ENTITY_CONBINATION');
1922: OE_MSG_PUB.ADD;
1923: RAISE FND_API.G_EXC_ERROR;
1924: end if;
1925: elsif p_hold_source_rec.hold_entity_code = 'CD' then
1926: if p_hold_source_rec.hold_entity_code2 not in ('CB') then
1925: elsif p_hold_source_rec.hold_entity_code = 'CD' then
1926: if p_hold_source_rec.hold_entity_code2 not in ('CB') then
1927: OE_Debug_PUB.Add('Invalid Entity Combination',1);
1928: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ENTITY_CONBINATION');
1929: OE_MSG_PUB.ADD;
1930: RAISE FND_API.G_EXC_ERROR;
1931: end if;
1932: --ER#7479609 end
1933: else
2061: --ER#7479609 end
2062: ELSE
2063: OE_Debug_PUB.Add('Invalid Entity Code');
2064: FND_MESSAGE.SET_NAME('ONT', 'OE_MISSING_ENTITY_CODE');
2065: OE_MSG_PUB.ADD;
2066: RAISE FND_API.G_EXC_ERROR;
2067: END IF;
2068:
2069: /*********************************
2212: --ER#7479609 end
2213: ELSE
2214: OE_Debug_PUB.Add('Invalid Second Entity Code');
2215: FND_MESSAGE.SET_NAME('ONT', 'OE_MISSING_ENTITY_CODE');
2216: OE_MSG_PUB.ADD;
2217: RAISE FND_API.G_EXC_ERROR;
2218: END IF;
2219: END IF;
2220: ------------------------------
2225: WHEN NO_DATA_FOUND THEN
2226: /* XXX Error message here */
2227: OE_Debug_PUB.Add('Hold Entity ID not found for entity',1);
2228: FND_MESSAGE.SET_NAME('ONT', 'OE_MISSING_ENTITY_ID');
2229: OE_MSG_PUB.ADD;
2230: RAISE FND_API.G_EXC_ERROR;
2231: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2232: WHEN FND_API.G_EXC_ERROR THEN
2233: /*
2232: WHEN FND_API.G_EXC_ERROR THEN
2233: /*
2234: ** This message is not required.
2235: FND_MESSAGE.SET_NAME('ONT', 'OE_ENTITY_NOT_ON_ORDER_OR_LINE');
2236: OE_MSG_PUB.ADD;
2237: */
2238: OE_Debug_PUB.Add('Expected error in Validate_Hold_source',1);
2239: x_return_status := FND_API.G_RET_STS_ERROR;
2240: WHEN OTHERS THEN
2238: OE_Debug_PUB.Add('Expected error in Validate_Hold_source',1);
2239: x_return_status := FND_API.G_RET_STS_ERROR;
2240: WHEN OTHERS THEN
2241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2242: IF OE_MSG_PUB.Check_Msg_Level
2243: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2244: THEN
2245: OE_MSG_PUB.Add_Exc_Msg
2246: ( G_PKG_NAME
2239: x_return_status := FND_API.G_RET_STS_ERROR;
2240: WHEN OTHERS THEN
2241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2242: IF OE_MSG_PUB.Check_Msg_Level
2243: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2244: THEN
2245: OE_MSG_PUB.Add_Exc_Msg
2246: ( G_PKG_NAME
2247: , l_api_name
2241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2242: IF OE_MSG_PUB.Check_Msg_Level
2243: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2244: THEN
2245: OE_MSG_PUB.Add_Exc_Msg
2246: ( G_PKG_NAME
2247: , l_api_name
2248: );
2249: END IF;
2265:
2266: -- Check for Missing Values
2267: IF p_hold_id IS NULL THEN
2268: FND_MESSAGE.SET_NAME('ONT', 'OE_MISSING_HOLD_ID');
2269: OE_MSG_PUB.ADD;
2270: RAISE FND_API.G_EXC_ERROR;
2271: END IF;
2272:
2273:
2287: WHEN NO_DATA_FOUND THEN
2288: OE_Debug_PUB.Add('Invalid Hold ID'||to_char(p_hold_id),1);
2289: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_HOLD_ID');
2290: FND_MESSAGE.SET_TOKEN('HOLD_ID',p_hold_id);
2291: OE_MSG_PUB.ADD;
2292: x_return_status := FND_API.G_RET_STS_ERROR;
2293:
2294: END; -- Validate Hold ID
2295:
2353: OE_Debug_PUB.Add('Duplicate Hold Source for EntityID'||
2354: to_char(p_hold_source_rec.hold_entity_id) ,1);
2355: --FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD');
2356: FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD_SOURCE');
2357: OE_MSG_PUB.ADD;
2358: x_hold_exists := 'Y';
2359: RETURN;
2360: --RAISE FND_API.G_EXC_ERROR;
2361: END IF;
2384: OE_Debug_PUB.Add('Duplicate Hold Source for EntityID'||
2385: to_char(p_hold_source_rec.hold_entity_id) ,1);
2386: --FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD');
2387: FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD_SOURCE');
2388: OE_MSG_PUB.ADD;
2389: x_hold_exists := 'Y';
2390: RETURN;
2391: --RAISE FND_API.G_EXC_ERROR;
2392: END IF;
2412: OE_Debug_PUB.Add('Duplicate Hold Source for EntityID'||
2413: to_char(p_hold_source_rec.hold_entity_id) ,1);
2414: --FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD');
2415: FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD_SOURCE');
2416: OE_MSG_PUB.ADD;
2417: --RETURN;
2418: RAISE FND_API.G_EXC_ERROR;
2419: END IF;
2420: end if;
2511: EXCEPTION
2512: WHEN FND_API.G_EXC_ERROR THEN
2513: --ROLLBACK TO Create_Hold_Source;
2514: x_return_status := FND_API.G_RET_STS_ERROR;
2515: OE_MSG_PUB.Count_And_Get
2516: ( p_count => x_msg_count
2517: , p_data => x_msg_data
2518: );
2519: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2518: );
2519: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2520: --ROLLBACK TO Create_Hold_Source;
2521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2522: OE_MSG_PUB.Count_And_Get
2523: ( p_count => x_msg_count
2524: , p_data => x_msg_data
2525: );
2526: WHEN OTHERS THEN
2525: );
2526: WHEN OTHERS THEN
2527: --ROLLBACK TO Create_Hold_Source;
2528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2529: IF OE_MSG_PUB.Check_Msg_Level
2530: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2531: THEN
2532: OE_MSG_PUB.Add_Exc_Msg
2533: ( G_PKG_NAME,
2526: WHEN OTHERS THEN
2527: --ROLLBACK TO Create_Hold_Source;
2528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2529: IF OE_MSG_PUB.Check_Msg_Level
2530: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2531: THEN
2532: OE_MSG_PUB.Add_Exc_Msg
2533: ( G_PKG_NAME,
2534: l_api_name);
2528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2529: IF OE_MSG_PUB.Check_Msg_Level
2530: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2531: THEN
2532: OE_MSG_PUB.Add_Exc_Msg
2533: ( G_PKG_NAME,
2534: l_api_name);
2535: END IF;
2536: OE_MSG_PUB.Count_And_Get
2532: OE_MSG_PUB.Add_Exc_Msg
2533: ( G_PKG_NAME,
2534: l_api_name);
2535: END IF;
2536: OE_MSG_PUB.Count_And_Get
2537: ( p_count => x_msg_count
2538: , p_data => x_msg_data
2539: );
2540: END Create_Hold_Source;
2594: OE_Debug_PUB.Add('Duplicate Hold Source for EntityID'||
2595: to_char(p_hold_source_rec.hold_entity_id) ,1);
2596: --FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD');
2597: FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD_SOURCE');
2598: OE_MSG_PUB.ADD;
2599: --RETURN;
2600: RAISE FND_API.G_EXC_ERROR;
2601: END IF;
2602: /* If Order Level Hold */
2623: OE_Debug_PUB.Add('Duplicate Hold Source for EntityID'||
2624: to_char(p_hold_source_rec.hold_entity_id) ,1);
2625: --FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD');
2626: FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD_SOURCE');
2627: OE_MSG_PUB.ADD;
2628: --RETURN;
2629: RAISE FND_API.G_EXC_ERROR;
2630: END IF;
2631:
2655: OE_Debug_PUB.Add('Duplicate Hold Source for EntityID'||
2656: to_char(p_hold_source_rec.hold_entity_id) ,1);
2657: --FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD');
2658: FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD_SOURCE');
2659: OE_MSG_PUB.ADD;
2660: --RETURN;
2661: RAISE FND_API.G_EXC_ERROR;
2662: END IF;
2663:
2786: EXCEPTION
2787: WHEN FND_API.G_EXC_ERROR THEN
2788: --ROLLBACK TO Create_Hold_Source;
2789: x_return_status := FND_API.G_RET_STS_ERROR;
2790: OE_MSG_PUB.Count_And_Get
2791: ( p_count => x_msg_count
2792: , p_data => x_msg_data
2793: );
2794: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2793: );
2794: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2795: --ROLLBACK TO Create_Hold_Source;
2796: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2797: OE_MSG_PUB.Count_And_Get
2798: ( p_count => x_msg_count
2799: , p_data => x_msg_data
2800: );
2801: WHEN OTHERS THEN
2800: );
2801: WHEN OTHERS THEN
2802: --ROLLBACK TO Create_Hold_Source;
2803: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2804: IF OE_MSG_PUB.Check_Msg_Level
2805: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2806: THEN
2807: OE_MSG_PUB.Add_Exc_Msg
2808: ( G_PKG_NAME,
2801: WHEN OTHERS THEN
2802: --ROLLBACK TO Create_Hold_Source;
2803: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2804: IF OE_MSG_PUB.Check_Msg_Level
2805: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2806: THEN
2807: OE_MSG_PUB.Add_Exc_Msg
2808: ( G_PKG_NAME,
2809: l_api_name);
2803: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2804: IF OE_MSG_PUB.Check_Msg_Level
2805: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2806: THEN
2807: OE_MSG_PUB.Add_Exc_Msg
2808: ( G_PKG_NAME,
2809: l_api_name);
2810: END IF;
2811: OE_MSG_PUB.Count_And_Get
2807: OE_MSG_PUB.Add_Exc_Msg
2808: ( G_PKG_NAME,
2809: l_api_name);
2810: END IF;
2811: OE_MSG_PUB.Count_And_Get
2812: ( p_count => x_msg_count
2813: , p_data => x_msg_data
2814: );
2815: END Create_Hold_Source;
4744: EXCEPTION
4745: WHEN FND_API.G_EXC_ERROR THEN
4746: --ROLLBACK TO APPLY_HOLDS_PUB;
4747: x_return_status := FND_API.G_RET_STS_ERROR;
4748: OE_MSG_PUB.Count_And_Get
4749: ( p_count => x_msg_count
4750: , p_data => x_msg_data
4751: );
4752: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4751: );
4752: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4753: --ROLLBACK TO APPLY_HOLDS_PUB;
4754: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4755: OE_MSG_PUB.Count_And_Get
4756: ( p_count => x_msg_count
4757: , p_data => x_msg_data
4758: );
4759: WHEN OTHERS THEN
4758: );
4759: WHEN OTHERS THEN
4760: --ROLLBACK TO APPLY_HOLDS_PUB;
4761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4762: IF OE_MSG_PUB.Check_Msg_Level
4763: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4764: THEN
4765: OE_MSG_PUB.Add_Exc_Msg
4766: ( G_PKG_NAME
4759: WHEN OTHERS THEN
4760: --ROLLBACK TO APPLY_HOLDS_PUB;
4761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4762: IF OE_MSG_PUB.Check_Msg_Level
4763: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4764: THEN
4765: OE_MSG_PUB.Add_Exc_Msg
4766: ( G_PKG_NAME
4767: , l_api_name
4761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4762: IF OE_MSG_PUB.Check_Msg_Level
4763: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4764: THEN
4765: OE_MSG_PUB.Add_Exc_Msg
4766: ( G_PKG_NAME
4767: , l_api_name
4768: );
4769: END IF;
4766: ( G_PKG_NAME
4767: , l_api_name
4768: );
4769: END IF;
4770: OE_MSG_PUB.Count_And_Get
4771: ( p_count => x_msg_count
4772: , p_data => x_msg_data
4773: );
4774:
4878: p_hold_release_rec.release_reason_code ,2);
4879: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_REASON_CODE');
4880: FND_MESSAGE.SET_TOKEN('REASON_CODE',
4881: p_hold_release_rec.release_reason_code);
4882: OE_MSG_PUB.ADD;
4883: RAISE FND_API.G_EXC_ERROR;
4884:
4885: END; -- Validate Reason Code
4886:
4974: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4975: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4976: ROLLBACK TO insert_hold_release;
4977: WHEN OTHERS THEN
4978: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4979: OE_MSG_PUB.Add_Exc_Msg
4980: (G_PKG_NAME
4981: ,'Insert_Hold_Release');
4982: END IF;
4975: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4976: ROLLBACK TO insert_hold_release;
4977: WHEN OTHERS THEN
4978: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4979: OE_MSG_PUB.Add_Exc_Msg
4980: (G_PKG_NAME
4981: ,'Insert_Hold_Release');
4982: END IF;
4983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5053: oe_debug_pub.add('Entity Code2/ID2' ||
5054: p_hold_source_rec.hold_entity_code2 || '/' ||
5055: to_char(p_hold_source_rec.hold_entity_id2) ,1);
5056: FND_MESSAGE.SET_NAME('ONT', 'OE_MISSING_HOLD_SOURCE');
5057: OE_MSG_PUB.ADD;
5058: RAISE FND_API.G_EXC_ERROR;
5059: */
5060: CLOSE order_hold_source;
5061: RETURN;
5072: oe_debug_pub.add('Entity Code2/ID2' ||
5073: p_hold_source_rec.hold_entity_code2 || '/' ||
5074: to_char(p_hold_source_rec.hold_entity_id2) ,1);
5075: FND_MESSAGE.SET_NAME('ONT', 'OE_MISSING_HOLD_SOURCE');
5076: OE_MSG_PUB.ADD;
5077: RAISE FND_API.G_EXC_ERROR;
5078: END IF; -- hold_source%NOTFOUND
5079: CLOSE hold_source;
5080: END IF; -- p_hold_source_rec.hold_entity_code = 'O'
5112: x_return_status := FND_API.G_RET_STS_ERROR;
5113: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5115: WHEN OTHERS THEN
5116: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5117: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME
5118: ,'Insert_Hold_Release');
5119: END IF;
5120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5113: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5115: WHEN OTHERS THEN
5116: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5117: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME
5118: ,'Insert_Hold_Release');
5119: END IF;
5120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5121:
5137: x_return_status := FND_API.G_RET_STS_SUCCESS;
5138:
5139: IF p_line_id IS NULL AND p_header_id IS NULL THEN
5140: FND_MESSAGE.SET_NAME('ONT', 'OE_ENTER_HEADER_OR_LINE_ID');
5141: OE_MSG_PUB.ADD;
5142: RAISE FND_API.G_EXC_ERROR;
5143: ELSIF p_header_id IS NULL THEN
5144: l_dummy := 'LINE'; -- Added for bug 7112725
5145: SELECT header_id
5159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5160: IF l_dummy = 'HEADER' THEN
5161: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_HEADER_ID');
5162: FND_MESSAGE.SET_TOKEN('HEADER_ID',p_header_id);
5163: OE_MSG_PUB.ADD;
5164: ELSIF l_dummy = 'LINE' THEN
5165: FND_MESSAGE.SET_NAME('ONT', 'OE_COGS_INVALID_LINE_ID');
5166: FND_MESSAGE.SET_TOKEN('LINE_ID',p_line_id);
5167: OE_MSG_PUB.ADD;
5163: OE_MSG_PUB.ADD;
5164: ELSIF l_dummy = 'LINE' THEN
5165: FND_MESSAGE.SET_NAME('ONT', 'OE_COGS_INVALID_LINE_ID');
5166: FND_MESSAGE.SET_TOKEN('LINE_ID',p_line_id);
5167: OE_MSG_PUB.ADD;
5168: END IF;
5169: oe_debug_pub.add('Return Status : ' || x_return_status, 5);
5170: -- RAISE FND_API.G_EXC_ERROR; -- Commented for bug 7112725
5171: END Validate_Order;
5248: IF (p_order_rec.header_id = FND_API.G_MISS_NUM
5249: AND p_order_rec.line_id = FND_API.G_MISS_NUM) THEN
5250:
5251: FND_MESSAGE.SET_NAME('ONT', 'OE_ENTER_HEADER_OR_LINE_ID');
5252: OE_MSG_PUB.ADD;
5253: RAISE FND_API.G_EXC_ERROR;
5254:
5255: END IF;
5256:
5361: CLOSE line_hold;
5362: END IF;
5363: ROLLBACK TO DELETE_HOLDS_PUB;
5364: x_return_status := FND_API.G_RET_STS_ERROR;
5365: OE_MSG_PUB.Count_And_Get
5366: ( p_count => x_msg_count
5367: , p_data => x_msg_data
5368: );
5369: WHEN OTHERS THEN
5377: CLOSE line_hold;
5378: END IF;
5379: ROLLBACK TO DELETE_HOLDS_PUB;
5380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5381: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5382: THEN
5383: OE_MSG_PUB.Add_Exc_Msg
5384: ( G_PKG_NAME
5385: , l_api_name
5379: ROLLBACK TO DELETE_HOLDS_PUB;
5380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5381: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5382: THEN
5383: OE_MSG_PUB.Add_Exc_Msg
5384: ( G_PKG_NAME
5385: , l_api_name
5386: );
5387: END IF;
5384: ( G_PKG_NAME
5385: , l_api_name
5386: );
5387: END IF;
5388: OE_MSG_PUB.Count_And_Get
5389: ( p_count => x_msg_count
5390: , p_data => x_msg_data
5391: );
5392: END Delete_Holds;
5561:
5562: IF p_order_tbl.COUNT = 1 AND l_count_of_holds_applied = 0 THEN
5563: fnd_message.set_name('ONT', 'OE_NO_HOLD_FOR_ACTIVITY');
5564: fnd_message.set_token('WF_ACT',l_user_activity_name);
5565: OE_MSG_PUB.ADD;
5566: oe_debug_pub.add(' Hold Not applied for the requested line');
5567: RAISE FND_API.G_EXC_ERROR;
5568: ELSIF l_count_of_holds_applied = 0
5569: AND p_order_tbl.COUNT > 1 THEN
5568: ELSIF l_count_of_holds_applied = 0
5569: AND p_order_tbl.COUNT > 1 THEN
5570: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
5571: fnd_message.set_token('WF_ACT',l_user_activity_name);
5572: OE_MSG_PUB.ADD;
5573: oe_debug_pub.add('Hold Not applied for ALL requested lines');
5574: RAISE FND_API.G_EXC_ERROR;
5575: ELSIF p_order_tbl.COUNT > l_count_of_holds_applied
5576: AND p_order_tbl.COUNT > 1 THEN
5575: ELSIF p_order_tbl.COUNT > l_count_of_holds_applied
5576: AND p_order_tbl.COUNT > 1 THEN
5577: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
5578: fnd_message.set_token('WF_ACT',l_user_activity_name);
5579: OE_MSG_PUB.ADD;
5580: oe_debug_pub.add('Hold Not applied for FEW requested lines');
5581: ELSE
5582: NULL; -- No messages are required to be logged.
5583: END IF;
5962: l_user_activity_name VARCHAR2(80);
5963:
5964:
5965: BEGIN
5966: oe_msg_pub.initialize;
5967:
5968: OE_DEBUG_PUB.Add('Entering OE_Holds_PVT.process_apply_holds_lines',1);
5969:
5970: IF check_system_holds(
5974: x_msg_data => x_msg_data) = 'N' THEN
5975:
5976: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(p_hold_id));
5977: fnd_message.set_name('ONT', 'ONT_HOLDS_SYSTEM_CHECK');
5978: OE_MSG_PUB.ADD;
5979: x_return_status := FND_API.G_RET_STS_ERROR;
5980: OE_MSG_PUB.Count_And_Get
5981: ( p_count => x_msg_count
5982: , p_data => x_msg_data
5976: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(p_hold_id));
5977: fnd_message.set_name('ONT', 'ONT_HOLDS_SYSTEM_CHECK');
5978: OE_MSG_PUB.ADD;
5979: x_return_status := FND_API.G_RET_STS_ERROR;
5980: OE_MSG_PUB.Count_And_Get
5981: ( p_count => x_msg_count
5982: , p_data => x_msg_data
5983: );
5984: RETURN;
6000:
6001: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
6002: fnd_message.set_token('ACTION', l_msg_token);
6003:
6004: OE_MSG_PUB.ADD;
6005: --RAISE FND_API.G_EXC_ERROR;
6006: x_return_status := FND_API.G_RET_STS_ERROR;
6007: OE_MSG_PUB.Count_And_Get
6008: ( p_count => x_msg_count
6003:
6004: OE_MSG_PUB.ADD;
6005: --RAISE FND_API.G_EXC_ERROR;
6006: x_return_status := FND_API.G_RET_STS_ERROR;
6007: OE_MSG_PUB.Count_And_Get
6008: ( p_count => x_msg_count
6009: , p_data => x_msg_data
6010: );
6011: RETURN;
6111: IF p_sel_rec_tbl.COUNT = 1 AND l_count_of_holds_applied = 0
6112: THEN
6113: fnd_message.set_name('ONT', 'OE_NO_HOLD_FOR_ACTIVITY');
6114: fnd_message.set_token('WF_ACT',l_user_activity_name);
6115: OE_MSG_PUB.ADD;
6116: oe_debug_pub.add(' Hold Not applied for the requested line');
6117: RAISE FND_API.G_EXC_ERROR;
6118: ELSIF l_count_of_holds_applied = 0
6119: AND p_sel_rec_tbl.COUNT > 1 THEN
6118: ELSIF l_count_of_holds_applied = 0
6119: AND p_sel_rec_tbl.COUNT > 1 THEN
6120: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
6121: fnd_message.set_token('WF_ACT',l_user_activity_name);
6122: OE_MSG_PUB.ADD;
6123: oe_debug_pub.add('Hold Not applied for ALL requested lines');
6124: RAISE FND_API.G_EXC_ERROR;
6125: ELSIF p_sel_rec_tbl.COUNT > l_count_of_holds_applied
6126: AND p_sel_rec_tbl.COUNT > 1 THEN
6125: ELSIF p_sel_rec_tbl.COUNT > l_count_of_holds_applied
6126: AND p_sel_rec_tbl.COUNT > 1 THEN
6127: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
6128: fnd_message.set_token('WF_ACT',l_user_activity_name);
6129: OE_MSG_PUB.ADD;
6130: oe_debug_pub.add('Hold Not applied for FEW requested lines');
6131: ELSE
6132: NULL; -- No messages are required to be logged.
6133: END IF;
6134: END IF; -- End of WF_HOLDS ER (bug 6449458) IF Condition
6135:
6136: x_return_status := FND_API.G_RET_STS_SUCCESS;
6137: -- Get message count and data
6138: OE_MSG_PUB.Count_And_Get
6139: ( p_count => x_msg_count
6140: , p_data => x_msg_data
6141: );
6142:
6145: EXCEPTION /* Procedure exception handler */
6146:
6147: WHEN FND_API.G_EXC_ERROR THEN
6148: x_return_status := FND_API.G_RET_STS_ERROR ;
6149: OE_MSG_PUB.Count_And_Get
6150: ( p_count => x_msg_count,
6151: p_data => x_msg_data
6152: );
6153: ROLLBACK TO SAVEPOINT process_apply_holds_lines;
6153: ROLLBACK TO SAVEPOINT process_apply_holds_lines;
6154:
6155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6157: OE_MSG_PUB.Count_And_Get
6158: ( p_count => x_msg_count,
6159: p_data => x_msg_data
6160: );
6161: ROLLBACK TO SAVEPOINT process_apply_holds_lines;
6161: ROLLBACK TO SAVEPOINT process_apply_holds_lines;
6162:
6163: WHEN OTHERS THEN
6164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6165: IF OE_MSG_PUB.Check_Msg_Level
6166: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6167: THEN
6168: OE_MSG_PUB.Add_Exc_Msg
6169: (G_PKG_NAME,
6162:
6163: WHEN OTHERS THEN
6164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6165: IF OE_MSG_PUB.Check_Msg_Level
6166: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6167: THEN
6168: OE_MSG_PUB.Add_Exc_Msg
6169: (G_PKG_NAME,
6170: l_api_name
6164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6165: IF OE_MSG_PUB.Check_Msg_Level
6166: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6167: THEN
6168: OE_MSG_PUB.Add_Exc_Msg
6169: (G_PKG_NAME,
6170: l_api_name
6171: );
6172: END IF;
6169: (G_PKG_NAME,
6170: l_api_name
6171: );
6172: END IF;
6173: OE_MSG_PUB.Count_And_Get
6174: ( p_count => x_msg_count,
6175: p_data => x_msg_data);
6176: ROLLBACK TO SAVEPOINT process_apply_holds_lines;
6177:
6211: l_count_of_holds_applied NUMBER := 0;
6212: l_user_activity_name VARCHAR2(80);
6213:
6214: BEGIN
6215: oe_msg_pub.initialize;
6216:
6217: OE_DEBUG_PUB.Add('Entering OE_Holds_PVT.process_apply_holds_orders',1);
6218:
6219: IF check_system_holds( p_hold_id => p_hold_id
6222: , x_msg_data => x_msg_data
6223: ) = 'N' THEN
6224: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(p_hold_id));
6225: fnd_message.set_name('ONT', 'ONT_HOLDS_SYSTEM_CHECK');
6226: OE_MSG_PUB.ADD;
6227: x_return_status := FND_API.G_RET_STS_ERROR;
6228: OE_MSG_PUB.Count_And_Get
6229: ( p_count => x_msg_count
6230: , p_data => x_msg_data
6224: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(p_hold_id));
6225: fnd_message.set_name('ONT', 'ONT_HOLDS_SYSTEM_CHECK');
6226: OE_MSG_PUB.ADD;
6227: x_return_status := FND_API.G_RET_STS_ERROR;
6228: OE_MSG_PUB.Count_And_Get
6229: ( p_count => x_msg_count
6230: , p_data => x_msg_data
6231: );
6232: RETURN;
6249:
6250: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
6251: fnd_message.set_token('ACTION', l_msg_token);
6252:
6253: OE_MSG_PUB.ADD;
6254: -- RAISE FND_API.G_EXC_ERROR;
6255: x_return_status := FND_API.G_RET_STS_ERROR;
6256: OE_MSG_PUB.Count_And_Get
6257: ( p_count => x_msg_count
6252:
6253: OE_MSG_PUB.ADD;
6254: -- RAISE FND_API.G_EXC_ERROR;
6255: x_return_status := FND_API.G_RET_STS_ERROR;
6256: OE_MSG_PUB.Count_And_Get
6257: ( p_count => x_msg_count
6258: , p_data => x_msg_data
6259: );
6260: RETURN;
6344: IF p_sel_rec_tbl.COUNT = 1 AND l_count_of_holds_applied = 0
6345: THEN
6346: fnd_message.set_name('ONT', 'OE_NO_HOLD_FOR_ACTIVITY');
6347: fnd_message.set_token('WF_ACT',l_user_activity_name);
6348: OE_MSG_PUB.ADD;
6349: oe_debug_pub.add(' Hold Not applied for the requested line');
6350: RAISE FND_API.G_EXC_ERROR;
6351: ELSIF l_count_of_holds_applied = 0
6352: AND p_sel_rec_tbl.COUNT > 1 THEN
6351: ELSIF l_count_of_holds_applied = 0
6352: AND p_sel_rec_tbl.COUNT > 1 THEN
6353: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
6354: fnd_message.set_token('WF_ACT',l_user_activity_name);
6355: OE_MSG_PUB.ADD;
6356: oe_debug_pub.add('Hold Not applied for ALL requested lines');
6357: RAISE FND_API.G_EXC_ERROR;
6358: ELSIF p_sel_rec_tbl.COUNT > l_count_of_holds_applied
6359: AND p_sel_rec_tbl.COUNT > 1 THEN
6358: ELSIF p_sel_rec_tbl.COUNT > l_count_of_holds_applied
6359: AND p_sel_rec_tbl.COUNT > 1 THEN
6360: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
6361: fnd_message.set_token('WF_ACT',l_user_activity_name);
6362: OE_MSG_PUB.ADD;
6363: oe_debug_pub.add('Hold Not applied for FEW requested lines');
6364: ELSE
6365: NULL; -- No messages are required to be logged.
6366: END IF;
6367: END IF; -- End of WF_HOLDS ER (bug 6449458) IF Condition
6368:
6369: x_return_status := FND_API.G_RET_STS_SUCCESS;
6370: -- Get message count and data
6371: OE_MSG_PUB.Count_And_Get
6372: ( p_count => x_msg_count
6373: , p_data => x_msg_data
6374: );
6375:
6378: EXCEPTION /* Procedure exception handler */
6379:
6380: WHEN FND_API.G_EXC_ERROR THEN
6381: x_return_status := FND_API.G_RET_STS_ERROR ;
6382: OE_MSG_PUB.Count_And_Get
6383: ( p_count => x_msg_count,
6384: p_data => x_msg_data
6385: );
6386: ROLLBACK TO SAVEPOINT process_apply_holds_orders;
6386: ROLLBACK TO SAVEPOINT process_apply_holds_orders;
6387:
6388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6390: OE_MSG_PUB.Count_And_Get
6391: ( p_count => x_msg_count,
6392: p_data => x_msg_data
6393: );
6394: ROLLBACK TO SAVEPOINT process_apply_holds_orders;
6394: ROLLBACK TO SAVEPOINT process_apply_holds_orders;
6395:
6396: WHEN OTHERS THEN
6397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6398: IF OE_MSG_PUB.Check_Msg_Level
6399: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6400: THEN
6401: OE_MSG_PUB.Add_Exc_Msg
6402: (G_PKG_NAME,
6395:
6396: WHEN OTHERS THEN
6397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6398: IF OE_MSG_PUB.Check_Msg_Level
6399: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6400: THEN
6401: OE_MSG_PUB.Add_Exc_Msg
6402: (G_PKG_NAME,
6403: l_api_name
6397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6398: IF OE_MSG_PUB.Check_Msg_Level
6399: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6400: THEN
6401: OE_MSG_PUB.Add_Exc_Msg
6402: (G_PKG_NAME,
6403: l_api_name
6404: );
6405: END IF;
6402: (G_PKG_NAME,
6403: l_api_name
6404: );
6405: END IF;
6406: OE_MSG_PUB.Count_And_Get
6407: ( p_count => x_msg_count,
6408: p_data => x_msg_data);
6409: ROLLBACK TO SAVEPOINT process_apply_holds_orders;
6410:
6448: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID;
6449: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;
6450: l_msg_token VARCHAR2(100);
6451: BEGIN
6452: oe_msg_pub.initialize;
6453:
6454: OE_DEBUG_PUB.Add('Entering OE_Holds_PVT.process_release_holds_lines',1);
6455:
6456: IF check_system_holds( p_hold_id => p_hold_id
6459: ,x_msg_data => x_msg_data
6460: ) = 'N' THEN
6461: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(p_hold_id));
6462: fnd_message.set_name('ONT', 'ONT_HOLDS_SYSTEM_CHECK');
6463: OE_MSG_PUB.ADD;
6464: x_return_status := FND_API.G_RET_STS_ERROR;
6465: OE_MSG_PUB.Count_And_Get
6466: ( p_count => x_msg_count
6467: , p_data => x_msg_data
6461: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(p_hold_id));
6462: fnd_message.set_name('ONT', 'ONT_HOLDS_SYSTEM_CHECK');
6463: OE_MSG_PUB.ADD;
6464: x_return_status := FND_API.G_RET_STS_ERROR;
6465: OE_MSG_PUB.Count_And_Get
6466: ( p_count => x_msg_count
6467: , p_data => x_msg_data
6468: );
6469: RETURN;
6485:
6486: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
6487: fnd_message.set_token('ACTION', l_msg_token);
6488:
6489: OE_MSG_PUB.ADD;
6490: -- RAISE FND_API.G_EXC_ERROR;
6491: x_return_status := FND_API.G_RET_STS_ERROR;
6492: OE_MSG_PUB.Count_And_Get
6493: ( p_count => x_msg_count
6488:
6489: OE_MSG_PUB.ADD;
6490: -- RAISE FND_API.G_EXC_ERROR;
6491: x_return_status := FND_API.G_RET_STS_ERROR;
6492: OE_MSG_PUB.Count_And_Get
6493: ( p_count => x_msg_count
6494: , p_data => x_msg_data
6495: );
6496: RETURN;
6548: END LOOP;
6549:
6550: x_return_status := FND_API.G_RET_STS_SUCCESS;
6551: -- Get message count and data
6552: OE_MSG_PUB.Count_And_Get
6553: ( p_count => x_msg_count
6554: , p_data => x_msg_data
6555: );
6556:
6559: EXCEPTION /* Procedure exception handler */
6560:
6561: WHEN FND_API.G_EXC_ERROR THEN
6562: x_return_status := FND_API.G_RET_STS_ERROR ;
6563: OE_MSG_PUB.Count_And_Get
6564: ( p_count => x_msg_count,
6565: p_data => x_msg_data
6566: );
6567: ROLLBACK TO SAVEPOINT process_release_holds_lines;
6567: ROLLBACK TO SAVEPOINT process_release_holds_lines;
6568:
6569: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6571: OE_MSG_PUB.Count_And_Get
6572: ( p_count => x_msg_count,
6573: p_data => x_msg_data
6574: );
6575: ROLLBACK TO SAVEPOINT process_release_holds_lines;
6575: ROLLBACK TO SAVEPOINT process_release_holds_lines;
6576:
6577: WHEN OTHERS THEN
6578: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6579: IF OE_MSG_PUB.Check_Msg_Level
6580: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6581: THEN
6582: OE_MSG_PUB.Add_Exc_Msg
6583: (G_PKG_NAME,
6576:
6577: WHEN OTHERS THEN
6578: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6579: IF OE_MSG_PUB.Check_Msg_Level
6580: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6581: THEN
6582: OE_MSG_PUB.Add_Exc_Msg
6583: (G_PKG_NAME,
6584: l_api_name
6578: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6579: IF OE_MSG_PUB.Check_Msg_Level
6580: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6581: THEN
6582: OE_MSG_PUB.Add_Exc_Msg
6583: (G_PKG_NAME,
6584: l_api_name
6585: );
6586: END IF;
6583: (G_PKG_NAME,
6584: l_api_name
6585: );
6586: END IF;
6587: OE_MSG_PUB.Count_And_Get
6588: ( p_count => x_msg_count,
6589: p_data => x_msg_data);
6590: ROLLBACK TO SAVEPOINT process_release_holds_lines;
6591:
6623: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID;
6624: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;
6625: l_msg_token VARCHAR2(100);
6626: BEGIN
6627: oe_msg_pub.initialize;
6628:
6629: OE_DEBUG_PUB.Add('Entering OE_Holds_PVT.process_release_holds_orders',1);
6630:
6631: IF check_system_holds( p_hold_id => p_hold_id
6634: ,x_msg_data => x_msg_data
6635: ) = 'N' THEN
6636: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(p_hold_id));
6637: fnd_message.set_name('ONT', 'ONT_HOLDS_SYSTEM_CHECK');
6638: OE_MSG_PUB.ADD;
6639: x_return_status := FND_API.G_RET_STS_ERROR;
6640: OE_MSG_PUB.Count_And_Get
6641: ( p_count => x_msg_count
6642: , p_data => x_msg_data
6636: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(p_hold_id));
6637: fnd_message.set_name('ONT', 'ONT_HOLDS_SYSTEM_CHECK');
6638: OE_MSG_PUB.ADD;
6639: x_return_status := FND_API.G_RET_STS_ERROR;
6640: OE_MSG_PUB.Count_And_Get
6641: ( p_count => x_msg_count
6642: , p_data => x_msg_data
6643: );
6644: RETURN;
6660:
6661: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
6662: fnd_message.set_token('ACTION', l_msg_token);
6663:
6664: OE_MSG_PUB.ADD;
6665: -- RAISE FND_API.G_EXC_ERROR;
6666: x_return_status := FND_API.G_RET_STS_ERROR;
6667:
6668: OE_MSG_PUB.Count_And_Get
6664: OE_MSG_PUB.ADD;
6665: -- RAISE FND_API.G_EXC_ERROR;
6666: x_return_status := FND_API.G_RET_STS_ERROR;
6667:
6668: OE_MSG_PUB.Count_And_Get
6669: ( p_count => x_msg_count
6670: , p_data => x_msg_data
6671: );
6672:
6717: END LOOP;
6718:
6719: x_return_status := FND_API.G_RET_STS_SUCCESS;
6720: -- Get message count and data
6721: OE_MSG_PUB.Count_And_Get
6722: ( p_count => x_msg_count
6723: , p_data => x_msg_data
6724: );
6725:
6728: EXCEPTION /* Procedure exception handler */
6729:
6730: WHEN FND_API.G_EXC_ERROR THEN
6731: x_return_status := FND_API.G_RET_STS_ERROR ;
6732: OE_MSG_PUB.Count_And_Get
6733: ( p_count => x_msg_count,
6734: p_data => x_msg_data
6735: );
6736: ROLLBACK TO SAVEPOINT process_release_holds_orders;
6736: ROLLBACK TO SAVEPOINT process_release_holds_orders;
6737:
6738: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6739: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6740: OE_MSG_PUB.Count_And_Get
6741: ( p_count => x_msg_count,
6742: p_data => x_msg_data
6743: );
6744: ROLLBACK TO SAVEPOINT process_release_holds_orders;
6744: ROLLBACK TO SAVEPOINT process_release_holds_orders;
6745:
6746: WHEN OTHERS THEN
6747: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6748: IF OE_MSG_PUB.Check_Msg_Level
6749: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6750: THEN
6751: OE_MSG_PUB.Add_Exc_Msg
6752: (G_PKG_NAME,
6745:
6746: WHEN OTHERS THEN
6747: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6748: IF OE_MSG_PUB.Check_Msg_Level
6749: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6750: THEN
6751: OE_MSG_PUB.Add_Exc_Msg
6752: (G_PKG_NAME,
6753: l_api_name
6747: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6748: IF OE_MSG_PUB.Check_Msg_Level
6749: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6750: THEN
6751: OE_MSG_PUB.Add_Exc_Msg
6752: (G_PKG_NAME,
6753: l_api_name
6754: );
6755: END IF;
6752: (G_PKG_NAME,
6753: l_api_name
6754: );
6755: END IF;
6756: OE_MSG_PUB.Count_And_Get
6757: ( p_count => x_msg_count,
6758: p_data => x_msg_data);
6759: ROLLBACK TO SAVEPOINT process_release_holds_orders;
6760:
6793:
6794: --
6795: BEGIN
6796: oe_debug_pub.add('In process_create_holds', 1);
6797: oe_msg_pub.initialize; --bug 5548778
6798: l_hold_source_rec := p_hold_source_rec;
6799:
6800: if check_system_holds( p_hold_id => l_hold_source_rec.hold_id
6801: ,x_return_status => x_return_status
6803: ,x_msg_data => x_msg_data
6804: ) = 'N' THEN
6805: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(l_hold_source_rec.hold_id));
6806: fnd_message.set_name('ONT', 'ONT_HOLDS_SYSTEM_CHECK');
6807: OE_MSG_PUB.ADD;
6808: x_return_status := FND_API.G_RET_STS_ERROR;
6809: OE_MSG_PUB.Count_And_Get
6810: ( p_count => x_msg_count
6811: , p_data => x_msg_data
6805: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(l_hold_source_rec.hold_id));
6806: fnd_message.set_name('ONT', 'ONT_HOLDS_SYSTEM_CHECK');
6807: OE_MSG_PUB.ADD;
6808: x_return_status := FND_API.G_RET_STS_ERROR;
6809: OE_MSG_PUB.Count_And_Get
6810: ( p_count => x_msg_count
6811: , p_data => x_msg_data
6812: );
6813: return;
6829:
6830: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
6831: fnd_message.set_token('ACTION', l_msg_token);
6832:
6833: OE_MSG_PUB.ADD;
6834: RAISE FND_API.G_EXC_ERROR;
6835: x_return_status := FND_API.G_RET_STS_ERROR;
6836: OE_MSG_PUB.Count_And_Get
6837: ( p_count => x_msg_count
6832:
6833: OE_MSG_PUB.ADD;
6834: RAISE FND_API.G_EXC_ERROR;
6835: x_return_status := FND_API.G_RET_STS_ERROR;
6836: OE_MSG_PUB.Count_And_Get
6837: ( p_count => x_msg_count
6838: , p_data => x_msg_data
6839: );
6840: return;
6948: oe_debug_pub.add ('Do nothing',3);
6949: end if; -- (p_hold_existing_flg = 'Y' AND p_hold_future_flg 'Y')
6950: -- Get message count and data
6951:
6952: OE_MSG_PUB.Count_And_Get
6953: ( p_count => x_msg_count
6954: , p_data => x_msg_data
6955: );
6956:
6958: EXCEPTION /* Procedure exception handler */
6959:
6960: WHEN FND_API.G_EXC_ERROR THEN
6961: x_return_status := FND_API.G_RET_STS_ERROR ;
6962: OE_MSG_PUB.Count_And_Get
6963: ( p_count => x_msg_count,
6964: p_data => x_msg_data
6965: );
6966:
6965: );
6966:
6967: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6968: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6969: OE_MSG_PUB.Count_And_Get
6970: ( p_count => x_msg_count,
6971: p_data => x_msg_data
6972: );
6973:
6972: );
6973:
6974: WHEN OTHERS THEN
6975: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6976: IF OE_MSG_PUB.Check_Msg_Level
6977: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6978: THEN
6979: OE_MSG_PUB.Add_Exc_Msg
6980: (G_PKG_NAME,
6973:
6974: WHEN OTHERS THEN
6975: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6976: IF OE_MSG_PUB.Check_Msg_Level
6977: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6978: THEN
6979: OE_MSG_PUB.Add_Exc_Msg
6980: (G_PKG_NAME,
6981: l_api_name
6975: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6976: IF OE_MSG_PUB.Check_Msg_Level
6977: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6978: THEN
6979: OE_MSG_PUB.Add_Exc_Msg
6980: (G_PKG_NAME,
6981: l_api_name
6982: );
6983: END IF;
6980: (G_PKG_NAME,
6981: l_api_name
6982: );
6983: END IF;
6984: OE_MSG_PUB.Count_And_Get
6985: ( p_count => x_msg_count,
6986: p_data => x_msg_data);
6987:
6988:
7030: If l_hold_id = 1 AND (l_hold_entity_code ='C' OR l_hold_entity_code = 'B') then
7031: OE_DEBUG_PUB.Add('Bug 1946783 Credit Hold should be released from AR',1);
7032:
7033: fnd_message.set_name('ONT', 'OE_CC_AR_HOLD_NOT_RELEASED');
7034: OE_MSG_PUB.ADD;
7035: RAISE FND_API.G_EXC_ERROR;
7036: x_return_status := FND_API.G_RET_STS_ERROR;
7037: OE_MSG_PUB.Count_And_Get
7038: ( p_count => x_msg_count
7033: fnd_message.set_name('ONT', 'OE_CC_AR_HOLD_NOT_RELEASED');
7034: OE_MSG_PUB.ADD;
7035: RAISE FND_API.G_EXC_ERROR;
7036: x_return_status := FND_API.G_RET_STS_ERROR;
7037: OE_MSG_PUB.Count_And_Get
7038: ( p_count => x_msg_count
7039: , p_data => x_msg_data
7040: );
7041: return;
7051: ) = 'N' THEN
7052: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(l_hold_id));
7053: fnd_message.set_name('ONT', 'ONT_HOLDS_SYSTEM_CHECK');
7054: fnd_message.set_token('ACTION', 'Release');
7055: OE_MSG_PUB.ADD;
7056: x_return_status := FND_API.G_RET_STS_ERROR;
7057: OE_MSG_PUB.Count_And_Get
7058: ( p_count => x_msg_count
7059: , p_data => x_msg_data
7053: fnd_message.set_name('ONT', 'ONT_HOLDS_SYSTEM_CHECK');
7054: fnd_message.set_token('ACTION', 'Release');
7055: OE_MSG_PUB.ADD;
7056: x_return_status := FND_API.G_RET_STS_ERROR;
7057: OE_MSG_PUB.Count_And_Get
7058: ( p_count => x_msg_count
7059: , p_data => x_msg_data
7060: );
7061: return;
7076:
7077: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
7078: fnd_message.set_token('ACTION', l_msg_token);
7079:
7080: OE_MSG_PUB.ADD;
7081: RAISE FND_API.G_EXC_ERROR;
7082: x_return_status := FND_API.G_RET_STS_ERROR;
7083: OE_MSG_PUB.Count_And_Get
7084: ( p_count => x_msg_count
7079:
7080: OE_MSG_PUB.ADD;
7081: RAISE FND_API.G_EXC_ERROR;
7082: x_return_status := FND_API.G_RET_STS_ERROR;
7083: OE_MSG_PUB.Count_And_Get
7084: ( p_count => x_msg_count
7085: , p_data => x_msg_data
7086: );
7087: return;
7110: END IF;
7111:
7112: x_return_status := FND_API.G_RET_STS_SUCCESS;
7113: -- Get message count and data
7114: OE_MSG_PUB.Count_And_Get
7115: ( p_count => x_msg_count
7116: , p_data => x_msg_data
7117: );
7118:
7120: EXCEPTION /* Procedure exception handler */
7121:
7122: WHEN FND_API.G_EXC_ERROR THEN
7123: x_return_status := FND_API.G_RET_STS_ERROR ;
7124: OE_MSG_PUB.Count_And_Get
7125: ( p_count => x_msg_count,
7126: p_data => x_msg_data
7127: );
7128:
7127: );
7128:
7129: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7131: OE_MSG_PUB.Count_And_Get
7132: ( p_count => x_msg_count,
7133: p_data => x_msg_data
7134: );
7135:
7134: );
7135:
7136: WHEN OTHERS THEN
7137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7138: IF OE_MSG_PUB.Check_Msg_Level
7139: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7140: THEN
7141: OE_MSG_PUB.Add_Exc_Msg
7142: (G_PKG_NAME,
7135:
7136: WHEN OTHERS THEN
7137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7138: IF OE_MSG_PUB.Check_Msg_Level
7139: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7140: THEN
7141: OE_MSG_PUB.Add_Exc_Msg
7142: (G_PKG_NAME,
7143: l_api_name
7137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7138: IF OE_MSG_PUB.Check_Msg_Level
7139: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7140: THEN
7141: OE_MSG_PUB.Add_Exc_Msg
7142: (G_PKG_NAME,
7143: l_api_name
7144: );
7145: END IF;
7142: (G_PKG_NAME,
7143: l_api_name
7144: );
7145: END IF;
7146: OE_MSG_PUB.Count_And_Get
7147: ( p_count => x_msg_count,
7148: p_data => x_msg_data);
7149:
7150: end process_release_source;
7205: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID;
7206: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;
7207: l_msg_token VARCHAR2(100);
7208: BEGIN
7209: oe_msg_pub.initialize;
7210:
7211: OE_DEBUG_PUB.Add('Entering OE_Holds_PVT.process_release_holds_lines',1);
7212:
7213: IF check_system_holds( p_hold_id => p_hold_id
7216: ,x_msg_data => x_msg_data
7217: ) = 'N' THEN
7218: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(p_hold_id));
7219: fnd_message.set_name('ONT', 'ONT_HOLDS_SYSTEM_CHECK');
7220: OE_MSG_PUB.ADD;
7221: x_return_status := FND_API.G_RET_STS_ERROR;
7222: OE_MSG_PUB.Count_And_Get
7223: ( p_count => x_msg_count
7224: , p_data => x_msg_data
7218: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(p_hold_id));
7219: fnd_message.set_name('ONT', 'ONT_HOLDS_SYSTEM_CHECK');
7220: OE_MSG_PUB.ADD;
7221: x_return_status := FND_API.G_RET_STS_ERROR;
7222: OE_MSG_PUB.Count_And_Get
7223: ( p_count => x_msg_count
7224: , p_data => x_msg_data
7225: );
7226: RETURN;
7242:
7243: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
7244: fnd_message.set_token('ACTION', l_msg_token);
7245:
7246: OE_MSG_PUB.ADD;
7247: -- RAISE FND_API.G_EXC_ERROR;
7248: x_return_status := FND_API.G_RET_STS_ERROR;
7249: OE_MSG_PUB.Count_And_Get
7250: ( p_count => x_msg_count
7245:
7246: OE_MSG_PUB.ADD;
7247: -- RAISE FND_API.G_EXC_ERROR;
7248: x_return_status := FND_API.G_RET_STS_ERROR;
7249: OE_MSG_PUB.Count_And_Get
7250: ( p_count => x_msg_count
7251: , p_data => x_msg_data
7252: );
7253: RETURN;
7319: END LOOP;
7320:
7321: x_return_status := FND_API.G_RET_STS_SUCCESS;
7322: -- Get message count and data
7323: OE_MSG_PUB.Count_And_Get
7324: ( p_count => x_msg_count
7325: , p_data => x_msg_data
7326: );
7327:
7330: EXCEPTION /* Procedure exception handler */
7331:
7332: WHEN FND_API.G_EXC_ERROR THEN
7333: x_return_status := FND_API.G_RET_STS_ERROR ;
7334: OE_MSG_PUB.Count_And_Get
7335: ( p_count => x_msg_count,
7336: p_data => x_msg_data
7337: );
7338: ROLLBACK TO SAVEPOINT process_release_holds_lines;
7338: ROLLBACK TO SAVEPOINT process_release_holds_lines;
7339:
7340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7342: OE_MSG_PUB.Count_And_Get
7343: ( p_count => x_msg_count,
7344: p_data => x_msg_data
7345: );
7346: ROLLBACK TO SAVEPOINT process_release_holds_lines;
7346: ROLLBACK TO SAVEPOINT process_release_holds_lines;
7347:
7348: WHEN OTHERS THEN
7349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7350: IF OE_MSG_PUB.Check_Msg_Level
7351: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7352: THEN
7353: OE_MSG_PUB.Add_Exc_Msg
7354: (G_PKG_NAME,
7347:
7348: WHEN OTHERS THEN
7349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7350: IF OE_MSG_PUB.Check_Msg_Level
7351: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7352: THEN
7353: OE_MSG_PUB.Add_Exc_Msg
7354: (G_PKG_NAME,
7355: l_api_name
7349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7350: IF OE_MSG_PUB.Check_Msg_Level
7351: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7352: THEN
7353: OE_MSG_PUB.Add_Exc_Msg
7354: (G_PKG_NAME,
7355: l_api_name
7356: );
7357: END IF;
7354: (G_PKG_NAME,
7355: l_api_name
7356: );
7357: END IF;
7358: OE_MSG_PUB.Count_And_Get
7359: ( p_count => x_msg_count,
7360: p_data => x_msg_data);
7361: ROLLBACK TO SAVEPOINT process_release_holds_lines;
7362:
7413: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID;
7414: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;
7415: l_msg_token VARCHAR2(100);
7416: BEGIN
7417: oe_msg_pub.initialize;
7418:
7419: OE_DEBUG_PUB.Add('Entering OE_Holds_PVT.process_release_holds_orders',1);
7420:
7421: IF check_system_holds( p_hold_id => p_hold_id
7424: ,x_msg_data => x_msg_data
7425: ) = 'N' THEN
7426: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(p_hold_id));
7427: fnd_message.set_name('ONT', 'ONT_HOLDS_SYSTEM_CHECK');
7428: OE_MSG_PUB.ADD;
7429: x_return_status := FND_API.G_RET_STS_ERROR;
7430: OE_MSG_PUB.Count_And_Get
7431: ( p_count => x_msg_count
7432: , p_data => x_msg_data
7426: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(p_hold_id));
7427: fnd_message.set_name('ONT', 'ONT_HOLDS_SYSTEM_CHECK');
7428: OE_MSG_PUB.ADD;
7429: x_return_status := FND_API.G_RET_STS_ERROR;
7430: OE_MSG_PUB.Count_And_Get
7431: ( p_count => x_msg_count
7432: , p_data => x_msg_data
7433: );
7434: RETURN;
7450:
7451: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
7452: fnd_message.set_token('ACTION', l_msg_token);
7453:
7454: OE_MSG_PUB.ADD;
7455: -- RAISE FND_API.G_EXC_ERROR;
7456: x_return_status := FND_API.G_RET_STS_ERROR;
7457:
7458: OE_MSG_PUB.Count_And_Get
7454: OE_MSG_PUB.ADD;
7455: -- RAISE FND_API.G_EXC_ERROR;
7456: x_return_status := FND_API.G_RET_STS_ERROR;
7457:
7458: OE_MSG_PUB.Count_And_Get
7459: ( p_count => x_msg_count
7460: , p_data => x_msg_data
7461: );
7462:
7521: END LOOP;
7522:
7523: x_return_status := FND_API.G_RET_STS_SUCCESS;
7524: -- Get message count and data
7525: OE_MSG_PUB.Count_And_Get
7526: ( p_count => x_msg_count
7527: , p_data => x_msg_data
7528: );
7529:
7532: EXCEPTION /* Procedure exception handler */
7533:
7534: WHEN FND_API.G_EXC_ERROR THEN
7535: x_return_status := FND_API.G_RET_STS_ERROR ;
7536: OE_MSG_PUB.Count_And_Get
7537: ( p_count => x_msg_count,
7538: p_data => x_msg_data
7539: );
7540: ROLLBACK TO SAVEPOINT process_release_holds_orders;
7540: ROLLBACK TO SAVEPOINT process_release_holds_orders;
7541:
7542: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7543: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7544: OE_MSG_PUB.Count_And_Get
7545: ( p_count => x_msg_count,
7546: p_data => x_msg_data
7547: );
7548: ROLLBACK TO SAVEPOINT process_release_holds_orders;
7548: ROLLBACK TO SAVEPOINT process_release_holds_orders;
7549:
7550: WHEN OTHERS THEN
7551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7552: IF OE_MSG_PUB.Check_Msg_Level
7553: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7554: THEN
7555: OE_MSG_PUB.Add_Exc_Msg
7556: (G_PKG_NAME,
7549:
7550: WHEN OTHERS THEN
7551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7552: IF OE_MSG_PUB.Check_Msg_Level
7553: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7554: THEN
7555: OE_MSG_PUB.Add_Exc_Msg
7556: (G_PKG_NAME,
7557: l_api_name
7551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7552: IF OE_MSG_PUB.Check_Msg_Level
7553: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7554: THEN
7555: OE_MSG_PUB.Add_Exc_Msg
7556: (G_PKG_NAME,
7557: l_api_name
7558: );
7559: END IF;
7556: (G_PKG_NAME,
7557: l_api_name
7558: );
7559: END IF;
7560: OE_MSG_PUB.Count_And_Get
7561: ( p_count => x_msg_count,
7562: p_data => x_msg_data);
7563: ROLLBACK TO SAVEPOINT process_release_holds_orders;
7564:
7620: If l_hold_id = 1 AND (l_hold_entity_code ='C' OR l_hold_entity_code = 'B') then
7621: OE_DEBUG_PUB.Add('Bug 1946783 Credit Hold should be released from AR',1);
7622:
7623: fnd_message.set_name('ONT', 'OE_CC_AR_HOLD_NOT_RELEASED');
7624: OE_MSG_PUB.ADD;
7625: RAISE FND_API.G_EXC_ERROR;
7626: x_return_status := FND_API.G_RET_STS_ERROR;
7627: OE_MSG_PUB.Count_And_Get
7628: ( p_count => x_msg_count
7623: fnd_message.set_name('ONT', 'OE_CC_AR_HOLD_NOT_RELEASED');
7624: OE_MSG_PUB.ADD;
7625: RAISE FND_API.G_EXC_ERROR;
7626: x_return_status := FND_API.G_RET_STS_ERROR;
7627: OE_MSG_PUB.Count_And_Get
7628: ( p_count => x_msg_count
7629: , p_data => x_msg_data
7630: );
7631: return;
7641: ) = 'N' THEN
7642: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(l_hold_id));
7643: fnd_message.set_name('ONT', 'ONT_HOLDS_SYSTEM_CHECK');
7644: fnd_message.set_token('ACTION', 'Release');
7645: OE_MSG_PUB.ADD;
7646: x_return_status := FND_API.G_RET_STS_ERROR;
7647: OE_MSG_PUB.Count_And_Get
7648: ( p_count => x_msg_count
7649: , p_data => x_msg_data
7643: fnd_message.set_name('ONT', 'ONT_HOLDS_SYSTEM_CHECK');
7644: fnd_message.set_token('ACTION', 'Release');
7645: OE_MSG_PUB.ADD;
7646: x_return_status := FND_API.G_RET_STS_ERROR;
7647: OE_MSG_PUB.Count_And_Get
7648: ( p_count => x_msg_count
7649: , p_data => x_msg_data
7650: );
7651: return;
7667:
7668: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
7669: fnd_message.set_token('ACTION', l_msg_token);
7670:
7671: OE_MSG_PUB.ADD;
7672: RAISE FND_API.G_EXC_ERROR;
7673: x_return_status := FND_API.G_RET_STS_ERROR;
7674: OE_MSG_PUB.Count_And_Get
7675: ( p_count => x_msg_count
7670:
7671: OE_MSG_PUB.ADD;
7672: RAISE FND_API.G_EXC_ERROR;
7673: x_return_status := FND_API.G_RET_STS_ERROR;
7674: OE_MSG_PUB.Count_And_Get
7675: ( p_count => x_msg_count
7676: , p_data => x_msg_data
7677: );
7678: return;
7716: END IF;
7717:
7718: x_return_status := FND_API.G_RET_STS_SUCCESS;
7719: -- Get message count and data
7720: OE_MSG_PUB.Count_And_Get
7721: ( p_count => x_msg_count
7722: , p_data => x_msg_data
7723: );
7724:
7726: EXCEPTION /* Procedure exception handler */
7727:
7728: WHEN FND_API.G_EXC_ERROR THEN
7729: x_return_status := FND_API.G_RET_STS_ERROR ;
7730: OE_MSG_PUB.Count_And_Get
7731: ( p_count => x_msg_count,
7732: p_data => x_msg_data
7733: );
7734:
7733: );
7734:
7735: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7736: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7737: OE_MSG_PUB.Count_And_Get
7738: ( p_count => x_msg_count,
7739: p_data => x_msg_data
7740: );
7741:
7740: );
7741:
7742: WHEN OTHERS THEN
7743: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7744: IF OE_MSG_PUB.Check_Msg_Level
7745: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7746: THEN
7747: OE_MSG_PUB.Add_Exc_Msg
7748: (G_PKG_NAME,
7741:
7742: WHEN OTHERS THEN
7743: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7744: IF OE_MSG_PUB.Check_Msg_Level
7745: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7746: THEN
7747: OE_MSG_PUB.Add_Exc_Msg
7748: (G_PKG_NAME,
7749: l_api_name
7743: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7744: IF OE_MSG_PUB.Check_Msg_Level
7745: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7746: THEN
7747: OE_MSG_PUB.Add_Exc_Msg
7748: (G_PKG_NAME,
7749: l_api_name
7750: );
7751: END IF;
7748: (G_PKG_NAME,
7749: l_api_name
7750: );
7751: END IF;
7752: OE_MSG_PUB.Count_And_Get
7753: ( p_count => x_msg_count,
7754: p_data => x_msg_data);
7755:
7756: end process_release_source;
7893: WHEN NO_DATA_FOUND then
7894: null; -- its ok if there is not holds on the orignal line
7895: WHEN FND_API.G_EXC_ERROR THEN
7896: x_return_status := FND_API.G_RET_STS_ERROR;
7897: OE_MSG_PUB.Count_And_Get
7898: ( p_count => x_msg_count
7899: , p_data => x_msg_data
7900: );
7901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7899: , p_data => x_msg_data
7900: );
7901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7903: OE_MSG_PUB.Count_And_Get
7904: ( p_count => x_msg_count
7905: , p_data => x_msg_data
7906: );
7907: WHEN OTHERS THEN
7905: , p_data => x_msg_data
7906: );
7907: WHEN OTHERS THEN
7908: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7909: IF OE_MSG_PUB.Check_Msg_Level
7910: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7911: THEN
7912: OE_MSG_PUB.Add_Exc_Msg
7913: ( G_PKG_NAME,
7906: );
7907: WHEN OTHERS THEN
7908: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7909: IF OE_MSG_PUB.Check_Msg_Level
7910: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7911: THEN
7912: OE_MSG_PUB.Add_Exc_Msg
7913: ( G_PKG_NAME,
7914: l_api_name);
7908: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7909: IF OE_MSG_PUB.Check_Msg_Level
7910: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7911: THEN
7912: OE_MSG_PUB.Add_Exc_Msg
7913: ( G_PKG_NAME,
7914: l_api_name);
7915: END IF;
7916: OE_MSG_PUB.Count_And_Get
7912: OE_MSG_PUB.Add_Exc_Msg
7913: ( G_PKG_NAME,
7914: l_api_name);
7915: END IF;
7916: OE_MSG_PUB.Count_And_Get
7917: ( p_count => x_msg_count
7918: , p_data => x_msg_data
7919: );
7920:
8378: and lookup_code = p_activity_name;
8379:
8380: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
8381: fnd_message.set_token('WF_ACT', l_user_activity_name);
8382: OE_MSG_PUB.ADD;
8383: oe_debug_pub.add(' Hold Not applied for All requested records');
8384: RAISE FND_API.G_EXC_ERROR;
8385: ELSIF l_sql_rowcount > 0 THEN
8386: SELECT count(*)
8411: and lookup_code = p_activity_name;
8412:
8413: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
8414: fnd_message.set_token('WF_ACT', l_user_activity_name);
8415: OE_MSG_PUB.ADD;
8416: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
8417: END IF;
8418: END IF;
8419: END IF;
8700: and lookup_code = p_activity_name;
8701:
8702: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
8703: fnd_message.set_token('WF_ACT', l_user_activity_name);
8704: OE_MSG_PUB.ADD;
8705: oe_debug_pub.add(' Hold Not applied for All requested records');
8706: RAISE FND_API.G_EXC_ERROR;
8707: ELSIF l_sql_rowcount > 0 THEN
8708: SELECT count(*)
8735: and lookup_code = p_activity_name;
8736:
8737: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
8738: fnd_message.set_token('WF_ACT', l_user_activity_name);
8739: OE_MSG_PUB.ADD;
8740: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
8741: END IF;
8742: END IF;
8743: END IF;
8917: and lookup_code = p_activity_name;
8918:
8919: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
8920: fnd_message.set_token('WF_ACT', l_user_activity_name);
8921: OE_MSG_PUB.ADD;
8922: oe_debug_pub.add(' Hold Not applied for All requested records');
8923: RAISE FND_API.G_EXC_ERROR;
8924: ELSIF l_sql_rowcount > 0 THEN
8925: SELECT count(*)
8950: and lookup_code = p_activity_name;
8951:
8952: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
8953: fnd_message.set_token('WF_ACT', l_user_activity_name);
8954: OE_MSG_PUB.ADD;
8955: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
8956: END IF;
8957: END IF;
8958: END IF;
9130: and lookup_code = p_activity_name;
9131:
9132: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
9133: fnd_message.set_token('WF_ACT', l_user_activity_name);
9134: OE_MSG_PUB.ADD;
9135: oe_debug_pub.add(' Hold Not applied for All requested records');
9136: RAISE FND_API.G_EXC_ERROR;
9137: ELSIF l_sql_rowcount > 0 THEN
9138: SELECT count(*)
9162: and lookup_code = p_activity_name;
9163:
9164: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
9165: fnd_message.set_token('WF_ACT', l_user_activity_name);
9166: OE_MSG_PUB.ADD;
9167: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
9168: END IF;
9169: END IF;
9170: END IF;
9344: and lookup_code = p_activity_name;
9345:
9346: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
9347: fnd_message.set_token('WF_ACT', l_user_activity_name);
9348: OE_MSG_PUB.ADD;
9349: oe_debug_pub.add(' Hold Not applied for All requested records');
9350: RAISE FND_API.G_EXC_ERROR;
9351: ELSIF l_sql_rowcount > 0 THEN
9352: SELECT count(*)
9377: and lookup_code = p_activity_name;
9378:
9379: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
9380: fnd_message.set_token('WF_ACT', l_user_activity_name);
9381: OE_MSG_PUB.ADD;
9382: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
9383: END IF;
9384: END IF;
9385: END IF;
9558: and lookup_code = p_activity_name;
9559:
9560: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
9561: fnd_message.set_token('WF_ACT', l_user_activity_name);
9562: OE_MSG_PUB.ADD;
9563: oe_debug_pub.add(' Hold Not applied for All requested records');
9564: RAISE FND_API.G_EXC_ERROR;
9565: ELSIF l_sql_rowcount > 0 THEN
9566: SELECT count(*)
9591: and lookup_code = p_activity_name;
9592:
9593: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
9594: fnd_message.set_token('WF_ACT', l_user_activity_name);
9595: OE_MSG_PUB.ADD;
9596: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
9597: END IF;
9598: END IF;
9599: END IF;
9776: and lookup_code = p_activity_name;
9777:
9778: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
9779: fnd_message.set_token('WF_ACT', l_user_activity_name);
9780: OE_MSG_PUB.ADD;
9781: oe_debug_pub.add(' Hold Not applied for All requested records');
9782: RAISE FND_API.G_EXC_ERROR;
9783: ELSIF l_sql_rowcount > 0 THEN
9784: SELECT count(*)
9809: and lookup_code = p_activity_name;
9810:
9811: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
9812: fnd_message.set_token('WF_ACT', l_user_activity_name);
9813: OE_MSG_PUB.ADD;
9814: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
9815: END IF;
9816: END IF;
9817: END IF;
10081: and lookup_code = p_activity_name;
10082:
10083: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
10084: fnd_message.set_token('WF_ACT', l_user_activity_name);
10085: OE_MSG_PUB.ADD;
10086: oe_debug_pub.add(' Hold Not applied for All requested records');
10087: RAISE FND_API.G_EXC_ERROR;
10088: ELSIF l_sql_rowcount > 0 THEN
10089: SELECT count(*)
10114: and lookup_code = p_activity_name;
10115:
10116: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
10117: fnd_message.set_token('WF_ACT', l_user_activity_name);
10118: OE_MSG_PUB.ADD;
10119: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
10120: END IF;
10121: END IF;
10122: END IF;
10295: and lookup_code = p_activity_name;
10296:
10297: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
10298: fnd_message.set_token('WF_ACT', l_user_activity_name);
10299: OE_MSG_PUB.ADD;
10300: oe_debug_pub.add(' Hold Not applied for All requested records');
10301: RAISE FND_API.G_EXC_ERROR;
10302: ELSIF l_sql_rowcount > 0 THEN
10303: SELECT count(*)
10328: and lookup_code = p_activity_name;
10329:
10330: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
10331: fnd_message.set_token('WF_ACT', l_user_activity_name);
10332: OE_MSG_PUB.ADD;
10333: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
10334: END IF;
10335: END IF;
10336: END IF;
10512: and lookup_code = p_activity_name;
10513:
10514: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
10515: fnd_message.set_token('WF_ACT', l_user_activity_name);
10516: OE_MSG_PUB.ADD;
10517: oe_debug_pub.add(' Hold Not applied for All requested records');
10518: RAISE FND_API.G_EXC_ERROR;
10519: ELSIF l_sql_rowcount > 0 THEN
10520: SELECT count(*)
10545: and lookup_code = p_activity_name;
10546:
10547: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
10548: fnd_message.set_token('WF_ACT', l_user_activity_name);
10549: OE_MSG_PUB.ADD;
10550: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
10551: END IF;
10552: END IF;
10553: END IF;
10837: and lookup_code = p_activity_name;
10838:
10839: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
10840: fnd_message.set_token('WF_ACT', l_user_activity_name);
10841: OE_MSG_PUB.ADD;
10842: oe_debug_pub.add(' Hold Not applied for All requested records');
10843: RAISE FND_API.G_EXC_ERROR;
10844: ELSIF l_sql_rowcount > 0 THEN
10845: SELECT count(*)
10870: and lookup_code = p_activity_name;
10871:
10872: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
10873: fnd_message.set_token('WF_ACT', l_user_activity_name);
10874: OE_MSG_PUB.ADD;
10875: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
10876: END IF;
10877: END IF;
10878: END IF;
11051: and lookup_code = p_activity_name;
11052:
11053: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
11054: fnd_message.set_token('WF_ACT', l_user_activity_name);
11055: OE_MSG_PUB.ADD;
11056: oe_debug_pub.add(' Hold Not applied for All requested records');
11057: RAISE FND_API.G_EXC_ERROR;
11058: ELSIF l_sql_rowcount > 0 THEN
11059: SELECT count(*)
11084: and lookup_code = p_activity_name;
11085:
11086: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
11087: fnd_message.set_token('WF_ACT', l_user_activity_name);
11088: OE_MSG_PUB.ADD;
11089: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
11090: END IF;
11091: END IF;
11092: END IF;
11265: and lookup_code = p_activity_name;
11266:
11267: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
11268: fnd_message.set_token('WF_ACT', l_user_activity_name);
11269: OE_MSG_PUB.ADD;
11270: oe_debug_pub.add(' Hold Not applied for All requested records');
11271: RAISE FND_API.G_EXC_ERROR;
11272: ELSIF l_sql_rowcount > 0 THEN
11273: SELECT count(*)
11298: and lookup_code = p_activity_name;
11299:
11300: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
11301: fnd_message.set_token('WF_ACT', l_user_activity_name);
11302: OE_MSG_PUB.ADD;
11303: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
11304: END IF;
11305: END IF;
11306: END IF;
11476: and lookup_code = p_activity_name;
11477:
11478: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
11479: fnd_message.set_token('WF_ACT', l_user_activity_name);
11480: OE_MSG_PUB.ADD;
11481: oe_debug_pub.add(' Hold Not applied for All requested records');
11482: RAISE FND_API.G_EXC_ERROR;
11483: ELSIF l_sql_rowcount > 0 THEN
11484: SELECT count(*)
11508: and lookup_code = p_activity_name;
11509:
11510: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
11511: fnd_message.set_token('WF_ACT', l_user_activity_name);
11512: OE_MSG_PUB.ADD;
11513: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
11514: END IF;
11515: END IF;
11516: END IF;
11656: and lookup_code = p_activity_name;
11657:
11658: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
11659: fnd_message.set_token('WF_ACT', l_user_activity_name);
11660: OE_MSG_PUB.ADD;
11661: oe_debug_pub.add(' Hold Not applied for All requested records');
11662: RAISE FND_API.G_EXC_ERROR;
11663: ELSIF l_sql_rowcount > 0 THEN
11664: x_is_hold_applied := TRUE;
11690: and lookup_code = p_activity_name;
11691:
11692: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
11693: fnd_message.set_token('WF_ACT', l_user_activity_name);
11694: OE_MSG_PUB.ADD;
11695: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
11696: END IF;
11697: END IF;
11698: END IF;
11849: and lookup_code = p_activity_name;
11850:
11851: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
11852: fnd_message.set_token('WF_ACT', l_user_activity_name);
11853: OE_MSG_PUB.ADD;
11854: oe_debug_pub.add(' Hold Not applied for All requested records');
11855: RAISE FND_API.G_EXC_ERROR;
11856: ELSIF l_sql_rowcount > 0 THEN
11857: SELECT count(*)
11879: and lookup_code = p_activity_name;
11880:
11881: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
11882: fnd_message.set_token('WF_ACT', l_user_activity_name);
11883: OE_MSG_PUB.ADD;
11884: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
11885: END IF;
11886: END IF;
11887: END IF;
12311: and lookup_code = p_activity_name;
12312:
12313: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
12314: fnd_message.set_token('WF_ACT', l_user_activity_name);
12315: OE_MSG_PUB.ADD;
12316: oe_debug_pub.add(' Hold Not applied for All requested records');
12317: RAISE FND_API.G_EXC_ERROR;
12318: ELSIF l_sql_rowcount > 0 THEN
12319: SELECT count(*)
12343: and lookup_code = p_activity_name;
12344:
12345: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
12346: fnd_message.set_token('WF_ACT', l_user_activity_name);
12347: OE_MSG_PUB.ADD;
12348: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
12349: END IF;
12350: END IF;
12351: END IF;
12523: and lookup_code = p_activity_name;
12524:
12525: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
12526: fnd_message.set_token('WF_ACT', l_user_activity_name);
12527: OE_MSG_PUB.ADD;
12528: oe_debug_pub.add(' Hold Not applied for All requested records');
12529: RAISE FND_API.G_EXC_ERROR;
12530: ELSIF l_sql_rowcount > 0 THEN
12531: SELECT count(*)
12555: and lookup_code = p_activity_name;
12556:
12557: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
12558: fnd_message.set_token('WF_ACT', l_user_activity_name);
12559: OE_MSG_PUB.ADD;
12560: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
12561: END IF;
12562: END IF;
12563: END IF;
12734: and lookup_code = p_activity_name;
12735:
12736: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
12737: fnd_message.set_token('WF_ACT', l_user_activity_name);
12738: OE_MSG_PUB.ADD;
12739: oe_debug_pub.add(' Hold Not applied for All requested records');
12740: RAISE FND_API.G_EXC_ERROR;
12741: ELSIF l_sql_rowcount > 0 THEN
12742: SELECT count(*)
12766: and lookup_code = p_activity_name;
12767:
12768: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
12769: fnd_message.set_token('WF_ACT', l_user_activity_name);
12770: OE_MSG_PUB.ADD;
12771: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
12772: END IF;
12773: END IF;
12774: END IF;
12946: and lookup_code = p_activity_name;
12947:
12948: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
12949: fnd_message.set_token('WF_ACT', l_user_activity_name);
12950: OE_MSG_PUB.ADD;
12951: RAISE FND_API.G_EXC_ERROR;
12952: ELSIF l_sql_rowcount > 0 THEN
12953: SELECT count(*)
12954: into l_parent_count
12977: and lookup_code = p_activity_name;
12978:
12979: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
12980: fnd_message.set_token('WF_ACT', l_user_activity_name);
12981: OE_MSG_PUB.ADD;
12982:
12983: END IF;
12984: END IF;
12985: END IF;
13478: EXCEPTION
13479: WHEN FND_API.G_EXC_ERROR THEN
13480: --ROLLBACK TO APPLY_HOLDS_PUB;
13481: x_return_status := FND_API.G_RET_STS_ERROR;
13482: OE_MSG_PUB.Count_And_Get
13483: ( p_count => x_msg_count
13484: , p_data => x_msg_data
13485: );
13486: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
13485: );
13486: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
13487: --ROLLBACK TO APPLY_HOLDS_PUB;
13488: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13489: OE_MSG_PUB.Count_And_Get
13490: ( p_count => x_msg_count
13491: , p_data => x_msg_data
13492: );
13493: WHEN OTHERS THEN
13492: );
13493: WHEN OTHERS THEN
13494: --ROLLBACK TO APPLY_HOLDS_PUB;
13495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13496: IF OE_MSG_PUB.Check_Msg_Level
13497: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
13498: THEN
13499: OE_MSG_PUB.Add_Exc_Msg
13500: ( G_PKG_NAME
13493: WHEN OTHERS THEN
13494: --ROLLBACK TO APPLY_HOLDS_PUB;
13495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13496: IF OE_MSG_PUB.Check_Msg_Level
13497: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
13498: THEN
13499: OE_MSG_PUB.Add_Exc_Msg
13500: ( G_PKG_NAME
13501: , l_api_name
13495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13496: IF OE_MSG_PUB.Check_Msg_Level
13497: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
13498: THEN
13499: OE_MSG_PUB.Add_Exc_Msg
13500: ( G_PKG_NAME
13501: , l_api_name
13502: );
13503: END IF;
13500: ( G_PKG_NAME
13501: , l_api_name
13502: );
13503: END IF;
13504: OE_MSG_PUB.Count_And_Get
13505: ( p_count => x_msg_count
13506: , p_data => x_msg_data
13507: );
13508: