DBA Data[Home] [Help]

APPS.INV_LABEL_PVT5 dependencies on FND_MESSAGE

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

3085:
3086: IF (c_sql_stmt%rowcount=1 AND l_sql_stmt_result IS NULL) THEN
3087: x_return_status := FND_API.G_RET_STS_SUCCESS;
3088: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
3089: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
3090: fnd_msg_pub.ADD;
3091: -- Fix for bug: 4179593 Start
3092: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
3093: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);

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

3106: trace('Custom Labels Trace [INVLAP5B.pls]: WARNING: No row returned by the Custom SQL query');
3107: END IF;
3108: x_return_status := FND_API.G_RET_STS_SUCCESS;
3109: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
3110: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
3111: fnd_msg_pub.ADD;
3112: -- Fix for bug: 4179593 Start
3113: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
3114: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);

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

3121: trace('Custom Labels Trace [INVLAP5B.pls]: ERROR: Multiple values returned by the Custom SQL query');
3122: END IF;
3123: x_return_status := FND_API.G_RET_STS_SUCCESS;
3124: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
3125: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
3126: fnd_msg_pub.ADD;
3127: -- Fix for bug: 4179593 Start
3128: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
3129: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);

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

3143: trace('Custom Labels Trace [INVLAP5B.pls]: At Breadcrumb 5');
3144: trace('Custom Labels Trace [INVLAP5B.pls]: Unexpected Error has occured in GET_VARIABLES_DATA');
3145: END IF;
3146: x_return_status := FND_API.G_RET_STS_ERROR;
3147: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
3148: fnd_msg_pub.ADD;
3149: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3151: END;