674: );
675:
676: IF l_return_status <> 'S' THEN
677: fnd_message.set_name('WMS', 'WMS_LABL_RULE_ENGINE_FAILED');
678: fnd_msg_pub.ADD;
679: l_label_format := p_label_type_info.default_format_id;
680: l_label_format_id := p_label_type_info.default_format_name;
681: l_label_status := INV_LABEL.G_ERROR;
682: END IF;
804: IF (c_sql_stmt%rowcount=1 AND l_sql_stmt_result IS NULL) THEN
805: x_return_status := FND_API.G_RET_STS_SUCCESS;
806: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
807: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
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_CustSqlWarnMsg := l_custom_sql_ret_msg;
806: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
807: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
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_CustSqlWarnMsg := l_custom_sql_ret_msg;
813: l_CustSqlWarnFlagSet := TRUE;
814: -- Fix for bug: 4179593 End
807: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
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_CustSqlWarnMsg := l_custom_sql_ret_msg;
813: l_CustSqlWarnFlagSet := TRUE;
814: -- Fix for bug: 4179593 End
815: IF (l_debug = 1) THEN
825: END IF;
826: x_return_status := FND_API.G_RET_STS_SUCCESS;
827: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
828: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
829: fnd_msg_pub.ADD;
830: -- Fix for bug: 4179593 Start
831: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
832: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
833: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
827: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
828: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
829: fnd_msg_pub.ADD;
830: -- Fix for bug: 4179593 Start
831: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
832: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
833: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
834: l_CustSqlWarnFlagSet := TRUE;
835: -- Fix for bug: 4179593 End
828: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
829: fnd_msg_pub.ADD;
830: -- Fix for bug: 4179593 Start
831: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
832: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
833: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
834: l_CustSqlWarnFlagSet := TRUE;
835: -- Fix for bug: 4179593 End
836: ELSIF c_sql_stmt%rowcount>=2 THEN
841: l_sql_stmt_result := NULL;
842: x_return_status := FND_API.G_RET_STS_SUCCESS;
843: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
844: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
845: fnd_msg_pub.ADD;
846: -- Fix for bug: 4179593 Start
847: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
848: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
849: l_CustSqlErrMsg := l_custom_sql_ret_msg;
843: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
844: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
845: fnd_msg_pub.ADD;
846: -- Fix for bug: 4179593 Start
847: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
848: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
849: l_CustSqlErrMsg := l_custom_sql_ret_msg;
850: l_CustSqlErrFlagSet := TRUE;
851: -- Fix for bug: 4179593 End
844: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
845: fnd_msg_pub.ADD;
846: -- Fix for bug: 4179593 Start
847: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
848: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
849: l_CustSqlErrMsg := l_custom_sql_ret_msg;
850: l_CustSqlErrFlagSet := TRUE;
851: -- Fix for bug: 4179593 End
852: END IF;
863: trace('Custom Labels Trace [INVLA13B.pls]: Unexpected Error has occured in GET_VARIABLES_DATA');
864: END IF;
865: x_return_status := FND_API.G_RET_STS_ERROR;
866: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
867: fnd_msg_pub.ADD;
868: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
869: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
870: END;
871: IF (l_debug = 1) THEN
864: END IF;
865: x_return_status := FND_API.G_RET_STS_ERROR;
866: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
867: fnd_msg_pub.ADD;
868: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
869: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
870: END;
871: IF (l_debug = 1) THEN
872: trace('Custom Labels Trace [INVLA13B.pls]: At Breadcrumb 6');