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_PVT1 dependencies on FND_API

Line 2150: x_return_status := fnd_api.g_ret_sts_success;

2146:
2147:
2148: BEGIN
2149: l_debug := inv_label.l_debug;
2150: x_return_status := fnd_api.g_ret_sts_success;
2151: l_label_err_msg := NULL;
2152:
2153: IF (l_debug = 1) THEN
2154: TRACE('**In PVT1: Material label**');

Line 3966: l_custom_sql_ret_status := FND_API.G_RET_STS_SUCCESS;

3962:
3963: l_column_name_list := 'Set variables for ';
3964:
3965: /* Modified for Bug 4072474 -start*/
3966: l_custom_sql_ret_status := FND_API.G_RET_STS_SUCCESS;
3967: /* Modified for Bug 4072474 -End*/
3968:
3969: -- Fix for bug: 4179593 Start
3970: l_CustSqlWarnFlagSet := FALSE;

Line 4019: x_return_status := FND_API.G_RET_STS_SUCCESS;

4015: EXIT WHEN c_sql_stmt%notfound OR c_sql_stmt%rowcount >=2;
4016: END LOOP;
4017:
4018: IF (c_sql_stmt%rowcount=1 AND l_sql_stmt_result IS NULL) THEN
4019: x_return_status := FND_API.G_RET_STS_SUCCESS;
4020: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
4021: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
4022: fnd_msg_pub.ADD;
4023: -- Fix for bug: 4179593 Start

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

4020: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
4021: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
4022: fnd_msg_pub.ADD;
4023: -- Fix for bug: 4179593 Start
4024: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
4025: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
4026: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
4027: l_CustSqlWarnFlagSet := TRUE;
4028: -- Fix for bug: 4179593 End

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

4021: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
4022: fnd_msg_pub.ADD;
4023: -- Fix for bug: 4179593 Start
4024: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
4025: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
4026: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
4027: l_CustSqlWarnFlagSet := TRUE;
4028: -- Fix for bug: 4179593 End
4029:

Line 4041: x_return_status := FND_API.G_RET_STS_SUCCESS;

4037: IF (l_debug = 1) THEN
4038: trace('Custom Labels Trace [INVLAP1B.pls]: At Breadcrumb 3');
4039: trace('Custom Labels Trace [INVLAP1B.pls]: WARNING: No row returned by the Custom SQL query');
4040: END IF;
4041: x_return_status := FND_API.G_RET_STS_SUCCESS;
4042: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
4043: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
4044: fnd_msg_pub.ADD;
4045: -- Fix for bug: 4179593 Start

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

4042: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
4043: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
4044: fnd_msg_pub.ADD;
4045: -- Fix for bug: 4179593 Start
4046: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
4047: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
4048: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
4049: l_CustSqlWarnFlagSet := TRUE;
4050: -- Fix for bug: 4179593 End

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

4043: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
4044: fnd_msg_pub.ADD;
4045: -- Fix for bug: 4179593 Start
4046: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
4047: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
4048: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
4049: l_CustSqlWarnFlagSet := TRUE;
4050: -- Fix for bug: 4179593 End
4051: ELSIF c_sql_stmt%rowcount>=2 THEN

Line 4057: x_return_status := FND_API.G_RET_STS_SUCCESS;

4053: trace('Custom Labels Trace [INVLAP1B.pls]: At Breadcrumb 4');
4054: trace('Custom Labels Trace [INVLAP1B.pls]: ERROR: Multiple values returned by the Custom SQL query');
4055: END IF;
4056: l_sql_stmt_result := NULL;
4057: x_return_status := FND_API.G_RET_STS_SUCCESS;
4058: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
4059: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
4060: fnd_msg_pub.ADD;
4061: -- Fix for bug: 4179593 Start

Line 4058: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;

4054: trace('Custom Labels Trace [INVLAP1B.pls]: ERROR: Multiple values returned by the Custom SQL query');
4055: END IF;
4056: l_sql_stmt_result := NULL;
4057: x_return_status := FND_API.G_RET_STS_SUCCESS;
4058: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
4059: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
4060: fnd_msg_pub.ADD;
4061: -- Fix for bug: 4179593 Start
4062: --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 4062: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);

4058: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
4059: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
4060: fnd_msg_pub.ADD;
4061: -- Fix for bug: 4179593 Start
4062: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
4063: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
4064: l_CustSqlErrMsg := l_custom_sql_ret_msg;
4065: l_CustSqlErrFlagSet := TRUE;
4066: -- Fix for bug: 4179593 End

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

4059: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
4060: fnd_msg_pub.ADD;
4061: -- Fix for bug: 4179593 Start
4062: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
4063: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
4064: l_CustSqlErrMsg := l_custom_sql_ret_msg;
4065: l_CustSqlErrFlagSet := TRUE;
4066: -- Fix for bug: 4179593 End
4067: END IF;

Line 4080: x_return_status := FND_API.G_RET_STS_ERROR;

4076: IF (l_debug = 1) THEN
4077: trace('Custom Labels Trace [INVLAP1B.pls]: At Breadcrumb 5');
4078: trace('Custom Labels Trace [INVLAP1B.pls]: Unexpected Error has occured in GET_VARIABLES_DATA');
4079: END IF;
4080: x_return_status := FND_API.G_RET_STS_ERROR;
4081: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
4082: fnd_msg_pub.ADD;
4083: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
4084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4079: END IF;
4080: x_return_status := FND_API.G_RET_STS_ERROR;
4081: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
4082: fnd_msg_pub.ADD;
4083: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
4084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4085: END;
4086: IF (l_debug = 1) THEN
4087: trace('Custom Labels Trace [INVLAP1B.pls]: At Breadcrumb 6');

Line 4084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4080: x_return_status := FND_API.G_RET_STS_ERROR;
4081: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
4082: fnd_msg_pub.ADD;
4083: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
4084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4085: END;
4086: IF (l_debug = 1) THEN
4087: trace('Custom Labels Trace [INVLAP1B.pls]: At Breadcrumb 6');
4088: trace('Custom Labels Trace [INVLAP1B.pls]: Before assigning it to l_material_data');

Line 5069: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;

5065: l_custom_sql_ret_msg := l_CustSqlWarnMsg;
5066: END IF;
5067:
5068: IF (l_CustSqlErrFlagSet) THEN
5069: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
5070: l_custom_sql_ret_msg := l_CustSqlErrMsg;
5071: END IF;
5072: -- Fix for bug: 4179593 End
5073: IF (l_CustSqlErrFlagSet) THEN