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

Line 3090: fnd_msg_pub.ADD;

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

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

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);
3094: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
3095: l_CustSqlWarnFlagSet := TRUE;
3096: -- Fix for bug: 4179593 End

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

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);
3094: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
3095: l_CustSqlWarnFlagSet := TRUE;
3096: -- Fix for bug: 4179593 End
3097: IF (l_debug = 1) THEN

Line 3111: fnd_msg_pub.ADD;

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

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

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);
3115: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
3116: l_CustSqlWarnFlagSet := TRUE;
3117: -- Fix for bug: 4179593 End

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

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);
3115: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
3116: l_CustSqlWarnFlagSet := TRUE;
3117: -- Fix for bug: 4179593 End
3118: ELSIF c_sql_stmt%rowcount>=2 THEN

Line 3126: fnd_msg_pub.ADD;

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

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

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);
3130: l_CustSqlErrMsg := l_custom_sql_ret_msg;
3131: l_CustSqlErrFlagSet := TRUE;
3132: -- Fix for bug: 4179593 End

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

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);
3130: l_CustSqlErrMsg := l_custom_sql_ret_msg;
3131: l_CustSqlErrFlagSet := TRUE;
3132: -- Fix for bug: 4179593 End
3133: END IF;

Line 3148: fnd_msg_pub.ADD;

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

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