636: );
637:
638: IF l_return_status <> 'S' THEN
639: fnd_message.set_name('WMS', 'WMS_LABL_RULE_ENGINE_FAILED');
640: fnd_msg_pub.ADD;
641: l_label_format := p_label_type_info.default_format_id;
642: l_label_format_id := p_label_type_info.default_format_name;
643: l_label_status := INV_LABEL.G_ERROR;
644: END IF;
767: IF (c_sql_stmt%rowcount=1 AND l_sql_stmt_result IS NULL) THEN
768: x_return_status := FND_API.G_RET_STS_SUCCESS;
769: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
770: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
771: fnd_msg_pub.ADD;
772: -- Fix for bug: 4179593 Start
773: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
774: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
775: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
769: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
770: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
771: fnd_msg_pub.ADD;
772: -- Fix for bug: 4179593 Start
773: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
774: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
775: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
776: l_CustSqlWarnFlagSet := TRUE;
777: -- Fix for bug: 4179593 End
770: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
771: fnd_msg_pub.ADD;
772: -- Fix for bug: 4179593 Start
773: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
774: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
775: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
776: l_CustSqlWarnFlagSet := TRUE;
777: -- Fix for bug: 4179593 End
778: IF (l_debug = 1) THEN
788: END IF;
789: x_return_status := FND_API.G_RET_STS_SUCCESS;
790: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
791: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
792: fnd_msg_pub.ADD;
793: -- Fix for bug: 4179593 Start
794: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
795: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
796: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
790: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
791: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
792: fnd_msg_pub.ADD;
793: -- Fix for bug: 4179593 Start
794: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
795: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
796: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
797: l_CustSqlWarnFlagSet := TRUE;
798: -- Fix for bug: 4179593 End
791: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
792: fnd_msg_pub.ADD;
793: -- Fix for bug: 4179593 Start
794: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
795: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
796: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
797: l_CustSqlWarnFlagSet := TRUE;
798: -- Fix for bug: 4179593 End
799: ELSIF c_sql_stmt%rowcount>=2 THEN
804: l_sql_stmt_result := NULL;
805: x_return_status := FND_API.G_RET_STS_SUCCESS;
806: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
807: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
808: fnd_msg_pub.ADD;
809: -- Fix for bug: 4179593 Start
810: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
811: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
812: l_CustSqlErrMsg := l_custom_sql_ret_msg;
806: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
807: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
808: fnd_msg_pub.ADD;
809: -- Fix for bug: 4179593 Start
810: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
811: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
812: l_CustSqlErrMsg := l_custom_sql_ret_msg;
813: l_CustSqlErrFlagSet := TRUE;
814: -- Fix for bug: 4179593 End
807: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
808: fnd_msg_pub.ADD;
809: -- Fix for bug: 4179593 Start
810: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
811: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
812: l_CustSqlErrMsg := l_custom_sql_ret_msg;
813: l_CustSqlErrFlagSet := TRUE;
814: -- Fix for bug: 4179593 End
815: END IF;
826: trace('Custom Labels Trace [INVLA11B.pls]: Unexpected Error has occured in GET_VARIABLES_DATA');
827: END IF;
828: x_return_status := FND_API.G_RET_STS_ERROR;
829: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
830: fnd_msg_pub.ADD;
831: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
833: END;
834: IF (l_debug = 1) THEN
827: END IF;
828: x_return_status := FND_API.G_RET_STS_ERROR;
829: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
830: fnd_msg_pub.ADD;
831: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
833: END;
834: IF (l_debug = 1) THEN
835: trace('Custom Labels Trace [INVLA11B.pls]: At Breadcrumb 6');