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_PVT15 dependencies on FND_MSG_PUB

Line 365: fnd_msg_pub.ADD;

361: );
362:
363: IF l_return_status <> 'S' THEN
364: fnd_message.set_name('WMS', 'WMS_LABL_RULE_ENGINE_FAILED');
365: fnd_msg_pub.ADD;
366: l_label_format := p_label_type_info.default_format_id;
367: l_label_format_id := p_label_type_info.default_format_name;
368: l_label_status := INV_LABEL.G_ERROR;
369: END IF;

Line 495: fnd_msg_pub.ADD;

491: IF (c_sql_stmt%rowcount=1 AND l_sql_stmt_result IS NULL) THEN
492: x_return_status := FND_API.G_RET_STS_SUCCESS;
493: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
494: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
495: fnd_msg_pub.ADD;
496: -- Fix for bug: 4179593 Start
497: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
498: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
499: l_CustSqlWarnMsg := l_custom_sql_ret_msg;

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

493: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
494: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
495: fnd_msg_pub.ADD;
496: -- Fix for bug: 4179593 Start
497: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
498: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
499: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
500: l_CustSqlWarnFlagSet := TRUE;
501: -- Fix for bug: 4179593 End

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

494: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
495: fnd_msg_pub.ADD;
496: -- Fix for bug: 4179593 Start
497: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
498: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
499: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
500: l_CustSqlWarnFlagSet := TRUE;
501: -- Fix for bug: 4179593 End
502: IF (l_debug = 1) THEN

Line 516: fnd_msg_pub.ADD;

512: END IF;
513: x_return_status := FND_API.G_RET_STS_SUCCESS;
514: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
515: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
516: fnd_msg_pub.ADD;
517: -- Fix for bug: 4179593 Start
518: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
519: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
520: l_CustSqlWarnMsg := l_custom_sql_ret_msg;

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

514: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
515: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
516: fnd_msg_pub.ADD;
517: -- Fix for bug: 4179593 Start
518: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
519: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
520: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
521: l_CustSqlWarnFlagSet := TRUE;
522: -- Fix for bug: 4179593 End

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

515: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
516: fnd_msg_pub.ADD;
517: -- Fix for bug: 4179593 Start
518: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
519: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
520: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
521: l_CustSqlWarnFlagSet := TRUE;
522: -- Fix for bug: 4179593 End
523: ELSIF c_sql_stmt%rowcount>=2 THEN

Line 532: fnd_msg_pub.ADD;

528: l_sql_stmt_result := NULL;
529: x_return_status := FND_API.G_RET_STS_SUCCESS;
530: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
531: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
532: fnd_msg_pub.ADD;
533: -- Fix for bug: 4179593 Start
534: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
535: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
536: l_CustSqlErrMsg := l_custom_sql_ret_msg;

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

530: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
531: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
532: fnd_msg_pub.ADD;
533: -- Fix for bug: 4179593 Start
534: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
535: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
536: l_CustSqlErrMsg := l_custom_sql_ret_msg;
537: l_CustSqlErrFlagSet := TRUE;
538: -- Fix for bug: 4179593 End

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

531: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
532: fnd_msg_pub.ADD;
533: -- Fix for bug: 4179593 Start
534: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
535: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
536: l_CustSqlErrMsg := l_custom_sql_ret_msg;
537: l_CustSqlErrFlagSet := TRUE;
538: -- Fix for bug: 4179593 End
539: END IF;

Line 554: fnd_msg_pub.ADD;

550: trace('Custom Labels Trace [INVLA15B.pls]: Unexpected Error has occured in GET_VARIABLES_DATA');
551: END IF;
552: x_return_status := FND_API.G_RET_STS_ERROR;
553: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
554: fnd_msg_pub.ADD;
555: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
557: END;
558: IF (l_debug = 1) THEN

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

551: END IF;
552: x_return_status := FND_API.G_RET_STS_ERROR;
553: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
554: fnd_msg_pub.ADD;
555: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
557: END;
558: IF (l_debug = 1) THEN
559: trace('Custom Labels Trace [INVLA15B.pls]: At Breadcrumb 6');