eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_RCV_INTEGRATION_APIS dependencies on FND_MSG_PUB

Line 492: fnd_msg_pub.initialize;

488: END IF;
489:
490: -- Initialize message list if p_init_msg_list is set to TRUE.
491: IF fnd_api.to_boolean(p_init_msg_lst) THEN
492: fnd_msg_pub.initialize;
493: END IF;
494:
495: --Initialize the return status
496: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1040: fnd_msg_pub.count_and_get (

1036: IF c_mln_attributes%ISOPEN THEN
1037: CLOSE c_mln_attributes;
1038: END IF;
1039: x_return_status := FND_API.G_RET_STS_ERROR;
1040: fnd_msg_pub.count_and_get (
1041: p_encoded => FND_API.G_FALSE
1042: , p_count => x_msg_count
1043: , p_data => x_msg_data );
1044: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1049: fnd_msg_pub.count_and_get (

1045: IF c_mln_attributes%ISOPEN THEN
1046: CLOSE c_mln_attributes;
1047: END IF;
1048: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1049: fnd_msg_pub.count_and_get (
1050: p_encoded => FND_API.G_FALSE
1051: , p_count => x_msg_count
1052: , p_data => x_msg_data );
1053: WHEN OTHERS THEN

Line 1058: fnd_msg_pub.count_and_get (

1054: IF c_mln_attributes%ISOPEN THEN
1055: CLOSE c_mln_attributes;
1056: END IF;
1057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1058: fnd_msg_pub.count_and_get (
1059: p_encoded => FND_API.G_FALSE
1060: , p_count => x_msg_count
1061: , p_data => x_msg_data );
1062: IF SQLCODE IS NOT NULL THEN

Line 1410: fnd_msg_pub.initialize;

1406: END IF;
1407:
1408: -- Initialize message list if p_init_msg_list is set to TRUE.
1409: IF fnd_api.to_boolean(p_init_msg_lst) THEN
1410: fnd_msg_pub.initialize;
1411: END IF;
1412:
1413: --Initialize the return status
1414: x_return_status := fnd_api.g_ret_sts_success;

Line 1869: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

1865: IF c_msn_attributes%ISOPEN THEN
1866: CLOSE c_msn_attributes;
1867: END IF;
1868: x_return_status := fnd_api.g_ret_sts_error;
1869: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1870: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1871: IF c_msn_attributes%ISOPEN THEN
1872: CLOSE c_msn_attributes;
1873: END IF;

Line 1875: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

1871: IF c_msn_attributes%ISOPEN THEN
1872: CLOSE c_msn_attributes;
1873: END IF;
1874: x_return_status := fnd_api.g_ret_sts_unexp_error;
1875: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1876: WHEN OTHERS THEN
1877: IF c_msn_attributes%ISOPEN THEN
1878: CLOSE c_msn_attributes;
1879: END IF;

Line 1881: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

1877: IF c_msn_attributes%ISOPEN THEN
1878: CLOSE c_msn_attributes;
1879: END IF;
1880: x_return_status := fnd_api.g_ret_sts_unexp_error;
1881: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1882:
1883: IF SQLCODE IS NOT NULL THEN
1884: inv_mobile_helper_functions.sql_error('INV_RCV_INTEGRATION_APIS.INSERT_MSNI', l_progress, SQLCODE);
1885: END IF;

Line 1948: fnd_msg_pub.initialize;

1944: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1945: BEGIN
1946: x_return_status := g_ret_sts_success;
1947:
1948: fnd_msg_pub.initialize;
1949:
1950: IF l_debug = 1 THEN
1951: print_debug('validate_lot_number: Entered with following parameters:', 9);
1952: print_debug('validate_lot_number: lot_number: ' || p_lot_number, 9);

Line 2020: fnd_msg_pub.ADD;

2016: --then raise an error indicating invalid lot number
2017: IF (p_validation_mode = INV_RCV_INTEGRATION_APIS.G_EXISTS_ONLY AND
2018: l_lot_exists = 'N') THEN
2019: fnd_message.set_name('INV', 'INV_INVALID_LOT');
2020: fnd_msg_pub.ADD;
2021: x_return_status := FND_API.g_ret_sts_error;
2022: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2023: print_debug('err: ' || x_msg_data, 9);
2024: RETURN FALSE;

Line 2022: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

2018: l_lot_exists = 'N') THEN
2019: fnd_message.set_name('INV', 'INV_INVALID_LOT');
2020: fnd_msg_pub.ADD;
2021: x_return_status := FND_API.g_ret_sts_error;
2022: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2023: print_debug('err: ' || x_msg_data, 9);
2024: RETURN FALSE;
2025: END IF;
2026:

Line 2041: fnd_msg_pub.add;

2037:
2038: --If the lot is not unique then raise an error
2039: IF NOT l_unique_lot THEN
2040: fnd_message.set_name('INV', 'INV_LOT_UNIQUE_FAIL');
2041: fnd_msg_pub.add;
2042: x_return_status := FND_API.g_ret_sts_error;
2043: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2044: RETURN FALSE;
2045: END IF;

Line 2043: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

2039: IF NOT l_unique_lot THEN
2040: fnd_message.set_name('INV', 'INV_LOT_UNIQUE_FAIL');
2041: fnd_msg_pub.add;
2042: x_return_status := FND_API.g_ret_sts_error;
2043: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2044: RETURN FALSE;
2045: END IF;
2046:
2047: --Validate the expiration date based on shelf life code

Line 2060: fnd_msg_pub.ADD;

2056: EXCEPTION
2057: WHEN NO_DATA_FOUND THEN
2058: fnd_message.set_name('INV', 'INV_SHELF_LIFE_ERROR');
2059: fnd_message.set_token('INV', 'ITEM');
2060: fnd_msg_pub.ADD;
2061: IF l_debug = 1 THEN
2062: print_debug('validate_lot_number: Unable to fetch shelf life code for the inventory item passed', 9);
2063: END IF;
2064: x_return_status := FND_API.g_ret_sts_error;

Line 2065: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

2061: IF l_debug = 1 THEN
2062: print_debug('validate_lot_number: Unable to fetch shelf life code for the inventory item passed', 9);
2063: END IF;
2064: x_return_status := FND_API.g_ret_sts_error;
2065: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2066: RETURN FALSE;
2067: END;
2068:
2069: IF l_debug = 1 THEN

Line 2084: fnd_msg_pub.ADD;

2080: FROM DUAL;
2081:
2082: IF TRUNC(l_expiration_date) <> trunc(p_expiration_date) THEN
2083: fnd_message.set_name('INV', 'INV_EXP_DATE_NOT_CONSIDER');
2084: fnd_msg_pub.ADD;
2085: IF l_debug = 1 THEN
2086: print_debug('validate_lot_number: Expiration will not be considered for shelf_life code of type ITEM_SHELF_LIFE_DAYS', 9);
2087: END IF;
2088: x_return_status := FND_API.g_ret_sts_error;

Line 2089: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

2085: IF l_debug = 1 THEN
2086: print_debug('validate_lot_number: Expiration will not be considered for shelf_life code of type ITEM_SHELF_LIFE_DAYS', 9);
2087: END IF;
2088: x_return_status := FND_API.g_ret_sts_error;
2089: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2090: RETURN FALSE;
2091: END IF;
2092: ELSIF l_shelf_life_code = user_defined_exp_date THEN
2093: IF l_debug = 1 THEN

Line 2098: fnd_msg_pub.ADD;

2094: print_debug('validate_lot_number: Shelf_life code is of type USER_DEFINED_EXP_DATE', 9);
2095: END IF;
2096: IF p_expiration_date IS NULL THEN
2097: fnd_message.set_name('INV', 'INV_LOT_EXPREQD');
2098: fnd_msg_pub.ADD;
2099: IF l_debug = 1 THEN
2100: print_debug('validate_lot_number: Lot expiration date is required ', 9);
2101: END IF;
2102: x_return_status := FND_API.g_ret_sts_error;

Line 2103: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

2099: IF l_debug = 1 THEN
2100: print_debug('validate_lot_number: Lot expiration date is required ', 9);
2101: END IF;
2102: x_return_status := FND_API.g_ret_sts_error;
2103: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2104: RETURN FALSE;
2105: ELSE
2106: l_expiration_date := p_expiration_date;
2107: END IF;

Line 2168: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

2164: IF (l_debug = 1) THEN
2165: print_debug('validate_lot_number: Error in creating the lot number', 9);
2166: END IF;
2167: x_return_status := FND_API.g_ret_sts_error;
2168: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2169: RETURN FALSE;
2170: END IF;
2171: END IF; --END IF create the lot number
2172: --This API should be getting called only for a ship transaction from iSP.

Line 2175: fnd_msg_pub.add;

2171: END IF; --END IF create the lot number
2172: --This API should be getting called only for a ship transaction from iSP.
2173: ELSE
2174: fnd_message.set_name('INV','INV_NOT_IMPLEMENTED');
2175: fnd_msg_pub.add;
2176: x_return_status := FND_API.g_ret_sts_error;
2177: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2178: RETURN FALSE;
2179: END IF; --END IF Check the transaction type

Line 2177: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

2173: ELSE
2174: fnd_message.set_name('INV','INV_NOT_IMPLEMENTED');
2175: fnd_msg_pub.add;
2176: x_return_status := FND_API.g_ret_sts_error;
2177: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2178: RETURN FALSE;
2179: END IF; --END IF Check the transaction type
2180:
2181: --All the validations have passed successfully, then

Line 2190: fnd_msg_pub.count_and_get(

2186: IF (l_debug = 1) THEN
2187: print_debug('validate_lot_number: Exception occurred in validate_lot_number', 3);
2188: END IF;
2189: x_return_status := FND_API.g_ret_sts_error;
2190: fnd_msg_pub.count_and_get(
2191: p_encoded => fnd_api.g_false
2192: , p_count => x_msg_count
2193: , p_data => x_msg_data);
2194: IF SQLCODE IS NOT NULL THEN

Line 2235: fnd_msg_pub.initialize;

2231: l_return NUMBER;
2232: BEGIN
2233: x_return_status := g_ret_sts_success;
2234:
2235: fnd_msg_pub.initialize;
2236:
2237:
2238: IF l_debug = 1 THEN
2239: print_debug('validate_serial_range: Entered with following parameters:', 9);

Line 2259: fnd_msg_pub.add;

2255: IF (l_debug = 1) THEN
2256: print_debug('validate_serial_range: From Serial Number cannot be NULL', 9);
2257: END IF;
2258: fnd_message.set_name('INV', 'INV_INLTIS_FROMSER');
2259: fnd_msg_pub.add;
2260: x_return_status := FND_API.g_ret_sts_error;
2261: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2262: RETURN FALSE;
2263: END IF;

Line 2261: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

2257: END IF;
2258: fnd_message.set_name('INV', 'INV_INLTIS_FROMSER');
2259: fnd_msg_pub.add;
2260: x_return_status := FND_API.g_ret_sts_error;
2261: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2262: RETURN FALSE;
2263: END IF;
2264:
2265: --If to serial number and quantity both are NULL then raise an error

Line 2271: fnd_msg_pub.add;

2267: IF (l_debug = 1) THEN
2268: print_debug('validate_serial_range: To Serial and quantity both cannot be NULL', 9);
2269: END IF;
2270: fnd_message.set_name('INV', 'INV_INLTIS_RANGE');
2271: fnd_msg_pub.add;
2272: x_return_status := FND_API.g_ret_sts_error;
2273: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2274: RETURN FALSE;
2275: END IF;

Line 2273: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

2269: END IF;
2270: fnd_message.set_name('INV', 'INV_INLTIS_RANGE');
2271: fnd_msg_pub.add;
2272: x_return_status := FND_API.g_ret_sts_error;
2273: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2274: RETURN FALSE;
2275: END IF;
2276:
2277: --If to serial number is passed, get the difference between from and to serials

Line 2289: fnd_msg_pub.add;

2285: print_debug('validate_serial_range: Length of from and to serials do not match', 9);
2286: END IF;
2287: -- Bug Fix 4375959
2288: -- fnd_message.set_name('INV', 'INV_INLTIS_RANGE');
2289: fnd_msg_pub.add;
2290: x_return_status := FND_API.g_ret_sts_error;
2291: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2292: RETURN FALSE;
2293: END IF; --End If serial difference is < 0

Line 2291: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

2287: -- Bug Fix 4375959
2288: -- fnd_message.set_name('INV', 'INV_INLTIS_RANGE');
2289: fnd_msg_pub.add;
2290: x_return_status := FND_API.g_ret_sts_error;
2291: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2292: RETURN FALSE;
2293: END IF; --End If serial difference is < 0
2294:
2295: --If quantity is > 1 and the serial difference does not match the quantity

Line 2305: fnd_msg_pub.add;

2301: IF (l_debug = 1) THEN
2302: print_debug('validate_serial_range: Serial quantity does not match transaction quantity', 9);
2303: END IF;
2304: fnd_message.set_name('INV', 'INV_SERQTY_NOTMATCH');
2305: fnd_msg_pub.add;
2306: x_return_status := FND_API.g_ret_sts_error;
2307: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2308: RETURN FALSE;
2309: END IF;

Line 2307: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

2303: END IF;
2304: fnd_message.set_name('INV', 'INV_SERQTY_NOTMATCH');
2305: fnd_msg_pub.add;
2306: x_return_status := FND_API.g_ret_sts_error;
2307: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2308: RETURN FALSE;
2309: END IF;
2310: END IF; --END IF p_to_serial_number is NOT NULL
2311:

Line 2321: fnd_msg_pub.add;

2317: IF (l_debug = 1) THEN
2318: print_debug('validate_serial_range: To serial number must be specified', 9);
2319: END IF;
2320: fnd_message.set_name('INV', 'INV_SERIAL_NOT_ENTERED');
2321: fnd_msg_pub.add;
2322: x_return_status := FND_API.g_ret_sts_error;
2323: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2324: RETURN FALSE;
2325: END IF; --END IF p_to_serial_number IS NULL

Line 2323: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

2319: END IF;
2320: fnd_message.set_name('INV', 'INV_SERIAL_NOT_ENTERED');
2321: fnd_msg_pub.add;
2322: x_return_status := FND_API.g_ret_sts_error;
2323: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2324: RETURN FALSE;
2325: END IF; --END IF p_to_serial_number IS NULL
2326:
2327: --Now check for the existence of all the serials in the range

Line 2360: fnd_msg_pub.add;

2356: print_debug('validate_serial_number: could not find the serial number: ' || l_cur_serial_number, 9);
2357: END IF;
2358: fnd_message.set_name('INV', 'INV_SER_NOTEXIST');
2359: fnd_message.set_token('TOKEN', l_cur_serial_number);
2360: fnd_msg_pub.add;
2361: x_return_status := FND_API.g_ret_sts_error;
2362: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2363: RETURN FALSE;
2364: END;

Line 2362: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

2358: fnd_message.set_name('INV', 'INV_SER_NOTEXIST');
2359: fnd_message.set_token('TOKEN', l_cur_serial_number);
2360: fnd_msg_pub.add;
2361: x_return_status := FND_API.g_ret_sts_error;
2362: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2363: RETURN FALSE;
2364: END;
2365: END LOOP; --END For each serial in the range
2366: END IF; --END IF g_exists_only

Line 2392: fnd_msg_pub.ADD;

2388: IF (l_debug = 1) THEN
2389: print_debug('validate_serial_range: Error returned by validate_serials', 9);
2390: END IF;
2391: fnd_message.set_name('INV', 'INVALID_SERIAL_NUMBER');
2392: fnd_msg_pub.ADD;
2393: x_return_status := FND_API.g_ret_sts_error;
2394: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2395: RETURN FALSE;
2396: END IF;

Line 2394: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

2390: END IF;
2391: fnd_message.set_name('INV', 'INVALID_SERIAL_NUMBER');
2392: fnd_msg_pub.ADD;
2393: x_return_status := FND_API.g_ret_sts_error;
2394: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2395: RETURN FALSE;
2396: END IF;
2397: END IF; --END IF g_exists_or_create
2398:

Line 2405: fnd_msg_pub.add;

2401:
2402: --This API should be getting called only for a ship transaction from iSP.
2403: ELSE
2404: fnd_message.set_name('INV','INV_NOT_IMPLEMENTED');
2405: fnd_msg_pub.add;
2406: x_return_status := FND_API.g_ret_sts_error;
2407: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2408: RETURN FALSE;
2409: END IF; --END IF Check the transaction type

Line 2407: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

2403: ELSE
2404: fnd_message.set_name('INV','INV_NOT_IMPLEMENTED');
2405: fnd_msg_pub.add;
2406: x_return_status := FND_API.g_ret_sts_error;
2407: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2408: RETURN FALSE;
2409: END IF; --END IF Check the transaction type
2410:
2411: EXCEPTION

Line 2417: fnd_msg_pub.count_and_get(

2413: IF (l_debug = 1) THEN
2414: print_debug('validate_serial_range: Exception occurred in validate_serial_range', 3);
2415: END IF;
2416: x_return_status := FND_API.g_ret_sts_error;
2417: fnd_msg_pub.count_and_get(
2418: p_encoded => fnd_api.g_false
2419: , p_count => x_msg_count
2420: , p_data => x_msg_data);
2421: IF SQLCODE IS NOT NULL THEN

Line 2472: fnd_msg_pub.ADD;

2468: /*end , INVCONV*/
2469:
2470: x_msg_data := x_msg_data||':'||fnd_message.get_string('INV','INV_LOT_SERIAL_VALIDATION_FAIL');
2471: fnd_message.set_name('INV','INV_LOT_SERIAL_VALIDATION_FAIL');
2472: fnd_msg_pub.ADD;
2473: RETURN FALSE;
2474: END IF;
2475:
2476: RETURN TRUE;

Line 2502: fnd_msg_pub.add;

2498: x_return_status := g_ret_sts_success;
2499:
2500: x_return_status := g_ret_sts_error;
2501: fnd_message.set_name('INV','INV_NOT_IMPLEMENTED');
2502: fnd_msg_pub.add;
2503: fnd_msg_pub.count_and_get
2504: ( p_count => x_msg_count
2505: , p_data => x_msg_data
2506: );

Line 2503: fnd_msg_pub.count_and_get

2499:
2500: x_return_status := g_ret_sts_error;
2501: fnd_message.set_name('INV','INV_NOT_IMPLEMENTED');
2502: fnd_msg_pub.add;
2503: fnd_msg_pub.count_and_get
2504: ( p_count => x_msg_count
2505: , p_data => x_msg_data
2506: );
2507: RETURN NULL;

Line 2530: fnd_msg_pub.add;

2526: x_return_status := g_ret_sts_success;
2527:
2528: x_return_status := g_ret_sts_error;
2529: fnd_message.set_name('INV','INV_NOT_IMPLEMENTED');
2530: fnd_msg_pub.add;
2531: fnd_msg_pub.count_and_get
2532: ( p_count => x_msg_count
2533: , p_data => x_msg_data
2534: );

Line 2531: fnd_msg_pub.count_and_get

2527:
2528: x_return_status := g_ret_sts_error;
2529: fnd_message.set_name('INV','INV_NOT_IMPLEMENTED');
2530: fnd_msg_pub.add;
2531: fnd_msg_pub.count_and_get
2532: ( p_count => x_msg_count
2533: , p_data => x_msg_data
2534: );
2535: END generate_serial_numbers;

Line 2556: fnd_msg_pub.initialize;

2552: l_lpn_id NUMBER;
2553: BEGIN
2554: x_return_status := g_ret_sts_success;
2555:
2556: fnd_msg_pub.initialize;
2557:
2558: IF (p_validation_mode = g_exists_only OR p_validation_mode = g_exists_or_create) THEN
2559: BEGIN
2560: select 1, lpn_id

Line 2580: fnd_msg_pub.ADD;

2576: print_debug( 'This is an invalid lpn => ' || ' lpn = '||p_lpn ||' lpn_id= '||p_lpn_id,1 );
2577: END IF;
2578: x_return_status := g_ret_sts_error;
2579: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN');
2580: fnd_msg_pub.ADD;
2581: fnd_msg_pub.count_and_get
2582: ( p_count => x_msg_count
2583: , p_data => x_msg_data
2584: );

Line 2581: fnd_msg_pub.count_and_get

2577: END IF;
2578: x_return_status := g_ret_sts_error;
2579: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN');
2580: fnd_msg_pub.ADD;
2581: fnd_msg_pub.count_and_get
2582: ( p_count => x_msg_count
2583: , p_data => x_msg_data
2584: );
2585: RETURN FALSE;

Line 2607: fnd_msg_pub.ADD;

2603: IF (l_debug = 1) THEN
2604: print_debug( 'Error creating lpn => '||'lpn = '||p_lpn ||'lpn_id= '||p_lpn_id,1 );
2605: END IF;
2606: fnd_message.set_name('WMS', 'WMS_LPN_NOTGEN');
2607: fnd_msg_pub.ADD;
2608: fnd_msg_pub.count_and_get
2609: ( p_count => x_msg_count
2610: , p_data => x_msg_data
2611: );

Line 2608: fnd_msg_pub.count_and_get

2604: print_debug( 'Error creating lpn => '||'lpn = '||p_lpn ||'lpn_id= '||p_lpn_id,1 );
2605: END IF;
2606: fnd_message.set_name('WMS', 'WMS_LPN_NOTGEN');
2607: fnd_msg_pub.ADD;
2608: fnd_msg_pub.count_and_get
2609: ( p_count => x_msg_count
2610: , p_data => x_msg_data
2611: );
2612: RETURN FALSE;

Line 2624: fnd_msg_pub.ADD;

2620: print_debug( 'This is an invalid lpn => ' || ' lpn = '||p_lpn ||' lpn_id= '||p_lpn_id,1 );
2621: END IF;
2622: x_return_status := g_ret_sts_error;
2623: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN');
2624: fnd_msg_pub.ADD;
2625: fnd_msg_pub.count_and_get
2626: ( p_count => x_msg_count
2627: , p_data => x_msg_data
2628: );

Line 2625: fnd_msg_pub.count_and_get

2621: END IF;
2622: x_return_status := g_ret_sts_error;
2623: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN');
2624: fnd_msg_pub.ADD;
2625: fnd_msg_pub.count_and_get
2626: ( p_count => x_msg_count
2627: , p_data => x_msg_data
2628: );
2629: RETURN FALSE;

Line 2634: fnd_msg_pub.add;

2630: END;
2631: ELSE
2632: x_return_status := g_ret_sts_error;
2633: fnd_message.set_name('INV','INV_NOT_IMPLEMENTED');
2634: fnd_msg_pub.add;
2635: fnd_msg_pub.count_and_get
2636: ( p_count => x_msg_count
2637: , p_data => x_msg_data
2638: );

Line 2635: fnd_msg_pub.count_and_get

2631: ELSE
2632: x_return_status := g_ret_sts_error;
2633: fnd_message.set_name('INV','INV_NOT_IMPLEMENTED');
2634: fnd_msg_pub.add;
2635: fnd_msg_pub.count_and_get
2636: ( p_count => x_msg_count
2637: , p_data => x_msg_data
2638: );
2639: RETURN FALSE;

Line 2705: fnd_msg_pub.add;

2701: -- error out. This API should not be called for a OPM transaction.
2702: IF gml_process_flags.check_process_orgn(l_org_id) = 1 THEN
2703: x_return_status := g_ret_sts_error;
2704: fnd_message.set_name('INV','INV_NOT_IMPLEMENTED');
2705: fnd_msg_pub.add;
2706: fnd_msg_pub.count_and_get
2707: ( p_count => x_msg_count
2708: , p_data => x_msg_data
2709: );

Line 2706: fnd_msg_pub.count_and_get

2702: IF gml_process_flags.check_process_orgn(l_org_id) = 1 THEN
2703: x_return_status := g_ret_sts_error;
2704: fnd_message.set_name('INV','INV_NOT_IMPLEMENTED');
2705: fnd_msg_pub.add;
2706: fnd_msg_pub.count_and_get
2707: ( p_count => x_msg_count
2708: , p_data => x_msg_data
2709: );
2710: RETURN FALSE;

Line 2732: fnd_msg_pub.initialize;

2728: l_progress := '50';
2729:
2730: -- Initialize message list if p_init_msg_list is set to TRUE.
2731: IF fnd_api.to_boolean(p_init_msg_lst) THEN
2732: fnd_msg_pub.initialize;
2733: END IF;
2734:
2735: l_progress := '60';
2736:

Line 2753: fnd_msg_pub.ADD;

2749: IF (l_debug = 1) THEN
2750: print_debug('VALIDATE_LPN_INFO: x_msg_data: '||x_msg_data,1);
2751: END IF;
2752: fnd_message.set_name('INV','INV_LPN_VALIDATION_FAILED');
2753: fnd_msg_pub.ADD;
2754: RETURN FALSE;
2755: END IF;
2756:
2757: l_progress := '80';

Line 2789: fnd_msg_pub.add;

2785: x_return_status := g_ret_sts_success;
2786:
2787: x_return_status := g_ret_sts_error;
2788: fnd_message.set_name('INV','INV_NOT_IMPLEMENTED');
2789: fnd_msg_pub.add;
2790: fnd_msg_pub.count_and_get
2791: ( p_count => x_msg_count
2792: , p_data => x_msg_data
2793: );

Line 2790: fnd_msg_pub.count_and_get

2786:
2787: x_return_status := g_ret_sts_error;
2788: fnd_message.set_name('INV','INV_NOT_IMPLEMENTED');
2789: fnd_msg_pub.add;
2790: fnd_msg_pub.count_and_get
2791: ( p_count => x_msg_count
2792: , p_data => x_msg_data
2793: );
2794: END generate_lpn;

Line 2828: fnd_msg_pub.add;

2824: OR transfer_license_plate_number is not null)
2825: );
2826: x_return_status := g_ret_sts_error;
2827: fnd_message.set_name('INV','INV_NOT_IMPLEMENTED');
2828: fnd_msg_pub.add;
2829: fnd_msg_pub.count_and_get
2830: ( p_count => x_msg_count
2831: , p_data => x_msg_data
2832: );

Line 2829: fnd_msg_pub.count_and_get

2825: );
2826: x_return_status := g_ret_sts_error;
2827: fnd_message.set_name('INV','INV_NOT_IMPLEMENTED');
2828: fnd_msg_pub.add;
2829: fnd_msg_pub.count_and_get
2830: ( p_count => x_msg_count
2831: , p_data => x_msg_data
2832: );
2833: EXCEPTION

Line 2839: fnd_msg_pub.add;

2835: x_return_status := g_ret_sts_success;
2836: when OTHERS then
2837: x_return_status := g_ret_sts_error;
2838: fnd_message.set_name('INV','INV_NOT_IMPLEMENTED');
2839: fnd_msg_pub.add;
2840: fnd_msg_pub.count_and_get
2841: ( p_count => x_msg_count
2842: , p_data => x_msg_data
2843: );

Line 2840: fnd_msg_pub.count_and_get

2836: when OTHERS then
2837: x_return_status := g_ret_sts_error;
2838: fnd_message.set_name('INV','INV_NOT_IMPLEMENTED');
2839: fnd_msg_pub.add;
2840: fnd_msg_pub.count_and_get
2841: ( p_count => x_msg_count
2842: , p_data => x_msg_data
2843: );
2844: END;

Line 3007: fnd_msg_pub.ADD;

3003: print_debug('VALIDATE_SUB_LOC 60: Invalid Subinventory Type for the transaction:' || l_sub_type || ':' || l_trx_type, 1);
3004: END IF;
3005:
3006: fnd_message.set_name('INV', 'INV_INVALID_SUBINV');
3007: fnd_msg_pub.ADD;
3008: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3009: RETURN;
3010: END IF; --IF (l_sub_type = 2
3011:

Line 3008: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

3004: END IF;
3005:
3006: fnd_message.set_name('INV', 'INV_INVALID_SUBINV');
3007: fnd_msg_pub.ADD;
3008: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3009: RETURN;
3010: END IF; --IF (l_sub_type = 2
3011:
3012: IF (l_lpn_cont_flag = 2

Line 3024: fnd_msg_pub.ADD;

3020: print_debug('VALIDATE_SUB_LOC 70: Invalid LPN Controlled Flag for the transaction:' || l_lpn_cont_flag || ':' || l_lpn_id || ':' || l_lpn_num, 1);
3021: END IF;
3022:
3023: fnd_message.set_name('INV', 'INV_INVALID_SUBINV');
3024: fnd_msg_pub.ADD;
3025: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3026: RETURN;
3027: END IF; --IF (l_lpn_cont_flag = 2
3028: END IF; --IF l_sub IS NOT NULL THEN

Line 3025: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

3021: END IF;
3022:
3023: fnd_message.set_name('INV', 'INV_INVALID_SUBINV');
3024: fnd_msg_pub.ADD;
3025: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3026: RETURN;
3027: END IF; --IF (l_lpn_cont_flag = 2
3028: END IF; --IF l_sub IS NOT NULL THEN
3029:

Line 3053: fnd_msg_pub.ADD;

3049: IF (l_debug = 1) THEN
3050: print_debug('VALIDATE_SUB_LOC 80: Invalid Locator Type for the transaction:' || l_loc_type || ':' || l_trx_type, 1);
3051: END IF;
3052: fnd_message.set_name('INV', 'INV_INT_LOCCODE');
3053: fnd_msg_pub.ADD;
3054: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3055: RETURN;
3056: END IF;
3057: END IF; --IF l_locator_id IS NOT NULL THEN

Line 3054: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

3050: print_debug('VALIDATE_SUB_LOC 80: Invalid Locator Type for the transaction:' || l_loc_type || ':' || l_trx_type, 1);
3051: END IF;
3052: fnd_message.set_name('INV', 'INV_INT_LOCCODE');
3053: fnd_msg_pub.ADD;
3054: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3055: RETURN;
3056: END IF;
3057: END IF; --IF l_locator_id IS NOT NULL THEN
3058:

Line 3088: fnd_msg_pub.ADD;

3084: IF (l_debug = 1) THEN
3085: print_debug('VALIDATE_SUB_LOC 90: Invalid Location for the transaction:' || l_location_id || ':' || l_trx_type, 1);
3086: END IF;
3087: fnd_message.set_name('INV', 'INV_INVALID_LOCATION');
3088: fnd_msg_pub.ADD;
3089: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3090: RETURN;
3091: EXCEPTION
3092: WHEN no_data_found THEN

Line 3089: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

3085: print_debug('VALIDATE_SUB_LOC 90: Invalid Location for the transaction:' || l_location_id || ':' || l_trx_type, 1);
3086: END IF;
3087: fnd_message.set_name('INV', 'INV_INVALID_LOCATION');
3088: fnd_msg_pub.ADD;
3089: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3090: RETURN;
3091: EXCEPTION
3092: WHEN no_data_found THEN
3093: IF (l_debug = 1) THEN

Line 3102: fnd_msg_pub.ADD;

3098: IF (l_debug = 1) THEN
3099: print_debug('VALIDATE_SUB_LOC 110: Invalid Location for the transaction:' || l_location_id || ':' || l_trx_type, 1);
3100: END IF;
3101: fnd_message.set_name('INV', 'INV_INVALID_LOCATION');
3102: fnd_msg_pub.ADD;
3103: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3104: RETURN;
3105: END ;
3106: END IF; --IF (l_sub IS NULL AND l_location_id IS NOT NULL THEN

Line 3103: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

3099: print_debug('VALIDATE_SUB_LOC 110: Invalid Location for the transaction:' || l_location_id || ':' || l_trx_type, 1);
3100: END IF;
3101: fnd_message.set_name('INV', 'INV_INVALID_LOCATION');
3102: fnd_msg_pub.ADD;
3103: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3104: RETURN;
3105: END ;
3106: END IF; --IF (l_sub IS NULL AND l_location_id IS NOT NULL THEN
3107: END LOOP;

Line 3175: fnd_msg_pub.initialize;

3171: END IF;
3172:
3173: -- Initialize message list if p_init_msg_list is set to TRUE.
3174: IF fnd_api.to_boolean(p_init_msg_lst) THEN
3175: fnd_msg_pub.initialize;
3176: END IF;
3177:
3178: inv_rcv_integration_pvt.split_lot_serial(p_rti_tb => p_new_rti_info,
3179: x_return_status => x_return_status,

Line 3237: fnd_msg_pub.add;

3233: -- error out. This API should not be called for a OPM transaction.
3234: IF gml_process_flags.check_process_orgn(l_org_id) = 1 THEN
3235: x_return_status := g_ret_sts_error;
3236: fnd_message.set_name('INV','INV_NOT_IMPLEMENTED');
3237: fnd_msg_pub.add;
3238: fnd_msg_pub.count_and_get
3239: ( p_count => x_msg_count
3240: , p_data => x_msg_data
3241: );

Line 3238: fnd_msg_pub.count_and_get

3234: IF gml_process_flags.check_process_orgn(l_org_id) = 1 THEN
3235: x_return_status := g_ret_sts_error;
3236: fnd_message.set_name('INV','INV_NOT_IMPLEMENTED');
3237: fnd_msg_pub.add;
3238: fnd_msg_pub.count_and_get
3239: ( p_count => x_msg_count
3240: , p_data => x_msg_data
3241: );
3242: RETURN FALSE;

Line 3270: fnd_msg_pub.ADD;

3266: );
3267: IF (x_return_status <> g_ret_sts_success) THEN
3268: x_msg_data := x_msg_data||':'||fnd_message.get_string('INV','INV_FAILED');
3269: fnd_message.set_name('INV','INV_TRANSACTION_FAILED');
3270: fnd_msg_pub.ADD;
3271: RETURN FALSE;
3272: END IF;
3273:
3274: RETURN TRUE;

Line 3779: fnd_msg_pub.add;

3775: print_debug('SPLIT_MMTT: No remaining MMTT with header_id '
3776: || p_txn_header_id || ' found MOL',4);
3777: END IF;
3778: fnd_message.set_name('WMS','WMS_TASK_NO_ELIGIBLE_TASKS');
3779: fnd_msg_pub.add;
3780: RAISE fnd_api.g_exc_error;
3781: END IF;
3782: ELSE
3783: IF (mmtt_cur%notfound) THEN

Line 3853: fnd_msg_pub.ADD;

3849: IF (l_debug = 1) THEN
3850: print_debug('SPLIT_MMTT: MMTT Not fully loaded, next iteration...',4);
3851: END IF;
3852: fnd_message.set_name('WMS', 'WMS_TASK_NOT_FULLY_LOADED');
3853: fnd_msg_pub.ADD;
3854: l_skip_iteration := 'Y';
3855: END IF;
3856: ELSE -- p_peration_type = 'DROP'
3857: IF (l_drop_flag <> 3) THEN

Line 3862: fnd_msg_pub.ADD;

3858: IF (l_debug = 1) THEN
3859: print_debug('SPLIT_MMTT: MMTT Not fully dropped, next iteration...',4);
3860: END IF;
3861: fnd_message.set_name('WMS', 'WMS_TASK_NOT_FULLY_DROPPED');
3862: fnd_msg_pub.ADD;
3863: l_skip_iteration := 'Y';
3864: END IF;
3865: END IF;
3866: END IF; --IF (p_operation_type IN ('LOAD', 'DROP'))

Line 4457: fnd_msg_pub.add;

4453: IF (l_debug = 1) THEN
4454: print_debug('SPLIT_MMTT: Error in split_operation_instance',4);
4455: END IF;
4456: fnd_message.set_name('WMS','WMS_TASK_SPLIT_FAIL');
4457: fnd_msg_pub.add;
4458: RAISE fnd_api.g_exc_error;
4459: END IF;
4460: l_progress := '130';
4461:

Line 4765: fnd_msg_pub.count_and_get

4761: IF (mmtt_cur%isopen) THEN
4762: CLOSE mmtt_cur;
4763: END IF;
4764: x_return_status := g_ret_sts_unexp_err;
4765: fnd_msg_pub.count_and_get
4766: ( p_count => x_msg_count
4767: ,p_data => x_msg_data );
4768: END split_mmtt;
4769:

Line 4881: fnd_msg_pub.ADD;

4877: IF (l_debug = 1) THEN
4878: print_debug('SPLIT_MO ERROR: Original quantity is <= 0', 4);
4879: END IF;
4880: fnd_message.set_name('INV', 'INV_INVALID_QTY');
4881: fnd_msg_pub.ADD;
4882: RAISE fnd_api.g_exc_error;
4883: END IF;
4884:
4885: l_progress := '20';

Line 4906: fnd_msg_pub.ADD;

4902: IF (l_debug = 1) THEN
4903: print_debug('SPLIT_MO - ERROR: Quantity to split is <= 0', 4);
4904: END IF;
4905: fnd_message.set_name('INV', 'INV_INVALID_QTY');
4906: fnd_msg_pub.ADD;
4907: RAISE fnd_api.g_exc_error;
4908: END IF;
4909:
4910: -- convert prim quantities to transaction uom in mol first

Line 4951: fnd_msg_pub.ADD;

4947: print_debug('SPLIT_MO - ERROR: Original QTY only '||l_orig_mol_rec.quantity
4948: || ', not enough to split ' || l_total_to_split, 4);
4949: END IF;
4950: fnd_message.set_name('INV', 'INV_INSUFFICIENT_QTY');
4951: fnd_msg_pub.ADD;
4952: RAISE fnd_api.g_exc_error;
4953: END IF;
4954:
4955: l_progress := '40';

Line 5227: fnd_msg_pub.add;

5223: print_debug('SPLIT_MO: Error copying move order lines', 4);
5224: print_debug('SPLIT_MO: SQLCODE = ' || SQLCODE, 4);
5225: END IF;
5226: fnd_message.set_name('WMS','WMS_MO_CREATE_FAIL');
5227: fnd_msg_pub.add;
5228: RAISE fnd_api.g_exc_error;
5229: END;
5230:
5231: l_progress := '60';

Line 5616: fnd_msg_pub.count_and_get

5612: END IF;
5613:
5614: x_return_status := g_ret_sts_unexp_err;
5615:
5616: fnd_msg_pub.count_and_get
5617: ( p_count => x_msg_count
5618: ,p_data => x_msg_data );
5619: ROLLBACK TO split_mo_pub;
5620: END split_mo;

Line 6437: fnd_msg_pub.add;

6433: IF (l_debug = 1) THEN
6434: print_debug('SPLIT_MMTT: Error in split_operation_instance',4);
6435: END IF;
6436: fnd_message.set_name('WMS','WMS_TASK_SPLIT_FAIL');
6437: fnd_msg_pub.add;
6438: RAISE fnd_api.g_exc_error;
6439: END IF;
6440:
6441: IF l_debug = 1 THEN

Line 6456: fnd_msg_pub.count_and_get

6452: IF (mmtt_cur%isopen) THEN
6453: CLOSE mmtt_cur;
6454: END IF;
6455: x_return_status := g_ret_sts_unexp_err;
6456: fnd_msg_pub.count_and_get
6457: ( p_count => x_msg_count
6458: ,p_data => x_msg_data );
6459: END split_mmtt;
6460: END inv_rcv_integration_apis;