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_MSG_PUB

Line 1197: fnd_msg_pub.ADD;

1193: , p_organization_id => l_get_org_id);
1194:
1195: IF l_return_status <> 'S' THEN
1196: fnd_message.set_name('WMS', 'WMS_INSTALL_CHECK_INSTALL_FAILED');
1197: fnd_msg_pub.ADD;
1198: RETURN;
1199: END IF;
1200:
1201: IF (l_debug = 1) THEN

Line 1332: fnd_msg_pub.ADD;

1328: );
1329:
1330: IF l_return_status <> 'S' THEN
1331: fnd_message.set_name('WMS', 'WMS_GET_SER_CUR_FAILED');
1332: fnd_msg_pub.ADD;
1333: RETURN;
1334: END IF;
1335:
1336: IF (l_debug = 1) THEN

Line 1411: fnd_msg_pub.ADD;

1407: );
1408:
1409: IF l_return_status <> 'S' THEN
1410: fnd_message.set_name('WMS', 'WMS_GET_SER_CUR_FAILED');
1411: fnd_msg_pub.ADD;
1412: RETURN;
1413: END IF;
1414:
1415: IF (l_debug = 1) THEN

Line 1497: FND_MSG_PUB.ADD;

1493: , x_number_table => l_serial_numbers_table);
1494:
1495: IF l_return_status <> 'S' THEN
1496: FND_MESSAGE.SET_NAME('WMS', 'WMS_GET_SER_CUR_FAILED');
1497: FND_MSG_PUB.ADD;
1498: RETURN;
1499: END IF;
1500:
1501: IF (l_debug = 1) THEN

Line 1584: fnd_msg_pub.ADD;

1580: );
1581:
1582: IF l_return_status <> 'S' THEN
1583: fnd_message.set_name('WMS', 'WMS_GET_SER_CUR_FAILED');
1584: fnd_msg_pub.ADD;
1585: RETURN;
1586: END IF;
1587:
1588: TRACE(' Count of rows in l_serial_numbers_table ' || l_serial_numbers_table.COUNT);

Line 1630: fnd_msg_pub.ADD;

1626: );
1627:
1628: IF l_return_status <> 'S' THEN
1629: fnd_message.set_name('WMS', 'WMS_GET_SER_CUR_FAILED');
1630: fnd_msg_pub.ADD;
1631: RETURN;
1632: END IF;
1633:
1634: IF (l_debug = 1) THEN

Line 1673: fnd_msg_pub.ADD;

1669: );
1670:
1671: IF l_return_status <> 'S' THEN
1672: fnd_message.set_name('WMS', 'WMS_GET_SER_CUR_FAILED'); -- Code message for this.
1673: fnd_msg_pub.ADD;
1674: RETURN;
1675: END IF;
1676:
1677: IF (l_debug = 1) THEN

Line 1975: fnd_msg_pub.ADD;

1971: );
1972:
1973: IF l_return_status <> 'S' THEN
1974: fnd_message.set_name('WMS', 'WMS_LABL_RULE_ENGINE_FAILED');
1975: fnd_msg_pub.ADD;
1976: l_label_format_set_id := p_label_type_info.default_format_id;
1977: l_label_format := p_label_type_info.default_format_name;
1978: END IF;
1979:

Line 2056: fnd_msg_pub.ADD;

2052: );
2053:
2054: IF l_return_status <> 'S' THEN
2055: fnd_message.set_name('WMS', 'WMS_LABL_RULE_ENGINE_FAILED');
2056: fnd_msg_pub.ADD;
2057: l_label_format_id := p_label_type_info.default_format_id;
2058: l_label_format := p_label_type_info.default_format_name;
2059: END IF;
2060:

Line 2417: fnd_msg_pub.ADD;

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
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;

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 2439: fnd_msg_pub.ADD;

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
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;

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 2455: fnd_msg_pub.ADD;

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);
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;

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 2477: fnd_msg_pub.ADD;

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;
2480: END;
2481: IF (l_debug = 1) THEN

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 3235: fnd_msg_pub.ADD;

3231: );
3232:
3233: IF l_return_status <> 'S' THEN
3234: fnd_message.set_name('WMS', 'WMS_GET_SER_CUR_FAILED'); -- Code message for this.
3235: fnd_msg_pub.ADD;
3236: RETURN;
3237: END IF;
3238:
3239: IF (l_debug = 1) THEN

Line 3293: FND_MSG_PUB.ADD;

3289: , x_number_table => l_serial_numbers_table);
3290:
3291: IF l_return_status <> 'S' THEN
3292: FND_MESSAGE.SET_NAME('WMS', 'WMS_GET_SER_CUR_FAILED');
3293: FND_MSG_PUB.ADD;
3294: RETURN;
3295: END IF;
3296: IF (l_debug = 1) THEN
3297: TRACE(' Number of SN in l_serial_numbers_table ' || l_serial_numbers_table.COUNT);

Line 3352: fnd_msg_pub.ADD;

3348: );
3349:
3350: IF l_return_status <> 'S' THEN
3351: fnd_message.set_name('WMS', 'WMS_GET_SER_CUR_FAILED'); -- Code message for this.
3352: fnd_msg_pub.ADD;
3353: RETURN;
3354: END IF;
3355:
3356: IF (l_debug = 1) THEN

Line 3490: fnd_msg_pub.ADD;

3486: );
3487:
3488: IF l_return_status <> 'S' THEN
3489: fnd_message.set_name('WMS', 'WMS_GET_SER_CUR_FAILED');
3490: fnd_msg_pub.ADD;
3491: RETURN;
3492: END IF;
3493:
3494: TRACE(' Count of rows in l_serial_numbers_table ' || l_serial_numbers_table.COUNT);

Line 3540: fnd_msg_pub.ADD;

3536: );
3537:
3538: IF l_return_status <> 'S' THEN
3539: fnd_message.set_name('WMS', 'WMS_GET_SER_CUR_FAILED'); -- Code message for this.
3540: fnd_msg_pub.ADD;
3541: RETURN;
3542: END IF;
3543:
3544: IF (l_debug = 1) THEN

Line 3587: fnd_msg_pub.ADD;

3583: );
3584:
3585: IF l_return_status <> 'S' THEN
3586: fnd_message.set_name('WMS', 'WMS_GET_SER_CUR_FAILED');
3587: fnd_msg_pub.ADD;
3588: RETURN;
3589: END IF;
3590:
3591: IF (l_debug = 1) THEN