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

1200: , p_organization_id => l_get_org_id);
1201:
1202: IF l_return_status <> 'S' THEN
1203: fnd_message.set_name('WMS', 'WMS_INSTALL_CHECK_INSTALL_FAILED');
1204: fnd_msg_pub.ADD;
1205: RETURN;
1206: END IF;
1207:
1208: IF (l_debug = 1) THEN

Line 1339: fnd_msg_pub.ADD;

1335: );
1336:
1337: IF l_return_status <> 'S' THEN
1338: fnd_message.set_name('WMS', 'WMS_GET_SER_CUR_FAILED');
1339: fnd_msg_pub.ADD;
1340: RETURN;
1341: END IF;
1342:
1343: IF (l_debug = 1) THEN

Line 1418: fnd_msg_pub.ADD;

1414: );
1415:
1416: IF l_return_status <> 'S' THEN
1417: fnd_message.set_name('WMS', 'WMS_GET_SER_CUR_FAILED');
1418: fnd_msg_pub.ADD;
1419: RETURN;
1420: END IF;
1421:
1422: IF (l_debug = 1) THEN

Line 1504: FND_MSG_PUB.ADD;

1500: , x_number_table => l_serial_numbers_table);
1501:
1502: IF l_return_status <> 'S' THEN
1503: FND_MESSAGE.SET_NAME('WMS', 'WMS_GET_SER_CUR_FAILED');
1504: FND_MSG_PUB.ADD;
1505: RETURN;
1506: END IF;
1507:
1508: IF (l_debug = 1) THEN

Line 1591: fnd_msg_pub.ADD;

1587: );
1588:
1589: IF l_return_status <> 'S' THEN
1590: fnd_message.set_name('WMS', 'WMS_GET_SER_CUR_FAILED');
1591: fnd_msg_pub.ADD;
1592: RETURN;
1593: END IF;
1594:
1595: TRACE(' Count of rows in l_serial_numbers_table ' || l_serial_numbers_table.COUNT);

Line 1637: fnd_msg_pub.ADD;

1633: );
1634:
1635: IF l_return_status <> 'S' THEN
1636: fnd_message.set_name('WMS', 'WMS_GET_SER_CUR_FAILED');
1637: fnd_msg_pub.ADD;
1638: RETURN;
1639: END IF;
1640:
1641: IF (l_debug = 1) THEN

Line 1680: fnd_msg_pub.ADD;

1676: );
1677:
1678: IF l_return_status <> 'S' THEN
1679: fnd_message.set_name('WMS', 'WMS_GET_SER_CUR_FAILED'); -- Code message for this.
1680: fnd_msg_pub.ADD;
1681: RETURN;
1682: END IF;
1683:
1684: IF (l_debug = 1) THEN

Line 1998: fnd_msg_pub.ADD;

1994: );
1995:
1996: IF l_return_status <> 'S' THEN
1997: fnd_message.set_name('WMS', 'WMS_LABL_RULE_ENGINE_FAILED');
1998: fnd_msg_pub.ADD;
1999: l_label_format_set_id := p_label_type_info.default_format_id;
2000: l_label_format := p_label_type_info.default_format_name;
2001: END IF;
2002:

Line 2079: fnd_msg_pub.ADD;

2075: );
2076:
2077: IF l_return_status <> 'S' THEN
2078: fnd_message.set_name('WMS', 'WMS_LABL_RULE_ENGINE_FAILED');
2079: fnd_msg_pub.ADD;
2080: l_label_format_id := p_label_type_info.default_format_id;
2081: l_label_format := p_label_type_info.default_format_name;
2082: END IF;
2083:

Line 2439: fnd_msg_pub.ADD;

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

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

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

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

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

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

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

3255: );
3256:
3257: IF l_return_status <> 'S' THEN
3258: fnd_message.set_name('WMS', 'WMS_GET_SER_CUR_FAILED'); -- Code message for this.
3259: fnd_msg_pub.ADD;
3260: RETURN;
3261: END IF;
3262:
3263: IF (l_debug = 1) THEN

Line 3317: FND_MSG_PUB.ADD;

3313: , x_number_table => l_serial_numbers_table);
3314:
3315: IF l_return_status <> 'S' THEN
3316: FND_MESSAGE.SET_NAME('WMS', 'WMS_GET_SER_CUR_FAILED');
3317: FND_MSG_PUB.ADD;
3318: RETURN;
3319: END IF;
3320: IF (l_debug = 1) THEN
3321: TRACE(' Number of SN in l_serial_numbers_table ' || l_serial_numbers_table.COUNT);

Line 3376: fnd_msg_pub.ADD;

3372: );
3373:
3374: IF l_return_status <> 'S' THEN
3375: fnd_message.set_name('WMS', 'WMS_GET_SER_CUR_FAILED'); -- Code message for this.
3376: fnd_msg_pub.ADD;
3377: RETURN;
3378: END IF;
3379:
3380: IF (l_debug = 1) THEN

Line 3530: fnd_msg_pub.ADD;

3526: );
3527:
3528: IF l_return_status <> 'S' THEN
3529: fnd_message.set_name('WMS', 'WMS_GET_SER_CUR_FAILED');
3530: fnd_msg_pub.ADD;
3531: RETURN;
3532: END IF;
3533:
3534: TRACE(' Count of rows in l_serial_numbers_table ' || l_serial_numbers_table.COUNT);

Line 3580: fnd_msg_pub.ADD;

3576: );
3577:
3578: IF l_return_status <> 'S' THEN
3579: fnd_message.set_name('WMS', 'WMS_GET_SER_CUR_FAILED'); -- Code message for this.
3580: fnd_msg_pub.ADD;
3581: RETURN;
3582: END IF;
3583:
3584: IF (l_debug = 1) THEN

Line 3627: fnd_msg_pub.ADD;

3623: );
3624:
3625: IF l_return_status <> 'S' THEN
3626: fnd_message.set_name('WMS', 'WMS_GET_SER_CUR_FAILED');
3627: fnd_msg_pub.ADD;
3628: RETURN;
3629: END IF;
3630:
3631: IF (l_debug = 1) THEN