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

Line 1320: x_return_status := FND_API.G_RET_STS_SUCCESS;

1316: ', Transaction ID='||p_transaction_id ||
1317: ', Transaction Identifier='||p_transaction_identifier );
1318: END IF;
1319: -- Initialize return status as success
1320: x_return_status := FND_API.G_RET_STS_SUCCESS;
1321:
1322: IF (inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j)
1323: AND (inv_rcv_common_apis.g_po_patch_level >=inv_rcv_common_apis.g_patchset_j_po) THEN
1324: l_patch_level := 1;

Line 1991: l_custom_sql_ret_status := FND_API.G_RET_STS_SUCCESS;

1987: trace(' for: lpn_id='||l_lpn_id||', l_cur_item='||l_cur_item_id||',ndx='||l_lpn_table_index);
1988: END IF;
1989:
1990: -- Fix for bug: 4179593
1991: l_custom_sql_ret_status := FND_API.G_RET_STS_SUCCESS;
1992: -- Fix for bug: 4179593
1993:
1994: -- Fix for bug: 4179593 Start
1995: l_CustSqlWarnFlagSet := FALSE;

Line 2521: x_return_status := FND_API.G_RET_STS_SUCCESS;

2517: EXIT WHEN c_sql_stmt%notfound OR c_sql_stmt%rowcount >=2;
2518: END LOOP;
2519:
2520: IF (c_sql_stmt%rowcount=1 AND l_sql_stmt_result IS NULL) THEN
2521: x_return_status := FND_API.G_RET_STS_SUCCESS;
2522: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
2523: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
2524: fnd_msg_pub.ADD;
2525: -- Fix for bug: 4179593 Start

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

2522: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
2523: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
2524: fnd_msg_pub.ADD;
2525: -- Fix for bug: 4179593 Start
2526: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
2527: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
2528: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
2529: l_CustSqlWarnFlagSet := TRUE;
2530: -- Fix for bug: 4179593 End

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

2523: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
2524: fnd_msg_pub.ADD;
2525: -- Fix for bug: 4179593 Start
2526: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
2527: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
2528: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
2529: l_CustSqlWarnFlagSet := TRUE;
2530: -- Fix for bug: 4179593 End
2531: IF (l_debug = 1) THEN

Line 2542: x_return_status := FND_API.G_RET_STS_SUCCESS;

2538: IF (l_debug = 1) THEN
2539: trace('Custom Labels Trace [INVLAP5B.pls]: At Breadcrumb 3');
2540: trace('Custom Labels Trace [INVLAP5B.pls]: WARNING: No row returned by the Custom SQL query');
2541: END IF;
2542: x_return_status := FND_API.G_RET_STS_SUCCESS;
2543: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
2544: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
2545: fnd_msg_pub.ADD;
2546: -- Fix for bug: 4179593 Start

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

2543: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
2544: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
2545: fnd_msg_pub.ADD;
2546: -- Fix for bug: 4179593 Start
2547: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
2548: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
2549: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
2550: l_CustSqlWarnFlagSet := TRUE;
2551: -- Fix for bug: 4179593 End

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

2544: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
2545: fnd_msg_pub.ADD;
2546: -- Fix for bug: 4179593 Start
2547: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
2548: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
2549: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
2550: l_CustSqlWarnFlagSet := TRUE;
2551: -- Fix for bug: 4179593 End
2552: ELSIF c_sql_stmt%rowcount>=2 THEN

Line 2557: x_return_status := FND_API.G_RET_STS_SUCCESS;

2553: IF (l_debug = 1) THEN
2554: trace('Custom Labels Trace [INVLAP5B.pls]: At Breadcrumb 4');
2555: trace('Custom Labels Trace [INVLAP5B.pls]: ERROR: Multiple values returned by the Custom SQL query');
2556: END IF;
2557: x_return_status := FND_API.G_RET_STS_SUCCESS;
2558: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
2559: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
2560: fnd_msg_pub.ADD;
2561: -- Fix for bug: 4179593 Start

Line 2558: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;

2554: trace('Custom Labels Trace [INVLAP5B.pls]: At Breadcrumb 4');
2555: trace('Custom Labels Trace [INVLAP5B.pls]: ERROR: Multiple values returned by the Custom SQL query');
2556: END IF;
2557: x_return_status := FND_API.G_RET_STS_SUCCESS;
2558: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
2559: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
2560: fnd_msg_pub.ADD;
2561: -- Fix for bug: 4179593 Start
2562: --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 2562: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);

2558: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
2559: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
2560: fnd_msg_pub.ADD;
2561: -- Fix for bug: 4179593 Start
2562: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
2563: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
2564: l_CustSqlErrMsg := l_custom_sql_ret_msg;
2565: l_CustSqlErrFlagSet := TRUE;
2566: -- Fix for bug: 4179593 End

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

2559: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
2560: fnd_msg_pub.ADD;
2561: -- Fix for bug: 4179593 Start
2562: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
2563: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
2564: l_CustSqlErrMsg := l_custom_sql_ret_msg;
2565: l_CustSqlErrFlagSet := TRUE;
2566: -- Fix for bug: 4179593 End
2567: END IF;

Line 2580: x_return_status := FND_API.G_RET_STS_ERROR;

2576: IF (l_debug = 1) THEN
2577: trace('Custom Labels Trace [INVLAP5B.pls]: At Breadcrumb 5');
2578: trace('Custom Labels Trace [INVLAP5B.pls]: Unexpected Error has occured in GET_VARIABLES_DATA');
2579: END IF;
2580: x_return_status := FND_API.G_RET_STS_ERROR;
2581: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
2582: fnd_msg_pub.ADD;
2583: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

2579: END IF;
2580: x_return_status := FND_API.G_RET_STS_ERROR;
2581: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
2582: fnd_msg_pub.ADD;
2583: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2585: END;
2586: IF (l_debug = 1) THEN
2587: trace('Custom Labels Trace [INVLAP5B.pls]: At Breadcrumb 6');

Line 2584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2580: x_return_status := FND_API.G_RET_STS_ERROR;
2581: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
2582: fnd_msg_pub.ADD;
2583: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2585: END;
2586: IF (l_debug = 1) THEN
2587: trace('Custom Labels Trace [INVLAP5B.pls]: At Breadcrumb 6');
2588: trace('Custom Labels Trace [INVLAP5B.pls]: Before assigning it to l_content_item_data');

Line 3562: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;

3558: l_custom_sql_ret_msg := l_CustSqlWarnMsg;
3559: END IF;
3560:
3561: IF (l_CustSqlErrFlagSet) THEN
3562: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
3563: l_custom_sql_ret_msg := l_CustSqlErrMsg;
3564: END IF;
3565: -- Fix for bug: 4179593 End
3566:

Line 3785: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;

3781: l_custom_sql_ret_msg := l_CustSqlWarnMsg;
3782: END IF;
3783:
3784: IF (l_CustSqlErrFlagSet) THEN
3785: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
3786: l_custom_sql_ret_msg := l_CustSqlErrMsg;
3787: END IF;
3788: -- Fix for bug: 4179593 End
3789:

Line 3866: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;

3862: l_custom_sql_ret_msg := l_CustSqlWarnMsg;
3863: END IF;
3864:
3865: IF (l_CustSqlErrFlagSet) THEN
3866: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
3867: l_custom_sql_ret_msg := l_CustSqlErrMsg;
3868: END IF;
3869: -- Fix for bug: 4179593 End
3870: