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_API

Line 612: x_return_status := fnd_api.g_ret_sts_success;

608: --END Conf Label ER
609:
610: BEGIN
611: -- Initialize return status as success
612: x_return_status := fnd_api.g_ret_sts_success;
613: l_debug := inv_label.l_debug;
614:
615: IF (l_debug = 1) THEN
616: TRACE('**In PVT3: LPN label**');

Line 1184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1180: WHEN OTHERS THEN
1181: trace('Exception raised in custom code in WMS_LABEL_CUSTOM_PKG.custom_restrict_labels');
1182: trace('SQLCODE::'||SQLCODE);
1183: trace('SQLERRM::'||SQLERRM);
1184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1185: END;
1186:
1187: --First validate that the table returned from custom code has not introduced any new LPNs
1188: --If there are new LPNs, then first remove them from the list and proceed

Line 1728: l_custom_sql_ret_status := FND_API.G_RET_STS_SUCCESS;

1724:
1725: l_column_name_list := 'Set variables for ';
1726:
1727: -- Fix for bug: 4179593 Start
1728: l_custom_sql_ret_status := FND_API.G_RET_STS_SUCCESS;
1729: l_CustSqlWarnFlagSet := FALSE;
1730: l_CustSqlErrFlagSet := FALSE;
1731: l_CustSqlWarnMsg := NULL;
1732: l_CustSqlErrMsg := NULL;

Line 1778: x_return_status := FND_API.G_RET_STS_SUCCESS;

1774: EXIT WHEN c_sql_stmt%notfound OR c_sql_stmt%rowcount >=2;
1775: END LOOP;
1776:
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

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 1799: x_return_status := FND_API.G_RET_STS_SUCCESS;

1795: IF (l_debug = 1) THEN
1796: trace('Custom Labels Trace [INVLAP3B.pls]: At Breadcrumb 3');
1797: trace('Custom Labels Trace [INVLAP3B.pls]: WARNING: No row returned by the Custom SQL query');
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

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 1815: x_return_status := FND_API.G_RET_STS_SUCCESS;

1811: trace('Custom Labels Trace [INVLAP3B.pls]: At Breadcrumb 4');
1812: trace('Custom Labels Trace [INVLAP3B.pls]: ERROR: Multiple values returned by the Custom SQL query');
1813: END IF;
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

Line 1816: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;

1812: trace('Custom Labels Trace [INVLAP3B.pls]: ERROR: Multiple values returned by the Custom SQL query');
1813: END IF;
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);

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 1838: x_return_status := FND_API.G_RET_STS_ERROR;

1834: IF (l_debug = 1) THEN
1835: trace('Custom Labels Trace [INVLAP3B.pls]: At Breadcrumb 5');
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;

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

Line 1842: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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');
1846: trace('Custom Labels Trace [INVLAP3B.pls]: Before assigning it to l_content_item_data');

Line 2231: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;

2227: l_custom_sql_ret_msg := l_CustSqlWarnMsg;
2228: END IF;
2229:
2230: IF (l_CustSqlErrFlagSet) THEN
2231: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
2232: l_custom_sql_ret_msg := l_CustSqlErrMsg;
2233: END IF;
2234: -- Fix for bug: 4179593 End
2235: