DBA Data[Home] [Help]

APPS.WMS_ZONES_PVT dependencies on FND_MSG_PUB

Line 2034: fnd_msg_pub.count_and_get(

2030:
2031: END IF;
2032:
2033: x_return_status := FND_API.G_RET_STS_SUCCESS;
2034: fnd_msg_pub.count_and_get(
2035: p_count => x_msg_count,
2036: p_data => x_msg_data
2037: );
2038:

Line 2044: fnd_msg_pub.add;

2040: WHEN NO_DATA_FOUND THEN
2041: x_return_status := fnd_api.g_ret_sts_error;
2042:
2043: fnd_message.set_name('INV','OE_LOCK_ROW_DELETED');
2044: fnd_msg_pub.add;
2045:
2046: fnd_msg_pub.count_and_get(
2047: p_count => x_msg_count,
2048: p_data => x_msg_data

Line 2046: fnd_msg_pub.count_and_get(

2042:
2043: fnd_message.set_name('INV','OE_LOCK_ROW_DELETED');
2044: fnd_msg_pub.add;
2045:
2046: fnd_msg_pub.count_and_get(
2047: p_count => x_msg_count,
2048: p_data => x_msg_data
2049: );
2050:

Line 2055: fnd_msg_pub.add;

2051: WHEN app_exceptions.record_lock_exception THEN
2052: x_return_status := fnd_api.g_ret_sts_error;
2053:
2054: fnd_message.set_name('INV','OE_LOCK_ROW_ALREADY_LOCKED');
2055: fnd_msg_pub.add;
2056:
2057: fnd_msg_pub.count_and_get(
2058: p_count => x_msg_count,
2059: p_data => x_msg_data

Line 2057: fnd_msg_pub.count_and_get(

2053:
2054: fnd_message.set_name('INV','OE_LOCK_ROW_ALREADY_LOCKED');
2055: fnd_msg_pub.add;
2056:
2057: fnd_msg_pub.count_and_get(
2058: p_count => x_msg_count,
2059: p_data => x_msg_data
2060: );
2061:

Line 2067: fnd_msg_pub.add;

2063: WHEN record_changed THEN
2064: x_return_status := fnd_api.g_ret_sts_error;
2065:
2066: fnd_message.set_name('INV','OE_LOCK_ROW_CHANGED');
2067: fnd_msg_pub.add;
2068:
2069: fnd_msg_pub.count_and_get(
2070: p_count => x_msg_count,
2071: p_data => x_msg_data

Line 2069: fnd_msg_pub.count_and_get(

2065:
2066: fnd_message.set_name('INV','OE_LOCK_ROW_CHANGED');
2067: fnd_msg_pub.add;
2068:
2069: fnd_msg_pub.count_and_get(
2070: p_count => x_msg_count,
2071: p_data => x_msg_data
2072: );
2073:

Line 2081: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2077:
2078: x_msg_data := substrb(sqlerrm, 200);
2079: x_msg_count := 1;
2080:
2081: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2082: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
2083:
2084: END IF;
2085:

Line 2082: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);

2078: x_msg_data := substrb(sqlerrm, 200);
2079: x_msg_count := 1;
2080:
2081: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2082: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
2083:
2084: END IF;
2085:
2086: END LOCK_ROW;

Line 2302: fnd_msg_pub.ADD;

2298: IF p_disable_date < SYSDATE THEN
2299:
2300: l_return_status := 'E';
2301: fnd_message.set_name('WMS','WMS_ZONE_DISABLE_INAVLID');
2302: fnd_msg_pub.ADD;
2303:
2304: END IF;
2305:
2306: l_progress_indicator := '20';

Line 2321: fnd_msg_pub.ADD;

2317: ELSE
2318:
2319: l_return_status := 'E';
2320: fnd_message.set_name('WMS','WMS_ZONE_ENABLED_INVALID');
2321: fnd_msg_pub.ADD;
2322:
2323: END IF;
2324:
2325: l_progress_indicator := '30';

Line 2333: fnd_msg_pub.ADD;

2329: **/
2330: IF LENGTH(p_description) > 240 THEN
2331:
2332: fnd_message.set_name('WMS','WMS_DESCRIP_TOO_LONG');
2333: fnd_msg_pub.ADD;
2334:
2335: IF l_return_status = 'S' THEN
2336: l_return_status := 'W';
2337: END IF;

Line 2349: fnd_msg_pub.ADD;

2345: **/
2346: IF LENGTH(p_zone_name) > 30 THEN
2347:
2348: fnd_message.set_name('WMS','WMS_ZONE_TOO_LONG');
2349: fnd_msg_pub.ADD;
2350:
2351: IF l_return_status = 'S' THEN
2352: l_return_status := 'W';
2353: END IF;

Line 2368: fnd_msg_pub.add;

2364: IF c_org_id%NOTFOUND THEN
2365:
2366: l_return_status := 'E';
2367: fnd_message.set_name('WMS','WMS_ORG_ID');
2368: fnd_msg_pub.add;
2369:
2370: END IF;
2371: CLOSE c_org_id;
2372:

Line 2388: fnd_msg_pub.ADD;

2384: ELSE
2385:
2386: l_return_status := 'E';
2387: fnd_message.set_name('WMS','WMS_ZONE_ID');
2388: fnd_msg_pub.ADD;
2389:
2390: END IF;
2391: CLOSE c_zone_id;
2392:

Line 2409: fnd_msg_pub.ADD;

2405:
2406: l_return_status := 'E';
2407: fnd_message.set_name('INV', 'INV_ALREADY_EXISTS');
2408: fnd_message.set_token('ENTITY', 'Zone', FALSE);
2409: fnd_msg_pub.ADD;
2410:
2411: END IF;
2412: CLOSE c_zone_name;
2413: