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_LABEL_PVT8 dependencies on FND_MSG_PUB

Line 1729: fnd_msg_pub.ADD;

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;
1733: IF (l_debug = 1) THEN

Line 3052: fnd_msg_pub.ADD;

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);
3056: l_CustSqlWarnMsg := l_custom_sql_ret_msg;

Line 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);

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);
3056: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
3057: l_CustSqlWarnFlagSet := TRUE;
3058: -- Fix for bug: 4179593 End

Line 3055: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);

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);
3056: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
3057: l_CustSqlWarnFlagSet := TRUE;
3058: -- Fix for bug: 4179593 End
3059: IF (l_debug = 1) THEN

Line 3073: fnd_msg_pub.ADD;

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);
3077: l_CustSqlWarnMsg := l_custom_sql_ret_msg;

Line 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);

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);
3077: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
3078: l_CustSqlWarnFlagSet := TRUE;
3079: -- Fix for bug: 4179593 End

Line 3076: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);

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);
3077: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
3078: l_CustSqlWarnFlagSet := TRUE;
3079: -- Fix for bug: 4179593 End
3080: ELSIF c_sql_stmt%rowcount>=2 THEN

Line 3088: fnd_msg_pub.ADD;

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);
3092: l_CustSqlErrMsg := l_custom_sql_ret_msg;

Line 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);

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);
3092: l_CustSqlErrMsg := l_custom_sql_ret_msg;
3093: l_CustSqlErrFlagSet := TRUE;
3094: -- Fix for bug: 4179593 End

Line 3091: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);

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);
3092: l_CustSqlErrMsg := l_custom_sql_ret_msg;
3093: l_CustSqlErrFlagSet := TRUE;
3094: -- Fix for bug: 4179593 End
3095: END IF;

Line 3110: fnd_msg_pub.ADD;

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;
3114: IF (l_debug = 1) THEN

Line 3111: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_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;
3114: IF (l_debug = 1) THEN
3115: trace('Custom Labels Trace [INVLAP8B.pls]: At Breadcrumb 6');