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.

[Home] [Help]

APPS.OE_HOLDS_PVT dependencies on FND_MESSAGE

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

954: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
955: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
956: AND lookup_code = p_activity_name;
957:
958: FND_MESSAGE.SET_NAME('ONT', 'OE_NO_HOLD_ALL_LINES');
959: FND_MESSAGE.SET_TOKEN('WF_ACT', l_user_activity_name);
960: OE_MSG_PUB.ADD;
961: OE_DEBUG_PUB.ADD(' Hold Not applied for All requested records');
962: RAISE FND_API.G_EXC_ERROR;

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

955: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
956: AND lookup_code = p_activity_name;
957:
958: FND_MESSAGE.SET_NAME('ONT', 'OE_NO_HOLD_ALL_LINES');
959: FND_MESSAGE.SET_TOKEN('WF_ACT', l_user_activity_name);
960: OE_MSG_PUB.ADD;
961: OE_DEBUG_PUB.ADD(' Hold Not applied for All requested records');
962: RAISE FND_API.G_EXC_ERROR;
963:

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

992: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
993: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
994: AND lookup_code = p_activity_name;
995:
996: FND_MESSAGE.SET_NAME('ONT', 'OE_NO_HOLD_FEW_LINES');
997: FND_MESSAGE.SET_TOKEN('WF_ACT', l_user_activity_name);
998: OE_MSG_PUB.ADD;
999: OE_DEBUG_PUB.ADD(' Hold Not applied for FEW of the requested records');
1000: END IF;

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

993: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
994: AND lookup_code = p_activity_name;
995:
996: FND_MESSAGE.SET_NAME('ONT', 'OE_NO_HOLD_FEW_LINES');
997: FND_MESSAGE.SET_TOKEN('WF_ACT', l_user_activity_name);
998: OE_MSG_PUB.ADD;
999: OE_DEBUG_PUB.ADD(' Hold Not applied for FEW of the requested records');
1000: END IF;
1001: END IF;

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

1248: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
1249: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
1250: AND lookup_code = p_activity_name;
1251:
1252: FND_MESSAGE.SET_NAME('ONT', 'OE_NO_HOLD_ALL_LINES');
1253: FND_MESSAGE.SET_TOKEN('WF_ACT',l_user_activity_name);
1254: OE_MSG_PUB.ADD;
1255: OE_DEBUG_PUB.ADD(' Hold Not applied for All requested records');
1256: RAISE FND_API.G_EXC_ERROR;

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

1249: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
1250: AND lookup_code = p_activity_name;
1251:
1252: FND_MESSAGE.SET_NAME('ONT', 'OE_NO_HOLD_ALL_LINES');
1253: FND_MESSAGE.SET_TOKEN('WF_ACT',l_user_activity_name);
1254: OE_MSG_PUB.ADD;
1255: OE_DEBUG_PUB.ADD(' Hold Not applied for All requested records');
1256: RAISE FND_API.G_EXC_ERROR;
1257:

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

1286: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
1287: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
1288: AND lookup_code = p_activity_name;
1289:
1290: FND_MESSAGE.SET_NAME('ONT', 'OE_NO_HOLD_FEW_LINES');
1291: FND_MESSAGE.SET_TOKEN('WF_ACT',l_user_activity_name);
1292: OE_MSG_PUB.ADD;
1293: OE_DEBUG_PUB.ADD(' Hold Not applied for FEW of the requested records');
1294: END IF;

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

1287: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
1288: AND lookup_code = p_activity_name;
1289:
1290: FND_MESSAGE.SET_NAME('ONT', 'OE_NO_HOLD_FEW_LINES');
1291: FND_MESSAGE.SET_TOKEN('WF_ACT',l_user_activity_name);
1292: OE_MSG_PUB.ADD;
1293: OE_DEBUG_PUB.ADD(' Hold Not applied for FEW of the requested records');
1294: END IF;
1295: END IF;

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

1790: (p_hold_source_rec.hold_entity_code = 'O' AND
1791: p_hold_source_rec.line_id IS NOT NULL) OR
1792: p_hold_source_rec.hold_entity_code2 IS NOT NULL THEN
1793: oe_debug_pub.add('Error: Order WF Hold, being applied at Line Level');
1794: FND_MESSAGE.SET_NAME('ONT','OE_ORDER_HOLD_INVALID_CRITERIA');
1795: OE_MSG_PUB.ADD;
1796: RAISE FND_API.G_EXC_ERROR;
1797: END IF;
1798: ELSIF l_item_type = 'OEOL' THEN

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

1799: IF p_hold_source_rec.hold_entity_code IN ('C','O') AND
1800: p_hold_source_rec.line_id IS NULL AND
1801: l_apply_to_flag = 'N' THEN
1802: oe_debug_pub.add('Error: Line WF Hold, being applied at Order Level');
1803: FND_MESSAGE.SET_NAME('ONT','OE_LINE_HOLD_INVALID_CRITERIA');
1804: OE_MSG_PUB.ADD;
1805: RAISE FND_API.G_EXC_ERROR;
1806: END IF;
1807: END IF;

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

1828: NULL;
1829: oe_debug_pub.add('Order WF HOLD');
1830: ELSIF l_item_type = 'OEOL' AND l_apply_to_flag = 'N' THEN
1831: oe_debug_pub.add('Error: Line WF Hold, being applied at Order Level');
1832: FND_MESSAGE.SET_NAME('ONT','OE_LINE_HOLD_INVALID_CRITERIA');
1833: OE_MSG_PUB.ADD;
1834: RAISE FND_API.G_EXC_ERROR;
1835: END IF;
1836: ELSE

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

1841: NULL;
1842: oe_debug_pub.add('Line WF HOLD');
1843: ELSIF l_item_type = 'OEOH' THEN
1844: oe_debug_pub.add('Error: Order WF Hold, being applied at Line Level');
1845: FND_MESSAGE.SET_NAME('ONT','OE_ORDER_HOLD_INVALID_CRITERIA');
1846: OE_MSG_PUB.ADD;
1847: RAISE FND_API.G_EXC_ERROR;
1848: END IF;
1849: END IF;

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

1858: if p_hold_source_rec.hold_entity_code = 'I' then
1859: --ER#7479609 if p_hold_source_rec.hold_entity_code2 not in ('C', 'S', 'B', 'W','H') then
1860: if p_hold_source_rec.hold_entity_code2 not in ('C', 'S', 'B', 'W','H','SM','D','PL','PR','ST','LT') then --ER#7479609
1861: OE_Debug_PUB.Add('Invalid Entity Combination',1);
1862: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ENTITY_CONBINATION');
1863: OE_MSG_PUB.ADD;
1864: RAISE FND_API.G_EXC_ERROR;
1865: end if;
1866: elsif p_hold_source_rec.hold_entity_code = 'W' then

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2060: AND lookup_type = 'SHIP_METHOD';
2061: --ER#7479609 end
2062: ELSE
2063: OE_Debug_PUB.Add('Invalid Entity Code');
2064: FND_MESSAGE.SET_NAME('ONT', 'OE_MISSING_ENTITY_CODE');
2065: OE_MSG_PUB.ADD;
2066: RAISE FND_API.G_EXC_ERROR;
2067: END IF;
2068:

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

2211: where currency_code = p_hold_source_rec.hold_entity_id2;
2212: --ER#7479609 end
2213: ELSE
2214: OE_Debug_PUB.Add('Invalid Second Entity Code');
2215: FND_MESSAGE.SET_NAME('ONT', 'OE_MISSING_ENTITY_CODE');
2216: OE_MSG_PUB.ADD;
2217: RAISE FND_API.G_EXC_ERROR;
2218: END IF;
2219: END IF;

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

2224: null;
2225: WHEN NO_DATA_FOUND THEN
2226: /* XXX Error message here */
2227: OE_Debug_PUB.Add('Hold Entity ID not found for entity',1);
2228: FND_MESSAGE.SET_NAME('ONT', 'OE_MISSING_ENTITY_ID');
2229: OE_MSG_PUB.ADD;
2230: RAISE FND_API.G_EXC_ERROR;
2231: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2232: WHEN FND_API.G_EXC_ERROR THEN

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

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;
2237: */
2238: OE_Debug_PUB.Add('Expected error in Validate_Hold_source',1);
2239: x_return_status := FND_API.G_RET_STS_ERROR;

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

2264:
2265:
2266: -- Check for Missing Values
2267: IF p_hold_id IS NULL THEN
2268: FND_MESSAGE.SET_NAME('ONT', 'OE_MISSING_HOLD_ID');
2269: OE_MSG_PUB.ADD;
2270: RAISE FND_API.G_EXC_ERROR;
2271: END IF;
2272:

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

2285: EXCEPTION
2286:
2287: WHEN NO_DATA_FOUND THEN
2288: OE_Debug_PUB.Add('Invalid Hold ID'||to_char(p_hold_id),1);
2289: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_HOLD_ID');
2290: FND_MESSAGE.SET_TOKEN('HOLD_ID',p_hold_id);
2291: OE_MSG_PUB.ADD;
2292: x_return_status := FND_API.G_RET_STS_ERROR;
2293:

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

2286:
2287: WHEN NO_DATA_FOUND THEN
2288: OE_Debug_PUB.Add('Invalid Hold ID'||to_char(p_hold_id),1);
2289: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_HOLD_ID');
2290: FND_MESSAGE.SET_TOKEN('HOLD_ID',p_hold_id);
2291: OE_MSG_PUB.ADD;
2292: x_return_status := FND_API.G_RET_STS_ERROR;
2293:
2294: END; -- Validate Hold ID

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

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

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

2351:
2352: IF l_count > 0 THEN
2353: OE_Debug_PUB.Add('Duplicate Hold Source for EntityID'||
2354: to_char(p_hold_source_rec.hold_entity_id) ,1);
2355: --FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD');
2356: FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD_SOURCE');
2357: OE_MSG_PUB.ADD;
2358: x_hold_exists := 'Y';
2359: RETURN;

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

2352: IF l_count > 0 THEN
2353: OE_Debug_PUB.Add('Duplicate Hold Source for EntityID'||
2354: to_char(p_hold_source_rec.hold_entity_id) ,1);
2355: --FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD');
2356: FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD_SOURCE');
2357: OE_MSG_PUB.ADD;
2358: x_hold_exists := 'Y';
2359: RETURN;
2360: --RAISE FND_API.G_EXC_ERROR;

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

2382:
2383: IF l_count > 0 THEN
2384: OE_Debug_PUB.Add('Duplicate Hold Source for EntityID'||
2385: to_char(p_hold_source_rec.hold_entity_id) ,1);
2386: --FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD');
2387: FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD_SOURCE');
2388: OE_MSG_PUB.ADD;
2389: x_hold_exists := 'Y';
2390: RETURN;

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

2383: IF l_count > 0 THEN
2384: OE_Debug_PUB.Add('Duplicate Hold Source for EntityID'||
2385: to_char(p_hold_source_rec.hold_entity_id) ,1);
2386: --FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD');
2387: FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD_SOURCE');
2388: OE_MSG_PUB.ADD;
2389: x_hold_exists := 'Y';
2390: RETURN;
2391: --RAISE FND_API.G_EXC_ERROR;

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

2410:
2411: IF l_count > 0 THEN
2412: OE_Debug_PUB.Add('Duplicate Hold Source for EntityID'||
2413: to_char(p_hold_source_rec.hold_entity_id) ,1);
2414: --FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD');
2415: FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD_SOURCE');
2416: OE_MSG_PUB.ADD;
2417: --RETURN;
2418: RAISE FND_API.G_EXC_ERROR;

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

2411: IF l_count > 0 THEN
2412: OE_Debug_PUB.Add('Duplicate Hold Source for EntityID'||
2413: to_char(p_hold_source_rec.hold_entity_id) ,1);
2414: --FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD');
2415: FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD_SOURCE');
2416: OE_MSG_PUB.ADD;
2417: --RETURN;
2418: RAISE FND_API.G_EXC_ERROR;
2419: END IF;

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

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

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

2592:
2593: IF l_count > 0 THEN
2594: OE_Debug_PUB.Add('Duplicate Hold Source for EntityID'||
2595: to_char(p_hold_source_rec.hold_entity_id) ,1);
2596: --FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD');
2597: FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD_SOURCE');
2598: OE_MSG_PUB.ADD;
2599: --RETURN;
2600: RAISE FND_API.G_EXC_ERROR;

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

2593: IF l_count > 0 THEN
2594: OE_Debug_PUB.Add('Duplicate Hold Source for EntityID'||
2595: to_char(p_hold_source_rec.hold_entity_id) ,1);
2596: --FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD');
2597: FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD_SOURCE');
2598: OE_MSG_PUB.ADD;
2599: --RETURN;
2600: RAISE FND_API.G_EXC_ERROR;
2601: END IF;

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

2621:
2622: IF l_count > 0 THEN
2623: OE_Debug_PUB.Add('Duplicate Hold Source for EntityID'||
2624: to_char(p_hold_source_rec.hold_entity_id) ,1);
2625: --FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD');
2626: FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD_SOURCE');
2627: OE_MSG_PUB.ADD;
2628: --RETURN;
2629: RAISE FND_API.G_EXC_ERROR;

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

2622: IF l_count > 0 THEN
2623: OE_Debug_PUB.Add('Duplicate Hold Source for EntityID'||
2624: to_char(p_hold_source_rec.hold_entity_id) ,1);
2625: --FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD');
2626: FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD_SOURCE');
2627: OE_MSG_PUB.ADD;
2628: --RETURN;
2629: RAISE FND_API.G_EXC_ERROR;
2630: END IF;

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

2653:
2654: IF l_count > 0 THEN
2655: OE_Debug_PUB.Add('Duplicate Hold Source for EntityID'||
2656: to_char(p_hold_source_rec.hold_entity_id) ,1);
2657: --FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD');
2658: FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD_SOURCE');
2659: OE_MSG_PUB.ADD;
2660: --RETURN;
2661: RAISE FND_API.G_EXC_ERROR;

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

2654: IF l_count > 0 THEN
2655: OE_Debug_PUB.Add('Duplicate Hold Source for EntityID'||
2656: to_char(p_hold_source_rec.hold_entity_id) ,1);
2657: --FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD');
2658: FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD_SOURCE');
2659: OE_MSG_PUB.ADD;
2660: --RETURN;
2661: RAISE FND_API.G_EXC_ERROR;
2662: END IF;

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

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

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

4875:
4876: WHEN NO_DATA_FOUND THEN
4877: oe_debug_pub.add('Invalid Reason Code:' ||
4878: p_hold_release_rec.release_reason_code ,2);
4879: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_REASON_CODE');
4880: FND_MESSAGE.SET_TOKEN('REASON_CODE',
4881: p_hold_release_rec.release_reason_code);
4882: OE_MSG_PUB.ADD;
4883: RAISE FND_API.G_EXC_ERROR;

Line 4880: FND_MESSAGE.SET_TOKEN('REASON_CODE',

4876: WHEN NO_DATA_FOUND THEN
4877: oe_debug_pub.add('Invalid Reason Code:' ||
4878: p_hold_release_rec.release_reason_code ,2);
4879: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_REASON_CODE');
4880: FND_MESSAGE.SET_TOKEN('REASON_CODE',
4881: p_hold_release_rec.release_reason_code);
4882: OE_MSG_PUB.ADD;
4883: RAISE FND_API.G_EXC_ERROR;
4884:

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

5052: p_hold_source_rec.line_id,1);
5053: oe_debug_pub.add('Entity Code2/ID2' ||
5054: p_hold_source_rec.hold_entity_code2 || '/' ||
5055: to_char(p_hold_source_rec.hold_entity_id2) ,1);
5056: FND_MESSAGE.SET_NAME('ONT', 'OE_MISSING_HOLD_SOURCE');
5057: OE_MSG_PUB.ADD;
5058: RAISE FND_API.G_EXC_ERROR;
5059: */
5060: CLOSE order_hold_source;

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

5071: to_char(p_hold_source_rec.hold_entity_id) ,1);
5072: oe_debug_pub.add('Entity Code2/ID2' ||
5073: p_hold_source_rec.hold_entity_code2 || '/' ||
5074: to_char(p_hold_source_rec.hold_entity_id2) ,1);
5075: FND_MESSAGE.SET_NAME('ONT', 'OE_MISSING_HOLD_SOURCE');
5076: OE_MSG_PUB.ADD;
5077: RAISE FND_API.G_EXC_ERROR;
5078: END IF; -- hold_source%NOTFOUND
5079: CLOSE hold_source;

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

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;
5142: RAISE FND_API.G_EXC_ERROR;
5143: ELSIF p_header_id IS NULL THEN
5144: l_dummy := 'LINE'; -- Added for bug 7112725

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

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;
5164: ELSIF l_dummy = 'LINE' THEN
5165: FND_MESSAGE.SET_NAME('ONT', 'OE_COGS_INVALID_LINE_ID');

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

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;
5164: ELSIF l_dummy = 'LINE' THEN
5165: FND_MESSAGE.SET_NAME('ONT', 'OE_COGS_INVALID_LINE_ID');
5166: FND_MESSAGE.SET_TOKEN('LINE_ID',p_line_id);

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

5161: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_HEADER_ID');
5162: FND_MESSAGE.SET_TOKEN('HEADER_ID',p_header_id);
5163: OE_MSG_PUB.ADD;
5164: ELSIF l_dummy = 'LINE' THEN
5165: FND_MESSAGE.SET_NAME('ONT', 'OE_COGS_INVALID_LINE_ID');
5166: FND_MESSAGE.SET_TOKEN('LINE_ID',p_line_id);
5167: OE_MSG_PUB.ADD;
5168: END IF;
5169: oe_debug_pub.add('Return Status : ' || x_return_status, 5);

Line 5166: FND_MESSAGE.SET_TOKEN('LINE_ID',p_line_id);

5162: FND_MESSAGE.SET_TOKEN('HEADER_ID',p_header_id);
5163: OE_MSG_PUB.ADD;
5164: ELSIF l_dummy = 'LINE' THEN
5165: FND_MESSAGE.SET_NAME('ONT', 'OE_COGS_INVALID_LINE_ID');
5166: FND_MESSAGE.SET_TOKEN('LINE_ID',p_line_id);
5167: OE_MSG_PUB.ADD;
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

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

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;
5254:
5255: END IF;

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

5559: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
5560: and lookup_code = l_wf_activity_name;
5561:
5562: IF p_order_tbl.COUNT = 1 AND l_count_of_holds_applied = 0 THEN
5563: fnd_message.set_name('ONT', 'OE_NO_HOLD_FOR_ACTIVITY');
5564: fnd_message.set_token('WF_ACT',l_user_activity_name);
5565: OE_MSG_PUB.ADD;
5566: oe_debug_pub.add(' Hold Not applied for the requested line');
5567: RAISE FND_API.G_EXC_ERROR;

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

5560: and lookup_code = l_wf_activity_name;
5561:
5562: IF p_order_tbl.COUNT = 1 AND l_count_of_holds_applied = 0 THEN
5563: fnd_message.set_name('ONT', 'OE_NO_HOLD_FOR_ACTIVITY');
5564: fnd_message.set_token('WF_ACT',l_user_activity_name);
5565: OE_MSG_PUB.ADD;
5566: oe_debug_pub.add(' Hold Not applied for the requested line');
5567: RAISE FND_API.G_EXC_ERROR;
5568: ELSIF l_count_of_holds_applied = 0

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

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);
5572: OE_MSG_PUB.ADD;
5573: oe_debug_pub.add('Hold Not applied for ALL requested lines');
5574: RAISE FND_API.G_EXC_ERROR;

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

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

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

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);
5579: OE_MSG_PUB.ADD;
5580: oe_debug_pub.add('Hold Not applied for FEW requested lines');
5581: ELSE

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

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);
5579: OE_MSG_PUB.ADD;
5580: oe_debug_pub.add('Hold Not applied for FEW requested lines');
5581: ELSE
5582: NULL; -- No messages are required to be logged.

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

5973: x_msg_count => x_msg_count,
5974: x_msg_data => x_msg_data) = 'N' THEN
5975:
5976: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(p_hold_id));
5977: fnd_message.set_name('ONT', 'ONT_HOLDS_SYSTEM_CHECK');
5978: OE_MSG_PUB.ADD;
5979: x_return_status := FND_API.G_RET_STS_ERROR;
5980: OE_MSG_PUB.Count_And_Get
5981: ( p_count => x_msg_count

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

5994: ,x_msg_data => x_msg_data
5995: ) = 'N' THEN
5996: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(p_hold_id));
5997:
5998: fnd_message.set_name('ONT','ONT_APPLY');
5999: l_msg_token := fnd_message.get;
6000:
6001: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
6002: fnd_message.set_token('ACTION', l_msg_token);

Line 5999: l_msg_token := fnd_message.get;

5995: ) = 'N' THEN
5996: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(p_hold_id));
5997:
5998: fnd_message.set_name('ONT','ONT_APPLY');
5999: l_msg_token := fnd_message.get;
6000:
6001: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
6002: fnd_message.set_token('ACTION', l_msg_token);
6003:

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

5997:
5998: fnd_message.set_name('ONT','ONT_APPLY');
5999: l_msg_token := fnd_message.get;
6000:
6001: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
6002: fnd_message.set_token('ACTION', l_msg_token);
6003:
6004: OE_MSG_PUB.ADD;
6005: --RAISE FND_API.G_EXC_ERROR;

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

5998: fnd_message.set_name('ONT','ONT_APPLY');
5999: l_msg_token := fnd_message.get;
6000:
6001: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
6002: fnd_message.set_token('ACTION', l_msg_token);
6003:
6004: OE_MSG_PUB.ADD;
6005: --RAISE FND_API.G_EXC_ERROR;
6006: x_return_status := FND_API.G_RET_STS_ERROR;

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

6109: and lookup_code = l_activity_name;
6110:
6111: IF p_sel_rec_tbl.COUNT = 1 AND l_count_of_holds_applied = 0
6112: THEN
6113: fnd_message.set_name('ONT', 'OE_NO_HOLD_FOR_ACTIVITY');
6114: fnd_message.set_token('WF_ACT',l_user_activity_name);
6115: OE_MSG_PUB.ADD;
6116: oe_debug_pub.add(' Hold Not applied for the requested line');
6117: RAISE FND_API.G_EXC_ERROR;

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

6110:
6111: IF p_sel_rec_tbl.COUNT = 1 AND l_count_of_holds_applied = 0
6112: THEN
6113: fnd_message.set_name('ONT', 'OE_NO_HOLD_FOR_ACTIVITY');
6114: fnd_message.set_token('WF_ACT',l_user_activity_name);
6115: OE_MSG_PUB.ADD;
6116: oe_debug_pub.add(' Hold Not applied for the requested line');
6117: RAISE FND_API.G_EXC_ERROR;
6118: ELSIF l_count_of_holds_applied = 0

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

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);
6122: OE_MSG_PUB.ADD;
6123: oe_debug_pub.add('Hold Not applied for ALL requested lines');
6124: RAISE FND_API.G_EXC_ERROR;

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

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

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

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);
6129: OE_MSG_PUB.ADD;
6130: oe_debug_pub.add('Hold Not applied for FEW requested lines');
6131: ELSE

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

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);
6129: OE_MSG_PUB.ADD;
6130: oe_debug_pub.add('Hold Not applied for FEW requested lines');
6131: ELSE
6132: NULL; -- No messages are required to be logged.

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

6221: , x_msg_count => x_msg_count
6222: , x_msg_data => x_msg_data
6223: ) = 'N' THEN
6224: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(p_hold_id));
6225: fnd_message.set_name('ONT', 'ONT_HOLDS_SYSTEM_CHECK');
6226: OE_MSG_PUB.ADD;
6227: x_return_status := FND_API.G_RET_STS_ERROR;
6228: OE_MSG_PUB.Count_And_Get
6229: ( p_count => x_msg_count

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

6243: , x_msg_data => x_msg_data
6244: ) = 'N' THEN
6245: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(p_hold_id));
6246:
6247: fnd_message.set_name('ONT','ONT_APPLY');
6248: l_msg_token := fnd_message.get;
6249:
6250: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
6251: fnd_message.set_token('ACTION', l_msg_token);

Line 6248: l_msg_token := fnd_message.get;

6244: ) = 'N' THEN
6245: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(p_hold_id));
6246:
6247: fnd_message.set_name('ONT','ONT_APPLY');
6248: l_msg_token := fnd_message.get;
6249:
6250: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
6251: fnd_message.set_token('ACTION', l_msg_token);
6252:

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

6246:
6247: fnd_message.set_name('ONT','ONT_APPLY');
6248: l_msg_token := fnd_message.get;
6249:
6250: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
6251: fnd_message.set_token('ACTION', l_msg_token);
6252:
6253: OE_MSG_PUB.ADD;
6254: -- RAISE FND_API.G_EXC_ERROR;

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

6247: fnd_message.set_name('ONT','ONT_APPLY');
6248: l_msg_token := fnd_message.get;
6249:
6250: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
6251: fnd_message.set_token('ACTION', l_msg_token);
6252:
6253: OE_MSG_PUB.ADD;
6254: -- RAISE FND_API.G_EXC_ERROR;
6255: x_return_status := FND_API.G_RET_STS_ERROR;

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

