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 2028: x_return_status := fnd_api.g_ret_sts_success;

2024:
2025:
2026: BEGIN
2027: l_debug := inv_label.l_debug;
2028: x_return_status := fnd_api.g_ret_sts_success;
2029: l_label_err_msg := NULL;
2030:
2031: IF (l_debug = 1) THEN
2032: TRACE('**In PVT1: Material label**');

Line 3668: l_custom_sql_ret_status := FND_API.G_RET_STS_SUCCESS;

3664:
3665: l_column_name_list := 'Set variables for ';
3666:
3667: /* Modified for Bug 4072474 -start*/
3668: l_custom_sql_ret_status := FND_API.G_RET_STS_SUCCESS;
3669: /* Modified for Bug 4072474 -End*/
3670:
3671: -- Fix for bug: 4179593 Start
3672: l_CustSqlWarnFlagSet := FALSE;

Line 3721: x_return_status := FND_API.G_RET_STS_SUCCESS;

3717: EXIT WHEN c_sql_stmt%notfound OR c_sql_stmt%rowcount >=2;
3718: END LOOP;
3719:
3720: IF (c_sql_stmt%rowcount=1 AND l_sql_stmt_result IS NULL) THEN
3721: x_return_status := FND_API.G_RET_STS_SUCCESS;
3722: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
3723: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
3724: fnd_msg_pub.ADD;
3725: -- Fix for bug: 4179593 Start

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

3722: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
3723: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
3724: fnd_msg_pub.ADD;
3725: -- Fix for bug: 4179593 Start
3726: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
3727: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
3728: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
3729: l_CustSqlWarnFlagSet := TRUE;
3730: -- Fix for bug: 4179593 End

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

3723: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
3724: fnd_msg_pub.ADD;
3725: -- Fix for bug: 4179593 Start
3726: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
3727: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
3728: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
3729: l_CustSqlWarnFlagSet := TRUE;
3730: -- Fix for bug: 4179593 End
3731:

Line 3743: x_return_status := FND_API.G_RET_STS_SUCCESS;

3739: IF (l_debug = 1) THEN
3740: trace('Custom Labels Trace [INVLAP1B.pls]: At Breadcrumb 3');
3741: trace('Custom Labels Trace [INVLAP1B.pls]: WARNING: No row returned by the Custom SQL query');
3742: END IF;
3743: x_return_status := FND_API.G_RET_STS_SUCCESS;
3744: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
3745: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
3746: fnd_msg_pub.ADD;
3747: -- Fix for bug: 4179593 Start

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

3744: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
3745: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
3746: fnd_msg_pub.ADD;
3747: -- Fix for bug: 4179593 Start
3748: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
3749: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
3750: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
3751: l_CustSqlWarnFlagSet := TRUE;
3752: -- Fix for bug: 4179593 End

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

3745: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
3746: fnd_msg_pub.ADD;
3747: -- Fix for bug: 4179593 Start
3748: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
3749: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
3750: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
3751: l_CustSqlWarnFlagSet := TRUE;
3752: -- Fix for bug: 4179593 End
3753: ELSIF c_sql_stmt%rowcount>=2 THEN

Line 3759: x_return_status := FND_API.G_RET_STS_SUCCESS;

3755: trace('Custom Labels Trace [INVLAP1B.pls]: At Breadcrumb 4');
3756: trace('Custom Labels Trace [INVLAP1B.pls]: ERROR: Multiple values returned by the Custom SQL query');
3757: END IF;
3758: l_sql_stmt_result := NULL;
3759: x_return_status := FND_API.G_RET_STS_SUCCESS;
3760: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
3761: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
3762: fnd_msg_pub.ADD;
3763: -- Fix for bug: 4179593 Start

Line 3760: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;

3756: trace('Custom Labels Trace [INVLAP1B.pls]: ERROR: Multiple values returned by the Custom SQL query');
3757: END IF;
3758: l_sql_stmt_result := NULL;
3759: x_return_status := FND_API.G_RET_STS_SUCCESS;
3760: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
3761: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
3762: fnd_msg_pub.ADD;
3763: -- Fix for bug: 4179593 Start
3764: --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 3764: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);

3760: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
3761: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
3762: fnd_msg_pub.ADD;
3763: -- Fix for bug: 4179593 Start
3764: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
3765: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
3766: l_CustSqlErrMsg := l_custom_sql_ret_msg;
3767: l_CustSqlErrFlagSet := TRUE;
3768: -- Fix for bug: 4179593 End

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

3761: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
3762: fnd_msg_pub.ADD;
3763: -- Fix for bug: 4179593 Start
3764: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
3765: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
3766: l_CustSqlErrMsg := l_custom_sql_ret_msg;
3767: l_CustSqlErrFlagSet := TRUE;
3768: -- Fix for bug: 4179593 End
3769: END IF;

Line 3782: x_return_status := FND_API.G_RET_STS_ERROR;

3778: IF (l_debug = 1) THEN
3779: trace('Custom Labels Trace [INVLAP1B.pls]: At Breadcrumb 5');
3780: trace('Custom Labels Trace [INVLAP1B.pls]: Unexpected Error has occured in GET_VARIABLES_DATA');
3781: END IF;
3782: x_return_status := FND_API.G_RET_STS_ERROR;
3783: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
3784: fnd_msg_pub.ADD;
3785: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3781: END IF;
3782: x_return_status := FND_API.G_RET_STS_ERROR;
3783: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
3784: fnd_msg_pub.ADD;
3785: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3787: END;
3788: IF (l_debug = 1) THEN
3789: trace('Custom Labels Trace [INVLAP1B.pls]: At Breadcrumb 6');

Line 3786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3782: x_return_status := FND_API.G_RET_STS_ERROR;
3783: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
3784: fnd_msg_pub.ADD;
3785: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3787: END;
3788: IF (l_debug = 1) THEN
3789: trace('Custom Labels Trace [INVLAP1B.pls]: At Breadcrumb 6');
3790: trace('Custom Labels Trace [INVLAP1B.pls]: Before assigning it to l_material_data');

Line 4761: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;

4757: l_custom_sql_ret_msg := l_CustSqlWarnMsg;
4758: END IF;
4759:
4760: IF (l_CustSqlErrFlagSet) THEN
4761: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
4762: l_custom_sql_ret_msg := l_CustSqlErrMsg;
4763: END IF;
4764: -- Fix for bug: 4179593 End
4765: IF (l_CustSqlErrFlagSet) THEN