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

Line 639: fnd_msg_pub.ADD;

635: );
636:
637: IF l_return_status <> 'S' THEN
638: fnd_message.set_name('WMS', 'WMS_LABL_RULE_ENGINE_FAILED');
639: fnd_msg_pub.ADD;
640: l_label_format := p_label_type_info.default_format_id;
641: l_label_format_id := p_label_type_info.default_format_name;
642: l_label_status := INV_LABEL.G_ERROR;
643: END IF;

Line 770: fnd_msg_pub.ADD;

766: IF (c_sql_stmt%rowcount=1 AND l_sql_stmt_result IS NULL) THEN
767: x_return_status := FND_API.G_RET_STS_SUCCESS;
768: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
769: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
770: fnd_msg_pub.ADD;
771: -- Fix for bug: 4179593 Start
772: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
773: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
774: l_CustSqlWarnMsg := l_custom_sql_ret_msg;

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

768: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
769: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
770: fnd_msg_pub.ADD;
771: -- Fix for bug: 4179593 Start
772: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
773: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
774: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
775: l_CustSqlWarnFlagSet := TRUE;
776: -- Fix for bug: 4179593 End

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

769: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
770: fnd_msg_pub.ADD;
771: -- Fix for bug: 4179593 Start
772: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
773: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
774: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
775: l_CustSqlWarnFlagSet := TRUE;
776: -- Fix for bug: 4179593 End
777: IF (l_debug = 1) THEN

Line 791: fnd_msg_pub.ADD;

787: END IF;
788: x_return_status := FND_API.G_RET_STS_SUCCESS;
789: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
790: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
791: fnd_msg_pub.ADD;
792: -- Fix for bug: 4179593 Start
793: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
794: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
795: l_CustSqlWarnMsg := l_custom_sql_ret_msg;

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

789: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
790: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
791: fnd_msg_pub.ADD;
792: -- Fix for bug: 4179593 Start
793: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
794: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
795: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
796: l_CustSqlWarnFlagSet := TRUE;
797: -- Fix for bug: 4179593 End

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

790: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
791: fnd_msg_pub.ADD;
792: -- Fix for bug: 4179593 Start
793: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
794: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
795: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
796: l_CustSqlWarnFlagSet := TRUE;
797: -- Fix for bug: 4179593 End
798: ELSIF c_sql_stmt%rowcount>=2 THEN

Line 807: fnd_msg_pub.ADD;

803: l_sql_stmt_result := NULL;
804: x_return_status := FND_API.G_RET_STS_SUCCESS;
805: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
806: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
807: fnd_msg_pub.ADD;
808: -- Fix for bug: 4179593 Start
809: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
810: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
811: l_CustSqlErrMsg := l_custom_sql_ret_msg;

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

805: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
806: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
807: fnd_msg_pub.ADD;
808: -- Fix for bug: 4179593 Start
809: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
810: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
811: l_CustSqlErrMsg := l_custom_sql_ret_msg;
812: l_CustSqlErrFlagSet := TRUE;
813: -- Fix for bug: 4179593 End

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

806: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
807: fnd_msg_pub.ADD;
808: -- Fix for bug: 4179593 Start
809: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
810: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
811: l_CustSqlErrMsg := l_custom_sql_ret_msg;
812: l_CustSqlErrFlagSet := TRUE;
813: -- Fix for bug: 4179593 End
814: END IF;

Line 829: fnd_msg_pub.ADD;

825: trace('Custom Labels Trace [INVLA11B.pls]: Unexpected Error has occured in GET_VARIABLES_DATA');
826: END IF;
827: x_return_status := FND_API.G_RET_STS_ERROR;
828: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
829: fnd_msg_pub.ADD;
830: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
831: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
832: END;
833: IF (l_debug = 1) THEN

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

826: END IF;
827: x_return_status := FND_API.G_RET_STS_ERROR;
828: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
829: fnd_msg_pub.ADD;
830: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
831: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
832: END;
833: IF (l_debug = 1) THEN
834: trace('Custom Labels Trace [INVLA11B.pls]: At Breadcrumb 6');