6342: and lookup_code = l_activity_name;
6343:
6344: IF p_sel_rec_tbl.COUNT = 1 AND l_count_of_holds_applied = 0
6345: THEN
6346: fnd_message.set_name('ONT', 'OE_NO_HOLD_FOR_ACTIVITY');
6347: fnd_message.set_token('WF_ACT',l_user_activity_name);
6348: OE_MSG_PUB.ADD;
6349: oe_debug_pub.add(' Hold Not applied for the requested line');
6350: RAISE FND_API.G_EXC_ERROR;

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

6343:
6344: IF p_sel_rec_tbl.COUNT = 1 AND l_count_of_holds_applied = 0
6345: THEN
6346: fnd_message.set_name('ONT', 'OE_NO_HOLD_FOR_ACTIVITY');
6347: fnd_message.set_token('WF_ACT',l_user_activity_name);
6348: OE_MSG_PUB.ADD;
6349: oe_debug_pub.add(' Hold Not applied for the requested line');
6350: RAISE FND_API.G_EXC_ERROR;
6351: ELSIF l_count_of_holds_applied = 0

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

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);
6355: OE_MSG_PUB.ADD;
6356: oe_debug_pub.add('Hold Not applied for ALL requested lines');
6357: RAISE FND_API.G_EXC_ERROR;

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

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

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

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);
6362: OE_MSG_PUB.ADD;
6363: oe_debug_pub.add('Hold Not applied for FEW requested lines');
6364: ELSE

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

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);
6362: OE_MSG_PUB.ADD;
6363: oe_debug_pub.add('Hold Not applied for FEW requested lines');
6364: ELSE
6365: NULL; -- No messages are required to be logged.

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

6458: ,x_msg_count => x_msg_count
6459: ,x_msg_data => x_msg_data
6460: ) = 'N' THEN
6461: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(p_hold_id));
6462: fnd_message.set_name('ONT', 'ONT_HOLDS_SYSTEM_CHECK');
6463: OE_MSG_PUB.ADD;
6464: x_return_status := FND_API.G_RET_STS_ERROR;
6465: OE_MSG_PUB.Count_And_Get
6466: ( p_count => x_msg_count

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

6479: ,x_msg_count => x_msg_count
6480: ,x_msg_data => x_msg_data
6481: ) = 'N' THEN
6482: OE_DEBUG_PUB.Add('Not authorize to Release this Hold:'||to_char(p_hold_id));
6483: fnd_message.set_name('ONT','ONT_RELEASE');
6484: l_msg_token := fnd_message.get;
6485:
6486: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
6487: fnd_message.set_token('ACTION', l_msg_token);

Line 6484: l_msg_token := fnd_message.get;

6480: ,x_msg_data => x_msg_data
6481: ) = 'N' THEN
6482: OE_DEBUG_PUB.Add('Not authorize to Release this Hold:'||to_char(p_hold_id));
6483: fnd_message.set_name('ONT','ONT_RELEASE');
6484: l_msg_token := fnd_message.get;
6485:
6486: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
6487: fnd_message.set_token('ACTION', l_msg_token);
6488:

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

6482: OE_DEBUG_PUB.Add('Not authorize to Release this Hold:'||to_char(p_hold_id));
6483: fnd_message.set_name('ONT','ONT_RELEASE');
6484: l_msg_token := fnd_message.get;
6485:
6486: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
6487: fnd_message.set_token('ACTION', l_msg_token);
6488:
6489: OE_MSG_PUB.ADD;
6490: -- RAISE FND_API.G_EXC_ERROR;

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

6483: fnd_message.set_name('ONT','ONT_RELEASE');
6484: l_msg_token := fnd_message.get;
6485:
6486: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
6487: fnd_message.set_token('ACTION', l_msg_token);
6488:
6489: OE_MSG_PUB.ADD;
6490: -- RAISE FND_API.G_EXC_ERROR;
6491: x_return_status := FND_API.G_RET_STS_ERROR;

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

6633: ,x_msg_count => x_msg_count
6634: ,x_msg_data => x_msg_data
6635: ) = 'N' THEN
6636: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(p_hold_id));
6637: fnd_message.set_name('ONT', 'ONT_HOLDS_SYSTEM_CHECK');
6638: OE_MSG_PUB.ADD;
6639: x_return_status := FND_API.G_RET_STS_ERROR;
6640: OE_MSG_PUB.Count_And_Get
6641: ( p_count => x_msg_count

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

6654: ,x_msg_count => x_msg_count
6655: ,x_msg_data => x_msg_data
6656: ) = 'N' THEN
6657: OE_DEBUG_PUB.Add('Not authorize to Release this Hold:'|| to_char(p_hold_id),1);
6658: fnd_message.set_name('ONT','ONT_RELEASE');
6659: l_msg_token := fnd_message.get;
6660:
6661: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
6662: fnd_message.set_token('ACTION', l_msg_token);

Line 6659: l_msg_token := fnd_message.get;

6655: ,x_msg_data => x_msg_data
6656: ) = 'N' THEN
6657: OE_DEBUG_PUB.Add('Not authorize to Release this Hold:'|| to_char(p_hold_id),1);
6658: fnd_message.set_name('ONT','ONT_RELEASE');
6659: l_msg_token := fnd_message.get;
6660:
6661: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
6662: fnd_message.set_token('ACTION', l_msg_token);
6663:

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

6657: OE_DEBUG_PUB.Add('Not authorize to Release this Hold:'|| to_char(p_hold_id),1);
6658: fnd_message.set_name('ONT','ONT_RELEASE');
6659: l_msg_token := fnd_message.get;
6660:
6661: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
6662: fnd_message.set_token('ACTION', l_msg_token);
6663:
6664: OE_MSG_PUB.ADD;
6665: -- RAISE FND_API.G_EXC_ERROR;

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

6658: fnd_message.set_name('ONT','ONT_RELEASE');
6659: l_msg_token := fnd_message.get;
6660:
6661: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
6662: fnd_message.set_token('ACTION', l_msg_token);
6663:
6664: OE_MSG_PUB.ADD;
6665: -- RAISE FND_API.G_EXC_ERROR;
6666: x_return_status := FND_API.G_RET_STS_ERROR;

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

6802: ,x_msg_count => x_msg_count
6803: ,x_msg_data => x_msg_data
6804: ) = 'N' THEN
6805: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(l_hold_source_rec.hold_id));
6806: fnd_message.set_name('ONT', 'ONT_HOLDS_SYSTEM_CHECK');
6807: OE_MSG_PUB.ADD;
6808: x_return_status := FND_API.G_RET_STS_ERROR;
6809: OE_MSG_PUB.Count_And_Get
6810: ( p_count => x_msg_count

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

6823: ) = 'N' THEN
6824: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'||
6825: to_char(l_hold_source_rec.hold_id));
6826:
6827: fnd_message.set_name('ONT','ONT_APPLY');
6828: l_msg_token := fnd_message.get;
6829:
6830: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
6831: fnd_message.set_token('ACTION', l_msg_token);

Line 6828: l_msg_token := fnd_message.get;

6824: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'||
6825: to_char(l_hold_source_rec.hold_id));
6826:
6827: fnd_message.set_name('ONT','ONT_APPLY');
6828: l_msg_token := fnd_message.get;
6829:
6830: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
6831: fnd_message.set_token('ACTION', l_msg_token);
6832:

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

6826:
6827: fnd_message.set_name('ONT','ONT_APPLY');
6828: l_msg_token := fnd_message.get;
6829:
6830: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
6831: fnd_message.set_token('ACTION', l_msg_token);
6832:
6833: OE_MSG_PUB.ADD;
6834: RAISE FND_API.G_EXC_ERROR;

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

6827: fnd_message.set_name('ONT','ONT_APPLY');
6828: l_msg_token := fnd_message.get;
6829:
6830: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
6831: fnd_message.set_token('ACTION', l_msg_token);
6832:
6833: OE_MSG_PUB.ADD;
6834: RAISE FND_API.G_EXC_ERROR;
6835: x_return_status := FND_API.G_RET_STS_ERROR;

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

7029:
7030: If l_hold_id = 1 AND (l_hold_entity_code ='C' OR l_hold_entity_code = 'B') then
7031: OE_DEBUG_PUB.Add('Bug 1946783 Credit Hold should be released from AR',1);
7032:
7033: fnd_message.set_name('ONT', 'OE_CC_AR_HOLD_NOT_RELEASED');
7034: OE_MSG_PUB.ADD;
7035: RAISE FND_API.G_EXC_ERROR;
7036: x_return_status := FND_API.G_RET_STS_ERROR;
7037: OE_MSG_PUB.Count_And_Get

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

7049: ,x_msg_count => x_msg_count
7050: ,x_msg_data => x_msg_data
7051: ) = 'N' THEN
7052: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(l_hold_id));
7053: fnd_message.set_name('ONT', 'ONT_HOLDS_SYSTEM_CHECK');
7054: fnd_message.set_token('ACTION', 'Release');
7055: OE_MSG_PUB.ADD;
7056: x_return_status := FND_API.G_RET_STS_ERROR;
7057: OE_MSG_PUB.Count_And_Get

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

7050: ,x_msg_data => x_msg_data
7051: ) = 'N' THEN
7052: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(l_hold_id));
7053: fnd_message.set_name('ONT', 'ONT_HOLDS_SYSTEM_CHECK');
7054: fnd_message.set_token('ACTION', 'Release');
7055: OE_MSG_PUB.ADD;
7056: x_return_status := FND_API.G_RET_STS_ERROR;
7057: OE_MSG_PUB.Count_And_Get
7058: ( p_count => x_msg_count

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

7070: ,x_msg_data => x_msg_data
7071: ) = 'N' THEN
7072: OE_DEBUG_PUB.Add('Not authorize to Release this Hold:'|| to_char(l_hold_id));
7073:
7074: fnd_message.set_name('ONT','ONT_RELEASE');
7075: l_msg_token := fnd_message.get;
7076:
7077: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
7078: fnd_message.set_token('ACTION', l_msg_token);

Line 7075: l_msg_token := fnd_message.get;

7071: ) = 'N' THEN
7072: OE_DEBUG_PUB.Add('Not authorize to Release this Hold:'|| to_char(l_hold_id));
7073:
7074: fnd_message.set_name('ONT','ONT_RELEASE');
7075: l_msg_token := fnd_message.get;
7076:
7077: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
7078: fnd_message.set_token('ACTION', l_msg_token);
7079:

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

7073:
7074: fnd_message.set_name('ONT','ONT_RELEASE');
7075: l_msg_token := fnd_message.get;
7076:
7077: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
7078: fnd_message.set_token('ACTION', l_msg_token);
7079:
7080: OE_MSG_PUB.ADD;
7081: RAISE FND_API.G_EXC_ERROR;

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

7074: fnd_message.set_name('ONT','ONT_RELEASE');
7075: l_msg_token := fnd_message.get;
7076:
7077: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
7078: fnd_message.set_token('ACTION', l_msg_token);
7079:
7080: OE_MSG_PUB.ADD;
7081: RAISE FND_API.G_EXC_ERROR;
7082: x_return_status := FND_API.G_RET_STS_ERROR;

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

7215: ,x_msg_count => x_msg_count
7216: ,x_msg_data => x_msg_data
7217: ) = 'N' THEN
7218: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(p_hold_id));
7219: fnd_message.set_name('ONT', 'ONT_HOLDS_SYSTEM_CHECK');
7220: OE_MSG_PUB.ADD;
7221: x_return_status := FND_API.G_RET_STS_ERROR;
7222: OE_MSG_PUB.Count_And_Get
7223: ( p_count => x_msg_count

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

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

Line 7241: l_msg_token := fnd_message.get;

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

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

7239: OE_DEBUG_PUB.Add('Not authorize to Release this Hold:'||to_char(p_hold_id));
7240: fnd_message.set_name('ONT','ONT_RELEASE');
7241: l_msg_token := fnd_message.get;
7242:
7243: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
7244: fnd_message.set_token('ACTION', l_msg_token);
7245:
7246: OE_MSG_PUB.ADD;
7247: -- RAISE FND_API.G_EXC_ERROR;

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

7240: fnd_message.set_name('ONT','ONT_RELEASE');
7241: l_msg_token := fnd_message.get;
7242:
7243: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
7244: fnd_message.set_token('ACTION', l_msg_token);
7245:
7246: OE_MSG_PUB.ADD;
7247: -- RAISE FND_API.G_EXC_ERROR;
7248: x_return_status := FND_API.G_RET_STS_ERROR;

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

7423: ,x_msg_count => x_msg_count
7424: ,x_msg_data => x_msg_data
7425: ) = 'N' THEN
7426: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(p_hold_id));
7427: fnd_message.set_name('ONT', 'ONT_HOLDS_SYSTEM_CHECK');
7428: OE_MSG_PUB.ADD;
7429: x_return_status := FND_API.G_RET_STS_ERROR;
7430: OE_MSG_PUB.Count_And_Get
7431: ( p_count => x_msg_count

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

7444: ,x_msg_count => x_msg_count
7445: ,x_msg_data => x_msg_data
7446: ) = 'N' THEN
7447: OE_DEBUG_PUB.Add('Not authorize to Release this Hold:'|| to_char(p_hold_id),1);
7448: fnd_message.set_name('ONT','ONT_RELEASE');
7449: l_msg_token := fnd_message.get;
7450:
7451: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
7452: fnd_message.set_token('ACTION', l_msg_token);

Line 7449: l_msg_token := fnd_message.get;

7445: ,x_msg_data => x_msg_data
7446: ) = 'N' THEN
7447: OE_DEBUG_PUB.Add('Not authorize to Release this Hold:'|| to_char(p_hold_id),1);
7448: fnd_message.set_name('ONT','ONT_RELEASE');
7449: l_msg_token := fnd_message.get;
7450:
7451: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
7452: fnd_message.set_token('ACTION', l_msg_token);
7453:

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

7447: OE_DEBUG_PUB.Add('Not authorize to Release this Hold:'|| to_char(p_hold_id),1);
7448: fnd_message.set_name('ONT','ONT_RELEASE');
7449: l_msg_token := fnd_message.get;
7450:
7451: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
7452: fnd_message.set_token('ACTION', l_msg_token);
7453:
7454: OE_MSG_PUB.ADD;
7455: -- RAISE FND_API.G_EXC_ERROR;

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

7448: fnd_message.set_name('ONT','ONT_RELEASE');
7449: l_msg_token := fnd_message.get;
7450:
7451: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
7452: fnd_message.set_token('ACTION', l_msg_token);
7453:
7454: OE_MSG_PUB.ADD;
7455: -- RAISE FND_API.G_EXC_ERROR;
7456: x_return_status := FND_API.G_RET_STS_ERROR;

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

7619:
7620: If l_hold_id = 1 AND (l_hold_entity_code ='C' OR l_hold_entity_code = 'B') then
7621: OE_DEBUG_PUB.Add('Bug 1946783 Credit Hold should be released from AR',1);
7622:
7623: fnd_message.set_name('ONT', 'OE_CC_AR_HOLD_NOT_RELEASED');
7624: OE_MSG_PUB.ADD;
7625: RAISE FND_API.G_EXC_ERROR;
7626: x_return_status := FND_API.G_RET_STS_ERROR;
7627: OE_MSG_PUB.Count_And_Get

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

7639: ,x_msg_count => x_msg_count
7640: ,x_msg_data => x_msg_data
7641: ) = 'N' THEN
7642: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(l_hold_id));
7643: fnd_message.set_name('ONT', 'ONT_HOLDS_SYSTEM_CHECK');
7644: fnd_message.set_token('ACTION', 'Release');
7645: OE_MSG_PUB.ADD;
7646: x_return_status := FND_API.G_RET_STS_ERROR;
7647: OE_MSG_PUB.Count_And_Get

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

7640: ,x_msg_data => x_msg_data
7641: ) = 'N' THEN
7642: OE_DEBUG_PUB.Add('Not authorize to Apply this Hold:'|| to_char(l_hold_id));
7643: fnd_message.set_name('ONT', 'ONT_HOLDS_SYSTEM_CHECK');
7644: fnd_message.set_token('ACTION', 'Release');
7645: OE_MSG_PUB.ADD;
7646: x_return_status := FND_API.G_RET_STS_ERROR;
7647: OE_MSG_PUB.Count_And_Get
7648: ( p_count => x_msg_count

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

7661: ,x_msg_data => x_msg_data
7662: ) = 'N' THEN
7663: OE_DEBUG_PUB.Add('Not authorize to Release this Hold:'|| to_char(l_hold_id));
7664:
7665: fnd_message.set_name('ONT','ONT_RELEASE');
7666: l_msg_token := fnd_message.get;
7667:
7668: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
7669: fnd_message.set_token('ACTION', l_msg_token);

Line 7666: l_msg_token := fnd_message.get;

7662: ) = 'N' THEN
7663: OE_DEBUG_PUB.Add('Not authorize to Release this Hold:'|| to_char(l_hold_id));
7664:
7665: fnd_message.set_name('ONT','ONT_RELEASE');
7666: l_msg_token := fnd_message.get;
7667:
7668: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
7669: fnd_message.set_token('ACTION', l_msg_token);
7670:

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

7664:
7665: fnd_message.set_name('ONT','ONT_RELEASE');
7666: l_msg_token := fnd_message.get;
7667:
7668: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
7669: fnd_message.set_token('ACTION', l_msg_token);
7670:
7671: OE_MSG_PUB.ADD;
7672: RAISE FND_API.G_EXC_ERROR;

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

7665: fnd_message.set_name('ONT','ONT_RELEASE');
7666: l_msg_token := fnd_message.get;
7667:
7668: fnd_message.set_name('ONT', 'OE_HOLDS_AUTHORIZATION_FAILED');
7669: fnd_message.set_token('ACTION', l_msg_token);
7670:
7671: OE_MSG_PUB.ADD;
7672: RAISE FND_API.G_EXC_ERROR;
7673: x_return_status := FND_API.G_RET_STS_ERROR;

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

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

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

8376: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
8377: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
8378: and lookup_code = p_activity_name;
8379:
8380: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
8381: fnd_message.set_token('WF_ACT', l_user_activity_name);
8382: OE_MSG_PUB.ADD;
8383: oe_debug_pub.add(' Hold Not applied for All requested records');
8384: RAISE FND_API.G_EXC_ERROR;

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

8377: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
8378: and lookup_code = p_activity_name;
8379:
8380: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
8381: fnd_message.set_token('WF_ACT', l_user_activity_name);
8382: OE_MSG_PUB.ADD;
8383: oe_debug_pub.add(' Hold Not applied for All requested records');
8384: RAISE FND_API.G_EXC_ERROR;
8385: ELSIF l_sql_rowcount > 0 THEN

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

8409: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
8410: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
8411: and lookup_code = p_activity_name;
8412:
8413: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
8414: fnd_message.set_token('WF_ACT', l_user_activity_name);
8415: OE_MSG_PUB.ADD;
8416: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
8417: END IF;

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

8410: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
8411: and lookup_code = p_activity_name;
8412:
8413: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
8414: fnd_message.set_token('WF_ACT', l_user_activity_name);
8415: OE_MSG_PUB.ADD;
8416: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
8417: END IF;
8418: END IF;

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

8698: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
8699: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
8700: and lookup_code = p_activity_name;
8701:
8702: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
8703: fnd_message.set_token('WF_ACT', l_user_activity_name);
8704: OE_MSG_PUB.ADD;
8705: oe_debug_pub.add(' Hold Not applied for All requested records');
8706: RAISE FND_API.G_EXC_ERROR;

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

8699: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
8700: and lookup_code = p_activity_name;
8701:
8702: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
8703: fnd_message.set_token('WF_ACT', l_user_activity_name);
8704: OE_MSG_PUB.ADD;
8705: oe_debug_pub.add(' Hold Not applied for All requested records');
8706: RAISE FND_API.G_EXC_ERROR;
8707: ELSIF l_sql_rowcount > 0 THEN

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

8733: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
8734: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
8735: and lookup_code = p_activity_name;
8736:
8737: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
8738: fnd_message.set_token('WF_ACT', l_user_activity_name);
8739: OE_MSG_PUB.ADD;
8740: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
8741: END IF;

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

8734: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
8735: and lookup_code = p_activity_name;
8736:
8737: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
8738: fnd_message.set_token('WF_ACT', l_user_activity_name);
8739: OE_MSG_PUB.ADD;
8740: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
8741: END IF;
8742: END IF;

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

8915: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
8916: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
8917: and lookup_code = p_activity_name;
8918:
8919: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
8920: fnd_message.set_token('WF_ACT', l_user_activity_name);
8921: OE_MSG_PUB.ADD;
8922: oe_debug_pub.add(' Hold Not applied for All requested records');
8923: RAISE FND_API.G_EXC_ERROR;

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

8916: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
8917: and lookup_code = p_activity_name;
8918:
8919: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
8920: fnd_message.set_token('WF_ACT', l_user_activity_name);
8921: OE_MSG_PUB.ADD;
8922: oe_debug_pub.add(' Hold Not applied for All requested records');
8923: RAISE FND_API.G_EXC_ERROR;
8924: ELSIF l_sql_rowcount > 0 THEN

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

8948: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
8949: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
8950: and lookup_code = p_activity_name;
8951:
8952: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
8953: fnd_message.set_token('WF_ACT', l_user_activity_name);
8954: OE_MSG_PUB.ADD;
8955: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
8956: END IF;

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

8949: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
8950: and lookup_code = p_activity_name;
8951:
8952: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
8953: fnd_message.set_token('WF_ACT', l_user_activity_name);
8954: OE_MSG_PUB.ADD;
8955: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
8956: END IF;
8957: END IF;

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

9128: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
9129: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
9130: and lookup_code = p_activity_name;
9131:
9132: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
9133: fnd_message.set_token('WF_ACT', l_user_activity_name);
9134: OE_MSG_PUB.ADD;
9135: oe_debug_pub.add(' Hold Not applied for All requested records');
9136: RAISE FND_API.G_EXC_ERROR;

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

9129: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
9130: and lookup_code = p_activity_name;
9131:
9132: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
9133: fnd_message.set_token('WF_ACT', l_user_activity_name);
9134: OE_MSG_PUB.ADD;
9135: oe_debug_pub.add(' Hold Not applied for All requested records');
9136: RAISE FND_API.G_EXC_ERROR;
9137: ELSIF l_sql_rowcount > 0 THEN

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

9160: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
9161: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
9162: and lookup_code = p_activity_name;
9163:
9164: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
9165: fnd_message.set_token('WF_ACT', l_user_activity_name);
9166: OE_MSG_PUB.ADD;
9167: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
9168: END IF;

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

9161: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
9162: and lookup_code = p_activity_name;
9163:
9164: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
9165: fnd_message.set_token('WF_ACT', l_user_activity_name);
9166: OE_MSG_PUB.ADD;
9167: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
9168: END IF;
9169: END IF;

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

9342: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
9343: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
9344: and lookup_code = p_activity_name;
9345:
9346: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
9347: fnd_message.set_token('WF_ACT', l_user_activity_name);
9348: OE_MSG_PUB.ADD;
9349: oe_debug_pub.add(' Hold Not applied for All requested records');
9350: RAISE FND_API.G_EXC_ERROR;

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

9343: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
9344: and lookup_code = p_activity_name;
9345:
9346: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
9347: fnd_message.set_token('WF_ACT', l_user_activity_name);
9348: OE_MSG_PUB.ADD;
9349: oe_debug_pub.add(' Hold Not applied for All requested records');
9350: RAISE FND_API.G_EXC_ERROR;
9351: ELSIF l_sql_rowcount > 0 THEN

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

9375: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
9376: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
9377: and lookup_code = p_activity_name;
9378:
9379: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
9380: fnd_message.set_token('WF_ACT', l_user_activity_name);
9381: OE_MSG_PUB.ADD;
9382: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
9383: END IF;

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

9376: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
9377: and lookup_code = p_activity_name;
9378:
9379: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
9380: fnd_message.set_token('WF_ACT', l_user_activity_name);
9381: OE_MSG_PUB.ADD;
9382: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
9383: END IF;
9384: END IF;

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

9556: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
9557: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
9558: and lookup_code = p_activity_name;
9559:
9560: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
9561: fnd_message.set_token('WF_ACT', l_user_activity_name);
9562: OE_MSG_PUB.ADD;
9563: oe_debug_pub.add(' Hold Not applied for All requested records');
9564: RAISE FND_API.G_EXC_ERROR;

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

9557: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
9558: and lookup_code = p_activity_name;
9559:
9560: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
9561: fnd_message.set_token('WF_ACT', l_user_activity_name);
9562: OE_MSG_PUB.ADD;
9563: oe_debug_pub.add(' Hold Not applied for All requested records');
9564: RAISE FND_API.G_EXC_ERROR;
9565: ELSIF l_sql_rowcount > 0 THEN

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

9589: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
9590: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
9591: and lookup_code = p_activity_name;
9592:
9593: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
9594: fnd_message.set_token('WF_ACT', l_user_activity_name);
9595: OE_MSG_PUB.ADD;
9596: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
9597: END IF;

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

9590: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
9591: and lookup_code = p_activity_name;
9592:
9593: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
9594: fnd_message.set_token('WF_ACT', l_user_activity_name);
9595: OE_MSG_PUB.ADD;
9596: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
9597: END IF;
9598: END IF;

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

9774: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
9775: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
9776: and lookup_code = p_activity_name;
9777:
9778: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
9779: fnd_message.set_token('WF_ACT', l_user_activity_name);
9780: OE_MSG_PUB.ADD;
9781: oe_debug_pub.add(' Hold Not applied for All requested records');
9782: RAISE FND_API.G_EXC_ERROR;

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

