DBA Data[Home] [Help]

APPS.INV_LABEL_PVT5 dependencies on FND_MESSAGE

Line 2523: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');

2519:
2520: IF (c_sql_stmt%rowcount=1 AND l_sql_stmt_result IS NULL) THEN
2521: x_return_status := FND_API.G_RET_STS_SUCCESS;
2522: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
2523: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
2524: fnd_msg_pub.ADD;
2525: -- Fix for bug: 4179593 Start
2526: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
2527: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);

Line 2544: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');

2540: trace('Custom Labels Trace [INVLAP5B.pls]: WARNING: No row returned by the Custom SQL query');
2541: END IF;
2542: x_return_status := FND_API.G_RET_STS_SUCCESS;
2543: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
2544: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
2545: fnd_msg_pub.ADD;
2546: -- Fix for bug: 4179593 Start
2547: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
2548: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);

Line 2559: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');

2555: trace('Custom Labels Trace [INVLAP5B.pls]: ERROR: Multiple values returned by the Custom SQL query');
2556: END IF;
2557: x_return_status := FND_API.G_RET_STS_SUCCESS;
2558: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
2559: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
2560: fnd_msg_pub.ADD;
2561: -- Fix for bug: 4179593 Start
2562: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
2563: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);

Line 2581: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');

2577: trace('Custom Labels Trace [INVLAP5B.pls]: At Breadcrumb 5');
2578: trace('Custom Labels Trace [INVLAP5B.pls]: Unexpected Error has occured in GET_VARIABLES_DATA');
2579: END IF;
2580: x_return_status := FND_API.G_RET_STS_ERROR;
2581: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
2582: fnd_msg_pub.ADD;
2583: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2585: END;