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_API

Line 447: x_return_status := FND_API.G_RET_STS_SUCCESS;

443: wf_engine.CompleteActivity('OEOL', c_rec.item_key, c_rec.full_activity_name, l_result);
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: );

Line 524: x_return_status := FND_API.G_RET_STS_SUCCESS;

520:
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: );

Line 534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

530: EXCEPTION
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: );

Line 665: x_return_status := FND_API.G_RET_STS_SUCCESS;

661:
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: );

Line 675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

671: EXCEPTION
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: );

Line 962: RAISE FND_API.G_EXC_ERROR;

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
965:
966: l_wf_sqlmt := 'SELECT count(*)

Line 1256: RAISE FND_API.G_EXC_ERROR;

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
1259: l_wf_sqlmt := 'SELECT count(*)
1260: FROM OE_ORDER_HEADERS_ALL h, OE_ORDER_LINES_ALL ol

Line 1589: x_return_status := FND_API.G_RET_STS_SUCCESS;

1585:
1586: l_hold_source_rec OE_HOLDS_PVT.hold_source_rec_type;
1587: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1588: BEGIN
1589: x_return_status := FND_API.G_RET_STS_SUCCESS;
1590: l_user_id := OE_HOLDS_PVT.get_user_id;
1591: -- XX Also check for release reason code
1592: OPEN hold_source;
1593: LOOP

Line 1757: x_return_status := FND_API.G_RET_STS_SUCCESS;

1753:
1754: BEGIN
1755: OE_Debug_PUB.Add('In OE_holds_PUB.Validate_Hold_source',1);
1756: -- Initialize API return status to success
1757: x_return_status := FND_API.G_RET_STS_SUCCESS;
1758:
1759: --XXX Check the Entity Combination
1760: /*
1761: > Item - Customer

Line 1796: RAISE FND_API.G_EXC_ERROR;

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

Line 1805: RAISE FND_API.G_EXC_ERROR;

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*/
1809:

Line 1834: RAISE FND_API.G_EXC_ERROR;

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

Line 1847: RAISE FND_API.G_EXC_ERROR;

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;
1851: --ER#7479609 end

Line 1864: RAISE FND_API.G_EXC_ERROR;

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
1868: if p_hold_source_rec.hold_entity_code2 not in ('C', 'S', 'B','LT','SM','D','ST') then --ER#7479609

Line 1872: RAISE FND_API.G_EXC_ERROR;

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
1876: OE_Debug_PUB.Add('Invalid Entity Combination',1);

Line 1879: RAISE FND_API.G_EXC_ERROR;

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
1883: if p_hold_source_rec.hold_entity_code2 not in ('S', 'B', 'W', 'L','PL','PT','SM','D','LT') then --ER#7479609

Line 1887: RAISE FND_API.G_EXC_ERROR;

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
1891: if p_hold_source_rec.hold_entity_code2 not in ('OI') then

Line 1895: RAISE FND_API.G_EXC_ERROR;

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
1899: OE_Debug_PUB.Add('Invalid Entity Combination',1);

Line 1902: RAISE FND_API.G_EXC_ERROR;

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
1906: OE_Debug_PUB.Add('Invalid Entity Combination',1);

Line 1909: RAISE FND_API.G_EXC_ERROR;

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
1913: OE_Debug_PUB.Add('Invalid Entity Combination',1);

Line 1916: RAISE FND_API.G_EXC_ERROR;

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
1920: OE_Debug_PUB.Add('Invalid Entity Combination',1);

Line 1923: RAISE FND_API.G_EXC_ERROR;

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
1927: OE_Debug_PUB.Add('Invalid Entity Combination',1);

Line 1930: RAISE FND_API.G_EXC_ERROR;

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

Line 2066: RAISE FND_API.G_EXC_ERROR;

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: /*********************************
2070: ** Check the Second Entity **

Line 2217: RAISE FND_API.G_EXC_ERROR;

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

Line 2230: RAISE FND_API.G_EXC_ERROR;

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: /*
2234: ** This message is not required.

Line 2231: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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: /*
2234: ** This message is not required.
2235: FND_MESSAGE.SET_NAME('ONT', 'OE_ENTITY_NOT_ON_ORDER_OR_LINE');

Line 2232: WHEN FND_API.G_EXC_ERROR THEN

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: /*
2234: ** This message is not required.
2235: FND_MESSAGE.SET_NAME('ONT', 'OE_ENTITY_NOT_ON_ORDER_OR_LINE');
2236: OE_MSG_PUB.ADD;

Line 2239: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 2263: x_return_status := FND_API.G_RET_STS_SUCCESS;

2259: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
2260: IS
2261: l_dummy VARCHAR2(30) DEFAULT NULL;
2262: BEGIN
2263: x_return_status := FND_API.G_RET_STS_SUCCESS;
2264:
2265:
2266: -- Check for Missing Values
2267: IF p_hold_id IS NULL THEN

Line 2270: RAISE FND_API.G_EXC_ERROR;

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:
2274: -- Validate Hold ID

Line 2292: x_return_status := FND_API.G_RET_STS_ERROR;

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:
2296: END Validate_Hold;

Line 2316: x_return_status := FND_API.G_RET_STS_SUCCESS;

2312: l_count NUMBER;
2313: --l_hold_source_id OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE;
2314: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
2315: BEGIN
2316: x_return_status := FND_API.G_RET_STS_SUCCESS;
2317: x_hold_exists := 'N';
2318: l_user_id := OE_HOLDS_PVT.get_user_id;
2319: l_org_id := MO_GLOBAL.get_current_org_id;
2320: IF l_org_id IS NULL THEN

Line 2323: x_return_status := FND_API.G_RET_STS_ERROR;

2319: l_org_id := MO_GLOBAL.get_current_org_id;
2320: IF l_org_id IS NULL THEN
2321: -- org_id is null, raise an error.
2322: oe_debug_pub.add('Org_Id is NULL',1);
2323: x_return_status := FND_API.G_RET_STS_ERROR;
2324: FND_MESSAGE.SET_NAME('FND','MO_ORG_REQUIRED');
2325: FND_MSG_PUB.ADD;
2326: RAISE FND_API.G_EXC_ERROR;
2327: END IF;

Line 2326: RAISE FND_API.G_EXC_ERROR;

2322: oe_debug_pub.add('Org_Id is NULL',1);
2323: x_return_status := FND_API.G_RET_STS_ERROR;
2324: FND_MESSAGE.SET_NAME('FND','MO_ORG_REQUIRED');
2325: FND_MSG_PUB.ADD;
2326: RAISE FND_API.G_EXC_ERROR;
2327: END IF;
2328:
2329: if (p_hold_source_rec.hold_entity_code = 'O'
2330: AND p_hold_source_rec.hold_entity_code2 is NULL) then

Line 2360: --RAISE FND_API.G_EXC_ERROR;

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;
2362: /* If Order Level Hold */
2363: ELSE
2364: select count(*)

Line 2391: --RAISE FND_API.G_EXC_ERROR;

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;
2393:
2394: END IF; /*If Order Level Hold */
2395: else

Line 2418: RAISE FND_API.G_EXC_ERROR;

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;
2421:
2422:

Line 2512: WHEN FND_API.G_EXC_ERROR THEN

2508:
2509: --dbms_output.put_line ('Caling Create_Order_Holds');
2510:
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

Line 2514: x_return_status := FND_API.G_RET_STS_ERROR;

2510:
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: );

Line 2519: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 2521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2517: , p_data => x_msg_data
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: );

Line 2528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 2559: x_return_status := FND_API.G_RET_STS_SUCCESS;

2555: --l_hold_source_id OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE;
2556: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
2557: l_hold_comment OE_HOLD_SOURCES_ALL.HOLD_COMMENT%TYPE; --ER#7479609
2558: BEGIN
2559: x_return_status := FND_API.G_RET_STS_SUCCESS;
2560: l_user_id := OE_HOLDS_PVT.get_user_id;
2561: l_org_id := MO_GLOBAL.get_current_org_id;
2562: IF l_org_id IS NULL THEN
2563: -- org_id is null, raise an error.

Line 2565: x_return_status := FND_API.G_RET_STS_ERROR;

2561: l_org_id := MO_GLOBAL.get_current_org_id;
2562: IF l_org_id IS NULL THEN
2563: -- org_id is null, raise an error.
2564: oe_debug_pub.add('Org_Id is NULL',1);
2565: x_return_status := FND_API.G_RET_STS_ERROR;
2566: FND_MESSAGE.SET_NAME('FND','MO_ORG_REQUIRED');
2567: FND_MSG_PUB.ADD;
2568: RAISE FND_API.G_EXC_ERROR;
2569: END IF;

Line 2568: RAISE FND_API.G_EXC_ERROR;

2564: oe_debug_pub.add('Org_Id is NULL',1);
2565: x_return_status := FND_API.G_RET_STS_ERROR;
2566: FND_MESSAGE.SET_NAME('FND','MO_ORG_REQUIRED');
2567: FND_MSG_PUB.ADD;
2568: RAISE FND_API.G_EXC_ERROR;
2569: END IF;
2570:
2571: if (p_hold_source_rec.hold_entity_code = 'O'
2572: AND p_hold_source_rec.hold_entity_code2 is NULL) then

Line 2600: RAISE FND_API.G_EXC_ERROR;

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 */
2603: ELSE
2604: select count(*)

Line 2629: RAISE FND_API.G_EXC_ERROR;

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:
2632: END IF; /*If Order Level Hold */
2633: else

Line 2661: RAISE FND_API.G_EXC_ERROR;

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:
2664: end if;
2665:

Line 2787: WHEN FND_API.G_EXC_ERROR THEN

2783:
2784: --dbms_output.put_line ('Caling Create_Order_Holds');
2785:
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

Line 2789: x_return_status := FND_API.G_RET_STS_ERROR;

2785:
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: );

Line 2794: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 2796: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2792: , p_data => x_msg_data
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: );

Line 2803: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 2889: x_return_status := FND_API.G_RET_STS_SUCCESS;

2885: l_line_rec OE_Order_PUB.Line_Rec_Type;*/
2886: -- GENESIS --
2887: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2888: BEGIN
2889: x_return_status := FND_API.G_RET_STS_SUCCESS;
2890: l_user_id := OE_HOLDS_PVT.get_user_id;
2891: l_org_id := MO_GLOBAL.get_current_org_id;
2892: IF l_org_id IS NULL THEN
2893: -- org_id is null, raise an error.

Line 2895: x_return_status := FND_API.G_RET_STS_ERROR;

2891: l_org_id := MO_GLOBAL.get_current_org_id;
2892: IF l_org_id IS NULL THEN
2893: -- org_id is null, raise an error.
2894: oe_debug_pub.add('Org_Id is NULL',1);
2895: x_return_status := FND_API.G_RET_STS_ERROR;
2896: FND_MESSAGE.SET_NAME('FND','MO_ORG_REQUIRED');
2897: FND_MSG_PUB.ADD;
2898: RAISE FND_API.G_EXC_ERROR;
2899: END IF;

Line 2898: RAISE FND_API.G_EXC_ERROR;

2894: oe_debug_pub.add('Org_Id is NULL',1);
2895: x_return_status := FND_API.G_RET_STS_ERROR;
2896: FND_MESSAGE.SET_NAME('FND','MO_ORG_REQUIRED');
2897: FND_MSG_PUB.ADD;
2898: RAISE FND_API.G_EXC_ERROR;
2899: END IF;
2900:
2901: Begin
2902: select item_type, activity_name

Line 4745: WHEN FND_API.G_EXC_ERROR THEN

4741: END IF; --p_hold_source_rec.hold_entity_code = 'O'
4742: END IF;*/
4743: -- GENESIS --
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

Line 4747: x_return_status := FND_API.G_RET_STS_ERROR;

4743: -- GENESIS --
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: );

Line 4752: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 4754: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4750: , p_data => x_msg_data
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: );

Line 4761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 4803: x_return_status := FND_API.G_RET_STS_SUCCESS;

4799: l_user_id NUMBER;
4800: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4801:
4802: BEGIN
4803: x_return_status := FND_API.G_RET_STS_SUCCESS;
4804: l_user_id := OE_HOLDS_PVT.get_user_id;
4805: -- Flag all orders and order line holds for this hold source
4806: -- as released
4807: UPDATE oe_order_holds

Line 4861: x_return_status := FND_API.G_RET_STS_SUCCESS;

4857: BEGIN
4858:
4859: -- Fix For Bug 1903900
4860: SAVEPOINT insert_hold_release;
4861: x_return_status := FND_API.G_RET_STS_SUCCESS;
4862:
4863: l_user_id := OE_HOLDS_PVT.get_user_id;
4864:
4865: -- Validate Reason Code

Line 4883: RAISE FND_API.G_EXC_ERROR;

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:
4887: SELECT OE_HOLD_RELEASES_S.NEXTVAL

Line 4971: WHEN FND_API.G_EXC_ERROR THEN

4967: -- l_hold_release_rec := p_hold_release_rec;
4968: -- l_hold_release_rec.hold_release_id := x_hold_release_id;
4969:
4970: EXCEPTION
4971: WHEN FND_API.G_EXC_ERROR THEN
4972: x_return_status := FND_API.G_RET_STS_ERROR;
4973: ROLLBACK TO insert_hold_release;
4974: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4975: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4972: x_return_status := FND_API.G_RET_STS_ERROR;

4968: -- l_hold_release_rec.hold_release_id := x_hold_release_id;
4969:
4970: EXCEPTION
4971: WHEN FND_API.G_EXC_ERROR THEN
4972: x_return_status := FND_API.G_RET_STS_ERROR;
4973: ROLLBACK TO insert_hold_release;
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;

Line 4974: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4970: EXCEPTION
4971: WHEN FND_API.G_EXC_ERROR THEN
4972: x_return_status := FND_API.G_RET_STS_ERROR;
4973: ROLLBACK TO insert_hold_release;
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

Line 4975: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4971: WHEN FND_API.G_EXC_ERROR THEN
4972: x_return_status := FND_API.G_RET_STS_ERROR;
4973: ROLLBACK TO insert_hold_release;
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

Line 4983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
4984: ROLLBACK TO insert_hold_release;
4985:
4986: END Create_Release_Source;
4987:

Line 5034: x_return_status := FND_API.G_RET_STS_SUCCESS;

5030: nvl(p_hold_source_rec.header_id, oh.header_id)
5031: and nvl(oh.line_id, -99) =
5032: nvl(p_hold_source_rec.line_id, -99));
5033: BEGIN
5034: x_return_status := FND_API.G_RET_STS_SUCCESS;
5035: l_hold_release_rec := p_hold_release_rec;
5036:
5037: -- Retrieving hold source ID if not passed
5038: IF p_hold_source_rec.hold_source_id IS NULL THEN

Line 5058: RAISE FND_API.G_EXC_ERROR;

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;
5062: END IF; -- order_hold_source%NOTFOUND

Line 5077: RAISE FND_API.G_EXC_ERROR;

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'
5081: ELSE

Line 5093: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5089: x_return_status => x_return_status,
5090: x_msg_count => x_msg_count,
5091: x_msg_data => x_msg_data);
5092:
5093: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5094: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5095: RAISE FND_API.G_EXC_ERROR;
5096: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
5097: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5094: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

5090: x_msg_count => x_msg_count,
5091: x_msg_data => x_msg_data);
5092:
5093: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5094: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5095: RAISE FND_API.G_EXC_ERROR;
5096: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
5097: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5098: END IF;

Line 5095: RAISE FND_API.G_EXC_ERROR;

5091: x_msg_data => x_msg_data);
5092:
5093: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5094: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5095: RAISE FND_API.G_EXC_ERROR;
5096: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
5097: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5098: END IF;
5099: END IF;

Line 5096: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

5092:
5093: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5094: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5095: RAISE FND_API.G_EXC_ERROR;
5096: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
5097: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5098: END IF;
5099: END IF;
5100: oe_debug_pub.add('Calling Release_Order_holds using l_hold_release_id' ||

Line 5097: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5093: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5094: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5095: RAISE FND_API.G_EXC_ERROR;
5096: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
5097: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5098: END IF;
5099: END IF;
5100: oe_debug_pub.add('Calling Release_Order_holds using l_hold_release_id' ||
5101: to_char(l_hold_release_id) ,1);

Line 5111: WHEN FND_API.G_EXC_ERROR THEN

5107: x_msg_count => x_msg_count,
5108: x_msg_data => x_msg_data);
5109:
5110: EXCEPTION
5111: WHEN FND_API.G_EXC_ERROR THEN
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

Line 5112: x_return_status := FND_API.G_RET_STS_ERROR;

5108: x_msg_data => x_msg_data);
5109:
5110: EXCEPTION
5111: WHEN FND_API.G_EXC_ERROR THEN
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

Line 5113: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5109:
5110: EXCEPTION
5111: WHEN FND_API.G_EXC_ERROR THEN
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

Line 5114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5110: EXCEPTION
5111: WHEN FND_API.G_EXC_ERROR THEN
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');

Line 5120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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:
5122: END Release_Hold_Source;
5123:
5124:

Line 5137: x_return_status := FND_API.G_RET_STS_SUCCESS;

5133: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Order';
5134: l_dummy VARCHAR2(30);
5135: l_header_id OE_ORDER_HEADERS.header_id%type;
5136: BEGIN
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;

Line 5142: RAISE FND_API.G_EXC_ERROR;

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
5146: INTO l_header_id

Line 5159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5155: END IF;
5156: EXCEPTION
5157: WHEN NO_DATA_FOUND THEN
5158: -- Modified below code for bug 7112725
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;

Line 5170: -- RAISE FND_API.G_EXC_ERROR; -- Commented for bug 7112725

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;
5172:
5173:
5174: Procedure Validate (

Line 5189: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

5185: );
5186: /*
5187: ** Call Validate_Hold() only if Validate_Hold_Source() was successful
5188: */
5189: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
5190:
5191: Validate_Hold ( p_hold_id => p_hold_source_rec.hold_id,
5192: x_return_status => x_return_status,
5193: x_msg_count => x_msg_count,

Line 5244: x_return_status := FND_API.G_RET_STS_SUCCESS;

5240:
5241: SAVEPOINT DELETE_HOLDS_PUB;
5242:
5243: -- Initialize API return status to success
5244: x_return_status := FND_API.G_RET_STS_SUCCESS;
5245:
5246: -- Missing Input arguments
5247:
5248: IF (p_order_rec.header_id = FND_API.G_MISS_NUM

Line 5248: IF (p_order_rec.header_id = FND_API.G_MISS_NUM

5244: x_return_status := FND_API.G_RET_STS_SUCCESS;
5245:
5246: -- Missing Input arguments
5247:
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;

Line 5249: AND p_order_rec.line_id = FND_API.G_MISS_NUM) THEN

5245:
5246: -- Missing Input arguments
5247:
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;

Line 5253: RAISE FND_API.G_EXC_ERROR;

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:
5257: -- Delete the hold records corr. to this order or line in OE_ORDER_HOLDS

Line 5259: IF p_order_rec.line_id = FND_API.G_MISS_NUM THEN

5255: END IF;
5256:
5257: -- Delete the hold records corr. to this order or line in OE_ORDER_HOLDS
5258:
5259: IF p_order_rec.line_id = FND_API.G_MISS_NUM THEN
5260:
5261: -- Delete order hold records
5262:
5263: OPEN order_hold;

Line 5353: WHEN FND_API.G_EXC_ERROR THEN

5349: END IF;
5350:
5351:
5352: EXCEPTION
5353: WHEN FND_API.G_EXC_ERROR THEN
5354: IF (order_hold%isopen) THEN
5355: CLOSE order_hold;
5356: END IF;
5357: IF (hold_source%isopen) THEN

Line 5364: x_return_status := FND_API.G_RET_STS_ERROR;

5360: IF (line_hold%isopen) THEN
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: );

Line 5380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5376: IF (line_hold%isopen) 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

Line 5419: x_return_status := FND_API.G_RET_STS_SUCCESS;

5415: l_count_of_holds_applied NUMBER := 0;
5416: l_user_activity_name VARCHAR2(80);
5417:
5418: BEGIN
5419: x_return_status := FND_API.G_RET_STS_SUCCESS;
5420: OE_DEBUG_PUB.Add('IN Apply Holds..Orders',1);
5421:
5422: for j in 1..p_order_tbl.COUNT loop
5423: OE_DEBUG_PUB.Add('IN Apply Holds Loop',3);

Line 5425: x_return_status := FND_API.G_RET_STS_SUCCESS;

5421:
5422: for j in 1..p_order_tbl.COUNT loop
5423: OE_DEBUG_PUB.Add('IN Apply Holds Loop',3);
5424: l_hold_exists := 'N'; --bug 5548778
5425: x_return_status := FND_API.G_RET_STS_SUCCESS;
5426: l_hold_source_rec.hold_entity_code := 'O';
5427: l_hold_source_rec.hold_entity_id := p_order_tbl(j).header_id;
5428: l_hold_source_rec.line_id := p_order_tbl(j).line_id;
5429:

Line 5457: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5453: OE_DEBUG_PUB.Add('x_msg_count:' || to_char(x_msg_count),2 );
5454: OE_DEBUG_PUB.Add('x_msg_data:' || x_msg_data,2 );
5455:
5456: -- Added for bug 7112725
5457: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5458: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5459: RAISE FND_API.G_EXC_ERROR;
5460: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5458: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

5454: OE_DEBUG_PUB.Add('x_msg_data:' || x_msg_data,2 );
5455:
5456: -- Added for bug 7112725
5457: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5458: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5459: RAISE FND_API.G_EXC_ERROR;
5460: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5462: END IF;

Line 5459: RAISE FND_API.G_EXC_ERROR;

5455:
5456: -- Added for bug 7112725
5457: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5458: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5459: RAISE FND_API.G_EXC_ERROR;
5460: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5462: END IF;
5463: END IF;

Line 5460: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5456: -- Added for bug 7112725
5457: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5458: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5459: RAISE FND_API.G_EXC_ERROR;
5460: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5462: END IF;
5463: END IF;
5464:

Line 5461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5457: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5458: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5459: RAISE FND_API.G_EXC_ERROR;
5460: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5462: END IF;
5463: END IF;
5464:
5465: /* Don't need this, cos just putting orders on hold

Line 5473: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5469: x_return_status => x_return_status,
5470: x_msg_count => x_msg_count,
5471: x_msg_data => x_msg_data
5472: );
5473: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5474: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5475: RAISE FND_API.G_EXC_ERROR;
5476: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
5477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5474: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

5470: x_msg_count => x_msg_count,
5471: x_msg_data => x_msg_data
5472: );
5473: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5474: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5475: RAISE FND_API.G_EXC_ERROR;
5476: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
5477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5478: END IF;

Line 5475: RAISE FND_API.G_EXC_ERROR;

5471: x_msg_data => x_msg_data
5472: );
5473: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5474: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5475: RAISE FND_API.G_EXC_ERROR;
5476: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
5477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5478: END IF;
5479: END IF;

Line 5476: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

5472: );
5473: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5474: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5475: RAISE FND_API.G_EXC_ERROR;
5476: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
5477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5478: END IF;
5479: END IF;
5480: --bug 5548778 call overloaded method

Line 5477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5473: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5474: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5475: RAISE FND_API.G_EXC_ERROR;
5476: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
5477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5478: END IF;
5479: END IF;
5480: --bug 5548778 call overloaded method
5481: Create_Hold_Source (

Line 5494: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5490: x_return_status,1);
5491: OE_DEBUG_PUB.Add('x_msg_count:' || to_char(x_msg_count),3 );
5492: OE_DEBUG_PUB.Add('x_msg_data:' || x_msg_data ,3);
5493: OE_DEBUG_PUB.Add('l_hold_exists:' || l_hold_exists ,3);
5494: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5495: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5496: RAISE FND_API.G_EXC_ERROR;
5497: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
5498: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5495: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

5491: OE_DEBUG_PUB.Add('x_msg_count:' || to_char(x_msg_count),3 );
5492: OE_DEBUG_PUB.Add('x_msg_data:' || x_msg_data ,3);
5493: OE_DEBUG_PUB.Add('l_hold_exists:' || l_hold_exists ,3);
5494: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5495: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5496: RAISE FND_API.G_EXC_ERROR;
5497: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
5498: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5499: END IF;

Line 5496: RAISE FND_API.G_EXC_ERROR;

5492: OE_DEBUG_PUB.Add('x_msg_data:' || x_msg_data ,3);
5493: OE_DEBUG_PUB.Add('l_hold_exists:' || l_hold_exists ,3);
5494: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5495: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5496: RAISE FND_API.G_EXC_ERROR;
5497: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
5498: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5499: END IF;
5500: END IF;

Line 5497: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

5493: OE_DEBUG_PUB.Add('l_hold_exists:' || l_hold_exists ,3);
5494: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5495: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5496: RAISE FND_API.G_EXC_ERROR;
5497: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
5498: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5499: END IF;
5500: END IF;
5501:

Line 5498: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5494: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5495: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5496: RAISE FND_API.G_EXC_ERROR;
5497: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
5498: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5499: END IF;
5500: END IF;
5501:
5502: OE_DEBUG_PUB.Add('l_hold_source_id->' || to_char(l_hold_source_id) ,1);

Line 5567: RAISE FND_API.G_EXC_ERROR;

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
5570: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
5571: fnd_message.set_token('WF_ACT',l_user_activity_name);

Line 5574: RAISE FND_API.G_EXC_ERROR;

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
5577: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
5578: fnd_message.set_token('WF_ACT',l_user_activity_name);

Line 5640: x_return_status := FND_API.G_RET_STS_SUCCESS;

5636: x_is_hold_applied => l_hold_msg_applied);
5637: /*BEGIN
5638: OE_DEBUG_PUB.Add('In OE_Holds_pvt.Apply Holds, Creating Hold Source',1);
5639:
5640: x_return_status := FND_API.G_RET_STS_SUCCESS;
5641: l_hold_source_rec := p_hold_source_rec;
5642: Validate (p_hold_source_rec => p_hold_source_rec,
5643: x_return_status => x_return_status,
5644: x_msg_count => x_msg_count,

Line 5647: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5643: x_return_status => x_return_status,
5644: x_msg_count => x_msg_count,
5645: x_msg_data => x_msg_data );
5646: OE_DEBUG_PUB.Add('Validate return status:' || x_return_status,1);
5647: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5648: OE_Debug_PUB.Add('Validate not successful',1);
5649: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5650: RAISE FND_API.G_EXC_ERROR;
5651: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 5649: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

5645: x_msg_data => x_msg_data );
5646: OE_DEBUG_PUB.Add('Validate return status:' || x_return_status,1);
5647: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5648: OE_Debug_PUB.Add('Validate not successful',1);
5649: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5650: RAISE FND_API.G_EXC_ERROR;
5651: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5653: END IF;

Line 5650: RAISE FND_API.G_EXC_ERROR;

5646: OE_DEBUG_PUB.Add('Validate return status:' || x_return_status,1);
5647: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5648: OE_Debug_PUB.Add('Validate not successful',1);
5649: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5650: RAISE FND_API.G_EXC_ERROR;
5651: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5653: END IF;
5654: ELSE

Line 5651: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5647: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5648: OE_Debug_PUB.Add('Validate not successful',1);
5649: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5650: RAISE FND_API.G_EXC_ERROR;
5651: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5653: END IF;
5654: ELSE
5655: OE_DEBUG_PUB.Add ('Calling Create_Hold_Source bug 5548778 overload',1);

Line 5652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5648: OE_Debug_PUB.Add('Validate not successful',1);
5649: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5650: RAISE FND_API.G_EXC_ERROR;
5651: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5653: END IF;
5654: ELSE
5655: OE_DEBUG_PUB.Add ('Calling Create_Hold_Source bug 5548778 overload',1);
5656: Create_Hold_Source (

Line 5668: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5664: OE_DEBUG_PUB.Add('x_return_status->' || x_return_status,1);
5665: OE_DEBUG_PUB.Add('x_msg_count->' || x_msg_count,1);
5666: OE_DEBUG_PUB.Add('x_msg_data' || x_msg_data,1);
5667: OE_DEBUG_PUB.Add('l_hold_exists' || l_hold_exists,1);
5668: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5669: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5670: RAISE FND_API.G_EXC_ERROR;
5671: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
5672: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5669: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

5665: OE_DEBUG_PUB.Add('x_msg_count->' || x_msg_count,1);
5666: OE_DEBUG_PUB.Add('x_msg_data' || x_msg_data,1);
5667: OE_DEBUG_PUB.Add('l_hold_exists' || l_hold_exists,1);
5668: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5669: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5670: RAISE FND_API.G_EXC_ERROR;
5671: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
5672: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5673: END IF;

Line 5670: RAISE FND_API.G_EXC_ERROR;

5666: OE_DEBUG_PUB.Add('x_msg_data' || x_msg_data,1);
5667: OE_DEBUG_PUB.Add('l_hold_exists' || l_hold_exists,1);
5668: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5669: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5670: RAISE FND_API.G_EXC_ERROR;
5671: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
5672: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5673: END IF;
5674: END IF;

Line 5671: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

5667: OE_DEBUG_PUB.Add('l_hold_exists' || l_hold_exists,1);
5668: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5669: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5670: RAISE FND_API.G_EXC_ERROR;
5671: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
5672: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5673: END IF;
5674: END IF;
5675: OE_DEBUG_PUB.Add('l_hold_source_id->' || to_char(l_hold_source_id) ,1);

Line 5672: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5668: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5669: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5670: RAISE FND_API.G_EXC_ERROR;
5671: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
5672: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5673: END IF;
5674: END IF;
5675: OE_DEBUG_PUB.Add('l_hold_source_id->' || to_char(l_hold_source_id) ,1);
5676: l_hold_source_rec.hold_source_id := l_hold_source_id;

Line 5705: x_return_status := FND_API.G_RET_STS_SUCCESS;

5701: --bug 5051532
5702: l_hold_source_rec OE_HOLDS_PVT.hold_source_rec_type;
5703:
5704: BEGIN
5705: x_return_status := FND_API.G_RET_STS_SUCCESS;
5706: --bug 5051532
5707: l_hold_source_rec := p_hold_source_rec;
5708: -- replaced the occurences of p_hold_source_rec with l_hold_source_rec in theIF part of the IF-ELSE block below, for bug 5051532
5709:

Line 5738: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5734: );
5735: oe_debug_pub.add('After Validate_Order with x_return_status'||x_return_status,2);
5736:
5737: -- Added for bug 7112725
5738: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5739: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5740: RAISE FND_API.G_EXC_ERROR;
5741: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5742: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5739: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

5735: oe_debug_pub.add('After Validate_Order with x_return_status'||x_return_status,2);
5736:
5737: -- Added for bug 7112725
5738: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5739: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5740: RAISE FND_API.G_EXC_ERROR;
5741: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5742: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5743: END IF;

Line 5740: RAISE FND_API.G_EXC_ERROR;

5736:
5737: -- Added for bug 7112725
5738: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5739: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5740: RAISE FND_API.G_EXC_ERROR;
5741: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5742: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5743: END IF;
5744: END IF;

Line 5741: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5737: -- Added for bug 7112725
5738: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5739: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5740: RAISE FND_API.G_EXC_ERROR;
5741: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5742: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5743: END IF;
5744: END IF;
5745:

Line 5742: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5738: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5739: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5740: RAISE FND_API.G_EXC_ERROR;
5741: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5742: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5743: END IF;
5744: END IF;
5745:
5746: Release_orders ( p_hold_release_rec => p_hold_release_rec,

Line 5792: x_return_status := FND_API.G_RET_STS_SUCCESS;

5788: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
5789: l_order_rec OE_HOLDS_PVT.order_rec_type;
5790: l_hold_release_rec OE_HOLDS_PVT.hold_release_rec_type;
5791: BEGIN
5792: x_return_status := FND_API.G_RET_STS_SUCCESS;
5793: oe_debug_pub.add('In Release Holds..Orders',1);
5794: for j in 1..p_order_tbl.COUNT loop
5795: -- IF p_order_tbl(j).header_id IS NULL AND
5796: -- p_order_tbl(j).line_id NULL THEN ERROR

Line 5825: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5821: );
5822: oe_debug_pub.add('After Validate_Order with x_return_status'|| x_return_status);
5823:
5824: -- Added for bug 7112725
5825: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5826: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5827: RAISE FND_API.G_EXC_ERROR;
5828: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5829: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5826: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

5822: oe_debug_pub.add('After Validate_Order with x_return_status'|| x_return_status);
5823:
5824: -- Added for bug 7112725
5825: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5826: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5827: RAISE FND_API.G_EXC_ERROR;
5828: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5829: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5830: END IF;

Line 5827: RAISE FND_API.G_EXC_ERROR;

5823:
5824: -- Added for bug 7112725
5825: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5826: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5827: RAISE FND_API.G_EXC_ERROR;
5828: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5829: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5830: END IF;
5831: END IF;

Line 5828: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5824: -- Added for bug 7112725
5825: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5826: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5827: RAISE FND_API.G_EXC_ERROR;
5828: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5829: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5830: END IF;
5831: END IF;
5832:

Line 5829: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5825: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5826: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5827: RAISE FND_API.G_EXC_ERROR;
5828: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5829: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5830: END IF;
5831: END IF;
5832:
5833: oe_debug_pub.add('l_order_rec.header_id'||l_order_rec.header_id);

Line 5885: l_return_status Varchar2(1) := FND_API.G_RET_STS_SUCCESS;

5881: )
5882: RETURN varchar2
5883: IS
5884: l_authorized_or_not varchar2(1) := 'Y';
5885: l_return_status Varchar2(1) := FND_API.G_RET_STS_SUCCESS;
5886: BEGIN
5887:
5888: x_return_status := l_return_status;
5889: x_msg_count := 0;

Line 5979: x_return_status := FND_API.G_RET_STS_ERROR;

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
5983: );

Line 6005: --RAISE FND_API.G_EXC_ERROR;

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

Line 6006: x_return_status := FND_API.G_RET_STS_ERROR;

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
6009: , p_data => x_msg_data
6010: );

Line 6092: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

6088: ,x_return_status => x_return_status
6089: ,x_msg_count => x_msg_count
6090: ,x_msg_data => x_msg_data);*/
6091:
6092: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6093: oe_debug_pub.add('process_apply_holds_lines unexpected failure',1);
6094: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6095: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
6096: oe_debug_pub.add('process_apply_holds_lines expected failure',1);

Line 6094: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6090: ,x_msg_data => x_msg_data);*/
6091:
6092: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6093: oe_debug_pub.add('process_apply_holds_lines unexpected failure',1);
6094: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6095: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
6096: oe_debug_pub.add('process_apply_holds_lines expected failure',1);
6097: RAISE FND_API.G_EXC_ERROR;
6098: END IF;

Line 6095: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

6091:
6092: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6093: oe_debug_pub.add('process_apply_holds_lines unexpected failure',1);
6094: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6095: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
6096: oe_debug_pub.add('process_apply_holds_lines expected failure',1);
6097: RAISE FND_API.G_EXC_ERROR;
6098: END IF;
6099:

Line 6097: RAISE FND_API.G_EXC_ERROR;

6093: oe_debug_pub.add('process_apply_holds_lines unexpected failure',1);
6094: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6095: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
6096: oe_debug_pub.add('process_apply_holds_lines expected failure',1);
6097: RAISE FND_API.G_EXC_ERROR;
6098: END IF;
6099:
6100: END LOOP;
6101: /*Added the Select query and IF Condition below for WF_HOLDS ER (bug 6449458)*/

Line 6117: RAISE FND_API.G_EXC_ERROR;

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
6120: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
6121: fnd_message.set_token('WF_ACT',l_user_activity_name);

Line 6124: RAISE FND_API.G_EXC_ERROR;

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
6127: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
6128: fnd_message.set_token('WF_ACT',l_user_activity_name);

Line 6136: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 6147: WHEN FND_API.G_EXC_ERROR THEN

6143: OE_DEBUG_PUB.Add('Exiting OE_Holds_PVT.process_apply_holds_lines',1);
6144:
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