9775: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
9776: and lookup_code = p_activity_name;
9777:
9778: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
9779: fnd_message.set_token('WF_ACT', l_user_activity_name);
9780: OE_MSG_PUB.ADD;
9781: oe_debug_pub.add(' Hold Not applied for All requested records');
9782: RAISE FND_API.G_EXC_ERROR;
9783: ELSIF l_sql_rowcount > 0 THEN

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

9807: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
9808: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
9809: and lookup_code = p_activity_name;
9810:
9811: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
9812: fnd_message.set_token('WF_ACT', l_user_activity_name);
9813: OE_MSG_PUB.ADD;
9814: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
9815: END IF;

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

9808: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
9809: and lookup_code = p_activity_name;
9810:
9811: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
9812: fnd_message.set_token('WF_ACT', l_user_activity_name);
9813: OE_MSG_PUB.ADD;
9814: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
9815: END IF;
9816: END IF;

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

10079: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
10080: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
10081: and lookup_code = p_activity_name;
10082:
10083: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
10084: fnd_message.set_token('WF_ACT', l_user_activity_name);
10085: OE_MSG_PUB.ADD;
10086: oe_debug_pub.add(' Hold Not applied for All requested records');
10087: RAISE FND_API.G_EXC_ERROR;

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

10080: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
10081: and lookup_code = p_activity_name;
10082:
10083: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
10084: fnd_message.set_token('WF_ACT', l_user_activity_name);
10085: OE_MSG_PUB.ADD;
10086: oe_debug_pub.add(' Hold Not applied for All requested records');
10087: RAISE FND_API.G_EXC_ERROR;
10088: ELSIF l_sql_rowcount > 0 THEN

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

10112: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
10113: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
10114: and lookup_code = p_activity_name;
10115:
10116: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
10117: fnd_message.set_token('WF_ACT', l_user_activity_name);
10118: OE_MSG_PUB.ADD;
10119: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
10120: END IF;

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

10113: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
10114: and lookup_code = p_activity_name;
10115:
10116: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
10117: fnd_message.set_token('WF_ACT', l_user_activity_name);
10118: OE_MSG_PUB.ADD;
10119: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
10120: END IF;
10121: END IF;

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

10293: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
10294: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
10295: and lookup_code = p_activity_name;
10296:
10297: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
10298: fnd_message.set_token('WF_ACT', l_user_activity_name);
10299: OE_MSG_PUB.ADD;
10300: oe_debug_pub.add(' Hold Not applied for All requested records');
10301: RAISE FND_API.G_EXC_ERROR;

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

10294: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
10295: and lookup_code = p_activity_name;
10296:
10297: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
10298: fnd_message.set_token('WF_ACT', l_user_activity_name);
10299: OE_MSG_PUB.ADD;
10300: oe_debug_pub.add(' Hold Not applied for All requested records');
10301: RAISE FND_API.G_EXC_ERROR;
10302: ELSIF l_sql_rowcount > 0 THEN

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

10326: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
10327: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
10328: and lookup_code = p_activity_name;
10329:
10330: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
10331: fnd_message.set_token('WF_ACT', l_user_activity_name);
10332: OE_MSG_PUB.ADD;
10333: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
10334: END IF;

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

10327: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
10328: and lookup_code = p_activity_name;
10329:
10330: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
10331: fnd_message.set_token('WF_ACT', l_user_activity_name);
10332: OE_MSG_PUB.ADD;
10333: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
10334: END IF;
10335: END IF;

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

10510: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
10511: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
10512: and lookup_code = p_activity_name;
10513:
10514: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
10515: fnd_message.set_token('WF_ACT', l_user_activity_name);
10516: OE_MSG_PUB.ADD;
10517: oe_debug_pub.add(' Hold Not applied for All requested records');
10518: RAISE FND_API.G_EXC_ERROR;

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

10511: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
10512: and lookup_code = p_activity_name;
10513:
10514: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
10515: fnd_message.set_token('WF_ACT', l_user_activity_name);
10516: OE_MSG_PUB.ADD;
10517: oe_debug_pub.add(' Hold Not applied for All requested records');
10518: RAISE FND_API.G_EXC_ERROR;
10519: ELSIF l_sql_rowcount > 0 THEN

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

10543: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
10544: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
10545: and lookup_code = p_activity_name;
10546:
10547: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
10548: fnd_message.set_token('WF_ACT', l_user_activity_name);
10549: OE_MSG_PUB.ADD;
10550: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
10551: END IF;

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

10544: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
10545: and lookup_code = p_activity_name;
10546:
10547: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
10548: fnd_message.set_token('WF_ACT', l_user_activity_name);
10549: OE_MSG_PUB.ADD;
10550: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
10551: END IF;
10552: END IF;

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

10835: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
10836: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
10837: and lookup_code = p_activity_name;
10838:
10839: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
10840: fnd_message.set_token('WF_ACT', l_user_activity_name);
10841: OE_MSG_PUB.ADD;
10842: oe_debug_pub.add(' Hold Not applied for All requested records');
10843: RAISE FND_API.G_EXC_ERROR;

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

10836: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
10837: and lookup_code = p_activity_name;
10838:
10839: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
10840: fnd_message.set_token('WF_ACT', l_user_activity_name);
10841: OE_MSG_PUB.ADD;
10842: oe_debug_pub.add(' Hold Not applied for All requested records');
10843: RAISE FND_API.G_EXC_ERROR;
10844: ELSIF l_sql_rowcount > 0 THEN

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

10868: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
10869: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
10870: and lookup_code = p_activity_name;
10871:
10872: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
10873: fnd_message.set_token('WF_ACT', l_user_activity_name);
10874: OE_MSG_PUB.ADD;
10875: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
10876: END IF;

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

10869: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
10870: and lookup_code = p_activity_name;
10871:
10872: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
10873: fnd_message.set_token('WF_ACT', l_user_activity_name);
10874: OE_MSG_PUB.ADD;
10875: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
10876: END IF;
10877: END IF;

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

11049: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
11050: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
11051: and lookup_code = p_activity_name;
11052:
11053: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
11054: fnd_message.set_token('WF_ACT', l_user_activity_name);
11055: OE_MSG_PUB.ADD;
11056: oe_debug_pub.add(' Hold Not applied for All requested records');
11057: RAISE FND_API.G_EXC_ERROR;

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

11050: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
11051: and lookup_code = p_activity_name;
11052:
11053: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
11054: fnd_message.set_token('WF_ACT', l_user_activity_name);
11055: OE_MSG_PUB.ADD;
11056: oe_debug_pub.add(' Hold Not applied for All requested records');
11057: RAISE FND_API.G_EXC_ERROR;
11058: ELSIF l_sql_rowcount > 0 THEN

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

11082: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
11083: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
11084: and lookup_code = p_activity_name;
11085:
11086: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
11087: fnd_message.set_token('WF_ACT', l_user_activity_name);
11088: OE_MSG_PUB.ADD;
11089: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
11090: END IF;

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

11083: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
11084: and lookup_code = p_activity_name;
11085:
11086: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
11087: fnd_message.set_token('WF_ACT', l_user_activity_name);
11088: OE_MSG_PUB.ADD;
11089: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
11090: END IF;
11091: END IF;

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

11263: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
11264: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
11265: and lookup_code = p_activity_name;
11266:
11267: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
11268: fnd_message.set_token('WF_ACT', l_user_activity_name);
11269: OE_MSG_PUB.ADD;
11270: oe_debug_pub.add(' Hold Not applied for All requested records');
11271: RAISE FND_API.G_EXC_ERROR;

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

11264: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
11265: and lookup_code = p_activity_name;
11266:
11267: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
11268: fnd_message.set_token('WF_ACT', l_user_activity_name);
11269: OE_MSG_PUB.ADD;
11270: oe_debug_pub.add(' Hold Not applied for All requested records');
11271: RAISE FND_API.G_EXC_ERROR;
11272: ELSIF l_sql_rowcount > 0 THEN

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

11296: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
11297: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
11298: and lookup_code = p_activity_name;
11299:
11300: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
11301: fnd_message.set_token('WF_ACT', l_user_activity_name);
11302: OE_MSG_PUB.ADD;
11303: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
11304: END IF;

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

11297: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
11298: and lookup_code = p_activity_name;
11299:
11300: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
11301: fnd_message.set_token('WF_ACT', l_user_activity_name);
11302: OE_MSG_PUB.ADD;
11303: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
11304: END IF;
11305: END IF;

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

11474: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
11475: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
11476: and lookup_code = p_activity_name;
11477:
11478: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
11479: fnd_message.set_token('WF_ACT', l_user_activity_name);
11480: OE_MSG_PUB.ADD;
11481: oe_debug_pub.add(' Hold Not applied for All requested records');
11482: RAISE FND_API.G_EXC_ERROR;

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

11475: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
11476: and lookup_code = p_activity_name;
11477:
11478: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
11479: fnd_message.set_token('WF_ACT', l_user_activity_name);
11480: OE_MSG_PUB.ADD;
11481: oe_debug_pub.add(' Hold Not applied for All requested records');
11482: RAISE FND_API.G_EXC_ERROR;
11483: ELSIF l_sql_rowcount > 0 THEN

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

11506: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
11507: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
11508: and lookup_code = p_activity_name;
11509:
11510: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
11511: fnd_message.set_token('WF_ACT', l_user_activity_name);
11512: OE_MSG_PUB.ADD;
11513: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
11514: END IF;

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

11507: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
11508: and lookup_code = p_activity_name;
11509:
11510: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
11511: fnd_message.set_token('WF_ACT', l_user_activity_name);
11512: OE_MSG_PUB.ADD;
11513: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
11514: END IF;
11515: END IF;

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

11654: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
11655: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
11656: and lookup_code = p_activity_name;
11657:
11658: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
11659: fnd_message.set_token('WF_ACT', l_user_activity_name);
11660: OE_MSG_PUB.ADD;
11661: oe_debug_pub.add(' Hold Not applied for All requested records');
11662: RAISE FND_API.G_EXC_ERROR;

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

11655: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
11656: and lookup_code = p_activity_name;
11657:
11658: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
11659: fnd_message.set_token('WF_ACT', l_user_activity_name);
11660: OE_MSG_PUB.ADD;
11661: oe_debug_pub.add(' Hold Not applied for All requested records');
11662: RAISE FND_API.G_EXC_ERROR;
11663: ELSIF l_sql_rowcount > 0 THEN

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

11688: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
11689: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
11690: and lookup_code = p_activity_name;
11691:
11692: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
11693: fnd_message.set_token('WF_ACT', l_user_activity_name);
11694: OE_MSG_PUB.ADD;
11695: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
11696: END IF;

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

11689: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
11690: and lookup_code = p_activity_name;
11691:
11692: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
11693: fnd_message.set_token('WF_ACT', l_user_activity_name);
11694: OE_MSG_PUB.ADD;
11695: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
11696: END IF;
11697: END IF;

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

11847: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
11848: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
11849: and lookup_code = p_activity_name;
11850:
11851: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
11852: fnd_message.set_token('WF_ACT', l_user_activity_name);
11853: OE_MSG_PUB.ADD;
11854: oe_debug_pub.add(' Hold Not applied for All requested records');
11855: RAISE FND_API.G_EXC_ERROR;

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

11848: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
11849: and lookup_code = p_activity_name;
11850:
11851: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
11852: fnd_message.set_token('WF_ACT', l_user_activity_name);
11853: OE_MSG_PUB.ADD;
11854: oe_debug_pub.add(' Hold Not applied for All requested records');
11855: RAISE FND_API.G_EXC_ERROR;
11856: ELSIF l_sql_rowcount > 0 THEN

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

11877: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
11878: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
11879: and lookup_code = p_activity_name;
11880:
11881: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
11882: fnd_message.set_token('WF_ACT', l_user_activity_name);
11883: OE_MSG_PUB.ADD;
11884: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
11885: END IF;

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

11878: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
11879: and lookup_code = p_activity_name;
11880:
11881: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
11882: fnd_message.set_token('WF_ACT', l_user_activity_name);
11883: OE_MSG_PUB.ADD;
11884: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
11885: END IF;
11886: END IF;

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

12309: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
12310: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
12311: and lookup_code = p_activity_name;
12312:
12313: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
12314: fnd_message.set_token('WF_ACT', l_user_activity_name);
12315: OE_MSG_PUB.ADD;
12316: oe_debug_pub.add(' Hold Not applied for All requested records');
12317: RAISE FND_API.G_EXC_ERROR;

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

12310: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
12311: and lookup_code = p_activity_name;
12312:
12313: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
12314: fnd_message.set_token('WF_ACT', l_user_activity_name);
12315: OE_MSG_PUB.ADD;
12316: oe_debug_pub.add(' Hold Not applied for All requested records');
12317: RAISE FND_API.G_EXC_ERROR;
12318: ELSIF l_sql_rowcount > 0 THEN

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

12341: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
12342: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
12343: and lookup_code = p_activity_name;
12344:
12345: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
12346: fnd_message.set_token('WF_ACT', l_user_activity_name);
12347: OE_MSG_PUB.ADD;
12348: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
12349: END IF;

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

12342: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
12343: and lookup_code = p_activity_name;
12344:
12345: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
12346: fnd_message.set_token('WF_ACT', l_user_activity_name);
12347: OE_MSG_PUB.ADD;
12348: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
12349: END IF;
12350: END IF;

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

12521: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
12522: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
12523: and lookup_code = p_activity_name;
12524:
12525: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
12526: fnd_message.set_token('WF_ACT', l_user_activity_name);
12527: OE_MSG_PUB.ADD;
12528: oe_debug_pub.add(' Hold Not applied for All requested records');
12529: RAISE FND_API.G_EXC_ERROR;

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

12522: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
12523: and lookup_code = p_activity_name;
12524:
12525: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
12526: fnd_message.set_token('WF_ACT', l_user_activity_name);
12527: OE_MSG_PUB.ADD;
12528: oe_debug_pub.add(' Hold Not applied for All requested records');
12529: RAISE FND_API.G_EXC_ERROR;
12530: ELSIF l_sql_rowcount > 0 THEN

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

12553: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
12554: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
12555: and lookup_code = p_activity_name;
12556:
12557: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
12558: fnd_message.set_token('WF_ACT', l_user_activity_name);
12559: OE_MSG_PUB.ADD;
12560: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
12561: END IF;

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

12554: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
12555: and lookup_code = p_activity_name;
12556:
12557: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
12558: fnd_message.set_token('WF_ACT', l_user_activity_name);
12559: OE_MSG_PUB.ADD;
12560: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
12561: END IF;
12562: END IF;

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

12732: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
12733: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
12734: and lookup_code = p_activity_name;
12735:
12736: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
12737: fnd_message.set_token('WF_ACT', l_user_activity_name);
12738: OE_MSG_PUB.ADD;
12739: oe_debug_pub.add(' Hold Not applied for All requested records');
12740: RAISE FND_API.G_EXC_ERROR;

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

12733: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
12734: and lookup_code = p_activity_name;
12735:
12736: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
12737: fnd_message.set_token('WF_ACT', l_user_activity_name);
12738: OE_MSG_PUB.ADD;
12739: oe_debug_pub.add(' Hold Not applied for All requested records');
12740: RAISE FND_API.G_EXC_ERROR;
12741: ELSIF l_sql_rowcount > 0 THEN

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

12764: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
12765: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
12766: and lookup_code = p_activity_name;
12767:
12768: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
12769: fnd_message.set_token('WF_ACT', l_user_activity_name);
12770: OE_MSG_PUB.ADD;
12771: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
12772: END IF;

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

12765: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
12766: and lookup_code = p_activity_name;
12767:
12768: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
12769: fnd_message.set_token('WF_ACT', l_user_activity_name);
12770: OE_MSG_PUB.ADD;
12771: oe_debug_pub.add(' Hold Not applied for FEW of the requested records');
12772: END IF;
12773: END IF;

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

12944: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
12945: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
12946: and lookup_code = p_activity_name;
12947:
12948: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
12949: fnd_message.set_token('WF_ACT', l_user_activity_name);
12950: OE_MSG_PUB.ADD;
12951: RAISE FND_API.G_EXC_ERROR;
12952: ELSIF l_sql_rowcount > 0 THEN

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

12945: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
12946: and lookup_code = p_activity_name;
12947:
12948: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
12949: fnd_message.set_token('WF_ACT', l_user_activity_name);
12950: OE_MSG_PUB.ADD;
12951: RAISE FND_API.G_EXC_ERROR;
12952: ELSIF l_sql_rowcount > 0 THEN
12953: SELECT count(*)

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

12975: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
12976: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
12977: and lookup_code = p_activity_name;
12978:
12979: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
12980: fnd_message.set_token('WF_ACT', l_user_activity_name);
12981: OE_MSG_PUB.ADD;
12982:
12983: END IF;

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

12976: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
12977: and lookup_code = p_activity_name;
12978:
12979: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
12980: fnd_message.set_token('WF_ACT', l_user_activity_name);
12981: OE_MSG_PUB.ADD;
12982:
12983: END IF;
12984: END IF;