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

Line 1037: fnd_msg_pub.ADD;

1033: );
1034:
1035: IF l_return_status <> 'S' THEN
1036: fnd_message.set_name('WMS', 'WMS_LABL_RULE_ENGINE_FAILED');
1037: fnd_msg_pub.ADD;
1038: l_label_format_set_id := p_label_type_info.default_format_id;
1039: l_label_format := p_label_type_info.default_format_name;
1040: END IF;
1041:

Line 1109: fnd_msg_pub.ADD;

1105: );
1106:
1107: IF l_return_status <> 'S' THEN
1108: fnd_message.set_name('WMS', 'WMS_LABL_RULE_ENGINE_FAILED');
1109: fnd_msg_pub.ADD;
1110: l_label_format_id := p_label_type_info.default_format_id;
1111: l_label_format := p_label_type_info.default_format_name;
1112: END IF;
1113:

Line 1419: fnd_msg_pub.ADD;

1415: IF (c_sql_stmt%rowcount=1 AND l_sql_stmt_result IS NULL) THEN
1416: x_return_status := FND_API.G_RET_STS_SUCCESS;
1417: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
1418: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
1419: fnd_msg_pub.ADD;
1420: -- Fix for bug: 4179593 Start
1421: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
1422: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
1423: l_CustSqlWarnMsg := l_custom_sql_ret_msg;

Line 1421: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);

1417: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
1418: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
1419: fnd_msg_pub.ADD;
1420: -- Fix for bug: 4179593 Start
1421: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
1422: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
1423: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
1424: l_CustSqlWarnFlagSet := TRUE;
1425: -- Fix for bug: 4179593 End

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

1418: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
1419: fnd_msg_pub.ADD;
1420: -- Fix for bug: 4179593 Start
1421: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
1422: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
1423: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
1424: l_CustSqlWarnFlagSet := TRUE;
1425: -- Fix for bug: 4179593 End
1426: IF (l_debug = 1) THEN

Line 1440: fnd_msg_pub.ADD;

1436: END IF;
1437: x_return_status := FND_API.G_RET_STS_SUCCESS;
1438: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
1439: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
1440: fnd_msg_pub.ADD;
1441: -- Fix for bug: 4179593 Start
1442: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
1443: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
1444: l_CustSqlWarnMsg := l_custom_sql_ret_msg;

Line 1442: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);

1438: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
1439: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
1440: fnd_msg_pub.ADD;
1441: -- Fix for bug: 4179593 Start
1442: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
1443: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
1444: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
1445: l_CustSqlWarnFlagSet := TRUE;
1446: -- Fix for bug: 4179593 End

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

1439: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
1440: fnd_msg_pub.ADD;
1441: -- Fix for bug: 4179593 Start
1442: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
1443: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
1444: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
1445: l_CustSqlWarnFlagSet := TRUE;
1446: -- Fix for bug: 4179593 End
1447: ELSIF c_sql_stmt%rowcount>=2 THEN

Line 1456: fnd_msg_pub.ADD;

1452: l_sql_stmt_result := NULL;
1453: x_return_status := FND_API.G_RET_STS_SUCCESS;
1454: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
1455: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
1456: fnd_msg_pub.ADD;
1457: -- Fix for bug: 4179593 Start
1458: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
1459: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
1460: l_CustSqlErrMsg := l_custom_sql_ret_msg;

Line 1458: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);

1454: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
1455: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
1456: fnd_msg_pub.ADD;
1457: -- Fix for bug: 4179593 Start
1458: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
1459: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
1460: l_CustSqlErrMsg := l_custom_sql_ret_msg;
1461: l_CustSqlErrFlagSet := TRUE;
1462: -- Fix for bug: 4179593 End

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

1455: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
1456: fnd_msg_pub.ADD;
1457: -- Fix for bug: 4179593 Start
1458: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
1459: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
1460: l_CustSqlErrMsg := l_custom_sql_ret_msg;
1461: l_CustSqlErrFlagSet := TRUE;
1462: -- Fix for bug: 4179593 End
1463: END IF;

Line 1478: fnd_msg_pub.ADD;

1474: trace('Custom Labels Trace [INVLAP3B.pls]: Unexpected Error has occured in GET_VARIABLES_DATA');
1475: END IF;
1476: x_return_status := FND_API.G_RET_STS_ERROR;
1477: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
1478: fnd_msg_pub.ADD;
1479: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1481: END;
1482: IF (l_debug = 1) THEN

Line 1479: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

1475: END IF;
1476: x_return_status := FND_API.G_RET_STS_ERROR;
1477: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
1478: fnd_msg_pub.ADD;
1479: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1481: END;
1482: IF (l_debug = 1) THEN
1483: trace('Custom Labels Trace [INVLAP3B.pls]: At Breadcrumb 6');