Line 6148: x_return_status := FND_API.G_RET_STS_ERROR ;

6144:
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: );

Line 6155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6151: p_data => x_msg_data
6152: );
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

Line 6156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

6152: );
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: );

Line 6164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

6160: );
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

Line 6227: x_return_status := FND_API.G_RET_STS_ERROR;

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
6231: );

Line 6254: -- RAISE FND_API.G_EXC_ERROR;

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

Line 6255: x_return_status := FND_API.G_RET_STS_ERROR;

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
6258: , p_data => x_msg_data
6259: );

Line 6325: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

6321: OE_DEBUG_PUB.Add('x_return_status:' || x_return_status,2);
6322: OE_DEBUG_PUB.Add('x_msg_count:' || to_char(x_msg_count),2);
6323: OE_DEBUG_PUB.Add('x_msg_data:' || x_msg_data,2);
6324:
6325: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6326: Oe_debug_pub.add('process_apply_holds_orders unexpected failure',3);
6327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6328: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
6329: oe_debug_pub.add('process_apply_holds_orders expected failure',3);

Line 6327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6323: OE_DEBUG_PUB.Add('x_msg_data:' || x_msg_data,2);
6324:
6325: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6326: Oe_debug_pub.add('process_apply_holds_orders unexpected failure',3);
6327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6328: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
6329: oe_debug_pub.add('process_apply_holds_orders expected failure',3);
6330: RAISE FND_API.G_EXC_ERROR;
6331: END IF;

Line 6328: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

6324:
6325: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6326: Oe_debug_pub.add('process_apply_holds_orders unexpected failure',3);
6327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6328: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
6329: oe_debug_pub.add('process_apply_holds_orders expected failure',3);
6330: RAISE FND_API.G_EXC_ERROR;
6331: END IF;
6332:

Line 6330: RAISE FND_API.G_EXC_ERROR;

6326: Oe_debug_pub.add('process_apply_holds_orders unexpected failure',3);
6327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6328: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
6329: oe_debug_pub.add('process_apply_holds_orders expected failure',3);
6330: RAISE FND_API.G_EXC_ERROR;
6331: END IF;
6332:
6333: END LOOP;
6334: /*Added the Select query and IF Condition below for WF_HOLDS ER (bug 6449458)*/

Line 6350: RAISE FND_API.G_EXC_ERROR;

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
6353: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
6354: fnd_message.set_token('WF_ACT',l_user_activity_name);

Line 6357: RAISE FND_API.G_EXC_ERROR;

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
6360: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
6361: fnd_message.set_token('WF_ACT',l_user_activity_name);

Line 6369: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 6380: WHEN FND_API.G_EXC_ERROR THEN

6376: OE_DEBUG_PUB.Add('Exiting OE_Holds_PVT.process_apply_holds_orders',1);
6377:
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

Line 6381: x_return_status := FND_API.G_RET_STS_ERROR ;

6377:
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: );

Line 6388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6384: p_data => x_msg_data
6385: );
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

Line 6389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

6385: );
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: );

Line 6397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

6393: );
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

Line 6464: x_return_status := FND_API.G_RET_STS_ERROR;

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
6468: );

Line 6490: -- RAISE FND_API.G_EXC_ERROR;

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

Line 6491: x_return_status := FND_API.G_RET_STS_ERROR;

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
6494: , p_data => x_msg_data
6495: );

Line 6540: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

6536:
6537: OE_DEBUG_PUB.Add('After oe_holds_pvt.release_holds:' || x_return_status,3);
6538:
6539:
6540: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6541: oe_debug_pub.add('process_release_holds_lines unexpected failure',3);
6542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6543: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
6544: oe_debug_pub.add('process_release_holds_lines failure',3);

Line 6542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6538:
6539:
6540: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6541: oe_debug_pub.add('process_release_holds_lines unexpected failure',3);
6542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6543: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
6544: oe_debug_pub.add('process_release_holds_lines failure',3);
6545: RAISE FND_API.G_EXC_ERROR;
6546: END IF;

Line 6543: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

6539:
6540: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6541: oe_debug_pub.add('process_release_holds_lines unexpected failure',3);
6542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6543: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
6544: oe_debug_pub.add('process_release_holds_lines failure',3);
6545: RAISE FND_API.G_EXC_ERROR;
6546: END IF;
6547:

Line 6545: RAISE FND_API.G_EXC_ERROR;

6541: oe_debug_pub.add('process_release_holds_lines unexpected failure',3);
6542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6543: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
6544: oe_debug_pub.add('process_release_holds_lines failure',3);
6545: RAISE FND_API.G_EXC_ERROR;
6546: END IF;
6547:
6548: END LOOP;
6549:

Line 6550: x_return_status := FND_API.G_RET_STS_SUCCESS;

6546: END IF;
6547:
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

Line 6561: WHEN FND_API.G_EXC_ERROR THEN

6557: OE_DEBUG_PUB.Add('Exiting OE_Holds_PVT.process_release_holds_lines',1);
6558:
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

Line 6562: x_return_status := FND_API.G_RET_STS_ERROR ;

6558:
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: );

Line 6569: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6565: p_data => x_msg_data
6566: );
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

Line 6570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

6566: );
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: );

Line 6578: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

6574: );
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

Line 6639: x_return_status := FND_API.G_RET_STS_ERROR;

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
6643: );

Line 6665: -- RAISE FND_API.G_EXC_ERROR;

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
6669: ( p_count => x_msg_count

Line 6666: x_return_status := FND_API.G_RET_STS_ERROR;

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
6669: ( p_count => x_msg_count
6670: , p_data => x_msg_data

Line 6708: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

6704: OE_DEBUG_PUB.Add('x_return_status:' || x_return_status,2);
6705: OE_DEBUG_PUB.Add('x_msg_count:' || to_char(x_msg_count),2);
6706: OE_DEBUG_PUB.Add('x_msg_data:' || x_msg_data,2);
6707:
6708: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6709: oe_debug_pub.add('process_release_holds_orders unexpected failure',3);
6710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6711: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
6712: oe_debug_pub.add('process_release_holds_orders failure',3);

Line 6710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6706: OE_DEBUG_PUB.Add('x_msg_data:' || x_msg_data,2);
6707:
6708: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6709: oe_debug_pub.add('process_release_holds_orders unexpected failure',3);
6710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6711: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
6712: oe_debug_pub.add('process_release_holds_orders failure',3);
6713: RAISE FND_API.G_EXC_ERROR;
6714: END IF;

Line 6711: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

6707:
6708: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6709: oe_debug_pub.add('process_release_holds_orders unexpected failure',3);
6710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6711: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
6712: oe_debug_pub.add('process_release_holds_orders failure',3);
6713: RAISE FND_API.G_EXC_ERROR;
6714: END IF;
6715:

Line 6713: RAISE FND_API.G_EXC_ERROR;

6709: oe_debug_pub.add('process_release_holds_orders unexpected failure',3);
6710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6711: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
6712: oe_debug_pub.add('process_release_holds_orders failure',3);
6713: RAISE FND_API.G_EXC_ERROR;
6714: END IF;
6715:
6716:
6717: END LOOP;

Line 6719: x_return_status := FND_API.G_RET_STS_SUCCESS;

6715:
6716:
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

Line 6730: WHEN FND_API.G_EXC_ERROR THEN

6726: OE_DEBUG_PUB.Add('Exiting OE_Holds_PVT.process_release_holds_orders',1);
6727:
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

Line 6731: x_return_status := FND_API.G_RET_STS_ERROR ;

6727:
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: );

Line 6738: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6734: p_data => x_msg_data
6735: );
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

Line 6739: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

6735: );
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: );

Line 6747: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

6743: );
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

Line 6808: x_return_status := FND_API.G_RET_STS_ERROR;

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
6812: );

Line 6834: RAISE FND_API.G_EXC_ERROR;

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

Line 6835: x_return_status := FND_API.G_RET_STS_ERROR;

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
6838: , p_data => x_msg_data
6839: );

Line 6875: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

6871: ,x_is_hold_applied => l_is_hold_applied
6872: );
6873:
6874: OE_DEBUG_PUB.Add('x_return_status:' || x_return_status,2);
6875: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6876: oe_debug_pub.add('process_create_holds unexpected failure',1);
6877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6878: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
6879: oe_debug_pub.add('process_create_holds expected failure',1);

Line 6877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6873:
6874: OE_DEBUG_PUB.Add('x_return_status:' || x_return_status,2);
6875: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6876: oe_debug_pub.add('process_create_holds unexpected failure',1);
6877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6878: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
6879: oe_debug_pub.add('process_create_holds expected failure',1);
6880: RAISE FND_API.G_EXC_ERROR;
6881: END IF;

Line 6878: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

6874: OE_DEBUG_PUB.Add('x_return_status:' || x_return_status,2);
6875: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6876: oe_debug_pub.add('process_create_holds unexpected failure',1);
6877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6878: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
6879: oe_debug_pub.add('process_create_holds expected failure',1);
6880: RAISE FND_API.G_EXC_ERROR;
6881: END IF;
6882: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6880: RAISE FND_API.G_EXC_ERROR;

6876: oe_debug_pub.add('process_create_holds unexpected failure',1);
6877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6878: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
6879: oe_debug_pub.add('process_create_holds expected failure',1);
6880: RAISE FND_API.G_EXC_ERROR;
6881: END IF;
6882: x_return_status := FND_API.G_RET_STS_SUCCESS;
6883: elsif (p_hold_existing_flg = 'Y' AND p_hold_future_flg = 'N') then
6884: -- Create_Hold_Source (Create the Hold Source)

Line 6882: x_return_status := FND_API.G_RET_STS_SUCCESS;

6878: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
6879: oe_debug_pub.add('process_create_holds expected failure',1);
6880: RAISE FND_API.G_EXC_ERROR;
6881: END IF;
6882: x_return_status := FND_API.G_RET_STS_SUCCESS;
6883: elsif (p_hold_existing_flg = 'Y' AND p_hold_future_flg = 'N') then
6884: -- Create_Hold_Source (Create the Hold Source)
6885: -- Create_Order_Holds (Put the existing Orders on Hold)
6886: -- Create_Release_Source (Release the source.Do not release orders from hold)

Line 6897: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6893: x_msg_count => x_msg_count,
6894: x_msg_data => x_msg_data
6895: );
6896:
6897: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6898: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
6899: RAISE FND_API.G_EXC_ERROR;
6900: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
6901: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6898: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

6894: x_msg_data => x_msg_data
6895: );
6896:
6897: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6898: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
6899: RAISE FND_API.G_EXC_ERROR;
6900: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
6901: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6902: END IF;

Line 6899: RAISE FND_API.G_EXC_ERROR;

6895: );
6896:
6897: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6898: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
6899: RAISE FND_API.G_EXC_ERROR;
6900: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
6901: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6902: END IF;
6903: END IF;

Line 6900: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

6896:
6897: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6898: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
6899: RAISE FND_API.G_EXC_ERROR;
6900: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
6901: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6902: END IF;
6903: END IF;
6904: OE_DEBUG_PUB.Add('l_hold_source_id->' || to_char(l_hold_source_id) ,3);

Line 6901: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6897: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6898: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
6899: RAISE FND_API.G_EXC_ERROR;
6900: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
6901: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6902: END IF;
6903: END IF;
6904: OE_DEBUG_PUB.Add('l_hold_source_id->' || to_char(l_hold_source_id) ,3);
6905: l_hold_source_rec.hold_source_id := l_hold_source_id;

Line 6938: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6934: x_return_status => x_return_status,
6935: x_msg_count => x_msg_count,
6936: x_msg_data => x_msg_data
6937: );
6938: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6939: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
6940: RAISE FND_API.G_EXC_ERROR;
6941: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
6942: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6939: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

6935: x_msg_count => x_msg_count,
6936: x_msg_data => x_msg_data
6937: );
6938: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6939: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
6940: RAISE FND_API.G_EXC_ERROR;
6941: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
6942: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6943: END IF;

Line 6940: RAISE FND_API.G_EXC_ERROR;

6936: x_msg_data => x_msg_data
6937: );
6938: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6939: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
6940: RAISE FND_API.G_EXC_ERROR;
6941: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
6942: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6943: END IF;
6944: END IF;

Line 6941: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

6937: );
6938: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6939: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
6940: RAISE FND_API.G_EXC_ERROR;
6941: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
6942: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6943: END IF;
6944: END IF;
6945: else

Line 6942: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6938: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6939: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
6940: RAISE FND_API.G_EXC_ERROR;
6941: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
6942: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6943: END IF;
6944: END IF;
6945: else
6946: -- Should not get here

Line 6960: WHEN FND_API.G_EXC_ERROR THEN

6956:
6957:
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

Line 6961: x_return_status := FND_API.G_RET_STS_ERROR ;

6957:
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: );

Line 6967: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6963: ( p_count => x_msg_count,
6964: p_data => x_msg_data
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

Line 6968: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

6964: p_data => x_msg_data
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: );

Line 6975: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

6971: p_data => x_msg_data
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

Line 7035: RAISE FND_API.G_EXC_ERROR;

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

Line 7036: x_return_status := FND_API.G_RET_STS_ERROR;

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
7039: , p_data => x_msg_data
7040: );

Line 7056: x_return_status := FND_API.G_RET_STS_ERROR;

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
7060: );

Line 7081: RAISE FND_API.G_EXC_ERROR;

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

Line 7082: x_return_status := FND_API.G_RET_STS_ERROR;

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
7085: , p_data => x_msg_data
7086: );

Line 7104: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

7100: ,x_msg_data => x_msg_data
7101: );
7102: OE_DEBUG_PUB.Add('x_return_status:' || x_return_status,1);
7103:
7104: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7105: oe_debug_pub.add('process_release_source unexpected failure',3);
7106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7107: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
7108: oe_debug_pub.add('process_release_source expected failure',3);

Line 7106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7102: OE_DEBUG_PUB.Add('x_return_status:' || x_return_status,1);
7103:
7104: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7105: oe_debug_pub.add('process_release_source unexpected failure',3);
7106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7107: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
7108: oe_debug_pub.add('process_release_source expected failure',3);
7109: RAISE FND_API.G_EXC_ERROR;
7110: END IF;

Line 7107: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

7103:
7104: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7105: oe_debug_pub.add('process_release_source unexpected failure',3);
7106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7107: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
7108: oe_debug_pub.add('process_release_source expected failure',3);
7109: RAISE FND_API.G_EXC_ERROR;
7110: END IF;
7111:

Line 7109: RAISE FND_API.G_EXC_ERROR;

7105: oe_debug_pub.add('process_release_source unexpected failure',3);
7106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7107: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
7108: oe_debug_pub.add('process_release_source expected failure',3);
7109: RAISE FND_API.G_EXC_ERROR;
7110: END IF;
7111:
7112: x_return_status := FND_API.G_RET_STS_SUCCESS;
7113: -- Get message count and data

Line 7112: x_return_status := FND_API.G_RET_STS_SUCCESS;

7108: oe_debug_pub.add('process_release_source expected failure',3);
7109: RAISE FND_API.G_EXC_ERROR;
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

Line 7122: WHEN FND_API.G_EXC_ERROR THEN

7118:
7119:
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

Line 7123: x_return_status := FND_API.G_RET_STS_ERROR ;

7119:
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: );

Line 7129: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

7125: ( p_count => x_msg_count,
7126: p_data => x_msg_data
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

Line 7130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

7126: p_data => x_msg_data
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: );

Line 7137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

7133: p_data => x_msg_data
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

Line 7221: x_return_status := FND_API.G_RET_STS_ERROR;

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
7225: );

Line 7247: -- RAISE FND_API.G_EXC_ERROR;

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

Line 7248: x_return_status := FND_API.G_RET_STS_ERROR;

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
7251: , p_data => x_msg_data
7252: );

Line 7296: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

7292:
7293: OE_DEBUG_PUB.Add('After oe_holds_pvt.release_holds:' || x_return_status,3);
7294:
7295: -- Changes begin : ER 1373910
7296: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
7297:
7298: IF p_wf_release_action = 'Y' THEN
7299: OE_DEBUG_PUB.Add('Before calling Oe_holds_pvt.progress_order');
7300: progress_order( p_hold_id,

Line 7311: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

7307: END IF;
7308: END IF;
7309: -- Changes End : ER 1373910
7310:
7311: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7312: oe_debug_pub.add('process_release_holds_lines unexpected failure',3);
7313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7314: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
7315: oe_debug_pub.add('process_release_holds_lines failure',3);

Line 7313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7309: -- Changes End : ER 1373910
7310:
7311: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7312: oe_debug_pub.add('process_release_holds_lines unexpected failure',3);
7313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7314: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
7315: oe_debug_pub.add('process_release_holds_lines failure',3);
7316: RAISE FND_API.G_EXC_ERROR;
7317: END IF;

Line 7314: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

7310:
7311: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7312: oe_debug_pub.add('process_release_holds_lines unexpected failure',3);
7313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7314: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
7315: oe_debug_pub.add('process_release_holds_lines failure',3);
7316: RAISE FND_API.G_EXC_ERROR;
7317: END IF;
7318:

Line 7316: RAISE FND_API.G_EXC_ERROR;

7312: oe_debug_pub.add('process_release_holds_lines unexpected failure',3);
7313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7314: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
7315: oe_debug_pub.add('process_release_holds_lines failure',3);
7316: RAISE FND_API.G_EXC_ERROR;
7317: END IF;
7318:
7319: END LOOP;
7320:

Line 7321: x_return_status := FND_API.G_RET_STS_SUCCESS;

7317: END IF;
7318:
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

Line 7332: WHEN FND_API.G_EXC_ERROR THEN

7328: OE_DEBUG_PUB.Add('Exiting OE_Holds_PVT.process_release_holds_lines',1);
7329:
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

Line 7333: x_return_status := FND_API.G_RET_STS_ERROR ;

7329:
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: );

Line 7340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

7336: p_data => x_msg_data
7337: );
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

Line 7341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

7337: );
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: );

Line 7349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

7345: );
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

Line 7429: x_return_status := FND_API.G_RET_STS_ERROR;

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
7433: );

Line 7455: -- RAISE FND_API.G_EXC_ERROR;

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
7459: ( p_count => x_msg_count

Line 7456: x_return_status := FND_API.G_RET_STS_ERROR;

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
7459: ( p_count => x_msg_count
7460: , p_data => x_msg_data

Line 7498: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

7494: OE_DEBUG_PUB.Add('x_msg_count:' || to_char(x_msg_count),2);
7495: OE_DEBUG_PUB.Add('x_msg_data:' || x_msg_data,2);
7496:
7497: -- Changes begin : ER 1373910
7498: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
7499: IF p_wf_release_action = 'Y' THEN
7500: OE_DEBUG_PUB.Add('Before calling Oe_holds_pvt.progress_order');
7501: progress_order( p_hold_id,
7502: p_num_of_records,

Line 7512: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

7508: END IF;
7509: END IF;
7510: -- Changes end : ER 1373910
7511:
7512: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7513: oe_debug_pub.add('process_release_holds_orders unexpected failure',3);
7514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7515: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
7516: oe_debug_pub.add('process_release_holds_orders failure',3);

Line 7514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7510: -- Changes end : ER 1373910
7511:
7512: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7513: oe_debug_pub.add('process_release_holds_orders unexpected failure',3);
7514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7515: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
7516: oe_debug_pub.add('process_release_holds_orders failure',3);
7517: RAISE FND_API.G_EXC_ERROR;
7518: END IF;

Line 7515: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

7511:
7512: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7513: oe_debug_pub.add('process_release_holds_orders unexpected failure',3);
7514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7515: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
7516: oe_debug_pub.add('process_release_holds_orders failure',3);
7517: RAISE FND_API.G_EXC_ERROR;
7518: END IF;
7519:

Line 7517: RAISE FND_API.G_EXC_ERROR;

7513: oe_debug_pub.add('process_release_holds_orders unexpected failure',3);
7514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7515: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
7516: oe_debug_pub.add('process_release_holds_orders failure',3);
7517: RAISE FND_API.G_EXC_ERROR;
7518: END IF;
7519:
7520:
7521: END LOOP;

Line 7523: x_return_status := FND_API.G_RET_STS_SUCCESS;

7519:
7520:
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

Line 7534: WHEN FND_API.G_EXC_ERROR THEN

7530: OE_DEBUG_PUB.Add('Exiting OE_Holds_PVT.process_release_holds_orders',1);
7531:
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

Line 7535: x_return_status := FND_API.G_RET_STS_ERROR ;

7531:
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: );

Line 7542: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

7538: p_data => x_msg_data
7539: );
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

Line 7543: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

7539: );
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: );

Line 7551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

7547: );
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

Line 7625: RAISE FND_API.G_EXC_ERROR;

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

Line 7626: x_return_status := FND_API.G_RET_STS_ERROR;

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
7629: , p_data => x_msg_data
7630: );

Line 7646: x_return_status := FND_API.G_RET_STS_ERROR;

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
7650: );

Line 7672: RAISE FND_API.G_EXC_ERROR;

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

Line 7673: x_return_status := FND_API.G_RET_STS_ERROR;

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
7676: , p_data => x_msg_data
7677: );

Line 7698: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

7694:
7695: OE_DEBUG_PUB.Add('x_return_status:' || x_return_status,1);
7696:
7697: -- Changes begin : ER 1373910
7698: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
7699: IF p_wf_release_action = 'Y' THEN
7700: Oe_debug_pub.Add('Before calling Oe_holds_pvt.progress_order');
7701: progress_order( p_hold_source_id,
7702: x_return_status,

Line 7710: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

7706: END IF;
7707: END IF;
7708: -- Changes end : ER 1373910
7709:
7710: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7711: oe_debug_pub.add('process_release_source unexpected failure',3);
7712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7713: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
7714: oe_debug_pub.add('process_release_source expected failure',3);

Line 7712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7708: -- Changes end : ER 1373910
7709:
7710: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7711: oe_debug_pub.add('process_release_source unexpected failure',3);
7712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7713: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
7714: oe_debug_pub.add('process_release_source expected failure',3);
7715: RAISE FND_API.G_EXC_ERROR;
7716: END IF;

Line 7713: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

7709:
7710: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7711: oe_debug_pub.add('process_release_source unexpected failure',3);
7712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7713: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
7714: oe_debug_pub.add('process_release_source expected failure',3);
7715: RAISE FND_API.G_EXC_ERROR;
7716: END IF;
7717:

Line 7715: RAISE FND_API.G_EXC_ERROR;

7711: oe_debug_pub.add('process_release_source unexpected failure',3);
7712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7713: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
7714: oe_debug_pub.add('process_release_source expected failure',3);
7715: RAISE FND_API.G_EXC_ERROR;
7716: END IF;
7717:
7718: x_return_status := FND_API.G_RET_STS_SUCCESS;
7719: -- Get message count and data

Line 7718: x_return_status := FND_API.G_RET_STS_SUCCESS;

7714: oe_debug_pub.add('process_release_source expected failure',3);
7715: RAISE FND_API.G_EXC_ERROR;
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

Line 7728: WHEN FND_API.G_EXC_ERROR THEN

7724:
7725:
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

Line 7729: x_return_status := FND_API.G_RET_STS_ERROR ;

7725:
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: );

Line 7735: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

7731: ( p_count => x_msg_count,
7732: p_data => x_msg_data
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

Line 7736: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

7732: p_data => x_msg_data
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: );

Line 7743: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

7739: p_data => x_msg_data
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

Line 7814: x_return_status := FND_API.G_RET_STS_SUCCESS;

7810: AND OH.HOLD_SOURCE_ID = HS.HOLD_SOURCE_ID;
7811:
7812:
7813: BEGIN
7814: x_return_status := FND_API.G_RET_STS_SUCCESS;
7815:
7816: l_user_id := OE_HOLDS_PVT.get_user_id;
7817: l_org_id := OE_GLOBALS.G_ORG_ID;
7818: if l_org_id IS NULL THEN

Line 7895: WHEN FND_API.G_EXC_ERROR THEN

7891:
7892: exception
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

Line 7896: x_return_status := FND_API.G_RET_STS_ERROR;

7892: exception
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: );

Line 7901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 7902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7898: ( p_count => x_msg_count
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: );

Line 7908: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7904: ( p_count => x_msg_count
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

Line 7952: x_return_status := FND_API.G_RET_STS_SUCCESS;

7948: BEGIN
7949:
7950: OE_DEBUG_PUB.Add('In OE_Holds_pvt.Apply Holds, Creating Hold Source',1);
7951:
7952: x_return_status := FND_API.G_RET_STS_SUCCESS;
7953: l_hold_source_rec := p_hold_source_rec;
7954:
7955: Validate (p_hold_source_rec => p_hold_source_rec,
7956: x_return_status => x_return_status,

Line 7961: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

7957: x_msg_count => x_msg_count,
7958: x_msg_data => x_msg_data );
7959: OE_DEBUG_PUB.Add('Validate return status:' || x_return_status,1);
7960:
7961: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7962: OE_Debug_PUB.Add('Validate not successful',1);
7963: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
7964: RAISE FND_API.G_EXC_ERROR;
7965: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 7963: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

7959: OE_DEBUG_PUB.Add('Validate return status:' || x_return_status,1);
7960:
7961: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7962: OE_Debug_PUB.Add('Validate not successful',1);
7963: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
7964: RAISE FND_API.G_EXC_ERROR;
7965: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7967: END IF;

Line 7964: RAISE FND_API.G_EXC_ERROR;

7960:
7961: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7962: OE_Debug_PUB.Add('Validate not successful',1);
7963: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
7964: RAISE FND_API.G_EXC_ERROR;
7965: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7967: END IF;
7968: ELSE

Line 7965: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

7961: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7962: OE_Debug_PUB.Add('Validate not successful',1);
7963: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
7964: RAISE FND_API.G_EXC_ERROR;
7965: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7967: END IF;
7968: ELSE
7969: OE_DEBUG_PUB.Add ('Calling Create_Hold_Source bug 5548778 overload',1);

Line 7966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7962: OE_Debug_PUB.Add('Validate not successful',1);
7963: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
7964: RAISE FND_API.G_EXC_ERROR;
7965: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7967: END IF;
7968: ELSE
7969: OE_DEBUG_PUB.Add ('Calling Create_Hold_Source bug 5548778 overload',1);
7970: Create_Hold_Source (

Line 7983: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

7979: OE_DEBUG_PUB.Add('x_return_status->' || x_return_status,1);
7980: OE_DEBUG_PUB.Add('x_msg_count->' || x_msg_count,1);
7981: OE_DEBUG_PUB.Add('x_msg_data' || x_msg_data,1);
7982: OE_DEBUG_PUB.Add('l_hold_exists' || l_hold_exists,1);
7983: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7984: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
7985: RAISE FND_API.G_EXC_ERROR;
7986: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
7987: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 7984: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

7980: OE_DEBUG_PUB.Add('x_msg_count->' || x_msg_count,1);
7981: OE_DEBUG_PUB.Add('x_msg_data' || x_msg_data,1);
7982: OE_DEBUG_PUB.Add('l_hold_exists' || l_hold_exists,1);
7983: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7984: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
7985: RAISE FND_API.G_EXC_ERROR;
7986: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
7987: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7988: END IF;

Line 7985: RAISE FND_API.G_EXC_ERROR;

7981: OE_DEBUG_PUB.Add('x_msg_data' || x_msg_data,1);
7982: OE_DEBUG_PUB.Add('l_hold_exists' || l_hold_exists,1);
7983: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7984: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
7985: RAISE FND_API.G_EXC_ERROR;
7986: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
7987: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7988: END IF;
7989: END IF;

Line 7986: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

7982: OE_DEBUG_PUB.Add('l_hold_exists' || l_hold_exists,1);
7983: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7984: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
7985: RAISE FND_API.G_EXC_ERROR;
7986: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
7987: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7988: END IF;
7989: END IF;
7990:

Line 7987: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7983: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7984: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
7985: RAISE FND_API.G_EXC_ERROR;
7986: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
7987: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7988: END IF;
7989: END IF;
7990:
7991: OE_DEBUG_PUB.Add('l_hold_source_id->' ||

Line 8162: x_return_status := FND_API.G_RET_STS_SUCCESS;

8158: l_line_rec OE_Order_PUB.Line_Rec_Type;
8159: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
8160: -- GENESIS --
8161: BEGIN
8162: x_return_status := FND_API.G_RET_STS_SUCCESS;
8163: l_user_id := OE_HOLDS_PVT.get_user_id;
8164: l_org_id := MO_GLOBAL.get_current_org_id;
8165: x_is_hold_applied := NULL;
8166: IF l_org_id IS NULL THEN

Line 8169: x_return_status := FND_API.G_RET_STS_ERROR;

8165: x_is_hold_applied := NULL;
8166: IF l_org_id IS NULL THEN
8167: -- org_id is null, raise an error.
8168: oe_debug_pub.add('Org_Id is NULL',1);
8169: x_return_status := FND_API.G_RET_STS_ERROR;
8170: FND_MESSAGE.SET_NAME('FND','MO_ORG_REQUIRED');
8171: FND_MSG_PUB.ADD;
8172: RAISE FND_API.G_EXC_ERROR;
8173: END IF;

Line 8172: RAISE FND_API.G_EXC_ERROR;

8168: oe_debug_pub.add('Org_Id is NULL',1);
8169: x_return_status := FND_API.G_RET_STS_ERROR;
8170: FND_MESSAGE.SET_NAME('FND','MO_ORG_REQUIRED');
8171: FND_MSG_PUB.ADD;
8172: RAISE FND_API.G_EXC_ERROR;
8173: END IF;
8174:
8175: oe_debug_pub.add('p_hold_source_rec.hold_source_id:' ||
8176: p_hold_source_rec.hold_source_id);

Line 8384: RAISE FND_API.G_EXC_ERROR;

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(*)
8387: into l_parent_count
8388: FROM OE_ORDER_HEADERS_ALL h, OE_ORDER_LINES_ALL ol

Line 8706: RAISE FND_API.G_EXC_ERROR;

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(*)
8709: into l_parent_count
8710: FROM OE_ORDER_HEADERS_ALL h, OE_ORDER_LINES_ALL ol , ra_terms_b rt

Line 8923: RAISE FND_API.G_EXC_ERROR;

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(*)
8926: into l_parent_count
8927: FROM OE_ORDER_HEADERS_ALL h, OE_ORDER_LINES_ALL ol

Line 9136: RAISE FND_API.G_EXC_ERROR;

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(*)
9139: into l_parent_count
9140: FROM OE_ORDER_HEADERS_ALL h, OE_ORDER_LINES_ALL ol

Line 9350: RAISE FND_API.G_EXC_ERROR;

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(*)
9353: into l_parent_count
9354: FROM OE_ORDER_HEADERS_ALL h, OE_ORDER_LINES_ALL ol

Line 9564: RAISE FND_API.G_EXC_ERROR;

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(*)
9567: into l_parent_count
9568: FROM OE_ORDER_HEADERS_ALL h, OE_ORDER_LINES_ALL ol

Line 9782: RAISE FND_API.G_EXC_ERROR;

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(*)
9785: into l_parent_count
9786: FROM OE_ORDER_HEADERS_ALL h, OE_ORDER_LINES_ALL ol

Line 10087: RAISE FND_API.G_EXC_ERROR;

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(*)
10090: into l_parent_count
10091: FROM OE_ORDER_HEADERS_ALL h, OE_ORDER_LINES_ALL ol

Line 10301: RAISE FND_API.G_EXC_ERROR;

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(*)
10304: into l_parent_count
10305: FROM OE_ORDER_HEADERS_ALL h, OE_ORDER_LINES_ALL ol

Line 10518: RAISE FND_API.G_EXC_ERROR;

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(*)
10521: into l_parent_count
10522: FROM OE_ORDER_HEADERS_ALL h, OE_ORDER_LINES_ALL ol

Line 10843: RAISE FND_API.G_EXC_ERROR;

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(*)
10846: into l_parent_count
10847: FROM OE_ORDER_HEADERS_ALL h, OE_ORDER_LINES_ALL ol

Line 11057: RAISE FND_API.G_EXC_ERROR;

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(*)
11060: into l_parent_count
11061: FROM OE_ORDER_HEADERS_ALL h, OE_ORDER_LINES_ALL ol

Line 11271: RAISE FND_API.G_EXC_ERROR;

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(*)
11274: into l_parent_count
11275: FROM OE_ORDER_HEADERS_ALL h, OE_ORDER_LINES_ALL ol

Line 11482: RAISE FND_API.G_EXC_ERROR;

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(*)
11485: into l_parent_count
11486: FROM OE_ORDER_HEADERS_ALL h, OE_ORDER_LINES_ALL ol

Line 11662: RAISE FND_API.G_EXC_ERROR;

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;
11665: SELECT count(*)
11666: into l_parent_count

Line 11855: RAISE FND_API.G_EXC_ERROR;

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(*)
11858: into l_parent_count
11859: FROM OE_ORDER_HEADERS_ALL h

Line 12317: RAISE FND_API.G_EXC_ERROR;

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(*)
12320: into l_parent_count
12321: FROM OE_ORDER_HEADERS_ALL h, OE_ORDER_LINES_ALL ol

Line 12529: RAISE FND_API.G_EXC_ERROR;

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(*)
12532: into l_parent_count
12533: FROM OE_ORDER_HEADERS_ALL h, OE_ORDER_LINES_ALL ol

Line 12740: RAISE FND_API.G_EXC_ERROR;

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(*)
12743: into l_parent_count
12744: FROM OE_ORDER_HEADERS_ALL h, OE_ORDER_LINES_ALL ol

Line 12951: RAISE FND_API.G_EXC_ERROR;

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
12955: FROM OE_ORDER_HEADERS_ALL h, OE_ORDER_LINES_ALL ol

Line 13479: WHEN FND_API.G_EXC_ERROR THEN

13475: END IF;
13476: -- GENESIS --
13477:
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

Line 13481: x_return_status := FND_API.G_RET_STS_ERROR;

13477:
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: );

Line 13486: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 13488: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

13484: , p_data => x_msg_data
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: );

Line 13495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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