DBA Data[Home] [Help]

APPS.WMS_ZONES_PVT dependencies on FND_MSG_PUB

Line 2061: fnd_msg_pub.count_and_get(

2057:
2058: END IF;
2059:
2060: x_return_status := FND_API.G_RET_STS_SUCCESS;
2061: fnd_msg_pub.count_and_get(
2062: p_count => x_msg_count,
2063: p_data => x_msg_data
2064: );
2065:

Line 2071: fnd_msg_pub.add;

2067: WHEN NO_DATA_FOUND THEN
2068: x_return_status := fnd_api.g_ret_sts_error;
2069:
2070: fnd_message.set_name('INV','OE_LOCK_ROW_DELETED');
2071: fnd_msg_pub.add;
2072:
2073: fnd_msg_pub.count_and_get(
2074: p_count => x_msg_count,
2075: p_data => x_msg_data

Line 2073: fnd_msg_pub.count_and_get(

2069:
2070: fnd_message.set_name('INV','OE_LOCK_ROW_DELETED');
2071: fnd_msg_pub.add;
2072:
2073: fnd_msg_pub.count_and_get(
2074: p_count => x_msg_count,
2075: p_data => x_msg_data
2076: );
2077:

Line 2082: fnd_msg_pub.add;

2078: WHEN app_exceptions.record_lock_exception THEN
2079: x_return_status := fnd_api.g_ret_sts_error;
2080:
2081: fnd_message.set_name('INV','OE_LOCK_ROW_ALREADY_LOCKED');
2082: fnd_msg_pub.add;
2083:
2084: fnd_msg_pub.count_and_get(
2085: p_count => x_msg_count,
2086: p_data => x_msg_data

Line 2084: fnd_msg_pub.count_and_get(

2080:
2081: fnd_message.set_name('INV','OE_LOCK_ROW_ALREADY_LOCKED');
2082: fnd_msg_pub.add;
2083:
2084: fnd_msg_pub.count_and_get(
2085: p_count => x_msg_count,
2086: p_data => x_msg_data
2087: );
2088:

Line 2094: fnd_msg_pub.add;

2090: WHEN record_changed THEN
2091: x_return_status := fnd_api.g_ret_sts_error;
2092:
2093: fnd_message.set_name('INV','OE_LOCK_ROW_CHANGED');
2094: fnd_msg_pub.add;
2095:
2096: fnd_msg_pub.count_and_get(
2097: p_count => x_msg_count,
2098: p_data => x_msg_data

Line 2096: fnd_msg_pub.count_and_get(

2092:
2093: fnd_message.set_name('INV','OE_LOCK_ROW_CHANGED');
2094: fnd_msg_pub.add;
2095:
2096: fnd_msg_pub.count_and_get(
2097: p_count => x_msg_count,
2098: p_data => x_msg_data
2099: );
2100:

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

2104:
2105: x_msg_data := substrb(sqlerrm, 200);
2106: x_msg_count := 1;
2107:
2108: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2109: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
2110:
2111: END IF;
2112:

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

2105: x_msg_data := substrb(sqlerrm, 200);
2106: x_msg_count := 1;
2107:
2108: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2109: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
2110:
2111: END IF;
2112:
2113: END LOCK_ROW;

Line 2329: fnd_msg_pub.ADD;

2325: IF p_disable_date < SYSDATE THEN
2326:
2327: l_return_status := 'E';
2328: fnd_message.set_name('WMS','WMS_ZONE_DISABLE_INAVLID');
2329: fnd_msg_pub.ADD;
2330:
2331: END IF;
2332:
2333: l_progress_indicator := '20';

Line 2348: fnd_msg_pub.ADD;

2344: ELSE
2345:
2346: l_return_status := 'E';
2347: fnd_message.set_name('WMS','WMS_ZONE_ENABLED_INVALID');
2348: fnd_msg_pub.ADD;
2349:
2350: END IF;
2351:
2352: l_progress_indicator := '30';

Line 2360: fnd_msg_pub.ADD;

2356: **/
2357: IF LENGTH(p_description) > 240 THEN
2358:
2359: fnd_message.set_name('WMS','WMS_DESCRIP_TOO_LONG');
2360: fnd_msg_pub.ADD;
2361:
2362: IF l_return_status = 'S' THEN
2363: l_return_status := 'W';
2364: END IF;

Line 2376: fnd_msg_pub.ADD;

2372: **/
2373: IF LENGTH(p_zone_name) > 30 THEN
2374:
2375: fnd_message.set_name('WMS','WMS_ZONE_TOO_LONG');
2376: fnd_msg_pub.ADD;
2377:
2378: IF l_return_status = 'S' THEN
2379: l_return_status := 'W';
2380: END IF;

Line 2395: fnd_msg_pub.add;

2391: IF c_org_id%NOTFOUND THEN
2392:
2393: l_return_status := 'E';
2394: fnd_message.set_name('WMS','WMS_ORG_ID');
2395: fnd_msg_pub.add;
2396:
2397: END IF;
2398: CLOSE c_org_id;
2399:

Line 2415: fnd_msg_pub.ADD;

2411: ELSE
2412:
2413: l_return_status := 'E';
2414: fnd_message.set_name('WMS','WMS_ZONE_ID');
2415: fnd_msg_pub.ADD;
2416:
2417: END IF;
2418: CLOSE c_zone_id;
2419:

Line 2436: fnd_msg_pub.ADD;

2432:
2433: l_return_status := 'E';
2434: fnd_message.set_name('INV', 'INV_ALREADY_EXISTS');
2435: fnd_message.set_token('ENTITY', 'Zone', FALSE);
2436: fnd_msg_pub.ADD;
2437:
2438: END IF;
2439: CLOSE c_zone_name;
2440: