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

1149: l_label_format_set_id NUMBER;
1150: --End: Enabling EPC generation for R12 Project
1151:
1152: BEGIN
1153: x_return_status := fnd_api.g_ret_sts_success;
1154: l_label_err_msg := NULL;
1155: l_debug := inv_label.l_debug;
1156:
1157: IF (

Line 2384: l_custom_sql_ret_status := FND_API.G_RET_STS_SUCCESS;

2380:
2381: l_column_name_list := 'Set variables for ';
2382:
2383: /* Modified for Bug 4072474 -start*/
2384: l_custom_sql_ret_status := FND_API.G_RET_STS_SUCCESS;
2385: /* Modified for Bug 4072474 -End*/
2386:
2387: -- Fix for bug: 4179593 Start
2388: l_CustSqlWarnFlagSet := FALSE;

Line 2436: x_return_status := FND_API.G_RET_STS_SUCCESS;

2432: EXIT WHEN c_sql_stmt%notfound OR c_sql_stmt%rowcount >=2;
2433: END LOOP;
2434:
2435: IF (c_sql_stmt%rowcount=1 AND l_sql_stmt_result IS NULL) THEN
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_NULL_VALUE_RETURNED');
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_NULL_VALUE_RETURNED');
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_NULL_VALUE_RETURNED');
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:

Line 2458: x_return_status := FND_API.G_RET_STS_SUCCESS;

2454: IF (l_debug = 1) THEN
2455: trace('Custom Labels Trace [INVLAP2B.pls]: At Breadcrumb 3');
2456: trace('Custom Labels Trace [INVLAP2B.pls]: WARNING: No row returned by the Custom SQL query');
2457: END IF;
2458: x_return_status := FND_API.G_RET_STS_SUCCESS;
2459: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
2460: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
2461: fnd_msg_pub.ADD;
2462: -- Fix for bug: 4179593 Start

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

2459: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
2460: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
2461: fnd_msg_pub.ADD;
2462: -- Fix for bug: 4179593 Start
2463: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
2464: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
2465: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
2466: l_CustSqlWarnFlagSet := TRUE;
2467: -- Fix for bug: 4179593 End

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

2460: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
2461: fnd_msg_pub.ADD;
2462: -- Fix for bug: 4179593 Start
2463: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
2464: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
2465: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
2466: l_CustSqlWarnFlagSet := TRUE;
2467: -- Fix for bug: 4179593 End
2468: ELSIF c_sql_stmt%rowcount>=2 THEN

Line 2474: x_return_status := FND_API.G_RET_STS_SUCCESS;

2470: trace('Custom Labels Trace [INVLAP2B.pls]: At Breadcrumb 4');
2471: trace('Custom Labels Trace [INVLAP2B.pls]: ERROR: Multiple values returned by the Custom SQL query');
2472: END IF;
2473: l_sql_stmt_result := NULL;
2474: x_return_status := FND_API.G_RET_STS_SUCCESS;
2475: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
2476: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
2477: fnd_msg_pub.ADD;
2478: -- Fix for bug: 4179593 Start

Line 2475: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;

2471: trace('Custom Labels Trace [INVLAP2B.pls]: ERROR: Multiple values returned by the Custom SQL query');
2472: END IF;
2473: l_sql_stmt_result := NULL;
2474: x_return_status := FND_API.G_RET_STS_SUCCESS;
2475: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
2476: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
2477: fnd_msg_pub.ADD;
2478: -- Fix for bug: 4179593 Start
2479: --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 2479: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);

2475: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
2476: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
2477: fnd_msg_pub.ADD;
2478: -- Fix for bug: 4179593 Start
2479: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
2480: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
2481: l_CustSqlErrMsg := l_custom_sql_ret_msg;
2482: l_CustSqlErrFlagSet := TRUE;
2483: -- Fix for bug: 4179593 End

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

2476: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
2477: fnd_msg_pub.ADD;
2478: -- Fix for bug: 4179593 Start
2479: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
2480: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
2481: l_CustSqlErrMsg := l_custom_sql_ret_msg;
2482: l_CustSqlErrFlagSet := TRUE;
2483: -- Fix for bug: 4179593 End
2484: END IF;

Line 2497: x_return_status := FND_API.G_RET_STS_ERROR;

2493: IF (l_debug = 1) THEN
2494: trace('Custom Labels Trace [INVLAP2B.pls]: At Breadcrumb 5');
2495: trace('Custom Labels Trace [INVLAP2B.pls]: Unexpected Error has occured in GET_VARIABLES_DATA');
2496: END IF;
2497: x_return_status := FND_API.G_RET_STS_ERROR;
2498: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
2499: fnd_msg_pub.ADD;
2500: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

2496: END IF;
2497: x_return_status := FND_API.G_RET_STS_ERROR;
2498: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
2499: fnd_msg_pub.ADD;
2500: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2502: END;
2503: IF (l_debug = 1) THEN
2504: trace('Custom Labels Trace [INVLAP2B.pls]: At Breadcrumb 6');

Line 2501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2497: x_return_status := FND_API.G_RET_STS_ERROR;
2498: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
2499: fnd_msg_pub.ADD;
2500: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2502: END;
2503: IF (l_debug = 1) THEN
2504: trace('Custom Labels Trace [INVLAP2B.pls]: At Breadcrumb 6');
2505: trace('Custom Labels Trace [INVLAP2B.pls]: Before assigning it to l_serial_data');

Line 3099: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;

3095: l_custom_sql_ret_msg := l_CustSqlWarnMsg;
3096: END IF;
3097:
3098: IF (l_CustSqlErrFlagSet) THEN
3099: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
3100: l_custom_sql_ret_msg := l_CustSqlErrMsg;
3101: x_variable_content(l_label_index).label_status := l_custom_sql_ret_status;
3102: END IF;
3103: -- Fix for bug: 4179593 End