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

Line 1146: x_return_status := fnd_api.g_ret_sts_success;

1142: l_label_format_set_id NUMBER;
1143: --End: Enabling EPC generation for R12 Project
1144:
1145: BEGIN
1146: x_return_status := fnd_api.g_ret_sts_success;
1147: l_label_err_msg := NULL;
1148: l_debug := inv_label.l_debug;
1149:
1150: IF (

Line 2362: l_custom_sql_ret_status := FND_API.G_RET_STS_SUCCESS;

2358:
2359: l_column_name_list := 'Set variables for ';
2360:
2361: /* Modified for Bug 4072474 -start*/
2362: l_custom_sql_ret_status := FND_API.G_RET_STS_SUCCESS;
2363: /* Modified for Bug 4072474 -End*/
2364:
2365: -- Fix for bug: 4179593 Start
2366: l_CustSqlWarnFlagSet := FALSE;

Line 2414: x_return_status := FND_API.G_RET_STS_SUCCESS;

2410: EXIT WHEN c_sql_stmt%notfound OR c_sql_stmt%rowcount >=2;
2411: END LOOP;
2412:
2413: IF (c_sql_stmt%rowcount=1 AND l_sql_stmt_result IS NULL) THEN
2414: x_return_status := FND_API.G_RET_STS_SUCCESS;
2415: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
2416: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
2417: fnd_msg_pub.ADD;
2418: -- Fix for bug: 4179593 Start

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

2415: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
2416: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
2417: fnd_msg_pub.ADD;
2418: -- Fix for bug: 4179593 Start
2419: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
2420: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
2421: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
2422: l_CustSqlWarnFlagSet := TRUE;
2423: -- Fix for bug: 4179593 End

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

2416: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
2417: fnd_msg_pub.ADD;
2418: -- Fix for bug: 4179593 Start
2419: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
2420: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
2421: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
2422: l_CustSqlWarnFlagSet := TRUE;
2423: -- Fix for bug: 4179593 End
2424:

Line 2436: x_return_status := FND_API.G_RET_STS_SUCCESS;

2432: IF (l_debug = 1) THEN
2433: trace('Custom Labels Trace [INVLAP2B.pls]: At Breadcrumb 3');
2434: trace('Custom Labels Trace [INVLAP2B.pls]: WARNING: No row returned by the Custom SQL query');
2435: END IF;
2436: x_return_status := FND_API.G_RET_STS_SUCCESS;
2437: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
2438: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
2439: fnd_msg_pub.ADD;
2440: -- Fix for bug: 4179593 Start

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

2437: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
2438: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
2439: fnd_msg_pub.ADD;
2440: -- Fix for bug: 4179593 Start
2441: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
2442: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
2443: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
2444: l_CustSqlWarnFlagSet := TRUE;
2445: -- Fix for bug: 4179593 End

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

2438: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
2439: fnd_msg_pub.ADD;
2440: -- Fix for bug: 4179593 Start
2441: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
2442: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
2443: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
2444: l_CustSqlWarnFlagSet := TRUE;
2445: -- Fix for bug: 4179593 End
2446: ELSIF c_sql_stmt%rowcount>=2 THEN

Line 2452: x_return_status := FND_API.G_RET_STS_SUCCESS;

2448: trace('Custom Labels Trace [INVLAP2B.pls]: At Breadcrumb 4');
2449: trace('Custom Labels Trace [INVLAP2B.pls]: ERROR: Multiple values returned by the Custom SQL query');
2450: END IF;
2451: l_sql_stmt_result := NULL;
2452: x_return_status := FND_API.G_RET_STS_SUCCESS;
2453: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
2454: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
2455: fnd_msg_pub.ADD;
2456: -- Fix for bug: 4179593 Start

Line 2453: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;

2449: trace('Custom Labels Trace [INVLAP2B.pls]: ERROR: Multiple values returned by the Custom SQL query');
2450: END IF;
2451: l_sql_stmt_result := NULL;
2452: x_return_status := FND_API.G_RET_STS_SUCCESS;
2453: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
2454: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
2455: fnd_msg_pub.ADD;
2456: -- Fix for bug: 4179593 Start
2457: --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 2457: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);

2453: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
2454: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
2455: fnd_msg_pub.ADD;
2456: -- Fix for bug: 4179593 Start
2457: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
2458: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
2459: l_CustSqlErrMsg := l_custom_sql_ret_msg;
2460: l_CustSqlErrFlagSet := TRUE;
2461: -- Fix for bug: 4179593 End

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

2454: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
2455: fnd_msg_pub.ADD;
2456: -- Fix for bug: 4179593 Start
2457: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
2458: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
2459: l_CustSqlErrMsg := l_custom_sql_ret_msg;
2460: l_CustSqlErrFlagSet := TRUE;
2461: -- Fix for bug: 4179593 End
2462: END IF;

Line 2475: x_return_status := FND_API.G_RET_STS_ERROR;

2471: IF (l_debug = 1) THEN
2472: trace('Custom Labels Trace [INVLAP2B.pls]: At Breadcrumb 5');
2473: trace('Custom Labels Trace [INVLAP2B.pls]: Unexpected Error has occured in GET_VARIABLES_DATA');
2474: END IF;
2475: x_return_status := FND_API.G_RET_STS_ERROR;
2476: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
2477: fnd_msg_pub.ADD;
2478: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2479: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

2474: END IF;
2475: x_return_status := FND_API.G_RET_STS_ERROR;
2476: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
2477: fnd_msg_pub.ADD;
2478: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2479: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2480: END;
2481: IF (l_debug = 1) THEN
2482: trace('Custom Labels Trace [INVLAP2B.pls]: At Breadcrumb 6');

Line 2479: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2475: x_return_status := FND_API.G_RET_STS_ERROR;
2476: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
2477: fnd_msg_pub.ADD;
2478: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2479: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2480: END;
2481: IF (l_debug = 1) THEN
2482: trace('Custom Labels Trace [INVLAP2B.pls]: At Breadcrumb 6');
2483: trace('Custom Labels Trace [INVLAP2B.pls]: Before assigning it to l_serial_data');

Line 3075: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;

3071: l_custom_sql_ret_msg := l_CustSqlWarnMsg;
3072: END IF;
3073:
3074: IF (l_CustSqlErrFlagSet) THEN
3075: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
3076: l_custom_sql_ret_msg := l_CustSqlErrMsg;
3077: x_variable_content(l_label_index).label_status := l_custom_sql_ret_status;
3078: END IF;
3079: -- Fix for bug: 4179593 End