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

Line 533: x_return_status := fnd_api.g_ret_sts_success;

529: l_label_formats_in_set NUMBER;
530:
531: BEGIN
532: -- Initialize return status as success
533: x_return_status := fnd_api.g_ret_sts_success;
534: l_debug := inv_label.l_debug;
535:
536: IF (l_debug = 1) THEN
537: TRACE('**In PVT3: LPN label**');

Line 1366: l_custom_sql_ret_status := FND_API.G_RET_STS_SUCCESS;

1362:
1363: l_column_name_list := 'Set variables for ';
1364:
1365: -- Fix for bug: 4179593 Start
1366: l_custom_sql_ret_status := FND_API.G_RET_STS_SUCCESS;
1367: l_CustSqlWarnFlagSet := FALSE;
1368: l_CustSqlErrFlagSet := FALSE;
1369: l_CustSqlWarnMsg := NULL;
1370: l_CustSqlErrMsg := NULL;

Line 1416: x_return_status := FND_API.G_RET_STS_SUCCESS;

1412: EXIT WHEN c_sql_stmt%notfound OR c_sql_stmt%rowcount >=2;
1413: END LOOP;
1414:
1415: IF (c_sql_stmt%rowcount=1 AND l_sql_stmt_result IS NULL) THEN
1416: x_return_status := FND_API.G_RET_STS_SUCCESS;
1417: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
1418: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
1419: fnd_msg_pub.ADD;
1420: -- Fix for bug: 4179593 Start

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

1417: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
1418: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
1419: fnd_msg_pub.ADD;
1420: -- Fix for bug: 4179593 Start
1421: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
1422: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
1423: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
1424: l_CustSqlWarnFlagSet := TRUE;
1425: -- Fix for bug: 4179593 End

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

1418: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
1419: fnd_msg_pub.ADD;
1420: -- Fix for bug: 4179593 Start
1421: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
1422: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
1423: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
1424: l_CustSqlWarnFlagSet := TRUE;
1425: -- Fix for bug: 4179593 End
1426: IF (l_debug = 1) THEN

Line 1437: x_return_status := FND_API.G_RET_STS_SUCCESS;

1433: IF (l_debug = 1) THEN
1434: trace('Custom Labels Trace [INVLAP3B.pls]: At Breadcrumb 3');
1435: trace('Custom Labels Trace [INVLAP3B.pls]: WARNING: No row returned by the Custom SQL query');
1436: END IF;
1437: x_return_status := FND_API.G_RET_STS_SUCCESS;
1438: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
1439: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
1440: fnd_msg_pub.ADD;
1441: -- Fix for bug: 4179593 Start

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

1438: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
1439: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
1440: fnd_msg_pub.ADD;
1441: -- Fix for bug: 4179593 Start
1442: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
1443: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
1444: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
1445: l_CustSqlWarnFlagSet := TRUE;
1446: -- Fix for bug: 4179593 End

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

1439: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
1440: fnd_msg_pub.ADD;
1441: -- Fix for bug: 4179593 Start
1442: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
1443: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
1444: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
1445: l_CustSqlWarnFlagSet := TRUE;
1446: -- Fix for bug: 4179593 End
1447: ELSIF c_sql_stmt%rowcount>=2 THEN

Line 1453: x_return_status := FND_API.G_RET_STS_SUCCESS;

1449: trace('Custom Labels Trace [INVLAP3B.pls]: At Breadcrumb 4');
1450: trace('Custom Labels Trace [INVLAP3B.pls]: ERROR: Multiple values returned by the Custom SQL query');
1451: END IF;
1452: l_sql_stmt_result := NULL;
1453: x_return_status := FND_API.G_RET_STS_SUCCESS;
1454: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
1455: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
1456: fnd_msg_pub.ADD;
1457: -- Fix for bug: 4179593 Start

Line 1454: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;

1450: trace('Custom Labels Trace [INVLAP3B.pls]: ERROR: Multiple values returned by the Custom SQL query');
1451: END IF;
1452: l_sql_stmt_result := NULL;
1453: x_return_status := FND_API.G_RET_STS_SUCCESS;
1454: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
1455: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
1456: fnd_msg_pub.ADD;
1457: -- Fix for bug: 4179593 Start
1458: --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 1458: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);

1454: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
1455: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
1456: fnd_msg_pub.ADD;
1457: -- Fix for bug: 4179593 Start
1458: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
1459: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
1460: l_CustSqlErrMsg := l_custom_sql_ret_msg;
1461: l_CustSqlErrFlagSet := TRUE;
1462: -- Fix for bug: 4179593 End

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

1455: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
1456: fnd_msg_pub.ADD;
1457: -- Fix for bug: 4179593 Start
1458: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
1459: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
1460: l_CustSqlErrMsg := l_custom_sql_ret_msg;
1461: l_CustSqlErrFlagSet := TRUE;
1462: -- Fix for bug: 4179593 End
1463: END IF;

Line 1476: x_return_status := FND_API.G_RET_STS_ERROR;

1472: IF (l_debug = 1) THEN
1473: trace('Custom Labels Trace [INVLAP3B.pls]: At Breadcrumb 5');
1474: trace('Custom Labels Trace [INVLAP3B.pls]: Unexpected Error has occured in GET_VARIABLES_DATA');
1475: END IF;
1476: x_return_status := FND_API.G_RET_STS_ERROR;
1477: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
1478: fnd_msg_pub.ADD;
1479: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1475: END IF;
1476: x_return_status := FND_API.G_RET_STS_ERROR;
1477: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
1478: fnd_msg_pub.ADD;
1479: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1481: END;
1482: IF (l_debug = 1) THEN
1483: trace('Custom Labels Trace [INVLAP3B.pls]: At Breadcrumb 6');

Line 1480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1476: x_return_status := FND_API.G_RET_STS_ERROR;
1477: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
1478: fnd_msg_pub.ADD;
1479: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1481: END;
1482: IF (l_debug = 1) THEN
1483: trace('Custom Labels Trace [INVLAP3B.pls]: At Breadcrumb 6');
1484: trace('Custom Labels Trace [INVLAP3B.pls]: Before assigning it to l_content_item_data');

Line 1869: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;

1865: l_custom_sql_ret_msg := l_CustSqlWarnMsg;
1866: END IF;
1867:
1868: IF (l_CustSqlErrFlagSet) THEN
1869: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
1870: l_custom_sql_ret_msg := l_CustSqlErrMsg;
1871: END IF;
1872: -- Fix for bug: 4179593 End
1873: