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 1401: fnd_msg_pub.ADD;

1397: );
1398:
1399: IF l_return_status <> 'S' THEN
1400: fnd_message.set_name('WMS', 'WMS_LABL_RULE_ENGINE_FAILED');
1401: fnd_msg_pub.ADD;
1402: l_label_format_set_id := p_label_type_info.default_format_id;
1403: l_label_format := p_label_type_info.default_format_name;
1404: END IF;
1405:

Line 1473: fnd_msg_pub.ADD;

1469: );
1470:
1471: IF l_return_status <> 'S' THEN
1472: fnd_message.set_name('WMS', 'WMS_LABL_RULE_ENGINE_FAILED');
1473: fnd_msg_pub.ADD;
1474: l_label_format_id := p_label_type_info.default_format_id;
1475: l_label_format := p_label_type_info.default_format_name;
1476: END IF;
1477:

Line 1781: fnd_msg_pub.ADD;

1777: IF (c_sql_stmt%rowcount=1 AND l_sql_stmt_result IS NULL) THEN
1778: x_return_status := FND_API.G_RET_STS_SUCCESS;
1779: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
1780: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
1781: fnd_msg_pub.ADD;
1782: -- Fix for bug: 4179593 Start
1783: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
1784: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
1785: l_CustSqlWarnMsg := l_custom_sql_ret_msg;

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

1779: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
1780: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
1781: fnd_msg_pub.ADD;
1782: -- Fix for bug: 4179593 Start
1783: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
1784: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
1785: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
1786: l_CustSqlWarnFlagSet := TRUE;
1787: -- Fix for bug: 4179593 End

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

1780: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
1781: fnd_msg_pub.ADD;
1782: -- Fix for bug: 4179593 Start
1783: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
1784: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
1785: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
1786: l_CustSqlWarnFlagSet := TRUE;
1787: -- Fix for bug: 4179593 End
1788: IF (l_debug = 1) THEN

Line 1802: fnd_msg_pub.ADD;

1798: END IF;
1799: x_return_status := FND_API.G_RET_STS_SUCCESS;
1800: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
1801: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
1802: fnd_msg_pub.ADD;
1803: -- Fix for bug: 4179593 Start
1804: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
1805: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
1806: l_CustSqlWarnMsg := l_custom_sql_ret_msg;

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

1800: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
1801: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
1802: fnd_msg_pub.ADD;
1803: -- Fix for bug: 4179593 Start
1804: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
1805: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
1806: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
1807: l_CustSqlWarnFlagSet := TRUE;
1808: -- Fix for bug: 4179593 End

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

1801: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
1802: fnd_msg_pub.ADD;
1803: -- Fix for bug: 4179593 Start
1804: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
1805: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
1806: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
1807: l_CustSqlWarnFlagSet := TRUE;
1808: -- Fix for bug: 4179593 End
1809: ELSIF c_sql_stmt%rowcount>=2 THEN

Line 1818: fnd_msg_pub.ADD;

1814: l_sql_stmt_result := NULL;
1815: x_return_status := FND_API.G_RET_STS_SUCCESS;
1816: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
1817: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
1818: fnd_msg_pub.ADD;
1819: -- Fix for bug: 4179593 Start
1820: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
1821: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
1822: l_CustSqlErrMsg := l_custom_sql_ret_msg;

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

1816: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
1817: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
1818: fnd_msg_pub.ADD;
1819: -- Fix for bug: 4179593 Start
1820: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
1821: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
1822: l_CustSqlErrMsg := l_custom_sql_ret_msg;
1823: l_CustSqlErrFlagSet := TRUE;
1824: -- Fix for bug: 4179593 End

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

1817: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
1818: fnd_msg_pub.ADD;
1819: -- Fix for bug: 4179593 Start
1820: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
1821: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
1822: l_CustSqlErrMsg := l_custom_sql_ret_msg;
1823: l_CustSqlErrFlagSet := TRUE;
1824: -- Fix for bug: 4179593 End
1825: END IF;

Line 1840: fnd_msg_pub.ADD;

1836: trace('Custom Labels Trace [INVLAP3B.pls]: Unexpected Error has occured in GET_VARIABLES_DATA');
1837: END IF;
1838: x_return_status := FND_API.G_RET_STS_ERROR;
1839: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
1840: fnd_msg_pub.ADD;
1841: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1842: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1843: END;
1844: IF (l_debug = 1) THEN

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

1837: END IF;
1838: x_return_status := FND_API.G_RET_STS_ERROR;
1839: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
1840: fnd_msg_pub.ADD;
1841: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1842: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1843: END;
1844: IF (l_debug = 1) THEN
1845: trace('Custom Labels Trace [INVLAP3B.pls]: At Breadcrumb 6');