DBA Data[Home] [Help]

APPS.INV_LABEL_PVT8 dependencies on FND_MESSAGE

Line 1728: fnd_message.set_name('WMS', 'WMS_PRINT_LABEL_FAIL');

1724: IF ( l_return_status <> fnd_api.g_ret_sts_success ) THEN
1725: IF (l_debug = 1) THEN
1726: trace('failed to genrate LPN');
1727: END IF;
1728: fnd_message.set_name('WMS', 'WMS_PRINT_LABEL_FAIL');
1729: fnd_msg_pub.ADD;
1730: END IF;
1731:
1732: l_wdd_tb(l_qty_index).outer_lpn_id := l_to_lpn_id;

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

3047:
3048: IF (c_sql_stmt%rowcount=1 AND l_sql_stmt_result IS NULL) THEN
3049: x_return_status := FND_API.G_RET_STS_SUCCESS;
3050: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
3051: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
3052: fnd_msg_pub.ADD;
3053: -- Fix for bug: 4179593 Start
3054: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
3055: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);

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

3068: trace('Custom Labels Trace [INVLAP8B.pls]: WARNING: No row returned by the Custom SQL query');
3069: END IF;
3070: x_return_status := FND_API.G_RET_STS_SUCCESS;
3071: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
3072: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
3073: fnd_msg_pub.ADD;
3074: -- Fix for bug: 4179593 Start
3075: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
3076: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);

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

3083: trace('Custom Labels Trace [INVLAP8B.pls]: ERROR: Multiple values returned by the Custom SQL query');
3084: END IF;
3085: x_return_status := FND_API.G_RET_STS_SUCCESS;
3086: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
3087: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
3088: fnd_msg_pub.ADD;
3089: -- Fix for bug: 4179593 Start
3090: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
3091: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);

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

3105: trace('Custom Labels Trace [INVLAP8B.pls]: At Breadcrumb 5');
3106: trace('Custom Labels Trace [INVLAP8B.pls]: Unexpected Error has occured in GET_VARIABLES_DATA');
3107: END IF;
3108: x_return_status := FND_API.G_RET_STS_ERROR;
3109: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
3110: fnd_msg_pub.ADD;
3111: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3113: END;